Dependent Rate Value Calculation is returning zero when using a user defined table
Summary:
We have a need to look through an employee's dependents, determine the gender. Get Table Value returns a 0, the default value, while we know we are sending it correct data.
Content (please ensure you mask any confidential information):
We have a health plan which sums the rate for the dependents based on gender and age band. We created a UDT with the bands as rows and gender as column. Both the rows and columns are numeric value and it is based on range.
No matter how we feed it, it throws a hissy. Our age calc works and we know we are passing it valid data.