| Data element |
Definition |
| Add_Coll_Date Indexed - no
Format - Date (7)
May be Null? Y | Last refreshed date within data warehouse. |
| Adm_Type Indexed - no
Format - Varchar2 (80)
May be Null? Y | Financial aid status. |
| Age Indexed - no
Format - Number (22)
May be Null? Y | Email address listed. |
| Agi Indexed - no
Format - Number (22)
May be Null? Y | US income tax paid. |
| Aidy_Code Indexed - yes
Format - Varchar2 (16)
May be Null? Y | The aid year associated with information in this record. |
| Applic_Type Indexed - no
Format - Varchar2 (20)
May be Null? Y | Citizenship indicator code. |
| App_Submited_Date Indexed - no
Format - Date (7)
May be Null? Y | Add college submitted date. |
| Assume_Yr_In_Coll_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | Assumed year for financial aid applicant code. |
| Assume_Yr_In_Coll_Desc Indexed - no
Format - Varchar2 (60)
May be Null? Y | Assumed year for financial aid applicant description. |
| Birth_Date Indexed - no
Format - Date (7)
May be Null? Y | Age listed. |
| Business_Debt Indexed - no
Format - Number (22)
May be Null? Y | Business debt. |
| Business_Val Indexed - no
Format - Number (22)
May be Null? Y | Business worth. |
| Cash_Savings_Checking Indexed - no
Format - Number (22)
May be Null? Y | Value of cash, savings, and checking accounts. |
| Catastrophic_Event Indexed - no
Format - Varchar2 (4)
May be Null? Y | Elder care. |
| Cb_Fina_Aid_Id Indexed - no
Format - Varchar2 (28)
May be Null? Y | School assigned ID. |
| Change_In_Employment Indexed - no
Format - Varchar2 (4)
May be Null? Y | Scholarships. |
| Child_Support_End_Mo Indexed - no
Format - Varchar2 (8)
May be Null? Y | Parents medical and dental expenses. |
| Child_Support_End_Yr Indexed - no
Format - Varchar2 (16)
May be Null? Y | Child support end month. |
| Child_Support_Paid Indexed - no
Format - Number (22)
May be Null? Y | Child support end year. |
| Child_Supp_Paid Indexed - no
Format - Number (22)
May be Null? Y | Medical and dental expenses paid. |
| Child_Supp_Recd Indexed - no
Format - Number (22)
May be Null? Y | Earned income tax credit. |
| Child_Supp_Recd_For_Stu Indexed - no
Format - Number (22)
May be Null? Y | IRA and Keogh deductions. |
| Citz_Country Indexed - no
Format - Varchar2 (60)
May be Null? Y | Visa code. |
| Citz_Desc Indexed - no
Format - Varchar2 (30)
May be Null? Y | Country of citizenship. |
| Citz_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Citizenship description. |
| Combat_Pay Indexed - no
Format - Number (22)
May be Null? Y | Intereste from dividend income. |
| Created_Date Indexed - no
Format - Date (7)
May be Null? Y | Application submitted date. |
| Currency_Cde Indexed - no
Format - Varchar2 (12)
May be Null? Y | International currency rate. |
| Currency_Rate Indexed - no
Format - Number (22)
May be Null? Y | Parent country coefficient. |
| C_Depend_Status Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent contribution for student |
| Dependency_Status Indexed - no
Format - Varchar2 (4)
May be Null? Y | Dependent status code listed. |
| Dislocated_Worker Indexed - no
Format - Varchar2 (4)
May be Null? Y | Tax return filed indicator. |
| Dividends Indexed - no
Format - Number (22)
May be Null? Y | Social security benefits received. |
| Earned_Inc_Credit Indexed - no
Format - Number (22)
May be Null? Y | Other untaxed income. |
| Edu_Tax_Credit Indexed - no
Format - Number (22)
May be Null? Y | Itemized deductions. |
| Efc Indexed - no
Format - Number (22)
May be Null? Y | Estimated family contribution. |
| Efm_Computed_Orphan_Or_Woc Indexed - no
Format - Varchar2 (4)
May be Null? Y | Homelss indicator. |
| Elder_Care Indexed - no
Format - Varchar2 (4)
May be Null? Y | Nonrecurring income. |
| Email_Address Indexed - no
Format - Varchar2 (1024)
May be Null? Y | Phone number listed. |
| Excess_Adv_Prem_Tax_Cred Indexed - no
Format - Number (22)
May be Null? Y | Parent education credits. |
| Expected_Foundation_Supp_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Explanations text. |
| Explantion_Text Indexed - no
Format - Varchar2 (2000)
May be Null? Y | Change in employment. |
| Exp_Gov_Support_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Expected foundation support. |
| Exp_Tuit_Benefit_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Expected government support. |
| Fam_Age_1 Indexed - no
Format - Number (22)
May be Null? Y | Family member 1 attending college. |
| Fam_Age_2 Indexed - no
Format - Number (22)
May be Null? Y | Family member 2 attending college. |
| Fam_Age_3 Indexed - no
Format - Number (22)
May be Null? Y | Family member 3 attending college. |
| Fam_Age_4 Indexed - no
Format - Number (22)
May be Null? Y | Family member 4 attending college. |
| Fam_Age_5 Indexed - no
Format - Number (22)
May be Null? Y | Family member 5 attending college. |
| Fam_Age_6 Indexed - no
Format - Number (22)
May be Null? Y | Family member 6 attending college. |
| Fam_Age_7 Indexed - no
Format - Number (22)
May be Null? Y | Family member 7 attending college. |
| Fam_Attend_Coll_1 Indexed - no
Format - Varchar2 (4)
May be Null? Y | Family member 1 college type. |
| Fam_Attend_Coll_2 Indexed - no
Format - Varchar2 (4)
May be Null? Y | Family member 2 college type. |
| Fam_Attend_Coll_3 Indexed - no
Format - Varchar2 (4)
May be Null? Y | Family member 3 college type. |
| Fam_Attend_Coll_4 Indexed - no
Format - Varchar2 (4)
May be Null? Y | Family member 4 college type. |
| Fam_Attend_Coll_5 Indexed - no
Format - Varchar2 (4)
May be Null? Y | Familiy member 5 college type. |
| Fam_Attend_Coll_6 Indexed - no
Format - Varchar2 (4)
May be Null? Y | Family member 6 college type. |
| Fam_Attend_Coll_7 Indexed - no
Format - Varchar2 (4)
May be Null? Y | Family member 7 college type. |
| Fam_Relt_1 Indexed - no
Format - Varchar2 (20)
May be Null? Y | Family member 1 age. |
| Fam_Relt_2 Indexed - no
Format - Varchar2 (20)
May be Null? Y | Family member 2 age. |
| Fam_Relt_3 Indexed - no
Format - Varchar2 (20)
May be Null? Y | Family member 3 age. |
| Fam_Relt_4 Indexed - no
Format - Varchar2 (20)
May be Null? Y | Family member 4 age. |
| Fam_Relt_5 Indexed - no
Format - Varchar2 (20)
May be Null? Y | Family member 5 age. |
| Fam_Relt_6 Indexed - no
Format - Varchar2 (20)
May be Null? Y | Family member 6 age. |
| Fam_Relt_7 Indexed - no
Format - Varchar2 (20)
May be Null? Y | Family member 7 age. |
| Fam_Schl_Type_1 Indexed - no
Format - Varchar2 (30)
May be Null? Y | Family member 1 college name. |
| Fam_Schl_Type_2 Indexed - no
Format - Varchar2 (30)
May be Null? Y | Family member 2 college name. |
| Fam_Schl_Type_3 Indexed - no
Format - Varchar2 (30)
May be Null? Y | Family member 3 college name. |
| Fam_Schl_Type_4 Indexed - no
Format - Varchar2 (30)
May be Null? Y | Family member 4 college name. |
| Fam_Schl_Type_5 Indexed - no
Format - Varchar2 (30)
May be Null? Y | Family member 5 college name |
| Fam_Schl_Type_6 Indexed - no
Format - Varchar2 (30)
May be Null? Y | Family member 6 college name. |
| Fam_Schl_Type_7 Indexed - no
Format - Varchar2 (30)
May be Null? Y | Family member 7 college name. |
| Farm_Debt Indexed - no
Format - Number (22)
May be Null? Y | Farm debt. |
| Farm_Val Indexed - no
Format - Number (22)
May be Null? Y | Farm worth. |
| Fee_Waiver_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Admission type |
| Fica Indexed - no
Format - Number (22)
May be Null? Y | Parent Excess Advance Premium Tax Credit |
| Financial_Support Indexed - no
Format - Varchar2 (4)
May be Null? Y | Special circumstances labeld as none. |
| Fin_Aid_Status Indexed - no
Format - Varchar2 (40)
May be Null? Y | Transfer student. |
| First_Name Indexed - no
Format - Varchar2 (240)
May be Null? Y | Middle initial. |
| Fm_Contribution_For_Stu Indexed - no
Format - Number (22)
May be Null? Y | Fee Waiver Indicator |
| Fm_Par_Contribution_For_Stu Indexed - no
Format - Number (22)
May be Null? Y | Total contribution for student. |
| Fm_Par_Ctrb_Fr_Asset Indexed - no
Format - Number (22)
May be Null? Y | Student analysis type. |
| Fm_Par_Ctrb_Fr_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent total contribution from asset estimate. |
| Fm_Par_Total_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent total contribution from income estimate. |
| Fm_Stu_Ctrb_Fr_Asset Indexed - no
Format - Number (22)
May be Null? Y | Original creation date. |
| Fm_Stu_Ctrb_Fr_Inc Indexed - no
Format - Number (22)
May be Null? Y | Student total contribution from asset estimate. |
| Fm_Stu_Total_Inc Indexed - no
Format - Number (22)
May be Null? Y | Student total contribution from income estimate. |
| Foreign_Address_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Natural parent maritial status. |
| Free_Reduced_Lunch Indexed - no
Format - Varchar2 (4)
May be Null? Y | Received TANF benefits. |
| Grant_Schlshp_Aid Indexed - no
Format - Number (22)
May be Null? Y | Veteran benefit type code. |
| Has_Legal_Dep Indexed - no
Format - Varchar2 (4)
May be Null? Y | Received tuition benefit. |
| Hhb_Indicated Indexed - no
Format - Varchar2 (4)
May be Null? Y | CSS lifetime indicator. |
| Homeless_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Legal depedendts indicator. |
| Home_Owed Indexed - no
Format - Number (22)
May be Null? Y | Amount owed on home. |
| Home_Purchased_Amt Indexed - no
Format - Number (22)
May be Null? Y | Home purchase price. |
| Home_Worth Indexed - no
Format - Number (22)
May be Null? Y | Home worth. |
| Home_Yr_Purchased Indexed - no
Format - Number (22)
May be Null? Y | Home year purchased. |
| Household_Type Indexed - no
Format - Varchar2 (6)
May be Null? Y | Household type for analysis. HHA or HHB. |
| Im_Computed_Orphan_Or_Woc Indexed - no
Format - Varchar2 (4)
May be Null? Y | EFC computed orphan ward foster indicator. |
| Infc_Code Indexed - no
Format - Varchar2 (28)
May be Null? Y | INTERFACE TAPE CODE: A code from the Interface Tape Table indicating the source and format of the application record. EXAMPLES: CSS, ACT-CSS. |
| Infc_Desc Indexed - no
Format - Varchar2 (120)
May be Null? Y | INTERFACE TAPE DESCRPTION: Description from the Interface Tape Table indicating the source and format of the application record. EXAMPLES: CSS, ACT-CSS. |
| Inst_House_Cde Indexed - no
Format - Varchar2 (4)
May be Null? Y | Instituitonal housing description. |
| Inst_House_Desc Indexed - no
Format - Varchar2 (30)
May be Null? Y | Veteran indicator |
| Investment_Owed Indexed - no
Format - Number (22)
May be Null? Y | Home equity. |
| Investment_Value Indexed - no
Format - Number (22)
May be Null? Y | Investment worth. |
| Ira_Keogh Indexed - no
Format - Number (22)
May be Null? Y | IRA and KEOGH Account Value |
| Item_Deductns Indexed - no
Format - Number (22)
May be Null? Y | Wages for student or parent 1. |
| Last_Name Indexed - no
Format - Varchar2 (240)
May be Null? Y | First name on application. |
| Live_On_Farm_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Live on a farm. |
| Lrg_Bus_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Large business indicator: Indicates if business employes more than 100 full time employees. |
| Mail_Addr Indexed - no
Format - Varchar2 (300)
May be Null? Y | Mailing city. |
| Mail_City Indexed - no
Format - Varchar2 (200)
May be Null? Y | Mailing state code. |
| Mail_Postal_Cde Indexed - no
Format - Varchar2 (68)
May be Null? Y | Maling state code. |
| Mail_Stat_Code Indexed - no
Format - Varchar2 (8)
May be Null? Y | Mailing postal code. |
| Medicaid Indexed - no
Format - Varchar2 (4)
May be Null? Y | Dislocated worker. |
| Med_Dental_Expense Indexed - no
Format - Number (22)
May be Null? Y | Monthly mortgage or rent payments. |
| Memb_In_Family Indexed - no
Format - Number (22)
May be Null? Y | Number of family members in college. |
| Mi Indexed - no
Format - Varchar2 (240)
May be Null? Y | Preferred name. |
| Month_Mortgage_Or_Rent Indexed - no
Format - Number (22)
May be Null? Y | Child support paid. |
| Mrtl_Desc Indexed - no
Format - Varchar2 (60)
May be Null? Y | Application type. |
| Mrtl_Status Indexed - no
Format - Varchar2 (4)
May be Null? Y | Marital description. |
| Name_Of_School_1 Indexed - no
Format - Varchar2 (200)
May be Null? Y | Family member 2 relationship. |
| Name_Of_School_2 Indexed - no
Format - Varchar2 (200)
May be Null? Y | Family member 3 relationship. |
| Name_Of_School_3 Indexed - no
Format - Varchar2 (200)
May be Null? Y | Family member 4 relationsihp. |
| Name_Of_School_4 Indexed - no
Format - Varchar2 (200)
May be Null? Y | Family member 5 relationship. |
| Name_Of_School_5 Indexed - no
Format - Varchar2 (200)
May be Null? Y | Family member 6 relationship. |
| Name_Of_School_6 Indexed - no
Format - Varchar2 (200)
May be Null? Y | Family member 7 relationship. |
| Name_Of_School_7 Indexed - no
Format - Varchar2 (200)
May be Null? Y | International currency code. |
| Nonrecurring_Inc Indexed - no
Format - Varchar2 (4)
May be Null? Y | Financial support. |
| No_2nd_Bap_Resp Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parents yeas in marriage. |
| No_In_Coll Indexed - no
Format - Number (22)
May be Null? Y | Number of members in parents family unit. |
| No_Of_Exemptions Indexed - no
Format - Number (22)
May be Null? Y | Reported IRS Adjusted Gross Income. |
| Num_Months_Va_Benefits_Recv Indexed - no
Format - Number (22)
May be Null? Y | Parent received food stamps. |
| Other Indexed - no
Format - Varchar2 (4)
May be Null? Y | Family member 1 relationship. |
| Other_Taxable_Inc Indexed - no
Format - Number (22)
May be Null? Y | Other taxable income. |
| Other_Untaxed_Inc Indexed - no
Format - Number (22)
May be Null? Y | Other untaxable income. |
| Othr_Real_Estate_Debt Indexed - no
Format - Number (22)
May be Null? Y | Other real estate debt. |
| Othr_Real_Estate_Val Indexed - no
Format - Number (22)
May be Null? Y | Other real estate value |
| Oth_Taxable_Income Indexed - no
Format - Number (22)
May be Null? Y | Other untaxable income. |
| Oth_Untax_Inc Indexed - no
Format - Number (22)
May be Null? Y | Other grant and scholarships. |
| Oth_Untax_Income Indexed - no
Format - Number (22)
May be Null? Y | Parent total income. |
| Owed_To_Par_By_Othr Indexed - no
Format - Number (22)
May be Null? Y | Parents amount owned to others. |
| Par1_Age Indexed - no
Format - Number (22)
May be Null? Y | Parent 2 relationship to student. |
| Par1_Birth_Date Indexed - no
Format - Date (7)
May be Null? Y | Parent 2 birthday. |
| Par1_Deceased Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent 1 age. |
| Par1_Edu_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent 2 age description. |
| Par1_Edu_Desc Indexed - no
Format - Varchar2 (35)
May be Null? Y | Parent 2 education code. |
| Par1_Email_Address Indexed - no
Format - Varchar2 (512)
May be Null? Y | Parent 2 email address. |
| Par1_Employer Indexed - no
Format - Varchar2 (80)
May be Null? Y | Parent 1 self employed inicator. |
| Par1_Occupation Indexed - no
Format - Varchar2 (80)
May be Null? Y | Parent 1 employer. |
| Par1_Rel_To_Stu Indexed - no
Format - Varchar2 (20)
May be Null? Y | Parent 1 occupation. |
| Par1_Self_Employed Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent 1 uneployed indicator. |
| Par1_Unemployed Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent 1 vet indicator. |
| Par1_Vet Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent 1 deceased. |
| Par2_Age Indexed - no
Format - Number (22)
May be Null? Y | Parent 1 age code |
| Par2_Birth_Date Indexed - no
Format - Date (7)
May be Null? Y | Child support paid. |
| Par2_Deceased Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent 2 age. |
| Par2_Edu_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent 2 education description. |
| Par2_Edu_Desc Indexed - no
Format - Varchar2 (35)
May be Null? Y | Parent mailing address. |
| Par2_Email_Address Indexed - no
Format - Varchar2 (512)
May be Null? Y | Parent housing status code |
| Par2_Employer Indexed - no
Format - Varchar2 (80)
May be Null? Y | Parent 2 self employed indicator. |
| Par2_Occupation Indexed - no
Format - Varchar2 (80)
May be Null? Y | Parent 2 employer. |
| Par2_Rel_To_Stu Indexed - no
Format - Varchar2 (20)
May be Null? Y | Parent 2 occupation. |
| Par2_Self_Employed Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent 2 unemployed indicator. |
| Par2_Unemployed Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent 2 vet indicator. |
| Par2_Vet Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent 2 deceased. |
| Parent_Contribution_Offer Indexed - no
Format - Number (22)
May be Null? Y | Contributions from parents offered. |
| Par_1_Anticipated_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent 1 anticipated earned income. |
| Par_1_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent 2 income. |
| Par_1_Ret_Assets Indexed - no
Format - Number (22)
May be Null? Y | Parent 1 retirement account value. |
| Par_2_Anticipated_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent 2 anticipated earned income. |
| Par_2_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent combat pay |
| Par_2_Ret_Assets Indexed - no
Format - Number (22)
May be Null? Y | Parent 2 retirement account value. |
| Par_Addl_Child_Tx_Cred Indexed - no
Format - Number (22)
May be Null? Y | Parent military and clergy allowance. |
| Par_Add_Medicare_Tax Indexed - no
Format - Number (22)
May be Null? Y | FICA for student. |
| Par_Adj_To_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent adjustged gross income. |
| Par_Alimony_Recd Indexed - no
Format - Number (22)
May be Null? Y | Parent business income. |
| Par_Allowable_Med_Den_Exp Indexed - no
Format - Number (22)
May be Null? Y | |
| Par_Allowable_Tuit_Expense Indexed - no
Format - Number (22)
May be Null? Y | Allowable School Tuition Expense Override IM. |
| Par_Amt_Pd_Home_Employ Indexed - no
Format - Number (22)
May be Null? Y | Parents other expenses. |
| Par_Analyis_Type Indexed - no
Format - Varchar2 (20)
May be Null? Y | Parent total income estimate. |
| Par_Annual_Debt_Pay Indexed - no
Format - Number (22)
May be Null? Y | Parent expenses for auto maintenance. |
| Par_Asea Indexed - no
Format - Number (22)
May be Null? Y | Parent Annual Education Savings Account (Parent AESA). |
| Par_Asea_Children Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent AESA children indicator. |
| Par_Assets_Home_Equity Indexed - no
Format - Number (22)
May be Null? Y | Parent assets and home equity increase. |
| Par_Asset_Home_Reduction Indexed - no
Format - Number (22)
May be Null? Y | Parent assets and home equity reduction. |
| Par_Autho_Maintenance Indexed - no
Format - Number (22)
May be Null? Y | Parent property insurance payments. |
| Par_Bus_Dbt Indexed - no
Format - Number (22)
May be Null? Y | Parents business debt |
| Par_Bus_Fam_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent other taxable income. |
| Par_Bus_Return_Field Indexed - no
Format - Varchar2 (4)
May be Null? Y | Indicates business tax return form used by parents. |
| Par_Bus_Val Indexed - no
Format - Number (22)
May be Null? Y | Parents business value. |
| Par_Calc_Home_Equity Indexed - no
Format - Number (22)
May be Null? Y | Parents calculated home equity. |
| Par_Cash_Savings Indexed - no
Format - Number (22)
May be Null? Y | Amount in parents cash, savings, and checking accounts. |
| Par_Cesa_Ages Indexed - no
Format - Varchar2 (8)
May be Null? Y | Parent CESA age. |
| Par_Child_Support_Pd Indexed - no
Format - Number (22)
May be Null? Y | Parent educational loan repayment amount. |
| Par_Child_Supp_Recd Indexed - no
Format - Number (22)
May be Null? Y | Child support amount allocated to student. |
| Par_Cloth_Expenses Indexed - no
Format - Number (22)
May be Null? Y | Parents household expenses. |
| Par_Cntry_Cntry_Code_Res Indexed - no
Format - Varchar2 (8)
May be Null? Y | Parent 1 email address. |
| Par_Combat_Pay Indexed - no
Format - Number (22)
May be Null? Y | Parent SS benefit received. |
| Par_Contrb_From_Assets Indexed - no
Format - Number (22)
May be Null? Y | Parent contribution from assets. |
| Par_Contrb_From_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent contribution from income. |
| Par_Cost_Of_Living_Mutliplier Indexed - no
Format - Number (22)
May be Null? Y | Parent Income Protection Allowance. |
| Par_Country_Coefficient Indexed - no
Format - Number (22)
May be Null? Y | Sutdent country coefficient. |
| Par_Cum_Ed_Savings Indexed - no
Format - Number (22)
May be Null? Y | Parent's monthly mortgage or rent. |
| Par_Debt_Expense Indexed - no
Format - Number (22)
May be Null? Y | Annual payment for parents debt. |
| Par_Disc_Net_Wth Indexed - no
Format - Number (22)
May be Null? Y | Parent Discretionary Net Worth. |
| Par_Disl_Wrk Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent is medicaid eligible. |
| Par_Dividend_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent alimony amount received. |
| Par_Earned_Income_Credit Indexed - no
Format - Number (22)
May be Null? Y | Parent additoinal child tax credit. |
| Par_Edu_Credit Indexed - no
Format - Number (22)
May be Null? Y | Parent itemized deductions. |
| Par_Emerg_Res_Allow Indexed - no
Format - Number (22)
May be Null? Y | Parents cumulative education savings allowance. |
| Par_Entertain_Costs Indexed - no
Format - Number (22)
May be Null? Y | Parents number of people employed. |
| Par_Exp_No_Child_Tuit Indexed - no
Format - Number (22)
May be Null? Y | Allowable School Tuition Expense. |
| Par_Fam_Support_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent total avalialble discretionary income. |
| Par_Farm_Bus_Net_Worth Indexed - no
Format - Number (22)
May be Null? Y | Parent business net worth. |
| Par_Farm_Dbt Indexed - no
Format - Number (22)
May be Null? Y | Parent farm debt. |
| Par_Farm_Purch_Amt Indexed - no
Format - Number (22)
May be Null? Y | Parent farm purchased |
| Par_Farm_Val Indexed - no
Format - Number (22)
May be Null? Y | Parents farm value. |
| Par_Farm_Yr_Purch Indexed - no
Format - Number (22)
May be Null? Y | Parent year farm purchased. |
| Par_Food_Expense Indexed - no
Format - Number (22)
May be Null? Y | Parents clothing expenses. |
| Par_Food_Stamps Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent received free or reduced lunch. |
| Par_For_Inc_Excl Indexed - no
Format - Number (22)
May be Null? Y | Parent other untaxed income. |
| Par_Fsa_Dependent_Care Indexed - no
Format - Number (22)
May be Null? Y | Parent health savings account. |
| Par_Fsa_Health_Care Indexed - no
Format - Number (22)
May be Null? Y | Parent Dependent FSA healthcare contribution. |
| Par_Health_Savings_Account Indexed - no
Format - Number (22)
May be Null? Y | Parent HAS pre-tax contribution. |
| Par_Home_Debt Indexed - no
Format - Number (22)
May be Null? Y | Parent home debt. |
| Par_Home_Purch_Amt Indexed - no
Format - Number (22)
May be Null? Y | Parents home purchase amount. |
| Par_Home_Purch_Yr Indexed - no
Format - Number (22)
May be Null? Y | Parents home year purchased. |
| Par_Home_Val Indexed - no
Format - Number (22)
May be Null? Y | Parents home value. |
| Par_Household_Expenses Indexed - no
Format - Number (22)
May be Null? Y | Parent expenses from debt. |
| Par_Hous_Stat Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent housing status description. |
| Par_Hous_Stat_Desc Indexed - no
Format - Varchar2 (30)
May be Null? Y | Parent year seperated. |
| Par_Hsa_Pre_Tax Indexed - no
Format - Number (22)
May be Null? Y | Parent Earned income credit. |
| Par_Im_Oth_Untax_Inc Indexed - no
Format - Number (22)
May be Null? Y | Family support income. |
| Par_Im_Zip Indexed - no
Format - Varchar2 (120)
May be Null? Y | Mailing address. |
| Par_Income_Protection_Allow Indexed - no
Format - Number (22)
May be Null? Y | Sibbling assets from parent family. |
| Par_Inc_Frm_Dbts Indexed - no
Format - Number (22)
May be Null? Y | Parent income from debts. |
| Par_Inc_Tax_Paid Indexed - no
Format - Number (22)
May be Null? Y | Parent state and local taxes paid. |
| Par_Intrest_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent income from dividends. |
| Par_Invest_Debt Indexed - no
Format - Number (22)
May be Null? Y | Parents investment debt. |
| Par_Invest_Val Indexed - no
Format - Number (22)
May be Null? Y | Parents investment values. |
| Par_Ira_Distributions Indexed - no
Format - Number (22)
May be Null? Y | Parent untaxed pension. |
| Par_Ira_Keough_Dedct Indexed - no
Format - Number (22)
May be Null? Y | Untaxed IRAs Pensions Annuities Distribution. |
| Par_Item_Deductns Indexed - no
Format - Number (22)
May be Null? Y | Parent qualified business income deduction. |
| Par_Live_Farm_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Indicator of living farms. |
| Par_Living_Allowance Indexed - no
Format - Number (22)
May be Null? Y | Parent military and clergy housing allowance. |
| Par_Mail_Addr Indexed - no
Format - Varchar2 (300)
May be Null? Y | Parent mailing city. |
| Par_Mail_City Indexed - no
Format - Varchar2 (200)
May be Null? Y | Parent mailing state code. |
| Par_Mail_Country_Cde Indexed - no
Format - Varchar2 (8)
May be Null? Y | Parent analysis type. |
| Par_Mail_Postal_Code Indexed - no
Format - Varchar2 (68)
May be Null? Y | Parent mailing country code. |
| Par_Mail_Stat_Code Indexed - no
Format - Varchar2 (8)
May be Null? Y | Parent postal code. |
| Par_Medicaid Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent received TANF benfits. |
| Par_Med_Dental_Expense Indexed - no
Format - Number (22)
May be Null? Y | |
| Par_Med_Dent_Exp_Im_Ovr Indexed - no
Format - Number (22)
May be Null? Y | Parent private school tuition paid amount. |
| Par_Memb_In_Family Indexed - no
Format - Number (22)
May be Null? Y | Number of members in parent family unit in college. |
| Par_Mil_Hous_Allowance Indexed - no
Format - Number (22)
May be Null? Y | Parent VA Non-educational benefits. |
| Par_Mnth_Mort_Rent_Pay Indexed - no
Format - Number (22)
May be Null? Y | Number of members within family unit. |
| Par_Mrtl_Desc Indexed - no
Format - Varchar2 (240)
May be Null? Y | Parent maritial status description. |
| Par_Mrtl_Status Indexed - no
Format - Varchar2 (4)
May be Null? Y | Indicates parent maritial status. |
| Par_Natrl_Sep_Div Indexed - no
Format - Varchar2 (4)
May be Null? Y | Natural parent maritial description. |
| Par_Natrl_Sep_Div_Desc Indexed - no
Format - Varchar2 (40)
May be Null? Y | No second BAP response. |
| Par_Nbr_Employed Indexed - no
Format - Number (22)
May be Null? Y | Parents amount paid to home employees. |
| Par_Ncp_Contrb_Pc Indexed - no
Format - Number (22)
May be Null? Y | Calculated Non-Custodial Parent Contribution. |
| Par_Ncp_Parent_Agreement Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent child support paid amount. |
| Par_Net_Worth Indexed - no
Format - Number (22)
May be Null? Y | Parent net worth. |
| Par_No_Child_Tuit Indexed - no
Format - Number (22)
May be Null? Y | |
| Par_No_Exempt Indexed - no
Format - Number (22)
May be Null? Y | Parent wages. |
| Par_No_In_Coll Indexed - no
Format - Number (22)
May be Null? Y | Parent 1 birthday. |
| Par_Npc_Contribution Indexed - no
Format - Number (22)
May be Null? Y | Noncustodial parent agreement of support. |
| Par_Numb_Of_Bus Indexed - no
Format - Number (22)
May be Null? Y | Number of business owned by parents |
| Par_Numb_Of_Employ_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Indicates if parent business has more than 100 employees. |
| Par_Numb_Real_Estate Indexed - no
Format - Number (22)
May be Null? Y | Parents number of real estate owed. |
| Par_Num_Farms Indexed - no
Format - Number (22)
May be Null? Y | Parent Number of Farms |
| Par_Other_Allowances Indexed - no
Format - Number (22)
May be Null? Y | Parent total allowances. |
| Par_Other_Untax_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent other untaxed income for IM. |
| Par_Othr_Real_Estate_Dbt Indexed - no
Format - Number (22)
May be Null? Y | Parents other real estate debt. |
| Par_Othr_Real_Estate_Inv Indexed - no
Format - Number (22)
May be Null? Y | Parents other real estate investment |
| Par_Othr_Real_Estate_Val Indexed - no
Format - Number (22)
May be Null? Y | Parents other real estate worth. |
| Par_Oth_Expense Indexed - no
Format - Number (22)
May be Null? Y | Travel plan code for student. |
| Par_Oth_Tax_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent adjustments to income. |
| Par_Pension_Dedct Indexed - no
Format - Number (22)
May be Null? Y | Parent FSA healthcare contribution. |
| Par_Perc_From_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent's percent from income. |
| Par_Private_Tuit_Paid Indexed - no
Format - Number (22)
May be Null? Y | Parent number of children paying for private school. |
| Par_Property_Insur Indexed - no
Format - Number (22)
May be Null? Y | Parents vacation expenses. |
| Par_Qual_Bus_Inc_Ded Indexed - no
Format - Number (22)
May be Null? Y | Parent 1 income. |
| Par_Recd_Wic Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent is a dislocated worker. |
| Par_Repay_Edu_Loan Indexed - no
Format - Number (22)
May be Null? Y | Parent tution paid for private school. |
| Par_School_Lunch Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent received WIC benefits. |
| Par_Sibling_Assets Indexed - no
Format - Number (22)
May be Null? Y | Parent state of residence code. |
| Par_Ssi Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent tax return indicator code. |
| Par_Ss_Benefit Indexed - no
Format - Number (22)
May be Null? Y | Parent TANF received. |
| Par_Stat_Code_Res Indexed - no
Format - Varchar2 (8)
May be Null? Y | Dependent status listed for student. |
| Par_Stat_Locl_Tax Indexed - no
Format - Number (22)
May be Null? Y | Parent additoinal medicare tax paid. |
| Par_Tanf Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent received SSI. |
| Par_Tax_Exmpt_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent foreign income exclusion. |
| Par_Tax_Filing_Desc Indexed - no
Format - Varchar2 (45)
May be Null? Y | Paretn number of exemptions. |
| Par_Tax_Filing_Status Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent tax filing status description. |
| Par_Tax_Form_Desc Indexed - no
Format - Varchar2 (30)
May be Null? Y | Parent tax filing status. |
| Par_Tot_Allowances Indexed - no
Format - Number (22)
May be Null? Y | Other taxable income. |
| Par_Tot_Avlb_Inc Indexed - no
Format - Number (22)
May be Null? Y | Reported non-constodial parent contribution. |
| Par_Tot_Contrb Indexed - no
Format - Number (22)
May be Null? Y | Total parent contribution. |
| Par_Tot_Inc Indexed - no
Format - Number (22)
May be Null? Y | Parent cost of living multiplier. |
| Par_Tuit_Expense_Im Indexed - no
Format - Number (22)
May be Null? Y | Parent other allowances. |
| Par_Tuit_Pd Indexed - no
Format - Number (22)
May be Null? Y | Number of childen parent is paying school tuition for. |
| Par_Tui_Fee_Ded Indexed - no
Format - Number (22)
May be Null? Y | Parents utility expenses. |
| Par_Tx_Form_Ind Indexed - no
Format - Varchar2 (8)
May be Null? Y | Parent tax form description. |
| Par_Tx_Ret_Desc Indexed - no
Format - Varchar2 (12)
May be Null? Y | Parent tax form indicator code. |
| Par_Tx_Ret_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Parent tax return indicator description. |
| Par_Untaxed_Ira_Pns_Dist Indexed - no
Format - Number (22)
May be Null? Y | Parent Untaxed IRA distributions. |
| Par_Untax_Pension Indexed - no
Format - Number (22)
May be Null? Y | Tax deferred pensions. |
| Par_Utility_Expense Indexed - no
Format - Number (22)
May be Null? Y | Parents food expenses. |
| Par_Vacation_Expense Indexed - no
Format - Number (22)
May be Null? Y | Parents entertainment costs. |
| Par_Val_Other_Assets Indexed - no
Format - Number (22)
May be Null? Y | Parent's value of other assets. |
| Par_Va_Non_Edu_Benefit Indexed - no
Format - Number (22)
May be Null? Y | Parent tax exempt income. |
| Par_Wages Indexed - no
Format - Number (22)
May be Null? Y | Parent income from investment. |
| Par_Welfare_Tanf Indexed - no
Format - Number (22)
May be Null? Y | Parent child support amount received. |
| Par_Yr_Div Indexed - no
Format - Varchar2 (16)
May be Null? Y | Parent 1 relationship to student. |
| Par_Yr_Of_Marriage Indexed - no
Format - Varchar2 (16)
May be Null? Y | Parent country code of residence. |
| Par_Yr_Sep Indexed - no
Format - Varchar2 (16)
May be Null? Y | Parent year divorced. |
| Pa_Agi Indexed - no
Format - Number (22)
May be Null? Y | Parent income tax paid. |
| Penn_Id Indexed - no
Format - Varchar2 (9)
May be Null? Y | Internal number for individual within Banner. |
| Phone_Number Indexed - no
Format - Varchar2 (132)
May be Null? Y | Maritial status. |
| Pidm Indexed - yes
Format - Number (22)
May be Null? Y | Financial aid year associated with financial aid applicant. |
| Pk_Fa_Need_Css Indexed - yes
Format - Varchar2 (76)
May be Null? Y | Internal warehouse primary key: based on PIDM, AIDY_CODE, INFC_CODE |
| Postal_Code Indexed - no
Format - Varchar2 (120)
May be Null? Y | Foreign address indicator. |
| Preferred_Name Indexed - no
Format - Varchar2 (240)
May be Null? Y | Birthday. |
| Recd_Ssi Indexed - no
Format - Varchar2 (4)
May be Null? Y | Receieved food stamps. |
| Recd_Tanf Indexed - no
Format - Varchar2 (4)
May be Null? Y | Received WIC benefits. |
| Recd_Wic Indexed - no
Format - Varchar2 (4)
May be Null? Y | Receieved food stamps. |
| Refresh_Date Indexed - no
Format - Date (7)
May be Null? Y | |
| Relatives_Contribution_Offer Indexed - no
Format - Number (22)
May be Null? Y | Contributions from relatives offered. |
| Res_Stat_Code Indexed - no
Format - Varchar2 (8)
May be Null? Y | Student IM zip code. |
| Scholarships Indexed - no
Format - Varchar2 (4)
May be Null? Y | Siblings in private schools. |
| School_Assigned_Id Indexed - no
Format - Varchar2 (80)
May be Null? Y | Last name on application. |
| School_Yr_Earned_Inc Indexed - no
Format - Number (22)
May be Null? Y | Expected income earned during school year. |
| School_Yr_Untax_Inc Indexed - no
Format - Number (22)
May be Null? Y | School year untaxed income. |
| Sibl_Private_School Indexed - no
Format - Varchar2 (4)
May be Null? Y | Catestrophic event. |
| Snap Indexed - no
Format - Varchar2 (4)
May be Null? Y | Received reduced or free school lunch. |
| Special_Circumstances_None Indexed - no
Format - Varchar2 (4)
May be Null? Y | Other circumstances indicator. |
| Spouse_School_Yr_Earned_Inc Indexed - no
Format - Number (22)
May be Null? Y | Expected spouse income during school year. |
| Spouse_Sum_Earned_Inc Indexed - no
Format - Number (22)
May be Null? Y | Spouse summer income. |
| Spouse_Wages Indexed - no
Format - Number (22)
May be Null? Y | Combat pay. |
| Ss_Benefits Indexed - no
Format - Number (22)
May be Null? Y | TANF benefit amount. |
| State_Code Indexed - no
Format - Varchar2 (8)
May be Null? Y | Mailing zip code |
| Stu_Aesa_Children Indexed - no
Format - Varchar2 (4)
May be Null? Y | Student AESA children indicator. |
| Stu_Analyis_Type Indexed - no
Format - Varchar2 (20)
May be Null? Y | Student total income estimate. |
| Stu_Cesa_Ages Indexed - no
Format - Varchar2 (8)
May be Null? Y | Student CESA age. |
| Stu_Contrb_From_Asset Indexed - no
Format - Number (22)
May be Null? Y | Total student contribution from assets. |
| Stu_Contrb_From_Inc Indexed - no
Format - Number (22)
May be Null? Y | Total student contribution from income. |
| Stu_Contribution Indexed - no
Format - Number (22)
May be Null? Y | Total student contribution. |
| Stu_Country_Coefficient Indexed - no
Format - Number (22)
May be Null? Y | HHB Indicated. |
| Stu_Im_Zip Indexed - no
Format - Varchar2 (120)
May be Null? Y | Parent IM zip code. |
| Stu_Rec_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | The student record type entered code (ie: initial or school added). |
| Stu_Rec_Desc Indexed - no
Format - Varchar2 (30)
May be Null? Y | The student record type entered description (ie: initial or school added). |
| Stu_Total_Inc Indexed - no
Format - Number (22)
May be Null? Y | Total student income. |
| Summer_Untax_Inc Indexed - no
Format - Number (22)
May be Null? Y | Summer untaxed income. |
| Sum_Earned_Inc Indexed - no
Format - Number (22)
May be Null? Y | Summer earned income |
| Tanf_Benefits Indexed - no
Format - Number (22)
May be Null? Y | Child support amount received. |
| Tax_Filing_Status Indexed - no
Format - Varchar2 (4)
May be Null? Y | Tax filing status description. |
| Tax_Filing_Status_Desc Indexed - no
Format - Varchar2 (45)
May be Null? Y | Number of excemptions. |
| Total_Inc Indexed - no
Format - Number (22)
May be Null? Y | Total income on record. |
| Totl_Assets Indexed - no
Format - Number (22)
May be Null? Y | Total assets for student. |
| Tot_Contrb_For_Stu Indexed - no
Format - Number (22)
May be Null? Y | Total contribution for student. |
| Tot_Contrb_From_Asset Indexed - no
Format - Number (22)
May be Null? Y | Contribution from assets. |
| Tot_Contrb_From_Inc Indexed - no
Format - Number (22)
May be Null? Y | Contribution from income. |
| Transfer_Stu Indexed - no
Format - Varchar2 (4)
May be Null? Y | Instituitonal housing code. |
| Travel_Pay_Plan_Cde Indexed - no
Format - Varchar2 (4)
May be Null? Y | Travel plan description for student. |
| Travel_Pay_Plan_Desc Indexed - no
Format - Varchar2 (30)
May be Null? Y | Received SSI benefits. |
| Trust_Availb_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Trust fund is avaliable indicator. |
| Trust_Estb_By_Desc Indexed - no
Format - Varchar2 (30)
May be Null? Y | Trust fund established by description. |
| Trust_Estb_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | Trust fund established code. |
| Trust_Fund Indexed - no
Format - Number (22)
May be Null? Y | Value of students trust fund. |
| Tutition_Benefits Indexed - no
Format - Number (22)
May be Null? Y | Tuition benefits received from employer. |
| Tx_Ret_Filed_Desc Indexed - no
Format - Varchar2 (15)
May be Null? Y | Tax filing status code. |
| Tx_Ret_Filed_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Tax return filed indicator description. |
| Us_Tax_Pd Indexed - no
Format - Number (22)
May be Null? Y | Education tax credits. |
| Vet_Befefits_Desc Indexed - no
Format - Varchar2 (31)
May be Null? Y | Veteran benefit amount. |
| Vet_Benefits_Amt Indexed - no
Format - Number (22)
May be Null? Y | Number of months veteratn benefits received. |
| Vet_Benefits_Type Indexed - no
Format - Varchar2 (4)
May be Null? Y | Veteran benefit type description. |
| Vet_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | IM computed orphan ward foster indicator. |
| Visa_Class Indexed - no
Format - Varchar2 (20)
May be Null? Y | State of residence code. |
| Wages Indexed - no
Format - Number (22)
May be Null? Y | Wages for spouse or parent 2. |
| Wrttn_Expln_Prsnt Indexed - no
Format - Varchar2 (4)
May be Null? Y | Indicates if a written explanation is present for student. |
????????????????????? ??? ??????????????????? ??????????????????????????????????????? ????????????????????? ?????????????????????????????????????????? ??????????4???????????????????†??????????????????????????????? ????????????????????????4???†????????????????????????????????????????????????†???????????????????????????????????????†?????????????????????†???????????????????????????????????????†????????????????????????????? ????????????????????????????????†????????????????????????????†?????????????????????? ??? ??????????????????? ??????????????????????????????????????? ????????????????????? ??????????????????????????????????????????†????????????????????????????? ????????????????????????????????†??????????????????????????????†???????????????????????? ??? ??????????????????? ??????????????????????????????????????? ????????????????????? ????????????????????????????????????????? ??????????4???????????????????†??????????????????????????????? ?????????????????????????????? ???????????????????????? ??? ????????????????
