| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
RIGHTS_LOST_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
AFI - Rights Lost
|
| 4 |
LABOR_RLTNSHIP_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Special Labor Relationship
|
| 5 |
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
|
| 6 |
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
|
| 7 |
ACTION_FLAG |
Character(2) |
VARCHAR2(2) NOT NULL |
Action Flag
|
| 8 |
PREV_EFFDT |
Date(10) |
DATE |
Work field
|