VIEW: HR.HR_DM_TABLES#

Source

View Text - Preformatted

select TABLE_ID TABLE_ID, TABLE_NAME TABLE_NAME, UPLOAD_TABLE_NAME UPLOAD_TABLE_NAME, TABLE_ALIAS TABLE_ALIAS, DATETRACK DATETRACK, APPLICATION APPLICATION, PARTICIPANT PARTICIPANT, DERIVE_SQL_SOURCE_TABLES DERIVE_SQL_SOURCE_TABLES, DERIVE_SQL_CALC_RANGES DERIVE_SQL_CALC_RANGES, DERIVE_SQL_DELETE_SOURCE DERIVE_SQL_DELETE_SOURCE, DERIVE_SQL_DOWNLOAD_ADD DERIVE_SQL_DOWNLOAD_ADD, DERIVE_SQL_DOWNLOAD_FULL DERIVE_SQL_DOWNLOAD_FULL, DERIVE_SQL_CHK_SOURCE_TABLES DERIVE_SQL_CHK_SOURCE_TABLES, DERIVE_SQL_CHK_ROW_EXISTS DERIVE_SQL_CHK_ROW_EXISTS, SURROGATE_PK_COLUMN_NAME SURROGATE_PK_COLUMN_NAME, TAB_DELETE TAB_DELETE, LOADER_NAME LOADER_NAME, LOADER_CONC_PROGRAM LOADER_CONC_PROGRAM, LOADER_CONFIG_FILE LOADER_CONFIG_FILE, LOADER_APPLICATION LOADER_APPLICATION, SHORT_NAME SHORT_NAME, USE_DISTINCT_DOWNLOAD USE_DISTINCT_DOWNLOAD, LAST_GENERATED_DATE LAST_GENERATED_DATE, GENERATOR_VERSION GENERATOR_VERSION, WHO_LINK_ALIAS WHO_LINK_ALIAS, GLOBAL_DATA GLOBAL_DATA, ALWAYS_CHECK_ROW ALWAYS_CHECK_ROW, SEQUENCE_NAME SEQUENCE_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID from "HR"."HR_DM_TABLES"

View Text - HTML Formatted

SELECT TABLE_ID TABLE_ID
, TABLE_NAME TABLE_NAME
, UPLOAD_TABLE_NAME UPLOAD_TABLE_NAME
, TABLE_ALIAS TABLE_ALIAS
, DATETRACK DATETRACK
, APPLICATION APPLICATION
, PARTICIPANT PARTICIPANT
, DERIVE_SQL_SOURCE_TABLES DERIVE_SQL_SOURCE_TABLES
, DERIVE_SQL_CALC_RANGES DERIVE_SQL_CALC_RANGES
, DERIVE_SQL_DELETE_SOURCE DERIVE_SQL_DELETE_SOURCE
, DERIVE_SQL_DOWNLOAD_ADD DERIVE_SQL_DOWNLOAD_ADD
, DERIVE_SQL_DOWNLOAD_FULL DERIVE_SQL_DOWNLOAD_FULL
, DERIVE_SQL_CHK_SOURCE_TABLES DERIVE_SQL_CHK_SOURCE_TABLES
, DERIVE_SQL_CHK_ROW_EXISTS DERIVE_SQL_CHK_ROW_EXISTS
, SURROGATE_PK_COLUMN_NAME SURROGATE_PK_COLUMN_NAME
, TAB_DELETE TAB_DELETE
, LOADER_NAME LOADER_NAME
, LOADER_CONC_PROGRAM LOADER_CONC_PROGRAM
, LOADER_CONFIG_FILE LOADER_CONFIG_FILE
, LOADER_APPLICATION LOADER_APPLICATION
, SHORT_NAME SHORT_NAME
, USE_DISTINCT_DOWNLOAD USE_DISTINCT_DOWNLOAD
, LAST_GENERATED_DATE LAST_GENERATED_DATE
, GENERATOR_VERSION GENERATOR_VERSION
, WHO_LINK_ALIAS WHO_LINK_ALIAS
, GLOBAL_DATA GLOBAL_DATA
, ALWAYS_CHECK_ROW ALWAYS_CHECK_ROW
, SEQUENCE_NAME SEQUENCE_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "HR"."HR_DM_TABLES"