SAD_CRS_SUS

(SQL Table)
 Index Back

CRS Test Suspension Table

CRS_SUSPN contains all records from the SSS (Student Search Service) load process.

  • Parent Record Of SAD_CRS_SUS_JP SAD_CRS_SUS_MJR SAD_CRS_SUS_PRV SAD_CRS_SUS_STD SAD_CRS_SUS_STS

    • # 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 SAD_LAST_NAME_LD Character(32) VARCHAR2(32) NOT NULL Admissions Last Name from Test Load
    5 SAD_FIRST_NAME_LD Character(30) VARCHAR2(30) NOT NULL Admissions First Name from Test Load
    6 SAD_MID_INIT_LD Character(1) VARCHAR2(1) NOT NULL Admissions Middle Initial from Test Load
    7 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

    Prompt Table: NAME_PREFIX_TBL

    8 SAD_ADDRESS1_LD Character(55) VARCHAR2(55) NOT NULL Address 1
    9 SAD_ADDRESS2_LD Character(55) VARCHAR2(55) NOT NULL Address 2
    10 SAD_ADDRESS3_LD Character(55) VARCHAR2(55) NOT NULL Address 3
    11 SAD_CITY_LD Character(40) VARCHAR2(40) NOT NULL Test Load City
    12 SAD_STATE_LD Character(60) VARCHAR2(60) NOT NULL Test Load State
    13 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_NAMES_TBL

    14 SAD_COUNTRY_LD Character(30) VARCHAR2(30) NOT NULL Test Load Country
    15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    16 SAD_POSTAL_LD Character(15) VARCHAR2(15) NOT NULL Test Load Postal Code
    17 SAD_TELEPHONE_LD Character(20) VARCHAR2(20) NOT NULL Telephone Number
    18 SAD_SSN_LD Character(9) VARCHAR2(9) NOT NULL Admissions Test Load SSN
    19 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    20 SAD_ETHNICITY_LD Character(2) VARCHAR2(2) NOT NULL Ethnicity
    21 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: ETHNIC_GRP_TBL
    Set Control Field: REG_REGION

    22 SAD_BIRTHDATE_LD Character(10) VARCHAR2(10) NOT NULL Admissions Birthdate from Test Load
    23 BIRTHDATE Date(10) DATE Date of Birth
    24 SAD_SEX_LD Character(1) VARCHAR2(1) NOT NULL Test Load Gender
    25 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    26 PERM_STATE_CRS Character(2) VARCHAR2(2) NOT NULL CRS Permanent State
    27 US_CITIZEN_CRS Character(1) VARCHAR2(1) NOT NULL US Citizen/Resident Alien
    28 CAN_CITIZEN_CRS Character(1) VARCHAR2(1) NOT NULL Canada Citizen/Landed Immgrant
    29 UNDGRD_DEG_CD_CRS Character(4) VARCHAR2(4) NOT NULL Undergraduate Information
    30 UNDGRD_DEG_DT_CRS Character(6) VARCHAR2(6) NOT NULL Undergraduate Degree Date
    31 DEGREE_DT Date(10) DATE Admissions degree date.
    32 UNDGRD_SCH_ST_CRS Character(2) VARCHAR2(2) NOT NULL School State (Numeric)
    33 CMPLT_FLAG_CRS Character(1) VARCHAR2(1) NOT NULL Complete Flag
    34 SAD_TEST_DT_LD Character(10) VARCHAR2(10) NOT NULL Test Load Test Date
    35 TEST_DT Date(10) DATE NOT NULL Test Date
    36 SAD_TST_COMP1 Character(5) VARCHAR2(5) NOT NULL Test Component 1

    Prompt Table: SA_TCMP_REL_TBL

    37 SAD_SCORE_COMP1 Number(7,2) DECIMAL(6,2) NOT NULL Score
    38 SAD_TST_COMP1_ERR Character(1) VARCHAR2(1) NOT NULL Error

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    40 SAD_TST_SCR_COMP1 Character(3) VARCHAR2(3) NOT NULL Test Component 1 Score
    41 TEST_ADMIN Character(1) VARCHAR2(1) NOT NULL Standard Test Administration

    Y/N Table Edit

    Default Value: N

    42 AVG_LSAT_SCORE_CRS Character(3) VARCHAR2(3) NOT NULL Average LSAT Score
    43 VLD_LSAT_SCRS_CRS Character(2) VARCHAR2(2) NOT NULL Number of Valid LSAT Scores
    44 ACCO_TST_FLAG_CRS Character(1) VARCHAR2(1) NOT NULL Accommodated Test Flag
    45 DT_UPCMNG_LSAT_CRS Character(6) VARCHAR2(6) NOT NULL Date of Upcoming LSAT
    46 LSDAS_GPA_CRS Character(4) VARCHAR2(4) NOT NULL LSDAS GPA
    47 SELF_RPRTD_GPA_CRS Character(1) VARCHAR2(1) NOT NULL Self-Reported GPA
    48 LAW_SCHL_CD_CRS Character(4) VARCHAR2(4) NOT NULL Law School Code
    49 SAD_CRS_PERM_ST Character(2) VARCHAR2(2) NOT NULL CRS Permanent State or Province
    50 SAD_CRS_UGRD_ST Character(2) VARCHAR2(2) NOT NULL CRS Udergraduate School State
    51 SAD_CRS_MSTR_ID Character(10) VARCHAR2(10) NOT NULL CRS Master ID for this request
    52 SAD_CRS_RUN_DT Character(8) VARCHAR2(8) NOT NULL CRS Run Date
    53 SAD_EMAIL_LD Character(70) VARCHAR2(70) NOT NULL EMail Address
    54 SAD_CRS_CIT_FLG Character(1) VARCHAR2(1) NOT NULL Citizen of country other than US or Canada
    55 SAD_CRS_EMP_STS Character(1) VARCHAR2(1) NOT NULL CRS Current Employment
    56 SAD_CRS_EMP_YRS Character(1) VARCHAR2(1) NOT NULL CRS Years of Full-time Employment
    57 SAD_CRS_MIL_SVC Character(1) VARCHAR2(1) NOT NULL CRS Military Service
    58 SAD_CRS_CLS_RNK Character(1) VARCHAR2(1) NOT NULL Class Rank
    59 SAD_CRS_DEG_HI Character(1) VARCHAR2(1) NOT NULL CRS Highest Degree Earned
    60 SAD_CRS_PGM_TIM Character(1) VARCHAR2(1) NOT NULL CRS Program Time
    61 SAD_CRS_GEO_CHS Character(1) VARCHAR2(1) NOT NULL CRS Geographic Characteristics
    62 SAD_CRS_REL_AFF Character(1) VARCHAR2(1) NOT NULL CRS Religious Affiliation
    63 SAD_CRS_GLBT_ST Character(1) VARCHAR2(1) NOT NULL GLBT Status
    64 SAD_CRS_CRSEWRK1 Character(2) VARCHAR2(2) NOT NULL Coursework 1
    65 SAD_CRS_CRSEWRK2 Character(2) VARCHAR2(2) NOT NULL CRS Coursework 2
    66 SAD_CRS_ENR_YR Character(2) VARCHAR2(2) NOT NULL CRS Expected enrollment year
    67 SAD_CRS_REG_NBR Character(5) VARCHAR2(5) NOT NULL CRS Forum Registration Number
    68 SAD_LSAC_ACCT_NBR Character(9) VARCHAR2(9) NOT NULL LSAC Account Number