PQH EEO4 Reporting

Description
Categories: BI Publisher, Human Resources
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
Breakpoint for Emp Count for each function
 
Number
Breakpoint for full-time Emp count
 
Number
Business Group Id
 
Additional Message 7
 
Additional Message 6
 
Additional Message 5
 
Additional Message 4
 
Additional Message 3
 
Additional Message 2
 
Additional Message 1
 
Reporting Year
 
Number