FAN_INST_PAR_VW(SQL View) |
Index Back |
---|---|
Institutional Parent App ViewThis 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' |
# | 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. |