Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            PERSACTION FILE

                            Personnel Action

The Personnel Action file contains personnel action parameters setup in
PA52.1 (Individual Action) for processing by PA100 (Action Update). Records
are created in this file only if the personnel action does not need immediate
processing (it has an effective date in the future).

REFERENCED BY

PA302     PA56.1    BN150     HR521     PR128     PR131
PR132     PR134     PR136     PR137     PR140     PR150
PR195     PR199     PR32.1    PR32.2    PR33.1    PR33.2
PR33.3    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR36.1    PR37.1    PR45.1    PR530
PR80.1    PR82.1    PR85.1    UK102     UK330     UK120
PA115     PA120     PA50.1

UPDATED BY

HC02.3    HCOP.2    HR11.1    HR15.1    HR155     HR170
HR511     HR54.1    HR55.2    HR55.3    HR65.6    HR65.8
HR70.1    HR700     HR704     HRS1.1    HRSC.1    PA02.1
PA100     PA102     PA13.1    PA13.2    PA16.1    PA20.1
PA21.1    PA22.1    PA24.1    PA272     PA34.1    PA35.1
PA36.1    PA38.1    PA502     PA513     PA52.1    PA52.2
PA52.3    PA52.4    PA52.5    PA520     PA53.1    PA54.1
TR21.1    TR22.1    TR500     PR13.1    UK110

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PCT-COMPANY          Numeric 4                                   PA100   PA52.1
Company              Contains the company number which           PA52.2  PA52.3
                     represents an established company.          PA52.4  PA52.5
                                                                 PA53.1  UK110

PCT-ACTION-TYPE      Alpha 1                                     PA100   PA52.1
Action Type          Contains the action type. Valid values      PA52.2  PA52.3
                     are:                                        PA52.4  PA52.5
                                                                 PA53.1  UK110
                     A = Hire an applicant
                     E = Individual action
                     M = Mass change
                     P = Mass pay change
                     L = Multiple Positions

PCT-EFFECT-DATE      Numeric 8  (yyyymmdd)                       PA100   PA52.1
Effective Date       Contains the date the personnel action      PA52.2  PA52.3
                     is effective. This date is stored in the    PA52.4  PA52.5
                     Employee Maintenance Audit file as the      PA53.1  UK110
                     effective date for each field changed by
                     the action.

PCT-ACTION-CODE      Alpha 10                                    PA100   PA52.1
Action Code          Contains the action code.                   PA52.2  PA52.3
                                                                 PA52.4  PA52.5
                     Action codes are setup in PA50.1            PA53.1  UK110
                     (Action).

PCT-EMPLOYEE         Numeric 9                                   PA100   PA52.1
Employee Number      When the action type is E (individual       PA52.2  PA52.3
                     employee), this field contains the          PA52.4  PA52.5
                     employee number. When the action type is    PA53.1  UK110
                     H (hire an applicant), this field
                     contains the applicant number. With
                     action types of M (mass change) or P
                     (mass pay change), this field contains a
                     value of zero.

PCT-ANT-END-DATE     Numeric 8  (yyyymmdd)                       PA100   PA52.1
Anticipated Ending   Contains the anticipated ending date of     PA52.2  PA52.3
Date                 the personnel action. This date is used     PA52.4  PA52.5
                     for references purposes only.               UK110

PCT-ACTION-NBR       Numeric 4                                   PA100   PA52.1
Action Number        Contains the internal action number,        PA52.2  PA52.3
                     which is automatically assigned.            PA52.4  PA52.5
                                                                 PA53.1  UK110

PCT-PROCESS-LEVEL    Alpha 5                                     PA52.1  PA52.2
Process Level        Contains the process level. It is used      PA52.3  PA52.5
                     to define the population affected by M      UK110
                     (mass change) and P (mass pay change)
                     actions.

PCT-DEPARTMENT       Alpha 5                                     PA52.1  PA52.2
Department           Contains the department. It is used to      PA52.3  PA52.5
                     define the population affected by M         UK110
                     (mass change) and P (mass pay change)
                     actions.

PCT-USER-LEVEL       Alpha 10                                    PA52.2  PA52.3
User Level           Contains the user level. It is used to
                     define the population affected by M
                     (mass change) and P (mass pay change)
                     actions.

PCT-LOCAT-CODE       Alpha 10                                    PA52.2  PA52.3
Location             Contains the location. It is used to
                     define the population affected by M
                     (Mass change) and P (Mass Pay Change)
                     actions.

PCT-SUPERVISOR       Alpha 10                                    PA52.2  PA52.3
Supervisor           Contains the supervisor. It is used to
                     define the population affected by M
                     (mass change) and P (mass pay change)
                     actions.

PCT-UNION-CODE       Alpha 10                                    PA52.2
Union                Contains the union. It is used to
                     define the population affected by M
                     (mass change) and P (mass pay change)
                     actions.

PCT-PERS-GROUP       Alpha 10                                    PA52.2  PA52.3
Employee Group       Contains the employee group. It is used
                     to define the population affected by M
                     (mass change) and P (mass pay change)
                     actions.

PCT-REASON           Alpha 10 Occurs 2 Times                     PA100   PA52.1
Reason               Contains personnel action reasons.          PA52.2  PA52.3
                     Valid reason codes must be setup in the     PA52.4  PA52.5
                     Human Resource Code file.                   UK110

PCT-FLD-NBR          Numeric 4 Occurs 36 Times                   PA100   PA102
Dictionary Field     This field identifies (by using the         PA52.1  PA52.2
Number               data dictionary) the field to be updated    PA52.3  PA52.4
                     by the personnel action.                    PA52.5  UK110

PCT-NEW-VALUE        Alpha 30 Occurs 36 Times                    HC02.3  HCOP.2
Field Value After    Contains the new value to be updated to     HR11.1  HR15.1
Change               the employee for the associated field.      HR155   HR170
                                                                 HR511   HR54.1
                                                                 HR55.2  HR55.3
                                                                 HR65.6  HR65.8
                                                                 HR70.1  HR700
                                                                 HR704   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA16.1  PA20.1
                                                                 PA21.1  PA22.1
                                                                 PA24.1  PA272
                                                                 PA34.1  PA35.1
                                                                 PA36.1  PA38.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.2
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA520
                                                                 PA54.1  PR13.1
                                                                 TR21.1  TR22.1
                                                                 TR500   UK110

PCT-SALARY-CLASS     Alpha 1                                     PA52.1  PA52.2
Salary Class         Contains the salary class. It is used
                     to define the population affected by M
                     (mass change) and P (mass pay change)
                     actions.
                     H = Hourly
                     S = Salaried

PCT-PCT-PAY-INC      Signed 7.3                                  PA52.1  PA52.2
Percent Pay Increase Contains the percent of pay increase.
                     This value is used by P (Mass Pay
                     Change) actions.

PCT-ROUND-EVEN       Signed 9.4                                  PA52.1  PA52.2
Round to Even Amount Contains the amount to be rounded. This
                     value is used by P (Mass Pay Change)
                     actions.

PCT-PCT-PAY-DEC      Signed 7.3                                  PA52.1  PA52.2
Percent Pay Decrease Contains the percent decrease of pay.
                     This value is used by type P (Mass Pay
                     Change) actions.

PCT-ROUND-OPT        Alpha 1                                     PA52.1  PA52.2
Rounding Option      Contains the rounding option. This
                     value is used by P (Mass Pay Change)
                     actions.
                     H = Round Higher
                     N = Do not round
                     R = Normal rounding

PCT-FLAT-INC         Signed 13.4                                 PA52.1  PA52.2
Flat Dollar Increase Contains the increase by the flat
                     amount. This value is used by P (Mass
                     Pay Change) actions.

PCT-FLAT-DEC         Signed 13.4                                 PA52.1  PA52.2
Flat Dollar Decrease Contains the amount of decrease by the
                     flat amount. This value is used by P
                     (Mass Pay Change) actions.

PCT-NEW-RATE         Signed 13.4                                 PA52.1  PA52.2
New Pay Rate         Contains the new rate. This value is
                     used by P (Mass Pay Change) actions.

PCT-USER-ID          Alpha 10  (Lower Case)                      PA100   PA52.1
User ID              Contains the password description of        PA52.2  PA52.3
                     the user who setup the personnel action.    PA52.4  PA52.5
                     The user ID is stored in the Employee       UK110
                     Maintenance Audit file. This field is
                     used only if the Lawson Security package
                     is installed.

PCT-PARTICIPNT       Numeric 9                                   PA100   PA52.1
Participant          Contains the COBRA participant number
                     if the action changes the employee to a
                     COBRA participant.

PCT-OCCUR-TYPE       Alpha 2                                     PA100   PA52.1
Type of First        Contains the occurrence. This field is
Occurrence           used only if the action changes the
                     employee to a COBRA participant. This is
                     a user-defined occurrence type from the
                     Benefits system.

PCT-UPDATE-BENEFIT   Alpha 1                                     PA100   PA52.1
Update Benefit       Indicate whether the change can update      PA52.2  PA52.3
                     benefits.                                   PA52.5  UK110
                     Y = Yes
                     N = No

PCT-POS-LEVEL        Numeric 2                                   PA100   PA52.1
Pos Level            Contains the position level.                PA52.2  PA52.3
                     01 = Level 1                                PA52.4  PA52.5
                     02 = Level 2                                UK110
                     03 = Level 3
                     04 = Level 4
                     05 = Level 5

PCT-POS-EFF-DT       Numeric 8  (yyyymmdd)                       PA02.1  PA100
Pos Eff Dt           Contains the effective date for the         PA102   PA502
                     position.                                   PA52.1  PA52.4
                                                                 PA52.5

PCT-POSITION         Alpha 12                                    PA100   PA52.1
Position             Contains the user-defined code that         PA52.4  PA52.5
                     represents a position in the company.

PCT-REQUISITION      Numeric 9                                   PA100   PA52.4
Requisition          Contains a user-defined code that
                     represents a requisition.

PCT-JOB-CODE         Alpha 9                                     PA100   PA52.1
Job Code             Contains a user-defined code that           PA52.4  PA52.5
                     represents a type of job.                   UK110

PCT-PAY-POSITION     Alpha 12                                    PA52.1  PA52.5
Pay Position         If the action contains position default
                     information, this field contains the
                     position.

PCT-UPDATE-REQ-DED   Alpha 1                                     PA52.1  PA52.4
Update Req Ded       Indicates whether you want to               PA52.5  UK110
                     automatically update required
                     deductions.
                     N = No
                     Y = Yes

PCT-EDM-EFFECT-DT    Numeric 8  (yyyymmdd)                       PA52.1  PA52.4
Edm Effect Dt        Contains the first date to take new         PA52.5
                     required deductions.

PCT-EDM-END-DATE     Numeric 8  (yyyymmdd)                       PA52.1  PA52.5
Edm End Date         Contains the last date you want to take
                     old required deductions.

PCT-SHORT-TYPE-DES   Derived
Short Type Des

PCT-SHORT-NAME       Derived
Short Name

PCT-APPROVAL-FLAG    Alpha 1                                     PA52.1  PA52.2
Approval             N = No                                      PA52.3  PA52.4
                     Y = Yes                                     PA52.5  PA53.1
                                                                 UK110

PCT-WF-PEND-ACT      Derived
Wf Pend Act          Company
                     Action Type
                     Effect Date
                     Action Code
                     Employee
                     Action Nbr

PCT-BASE-CURRENCY    Alpha 5                                     HR700   PA52.1
Base Currency        Contains the base currency of the           PA52.2  PA52.5
                     company.

PCT-BASE-ND          Numeric 1                                   HR700   PA52.1
Base Number Of       The number of decimal positions defined     PA52.2  PA52.5
Decimals             for the company base currency.              UK110


PCT-BASE-PAY-RATE    Signed 13.4                                 HR700   PA52.1
Base Pay Rate        Contains the pay in the company's base      PA52.2  PA52.5
                     currency.                                   UK110

                         PERSACTION FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PCTSET1   COMPANY                                                HC02.3  HCOP.2
          ACTION-TYPE                                            HR11.1  HR15.1
          EFFECT-DATE                                            HR155   HR170
          ACTION-CODE                                            HR511   HR54.1
          EMPLOYEE                                               HR55.1  HR55.2
          ACTION-NBR                                             HR55.3  HR65.6
                                                                 HR65.8  HR70.1
                                                                 HR700   HR704
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 PA22.1  PA24.1
                                                                 PA272   PA302
                                                                 ...

PCTSET2   COMPANY                                                BN150   HR11.1
          ACTION-TYPE                                            HR511   HR521
          EMPLOYEE                                               PA02.1  PA100
          ACTION-CODE                                            PA102   PA13.1
          EFFECT-DATE                                            PA13.2  PA272
          ACTION-NBR*                                            PA502   PA513
                                                                 PA52.1  PA52.2
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA53.1
                                                                 PA54.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR150   PR195
                                                                 PR199   PR32.1
                                                                 ...

PCTSET3   COMPANY                                                HR704   PA115
          ACTION-CODE                                            PA120   PA272
          ACTION-TYPE                                            PA50.1
          EFFECT-DATE
          EMPLOYEE
          ACTION-NBR*

                         PERSACTION FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Action Code    PERSACTYPE   Required

                            PCT-COMPANY          -> PAT-COMPANY
                            PCT-ACTION-CODE      -> PAT-ACTION-CODE

