SAD_CRM_FLT_ACD

(SQL View)
 Index Back

Mapping for EXT_ACAD_DATA

Mapping for EXT_ACAD_DATA.

SELECT EMPLID , EXT_ORG_ID , EXT_CAREER , EXT_DATA_NBR , LS_DATA_SOURCE , TRANSCRIPT_FLAG , TRANSCRIPT_TYPE , TRNSCRPT_STATUS , EXT_ACAD_LEVEL , TRANSCRIPT_DT , EXT_TERM_TYPE , EXT_TERM , TERM_YEAR , RECEIVED_DT , DATA_MEDIUM , FROM_DT , TO_DT FROM PS_EXT_ACAD_DATA WHERE EMPLID IN ( SELECT EMPLID FROM PS_SAD_CRM_EMPLIDS)

# 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
GRAD=Graduate
HS=High School
LAW=Law
MED=Medical
UGRD=Undergraduate
4 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr
5 LS_DATA_SOURCE Character(3) VARCHAR2(3) NOT NULL Data Source
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 Transcript Action
D=Desired
R=Received
7 TRANSCRIPT_TYPE Character(3) VARCHAR2(3) NOT NULL Transcript Type
OFF=Official
UNO=Unofficial
8 TRNSCRPT_STATUS Character(1) VARCHAR2(1) NOT NULL Transcript Status
F=Final
I=Incomplete
M=Mid-Year Report
W=Work in Progress
9 EXT_ACAD_LEVEL Character(4) VARCHAR2(4) NOT NULL External 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)
10 TRANSCRIPT_DT Date(10) DATE Transcript Date
11 EXT_TERM_TYPE Character(4) VARCHAR2(4) NOT NULL External Term Type
1YR=Full Year
MINI=Miniterm
OTHR=Other
QTR=Quarter
QUIN=Quinmester
SEM=Semester
TRIM=Trimester
UNKN=Unknown
12 EXT_TERM Character(4) VARCHAR2(4) NOT NULL External Term
FALL=Fall
SPR=Spring
SUMR=Summer
WINT=Winter
13 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year
14 RECEIVED_DT Date(10) DATE Certificate Received Date
15 DATA_MEDIUM Character(1) VARCHAR2(1) NOT NULL Data Medium
E=EDI
H=Hard Copy
16 FROM_DT Date(10) DATE From Date
17 TO_DT Date(10) DATE To Date