Databases

Note: None of these databases contain Geographic Information System data.

Note: Estimated physical storage requirements given below do not include approximately 2 gigabytes of "overhead" storage requirements (shared files, etc.)

Application Name: Admission Management System (AMS)
Software: OS/VS COBOL, ADABAS, COM-PLETE, NATURAL, MVS/ESA
Hardware: IBM 9672 Mainframe
Location: UNT Computing Center
Batch/On-Line Status: Batch functions support mass update and reporting, on-line functions available for individual update and query.
Estimated Physical Storage Requirements: 0.04 gigabytes
Application Description: Collects, maintains, and reports basic information for all categories of applicants to the University. Includes provisions for communicating with students re. missing information, etc. Information maintained is electronically passed to the SRS (Student Records System) when admitted applicants actually register to become students.
Sharing:  
   
Application Name: Advancement / Development System
Software: OS/VS COBOL, ADABAS, NATURAL, COM­PLETE, MVS/ESA
Hardware: IBM 9672 Mainframe
Location: UNT Computing Center
Batch/On-Line Status: Batch functions support mass update and reporting, on-line functions available for individual update and query.
Estimated Physical Storage Requirements: 0.14 gigabytes
Application Description: Collects, maintains, and reports detail information about all UNT alumni and other specific donors and supplies information for various solicitation campaigns.
Sharing:  
   
Application Name: Billing/Receivables System (BRS)
Software: OS/VS COBOL, ADABAS, COM­PLETE, NATURAL, MVS/ESA
Hardware: IBM 9672 Mainframe
Location: UNT Computing Center
Batch/On-Line Status: Batch functions support mass update and reporting, on-line functions available for individual update and query.
Estimated Physical Storage Requirements: 0.71 gigabytes
Application Description: Collects, maintains, and reports basic information for all categories of applicants to the University. Includes provisions for communicating with students re. missing information, etc. Information maintained is electronically passed to the SRS (Student Records System) when admitted applicants actually register to become students.
Sharing:  
   
Application Name: Capital Equipment Account Tracking System (CEATS)
Software: NATURAL, ADABAS, COM-PLETE, MVS/ESA
Hardware: IBM 9672 Mainframe
Location: UNT Computing Center
Batch/On-Line Status: On-line updating and individual inquiry. Large reports are produced using batch processing.
Estimated Physical Storage Requirements: 0.16 gigabytes
Application Description: Collects, maintains, and reports detail property information about individual items of capital/controlled equipment, including purchase date and cost, current location, general ledger data, acquiring account, person with inventory responsibility for the equipment, etc. System is interfaced to the State Comptroller's State Property Accounting (SPA) to provide that system with data mandated by the State Comptroller.
Sharing: UNT transmits transactions quarterly reflecting activity in CEATS to the State Property Accounting System (SPA). Additionally the Agency Extract from SPA is utilized by UNT's CEATS to produce a reconciliation report for UNT's property manager. UNT's Property Manager interfaces online with SPA to input some transactions which cannot be sent via batch due to timing or functional reasons. UNT's Property Manager also uses the inquiry functions in SPA.
   
Application Name: Degree Audit Reporting System (DARS)
Software: OS/VS COBOL, ADABAS, COM-PLETE, NATURAL
Hardware: IBM 9672 Mainframe
Location: UNT Computing Center
Batch/On-Line Status: Batch functions support mass update and reporting, on-line functions available for individual update and query.
Estimated Physical Storage Requirements: 0.25 gigabytes
Application Description: DARS or the audit report is designed to compare a student's academic work - at any point in the student's career - with the requirements of an institution's academic program or programs, and to prepare a comprehensive report detailing the student's progress toward meeting those requirements. The report may be produced to report all satisfied requirements first following by any unsatisfied requirements, vice versa, or to report using several other run options.

Audit reports may be prepared in either a "batch" or "on-line" mode. Batch reports are usually prepared for large numbers of students as might be needed prior to student registration, or for all degree candidates, or for a particular major or college.

