| 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 |
- 0
- Open
- -1
- Inactive
- Unassigned
- 1
- Closed
- 2
- Reopened
|
| 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 |
