O'Neil Software - Record Storage and Management Solutions

2011rssqlheader

Overview

2011rssqlintroA complete and comprehensive solution that includes invoicing, scheduling, automatic monitoring and reporting, error trapping, search capabilities, multi-user options, wireless technology, portable computing, remote access, retention scheduling, language translation, multi-site functionality and internet access. These are just a few of the key features designed to increase your record center’s efficiency, productivity and profitability.

RS-SQL is the scalable foundation that all the other O'Neil records storage/management solutions build upon. Five of the functional areas of the core RS-SQL software are explained below.

Take a look and then call us to learn how RS-SQL can give you complete control of your records storage/management needs.

 

Box Management

Container Add :: Each container in the system has quite a bit of information associated with it, and this information can all be found in the Container Add and Edit dialogs. Container Grid :: The RS-SQL Container grid allows you to view and manipulate container data in many different ways. It includes several 'Grid Specific' menu items – Load Refile List From, Urgent Notification, Global Edit Contents, Save Refile List, Global Edit Description, Refile List to PDT3100, and Print Refile List -- as well as several 'Grid Specific' pushbuttons. Container Query :: Queries allow you to load the exact items you want onto grids. Through Query dialogs, you can determine exactly what criteria are needed to access exactly what you need to load onto your grid.
Container Add Container Grid Container Query
Each container in the system can have a lot of information associated with it, all of which can be found in the Container Add and Edit dialogs. All data entry for containers is accomplished here. Containers are normally added to the system using scanners, but they can be added manually as well. Each time you enter an area of RS-SQL, you will see a blank white screen.  This screen is called a grid.  The RS-SQL Container Grid allows you to view and manipulate data in many different ways. It includes several 'Grid Specific' menu items such as Load Refile List From, Urgent Notification, Global Edit Contents (to name a few), as well as several 'Grid Specific' pushbuttons.
A query can be thought of as a question you ask the database, or a command to display information.  If you want to find out information about an item, you must query it onto the grid. Container Query allows you to load the exact items you want onto the grids. Through Query dialogs, you can determine precisely what criteria is needed, to access what you need to load.

 


RS-SQL has hundreds of individual features to help you manage your records storage/management facility.

Click Here to see more...

File Management

Filefolder Refile :: RS-SQL allows you to scan the barcodes of filefolders that need to be returned to containers and create a report that tells you what containers they should be in, and where those containers are currently located. This is called a Refile List. You may print a hard copy of a Refile List that displays on paper all the filefolders by location. Or you can send the refile list to a RSMobile hand-held scanner that then directs you around the facility and validates that the files have been refiled. Filefolder Edit :: Each filefolder in the system can have a lot of information associated with it, and this information is found in the Filefolder Add and Edit dialogs. All data entry for filefolders is done from the Filefolder Edit dialog box. Along with teh structured fields, RS-SQL offers you the option of entering free text to describe each filefolder. Your customers will define what descriptions are to be entered for each file, and this information can be searched on later to help you find it. Filefolder Tally :: The Filefolder Tally menu option is used to tally the number of filefolders that are in containers listed in the Container grid.

Filefolder Refile

Filefolder Edit

Filefolder Tally

A Refile simply means putting things back into storage after the client has had them out.  RS-SQL allows you to scan the barcodes of filefolders that need to be returned to containers, as well as create a report that tells you what containers they should be in and where they are located. Called a Refile List, you may print a hard copy, or send it to an RSMobile handheld, that then directs you around the facility and validates that the files have been refiled. Each filefolder in the system can have a lot of information associated with it, which can be found in the Filefolder Add and Edit dialogs. All data entry for filefolders is accomplished here. Along with structured fields, RS-SQL offers you the option of entering free text, to describe each filefolder and which your customers can define. This information can be searched on later, to help you find it. The Filefolder Tally menu option is used to count the number of filefolders that are in containers listed in the Container Grid and display the information. The results are sorted by Account Code and then Container Code.

RS-SQL has hundreds of individual features to help you manage your records storage/management facility.

