PQH EEO4 Reporting
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 ...
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
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 |