| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
TRN_T_FNC_AREA_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Functional Area
1=Management
2=Administration
3=Commercial
4=Maintenance
5=Production
|
| 5 |
CATEGORY_FORCEM |
Character(3) |
VARCHAR2(3) NOT NULL |
FORCEM Category
1=Manager
2=Middle Level Manager
3=Technical
4=Qualified Worker
5=No Qualified Worker
|
| 6 |
TRN_T_STDY_LVL_ESP |
Character(2) |
VARCHAR2(2) NOT NULL |
Education Level
1=Without Studies
10=Other
2=Primary Studies
3=First Range of Seconday Ed
4=BUP, FPI,FPII or Equivalent
4=Tech Archict/Enginr,Tech Schl
5=Professional Certificate 3
5=Major Eng or Bachelor degree
6=Certificate Higher Education
6=Others
7=Bachelor's Degree
8=University Degree
9=Doctorate
|
| 7 |
TRN_T_QLIFICTN_ESP |
Character(150) |
VARCHAR2(150) NOT NULL |
Others Qualifications
|
| 8 |
TRN_T_CHK_MBR_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Priority Member
Y/N Table Edit
Default Value: N
|
| 9 |
TRN_T_VICTMGNR_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Affected by Gender Violence
Y/N Table Edit
Default Value: N
|
| 10 |
TRN_T_VICTMTRR_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Affected by Terrorism
Y/N Table Edit
Default Value: N
|
| 11 |
TRN_T_EE_ERTE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee in ERTE
Y/N Table Edit
Default Value: N
|
| 12 |
CNT_PERM_INTER_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Permanent Intermitent flag
Y/N Table Edit
|