Skip to main content

Cost Dataset Specification

Updated over a month ago

Cost Dataset Specification

Cost Dataset Specification

The "Cost Dataset Specification" is designed to enhance financial management within healthcare settings by meticulously tracking and analyzing costs and savings. This structured approach helps in budgeting, strategic planning, and optimizing financial resources.

Key Features

  • Cost Records:\ Includes detailed records of all expenses related to healthcare services, encompassing direct costs, overheads, and other essential financial metrics. This comprehensive documentation is crucial for accurate financial oversight and analysis.

  • Cost Saving Logs:\ Details the efforts and strategies employed to reduce expenses, documenting the savings achieved over time. These logs also assess the effectiveness of cost-saving initiatives, providing insights into financial management practices.

  • Cost Saving Raw Data:\ Offers unprocessed financial data, providing a granular view of expenses and savings before any aggregation or analysis. This raw data is vital for conducting detailed financial studies and preparing for more complex fiscal assessments.

This dataset plays a crucial role in the financial analysis and strategic planning processes of healthcare organizations, enabling them to manage budgets effectively and make informed decisions.

Table Name: Cost

Column Specifications

  • Cost_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each cost record.

  • Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key linking to the program enrollment associated with the cost.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member associated with the cost.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program associated with the cost.

  • Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the request associated with the cost.

  • Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key linking to the specific request associated with the cost.

  • Cost_Saving_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for identifying specific cost-saving measures.

  • Cost_Saving_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code identifying the type of cost-saving measure.

  • Cost_Saving_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the cost-saving measure.

  • Savings_Documentation_Start_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Start date for when the savings documentation is valid.

  • Savings_Documentation_End_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: End date for when the savings documentation is valid.

  • Cost_Saving_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of cost-saving measure.

  • Cost_Saving_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the cost-saving type.

  • Other_Cost_Saving_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description for other types of cost savings not categorized.

  • Care_Management_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of care management associated with the cost. See Dictionary Care Management Type table in the Dictionary Dataset Specification.

  • Care_Management_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the care management type. See Dictionary Care Management Type table in the Dictionary Dataset Specification.

  • Coordinated_Care_Discharge_Disposition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Discharge disposition in coordinated care settings.

  • Coordinated_Care_Discharge_Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the discharge disposition in coordinated care settings.

  • Other_Coordinated_Care_Discharge_Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional descriptions for other types of coordinated care discharge dispositions.

  • Cost_Saving_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the cost-saving measure.

  • Permission_Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if permission is required for the cost-saving measure.

  • Permission_From_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person from whom permission is required.

  • Permission_From_Role

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Role of the person from whom permission is required.

  • Medical_Director_Name

  • Is Nullable: YES

  • Data Type: STRING

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

  • Cost_Saving_Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator of whether the cost-saving measure is void.

  • Cost_Saving_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

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

  • Cost_Saving_Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Cost_Saving_Amount

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Amount saved through the cost-saving measure.

  • Cost_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the cost entry.

  • Original_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the cost entry is the original.

  • Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the cost entry is void.

  • Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding the cost entry.

  • Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the reason for voiding the cost entry.

  • Diagnosis_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Diagnosis code associated with the cost.

  • Diagnosis_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the diagnosis associated with the cost.

  • Diagnosis_Group

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Group classification of the diagnosis.

  • Diagnosis_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the diagnosis group classification.

  • Diagnosis_Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Coding scheme used for the diagnosis.

  • Bed_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of bed associated with the cost. See Dictionary Bed Type table in the Dictionary Dataset Specification.

  • Bed_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the bed type. See Dictionary Bed Type table in the Dictionary Dataset Specification.

  • Type_Of_Care

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of care associated with the cost.

  • Type_Of_Care_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the type of care.

  • Units

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of units associated with the cost.

  • Cost_Per_Unit

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Cost per unit.

  • Cost_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of cost incurred. See Dictionary Cost Type table in the Dictionary Dataset Specification.

  • Primary_Service_Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Coding scheme for the primary service associated with the cost.

  • Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the service associated with the cost.

  • Service_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the service.

  • Service_Provider_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the service provider.

  • Service_Unit_Of_Measure

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unit of measure for the service provided.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the cost record.

Cost Dataset Specification

Cost Record Fields

