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_LINES

Object Details

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

PER_PTU_DFF_MAPPING_LINES 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 stores the Segment Mapping Details of a DFF Migration.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
MAPPING_LINE_ID	NUMBER	(15)	Yes	System generated primary key from PER_PTU_DFF_MAPPING_LINES_S.
MAPPING_HEADER_ID	NUMBER	(15)		Foreign key to PER_PTU_DFF_MAPPING_HEADERS.
PER_DFF_ATTRIBUTE	VARCHAR2	(30)		Descriptive flexfield column name of the PER_PEOPLE DFF.
PER_END_USER_COLUMN_NAME	VARCHAR2	(30)		End user coulmn name of the Descriptive flexfield column.
PTU_DFF_CONTEXT_FIELD_CODE	VARCHAR2	(30)		The Context field value defined for the PER_PERSON_TYPE_USAGES DFF.
PTU_DFF_CONTEXT_FIELD_DESC	VARCHAR2	(30)		The Context name.
PTU_DFF_ATTRIBUTE	VARCHAR2	(30)		Descriptive flexfield column name of the PER_PERSON_TYPE_USAGES DFF.
PTU_END_USER_COLUMN_NAME	VARCHAR2	(30)		End user coulmn name of the Descriptive flexfield column.
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_LINE_ID
,      MAPPING_HEADER_ID
,      PER_DFF_ATTRIBUTE
,      PER_END_USER_COLUMN_NAME
,      PTU_DFF_CONTEXT_FIELD_CODE
,      PTU_DFF_CONTEXT_FIELD_DESC
,      PTU_DFF_ATTRIBUTE
,      PTU_END_USER_COLUMN_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HR.PER_PTU_DFF_MAPPING_LINES;

Dependencies

[top of page]

HR.PER_PTU_DFF_MAPPING_LINES does not reference any database object

HR.PER_PTU_DFF_MAPPING_LINES is referenced by following:

HR: PER_PTU_DFF_MAPPING_LINES#