[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:
|
|
|