[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: |
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:
|
|
|