User Tools

Site Tools


middleware:devel:ed:docs:dpid-transitions

DPID Transitions

Author Daniel Fisher
Date 2007/03/21

Introduction

The purpose of this document is to outline all the steps needed to transition departmental PIDs to supported infrastructure.

DPID Transition Scenerios

For the following instructions, fields that are surrounded by '#' should be replaced with actual data values.
All other fields should entered as displayed.
It is assumed you know the UID of the person to whom you are moving the DPID.

Move DPID with mail account to PID

Person can not already have a PID

  1. lookup DPID_UID:
    select dpid_temp_seqno from vtregistry.dpid_temp where uupid = '#DPID#'
  2. delete DPID records:
    delete from vtregistry.dpid_temp, vtregistry.dpid_eaddresses where dpid_temp_seqno = #DPID_TEMP_SEQNO#
  3. assign the new pid :
    insert into vtregistry.vtuserids (VTUSERID_SEQNO, VTPEOPLE_SEQNO, USERID_TYPE_CODE, USERID, CREATED_DATE, CREATED_BY, AUP_ACCEPTED, USTATUS_TYPE_CODE, UTRANSITION_TYPE_CODE) values (vtregistry.edreg_vtuserid_seq.nextval, #PERSON_UID#, 'PID', '#DPID#',sysdate, 'DPID TRANSITION', 0, 'ACT', 'UAD')
  4. assign the new email account:
    insert into vtregistry.vtpeople_eaddresses (VTPEOPLE_EADDR_SEQNO, VTPEOPLE_SEQNO, EADDR_TYPE_CODE, EADDRESS, PREFERRED_FLAG, CREATED_DATE, CREATED_BY, MAX_ALIASES, DELETED_STATE_FLAG) values (vtregistry.edreg_eaddress_seq.nextval, #PERSON_UID#, 'VE', '#DPID#@vt.edu', 1, sysdate, 'DPID TRANSITION', 3, 0)
  5. send Dave Hawes a note to delete the DPID from the LDAP
  6. send Cathy Winfrey a note to move the email account to the new UID
  7. perform password reset for the person

Move DPID with mail account to Forward-only E-mail Account

  1. lookup DPID_UID:
    select dpid_temp_seqno from vtregistry.dpid_temp where uupid = '#DPID#'
  2. delete DPID records:
    delete from vtregistry.dpid_temp, vtregistry.dpid_eaddresses where dpid_temp_seqno = #DPID_TEMP_SEQNO#
  3. assign the new email account:
    insert into VTREGISTRY.VTEMAIL_ACCOUNTS (VTEMAIL_ACCOUNT_SEQNO, VTPEOPLE_SEQNO, EMAIL_ACCOUNT_TYPE_CODE, UUMID, MAX_ALIASES, MAX_FORWARDS, DELETED_STATE_FLAG, JMM_STATUS, LOCAL_DELIVERY, CREATED_BY, CREATED_DATE) values (vtregistry.edreg_eaddress_seq.nextval, ###PERSON_UID###, 'FE', '###DPID###', 3, 1, 0, 0, 0, 'DPID TRANSITION', sysdate)
    insert into VTREGISTRY.VTEMAIL_ADDRESSES (VTEMAIL_ADDRESS_SEQNO, VTEMAIL_ACCOUNT_SEQNO, EMAIL_ADDRESS_TYPE_CODE, EMAIL_ADDRESS, PREFERRED_FLAG, CREATED_BY, CREATED_DATE) values (vtregistry.edreg_vtemail_addresses_seq.nextval, ###ACCOUNT_UID###, 'PRI', '###DPID###@vt.edu', 1, 'DPID TRANSITION', sysdate)
  4. send Dave Hawes a note to delete the DPID from the LDAP
  5. login to the DAT and set the forward for the new e-mail account

Move DPID with mail account to E-mail Alias

  1. lookup DPID_UID:
    select dpid_temp_seqno from vtregistry.dpid_temp where uupid = '#DPID#'
  2. delete DPID records:
    delete from vtregistry.dpid_temp, vtregistry.dpid_eaddresses where dpid_temp_seqno = #DPID_TEMP_SEQNO#
  3. send Dave Hawes a note to delete the DPID from the LDAP
  4. send Cathy Winfrey a note to move the email account to deleted state
    • the account will be deleted in approximately 32 days, the alias will not be available until that time
      • the alias cannot be assigned while the account is in deleted state, it will result in bounced mail
      • the mail team cannot delete the account immmediately unless it has *always* been forwarded
    • do not proceed until the account has been deleted
  5. lookup e-mail account seqno:
    select vtpeople_eaddr_seqno from vtregistry.vtpeople_eaddresses where vtpeople_seqno = #PERSON_UID# and eaddr_type_code = 'VE'
  6. assign the new email alias:
    insert into vtregistry.vtpeople_eaddresses (VTPEOPLE_EADDR_SEQNO, VTPEOPLE_SEQNO, EADDR_TYPE_CODE, EADDRESS, PREFERRED_FLAG, ACCOUNT_EADDR, CREATED_DATE, CREATED_BY, MAX_ALIASES, DELETED_STATE_FLAG) values (vtregistry.edreg_eaddress_seq.nextval, #PERSON_UID#, 'VEA', '#DPID#@vt.edu', 0, #VTPEOPLE_EADDR_SEQNO#, sysdate, 'DPID TRANSITION', 3, 0)

Comments

middleware/devel/ed/docs/dpid-transitions.txt · Last modified: 2015/06/01 12:02 (external edit)