[Home] [Help] [Dependency Information]
Object Name: | PER_APPRAISALS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPRAISAL_ID | NUMBER | (15) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
APPRAISAL_TEMPLATE_ID | NUMBER | (15) | Yes | |
APPRAISEE_PERSON_ID | NUMBER | (15) | Yes | |
APPRAISER_PERSON_ID | NUMBER | (15) | Yes | |
APPRAISAL_DATE | DATE | |||
GROUP_DATE | DATE | |||
GROUP_INITIATOR_ID | NUMBER | (9) | ||
APPRAISAL_PERIOD_END_DATE | DATE | Yes | ||
APPRAISAL_PERIOD_START_DATE | DATE | Yes | ||
TYPE | VARCHAR2 | (30) | ||
NEXT_APPRAISAL_DATE | DATE | |||
STATUS | VARCHAR2 | (30) | ||
COMMENTS | VARCHAR2 | (2000) | ||
OVERALL_PERFORMANCE_LEVEL_ID | NUMBER | (15) | ||
OPEN | VARCHAR2 | (30) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE16 | VARCHAR2 | (150) | ||
ATTRIBUTE17 | VARCHAR2 | (150) | ||
ATTRIBUTE18 | VARCHAR2 | (150) | ||
ATTRIBUTE19 | VARCHAR2 | (150) | ||
ATTRIBUTE20 | VARCHAR2 | (150) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
SYSTEM_TYPE | VARCHAR2 | (30) | ||
APPRAISAL_SYSTEM_STATUS | VARCHAR2 | (30) | ||
SYSTEM_PARAMS | VARCHAR2 | (500) | ||
APPRAISEE_ACCESS | VARCHAR2 | (30) | ||
MAIN_APPRAISER_ID | NUMBER | (15) | ||
ASSIGNMENT_ID | NUMBER | (15) | ||
ASSIGNMENT_START_DATE | DATE | |||
ASSIGNMENT_BUSINESS_GROUP_ID | NUMBER | (15) | ||
ASSIGNMENT_ORGANIZATION_ID | NUMBER | (15) | ||
ASSIGNMENT_JOB_ID | NUMBER | (15) | ||
ASSIGNMENT_POSITION_ID | NUMBER | (15) | ||
ASSIGNMENT_GRADE_ID | NUMBER | (15) | ||
POTENTIAL_READINESS_LEVEL | VARCHAR2 | (30) | ||
POTENTIAL_SHORT_TERM_WORKOPP | VARCHAR2 | (240) | ||
POTENTIAL_LONG_TERM_WORKOPP | VARCHAR2 | (240) | ||
POTENTIAL_DETAILS | VARCHAR2 | (2000) | ||
EVENT_ID | NUMBER | (15) | ||
SHOW_COMPETENCY_RATINGS | VARCHAR2 | (30) | ||
SHOW_QUESTIONNAIRE_INFO | VARCHAR2 | (30) | ||
SHOW_OVERALL_RATINGS | VARCHAR2 | (30) | ||
SHOW_OVERALL_COMMENTS | VARCHAR2 | (30) | ||
UPDATE_APPRAISAL | VARCHAR2 | (30) | ||
PROVIDE_OVERALL_FEEDBACK | VARCHAR2 | (30) | ||
SHOW_OBJECTIVE_RATINGS | VARCHAR2 | (30) | ||
SHOW_PARTICIPANT_DETAILS | VARCHAR2 | (30) | ||
SHOW_PARTICIPANT_NAMES | VARCHAR2 | (30) | ||
SHOW_PARTICIPANT_RATINGS | VARCHAR2 | (30) | ||
APPRAISEE_COMMENTS | VARCHAR2 | (2000) | ||
PLAN_ID | NUMBER | (15) | ||
OFFLINE_STATUS | VARCHAR2 | (30) | ||
RETENTION_POTENTIAL | VARCHAR2 | (30) | ||
SHOW_PARTICIPANT_COMMENTS | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT APPRAISAL_ID
, BUSINESS_GROUP_ID
, OBJECT_VERSION_NUMBER
, APPRAISAL_TEMPLATE_ID
, APPRAISEE_PERSON_ID
, APPRAISER_PERSON_ID
, APPRAISAL_DATE
, GROUP_DATE
, GROUP_INITIATOR_ID
, APPRAISAL_PERIOD_END_DATE
, APPRAISAL_PERIOD_START_DATE
, TYPE
, NEXT_APPRAISAL_DATE
, STATUS
, COMMENTS
, OVERALL_PERFORMANCE_LEVEL_ID
, OPEN
, 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
, SYSTEM_TYPE
, APPRAISAL_SYSTEM_STATUS
, SYSTEM_PARAMS
, APPRAISEE_ACCESS
, MAIN_APPRAISER_ID
, ASSIGNMENT_ID
, ASSIGNMENT_START_DATE
, ASSIGNMENT_BUSINESS_GROUP_ID
, ASSIGNMENT_ORGANIZATION_ID
, ASSIGNMENT_JOB_ID
, ASSIGNMENT_POSITION_ID
, ASSIGNMENT_GRADE_ID
, POTENTIAL_READINESS_LEVEL
, POTENTIAL_SHORT_TERM_WORKOPP
, POTENTIAL_LONG_TERM_WORKOPP
, POTENTIAL_DETAILS
, EVENT_ID
, SHOW_COMPETENCY_RATINGS
, SHOW_QUESTIONNAIRE_INFO
, SHOW_OVERALL_RATINGS
, SHOW_OVERALL_COMMENTS
, UPDATE_APPRAISAL
, PROVIDE_OVERALL_FEEDBACK
, SHOW_OBJECTIVE_RATINGS
, SHOW_PARTICIPANT_DETAILS
, SHOW_PARTICIPANT_NAMES
, SHOW_PARTICIPANT_RATINGS
, APPRAISEE_COMMENTS
, PLAN_ID
, OFFLINE_STATUS
, RETENTION_POTENTIAL
, SHOW_PARTICIPANT_COMMENTS
FROM HR.PER_APPRAISALS#;
|
|
|