| 50 | | # email summary of changes to sdedirregistry@email.alaska.edu |
| 51 | | |
| 52 | | # changes are listed in ldap_RPTS_dept_<date>.changes file |
| 53 | | cd $HOME/local/ldap/extracts/ |
| 54 | | ls -lrt *dept*changes|tail -1 # check date/time stamp |
| 55 | | awk '{print $1}' $(ls -1rt *dept*changes|tail -1)|sort |uniq -c |
| 56 | | |
| 57 | | # compare EDIR structure to BOR structure and send |
| 58 | | # email to Budget Offices soliciting response to unit changes |
| 59 | | |
| 60 | | cd $HOME/local/ldap/query |
| 61 | | sqlplus / |
| 62 | | @compare_edir_structure_to_bor.sql |
| 63 | | exit |
| 64 | | |
| 65 | | # copy and paste screen output to email for budget offices |
| 66 | | # with request for feedback |
| 67 | | Recipients: Phil Harrington <plharrington@alaska.edu>, Lynn Wrightsman <lawrightsman@alaska.edu>, Barbara Hyde <bjhyde@uas.alaska.edu> |
| 68 | | CC: to !ua-oit-registry@alaska.edu |
| 69 | | |
| 70 | | # if the budget office respond with feedback |
| 71 | | # then |
| 72 | | # move EDIR data to new unit records if applicable |
| | 50 | 1. Email summary of changes to sdedirregistry@email.alaska.edu |
| | 51 | * Changes are listed in ldap_RPTS_dept_<date>.changes file |
| | 52 | * cd $HOME/local/ldap/extracts/ |
| | 53 | * ls -lrt *dept*changes|tail -1 # check date/time stamp |
| | 54 | * awk '{print $1}' $(ls -1rt *dept*changes|tail -1)|sort |uniq -c |
| | 55 | 1. Compare EDIR structure to BOR structure and send |
| | 56 | 1. Email to Budget Offices soliciting response to unit changes |
| | 57 | * cd $HOME/local/ldap/query |
| | 58 | * sqlplus / |
| | 59 | * @compare_edir_structure_to_bor.sql |
| | 60 | * exit |
| | 61 | * copy and paste screen output to email for budget offices with request for feedback |
| | 62 | * Recipients: Phil Harrington <plharrington@alaska.edu>, Lynn Wrightsman <lawrightsman@alaska.edu>, Barbara Hyde <bjhyde@uas.alaska.edu> |
| | 63 | * CC: to !ua-oit-registry@alaska.edu |
| | 64 | * If the budget office respond with feedback |
| | 65 | * move EDIR data to new unit records if applicable |
| 74 | | |
| 75 | | # flag to keep, or delete, old unit records if applicable |
| 76 | | (TBD - see beth in meantime) |
| 77 | | |
| 78 | | # Note: No EDIR unit record will be dropped from EDIR unless flagged |
| 79 | | # in the EDIR_STRUCTURE table. This allows EDIR to reflect units w/o |
| 80 | | # budget that are **not** retained in the BOR structure table. |
| 81 | | |
| 82 | | # notify sdtsaa of new/obsolete EDIRroles (associated with unit changes) |
| 83 | | # NOTE: run show scripts before running add/delete scripts in next step |
| 84 | | |
| 85 | | # first generate list of new and obsolete edir unit related roles |
| 86 | | # send 2 emails to sdtsaa; one with needed one with obsolete |
| | 67 | * flag to keep, or delete, old unit records if applicable |
| | 68 | (TBD - see beth in meantime) |
| | 69 | * ''Note:'' No EDIR unit record will be dropped from EDIR unless flagged |
| | 70 | * in the EDIR_STRUCTURE table. This allows EDIR to reflect units w/o |
| | 71 | * budget that are **not** retained in the BOR structure table. |
| | 72 | 1. Notify sdtsaa of new/obsolete EDIRroles (associated with unit changes) |
| | 73 | * First generate a list of new and obsolete EDIR unit related roles |
| | 74 | {{{ |