...
| Name | Description | System Data Type | Extract Data Type | ||
|---|---|---|---|---|---|
| item_id | Identifier of the ticket-specific details from APP_ITEM | BIGINT | Long Integer (4) | ||
| case_id | Case ID | BIGINT | Long Integer (4) | ||
| ticket_id | An ID identifying a ticket. | BIGINT | Long Integer (4) | ||
| ticket_status | Status of the ticket (New/Queued/Closed). | NVARCHAR (50) | Memo (-) | ||
| ticket_reason_code | Reason code for any action that is taken on the ticket which resulted in the state change. | NVARCHAR (50) | Memo (-) | ||
| modifieddatetext | Last modified ticket date in formatted value (DD/MM/YYYY). | - - | Date/Time (8) | ||
| createddatetext | Ticket created date. | - - | Date/Time (8) | ||
| modified_date | Last modified ticket date. | INT | Long Integer (4) | ||
| created_date | Date in milliseconds when the ticket is created. | INT | Long Integer (4) | ||
| ticket_priority | Ticket priority. | NVARCHAR (50) | Memo (-) | ||
| ticket_description | Ticket description. | NVARCHAR (256) | Memo (-) | ||
| created_by_group_name | Group ID of the creator group of the ticket. | NVARCHAR (50) | Memo (-) | ||
| created_by_name | Name of the ticket creator. | - - | Memo (-) | ||
| created_by_last_name | |||||
| createdbyname | Name of the ticket creator. | - - | Memo (-) | ||
| assigned_to group_name | Name of the group to whom ticket is assigned. | NVARCHAR (50) | Memo (-) | ||
| assigned_to_name | |||||
| assigned_to_last_name | |||||
| assignedtoindividual | Name of the individual to whom ticket is assigned. | - - | Memo (-) | ||
| modified_by_group_name | Last ticket modified group name. | NVARCHAR (50) | Memo (-) | ||
| modified_by_name | Last ticket modified. | - - | Memo (-) | ||
| modified_by_last_name | |||||
| modifiedbyname | Last ticket modified. | - - | Memo (-) | ||
| person1_e_mail | Requester's email. | NVARCHAR (126) | Memo (-) | ||
| person1_first_name | |||||
| person1_last_name | |||||
| requester | Requester's name. | BIGINT | Memo (-) | ||
| person1_job_title | |||||
| person1_phone1 | |||||
| person1_org_name | |||||
| person1_hierarchical_path | |||||
| person2_e_mail | |||||
| person2_first_name | |||||
| person2_last_name | |||||
| requester2 | |||||
| person2_job_title | |||||
| person2_phone1 | |||||
| person2_org_name | |||||
| person2_hierarchical_path | |||||
| ccti_id | |||||
| ccti_class | |||||
| ccti_category | |||||
| ccti_type | |||||
| ccti_item | |||||
| person1_alt_phone | |||||
| person1_alt_email | |||||
| ticket_solution_id | |||||
| person2_alt_phone | |||||
| person2_alt_email | |||||
| description_long | |||||
| task_name | |||||
| task_type | |||||
| actual_start_date | |||||
| actual_end_date | |||||
| parent_description | |||||
| parent_item_id | |||||
| parent_ticket_type | |||||
| created_by_contact_id | |||||
| assigned_to_contact_id | |||||
| modified_by_contact_id | |||||
| person1_contact_id | |||||
| person2_contact_id | |||||
| affected_service | |||||
| ticket_phase | |||||
| ticket_source | |||||
| ticket_impact | |||||
| ticket_urgency | |||||
| planned_start_date | |||||
| planned_end_date | |||||
| planned_duration | |||||
| planned_start_datetext | |||||
| planned_end_datetext | |||||
| actual_duration | |||||
| actual_start_datetext | |||||
| actual_end_datetext | |||||
| archived_data |
...