GHR CPDF Organizational Component Translation

➜ Back to Library
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
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 NameSQL textValidation
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
Download
Related Blitz Reports
GHR CPDF Dynamics GHR CPDF Status GL Currency - Historical Rates Listing INV Move Order Pick Slip ECC Depot Repair, Depot Service Orders (1) WSH Pick Slip ECC Depot Repair, Depot Service Orders (2) ECC Depot Repair, Depot Service Orders CST Margin Analysis Report with Order Management
Blitz Report™