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 |