Body
Who is Eligible?
Active Faculty or Staff
• Be mindful of tables with Social Security Numbers and other Sensitive Information. In many instances there are Views that reference a Table without the Sensitive Information.
Social Security Numbers vs No Social Security Numbers
UHR has implemented new Views to support staff that does not need access to Social Security Numbers. The Views are exact duplicates of the normal tables/views except the SSN field is blank. This allows developers/query members to still use the similar table without access to SSN data.
Affected Tables & Views and replacement View
-
|
Affected Tables & Views and replacement View
|
|
Affected Table
|
==>
|
New Replacement View
|
|
SPBPERS (contains SSN)
|
==>
|
SOUOA_SPBPERS_NOSSN
|
|
PXRW2SS
|
==>
|
POUOA_PXRW2SS_NOSSN
|
|
PERDEMO
|
==>
|
POUOA_PERDEMO_NOSSN
|
|
PERASGN
|
==>
|
POUOA_PERASGN_NOSSN
|
|
PDRBENE
|
==>
|
POUOA_PDRBENE_NOSSN
|
|
PDRBEHS
|
==>
|
POUOA_PDRBEHS_NOSSN
|
Note: As we learn more about the Evisions Argos product, these standards and best practices will grow and be revised to suit our environment more closely.
Additional Support
- OU Technology Center
- 44 Oakland Center
- Rochester, MI 48309-4479
- (248) 370-4357
- Office Hours: M-F 8:00am - 5:00pm