AFI_RC_EE_ESP (SQL Table)	Index Back
AFI RC Action Employee ESP AFI RC Regular Action Employee

AFI_RC_EE_ESP

(SQL Table)

AFI RC Action Employee ESP

AFI RC Regular Action Employee

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERS_SRCH_GBL

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

5 ACTION_DT Date(10) DATE Action Date

6 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
Default Value: 0

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

8 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
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

9 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number

10 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

11 AFI_PRINT_FLG_ESP Character(1) VARCHAR2(1) NOT NULL ASA Types for AFI
C=Print Resolution + IDC
I=Contribution Data Report (IDC)
N=No
S=Print Resolution
Default Value: N

12 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

13 CNT_EVENT_ESP Character(3) VARCHAR2(3) NOT NULL Contract Action
001=Affiliation
002=Unregister
003=Change in Contract
004=Erase Previous Data
005=Labor Agreement Communictn
006=Additional Situations
007=Worked Days Registration
008=Suspension Period
009=Additional Bases Communication

14 CNT_EVENT_RSN_ESP Character(4) VARCHAR2(4) NOT NULL Contract Action

15 AFI_NODE_STATS_ESP Character(1) VARCHAR2(1) NOT NULL Node Status
0=AFI Sent Confirmed
1=Included in AFI
2=Not Communicated

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	ACTION_DT	Date(10)	DATE	Action Date
6	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence Default Value: 0
7	AFI_SS_ACTION_ESP	Character(3)	VARCHAR2(3) NOT NULL	Actions to report to the Social Security through the affiliation report
8	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 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
9	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
10	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
11	AFI_PRINT_FLG_ESP	Character(1)	VARCHAR2(1) NOT NULL	ASA Types for AFI C=Print Resolution + IDC I=Contribution Data Report (IDC) N=No S=Print Resolution Default Value: N
12	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
13	CNT_EVENT_ESP	Character(3)	VARCHAR2(3) NOT NULL	Contract Action 001=Affiliation 002=Unregister 003=Change in Contract 004=Erase Previous Data 005=Labor Agreement Communictn 006=Additional Situations 007=Worked Days Registration 008=Suspension Period 009=Additional Bases Communication
14	CNT_EVENT_RSN_ESP	Character(4)	VARCHAR2(4) NOT NULL	Contract Action
15	AFI_NODE_STATS_ESP	Character(1)	VARCHAR2(1) NOT NULL	Node Status 0=AFI Sent Confirmed 1=Included in AFI 2=Not Communicated