Applicant      APPLICANT    Required
                            When PCT-ACTION-TYPE = "A"

                            PCT-COMPANY          -> APL-COMPANY
                            PCT-EMPLOYEE         -> APL-APPLICANT

Base Currency  CUCODES      Required
                            When PCT-BASE-CURRENCY != Spaces

                            PCT-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Company        PRSYSTEM     Required

                            PCT-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Department     DEPTCODE     Required
                            When PCT-DEPARTMENT != Spaces

                            PCT-COMPANY          -> DPT-COMPANY
                            PCT-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            PCT-DEPARTMENT       -> DPT-DEPARTMENT

Emp Group      PERSGROUP    Required
                            When PCT-PERS-GROUP != Spaces

                            PCT-COMPANY          -> PRG-COMPANY
                            PCT-PERS-GROUP       -> PRG-GROUP-NAME

Employee       EMPLOYEE     Required
                            When PCT-ACTION-TYPE = "E"

                            PCT-COMPANY          -> EMP-COMPANY
                            PCT-EMPLOYEE         -> EMP-EMPLOYEE

Field Nbr      PADICT       Required
                            When PCT-FLD-NBR != Zeroes

                            PCT-FLD-NBR          -> PAD-FLD-NBR

Jobcode        JOBCODE      Required
                            When (PCT-JOB-CODE != Spaces )

                            PCT-COMPANY          -> JBC-COMPANY
                            PCT-JOB-CODE         -> JBC-JOB-CODE

Location       PCODES       Required
                            When PCT-LOCAT-CODE != Spaces

                            "LO"                 -> PCO-TYPE
                            PCT-LOCAT-CODE       -> PCO-CODE

Occur Type     OCCURTYPE    Required
                            When PCT-OCCUR-TYPE != Spaces

                            PCT-COMPANY          -> OCC-COMPANY
                            PCT-OCCUR-TYPE       -> OCC-OCCUR-TYPE

Participant    PARTICIPNT   Required
                            When PCT-PARTICIPNT != Zeroes

                            PCT-COMPANY          -> PAR-COMPANY
                            PCT-PARTICIPNT       -> PAR-PARTICIPNT

Process Level  PRSYSTEM     Required
                            When PCT-PROCESS-LEVEL != Spaces

                            PCT-COMPANY          -> PRS-COMPANY
                            PCT-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

Reason         PCODES       Required
                            When PCT-REASON != Spaces

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

Requisition    PAJOBREQ     Required
                            When (PCT-REQUISITION != Zeroes )

                            PCT-COMPANY          -> PJR-COMPANY
                            PCT-REQUISITION      -> PJR-REQUISITION

Supervisor     HRSUPER      Required
                            When PCT-SUPERVISOR != Spaces

                            PCT-COMPANY          -> HSU-COMPANY
                            PCT-SUPERVISOR       -> HSU-CODE

Union          PCODES       Required
                            When PCT-UNION-CODE != Spaces

                            "UN"                 -> PCO-TYPE
                            PCT-UNION-CODE       -> PCO-CODE

User Level     PCODES       Required
                            When PCT-USER-LEVEL != Spaces

                            "UL"                 -> PCO-TYPE
                            PCT-USER-LEVEL       -> PCO-CODE

                         PERSACTION FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Comments       PACOMMENTS

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

Emp Group Emps PGEMPLOYEE

                            PCT-COMPANY          -> PGE-COMPANY
                            PCT-PERS-GROUP       -> PGE-GROUP-NAME
                                                    PGE-EMPLOYEE

Pay Position   PAPOSITION
                            Valid When (PCT-PAY-POSITION != Spaces )

                            PCT-COMPANY          -> POS-COMPANY
                            PCT-PAY-POSITION     -> POS-POSITION
                                                    POS-EFFECT-DATE

Pos Chg Error  PAPOSERR
                            Valid When (PCT-POSITION != Spaces )

                            PCT-COMPANY          -> PPE-COMPANY
                            PCT-EMPLOYEE         -> PPE-EMPLOYEE
                            Zeroes               -> PPE-REQUISITION
                            PCT-POSITION         -> PPE-POSITION
                                                    PPE-EFFECT-DATE
                                                    PPE-UPDATE-TYPE

Position       PAPOSITION   Required
                            When (PCT-POSITION != Spaces )

                            PCT-COMPANY          -> POS-COMPANY
                            PCT-POSITION         -> POS-POSITION
                                                    POS-EFFECT-DATE

Workflow       WFWORKUNIT

                            "PCTSET1        "    -> WFW-OBJECT-NAME
                            PCT-WF-PEND-ACT      -> WFW-KEY-STRING
                                                    WFW-WORKUNIT