Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PERSACTION


                            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     ET530     ETI2.1    HR521
LP130     PA120     PA182     PR128     PR130     PR131
PR132     PR134     PR136     PR189     PR29.1    PR32.2
PR33.2    PR33.3    PR35.1    PR35.2    PR35.3    PR35.4
PR35.5    PR35.6    PR35.8    PR35.9    PR36.1    PR45.1
PR529     PR530     PR560     PR80.1    PR82.1    UK102
UK560     TA147     PA50.1

UPDATED BY

BN305     HC02.5    HAP3.1    HEP4.1    HPOS.1    HPQC.1
HPRS.1    HR11.1    HR11.2    HR15.1    HR155     HR170
HR511     HR515     HR54.1    HR55.2    HR55.3    HR65.6
HR65.8    HR70.1    HRS1.1    HRSC.1    LP100     LP101
PA02.1    PA100     PA102     PA113     PA115     PA13.1
PA13.2    PA16.1    PA20.1    PA21.1    PA22.1    PA24.1
PA27.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
TR26.1    TR500     PR110     PR113     PR120     PR13.1
PR13.5    PR13.6    PR13.8    UK110

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PCT-COMPANY            Numeric 4                                 PA100   PA52.1
Element: 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
Element: 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
Element: Effective DateContains 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
Element: 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
Element: Employee NumbeWhen 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
Element: Ant End Date  Contains the anticipated ending date of   PA52.2  PA52.3
                       the personnel action. This date is used   PA52.4  PA52.5
                       for references purposes only.             UK110

