[Home] [Help] [Dependency Information]
Object Name: | HRI_DBI_WMV_CHANGES_EVTS_TMP |
---|---|
Object Type: | TABLE |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
HRI.HRI_DBI_WMV_CHANGES_EVTS_TMP is a global temporary table. The current session is able see data that it 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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_DBI_WMV_CHGS_EVTS_TMP_N1 | NORMAL | NONUNIQUE |
CHANGE_TYPE
ASSIGNMENT_ID EFFECTIVE_DATE | |
HRI_DBI_WMV_CHGS_EVTS_TMP_N2 | NORMAL | NONUNIQUE |
PERSON_ID
CUR_SUPERVISOR_ID PREV_SUPERVISOR_ID EFFECTIVE_DATE | |
HRI_DBI_WMV_CHGS_EVTS_TMP_N3 | NORMAL | NONUNIQUE |
CHANGE_TYPE
EFFECTIVE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_ID | NUMBER | Yes | ||
PERSON_ID | NUMBER | Yes | ||
CUR_SUPERVISOR_ID | NUMBER | Yes | ||
PREV_SUPERVISOR_ID | NUMBER | Yes | ||
EFFECTIVE_DATE | DATE | Yes | ||
CHANGE_TYPE | VARCHAR2 | (20) | Yes | |
CHANGE_REASON | VARCHAR2 | (30) | ||
JOB_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ID
, PERSON_ID
, CUR_SUPERVISOR_ID
, PREV_SUPERVISOR_ID
, EFFECTIVE_DATE
, CHANGE_TYPE
, CHANGE_REASON
, JOB_ID
FROM HRI.HRI_DBI_WMV_CHANGES_EVTS_TMP;
HRI.HRI_DBI_WMV_CHANGES_EVTS_TMP does not reference any database object
HRI.HRI_DBI_WMV_CHANGES_EVTS_TMP is referenced by following:
|
|
|