Delta Extracts

Delta Extracts are used to extract data that are modified between a desired start date and end date. For some delta extract entities like relationship tables, you can extract all the data irrespective of date-range specified. This section provides information on the field values of an entity that is made available in Delta Extracts. The following entities are available for your reference:

Entity: CHANGES

Changes refer to the Change Tickets logged and updated in your instance. Details in the following fields of the Change 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	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 (-)
createdByName	Name of ticket creator	--	Memo (-)
assigned_to_group_name	Name of group to whom ticket is assigned	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 (-)
modifiedByName	Last Ticket modified	--	Memo (-)
person1_e_mail	Requester email	NVARCHAR(126)	Memo (-)
Requester	Name of the requester	BIGINT	Memo (-)
person1_job_title	Requester job title	NVARCHAR(126)	Memo (-)
person1_phone1	Requester phone number	NVARCHAR(50)	Memo (-)
person1_org_name	Requester organization name	NVARCHAR(50)	Memo (-)
person1_hierarchical_path	The organization hierarchical path of requester	NVARCHAR(4000)	Memo (-)
person2_e_mail	Requested For email id	NVARCHAR(126)	Memo (-)
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_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 used to resolve this ticket	BIGINT	Long Integer (4)
person2_alt_phone	Phone number of Requested For/Whom to Contact For/Who is Having the Issue/Requested on Behalf of contact for this ticket	NVARCHAR(50)	Memo (-)
person2_alt_email	Email address of Requested For/Whom to Contact For/Who is Having the Issue/Requested on Behalf of 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)
person2_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

Entity: CI_ CUSTOM_FIELDS

CI_ CUSTOM_FIELDS refers to the attributes from a CI attribute template which gets related to a CI record. Details from the following fields on the CI and CI Attribute template are available in the extract.

Name

Description

System Data Type

Extract Data Type

ci_id

The configuration item (CI) with which the Custom Field is related.

BIGINT

Long Integer (4)

template_name

The name of the custom attribute template

NVARCHAR(126)

Text (126)

attr_data_type

The data type of the attribute value. The Allowed values are listed: - Text (1): A sequence of characters, such as words and sentences that are entered as a single line. - Number (2): An input element whose value is "number" represents a precise control for setting the value of the element to a string representing a number. - DateTime (3): An input element that contains both date and time information. The date and time value is stored in seconds in the database. - List (4): A list is useful for allowing the selection from a list of values/options. - MultiLineText (5): A sequence of characters, such as words and sentences that are entered into multiple lines that are separated by a carriage-return. - Checkboxes (6): A group of checkboxes to select one or more items out of many choices. – Radio Buttons (7): A group of radio button controls that act as a single mutually exclusive control; therefore, a user can select only one Radio Button control at a time. - Section Header (8): A section header element allows it being associated with other input elements, and thus enabling breaking the screen up into sections by laying out various field elements into smaller logical groupings and also displaying a header/text at the beginning of each group.

INT

Text (100)

attr_name

A name that uniquely identifies the custom attribute.

NVARCHAR(100)

Text (100)

attr_value

The value that is assigned to the CI attribute.

NVARCHAR(4000)

Memo (-)

Entity: CONFIGURATION_ITEMS

CONFIGURATION_ITEMS refers to the CI records stored in your instance. Details in the following fields of a CI record are available in the extract.

Name

Description

System Data Type

Extract Data Type

ci_id

The Configuration Item ID.

BIGINT

Long Integer (4)

ci_name

The Configuration Item name.

NVARCHAR(128)

Text (255)

ci_function

The Configuration Item function descriptor.

NVARCHAR(50)

Text (255)

ci_identifier

The Configuration Item identifier.

NVARCHAR(50)

Text (255)

ci_description

The Configuration Item description.

NVARCHAR(256)

Memo (-)

ci_ccti_id

The categorization for the configuration item.

BIGINT

Long Integer (4)

ccti_class

The Configuration Item class.

NVARCHAR(50)

Text (50)

ccti_category

The Configuration Item category.

NVARCHAR(50)

Text (50)

ccti_type

The Configuration Item type.

NVARCHAR(50)

Text (255)

ccti_item

The Configuration Item item.

NVARCHAR(50)

Text (255)

ci_status

The Configuration Item status.

NVARCHAR(50)

Text (255)

ci_org_name

