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 |