VIEW: HR.PER_APPRAISALS#

Source

View Text - Preformatted

select APPRAISAL_ID APPRAISAL_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, APPRAISAL_TEMPLATE_ID APPRAISAL_TEMPLATE_ID, APPRAISEE_PERSON_ID APPRAISEE_PERSON_ID, APPRAISER_PERSON_ID APPRAISER_PERSON_ID, APPRAISAL_DATE APPRAISAL_DATE, GROUP_DATE GROUP_DATE, GROUP_INITIATOR_ID GROUP_INITIATOR_ID, APPRAISAL_PERIOD_END_DATE APPRAISAL_PERIOD_END_DATE, APPRAISAL_PERIOD_START_DATE APPRAISAL_PERIOD_START_DATE, TYPE TYPE, NEXT_APPRAISAL_DATE NEXT_APPRAISAL_DATE, STATUS STATUS, COMMENTS COMMENTS, OVERALL_PERFORMANCE_LEVEL_ID OVERALL_PERFORMANCE_LEVEL_ID, OPEN OPEN, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, SYSTEM_TYPE SYSTEM_TYPE, APPRAISAL_SYSTEM_STATUS APPRAISAL_SYSTEM_STATUS, SYSTEM_PARAMS SYSTEM_PARAMS, APPRAISEE_ACCESS APPRAISEE_ACCESS, MAIN_APPRAISER_ID MAIN_APPRAISER_ID, ASSIGNMENT_ID ASSIGNMENT_ID, ASSIGNMENT_START_DATE ASSIGNMENT_START_DATE, ASSIGNMENT_BUSINESS_GROUP_ID ASSIGNMENT_BUSINESS_GROUP_ID, ASSIGNMENT_ORGANIZATION_ID ASSIGNMENT_ORGANIZATION_ID, ASSIGNMENT_JOB_ID ASSIGNMENT_JOB_ID, ASSIGNMENT_POSITION_ID ASSIGNMENT_POSITION_ID, ASSIGNMENT_GRADE_ID ASSIGNMENT_GRADE_ID, POTENTIAL_READINESS_LEVEL POTENTIAL_READINESS_LEVEL, POTENTIAL_SHORT_TERM_WORKOPP POTENTIAL_SHORT_TERM_WORKOPP, POTENTIAL_LONG_TERM_WORKOPP POTENTIAL_LONG_TERM_WORKOPP, POTENTIAL_DETAILS POTENTIAL_DETAILS, EVENT_ID EVENT_ID, SHOW_COMPETENCY_RATINGS SHOW_COMPETENCY_RATINGS, SHOW_QUESTIONNAIRE_INFO SHOW_QUESTIONNAIRE_INFO, SHOW_OVERALL_RATINGS SHOW_OVERALL_RATINGS, SHOW_OVERALL_COMMENTS SHOW_OVERALL_COMMENTS, UPDATE_APPRAISAL UPDATE_APPRAISAL, PROVIDE_OVERALL_FEEDBACK PROVIDE_OVERALL_FEEDBACK, SHOW_OBJECTIVE_RATINGS SHOW_OBJECTIVE_RATINGS, SHOW_PARTICIPANT_DETAILS SHOW_PARTICIPANT_DETAILS, SHOW_PARTICIPANT_NAMES SHOW_PARTICIPANT_NAMES, SHOW_PARTICIPANT_RATINGS SHOW_PARTICIPANT_RATINGS, APPRAISEE_COMMENTS APPRAISEE_COMMENTS, PLAN_ID PLAN_ID, OFFLINE_STATUS OFFLINE_STATUS, RETENTION_POTENTIAL RETENTION_POTENTIAL, SHOW_PARTICIPANT_COMMENTS SHOW_PARTICIPANT_COMMENTS from "HR"."PER_APPRAISALS"

View Text - HTML Formatted

SELECT APPRAISAL_ID APPRAISAL_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, APPRAISAL_TEMPLATE_ID APPRAISAL_TEMPLATE_ID
, APPRAISEE_PERSON_ID APPRAISEE_PERSON_ID
, APPRAISER_PERSON_ID APPRAISER_PERSON_ID
, APPRAISAL_DATE APPRAISAL_DATE
, GROUP_DATE GROUP_DATE
, GROUP_INITIATOR_ID GROUP_INITIATOR_ID
, APPRAISAL_PERIOD_END_DATE APPRAISAL_PERIOD_END_DATE
, APPRAISAL_PERIOD_START_DATE APPRAISAL_PERIOD_START_DATE
, TYPE TYPE
, NEXT_APPRAISAL_DATE NEXT_APPRAISAL_DATE
, STATUS STATUS
, COMMENTS COMMENTS
, OVERALL_PERFORMANCE_LEVEL_ID OVERALL_PERFORMANCE_LEVEL_ID
, OPEN OPEN
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, SYSTEM_TYPE SYSTEM_TYPE
, APPRAISAL_SYSTEM_STATUS APPRAISAL_SYSTEM_STATUS
, SYSTEM_PARAMS SYSTEM_PARAMS
, APPRAISEE_ACCESS APPRAISEE_ACCESS
, MAIN_APPRAISER_ID MAIN_APPRAISER_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, ASSIGNMENT_START_DATE ASSIGNMENT_START_DATE
, ASSIGNMENT_BUSINESS_GROUP_ID ASSIGNMENT_BUSINESS_GROUP_ID
, ASSIGNMENT_ORGANIZATION_ID ASSIGNMENT_ORGANIZATION_ID
, ASSIGNMENT_JOB_ID ASSIGNMENT_JOB_ID
, ASSIGNMENT_POSITION_ID ASSIGNMENT_POSITION_ID
, ASSIGNMENT_GRADE_ID ASSIGNMENT_GRADE_ID
, POTENTIAL_READINESS_LEVEL POTENTIAL_READINESS_LEVEL
, POTENTIAL_SHORT_TERM_WORKOPP POTENTIAL_SHORT_TERM_WORKOPP
, POTENTIAL_LONG_TERM_WORKOPP POTENTIAL_LONG_TERM_WORKOPP
, POTENTIAL_DETAILS POTENTIAL_DETAILS
, EVENT_ID EVENT_ID
, SHOW_COMPETENCY_RATINGS SHOW_COMPETENCY_RATINGS
, SHOW_QUESTIONNAIRE_INFO SHOW_QUESTIONNAIRE_INFO
, SHOW_OVERALL_RATINGS SHOW_OVERALL_RATINGS
, SHOW_OVERALL_COMMENTS SHOW_OVERALL_COMMENTS
, UPDATE_APPRAISAL UPDATE_APPRAISAL
, PROVIDE_OVERALL_FEEDBACK PROVIDE_OVERALL_FEEDBACK
, SHOW_OBJECTIVE_RATINGS SHOW_OBJECTIVE_RATINGS
, SHOW_PARTICIPANT_DETAILS SHOW_PARTICIPANT_DETAILS
, SHOW_PARTICIPANT_NAMES SHOW_PARTICIPANT_NAMES
, SHOW_PARTICIPANT_RATINGS SHOW_PARTICIPANT_RATINGS
, APPRAISEE_COMMENTS APPRAISEE_COMMENTS
, PLAN_ID PLAN_ID
, OFFLINE_STATUS OFFLINE_STATUS
, RETENTION_POTENTIAL RETENTION_POTENTIAL
, SHOW_PARTICIPANT_COMMENTS SHOW_PARTICIPANT_COMMENTS
FROM "HR"."PER_APPRAISALS"