The Configuration Item primary organization name.

NVARCHAR(50)

Text (255)

ci_contact_id

Id of the primary owner/contact person for the configuration item.

BIGINT

Long Integer (4)

ci_contact_name

The primary owner/contact person for the configuration item.

- -

Text (255)

contact_org_name

Organization of primary owner/contact person for the configuration item.

NVARCHAR(50)

Text (255)

created_by_contact_id

The contact person who created this configuration item.

BIGINT

Long Integer (4)

created_by_contact_name

The contact person who created this configuration item.

- -

Text (255)

modified_by_contact_id

modified_by_contact_id identifies the contact who modified the ticket.

BIGINT

Long Integer (4)

modified_by_contact_name

The contact person who last modified this configuration item.

- -

Text (255)

created_date

Date in milliseconds when the ticket is created.

INT

Long Integer (4)

modified_date

The date on which the configuration item was last modified.

INT

Long Integer (4)

ci_status_date

The date on which the configuration item was brought/moved into the current status.

INT

Long Integer (4)

createddatetext

Date in milliseconds when the ticket is created in formatted text (DD/MM/YYYY).

- -

Date/Time (8)

modifieddatetext

The date on which the configuration item was last modified in formatted text (DD/MM/YYYY).

- -

Date/Time (8)

cistatusdatetext

Configuration Item status in formatted text (DD/MM/YYYY)

- -

Date/Time (8)

ciorg_hierarchical_path

The Configuration Item organization hierarchical path

NVARCHAR(4000)

Memo (-)

contact_org_hierarchical_path

Organization hierarchy path of primary owner/contact person for the configuration item

NVARCHAR(4000)

Memo (-)

Entity: CONTACTS

CONTACTS refers to the Contact records stored in your instance. Details in the following fields of the Contact record are available in the extract.

Name

Description

System Data Type

Extract Data Type

row_id

Record Identifier.

BIGINT

Long Integer (4)

e_mail

Email address of the contact.

NVARCHAR(126)

Memo (-)

employee_id

Employee ID.

NVARCHAR(50)

Memo (-)

first_name

first_name specifies the first name of the contact.

NVARCHAR(50)

Memo (-)

last_name

Last name of the contact.

NVARCHAR(50)

Memo (-)

job_title

Job title of the contact.

NVARCHAR(126)

Memo (-)

phone_type1

Category for Phone1

NVARCHAR(50)

Memo (-)

phone_type2

Category for Phone2

NVARCHAR(50)

Memo (-)

phone1

Phone number of contact

NVARCHAR(50)

Memo (-)

Phone2

Alternative phone number of contact

NVARCHAR(50)

Memo (-)

contact_role

Role of Contact

NVARCHAR(50)

Memo (-)

rel_state

This status is an indicator that the record is: 0 Active, 1 Marked as delete

INT

Long Integer (4)

created_date

Created Date

INT

Long Integer (4)

created_by_contact_id

The contact person who created this contact.

BIGINT

Long Integer (4)

modified_by_contact_id

modified_by_contact_id identifies the contact who modified the ticket.

BIGINT

Long Integer (4)

modified_date

Date in milliseconds when the ticket is modified.

INT

Long Integer (4)

ModifiedDateText

Modified Date in formatted text (DD/MM/YYYY)

- -

Date/Time (8)

CreatedDateText

Created Date in formatted text (DD/MM/YYYY)

- -

Date/Time (8)

createdBy

Contact created by

- -

Memo (-)

modifiedBy

Contact modified by

- -

Memo (-)

user_login

user_login specifies the user login.

NVARCHAR(255)

Memo (-)

user_license_type

The user License type

INT

Long Integer (4)

vip_user

vip_user indicates that a Contact is a VIP.

INT

Memo (-)

org_name

Organization of the contact

NVARCHAR(50)

Memo (-)

org_hierarchical_path

The hierarchical path for organization of the contact

NVARCHAR(4000)

Memo (-)

Entity: CUSTOM_FIELDS

CUSTOM_FIELDS refers to the custom fields that get applied to a ticket from an applicable Custom Field Template. Details in the following fields that are related to Ticket Custom Fields are available in the extract.

Name

Description

System Data Type

Extract Data Type

item_id

Identifier of the custom field details.

BIGINT

Long Integer (4)

template_name

The name of the custom attribute template.

