The TICKETACTIVITY table stores detailed information on all support activities, such as On-site consulting, associated with tickets. An activity is an action or event that occurs during the processing and resolution of a ticket. This includes any process, action, step, or work done by a customer service representative or technical service representative to help solve a customers problem or resolve a reported defect. The information stored in this table includes the TicketID, rate type description associated to the ticket, activity type code, due date, assigned date, completed date, and other details.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
TICKETACTIVITYID (PK) |
STANDARDID(12) |
NOT NULL |
TICKETACTIVITY_TICKETACTIVITYID_PK (AK) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
TICKETID (FK) |
STANDARDID(12) |
NOT NULL |
TICKETACTIVITY_TICKETID (CA) |
(Many) to (One) |
|
|
RATETYPEDESC (FK) |
varchar(80) |
NULLS |
|
(Many) to (One) |
|
|
ACTIVITYTYPECODE |
STANDARDID(12) |
NULLS |
|
|
|
|
USERID (FK) |
STANDARDID(12) |
NULLS |
TICKETACTIVITY_USERID (IE) |
(Many) to (One) |
|
|
DATEDUE |
datetime(8) |
NULLS |
|
|
|
|
UNITS |
float(8) |
NULLS |
|
|
|
|
SHORTDESC |
varchar(255) |
NULLS |
|
|
|
|
ELAPSEDUNITS |
float(8) |
NULLS |
|
|
|
|
ASSIGNEDDATE |
datetime(8) |
NULLS |
|
|
|
|
COMPLETEDDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
USERFIELD1 |
varchar(80) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
USERFIELD2 |
varchar(80) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
USERFIELD3 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD4 |
varchar(80) |
NULLS |
|
|
|
|
ACTIVITYDESC |
TEXTBLOB(16) |
NULLS |
|
|
|
|
USERFIELD5 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD6 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD7 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD8 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD9 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD10 |
varchar(80) |
NULLS |
|
|
|
|
FOLLOWUP |
BOOLEAN(1) |
NULLS |
|
|
|
|
TOTALLABOR |
float(8) |
NULLS |
|
|
|
|
TOTALPARTS |
float(8) |
NULLS |
|
|
|
|
TOTALFEE |
float(8) |
NULLS |
|
|
|
|
RATE |
float(8) |
NULLS |
|
|
|
|
PUBLICACCESSCODE |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|