Skip to end of metadata
Go to start of metadata

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:

Entity: DTX _Incidents

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.

NameDescriptionSystem Data TypeExtract Data Type
item_idIdentifier of the ticket-specific details from APP_ITEMBIGINTLong Integer (4)
case_idCase IDBIGINTLong Integer (4)
ticket_id

An ID identifying a ticket

BIGINTLong 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. BIGINTMemo (-) 
 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    

Entity: DTX_Problems

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.

NameDescriptionSystem Data TypeExtract Data Type
item_idIdentifier of the ticket-specific details from APP_ITEMBIGINTLong Integer (4)
case_idCase IDBIGINTLong Integer (4)
ticket_idAn ID identifying a ticket.BIGINTLong 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. INTLong 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. BIGINTMemo (-) 
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. BIGINTLong 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. BIGINTLong 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 (-) 
severitySeverity 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. BIGINTLong Integer (4) 
modified_by_contact_id  modified_by_contact_id identifies the contact who modified the ticket. BIGINTLong Integer (4) 
person1_contact_id Identification for the contact who is the requester of the ticket. BIGINTLong Integer (4) 
person2_contact_id  Identification for the contact who is the requester of the ticket. BIGINTLong Integer (4) 
ci_name    
affected_service Affected service. BIGINTMemo (-) 
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   

Entity: DTX_Tasks

NameDescriptionSystem Data TypeExtract Data Type
item_idIdentifier of the ticket-specific details from APP_ITEMBIGINTLong Integer (4)
case_idCase IDBIGINTLong Integer (4)
ticket_idAn ID identifying a ticket.BIGINTLong Integer (4)
ticket_statusStatus 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. INTLong 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    

Entity: DTX_Changes

NameDescriptionSystem Data TypeExtract 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    

Entity: DTX_Ticket_Approvals

NameDescriptionSystem Data TypeExtract 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    

Entity: DTX_Service Requests

NameDescriptionSystem Data TypeExtract 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    

Entity: DTX_Ticket_CI_Relationship

NameDescriptionSystem Data TypeExtract Data Type
ci_id


item_id


archived_data


Entity: DTX_Ticket_Ticket_Relationship

NameDescriptionSystem Data TypeExtract Data Type
parent_item_id


item_id


archived_data


Entity: DTX_History

NameDescriptionSystem Data TypeExtract 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    

Entity: DTX_Work_Log

NameDescriptionSystem Data TypeExtract 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    

Entity: DTX_Custom_Fields

NameDescriptionSystem Data TypeExtract Data Type
row_id


item_id


template_name


attr_name    
attr_data_type    
attr_value    
archived_data    

Entity: DTX_VARC_SLA_Qualifying_Items

NameDescriptionSystem Data TypeExtract 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    

Entity: DTX_SLA_Compliance

NameDescriptionSystem Data TypeExtract 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   


  • No labels

© 2019 Serviceaide 1-650-206-8988 http://www.serviceaide.com info@serviceaide.com