PER Terminations (1)

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Terminations Report
Application: Human Resources
Source: Terminations Report (XML)
Short Name: PERRPRTM_XML
DB package: PER_PERRPRTM_XMLP_PKG
SELECT A.ORGANIZATION_ID ORGANIZATION_ID1,
	count(distinct
		decode(:P_LEAV_REASON1,null,null, &P_REASON_COLUMN,
		P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason1_tot,
	count(distinct
		decode(:P_LEAV_REASON2,null,null,&P_REASON_COLUMN,
		P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason2_tot,
	count(distinct
		decode(:P_LEAV_REASON3,null,null, &P_REASON_COLUMN,
		P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason3_tot,
	count(distinct
		decode(:P_LEAV_REASON4,null,null,&P_REASON_COLUMN,
		P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason4_tot,
	count(distinct
		decode(:P_LEAV_REASON5,null,null,&P_REASON_COLUMN,
		P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason5_tot,
	count(distinct
		decode(:P_LEAV_REASON6,null,null,&P_REASON_COLUMN,
		P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason6_tot,
           count(distinct
                   decode(&P_REASON_COLUMN,
                        decode(:P_LEAV_REASON1,null,'999',:P_LEAV_REASON1),
                                        P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,
                        decode(:P_LEAV_REASON2,null,'999',:P_LEAV_REASON2),
                                        P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,
                        decode(:P_LEAV_REASON3,null,'999',:P_LEAV_REASON3),
                                        P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,
                        decode(:P_LEAV_REASON4,null,'999',:P_LEAV_REASON4),
                                        P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,
                        decode(:P_LEAV_REASON5,null,'999',:P_LEAV_REASON5),
                                        P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,
                        decode(:P_LEAV_REASON5,null,'999',:P_LEAV_REASON5),
                                        P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,
                                              null)) reasons_tot,
            count(distinct P.PERSON_ID||P.ACTUAL_TERMINATION_DATE) all_total
FROM   PER_PERIODS_OF_SERVICE P,
	PER_ASSIGNMENTS_F A
WHERE  P.PERIOD_OF_SERVICE_ID = A.PERIOD_OF_SERVICE_ID
	AND  A.ASSIGNMENT_TYPE = 'E'
	AND  P.ACTUAL_TERMINATION_DATE BETWEEN
		A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE
	AND  P.ACTUAL_TERMINATION_DATE BETWEEN
		:P_DATE_FROM AND :P_DATE_TO
 and A.ORGANIZATION_ID=:org_id
group by A.ORGANIZATION_ID
Parameter NameSQL textValidation
Effective Date
 
Date
Organization Structure
 
LOV Oracle
Version
 
LOV Oracle
Parent Organization
 
LOV Oracle
Date From
 
Date
Date To
 
Date
Termination Reason 1
 
LOV Oracle
Termination Reason 2
 
LOV Oracle
Termination Reason 3
 
LOV Oracle
Termination Reason 4
 
LOV Oracle
Termination Reason 5
 
LOV Oracle
Termination Reason 6
 
LOV Oracle
Download
Related Blitz Reports
AP Employee Update Program- Not Supported: Reserved For Future Use RKD Employee Element History PER Terminations PER Employee Length of Service PAY End of Year Reconciliation Summary Totals PQH EEO5 Reporting PER Terminations and Separations PER Payroll Element Entry Upload BEN Back-out Life Events Summary BEN Back-out Life Events Audit Log
Blitz Report™