STDNT_TEST_MC

(SQL Table)
 Index Back

Student Test Components MC

Use STDNT_TEST_COMP to enter scores by test component for tests taken by a student. A Composite test component can be identified so that a score for the entire test can be entered, if appropriate.

  • Parent record: STDNT_TEST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition
    2 MC_STATUS Character(3) VARCHAR2(3) NOT NULL Mass Change Status
    APR=Approved Transaction
    CAN=Cancel Transaction
    ERR=Errored Transaction
    PND=Pending Transaction
    SCS=Successful Transaction
    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    5 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID

    Prompt Table: SA_TEST_TBL

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

    Prompt Table: SA_TCMP_REL_TBL

    7 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
    8 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score