On-line reports are typically prepared to handle individual student advising needs, to determine where a student would stand in some other academic program, or in using another catalog year/term, ("what if" type questions), or to confirm the affects of some academic program "exception" action for a student.

The Transfer Equivalency System (TRES), a subsystem of DARS, provides automated support for determining the transferability of course work from other institutions (whose courses have been evaluated) to determine the UNT equivalent. Currently this includes all community/junior colleges in Texas and selected senior-level universities. Classes from other institutions for which course equivalencies have been established can be evaluated to determine the applicability of those courses toward a UNT degree. Course data for individual students are either input through a computer terminal or received electronically over the AHE Electronic Transcript Network. Transcripts/reports are then produced showing the equivalency of the course work.

   
Application Name: Development Query System
Software: ORACLE, Entire Connection, Windows NT (server operating system), Esperant, Novell Network; any version of MS-Windows on client machines
Hardware: Generic Intel Pentium-based EISA server, desktop (client) machines capable of running any version of MS-Windows
Location: UNT Computing Center
Batch/On-Line Status: On-Line
Estimated Physical Storage Requirements: 0.75 gigabytes
Application Description: This application uses selected data from the Advancement / Development System which is periodically downloaded from that system and stored in an ORACLE database file on a database server attached to the campus network. This database is Made available to Advancement personnel, College Development Officers, and others, as deemed appropriate by the Advancement Office administrators, who use Esperant or other PC-based end-user oriented query and reporting software tools to run ad-hoc queries and produce reports as needed.
Sharing:  
   
Application Name: Facilities Inventory System
Software: OS/VS COBOL, ADABAS, NATURAL, COM-PLETE, MVS/ESA
Hardware: IBM 9672 Mainframe
Location: UNT Computing Center
Batch/On-Line Status: Batch functions support mass update and reporting, on-line functions available for individual update and query.
Estimated Physical Storage Requirements:  
Application Description: Collects, maintains, and reports detail information about the University's buildings and rooms.
Sharing:  
   
Application Name: Financial Aid Management System (FAMS)
Software: OS/VS COBOL, ADABAS, COM­PLETE, NATURAL, MVS/ESA
Hardware: IBM 9672 Mainframe
Location: UNT Computing Center
Batch/On-Line Status: Batch functions support mass update and reporting, on-line functions available for individual update and query.
Estimated Physical Storage Requirements: 1.10 gigabytes
Application Description: Collects, maintains, and reports information to allow applicants for financial aid to be considered for available funds. Supports financial aid awarding, packaging, student notification, and BRS system feed functions.
Sharing:  
   
Application Name: General Ledger Accounting System (GLAS)
Software: OS/VS COBOL, ADABAS, COM­PLETE, NATURAL, Clipper, PC-DOS, MVS/ESA
Hardware: IBM 9672 Mainframe, Networked PC's
Location: UNT Computing Center, Controller's Office Network
Batch/On-Line Status: Batch functions support mass update and reporting, on-line functions available for individual update and query.
Estimated Physical Storage Requirements: 1.56 gigabytes
Application Description: Consists of software necessary to 1) post and maintain the general ledger, 2) process claims to produce payments to vendors operating on a modified accrual basis, and 3) produce periodic accounting statements as required by the University, and to meet state and federal reporting requirements. Also allows for on-line inquiry and display of departmental account balances. System is interfaced to the State Comptroller's Uniform Statewide Accounting System (USAS) to provide that system with information as mandated by the State Comptroller. System is used by both UNT and UNT Health Science Center.
Sharing: Selected transactions from the GLAS are sent daily to the comptroller's office to be posted in USAS. Encumbrance balances and payable balances from GLAS are calculated are transmitted quarterly to be posted in USAS. UNT receives the USAS History extract and updates some tracking information in GLAS from USAS. Additionally reports are printed locally and distributed to UNT Controller office personnel. UNT Controller Office personnel also interface online to input certain transactions directly into USAS.
   
