| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
ESTAB_CD_MEX |
Number(7,0) |
INTEGER NOT NULL |
Establishment Code for STPS MEX
Prompt Table:
ESTABCD_TBL_MEX
|
| 6 |
OCCUP_CD_MEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Occupation Code
Prompt Table:
OCCUPCD_TBL_MEX
|
| 7 |
NORM_CD_MEX |
Character(11) |
VARCHAR2(11) NOT NULL |
Competency Norm Code Mexico
|
| 8 |
CERTIF_DATE_MEX |
Date(10) |
DATE |
Certification Date Mexico
|
| 9 |
DISABILITY_MEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Disability type Mexico
0=None
1=Motor
2=Visual
3=Mental
4=Hearing
5=Speech
Default Value: 0
|
| 10 |
HIGH_EDU_LVL_MEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Education Level Mexico
0=None
1=Primary Education
2=Junior High School
3=High School
4=Technical
5=Bachelor's Degree
6=Post-Bachelor's Degree
7=Master's Degree
8=Doctorate
|
| 11 |
PUBL_PRIV_SCHO_MEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Public/Private School Mexico
P=Public School
V=Private School
|
| 12 |
APPROV_DOC_MEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Document Mexico
1=Degree
2=Certificate
3=Diploma
4=Other
|
| 13 |
APP_DOC_DATE_MEX |
Date(10) |
DATE |
Approval Document Date Mexico
Default Value: %date
|
| 14 |
ACAD_CAREER_MEX |
Character(150) |
VARCHAR2(150) NOT NULL |
Academic Carrer Name Mexico
|
| 15 |
PUBLIC_PRIVATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Public/Private
P=Public
V=Private
|
| 16 |
PENSION_TP_WRK_MEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Pensioned worker
0=Not Applicable
1=Disability
2=Unemployment and Old Age
Default Value: 0
|