HRA_SECTION_DEFNS_VL

Details

  • Schema: FUSION

  • Object owner: HRA

  • Object type: VIEW

Columns

Name

SECTION_DEF_ID

BUSINESS_GROUP_ID

NAME

DESCRIPTION

COMMENTS

DATE_FROM

DATE_TO

STATUS_CODE

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_FLAG

CONTENT_PROFILE_FLAG

CONTENT_TYPE_ID

FREE_FORM_ALLOWED_FLAG

ADD_ITEMS_CONFIRM_CRIT_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

SHOW_SECTION_WEIGHT

SHOW_SECTION_MIN_WEIGHT

SHOW_MANDATORY

SHOW_CRITICAL

SHOW_DESCRIPTION

SHOW_MEASUREMENT

SHOW_DUE_DATE

SHOW_REMINDER_DATE

SHOW_OWNED_BY

SHOW_STATUS

SHOW_PERCENT_COMPLETE

USE_PROFILE_FLAG

PROFILE_TYPE_ID

USE_SPEC_PROFILE_FLAG

PROFILE_ID

USE_WORKER_GOALS_FLAG

USE_SPEC_CONTENT_ITEM_FLAG

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

MODULE_ID

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_NUMBER11

ATTRIBUTE_NUMBER12

ATTRIBUTE_NUMBER13

ATTRIBUTE_NUMBER14

ATTRIBUTE_NUMBER15

ATTRIBUTE_NUMBER16

ATTRIBUTE_NUMBER17

ATTRIBUTE_NUMBER18

ATTRIBUTE_NUMBER19

ATTRIBUTE_NUMBER20

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_DATE11

ATTRIBUTE_DATE12

ATTRIBUTE_DATE13

ATTRIBUTE_DATE14

ATTRIBUTE_DATE15

USE_WRITING_ASSISTANT_FLAG

ROUNDING_RULE_CODE

DECIMAL_PLACES

MAPPING_METHOD_CODE

CALC_MAPPING_CODE

USE_SEC_WEIGHTS_FOR_CALC

ENABLE_CHILD_ITEMS_FLAG

INCLUDE_FUTURE_ITEMS_FLAG

EXCLUDE_INACTIVE_ITEMS_FLAG

UPDATE_GOAL_WEIGHTS_FLAG

REFERENCE_SECTION_ID

ENABLE_SECTION_COMMENTS_FLAG

ENABLE_ITEM_COMMENTS_FLAG

EVALUATION_TYPE_CODE

ENABLE_SYNC_FLAG

INCLUDE_QSTNR_SCORING_FLAG

INCLUDE_QSTNR_SCORE_OS_FLAG

ENABLE_MGR_REASON_FLAG

Query

SQL_Statement

SELECT

SD.SECTION_DEF_ID,

SD.BUSINESS_GROUP_ID,

SDTL.NAME,

SDTL.DESCRIPTION,

SDTL.COMMENTS,

SD.DATE_FROM,

SD.DATE_TO,

SD.STATUS_CODE,

SD.SECTION_TYPE_CODE,

SD.RATE_SECTION_FLAG,

SD.CALCULATION_RULE_CODE,

SD.FAST_FORMULA_ID,

SD.SECTION_RATING_MODEL_ID,

SD.WEIGHT_SECTION_FLAG,

SD.SECTION_WEIGHT,

SD.SECTION_MIN_WEIGHT,

SD.ENABLE_ITEMS_FLAG,

SD.CONTENT_PROFILE_FLAG,

SD.CONTENT_TYPE_ID,

SD.FREE_FORM_ALLOWED_FLAG,

SD.ADD_ITEMS_CONFIRM_CRIT_FLAG,

SD.RATE_ITEM_FLAG,

SD.RATING_TYPE_CODE,

SD.USE_SECRTG_FOR_PERFRTG_FLAG,

SD.PERF_RATING_MODEL_ID,

SD.ITEM_CALCULATION_CODE,

SD.SHOW_TARGET_PERF_RTG,

SD.SHOW_TARGET_PROF_LEVEL,

SD.SHOW_SECTION_WEIGHT,

SD.SHOW_SECTION_MIN_WEIGHT,

SD.SHOW_MANDATORY,

SD.SHOW_CRITICAL,

SD.SHOW_DESCRIPTION,

SD.SHOW_MEASUREMENT,

SD.SHOW_DUE_DATE,

SD.SHOW_REMINDER_DATE,

SD.SHOW_OWNED_BY,

SD.SHOW_STATUS,

SD.SHOW_PERCENT_COMPLETE,

SD.USE_PROFILE_FLAG,

SD.PROFILE_TYPE_ID,

SD.USE_SPEC_PROFILE_FLAG,

SD.PROFILE_ID,

SD.USE_WORKER_GOALS_FLAG,

