 |
Lawson Insight Technical Documentation |
|
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
PA115 PA120 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 PR36.1 PR45.1 PR529 PR530
PR560 PR80.1 PR82.1 UK102 TA147 UK120
PA50.1
UPDATED BY
HC02.3 HCOP.2 HR11.1 HR11.2 HR15.1 HR155
HR170 HR511 HR515 HR54.1 HR55.2 HR55.3
HR65.6 HR65.8 HR650 HR70.1 HRS1.1 HRSC.1
PA02.1 PA100 PA102 PA113 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 PRSC.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 HR11.2
Change the employee for the associated field. HR15.1 HR155
HR170 HR511
HR515 HR54.1
HR55.2 HR55.3
HR65.6 HR65.8
HR650 HR70.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
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 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
TR21.1 TR22.1
TR26.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 PA52.4
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.4 PA52.5
Y = Yes UK110
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.5 UK110
represents a type of job.
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 PA52.1 PA52.2
Base Currency Contains the base currency of the PA52.5
company.
PCT-BASE-ND Numeric 1 PA52.1 PA52.2
Base Number Of The number of decimal positions defined PA52.5 UK110
Decimals for the company base currency.
PCT-BASE-PAY-RATE Signed 13.4 PA52.1 PA52.2
Base Pay Rate Contains the pay in the company's base PA52.5 UK110
currency.
PCT-MERGE-ACTN-NBR Numeric 4 PA52.1 PA52.5
Merge Actn Nbr
PCT-HIST-CORR-FLAG Alpha 2 PA52.1 PA52.2
Hist Corr Flag Indicates 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
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 HR11.1 HR11.2
EFFECT-DATE HR15.1 HR155
ACTION-CODE HR170 HR511
EMPLOYEE HR515 HR54.1
ACTION-NBR HR55.1 HR55.2
HR55.3 HR65.6
HR65.8 HR650
HR70.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
...
PCTSET2 COMPANY AC541 AC542
ACTION-TYPE BN150 HR11.1
EMPLOYEE HR11.2 HR511
ACTION-CODE HR521 HR650
EFFECT-DATE PA02.1 PA100
ACTION-NBR* PA102 PA115
PA120 PA13.1
PA13.2 PA272
PA502 PA513
PA52.1 PA52.2
PA52.3 PA52.4
PA52.5 PA53.1
PA54.1 PR110
PR113 PR120
PR128 PR13.1
...
PCTSET3 COMPANY PA100 PA272
ACTION-CODE PA50.1 PA52.1
ACTION-TYPE PA52.2 PA52.3
EFFECT-DATE PA52.5
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
|