...
New view (CU_PERSONAL_DATA) containing similar data to that provided in PERSONAL_DATA which will not require NPI access and include a few additional details.
DOB in month/day format (no year), last four of SSN (if exists), campus email (if exists). Any sensitive HR/payroll data would not be included.
...
Currently, it order to obtain personal information for a student, several tables must be joined into the query. The name is in one table, the address is in another, campus email is in another (with an outer join, as it may not exist), sex is in another, military status is in another. This makes for complicated queries which stresses the system unnecessarily. Also, it makes the task of writing simple queries more cumbersome, especially for the novice query writer and other non tech query writer as well. This new view would ease the process for obtaining a student's personal data - it would be in one view. In addition, modification of queries in future will be much simpler for query writers as well.
Proposed SQL or other technical documentation
...