SAD_ACT_SUS

(SQL Table)
 Index Back

ACT Suspense File

ACT Suspense Table is a temporary holding table and has all the Bio/Demo and test score data.

  • Parent Record Of SAD_ACT_SUS_COL SAD_ACT_SUS_HS SAD_ACT_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 REPORTING_YR_ACT Character(2) VARCHAR2(2) NOT NULL ACT Reporting Year
    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_ADDRESS1_LD Character(55) VARCHAR2(55) NOT NULL Address 1
    10 SAD_SEX_LD Character(1) VARCHAR2(1) NOT NULL Test Load Gender
    11 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    12 GRADE_CLASS_ACT Character(2) VARCHAR2(2) NOT NULL ACT Grade Classification
    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_BIRTHDATE_LD Character(10) VARCHAR2(10) NOT NULL Admissions Birthdate from Test Load
    16 BIRTHDATE Date(10) DATE Date of Birth
    17 SAD_TELEPHONE_LD Character(20) VARCHAR2(20) NOT NULL Telephone Number
    18 SAD_CITY_LD Character(40) VARCHAR2(40) NOT NULL Test Load City
    19 SAD_STATE_LD Character(60) VARCHAR2(60) NOT NULL Test Load State
    20 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_NAMES_TBL

    21 SAD_POSTAL_LD Character(15) VARCHAR2(15) NOT NULL Test Load Postal Code
    22 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    23 SAD_TST_SCR_COMP1 Character(3) VARCHAR2(3) NOT NULL Test Component 1 Score
    24 SAD_SCORE_COMP1 Number(7,2) DECIMAL(6,2) NOT NULL Score
    25 SAD_TST_COMP1 Character(5) VARCHAR2(5) NOT NULL Test Component 1

    Prompt Table: SA_TCMP_REL_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    28 SAD_TST_SCR_COMP2 Character(3) VARCHAR2(3) NOT NULL Test Component 2 Score
    29 SAD_SCORE_COMP2 Number(7,2) DECIMAL(6,2) NOT NULL Score
    30 SAD_TST_COMP2 Character(5) VARCHAR2(5) NOT NULL Test Component 2

    Prompt Table: SA_TCMP_REL_TBL

    31 SAD_TST_COMP2_PST Character(1) VARCHAR2(1) NOT NULL Post

    Y/N Table Edit

    Default Value: N

    32 SAD_TST_COMP2_ERR Character(1) VARCHAR2(1) NOT NULL Error

    Y/N Table Edit

    Default Value: N

    33 SAD_ACT_NNRM_EW Character(2) VARCHAR2(2) NOT NULL ACT English/Writing National Norm
    34 SAD_ACT_NNRM_WR Character(2) VARCHAR2(2) NOT NULL ACT Writing Subscore National Norm
    35 SAD_ACT_WR_DESC1 Character(2) VARCHAR2(2) NOT NULL ACT Writing Score Description
    36 SAD_ACT_WR_DESC2 Character(2) VARCHAR2(2) NOT NULL ACT Writing Score Description
    37 SAD_ACT_WR_DESC3 Character(2) VARCHAR2(2) NOT NULL ACT Writing Score Description
    38 SAD_ACT_WR_DESC4 Character(2) VARCHAR2(2) NOT NULL ACT Writing Score Description
    39 HS_CODE_ACT Character(6) VARCHAR2(6) NOT NULL ACT High School Code
    40 HS_ENG_GRD_ACT Number(3,1) DECIMAL(2,1) NOT NULL ACT High School English Grade
    41 HS_MATH_GRD_ACT Number(3,1) DECIMAL(2,1) NOT NULL ACT High School Mathematics Grade
    42 HS_SS_GRD_ACT Number(3,1) DECIMAL(2,1) NOT NULL ACT High School Social Studies Grade
    43 HS_NS_GRD_ACT Number(3,1) DECIMAL(2,1) NOT NULL ACT High School Natural Sciences Grade
    44 HS_AVG_ACT Number(4,2) DECIMAL(3,2) NOT NULL ACT High School Average
    45 HS_GRAD_YEAR_ACT Character(4) VARCHAR2(4) NOT NULL ACT Year of High School Graduation
    46 HS_GRAD_DT Date(10) DATE Highschool graduation date
    47 EXT_ACAD_LEVEL Character(4) VARCHAR2(4) NOT NULL External Academic Level
    0=Unknown
    01=Pre-Eighth Grade
    1=Eighth Grade
    2=Ninth Grade
    3=Tenth Grade
    4=Eleventh Grade
    5=Twelfth Grade
    6=Postsecondary First Year
    7=Postsecondary Sophomore
    8=Postsecondary Junior
    9=Postsecondary Senior
    90=Post-Secondary
    91=Postsecondary Professional
    92=Postsecondary Master
    93=Postsecondary Doctoral
    94=Postdoctoral
    A1=Basic User/Breakthrough (NLD)
    A2=Basic User/Waystage (NLD)
    B1=Independ. User/Threshold (NLD)
    B2=Independ. User/Vantage (NLD)
    C1=Prof. User/Effective (NLD)
    C2=Proficient User/Master (NLD)
    48 SAD_TEST_DT_LD Character(10) VARCHAR2(10) NOT NULL Test Load Test Date
    49 TEST_DT Date(10) DATE NOT NULL Test Date
    50 TEST_TYPE_ACT Character(1) VARCHAR2(1) NOT NULL ACT Test Type
    51 REV_SCORE_IND_ACT Character(1) VARCHAR2(1) NOT NULL ACT Corrected Score Indicator
    52 SAD_TST_SCR_COMP3 Character(3) VARCHAR2(3) NOT NULL Test Component 3 Score
    53 SAD_SCORE_COMP3 Number(7,2) DECIMAL(6,2) NOT NULL Score
    54 SAD_TST_COMP3 Character(5) VARCHAR2(5) NOT NULL Test Component 3

    Prompt Table: SA_TCMP_REL_TBL

    55 SAD_TST_COMP3_PST Character(1) VARCHAR2(1) NOT NULL Post

    Y/N Table Edit

    Default Value: N

    56 SAD_TST_COMP3_ERR Character(1) VARCHAR2(1) NOT NULL Error

    Y/N Table Edit

    Default Value: N

    57 SAD_TST_SCR_COMP4 Character(3) VARCHAR2(3) NOT NULL Test Component 4 Score
    58 SAD_SCORE_COMP4 Number(7,2) DECIMAL(6,2) NOT NULL Score
    59 SAD_TST_COMP4 Character(5) VARCHAR2(5) NOT NULL Test Component 4

    Prompt Table: SA_TCMP_REL_TBL

    60 SAD_TST_COMP4_PST Character(1) VARCHAR2(1) NOT NULL Post

    Y/N Table Edit

    Default Value: N

    61 SAD_TST_COMP4_ERR Character(1) VARCHAR2(1) NOT NULL Error

    Y/N Table Edit

    Default Value: N

    62 SAD_TST_SCR_COMP5 Character(3) VARCHAR2(3) NOT NULL Test Component 5 Score
    63 SAD_SCORE_COMP5 Number(7,2) DECIMAL(6,2) NOT NULL Score
    64 SAD_TST_COMP5 Character(5) VARCHAR2(5) NOT NULL Test Component 5

    Prompt Table: SA_TCMP_REL_TBL

    65 SAD_TST_COMP5_PST Character(1) VARCHAR2(1) NOT NULL Post

    Y/N Table Edit

    Default Value: N

    66 SAD_TST_COMP5_ERR Character(1) VARCHAR2(1) NOT NULL Error

    Y/N Table Edit

    Default Value: N

    67 SAD_TST_SCR_COMP6 Character(3) VARCHAR2(3) NOT NULL Test Component 6 Score
    68 SAD_SCORE_COMP6 Number(7,2) DECIMAL(6,2) NOT NULL Score
    69 SAD_TST_COMP6 Character(5) VARCHAR2(5) NOT NULL Test Component 6

    Prompt Table: SA_TCMP_REL_TBL

    70 SAD_TST_COMP6_PST Character(1) VARCHAR2(1) NOT NULL Post

    Y/N Table Edit

    Default Value: N

    71 SAD_TST_COMP6_ERR Character(1) VARCHAR2(1) NOT NULL Error

    Y/N Table Edit

    Default Value: N

    72 SAD_TST_SCR_COMP7 Character(3) VARCHAR2(3) NOT NULL Test Component 7 Score
    73 SAD_SCORE_COMP7 Number(7,2) DECIMAL(6,2) NOT NULL Score
    74 SAD_TST_COMP7 Character(5) VARCHAR2(5) NOT NULL Test Component 7

    Prompt Table: SA_TCMP_REL_TBL

    75 SAD_TST_COMP7_PST Character(1) VARCHAR2(1) NOT NULL Post

    Y/N Table Edit

    Default Value: N

    76 SAD_TST_COMP7_ERR Character(1) VARCHAR2(1) NOT NULL Error

    Y/N Table Edit

    Default Value: N

    77 TEST_ADMIN Character(1) VARCHAR2(1) NOT NULL Standard Test Administration

    Y/N Table Edit

    Default Value: N

    78 SUM_SCALE_SCRS_ACT Character(3) VARCHAR2(3) NOT NULL ACT Sum of Scale Scores
    79 INT_INV_S_ACT Character(2) VARCHAR2(2) NOT NULL ACT Interest Inventory - Science
    80 INT_INV_A_ACT Character(2) VARCHAR2(2) NOT NULL ACT Interest Inventory - Arts
    81 INT_INV_SS_ACT Character(2) VARCHAR2(2) NOT NULL ACT Interest Inventory - Social Service
    82 INT_INV_BC_ACT Character(2) VARCHAR2(2) NOT NULL ACT Interest Inventory - Business Contact
    83 INT_INV_BO_ACT Character(2) VARCHAR2(2) NOT NULL ACT Interest Inventory - Business Operations
    84 INT_INV_T_ACT Character(2) VARCHAR2(2) NOT NULL ACT Interest Inventory - Technical
    85 MAP_REGION1_ACT Character(2) VARCHAR2(2) NOT NULL ACT Map Region 1
    86 MAP_REGION2_ACT Character(2) VARCHAR2(2) NOT NULL ACT Map Region 2
    87 MAP_REGION3_ACT Character(2) VARCHAR2(2) NOT NULL ACT Map Region 3
    88 COL_CHOICE_ACT Character(1) VARCHAR2(1) NOT NULL ACT College Choice
    89 COL_CD_ACT Character(4) VARCHAR2(4) NOT NULL ACT College Code Number
    90 EN_SUBSCORE_UM_ACT Character(2) VARCHAR2(2) NOT NULL ACT Enhanced (Scale) Subscores - Usage/Mechanism
    91 EN_SUBSCORE_RH_ACT Character(2) VARCHAR2(2) NOT NULL ACT Enhanced (Scale) Subscores - Rhetorical Skills
    92 EN_SUBSCORE_EA_ACT Character(2) VARCHAR2(2) NOT NULL ACT Enhanced (Scale) Subscores - Elem Algebra
    93 EN_SUBSCORE_AG_ACT Character(2) VARCHAR2(2) NOT NULL ACT Enhanced (Scale) Subscores - Alg/Coord Geom
    94 EN_SUBSCORE_GT_ACT Character(2) VARCHAR2(2) NOT NULL ACT Enhanced (Scale) Subscores - Plane Geom/Trig
    95 EN_SUBSCORE_SS_ACT Character(2) VARCHAR2(2) NOT NULL ACT Enhanced (Scale) Subscores - Soc Stud/Sci
    96 EN_SUBSCORE_AL_ACT Character(2) VARCHAR2(2) NOT NULL ACT Enhanced (Scale) Subscores - Arts/Lit
    97 NATL_NORM_UM_ACT Character(2) VARCHAR2(2) NOT NULL ACT National Norms - Usage/Mech
    98 NATL_NORM_RH_ACT Character(2) VARCHAR2(2) NOT NULL ACT National Norm - Rhetorical Skills
    99 NATL_NORM_EA_ACT Character(2) VARCHAR2(2) NOT NULL ACT National Norm - Elem Algebra
    100 NATL_NORM_AG_ACT Character(2) VARCHAR2(2) NOT NULL ACT National Norms - Alg/Coord Geom
    101 NATL_NORM_GT_ACT Character(2) VARCHAR2(2) NOT NULL ACT National Norm - Plane Geom/Trig
    102 NATL_NORM_SS_ACT Character(2) VARCHAR2(2) NOT NULL ACT National Norm - Soc Stud/Sci
    103 NATL_NORM_AL_ACT Character(2) VARCHAR2(2) NOT NULL ACT National Norms - Arts/Lit
    104 LCL_NORM_UM_ACT Character(2) VARCHAR2(2) NOT NULL ACT Local Norms - Usage/Mech
    105 LCL_NORM_RH_ACT Character(2) VARCHAR2(2) NOT NULL ACT Local Norm - Rhetorical Skills
    106 LCL_NORM_EA_ACT Character(2) VARCHAR2(2) NOT NULL ACT Local Norm - Elem Algebra
    107 LCL_NORM_AG_ACT Character(2) VARCHAR2(2) NOT NULL ACT Local Norms - Alg/Coord Geom
    108 LCL_NORM_GT_ACT Character(2) VARCHAR2(2) NOT NULL ACT Local Norm - Plane Geom/Trig
    109 LCL_NORM_SS_ACT Character(2) VARCHAR2(2) NOT NULL ACT Local Norm - Soc Stud/Sci
    110 LCL_NORM_AL_ACT Character(2) VARCHAR2(2) NOT NULL ACT Local Norms - Arts/Lit
    111 FULL_PART_ACT Character(1) VARCHAR2(1) NOT NULL ACT Full/Part Time
    1=Full Time
    2=Part Time
    112 DAY_EVEN_ACT Character(1) VARCHAR2(1) NOT NULL ACT Day/Evening Classes
    1=Day Classes
    2=Evening Classes
    113 PLANNED_ENTRY_ACT Character(1) VARCHAR2(1) NOT NULL ACT Month of Planned Entry
    114 PLANNED_RES_ACT Character(1) VARCHAR2(1) NOT NULL ACT Planned Residency
    115 MAR_STATUS_ACT Character(1) VARCHAR2(1) NOT NULL ACT Marital Status
    116 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    L=DissDeclLost Civil Partner
    M=Married
    P=Civil Partnership
    S=Single
    T=Surviving Civil Partner
    U=Unknown
    V=Dissolved Civil Partnership
    W=Widowed
    117 SAD_CITIZEN_LD Character(3) VARCHAR2(3) NOT NULL Test Load Citizenship
    118 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Prompt Table: ADM_USA_CIT_VW

    119 RESIDENT_ACT Character(1) VARCHAR2(1) NOT NULL ACT Legal Resident of State
    120 DISABILITY_ACT Character(1) VARCHAR2(1) NOT NULL ACT Disability
    121 ACTIVE_DUTY_ACT Character(1) VARCHAR2(1) NOT NULL ACT Military Active Duty
    122 PREV_COL_CRDT_ACT Character(1) VARCHAR2(1) NOT NULL ACT Previous College Credit
    123 MAJOR_PLAN_ACT Character(3) VARCHAR2(3) NOT NULL ACT College Major Plan
    124 VOCATION1_ACT Character(3) VARCHAR2(3) NOT NULL ACT First Choice Vocation
    125 VOCATION2_ACT Character(3) VARCHAR2(3) NOT NULL ACT Second Choice Vocation
    126 CONF_MAJ_ACT Character(1) VARCHAR2(1) NOT NULL ACT Confidence in College Major
    127 CONF_VOC_ACT Character(1) VARCHAR2(1) NOT NULL ACT Confidence in Vocation
    128 EXP_LVL_ACT Character(1) VARCHAR2(1) NOT NULL ACT Expected Highest Level
    129 EST_GPA_ACT Character(1) VARCHAR2(1) NOT NULL AXT Estimated GPA
    130 ROTC_ACT Character(1) VARCHAR2(1) NOT NULL ACT Interest in ROTC
    131 FIN_AID_APPLY_ACT Character(1) VARCHAR2(1) NOT NULL Expect to Apply
    132 FIN_AID_WORK_ACT Character(1) VARCHAR2(1) NOT NULL Expect to Work
    133 FIN_AID_HRS_ACT Character(1) VARCHAR2(1) NOT NULL Hours Expect to Work
    134 FIN_AID_INCOME_ACT Character(1) VARCHAR2(1) NOT NULL Parents Income
    135 RELIGION_ACT Character(2) VARCHAR2(2) NOT NULL ACT Religious Affiliation
    136 DIST_COL_ACT Character(1) VARCHAR2(1) NOT NULL ACT Distance From College
    137 ENGL_HOME_ACT Character(1) VARCHAR2(1) NOT NULL ACT English Spoken at Home
    138 SAD_ETHNICITY_LD Character(2) VARCHAR2(2) NOT NULL Ethnicity
    139 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: ETHNIC_GRP_TBL
    Set Control Field: REG_REGION

    140 COL_TYPE_ACT Character(1) VARCHAR2(1) NOT NULL ACT Preference for College Type
    141 COED_ACT Character(1) VARCHAR2(1) NOT NULL ACT Preference for Gender Composition
    142 COL_STATE1_ACT Character(2) VARCHAR2(2) NOT NULL ACT Preference for College State 1
    143 COL_STATE2_ACT Character(2) VARCHAR2(2) NOT NULL ACT Preference for College State 2
    144 COL_STATE3_ACT Character(2) VARCHAR2(2) NOT NULL ACT Preference for College State 3
    145 COL_STATE4_ACT Character(2) VARCHAR2(2) NOT NULL ACT Preference for College State 4
    146 COL_STATE5_ACT Character(2) VARCHAR2(2) NOT NULL ACT Preference for College State 5
    147 STUD_BOD_SZ_ACT Character(1) VARCHAR2(1) NOT NULL ACT Preference for Student Body Size
    148 RANK_INST_ACT Character(1) VARCHAR2(1) NOT NULL ACT Ranking of Type of Institution
    149 RANK_GENDER_ACT Character(1) VARCHAR2(1) NOT NULL ACT Ranking of Gender Composition
    150 RANK_LOC_ACT Character(1) VARCHAR2(1) NOT NULL ACT Ranking of Location
    151 RANK_TUI_ACT Character(1) VARCHAR2(1) NOT NULL ACT Ranking of Tuition
    152 RANK_SZ_ACT Character(1) VARCHAR2(1) NOT NULL ACT Ranking of Student Body Size
    153 RANK_MAJ_ACT Character(1) VARCHAR2(1) NOT NULL ACT Ranking of Field of Study
    154 RANK_OTH_ACT Character(1) VARCHAR2(1) NOT NULL ACT Ranking of Other Factor
    155 RANK_ACT Character(1) VARCHAR2(1) NOT NULL ACT Class Rank
    156 GPA_ACT Character(1) VARCHAR2(1) NOT NULL ACT GPA
    157 HONORS_ENG_ACT Character(1) VARCHAR2(1) NOT NULL English
    158 HONORS_MATH_ACT Character(1) VARCHAR2(1) NOT NULL Math
    159 HONORS_SS_ACT Character(1) VARCHAR2(1) NOT NULL Social Studies
    160 HONORS_NS_ACT Character(1) VARCHAR2(1) NOT NULL ACT Honors Natural Sciences
    161 HONORS_FL_ACT Character(1) VARCHAR2(1) NOT NULL ACT Honors Foreign Language
    162 SAD_TST_PER_COMP3 Character(2) VARCHAR2(2) NOT NULL Percentile
    163 SAD_PERCENT_COMP3 Number(3,0) SMALLINT NOT NULL Percentile
    164 SAD_TST_PER_COMP4 Character(2) VARCHAR2(2) NOT NULL Percentile
    165 SAD_PERCENT_COMP4 Number(3,0) SMALLINT NOT NULL Percentile
    166 SAD_TST_PER_COMP5 Character(2) VARCHAR2(2) NOT NULL Percentile
    167 SAD_PERCENT_COMP5 Number(3,0) SMALLINT NOT NULL Percentile
    168 SAD_TST_PER_COMP6 Character(2) VARCHAR2(2) NOT NULL Percentile
    169 SAD_PERCENT_COMP6 Number(3,0) SMALLINT NOT NULL Percentile
    170 SAD_TST_PER_COMP7 Character(2) VARCHAR2(2) NOT NULL Percentile
    171 SAD_PERCENT_COMP7 Number(3,0) SMALLINT NOT NULL Percentile
    172 PER_OVERALL1_ACT Character(2) VARCHAR2(2) NOT NULL ACT Percentile Rank Overall 1
    173 PER_OVERALL2_ACT Character(2) VARCHAR2(2) NOT NULL ACT Percentile Rank Overall 2
    174 PER_OVERALL3_ACT Character(2) VARCHAR2(2) NOT NULL ACT Percentile Rank Overall 3
    175 PER_OVERALL4_ACT Character(2) VARCHAR2(2) NOT NULL ACT Percentile Rank Overall 4
    176 PER_OVERALL5_ACT Character(2) VARCHAR2(2) NOT NULL ACT Percentile Rank Overall 5
    177 PER_COURSES1_ACT Character(2) VARCHAR2(2) NOT NULL ACT Percentile Rank Specific Courses 1
    178 PER_COURSES2_ACT Character(2) VARCHAR2(2) NOT NULL ACT Percentile Rank Specific Courses 2
    179 PER_COURSES3_ACT Character(2) VARCHAR2(2) NOT NULL ACT Percentile Rank Specific Courses 3
    180 PER_COURSES4_ACT Character(2) VARCHAR2(2) NOT NULL ACT Percentile Rank Specific Courses 4
    181 PER_COURSES5_ACT Character(2) VARCHAR2(2) NOT NULL ACT Percentile Rank Specific Courses 5
    182 NORMS_SCORE_E_ACT Character(2) VARCHAR2(2) NOT NULL ACT National Norms Assessment Scales Scores English
    183 NORMS_SCORE_M_ACT Character(2) VARCHAR2(2) NOT NULL ACT National Norms Assessment Scales Scores Math
    184 NORMS_SCORE_R_ACT Character(2) VARCHAR2(2) NOT NULL ACT National Norms Assessment Scales Scores Reading
    185 NORMS_SCORE_SR_ACT Character(2) VARCHAR2(2) NOT NULL ACT National Norms Assessment Scales Scores Science Reasoning
    186 NORMS_SCORE_C_ACT Character(2) VARCHAR2(2) NOT NULL ACT National Norms Assessment Scales Scores Composite
    187 NORMS_TYPE_ACT Character(1) VARCHAR2(1) NOT NULL ACT Norms Type
    188 SAD_EMAIL_LD Character(70) VARCHAR2(70) NOT NULL EMail Address
    189 SAD_SCI_INV_PC_RNK Character(2) VARCHAR2(2) NOT NULL ACT Science Interest Inventory Percentile Rank
    190 SAD_ART_INV_PC_RNK Character(2) VARCHAR2(2) NOT NULL ACT Arts Interest Inventory Percentile Rank
    191 SAD_SS_INV_PC_RNK Character(2) VARCHAR2(2) NOT NULL ACT Social Science Interest Inventory Percentile Rank
    192 SAD_BC_INV_PC_RNK Character(2) VARCHAR2(2) NOT NULL ACT Business Contact Interest Inventory Percentile Rank
    193 SAD_BO_INV_PC_RNK Character(2) VARCHAR2(2) NOT NULL ACT Business Operations Interest Inventory Percentile Rank
    194 SAD_TEC_INV_PC_RNK Character(2) VARCHAR2(2) NOT NULL ACT Technical Interest Inventory Percentile Rank
    195 SAD_MAX_TUITION Character(1) VARCHAR2(1) NOT NULL ACT Maximum Annual Tuition
    196 SAD_HIGH_SCH_DESCR Character(1) VARCHAR2(1) NOT NULL ACT High School Description
    197 SAD_CLASS_SIZE Character(1) VARCHAR2(1) NOT NULL ACT Class Size
    198 SAD_HSCH_PROG_TYPE Character(1) VARCHAR2(1) NOT NULL ACT High School Program Type
    199 SAD_PHONE_TYPE_LD Character(1) VARCHAR2(1) NOT NULL Telephone Type
    1=Home
    2=Cell
    3=Other
    200 SAD_MGUARD1_EDLVL Character(1) VARCHAR2(1) NOT NULL Mother/Guardian 1 Education Level
    1=Less Than High School
    2=High School Grad/GED
    3=Business/Tech/Certificate Pgm
    4=Some College, no degree/Cert
    5=Associate Degree 2 year
    6=Bachelor Degree 4 year
    7=1-2 year Graduate Degree
    8=Doctorate/Prof Degree
    201 SAD_FGUARD2_EDLVL Character(1) VARCHAR2(1) NOT NULL Father/Guardian 2 Education Level
    1=Less Than High School
    2=High School Grad/GED
    3=Business/Tech/Certificate Pgm
    4=Some College, no degree/Cert
    5=Associate Degree 2 year
    6=Bachelor Degree 4 year
    7=1-2 year Graduate Degree
    8=Doctorate/Prof Degree
    202 ETHNICHISP_IND Character(1) VARCHAR2(1) NOT NULL Ethnic Hispanic Indicator
    203 SAD_ACT_RACE_ETH Character(7) VARCHAR2(7) NOT NULL Ethnicity
    204 SAD_COUNTRY_LD Character(30) VARCHAR2(30) NOT NULL Test Load Country
    205 SAD_ACT_MOB_IND Number(4,2) DECIMAL(3,2) NOT NULL Mobility Index
    206 SAD_ACT_INSTYP_IND Number(4,2) DECIMAL(3,2) NOT NULL Institution Type Index
    207 SAD_ACT_SELECT_IND Number(3,1) DECIMAL(2,1) NOT NULL Selectivity Index
    208 SAD_ACT_INSSIZ_IND Number(3,1) DECIMAL(2,1) NOT NULL Instt Size Indicator
    209 SAD_ACT_INMJFIT_SC Number(4,2) DECIMAL(3,2) NOT NULL Instt Major Fit Score
    210 SAD_ACT_STATID_NBR Character(10) VARCHAR2(10) NOT NULL State Assigned Student ID