ActivityType Table

The ActivityType table stores information about the different kinds of activities that are available in the organization and provides a way to apply a set of rules to activities that have an activity type in common. This table has foreign key relationships with the Activity and GradeScale tables. The following illustration shows the column properties of the ActivityType table.

• The ActivityTypeId column is the primary key for an activity and it is an identity column.
• The GradeScaleId column is the foreign key that links the ActivityType table to the GradeScale table. Its data type is int because the foreign key relationship requires that the data types of related columns match.
• The Name column contains the name of the activity type that appears on the PT application Web pages.
• The Description column contains information that further describes and clarifies the purpose of the activity type. This information is used primarily to assist an evaluator in choosing the appropriate activity type to associate with an activity.
• The Weight column contains a numeric value that describes the relative influence of this activity type when calculating the average score for several activities. The default value for the Weight column is 1.
• The DropLowest column indicates how many activities of this activity type are excluded when calculating a person's aggregate score. The default value for the DropLowest column is 0.
• The LateType column contains a value that maps to a calculation that can adjust the RawScore by a late penalty. Options are the following: 0 (the default value means the RawScore has no late penalty), 1 (the LateValue is a percentage of the RawScore), 2 (the LateValue is a number of points), or 3 (the LateValue is a number of points for each day late, counting from the due date of the activity).
• The LateValue column contains the percentage, points, or points per day value that is associated with a LateType. The default value for the LateValue column is 0.