Application Name: Housing Information System (HIS)
Software: Oracle, MS-DOS, Novell Netware
Hardware: Ethernet LAN, File Server, Data Server
Location: Housing Department
Batch/On-Line Status: Batch functions for Mainframe (SRS) update; on-line functions for record update, reporting and ad-hoc query.
Estimated Physical Storage Requirements:  
Application Description: Collects, maintains, and reports assignment and financial information for residential students. Generates accounts receivable transactions, student bills and payment receipts. Data are available to residential system. Demographic data passed to Student Record System each semester for update and comparative purposes.
Sharing:  
   
Application Name: Payroll/Personnel / Human Resources Management Information System (HRMIS)
Software: OS/VS COBOL, ADABAS, COM­PLETE, NATURAL, PC­DOS, Clipper, dBase III, MVS/ESA
Hardware: IBM 9672 Mainframe, Networked PC's
Location: UNT Computing Center (mainframe component), Personnel Office and Budget Office Networks (PC Component)
Batch/On-Line Status: Batch functions support mass update and reporting, on-line functions available for individual update and query.
Estimated Physical Storage Requirements: 1.82 gigabytes
Application Description: Provides automated support for payroll processing (including mandatory associated record-keeping and reporting) as well as meeting the special, complex, and critical management information needs of the University for Payroll/Personnel related information. The overall system includes four major sub-systems as follows:1) Employee Maintenance: Accommodates all master file maintenance activities related to employee-related data, benefits enrollments, and assorted codes used in payroll processing. 2) Payroll Detail: Supports gross pay and net pay calculations, printing of checks, processing of check reversals, payment of benefits vendors, and periodic payroll reporting. 3) Budgets: Supports all activities associated with the preparation of fiscal year budgets, including both personnel and non-personnel items. 4) Position Control: Supports the requisition and support of individuals to fill those positions. System is used by both UNT and UNTHSC.
Sharing: Employee Retirement System ­ Two way interface of all information concerning state provided insurance benefits in support of plan administration and premium reconciliation. Online inquiry and update of the ERS system in Austin is available locally.

Comptroller's Human Resource Information System ­ Interface of payroll and personnel data to the states human resource reporting database. Online inquiry and update of the HRIS database in Austin is available locally.

Uniform Statewide Accounting System ­ Transmission of state paid payroll information to Austin for reimbursement. Online inquiry and some updating of the USAS system in Austin is available locally.

   
Application Name: Reimbursements/Disbursement Management System
Software: ADABAS, COM­PLETE, NATURAL, MVS/ESA
Hardware: IBM 9672 Mainframe
Location: UNT Computing Center
Batch/On-Line Status: Batch functions support mass updating and reporting, on-line functions support inquiry, transaction entry, system management, check printing.
Estimated Physical Storage Requirements: 0.73 gigabytes
Application Description: Supports the calculation, posting and printing of reimbursements for students which arise from credit balances on the student's account. Provides for both batch & online (on-demand) printing of disbursements.
Sharing:  
   
Application Name: Special Fees Administration System
Software: ADABAS, COM­PLETE, NATURAL, MVS/ESA
Hardware: IBM 9672 Mainframe
Location: UNT Computing Center
Batch/On-Line Status: Batch functions support mass updating and reporting, on-line functions support inquiry, transaction entry.
Estimated Physical Storage Requirements: 0.03 gigabytes
Application Description: Provides transactions to award, maintain and apply scholarship, third party sponsorship & tuition/fee waiver credits to student accounts.
Sharing:  
   
Application Name: Student Records System (SRS)
Software: OS/VS COBOL, ADABAS, COM­PLETE, NATURAL, Clipper, dBase III, PC­DOS
Hardware: IBM 9672 Mainframe, Networked PC's, MVS/ESA
Location: UNT Computing Center (mainframe component), Registrar's Office Network (PC component)
Batch/On-Line Status: Batch functions support mass update and reporting, on-line functions available for individual update and query.
Estimated Physical Storage Requirements: 1.2 gigabytes
Application Description: Collects, maintains, and reports information for current and previous students, maintains and reports course-related information (by term), and maintains and reports students' permanent academic record (transcript) information. Also supports student registration for classes via the Telephone Registration (Telreg) system (listed and described as a separate application), and on-line terminals.
Sharing: CBM001, 002, 004, 005, 008, and 009 reports are sent to the Texas Higher Education Coordinating Board.
   