NVARCHAR(126)

Text (126)

attr_data_type

Attribute data type

INT

Text (100)

attr_name

attr_name specifies the attribute name.

NVARCHAR(100)

Text (100)

attr_value

Attribute value

NVARCHAR(4000)

Memo (-)

Entity: FEEDBACK_RESPONSES

FEEDBACK_RESPONSES refers to the response received from Respondents to a Feedback Schedule. The following information that is related to Feedback Response is available in the extract.

Name

Description

System Data Type

Extract Data Type

schedule_id

The ID associated with Feedback Schedule under which the feedback form is sent to participants.

BIGINT

Long Integer (4)

fb_form_id

The ID associated with the Feedback Survey Form

BIGINT

Long Integer (4)

fb_form_question_id

The question on which the response is provided.

BIGINT

Long Integer (4)

answer_submitted

The customer response to the question within the feedback form questionnaire

NVARCHAR(1284)

Memo (-)

notification_date

The notification date

INT

Long Integer (4)

notification_datetext

The notification date in formatted text (DD/MM/YYYY)

- -

Date/Time (8)

responded_date

The responded date

INT

Long Integer (4)

responded_datetext

The responded date in formatted text (DD/MM/YYYY)

- -

Date/Time (8)

valid_untill_date

Date until when Feedback response can be made.

INT

Long Integer (4)

contact_id

The ID of customer contact person who provides feedback on the quality and adequacy of the delivered services.

BIGINT

Long Integer (4)

contact_name

The customer contact person who provides feedback on the quality and adequacy of the delivered services.

- -

Text (255)

feedback_id

The ID associated with the unique notification generated by the scheduler for each recipient.

BIGINT

Long Integer (4)

item_id

Ticket Id, in case the feedback schedule was triggered based on tickets.

BIGINT

Long Integer (4)

Entity: HISTORY

HISTORY refers to the history of all actions that are applied to a ticket (both manual and automated actions). The following information that is related to the History of a ticket is 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)

ActionTakenDateText

The action that is taken in formatted text (DD/MM/YYYY).

- -

Date/Time (8)

action_created_date

The date when this action occurred

INT

Long Integer (4)

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 (-)

ActionTakenBy

Identifies the action that is taken on a ticket.

- -

Memo (-)

group_name

The group that acted on a ticket.

NVARCHAR(50)

Memo (-)

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)

Entity: 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.

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 (-)

createdByName

Name of the ticket creator.

- -

Memo (-)

assigned_to_group_name

Name of group to whom ticket is assigned.

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 (-)

modifiedByName

Last Ticket modified.

- -

Memo (-)

person1_e_mail

Requester email.

NVARCHAR(126)

Memo (-)

Requester

Requester name.

BIGINT

Memo (-)

person1_job_title

Requester job title.

NVARCHAR(126)

Memo (-)

person1_phone1

Requester phone number.

NVARCHAR(50)

Memo (-)

person2_e_mail

Requested For email id.

NVARCHAR(126)

Memo (-)

Requester2

Name of the Requested

BIGINT

Memo (-)

person2_job_title

Requested For job title

NVARCHAR(126)

Memo (-)

person2_phone1

Requested For phone number

NVARCHAR(50)

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 Requested For/Whom to Contact For/Who is Having the Issue/Requested on Behalf of contact for this ticket.

NVARCHAR(50)

Memo (-)

person2_alt_email

Email address of Requested For/Whom to Contact For/Who is Having the Issue/Requested on Behalf of 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 (-)

description_long

Long description of the incident faced.

NVARCHAR(4000)

Memo (-)

this_ticket_is

this_ticket_is specifies that the ticket is global.

NVARCHAR(50)

Memo (-)

related_to_global_issue_id

Related Global Issue ID

NVARCHAR(50)

Memo (-)

created_by_contact_id

The contact person who created this incident 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)

person1_org_name

Requester organization name

NVARCHAR(50)

Memo (-)

person1_hierarchical_path

Requester organization hierarchical path

NVARCHAR(4000)

Memo (-)

person2_org_name

Requested For organization name

NVARCHAR(50)

Memo (-)

person2_hierarchical_path

Requested For organization hierarchical path

NVARCHAR(4000)

Memo (-)

Entity: 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.

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 (-)

createdByName

Name of the ticket creator.

- -

Memo (-)

assigned_to_group_name

Name of group to whom ticket is assigned.

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 (-)

modifiedByName

Last Ticket modified

- -

Memo (-)

person1_e_mail

Requester email

NVARCHAR(126)

Memo (-)

Requester

Requester name

BIGINT

Memo (-)

person1_job_title

Requester job title

NVARCHAR(126)

Memo (-)

person1_phone1

Requester phone number

NVARCHAR(50)

Memo (-)

person2_e_mail

Requested For email id

NVARCHAR(126)

Memo (-)

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 (-)

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 Requested For/Whom to Contact For/Who is Having the Issue/Requested on Behalf of contact for this ticket.

NVARCHAR(50)

Memo (-)

person2_alt_email

Email address of Requested For/Whom to Contact For/Who is Having the Issue/Requested on Behalf of 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 (-)

this_ticket_is

this_ticket_is specifies that the ticket is global.

NVARCHAR(50)

Memo (-)

related_to_global_issue_id

Related Global Issue ID.

NVARCHAR(50)

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)

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)

person1_org_name

Requester organization name

NVARCHAR(50)

Memo (-)

person1_hierarchical_path

Requester organization hierarchical path

NVARCHAR(4000)

Memo (-)

person2_org_name

Requested For organization name

NVARCHAR(50)

Memo (-)

person2_hierarchical_path

Requested For organization hierarchical path

NVARCHAR(4000)

Memo (-)

Entity: SERVICE_REQUEST

SERVICE_REQUEST refers to the Service Request logged and updated in your instance. Details in the following fields of the Service Requests 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)

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

Name of the ticket creator.

- -

Memo (-)

assigned_to_group_name

Name of group to whom ticket is assigned.

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 (-)

modifiedByName

Last Ticket modified

- -

Memo (-)

person1_e_mail

Requester email

NVARCHAR(126)

Memo (-)

Requester

Requester name

BIGINT

Memo (-)

person1_job_title

Requester job title

NVARCHAR(126)

Memo (-)

person1_phone1

Requester phone number

NVARCHAR(50)

Memo (-)

person2_e_mail

Requested For email id

NVARCHAR(126)

Memo (-)

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 (-)

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 Requested For/Whom to Contact For/Who is Having the Issue/Requested on Behalf of contact for this ticket.

NVARCHAR(50)

Memo (-)

person2_alt_email

Email address of Requested For/Whom to Contact For/Who is Having the Issue/Requested on Behalf of 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)

person1_org_name

Requester organization name

NVARCHAR(50)

Memo (-)

person1_hierarchical_path

Requester organization hierarchical path

NVARCHAR(4000)

Memo (-)

person2_org_name

Requested For organization name

NVARCHAR(50)

Memo (-)

person2_hierarchical_path

Requested For organization hierarchical path

NVARCHAR(4000)

Memo (-)

Entity: SLA_COMPLIANCE

SLA_COMPLIANCE refers to the SLA Compliance for tickets to which the SLA targets are applied in your instance. The following information that is related to SLA Compliance of tickets is available in the extract.

Name

Description

System Data Type

Extract Data Type

item_id

Item ID

BIGINT

Double (8)

row_id

Record Identifier

BIGINT

Long Integer (4)

ticket_type

Type of the ticket (Service Request/Incident/Problem/Change/Task)

NVARCHAR(50)

Memo (-)

agreement_name

The service level agreement name

NVARCHAR(128)

Memo (-)

threshold_hhmm

The particular threshold record that defines the target value for a particular service level agreement metric.

NVARCHAR(15)

Memo (-)

target_hhmm

The service level target value against which the service level metric was compared to identify the violation.

NVARCHAR(15)

Memo (-)

sla_start_time

The starting date that is defined in the service level agreement that is, SLA.

INT

Double (8)

sla_due_by

The value of the SLA Threshold determines the due date that is defined in the applicable service level agreement. That is, SLA Target configuration and the starting date timer. The timers are based on the business operating scheduler (working-hour) calendars.

INT

Double (8)

compliance_status

The measured compliance status indicator against the predefined service level agreement (SLA) targets. For example, Allowed Values - 0: In Progress, 1: Met SLA, 2: Missed SLA, 3: Approaching Violation Threshold, 4:Aborted, 5:Completed, 6: Ignored, 7: Paused.

INT

Memo (-)

