TS Database
The following describes the fields in the TS (Issues) database.
| Field | Contents | Description |
|---|---|---|
| ARCHIVE | Logical | Indicates if the issue is being archived |
| ASSIGNEDTO | 22 characters | The user the issue is assigned to |
| CLEARED | 1 character | Indicates if the issue was cleared |
| CLEAREDBY | 22 characters | The user who cleared the issue |
| CLEAREDON | 14 characters | The date and time the issue was cleared on |
| COMPLETEBY | 22 characters | The user who completed the issue |
| COMPLETEON | 14 characters | The date and time the issue was completed on |
| CREATEDBY | 22 characters | The user who created the issue |
| CREATEDON | 14 characters | The date and time the issue was created |
| CWDATED | 14 characters | The date and time the description was modified on |
| CWDATER | 14 characters | The date and time the resolution was modified on |
| CWGUID | 22 characters | Issue identifier |
| DESC | Memo field, 10 characters | Issue description |
| DOCID | 22 characters | Document identifier |
| DUEON | 14 characters | The date and time the issue is due on |
| EXINFO | Memo field, 10 characters | Extended information about the issue |
| FIELD | 64 characters | Not used |
| FILEID | 22 characters | File identifier |
| HISTORYCOM | 22 characters | Indicates if the history was completed |
| HISTORYCRE | 22 characters | Indicates the history events created |
| ID | 12 characters | Issue number |
| MODIFIEDON | 14 characters | The date and time the issue was modified |
| OBJECTID | 128 characters | Object identifier |
| OBJECTTYPE | 2 characters | Object type |
| PERCENT | 3 characters | Issue completion percentage |
| PRIORITY | 1 character | Issue priority |
| REMINDED | 14 characters | Not used |
| REMINDER | 14 characters | Issue reminder |
| RESOLUTION | Memo field, 10 characters | Issue resolution |
| ROLL | Logical | Indicates if the issue is being rolled forward |
| STARTON | 14 characters | The date and time the issue started on |
| STATUS | 1 character | Issue status |
| SUBJECT | 254 characters | Issue subject |
| TYPE | 2 characters | Issue type |
