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

TABLE: IGS.IGS_FI_ELM_RANGE

Object Details
Object Name: IGS_FI_ELM_RANGE
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_FI_ELM_RANGE
Subobject Name:
Status: VALID


IGS_FI_ELM_RANGE describes ranges applied to elements derived from charge methods for the purpose of determining fee assessment rates.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_FI_ELM_RANGE_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnER_ID
IGS_FI_ELM_RANGE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFEE_CAT
ColumnFEE_CAL_TYPE
ColumnFEE_CI_SEQUENCE_NUMBER
ColumnFEE_TYPE
Columns
Name Datatype Length Mandatory Comments
ER_ID NUMBER (9) Yes Unique system generated element range ID
FEE_TYPE VARCHAR2 (10) Yes Describes the fee types used for the purpose of applying fees and charges. A fee type may be used with many fee categories, permitting a single system wide fee definition to be used. For example, contribution, guild.
FEE_CAL_TYPE VARCHAR2 (10) Yes Calendar type with calendar category fee
FEE_CI_SEQUENCE_NUMBER NUMBER (6) Yes Uniquely identifies the calendar instance
S_RELATION_TYPE VARCHAR2 (10) Yes Describes the system relation type to that the elements range belongs.
RANGE_NUMBER NUMBER (6) Yes Number that uniquely identifies the element range record
FEE_CAT VARCHAR2 (10)
Describes the fee categories applicable to enrolled students. The purpose of the fee category is to identify the distinct fee assessment groups assigned fee type liabilities.
LOWER_RANGE NUMBER (7)
Describes the lower range value in a fee assessment element range record. The value is inclusive and can be left unspecified if an upper range value is entered. Element range records cannot overlap.
UPPER_RANGE NUMBER (7)
Describes the upper range value in a fee assessment element range record. The value is inclusive and can be left unspecified if a lower range value is recorded. Element range records cannot overlap.
S_CHG_METHOD_TYPE VARCHAR2 (30)
This is optional field. If left blank, the element range record defaults to the charge method entered at either the fee type calendar instance level, or the fee category instance level, as appropriate. Alternatively a flatrate override charge method can be specified for the element range record.
LOGICAL_DELETE_DT DATE

Contains the date and time the elements range record was logically deleted.
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
REQUEST_ID NUMBER (15)
Request identifier of last concurrent program to update this record.
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE DATE

Last update date of this record by a concurrent program
Query Text

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


SELECT ER_ID
,      FEE_TYPE
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      S_RELATION_TYPE
,      RANGE_NUMBER
,      FEE_CAT
,      LOWER_RANGE
,      UPPER_RANGE
,      S_CHG_METHOD_TYPE
,      LOGICAL_DELETE_DT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_FI_ELM_RANGE;

Dependencies

[top of page]

IGS.IGS_FI_ELM_RANGE does not reference any database object

IGS.IGS_FI_ELM_RANGE is referenced by following:

SchemaAPPS
SynonymIGS_FI_ELM_RANGE