HXT Variance Table Listing

➜ Back to Library

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

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 Rotation Plan Table Listing HXT Work Plan Table Listing HXT Holiday Calendar Table HXT Prem. Interaction Plcy Tbl Lst