eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.HR_DM_TABLES

Object Details

Object Name:	HR_DM_TABLES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_DM_TABLES
Subobject Name:
Status:	VALID

This entity contains a HRMS table listing that will be processed by the data migrator. This entity will also be used to hold the AOL loader information. It also contains information whether the table in question is :
Date Tracked.
Used for holding program, plan , participant data.
Used by one of the Selective modes of migration.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Primary Key: HR_DM_TABLES_PK

TABLE_ID

Unique Key: HR_DM_TABLES_UK1

TABLE_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_DM_TABLES_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	TABLE_ID
HR_DM_TABLES_UK1	NORMAL	UNIQUE	APPS_TS_INTERFACE	TABLE_NAME

Foreign Keys

Table	Foreign Table	Foreign Key Column
HR_DM_HIERARCHIES	HR_DM_TABLES	HR_DM_HIERARCHIES TABLE_ID
HR_DM_HIERARCHIES	HR_DM_TABLES	HR_DM_HIERARCHIES PARENT_TABLE_ID
HR_DM_LOADER_PARAMS	HR_DM_TABLES	HR_DM_LOADER_PARAMS TABLE_ID
HR_DM_TABLE_GROUPINGS	HR_DM_TABLES	HR_DM_TABLE_GROUPINGS TABLE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TABLE_ID	NUMBER	(15)	Yes	System-generated primary key column.
TABLE_NAME	VARCHAR2	(30)		Name of the table.
UPLOAD_TABLE_NAME	VARCHAR2	(30)		Name of the table as used by the TUPS. If the value is NULL then the TABLE_NAME is used.
TABLE_ALIAS	VARCHAR2	(4)		The cursor alias for the table.
DATETRACK	VARCHAR2	(1)		A flag used to indicate if the table is data tracked, Y, or not data tracked, N.
APPLICATION	VARCHAR2	(1)		A flag used to indicate if the table contains application data, Y, or not, N.
PARTICIPANT	VARCHAR2	(1)		A flag used to indicate if the table contains participant data, Y, or not, N.
DERIVE_SQL_SOURCE_TABLES	VARCHAR2	(2000)		The source tables for constructing the from clause for the derive SQL statements in the TDS.
DERIVE_SQL_CALC_RANGES	VARCHAR2	(2000)		The where clause of the select statement for calculating ranges.
DERIVE_SQL_DELETE_SOURCE	VARCHAR2	(2000)		The where clause of the select statement for deleting from the source database.
DERIVE_SQL_DOWNLOAD_ADD	VARCHAR2	(2000)		The where clause of the select statement for additive migrations.
DERIVE_SQL_DOWNLOAD_FULL	VARCHAR2	(2000)		The where clause of the select statement for full migrations.
DERIVE_SQL_CHK_SOURCE_TABLES	VARCHAR2	(2000)		The source tables for the FROM clause for checking if a row exists in the destination database.
DERIVE_SQL_CHK_ROW_EXISTS	VARCHAR2	(2000)		The where clause of the select statement for checking if a row exists in the destination database
SURROGATE_PK_COLUMN_NAME	VARCHAR2	(240)		Surrogate primary key column name for use in data tracked deletes.
TAB_DELETE	VARCHAR2	(1)		A flag used to indicate if the table is to be deleted, Y, or not, N.
LOADER_NAME	VARCHAR2	(30)		The description of the loader used for migration of AOL data..
LOADER_CONC_PROGRAM	VARCHAR2	(30)		The name of the loader concurrent program
LOADER_CONFIG_FILE	VARCHAR2	(30)		The name of the loader configuration file used for migration of AOL data.
LOADER_APPLICATION	VARCHAR2	(50)		The application short name for the loader used for migration of AOL data.
SHORT_NAME	VARCHAR2	(23)		A short form of the table name for use in dynamic SQL.
USE_DISTINCT_DOWNLOAD	VARCHAR2	(1)		A flag used to enforce the use of distinct in the select clause used during the download.
LAST_GENERATED_DATE	DATE			The date of the last successful generation of the TDS/TUDS packages for this table.
GENERATOR_VERSION	VARCHAR2	(2000)		The version details of the main generator, TDS and TUPS packages are stored to enable regeneration of all TDS/TUPS when the generator is modified.
WHO_LINK_ALIAS	VARCHAR2	(4)		The alias of the table which contains the last update date information where the current table does not have an explicit last update date (ie no WHO columns).
GLOBAL_DATA	VARCHAR2	(1)	Yes	A Y indicates that this business group is not striped by business group and thus contain global data. These tables will be migrated in full.
ALWAYS_CHECK_ROW	VARCHAR2	(1)		A Y indicates that the TUPS should always check if a row exists in the destination database.
SEQUENCE_NAME	VARCHAR2	(30)		The sequence to be used to generate a new value for the primary key if a row is to be inserted but the id value used in the source database already exists. If this value is not null then a check will always be made to see if the id value has previously been used.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
SECURITY_GROUP_ID	NUMBER	(15)		Foreign Key to FND_SECURITY_GROUPS.

Query Text

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;

Dependencies

[top of page]

HR.HR_DM_TABLES does not reference any database object

HR.HR_DM_TABLES is referenced by following:

APPS: HR_DM_TABLES; HR_DM_TABLES_WHO
PUBLIC: HR_DM_TABLES