PAY GB Pensions Qualifying Scheme exists

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: GB Pensions Qualifying Scheme exists
Short Name: PYGBPAEQ
DB package:
SELECT 
			 PAI.ACTION_INFORMATION14 FULL_NAME,
			 PAI.ACTION_INFORMATION15 ASSIGNMENT_NUMBER,
			 PAI.ACTION_INFORMATION1 PENSION_SCHEME_NAME,
			 PAI.ACTION_INFORMATION7 EMPLOYEE_CLASSIFICATION,
			 fnd_date.canonical_to_date(PAI.ACTION_INFORMATION17) NOM_AUTO_ENROLLMENT_DATE
			 FROM PAY_ACTION_INFORMATION PAI,
			 PAY_ASSIGNMENT_ACTIONS PAA
			 WHERE PAI.ACTION_CONTEXT_TYPE='AAP'
			 AND PAI.ACTION_INFORMATION_CATEGORY='GB_ENROLL_PENSIONS'
			 AND PAI.ACTION_CONTEXT_ID=PAA.ASSIGNMENT_ACTION_ID
			 AND PAA.PAYROLL_ACTION_ID=:P_PAYROLL_ACTION_ID
			 AND PAI.ACTION_INFORMATION9 IS NULL
			 AND PAI.ACTION_INFORMATION1 IS NOT NULL
Parameter NameSQL textValidation
Payroll Action Id
 
Number
Pay Start Date
 
Date
Pay End Date
 
Date
PRP Start Date
 
Date
PRP End Date
 
Date
Mode
 
Char
Payroll Name
 
Char
Period Name
 
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™