|
|
PAFOLLOWUP FILE
Contains employee test follow up information. This file is maintained
primarily by PA90.2 (Incident Follow Up).
UPDATED BY
PA290 PA372 PA490 PA590 PA90.1 PA90.2
HR00.1 HR01.1 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAF-COMPANY Numeric 4 PA590 PA90.2
Element: Company Hr
PAF-EMPLOYEE Numeric 9 PA590 PA90.2
Element: Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PAF-ESTABLISHMENT Alpha 10 PA590 PA90.2
Element: Establishment Contains the establishment where the
incident took place.
PAF-INCIDENT-NBR Numeric 4 PA590 PA90.2
Element: Incident Nbr Contains the incident report number.
PAF-SEQ-NBR Numeric 4 PA590 PA90.2
Element: Seq Nbr An automatically assigned sequence
number.
PAF-EFFECT-DATE Numeric 8 (yyyymmdd) PA590 PA90.2
Element: Effect Date Contains the date for the follow up
information.
PAF-FOLLOW-STAT Alpha 10 PA590 PA90.2
Element: Follow Stat Contains the user-defined incident
follow up status.
PAF-FOLLOW-CAT Alpha 10 PA590 PA90.2
Element: Follow Cat Contains the user-defined incident
follow-up category.
PAF-FOLLOW-TYPE Alpha 10 PA590 PA90.2
Element: Follow Type Contains the user-defined incident
follow up type.
PAF-OUTCOME Alpha 10 PA590 PA90.2
Element: Outcome Contains the user-defined incident
outcome.
PAF-PERFORMED-BY Numeric 9 PA590 PA90.2
Element: Performed By Contains the employee who performed the
incident follow up.
PAF-COMMENT Alpha 40 (Lower Case) PA590 PA90.2
Element: Comment Contains comments about the incident
follow up.
PAF-DATE-STAMP Numeric 8 (yyyymmdd) PA590 PA90.2
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PAF-TIME-STAMP Numeric 6 (hhmmss) PA590 PA90.2
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PAF-USER-ID Alpha 10 (Lower Case) PA590 PA90.2
Element: User
PAFOLLOWUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAFSET1 COMPANY HR00.1 HR01.1
EMPLOYEE HR11.1 PA115
ESTABLISHMENT PA290 PA372
INCIDENT-NBR PA490 PA590
SEQ-NBR PA90.1 PA90.2
PAFSET2 COMPANY KeyChange PA290 PA90.2
EMPLOYEE
ESTABLISHMENT
INCIDENT-NBR*
EFFECT-DATE*
SEQ-NBR*
PAFOLLOWUP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PAF-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
PAF-COMPANY -> EMP-COMPANY
PAF-EMPLOYEE -> EMP-EMPLOYEE
Establishment OSHESTAB Required
When (PAF-ESTABLISHMENT != Spaces )
PAF-COMPANY -> OTB-COMPANY
PAF-ESTABLISHMENT -> OTB-ESTABLISHMENT
Follow Outcome PCODES Required
When (PAF-OUTCOME != Spaces )
"FO" -> PCO-TYPE
PAF-OUTCOME -> PCO-CODE
Follow Up Cat PCODES Required
When (PAF-FOLLOW-CAT != Spaces )
"FA" -> PCO-TYPE
PAF-FOLLOW-STAT -> PCO-CODE
Follow Up Stat PCODES Required
When (PAF-FOLLOW-STAT != Spaces )
"FS" -> PCO-TYPE
PAF-FOLLOW-STAT -> PCO-CODE
Follow Up Type PCODES Required
When (PAF-FOLLOW-TYPE != Spaces )
"FT" -> PCO-TYPE
PAF-FOLLOW-TYPE -> PCO-CODE
Incident OSHA Required
PAF-COMPANY -> OSH-COMPANY
PAF-EMPLOYEE -> OSH-EMPLOYEE
PAF-ESTABLISHMENT -> OSH-ESTABLISHMENT
PAF-INCIDENT-NBR -> OSH-SEQ-NBR
Paemployee PAEMPLOYEE Required
PAF-COMPANY -> PEM-COMPANY
PAF-EMPLOYEE -> PEM-EMPLOYEE
Performed By EMPLOYEE Required
When (PAF-PERFORMED-BY != Zeroes )
PAF-COMPANY -> EMP-COMPANY
PAF-PERFORMED-BY -> EMP-EMPLOYEE
|