Application Name: Telephone Information System (TIMS)
Software: OS/VS COBOL, ADABAS, COM­PLETE, NATURAL, MVS/ESA
Hardware: IBM 9672 Mainframe
Location: UNT Computing Center
Batch/On-Line Status: Batch functions support mass update and reporting, on-line functions available for individual update and query.
Estimated Physical Storage Requirements: < 0.01 gigabyte
Application Description: Collects, maintains, and reports detail information about university telephones (location, characteristics, etc.) and usage for long-distance calls. Receives long-distance call information from local telephone companies (GTE and AT&T), produces statements (bills), and electronically passes information to the General Ledger Accounting System (GLAS).
Sharing:  

| Go Back to Table of Contents |

Major Applications

Although all of the applications described in the Databases section are considered major applications, they are not duplicated in this section.

Application Name: Access Control Information System
Software: UNIX, Proprietary
Hardware: HP 9000 data server, proprietary communications server, local telephone company-supplied data line distribution network.
Location: ID Card Office
Batch/On-Line Status: Batch functions for demographic information update. Transaction readers on-line via local telephone company data lines, administrative terminals on-line via local telephone company data lines.
Application Description: Remote access from vendor supplied authorization terminals updates statistical and customer data and provides authorization for transactions. Administrative access for fixed format and ad-hoc reporting.
   
Application Name: Access Student Service Information Systems by Telephone (ASSIST)
Software: SCO UNIX, "C", WRITE-1, SOLARIS
Hardware: NCR 3345 (486 microchannel) PC's, BT­III voice processing units, Express 3174/SNA emulation product, SUN 1000E Server
Location: UNT Computing Center
Batch/On-Line Status: On-Line
Application Description: This interactive voice response (IVR) system interacts in real-time with mainframe-bases systems (including the Admissions Management System, Student Records System, Financial Aid Management System, and Billing Records System) to allow students to do the functions listed below from any touch-tone phone. Except where otherwise noted, the requested information is spoken back to the student on the phone using computer-generated speech.):

Receive admission, registration, and scheduling information

Order transcripts and university publications (requested documents are subsequently mailed to requester)

Receive academic record and course information by phone (includes fax option for academic status and grades and for student course schedule)

Receive student account receivable information (account balances and payment deadlines)

Pay account balances by credit card

Receive housing and financial aid information

Receive academic calendar and graduation information

   
Application Name: Admissions Prospect System
Software: SPEED II (4GL Application Development Product from APPX Software, Inc., Release 06.01.07), Wang VS Operating System Version 07.32.02. (Note: SPEED II is available for both the Wang VS and UNIX platforms.)
Hardware: Wang VS/5000 Mini Computer with four Work Stations, four printers, and streaming tape drive (for backup purposes).
Location: Admissions Office
Batch/On-Line Status: Batch functions for mass update and reporting and for mainframe (AMS) update; on-line functions for individual record update, display and ad hoc query. TCP/IP communications for electronic transmittal of prospective student information requests for centralized processing and distribution.
Application Description: Collects, maintains, and reports information about prospective applicants. This information potentially comes from a variety of sources, including Admissions Office staff recruiting visits to high schools and junior/community colleges. Student information accompanying admissions exam scores processed on the mainframe is also downloaded to the Prospect System, creating prospect records. The system produces personalized reply letters and labels for mailing requested materials, including Catalogs and Schedules of Classes. If the prospect has requested an application for housing, financial aid, or information from a specific school or college, mailing labels are forwarded to the appropriate unit for mailing the requested materials. Periodically the prospect records contained in the Prospect System are matched against the records contained in the Admissions Management System (AMS) on the administrative mainframe. Prospect records which contain essential identifying information can create a new record in the mainframe based AMS if no record exists there for the person. For matching records, information from AMS is added to the Prospect System to provide a more complete and current record. The Prospect System supports and tracks follow­up contacts with prospective students over an extended period of time, in some cases for years, depending upon an individual's classification, or year in school, at the time of initial inquiry into UNT. The Prospect System was substantially enhanced in 1994 to support electronic transmittal of student information requests to Printing Services via the new Recruitment Materials Distribution System (RMDS).
   
