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.

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