SUSP_PROF_CNTRL

(SQL Table)
 Index Back

Inst Control Susp Data

ISIR Suspense Management.

  • Parent record: STUDENT_AID

    • # 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 DT_APP_RECEIVED Date(10) DATE Date Application Received

    Default Value: %date

    6 DT_APP_COMPLETED Date(10) DATE Date Application Completed
    7 SIGNED_BY_APPLICNT Character(1) VARCHAR2(1) NOT NULL Student Signed
    1=Yes
    2=No
    8 SIGNED_BY_FATHER Character(1) VARCHAR2(1) NOT NULL Father Signed
    1=Yes
    9 SIGNED_BY_MOTHER Character(1) VARCHAR2(1) NOT NULL Mother Signed
    1=Yes
    10 SIGNED_BY_SPOUSE Character(1) VARCHAR2(1) NOT NULL Spouse Signed
    1=Yes
    11 SPECIAL_PROCESSING Character(1) VARCHAR2(1) NOT NULL Special Circumstances
    1=Yes
    N=No
    Y=Yes
    12 CSS_SCHOOL_CODE Character(4) VARCHAR2(4) NOT NULL CSS School Code
    13 PROCESSING_ACTION Character(1) VARCHAR2(1) NOT NULL Processing Action
    A=Add (Do NOT Replace)
    D=Delete from Database
    P=Pending
    R=Add to Database (Replace)
    14 SUSPEND_REASON Character(1) VARCHAR2(1) NOT NULL Suspend Reason
    1=1 - Student ID not Found
    2=2 - Student not at Load Level
    3=3 - Final Review Flag Set
    4=4 - No SAI Calculation
    5=5 - Invalid School Code
    6=6 - Student Id already Exists
    7=ISIR Tran Nbr out of Sequence
    8=8 - Registration Only Record
    9=9 -Non-Unique Student ID Found
    A=A - Student not at Admit Level
    E=SAI Mismatch
    F=10 - FA Term Not Built
    H=13 - HHB Add Person Suspend
    L=Load Update Profile Set To No
    M=11 - Manually Set to Suspended
    P=12- Packaging Completed
    T=Prof Tran Nbr out of Sequence
    15 ADMIT_LVL Character(1) VARCHAR2(1) NOT NULL Student's Admit Lvl
    0=0 - Student Not Found
    1=1 - Has Not Applied
    2=2 - Inactive
    3=3 - Applied/Pending
    4=4 - Admitted
    5=5 - Accepted/Continuing
    16 SIGNED_ELECTRONIC Character(1) VARCHAR2(1) NOT NULL Electronic Signature
    1=Yes
    17 REPORTING_TYPE Character(1) VARCHAR2(1) NOT NULL Institutional Reporting Type
    1=1st Time Application
    2=Subsequent Application
    3=Registration Only
    18 DT_APP_LOADED Date(10) DATE Date Application Loaded
    19 SFA_APPL_TYPE Character(1) VARCHAR2(1) NOT NULL Application Type
    1=Domestic PROFILE
    2=Noncustodial PROFILE
    3=Registration Only Record
    4=International PROFILE
    20 SFA_LOCTN_COMPUTER Character(1) VARCHAR2(1) NOT NULL Location of Computer
    1=Home
    2=Father's Work
    3=Mother's Work
    4=High School
    5=College
    6=Library
    7=Community Center
    8=Friend's or Relatives House
    9=Other