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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PAF-COMPANY PK
COMPANY		Numeric 4—PA590, PA90.2
#PAF-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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 10Contains the establishment where the incident took place.PA590, PA90.2
#PAF-INCIDENT-NBR PK
INCIDENT_NBR		Numeric 4Contains the incident report number.PA590, PA90.2
#PAF-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.PA590, PA90.2
#PAF-EFFECT-DATE SET2
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the date for the follow up information.PA590, PA90.2
#PAF-FOLLOW-STAT
FOLLOW_STAT		Alpha 10Contains the user-defined incident follow up status.PA590, PA90.2
#PAF-FOLLOW-CAT
FOLLOW_CAT		Alpha 10Contains the user-defined incident follow-up category.PA590, PA90.2
#PAF-FOLLOW-TYPE
FOLLOW_TYPE		Alpha 10Contains the user-defined incident follow up type.PA590, PA90.2
#PAF-OUTCOME
OUTCOME		Alpha 10Contains the user-defined incident outcome.PA590, PA90.2
#PAF-PERFORMED-BY
PERFORMED_BY		Numeric 9Contains 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PAFSET1
  1. COMPANY
  2. EMPLOYEE
  3. ESTABLISHMENT
  4. INCIDENT-NBR
  5. SEQ-NBR
PrimaryHR00.1, HR01.1, HR11.1, PA115, PA290, PA372, PA490, PA590 +2 more
PAFSET2
  1. COMPANY
  2. EMPLOYEE
  3. ESTABLISHMENT
  4. INCIDENT-NBR ↓
  5. EFFECT-DATE ↓
  6. SEQ-NBR ↓
KeyChangePA290, PA90.2

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMEMPLOYEEOSHESTABPCODESOSHAPAEMPLOYEEPAFOLLOWUP

One to one (10) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PAF-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PAF-COMPANY→EMP-COMPANY
PAF-EMPLOYEE→EMP-EMPLOYEE
EstablishmentOSHESTABRequiredWhen (PAF-ESTABLISHMENT != Spaces)
PAF-COMPANY→OTB-COMPANY
PAF-ESTABLISHMENT→OTB-ESTABLISHMENT
Follow OutcomePCODESRequiredWhen (PAF-OUTCOME != Spaces)
"FO"→PCO-TYPE
PAF-OUTCOME→PCO-CODE
Follow Up CatPCODESRequiredWhen (PAF-FOLLOW-CAT != Spaces)
"FA"→PCO-TYPE
PAF-FOLLOW-STAT→PCO-CODE
Follow Up StatPCODESRequiredWhen (PAF-FOLLOW-STAT != Spaces)
"FS"→PCO-TYPE
PAF-FOLLOW-STAT→PCO-CODE
Follow Up TypePCODESRequiredWhen (PAF-FOLLOW-TYPE != Spaces)
"FT"→PCO-TYPE
PAF-FOLLOW-TYPE→PCO-CODE
IncidentOSHARequired
PAF-COMPANY→OSH-COMPANY
PAF-EMPLOYEE→OSH-EMPLOYEE
PAF-ESTABLISHMENT→OSH-ESTABLISHMENT
PAF-INCIDENT-NBR→OSH-SEQ-NBR
PaemployeePAEMPLOYEERequired
PAF-COMPANY→PEM-COMPANY
PAF-EMPLOYEE→PEM-EMPLOYEE
Performed ByEMPLOYEERequiredWhen (PAF-PERFORMED-BY != Zeroes)
PAF-COMPANY→EMP-COMPANY
PAF-PERFORMED-BY→EMP-EMPLOYEE

Programs

Updated by (10)