Level AI - Data Export Schema 2.0

Last updated: September 2, 2026

Level AI provides a comprehensive Data exports and the exports schema is mentioned below. First table lists all the tables and their definitions. You can then scroll through individual tables to know about the exact data columns and their definition

Supported Tables

S.NO	OBJECT_NAME	DETAILS
1	AUDITLOG_CUSTOM_AUDITLOGENTRY	Audit info for various entities in the platform.
2	LEVEL_NLP_METRICTAGRULECONDITION	List of conditions when a metric tag must be applied.
3	LEVEL_NLP_SENTIMENTTAG	List of sentiment tags defined for the tenant.
4	QUALITY_ASSESSMENT_CUSTOMFORMCATEGORY	Contains a list of rubric categories.
5	QUALITY_ASSESSMENT_CUSTOMFORMSECTION	Contains a list of rubric sections.
6	QUALITY_ASSESSMENT_CUSTOMFORMTHRESHOLDS	Threshold for outcome buckets present in Rubric settings.
7	ACCOUNTS_ORGANIZATION	Divisions within a tenant: Used to separate data by different geographies, business units, etc.
8	ACCOUNTS_TEAM	Grouping of users to represent team assignments.
9	ACCOUNTS_TEAMMEMBER	Contains actual user-to-team MxN mapping.
10	ACCOUNTS_USERPROFILE	Additional user information mapped to the source of information (CRM, Manual, SSO, etc.).
11	ACCOUNTS_USER	User information (passwords and secrets are filtered out).
12	ACCOUNTS_USERORGANIZATIONS	Contains mapping between users to their respective organizations
13	BANKING_BANKINGCONVERSATION	Represents a conversation assigned to a real user. This ID is labeled as Conversation ID in the UI.
14	LEVEL_ASR_ASRLOG	This is the basic unit of a conversation in the platform. All actions are performed on this unit.
15	CFANSWER	Contains rubric manual and auto-scored question answers for a given conversation.
16	QUALITY_ASSESSMENT_CUSTOMFORMQUESTION	Contains a list of rubric questions.
17	QUALITY_ASSESSMENT_CUSTOMFORM	Rubric definitions.
18	METRICS	Metrics mapped to ASRLog.
19	QUALITY_ASSESSMENT_VOICECONVERSATIONMETRICS	Metrics specific to audio conversations.
20	QUALITY_ASSESSMENT_CHATCONVERSATIONMETRICS	Metrics specific to chat conversations.
21	QUALITY_ASSESSMENT_EMAILCONVERSATIONMETRICS	Metrics specific to email conversations.
22	QUALITY_ASSESSMENT_QAAUTOMATIONRULE	Task assignment rules.
23	MOMENT	Mapping of tags against ASR Log.
24	LEVEL_NLP_INTENTTOPICS	ASRLog to Category Mapping.
25	LEVEL_NLP_SCRIPTINGRULE	List of conversation tags.
26	LEVEL_NLP_CONCERNMININGSUBTOPIC	List of Voice of Customer subtopics generated by AI.
27	LEVEL_NLP_CATEGORY	List of categories generated by AI.
28	LEVEL_NLP_CONCERNMININGHEADTOPIC	List of Voice of Customer head topics generated by AI.
29	LEVEL_NLP_METRICTAGRULE	List of metrics defined for the tenant.
30	LEVEL_NLP_CONCERNMININGOUTPUT	Mapping of concern for Conversation (ASRLog).
31	QA_CALIBRATIONS_CALIBRATIONSESSION	List of Calibration Session Data.
32	QA_CALIBRATIONS_CALIBRATIONSESSIONCONVERSATION	Contains the linkage between sessions and conversations.
33	QA_CALIBRATIONS_SESSIONPARTICIPANTRESPONSE	Contains metrics about responses added by participants.
34	QA_CALIBRATIONS_PARTICIPANTRESPONSECOMMENT	Contains comments made on calibration through the Response page.
35	QA_CALIBRATIONS_SESSIONANALYTICS	Stores Calibration Session Level metrics.
36	QA_CALIBRATIONS_SESSIONPARTICIPANTANSWER	Contains responses added by participants.
37	LEVEL_ASR_ASRTRANSCRIPTIONLOG	List of transcripts for a given conversation.
38	AGENT_COACHING_COACHINGSESSION	Coaching sessions
39	AGENT_COACHING_COMMENT	Comments on coaching sessions
40	QUALITY_ASSESSMENT_INSTAREVIEWTAGS	Suggest summary of conversation if it has positive annotation or negative annotation and whether it has sufficient information to analyse the whole conversation or not. 1 - to - 1 mapping with asr_log table
41	CONVO_SPEAKER_UTTERANCES	List of all the utterances from customer and agent for every Conversation (ASRLog)
42	MANUALSCORE	List of all the manual scores done for a custom form on a conversation.
43	INSTASCORE	List of all the insta scores done for a custom form on a conversation.
44	QA_METRICS	Primarily this table is used to track evaluation duration of conversations which has been evaluated manually
45	JOURNEY_JOURNEY
46	JOURNEY_AIJOURNEYMETRICS
47	JOURNEY_JOURNEYMETRICS
48	LEVEL_ASR_JOURNEYSUMMARY
49	LEVEL_ASR_JOURNEYSUMMARYMETADATA
50	LEVEL_NLP_JOURNEYCONCERNMININGOUTPUT

1. AUDITLOG_CUSTOM_AUDITLOGENTRY

COLUMN_NAME	DATA_TYPE	DESCRIPTION
UUID	TEXT	Universally unique identifier for the log entry.
ROOT_OBJECT_PK	TEXT	Primary key of the root object associated with the log entry.
ROOT_OBJECT_ID	NUMBER	Identifier of the root object associated with the log entry.
REMOTE_ADDR	TEXT	IP address of the remote device or user.
ID	NUMBER	Unique identifier for each audio log entry.
TIMESTAMP	TIMESTAMP_NTZ	Date and time when the log entry was recorded.
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization associated with the log entry.
ROOT_OBJECT_TYPE_ID	NUMBER	Identifier of the type of root object associated with the log entry.
ADDITIONAL_DATA	TEXT	Additional data or information related to the log entry.
ACTOR_ID	NUMBER	Identifier of the actor associated with the log entry.

2. LEVEL_NLP_METRICTAGRULECONDITION

