[Home] [Help] [Dependency Information]
Object Name: | GHR_COMPLAINTS2# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPLAINT_ID | NUMBER | (15) | Yes | |
COMPLAINANT_PERSON_ID | NUMBER | (15) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | ||
DOCKET_NUMBER | VARCHAR2 | (50) | ||
STAGE | VARCHAR2 | (30) | ||
CLASS_FLAG | VARCHAR2 | (3) | ||
MIXED_FLAG | VARCHAR2 | (3) | ||
CONSOLIDATED_FLAG | VARCHAR2 | (3) | ||
REMAND_FLAG | VARCHAR2 | (3) | ||
ACTIVE_FLAG | VARCHAR2 | (3) | ||
INFORMATION_INQUIRY | DATE | |||
PCOM_INIT | DATE | |||
ALLEG_INCIDENT | DATE | |||
ALLEG_DISCRIM_ORG_NAME | VARCHAR2 | (30) | ||
RR_LTR_DATE | DATE | |||
RR_LTR_RECVD | DATE | |||
PRE_COM_ELEC | VARCHAR2 | (30) | ||
CLASS_AGENT_FLAG | VARCHAR2 | (3) | ||
PRE_COM_DESC | VARCHAR2 | (500) | ||
COUNSELOR_ASG | DATE | |||
INIT_COUNSELOR_INTERVIEW | DATE | |||
ANONYMITY_REQUESTED | VARCHAR2 | (3) | ||
COUNSEL_EXT_LTR | DATE | |||
TRADITIONAL_COUNSEL_OUTCOME | VARCHAR2 | (30) | ||
FINAL_INTERVIEW | DATE | |||
NOTICE_RTF_RECVD | DATE | |||
PRECOM_CLOSED | DATE | |||
PRECOM_CLOSURE_NATURE | VARCHAR2 | (30) | ||
COUNSELOR_RPT_SUB | DATE | |||
HR_OFFICE_NAME | VARCHAR2 | (30) | ||
EEO_OFFICE_NAME | VARCHAR2 | (30) | ||
SERVICED_ORG_NAME | VARCHAR2 | (30) | ||
FORMAL_COM_FILED | DATE | |||
ACK_LTR | DATE | |||
CLARIFICATION_LTR_DATE | DATE | |||
CLARIFICATION_RESPONSE_RECVD | DATE | |||
FORWARDED_LEGAL_REVIEW | DATE | |||
RETURNED_FROM_LEGAL | DATE | |||
LETTER_TYPE | VARCHAR2 | (30) | ||
LETTER_DATE | DATE | |||
LETTER_RECVD | DATE | |||
INVESTIGATION_SOURCE | VARCHAR2 | (30) | ||
AGENCY_INVESTIGATOR_REQ | DATE | |||
INVESTIGATOR_RECVD_REQ | DATE | |||
INVESTIGATOR_ASG | DATE | |||
INVESTIGATION_START | DATE | |||
INVESTIGATION_END | DATE | |||
INVESTIGATION_EXTENDED | DATE | |||
INVEST_EXTENSION_DESC | VARCHAR2 | (500) | ||
AGENCY_RECVD_ROI | DATE | |||
COMREP_RECVD_ROI | DATE | |||
OPTIONS_LTR_DATE | DATE | |||
COMREP_RECVD_OPT_LTR | DATE | |||
COMREP_OPT_LTR_RESPONSE | VARCHAR2 | (30) | ||
RESOLUTION_OFFER | DATE | |||
COMREP_RESOL_OFFER_RECVD | DATE | |||
COMREP_RESOL_OFFER_RESPONSE | DATE | |||
COMREP_RESOL_OFFER_DESC | VARCHAR2 | (250) | ||
RESOL_OFFER_SIGNED | DATE | |||
RESOL_OFFER_DESC | VARCHAR2 | (2000) | ||
HEARING_REQ | DATE | |||
HEARING_SOURCE | VARCHAR2 | (30) | ||
AGENCY_NOTIFIED_HEARING | DATE | |||
AGENCY_FILES_FORWARDED_EEOC | DATE | |||
EEOC_HEARING_DOCKET_NUM | VARCHAR2 | (50) | ||
HEARING_COMPLETE | DATE | |||
AJ_MERIT_DECISION_DATE | DATE | |||
AGENCY_RECVD_AJ_MERIT_DEC | DATE | |||
AJ_MERIT_DECISION | VARCHAR2 | (30) | ||
AJ_CA_DECISION_DATE | DATE | |||
AGENCY_RECVD_AJ_CA_DEC | DATE | |||
AJ_CA_DECISION | VARCHAR2 | (30) | ||
FAD_REQUESTED | DATE | |||
FAD_SOURCE | VARCHAR2 | (30) | ||
MERIT_FAD | VARCHAR2 | (3) | ||
ATTORNEY_FEES_FAD | VARCHAR2 | (3) | ||
COMP_DAMAGES_FAD | VARCHAR2 | (3) | ||
NON_COMPLIANCE_FAD | VARCHAR2 | (3) | ||
FAD_REQ_RECVD_EEO_OFFICE | DATE | |||
FAD_REQ_FORWD_TO_AGENCY | DATE | |||
AGENCY_RECVD_REQUEST | DATE | |||
FAD_DUE | DATE | |||
FAD_DATE | DATE | |||
FAD_DECISION | VARCHAR2 | (30) | ||
FAD_FORWD_TO_COMREP | DATE | |||
FAD_RECVD_BY_COMREP | DATE | |||
FAD_IMP_LTR_FORWD_TO_ORG | DATE | |||
FAD_DECISION_FORWD_LEGAL | DATE | |||
FAD_DECISION_RECVD_LEGAL | DATE | |||
FA_SOURCE | VARCHAR2 | (30) | ||
FINAL_ACTION_DUE | DATE | |||
FINAL_ACT_FORWD_COMREP | DATE | |||
FINAL_ACT_RECVD_COMREP | DATE | |||
FINAL_ACTION_DECISION_DATE | DATE | |||
FINAL_ACTION_DECISION | VARCHAR2 | (30) | ||
FA_IMP_LTR_FORWD_TO_ORG | DATE | |||
FA_DECISION_FORWD_LEGAL | DATE | |||
FA_DECISION_RECVD_LEGAL | DATE | |||
CIVIL_ACTION_FILED | DATE | |||
AGENCY_NOTIF_OF_CIVIL_ACTION | DATE | |||
AGENCY_CLOSURE_CONFIRMED | DATE | |||
CONSOLIDATED_COMPLAINT_ID | NUMBER | (15) | ||
CONSOLIDATED | DATE | |||
STAGE_OF_CONSOLIDATION | VARCHAR2 | (30) | ||
COMREP_NOTIF_CONSOLIDATION | DATE | |||
CONSOLIDATION_DESC | VARCHAR2 | (500) | ||
COMPLAINT_CLOSED | DATE | |||
COMPLAINT_CLOSED_DESC | VARCHAR2 | (2000) | ||
FILED_FORMAL_CLASS | DATE | |||
FORWD_EEOC | DATE | |||
AGENCY_BRIEF_EEOC | DATE | |||
AJ_CERT_DECISION_DATE | DATE | |||
AJ_CERT_DECISION_RECVD | DATE | |||
AJ_CERT_DECISION | VARCHAR2 | (30) | ||
CLASS_MEMBERS_NOTIFIED | DATE | |||
NUMBER_OF_COMPLAINTANTS | NUMBER | (9) | ||
CLASS_HEARING | DATE | |||
AJ_DEC | DATE | |||
AGENCY_RECVD_AJ_DEC | 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) | ||
AJ_DECISION | VARCHAR2 | (30) | ||
NATURE_OF_CLOSURE | VARCHAR2 | (30) | ||
AGENCY_CODE | VARCHAR2 | (4) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE16 | VARCHAR2 | (150) | ||
ATTRIBUTE17 | VARCHAR2 | (150) | ||
ATTRIBUTE18 | VARCHAR2 | (150) | ||
ATTRIBUTE19 | VARCHAR2 | (150) | ||
ATTRIBUTE20 | VARCHAR2 | (150) | ||
ATTRIBUTE21 | VARCHAR2 | (150) | ||
ATTRIBUTE22 | VARCHAR2 | (150) | ||
ATTRIBUTE23 | VARCHAR2 | (150) | ||
ATTRIBUTE24 | VARCHAR2 | (150) | ||
ATTRIBUTE25 | VARCHAR2 | (150) | ||
ATTRIBUTE26 | VARCHAR2 | (150) | ||
ATTRIBUTE27 | VARCHAR2 | (150) | ||
ATTRIBUTE28 | VARCHAR2 | (150) | ||
ATTRIBUTE29 | VARCHAR2 | (150) | ||
ATTRIBUTE30 | VARCHAR2 | (150) | ||
ALLEG_DISCRIM_ORG_ID | NUMBER | (15) | ||
HR_OFFICE_ORG_ID | NUMBER | (15) | ||
EEO_OFFICE_ORG_ID | VARCHAR2 | (240) | ||
SERVICED_ORG_ID | VARCHAR2 | (240) | ||
RECORD_RECEIVED | DATE | |||
AUDITED_BY | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT COMPLAINT_ID
, COMPLAINANT_PERSON_ID
, BUSINESS_GROUP_ID
, DOCKET_NUMBER
, STAGE
, CLASS_FLAG
, MIXED_FLAG
, CONSOLIDATED_FLAG
, REMAND_FLAG
, ACTIVE_FLAG
, INFORMATION_INQUIRY
, PCOM_INIT
, ALLEG_INCIDENT
, ALLEG_DISCRIM_ORG_NAME
, RR_LTR_DATE
, RR_LTR_RECVD
, PRE_COM_ELEC
, CLASS_AGENT_FLAG
, PRE_COM_DESC
, COUNSELOR_ASG
, INIT_COUNSELOR_INTERVIEW
, ANONYMITY_REQUESTED
, COUNSEL_EXT_LTR
, TRADITIONAL_COUNSEL_OUTCOME
, FINAL_INTERVIEW
, NOTICE_RTF_RECVD
, PRECOM_CLOSED
, PRECOM_CLOSURE_NATURE
, COUNSELOR_RPT_SUB
, HR_OFFICE_NAME
, EEO_OFFICE_NAME
, SERVICED_ORG_NAME
, FORMAL_COM_FILED
, ACK_LTR
, CLARIFICATION_LTR_DATE
, CLARIFICATION_RESPONSE_RECVD
, FORWARDED_LEGAL_REVIEW
, RETURNED_FROM_LEGAL
, LETTER_TYPE
, LETTER_DATE
, LETTER_RECVD
, INVESTIGATION_SOURCE
, AGENCY_INVESTIGATOR_REQ
, INVESTIGATOR_RECVD_REQ
, INVESTIGATOR_ASG
, INVESTIGATION_START
, INVESTIGATION_END
, INVESTIGATION_EXTENDED
, INVEST_EXTENSION_DESC
, AGENCY_RECVD_ROI
, COMREP_RECVD_ROI
, OPTIONS_LTR_DATE
, COMREP_RECVD_OPT_LTR
, COMREP_OPT_LTR_RESPONSE
, RESOLUTION_OFFER
, COMREP_RESOL_OFFER_RECVD
, COMREP_RESOL_OFFER_RESPONSE
, COMREP_RESOL_OFFER_DESC
, RESOL_OFFER_SIGNED
, RESOL_OFFER_DESC
, HEARING_REQ
, HEARING_SOURCE
, AGENCY_NOTIFIED_HEARING
, AGENCY_FILES_FORWARDED_EEOC
, EEOC_HEARING_DOCKET_NUM
, HEARING_COMPLETE
, AJ_MERIT_DECISION_DATE
, AGENCY_RECVD_AJ_MERIT_DEC
, AJ_MERIT_DECISION
, AJ_CA_DECISION_DATE
, AGENCY_RECVD_AJ_CA_DEC
, AJ_CA_DECISION
, FAD_REQUESTED
, FAD_SOURCE
, MERIT_FAD
, ATTORNEY_FEES_FAD
, COMP_DAMAGES_FAD
, NON_COMPLIANCE_FAD
, FAD_REQ_RECVD_EEO_OFFICE
, FAD_REQ_FORWD_TO_AGENCY
, AGENCY_RECVD_REQUEST
, FAD_DUE
, FAD_DATE
, FAD_DECISION
, FAD_FORWD_TO_COMREP
, FAD_RECVD_BY_COMREP
, FAD_IMP_LTR_FORWD_TO_ORG
, FAD_DECISION_FORWD_LEGAL
, FAD_DECISION_RECVD_LEGAL
, FA_SOURCE
, FINAL_ACTION_DUE
, FINAL_ACT_FORWD_COMREP
, FINAL_ACT_RECVD_COMREP
, FINAL_ACTION_DECISION_DATE
, FINAL_ACTION_DECISION
, FA_IMP_LTR_FORWD_TO_ORG
, FA_DECISION_FORWD_LEGAL
, FA_DECISION_RECVD_LEGAL
, CIVIL_ACTION_FILED
, AGENCY_NOTIF_OF_CIVIL_ACTION
, AGENCY_CLOSURE_CONFIRMED
, CONSOLIDATED_COMPLAINT_ID
, CONSOLIDATED
, STAGE_OF_CONSOLIDATION
, COMREP_NOTIF_CONSOLIDATION
, CONSOLIDATION_DESC
, COMPLAINT_CLOSED
, COMPLAINT_CLOSED_DESC
, FILED_FORMAL_CLASS
, FORWD_EEOC
, AGENCY_BRIEF_EEOC
, AJ_CERT_DECISION_DATE
, AJ_CERT_DECISION_RECVD
, AJ_CERT_DECISION
, CLASS_MEMBERS_NOTIFIED
, NUMBER_OF_COMPLAINTANTS
, CLASS_HEARING
, AJ_DEC
, AGENCY_RECVD_AJ_DEC
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, AJ_DECISION
, NATURE_OF_CLOSURE
, AGENCY_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ALLEG_DISCRIM_ORG_ID
, HR_OFFICE_ORG_ID
, EEO_OFFICE_ORG_ID
, SERVICED_ORG_ID
, RECORD_RECEIVED
, AUDITED_BY
FROM HR.GHR_COMPLAINTS2#;
|
|
|