SAD_AP_SUS

(SQL Table)
 Index Back

AP Test Suspension Table

AP_SUSPN contains all records from the AP load process. AP edit will update fields. Those records which are 'clean' will be processed by the AP post program, loaded into the 'live' tables and then removed from the suspense table.

  • Parent Record Of SAD_AP_SUS_AWRD SAD_AP_SUS_PREV SAD_AP_SUS_SCHL SAD_AP_SUS_TEST

    • # 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 REG_NBR_AP Character(8) VARCHAR2(8) NOT NULL AP Registration Number
    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 SAD_MID_INIT_LD Character(1) VARCHAR2(1) NOT NULL Admissions Middle Initial from Test Load
    8 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

    Prompt Table: NAME_PREFIX_TBL

    9 SAD_ADDRESS1_LD Character(55) VARCHAR2(55) NOT NULL Address 1
    10 SAD_ADDRESS2_LD Character(55) VARCHAR2(55) NOT NULL Address 2
    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_POSTAL_LD Character(15) VARCHAR2(15) NOT NULL Test Load Postal Code
    15 SAD_COUNTRY_LD Character(30) VARCHAR2(30) NOT NULL Test Load Country
    16 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    17 SAD_SEX_LD Character(1) VARCHAR2(1) NOT NULL Test Load Gender
    18 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    19 SAD_BIRTHDATE_LD Character(10) VARCHAR2(10) NOT NULL Admissions Birthdate from Test Load
    20 BIRTHDATE Date(10) DATE Date of Birth
    21 SAD_SSN_LD Character(9) VARCHAR2(9) NOT NULL Admissions Test Load SSN
    22 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    23 ED_LEVEL_AP Character(1) VARCHAR2(1) NOT NULL Education Level
    24 EXPCTD_COL_ENTR_AP Character(3) VARCHAR2(3) NOT NULL AP Expected College Entrance
    25 SAD_ETHNICITY_LD Character(2) VARCHAR2(2) NOT NULL Ethnicity
    26 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: ETHNIC_GRP_TBL
    Set Control Field: REG_REGION

    27 APLY_SPHMR_STND_AP Character(1) VARCHAR2(1) NOT NULL AP Apply Sophmore Standing
    28 DT_GRADE_REL_AP Character(6) VARCHAR2(6) NOT NULL AP Date Grade Released
    29 DT_CAND_UPDT_AP Character(6) VARCHAR2(6) NOT NULL AP Date of Last Candidate Update
    30 DT_REPORT_AP Character(6) VARCHAR2(6) NOT NULL AP Date of this Report
    31 SRVC_TYPE_AP Character(2) VARCHAR2(2) NOT NULL AP Service Type
    32 SRVC_CODE_AP Character(4) VARCHAR2(4) NOT NULL AP Service Code
    33 ORDR_INST_KEY_AP Character(8) VARCHAR2(8) NOT NULL AP Ordering Institution Key
    34 STDNT_SRCH_FLAG_AP Character(1) VARCHAR2(1) NOT NULL AP Student Search Flag
    35 BEST_LANGUAGE_AP Character(1) VARCHAR2(1) NOT NULL AP Best Language