PAY PQP GB Scottish LGPS End of Year Report Output

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: PQP GB Scottish LGPS End of Year Report Output
Short Name: PQGBSCLGPSROP
DB package:
					select     
						arch.ACTION_INFORMATION1 FORE_NAME,
						arch.ACTION_INFORMATION2 SUR_NAME,
						arch.ACTION_INFORMATION3 NINO,
						arch.ACTION_INFORMATION4 GENDER,
						arch.ACTION_INFORMATION5 DOB,
						arch.ACTION_INFORMATION6 CPP1,
						arch.ACTION_INFORMATION7 CPP2,
						arch.ACTION_INFORMATION9 CEC2,
						arch.ACTION_INFORMATION8 CRC,
						arch.ACTION_INFORMATION10 CEC1,
						arch.ACTION_INFORMATION11 EAPC,
						arch.ACTION_INFORMATION12 EAVC,
						arch.ACTION_INFORMATION13 RAPC,
						arch.ACTION_INFORMATION14 RAVC,
						arch.ACTION_INFORMATION15 PP,
						arch.ACTION_INFORMATION17 asg_num
						From pay_action_information arch,
						pay_assignment_actions paa
						where 
						paa.payroll_action_id = :PAYROLL_ACTION_ID
						and arch.ACTION_CONTEXT_ID = paa.ASSIGNMENT_ACTION_ID
						and arch.ACTION_CONTEXT_TYPE = 'AAP'
						and arch.ACTION_INFORMATION_CATEGORY = 'PQP GB SC LGPS DETAILS'
				  	order by arch.ACTION_INFORMATION17
Parameter NameSQL textValidation
payroll_action_id
 
Char
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™