[Home] [Help] [Dependency Information]
Object Name: | GHR_PA_INTERFACE_ERR_DTLS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | GHR.GHR_PA_INTERFACE_ERR_DTLS |
Subobject Name: | |
Status: | VALID |
GHR_PA_INTERFACE_ERR_DTLS stores the error details during NFC RPA interface generation.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GHR_PA_INTERFACE_ERR_DTL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | PA_INTERFACE_ERR_DTL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PA_INTERFACE_ERR_DTL_ID | NUMBER | (15) | Yes | Primary Key generated from GHR_PA_INTERFACE_ERR_DTLS_S |
EXT_REQUEST_ID | NUMBER | (15) | Extracted PA 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 | |
PERSON_ID | NUMBER | (15) | Person ID | |
ASSIGNMENT_ID | NUMBER | (15) | Assignment ID | |
PA_REQUEST_ID | NUMBER | (15) | PA Request ID | |
ALT_PA_REQUEST_ID | NUMBER | (15) | Altered PA Request ID | |
ERR_SSN_NO | VARCHAR2 | (30) | SSN Number of Errored Record | |
ERR_AGENCY | VARCHAR2 | (30) | Agency of Errored Record | |
ERR_EMP_OFF | VARCHAR2 | (30) | Employee Office of Errored Record | |
ERR_DEPT_CODE | VARCHAR2 | (30) | Department Code of Errored Record | |
ERR_DOC_TYPE | VARCHAR2 | (30) | Document Type of Errored Record | |
ERR_PAY_PERIOD | VARCHAR2 | (30) | Pay Period of Errored Record | |
ERR_AUTH_DT | VARCHAR2 | (16) | Authorised date of Errored Record | |
NAT_ACT_1ST_3_POS | VARCHAR2 | (3) | First 3 Characters of First NOA Code | |
NAT_ACT_2ND_3_POS | VARCHAR2 | (3) | First 3 Characters of Second NOA Code | |
ERR_EFF_DT | VARCHAR2 | (16) | Effective Date of Errored Record | |
ERR_BATCH_NO | VARCHAR2 | (20) | Batch Number of of Errored Record | |
ERR_OPER_CODE | VARCHAR2 | (30) | Oper. Code of Errored Record | |
ERROR_CODE | VARCHAR2 | (20) | Error Code | |
ERROR_MSG | VARCHAR2 | (50) | Error Message | |
ERROR_ELEMENT_NAME | VARCHAR2 | (30) | Element Name of Errored Record | |
ERROR_ELEM_CONTENT | VARCHAR2 | (30) | Elemenet Content of Errored Record | |
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 PA_INTERFACE_ERR_DTL_ID
, EXT_REQUEST_ID
, RESULT_ID
, RESULT_DTL_ID
, RECORD_ID
, BUSINESS_GROUP_ID
, PERSON_ID
, ASSIGNMENT_ID
, PA_REQUEST_ID
, ALT_PA_REQUEST_ID
, ERR_SSN_NO
, ERR_AGENCY
, ERR_EMP_OFF
, ERR_DEPT_CODE
, ERR_DOC_TYPE
, ERR_PAY_PERIOD
, ERR_AUTH_DT
, NAT_ACT_1ST_3_POS
, NAT_ACT_2ND_3_POS
, ERR_EFF_DT
, ERR_BATCH_NO
, ERR_OPER_CODE
, ERROR_CODE
, ERROR_MSG
, ERROR_ELEMENT_NAME
, ERROR_ELEM_CONTENT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM HR.GHR_PA_INTERFACE_ERR_DTLS;
HR.GHR_PA_INTERFACE_ERR_DTLS does not reference any database object
HR.GHR_PA_INTERFACE_ERR_DTLS is referenced by following:
|
|
|