APPL_EXT_SBJ_VW

(SQL View)
 Index Back

Applicant External Subject VW

View of External Subject data for an Admissions Applicant.

SELECT A.Emplid , A.Acad_Career , A.Stdnt_Car_Nbr , A.Adm_Appl_Nbr , A.Appl_Prog_Nbr , D.Institution , D.Genl_Matl_Group , B.Ext_Org_Id , B.Ext_Career , B.Ext_Data_Nbr , B.LS_Data_Source , B.Transcript_Type , B.Trnscrpt_Status , B.Transcript_Dt , B.Transcript_Flag , B.Received_Dt , B.Data_Medium , E.Ext_Subject_Area , E.Course_Level , E.Unt_Atmp_Total , E.Unt_Comp_Total , E.Total_Crse_Comp , E.Total_Crse_Atmp , E.Gpa_Type , E.Ext_Gpa , E.Convert_Gpa , E.Institution , E.Unt_Type FROM ps_adm_app_car_seq A , PS_EXT_ACAD_DATA B , ps_matl_grp_tbl D , ps_ext_acad_subj E WHERE A.Emplid = B.Emplid AND B.Emplid = E.Emplid AND B.Ext_Org_Id = E.Ext_Org_Id AND B.Ext_Career = E.Ext_Career AND B.Ext_Data_Nbr = E.Ext_Data_Nbr AND NOT EXISTS ( SELECT 'X' FROM ps_adm_appl_matls C WHERE A.Emplid = C.Emplid AND A.Acad_Career = C.Acad_Career AND A.Stdnt_Car_Nbr = C.Stdnt_Car_Nbr AND A.Adm_Appl_Nbr = C.Adm_Appl_Nbr AND A.Appl_Prog_Nbr = C.Appl_Prog_Nbr AND D.Genl_Matl_Group = C.Genl_Matl_Group AND E.Emplid = C.Emplid AND E.Ext_Org_Id = C.Ext_Org_Id AND E.Ext_Career = C.Ext_Career AND E.Ext_Data_Nbr = C.Ext_Data_Nbr AND E.Ext_Subject_Area = C.Ext_Subject_Area AND E.Course_Level = C.Course_Level)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
5 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
6 INSTITUTION_SRCH Character(5) VARCHAR2(5) NOT NULL Institution
7 GENL_MATL_GROUP Character(8) VARCHAR2(8) NOT NULL Material Group
8 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
9 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
GRAD=Graduate
HS=High School
LAW=Law
MED=Medical
UGRD=Undergraduate
10 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr
11 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
12 TRANSCRIPT_TYPE Character(3) VARCHAR2(3) NOT NULL Transcript Type
OFF=Official
UNO=Unofficial
13 TRNSCRPT_STATUS Character(1) VARCHAR2(1) NOT NULL Transcript Status
F=Final
I=Incomplete
M=Mid-Year Report
W=Work in Progress
14 TRANSCRIPT_DT Date(10) DATE Transcript Date
15 TRANSCRIPT_FLAG Character(1) VARCHAR2(1) NOT NULL Transcript Action
D=Desired
R=Received
16 RECEIVED_DT Date(10) DATE Certificate Received Date
17 DATA_MEDIUM Character(1) VARCHAR2(1) NOT NULL Data Medium
E=EDI
H=Hard Copy
18 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area

Prompt Table: EXT_SUBJECT_TBL

19 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
20 UNT_ATMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Units Attempted
21 UNT_COMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Completed Units
22 TOTAL_CRSE_COMP Number(2,0) SMALLINT NOT NULL Total Courses Completed
23 TOTAL_CRSE_ATMP Number(2,0) SMALLINT NOT NULL Total Courses Attempted
24 GPA_TYPE Character(4) VARCHAR2(4) NOT NULL GPA Type
25 EXT_GPA Number(7,3) DECIMAL(6,3) NOT NULL External GPA
26 CONVERT_GPA Number(7,3) DECIMAL(6,3) NOT NULL Converted GPA
27 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

28 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