PERSACTYPE FILE
Personnel Action Code
The Personnel Action Code file contains information about personnel actions.
PA50.1 (Action) is the primary program that updates this file.
REFERENCED BY
BN16.2 BN16.3 BN16.4 BN216 HC02.3 HPAT.1
HR04.4 HR04.5 HR04.6 HR200 HR521 HR704
PA102 PA115 PA13.1 PA13.2 PA213 PA248
PA250 PA272 PA311 PA341 PA370 PA53.1
PA54.1 PA66.1 PA66.2 PA66.3 PA66.4 UK10.1
UK110 UK210
UPDATED BY
PA100 PA50.1 PA52.4 PA56.1 HR00.1 HR01.1
PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAT-COMPANY Numeric 4 PA50.1 PA52.4
Company Contains the company number which
represents an established company.
PAT-ACTION-CODE Alpha 10 PA50.1 PA52.4
Action Code Contains the code that represents the
personnel action.
PAT-DESCRIPTION Alpha 30 (Lower Case) PA50.1 PA52.4
Description Contains the description of the
personnel action.
PAT-FLD-NBR Numeric 4 Occurs 36 Times PA50.1
Dictionary Field Contains the data dictionary item
Number number corresponding to the field used
in the personnel action.
PAT-LAST-CMT-SEQ Numeric 4 PA100 PA56.1
Last Comment Contains the last sequence number used
Sequence Number for personnel action comments.
PAT-WEB-AVAILABLE Alpha 1 PA50.1
Web Available Indicates whether the employee can
change information on the Web by using
this action code.
N = No
Y = Yes
PAT-WEB-AVAIL-SUPV Alpha 1 PA50.1
Web Avail Supv Indicates whether the employee's
supervisor can see results of the
action on the web.
1 = Not Available
2 = Direct Supervisor
3 = Indirect Supervisor
4 = Direct; Indirect Supvr
" "
PAT-WEB-IMMEDIATE Alpha 1 PA50.1
Web Immediate Indicates whether an employee or
supervisor can make the action immideate
using the Web.
N = No
Y = Yes
PAT-WORKFLOW-FLAG Alpha 1 PA50.1
Workflow Indicates whether to initiate a workflow
service.
N = No
Y = Yes
PERSACTYPE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PATSET1 COMPANY BN16.2 BN16.3
ACTION-CODE BN16.4 BN216
HC02.3 HPAT.1
HR00.1 HR01.1
HR04.4 HR04.5
HR04.6 HR200
HR521 HR704
PA100 PA102
PA115 PA13.1
PA13.2 PA213
PA248 PA250
PA272 PA311
PA341 PA370
PA50.1 PA52.1
PA52.2 PA52.3
...
PERSACTYPE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PAT-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Field Nbr PADICT Required
When PAT-FLD-NBR != Zeroes
PAT-FLD-NBR -> PAD-FLD-NBR
PERSACTYPE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Hist Err HISTERR Delete Cascades
PAT-COMPANY -> HER-COMPANY
PAT-ACTION-CODE -> HER-ACTION-CODE
HER-EMPLOYEE
HER-OBJ-ID
HER-EFFECT-DATE
HER-ACTION-NBR
HER-FLD-NBR
HER-SEQ-NBR
Pers Actions PERSACTION Delete Restricted
PAT-COMPANY -> PCT-COMPANY
PAT-ACTION-CODE -> PCT-ACTION-CODE
PCT-ACTION-TYPE
PCT-EFFECT-DATE
PCT-EMPLOYEE
PCT-ACTION-NBR
Persacthst PERSACTHST Delete Restricted
PAT-COMPANY -> PAH-COMPANY
PAT-ACTION-CODE -> PAH-ACTION-CODE
PAH-EMPLOYEE
PAH-EFFECT-DATE
PAH-ACTION-NBR
|