SAD_CRM_FLT_ACS

(SQL View)
 Index Back

Mapping for EXT_ACAD_SUM

Mapping for EXT_ACAD_SUM.

SELECT EMPLID ,EXT_ORG_ID , EXT_CAREER , EXT_DATA_NBR , EXT_SUMM_TYPE , EXT_ACAD_LEVEL , TERM_YEAR , EXT_TERM_TYPE , EXT_TERM , INSTITUTION , UNT_TYPE , UNT_ATMP_TOTAL , UNT_COMP_TOTAL , CLASS_RANK , CLASS_SIZE , GPA_TYPE , EXT_GPA , CONVERT_GPA , PERCENTILE , RANK_TYPE FROM PS_EXT_ACAD_SUM 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 EXT_SUMM_TYPE Character(4) VARCHAR2(4) NOT NULL Summary Type
6 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)
7 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year
8 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
9 EXT_TERM Character(4) VARCHAR2(4) NOT NULL External Term
FALL=Fall
SPR=Spring
SUMR=Summer
WINT=Winter
10 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
11 UNT_TYPE Character(3) VARCHAR2(3) NOT NULL Unit Type
ADU=Adult
CAR=Carnegie Units
CEU=Continuing Education Unit
NCR=No Credit
OTH=Non-Standard units
QTR=Quarter Units
SEM=Semester Units
UKN=Unknown
UNT=Units
VOC=Vocational
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 Rank
15 CLASS_SIZE Number(5,0) INTEGER NOT NULL Class Size
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
20 RANK_TYPE Character(3) VARCHAR2(3) NOT NULL Rank Type
UNW=Unweighted
WGT=Weighted