|
|
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 ET530 ETI2.1 HR521
LP130 PA120 PA182 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 PR35.9 PR36.1 PR45.1
PR529 PR530 PR560 PR80.1 PR82.1 UK102
UK560 TA147 PA50.1
UPDATED BY
BN305 HC02.5 HAP3.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR15.1 HR155 HR170
HR511 HR515 HR54.1 HR55.2 HR55.3 HR65.6
HR65.8 HR70.1 HRS1.1 HRSC.1 LP100 LP101
PA02.1 PA100 PA102 PA113 PA115 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 UK110
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCT-COMPANY Numeric 4 PA100 PA52.1
Element: 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
Element: 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
Element: Effective DateContains 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
Element: 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
Element: Employee NumbeWhen 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
Element: Ant End Date Contains the anticipated ending date of PA52.2 PA52.3
the personnel action. This date is used PA52.4 PA52.5
for references purposes only. UK110
PCT-ACTION-NBR Numeric 4 PA100 PA52.1
Element: Action Nbr 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Group Name 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
Element: 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
Element: Fld Nbr This field identifies (by using the PA52.1 PA52.2
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 BN305 HAP3.1
Element: New Value Contains the new value to be updated to HC02.5 HEP4.1
the employee for the associated field. HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR170
HR511 HR515
HR54.1 HR55.2
HR55.3 HR65.6
HR65.8 HR70.1
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA16.1
PA182 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 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
...
PCT-SALARY-CLASS Alpha 1 PA52.1 PA52.2
Element: 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 PA100 PA52.1
Element: Pct Pay Inc Contains the percent of pay increase. PA52.2
This value is used by P (Mass Pay
Change) actions.
PCT-ROUND-EVEN Signed 9.4 PA100 PA52.1
Element: Round Even Contains the amount to be rounded. This PA52.2
value is used by P (Mass Pay Change)
actions.
PCT-PCT-PAY-DEC Signed 7.3 PA100 PA52.1
Element: Pct Pay Dec Contains the percent decrease of pay. PA52.2
This value is used by type P (Mass Pay
Change) actions.
PCT-ROUND-OPT Alpha 1 PA100 PA52.1
Element: Round Opt Contains the rounding option. This PA52.2
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 PA100 PA52.1
Element: Flat Inc Contains the increase by the flat PA52.2
amount. This value is used by P (Mass
Pay Change) actions.
PCT-FLAT-DEC Signed 13.4 PA100 PA52.1
Element: Flat Dec Contains the amount of decrease by the PA52.2
flat amount. This value is used by P
(Mass Pay Change) actions.
PCT-NEW-RATE Signed 13.4 PA100 PA52.1
Element: Pay Rate Contains the new rate. This value is PA52.2
used by P (Mass Pay Change) actions.
PCT-USER-ID Alpha 10 (Lower Case) PA100 PA52.1
Element: 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
Element: 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
Element: Occur Type Contains 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.
PCT-UPDATE-BENEFIT Alpha 1 PA100 PA52.1
Element: Update BenefitIndicate 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
Element: Pos Level Contains the position level. PA52.2 PA52.3
PA52.4 PA52.5
UK110
PCT-POS-EFF-DT Numeric 8 (yyyymmdd) PA02.1 PA100
Element: 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
Element: Position Contains the user-defined code that PA52.4 PA52.5
represents a position in the company.
PCT-REQUISITION Numeric 9 PA100 PA52.4
Element: Requisition Contains a user-defined code that
represents a requisition.
PCT-JOB-CODE Alpha 9 PA100 PA52.1
Element: 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
Element: Pay Position If the action contains position default
information, this field contains the
position.
PCT-UPDATE-REQ-DED Alpha 1 PA52.1 PA52.4
Element: Update Req DedIndicates 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
Element: 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
Element: Edm End Date Contains the last date you want to take
old required deductions.
PCT-SHORT-TYPE-DES Derived
Element: Short Type Des
PCT-SHORT-NAME Derived
Element: Short Name
PCT-APPROVAL-FLAG Alpha 1 PA52.1 PA52.2
Element: Approval Flag N = No PA52.3 PA52.4
Y = Yes PA52.5 PA53.1
UK110
PCT-WF-PEND-ACT Derived
Element: Wf Pend Act Company
Action Type
Effect Date
Action Code
Employee
Action Nbr
PCT-BASE-CURRENCY Alpha 5 PA52.1 PA52.2
Element: Base Currency Contains the base currency of the PA52.5
company.
PCT-BASE-ND Numeric 1 PA52.1 PA52.2
Element: Base Nd The number of decimal positions defined PA52.5 UK110
for the company base currency.
PCT-BASE-PAY-RATE Signed 13.4 PA52.1 PA52.2
Element: Pay Rate Contains the pay in the company's base PA52.5 UK110
currency.
PCT-MERGE-ACTN-NBR Numeric 4 PA52.1 PA52.5
Element: Merge Actn Nbr
PCT-HIST-CORR-FLAG Alpha 2 PA52.1 PA52.2
Element: Hist Corr FlagIndicates 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
Element: 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
5 = Move From Level
PCT-POS-LEVEL-MOVE Numeric 2 PA52.1 PA52.5
Element: Pos Level Move
PCT-UPD-ABS-MGMT Alpha 1 PA100 PA52.1
Element: Upd Abs Mgmt N = No PA52.2 PA52.3
Y = Yes PA52.4 PA52.5
PERSACTION FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCTSET1 COMPANY BN305 HC02.5
ACTION-TYPE HAP3.1 HEP4.1
EFFECT-DATE HPOS.1 HPQC.1
ACTION-CODE HPRS.1 HR11.1
EMPLOYEE HR11.2 HR15.1
ACTION-NBR HR155 HR170
HR511 HR515
HR54.1 HR55.1
HR55.2 HR55.3
HR65.6 HR65.8
HR70.1 HRS1.1
HRSC.1 LP100
LP101 PA02.1
PA100 PA102
PA113 PA115
...
PCTSET2 COMPANY BN150 BN305
ACTION-TYPE ET530 ETI2.1
EMPLOYEE HR11.1 HR11.2
ACTION-CODE HR511 HR521
EFFECT-DATE LP130 PA02.1
ACTION-NBR* PA100 PA102
PA115 PA120
PA13.1 PA13.2
PA182 PA272
PA502 PA513
PA52.1 PA52.2
PA52.3 PA52.4
PA52.5 PA53.1
PA54.1 PR110
PR113 PR120
...
PCTSET3 COMPANY PA100 PA272
ACTION-CODE PA50.1 PA52.1
ACTION-TYPE PA52.2 PA52.3
EFFECT-DATE PA52.5
EMPLOYEE
ACTION-NBR*
PCTSET4 COMPANY
EMPLOYEE
ACTION-TYPE
ACTION-CODE
EFFECT-DATE
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 (PATSET1)
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
Paemployee PAEMPLOYEE Required
When PCT-ACTION-TYPE = "E"
PCT-COMPANY -> PEM-COMPANY
PCT-EMPLOYEE -> PEM-EMPLOYEE
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
Valid When PCT-PERS-GROUP != Spaces
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
|
