Erv has said we do not need to store decryptable passwords
| Task Name | Finish | % Complete | Resources |
| Destroy private key | | 0% | dunker, wdonald |
| Destroy passphrase | | 100% | dunker |
| Update PaswordChange code to no longer store decryptable passwords | | 100% | M |
| Destroy decryptable passwords in the Registry | | 0% | IRM |
| Document what was done and why | | 0% | IRM |
| Task Name | Finish | % Complete | Resources |
| Move group email DPids to eaddresses table | 12/01/06 | 0% | kevinb |
| Task Name | Finish | % Complete | Resources |
| Analysis and review of DPID uses from survey, other sources | | 0% | IRM,ED Policy |
| Task Name | Finish | % Complete | Resources |
| Remove data from VTUSERIDS and VTUSERID_TYPES | 04/15/06 | 0% | kevinb |
| Task Name | Finish | % Complete | Resources |
| Create new affiliation for people who never complete orientation (VT-PRE-HIRE-FORMER) | 04/30/06 | 0% | kevinb |
| Update data in VTAFFILIATIONS | 04/30/06 | 0% | kevinb |
| Send Marc Debonis a list of modified uids and uupids | 04/30/06 | 0% | kevinb |
| Task Name | Finish | % Complete | Resources |
| Determine if archiving is wanted/needed | 06/30/06 | 0% | IRM |
| If archiving, then determine if full or partial archiving is wanted/needed | 06/30/06 | 0% | IRM |
| Task Name | Finish | % Complete | Resources |
| IRM is rewriting as Banner app | 07/15/06 | 0% | IRM |
| Retire current vcom-import webapp (remove from svn trunk) | 08/30/06 | 0% | M |
| Task Name | Finish | % Complete | Resources |
| Remove duplicate e-mail forwards | 10/15/06 | 0% | IRM |
| Remove duplicate UUPIDs | 10/15/06 | 0% | IRM |
| Remove duplicate IDs | 10/15/06 | 0% | IRM |
| Remove duplicate people | 12/15/06 | 0% | IRM |
To find duplicate e-mail forwards:
select * from vtregistry.vtpeople_eaddresses a, vtregistry.vtpeople_eaddresses b where
a.vtpeople_seqno = b.vtpeople_seqno and a.eaddr_type_code = 'VEF' and b.eaddr_type_code = 'VEF' and a.vtpeople_eaddr_seqno != b.vtpeople_eaddr_seqno
To find duplicate UUPIDs:
select * from vtregistry.vtuserids a, vtregistry.vtuserids b where
a.vtpeople_seqno = b.vtpeople_seqno and a.userid_type_code = 'PID' and b.userid_type_code = 'PID' and a.vtuserid_seqno != b.vtuserid_seqno
To find duplicate IDs:
select * from vtregistry.vtuserids a, vtregistry.vtuserids b where
a.userid = b.userid and a.userid_type_code = b.userid_type_code and a.vtuserid_seqno != b.vtuserid_seqno
| Task Name | Finish | % Complete | Resources |
| Evaluate EduPerson spec 200604 | 12/31/06 | 0% | M, IRM |
| Task Name | Finish | % Complete | Resources |
| Add ability to set/unset junk mail tracking (JMM_STATUS) | | 100% | M |
| Update mail-repl to set junk mail attributes | | 100% | cwinfrey |
| Update mail-repl to ignore mail accounts in deleted state | | 100% | cwinfrey |
| Update mail-repl to stop sanity check on UID to allow moving mail accounts | | 100% | cwinfrey |
| Update 'My Profile' to accomodate junk mail tracking (Will not occur in production until later) | | 0% | CTU |
| Rename group email type to forward only type | | 100% | M |
| Task Name | Finish | % Complete | Resources |
| Schedule meeting with Ken McCrery concerning new web interface | | 100% | CTU,dunker |
| Analysis: Should we continue to use Banner for authentication [YES] | | 100% | IRM,M |
| Develop new PIDGen web interface | 01/30/07 | 95% | CTU,IRM,M |
| Convert existing pidgen webapp to web services | 01/30/07 | 100% | M |
| Remove lastname from generated PID suggestions, now using firstname with lastname initial | 01/30/07 | 100% | M |
| Retiree mdsAuth and current pidgen webapp, we may do parallel in production for a brief period | 03/01/07 | 0% | CTU,M |
| Task Name | Finish | % Complete | Resources |
| DAT integration with CAS (requested by Carl Harris) | | 100% | dhawes |
| Wiki links for each tile, to allow inline documentation, uses CAS to wiki | | 100% | brianx |
| Ability to view group membership on DAT id info page (requested by Rhonda Randel) | | 100% | brianx |
| Email management should add '@vt.edu' to eaddresses (max alias length should be 32 ala my.vt) (requested by Rhonda Randel) | | 100% | brianx |
| Person create confirm page doesn't show responsible pid | | 100% | brianx |
| Don't allow e-mail accounts in deleted state to be modified | | 100% | brianx |
| Add transition state to the PID info tile | | 100% | brianx |
| Task Name | Finish | % Complete | Resources |
| Flaten temporary reservation namespace, refactor namearbiter to improve performance | | 100% | cwinfrey |
| Add interface to control Namearbiter reservations in the DAT | | 0% | cwinfrey |
| Task Name | Finish | % Complete | Resources |
| Update ED Ldap libs to work with groups | 03/01/06 | 100% | dfisher |
| Develop groups admin interface | 10/30/06 | 100% | CTU |
| Task Name | Finish | % Complete | Resources |
| Refactor eaddresses table | | 0% | M, IRM |
| Add ability for all e-mail accounts to set multiple forwards | | 0% | M |
| Update 'My Profile' to accomodate multiple forwards | | 0% | CTU |
| Add ability for administrative setting of both forward and local mail delivery | | 0% | M |
| Task Name | Finish | % Complete | Resources |
| Review Registry Triggers, move functionality to registry-manage package | | 50% | dhawes |
| Task Name | Finish | % Complete | Resources |
| Stop using DTO objects, use DSML instead (XSL transforms?) | | 0% | brianx |
| Ability to add a person to a group on creation in DAT (requested by Rhonda Randel) | | 0% | brianx |
| Task Name | Finish | % Complete | Resources |
| Add replication interface to the DAT (view Q size, enqueue single and multiple records | | 0% | brianx |
| Task Name | Finish | % Complete | Resources |
| Review existing PL/SQL used to write to Oracle AQ | | 0% | IRM,brianx |
| Develop JBoss message based SAR that performs PL/SQL tasks | | 50% | brianx |
| Disable Banner Update Triggers | | 0% | IRM |
tenative for this deploy as the complexity of the changes are still unknown
| Task Name | Finish | % Complete | Resources |
| Design LDAP schema branches for degrees and jobs | | 0% | dhawes |
| Verify the Registry has all the Banner data it needs, update Registry schema as necessary | | 0% | M,IRM |
| Update Registry replication to accomodate new data | | 0% | dhawes |
| Task Name | Finish | % Complete | Resources |
| Review Registry to CNS updates, move replication to clients-repl package | | 0% | IRM,dhawes |
| Review Registry to non VT updates, move replication to clients-repl package | | 0% | IRM,dhawes |
| Task Name | Finish | % Complete | Resources |
| Change RUID and UID type codes to RVK and PRM | | 0% | IRM |
| Update types class | | 0% | M |
| Task Name | Finish | % Complete | Resources |
| Add new attribute to directory schema to expose the new flag | | 0% | M |
| Update personquery to add new flag to person DSML | | 0% | M |
| Reload directories with new field | | 0% | M |
| Stop using ACTIVE-MEMBER as visibility key, start using new attribute in directory ACLs | | 0% | dhawes |
| Task Name | Finish | % Complete | Resources |
| Determine rules for deprovisioning | | 0% | MIG |
| Set prehire-former affiliation in Banner to Registry replication | | 0% | IRM |
| Add PID accountState, VT-EMPLOYEE-FORMER, and VT-EMPLOYEE-PREHIRE-FORMER to replication stream | | 0% | M |
| Task Name | Finish | % Complete | Resources |
| Add person to group based on UID | | 0% | M |
| Service viewable attribute management in DAT needs overhaul (requested by Rhonda Randel) | | 100% | M |
| Batch creation process for revokable people in the DAT (requested by IRM) | | 0% | M |
| DAT view authorization for people searching (requested by Karen Herrington) | | 0% | M |
| Task Name | Finish | % Complete | Resources |
| Namearbiter override (requested by Karen Herrington) | | 0% | M |
| Ability to create test people in all instances of the Registry (requested by Kim Homer) | | 0% | M |
| Ability to lock mail accounts separate from PIDs (requested by Dave Martin) | | 0% | M |
| Ability to track who reset a user's password (requested by IRM) | | 0% | M |
| Task Name | Finish | % Complete | Resources |
| Investigate mapping all 4 Banner address types to Registry address types | | 0% | M, IRM |
IRM has indicated they do not want this functinality
| Task Name | Finish | % Complete | Resources |
| Update Banner side PL/SQL to publish person delete message | | 0% | IRM |
| Update Registry side listener to process person delete message | | 0% | M |
| Task Name | Finish | % Complete | Resources |
| Refactor eaddress and userids table | | 0% | M,IRM |
| Finialize table naming and update any non-compliant tables | | 0% | M,IRM |
| Task Name | Finish | % Complete | Resources |
| Finalize LDAP ACLs | | 0% | M |
| Add options to DAT service management interface | | 0% | M |
| Task Name | Finish | % Complete | Resources |
| Susan Brooker-Gross will advise on the future of this project | | 0% | ED Policy |
| Task Name | Finish | % Complete | Resources |
| Consult with new alumni head | | 0% | IRM |
| Analysis: Can we/Should we integrate the alumni data in the Registry | | 0% | IRM |
| Develop requirements based on analysis, do we need more machines? | | 0% | M |
| Task Name | Finish | % Complete | Resources |
| Gather requirements and set priority | | 0% | IRM |
| Task Name | Finish | % Complete | Resources |
| Research privilege management | | 0% | |
| Look at service provisioning needs that do not fit the PID account lifecycle | | 0% | |
