GHR CPDF Organizational Component Translation

Description
Categories: BI Publisher, Human Resources
Application: US Federal Human Resources
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 Filename
 
Organization Hierarchy Version Number
 
LOV Oracle
Name of Organization Hierarchy
 
LOV Oracle
Subelement
 
LOV Oracle
Agency Code
 
LOV Oracle
Report Date
 
Date