FAN_INST_CTL_VW

(SQL View)
 Index Back

Base Internal Student Aid View

This record houses data in the institutional application data. This is a view of this table used for Fin Aid Award Notification Letter equation selection processing.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.DT_APP_RECEIVED ,A.DT_APP_COMPLETED ,A.SIGNED_BY_APPLICNT ,A.SIGNED_BY_FATHER ,A.SIGNED_BY_MOTHER ,A.SIGNED_BY_SPOUSE ,A.SPECIAL_PROCESSING ,A.INAS_RFC_CALL ,A.CSS_ID ,A.CSS_SCHOOL_CODE ,A.CPS_SCHOOL_CODE ,A.CNAS_RFC_CALL ,A.SIGNED_ELECTRONIC ,A.DT_APP_LOADED ,A.IM_CALC_SELECT_PAR ,A.IM_CALC_SELECT_STU FROM PS_INST_CONTROL A WHERE A.APP_SOURCE_CODE = '8'

  • Parent record: STUDENT_AID

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

    Prompt Table: STDNT_AID_SRCH

    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 DT_APP_RECEIVED Date(10) DATE Date Application Received
    5 DT_APP_COMPLETED Date(10) DATE Date Application Completed
    6 SIGNED_BY_APPLICNT Character(1) VARCHAR2(1) NOT NULL Student Signed
    1=Yes
    2=No
    7 SIGNED_BY_FATHER Character(1) VARCHAR2(1) NOT NULL Father Signed
    1=Yes
    8 SIGNED_BY_MOTHER Character(1) VARCHAR2(1) NOT NULL Mother Signed
    1=Yes
    9 SIGNED_BY_SPOUSE Character(1) VARCHAR2(1) NOT NULL Spouse Signed
    1=Yes
    10 SPECIAL_PROCESSING Character(1) VARCHAR2(1) NOT NULL Special Circumstances
    1=Yes
    N=No
    Y=Yes
    11 INAS_RFC_CALL Character(1) VARCHAR2(1) NOT NULL Calc EFC via Remote Call
    N=No
    Y=Yes
    12 CSS_ID Character(7) VARCHAR2(7) NOT NULL CSS ID Number
    13 CSS_SCHOOL_CODE Character(4) VARCHAR2(4) NOT NULL CSS School Code
    14 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
    15 CNAS_RFC_CALL Character(1) VARCHAR2(1) NOT NULL Call CNAS via RFC
    16 SIGNED_ELECTRONIC Character(1) VARCHAR2(1) NOT NULL Electronic Signature
    1=Yes
    17 DT_APP_LOADED Date(10) DATE Date Application Loaded
    18 IM_CALC_SELECT_PAR Character(1) VARCHAR2(1) NOT NULL IM Calc Selected
    B=Base IM
    O=IM w/Options
    19 IM_CALC_SELECT_STU Character(1) VARCHAR2(1) NOT NULL IM Calc Selected
    B=Base IM
    E=IM Estimated
    O=IM w/Options