AFI_RC_EE_ESP

#	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 Rcd Nbr
5	ACTION_DT	Date(10)	DATE	Action Date
6	AFI_SS_ACTION_ESP	Character(3)	VARCHAR2(3) NOT NULL	Actions to report to the Social Security through the affiliation report
7	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence Default Value: 0
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 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