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 7
Next »
The following entities are present in the DTX extracts:
| Name | Description | System Data Type | Extract Data Type |
|---|
| item_id |
| BIGINT |
|
| case_id |
| BIGINT |
|
| ticket_id |
| BIGINT |
|
| ticket_status | | | |
| ticket_reason_code | | | |
| modifieddatetext | | | |
| createddatetext | | | |
| modified_date | | INT | |
| 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 | | | |
| severity | | | |
| ticket_phase | | | |
| ticket_source | | | |
| ticket_impact | | | |
| ticket_urgency | | | |
| archived_data | | | |
| Name | Description | System Data Type | Extract Data Type |
|---|
| item_id |
|
|
|
| case_id |
|
|
|
| ticket_id |
|
|
|
| ticket_status | | | |
| ticket_reason_code | | | |
| modifiedatetext | | | |
| 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 | | | |
| severity | | | |
| description_long | | | |
| created_by_contact_id | | | |
| assigned_to_contact_id | | | |
| modified_by_contact_id | | | |
| person1_contact_id | | | |
| person2_contact_id | | | |
| ci_name | | | |
| affected_service | | | |
| ticket_phase | | | |
| ticket_source | | | |
| ticket_impact | | | |
| ticket_urgency | | | |
| 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 | | | |
| 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 | | | |
Add Comment