VIEW: HR.PER_APPRAISAL_TEMPLATES#

Source

View Text - Preformatted

select APPRAISAL_TEMPLATE_ID APPRAISAL_TEMPLATE_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, NAME NAME, DESCRIPTION DESCRIPTION, DATE_FROM DATE_FROM, DATE_TO DATE_TO, ASSESSMENT_TYPE_ID ASSESSMENT_TYPE_ID, RATING_SCALE_ID RATING_SCALE_ID, QUESTIONNAIRE_TEMPLATE_ID QUESTIONNAIRE_TEMPLATE_ID, QUESTIONNAIRE_LANGUAGE QUESTIONNAIRE_LANGUAGE, 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, INSTRUCTIONS INSTRUCTIONS, OBJECTIVE_ASMNT_TYPE_ID OBJECTIVE_ASMNT_TYPE_ID, MA_QUEST_TEMPLATE_ID MA_QUEST_TEMPLATE_ID, LINK_APPR_TO_LEARNING_PATH LINK_APPR_TO_LEARNING_PATH, FINAL_SCORE_FORMULA_ID FINAL_SCORE_FORMULA_ID, UPDATE_PERSONAL_COMP_PROFILE UPDATE_PERSONAL_COMP_PROFILE, COMP_PROFILE_SOURCE_TYPE COMP_PROFILE_SOURCE_TYPE, SHOW_COMPETENCY_RATINGS SHOW_COMPETENCY_RATINGS, SHOW_OBJECTIVE_RATINGS SHOW_OBJECTIVE_RATINGS, SHOW_OVERALL_RATINGS SHOW_OVERALL_RATINGS, SHOW_OVERALL_COMMENTS SHOW_OVERALL_COMMENTS, PROVIDE_OVERALL_FEEDBACK PROVIDE_OVERALL_FEEDBACK, SHOW_PARTICIPANT_DETAILS SHOW_PARTICIPANT_DETAILS, ALLOW_ADD_PARTICIPANT ALLOW_ADD_PARTICIPANT, SHOW_ADDITIONAL_DETAILS SHOW_ADDITIONAL_DETAILS, SHOW_PARTICIPANT_NAMES SHOW_PARTICIPANT_NAMES, SHOW_PARTICIPANT_RATINGS SHOW_PARTICIPANT_RATINGS, AVAILABLE_FLAG AVAILABLE_FLAG, SHOW_QUESTIONNAIRE_INFO SHOW_QUESTIONNAIRE_INFO, MA_OFF_TEMPLATE_CODE MA_OFF_TEMPLATE_CODE, APPRAISEE_OFF_TEMPLATE_CODE APPRAISEE_OFF_TEMPLATE_CODE, OTHER_PART_OFF_TEMPLATE_CODE OTHER_PART_OFF_TEMPLATE_CODE, PART_REV_OFF_TEMPLATE_CODE PART_REV_OFF_TEMPLATE_CODE, PART_APP_OFF_TEMPLATE_CODE PART_APP_OFF_TEMPLATE_CODE, SHOW_PARTICIPANT_COMMENTS SHOW_PARTICIPANT_COMMENTS, SHOW_TERM_EMPLOYEE SHOW_TERM_EMPLOYEE, SHOW_TERM_CONTIGENT SHOW_TERM_CONTIGENT, SHOW_FUTURE_TERM_EMPLOYEE SHOW_FUTURE_TERM_EMPLOYEE, DISP_TERM_EMP_PERIOD_FROM DISP_TERM_EMP_PERIOD_FROM from "HR"."PER_APPRAISAL_TEMPLATES"

View Text - HTML Formatted

SELECT APPRAISAL_TEMPLATE_ID APPRAISAL_TEMPLATE_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, NAME NAME
, DESCRIPTION DESCRIPTION
, DATE_FROM DATE_FROM
, DATE_TO DATE_TO
, ASSESSMENT_TYPE_ID ASSESSMENT_TYPE_ID
, RATING_SCALE_ID RATING_SCALE_ID
, QUESTIONNAIRE_TEMPLATE_ID QUESTIONNAIRE_TEMPLATE_ID
, QUESTIONNAIRE_LANGUAGE QUESTIONNAIRE_LANGUAGE
, 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
, INSTRUCTIONS INSTRUCTIONS
, OBJECTIVE_ASMNT_TYPE_ID OBJECTIVE_ASMNT_TYPE_ID
, MA_QUEST_TEMPLATE_ID MA_QUEST_TEMPLATE_ID
, LINK_APPR_TO_LEARNING_PATH LINK_APPR_TO_LEARNING_PATH
, FINAL_SCORE_FORMULA_ID FINAL_SCORE_FORMULA_ID
, UPDATE_PERSONAL_COMP_PROFILE UPDATE_PERSONAL_COMP_PROFILE
, COMP_PROFILE_SOURCE_TYPE COMP_PROFILE_SOURCE_TYPE
, SHOW_COMPETENCY_RATINGS SHOW_COMPETENCY_RATINGS
, SHOW_OBJECTIVE_RATINGS SHOW_OBJECTIVE_RATINGS
, SHOW_OVERALL_RATINGS SHOW_OVERALL_RATINGS
, SHOW_OVERALL_COMMENTS SHOW_OVERALL_COMMENTS
, PROVIDE_OVERALL_FEEDBACK PROVIDE_OVERALL_FEEDBACK
, SHOW_PARTICIPANT_DETAILS SHOW_PARTICIPANT_DETAILS
, ALLOW_ADD_PARTICIPANT ALLOW_ADD_PARTICIPANT
, SHOW_ADDITIONAL_DETAILS SHOW_ADDITIONAL_DETAILS
, SHOW_PARTICIPANT_NAMES SHOW_PARTICIPANT_NAMES
, SHOW_PARTICIPANT_RATINGS SHOW_PARTICIPANT_RATINGS
, AVAILABLE_FLAG AVAILABLE_FLAG
, SHOW_QUESTIONNAIRE_INFO SHOW_QUESTIONNAIRE_INFO
, MA_OFF_TEMPLATE_CODE MA_OFF_TEMPLATE_CODE
, APPRAISEE_OFF_TEMPLATE_CODE APPRAISEE_OFF_TEMPLATE_CODE
, OTHER_PART_OFF_TEMPLATE_CODE OTHER_PART_OFF_TEMPLATE_CODE
, PART_REV_OFF_TEMPLATE_CODE PART_REV_OFF_TEMPLATE_CODE
, PART_APP_OFF_TEMPLATE_CODE PART_APP_OFF_TEMPLATE_CODE
, SHOW_PARTICIPANT_COMMENTS SHOW_PARTICIPANT_COMMENTS
, SHOW_TERM_EMPLOYEE SHOW_TERM_EMPLOYEE
, SHOW_TERM_CONTIGENT SHOW_TERM_CONTIGENT
, SHOW_FUTURE_TERM_EMPLOYEE SHOW_FUTURE_TERM_EMPLOYEE
, DISP_TERM_EMP_PERIOD_FROM DISP_TERM_EMP_PERIOD_FROM
FROM "HR"."PER_APPRAISAL_TEMPLATES"