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.