PAFOLLOWUP

Contains employee test follow up information. This file is maintained primarily by PA90.2 (Incident Follow Up).
UPDATED BY
HR00.1 HR01.1 HR11.1 PA115 PA290 PA372
PA490 PA590 PA90.1 PA90.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAF-COMPANY
Element: Company Hr
Numeric 4
PA590 PA90.2
PAF-EMPLOYEE
Element: Employee
Numeric 9
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.
PA590 PA90.2
PAF-ESTABLISHMENT
Element: Establishment
Alpha 10
Contains the establishment where the incident took place.
PA590 PA90.2
PAF-INCIDENT-NBR
Element: Incident Nbr
Numeric 4
Contains the incident report number.
PA590 PA90.2
PAF-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
PA590 PA90.2
PAF-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the date for the follow up information.
PA590 PA90.2
PAF-FOLLOW-STAT
Element: Follow Stat
Alpha 10
Contains the user-defined incident follow up status.
PA590 PA90.2
PAF-FOLLOW-CAT
Element: Follow Cat
Alpha 10
Contains the user-defined incident follow-up category.
PA590 PA90.2
PAF-FOLLOW-TYPE
Element: Follow Type
Alpha 10
Contains the user-defined incident follow up type.
PA590 PA90.2
PAF-OUTCOME
Element: Outcome
Alpha 10
Contains the user-defined incident outcome.
PA590 PA90.2
PAF-PERFORMED-BY
Element: Performed By
Numeric 9
Contains the employee who performed the incident follow up.
PA590 PA90.2
PAF-COMMENT
Element: Comment
Alpha 40 (Lower Case)
Contains comments about the incident follow up.
PA590 PA90.2
PAF-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
PA590 PA90.2
PAF-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PA590 PA90.2
PAF-USER-ID
Element: User
Alpha 10 (Lower Case)
PA590 PA90.2


PAFOLLOWUP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAFSET1 COMPANY
EMPLOYEE
ESTABLISHMENT
INCIDENT-NBR
SEQ-NBR
HR00.1 HR01.1
HR11.1 PA115
PA290 PA372
PA490 PA590
PA90.1 PA90.2
PAFSET2 COMPANY
EMPLOYEE
ESTABLISHMENT
INCIDENT-NBR*
EFFECT-DATE*
SEQ-NBR*
KeyChange
PA290 PA90.2


PAFOLLOWUP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:22:13 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.