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_PERF_CERT

Object Details

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

GHR_PERF_CERT stores the performance certification details of an agency or subelement code or organization.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GHR_PERF_CERT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CERT_AGENCY CERT_GROUP CERT_START_DATE CERT_END_DATE BUSINESS_GROUP_ID
GHR_PERF_CERT_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CERT_ID
GHR_PERF_CERT_UK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CERT_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
CERT_ID	NUMBER	(15)	Yes	Certification ID
CERT_NAME	VARCHAR2	(35)	Yes	Certification Name
CERT_AGENCY	VARCHAR2	(2)		Certification Agency
CERT_AGENCY_SUB_CODE	VARCHAR2	(4)		Certification Agency Sub Element
CERT_ORGANIZATION	NUMBER	(15)		Certification Organization
CERT_GROUP	VARCHAR2	(4)	Yes	Certification Group
CERT_TYPE	VARCHAR2	(15)	Yes	Certification Type
CERT_START_DATE	DATE		Yes	Certification Start Date
CERT_END_DATE	DATE			Certification End Date
CREATED_BY	NUMBER	(15)	Yes	Created By
CREATION_DATE	DATE		Yes	Creation Date
LAST_UPDATED_BY	NUMBER	(15)	Yes	Last Updated By
LAST_UPDATE_DATE	DATE		Yes	Last Update Date
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Update Login
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Object Version Number
BUSINESS_GROUP_ID	NUMBER	(15)		Business Group Id

Query Text

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


SELECT CERT_ID
,      CERT_NAME
,      CERT_AGENCY
,      CERT_AGENCY_SUB_CODE
,      CERT_ORGANIZATION
,      CERT_GROUP
,      CERT_TYPE
,      CERT_START_DATE
,      CERT_END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      BUSINESS_GROUP_ID
FROM HR.GHR_PERF_CERT;

Dependencies

[top of page]

HR.GHR_PERF_CERT does not reference any database object

HR.GHR_PERF_CERT is referenced by following:

HR: GHR_PERF_CERT#