| # |
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 Rcd Nbr
|
| 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 |
Occupation 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
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
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
M=Part Time<333. RDL 2/2009
P=RDL 3/2014 - Fix rate
R=RDL 1/2015 Reduced rate
|
| 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(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
|
| 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
Y/N Table Edit
|
| 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 Employee
0=None
1=Social Exclusion
2=Domestic Violence Victim
3=Gender Violence Victim
4=Soc Excl - Insertion Itinerary
5=Soc Excl - Relapse
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
|
| 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
J=Job Data Message
Default Value: 0
|
| 32 |
AFI_ASA_TYPE_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
ASA Types for AFI
001=PTO not Taken
002=Domestic Violence
|
| 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
|
| 49 |
RIGHTS_LOST_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
AFI - Rights Lost
01=No Meet Requirements
02=Employer debtor to Soc. Sec.
03=New Permanent cntrct prev 24m
04=New Temporary cntrct prev 6m
05=New Permanent cntrct prev 3m
06=Public Administration
07=Lack temporary contract prior
08=Extintn Bonif Contrct Last 12m
09=Company w/o insertn conditn
11=Debtor at the right start date
12=Hiring after deadline
20=Fail fulfill Tax Obligatn (OT)
21=Tax debts (DT)
22=Fail to fulfill OT + DT
23=Unregister census detected(BC)
24=Fiscal offense (DF)
25=Fail to fulfill OT + DT + DF
26=Fail to fulfill OT + DF
27=DT+DF
28=Fail to fulfill OT + DT + BC
29=DT + BC
30=DF + BC
31=Fail to fulfill OT + DT+DF+BC
32=Fail to fulfill OT + BC + DF
33=DT + DF + BC
34=Fail to fulfill OT + DT + BC
41=Fail fulfill maintain employmn
42=No application conditions CEE
43=Company >= to 50 employees.
|
| 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
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
Default Value: 000
|
| 63 |
AFI_YOUTH_SUPP_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
Eligibility Youth Support for SS
01=Dummy Text
Default Value: 00
|