SSR_TSCRPT_TEST

(SQL Table)
 Index Back

Transcript Test Score Table

Flexible Transcript Test Score Table

  • Parent record: SSR_TSCRPT_TYPE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type

    Prompt Table: TRANSCRIPT_TYPE

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Prompt Table: SAD_TEST_SC_VW

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

    Prompt Table: SA_TCMP_REL_TBL

    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