SAD_LAW_SUS_TST

(SQL Table)
Index Back

LSAC Suspense Data File

LSAC_SUSPN_I_C contains the LSAT test score data.

  • Parent record: SAD_LAW_SUS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID

    Prompt Table: SAD_LAW_SUS

    2 TEST_REC_NBR Number(9,0) DECIMAL(9) NOT NULL Test Type Record Nbr

    Prompt Table: SAD_LAW_SUS

    3 TEST_NBR Number(2,0) SMALLINT NOT NULL Test Number
    4 SAD_TST_SCR_COMP1 Character(3) VARCHAR2(3) NOT NULL Test Component 1 Score
    5 SAD_SCORE_COMP1 Number(7,2) DECIMAL(6,2) NOT NULL Score
    6 LSDAS_UPPER_BAND Number(3,0) SMALLINT NOT NULL LSDAS Upper Band
    7 LSDAS_LOWER_BAND Number(3,0) SMALLINT NOT NULL LSDAS Lower Band
    8 IRREG_CD_LSAC Character(1) VARCHAR2(1) NOT NULL LSAC Irregularity Code
    9 THREE_YR_PRCNT Number(2,0) SMALLINT NOT NULL 3-Year Percentile
    10 SAD_TEST_DT_LD Character(10) VARCHAR2(10) NOT NULL Test Load Test Date
    11 TEST_DT Date(10) DATE NOT NULL Test Date
    12 TEST_DT_ERROR Character(1) VARCHAR2(1) NOT NULL Test Date Error

    Y/N Table Edit

    Default Value: N

    13 SAD_TST_COMP1 Character(5) VARCHAR2(5) NOT NULL Test Component 1

    Prompt Table: SA_TCMP_REL_TBL

    14 SAD_TST_COMP1_PST Character(1) VARCHAR2(1) NOT NULL Post

    Y/N Table Edit

    Default Value: N

    15 SAD_TST_COMP1_ERR Character(1) VARCHAR2(1) NOT NULL Error

    Y/N Table Edit

    Default Value: N

    16 LSDAS_TEST_INDEX Number(7,1) DECIMAL(6,1) NOT NULL LSDAS Test Index
    17 TEST_INDEX Number(7,1) DECIMAL(6,1) NOT NULL Test Index
    18 LSDAS_THREE_YR_PCT Number(2,0) SMALLINT NOT NULL 3-Year Percentile