[Home] [Help] [Dependency Information]
Object Name: | PER_ASSESSMENT_TYPES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.PER_ASSESSMENT_TYPES |
Subobject Name: | |
Status: | VALID |
The definition of an assessment template including an indication of
whether the Assessment is designed to evaluate Competence Proficiency,
Performance or Both. An assessment type is used to define the set of
competences which should be evaluated in any given assessment.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PER_ASSESSMENT_TYPES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ASSESSMENT_TYPE_ID |
PER_ASSESSMENT_TYPES_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
PER_ASSESSMENT_TYPES_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RATING_SCALE_ID |
PER_ASSESSMENT_TYPES_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | WEIGHTING_SCALE_ID |
PER_ASSESSMENT_TYPES_UK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
NAME
BUSINESS_GROUP_ID |
Table | |
Foreign Table | Foreign Key Column | PER_ASSESSMENT_TYPES | HR_ALL_ORGANIZATION_UNITS | PER_ASSESSMENT_TYPES BUSINESS_GROUP_ID | PER_ASSESSMENT_TYPES | PER_RATING_SCALES | PER_ASSESSMENT_TYPES WEIGHTING_SCALE_ID | PER_ASSESSMENT_TYPES | PER_RATING_SCALES | PER_ASSESSMENT_TYPES RATING_SCALE_ID | PER_APPRAISAL_TEMPLATES | PER_ASSESSMENT_TYPES | PER_APPRAISAL_TEMPLATES ASSESSMENT_TYPE_ID | PER_ASSESSMENTS | PER_ASSESSMENT_TYPES | PER_ASSESSMENTS ASSESSMENT_TYPE_ID | PER_COMPETENCE_ELEMENTS | PER_ASSESSMENT_TYPES | PER_COMPETENCE_ELEMENTS ASSESSMENT_TYPE_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSESSMENT_TYPE_ID | NUMBER | (9) | Yes | Unique identifier of assessment type |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign Key to HR_ORGANIZATION_UNITS | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | System-generated version of row. Increments by one with each update. |
NAME | VARCHAR2 | (240) | Yes | The title of the Assessmnt TYpe |
DATE_TO | DATE | Indication of when the assessment type will be unavialable for use | ||
DATE_FROM | DATE | Indication of when the assessment type will be avialable for use | ||
ASSESSMENT_CLASSIFICATION | VARCHAR2 | (30) | Yes | An indication of whether the Assessment is designed to evaluate Performance, Proficiency or Both |
DISPLAY_ASSESSMENT_COMMENTS | VARCHAR2 | (30) | Yes | An indication of whether the Comments item should be displayed on the Competence Assessment Questionnaire |
DESCRIPTION | VARCHAR2 | (255) | A description of the assessment type | |
RATING_SCALE_COMMENT | VARCHAR2 | (2000) | Comments relating to the use of the Performance Rating Scale that will be displayed on an Assessment of this type | |
WEIGHTING_SCALE_COMMENT | VARCHAR2 | (2000) | Comments relating to the use of the Weighting Scale that will be displayed on an Assessment of this type | |
COMMENTS | VARCHAR2 | (2000) | Comments about the assessment type | |
LINE_SCORE_FORMULA | VARCHAR2 | (30) | The formula used to calculate the score for each assessment line | |
TOTAL_SCORE_FORMULA | VARCHAR2 | (30) | The formula used to calculate the total score for the assessment | |
WEIGHTING_CLASSIFICATION | VARCHAR2 | (30) | An indication of whether the Weighting Value applies to the Proficiency Level or the Performance Rating | |
RATING_SCALE_ID | NUMBER | (9) | The rating scale used in the assessment template | |
WEIGHTING_SCALE_ID | NUMBER | (9) | The weighting scale used in the assessment template | |
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. | ||
INSTRUCTIONS | LONG | (0) | General Instructions to be displayed on any assessment of this type | |
TYPE | VARCHAR2 | (30) | Indicates Assement Type | |
LINE_SCORE_FORMULA_ID | NUMBER | (9) | Formula ID | |
DEFAULT_JOB_COMPETENCIES | VARCHAR2 | (30) | Inidcates to default Job Competencies in appraisals | |
AVAILABLE_FLAG | VARCHAR2 | (30) | Indicates whether published |
Cut, paste (and edit) the following text to query this object:
SELECT ASSESSMENT_TYPE_ID
, BUSINESS_GROUP_ID
, OBJECT_VERSION_NUMBER
, NAME
, DATE_TO
, DATE_FROM
, ASSESSMENT_CLASSIFICATION
, DISPLAY_ASSESSMENT_COMMENTS
, DESCRIPTION
, RATING_SCALE_COMMENT
, WEIGHTING_SCALE_COMMENT
, COMMENTS
, LINE_SCORE_FORMULA
, TOTAL_SCORE_FORMULA
, WEIGHTING_CLASSIFICATION
, RATING_SCALE_ID
, WEIGHTING_SCALE_ID
, 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
, INSTRUCTIONS
, TYPE
, LINE_SCORE_FORMULA_ID
, DEFAULT_JOB_COMPETENCIES
, AVAILABLE_FLAG
FROM HR.PER_ASSESSMENT_TYPES;
HR.PER_ASSESSMENT_TYPES does not reference any database object
HR.PER_ASSESSMENT_TYPES is referenced by following:
|
|
|