GL_MERGED_CHILD_RANGES_GT
This table is used for internal processing only.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
VALUE_SET_ID | NUMBER | 18 | Yes | Value set defining column. | |
PARENT_VALUE | VARCHAR2 | 25 | Yes | Parent segment value. | |
CHILD_VALUE_LOW | VARCHAR2 | 25 | Yes | Child segment low range value. | |
CHILD_VALUE_HIGH | VARCHAR2 | 25 | Yes | Child segment high range value. | |
EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
EFFECTIVE_END_DATE | DATE | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
GL_MERGED_CHILD_RANGES_GT_N1 | Non Unique | VALUE_SET_ID, PARENT_VALUE |