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

Source

View Text - Preformatted


select COMPL_APPEAL_ID COMPL_APPEAL_ID, COMPLAINT_ID COMPLAINT_ID, APPEAL_DATE APPEAL_DATE, APPEALED_TO APPEALED_TO, REASON_FOR_APPEAL REASON_FOR_APPEAL, SOURCE_DECISION_DATE SOURCE_DECISION_DATE, DOCKET_NUM DOCKET_NUM, ORG_NOTIFIED_OF_APPEAL ORG_NOTIFIED_OF_APPEAL, AGENCY_RECVD_REQ_FOR_FILES AGENCY_RECVD_REQ_FOR_FILES, FILES_DUE FILES_DUE, FILES_FORWD FILES_FORWD, AGCY_RECVD_APPELLANT_BRIEF AGCY_RECVD_APPELLANT_BRIEF, AGENCY_BRIEF_DUE AGENCY_BRIEF_DUE, APPELLANT_BRIEF_FORWD_ORG APPELLANT_BRIEF_FORWD_ORG, ORG_FORWD_BRIEF_TO_AGENCY ORG_FORWD_BRIEF_TO_AGENCY, AGENCY_BRIEF_FORWD AGENCY_BRIEF_FORWD, DECISION_DATE DECISION_DATE, DEC_RECVD_BY_AGENCY DEC_RECVD_BY_AGENCY, DECISION DECISION, DEC_FORWD_TO_ORG DEC_FORWD_TO_ORG, AGENCY_RFR_SUSPENSE AGENCY_RFR_SUSPENSE, REQUEST_FOR_RFR REQUEST_FOR_RFR, RFR_DOCKET_NUM RFR_DOCKET_NUM, RFR_REQUESTED_BY RFR_REQUESTED_BY, AGENCY_RFR_DUE AGENCY_RFR_DUE, RFR_FORWD_TO_ORG RFR_FORWD_TO_ORG, ORG_FORWD_RFR_TO_AGENCY ORG_FORWD_RFR_TO_AGENCY, AGENCY_FORWD_RFR_OFO AGENCY_FORWD_RFR_OFO, RFR_DECISION RFR_DECISION, RFR_DECISION_DATE RFR_DECISION_DATE, AGENCY_RECVD_RFR_DEC AGENCY_RECVD_RFR_DEC, RFR_DECISION_FORWD_TO_ORG RFR_DECISION_FORWD_TO_ORG, 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_APPEALS"

View Text - HTML Formatted

SELECT COMPL_APPEAL_ID COMPL_APPEAL_ID
, COMPLAINT_ID COMPLAINT_ID
, APPEAL_DATE APPEAL_DATE
, APPEALED_TO APPEALED_TO
, REASON_FOR_APPEAL REASON_FOR_APPEAL
, SOURCE_DECISION_DATE SOURCE_DECISION_DATE
, DOCKET_NUM DOCKET_NUM
, ORG_NOTIFIED_OF_APPEAL ORG_NOTIFIED_OF_APPEAL
, AGENCY_RECVD_REQ_FOR_FILES AGENCY_RECVD_REQ_FOR_FILES
, FILES_DUE FILES_DUE
, FILES_FORWD FILES_FORWD
, AGCY_RECVD_APPELLANT_BRIEF AGCY_RECVD_APPELLANT_BRIEF
, AGENCY_BRIEF_DUE AGENCY_BRIEF_DUE
, APPELLANT_BRIEF_FORWD_ORG APPELLANT_BRIEF_FORWD_ORG
, ORG_FORWD_BRIEF_TO_AGENCY ORG_FORWD_BRIEF_TO_AGENCY
, AGENCY_BRIEF_FORWD AGENCY_BRIEF_FORWD
, DECISION_DATE DECISION_DATE
, DEC_RECVD_BY_AGENCY DEC_RECVD_BY_AGENCY
, DECISION DECISION
, DEC_FORWD_TO_ORG DEC_FORWD_TO_ORG
, AGENCY_RFR_SUSPENSE AGENCY_RFR_SUSPENSE
, REQUEST_FOR_RFR REQUEST_FOR_RFR
, RFR_DOCKET_NUM RFR_DOCKET_NUM
, RFR_REQUESTED_BY RFR_REQUESTED_BY
, AGENCY_RFR_DUE AGENCY_RFR_DUE
, RFR_FORWD_TO_ORG RFR_FORWD_TO_ORG
, ORG_FORWD_RFR_TO_AGENCY ORG_FORWD_RFR_TO_AGENCY
, AGENCY_FORWD_RFR_OFO AGENCY_FORWD_RFR_OFO
, RFR_DECISION RFR_DECISION
, RFR_DECISION_DATE RFR_DECISION_DATE
, AGENCY_RECVD_RFR_DEC AGENCY_RECVD_RFR_DEC
, RFR_DECISION_FORWD_TO_ORG RFR_DECISION_FORWD_TO_ORG
, 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_APPEALS"