A Data Extract is a file that contains the customer's service desk related data for on-premise reporting. This article lists a number of tables containing the list of entities. You can use these details to create new reports using your reporting tool
A Data Extract is a file that contains the customer's service desk related data for on-premise reporting. This article lists a number of tables containing the list of entities. You can use these details to create new reports using your reporting tool.
Data Extract is enabled by a set of scripts that run against the customer’s Production database. The script executes queries to extract data from the database and this extracted data is exported as Views in the read-only database.
...
| 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) |
| 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 (-) |
| createdbyname | First name of the ticket creator | --- | Text |
| createdbyname | Last name of the ticket creator | --- | Text |
| createdbyname | Name of the ticket creator | --- | Memo (-) |
| assigned_to_group_name | Name of group to whom ticket is assigned. | NVARCHAR (50) | Memo (-) |
| assignedtoindividual | First name of the individual to whom ticket is assigned. | NVARCHAR | Text |
| assignedtoindividual | Last name of the individual to whom ticket is assigned. | ||
| assignedtoindividual | Name of individual to whom ticket is assigned. | - - | Memo (-) |
| modified_by_group_name | Last ticket modified group name. | NVARCHAR (50) | Memo (-) |
| modifiedbyname | First name of the person who modified the ticket. | NVARCHAR | |
| modifiedbyname | Last name of the person who modified the ticket. | NVARCHAR | |
| modifiedbyname | Last ticket modified. | - - | Memo (-) |
| person1_e_mail | Requester's email. | NVARCHAR (126) | Memo (-) |
| requester | First name of the ticket requester. | NVARCHAR | |
| requester | Last name of the ticket requester. | NVARCHAR | |
| requester | Requester's name. | BIGINT | Memo (-) |
| person1_job_title | Requester's job title. | NVARCHAR (126) | Memo (-) |
| person1_phone1 | Requester's phone number. | NVARCHAR (50) | Memo (-) |
| person1_org_name | Requester's organization name. | NVARCHAR (50) | Memo (-) |
| person1_hierarchical_path | Requester's organization hierarchical path | NVARCHAR (4000) | Memo (-) |
| person2_e_mail | Email id of the ticket requested for. | NVARCHAR | Text |
| requester2 | First name of the ticket requested for. | NVARCHAR | Text |
| requester2 | Last name of the ticket requested for. | NVARCHAR | Text |
| requester2 | Name of the requested for. | NVARCHAR | Text |
| person2_job_title | Job title of the ticket requested for. | NVARCHAR | Text |
| person2_phone1 | Phone number of the ticket requested for. | NVARCHAR | Text |
| person2_org_name | Requested for organization name. | NVARCHAR (50) | Memo (-) |
| person2_hierarchical_path | Requested for organization hierarchical path. | NVARCHAR (4000) | Memo (-) |
| ccti_id | ccti_id identifies the categorization of the ticket. | BIGINT | Long Integer (4) |
| ccti_class | CCTI Class | NVARCHAR (50) | Memo (-) |
| ccti_category | CCTI Category | NVARCHAR (50) | Memo (-) |
| ccti_type | The CCTI item type. | NVARCHAR (50) | Memo (-) |
| ccti_item | CCTI item | NVARCHAR (50) | Memo (-) |
| person1_alt_phone | Phone no of the contact who is the requester of the ticket. | NVARCHAR (50) | Memo (-) |
| person1_alt_email | Email of the contact who is the requester of the ticket. | NVARCHAR (126) | Memo (-) |
| ticket_solution_id | Identifier of the solution that is used to resolve this ticket. | BIGINT | Long Integer (4) |
| person2_alt_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 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 resolution. | NVARCHAR (4000) | Memo (-) |
| cause | Ticket cause. | NVARCHAR (50) | Memo (-) |
| severity | Severity specifies the ticket severity. | NVARCHAR (50) | 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) |
| archived_data | An indicator flag used to identify whether this is a historical record that is ready to be archived. | INTEGER |
...
| 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 (-) | |||||||||||
| modifiedatetext | 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 (-) createdbyname | First name of the ticket creator. | NVARCHAR | createdbyname | Last name of the ticket creator. | NVARCHAR | ||||||
| createdbyname | Name of the ticket creator. | - - | Memo (-) | |||||||||||
| assigned_to_group_name | Name of the group to whom ticket is assigned. | NVARCHAR (50) | Memo (-) | assignedtoindividual | Name of the individual to whom ticket is assigned. | NVARCHAR | assignedtoindividual | Last name of the individual to whom ticket is assigned. | NVARCHAR | assignedtoindividual name | Name of the individual group to whom ticket is assigned. | - -NVARCHAR (50) | Memo (-) | |
| modified_by_group_name | Last ticket modified group name. | NVARCHAR (50) | Memo (-) | |||||||||||
| modifiedbyname | Last ticket modified. | - - | Memo (-) | modifiedbyname | Last name of the individual who modified the ticket. | NVARCHAR | ||||||||
| modifiedbyname | Last Ticket Modified. | - - | Memo (-) | |||||||||||
| person1_e_mail | Requester's email. | NVARCHAR (126) | Memo (-) | requester | First name of the requester. | NVARCHAR | requester | Last name of the requester. | NVARCHAR | requester | Requester's name. | BIGINT . | NVARCHAR (126) | Memo (-) |
| person1_job_title | Requester's job title. | NVARCHAR (126) | Memo (-) | |||||||||||
| person1_phone1 | Requester's phone number. | NVARCHAR (50) | Memo (-) | |||||||||||
| person1_org_name | Requester's organization name. | NVARCHAR (50) | Memo (-) | |||||||||||
| person1_hierarchical_path | Requester's organization hierarchical path. | NVARCHAR (4000) | Memo (-) | |||||||||||
| person2_e_mail | Requested for email id. | NVARCHAR (126) | Memo (-) requester2 | First name of the requested for. | NVARCHAR | requester2 | Last name of the requested for. | NVARCHAR | ||||||
| requester2 | Name of the requested for. | BIGINT | Memo (-) | |||||||||||
| person2_job_title | Requested for job title. | NVARCHAR (126) | Memo (-) | |||||||||||
| person2_phone1 | Requested for phone number. | NVARCHAR (50) | Memo (-) | |||||||||||
| person2_org_name | Requested for organization name. | NVARCHAR (50) | Memo (-) | |||||||||||
| person2_hierarchical_path | Requested for organization's hierarchical path. | NVARCHAR (4000) | Memo (-) | |||||||||||
| ccti_id | The categorization for the configuration item. | BIGINT | Long Integer (4) | |||||||||||
| ccti_class | CCTI class | NVARCHAR (50) | Memo (-) | |||||||||||
| ccti_category | CCTI category | NVARCHAR (50) | Memo (-) | |||||||||||
| ccti_type | The CCTI item type. | NVARCHAR (50) | Memo (-) | |||||||||||
| ccti_item | CCTI item | NVARCHAR (50) | Memo (-) | |||||||||||
| person1_alt_phone | Phone no of the contact who is the requester of the ticket. | NVARCHAR (50) | Memo (-) | |||||||||||
| person1_alt_email | Email of the contact who is the requester of the ticket. | NVARCHAR (126) | Memo (-) | |||||||||||
| ticket_solution_id | Identifier of the solution that is used to resolve this ticket. | BIGINT | Long Integer (4) | |||||||||||
| person2_alt_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 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 resolution. | NVARCHAR (4000) | Memo (-) | |||||||||||
| cause | Ticket cause. | NVARCHAR (50) | Memo (-) | |||||||||||
| severity | Severity specifies the severity of the ticket. | NVARCHAR (50) | Memo (-) | |||||||||||
| description_long | Long description of the problem faced. | NVARCHAR (4000) | Memo (-) | |||||||||||
| created_by_contact_id | The contact person who created this problem 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 | modified_by_contact_id identifies 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) | |||||||||||
| ci_name | Name of the configuration item. | NVARCHAR | ||||||||||||
| 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) | |||||||||||
| archived_data | An indicator flag used to identify whether this is a historical record that is ready to be archived. | INT |
...
| 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 ticketticket_priority | Ticket priority. | NVARCHAR (50) | Memo (-) | |||||
| createdbyname | Name of the ticket creator. | - - | Memo (-) | createdbyname | Last name of the ticket creator. | NVARCHAR | |||
| createdbyname | Name of the ticket creator. | - - | Memo (-) | ||||||
| assigned_to group_name | Name of the group to whom ticket is assignedticket_description | Ticket description. | NVARCHAR (256) | Memo (-) | |||||
| created_by_group_name | Group ID of the creator group of the ticket. | NVARCHAR (50) | Memo (-) assignedtoindividual | ||||||
| Name of the individual to whom ticket is assigned. | NVARCHAR | assignedtoindividual | Last name of the individual to whom ticket is assigned. | NVARCHAR | assignedtoindividual assigned_to group_name | Name of the individual group to whom ticket is assigned. | - - | Memo NVARCHAR (50) | Memo (-) |
| modified_by_group_name | Last ticket modified group name. | NVARCHAR (50) | Memo (-) | ||||||
| modifiedbyname | Last ticket modified. | - - | Memo (-) | modifiedbyname | Last name of the individual who modified the ticket. | NVARCHAR | |||
| modifiedbyname | Last ticket modified. | - - | Memo (-) | ||||||
| person1_e_mail | Requester's email. | NVARCHAR (126) | Memo (-) | ||||||
| requester | First name of the requester. | NVARCHAR | requester | Last name of the requester. | NVARCHAR | requester person1_e_mail | Requester's nameemail. | BIGINTNVARCHAR (126) | Memo (-) |
| person1_job_title | Requester's job title. | NVARCHAR (126) | Memo (-) | ||||||
| person1_phone1 | Requester's phone number. | NVARCHAR (50) | Memo (-) | ||||||
| person1_org_name | Requester's organization name. | NVARCHAR (50) | Memo (-) | ||||||
| person1_hierarchical_path | Requester's organization hierarchical path. | NVARCHAR (50) | Memo (-) | ||||||
| person2_e_mail | Requested for email id. | NVARCHAR (126) | Memo (-) | ||||||
| person2_first_name | First name of the requested for. | NVARCHAR | |||||||
| person2_last_name | Last name of the requested for. | NVARCHAR | |||||||
| requester2 | Requested for name. | BIGINT | Memo (-) | ||||||
| person2_job_title | Requested for job title. | NVARCHAR (126) | Memo (-) | ||||||
| person2_phone1 | Requested for phone number. | NVARCHAR (50) | Memo (-) | ||||||
| person2_org_name | Requested for the organization name. | NVARCHAR (50) | Memo (-) | ||||||
| person2_hierarchical_path | Requested for the organization hierarchical path. | NVARCHAR (4000) | Memo (-) | ||||||
| ccti_id | The categorization for the configuration item. | BIGINT | Long Integer (4) | ||||||
| ccti_class | CCTI class | NVARCHAR (50) | Memo (-) | ||||||
| ccti_category | CCTI category. | NVARCHAR (50) | Memo (-) | ||||||
| ccti_type | The CCTI item type. | NVARCHAR (50) | Memo (-) | ||||||
| ccti_item | CCTI item. | NVARCHAR (50) | Memo (-) | ||||||
| person1_alt_phone | Phone no of the contact who is the requester of the ticket. | NVARCHAR (50) | Memo (-) | ||||||
| person1_alt_email | Email of the contact who is the requester of the ticket. | NVARCHAR (126) | Memo (-) | ||||||
| ticket_solution_id | Identifier of the solution used to resolve the ticket. | BIGINT | |||||||
| person2_alt_phone | Alternate phone number of the requested for. | NVARCHAR | |||||||
| person2_alt_email | Alternate email id of the requested for. | NVARCHAR | |||||||
| description_long | Long description of the issue faced. | NVARCHAR (4000) | Memo (-) | ||||||
| task_name | Task name | NVARCHAR (126) | Memo (-) | ||||||
| task_type | The task type. | NVARCHAR (50) | Memo (-) | ||||||
| actual_start_date | The actual start date when the task would be started. | INT | Long Integer (4) | ||||||
| actual_end_date | The actual end date when the task would be completed. | INT | Long Integer (4) | ||||||
| parent_description | 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) | ||||||
| affectedaffected_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 | An indicator flag used to identify whether this is a historical record that is ready to be archived. | INT |
...
| 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 | Identifier of the case. | 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 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 in formatted value (DD/MM/YYYY). | - - | 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 | Priority of the ticket. | NVARCHAR (50) | Memo (-) | |||||||||
| ticket_description | Description of the ticket. | NVARCHAR (50) | Memo (-) | |||||||||
| created_by_group_name | Group ID of the creator group of the ticket. | NVARCHAR (50) | Memo (-date | Last modified ticket date. | INT | Long Integer (4) | ||||||
| created_by_name Name of date | Date in milliseconds when the ticket creatoris created. | - -INT | Memo Long Integer (-4) | created_by_last_name | ||||||||
| Last name ticket_priority | Priority of the ticket creator. | NVARCHAR | createdbyname | Name of the ticket creator. | - -(50) | Memo (-) | ||||||
| assigned_to_group_name | Name of the group to whom ticket is assignedticket_description | Description of the ticket. | NVARCHAR (50) | Memo (-) | ||||||||
| assignedcreated_by_togroup_name | Name Group ID of the creator group of the individual to whom ticket is assigned.NVARCHAR ticket. | NVARCHAR (50) | Memo (-) | |||||||||
| assigned_to_lastgroup_name | Name of the individual group to whom ticket is assigned. | NVARCHAR NVARCHAR (50) | Memo (-) | |||||||||
| assignedtoindividual | Name of individual to whom ticket is assigned. | - - | Memo (-) | |||||||||
| modified_by_group_name | Last ticket modified group name. | NVARCHAR (50) | Memo (-) | modified_by_name | Name of the individual who modified the ticket. | NVARCHAR | modified_by_last_name | Last name of the individual who modified the ticket. | NVARCHAR | |||
| modifiedbyname | Last ticket modified. | - - | Memo (-) | |||||||||
| person1_e_mail | Requester's email. | NVARCHAR (126) | Memo (-) | person1_first_name | First name of the requester. | NVARCHAR | person1_last_name | Last name of the requester. | NVARCHAR | Requester's email. | NVARCHAR (126) | Memo (-) |
| requester | Name of the requester. | BIGINT | Memo (-) | |||||||||
| person1_job_title | Requester's job title. | NVARCHAR (126) | Memo (-) | |||||||||
| person1_phone1 | Requester's phone number. | NVARCHAR (50) | Memo (-) | |||||||||
| person1_org_name | Requester's organization name. | NVARCHAR (50) | Memo (-) | |||||||||
| person1_hierarchical_path | The organization hierarchical path of the requester. | NVARCHAR (4000) | Memo (-) | |||||||||
| person2_e_mail | Requested for email id. | NVARCHAR (126) | Memo (-) | person2_first_name | First name of the requested for. | NVARCHAR | person2_last_name | Last name of the requested for. | NVARCHAR | |||
| requester2 | Requested for name. | BIGINT | Memo (-) | |||||||||
| person2_job_title | Requested for job title. | NVARCHAR (126) | Memo (-) | |||||||||
| person2_phone1 | Requested for phone number. | NVARCHAR (50) | Memo (-) | |||||||||
| person2_org_name | Requested for organization name. | NVARCHAR (126) | Memo (-) | |||||||||
| person2_hierarchical_path | The organization hierarchical path of requested for ticket. | NVARCHAR (4000) | Memo (-) | |||||||||
| ccti_id | Identifies in which categorization the ticket lies. | BIGINT | Long Integer (4) | |||||||||
| ccti_class | Class of a CCTI. | NVARCHAR (50) | Memo (-) | |||||||||
| ccti_category | Category of a CCTI. | NVARCHAR (50) | Memo (-) | |||||||||
| ccti_type | Type of CCTI. | NVARCHAR | ||||||||||
| ccti_item | Item of the CCTI. | NVARCHAR (50) | Memo (-) | |||||||||
| person1_alt_phone | Phone number of the contact who is the requester of the ticket. | NVARCHAR (50) | Memo (-) | |||||||||
| person1_alt_email | Email of the contact who is the requester of the ticket. | NVARCHAR (126) | Memo (-) | |||||||||
| ticket_solution_id | Identifier of the solution used to resolve this ticket. | BIGINT | Long Integer (4) | |||||||||
| person2_alt_phone | Phone number of the requested 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 address of the requested for whom to contact for who is having the Issue/Requested on behalf of the contact for this ticket. | NVARCHAR (126) | Memo (-) | |||||||||
| ticket_details | Description of a ticket. | NVARCHAR (4000) | Memo (-) | |||||||||
| created_by_contact_id | The contact person who created this change 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 | Identifies 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) | |||||||||
| person2person2_contact_id | Identification for the contact who is the requester of the ticket. | BIGINT | Long Integer (4) | |||||||||
| affected_service | Service that is affected. | NVARCHAR (126) | Memo (-) | |||||||||
| ticket_phase | The current lifecycle phase/stage of the service desk ticket. | NVARCHAR (50) | Memo (-) | |||||||||
| ticket_source | Source of the ticket. | NVARCHAR (50) | Memo (-) | |||||||||
| business_criticality | The criticality of this change from the business point of view. | NVARCHAR (50) | Memo (-) | |||||||||
| change_subtype | Subtype of a change. | NVARCHAR (50) | Memo (-) | |||||||||
| outage_type | The type of outage or disruption expected during the implementation of the requested change. | NVARCHAR (30) | Memo (-) | |||||||||
| outage_duration | The approximate length of the outage. | INT | Text (255) | |||||||||
| risk_assessment | The predicted impact of the requested change. | NVARCHAR (30) | Text (255) | |||||||||
| planned_start_date | The planned start date to begin this change. | INT | Long Integer (4) | |||||||||
| planned_end_date | The planned end date to complete this change. | INT | Long Integer (4) | |||||||||
| planned_start_datetext | The planned start date to complete this change in formatted text (DD/MM/YYYY). | - - | Date/Time (8) | |||||||||
| planned_end_datetext | The planned end date to complete this change in formatted text (DD/MM/YYYY). | - - | Date/Time (8) | |||||||||
| planned_duration | The planned duration to complete this change. | INT | Long Integer (4) | |||||||||
| actual_start_date | The actual start date when the change would be started. | INT | Long Integer (4) | |||||||||
| actual_end_date | The actual end date when the change would be completed. | INT | Long Integer (4) | |||||||||
| actual_start_datetext | The actual start date when the change would be started in formatted text (DD/MM/YYYY). | - - | Date/Time (8) | |||||||||
| actual_end_datetext | The actual end date when the change would be completed in formatted text (DD/MM/YYYY). | - - | Date/Time (8) | |||||||||
| actual_duration | The actual duration to complete the work to be done to implement the change. | INT | Long Integer (4) | |||||||||
| ticket_impact | Value in the Ticket impact field. | NVARCHAR (50) | Text (255) | |||||||||
| ticket_urgency | Value in the Ticket Urgency field. | NVARCHAR (50) | Text (255) | |||||||||
| implementation_verification_plan | The plan for implementing this change. | NVARCHAR (4000) | Memo | |||||||||
| changed_impacted | The environments that might get affected due to the change. | NVARCHAR (4000) | Memo | |||||||||
| cis_affected | The Configuration Items that will get affected after making this change. | NVARCHAR (4000) | Memo | |||||||||
| locations_affected | The sites and locations that can be affected by this change. | NVARCHAR (4000) | Memo | |||||||||
| environment_affected | The environment that may be impacted by the change. | NVARCHAR (4000) | Memo | |||||||||
| backout_plan | The back-out plans for change rollback in case the change fails or something goes wrong while making the change. | NVARCHAR (4000) | Memo | |||||||||
| archived_data | An indicator flag used to identify whether this is a historical record that is ready to be archived. | INT |
...
| 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 individual who created the ticket. | NVARCHAR | created_by_last_name | Last name Group ID of the individual who created creator group of the ticket. | NVARCHAR (50) | Memo (-) | NVARCHAR |
| 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 | Name of the individual to whom ticket is assigned. | NVARCHAR | assigned_to_last_name | Last name of the individual to whom ticket is assigned. | NVARCHAR | ||
| assignedtoindividual | Name of individual to whom ticket is assigned. | - - | Memo (-) | ||||||||
| modified_by_group_name | Last ticket modified group name. | NVARCHAR (50) | Memo (-) | modified_by_name | Name of the individual who modified the ticket. | NVARCHAR | modified_by_last_name | Last name of the individual who modified the ticket. NVARCHAR | |||
| modifiedbyname | Last ticket modified. | - - | Memo (-) | ||||||||
| person1_e_mail | Requester's email. | NVARCHAR (126) | Memo (-) | person1_first_name | First name of the requester. | NVARCHAR | person1_last_name | Last name of the requester. | NVARCHAR | ||
| requester | Requester's name. | BIGINT | Memo (-) | ||||||||
| person1_job_title | Requester's job title | NVARCHAR (126) | Memo (-) | ||||||||
| person1_phone1 | Requester's phone number. | NVARCHAR (50) | Memo (-) | ||||||||
| person1_org_name | Requester's organization name. | NVARCHAR (50) | Memo (-) | ||||||||
| person1_hierarchical_path | Requester's organization hierarchical path. | NVARCHAR (4000) | Memo (-) | ||||||||
| person2_e_mail | Email id of the requested for. | NVARCHAR (126) | Memo (-) | person2_first_name | First name of the requested for. | NVARCHAR | person2_last_name | Last name of the requested for. | NVARCHAR | ||
| requester2 | Name of the requested for. | BIGINT | Memo (-) | ||||||||
| person2_job_title | Requested for job title. | NVARCHAR (126) | Memo (-) | ||||||||
| person2_phone1 | Requested for phone number. | NVARCHAR (50) | Memo (-) | ||||||||
| person2_org_name | Requested for organization name. | NVARCHAR (50) | Memo (-) | ||||||||
| person2_hierarchical_path | Requested for organization hierarchical path. | NVARCHAR (4000) | Memo (-) | ||||||||
| ccti_id | The categorization for the configuration item. | BIGINT | Long Integer (4) | ||||||||
| ccti_class | CCTI class. | NVARCHAR (50) | Memo (-) | ||||||||
| ccti_category | CCTI category | NVARCHAR (50) | Memo (-) | ||||||||
| ccti_type | CCTI item type. | NVARCHAR (50) | Memo (-) | ||||||||
| ccti_item | CCTI item | NVARCHAR (50) | Memo (-) | ||||||||
| person1_alt_phone | Phone number of the contact who is the requester of the ticket. | NVARCHAR (50) | Memo (-) | ||||||||
| person1_alt_email | Email of the contact who is the requester of the ticket. | NVARCHAR (126) | Memo (-) | ||||||||
| ticket_solution_id | Identifier of the solution that is used to resolve this ticket. | BIGINT | Long Integer (4) | ||||||||
| person2_alt_phone | Phone number of the requested 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 address of the requested for whom to contact for who is having the Issue/Requested on behalf of the contact for this ticket. | NVARCHAR (126) | Memo (-) | ||||||||
| resolution | Ticket resolution. | NVARCHAR (4000) | Memo (-) | ||||||||
| cause | Ticket cause. | NVARCHAR (50) | Memo (-) | ||||||||
| description_long | Long description of the issue faced. | NVARCHAR (4000) | 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 | modified_by_contact_id identifies 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) | ||||||||
| archived_data | An indicator flag used to identify whether this is a historical record that is ready to be archived. | INT |
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 | An indicator flag used to identify whether this is a historical record that is ready to be archived. | INT |
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 | An indicator flag used to identify whether this is a historical record that is ready to be archived. | INT |
...
| Name | Description | System Data Type | Extract Data Type | ||||||
|---|---|---|---|---|---|---|---|---|---|
| item_id | Identifier of the ticket-specific details from APP_ITEM | BIGINT | Long Integer (4) | ||||||
| action_created_date | The date when this action occurred | INT | Long Integer (4) | ||||||
| actiontakendatetext | The action that is taken in formatted text (DD/MM/YYYY). | - - | Date/Time (8) | ||||||
| act_name | Name of the Action option | NVARCHAR (126) | Memo (-) | ||||||
| act_description | Description of the Action option | NVARCHAR (256) | Memo (-) | ||||||
| action_created_by_contact_id | The contact who caused that action to occur. | BIGINT | Memo (-) | ||||||
| action_by_first_name | First name of the person who has taken the action | NVARCHAR | |||||||
| action_by_last_name | Last name of the person who has taken the action. | NVARCHAR | |||||||
| actiontakenby | Identifies the action that is taken on a ticket. | - - | Memo (-) | ||||||
| group_name | The group that acted on a ticket. | NVARCHAR (50) | Memo (-) | assign_first_name | First name of the individual to whom ticket is assigned. | NVARCHAR | assign_last_name | Last name of the individual to whom ticket is assigned. | NVARCHAR |
| assignedtoindividual | The individual to whom the ticket is assigned. | - - | Memo (-) | ||||||
| assign_contact_id | Identifier of the contact person to whom the assignment is assigned. | BIGINT | Long Integer (4) | ||||||
| status | The status that the ticket is set to. | NVARCHAR (50) | Memo (-) | ||||||
| status_reason_code | The reason code that is specified for the status. | NVARCHAR (50) | Memo (-) | ||||||
| status_end_date | Date status changed (History Record). | INT | Long Integer (4) | ||||||
| statusenddatetext | Date Status Changed (History Record) in formatted text (DD/MM/YYYY). | - - | Date/Time (8) | ||||||
| archived_data | An indicator flag used to identify whether this is a historical record that is ready to be archived. | INT |
...