Application Name: Broadcast Notification Service (BNS)
Software: SCO UNIX, "C"
Hardware: NCR 3345 (486 microchannel) PC's, BT­III voice processing units, Express 3174/SNA emulation product.
Location: UNT Computing Center
Batch/On-Line Status: On-Line
Application Description: This interactive voice response (IVR) system allows remote recording (from touch-tone phone) of messages to be spoken to callers during any emergency situation (including closing of the university due to severe weather conditions). Campus offices then transfer their phones to the emergency broadcast number so that callers are provided consistent information without regard to the office they call, and individual campus offices do not have to record individual or departmental messages.
   
Application Name: Career Planning & Placement Service Job Line
Software: SCO UNIX, "C", WRITE-1, TCP/IP, OS/2
Hardware: NCR 3345 (486 microchannel), generic Intel-based EISA machine w/ SCSI interface for disk and tape drives, BT-III voice processing units, SUN 1000E Server
Location: UNT Computing Center
Batch/On-Line Status: On-Line
Application Description: This interactive voice response system allows prospective graduates who have registered with the Career Planning and Placement (CPP) Office to call in and hear descriptions of job offerings in various categories. Employers first call CPP and describe job openings. CPP staff record the information about job offerings and categorize jobs into four major categories. These are Business, Education, Higher Education, and Other. Jobs are further categorized by geographic area and specialty. A "Business" job, for example, might be further categorized as accounting, retail, marketing, etc. Prospective graduates who register with CPP are allowed to call the job line interactive voice response system and hear information about job offerings. They can then call CPP if they with to schedule interviews with prospective employers. We hope to eventually expand the system's functionality so that prospective graduates can schedule interviews directly without calling CPP. The job information and prospective graduation information is maintained on a file server in Student Affairs. This interactive voice response application receives information from that system as needed.
   
Application Name: Financial Aid Voice Response System (FAVORS)
Software: SCO UNIX, "C", WRITE-1, SOLARIS
Hardware: NCR 3345 (486 microchannel) PC's, BT­III voice processing units, Express 3174/SNA emulation product, SUN 1000E Server
Location: UNT Computing Center
Batch/On-Line Status: On-Line
Application Description: This interactive voice response (IVR) system interacts with the Financial Aid Management System (FAMS) to allow students who have applied for financial aid to determine the status of their application from any touch-tone telephone. System includes provision for programmatically directing problem calls to appropriate individuals in the Financial Aid Office for resolution. Computer-generated voice messages provide students with requested information. [Note: The FAMS application is described separately.]
   
Application Name: Laser Optic Filing System (LOFS)
Software: Vendor Proprietary (TAB products)
Hardware: Vendor supplied equipment based on industry standard IBM compatible PC's with some propriety hardware.
Location: UNT Claims Accounting Office
Batch/On-Line Status: Online transactions to scan, file and retrieve document images.
Application Description: This application allows for scanning, filing, retrieving, viewing, and printing of document images on laser optical filing media. This system is currently being used by the Controller's Office to file backup documentation relating to claims disbursements made to vendors. Note: As of October 1994, this system was replaced with the ScanOptic imaging system described above for ongoing operations. LOFS will continue to be used in the retrieval mode to retrieve images previously scanned. It will continue being used this way until the end of the required retention period for the documents in the LOFS system, at which point it will be phased out in favor of the ScanOptic system.
   
