PERSACTION – Personnel Action

System
Personnel (PA)
Prefix
PCT
Primary key
COMPANY, ACTION-TYPE, EFFECT-DATE, ACTION-CODE, EMPLOYEE, ACTION-NBR
Fields
56
Updated by
82 programs
Referenced by
46 programs

PERSACTION is the Personnel Action table in Lawson Personnel (prefix PCT). It is indexed by COMPANY, ACTION-TYPE, EFFECT-DATE, ACTION-CODE, EMPLOYEE, ACTION-NBR (PCTSET1); alternate indexes: PCTSET2, PCTSET3 and PCTSET4. It is related 1:1 to PERSACTYPE, APPLICANT, CUCODES, PRSYSTEM, DEPTCODE, PERSGROUP, EMPLOYEE, PADICT and 7 more and 1:M to PACOMMENTS, PGEMPLOYEE, PAPOSITION, PAPOSERR and PAACTREAS. It is updated by BN305, HAP3.1, HC02.5, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 and 74 more and referenced by BN150, EXI2.1, EXI4.1, HR521, LP130, PA120, PA302, PA50.1 and 38 more. The table has 56 fields, 4 indexes and 24 documented relations.

About PERSACTION

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).

Fields (56)

Column = COBOL field name without the PCT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PCT-COMPANY PK
COMPANY
Numeric 4Contains the company number which represents an established company.PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, PA53.1, UK110
#PCT-ACTION-TYPE PK
ACTION_TYPE
Alpha 1Contains the action type. Valid values are:
  • A Hire an applicant
  • E Individual action
  • M Mass change
  • P Mass pay change
  • L Multiple Positions
PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, PA53.1, UK110
#PCT-EFFECT-DATE PK
EFFECT_DATE
Numeric 8 (yyyymmdd)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.PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, PA53.1, UK110
#PCT-ACTION-CODE PK
ACTION_CODE
Alpha 10Contains the action code. Action codes are setup in PA50.1 (Action).PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, PA53.1, UK110
#PCT-EMPLOYEE PK
EMPLOYEE
Numeric 9When 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.PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, PA53.1, UK110
#PCT-ANT-END-DATE
ANT_END_DATE
Numeric 8 (yyyymmdd)Contains the anticipated ending date of the personnel action. This date is used for references purposes only.PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, UK110
#PCT-ACTION-NBR PK
ACTION_NBR
Numeric 4Contains the internal action number, which is automatically assigned.PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, PA53.1, UK110
#PCT-PROCESS-LEVEL
PROCESS_LEVEL
Alpha 5Contains the process level. It is used to define the population affected by M (mass change) and P (mass pay change) actions.PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, UK110
#PCT-DEPARTMENT
DEPARTMENT
Alpha 5Contains the department. It is used to define the population affected by M (mass change) and P (mass pay change) actions.PA52.1, PA52.2, PA52.3, PA52.5, UK110
#PCT-USER-LEVEL
USER_LEVEL
Alpha 10Contains the user level. It is used to define the population affected by M (mass change) and P (mass pay change) actions.PA52.2, PA52.3
#PCT-LOCAT-CODE
LOCAT_CODE
Alpha 10Contains the location. It is used to define the population affected by M (Mass change) and P (Mass Pay Change) actions.PA52.2, PA52.3
#PCT-SUPERVISOR
SUPERVISOR
Alpha 10Contains the supervisor. It is used to define the population affected by M (mass change) and P (mass pay change) actions.PA52.2, PA52.3
#PCT-UNION-CODE
UNION_CODE
Alpha 10Contains the union. It is used to define the population affected by M (mass change) and P (mass pay change) actions.PA52.2
#PCT-PERS-GROUP
PERS_GROUP
Alpha 10Contains the employee group. It is used to define the population affected by M (mass change) and P (mass pay change) actions.PA52.2, PA52.3
#PCT-REASON
REASON
Alpha 10 Occurs 2 Times ×2Contains personnel action reasons. Valid reason codes must be setup in the Human Resource Code file.PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, UK110
#PCT-FLD-NBR
FLD_NBR
Numeric 4 Occurs 36 Times ×36This field identifies (by using the data dictionary) the field to be updated by the personnel action.PA100, PA102, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, UK110
#PCT-NEW-VALUE
NEW_VALUE
Alpha 60 (Lower Case)Occurs 36 Times Contains the new value to be updated to the employee for the associated field.BN305, HAP3.1, HC02.5, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +52 more (list truncated in source)
#PCT-SALARY-CLASS
SALARY_CLASS
Alpha 1Contains 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
PA52.1, PA52.2
#PCT-PCT-PAY-INC
PCT_PAY_INC
Signed 7.3Contains the percent of pay increase. This value is used by P (Mass Pay Change) actions.PA100, PA52.1, PA52.2
#PCT-ROUND-EVEN
ROUND_EVEN
Signed 9.4Contains the amount to be rounded. This value is used by P (Mass Pay Change) actions.PA100, PA52.1, PA52.2
#PCT-PCT-PAY-DEC
PCT_PAY_DEC
Signed 7.3Contains the percent decrease of pay. This value is used by type P (Mass Pay Change) actions.PA100, PA52.1, PA52.2
#PCT-ROUND-OPT
ROUND_OPT
Alpha 1Contains the rounding option. This value is used by P (Mass Pay Change) actions.
  • H Round Higher
  • N Do not round
  • R Normal rounding
