| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
|
| 3 |
EXT_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
External Career
|
| 4 |
EXT_DATA_NBR |
Number(3,0) |
SMALLINT NOT NULL |
EXT DATA NBR. This field is used in the TS189 OutBound Transformation Process.
|
| 5 |
EXT_SUMM_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Summary Type
|
| 6 |
EXT_ACAD_LEVEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic level
0=Unknown
01=Pre-Eighth Grade
1=Eighth Grade
2=Ninth Grade
3=Tenth Grade
4=Eleventh Grade
5=Twelfth Grade
6=Postsecondary First Year
7=Postsecondary Sophomore
8=Postsecondary Junior
9=Postsecondary Senior
90=Post-Secondary
91=Postsecondary Professional
92=Postsecondary Master
93=Postsecondary Doctoral
94=Postdoctoral
A1=Basic User/Breakthrough (NLD)
A2=Basic User/Waystage (NLD)
B1=Independ. User/Threshold (NLD)
B2=Independ. User/Vantage (NLD)
C1=Prof. User/Effective (NLD)
C2=Proficient User/Master (NLD)
|
| 7 |
TERM_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Term Year
|
| 8 |
EXT_TERM_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
External Term Type
|
| 9 |
EXT_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
External Term
|
| 10 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Institution field to store institution information in campus solution system.
|
| 11 |
UNT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit Type
|
| 12 |
UNT_ATMP_TOTAL |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
total units attempted
|
| 13 |
UNT_COMP_TOTAL |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
total completed units
|
| 14 |
CLASS_RANK |
Number(5,0) |
INTEGER NOT NULL |
Class Ranking
|
| 15 |
CLASS_SIZE |
Number(5,0) |
INTEGER NOT NULL |
Size of the class
|
| 16 |
GPA_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
GPA Type
|
| 17 |
EXT_GPA |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
External GPA
|
| 18 |
CONVERT_GPA |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Converted GPA
|
| 19 |
PERCENTILE |
Number(3,0) |
SMALLINT NOT NULL |
Percentile information captured using this field.
|
| 20 |
RANK_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Rank Type
|