[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_INAR_DTL_ALL_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_INAR_DTL_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_ARCHIVE
|
 INAR_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INAR_ID | NUMBER | (15) | Yes | |
| FA_BASE_ID | NUMBER | (15) | ||
| OVERWRITE_ISIR_FC | VARCHAR2 | (30) | ||
| ISIR_ID | VARCHAR2 | (15) | ||
| DETERMINE_NEED | VARCHAR2 | (30) | ||
| INAR_DATE | DATE | |||
| FM_FC | NUMBER | (15) | ||
| S_AGI | NUMBER | (9) | ||
| P_STATE | NUMBER | (9) | ||
| S_TAX_PAID | NUMBER | (9) | ||
| S_EXM_CLAIMED | NUMBER | (9) | ||
| S_EAR_INC_CREDIT | NUMBER | (9) | ||
| S_INC_WORK | NUMBER | (9) | ||
| S_SPOUSE_INC | NUMBER | (9) | ||
| S_OTHER_UNTAX_INC | NUMBER | (9) | ||
| S_TITLE_IV_INC | NUMBER | (9) | ||
| S_CASH_SAV | NUMBER | (9) | ||
| S_INV_NET_WORTH | NUMBER | (9) | ||
| S_BUS_NET_WORTH | NUMBER | (9) | ||
| S_INV_FARM_NET_WORTH | NUMBER | (9) | ||
| S_VET_BEN_AMT | NUMBER | (9) | ||
| S_TOT_AMT_WSA | NUMBER | (9) | ||
| S_TOT_AMT_WSB | NUMBER | (9) | ||
| S_STATE | VARCHAR2 | (30) | ||
| S_TAX_FILER | VARCHAR2 | (10) | ||
| S_IN_COLLEGE | NUMBER | (3) | ||
| S_FAMILY_SIZE | NUMBER | (3) | ||
| S_COLL_SIZE | NUMBER | (3) | ||
| S_YEAR | VARCHAR2 | (10) | ||
| P_IN_COLLEGE | NUMBER | (3) | ||
| P_TAX_FILER | VARCHAR2 | (10) | ||
| P_P_IN_COLLEGE | NUMBER | (3) | ||
| P_O_IN_COLLEGE | NUMBER | (3) | ||
| S_MARR_STATUS | VARCHAR2 | (1) | ||
| S_TOT_AMT_WSC | NUMBER | (9) | ||
| P_AGI | NUMBER | (9) | ||
| P_TAX_PAID | NUMBER | (9) | ||
| P_EXM_CLAIMED | NUMBER | (9) | ||
| P_EAR_INC_CREDIT | NUMBER | (9) | ||
| P_DAD_INC | NUMBER | (9) | ||
| P_MOM_INC | NUMBER | (9) | ||
| P_OTHER_UNTAX_INC | NUMBER | (9) | ||
| P_TITLE_IV_INC | NUMBER | (9) | ||
| P_CASH_SAV | NUMBER | (9) | ||
| P_INV_NET_WORTH | NUMBER | (9) | ||
| P_BUS_NET_WORTH | NUMBER | (9) | ||
| P_INV_FARM_NET_WORTH | NUMBER | (9) | ||
| P_INC_WSA | NUMBER | (9) | ||
| P_INC_WSB | NUMBER | (9) | ||
| P_INC_WSC | NUMBER | (9) | ||
| 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) | ||
| REQUEST_ID | NUMBER | (15) | ||
| PROGRAM_ID | NUMBER | (15) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| ORG_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT INAR_ID
, FA_BASE_ID
, OVERWRITE_ISIR_FC
, ISIR_ID
, DETERMINE_NEED
, INAR_DATE
, FM_FC
, S_AGI
, P_STATE
, S_TAX_PAID
, S_EXM_CLAIMED
, S_EAR_INC_CREDIT
, S_INC_WORK
, S_SPOUSE_INC
, S_OTHER_UNTAX_INC
, S_TITLE_IV_INC
, S_CASH_SAV
, S_INV_NET_WORTH
, S_BUS_NET_WORTH
, S_INV_FARM_NET_WORTH
, S_VET_BEN_AMT
, S_TOT_AMT_WSA
, S_TOT_AMT_WSB
, S_STATE
, S_TAX_FILER
, S_IN_COLLEGE
, S_FAMILY_SIZE
, S_COLL_SIZE
, S_YEAR
, P_IN_COLLEGE
, P_TAX_FILER
, P_P_IN_COLLEGE
, P_O_IN_COLLEGE
, S_MARR_STATUS
, S_TOT_AMT_WSC
, P_AGI
, P_TAX_PAID
, P_EXM_CLAIMED
, P_EAR_INC_CREDIT
, P_DAD_INC
, P_MOM_INC
, P_OTHER_UNTAX_INC
, P_TITLE_IV_INC
, P_CASH_SAV
, P_INV_NET_WORTH
, P_BUS_NET_WORTH
, P_INV_FARM_NET_WORTH
, P_INC_WSA
, P_INC_WSB
, P_INC_WSC
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
FROM IGF.IGF_AP_INAR_DTL_ALL_OLD;
IGF.IGF_AP_INAR_DTL_ALL_OLD does not reference any database object
IGF.IGF_AP_INAR_DTL_ALL_OLD is referenced by following:
APPS
IGF_AP_INAR_DTL_ALL_OLD
|
|
|
|