General Information

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person who created the cost record.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the cost record was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Cost Details

  • Total_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Total cost calculated.

  • Expected_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Expected cost projection.

  • Actual_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Actual cost incurred.

  • Cost_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category of the cost.

  • Cost_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the cost category.

  • Cost_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the cost type. See Dictionary Cost Type table in the Dictionary Dataset Specification.

  • Cost_Saving_Calendar_Month

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Calendar month associated with the cost-saving measure.

  • Documentation_Closed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the documentation for the cost-saving measure is closed.

Cost Saving Log Fields

General Information

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member associated with the cost saving.

  • Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key linking to the program enrollment associated with the cost saving.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program associated with the cost saving.

  • Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the request associated with the cost saving.

  • Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key linking to the specific request associated with the cost saving.

Cost Saving Details

  • Cost_Saving_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for identifying specific cost-saving measures.

  • Cost_Saving_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the cost-saving measure.

  • Cost_Saving_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of cost-saving measure.

  • Cost_Saving_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the cost-saving type.

  • Cost_Saving_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code identifying the type of cost-saving measure.

  • Cost_Saving_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the cost-saving measure.

  • Other_Cost_Saving_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description for other types of cost savings not categorized.

  • Savings_Documentation_Start_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Start date for when the savings documentation is valid.

  • Savings_Documentation_End_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: End date for when the savings documentation is valid.

Void Information

  • Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator of whether the cost-saving measure is void.

  • Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

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

  • Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Permissions

  • Permission_Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if permission is required for the cost-saving measure.

  • Permission_From_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person from whom permission is required.

  • Permission_From_Role

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Role of the person from whom permission is required.

Savings Details

  • Savings_For_Service_Amount

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Amount saved through the cost-saving measure.

Care Management

  • Care_Management_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Care_Management_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the care management type.

Coordinated Care

  • Coordinated_Care_Discharge_Disposition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Discharge disposition in coordinated care settings.

  • Coordinated_Care_Discharge_Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the discharge disposition in coordinated care settings.

User Information

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Medical_Director_Name

  • Is Nullable: YES

  • Data Type: STRING

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

Timestamps

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Costs Array

General Information

  • Costs

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of associated cost details, each containing fields such as cost type, amount, and related provider information.

Cost Fields

  • Key

  • Is Nullable: YES

  • Data Type: INT64

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

  • Cost_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Original_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

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

  • Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

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

  • Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

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

  • Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Diagnosis Information

  • Diagnosis_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Diagnosis_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Diagnosis_Group

  • Is Nullable: YES

  • Data Type: STRING

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

  • Diagnosis_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Diagnosis_Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

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

Bed Information

  • Bed_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Bed_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Care Information

  • 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

  • Is Nullable: YES

  • Data Type: STRING

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

  • Units

  • Is Nullable: YES

  • Data Type: INT64

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

Cost Dataset Specification

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.

Cost_Type

  • Is Nullable: YES

  • Data Type: STRING

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

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

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Provider_Name

  • Is Nullable: YES

  • Data Type: STRING

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

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

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Cost_Saving_Log

Notes

Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for each note entry in the system.

Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content or body of the note, providing relevant information or observations.

Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Author_Full_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The full name of the user who authored the note.

Author_User_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The professional title or role of the user who authored the note.

Author_Phone_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The contact phone number of the note’s author, if applicable.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp marking when the note was originally created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp marking the most recent modification or update made to the note.

Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the cost saving record.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who performed the transaction on the cost saving record.

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the cost saving log record has been deleted.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the cost saving record.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the tenant for the cost saving log.

Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if this record is the active version of the cost saving log.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the cost saving log record.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A sequential number indicating the order of the cost saving record.

Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from which the cost saving record originated.

Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp from the source system for the cost saving record.

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the file from the source system for the cost saving record.

Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

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

Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Member partition key used for partitioning the cost saving log data.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The action taken on this cost saving log record, such as 'create' or 'update'.

Other_Coordinated_Care_Discharge_Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information or description about the coordinated care discharge disposition that isn't covered by the standard description field.

Cost_Saving_Raw

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member associated with the cost saving.

Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Reference key to the program enrollment associated with the cost saving.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program linked to the cost saving.

Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the request related to the cost saving.

Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Reference key to the specific request associated with the cost saving.

Cost_Saving_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key for identifying the cost-saving entry.

