ACT_RSN_TBL_ESP (SQL Table)	Index Back
Action/Reason Combinations ACTN_REASON_TBL is an edit table. Use it to record combinations of action codes and the reason codes that are valid for an action. For example, two valid reasons for a termination action might be attendance and misconduct.

ACT_RSN_TBL_ESP

(SQL Table)

Action/Reason Combinations

ACTN_REASON_TBL is an edit table. Use it to record combinations of action codes and the reason codes that are valid for an action. For example, two valid reasons for a termination action might be attendance and misconduct.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: ACTION_TBL

2 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
Prompt Table: ACTN_REASON_TBL

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 AFI_EE_STATUS_ESP Character(2) VARCHAR2(2) NOT NULL Social Security AFI Employee Status
01=Hire
51=Voluntary / Resignation
53=Individual Disciplinary Dismis
54=Non Voluntary Termination
55=Termination by Takeover
56=Termination by Death
58=Termination by Retirement
61=Termination by Military Serv
61=Termination by Military Serv
63=Termination by Voluntary Leave
65=Termination by End of IT
67=Termination by Seasonal Layoff
68=Termination by Maternity
69=Termination by ERE Suspension
73=Termination by Dependent Care
74=Other Term. by Suspension
76=Term by Domestic Violence
77=Mass dismissal
80=Susp by Domestic Violence
85=End of Test Period
91=TER Objective Reasons. Worker
92=TER Objective Reason. Company
93=TER End of Contract
94=Inactivity in Permanent Interm
99=Other Termination Reasons

5 AFI_SS_ACTION_ESP Character(3) VARCHAR2(3) NOT NULL Actions to report to the Social Security through the affiliation report

6 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
2	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	AFI_EE_STATUS_ESP	Character(2)	VARCHAR2(2) NOT NULL	Social Security AFI Employee Status 01=Hire 51=Voluntary / Resignation 53=Individual Disciplinary Dismis 54=Non Voluntary Termination 55=Termination by Takeover 56=Termination by Death 58=Termination by Retirement 61=Termination by Military Serv 61=Termination by Military Serv 63=Termination by Voluntary Leave 65=Termination by End of IT 67=Termination by Seasonal Layoff 68=Termination by Maternity 69=Termination by ERE Suspension 73=Termination by Dependent Care 74=Other Term. by Suspension 76=Term by Domestic Violence 77=Mass dismissal 80=Susp by Domestic Violence 85=End of Test Period 91=TER Objective Reasons. Worker 92=TER Objective Reason. Company 93=TER End of Contract 94=Inactivity in Permanent Interm 99=Other Termination Reasons
5	AFI_SS_ACTION_ESP	Character(3)	VARCHAR2(3) NOT NULL	Actions to report to the Social Security through the affiliation report
6	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Y/N Table Edit Default Value: N