VIEW: HR.GHR_COMPLAINTS2#

Source

View Text - Preformatted

select COMPLAINT_ID COMPLAINT_ID, COMPLAINANT_PERSON_ID COMPLAINANT_PERSON_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, DOCKET_NUMBER DOCKET_NUMBER, STAGE STAGE, CLASS_FLAG CLASS_FLAG, MIXED_FLAG MIXED_FLAG, CONSOLIDATED_FLAG CONSOLIDATED_FLAG, REMAND_FLAG REMAND_FLAG, ACTIVE_FLAG ACTIVE_FLAG, INFORMATION_INQUIRY INFORMATION_INQUIRY, PCOM_INIT PCOM_INIT, ALLEG_INCIDENT ALLEG_INCIDENT, ALLEG_DISCRIM_ORG_NAME ALLEG_DISCRIM_ORG_NAME, RR_LTR_DATE RR_LTR_DATE, RR_LTR_RECVD RR_LTR_RECVD, PRE_COM_ELEC PRE_COM_ELEC, CLASS_AGENT_FLAG CLASS_AGENT_FLAG, PRE_COM_DESC PRE_COM_DESC, COUNSELOR_ASG COUNSELOR_ASG, INIT_COUNSELOR_INTERVIEW INIT_COUNSELOR_INTERVIEW, ANONYMITY_REQUESTED ANONYMITY_REQUESTED, COUNSEL_EXT_LTR COUNSEL_EXT_LTR, TRADITIONAL_COUNSEL_OUTCOME TRADITIONAL_COUNSEL_OUTCOME, FINAL_INTERVIEW FINAL_INTERVIEW, NOTICE_RTF_RECVD NOTICE_RTF_RECVD, PRECOM_CLOSED PRECOM_CLOSED, PRECOM_CLOSURE_NATURE PRECOM_CLOSURE_NATURE, COUNSELOR_RPT_SUB COUNSELOR_RPT_SUB, HR_OFFICE_NAME HR_OFFICE_NAME, EEO_OFFICE_NAME EEO_OFFICE_NAME, SERVICED_ORG_NAME SERVICED_ORG_NAME, FORMAL_COM_FILED FORMAL_COM_FILED, ACK_LTR ACK_LTR, CLARIFICATION_LTR_DATE CLARIFICATION_LTR_DATE, CLARIFICATION_RESPONSE_RECVD CLARIFICATION_RESPONSE_RECVD, FORWARDED_LEGAL_REVIEW FORWARDED_LEGAL_REVIEW, RETURNED_FROM_LEGAL RETURNED_FROM_LEGAL, LETTER_TYPE LETTER_TYPE, LETTER_DATE LETTER_DATE, LETTER_RECVD LETTER_RECVD, INVESTIGATION_SOURCE INVESTIGATION_SOURCE, AGENCY_INVESTIGATOR_REQ AGENCY_INVESTIGATOR_REQ, INVESTIGATOR_RECVD_REQ INVESTIGATOR_RECVD_REQ, INVESTIGATOR_ASG INVESTIGATOR_ASG, INVESTIGATION_START INVESTIGATION_START, INVESTIGATION_END INVESTIGATION_END, INVESTIGATION_EXTENDED INVESTIGATION_EXTENDED, INVEST_EXTENSION_DESC INVEST_EXTENSION_DESC, AGENCY_RECVD_ROI AGENCY_RECVD_ROI, COMREP_RECVD_ROI COMREP_RECVD_ROI, OPTIONS_LTR_DATE OPTIONS_LTR_DATE, COMREP_RECVD_OPT_LTR COMREP_RECVD_OPT_LTR, COMREP_OPT_LTR_RESPONSE COMREP_OPT_LTR_RESPONSE, RESOLUTION_OFFER RESOLUTION_OFFER, COMREP_RESOL_OFFER_RECVD COMREP_RESOL_OFFER_RECVD, COMREP_RESOL_OFFER_RESPONSE COMREP_RESOL_OFFER_RESPONSE, COMREP_RESOL_OFFER_DESC COMREP_RESOL_OFFER_DESC, RESOL_OFFER_SIGNED RESOL_OFFER_SIGNED, RESOL_OFFER_DESC RESOL_OFFER_DESC, HEARING_REQ HEARING_REQ, HEARING_SOURCE HEARING_SOURCE, AGENCY_NOTIFIED_HEARING AGENCY_NOTIFIED_HEARING, AGENCY_FILES_FORWARDED_EEOC AGENCY_FILES_FORWARDED_EEOC, EEOC_HEARING_DOCKET_NUM EEOC_HEARING_DOCKET_NUM, HEARING_COMPLETE HEARING_COMPLETE, AJ_MERIT_DECISION_DATE AJ_MERIT_DECISION_DATE, AGENCY_RECVD_AJ_MERIT_DEC AGENCY_RECVD_AJ_MERIT_DEC, AJ_MERIT_DECISION AJ_MERIT_DECISION, AJ_CA_DECISION_DATE AJ_CA_DECISION_DATE, AGENCY_RECVD_AJ_CA_DEC AGENCY_RECVD_AJ_CA_DEC, AJ_CA_DECISION AJ_CA_DECISION, FAD_REQUESTED FAD_REQUESTED, FAD_SOURCE FAD_SOURCE, MERIT_FAD MERIT_FAD, ATTORNEY_FEES_FAD ATTORNEY_FEES_FAD, COMP_DAMAGES_FAD COMP_DAMAGES_FAD, NON_COMPLIANCE_FAD NON_COMPLIANCE_FAD, FAD_REQ_RECVD_EEO_OFFICE FAD_REQ_RECVD_EEO_OFFICE, FAD_REQ_FORWD_TO_AGENCY FAD_REQ_FORWD_TO_AGENCY, AGENCY_RECVD_REQUEST AGENCY_RECVD_REQUEST, FAD_DUE FAD_DUE, FAD_DATE FAD_DATE, FAD_DECISION FAD_DECISION, FAD_FORWD_TO_COMREP FAD_FORWD_TO_COMREP, FAD_RECVD_BY_COMREP FAD_RECVD_BY_COMREP, FAD_IMP_LTR_FORWD_TO_ORG FAD_IMP_LTR_FORWD_TO_ORG, FAD_DECISION_FORWD_LEGAL FAD_DECISION_FORWD_LEGAL, FAD_DECISION_RECVD_LEGAL FAD_DECISION_RECVD_LEGAL, FA_SOURCE FA_SOURCE, FINAL_ACTION_DUE FINAL_ACTION_DUE, FINAL_ACT_FORWD_COMREP FINAL_ACT_FORWD_COMREP, FINAL_ACT_RECVD_COMREP FINAL_ACT_RECVD_COMREP, FINAL_ACTION_DECISION_DATE FINAL_ACTION_DECISION_DATE, FINAL_ACTION_DECISION FINAL_ACTION_DECISION, FA_IMP_LTR_FORWD_TO_ORG FA_IMP_LTR_FORWD_TO_ORG, FA_DECISION_FORWD_LEGAL FA_DECISION_FORWD_LEGAL, FA_DECISION_RECVD_LEGAL FA_DECISION_RECVD_LEGAL, CIVIL_ACTION_FILED CIVIL_ACTION_FILED, AGENCY_NOTIF_OF_CIVIL_ACTION AGENCY_NOTIF_OF_CIVIL_ACTION, AGENCY_CLOSURE_CONFIRMED AGENCY_CLOSURE_CONFIRMED, CONSOLIDATED_COMPLAINT_ID CONSOLIDATED_COMPLAINT_ID, CONSOLIDATED CONSOLIDATED, STAGE_OF_CONSOLIDATION STAGE_OF_CONSOLIDATION, COMREP_NOTIF_CONSOLIDATION COMREP_NOTIF_CONSOLIDATION, CONSOLIDATION_DESC CONSOLIDATION_DESC, COMPLAINT_CLOSED COMPLAINT_CLOSED, COMPLAINT_CLOSED_DESC COMPLAINT_CLOSED_DESC, FILED_FORMAL_CLASS FILED_FORMAL_CLASS, FORWD_EEOC FORWD_EEOC, AGENCY_BRIEF_EEOC AGENCY_BRIEF_EEOC, AJ_CERT_DECISION_DATE AJ_CERT_DECISION_DATE, AJ_CERT_DECISION_RECVD AJ_CERT_DECISION_RECVD, AJ_CERT_DECISION AJ_CERT_DECISION, CLASS_MEMBERS_NOTIFIED CLASS_MEMBERS_NOTIFIED, NUMBER_OF_COMPLAINTANTS NUMBER_OF_COMPLAINTANTS, CLASS_HEARING CLASS_HEARING, AJ_DEC AJ_DEC, AGENCY_RECVD_AJ_DEC AGENCY_RECVD_AJ_DEC, 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, AJ_DECISION AJ_DECISION, NATURE_OF_CLOSURE NATURE_OF_CLOSURE, AGENCY_CODE AGENCY_CODE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, ALLEG_DISCRIM_ORG_ID ALLEG_DISCRIM_ORG_ID, HR_OFFICE_ORG_ID HR_OFFICE_ORG_ID, EEO_OFFICE_ORG_ID EEO_OFFICE_ORG_ID, SERVICED_ORG_ID SERVICED_ORG_ID, RECORD_RECEIVED RECORD_RECEIVED, AUDITED_BY AUDITED_BY from "HR"."GHR_COMPLAINTS2"