COLUMN_NAME	DATA_TYPE	DESCRIPTION
METRIC_DESCRIPTION	TEXT	Text describing the metric associated with the condition.
UNIT	TEXT	Text indicating the unit of measurement for the metric.
RULE_ID	NUMBER	Identifier referencing the rule associated with the condition.
THRESHOLD_OPTIONS	TEXT	Text containing options related to the threshold.
MODIFIED	TIMESTAMP_NTZ	Timestamp indicating the date and time of the last modification to the condition.
METRIC_NAME	TEXT	Text containing the name of the metric.
OPERATOR	TEXT	Text indicating the operator used in the condition.
ID	NUMBER	Unique identifier for each condition.
CREATED	TIMESTAMP_NTZ	Timestamp indicating the date and time when the condition was created.
THRESHOLD	FLOAT	Float value representing the threshold for the condition.
CHANNEL	NUMBER	Identifier representing the channel associated with the condition.
ORGANIZATION_ID	NUMBER	Identifier referencing the organization to which the condition belongs.

3. LEVEL_NLP_SENTIMENTTAG

COLUMN_NAME	DATA_TYPE	DESCRIPTION
MODIFIED	TIMESTAMP_NTZ	Date and time of the last modification to the sentiment tag.
ID	NUMBER	Unique identifier for each sentiment tag.
IS_ACTIVE	BOOLEAN	Indicates if the sentiment tag is active.
EMOTION	TEXT	Emotion associated with the sentiment tag.
CREATED	TIMESTAMP_NTZ	Date and time when the sentiment tag was created.
EMOTION_DESCRIPTION	TEXT	Description or details of the emotion associated with the sentiment tag.
CATEGORY	TEXT	Category of the sentiment tag.
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization to which the sentiment tag belongs.
TITLE	TEXT	Title or name of the sentiment tag.

4. QUALITY_ASSESSMENT_CUSTOMFORMCATEGORY

COLUMN_NAME	DATA_TYPE	DESCRIPTION
ORGANIZATION_ID	NUMBER	Integer representing the identifier of the organization to which the category belongs.
MODIFIED	TIMESTAMP_NTZ	Timestamp indicating the date and time of the last modification to the category.
WEIGHTAGE	FLOAT	Numeric value representing the weightage assigned to the category.
ORDER_ID	NUMBER	Integer representing the order index of the category.
FORM_ID	NUMBER	Identifier referencing the rubric to which the category belongs.
CREATED	TIMESTAMP_NTZ	Timestamp indicating the date and time when the category was created.
TITLE	TEXT	Text field containing the title of the category.
ID	NUMBER	Unique identifier for each category.

5. QUALITY_ASSESSMENT_CUSTOMFORMSECTION

COLUMN_NAME	DATA_TYPE	DESCRIPTION
ORDER_ID	NUMBER	An integer representing the order index of the section.
CATEGORY_ID	NUMBER	An integer representing the identifier of the category to which the section belongs.
CREATED	TIMESTAMP_NTZ	A timestamp indicating the date and time when the section was created.
MODIFIED	TIMESTAMP_NTZ	A timestamp indicating the date and time of the last modification to the section.
ID	NUMBER	A unique identifier for each section.
ORGANIZATION_ID	NUMBER	An integer representing the identifier of the organization to which the section belongs.
TITLE	TEXT	A text field containing the title of the section.

6. QUALITY_ASSESSMENT_CUSTOMFORMTHRESHOLDS

COLUMN_NAME	DATA_TYPE	DESCRIPTION
ORGANIZATION_ID	NUMBER	Integer representing the identifier of the organization to which the threshold belongs.
OUTCOME	TEXT	Outcome associated with the threshold.
MODIFIED	TIMESTAMP_NTZ	Timestamp indicating the date and time of the last modification to the threshold.
FROM_VALUE	FLOAT	The starting value of the threshold range.
CREATED	TIMESTAMP_NTZ	Timestamp indicating the date and time when the threshold was created.
TO_VALUE	FLOAT	The ending value of the threshold range.
ID	NUMBER	Unique identifier for each threshold.
FORM_ID	NUMBER	Identifier referencing the rubric to which the threshold belongs.

7. ACCOUNTS_ORGANIZATION

COLUMN_NAME	DATA_TYPE	DESCRIPTION
CREATED	TIMESTAMP_NTZ	Date and time of organization creation.
ID	NUMBER	Unique identifier for each organization.
LOGO_PATH	TEXT	URL for organization logo.
NAME	TEXT	Name of the organization
CREATED_BY	NUMBER	Foreign key referencing the USER table, indicating the creator of the organization.
MODIFIED	TIMESTAMP_NTZ	Date and time of last modification.

8. ACCOUNTS_TEAM

COLUMN_NAME	DATA_TYPE	DESCRIPTION
MODIFIED	TIMESTAMP_NTZ	Date and time of last modification.
NAME	TEXT	Name of the team.
ID	NUMBER	Unique identifier for each team
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization to which the team belongs.
CREATED_BY_ID	NUMBER	Foreign key referencing the user who created the team.
DEFAULT	BOOLEAN	nan
SAMPLE	TEXT	nan
TYPE	NUMBER	Type of the team
CREATED	TIMESTAMP_NTZ	Date and time of team creation

9. ACCOUNTS_TEAMMEMBER

COLUMN_NAME	DATA_TYPE	DESCRIPTION
MODIFIED	TIMESTAMP_NTZ	Date and time of last modification.
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization
ID	NUMBER	Unique identifier for each user to team mapping
IS_TEAM_ADMIN	BOOLEAN	Indicates if the user has administrative privileges within the team.
TEAM_ID	NUMBER	Foreign key referencing the team to which the user belongs.
CREATED	TIMESTAMP_NTZ	Date and time when the user was added to the team.
USER_ID	NUMBER	Foreign key referencing the user who is the team member.
AUTO_ADDED	BOOLEAN	Indicates if the user was automatically added.
ADDED_BY_ID	NUMBER	Foreign key referencing the user who added the team member.

10. ACCOUNTS_USERPROFILE

COLUMN_NAME	DATA_TYPE	DESCRIPTION
MODIFIED	TIMESTAMP_NTZ	Date and time of last modification.
ID	NUMBER	Unique identifier for each user profile.
PROFILE	VARIANT	Profile information of the user.
USER_ID	NUMBER	Foreign key referencing the user associated with the profile.
USER_ROLE_ID	NUMBER	Foreign key referencing the role of the user.
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization to which the user belongs.
CREATED	TIMESTAMP_NTZ	Date and time when the user profile was created.
ENABLE_ANALYTICS	BOOLEAN	Indicates if analytics are enabled for this user profile.
SOURCE	NUMBER	Source of the user profile data.

11. ACCOUNTS_USER

