Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PERSACTHST


                            PERSACTHST FILE

                        Personnel Action History

Contains a history log of personnel action changes.

REFERENCED BY

HCHP.1    PA213     PA311     PA340     PA370     PA594
PA66.3    PA66.1    PA66.4    PA66.2    BN100     BN35.1
HR170     HR70.1    PA105     PA223     PA534     PA55.1
PA56.1    PA67.1    PR282     UK110     PA341     PA355
PA149

UPDATED BY

HAP3.1    HEP4.1    HPOS.1    HPQC.1    HPRS.1    HR11.1
HR11.2    HR15.1    HR511     HR515     HR521     HR54.1
HRS1.1    HRSC.1    PA02.1    PA100     PA102     PA113
PA125     PA13.1    PA13.2    PA502     PA513     PA52.1
PA52.3    PA52.4    PA52.5    PA54.1    PR110     PR113
PR120     PR13.1    PR13.5    PR13.6    PR13.8    PRSC.1
PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PAH-COMPANY            Numeric 4                                 HR11.2  HR511
Element: Company Hr    Identifies the AP company if the          HR521   PA02.1
                       resource type = V.  Identifies the HR     PA100   PA102
                       company if the resource type = E.  It is  PA13.1  PA13.2
                       blank for type A, P or Q resources.       PA502   PA513
                                                                 PA52.1  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110

PAH-ACTION-CODE        Alpha 10                                  HR11.2  HR511
Element: Action Code   This field contains the personnel         HR521   PA02.1
                       action code.                              PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110

PAH-EFFECT-DATE        Numeric 8  (yyyymmdd)                     HR11.2  HR511
Element: Effective DateContains the date the action takes        HR521   PA02.1
                       effect.                                   PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110

PAH-ACTION-NBR         Numeric 4                                 HR11.2  HR511
Element: Action Number Contains the last action number used      HR521   PA02.1
                       for personnel actions. Taken from the     PA100   PA102
                       Personnel Action Code file.               PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110

PAH-EMPLOYEE           Numeric 9                                 HR11.2  HR511
Element: Employee      Contains the employee number.             HR521   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110

PAH-ANT-END-DATE       Numeric 8  (yyyymmdd)                     HR11.2  HR511
Anticipated Ending     Contains the anticipated ending date      HR521   PA02.1
Date                   for the action.                           PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110

PAH-REASON             Alpha 10 Occurs 2 Times                   HR11.2  HR511
Element: Reason        Contains the reason for the action.       HR521   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA340   PA502
                                                                 PA513   PA52.1
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110

PAH-USER-ID            Alpha 10  (Lower Case)                    HR11.2  HR511
Element: User          Contains the User Id for the individual   HR521   PA02.1
                       making the change.                        PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110

PAH-DATE-STAMP         Numeric 8  (yyyymmdd)                     HR11.2  HR511
Element: Date Stamp    Contains the system date for the action.  HR521   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110

PAH-ACTION-TYPE        Alpha 1                                   HR11.2  HR511
Element: Action Type   This field contains the action type.      HR521   PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110

PAH-OBJ-ID             Numeric 12                                HR11.2  HR511
Object                 Contains a system-assigned identifier     HR521   PA02.1
Identification         that provides access to data in related   PA100   PA102
                       files.                                    PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PR110

PAH-REASON1            Derived
Element: Reason1

PAH-REASON2            Derived
Element: Reason2

PAH-ERROR-FLAG         Alpha 1                                   HAP3.1  HEP4.1
Element: Error Flag    Indicates if History Errors exist for     HPOS.1  HPQC.1
                       this Action History record.               HPRS.1  HR11.1
                       0 = No HER records                        HR11.2  HR15.1
                       1 = Some HER records                      HR511   HR515
                       2 = Only HER records                      HR54.1  HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA125
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 PRSC.1

                         PERSACTHST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PAHSET1   COMPANY                                                HCHP.1  HR11.1
          EMPLOYEE                                               PA100   PA115
          EFFECT-DATE                                            PA125   PA213
          ACTION-CODE                                            PA311   PA340
          ACTION-NBR                                             PA370   PA52.1
                                                                 PA52.5  PA54.1
                                                                 PA594   PA66.3

PAHSET2   OBJ-ID                                                 BN100   BN35.1
                                                                 HAP3.1  HEP4.1
                                                                 HPOS.1  HPQC.1
                                                                 HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR170   HR511
                                                                 HR515   HR54.1
                                                                 HR70.1  HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA105   PA113
                                                                 PA125   PA13.1
                                                                 PA13.2  PA223
                                                                 PA370   PA502
                                                                 PA513   PA52.1
                                                                 ...

PAHSET4   COMPANY                                                HR11.2  HR511
          EMPLOYEE                                               HR521   PA02.1
          ACTION-CODE                                            PA100   PA102
          EFFECT-DATE*                                           PA13.1  PA13.2
          ACTION-NBR*                                            PA502   PA513
                                                                 PA52.1  PA52.2
                                                                 PA52.3  PA52.5
                                                                 PA54.1  PA66.1
                                                                 PA66.4  PR110
                                                                 PR282   UK110

PAHSET5   COMPANY                                                PA125   PA340
          ACTION-CODE                                            PA341   PA355
          EMPLOYEE                                               PA66.2
          EFFECT-DATE*
          ACTION-NBR*

PAHSET6   COMPANY       KeyChange                                PA149
          DATE-STAMP
          OBJ-ID

                         PERSACTHST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Action Code    PERSACTYPE   Required

                            PAH-COMPANY        -> PAT-COMPANY
                            PAH-ACTION-CODE    -> PAT-ACTION-CODE

Company        PRSYSTEM     Required

                            PAH-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            PAH-COMPANY        -> EMP-COMPANY
                            PAH-EMPLOYEE       -> EMP-EMPLOYEE

Paemployee     PAEMPLOYEE   Required

                            PAH-COMPANY        -> PEM-COMPANY
                            PAH-EMPLOYEE       -> PEM-EMPLOYEE

Reason         PCODES       Required
                            When PAH-REASON != Spaces

                            "RA"               -> PCO-TYPE
                            PAH-REASON         -> PCO-CODE

                         PERSACTHST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Comments       PACOMMENTS

                            PAH-COMPANY        -> PAC-COMPANY
                            Zeroes             -> PAC-EMP-APP
                            "PA"               -> PAC-CMT-TYPE
                            PAH-ACTION-CODE    -> PAC-ACTION-CODE
                            PAH-EFFECT-DATE    -> PAC-DATE
                            PAH-EMPLOYEE       -> PAC-EMPLOYEE
                            Spaces             -> PAC-JOB-CODE
                            PAH-ACTION-NBR     -> PAC-LN-NBR
                                                  PAC-SEQ-NBR

Hist Err       HISTERR      Delete Cascades

                            PAH-OBJ-ID         -> HER-ACT-OBJ-ID
                                                  HER-FLD-NBR
                                                  HER-SEQ-NBR

Hr History     HRHISTORY

                            PAH-COMPANY        -> HRH-COMPANY
                            PAH-OBJ-ID         -> HRH-ACT-OBJ-ID
                                                  HRH-FLD-NBR
                                                  HRH-EMPLOYEE
                                                  HRH-OBJ-ID
                                                  HRH-BEG-DATE
                                                  HRH-SEQ-NBR

Pay Rate Hist  PRRATEHIST

                            PAH-COMPANY        -> PRH-COMPANY
                            PAH-OBJ-ID         -> PRH-ACT-OBJ-ID
                                                  PRH-EMPLOYEE
                                                  PRH-BEG-DATE
                                                  PRH-SEQ-NBR