[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_SUB_ELM_RNG |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_FI_SUB_ELM_RNG |
Subobject Name: | |
Status: | VALID |
This table describes the sub ranges applied to elements derived from charge methods for the purpose of determining fee assessment rates.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_FI_SUB_ELM_RNG_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | SUB_ER_ID |
IGS_FI_SUB_ELM_RNG_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ER_ID
SUB_RANGE_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUB_ER_ID | NUMBER | Yes | Unique system generated sub element range Identifier | |
ER_ID | NUMBER | Yes | Unique system generated Global Element Range Identifier. Identifies the Element Range for which Sub Element Ranges have been defined. | |
SUB_RANGE_NUM | NUMBER | (15) | Yes | Number that uniquely identifies the sub element range record |
SUB_LOWER_RANGE | NUMBER | (7) | Describes the lower range value in a fee assessment sub element range record. The value is inclusive and can be left unspecified if an upper range value is entered. Sub Element range records cannot overlap. | |
SUB_UPPER_RANGE | NUMBER | (7) | Describes the upper range value in a fee assessment sub element range record. The value is inclusive and can be left unspecified if a lower range value is recorded. Sub Element range records cannot overlap. | |
SUB_CHG_METHOD_CODE | VARCHAR2 | (30) | This is an optional field. A flat rate override charge method can be specified for the sub element range record. | |
LOGICAL_DELETE_DATE | DATE | Contains the date and time the sub elements range record was logically deleted. | ||
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT SUB_ER_ID
, ER_ID
, SUB_RANGE_NUM
, SUB_LOWER_RANGE
, SUB_UPPER_RANGE
, SUB_CHG_METHOD_CODE
, LOGICAL_DELETE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM IGS.IGS_FI_SUB_ELM_RNG;
IGS.IGS_FI_SUB_ELM_RNG does not reference any database object
IGS.IGS_FI_SUB_ELM_RNG is referenced by following:
|
|
|