HRA_SECTION_DEFNS

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

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')

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')