APPL_SCORES_VW

(SQL View)
 Index Back

Applicant Test Score View

This table provides a view of all Test Scores for a person that have not been linked to that persons Application.

SELECT e.Oprid , A.Emplid , A.Acad_Career , A.Stdnt_Car_Nbr , A.Adm_Appl_Nbr , A.Appl_Prog_Nbr , D.Institution , D.Genl_Matl_Group , B.Test_Id , B.Test_Component , B.Test_Dt , B.LS_Data_Source , B.Score , B.Ext_Acad_Level , B.Date_Loaded , B.Percentile FROM ps_adm_app_car_seq A , PS_STDNT_TEST_COMP B , ps_matl_grp_tbl D , PS_SAD_TEST_SC_VW e WHERE A.Emplid = B.Emplid AND b.test_id = e.test_id 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 B.Emplid = C.Emplid AND B.Test_Id = C.Test_Id AND B.Test_Component = C.Test_Component AND B.Test_Dt = C.Test_Dt AND B.LS_Data_Source = C.LS_Data_Source)

# 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

8 GENL_MATL_GROUP Character(8) VARCHAR2(8) NOT NULL Material Group
9 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID
10 TEST_COMPONENT Character(5) VARCHAR2(5) NOT NULL Test Component
11 TEST_DT Date(10) DATE Test Date
12 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
13 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
14 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)
15 DATE_LOADED Date(10) DATE Date Loaded
16 PERCENTILE Number(3,0) SMALLINT NOT NULL Percentile