JOB_WORK_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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
6	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
7	ACTION_DT	Date(10)	DATE	Action Date
8	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
9	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Prompt Table: REG_STANDARD_VW
10	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
11	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number Prompt Table: CNT_ACTIVE_VW
12	CONTRACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Contract Type Prompt Table: PERS_CNTRCT_TYP
13	CONTRACT_TYPE_BEF	Character(3)	VARCHAR2(3) NOT NULL	Contract Type Before AFI Changed
14	SOC_SEC_RISK_CODE	Character(3)	VARCHAR2(3) NOT NULL	Occupation Code
15	SOCS_RISK_CD_B_ESP	Character(3)	VARCHAR2(3) NOT NULL	Social Security Risk Code
16	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
17	LABOR_AGREEMENT_B	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
18	EMPL_CTG	Character(6)	VARCHAR2(6) NOT NULL	Employee Category
19	EMPL_CTG_BEFORE	Character(6)	VARCHAR2(6) NOT NULL	Category Before AFI Changed
20	SOC_SEC_WRK_GRP_CD	Character(2)	VARCHAR2(2) NOT NULL	Social Security Work Group
21	SOCS_WRKGRP_B_ESP	Character(2)	VARCHAR2(2) NOT NULL	Social Security Wrk Group Cd
22	ACTIVE_RENT_ESP	Character(1)	VARCHAR2(1) NOT NULL	Social Security Active Rent Y/N Table Edit
23	FIRST_SELFWRKR_ESP	Character(1)	VARCHAR2(1) NOT NULL	First self employer worker Y/N Table Edit
24	PART_TIME_PERC_ESP	Number(3,0)	SMALLINT NOT NULL	Percentage of Part Time
25	RE_JOIN_DSB_EE_ESP	Character(1)	VARCHAR2(1) NOT NULL	Re-Joined Disabled Employee Y/N Table Edit
26	SOC_EXCLUSION_ESP	Character(1)	VARCHAR2(1) NOT NULL	Social Exclusion Employee 0=None 1=Social Exclusion 2=Domestic Violence Victim 3=Gender Violence Victim 4=Soc Excl - Insertion Itinerary 5=Soc Excl - Relapse Y/N Table Edit
27	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 M=Part Time<333. RDL 2/2009 P=RDL 3/2014 - Fix rate R=RDL 1/2015 Reduced rate
28	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 Y/N Table Edit
29	WOMAN_SBRPRSNT_ESP	Character(1)	VARCHAR2(1) NOT NULL	Woman Subrepresented Y/N Table Edit
30	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
31	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
32	SUSBTIT_EMPLID_ESP	Character(11)	VARCHAR2(11) NOT NULL	Substitution Emplid Prompt Table: PERSON
33	PART_SUBROGTN_ESP	Character(1)	VARCHAR2(1) NOT NULL	Partial Subrogation Y/N Table Edit
34	LABOR_RLTNSHIP_ESP	Character(4)	VARCHAR2(4) NOT NULL	Special Labor Relationship
35	AFI_SS_ACTION_ESP	Character(3)	VARCHAR2(3) NOT NULL	Actions to report to the Social Security through the affiliation report
36	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
37	AFI_SENT	Character(1)	VARCHAR2(1) NOT NULL	Social Security AFI Sent data Y/N Table Edit
38	AFI_TESTED	Character(1)	VARCHAR2(1) NOT NULL	Social Security AFI Tested data
39	AFI_DELETED	Character(1)	VARCHAR2(1) NOT NULL	AFI Deleted
40	INACTIVITY_TYP_ESP	Character(1)	VARCHAR2(1) NOT NULL	Inactivity Type 0=End Inactivity Period 1=Inactivity Period 2=Total Strike 3=Partial Strike 4=Trienniums Public Workers 5=Work Absence 6=Hiring w/o Salary 7=Unpaid Leave 8=Provisional Suspension 9=No Resolved Provisinl Suspn A=Resolved Provisinl Suspensn B=ERE Tot wo Benefit C=ERE Part wo Benefit D=ERE Part wo Bnf&Strk H=Reservist Activation Period I=ERE Tot Force Majeure J=ERE Part Force Majeure K=ERE Part Force Majeure&Strk L=Maternity leave child/fam care
41	PART_STRK_ACT_ESP	Character(3)	VARCHAR2(3) NOT NULL	Partial Strike Activity Coeff.