The purpose of this page is to list the various databases which are available on the Sybase extract server and to describe the type of information contained in each database. These databases represent periodic extracts of data from the university's mainframe legacy systems.
Also listed is the data steward who is responsible for the integrity of the database. The data steward is available to answer
questions about what data is available and where to find it in the database. They also approve security access to the data. For
security authorization to a database, complete the standard Access and Security Information (ACS-025) form and include the
database name from the table below.
| EXTRACT DATABASE NAME | DESCRIPTION OF INFORMATION IN THE EXTRACT | DATA STEWARD | REFRESH RATE |
|---|---|---|---|
| admiss | admission and application information with views for general admission, undergraduate admission, and graduate admission | University Registrar, 515-2576 | weekly |
| apps | current purchase order and small purchase data from the Accounts Payable Purchasing System (APPS) | Assistant Director, Purchasing, 515-6125 | daily |
| apps_fy | prior year-end snapshot (as of June 30) of purchase order and small purchase data from APPS | Assistant Director, Purchasing, 515-6125 | after year-end |
| appspurge | closed purchase orderes and small purchase data for prior fiscal years which has been purged from APPS | Assistant Director, Purchasing, 515-6125 | annually |
| facilities_ext | building and room identifiers, specifications, utilization, and other facilities information | Facilities Resources Specialist, 515-7675 | weekly |
| fas | current and prior year financial accounting information, including budgets and expenditures, from the Finnacial Accounting System (FAS) | Director, University Accounting, 515-3824 | daily |
| fas94 | fiscal year 1994-95, financial accounting information, including budgets and expendituresm from the Financial Accounting System (FAS) | Director, University Accounting, 515-3824 | after year-end |
| fas95 | fiscal year 1995-96, financial accounting information, including budgets and expendituresm from the Financial Accounting System (FAS) | Director, University Accounting, 515-3824 | after year-end |
| gars | graduate student committee and plan of work information from the Graduate Admission Record System | Director of Information Systems, Graduate School, 515-2873 | weekly |
| hrl_extract | student housing and resident information by semester | Asst. Director, University Housing, 515-3822 | daily |
| lookuptb | description tables for geographic codes, personnel codes, and other demographic values | Budget Office, 515-2175 | weekly |
| pics | personnel and payroll information from the Position Information Control System (PICS) and the Payroll System (PPPC) | Budget Office, 515-2175 | daily |
| PurchaseCard | purchasing credit card information | Purchase Card Administrator, 515-7810 | daily |
| recruiting | prospective student demographic, placement, ranking, testing, and other recruiting information | Director, Undergraduate Admnissions, 515-2434 | daily |
| regstr_ext | registration information, class rolls, student schedules, and address | University Registrar, 515-2576 | daily |
| regrec | student demographic information from Registration & records | Registration & Records, 515-2572 | daily |
| VendAddr | vendor information from Accounts Payable Purchasing System (APPS) | Assistant Director, Purchasing, 515-6125 | daily |
