INST_INTERPRET

(SQL Table)
 Index Back

Institutional Int/Assm Values

This table stores Institutional Application need analysis data that was interpreted or asssumed from dataon an institutional need analysis formula.

  • Parent record: INST_CONTROL

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

    Default Value: 8

    5 DEPNDNCY_STAT Character(1) VARCHAR2(1) NOT NULL Dependency Status
    1=Independent
    2=Dependent
    3=Indepenedent/Pro Judgmnt
    D=Dependent
    I=Independent
    X=Dependent Reject
    Y=Independent Reject
    Z=Provisional Independent
    6 AGE Number(3,0) SMALLINT NOT NULL Age
    7 ASMD_YR_IN_COLL Character(1) VARCHAR2(1) NOT NULL Year in College
    0=4th or More Grad/Prof
    1=1st (Never Attended)
    2=1st (Prev. Attended)
    3=2nd
    4=3rd
    5=4th
    6=5th or More Undergrad
    7=1st Grad/Prof
    8=2nd Grad/Prof
    9=3rd Grad/Prof
    8 MARITAL_STAT Character(1) VARCHAR2(1) NOT NULL Marital Status
    1=Single
    2=Married
    3=Separated
    4=Divorced
    5=Widowed
    9 NUMBER_IN_FAMILY Character(2) VARCHAR2(2) NOT NULL Nbr Family Members
    10 NUMBER_IN_COLLEGE Character(2) VARCHAR2(2) NOT NULL Nbr in College
    11 PAR_NUM_IN_FAMILY Character(2) VARCHAR2(2) NOT NULL Family Members
    12 PAR_NUM_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Nbr in College
    13 PARENTS_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Parents in College
    0=Neither
    1=One Parent
    2=Both Parents
    ?=?
    14 PAR_OTH_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Oth in College
    15 PAR_ZERO_LOSS_IND Character(1) VARCHAR2(1) NOT NULL Par Losses
    16 PAR_TUITION_IND Character(1) VARCHAR2(1) NOT NULL Par Tuition
    17 PAR_HOME_IND Character(1) VARCHAR2(1) NOT NULL Par Home Value
    1=Greater of Reported
    2=Lessor of Reported
    3=Both
    4=Calced using 2.4 index cap
    18 PAR_HOME_VAL Number(7,0) INTEGER NOT NULL Home Value
    19 PAR_HOME_DEBT Number(7,0) INTEGER NOT NULL Home Debt
    20 PAR_AAI_RATE_IND Character(1) VARCHAR2(1) NOT NULL Par Adj Avail Inc
    21 IRA_KEOGH_IND Character(1) VARCHAR2(1) NOT NULL Stu IRA/Keogh
    22 AI_RATE_IND Character(1) VARCHAR2(1) NOT NULL Stu AI Rate
    23 HOME_IND Character(1) VARCHAR2(1) NOT NULL Stu Home Value
    1=Greater of Reported
    2=Lessor of Reported
    3=Both
    24 STU_HOME_VAL Number(6,0) INTEGER NOT NULL Home Value
    25 STU_HOME_DEBT Number(6,0) INTEGER NOT NULL Home Debt
    26 STU_SUM_AY_INC_IND Character(1) VARCHAR2(1) NOT NULL Stu P/T Income
    27 ASMD_FAM_MEM_IND Character(1) VARCHAR2(1) NOT NULL Stu Family Mem
    28 ASMD_IN_COLL_IND Character(1) VARCHAR2(1) NOT NULL Stu Nbr in Coll
    29 ASMD_MAR_STAT_IND Character(1) VARCHAR2(1) NOT NULL Stu Mar Status
    30 ASMD_P_FAM_MEM_IND Character(1) VARCHAR2(1) NOT NULL Par Family Mem
    31 ASMD_P_IN_COLL_IND Character(1) VARCHAR2(1) NOT NULL Par Tot in Coll
    32 ASMD_P_MR_STAT_IND Character(1) VARCHAR2(1) NOT NULL Par Mar Status
    33 STU_HOPE_LL_CREDIT Character(1) VARCHAR2(1) NOT NULL Student Hope/LL Credit Option
    1=Yes
    34 PAR_HOPE_LL_CREDIT Character(1) VARCHAR2(1) NOT NULL Parent Hope/LL Credit Option
    1=Yes
    35 PAR_COLA_ADJ_IND Character(1) VARCHAR2(1) NOT NULL Parent COLA Adjustment
    36 PAR_STU_ASSETS_IND Character(1) VARCHAR2(1) NOT NULL Stu Assets treated as Par Asts
    37 PAR_IPT_ASSETS_IND Character(1) VARCHAR2(1) NOT NULL Par Assets Imputed from Intrst
    38 STU_IPT_ASSETS_IND Character(1) VARCHAR2(1) NOT NULL Stu Assets Imputed from Intrst
    39 PAR_COLA_ADJ_VAL Character(5) VARCHAR2(5) NOT NULL Parent COLA Adj Value
    40 ISTU_IPT_ASSET_IND Character(1) VARCHAR2(1) NOT NULL Independent Student IPT Assets
    41 SFA_CP_CONTRIB_ADJ Character(1) VARCHAR2(1) NOT NULL Custodial Parent Contrib Adj
    42 SFA_PF_PARMAR_STAT Character(1) VARCHAR2(1) NOT NULL Parent Marital Status
    1=Never Married
    2=Married Or Domestic Relation
    4=Separated
    5=Divorce Or No Domestic Partner
    6=Widowed
    43 SFA_PF_IMPHOME_PAR Character(1) VARCHAR2(1) NOT NULL Impute Home Value Indicator
    N=No
    Y=Yes

    Default Value: N

    44 SFA_PF_IMPUTEHOME Character(1) VARCHAR2(1) NOT NULL Impute Home Value Indicator
    N=No
    Y=Yes

    Default Value: N

    45 SFA_EFM_POVRTY_MET Character(1) VARCHAR2(1) NOT NULL Met Poverty Guidelines
    N=No
    Y=Yes

    Default Value: N