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:

1. 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.
   
   
2. 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.
   
   
3. NEEDS UPDATE TO REFLECT HUSKYBUY PROCESS
4. 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

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