SAD_TEST_LOAD

(SQL Table)
 Index Back

Test Score Input Parms

SAD_TEST_LOAD holds the parameters needed for the processing of the Admissions Test Score loads.

  • Parent Record Of AP_PARMS_SUBJ SAT_PARMS_II_C SSS_PARMS_SUBJ

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

    Prompt Table: SAD_TST_SCTY_VW

    4 FILE_INPUT Character(254) VARCHAR2(254) NOT NULL Test Score File Name and Path
    5 FILE_INPUT_AADSAS Character(254) VARCHAR2(254) NOT NULL AADSAS
    6 FILE_INPUT_CRSE_AA Character(254) VARCHAR2(254) NOT NULL AADSAS File Input
    7 NAME_PREFIX_M Character(4) VARCHAR2(4) NOT NULL Male Name Prefix

    Prompt Table: NAME_PREFIX_TBL

    8 NAME_PREFIX_F Character(4) VARCHAR2(4) NOT NULL Female Name Prefix

    Prompt Table: NAME_PREFIX_TBL

    9 NAME_PREFIX_U Character(4) VARCHAR2(4) NOT NULL Unknown Name Prefix

    Prompt Table: NAME_PREFIX_TBL

    10 TEST_DAY_INPUT Character(2) VARCHAR2(2) NOT NULL Test Day Input

    Default Value: 01

    11 TEST_MONTH_INPUT Character(2) VARCHAR2(2) NOT NULL Test Month Input

    Default Value: 01

    12 GRAD_DAY_INPUT Character(2) VARCHAR2(2) NOT NULL Graduation Day Input

    Default Value: 01

    13 SAD_GRAD_MONTH Character(2) VARCHAR2(2) NOT NULL Graduation Month Input

    Default Value: 01

    14 SAD_DEG_DAY_INPUT Character(2) VARCHAR2(2) NOT NULL Degree Day

    Default Value: 01

    15 MIDDLE_NAME_OPTION Character(1) VARCHAR2(1) NOT NULL Middle Name Load Option
    F=Full
    I=Initial

    Default Value: I

    16 SAD_ACT_DAY Character(2) VARCHAR2(2) NOT NULL Test Day of National Testing

    Default Value: 01

    17 SAD_ACT_DAY_D Character(2) VARCHAR2(2) NOT NULL Test Day of ACT DANTES Test

    Default Value: 02

    18 SAD_ACT_DAY_F Character(2) VARCHAR2(2) NOT NULL Test Day of ACT International Test

    Default Value: 03

    19 SAD_ACT_DAY_I Character(2) VARCHAR2(2) NOT NULL Test Day of ACTResidual Testing by Your Institution

    Default Value: 04

    20 SAD_ACT_DAY_R Character(2) VARCHAR2(2) NOT NULL Test Day of ACT Residual Testing by ACT

    Default Value: 05

    21 SAD_ACT_DAY_S Character(2) VARCHAR2(2) NOT NULL Test Day of ACT State Testing

    Default Value: 06

    22 SAD_ACT_DAY_Z Character(2) VARCHAR2(2) NOT NULL Test Day of ACT Arranged Testing

    Default Value: 07

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

    Prompt Table: SA_TCMP_REL_TBL

    24 SAD_TST_COMP2 Character(5) VARCHAR2(5) NOT NULL Test Component 2

    Prompt Table: SA_TCMP_REL_TBL

    25 SAD_TST_COMP3 Character(5) VARCHAR2(5) NOT NULL Test Component 3

    Prompt Table: SA_TCMP_REL_TBL

    26 SAD_TST_COMP4 Character(5) VARCHAR2(5) NOT NULL Test Component 4

    Prompt Table: SA_TCMP_REL_TBL

    27 SAD_TST_COMP5 Character(5) VARCHAR2(5) NOT NULL Test Component 5

    Prompt Table: SA_TCMP_REL_TBL

    28 SAD_TST_COMP6 Character(5) VARCHAR2(5) NOT NULL Test Component 6

    Prompt Table: SA_TCMP_REL_TBL

    29 SAD_TST_COMP7 Character(5) VARCHAR2(5) NOT NULL Test Component 7

    Prompt Table: SA_TCMP_REL_TBL

    30 SAD_TST_COMP8 Character(5) VARCHAR2(5) NOT NULL Test Component 8

    Prompt Table: SA_TCMP_REL_TBL

    31 SAD_TST_COMP9 Character(5) VARCHAR2(5) NOT NULL Test Component 9

    Prompt Table: SA_TCMP_REL_TBL

    32 SAD_TST_COMP10 Character(5) VARCHAR2(5) NOT NULL Test Component 10

    Prompt Table: SA_TCMP_REL_TBL

    33 SAD_TST_COMP11 Character(5) VARCHAR2(5) NOT NULL Test Component 11

    Prompt Table: SA_TCMP_REL_TBL

    34 SAD_TST_COMP12 Character(5) VARCHAR2(5) NOT NULL Test Component 12

    Prompt Table: SA_TCMP_REL_TBL

    35 SAD_TST_COMP13 Character(5) VARCHAR2(5) NOT NULL Test Component 13

    Prompt Table: SA_TCMP_REL_TBL

    36 SAD_TST_COMP14 Character(5) VARCHAR2(5) NOT NULL Test Component 14

    Prompt Table: SA_TCMP_REL_TBL

    37 SAD_TST_COMP15 Character(5) VARCHAR2(5) NOT NULL Test Component 15

    Prompt Table: SA_TCMP_REL_TBL

    38 SAD_TST_COMP16 Character(5) VARCHAR2(5) NOT NULL Test Component 15

    Prompt Table: SA_TCMP_REL_TBL

    39 SAD_TST_COMP17 Character(5) VARCHAR2(5) NOT NULL Test Component 15

    Prompt Table: SA_TCMP_REL_TBL

    40 SAD_TST_COMP18 Character(5) VARCHAR2(5) NOT NULL Test Component 15

    Prompt Table: SA_TCMP_REL_TBL

    41 SAD_TST_COMP19 Character(5) VARCHAR2(5) NOT NULL Test Component 15

    Prompt Table: SA_TCMP_REL_TBL

    42 SAD_TST_COMP20 Character(5) VARCHAR2(5) NOT NULL Test Component 20

    Prompt Table: SA_TCMP_REL_TBL

    43 SAD_TST_COMP21 Character(5) VARCHAR2(5) NOT NULL Test Component 21

    Prompt Table: SA_TCMP_REL_TBL

    44 SAD_SCORE_COMP1 Number(7,2) DECIMAL(6,2) NOT NULL Score
    45 SAD_SCORE_COMP2 Number(7,2) DECIMAL(6,2) NOT NULL Score
    46 SAD_SCORE_COMP3 Number(7,2) DECIMAL(6,2) NOT NULL Score
    47 SAD_SCORE_COMP4 Number(7,2) DECIMAL(6,2) NOT NULL Score
    48 SAD_SCORE_COMP5 Number(7,2) DECIMAL(6,2) NOT NULL Score
    49 SAD_PERCENT_COMP1 Number(3,0) SMALLINT NOT NULL Percentile
    50 SAD_PERCENT_COMP2 Number(3,0) SMALLINT NOT NULL Percentile
    51 SAD_PERCENT_COMP3 Number(3,0) SMALLINT NOT NULL Percentile
    52 SAD_PERCENT_COMP4 Number(3,0) SMALLINT NOT NULL Percentile
    53 SAD_PERCENT_COMP5 Number(3,0) SMALLINT NOT NULL Percentile
    54 SCORE_TYPE_AADSAS Character(1) VARCHAR2(1) NOT NULL AADSAS Score Type
    C=Canada
    U=United States

    Default Value: U

    55 TEST_SELECT_LSAC Character(1) VARCHAR2(1) NOT NULL LSAT/LSDAS Test Score
    L=LSAT Test Score
    S=LSDAS Test Score

    Default Value: S

    56 TEST_SELECT_SAT Character(1) VARCHAR2(1) NOT NULL School Tape Type
    C=College Tape
    S=Secondary School Tape

    Default Value: C

    57 SAD_SAT_I_TEST_ID Character(11) VARCHAR2(11) NOT NULL SAT I Test ID

    Prompt Table: SAD_TST_SCTY_VW

    58 SAD_SAT_II_TEST_ID Character(11) VARCHAR2(11) NOT NULL SAT II Test ID

    Prompt Table: SAD_TST_SCTY_VW

    59 TEST_DT Date(10) DATE Test Date

    Default Value: %date

    60 SEARCH_SWICH_SSS Character(1) VARCHAR2(1) NOT NULL SSS SAT/PSAT/AP Search Swich
    A=AP Search
    P=PSAT/NMSQT Search
    S=SAT I Search

    Default Value: S

    61 SAD_FILE_COLLEGE Character(254) VARCHAR2(254) NOT NULL AADSAS College File Descr
    62 SAD_FILE_GPA Character(254) VARCHAR2(254) NOT NULL AADSAS GPA DESCR
    63 SAD_FILE_GPA_COL Character(254) VARCHAR2(254) NOT NULL AADSAS College File Descr
    64 SAD_FILE_GPA_SES Character(254) VARCHAR2(254) NOT NULL AADSAS GPA per Session File Descr
    65 SAD_FILE_PL_COURSE Character(254) VARCHAR2(254) NOT NULL AADSAS Planned Courses File Descr