compliance_notes

The special notes/remarks regarding the achievement or breach of the service level agreement (SLA) targets for a support request (ticket).

NVARCHAR(4000)

Memo (-)

assigned_group_name

The assignment support group for the support request (ticket) for which the service metric value is calculated.

- -

Memo (-)

affected_ci

Affected CI

- -

Memo (-)

Entity: SOLUTIONS

SOLUTIONS refers to the solutions stored as knowledge articles in your instance. Details in the following fields of knowledge articles are available in the extract.

Name

Description

System Data Type

Extract Data Type

ROW_ID

Record Identifier

BIGINT

Decimal (16)

SOL_SYMPTOM

The symptom that caused the need for this solution.

NVARCHAR(256)

Memo (-)

SOL_SYMPTOM_DETAIL

The detailed description of the symptom that caused the need for this solution.

NVARCHAR(4000)

Memo (-)

SOL_RESOLUTION

The resolution of the symptom that caused the need for this solution.

NVARCHAR(4000)

Memo (-)

SOL_CAUSE

The cause of the symptom that caused the need for this solution.

NVARCHAR(4000)

Memo (-)

CCTI_ID

The CCTI combination for which this solution was required.

BIGINT

Decimal (16)

SOL_CREATED_DATE

The date when the user created the solution record.

INT

Long Integer (4)

SOL_CREATED_CONTACT_ID

The contact person who figured out the solution.

BIGINT

Decimal (16)

SOL_MODIFIED_DATE

The last date when the user modified the solution record.

INT

Long Integer (4)

SOL_MODIFIED_CONTACT_ID

The contact person who modified the solution.

BIGINT

Decimal (16)

REL_STATE

The record is: 0 Active, 1 Marked as delete.

INT

Long Integer (4)

SOL_CATEGORY

The associated categorization for classification of this solution.

NVARCHAR(30)

Memo (-)

SOL_STATUS

Solution Status

NVARCHAR(30)

Memo (-)

Entity: TASKS

TASKS refers to the Tasks tickets logged and updated in your instance. Details in the following fields of the Tasks 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)

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

Name of the ticket creator.

- -

Memo (-)

assigned_to_group_name

Name of group to whom ticket is assigned.

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 (-)

modifiedByName

Last Ticket modified.

- -

Memo (-)

person1_e_mail

Requester email.

NVARCHAR(126)

Memo (-)

Requester

Requester name.

BIGINT

Memo (-)

person1_job_title

Requester job title.

NVARCHAR(126)

Memo (-)

person1_phone1

Requester phone number.

NVARCHAR(50)

Memo (-)

person2_e_mail

Requested For email id.

NVARCHAR(126)

Memo (-)

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 (-)

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 (-)

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 (-)

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 (-)

parent_item_id

Parent ticket ID

BIGINT

Long Integer (4)

parent_ticket_type

Parent ticket type

NVARCHAR(50)

Memo (-)

ticket_impact

Ticket impact

NVARCHAR(50)

Text (255)

ticket_urgency

Ticket Urgency

NVARCHAR(50)

Text (255)

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)

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)

person1_org_name

Requester organization name

NVARCHAR(50)

Memo (-)

person1_hierarchical_path

Requester organization hierarchical path

NVARCHAR(4000)

Memo (-)

person2_org_name

Requested For organization name

NVARCHAR(50)

Memo (-)

person2_hierarchical_path

Requested For organization hierarchical path

NVARCHAR(4000)

Memo (-)

Entity: TICKET_APPROVALS

TICKET_APPROVALS refers to the Change tickets that were part of the Approval cycle in your instance. The following details regarding ticket Approvals are available in the extract.

Name

Description

System Data Type

Extract Data Type

item_id

The item identifier of the change request that is submitted for approval.

BIGINT

Long Integer (4)

appr_history_id

The approval routing process history record to which the support request (ticket) approval record is associated.

BIGINT

Long Integer (4)

appr_phase

The lifecycle phase/stage of the support request (ticket) when the approval routing process was initiated.

NVARCHAR(256)

Memo (-)

appr_status

The approval status of the support request (ticket) when the approval routing process was initiated.

NVARCHAR(256)

Text (255)

appr_voting_type

