PAFOLLOWUP – Employee Incident Follow Up

System: Personnel (PA)
Prefix: PAF
Primary key: COMPANY, EMPLOYEE, ESTABLISHMENT, INCIDENT-NBR, SEQ-NBR
Fields: 15
Updated by: 10 programs
Referenced by: 0 programs

PAFOLLOWUP is the Employee Incident Follow Up table in Lawson Personnel (prefix PAF). It is indexed by COMPANY, EMPLOYEE, ESTABLISHMENT, INCIDENT-NBR, SEQ-NBR (PAFSET1); alternate indexes: PAFSET2. It is related 1:1 to PRSYSTEM, EMPLOYEE, OSHESTAB, PCODES, OSHA and PAEMPLOYEE. It is updated by HR00.1, HR01.1, HR11.1, PA115, PA290, PA372, PA490, PA590 and 2 more. The table has 15 fields, 2 indexes and 10 documented relations.

About PAFOLLOWUP

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the PAF- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PAF-COMPANY` PK COMPANY	Numeric 4	—	PA590, PA90.2
`PAF-EMPLOYEE` PK 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` PK ESTABLISHMENT	Alpha 10	Contains the establishment where the incident took place.	PA590, PA90.2
`PAF-INCIDENT-NBR` PK INCIDENT_NBR	Numeric 4	Contains the incident report number.	PA590, PA90.2
`PAF-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	PA590, PA90.2
`PAF-EFFECT-DATE` EFFECT_DATE	Numeric 8 (yyyymmdd)	Contains the date for the follow up information.	PA590, PA90.2
`PAF-FOLLOW-STAT` FOLLOW_STAT	Alpha 10	Contains the user-defined incident follow up status.	PA590, PA90.2
`PAF-FOLLOW-CAT` FOLLOW_CAT	Alpha 10	Contains the user-defined incident follow-up category.	PA590, PA90.2
`PAF-FOLLOW-TYPE` FOLLOW_TYPE	Alpha 10	Contains the user-defined incident follow up type.	PA590, PA90.2
`PAF-OUTCOME` OUTCOME	Alpha 10	Contains the user-defined incident outcome.	PA590, PA90.2
`PAF-PERFORMED-BY` PERFORMED_BY	Numeric 9	Contains the employee who performed the incident follow up.	PA590, PA90.2
`PAF-COMMENT` COMMENT	Alpha 40 (Lower Case)	Contains comments about the incident follow up.	PA590, PA90.2
`PAF-DATE-STAMP` 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` 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` USER_ID	Alpha 10 (Lower Case)	—	PA590, PA90.2

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PAFSET1`	`COMPANY`, `EMPLOYEE`, `ESTABLISHMENT`, `INCIDENT-NBR`, `SEQ-NBR`	Primary		HR00.1, HR01.1, HR11.1, PA115, PA290, PA372, PA490, PA590 +2 more
`PAFSET2`	`COMPANY`, `EMPLOYEE`, `ESTABLISHMENT`, `INCIDENT-NBR`, `EFFECT-DATE`, `SEQ-NBR*`	KeyChange		PA290, PA90.2

Relations

One to one (10) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (10)

HR00.1 Company
HR01.1 Process Level
HR11.1 Employee
PA115 Employee Purge
PA290 Health and Safety Incident Listing
PA372 Health and Safety Incident Purge
PA490 OSHA Log, Summary Report
PA590 Health and Safety Incident Conversion
PA90.1 Health and Safety Incident
PA90.2 Incident Follow Up