HXT Premium Elg. Policy Tbl List

➜ Back to Library
Description
Categories: BI Publisher
Application: Time and Labor
Source: Premium Elg. Policy Tbl List (XML)
Short Name: HXT956D_XML
DB package: HXT_HXT956D_XMLP_PKG
select EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, ELT_BASE_ID, ELT_PREMIUM_ID, PEP_ID, 
	HXT_HXT956D_XMLP_PKG.bhtformula(HXT_PREM_ELIGBLTY_RULES.ELT_BASE_ID, HXT_PREM_ELIGBLTY_RULES.EFFECTIVE_START_DATE, HXT_PREM_ELIGBLTY_RULES.EFFECTIVE_END_DATE) BHT, 
	HXT_HXT956D_XMLP_PKG.premformula(HXT_PREM_ELIGBLTY_RULES.ELT_PREMIUM_ID) PREM
from 
HXT_PREM_ELIGBLTY_RULES 
 where HXT_PREM_ELIGBLTY_RULES.PEP_ID=:ID
Download
Related Blitz Reports
HXT Prem. Interaction Plcy Tbl Lst HXT Work Plan Table Listing HXT Hour Deduction Plcy Tbl List HXT Shift Diff. Pol. Table Listing HXT Location Variance Calculation HXT Actual and Rounded Time Punch HXT Earning Policy Table Listing HXT Periodic Late Clock-In HXT Earning Variance Calculation
Blitz Report™