The approval voting process that is in force for the current approval stage. Allowed Values - 0: A service desk ticket is treated as approved or rejected only when all of the designated/authorized voting members have submitted their approval or denial decisions. 1: A service desk ticket is treated as approved or rejected when any one of the designated/authorized voting members has submitted their approval or denial decision.

INT

Text (255)

approver_id

Id of the approver

BIGINT

Long Integer (4)

approver_name

Name of approver

- -

Text (255)

approver_role

A flag that denotes whether the contact has been designated as an approver or a reviewer.

NVARCHAR(20)

Text (255)

group_name

Approval group name

NVARCHAR(126)

Text (255)

decision

Approval decision (approved/rejected/need more information)

NVARCHAR(30)

Text (255)

decision_date

Date of approval decision

INT

Long Integer (4)

decision_datetext

Date of approval decision in formatted text (DD/MM/YYYY)

- -

Date/Time (8)

approver_comment

The review decisions, observations, suggestions, or extra information requirements regarding the submitted change

NVARCHAR(4000)

Memo (-)

Entity: WORK_LOG

WORK_LOG refers to the Worklogs entered into tickets. Details in the following fields of the Worklog are available in the extract.

Name

Description

System Data Type

Extract Data Type

item_id

Item ID

BIGINT

Long Integer (4)

row_id

Record Identifier

BIGINT

Long Integer (4)

ticket_type

Type of the ticket (Service Request/Incident/Problem/Change/Task)

NVARCHAR(50)

Memo (-)

case_id

Case id

BIGINT

Long Integer (4)

ticket_id

An ID identifying a ticket

BIGINT

Long Integer (4)

work_type

Type of work done

INT

Memo (-)

work_time_spent

Time that is spent on the work.

INT

Long Integer (4)

work_description

Description of Work that is done in the ticket.

NVARCHAR(4000)

Memo (-)

work_created_date

Date of creating worklog.

INT

Long Integer (4)

work_created_by_contact_id

The contact person who created this worklog.

BIGINT

Long Integer (4)

Submitter

The creator of the Worklog.

- -

Memo (-)

ClientViewable

Worklog type

INT

Memo (-)

The following entities provide you with all the data in a given slice irrespective of the date range specified.

Entity: CI_CI_RELATIONSHIP

CI_CI_RELATIONSHIP refers to the relationship between one or more CI in your instance. The following details regarding the CI relationships are available in the extract.

Name

Description

System Data Type

Extract Data Type

parent_ci_id

The parent configuration item to which another CI is related.

BIGINT

Long Integer (4)

ci_id

The configuration item which holds a relationship with the parent CI.

BIGINT

Long Integer (4)

domain_type

The relationship domain for the configuration items indicating physical or logical connections between CIs

NVARCHAR(50)

Text (255)

rel_description

The description gives an overview of the context and usage of the relationship type.

NVARCHAR(126)

Text (255)

Entity: CI_CONTACT_RELATIONSHIP

CI_CONTACT_RELATIONSHIP refers to the CI to the Contacts relationship in your instance. Details n the following fields in the relationship are available in the extract.

Name

Description

System Data Type

Extract Data Type

ci_id

The configuration item (CI) with which the contact is related.

BIGINT

Long Integer (4)

contact_id

The contact person that is associated with the configuration item (CI).

BIGINT

Long Integer (4)

contact_name

Name of the contact that is associated with the Configuration Item.

- -

Text (255)

group_id

The support group that is associated with the configuration item (CI).

BIGINT

Long Integer (4)

group_name

Group Name that is associated with CI.

NVARCHAR(50)

Text (255)

ci_contact_rel_type

The configuration item and contact relationship descriptor

BIGINT

Text (255)

Entity: 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

item_id

Item ID

BIGINT

Long Integer (4)

ci_id

The associated configuration item to the ticket

BIGINT

Long Integer (4)

Entity: 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)

Entity: CATEGORIZATION

Categorization refers to the CCTI records created and stored in your instance. Only active CCTI records are fetched in Delta extract. Details in the following fields of the CCTI record are available in the extract.

Name	Description	System Data Type	Extract Data Type
row_id	Record Identifier	BIGINT	Long Integer (4)
class	The value of the CLASS field	NVARCHAR(50)	Memo (-)
category	The value of the CATEGORY field	NVARCHAR(50)	Memo (-)
type	The value of the TYPE field	NVARCHAR(50)	Memo (-)
item	The value of the ITEM field	NVARCHAR(50)	Memo (-)
ticket_types	Type of the ticket (Service Request/Incident/Problem/Change/Task) and Configuration Items	- -	Memo (-)

