A DVC (Data Validation Center) Rule set can be applied to a file importing via STP (Relius Straight Through Processing). In the event of a critical error, the file will not process. While there are many Relius-provided and custom rules that can be applied, you will want to think through your process to determine the rules to apply and the severity.
Note - Creating a new rule set is not required, but this is a basic recommendation. You can apply an existing rule set if you have one. It is not required to have a Finch File Rule Set. You can use any name for the rule set. Your business may have different requirements and this list may not be applicable.
| Rule Set Name |
System / Custom |
Severity | Rule Name | Rule Description / Message |
| Finch File Rule Set | Custom | Critical | Missing Birth Date | Birth Date is required for new employees. Provide the DOB for this employee. |
| Finch File Rule Set | Custom | Warning | Blank Name new PPT | Participant Name is not populated for a NEW participant. |
| Finch File Rule Set | Custom | Not Displayed | Rehire Date | The date of hire is later than the term date. Date of hire stored as rehire date. |
| Finch File Rule Set | Custom | Critical | DOH Missing | The date of hire is required for new employees. Provide the DOH for this employee. |
| Finch File Rule Set | Custom | Warning | Comp with 0 hours | Record shows 0 hours with salary greater than 0. Verify that the hours or salary amount are correct. |
| Finch File Rule Set | Custom | Warning | Hours - no comp | The participant has hours worked and no compensation. Verify that the hours and compensation are correct. |
| Finch File Rule Set | System | Warning | DOT Difference | The termination date does not match our current record. Date of Term will not be imported |
| Finch File Rule Set | System | Warning | DOB Difference | Date of Birth does not match our current record. Date of Birth will not be imported. |
| Finch File Rule Set | System | Not Displayed | Merge Duplicate SSNs | Merge values for SSNs that are uploaded more than one time |
Other Rules for consideration:
- Blank address
- Blank Name
- Deferral amount greater than match
- Set the Actual Loan payroll frequency to the payroll frequency.