Person Table
The Person table stores information related to users (individuals, evaluators, and auditors) of the PT User application. A person must have a record in the Person and Logon tables before the PT User application allows that person access to the application's Web pages. Administrators using the PT Admin application need not have a record in the Person table. Security in the PT Admin Application describes how administrators are authenticated. This table has foreign key relationships with the PersonGroup and PersonActivity tables. The following illustration shows the column properties of the Person table.
- The PersonId column is the primary key for a person and it is an identity column.
- The StudentId column is an alternate identifier for a person. All values in this column must be unique but an entry is not required.
- The FirstName and LastName columns contain the first name and last name of an individual, evaluator, or auditor. The data type of these columns is nvarchar to allow entry of characters from all character sets.
- The Email column contains the e-mail address for a person and has an nvarchar data type. Entry in this column is optional (Allow Nulls is checked) because not all persons have e-mail addresses.
- The Street, City, Region, PostalCode, and Country columns make up the address for an individual, evaluator, or auditor. These optional fields contain character data and have an nvarchar data type.
- The Phone column contains the telephone number for an individual, evaluator, or auditor.
- The Contact and ContactPhone columns contain the name and telephone number of the person to contact (in case of an emergency, for example). The contact person is not an auditor and has no privileges to view or modify application data.
- The ContactRelationship column describes how the person in the Contact column is related to the person in the record.
- The ReleaseInfo column contains a 13-character bit pattern (zeros and ones) with one bit for each column of the Person table except for the PersonId (which is an identity column that has no meaning outside the database structure); the Password column; and the ReleaseInfo column itself. Position one in the string refers to the FirstName column, position two to the LastName column, and so on. A value of 1 indicates information in the column can be released and a 0 indicates the information is not available for display on some of the PT application's Web pages; for example, if an individual chooses to release only his or her first and last name, the ReleaseInfo column contains the string "0110000000000". The following table illustrates how this string is derived.
# |
Column |
Release data |
Bit value |
1 |
StudentId |
No |
0 |
2 |
FirstName |
Yes |
1 |
3 |
LastName |
Yes |
1 |
4 |
Email |
No |
0 |
5 |
Street |
No |
0 |
6 |
City |
No |
0 |
7 |
Region |
No |
0 |
8 |
PostalCode |
No |
0 |
9 |
Country |
No |
0 |
10 |
Phone |
No |
0 |
11 |
Contact |
No |
0 |
12 |
ContactPhone |
No |
0 |
13 |
ContactRelationship |
No |
0 |
Note For security reasons, two pieces of information (password and user name) for a person are not stored in the Person table. A separate table, the Logon table, contains this data.