eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.GHR_COMPL_CA_HEADERS

Object Details

Object Name:	GHR_COMPL_CA_HEADERS
Object Type:	TABLE
Owner:	HR
FND Design Data:	GHR.GHR_COMPL_CA_HEADERS
Subobject Name:
Status:	VALID

Stores the Corrective Action Header information for a given Complaint.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: GHR_COMPL_CA_HEADERS_PK

COMPL_CA_HEADER_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
GHR_COMPL_CA_HEADERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMPL_CA_HEADER_ID
GHR_COMPL_CA_HEADERS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPLAINT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
GHR_COMPL_CA_HEADERS		GHR_COMPLAINTS2	GHR_COMPL_CA_HEADERS COMPLAINT_ID
GHR_COMPL_CA_DETAILS		GHR_COMPL_CA_HEADERS	GHR_COMPL_CA_DETAILS COMPL_CA_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COMPL_CA_HEADER_ID	NUMBER	(15)	Yes	Primary key generated from sequence GHR_COMPL_CA_HEADERS_S
COMPLAINT_ID	NUMBER	(15)	Yes	Foreign key to GHR_COMPLAINTS2
CA_SOURCE	VARCHAR2	(30)		Source of Corrective Action
LAST_COMPLIANCE_REPORT	DATE			Date of Last Compliance Report
COMPLIANCE_CLOSED	DATE			Date Compliance Closed
COMPL_DOCKET_NUMBER	VARCHAR2	(50)		OFO Compliance Docket Number
APPEAL_DOCKET_NUMBER	VARCHAR2	(50)		OFO Appeal Docket Number
PFE_DOCKET_NUMBER	VARCHAR2	(50)		Docket Number
PFE_RECEIVED	DATE			Date Petition for Enforcement (PFE) Received
AGENCY_BRIEF_PFE_DUE	DATE			Date Agency Brief Due
AGENCY_BRIEF_PFE_DATE	DATE			Date Agency Brief
DECISION_PFE_DATE	DATE			Date Decision on PFE
DECISION_PFE	VARCHAR2	(2000)		Decision on PFE
AGENCY_RECVD_PFE_DECISION	DATE			Date Agency Received PFE Decision
AGENCY_PFE_BRIEF_FORWD	DATE			Date Agency PFE Brief Forwarded
AGENCY_NOTIFIED_NONCOM	DATE			Date Agency Notified of Noncompliance
COMREP_NONCOM_REQ	VARCHAR2	(30)		Complainant/Rep Noncompliance Request
EEO_OFF_REQ_DATA_FROM_ORG	DATE			Date EEO Office Requested Data from Org
ORG_FORWD_DATA_TO_EEO_OFF	DATE			Date Org Forwarded Data to EEO Office
DEC_IMPLEMENTED	DATE			Date Decision Implemented
COMPLAINT_REINSTATED	DATE			Date Complaint Reinstated
STAGE_COMPLAINT_REINSTATED	VARCHAR2	(30)		Stage Complaint Reinstated
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.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT COMPL_CA_HEADER_ID
,      COMPLAINT_ID
,      CA_SOURCE
,      LAST_COMPLIANCE_REPORT
,      COMPLIANCE_CLOSED
,      COMPL_DOCKET_NUMBER
,      APPEAL_DOCKET_NUMBER
,      PFE_DOCKET_NUMBER
,      PFE_RECEIVED
,      AGENCY_BRIEF_PFE_DUE
,      AGENCY_BRIEF_PFE_DATE
,      DECISION_PFE_DATE
,      DECISION_PFE
,      AGENCY_RECVD_PFE_DECISION
,      AGENCY_PFE_BRIEF_FORWD
,      AGENCY_NOTIFIED_NONCOM
,      COMREP_NONCOM_REQ
,      EEO_OFF_REQ_DATA_FROM_ORG
,      ORG_FORWD_DATA_TO_EEO_OFF
,      DEC_IMPLEMENTED
,      COMPLAINT_REINSTATED
,      STAGE_COMPLAINT_REINSTATED
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HR.GHR_COMPL_CA_HEADERS;

Dependencies

[top of page]

HR.GHR_COMPL_CA_HEADERS does not reference any database object

HR.GHR_COMPL_CA_HEADERS is referenced by following:

APPS: GHR_COMPL_CA_HEADERS; GHR_COMPL_CA_HEADERS_WHO
PUBLIC: GHR_COMPL_CA_HEADERS