| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SCC_SEQ_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence ID
|
| 3 |
SCC_SEQ_ID3 |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Nbr
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 6 |
ETHNIC_GROUP_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Ethnic Group Brazil
01=Native
02=White
04=Black
06=Yellow
08=Brown
09=Non Informed
|
| 7 |
NATIONALITY_CD_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Nationality code Brazil
|
| 8 |
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
|
| 9 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|