WKF_CNT_AFI_ESP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	PART_SUBROGTN_ESP	Character(1)	VARCHAR2(1) NOT NULL	Partial Subrogation Y/N Table Edit
5	SUSBTIT_EMPLID_ESP	Character(11)	VARCHAR2(11) NOT NULL	Substitution Emplid Prompt Table: PERS_SRCH_GBL
6	SUSBTIT_REASON_ESP	Character(2)	VARCHAR2(2) NOT NULL	Substitution Reasons 01=Extended LOA 02=Maternity or Pregnacy Risk 03=Retirement at 64 04=Disabled Employee 05=Disable Employee on IT 06=Gender Violence Victims 07=Incentivated EE 09=Sexual Violence 10=Birthcare/Risk Preg/Breastfeed
7	CONTRACT_BEGIN_DT	Date(10)	DATE	Initial Contract Begin Dt
8	SOCS_LBR_AGRMT_ESP	Character(14)	VARCHAR2(14) NOT NULL	Social Security Labor Agreement. Special codification following Social Security tables. This info is needed for AFI File. Prompt Table: SOCS_AGRMNT_ESP
9	WOMAN_SBRPRSNT_ESP	Character(1)	VARCHAR2(1) NOT NULL	Woman Subrepresented Y/N Table Edit
10	UNEMPLYMNT_CND_ESP	Character(1)	VARCHAR2(1) NOT NULL	Unemployment Condition 1=Booked in Unemployment Office 2=Booked in Office more than 12 3=Agricultural 4=With subsidy over one year 5=Booked in Office more than 6 m 6=With One-yr-remaining Subsidy 7=W/ subsidy. Older than 52 yrs. A=W/ Benefit. RDL 2/2009 B=With Employability Problems C=Unemployed at 1-1-2011 D=Unemployed at 1-1-2011. 12/18 E=Unemployed 16-08-2011 F=Unemployed with Family support G=Unemployed >6 m. Fam Support H=Under 3 m. of work experience I=Unemployed from another sector J=Youth Employment K=Unemployed w/o Education Certf L=Unemployed >12m last 18 months M=Part Time<333. RDL 2/2009 P=RDL 3/2014 - Fix rate R=RDL 1/2015 Reduced rate W=Collective Excl. from regist.
11	WOMAN_HRD_AFTR_ESP	Character(1)	VARCHAR2(1) NOT NULL	Woman Hired 24 months after M. 2=Superimposition Second Rejoin 3=Less than 5 years in Inactivty 4=Rehire after Extended Leave S=Rejoin After 2 Years Maternity
12	RE_JOIN_DSB_EE_ESP	Character(1)	VARCHAR2(1) NOT NULL	Re-Joined Disabled Employee 1=Readmitted Back to Work 2=Readmit. Perm part. Disablty 3=Readmit>55Inc Perm.Perm.OthCat 4=Readmit>55Inc.Perm.OthCat 5=Lmtd Intellectual Disability S=Readmitted
13	FIRST_SELFWRKR_ESP	Character(1)	VARCHAR2(1) NOT NULL	First self employer worker Y/N Table Edit
14	SOC_EXCLUSION_ESP	Character(1)	VARCHAR2(1) NOT NULL	Social Exclusion
15	ACTIVE_RENT_ESP	Character(1)	VARCHAR2(1) NOT NULL	Social Security Active Rent Y/N Table Edit
16	LABOR_RLTNSHIP_ESP	Character(4)	VARCHAR2(4) NOT NULL	Special Labor Relationship
17	MATERNTY_2YRS_ESP	Character(1)	VARCHAR2(1) NOT NULL	IT per illness Y/N Table Edit
18	RELV_CONTRCT_ESP	Character(1)	VARCHAR2(1) NOT NULL	Relieve Contract Flag Y/N Table Edit Default Value: N
19	AFI_WORK_DAYS_ESP	Number(3,0)	SMALLINT NOT NULL	Social Security Part Time Worked Days. Part Time employees must report the number of worked days per month. This info is needed for AFI File.
20	FAMILY_BOND_ESP	Character(1)	VARCHAR2(1) NOT NULL	Family Bond 1=Family Member up to Second Deg 3=Descendant younger than 30 yrs 4=Family Member younger than 45 5=Child with qualif. Disability 9=Resp Dec Non-exist Family Ties I=Child <30 years Law 6/2017 J=Fam Mem up to 2nd Deg L6/2017 K=Child 30 Qualif Disab L 6/2017
21	RIGHTS_LOST_ESP	Character(2)	VARCHAR2(2) NOT NULL	AFI - Rights Lost
22	AGRO_EMPLMNT_ESP	Character(1)	VARCHAR2(1) NOT NULL	Social Security AFI Tested data Y/N Table Edit
23	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone Prompt Table: EE_PHONES_ESPVW
24	REMOVE_PHONE_ESP	Character(1)	VARCHAR2(1) NOT NULL	Remove SMS Phone Y/N Table Edit Default Value: N
25	SOC_SEC_WRK_GRP_CD	Character(2)	VARCHAR2(2) NOT NULL	Social Security Work Group 01=01-Engineers 02=02-Technicals 03=03-Administrative 04=04-Assistants 05=05-White Collar 06=06-Subordinates 07=07-Administrative assistants 08=08-1st and 2nd degree 09=09-3rd degree 10=10-Over 18 years 11=11-Under 18 years
26	CNTRB_MONTHLY_ESP	Character(1)	VARCHAR2(1) NOT NULL	Daily employee contributing as Monthly flag Y/N Table Edit Default Value: N
27	ENTREPRENEUR_ESP	Character(1)	VARCHAR2(1) NOT NULL	Entrepreneur Flag 1=Less 50 Employees 3=Less 10 Employees Default Value: N
28	AFI_COLECT_FLG_ESP	Character(1)	VARCHAR2(1) NOT NULL	Special Collective Flag Y/N Table Edit Default Value: N
29	AFI_COLLECTIVE_ESP	Character(3)	VARCHAR2(3) NOT NULL	Special Collective 000=None 951=Adviser w/ Work Contract 952=Adviser w/ Commercial Contract 967=CT Production Reason 968=CT Predictive Production Reasn 969=CT Empl. Activation program 970=CT Plan for recovery Default Value: 000
30	AFI_YOUTH_SUPP_ESP	Character(2)	VARCHAR2(2) NOT NULL	Eligibility Youth Support for SS 00=Non Eligible 01=Requested 11=Accredited 14=SS Acredited 15=Conversion to Bonification 16=Benef SNGJ-Low qualification 17=Ceuta and Melilla 18=Practical Trng CoopLbr Society 19=Training Art23 RDL 1/2023 20=Conversion FD Art29 RDL 1/2023 21=Partners Art28 RDL 1/2023
31	SPECIAL_COEFF_ESP	Character(2)	VARCHAR2(2) NOT NULL	Activity Coefficient 33=1.33 61=1.61
32	SPECIAL_SCHEME_ESP	Character(2)	VARCHAR2(2) NOT NULL	Special SS Scheme: - 32 Fruit, vegetables and canned vegetables - 35 Hotel Services - 36 Films exhibition and Similarly - 37 Public opinion 32=Fruit, vegetables/canned veg 35=Hotel Services 36=Films exhibition and Similarly 37=Public opinion
33	CNTB_EXCLUSION_ESP	Character(3)	VARCHAR2(3) NOT NULL	Contribution Exclusion Prompt Table: CNTB_EXCLSN_ESP
34	DBA_RSN_ESP	Character(1)	VARCHAR2(1) NOT NULL	Additional Bases Reason Y/N Table Edit
35	RED_RETMNT_FCT_ESP	Number(2,0)	SMALLINT NOT NULL	Reduced Retirement Age Factor
36	CASIA_REPORT_ESP	Character(11)	VARCHAR2(11) NOT NULL	CASIA Report