You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 8
Next »
The following entities are present in the DTX extracts:
INCIDENTS refers to the Incident Tickets logged and updated in your instance. Details in the following fields of the Incident ticket are available in the extract.
| 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 (-) |
| created_by_name | | | |
| created_by_last_name | | | |
| createdbyname | Name of the ticket creator | --- | Memo (-) |
| assigned_to_group_name | Name of group to whom ticket is assigned. | NVARCHAR (50) | Memo (-) |
| assigned_to_name | | | |
| assigned_to_last_name | | | |
| 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 | | | |
| 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 | 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 | | | |
| person2_first_name | | | |
| person2_last_name | | | |
| requester2 | | | |
| person2_job_title | | | |
| person2_phone1 | | | |
| 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 | | | |
Problems refers to the Problem Tickets logged and updated in your instance. Details in the following fields of the Problem ticket are available in the extract.
| 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 (-) |
| created_by_name | Name of the ticket creator. | | |
| 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 | 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 (-) |
| person2_first_name | | | |
| person2_last_name | | | |
| 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 | | | |
| 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 | | | |
| 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 | | | |
| person1_e_mail | | | |
| person1_first_name | | | |
| person1_last_name | | | |
| requester | | | |
| 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 | | | |
| Name | Description | System Data Type | Extract Data Type |
|---|
| item_id |
|
|
|
| case_id |
|
|
|
| ticket_id |
|
|
|
| ticket_status | | | |
| ticket_reason_code | | | |
| modifieddatetext | | | |
| createddatetext | | | |
| modified_date | | | |
| created_date | | | |
| ticket_priority | | | |
| ticket_description | | | |
| created_by_group_name | | | |
| created_by_name | | | |
| created_by_last_name | | | |
| createdbyname | | | |
| assigned_to_group_name | | | |
| assigned_to_name | | | |
| assigned_to_last_name | | | |
| assignedtoindividual | | | |
| modified_by_group_name | | | |
| modified_by_name | | | |
| modified_by_last_name | | | |
| modifiedbyname | | | |
| person1_e_mail | | | |
| person1_first_name | | | |
| person1_last_name | | | |
| requester | | | |
| 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 | | | |
| ticket_details | | | |
| created_by_contact_id | | | |
| assigned_to_contact_id | | | |
| modified_by_contact_id | | | |
| person1_contact_id |
| | |
| person2_contact_id | | | |
| affected_service | | | |
| ticket_phase | | | |
| ticket_source | | | |
| business_criticality | | | |
| change_subtype | | | |
| outage_type | | | |
| outage_duration | | | |
| risk_assessment | | | |
| planned_start_date | | | |
| planned_end_date | | | |
| planned_start_datetext | | | |
| planned_end_datetext | | | |
| planned_duration | | | |
| actual_start_date | | | |
| actual_end_date | | | |
| actual_start_datetext | | | |
| actual_end_datetext | | | |
| actual_duration | | | |
| ticket_impact | | | |
| ticket_urgency | | | |
| implementation_verification_plan | | | |
| changed_impacted | | | |
| cis_affected | | | |
| locations_affected | | | |
| environment_affected | | | |
| backout_plan | | | |
| archived_data | | | |
| Name | Description | System Data Type | Extract Data Type |
|---|
| item_id |
|
|
|
| appr_history_id |
|
|
|
| appr_phase |
|
|
|
| appr_status | | | |
| appr_voting_type | | | |
| approver_id | | | |
| last_name | | | |
| first_name | | | |
| approver_name | | | |
| appr_role | | | |
| group_name | | | |
| decision | | | |
| decision_date | | | |
| decision_datetext | | | |
| comment_text | | | |
| approver_comment | | | |
| archived_data | | | |
| Name | Description | System Data Type | Extract Data Type |
|---|
| item_id |
|
|
|
| case_id |
|
|
|
| ticket_id |
|
|
|
| ticket_status | | | |
| ticket_reason_code | | | |
| modifieddatetext | | | |
| createddatetext | | | |
| modified_date | | | |
| created_date | | | |
| ticket_priority | | | |
| ticket_description | | | |
| created_by_group_name | | | |
| created_by_name | | | |
| created_by_last_name | | | |
| createdbyname | | | |
| assigned_to_group_name | | | |
| assigned_to_name | | | |
| assigned_to_last_name | | | |
| assignedtoindividual | | | |
| modified_by_group_name | | | |
| modified_by_name | | | |
| modified_by_last_name | | | |
| modifiedbyname | | | |
| person1_e_mail | | | |
| person1_first_name | | | |
| person1_last_name | | | |
| requester | | | |
| 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 | | | |
| resolution | | | |
| cause | | | |
| description_long | | | |
| 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 | | | |
| archived_data | | | |
| Name | Description | System Data Type | Extract Data Type |
|---|
| ci_id |
|
|
|
| item_id |
|
|
|
| archived_data |
|
|
|
| Name | Description | System Data Type | Extract Data Type |
|---|
| parent_item_id |
|
|
|
| item_id |
|
|
|
| archived_data |
|
|
|
| Name | Description | System Data Type | Extract Data Type |
|---|
| item_id |
|
|
|
| action_created_date |
|
|
|
| actiontakendatetext |
|
|
|
| act_name | | | |
| act_description | | | |
| action_created_by_contact_id | | | |
| action_by_first_name | | | |
| action_by_last_name | | | |
| actiontakenby | | | |
| group_name | | | |
| assign_first_name | | | |
| assign_last_name | | | |
| assignedtoindividual | | | |
| assign_contact_id | | | |
| status | | | |
| status_reason_code | | | |
| status_end_date | | | |
| statusenddatetext | | | |
| archived_data | | | |
| Name | Description | System Data Type | Extract Data Type |
|---|
| item_id |
|
|
|
| row_id |
|
|
|
| ticket_type |
|
|
|
| case_id | | | |
| ticket_id | | | |
| work_type | | | |
| work_time_spent | | | |
| work_description | | | |
| work_created_date | | | |
| work_created_by_contact_id | | | |
| work_by_first_name | | | |
| work_by_last_name | | | |
| submitter | | | |
| clientviewable | | | |
| work_actual_date | | | |
| archived_data | | | |
| Name | Description | System Data Type | Extract Data Type |
|---|
| row_id |
|
|
|
| item_id |
|
|
|
| template_name |
|
|
|
| attr_name | | | |
| attr_data_type | | | |
| attr_value | | | |
| archived_data | | | |
| Name | Description | System Data Type | Extract Data Type |
|---|
| slice |
|
|
|
| row_id |
|
|
|
| agreement_id |
|
|
|
| metric_id | | | |
| item_id | | | |
| assigned_group_id | | | |
| group_name | | | |
| assigned_group_name | | | |
| affected_ci_id | | | |
| ci_name | | | |
| affected_ci_name | | | |
| assigned_contact_id | | | |
| last_name | | | |
| assigned_contact_last_name | | | |
| first_name | | | |
| assigned_contact_first_name | | | |
| qualifier_item_values | | | |
| instance_id | | | |
| process_status_code | | | |
| enum_value | | | |
| process_status | | | |
| modified_date | | | |
| Name | Description | System Data Type | Extract Data Type |
|---|
| item_id |
|
|
|
| row_id |
|
|
|
| ticket_type |
|
|
|
| agreement_name | | | |
| threshold_value_hhmm | | | |
| target_value_hhmmss | | | |
| sla_start_time | | | |
| sla_due_by | | | |
| compliance_status | | | |
| compliance_notes | | | |
| assigned_group_name | | | |
| affected_ci_name | | | |
| affected_ci | | | |
| archived_data | | | |
| slice | | | |
0 Comments