[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GHR_COMPLAINTS2 |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  GHR.GHR_COMPLAINTS2
|
| Subobject Name: | |
| Status: | VALID |
GHR_COMPLAINT2 is a table that contains all the details of the Complaints filed by various person types in the system. (Employees ,Applicants etc)
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
COMPLAINT_ID| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GHR_COMPLAINTS2_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
COMPLAINT_ID
|
| Table | |
Foreign Table | Foreign Key Column |
GHR_COMPL_ADRS
|
 |
GHR_COMPLAINTS2 | GHR_COMPL_ADRS COMPLAINT_ID |
GHR_COMPL_AGENCY_APPEALS
|
|
GHR_COMPLAINTS2 | GHR_COMPL_AGENCY_APPEALS COMPLAINT_ID |
GHR_COMPL_APPEALS
|
|
GHR_COMPLAINTS2 | GHR_COMPL_APPEALS COMPLAINT_ID |
GHR_COMPL_CA_HEADERS
|
|
GHR_COMPLAINTS2 | GHR_COMPL_CA_HEADERS COMPLAINT_ID |
GHR_COMPL_CLAIMS
|
|
GHR_COMPLAINTS2 | GHR_COMPL_CLAIMS COMPLAINT_ID |
GHR_COMPL_PEOPLE
|
|
GHR_COMPLAINTS2 | GHR_COMPL_PEOPLE COMPLAINT_ID |
|---|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COMPLAINT_ID | NUMBER | (15) | Yes | Primary key generated from sequence GHR_COMPLAINTS2_S |
| COMPLAINANT_PERSON_ID | NUMBER | (15) | Unique Identifer of the Complainant Person. | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Unique Identifier of the Business Group. | |
| DOCKET_NUMBER | VARCHAR2 | (50) | Docket Number | |
| STAGE | VARCHAR2 | (30) | Stage | |
| CLASS_FLAG | VARCHAR2 | (3) | Class Flag | |
| MIXED_FLAG | VARCHAR2 | (3) | Mixed Flag | |
| CONSOLIDATED_FLAG | VARCHAR2 | (3) | Consolidated Flag | |
| REMAND_FLAG | VARCHAR2 | (3) | Remand Flag | |
| ACTIVE_FLAG | VARCHAR2 | (3) | Active Flag | |
| INFORMATION_INQUIRY | DATE | Information Inquiry | ||
| PCOM_INIT | DATE | Date Pre-Complaint Initiated | ||
| ALLEG_INCIDENT | DATE | Date of Alleged Incident | ||
| ALLEG_DISCRIM_ORG_NAME | VARCHAR2 | (30) | Alleged Discriminating Organization | |
| RR_LTR_DATE | DATE | Rights/Responsibilities Letter Date | ||
| RR_LTR_RECVD | DATE | Date Rights/Responsibilities Letter Received | ||
| PRE_COM_ELEC | VARCHAR2 | (30) | Pre-Complaint Election | |
| CLASS_AGENT_FLAG | VARCHAR2 | (3) | Flags case as Class if case is CURRENTLY class | |
| PRE_COM_DESC | VARCHAR2 | (500) | Pre Complaint Description | |
| COUNSELOR_ASG | DATE | Date Counselor Assigned | ||
| INIT_COUNSELOR_INTERVIEW | DATE | Date of Initial Interview with Counselor | ||
| ANONYMITY_REQUESTED | VARCHAR2 | (3) | Anonymity Requested | |
| COUNSEL_EXT_LTR | DATE | Date Counseling Extension Letter | ||
| TRADITIONAL_COUNSEL_OUTCOME | VARCHAR2 | (30) | Traditional Counseling Outcome | |
| FINAL_INTERVIEW | DATE | Date Final Interview | ||
| NOTICE_RTF_RECVD | DATE | Date Notice of Right to File Received by ComRep | ||
| PRECOM_CLOSED | DATE | Date Pre-Complaint Closed | ||
| PRECOM_CLOSURE_NATURE | VARCHAR2 | (30) | Pre-Complaint Nature of Closure | |
| COUNSELOR_RPT_SUB | DATE | Date Counselors Report Submitted | ||
| HR_OFFICE_NAME | VARCHAR2 | (30) | Servicing HR Office | |
| EEO_OFFICE_NAME | VARCHAR2 | (30) | Servicing EEO Office | |
| SERVICED_ORG_NAME | VARCHAR2 | (30) | Serviced Organization | |
| FORMAL_COM_FILED | DATE | Date Formal Complaint Filed | ||
| ACK_LTR | DATE | Date Acknowledgment Letter | ||
| CLARIFICATION_LTR_DATE | DATE | Date Clarification Letter | ||
| CLARIFICATION_RESPONSE_RECVD | DATE | Date Complainants Response to Clarification Rcvd | ||
| FORWARDED_LEGAL_REVIEW | DATE | Date Forwarded for Legal Review | ||
| RETURNED_FROM_LEGAL | DATE | Date Returned from Legal | ||
| LETTER_TYPE | VARCHAR2 | (30) | Letter Type | |
| LETTER_DATE | DATE | Letter Date | ||
| LETTER_RECVD | DATE | Date Letter Received | ||
| INVESTIGATION_SOURCE | VARCHAR2 | (30) | Source of Investigation | |
| AGENCY_INVESTIGATOR_REQ | DATE | Date Agency Requested Investigator | ||
| INVESTIGATOR_RECVD_REQ | DATE | Date Request Received by Investigator | ||
| INVESTIGATOR_ASG | DATE | Date Investigator Assigned | ||
| INVESTIGATION_START | DATE | Date Investigation Started | ||
| INVESTIGATION_END | DATE | Date Investigation Ended | ||
| INVESTIGATION_EXTENDED | DATE | Date Investigation Extended | ||
| INVEST_EXTENSION_DESC | VARCHAR2 | (500) | Extension Description | |
| AGENCY_RECVD_ROI | DATE | Date Agency Received ROI | ||
| COMREP_RECVD_ROI | DATE | Date Complainant/Rep Received ROI | ||
| OPTIONS_LTR_DATE | DATE | Options Letter | ||
| COMREP_RECVD_OPT_LTR | DATE | Options Letter Date | ||
| COMREP_OPT_LTR_RESPONSE | VARCHAR2 | (30) | Complainant/Rep Response to Options Letter | |
| RESOLUTION_OFFER | DATE | Date of Offer of Resolution | ||
| COMREP_RESOL_OFFER_RECVD | DATE | Date ComRep Received Offer of Resolution | ||
| COMREP_RESOL_OFFER_RESPONSE | DATE | Date ComRep Response to Offer of Resolution | ||
| COMREP_RESOL_OFFER_DESC | VARCHAR2 | (250) | Complainant/Rep Response to Offer of Resolution | |
| RESOL_OFFER_SIGNED | DATE | Date Offer of Resolution Signed | ||
| RESOL_OFFER_DESC | VARCHAR2 | (2000) | Summary of Offer of Resolution | |
| HEARING_REQ | DATE | Date Hearing Requested | ||
| HEARING_SOURCE | VARCHAR2 | (30) | Source of Investigation | |
| AGENCY_NOTIFIED_HEARING | DATE | Date Agency Notified of Hearing | ||
| AGENCY_FILES_FORWARDED_EEOC | DATE | Date Agency Forwarded Files to EEOC | ||
| EEOC_HEARING_DOCKET_NUM | VARCHAR2 | (50) | EEOC Hearing Docket Number | |
| HEARING_COMPLETE | DATE | Date Hearing Completed | ||
| AJ_MERIT_DECISION_DATE | DATE | Date of AJ Merit Decision | ||
| AGENCY_RECVD_AJ_MERIT_DEC | DATE | Date Agency Received AJ Merit Decision | ||
| AJ_MERIT_DECISION | VARCHAR2 | (30) | AJ Merit Decision | |
| AJ_CA_DECISION_DATE | DATE | Date AJ Corrective Action Decision | ||
| AGENCY_RECVD_AJ_CA_DEC | DATE | Date Agency Received AJ Corrective Action Decision | ||
| AJ_CA_DECISION | VARCHAR2 | (30) | AJ Corrective Action Decision | |
| FAD_REQUESTED | DATE | Final Agency Decision (FAD) Requested | ||
| FAD_SOURCE | VARCHAR2 | (30) | Source of FAD | |
| MERIT_FAD | VARCHAR2 | (3) | Yes if FAD contains Merit based | |
| ATTORNEY_FEES_FAD | VARCHAR2 | (3) | Yes if FAD contains Attorney Fees | |
| COMP_DAMAGES_FAD | VARCHAR2 | (3) | Yes if FAD contains Compensatory Damages | |
| NON_COMPLIANCE_FAD | VARCHAR2 | (3) | Yes if FAD is due to Non-Compliance | |
| FAD_REQ_RECVD_EEO_OFFICE | DATE | Date EEO Office Received FAD Request | ||
| FAD_REQ_FORWD_TO_AGENCY | DATE | Date Request for FAD Forwarded to Agency | ||
| AGENCY_RECVD_REQUEST | DATE | Date Agency Received Request | ||
| FAD_DUE | DATE | Date FAD Due | ||
| FAD_DATE | DATE | FAD Date | ||
| FAD_DECISION | VARCHAR2 | (30) | Fad Decision | |
| FAD_FORWD_TO_COMREP | DATE | Date FAD Forwarded to Complainant/Rep | ||
| FAD_RECVD_BY_COMREP | DATE | Date FAD Received by Complainant/Rep | ||
| FAD_IMP_LTR_FORWD_TO_ORG | DATE | Date Implementation Letter Forwarded to Org | ||
| FAD_DECISION_FORWD_LEGAL | DATE | Date Decision Forwarded for Legal Review | ||
| FAD_DECISION_RECVD_LEGAL | DATE | Date Decision Received from Legal | ||
| FA_SOURCE | VARCHAR2 | (30) | Source of Final Action | |
| FINAL_ACTION_DUE | DATE | Final Action Due | ||
| FINAL_ACT_FORWD_COMREP | DATE | Date Final Action Forwarded to Complainant/Rep | ||
| FINAL_ACT_RECVD_COMREP | DATE | Date Final Action Received by Complainant/Rep | ||
| FINAL_ACTION_DECISION_DATE | DATE | Date Final Action Date | ||
| FINAL_ACTION_DECISION | VARCHAR2 | (30) | Final Action Decision | |
| FA_IMP_LTR_FORWD_TO_ORG | DATE | Date Implementation Letter to Org | ||
| FA_DECISION_FORWD_LEGAL | DATE | Date Decision Forwarded for Legal Review | ||
| FA_DECISION_RECVD_LEGAL | DATE | Date Decision Received from Legal | ||
| CIVIL_ACTION_FILED | DATE | Date Civil Action Filed | ||
| AGENCY_NOTIF_OF_CIVIL_ACTION | DATE | Date Agency Notified of Civil Action | ||
| AGENCY_CLOSURE_CONFIRMED | DATE | Date Agency Closure Confirmed | ||
| CONSOLIDATED_COMPLAINT_ID | NUMBER | (15) | Parent complaint_id for all complaints consolidated | |
| CONSOLIDATED | DATE | Date Consolidated | ||
| STAGE_OF_CONSOLIDATION | VARCHAR2 | (30) | Stage of Consolidation | |
| COMREP_NOTIF_CONSOLIDATION | DATE | Date complainant/Rep Notified of Consolidation | ||
| CONSOLIDATION_DESC | VARCHAR2 | (500) | Reason for Consolidation | |
| COMPLAINT_CLOSED | DATE | Date Complaint Closed | ||
| COMPLAINT_CLOSED_DESC | VARCHAR2 | (2000) | Description | |
| FILED_FORMAL_CLASS | DATE | Date Filed Formal Class | ||
| FORWD_EEOC | DATE | Date Forwarded to EEOC | ||
| AGENCY_BRIEF_EEOC | DATE | Date Agency Brief to EEOC | ||
| AJ_CERT_DECISION_DATE | DATE | Date of AJ Cert Decision | ||
| AJ_CERT_DECISION_RECVD | DATE | Date Agency Received Cert Decions | ||
| AJ_CERT_DECISION | VARCHAR2 | (30) | Date of AJ Certification Decision | |
| CLASS_MEMBERS_NOTIFIED | DATE | Date Class Members Notified | ||
| NUMBER_OF_COMPLAINTANTS | NUMBER | (9) | Number of complainants | |
| CLASS_HEARING | DATE | Class Hearing Date | ||
| AJ_DEC | DATE | Date AJ Decision | ||
| AGENCY_RECVD_AJ_DEC | DATE | Date Agency Received AJ Decision | ||
| OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | System-generated version of row. Increments by one with each update. |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
| CREATION_DATE | DATE | Yes | Standard who column. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
| AJ_DECISION | VARCHAR2 | (30) | AJ Decision | |
| NATURE_OF_CLOSURE | VARCHAR2 | (30) | Nature Of Closure | |
| AGENCY_CODE | VARCHAR2 | (4) | Agency Code | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Determines context of the attribute descriptive flexfield in parameters. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ALLEG_DISCRIM_ORG_ID | NUMBER | (15) | Alleged Discriminating Organization ID | |
| HR_OFFICE_ORG_ID | NUMBER | (15) | Servicing HR Office ID | |
| EEO_OFFICE_ORG_ID | VARCHAR2 | (240) | Servicing EEO Office ID | |
| SERVICED_ORG_ID | VARCHAR2 | (240) | Serviced Organization ID | |
| RECORD_RECEIVED | DATE | Record Received | ||
| AUDITED_BY | VARCHAR2 | (30) | Audited By |
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 does not reference any database object
HR.GHR_COMPLAINTS2 is referenced by following:
HR
GHR_COMPLAINTS2#
|
|
|
|