SUSP_PROF_COMM

(SQL Table)
Index Back

Base Student Aid Suspense Tbl

This record houses data in the institutional application data.

  • Parent record: SUSP_PROF_CNTRL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CSS_ID Character(7) VARCHAR2(7) NOT NULL CSS ID Number
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: STUDENT_AID

    4 APP_SOURCE_CODE Character(1) VARCHAR2(1) NOT NULL Application Source Code
    0=Need Access
    0=Need Access
    1=Electronic Initial Application
    2=Electronic Renewal Aplication
    3=Electronic Correction
    4=FAFSA Express
    5=ACT
    6=I-NET
    7=NCS
    8=Profile
    9=Institutional Application
    O=FT Canada Student Loan
    P=PT Canada Student Loan
    5 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
    8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    9 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

    Prompt Table: HCR_NM_PREFIX_I

    10 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    12 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    13 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    14 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    15 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    16 CITY Character(30) VARCHAR2(30) NOT NULL City
    17 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    18 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    19 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    20 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    21 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    22 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    23 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    24 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    25 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    26 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    27 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    28 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    29 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
    30 MAR_STATUS_DT Date(10) DATE This is the date that the employee's Marital status is/was effective. /* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons. 1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user. 2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
    31 BIRTHDATE Date(10) DATE Date of Birth
    32 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Prompt Table: HCR_CTZN_STS_I

    33 VISA_WRKPMT_NBR Character(15) VARCHAR2(15) NOT NULL Visa/Permit Number
    34 DRIVERS_LIC_NBR Character(20) VARCHAR2(20) NOT NULL Driver's License #
    35 DRIV_LIC_STATE Character(6) VARCHAR2(6) NOT NULL Issuing State
    36 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    37 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone