HRA_EVAL_SECTIONS

Details

Schema: FUSION
Object owner: HRA
Object type: VIEW

Columns

Name
EVAL_SECTION_ID ENABLE_SECTION_COMMENTS_FLAG BUSINESS_GROUP_ID TMPL_SECTION_ID CONTENT_TYPE_ID EVALUATION_ID SEQUENCE_NUMBER SECTION_TYPE_CODE RATE_SECTION_FLAG CALCULATION_RULE_CODE FAST_FORMULA_ID SECTION_RATING_MODEL_ID WEIGHT_SECTION_FLAG SECTION_WEIGHT SECTION_MIN_WEIGHT ENABLE_ITEMS FREE_FORM_ALLOWED_FLAG RATE_ITEM_FLAG RATING_TYPE_CODE USE_SECRTG_FOR_PERFRTG_FLAG PERF_RATING_MODEL_ID ITEM_CALCULATION_CODE SHOW_TARGET_PERF_RTG SHOW_TARGET_PROF_LEVEL ADD_ITEMS_CONFIRM_CRIT_FLAG SECTION_WEIGHT_FLAG SECTION_MIN_WEIGHT_FLAG SHOW_MANDATORY SHOW_CRITICAL SHOW_DESCRIPTION SHOW_MEASUREMENT SHOW_DUE_DATE SHOW_REMINDER_DATE SHOW_OWNED_BY SHOW_STATUS SHOW_PERCENT_COMPLETE PROFILE_TYPE_ID PROFILE_ID RATING_OVERIDE_FLAG USE_PROFILE_FLAG USE_SPEC_PROFILE_FLAG USE_SPEC_CONTENT_ITEM_FLAG USE_WORKER_GOALS_FLAG COMMENTS OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN USE_WRITING_ASSISTANT_FLAG COMMENT_TEXT ROUNDING_RULE_CODE DECIMAL_PLACES MAPPING_METHOD_CODE CALC_MAPPING_CODE USE_SEC_WEIGHTS_FOR_CALC

Name

EVAL_SECTION_ID

ENABLE_SECTION_COMMENTS_FLAG

BUSINESS_GROUP_ID

TMPL_SECTION_ID

CONTENT_TYPE_ID

EVALUATION_ID

SEQUENCE_NUMBER

SECTION_TYPE_CODE

RATE_SECTION_FLAG

CALCULATION_RULE_CODE

FAST_FORMULA_ID

SECTION_RATING_MODEL_ID

WEIGHT_SECTION_FLAG

SECTION_WEIGHT

SECTION_MIN_WEIGHT

ENABLE_ITEMS

FREE_FORM_ALLOWED_FLAG

RATE_ITEM_FLAG

RATING_TYPE_CODE

USE_SECRTG_FOR_PERFRTG_FLAG

PERF_RATING_MODEL_ID

ITEM_CALCULATION_CODE

SHOW_TARGET_PERF_RTG

SHOW_TARGET_PROF_LEVEL

ADD_ITEMS_CONFIRM_CRIT_FLAG

SECTION_WEIGHT_FLAG

SECTION_MIN_WEIGHT_FLAG

SHOW_MANDATORY

SHOW_CRITICAL

SHOW_DESCRIPTION

SHOW_MEASUREMENT

SHOW_DUE_DATE

SHOW_REMINDER_DATE

SHOW_OWNED_BY

SHOW_STATUS

SHOW_PERCENT_COMPLETE

PROFILE_TYPE_ID

PROFILE_ID

RATING_OVERIDE_FLAG

USE_PROFILE_FLAG

USE_SPEC_PROFILE_FLAG

USE_SPEC_CONTENT_ITEM_FLAG

USE_WORKER_GOALS_FLAG

COMMENTS

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

USE_WRITING_ASSISTANT_FLAG

COMMENT_TEXT

ROUNDING_RULE_CODE

DECIMAL_PLACES

MAPPING_METHOD_CODE

CALC_MAPPING_CODE

USE_SEC_WEIGHTS_FOR_CALC

Query

