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: CN.CN_XREF_TBL

Object Details

Object Name:	CN_XREF_TBL
Object Type:	TABLE
Owner:	CN
FND Design Data:	CN.CN_XREF_TBL
Subobject Name:
Status:	VALID

CN_XREF_TBL is a cross-reference table to integrate PSFT-HRMS with OIC.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: CN_XREF_TBL_PK

HASH_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CN_XREF_TBL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	HASH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
HASH_ID	NUMBER		Yes	Hash key for lookup records
INTEGRATION_PROCESS_ID	VARCHAR2	(40)	Yes	Indication of source process; VALUE: PeopleSoft, etc.
SETID	VARCHAR2	(40)		Setid in PeopleSoft
ORIGINAL_ID	VARCHAR2	(40)		ID in source process
EFFDT	DATE			Effective Date of record in source process
EFFSEQ	NUMBER			Effective sequence number in PeopleSoft
OID	NUMBER			ID in Oracle Resource Manager
O_NUMBER	VARCHAR2	(40)		Oracle Number in Resource Manager
OBJECT_TYPE	VARCHAR2	(40)		Object type of the record as in source process
OBJECT_VERSION_NUMBER	NUMBER			Object version number in Oracle Resource Manager

Query Text

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


SELECT HASH_ID
,      INTEGRATION_PROCESS_ID
,      SETID
,      ORIGINAL_ID
,      EFFDT
,      EFFSEQ
,      OID
,      O_NUMBER
,      OBJECT_TYPE
,      OBJECT_VERSION_NUMBER
FROM CN.CN_XREF_TBL;

Dependencies

[top of page]

CN.CN_XREF_TBL does not reference any database object

CN.CN_XREF_TBL is referenced by following:

APPS: CN_XREF_TBL