HZ_TEMP_REL_GT
AR.HZ_TEMP_REL_GT is a global temporary table. The current session is able to see data that is placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Comments |
|---|---|---|---|
| DATE1 | DATE | Start date | |
| DATE2 | DATE | End date | |
| PC_FLAG | VARCHAR2 | 1 | Indicate if this is a parent node in hierarchy. 'P' for parent, 'C' for child. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| HZ_TEMP_REL_GT_N1 | Non Unique | DATE1, DATE2 |