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
HCRE.1 HR00.1 HR170 HR200 HR70.1 LT101
LT111 PA105 PA223 PA257 PA355 PA50.1
PA54.1 PA594 PA66.3 PA66.4 HR51.2 HR51.6
PA102 PA13.1 PA13.2 PA52.1 PA52.2 PA52.3
PA52.4 PA52.5 PR282


UPDATED BY
PA57.1 PA57.2 PA57.3

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 LT101
LT111 PA105
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
LT101 LT111
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: Thu Jun 09 02:24:51 2016

Home
Contact Us



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