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

TABLE: HR.GHR_PD_CLASSIFICATIONS

Object Details
Object Name: GHR_PD_CLASSIFICATIONS
Object Type: TABLE
Owner: HR
FND Design Data: TableGHR.GHR_PD_CLASSIFICATIONS
Subobject Name:
Status: VALID


Classification details of a Position Description.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: GHR_PD_CLASSIFICATIONS_PK
  1. ColumnPD_CLASSIFICATION_ID
Unique Key: GHR_PD_CLASSIFICATIONS_UK
  1. ColumnPOSITION_DESCRIPTION_ID
  2. ColumnCLASS_GRADE_BY
Indexes
Index Type Uniqueness Tablespace Column
GHR_PD_CLASSIFICATIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPD_CLASSIFICATION_ID
GHR_PD_CLASSIFICATIONS_UK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_DESCRIPTION_ID
ColumnCLASS_GRADE_BY
GHR_PD_CLASSIFICATIONS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAY_PLAN
Foreign Keys
Table
Foreign Table Foreign Key Column
GHR_PD_CLASSIFICATIONS GHR_PD_CLASSIFICATIONS_FK1 TableGHR_POSITION_DESCRIPTIONS GHR_PD_CLASSIFICATIONS POSITION_DESCRIPTION_ID
Columns
Name Datatype Length Mandatory Comments
PD_CLASSIFICATION_ID NUMBER (15) Yes Primary key generated from sequence GHR_PA_CLASSIFICATIONS_S.
POSITION_DESCRIPTION_ID NUMBER (15) Yes Foreign key to GHR_POSITION_DESCRIPTIONS.
CLASS_GRADE_BY VARCHAR2 (2) Yes Code indicating level of review provided.
OFFICIAL_TITLE VARCHAR2 (80)
Official title.
PAY_PLAN VARCHAR2 (2)
Pay plan.
OCCUPATIONAL_CODE VARCHAR2 (9)
Occupational code.
GRADE_LEVEL VARCHAR2 (2)
Grade or level.
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.
Query Text

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


SELECT PD_CLASSIFICATION_ID
,      POSITION_DESCRIPTION_ID
,      CLASS_GRADE_BY
,      OFFICIAL_TITLE
,      PAY_PLAN
,      OCCUPATIONAL_CODE
,      GRADE_LEVEL
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.GHR_PD_CLASSIFICATIONS;

Dependencies

[top of page]

HR.GHR_PD_CLASSIFICATIONS does not reference any database object

HR.GHR_PD_CLASSIFICATIONS is referenced by following:

SchemaHR
ViewGHR_PD_CLASSIFICATIONS#