The following entities are present in the DTX extracts:
...
| 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 Status of the ticket (New/Queued/Closed) | NVARCHAR(50) | Memo (-) |
| ticket_reason_code | Reason Reason code for any action that is taken on the ticket which resulted in the state change. | NVARCHAR(50) | Memo (-) |
| modifieddatetext | Last Last Modified Ticket Date in formatted value (DD/MM/YYYY) | - - | Date/Time (8) |
| createddatetext | Ticket Ticket Created Date | - - | Date/Time (8) |
| modified_date | Last Last Modified Ticket Date | INT | Long Integer (4) |
| ticket_priority | Ticket Ticket Priority | NVARCHAR (50) | Memo (-) |
| ticket_description | Ticket Ticket Description | NVARCHAR (256) | Memo (-) |
| created_by_group_name | Group Group ID of the creator group of the ticket | NVARCHAR (50) | Memo (-) |
| created_by_name | |||
| created_by_last_name | |||
| createdbyname | Name Name of the ticket creator | --- | Memo (-) |
| assigned_to_group_name | Name Name of group to whom ticket is assigned. | NVARCHAR (50) | Memo (-) |
| assigned_to_name | |||
| assigned_to_last_name | |||
| assignedtoindividual | Name Name of individual to whom ticket is assigned. | - - | Memo (-) |
| modified_by_group_name | Last Last ticket modified group name. | NVARCHAR (50) | Memo (-) |
| modified_by_name | |||
| modified_by_last_name | |||
| modifiedbyname | Last Last ticket modified. | - - | Memo (-) |
| person1_e_mail | RequesterRequester's email. | NVARCHAR (126) | Memo (-) |
| person1_first_name | |||
| person1_last_name | |||
| requester | RequesterRequester's name. | BIGINT | Memo (-) |
| person1_job_title | RequesterRequester's job title. | NVARCHAR (126) | Memo (-) |
| person1_phone1 | RequesterRequester's phone number. | NVARCHAR (50) | Memo (-) |
| person1_org_name | RequesterRequester's organization name. | NVARCHAR (50) | Memo (-) |
| person1_hierarchical_path | RequesterRequester's organization hierarchical path | NVARCHAR (4000) | Memo (-) |
| person2_e_mail | |||
| person2_first_name | |||
| person2_last_name | |||
| requester2 | |||
| person2_job_title | |||
| person2_phone1 | |||
| person2_org_name | Requested Requested for organization name. | NVARCHAR (50) | Memo (-) |
| person2_hierarchical_path | Requested Requested For organization hierarchical path. | NVARCHAR (4000) | Memo (-) |
| ccti_id | ccticcti_id identifies the categorization of the ticket. | BIGINT | Long Integer (4) |
| ccti_class | CCTI CCTI Class | NVARCHAR (50) | Memo (-) |
| ccti_category | CCTI CCTI Category | NVARCHAR (50) | Memo (-) |
| ccti_type | The The CCTI item type. | NVARCHAR (50) | Memo (-) |
| ccti_item | CCTI CCTI item | NVARCHAR (50) | Memo (-) |
| person1_alt_phone | Phone Phone no of the contact who is the requester of the ticket. | NVARCHAR (50) | Memo (-) |
| person1_alt_email | Email Email of the contact who is the requester of the ticket. | NVARCHAR (126) | Memo (-) |
| ticket_solution_id | Identifier Identifier of the solution that is used to resolve this ticket. | BIGINT | Long Integer (4) |
| person2_alt_phone | Phone Phone number of the requester for whom to contact for who is having the Issue/Requested on behalf of the contact for this ticket. | NVARCHAR (50) | Memo (-) |
| person2_alt_email | Email Email address of the requester for whom to contact for who is having the Issue/Requested on behalf of the contact for this ticket. | NVARCHAR (126) | Memo (-) |
| resolution | Ticket Ticket resolution. | NVARCHAR (4000) | Memo (-) |
| cause | Ticket Ticket cause. | NVARCHAR (50) | Memo (-) |
| severity | Severity Severity specifies the ticket severity. | NVARCHAR (50) | Memo (-) |
| ticket_phase | The The current lifecycle phase/stage of the service desk ticket. | NVARCHAR (50) | Memo (-) |
| ticket_source | Ticket Ticket source. | NVARCHAR (50) | Memo (-) |
| ticket_impact | Ticket Ticket impact. | NVARCHAR (50) | Text (255) |
| ticket_urgency | Ticket Ticket urgency. | NVARCHAR (50) | Text (255) |
| archived_data |
...
| 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 Status of the ticket (New/Queued/Closed). | NVARCHAR (50) | Memo (-) |
| ticket_reason_code | Reason Reason code for any action that is taken on the ticket which resulted in the state change. | NVARCHAR (50) | Memo (-) |
| modifiedatetext | Last Last modified ticket date in formatted value (DD/MM/YYYY). | - - | Date/Time (8) |
| createddatetext | Ticket Ticket created date. | - - | Date/Time (8) |
| modified_date | Last Last modified ticket date. | INT | Long Integer (4) |
| created_date | Date Date in milliseconds when the ticket is created. | INT | Long Integer (4) |
| ticket_priority | Ticket Ticket priority. | NVARCHAR (50) | Memo (-) |
| ticket_description | Ticket Ticket description. | NVARCHAR (256) | Memo (-) |
| created_by_group_name | Group Group ID of the creator group of the ticket. | NVARCHAR (50) | Memo (-) |
| created_by_name | Name Name of the ticket creator. | ||
| created_by_last_name | |||
| createdbyname | Name Name of the ticket creator. | - - | Memo (-) |
| assigned_to_group_name | Name Name of the group to whom ticket is assigned. | NVARCHAR (50) | Memo (-) |
| assigned_to_name | |||
| assigned_to_last_name | |||
| assignedtoindividual | Name Name of the individual to whom ticket is assigned. | - - | Memo (-) |
| modified_by_group_name | Last Last ticket modified group name. | NVARCHAR (50) | Memo (-) |
| modified_by_name | Last Last ticket modified. | - - | Memo (-) |
| modified_by_last_name | |||
| modifiedbyname | Last Last Ticket Modified. | - - | Memo (-) |
| person1_e_mail | RequesterRequester's email. | NVARCHAR (126) | Memo (-) |
| person1_first_name | |||
| person1_last_name | |||
| requester | RequesterRequester's name. | BIGINT | Memo (-) |
| person1_job_title | RequesterRequester's job title. | NVARCHAR (126) | Memo (-) |
| person1_phone1 | RequesterRequester's phone number. | NVARCHAR (50) | Memo (-) |
| person1_org_name | RequesterRequester's organization name. | NVARCHAR (50) | Memo (-) |
| person1_hierarchical_path | RequesterRequester's organization hierarchical path. | NVARCHAR (4000) | Memo (-) |
| person2_e_mail | Requested Requested for email id. | NVARCHAR (126) | Memo (-) |
| person2_first_name | |||
| person2_last_name | |||
| requester2 | Name Name of the requested for. | BIGINT | Memo (-) |
| person2_job_title | Requested Requested for job title. | NVARCHAR (126) | Memo (-) |
| person2_phone1 | Requested Requested for phone number. | NVARCHAR (50) | Memo (-) |
| person2_org_name | Requested Requested for organization name. | NVARCHAR (50) | Memo (-) |
| person2_hierarchical_path | Requested Requested for organization's hierarchical path. | NVARCHAR (4000) | Memo (-) |
| ccti_id | The The categorization for the configuration item. | BIGINT | Long Integer (4) |
| ccti_class | CCTI CCTI class | NVARCHAR (50) | Memo (-) |
| ccti_category | CCTI CCTI category | NVARCHAR (50) | Memo (-) |
| ccti_type | The The CCTI item type. | NVARCHAR (50) | Memo (-) |
| ccti_item | CCTI CCTI item | NVARCHAR (50) | Memo (-) |
| person1_alt_phone | Phone Phone no of the contact who is the requester of the ticket. | NVARCHAR (50) | Memo (-) |
| person1_alt_email | Email Email of the contact who is the requester of the ticket. | NVARCHAR (126) | Memo (-) |
| ticket_solution_id | Identifier Identifier of the solution that is used to resolve this ticket. | BIGINT | Long Integer (4) |
| person2_alt_phone | Phone Phone number of the requester for whom to contact for who is having the Issue/Requested on behalf of the contact for this ticket. | NVARCHAR (50) | Memo (-) |
| person2_alt_email | Email Email address of the requester for whom to contact for who is having the Issue/Requested on behalf of the contact for this ticket. | NVARCHAR (126) | Memo (-) |
| resolution | Ticket Ticket resolution. | NVARCHAR (4000) | Memo (-) |
| cause | Ticket Ticket cause. | NVARCHAR (50) | Memo (-) |
| severity | Severity specifies the severity of the ticket. | NVARCHAR (50) | Memo (-) |
| description_long | Long Long description of the problem faced. | NVARCHAR (4000) | Memo (-) |
| created_by_contact_id | The The contact person who created this problem ticket. | BIGINT | Long Integer (4) |
| assigned_to_contact_id | Identify Identify the individual/contact to which the ticket is assigned. | BIGINT | Long Integer (4) |
| modified_by_contact_id | modifiedmodified_by_contact_id identifies the contact who modified the ticket. | BIGINT | Long Integer (4) |
| person1_contact_id | Identification Identification for the contact who is the requester of the ticket. | BIGINT | Long Integer (4) |
| person2_contact_id | Identification Identification for the contact who is the requester of the ticket. | BIGINT | Long Integer (4) |
| ci_name | |||
| affected_service | Affected Affected service. | BIGINT | Memo (-) |
| ticket_phase | The The current lifecycle phase/stage of the service desk ticket. | NVARCHAR (50) | Memo (-) |
| ticket_source | Ticket Ticket source. | NVARCHAR (50) | Memo (-) |
| ticket_impact | Ticket Ticket impact. | NVARCHAR (50) | Text (255) |
| ticket_urgency | Ticket Ticket urgency. | NVARCHAR (50) | Text (255) |
| archived_data |
...
| 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 Reason code for any action that is taken on the ticket which resulted in the state change. | NVARCHAR (50) | Memo (-) |
| modifieddatetext | Last Last modified ticket date in formatted value (DD/MM/YYYY). | - - | Date/Time (8) |
| createddatetext | Ticket Ticket created date. | - - | Date/Time (8) |
| modified_date | Last Last modified ticket date. | INT | Long Integer (4) |
| created_date | Date Date in milliseconds when the ticket is created. | INT | Long Integer (4) |
| ticket_priority | Ticket Ticket priority. | NVARCHAR (50) | Memo (-) |
| ticket_description | Ticket Ticket description. | NVARCHAR (256) | Memo (-) |
| created_by_group_name | Group Group ID of the creator group of the ticket. | NVARCHAR (50) | Memo (-) |
| created_by_name | Name Name of the ticket creator. | - - | Memo (-) |
| created_by_last_name | |||
| createdbyname | Name Name of the ticket creator. | - - | Memo (-) |
| assigned_to group_name | Name Name of the group to whom ticket is assigned. | NVARCHAR (50) | Memo (-) |
| assigned_to_name | |||
| assigned_to_last_name | |||
| assignedtoindividual | Name Name of the individual to whom ticket is assigned. | - - | Memo (-) |
| modified_by_group_name | Last Last ticket modified group name. | NVARCHAR (50) | Memo (-) |
| modified_by_name | Last Last ticket modified. | - - | Memo (-) |
| modified_by_last_name | |||
| modifiedbyname | Last Last ticket modified. | - - | Memo (-) |
| person1_e_mail | RequesterRequester's email. | NVARCHAR (126) | Memo (-) |
| person1_first_name | |||
| person1_last_name | |||
| requester | RequesterRequester's name. | BIGINT | Memo (-) |
| person1_job_title | RequesterRequester's job title. | NVARCHAR (126) | Memo (-) |
| person1_phone1 | RequesterRequester's phone number. | NVARCHAR (50) | Memo (-) |
| person1_org_name | RequesterRequester's organization name. | NVARCHAR (50) | Memo (-) |
| person1_hierarchical_path | RequesterRequester's organization hierarchical path. | NVARCHAR (50) | Memo (-) |
| person2_e_mail | Requested Requested for email id. | NVARCHAR (126) | Memo (-) |
| person2_first_name | |||
| person2_last_name | |||
| requester2 | Requested Requested for name. | BIGINT | Memo (-) |
| person2_job_title | Requested Requested for job title. | NVARCHAR (126) | Memo (-) |
| person2_phone1 | Requested Requested for phone number. | NVARCHAR (50) | Memo (-) |
| person2_org_name | Requested Requested for the organization name. | NVARCHAR (50) | Memo (-) |
| person2_hierarchical_path | Requested Requested for the organization hierarchical path. | NVARCHAR (4000) | Memo (-) |
| ccti_id | The The categorization for the configuration item. | BIGINT | Long Integer (4) |
| ccti_class | CCTI CCTI class | NVARCHAR (50) | Memo (-) |
| ccti_category | CCTI CCTI category. | NVARCHAR (50) | Memo (-) |
| ccti_type | The The CCTI item type. | NVARCHAR (50) | Memo (-) |
| ccti_item | CCTI CCTI item. | NVARCHAR (50) | Memo (-) |
| person1_alt_phone | Phone Phone no of the contact who is the requester of the ticket. | NVARCHAR (50) | Memo (-) |
| person1_alt_email | Email Email of the contact who is the requester of the ticket. | NVARCHAR (126) | Memo (-) |
| ticket_solution_id | |||
| person2_alt_phone | |||
| person2_alt_email | |||
| description_long | Long Long description of the issue faced. | NVARCHAR (4000) | Memo (-) |
| task_name | Task Task name | NVARCHAR (126) | Memo (-) |
| task_type | The The task type. | NVARCHAR (50) | Memo (-) |
| actual_start_date | The The actual start date when the task would be started. | INT | Long Integer (4) |
| actual_end_date | The The actual end date when the task would be completed. | INT | Long Integer (4) |
| parent_description | Parent Parent ticket description. | NVARCHAR (256) | Memo (-) |
| parent_item_id | Parent ticket ID. | BIGINT | Long Integer (4) |
| parent_ticket_type | Parent ticket type. | NVARCHAR (50) | Memo (-) |
| created_by_contact_id | The contact person who created this request ticket. | BIGINT | Long Integer (4) |
| assigned_to_contact_id | Identify the individual/contact to which the ticket is assigned. | BIGINT | Long Integer (4) |
| modified_by_contact_id | The contact who modified the ticket. | BIGINT | Long Integer (4) |
| person1_contact_id | Identification for the contact who is the requester of the ticket. | BIGINT | Long Integer (4) |
| person2_contact_id | Identification for the contact who is the requester of the ticket. | BIGINT | Long Integer (4) |
| affected_service | Affected service. | BIGINT | Memo (-) |
| ticket_phase | The current lifecycle phase/stage of the service desk ticket. | NVARCHAR (50) | Memo (-) |
| ticket_source | Ticket source. | NVARCHAR (50) | Memo (-) |
| ticket_impact | Ticket impact. | NVARCHAR (50) | Text (255) |
| ticket_urgency | Ticket urgency. | NVARCHAR (50) | Text (255) |
| planned_start_date | The planned start date to complete this Task. | INT | Long Integer (4) |
| planned_end_date | The planned end date to complete this Task. | INT | Long Integer (4) |
| planned_duration | The planned duration to complete this Task. | INT | Long Integer (4) |
| planned_start_datetext | The planned start date to complete this Task in formatted text (DD/MM/YYYY). | - - | Date/Time (8) |
| planned_end_datetext | The planned end date to complete this Task in formatted text (DD/MM/YYYY). | - - | Date/Time (8) |
| actual_duration | The actual duration to complete the work to be done to implement the Task. | INT | Long Integer (4) |
| actual_start_datetext | The actual start date when the Task would be started in formatted text (DD/MM/YYYY). | - - | Date/Time (8) |
| actual_end_datetext | The actual end date when the Task would be completed in formatted text (DD/MM/YYYY). | - - | Date/Time (8) |
| archived_data |
...
Entity: DTX_Ticket_CI_Relationship
TICKET_CI_RELATIONSHIP refers to the Ticket to the CI relationship in your instance. The following details about the Ticket CI relationship are available in the extract.
| Name | Description | System Data Type | Extract Data Type |
|---|---|---|---|
| ci_id | The associated configuration item to the ticket. | BIGINT | Long Integer (4) |
| item_id | Item ID | BIGINT | Long Integer (4) |
| archived_data |
Entity: DTX_Ticket_Ticket_Relationship
TICKET_TICKET_RELATIONSHIP refers to the Ticket to the Ticket relationship in your instance. The following information about Ticket to ticket relationship is available in the extract.
| Name | Description | System Data Type | Extract Data Type |
|---|---|---|---|
| parent_item_id | Parent ticket ID | BIGINT | Long integer (4) |
| item_id | Item ID | BIGINT | Long Integer (4) |
| archived_data |
...