[Home] [Help] [Dependency Information]
Object Name: | GHR_COMPL_APPEALS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPL_APPEAL_ID | NUMBER | (15) | Yes | |
COMPLAINT_ID | NUMBER | (15) | Yes | |
APPEAL_DATE | DATE | |||
APPEALED_TO | VARCHAR2 | (30) | ||
REASON_FOR_APPEAL | VARCHAR2 | (30) | ||
SOURCE_DECISION_DATE | DATE | |||
DOCKET_NUM | VARCHAR2 | (50) | ||
ORG_NOTIFIED_OF_APPEAL | DATE | |||
AGENCY_RECVD_REQ_FOR_FILES | DATE | |||
FILES_DUE | DATE | |||
FILES_FORWD | DATE | |||
AGCY_RECVD_APPELLANT_BRIEF | DATE | |||
AGENCY_BRIEF_DUE | DATE | |||
APPELLANT_BRIEF_FORWD_ORG | DATE | |||
ORG_FORWD_BRIEF_TO_AGENCY | DATE | |||
AGENCY_BRIEF_FORWD | DATE | |||
DECISION_DATE | DATE | |||
DEC_RECVD_BY_AGENCY | DATE | |||
DECISION | VARCHAR2 | (30) | ||
DEC_FORWD_TO_ORG | DATE | |||
AGENCY_RFR_SUSPENSE | DATE | |||
REQUEST_FOR_RFR | DATE | |||
RFR_DOCKET_NUM | VARCHAR2 | (50) | ||
RFR_REQUESTED_BY | VARCHAR2 | (30) | ||
AGENCY_RFR_DUE | DATE | |||
RFR_FORWD_TO_ORG | DATE | |||
ORG_FORWD_RFR_TO_AGENCY | DATE | |||
AGENCY_FORWD_RFR_OFO | DATE | |||
RFR_DECISION | VARCHAR2 | (30) | ||
RFR_DECISION_DATE | DATE | |||
AGENCY_RECVD_RFR_DEC | DATE | |||
RFR_DECISION_FORWD_TO_ORG | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT COMPL_APPEAL_ID
, COMPLAINT_ID
, APPEAL_DATE
, APPEALED_TO
, REASON_FOR_APPEAL
, SOURCE_DECISION_DATE
, DOCKET_NUM
, ORG_NOTIFIED_OF_APPEAL
, AGENCY_RECVD_REQ_FOR_FILES
, FILES_DUE
, FILES_FORWD
, AGCY_RECVD_APPELLANT_BRIEF
, AGENCY_BRIEF_DUE
, APPELLANT_BRIEF_FORWD_ORG
, ORG_FORWD_BRIEF_TO_AGENCY
, AGENCY_BRIEF_FORWD
, DECISION_DATE
, DEC_RECVD_BY_AGENCY
, DECISION
, DEC_FORWD_TO_ORG
, AGENCY_RFR_SUSPENSE
, REQUEST_FOR_RFR
, RFR_DOCKET_NUM
, RFR_REQUESTED_BY
, AGENCY_RFR_DUE
, RFR_FORWD_TO_ORG
, ORG_FORWD_RFR_TO_AGENCY
, AGENCY_FORWD_RFR_OFO
, RFR_DECISION
, RFR_DECISION_DATE
, AGENCY_RECVD_RFR_DEC
, RFR_DECISION_FORWD_TO_ORG
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM HR.GHR_COMPL_APPEALS#;
|
|
|