Use of Tables with SSN

How to Handle Sensitive Information

• 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.