FAN_INST_PAR_VW

(SQL View)
Index Back

Institutional Parent 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.MARITAL_STAT ,A.LEGAL_RESIDENCE ,A.NUMBER_IN_FAMILY ,A.NUM_IN_COLLEGE ,A.PARENTS_IN_COLLEGE ,A.DIVORCED_SEPARATED ,A.PRNT_LOAN_EXP ,A.MED_DENT_EXPENSES ,A.TUIT_PD_AMOUNT ,A.TUIT_PD_NBR ,A.EXPCT_CHLD_SPPT_PD ,A.EXPCT_PRT_LOAN_EXP ,A.EXPCT_MED_DENT ,A.EXPCT_TUIT_PD_AMT ,A.EXPCT_TUIT_PD_NUM ,A.EXPCT_FATHER_INC ,A.EXPCT_MOTHER_INC ,A.EXPCT_OTH_INC ,A.EXPCT_OTH_UNTX_INC ,A.TAX_FORM_FILED ,A.NUMBER_EXEMPTIONS ,A.AGI ,A.AGI_PAR_INST ,A.WAGES_SAL_TIPS ,A.INTEREST_INCOME ,A.DIVIDEND_INCOME ,A.NET_INC_BUS_FARM ,A.OTH_TAXABLE_INC ,A.ADJ_TO_INCOME ,A.TAXES_PAID ,A.ITEMIZED_DEDUCTION ,A.CHILD_SUPPORT_PAID ,A.CHILD_SUPPORT_RCVD ,A.FATHER_INCOME ,A.MOTHER_INCOME ,A.SOC_SEC_BENEFITS ,A.AFDC_BENEFITS ,A.DEDUCT_IRA_PMTS ,A.TAX_DEFER_PENS_SAV ,A.DEP_MED_EXPENSE ,A.EARNED_INC_CREDIT ,A.LIVING_ALLOWANCE ,A.TAX_EXEMPT_INT_INC ,A.FOREIGN_INC_EXCL ,A.OTHER_UNTAX_INC ,A.AGE_OLDER_PARENT ,A.CASH_SAVINGS ,A.MONTH_MORTGAGE_PMT ,A.INVEST_VALUE ,A.INVEST_DEBT ,A.HOME_VALUE ,A.HOME_DEBT ,A.HOME_PURCH_YEAR ,A.HOME_PURCH_PRICE ,A.OWN_BUSINESS_FARM ,A.LIVE_ON_FARM ,A.RE_INVEST_VALUE ,A.RE_INVEST_DEBT ,A.OTH_RE_PURCH_YR ,A.OTH_RE_PURCH_AMT ,A.BUSINESS_VALUE ,A.BUSINESS_DEBT ,A.FARM_VALUE ,A.FARM_DEBT ,A.CURRENCY_CD ,A.PRIOR_AGI ,A.PRIOR_TAX_PAID ,A.PRIOR_DEDUCTIONS ,A.PRIOR_UNTAXED_INC ,A.AGE_FATHER ,A.AGE_MOTHER ,A.DIV_SEP_IND ,A.NO_CUSTODY_CONTRIB ,A.SIBLINGS_ASSETS ,A.HOPE_LL_CREDIT ,A.YEAR_DIVORCE ,A.YEAR_SEPARATION ,A.CHLD_NUM_AESA_CLC ,A.CHLD_AGES_CESA_CLC ,A.SIBLINGS_PRE_TUIT ,A.STUDENT_PRE_TUIT ,A.FOREIGN_INC_EXCL04 ,A.OTHER_UNTAX_INC_04 FROM PS_INST_PARENT 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 MARITAL_STAT Character(1) VARCHAR2(1) NOT NULL Marital Status
    1=Single
    2=Married
    3=Separated
    4=Divorced
    5=Widowed
    5 LEGAL_RESIDENCE Character(2) VARCHAR2(2) NOT NULL Legal Residence

    Prompt Table: USA_STATE_VW

    6 NUMBER_IN_FAMILY Character(2) VARCHAR2(2) NOT NULL Nbr Family Members
    7 NUM_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Nbr in College
    8 PARENTS_IN_COLLEGE Character(1) VARCHAR2(1) NOT NULL Parents in College
    0=Neither
    1=One Parent
    2=Both Parents
    ?=?
    9 DIVORCED_SEPARATED Character(1) VARCHAR2(1) NOT NULL Parents Separated/Divorced
    1=Yes
    2=No
    10 PRNT_LOAN_EXP Signed Number(11,0) DECIMAL(10) NOT NULL Annual Educ Loan Expense
    11 MED_DENT_EXPENSES Signed Number(11,0) DECIMAL(10) NOT NULL Medical/Dental
    12 TUIT_PD_AMOUNT Signed Number(11,0) DECIMAL(10) NOT NULL Other Tuition Paid
    13 TUIT_PD_NBR Character(1) VARCHAR2(1) NOT NULL Number of Tuition Paid
    14 EXPCT_CHLD_SPPT_PD Signed Number(11,0) DECIMAL(10) NOT NULL Child Sppt Paid
    15 EXPCT_PRT_LOAN_EXP Signed Number(11,0) DECIMAL(10) NOT NULL Loan Expense
    16 EXPCT_MED_DENT Signed Number(11,0) DECIMAL(10) NOT NULL Med/Dental Expenses
    17 EXPCT_TUIT_PD_AMT Signed Number(11,0) DECIMAL(10) NOT NULL Other Tuition Cost
    18 EXPCT_TUIT_PD_NUM Character(1) VARCHAR2(1) NOT NULL Nbr Tuitions
    19 EXPCT_FATHER_INC Signed Number(11,0) DECIMAL(10) NOT NULL Father's Earnings
    20 EXPCT_MOTHER_INC Signed Number(11,0) DECIMAL(10) NOT NULL Mother's Earnings
    21 EXPCT_OTH_INC Signed Number(11,0) DECIMAL(10) NOT NULL Other Taxable Income
    22 EXPCT_OTH_UNTX_INC Signed Number(11,0) DECIMAL(10) NOT NULL Untaxed Income and Benefits
    23 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
    24 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
    ?=?
    25 AGI Signed Number(11,0) DECIMAL(10) NOT NULL Adjusted Gross Income
    26 AGI_PAR_INST Signed Number(11,0) DECIMAL(10) NOT NULL Adjusted Gross Income used on INST_PAR fo rProfile/Need Access beginning 2001-02.
    27 WAGES_SAL_TIPS Signed Number(11,0) DECIMAL(10) NOT NULL Wages, Sal, & Tips
    28 INTEREST_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Interest Income
    29 DIVIDEND_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Dividend Income
    30 NET_INC_BUS_FARM Signed Number(11,0) DECIMAL(10) NOT NULL Bus/Farm Income
    31 OTH_TAXABLE_INC Signed Number(11,0) DECIMAL(10) NOT NULL Other Taxable
    32 ADJ_TO_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Adjustments to Income
    33 TAXES_PAID Signed Number(11,0) DECIMAL(10) NOT NULL U.S. Tax Paid
    34 ITEMIZED_DEDUCTION Signed Number(11,0) DECIMAL(10) NOT NULL Itemized Deductions
    35 CHILD_SUPPORT_PAID Signed Number(11,0) DECIMAL(10) NOT NULL Child Support Paid
    36 CHILD_SUPPORT_RCVD Signed Number(11,0) DECIMAL(10) NOT NULL Child Supp Rec'd
    37 FATHER_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Father's Earnings
    38 MOTHER_INCOME Signed Number(11,0) DECIMAL(10) NOT NULL Mother's Earnings
    39 SOC_SEC_BENEFITS Signed Number(11,0) DECIMAL(10) NOT NULL SS Benefits
    40 AFDC_BENEFITS Signed Number(11,0) DECIMAL(10) NOT NULL AFDC Benefits
    41 DEDUCT_IRA_PMTS Signed Number(11,0) DECIMAL(10) NOT NULL IRA/Keogh Payments
    42 TAX_DEFER_PENS_SAV Signed Number(11,0) DECIMAL(10) NOT NULL Tax Deferred Plans
    43 DEP_MED_EXPENSE Signed Number(6,0) DECIMAL(5) NOT NULL Medical, etc. Spend Accts.
    44 EARNED_INC_CREDIT Signed Number(11,0) DECIMAL(10) NOT NULL Earned Income Credit
    45 LIVING_ALLOWANCE Signed Number(11,0) DECIMAL(10) NOT NULL Living Allowance
    46 TAX_EXEMPT_INT_INC Signed Number(11,0) DECIMAL(10) NOT NULL Tax-Exempt Interest
    47 FOREIGN_INC_EXCL Signed Number(11,0) DECIMAL(10) NOT NULL Foreign Income Exclusions
    48 OTHER_UNTAX_INC Signed Number(11,0) DECIMAL(10) NOT NULL Other Untaxed
    49 AGE_OLDER_PARENT Character(2) VARCHAR2(2) NOT NULL Age of Older Parent
    50 CASH_SAVINGS Signed Number(11,0) DECIMAL(10) NOT NULL Cash Savings
    51 MONTH_MORTGAGE_PMT Signed Number(11,0) DECIMAL(10) NOT NULL Monthly Mortgage/Rent Payment
    52 INVEST_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Investment Value
    53 INVEST_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Investment Debt
    54 HOME_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Home Value
    55 HOME_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Home Debt
    56 HOME_PURCH_YEAR Character(4) VARCHAR2(4) NOT NULL Home Purchase Year
    57 HOME_PURCH_PRICE Signed Number(11,0) DECIMAL(10) NOT NULL Home Purchase Price
    58 OWN_BUSINESS_FARM Character(1) VARCHAR2(1) NOT NULL Own a Business or Farm
    1=Yes
    2=No
    59 LIVE_ON_FARM Character(1) VARCHAR2(1) NOT NULL Reside on Farm
    1=Yes
    2=No
    N=No
    Y=Yes
    60 RE_INVEST_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Real Estate Invest Value
    61 RE_INVEST_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Real Estate Invest Debt
    62 OTH_RE_PURCH_YR Character(4) VARCHAR2(4) NOT NULL Other Real Estate Purchase Yr
    63 OTH_RE_PURCH_AMT Signed Number(11,0) DECIMAL(10) NOT NULL Other Real Estate Purchase Amt
    64 BUSINESS_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Business Value
    65 BUSINESS_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Business Debt
    66 FARM_VALUE Signed Number(11,0) DECIMAL(10) NOT NULL Investment Farm Value
    67 FARM_DEBT Signed Number(11,0) DECIMAL(10) NOT NULL Investment Farm Debt
    68 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    69 PRIOR_AGI Signed Number(11,0) DECIMAL(10) NOT NULL Prior Year AGI
    70 PRIOR_TAX_PAID Signed Number(11,0) DECIMAL(10) NOT NULL Prior Year Taxes Paid
    71 PRIOR_DEDUCTIONS Signed Number(11,0) DECIMAL(10) NOT NULL Prior Year Item Deductions
    72 PRIOR_UNTAXED_INC Signed Number(11,0) DECIMAL(10) NOT NULL Prior Year Untaxed Income
    73 AGE_FATHER Character(2) VARCHAR2(2) NOT NULL Father's Age
    74 AGE_MOTHER Character(2) VARCHAR2(2) NOT NULL Mother's Age
    75 DIV_SEP_IND Character(1) VARCHAR2(1) NOT NULL Divorced/Separated/Remarried
    76 NO_CUSTODY_CONTRIB Signed Number(11,0) DECIMAL(10) NOT NULL Non-Custodial Parent's Contrib
    77 SIBLINGS_ASSETS Signed Number(11,0) DECIMAL(10) NOT NULL Assets Held by Siblings
    78 HOPE_LL_CREDIT Signed Number(11,0) DECIMAL(10) NOT NULL Hope Lifetime Learning Credit
    79 YEAR_DIVORCE Character(4) VARCHAR2(4) NOT NULL Year of Divorce
    80 YEAR_SEPARATION Character(4) VARCHAR2(4) NOT NULL Year of Separation
    81 CHLD_NUM_AESA_CLC Character(1) VARCHAR2(1) NOT NULL Number Children Under 18
    82 CHLD_AGES_CESA_CLC Character(3) VARCHAR2(3) NOT NULL Sum of Childrens Ages < 18
    83 SIBLINGS_PRE_TUIT Signed Number(8,0) DECIMAL(7) NOT NULL Siblings Prepaid Tuition
    84 STUDENT_PRE_TUIT Signed Number(8,0) DECIMAL(7) NOT NULL Student Prepaid Tuition
    85 FOREIGN_INC_EXCL04 Signed Number(11,0) DECIMAL(10) NOT NULL Replaces FOREIGN_INC_EXCL in INST_PARENT as of AY 2003/04. The reason is byte size increased from 6 to 7.
    86 OTHER_UNTAX_INC_04 Signed Number(11,0) DECIMAL(10) NOT NULL Replaces OTHER_UNTAX_INC on INST_PARENT as of 2003/04. The reason is that the byte size increased from 6 to 7.