| # |
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
Prompt Table:
EXT_ORG_TBL
|
| 3 |
EXT_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
External Career
Default Value: EXT_ORG_TBL_ADM.EXT_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 |
LS_DATA_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
The data source for the application data.
A8=TEAS Degree Information
AAD=AADSAS
ACT=American College Testing
AE=Ad-Hoc Employee
AMC=AMCAS
AO=Ad-Hoc Organizational
E=Extract
ETS=Educational Testing Service
GH=OLSAS Last Secondary-G2
LSD=LSDAS
PI=Prev/Post Secondary Info
RS=OLSAS Postsecondary Info
SCH=School
SLF=Self-Reported Information
WWW=World Wide Web
|
| 6 |
TRANSCRIPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Transit Flag
|
| 7 |
TRANSCRIPT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Transcript Type
|
| 8 |
TRNSCRPT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
transcript status
|
| 9 |
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)
Default Value: 0
|
| 10 |
TRANSCRIPT_DT |
Date(10) |
DATE |
Transcript Date
Default Value: %date
|
| 11 |
EXT_TERM_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
External Term Type
Default Value: EXT_ORG_TBL_ADM.EXT_TERM_TYPE
|
| 12 |
EXT_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
External Term
|
| 13 |
TERM_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Term Year
|
| 14 |
RECEIVED_DT |
Date(10) |
DATE |
Specifies the date that a group of pending items was received by the organization. This date may be earlier or the same as the date that the items were actually entered into the system (ENTRY_DT).
|
| 15 |
DATA_MEDIUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Medium Indicator
|
| 16 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 17 |
TO_DT |
Date(10) |
DATE |
to
|