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.PER_PTU_DFF_MAPPING_HEADERS

Object Details

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

PER_PTU_DFF_MAPPING_HEADERS is the table that stores DFF mapping Information for the migration process to migrate DFF data from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F. Specifically, this table is used to store the Context details of a DFF Migration.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
MAPPING_HEADER_ID	NUMBER	(15)	Yes	System generated primary key from PER_PTU_DFF_MAPPING_HEADERS_S.
PER_DFF_CONTEXT_FIELD_CODE	VARCHAR2	(30)		The Context field value defined for the PER_PEOPLE DFF.
PER_DFF_CONTEXT_FIELD_NAME	VARCHAR2	(30)		The name of the reference field for the PER_PEOPLE DFF.
PER_DFF_CONTEXT_FIELD_DESC	VARCHAR2	(240)		The Context name.
DATA_MAPPING_COMPLETE	VARCHAR2	(1)		Data mapping code Y or N.
REQUEST_ID	NUMBER	(15)		Standard Who Column.
MIGRATION_STATUS	VARCHAR2	(20)		Migration Status COMPLETE or PENDING.
CREATED_BY	NUMBER	(15)		Standard Who Column.
CREATION_DATE	DATE			Standard Who Column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column.
LAST_UPDATE_DATE	DATE			Standard Who Column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column.

Query Text

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


SELECT MAPPING_HEADER_ID
,      PER_DFF_CONTEXT_FIELD_CODE
,      PER_DFF_CONTEXT_FIELD_NAME
,      PER_DFF_CONTEXT_FIELD_DESC
,      DATA_MAPPING_COMPLETE
,      REQUEST_ID
,      MIGRATION_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HR.PER_PTU_DFF_MAPPING_HEADERS;

Dependencies

[top of page]

HR.PER_PTU_DFF_MAPPING_HEADERS does not reference any database object

HR.PER_PTU_DFF_MAPPING_HEADERS is referenced by following:

APPS: PER_PTU_DFF_MAPPING_HEADERS; PER_PTU_DFF_MAPPING_HEADER_WHO
PUBLIC: PER_PTU_DFF_MAPPING_HEADERS