Databases

736 Words2 Pages

ABSTRACT
The Automated Business Service System (ABSS) was designed for the military to process documents without wasting an enormous amount of time. The original way of processing a document involved typing the document up and visiting each person to sign off on it. Not only was this time consuming but there was no historical record available if the original document was lost or destroyed. ABSS uses an Oracle database and has changed the way finance processes documents forever.

Before I worked as the systems administrator for finance I was the budget analyst. I started using the Automated Business Service System (ABSS) over eight years ago and I think it is one of the best programs the Air Force has adopted. ABSS was written by a private company and has been implemented over multiple branches of the service. When the program first came on board at my base in Germany I was appointed as the functional administrator to maintain the program. I was in charge of maintaining all user accounts and assisting the resource advisors on base with building their flows. I also had to process documents for my program through ABSS. I had to quickly learn how to use this program as well as learn how the Oracle database stored all this pertinent data.
Before the system was put online I was trained for a few days on how to start building the database and getting the system ready for implementation. I would not responsible for maintaining the actual database. We had a remote database administrator that had the capability to access the database and ensure there were no problems. The actual server was in my office but I had no access to log into it. I could log into the program from any system and make changes to the database that way. The actual integrity of the database was not part of my duties. I had to start building all the accounts for each user within the database.
There was a lot of work to be accomplished before the database went live. Every person who needed to approve a document would have an account as well as a step in the process. A user would draft and submit a document. Each users account also had there electronic mailing address linked to it. This would allow the system to generate an e-mail and the next person in line to approve the document would be able to log into the system and take the appropriate action.

Open Document