HRA_EVAL_ITEMS

This tables stores evaluation item details

Details

  • Schema: FUSION

  • Object owner: HRA

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

HRA_EVAL_ITEMS_PK

EVAL_ITEM_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
EVAL_ITEM_ID NUMBER 18 Yes Primary key for section items
BUSINESS_GROUP_ID NUMBER 18 Yes Foreign key to HR_ALL_ORGANIZATION_UNITS
EVALUATION_ID NUMBER 18 Primary key of Evaluation.
EVAL_SECTION_ID NUMBER 18 The identifier for the section (not shown in the UI)
REFERENCE_ITEM_ID NUMBER 18 Indicates the reference to the current item in Profile Management or Goal Management, depending on the type of the section item.
PARENT_ITEM_ID NUMBER 18 This field indicates the parent item.
ITEM_NAME VARCHAR2 240 Translated name for item.
DESCRIPTION VARCHAR2 4000 Description of the item.
MEASUREMENT VARCHAR2 4000 Usually used for objectives, this field indicates how achievement of an objective will be measured
TARGET_PROF_REV_RATING_ID NUMBER 18 This is the target performance rating for the item.
TARGET_PERF_REV_RATING_ID NUMBER 18 This is the target proficiency rating for the item.
PERF_RATING_MODEL_ID NUMBER 18 This is the rating model for performance for the item.
PROF_RATING_MODEL_ID NUMBER 18 This is the rating model for proficiency for each item
TARGET_DATE DATE This is the target date of the item. Typically applied to objectives
START_DATE DATE This the start date of the item. Typically applied to objectives
ACHIEVEMENT_DATE DATE This is the achievement date of the item. Typically applied to objectives
DUE_DATE DATE This is the due date for the item.
REMINDER_DATE DATE This is the reminder date for the item.
MIN_WEIGHT NUMBER 20 This is the minimum weight of the item.
WEIGHT NUMBER 20 This is the weight of the item.
OWNED_BY VARCHAR2 30 This field indicates the ownership and responsibility for a particular item.
RATING_OVERIDE_FLAG VARCHAR2 30 Indicates wheter to overide the ratings
MANDATORY_FLAG VARCHAR2 30 This flag indicates if an item is mandatory. Such items cannot be deleted or modified by the user
CRITICAL_FLAG VARCHAR2 30 This flag indicates if an item is critical. This flag is maintained by the user
PERCENT_COMPLETED NUMBER 18 Percentage of item completed
ADDED_IN_TASK VARCHAR2 30 Indicates the Item is added during which task
NOT_RATED_FLAG VARCHAR2 30 Indicates the item is not rated.
NOT_RATED_FLAG_UPDATED_BY NUMBER 18 Indicates the person Id who updated the not rated flag.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE30 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER13 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER14 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER15 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER16 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER17 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER18 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER19 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_NUMBER20 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE13 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE14 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
ATTRIBUTE_DATE15 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Performance Evaluation Items (HRA_EVAL_ITEMS)
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table Foreign Table Foreign Key Column
HRA_EVAL_ITEMS hra_eval_sections EVAL_SECTION_ID
HRA_EVAL_ITEMS hra_evaluations EVALUATION_ID
HRA_EVAL_ITEMS hrt_rating_models_b PERF_RATING_MODEL_ID, BUSINESS_GROUP_ID
HRA_EVAL_ITEMS hrt_rating_models_b PROF_RATING_MODEL_ID, BUSINESS_GROUP_ID
HRA_EVAL_ITEMS hrt_rating_levels_b TARGET_PROF_REV_RATING_ID, BUSINESS_GROUP_ID
HRA_EVAL_ITEMS hrt_rating_levels_b TARGET_PERF_REV_RATING_ID, BUSINESS_GROUP_ID

Indexes

Index Uniqueness Tablespace Columns
HRA_EVAL_ITEMS_N1 Non Unique Default EVAL_SECTION_ID
HRA_EVAL_ITEMS_N2 Non Unique Default EVALUATION_ID, REFERENCE_ITEM_ID
HRA_EVAL_ITEMS_N4 Non Unique Default REFERENCE_ITEM_ID
HRA_EVAL_ITEMS_PK Unique Default EVAL_ITEM_ID