[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GHR_POS_INTERFACE_ERR_DTLS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | POS_INTERFACE_ERR_DTL_ID |
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 |
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;
HR.GHR_POS_INTERFACE_ERR_DTLS does not reference any database object
HR.GHR_POS_INTERFACE_ERR_DTLS is referenced by following:
|
|
|