PCT-ACTION-NBR         Numeric 4                                 PA100   PA52.1
Element: Action Nbr    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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Group Name    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
Element: 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
Element: Fld Nbr       This field identifies (by using the       PA52.1  PA52.2
                       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                  BN305   HAP3.1
Element: New Value     Contains the new value to be updated to   HC02.5  HEP4.1
                       the employee for the associated field.    HPOS.1  HPQC.1
                                                                 HPRS.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR170
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR55.3  HR65.6
                                                                 HR65.8  HR70.1
                                                                 HRS1.1  HRSC.1
                                                                 LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 PA115   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA182   PA20.1
                                                                 PA21.1  PA22.1
                                                                 PA24.1  PA27.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  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 ...

PCT-SALARY-CLASS       Alpha 1                                   PA52.1  PA52.2
Element: 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                                PA100   PA52.1
Element: Pct Pay Inc   Contains the percent of pay increase.     PA52.2
                       This value is used by P (Mass Pay
                       Change) actions.

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

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

PCT-ROUND-OPT          Alpha 1                                   PA100   PA52.1
Element: Round Opt     Contains the rounding option. This        PA52.2
                       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                               PA100   PA52.1
Element: Flat Inc      Contains the increase by the flat         PA52.2
                       amount. This value is used by P (Mass
                       Pay Change) actions.

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

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

PCT-USER-ID            Alpha 10  (Lower Case)                    PA100   PA52.1
Element: 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
Element: Participant   Contains the COBRA participant number     PA52.4
                       if the action changes the employee to a
                       COBRA participant.

PCT-OCCUR-TYPE         Alpha 2                                   PA100   PA52.1
Element: Occur Type    Contains the occurrence. This field is
                       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
Element: Update BenefitIndicate whether the change can update    PA52.2  PA52.3
                       benefits.                                 PA52.4  PA52.5
                       Y = Yes                                   UK110
                       N = No

PCT-POS-LEVEL          Numeric 2                                 PA100   PA52.1
Element: Pos Level     Contains the position level.              PA52.2  PA52.3
                                                                 PA52.4  PA52.5
                                                                 UK110

PCT-POS-EFF-DT         Numeric 8  (yyyymmdd)                     PA02.1  PA100
Element: 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
Element: Position      Contains the user-defined code that       PA52.4  PA52.5
                       represents a position in the company.

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

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

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

PCT-UPDATE-REQ-DED     Alpha 1                                   PA52.1  PA52.4
Element: Update Req DedIndicates 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
Element: 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
Element: Edm End Date  Contains the last date you want to take
                       old required deductions.

PCT-SHORT-TYPE-DES     Derived
Element: Short Type Des

PCT-SHORT-NAME         Derived
Element: Short Name

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

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

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

PCT-BASE-ND            Numeric 1                                 PA52.1  PA52.2
Element: Base Nd       The number of decimal positions defined   PA52.5  UK110
                       for the company base currency.

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

PCT-MERGE-ACTN-NBR     Numeric 4                                 PA52.1  PA52.5
Element: Merge Actn Nbr

PCT-HIST-CORR-FLAG     Alpha 2                                   PA52.1  PA52.2
Element: Hist Corr FlagIndicates default method the system uses  PA52.3  PA52.5
                       to correct employee history audit files
                       when a retroactive change is performed.
                       1 = Create pending upd
                       2 = Delete
                       3 = Move to Hist Error

PCT-PROCESS-TYPE       Alpha 2                                   PA52.1  PA52.5
Element: Process Type  This field is the process type to be
                       used for requisitions.  The process type
                       determines which steps (pick, pack, and
                       ship) are to be used in the Warehouse
                       system.
                       1 = Chg Effect Date
                       2 = Retroactive Chg
                       3 = Combine w/Hist Action
                       4 = Reverse Action
                       5 = Move From Level

PCT-POS-LEVEL-MOVE     Numeric 2                                 PA52.1  PA52.5
Element: Pos Level Move

PCT-UPD-ABS-MGMT       Alpha 1                                   PA100   PA52.1
Element: Upd Abs Mgmt  N = No                                    PA52.2  PA52.3
                       Y = Yes                                   PA52.4  PA52.5

                         PERSACTION FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PCTSET1   COMPANY                                                BN305   HC02.5
          ACTION-TYPE                                            HAP3.1  HEP4.1
          EFFECT-DATE                                            HPOS.1  HPQC.1
          ACTION-CODE                                            HPRS.1  HR11.1
          EMPLOYEE                                               HR11.2  HR15.1
          ACTION-NBR                                             HR155   HR170
                                                                 HR511   HR515
                                                                 HR54.1  HR55.1
                                                                 HR55.2  HR55.3
                                                                 HR65.6  HR65.8
                                                                 HR70.1  HRS1.1
                                                                 HRSC.1  LP100
                                                                 LP101   PA02.1
                                                                 PA100   PA102
                                                                 PA113   PA115
                                                                 ...

PCTSET2   COMPANY                                                BN150   BN305
          ACTION-TYPE                                            ET530   ETI2.1
          EMPLOYEE                                               HR11.1  HR11.2
          ACTION-CODE                                            HR511   HR521
          EFFECT-DATE                                            LP130   PA02.1
          ACTION-NBR*                                            PA100   PA102
                                                                 PA115   PA120
                                                                 PA13.1  PA13.2
                                                                 PA182   PA272
                                                                 PA502   PA513
                                                                 PA52.1  PA52.2
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA53.1
                                                                 PA54.1  PR110
                                                                 PR113   PR120
                                                                 ...

PCTSET3   COMPANY                                                PA100   PA272
          ACTION-CODE                                            PA50.1  PA52.1
          ACTION-TYPE                                            PA52.2  PA52.3
          EFFECT-DATE                                            PA52.5
          EMPLOYEE
          ACTION-NBR*

PCTSET4   COMPANY
          EMPLOYEE
          ACTION-TYPE
          ACTION-CODE
          EFFECT-DATE
          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  (PATSET1)
                            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

Paemployee     PAEMPLOYEE   Required
                            When PCT-ACTION-TYPE = "E"

                            PCT-COMPANY          -> PEM-COMPANY
                            PCT-EMPLOYEE         -> PEM-EMPLOYEE

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
                            Valid When PCT-PERS-GROUP != Spaces

                            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