Last Update: July 14, 2015 |
These tables pertain to the CallTrack program.
CallCenterCategories—Holds the codes and descriptions set up on the Categories dialog.
CallCenterCommonProbs—Holds the codes and descriptions set up on the Common Problem List dialog.
CallCenterDepartments—Holds the codes and descriptions set up on the Departments dialog.
CallCenterEquipment—Holds equipment selected for each election on the Maintain Equipment List dialog.
CallCenterEquipmentTypes—Holds and codes and descriptions set up on the Equipment Types Maintenance dialog.
CallCenterPriorities—Holds the codes and descriptions of items in the Priority drop-down list on the CallTrack Calls tab and the New Call dialog.
Election_Number |
Election in which the call was created. |
Call_Number |
Unique system-assigned number for the call. |
Creation_Date |
Timestamp when call was created. |
Last_Date_Changed |
Timestamp of last change to call record. |
Precinct |
The place (polling place, early voting site, or election center) associated with the call. |
LocationType |
Place type of the place related to the call. |
Operator_Created |
User who created the call record. |
Reported_By |
Caller who reported call to call center. |
Category |
Category assigned to the call from the CallCenterCategories table. |
Priority |
Priority assigned to the call from the CallCenterPriorites table. |
Department |
Department assigned to the call from the CallCenterDepartments table. |
Status |
Status of the call: O—Open P—Pending R—Resolved |
Last_Comment_Date |
Timestamp of last entry in comments fields on CallTrack Calls tab and New Call dialog. |
Equipment_Type |
The equipment type code from the CallCenterEquipment table. |
Serial_Number |
The serial number of the equipment related to the call. |
Election_Number |
Election in which the call was created. |
Call_Number |
Unique system-assigned number for the call. |
Creation_Date |
Timestamp when call was created. |
Comment_Type |
Code indicating whether the comment is: P—The initial comment entered in the Problem Description field on the New Call dialog. C—Subsequent comments entered in the Notes about Problem Resolution field on the New Call dialog or Enter New Comment field on the CallTrack Calls tab. |
Comment |
The text of the comment referenced in Comment_Type. |
Operator |
The user who created the call record. |