The web Browser you are currently using is unsupported, and some features of this site may not work as intended. Please update to a modern browser such as Chrome, Firefox or Edge to experience all features Michigan.gov has to offer.
14.04.07: Validations run for DTL3 records
14.04.07: Validations run for DTL3 records
Rule |
Description |
1 |
SUSPEND a record if the SSN does not exist in the system. |
2 |
SUSPEND a record if the Invoice Number does not exist in the system for the SSN being processed. |
3 |
SUSPEND a record if the Agreement Number does not exist in the system for the SSN being processed. |
4 |
SUSPEND a record with TDP Record Type Code 01 (regular) or 05 (positive), if the Invoice Number does exist in the system for the SSN being processed but the Billing is not in Accept or In Progress status. |
5 |
SUSPEND a record with TDP Record Type Code 01 (regular) or 05 (positive) if a deduction is reported for an invoice that has been paid in full. |
6 |
SUSPEND a record with TDP Record Type Code 01 (regular) if the deduction amount is less than the scheduled deduction amount and the Deduction Reason Code is 01 (valid deduction), unless it is the last deduction to complete the agreement. |
7 |
SUSPEND a record with TDP Record Type Code 01 (regular) or 05 (positive) if the deduction amount is greater than the balance remaining on the invoice. |
8 |
SUSPEND a record if the deduction amount is greater than zero and the Deduction Reason Code is not 01 (regular). |
9 |
SUSPEND a record with TDP Record Type Code 01 (regular) if it contains a duplicate pay period end date for the same agreement number. |
10 |
SUSPEND a record if the invoice number and agreement number exist in the system for the reported SSN and the invoice number does not match the invoice number for the reported agreement number. |
11 |
SUSPEND a record with TDP Record Type Code 06 (negative) if the deduction amount is greater than the original amount that was initially posted for the period. |
12 |
SUSPEND a record with TDP Record Type Code 06 (negative) if the difference between the original amount that was posted and the reported deduction amount (original amount from be_osc_pmnt hist - val_tdp_deduc_amt) is either less than zero or is greater than the scheduled deduction amount. |
13 |
SUSPEND a record if the invoice is not paid in full and the Deduction Reason Code is 06 (agreement closed-paid in full). |
14 |
FLAG a record with Deduction Reason Code 01 (regular) that is reported after the pay period end date of a record with Deduction Reason Code 04 (agreement closed-employee deceased) but within 120 days prior to closing the agreement. |
15 |
SUSPEND a record with TDP Record Type Code 05 (positive) if the sum of the original amount that was posted and the deduction amount is greater than the remaining amount due. |
16 |
SUSPEND a record with TDP Record Type Code 05 (positive) if the deduction amount is less that the scheduled deduction amount and there is no original deduction posted for the period. |
17 |
SUSPEND a record with TDP Record Type Code 01 (regular) or 05 (positive) if the deduction amount is more than the scheduled deduction amount and the pay period end date of the deduction is on or after 4/1/2005. |
18 |
SUSPEND a record with TDP Record Type Code 05 (positive) or 06 (negative) reported with a pay period end date prior to 10/1/2002. |
19 |
SUSPEND a record if the pay period end date is not equal to the end date of any of the payroll cycles from the payroll cycle calendars for that employer. |
20 |
SUSPEND a record with TDP Record Type Code 05 (regular) or 06 (negative) if the pay period end date falls within the reports' begin and end dates. |
21 |
SUSPEND a record if the Deduction Reason Code is 00. |
22 |
SUSPEND a record with TDP Record Type Code 05 (positive) or 06 (negative) if the agreement involved has ever been cross referenced. |
Last updated: 04/13/2012