{"text_format":"2","workbook":"xls","n_sheets":10,"sheets":["Task_Table1","WesNet","2007 Done","2006 Done","2005 Done","2004 Done","2003 Done","2002 Done","2001 Done","1999-2000 Done"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Task_Table1","index":0,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Task","Request Date","Finish","Status","Resource (Leader)","Comment"]
["Data Cleanup"]
[]
["Production Bug Corrections"]
["Mill 7.4 issues:",{"$nulls":4},"Assignments - Run time issues.              Attachments on Chart of Accounts(reported as a bug to SAGE)"]
["Miscellaneous Enhancements"]
["Wesnet Tracking Report enhancement (for Volunteers)","2006-02-01",null,null,"Andrea","Add 2 new columns---last name, class year"]
["FRS Feed Issues","2006-02-27",null,null,null,"Need to make a change for ftp to willet.  Either feed frsbatch tables, and no ftp, or change the ftp model that we are using.  Either way, look at changing the time that the job runs."]
["Create files for wesleyan connection and wesleyan extra","2006-06-01",null,"In Progress","Jane","Create files on a weekly basis, that can be used to send the wesleyan connection and the wesleyan extra"]
["UR Calendar","2006-01-01",null,"In Progress","Ravi, Steve M., Jane","Work with UR and Portfolio Programming to create a ur calendar similar to the Wesleyan Events Calendar"]
["Website Development/Enhancements"," "," "]
["OnLine giving site","2004-11-01",null,"In Progress","Felix, Jane","In conjunction with implementation of Infinet - review and revamp online giving site, meeting with Mark Bailey, Deb Treister--review page structure  Meet with Infinet 5/9/06"]
["Change Online Giving Site for the introduction of The Wesleyan Fund. Also add the sciences to the dropdown for priorities.","2006-06-12",null,null,"Doug, Jane"]
["Work with Social Psych Network to use infinet","2005-11-09",null,null,"Felix","Deb to coordinate meeting with Ann, Jane, Felix, Steve, Daune to evaluate"]
["Add access to Fiscal Year Goals table for end user","2006-06-01",null,"In Progress","Doug"]
["Add access to Mini Case Statements in WesNet","2006-06-05",null,"In Progress","Jane"]
["Change Athletics tab in Wesmill","2006-06-28",null,null,"Doug","Under Athletics in Wesmill, change the name 'Calendar Import' to 'Calendar Results Import'."]
["Homecoming Family Weekend","2006-07-13"]
["RC07 Questionnaire","2006-07-16"]
["Reporting"," "," ",null," "]
["WAF Monthly Comparison Enhancement","2005-08-26",null,"In Progress","Sharon","Req'd by A. MarthNeed to adapt existing report for Parents and GLSP alumni (with existing detail about participation, # LYBUNTs, SYBUNTs, dollars, pledges, etc.)"]
[]
["Snapshot Class Giving (class analysis)",null,null,"In Progress","Sharon","Re do  selection logic, add verbals, breakout matching - test version available in production done -waiting for new fiscal year to implement per D. Astin"]
["Measure Fundraiser Results","2006-03-30",null,"In Progress","Jane","Create new report, fundraiser review to help determine what it takes to secure a gift."]
[]
["Reunion Class Analysis with Spouse","2006-06-22",null,"In Progress","Sharon","Add columns per Andrea; add number of $2500-4999 WAF Support; add number of $5000-$9999 WAF Support; add Number of @10k+ WAF Support; Change Number of 1k+ WAF Support to be Number of $1000-$2499; Add # of Olin Associates by class based off othe attribut 'rolin'"]
["Bridging Functionality","1999-05-01T08:00:00"]
["HR Import","2004-10-01",null,null,null,"(Low) HR import - They are reviewing how they store Faculty in HR.  If there is a change, we will have to change import"]
["Feed WSA groups into Mill","2001-05-09",null,null,"Sharon","(LOW) part of getting extra curricular info into Mill. Mill feed must access SFIS Extracurricular table"]
["Database"," "," "]
["Broadcast Email","2005-04-08",null,"In Progress","Jane, Deb","(HIGH)"]
["Major Gifts OnLine Reporting System","2005-04-11",null,"In Progress","Jane, Deb, Felix","(HIGH)Decide where to build functionality so that Major Gift officers can access donor profiles/giving information (WesNet vs. Millennium)Addtions to Donor View.  Liftetime Support, add an indicator if the donor is an llin associate, donor detail page, add a column to indicate that a pledge or gift has a life income designation, donor detail page sort the transactions in order of campaign year"]
["Install 7.5","2005-03-01"]

{"sheet":"WesNet","index":1,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Task","Start","Finish","Status","Resource (Leader)","Comment"]
["WesNet Production Bug Corrections",null,null,null," "]
[]
["WesNet Enhancements",null,null,null," "]
["2005 Reunion Survey","2005-08-01",null,null,null,"req'd by Makaela Steinberg.  Post 2005 reunion survey on WesNet"]
["WesCan Search","2005-03-18",null,null,null,"req'd by Msimonson  Single select pulldown for Degree in Post Grad. Deg. Info. Section of WesCAN search should be converted to multi-select box (5 items high)"]
["Parent Online Community","2003-01-01",null,"HOLD",null,"(HIGH) req'd by M.Zocco"]
["Volunteer Module","2003-01-01",null," ",null,"(HIGH) req'd by A. Marth"]
["WAF Volunteer Module","2003-07-24",null,"In process","Jane, M.Herlihy","(HIGH) req'd by A. Marth"]
["Move Class Notes into WesNet","2003-09-25",null,"HOLD","Dave","(HIGH) req'd by B. Holder"]
["Revamp Signup process","2004-03-17",null,"In Progress","Dave","(HIGH) from team meeting 3/17/04."]
["CRC - Volunteerism enhancement","2003-11-13",null,null,"Dave","(HIGH) req'd by M. Simonson at team meeting - link to signup page to be a CRC volunteer"]
["Include Graduate Alumni ","2003-03-03",null,"In Progress","Felix","(HIGH) req'd at All-Staff Mtg, & CRC"]
["Provide link to Admission Postcard site","2004-03-17",null,null,"Dave","(MEDIUM) from team meeting 3/17/04.  "]
[]
["Report contact info changes of others","2003-03-29",null," ",null,"(MEDIUM) AAEC Mtg - allow alumni to supply info on other alumni"]
["CRC - Work History2 - enhancement","2003-11-13",null,null,null,"(MEDIUM) req'd by M. Simonson at team meeting - See CRC's prioritized list - anecdotal, advice, other involvement"]
["CRC - WesNet Listserve","2003-11-13",null,null,null,"(MEDIUM) req'd by M. Simonson at team meeting - listserve within WesNet"]
["Display Wesleyan Volunteer Involvement","2004-02-03",null,null,null,"(MEDIUM) req'd by M. Simonson - but should also be for all Wes Volunteers not just CRC Vols."]
["CRC - Alumni to alumni job posting","2003-03-13",null," ",null,"(LOW) req'd by M. Sciola & M. Simonson - see CRC's prioritized list"]
["CRC - Resume Searching enhancement","2003-11-13",null,null,null,"(LOW) req'd by M. Simonson at team meeting - allow employers to search thru alumni resumes"]
["CRC - Resume Book enhancement","2003-11-13",null,null,null,"(LOW) req'd by M. Simonson at team meeting - Vendor solution?"]
["CRC - Chatrooms ","2003-11-13",null,null,null,"(LOW) req'd by M. Simonson at team meeting"]
["Profile Page - Link to Feedback Form","2003-03-29",null," ","Dave","(MEDIUM) AAEC Mtg"]
["Signed up alumni - with private info in Mill","2004-02-03",null,null,null,"(LOW) req'd at 2/3/04 team meeting - expand the function that hides WesNet data if someone is marked private in Mill. Expand to function for alumni who have signed up for WesNet."]
["Display/Update of Societies in the Directory","2004-02-18",null,null,null,"(LOW) team meeting 2/18/04 data cleanup in Mill - not Award attribs, and include in Directory search?, display"]
["Email Harris opt out's to allow opt in","2003-03-29",null,null,null,"(MEDIUM) AAEC Mtg - notify those Harris no-publishes to opt back in"]
["Address book function ","2003-02-03",null,null,null,"(LOW) req'd by C. Kelly-take from the search and link to the alumns display page."]
["Submit/Read Class Notes","2003-02-03",null,null,null,"(LOW) req'd by C. Kelly"]
["Change Form- more than 1 occupation","2003-02-03",null,null,null,"(LOW) req'd by B. Rosenberg- allow alumni to input more than 1"]
["Converse with others logged on","2003-03-26",null,null,null,"(LOW) UR Alumni Review Session - function to see who else is logged on and have live chats"]
["Events Calendar - Enhancement","2003-03-26",null,null,null,"(LOW) UR Alumni Review Session - don't open new browser"]
["Change Form - mulitple majors","2003-03-29",null,null,null,"(LOW) AAEC Mtg - input multiple majors"]
["Webboards","2003-03-26",null,null,null,"(LOW) UR Alumni Review Session "]
["Chatrooms/Message Boards","2003-01-01",null,null,null,"(LOW) "]
["Audit Trail of WesNet Usage","2003-03-19",null,null,null,"(LOW) req'd Project Status Mtg -searches, most visited pages, where they came from, where they went to"]
["Industry Related Networking/ Mentoring module","3/13/03, 7/8/03",null,null,null,"(LOW) req'd by M. Sciola"]
["CRC Scheduled Events","2003-07-09",null,null,null,"(LOW) req'd by M. Sciola, virtual job fair, industry focused virtual panel"]
["Link to major alumni events directly","2003-02-03",null,null,null,"(LOW) req'd by C. Kelly- not through the \"calendar\""]
["Alumni to post personal info","2003-02-03",null,null,null,"(LOW) req'd by C. Kelly- alum to post info photos of family, job, etc"]
["Include Alumni Giving Info","2003-03-03",null,null,null,"(LOW) req'd at All-Staff Mtg - alum can see their own giving "]
["Search Screen - exact match search","2003-03-26",null,null,null,"(LOW) UR Alumni Review Session - check off box to do an exact find"]
["\"OR\" searches","2003-02-03",null,null,null,"(LOW) req'd by B. Rosenberg"]
["Auto login to IMP ","2003-03-26",null,null,null,"(LOW) UR Alumni Review Session"]
["Results Page -Additional sort columns","2003-02-03",null,null,null,"(LOW) req'd by B. Rosenberg"]
["Variable display of alumni info","2003-02-03",null,null,null,"(LOW) req'd by C. Kelly - allow certain people to know all your info, but keep info to the general alumni public more limited"]
["S/A Actions Audit Trail","2003-03-19",null,null,null,"(LOW) req'd Project Status Mtg-track what/when/why S/A makes changes "]
["Organize your own events","2003-02-03",null,null,null,"(LOW) req'd by C. Kelly- organize your own mini-Wesleyan events with your friends"]
["Profile Page - display birth mmdd","2003-03-26",null,null,null,"(LOW) UR Alumni Review Session - show birth month and day – not birth year"]
["Profile Page - Display last Update Date","2003-03-29",null,null,null,"(LOW) AAEC Mtg "]

{"sheet":"2007 Done","index":2,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Task","Request Date","Finish","Status","Resource (Leader)","Comment"]
["Honor/Memory Report","2006-05-17","07/142006","Done","Sharon","Rearrange columns and add version of report to run by constituent per D. Treister specs."]

{"sheet":"2006 Done","index":3,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Task","Request Date","Finish","Status","Resource (Leader)","Comment"]
["Duplicate Match Credits",null,null,"Done","Sharon","Cleanup duplicate match credits.  Add Data Anomaly scan to detect duplicate match credits.  Change Data Anomaly Error Report to allow printing of only duplicate match credits errors.  Notify Sage of TA_Gifts bug."]
["Add Binswanger nomination capability to Wesnet","2005-11-18","2006-01-03","Done","Felix, Jane","Requested by Gail Briggs, Kathy Macko and Marcy Herlihy"]
["Athletics--Treat golf, tennis, crew & track(indoor, outdoor) differently in the rollover process","2006-01-30",null,"Done","Sharon","Athletics--Treat golf, tennis, crew & track(indoor, outdoor) differently in the rollover process"]
["Honor Roll Enhancements",null,null,"Done","Dawn, Jane","(HIGH) needed by Mid Jan. '05"]
["Completed Contact Reports",null,"2005-11-28","Done","Felix ","(LOW) req'd by Dawn Astin provide option to run by individual author, also req'd by Karne Stribula, create a totals report option, this would show totals by person, with no detail"]
["Install 7.4 on Production System",38732,38740,null,"Jane, Deb","Done"]
["HR Import","2006-03-09",null,"Done","Sharon","Change to bridge retirees; change to allow updates to all employees home addresses regardless of whether they're an alum or not"]
["Pledge Key Storage","0317/06",null,"Done","Sharon","Think about using giftnum(1 or 2) for the storage of the pledge key, which is currently stored in gifttext. We are not going to do this, because of the display issues."]
["Events Reports","2005-10-27","2006-03-15","Done","Jane","Need two new spreadsheets for events 1  List of wesids who have registered by mail--need a date parameter   2.  List of registrant wesids, not including guests Skampen"]
["Giving Priorities","2006-01-26","2006-04-01","Done","Marcy/Dawn/Jane","Need to store giving priorities on the actual gift row.  Cleanup required"]
["Gift Receipts","2006-02-10",null,"Done","Sharon, Deb","Increased giving, Reunion messaging; salutation for BJW & DJB letters, new file for WESU"]
["Trustee Ballot 2006",null,null,"Done","Jane"]
["Reunion 2006",null,null,"Done","Felix"]
["AOC Reunion 2006",null,null,"Done","Felix"]
["HR Import","2006-03-03","2006-03-10","Done","Sharon","Bridge retiree name/address chgs.  Bridge alum employees address chgs."]
["Event Counts Report","2006-04-26","2006-04-28","Done","Sharon","Redo report logic to correct bugs."]
["Data Anomaly Scan","2006-03-06","2006-05-08","Done","Sharon","Add username to error, add new scans, remove inactive scans."]
["Athletics Lyris Lists","2006-01-30",null,"Done","Sharon","Create views of emails for each team and for each season for the current academic year."]
["OnLine giving site","2006-01-31",null,"Done","Felix, Jane","Enhancements:  Need an anonymous designation.  Need a comments box(done 2/10).  Need to have them choose 'highest priority'"]
["Identify Outstanding Matching Gifts","2005-11-09",null,"Done","Felix","Req'd by D. Treister  Need a report that pulls all open match potential and matching pledge > 6 months old.  Spreadsheet with wesid, name of donor, name of company and amount  12/9  Deb is testing"]
["WAF Pyarmid Report Enhancements","2005-08-26","2006-04-12","Done","Sharon","Req'd by A. Marth.  Our existing report provides a gift-level pyramid for all alumni, with giving totals for other constituencies. Would like to develop a comprehensive pyramid with gift-levels for all constituencies in one, then adapt gift-level table for individual constituencies/breakouts: (1) all alumni (2) alumni in individual classes, (3) all reunion classes, (4) all non-reunion classes, (5) all parents, (6) current parents, (7) past parents, (8) parents by parent-year, (9) GLSP alumni. Would like to break out existing giving levels at the bottom of the pyramid (currently @ $1 - $499, $500 - $1,000) to show gifts at these levels: $1 - $99; $100 - $249; $250 - $499. Req'd by A. Marth - Enhance the WAF Pyramid in WesMill to have a parameter allowing it to run against an export table and include the current year WAF Target and Capacity in the detail section of the report.  Also add donor levels for Parents.  Second version of report for Household."]
["WAF Progress Summary","2006-03-01","2006-05-01","Done","Jane","Create a weekly report for relationship managers to review progress"]
["Pilot 7.5 testing","2006-03-11",null,"Done","Jane, Deb"]
["Waf Target Logic","2005-10-27","2006-06-01","Done","Sharon","Whereever we are looking at waf target, make sure to look at campaign year, not just if the rating row is active  Dastin"]
["WAF Verbals","2005-11-18","2006-06-01","Done","Sharon","Req'd by D. Astin/A. Marth - Add WAF Verbals to all WAF reports  Needs to be added to the Class Analysis (snapshot class giving) WAF Pyramid and Monthly/Weekly Comparison (new report)  Current fiscal year waf verbals only  They have been added to the donor datamart, and it has been added to the new waf pyramid."]
["Data Anomaly Scan Report","2006-05-05",null,"Done","Sharon","Create multiple versions of report either by table or source."]
["Pledge Reminders","4/24//2006","2006-06-08","Done","Sharon","Make No RM version. For D. Treister"]
["Fiscal Year Cash Report","2006-04-24","2006-06-30","Done","Sharon","Create new fiscal year cash report - specs on Dragon - report written, goals may need tweaking per D, Astin"]

{"sheet":"2005 Done","index":4,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Completed Tasks 2005"]
["Task","Request Date","Finish","Status","Resource (Leader)","Comment"]
["Data Cleanup"]
["City/Club Events","2005-02-03","2005-09-14","Done","Sharon","Req'd by J. Jylkka.  Develop routine to clean up the invited guests to OLD city/club events"]
["Ballot Attribute Cleanup","2005-09-15","2005-09-07","Done","Sharon","Per Marcy, cleanup ballot attributes"]
["Senior Class Gift","2004-12-21","2005-01-12","Done","Jane","(HIGH) Req'd by M. Herlihy. Cleanup gifts from 2004 Senior Class Gift (currently in WAF Holding Account).  ETA 12/31/2004"]
["Athletcs, cleanup end reason codes","2005-08-23","2005-09-15","Done","Jane, Felix","We need to have consistent end reasons.  We will change the input screen, and clean up the old data."]
["Production Bug Corrections"]
["FRS 2005 Year End Issues","2005-08-19","2005-08-23","Done","Felix","Fix ledger dates, and frs info for jul/aug 2005"]
["Athletics","2005-09-14","2005-09-12","Done","Jane","make sure data is good for statistical reporting Athletics, end reason needs to be a drop down, new field for sub-varsity, remove ncaa date from all screens, and the view for sfis"]
["Spousal Relationships",null,"2005-11-22","Done","Sharon","Redo spousal relationship routine to handle multiple spousal relationships (i.e.) a dsp stays linked to the ssp only if the ssp doesn't have a later spousal relationship"]
["Athletics",null,"2005-11-30","Done","Sharon","Change historical results import so it cannot be run beyond 2001.  Discuss Calendar system and import implications w/ Brian, Kirsten, Nancy and document relationship between calendar system and athletics data."]
["Miscellaneous Enhancements"]
["Maintain Relationships","2005-02-10","2005-09-08","Done","Sharon","Req'd by M. Herlihy - Add Bookmark/bookmarker relationship to Maintain Relationship bulk update process"]
["Data Anomaly","2005-09-01","2005-08-19","Done","Sharon","Make sure there are no rating rows with PCC"]
["RC05 Reg. Process","2004-09-03","2005-03-21","Done","Felix","(Medium) Revise the registration for RC05 - needed by 03/15/05"]
["Alumni Elected Trustees","2004-11-29",null,"Done",null,"Req'd by L. Secord - cleanup and development of new system to track Alumni Elected Trustees.  Specs to be provided."]
["Time Zones","2004-09-29","2005-01-06","Done","Sharon","(Medium) Develop process to add time zones for from the zipcode file we get monthly (req'd by Dawn Astin)"]
["Alumni Trustee Ballot","2004-12-21","2005-03-16","Done","Jane, Felix","(HIGH)Req'd by L. Secord - Support '05 Alumni Trustee Ballot ETA 3/01/05"]
["Events Module","2004-11-01","2005-11-01","Done","Jane","Gather input and make recommendations regarding use of Events module in Millennium"]
["Website Development/Enhancements"," "," "]
["Social Psychology Network Giving Page","2005-04-26","2005-07-15","Done","Felix","(High) Create link to UR online giving from Social Psychology Network giving page to collect gift/donor information"]
["Infinet","2005-02-03","2005-08-01","Done","Felix, Jane","Implementation of Infinet 3/21/05 Done for RC05, City Club in progress"]
["HCFW05","2005-08-29","2005-08-29","Done","Felix, Dave"]
["Reporting"," "," ",null," "]
["Honor Roll Name Type Enhancement","2004-12-21","2005-01-10","Done","Dawn, Felix","(HIGH) needed by early Jan, '05 (creation of new name type)"]
["Third Party Gifts","2004-10-13","2005-01-15","Done","Jane, Dawn, Sharon","(HIGH) Review 3rd party gifts and how they are reflected in reports"]
["Gift Receipts - In honor of/In Memory Of name acknowledgment","2004-07-20","2005-12-24","Done","Sharon","(High) req'd by D. Treister.  Need to ensure that all In Memory of and In Honor of names appear on receipt (as entered in Millennium).TESTING"]
["Campaign/Chart of Account","2005-02-03",null,"Done","Jane","Req'd by Jane/Deb/Dawn.  Review and adjust how to handle multiple campaigns tied to a purpose on the Chart of Accounts."]
["Post Campaign Reporting","2005-03-10","2005-08-11","Done","Jane/Dawn/Sharon","(HIGH) Adjust datamarts to reflect post campaign money.  Go live week of July 25th."]
["Sol Form TSV","2005-03-10","2005-08-11","Done","Sharon","Req'd by Dawn.  Add 2 columns to report:  Solicitor ID number and Solicitor Class Year."]
["Gift Receipts","2004-12-23","2005-06-15","Done","Sharon","(HIGH) Req'd by D. Treister  Produce only 1 receipt when multiple pledges for a WESID are paid down on the same day."]
["Honor Roll","2004-12-21","2005-05-15","Done","Jane","Req'd by D. Astin.  End of Campaign Honor Roll  "]
["Ballot-build two new reports, one for the initial review, one for the final candidates","2005-06-01","2005-09-06","Done","Sharon","Req'd by Linda Secord"]
["Honor Roll Name Type","2005-03-17",null,"Done","Sharon, Jane","Req'd by Dawn.  Add Nameformn from Honor Roll Name Type to the following:  Mailing Single (also add to name tags output), Mailing Single with Giving, Volunteer Roster (Done), Reunion Hope to Attend listing (sort can still be by current last name)"]
["Gift Receipts","2005-07-25",null,"Done","Sharon","(HIGH) Req'd by D. Treister Get RM titles, phone, fax and address from comments table.  Blank out form on thank you letters.  Add new file for memories - 1st in heirarchy, Christina Posniak RM"]
["Infinet Balancing Routine","2005-10-20","2005-11-20","Done","Jane"]
["Development Committee Reporting System","2005-09-27","2005-11-20","Done","Jane","Req'd by Karen DePoto - Using Sol.tsv report, add fields to pull in Cultivator, Campaign Support, Lifetime Support, Post Campaign Support and Pledge Balance.  Clean up old Cultivator relationship rows. Add Lookup field to Relationship for \"Contact\" (i.e., Development Comm.; Steering Comm.; etc.)"]
["Change reports to look at complex_reunion instead of simple_reunion","2005-11-09","2005-11-15","Done","Jane","Req'd by D. Astin, urrpt_reunion_class_analysis, and urrpt_spouse_reunion_class_analysis"]
["Infinet Balancing","2005-10-27","2005-12-05","Done","Jane","Work with financial services to allow them to balance to the bank statement Vnye"]
["Household Linkages",null,"2005-11-16","Finished","Sharon","Fix spousal relationship logic so that household relationships in the datamarts are correct."]
["Enhancement to Mailing Single","2004-12-14","2005-12-01","Done","Felix","Req'd by Msteinberg  - Add column for maiden/graduation last name if different from current last name."]
["New Extract - Non BA Parents","2004-10-27","2005-11-16","Done","Felix","Req'd by M. Herlihy - Extract of all non BA Parents who are married to BA Alums."]
["Research Synopsis","2005-10-27","2005-10-31","Done","Sharon","In the giving section, indicate if there is an attachment associated with the gift Kstribula"]
["Faculty/Staff Extract","2005-10-07","2005-12-22","Done","Sharon","Req'd by D. Astin - Create a Faculty/Staff extract"]
["Bridging Functionality"]
["HR Import","2005-03-23","2005-08-23","Done","Sharon","HR Import of new employees - would like to have Basic Data of new employees feed to Millennium prior to the employee start date."]
["Country Cleanup","2004-09-03","2005-01-11","Done","Sharon","(LOW) req'd by M. Herlihy.  Need to combine 2 countries - specs to be supplied by Marcy."]
["Student Wes Emails","2004-10-01","2005-07-01","Done","Sharon","(Medium) Student Wes Emails are not set to preferred.  Should this be done on SFIS or in the import"]
["SFIS Import","2005-09-30","2005-10-13","Done","Sharon","Retrieve last school attended from admissions data for transfer students."]
["SQR's","2005-02-03","2005-11-30","Done","Sharon, Felix","Req'd by Jane.  Change the SQR's that build the datamarts to add the oracle exception routine for called procedures"]
["Database"," "," "]
["Rel 7.3 Test Sessions","2004-11-01","2005-02-11","Done","UR","(LOW) "]
["Rel 7.3 Training Sessions","2005-01-04","2005-02-11","Done","UR","(LOW) "]
["Implement Rel 7.3 into Production","2005-02-05","2005-02-11","Done","Jane, Felix","(LOW) "]
["Rel. 7.4 Pilot Test","2005-01-01","2005-01-31","Done","Jane, Deb"]
["Alumni Directory Data Transfer","2005-04-08","2005-05-01","Done","Felix,Jane, Deb","(HIGH)"]
["Oracle 9 Installation","2005-12-21","2005-06-11","Done","Steve Windsor","(MEDIUM)"]
["Install 7.4 On test system","2005-06-15","2005-06-15","Done","Jane"]
["Alumni Directory Survey Results","2005-04-08",null,"Done","Jane, Deb, Felix","(HIGH)"]
["Data Examiner","2005-04-26","2005-06-01","Done","Jane, Deb","(High) Look into possibility of purchasing data examiner through BEST in order to manage the data return from PCI  We are going to do this ourselves"]
["Install Autosys Web Client","2005-11-09","2005-12-08","Done","Felix"]

{"sheet":"2004 Done","index":5,"n_rows":71,"n_cols":6,"rows_kept":71,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Task","Start","Finish","Status","Resource","Comment"]
["Data Cleanup"]
["Institution Duplicate entries","2003-07-10","2004-03-22","Done","Sharon","(MEDIUM) req'd by B. Whitaker, is SFIS interface creating duplicate institutions?  Should we convert to SFIS standards? Gatekeeper to access the Institutions Lookup Table 12/9/03 Sharons Part is done, Jane will look into Gatekeeper"]
["Convert old occupation codes to new ones","2004-03-15","2004-03-30","Done","Jane","(HIGH) req'd by B. Whitaker.  See email for specs."]
["Data Anomaly Cleanup","2004-02-23","2004-04-13","Done","Barb, Sharon(?)","(MEDIUM) req'd by B. Whitaker 1-time data cleanup for field that cannot be accessed by data entry staff. Barb to make a list."]
["Social Security Numbers","2004-05-27","2004-06-24","Done","Jane/Felix","(HIGH) req'd by J. Jylkka  remove SSNs from Basic Data, store in separate table,and create WesMill search for Data Services."]
["Production Bug Corrections"]
["SFIS Interface - Reciprocal Relationships","2004-01-27","2004-01-27","done","Sharon","(HIGH) Not all admission legacy relationships were being created in Mill.  Sharon rewrote to go into SFIS via the applicant side."]
["Gatekeeper - duplicate address links","2004-03-17","2004-03-23","done","Jane","(HIGH) found by K. Vecchitto"]
["Gatekeeper - County not refreshed on foreign addresses, take off preferred email","2004-05-25","2004-10-27","Done","Felix","(MEDIUM)  found by K. Vecchitto - see id 238857, for email updates take preferred off old email addresses"]
["Miscellaneous Enhancements"]
["Alumni Trustee Ballot enhancements for 2004.","2003-10-17","2004-02-15","Done","Felix","(HIGH) req'd by J. Jylkka and J. Chapman"]
["Nightly Do Not Process - incorporate new GLSP Do Not attributes","2003-12-16","2004-04-09","Done","Sharon","(HIGH) req'd by D. Treister  "]
["RC2004 Enhancements","2004-02-10","2004-05-19","Done","Felix","(HIGH)"]
["Club Event Registration System","2003-10-15","2004-06-11","Done","Felix","(HIGH) ETA mid-Jan '04 - req'd by P. St. Germain - similar to the RC registration function"]
["Facilty to track Athletics rosters and win/loss records","2003-04-09",null,"Done","Jane, Felix, Sharon","(MEDIUM) req'd by Athletics office. Build tables outside of Millennium DB with web data entry forms FERPA, Calendar Load (Done), Mentor Form (Done)."]
["Donor Level Report","2004-09-02","2004-09-05","Done","Jane","(HIGH) req'd by Dawn Astin add a parameter to the current report allowing the report to run either 10k Plus or all donors to the campaign"]
["Online Event Registration - reevaluation","2004-04-29","2004-09-05","Done","Felix, Jane","(MEDIUM) req's by J. Jylkka look at shopping cart methodology"]
["Athletics - Calendar results","2004-11-01","2004-12-14","Done","Sharon","(MEDIUM) req'd by Athletics Dept. Athletics - calendar results load into the Atletics Subsystem need by 11/1/04"]
["Solicitation Card","2004-08-25","2004-12-15","Done","Jane ","(HIGH) req'd by M. Herlihy - add last WAF Gift Date to Solicitation Card (Sol Card is done, tsv still needs to be done)"]
["Post Campaign Reporting Strategy","2003-12-04","2004-12-15","Done","Jane, Dawn, Sharon","(MEDIUM) decide on strategy for post campaign reporting and make changes to datamarts(DONE),summaries,REPORTS (Done 7/22/04)"]
["RC05  ","2004-09-03","2004-10-15","Done","Jane, Dave","(High) Create Hope to Attend for RC05 - needed by 10/15/04"]
["Reporting"," "," ",null," "]
["New Event Reports - Packet Report, Receipt report","2003-11-13","2004-02-15","Done","Jane","(HIGH) ETA 5/1/04 req'd by M. Steinberg - 2 new reports"]
["Data Anomaly Enhancements","2004-01-08","2004-03-24","Done","Sharon","(HIGH) req'd by B. Whitaker - see specs on dragon."]
["Prospect Review Enhancement","2004-02-25","2004-04-09","Done","Sharon","(MEDIUM) ETA 8/15/04 req'd by D. Astin, A. Marth, P. Vasiliou add WAF columns to the output spreadsheet."]
["Summaries enhancement","2003-09-24","2004-05-06","Done","Jane","(MEDIUM) req'd by B. Whitaker include Gift Trx 'Hold' in the consecutive year calculation."]
["Summaries - make the table build process easier.","2004-04-29","2004-04-30","Done","Sharon","(HIGH) req'd by J. Jylkka"]
["Action Priority field for Contact Report Issues","2003-12-01","2004-04-30","Done","Sharon, Felix","(HIGH) req'd by A. Marth - Data Anomaly (done), Research Synopsis (done), WesMill Contact Report"]
["Datamart Process","2004-04-29","2004-05-19","Done","Sharon","(HIGH) req'd by J. Jylkka  Datamart process-gifts and donors, do not do the truncate until you \nknow the build is good"]
["Department Gift Report - add Gift Comment field","2004-04-01","2004-05-19","Done","Jane","(HIGH) req'd by B. Whitaker for PIMMS - change URRPT DEPARTMENTAL NOTIFICATION – GIFTS.RPT"]
["Mailing Graduating Students","2004-05-26","2004-06-01","Done","Jane","(HIGH) req'd by B. Whitaker.  Add the Degree translation to the output file."]
["New Report - WAF Year End Report","2004-07-16","2004-07-16","Done","Sharon","(HIGH) req'd by Marcy Herlihy - create a year end report for WAF that generates a spreadsheet similar to the WAF Volunteer Remote Access"]
["Harris Data Interface","2004-06-21","2004-07-15","Done","Jane","(HIGH) req'd by J. Jylkka - send data to Harris, receive back, update into Demog. Tbl.,"]
["Target Analysis Enhancement","2004-02-04","2004-06-13","Done","Sharon","(MEDIUM) ETA 9/1/04 req'd by D. Astin incorporate new 'do not' attributes"]
["Gift Receipts/Thank You letter enhancements","2003-03-27","2004-09-01","Done","Sharon","(HIGH) req'd by D. Treister  Testing"]
["Maintain WAF Targets","2004-07-20","2004-09-15","Done","Jane, Andrea","(High) req'd by A. Marth - details to be provided by Andrea"]
["Rewrite WebDB reports","2004-06-21","2004-09-15","Done","Jane/Felix/Sharon","(HIGH) req'd by J. Jylkka - rewrite to WesMill environment"]
["Reunion Class Analysis and Reunion Class Analysis with Spouse",null,"2004-10-15","Done","Jane","(HIGH) req'd by P. DiSanto and P. Vasiliou - add columns for Preferred mailing City and State, Employer and job title to the detail section of both reports"]
["WesMill Reporting Queue","2004-10-01","2004-11-15","Done","Felix","(Low) Rewrite the WesMill Reporting Queue.  Update in technology since it was written, we should re-write - should fix problem with it not coming up everyday on Venus (reg'd by J. Jylkka)"]
["Confirmation Label Report","2004-10-06","2004-10-12","Done","Jane","(HIGH) Confirmation label report for Events - used to be a WEBDB report  req'd by Kathy Macko"]
["New Report - Major Donor Pledge Profile","2004-05-24","2004-12-09","Done","Sharon","(MEDIUM) req'd by D. Treister"]
["Bridging Functionality"," "," ",null," "]
["Rewrite the HR interface against Peoplesoft","2003-11-03","2004-04-06","Done","Sharon","(HIGH) coordinated with the implementation of HR Peoplesoft"]
["New Bridge to import Athletic data from Athletic subsystem","2004-04-06","2004-04-08","Done","Sharon","No longer maintained in SFIS, so needs to be removed from SFIS and new import created."]
["HR Interface - don't interface blank addresses","2004-04-08","2004-04-13","Done","Sharon","(MEDIUM) don't create a Millennium address if address lines, city or state are blank.  See id 376025"]
["SFIS Interface - change email bridging logic","2004-02-26","2004-04-13","Done","Sharon","(MEDIUM) req'd by B. Whitaker change logic to send Wesleyan email and preferred email over to Millennium."]
["Enrollment Day Report - change printer","2004-04-26","2004-04-28","Done","Sharon","(MEDIUM) req'd by B. Whitaker.  Change printer for the Enrollment day report to UR 18 - 2nd floor 48 Wyllys."]
["SFIS Feed - bypass certificates which are not majors","2004-06-03","2004-06-23","Done","Sharon","(MEDIUM) can we bypass the certificates which are not majors so they no longer appear on the error report."]
["WesNet Enhancements",null,null,null," "]
["Signup page - Wesnet Help link","2003-06-19","2004-01-01","done","Dave","(HIGH) req'd at 6/19 team meeting"]
["Industry/Occupation Pop Up","2003-10-01","2004-01-20","Done","Felix, Dave","(MEDIUM) req'd by G. Waldron - new window with list to print off"]
["Twistee Enhancement - Mouse over","2003-03-29","2004-02-03","done","Dave/Felix","(HIGH) AAEC Mtg -mouseover description of twistees"]
["Add Fraternity to the dropdown list","2004-02-17","2004-02-23","done","Jane ","(HIGH) req'd by B. Whitaker  add Kappa Alpha Theta to the list"]
["WesCAN - add occupation/industry 'display full list' option","2004-02-03","2004-02-20","done","Dave","(HIGH) req'd by M. Simonson - same functionality as the Directory"]
["Link to Club Activties -general link","2003-02-03","2004-02-21","done","Dave ","(MEDIUM) req'd by C. Kelly& AAEC Mtg - alumn specific option was tabled on 4/24/03.  We will create a Alumni Website twistee with a mouseover."]
["94 Reunion Book online","2003-09-30","2004-02-19","done","Jen, Dave","(HIGH) req'd by M. Steinberg, post '94 survey and notes in WesNet"]
["Delete Fraternity from the dropdown list","2004-03-03","2004-03-08","Done","Jane","(HIGH) req'd by B. Whitaker  delete Phi Beta Kappa from the dropdown list"]
["Automated process to add new faculty ids to the signup table.","2003-12-09","2004-03-22","Done","Jane","(HIGH) from the 12/9/03 team meeting."]
["WAF Vounteer Twistee","2004-02-03","2004-05-01","Dave","Dave","(HIGH) req'd by M. Herlihy - break out from Volunteer Resources twistee."]
["WesNet- Online Directory table build process enhancement","2004-04-29","2004-05-15","Done","Felix","(HIGH) req's by J. Jylkka - only rebuild data for wesids that have really \nchanged "]
["Reunion Questionnaire","2004-08-10",null,"Done","Jane","(HIGH) Post reunion questionnaire on WesNet"]
["Signup page - link to privacy policy with 'Accept' 'Do Not Accept' buttons","2003-12-09","2004-09-15","Done","Dave, Felix","(HIGH) req'd at 12/9/03 team meeting"]
["Career Resouces Twistee - addition of a link for Resouces & Passwords","2004-02-03",null,"Done","Dave","(HIGH) req'd by M. Simonson - add to the existing twistee"]
["Reunion Survey","2004-04-19","2004-08-15","Done","Dave","(HIGH) ETA 8/15/04 req'd by D. Carlsson"]
["CRC - Work History 1- enhancement","2003-11-13","2004-10-01","Done","Felix","(HIGH) Design ETA 9/1/04 - req'd by M. Simonson at team meeting - See CRC's prioritized list - searchable job history"]
["Make Name fields and Title updateable","2004-01-08"," ","Done","Felix","(MEDIUM) req'd at 1/8/04 team meeting  Break out 4 fields and make them updateable."]
["Database"," "," "]
["Install Rel 7.3 on Venus for Pilot Testing","2004-01-12","2004-01-16","done","Jane","(HIGH)"]
["Conduct test sessions -Round 2","2004-01-19","2004-02-17","done","Barb, ITS, Data Services","(HIGH)"]
["Install Rel 7.3.1 with Patch  in Test","2004-10-01","2004-10-05","Done","Jane, Felix","(LOW) "]

{"sheet":"2003 Done","index":6,"n_rows":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["#","Task","Start","Finish","Status","Resource","Comment"]
[1,"Data Cleanup"]
[2,"Address format - change standards","2002-01-24","2003-02-01","done","Jane, Deb","(HIGH) req'd by President's office"]
[3,"Delete SSN, and Birthdate for non-alumni, non-student employees","2003-07-16","2003-07-18","Done","Jane, Barb","(MEDIUM) req'd by S. Machuga"]
[4,"Production Bug Corrections"]
[5,"SFIS Bridge - class year derivation","2003-01-14","2003-01-16","Done","Sharon","(HIGH) per C. Dolanksy - mid year grad's class year incorrect - SFIS has new procedures"]
[6,"Mailing_Graduating_Students","2003-06-10","2003-06-10","done","Jane","(HIGH) req'd by B. Whitaker  some majors are missing from extract file"]
[7,"WesMill Search - error message on return to export table button","2003-08-21","2003-08-26","Done","Felix","(MEDIUM) reported by E. Watrous, after inserting a constituent if you click on return to export tables, err msg appears"]
[8,"WesMill - Bulk Email - text too long","2003-05-21","2003-05-25","Done","Felix","(HIGH) reported by P. DiSanto, text which is too long causes error and loss of text"]
[9,"WesMill search doesn’t find hyphenated last names","2003-07-15","2003-07-18","Done","Felix","(HIGH) reported by C. Colfer"]
[10,"WesMill export table 'prev' button","2003-07-17","2003-07-18","Done","Felix","(MEDIUM) reported by B. Whitaker clicking of prev button causes error msg hen editing and export table"]
[7,"Organization Fiscal Year Rpt","2003-09-30","2003-10-01","Done","Jane","(HIGH) per C. West-Webster - Failure in WesMill run"]
[22,"New Standard Export tables","2003-10-28","2003-10-28","Done","Jane","(HIGH) req'd by C. Colfer - extracts for DNC-AOC, DNA-WesNet, DNC-WesCan, DNP-WesNet"]
[21,"Mailing Single - Enhancement","2003-09-30","2003-11-12","Done","Jane","(HIGH) req'd by M. Steinberg, nametag output file - format the class year columns,and state,country columns"]
[10,"WesMill Export table maintenance","2003-11-21","2003-11-21","Done","Felix","(HIGH) req'd by B. Whitaker - when editing an export table, folks w/o valid Mill addresses still show a state listed."]
[11,"Miscellaneous Enhancements"]
[12,"Alumni Ballot Function - enhancements for 2003","2002-04-29","2003-02-15","Done","Felix, Jane","(LOW) req'd by J. Chapman - based on feedback from alumn's use in 2002"]
[13,"Yearly Reunion/ Commencement Enhancements- RC2003","2002-10-30","2003-04-05","Done","Felix, Jane","(HIGH) Yearly changes to support R/C"]
[14,"Define new printer to Millennium","2003-05-21","2003-06-01","Done","Felix","(MEDIUM) req'd by B. Whitaker - new 48 Wyllys Ave printer - replacing UR18."]
[15,"Rewrite the Zip code update","2003-06-11","2003-07-22","Done","Sharon","(MEDIUM) req'd by J. Jylkka due to using new file for WesNet"]
[16,"Website Development/Enhancements"," "," "]
[17,"Online Directory ","2002-05-01","2003-04-02","Done","Jane, Felix, Deb, Barb, Greg","(HIGH) - Part of the online community"]
[18,"Alumni e-Portfolio","2002-05-01","2003-04-02","Done","Curran, Barb, Greg","(HIGH) - Part of the online community"]
[19]
[20,"Reporting"," "," ",null," "]
[21,"Gift Thank you letters","2002-05-02","2003-01-03","Done","Jane","(HIGH) change the salutation used for alumn of '67 and prior"]
[22,"Data Anomaly Edit Enhancements","2002-10-10","2003-01-22","Done","Sharon","(MEDIUM) see specs document from Oct 2002 - present."]
[23,"WAF Pyramid Enhancements","2002-12-12","2003-01-22","Done","Jane","(MEDIUM) req'd by D. Astin & F. Williams.   Add Rel. Mgr to the detail report. Create a household version of the report."]
[24,"Receipts/Thank You letters - enhancements","2002-10-15","2003-02-13","Done","Sharon","(MEDIUM) req'd by D. Treister."]
[25,"Briefing Card - Add Executive Committee attributes","2002-09-11","2003-02-13","Done","Sharon","(MEDIUM) req'd by K. Stribula.  Specs from example on email. See FS1/Signed of folder"]
[26,"Data Anomaly Enhancements","2003-01-23","2003-02-14","Done","Sharon","(MEDIUM) see specs document from Jan 2003 - present"]
[27,"Pledge Reminders","2003-01-06","2003-02-13","Done","Sharon","(HIGH) ETA 4/03-req'd by D. Astin.  Fix multi alloc bug, new tsv file columns, new user field on Gifts, Payment Sched cleanup"]
[28,"Honor Roll - enhancements","2003-01-21","2003-03-07","done","Done","(HIGH) ETA 5/1/03-req'd by D. Astin/A. Marth.  "]
[29,"Mailing Combined - Enhancement","2003-02-12","2003-02-05","Done","Sharon","(MEDIUM) req'd by C. Dolansky.  Add a column for the spouse's email to both combined and with gifts reports."]
[30,"New WesMill Report - Demographics and Employment","2003-03-05","2003-04-01","Done","Sharon","(MEDIUM) ETA 4/30 req'd by C. West Webster  new report to show demographics, education and employment info"]
[31,"Briefing Card Enhancement","2003-03-20","2003-04-01","Done","Sharon","(HIGH) req'd by K. Stribula - change the date logic for the attributes to show attribute if no end date or a future end date."]
[32,"WesCan enhancements","2003-03-13","2003-05-01","Done","Felix","(HIGH) req'd by M. Sciola, add 'CRC Volunteer' comment, preferred email, filter out non-CRC Volunteer parents."]
[33,"New Report - Reunion Giving including spouses","2003-05-16","2003-05-18","Done","Jane, Dawn","(URGENT) req'd by BJW via P. Vasiliou & D. Astin,  copy the Reunion Giving report and add spousal giving columns, create new datamarts"]
[34,"Briefing Card - show stepchildren and wards","2003-05-05","2003-06-03","Done","Sharon","(HIGH) reported by C. Dolansky"]
[35,"Completed Contact Report","2003-06-03","2003-06-10","Done","Sharon","(MEDIUM) req'd by K. Stribula - add subtotals after each report type"]
[36,"Graduating_Students_Wes template criteria","2003-06-05","2003-06-10","Done","Jane","(LOW) req'd by B. Whitaker copy revised template criteria to the New area."]
[37,"Campaign Pyramid Rpt - enhancement","2003-06-26","2003-07-01","Done","Dawn","(MEDIUM) req'd by E. Watrous add a column for lifetime giving to the output file"]
[38,"WesMill Search - add functionality","2002-12-18","2003-07-15","Done","Felix","(LOW) from O/L Dir status meeting.  Make it function the same as the advanced search in the O/L Dir."]
[39,"Honor Roll - Enhancement","2003-06-02","2003-08-26","Done","Jane","(HIGH) req'd by D. Astin - ETA Aug 03 - specs to be written by Dawn."]
[40,"Remove UR08, UR09 printers","2003-07-15","2003-09-02","Done","Jane","(MEDIUM) req'd by L. Schulte - pritners no longer exist.  Remove from IR and Wesmill dropdown lists"]
[41,"WAF Pyramid - new columns","2003-08-07","2003-09-09","Done","Jane","(HIGH) req'd by F. Williams  ETA Nov '03- add output file for household version"]
[42,"WAF Remote Report Enhancement - 3 new columns","2003-07-24","2003-09-15","Done","Sharon","(HIGH) req'd by A. Marth - ETA of 9/18/03 add to full version - Solicitable Base, Commitment, Target Group"]
[43,"No Degree Update - enhancement","2003-09-03","2003-09-12","Done","Sharon","(MEDIUM) req'd by B. Whitaker - create br0025 attribute."]
[44,"Data Anomaly enhancement","2003-09-25","2003-09-26","Done","Sharon","(MEDIUM) req'd by B. Whitaker"]
[21,"Mailing Single - Enhancement","2003-03-21","2003-10-08","Done","Jane","(MEDIUM) req'd by D. Hutson redo the nametag output file---testing"]
[25,"Reunion Remote Access","2003-10-09","2003-10-10","Done","Jane","(MEDIUM) req'd by M. Steinberg, remove the 'Volunteer' column"]
[20,"CRC Printers","2003-10-01","2003-10-10","Done","Jane","(HIGH) req'd by M. Simonson redefine 2 printers in CRC for Millennium"]
[25,"Industry/Occupation Distribution Reports - new reports","2003-10-13","2003-12-04","done","Dawn","(HIGH) req'd by M. Simonson - new IR Crystal reports to give alumni counts in occupations and industries"]
[28,"Move template criteria to 'New' area of Millennium","2003-11-18","2003-12-01","Done","Jane","(MEDIUM) req'd by B. Whitaker - criteria for 2 new CRC reports - Occupation_Distribution_Code and Industry_Distribution_Code"]
[26,"Snapshot Class Giving","2003-11-17","2003-12-11","Done","Jane","(HIGH) req'd by D. Astin/A. Marth ETA 12/31/03 - add 4 new columns of donor counts"]
[23,"Mini Bio - CRC Version","2003-10-13","2003-12-22","Done","Jane","(HIGH) req'd by M. Simonson - modify current mini bio for CRC"]
[45,"Bridging Functionality"," "," ",null," "]
[46,"CSS Feed - enhancement - Name title for ee's with spouses in Mill","2002-11-21","2003-03-04","Done","Sharon","(MEDIUM) req'd by D. Treister. Force the title to Mrs if ee has spouse in Mill."]
[47,"Legacy Denial Enhancement","2002-12-11","2003-04-08","Done","Sharon","(MEDIUM) req'd by K. Stribula.  Feed deferrals, applies, and admits from SFIS as Comments in Mill."]
[48,"Test SFIS Interface with the Rel 8.0 of Peoplesoft","2002-08-30","2003-06-19","Done","Sharon","(MEDIUM) ETA April 03.  SFIS testing slated to start in Dec 02."]
[49,"SFIS Extra - curricular activities into Mill","2003-01-30","2003-06-19","Done","Sharon","(MEDIUM) req'd by B. Whitaker  feed Frats, RA, Head Resid, Pgm Houses, Residences"]
[50,"CSS Enhancement - link Wes Business Addr to Primary Wes job","2003-06-10","2003-06-24","Done","Sharon","(MEDIUM) req'd by B. Whitaker to support WesCan online so alumni Wes employees are in the application"]
[51,"Admission Legacy Applicants - enhancement","2003-04-10","2003-07-01","Done","Sharon","(MEDIUM) req'd by F. Williams.  Include applicants related to existing parents and BA/NDs."]
[52,"CSS Enhancement - use new field in CSS for Wes business address","2003-06-24","2003-06-26","Done","Sharon","(MEDIUM) part of business address change Sharon found that CSS now uses a different address"]
[53,"SFIS Feed - Enhancement","2003-09-09","2003-09-23","Done","Sharon","(MEDIUM) req'd by B. Whitaker - create br0025 for BA/ND degrees, email address for all students"]
[54,"CSS Feed - Enhancement","2003-09-09","2003-09-23","Done","Sharon","(MEDIUM) req'd by B. Whitaker - termination process - change email to 'personal' for alumni"]
[55,"Extra curricular info into Millennium"]
[56]
[57,"WesNet Enhancements",null,null,null," "]
[58,"Search on Multiple Values","2003-03-26","2003-05-08","done","Felix","(HIGH) UR Alumni Review Session - select mulitple dropdown values"]
[59,"News Group Page - enhancement","2003-11-26","2003-05-08","done","Felix","(HIGH) UR Alumni Review Session - remove weschat - requires a separate logon"]
[60,"Geographic radius area searches","2003-02-03","2003-06-04","Done","Jane/Felix","(HIGH) req'd by B. Rosenberg -Search on region instead of just city/state/zip"]
[61,"Reorder twistees","2003-06-25","2003-07-15","done","Dave","renamed to Alumni Resources, rearranged twistee dropdowns, elimin simple search"]
[62,"Add website as new field","2003-07-08","2003-09-01","done","Felix","(HIGH) req'd by B. Whitaker,  add website to profile page, Update page, Gatekeeper"]
[4,"WesCan Replacement","2003-01-01","2003-09-01","Done","Jane/Felix","(HIGH) req'd by M. Sciola"]
[null,"Integrate WAAVe with WesNet","2003-07-02","2003-10-06","done","Dave, Scot, Madeleine","(HIGH) req'd by B. Whitaker  provide link to post interview results thru WesNet"]
[7,"WesCareer Portfolios for '03 Grads","2003-11-26","2003-11-26","done","Jane","(HIGH) needed to support the new release of student portfolios - '03 grads being moved to WesCareer."]
[17,"Add middle name to search","2003-06-19","2003-12-15","Done","Felix","(HIGH) req'd at 6/19 team meeting"]
[12,"Trigger for Private Addresses","2003-11-13","2003-12-15","Done","Felix","(HIGH) from 11/13 team mtg - trigger in Mill to hide addr in Directory if \"Private' is checked on"]
[63,"Database"," "," "]
[64,"Install Rel 7.2 in Test Environment","2002-07-29","2003-05-06","done","Felix","(MEDIUM) dependent on release of Rel 7.2 SP1"]
[65,"Rel 7.2 User Test Sessions",null,"2003-08-03","done","Barb, UR","(MEDIUM)"]
[66,"Rel 7.2 - move to production",null,"2003-09-06","Done","ITS","(MEDIUM) "]
[42,"Pilot testing of Rel 7.3","2003-11-10","2003-11-21","done","Jane, Felix, Data Services","(HIGH) product is not ready for pilot testing - install issues, new features bugs - pilot testing stopped on 11/21."]
[67]
[68]

{"sheet":"2002 Done","index":7,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["#","Task","Start","Finish","Status","Resource","Comment"]
[1,"Volunteer Remote Access"," "," ",null," "]
[2,"New WesMill Function- bulk email of reports","2002-01-16","2002-02-26","Done","Jane","(HIGH) req'd by A. Marth.  Bulk email of an individual's Remote access reports 1/28/02-completed initial test, sent email to Amarth to test"]
[3,"Add 'do not' attributes to Remote Access","2001-10-30","2002-03-05","Done","Jane","(HIGH) specific attributes in specs on FS1."]
[4,"Data Cleanup"]
[5,"Nightly Name Title Formatting Process","2001-10-03","2002-01-22","done","Jane","(HIGH)"]
[6,"Relation Group Field - 1 shot cleanup","2002-01-23","2002-01-23","done","Sharon","cleanup of converted relation rows where the group field was not populated"]
[7,"Unlink alumns from parents 1-shot","2002-02-12","2002-02-13","done","Sharon"]
[8,"Admission denial data as Comments","2001-01-15","2002-02-15","done","Deb","(MEDIUM) take out of contact reports and Action Comments and put into Comment area."]
[9,"1-shot to delete all Friend Attributes","2002-03-07","2002-03-12","done","Sharon"]
[10,"Graduation Name - set to Lookup 'yes'","2002-03-06","2002-03-13","Done","Jane","(MEDIUM) req at 3/6 usergroup.  Set to Y if for females if last name not = preferred last name"]
[11,"Action Priority - incorporate new values","2002-03-06","2002-03-15","Done","Karen","(HIGH) req'd by K. Stribula. New list of values "]
[12,"1-shot to Relations","2002-03-13","2002-03-15","Done","Sharon","(HIGH) fix relation records where the reciprocal relationships are not equal"]
[13,"1-shot- delete campus address for former students","2002-03-26","2002-03-27","Done","Sharon","(HIGH) delete old GLSP and undergrad campus addresses."]
[14,"Correspondence - 1shot - Alumni Ballot rows","2002-02-06","2002-04-05","Done","Jane","(MEDIUM) convert all rows to 'wesbal' code"]
[15,"1-shot for anyone with 1 good address that is not 'preferred'","2002-04-30","2002-05-01","done ","Sharon","(HIGH) set the 1 'good' address to 'preferred' and eff months to 'all'."]
[16,"Review of mandatory team assignments in light of new UR organizational structure","2002-06-25","2002-09-30",null,"Deb, DSvs","(MEDIUM) to be coordinated with the conversion of data to the new team structure"]
[17,"Delete 'Current Staff\" attribute","2002-10-08","2002-10-08","Done","Sharon","(LOW) not needed since we have the CSS interface in place."]
[18,"WAF Rating Rows for deceased","2002-11-06","2002-11-06","done","Sharon","(HIGH) inactivate the WAF rating row for deceased folks."]
[19,"Sports Attributes","2002-10-23","2002-11-01","Done","Jane, Barb","(HIGH) for Online Directory - assign men's/women's values based on gender"]
[20,"Fix Goals and Divisions","2002-11-19","2002-11-21","done","Jane","(HIGH) req'd by D. Astin."]
[21,"Production Bug Corrections"]
[22,"Gift Roster - no Team 4 report","2002-01-15","2002-01-16","done","Jane","reported by G. Gibbons"]
[23,"Gift Receipts - multiple allocation bug","2001-12-11","2002-01-15","Done","Felix","(HIGH)  no receipt produced if pledge payment is not paying off the 1st allocation-Dtreister is reviewing 1/10/02"]
[24,"SFIS Interface - High School Institution not populated","2002-02-19","2002-02-19","done","Sharon"]
[25,"WesMill Contact Reports","2002-03-05","2002-03-06","done","Felix","(HIGH) 2 bugs: blank text in the document (fixed 3/6), error message for non-unique constraint"]
[26,"Parent Years Disappears for inactive students","2002-02-18","2002-03-05","Done","Sharon","(MEDIUM) due to SFIS not putting up term records for inactive students - change nightly routine to create 'bstu' attributes for inactive students"]
[27,"Gift Roster - display of In Honor Gifts","2002-06-01","6/22/02?","done","Jane","(HIGH) found by E. Watrous"]
[28,"Tsv output files show incorrect dates","2002-07-24","2002-07-25","done","Jane","(HIGH) reported by E. Watrous - dates prior to 2000 were formatted as 2000+ - 1997 was displaying as 2097"]
[29,"WesMill Contact Reports - failure","2002-08-27","2002-08-27","done","Felix","(HIGH) found by E. Watrous- changed to MARS did not allow a blank contact report type "]
[30,"Horgan House printers - adjust Mill addresses","2002-09-04","2002-09-04","done","Jane","the planned printers were not installed as expected in the Horgan House."]
[31,"Mini Bio - show sp/sp relation before surviving sp/deceased sp relation","2002-09-17","2002-09-19","Done","Sharon","(High) reported by P. DiSanto - bug appears when an alumn remarries."]
[32,"Gifts Roster - split gift bug","2002-09-16","2002-09-24","done","Sharon","(HIGH) found by E. Watrous  perferred name of joint donor produces an error message"]
[33,"Research Synopsis - all prior campaign gifts should be included","2002-09-25","2002-09-25","Done","Sharon","(HIGH) found by E. Miel - all prior campaign gifts should be in the Pre-Campaign total"]
[35,"Miscellaneous Enhancements"]
[36,"Address Update Function - assign team code","2002-01-10","2002-01-17","done","Jane","(MEDIUM) research and change green button function to update region correctly on addresses."]
[37,"Nightly 'Do Not' Update Process","2002-01-10","2002-04-02","Done","Jane","(MEDIUM) if one of the global 'do nots' is found, delete the more detailed ones."]
[38,"Gifts - Do Not Writeoff Flag","2002-02-18","2002-05-01","Done","Jane","(HIGH) Req'd by D. Astin use giftyesno 1-shot to set field for existing pledges. 3/1/02 Sent to UR for testing"]
[39,"Shasha Event Registration Function","2002-04-29","2002-06-03","Cancelled per Ryan 6/3/02","Unassigned","(HIGH) req'd by Ryan - ETA end Aug'02  registration similar to Sons& Daughters with credit card function"]
[40,"Convert data to new UR organizational team structure","2002-06-25","2002-09-12","Done","Jane","(MEDIUM) req'd by K. Stribula - 3 teams based on state/geo areas"]
[41,"No Degree Update - enhancement","2002-10-21","2002-10-16","done","Unassigned","(MEDIUM) Remove deletion of NRS attribute, no enroll status attribute"]
[42,"Homecoming/Family Weekend 2002 Support","2002-07-25","2002-10-18","Done","Felix","(HIGH) "]
[43,"Link Alumni Website with Millennium"," "," "]
[44,"Hope to Attend RC2002 Website","2001-10-10","2002-01-09","Done","Jane, Ryan","(HIGH)"]
[45,"Website for Alumni Trustee Ballots","2000-02-01","2002-02-19","Done","Felix, Ryan","(HIGH) - Requested by J. Chapman, kickoff set for 9/12/01"]
[46,"Events Module Enhancement for R/C"," ",null,null,null,"(HIGH)"]
[47,"Yearly Reunion/ Commencement Enhancements","2002-01-10","2002-05-13","Done","Felix, Ryan","(HIGH) Yearly changes to support R/C"]
[48,"Reporting"," "," ",null," "]
[49,"Gift Roster Enhancement","2002-01-17","2002-01-24","Done","Jane","(HIGH) new field to indicate an increase in WAF gift vs. prior year."]
[50,"Nametags (alums & parents) ","2000-01-30","2002-01-25","Done","Colfer, Jane","(MEDIUM) needs spec-K.Stribula requested. 10/17/01 make an optional file from Single Mailing for nametages per Ccolfer."]
[51,"New Report - Reunion Class Analysis","2001-10-25","2002-02-01","Done","Jane, Pam, Dawn","(HIGH) req'd ETA 12/31/01 by G. Waldron summary giving by reunion classes. 12/3 to UR for review 12/5 received feedback, more work is needed"]
[52,"Solicitation Form  Enhancement","2002-01-16","2002-02-01","Done","Jane","(MEDIUM) req'd by D. Astin.  Add a sort of Solicitor class/Solicitor alpha last name."]
[53,"Data Anomaly edits","2002-01-10","2002-02-04","done","Jane","a select group of edits was completed.  Add'l ones still outstanding."]
[54,"Data Anomaly edits","2002-02-13","2002-02-13","done","Sharon","Added a new section for error on non-UR owned constituents (SFIS)"]
[55,"Research Synopsis","2001-12-12","2002-02-13","Done","Jane","(MEDIUM) new Section - Cultiv. Strategy, changes to giving section A&B"]
[56,"Organization Fiscal Year - New Report","2002-01-22","2002-03-11","Done ","Jane","(MEDIUM) req'd by D. Astin for Found/Corp.  New WesMill Excel report"]
[57,"Reunion Class Analysis - Enhancement","2002-03-11","2002-03-11","Done","Jane","(MEDIUM) req'd by G. Waldron/P. Vasiliou - add RM, Compreh. Sol, WAF Sol."]
[58,"Briefing Card Enhancement - 2 versions","2002-03-11","2002-03-20","Done","Jane","(MEDIUM) req'd by K. Stribula DJB version and a full version"]
[59," Pyramid Report - create template criteria","2002-03-14","2002-03-18","Done","Jane, Dawn","(HIGH) move template criteria to 'new' area."]
[60,"Solicitation Tsv - enrollment status - 2changes","2001-12-13","2002-03-22","Done","Jane","(MEDIUM) make same changes as solicitation form for enrollment status and add wes children's wesids.3/13 sent to Camille for testing"]
[61,"Data Anomaly edit ","2002-04-02","2002-04-02","done","Sharon","(HIGH) add priority 6 as a valid value for Actions."]
[62,"Online Giving Website - Enhancement - in honor indicator and designation of Financial Aid","2002-01-29","2002-04-04","Done","Felix","(MEDIUM) add the ability to indicate an in-honor gift  and restricting gifts to Financial Aid on the online screen.  Make this part of the data that is given to Data Entry."]
[63,"Gift Receipt Process - look for spouse's RM","2002-03-28","2002-04-07","Done","Felix","(HIGH) req'd by K. Stribula. If one spouse has no RM, check other spouse for RM for sorting of receipts and thx letter tsv file."]
[64,"Revamp Receipt/Thank You letter process","2002-03-28","2002-04-07","Done","Felix","(HIGH) break process into separate stages."]
[65,"New Report - Priority by Target","2002-03-28","2002-04-24","Done","Jane","(MEDIUM) req'd by K. Stribula "]
[66,"Data Anomaly Edit Enhancements","2002-01-10","2002-06-13","Done","Sharon","(HIGH) see specs on FS1 from Jan 2002+"]
[67,"WAF Pyramid report","2002-04-15","2002-06-20","Done","Jane","(MEDIUM) req'd by A. Marth.  Dawn sent specs on 4/24/02."]
[68,"1-shot extract of wesemails for BA alumns","2002-06-20","2002-06-20","done","Sharon","(HIGH) req'd by G. Waldron used by J. Maguda to return a file of wes emails that have forwarding"]
[69,"New Report - Fiscal Year RM report","2002-05-10","2002-07-01","Done","Jane","(MEDIUM) req'd by K. Stribula"]
[70,"Events Remote Access Enhancement","2002-06-05","2002-07-25","Done","Jane","(HIGH) req'd by M. Steinberg  change columns and access attribute"]
[71,"Mailing Single - Enhancement","2002-05-16","2002-08-12","Done","Jane","(MEDIUM) req'd by D. Treister, M.Steinberg  add birthday,RM and a a new version with Priv ind, Grad name, Occupation"]
[72,"Briefing Card - Enhancement","2002-06-12","2002-08-12","Done","Jane","(MEDIUM) req'd by G. Waldron - add a parameter for printing addresses, include Expectancies"]
[73,"Research Synopsis - Enhancement","2002-05-02","2002-08-21","Done","Jane","(MEDIUM) req'd by E. Watrous add Media comments and option to print off attached documents."]
[74,"Data Anomaly Edit Enhancements","2002-06-13","2002-08-28","Done","Sharon","(HIGH) see specs on FS1 from June 2002+"]
[75,"New Wesleyan Printer rollout","2002-07-25","2002-09-09","Done","Jane, Felix, Doug","(HIGH) Ricoh replacements - starting Aug 8?"]
[76,"Rename Printers for Horgan House","2002-06-24","2002-09-09","Done","Unassigned","(MEDIUM) Alumni Programs is moving 7/8/02"]
[77,"Maintain WAF Target - yearly enhancements","2002-02-12","2002-09-17","Done","Sharon","(HIGH) req'd by D. Astin. Changes for reunion years to be 5 year amounts."]
[78,"In-Honor & In Memory recipient notification","2002-01-22","2002-09-17","Done","Jane","(HIGH) req'd by D. Treister.  Produce notification for in-honor constituent when an in-honor gift is received. Sent to UR 2/15 for testing"]
[79,"Donor Datamart - Add 5 yr WAF Target field","2002-09-09","2002-09-19","Done","Sharon","(HIGH) req'd by D. Astin.  Add ratemny1 to the donor datamart."]
[80,"New standard export table - Alumni married to alumns","2002-06-12","2002-09-26","Done","Sharon","(LOW) req'd by A.Marth"]
[81,"WesMill Export Table process","2002-02-12","2002-09-25","Done","Sharon","(LOW) req'd by D. Astin - add the ability to delete duplicates off an export table"]
[82,"New Report - RM Prospects by Capacity","2002-05-15","2002-10-01","Done","Sharon","(MEDIUM) req'd by K. Stribula.  Specs from example on email. See FS1/Signed of folder"]
[83,"Maintain Comments","2001-11-19","2002-10-03","Cancelled","Unassigned","cancelled due to Interface of Legacy Denials (LOW) new WesMill function to bulk update Comment Rows based on an input spreadsheet. Specs on FS1."]
[84,"Data Anomaly edits","2002-09-01","2002-10-03",null,"Sharon","(MEDIUM) edits from Sept 1 - Oct1, 2002."]
[85,"New IR report - WAF Giving Detail","2002-05-12","2002-10-21","done","Dawn","(HIGH) req'd by A. Marth.  Dawn will develop in Crystal based on a trustee rpt - showing a breakout of all giving for a donor."]
[86,"WAF Giving Detail -move template criteria","2002-10-21","2002-10-30","Done","Jane","(MEDIUM) req'd by D. Astin.  Move template criteria for new IR report to Financial area."]
[87,"Briefing Card - Add Column - Verbals","2002-10-21","2002-10-30","Done","Sharon","(HIGH) req'd by K. Stribula.  Add a verbal pledge column."]
[88,"Campaign Combined Review - Add credit column","2002-10-21","2002-10-29","Done","Sharon","(HIGH) req'd by K. Stribula.  Add column for person tagged with an \"i\"."]
[89,"Target Analysis Vendor Feed enhancement","2002-10-10","2002-11-13","Done","Sharon","(HIGH) req'd by D. Astin. Add 8 new columns based on volunteer attributes."]
[90,"Add Rating Row- Target Group field to 3 reports","2002-11-04","2002-11-13","Done","Sharon","(HIGH) req'd by D. Astin.  Add this field to the Combined & Single Mailing with gifts, Target Review (full version)"]
[91,"5-Year WAF Target","2002-10-22","2002-11-20","Done","Sharon","(HIGH) req'd by D. Astin. Add to WAF Target figure to Target Review Full version, Solicitation form&tsv, WAF Remote Access."]
[92,"WAF Remote Access","2002-10-22","2002-11-20","Done","Sharon","(HIGH) req'd by D. Astin - add Reunion Status to the reports."]
[93,"No Degree Update - enhancement","2002-10-23","2002-11-26","Done","Sharon","(MEDIUM) for O/L Directory  ETA May 2003 - when creating BA/NDs create the br0023 attribute"]
[97,"Bridging Functionality"," "," ",null," "]
[98,"Incoming Students Parent - Enhancement","2001-10-03","2002-03-07","Done","Sharon","(HIGH) run 1-shot to unlinked student/parent addresses.  (Done w/e 10/12/01) Change routine not to link student addrs to parents addrs. Dtreister testing 1/10/02.  1/24/02-Data cleanup is required before implementation"]
[99,"Feed Wes Employee info to Mill","2000-09-13","2002-06-13","Done","Sharon","(MEDIUM) include a cleanup of employment rows for Wes employees, set Employee attributes w/ Faculty designation based on Employment rows."]
[100,"Wesleyan Email Load into Mill","2002-06-11","2002-06-18","Done","Sharon","(HIGH) load new Wesleyan emails created by TSS into Millennium as a regularly scheduled job"]
[101,"New routine - yearly feed of legacy denials from SFIS to Mill","2002-01-31","2002-08-13","Done","Sharon","(LOW) ETA 8/03 yearly feed after incoming class finalized to create Comment records in Mill on the legacy constituent"]
[102,"Feed Freeman Asian Scholar indication to Mill","2000-09-13","2002-10-02","Done","Sharon","dependent on data getting in and maintained in SFIS.  Will be done manually by DSvs till then."]
[103,"New routine - feed Admission Vol into into Milll","2002-01-31","2002-11-13","Done","Sharon","(MEDIUM) feed the alumn's interest and the activity to Mill and create attributes 11/6 in prod being monitored"]
[104,"SFIS Feed - BA/ND process","2002-10-23","2002-11-26","Done","Sharon","(HIGH) for O/L Directory - when creating BA/NDs create the br0023 attribute"]
[105,"Extra curricular info into Millennium"]
[106]
[107,"Database"," "," "]
[108,"Hardware Fix to Earth","2001-12-17","2002-01-05","Done","Doug","(HIGH)"]
[109,"Change wesids to start with 800000","2002-02-25","2002-02-28","Done","Jane, Sharon","(HIGH) SFIS is now creating wesids starting with 600000."]
[110,"Replace MARS server","2002-07-30","2002-08-25","Done","D. Baker","(MEDIUM) "]
[111,"Neptune Replaced","2002-09-17","2002-09-17","done","D. Baker, Felix","(HIGH)"]
[112,"Install new Venus server","2002-10-30","2002-11-20","Done","Doug","(MEDIUM) "]
[113,"Install new Neptune server","2002-10-30","2002-12-06","Done","Doug","(MEDIUM) "]
[114]

{"sheet":"2001 Done","index":8,"n_rows":150,"n_cols":7,"rows_kept":150,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["#","Task","Start","Finish","Status","Resource","Comment"]
[1,"Volunteer Remote Access"," "," ",null," "]
[2,"Assigned Prospect Report enhancement","2000-12-05","2001-01-25","Done ","Jane","(MEDIUM) requested by J. Jurgen.  Create a mini version."]
[3,"Data Cleanup"]
[4,"Delete clsmon on deceased constituents","2001-01-04","2001-01-10","Done ","Jane"]
[5,"Apply Chart of Accts Goal/Division to gifts","2001-01-29","2001-02-07","Done ","Jane","(MEDIUM) Requested by D. Astin"]
[6,"Active Wes employees","2001-02-07","2001-02-16","done ","Sharon","(HIGH) use SFIS tsv file to inactivate ee's no longer at Wes"]
[7,"Honorary Degree cleanup","2001-03-09","2001-03-09","done","Sharon","set school = Honorary"]
[8,"Education Row - Preferred year","2001-01-22","2001-03-06","done ","Sharon","(MEDIUM) Set Preferred year = Corebio Preferred year for alumns with a mandatory class year attribute"]
[9,"Parent Addresses - flip addr lines","2001-03-09","2001-04-06","Done","Sharon","(HIGH) due to bad feed from SFIS--waiting in UR to review 4/2/01"]
[10,"Export Table cleanup","2001-05-14","2001-05-17","done","Barb, Jane","deleted over 600 of 900 tables"]
[11,"Matching Gift Credit Cleanup","2001-03-29","2001-05-31","DONE","Deb","(HIGH)"]
[12,"Attribute Comment cleanup","2001-05-02","2001-08-07","done","Deb, Marion, Dawn","(HIGH) remove 'Attended' and date of comments of activities"]
[13,"Invitation Attributes to Correspondence Rows","2001-04-04","2001-08-24","done","Deb, Marian","(MEDIUM)"]
[14,"Do Not Attributes","2001-06-01","2001-09-21","done","Deb, Barb, Jane","(HIGH) ETA week of 9/17, convert attributes, create std exports for ea. Attribute, data anomaly addition-see specs, run 1-shot to apply table group to the attribute rows for the 'br' attributes."]
[15,"Mandatory Class Assignment reivew/changes","2001-08-08","2001-09-08","done","Deb","(HIGH) align with new team structure in Mill."]
[16,"Multi year pledges","2001-09-04","2001-09-21","done  ","Dawn, Deb","(HIGH) Based on list from Dawn, set check# field to 'mult' for multiyr pledges"]
[17,"Add 'do not' attributes to WesCan selection","2001-10-25","2001-11-01","done","Jane","(HIGH) add 'do not contact' and 'do not contact-WesCan'."]
[18,"Action Row Priority field","2001-10-17","2001-11-15","Done","Jane","(HIGH) 1-shot to set priority field to blanks, D.anomaly edit for Cultiv. Strat type and Priority values."]
[19,"2001 Legacy Denials in Mill","2001-12-01","2001-12-01","done","Deb","based on data file from Admissions"]
[20,"Move Tracking Attributes to General Attributes","2001-10-10","2001-12-05","done","Deb, Dawn, Jane","(HIGH) bulk moves, rpts(Class Analysis?, Research Synop?)"]
[21,"Gift Goal/Division 1-shot","2001-12-06","2001-12-06","done","Jane","req'd by D. Astin  "]
[22,"Production Bug Corrections"]
[23,"Prospect Review - total all Pledge Potentials together","2001-01-26","2001-01-26","Done ","Jane","reported by K. Stibula"]
[24,"Gift Receipts - being produced even if class 2 = 'do not acknowledge' ","2001-03-27","2001-03-29","done ","Felix","(HIGH)"]
[25,"Prospect Review - Notes column is wrapping to next line","2001-04-30","2001-04-30","done","Jane","(HIGH)"]
[26,"Data Anomaly - fixes","2001-05-09","2001-05-09","done","Sharon","misinterpretation of specs for Pledge potential purpose ids and batch numbers"]
[27,"Mini-bio - correct sort order","2001-06-27","2001-07-24","Done","Jane","(MEDIUM) sort on parent year only if person is not an alum."]
[28,"WesMill- Contact Report","2001-12-11","2001-12-12","done","Felix","(HIGH) all quotes are replaced with question marks in the word document"]
[29,"WesMill - search fix","2001-12-11","2001-12-12","done","Felix","(HIGH) if 2 nicknames, person appears twice"]
[30,"WesMill- Contact Report","2001-12-11","2001-12-11","done","Felix","(HIGH) show the blank entry in the contact type dropdown and put in an edit force type selection"]
[31,"Miscellaneous Enhancements"]
[32,"New Function - Setting Relmgr to former as a nightly process","2001-02-02","2001-02-08","Done ","Sharon","(MEDIUM) if a relmgr has a stop date make it 'former relmgr', if a relmgr has no stop date make it 'relmgr'"]
[33,"Mailing Address Nightly Function","2001-02-14","2001-02-14","Done","Jane, Deb","add requested mailing address type to the logic to determine mailing address"]
[34,"New Summary - Pledge Potentials","2001-01-24","2001-02-10","done ","Jane","(MEDIUM) part of incorporating Pledge Potentials into reports"]
[35,"Define new 318 Basement printer","2001-02-20","2001-03-28","done ","Unassigned","(MEDIUM) dependent on delivery of new printer."]
[36,"Parent Attribute","2000-11-29","2001-05-01","done","Sharon","(LOW) Requested at usergroup meeting on 11/29. Add all parent years to the Parent attribute Comment field"]
[37,"End of Fiscal Year activity","2001-06-28","2001-07-16","Done","Felix","(HIGH) all FY end activity and a copy of the gift table"]
[38,"Surviving Spouse Process","2001-03-19","2001-08-09","done","Jane","(HIGH) ETA 8/31/01 req'd by L. Tipping.  New Corebio field, 1-shot startup, Data Anomaly edit"]
[39,"Convert data to 4 UR teams","2001-06-25","2001-08-29","Done","Jane","(HIGH) UR reorganization.  "]
[40,"Link Alumni Website with Millennium"," "," "]
[41,"Incorporate Cybercash to the Alumni web gift","2001-04-10","2001-12-05","done","Felix","Phase 1 recode in Oracle, install cybercash, encryption1"]
[42,"Events Module Enhancement for RC2K+1"," ","RC2K+1",null,null,"(HIGH)"]
[43,"Identify enhancements","2000-07-11","2001-04-02","done ","Nikki"," "]
[44,"Automated function to process online registrations into Millennium","2000-07-11","2001-04-02","Done","Nikki, Barb, Jane, Felix","Registration screen development"]
[45,"Mill Rel 7 Events testing","2000-12-14","2001-04-02","Done","Ryan, Lisa"]
[46,"WebDB enhancements","2000-07-11","2001-04-02","Done","Felix","more specific, canned reports - need specs from Events office"]
[47,"RC2001 Procedures updating","2000-12-14","2001-04-02","Done","Lisa, Ryan"]
[48,"Reporting"," "," ",null," "]
[49,"WesMill:Table Processing & Maint. enhancements",null,"2001-01-03","Done ","Felix","requested at user training on 7/20/00:undo function, table count, create date, save set logic, flow of screens after inserts or deletes of tables, delete multiple export tables at once"]
[50,"Maintain Relationship - enhancement","2001-01-02","2001-01-04","Done ","Jane","(MEDIUM) requested by A. Tetto.  Allow a relationship to be stopped for a class."]
[51,"Funding Opportunity Enhancement","2000-12-20","2001-01-16","Done","Jane","(HIGH) 1/31/01 ETA for A. Bergen - add Verbal Pledge and Grand Total Columns  Given to bwhitaker on 1/5/01 for review"]
[52,"New Report - Contact Report Stats","2000-11-14","2001-01-15","Done","Jane","(MEDIUM) requested by K. Stribula. Waiting for Karen's signoff"]
[53,"Assignment Status Rpt - enhancemt","2001-01-23","2001-01-23","Done","Dawn","changed to include a parameter to supress Comprehensive Solicitors"]
[54,"New Report - Leadership Gifts","2001-01-24","2001-01-29","Done","Dawn","new report to show major prospect gifts and reunion giving"]
[55,"Data Anomaly enhancements","2000-10-10","2001-02-01","Done ","Sharon","(MEDIUM) see specs - Oct 2000 - Jan 2001 section"]
[56,"Solicitation Form TSV - enhancement","2001-02-07","2001-02-07","Done","Jane","req'd by P. Vasiliou - add a column for the Cap 1 target amount"]
[57,"Donor Data Mart Enhancement - Pledge Potentials","2000-12-05","2001-02-21","Done","Jane, Dawn","(HIGH) Req'sted by D. Astin - create 1 new donor table bucket for all outstanding Pledge Potentials"]
[58,"Donor Data Mart - will considers","2001-02-15","2010-02-21","Done ","Jane","req'd by D. Astin - add a count of will considers"]
[59,"Bulk Email - enhancement","2001-01-03","2001-03-09","done","Unassigned","(LOW) requested by Waldron - ability to personalize the email and attach a generic document - Ravi's facility"]
[60,"Campaign Status",null,"2001-03-13","done","Jane","added pledge potentials"]
[61,"Gift Receipt - Gold Group membership card comment","2000-12-14","2001-03-13","done ","Felix","(HIGH) 3/1/01 ETA  requested by A. Marth"]
[62,"Preferred email on reports","2001-03-22","2001-03-26","done ","Sharon","(MEDIUM) report audit- change Pledge Balance Rpt to show preferred email address."]
[63,"Standard Exports for Area Campaigns","2000-11-01","2001-04-02","Done","Jane","(HIGH) needed for Jan 2001 Board meeting. Req'd by K. Stribula. 3/1/01-Karen reviewing "]
[64,"Target Review Enhancement",null,"2001-04-04","done","Jane","added pledge potentials"]
[65,"Single Mailing Enhancement",null,"2001-04-04","done","Jane","added pledge potentials"]
[66,"Prospect Review - Enhancement",null,"2001-04-04","done","Jane","added pledge potentials"]
[67,"Briefing Card Enhancement",null,"2001-04-04","done","Jane","added pledge potentials"]
[68,"Mini-bio with Gifts Enhancement",null,"2001-04-04","done","Jane","added pledge potentials"]
[69,"Maintain Incoming Student Parents - enhancement","2000-08-02","2001-04-05","Done","Sharon","(HIGH) ETA 7/1/01 Function should do processing if one or more parents are alumns, and change the source of familial relationships to UR"]
[70,"Standard Export Tables - incorporate enrollment status","2001-03-28","2001-04-06","Done","Sharon","(HIGH) only extract parents of students who are active or on leave. Student tables only for active or leave students"]
[71,"Area Code Split Routine","2001-04-06","2001-04-06","Done","Sharon","(MEDIUM)  Rewrite area code split routine, so that it does not need any manual intervention"]
[72,"Data Anomaly Enhancements","2001-02-20","2001-04-06","Done","Sharon","(MEDIUM) continue with additional edits in specs on FS1."]
[73,"SFIS Import Error Report","2001-03-13","2001-04-06","Done","Sharon","(MEDIUM) separate section for parents, delete module col, expand width of description col."]
[74,"Snapshot Class Giving","2000-11-02","2001-04-09","Done","Jane","(MEDIUM) req'd by Dawn - new columns--Given to UR for review 3/6/2000"]
[75,"FRS Feed - exclude EFT gifts","2000-12-14","2001-04-10","Done","Felix","(HIGH) 1/31/01 ETA requested by G. Waldron"]
[76,"Team Code Report","2000-10-10","2001-04-10","done","Felix","(MEDIUM) Change trigger to capture change in Team assignmt - put out on D. A. Rpt"]
[77,"Combined Mailing - enhancement (both versions)","2001-02-02","2001-04-10","done","Sharon","(MEDIUM) from Social Name Mtg - add a column to indicate an override for the combined name field"]
[78,"Mailing with Gifts - Enhancement","2001-04-10","2001-04-11","done","Jane, Dawn","(HIGH) single and combined versions - add a new column showing prior year giving total for all campaigns and include matches (P1_support from datamarts)"]
[79,"Research Synopsis - enhancement","2000-11-29","2001-04-12","Done","Jane","(MEDIUM)  Add Comment table to Research Synopsis - result of adding admission denials of legacy constituents"]
[80,"Research Synopsis - Enhancement",null,"2001-04-12","done","Jane","added pledge potentials"]
[81,"Parent Support Report - Enhancement",null,"2001-04-13","done","Jane","added pledge potentials"]
[82,"Volunteer Remote Access - Enhancement",null,"2001-04-16","done","Jane","added pledge potentials"]
[83,"Delete 6 unused reports","2001-02-22","2001-04-17","done ","Jane","(MEDIUM) part of report audit"]
[84,"Solicitation form and tsv - Enhancement",null,"2001-04-18","done","Jane","added pledge potentials"]
[85,"Assignment Status Rpt - enhancemt",null,"2001-04-20","done","Dawn","added pledge potentials"]
[86,"New WesMill Function - Maintain Solicitation programs","2000-10-06","2001-04-30","done ","Jane","(HIGH) requested by Waldron - ETA 8/1/01 - bulk update for WAF Rating Row - Cultivation field, Specs on FS-Signed off folder"]
[87,"New WesMill function - Parent Export Table","2001-04-02","2001-05-01","done ","Sharon","(MEDIUM) create parent export table based on student wesids."]
[88,"Gift Receipt - Change sort on Matching Gift Acknowledgment letters, so that Corp/Foundations sort to the top","2000-12-14","2001-04-26","Done ","Felix","(HIGH)  requested by A. Marth sent to UR for testing 4/9/01"]
[89,"Gift Receipt - Produce 1 receipt for multiple Matching gifts","2001-01-31","2001-04-26","Done","Felix","(HIGH)  requested by A. Marth.  1 Reciept for all gifts from a Matching Company on one day. sent to UR for testing 4/9/01"]
[90,"Gift Receipt - use student Campus address","2001-03-22","2001-04-26","Done","Felix","(HIGH)  sent to UR for testing 4/9/01"]
[91,"Gift Detail - new IR report",null,"2001-04-30","done","Dawn"]
[92,"Gift Receipt - 3rd tsv file for split allocations","2001-01-19","2001-05-22","Done ","Felix","(HIGH) create new tsv file for split gifts, don't create letter for purpid 440 - DAC gifts, no letter to Foundations/Corps"]
[93,"Single and Combined Mailing with Gifts","2001-04-26","2001-05-29","Done","Jane","(HIGH) requested by D. Astin - Change WAF consecutive Yr. Giving to Donor Consecutive Year Giving"]
[94,"Maintain Attributes- enhancement - Comments","2001-03-22","2001-05-30","done","Felix","(MEDIUM) allow a Comment column in input file to be used in creating/updating attributes UR is testing 5/23/2001"]
[95,"Maintain Correspondence - enhancement","2000-11-15","2001-05-31","done","Felix","(MEDIUM) allow users to attach documents  UR is testing 5/23/2001"]
[96,"Gift Solicitor Report - new IR rpt",null,"2001-05-31","done","Dawn"]
[97,"Campaign Giving Detail - new  IR rpt",null,"2001-05-31","done","Dawn"]
[98,"Life Income Accounting changes","2001-03-09","2001-05-22","Done","Jane","(MEDIUM) req'd by Dawn - New Donor Campagin Data Mart, changes to Detail Funding Opp Rpt, Donor Level Rpt"]
[99,"Campaign Donor Level Rpt - new WesMill rpt","2000-12-20","2001-06-25","done","Jane","(HIGH) 1/31/01 ETA for A. Bergen - create new WesMill campaign report to support campaign Pyramid & a total row at end. 3/1/01 - Dawn reviewing"]
[100,"Target Review Enhancement - 5 campaign project attributes","2001-06-12","2001-06-26","Done","Jane","(HIGH) requested by A.Bergen/ A. Goodwin.  ETA August 2001.  Specs on FS1."]
[101,"Target Review Enhancement","2001-03-21","2001-06-26","Done","Jane","(MEDIUM) requested by K. Stribula, E. Watrous. Add a column for current year giving."]
[102,"Delete WesMill Reports","2001-04-18","2001-06-25","Done","Jane","(MEDIUM) delete Dpt In Honor Of Gifts and Export Table Count reports"]
[103,"New Function - EFT feed to Bank ACH System","2000-12-14","2001-07-01","done ","Deb, Felix","(HIGH) 1/31/01 ETA requested by G. Waldron. UR is reviewing Treasury Express & PCACH"]
[104,"Maintain Address Utilizations - new WesMill function","2000-10-12","2001-07-01","done ","Felix","(HIGH) ETA for 9/1/01 bulk setting for mail flags, specs on FS1-Signed off folder UR is testing"]
[105,"Delete criteria files","2001-06-28","2001-07-05","done","Unassigned","(MEDIUM) delete criteria files of terminated UR staff members. List forwarded to Jane 6/28/01"]
[106,"Mini Bio enhancement","2001-06-27","2001-07-25","Done","Jane","(MEDIUM) requested at 6/27 usergroup meeting - option to show seasonal addresses, adjust fonts"]
[107,"Maintain WAF Targets - Enhancement","2001-07-18","2001-08-07","done","Jane, Camille, Dawn","(HIGH) ETA 8/1/01 - req'st by M. Zocco - changes for parent algorithm"]
[108,"Briefing Card - Rewrite","2001-05-02","2001-08-07","done","Karen, Jane","(HIGH) requested by K. Stribula per Doug, ETA ? Sent to Kstribula for review on 5/29/01"]
[109,"Target Analysis Group - Vendor extract - bio & giving data","2001-04-04","2001-08-27","done","Barb, Dawn, Felix","(HIGH) ETA 7/15/01 requested by G. Waldron - will be run after FY'01 closes.  Specs begun.  Sent to UR for review on 5/29/01"]
[110,"Mailing & Mailing w/Gifts Enhancement","2001-08-08","2001-08-31","Done","Jane","(HIGH) change the class year on the extract to show the alumni class year or the surviving sp year"]
[111,"Events - Registration website for HCFW '01","2001-06-18","2001-09-01","Done","Felix","(HIGH) ETA 9/1/01"]
[112,"Events - Remote Access reports","2001-02-08","2001-09-04","Done","Jane","(HIGH) ETA 9/30/01 req'd by M. Steinberg- a facility like WAF Remote access to email vol class lists for reunion.  Hold until policy decision is worked out"]
[113,"Balloon Pledge Buckets","2001-03-07","2001-09-14","Done","Jane","(MEDIUM) add a bucket for pledges beyond 5 yrs to DataMart, a new Summary, Solicitation Form, Solicitation TSV"]
[114,"New Report or Gift Roster Change","2001-01-10","2001-10-02","Done","Jane","(MEDIUM) requested at 1/10 user group mtg. Rpt to show all gifts for a household based on date range - like Daily Gift Rpt - show all trx types. Initial specs done by Jane"]
[115,"Snapshot Donor Level - Enhancement","2001-04-11","2001-10-03","done","Jane","(MEDIUM) requested by D. Astin - add 3 higher level groupings"]
[116,"New WesMill function - Maintain Emails","2001-10-09","2001-10-15","Done","Jane","(HIGH) ability to bulk delete emails based on an excel input file"]
[117,"Solicitation form - add enrollment status","2001-02-02","2001-10-12","Done","Jane, Camille","(MEDIUM) dependent on SFIS Bridge enhancement.  Req'd by Camille."]
[118,"Contact Report Website","2000-11-13","2001-11-02","Done","Felix","(HIGH) creates word doc, action, task, and links the document, site must be secure to UR staff only. Initial specs done 1/4/01  11/2-additional requests"]
[119,"Data Anomaly Enhancements","2001-07-18","2001-11-01","Done","Jane","(HIGH) see FS1 specs May01-present section"]
[120,"Sons & Daughters Registration Page","2001-10-23","2001-10-26","Done","Felix","(HIGH) req'd by Ryan"]
[121,"Campaign Combined Review, Target Review","2001-10-17","2001-11-15","Done","Jane","(HIGH) req'd by K. Stribula, add a new column for Cultivation Strategy Priority"]
[122,"Target Review Enhancement - attribute code","2001-10-23","2001-11-15","Done","Jane","(MEDIUM) req'd by K. Stribula extract the campaign proj attribute codes instead of the translation of the code"]
[123,"Target Review Enhancement","2001-07-25","2001-11-15","Done","Jane","(MEDIUM) requested by D. Astin. Add WAF Cultivation field to full version for WAF.  Waiting for columns for Campaign version from K. Stribula   Per Karen 11/14/01--no need for separate report for Waf vs Campaign"]
[124,"Mailing Combined with Gifts","2001-11-29","2001-11-29","done","Jane","added 4 new columns for last gift and campaign - also for spouse"]
[125,"Identification of Corp/Found gifts as individual or Corporation","2001-09-26","2001-11-27","Done","Jane","(HIGH) req'd by C. Scully and K. Stribula to support campaign reporting"]
[126,"Maintain Attribute Enhancement","2001-10-24","2001-11-29","Done","Jane","(MEDIUM) req'd by D. Treister have 2 dropdowns - code and attribute name  (The fix was to just put it back the way ist used to be, they now enter an attribute type)."]
[127,"Bridging Functionality"," "," ",null," "]
[128,"Direct Mill to SFIS Interface","2000-03-01T08:00:00"," ","done?","Gary Gravino","(MEDIUM)-Gary Gravino has written a routine that links to wes address & bio datamarts and pull addresses and desceased info for parents and alums"]
[129,"SFIS/Mill Feed Enhancement - enrollment status","2000-07-01","2001-03-13","done ","Barb, Meg, Deb, Sharon","(HIGH)"]
[130,"Research/Monitor 2001 Graduation class interfacing into Mill","2001-05-31","2001-07-01","done ","Sharon","(HIGH) "]
[131,"New Yearly Routine - Rollover any 'inactive' or visiting students for the graduating class year to an alumni status","2001-01-24","2001-07-01","done ","Sharon","(HIGH) ETA 6/1/01 for 01 graduation. Remove no shows and rollover 'inactive' or visiting students (no clsyr but active Ed Row) to alumni status"]
[132,"Feed Enrollment Day parent address updates to Mill","2001-05-17","2001-08-27","done","Felix","(HIGH) Registrar's offices testing in mid June, production by mid-July SFIS will turn over table by 6/29/01-but there is no data to test with at this time Sent to UR for testing 7/17/01"]
[133,"Lyris Feed - Class Notes & WesOnline Monthly","2001-05-16","2001-09-01","done","Jane","(HIGH) build feed for preferred emails for listserves"]
[134,"Rewrite SFIS Interface","2001-06-07","2001-12-05","done","Sharon","(HIGH)"]
[135,"Extra curricular info into Millennium"]
[136,"Policy kick-off discussion/meeting","1999-07-06T08:00:00","2001-05-09","done","Barb, Greg, UR reps","kickoff meeting on 5/9/01"]
[137,"Database"," "," "]
[138,"Install Mill  Rel 7.0.1 Service pack","2000-11-01","2001-01-20","Done","Steve, Felix","(HIGH)"]
[139,"Download class1/class2 bug fix","2001-02-22","2001-03-14","done ","Jane","(HIGH) for Release 7.0.1"]
[140,"Apply JSI fix for address util on spouses","2001-03-07","2001-03-14","done ","Unassigned","(MEDIUM) sent by JSI(Brennan) on 3/2/01"]
[141,"Saturn Replacement","2001-06-02","2001-06-03","done","Doug, Ken","(HIGH) "]
[142,"Earth Replacement","2001-06-09","2001-06-10","done","Doug, Steve W","(HIGH)  "]
[143,"Install Rel 7.1 in testing","2001-07-09","2001-07-09","done ","Unassigned","(HIGH)  "]
[144,"Conduct Rel 7.1 testing","2001-07-16","2001-08-03","done ","Barb","(HIGH) set up usergroup sessions"]
[145,"Support Rel 7.1 testing","2001-07-16","2001-08-03","done","Felix/Jane","(HIGH) "]
[146,"Install Rel 7.1 to production","2001-08-03","2001-08-03","done","Felix, S. Windsor","(HIGH)  "]
[147,"Install SSL on Neptune/Saturn","2001-07-12","2001-09-25","Done on Neptune 8/28, Saturn 9/25","Felix, Doug & Pat","(MEDIUM)"]
[148,"MARS hardware upgrade","2001-11-15","2001-11-15","done","Felix"," "]
[149]

{"sheet":"1999-2000 Done","index":9,"n_rows":258,"n_cols":8,"rows_kept":258,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["#","Task","Start","Finish","Status","Resource","Comment"]
[1,"COMPLETED TASKS"]
[2,"Full Implementation Support",null,null,null," "]
[3,"1999 Pledge Write-offs - 1 time","1999-10-11","2000-04-04","done","Chip, Dawn","(HIGH) Utility run under Rel 6.04 SP1 on 4/4/00"]
[4,"Remove UDB Access",null,"2000-02-15","done","Chip"]
[5,"Document Operational Support Procedures","1999-10-18","1999-10-28","Done","Jane, Chip"]
[6,"Autosys job to populate email/wesid table for Wescan & Remote Access","1999-10-18","1999-10-29","Done","Jane"]
[7,"Build & maintain report statistics","1999-11-23","1999-11-23","Done","Chip"]
[8,"Data Services Printer Queue",null,"1999-12-09","cancelled","Jane"]
[9,"Printer Assignment Maintenance","1999-11-15","2000-01-18","Done","Chip, Donald"," "]
[10,"Harris Alumni Directory"," "," ","DONE"]
[11,"Development Plan for Harris","1999-10-01T08:00:00","1999-10-06T17:00:00","Done","Barb, Chip, Michael, Deb"]
[12,"Submission of Millennium data","1999-10-08","1999-11-16","Done","Chip, Deb","Files sent to Harris"]
[13,"2nd Submission of data to Harris","2000-02-07","2000-03-15","done","Deb, Chip"]
[14,"Receipt and Intrepretation of Harris data  ","2000-03-15","2000-05-17T17:00:00","done","Deb"]
[15,"Load Harris Data to Millennium","2000-05-18T08:00:00","2000-11-03","done","Deb"]
[16,"Millennium 6.04 ","TBD","TBD",null,"Steve, Jane, Barb","(HIGH)"]
[17,"Install on URD/Venus","1999-11-18","1999-11-18","Done","SWINDSOR, JJYLKKA"]
[18,"Test on URD Development","1999-11-19","1999-12-03","done","UR","Problem with Gift Batch# on Insert. Writeoff utility bug."]
[19,"Install on Production & Training","1999-12-06","2000-03-22","done","Swindsor, JJylkka","installed on Neptune on 3/21/00, Saturn on 3/22"]
[20,"Test new queue software","1999-10-13","1999-11-19","Done","Jane","v6.04 queue software installed on production reporting queues as of 18-Nov"]
[21,"Millennium Changes for new UR organization structure","2000-01-20","2000-04-14",null,"Jane, Barb, Chip","(HIGH) initial meeting on 1/20/00"]
[22,"Team Code Assignments","2000-04-03","2000-04-17","Done","Jane","(HIGH)"]
[23,"Events Module Support","1999-08-23T08:00:00","2000-01-21T17:00:00"]
[24,"Review events module with JSI.","1999-09-07T08:00:00","1999-09-08T17:00:00","Done","Nikki, Gemma, Barb, Lisa"]
[25,"Direction/Task/Procedures","1999-11-08","2000-01-21T17:00:00","done","Nikki, Gemma, Barb, Lisa"]
[26,"Specify Needed Reports","1999-11-08","2000-06-01","done","Nikki, Barb, SMachuga, Mglynn"]
[27,"Report Creation","1999-12-01","2000-06-01","done","M. Glynn"]
[28,"Events Procedure Documentation","1999-08-23T08:00:00","2000-06-01","done","Nikki, Lisa, Gemma"]
[29,"Relationship Management Enhancements","1999-10-18","2000-07-27",null,null,"(HIGH) waiting for UR signoff"]
[30,"Relationship End Dates, Export Tables, Class Years","2000-05-01","2000-07-27","done","Barb, Jane, Annette","specs sent to ITS on 3/20"]
[31,"Delete Class Monitor Relationships","2000-05-01","2000-07-27","done","Barb, Jane, Annette"]
[32,"Insert Class Monitor for New Grad Class","2000-05-01","2000-07-27","done","Barb, Jane, Annette"]
[33,"Stop a deceased Prospect mgt relations","2000-05-01","2000-07-27","done","Barb, Jane, Annette"]
[34,"Link Alumni WesNet.html with Millennium","1999-10-01T08:00:00","1999-11-02T17:00:00"]
[35,"Revamp the Email Directory updating process on the alumni website"," ","2000-06-21","done","Hannah","requested by Drew Sanborn & M. Casey"]
[36,"Data Cleanup"]
[37,"Delete Olin standalone attributes",null,"1999-11-30","done 12/2","Jane"]
[38,"Cleanup of Reunion Attributes from Conversion","1999-11-03","1999-12-14","done","Angela, Chip"]
[39,"Parent/CRC Volunteer Attributes",null,"2000-01-31","done","Dawn"," "]
[40,"Wrong campaign on gift/pledge trx","2000-02-02","2000-02-25","done","Cate, Chip"]
[41,"Multiple companies with different ids","1999-12-01","2000-02-24","done","Cate","ongoing"]
[42,"Pledge payments with no solicitation codes","2000-02-29","2000-03-07","done","Chip","email sent to Chip on 2/29."]
[43,"Cleanup of gifts to purid 785 - set goal and division","2000-02-29","2000-03-07","done","Chip","email sent to Chip on 2/29."]
[44,"Matching Gift Solicitation codes","2000-03-09","2000-03-21","done","Chip, Dawn","set the sol code to 'match', sent to ITS on 3/9"]
[45,"Industry code cleanup- nightly run","2000-03-15","2000-04-05","done","Jane"," "]
[46,"Address Preferred flag cleanup",null,"2000-04-20","done","Sharon","if locator not = good then uncheck the Preferred flag"]
[47,"Graduate Alumn (1999) pref year - 1shot",null,null,"done","Sharon","prefyr not set in UDB and so not fed to Mill"]
[48,"Purpose id name cleanup","2000-05-04","2000-05-17","done","Carol K, Chip","request per Carol K. Email sent to ITS on 5/15."]
[49,"Corebio CAE codes need to be cleaned up",null,"2000-05-22","done","Jane","(HIGH) to assist in producing CAE report in July 00. Specs to Sharon on 4/20.Needs to be added to batch constituent update function"]
[50,"Alum/ee source cleanup","2000-05-24","2000-05-30","done","Jane","set the corebio souce to UR for all alum employees of Weslyean"]
[51,"Convert 'MALS\" degrees to \"MAL\" degrees","2000-06-12","2000-06-14","done","Chip","due to new SFIS feed"]
[52,"Purpose id cleanup for goals and divisions and Incorporate the CAE category of Athletics into the Purposes in the Chart of Accts table and gifts","2000-04-18","2000-06-14","done","Dawn, Chip","(HIGH) New Athletic CAE codes forwarded to ITS on 4/18&Chip did on 4/27. Goals applied on 5/3.Divisions on 6/14."]
[53,"Employment Row ","2000-05-17","2000-06-26","done","Jane","take out Descript 1 of Primary for jobs with status of 'No longer…'"]
[54,"Delete invoice address",null,"2000-06-26","done","Jane"]
[55,"1999 Alum Cleanup","2000-05-23","2000-06-27","done","Jane","submitted to ITS on 5/23.  Clean up Title, name overrides and delete WesPO Box."]
[56,"Convert 'MAAE\" degrees to \"MAA\" degrees","2000-06-27","2000-06-27","done","Sharon","due to new SFIS feed"]
[57,"1-shot to set all current student WesPO Addresses ","2000-07-10","2000-07-19","done","Jane","set city, state, zip fields"]
[58,"Corebio - set the preferred year",null,"2000-09-01","done","Sharon","(HIGH) set the preferred year = to the Education degree yr."," "]
[59,"Education attribute linking","2000-09-14","2000-09-30","Done","Sharon","Education attributes codes 'eu0000' thru 'eu0015' ' should be linked to the Wesleyan Undergraduate Education row"]
[60,"New goals/Divisions in Chart of accts","2000-10-02","2000-10-10","done","Chip","ETA 10/9 requested by Dawn - run 1 - shot to change goals/div on gifts"]
[61,"Magazine Mail Flag setting","2000-10-12","2000-10-19","Done","Jane","(MEDIUM) ETA of 11/3 requested by D. Astin for magazine mailing extract. 1-shot to adjust the magazine mail flags"]
[62,"Prize  Attributes - reconvert from UDB","2000-04-15","2000-10-25","Done","Chip","(MEDIUM) requested by researchers 10/19 waiting for approval from UR"]
[63,"Assign parent years to step parents","2000-11-15","2000-11-29","Done","Sharon","requested by C. Dolansky"]
[64,"Production Bug Corrections"]
[65,"Pledge Acknowledgment - correct the tsv file to have city if an apartment number is present","2000-01-11","2000-01-11","done","Cate, Sharon "," "]
[66,"Memories - correct for refusals & considers.","1999-12-14","2000-01-12","done","Jane"," "]
[67,"Convert attachments to Word docs",null,"1999-01-13","Done","Jane","Convert attached files from text docs to Word docs such that Synopsis prints correctly."]
[68,"WAF Assignment Status Report  - should only show active relationships","2000-01-26","2000-01-27","done","Jane","reported to ITS on 1/26."]
[69,"Criteria Review Rpt - no wesid or constituent types","2000-02-02","2000-02-02","done","Jane"]
[70,"Combined Mailing - Nickname2 not correct","2000-02-10","2000-02-11","done","Jane"]
[71,"Mini Bio reports (2)- ",null,"2000-02-14","done","Jane","reequested by M. Zocco - show all undergraduate children"]
[72,"Fix gift rows with invalid giftsumkeys",null,"2000-01-31","Done","Chip"]
[73,"Gift Receipts - wrong Rel mgr","2000-03-07","2000-03-09","done","Unassigned","reported to ITS on 3/7"]
[74,"Department Gift Report - drops records if donor has no valid address","2000-03-13","2000-03-24","done","Jane","reported to ITS on 3/13"]
[75,"Summaries - totals for Corporations",null,"2000-04-04","done","Jane","reported by G. Mezzi"]
[76,"Pledge Acknowl. - change the due date to the end of the fiscal year","1999-12-09","2000-04-04","done","Sharon","Pledge Ackn rewritten"]
[77,"Gift Receipts - take out the deductible message, ","1999-12-09","2000-04-04","done","Sharon"," "]
[78,"Pledge Acknowl.- take out message \"$nn of gift was applied to\"","2000-04-03","2000-04-04","done","Sharon"]
[79,"Daily Gift Report - truncates 7 positions numbers","2000-04-12","2000-04-13","done","Jane","reported to ITS on 4/12/00"]
[80,"Remote Access - Total Column not calculated correctly","2000-04-18","2000-04-25","done","Jane","Dawn reported to ITS on 4/18/00"]
[81,"Snapshot Donor - #of donors not calculated correctly","2000-04-18","2000-05-08","done","Jane","Annette  reported to Chip in early April"]
[82,"Gift Receipts- stock wording","2000-05-03","2000-05-10","done","Sharon","take out $ on stock gifts with multiple allocations"]
[83,"Volunteer Roster",null,"2000-09-06","done","Jane","failure msg due to lack of space - remove attr code and group code fields"]
[84,"New Report - Screening Statistics",null,"2000-05-01","hold","Unassigned","Requested by M. Casey"]
[85,"New - Survey Results Reports","2000-08-01","2000-09-01","hold","Unassigned","Requested by M. Casey"]
[86,"Big Reunions",null,"1999-12-30","Hold"]
[87,"Executive Committee Progress",null,"1999-12-30","Hold"]
[88,"Leadership Gifts Committee: Progress Summary",null,"1999-12-30","Hold"]
[89,"Major Project Progress",null,"1999-12-30","Hold"]
[90,"Prospect Donor List",null,"1999-12-30","Hold"]
[91,"WAF Trophy Standings",null,"1999-12-30","Hold"]
[92,"SFIS Interface - birthdate does not have 4 position year","2000-09-26","2000-09-27","done","Sharon","reported by D. Treister"]
[93,"SFIS Interface - parent titlebar wiped out","2000-09-26","2000-09-27","done","Sharon","reported by K. Stribula - will be cleaned up by K. Stribula manually"]
[94,"Maintain Incoming Student Parents - change name to Ms if different last names.","2000-09-25","2000-09-27","done","Jane","(HIGH) based on complaint from parent"]
[95,"Mini Bio reports - show the preferred email address","2000-10-26","2000-10-27","Done","Jane","currently only shows email if the email type is 'email'."]
[96,"Department Notificiation Rpt","2000-11-13","2000-11-17","Done","Jane","not page breaking correctly"]
[97,"Maintain Attributes - descr2","2000-12-07","2000-12-08","done","Jane","routine fixed to look at 2nd descriptor table"]
[98,"Miscellaneous Enhancements"]
[99,"Batch class year/parent year process","2000-08-29","2000-09-21","done","Sharon","(HIGH) set parent year for guardians, need to change constituent attribute batch process to create parent attrib for guardians"]
[100,"Rating Row - Cultivation field - 1 shot","2000-10-03","2000-10-06","done","Jane","(HIGH) designate the Solicitation Program on the WAF Rating row"]
[101,"Review saturn/docs security",null,"2000-11-15","done","Felix","(HIGH) restrict user ability to create/delete subdirectories"]
[102,"New gift type - Pledge Potential","2000-09-20","2000-11-15","done","Barb, Deb, Karen","(MEDIUM) incorporate into verbal commitment process"]
[103,"Summaries - Enhancements"]
[104,"Worksessions to determine changes that are needed & impact & effort","1999-01-11","2000-01-13","done","Barb, Chip","meeting held"]
[105,"Changes to Memories","1999-02-01","1999-02-28","done","Jane","help documents modified"]
[106,"Summaries - enhancement - break out WAF and Donor giving into its components",null,"2000-12-07",null,"Unassigned","Accomodated by data marts.  requested by K. Stribula, ITS developing a proposal. Consider when defining datamart."]
[107,"Bulk Correspondence","1999-10-11","2000-05-04","done","Barb, Deb","Test JSI Functionality"]
[108,"Security Research Extract"," "," ",null,null,"(HIGH)"]
[109,"Sign contact with outside Vendor","1999-12-01","2000-04-07","done","Karen","1/20/00 - Karen states contract is not yet signed."]
[110,"Specs for electronic feed","2000-03-30","2000-03-30","done","Karen","specs sent to Chip on 3/30"]
[111,"Submission of Mill data to vendor","2000-04-15","2000-04-14","done","Karen, Jane","function developed - Karen to run"]
[112,"Bulk Email Enhancements","1999-10-01T08:00:00","1999-11-26T17:00:00"]
[113,"Bulk Email - Add separate CC and attachment functionality","1999-10-15","1999-12-01","Done","Felix"]
[114,"Telefund Integration","1999-06-01T08:00:00","2000-03-09T17:00:00","HOLD","Michael,Chip,Barb","HOLD"]
[115,"High-level Telefund  Requirements","1999-06-01T08:00:00","1999-06-01T17:00:00","DONE","Michael, Barb"]
[116,"Begin to Investigate Telefund Options, Compromises","2000-01-04","2000-03-01","Hold","Barb, Paul, Karen","Hold per M. Casey"]
[117,"Finalize Telefund Direction","2000-03-01","2000-03-30","Hold","Chip, Paul, Karen, Barb"]
[118,"Telefund Code Changes","2000-04-01","2000-09-01","Hold","Chip, Ravi"]
[119,"Yearly Targeting Enhancements",{"$nulls":4},"(HIGH)"]
[120,"Analysis of changes req'd for 00/01",null,"2000-07-01","done","Barb, Meg, Greg, Michael","initial meeting scheduled for 5/22/00"]
[121,"Enhancements to algorithms",null,"2000-07-01","done","Unassigned","initial meeting scheduled for 5/22/00"]
[122,"Enhancement - include all outstanding future pledges",null,"2000-08-29","done","Chip","per Greg's request"]
[123,"Credit Balance Amount Bug","1999-10-11","1999-10-31","Done","Chip, Dawn","Dawn documented & JSI has notified us this is not a bug."]
[124,"User Conference Presentation","1999-09-15","1999-11-09","Done","Jane & Felix"]
[125,"Combined Solicitation Form","1999-09-09T08:00:00","1999-10-04","Done","Jane"]
[126,"Wesid File Processing ","1999-09-02T08:00:00","1999-12-31T17:00:00","Done"]
[127,"Wesid File Processing Specifications","1999-09-02T08:00:00","1999-09-08T17:00:00","Done","Chip,Barb"]
[128,"Wesid File Coding","1999-09-30T08:00:00","1999-09-30T17:00:00","Done","Felix"]
[129,"Volunteer Remote Access","1999-06-01T08:00:00","1999-11-02","Done","Felix,Ravi"]
[130,"Define Volunteer Remote Access Specifications","1999-06-01T08:00:00","1999-06-01T14:00:00","Done","Michael"]
[131,"Volunteer Remote Access Technical Approach","1999-06-01T14:00:00","1999-06-08T14:00:00","Done","Felix,Ravi"]
[132,"Report Specifications","1999-06-29T08:00:00","1999-07-01T17:00:00","Done","Michael,Paul"]
[133,"Volunteer Remote Access Implementation","1999-09-29T14:20:00","1999-10-22T13:08:00","Done","Barb, Annette Tetto"]
[134,"Volunteer Remote Access Data Cleanup","1999-09-21T14:20:00","1999-11-02T14:20:00","Done","Michael, Cate, Annette"]
[135,"Cleanup of Remote Access Attribute names applied to Attribute rows",null,"1999-12-15","Done","Cate"," "]
[136,"Add a counter of hits to the site","2000-01-27","2000-02-29","done","Steve M.","requested by Annette; Steve has asked P Leone to install."]
[137,"Enhancements - Class Detail Rpt (Super Rpt) changes","2000-09-26","2000-11-16","done","Chip","(MEDIUM) requested by Waldron - add columns"]
[138,"Help Files","1999-09-08T08:00:00","2000-11-16","done","Michael, Paul, Lisa Gates","not high priority per Casey"]
[139,"WESCAN Enhancements",null,null,"Done","Jane","(HIGH) Sciola signed off on 7/6/00-waiting on documentation from CRC"]
[140,"Parent Exclusion",null,"2000-08-14","Done","Jane","6/30/00 requested ETA by M. Sciola"]
[141,"Search by name",null,"2000-06-30","Done","Jane","requested ETA by M. Sciola(no per M. Sciola--6/19/00)"]
[142,"Change heading from 'degree' to 'advanced degree'",null,"2000-08-14","Done","Jane","6/30/00requested ETA by M. Sciola"]
[143,"Search by class year and range of class years",null,"2000-08-14","Done","Jane","6/30/00requested ETA by M. Sciola"]
[144,"Include Note 'Not to use Back/Forward navigation buttons'.",null,"2000-08-14","Done","Jane"]
[145,"Bulk Prospect Management Relation Change Facility ","1999-09-21T08:00:00","1999-12-31T17:00:00","Done"]
[146,"Bulk Prospect Management Specifications","1999-09-21T08:00:00","1999-09-21T14:20:00","Done","Michael,Barb,Felix"]
[147,"Bulk Prospect Management Coding","1999-09-21T14:20:00","1999-09-29T14:20:00","Done","Felix"]
[148,"New Maintain Employment Function",null,"2000-05-11","done","Jane"]
[149,"Address Utilization bulk change","1999-10-18","1999-10-19","Done","Chip, Dawn"]
[150,"Targeting Algorithm Changes",null,null,"Done"]
[151,"Analysis of Need","1999-10-14","1999-10-18","Done","Chip, Paul"]
[152,"Implementation of Changes","1999-10-18","1999-10-20","Done","Chip, Paul"]
[153,"Zip Code - Test Environment",null,null,"Done",null,"(HIGH)"]
[154,"Data Anomaly Enhancement and ITS procedure changes","2000-07-13","2000-10-04","done","Barb, Deb, Sharon"," "]
[155,"Reporting","1999-03-23T08:00:00","2000-05-15T08:12:00","Done"," "]
[156,"Anomaly Scan","1999-06-01T08:00:00","1999-06-01T17:00:00","Done"]
[157,"Enhance Data Anomaly – cc Campaign on gifts prior to 7/1/97","1999-10-01","1999-10-22","Done","Sharon"]
[158,"Enhance Data Anomaly – check gift camp yr >1950","1999-10-01","1999-10-22","Done","Sharon"]
[159,"Enhance Data Anomaly – Detect orphan rows","1999-10-01","1999-10-22","Done","Sharon"]
[160,"Enhance Data Anomaly – Lookup table blank values","1999-10-01","1999-10-22","Done","Sharon"]
[161,"Enhance Data Anomaly – sort on userid","1999-09-30","1999-10-22","Done","Sharon"]
[162,"Enhance Data Anomaly - edit for PM relationships not linked for donor",null,"1999-10-18","Done","Sharon"]
[163,"Waf  Class Status","1999-09-15",null,"Done","Dawn"]
[164,"Combined Solicitation Form","1999-10-15",null,"Done","Jane"]
[165,"Payroll Deduction Gift Receipts","1999-06-01T08:00:00","1999-06-21T08:30:00","Done","Felix"]
[166,"Briefing Card","1999-07-06T08:00:00","1999-07-12T17:00:00","Done","Elizabeth"]
[167,"Enhance WAF Class Status","1999-08-31T08:00:00","1999-08-31T17:00:00","Done","Jane"]
[168,"Enhance Mailing Extracts","1999-08-31T08:00:00","1999-09-30T17:00:00","Done","Jane"]
[169,"Enhance Research Synopsis","1999-09-01T08:00:00","1999-09-30T17:00:00","Done","Jane"]
[170,"Single Merge with Gifts - add fraternity","1999-09-27","1999-10-15","Done","Jane",null," "]
[171,"Class Distribution - Class Counts -New Report",null,"1999-10-15","Done","Jane"]
[172,"Mini Bio w/gifts - Enhancements- capacity from rateaskamt, Wes Children to Children","1999-10-01","1999-10-15","Done","Jane "]
[173,"Name Printout (JSI report).  Modify to have \"Maid\" name point to Grad Name (Enhancement)",null,"1999-12-15","Cancel",null,"Report replaced by SQR Roster"]
[174,"Roster - WesMill version","1999-10-20","1999-11-15","done","Sharon"]
[175,"Pledge Acknowledgements","1999-10-06","1999-10-15","done 11/15","Cate","word template needs a fix"]
[176,"No country on gift reciepts & Pledge Acknowledgements",null,"1999-11-29","Done","Sharon"]
[177,"Snapshot - Enhancement - extract file for pledges ",null,"1999-12-07","Done","Chip, Dawn"]
[178,"Campaign Status Spreadsheet (Driscoll Spreadsheet)","1999-09-20","1999-12-09","done","Barb, Jane"," "]
[179,"Solicitation Form Enhancement - indicate refusals and will considers",null,"1999-12-16","done","Paul, Jane","Test version completed Dec 10, waiting for UR approval."]
[180,"Pledge Reminders","1999-11-01","1999-01-11","In Progress","Sharon, Dawn,Cate"," "]
[181,"Enhancement - Rating List Report.  Change capacity to pull from Capital 1 rateaskamount field - also add credits to Campaign total field on report",null,"1999-12-20","done","Jane"]
[182,"Criteria Review Report - New Crystal Report for IR",null,"1999-12-21","done","Barb, Jane","List of names & wesids sorted alpha from any export table."]
[183,"Considers & Refusals","1999-12-09","1999-12-23","Done","Jane","Modify report software for new detection of Considers & Refusals."]
[184,"Campaign Status Spreadsheet - show proposal with greatest ask amount value","1999-12-16","1999-12-23","Done","Jane"]
[185,"Enhancement - JSI's Daily Gift.rpt - add relationship Manager ",null,"2000-01-10","done","Jane, Barb"," "]
[186,"Batch Balance Report","1999-10-01","2000-01-13","done","Jane, Cate"," "]
[187,"UR Developed Reports to Production Environment","1999-11-15","2000-01-17","Done","Jane, Dawn, Barb","Waiting on automated copy"]
[188,"Attached Document Scan","2000-01-17","2000-01-24","DONE","Jane","Scan Attachments table for invalid linkages & update the Error table."]
[189,"Target Review - Enhancement - add Life Total figure that is contained on the Mini Bio w/ Gift report and anonymous giving",null,"2000-01-27","Done","Jane","requested by K. Stribula"]
[190,"Solicitation Form Enhancement - ",null,"2000-02-23","done","Jane","requested by Meg Zocco -specs are ready on FS1-add High School & spouse's jobtitle and company name"]
[191,"Export reports from IR and WesMill to Word or to bulk email (via an HTML file)","1999-11-01","2000-02-10","done",null,"html reports saved to html file and attached to email"]
[192,"Combined Merge with gifts","2000-01-21","2000-02-15","done","Jane"," "]
[193,"WAF Assignment Status Report  - add sort option of Class Monitor or WAF solicitor","2000-01-24","2000-02-23","Done","Dawn, Jane","requested by Meg Zocco (wesmill, medium priority); UR reviewing."]
[194,"Daily Gift Report - add fields","2000-02-23","2000-03-08","done","Rich","based on JSI Daily_Report_Gifts.RPT, specs available"]
[195,"Dept Gift Report - enhance/correct",null,"2000-03-08","done","Rich","specs available - anon info, subtotal on wesid, take out addr edit(not done)"]
[196,"New Report - Screening spreadsheet","2000-02-02","2000-03-08","done","Rich"]
[197,"Data Anomaly - Ehancement - check for dates less than 1900, wafsol=csol, only 1 Do Not Solict Attrib., comment out edit for death date error, 'do not' attibutes linked to basic bio",null,"2000-03-15","done","Barb, Sharon (as fill work with bridging)","(HIGH) spec have been developed. Waiting for ITS resource."]
[198,"WesMill: Constituent Search function",null,"2000-03-30","done","Felix","(HIGH) specs sent to ITS"]
[199,"Develop Help documents & template criteria for UR developed reports","1999-12-15","2000-04-05","done","Dawn","Template Criteria done.  Need to develop help (5year giving, frats, surv sp, sports and cleanup report formats."]
[200,"Research Synopsis - add eff dte to gift detail","2000-03-01","2000-04-12","done","Jane","requested at usergroup mtg 3/1/00"]
[201,"New Mailing Extract - Student Campus addresses",null,"2000-04-12","done","Dawn Jane","requested by A. Tetto - specs are available; in testing w/Dawn"]
[202,"Data Anomaly Enhancement - new edit for Address Record","2000-04-19","2000-04-20","done","Sharon","address marked preferred & locator is not 'good'"]
[203,"Lookup Table Printouts (Chart of Accts, Attributes)","2000-02-01","2000-04-27","done","Dawn, Rich","Rich did Attributes, Dawn did Chart of Accts"]
[204,"Data Anomaly Enhancement - new edit for Address Record","2000-04-28","2000-04-28","done","Sharon","1good address and no effective months"]
[205,"Gift Receipts: Rework software for ease of maintenance.","2000-01-12","2000-04-08","done","Sharon","Testing 28-Feb-00"]
[206,"Credit Card Report for Data Services",null,"2000-05-01","done","Barb","JSI corrections make the rpt usable for DSvs."]
[207,"Affinity Reports",null,"2000-05-11","done","Barb,  Jane ","(HIGH) 4/5 Go with specs, delivery target 4-6 weeks. April- Casey signed off specs"]
[208,"Help documentation - add thumbnail examples to help",null,"2000-01-30","done","Lisa, Chip, Jane"]
[209,"Target Review Enhancement - Research info",null,"2000-05-17","done","Jane","HIGH-Karen's request) add Last Research date,Date Checked fields"]
[210,"Briefing Card - Enhancement - ",null,"2000-05-19","done","Karen, Jane","(HIGH)) Requested by K. Stribula-Last gift should include payments, remove Last WAF year"]
[211,"Daily Gift Rept - Enhancement","2000-05-16","2000-05-19","done","Dawn","requested by M. Zocco- add Parent year column"]
[212,"FRS Summary by Purpose Enhancement","2000-05-24","2000-06-20","done","Jane","(HIGH) add cfae codes of 'S' and 'T'"]
[213,"Attribute Table Printout","2000-06-01","2000-06-05","done","Dawn","get sorts and active/inactive selects to work\\"]
[214,"Target Review Enhancement - Combined name & Employment info",null,"2000-06-13"," ","Jane","Usergroup Mtg - requested Combined name if export table has combine name option.  Employment requested by M. Lawrence - needs to be defined for non-active jobs (still needed?) - not approved and not implemented"]
[215,"Datamart for ad hoc reporting","2000-02-15","2000-06-01","Done","Chip, Jane","Data extraction. Initial structure built & is being refreshed nightly."]
[216,"Datamart - Wes_Bio Enhancement","2000-06-13","2000-06-19","done","Jane","Add titlebar fields(priv, privaddr, trustee,vip)"]
[217,"New Report - Graduating Students Spreadsheet","2000-06-20","2000-07-06","done","Jane","(HIGH) requested by Kirstin Fearnley for Press releases"]
[218,"Standard Extracts ","2000-03-29","2000-07-11","done","Dawn, Chip, Jane","(HIGH) Initial specs prepared by Dawn, First export tables created."]
[219,"Research Synopsis - enhancement - Add Correspondence & Media Data to the report","2000-01-27","2000-07-13","Done","Deb, Karen, Jane","(MEDIUM) requested by K. Stribula -submitted to Kstribula for testing 7/6/00"]
[220,"WesMill: Export Table Set Logic",null,"2000-07-20","done","Felix","(HIGH) Delay due to Felix's work on SFIS."]
[221,"WesMill: Export Table Conversion",null,"2000-07-20","done","Felix","(HIGH) To/From Spouse Combined"]
[222,"WesMill: Export table maintenance enhancement","2000-03-22","2000-07-20","done?","part of the new table set logic","ability to copy another user's export table as your own.  Requested by A. Tetto on 3/22"]
[223,"Adjust Printer Configurations","2000-07-12","2000-07-26","done","Chip, Doug","(HIGH) Admissions bldg, 48 Wyllys, 330 High"]
[224,"Research Synopsis",null,"2000-08-29","done","Jane","search options  added"]
[225,"New Report - Prospect Review",null,"2000-09-15","Done","Jane","(MEDIUM) requested by K. Stribula in time for Sept meeting with Jenkins"]
[226,"Screening Spreadsheet Enhancement",null,"2000-09-15","done","DAWN","(HIGH) needs to be rewritten in WesMill - fonts mixed"]
[227,"Solicitation form - tsv file",null,"2000-09-30","Done","Jane","(HIGH) to support the 10/11/00 Phonathon"," "]
[228,"Data Anomaly Enhancements","2000-08-01","2000-10-02","done","Sharon","(MEDIUM) Misc. additions"," "]
[229,"Incorporate 'Cultivator' as a new relationship","2000-07-31","2000-10-02","done","Jane/Sharon","(MEDIUM) Data Anomaly - only have 1, Maintain Rel - add as valid relationship"," "]
[230,"Volunteer Roster Enhancement","2000-10-04","2000-10-12","done","Sharon","add a column for parent year"]
[231,"WesMill  - Screening spreadsheet",null,"2000-10-22","Done","Jane","(LOW) req'd by K.Stribula-rewrite IR Screening Spreadsheet Wes to WesMill - fonts mixed in IR, Target Review option in WesMill-10/13 made an enhancement to Target Review which should elminate this request"]
[232,"Combined mailing enhancement","2000-10-12","2000-10-25","Done","Jane","(MEDIUM) do not populate the mailname2 if the spouse is deceased."]
[233,"Excel Campaign Analysis: fix asof date & menu scripts for YTD Reports","2000-10-19","2000-10-25","Done","Chip","(HIGH)"]
[234,"WesMill - New Report -  Matching Potentials by donor","2000-09-14","2000-11-02","done","Felix, Andrea","(MEDIUM) create an export table of donor whose companies have matching potentials"]
[235,"WesMill:  New Bulk correspondence utility",null,"2000-11-02","done","Felix","(MEDIUM) requested by A. Tetto at usergroup mtg 3/1/00 - linked to new WesMill extract for matching potentials"]
[236,"New Report - Honor Roll","2000-07-13","2000-11-09","done","Dawn, Chip","(HIGH) ETA of 10/20 per G. Waldron for internal purposes/ 10/19-waiting for signoff from UR"]
[237,"Prospect Review Enhancement","2000-11-01","2000-11-20","Done","Jane","(HIGH) ETA week of 11/13/00  Report must be changed to look at Pledge Potentials instead of Proposals for Verbal commitments"]
[238,"WesMill- new function - Convert Excel to Export Table","2000-11-01","2000-11-17","done","Felix","(MEDIUM)"]
[239,"New Rpt - Parents Giving Summary","2000-02-15","2000-10-15","done","Jane, Camille","(MEDIUM) Dawn developed specs and submitted to ITS approx 2/23/ 10/19 Was approved-but may need modifications after meeting on 10/18"," "]
[240,"Funding Opport. Enhancement","2000-06-08","2000-11-30","done","JANE","(MEDIUM) Add count of open proposals and total ask amt by goal/division - waiting for Bergen signoff"]
[241,"Bridging Functionality","1999-05-01T08:00:00","2000-05-23T17:00:00",null,"Sharon,Dan Koepf,Felix"]
[242,"Student majors from UDB to Mill",null,"2000-02-03","Done","Sharon","requested by M. Zocco"]
[243,"Mill to UDB interface","1999-05-01T08:00:00","1999-06-03T12:00:00","Done","Sharon"]
[244,"SFIS to Mill Interface","1999-09-27T08:00:00","2000-07-31","done","Sharon, Glenn"]
[245,"SFIS to UDB for Duplicate Detect","1999-10-01","1999-11-15","done","Sharon, Glenn","Sharon began 12/13/99; production test began 1/11/00."]
[246,"Freshmen class & parents into Mill - new WesMill routine -- Maintain Incoming Student Parents",null,"2000-07-11","done","Barb, Deb, Jane","(HIGH) incorporate also alumn children who have applied and are not coming- not done for y'00."]
[247,"Student/alum Rollover Routine",null,"2000-07-11","done","Barb, Deb, Jane","(HIGH) wipe out campus addresses when students become alumni, assign name prefix based on gender"]
[248,"Feed Financial Aid info to Mill","2000-10-25","2000-12-04","done","Angela","(MEDIUM) indication of 'applied for' or 'received' as an Educ attribute- bulk attribute"]
[249,"Gift Receipts - Produce notification to donor when matching co. $ rec'd","2000-09-13","2000-12-07","Done","Felix, Andrea","(HIGH) requires new type of receipt to donor with new wording"]
[250,"Gift Receipts - suppress outstanding balance message","2000-09-18","2000-12-07","Done","Felix, Carol","(HIGH)  "]
[251,"Gift Receipts - change wording for holding accounts","2000-09-18","2000-12-07","Done","Felix, Carol","(HIGH)  chart_type=hldact, wording \"to The Wesleyan Campaign\""]
[252,"Gift Receipts - add the production of a Thank you form letter.","2000-09-18","2000-12-07","Done","Felix, Carol","(HIGH) request by C. Kosloski"]
[253,"Database","2000-06-01","2000-08-15"]
[254,"Oracle 8","2000-05-15","2000-08-09","done","S. Windsor, Jane, Chip","(HIGH) Move Millennium database to Oracle 8 on 8/9"]
[255,"Millennium tables to new schema","2000-09-01",null,"done","Jane, Steve W., Felix","(HIGH) Move Millennium tables out of the system schema."," "]
[256,"Wesleyan tables & software to new schema.","2000-09-01",null,"done","Jane, Steve W., Felix","(HIGH) Move Wesleyan tables & software out of the system schema."," "]
[257,"Implement Mill Release 7.0",null,"2000-10-16","Done","Jane, Steve W., Felix","(HIGH) dependent on Oracle 8 installation + schema changes"]