Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAFOLLOWUP


                            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