PAFOLLOWUP

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
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: Wed Jun 08 20:50:24 2016

Home
Contact Us



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