PJC_PAY_ELEMENT_TYPES_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
ELEMENT_TYPE_ID ELEMENT_NAME BASE_ELEMENT_NAME LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE

Query

SQL_Statement
SELECT element_type_id, element_name, base_element_name, legislative_data_group_id, legislation_code FROM pay_element_types_vl group by element_type_id, element_name, base_element_name, legislative_data_group_id, legislation_code