Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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    AC541     AC542     BN150     HR521
PA120     PR128     PR131     PR132     PR134     PR136
PR32.2    PR33.2    PR33.3    PR35.1    PR35.2    PR35.3
PR35.4    PR35.5    PR35.6    PR35.8    PR36.1    PR530
PR82.1    UK102     UK120     PA50.1

UPDATED BY

HC02.3    HCOP.2    HR15.1    HR155     HR170     HR511
HR515     HR54.1    HR55.2    HR55.3    HR65.6    HR65.8
HR650     HR70.1    HRS1.1    HRSC.1    PA113     PA16.1
PA272     PA502     PA513     PA53.1    PA54.1    TR22.1
TR500     PR13.1    PR13.5    PR13.6    PR13.8    UK110

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PCT-COMPANY          Numeric 4                                   PA53.1  UK110
Company              Contains the company number which
                     represents an established company.

PCT-ACTION-TYPE      Alpha 1                                     PA53.1  UK110
Action Type          Contains the action type. Valid values
                     are:

                     A = Hire an applicant
                     E = Individual action
                     M = Mass change
                     P = Mass pay change
                     L = Multiple Positions

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

PCT-ACTION-CODE      Alpha 10                                    PA53.1  UK110
Action Code          Contains the action code.

                     Action codes are setup in PA50.1
                     (Action).

PCT-EMPLOYEE         Numeric 9                                   PA53.1  UK110
Employee Number      When the action type is E (individual
                     employee), this field contains the
                     employee number. When the action type is
                     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)                       UK110
Anticipated Ending   Contains the anticipated ending date of
Date                 the personnel action. This date is used
                     for references purposes only.

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

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

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

PCT-USER-LEVEL       Alpha 10
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
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
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
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
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                     UK110
Reason               Contains personnel action reasons.
                     Valid reason codes must be setup in the
                     Human Resource Code file.

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

PCT-NEW-VALUE        Alpha 30 Occurs 36 Times                    HC02.3  HCOP.2
Field Value After    Contains the new value to be updated to     HR15.1  HR155
Change               the employee for the associated field.      HR170   HR511
                                                                 HR515   HR54.1
                                                                 HR55.2  HR55.3
                                                                 HR65.6  HR65.8
                                                                 HR650   HR70.1
                                                                 HRS1.1  HRSC.1
                                                                 PA113   PA16.1
                                                                 PA272   PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR22.1  TR500
                                                                 UK110

PCT-SALARY-CLASS     Alpha 1
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
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
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
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
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
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
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
New Pay Rate         Contains the new rate. This value is
                     used by P (Mass Pay Change) actions.

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

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

PCT-OCCUR-TYPE       Alpha 2
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                                     UK110
Update Benefit       Indicate whether the change can update
                     benefits.
                     Y = Yes
                     N = No

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

PCT-POS-EFF-DT       Numeric 8  (yyyymmdd)                       PA502
Pos Eff Dt           Contains the effective date for the
                     position.

PCT-POSITION         Alpha 12
Position             Contains the user-defined code that
                     represents a position in the company.

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

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

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

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

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

PCT-EDM-END-DATE     Numeric 8  (yyyymmdd)
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                                     PA53.1  UK110
Approval             N = No
                     Y = Yes

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

PCT-BASE-CURRENCY    Alpha 5
Base Currency        Contains the base currency of the
                     company.

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

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

PCT-MERGE-ACTN-NBR   Numeric 4
Merge Actn Nbr

PCT-HIST-CORR-FLAG   Alpha 2
Hist Corr Flag       Indicates default method the system uses
                     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
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

                         PERSACTION FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PCTSET1   COMPANY                                                HC02.3  HCOP.2
          ACTION-TYPE                                            HR15.1  HR155
          EFFECT-DATE                                            HR170   HR511
          ACTION-CODE                                            HR515   HR54.1
          EMPLOYEE                                               HR55.1  HR55.2
          ACTION-NBR                                             HR55.3  HR65.6
                                                                 HR65.8  HR650
                                                                 HR70.1  HRS1.1
                                                                 HRSC.1  PA113
                                                                 PA16.1  PA272
                                                                 PA302   PA502
                                                                 PA513   PA54.1
                                                                 PA56.1  TR22.1
                                                                 TR500   PR13.1
                                                                 PR13.5  PR13.6
                                                                 ...

PCTSET2   COMPANY                                                AC541   AC542
          ACTION-TYPE                                            BN150   HR511
          EMPLOYEE                                               HR521   HR650
          ACTION-CODE                                            PA120   PA272
          EFFECT-DATE                                            PA502   PA513
          ACTION-NBR*                                            PA53.1  PA54.1
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR131
                                                                 PR132   PR134
                                                                 PR136   PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 ...

PCTSET3   COMPANY                                                PA272   PA50.1
          ACTION-CODE
          ACTION-TYPE
          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