OLM_TSTSCORE_VW

(SQL View)
 Index Back

Test Scores View

View used in Test Scores profile record definition.

SELECT BO_ID , SYNCID , TEST_ID , TEST_COMPONENT , TEST_DT , LS_DATA_SOURCE , EMPLID , SCORE , SCORE_LETTER , EXT_ACAD_LEVEL , DATE_LOADED ,PERCENTILE , TEST_ADMIN , TEST_INDEX FROM PS_RD_TEST_SCORE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
2 RA_ATTRIB_SEQ Number(31,0) DECIMAL(31) NOT NULL Profile / attribute sequence numbers
3 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID codes.

Prompt Table: RD_TEST

4 TEST_COMPONENT Character(5) VARCHAR2(5) NOT NULL Enter the test component information.

Prompt Table: SA_TCMP_REL_TBL

5 TEST_DT Date(10) DATE NOT NULL Enter test date.
6 LS_DATA_SOURCE Character(3) VARCHAR2(3) NOT NULL The data source for the application data.
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
7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
8 RA_TSTSCORE Number(21,2) DECIMAL(20,2) NOT NULL Test Score
9 SCORE_LETTER Character(4) VARCHAR2(4) NOT NULL Enter the test score letter code.
10 EXT_ACAD_LEVEL Character(4) VARCHAR2(4) NOT NULL 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)
11 DATE_LOADED Date(10) DATE Date campus information loaded
12 RA_TSTPERCENT Number(18,0) DECIMAL(18) NOT NULL Test Percent
13 TEST_ADMIN Character(1) VARCHAR2(1) NOT NULL Enter the test administration information.

Y/N Table Edit

14 RA_TSTINDEX Number(20,1) DECIMAL(19,1) NOT NULL Test Index