SCC_TST_COMP_VW

(SQL View)
 Index Back

Student Test Components View

This is a view of the STDNT_TEST_COMP table, it does not have any defaults and is used in the Academic Test Summary..

SELECT B.OPRID , A.EMPLID , A.TEST_ID , A.TEST_COMPONENT , A.TEST_DT , A.LS_DATA_SOURCE , A.SCORE , A.SCORE_LETTER , A.EXT_ACAD_LEVEL , C.XLATLONGNAME , C.XLATSHORTNAME , A.DATE_LOADED , A.PERCENTILE , A.TEST_ADMIN FROM PS_STDNT_TEST_COMP A , PS_SAD_TEST_SC_VW B , PSXLATITEM C WHERE A.TEST_ID = B.TEST_ID AND C.FIELDNAME = 'EXT_ACAD_LEVEL' AND C.FIELDVALUE = A.EXT_ACAD_LEVEL AND C.EFFDT = ( SELECT MAX(C1.effdt) FROM PSXLATITEM C1 WHERE C1.FIELDNAME=C.FIELDNAME AND C1.FIELDVALUE=C.FIELDVALUE AND C1.EFFDT<=%CurrentDateIn)

  • Parent record: STDNT_TEST

    • # 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 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID

    Prompt Table: STDNT_TEST

    4 TEST_COMPONENT Character(5) VARCHAR2(5) NOT NULL Test Component

    Prompt Table: SA_TCMP_REL_TBL

    5 TEST_DT Date(10) DATE NOT NULL Test Date
    6 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
    7 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
    8 SCORE_LETTER Character(4) VARCHAR2(4) NOT NULL Letter Score
    9 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)
    10 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    11 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    12 DATE_LOADED Date(10) DATE Date Loaded
    13 PERCENTILE Number(3,0) SMALLINT NOT NULL Percentile
    14 TEST_ADMIN Character(1) VARCHAR2(1) NOT NULL Standard Test Administration

    Y/N Table Edit