PAY NZ Generate ED Payday File

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
Application
Payroll
Source
NZ Generate ED Payday File
Short Name
PYNZED_XML
Imported from BI Publisher
DB package:

SQL 16 lines

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

Parameters 2

ParameterTypeList of values SQL
P_LEGAL_EMP_IDLOV Oracle
Archive IDLOV Oracle