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

Object Details

Object Name:	PQP_EXT_CROSS_PERSON_RECORDS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQP.PQP_EXT_CROSS_PERSON_RECORDS
Subobject Name:
Status:	VALID

This table holds information such as national identifier and processing status of person records used by Teachers Pension Extract Process.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQP_EXT_CROSS_PERSON_RECS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	RECORD_TYPE NATIONAL_IDENTIFIER

Columns

Name	Datatype	Length	Mandatory	Comments
RECORD_TYPE	VARCHAR2	(1)	Yes	Identifies the type of record, M for master and X for others.
BUSINESS_GROUP_ID	NUMBER	(15)		Business group id.
PERSON_ID	NUMBER	(15)		Person id
NATIONAL_IDENTIFIER	VARCHAR2	(30)		National Identifier
ASSIGNMENT_ID	NUMBER	(15)		Assignment ID
EFFECTIVE_START_DATE	DATE			Effective Start Date
EFFECTIVE_END_DATE	DATE			Effective End Date
PROCESSING_STATUS	VARCHAR2	(1)		The processing status of the record, C for completed, U for updated.
REQUEST_ID	NUMBER	(15)		The concurrent requests ID
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column
OBJECT_VERSION_NUMBER	NUMBER		Yes	System generated version of row. Increments by one with each update.
EXT_DFN_ID	NUMBER	(15)		Extract Definition Id
LEA_NUMBER	VARCHAR2	(3)		LEA Number

Query Text

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


SELECT RECORD_TYPE
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      NATIONAL_IDENTIFIER
,      ASSIGNMENT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PROCESSING_STATUS
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      EXT_DFN_ID
,      LEA_NUMBER
FROM HR.PQP_EXT_CROSS_PERSON_RECORDS;

Dependencies

[top of page]

HR.PQP_EXT_CROSS_PERSON_RECORDS does not reference any database object

HR.PQP_EXT_CROSS_PERSON_RECORDS is referenced by following:

APPS: PQP_EXT_CROSS_PERSON_RECORDS; PQP_EXT_CROSS_PERSON_RECOR_WHO
PUBLIC: PQP_EXT_CROSS_PERSON_RECORDS