|
|
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
HR11.1 PA115 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAF-COMPANY Numeric 4 PA590 PA90.2
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
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: Sequence NumbeAn automatically assigned sequence
number.
PAF-EFFECT-DATE Numeric 8 (yyyymmdd) PA590 PA90.2
Element: Effective DateContains 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 Line 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 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 HR11.1 PA115
ESTABLISHMENT PA372 PA590
INCIDENT-NBR PA90.1 PA90.2
SEQ-NBR PBIP.1 PR197
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
|
