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_POSITION_DESCRIPTIONS

Object Details

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

Federal Position Description details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: GHR_POSITION_DESCRIPTIONS_PK

POSITION_DESCRIPTION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
GHR_POSITION_DESCRIPTIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	POSITION_DESCRIPTION_ID
GHR_POSITION_DESCRIPTIONS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ROUTING_GROUP_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
GHR_POSITION_DESCRIPTIONS	GHR_ROUTING_GROUPS	GHR_POSITION_DESCRIPTIONS ROUTING_GROUP_ID
GHR_PD_CLASSIFICATIONS	GHR_POSITION_DESCRIPTIONS	GHR_PD_CLASSIFICATIONS POSITION_DESCRIPTION_ID
GHR_PD_ROUTING_HISTORY	GHR_POSITION_DESCRIPTIONS	GHR_PD_ROUTING_HISTORY POSITION_DESCRIPTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
POSITION_DESCRIPTION_ID	NUMBER	(15)	Yes	Primary key generated from sequence GHR_POSITION_DESCRIPTIONS_S.
ROUTING_GROUP_ID	NUMBER	(15)	Yes	Foreign key to GHR_ROUTING_GROUPS.
DATE_FROM	DATE		Yes	The date on which the position description becomes effective.
DATE_TO	DATE			The date after which the position description is no longer effective.
OPM_CERT_NUM	VARCHAR2	(20)		Office of Personnel Management certification number.
FLSA	VARCHAR2	(1)		Fair labor standards act.
FINANCIAL_STATEMENT	VARCHAR2	(1)		Indicates the financial statement is required.
SUBJECT_TO_IA_ACTION	VARCHAR2	(1)		Indicates whether the position is subject to IA action.
POSITION_STATUS	NUMBER	(1)		Position status.
POSITION_IS	VARCHAR2	(1)		Supervisory status.
POSITION_SENSITIVITY	VARCHAR2	(1)		Position sensitivity.
COMPETITIVE_LEVEL	VARCHAR2	(4)		Competitive level.
PD_REMARKS	VARCHAR2	(2000)		Remarks.
POSITION_CLASS_STD	VARCHAR2	(50)		Position classification standards.
CATEGORY	VARCHAR2	(10)		Category.
CAREER_LADDER	VARCHAR2	(1)		Indicates whether the position is part of a career ladder.
SUPERVISOR_NAME	VARCHAR2	(240)		Supervisor?s name.
SUPERVISOR_TITLE	VARCHAR2	(240)		Supervisor?s title.
SUPERVISOR_DATE	DATE			Date of supervisor?s authorization.
MANAGER_NAME	VARCHAR2	(240)		Manager?s name.
MANAGER_TITLE	VARCHAR2	(240)		Manager?s title.
MANAGER_DATE	DATE			Date of manager?s authorization.
CLASSIFIER_NAME	VARCHAR2	(240)		Classifier?s name.
CLASSIFIER_TITLE	VARCHAR2	(240)		Classifier?s title.
CLASSIFIER_DATE	DATE			Date of classifier?s authorization.
PA_REQUEST_ID	NUMBER	(15)		Foreign key to GHR_PA_REQUESTS.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield column.
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.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System-generated version of row. Increments by one with each update.
LAST_UPDATE_DATE	DATE		Yes	Standard who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column.
CREATED_BY	NUMBER	(15)	Yes	Standard who column.
CREATION_DATE	DATE		Yes	Standard who column.
BUSINESS_GROUP_ID	NUMBER	(15)		Business Group of Record

Query Text

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


SELECT POSITION_DESCRIPTION_ID
,      ROUTING_GROUP_ID
,      DATE_FROM
,      DATE_TO
,      OPM_CERT_NUM
,      FLSA
,      FINANCIAL_STATEMENT
,      SUBJECT_TO_IA_ACTION
,      POSITION_STATUS
,      POSITION_IS
,      POSITION_SENSITIVITY
,      COMPETITIVE_LEVEL
,      PD_REMARKS
,      POSITION_CLASS_STD
,      CATEGORY
,      CAREER_LADDER
,      SUPERVISOR_NAME
,      SUPERVISOR_TITLE
,      SUPERVISOR_DATE
,      MANAGER_NAME
,      MANAGER_TITLE
,      MANAGER_DATE
,      CLASSIFIER_NAME
,      CLASSIFIER_TITLE
,      CLASSIFIER_DATE
,      PA_REQUEST_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      BUSINESS_GROUP_ID
FROM HR.GHR_POSITION_DESCRIPTIONS;

Dependencies

[top of page]

HR.GHR_POSITION_DESCRIPTIONS does not reference any database object

HR.GHR_POSITION_DESCRIPTIONS is referenced by following:

HR: GHR_POSITION_DESCRIPTIONS#