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.

[Home] [Help]

VIEW: HR.GHR_PA_INTERFACE_ERR_DTLS#

Source

View Text - Preformatted


select PA_INTERFACE_ERR_DTL_ID PA_INTERFACE_ERR_DTL_ID, EXT_REQUEST_ID EXT_REQUEST_ID, RESULT_ID RESULT_ID, RESULT_DTL_ID RESULT_DTL_ID, RECORD_ID RECORD_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID, PA_REQUEST_ID PA_REQUEST_ID, ALT_PA_REQUEST_ID ALT_PA_REQUEST_ID, ERR_SSN_NO ERR_SSN_NO, ERR_AGENCY ERR_AGENCY, ERR_EMP_OFF ERR_EMP_OFF, ERR_DEPT_CODE ERR_DEPT_CODE, ERR_DOC_TYPE ERR_DOC_TYPE, ERR_PAY_PERIOD ERR_PAY_PERIOD, ERR_AUTH_DT ERR_AUTH_DT, NAT_ACT_1ST_3_POS NAT_ACT_1ST_3_POS, NAT_ACT_2ND_3_POS NAT_ACT_2ND_3_POS, ERR_EFF_DT ERR_EFF_DT, ERR_BATCH_NO ERR_BATCH_NO, ERR_OPER_CODE ERR_OPER_CODE, ERROR_CODE ERROR_CODE, ERROR_MSG ERROR_MSG, ERROR_ELEMENT_NAME ERROR_ELEMENT_NAME, ERROR_ELEM_CONTENT ERROR_ELEM_CONTENT, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE from "HR"."GHR_PA_INTERFACE_ERR_DTLS"

View Text - HTML Formatted

SELECT PA_INTERFACE_ERR_DTL_ID PA_INTERFACE_ERR_DTL_ID
, EXT_REQUEST_ID EXT_REQUEST_ID
, RESULT_ID RESULT_ID
, RESULT_DTL_ID RESULT_DTL_ID
, RECORD_ID RECORD_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, PA_REQUEST_ID PA_REQUEST_ID
, ALT_PA_REQUEST_ID ALT_PA_REQUEST_ID
, ERR_SSN_NO ERR_SSN_NO
, ERR_AGENCY ERR_AGENCY
, ERR_EMP_OFF ERR_EMP_OFF
, ERR_DEPT_CODE ERR_DEPT_CODE
, ERR_DOC_TYPE ERR_DOC_TYPE
, ERR_PAY_PERIOD ERR_PAY_PERIOD
, ERR_AUTH_DT ERR_AUTH_DT
, NAT_ACT_1ST_3_POS NAT_ACT_1ST_3_POS
, NAT_ACT_2ND_3_POS NAT_ACT_2ND_3_POS
, ERR_EFF_DT ERR_EFF_DT
, ERR_BATCH_NO ERR_BATCH_NO
, ERR_OPER_CODE ERR_OPER_CODE
, ERROR_CODE ERROR_CODE
, ERROR_MSG ERROR_MSG
, ERROR_ELEMENT_NAME ERROR_ELEMENT_NAME
, ERROR_ELEM_CONTENT ERROR_ELEM_CONTENT
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "HR"."GHR_PA_INTERFACE_ERR_DTLS"