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_DU_COLUMN_MAPPINGS

Object Details

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

This table holds the relationship between the column name used in the source object (e.g. the spreadsheet column) and the output target (e.g. the Data Pump parameter name).

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: HR_DU_COLUMN_MAPPINGS_PK

COLUMN_MAPPING_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_DU_COLUMN_MAPPINGS_PK	NORMAL	UNIQUE	APPS_TS_SEED	COLUMN_MAPPING_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COLUMN_MAPPING_ID	NUMBER	(15)	Yes	System generated primary key
API_MODULE_ID	NUMBER	(15)	Yes	Foreign Key to HR_API_MODULES.API_MODULE_ID
COLUMN_NAME	VARCHAR2	(30)	Yes	The name of the column loaded into HR_DU_UPLOAD_LINES.
MAPPED_TO_NAME	VARCHAR2	(30)		The name of the column / tag to which the column is mapped to.
MAPPING_TYPE	VARCHAR2	(1)	Yes	The output target for this mapping. This value is a lookup code of the lookup type HR_DU_MAPPING_TYPE and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES
PARENT_API_MODULE_ID	NUMBER	(15)		Holds the API_MODULE_ID identifying which API module that column is attached to.
PARENT_TABLE	VARCHAR2	(30)		Used for generic entities such as phone. The column identifies where the calling API_MODULE_ID can be stored.
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)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT COLUMN_MAPPING_ID
,      API_MODULE_ID
,      COLUMN_NAME
,      MAPPED_TO_NAME
,      MAPPING_TYPE
,      PARENT_API_MODULE_ID
,      PARENT_TABLE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SECURITY_GROUP_ID
FROM HR.HR_DU_COLUMN_MAPPINGS;

Dependencies

[top of page]

HR.HR_DU_COLUMN_MAPPINGS does not reference any database object

HR.HR_DU_COLUMN_MAPPINGS is referenced by following:

APPS: HR_DU_COLUMN_MAPPINGS; HR_DU_COLUMN_MAPPINGS_WHO
PUBLIC: HR_DU_COLUMN_MAPPINGS