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


TABLE: HR.PER_RATING_SCALES

Object Details
Object Name: PER_RATING_SCALES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_RATING_SCALES
Subobject Name:
Status: VALID


A rating scale is a grouping of rating scale steps which are used to
rate competences.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_RATING_SCALES_PK
  1. ColumnRATING_SCALE_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_RATING_SCALES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRATING_SCALE_ID
PER_RATING_SCALES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_RATING_SCALES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_RATING_SCALES PER_RATING_SCALES_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_RATING_SCALES BUSINESS_GROUP_ID
TablePER_APPRAISAL_TEMPLATES PER_APPRAISAL_TEMPLATES_FK3 PER_RATING_SCALES PER_APPRAISAL_TEMPLATES RATING_SCALE_ID
TablePER_ASSESSMENT_TYPES PER_ASSESSMENT_TYPES_FK2 PER_RATING_SCALES PER_ASSESSMENT_TYPES RATING_SCALE_ID
TablePER_ASSESSMENT_TYPES PER_ASSESSMENT_TYPES_FK3 PER_RATING_SCALES PER_ASSESSMENT_TYPES WEIGHTING_SCALE_ID
TablePER_COMPETENCES PER_COMPETENCES_FK2 PER_RATING_SCALES PER_COMPETENCES RATING_SCALE_ID
TablePER_RATING_LEVELS PER_RATING_LEVELS_FK1 PER_RATING_SCALES PER_RATING_LEVELS RATING_SCALE_ID
Columns
Name Datatype Length Mandatory Comments
RATING_SCALE_ID NUMBER (9) Yes Primary Key for PER_RATING_SCALES
BUSINESS_GROUP_ID NUMBER (15)
Foreign Key to HR_ORGANIZATION_UNITS
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object Version Number
NAME VARCHAR2 (80) Yes The name of the rating scale
TYPE VARCHAR2 (30) Yes The type of Rating Scale e.g. Performance, Proficiency, Weighting
DESCRIPTION VARCHAR2 (2000)
The description of the rating scale
DEFAULT_FLAG VARCHAR2 (30)
An indication that the rating scale is the preferred scale in the absence of another specifically chosen scale.
MAX_SCALE_STEP NUMBER (15)
The maximum rating level within this rating scale
MIN_SCALE_STEP NUMBER (15)
The minimum level in use within this rating scale
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining 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.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
Query Text

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


SELECT RATING_SCALE_ID
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      NAME
,      TYPE
,      DESCRIPTION
,      DEFAULT_FLAG
,      MAX_SCALE_STEP
,      MIN_SCALE_STEP
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_RATING_SCALES;

Dependencies

[top of page]

HR.PER_RATING_SCALES does not reference any database object

HR.PER_RATING_SCALES is referenced by following:

SchemaAPPS
SynonymPER_RATING_SCALES
TriggerPER_RATING_SCALES_WHO
SchemaPUBLIC
SynonymPER_RATING_SCALES