HXT Variance Table Listing

Description

Categories: BI Publisher, Human Resources

Application: Time and Labor
Source: Variance Table Listing (XML)
Short Name: HXT957F_XML
DB package: HXT_HXT957F_XMLP_PKG

Copy

SELECT VAR_TYPE,
 FCL_PERIOD,
 VAR_TYPE_ID,
 BALANCE_NAME,
 BALANCE_DIMENSION,
 BALANCE_LEVEL,
 DATE_FROM,
 DATE_TO,
 CREATED_BY,
 CREATION_DATE,
 LAST_UPDATED_BY,
 LAST_UPDATE_DATE,
 LAST_UPDATE_LOGIN,
 HIGH,
 LOW,
 AVERAGE, 
	HXT_HXT957F_XMLP_PKG.var_type_desformula(HXT_VARIANCES.VAR_TYPE) VAR_TYPE_DES, 
	HXT_HXT957F_XMLP_PKG.var_type_nameformula(HXT_VARIANCES.VAR_TYPE,HXT_VARIANCES.VAR_TYPE_ID) VAR_TYPE_NAME
FROM HXT_VARIANCES
ORDER BY VAR_TYPE

Download

Related Blitz Reports

HXT Organization Variance Calc HXT Total Table Entries HXT Earning Variance Calculation HXT Location Variance Calculation HXT Earning Policy Table Listing HXT Work Plan Table Listing HXT Holiday Calendar Table HXT Prem. Interaction Plcy Tbl Lst HXT Premium Elg. Policy Tbl List