SQL_Statement
SELECT HRA_EVAL_SECTIONS.EVAL_SECTION_ID EVAL_SECTION_ID, HRA_EVAL_SECTIONS.ENABLE_SECTION_COMMENTS_FLAG ENABLE_SECTION_COMMENTS_FLAG, HRA_EVAL_SECTIONS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, HRA_EVAL_SECTIONS.TMPL_SECTION_ID TMPL_SECTION_ID, HRA_EVAL_SECTIONS.CONTENT_TYPE_ID CONTENT_TYPE_ID, HRA_EVAL_SECTIONS.EVALUATION_ID EVALUATION_ID, HRA_EVAL_SECTIONS.SEQUENCE_NUMBER SEQUENCE_NUMBER, HRA_EVAL_SECTIONS.SECTION_TYPE_CODE SECTION_TYPE_CODE, HRA_EVAL_SECTIONS.RATE_SECTION_FLAG RATE_SECTION_FLAG, HRA_EVAL_SECTIONS.CALCULATION_RULE_CODE CALCULATION_RULE_CODE, HRA_EVAL_SECTIONS.FAST_FORMULA_ID FAST_FORMULA_ID, HRA_EVAL_SECTIONS.SECTION_RATING_MODEL_ID SECTION_RATING_MODEL_ID, HRA_EVAL_SECTIONS.WEIGHT_SECTION_FLAG WEIGHT_SECTION_FLAG, HRA_EVAL_SECTIONS.SECTION_WEIGHT SECTION_WEIGHT, HRA_EVAL_SECTIONS.SECTION_MIN_WEIGHT SECTION_MIN_WEIGHT, HRA_EVAL_SECTIONS.ENABLE_ITEMS ENABLE_ITEMS, HRA_EVAL_SECTIONS.FREE_FORM_ALLOWED_FLAG FREE_FORM_ALLOWED_FLAG, HRA_EVAL_SECTIONS.RATE_ITEM_FLAG RATE_ITEM_FLAG, HRA_EVAL_SECTIONS.RATING_TYPE_CODE RATING_TYPE_CODE, HRA_EVAL_SECTIONS.USE_SECRTG_FOR_PERFRTG_FLAG USE_SECRTG_FOR_PERFRTG_FLAG, HRA_EVAL_SECTIONS.PERF_RATING_MODEL_ID PERF_RATING_MODEL_ID, HRA_EVAL_SECTIONS.ITEM_CALCULATION_CODE ITEM_CALCULATION_CODE, HRA_EVAL_SECTIONS.SHOW_TARGET_PERF_RTG SHOW_TARGET_PERF_RTG, HRA_EVAL_SECTIONS.SHOW_TARGET_PROF_LEVEL SHOW_TARGET_PROF_LEVEL, HRA_EVAL_SECTIONS.ADD_ITEMS_CONFIRM_CRIT_FLAG ADD_ITEMS_CONFIRM_CRIT_FLAG, HRA_EVAL_SECTIONS.SECTION_WEIGHT_FLAG SECTION_WEIGHT_FLAG, HRA_EVAL_SECTIONS.SECTION_MIN_WEIGHT_FLAG SECTION_MIN_WEIGHT_FLAG, HRA_EVAL_SECTIONS.SHOW_MANDATORY SHOW_MANDATORY, HRA_EVAL_SECTIONS.SHOW_CRITICAL SHOW_CRITICAL, HRA_EVAL_SECTIONS.SHOW_DESCRIPTION SHOW_DESCRIPTION, HRA_EVAL_SECTIONS.SHOW_MEASUREMENT SHOW_MEASUREMENT, HRA_EVAL_SECTIONS.SHOW_DUE_DATE SHOW_DUE_DATE, HRA_EVAL_SECTIONS.SHOW_REMINDER_DATE SHOW_REMINDER_DATE, HRA_EVAL_SECTIONS.SHOW_OWNED_BY SHOW_OWNED_BY, HRA_EVAL_SECTIONS.SHOW_STATUS SHOW_STATUS, HRA_EVAL_SECTIONS.SHOW_PERCENT_COMPLETE SHOW_PERCENT_COMPLETE, HRA_EVAL_SECTIONS.PROFILE_TYPE_ID PROFILE_TYPE_ID, HRA_EVAL_SECTIONS.PROFILE_ID PROFILE_ID, HRA_EVAL_SECTIONS.RATING_OVERIDE_FLAG RATING_OVERIDE_FLAG, HRA_EVAL_SECTIONS.USE_PROFILE_FLAG USE_PROFILE_FLAG, HRA_EVAL_SECTIONS.USE_SPEC_PROFILE_FLAG USE_SPEC_PROFILE_FLAG, HRA_EVAL_SECTIONS.USE_SPEC_CONTENT_ITEM_FLAG USE_SPEC_CONTENT_ITEM_FLAG, HRA_EVAL_SECTIONS.USE_WORKER_GOALS_FLAG USE_WORKER_GOALS_FLAG, SUBSTR(HRA_EVAL_SECTIONS.COMMENT_TEXT, 1, 4000) COMMENTS, HRA_EVAL_SECTIONS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HRA_EVAL_SECTIONS.CREATED_BY CREATED_BY, HRA_EVAL_SECTIONS.CREATION_DATE CREATION_DATE, HRA_EVAL_SECTIONS.LAST_UPDATED_BY LAST_UPDATED_BY, HRA_EVAL_SECTIONS.LAST_UPDATE_DATE LAST_UPDATE_DATE, HRA_EVAL_SECTIONS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HRA_EVAL_SECTIONS.USE_WRITING_ASSISTANT_FLAG USE_WRITING_ASSISTANT_FLAG, HRA_EVAL_SECTIONS.COMMENT_TEXT COMMENT_TEXT, HRA_EVAL_SECTIONS.ROUNDING_RULE_CODE ROUNDING_RULE_CODE, HRA_EVAL_SECTIONS.DECIMAL_PLACES DECIMAL_PLACES, HRA_EVAL_SECTIONS.MAPPING_METHOD_CODE MAPPING_METHOD_CODE, HRA_EVAL_SECTIONS.CALC_MAPPING_CODE CALC_MAPPING_CODE, HRA_EVAL_SECTIONS.USE_SEC_WEIGHTS_FOR_CALC USE_SEC_WEIGHTS_FOR_CALC FROM HRA_EVAL_SECTIONS

