FAN_INST_STD_VW(SQL View) |
Index Back |
---|---|
Institutional Student 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.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' |
# | 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 |