View Text - HTML Formatted

SELECT COMPLAINT_ID COMPLAINT_ID
, COMPLAINANT_PERSON_ID COMPLAINANT_PERSON_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DOCKET_NUMBER DOCKET_NUMBER
, STAGE STAGE
, CLASS_FLAG CLASS_FLAG
, MIXED_FLAG MIXED_FLAG
, CONSOLIDATED_FLAG CONSOLIDATED_FLAG
, REMAND_FLAG REMAND_FLAG
, ACTIVE_FLAG ACTIVE_FLAG
, INFORMATION_INQUIRY INFORMATION_INQUIRY
, PCOM_INIT PCOM_INIT
, ALLEG_INCIDENT ALLEG_INCIDENT
, ALLEG_DISCRIM_ORG_NAME ALLEG_DISCRIM_ORG_NAME
, RR_LTR_DATE RR_LTR_DATE
, RR_LTR_RECVD RR_LTR_RECVD
, PRE_COM_ELEC PRE_COM_ELEC
, CLASS_AGENT_FLAG CLASS_AGENT_FLAG
, PRE_COM_DESC PRE_COM_DESC
, COUNSELOR_ASG COUNSELOR_ASG
, INIT_COUNSELOR_INTERVIEW INIT_COUNSELOR_INTERVIEW
, ANONYMITY_REQUESTED ANONYMITY_REQUESTED
, COUNSEL_EXT_LTR COUNSEL_EXT_LTR
, TRADITIONAL_COUNSEL_OUTCOME TRADITIONAL_COUNSEL_OUTCOME
, FINAL_INTERVIEW FINAL_INTERVIEW
, NOTICE_RTF_RECVD NOTICE_RTF_RECVD
, PRECOM_CLOSED PRECOM_CLOSED
, PRECOM_CLOSURE_NATURE PRECOM_CLOSURE_NATURE
, COUNSELOR_RPT_SUB COUNSELOR_RPT_SUB
, HR_OFFICE_NAME HR_OFFICE_NAME
, EEO_OFFICE_NAME EEO_OFFICE_NAME
, SERVICED_ORG_NAME SERVICED_ORG_NAME
, FORMAL_COM_FILED FORMAL_COM_FILED
, ACK_LTR ACK_LTR
, CLARIFICATION_LTR_DATE CLARIFICATION_LTR_DATE
, CLARIFICATION_RESPONSE_RECVD CLARIFICATION_RESPONSE_RECVD
, FORWARDED_LEGAL_REVIEW FORWARDED_LEGAL_REVIEW
, RETURNED_FROM_LEGAL RETURNED_FROM_LEGAL
, LETTER_TYPE LETTER_TYPE
, LETTER_DATE LETTER_DATE
, LETTER_RECVD LETTER_RECVD
, INVESTIGATION_SOURCE INVESTIGATION_SOURCE
, AGENCY_INVESTIGATOR_REQ AGENCY_INVESTIGATOR_REQ
, INVESTIGATOR_RECVD_REQ INVESTIGATOR_RECVD_REQ
, INVESTIGATOR_ASG INVESTIGATOR_ASG
, INVESTIGATION_START INVESTIGATION_START
, INVESTIGATION_END INVESTIGATION_END
, INVESTIGATION_EXTENDED INVESTIGATION_EXTENDED
, INVEST_EXTENSION_DESC INVEST_EXTENSION_DESC
, AGENCY_RECVD_ROI AGENCY_RECVD_ROI
, COMREP_RECVD_ROI COMREP_RECVD_ROI
, OPTIONS_LTR_DATE OPTIONS_LTR_DATE
, COMREP_RECVD_OPT_LTR COMREP_RECVD_OPT_LTR
, COMREP_OPT_LTR_RESPONSE COMREP_OPT_LTR_RESPONSE
, RESOLUTION_OFFER RESOLUTION_OFFER
, COMREP_RESOL_OFFER_RECVD COMREP_RESOL_OFFER_RECVD
, COMREP_RESOL_OFFER_RESPONSE COMREP_RESOL_OFFER_RESPONSE
, COMREP_RESOL_OFFER_DESC COMREP_RESOL_OFFER_DESC
, RESOL_OFFER_SIGNED RESOL_OFFER_SIGNED
, RESOL_OFFER_DESC RESOL_OFFER_DESC
, HEARING_REQ HEARING_REQ
, HEARING_SOURCE HEARING_SOURCE
, AGENCY_NOTIFIED_HEARING AGENCY_NOTIFIED_HEARING
, AGENCY_FILES_FORWARDED_EEOC AGENCY_FILES_FORWARDED_EEOC
, EEOC_HEARING_DOCKET_NUM EEOC_HEARING_DOCKET_NUM
, HEARING_COMPLETE HEARING_COMPLETE
, AJ_MERIT_DECISION_DATE AJ_MERIT_DECISION_DATE
, AGENCY_RECVD_AJ_MERIT_DEC AGENCY_RECVD_AJ_MERIT_DEC
, AJ_MERIT_DECISION AJ_MERIT_DECISION
, AJ_CA_DECISION_DATE AJ_CA_DECISION_DATE
, AGENCY_RECVD_AJ_CA_DEC AGENCY_RECVD_AJ_CA_DEC
, AJ_CA_DECISION AJ_CA_DECISION
, FAD_REQUESTED FAD_REQUESTED
, FAD_SOURCE FAD_SOURCE
, MERIT_FAD MERIT_FAD
, ATTORNEY_FEES_FAD ATTORNEY_FEES_FAD
, COMP_DAMAGES_FAD COMP_DAMAGES_FAD
, NON_COMPLIANCE_FAD NON_COMPLIANCE_FAD
, FAD_REQ_RECVD_EEO_OFFICE FAD_REQ_RECVD_EEO_OFFICE
, FAD_REQ_FORWD_TO_AGENCY FAD_REQ_FORWD_TO_AGENCY
, AGENCY_RECVD_REQUEST AGENCY_RECVD_REQUEST
, FAD_DUE FAD_DUE
, FAD_DATE FAD_DATE
, FAD_DECISION FAD_DECISION
, FAD_FORWD_TO_COMREP FAD_FORWD_TO_COMREP
, FAD_RECVD_BY_COMREP FAD_RECVD_BY_COMREP
, FAD_IMP_LTR_FORWD_TO_ORG FAD_IMP_LTR_FORWD_TO_ORG
, FAD_DECISION_FORWD_LEGAL FAD_DECISION_FORWD_LEGAL
, FAD_DECISION_RECVD_LEGAL FAD_DECISION_RECVD_LEGAL
, FA_SOURCE FA_SOURCE
, FINAL_ACTION_DUE FINAL_ACTION_DUE
, FINAL_ACT_FORWD_COMREP FINAL_ACT_FORWD_COMREP
, FINAL_ACT_RECVD_COMREP FINAL_ACT_RECVD_COMREP
, FINAL_ACTION_DECISION_DATE FINAL_ACTION_DECISION_DATE
, FINAL_ACTION_DECISION FINAL_ACTION_DECISION
, FA_IMP_LTR_FORWD_TO_ORG FA_IMP_LTR_FORWD_TO_ORG
, FA_DECISION_FORWD_LEGAL FA_DECISION_FORWD_LEGAL
, FA_DECISION_RECVD_LEGAL FA_DECISION_RECVD_LEGAL
, CIVIL_ACTION_FILED CIVIL_ACTION_FILED
, AGENCY_NOTIF_OF_CIVIL_ACTION AGENCY_NOTIF_OF_CIVIL_ACTION
, AGENCY_CLOSURE_CONFIRMED AGENCY_CLOSURE_CONFIRMED
, CONSOLIDATED_COMPLAINT_ID CONSOLIDATED_COMPLAINT_ID
, CONSOLIDATED CONSOLIDATED
, STAGE_OF_CONSOLIDATION STAGE_OF_CONSOLIDATION
, COMREP_NOTIF_CONSOLIDATION COMREP_NOTIF_CONSOLIDATION
, CONSOLIDATION_DESC CONSOLIDATION_DESC
, COMPLAINT_CLOSED COMPLAINT_CLOSED
, COMPLAINT_CLOSED_DESC COMPLAINT_CLOSED_DESC
, FILED_FORMAL_CLASS FILED_FORMAL_CLASS
, FORWD_EEOC FORWD_EEOC
, AGENCY_BRIEF_EEOC AGENCY_BRIEF_EEOC
, AJ_CERT_DECISION_DATE AJ_CERT_DECISION_DATE
, AJ_CERT_DECISION_RECVD AJ_CERT_DECISION_RECVD
, AJ_CERT_DECISION AJ_CERT_DECISION
, CLASS_MEMBERS_NOTIFIED CLASS_MEMBERS_NOTIFIED
, NUMBER_OF_COMPLAINTANTS NUMBER_OF_COMPLAINTANTS
, CLASS_HEARING CLASS_HEARING
, AJ_DEC AJ_DEC
, AGENCY_RECVD_AJ_DEC AGENCY_RECVD_AJ_DEC
, 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
, AJ_DECISION AJ_DECISION
, NATURE_OF_CLOSURE NATURE_OF_CLOSURE
, AGENCY_CODE AGENCY_CODE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, ALLEG_DISCRIM_ORG_ID ALLEG_DISCRIM_ORG_ID
, HR_OFFICE_ORG_ID HR_OFFICE_ORG_ID
, EEO_OFFICE_ORG_ID EEO_OFFICE_ORG_ID
, SERVICED_ORG_ID SERVICED_ORG_ID
, RECORD_RECEIVED RECORD_RECEIVED
, AUDITED_BY AUDITED_BY
FROM "HR"."GHR_COMPLAINTS2"