PAY_RANGE_DEF_LDG_OVERRIDE_V

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name

RANGE_TYPE RANGE_DEF_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE VALUE_DEFN_ID LOW_VALUE HIGH_VALUE CALC_TYPE_ID VALUE1 VALUE2 VALUE3 ENTERPRISE_ID LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY MODULE_ID SEED_STATUS SGUID VBC_VALUE_TEXT TYPE VD_SOURCE_ID VD_SOURCE_ID_RANK VD_LEGISLATIVE_DATA_GROUP_ID VD_PARENT_VALUE_DEFN_ID RI_IDS_LDG_OVER_SETS

Query

SQL_Statement

SELECT 'DEFN' range_type, rd.range_def_id, rd.effective_start_date, rd.effective_end_date, rd.value_defn_id, rd.low_value, rd.high_value, rd.calc_type_id, rd.value1, rd.value2, rd.value3, rd.enterprise_id, rd.legislation_code, rd.legislative_data_group_id, rd.object_version_number, rd.created_by, rd.creation_date, rd.last_update_date, rd.last_update_login, rd.last_updated_by, rd.module_id, rd.seed_status, rd.sguid, rd.vbc_value_text, ct.type, 1 as vd_source_id, 1 as vd_source_id_rank, 1 as vd_legislative_data_group_id, 1 as vd_parent_value_defn_id, '1' as ri_ids_ldg_over_sets FROM pay_range_defs_f rd, pay_calc_types ct WHERE rd.calc_type_id = ct.calc_type_id (+) UNION SELECT "RANGE_TYPE","RANGE_DEF_ID","EFFECTIVE_START_DATE","EFFECTIVE_END_DATE","VALUE_DEFN_ID","LOW_VALUE","HIGH_VALUE","CALC_TYPE_ID","VALUE1","VALUE2","VALUE3","ENTERPRISE_ID","LEGISLATION_CODE","LEGISLATIVE_DATA_GROUP_ID","OBJECT_VERSION_NUMBER","CREATED_BY","CREATION_DATE","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","LAST_UPDATED_BY","MODULE_ID","SEED_STATUS","SGUID","VBC_VALUE_TEXT","TYPE","VD_SOURCE_ID","VD_SOURCE_ID_RANK","VD_LEGISLATIVE_DATA_GROUP_ID","VD_PARENT_VALUE_DEFN_ID","RI_IDS_LDG_OVER_SETS" from ( SELECT range_type, range_def_id, effective_start_date, effective_end_date, value_defn_id, low_value, high_value, calc_type_id, value1, value2, value3, enterprise_id, legislation_code, legislative_data_group_id, object_version_number, created_by, creation_date, last_update_date, last_update_login, last_updated_by, module_id, seed_status, sguid, vbc_value_text, type, vd_source_id, vd_source_id_rank, vd_legislative_data_group_id, vd_parent_value_defn_id, listagg (distinct range_def_id, ',') within group (order by low_value) over (partition by vd_parent_value_defn_id,vd_legislative_data_group_id,low_value) as ri_ids_ldg_over_sets FROM PAY_RANGE_INST_LDG_OVERRIDE_V) WHERE VD_SOURCE_ID_RANK = 1