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

Object Details

Object Name:	GHR_POS_INTERFACE_ERR_DTLS
Object Type:	TABLE
Owner:	HR
FND Design Data:	GHR.GHR_POS_INTERFACE_ERR_DTLS
Subobject Name:
Status:	VALID

GHR_POS_INTERFACE_ERR_DTLS stores the error details during NFC Position interface generation.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GHR_POS_INTERFACE_ERR_DTLS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	POS_INTERFACE_ERR_DTL_ID
GHR_POS_INTERFACE_ERR_DTLS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSITION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
POS_INTERFACE_ERR_DTL_ID	NUMBER	(15)	Yes	Primary key generated from sequence GHR_POS_INTERFACE_ERR_DTLS_S
REQUEST_ID	NUMBER	(15)		Request ID
RESULT_ID	NUMBER	(15)		Result ID
RESULT_DTL_ID	NUMBER	(15)		Result Detail ID
RECORD_ID	NUMBER	(15)		Record ID
BUSINESS_GROUP_ID	NUMBER	(15)		Business Group ID
POSITION_ID	NUMBER	(15)		Position ID
SUSP_USER_ID	NUMBER	(15)		Susp User ID
SUSP_MAST_INDV	VARCHAR2	(4)		Susp Mast Ind
SUSP_FUNCTION_CD	VARCHAR2	(10)		Susp Function Code
SUSP_DEPT	VARCHAR2	(2)		Susp Department
SUSP_AGCY	VARCHAR2	(2)		Susp Agency
SUSP_POI	VARCHAR2	(4)		Susp Personnel Office ID
SUSP_MAST_REC_NUM	VARCHAR2	(6)		Susp Master Record Number
SUSP_GRD	VARCHAR2	(2)		Susp Grade
SUSP_INDV_POS_NUM	VARCHAR2	(8)		Susp Individual Position Number
SUSP_INCUM_SSN	VARCHAR2	(9)		Susp Incum SSN
SUSP_OBLIG_SSN	VARCHAR2	(9)		Susp Oblig SSN
SUSP_PAY_PERIOD	VARCHAR2	(2)		Susp Pay Period
SUSP_PASS_NUM	VARCHAR2	(2)		Susp Pass Number
SUSP_ERROR_MSG_NUM	VARCHAR2	(3)		Susp Error Message Number
SUSP_ERROR_MSG	VARCHAR2	(50)		Susp Error Message
SUSP_ELEM_NAME_NUM	VARCHAR2	(3)		Susp Element Name Number
SUSP_ELEM_NAME	VARCHAR2	(3)		Susp Element Name
SUSP_DATA_FIELD	VARCHAR2	(8)		Susp Data Field
SUSP_SERV_AGCY	VARCHAR2	(2)		Susp Service Agency
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT POS_INTERFACE_ERR_DTL_ID
,      REQUEST_ID
,      RESULT_ID
,      RESULT_DTL_ID
,      RECORD_ID
,      BUSINESS_GROUP_ID
,      POSITION_ID
,      SUSP_USER_ID
,      SUSP_MAST_INDV
,      SUSP_FUNCTION_CD
,      SUSP_DEPT
,      SUSP_AGCY
,      SUSP_POI
,      SUSP_MAST_REC_NUM
,      SUSP_GRD
,      SUSP_INDV_POS_NUM
,      SUSP_INCUM_SSN
,      SUSP_OBLIG_SSN
,      SUSP_PAY_PERIOD
,      SUSP_PASS_NUM
,      SUSP_ERROR_MSG_NUM
,      SUSP_ERROR_MSG
,      SUSP_ELEM_NAME_NUM
,      SUSP_ELEM_NAME
,      SUSP_DATA_FIELD
,      SUSP_SERV_AGCY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM HR.GHR_POS_INTERFACE_ERR_DTLS;

Dependencies

[top of page]

HR.GHR_POS_INTERFACE_ERR_DTLS does not reference any database object

HR.GHR_POS_INTERFACE_ERR_DTLS is referenced by following:

HR: GHR_POS_INTERFACE_ERR_DTLS#