Click Here to see more...

Tape Management

Tape Objects :: The system is shipped with several standard Objects, such as tapes of various shapes and sizes. RS-SQL allows you to create sublists for Tapes, as well as for Containers and Materials. Tape Delivery:: You can create pre-workorders for jobs that are to be done in the future. You can also create standard workorders for delivery and pickup, accessing and receiving items, destroying containers, files and tapes, as well as selling services and supplies to your customers. Billing Options :: Accounts can be set up through the Account option of the Administration program of RS-SQL. Using this function, you are able to fully identify your clients and customize their Accounts to suit your and their needs. For example, tape highwater storage charges the client for the highest quantity of tapes in the record center on any given day of the billing period in question. Highwater storgae charges work like this: on June 1, ABC Corp HQ has only 100 tapes on the system, but only 75 are in the facility. During the month tapes are removed and returned, and 50 tapes are added to the system. The month started with 75 tapes in the facility. The amount went up to 100 on the 10th and down to 60 by the 15th. When ABC added 50 tapes to the system and returned some others, the in-house quantity went up to 120 on the 26th, then down to 40 at the end of the month. Using Highwater Storage, the system would only note the highest quantity, and charge for 120 tapes.

Tape Objects

Tape Delivery

Billing Options

Objects are all the physical items that exist in your record center and that you sell.  The system is shipped with several standard Objects, such as tapes of various shapes and sizes.  RS-SQL allows you to create sublists for these tapes, as well as for containers and materials that are sold or delivered. You can create pre-workorders for jobs that are to be done in the future. You can also create standard workorders for delivery and pickup; accessing and receiving items; destroying containers, files and tapes; and selling services and supplies to your customers. Accounts can be set up through the Account option of the Administration - Critical  Set Up Program of RS-SQL.  Every customer will have a Level 1 Account.  Some will also have one or more Level 2 Accounts and possibly a Level 3.  Using this function, you are able to fully identify your clients and customize their accounts to suit their needs, as well as yours.

RS-SQL has hundreds of individual features to help you manage your records storage/management facility.

Click Here to see more...

Document Imaging

Imaging Workorder:: A Document Imaging Workorder allows you to handle a request that documents be scanned. You can only add documents to be scanned, other services and charges/credits to the Document Image Workorder. You cannot request documents to be delivered, picked up, or destroyed. Image Delivery :: An image of a document can be scanned and stored in the database, for viewing in RSWeb.NET. You can then see, edit, delete, or print the image. The image description displays above the image. Invoicing :: As you fulfill services requested by your customer, RS-SQL automatically captures each activity performed and it appears on a customer's invoice. Pricing can be standardized or customized for customers, departments or even cost centers with the same account; flat rates or quantity price breaks can be established; and you can bill storage by the item or cubic foot. Multiple formats (from basic one-page invoices to detailed, multi-page listings) are available from a service or work order level, showing complete detail.
Imaging Workorder Image Delivery Imaging Invoicing
RS-SQL Imaging on Demand provides immediate access to records for your clients.  Rather than picking and delivering a file, a file is picked, the page or pages are scanned and the file is returned to its storage location.  The image of the file can then be accessed via a secure web connection.  A Document Imaging Workorder allows you to handle a request that documents be scanned.  You can only add documents to be scanned, other services and charges/credits to the Document Image Workorder. You cannot request documents to be delivered, picked up, or destroyed. An image of a specific document can be scanned and stored in the database, for your customer's rapid access and viewing in RSWeb.NET. They can then see, add, edit, delete, or print the image. The image description displays above the image. As you fulfill services requested by your customer, RS-SQL automatically captures each activity performed and it appears on their invoice. Pricing can be standardized or customized for customers, departments, or even cost centers with the same account;  flat rates or quantity price breaks established; and you can bill storage by the item or cubic foot. Multiple formats (from basic one-page invoices to detailed, multi-page listings) are available from a service or work order level, showing complete detail.

RS-SQL has hundreds of individual features to help you manage your records storage/management facility.

Click Here to see more...