PAFOLLOWUP FILE
Contains employee test follow up information. This file is maintained
primarily by PA90.2 (Incident Follow Up).
REFERENCED BY
PA290
UPDATED BY
PA372 PA590 PA90.1 PA90.2 HR00.1 HR01.1
PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAF-COMPANY Numeric 4 PA590 PA90.2
Company The company number represents an
established company and is entered on
all function codes.
PAF-EMPLOYEE Numeric 9 PA590 PA90.2
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
Establishment Contains the establishment where the
incident took place.
PAF-INCIDENT-NBR Numeric 4 PA590 PA90.2
Incident Nbr Contains the incident report number.
PAF-SEQ-NBR Numeric 4 PA590 PA90.2
Sequence Number An automatically assigned sequence
number.
PAF-EFFECT-DATE Numeric 8 (yyyymmdd) PA590 PA90.2
Effective Date Contains the date for the follow up
information.
PAF-FOLLOW-STAT Alpha 10 PA590 PA90.2
Follow Stat Contains the user-defined incident
follow up status.
PAF-FOLLOW-CAT Alpha 10 PA590 PA90.2
Follow Cat Contains the user-defined incident
follow-up category.
PAF-FOLLOW-TYPE Alpha 10 PA590 PA90.2
Follow Type Contains the user-defined incident
follow up type.
PAF-OUTCOME Alpha 10 PA590 PA90.2
Outcome Contains the user-defined incident
outcome.
PAF-PERFORMED-BY Numeric 9 PA590 PA90.2
Performed By Contains the employee who performed the
incident follow up.
PAF-COMMENT Alpha 40 (Lower Case) PA590 PA90.2
Comment Line Contains comments about the incident
follow up.
PAF-DATE-STAMP Numeric 8 (yyyymmdd) PA590 PA90.2
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
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
User ID Name Contains the user ID of the person who
last changed this record.
PAFOLLOWUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAFSET1 COMPANY HR00.1 HR01.1
EMPLOYEE PA372 PA590
ESTABLISHMENT PA90.1 PA90.2
INCIDENT-NBR PR197
SEQ-NBR
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 PCODES Required
When (PAF-ESTABLISHMENT != Spaces )
"ET" -> PCO-TYPE
PAF-ESTABLISHMENT -> PCO-CODE
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
Performed By EMPLOYEE Required
When (PAF-PERFORMED-BY != Zeroes )
PAF-COMPANY -> EMP-COMPANY
PAF-PERFORMED-BY -> EMP-EMPLOYEE
|
