[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| 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.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
TABLE_IDTABLE_NAME| 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
|
| 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 |
|---|
| 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. |
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;
HR.HR_DM_TABLES does not reference any database object
HR.HR_DM_TABLES is referenced by following:
HR
HR_DM_TABLES#
|
|
|
|