COLUMN_NAME	DATA_TYPE	DESCRIPTION
FIRST_NAME	TEXT	The user's first name.
EXT_EMP_ID	TEXT	External employee identifier.
MODIFIED	TIMESTAMP_NTZ	Date and time of last modification
IS_SUPERUSER	BOOLEAN	Indicates if the user has superuser privileges.
MANAGER_ID	NUMBER	Foreign key referencing the user's manager.
UUID	TEXT	Universally unique identifier for the user.
AVATAR	TEXT	Path or URL to the user's avatar image.
DATE_JOINED	TIMESTAMP_NTZ	Date and time when the user joined.
LAST_NAME	TEXT	The user's last name.
IS_ACTIVE	BOOLEAN	Indicates if the user account is active.
EMAIL	TEXT	The user's email address.
ORGANIZATION_ID	NUMBER	(Deprecated) Foreign key referencing the organization to which the user belongs.
PHONE_NUMBER	TEXT	The user's phone number.
IS_STAFF	BOOLEAN	Indicates if the user is staff.
ID	NUMBER	Unique identifier for each user.
LAST_LOGIN	TIMESTAMP_NTZ	Date and time of the user's last login.
ROLE	TEXT	Role of the user within the organization.
IS_BOT	BOOLEAN	Indicates if the user is bot or human agent
LANGUAGE
PERSONA

12. ACCOUNTS_USERORGANIZATIONS

COLUMN_NAME	DATA_TYPE	DESCRIPTION
MODIFIED	TIMESTAMP_NTZ	Date and time of last modification.
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization
ID	NUMBER	Unique identifier for each user to organization mapping
CREATED	TIMESTAMP_NTZ	Date and time when the user was added to the Organization.
USER_ID	NUMBER	Foreign key referencing the user.
IS_ACTIVE	BOOLEAN	Indicates if the user account is active in the mentioned organization or not
PERSONA	TEXT	Persona attached to the given user in the corresponding organization
DELETED

13. BANKING_BANKINGCONVERSATION

COLUMN_NAME	DATA_TYPE	DESCRIPTION
ID	NUMBER	Unique identifier for each conversation.
USER_ID	NUMBER	Foreign key referencing the user involved in the conversation.
CREATED	TIMESTAMP_NTZ	Date and time when the conversation was created.
ASR_LOG_ID	NUMBER	Identifier referencing the ASR log associated with the conversation.
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization to which the conversation belongs.
MODIFIED	TIMESTAMP_NTZ	Date and time of the last modification to the conversation.

14. LEVEL_ASR_ASRLOG

COLUMN_NAME	DATA_TYPE	DESCRIPTION
CLEAN_TEXT	TEXT	Cleaned version of the text extracted from the conversation.
EMAIL_SUMMARIES	TEXT	nan
CUSTOM_FIELDS	VARIANT	Custom fields associated with the conversation.
TRANSCRIPTION_UUID	TEXT	Universally unique identifier for the transcription of the conversation. This field can be used to search transcripts in ASRTranscriptionLog
CONVERSATION_STATUS	TEXT	Status of the conversation.
USER_ID	NUMBER	Foreign key referencing the agent involved in the conversation.
EXTERNAL_LOG_ID	NUMBER	Identifier for an external log associated with the conversation.
PROCESSING_BATCH_ID	NUMBER	Identifier for the batch processing of the conversation.
ORGANISATION_ID	NUMBER	Foreign key referencing the organization to which the conversation belongs.
IS_CORRECT	BOOLEAN	nan
CORRECTED_TEXT	TEXT	nan
TEXT	TEXT	Original text of the conversation.
CHANNEL	NUMBER	Channel through which the conversation took place. 1 Call 2 Chat 3 SMS 4 Email 5 Slack 6 Non-contact 7 Manual
SUMMARY	TEXT	Summary of the conversation.
LANGUAGE	TEXT	Language used in the conversation.
ID	NUMBER	Unique identifier for each ASR log entry.
COMPLETED_AT	TIMESTAMP_NTZ	Date and time when the transcription was completed.
WORKSPACE_ID	NUMBER	Identifier for the workspace associated with the conversation.
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization to which the conversation belongs.
HAS_SCREEN_RECORDING	BOOLEAN	Indicates if there is a screen recording associated with the conversation.
IS_BLACKLISTED_FOR_ANALYTICS	BOOLEAN	Indicates if the conversation is blacklisted for analytics.
IS_SAMPLED	BOOLEAN	Indicates if the conversation is sampled for analytics.
QA_STATUS	NUMBER	Quality assurance status of the conversation. Pending Evaluation (1) Evaluated (2) Accepted (3) Disputed (4)
MODIFIED	TIMESTAMP_NTZ	Date and time of the last modification to the conversation.
AGENT_JOINED_IN	NUMBER	Indicates if an agent joined the conversation.
IS_FORCE_END	BOOLEAN	Indicates if the conversation was forcefully ended.
TRANSCRIPT_ID	TEXT	Identifier for the transcript associated with the conversation.
CREATED	TIMESTAMP_NTZ	Date and time when the conversation was created.
BANKING_CONVERSATION_ID	NUMBER	Identifier for banking-related conversations.
VERSION	TEXT	Version of the conversation.
CUSTOMER_EMAIL	TEXT	Email of the customer involved in the conversation.
AUDIO_ID	NUMBER	Identifier for the audio associated with the conversation.
OFFLINE_ASR_PAYLOAD_ID	NUMBER	Identifier for offline ASR payload associated with the conversation.

15. CFANSWER

COLUMN_NAME	DATA_TYPE	DESCRIPTION
CREATED	TIMESTAMP_NTZ	Date and time when the QA entry was created.
ANSWER	VARIANT	Answer provided
ID	NUMBER	Unique identifier for each CFAnswer entry.
USER_ID	NUMBER	Foreign key referencing the QA auditor who performed the QA.
FREEZE	BOOLEAN	Indicates if the CFAnswer entry is frozen or locked for further editing.
AUTO_INSTASCORE_PCNT	FLOAT	Percentage score automatically assigned based on QA.
RAW_SCORE	FLOAT	Manual score assigned for the QA.
CUSTOM_FORM_ID	NUMBER	Identifier for the custom form (Rubric) associated with the QA.
MAX_SCORE	FLOAT	Maximum possible manual score
MODIFIED	TIMESTAMP_NTZ	Date and time of the last modification to the Answer entry.
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization to which the CFAnswer belongs.
AUTO_INSTASCORE	FLOAT	Automatic score assigned based on QA.
SUBMITTED_AS_CERTIFICATION	BOOLEAN	nan
VERSION	NUMBER	Version of the CFAnswer entry.
RULES_META_DATA	TEXT	Metadata related to the rules applied for QA.
IS_AUTOSCORED	BOOLEAN	Indicates if the QA is automatically scored.
ASR_LOG_ID	NUMBER	Identifier referencing the ASRlog associated with the CFAnswer.
OUTCOME	TEXT	Outcome of the Answer. OUTSTANDING GOOD NEEDS_IMPROVEMENT POOR PASS FAIL
AUTO_MAX_INSTASCORE	FLOAT	Maximum possible automatic score