Cost_Saving_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the cost-saving measure.

Cost_Saving_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of cost-saving measure being documented.

Cost_Saving_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the cost-saving type.

Cost_Saving_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code that identifies the type of cost-saving measure.

Cost_Saving_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of what the cost-saving measure entails.

Other_Cost_Saving_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description for cost savings that do not fit the standard categories.

Savings_Documentation_Start_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Start date for the period over which cost savings are documented.

Savings_Documentation_End_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: End date for the period over which cost savings are documented.

Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the cost saving record has been voided.

Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding the cost saving record.

Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Permission_Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if permission is needed to consider this cost saving.

Savings_For_Service_Amount

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Numeric value indicating the amount of money saved for a particular service.

Care_Management_Type

  • Is Nullable: YES

  • Data Type: STRING

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

Cost Dataset Specification

Cost Saving Raw Fields

Care Management Type Description

  • Field Name: Care_Management_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the care management type involved in the cost saving.

Coordinated Care Discharge Disposition

  • Field Name: Coordinated_Care_Discharge_Disposition

  • Required: YES

  • Type: STRING

  • Description: Discharge disposition associated with coordinated care.

Coordinated Care Discharge Disposition Description

  • Field Name: Coordinated_Care_Discharge_Disposition_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the discharge disposition in the context of coordinated care.

Created User ID

  • Field Name: Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the individual 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 individual who last modified the cost-saving record.

Permission From Name

  • Field Name: Permission_From_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the individual from whom permission is required to apply the cost saving.

Permission From Role

  • Field Name: Permission_From_Role

  • Required: YES

  • Type: STRING

  • Description: Role of the individual from whom permission is required.

Medical Director Name

  • Field Name: Medical_Director_Name

  • Required: YES

  • Type: STRING

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

Created Timestamp

  • Field Name: Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Last Modified Timestamp

  • Field Name: Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Record Last Modified Timestamp

  • Field Name: Record_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating the last modification to the cost-saving record.

Transaction User ID

  • Field Name: Transaction_User_ID

  • Required: YES

  • Type: STRING

  • Description: ID of the user involved in the transaction for the cost-saving record.

Deleted Indicator

  • Field Name: Deleted_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the cost-saving record has been marked as deleted.

Type

  • Field Name: Type

  • Required: YES

  • Type: STRING

  • Description: Type of the cost-saving record.

Tenant

  • Field Name: Tenant

  • Required: YES

  • Type: STRING

  • Description: Identifies the tenant in the context of a multi-tenant system.

Active Version

  • Field Name: Active_Version

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether this version of the cost-saving record is active.

Date

  • Field Name: Date

  • Required: YES

  • Type: DATE

  • Description: The date associated with the cost-saving record.

Sequence

  • Field Name: Sequence

  • Required: YES

  • Type: INT64

  • Description: Sequence number used for ordering or versioning the cost-saving records.

Source System Name

  • Field Name: Source_System_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source system from which the cost-saving data originates.

Source Timestamp

  • Field Name: Source_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the cost-saving data was sourced.

Costs Log Fields

Costs Array

  • Field Name: Costs

  • Required: NO

  • Type: ARRAY

  • Description: Array of associated cost details, each containing fields such as cost type, amount, and related provider information.

Costs.Key

  • Field Name: Key

  • Required: YES

  • Type: INT64

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

Costs.Cost_ID

  • Field Name: Cost_ID

  • Required: YES

  • Type: STRING

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

Costs.Original Indicator

  • Field Name: 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: Void_Indicator

  • Required: YES

  • Type: BOOL

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

Costs.Void Reason

  • Field Name: Void_Reason

  • Required: YES

  • Type: STRING

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

Costs.Void Reason Description

  • Field Name: Void_Reason_Description

  • Required: YES

  • Type: STRING

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

Costs.Diagnosis Code

  • Field Name: 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: Diagnosis_Description

  • Required: YES

  • Type: STRING

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

Costs.Diagnosis Group

  • Field Name: Diagnosis_Group

  • Required: YES

  • Type: STRING

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

Costs.Diagnosis Group Description

  • Field Name: Diagnosis_Group_Description

  • Required: YES

  • Type: STRING

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

