PAY GB Pensions Automatic Enrollment not applied

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: GB Pensions Automatic Enrollment not applied
Short Name: PYGBPAENR
DB package:
SELECT PAI.ACTION_INFORMATION15 ASSIGNMENT_NUMBER,
		 PAI.ACTION_INFORMATION14 FULL_NAME,
		 PAI.ACTION_INFORMATION7 EMPLOYEE_CLASSIFICATION,
		 fnd_date.canonical_to_date(PAI.ACTION_INFORMATION8) FIRST_FOUND_ELIG_DATE,
		 fnd_date.canonical_to_date(PAI.ACTION_INFORMATION6) POST_PERIOD_END_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 fnd_date.canonical_to_date(PAI.ACTION_INFORMATION6) >= :P_PRP_END_DATE 
		 AND PAI.ACTION_INFORMATION9 IS NULL
		 AND PAI.ACTION_INFORMATION5='Eligible Job Holder Postponement'
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 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™