DBA Data[Home] [Help] [Dependency Information]

TABLE: IGF.IGF_AW_FI_INC_LEVEL

Object Details
Object Name: IGF_AW_FI_INC_LEVEL
Object Type: TABLE
Owner: IGF
FND Design Data: TableIGF.IGF_AW_FI_INC_LEVEL
Subobject Name:
Status: VALID


This entity holds information to setup the various Income Levels for a specific category ID, which is a combination of Award year, FISAP section, Dependency Status and Class Standing. This range information is used in the FISAP reports.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_AW_FI_INC_LEVEL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRANGE_ID
IGF_AW_FI_INC_LEVEL_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCATEGORY_ID
ColumnMINVALUE
Columns
Name Datatype Length Mandatory Comments
CATEGORY_ID NUMBER (15) Yes The category would consist of an Award Year,Class Standing, Dependency Status, FISAP Section. This is a unique identifier for a category.
RANGE_ID NUMBER (15) Yes Sequence Generated Unique Identifier for an Income Range.
MINVALUE NUMBER (13) Yes Lower value of FISAP Income Range.
MAXVALUE NUMBER (13) Yes Upper value of FISAP Income Range.
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)
Standard WHO column.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CATEGORY_ID
,      RANGE_ID
,      MINVALUE
,      MAXVALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_AW_FI_INC_LEVEL;

Dependencies

[top of page]

IGF.IGF_AW_FI_INC_LEVEL does not reference any database object

IGF.IGF_AW_FI_INC_LEVEL is referenced by following:

SchemaAPPS
SynonymIGF_AW_FI_INC_LEVEL