Costs.Diagnosis Coding Scheme

  • Field Name: Diagnosis_Coding_Scheme

  • Required: YES

  • Type: STRING

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

Costs.Bed Type

  • Field Name: Bed_Type

  • Required: YES

  • Type: STRING

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

Costs.Bed Type Description

  • Field Name: Bed_Type_Description

  • Required: YES

  • Type: STRING

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

Costs.Type Of Care

  • Field Name: Type_Of_Care

  • Required: YES

  • Type: STRING

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

Costs.Type Of Care Description

  • Field Name: Type_Of_Care_Description

  • Required: YES

  • Type: STRING

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

Costs.Units

  • Field Name: Units

  • Required: YES

  • Type: INT64

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

Costs.Cost Per Unit

  • Field Name: Cost_Per_Unit

  • Required: YES

  • Type: NUMERIC

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

Costs.Cost Type

  • Field Name: Cost_Type

  • Required: YES

  • Type: STRING

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

Costs.Primary Service Coding Scheme

  • Field Name: Primary_Service_Coding_Scheme

  • Required: YES

  • Type: STRING

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

Costs.Service Code

  • Field Name: Service_Code

  • Required: YES

  • Type: STRING

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

Costs.Service Description

  • Field Name: Service_Description

  • Required: YES

  • Type: STRING

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

Costs.Service Provider Name

  • Field Name: Service_Provider_Name

  • Required: YES

  • Type: STRING

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

Costs.Service Unit Of Measure

  • Field Name: Service_Unit_Of_Measure

  • Required: YES

  • Type: STRING

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

Costs.Created User ID

  • Field Name: Created_User_ID

  • Required: YES

  • Type: STRING

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

Costs.Last Modified User ID

  • Field Name: Last_Modified_User_ID

  • Required: YES

  • Type: STRING

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

Costs.Created Timestamp

  • Field Name: Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Costs.Last Modified Timestamp

  • Field Name: Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Notes Log Fields

Notes Array

  • Field Name: Notes

  • Required: NO

  • Type: ARRAY

  • Description: Array of notes related to the cost saving, detailing observations or additional information from users or administrators.

Notes.Key

  • Field Name: Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each note entry in the system.

Notes.Text

  • Field Name: Text

  • Required: YES

  • Type: STRING

  • Description: The content or body of the note, providing relevant information or observations.

Notes.Author User ID

  • Field Name: Author_User_ID

  • Required: YES

  • Type: STRING

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

Notes.Author Full Name

  • Field Name: Author_Full_Name

  • Required: YES

  • Type: STRING

  • Description: The full name of the user who authored the note.

Notes.Author User Title

  • Field Name: Author_User_Title

  • Required: YES

  • Type: STRING

  • Description: The professional title or role of the user who authored the note.

Notes.Author Phone Number

  • Field Name: Author_Phone_Number

  • Required: YES

  • Type: STRING

  • Description: The contact phone number of the note’s author, if applicable.

Notes.Created Timestamp

  • Field Name: Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp marking when the note was originally created.

Notes.Last Modified Timestamp

  • Field Name: Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp marking the most recent modification or update made to the note.

Cost Dataset Specification

Overview

Cost Records

  • Detailed records of all expenses related to healthcare services.

  • Includes direct costs, overheads, and other essential financial metrics.

  • Crucial for accurate financial oversight and analysis.

Cost Saving Logs

  • Documentation of efforts and strategies employed to reduce expenses.

  • Includes savings achieved over time.

  • Assesses the effectiveness of cost-saving initiatives.

  • Provides insights into financial management practices.

Cost Saving Raw Data

  • Unprocessed financial data offering a granular view of expenses and savings.

  • Vital for conducting detailed financial studies.

  • Prepares for more complex fiscal assessments.

Cost Saving Raw Data Fields

Column Name

Is Nullable

Data Type

Description

Source_File_Name

YES

STRING

Name of the file from the source system containing the cost-saving data.

Schema_Version

YES

FLOAT64

Version of the schema used for the cost-saving data.

Member_Partition

YES

INT64

Partition key based on the member ID, used for data segmentation and optimization.

Other_Coordinated_Care_Discharge_Disposition_Description

YES

STRING

Additional description for the coordinated care discharge disposition that is not covered by standard categories.

Cost Table Fields

Table Name

Column Name

Is Nullable

Data Type

Description

Cost

Cost_Key

YES

INT64

Unique identifier for each cost record.

Cost

Program_Enrollment_Key

YES

INT64

Key linking to the program enrollment associated with the cost.

Cost

Member_ID

YES

STRING

Identifier for the member associated with the cost.

Cost

Program_ID

YES

STRING

Identifier for the program associated with the cost.

Cost

Request_ID

YES

STRING

Identifier for the request associated with the cost.

Cost

Request_Key

YES

INT64

Key linking to the specific request associated with the cost.

Cost

Cost_Saving_Key

YES

INT64

Key for identifying specific cost-saving measures.

Cost

Cost_Saving_Code

YES

STRING

Code identifying the type of cost-saving measure.

Cost

Cost_Saving_Description

YES

STRING

Description of the cost-saving measure.

Cost

Savings_Documentation_Start_Date

YES

DATE

Start date for when the savings documentation is valid.

Cost

Savings_Documentation_End_Date

YES

DATE

End date for when the savings documentation is valid.

Cost

Cost_Saving_Type

YES

STRING

Type of cost-saving measure.

Cost

Cost_Saving_Type_Description

YES

STRING

Description of the cost-saving type.

Cost

Other_Cost_Saving_Description

YES

STRING

Additional description for other types of cost savings not categorized.

Cost

Care_Management_Type

YES

STRING

Type of care management associated with the cost. See Dictionary Care Management Type table in the Dictionary Dataset Specification.

Cost

Care_Management_Type_Description

YES

STRING

Description of the care management type. See Dictionary Care Management Type table in the Dictionary Dataset Specification.

Cost

Coordinated_Care_Discharge_Disposition

YES

STRING

Discharge disposition in coordinated care settings.

Cost

Coordinated_Care_Discharge_Disposition_Description

YES

STRING

Description of the discharge disposition in coordinated care settings.

Cost

Other_Coordinated_Care_Discharge_Disposition_Description

YES

STRING

Additional descriptions for other types of coordinated care discharge dispositions.

Cost

Cost_Saving_ID

YES

STRING

Unique identifier for the cost-saving measure.

Cost

Permission_Required

YES

BOOL

Indicates if permission is required for the cost-saving measure.

Cost

Permission_From_Name

YES

STRING

Name of the person from whom permission is required.

Cost

Permission_From_Role

YES

STRING

Role of the person from whom permission is required.

Cost

Medical_Director_Name

YES

STRING

Name of the medical director associated with the cost.

Cost

Cost_Saving_Void_Indicator

YES

BOOL

Indicator of whether the cost-saving measure is void.

Cost

Cost_Saving_Void_Reason

YES

STRING

Reason for voiding the cost-saving measure.

Cost

Cost_Saving_Void_Reason_Description

YES

STRING

Description of the reason for voiding the cost-saving measure.

Cost

Cost_Saving_Amount

YES

NUMERIC

Amount saved through the cost-saving measure.

Cost

Cost_ID

YES

STRING

Unique identifier for the cost entry.

Cost

Original_Indicator

YES

BOOL

Indicates if the cost entry is the original.

Cost

Void_Indicator

YES

BOOL

Indicates if the cost entry is void.

Cost

Void_Reason

YES

STRING

Reason for voiding the cost entry.

Cost

Void_Reason_Description

YES

STRING

Description of the reason for voiding the cost entry.

Cost

Diagnosis_Code

YES

STRING

Diagnosis code associated with the cost.

Cost

Diagnosis_Description

YES

STRING

Description of the diagnosis associated with the cost.

Cost

Diagnosis_Group

YES

STRING

Group classification of the diagnosis.

Cost

Diagnosis_Group_Description

YES

STRING

Description of the diagnosis group classification.

Cost

Diagnosis_Coding_Scheme

YES

STRING

Coding scheme used for the diagnosis.

Cost

Bed_Type

YES

STRING

Type of bed associated with the cost. See Dictionary Bed Type table in the Dictionary Dataset Specification.

Cost

Bed_Type_Description

YES

STRING

Description of the bed type. See Dictionary Bed Type table in the Dictionary Dataset Specification.

Cost

Type_Of_Care

YES

STRING

Type of care associated with the cost.

Cost

Type_Of_Care_Description

YES

STRING

Description of the type of care.

Cost

Units

YES

INT64

Number of units associated with the cost.

Cost Dataset Specification

Cost Table

Columns

  • Cost_Per_Unit

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Cost per unit.

  • Cost_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of cost incurred. See Dictionary Cost Type table in the Dictionary Dataset Specification.

  • Primary_Service_Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Coding scheme for the primary service associated with the cost.

  • Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the service associated with the cost.

  • Service_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the service.

  • Service_Provider_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the service provider.

  • Service_Unit_Of_Measure

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unit of measure for the service provided.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person who created the cost record.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the cost record was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Total_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Total cost calculated.

  • Expected_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Expected cost projection.

  • Actual_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Actual cost incurred.

  • Cost_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category of the cost.

  • Cost_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the cost category.

  • Cost_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the cost type. See Dictionary Cost Type table in the Dictionary Dataset Specification.

  • Cost_Saving_Calendar_Month

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Calendar month associated with the cost-saving measure.

  • Documentation_Closed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the documentation for the cost-saving measure is closed.

Cost_Saving_Log Table

Columns

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member associated with the cost saving.

  • Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key linking to the program enrollment associated with the cost saving.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program associated with the cost saving.

  • Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the request associated with the cost saving.

  • Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key linking to the specific request associated with the cost saving.

  • Cost_Saving_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for identifying specific cost-saving measures.

  • Cost_Saving_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the cost-saving measure.

  • Cost_Saving_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of cost-saving measure.

  • Cost_Saving_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the cost-saving type.

  • Cost_Saving_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code identifying the type of cost-saving measure.

  • Cost_Saving_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the cost-saving measure.

  • Other_Cost_Saving_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description for other types of cost savings not categorized.

  • Savings_Documentation_Start_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Start date for when the savings documentation is valid.

  • Savings_Documentation_End_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: End date for when the savings documentation is valid.

  • Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator of whether the cost-saving measure is void.

  • Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

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

  • Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Permission_Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if permission is required for the cost-saving measure.

  • Savings_For_Service_Amount

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Amount saved through the cost-saving measure.

  • Care_Management_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Care_Management_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the care management type.

  • Coordinated_Care_Discharge_Disposition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Discharge disposition in coordinated care settings.

  • Coordinated_Care_Discharge_Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the discharge disposition in coordinated care settings.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Permission_From_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person from whom permission is required.

  • Permission_From_Role

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Role of the person from whom permission is required.

  • Medical_Director_Name

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Costs

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of associated cost details, each containing fields such as cost type, amount, and related provider information.

Costs Array

Fields

  • Key

  • Is Nullable: YES

  • Data Type: INT64

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

  • Cost_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Original_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

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

Cost Dataset Specification

Costs

Void Indicator

  • Column Name: Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

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

Void Reason

  • Column Name: Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

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

Void Reason Description

  • Column Name: Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Diagnosis Code

  • Column Name: Diagnosis_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Diagnosis Description

  • Column Name: Diagnosis_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Diagnosis Group

  • Column Name: Diagnosis_Group

  • Is Nullable: YES

  • Data Type: STRING

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

Diagnosis Group Description

  • Column Name: Diagnosis_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Diagnosis Coding Scheme

  • Column Name: Diagnosis_Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

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

Bed Type

  • Column Name: Bed_Type

  • Is Nullable: YES

  • Data Type: STRING

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

Bed Type Description

  • Column Name: Bed_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

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: Array of notes related to the cost saving, detailing observations or additional information from users or administrators.

Key

  • Column Name: Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for each note entry in the system.

Text

  • Column Name: Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content or body of the note, providing relevant information or observations.

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 user who authored the note.

Author User Title

  • Column Name: Author_User_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The professional title or role of the user who authored the note.

Author Phone Number

  • Column Name: Author_Phone_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The contact phone number of the note’s author, if applicable.

Created Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp marking when the note was originally created.

Last Modified Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp marking the most recent modification or update made to the note.

Record Last Modified Timestamp

  • Column Name: Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the cost saving record.

Transaction User ID

  • Column Name: Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who performed the transaction on the cost saving record.

Deleted Indicator

  • Column Name: Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the cost saving log record has been deleted.

Type

  • Column Name: Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the cost saving record.

Tenant

  • Column Name: Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the tenant for the cost saving log.

Active Version

  • Column Name: Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if this record is the active version of the cost saving log.

Date

  • Column Name: Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the cost saving log record.

Sequence

  • Column Name: Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A sequential number indicating the order of the cost saving record.

Source System Name

  • Column Name: Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from which the cost saving record originated.

Source Timestamp

  • Column Name: Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp from the source system for the cost saving record.

Source File Name

  • Column Name: Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the file from the source system for the cost saving record.

Schema Version

  • Column Name: Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

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

Member Partition

  • Column Name: Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Member partition key used for partitioning the cost saving log data.

Action

  • Column Name: Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The action taken on this cost saving log record, such as 'create' or 'update'.

Other Coordinated Care Discharge Disposition Description

  • Column Name: Other_Coordinated_Care_Discharge_Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information or description about the coordinated care discharge disposition that isn't covered by the standard description field.

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.

Program Enrollment Key

  • Column Name: Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Reference key to the program enrollment associated with the cost saving.

Program ID

  • Column Name: Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program associated with the cost saving.

Cost Dataset Specification

Cost_Saving_raw

Fields

  • Program_Linked_To_Cost_Saving

  • Type: STRING

  • Required: YES

  • Description: Identifier for the program linked to the cost saving.

  • Request_ID

  • Type: STRING

  • Required: YES

  • Description: Identifier for the request related to the cost saving.

  • Request_Key

  • Type: INT64

  • Required: YES

  • Description: Reference key to the specific request associated with the cost saving.

  • Cost_Saving_Key

  • Type: INT64

  • Required: YES

  • Description: Unique key for identifying the cost-saving entry.

  • Cost_Saving_ID

  • Type: STRING

  • Required: YES

  • Description: Unique identifier for the cost-saving measure.

  • Cost_Saving_Type

  • Type: STRING

  • Required: YES

  • Description: Type of cost-saving measure being documented.

  • Cost_Saving_Type_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the cost-saving type.

  • Cost_Saving_Code

  • Type: STRING

  • Required: YES

  • Description: Code that identifies the type of cost-saving measure.

  • Cost_Saving_Description

  • Type: STRING

  • Required: YES

  • Description: Detailed description of what the cost-saving measure entails.

  • Other_Cost_Saving_Description

  • Type: STRING

  • Required: YES

  • Description: Additional description for cost savings that do not fit the standard categories.

  • Savings_Documentation_Start_Date

  • Type: DATE

  • Required: YES

  • Description: Start date for the period over which cost savings are documented.

  • Savings_Documentation_End_Date

  • Type: DATE

  • Required: YES

  • Description: End date for the period over which cost savings are documented.

  • Void_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicates whether the cost saving record has been voided.

  • Void_Reason

  • Type: STRING

  • Required: YES

  • Description: Reason for voiding the cost saving record.

  • Void_Reason_Description

  • Type: STRING

  • Required: YES

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

  • Permission_Required

  • Type: BOOL

  • Required: YES

  • Description: Indicates if permission is needed to consider this cost saving.

  • Savings_For_Service_Amount

  • Type: NUMERIC

  • Required: YES

  • Description: Numeric value indicating the amount of money saved for a particular service.

  • Care_Management_Type

  • Type: STRING

  • Required: YES

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

  • Care_Management_Type_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the care management type involved in the cost saving.

  • Coordinated_Care_Discharge_Disposition

  • Type: STRING

  • Required: YES

  • Description: Discharge disposition associated with coordinated care.

  • Coordinated_Care_Discharge_Disposition_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the discharge disposition in the context of coordinated care.

  • Created_User_ID

  • Type: STRING

  • Required: YES

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

  • Last_Modified_User_ID

  • Type: STRING

  • Required: YES

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

  • Permission_From_Name

  • Type: STRING

  • Required: YES

  • Description: Name of the individual from whom permission is required to apply the cost saving.

  • Permission_From_Role

  • Type: STRING

  • Required: YES

  • Description: Role of the individual from whom permission is required.

  • Medical_Director_Name

  • Type: STRING

  • Required: YES

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

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Cost_Saving_log

Fields

  • Costs

  • Type: ARRAY

  • Required: NO

  • Description: Array of associated cost details, each containing fields such as cost type, amount, and related provider information.

Costs Fields

  • Key

  • Type: INT64

  • Required: YES

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

  • Cost_ID

  • Type: STRING

  • Required: YES

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

  • Original_Indicator

  • Type: BOOL

  • Required: YES

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

  • Void_Indicator

  • Type: BOOL

  • Required: YES

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

  • Void_Reason

  • Type: STRING

  • Required: YES

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

  • Void_Reason_Description

  • Type: STRING

  • Required: YES

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

  • Diagnosis_Code

  • Type: STRING

  • Required: YES

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

  • Diagnosis_Description

  • Type: STRING

  • Required: YES

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

  • Diagnosis_Group

  • Type: STRING

  • Required: YES

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

  • Diagnosis_Group_Description

  • Type: STRING

  • Required: YES

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

  • Diagnosis_Coding_Scheme

  • Type: STRING

  • Required: YES

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

  • Bed_Type

  • Type: STRING

  • Required: YES

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

  • Bed_Type_Description

  • Type: STRING

  • Required: YES

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

  • Type_Of_Care

  • Type: STRING

  • Required: YES

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

  • Type_Of_Care_Description

  • Type: STRING

  • Required: YES

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

  • Units

  • Type: INT64

  • Required: YES

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

  • Cost_Per_Unit

  • Type: NUMERIC

  • Required: YES

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

  • Cost_Type

  • Type: STRING

  • Required: YES

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

  • Primary_Service_Coding_Scheme

  • Type: STRING

  • Required: YES

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

  • Service_Code

  • Type: STRING

  • Required: YES

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

  • Service_Description

  • Type: STRING

  • Required: YES

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

  • Service_Provider_Name

  • Type: STRING

  • Required: YES

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

Cost Dataset Specification

Of_Measure

  • Required: YES

  • Type: STRING

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

Costs

Costs.Created_User_ID

  • Required: YES

  • Type: STRING

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

Costs.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

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

Costs.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Costs.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Cost_Saving_Log

Notes

  • Required: NO

  • Type: ARRAY

  • Description: Array of notes related to the cost saving, detailing observations or additional information from users or administrators.

Notes.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each note entry in the system.

Notes.Text

  • Required: YES

  • Type: STRING

  • Description: The content or body of the note, providing relevant information or observations.

Notes.Author_User_ID

  • Required: YES

  • Type: STRING

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

Notes.Author_Full_Name

  • Required: YES

  • Type: STRING

  • Description: The full name of the user who authored the note.

Notes.Author_User_Title

  • Required: YES

  • Type: STRING

  • Description: The professional title or role of the user who authored the note.

Notes.Author_Phone_Number

  • Required: YES

  • Type: STRING

  • Description: The contact phone number of the note’s author, if applicable.

Notes.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp marking when the note was originally created.

Notes.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp marking the most recent modification or update made to the note.

Cost_Saving_Raw

Record_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating the last modification to the cost-saving record.

Transaction_User_ID

  • Required: YES

  • Type: STRING

  • Description: ID of the user involved in the transaction for the cost-saving record.

Deleted_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the cost-saving record has been marked as deleted.

Type

  • Required: YES

  • Type: STRING

  • Description: Type of the cost-saving record.

Tenant

  • Required: YES

  • Type: STRING

  • Description: Identifies the tenant in the context of a multi-tenant system.

Active_Version

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether this version of the cost-saving record is active.

Date

  • Required: YES

  • Type: DATE

  • Description: The date associated with the cost-saving record.

Sequence

  • Required: YES

  • Type: INT64

  • Description: Sequence number used for ordering or versioning the cost-saving records.

Source_System_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source system from which the cost-saving data originates.

Source_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the data was captured from the source system.

Source_File_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the file from the source system containing the cost-saving data.

Schema_Version

  • Required: YES

  • Type: FLOAT64

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

Member_Partition

  • Required: YES

  • Type: INT64

  • Description: Partition key based on the member ID, used for data segmentation and optimization.

Other_Coordinated_Care_Discharge_Disposition_Description

  • Required: YES

  • Type: STRING

  • Description: Additional description for the coordinated care discharge disposition that is not covered by standard categories.

Related Articles
Request Dataset Specification
Questionnaire Dataset Specification
Program Dataset Specification
Cost Saving Dataset Specification
Fax Dataset Specification
Did this answer your question?