SQL_Statement

SELECT

HRA_EVAL_SECTIONS.EVAL_SECTION_ID EVAL_SECTION_ID,

HRA_EVAL_SECTIONS.ENABLE_SECTION_COMMENTS_FLAG ENABLE_SECTION_COMMENTS_FLAG,

HRA_EVAL_SECTIONS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID,

HRA_EVAL_SECTIONS.TMPL_SECTION_ID TMPL_SECTION_ID,

HRA_EVAL_SECTIONS.CONTENT_TYPE_ID CONTENT_TYPE_ID,

HRA_EVAL_SECTIONS.EVALUATION_ID EVALUATION_ID,

HRA_EVAL_SECTIONS.SEQUENCE_NUMBER SEQUENCE_NUMBER,

HRA_EVAL_SECTIONS.SECTION_TYPE_CODE SECTION_TYPE_CODE,

HRA_EVAL_SECTIONS.RATE_SECTION_FLAG RATE_SECTION_FLAG,

HRA_EVAL_SECTIONS.CALCULATION_RULE_CODE CALCULATION_RULE_CODE,

HRA_EVAL_SECTIONS.FAST_FORMULA_ID FAST_FORMULA_ID,

HRA_EVAL_SECTIONS.SECTION_RATING_MODEL_ID SECTION_RATING_MODEL_ID,

HRA_EVAL_SECTIONS.WEIGHT_SECTION_FLAG WEIGHT_SECTION_FLAG,

HRA_EVAL_SECTIONS.SECTION_WEIGHT SECTION_WEIGHT,

HRA_EVAL_SECTIONS.SECTION_MIN_WEIGHT SECTION_MIN_WEIGHT,

HRA_EVAL_SECTIONS.ENABLE_ITEMS ENABLE_ITEMS,

HRA_EVAL_SECTIONS.FREE_FORM_ALLOWED_FLAG FREE_FORM_ALLOWED_FLAG,

HRA_EVAL_SECTIONS.RATE_ITEM_FLAG RATE_ITEM_FLAG,

HRA_EVAL_SECTIONS.RATING_TYPE_CODE RATING_TYPE_CODE,

HRA_EVAL_SECTIONS.USE_SECRTG_FOR_PERFRTG_FLAG USE_SECRTG_FOR_PERFRTG_FLAG,