16. QUALITY_ASSESSMENT_CUSTOMFORMQUESTION

COLUMN_NAME	DATA_TYPE	DESCRIPTION
SECTION_ID	NUMBER	Identifier referencing the section to which the question belongs.
IS_UNIVERSAL	BOOLEAN	Indicates if the question is universal
AUTOMATED_SCORING_ID	NUMBER
TITLE	TEXT	Title of the question.
ID	NUMBER	Unique identifier for each rubric question.
SCORING	NUMBER	Scoring method used for the question.
MODIFIED	TIMESTAMP_NTZ	Date and time of the last modification to the question.
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization to which the question belongs.
ORDER_ID	NUMBER	Order index of the question within its section.
CREATED	TIMESTAMP_NTZ	Date and time when the question was created.
DESCRIPTION	TEXT	Description or details of the question.
IS_AUTOSCORED	BOOLEAN	Indicates if the question is automatically scored.
PREFILL_OPTION_INDEX	NUMBER	Index of the prefill option associated with the question.
OPTIONS	TEXT	Options available for the question.
QUESTION_LEVEL	NUMBER	Level of the question: It can have 2 values, 1 and 2. 1 means base questions (L1) 2 means follow-up question (L2)
OPTION_SELECTION_TYPE	NUMBER	Option Selection Type: It can have 2 values 1 and 2 1 means single choice question 2 means multiple choice question
PARENT_QUESTION_ID	NUMBER	All followup questions will have this field set to base questionId Base questions (L1) will have this value as null
AUTO_QA_SETUP_TYPE

17. QUALITY_ASSESSMENT_CUSTOMFORM

COLUMN_NAME	DATA_TYPE	DESCRIPTION
IS_AUTOFILL_SCORE	BOOLEAN	Indicates if the score is automatically filled.
IS_CHAT	BOOLEAN	Indicates if the rubric is for chat conversations.
OUTCOME_TYPE	TEXT	Type of outcome associated with the rubric.
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization to which the rubric belongs.
SAMPLE	TEXT	nan
MAX_SCORE	NUMBER	Maximum score possible with this rubric.
TITLE	TEXT	Title of the rubric.
UPDATED_BY_ID	NUMBER	Foreign key referencing the user who last updated the rubric.
SCORING	TEXT	Scoring method used by the rubric. (POINTS/ PERCENTAGE)
CREATED	TIMESTAMP_NTZ	Date and time when the rubric was created.
MODIFIED	TIMESTAMP_NTZ	Date and time of the last modification to the rubric.
IS_CALL	BOOLEAN	Indicates if the rubric is for call conversations.
IS_ACTIVE	BOOLEAN	Indicates if the rubric is currently active.
ID	NUMBER	Unique identifier for each rubric.
DEFAULT_OPTIONS	TEXT	Default options associated with the rubric.
TYPE	TEXT	Type of the rubric. (INSTASCORE/ MANUAL)
DESCRIPTION	TEXT	Description or details of the rubric.
USER_ID	NUMBER	Foreign key referencing the user associated with the rubric.
IS_EMAIL	BOOLEAN	Indicates if the rubric is for email conversations.
AGENT_TYPE	TEXT	Type of agent associated with the rubric.
GLOBAL_PROJECTS_ACCESS
SOURCE
TEMPLATE_USED
VERSION_NUMBER
VERSION_STATUS

18. METRICS

COLUMN_NAME	DATA_TYPE	DESCRIPTION
HANDLING_TIME	NUMBER	Time taken to handle the conversation.
AUTOMATED_ETIQUETTE_SCORE	FLOAT	Score indicating automated assessment of etiquette.
ASSISTS	NUMBER	Number of assists provided during the conversation.
FEEDBACK_AT	TIMESTAMP_NTZ	Date and time when feedback was provided.
DISPUTE_STATUS	NUMBER	Status of any disputes related to the metrics.
FLAGS	NUMBER	Flags raised during the conversation.
MODIFIED	TIMESTAMP_NTZ	Date and time of the last modification to the metrics.
QA_SCORE	FLOAT	Quality assurance score.
NEGATIVE_MOMENTS	NUMBER	Count of negative moments during the conversation.
FEEDBACK_BY_ID	NUMBER	Identifier referencing the user who provided feedback.
AUTOMATED_KNOWLEDGE_SCORE	FLOAT	Score indicating automated assessment of knowledge.
SENTIMENT_SCORE	FLOAT	Score indicating sentiment analysis.
DISPUTE_AT	TIMESTAMP_NTZ	Date and time when the dispute occurred.
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization to which the metrics belong.
CONVERSATION_TAG_COUNT	NUMBER	Count of conversation tags.
WARNINGS	NUMBER	Warnings raised during the conversation.
POSITIVE_MOMENTS	NUMBER	Count of positive moments during the conversation.
ASR_LOG_ID	NUMBER	Identifier referencing the ASR log associated with the conversation.
CREATED	TIMESTAMP_NTZ	Date and time when the metrics entry was created.
AGENT_FEEDBACK	TEXT	Feedback provided by the agent.
CUSTOMER_EFFORT_SCORE	FLOAT	Customer effort score.
AUTOMATED_COMPLIANCE_SCORE	FLOAT	Score indicating automated assessment of compliance.
RESOURCE_CLICK_RATE	FLOAT	Click rate for resources provided during the conversation.
ID	NUMBER	Unique identifier for each metrics entry.

19. QUALITY_ASSESSMENT_VOICECONVERSATIONMETRICS

COLUMN_NAME	DATA_TYPE
BASE_METRICS_ID	NUMBER
AVERAGE_WORDS_PER_MINUTE	FLOAT
ID	NUMBER
DEAD_AIR_RATIO	FLOAT
LISTEN_TO_TALK_RATIO	FLOAT
MODIFIED	TIMESTAMP_NTZ
ORGANIZATION_ID	NUMBER
CREATED	TIMESTAMP_NTZ

20. QUALITY_ASSESSMENT_CHATCONVERSATIONMETRICS

