ticket Table (Ticket)
| Name | Description |
|---|---|
| number | |
| generation | |
| empl | |
| lastmodempl | |
| subject | |
| originator | Who authored the data for the ticket. |
| entdate | |
| enttime | |
| user | user.number - deprecated |
| reference | The number of the record from the fromtable table. |
| queue | queue.number |
| state |
|
| priority |
Calculated from the queue problems and automatically updated if Service Level Agreement in effect. |
| assignedto | auth.number |
| problem | Populated from the queue problems |
| resolution | Populated from the problem resolutions |
| lastactdate | Date of last activity for the ticket. |
| lastacttime | Time of last activity for the ticket. |
| misc01 | |
| misc02 | |
| misc03 | |
| misc04 | |
| misc05 | |
| misc06 | |
| misc07 | |
| misc08 | |
| misc09 | |
| misc10 | |
| externalid | Used to populate reference to third party system. |
| fromtable | table to which the ticket is attached |