EXT_ACAD_VW

(SQL View)
 Index Back

External Academic Summary View

EXT_ACAD_VW is a view that joins EXT_ACAD_DATA and EXT_ACAD_SUM. It is used in the summary panel - EXT_ACAD_SUMMARY.

SELECT A.EMPLID , A.EXT_ORG_ID , A.EXT_DATA_NBR , B.INSTITUTION , B.EXT_SUMM_TYPE , A.LS_DATA_SOURCE , A.RECEIVED_DT , B.EXT_GPA , B.CONVERT_GPA , B.PERCENTILE , B.UNT_COMP_TOTAL , B.UNT_TYPE , B.UNT_ATMP_TOTAL , B.RANK_TYPE , B.CLASS_RANK , B.CLASS_SIZE , B.GPA_TYPE , A.TRANSCRIPT_FLAG , A.TRANSCRIPT_TYPE , A.TRNSCRPT_STATUS , A.EXT_ACAD_LEVEL , A.TRANSCRIPT_DT , A.EXT_TERM_TYPE , A.EXT_TERM , A.TERM_YEAR , A.FROM_DT , A.TO_DT FROM PS_EXT_ACAD_DATA A , PS_EXT_ACAD_SUM B WHERE A.EMPLID = B.EMPLID AND A.EXT_ORG_ID = B.EXT_ORG_ID AND A.EXT_CAREER = B.EXT_CAREER AND A.EXT_DATA_NBR = B.EXT_DATA_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
3 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr
4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
5 EXT_SUMM_TYPE Character(4) VARCHAR2(4) NOT NULL Summary Type

Prompt Table: EXT_SUMM_TP_TBL

6 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
7 RECEIVED_DT Date(10) DATE Certificate Received Date
8 EXT_GPA Number(7,3) DECIMAL(6,3) NOT NULL External GPA

Prompt Table: GPA_TYPE_TBL

9 CONVERT_GPA Number(7,3) DECIMAL(6,3) NOT NULL Converted GPA
10 PERCENTILE Number(3,0) SMALLINT NOT NULL Percentile
11 UNT_COMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Completed Units
12 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
13 UNT_ATMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Units Attempted
14 RANK_TYPE Character(3) VARCHAR2(3) NOT NULL Rank Type
UNW=Unweighted
WGT=Weighted
15 CLASS_RANK Number(5,0) INTEGER NOT NULL Class Rank
16 CLASS_SIZE Number(5,0) INTEGER NOT NULL Class Size
17 GPA_TYPE Character(4) VARCHAR2(4) NOT NULL GPA Type

Prompt Table: GPA_TYPE_TBL

18 TRANSCRIPT_FLAG Character(1) VARCHAR2(1) NOT NULL Transcript Action
D=Desired
R=Received
19 TRANSCRIPT_TYPE Character(3) VARCHAR2(3) NOT NULL Transcript Type
OFF=Official
UNO=Unofficial
20 TRNSCRPT_STATUS Character(1) VARCHAR2(1) NOT NULL Transcript Status
F=Final
I=Incomplete
M=Mid-Year Report
W=Work in Progress
21 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)
22 TRANSCRIPT_DT Date(10) DATE Transcript Date
23 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
24 EXT_TERM Character(4) VARCHAR2(4) NOT NULL External Term
FALL=Fall
SPR=Spring
SUMR=Summer
WINT=Winter

Prompt Table: EXT_TERM_TBL

25 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year
26 FROM_DT Date(10) DATE From Date
27 TO_DT Date(10) DATE To Date