PA100, PA52.1, PA52.2
#PCT-FLAT-INC
FLAT_INC
Signed 13.4Contains the increase by the flat amount. This value is used by P (Mass Pay Change) actions.PA100, PA52.1, PA52.2
#PCT-FLAT-DEC
FLAT_DEC
Signed 13.4Contains the amount of decrease by the flat amount. This value is used by P (Mass Pay Change) actions.PA100, PA52.1, PA52.2
#PCT-NEW-RATE
NEW_RATE
Signed 13.4Contains the new rate. This value is used by P (Mass Pay Change) actions.PA100, PA52.1, PA52.2
#PCT-USER-ID
USER_ID
Alpha 10 (Lower Case)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.PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, PA53.1, UK110
#PCT-PARTICIPNT
PARTICIPNT
Numeric 9Contains the COBRA participant number if the action changes the employee to a COBRA participant.PA100, PA52.1, PA52.4
#PCT-OCCUR-TYPE
OCCUR_TYPE
Alpha 2Contains 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.PA100, PA52.1
#PCT-UPDATE-BENEFIT
UPDATE_BENEFIT
Alpha 1Indicate whether the change can update benefits.
  • Y Yes
  • N No
PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, UK110
#PCT-POS-LEVEL
POS_LEVEL
Numeric 2Contains the position level.PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, UK110
#PCT-POS-EFF-DT
POS_EFF_DT
Numeric 8 (yyyymmdd)Contains the effective date for the position.LT101, LT111, PA02.1, PA100, PA102, PA502, PA52.1, PA52.4 +1 more
#PCT-POSITION
POSITION
Alpha 12Contains the user-defined code that represents a position in the company.PA100, PA52.1, PA52.4, PA52.5
#PCT-REQUISITION
REQUISITION
Numeric 9Contains a user-defined code that represents a requisition.PA100, PA52.4
#PCT-JOB-CODE
JOB_CODE
Alpha 9Contains a user-defined code that represents a type of job.PA100, PA52.1, PA52.5, UK110
#PCT-PAY-POSITION
PAY_POSITION
Alpha 12If the action contains position default information, this field contains the position.PA52.1, PA52.5
#PCT-UPDATE-REQ-DED
UPDATE_REQ_DED
Alpha 1Indicates whether you want to automatically update required deductions.
  • N No
  • Y Yes
PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, UK110
#PCT-EDM-EFFECT-DT
EDM_EFFECT_DT
Numeric 8 (yyyymmdd)Contains the first date to take new required deductions.PA52.1, PA52.2, PA52.3, PA52.4, PA52.5
#PCT-EDM-END-DATE
EDM_END_DATE
Numeric 8 (yyyymmdd)Contains the last date you want to take old required deductions.PA52.1, PA52.2, PA52.3, PA52.4, PA52.5
#PCT-SHORT-TYPE-DES
SHORT_TYPE_DES
Derived——
#PCT-SHORT-NAME
SHORT_NAME
Derived——
#PCT-APPROVAL-FLAG
APPROVAL_FLAG
Alpha 1—
  • N No
  • Y Yes
  • L LTM Action
PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, PA53.1, UK110
#PCT-WF-PEND-ACT
WF_PEND_ACT
DerivedCompany Action Type Effect Date Action Code Employee Action Nbr—
#PCT-BASE-CURRENCY
BASE_CURRENCY
Alpha 5Contains the base currency of the company.PA52.1, PA52.2, PA52.5
#PCT-BASE-ND
BASE_ND
Numeric 1The number of decimal positions defined for the company base currency.PA52.1, PA52.2, PA52.5, UK110
#PCT-BASE-PAY-RATE
BASE_PAY_RATE
Signed 13.4Contains the pay in the company's base currency.PA52.1, PA52.2, PA52.5, UK110
#PCT-MERGE-ACTN-NBR
MERGE_ACTN_NBR
Numeric 4—PA52.1, PA52.5
#PCT-HIST-CORR-FLAG
HIST_CORR_FLAG
Alpha 2Indicates 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
PA52.1, PA52.2, PA52.3, PA52.4, PA52.5
#PCT-PROCESS-TYPE
PROCESS_TYPE
Alpha 2This 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
PA52.1, PA52.5
#PCT-POS-LEVEL-MOVE
POS_LEVEL_MOVE
Numeric 2—PA52.1, PA52.5
#PCT-UPD-ABS-MGMT
UPD_ABS_MGMT
Alpha 1—
  • N No
  • Y Yes
PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5
#PCT-HOLD-FLAG
HOLD_FLAG
Alpha 1This field enables a personnel action to be put on hold. PA100 would not process this action until the it is no longer being held.
  • N No
  • Y Yes
PA52.1, PA52.2, PA52.3, PA52.4, PA52.5, PA58.1
#PCT-CREATE-USER-ID
CREATE_USER_ID
Alpha 10 (Lower Case)—PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5
#PCT-CREATE-TIME
CREATE_TIME
Numeric 6 (hhmmss)—PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5
#PCT-CREATE-DATE
CREATE_DATE
Numeric 8 (yyyymmdd)—PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5
#PCT-TIME-STAMP
TIME_STAMP
Numeric 6 (hhmmss)—PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5
#PCT-DATE-STAMP
DATE_STAMP
Numeric 8 (yyyymmdd)—PA100, PA52.1, PA52.2, PA52.3, PA52.4, PA52.5

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PCTSET1
  1. COMPANY
  2. ACTION-TYPE
  3. EFFECT-DATE
  4. ACTION-CODE
  5. EMPLOYEE
  6. ACTION-NBR
PrimaryBN305, HC02.5, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +22 more (list truncated in source)
PCTSET2
  1. COMPANY
  2. ACTION-TYPE
  3. EMPLOYEE
  4. ACTION-CODE
  5. EFFECT-DATE
  6. ACTION-NBR ↓
BN150, BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR521 +22 more (list truncated in source)
PCTSET3
  1. COMPANY
  2. ACTION-CODE
  3. ACTION-TYPE
  4. EFFECT-DATE
  5. EMPLOYEE
  6. ACTION-NBR ↓
PA100, PA272, PA50.1, PA52.1, PA52.2, PA52.3, PA52.5
PCTSET4
  1. COMPANY
  2. EMPLOYEE
  3. ACTION-TYPE
  4. ACTION-CODE
  5. EFFECT-DATE
  6. ACTION-NBR
PA58.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PERSACTYPEAPPLICANTCUCODESPRSYSTEMDEPTCODEPERSGROUPEMPLOYEEPADICTJOBCODEPCODESOCCURTYPEPAEMPLOYEEPARTICIPNTPAJOBREQ+1 more belowPACOMMENTSPGEMPLOYEEPAPOSITIONPAPOSERRPAACTREASPERSACTION

One to one (18) — lookups and parents

