GHR CPDF Organizational Component Translation

➜ Back to Library

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 more less

Copy

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

Download

Related Blitz Reports
GHR CPDF Dynamics GHR CPDF Status GL Currency - Historical Rates Listing CST Margin Analysis Report with Order Management WSH Pick Slip INV Move Order Pick Slip AP Supplier Paid Invoice History - draft CST All Inventories Value Report - by Cost Group PER Head Count Detail