HRA_EVAL_SECTIONS.PERF_RATING_MODEL_ID PERF_RATING_MODEL_ID,

HRA_EVAL_SECTIONS.ITEM_CALCULATION_CODE ITEM_CALCULATION_CODE,

HRA_EVAL_SECTIONS.SHOW_TARGET_PERF_RTG SHOW_TARGET_PERF_RTG,

HRA_EVAL_SECTIONS.SHOW_TARGET_PROF_LEVEL SHOW_TARGET_PROF_LEVEL,

HRA_EVAL_SECTIONS.ADD_ITEMS_CONFIRM_CRIT_FLAG ADD_ITEMS_CONFIRM_CRIT_FLAG,

HRA_EVAL_SECTIONS.SECTION_WEIGHT_FLAG SECTION_WEIGHT_FLAG,

HRA_EVAL_SECTIONS.SECTION_MIN_WEIGHT_FLAG SECTION_MIN_WEIGHT_FLAG,

HRA_EVAL_SECTIONS.SHOW_MANDATORY SHOW_MANDATORY,

HRA_EVAL_SECTIONS.SHOW_CRITICAL SHOW_CRITICAL,

HRA_EVAL_SECTIONS.SHOW_DESCRIPTION SHOW_DESCRIPTION,

HRA_EVAL_SECTIONS.SHOW_MEASUREMENT SHOW_MEASUREMENT,

HRA_EVAL_SECTIONS.SHOW_DUE_DATE SHOW_DUE_DATE,

HRA_EVAL_SECTIONS.SHOW_REMINDER_DATE SHOW_REMINDER_DATE,

HRA_EVAL_SECTIONS.SHOW_OWNED_BY SHOW_OWNED_BY,

HRA_EVAL_SECTIONS.SHOW_STATUS SHOW_STATUS,

HRA_EVAL_SECTIONS.SHOW_PERCENT_COMPLETE SHOW_PERCENT_COMPLETE,

HRA_EVAL_SECTIONS.PROFILE_TYPE_ID PROFILE_TYPE_ID,

HRA_EVAL_SECTIONS.PROFILE_ID PROFILE_ID,

HRA_EVAL_SECTIONS.RATING_OVERIDE_FLAG RATING_OVERIDE_FLAG,

HRA_EVAL_SECTIONS.USE_PROFILE_FLAG USE_PROFILE_FLAG,

HRA_EVAL_SECTIONS.USE_SPEC_PROFILE_FLAG USE_SPEC_PROFILE_FLAG,

HRA_EVAL_SECTIONS.USE_SPEC_CONTENT_ITEM_FLAG USE_SPEC_CONTENT_ITEM_FLAG,

HRA_EVAL_SECTIONS.USE_WORKER_GOALS_FLAG USE_WORKER_GOALS_FLAG,

SUBSTR(HRA_EVAL_SECTIONS.COMMENT_TEXT, 1, 4000) COMMENTS,

HRA_EVAL_SECTIONS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

HRA_EVAL_SECTIONS.CREATED_BY CREATED_BY,

HRA_EVAL_SECTIONS.CREATION_DATE CREATION_DATE,

HRA_EVAL_SECTIONS.LAST_UPDATED_BY LAST_UPDATED_BY,

HRA_EVAL_SECTIONS.LAST_UPDATE_DATE LAST_UPDATE_DATE,

HRA_EVAL_SECTIONS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

HRA_EVAL_SECTIONS.USE_WRITING_ASSISTANT_FLAG USE_WRITING_ASSISTANT_FLAG,

HRA_EVAL_SECTIONS.COMMENT_TEXT COMMENT_TEXT,

HRA_EVAL_SECTIONS.ROUNDING_RULE_CODE ROUNDING_RULE_CODE,

HRA_EVAL_SECTIONS.DECIMAL_PLACES DECIMAL_PLACES,

HRA_EVAL_SECTIONS.MAPPING_METHOD_CODE MAPPING_METHOD_CODE,

HRA_EVAL_SECTIONS.CALC_MAPPING_CODE CALC_MAPPING_CODE,

HRA_EVAL_SECTIONS.USE_SEC_WEIGHTS_FOR_CALC USE_SEC_WEIGHTS_FOR_CALC

FROM

HRA_EVAL_SECTIONS