RelationTableRulesConditionField map
Action CodePERSACTYPERequired
PCT-COMPANY→PAT-COMPANY
PCT-ACTION-CODE→PAT-ACTION-CODE
ApplicantAPPLICANTRequiredWhen PCT-ACTION-TYPE = "A"
PCT-COMPANY→APL-COMPANY
PCT-EMPLOYEE→APL-APPLICANT
Base CurrencyCUCODESRequiredWhen PCT-BASE-CURRENCY != Spaces
PCT-BASE-CURRENCY→CUC-CURRENCY-CODE
CompanyPRSYSTEMRequired
PCT-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
DepartmentDEPTCODERequiredWhen PCT-DEPARTMENT != Spaces
PCT-COMPANY→DPT-COMPANY
PCT-PROCESS-LEVEL→DPT-PROCESS-LEVEL
PCT-DEPARTMENT→DPT-DEPARTMENT
Emp GroupPERSGROUPRequiredWhen PCT-PERS-GROUP != Spaces
PCT-COMPANY→PRG-COMPANY
PCT-PERS-GROUP→PRG-GROUP-NAME
EmployeeEMPLOYEERequiredWhen PCT-ACTION-TYPE = "E"
PCT-COMPANY→EMP-COMPANY
PCT-EMPLOYEE→EMP-EMPLOYEE
Field NbrPADICTRequiredWhen PCT-FLD-NBR != Zeroes
PCT-FLD-NBR→PAD-FLD-NBR
JobcodeJOBCODERequiredWhen (PCT-JOB-CODE != Spaces)
PCT-COMPANY→JBC-COMPANY
PCT-JOB-CODE→JBC-JOB-CODE
LocationPCODESRequiredWhen PCT-LOCAT-CODE != Spaces
"LO"→PCO-TYPE
PCT-LOCAT-CODE→PCO-CODE
Occur TypeOCCURTYPERequiredWhen PCT-OCCUR-TYPE != Spaces
PCT-COMPANY→OCC-COMPANY
PCT-OCCUR-TYPE→OCC-OCCUR-TYPE
PaemployeePAEMPLOYEERequiredWhen PCT-ACTION-TYPE = "E"
PCT-COMPANY→PEM-COMPANY
PCT-EMPLOYEE→PEM-EMPLOYEE
ParticipantPARTICIPNTRequiredWhen PCT-PARTICIPNT != Zeroes
PCT-COMPANY→PAR-COMPANY
PCT-PARTICIPNT→PAR-PARTICIPNT
Process LevelPRSYSTEMRequiredWhen PCT-PROCESS-LEVEL != Spaces
PCT-COMPANY→PRS-COMPANY
PCT-PROCESS-LEVEL→PRS-PROCESS-LEVEL
RequisitionPAJOBREQRequiredWhen (PCT-REQUISITION != Zeroes)
PCT-COMPANY→PJR-COMPANY
PCT-REQUISITION→PJR-REQUISITION
SupervisorHRSUPERRequiredWhen PCT-SUPERVISOR != Spaces
PCT-COMPANY→HSU-COMPANY
PCT-SUPERVISOR→HSU-CODE
UnionPCODESRequiredWhen PCT-UNION-CODE != Spaces
"UN"→PCO-TYPE
PCT-UNION-CODE→PCO-CODE
User LevelPCODESRequiredWhen PCT-USER-LEVEL != Spaces
"UL"→PCO-TYPE
PCT-USER-LEVEL→PCO-CODE

One to many (6) — child tables

RelationTableRulesConditionField map
CommentsPACOMMENTS
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
—→PAC-DATE
Emp Group EmpsPGEMPLOYEEValid When PCT-PERS-GROUP != Spaces
PCT-COMPANY→PGE-COMPANY
PCT-PERS-GROUP→PGE-GROUP-NAME
—→PGE-EMPLOYEE
Pay PositionPAPOSITIONValid When (PCT-PAY-POSITION != Spaces)
PCT-COMPANY→POS-COMPANY
PCT-PAY-POSITION→POS-POSITION
—→POS-EFFECT-DATE
Pos Chg ErrorPAPOSERRValid 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
PositionPAPOSITIONRequiredWhen (PCT-POSITION != Spaces)
PCT-COMPANY→POS-COMPANY
PCT-POSITION→POS-POSITION
—→POS-EFFECT-DATE
ReasonPAACTREASRequiredWhen PCT-REASON != Spaces
PCT-COMPANY→CRE-COMPANY
PCT-REASON→CRE-ACT-REASON-CD
—→CRE-ACTION-CODE

Programs

Updated by (82)

Referenced by (46)