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 | {{{ |