University of ConnecticutAccounts Payable - DRS Tax Delinquency Process
The State of Connecticut Department of Revenue Services (DRS) requires those State Agencies with check writing authority, to update their vendors records with information indentifying which tax delinquent vendors should have garnishments applied to their payments from the State. The process for doing this runs quarterly.
The DRS process is initiated at UCONN on February 15, May 15, August 15, or November 15. The process commences automatically on each of these dates using the UITS job scheduler. The job extracts to a generation dataset all active FRS vendors and prints a control report for Accounts Payable alerting them that the process has begun. Five generations of datasets are kept. The job also sends an email to scheduling for the next job to run. The next job FTP's the dataset to the DOIT mainframe at DRS and emails the DOIT team that the dataset is on their system. It also emails to inform users that the dataset was FTP'd.
Approximately 45 to 60 days later a hard-copy report and an official sign-off of the process addressed to the President's office, will be picked up by a UCONN courier after DRS has notified the UCONN Accounts Payable Department that it is ready. Accounts Payable and DOIT will notify UITS that the new dataset is available processing.
The first job of the next step, FTP's a DOIT mainframe dataset to an FRS dataset. This dataset contains Certified Tax Delinquents. Five generations are kept. The final job updates the FRS Vendor File with information from this dataset. Both these jobs are scheduled by the user.
|
The following Control cards are required for this process: C9612E01 - Email notification to schedule J9612S02 C9612S02 - FTP commands to send Vendor Extract to DOIT mainframe C9612E02 - Email notification to DOIT personnel that file is sent C9612S10 - FTP commands to retrieve updated tax delinquenncy file C9612E10 - Email notification that file was received from DOIT and to schedule J9612M11. |
The DRS process consists of the following jobs:
J9612S01
The job extracts active vendor records and prints a control report. This job is automatically run by date. An Email message is sent to Scheduling to place J9612S02 on daily schedule.
J9612S02
The job FTP's the Vendor File Extract to the DOIT mainframe for input their tax delinquency process. UITS Scheduling will have this job run during the day. An Email message is sent to the DOIT mainframe personnel that the file has been FTP'd.
J9612S10
The job FTP's the Vendor File from DRS DOIT mainframe to a file for into update job J9612M11. It now contains Certified Tax Delinquents User scheduled. An email message is sent to scheduling to schedule J9612M11 in the nightly batch schedule and sent to the DOIT mainframe that the the tax delinquency file has been received.J9612M11
The job updates the FRS Vendor File and prints both a detail and a control report. User scheduled.