SD.USE_SPEC_CONTENT_ITEM_FLAG,

SD.ATTRIBUTE_CATEGORY,

SD.ATTRIBUTE1,

SD.ATTRIBUTE2,

SD.ATTRIBUTE3,

SD.ATTRIBUTE4,

SD.ATTRIBUTE5,

SD.ATTRIBUTE6,

SD.ATTRIBUTE7,

SD.ATTRIBUTE8,

SD.ATTRIBUTE9,

SD.ATTRIBUTE10,

SD.ATTRIBUTE11,

SD.ATTRIBUTE12,

SD.ATTRIBUTE13,

SD.ATTRIBUTE14,

SD.ATTRIBUTE15,

SD.ATTRIBUTE16,

SD.ATTRIBUTE17,

SD.ATTRIBUTE18,

SD.ATTRIBUTE19,

SD.ATTRIBUTE20,

SD.ATTRIBUTE21,

SD.ATTRIBUTE22,

SD.ATTRIBUTE23,

SD.ATTRIBUTE24,

SD.ATTRIBUTE25,

SD.ATTRIBUTE26,

SD.ATTRIBUTE27,

SD.ATTRIBUTE28,

SD.ATTRIBUTE29,

SD.ATTRIBUTE30,

SD.OBJECT_VERSION_NUMBER,

SD.CREATED_BY,

SD.CREATION_DATE,

SD.LAST_UPDATE_DATE,

SD.LAST_UPDATED_BY,

SD.LAST_UPDATE_LOGIN,

SD.MODULE_ID,

SD.ATTRIBUTE_NUMBER1,

SD.ATTRIBUTE_NUMBER2,

SD.ATTRIBUTE_NUMBER3,

SD.ATTRIBUTE_NUMBER4,

SD.ATTRIBUTE_NUMBER5,

SD.ATTRIBUTE_NUMBER6,

SD.ATTRIBUTE_NUMBER7,

SD.ATTRIBUTE_NUMBER8,

SD.ATTRIBUTE_NUMBER9,

SD.ATTRIBUTE_NUMBER10,

SD.ATTRIBUTE_NUMBER11,

SD.ATTRIBUTE_NUMBER12,

SD.ATTRIBUTE_NUMBER13,

SD.ATTRIBUTE_NUMBER14,

SD.ATTRIBUTE_NUMBER15,

SD.ATTRIBUTE_NUMBER16,

SD.ATTRIBUTE_NUMBER17,

SD.ATTRIBUTE_NUMBER18,

SD.ATTRIBUTE_NUMBER19,

SD.ATTRIBUTE_NUMBER20,

SD.ATTRIBUTE_DATE1,

SD.ATTRIBUTE_DATE2,

SD.ATTRIBUTE_DATE3,

SD.ATTRIBUTE_DATE4,

SD.ATTRIBUTE_DATE5,

SD.ATTRIBUTE_DATE6,

SD.ATTRIBUTE_DATE7,

SD.ATTRIBUTE_DATE8,

SD.ATTRIBUTE_DATE9,

SD.ATTRIBUTE_DATE10,

SD.ATTRIBUTE_DATE11,

SD.ATTRIBUTE_DATE12,

SD.ATTRIBUTE_DATE13,

SD.ATTRIBUTE_DATE14,

SD.ATTRIBUTE_DATE15,

SD.USE_WRITING_ASSISTANT_FLAG,

SD.ROUNDING_RULE_CODE,

SD.DECIMAL_PLACES,

SD.MAPPING_METHOD_CODE,

SD.CALC_MAPPING_CODE,

SD.USE_SEC_WEIGHTS_FOR_CALC,

SD.ENABLE_CHILD_ITEMS_FLAG,

SD.INCLUDE_FUTURE_ITEMS_FLAG,

SD.EXCLUDE_INACTIVE_ITEMS_FLAG,

SD.UPDATE_GOAL_WEIGHTS_FLAG,

SD.REFERENCE_SECTION_ID,

SD.ENABLE_SECTION_COMMENTS_FLAG,

SD.ENABLE_ITEM_COMMENTS_FLAG,

SD.EVALUATION_TYPE_CODE,

SD.ENABLE_SYNC_FLAG,

SD.INCLUDE_QSTNR_SCORING_FLAG,

SD.INCLUDE_QSTNR_SCORE_OS_FLAG,

SD.ENABLE_MGR_REASON_FLAG

FROM

HRA_SECTION_DEFNS_B SD,

HRA_SECTION_DEFNS_TL SDTL

WHERE

SD.SECTION_DEF_ID = SDTL.SECTION_DEF_ID AND SD.BUSINESS_GROUP_ID = SDTL.BUSINESS_GROUP_ID AND SDTL.LANGUAGE = USERENV('LANG')