COLUMN_NAME	DATA_TYPE
CASE_RESOLUTION_TIME	NUMBER
WAITING_TIME_RATIO	FLOAT
BASE_METRICS_ID	NUMBER
MODIFIED	TIMESTAMP_NTZ
FIRST_RESPONSE_TIME	NUMBER
ID	NUMBER
CREATED	TIMESTAMP_NTZ
ORGANIZATION_ID	NUMBER

21. QUALITY_ASSESSMENT_EMAILCONVERSATIONMETRICS

COLUMN_NAME	DATA_TYPE
ID	NUMBER
MODIFIED	TIMESTAMP_NTZ
CREATED	TIMESTAMP_NTZ
FIRST_RESPONSE_TIME	NUMBER
CUSTOMER_REPLY_COUNT	NUMBER
AGENT_REPLY_COUNT	NUMBER
ORGANIZATION_ID	NUMBER
AGENT_AVERAGE_RESPONSE_TIME	NUMBER
TOTAL_HANDLING_TIME	NUMBER
BASE_METRICS_ID	NUMBER
IS_RESOLVED_BY_AGENT	BOOLEAN

22. QUALITY_ASSESSMENT_QAAUTOMATIONRULE

COLUMN_NAME	DATA_TYPE
ID	NUMBER
CREATED_BY_ID	NUMBER
AGENT_GROUP	TEXT
DATA_PULL_RANGE	NUMBER
SAMPLE_ID	NUMBER
LAST_RUN_AT	TIMESTAMP_NTZ
BEAT_TASK_ID	NUMBER
NAME	TEXT
ACTIVE	BOOLEAN
CRON_SCHEDULE_ID	NUMBER
CREATED	TIMESTAMP_NTZ
TEAMS	TEXT
MODIFIED	TIMESTAMP_NTZ
ORGANIZATION_ID	NUMBER
DEFAULT_RUBRIC_ID_ID
GOAL_PREDICTION_NOTIFICATION
LAST_PREDICTION_RUN_AT
MAX_RUN_COUNT
MODERATOR_SAMPLE
PREDICTION_PROGRESS
WORKLOAD_TIMEOFF

23. MOMENT

COLUMN_NAME	DATA_TYPE	DESCRIPTION
NLP_UUID	TEXT	Universally unique identifier for the moment.
ASR_TRANSCRIPTION_LOG_ID	NUMBER	Identifier referencing the ASR transcription log associated with the moment.
LINK	TEXT	Link associated with the moment.
TRIGGER_SPEAKER	TEXT	Speaker who triggered the moment.
IS_VISIBLE	BOOLEAN	Indicates if the moment is visible.
TRIGGER_CONTEXT	TEXT	Context in which the moment was triggered.
ID	NUMBER	Unique identifier for each moment.
DESCRIPTION	TEXT	Description or details of the moment.
TITLE	TEXT	Title of the moment.
METRIC_TAG_RULE_ID	NUMBER	Identifier referencing the metric tag rule associated with the moment.
MOMENT_TYPE	TEXT	Type of moment.
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization to which the moment belongs.
EXPECTATION_SPEAKER	TEXT	nan
EXPECTATION_CONTEXT	TEXT	nan
CREATED	TIMESTAMP_NTZ	Date and time when the moment was created.
MODIFIED	TIMESTAMP_NTZ	Date and time of the last modification to the moment.
RULE_ID	NUMBER	Identifier referencing the rule associated with the moment.
FOLLOWED	TEXT	Indicates if the compliance was followed.
ASR_LOG_ID	NUMBER	Identifier referencing the ASR log associated with the moment.
IS_HIDDEN_FOLLOWED	BOOLEAN	Indicates if the followed moment is hidden.

24. LEVEL_NLP_INTENTTOPICS

COLUMN_NAME	DATA_TYPE	DESCRIPTION
TOPICS	TEXT	Text containing the topics associated with the intent.
ORGANIZATION_ID	NUMBER	Identifier referencing the organization to which the intent topics belong.
MODIFIED	TIMESTAMP_NTZ	Timestamp indicating the date and time of the last modification to the intent topics.
CREATED	TIMESTAMP_NTZ	Timestamp indicating the date and time when the intent topics were created.
ID	NUMBER	Unique identifier for each set of intent topics.
ASR_LOG_ID	NUMBER	Identifier referencing the Automatic Speech Recognition (ASR) log associated with the intent topics.
CATEGORY_ID	NUMBER	Identifier referencing the category associated with the intent topics.

25. LEVEL_NLP_SCRIPTINGRULE

COLUMN_NAME	DATA_TYPE	DESCRIPTION
ID	NUMBER	Unique identifier for each scripting rule.
ALERT_ENABLED	BOOLEAN	Indicates if the alert for the rule is enabled
RULE_AUDIT_ID	NUMBER	Identifier referencing the RuleAudit associated with the rule.
CREATED	TIMESTAMP_NTZ	Timestamp indicating the date and time when the scripting rule was created.
ORGANIZATION_ID	NUMBER	Identifier referencing the organization to which the scripting rule belongs.
MODIFIED	TIMESTAMP_NTZ	Timestamp indicating the date and time of the last modification to the scripting rule.
RULE_JSON	TEXT	Text containing the JSON representation of the rule.
RULE_TYPE	TEXT	Type of the rule.
WORKSPACE_ID	NUMBER	Identifier referencing the workspace to which the scripting rule belongs.

26. LEVEL_NLP_CONCERNMININGSUBTOPIC

COLUMN_NAME	DATA_TYPE	DESCRIPTION
CREATED	TIMESTAMP_NTZ	Timestamp indicating the date and time when the subtopic was created.
ORGANIZATION_ID	NUMBER	Identifier referencing the organization to which the subtopic belongs.
ID	NUMBER	Unique identifier for each subtopic.
MODIFIED	TIMESTAMP_NTZ	Timestamp indicating the date and time of the last modification to the subtopic.
CUSTOMER_DEFINED_NAME	TEXT	Text containing the customer-defined name for the subtopic.
NAME	TEXT	Text containing the name of the subtopic.
TOPIC_TYPE

27. LEVEL_NLP_CATEGORY

