ADM_APP_SUBJ_VW

(SQL View)
 Index Back

Admission App Extrnl Subjects

This record is a view of the Admission Applicants Material record. It will show detail data for External Subjects that are linked to an Admission Applicant.

SELECT emplid , acad_career , stdnt_car_nbr , adm_appl_nbr , appl_prog_nbr , genl_matl_group , genl_matl_type , genl_matl_nbr , appl_matl_nbr , matl_indicator , matl_usage , ext_org_id , ext_career , ext_data_nbr , ls_data_source , ext_acad_level , transcript_type , trnscrpt_status , ext_subject_area , course_level , unt_type , unt_atmp_total , unt_comp_total , total_crse_comp , total_crse_atmp , gpa_type , ext_gpa , convert_gpa , institution , term_year FROM PS_ADM_APPL_MATLS WHERE genl_matl_type = 'SBJ'

# 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 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 GENL_MATL_GROUP Character(8) VARCHAR2(8) NOT NULL Material Group
7 GENL_MATL_TYPE Character(3) VARCHAR2(3) NOT NULL Material Type
8 GENL_MATL_NBR Number(3,0) SMALLINT NOT NULL Material Nbr
9 APPL_MATL_NBR Number(3,0) SMALLINT NOT NULL Appl Matl Nbr
10 MATL_INDICATOR Character(1) VARCHAR2(1) NOT NULL Material Indicator
11 MATL_USAGE Character(4) VARCHAR2(4) NOT NULL Material Usage
BOTH=Both
COMP=Completion
EVAL=Evaluation
12 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
13 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
GRAD=Graduate
HS=High School
LAW=Law
MED=Medical
UGRD=Undergraduate
14 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr
15 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
16 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)
17 TRANSCRIPT_TYPE Character(3) VARCHAR2(3) NOT NULL Transcript Type
OFF=Official
UNO=Unofficial
18 TRNSCRPT_STATUS Character(1) VARCHAR2(1) NOT NULL Transcript Status
F=Final
I=Incomplete
M=Mid-Year Report
W=Work in Progress
19 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area
20 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
21 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
22 UNT_ATMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Units Attempted
23 UNT_COMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Completed Units
24 TOTAL_CRSE_COMP Number(2,0) SMALLINT NOT NULL Total Courses Completed
25 TOTAL_CRSE_ATMP Number(2,0) SMALLINT NOT NULL Total Courses Attempted
26 GPA_TYPE Character(4) VARCHAR2(4) NOT NULL GPA Type
27 EXT_GPA Number(7,3) DECIMAL(6,3) NOT NULL External GPA
28 CONVERT_GPA Number(7,3) DECIMAL(6,3) NOT NULL Converted GPA
29 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

30 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year