Department of Revenue Services (DRS) Delinquent Vendor File
Delinquent Vendor File Process:
The State of CT requires UConn to garnish payments to vendors that have delinquent taxes. DRS will create a file each quarter listing UConn vendors who have delinquent taxes, and make it available to UConn. UConn, then retrieves the file and processes it.  A DRS hold is set on the vendor, preventing any payments to the vendor.
Frequency:
A file is retrieved, from DRS, on a quarterly basis during the middle of the months of January, April, July, and October.Â
Procedure:
- An email is received from the UConn Accounts Payable Tax department or a Jira ticket is issued, indicating a need to Update DRS holds on Vendors in Kuali.
- Request that PRD-KFS-DelinquentVendorDRStoControl-M-MFT (PRD_KFS_UNSCHEDULED folder) be run, followed by PRD-KFS-DelinquentVendorDRStoControl-M-MFT, followed by PRD-KFS-delinquentVendorDataImportJob.  The first job pulls the encrypted file from DRS to the Control_M server opt/mftuser/drs/DRStoUCONN_VendorOffsetsCertfiedFile_RINTJ607*.asc. the second job decrypts the file and moves it to the KFS server staging/vnd/deliquentVendor/DRStoUCONN_VendorOffsetsCertfiedFile_RINTJ607_yyyymmddhhmmss.dat with an associated .done file.  The third job processes the file into KFS, placing a hold on vendors who are delinquent in paying state taxes.  An email is sent to DRS.ProdControl@po.state.ct.us to indicate that UConn received the file.  Emails are also sent to APtax@uconn.edu and CONTROLLERKFSBATCH@listserv.uconn.edu indicating the process is complete.
- NEEDS UPDATE TO REFLECT HUSKYBUY PROCESS
- After both jobs complete, Delinquent_Vendor.summary.yyyymmdd-hh-mm-ss-999.txt can be found in Kuali Production, reports/vnd. This report must be downloaded and sent to APtax@uconn.edu. Â
DRS File Format
There is a Header Row and Footer Row that is not used
FieldName | FieldPosition | FieldLength | Example | |
---|---|---|---|---|
1 | Code | 1 | 1 | Always "D" |
2 | TaxID | 2-10 | 9 | 077990009 |
3 | State Reg Code | 11-17 | 7 | |
4 | Dollars | 18-36 | 19 | 9999.9* (Last penny value is character 37) |
5 | Penny | 37 | 1 | Signed Overpunch Character |
6 | Vendor Name | 38-70 | 32 | DELL MARKETING INC |
7 | Street Address | 71-98 | 28 | 55 RED FOX LN |
8 | City | 99-114 | 16 | NEW HAVEN |
9 | State | 115-116 | 2 | CT |
10 | Zip+4 | 117-125 | 9 | 065130000 |
Signed Overpunch Values complete the dollar values:
Translated Values:
{ is 0
A is 1
B is 2
C is 3
D is 4
E is 5
F is 6
G is 7
H is 8
I is 9
Example:
D12345678911234567000000000000035700{FISH MARKET LLC 1307 MAIN ST WILLIMANTIC CT062261948