Entity: FEEDBACK_QUESTIONS

FEEDBACK_QUESTIONS refers to the questions included in Feedback Forms that you configure. The following information that is related to Feedback Questions is available in the extract.

Name

Description

System Data Type

Extract Data Type

fb_form_id

The feedback form with which the question is associated.

BIGINT

Long Integer (4)

question_id

ID of Feedback question

BIGINT

Long Integer (4)

question_type

The choice of question type on the feedback questionnaire

NVARCHAR(50)

Text (225)

sequence_no

The sequence number for the question

INT

Long Integer (4)

question_description

The question on the feedback questionnaire

NVARCHAR(256)

Memo (-)

is_mandatory

is_mandatory identifies whether a response to this question is mandatory (required).

INT

Long Integer (4)

allowed_values

The list of allowable options in case of a multiple choice question

NVARCHAR(1284)

Memo (-)

Entity: SERVICE_FEEDBACK

SERVICE_FEEDBACK refers to the Service Feedback Schedules in your instance. The following information that is related to Service Feedback Schedules is available in the extract.

Name

Description

System Data Type

Extract Data Type

schedule_id

The notification schedule with which the notification is associated.

BIGINT

Long Integer (4)

fb_form_id

The feedback form that must be filled in by the participant.

BIGINT

Long Integer (4)

schedule_name

The service feedback notification schedule name

NVARCHAR(128)

Text (255)

fb_form_name

Service feedback form name

NVARCHAR(128)

Text (255)

schedule_description

The service feedback notification schedule description

NVARCHAR(256)

Memo (-)

schedule_status

The current status of the feedback notification schedule. Allowed Values: Not Initiated, Initiated, Aborted, Completed.

NVARCHAR(50)

Text (255)

schedule_start_date

The start date for the notification schedule.

INT

Long Integer (4)

schedule_start_datetext

The start date for the notification schedule in formatted text (DD/MM/YYYY).

- -

Date/Time (8)

schedule_end_date

The date when the notification schedule ends.

INT

Long Integer (4)

schedule_end_datetext

The date when the notification schedule ends in formatted text (DD/MM/YYYY).

- -

Date/Time (8)

repeat_type

The recurrence pattern for the notification schedule.

NVARCHAR(50)

Text (255)

repeat_count

The counter that identifies the number of days or tickets after which to initiate a notification.

INT

Long Integer (4)

number_of_tickets

Number of tickets.

INT

Long Integer (4)

repeat_for_ticket_types

The type of support requests to which service feedback recurrence option for "X Number of Tickets" is applied.

INT

Memo (-)

anonymous_submissions

anonymous_submissions specifies whether feedback filled out by the respondents are submitted anonymously to the system.

INT

Long Integer (4)

allow_duplicate_response_submissions

allow_duplicate_response_submissions specifies whether respondents are allowed to fill out and to submit multiple feedback.

INT

Long Integer (4)

auto_close_in_days

The number of days (from the notification date) within which customer feedback is allowed.

INT

Long Integer (4)

response_notifications_to

The list of recipients who are notified when a customer submits a service satisfaction feedback form.

NVARCHAR(512)

Memo (-)

participant_type

The participant type (respondent) for the notification schedule. For example, Allowed Values: Organization, Support Group, Contact.

NVARCHAR(50)

Text (255)

participant_names

Feedback participant name

- -

Memo (-)

created_date

The date on which the feedback form was created.

INT

Long Integer (4)

created_datetext

The date on which the feedback form was created in formatted text (DD/MM/YYYY)

- -

Date/Time (8)

created_by_contact_id

The contact person who created the feedback form.

BIGINT

Long Integer (4)

created_by_contact_name

created_by_contact_name specifies the name of the feedback scheduler.

- -

Text (255)

modified_date

The date on which the feedback schedule was modified.

INT

Long Integer (4)

modified_datetext

The date on which the feedback schedule was modified in formatted text (DD/MM/YYYY)

- -

Date/Time (8)

modified_by_contact_id

ID of the contact person who modified the feedback form.

BIGINT

Long Integer (4)

modified_by_contact_name

The contact person who modified the feedback form.

- -

Text (255)