ADM_WEB_PRS_TS2

(SQL Table)
 Index Back

Web Prospect Test Components

This table contains the Test Component information for each Test ID. It is a child to the table ADM_WEB_PRS_TST.

  • Parent record: ADM_WEB_PRS_TST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID
    3 TEST_COMPONENT Character(5) VARCHAR2(5) NOT NULL Test Component

    Prompt Table: ADM_WEB_TCMP_VW

    4 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
    5 PERCENTILE Number(3,0) SMALLINT NOT NULL Percentile
    6 TEST_DT Date(10) DATE Test Date
    7 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)