SFA_PF_INTRP_ST

(SQL Table)
 Index Back

Institut Interpret StageValues

Institut Interpret StageValues

  • Parent record: SFA_PF_CNTRL_ST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_PF_QUEUE_INST Number(9,0) DECIMAL(9) NOT NULL Load Instance
    2 CSS_ID Character(7) VARCHAR2(7) NOT NULL CSS ID Number
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    4 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: STUDENT_AID

    5 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

    6 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
    7 SFA_PF_STUAGE_STG Character(2) VARCHAR2(2) NOT NULL Age
    8 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
    9 MARITAL_STAT Character(1) VARCHAR2(1) NOT NULL Marital Status
    1=Single
    2=Married
    3=Separated
    4=Divorced
    5=Widowed
    10 NUMBER_IN_FAMILY Character(2) VARCHAR2(2) NOT NULL Nbr Family Members
    11 NUMBER_IN_COLLEGE Character(2) VARCHAR2(2) NOT NULL Nbr in College
    12 PAR_NUM_IN_FAMILY Character(2) VARCHAR2(2) NOT NULL Family Members
    13 PAR_NUM_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Nbr in College
    14 PARENTS_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Parents in College
    0=Neither
    1=One Parent
    2=Both Parents
    ?=?
    15 PAR_OTH_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Oth in College
    16 PAR_ZERO_LOSS_IND Character(1) VARCHAR2(1) NOT NULL Par Losses
    17 PAR_TUITION_IND Character(1) VARCHAR2(1) NOT NULL Par Tuition
    18 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
    19 IRA_KEOGH_IND Character(1) VARCHAR2(1) NOT NULL Stu IRA/Keogh
    20 HOME_IND Character(1) VARCHAR2(1) NOT NULL Stu Home Value
    1=Greater of Reported
    2=Lessor of Reported
    3=Both
    21 STU_SUM_AY_INC_IND Character(1) VARCHAR2(1) NOT NULL Stu P/T Income
    22 ASMD_FAM_MEM_IND Character(1) VARCHAR2(1) NOT NULL Stu Family Mem
    23 ASMD_IN_COLL_IND Character(1) VARCHAR2(1) NOT NULL Stu Nbr in Coll
    24 ASMD_MAR_STAT_IND Character(1) VARCHAR2(1) NOT NULL Stu Mar Status
    25 ASMD_P_FAM_MEM_IND Character(1) VARCHAR2(1) NOT NULL Par Family Mem
    26 ASMD_P_IN_COLL_IND Character(1) VARCHAR2(1) NOT NULL Par Tot in Coll
    27 ASMD_P_MR_STAT_IND Character(1) VARCHAR2(1) NOT NULL Par Mar Status
    28 STU_HOPE_LL_CREDIT Character(1) VARCHAR2(1) NOT NULL Student Hope/LL Credit Option
    1=Yes
    29 PAR_HOPE_LL_CREDIT Character(1) VARCHAR2(1) NOT NULL Parent Hope/LL Credit Option
    1=Yes
    30 PAR_COLA_ADJ_IND Character(1) VARCHAR2(1) NOT NULL Parent COLA Adjustment
    31 PAR_STU_ASSETS_IND Character(1) VARCHAR2(1) NOT NULL Stu Assets treated as Par Asts
    32 PAR_IPT_ASSETS_IND Character(1) VARCHAR2(1) NOT NULL Par Assets Imputed from Intrst
    33 STU_IPT_ASSETS_IND Character(1) VARCHAR2(1) NOT NULL Stu Assets Imputed from Intrst
    34 PAR_COLA_ADJ_VAL Character(5) VARCHAR2(5) NOT NULL Parent COLA Adj Value
    35 SFA_CP_CONTRIB_ADJ Character(1) VARCHAR2(1) NOT NULL Custodial Parent Contrib Adj
    36 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
    37 CHLD_AG_CESA_CLC_P Character(2) VARCHAR2(2) NOT NULL Sum Of Children Ages Under 18
    38 CHLD_NU_AESA_CLC_P Character(1) VARCHAR2(1) NOT NULL Number Children Under 18
    39 CHLD_AGES_CESA_CLC Character(3) VARCHAR2(3) NOT NULL Sum of Childrens Ages < 18
    40 CHLD_NUM_AESA_CLC Character(1) VARCHAR2(1) NOT NULL Number Children Under 18
    41 SFA_PF_IMPHOME_PAR Character(1) VARCHAR2(1) NOT NULL Impute Home Value Indicator
    N=No
    Y=Yes
    42 SFA_PF_IMPUTEHOME Character(1) VARCHAR2(1) NOT NULL Impute Home Value Indicator
    N=No
    Y=Yes