[Home] [Help]
[Dependency Information]
[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#;
HR
GHR_COMPLAINTS2
APPS
GHR_COMPLAINTS2
GHR_COMPLAINTS2_WHO
|
|
|
|