| # |
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 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Default Value: OPR_DEF_TBL_HR.REG_REGION
Prompt Table:
REG_REGION_TBL
|
| 4 |
ETHNIC_GRP_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Ethnic group code
Prompt Table:
ETHNIC_GRP_TBL
|
| 5 |
NATIONALITY_CD_BRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Nationality code Brazil
Prompt Table:
COUNTRY_TBL
|
| 6 |
EDUCATION_LVL_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Education Level Brazil
01=Analphabet
02=5th (4th old) Grade Incomplete
03=5th (4th old) Grade Complete
04=6th to 9th Grade Incomplete
05=Elementary School Complete
06=Medium School Incomplete
07=Medium School Complete
08=University Incomplete
09=University Complete
10=Post Graduation/Specialization
11=Post Graduation -- Complete
12=Master Degree -- Incomplete
13=Master Degree -- Complete
14=Ph Degree -- Incomplete
15=Ph Degree -- Complete
16=Post Ph Degree -- Incomplete
17=Post Ph Degree -- Complete
|
| 7 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 8 |
ARRIVAL_DATE_BRA |
Date(10) |
DATE |
Arrival date to Brazil
|
| 9 |
NATURAL_DT_BRA |
Date(10) |
DATE |
Naturalization Date
|
| 10 |
SPOUSE_IND_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Brazilian Spouse Indicator
Y/N Table Edit
Default Value: N
|
| 11 |
CHILDREN_IND_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Brazilian Children
Y/N Table Edit
Default Value: N
|
| 12 |
RESIDENCE_PER_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Residence Period Brazil
1=Undetermined
2=Determined
|
| 13 |
IMMI_CONDITION_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Immigration Condition Brazil.
1=Refugee
2=Asylum Seeker
3=Brazilian's Family
4=Benefited - Mercosur Countries
5=Dependent of Diplomat/Consular
6=Benefited - Treaty BRA & POR
7=Other Conditions
|