COLUMN_NAME	DATA_TYPE	DESCRIPTION
LEVEL	NUMBER	nan
ORGANIZATION_ID	NUMBER	Identifier referencing the organization to which the category belongs.
PARENT_ID	NUMBER	Identifier referencing the parent category of the category.
CATEGORY_TYPE	TEXT	Type of the category.
EXAMPLE_TERMS	TEXT	nan
MODIFIED	TIMESTAMP_NTZ	Timestamp indicating the date and time of the last modification to the category.
PHRASES	TEXT	phrases associated with the category.
IS_ENABLED	BOOLEAN	Indicates if the category is enabled
COUNT	NUMBER	Count of conversations with this category
TITLE	TEXT	Title or name of the category.
MERGED_CATEGORIES	TEXT	nan
ID	NUMBER	Unique identifier for each category.
NLP_ID	NUMBER	nan
CATEGORY_TRAINED	BOOLEAN	Indicates if the category is trained
TITLE_AUTO_GENERATED	BOOLEAN	Indicates if the title of the category is auto-generated
CREATED	TIMESTAMP_NTZ	Timestamp indicating the date and time when the category was created.

28. LEVEL_NLP_CONCERNMININGHEADTOPIC

COLUMN_NAME	DATA_TYPE	DESCRIPTION
ORGANIZATION_ID	NUMBER	Identifier referencing the organization to which the head topic belongs.
ID	NUMBER	Unique identifier for each head topic.
CUSTOMER_DEFINED_NAME	TEXT	Text containing the customer-defined name for the head topic.
MODIFIED	TIMESTAMP_NTZ	Timestamp indicating the date and time of the last modification to the head topic.
NAME	TEXT	Text containing the name of the head topic.
CREATED	TIMESTAMP_NTZ	Timestamp indicating the date and time when the head topic was created.
TOPIC_TYPE

29. LEVEL_NLP_METRICTAGRULE

30. LEVEL_NLP_CONCERNMININGOUTPUT

COLUMN_NAME	DATA_TYPE	DESCRIPTION
ORGANIZATION_ID	NUMBER	Identifier referencing the organization to which the concern mining output belongs.
ID	NUMBER	Unique identifier for each entry in the concern mining output.
HEAD_TOPIC_ID	NUMBER	Identifier referencing the main topic associated with the concern.
MODIFIED	TIMESTAMP_NTZ	Timestamp indicating the date and time of the last modification to the concern mining output.
CREATED	TIMESTAMP_NTZ	Timestamp indicating the date and time when the concern mining output was created.
CONCERN	TEXT	Textual content describing the concern.
ASR_LOG_ID	NUMBER	Identifier referencing the ASR log associated with the concern.
SUB_TOPIC_ID	NUMBER	Identifier referencing the sub-topic associated with the concern.

31. QA_CALIBRATIONS_CALIBRATIONSESSION

COLUMN_NAME	DATA_TYPE
CREATED	TIMESTAMP_NTZ
COMPLETED_AT	TIMESTAMP_NTZ
DISCUSSION	TEXT
FEEDBACK	TEXT
CO_MODERATOR_ID	NUMBER
RUBRIC	TEXT
ID	NUMBER
ORGANIZATION_ID	NUMBER
MODERATOR_ID	NUMBER
START_TIME	TIMESTAMP_NTZ
IS_CARRY_FORWARDED	BOOLEAN
ANALYTICS_ID	NUMBER
MODERATOR_CAN_SKIP_RESPONSE	BOOLEAN
MODIFIED	TIMESTAMP_NTZ
NAME	TEXT
STATUS	NUMBER
DISPUTE_STATUS
IS_REDACTION_ENABLED
USE_WEIGHTED_CALIBRATION_SCORE

32. QA_CALIBRATIONS_CALIBRATIONSESSIONCONVERSATION

COLUMN_NAME	DATA_TYPE
ID	NUMBER
PARTICIPANT_ID	NUMBER
COMMENT	TEXT
ORGANIZATION_ID	NUMBER
IS_MODERATOR	BOOLEAN
SESSION_ID	NUMBER
CONVERSATION_ID	NUMBER
RESPONSE_ID	NUMBER

33. QA_CALIBRATIONS_SESSIONPARTICIPANTRESPONSE

COLUMN_NAME	DATA_TYPE
MAX_SCORE	FLOAT
SESSION_ID	NUMBER
ID	NUMBER
RUBRIC_ID	NUMBER
RAW_SCORE	FLOAT
ORGANIZATION_ID	NUMBER
OUTCOME	TEXT
CALIBRATION_SCORE	FLOAT
SCORING	TEXT
MODIFIED	TIMESTAMP_NTZ
SCORE	FLOAT
CREATED	TIMESTAMP_NTZ
NESTED_QA_SCORES	JSON
NESTED_CALIBRATION_SCORES	JSON

34. QA_CALIBRATIONS_PARTICIPANTRESPONSECOMMENT

COLUMN_NAME	DATA_TYPE
CREATED	TIMESTAMP_NTZ
CONVERSATION_ID	NUMBER
ID	NUMBER
ORGANIZATION_ID	NUMBER
CONTENT	TEXT
USER_ID	NUMBER
MODIFIED	TIMESTAMP_NTZ
SESSION_ID	NUMBER
QUESTION_ID	NUMBER
PARTICIPANT_ID	NUMBER

35. QA_CALIBRATIONS_SESSIONANALYTICS

COLUMN_NAME	DATA_TYPE
AVERAGE_QA_SCORE	FLOAT
ORGANIZATION_ID	NUMBER
CALIBRATION_SCORE	FLOAT
ID	NUMBER

36. QA_CALIBRATIONS_SESSIONPARTICIPANTANSWER

COLUMN_NAME	DATA_TYPE
MODIFIED	TIMESTAMP_NTZ
QUESTION_ID	NUMBER
SCORE	FLOAT
PARTICIPANT_ID	NUMBER
SESSION_ID	NUMBER
CREATED	TIMESTAMP_NTZ
ID	NUMBER
SECTION_ID	NUMBER
CATEGORY_ID	NUMBER
ORGANIZATION_ID	NUMBER
SELECTED_OPTION	TEXT
SELECTED_OPTIONS	LIST [ TEXT]

37. LEVEL_ASR_ASRTRANSCRIPTIONLOG

COLUMN_NAME	DATA_TYPE	DESCRIPTION
ID	NUMBER	Unique identifier for each transcription log entry.
SPEAKER_TAGS	TEXT	Tags indicating different speakers in the transcription.
MODIFIED	TIMESTAMP_NTZ	Date and time of the last modification to the transcription log entry.
ASR_EVENT	NUMBER	nan
UUID	TEXT	Universally unique identifier for the transcription log entry.
EXT_CREATED_DATETIME	TIMESTAMP_NTZ	External date and time when the transcription was created.
CREATED	TIMESTAMP_NTZ	Date and time when the transcription log entry was created.
ORIGINAL_TEXT	TEXT	Original text before any processing or cleaning.
ACTIVE_USER_ID	NUMBER	Identifier referencing the active user associated with the transcription.
POLARITY	FLOAT	nan
SESSION_AUDIO_LOG_ID	NUMBER	Identifier referencing the session audio log associated with the transcription.
CLEAN_TEXT	TEXT	Cleaned version of the text extracted from the transcription.
TEXT	TEXT	Transcribed text.
EXTERNAL_TRANSCRIPTION_LOG_ID	NUMBER	Identifier referencing an external transcription log.
TIMESTAMPS	TEXT	Timestamps associated with the transcription.
SENTIMENT	TEXT	Sentiment analysis associated with the transcription.
ORGANIZATION_ID	NUMBER	Foreign key referencing the organization to which the transcription log belongs.
ASR_LOG_CREATED	TIMESTAMP_NTZ	Date and time when the ASR log was created.
PUB_SUB_LOG_ID	NUMBER	Identifier referencing the Pub/Sub log associated with the transcription.
POLARITY
SESSION_AUDIO_LOG_ID

38. AGENT_COACHING_COACHINGSESSION

COLUMN_NAME	DATA_TYPE	DESCRIPTION
FINISHED	TIMESTAMP_NTZ	Indicates if the coaching session is finished.
CREATED	TIMESTAMP_NTZ	Timestamp indicating the date and time when the coaching session was created.
PENDING_ACTION_ITEMS_REVIEWED	TIMESTAMP_NTZ	nan
RUBRIC_ID	NUMBER	Identifier referencing the rubric associated with the coaching session.
TITLE	TEXT	Title or name of the coaching session.
AGENT_ID	NUMBER	Identifier referencing the agent associated with the coaching session.
VISIBILITY	NUMBER	nan
MODIFIED	TIMESTAMP_NTZ	Timestamp indicating the date and time of the last modification to the coaching session.
FINISHED_BY_ID	NUMBER	Identifier referencing the user who finished the coaching session.
ORGANIZATION_ID	NUMBER	Identifier referencing the organization to which the coaching session belongs.
COACH_ID	NUMBER	Identifier referencing the coach associated with the coaching session.
STATUS	NUMBER	Status of the coaching session.
AGENT_SIGNED	TIMESTAMP_NTZ	Indicates if the agent has signed the coaching session.
ID	NUMBER	Unique identifier for each coaching session.
CREATED_BY_ID
METADATA
PROJECT_ID
SOURCE

39. AGENT_COACHING_COMMENT

COLUMN_NAME	DATA_TYPE	DESCRIPTION
MODIFIED	TIMESTAMP_NTZ	Timestamp indicating the date and time of the last modification to the coaching comment.
USER_ID	NUMBER	Identifier referencing the user who created the coaching comment.
CONTENT	TEXT	Text content of the coaching comment.
ORGANIZATION_ID	NUMBER	Identifier referencing the organization to which the coaching comment belongs.
SESSION_ID	NUMBER	Identifier referencing the session associated with the coaching comment.
CREATED	TIMESTAMP_NTZ	Timestamp indicating the date and time when the coaching comment was created.
ID	NUMBER	Unique identifier for each coaching comment.

40. QUALITY_ASSESSMENT_INSTAREVIEWTAGS

COLUMN_NAME	DATA_TYPE	DESCRIPTION
ASR_LOG_ID	NUMBER	Identifier referencing the ASR log associated with the insta review tag.
RICH_CONVERSATION	BOOLEAN	Indicates if the conversation is rich
POSITIVE_CONVERSATION	BOOLEAN	Indicates if the conversation is positive
ID	NUMBER	Unique identifier for each insta review tag.
MODIFIED	TIMESTAMP_NTZ	Timestamp indicating the date and time of the last modification to the insta review tag.
CREATED	TIMESTAMP_NTZ	Timestamp indicating the date and time when the insta review tag was created.
REVIEW_PAYLOAD	TEXT	Textual content of the review payload.
NEGATIVE_CONVERSATION	BOOLEAN	Indicates if the conversation is negative
ORGANIZATION_ID	NUMBER	Identifier referencing the organization to which the insta review tag belongs.

41. CONVO_SPEAKER_UTTERANCES

COLUMN_NAME	DATA_TYPE	DESCRIPTION
ASR_LOG_ID	NUMBER	Identifier referencing the ASRlog associated with the speaker utterance.
CONVO_CREATED	TIMESTAMP_NTZ	Date and time when the conversation was created.
CONVO_ID	NUMBER	Unique identifier for each conversation.
END_TIME	TIME	End time of the speaker utterance
ID	NUMBER	Unique identifier for each entry.
MODIFIED	TIMESTAMP_NTZ	Date and time when the conversation was ingested into Level
SPEAKER	VARCHAR	Customer or Agent
START_TIME	TIME	Start time of the speaker utterance
START_TIMESTAMP	TIMESTAMP_NTZ	Actual starting timestamp of the conversation
TRANSCRIPT	VARCHAR	Transcribed text.
UPDATED	NUMBER	Cursor field for incremental upserts (epoch ms)

42. MANUALSCORE

COLUMN_NAME	DATA_TYPE	DESCRIPTION
ASR_LOG_ID	NUMBER	Unique identifier for each ASR log entry.
CATEGORY	TEXT	Category Name for the respective answer in the CFAnswer entry.
CATEGORY_ID	NUMBER	Category Identifier for the respective answer in the CFAnswer entry.
CATEGORY_SCORE	FLOAT	Category Score for the respective answer in the CFAnswer entry.
CATEGORY_SCORE_PCNT	FLOAT	Category Score Percentage for the respective answer in the CFAnswer entry.
ID	NUMBER	Unique identifier for each entry (question, section, category and asr_log_id as unique id)
PARENT_QUESTION_ID	NUMBER	All followup questions will have this field set to base questionId Base questions (L1) will have this value as null
QUESTION	TEXT	Question for the respective answer in the CFAnswer entry.
QUESTION_ID	NUMBER	Question Identifier for the respective answer in the CFAnswer entry.
QUESTION_LEVEL	NUMBER	Level of the question in-case of multi-select questions (It can have 2 values, 1 and 2. 1 means base questions (L1) 2 means follow-up question (L2))
QUESTION_MAX_SCORE	FLOAT	Maximum Question Score for the respective answer in the CFAnswer entry.
QUESTION_SCORE	FLOAT	Question Score for the respective answer in the CFAnswer entry.
QUESTION_SCORE_PCNT	FLOAT	Question Score Percentage for the respective answer in the CFAnswer entry.
RAW_SCORE	FLOAT	Manual score assigned for the QA.
RUBRIC_ID	NUMBER	Unique identifier for each CustomForm entry.
RUBRIC_TITLE	TEXT	Title of the rubric
SECTION	TEXT	Section Name for the respective answer in the CFAnswer entry.
SECTION_ID	NUMBER	Section Identifier for the respective answer in the CFAnswer entry.
SECTION_SCORE	FLOAT	Section Score for the respective answer in the CFAnswer entry.
SECTION_SCORE_PCNT	FLOAT	Section Score Percentage for the respective answer in the CFAnswer entry.
SELECTED_OPTION	TEXT	Selected option for this record
UPDATED	NUMBER	Date and time of the last modification to the transcription log or asr log entry.

43. INSTASCORE

COLUMN_NAME	DATA_TYPE	DESCRIPTION
ASR_LOG_ID	NUMBER	Unique identifier for each ASR log entry.
CATEGORY	TEXT	Category Name for the respective answer in the CFAnswer entry.
CATEGORY_ID	NUMBER	Category Identifier for the respective answer in the CFAnswer entry.
CATEGORY_SCORE	FLOAT	Category Score for the respective answer in the CFAnswer entry.
CATEGORY_SCORE_PCNT	FLOAT	Category Score Percentage for the respective answer in the CFAnswer entry.
ID	NUMBER	Unique identifier for each entry (question, section, category and asr_log_id as unique id)
PARENT_QUESTION_ID	NUMBER	All followup questions will have this field set to base questionId Base questions (L1) will have this value as null
QUESTION	TEXT	Question for the respective answer in the CFAnswer entry.
QUESTION_ID	NUMBER	Question Identifier for the respective answer in the CFAnswer entry.
QUESTION_LEVEL	NUMBER	Level of the question in-case of multi-select questions (It can have 2 values, 1 and 2. 1 means base questions (L1) 2 means follow-up question (L2))
QUESTION_SCORE	FLOAT	Question Score for the respective answer in the CFAnswer entry.
QUESTION_SCORE_PCNT	FLOAT	Question Score Percentage for the respective answer in the CFAnswer entry.
RUBRIC_ID	NUMBER	Unique identifier for each CustomForm entry.
RUBRIC_TITLE	TEXT	Title of the rubric
SECTION	TEXT	Section Name for the respective answer in the CFAnswer entry.
SECTION_ID	NUMBER	Section Identifier for the respective answer in the CFAnswer entry.
SECTION_SCORE	FLOAT	Section Score for the respective answer in the CFAnswer entry.
SECTION_SCORE_PCNT	FLOAT	Section Score Percentage for the respective answer in the CFAnswer entry.
SELECTED_OPTION	TEXT	Selected option for this record
UPDATED	NUMBER	Date and time of the last modification to the transcription log or asr log entry.

44. QA_METRICS

COLUMN_NAME	DATA_TYPE	DESCRIPTION
ID	NUMBER	Unique identifier
CREATED	TIMESTAMP_NTZ	Date and time when the record was created.
MODIFIED	TIMESTAMP_NTZ	Date and time of the last modification to the record.
SENTIMENT_SCORE_APPLICABLE	BOOLEAN	Foreign key referencing the organization to which the rubric belongs.
EVALUATION_DURATION	NUMBER	evaluation duration of conversation which has been evaluated manually, empty otherwise
ASR_LOG_ID	NUMBER	Foreign key referening the asr log id for this record
ORGANISATION	NUMBER	Foreign key referencing the organization to which the record belongs.

45. JOURNEY_JOURNEY

COLUMN_NAME	DATA_TYPE
ID	NUMBER
CREATED	TIMESTAMP_NTZ
MODIFIED	TIMESTAMP_NTZ
DELETED	TIMESTAMP_NTZ
EXTERNAL_SESSION_ID	TEXT
PERSONA_ID	NUMBER
ORGANIZATION_ID	NUMBER
IS_ARCHIVED
STATE

46. JOURNEY_AIJOURNEYMETRICS

COLUMN_NAME	DATA_TYPE
ID	NUMBER
CREATED	TIMESTAMP_NTZ
MODIFIED	TIMESTAMP_NTZ
DELETED	TIMESTAMP_NTZ
JOURNEY_ID	NUMBER
CES	FLOAT
ICSAT_SCORE	FLOAT
SENTIMENT_SCORE	FLOAT
RESOLUTION_SCORE	FLOAT
SENTIMENT_SCORE_APPLICABLE	BOOLEAN
CONVERSATION_DURATION_RATIO	FLOAT
CDS	FLOAT
ORGANIZATION_ID	NUMBER

47. JOURNEY_JOURNEYMETRICS

COLUMN_NAME	DATA_TYPE
ID	NUMBER
CREATED	TIMESTAMP_NTZ
MODIFIED	TIMESTAMP_NTZ
DELETED	TIMESTAMP_NTZ
JOURNEY_ID	NUMBER
NUMBER_OF_CONVERSATIONS	NUMBER
DURATION	FLOAT
CSAT_SCORE	FLOAT
ORGANIZATION_ID	NUMBER

48. LEVEL_ASR_JOURNEYSUMMARY

COLUMN_NAME	DATA_TYPE
ID	NUMBER
CREATED	TIMESTAMP_NTZ
MODIFIED	TIMESTAMP_NTZ
JOURNEY_ID	NUMBER
JOURNEY_SUMMARY_METADATA_ID	NUMBER
SUMMARY_SECTION	NUMBER
SUMMARY_TEXT	TEXT
ORGANIZATION_ID	NUMBER

49. LEVEL_ASR_JOURNEYSUMMARYMETADATA

COLUMN_NAME	DATA_TYPE
ID	NUMBER
CREATED	TIMESTAMP_NTZ
MODIFIED	TIMESTAMP_NTZ
JOURNEY_ID	NUMBER
RESOLUTION_TYPE	NUMBER
AGENT_FOLLOWUP	NUMBER
CUSTOMER_FOLLOWUP	NUMBER
ORGANIZATION_ID	NUMBER

50. LEVEL_NLP_JOURNEYCONCERNMININGOUTPUT

COLUMN_NAME	DATA_TYPE
ID	NUMBER
CREATED	TIMESTAMP_NTZ
MODIFIED	TIMESTAMP_NTZ
DELETED	TIMESTAMP_NTZ
CONCERN	TEXT
HEAD_TOPIC_ID	NUMBER
SUB_TOPIC_ID	NUMBER
THEME_ID	NUMBER
JOURNEY_ID	NUMBER
LAST_UPDATED_ASR_LOG_ID	NUMBER
ORGANIZATION_ID	NUMBER
LAST_UPDATED_ASR_LOG_ID