DATA ADMINISTRATION
Task List
12/16/2003
System	Sub system	Project #	Type	Description	Est. Days	Hours Completed	Days Completed	% Done	Days Remaining	Months Remaining	Deadline	Comments	Status
DA	MISC	EXXN0000	III	ERP Preparation	30	81.00	10.13	34	19.88	0.99			Active
DA	DQ	IQUP0001	I	Cleanse vendor file data in FRS.	150	925.50	115.69	77	34.31	1.72		Significant additional effort on this project is being done by Purchasing and A/P.	Hold
DA	DQ	IQUP0003	I	Cleanse marital status data in SIS and HRS.	40	193.00	24.13	60	15.88	0.79		Significant additional effort on this project will need to be done by Student Financial Aid.  (This was put on hold as it is a low priority.)	Hold
DA	DQ	IQUP0004	I	Cleanse student residency code data in SIS.	10	0.00	0.00	0	10.00	0.50		Assistance from Registrar's Office will also be required.  (This is on hold as we are currently focusing on the address cleansing.)	Hold
DA	DQ	IQUP0005	I	Cleanse admissions status and registration status in SIS.	10	0.00	0.00	0	10.00	0.50		This problem was reported during a meeting with Ruby Watts in 2000.	Not Assigned
DA	DQ	IQUP0006	I	Procedure to obtain access to Institutional Data	10	0.00	0.00	0	10.00	0.50			Hold
DA	DQ	IQUP0008	I	Cleanse building code and name, and room number data on the institutional systems.	60	107.00	13.38	22	46.63	2.33		Need to review Space and Equipment Inventory, FRS, HRS, SIS, LC and MC PPD, AXIS, Remedy, Network Database, Room Scheduling, etc. systems.  (This project has been focused on reconciling the data in SIS and the Space Inventory file in 3Q 2001.)	Active
DA	DQ	IQUP0011	I	Cleanse country code data in SIS, FRS and HRS.	40	57.00	7.13	18	32.88	1.64			Hold
DA	DQ	IQUP0012	I	Cleanse state code data in SIS, FRS and HRS.	10	40.00	5.00	50	5.00	0.25			Hold
DA	DQ	IQUP0013	I	Cleanse county code data in SIS, FRS and HRS.	10	40.00	5.00	50	5.00	0.25			Hold
DA	DQ	IQUP0014	I	Cleanse zip code data in SIS, FRS and HRS.	10	0.00	0.00	0	10.00	0.50			Hold
DA	DQ	IQUP0018	I	Cleanse FRS address records using MailerSoftware and USPO standards.	20	0.00	0.00	0	20.00	1.00		(This project will be activated after the completion of the SIS address corrections.)	Hold
DA	DQ	IQUP0019	I	Cleanse HRS address records using MailerSoftware and USPO standards.	20	6.00	0.75	4	19.25	0.96		('This project will be activated after the completion of the SIS and FRS address corrections).	Hold
DA	DQ	IQUP0023	I	Evaluate/fix bad data in IPEDS file - bad/old map to CIP codes.	30	0.00	0.00	0	30.00	1.50		This problem was identified by Gary Lindle in a meeting on 3/21/01 and he suggested talking to Barry Rankin about it.	Not Assigned
DA	DQ	IQUP0024	I	Collect credential information for all instructors to ensure courses are taught by qualified people per SACS recommendations (PRF-00030).	100	730.75	91.34	91	8.66	0.43		9/03 IQUP0020 incorporated into this project (45DEst, 97HComp).	Active
DA	MISC	IREA0001	II	Institutional Reporting (Required) Personnel EEO and IPEDS	60	90.00	11.25	19	48.75	2.44		This is an ongoing (term) task. It is done in the fall/cal year end of each year.	Active
DA	MISC	IRUA0001	II	Institutional Reporting (Required) CPE Enrollment	150	1147.25	143.41	96	6.59	0.33		This is an ongoing (term) task. This effort is for the Summer and Fall sessions - enrollment.	Active
DA	MISC	ISUN0001	III	Develop database for tracking data quality projects and reports.	20	40.00	5.00	25	15.00	0.75		(This project is on hold until the completion of the vendor data cleansing project.)	Hold
DA	MISC	ISUN0090	III	Miscellaneous projects sum - for Data Administration	180	952	119.00	66	61.00	3.05			Active
DA	MISC	ISUN0091	III	Miscellaneous projects - for Jayna Cheesman	20		0.00	0	20.00	1.00			Active
DA	MISC	ISUN0092	III	Miscellaneous projects - for Mike Carter	100	734	91.75	92	8.25	0.41			Active
DA	MISC	ISUN0093	III	Miscellaneous projects - for Deb Claunch	20		0.00	0	20.00	1.00			Active
DA	MISC	ISUN0094	III	Miscellaneous projects - for Judy Kisil	40	218	27.25	68	12.75	0.64			Active
DA	DW	IUUN0000	IV	Data Warehouse planning and education.  (Includes RFP process for ETL and Enterprise Reporting Tools.)	170	1250.50	156.31	92	13.69	0.68		This could be an ongoing task for quite awhile.  It includes any research on DW, development of presentations and education materials, and creation/maintenance of project plan.	Active
DA	DW	IUUN0002	IV	Analysis and testing to load FRS data to the Data Warehouse to address GASB reporting requirements, and coding/testing of the reports.	300	2055.75	256.97	86	43.03	2.15	3/31/2003	Some effort will be associated with the loading of non-FRS data into the Data Warehouse. Additional effort for the DBAs is included in task DOUN00010.   Includes Phase II.	Active
DA	DW	IUUN0003	IV	Analysis and testing for elements to load six years of CPE data into Data Warehouse.	60	460.00	57.50	96	2.50	0.13		Additional effort for the DBAs is included in task DOUN00010.	Active
DA	DW	IUUN0004	IV	Analysis, requirements document and testing for elements to load into Data Warehouse for PRF-00002, the data to supplement the CPE data.	40	32.00	4.00	10	36.00	1.80		Additional effort for the DBAs is included in task DOUN00010. (This is on hold as it is a lower priority than other DW requests.)	Hold
DA	DW	IUUN0005	IV	Analysis, requirements document and testing of data to load into Data Warehouse for PRF-00003, six years of the faculty/staff stat files.	60	10.00	1.25	2	58.75	2.94		Additional effort for the DBAs is included in task DOUN00010. (This is on hold as it is a lower priority than other DW requests.)	Active
DA	DW	IUUN0006	IV	Analysis, requirements document and testing of data to load into Data Warehouse for PRF-00005, data to supplement the faculty/staff stat file data.	60	0.00	0.00	0	60.00	3.00		Additional effort for the DBAs is included in task DOUN00010. (This is on hold as it is a lower priority than other DW requests.)	Not Assigned
DA	DW	IUUN0007	IV	Analysis, requirements document and testing of data to load into Data Warehouse for PRF-00008, change admissions purge program to load data to DW.	40	15.00	1.88	5	38.13	1.91		Additional effort for the DBAs is included in task DOUN00010. A new task will need to be added to the SIS task list for changing the purge program.	Hold
DA	DW	IUUN0008	IV	Analysis, requirements document and testing of data to load into Data Warehouse for PRF-00009, load last seven years of archived admissions data to DW.	20	0.00	0.00	0	20.00	1.00		Additional effort for the DBAs is included in task DOUN00010. A new task will need to be added to the SIS task list to create the program to retrieve the archived data from tape.	Not Assigned
DA	DW	IUUN0009	IV	Analysis, requirements document and testing of data to load into Data Warehouse to address RCTF reporting needs.	60	0.00	0.00	0	60.00	3.00		Some of this data will not come from FRS, FES and HRS.  Additional effort for the DBAs is included in task DOUN00010.	Not Assigned
DA	DW	IUUN0010	IV	Analysis, requirements document, coding and testing for creation of Course Demand summary data to load into Data Warehouse, and additional report formats to address retention analysis needs.	25	140.00	17.50	70	7.50	0.38		Detail course demand data is already in an Oracle database, and needs to be made accessible to/from the Data Warehouse.  This needs to be completed before IUUN0012.  Additional effort for the DBAs is included in task DOUN00010.	Hold
DA	DW	IUUN0011	IV	Analysis and requirements document for "master calendar" to be used to schedule the extraction of historical snapshots of FRS, HRS, FES and SIS data to load into Data Warehouse.	10	4.00	0.50	5	9.50	0.48		(This is on hold as it has a lower priority than other DW requests.)	Active
DA	DW	IUUN0012	IV	PRF-00025 'Analysis, requirements document, coding, data quality projects, and testing for creation of Course Management data to load into Data Warehouse, and production of the Course Management Reports.   This includes production of Classroom Utilization Reports.	233	1654.75	206.84	89	26.16	1.31		Detail course data in Oracle db, needs to be accessible to/from DW.  Builds on work done in IUUN0010.  Additional effort for the DBAs included in DOUN00010.   9/26/03 Incorporated IQUP0007, IQUP0009, IQUP0010, IQUP0016, 250HComp.	Active
DA	DW	IUUN0018	I	Data Warehouse Data and Maintenance issues.	50	236.00	29.50	59	20.50	1.03		Includes identification and resolution of data issues as well as data 'views' issues.	Inactive
		IUUN0020	IV	PRF-00037 Query Repository View Enhancements	30	196.75	24.59	82	5.41	0.27			Active
		IUUN0021	IV	PRF-00035 'Analysis, requirements document, coding, data quality projects, and testing for creation of Resource Management data to load into Data Warehouse, and production of the Resource Management Reports.	145	0.00	0.00	0	145.00	7.25			Not Assigned
DA	DW	IUUN0022	IV	Naming Standards	120	387.50	48.44	40	71.56	3.58			Active
DA	DW	IUUN0023	IV	Report Conversions - conversion of Brio and Crystal Reports due to view and name changes	120
DA	DW	IUXC0001	I	Consultation, testing, and conversion on Web FOCUS implementation.	60	304.00	38.00	63	22.00	1.10		(This has been 'unofficially' put on hold) 'Additional effort for the DBAs is included in tasks DJXC0001 and DOXC001. As of 5-15 it's back on again.	Active
DA	ALL	IXUN0001	III	Project Management Methodology	60	411.50	51.44	86	8.56	0.43			Active
DA	MISC	IXUN0002	II	Personnel Reporting	90	529.00	66.13	73	23.88	1.19		Miscell Reporting (Delaware study, MSFT,Novell,ALA)	Active
DA	MISC	IXUN0003	II	Federal and State Reporting Documentation and Project Plans	60	96.00	12.00	20	48.00	2.40			Hold
	MISC	IXUN0004	II	Student Reporting	80	546.00	68.25	85	11.75	0.59		This is for Fall 2003 CPE reporting and IPEDS Institutional reporting)	Active