[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_ISIR_UPD_FLAG_OLD |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_ARCHIVE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_AP_ISIR_UPD_FLAG_U1 | NORMAL | UNIQUE |
APPS_TS_ARCHIVE
|
 BASE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BASE_ID | NUMBER | (15) | Yes | |
| TRANSACTION_NUM | VARCHAR2 | (1) | Yes | |
| CURRENT_SSN | VARCHAR2 | (1) | ||
| LAST_NAME | VARCHAR2 | (1) | ||
| FIRST_NAME | VARCHAR2 | (1) | ||
| MIDDLE_INITIAL | VARCHAR2 | (1) | ||
| PERM_MAIL_ADD | VARCHAR2 | (1) | ||
| PERM_CITY | VARCHAR2 | (1) | ||
| PERM_STATE | VARCHAR2 | (1) | ||
| PERM_ZIP_CODE | VARCHAR2 | (1) | ||
| DATE_OF_BIRTH | VARCHAR2 | (1) | ||
| PHONE_NUMBER | VARCHAR2 | (1) | ||
| DRIVER_LICENSE_NUM | VARCHAR2 | (1) | ||
| DRIVER_LICENSE_STATE | VARCHAR2 | (1) | ||
| CITIZENSHIP_STATUS | VARCHAR2 | (1) | ||
| ALIEN_REG_NUMBER | VARCHAR2 | (1) | ||
| S_MARITAL_STATUS | VARCHAR2 | (1) | ||
| S_MARITAL_STATUS_DATE | VARCHAR2 | (1) | ||
| SUMM_ENRL_STATUS | VARCHAR2 | (1) | ||
| FALL_ENRL_STATUS | VARCHAR2 | (1) | ||
| WINTER_ENRL_STATUS | VARCHAR2 | (1) | ||
| SPRING_ENRL_STATUS | VARCHAR2 | (1) | ||
| SUMM2_ENRL_STATUS | VARCHAR2 | (1) | ||
| FATHERS_HIGHEST_EDU_LEVEL | VARCHAR2 | (1) | ||
| MOTHERS_HIGHEST_EDU_LEVEL | VARCHAR2 | (1) | ||
| S_STATE_LEGAL_RESIDENCE | VARCHAR2 | (1) | ||
| LEGAL_RESIDENCE_BEFORE_DATE | VARCHAR2 | (1) | ||
| S_LEGAL_RESD_DATE | VARCHAR2 | (1) | ||
| SS_R_U_MALE | VARCHAR2 | (1) | ||
| SELECTIVE_SERVICE_REG | VARCHAR2 | (1) | ||
| DEGREE_CERTIFICATION | VARCHAR2 | (1) | ||
| GRADE_LEVEL_IN_COLLEGE | VARCHAR2 | (1) | ||
| HIGH_SCHOOL_DIPLOMA_GED | VARCHAR2 | (1) | ||
| FIRST_BACHELOR_DEG_BY_DATE | VARCHAR2 | (1) | ||
| INTEREST_IN_STUD_LOAN | VARCHAR2 | (1) | ||
| INTEREST_IN_STUD_EMPLOYMENT | VARCHAR2 | (1) | ||
| DRUG_OFFENCE_CONVICTION | VARCHAR2 | (1) | ||
| S_TAX_RETURN_STATUS | VARCHAR2 | (1) | ||
| S_TYPE_TAX_RETURN | VARCHAR2 | (1) | ||
| S_ELIG_1040EZ | VARCHAR2 | (1) | ||
| S_ADJUSTED_GROSS_INCOME | VARCHAR2 | (1) | ||
| S_FED_TAXES_PAID | VARCHAR2 | (1) | ||
| S_EXEMPTIONS | VARCHAR2 | (1) | ||
| S_INCOME_FROM_WORK | VARCHAR2 | (1) | ||
| SPOUSE_INCOME_FROM_WORK | VARCHAR2 | (1) | ||
| S_TOA_AMT_FROM_WSA | VARCHAR2 | (1) | ||
| S_TOA_AMT_FROM_WSB | VARCHAR2 | (1) | ||
| S_TOA_AMT_FROM_WSC | VARCHAR2 | (1) | ||
| S_INVESTMENT_NETWORTH | VARCHAR2 | (1) | ||
| S_BUSI_FARM_NETWORTH | VARCHAR2 | (1) | ||
| S_CASH_SAVINGS | VARCHAR2 | (1) | ||
| VA_MONTHS | VARCHAR2 | (1) | ||
| VA_AMOUNT | VARCHAR2 | (1) | ||
| STUD_DOB_BEFORE_DATE | VARCHAR2 | (1) | ||
| DEG_BEYOND_BACHELOR | VARCHAR2 | (1) | ||
| S_MARRIED | VARCHAR2 | (1) | ||
| S_HAVE_CHILDREN | VARCHAR2 | (1) | ||
| LEGAL_DEPENDANTS | VARCHAR2 | (1) | ||
| ORPHAN_WARD_OF_COURT | VARCHAR2 | (1) | ||
| S_VETERAN | VARCHAR2 | (1) | ||
| P_MARITAL_STATUS | VARCHAR2 | (1) | ||
| FATHER_SSN | VARCHAR2 | (1) | ||
| F_LAST_NAME | VARCHAR2 | (1) | ||
| MOTHER_SSN | VARCHAR2 | (1) | ||
| M_LAST_NAME | VARCHAR2 | (1) | ||
| P_NUM_FAMILY_MEMBER | VARCHAR2 | (1) | ||
| P_NUM_IN_COLLEGE | VARCHAR2 | (1) | ||
| P_STATE_LEGAL_RESIDENCE | VARCHAR2 | (1) | ||
| P_STATE_LEGAL_RES_BEFORE_DT | VARCHAR2 | (1) | ||
| P_LEGAL_RES_DATE | VARCHAR2 | (1) | ||
| AGE_OLDER_PARENT | VARCHAR2 | (1) | ||
| P_TAX_RETURN_STATUS | VARCHAR2 | (1) | ||
| P_TYPE_TAX_RETURN | VARCHAR2 | (1) | ||
| P_ELIG_1040AEZ | VARCHAR2 | (1) | ||
| P_ADJUSTED_GROSS_INCOME | VARCHAR2 | (1) | ||
| P_TAXES_PAID | VARCHAR2 | (1) | ||
| P_EXEMPTIONS | VARCHAR2 | (1) | ||
| F_INCOME_WORK | VARCHAR2 | (1) | ||
| M_INCOME_WORK | VARCHAR2 | (1) | ||
| P_INCOME_WSA | VARCHAR2 | (1) | ||
| P_INCOME_WSB | VARCHAR2 | (1) | ||
| P_INCOME_WSC | VARCHAR2 | (1) | ||
| P_INVESTMENT_NETWORTH | VARCHAR2 | (1) | ||
| P_BUSINESS_NETWORTH | VARCHAR2 | (1) | ||
| P_CASH_SAVING | VARCHAR2 | (1) | ||
| S_NUM_FAMILY_MEMBERS | VARCHAR2 | (1) | ||
| S_NUM_IN_COLLEGE | VARCHAR2 | (1) | ||
| FIRST_COLLEGE | VARCHAR2 | (1) | ||
| FIRST_HOUSE_PLAN | VARCHAR2 | (1) | ||
| SECOND_COLLEGE | VARCHAR2 | (1) | ||
| SECOND_HOUSE_PLAN | VARCHAR2 | (1) | ||
| THIRD_COLLEGE | VARCHAR2 | (1) | ||
| THIRD_HOUSE_PLAN | VARCHAR2 | (1) | ||
| FOURTH_COLLEGE | VARCHAR2 | (1) | ||
| FOURTH_HOUSE_PLAN | VARCHAR2 | (1) | ||
| FIFTH_COLLEGE | VARCHAR2 | (1) | ||
| FIFTH_HOUSE_PLAN | VARCHAR2 | (1) | ||
| SIXTH_COLLEGE | VARCHAR2 | (1) | ||
| SIXTH_HOUSE_PLAN | VARCHAR2 | (1) | ||
| DATE_APP_COMPLETED | VARCHAR2 | (1) | ||
| SIGNED_BY | VARCHAR2 | (1) | ||
| PREPARER_SSN | VARCHAR2 | (1) | ||
| PREPARER_EMP_ID_NUMBER | VARCHAR2 | (1) | ||
| PREPARER_SIGN | VARCHAR2 | (1) | ||
| TRANSACTION_RECEIPT_DATE | VARCHAR2 | (1) | ||
| DEPENDENCY_OVERRIDE_IND | VARCHAR2 | (1) | ||
| FAA_FEDRAL_SCHL_CODE | VARCHAR2 | (1) | ||
| FAA_ADJUSTMENT | VARCHAR2 | (1) | ||
| SSN_NAME_CHANGE | VARCHAR2 | (1) | ||
| INPUT_RECORD_TYPE | VARCHAR2 | (1) | ||
| SERIAL_NUMBER | VARCHAR2 | (1) | ||
| EARLY_ANALYSIS_FLAG | VARCHAR2 | (1) | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT BASE_ID
, TRANSACTION_NUM
, CURRENT_SSN
, LAST_NAME
, FIRST_NAME
, MIDDLE_INITIAL
, PERM_MAIL_ADD
, PERM_CITY
, PERM_STATE
, PERM_ZIP_CODE
, DATE_OF_BIRTH
, PHONE_NUMBER
, DRIVER_LICENSE_NUM
, DRIVER_LICENSE_STATE
, CITIZENSHIP_STATUS
, ALIEN_REG_NUMBER
, S_MARITAL_STATUS
, S_MARITAL_STATUS_DATE
, SUMM_ENRL_STATUS
, FALL_ENRL_STATUS
, WINTER_ENRL_STATUS
, SPRING_ENRL_STATUS
, SUMM2_ENRL_STATUS
, FATHERS_HIGHEST_EDU_LEVEL
, MOTHERS_HIGHEST_EDU_LEVEL
, S_STATE_LEGAL_RESIDENCE
, LEGAL_RESIDENCE_BEFORE_DATE
, S_LEGAL_RESD_DATE
, SS_R_U_MALE
, SELECTIVE_SERVICE_REG
, DEGREE_CERTIFICATION
, GRADE_LEVEL_IN_COLLEGE
, HIGH_SCHOOL_DIPLOMA_GED
, FIRST_BACHELOR_DEG_BY_DATE
, INTEREST_IN_STUD_LOAN
, INTEREST_IN_STUD_EMPLOYMENT
, DRUG_OFFENCE_CONVICTION
, S_TAX_RETURN_STATUS
, S_TYPE_TAX_RETURN
, S_ELIG_1040EZ
, S_ADJUSTED_GROSS_INCOME
, S_FED_TAXES_PAID
, S_EXEMPTIONS
, S_INCOME_FROM_WORK
, SPOUSE_INCOME_FROM_WORK
, S_TOA_AMT_FROM_WSA
, S_TOA_AMT_FROM_WSB
, S_TOA_AMT_FROM_WSC
, S_INVESTMENT_NETWORTH
, S_BUSI_FARM_NETWORTH
, S_CASH_SAVINGS
, VA_MONTHS
, VA_AMOUNT
, STUD_DOB_BEFORE_DATE
, DEG_BEYOND_BACHELOR
, S_MARRIED
, S_HAVE_CHILDREN
, LEGAL_DEPENDANTS
, ORPHAN_WARD_OF_COURT
, S_VETERAN
, P_MARITAL_STATUS
, FATHER_SSN
, F_LAST_NAME
, MOTHER_SSN
, M_LAST_NAME
, P_NUM_FAMILY_MEMBER
, P_NUM_IN_COLLEGE
, P_STATE_LEGAL_RESIDENCE
, P_STATE_LEGAL_RES_BEFORE_DT
, P_LEGAL_RES_DATE
, AGE_OLDER_PARENT
, P_TAX_RETURN_STATUS
, P_TYPE_TAX_RETURN
, P_ELIG_1040AEZ
, P_ADJUSTED_GROSS_INCOME
, P_TAXES_PAID
, P_EXEMPTIONS
, F_INCOME_WORK
, M_INCOME_WORK
, P_INCOME_WSA
, P_INCOME_WSB
, P_INCOME_WSC
, P_INVESTMENT_NETWORTH
, P_BUSINESS_NETWORTH
, P_CASH_SAVING
, S_NUM_FAMILY_MEMBERS
, S_NUM_IN_COLLEGE
, FIRST_COLLEGE
, FIRST_HOUSE_PLAN
, SECOND_COLLEGE
, SECOND_HOUSE_PLAN
, THIRD_COLLEGE
, THIRD_HOUSE_PLAN
, FOURTH_COLLEGE
, FOURTH_HOUSE_PLAN
, FIFTH_COLLEGE
, FIFTH_HOUSE_PLAN
, SIXTH_COLLEGE
, SIXTH_HOUSE_PLAN
, DATE_APP_COMPLETED
, SIGNED_BY
, PREPARER_SSN
, PREPARER_EMP_ID_NUMBER
, PREPARER_SIGN
, TRANSACTION_RECEIPT_DATE
, DEPENDENCY_OVERRIDE_IND
, FAA_FEDRAL_SCHL_CODE
, FAA_ADJUSTMENT
, SSN_NAME_CHANGE
, INPUT_RECORD_TYPE
, SERIAL_NUMBER
, EARLY_ANALYSIS_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGF.IGF_AP_ISIR_UPD_FLAG_OLD;
IGF.IGF_AP_ISIR_UPD_FLAG_OLD does not reference any database object
IGF.IGF_AP_ISIR_UPD_FLAG_OLD is referenced by following:
APPS
IGF_AP_ISIR_UPD_FLAG_OLD
|
|
|
|