Application Name: Recruitment Materials Distribution System (RMDS)
Software: UNIX, Novell Netware, MS­DOS/Windows
Hardware: Ethernet LAN, File Server, Desktop Work Station (PC), SUN SPARCserver 1000, HP LaserJet 4si laser printer and Bryce BOS12K high speed ink jet printer
Location: Admissions Office, UNT Computing Center, Printing Services
Batch/On-Line Status: Batch
Application Description: Contact information and requests for materials are received by the Admissions Office and entered into the Admissions Prospect System. This system (RMDS) is interfaced with the Prospect System such that information from these requests is automatically downloaded (i.e., no manual action required) via the network to the Printing Services machine at pre-selected intervals. Printing Services collects, packages, and mails the materials. Optionally, a copy of the prospect information, or just summary counts, or both of these types of feedback is also electronically forwarded (via the network) to the respective administrative and academic units who want the opportunity to send additional materials specific to their own area(s).
   
Application Name: ScanOptic Imaging System
Software: WATCOM SQL Database Server, Novell Netware, Vendor Proprietary Application Software
Hardware: Industry standard IBM-compatible PC's, HP Optical Jukebox, Bell & Howell Scanner
Location: UNT Claims Accounting Office
Batch/On-Line Status: Online transactions to scan, file and retrieve document images.
Application Description: This application allows for scanning, filing, retrieving, viewing, and printing of document images on laser optical filing media. It also provides the capability to fax images. This system is currently being used by the Controller's Office to file backup documentation relating to claims disbursements made to vendors. Over 800,000 document images are currently maintained in the system, consisting of vouchers and related documents processed beginning September 1, 1990 (for fiscal year 1991).
   
Application Name: Schedule of Classes / Room Booking System
Software: OS/VS COBOL, ADABAS, COM­PLETE, NATURAL, COM­PLETE, MVS/ESA
Hardware: IBM 9672 Mainframe
Location: UNT Computing Center
Batch/On-Line Status: Batch functions support mass update and reporting, on-line functions available for individual update and query.
Application Description: This system is used to gather information from the various university departments on course offerings. This information is used to create a schedule of classes bulletin for student use. As the title implies, the application includes a "Room Booking" sub-system which provides automated assistance in locating and assigning space (i.e., rooms) for classes and special events.
   
Application Name: Student Record Microfilm and Computer Assisted Retrieval System (Proprietary Kodak KAR 6500 System)
Software: PIC Operating System, Proprietary Application Software from Kodak
Hardware: Kodak proprietary server with attached planetary camera, terminals, printer, 9-track tape drive, and retrieval units.
Location: Registrar's Office
Batch/On-Line Status: Batch functions support mass updating and reporting, on-line support provided for retrievals.
Application Description: Provides for filming, storing, indexing, and retrieving admission applications, permanent UNT academic records, and transfer transcripts for all UNT students. Information for over 300,000 students dating back to 1890 are currently maintained in the system.
   
Application Name: Telephone Information System (TIMS)
Software: OS/VS COBOL, ADABAS, COM­PLETE, NATURAL, MVS/ESA
Hardware: IBM 9672 Mainframe
Location: UNT Computing Center
Batch/On-Line Status: Batch functions support mass update and reporting, on-line functions available for individual update and query.
Application Description: Collects, maintains, and reports detail information about university telephones (location, characteristics, etc.) and usage for long-distance calls. Receives long-distance call information from local telephone companies (GTE and AT&T), produces statements (bills), and electronically passes information to the General Ledger Accounting System (GLAS).
   
Application Name: Telephone Registration System (Telreg)
Software: SCO UNIX, "C", WRITE-1, SOLARIS
Hardware: NCR 3345 (486 microchannel) PC's, BT­III voice processing units, Express 3174/SNA emulation product, SUN 1000E Server
Location: UNT Computing Center
Batch/On-Line Status: On-Line
Application Description: This interactive voice response (IVR) system allows students to interact with the registration component of the SRS (Student Records System) providing students with the ability to accomplish the course scheduling functions of the registration process from a touch-tone telephone. Computer-generated voice messages notify the student of the result of requests, prompts for additional information, etc. [Note: The SRS application is described separately]

| Go Back to Table of Contents |