2.4. Documenting the Site Survey
Because of the complexity of data design, document the results of the site surveys. Each step of the site survey can use simple tables to track data. Consider building a supplier table that outlines the decisions and outstanding concerns. A good tip is to use a spreadsheet so that the table's contents can easily be sorted and searched.
Table 2.4, “Example: Tabulating Data Ownership and Access” identifies data ownership and data access for each piece of data identified by the site survey.
Table 2.4. Example: Tabulating Data Ownership and Access
Data Name | Owner | Supplier Server/Application | Self Read/Write | Global Read | HR Writable | IS Writable |
---|---|---|---|---|---|---|
Employee name | HR | PeopleSoft | Read-only | Yes (anonymous) | Yes | Yes |
User password | IS | Directory US-1 | Read/Write | No | No | Yes |
Home phone number | HR | PeopleSoft | Read/Write | No | Yes | No |
Employee location | IS | Directory US-1 | Read-only | Yes (must log in) | No | Yes |
Office phone number | Facilities | Phone switch | Read-only | Yes (anonymous) | No | No |
Each row in the table shows what kind of information is being assessed, what departments have an interest in it, and how the information is used and accessed. For example, on the first row, the employee names data have the following management considerations:
- Owner. Human Resources owns this information and therefore is responsible for updating and changing it.
- Supplier Server/Application. The PeopleSoft application manages employee name information.
- Self Read/Write. A person can read his own name but not write (or change) it.
- Global Read. Employee names can be read anonymously by everyone with access to the directory.
- HR Writable. Members of the human resources group can change, add, and delete employee names in the directory.
- IS Writable. Members of the information services group can change, add, and delete employee names in the directory.