Calculation cards query questions
I’ve reviewed the calculation cards query questions on Customer Connect (very helpful) with a few additional questions about querying calculation card data. My SQL attached if helpful.
1) How do we query the Cumulative Taxation field for calc card associations?
2) What is the best source for determining start and end dates for federal and regional components? Need history as well as current. I see these dates in the PAY_RANGE_ITEMS_F table but it doesn’t seem like that would be the source.
3) Best way to consistently query Calculation Component name like Federal Taxes, Retiree Federal Tax, Retiree Reporting Information, etc. Looks like PAY_DIR_CARD_COMP_DEFS_VL.COMPONENT_NAME is a good source which I’ve tried to join with PAY_DIR_CARD_COMPONENTS_F.DIR_CARD_COMP_DEF_ID but results are inconsistent