Member App Dataset Specification

The "Member App Dataset Specification" is designed to manage and track member interactions and rewards within healthcare systems, adhering to healthcare-specific standards for privacy, data integrity, and user engagement. This dataset supports the functionality of member-facing applications, allowing healthcare organizations to enhance patient engagement, monitor activity, and offer rewards for participation in health-related activities.

This dataset plays a critical role in healthcare organizations looking to foster greater patient participation and engagement through member apps. By tracking rewards and activities, healthcare providers can encourage healthier lifestyles, promote wellness programs, and maintain compliance with healthcare standards for data security and patient privacy.

Key Tables

Member App Reward

Stores information on rewards earned by members for engaging in health-related activities within the app. This table tracks reward details, such as the type of reward, date of issue, and criteria for earning it, supporting efforts to encourage healthier behavior.

Columns

Member_App_Reward_Key: Unique identifier for the member's app reward. (Is Nullable: NO, Data Type: STRING)
Actor_Type: Specifies the type of actor associated with the reward (constant "MEMBER_APP"). (Is Nullable: YES, Data Type: STRING)
Member_ID: Unique identifier for the member receiving the reward (acm member id). (Is Nullable: NO, Data Type: STRING)
Program_Screening_Key: Unique identifier for the program screening related to the reward (MIP id). (Is Nullable: YES, Data Type: INT64)
Program_ID: Identifier for the program under which the reward is given. (Is Nullable: NO, Data Type: STRING)
Reward: The code of the reward, for instance FIRST_ASSESSMENT_COMPLETED. (Is Nullable: YES, Data Type: STRING)
Reward_Description: Detailed description of the reward (e.g., “First Assessment Completed”). (Is Nullable: YES, Data Type: STRING)
Entity_Key: Identifier for the entity associated with the reward. (Is Nullable: YES, Data Type: STRING)
Entity_Type: The type of action performed by the member. (ENUM: Assessment, Check_in, Edu_Content, Goal; Is Nullable: YES, Data Type: STRING)
Reward_Status: Indicates reward status. (ENUM: IN_PROGRESS, COMPLETED; Is Nullable: YES, Data Type: STRING)
Reward_Status_Description: Description of the current reward status. (Is Nullable: YES, Data Type: STRING)
Created_Timestamp: The UTC timestamp when the reward was created. (Is Nullable: YES, Data Type: TIMESTAMP)
Last_Modified_Timestamp: The UTC timestamp when the reward status was last modified. (Is Nullable: YES, Data Type: TIMESTAMP)

Member App Reward Log

Maintains a historical record of all changes and updates to member rewards. This log provides a transparent audit trail, allowing healthcare organizations to track modifications and ensure accurate reward management.

Columns

Actor_Type: Specifies the type of actor associated with the reward (constant "MEMBER_APP"). (Is Nullable: YES, Data Type: STRING)
Member_App_Reward_Key: Unique identifier for the member's app reward in the log. (Is Nullable: NO, Data Type: STRING)
Member_ID: Unique identifier for the member receiving the reward (acm member id). (Is Nullable: NO, Data Type: STRING)
Program_Screening_Key: Unique identifier for the program screening related to the reward (MIP id). (Is Nullable: YES, Data Type: INT64)
Reward: Description of the reward provided to the member. (Is Nullable: YES, Data Type: STRING)
Reward_Description: Detailed description of the reward (e.g., “First Assessment Completed”). (Is Nullable: YES, Data Type: STRING)
Entity_Key: Identifier for the entity associated with the reward. (Is Nullable: YES, Data Type: STRING)
Entity_Type: The type of action performed by the member. (ENUM: Assessment, Check_in, Edu_Content, Goal; Is Nullable: YES, Data Type: STRING)
Reward_Status: Indicates reward status. (ENUM: IN_PROGRESS, COMPLETED; Is Nullable: YES, Data Type: STRING)
Reward_Status_Description: Description of the current reward status. (Is Nullable: YES, Data Type: STRING)
Created_Timestamp: The UTC timestamp when the reward was created. (Is Nullable: YES, Data Type: TIMESTAMP)
Last_Modified_Timestamp: The UTC timestamp when the reward status was last modified. (Is Nullable: YES, Data Type: TIMESTAMP)
Record_Last_Modified_Timestamp: Timestamp when the log record was last modified. (Is Nullable: NO, Data Type: TIMESTAMP)
Transaction_User_ID: Identifier of the user who performed the last transaction. (Is Nullable: NO, Data Type: STRING)
Type: Specifies the type of the reward log entry. (Is Nullable: YES, Data Type: STRING)
Tenant: Identifies the tenant associated with the reward log entry. (Is Nullable: YES, Data Type: STRING)
Active_Version: Indicates whether the log entry is part of the active version. (Is Nullable: NO, Data Type: BOOL)
Date: The date the log entry was recorded. (Is Nullable: YES, Data Type: DATE)
Sequence: The sequence number of the log entry. (Is Nullable: YES, Data Type: INT64)
Source_System_Name: Name of the system from which the log entry originated. (Is Nullable: YES, Data Type: STRING)
Source_Timestamp: The timestamp when the source system recorded the entry. (Is Nullable: YES, Data Type: TIMESTAMP)

Member App Activity Log

Captures details of all member activities within the app, such as completed health assessments, participation in wellness programs, or usage of app features. This log is essential for understanding member engagement and tracking behavior that contributes to improved health outcomes.

Records information related to member sign-ins, including timestamps and device details. This table helps monitor member access patterns, providing insights into app usage and ensuring security compliance.

Member App Reward Raw

Contains unprocessed, detailed data related to member rewards. This raw data is essential for in-depth analysis and reporting, supporting further insights into reward programs and member engagement.