INST_CONTROL

(SQL Table)
 Index Back

Institutional App Control Tbl

This record houses data in the institutional application data.

  • 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 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

    Prompt Table: %EDITTABLE

    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 INAS_RFC_CALL Character(1) VARCHAR2(1) NOT NULL Calc EFC via Remote Call
    N=No
    Y=Yes
    13 CSS_ID Character(7) VARCHAR2(7) NOT NULL CSS ID Number
    14 CSS_SCHOOL_CODE Character(4) VARCHAR2(4) NOT NULL CSS School Code
    15 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code
    16 CNAS_RFC_CALL Character(1) VARCHAR2(1) NOT NULL Call CNAS via RFC
    17 SIGNED_ELECTRONIC Character(1) VARCHAR2(1) NOT NULL Electronic Signature
    1=Yes
    18 DT_APP_LOADED Date(10) DATE Date Application Loaded
    19 IM_CALC_SELECT_PAR Character(1) VARCHAR2(1) NOT NULL IM Calc Selected
    B=Base IM
    O=IM w/Options

    Default Value: B

    20 IM_CALC_SELECT_STU Character(1) VARCHAR2(1) NOT NULL IM Calc Selected
    B=Base IM
    E=IM Estimated
    O=IM w/Options

    Default Value: B

    21 EFC_OVRD_DSPLAY_IM Character(1) VARCHAR2(1) NOT NULL Flag that triggers the display of EFC Override labels.
    B=Display Base Override Label
    N=No Override Label Display
    O=Display Options Override Label

    Default Value: N

    22 SFA_APPL_TYPE Character(1) VARCHAR2(1) NOT NULL Application Type
    1=Domestic PROFILE
    2=Noncustodial PROFILE
    3=Registration Only Record
    4=International PROFILE
    23 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
    24 SFA_PF_CREATED_DT Date(10) DATE Created Date
    25 SFA_PF_NCP_DT_RCV Date(10) DATE NCP Application Receipt Date
    26 SFA_PF_SCHL_PERID Character(20) VARCHAR2(20) NOT NULL School Assigned Person ID
    27 SFA_PF_EXPLN_TXT Long Character CLOB Explanations Text
    28 SFA_PF_PRIOR_INST Character(5) VARCHAR2(5) NOT NULL Previous Institution
    29 SFA_PF_CBFINAID_ID Character(7) VARCHAR2(7) NOT NULL CB FinAid ID
    30 SFA_PF_ADDCOL_SBDT Character(10) VARCHAR2(10) NOT NULL Add College Submit Date
    31 SFA_PF_ADDCOLSB_DT Date(10) DATE Add College Submit Date
    32 SFA_PF_CHNG_EMPLMT Character(1) VARCHAR2(1) NOT NULL Change in Employment
    N=No
    Y=Yes
    33 SFA_PF_SCHOLARSHIP Character(1) VARCHAR2(1) NOT NULL Scholarship
    N=No
    Y=Yes
    34 SFA_PF_DEN_EXP_IND Character(1) VARCHAR2(1) NOT NULL Medical/Dental Exp
    N=No
    Y=Yes
    35 SFA_PF_PVT_SCH_IND Character(1) VARCHAR2(1) NOT NULL Siblings Private School Ind
    N=No
    Y=Yes
    36 SFA_PF_CATASTR_IND Character(1) VARCHAR2(1) NOT NULL Catastrophic Event
    N=No
    Y=Yes
    37 SFA_PF_ELDER_CARE Character(1) VARCHAR2(1) NOT NULL Elder Care
    N=No
    Y=Yes
    38 SFA_PF_NONRECUR_IN Character(1) VARCHAR2(1) NOT NULL Non Recurring Income
    N=No
    Y=Yes
    39 SFA_PF_FIN_SUP_IND Character(1) VARCHAR2(1) NOT NULL Financial Support
    N=No
    Y=Yes
    40 SFA_PF_NONE_IND Character(1) VARCHAR2(1) NOT NULL None
    N=No
    Y=Yes
    41 SFA_PF_OTH_IND Character(1) VARCHAR2(1) NOT NULL Other
    N=No
    Y=Yes
    42 SFA_PF_COVID19_IND Character(1) VARCHAR2(1) NOT NULL Covid-19
    N=No
    Y=Yes
    43 SFA_PF_TXN_NBR Number(1,0) SMALLINT NOT NULL This field is used to hold the Transaction umber of the Profile files
    44 SFA_PF_CORECTN_IND Character(1) VARCHAR2(1) NOT NULL This field is used to hold the Correction Record Indictor of the Profile files
    N=No
    Y=Yes
    45 SFA_PF_CRTN_DT Date(10) DATE Correction Date
    46 IM_CALC_SELECTED Character(1) VARCHAR2(1) NOT NULL IM Calc Selected
    B=Base IM
    E=Estimated FM
    O=IM w/Options

    Default Value: B

    47 SFA_PF_LI_PATHELIG Character(1) VARCHAR2(1) NOT NULL Low Income Eligible
    N=No
    Y=Yes
    48 SFA_PF_PROF_LITE Character(1) VARCHAR2(1) NOT NULL Profile Lite
    N=No
    Y=Yes