FAN_INST_INT_VW

(SQL View)
 Index Back

Institutional Int/Assm View

This table stores Institutional Application need analysis data that was interpreted or asssumed from dataon an institutional need analysis formula. 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.DEPNDNCY_STAT ,A.AGE ,A.ASMD_YR_IN_COLL ,A.MARITAL_STAT ,A.NUMBER_IN_FAMILY ,A.NUMBER_IN_COLLEGE ,A.PAR_NUM_IN_FAMILY ,A.PAR_NUM_IN_COLLEGE ,A.PARENTS_IN_COLLEGE ,A.PAR_OTH_IN_COLLEGE ,A.PAR_ZERO_LOSS_IND ,A.PAR_TUITION_IND ,A.PAR_HOME_IND ,A.PAR_HOME_VAL ,A.PAR_HOME_DEBT ,A.PAR_AAI_RATE_IND ,A.IRA_KEOGH_IND ,A.AI_RATE_IND ,A.HOME_IND ,A.STU_HOME_VAL ,A.STU_HOME_DEBT ,A.STU_SUM_AY_INC_IND ,A.ASMD_FAM_MEM_IND ,A.ASMD_IN_COLL_IND ,A.ASMD_MAR_STAT_IND ,A.ASMD_P_FAM_MEM_IND ,A.ASMD_P_IN_COLL_IND ,A.ASMD_P_MR_STAT_IND ,A.STU_HOPE_LL_CREDIT ,A.PAR_HOPE_LL_CREDIT ,A.PAR_COLA_ADJ_IND ,A.PAR_STU_ASSETS_IND ,A.PAR_IPT_ASSETS_IND ,A.STU_IPT_ASSETS_IND ,A.PAR_COLA_ADJ_VAL FROM PS_INST_INTERPRET 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 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
    5 AGE Number(3,0) SMALLINT NOT NULL Age
    6 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
    7 MARITAL_STAT Character(1) VARCHAR2(1) NOT NULL Marital Status
    1=Single
    2=Married
    3=Separated
    4=Divorced
    5=Widowed
    8 NUMBER_IN_FAMILY Character(2) VARCHAR2(2) NOT NULL Nbr Family Members
    9 NUMBER_IN_COLLEGE Character(2) VARCHAR2(2) NOT NULL Nbr in College
    10 PAR_NUM_IN_FAMILY Character(2) VARCHAR2(2) NOT NULL Family Members
    11 PAR_NUM_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Nbr in College
    12 PARENTS_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Parents in College
    0=Neither
    1=One Parent
    2=Both Parents
    ?=?
    13 PAR_OTH_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Oth in College
    14 PAR_ZERO_LOSS_IND Character(1) VARCHAR2(1) NOT NULL Par Losses
    15 PAR_TUITION_IND Character(1) VARCHAR2(1) NOT NULL Par Tuition
    16 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
    17 PAR_HOME_VAL Number(7,0) INTEGER NOT NULL Home Value
    18 PAR_HOME_DEBT Number(7,0) INTEGER NOT NULL Home Debt
    19 PAR_AAI_RATE_IND Character(1) VARCHAR2(1) NOT NULL Par Adj Avail Inc
    20 IRA_KEOGH_IND Character(1) VARCHAR2(1) NOT NULL Stu IRA/Keogh
    21 AI_RATE_IND Character(1) VARCHAR2(1) NOT NULL Stu AI Rate
    22 HOME_IND Character(1) VARCHAR2(1) NOT NULL Stu Home Value
    1=Greater of Reported
    2=Lessor of Reported
    3=Both
    23 STU_HOME_VAL Number(6,0) INTEGER NOT NULL Home Value
    24 STU_HOME_DEBT Number(6,0) INTEGER NOT NULL Home Debt
    25 STU_SUM_AY_INC_IND Character(1) VARCHAR2(1) NOT NULL Stu P/T Income
    26 ASMD_FAM_MEM_IND Character(1) VARCHAR2(1) NOT NULL Stu Family Mem
    27 ASMD_IN_COLL_IND Character(1) VARCHAR2(1) NOT NULL Stu Nbr in Coll
    28 ASMD_MAR_STAT_IND Character(1) VARCHAR2(1) NOT NULL Stu Mar Status
    29 ASMD_P_FAM_MEM_IND Character(1) VARCHAR2(1) NOT NULL Par Family Mem
    30 ASMD_P_IN_COLL_IND Character(1) VARCHAR2(1) NOT NULL Par Tot in Coll
    31 ASMD_P_MR_STAT_IND Character(1) VARCHAR2(1) NOT NULL Par Mar Status
    32 STU_HOPE_LL_CREDIT Character(1) VARCHAR2(1) NOT NULL Student Hope/LL Credit Option
    1=Yes
    33 PAR_HOPE_LL_CREDIT Character(1) VARCHAR2(1) NOT NULL Parent Hope/LL Credit Option
    1=Yes
    34 PAR_COLA_ADJ_IND Character(1) VARCHAR2(1) NOT NULL Parent COLA Adjustment
    35 PAR_STU_ASSETS_IND Character(1) VARCHAR2(1) NOT NULL Stu Assets treated as Par Asts
    36 PAR_IPT_ASSETS_IND Character(1) VARCHAR2(1) NOT NULL Par Assets Imputed from Intrst
    37 STU_IPT_ASSETS_IND Character(1) VARCHAR2(1) NOT NULL Stu Assets Imputed from Intrst
    38 PAR_COLA_ADJ_VAL Character(5) VARCHAR2(5) NOT NULL Parent COLA Adj Value