User Tools

Site Tools


middleware:devel:ed:docs:project-plan

Enterprise Directory Project Plan

Non-Deployment Tasks

Password Retrieval Test

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

Shared E-mail

Task Name Finish % Complete Resources
Move group email DPids to eaddresses table 12/01/06 0% kevinb

Departmental PIDs

Task Name Finish % Complete Resources
Analysis and review of DPID uses from survey, other sources 0% IRM,ED Policy

Previous VT IDs

Task Name Finish % Complete Resources
Remove data from VTUSERIDS and VTUSERID_TYPES 04/15/06 0% kevinb

Stale Pre-Hires

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

Archive Triggers

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

VCOM Import Tool

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

Registry Data Cleanup

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

SQL Queries

  • 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

Bring Directories back into EduPerson compliance

Task Name Finish % Complete Resources
Evaluate EduPerson spec 200604 12/31/06 0% M, IRM
Known Discreptancies
  • eduPersonAffiliation is no longer open ended
  • eduPerson objectclass no longer includes inetOrgPerson

June 2007 Deployment

New E-mail functionality

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

PIDGen Rewrite

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

DAT Updates

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

Namearbiter Updates

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

August 2007 Deployment

ED Groups (Phase 1 beta 2)

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

New E-mail functionality

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

Registry Replication

Task Name Finish % Complete Resources
Review Registry Triggers, move functionality to registry-manage package 50% dhawes

DAT Updates

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

Registry Replication

Task Name Finish % Complete Resources
Add replication interface to the DAT (view Q size, enqueue single and multiple records 0% brianx

Future Deployment

Registry to Banner Replication

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

Design of Registry Degrees and Jobs

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

End Of Life Registry PL/SQL

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

Person Type Code Cleanup

Task Name Finish % Complete Resources
Change RUID and UID type codes to RVK and PRM 0% IRM
Update types class 0% M

ED-Lite Visibility

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

AD Deprovisioning

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

DAT Updates

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

Feature Requests

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

New Registry Address Type

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

Registry Schema Cleanup

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

ED-ID Data Views

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

Self-service password reset

Task Name Finish % Complete Resources
Gather requirements and set priority 0% IRM

Signet Privilege Management Authority

Task Name Finish % Complete Resources
Research privilege management 0%
Look at service provisioning needs that do not fit the PID account lifecycle 0%
middleware/devel/ed/docs/project-plan.txt · Last modified: 2015/06/01 12:02 (external edit)