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

Source

View Text - Preformatted


select COMPL_AGENCY_APPEAL_ID COMPL_AGENCY_APPEAL_ID, COMPLAINT_ID COMPLAINT_ID, APPEAL_DATE APPEAL_DATE, REASON_FOR_APPEAL REASON_FOR_APPEAL, SOURCE_DECISION_DATE SOURCE_DECISION_DATE, DOCKET_NUM DOCKET_NUM, AGENCY_RECVD_REQ_FOR_FILES AGENCY_RECVD_REQ_FOR_FILES, FILES_DUE FILES_DUE, FILES_FORWD FILES_FORWD, AGENCY_BRIEF_DUE AGENCY_BRIEF_DUE, AGENCY_BRIEF_FORWD AGENCY_BRIEF_FORWD, AGENCY_RECVD_APPELLANT_BRIEF AGENCY_RECVD_APPELLANT_BRIEF, 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, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORG_FORWD_RFR_TO_AGENCY ORG_FORWD_RFR_TO_AGENCY, AGENCY_FORWD_RFR_OFO AGENCY_FORWD_RFR_OFO, RFR_DECISION_DATE RFR_DECISION_DATE, AGENCY_RECVD_RFR_DEC AGENCY_RECVD_RFR_DEC, RFR_DECISION_FORWD_TO_ORG RFR_DECISION_FORWD_TO_ORG, RFR_DECISION RFR_DECISION, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY from "HR"."GHR_COMPL_AGENCY_APPEALS"

View Text - HTML Formatted

SELECT COMPL_AGENCY_APPEAL_ID COMPL_AGENCY_APPEAL_ID
, COMPLAINT_ID COMPLAINT_ID
, APPEAL_DATE APPEAL_DATE
, REASON_FOR_APPEAL REASON_FOR_APPEAL
, SOURCE_DECISION_DATE SOURCE_DECISION_DATE
, DOCKET_NUM DOCKET_NUM
, AGENCY_RECVD_REQ_FOR_FILES AGENCY_RECVD_REQ_FOR_FILES
, FILES_DUE FILES_DUE
, FILES_FORWD FILES_FORWD
, AGENCY_BRIEF_DUE AGENCY_BRIEF_DUE
, AGENCY_BRIEF_FORWD AGENCY_BRIEF_FORWD
, AGENCY_RECVD_APPELLANT_BRIEF AGENCY_RECVD_APPELLANT_BRIEF
, 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
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORG_FORWD_RFR_TO_AGENCY ORG_FORWD_RFR_TO_AGENCY
, AGENCY_FORWD_RFR_OFO AGENCY_FORWD_RFR_OFO
, RFR_DECISION_DATE RFR_DECISION_DATE
, AGENCY_RECVD_RFR_DEC AGENCY_RECVD_RFR_DEC
, RFR_DECISION_FORWD_TO_ORG RFR_DECISION_FORWD_TO_ORG
, RFR_DECISION RFR_DECISION
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
FROM "HR"."GHR_COMPL_AGENCY_APPEALS"