GHR CPDF Organizational Component Translation
Description
Categories: BI Publisher
Application: US Federal Human Resources
Source: CPDF Organizational Component Translation Report (XML)
Short Name: GHRCPDFO_XML
DB package: GHR_GHRCPDFO_XMLP_PKG
Source: CPDF Organizational Component Translation Report (XML)
Short Name: GHRCPDFO_XML
DB package: GHR_GHRCPDFO_XMLP_PKG
SELECT AGENCY, COMPONENT, TITLE, MIN(L_COUNT) FROM (SELECT FROM_BASIC_PAY SORT_BY, AGENCY_CODE AGENCY, ORGANIZATIONAL_COMPONENT COMPONENT, LPAD(' ',2 * (FROM_LOCALITY_ADJ - 1)) ||RPAD(FROM_OCC_CODE ||FROM_NATIONAL_IDENTIFIER,179,' ') TITLE, NVL(FROM_LOCALITY_ADJ,0) L_LEVEL, FROM_BASIC_PAY L_COUNT FROM GHR_CPDF_TEMP WHERE REPORT_TYPE = 'GHRCPDFO' AND SESSION_ID = USERENV('sessionid') order by L_COUNT ) GROUP BY AGENCY,COMPONENT,TITLE ORDER BY 4 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Report Date | Date | ||
Agency Code | LOV Oracle | ||
Subelement | LOV Oracle | ||
Name of Organization Hierarchy | LOV Oracle | ||
Organization Hierarchy Version Number | LOV Oracle | ||
Report Filename | Char |