SAD_AP_CD

(SQL Table)
 Index Back

AP Test ACI Table

AP_ACI contains all records from the AP post process.

  • Parent Record Of SAD_AP_CD_AWRD SAD_AP_CD_PREV SAD_AP_CD_SCHL SAD_AP_CD_TEST

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

    Prompt Table: PEOPLE_SRCH

    2 TEST_DT Date(10) DATE NOT NULL Test Date
    3 SAD_LAST_NAME_LD Character(32) VARCHAR2(32) NOT NULL Admissions Last Name from Test Load
    4 SAD_FIRST_NAME_LD Character(30) VARCHAR2(30) NOT NULL Admissions First Name from Test Load
    5 SAD_MID_INIT_LD Character(1) VARCHAR2(1) NOT NULL Admissions Middle Initial from Test Load
    6 SAD_ADDRESS1_LD Character(55) VARCHAR2(55) NOT NULL Address 1
    7 SAD_ADDRESS2_LD Character(55) VARCHAR2(55) NOT NULL Address 2
    8 SAD_CITY_LD Character(40) VARCHAR2(40) NOT NULL Test Load City
    9 SAD_STATE_LD Character(60) VARCHAR2(60) NOT NULL Test Load State
    10 SAD_POSTAL_LD Character(15) VARCHAR2(15) NOT NULL Test Load Postal Code
    11 SAD_COUNTRY_LD Character(30) VARCHAR2(30) NOT NULL Test Load Country
    12 SAD_BIRTHDATE_LD Character(10) VARCHAR2(10) NOT NULL Admissions Birthdate from Test Load
    13 SAD_SEX_LD Character(1) VARCHAR2(1) NOT NULL Test Load Gender
    14 SAD_SSN_LD Character(9) VARCHAR2(9) NOT NULL Admissions Test Load SSN
    15 ED_LEVEL_AP Character(1) VARCHAR2(1) NOT NULL Education Level
    16 EXPCTD_COL_ENTR_AP Character(3) VARCHAR2(3) NOT NULL AP Expected College Entrance
    17 SAD_ETHNICITY_LD Character(2) VARCHAR2(2) NOT NULL Ethnicity
    18 STDNT_SRCH_FLAG_AP Character(1) VARCHAR2(1) NOT NULL AP Student Search Flag
    19 BEST_LANGUAGE_AP Character(1) VARCHAR2(1) NOT NULL AP Best Language
    20 DT_GRADE_REL_AP Character(6) VARCHAR2(6) NOT NULL AP Date Grade Released
    21 DT_CAND_UPDT_AP Character(6) VARCHAR2(6) NOT NULL AP Date of Last Candidate Update
    22 DT_REPORT_AP Character(6) VARCHAR2(6) NOT NULL AP Date of this Report
    23 SRVC_TYPE_AP Character(2) VARCHAR2(2) NOT NULL AP Service Type
    24 SRVC_CODE_AP Character(4) VARCHAR2(4) NOT NULL AP Service Code
    25 ORDR_INST_KEY_AP Character(8) VARCHAR2(8) NOT NULL AP Ordering Institution Key
    26 CAUSE_CREATION Character(1) VARCHAR2(1) NOT NULL Personal Data Impacts
    N=No Personal Data Impact
    U=Caused Personal Data Update
    Y=Caused Personal Data Creation

    Default Value: N

    27 REG_NBR_AP Character(8) VARCHAR2(8) NOT NULL AP Registration Number
    28 APLY_SPHMR_STND_AP Character(1) VARCHAR2(1) NOT NULL AP Apply Sophmore Standing