SAD_SAT_SUS

(SQL Table)
 Index Back

SAT Suspense File

SAD_SAT_SUSPN contains all records from the SAT load process. SAT edit will update fields. Those records which are 'clean' will be processed by the SAT post program, loaded into the 'live' tables and then removed from the suspense table. The SATI, OLD SAT and SATII related test score data are contained in child tables.

  • Parent Record Of SAD_SAT_SUS_COL SAD_SAT_SUS_HS SAD_SAT_SUS_I SAD_SAT_SUS_II SAD_SAT_SUS_STD

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

    Prompt Table: SA_TEST_TBL

    2 TEST_REC_NBR Number(9,0) DECIMAL(9) NOT NULL Test Type Record Nbr
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    4 HS_CODE_SAT Character(6) VARCHAR2(6) NOT NULL High School Code
    5 SAD_LAST_NAME_LD Character(32) VARCHAR2(32) NOT NULL Admissions Last Name from Test Load
    6 SAD_FIRST_NAME_LD Character(30) VARCHAR2(30) NOT NULL Admissions First Name from Test Load
    7 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

    Prompt Table: NAME_PREFIX_TBL

    8 SAD_MID_INIT_LD Character(1) VARCHAR2(1) NOT NULL Admissions Middle Initial from Test Load
    9 SAD_SEX_LD Character(1) VARCHAR2(1) NOT NULL Test Load Gender
    10 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    11 SAD_BIRTHDATE_LD Character(10) VARCHAR2(10) NOT NULL Admissions Birthdate from Test Load
    12 BIRTHDATE Date(10) DATE Date of Birth
    13 SAD_SSN_LD Character(9) VARCHAR2(9) NOT NULL Admissions Test Load SSN
    14 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    15 SAD_ADDRESS1_LD Character(55) VARCHAR2(55) NOT NULL Address 1
    16 SAD_CITY_LD Character(40) VARCHAR2(40) NOT NULL Test Load City
    17 SAD_STATE_LD Character(60) VARCHAR2(60) NOT NULL Test Load State
    18 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_NAMES_TBL

    19 SAD_POSTAL_LD Character(15) VARCHAR2(15) NOT NULL Test Load Postal Code
    20 RESIDENCE_CODE_SAT Character(5) VARCHAR2(5) NOT NULL SAT Residence Code
    21 SAD_COUNTRY_LD Character(30) VARCHAR2(30) NOT NULL Test Load Country
    22 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    23 SAD_TELEPHONE_LD Character(20) VARCHAR2(20) NOT NULL Telephone Number
    24 SAD_SAT_I_TEST_ID Character(11) VARCHAR2(11) NOT NULL SAT I Test ID

    Prompt Table: SA_TEST_TBL

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

    Prompt Table: SA_TEST_TBL

    26 HS_GRAD_DT_SAT Character(4) VARCHAR2(4) NOT NULL SAT High School Graduation Date
    27 HS_GRAD_DT Date(10) DATE Highschool graduation date
    28 SDQ_ACT_DT_SAT Character(4) VARCHAR2(4) NOT NULL SAT Student Descriptive Questionnaire Activity Date
    29 GPA_SAT Character(1) VARCHAR2(1) NOT NULL SAT Grade Point Average
    30 RANK_SAT Character(1) VARCHAR2(1) NOT NULL Class Rank
    31 PARTICIPATION_SAT Character(1) VARCHAR2(1) NOT NULL SAT Participation in Community/School Activities Flag

    Y/N Table Edit

    Default Value: N

    32 SPORTS_PARTIC_SAT Character(1) VARCHAR2(1) NOT NULL SAT Participated in Sports

    Y/N Table Edit

    Default Value: N

    33 SPORT1_SAT Character(1) VARCHAR2(1) NOT NULL SAT Sport 1
    34 SPORT2_SAT Character(1) VARCHAR2(1) NOT NULL SAT Sport 2
    35 SPORT3_SAT Character(1) VARCHAR2(1) NOT NULL SAT Sport 3
    36 SPORT4_SAT Character(1) VARCHAR2(1) NOT NULL SAT Sport 4
    37 SPORT5_SAT Character(1) VARCHAR2(1) NOT NULL SAT Sport 5
    38 SPORT6_SAT Character(1) VARCHAR2(1) NOT NULL SAT Sport 6
    39 TYPE_PREF1_SAT Character(1) VARCHAR2(1) NOT NULL SAT 4-Year College or University

    Y/N Table Edit

    Default Value: N

    40 TYPE_PREF2_SAT Character(1) VARCHAR2(1) NOT NULL SAT 2-Year Community or Junior College

    Y/N Table Edit

    Default Value: N

    41 TYPE_PREF3_SAT Character(1) VARCHAR2(1) NOT NULL SAT Vocational or Technical School

    Y/N Table Edit

    Default Value: N

    42 TYPE_PREF4_SAT Character(1) VARCHAR2(1) NOT NULL SAT Undecided 2-Year or 4-Year School

    Y/N Table Edit

    Default Value: N

    43 PUB_PRIV_PREF1_SAT Character(1) VARCHAR2(1) NOT NULL SAT Public University or College

    Y/N Table Edit

    Default Value: N

    44 PUB_PRIV_PREF2_SAT Character(1) VARCHAR2(1) NOT NULL SAT Private University or College (not religiously affiliated)

    Y/N Table Edit

    Default Value: N

    45 PUB_PRIV_PREF3_SAT Character(1) VARCHAR2(1) NOT NULL SAT Private University or College (religiously affiliated)

    Y/N Table Edit

    Default Value: N

    46 PUB_PRIV_PREF4_SAT Character(1) VARCHAR2(1) NOT NULL SAT Undecided Public/Private Institution

    Y/N Table Edit

    Default Value: N

    47 SIZE_PREF1_SAT Character(1) VARCHAR2(1) NOT NULL SAT Size of Institution Preference - Fewer than 1000

    Y/N Table Edit

    Default Value: N

    48 SIZE_PREF2_SAT Character(1) VARCHAR2(1) NOT NULL SAT Size of Institution Preference - About 1000 to 5000 Students

    Y/N Table Edit

    Default Value: N

    49 SIZE_PREF3_SAT Character(1) VARCHAR2(1) NOT NULL SAT Size of Institution Preference - About 5000 to 10,000 Students

    Y/N Table Edit

    Default Value: N

    50 SIZE_PREF4_SAT Character(1) VARCHAR2(1) NOT NULL SAT Size of Institution Preference - About 10,000 to 20,000 Students

    Y/N Table Edit

    Default Value: N

    51 SIZE_PREF5_SAT Character(1) VARCHAR2(1) NOT NULL SAT Size of Institution Preference - More Than 20,000 Students

    Y/N Table Edit

    Default Value: N

    52 SIZE_PREF6_SAT Character(1) VARCHAR2(1) NOT NULL SAT Size of Institution Preference - Undecided

    Y/N Table Edit

    Default Value: N

    53 SETTING_PREF1_SAT Character(1) VARCHAR2(1) NOT NULL SAT Setting - Large City or Metropolitan Area

    Y/N Table Edit

    Default Value: N

    54 SETTING_PREF2_SAT Character(1) VARCHAR2(1) NOT NULL SAT Setting - Medium-size City

    Y/N Table Edit

    Default Value: N

    55 SETTING_PREF3_SAT Character(1) VARCHAR2(1) NOT NULL SAT Setting - Small City or Town

    Y/N Table Edit

    Default Value: N

    56 SETTING_PREF4_SAT Character(1) VARCHAR2(1) NOT NULL SAT Setting - Suburban Community

    Y/N Table Edit

    Default Value: N

    57 SETTING_PREF5_SAT Character(1) VARCHAR2(1) NOT NULL SAT Setting - Rural

    Y/N Table Edit

    Default Value: N

    58 SETTING_PREF6_SAT Character(1) VARCHAR2(1) NOT NULL SAT Setting - Undecided

    Y/N Table Edit

    Default Value: N

    59 LOC_PREF1_SAT Character(1) VARCHAR2(1) NOT NULL SAT Location Preference - Close to Home

    Y/N Table Edit

    Default Value: N

    60 LOC_PREF2_SAT Character(1) VARCHAR2(1) NOT NULL SAT Location Preference - In My Home State

    Y/N Table Edit

    Default Value: N

    61 LOC_PREF3_SAT Character(1) VARCHAR2(1) NOT NULL SAT Location Preference - In States Bordering Mine

    Y/N Table Edit

    Default Value: N

    62 LOC_PREF4_SAT Character(1) VARCHAR2(1) NOT NULL SAT Location Preference - Beyond States Bordering Mine

    Y/N Table Edit

    Default Value: N

    63 LOC_PREF5_SAT Character(1) VARCHAR2(1) NOT NULL SAT Location Preference - Outside the U.S.

    Y/N Table Edit

    Default Value: N

    64 LOC_PREF6_SAT Character(1) VARCHAR2(1) NOT NULL SAT Location Preference - Undecided

    Y/N Table Edit

    Default Value: N

    65 COL_TYPE_PREF1_SAT Character(1) VARCHAR2(1) NOT NULL SAT College Type Preference - All Women or All Men

    Y/N Table Edit

    Default Value: N

    66 COL_TYPE_PREF2_SAT Character(1) VARCHAR2(1) NOT NULL SAT College Type Preference - Coeducational

    Y/N Table Edit

    Default Value: N

    67 COL_TYPE_PREF3_SAT Character(1) VARCHAR2(1) NOT NULL SAT College Type Preference - Undecided

    Y/N Table Edit

    Default Value: N

    68 DEG_GOAL_SAT Character(1) VARCHAR2(1) NOT NULL SAT Degree Goal
    69 MAJOR_FIRSTCH_SAT Character(3) VARCHAR2(3) NOT NULL SAT First Choice of Major
    70 CERT_MAJOR_SAT Character(1) VARCHAR2(1) NOT NULL SAT Certainty of First Choice Major
    71 MAJOR_OTHER_SAT Character(3) VARCHAR2(3) NOT NULL SAT Other Major 1
    72 OTH_MAJ2_SAT Character(3) VARCHAR2(3) NOT NULL SAT Other Major 2
    73 OTH_MAJ3_SAT Character(3) VARCHAR2(3) NOT NULL SAT Other Major 3
    74 OTH_MAJ4_SAT Character(3) VARCHAR2(3) NOT NULL SAT Other Major 4
    75 FINANCIAL_AID_SAT Character(1) VARCHAR2(1) NOT NULL Financial Aid
    76 PTJOB_SAT Character(1) VARCHAR2(1) NOT NULL SAT Part-time Job
    77 HOUSING_SAT Character(1) VARCHAR2(1) NOT NULL SAT Housing Plans
    78 SAD_ETHNICITY_LD Character(2) VARCHAR2(2) NOT NULL Ethnicity
    79 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: ETHNIC_GRP_TBL
    Set Control Field: REG_REGION

    80 FIRST_LANGUAGE_SAT Character(1) VARCHAR2(1) NOT NULL First Language
    81 BEST_LANG_SAT Character(1) VARCHAR2(1) NOT NULL SAT Best Language
    82 SAD_CITIZEN_LD Character(3) VARCHAR2(3) NOT NULL Test Load Citizenship
    83 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Prompt Table: ADM_USA_CIT_VW

    84 RELIGION_SAT Character(2) VARCHAR2(2) NOT NULL SAT Religion
    85 COL_CD1_SAT Character(5) VARCHAR2(5) NOT NULL SAT College Code 1
    86 COL_NAME1_SAT Character(30) VARCHAR2(30) NOT NULL SAT College Name 1
    87 COL_CD2_SAT Character(5) VARCHAR2(5) NOT NULL SAT College Code 2
    88 COL_NAME2_SAT Character(30) VARCHAR2(30) NOT NULL SAT College Name 2
    89 COL_CD3_SAT Character(5) VARCHAR2(5) NOT NULL SAT College Code 3
    90 COL_NAME3_SAT Character(30) VARCHAR2(30) NOT NULL SAT College Name 3
    91 COL_CD4_SAT Character(5) VARCHAR2(5) NOT NULL SAT College Code 4
    92 COL_NAME4_SAT Character(30) VARCHAR2(30) NOT NULL SAT College Name 4
    93 REC_NUM_SAT Character(2) VARCHAR2(2) NOT NULL SAT Record Number
    94 SS_PER_SAT Character(1) VARCHAR2(1) NOT NULL SAT Student Search Permission
    95 DT_REPORT_SAT Character(6) VARCHAR2(6) NOT NULL SAT Date of Report
    96 SCHOOL_CD_SAT Character(6) VARCHAR2(6) NOT NULL SAT College Code
    97 HS_NAME_SAT Character(30) VARCHAR2(30) NOT NULL SAT High School Name
    98 HS_ADD1_SAT Character(30) VARCHAR2(30) NOT NULL High School Address 1
    99 HS_ADD2_SAT Character(30) VARCHAR2(30) NOT NULL High School Address 2
    100 HS_ADD3_SAT Character(30) VARCHAR2(30) NOT NULL High School Address 3
    101 HS_PHONE_NBR_SAT Character(12) VARCHAR2(12) NOT NULL SAT High School Telephone Number
    102 HS_TYPE_SAT Character(1) VARCHAR2(1) NOT NULL SAT High School Type
    A=Public
    B=Independent Nonreligious
    C=Independent Religious
    103 HS_SNR_CLS_SZ_SAT Character(1) VARCHAR2(1) NOT NULL SAT High School Senior Class Size
    A=Fewer than 100
    B=100 - 249
    C=250 - 499
    D=500 - 749
    E=750 - 999
    F=1000 or more
    104 HS_PCT_SENIORS_SAT Character(1) VARCHAR2(1) NOT NULL SAT High School Percent of Seniors Going to College
    A=90% or more
    B=80% - 89%
    C=70% - 79%
    D=60% - 69%
    E=50% - 59%
    F=40% - 49%
    G=30% - 39%
    H=20% - 29%
    I=10% - 19%
    J=Less than 10%
    105 HS_LOCATION_SAT Character(1) VARCHAR2(1) NOT NULL SAT Location of High School
    A=Large City
    B=Medium-size City
    C=Small City or Town
    D=Suburban
    E=Rural
    106 HS_NBR_AP_CRS_SAT Number(2,0) SMALLINT NOT NULL SAT High School Number of AP Courses Offered
    107 HS_HNRS_CRSES_SAT Character(1) VARCHAR2(1) NOT NULL SAT High School Honors Courses Offered
    A=Yes
    B=No
    108 HS_UNITS_GRAD_SAT Number(4,0) SMALLINT NOT NULL SAT High School Units to Graduate
    109 TEST_SELECT_SAT Character(1) VARCHAR2(1) NOT NULL School Tape Type
    C=College Tape
    S=Secondary School Tape

    Default Value: C

    110 SAD_EMAIL_LD Character(70) VARCHAR2(70) NOT NULL EMail Address