ADM_APP_TEST_VW

(SQL View)
 Index Back

Admission App Test Scores

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

SELECT b.oprid , a.emplid , a.acad_career , a.stdnt_car_nbr , a.adm_appl_nbr , a.appl_prog_nbr , a.genl_matl_group , a.genl_matl_type , a.genl_matl_nbr , a.appl_matl_nbr , a.matl_indicator , a.matl_usage , a.test_id , a.test_component , a.test_dt , a.ls_data_source , a.score , a.ext_acad_level , a.date_loaded , a.percentile FROM ps_adm_appl_matls a , PS_SAD_TEST_SC_VW b WHERE a.genl_matl_type = 'TST' AND a.test_id = b.test_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

3 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
4 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
5 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
6 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
7 GENL_MATL_GROUP Character(8) VARCHAR2(8) NOT NULL Material Group
8 GENL_MATL_TYPE Character(3) VARCHAR2(3) NOT NULL Material Type
9 GENL_MATL_NBR Number(3,0) SMALLINT NOT NULL Material Nbr
10 APPL_MATL_NBR Number(3,0) SMALLINT NOT NULL Appl Matl Nbr
11 MATL_INDICATOR Character(1) VARCHAR2(1) NOT NULL Material Indicator
12 MATL_USAGE Character(4) VARCHAR2(4) NOT NULL Material Usage
BOTH=Both
COMP=Completion
EVAL=Evaluation
13 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID
14 TEST_COMPONENT Character(5) VARCHAR2(5) NOT NULL Test Component
15 TEST_DT Date(10) DATE Test Date
16 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
17 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
18 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)
19 DATE_LOADED Date(10) DATE Date Loaded
20 PERCENTILE Number(3,0) SMALLINT NOT NULL Percentile