PAY Payroll Element Details

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Master data report showing HR payroll element details.
Elements are the units used to build all the earnings, deductions and benefits that companies can give to employees.

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
petfv.element_name,
petfv.reporting_name,
petfv.description,
pec.classification_name,
pec.legislation_code,
petfv.input_currency_code,
petfv.output_currency_code,
xxen_util.meaning(petfv.additional_entry_allowed_flag,'YES_NO',0) additional_entry_allowed,
xxen_util.meaning(petfv.adjustment_only_flag,'YES_NO',0) adjustment_only,
xxen_util.meaning(petfv.closed_for_entry_flag,'YES_NO',0) closed_for_entry,
xxen_util.meaning(petfv.multiple_entries_allowed_flag,'YES_NO',0) multiple_entries_allowed,
xxen_util.meaning(petfv.process_in_run_flag,'YES_NO',0) process_in_run,
xxen_util.meaning(petfv.standard_link_flag,'YES_NO',0) standard_link,
xxen_util.meaning(petfv.processing_type,'PROCESSING_TYPE',3) processing_type,
xxen_util.meaning(petfv.post_termination_rule,'TERMINATION_RULE',3) post_termination_rule,
petfv.effective_start_date,
petfv.effective_end_date,
petfv.processing_priority,
xxen_util.user_name(petfv.created_by) created_by,
xxen_util.client_time(petfv.creation_date) creation_date,
xxen_util.user_name(petfv.last_updated_by) last_updated_by,
xxen_util.client_time(petfv.last_update_date) last_update_date,
petfv.element_type_id
from
pay_element_types_f_vl petfv, 
pay_element_classifications pec
where
1=1 and
petfv.classification_id=pec.classification_id
Parameter Name SQL text Validation
Effective Date 
:effective_date between petfv.effective_start_date and petfv.effective_end_date
 Date
Download
 
Related Blitz Reports
PAY Employee Payroll History PAY Payroll Reconciliation Detail SSP ShPP Adoption Element Results SSP ShPP Birth Element Results PAY List Payroll Actions and Results By Person PAY Employee Run Results PAY Employee Run Results Report (CA) PAY Fringe Benefits PER Pay Element Details
Blitz Report™

Blitz Report™ provides multiple benefits: