| Enterprise Database and Applications - Database and Reporting Groups | |||||||||
| Task List | |||||||||
| 12/16/2003 | |||||||||
| System | Subsystem | Project Nbr. | Type | Project Description | Status | Est. Days | % Done | Due Date | |
| DBA | CMS | COUC0005 | IV | CMS/Remedy Interface | Hold | 20 | 25 | 06/30/2004 | |
| DBA | SIS | DOUC0007 | III | Migrate Schedule25 to Oracle | Hold | 5 | 75 | 06/30/2004 | |
| SIS | DWE | DOUN0010 | III | Create CPE Data Mart | Hold | 5 | 80 | 06/30/2004 | |
| HRS | DWE | K0203.0003 | III | Value-Based (Dept Level) Security for HRS | Active | 2 | 95 | 09/30/2003 | |
| SIS | DWE | K0203.0009 | IV | Add Missing SIS Records to Query Repository | Active | 10 | 0 | 01/31/2004 | |
| DBA | IDMS | K0203.0010 | I | Install IDMS Server | Active | 60 | 50 | 03/31/2004 | |
| FES | DWE | K0203.0014 | IV | Requirements for FES Value-Based (Dept Level) Security | Hold | 10 | 0 | 03/31/2004 | |
| SIS | DWE | K0203.0015 | IV | Requirements for SIS Value-Based Security | Hold | 10 | 0 | 03/31/2004 | |
| FRS | DWE | K0203.0026 | III | Provide FRS Purchasing Data for EBARS | Active | 5 | 80 | 10/31/2003 | |
| DBA | DWE | K0203.0040 | IV | Standardize Naming Conventions | Active | 20 | 30 | 02/29/2004 | |
| DBA | Housing | K0304.0005 | I | Move Housing Database to Temporary Server | Hold | 5 | 75 | 01/31/2004 | |
| DBA | WebFOCUS | K0304.0009 | IV | WebFOCUS Demo of UKY Self-Service Appls | Active | 10 | 90 | 11/30/2003 | |
| SIS | DWE | K0304.0010 | IV | Course Mgmt Data Mart w/ETL Tool | Active | 10 | 60 | 01/31/2004 | |
| HRS | DWE | K0304.0011 | IV | HRS Stat w/ETL Tool | Active | 10 | 30 | 12/31/2003 | |
| DBA | DWE | K0304.0015 | IV | Create Metadata Database & Application | Active | 40 | 50 | 01/31/2004 | |
| DBA | CPE | K0304.0016 | I | WebFOCUS CPE Requests - Fiscal Year 2004 | Active | 80 | 30 | 06/30/2004 | |
| DBA | FAM | K0304.0017 | I | WebFOCUS FAM Requests - Fiscal Year 2004 | Active | 100 | 30 | 06/30/2004 | |
| DBA | HRS | K0304.0018 | I | WebFOCUS HRS Requests - Fiscal Year 2004 | Active | 280 | 30 | 06/30/2004 | |
| DBA | HRS | K0304.0019 | I | WebFOCUS Label Requests - Fiscal Year 2004 | Active | 140 | 30 | 06/30/2004 | |
| DBA | SIS | K0304.0020 | I | WebFOCUS SIS Requests - Fiscal Year 2004 | Active | 280 | 30 | 06/30/2004 | |
| HRS | DWE | K0304.0022 | IV | Requirements for HRS Vacancy Report | Active | 15 | 5 | 02/29/2004 | |
| DBA | WebFOCUS | K0304.0023 | I | Upgrade WebFOCUS to Version 5.2 | Active | 400 | 5 | 03/31/2004 | |
| DBA | Oracle | K0304.0024 | I | Upgrade UKYP Database to Oracle 9.2 | Hold | 40 | 80 | 12/31/2003 | |
| DBA | CMS | K0304.0026 | I | Upgrade CMSP Database to Oracle 9.2 | Active | 20 | 15 | 01/31/2004 | |
| DBA | SQLSVR | K0304.0028 | III | Move EUROPA SQL Server to New Machine | Active | 10 | 1 | 12/31/2003 | |
| SIS | DWE | K0304.0029 | I | Improve Total Execution Time for SIS Incremental | Active | 10 | 10 | 12/31/2004 | |
| DBA | IDMS | K0304.0030 | I | Upgrade IDMS to Version 15.0 | Active | 40 | 10 | 03/31/2004 | |
| DBA | IDMS | K0304.0032 | I | IDMS Support - Fiscal Year 2004 | Active | 240 | 30 | 06/30/2004 | |
| DBA | Oracle | K0304.0032 | III | Move UKYP Database to New Machine | Pending | 2 | 0 | 12/31/2003 | |
| DBA | Oracle | K0304.0033 | I | Oracle Support - Fiscal Year 2004 | Active | 240 | 30 | 06/30/2004 | |
| DBA | SQLSVR | K0304.0034 | I | SQL Server Support - Fiscal Year 2004 | Active | 240 | 30 | 06/30/2004 | |
| DBA | GASB | K0304.0035 | I | GASB Support - Fiscal Year 2004 | Active | 100 | 30 | 06/30/2004 | |
| DBA | INF | K0304.0036 | I | Project 2002 Support - Fiscal Year 2004 | Active | 80 | 10 | 06/30/2004 | |
| DBA | INF | K0304.0037 | I | SharePoint Team Services Support - Fiscal Year 2004 | Active | 80 | 10 | 06/30/2004 | |
| DBA | INF | K0304.0038 | II | Internet Access for Ky Housing Corp | Active | 60 | 10 | 10/31/2003 | |
| DBA | SIS | K0304.0039 | III | Student E-mail Auditing of Account Status | Active | 5 | 80 | 09/30/2003 | |
| DBA | ConfMgmt | K0304.0040 | IV | Conference Management - Phase I | Active | 10 | 10 | 01/31/2004 | |
| DBA | KYVU | K0304.0041 | IV | KYVU Interface - Phase I | Hold | 20 | 1 | 02/29/2004 | |
| DBA | CopierBilling | K0304.0042 | IV | Copier Billing Web Application | Pending | 10 | 0 | 01/31/2004 | |
| DBA | ResLife | K0304.0043 | IV | Resident Life Program Tracking | Pending | 60 | 0 | 01/31/2004 | |
| DBA | STEPS | K0304.0044 | IV | STEPS Batch Hospital Load | Pending | 20 | 0 | 01/31/2004 | |
| FRS | DWE | K0304.0045 | IV | FRS Purchasing & Vendor Data | Pending | 20 | 0 | 01/31/2004 | |
| DBA | OCT | K0304.0046 | IV | Electronic IDIVs | Active | 20 | 60 | 01/31/2004 | |
| DBA | Advising | K0304.0046 | IV | Central Advising Web Application | Hold | 20 | 10 | 02/29/2004 | |
| DBA | INF | K0304.0047 | III | Absence Web Application | Active | 20 | 65 | 12/31/2003 | |
| DBA | HRS | K0304.0048 | III | Performance Evaluation Tracking | Active | 10 | 20 | 01/31/2004 | |
| DBA | INF | K0304.0049 | IV | Syslog Interface | Active | 10 | 10 | 01/3/2004 | |
| DBA | INF | K0304.0050 | II | Eliminate use of VNC Software | Active | 5 | 30 | 12/31/2003 | |
| DBA | INF | K0304.0051 | II | Eliminate use of ATAMAN Software | Active | 40 | 10 | 03/31/2004 | |
| DBA | ETL | K0304.0053 | I | ETL Support - Fiscal Year 2004 | Active | 240 | 30 | 06/30/2004 | |
| IR | DWE | K0304.0054 | IV | SAS/IR Data in Oracle DWE | Pending | 60 | 0 | 01/31/2004 | |
| IR | DWE | K0304.0055 | IV | Generate Unique Cross-Reference ID for DW/DM | Pending | 60 | 0 | 01/31/2004 | |
| FRS | DWE | K0304.0056 | IV | Requirements for FRS View Enhancements | Active | 10 | 0 | 02/29/2004 | |
| DBA | DWE | K0304.0057 | IV | Requirements for Miscellaneous View Issues | Pending | 10 | 0 | 02/29/2004 | |
| FRS | DWE | K0304.0059 | IV | Requirements for New FRS Elements & Views | Pending | 10 | 0 | 02/29/2004 | |
| FRS | DWE | K0304.0060 | IV | FRS Old Year Data (1993-1997) | Active | 10 | 50 | 02/29/2004 | |
| DBA | DARWin | K0304.0061 | IV | Extract SIS Data for DARWin | Pending | 5 | 0 | 01/31/2004 | |
| DBA | Amcom | K0304.0062 | IV | Analysis & Application Support of Amcom & SmartWeb | Active | 40 | 35 | 01/31/2004 | |
| DBA | Amcom | K0304.0063 | IV | Update Amcom Database for SmartWeb | Pending | 20 | 0 | 03/31/2004 | |
| DBA | Remedy | K0304.0064 | IV | Create Remedy Development Environment | Pending | 20 | 0 | 02/29/2004 | |
| DBA | Remedy | K0304.0065 | IV | Update Remedy Application & Database | Pending | 20 | 0 | 02/29/2004 | |
| DBA | GASB | K0304.0066 | III | GASB Enhancements | Active | 20 | 5 | 03/31/2004 | |
| DBA | INF | K0304.0067 | IV | Ky Transportation Center | Active | 5 | 40 | 01/31/2004 | |
| DBA | DWE | K0304.0068 | I | Move UKWH Database to New WH Prod Machine | Active | 10 | 5 | 02/29/2004 | |
| DBA | DWE | K0304.0069 | I | Install Oracle Database on New WH Dev Machine | Active | 5 | 5 | 02/29/2004 | |
| DBA | WebFOCUS | K0304.0070 | IV | Web Report Delivery for Institutional Research | Active | 15 | 50 | 01/31/2004 | |
| DBA | WebFOCUS | K0304.0071 | IV | Web Report Delivery for Student Billing | Active | 15 | 10 | 01/31/2004 | |
| DBA | IDMS | K0304.0072 | I | Install SCT 1098-T Package for FAM | Active | 5 | 50 | 01/31/2004 | |
| FRS | DWE | K0304.0072 | IV | Add Missing FRS Records to Query Repository | Active | 10 | 1 | 01/31/2004 | |
| DBA | INF | K0304.0073 | I | Change FOCMVS filenames to IDMSXTR | Active | 10 | 2 | 01/31/2004 | |
| DBA | WebFOCUS | K0304.0073 | IV | Modify TRANSEXTR for College of Education | Active | 10 | 1 | 01/31/2004 | |