|
|
||
|
|
|
|
|
Version 05.13.02.00.05, March 2, 2013 - standard release |
|
|
Feature: |
SAO Data Export |
|
Ticket: |
251322 |
|
Change: |
Create ETL process to handle the data file transfer to the SAO site. |
|
Reason: |
Districts with large data file usually have unsuccessful transfer |
|
Menu: |
FM\AM\UT\AM\AU\DE |
|
Version 04.10.12.02.00, May 7. 2011 |
|
|
Feature: |
Modify SAO and AP FTP Processes |
|
Issue #: |
236520 |
|
Change: |
A small pause was added between processes. |
|
Reason: |
SAO & AP FTP processes are distributed across different platforms which have been causing time-out failures when communications between platforms was held up. |
|
Menu: |
FM\AM\UT\AM\AU\DE FM\AP\CI\TR\RF FM\AP\CI\TR\CF |
|
Version 04.10.12.01.05, April 9, 2011 |
|
|
Feature: |
Modify SAO Extract to include HAAETY-EMP-TYPES table |
|
Change: |
The HAAETY-EMP-TYPES table was added to the list of tables to be extracted. |
|
Reason: |
SAO requested adding the HAAETY-EMP-TYPES table to get employee title or job description for reviewing payroll. |
|
Menu: |
FM\AM\UT\AM\AU\DE |
|
Version 04.10.12.01.03, March 12, 2011 |
|
|
Feature: |
Modify SAO Extract to include all account codes for AcctMstr |
|
Change: |
Changes were made to the criteria on the AcctMstr extract to include all account codes every time rather than just the new ones. |
|
Reason: |
Some districts are missing codes that are sometimes from a previous year, sometimes from a subsequent year, and sometimes in between. A dump of all the codes each time would help to eliminate gaps which require the districts to submit additional years of data. |
|
Menu: |
FM\AM\UT\AM\AU\DE |
|
Version 04.10.01.01.00, May 8, 2010 |
|
|
Feature: |
Fix to the SAO Data Extract Process |
|
Issue #: |
224477 |
|
Change: |
A pause was added to the SAO Data Extract process between when the extract file is written and when it is renamed to a .zip. |
|
Reason: |
Larger districts were occasionally running into a problem where the extract process would attempt to rename the file to a .zip before it was done being written. |
|
Menu: |
FM\AM\UT\AM\AU\DE |
|
Version 04.09.06.02.02, February 6, 2010 |
|
|
Feature: |
Remove Pipe Delimiters from description fields in SAO extract |
|
Issue #: |
221245 |
|
Change: |
The SAO extract was modified to remove any pipe characters ("|”) from the fields when extracting the data. |
|
Reason: |
There were pipe delimiters appearing in some of the description fields from FFAPID-INVOICE-DTL that were causing problems for the SAO. The delimiters needed to be removed so that the files could be processed by the SAO more easily. |
|
Menu: |
FM\AM\UT\AM\AU\DE |
|
Version 04.08.10.00.03, February 7, 2009 |
|
|
Feature: |
SAO Transmission Fix |
|
Issue #: |
211841 |
|
Change: |
Modified code to ftp Data Export for SAO using DNS address for VPN. |
|
Reason: |
Some districts are running into issues where the FTP connection is closing before the .arc file is completely transferred resulting in an incomplete .arc file on the FTP server AND the zip file not being cleaned up. There is also the issue of data being transferred using a public interface. Not only will this be more secure because it goes over the VPN, the VPN tunnel will protect it from being disconnected (in theory). |
|
Menu: |
FM\AM\UT\AM\AU\ Data Extract for SAO - DE |
|
Version 04.08.10.00.01, January 10, 2009 |
|
|
Feature: |
SAO extract folder location change |
|
Issue #: |
210916 |
|
Change: |
The SAO folder was moved inside the fin_sec folder for added security. A message indicating that the extract is complete was also added. |
|
Reason: |
The files for the State Auditor’s Office needed to be extracted to a location with more security. |
|
Menu: |
FM\AM\UT\AM\AU\ Data Extract for SAO - DE |
|
Version 03.07.10.02.01, September 13, 2008 |
|
|
Feature: |
SAO Extract File Name Correction |
|
Change: |
An extra space after the district name in the extract file was corrected so that the file would successfully transmit to the State Accounting Office. |
|
Reason: |
The unintended space was preventing the extract file from being converted into a .zip file and transmitted to the State Accounting Office. |
|
Menu: |
FM\AM\UT\AM\AU\DE |
|
Version 03.07.10.01.04, August 16, 2008 |
|
|
Feature: |
SAO Data Extract |
|
Change: |
This program was updated to enable connection from production servers to the WSIPC FTP server. |
|
Reason: |
The SAO data extract program failed to connect to the WSIPC FTP server from the production environment. As a result, the extracted data could not be sent to the SAO server. |
|
Menu: |
FM\AM\UT\AM\AU\DE |
|
Version 03.07.10.01.04, July 12, 2008 |
|
|
Feature: |
SAO Automate Data Access |
|
Issue #: |
51222 |
|
Change: |
This feature allows clients to extract data for reporting to the State Accounting Office (SAO). |
|
Reason: |
Currently in WISE fiscal data and a limited HR data is provided to the state via export of WISE data files. The same feature &endash; to provide Fiscal and HR data to State Accounting Office - was desired in WESPaC. |
|
Menu: |
FM\AM\UT\AM\AU\DE |