[Home] [Help] [Dependency Information]
Object Name: | IGF_AP_CS_UPD_FLAGS |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AP_CS_UPD_FLAGS |
Subobject Name: | |
Status: | VALID |
Obsolete
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AP_CS_UPD_FLAGS_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | BASE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BASE_ID | NUMBER | Yes | Unique identifier for student financial aid record | |
LAST_NAME | VARCHAR2 | (1) | Holds the last name | |
FIRST_NAME | VARCHAR2 | (1) | Holds the first name | |
MIDDLE_INITIAL | VARCHAR2 | (1) | Holds the middle initial | |
ADDRESS_NUMBER_AND_STREET | VARCHAR2 | (1) | Holds the address | |
CITY | VARCHAR2 | (1) | Holds the city | |
STATE_MAILING | VARCHAR2 | (1) | Holds the state mailing | |
ZIP_CODE | VARCHAR2 | (1) | Holds the zip code | |
S_TELEPHONE_NUMBER | VARCHAR2 | (1) | Holds the telephone number | |
S_TITLE | VARCHAR2 | (1) | Holds the title | |
DATE_OF_BIRTH | VARCHAR2 | (1) | Holds the date of birth | |
SOCIAL_SECURITY_NUMBER | VARCHAR2 | (1) | Holds the social security number | |
STATE_LEGAL_RESIDENCE | VARCHAR2 | (1) | Holds the state legal residence | |
FOREIGN_ADDRESS_INDICATOR | VARCHAR2 | (1) | Holds the foreign address indicator | |
FOREIGN_POSTAL_CODE | VARCHAR2 | (1) | Holds the foreign postal code | |
COUNTRY | VARCHAR2 | (1) | Holds the country | |
FINANCIAL_AID_STATUS | VARCHAR2 | (1) | Holds the status of financial aid | |
YEAR_IN_COLLEGE | VARCHAR2 | (1) | Holds the year in college | |
MARITAL_STATUS | VARCHAR2 | (1) | Holds marital status | |
WARD_COURT | VARCHAR2 | (1) | Holds the ward court | |
LEGAL_DEPENDENTS_OTHER | VARCHAR2 | (1) | Holds the legal dependents | |
HOUSEHOLD_SIZE | VARCHAR2 | (1) | Holds the household size | |
NUMBER_IN_COLLEGE | VARCHAR2 | (1) | Holds the number in college | |
CITIZENSHIP_STATUS | VARCHAR2 | (1) | Holds the status of citizen | |
CITIZENSHIP_COUNTRY | VARCHAR2 | (1) | Holds the country of citizen | |
VISA_CLASSIFICATION | VARCHAR2 | (1) | Describes the visa classification | |
TAX_FIGURES | VARCHAR2 | (1) | Holds the tax figure | |
NUMBER_EXEMPTIONS | VARCHAR2 | (1) | Holds the number exemption | |
ADJUSTED_GROSS_INC | VARCHAR2 | (1) | Holds the adjusted gross income | |
US_TAX_PAID | VARCHAR2 | (1) | Holds the US tax paid | |
ITEMIZED_DEDUCTIONS | VARCHAR2 | (1) | Holds the itemized deductions | |
STU_INCOME_WORK | VARCHAR2 | (1) | Holds the student income work | |
SPOUSE_INCOME_WORK | VARCHAR2 | (1) | Holds the spouse income work | |
DIVID_INT_INC | VARCHAR2 | (1) | Holds the divided interest income | |
SOC_SEC_BENEFITS | VARCHAR2 | (1) | Holds the social security benefits | |
WELFARE_TANF | VARCHAR2 | (1) | Holds the welfare transfer | |
CHILD_SUPP_RCVD | VARCHAR2 | (1) | Holds the child support received | |
EARNED_INCOME_CREDIT | VARCHAR2 | (1) | Holds the earned income credit | |
OTHER_UNTAX_INCOME | VARCHAR2 | (1) | Holds the other untaxed income | |
TAX_STU_AID | VARCHAR2 | (1) | Describes student tax aid | |
CASH_SAV_CHECK | VARCHAR2 | (1) | Holds the cash saving check | |
IRA_KEOGH | VARCHAR2 | (1) | Holds the IRA KEOGH | |
INVEST_VALUE | VARCHAR2 | (1) | Holds the invest value | |
INVEST_DEBT | VARCHAR2 | (1) | Holds the invest debt | |
HOME_VALUE | VARCHAR2 | (1) | Holds the home value | |
HOME_DEBT | VARCHAR2 | (1) | Holds the home debt | |
OTH_REAL_VALUE | VARCHAR2 | (1) | Holds the other real value | |
OTH_REAL_DEBT | VARCHAR2 | (1) | Holds the other real debt | |
BUS_FARM_VALUE | VARCHAR2 | (1) | Holds the business farm value | |
BUS_FARM_DEBT | VARCHAR2 | (1) | Holds the business farm debt | |
LIVE_ON_FARM | VARCHAR2 | (1) | Denotes in student lives on farm | |
HOME_PURCH_PRICE | VARCHAR2 | (1) | Holds the price of home purchase | |
HOPE_LL_CREDIT | VARCHAR2 | (1) | Holds the hope LL credit | |
HOME_PURCH_YEAR | VARCHAR2 | (1) | Describes the year of home purchase | |
TRUST_AMOUNT | VARCHAR2 | (1) | Holds the trust amount | |
TRUST_AVAIL | VARCHAR2 | (1) | Holds the trust available | |
TRUST_ESTAB | VARCHAR2 | (1) | Holds the trust established | |
CHILD_SUPPORT_PAID | VARCHAR2 | (1) | Holds the children support paid | |
MED_DENT_EXPENSES | VARCHAR2 | (1) | Holds the medical and dental expenses | |
VET_US | VARCHAR2 | (1) | Holds the veteran befits US | |
VET_BEN_AMOUNT | VARCHAR2 | (1) | Holds the veteran befits amount | |
VET_BEN_MONTHS | VARCHAR2 | (1) | Holds the veteran befits months | |
STU_SUMMER_WAGES | VARCHAR2 | (1) | Describes the student summer wages | |
STU_SCHOOL_YR_WAGES | VARCHAR2 | (1) | Describes the student school year wages | |
SPOUSE_SUMMER_WAGES | VARCHAR2 | (1) | Describes the spouse summer wages | |
SPOUSE_SCHOOL_YR_WAGES | VARCHAR2 | (1) | Describes the spouse school year wages | |
SUMMER_OTHER_TAX_INC | VARCHAR2 | (1) | Describes the summer other tax income | |
SCHOOL_YR_OTHER_TAX_INC | VARCHAR2 | (1) | Holds the school year other tax income | |
SUMMER_UNTAX_INC | VARCHAR2 | (1) | Holds the summer untaxed income | |
SCHOOL_YR_UNTAX_INC | VARCHAR2 | (1) | Holds the school year untaxed income | |
GRANTS_SCHOL_ETC | VARCHAR2 | (1) | Holds the school grants etc | |
TUIT_BENEFITS | VARCHAR2 | (1) | Holds the tuition benefits | |
CONT_PARENTS | VARCHAR2 | (1) | Describes the contribution of parents | |
CONT_RELATIVES | VARCHAR2 | (1) | Describes the contribution of relatives | |
P_SIBLINGS_PRE_TUIT | VARCHAR2 | (1) | Holds the siblings pre tuition | |
P_STUDENT_PRE_TUIT | VARCHAR2 | (1) | Holds the student pre tuition | |
P_HOUSEHOLD_SIZE | VARCHAR2 | (1) | Holds the size of house hold | |
P_NUMBER_IN_COLLEGE | VARCHAR2 | (1) | Holds the number in college | |
P_PARENTS_IN_COLLEGE | VARCHAR2 | (1) | Holds the parents in college | |
P_MARITAL_STATUS | VARCHAR2 | (1) | Holds the marital status | |
P_STATE_LEGAL_RESIDENCE | VARCHAR2 | (1) | Holds the state legal residence | |
P_NATURAL_PAR_STATUS | VARCHAR2 | (1) | Describes the natural parents status | |
P_CHILD_SUPP_PAID | VARCHAR2 | (1) | Holds the expected support paid | |
P_REPAY_ED_LOANS | VARCHAR2 | (1) | Holds the repay education loans | |
P_MED_DENT_EXPENSES | VARCHAR2 | (1) | Holds the medical and dental expenses | |
P_TUIT_PAID_AMOUNT | VARCHAR2 | (1) | Contains the tuition paid amount | |
P_TUIT_PAID_NUMBER | VARCHAR2 | (1) | Contains the tuition paid number | |
P_EXP_CHILD_SUPP_PAID | VARCHAR2 | (1) | Holds the expected child support paid | |
P_EXP_REPAY_ED_LOANS | VARCHAR2 | (1) | Holds the expected repay education loans | |
P_EXP_MED_DENT_EXPENSES | VARCHAR2 | (1) | Contains the expected medical and dental expenses | |
P_EXP_TUIT_PD_AMOUNT | VARCHAR2 | (1) | Describes the expected tuition paid amount | |
P_EXP_TUIT_PD_NUMBER | VARCHAR2 | (1) | Describes the expected tuition paid number | |
P_CASH_SAV_CHECK | VARCHAR2 | (1) | Holds the cash saving check | |
P_MONTH_MORTGAGE_PAY | VARCHAR2 | (1) | Contains the month of mortgage pay | |
P_INVEST_VALUE | VARCHAR2 | (1) | Hold the investment value | |
P_INVEST_DEBT | VARCHAR2 | (1) | Hold the investment debt | |
P_HOME_VALUE | VARCHAR2 | (1) | Hold the home values | |
P_HOME_DEBT | VARCHAR2 | (1) | Hold the home debt | |
P_HOME_PURCH_PRICE | VARCHAR2 | (1) | Describes the home purchase price | |
P_OWN_BUSINESS_FARM | VARCHAR2 | (1) | Holds the own business farm | |
P_BUSINESS_VALUE | VARCHAR2 | (1) | Holds the business value | |
P_BUSINESS_DEBT | VARCHAR2 | (1) | Holds the business debt | |
P_FARM_VALUE | VARCHAR2 | (1) | Holds the farm value | |
P_FARM_DEBT | VARCHAR2 | (1) | Holds the farm debt | |
P_LIVE_ON_FARM | VARCHAR2 | (1) | Denotes if parent lives on farm | |
P_OTH_REAL_ESTATE_VALUE | VARCHAR2 | (1) | Holds the other real estate purchase values | |
P_OTH_REAL_ESTATE_DEBT | VARCHAR2 | (1) | Holds the other real estate purchase debt | |
P_OTH_REAL_PURCH_PRICE | VARCHAR2 | (1) | Holds the other real estate purchase price | |
P_SIBLINGS_ASSETS | VARCHAR2 | (1) | Holds the parents siblings assets | |
P_HOME_PURCH_YEAR | VARCHAR2 | (1) | Contains the home purchase year | |
P_OTH_REAL_PURCH_YEAR | VARCHAR2 | (1) | Holds the other real estate purchase year | |
P_PRIOR_AGI | VARCHAR2 | (1) | Holds the prior adjust gross income | |
P_PRIOR_US_TAX_PAID | VARCHAR2 | (1) | Describes the prior US tax paid | |
P_PRIOR_ITEM_DEDUCTIONS | VARCHAR2 | (1) | Prior item deductions | |
P_PRIOR_OTHER_UNTAX_INC | VARCHAR2 | (1) | Prior other untaxed income | |
P_TAX_FIGURES | VARCHAR2 | (1) | Holds the tax figures | |
P_NUMBER_EXEMPTIONS | VARCHAR2 | (1) | Holds the number exemption | |
P_ADJUSTED_GROSS_INC | VARCHAR2 | (1) | Holds the adjusted gross income | |
P_WAGES_SAL_TIPS | VARCHAR2 | (1) | Holds the wages the salary tips | |
P_INTEREST_INCOME | VARCHAR2 | (1) | Contains interest income | |
P_DIVIDEND_INCOME | VARCHAR2 | (1) | Holds the dividend income | |
P_NET_INC_BUS_FARM | VARCHAR2 | (1) | Holds the net income business farm | |
P_OTHER_TAXABLE_INCOME | VARCHAR2 | (1) | Contains the other taxable income | |
P_ADJ_TO_INCOME | VARCHAR2 | (1) | Adjusted to income | |
P_US_TAX_PAID | VARCHAR2 | (1) | Describes the US tax paid | |
P_ITEMIZED_DEDUCTIONS | VARCHAR2 | (1) | Describes the itemized deductions | |
P_FATHER_INCOME_WORK | VARCHAR2 | (1) | Father's income from work | |
P_MOTHER_INCOME_WORK | VARCHAR2 | (1) | Mother's income from work | |
P_SOC_SEC_BEN | VARCHAR2 | (1) | Holds the social security benefits | |
P_WELFARE_TANF | VARCHAR2 | (1) | Parents welfare transfer | |
P_CHILD_SUPP_RCVD | VARCHAR2 | (1) | Children support received | |
P_DED_IRA_KEOGH | VARCHAR2 | (1) | Holds the deduction IRA KEOGH | |
P_TAX_DEFER_PENS_SAVS | VARCHAR2 | (1) | Describes the tax defer pension and savings | |
P_DEP_CARE_MED_SPENDING | VARCHAR2 | (1) | Holds the dependents care medical spending | |
P_EARNED_INCOME_CREDIT | VARCHAR2 | (1) | Parents earned income credit | |
P_LIVING_ALLOW | VARCHAR2 | (1) | Parents Living allowance | |
P_TAX_EXMPT_INT | VARCHAR2 | (1) | Contains tax exempted interest | |
P_FOREIGN_INC_EXCL | VARCHAR2 | (1) | Holds the foreign income exclude | |
P_OTHER_UNTAX_INC | VARCHAR2 | (1) | Holds other untaxed income | |
P_HOPE_LL_CREDIT | VARCHAR2 | (1) | Holds the hope LL credit | |
P_YR_SEPARATION | VARCHAR2 | (1) | Year of separation | |
P_YR_DIVORCE | VARCHAR2 | (1) | Year of divorce | |
P_EXP_FATHER_INC | VARCHAR2 | (1) | Holds expected father income | |
P_EXP_MOTHER_INC | VARCHAR2 | (1) | Expected father income | |
P_EXP_OTHER_TAX_INC | VARCHAR2 | (1) | Expected father income | |
P_EXP_OTHER_UNTAX_INC | VARCHAR2 | (1) | Expected other untaxed income | |
LINE_2_RELATION | VARCHAR2 | (1) | Holds the relation line | |
LINE_2_ATTEND_COLLEGE | VARCHAR2 | (1) | Holds the attend college | |
LINE_3_RELATION | VARCHAR2 | (1) | Holds the relation line | |
LINE_3_ATTEND_COLLEGE | VARCHAR2 | (1) | Holds the attend college | |
LINE_4_RELATION | VARCHAR2 | (1) | Holds the relation line | |
LINE_4_ATTEND_COLLEGE | VARCHAR2 | (1) | Holds the attend college | |
LINE_5_RELATION | VARCHAR2 | (1) | Holds the relation line | |
LINE_5_ATTEND_COLLEGE | VARCHAR2 | (1) | Holds the attend college | |
LINE_6_RELATION | VARCHAR2 | (1) | Holds the relation line | |
LINE_6_ATTEND_COLLEGE | VARCHAR2 | (1) | Holds the attend college | |
LINE_7_RELATION | VARCHAR2 | (1) | Holds the relation line | |
LINE_7_ATTEND_COLLEGE | VARCHAR2 | (1) | Holds the attend college | |
LINE_8_RELATION | VARCHAR2 | (1) | Holds the relation line | |
LINE_8_ATTEND_COLLEGE | VARCHAR2 | (1) | Holds the attend college | |
P_AGE_FATHER | VARCHAR2 | (1) | Holds the age of father | |
P_AGE_MOTHER | VARCHAR2 | (1) | Holds the age of father | |
P_DIV_SEP_IND | VARCHAR2 | (1) | Divorce separation indicator | |
B_CONT_NON_CUSTODIAL_PAR | VARCHAR2 | (1) | Contribution of non custodial parents | |
COLLEGE_TYPE_2 | VARCHAR2 | (1) | Holds the type of college | |
COLLEGE_TYPE_3 | VARCHAR2 | (1) | Holds the type of college | |
COLLEGE_TYPE_4 | VARCHAR2 | (1) | Holds the type of college | |
COLLEGE_TYPE_5 | VARCHAR2 | (1) | Holds the type of college | |
COLLEGE_TYPE_6 | VARCHAR2 | (1) | Holds the type of college | |
COLLEGE_TYPE_7 | VARCHAR2 | (1) | Holds the type of college | |
COLLEGE_TYPE_8 | VARCHAR2 | (1) | Holds the type of college | |
SCHOOL_CODE_1 | VARCHAR2 | (1) | Holds the school code | |
HOUSING_CODE_1 | VARCHAR2 | (1) | Holds the housing code | |
SCHOOL_CODE_2 | VARCHAR2 | (1) | Holds the school code | |
HOUSING_CODE_2 | VARCHAR2 | (1) | Holds the housing code | |
SCHOOL_CODE_3 | VARCHAR2 | (1) | Holds the school code | |
HOUSING_CODE_3 | VARCHAR2 | (1) | Holds the housing code | |
SCHOOL_CODE_4 | VARCHAR2 | (1) | Holds the school code | |
HOUSING_CODE_4 | VARCHAR2 | (1) | Holds the housing code | |
SCHOOL_CODE_5 | VARCHAR2 | (1) | Holds the school code | |
HOUSING_CODE_5 | VARCHAR2 | (1) | Holds the housing code | |
SCHOOL_CODE_6 | VARCHAR2 | (1) | Holds the school code | |
HOUSING_CODE_6 | VARCHAR2 | (1) | Holds the housing code | |
SCHOOL_CODE_7 | VARCHAR2 | (1) | Holds the school code | |
HOUSING_CODE_7 | VARCHAR2 | (1) | Holds the housing code | |
SCHOOL_CODE_8 | VARCHAR2 | (1) | Holds the school code | |
HOUSING_CODE_8 | VARCHAR2 | (1) | Holds the housing code | |
SCHOOL_CODE_9 | VARCHAR2 | (1) | Holds the school code | |
HOUSING_CODE_9 | VARCHAR2 | (1) | Holds the housing code | |
SCHOOL_CODE_10 | VARCHAR2 | (1) | Holds the school code | |
HOUSING_CODE_10 | VARCHAR2 | (1) | Holds the housing code | |
ADDITIONAL_SCHOOL_CODE_1 | VARCHAR2 | (1) | Holds the additional school code | |
ADDITIONAL_SCHOOL_CODE_2 | VARCHAR2 | (1) | Holds the additional school code | |
ADDITIONAL_SCHOOL_CODE_3 | VARCHAR2 | (1) | Holds the additional school code | |
ADDITIONAL_SCHOOL_CODE_4 | VARCHAR2 | (1) | Holds the additional school code | |
ADDITIONAL_SCHOOL_CODE_5 | VARCHAR2 | (1) | Holds the additional school code | |
ADDITIONAL_SCHOOL_CODE_6 | VARCHAR2 | (1) | Holds the additional school code | |
ADDITIONAL_SCHOOL_CODE_7 | VARCHAR2 | (1) | Holds the additional school code | |
ADDITIONAL_SCHOOL_CODE_8 | VARCHAR2 | (1) | Holds the additional school code | |
ADDITIONAL_SCHOOL_CODE_9 | VARCHAR2 | (1) | Holds the additional school code | |
ADDITIONAL_SCHOOL_CODE_10 | VARCHAR2 | (1) | Holds the additional school code | |
EXPLANATION_SPEC_CIRCUM | VARCHAR2 | (1) | Explanation special circumstance | |
SIGNATURE_STUDENT | VARCHAR2 | (1) | Holds the signature student | |
SIGNATURE_SPOUSE | VARCHAR2 | (1) | Holds the signature spouse | |
SIGNATURE_FATHER | VARCHAR2 | (1) | Holds the signature father | |
SIGNATURE_MOTHER | VARCHAR2 | (1) | Holds the signature mother | |
MONTH_DAY_COMPLETED | VARCHAR2 | (1) | Month day completed | |
YEAR_COMPLETED | VARCHAR2 | (1) | year completed | |
AGE_LINE_2 | VARCHAR2 | (1) | Contains the age line | |
AGE_LINE_3 | VARCHAR2 | (1) | Contains the age line | |
AGE_LINE_4 | VARCHAR2 | (1) | Contains the age line | |
AGE_LINE_5 | VARCHAR2 | (1) | Contains the age line | |
AGE_LINE_6 | VARCHAR2 | (1) | Contains the age line | |
AGE_LINE_7 | VARCHAR2 | (1) | Contains the age line | |
AGE_LINE_8 | VARCHAR2 | (1) | Contains the age line | |
A_ONLINE_SIGNATURE | VARCHAR2 | (1) | Flag to specify the Student Applicant's On-line Signature | |
QUESTION_1_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_1_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_1_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_2_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_2_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_2_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_3_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_3_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_3_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_4_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_4_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_4_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_5_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_5_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_5_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_6_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_6_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_6_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_7_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_7_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_7_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_8_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_8_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_8_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_9_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_9_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_9_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_10_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_10_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_10_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_11_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_11_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_11_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_12_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_12_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_12_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_13_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_13_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_13_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_14_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_14_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_14_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_15_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_15_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_15_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_16_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_16_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_16_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_17_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_17_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_17_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_18_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_18_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_18_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_19_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_19_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_19_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_20_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_20_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_20_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_21_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_21_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_21_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_22_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_22_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_22_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_23_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_23_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_23_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_24_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_24_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_24_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_25_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_25_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_25_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_26_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_26_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_26_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_27_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_27_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_27_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_28_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_28_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_28_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_29_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTION_29_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_29_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
QUESTION_30_NUMBER | VARCHAR2 | (1) | Holds the question number | |
QUESTIONS_30_SIZE | VARCHAR2 | (1) | Holds the question size | |
QUESTION_30_ANSWER | VARCHAR2 | (1) | Describes the answers to question | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO columns |
CREATION_DATE | DATE | Yes | Standard WHO columns | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO columns |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO columns | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard WHO columns |
Cut, paste (and edit) the following text to query this object:
SELECT BASE_ID
, 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
FROM IGF.IGF_AP_CS_UPD_FLAGS;
IGF.IGF_AP_CS_UPD_FLAGS does not reference any database object
IGF.IGF_AP_CS_UPD_FLAGS is referenced by following:
|
|
|