[Home] [Help] [Dependency Information]
Object Name: | HR_DM_TABLES# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TABLE_ID | NUMBER | (15) | Yes | |
TABLE_NAME | VARCHAR2 | (30) | ||
UPLOAD_TABLE_NAME | VARCHAR2 | (30) | ||
TABLE_ALIAS | VARCHAR2 | (4) | ||
DATETRACK | VARCHAR2 | (1) | ||
APPLICATION | VARCHAR2 | (1) | ||
PARTICIPANT | VARCHAR2 | (1) | ||
DERIVE_SQL_SOURCE_TABLES | VARCHAR2 | (2000) | ||
DERIVE_SQL_CALC_RANGES | VARCHAR2 | (2000) | ||
DERIVE_SQL_DELETE_SOURCE | VARCHAR2 | (2000) | ||
DERIVE_SQL_DOWNLOAD_ADD | VARCHAR2 | (2000) | ||
DERIVE_SQL_DOWNLOAD_FULL | VARCHAR2 | (2000) | ||
DERIVE_SQL_CHK_SOURCE_TABLES | VARCHAR2 | (2000) | ||
DERIVE_SQL_CHK_ROW_EXISTS | VARCHAR2 | (2000) | ||
SURROGATE_PK_COLUMN_NAME | VARCHAR2 | (240) | ||
TAB_DELETE | VARCHAR2 | (1) | ||
LOADER_NAME | VARCHAR2 | (30) | ||
LOADER_CONC_PROGRAM | VARCHAR2 | (30) | ||
LOADER_CONFIG_FILE | VARCHAR2 | (30) | ||
LOADER_APPLICATION | VARCHAR2 | (50) | ||
SHORT_NAME | VARCHAR2 | (23) | ||
USE_DISTINCT_DOWNLOAD | VARCHAR2 | (1) | ||
LAST_GENERATED_DATE | DATE | |||
GENERATOR_VERSION | VARCHAR2 | (2000) | ||
WHO_LINK_ALIAS | VARCHAR2 | (4) | ||
GLOBAL_DATA | VARCHAR2 | (1) | Yes | |
ALWAYS_CHECK_ROW | VARCHAR2 | (1) | ||
SEQUENCE_NAME | VARCHAR2 | (30) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
SECURITY_GROUP_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT TABLE_ID
, TABLE_NAME
, UPLOAD_TABLE_NAME
, TABLE_ALIAS
, DATETRACK
, APPLICATION
, PARTICIPANT
, DERIVE_SQL_SOURCE_TABLES
, DERIVE_SQL_CALC_RANGES
, DERIVE_SQL_DELETE_SOURCE
, DERIVE_SQL_DOWNLOAD_ADD
, DERIVE_SQL_DOWNLOAD_FULL
, DERIVE_SQL_CHK_SOURCE_TABLES
, DERIVE_SQL_CHK_ROW_EXISTS
, SURROGATE_PK_COLUMN_NAME
, TAB_DELETE
, LOADER_NAME
, LOADER_CONC_PROGRAM
, LOADER_CONFIG_FILE
, LOADER_APPLICATION
, SHORT_NAME
, USE_DISTINCT_DOWNLOAD
, LAST_GENERATED_DATE
, GENERATOR_VERSION
, WHO_LINK_ALIAS
, GLOBAL_DATA
, ALWAYS_CHECK_ROW
, SEQUENCE_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, SECURITY_GROUP_ID
FROM HR.HR_DM_TABLES#;
|
|
|