| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 4 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 5 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 6 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 7 |
AFI_SS_ACTION_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Actions to report to the Social Security through the affiliation report
|
| 8 |
SOC_SEC_RISK_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Social Security Risk Code
|
| 9 |
SCHEME_ID_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Scheme ID - ESP
|
| 10 |
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
|
| 11 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 12 |
CONTRACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Type
|
| 13 |
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
|
| 14 |
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.
|
| 15 |
WOMAN_SBRPRSNT_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Woman Subrepresented
Y/N Table Edit
|
| 16 |
PART_TIME_PERC_ESP |
Number(3,0) |
SMALLINT NOT NULL |
Percentage of Part Time
|
| 17 |
INACTIVITY_TYP_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
Inactivity Type
|
| 18 |
PART_STRK_ACT_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Partial Strike Activity Coeff.
|
| 19 |
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
|
| 20 |
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
Y/N Table Edit
|
| 21 |
FIRST_SELFWRKR_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
First self employer worker
Y/N Table Edit
|
| 22 |
SOC_EXCLUSION_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Exclusion
|
| 23 |
ACTIVE_RENT_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Security Active Rent
Y/N Table Edit
|
| 24 |
PART_SUBROGTN_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Subrogation
Y/N Table Edit
|
| 25 |
LABOR_RLTNSHIP_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Special Labor Relationship
|
| 26 |
SUSBTIT_EMPLID_ESP |
Character(11) |
VARCHAR2(11) NOT NULL |
Substitution Emplid
|
| 27 |
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
|
| 28 |
MATERNTY_2YRS_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
IT per illness
Y/N Table Edit
|
| 29 |
AFI_NODE_STATS_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Node Status
0=AFI Sent Confirmed
1=Included in AFI
2=Not Communicated
|
| 30 |
AFI_FILE_NAME_ESP |
Character(20) |
VARCHAR2(20) NOT NULL |
Social Security affiliation report file name
|
| 31 |
TIME_STAMP_ESP |
DateTime(26) |
TIMESTAMP |
Time Stamp
|
| 32 |
AFI_REPORTBY_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Node Status
0=AFI File
1=On Line
|
| 33 |
AFI_DATASOURCE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Node Status
0=Other
C=Contract
J=Job Data Message
P=Pension Plan
|
| 34 |
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
|
| 35 |
BGN_DT |
Date(10) |
DATE |
Begin Date
|
| 36 |
END_DT |
Date(10) |
DATE |
end date
|
| 37 |
VACN_NOT_TAKEN_ESP |
Number(2,0) |
SMALLINT NOT NULL |
Vacation Not Taken Days
|
| 38 |
RELV_CONTRCT_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Relieve Contract Flag
Y/N Table Edit
|
| 39 |
CONTRACT_BEGIN_DT |
Date(10) |
DATE |
Contract Begin Date
|
| 40 |
VACN_END_DT_ESP |
Date(10) |
DATE |
Vacation Not Taken Days
|
| 41 |
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
|
| 42 |
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
|
| 43 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 44 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 45 |
SSN_EMPLOYER |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Social Security number
|
| 46 |
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.
|
| 47 |
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
|
| 48 |
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.
|
| 49 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 50 |
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
|
| 51 |
RIGHTS_LOST_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
AFI - Rights Lost
|
| 52 |
AGRO_EMPLMNT_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Security AFI Tested data
Y/N Table Edit
|
| 53 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 54 |
REMOVE_PHONE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Remove SMS Phone
Y/N Table Edit
|
| 55 |
INSERT_ROW |
Character(1) |
VARCHAR2(1) NOT NULL |
Insert Row
Y/N Table Edit
|
| 56 |
CNT_EVENT_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Action
001=Affiliation
002=Unregister
003=Change in Contract
004=Erase Previous Data
005=Labor Agreement Communictn
006=Additional Situations
007=Worked Days Registration
008=Suspension Period
009=Additional Bases Communication
|
| 57 |
CNT_EVENT_RSN_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Contract Action
|
| 58 |
REASON |
Character(30) |
VARCHAR2(30) NOT NULL |
Reason
|
| 59 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
|
| 60 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
|
| 61 |
BUNDLE91_20 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 62 |
BUNDLE91_16 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 63 |
BUNDLE91_13 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 64 |
BUNDLE91_10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 65 |
BUNDLE91_07 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 66 |
BUNDLE91_05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 67 |
BUNDLE91_03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 68 |
BUNDLE91_01 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 69 |
SELECT_LIST_CNT |
Long Character |
CLOB |
Select List
|
| 70 |
SELECT_LIST_INC |
Long Character |
CLOB |
Select List
|
| 71 |
BUNDLE90_11 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 72 |
BUNDLE90_14 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 73 |
BUNDLE90_16 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 74 |
BUNDLE90_20 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 75 |
BUNDLE90_23 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 76 |
BUNDLE90_25 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 77 |
BUNDLE90_26 |
Character(1) |
VARCHAR2(1) NOT NULL |
Bundle Flag
|
| 78 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|