PAY NZ Generate ED Payday File

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Payroll
Source: NZ Generate ED Payday File
Short Name: PYNZED_XML
DB package: 
SELECT  paa.assignment_action_id ASG_ACTION_ID
						,pai.ACTION_INFORMATION1 asg_no
						,pai.ACTION_INFORMATION2 emp_start_date
						,pai.ACTION_INFORMATION3 emp_end_date						
						,pai.ACTION_INFORMATION4 emp_ird_no
						,pai.ACTION_INFORMATION5 emp_name
						,pai.ACTION_INFORMATION6 email
						,pai.ACTION_INFORMATION7 kiwisaver_status
					FROM    pay_action_information pai
						,pay_assignment_actions paa
					WHERE   pai.action_context_id = paa.assignment_action_id
					AND     paa.payroll_action_id = :P_PAYROLL_ACTION_ID
					AND     pai.action_context_type = 'AAP'
					AND     pai.action_information_category = 'NZ_PED_ARCHIVE_ASG_DETAILS'
					AND		pai.ACTION_INFORMATION9 is null
Parameter Name SQL text Validation
P_LEGAL_EMP_ID 
 
 LOV Oracle
Archive ID 
 
 LOV Oracle
Download
Related Blitz Reports
PAY Payroll Reconciliation Detail PAY P46 EDI Process v6 Output PQP Generate MCR CSV PAY P46EXP EDI Process v6 Output PAY GB Pensions Automatic Enrollment not applied PAY Payroll Tax Report by Legal Employer PAY GB BIK Audit PAY RTI - Earlier Year Update Output 2014/15 PQP Teachers Pension MCR Reconciliation Report (Excel) PAY RTI ? Employer Alignment Submission Output
Blitz Report™

Blitz Report™ provides multiple benefits: