Skip to main content

Cost Saving Dataset Specification

Updated over a month ago

Cost Saving Dataset Specification

Cost Saving Dataset Specification

Overview

The "Cost Saving Dataset Specification" contains cost-saving information for programs or requests. The unique key is Cost_Saving_Key. It references members by Member_ID and optionally references related requests by both Request_Key and Request_ID. Additionally, it optionally references related programs by both Program_ID and Program_Enrollment_Key.

Key Features

  • Cost Saving Log:\ This table meticulously records every detail related to cost-saving activities, including the implementation steps and outcomes of each initiative. It provides a systematic timeline that tracks the progress and effectiveness of cost-saving measures over time.

  • Cost Saving Raw Data:\ This table contains unprocessed, detailed data concerning cost-saving efforts. It serves as a foundational resource for in-depth analysis, offering insights into the financial impacts of these activities and aiding in the evaluation of their success. This dataset is crucial for organizations aiming to optimize their cost-saving strategies, providing the tools needed to monitor, evaluate, and refine efforts to reduce expenditures effectively.

Table Specifications

Cost_Saving_Log Table

Columns

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Identifier for the member associated with the cost-saving activity. It is used to capture Client Code and Description, providing a unique reference to the member in the dataset.

  • Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description:\ Key representing the enrollment of a member in a program. Used to retrieve program-related data and calculate fields like Line Of Business, Plan, and Group Information in the summary view.

    Join Logic:

    • Data integration involves joining the Cost_Saving table with the Program and Member tables based on the provided conditions.

    • Use these fields to get program-related data.

    • Use these fields in the summary view to calculate fields like Line Of Business, Plan, and Group Information.

    Data Integration:

    • Links are established between the Cost_Saving, Program, and Member tables to ensure comprehensive data accessibility.

    • Associating each cost-saving instance with the corresponding program using Program.Program_Enrollment_Key.

    • Linking cost-saving records to specific members via Member.Member_ID.

    Data Validity:

    • Include records only where the Cost.Savings_Documentation_End_Date is specified.

    • Exclude any records flagged as void or deleted, using indicators such as Costs.Void_Indicator, Cost_Saving_Void_Indicator, and Cost_Saving.Deleted_Indicator.

    Summary Analysis:

    • For strategic overviews and detailed reporting, data is categorized and analyzed based on key program characteristics, which include:

      • Program enrollment details, such as Enrollment_Program and Enrollment_Program_Description.

      • Product specifics like Enrollment_Product and Enrollment_Product_Description.

      • Group and plan identifiers, including Group_ID, Group_Name, Plan_ID, and Plan_Description.

      • Business line categories, captured in Line_Of_Business and Line_Of_Business_Description.

    • Program_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description:\ To facilitate effective management of cost-saving activities within healthcare programs, a specific program identifier is utilized. This identifier is essential for linking cost-saving records to detailed program data, thereby enhancing strategic planning and reporting.

    Data Linking:

    • Connects the Cost_Saving table with both the Program and Member tables to create a comprehensive dataset.

    • Matching Program.Program_Enrollment_Key with corresponding entries in the Cost_Saving table.

    • Associating Member.Member_ID with relevant cost-saving records.

    Criteria for Data Inclusion:

    • Only records with a non-null Cost.Savings_Documentation_End_Date are included.

    • Records are vetted to exclude any that are marked as void or deleted, ensuring data quality through indicators like Costs.Void_Indicator, Cost_Saving_Void_Indicator, and Cost_Saving.Deleted_Indicator.

    Analytical Grouping for Reporting:

    • In summary views, data is organized and analyzed by crucial program attributes for a clearer understanding and better decision-making:

      • Program identifiers such as Enrollment_Program and its description.

      • Details about the product involved, listed under Enrollment_Product and its description.

      • Group and plan information including Group_ID, Group_Name, Plan_ID, and Plan_Description.

      • Line of Business and related details, ensuring strategic alignment across reporting.

    • Request_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description:\ Identifier for the request associated with the cost-saving activity. Used to retrieve request-related data and calculate fields like Client Code, Line Of Business, Plan, and Group Information in the summary view.

    Join Logic:

    • Use these fields to get request-related data.

    • Use these fields in the summary view to calculate fields like Client Code, Line Of Business, Plan, and Group Information.

    Data Integration:

    • Connects the Cost_Saving table with the Request and Member tables to ensure a comprehensive dataset.

    • Associating Request.Request_ID and Request.Request_Key with corresponding entries in the Cost_Saving table.

    • Linking Member.Member_ID with relevant cost-saving records.

    Data Validation Criteria:

    • Records are included only if Cost.Savings_Documentation_End_Date is filled.

    • Exclude any entries flagged as void or deleted, as indicated by Costs.Void_Indicator, Cost_Saving_Void_Indicator, and Cost_Saving.Deleted_Indicator.

    Summary View Grouping:

    • For efficient high-level analysis, data is systematically grouped by essential request attributes:

      • Request characteristics such as Request_ID and Request_Key.

      • Client Code, Line Of Business, Plan, and Group Information.

Cost Saving Dataset Specification

Overview

The Cost Saving Dataset Specification provides detailed information about the structure, attributes, and integration strategies for cost-saving activities. This document outlines the key fields, their descriptions, and the criteria for data inclusion to ensure integrity and relevance in financial analysis and decision-making.

Data Integration Strategy

To ensure a thorough compilation of data, the Cost_Saving table is linked with the Request and Member tables:

  • Request Integration: The connection is established by matching Request.Request_ID and Request.Request_Key with their corresponding entries in the Cost_Saving table.

  • Member Integration: Each cost-saving record is associated with member information using Member.Member_ID.

Criteria for Data Inclusion

To maintain data integrity and relevance:

  • Only entries with a specified Cost.Savings_Documentation_End_Date are considered.

  • Records flagged as void or deleted are excluded, guided by:

  • Costs.Void_Indicator

  • Cost_Saving_Void_Indicator

  • Cost_Saving.Deleted_Indicator

Analytical Grouping for Summaries

For high-level analyses, especially useful in strategic discussions and reporting, data is organized by essential request features:

  • Attributes of the request, such as Request_Type.

  • Group and plan details, including:

  • Group_ID

  • Group_Name

  • Plan_ID

  • Plan_Description

  • Categories and descriptions within the Line of Business.

Cost_Saving_log Fields

Request_Key

  • Type: INT64

  • Description: Key representing the request associated with the cost-saving activity.

  • Used to retrieve request-related data and calculate fields like Client Code, Line Of Business, Plan, and Group Information in the Summary view.

  • Serves as a pivotal link to aggregate cost-saving records with detailed request data, enriching financial analysis and decision-making.

Cost_Saving_Key

  • Type: STRING

  • Description: Key to uniquely identify the cost-saving record.

Cost_Saving_ID

  • Type: STRING

  • Description: Identifier for the cost-saving activity.

Cost_Saving_Type

  • Type: STRING

  • Description: Type of cost-saving activity.

Cost_Saving_Type_Description

  • Type: STRING

  • Description: Description of the type of cost-saving activity.

Cost_Saving_Code

  • Type: STRING

  • Description: Code representing the cost-saving activity.

Cost_Saving_Description

  • Type: STRING

  • Description: Description of the cost-saving activity.

Other_Cost_Saving_Description

  • Type: STRING

  • Description: Additional description or details related to the cost-saving activity.

Savings_Documentation_Start_Date

  • Type: DATE

  • Description: Start date of the documentation for savings.

Savings_Documentation_End_Date

  • Type: DATE

  • Description: End date of the documentation for savings.

  • If the record is not void and includes a Savings_Documentation_End_Date, the system formats this date to display only the year and month in YYYYMM format.

Void_Indicator

  • Type: BOOL

  • Description: Indicator to denote if the cost-saving record is voided.

Void_Reason

  • Type: STRING

  • Description: Reason for voiding the cost-saving record.

Void_Reason_Description

  • Type: STRING

  • Description: Description of the reason for voiding the cost-saving record.

Permission_Required

  • Type: BOOL

  • Description: Indicator to specify if permission is required for the cost-saving activity.

Savings_For_Service_Amount

  • Type: NUMERIC

  • Description: Amount of savings for the service.

Care_Management_Type

  • Type: STRING

  • Description: Type of care management associated with the cost-saving activity.

Care_Management_Type_Description

  • Type: STRING

  • Description: Description of the type of care management associated with the cost-saving activity.

Coordinated_Care_Discharge_Disposition

  • Type: STRING

  • Description: Discharge disposition for coordinated care.

Coordinated_Care_Discharge_Disposition_Description

  • Type: STRING

  • Description: Description of the discharge disposition for coordinated care.

Created_User_ID

  • Type: STRING

  • Description: User ID of the user who created the cost-saving record.

Last_Modified_User_ID

  • Type: STRING

  • Description: User ID of the user who last modified the cost-saving record.

Permission_From_Name

  • Type: STRING

  • Description: Name of the entity granting permission for the cost-saving activity.

Permission_From_Role

  • Type: STRING

  • Description: Role of the entity granting permission for the cost-saving activity.

Medical_Director_Name

  • Type: STRING

  • Description: Name of the medical director associated with the cost-saving activity.

Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the cost-saving record was created.

Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the cost-saving record was last modified.

Costs Fields

Key

  • Type: STRING

  • Description: A unique identifier for each cost record within the log.

Cost_ID

  • Type: STRING

  • Description: An identifier associated with the specific cost entry.

Original_Indicator

  • Type: BOOL

  • Description: Indicates whether the cost record is the original entry or a modified version.

Void_Indicator

  • Type: BOOL

  • Description: Indicates if the cost record has been voided or cancelled.

Void_Reason

  • Type: STRING

  • Description: Code identifying the reason a cost record was voided.

Void_Reason_Description

  • Type: STRING

  • Description: Detailed description of why the cost record was voided.

Diagnosis_Code

  • Type: STRING

  • Description: Code for the diagnosis related to the cost entry, based on a standard coding scheme.

Diagnosis_Description

  • Type: STRING

  • Description: Detailed description of the diagnosis linked to the cost.

Diagnosis_Group

  • Type: STRING

  • Description: Group or category of the diagnosis based on a classification system.

Diagnosis_Group_Description

  • Type: STRING

  • Description: Description of the diagnosis group, providing context about the categorization.

Diagnosis_Coding_Scheme

  • Type: STRING

  • Description: The coding scheme used for the diagnosis, such as ICD-10.

Bed_Type

  • Type: STRING

  • Description: Type of bed utilized during the patient's care, categorized for billing purposes.

Bed_Type_Description

  • Type: STRING

  • Description: Description of the bed type, explaining its specifications or purposes.

Cost Saving Dataset Specification

Costs

Type of Care

  • Column Name: Type_Of_Care

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category of care provided, which could affect the billing and costs.

Type of Care Description

  • Column Name: Type_Of_Care_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the type of care provided.

Units

  • Column Name: Units

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of units of the billed service or item.

Cost Per Unit

  • Column Name: Cost_Per_Unit

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Cost per unit of service or item provided, typically used in calculation of total costs.

Cost Type

  • Column Name: Cost_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification of the cost, such as direct, indirect, fixed, variable, etc.

Primary Service Coding Scheme

  • Column Name: Primary_Service_Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Coding scheme used for the primary service provided, helping in standardized billing.

Service Code

  • Column Name: Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code identifying the specific service provided, according to the relevant coding scheme.

Service Description

  • Column Name: Service_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the service provided, detailing what the service involved.

Service Provider Name

  • Column Name: Service_Provider_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the provider or facility that delivered the service.

Service Unit of Measure

  • Column Name: Service_Unit_Of_Measure

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unit of measure used for the service provided, essential for accurate documentation and billing.

Created User ID

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who initially created the cost record.

Last Modified User ID

  • Column Name: Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who last modified the cost record.

Created Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the cost record was first created.

Last Modified Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the cost record was last updated.

Cost Saving Log

Notes

  • Column Name: Notes

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Additional notes or comments related to the cost saving activity.

Key

  • Column Name: Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for each note entry within the log, ensuring traceability.

Text

  • Column Name: Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content of the note, providing detailed information or commentary related to healthcare costs.

Author User ID

  • Column Name: Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who authored the note.

Author Full Name

  • Column Name: Author_Full_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The full name of the note's author, providing clarity on who provided the information.

Author User Title

  • Column Name: Author_User_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The professional title of the author, indicating their role or position within the healthcare system.

Author Phone Number

  • Column Name: Author_Phone_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Contact phone number for the note's author, facilitating follow-up or clarification if needed.

Created Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was initially created, documenting the time of the communication.

Last Modified Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was last modified, tracking changes or updates to the information.

Record Last Modified Timestamp

  • Column Name: Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was last modified.

Transaction User ID

  • Column Name: Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID associated with the transaction related to the cost saving activity.

Deleted Indicator

  • Column Name: Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator to denote if the cost saving record is deleted.

Type

  • Column Name: Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the cost saving activity.

Tenant

  • Column Name: Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant information related to the cost saving activity.

Active Version

  • Column Name: Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Active version of the cost saving record.

Date

  • Column Name: Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the cost saving activity.

Sequence

  • Column Name: Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number for the cost saving activity.

Source System Name

  • Column Name: Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system for the cost saving data.

Source Timestamp

  • Column Name: Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the data was sourced.

Source File Name

  • Column Name: Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file for the cost saving data.

Schema Version

  • Column Name: Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the cost saving data.

Member Partition

  • Column Name: Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition information related to the member.

Action

  • Column Name: Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed related to the cost saving activity.

Other Coordinated Care Discharge Disposition Description

  • Column Name: Other_Coordinated_Care_Discharge_Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description for the coordinated care discharge disposition related to the cost saving activity.

Transaction Actor Type

  • Column Name: Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Cost Saving Raw

Member ID

  • Column Name: Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member associated with the cost saving activity. It is used to capture Client Code and Description, providing a unique reference to the member in the dataset.

Program Enrollment Key

  • Column Name: Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key representing the enrollment of a member in a program. Used to retrieve Program related data and calculate fields like Line Of Business, Plan, and Group Information in the Summary view. The join logic involves joining the Cost_Saving table with the Program and Member tables based on the provided conditions.

Program ID

  • Column Name: Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program associated with the cost saving activity. Used to retrieve Program related data and calculate fields like Line Of Business, Plan, and Group Information in the Summary view. The join logic involves joining the Cost_Saving table with the Program and Member tables based on the provided conditions.

Request ID

  • Column Name: Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the request associated with the cost-saving activity. Use to retrieve Request related data and calculate fields like Client Code, Line Of Business, Plan, and Group Information in the Summary view.

Request Key

  • Column Name: Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key representing the request associated with the cost-saving activity. Use to retrieve Request related data and calculate fields like Client Code, Line Of Business, Plan, and Group Information in the Summary view.

Cost Saving Key

  • Column Name: Cost_Saving_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key to uniquely identify the cost saving record.

Cost Saving ID

  • Column Name: Cost_Saving_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the cost saving activity.

Cost Saving Type

  • Column Name: Cost_Saving_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of cost saving activity.

Cost Saving Type Description

  • Column Name: Cost_Saving_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the type of cost saving activity.

Cost Saving Code

  • Column Name: Cost_Saving_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code associated with the cost saving activity.

Cost Saving Dataset Specification

Cost Saving Activity Fields

Cost_Saving_raw

  • Cost_Saving_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the cost saving activity.

  • Other_Cost_Saving_Description

  • Type: STRING

  • Required: YES

  • Description: Additional description or details related to the cost saving activity.

  • Savings_Documentation_Start_Date

  • Type: DATE

  • Required: YES

  • Description: Start date of the documentation for savings.

  • Savings_Documentation_End_Date

  • Type: DATE

  • Required: YES

  • Description: End date of the documentation for savings.

  • Void_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicator to denote if the cost saving record is voided.

  • Void_Reason

  • Type: STRING

  • Required: YES

  • Description: Reason for voiding the cost saving record.

  • Void_Reason_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the reason for voiding the cost saving record.

  • Permission_Required

  • Type: BOOL

  • Required: YES

  • Description: Indicator to specify if permission is required for the cost saving activity.

  • Savings_For_Service_Amount

  • Type: NUMERIC

  • Required: YES

  • Description: Amount of savings for the service.

  • Care_Management_Type

  • Type: STRING

  • Required: YES

  • Description: Type of care management associated with the cost saving activity.

  • Care_Management_Type_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the type of care management associated with the cost saving activity.

  • Coordinated_Care_Discharge_Disposition

  • Type: STRING

  • Required: YES

  • Description: Discharge disposition for coordinated care.

  • Coordinated_Care_Discharge_Disposition_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the discharge disposition for coordinated care.

  • Created_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who created the cost saving record.

  • Last_Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the cost saving record.

  • Permission_From_Name

  • Type: STRING

  • Required: YES

  • Description: Name of the entity granting permission for the cost saving activity.

  • Permission_From_Role

  • Type: STRING

  • Required: YES

  • Description: Role of the entity granting permission for the cost saving activity.

  • Medical_Director_Name

  • Type: STRING

  • Required: YES

  • Description: Name of the medical director associated with the cost saving activity.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the cost saving record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the cost saving record was last modified.

Costs Fields

Costs

  • Costs.Key

  • Type: STRING

  • Required: YES

  • Description: A unique identifier for each cost record within the dataset, ensuring traceability and uniqueness.

  • Costs.Cost_ID

  • Type: STRING

  • Required: YES

  • Description: An identifier associated with the specific cost entry, used for tracking and referencing costs.

  • Costs.Original_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicates whether the cost record is the original entry or has been adjusted or modified.

  • Costs.Void_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicates if the cost record has been nullified or invalidated, typically due to an error or change in status.

  • Costs.Void_Reason

  • Type: STRING

  • Required: YES

  • Description: The reason code for voiding the cost record, providing a quick reference to why the entry was nullified.

  • Costs.Void_Reason_Description

  • Type: STRING

  • Required: YES

  • Description: A detailed description of why the cost record was voided, offering context and justification.

  • Costs.Diagnosis_Code

  • Type: STRING

  • Required: YES

  • Description: The code for the diagnosis related to the cost entry, following a standardized medical coding system.

  • Costs.Diagnosis_Description

  • Type: STRING

  • Required: YES

  • Description: A detailed description of the diagnosis linked to the cost, helping to clarify the medical context.

  • Costs.Diagnosis_Group

  • Type: STRING

  • Required: YES

  • Description: The classification group to which the diagnosis belongs, aiding in broader categorization within healthcare.

  • Costs.Diagnosis_Group_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the diagnosis group, providing insights into the classification and its healthcare implications.

  • Costs.Diagnosis_Coding_Scheme

  • Type: STRING

  • Required: YES

  • Description: The coding scheme used for the diagnosis, such as ICD-10, which standardizes the way diagnoses are recorded.

  • Costs.Bed_Type

  • Type: STRING

  • Required: YES

  • Description: Type of bed utilized during the patient's care, which impacts cost calculations and billing.

  • Costs.Bed_Type_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the bed type, which explains the specific features or the care level associated with it.

  • Costs.Type_Of_Care

  • Type: STRING

  • Required: YES

  • Description: The category of care provided, which can influence cost based on the level and intensity of care required.

  • Costs.Type_Of_Care_Description

  • Type: STRING

  • Required: YES

  • Description: Detailed description of the type of care, offering more information on what the care entailed.

  • Costs.Units

  • Type: INT64

  • Required: YES

  • Description: The number of units of the billed service or item, important for calculating total costs.

  • Costs.Cost_Per_Unit

  • Type: NUMERIC

  • Required: YES

  • Description: The cost for each unit of service or item, crucial for financial analysis and billing.

  • Costs.Cost_Type

  • Type: STRING

  • Required: YES

  • Description: The classification of the cost, such as direct, indirect, fixed, or variable, relevant for budgeting and analysis.

  • Costs.Primary_Service_Coding_Scheme

  • Type: STRING

  • Required: YES

  • Description: The coding scheme used for the primary service, facilitating standardized billing across services.

  • Costs.Service_Code

  • Type: STRING

  • Required: YES

  • Description: The specific code for the service provided, aligning with healthcare billing standards.

  • Costs.Service_Description

  • Type: STRING

  • Required: YES

  • Description: A detailed description of the service provided, clarifying the nature and scope of the service.

  • Costs.Service_Provider_Name

  • Type: STRING

  • Required: YES

  • Description: The name of the provider or facility that delivered the service, essential for audits and records.

  • Costs.Service_Unit_Of_Measure

  • Type: STRING

  • Required: YES

  • Description: The unit of measure for the service provided, critical for quantifying and standardizing services in healthcare.

  • Costs.Created_User_ID

  • Type: STRING

  • Required: YES

  • Description: The ID of the user who created the cost record, ensuring accountability and traceability.

  • Costs.Last_Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: The ID of the user who last modified the cost record, important for tracking changes and updates.

  • Costs.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the cost record was first created, important for historical data tracking.

  • Costs.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the cost record was last modified, used for monitoring updates and changes over time.

Cost Saving Dataset Specification

Notes Table

Fields

  • Notes.Key

  • Type: INT64

  • Description: A unique identifier for each note entry within the dataset, ensuring each note can be distinctly traced.

  • Notes.Text

  • Type: STRING

  • Description: The content of the note, providing detailed information or commentary relevant to healthcare cost saving.

  • Notes.Author_User_ID

  • Type: STRING

  • Description: The unique identifier of the user who authored the note, linking the note to its creator.

  • Notes.Author_Full_Name

  • Type: STRING

  • Description: The full name of the note's author, providing clarity on who provided the information.

  • Notes.Author_User_Title

  • Type: STRING

  • Description: The professional title of the author, indicating their role or position within the healthcare system.

  • Notes.Author_Phone_Number

  • Type: STRING

  • Description: Contact phone number for the note's author, facilitating follow-up or clarification if needed.

  • Notes.Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the note was initially created, documenting the exact time of the communication.

  • Notes.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the note was last modified, tracking any changes or updates to the note's content.

Cost Saving Raw Table

Fields

  • Record_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was last modified.

  • Transaction_User_ID

  • Type: STRING

  • Description: User ID associated with the transaction related to the cost saving activity.

  • Deleted_Indicator

  • Type: BOOL

  • Description: Indicator to denote if the cost saving record is deleted.

  • Type

  • Type: STRING

  • Description: Type of the cost saving activity.

  • Tenant

  • Type: STRING

  • Description: Tenant information related to the cost saving activity.

  • Active_Version

  • Type: BOOL

  • Description: Active version of the cost saving record.

  • Date

  • Type: DATE

  • Description: Date associated with the cost saving activity.

  • Sequence

  • Type: INT64

  • Description: Sequence number for the cost saving activity.

  • Source_System_Name

  • Type: STRING

  • Description: Name of the source system for the cost saving data.

  • Source_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the data was sourced.

  • Source_File_Name

  • Type: STRING

  • Description: Name of the source file for the cost saving data.

  • Schema_Version

  • Type: FLOAT64

  • Description: Version of the schema used for the cost saving data.

  • Member_Partition

  • Type: INT64

  • Description: Partition information related to the member.

  • Other_Coordinated_Care_Discharge_Disposition_Description

  • Type: STRING

  • Description: Additional description for the coordinated care discharge disposition related to the cost saving activity.

  • Transaction_Actor_Type

  • Type: STRING

  • Description: Type of the actor performing the transaction.

Cost Saving Log

Overview

The Cost Saving Log table meticulously records every detail related to cost-saving activities, including the implementation steps and outcomes of each initiative. It provides a systematic timeline that tracks the progress and effectiveness of cost-saving measures over time.

Cost Saving Raw Data

Overview

The Cost Saving Raw Data table contains unprocessed, detailed data concerning cost-saving efforts. It serves as a foundational resource for in-depth analysis, offering insights into the financial impacts of these activities and aiding in the evaluation of their success.

Data Integration

Overview

We establish links between the Cost_Saving, Program, and Member tables to ensure comprehensive data accessibility. This integration is crucial for:

  • Associating each cost-saving instance with the corresponding program using Program.Program_Enrollment_Key.

  • Linking cost-saving records to specific members via Member.Member_ID.

Data Validity

Criteria

To ensure the accuracy and relevance of the data used in our reports, we apply the following criteria:

  • Include records only where the Cost.Savings_Documentation_End_Date is specified.

  • Exclude any records flagged as void or deleted, using indicators such as Costs.Void_Indicator, Cost_Saving_Void_Indicator, and Cost_Saving.Deleted_Indicator.

Summary Analysis

Overview

For strategic overviews and detailed reporting, data is categorized and analyzed based on key program characteristics, which include:

  • Program enrollment details

  • Examples: Enrollment_Program and Enrollment_Program_Description.

  • Product specifics

  • Examples: Enrollment_Product and Enrollment_Product_Description.

  • Group and plan identifiers

  • Examples: Group_ID, Group_Name, Plan_ID, and Plan_Description.

  • Business line categories

  • Examples: Line_Of_Business and Line_Of_Business_Description.

Data Linking

Overview

We connect the Cost_Saving table with both:

  • Program Table

  • Associating each cost-saving instance with the corresponding program using Program.Program_Enrollment_Key.

  • Member Table

  • Linking cost-saving records to specific members via Member.Member_ID.

Cost Saving Dataset Specification

Data Integration

Integration of Program and Member Tables

To create a comprehensive dataset, the integration of the Program and Member tables is facilitated by:

  • Matching Program.Program_Enrollment_Key with corresponding entries in the Cost_Saving table.

  • Associating Member.Member_ID with relevant cost-saving records.

Integration of Request and Member Tables

We connect the Cost_Saving table with the Request and Member tables to ensure a comprehensive dataset. This is done by:

  • Associating Request.Request_ID and Request.Request_Key with corresponding entries in the Cost_Saving table.

  • Linking Member.Member_ID with relevant cost-saving records.

Criteria for Data Inclusion

To maintain data integrity and relevance, specific conditions are applied:

  • Only records with a non-null Cost.Savings_Documentation_End_Date are included.

  • Records flagged as void or deleted are excluded, ensuring data quality through indicators such as:

  • Costs.Void_Indicator

  • Cost_Saving_Void_Indicator

  • Cost_Saving.Deleted_Indicator

Analytical Grouping for Reporting

Program-Level Grouping

In summary views, data is organized and analyzed by crucial program attributes for clearer understanding and better decision-making:

  • Program identifiers such as Enrollment_Program and its description.

  • Details about the product involved, listed under Enrollment_Product and its description.

  • Group and plan information, including:

  • Group_ID

  • Group_Name

  • Plan_ID

  • Plan_Description

  • Line of Business and related details, ensuring strategic alignment across reporting.

Request-Level Grouping

For efficient high-level analysis, data is systematically grouped by essential request attributes:

  • Request characteristics such as Request_Type.

  • Group and plan details, including:

  • Group_ID

  • Group_Name

  • Plan_ID

  • Plan_Description

  • Line of Business information and corresponding descriptions.

Data Validation Criteria

To ensure only the most relevant and accurate data is used:

  • Records are included only if Cost.Savings_Documentation_End_Date is filled.

  • Entries flagged as void or deleted are excluded, as indicated by:

  • Costs.Void_Indicator

  • Cost_Saving_Void_Indicator

  • Cost_Saving.Deleted_Indicator

Data Integration Strategy

We ensure a thorough compilation of data by linking the Cost_Saving table with the Request and Member tables:

  • The connection is established through matching Request.Request_ID and Request.Request_Key with their corresponding entries in the Cost_Saving table.

  • Each cost-saving record is associated with member information using Member.Member_ID.

Cost Saving Dataset Specification

Analytical Grouping for Summaries

For high-level analyses, especially useful in strategic discussions and reporting, data is organized by essential request features:

  • Attributes of the request: Includes Request_Type.

  • Details on groups and plans: Includes Group_ID, Group_Name, Plan_ID, and Plan_Description.

  • Categories and descriptions within the Line of Business.

Data Integration

  • The connection is established through matching Request.Request_ID and Request.Request_Key with their corresponding entries in the Cost_Saving table.

  • Each cost-saving record is associated with member information using Member.Member_ID.

Data Validity

To ensure the accuracy and relevance of the data used in reports:

  • Only entries with a specified Cost.Savings_Documentation_End_Date are considered.

  • Records flagged as void or deleted are excluded, guided by Costs.Void_Indicator, Cost_Saving_Void_Indicator, and Cost_Saving.Deleted_Indicator.

Table Content

Cost_Saving_log Table

Table Name

Column Name

Is Nullable

Data Type

Description

Cost_Saving_log

Member_ID

YES

STRING

Identifier for the member associated with the cost-saving activity. It is used to capture Client Code and Description, providing a unique reference to the member in the dataset.

Cost_Saving_log

Program_Enrollment_Key

YES

INT64

Key representing the enrollment of a member in a program. Used to retrieve program-related data and calculate fields like Line Of Business, Plan, and Group Information in the Summary view.

Cost_Saving_log

Program_ID

YES

STRING

Specific program identifier used to link cost-saving records to detailed program data, enhancing strategic planning and reporting.

Cost_Saving_log

Request_ID

YES

STRING

Identifier for the request associated with the cost-saving activity. Used to retrieve request-related data and calculate fields like Client Code, Line Of Business, Plan, and Group Information in the Summary view.

Data Integration

Linking Tables

To create a comprehensive dataset, links are established between the Cost_Saving, Program, and Member tables:

  • Program Integration:

  • Associate Program.Program_Enrollment_Key with corresponding entries in the Cost_Saving table.

  • Member Integration:

  • Link Member.Member_ID with relevant cost-saving records.

  • Request Integration:

  • Connect Request.Request_ID and Request.Request_Key with corresponding entries in the Cost_Saving table.

Criteria for Data Inclusion

To maintain data integrity and relevance:

  • Only records with a non-null Cost.Savings_Documentation_End_Date are included.

  • Records flagged as void or deleted are excluded using indicators such as Costs.Void_Indicator, Cost_Saving_Void_Indicator, and Cost_Saving.Deleted_Indicator.

Summary Analysis

For strategic overviews and detailed reporting, data is categorized and analyzed based on key program characteristics:

  • Program Enrollment Details:

  • Includes Enrollment_Program and Enrollment_Program_Description.

  • Product Specifics:

  • Includes Enrollment_Product and Enrollment_Product_Description.

  • Group and Plan Identifiers:

  • Includes Group_ID, Group_Name, Plan_ID, and Plan_Description.

  • Business Line Categories:

  • Captured in Line_Of_Business and Line_Of_Business_Description.

Cost Saving Dataset Specification

View Grouping

For efficient high-level analysis, data is systematically grouped by essential request attributes:

  • Request characteristics such as Request_Type.Group.

  • Plan details, including Group_ID, Group_Name, Plan_ID, and Plan_Description.

  • Line of Business information and corresponding descriptions.

Data Integration Strategy

We ensure a thorough compilation of data by linking the Cost_Saving table with the Request and Member tables:

  • The connection is established through matching Request.Request_ID and Request.Request_Key with their corresponding entries in the Cost_Saving table.

  • Each cost-saving record is associated with member information using Member.Member_ID.

Criteria for Data Inclusion

To ensure the integrity and relevance of data:

  • Only entries with a specified Cost.Savings_Documentation_End_Date are considered.

  • Records flagged as void or deleted are excluded, guided by:

  • Costs.Void_Indicator

  • Cost_Saving_Void_Indicator

  • Cost_Saving.Deleted_Indicator

Analytical Grouping for Summaries

For high-level analyses, especially useful in strategic discussions and reporting, data is organized by essential request features:

  • Attributes of the request, such as Request_Type.

  • Details on groups and plans, including Group_ID, Group_Name, Plan_ID, and Plan_Description.

  • Categories and descriptions within the Line of Business.

Cost Saving Log Fields

Request Key

  • Field Name: Request_Key

  • Required: YES

  • Type: INT64

  • Description: Key representing the request associated with the cost-saving activity. Use to retrieve request-related data and calculate fields like Client Code, Line of Business, Plan, and Group Information in the Summary view. This key serves as a pivotal link to aggregate cost-saving records with detailed request data, enriching financial analysis and decision-making.

Cost Saving Key

  • Field Name: Cost_Saving_Key

  • Required: YES

  • Type: STRING

  • Description: Key to uniquely identify the cost-saving record.

Cost Saving ID

  • Field Name: Cost_Saving_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the cost-saving activity.

Cost Saving Type

  • Field Name: Cost_Saving_Type

  • Required: YES

  • Type: STRING

  • Description: Type of cost-saving activity.

Cost Saving Type Description

  • Field Name: Cost_Saving_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the type of cost-saving activity.

Cost Saving Code

  • Field Name: Cost_Saving_Code

  • Required: YES

  • Type: STRING

  • Description: Code representing the cost-saving activity.

Cost Saving Description

  • Field Name: Cost_Saving_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the cost-saving activity.

Other Cost Saving Description

  • Field Name: Other_Cost_Saving_Description

  • Required: YES

  • Type: STRING

  • Description: Additional description or details related to the cost-saving activity.

Savings Documentation Start Date

  • Field Name: Savings_Documentation_Start_Date

  • Required: YES

  • Type: DATE

  • Description: Start date of the documentation for savings.

Savings Documentation End Date

  • Field Name: Savings_Documentation_End_Date

  • Required: YES

  • Type: DATE

  • Description: End date of the documentation for savings. If the record is not void and includes a Savings_Documentation_End_Date, the system formats this date to display only the year and month in YYYYMM format.

Void Indicator

  • Field Name: Void_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicator to denote if the cost-saving record is voided.

Void Reason

  • Field Name: Void_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for voiding the cost-saving record.

Void Reason Description

  • Field Name: Void_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the reason for voiding the cost-saving record.

Permission Required

  • Field Name: Permission_Required

  • Required: YES

  • Type: BOOL

  • Description: Indicator to specify if permission is required for the cost-saving activity.

Savings For Service Amount

  • Field Name: Savings_For_Service_Amount

  • Required: YES

  • Type: NUMERIC

  • Description: Amount of savings for the service.

Care Management Type

  • Field Name: Care_Management_Type

  • Required: YES

  • Type: STRING

  • Description: Type of care management associated with the cost-saving activity.

Care Management Type Description

  • Field Name: Care_Management_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the type of care management associated with the cost-saving activity.

Coordinated Care Discharge Disposition

  • Field Name: Coordinated_Care_Discharge_Disposition

  • Required: YES

  • Type: STRING

  • Description: Discharge disposition for coordinated care.

Coordinated Care Discharge Disposition Description

  • Field Name: Coordinated_Care_Discharge_Disposition_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the discharge disposition for coordinated care.

Created User ID

  • Field Name: Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who created the cost-saving record.

Last Modified User ID

  • Field Name: Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the cost-saving record.

Permission From Name

  • Field Name: Permission_From_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the entity granting permission for the cost-saving activity.

Permission From Role

  • Field Name: Permission_From_Role

  • Required: YES

  • Type: STRING

  • Description: Role of the entity granting permission for the cost-saving activity.

Medical Director Name

  • Field Name: Medical_Director_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the medical director associated with the cost-saving activity.

Created Timestamp

  • Field Name: Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the cost-saving record was created.

Last Modified Timestamp

  • Field Name: Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the cost-saving record was last modified.

Costs

  • Field Name: Costs

  • Required: NO

  • Type: ARRAY

  • Description: Cost details associated with the cost-saving activity.

Costs Key

  • Field Name: Costs.Key

  • Required: YES

  • Type: STRING

  • Description: A unique identifier for each cost record within the log.

Costs Cost ID

  • Field Name: Costs.Cost_ID

  • Required: YES

  • Type: STRING

  • Description: An identifier associated with the specific cost entry.

Costs Original Indicator

  • Field Name: Costs.Original_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the cost record is the original entry or a modified version.

Costs Void Indicator

  • Field Name: Costs.Void_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicates if the cost record has been voided or cancelled.

Costs Void Reason

  • Field Name: Costs.Void_Reason

  • Required: YES

  • Type: STRING

  • Description: Code identifying the reason a cost record was voided.

Costs Void Reason Description

  • Field Name: Costs.Void_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Detailed description of why the cost record was voided.

Costs Diagnosis Code

  • Field Name: Costs.Diagnosis_Code

  • Required: YES

  • Type: STRING

  • Description: Code for the diagnosis related to the cost entry, based on a standard coding scheme.

Costs Diagnosis Description

  • Field Name: Costs.Diagnosis_Description

  • Required: YES

  • Type: STRING

  • Description: Detailed description of the diagnosis linked to the cost.

Cost Saving Dataset Specification

Costs Table

Costs.Diagnosis_Group

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Group or category of the diagnosis based on a classification system.

Costs.Diagnosis_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the diagnosis group, providing context about the categorization.

Costs.Diagnosis_Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The coding scheme used for the diagnosis, such as ICD-10.

Costs.Bed_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of bed utilized during the patient's care, categorized for billing purposes.

Costs.Bed_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the bed type, explaining its specifications or purposes.

Costs.Type_Of_Care

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category of care provided, which could affect the billing and costs.

Costs.Type_Of_Care_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the type of care provided.

Costs.Units

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of units of the billed service or item.

Costs.Cost_Per_Unit

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Cost per unit of service or item provided, typically used in calculation of total costs.

Costs.Cost_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification of the cost, such as direct, indirect, fixed, variable, etc.

Costs.Primary_Service_Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Coding scheme used for the primary service provided, helping in standardized billing.

Costs.Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code identifying the specific service provided, according to the relevant coding scheme.

Costs.Service_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the service provided, detailing what the service involved.

Costs.Service_Provider_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the provider or facility that delivered the service.

Costs.Service_Unit_Of_Measure

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unit of measure used for the service provided, essential for accurate documentation and billing.

Costs.Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who initially created the cost record.

Costs.Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who last modified the cost record.

Costs.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the cost record was first created.

Costs.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the cost record was last updated.

Cost Saving Log

Notes

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Additional notes or comments related to the cost saving activity.

Notes.Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for each note entry within the log, ensuring traceability.

Notes.Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content of the note, providing detailed information or commentary related to healthcare costs.

Notes.Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who authored the note.

Notes.Author_Full_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The full name of the note's author, providing clarity on who provided the information.

Notes.Author_User_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The professional title of the author, indicating their role or position within the healthcare system.

Notes.Author_Phone_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Contact phone number for the note's author, facilitating follow-up or clarification if needed.

Notes.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was initially created, documenting the time of the communication.

Notes.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was last modified, tracking changes or updates to the information.

Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was last modified.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID associated with the transaction related to the cost saving activity.

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator to denote if the cost saving record is deleted.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the cost saving activity.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant information related to the cost saving activity.

Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Active version of the cost saving record.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the cost saving activity.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number for the cost saving activity.

Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system for the cost saving data.

Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the data was sourced.

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file for the cost saving data.

Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the cost saving data.

Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition information related to the member.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed related to the cost saving activity.

Other_Coordinated_Care_Discharge_Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description for the coordinated care discharge disposition related to the cost saving activity.

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Cost Saving Raw Table

Cost_Saving_raw.Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member associated with the cost saving activity. It is used to capture Client Code and Description, providing a unique reference to the member in the dataset.

Cost_Saving_raw.Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key representing the enrollment of a member in a program. Used to retrieve Program related data and calculate fields like Line Of Business, Plan, and Group Information in the Summary view. The join logic involves joining the Cost_Saving table with the Program and Member tables based on the provided conditions.

Cost_Saving_raw.Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program associated with the cost saving activity. Used to retrieve Program related data and calculate fields like Line Of Business, Plan.

Cost Saving Dataset Specification

Summary View

The join logic involves joining the Cost_Saving table with the Program and Member tables based on the provided conditions.

Cost_Saving_raw Table

Fields

  • Request_ID

  • Type: STRING

  • Required: YES

  • Description: Identifier for the request associated with the cost-saving activity. Used to retrieve request-related data and calculate fields like Client Code, Line Of Business, Plan, and Group Information in the Summary view.

  • Request_Key

  • Type: INT64

  • Required: YES

  • Description: Key representing the request associated with the cost-saving activity. Used to retrieve request-related data and calculate fields like Client Code, Line Of Business, Plan, and Group Information in the Summary view.

  • Cost_Saving_Key

  • Type: STRING

  • Required: YES

  • Description: Key to uniquely identify the cost-saving record.

  • Cost_Saving_ID

  • Type: STRING

  • Required: YES

  • Description: Identifier for the cost-saving activity.

  • Cost_Saving_Type

  • Type: STRING

  • Required: YES

  • Description: Type of cost-saving activity.

  • Cost_Saving_Type_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the type of cost-saving activity.

  • Cost_Saving_Code

  • Type: STRING

  • Required: YES

  • Description: Code representing the cost-saving activity.

  • Cost_Saving_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the cost-saving activity.

  • Other_Cost_Saving_Description

  • Type: STRING

  • Required: YES

  • Description: Additional description or details related to the cost-saving activity.

  • Savings_Documentation_Start_Date

  • Type: DATE

  • Required: YES

  • Description: Start date of the documentation for savings.

  • Savings_Documentation_End_Date

  • Type: DATE

  • Required: YES

  • Description: End date of the documentation for savings.

  • Void_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicator to denote if the cost-saving record is voided.

  • Void_Reason

  • Type: STRING

  • Required: YES

  • Description: Reason for voiding the cost-saving record.

  • Void_Reason_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the reason for voiding the cost-saving record.

  • Permission_Required

  • Type: BOOL

  • Required: YES

  • Description: Indicator to specify if permission is required for the cost-saving activity.

  • Savings_For_Service_Amount

  • Type: NUMERIC

  • Required: YES

  • Description: Amount of savings for the service.

  • Care_Management_Type

  • Type: STRING

  • Required: YES

  • Description: Type of care management associated with the cost-saving activity.

  • Care_Management_Type_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the type of care management associated with the cost-saving activity.

  • Coordinated_Care_Discharge_Disposition

  • Type: STRING

  • Required: YES

  • Description: Discharge disposition for coordinated care.

  • Coordinated_Care_Discharge_Disposition_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the discharge disposition for coordinated care.

  • Created_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who created the cost-saving record.

  • Last_Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the cost-saving record.

  • Permission_From_Name

  • Type: STRING

  • Required: YES

  • Description: Name of the entity granting permission for the cost-saving activity.

  • Permission_From_Role

  • Type: STRING

  • Required: YES

  • Description: Role of the entity granting permission for the cost-saving activity.

  • Medical_Director_Name

  • Type: STRING

  • Required: YES

  • Description: Name of the medical director associated with the cost-saving activity.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the cost-saving record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the cost-saving record was last modified.

  • Costs

  • Type: ARRAY

  • Required: NO

  • Description: Cost details associated with the cost-saving activity.

Costs Table

Fields

  • Key

  • Type: STRING

  • Required: YES

  • Description: A unique identifier for each cost record within the dataset, ensuring traceability and uniqueness.

  • Cost_ID

  • Type: STRING

  • Required: YES

  • Description: An identifier associated with the specific cost entry, used for tracking and referencing costs.

  • Original_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicates whether the cost record is the original entry or has been adjusted or modified.

  • Void_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicates if the cost record has been nullified or invalidated, typically due to an error or change in status.

  • Void_Reason

  • Type: STRING

  • Required: YES

  • Description: The reason code for voiding the cost record, providing a quick reference to why the entry was nullified.

  • Void_Reason_Description

  • Type: STRING

  • Required: YES

  • Description: A detailed description of why the cost record was voided, offering context and justification.

  • Diagnosis_Code

  • Type: STRING

  • Required: YES

  • Description: The code for the diagnosis related to the cost entry, following a standardized medical coding system.

  • Diagnosis_Description

  • Type: STRING

  • Required: YES

  • Description: A detailed description of the diagnosis linked to the cost, helping to clarify the medical context.

  • Diagnosis_Group

  • Type: STRING

  • Required: YES

  • Description: The classification group to which the diagnosis belongs, aiding in broader categorization within healthcare.

  • Diagnosis_Group_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the diagnosis group, providing insights into the classification and its healthcare implications.

  • Diagnosis_Coding_Scheme

  • Type: STRING

  • Required: YES

  • Description: The coding scheme used for the diagnosis, such as ICD-10, which standardizes the way diagnoses are recorded.

  • Bed_Type

  • Type: STRING

  • Required: YES

  • Description: Type of bed utilized during the patient's care, which impacts cost calculations and billing.

  • Bed_Type_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the bed type, which explains the specific features or the care level associated with it.

  • Type_Of_Care

  • Type: STRING

  • Required: YES

  • Description: The category of care provided, which can influence cost based on the level and intensity of care required.

  • Type_Of_Care_Description

  • Type: STRING

  • Required: YES

  • Description: Detailed description of the type of care, offering more information on what the care entailed.

  • Units

  • Type: INT64

  • Required: YES

  • Description: The number of units of care provided.

Cost Saving Dataset Specification

Costs

Costs.Billed_Service_Or_Item

  • Required: YES

  • Type: STRING

  • Description: The billed service or item, important for calculating total costs.

Costs.Cost_Per_Unit

  • Required: YES

  • Type: NUMERIC

  • Description: The cost for each unit of service or item, crucial for financial analysis and billing.

Costs.Cost_Type

  • Required: YES

  • Type: STRING

  • Description: The classification of the cost, such as direct, indirect, fixed, or variable, relevant for budgeting and analysis.

Costs.Primary_Service_Coding_Scheme

  • Required: YES

  • Type: STRING

  • Description: The coding scheme used for the primary service, facilitating standardized billing across services.

Costs.Service_Code

  • Required: YES

  • Type: STRING

  • Description: The specific code for the service provided, aligning with healthcare billing standards.

Costs.Service_Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the service provided, clarifying the nature and scope of the service.

Costs.Service_Provider_Name

  • Required: YES

  • Type: STRING

  • Description: The name of the provider or facility that delivered the service, essential for audits and records.

Costs.Service_Unit_Of_Measure

  • Required: YES

  • Type: STRING

  • Description: The unit of measure for the service provided, critical for quantifying and standardizing services in healthcare.

Costs.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The ID of the user who created the cost record, ensuring accountability and traceability.

Costs.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The ID of the user who last modified the cost record, important for tracking changes and updates.

Costs.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp when the cost record was first created, important for historical data tracking.

Costs.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp when the cost record was last modified, used for monitoring updates and changes over time.

Cost Saving Raw

Cost_Saving_raw.Notes

  • Required: NO

  • Type: ARRAY

  • Description: Additional notes or comments related to the cost saving activity.

Notes.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each note entry within the dataset, ensuring each note can be distinctly traced.

Notes.Text

  • Required: YES

  • Type: STRING

  • Description: The content of the note, providing detailed information or commentary relevant to healthcare cost saving.

Notes.Author_User_ID

  • Required: YES

  • Type: STRING

  • Description: The unique identifier of the user who authored the note, linking the note to its creator.

Notes.Author_Full_Name

  • Required: YES

  • Type: STRING

  • Description: The full name of the note's author, providing clarity on who provided the information.

Notes.Author_User_Title

  • Required: YES

  • Type: STRING

  • Description: The professional title of the author, indicating their role or position within the healthcare system.

Notes.Author_Phone_Number

  • Required: YES

  • Type: STRING

  • Description: Contact phone number for the note's author, facilitating follow-up or clarification if needed.

Notes.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the note was initially created, documenting the exact time of the communication.

Notes.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the note was last modified, tracking any changes or updates to the note's content.

Cost_Saving_raw.Record_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was last modified.

Cost_Saving_raw.Transaction_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID associated with the transaction related to the cost saving activity.

Cost_Saving_raw.Deleted_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicator to denote if the cost saving record is deleted.

Cost_Saving_raw.Type

  • Required: YES

  • Type: STRING

  • Description: Type of the cost saving activity.

Cost_Saving_raw.Tenant

  • Required: YES

  • Type: STRING

  • Description: Tenant information related to the cost saving activity.

Cost_Saving_raw.Active_Version

  • Required: YES

  • Type: BOOL

  • Description: Active version of the cost saving record.

Cost_Saving_raw.Date

  • Required: YES

  • Type: DATE

  • Description: Date associated with the cost saving activity.

Cost_Saving_raw.Sequence

  • Required: YES

  • Type: INT64

  • Description: Sequence number for the cost saving activity.

Cost_Saving_raw.Source_System_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source system for the cost saving data.

Cost_Saving_raw.Source_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the data was sourced.

Cost_Saving_raw.Source_File_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source file for the cost saving data.

Cost_Saving_raw.Schema_Version

  • Required: YES

  • Type: FLOAT64

  • Description: Version of the schema used for the cost saving data.

Cost_Saving_raw.Member_Partition

  • Required: YES

  • Type: INT64

  • Description: Partition information related to the member.

Cost_Saving_raw.Other_Coordinated_Care_Discharge_Disposition_Description

  • Required: YES

  • Type: STRING

  • Description: Additional description for the coordinated care discharge disposition related to the cost saving activity.

Cost_Saving_raw.Transaction_Actor_Type

  • Required: YES

  • Type: STRING

  • Description: Type of the actor performing the transaction.

Related Articles
Request Dataset Specification
Dictionary Dataset Specification
Program Dataset Specification
Cost Dataset Specification
Dictionary Dataset Specification A C
Did this answer your question?