FAN_INST_STD_VW

(SQL View)
Index Back

Institutional Student App View

This record houses 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.CURRENCY_CD ,A.SA_APP_STATUS ,A.NUM_FAMILY_MEMBERS ,A.NUMBER_IN_COLLEGE ,A.VETERAN ,A.ORPHAN ,A.DEPENDENTS ,A.TAX_FORM_FILED ,A.NUMBER_EXEMPTIONS ,A.AGI ,A.TAXES_PAID ,A.ITEMIZED_DEDUCTION ,A.STD_EARNED_INCOME ,A.SPS_EARNED_INCOME ,A.DIVID_INT_INCOME ,A.SOC_SEC_BENEFITS ,A.AFDC_BENEFITS ,A.CHILD_SUPPORT_RCVD ,A.EARNED_INC_CREDIT ,A.UNTAXED_INCOME ,A.STU_AID_INCOME ,A.CASH_SAVINGS ,A.IRA_VALUE ,A.RE_INVEST_VALUE ,A.INVEST_VALUE ,A.INVEST_DEBT ,A.RE_INVEST_DEBT ,A.HOME_VALUE ,A.HOME_DEBT ,A.BUS_FARM_VALUE ,A.BUS_FARM_DEBT ,A.LIVE_ON_FARM ,A.HOME_PURCH_YEAR ,A.HOME_PURCH_PRICE ,A.TRUST_AMOUNT ,A.TRUST_AVAIL ,A.TRUST_ESTABLISHER ,A.CHILD_SUPPORT_PAID ,A.MED_DENT_EXPENSES ,A.MONTHLY_VET_BEN ,A.NUM_MONTH_VET_BEN ,A.SUMMER_WAGES ,A.SCHOOL_YR_WAGES ,A.SPS_SUMM_WAGES ,A.SPS_SCH_YR_WAGES ,A.SUMMER_OTH_INCOME ,A.SCH_YR_OTH_INCOME ,A.SUMMER_UNTAXED ,A.SCHOOL_YR_UNTAXED ,A.GRANT_SCHOLARSHIP ,A.TUITION_BENEFITS ,A.PARENTS_CONTRIB ,A.RELATIVES_CONTRIB ,A.CURRENT_GRADE_LVL ,A.MARITAL_STAT ,A.STATE_RESIDENCE ,A.HOPE_LL_CREDIT ,A.EMAIL_ADDR ,A.CHLD_NUM_AESA_CLC ,A.CHLD_AGES_CESA_CLC ,A.POSTAL FROM PS_INST_STUDENT 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: PERSONAL_DATA

    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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    5 SA_APP_STATUS Character(1) VARCHAR2(1) NOT NULL Financial Aid Status
    1=First-time App, New Student
    2=Renewal App, Cont. Student
    3=First-time App, Cont. Student
    6 NUM_FAMILY_MEMBERS Character(2) VARCHAR2(2) NOT NULL Nbr in Family
    7 NUMBER_IN_COLLEGE Character(2) VARCHAR2(2) NOT NULL Nbr in College
    8 VETERAN Character(1) VARCHAR2(1) NOT NULL Veteran
    1=Yes
    2=No
    N=No
    Y=Yes
    9 ORPHAN Character(1) VARCHAR2(1) NOT NULL Orphan or Ward of the Court
    1=Yes
    2=No
    N=No
    Y=Yes
    10 DEPENDENTS Character(1) VARCHAR2(1) NOT NULL Dependents Other Than Spouse
    1=Yes
    2=No
    N=No
    Y=Yes
    11 TAX_FORM_FILED Character(1) VARCHAR2(1) NOT NULL Tax Form Filed
    1=Completed 1040A/EZ
    2=Completed 1040
    3=Estimated 1040A/EZ
    4=Estimated 1040
    5=Will Not File
    12 NUMBER_EXEMPTIONS Character(2) VARCHAR2(2) NOT NULL Nbr of Exemptions
    00=00
    01=01
    02=02
    03=03
    04=04
    05=05
    06=06
    07=07
    08=08
    09=09
    1=1
    10=10
    11=11
    12=12
    2=2
    3=3
    4=4
    5=5
    6=6
    7=7
    8=8
    9=9
    ?=?
    13 AGI Signed Number(11,0) DECIMAL(10) NOT NULL Adjusted Gross Income
    14 TAXES_PAID Signed Number(11,0) DECIMAL(10) NOT NULL U.S. Tax Paid
    15 ITEMIZED_DEDUCTION Signed Number(11,0) DECIMAL(10) NOT NULL Itemized Deductions
    16 STD_EARNED_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Student's Earned Income
    17 SPS_EARNED_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Spouse's Earned Income
    18 DIVID_INT_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Dividend and Interest Income
    19 SOC_SEC_BENEFITS Signed Number(11,0) DECIMAL(10) NOT NULL SS Benefits
    20 AFDC_BENEFITS Signed Number(11,0) DECIMAL(10) NOT NULL AFDC Benefits
    21 CHILD_SUPPORT_RCVD Signed Number(11,0) DECIMAL(10) NOT NULL Child Supp Rec'd
    22 EARNED_INC_CREDIT Signed Number(11,0) DECIMAL(10) NOT NULL Earned Income Credit
    23 UNTAXED_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Untaxed Income
    24 STU_AID_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Taxable Student Aid Income
    25 CASH_SAVINGS Signed Number(11,0) DECIMAL(10) NOT NULL Cash Savings
    26 IRA_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL IRA, Keogh, 401K Value
    27 RE_INVEST_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Real Estate Invest Value
    28 INVEST_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Investment Value
    29 INVEST_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Investment Debt
    30 RE_INVEST_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Real Estate Invest Debt
    31 HOME_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Home Value
    32 HOME_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Home Debt
    33 BUS_FARM_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Business/Farm Value
    34 BUS_FARM_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Business/Farm Debt
    35 LIVE_ON_FARM Character(1) VARCHAR2(1) NOT NULL Reside on Farm
    1=Yes
    2=No
    N=No
    Y=Yes
    36 HOME_PURCH_YEAR Character(4) VARCHAR2(4) NOT NULL Home Purchase Year
    37 HOME_PURCH_PRICE Signed Number(11,0) DECIMAL(10) NOT NULL Home Purchase Price
    38 TRUST_AMOUNT Signed Number(11,0) DECIMAL(10) NOT NULL Value of Trust Fund
    39 TRUST_AVAIL Character(1) VARCHAR2(1) NOT NULL Trust Available
    1=Yes
    2=No
    N=No
    Y=Yes
    40 TRUST_ESTABLISHER Character(1) VARCHAR2(1) NOT NULL Trust Established by
    1=Parents
    2=Other
    O=Other
    P=Parents
    41 CHILD_SUPPORT_PAID Signed Number(11,0) DECIMAL(10) NOT NULL Child Support Paid
    42 MED_DENT_EXPENSES Signed Number(11,0) DECIMAL(10) NOT NULL Medical/Dental
    43 MONTHLY_VET_BEN Signed Number(11,0) DECIMAL(10) NOT NULL Monthly Vet Edu Benefits
    44 NUM_MONTH_VET_BEN Character(2) VARCHAR2(2) NOT NULL VA Ben Number of Months
    45 SUMMER_WAGES Signed Number(11,0) DECIMAL(10) NOT NULL Summer Wages
    46 SCHOOL_YR_WAGES Signed Number(11,0) DECIMAL(10) NOT NULL School Year Wages
    47 SPS_SUMM_WAGES Signed Number(11,0) DECIMAL(10) NOT NULL Spouse's Summer Wages
    48 SPS_SCH_YR_WAGES Signed Number(11,0) DECIMAL(10) NOT NULL Spouses School Year Wages
    49 SUMMER_OTH_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Summer Other Taxable Income
    50 SCH_YR_OTH_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL School Year Other Income
    51 SUMMER_UNTAXED Signed Number(11,0) DECIMAL(10) NOT NULL Summer Untaxed Income
    52 SCHOOL_YR_UNTAXED Signed Number(11,0) DECIMAL(10) NOT NULL School Year Untaxed Income
    53 GRANT_SCHOLARSHIP Signed Number(11,0) DECIMAL(10) NOT NULL Grant/Scholarship
    54 TUITION_BENEFITS Signed Number(11,0) DECIMAL(10) NOT NULL Tuition Benefits
    55 PARENTS_CONTRIB Signed Number(11,0) DECIMAL(10) NOT NULL Parents Contribution
    56 RELATIVES_CONTRIB Signed Number(11,0) DECIMAL(10) NOT NULL Relative's Contributions
    57 CURRENT_GRADE_LVL Character(2) VARCHAR2(2) NOT NULL Current Grade Level
    01=1st yr Never Attended
    02=1st yr Attended Before
    03=2nd yr Sophmore
    04=3rd yr Junior
    05=4th yr Senior
    06=5th yr other UG
    07=1st yr Grad/Prof
    08=2nd yr Grad/Prof
    09=3rd yr Grad/Prof
    10=Beyond 3rd yr Grad/Prof
    58 MARITAL_STAT Character(1) VARCHAR2(1) NOT NULL Marital Status
    1=Single
    2=Married
    3=Separated
    4=Divorced
    5=Widowed
    59 STATE_RESIDENCE Character(6) VARCHAR2(6) NOT NULL State of Residence

    Prompt Table: USA_STATE_VW

    60 HOPE_LL_CREDIT Signed Number(11,0) DECIMAL(10) NOT NULL Hope Lifetime Learning Credit
    61 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    62 CHLD_NUM_AESA_CLC Character(1) VARCHAR2(1) NOT NULL Number Children Under 18
    63 CHLD_AGES_CESA_CLC Character(3) VARCHAR2(3) NOT NULL Sum of Childrens Ages < 18
    64 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal