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_POS_INTERFACE_ERR_DTLS#

Source

View Text - Preformatted


select POS_INTERFACE_ERR_DTL_ID POS_INTERFACE_ERR_DTL_ID, REQUEST_ID REQUEST_ID, RESULT_ID RESULT_ID, RESULT_DTL_ID RESULT_DTL_ID, RECORD_ID RECORD_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, POSITION_ID POSITION_ID, SUSP_USER_ID SUSP_USER_ID, SUSP_MAST_INDV SUSP_MAST_INDV, SUSP_FUNCTION_CD SUSP_FUNCTION_CD, SUSP_DEPT SUSP_DEPT, SUSP_AGCY SUSP_AGCY, SUSP_POI SUSP_POI, SUSP_MAST_REC_NUM SUSP_MAST_REC_NUM, SUSP_GRD SUSP_GRD, SUSP_INDV_POS_NUM SUSP_INDV_POS_NUM, SUSP_INCUM_SSN SUSP_INCUM_SSN, SUSP_OBLIG_SSN SUSP_OBLIG_SSN, SUSP_PAY_PERIOD SUSP_PAY_PERIOD, SUSP_PASS_NUM SUSP_PASS_NUM, SUSP_ERROR_MSG_NUM SUSP_ERROR_MSG_NUM, SUSP_ERROR_MSG SUSP_ERROR_MSG, SUSP_ELEM_NAME_NUM SUSP_ELEM_NAME_NUM, SUSP_ELEM_NAME SUSP_ELEM_NAME, SUSP_DATA_FIELD SUSP_DATA_FIELD, SUSP_SERV_AGCY SUSP_SERV_AGCY, 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_POS_INTERFACE_ERR_DTLS"

View Text - HTML Formatted

SELECT POS_INTERFACE_ERR_DTL_ID POS_INTERFACE_ERR_DTL_ID
, REQUEST_ID REQUEST_ID
, RESULT_ID RESULT_ID
, RESULT_DTL_ID RESULT_DTL_ID
, RECORD_ID RECORD_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, POSITION_ID POSITION_ID
, SUSP_USER_ID SUSP_USER_ID
, SUSP_MAST_INDV SUSP_MAST_INDV
, SUSP_FUNCTION_CD SUSP_FUNCTION_CD
, SUSP_DEPT SUSP_DEPT
, SUSP_AGCY SUSP_AGCY
, SUSP_POI SUSP_POI
, SUSP_MAST_REC_NUM SUSP_MAST_REC_NUM
, SUSP_GRD SUSP_GRD
, SUSP_INDV_POS_NUM SUSP_INDV_POS_NUM
, SUSP_INCUM_SSN SUSP_INCUM_SSN
, SUSP_OBLIG_SSN SUSP_OBLIG_SSN
, SUSP_PAY_PERIOD SUSP_PAY_PERIOD
, SUSP_PASS_NUM SUSP_PASS_NUM
, SUSP_ERROR_MSG_NUM SUSP_ERROR_MSG_NUM
, SUSP_ERROR_MSG SUSP_ERROR_MSG
, SUSP_ELEM_NAME_NUM SUSP_ELEM_NAME_NUM
, SUSP_ELEM_NAME SUSP_ELEM_NAME
, SUSP_DATA_FIELD SUSP_DATA_FIELD
, SUSP_SERV_AGCY SUSP_SERV_AGCY
, 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_POS_INTERFACE_ERR_DTLS"