PAACTREAS

This table is used to hold reason codes. The reason codes can be generic and used for any personnel action or defined specifically for one of more personnel actions.

REFERENCED BY
HR00.1 HR170 HR200 HR70.1 PA223 PA355
PA50.1 PA54.1 PA594 PA66.3 PA66.4


UPDATED BY
PA57.1 PA57.2 PA57.3 HCRE.1 PA257 HR51.2
HR51.6 PA102 PA13.1 PA13.2 PA52.1 PA52.2
PA52.3 PA52.4 PA52.5 PR282

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRE-COMPANY
Element: Hr Company		Numeric 4
Contains the HR company.
PA57.1 PA57.2
PA57.3
CRE-ACT-REASON-CD
Element: Reason		Alpha 10
This is the reason code that can be used for actions with a specific action code or in general.
PA57.1 PA57.2
PA57.3
CRE-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
PA57.1 PA57.2
PA57.3
CRE-ACTION-CODE
Element: Action Code		Alpha 10
PA57.1 PA57.2
PA57.3
CRE-ACTIVE-FLAG
Element: Active Flag		Alpha 1
The Active flag of the reason code.
1 = Active
2 = Inactive
PA57.1 PA57.2
PA57.3
CRE-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
PA57.1 PA57.2
PA57.3
CRE-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
PA57.1 PA57.2
PA57.3
CRE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
PA57.1 PA57.2
PA57.3


PAACTREAS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRESET1 COMPANY
ACT-REASON-CD
ACTION-CODE
HCRE.1 HR00.1
HR170 HR200
HR70.1 PA223
PA257 PA355
PA50.1 PA54.1
PA57.1 PA57.2
PA57.3 PA594
PA66.3 PA66.4
CRESET2 COMPANY
ACTION-CODE
ACT-REASON-CD
PA57.3
CRESET3 COMPANY
ACT-REASON-CD
ACTION-CODE
Subset
Where(ACTION-CODE =Spaces)
HR51.2 HR51.6
PA102 PA13.1
PA13.2 PA52.1
PA52.2 PA52.3
PA52.4 PA52.5
PA57.1 PA57.3
PR282
CRESET4 COMPANY
ACTION-CODE
ACT-REASON-CD
Subset
Where(ACTION-CODE !=Spaces)
HR51.2 HR51.6
PA102 PA13.1
PA13.2 PA257
PA52.1 PA52.2
PA52.3 PA52.4
PA52.5 PA57.3
CRESET5 COMPANY
ACT-REASON-CD
ACTION-CODE
Subset
Where(ACTION-CODE !=Spaces)
PA257 PA57.1
PA57.2


PAACTREAS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Action Code PERSACTYPE Required
When (CRE-ACTION-CODE !=Spaces )
CRE-COMPANY->PAT-COMPANY
CRE-ACTION-CODE->PAT-ACTION-CODE
Company PRSYSTEM Required
CRE-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL

File created: Wed Jun 08 20:50:22 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.