The description for fund 070 was changed to match the description in
the Auditor's USAS Manual.
1.2 4502: Updated for FY 2007
The 4502 program was updated to remove the Expendable Trust and Non-Expendable Trust fund types from the various exhibits and statements, and to replace them with columns for Permanent Funds and for Trust Funds.
Also, the calculate option will no longer prompt the user for whether
they wish to generate a "cash-basis" or a "gaap-basis" report. The 4502
report will now always use the fund type found on CASHSCN, if there is
one. If the fund type in CASHSCN is blank (recommended for most funds),
then the fund type designation from the Auditor of State's USAS Manual
will be used. A fund type is required to be entered in CASHSCN for 007
funds or a fatal error will be generated.
1.3 USAEMS: Updated for FY 2007
The USAEMS program was updated to extract the new fund types for proper reporting in EMIS for fiscal year 2007. The Expendable Trust and Non-Expendable Trust Fund Types were removed and replaced by the Permanent and Private-Purpose Trust fund types.
Also, all references to "Data Acquisition Site" were changed to
"Information Technology Center".
2 Problems Corrected
2.1 4502: Corrected problem with option 12
A problem was corrected in the calculate option that caused option 12
of the 4502 to "hang" while producing the 'Budget vs. Actual' reports.
This occurred only for districts with fytd receipts in an 1112 receipt
code. It will be necessary for affected districts to re-run the
calculate option (option 10) and then re-run option 12 in order to get
correct 'Budget vs. Actual' reports.
2.2 ACTCHG/FNDCHG: XREF records not updated properly
The XREF codes were not being updated correctly when using FNDCHG or
ACTCHG. This has now been corrected.
2.3 POFORM: Fix problem when printing MASCNV future po's
A problem was fixed in the POFORM program related to printing future
purchase orders. When using the option to print a range of future
purchase orders and the purchase orders were originally created in the
MASCNV program, the first item was missing for all po's except the
first po in each batch. This problem did not affect future purchase
orders created in either POSCN or USASWeb.
2.4 POFORM: Only printed first po in range
A problem was corrected which caused POFORM to only print the first
purchase order in the range requested if the district had more than
1000 total future purchase orders. This limit was increased to 2000 to
correct this problem for large districts.
2.5 POSUMM: Fixed remaining encumbrance for future po's
A problem was corrected which caused an incorrect remaining encumbrance
amount to be printed on the report for future purchase orders.
2.6 USACERT/APPRES: Fund types not printing correctly
The recap portion of the APPRES report was not properly handling funds
that represent more than one fund type. This problem has now been
corrected.
2.7 USASWeb: Highest transaction numbers not updated
The highest purchase order number on file and the highest receipt
number on file were not being updated when changing the transaction
number on purchase orders or receipts. This problem has been corrected.
2.8 USASWeb: 'Refunded To' not stored
The 'Refunded To' vendor name was not being stored on file when posting
a refund with a check. This caused the RCFORM program to prompt the
user for the "Enter person/vendor transaction received from" whenever
generating a print file for a refund associated with a check. This has
now been corrected.
3 Technical Enhancements and Changes
3.1 4502.SEQ: File layout changed
The record layout for Statement J and Statement M within the 4502.SEQ
file layout have been changed slightly to accomodate larger field sizes
needed for EMIS reporting.
4 Modifications to Menu Files
5 Documentation
The documentation is maintained by the SSDT and can be found in the
OECN$ROOT:[USAS.V6P1.DIST] distribution directory.
5.1 Documentation Changes
5.1.1 AUD_4502 Documentation Updates
Updated chapter to remove expendable trust and non-expendable trust
notation as well as updating calculation option prompt regarding cash
basis vs. gaap basis.
5.1.2 USAEMS Documentation Updates
Updated documenation referencing data acquisition sites. Replaced it
with Information Technology Centers.
5.2 Documentation Summary
The following are documentation files for the Uniform School Accounting System (USAS) package. Below is a brief description of the contents and the intended audience of the document.
| Document File | Revision Date | Description |
|---|---|---|
| USAS_REFERENCE_MANUAL | September, 2007 | USAS Reference Manual |
| USAS_REFERENCE_MANUAL_UPDATE | September, 2007 | Contains Updates to the Documentation for the USAS Reference Manual |
| USAS_USER_GUIDE | December, 2006 | USAS User's Guide |
| USAS_USER_GUIDE_UPDATE | December, 2006 | Contains Updates to the Documentation for the USAS User Guide |
| USAS_SYSMAN_MANUAL | December, 2006 | USAS System Manager Manual |
| USAS_SYSMAN_MANUAL_UPDATE | December, 2006 | Contains Updates to the Documentation for the USAS System Manager Manual |
| USASAUD_SPEC | March, 1999 | System Manager Documentation for the File Structures Used by the USASAUD Program. |
| AR_CUST_SPECS | September, 1996 | System Manager Documentation describing how to write an interface between the USAS/AR system and other databases. This interface allows ARF to access customer numbers, names and addresses in non-state software files. |
| AUTOPOST_SPEC | May, 2005 | System Manager Documentation for the File Structures Used by the AUTOPOST Program. |
| ACCLOAD_SPEC | May, 1999 | System Manager Documentation for the File Structures Used by the ACCLOAD Program. |
| VENLOAD_SPEC | December, 2002 | System Manager Documentation for the Fixed File Structures Used by the USALOAD/VENLOAD Program. |
| CONVERSION61_SPEC | September, 1998 | System Manager Documentation for implementing USAS V6.1 in order to prepare the programs for the next millennium. |
The training manual for BARNYARD software is available. It is located in the directory TRAINING:[BARNYARD] and is called BARNYARD_MANUAL.SDML. It also contains a AAAREADME.1ST file and a set of data files along with the manual.
The training manual for BARNYARD software is available. It is located in the directory TRAINING:[BARNYARD] and is called BARNYARD_MANUAL.SDML. It also contains a AAAREADME.1ST file and a set of data files along with the manual.
A training manual for the USAS GAAP Subsystem is also available. It is located in TRAINING:[GAAP]. In addition to the manuals shown below, the directory contains a file, AAAREADME.1ST and a set of data files designed to accompany the manual.
A training manual for the Accounts Receivable Facility (ARF) is available. It is located in TRAINING:[ARF] which contains a AAAREADME.1ST file and a set of data files along with the manual.
A beginner and an advanced training manual for the USASCN program are available. Included in the Beginner USASCN manual are POSCN, REQSCN, VENSCN, and OPTSCN. The beginner manual introduces the USASCN program and includes basic features such as creating requisitions/purchase orders and adding vendors. Included in the Advanced USASCN manual are ACTSCN, REQSCN, POSCN, BRDRET and the USASEC program which is located under USASDAT. The advanced manual is for users with USASCN experience. It includes advanced features such as adding/modify/deleting accounts in ACTSCN, modifying purchase orders, combining items in requisitions and purchase orders, creating future purchase orders, posting board's share of retirement and restricting the use of certain account codes. The beginner and advanced USASCN training manuals are located in TRAINING:[USASCN] which contains a AAAREADME.1ST file and one set of data files designed to accompany both manuals.
All documentation produced for these manuals was developed with a Digital product called VAX Document. This product enables us to provide three versions of the documentation for various types of printers. The version which has an extension of .LN03 can be printed on a laser printer; while version with the extension of .PS is to be printed on a ScriptPrinter.
| Document File | Revision Date | Description |
|---|---|---|
| BARNYARD_MANUAL | September, 2001 | Training Manual for the BARNYARD Software. |
| GAAP_TRAIN | September, 1998 | Training Manual for the USAS GAAP Subsystem. |
| ARF_TRAINING_GUIDE | May, 2003 | Training Manual for the ARF Software. |
| USAS_BEGIN_MANUAL | March, 2003 | Uniform School Accounting System Training Guide. |
| USASCN_BEG_MANUAL | January, 2003 | Beginner Training Manual for the USASCN Software. |
| USASCN_ADV_MANUAL | November, 2002 | Advanced Training Manual for the USASCN Software. |
The users have the ability to print the updates to the documentation manuals since the previous release, without having to print the entire documentation manuals. The updates are contained in a separate file which uses the same naming convention as the normal manual with "_UPDATE" appended. The update files are available in .LN03 and .PS versions. You will find updates to both the user and system manager manuals if changes have taken place.
The update files will include *ONLY* the modified chapters of the documentation manual, a new table of contents, and an index if one exists in the documentation manual. Updated documentation is also included in the normal documentation manuals. Therefore, if you plan to print the newest version of the entire user or system manager manual, it will *NOT* be necessary to print the update file.
It should be noted that even though the purpose of the update files is to allow the users to print only the updates, there may be cases when it would be more practical to print the entire documentation manual, rather than trying to use the update file. For instance, if a new chapter is added at the very beginning of the manual, the numbering for all subsequent chapters will change as well (the size of the update file could be almost as large as the normal documentation manual). SSDT will advise you in the release notes when the changes are so numerous that we recommend that you print the entire documentation manual.
There will only be one _UPDATE file provided each release for every manual. We do not plan to distribute updates for previous releases, as we do for the release notes.
SSDT strongly advises that you print new documentation manuals before you try to utilize the _UPDATE files.
If you print a .PS version of the entire documentation manual, be sure to print the .PS version of the _UPDATE files. The _UPDATE pages will not fit into the manual properly if you try to mix the various documentation formats.
If there are no changes in the documentation manuals, no _UPDATE file
will exist on the release.
6 Package Installation and Logicals
Installing USAS involves first using the OECN_INSTALL procedure to unpack the savesets into the OECN$ROOT:[USAS.V6P1.DIST]. After the distribution directories have been prepared, INSTALL_PACKAGE is used to transfer the package from the distribution directory into the user execution directory. See the VAXMGR_HANDBOOK in OECN$ROOT:[DOCUMENT.DIST] for more information about OECN_INSTALL and INSTALL_PACKAGE.
Prior to executing INSTALL_PACKAGE it is necessary to define several system logicals required by the package. The table below lists the logicals which should be defined prior to executing INSTALL_PACKAGE for USAS:
| Logical | Description |
|---|---|
| OECN$BUD_61 | Shared directory. Contains executables and files shared by all USAS |
| OECN$CDD_BUD_61 | CDD path name (optional, see next section) |
| OECN$MENU$FILES 1 | Location for menu files |
| OECN$HELP 1 | Location of VMS help libraries |
USAS also requires components from the OECN and CSSR packages. These packages should be installed prior to installation of this package. |
The USAS distribution contains optional CDD and DTR definitions that are acceptable for use with DTR, 20/20 and other products that are integrated with DEC CDD/Repository. Data names for COBOL are provided in the record definitions. The CDD definitions are optional and are not necessary to successfully install and utilize the base USAS package. However, there are a few "supported" DTR reports. If you wish to be able to use these reports, you must install the CDD definitions.
The INSTALL_PACKAGE procedure in OECN$UTL will load the CDD definitions into the CDD when either the "CDD" or "FULL" option is used to install USAS. INSTALL_PACKAGE is the only supported method for installation of CDD definitions for USAS Version 6.1.
The USAS CDD definitions for USAS Version 6.1 will be loaded into the CDD path referenced by the OECN$CDD_BUD_61 logical. This logical must be defined prior to executing INSTALL_PACKAGE and should be defined as a system logical. SSDT recommends that the USAS definitions be placed in a separate CDD directory from other CDD definitions. This increases the efficiency of the CDD, allows the USAS definitions to be treated as a 'database' from 20/20, and simplifies security maintenance. For example:
$ DEFINE/SYSTEM OECN$CDD_BUD_61 CDD$TOP.OECN.USAS61 |
After defining the OECN$CDD_BUD logical, the INSTALL_PACKAGE may be executed. Below is sample run of the CDD installation:
$
$ @OECN$UTL:INSTALL_PACKAGE CDD OECN$ROOT:[USAS.V6P1.DIST]
OECN INSTALL_PACKAGE (V1.1-010) Copyright © 1991, Ohio Dept of Ed, IMS
%OECNINS-I-BEGIN, Begin CDD installation for USAS Version 6.1 on NWOCA0::
at 14-MAR-1994 15:09:36.41
%OECNINS-I-CDD, Loading CDD definitions to CDD$TOP.OECN.USAS61
OECN INSTALL_CDD (V1.0-001) Copyright © 1994, Ohio Dept of Ed, IMS
%OECNINS-I-START, Starting CDD install for USAS Version 6.1
%OECNINS-I-RECORD, Processing record OECN$CDD_BUD.PERMANENT_4502_REC
.
.
.
|
USAS contains a dictionary for use with the UDMS Report Writer product. The dictionary will be installed automatically when OECN$UTL:INSTALL_PACKAGE is executed with either the FULL or UDMS option. If a version of the dictionary has already been installed, INSTALL_PACKAGE will merge the updated version into the local copy. Thus, reports and additional views developed locally will be preserved.
USAS also contains a sharable image which is used by UDMS. The sharable image provides 3GL functions which are used in calculated fields by the UDMS dictionary. To make this image available to UDMS, you must define the following logical during system startup:
$ DEFINE/SYSTEM OECN$USAS_SHR OECN$BUD:USASSHR.EXE
|
Please implement this release as soon as possible. It is difficult for the SSDT to provide assistance to your problems if you are not utilizing the current version of the software supplied.
Please refer to the documentation files contained on the release tape to obtain a history of the modifications the software has gone through. The release documentation files are named in the format of "RELyymm.DOC" where yymm is the release date.
Should you experience any problems, or have any questions, concerning the OpenVMS/Alpha version of the USAS Version 6.1 software please feel free to contact SSDT for assistance using one of the following options:
Visit the OECN Public Forum at http://forums.oecn.k12.oh.us/forums/oecn/
DAS restricted Forum at http://forums.oecn.k12.oh.us/forums/das/
SSDT Home Page at http://ssdt.oecn.k12.oh.us/
End of Documentation for USAS Version 6.1 Release: 2007.09