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.

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 4PA52.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 2PA52.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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PCTSET1COMPANY, ACTION-TYPE, EFFECT-DATE, ACTION-CODE, EMPLOYEE, ACTION-NBRPrimaryBN305, HC02.5, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +22 more (list truncated in source)
PCTSET2COMPANY, ACTION-TYPE, EMPLOYEE, ACTION-CODE, EFFECT-DATE, ACTION-NBR*BN150, BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR521 +22 more (list truncated in source)
PCTSET3COMPANY, ACTION-CODE, ACTION-TYPE, EFFECT-DATE, EMPLOYEE, ACTION-NBR*PA100, PA272, PA50.1, PA52.1, PA52.2, PA52.3, PA52.5
PCTSET4COMPANY, EMPLOYEE, ACTION-TYPE, ACTION-CODE, EFFECT-DATE, ACTION-NBRPA58.1

Relations

One to one (18) — lookups and parents

RelationTableRulesConditionField map
Action CodePERSACTYPERequiredPCT-COMPANYPAT-COMPANY, PCT-ACTION-CODEPAT-ACTION-CODE
ApplicantAPPLICANTRequiredWhen PCT-ACTION-TYPE = "A"PCT-COMPANYAPL-COMPANY, PCT-EMPLOYEEAPL-APPLICANT
Base CurrencyCUCODESRequiredWhen PCT-BASE-CURRENCY != SpacesPCT-BASE-CURRENCYCUC-CURRENCY-CODE
CompanyPRSYSTEMRequiredPCT-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL
DepartmentDEPTCODERequiredWhen PCT-DEPARTMENT != SpacesPCT-COMPANYDPT-COMPANY, PCT-PROCESS-LEVELDPT-PROCESS-LEVEL, PCT-DEPARTMENTDPT-DEPARTMENT
Emp GroupPERSGROUPRequiredWhen PCT-PERS-GROUP != SpacesPCT-COMPANYPRG-COMPANY, PCT-PERS-GROUPPRG-GROUP-NAME
EmployeeEMPLOYEERequiredWhen PCT-ACTION-TYPE = "E"PCT-COMPANYEMP-COMPANY, PCT-EMPLOYEEEMP-EMPLOYEE
Field NbrPADICTRequiredWhen PCT-FLD-NBR != ZeroesPCT-FLD-NBRPAD-FLD-NBR
JobcodeJOBCODERequiredWhen (PCT-JOB-CODE != Spaces)PCT-COMPANYJBC-COMPANY, PCT-JOB-CODEJBC-JOB-CODE
LocationPCODESRequiredWhen PCT-LOCAT-CODE != Spaces"LO"PCO-TYPE, PCT-LOCAT-CODEPCO-CODE
Occur TypeOCCURTYPERequiredWhen PCT-OCCUR-TYPE != SpacesPCT-COMPANYOCC-COMPANY, PCT-OCCUR-TYPEOCC-OCCUR-TYPE
PaemployeePAEMPLOYEERequiredWhen PCT-ACTION-TYPE = "E"PCT-COMPANYPEM-COMPANY, PCT-EMPLOYEEPEM-EMPLOYEE
ParticipantPARTICIPNTRequiredWhen PCT-PARTICIPNT != ZeroesPCT-COMPANYPAR-COMPANY, PCT-PARTICIPNTPAR-PARTICIPNT
Process LevelPRSYSTEMRequiredWhen PCT-PROCESS-LEVEL != SpacesPCT-COMPANYPRS-COMPANY, PCT-PROCESS-LEVELPRS-PROCESS-LEVEL
RequisitionPAJOBREQRequiredWhen (PCT-REQUISITION != Zeroes)PCT-COMPANYPJR-COMPANY, PCT-REQUISITIONPJR-REQUISITION
SupervisorHRSUPERRequiredWhen PCT-SUPERVISOR != SpacesPCT-COMPANYHSU-COMPANY, PCT-SUPERVISORHSU-CODE
UnionPCODESRequiredWhen PCT-UNION-CODE != Spaces"UN"PCO-TYPE, PCT-UNION-CODEPCO-CODE
User LevelPCODESRequiredWhen PCT-USER-LEVEL != Spaces"UL"PCO-TYPE, PCT-USER-LEVELPCO-CODE

One to many (6) — child tables

RelationTableRulesConditionField map
CommentsPACOMMENTSPCT-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "PA"PAC-CMT-TYPE, PCT-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, PCT-ACTION-CODEPAC-ACTION-CODE, PCT-ACTION-NBRPAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
Emp Group EmpsPGEMPLOYEEValid When PCT-PERS-GROUP != SpacesPCT-COMPANYPGE-COMPANY, PCT-PERS-GROUPPGE-GROUP-NAME, PGE-EMPLOYEE
Pay PositionPAPOSITIONValid When (PCT-PAY-POSITION != Spaces)PCT-COMPANYPOS-COMPANY, PCT-PAY-POSITIONPOS-POSITION, POS-EFFECT-DATE
Pos Chg ErrorPAPOSERRValid When (PCT-POSITION != Spaces)PCT-COMPANYPPE-COMPANY, PCT-EMPLOYEEPPE-EMPLOYEE, ZeroesPPE-REQUISITION, PCT-POSITIONPPE-POSITION, PPE-EFFECT-DATE, PPE-UPDATE-TYPE
PositionPAPOSITIONRequiredWhen (PCT-POSITION != Spaces)PCT-COMPANYPOS-COMPANY, PCT-POSITIONPOS-POSITION, POS-EFFECT-DATE
ReasonPAACTREASRequiredWhen PCT-REASON != SpacesPCT-COMPANYCRE-COMPANY, PCT-REASONCRE-ACT-REASON-CD, CRE-ACTION-CODE

Programs

Updated by (82)

Referenced by (46)