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

Source

View Text - Preformatted


select COMPL_CA_HEADER_ID COMPL_CA_HEADER_ID, COMPLAINT_ID COMPLAINT_ID, CA_SOURCE CA_SOURCE, LAST_COMPLIANCE_REPORT LAST_COMPLIANCE_REPORT, COMPLIANCE_CLOSED COMPLIANCE_CLOSED, COMPL_DOCKET_NUMBER COMPL_DOCKET_NUMBER, APPEAL_DOCKET_NUMBER APPEAL_DOCKET_NUMBER, PFE_DOCKET_NUMBER PFE_DOCKET_NUMBER, PFE_RECEIVED PFE_RECEIVED, AGENCY_BRIEF_PFE_DUE AGENCY_BRIEF_PFE_DUE, AGENCY_BRIEF_PFE_DATE AGENCY_BRIEF_PFE_DATE, DECISION_PFE_DATE DECISION_PFE_DATE, DECISION_PFE DECISION_PFE, AGENCY_RECVD_PFE_DECISION AGENCY_RECVD_PFE_DECISION, AGENCY_PFE_BRIEF_FORWD AGENCY_PFE_BRIEF_FORWD, AGENCY_NOTIFIED_NONCOM AGENCY_NOTIFIED_NONCOM, COMREP_NONCOM_REQ COMREP_NONCOM_REQ, EEO_OFF_REQ_DATA_FROM_ORG EEO_OFF_REQ_DATA_FROM_ORG, ORG_FORWD_DATA_TO_EEO_OFF ORG_FORWD_DATA_TO_EEO_OFF, DEC_IMPLEMENTED DEC_IMPLEMENTED, COMPLAINT_REINSTATED COMPLAINT_REINSTATED, STAGE_COMPLAINT_REINSTATED STAGE_COMPLAINT_REINSTATED, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "HR"."GHR_COMPL_CA_HEADERS"

View Text - HTML Formatted

SELECT COMPL_CA_HEADER_ID COMPL_CA_HEADER_ID
, COMPLAINT_ID COMPLAINT_ID
, CA_SOURCE CA_SOURCE
, LAST_COMPLIANCE_REPORT LAST_COMPLIANCE_REPORT
, COMPLIANCE_CLOSED COMPLIANCE_CLOSED
, COMPL_DOCKET_NUMBER COMPL_DOCKET_NUMBER
, APPEAL_DOCKET_NUMBER APPEAL_DOCKET_NUMBER
, PFE_DOCKET_NUMBER PFE_DOCKET_NUMBER
, PFE_RECEIVED PFE_RECEIVED
, AGENCY_BRIEF_PFE_DUE AGENCY_BRIEF_PFE_DUE
, AGENCY_BRIEF_PFE_DATE AGENCY_BRIEF_PFE_DATE
, DECISION_PFE_DATE DECISION_PFE_DATE
, DECISION_PFE DECISION_PFE
, AGENCY_RECVD_PFE_DECISION AGENCY_RECVD_PFE_DECISION
, AGENCY_PFE_BRIEF_FORWD AGENCY_PFE_BRIEF_FORWD
, AGENCY_NOTIFIED_NONCOM AGENCY_NOTIFIED_NONCOM
, COMREP_NONCOM_REQ COMREP_NONCOM_REQ
, EEO_OFF_REQ_DATA_FROM_ORG EEO_OFF_REQ_DATA_FROM_ORG
, ORG_FORWD_DATA_TO_EEO_OFF ORG_FORWD_DATA_TO_EEO_OFF
, DEC_IMPLEMENTED DEC_IMPLEMENTED
, COMPLAINT_REINSTATED COMPLAINT_REINSTATED
, STAGE_COMPLAINT_REINSTATED STAGE_COMPLAINT_REINSTATED
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "HR"."GHR_COMPL_CA_HEADERS"