Four queries to audit months in which deductions listed on the SDCOE Custom Override Deductions (Employee) screen should process

posted Aug 18, 2016, 11:39 AM by Peyri Herrera
Use the four queries listed below to audit the months in which deductions currently listed on the SDCOE Custom Override Deductions (Employee) screen should process. These queries will not reflect deductions that are not listed on the SDCOE Custom Override Deductions (Employee) screen.
  • M_BN_EMPL_DED_PROC_GENDED: To list all employee’s General Deduction Overrides broken down by month. 
  • M_BN_EMPL_DED_PROC_HLTH: To list all employee’s Health Plan Overrides broken down by month. 
  • M_BN_EMPL_DED_PROC_NONHLTH: To list all employee’s Disability / Life / Long Term Care / Legal Plans Overrides broken down by month. 
  • M_BN_EMPL_DED_PROC_SVNGS: To list all employee’s Savings Plan Overrides broken down by month. 
Screenshot of M_BN_EMPL_DED_PROC_HLTH:
M_BN_EMPL_DED_PROC_HLTH