EXT_SUBJ_VW

(SQL View)
 Index Back

External Subject View

EXT_SUBJ_VW is a view that joins EXT_ACAD_DATA and EXT_ACAD_SUBJ. It is used in the summary panel EXT_SUBJ_SUMMARY.

SELECT DISTINCT A.EMPLID , A.EXT_ORG_ID , A.EXT_SUBJECT_AREA , A.COURSE_LEVEL , A.UNT_ATMP_TOTAL , A.UNT_COMP_TOTAL , A.TOTAL_CRSE_COMP , A.TOTAL_CRSE_ATMP , A.GPA_TYPE , A.EXT_GPA , A.CONVERT_GPA , A.UNT_TYPE , B.TRANSCRIPT_FLAG , B.TRANSCRIPT_TYPE , B.TRNSCRPT_STATUS , B.TRANSCRIPT_DT , B.EXT_ACAD_LEVEL , B.EXT_TERM_TYPE , B.EXT_TERM , B.TERM_YEAR , B.RECEIVED_DT , B.FROM_DT , B.TO_DT , B.LS_DATA_SOURCE FROM PS_EXT_ACAD_SUBJ A , PS_EXT_ACAD_DATA 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

Prompt Table: EXT_ORG_TBL

3 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area

Prompt Table: EXT_SUBJECT_TBL

4 COURSE_LEVEL Character(2) VARCHAR2(2) NOT NULL Course Level
11=Grade 11
12=Grade 12
AP=Advanced Placement
DR=Graduate/Doctoral
FR=Freshman
GR=Graduate
HN=Honors
IB=International Baccalaureate
JR=Junior
LD=Lower Division
MS=Graduate/Master
RG=Regular
SO=Sophomore
SR=Senior
UD=Upper Division
5 UNT_ATMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Units Attempted
6 UNT_COMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Completed Units
7 TOTAL_CRSE_COMP Number(2,0) SMALLINT NOT NULL Total Courses Completed
8 TOTAL_CRSE_ATMP Number(2,0) SMALLINT NOT NULL Total Courses Attempted
9 GPA_TYPE Character(4) VARCHAR2(4) NOT NULL GPA Type

Prompt Table: GPA_TYPE_TBL

10 EXT_GPA Number(7,3) DECIMAL(6,3) NOT NULL External GPA

Prompt Table: GPA_VALUE_TBL

11 CONVERT_GPA Number(7,3) DECIMAL(6,3) NOT NULL Converted GPA

Prompt Table: GPA_RULES_TBL

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 TRANSCRIPT_FLAG Character(1) VARCHAR2(1) NOT NULL Transcript Action
D=Desired
R=Received

Y/N Table Edit

14 TRANSCRIPT_TYPE Character(3) VARCHAR2(3) NOT NULL Transcript Type
OFF=Official
UNO=Unofficial
15 TRNSCRPT_STATUS Character(1) VARCHAR2(1) NOT NULL Transcript Status
F=Final
I=Incomplete
M=Mid-Year Report
W=Work in Progress
16 TRANSCRIPT_DT Date(10) DATE Transcript Date
17 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)
18 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
19 EXT_TERM Character(4) VARCHAR2(4) NOT NULL External Term
FALL=Fall
SPR=Spring
SUMR=Summer
WINT=Winter

Prompt Table: EXT_TERM_TBL

20 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year
21 RECEIVED_DT Date(10) DATE Certificate Received Date
22 FROM_DT Date(10) DATE From Date
23 TO_DT Date(10) DATE To Date
24 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