[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_CSS_PROFILE_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_AP_CSS_PROFILE_ALL
|
| Subobject Name: | |
| Status: | VALID |
Holds the profile information as received from the college board
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_AP_CSS_PROFILE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 CSSP_ID
|
| IGF_AP_CSS_PROFILE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
CSS_ID_NUMBER
|
| IGF_AP_CSS_PROFILE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
BASE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CSSP_ID | NUMBER | (15) | Yes | Primary Key Column |
| ORG_ID | NUMBER | (15) | Org ID Column | |
| BASE_ID | NUMBER | (15) | Yes | Unique identifier for student financial aid record |
| SYSTEM_RECORD_TYPE | VARCHAR2 | (30) | Yes | Indicates whether the record is CORRECTION or ORIGINAL profile record.Correction here means the record created by user for unofficial Need Analysis purpose. |
| ACTIVE_PROFILE | VARCHAR2 | (1) | Yes | This indicates if the profile is the active profile of the student. For a student only one profile will be active. And Always its the most recent profile which is the active Profile. |
| COLLEGE_CODE | VARCHAR2 | (4) | College code of the school receiving this application | |
| ACADEMIC_YEAR | VARCHAR2 | (2) | Academic year identifies the year for which this record is valid. | |
| STU_RECORD_TYPE | VARCHAR2 | (30) | Student record type identifies the type of student profile record. | |
| CSS_ID_NUMBER | VARCHAR2 | (7) | Unique identifier for the CSS record | |
| REGISTRATION_RECEIPT_DATE | VARCHAR2 | (8) | Registration receipt date is the date on which the registration was received. | |
| REGISTRATION_TYPE | VARCHAR2 | (30) | Registration type denotes the type of registration. | |
| APPLICATION_RECEIPT_DATE | VARCHAR2 | (8) | Application receipt date denotes the date on which the application was received by the college board. | |
| APPLICATION_TYPE | VARCHAR2 | (30) | Application type indicates the type of application | |
| ORIGINAL_FNAR_COMPUTE | VARCHAR2 | (8) | Original FNAR compute | |
| REVISION_FNAR_COMPUTE_DATE | VARCHAR2 | (8) | Revision FNAR compute date | |
| ELECTRONIC_EXTRACT_DATE | VARCHAR2 | (8) | Electronic extract date | |
| INSTITUTIONAL_REPORTING_TYPE | VARCHAR2 | (30) | Institutional reporting type | |
| ASR_RECEIPT_DATE | VARCHAR2 | (8) | ASR receipt date | |
| LAST_NAME | VARCHAR2 | (16) | Yes | Last name of the student |
| FIRST_NAME | VARCHAR2 | (12) | Yes | Indicates first name of applicant student |
| MIDDLE_INITIAL | VARCHAR2 | (30) | Middle initial of the student | |
| ADDRESS_NUMBER_AND_STREET | VARCHAR2 | (28) | Street address of the student | |
| CITY | VARCHAR2 | (17) | City of residence of a student | |
| STATE_MAILING | VARCHAR2 | (2) | State mailing address | |
| ZIP_CODE | VARCHAR2 | (5) | Zip code | |
| S_TELEPHONE_NUMBER | VARCHAR2 | (10) | Students telephone number | |
| S_TITLE | VARCHAR2 | (30) | Students title | |
| DATE_OF_BIRTH | DATE | Date of birth of a student | ||
| SOCIAL_SECURITY_NUMBER | VARCHAR2 | (9) | Social security number of a student | |
| STATE_LEGAL_RESIDENCE | VARCHAR2 | (2) | Indicates students state of legal residence | |
| FOREIGN_ADDRESS_INDICATOR | VARCHAR2 | (30) | Indicates if student has foreign address | |
| FOREIGN_POSTAL_CODE | VARCHAR2 | (9) | Indicates foreign postal code for a student | |
| COUNTRY | VARCHAR2 | (25) | Indicates country of a student | |
| FINANCIAL_AID_STATUS | VARCHAR2 | (30) | Indicates financial aid status for a student | |
| YEAR_IN_COLLEGE | VARCHAR2 | (30) | Indicates the number of years spent in college by the student | |
| MARITAL_STATUS | VARCHAR2 | (30) | Indicates marital status of a student | |
| WARD_COURT | VARCHAR2 | (30) | Indicates if the student is ward of court | |
| LEGAL_DEPENDENTS_OTHER | VARCHAR2 | (30) | Indicates if student has other legal dependents | |
| HOUSEHOLD_SIZE | NUMBER | (15) | Indicates household size for a student | |
| NUMBER_IN_COLLEGE | NUMBER | (15) | Indicates the number of people in the family household of a student who are in college | |
| CITIZENSHIP_STATUS | VARCHAR2 | (30) | Indicates citizenship status of a student | |
| CITIZENSHIP_COUNTRY | VARCHAR2 | (15) | Indicates citizenship country for a student | |
| VISA_CLASSIFICATION | VARCHAR2 | (30) | Indicates visa classification for a student | |
| TAX_FIGURES | VARCHAR2 | (30) | Indicates students tax figures | |
| NUMBER_EXEMPTIONS | NUMBER | (15) | Indicates number exemptions for a student | |
| ADJUSTED_GROSS_INC | NUMBER | (15) | Indicates adjusted gross income for a student | |
| US_TAX_PAID | NUMBER | (15) | Indicates students US tax paid | |
| ITEMIZED_DEDUCTIONS | NUMBER | (15) | Indicates itemized deductions for a student | |
| STU_INCOME_WORK | NUMBER | (15) | Indicates income from work for a student | |
| SPOUSE_INCOME_WORK | NUMBER | (15) | Indicates spouse income from work for a student | |
| DIVID_INT_INC | NUMBER | (15) | Indicates dividend or interest income for a student | |
| SOC_SEC_BENEFITS | NUMBER | (15) | Indicates social security benefits for a student | |
| WELFARE_TANF | NUMBER | (15) | Indicates welfare TANF grants for the student | |
| CHILD_SUPP_RCVD | NUMBER | (15) | Indicates child support received by the student | |
| EARNED_INCOME_CREDIT | NUMBER | (15) | The earned income credit of the student | |
| OTHER_UNTAX_INCOME | NUMBER | (15) | The other untaxed income of the student | |
| TAX_STU_AID | NUMBER | (15) | The taxable aid received by the student | |
| CASH_SAV_CHECK | NUMBER | (15) | The cash saving or checking balance of the student | |
| IRA_KEOGH | NUMBER | (15) | IRA KEOGH received by the student | |
| INVEST_VALUE | NUMBER | (15) | Indicates investment value for a student | |
| INVEST_DEBT | NUMBER | (15) | Indicates investment debt for a student | |
| HOME_VALUE | NUMBER | (15) | Indicates home value for a student | |
| HOME_DEBT | NUMBER | (15) | Indicates home debt for a student | |
| OTH_REAL_VALUE | NUMBER | (15) | Indicates other real value for a student | |
| OTH_REAL_DEBT | NUMBER | (15) | Indicates other real debt for a student | |
| BUS_FARM_VALUE | NUMBER | (15) | Indicates business farm value for a student | |
| BUS_FARM_DEBT | NUMBER | (15) | Indicates business farm debt for a student | |
| LIVE_ON_FARM | VARCHAR2 | (30) | Indicates if student lives on farm | |
| HOME_PURCH_PRICE | NUMBER | (15) | Indicates home purchase price for a student | |
| HOPE_LL_CREDIT | NUMBER | (15) | Indicates hope credit received by the student | |
| HOME_PURCH_YEAR | VARCHAR2 | (4) | Indicates home purchase year for a student | |
| TRUST_AMOUNT | NUMBER | (15) | Indicates students trust amount | |
| TRUST_AVAIL | VARCHAR2 | (30) | Indicates if students trust is available | |
| TRUST_ESTAB | VARCHAR2 | (30) | Indicates when students trust was established | |
| CHILD_SUPPORT_PAID | NUMBER | (15) | Holds child support paid by the student | |
| MED_DENT_EXPENSES | NUMBER | (15) | Holds medical dental expenses of a student | |
| VET_US | VARCHAR2 | (30) | Indicates if the student is US Veteran | |
| VET_BEN_AMOUNT | NUMBER | (15) | Holds students veteran benefit amount | |
| VET_BEN_MONTHS | NUMBER | (15) | Hold students veteran benefit months | |
| STU_SUMMER_WAGES | NUMBER | (15) | Holds summer wages for a student | |
| STU_SCHOOL_YR_WAGES | NUMBER | (15) | Holds school year wages for a student | |
| SPOUSE_SUMMER_WAGES | NUMBER | (15) | Holds spouse summer wages for a student | |
| SPOUSE_SCHOOL_YR_WAGES | NUMBER | (15) | Holds spouse school year wages for student | |
| SUMMER_OTHER_TAX_INC | NUMBER | (15) | Holds other taxable income for a student for summer | |
| SCHOOL_YR_OTHER_TAX_INC | NUMBER | (15) | Holds other taxable income for a student for a school year | |
| SUMMER_UNTAX_INC | NUMBER | (15) | Holds untaxed income for a student for summer | |
| SCHOOL_YR_UNTAX_INC | NUMBER | (15) | Holds non-taxable income for a student for a school year | |
| GRANTS_SCHOL_ETC | NUMBER | (15) | Holds grants received from school by the student | |
| TUIT_BENEFITS | NUMBER | (15) | Holds students tuition benefits | |
| CONT_PARENTS | NUMBER | (15) | Holds parents contribution for a student | |
| CONT_RELATIVES | NUMBER | (15) | Holds relatives contribution for a student | |
| P_SIBLINGS_PRE_TUIT | NUMBER | (15) | Holds parents siblings pre tuition | |
| P_STUDENT_PRE_TUIT | NUMBER | (15) | student pre tuition | |
| P_HOUSEHOLD_SIZE | NUMBER | (15) | household size | |
| P_NUMBER_IN_COLLEGE | NUMBER | (15) | number in college | |
| P_PARENTS_IN_COLLEGE | NUMBER | (15) | parents in college | |
| P_MARITAL_STATUS | VARCHAR2 | (30) | marital status | |
| P_STATE_LEGAL_RESIDENCE | VARCHAR2 | (2) | state legal residence | |
| P_NATURAL_PAR_STATUS | VARCHAR2 | (30) | natural par status | |
| P_CHILD_SUPP_PAID | NUMBER | (15) | child support paid | |
| P_REPAY_ED_LOANS | NUMBER | (15) | Repay educational loans | |
| P_MED_DENT_EXPENSES | NUMBER | (15) | Medical and dental expenses | |
| P_TUIT_PAID_AMOUNT | NUMBER | (15) | Tuition paid amount | |
| P_TUIT_PAID_NUMBER | NUMBER | (15) | Tuition paid number | |
| P_EXP_CHILD_SUPP_PAID | NUMBER | (15) | Expected child support paid | |
| P_EXP_REPAY_ED_LOANS | NUMBER | (15) | Expected repay educational loans | |
| P_EXP_MED_DENT_EXPENSES | NUMBER | (15) | Expected medical and dental expenses | |
| P_EXP_TUIT_PD_AMOUNT | NUMBER | (15) | Expected tuition paid amount | |
| P_EXP_TUIT_PD_NUMBER | NUMBER | (15) | Expected tuition paid number | |
| P_CASH_SAV_CHECK | NUMBER | (15) | cash savings check | |
| P_MONTH_MORTGAGE_PAY | NUMBER | (15) | month mortgage pay | |
| P_INVEST_VALUE | NUMBER | (15) | investment value | |
| P_INVEST_DEBT | NUMBER | (15) | investment debt | |
| P_HOME_VALUE | NUMBER | (15) | home value | |
| P_HOME_DEBT | NUMBER | (15) | home debt | |
| P_HOME_PURCH_PRICE | NUMBER | (15) | Home purchase price | |
| P_OWN_BUSINESS_FARM | VARCHAR2 | (30) | own business farm | |
| P_BUSINESS_VALUE | NUMBER | (15) | business value | |
| P_BUSINESS_DEBT | NUMBER | (15) | business debt | |
| P_FARM_VALUE | NUMBER | (15) | farm value | |
| P_FARM_DEBT | NUMBER | (15) | farm debt | |
| P_LIVE_ON_FARM | NUMBER | (15) | farm debt | |
| P_OTH_REAL_ESTATE_VALUE | NUMBER | (15) | Other real estate value | |
| P_OTH_REAL_ESTATE_DEBT | NUMBER | (15) | Other real estate debt | |
| P_OTH_REAL_PURCH_PRICE | NUMBER | (15) | Other real purchase price | |
| P_SIBLINGS_ASSETS | NUMBER | (15) | Siblings assets | |
| P_HOME_PURCH_YEAR | VARCHAR2 | (4) | Home purchase year | |
| P_OTH_REAL_PURCH_YEAR | VARCHAR2 | (4) | Other real purchase year | |
| P_PRIOR_AGI | NUMBER | (15) | Prior actual gross income | |
| P_PRIOR_US_TAX_PAID | NUMBER | (15) | Prior us tax paid | |
| P_PRIOR_ITEM_DEDUCTIONS | NUMBER | (15) | Prior item deductions | |
| P_PRIOR_OTHER_UNTAX_INC | NUMBER | (15) | Prior other untaxed inclusions | |
| P_TAX_FIGURES | NUMBER | (15) | Tax figures | |
| P_NUMBER_EXEMPTIONS | NUMBER | (15) | Number exemptions | |
| P_ADJUSTED_GROSS_INC | NUMBER | (15) | Adjusted gross income | |
| P_WAGES_SAL_TIPS | NUMBER | (15) | Wages salary tips | |
| P_INTEREST_INCOME | NUMBER | (15) | Interest income | |
| P_DIVIDEND_INCOME | NUMBER | (15) | Dividend income | |
| P_NET_INC_BUS_FARM | NUMBER | (15) | Net income bus farm | |
| P_OTHER_TAXABLE_INCOME | NUMBER | (15) | Other taxable income | |
| P_ADJ_TO_INCOME | NUMBER | (15) | Adjust to income | |
| P_US_TAX_PAID | NUMBER | (15) | Us Tax paid | |
| P_ITEMIZED_DEDUCTIONS | NUMBER | (15) | Itemized deductions | |
| P_FATHER_INCOME_WORK | NUMBER | (15) | Father income work | |
| P_MOTHER_INCOME_WORK | NUMBER | (15) | Mother income work | |
| P_SOC_SEC_BEN | NUMBER | (15) | Social Security Benefits | |
| P_WELFARE_TANF | NUMBER | (15) | Welfare TANF | |
| P_CHILD_SUPP_RCVD | NUMBER | (15) | Child support received | |
| P_DED_IRA_KEOGH | NUMBER | (15) | Holds deductions IRA KEOGH | |
| P_TAX_DEFER_PENS_SAVS | NUMBER | (15) | Holds parents tax defer pension savings | |
| P_DEP_CARE_MED_SPENDING | NUMBER | (15) | Dependents care and medical spending | |
| P_EARNED_INCOME_CREDIT | NUMBER | (15) | Holds earned income credit | |
| P_LIVING_ALLOW | NUMBER | (15) | describes living allow | |
| P_TAX_EXMPT_INT | NUMBER | (15) | Holds tax exemption interval | |
| P_FOREIGN_INC_EXCL | NUMBER | (15) | Contains foreign income excluding | |
| P_OTHER_UNTAX_INC | NUMBER | (15) | other untaxed inclusions | |
| P_HOPE_LL_CREDIT | NUMBER | (15) | Hope LL credit | |
| P_YR_SEPARATION | NUMBER | (15) | Holds year separation | |
| P_YR_DIVORCE | NUMBER | (15) | Holds year divorce | |
| P_EXP_FATHER_INC | NUMBER | (15) | Holds expected father income | |
| P_EXP_MOTHER_INC | NUMBER | (15) | Holds expected mother income | |
| P_EXP_OTHER_TAX_INC | NUMBER | (15) | Holds expected other tax income | |
| P_EXP_OTHER_UNTAX_INC | NUMBER | (15) | Holds expected other untaxed income | |
| LINE_2_RELATION | VARCHAR2 | (30) | Holds the relation | |
| LINE_2_ATTEND_COLLEGE | VARCHAR2 | (30) | Holds College attended | |
| LINE_3_RELATION | VARCHAR2 | (30) | Holds the relation | |
| LINE_3_ATTEND_COLLEGE | VARCHAR2 | (30) | Holds College attended | |
| LINE_4_RELATION | VARCHAR2 | (30) | Holds the relation | |
| LINE_4_ATTEND_COLLEGE | VARCHAR2 | (30) | Holds College attended | |
| LINE_5_RELATION | VARCHAR2 | (30) | Holds the relation | |
| LINE_5_ATTEND_COLLEGE | VARCHAR2 | (30) | Holds College attended | |
| LINE_6_RELATION | VARCHAR2 | (30) | Holds the relation | |
| LINE_6_ATTEND_COLLEGE | VARCHAR2 | (30) | Holds College attended | |
| LINE_7_RELATION | VARCHAR2 | (30) | Holds the relation | |
| LINE_7_ATTEND_COLLEGE | VARCHAR2 | (30) | Holds College attended | |
| LINE_8_RELATION | VARCHAR2 | (30) | Holds the relation | |
| LINE_8_ATTEND_COLLEGE | VARCHAR2 | (30) | Holds College attended | |
| P_AGE_FATHER | VARCHAR2 | (2) | Holds age of father | |
| P_AGE_MOTHER | VARCHAR2 | (2) | Holds age of mother | |
| P_DIV_SEP_IND | VARCHAR2 | (30) | Describes divorce separation indicator | |
| B_CONT_NON_CUSTODIAL_PAR | VARCHAR2 | (6) | Contains non custodial parent | |
| COLLEGE_TYPE_2 | VARCHAR2 | (30) | Holds college type | |
| COLLEGE_TYPE_3 | VARCHAR2 | (30) | Holds college type | |
| COLLEGE_TYPE_4 | VARCHAR2 | (30) | Holds college type | |
| COLLEGE_TYPE_5 | VARCHAR2 | (30) | Holds college type | |
| COLLEGE_TYPE_6 | VARCHAR2 | (30) | Holds college type | |
| COLLEGE_TYPE_7 | VARCHAR2 | (30) | Holds college type | |
| COLLEGE_TYPE_8 | VARCHAR2 | (30) | Holds college type | |
| SCHOOL_CODE_1 | VARCHAR2 | (4) | Holds the school code | |
| HOUSING_CODE_1 | VARCHAR2 | (30) | Holds the house code | |
| SCHOOL_CODE_2 | VARCHAR2 | (4) | Holds the school code | |
| HOUSING_CODE_2 | VARCHAR2 | (30) | Holds the house code | |
| SCHOOL_CODE_3 | VARCHAR2 | (4) | Holds the school code | |
| HOUSING_CODE_3 | VARCHAR2 | (30) | Holds the house code | |
| SCHOOL_CODE_4 | VARCHAR2 | (4) | Holds the school code | |
| HOUSING_CODE_4 | VARCHAR2 | (30) | Holds the house code | |
| SCHOOL_CODE_5 | VARCHAR2 | (4) | Holds the school code | |
| HOUSING_CODE_5 | VARCHAR2 | (30) | Holds the house code | |
| SCHOOL_CODE_6 | VARCHAR2 | (4) | Holds the school code | |
| HOUSING_CODE_6 | VARCHAR2 | (30) | Holds the house code | |
| SCHOOL_CODE_7 | VARCHAR2 | (4) | Holds the school code | |
| HOUSING_CODE_7 | VARCHAR2 | (30) | Holds the house code | |
| SCHOOL_CODE_8 | VARCHAR2 | (4) | Holds the school code | |
| HOUSING_CODE_8 | VARCHAR2 | (30) | Holds the house code | |
| SCHOOL_CODE_9 | VARCHAR2 | (4) | Holds the school code | |
| HOUSING_CODE_9 | VARCHAR2 | (30) | Holds the house code | |
| SCHOOL_CODE_10 | VARCHAR2 | (4) | Holds the school code | |
| HOUSING_CODE_10 | VARCHAR2 | (30) | Holds the house code | |
| ADDITIONAL_SCHOOL_CODE_1 | VARCHAR2 | (4) | Contains additional school code | |
| ADDITIONAL_SCHOOL_CODE_2 | VARCHAR2 | (4) | Contains additional school code | |
| ADDITIONAL_SCHOOL_CODE_3 | VARCHAR2 | (4) | Contains additional school code | |
| ADDITIONAL_SCHOOL_CODE_4 | VARCHAR2 | (4) | Contains additional school code | |
| ADDITIONAL_SCHOOL_CODE_5 | VARCHAR2 | (4) | Contains additional school code | |
| ADDITIONAL_SCHOOL_CODE_6 | VARCHAR2 | (4) | Contains additional school code | |
| ADDITIONAL_SCHOOL_CODE_7 | VARCHAR2 | (4) | Contains additional school code | |
| ADDITIONAL_SCHOOL_CODE_8 | VARCHAR2 | (4) | Contains additional school code | |
| ADDITIONAL_SCHOOL_CODE_9 | VARCHAR2 | (4) | Contains additional school code | |
| ADDITIONAL_SCHOOL_CODE_10 | VARCHAR2 | (4) | Contains additional school code | |
| EXPLANATION_SPEC_CIRCUM | VARCHAR2 | (30) | Describes the special circumstances | |
| SIGNATURE_STUDENT | VARCHAR2 | (30) | Holds the signature of student | |
| SIGNATURE_SPOUSE | VARCHAR2 | (30) | Holds the signature of spouse | |
| SIGNATURE_FATHER | VARCHAR2 | (30) | Holds the signature of father | |
| SIGNATURE_MOTHER | VARCHAR2 | (30) | Holds the signature of mother | |
| MONTH_DAY_COMPLETED | VARCHAR2 | (4) | Contains month day completed | |
| YEAR_COMPLETED | VARCHAR2 | (30) | Holds year completed | |
| AGE_LINE_2 | NUMBER | (15) | Holds the age | |
| AGE_LINE_3 | NUMBER | (15) | Holds the age | |
| AGE_LINE_4 | NUMBER | (15) | Holds the age | |
| AGE_LINE_5 | NUMBER | (15) | Holds the age | |
| AGE_LINE_6 | NUMBER | (15) | Holds the age | |
| AGE_LINE_7 | NUMBER | (15) | Holds the age | |
| AGE_LINE_8 | NUMBER | (15) | Holds the age | |
| A_ONLINE_SIGNATURE | VARCHAR2 | (30) | Holds the signature | |
| QUESTION_1_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_1_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_1_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_2_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_2_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_2_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_3_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_3_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_3_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_4_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_4_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_4_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_5_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_5_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_5_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_6_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_6_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_6_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_7_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_7_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_7_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_8_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_8_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_8_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_9_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_9_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_9_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_10_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_10_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_10_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_11_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_11_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_11_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_12_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_12_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_12_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_13_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_13_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_13_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_14_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_14_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_14_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_15_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_15_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_15_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_16_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_16_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_16_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_17_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_17_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_17_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_18_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_18_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_18_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_19_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_19_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_19_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_20_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_20_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_20_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_21_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_21_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_21_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_22_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_22_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_22_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_23_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_23_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_23_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_24_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_24_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_24_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_25_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_25_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_25_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_26_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_26_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_26_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_27_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_27_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_27_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_28_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_28_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_28_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_29_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTION_29_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_29_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| QUESTION_30_NUMBER | VARCHAR2 | (3) | Holds Question number | |
| QUESTIONS_30_SIZE | NUMBER | (15) | Holds the size of the question | |
| QUESTION_30_ANSWER | VARCHAR2 | (20) | Holds answer to the question | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard who column |
| LEGACY_RECORD_FLAG | VARCHAR2 | (1) | Indicates weather the record was imported through a legacy process or not | |
| COA_DURATION_EFC_AMT | NUMBER | (10) | Holds the EFC amount during COA duration | |
| COA_DURATION_NUM | NUMBER | Holds the duration of which Students EFC values are calculated | ||
| P_SOC_SEC_BEN_STUDENT_AMT | NUMBER | (6) | Social Security Benefits - Student amount | |
| P_TUIT_FEE_DEDUCT_AMT | NUMBER | (6) | Tuition and Fees Deduction Amount | |
| STU_LIVES_WITH_NUM | NUMBER | Student Lives With | ||
| STU_MOST_SUPPORT_FROM_NUM | NUMBER | Student Received Most Support From | ||
| LOCATION_COMPUTER_NUM | NUMBER | Computer Location |
Cut, paste (and edit) the following text to query this object:
SELECT CSSP_ID
, ORG_ID
, BASE_ID
, SYSTEM_RECORD_TYPE
, ACTIVE_PROFILE
, COLLEGE_CODE
, ACADEMIC_YEAR
, STU_RECORD_TYPE
, CSS_ID_NUMBER
, REGISTRATION_RECEIPT_DATE
, REGISTRATION_TYPE
, APPLICATION_RECEIPT_DATE
, APPLICATION_TYPE
, ORIGINAL_FNAR_COMPUTE
, REVISION_FNAR_COMPUTE_DATE
, ELECTRONIC_EXTRACT_DATE
, INSTITUTIONAL_REPORTING_TYPE
, ASR_RECEIPT_DATE
, LAST_NAME
, FIRST_NAME
, MIDDLE_INITIAL
, ADDRESS_NUMBER_AND_STREET
, CITY
, STATE_MAILING
, ZIP_CODE
, S_TELEPHONE_NUMBER
, S_TITLE
, DATE_OF_BIRTH
, SOCIAL_SECURITY_NUMBER
, STATE_LEGAL_RESIDENCE
, FOREIGN_ADDRESS_INDICATOR
, FOREIGN_POSTAL_CODE
, COUNTRY
, FINANCIAL_AID_STATUS
, YEAR_IN_COLLEGE
, MARITAL_STATUS
, WARD_COURT
, LEGAL_DEPENDENTS_OTHER
, HOUSEHOLD_SIZE
, NUMBER_IN_COLLEGE
, CITIZENSHIP_STATUS
, CITIZENSHIP_COUNTRY
, VISA_CLASSIFICATION
, TAX_FIGURES
, NUMBER_EXEMPTIONS
, ADJUSTED_GROSS_INC
, US_TAX_PAID
, ITEMIZED_DEDUCTIONS
, STU_INCOME_WORK
, SPOUSE_INCOME_WORK
, DIVID_INT_INC
, SOC_SEC_BENEFITS
, WELFARE_TANF
, CHILD_SUPP_RCVD
, EARNED_INCOME_CREDIT
, OTHER_UNTAX_INCOME
, TAX_STU_AID
, CASH_SAV_CHECK
, IRA_KEOGH
, INVEST_VALUE
, INVEST_DEBT
, HOME_VALUE
, HOME_DEBT
, OTH_REAL_VALUE
, OTH_REAL_DEBT
, BUS_FARM_VALUE
, BUS_FARM_DEBT
, LIVE_ON_FARM
, HOME_PURCH_PRICE
, HOPE_LL_CREDIT
, HOME_PURCH_YEAR
, TRUST_AMOUNT
, TRUST_AVAIL
, TRUST_ESTAB
, CHILD_SUPPORT_PAID
, MED_DENT_EXPENSES
, VET_US
, VET_BEN_AMOUNT
, VET_BEN_MONTHS
, STU_SUMMER_WAGES
, STU_SCHOOL_YR_WAGES
, SPOUSE_SUMMER_WAGES
, SPOUSE_SCHOOL_YR_WAGES
, SUMMER_OTHER_TAX_INC
, SCHOOL_YR_OTHER_TAX_INC
, SUMMER_UNTAX_INC
, SCHOOL_YR_UNTAX_INC
, GRANTS_SCHOL_ETC
, TUIT_BENEFITS
, CONT_PARENTS
, CONT_RELATIVES
, P_SIBLINGS_PRE_TUIT
, P_STUDENT_PRE_TUIT
, P_HOUSEHOLD_SIZE
, P_NUMBER_IN_COLLEGE
, P_PARENTS_IN_COLLEGE
, P_MARITAL_STATUS
, P_STATE_LEGAL_RESIDENCE
, P_NATURAL_PAR_STATUS
, P_CHILD_SUPP_PAID
, P_REPAY_ED_LOANS
, P_MED_DENT_EXPENSES
, P_TUIT_PAID_AMOUNT
, P_TUIT_PAID_NUMBER
, P_EXP_CHILD_SUPP_PAID
, P_EXP_REPAY_ED_LOANS
, P_EXP_MED_DENT_EXPENSES
, P_EXP_TUIT_PD_AMOUNT
, P_EXP_TUIT_PD_NUMBER
, P_CASH_SAV_CHECK
, P_MONTH_MORTGAGE_PAY
, P_INVEST_VALUE
, P_INVEST_DEBT
, P_HOME_VALUE
, P_HOME_DEBT
, P_HOME_PURCH_PRICE
, P_OWN_BUSINESS_FARM
, P_BUSINESS_VALUE
, P_BUSINESS_DEBT
, P_FARM_VALUE
, P_FARM_DEBT
, P_LIVE_ON_FARM
, P_OTH_REAL_ESTATE_VALUE
, P_OTH_REAL_ESTATE_DEBT
, P_OTH_REAL_PURCH_PRICE
, P_SIBLINGS_ASSETS
, P_HOME_PURCH_YEAR
, P_OTH_REAL_PURCH_YEAR
, P_PRIOR_AGI
, P_PRIOR_US_TAX_PAID
, P_PRIOR_ITEM_DEDUCTIONS
, P_PRIOR_OTHER_UNTAX_INC
, P_TAX_FIGURES
, P_NUMBER_EXEMPTIONS
, P_ADJUSTED_GROSS_INC
, P_WAGES_SAL_TIPS
, P_INTEREST_INCOME
, P_DIVIDEND_INCOME
, P_NET_INC_BUS_FARM
, P_OTHER_TAXABLE_INCOME
, P_ADJ_TO_INCOME
, P_US_TAX_PAID
, P_ITEMIZED_DEDUCTIONS
, P_FATHER_INCOME_WORK
, P_MOTHER_INCOME_WORK
, P_SOC_SEC_BEN
, P_WELFARE_TANF
, P_CHILD_SUPP_RCVD
, P_DED_IRA_KEOGH
, P_TAX_DEFER_PENS_SAVS
, P_DEP_CARE_MED_SPENDING
, P_EARNED_INCOME_CREDIT
, P_LIVING_ALLOW
, P_TAX_EXMPT_INT
, P_FOREIGN_INC_EXCL
, P_OTHER_UNTAX_INC
, P_HOPE_LL_CREDIT
, P_YR_SEPARATION
, P_YR_DIVORCE
, P_EXP_FATHER_INC
, P_EXP_MOTHER_INC
, P_EXP_OTHER_TAX_INC
, P_EXP_OTHER_UNTAX_INC
, LINE_2_RELATION
, LINE_2_ATTEND_COLLEGE
, LINE_3_RELATION
, LINE_3_ATTEND_COLLEGE
, LINE_4_RELATION
, LINE_4_ATTEND_COLLEGE
, LINE_5_RELATION
, LINE_5_ATTEND_COLLEGE
, LINE_6_RELATION
, LINE_6_ATTEND_COLLEGE
, LINE_7_RELATION
, LINE_7_ATTEND_COLLEGE
, LINE_8_RELATION
, LINE_8_ATTEND_COLLEGE
, P_AGE_FATHER
, P_AGE_MOTHER
, P_DIV_SEP_IND
, B_CONT_NON_CUSTODIAL_PAR
, COLLEGE_TYPE_2
, COLLEGE_TYPE_3
, COLLEGE_TYPE_4
, COLLEGE_TYPE_5
, COLLEGE_TYPE_6
, COLLEGE_TYPE_7
, COLLEGE_TYPE_8
, SCHOOL_CODE_1
, HOUSING_CODE_1
, SCHOOL_CODE_2
, HOUSING_CODE_2
, SCHOOL_CODE_3
, HOUSING_CODE_3
, SCHOOL_CODE_4
, HOUSING_CODE_4
, SCHOOL_CODE_5
, HOUSING_CODE_5
, SCHOOL_CODE_6
, HOUSING_CODE_6
, SCHOOL_CODE_7
, HOUSING_CODE_7
, SCHOOL_CODE_8
, HOUSING_CODE_8
, SCHOOL_CODE_9
, HOUSING_CODE_9
, SCHOOL_CODE_10
, HOUSING_CODE_10
, ADDITIONAL_SCHOOL_CODE_1
, ADDITIONAL_SCHOOL_CODE_2
, ADDITIONAL_SCHOOL_CODE_3
, ADDITIONAL_SCHOOL_CODE_4
, ADDITIONAL_SCHOOL_CODE_5
, ADDITIONAL_SCHOOL_CODE_6
, ADDITIONAL_SCHOOL_CODE_7
, ADDITIONAL_SCHOOL_CODE_8
, ADDITIONAL_SCHOOL_CODE_9
, ADDITIONAL_SCHOOL_CODE_10
, EXPLANATION_SPEC_CIRCUM
, SIGNATURE_STUDENT
, SIGNATURE_SPOUSE
, SIGNATURE_FATHER
, SIGNATURE_MOTHER
, MONTH_DAY_COMPLETED
, YEAR_COMPLETED
, AGE_LINE_2
, AGE_LINE_3
, AGE_LINE_4
, AGE_LINE_5
, AGE_LINE_6
, AGE_LINE_7
, AGE_LINE_8
, A_ONLINE_SIGNATURE
, QUESTION_1_NUMBER
, QUESTION_1_SIZE
, QUESTION_1_ANSWER
, QUESTION_2_NUMBER
, QUESTION_2_SIZE
, QUESTION_2_ANSWER
, QUESTION_3_NUMBER
, QUESTION_3_SIZE
, QUESTION_3_ANSWER
, QUESTION_4_NUMBER
, QUESTION_4_SIZE
, QUESTION_4_ANSWER
, QUESTION_5_NUMBER
, QUESTION_5_SIZE
, QUESTION_5_ANSWER
, QUESTION_6_NUMBER
, QUESTION_6_SIZE
, QUESTION_6_ANSWER
, QUESTION_7_NUMBER
, QUESTION_7_SIZE
, QUESTION_7_ANSWER
, QUESTION_8_NUMBER
, QUESTION_8_SIZE
, QUESTION_8_ANSWER
, QUESTION_9_NUMBER
, QUESTION_9_SIZE
, QUESTION_9_ANSWER
, QUESTION_10_NUMBER
, QUESTION_10_SIZE
, QUESTION_10_ANSWER
, QUESTION_11_NUMBER
, QUESTION_11_SIZE
, QUESTION_11_ANSWER
, QUESTION_12_NUMBER
, QUESTION_12_SIZE
, QUESTION_12_ANSWER
, QUESTION_13_NUMBER
, QUESTION_13_SIZE
, QUESTION_13_ANSWER
, QUESTION_14_NUMBER
, QUESTION_14_SIZE
, QUESTION_14_ANSWER
, QUESTION_15_NUMBER
, QUESTION_15_SIZE
, QUESTION_15_ANSWER
, QUESTION_16_NUMBER
, QUESTION_16_SIZE
, QUESTION_16_ANSWER
, QUESTION_17_NUMBER
, QUESTION_17_SIZE
, QUESTION_17_ANSWER
, QUESTION_18_NUMBER
, QUESTION_18_SIZE
, QUESTION_18_ANSWER
, QUESTION_19_NUMBER
, QUESTION_19_SIZE
, QUESTION_19_ANSWER
, QUESTION_20_NUMBER
, QUESTION_20_SIZE
, QUESTION_20_ANSWER
, QUESTION_21_NUMBER
, QUESTION_21_SIZE
, QUESTION_21_ANSWER
, QUESTION_22_NUMBER
, QUESTION_22_SIZE
, QUESTION_22_ANSWER
, QUESTION_23_NUMBER
, QUESTION_23_SIZE
, QUESTION_23_ANSWER
, QUESTION_24_NUMBER
, QUESTION_24_SIZE
, QUESTION_24_ANSWER
, QUESTION_25_NUMBER
, QUESTION_25_SIZE
, QUESTION_25_ANSWER
, QUESTION_26_NUMBER
, QUESTION_26_SIZE
, QUESTION_26_ANSWER
, QUESTION_27_NUMBER
, QUESTION_27_SIZE
, QUESTION_27_ANSWER
, QUESTION_28_NUMBER
, QUESTION_28_SIZE
, QUESTION_28_ANSWER
, QUESTION_29_NUMBER
, QUESTION_29_SIZE
, QUESTION_29_ANSWER
, QUESTION_30_NUMBER
, QUESTIONS_30_SIZE
, QUESTION_30_ANSWER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LEGACY_RECORD_FLAG
, COA_DURATION_EFC_AMT
, COA_DURATION_NUM
, P_SOC_SEC_BEN_STUDENT_AMT
, P_TUIT_FEE_DEDUCT_AMT
, STU_LIVES_WITH_NUM
, STU_MOST_SUPPORT_FROM_NUM
, LOCATION_COMPUTER_NUM
FROM IGF.IGF_AP_CSS_PROFILE_ALL;
IGF.IGF_AP_CSS_PROFILE_ALL does not reference any database object
IGF.IGF_AP_CSS_PROFILE_ALL is referenced by following:
APPS
IGF_AP_CSS_PROFILE_ALL
|
|
|
|