| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
EMPLMT_SRCH_GBL
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
AFI_SS_ACTION_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Actions to report to the Social Security through the affiliation report
|
| 6 |
SOC_SEC_RISK_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Social Security Risk Code
Prompt Table:
%EDITTABLE12
|
| 7 |
SCHEME_ID_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Scheme ID - ESP
Default Value: 0111
|
| 8 |
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
Prompt Table:
WRK_GRP_ESP_VW
|
| 9 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Default Value: ESP
|
| 10 |
CONTRACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Type
Prompt Table:
PERS_CNTRCT_TYP
|
| 11 |
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
|
| 12 |
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.
|
| 13 |
WOMAN_SBRPRSNT_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Woman Subrepresented
Y/N Table Edit
|
| 14 |
PART_TIME_PERC_ESP |
Number(3,0) |
SMALLINT NOT NULL |
Percentage of Part Time
|
| 15 |
INACTIVITY_TYP_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
Inactivity Type
|
| 16 |
PART_STRK_ACT_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Partial Strike Activity Coeff.
|
| 17 |
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
|
| 18 |
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
|
| 19 |
FIRST_SELFWRKR_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
First self employer worker
Y/N Table Edit
|
| 20 |
SOC_EXCLUSION_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Exclusion
Default Value: 0
|
| 21 |
ACTIVE_RENT_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Security Active Rent
Y/N Table Edit
|
| 22 |
PART_SUBROGTN_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Subrogation
Y/N Table Edit
|
| 23 |
LABOR_RLTNSHIP_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Special Labor Relationship
|
| 24 |
SUSBTIT_EMPLID_ESP |
Character(11) |
VARCHAR2(11) NOT NULL |
Substitution Emplid
Prompt Table:
PERS_SRCH_GBL
|
| 25 |
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
|
| 26 |
MATERNTY_2YRS_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
IT per illness
Y/N Table Edit
|
| 27 |
AFI_NODE_STATS_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Node Status
0=AFI Sent Confirmed
1=Included in AFI
2=Not Communicated
|
| 28 |
AFI_FILE_NAME_ESP |
Character(20) |
VARCHAR2(20) NOT NULL |
Social Security affiliation report file name
|
| 29 |
TIME_STAMP_ESP |
DateTime(26) |
TIMESTAMP |
Time Stamp
|
| 30 |
AFI_REPORTBY_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Node Status
0=AFI File
1=On Line
Default Value: 0
|
| 31 |
AFI_DATASOURCE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Node Status
0=Other
C=Contract
J=Job Data Message
P=Pension Plan
Default Value: 0
|
| 32 |
AFI_ASA_TYPE_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
ASA Types for AFI
001=Vacation
002=Gender/Sexual Violence Victims
015=Paid Vacation
150=Expat: No Interntl Instutn
151=Expat: No Ambit Int. Inst.
152=Expat: Exceeded Max Period
153=Expat: Denied Extension
154=Expat: Int Inst no Displaced
301=Own child care
302=Relative child care
303=Own child care public sector
304=Relative child care pub.sector
305=Domestic violence pub.sector
406=Temporary ERE reduction
414=ER SS debtor interm. hostelry
415=Tax debtor interm. hostelry
420=Interm. turism hostelry redn
433=PreDoctoral Extension
434=Activity not Initiated
|
| 33 |
BGN_DT |
Date(10) |
DATE |
Begin Date
|
| 34 |
END_DT |
Date(10) |
DATE |
end date
|
| 35 |
VACN_NOT_TAKEN_ESP |
Number(2,0) |
SMALLINT NOT NULL |
Vacation Not Taken Days
|
| 36 |
RELV_CONTRCT_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Relieve Contract Flag
Y/N Table Edit
Default Value: N
|
| 37 |
CONTRACT_BEGIN_DT |
Date(10) |
DATE |
Contract Begin Date
|
| 38 |
VACN_END_DT_ESP |
Date(10) |
DATE |
Vacation Not Taken Days
|
| 39 |
AFI_DISBL_TYPE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Disability Type
0=Disability >= 33%
1=Permanent Disability Soc Sec
3=Permanent Disability Pass Clss
|
| 40 |
LEGAL_CUSTODY_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Social Security Legal Custody
000=None
016=Legal Custody
017=Legal Custody due Disability
018=Legal Custody due Relatives
019=Sched Red due Breastfeeding
020=Sched Red due Violence
025=Sched Red due Premature Baby
026=Sched Red due Underage Illness
027=Red Underage Illness + Other
Default Value: 000
|
| 41 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 42 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
SOCS_ALL_DEP_VW
|
| 43 |
SSN_EMPLOYER |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Social Security number
Prompt Table:
SOCS_ALL_CCC_VW
|
| 44 |
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.
|
| 45 |
JOB_CHANGE_RSN_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
Social Security Job Change Reasons. This info is needed for AFI File.
Valid Values
01 due Risk in Pregnancy/Brestfeeding
02 due Professional Illness
01=due Risk Pregnancy/Brestfeedng
02=due Professional Illness
03=Worker from ETT
|
| 46 |
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
|
| 47 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 48 |
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
|
| 49 |
RIGHTS_LOST_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
AFI - Rights Lost
|
| 50 |
AGRO_EMPLMNT_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Security AFI Tested data
Y/N Table Edit
|
| 51 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
Prompt Table:
EE_PHONES_ESPVW
|
| 52 |
REMOVE_PHONE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Remove SMS Phone
Y/N Table Edit
Default Value: N
|
| 53 |
ERE_RED_PERC_ESP |
Number(3,0) |
SMALLINT NOT NULL |
Percentage of Temporary ERE reduction
|
| 54 |
ENTREPRENEUR_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Entrepreneur Flag
1=Less 50 Employees
3=Less 10 Employees
|
| 55 |
NOTIFCATN_DT_ESP |
Date(10) |
DATE |
Vacation Not Taken Days
|
| 56 |
READMISSION_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Joined Disabled Employee
Y/N Table Edit
|
| 57 |
LEAVE_BGN_DT_ESP |
Date(10) |
DATE |
Vacation Not Taken Days
|
| 58 |
LEAVE_CCC_ESP |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Social Security number
Prompt Table:
SOCS_ALL_CCC_VW
|
| 59 |
RED_PCT_INI_ESP |
Number(3,0) |
SMALLINT NOT NULL |
Percentage of Part Time
|
| 60 |
SCHD_RED_RSN_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Schedule Reduction Reason
000=None
001=Care Child
002=Care Disabled
003=Family Care
004=Breastfeeding
005=Gender Violence
006=Premature Child Birth
007=Care Child with serious illnes
008=Care Child w Illness + Oth Red
009=Partial Reduction COVID-19
010=Total Reduction COVID-19
Default Value: 000
|
| 61 |
AFI_COLECT_FLG_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Collective Flag
Y/N Table Edit
Default Value: N
|
| 62 |
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
|
| 63 |
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
Default Value: 00
|
| 64 |
ABS_BGN_DT |
Date(10) |
DATE |
Absence Begin Date
|
| 65 |
ABS_END_DT |
Date(10) |
DATE |
Absence End Date
|
| 66 |
PIT_PRST_TYPE_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
Eligibility Youth Support for SS
IT=Temp Disability
SI=Risk in Pregnancy
SL=Risk in Lactancy
SM=Maternity
SP=Paternity
|
| 67 |
PIT_REASON_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Period IT Reason
1=Common Disease
2=Accident
3=Accident at Work
4=Occupatnl Disease
5=Observtn Period OD
|
| 68 |
PIT_PAY_TYPE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Period IT Pay Type
1=Direct Pay
3=Colaborate Ent Pay
4=Benefit Excluded
8=Other
9=No Benefit Rights
|
| 69 |
PIT_PRST_ENDDT_ESP |
Date(10) |
DATE |
Period IT Reason
|
| 70 |
PIT_MAPA_RSN_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Period IT Maternity Reason
1=Maternity/Childbirth
2=Multiple Birth
3=Death of Mother
4=Adoption
5=Placement
6=Other Progenitor
|
| 71 |
PIT_ECO_EFF_DT_ESP |
Date(10) |
DATE |
Period IT Reason
|
| 72 |
PIT_ATEP_DT_ESP |
Date(10) |
DATE |
Period IT Reason
1=Common Disease
2=Accident
3=Accident at Work
4=Occupational Disease
5=Observation Period Occ Disease
|
| 73 |
AFI_CNT_END_DT_ESP |
Date(10) |
DATE |
Expected Contract End Date. Data to be informed in AFI File for those employees in 'Excedencia' status and contract 4XX or 5XX
|
| 74 |
NEW_BGN_DT_ESP |
Date(10) |
DATE |
New Begin Date
|
| 75 |
NEW_END_DT_ESP |
Date(10) |
DATE |
New End Date
|
| 76 |
SPECIAL_COEFF_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
Activity Coefficient
33=1.33
61=1.61
|
| 77 |
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
|