PQH EEO4 Reporting

➜ Back to Library
Description
Categories: BI Publisher
Columns: Cert Officer Name, Cert Official Title, Contact Name, Contact Title, Contact Address, Contact City State Zip, Contact Telephone, Control Number ...
Application: Public Sector HR
Source: EEO4 Reporting (XML)
Short Name: PQHEEO4_XML
DB package: PQH_PQHEEO4_XMLP_PKG 
SELECT 	org_information1	Cert_Officer_Name,
	org_information2	Cert_Official_Title,
	org_information3	Contact_Name,
	org_information4	Contact_Title,
	org_information5||' '||
	org_information6	Contact_Address,
	org_information7||' '||
	org_information8||' '||
	org_information9	Contact_City_State_Zip,
	org_information10	Contact_Telephone,
	org_information12	Control_number
FROM	hr_organization_information
WHERE	org_information_context	= 'EEO_REPORT'
AND	organization_id		= :p_business_group_id
AND	org_information11		= 'EEO4'
Parameter Name SQL text Validation
Reporting Year 
 
 Number
Additional Message 1 
 
Additional Message 2 
 
Additional Message 3 
 
Additional Message 4 
 
Additional Message 5 
 
Additional Message 6 
 
Additional Message 7 
 
Business Group Id 
 
Breakpoint for full-time Emp count 
 
 Number
Breakpoint for Emp Count for each function 
 
 Number
Download
Related Blitz Reports
AR Transactions and Lines CAC Inventory and Intransit Value (Period-End) PAY Business Payrolls Survey CAC Material Account Summary CAC Margin Analysis Summary CAC WIP Account Summary CAC Receiving Account Summary PER Saudi Contract Expiry OPM WIP Value PER Saudi Passport Expiry
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: