Interaction Topic Dataset Specification
Interaction Topic Dataset Specification
The "Interaction Topic Dataset Specification" contains information about communication regarding a member. It includes Interaction as an inner object and might be included in multiple Interaction_Topics belonging to different members. Its unique key is Topic_Key. It references Members by Member_ID. Optionally, it references related Requests by both Request_Key and Request_ID. Also, optionally references related Programs by both Program_ID and Screening_Key. Interaction has optional reference by Member_Contact_Key and/or Provider_Contact_Key.
Key Components of the Dataset
Interaction Topic Records
Documents the subjects or themes of interactions.
Provides a structured overview of what is being discussed or addressed within the organization.
Interaction Topic Notes
Offers additional details and annotations about each topic.
Enriches the context and understanding of the interactions.
Vital for deepening insights into the nature and depth of discussions.
Interaction Topic Log
Records the history and changes of interaction topics.
Creates a comprehensive audit trail.
Essential for tracking the development and modifications of discussion topics over time, ensuring transparency and accountability.
Interaction Topic Raw Data
Contains unprocessed, detailed data related to the interactions.
Invaluable for conducting detailed analyses and gaining granular insights into the dynamics of organizational communication.
This dataset plays a pivotal role in enhancing the management of communication topics, fostering an environment of informed and effective interactions within the organization.
Table Specifications
Interaction_Topic_Member
Column Name | Is Nullable | Data Type | Description |
| YES | STRING | Identifier of the member involved in the interaction. |
| YES | INT64 | A unique key associated with the member for internal tracking. |
| YES | INT64 | A unique identifier for the topic of interaction, differentiating various interaction subjects. |
| YES | STRING | Unique identifier of the specific topic discussed or addressed in the interaction. |
| YES | STRING | A coded representation of the topic to categorize the subject matter systematically. See Dictionary Interaction Topic table in the Dictionary Dataset Specification. |
| YES | STRING | Descriptive text about the topic, providing context or details. See Dictionary Interaction Topic table in the Dictionary Dataset Specification. |
| YES | STRING | The outcome or resolution of the interaction topic. See Dictionary Interaction Topic Resolution table in the Dictionary Dataset Specification. |
| YES | STRING | Detailed explanation of how the topic was resolved or concluded. See Dictionary Interaction Topic Resolution table in the Dictionary Dataset Specification. |
| YES | INT64 | The total time spent discussing or addressing the topic, in minutes. |
| YES | INT64 | The number of attempts made to address or discuss the topic, indicating follow-ups or repeated discussions. |
| YES | TIMESTAMP | The starting time of the interaction related to the topic. |
| YES | DATE | Scheduled date for follow-up if the topic requires further attention. |
| YES | STRING | User ID of the individual who owns or is responsible for the topic. |
| YES | STRING | Full name of the topic owner, typically mapped from the user's full name in the system. |
| YES | TIMESTAMP | Timestamp indicating when the topic was first created or logged in the system. |
| YES | TIMESTAMP | The last time the topic record was updated or modified. |
| YES | INT64 | A unique identifier linking the topic to a specific member contact record. |
| YES | INT64 | Links the topic to a specific provider contact record, if applicable. |
| YES | STRING | Indicates whether the interaction is primarily associated with a member or provider, aiding in contextual analysis. If the interaction involves a member, it is labeled |
| YES | STRING | This classification describes the primary focus of the interaction, indicating whether it is centered around a member or a provider. If the interaction is connected to a member, it is classified as |
| YES | INT64 | A unique identifier for the interaction event or record. |
| YES | STRING | A unique identifier for the interaction, often used for tracking and reference. |
| YES | STRING | Unique Topic-Interaction Identifier. This identifier uniquely combines the interaction ID and the topic ID to distinctly identify each interaction-topic pairing. The format merges |
| YES | STRING | Type of interaction. |
Interaction Topic Dataset Specification
Interaction_Topic_Member
Interaction_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Descriptive text explaining the interaction type. See Dictionary Interaction Type table in the Dictionary Dataset Specification.
Interaction_Disposition
Is Nullable: YES
Data Type: STRING
Description: Indicates the outcome or status of the interaction, such as completed, pending, or void. See Dictionary Interaction Disposition table in the Dictionary Dataset Specification.
Interaction_Disposition_Description
Is Nullable: YES
Data Type: STRING
Description: Detailed description of the interaction's outcome or status. See Dictionary Interaction Disposition table in the Dictionary Dataset Specification.
Interaction_Route_Type
Is Nullable: YES
Data Type: STRING
Description: Describes the channel or method through which the interaction occurred, such as phone, email, or in-person. See Dictionary Route Type table in the Dictionary Dataset Specification.
Interaction_Route_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Provides details about the channel or method of the interaction. See Dictionary Route Type table in the Dictionary Dataset Specification.
Interaction_Start_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp marking the beginning of the interaction.
Interaction_Stop_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating the end of the interaction.
Interaction_Duration_In_Minutes
Is Nullable: YES
Data Type: INT64
Description: Total time duration of the interaction, measured in minutes.
Interaction_Disclaimer
Is Nullable: YES
Data Type: STRING
Description: Any disclaimer or special note associated with the interaction.
Interaction_Owner_User_ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the individual who owns or is primarily responsible for the interaction.
Interaction_Owner_User_Name
Is Nullable: YES
Data Type: STRING
Description: Full name of the interaction owner, linking to the system user's full name. Maps to User.Full_Name.
Interaction_Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction was initially created or logged.
Interaction_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: The last time the interaction record was updated or modified.
Interaction_Void_Indicator
Is Nullable: YES
Data Type: BOOL
Description: This boolean indicator determines whether the interaction has been voided or cancelled. If the interaction's disposition is marked as VOID, the indicator is set to true; otherwise, it is set to false.
Member_Enrollment_Key
Is Nullable: YES
Data Type: STRING
Description: Unique key associating the interaction with a specific member enrollment record.
Calculation Criteria:
Find primary active enrollment for a topic ID with attempt = 1 where topic start date is between enrollment effective and termination dates.
If multiple enrollments are found, select the one with the latest effective and termination dates.
Associate calculated enrollment from topics with attempt = 1 to corresponding topics where topic attempt is greater than 1.
Member_Enrollment_Effective_Date
Is Nullable: YES
Data Type: DATE
Description: Date when the member's enrollment became effective, related to the interaction. Maps to Member.Enrollment.Effective_Date.
Member_Enrollment_Termination_Date
Is Nullable: YES
Data Type: DATE
Description: Date when the member's enrollment was terminated, if applicable to the interaction. Maps to Member.Enrollment.Termination_Date.
Group_ID
Is Nullable: YES
Data Type: STRING
Description: Interaction topic group ID. Maps to Member.Enrollment.Group_ID.
Group_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the group related to the member's enrollment. Maps to Member.Enrollment.Group_Name.
Plan_ID
Is Nullable: YES
Data Type: STRING
Description: The plan identifier associated with the member’s enrollment, relevant to the interaction. Maps to Member.Enrollment.Plan_ID.
Plan_Description
Is Nullable: YES
Data Type: STRING
Description: Descriptive details of the member's health plan related to the interaction. Maps to Member.Enrollment.Plan_Description.
Line_Of_Business
Is Nullable: YES
Data Type: STRING
Description: The line of business associated with the member's enrollment, indicating the type of service or coverage. Maps to Member.Enrollment.Line_Of_Business.
Line_Of_Business_Description
Is Nullable: YES
Data Type: STRING
Description: Detailed description of the line of business, providing context to the type of services covered under the member’s plan. Maps to Member.Enrollment.Line_Of_Business_Description.
Interaction_Topic_Notes_Member
Interaction_Topic_Notes_Key
Is Nullable: YES
Data Type: INT64
Description: A unique identifier for a record in the interaction topic notes table. It serves as a primary key that links to other related tables.
Topic_Key
Is Nullable: YES
Data Type: INT64
Description: The identifier of the topic to which the note pertains. It helps to associate the note with a specific interaction topic.
Topic_ID
Is Nullable: YES
Data Type: STRING
Description: A string identifier for the topic that facilitates human-readable association with the topic. It can be used for easier display of information in user interfaces.
Text
Is Nullable: YES
Data Type: STRING
Description: The actual content of the note, containing comments, observations, or additional information related to the topic.
Author_User_ID
Is Nullable: YES
Data Type: STRING
Description: The identifier of the user who created the note. This allows tracking who contributed the note to the system.
Author_User_Name
Is Nullable: YES
Data Type: STRING
Description: The full name of the user who created the note. This field links to the user's full name as specified in their profile.
Author_User_Title
Is Nullable: YES
Data Type: STRING
Description: The title or position of the note's author, which can be useful to understand the context and authority of the note.
Author_Phone_Number
Is Nullable: YES
Data Type: STRING
Description: The phone number of the note's author, providing contact information for further clarification or follow-up.
Interaction Topic Dataset Specification
Interaction Topic Notes Member
Columns
Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: A timestamp indicating when the note was created in the system. Helps to track the history of interactions.
Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: A timestamp of when the note was last modified. Important for understanding the currency and relevance of the information in the note.
Interaction Topic Notes Program
Columns
Interaction_Topic_Notes_Key
Is Nullable: YES
Data Type: INT64
Description: A unique identifier for a record in the interaction topic notes table. It serves as a primary key that links to other related tables.
Topic_Key
Is Nullable: YES
Data Type: INT64
Description: The identifier of the topic to which the note pertains. It helps to associate the note with a specific interaction topic.
Topic_ID
Is Nullable: YES
Data Type: STRING
Description: A string identifier for the topic that facilitates human-readable association with the topic. It can be used for easier display of information in user interfaces.
Text
Is Nullable: YES
Data Type: STRING
Description: The actual content of the note, containing comments, observations, or additional information related to the topic.
Author_User_ID
Is Nullable: YES
Data Type: STRING
Description: The identifier of the user who created the note. This allows tracking who contributed the note to the system.
Author_User_Name
Is Nullable: YES
Data Type: STRING
Description: The full name of the user who created the note. This field links to the user's full name as specified in their profile.
Author_User_Title
Is Nullable: YES
Data Type: STRING
Description: The title or position of the note's author, which can be useful to understand the context and authority of the note.
Author_Phone_Number
Is Nullable: YES
Data Type: STRING
Description: Contact phone number of the note's author. Can be used for communication if clarification of the note is needed.
Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: A timestamp indicating when the note was created in the system. Helps to track the history of interactions.
Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: A timestamp of when the note was last modified. Important for understanding the currency and relevance of the information in the note.
Interaction Topic Notes Request
Columns
Interaction_Topic_Notes_Key
Is Nullable: YES
Data Type: INT64
Description: A unique identifier for a record in the interaction topic notes table. It serves as a primary key that links to other related tables.
Topic_Key
Is Nullable: YES
Data Type: INT64
Description: The identifier of the topic to which the note pertains. It helps to associate the note with a specific interaction topic.
Topic_ID
Is Nullable: YES
Data Type: STRING
Description: A string identifier for the topic that facilitates human-readable association with the topic. It can be used for easier display of information in user interfaces.
Text
Is Nullable: YES
Data Type: STRING
Description: The actual content of the note, containing comments, observations, or additional information related to the topic.
Author_User_ID
Is Nullable: YES
Data Type: STRING
Description: The identifier of the user who created the note. This allows tracking who contributed the note to the system.
Author_User_Name
Is Nullable: YES
Data Type: STRING
Description: The full name of the user who created the note. This field links to the user's full name as specified in their profile.
Author_User_Title
Is Nullable: YES
Data Type: STRING
Description: The title or position of the note's author, which can be useful to understand the context and authority of the note.
Author_Phone_Number
Is Nullable: YES
Data Type: STRING
Description: Contact phone number of the note's author. Can be used for communication if clarification of the note is needed.
Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: A timestamp indicating when the note was created in the system. Helps to track the history of interactions.
Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: A timestamp of when the note was last modified. Important for understanding the currency and relevance of the information in the note.
Interaction Topic Program
Columns
Member_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the member.
Member_Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the member.
Topic_Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the topic.
Topic_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the topic.
Topic_Code
Is Nullable: YES
Data Type: STRING
Description: Code representing the topic.
Topic_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the topic.
Topic_Resolution
Is Nullable: YES
Data Type: STRING
Description: Resolution status of the topic.
Topic_Resolution_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the topic's resolution.
Topic_Duration_In_Minutes
Is Nullable: YES
Data Type: INT64
Description: Duration of the topic discussion in minutes.
Topic_Attempts
Is Nullable: YES
Data Type: INT64
Description: Number of attempts made to address the topic.
Topic_Start_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the topic discussion started.
Topic_Followup_Date
Is Nullable: YES
Data Type: DATE
Description: Date for the follow-up on the topic.
Screening_Key
Is Nullable: YES
Data Type: INT64
Description: Unique identifier for the request.
Program_ID
Is Nullable: YES
Data Type: STRING
Description: Key that uniquely identifies the request.
Topic_Owner_User_ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the owner of the topic.
Topic_Owner_User_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the owner of the topic.
Topic_Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the topic was created.
Topic_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating the last time the topic was modified.
Interaction Topic Dataset Specification
Interaction Topic Program
Member Contact Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the member contact.
Provider Contact Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the provider contact.
Interaction Association Type
Is Nullable: YES
Data Type: STRING
Description: Type of association for the interaction.
Interaction Association Type Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction association type.
Interaction Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the interaction.
Interaction ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the interaction.
Topic Interaction ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the interaction related to the topic.
Interaction Type
Is Nullable: YES
Data Type: STRING
Description: Type of the interaction.
Interaction Type Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction type.
Interaction Disposition
Is Nullable: YES
Data Type: STRING
Description: Disposition of the interaction.
Interaction Disposition Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction disposition.
Interaction Route Type
Is Nullable: YES
Data Type: STRING
Description: Type of route for the interaction.
Interaction Route Type Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction route type.
Interaction Start Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction started.
Interaction Stop Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction stopped.
Interaction Duration in Minutes
Is Nullable: YES
Data Type: INT64
Description: Duration of the interaction in minutes.
Interaction Disclaimer
Is Nullable: YES
Data Type: STRING
Description: Disclaimer associated with the interaction.
Interaction Owner User ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the owner of the interaction.
Interaction Owner User Name
Is Nullable: YES
Data Type: STRING
Description: Name of the owner of the interaction.
Interaction Created Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction was created.
Interaction Last Modified Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating the last time the interaction was modified.
Interaction Void Indicator
Is Nullable: YES
Data Type: BOOL
Description: Indicator of whether the interaction is void.
Member Enrollment Key
Is Nullable: YES
Data Type: STRING
Description: Key that uniquely identifies the member's enrollment.
Member Enrollment Effective Date
Is Nullable: YES
Data Type: DATE
Description: Effective date of the member's enrollment.
Member Enrollment Termination Date
Is Nullable: YES
Data Type: DATE
Description: Termination date of the member's enrollment.
Group ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the group.
Group Name
Is Nullable: YES
Data Type: STRING
Description: Name of the group.
Plan ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the plan.
Plan Description
Is Nullable: YES
Data Type: STRING
Description: Description of the plan.
Line of Business
Is Nullable: YES
Data Type: STRING
Description: Identifier for the line of business.
Line of Business Description
Is Nullable: YES
Data Type: STRING
Description: Description of the line of business.
Interaction Topic Request
Member ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the member.
Member Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the member.
Topic Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the topic.
Topic ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the topic.
Topic Code
Is Nullable: YES
Data Type: STRING
Description: Code representing the topic.
Topic Description
Is Nullable: YES
Data Type: STRING
Description: Description of the topic.
Topic Resolution
Is Nullable: YES
Data Type: STRING
Description: Resolution status of the topic.
Topic Resolution Description
Is Nullable: YES
Data Type: STRING
Description: Description of the topic's resolution.
Topic Duration in Minutes
Is Nullable: YES
Data Type: INT64
Description: Duration of the topic discussion in minutes.
Topic Attempts
Is Nullable: YES
Data Type: INT64
Description: Number of attempts made to address the topic.
Topic Start Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the topic discussion started.
Topic Followup Date
Is Nullable: YES
Data Type: DATE
Description: Date for the follow-up on the topic.
Request ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the request.
Request Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the request.
Topic Owner User ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the owner of the topic.
Topic Owner User Name
Is Nullable: YES
Data Type: STRING
Description: Name of the owner of the topic.
Topic Created Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the topic was created.
Topic Last Modified Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating the last time the topic was modified.
Member Contact Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the member contact.
Provider Contact Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the provider contact.
Interaction Association Type
Is Nullable: YES
Data Type: STRING
Description: Type of association for the interaction.
Interaction Association Type Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction association type.
Interaction Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the interaction.
Interaction ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the interaction.
Topic Interaction ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the interaction related to the topic.
Interaction Type
Is Nullable: YES
Data Type: STRING
Description: Type of the interaction.
Interaction Type Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction type.
Interaction Disposition
Is Nullable: YES
Data Type: STRING
Description: Disposition of the interaction.
Interaction Topic Dataset Specification
Interaction Topic Request
Interaction_Disposition_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction disposition.
Interaction_Route_Type
Is Nullable: YES
Data Type: STRING
Description: Type of route for the interaction.
Interaction_Route_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction route type.
Interaction_Start_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction started.
Interaction_Stop_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction stopped.
Interaction_Duration_In_Minutes
Is Nullable: YES
Data Type: INT64
Description: Duration of the interaction in minutes.
Interaction_Disclaimer
Is Nullable: YES
Data Type: STRING
Description: Disclaimer associated with the interaction.
Interaction_Owner_User_ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the owner of the interaction.
Interaction_Owner_User_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the owner of the interaction.
Interaction_Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction was created.
Interaction_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating the last time the interaction was modified.
Interaction_Void_Indicator
Is Nullable: YES
Data Type: BOOL
Description: Indicator of whether the interaction is void.
Member_Enrollment_Key
Is Nullable: YES
Data Type: STRING
Description: Key that uniquely identifies the member's enrollment.
Member_Enrollment_Effective_Date
Is Nullable: YES
Data Type: DATE
Description: Effective date of the member's enrollment.
Member_Enrollment_Termination_Date
Is Nullable: YES
Data Type: DATE
Description: Termination date of the member's enrollment.
Group_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the group.
Group_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the group.
Plan_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the plan.
Plan_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the plan.
Line_Of_Business
Is Nullable: YES
Data Type: STRING
Description: Identifier for the line of business.
Line_Of_Business_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the line of business.
Interaction Topic Log
Member_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier of the member associated with the interaction.
Member_Key
Is Nullable: YES
Data Type: INT64
Description: A system-generated numerical identifier that uniquely identifies a member.
Topic_Key
Is Nullable: YES
Data Type: INT64
Description: Unique key of the interaction topic within the system.
Topic_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the specific topic of interaction.
Code
Is Nullable: YES
Data Type: STRING
Description: A code that categorizes or provides a shorthand for the interaction topic.
Description
Is Nullable: YES
Data Type: STRING
Description: A textual description of the interaction topic.
Resolution
Is Nullable: YES
Data Type: STRING
Description: Outcome or resolution of the interaction. See Dictionary Interaction Topic Resolution table in the Dictionary Dataset Specification.
Resolution_Description
Is Nullable: YES
Data Type: STRING
Description: Detailed explanation of the interaction's resolution. See Dictionary Interaction Topic Resolution table in the Dictionary Dataset Specification.
Duration_In_Minutes
Is Nullable: YES
Data Type: INT64
Description: Time spent on the interaction, measured in minutes.
Attempts
Is Nullable: YES
Data Type: INT64
Description: The number of times this topic has been addressed or attempted.
Start_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: The starting time of the interaction.
Followup_Date
Is Nullable: YES
Data Type: DATE
Description: Scheduled date for follow-up, if applicable.
Request_Key
Is Nullable: YES
Data Type: INT64
Description: Unique key identifying the request related to the interaction.
Request_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the request associated with the interaction.
Screening_Key
Is Nullable: YES
Data Type: INT64
Description: Unique identifier for the screening associated with the interaction.
Program_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the program related to the interaction.
Owner_User_ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the individual owning or responsible for the interaction.
Interaction Structure
Interaction
Is Nullable: YES
Data Type: STRUCT
Description: A structured data type containing details about the interaction, such as key, ID, type, disposition, and timestamps.
Interaction_Key
Is Nullable: YES
Data Type: INT64
Description: A unique identifier for the interaction event or record.
Interaction_ID
Is Nullable: YES
Data Type: STRING
Description: A unique identifier for the interaction, often used for tracking and reference.
Member_Contact_Key
Is Nullable: YES
Data Type: INT64
Description: A unique identifier linking the topic to a specific member contact record.
Provider_Contact_Key
Is Nullable: YES
Data Type: INT64
Description: Links the topic to a specific provider contact record, if applicable.
Interaction_Type
Is Nullable: YES
Data Type: STRING
Description: Categorizes the type of interaction, providing insight into the nature or method of the interaction. See Dictionary Interaction Type table in the Dictionary Dataset Specification.
Interaction_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Descriptive text explaining the interaction type. See Dictionary Interaction Type table in the Dictionary Dataset Specification.
Interaction_Disposition
Is Nullable: YES
Data Type: STRING
Description: Indicates the outcome or status of the interaction, such as completed, pending, or void. See Dictionary Interaction Disposition table in the Dictionary Dataset Specification.
Interaction_Disposition_Description
Is Nullable: YES
Data Type: STRING
Description: Detailed description of the interaction's outcome or status. See Dictionary Interaction Disposition table in the Dictionary Dataset Specification.
Interaction_Route_Type
Is Nullable: YES
Data Type: STRING
Description: Describes the channel or method through which the interaction occurred, such as phone, email, or in-person. See Dictionary Route Type table in the Dictionary Dataset Specification.
Interaction_Route_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Provides details about the channel or method of the interaction. See Dictionary Route Type table in the Dictionary Dataset Specification.
Interaction Topic Dataset Specification
Interaction
Interaction_Start_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp marking the beginning of the interaction.
Interaction_Stop_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating the end of the interaction.
Interaction_Duration_In_Minutes
Is Nullable: YES
Data Type: INT64
Description: Total time duration of the interaction, measured in minutes.
Interaction_Disclaimer
Is Nullable: YES
Data Type: STRING
Description: Any disclaimer or special note associated with the interaction.
Interaction_Owner_User_ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the individual who owns or is primarily responsible for the interaction.
Interaction_Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction was initially created or logged.
Interaction_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: The last time the interaction record was updated or modified.
Interaction_Topic_Log
Notes
Topic_Key
Is Nullable: YES
Data Type: INT64
Description: The identifier of the topic to which the note pertains. It helps to associate the note with a specific interaction topic.
Text
Is Nullable: YES
Data Type: STRING
Description: The actual content of the note, containing comments, observations, or additional information related to the topic.
Author_User_Title
Is Nullable: YES
Data Type: STRING
Description: The title or position of the note's author, which can be useful to understand the context and authority of the note.
Author_Phone_Number
Is Nullable: YES
Data Type: STRING
Description: Contact phone number of the note's author. Can be used for communication if clarification of the note is needed.
Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: A timestamp indicating when the note was created in the system. Helps to track the history of interactions.
Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: A timestamp of when the note was last modified. Important for understanding the currency and relevance of the information in the note.
Interaction_Topic_Log Fields
Record_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp of the last modification to the interaction record.
Transaction_User_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the user who last modified the interaction record.
Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: The timestamp when the interaction record was initially created.
Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: The most recent timestamp when the interaction record was updated.
Type
Is Nullable: YES
Data Type: STRING
Description: The type of interaction (e.g., call, email, meeting).
Tenant
Is Nullable: YES
Data Type: STRING
Description: Identifier for the tenant or organizational unit.
Active_Version
Is Nullable: YES
Data Type: BOOL
Description: Indicates whether the log entry is the current active version.
Date
Is Nullable: YES
Data Type: DATE
Description: The date of the interaction.
Sequence
Is Nullable: YES
Data Type: INT64
Description: A numerical sequence order for the interaction within a given context or set.
Source_System_Name
Is Nullable: YES
Data Type: STRING
Description: The name of the system where the interaction data originated.
Source_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp from the source system when the interaction was logged.
Source_File_Name
Is Nullable: YES
Data Type: STRING
Description: The name of the file from which the interaction data was sourced.
Deleted_Indicator
Is Nullable: YES
Data Type: BOOL
Description: A boolean flag indicating whether the interaction record has been marked as deleted.
Deleted_Indicator = false: Used as a filter to exclude deleted topic records from all views.
Schema_Version
Is Nullable: YES
Data Type: FLOAT64
Description: Version of the schema used for the interaction data.
Member_Partition
Is Nullable: YES
Data Type: INT64
Description: A numerical identifier used to partition member data for scalability and management.
Action
Is Nullable: YES
Data Type: STRING
Description: The action taken or logged in this interaction record.
Member_ID
Is Nullable: YES
Data Type: STRING
Description: This repeated field likely indicates a historical or log-specific instance of the member ID involved in the interaction.
Member_Key
Is Nullable: YES
Data Type: INT64
Description: Represents a unique system-generated key for the member, specific to the interaction log context.
Topic_Key
Is Nullable: YES
Data Type: INT64
Description: A unique identifier for the topic within the interaction log, used for tracking and reference purposes.
Transaction_Actor_Type
Is Nullable: YES
Data Type: STRING
Description: Type of the actor performing the transaction.
Interaction_Topic_Raw
Member_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier of the member associated with the interaction topic, linking the interaction to a specific individual in the database.
Member_Key
Is Nullable: YES
Data Type: INT64
Description: A numeric key unique to the member, used for internal tracking and linking within the database system.
Topic_Key
Is Nullable: YES
Data Type: INT64
Description: A unique identifier for the interaction topic, facilitating the tracking and referencing of specific topics.
Topic_ID
Is Nullable: YES
Data Type: STRING
Description: The string identifier of the topic, used for display and easy identification in user interfaces.
Code
Is Nullable: YES
Data Type: STRING
Description: A code that categorizes or identifies the topic within a predefined classification system.
Description
Is Nullable: YES
Data Type: STRING
Description: A textual description of the interaction topic, providing detailed information about its nature and content.
Resolution
Is Nullable: YES
Data Type: STRING
Description: The outcome or resolution of the interaction, indicating how the topic was concluded or addressed.
Resolution_Description
Is Nullable: YES
Data Type: STRING
Description: Detailed description of the resolution, offering insight into the outcome of the interaction.
Duration_In_Minutes
Is Nullable: YES
Data Type: INT64
Description: The total time spent on the interaction, measured in minutes, providing a quantifiable measure of the interaction's extent.
Interaction Topic Dataset Specification
Interaction Topic Raw Fields
ts
Type: INT64
Required: YES
Description: The number of attempts made to address or resolve the topic, indicating the level of effort or engagement required.
Start_Timestamp
Type: TIMESTAMP
Required: YES
Description: The timestamp marking the beginning of the interaction, used for timing and historical tracking.
Followup_Date
Type: DATE
Required: YES
Description: A specified date for follow-up on the topic, ensuring that the interaction is revisited or concluded as necessary.
Request_Key
Type: INT64
Required: YES
Description: An identifier linking the topic to a specific request in the system, for tracking and reference purposes.
Request_ID
Type: STRING
Required: YES
Description: The unique string identifier of the related request, used for cross-referencing and coordination with other processes.
Screening_Key
Type: INT64
Required: YES
Description: A key associated with any screening process linked to the interaction topic, for integrated healthcare management.
Program_ID
Type: STRING
Required: YES
Description: Identifier of the program related to the interaction topic, aligning the topic with broader organizational or treatment programs.
Owner_User_ID
Type: STRING
Required: YES
Description: The identifier of the user responsible for or owning the topic, ensuring accountability and ownership within the system.
Interaction
Type: STRUCT
Required: YES
Description: A structured data type containing details about the interaction, such as key, ID, type, disposition, and timestamps.
Interaction Fields
Interaction_Key
Type: INT64
Required: YES
Description: A unique identifier for the interaction event or record.
Interaction_ID
Type: STRING
Required: YES
Description: A unique identifier for the interaction, often used for tracking and reference.
Member_Contact_Key
Type: INT64
Required: YES
Description: A unique identifier linking the topic to a specific member contact record.
Provider_Contact_Key
Type: INT64
Required: YES
Description: Links the topic to a specific provider contact record, if applicable.
Interaction_Type
Type: STRING
Required: YES
Description: Categorizes the type of interaction, providing insight into the nature or method of the interaction.\ See Dictionary Interaction Type table in the Dictionary Dataset Specification.
Interaction_Type_Description
Type: STRING
Required: YES
Description: Descriptive text explaining the interaction type.\ See Dictionary Interaction Type table in the Dictionary Dataset Specification.
Interaction_Disposition
Type: STRING
Required: YES
Description: Indicates the outcome or status of the interaction, such as completed, pending, or void.\ See Dictionary Interaction Disposition table in the Dictionary Dataset Specification.
Interaction_Disposition_Description
Type: STRING
Required: YES
Description: Detailed description of the interaction's outcome or status.\ See Dictionary Interaction Disposition table in the Dictionary Dataset Specification.
Interaction_Route_Type
Type: STRING
Required: YES
Description: Describes the channel or method through which the interaction occurred, such as phone, email, or in-person.\ See Dictionary Route Type table in the Dictionary Dataset Specification.
Interaction_Route_Type_Description
Type: STRING
Required: YES
Description: Provides details about the channel or method of the interaction.\ See Dictionary Route Type table in the Dictionary Dataset Specification.
Interaction_Start_Timestamp
Type: TIMESTAMP
Required: YES
Description: Timestamp marking the beginning of the interaction.
Interaction_Stop_Timestamp
Type: TIMESTAMP
Required: YES
Description: Timestamp indicating the end of the interaction.
Interaction_Duration_In_Minutes
Type: INT64
Required: YES
Description: Total time duration of the interaction, measured in minutes.
Interaction_Disclaimer
Type: STRING
Required: YES
Description: Any disclaimer or special note associated with the interaction.
Interaction_Owner_User_ID
Type: STRING
Required: YES
Description: User ID of the individual who owns or is primarily responsible for the interaction.
Interaction_Created_Timestamp
Type: TIMESTAMP
Required: YES
Description: Timestamp indicating when the interaction was initially created or logged.
Interaction_Last_Modified_Timestamp
Type: TIMESTAMP
Required: YES
Description: The last time the interaction record was updated or modified.
Notes Fields
Notes
Type: ARRAY
Required: NO
Description: A collection of notes related to the interaction, each with a unique key and text content.
Topic_Key
Type: INT64
Required: YES
Description: The identifier of the topic to which the note pertains. It helps to associate the note with a specific interaction topic.
Text
Type: STRING
Required: YES
Description: The actual content of the note, containing comments, observations, or additional information related to the topic.
Author_User_Title
Type: STRING
Required: YES
Description: The title or position of the note's author, which can be useful to understand the context and authority of the note.
Author_Phone_Number
Type: STRING
Required: YES
Description: Contact phone number of the note's author. Can be used for communication if clarification of the note is needed.
Created_Timestamp
Type: TIMESTAMP
Required: YES
Description: A timestamp indicating when the note was created in the system. Helps to track the history of interactions.
Last_Modified_Timestamp
Type: TIMESTAMP
Required: YES
Description: A timestamp of when the note was last modified. Important for understanding the currency and relevance of the information in the note.
Record Metadata Fields
Record_Last_Modified_Timestamp
Type: TIMESTAMP
Required: YES
Description: The timestamp of the last modification made to the record, indicating the most recent update or change.
Transaction_User_ID
Type: STRING
Required: YES
Description: The identifier of the user who last modified the topic record, used for tracking changes and user activity.
Created_Timestamp
Type: TIMESTAMP
Required: YES
Description: The timestamp when the topic record was initially created in the system, marking the beginning of its lifecycle.
Last_Modified_Timestamp
Type: TIMESTAMP
Required: YES
Description: The most recent timestamp when the topic record was updated, reflecting the latest changes or actions taken.
Type
Type: STRING
Required: YES
Description: A classification or category of the interaction topic, providing a way to organize and differentiate topics.
Interaction Topic Dataset Specification
Interaction Topic Raw Data Fields
Tenant
Is Nullable: YES
Data Type: STRING
Description: A reference to the tenant under which the topic record is managed, indicating the organizational segment or division.
Active Version
Is Nullable: YES
Data Type: BOOL
Description: A boolean indicator signifying whether the topic record is the current active version, used for version control and data integrity.
Date
Is Nullable: YES
Data Type: DATE
Description: The date associated with the interaction topic, potentially marking an event or action related to the topic.
Sequence
Is Nullable: YES
Data Type: INT64
Description: A numerical order or sequence number for the topic, used for ordering or prioritizing within a list or series.
Source System Name
Is Nullable: YES
Data Type: STRING
Description: The name of the source system from which the interaction topic data originates, providing context for data integration.
Source Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: The timestamp from the source system, indicating when the data was generated or recorded at the origin.
Source File Name
Is Nullable: YES
Data Type: STRING
Description: The name of the file from the source system, aiding in data traceability and management.
Deleted Indicator
Is Nullable: YES
Data Type: BOOL
Description: A boolean flag indicating whether the topic record has been marked as deleted, used to filter out inactive or removed records.
Usage: When
Deleted_Indicator = false, deleted topic records are excluded from all views.
Schema Version
Is Nullable: YES
Data Type: FLOAT64
Description: A version number for the database schema, used to manage and track changes in the data structure over time.
Member Partition
Is Nullable: YES
Data Type: INT64
Description: A partitioning key for segmenting member data, optimizing data management and query performance within the database system.
Transaction Actor Type
Is Nullable: YES
Data Type: STRING
Description: Type of the actor performing the transaction.
Interaction Topic Components
Interaction Topic Records
Description: This table documents the subjects or themes of interactions, providing a structured overview of what is being discussed or addressed within the organization.
Interaction Topic Notes
Description: Offers additional details and annotations about each topic, enriching the context and understanding of the interactions. This component is vital for deepening insights into the nature and depth of discussions.
Interaction Topic Log
Description: Records the history and changes of interaction topics, creating a comprehensive audit trail. This log is essential for tracking the development and modifications of discussion topics over time, ensuring transparency and accountability.
Interaction Topic Raw Data
Description: Contains unprocessed, detailed data related to the interactions. This raw data is invaluable for conducting detailed analyses and gaining granular insights into the dynamics of organizational communication.
Interaction Topic Member Table
Column Name | Is Nullable | Data Type | Description |
Member_ID | YES | STRING | Identifier of the member involved in the interaction. |
Member_Key | YES | INT64 | A unique key associated with the member for internal tracking. |
Topic_Key | YES | INT64 | A unique identifier for the topic of interaction, differentiating various interaction subjects. |
Topic_ID | YES | STRING | Unique identifier of the specific topic discussed or addressed in the interaction. |
Topic_Code | YES | STRING | A coded representation of the topic to categorize the subject matter systematically. See Dictionary Interaction Topic table in the Dictionary Dataset Specification. |
Topic_Description | YES | STRING | Descriptive text about the topic, providing context or details. See Dictionary Interaction Topic table in the Dictionary Dataset Specification. |
Topic_Resolution | YES | STRING | The outcome or resolution of the interaction topic. See Dictionary Interaction Topic Resolution table in the Dictionary Dataset Specification. |
Topic_Resolution_Description | YES | STRING | Detailed explanation of how the topic was resolved or concluded. See Dictionary Interaction Topic Resolution table in the Dictionary Dataset Specification. |
Topic_Duration_In_Minutes | YES | INT64 | The total time spent discussing or addressing the topic, in minutes. |
Topic_Attempts | YES | INT64 | The number of attempts made to address or discuss the topic, indicating follow-ups or repeated discussions. |
Topic_Start_Timestamp | YES | TIMESTAMP | The starting time of the interaction related to the topic. |
Topic_Followup_Date | YES | DATE | Scheduled date for follow-up if the topic requires further attention. |
Topic_Owner_User_ID | YES | STRING | User ID of the individual who owns or is responsible for the topic. |
Topic_Owner_User_Name | YES | STRING | Full name of the topic owner, typically mapped from the user's full name in the system. |
Topic_Created_Timestamp | YES | TIMESTAMP | Timestamp indicating when the topic was first created or logged in the system. |
Topic_Last_Modified_Timestamp | YES | TIMESTAMP | The last time the topic record was updated or modified. |
Member_Contact_Key | YES | INT64 | A unique identifier linking the topic to a specific member contact record. |
Provider_Contact_Key | YES | INT64 | Links the topic to a specific provider contact record, if applicable. |
Interaction_Association_Type | YES | STRING | Indicates whether the interaction is primarily associated with a member or provider, aiding in contextual analysis. If the interaction involves a member, it is labeled |
Interaction Topic Dataset Specification
Interaction Topic Member
Interaction Association Type Description
Required: YES
Type: STRING
Description: This classification describes the primary focus of the interaction, indicating whether it is centered around a member or a provider.
If the interaction is connected to a member, it is classified as Member.
If it is linked to a provider, it is classified as Provider.
If there is no applicable contact key, the association type remains unspecified.
Interaction Key
Required: YES
Type: INT64
Description: A unique identifier for the interaction event or record.
Interaction ID
Required: YES
Type: STRING
Description: A unique identifier for the interaction, often used for tracking and reference.
Topic Interaction ID
Required: YES
Type: STRING
Description: Unique Topic-Interaction Identifier. This identifier uniquely combines the interaction ID and the topic ID to distinctly identify each interaction-topic pairing.
The format merges Interaction_ID and Topic_ID with a hyphen in between, resulting in Topic_Interaction_ID.
Interaction Type
Required: YES
Type: STRING
Description: Categorizes the type of interaction, providing insight into the nature or method of the interaction.
See Dictionary Interaction Type table in the Dictionary Dataset Specification.
Interaction Type Description
Required: YES
Type: STRING
Description: Descriptive text explaining the interaction type.
See Dictionary Interaction Type table in the Dictionary Dataset Specification.
Interaction Disposition
Required: YES
Type: STRING
Description: Indicates the outcome or status of the interaction, such as completed, pending, or void.
See Dictionary Interaction Disposition table in the Dictionary Dataset Specification.
Interaction Disposition Description
Required: YES
Type: STRING
Description: Detailed description of the interaction's outcome or status.
See Dictionary Interaction Disposition table in the Dictionary Dataset Specification.
Interaction Route Type
Required: YES
Type: STRING
Description: Describes the channel or method through which the interaction occurred, such as phone, email, or in-person.
See Dictionary Route Type table in the Dictionary Dataset Specification.
Interaction Route Type Description
Required: YES
Type: STRING
Description: Provides details about the channel or method of the interaction.
See Dictionary Route Type table in the Dictionary Dataset Specification.
Interaction Start Timestamp
Required: YES
Type: TIMESTAMP
Description: Timestamp marking the beginning of the interaction.
Interaction Stop Timestamp
Required: YES
Type: TIMESTAMP
Description: Timestamp indicating the end of the interaction.
Interaction Duration In Minutes
Required: YES
Type: INT64
Description: Total time duration of the interaction, measured in minutes.
Interaction Disclaimer
Required: YES
Type: STRING
Description: Any disclaimer or special note associated with the interaction.
Interaction Owner User ID
Required: YES
Type: STRING
Description: User ID of the individual who owns or is primarily responsible for the interaction.
Interaction Owner User Name
Required: YES
Type: STRING
Description: Full name of the interaction owner, linking to the system user's full name.
Maps to User.Full_Name.
Interaction Created Timestamp
Required: YES
Type: TIMESTAMP
Description: Timestamp indicating when the interaction was initially created or logged.
Interaction Last Modified Timestamp
Required: YES
Type: TIMESTAMP
Description: The last time the interaction record was updated or modified.
Interaction Void Indicator
Required: YES
Type: BOOL
Description: This boolean indicator determines whether the interaction has been voided or cancelled.
If the interaction's disposition is marked as VOID, the indicator is set to true; otherwise, it is set to false.
Member Enrollment Key
Required: YES
Type: STRING
Description: Unique key associating the interaction with a specific member enrollment record.
Populate it with Member_Enrollment_Key calculated with the following criteria:
Find primary active enrollment for a topic ID with attempt = 1 where topic start date is between enrollment effective and termination dates.
If multiple enrollments are found, select the one with the latest effective and termination dates.
Associate calculated enrollment from topics with attempt = 1 to corresponding topics where topic attempt is greater than 1.
Member Enrollment Effective Date
Required: YES
Type: DATE
Description: Date when the member's enrollment became effective, related to the interaction.
Maps to Member.Enrollment.Effective_Date.
Member Enrollment Termination Date
Required: YES
Type: DATE
Description: Date when the member's enrollment was terminated, if applicable to the interaction.
Maps to Member.Enrollment.Termination_Date.
Group ID
Required: YES
Type: STRING
Description: Interaction topic group ID.
Maps to Member.Enrollment.Group_ID.
Group Name
Required: YES
Type: STRING
Description: Name of the group related to the member's enrollment.
Maps to Member.Enrollment.Group_Name.
Plan ID
Required: YES
Type: STRING
Description: The plan identifier associated with the member’s enrollment, relevant to the interaction.
Maps to Member.Enrollment.Plan_ID.
Plan Description
Required: YES
Type: STRING
Description: Descriptive details of the member's health plan related to the interaction.
Maps to Member.Enrollment.Plan_Description.
Line Of Business
Required: YES
Type: STRING
Description: The line of business associated with the member's enrollment, indicating the type of service or coverage.
Maps to Member.Enrollment.Line_Of_Business.
Line Of Business Description
Required: YES
Type: STRING
Description: Detailed description of the line of business, providing context to the type of services covered under the member’s plan.
Maps to Member.Enrollment.Line_Of_Business_Desc.
Interaction Topic Dataset Specification
Interaction Topic Notes Member
Table Structure
Column Name | Is Nullable | Data Type | Description |
Interaction_Topic_Notes_Key | YES | INT64 | A unique identifier for a record in the interaction topic notes table. It serves as a primary key that links to other related tables. |
Topic_Key | YES | INT64 | The identifier of the topic to which the note pertains. It helps to associate the note with a specific interaction topic. |
Topic_ID | YES | STRING | A string identifier for the topic that facilitates human-readable association with the topic. It can be used for easier display of information in user interfaces. |
Text | YES | STRING | The actual content of the note, containing comments, observations, or additional information related to the topic. |
Author_User_ID | YES | STRING | The identifier of the user who created the note. This allows tracking who contributed the note to the system. |
Author_User_Name | YES | STRING | The full name of the user who created the note. This field links to the user's full name as specified in their profile. |
Author_User_Title | YES | STRING | The title or position of the note's author, which can be useful to understand the context and authority of the note. |
Author_Phone_Number | YES | STRING | Contact phone number of the note's author. Can be used for communication if clarification of the note is needed. |
Created_Timestamp | YES | TIMESTAMP | A timestamp indicating when the note was created in the system. Helps to track the history of interactions. |
Last_Modified_Timestamp | YES | TIMESTAMP | A timestamp of when the note was last modified. Important for understanding the currency and relevance of the information in the note. |
Interaction Topic Notes Program
Table Structure
Column Name | Is Nullable | Data Type | Description |
Interaction_Topic_Notes_Key | YES | INT64 | A unique identifier for a record in the interaction topic notes table. It serves as a primary key that links to other related tables. |
Topic_Key | YES | INT64 | The identifier of the topic to which the note pertains. It helps to associate the note with a specific interaction topic. |
Topic_ID | YES | STRING | A string identifier for the topic that facilitates human-readable association with the topic. It can be used for easier display of information in user interfaces. |
Text | YES | STRING | The actual content of the note, containing comments, observations, or additional information related to the topic. |
Author_User_ID | YES | STRING | The identifier of the user who created the note. This allows tracking who contributed the note to the system. |
Author_User_Name | YES | STRING | The full name of the user who created the note. This field links to the user's full name as specified in their profile. |
Author_User_Title | YES | STRING | The title or position of the note's author, which can be useful to understand the context and authority of the note. |
Author_Phone_Number | YES | STRING | Contact phone number of the note's author. Can be used for communication if clarification of the note is needed. |
Created_Timestamp | YES | TIMESTAMP | A timestamp indicating when the note was created in the system. Helps to track the history of interactions. |
Last_Modified_Timestamp | YES | TIMESTAMP | A timestamp of when the note was last modified. Important for understanding the currency and relevance of the information in the note. |
Interaction Topic Notes Request
Table Structure
Column Name | Is Nullable | Data Type | Description |
Interaction_Topic_Notes_Key | YES | INT64 | A unique identifier for a record in the interaction topic notes table. It serves as a primary key that links to other related tables. |
Topic_Key | YES | INT64 | The identifier of the topic to which the note pertains. It helps to associate the note with a specific interaction topic. |
Topic_ID | YES | STRING | A string identifier for the topic that facilitates human-readable association with the topic. It can be used for easier display of information in user interfaces. |
Text | YES | STRING | The actual content of the note, containing comments, observations, or additional information related to the topic. |
Author_User_ID | YES | STRING | The identifier of the user who created the note. This allows tracking who contributed the note to the system. |
Author_User_Name | YES | STRING | The full name of the user who created the note. This field links to the user's full name as specified in their profile. |
Author_User_Title | YES | STRING | The title or position of the note's author, which can be useful to understand the context and authority of the note. |
Author_Phone_Number | YES | STRING | Contact phone number of the note's author. Can be used for communication if clarification of the note is needed. |
Created_Timestamp | YES | TIMESTAMP | A timestamp indicating when the note was created in the system. Helps to track the history of interactions. |
Last_Modified_Timestamp | YES | TIMESTAMP | A timestamp of when the note was last modified. Important for understanding the currency and relevance of the information in the note. |
Interaction Topic Dataset Specification
Interaction_Topic_Program Table
Columns
Member_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the member.
Member_Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the member.
Topic_Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the topic.
Topic_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the topic.
Topic_Code
Is Nullable: YES
Data Type: STRING
Description: Code representing the topic.
Topic_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the topic.
Topic_Resolution
Is Nullable: YES
Data Type: STRING
Description: Resolution status of the topic.
Topic_Resolution_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the topic's resolution.
Topic_Duration_In_Minutes
Is Nullable: YES
Data Type: INT64
Description: Duration of the topic discussion in minutes.
Topic_Attempts
Is Nullable: YES
Data Type: INT64
Description: Number of attempts made to address the topic.
Topic_Start_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the topic discussion started.
Topic_Followup_Date
Is Nullable: YES
Data Type: DATE
Description: Date for the follow-up on the topic.
Screening_Key
Is Nullable: YES
Data Type: INT64
Description: Unique identifier for the request.
Program_ID
Is Nullable: YES
Data Type: STRING
Description: Key that uniquely identifies the request.
Topic_Owner_User_ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the owner of the topic.
Topic_Owner_User_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the owner of the topic.
Topic_Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the topic was created.
Topic_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating the last time the topic was modified.
Member_Contact_Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the member contact.
Provider_Contact_Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the provider contact.
Interaction_Association_Type
Is Nullable: YES
Data Type: STRING
Description: Type of association for the interaction.
Interaction_Association_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction association type.
Interaction_Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the interaction.
Interaction_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the interaction.
Topic_Interaction_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the interaction related to the topic.
Interaction_Type
Is Nullable: YES
Data Type: STRING
Description: Type of the interaction.
Interaction_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction type.
Interaction_Disposition
Is Nullable: YES
Data Type: STRING
Description: Disposition of the interaction.
Interaction_Disposition_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction disposition.
Interaction_Route_Type
Is Nullable: YES
Data Type: STRING
Description: Type of route for the interaction.
Interaction_Route_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction route type.
Interaction_Start_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction started.
Interaction_Stop_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction stopped.
Interaction_Duration_In_Minutes
Is Nullable: YES
Data Type: INT64
Description: Duration of the interaction in minutes.
Interaction_Disclaimer
Is Nullable: YES
Data Type: STRING
Description: Disclaimer associated with the interaction.
Interaction_Owner_User_ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the owner of the interaction.
Interaction_Owner_User_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the owner of the interaction.
Interaction_Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction was created.
Interaction_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating the last time the interaction was modified.
Interaction_Void_Indicator
Is Nullable: YES
Data Type: BOOL
Description: Indicator of whether the interaction is void.
Member_Enrollment_Key
Is Nullable: YES
Data Type: STRING
Description: Key that uniquely identifies the member's enrollment.
Member_Enrollment_Effective_Date
Is Nullable: YES
Data Type: DATE
Description: Effective date of the member's enrollment.
Member_Enrollment_Termination_Date
Is Nullable: YES
Data Type: DATE
Description: Termination date of the member's enrollment.
Group_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the group.
Group_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the group.
Plan_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the plan.
Plan_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the plan.
Line_Of_Business
Is Nullable: YES
Data Type: STRING
Description: Identifier for the line of business.
Line_Of_Business_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the line of business.
Interaction_Topic_Request Table
Columns
Member_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the member.
Member_Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the member.
Topic_Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the topic.
... (Content truncated for brevity; continue formatting remaining columns in the same structure.)
Interaction Topic Dataset Specification
Interaction_Topic_Request
Fields and Descriptions
Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the topic.
Topic_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the topic.
Topic_Code
Is Nullable: YES
Data Type: STRING
Description: Code representing the topic.
Topic_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the topic.
Topic_Resolution
Is Nullable: YES
Data Type: STRING
Description: Resolution status of the topic.
Topic_Resolution_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the topic's resolution.
Topic_Duration_In_Minutes
Is Nullable: YES
Data Type: INT64
Description: Duration of the topic discussion in minutes.
Topic_Attempts
Is Nullable: YES
Data Type: INT64
Description: Number of attempts made to address the topic.
Topic_Start_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the topic discussion started.
Topic_Followup_Date
Is Nullable: YES
Data Type: DATE
Description: Date for the follow-up on the topic.
Request_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the request.
Request_Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the request.
Topic_Owner_User_ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the owner of the topic.
Topic_Owner_User_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the owner of the topic.
Topic_Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the topic was created.
Topic_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating the last time the topic was modified.
Member_Contact_Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the member contact.
Provider_Contact_Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the provider contact.
Interaction_Association_Type
Is Nullable: YES
Data Type: STRING
Description: Type of association for the interaction.
Interaction_Association_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction association type.
Interaction_Key
Is Nullable: YES
Data Type: INT64
Description: Key that uniquely identifies the interaction.
Interaction_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the interaction.
Topic_Interaction_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the interaction related to the topic.
Interaction_Type
Is Nullable: YES
Data Type: STRING
Description: Type of the interaction.
Interaction_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction type.
Interaction_Disposition
Is Nullable: YES
Data Type: STRING
Description: Disposition of the interaction.
Interaction_Disposition_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction disposition.
Interaction_Route_Type
Is Nullable: YES
Data Type: STRING
Description: Type of route for the interaction.
Interaction_Route_Type_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the interaction route type.
Interaction_Start_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction started.
Interaction_Stop_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction stopped.
Interaction_Duration_In_Minutes
Is Nullable: YES
Data Type: INT64
Description: Duration of the interaction in minutes.
Interaction_Disclaimer
Is Nullable: YES
Data Type: STRING
Description: Disclaimer associated with the interaction.
Interaction_Owner_User_ID
Is Nullable: YES
Data Type: STRING
Description: User ID of the owner of the interaction.
Interaction_Owner_User_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the owner of the interaction.
Interaction_Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction was created.
Interaction_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating the last time the interaction was modified.
Interaction_Void_Indicator
Is Nullable: YES
Data Type: BOOL
Description: Indicator of whether the interaction is void.
Member_Enrollment_Key
Is Nullable: YES
Data Type: STRING
Description: Key that uniquely identifies the member's enrollment.
Member_Enrollment_Effective_Date
Is Nullable: YES
Data Type: DATE
Description: Effective date of the member's enrollment.
Member_Enrollment_Termination_Date
Is Nullable: YES
Data Type: DATE
Description: Termination date of the member's enrollment.
Group_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the group.
Group_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the group.
Plan_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the plan.
Plan_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the plan.
Line_Of_Business
Is Nullable: YES
Data Type: STRING
Description: Identifier for the line of business.
Line_Of_Business_Description
Is Nullable: YES
Data Type: STRING
Description: Description of the line of business.
Interaction_Topic_log
Fields and Descriptions
Member_ID
Is Nullable: YES
Data Type: STRING
Description: Unique identifier of the member associated with the interaction.
Member_Key
Is Nullable: YES
Data Type: INT64
Description: A system-generated numerical identifier that uniquely identifies a member.
Topic_Key
Is Nullable: YES
Data Type: INT64
Description: Unique key of the interaction topic within the system.
Topic_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the specific topic of interaction.
Code
Is Nullable: YES
Data Type: STRING
Description: A code that categorizes or provides a shorthand for the interaction topic.
Description
Is Nullable: YES
Data Type: STRING
Description: A textual description of the interaction topic.
Interaction Topic Dataset Specification
Interaction Topic Log
Resolution
Required: YES
Type: STRING
Description: Outcome or resolution of the interaction.\ See Dictionary Interaction Topic Resolution table in the Dictionary Dataset Specification.
Resolution Description
Required: YES
Type: STRING
Description: Detailed explanation of the interaction's resolution.\ See Dictionary Interaction Topic Resolution table in the Dictionary Dataset Specification.
Duration In Minutes
Required: YES
Type: INT64
Description: Time spent on the interaction, measured in minutes.
Attempts
Required: YES
Type: INT64
Description: The number of times this topic has been addressed or attempted.
Start Timestamp
Required: YES
Type: TIMESTAMP
Description: The starting time of the interaction.
Followup Date
Required: YES
Type: DATE
Description: Scheduled date for follow-up, if applicable.
Request Key
Required: YES
Type: INT64
Description: Unique key identifying the request related to the interaction.
Request ID
Required: YES
Type: STRING
Description: Identifier for the request associated with the interaction.
Screening Key
Required: YES
Type: INT64
Description: Unique identifier for the screening associated with the interaction.
Program ID
Required: YES
Type: STRING
Description: Identifier for the program related to the interaction.
Owner User ID
Required: YES
Type: STRING
Description: User ID of the individual owning or responsible for the interaction.
Interaction
Required: YES
Type: STRUCT
Description: A structured data type containing details about the interaction, such as key, ID, type, disposition, and timestamps.
Interaction Key
Required: YES
Type: INT64
Description: A unique identifier for the interaction event or record.
Interaction ID
Required: YES
Type: STRING
Description: A unique identifier for the interaction, often used for tracking and reference.
Member Contact Key
Required: YES
Type: INT64
Description: A unique identifier linking the topic to a specific member contact record.
Provider Contact Key
Required: YES
Type: INT64
Description: Links the topic to a specific provider contact record, if applicable.
Interaction Type
Required: YES
Type: STRING
Description: Categorizes the type of interaction, providing insight into the nature or method of the interaction.\ See Dictionary Interaction Type table in the Dictionary Dataset Specification.
Interaction Type Description
Required: YES
Type: STRING
Description: Descriptive text explaining the interaction type.\ See Dictionary Interaction Type table in the Dictionary Dataset Specification.
Interaction Disposition
Required: YES
Type: STRING
Description: Indicates the outcome or status of the interaction, such as completed, pending, or void.\ See Dictionary Interaction Disposition table in the Dictionary Dataset Specification.
Interaction Disposition Description
Required: YES
Type: STRING
Description: Detailed description of the interaction's outcome or status.\ See Dictionary Interaction Disposition table in the Dictionary Dataset Specification.
Interaction Route Type
Required: YES
Type: STRING
Description: Describes the channel or method through which the interaction occurred, such as phone, email, or in-person.\ See Dictionary Route Type table in the Dictionary Dataset Specification.
Interaction Route Type Description
Required: YES
Type: STRING
Description: Provides details about the channel or method of the interaction.\ See Dictionary Route Type table in the Dictionary Dataset Specification.
Interaction Start Timestamp
Required: YES
Type: TIMESTAMP
Description: Timestamp marking the beginning of the interaction.
Interaction Stop Timestamp
Required: YES
Type: TIMESTAMP
Description: Timestamp indicating the end of the interaction.
Interaction Duration In Minutes
Required: YES
Type: INT64
Description: Total time duration of the interaction, measured in minutes.
Interaction Disclaimer
Required: YES
Type: STRING
Description: Any disclaimer or special note associated with the interaction.
Interaction Owner User ID
Required: YES
Type: STRING
Description: User ID of the individual who owns or is primarily responsible for the interaction.
Interaction Created Timestamp
Required: YES
Type: TIMESTAMP
Description: Timestamp indicating when the interaction was initially created or logged.
Interaction Last Modified Timestamp
Required: YES
Type: TIMESTAMP
Description: The last time the interaction record was updated or modified.
Notes
Required: NO
Type: ARRAY
Description: A collection of notes related to the interaction, each with a unique key and text content.
Topic Key
Required: YES
Type: INT64
Description: Interaction topic notes topic key. The identifier of the topic to which the note pertains. It helps to associate the note with a specific interaction topic.
Text
Required: YES
Type: STRING
Description: Interaction topic notes text. The actual content of the note, containing comments, observations, or additional information related to the topic.
Author User Title
Required: YES
Type: STRING
Description: Interaction topic notes author user title. The title or position of the note's author, which can be useful to understand the context and authority of the note.
Author Phone Number
Required: YES
Type: STRING
Description: Interaction topic notes author phone number. Contact phone number of the note's author. Can be used for communication if clarification of the note is needed.
Created Timestamp
Required: YES
Type: TIMESTAMP
Description: Interaction topic notes created timestamp. A timestamp indicating when the note was created in the system. Helps to track the history of interactions.
Last Modified Timestamp
Required: YES
Type: TIMESTAMP
Description: Interaction topic notes last modified timestamp. A timestamp of when the note was last modified. Important for understanding the currency and relevance of the information in the note.
Record Last Modified Timestamp
Required: YES
Type: TIMESTAMP
Description: Timestamp of the last modification to the interaction record.
Transaction User ID
Required: YES
Type: STRING
Description: Identifier for the user who last modified the interaction record.
Created Timestamp
Required: YES
Type: TIMESTAMP
Description: Timestamp indicating when the interaction record was created.
Interaction Topic Dataset Specification
Interaction Topic Log
TAMP
Data Type: TIMESTAMP
Description: The timestamp when the interaction record was initially created.
Last_Modified_Timestamp
Data Type: TIMESTAMP
Description: The most recent timestamp when the interaction record was updated.
Type
Data Type: STRING
Description: The type of interaction (e.g., call, email, meeting).
Tenant
Data Type: STRING
Description: Identifier for the tenant or organizational unit.
Active_Version
Data Type: BOOL
Description: Indicates whether the log entry is the current active version.
Date
Data Type: DATE
Description: The date of the interaction.
Sequence
Data Type: INT64
Description: A numerical sequence order for the interaction within a given context or set.
Source_System_Name
Data Type: STRING
Description: The name of the system where the interaction data originated.
Source_Timestamp
Data Type: TIMESTAMP
Description: Timestamp from the source system when the interaction was logged.
Source_File_Name
Data Type: STRING
Description: The name of the file from which the interaction data was sourced.
Deleted_Indicator
Data Type: BOOL
Description: A boolean flag indicating whether the interaction record has been marked as deleted.
Deleted_Indicator = false: Used as a filter to exclude deleted topic records from all views.
Schema_Version
Data Type: FLOAT64
Description: Version of the schema used for the interaction data.
Member_Partition
Data Type: INT64
Description: A numerical identifier used to partition member data for scalability and management.
Action
Data Type: STRING
Description: The action taken or logged in this interaction record.
Member_ID
Data Type: STRING
Description: This repeated field likely indicates a historical or log-specific instance of the member ID involved in the interaction.
Member_Key
Data Type: INT64
Description: Represents a unique system-generated key for the member, specific to the interaction log context.
Topic_Key
Data Type: INT64
Description: A unique identifier for the topic within the interaction log, used for tracking and reference purposes.
Transaction_Actor_Type
Data Type: STRING
Description: Type of the actor performing the transaction.
Interaction Topic Raw
Member_ID
Data Type: STRING
Description: Identifier of the member associated with the interaction topic, linking the interaction to a specific individual in the database.
Member_Key
Data Type: INT64
Description: A numeric key unique to the member, used for internal tracking and linking within the database system.
Topic_Key
Data Type: INT64
Description: A unique identifier for the interaction topic, facilitating the tracking and referencing of specific topics.
Topic_ID
Data Type: STRING
Description: The string identifier of the topic, used for display and easy identification in user interfaces.
Code
Data Type: STRING
Description: A code that categorizes or identifies the topic within a predefined classification system.
Description
Data Type: STRING
Description: A textual description of the interaction topic, providing detailed information about its nature and content.
Resolution
Data Type: STRING
Description: The outcome or resolution of the interaction, indicating how the topic was concluded or addressed.
Resolution_Description
Data Type: STRING
Description: Detailed description of the resolution, offering insight into the outcome of the interaction.
Duration_In_Minutes
Data Type: INT64
Description: The total time spent on the interaction, measured in minutes, providing a quantifiable measure of the interaction's extent.
Attempts
Data Type: INT64
Description: The number of attempts made to address or resolve the topic, indicating the level of effort or engagement required.
Start_Timestamp
Data Type: TIMESTAMP
Description: The timestamp marking the beginning of the interaction, used for timing and historical tracking.
Followup_Date
Data Type: DATE
Description: A specified date for follow-up on the topic, ensuring that the interaction is revisited or concluded as necessary.
Request_Key
Data Type: INT64
Description: An identifier linking the topic to a specific request in the system, for tracking and reference purposes.
Request_ID
Data Type: STRING
Description: The unique string identifier of the related request, used for cross-referencing and coordination with other processes.
Screening_Key
Data Type: INT64
Description: A key associated with any screening process linked to the interaction topic, for integrated healthcare management.
Program_ID
Data Type: STRING
Description: Identifier of the program related to the interaction topic, aligning the topic with broader organizational or treatment programs.
Owner_User_ID
Data Type: STRING
Description: The identifier of the user responsible for or owning the topic, ensuring accountability and ownership within the system.
Interaction
Data Type: STRUCT
Description: A structured data type containing details about the interaction, such as key, ID, type, disposition, and timestamps.
Interaction.Interaction_Key
Data Type: INT64
Description: A unique identifier for the interaction event or record.
Interaction.Interaction_ID
Data Type: STRING
Description: A unique identifier for the interaction, often used for tracking and reference.
Interaction.Member_Contact_Key
Data Type: INT64
Description: A unique identifier linking the topic to a specific member contact record.
Interaction.Provider_Contact_Key
Data Type: INT64
Description: Links the topic to a specific provider contact record, if applicable.
Interaction.Interaction_Type
Data Type: STRING
Description: Categorizes the type of interaction.
Interaction Topic Dataset Specification
Interaction Fields
Interaction_Type
Field Name: Interaction.Interaction_Type
Required: YES
Data Type: STRING
Description: Indicates the type of interaction, providing insight into the nature or method of the interaction.\ See Dictionary Interaction Type table in the Dictionary Dataset Specification.
Interaction_Type_Description
Field Name: Interaction.Interaction_Type_Description
Required: YES
Data Type: STRING
Description: Descriptive text explaining the interaction type.\ See Dictionary Interaction Type table in the Dictionary Dataset Specification.
Interaction_Disposition
Field Name: Interaction.Interaction_Disposition
Required: YES
Data Type: STRING
Description: Indicates the outcome or status of the interaction, such as completed, pending, or void.\ See Dictionary Interaction Disposition table in the Dictionary Dataset Specification.
Interaction_Disposition_Description
Field Name: Interaction.Interaction_Disposition_Description
Required: YES
Data Type: STRING
Description: Detailed description of the interaction's outcome or status.\ See Dictionary Interaction Disposition table in the Dictionary Dataset Specification.
Interaction_Route_Type
Field Name: Interaction.Interaction_Route_Type
Required: YES
Data Type: STRING
Description: Describes the channel or method through which the interaction occurred, such as phone, email, or in-person.\ See Dictionary Route Type table in the Dictionary Dataset Specification.
Interaction_Route_Type_Description
Field Name: Interaction.Interaction_Route_Type_Description
Required: YES
Data Type: STRING
Description: Provides details about the channel or method of the interaction.\ See Dictionary Route Type table in the Dictionary Dataset Specification.
Interaction_Start_Timestamp
Field Name: Interaction.Interaction_Start_Timestamp
Required: YES
Data Type: TIMESTAMP
Description: Timestamp marking the beginning of the interaction.
Interaction_Stop_Timestamp
Field Name: Interaction.Interaction_Stop_Timestamp
Required: YES
Data Type: TIMESTAMP
Description: Timestamp indicating the end of the interaction.
Interaction_Duration_In_Minutes
Field Name: Interaction.Interaction_Duration_In_Minutes
Required: YES
Data Type: INT64
Description: Total time duration of the interaction, measured in minutes.
Interaction_Disclaimer
Field Name: Interaction.Interaction_Disclaimer
Required: YES
Data Type: STRING
Description: Any disclaimer or special note associated with the interaction.
Interaction_Owner_User_ID
Field Name: Interaction.Interaction_Owner_User_ID
Required: YES
Data Type: STRING
Description: User ID of the individual who owns or is primarily responsible for the interaction.
Interaction_Created_Timestamp
Field Name: Interaction.Interaction_Created_Timestamp
Required: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the interaction was initially created or logged.
Interaction_Last_Modified_Timestamp
Field Name: Interaction.Interaction_Last_Modified_Timestamp
Required: YES
Data Type: TIMESTAMP
Description: The last time the interaction record was updated or modified.
Interaction Topic Notes
Topic_Key
Field Name: Notes.Topic_Key
Required: YES
Data Type: INT64
Description: Interaction topic notes topic key. The identifier of the topic to which the note pertains. It helps to associate the note with a specific interaction topic.
Text
Field Name: Notes.Text
Required: YES
Data Type: STRING
Description: Interaction topic notes text. The actual content of the note, containing comments, observations, or additional information related to the topic.
Author_User_Title
Field Name: Notes.Author_User_Title
Required: YES
Data Type: STRING
Description: Interaction topic notes author user title. The title or position of the note's author, which can be useful to understand the context and authority of the note.
Author_Phone_Number
Field Name: Notes.Author_Phone_Number
Required: YES
Data Type: STRING
Description: Interaction topic notes author phone number. Contact phone number of the note's author. Can be used for communication if clarification of the note is needed.
Created_Timestamp
Field Name: Notes.Created_Timestamp
Required: YES
Data Type: TIMESTAMP
Description: Interaction topic notes created timestamp. A timestamp indicating when the note was created in the system. Helps to track the history of interactions.
Last_Modified_Timestamp
Field Name: Notes.Last_Modified_Timestamp
Required: YES
Data Type: TIMESTAMP
Description: Interaction topic notes last modified timestamp. A timestamp of when the note was last modified. Important for understanding the currency and relevance of the information in the note.
Interaction Topic Raw Fields
Record_Last_Modified_Timestamp
Field Name: Interaction_Topic_raw.Record_Last_Modified_Timestamp
Required: YES
Data Type: TIMESTAMP
Description: The timestamp of the last modification made to the record, indicating the most recent update or change.
Transaction_User_ID
Field Name: Interaction_Topic_raw.Transaction_User_ID
Required: YES
Data Type: STRING
Description: The identifier of the user who last modified the topic record, used for tracking changes and user activity.
Created_Timestamp
Field Name: Interaction_Topic_raw.Created_Timestamp
Required: YES
Data Type: TIMESTAMP
Description: The timestamp when the topic record was initially created in the system, marking the beginning of its lifecycle.
Last_Modified_Timestamp
Field Name: Interaction_Topic_raw.Last_Modified_Timestamp
Required: YES
Data Type: TIMESTAMP
Description: The most recent timestamp when the topic record was updated, reflecting the latest changes or actions taken.
Type
Field Name: Interaction_Topic_raw.Type
Required: YES
Data Type: STRING
Description: A classification or category of the interaction topic, providing a way to organize or group topics systematically.
Tenant
Field Name: Interaction_Topic_raw.Tenant
Required: YES
Data Type: STRING
Description: A reference to the tenant under which the topic record is managed, indicating the organizational segment or division.
Active_Version
Field Name: Interaction_Topic_raw.Active_Version
Required: YES
Data Type: BOOL
Description: A boolean indicator signifying whether the topic record is the current active version, used for version control and data integrity.
Date
Field Name: Interaction_Topic_raw.Date
Required: YES
Data Type: DATE
Description: The date associated with the interaction topic, potentially marking an event or action related to the topic.
Sequence
Field Name: Interaction_Topic_raw.Sequence
Required: YES
Data Type: INT64
Description: A numerical order or sequence number for the topic, used for ordering or prioritizing within a list or series.
Source_System_Name
Field Name: Interaction_Topic_raw.Source_System_Name
Required: YES
Data Type: STRING
Description: The name of the source system from which the interaction topic data originates, providing context for data integration.
Source_Timestamp
Field Name: Interaction_Topic_raw.Source_Timestamp
Required: YES
Data Type: TIMESTAMP
Description: The timestamp from the source system, indicating when the data was generated or recorded at the origin.
Source_File_Name
Field Name: Interaction_Topic_raw.Source_File_Name
Required: YES
Data Type: STRING
Description: The name of the file from the source system, aiding in data traceability and management.
Deleted_Indicator
Field Name: Interaction_Topic_raw.Deleted_Indicator
Required: YES
Data Type: BOOL
Description: A boolean flag indicating whether the topic record has been marked as deleted, used to filter out inactive or removed records.
Deleted_Indicator = false: Used as a filter to exclude deleted topic records from all views.
Schema_Version
Field Name: Interaction_Topic_raw.Schema_Version
Required: YES
Data Type: FLOAT64
Description: A version number for the database schema, used to manage and track changes in the data structure over time.
Interaction Topic Dataset Specification
Member Partition
Field Name: Member_Partition
Required: YES
Data Type: INT64
Description:\ A partitioning key for segmenting member data, optimizing data management and query performance within the database system.
Interaction Topic Raw
Transaction Actor Type
Field Name: Transaction_Actor_Type
Required: YES
Data Type: STRING
Description:\ Type of the actor performing the transaction.