Skip to main content

Program Dataset Specification

Updated over 4 months ago

Program Dataset Specification

Program Dataset Specification

The "Program Dataset Specification" stores member participation in programs, including different stages (screening, enrollment, etc.), with unique keys for references. It is an umbrella entity for Program_Plan_Of_Care.

Key Identifiers

  • Screening_Request_Key: Enforced unique key.

  • Program_ID: Unique identifier for programs.

  • Screening_Key: Optional key for references.

  • Problem_Key: Unique key for problems.

  • Questionnaire_Response_Key: Unique key for member responses to questionnaires.

References

  • Members: Referenced by Member_ID for direct access and efficient partitioning.

  • Providers: Referenced by Provider_Key.

  • Parent Programs: Referenced by Program_Enrollment_Key.

  • Questionnaire Metadata: Referenced by Questionnaire.Key.

  • Other Entities: Referenced by Program_ID in Member_Program_Questionnaire, Letter, Cost_Saving, Task, and Interaction_Topic.

Key Components

Program Management

Stores details on the administration and operational aspects of healthcare programs, helping to oversee and coordinate activities effectively.

Enrollment Details

Contains information about patient enrollment in specific programs, critical for tracking participation and engagement.

Care Planning

Provides structured data on the planning of individual patient care within programs, ensuring tailored and proactive healthcare delivery.

Problem Identification

Captures issues and challenges identified during the care process, facilitating timely interventions and support.

Notes and Logs

Includes detailed notes and logs documenting ongoing activities, observations, and interventions, offering a comprehensive view of patient interactions and program operations.

History Tracking

Maintains records of historical data related to program changes and patient progress, essential for longitudinal studies and outcome assessments.

Raw Data Storage

Holds unprocessed data, providing a robust foundation for in-depth analysis and research, enabling further insights into program effectiveness and areas for improvement.

Table Schema

Columns

Column Name

Is Nullable

Data Type

Description

Program_ID

YES

STRING

A unique identifier assigned to each program within the database. See Dictionary Program table in the Dictionary Dataset Specification.

Screening_Key

YES

INT64

A key associated with screening records linked to the program.

Screening_Request_Key

YES

INT64

A key associated with screening requests linked to the program.

Program_Enrollment_Key

YES

INT64

An identifier assigned to program enrollment records.

Member_ID

YES

STRING

An identification number for the member enrolled in the program.

Member_Enrollment_Key

YES

STRING

An identifier for the member's enrollment, determined by locating the primary active enrollment where the screening date falls between the enrollment's effective and termination dates.

Member_Enrollment_Effective_Date

YES

DATE

The date when the member's enrollment in the program started, derived from the "Effective_Date" parameter within the "Member Enrollment" table associated with the member.

Member_Enrollment_Termination_Date

YES

DATE

The date when the member's enrollment in the program ended, derived from the "Termination_Date" parameter within the "Member Enrollment" table associated with the member.

Group_ID

YES

STRING

An identification number for the group associated with the member's enrollment, sourced from the "Group_ID" parameter within the "Member Enrollment" table associated with the member.

Group_Name

YES

STRING

The name of the group associated with the member's enrollment, retrieved from the "Group_Name" parameter within the "Member Enrollment" table associated with the member.

Plan_ID

YES

STRING

An identification number for the plan associated with the member's enrollment, obtained from the "Plan_ID" parameter within the "Member Enrollment" table associated with the member.

Plan_Description

YES

STRING

A description of the plan associated with the member's enrollment, fetched from the "Plan_Description" parameter within the "Member Enrollment" table associated with the member.

Line_Of_Business

YES

STRING

Identifier for the line of business associated with the member's enrollment. This identifier is mapped from the "Line_Of_Business" parameter within the "Member Enrollment" table. See Dictionary Dataset.

Program Dataset Specification

Dictionary Line Of Business Table

Line_Of_Business_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the line of business associated with the member's enrollment. This description is obtained from the "Line_Of_Business_Description" parameter within the "Member Enrollment" table.

Screening Details

Screening_Request_Date

  • Required: YES

  • Type: DATE

  • Description: The date when the screening request was made.

Screening_Program

  • Required: YES

  • Type: STRING

  • Description: The program associated with the screening.

Screening_Program_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the program associated with the screening.

Screening_Severity

  • Required: YES

  • Type: STRING

  • Description: The severity level of the screening.

Screening_Severity_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the severity level of the screening. It is derived based on the value of the "Screening_Severity" parameter.

Screening_Product

  • Required: YES

  • Type: STRING

  • Description: The product related to the screening.

Screening_Product_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the product related to the screening.

Screening_Request_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the screening request was created.

Screening_Request_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the screening request was last modified.

Screening_Date

  • Required: YES

  • Type: DATE

  • Description: The date when the screening occurred.

Screening_Status

  • Required: YES

  • Type: STRING

  • Description: The status of the screening request.

Screening_Status_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the screening status. It is derived based on the value of the "Screening_Status" parameter.

Referral Details

Referral_Outstanding_Days

  • Required: YES

  • Type: INT64

  • Description: The number of days the referral has been outstanding. If the screening status is 'NOTCOMPLETED', this parameter calculates the difference between the current date and the screening request date. Otherwise, it's null.

Program Enrollment Details

Total_Duration_Days

  • Required: YES

  • Type: INT64

  • Description: Total duration, in days, of the program's enrollment. This is calculated based on various conditions including enrollment start date, close date, and current date.

Enrollment_Status

  • Required: YES

  • Type: STRING

  • Description: The status of the program's enrollment, derived from the screening status and enrollment start date.

Enrollment_Status_Description

  • Required: YES

  • Type: STRING

  • Description: Description corresponding to the enrollment status, providing additional context on the program's enrollment state.

Not_Enrolled_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for not enrolling in the program, if applicable.

Not_Enrolled_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Description explaining the reason for not enrolling in the program, if provided.

Close_Reason

  • Required: YES

  • Type: STRING

  • Description: The reason for closing the program, if applicable.

Close_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Description explaining the reason for closing the program, if provided.

Screening Ownership Details

Screening_Owner_ID

  • Required: YES

  • Type: STRING

  • Description: Identification of the screening owner, which can be either an individual or a department.

Screening_Owner_Type

  • Required: YES

  • Type: STRING

  • Description: Type of screening owner, indicating whether it's an individual ("INDV") or a department ("DEPT").

Screening_Owner_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the screening owner, which could be a user's full name or a department's name, based on the screening owner ID.

Screening_Owner_User_Name

  • Required: YES

  • Type: STRING

  • Description: User name of the screening owner.

Screening_Owner_Department_ID

  • Required: YES

  • Type: STRING

  • Description: Department ID of the screening owner.

Screening_Owner_Department_Name

  • Required: YES

  • Type: STRING

  • Description: Department name of the screening owner.

Screening_Owner_User_ID

  • Required: YES

  • Type: STRING

  • Description: ID of the screening owner.

Screening Timestamps

Screening_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the screening was initially created.

Screening_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating the last modification made to the screening.

Screener Details

Screener_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identification of the user who conducted the screening.

Screener_User_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the user who conducted the screening.

Source System Details

Source_System_ID

  • Required: YES

  • Type: STRING

  • Description: Identification of the source system.

Source_System_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the source system.

Source_System_Record_ID

  • Required: YES

  • Type: STRING

  • Description: Record ID from the source system where the Source_System_ID is 'CARE_PLANNER_WEB'.

Enrollment Program Details

Enrollment_Program

  • Required: YES

  • Type: STRING

  • Description: The program associated with enrollment.

Enrollment_Program_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the program associated with enrollment.

Enrollment_Severity

  • Required: YES

  • Type: STRING

  • Description: Severity level associated with enrollment.

Enrollment_Severity_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the severity level associated with enrollment.

Enrollment_Product

  • Required: YES

  • Type: STRING

  • Description: The product linked to the enrollment.

Program Dataset Specification

Dictionary Product Table

Refer to the Dictionary Product table in the Dictionary Dataset Specification for detailed information.

Columns and Descriptions

  • Enrollment_Product_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the product linked to the enrollment.

  • Enrollment_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when enrollment in the program occurred.

  • Close_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the program was closed, if applicable.

  • Closed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the program is closed. It is true if the Close_Date is not null, otherwise false.

  • Enrollment_Start_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when enrollment in the program started.

  • Enroller_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identification of the user who enrolled the program.

  • Enroller_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who enrolled the program, mapped to their full name.

  • Enrollment_Owner_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identification of the owner of the enrollment, which can be either an individual or a department.

  • Enrollment_Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of enrollment owner, indicating whether it's an individual ("INDV") or a department ("DEPT").

  • Enrollment_Owner_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the owner of the enrollment, which could be a user's full name or a department's name, based on the enrollment owner ID.

  • Enrollment_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the enrollment was initially created.

  • Enrollment_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the last modification made to the enrollment.

Primary Provider Information

Columns and Descriptions

  • Primary_Provider_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The primary key of the primary provider associated with the program.

  • Primary_Provider_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identification of the primary provider associated with the program.

  • Primary_Provider_NPI

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The National Provider Identifier (NPI) of the primary provider associated with the program.

  • Primary_Provider_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the primary provider associated with the program.

  • Primary_Provider_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description for the type of the primary provider associated with the program.

  • Primary_Provider_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the primary provider associated with the program, mapped to their full name.

Primary Diagnosis Information

Columns and Descriptions

  • Primary_Diagnosis_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The primary key associated with the primary diagnosis of the program.

  • Primary_Diagnosis_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code representing the primary diagnosis of the program.

  • Primary_Diagnosis_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the primary diagnosis of the program.

  • Primary_Diagnosis_Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The coding scheme used for the primary diagnosis of the program.

  • Primary_Diagnosis_Coding_Scheme_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the coding scheme used for the primary diagnosis of the program.

  • Primary_Diagnosis_Condition_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The category of the primary diagnosis condition.

  • Primary_Diagnosis_Condition_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the category of the primary diagnosis condition.

  • Primary_Axis

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The primary axis associated with the diagnosis.

  • Primary_Axis_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the primary axis associated with the diagnosis.

  • Primary_Diagnosis_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the primary diagnosis was initially created.

  • Primary_Diagnosis_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the last modification made to the primary diagnosis.

Program Information

Columns and Descriptions

  • Program_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of the program (e.g., clinical, wellness).

  • Program_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the type or category of the program.

  • Digital

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator of whether the program is conducted digitally (yes/no).

  • External_Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for an external program linked to this dataset.

  • External_Program_Vendor_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the vendor providing the external program.

  • External_Program_Vendor_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the external program vendor.

  • External_Program_Vendor_Phone

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Phone number of the external program vendor.

  • External_Program_Vendor_Email

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Email address of the external program vendor.

  • External_Program_Vendor_Link

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Link or URL for the external program vendor.

Program State Information

Columns and Descriptions

  • Current_Step

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the current step or phase within the program.

  • Current_Step_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the current step or phase within the program.

  • Current_State

  • Is Nullable: YES

  • Data Type: STRING

  • Description: State or status of the program (e.g., active, paused, completed).

  • Current_State_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the program's current state or status.

  • Digital_Pause_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator of whether the program is currently paused digitally (yes/no).

  • Digital_Pause_By_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or reason for the digital pause.

  • Digital_Pause_By_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the type or reason for the digital pause.

  • Digital_Pause_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the program was paused digitally.

  • Last_Closed_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the individual who last closed or completed the program.

  • Last_Closed_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the individual who last closed or completed the program.

Audit Log Information

Columns and Descriptions

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the program associated with the edit history record. Refer to the Dictionary Program table in the Dictionary Dataset Specification.

  • Audit_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The class or category of the audit data point being modified (e.g., demographic information, medical history, treatment plan). Refer to the Dictionary Audit Log Class table in the Dictionary Dataset Specification.

  • Audit_Data_Point

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific data point within the audit class being modified (e.g., patient age, diagnosis, medication dosage). Refer to the Dictionary Audit Log Data Point table in the Dictionary Dataset Specification.

  • Old_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The previous value of the edited data point before the change.

  • New_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The new value of the edited data point after the change.

Program Dataset Specification

Edit Details

Columns

  • Close_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the edit was made.

  • Edit_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who made the edit.

  • Edit_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who made the edit.

  • Edit_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the edit was made.

Program Details

Columns

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the program.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created the program.

  • Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who created the program.

Program Custom Fields

Columns

  • Program_Custom_Field_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The unique key or identifier for the custom field entry in the program's custom fields table.

  • Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key associated with the screening process to which the custom field pertains.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the program to which the custom field belongs. See Dictionary Program table in the Dictionary Dataset Specification.

  • ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identification number or code assigned to the custom field.

  • Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title or name of the custom field, providing a brief description of its purpose or content.

  • Use

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates how the custom field is utilized within the system or application.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the custom field entry was initially created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the custom field entry.

  • Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The value associated with the custom field.

  • Value_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description or explanation providing additional context for the value of the custom field, especially if the value is not self-explanatory.

  • Select_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key associated with the selection made in the custom field, if applicable.

  • Select_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the selection in the custom field was initially created.

  • Select_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the selection in the custom field.

Program Provider Roles

Columns

  • Program_Provider_Role_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The unique key or identifier for the provider role entry in the program's custom provider roles table.

  • Program_Provider_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key associated with the provider within the program.

  • Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key associated with the screening process to which the provider role pertains.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the program to which the provider role belongs. See Dictionary Program table in the Dictionary Dataset Specification.

  • Provider_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key or identifier associated with the provider in the system.

  • Provider_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identification number or code assigned to the provider.

  • Provider_NPI

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The National Provider Identifier (NPI) of the provider.

  • Primary_Provider_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the primary provider associated with the program.

  • Primary_Provider_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description for the type of the primary provider associated with the program.

  • Provider_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the provider.

  • Primary

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the provider holds a primary role within the program.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the provider role entry was initially created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the provider role entry.

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code associated with the provider role. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The description or name of the provider role, providing details about the role's responsibilities or functions. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

  • Role_Effective_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the provider assumed or started the role within the program.

  • Role_Termination_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the provider's role within the program was terminated or ended.

  • Role_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the provider role entry was initially created or established.

  • Role_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the provider role entry, including changes to role details such as effective or termination dates.

Screening Details

Columns

  • Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the screening entry.

  • Decision_Changed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether a decision has been changed (e.g., Yes/No).

  • Decision_Change_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the decision change was made.

  • Decision_Change_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Specific date when the decision change was recorded.

  • Decision_Change_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who made the decision change.

  • Decision_Change_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who made the decision change.

Program Diagnoses

Columns

  • Program_Diagnosis_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The unique key or identifier for the diagnosis entry in the program's diagnoses table.

  • Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key associated with the screening process to which the diagnosis pertains.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the program to which the diagnosis belongs. See Dictionary Program table in the Dictionary Dataset Specification.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the diagnosis entry was initially created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the diagnosis entry.

  • Primary

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the diagnosis is the primary diagnosis for the program.

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code representing the diagnosis.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The description or name of the diagnosis, providing details about the medical condition or ailment.

  • Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The coding scheme used for the diagnosis code.

  • Coding_Scheme_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the coding scheme used for the diagnosis code.

Program Dataset Specification

Diagnosis Details

Columns and Descriptions

  • Condition_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The category or classification of the medical condition associated with the diagnosis.

  • Condition_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the category or classification of the medical condition associated with the diagnosis.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The sequence number indicating the order of importance or relevance of the diagnosis within the program.

  • Axis

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The axis associated with the diagnosis code. See the Dictionary Axis table in the Dictionary Dataset Specification.

  • Axis_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the axis associated with the diagnosis code. See the Dictionary Axis table in the Dictionary Dataset Specification.

Cost Saving Program Enrollment Details

Columns and Descriptions

  • Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The unique key or identifier for the enrollment in the program's enrollment cost-saving details table.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the program to which the enrollment cost-saving details belong. See the Dictionary Program table in the Dictionary Dataset Specification.

  • Savings_Documentation_Start_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The start date of the documentation period for cost-saving measures.

  • Savings_Documentation_End_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The end date of the documentation period for cost-saving measures.

  • Cost_Saving_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code representing the specific cost-saving measure.

  • Cost_Saving_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The description or name of the cost-saving measure, providing details about the method or approach used to save costs.

  • Cost_Saving_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type or category of the cost-saving measure.

  • Cost_Saving_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the type or category of the cost-saving measure.

  • Other_Cost_Saving_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description or details for the cost-saving measure if it does not fit into predefined categories.

  • Care_Management_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type or method of care management associated with the cost-saving measure.

  • Care_Management_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the type or method of care management associated with the cost-saving measure.

  • Coordinated_Care_Discharge_Disposition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The disposition of the patient upon discharge related to coordinated care efforts.

  • Coordinated_Care_Discharge_Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the disposition of the patient upon discharge related to coordinated care efforts.

  • Other_Coordinated_Care_Discharge_Disposition_Description

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Additional description or details for the disposition of the patient upon discharge related to coordinated care efforts if it does not fit into predefined categories.

  • Cost_Saving_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the specific cost-saving entry.

  • Permission_Required

  • Is Nullable: YES

  • Data Type: BOOL

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

  • Permission_From_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the entity or individual from whom permission is required for the cost-saving measure.

  • Permission_From_Role

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The role or position of the entity or individual from whom permission is required for the cost-saving measure.

  • Medical_Director_Name

  • Is Nullable: YES

  • Data Type: STRING

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

  • Cost_Saving_Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

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

  • Cost_Saving_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The 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_Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the cost-saving entry.

  • Cost_Saving_Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who created the cost-saving entry.

  • Cost_Saving_Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the cost-saving entry.

  • Cost_Saving_Last_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the cost-saving entry.

  • Cost_Saving_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the cost-saving entry was initially created.

  • Cost_Saving_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the cost-saving entry.

  • Cost_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the cost associated with the cost-saving measure.

  • Cost_Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the cost entry has been voided.

  • Cost_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The reason for voiding the cost entry.

  • Cost_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: The code representing the diagnosis associated with the cost-saving details.

  • Diagnosis_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The description or name of the diagnosis.

Program Dataset Specification

Cost Saving Program Enrollment Details

Diagnosis Group

  • Column Name: Diagnosis_Group

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The group to which the diagnosis belongs.

Diagnosis Group Description

  • Column Name: Diagnosis_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the diagnosis group.

Diagnosis Coding Scheme

  • Column Name: Diagnosis_Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The coding scheme used for the diagnosis code.

Bed Type

  • Column Name: Bed_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of bed used for the patient's care. See Dictionary Bed Type table in the Dictionary Dataset Specification.

Bed Type Description

  • Column Name: 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

  • Column Name: Type_Of_Care

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type or category of care provided.

Type of Care Description

  • Column Name: Type_Of_Care_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the type or category of care provided.

Units

  • Column Name: Units

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The number of units of the service provided.

Cost Per Unit

  • Column Name: Cost_Per_Unit

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The cost per unit of the service provided.

Cost Type

  • Column Name: Cost_Type

  • Is Nullable: YES

  • Data Type: STRING

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

Service Code

  • Column Name: Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code representing the service provided.

Service Description

  • Column Name: Service_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The description or name of the service provided.

Service Unit of Measure

  • Column Name: Service_Unit_Of_Measure

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unit of measure for the service provided.

Service Provider Name

  • Column Name: Service_Provider_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the provider who delivered the service.

Primary Service Coding Scheme

  • Column Name: Primary_Service_Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The coding scheme used for the primary service code.

Cost Created User ID

  • Column Name: Cost_Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the cost-saving details.

Cost Created User Name

  • Column Name: Cost_Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who created the cost-saving details.

Cost Last Modified User ID

  • Column Name: Cost_Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the cost-saving details.

Cost Last Modified User Name

  • Column Name: Cost_Last_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the cost-saving details.

Cost Created Timestamp

  • Column Name: Cost_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the cost-saving details were initially created.

Cost Last Modified Timestamp

  • Column Name: Cost_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the cost-saving details.

Total Cost

  • Column Name: Total_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The total cost associated with the provided service or care.

Expected Cost

  • Column Name: Expected_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The expected cost of the service or care.

Actual Cost

  • Column Name: Actual_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The actual cost incurred for the service or care.

Cost Category

  • Column Name: Cost_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The category or classification of the cost.

Cost Category Description

  • Column Name: Cost_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the category or classification of the cost.

Cost Type Description

  • Column Name: Cost_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Savings Documentation End Date (YYYYMM)

  • Column Name: Savings_Documentation_End_Date_YYYYMM

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date of the documentation period for savings in YYYYMM format.

Documentation Closed

  • Column Name: Documentation_Closed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the documentation for cost savings is closed.

Condition Category

  • Column Name: Condition_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a category or classification related to specific conditions (e.g., health conditions, cost-saving criteria).

Condition Category Description

  • Column Name: Condition_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional details about the condition category (e.g., “Chronic Diseases” or “Eligibility Criteria”).

Cost Saving Program Enrollment Notes

Note Key

  • Column Name: Note_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The unique identifier/key for the cost-saving note.

Cost Saving Key

  • Column Name: Cost_Saving_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The key linking the note to the specific cost-saving details to which it pertains.

Text

  • Column Name: Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content or text of the note, providing additional information or comments related to the cost-saving details.

Author User ID

  • Column Name: Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Author User Name

  • Column Name: Author_User_Name

  • Is Nullable: YES

  • Data Type: STRING

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

Author User Title

  • Column Name: Author_User_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title or position of the user who authored or created the note.

Author Phone Number

  • Column Name: Author_Phone_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The phone number associated with the author of the note, if applicable.

Void Indicator

  • Column Name: Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the note is voided.

Void Timestamp

  • Column Name: Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was voided.

Void Reason

  • Column Name: Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding the note.

Void Reason Description

  • Column Name: Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the reason for voiding the note.

Void User ID

  • Column Name: Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who voided the note.

Void User Name

  • Column Name: Void_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who voided the note.

Created Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the note was created.

Program Dataset Specification

Cost Saving Program Enrollment Notes

Columns

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the note.

Cost Saving Program Enrollment Summary

Columns

  • Savings_Documentation_End_Date_YYYYMM

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date of the documentation period for cost savings, represented in YYYYMM format.

  • Enrollment_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier or code for the enrollment program associated with the cost-saving summary.

  • Enrollment_Program_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description providing details about the enrollment program associated with the cost-saving summary.

  • Enrollment_Product

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier or code for the product related to the enrollment program. See the Dictionary Product table in the Dictionary Dataset Specification.

  • Enrollment_Product_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description providing details about the product related to the enrollment program. See the Dictionary Product table in the Dictionary Dataset Specification.

  • Group_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier for the group associated with the cost-saving summary.

  • Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or label of the group associated with the cost-saving summary.

  • Plan_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier for the plan associated with the cost-saving summary.

  • Plan_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description providing details about the plan associated with the cost-saving summary.

  • Line_Of_Business

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier for the line of business associated with the cost-saving summary. See the Dictionary Line Of Business table in the Dictionary Dataset Specification.

  • Line_Of_Business_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description providing details about the line of business associated with the cost-saving summary. See the Dictionary Line Of Business table in the Dictionary Dataset Specification.

  • Client_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code representing the client associated with the cost-saving summary.

  • Client_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description providing details about the client associated with the cost-saving summary.

  • Cost_Saving_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type or category of cost-saving.

  • Cost_Saving_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description providing details about the type or category of cost-saving.

  • Total_Cost_Saving_Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The total count of cost-saving instances.

  • Total_Expected_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The total expected cost for all instances of cost-saving.

  • Total_Actual_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The total actual cost for all instances of cost-saving.

  • Total_Cost_Saving

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The total cost savings achieved across all instances.

Program Enrollment Key

Columns

  • Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The unique identifier for the enrollment within the program.

  • First_Enrollment_Owner_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the first owner responsible for the enrollment, determined from historical data within each enrolled program ID.

  • First_Enrollment_Owner_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the first owner responsible for the enrollment, derived from historical data within each enrolled program ID.

  • First_Enrollment_Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of the first owner responsible for the enrollment, determined from historical data within each enrolled program ID (e.g., individual or department).

  • Enrollment_Owner_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the current owner responsible for the enrollment, derived from the current program data, considering both user and department IDs.

  • Enrollment_Owner_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the current owner responsible for the enrollment, derived from the current program data, considering both user and department names.

  • Enrollment_Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of the current owner responsible for the enrollment, derived from the current program data (e.g., individual or department).

  • Previous_Enrollment_Owner_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the previous owner responsible for the enrollment, determined from historical data within each enrolled program ID.

  • Previous_Enrollment_Owner_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the previous owner responsible for the enrollment, derived from historical data within each enrolled program ID.

  • Previous_Enrollment_Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of the previous owner responsible for the enrollment, determined from historical data within each enrolled program ID (e.g., individual or department).

  • First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A flag indicating whether the record is the first historical record within a program.

  • Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A flag indicating whether the record is the latest historical record within a program.

  • Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the effective time of the record.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user associated with the transaction.

  • Transaction_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The full name of the user associated with the transaction, derived from the user ID.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A flag used as a filter, typically set to false to filter out deleted records.

Program Enrollment Metrics

Columns

  • Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the program enrollment entry.

  • Days_In_Closed_Program

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days the program was in a closed state.

  • Enrollment_Month_Count

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Total number of months the enrollment has been active.

  • Days_In_Program

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Total number of days the enrollment has been active.

Program Dataset Specification

Enrollment Reopen Details

Columns and Descriptions

  • Enrollment_Reopen_Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of times the enrollment has been reopened.

  • Enrollment_Reopen_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for reopening the enrollment.

  • Enrollment_Reopen_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the reason for reopening the enrollment.

  • Enrollment_Reopen_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the enrollment was reopened.

  • Enrollment_Reopen_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who reopened the enrollment.

  • Enrollment_Reopen_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who reopened the enrollment.

  • Enrollment_Reopen

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the enrollment has been reopened (e.g., Yes/No).

Program Enrollment Details

Columns and Descriptions

  • Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each enrollment record in the program.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program associated with the enrollment. See Dictionary Program table in the Dictionary Dataset Specification.

  • Enrollment_Start_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the enrollment started. For reopened programs, the reopen date is used as the enrollment start date.

  • Enrollment_Close_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the enrollment was closed.

  • Days_In_Closed_Program

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days the program was closed. Calculated based on the closed and open/reopen dates for all iterations using data from the Program_LOG table.

  • Gap_Days

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days between the current program's closed date and the next program's reopen date.

  • Enrollment_Reopen

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the enrollment was reopened. True if the program was reopened, otherwise false.

  • Enrollment_Reopen_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who reopened the enrollment.

  • Enrollment_Reopen_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full name of the user who initiated the reopening of the enrollment. This information is mapped to the Full_Name field within the User table based on the Enrollment_Reopen_User_ID.

  • Enrollment_Reopen_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for reopening the enrollment. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

  • Enrollment_Reopen_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the reason for reopening the enrollment. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

  • Enrollment_Reopen_Order

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequential number assigned to each open/reopen/close record within an enrollment ID.

  • Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether a record is the latest or not. True if it's the latest record, otherwise false.

Enrollment Severity Details

Columns and Descriptions

  • Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each enrollment record in the program.

  • First_Enrollment_Severity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The severity of the first enrollment in the program, calculated based on data from the Program_LOG table. See Dictionary Program Severity table in the Dictionary Dataset Specification.

  • First_Enrollment_Severity_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the severity of the first enrollment, derived from data in the Program_LOG table. See Dictionary Program Severity table in the Dictionary Dataset Specification.

  • First_Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the severity for the first enrollment was set within the program.

  • Enrollment_Severity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Severity of the current enrollment in the program. See Dictionary Program Severity table in the Dictionary Dataset Specification.

  • Enrollment_Severity_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the severity of the current enrollment. See Dictionary Program Severity table in the Dictionary Dataset Specification.

  • Previous_Enrollment_Severity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Severity of the enrollment before the current one, calculated based on data from the Program_LOG table. See Dictionary Program Severity table in the Dictionary Dataset Specification.

  • Previous_Enrollment_Severity_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the severity of the enrollment before the current one, derived from data in the Program_LOG table. See Dictionary Program Severity table in the Dictionary Dataset Specification.

  • Next_Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the next historical record of enrollment severity within the program begins. If null, the current record is the latest change.

  • First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether a record is the first historical record within a program. True if it is the first record, false otherwise.

  • Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether a record is the latest historical record within a program. True if it is the latest record, false otherwise.

  • Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when a change to the enrolled severity occurred within the program.

  • Program_Enrollment_Severity_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user responsible for setting the enrollment severity.

  • Program_Enrollment_Severity_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full name of the user responsible for setting the enrollment severity, derived from the User table.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator used as a filter. False indicates that the record is not deleted.

Global Assessment of Functioning Details

Columns and Descriptions

  • Program_Global_Assessment_of_Functioning_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each record of global assessment of functioning within the program.

  • Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier linking the assessment to a specific screening process.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the program associated with the assessment. See Dictionary Program table in the Dictionary Dataset Specification.

  • Score

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The score assigned for the global assessment of functioning.

  • Score_Entry_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the score for the global assessment of functioning was entered.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the assessment record was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the assessment record was last modified.

Screening Request Details

Columns and Descriptions

  • Screening_Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the screening request associated with the program move.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the program involved in the move. See Dictionary Program table.

Program Dataset Specification

Dictionary Dataset Specification

Entity Move Key

  • Entity_Move_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key for tracking the specific move event within the program.

  • From_Member_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key of the member from whom the program is being moved.

  • To_Member_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key of the member to whom the program is being moved.

  • From_Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member from which the program was moved.

  • To_Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member to which the program was moved.

  • Moved_By_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who initiated the program move.

  • Moved_By_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full name of the user who initiated the program move.

  • Moved_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the program move occurred.

Program Notes

  • Program_Note_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for each program note entry.

  • Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier linking the note to a specific screening.

  • Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content of the note.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the type of note. See Dictionary Note Type table in the Dictionary Dataset Specification.

  • Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the note type. See Dictionary Note Type table in the Dictionary Dataset Specification.

  • Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

  • Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the author who created the note.

  • Author_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full name of the author who created the note.

  • Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the note is voided or not.

  • Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was voided.

  • Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding the note. See Dictionary Note Void Reason table in the Dictionary Dataset Specification.

  • Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the reason for voiding the note. See Dictionary Note Void Reason table in the Dictionary Dataset Specification.

  • Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who voided the note.

  • Void_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full name of the user who voided the note.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification time of the note.

Program Plan of Care Goal Barriers

  • Program_Plan_Of_Care_Goal_Barrier_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each barrier entry within a program plan of care goal. See Dictionary Barrier table in the Dictionary Dataset Specification.

  • Program_Plan_Of_Care_Goal_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier linking the barrier to a specific program plan of care goal.

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the barrier.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the barrier. See Dictionary Barrier table in the Dictionary Dataset Specification.

  • Other_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description if the barrier is not covered by the predefined codes.

  • Identification_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the barrier was identified.

  • Resolution_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the barrier was resolved.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the barrier entry was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification time of the barrier entry.

  • Barrier_Resolved

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the barrier is resolved or not.

  • Barrier_Resolved_Days

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days taken to resolve the barrier.

  • Barrier_Resolved_Days_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the duration taken to resolve the barrier.

  • Barrier_Resolved_Days_Sort_Order

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sort order for displaying barriers based on the number of days taken to resolve them, used for sorting purposes.

Program Plan of Care Goals

  • Goal_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each program plan of care goal. See Dictionary Goal Focus table in the Dictionary Dataset Specification.

  • First_Goal_Focus_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the first goal focus associated with the program plan of care goal.

  • Goal_Focus_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the current goal focus associated with the program plan of care goal. See Dictionary Goal Focus table in the Dictionary Dataset Specification.

  • Previous_Goal_Focus_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the previous goal focus associated with the program plan of care goal.

  • Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the goal focus change took effect.

  • First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the record represents the first historical change of the goal focus within a program goal.

  • Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the record represents the latest historical change of the goal focus within a program goal.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier of the user who initiated the change in goal focus.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator of whether the record has been deleted.

Program Plan of Care Goal Focus

  • Program_Plan_Of_Care_Goal_Focus_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each program plan of care goal focus. See Dictionary Goal Focus table in the Dictionary Dataset Specification.

  • Program_Plan_Of_Care_Goal_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier linking the goal focus to the corresponding program plan of care goal.

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the program plan of care goal focus.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the program plan of care goal focus. See Dictionary Goal Focus table in the Dictionary Dataset Specification.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the program plan of care goal focus was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the program plan of care goal focus was last modified.

Program Plan of Care Goal Intervention Engagement Notes

  • Program_Plan_Of_Care_Goal_Intervention_Engagement_Emmi_Note_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each note related to program plan of care goal intervention engagement.

  • Program_Plan_Of_Care_Goal_Intervention_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier linking the note to the corresponding program plan of care goal intervention.

  • Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text content of the note.

  • Entry_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was entered.

Program Dataset Specification

Program Plan of Care Goals

Table Name: Program_Plan_Of_Care_Goal

Column Name

Is Nullable

Data Type

Description

Program_Plan_Of_Care_Goal_Key

YES

INT64

Unique identifier for each plan of care goal. See Dictionary Goal table in the Dictionary Dataset Specification.

Member_ID

YES

STRING

Identifier of the member associated with the goal.

Problem_Key

YES

INT64

Unique identifier for the problem associated with the goal.

Code

YES

STRING

Code representing the goal.

Description

YES

STRING

Description of the goal. See Dictionary Goal table in the Dictionary Dataset Specification.

Other_Description

YES

STRING

Additional description for the goal if available.

Type

YES

STRING

Type of the goal. See Dictionary Goal Type table in the Dictionary Dataset Specification.

Type_Description

YES

STRING

Description of the goal type. See Dictionary Goal Type table in the Dictionary Dataset Specification.

Start_Date

YES

DATE

Date when the goal was initiated.

Actual_Completion_Date

YES

DATE

Actual completion date of the goal.

Target_Completion_Date

YES

DATE

Target completion date set for the goal.

Outcome

YES

STRING

Outcome of the goal. See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

Outcome_Description

YES

STRING

Description of the outcome. See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

Outcome_Category

YES

STRING

Category of the outcome. See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

Outcome_Category_Description

YES

STRING

Description of the outcome category. See Dictionary Goal Outcome Category table in the Dictionary Dataset Specification.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the goal was created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the goal was last modified.

Goal_Count

YES

INT64

Count of goals associated with the plan of care.

Barriers_Count

YES

INT64

Count of barriers associated with the goal.

Interventions_Count

YES

INT64

Count of interventions associated with the goal.

Barriers_Exists

YES

BOOL

Indicates whether barriers exist for the goal.

Interventions_Exists

YES

BOOL

Indicates whether interventions exist for the goal.

Goal_Closed

YES

BOOL

Indicates whether the goal is closed.

Closed_State

YES

STRING

State of closure for the goal.

Closed_State_Description

YES

STRING

Description of the closure state for the goal.

Closed_Days_Description

YES

STRING

Description of the days until closure for the goal.

Closed_Days_Sort_Order

YES

INT64

Sort order for the days until closure for the goal.

Closed_Days

YES

INT64

Number of days until closure for the goal.

Program Plan of Care Notes

Table Name: Program_Plan_Of_Care_Note

Column Name

Is Nullable

Data Type

Description

Program_Plan_Of_Care_Note_Key

YES

STRING

Unique identifier for each note associated with a plan of care.

Problem_Key

YES

INT64

Unique identifier for the problem related to the note.

Text

YES

STRING

The content of the note.

Author_User_ID

YES

STRING

Identifier of the user who authored the note.

Author_User_Name

YES

STRING

Full name of the user who authored the note.

Void_Indicator

YES

BOOL

Indicates whether the note has been voided.

Void_Timestamp

YES

TIMESTAMP

The timestamp when the note was voided.

Void_Reason

YES

STRING

The reason for voiding the note.

Void_Reason_Description

YES

STRING

A detailed description of the reason for voiding the note.

Void_User_ID

YES

STRING

The ID of the user who voided the note.

Void_User_Name

YES

STRING

The name of the user who voided the note.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the note was created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the note was last modified.

Member Problems

Table Name: Member_Problem

Column Name

Is Nullable

Data Type

Description

Member_ID

YES

STRING

Unique identifier for the member associated with the problem.

Program_Enrollment_Key

YES

INT64

Unique identifier for the enrollment program related to the problem.

Program_ID

YES

STRING

Unique identifier for the program associated with the problem. See Dictionary Program table in the Dictionary Dataset Specification.

Problem_Key

YES

INT64

Unique identifier for the problem entry.

Member_Enrollment_Key

YES

STRING

Unique identifier for the member's enrollment.

Member_Enrollment_Effective_Date

YES

DATE

Effective date of the member's enrollment in the program.

Member_Enrollment_Termination_Date

YES

DATE

Termination date of the member's enrollment in the program.

Group_ID

YES

STRING

ID of the group to which the member belongs.

Group_Name

YES

STRING

Name of the group to which the member belongs.

Plan_ID

YES

STRING

ID of the plan associated with the problem.

Plan_Description

YES

STRING

Description of the plan associated with the problem.

Line_Of_Business

YES

STRING

Line of business related to the problem. See Dictionary Line Of Business table in the Dictionary Dataset Specification.

Line_Of_Business_Description

YES

STRING

Description of the line of business related to the problem. See Dictionary Line Of Business table in the Dictionary Dataset Specification.

Problem

YES

STRING

Description of the problem. See Dictionary Problem table in the Dictionary Dataset Specification.

Problem_Description

YES

STRING

Detailed description of the problem. See Dictionary Problem table in the Dictionary Dataset Specification.

Problem_Status

YES

STRING

Status of the problem. See Dictionary Problem Status table in the Dictionary Dataset Specification.

Problem_Status_Description

YES

STRING

Description of the problem status. See Dictionary Problem Status table in the Dictionary Dataset Specification.

Outcome_Code

YES

STRING

Code representing the outcome of the problem.

Problem_Outcome

YES

STRING

Outcome of the problem. See Dictionary Problem Outcome table in the Dictionary Dataset Specification.

Problem_Outcome_Description

YES

STRING

Description of the outcome of the problem. See Dictionary Problem Outcome table in the Dictionary Dataset Specification.

Program Dataset Specification

Problem Dataset Fields

Problem_Outcome_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category of the outcome of the problem. See Dictionary Problem Outcome Category table in the Dictionary Dataset Specification.

Problem_Outcome_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the category of the outcome of the problem. See Dictionary Problem Outcome Category table in the Dictionary Dataset Specification.

Problem_Other_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description of the problem if necessary.

Start_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the problem was initiated.

Actual_Completion_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Actual completion date of the problem.

Target_Completion_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Target completion date of the problem.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the problem entry was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the problem entry was last modified.

Problem_Closed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the problem is closed or not.

Problem_Closed_Days

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days the problem has been closed.

Problem_Closed_Days_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the number of days the problem has been closed.

Problem_Closed_Days_Sort_Order

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sorting order of the problem based on closed days.

Closed_State

  • Is Nullable: YES

  • Data Type: STRING

  • Description: State of closure for the problem.

Closed_State_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the state of closure for the problem.

Goals_Exist

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether goals exist for the problem.

Barriers_Exist

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether barriers exist for the problem.

Interventions_Exist

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether interventions exist for the problem.

Goals_Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of goals associated with the problem.

Barriers_Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of barriers associated with the problem.

Interventions_Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of interventions associated with the problem.

Program Plan of Care Dataset Fields

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the program plan of care.

Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the enrollment program associated with the plan of care.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the program associated with the plan of care. See Dictionary Program table in the Dictionary Dataset Specification.

Problem_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the problem entry in the plan of care.

Problem

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the problem in the plan of care. See Dictionary Problem table in the Dictionary Dataset Specification.

Problem_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the problem in the plan of care. See Dictionary Problem table in the Dictionary Dataset Specification.

Problem_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the problem in the plan of care. See Dictionary Problem Status table in the Dictionary Dataset Specification.

Problem_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the status of the problem in the plan of care. See Dictionary Problem Status table in the Dictionary Dataset Specification.

Outcome_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the outcome of the problem in the plan of care.

Problem_Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome of the problem in the plan of care. See Dictionary Problem Outcome table in the Dictionary Dataset Specification.

Problem_Outcome_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the outcome of the problem in the plan of care. See Dictionary Problem Outcome table in the Dictionary Dataset Specification.

Problem_Outcome_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category of the outcome of the problem in the plan of care. See Dictionary Problem Outcome Category table in the Dictionary Dataset Specification.

Problem_Outcome_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the category of the outcome of the problem in the plan of care. See Dictionary Problem Outcome Category table in the Dictionary Dataset Specification.

Problem_Other_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description of the problem in the plan of care if necessary.

Start_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the problem in the plan of care was initiated.

Actual_Completion_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Actual completion date of the problem in the plan of care.

Target_Completion_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Target completion date of the problem in the plan of care.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the problem entry in the plan of care was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the problem entry in the plan of care was last modified.

Notes

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Any additional notes or comments related to the plan of care.

Notes.Note_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The unique identifier/key for the cost-saving note.

Notes.Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content or text of the note, providing additional information or comments related to the cost-saving details.

Notes.Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Notes.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the note was initially created.

Notes.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the note.

Goals

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Goals associated with the problem in the plan of care.

Goals.Program_Plan_Of_Care_Goal_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each plan of care goal. See Dictionary Goal table in the Dictionary Dataset Specification.

Goals.Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the goal.

Goals.Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the goal.

Program Dataset Specification

Goals

General Attributes

  • Program_Plan_Of_Care_raw Goals.Other_Description

  • Required: YES

  • Type: STRING

  • Description: Additional description for the goal if available.

  • Program_Plan_Of_Care_raw Goals.Type

  • Required: YES

  • Type: STRING

  • Description: Type of the goal. See Dictionary Goal Type table in the Dictionary Dataset Specification.

  • Program_Plan_Of_Care_raw Goals.Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the goal type. See Dictionary Goal Type table in the Dictionary Dataset Specification.

  • Program_Plan_Of_Care_raw Goals.Start_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the goal was initiated.

  • Program_Plan_Of_Care_raw Goals.Actual_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: Actual completion date of the goal.

  • Program_Plan_Of_Care_raw Goals.Target_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: Target completion date set for the goal.

  • Program_Plan_Of_Care_raw Goals.Outcome

  • Required: YES

  • Type: STRING

  • Description: Outcome of the goal. See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

  • Program_Plan_Of_Care_raw Goals.Outcome_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the outcome. See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

  • Program_Plan_Of_Care_raw Goals.Outcome_Category

  • Required: YES

  • Type: STRING

  • Description: Category of the outcome. See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

  • Program_Plan_Of_Care_raw Goals.Outcome_Category_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the outcome category. See Dictionary Goal Outcome Category table in the Dictionary Dataset Specification.

  • Program_Plan_Of_Care_raw Goals.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the goal was created.

  • Program_Plan_Of_Care_raw Goals.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Focuses

  • Program_Plan_Of_Care_raw Goals.Focuses

  • Required: NO

  • Type: ARRAY

  • Description: Goal focuses.

Focus Attributes

  • Program_Plan_Of_Care_raw Goals.Focuses.Program_Plan_Of_Care_Goal_Focus_Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for each program plan of care goal focus. See Dictionary Goal Focus table in the Dictionary Dataset Specification.

  • Program_Plan_Of_Care_raw Goals.Focuses.Code

  • Required: YES

  • Type: STRING

  • Description: Code representing the program plan of care goal focus.

  • Program_Plan_Of_Care_raw Goals.Focuses.Description

  • Required: YES

  • Type: STRING

  • Description: Description of the program plan of care goal focus. See Dictionary Goal Focus table in the Dictionary Dataset Specification.

  • Program_Plan_Of_Care_raw Goals.Focuses.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the program plan of care goal focus was created.

  • Program_Plan_Of_Care_raw Goals.Focuses.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the program plan of care goal focus was last modified.

Interventions

  • Program_Plan_Of_Care_raw Goals.Interventions

  • Required: NO

  • Type: ARRAY

  • Description: Interventions related to the goals.

Intervention Attributes

  • Program_Plan_Of_Care_raw Goals.Interventions.Key

  • Required: YES

  • Type: INT64

  • Description: Unique key of the intervention.

  • Program_Plan_Of_Care_raw Goals.Interventions.Code

  • Required: YES

  • Type: STRING

  • Description: Code representing the goal.

  • Program_Plan_Of_Care_raw Goals.Interventions.Description

  • Required: YES

  • Type: STRING

  • Description: Description of the goal. See Dictionary Goal table in the Dictionary Dataset Specification.

  • Program_Plan_Of_Care_raw Goals.Interventions.Other_Description

  • Required: YES

  • Type: STRING

  • Description: Additional description for the goal if available.

  • Program_Plan_Of_Care_raw Goals.Interventions.Start_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the goal was initiated.

  • Program_Plan_Of_Care_raw Goals.Interventions.Actual_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: Actual completion date of the goal.

  • Program_Plan_Of_Care_raw Goals.Interventions.Target_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: Target completion date set for the goal.

  • Program_Plan_Of_Care_raw Goals.Interventions.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the goal was created.

  • Program_Plan_Of_Care_raw Goals.Interventions.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Engagement

  • Program_Plan_Of_Care_raw Goals.Interventions.Engagement

  • Required: NO

  • Type: STRUCT

  • Description: General engagement details related to goals and interventions.

Emmi Engagement Attributes

  • Program_Plan_Of_Care_raw Goals.Interventions.Engagement.Emmi

  • Required: NO

  • Type: STRUCT

  • Description: Specific engagement details related to the Emmi program.

  • Program_Plan_Of_Care_raw Goals.Interventions.Engagement.Emmi.Status

  • Required: NO

  • Type: STRING

  • Description: Current status of the engagement within the Emmi program.

  • Program_Plan_Of_Care_raw Goals.Interventions.Engagement.Emmi.Status_Description

  • Required: NO

  • Type: STRING

  • Description: Detailed description of the current status within the Emmi program.

Member Engagement

  • Program_Plan_Of_Care_raw Goals.Engagement

  • Required: NO

  • Type: STRUCT

  • Description: Represents engagement details related to a specific goal for a member.

Engagement Attributes

  • Program_Plan_Of_Care_raw Goals.Engagement.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for the engagement record.

  • Program_Plan_Of_Care_raw Goals.Engagement.Status

  • Required: YES

  • Type: STRING

  • Description: The current status of the engagement, indicating its progress.

  • Program_Plan_Of_Care_raw Goals.Engagement.Status_Description

  • Required: YES

  • Type: STRING

  • Description: A description providing more context on the engagement status.

  • Program_Plan_Of_Care_raw Goals.Engagement.Initiated_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp when the engagement was initiated or started.

  • Program_Plan_Of_Care_raw Goals.Engagement.Completed_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp when the engagement was completed.

  • Program_Plan_Of_Care_raw Goals.Engagement.Last_Activity_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp of the last recorded activity related to the engagement.

  • Program_Plan_Of_Care_raw Goals.Engagement.Type

  • Required: YES

  • Type: STRING

  • Description: The type of engagement, categorizing the nature of the activity or interaction.

  • Program_Plan_Of_Care_raw Goals.Engagement.Type_Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the engagement type.

  • Program_Plan_Of_Care_raw Goals.Engagement.Code

  • Required: YES

  • Type: STRING

  • Description: A code representing the specific type of engagement.

  • Program_Plan_Of_Care_raw Goals.Engagement.Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the engagement and its purpose or focus.

  • Program_Plan_Of_Care_raw Goals.Engagement.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp when the engagement record was created.

  • Program_Plan_Of_Care_raw Goals.Engagement.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp when the engagement record was last updated or modified.

Emmi

  • Program_Plan_Of_Care_raw Goals.Emmi

  • Required: NO

  • Type: STRUCT

  • Description: Contains information related to Emmi (a specific engagement program).

Program Dataset Specification

Program_Plan_Of_Care_raw Goals

Emmi

  • Member_Email_Address

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The email address of the member associated with the Emmi engagement.

  • Access_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code allowing the member to access the Emmi communication or content.

  • Access_URL

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A URL link that directs the member to the Emmi content or interaction.

  • Target_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The target date for completing the engagement or action related to Emmi.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the Emmi engagement record was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the Emmi engagement record was last updated.

Notes

  • Notes

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Free-text field that includes any notes related to the goal or engagement process.

  • Program_Plan_Of_Care_Goal_Intervention_Engagement_Emmi_Note_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each note related to program plan of care goal intervention engagement.

  • Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text content of the note.

  • Entry_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was entered.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Barriers

  • Barriers

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: List of barriers associated with the program plan of care goal.

  • Program_Plan_Of_Care_Goal_Barrier_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each barrier entry within a program plan of care goal. See Dictionary Barrier table in the Dictionary Dataset Specification.

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the barrier.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the barrier. See Dictionary Barrier table in the Dictionary Dataset Specification.

  • Other_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description if the barrier is not covered by the predefined codes.

  • Identification_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the barrier was identified.

  • Resolution_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the barrier was resolved.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the barrier entry was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification time of the barrier entry.

Program_Plan_Of_Care_raw Metadata

  • 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: Unique identifier for the user who performed the transaction related to the plan of care.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of record or transaction related to the plan of care.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant information associated with the plan of care.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Active version of the plan of care.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the plan of care.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the plan of care.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system providing data for the plan of care.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the data was sourced for the plan of care.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file containing data for the plan of care.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Schema version of the dataset.

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition information associated with the member.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the record is deleted or not.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the record is updated or not.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Questionnaire_Program_Question_Response_Comparison

  • Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the enrollment program associated with the question response comparison.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the program associated with the question response comparison. See Dictionary Program table in the Dictionary Dataset Specification.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the question response comparison.

  • Enrollment_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Program name or code for the enrollment associated with the question response comparison.

  • Enrollment_Program_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the program for the enrollment associated with the question response comparison.

  • Enrollment_Product

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Product name or code for the enrollment associated with the question response comparison. See Dictionary Product table in the Dictionary Dataset Specification.

  • Enrollment_Product_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the product for the enrollment associated with the question response comparison. See Dictionary Product table in the Dictionary Dataset Specification.

  • Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the question associated with the response comparison.

Program Dataset Specification

Questionnaire Program Question Response Comparison

Program Enrollment Start Date

  • Column Name: Program_Enrollment_Start_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Start date of the enrollment program associated with the question response comparison.

Program Close Date

  • Column Name: Program_Close_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Close date of the enrollment program associated with the question response comparison.

Program Close Reason

  • Column Name: Program_Close_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for closing the enrollment program associated with the question response comparison. See Dictionary Program Close Reason table in the Dictionary Dataset Specification.

Class

  • Column Name: Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Class of the question associated with the response comparison.

Class Description

  • Column Name: Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the class of the question associated with the response comparison.

Full Question Clinical

  • Column Name: Full_Question_Clinical

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full clinical description of the question associated with the response comparison.

Short Question

  • Column Name: Short_Question

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Short description or abbreviation of the question associated with the response comparison.

Question Report Title

  • Column Name: Question_Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title of the report containing the question associated with the response comparison.

Question Code

  • Column Name: Question_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the question associated with the response comparison.

Question Response Type

  • Column Name: Question_Response_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of response expected for the question associated with the response comparison.

Question Display Type

  • Column Name: Question_Display_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Display type of the question associated with the response comparison.

Question Response Type Description

  • Column Name: Question_Response_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the response type expected for the question associated with the response comparison.

Question Response Value Type

  • Column Name: Question_Response_Value_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Value type of the response for the question associated with the response comparison.

Question Response Value Type Description

  • Column Name: Question_Response_Value_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the value type of the response for the question associated with the response comparison.

First Response Timestamp

  • Column Name: First_Response_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the first response for the question associated with the response comparison.

First Response Value Text

  • Column Name: First_Response_Value_Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text value of the first response for the question associated with the response comparison.

First Response Value Date

  • Column Name: First_Response_Value_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date value of the first response for the question associated with the response comparison.

First Response Value Number

  • Column Name: First_Response_Value_Number

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Numeric value of the first response for the question associated with the response comparison.

Latest Response Value Text

  • Column Name: Latest_Response_Value_Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text value of the latest response for the question associated with the response comparison.

Latest Response Value Date

  • Column Name: Latest_Response_Value_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date value of the latest response for the question associated with the response comparison.

Latest Response Value Number

  • Column Name: Latest_Response_Value_Number

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Numeric value of the latest response for the question associated with the response comparison.

Latest Response Timestamp

  • Column Name: Latest_Response_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the latest response for the question associated with the response comparison.

Days Count Between First and Last Responses

  • Column Name: Days_Count_Between_First_Last_Responses

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days between the first and latest responses for the question associated with the response comparison.

One Response Indicator

  • Column Name: One_Response_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying if there is only one response for the question associated with the response comparison.

Program Provider Roles

Program Provider Roles Key

  • Column Name: Program_Provider_Roles_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the program provider roles entry.

Program Provider Key

  • Column Name: Program_Provider_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the program provider associated with the roles.

Program ID

  • Column Name: Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the program associated with the provider roles. See Dictionary Program table in the Dictionary Dataset Specification.

Provider ID

  • Column Name: Provider_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the provider associated with the roles.

Provider NPI

  • Column Name: Provider_NPI

  • Is Nullable: YES

  • Data Type: STRING

  • Description: National Provider Identifier (NPI) of the provider associated with the roles.

Primary

  • Column Name: Primary

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying if the role is primary for the provider.

Created Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the provider roles entry was created.

Last Modified Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the provider roles entry was last modified.

Role Code

  • Column Name: Role_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the role of the provider within the program. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

Role Description

  • Column Name: Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the role of the provider within the program. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

Role Effective Date

  • Column Name: Role_Effective_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Effective date of the provider's role within the program.

Role Termination Date

  • Column Name: Role_Termination_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Termination date of the provider's role within the program, if applicable.

Role Created Timestamp

  • Column Name: Role_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the provider's role entry was created.

Role Last Modified Timestamp

  • Column Name: Role_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the provider's role entry was last modified.

Program Dataset Specification

Screening Ownership Details

First Screening Ownership

  • First_Screening_Owner_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the first screening owner.

  • First_Screening_Owner_Name:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the first screening owner.

  • First_Screening_Owner_Type:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the first screening owner (calculated based on Program LOG data within each enrolled program ID).

Screening Ownership

  • Screening_Owner_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the screening owner.

  • Screening_Owner_Name:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the screening owner.

  • Screening_Owner_Type:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the screening owner (calculated based on Program LOG data within each enrolled program ID).

Previous Screening Ownership

  • Previous_Screening_Owner_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the previous screening owner.

  • Previous_Screening_Owner_Name:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the previous screening owner.

  • Previous_Screening_Owner_Type:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the previous screening owner (calculated based on Program LOG data within each enrolled program ID).

Historical Record Indicators

  • First:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Set to true for the first historical record within a program.

  • Latest:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Set to true for the latest historical record within a program.

Additional Details

  • Effective_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the effectiveness of the screening ownership.

  • Transaction_User_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user associated with the transaction.

  • Transaction_User_Name:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user associated with the transaction.

  • Deleted_Indicator:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator used to filter deleted records.

Screening Details

Screening Entry

  • Screening_Key:

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the screening entry.

Screening Reopen Details

  • Screening_Reopen_Date:

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the screening was reopened.

  • Screening_Reopen_Reason:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for reopening the screening.

  • Screening_Reopen_Reason_Description:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the reason for reopening the screening.

Social Problem Codes

Social Problem Indicators

  • Social_Problem_Code_1:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether there is a value for Social_Problems.Code for the first social problem.

  • Social_Problem_Code_2:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether there is a value for Social_Problems.Code for the second social problem.

  • Social_Problem_Code_3:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether there is a value for Social_Problems.Code for the third social problem.

  • Social_Problem_Code_4:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether there is a value for Social_Problems.Code for the fourth social problem.

  • Social_Problem_Code_5:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether there is a value for Social_Problems.Code for the fifth social problem.

  • Social_Problem_Code_6:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether there is a value for Social_Problems.Code for the sixth social problem.

  • Social_Problem_Code_7:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether there is a value for Social_Problems.Code for the seventh social problem.

  • Social_Problem_Code_8:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether there is a value for Social_Problems.Code for the eighth social problem.

  • Social_Problem_Code_9:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether there is a value for Social_Problems.Code for the ninth social problem.

Social Problems Description

  • Social_Problems_Selected:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Comma-separated descriptions for all valued Social_Problems.Description based on Social_Problems.Key.

Program Workflow Steps

Step Details

  • Program_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the program associated with the steps.

  • Screening_Key:

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key or identifier for the screening process linked to the program.

  • Step:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for a specific step within the program's workflow.

  • Step_Description:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the step within the program's workflow.

State Details

  • State:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current state or status of the step (e.g., active, completed).

  • State_Description:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the state or status of the step.

  • State_Last_Modified_User_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the state of the step.

  • State_Last_Modified_User_Name:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the state of the step.

  • State_Created_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the state of the step was initially created.

  • State_Last_Modified_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the state of the step was last updated.

Program Log Details

Member and Screening Request

  • Member_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member associated with the program log entry.

  • Screening_Request_Key:

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the screening request.

  • Screening_Request_Date:

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the screening request was made.

Behavioral Health Indicator

  • Behavioral_Health:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for whether the screening is related to behavioral health.

Program Designation

  • Program_Designation:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier representing the designation of the program.

  • Program_Designation_Description:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the program designation.

Program Type

  • Program_Type:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier representing the type of program.

  • Program_Type_Description:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the program type.

External Program Details

  • External_Program_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An external identifier for the program, possibly used by other systems or vendors.

  • External_Program_Vendor_Code:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code identifying the external vendor associated with the program, if applicable.

Current Step and State

  • Current_Step:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier or code representing the current step in the program process.

  • Current_Step_Description:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the current step in the program process.

  • Current_State:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier representing the current state of the program.

  • Current_State_Description:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the current state of the program.

Digital Pause Details

  • Digital_Pause_Indicator:

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: An indicator showing whether the digital aspects of the program are currently paused.

  • Digital_Pause_By_Type:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier indicating the type of entity that initiated the digital pause.

  • Digital_Pause_By_Type_Description:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the type of entity that initiated the digital pause.

  • Digital_Pause_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the digital pause was initiated.

Program Dataset Specification

Screening Request Details

Source

  • Source: YES, STRING\ Source of the screening request. See Dictionary Program Source table in the Dictionary Dataset Specification.

  • Source_Description: YES, STRING\ Description of the source of the screening request. See Dictionary Program Source table in the Dictionary Dataset Specification.

Screening Program

  • Screening_Program: YES, STRING\ Program associated with the screening.

  • Screening_Program_Description: YES, STRING\ Description of the screening program.

Screening Severity

  • Screening_Severity: YES, STRING\ Severity level of the screening. See Dictionary Program Severity table in the Dictionary Dataset Specification.

  • Screening_Severity_Description: YES, STRING\ Description of the severity level of the screening. See Dictionary Program Severity table in the Dictionary Dataset Specification.

Screening Product

  • Screening_Product: YES, STRING\ Product associated with the screening. See Dictionary Product table in the Dictionary Dataset Specification.

  • Screening_Product_Description: YES, STRING\ Description of the screening product. See Dictionary Product table in the Dictionary Dataset Specification.

Timestamps

  • Screening_Request_Created_Timestamp: YES, TIMESTAMP\ Timestamp indicating when the screening request was created.

  • Screening_Request_Last_Modified_Timestamp: YES, TIMESTAMP\ Timestamp indicating when the screening request was last modified.

Providers

Providers Details

  • Providers: NO, ARRAY\ Providers involved in the screening.

Provider Attributes

  • Providers.Program_Provider_Key: YES, INT64\ The key associated with the provider within the program.

  • Providers.Program_ID: YES, STRING\ The identifier of the program to which the provider role belongs. See Dictionary Program table in the Dictionary Dataset Specification.

  • Providers.Provider_Key: YES, INT64\ The key or identifier associated with the provider in the system.

  • Providers.Provider_ID: YES, STRING\ The identification number or code assigned to the provider.

  • Providers.Provider_NPI: YES, STRING\ The National Provider Identifier (NPI) of the provider.

  • Providers.Primary: YES, BOOL\ Indicates whether the provider holds a primary role within the program.

  • Providers.Created_Timestamp: YES, TIMESTAMP\ The timestamp indicating when the provider role entry was initially created.

  • Providers.Last_Modified_Timestamp: YES, TIMESTAMP\ The timestamp indicating the most recent modification made to the provider role entry.

Provider Roles

  • Providers.Roles: NO, ARRAY\ Providers' roles.

Role Attributes

  • Providers.Roles.Program_Provider_Role_Key: YES, INT64\ The unique key or identifier for the provider role entry in the program's custom provider roles table.

  • Providers.Roles.Code: YES, STRING\ The code associated with the provider role. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

  • Providers.Roles.Description: YES, STRING\ The description or name of the provider role, providing details about the role's responsibilities or functions. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

  • Providers.Roles.Role_Effective_Date: YES, DATE\ The date when the provider assumed or started the role within the program.

  • Providers.Roles.Role_Termination_Date: YES, DATE\ The date when the provider's role within the program was terminated or ended.

  • Providers.Roles.Role_Created_Timestamp: YES, TIMESTAMP\ The timestamp indicating when the provider role entry was initially created or established.

  • Providers.Roles.Role_Last_Modified_Timestamp: YES, TIMESTAMP\ The timestamp indicating the most recent modification made to the provider role entry, including changes to role details such as effective or termination dates.

Screening Details

Screening Attributes

  • Screening_Key: YES, INT64\ Key identifier for the screening.

  • Screening_Date: YES, DATE\ Date of the screening.

  • Close_Date: YES, DATE\ Date when the screening was closed.

  • Screening_Status: YES, STRING\ Status of the screening. See Dictionary Program Screening Status table in the Dictionary Dataset Specification.

  • Not_Enrolled_Reason: YES, STRING\ Reason for not enrolling the member in the program. See Dictionary Not Enrolled Reason table in the Dictionary Dataset Specification.

  • Not_Enrolled_Reason_Description: YES, STRING\ Description of the reason for not enrolling the member in the program. See Dictionary Not Enrolled Reason table in the Dictionary Dataset Specification.

  • Program_ID: YES, STRING\ Unique identifier for the program associated with the screening. See Dictionary Program table in the Dictionary Dataset Specification.

  • Close_Reason: YES, STRING\ Reason for closing the screening. See Dictionary Program Close Reason table in the Dictionary Dataset Specification.

  • Close_Reason_Description: YES, STRING\ Description of the reason for closing the screening. See Dictionary Program Close Reason table in the Dictionary Dataset Specification.

Screening Ownership

  • Screening_Owner_User_ID: YES, STRING\ User ID of the screening owner.

  • Screening_Owner_Department_ID: YES, STRING\ Department ID of the screening owner.

Screening Timestamps

  • Screening_Created_Timestamp: YES, TIMESTAMP\ Timestamp indicating when the screening was created.

  • Screening_Last_Modified_Timestamp: YES, TIMESTAMP\ Timestamp indicating when the screening was last modified.

Screener Details

  • Screener_User_ID: YES, STRING\ User ID of the screener.

Screening Reopen Details

  • Screening_Reopen_Date: YES, DATE\ Date when the screening was reopened.

  • Screening_Reopen_Reason: YES, STRING\ Reason for reopening the screening. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

  • Screening_Reopen_Reason_Description: YES, STRING\ Description of the reason for reopening the screening. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

Source System Details

Source System Attributes

  • Source_System_ID: YES, STRING\ Identifier for the source system. See Dictionary Source System table in the Dictionary Dataset Specification.

  • Source_System_Description: YES, STRING\ Description of the source system. See Dictionary Source System table in the Dictionary Dataset Specification.

  • Source_System_Record_ID: YES, STRING\ Identifier for the source system record.

Program Enrollment Details

Enrollment Attributes

  • Program_Enrollment_Key: YES, INT64\ Unique identifier for the program enrollment.

  • Enrollment_Program: YES, STRING\ Program associated with the enrollment.

  • Enrollment_Program_Description: YES, STRING\ Description of the enrollment program.

  • Enrollment_Severity: YES, STRING\ Severity level of the enrollment.

Program Dataset Specification

Enrollment Details

Severity Level

  • Enrollment_Severity_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the severity level of the enrollment.

  • Reference: See Dictionary Program Severity table in the Dictionary Dataset Specification.

Product

  • Enrollment_Product

  • Type: STRING

  • Required: YES

  • Description: Product associated with the enrollment.

  • Reference: See Dictionary Product table in the Dictionary Dataset Specification.

  • Enrollment_Product_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the enrollment product.

  • Reference: See Dictionary Product table in the Dictionary Dataset Specification.

Dates

  • Enrollment_Date

  • Type: DATE

  • Required: YES

  • Description: Date of the enrollment.

  • Enrollment_Start_Date

  • Type: DATE

  • Required: YES

  • Description: Start date of the enrollment.

  • Enrollment_Reopen_Date

  • Type: DATE

  • Required: YES

  • Description: Date when the enrollment was reopened.

Reopen Reason

  • Enrollment_Reopen_Reason

  • Type: STRING

  • Required: YES

  • Description: Reason for reopening the enrollment.

  • Reference: See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

  • Enrollment_Reopen_Reason_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the reason for reopening the enrollment.

  • Reference: See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

Ownership

  • Enroller_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the enroller.

  • Enrollment_Owner_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the enrollment owner.

  • Enrollment_Owner_Department_ID

  • Type: STRING

  • Required: YES

  • Description: Department ID of the enrollment owner.

  • Enrollment_Owner_Department_Name

  • Type: STRING

  • Required: YES

  • Description: Department name of the enrollment owner.

Timestamps

  • Enrollment_Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the enrollment was created.

  • Enrollment_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Diagnoses

Diagnoses Details

  • Diagnoses.Program_Diagnosis_Key

  • Type: INT64

  • Required: YES

  • Description: The unique key or identifier for the diagnosis entry in the program's diagnoses table.

  • Diagnoses.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating when the diagnosis entry was initially created.

  • Diagnoses.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating the most recent modification made to the diagnosis entry.

  • Diagnoses.Primary

  • Type: BOOL

  • Required: YES

  • Description: Indicates whether the diagnosis is the primary diagnosis for the program.

Diagnosis Code and Description

  • Diagnoses.Code

  • Type: STRING

  • Required: YES

  • Description: The code representing the diagnosis.

  • Diagnoses.Description

  • Type: STRING

  • Required: YES

  • Description: The description or name of the diagnosis, providing details about the medical condition or ailment.

Coding Scheme

  • Diagnoses.Coding_Scheme

  • Type: STRING

  • Required: YES

  • Description: The coding scheme used for the diagnosis code.

  • Diagnoses.Coding_Scheme_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the coding scheme used for the diagnosis code.

Condition Category

  • Diagnoses.Condition_Category

  • Type: STRING

  • Required: YES

  • Description: The category or classification of the medical condition associated with the diagnosis.

  • Diagnoses.Condition_Category_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the category or classification of the medical condition associated with the diagnosis.

Sequence and Axis

  • Diagnoses.Sequence

  • Type: INT64

  • Required: YES

  • Description: The sequence number indicating the order of importance or relevance of the diagnosis within the program.

  • Diagnoses.Axis

  • Type: STRING

  • Required: YES

  • Description: The axis associated with the diagnosis code.

  • Reference: See Dictionary Axis table in the Dictionary Dataset Specification.

  • Diagnoses.Axis_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the axis associated with the diagnosis code.

  • Reference: See Dictionary Axis table in the Dictionary Dataset Specification.

Social Problems

Social Problems Details

  • Social_Problems.Program_Social_Problem_Key

  • Type: INT64

  • Required: YES

  • Description: Unique key associated with the social problem entry.

  • Reference: See Dictionary Axis Social Problem table in the Dictionary Dataset Specification.

  • Social_Problems.Code

  • Type: STRING

  • Required: YES

  • Description: Code representing the social problem.

  • Social_Problems.Description

  • Type: STRING

  • Required: YES

  • Description: Description of the social problem.

  • Reference: See Dictionary Axis Social Problem table in the Dictionary Dataset Specification.

Timestamps

  • Social_Problems.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the social problem entry was created.

  • Social_Problems.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the social problem entry was last modified.

Global Assessment of Functioning

Assessment Details

  • Program_Global_Assessment_of_Functioning_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for each record of global assessment of functioning within the program.

Score

  • Program_Global_Assessment_of_Functioning_Key.Score

  • Type: INT64

  • Required: YES

  • Description: The score assigned for the global assessment of functioning.

  • Program_Global_Assessment_of_Functioning_Key.Score_Entry_Date

  • Type: DATE

  • Required: YES

  • Description: The date when the score for the global assessment of functioning was entered.

Timestamps

  • Program_Global_Assessment_of_Functioning_Key.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The date and time when the assessment record was created.

  • Program_Global_Assessment_of_Functioning_Key.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The date and time when the assessment record was last modified.

Custom Fields

Custom Field Details

  • Custom_Fields.Program_Custom_Field_Key

  • Type: INT64

  • Required: YES

  • Description: The unique key or identifier for the custom field entry in the program's custom fields table.

  • Custom_Fields.ID

  • Type: STRING

  • Required: YES

  • Description: The identification number or code assigned to the custom field.

  • Custom_Fields.Title

  • Type: STRING

  • Required: YES

  • Description: The title or name of the custom field, providing a brief description of its purpose or content.

  • Custom_Fields.Use

  • Type: STRING

  • Required: YES

  • Description: Indicates how the custom field is utilized within the system or application.

Timestamps

  • Custom_Fields.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating when the custom field entry was initially created.

  • Custom_Fields.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating the most recent modification made to the custom field entry.

Values

  • Custom_Fields.Values.Value

  • Type: STRING

  • Required: YES

  • Description: The value associated with the custom field.

  • Custom_Fields.Values.Value_Description

  • Type: STRING

  • Required: YES

  • Description: A description or explanation providing additional context for the value of the custom field, especially if the value is not self-explanatory.

  • Custom_Fields.Values.Select_Key

  • Type: INT64

  • Required: YES

  • Description: The key associated with the selection made in the custom field, if applicable.

Program Dataset Specification

Custom Fields

Values

  • Select_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the selection in the custom field was initially created.

  • Select_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the selection in the custom field.

Notes

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Notes related to the program.

Fields

  • Program_Note_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each program note entry.

  • Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content of the note.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the type of note. See Dictionary Note Type table in the Dictionary Dataset Specification.

  • Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the note type. See Dictionary Note Type table in the Dictionary Dataset Specification.

  • Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

  • Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the author who created the note.

  • Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the note is voided or not.

  • Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was voided.

  • Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding the note. See Dictionary Note Void Reason table in the Dictionary Dataset Specification.

  • Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the reason for voiding the note. See Dictionary Note Void Reason table in the Dictionary Dataset Specification.

  • Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who voided the note.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification time of the note.

Visibility Level

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Level of visibility for the program.

Record Metadata

Fields

  • 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.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of action or event.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the record.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Active version of the record.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the record.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the record.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the source system.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for whether the record is deleted.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema.

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition information for the member.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed on the record.

  • Last_Closed_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last closed or completed the program.

Steps

Fields

  • Steps

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: A collection of steps associated with the program.

Step Details

  • Step

  • Is Nullable: NO

  • Data Type: STRING

  • Description: An identifier or code for a specific step in the program.

  • Step_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: A detailed description of the step.

  • State

  • Is Nullable: NO

  • Data Type: STRING

  • Description: A code or identifier representing the current state of the step.

  • State_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: A detailed description of the current state of the step.

  • State_Last_Modified_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The user ID of the person who last modified the state of the step.

  • State_Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: The timestamp when the state of the step was initially created.

  • State_Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: The timestamp when the state of the step was last modified.

Screening and Enrollment

Fields

  • Digital

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the screening or enrollment process is digital (e.g., Yes/No).

  • Enrollment_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of the enrollment (e.g., Active, Inactive, Pending).

  • Enrollment_Reopen_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who reopened the enrollment.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Program Plan of Care Log

Fields

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier assigned to the member within the system, crucial for associating the care plan with the correct individual.

  • Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Represents the specific enrollment instance of the member in the program, vital for tracking their participation and progress.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the specific program under which the plan of care is created, linking the care activities to the broader service or treatment plan. See Dictionary Program table in the Dictionary Dataset Specification.

  • Problem_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key identifying the specific health or care issue addressed within the plan, essential for targeted care management.

  • Problem

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A concise label or code for the health issue being addressed, aiding in categorization and analysis of care plans. See Dictionary Problem table in the Dictionary Dataset Specification.

  • Problem_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed explanation of the health issue, providing context and clarity for care providers and stakeholders. See Dictionary Problem table in the Dictionary Dataset Specification.

  • Problem_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of the health issue, indicating progress, resolution, or ongoing management needs. See Dictionary Problem Status table in the Dictionary Dataset Specification.

  • Problem_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Expounds on the status, offering detailed insight into the patient's condition or progress in the care plan. See Dictionary Problem Status table in the Dictionary Dataset Specification.

  • Outcome_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code that represents the expected or achieved outcome for the care plan, helping in evaluating the effectiveness of care.

  • Problem_Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the result or impact of the care interventions on the member’s health issue. See Dictionary Problem Outcome table in the Dictionary Dataset Specification.

  • Problem_Outcome_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Offers detailed narrative on the outcomes, providing a qualitative measure of the care plan's effectiveness.

Program Dataset Specification

Program_Plan_Of_Care_Log

Problem_Outcome_Category

  • Required: YES

  • Type: STRING

  • Description: Categorizes the outcome to facilitate analysis and reporting on the care provided.\ See Dictionary Problem Outcome Category table in the Dictionary Dataset Specification.

Problem_Outcome_Category_Description

  • Required: YES

  • Type: STRING

  • Description: Provides a comprehensive explanation of the category, enriching the understanding of care results.\ See Dictionary Problem Outcome Category table in the Dictionary Dataset Specification.

Problem_Other_Description

  • Required: YES

  • Type: STRING

  • Description: Allows for additional notes or details about the problem that may not fit within standard fields, ensuring thorough documentation.

Start_Date

  • Required: YES

  • Type: DATE

  • Description: The date when the care plan or related intervention began, marking the timeline of care delivery.

Actual_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: The date when the care activities were actually completed, critical for tracking the actual duration of care.

Target_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: The planned or expected date for completing the care activities, important for monitoring adherence to care timelines.

Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date and time when the care log record was initially created, important for data management and audit trails.

Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Indicates the most recent update to the care log record, essential for tracking changes and current status.

Notes

  • Required: NO

  • Type: ARRAY

  • Description: Any additional notes or comments related to the plan of care.

Notes.Note_Key

  • Required: YES

  • Type: INT64

  • Description: The unique identifier/key for the cost-saving note.

Notes.Text

  • Required: YES

  • Type: STRING

  • Description: The content or text of the note, providing additional information or comments related to the cost-saving details.

Notes.Author_User_ID

  • Required: YES

  • Type: STRING

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

Notes.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the note was initially created.

Notes.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the note.

Goals

  • Required: NO

  • Type: ARRAY

  • Description: Goals associated with the problem in the plan of care.

Goals.Program_Plan_Of_Care_Goal_Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for each plan of care goal.\ See Dictionary Goal table in the Dictionary Dataset Specification.

Goals.Code

  • Required: YES

  • Type: STRING

  • Description: Code representing the goal.

Goals.Description

  • Required: YES

  • Type: STRING

  • Description: Description of the goal.\ See Dictionary Goal table in the Dictionary Dataset Specification.

Goals.Other_Description

  • Required: YES

  • Type: STRING

  • Description: Additional description for the goal if available.

Goals.Type

  • Required: YES

  • Type: STRING

  • Description: Type of the goal.\ See Dictionary Goal Type table in the Dictionary Dataset Specification.

Goals.Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the goal type.\ See Dictionary Goal Type table in the Dictionary Dataset Specification.

Goals.Start_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the goal was initiated.

Goals.Actual_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: Actual completion date of the goal.

Goals.Target_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: Target completion date set for the goal.

Goals.Outcome

  • Required: YES

  • Type: STRING

  • Description: Outcome of the goal.\ See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

Goals.Outcome_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the outcome.\ See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

Goals.Outcome_Category

  • Required: YES

  • Type: STRING

  • Description: Category of the outcome.\ See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

Goals.Outcome_Category_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the outcome category.\ See Dictionary Goal Outcome Category table in the Dictionary Dataset Specification.

Goals.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the goal was created.

Goals.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Goals.Focuses

  • Required: NO

  • Type: ARRAY

  • Description: Goal focuses.

Goals.Focuses.Program_Plan_Of_Care_Goal_Focus_Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for each program plan of care goal focus.\ See Dictionary Goal Focus table in the Dictionary Dataset Specification.

Goals.Focuses.Code

  • Required: YES

  • Type: STRING

  • Description: Code representing the program plan of care goal focus.

Goals.Focuses.Description

  • Required: YES

  • Type: STRING

  • Description: Description of the program plan of care goal focus.\ See Dictionary Goal Focus table in the Dictionary Dataset Specification.

Goals.Focuses.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the program plan of care goal focus was created.

Goals.Focuses.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the program plan of care goal focus was last modified.

Goals.Interventions

  • Required: NO

  • Type: ARRAY

  • Description: Interventions related to the goals.

Goals.Interventions.Key

  • Required: YES

  • Type: INT64

  • Description: Unique key of the intervention.

Goals.Interventions.Code

  • Required: YES

  • Type: STRING

  • Description: Code representing the goal.

Goals.Interventions.Description

  • Required: YES

  • Type: STRING

  • Description: Description of the goal.\ See Dictionary Goal table in the Dictionary Dataset Specification.

Goals.Interventions.Other_Description

  • Required: YES

  • Type: STRING

  • Description: Additional description for the goal if available.

Goals.Interventions.Start_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the goal was initiated.

Goals.Interventions.Actual_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: Actual completion date of the goal.

Goals.Interventions.Target_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: Target completion date set for the goal.

Goals.Interventions.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the goal was created.

Goals.Interventions.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Goals.Engagement

  • Required: NO

  • Type: STRUCT

  • Description: Represents engagement details related to a specific goal for a member.

Goals.Engagement.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for the engagement record.

Goals.Engagement.Status

  • Required: YES

  • Type: STRING

  • Description: The current status of the engagement, indicating its progress.

Goals.Engagement.Status_Description

  • Required: YES

  • Type: STRING

  • Description: A description providing more context on the engagement status.

Program Dataset Specification

Goals

Engagement

  • Goals.Engagement.Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the engagement was initiated or started.

  • Goals.Engagement.Completed_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the engagement was completed.

  • Goals.Engagement.Last_Activity_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the last recorded activity related to the engagement.

  • Goals.Engagement.Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of engagement, categorizing the nature of the activity or interaction.

  • Goals.Engagement.Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the engagement type.

  • Goals.Engagement.Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing the specific type of engagement.

  • Goals.Engagement.Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the engagement and its purpose or focus.

  • Goals.Engagement.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the engagement record was created.

  • Goals.Engagement.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the engagement record was last updated or modified.

Emmi

  • Goals.Emmi

  • Is Nullable: NO

  • Data Type: STRUCT

  • Description: Contains information related to Emmi engagement.

  • Goals.Emmi.Member_Email_Address

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The email address of the member associated with the Emmi engagement.

  • Goals.Emmi.Access_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code allowing the member to access the Emmi communication or content.

  • Goals.Emmi.Access_URL

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A URL link that directs the member to the Emmi content or interaction.

  • Goals.Emmi.Target_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The target date for completing the engagement or action related to Emmi.

  • Goals.Emmi.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the Emmi engagement record was created.

  • Goals.Emmi.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the Emmi engagement record was last updated.

Notes

  • Goals.Notes

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Free-text field that includes any notes related to the goal or engagement process.

  • Goals.Notes.Program_Plan_Of_Care_Goal_Intervention_Engagement_Emmi_Note_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each note related to program plan of care goal intervention engagement.

  • Goals.Notes.Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text content of the note.

  • Goals.Notes.Entry_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was entered.

  • Goals.Notes.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

  • Goals.Notes.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Barriers

  • Goals.Barriers

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Contains information about barriers related to program plan of care goals.

  • Goals.Barriers.Program_Plan_Of_Care_Goal_Barrier_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each barrier entry within a program plan of care goal. See Dictionary Barrier table in the Dictionary Dataset Specification.

  • Goals.Barriers.Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the barrier.

  • Goals.Barriers.Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the barrier. See Dictionary Barrier table in the Dictionary Dataset Specification.

  • Goals.Barriers.Other_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description if the barrier is not covered by the predefined codes.

  • Goals.Barriers.Identification_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the barrier was identified.

  • Goals.Barriers.Resolution_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the barrier was resolved.

  • Goals.Barriers.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the barrier entry was created.

  • Goals.Barriers.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification time of the barrier entry.

Program Plan of Care Log

  • Program_Plan_Of_Care_log.Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The latest timestamp when any part of the log record was updated, ensuring accurate and current data tracking.

  • Program_Plan_Of_Care_log.Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who performed the latest transaction or update on the care log, ensuring accountability and traceability.

  • Program_Plan_Of_Care_log.Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type or category of the log entry, useful for organizing and filtering care log records.

  • Program_Plan_Of_Care_log.Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the specific tenant or administrative domain within which the care log is managed, crucial for data segregation and management.

  • Program_Plan_Of_Care_log.Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the log record is the current active version, essential for maintaining data integrity and relevance.

  • Program_Plan_Of_Care_log.Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the log entry, often used for reporting and tracking purposes.

  • Program_Plan_Of_Care_log.Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A numerical sequence that orders the log entries, useful for chronological sorting and analysis.

  • Program_Plan_Of_Care_log.Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the system from which the log data originates, key for integration and data sourcing.

  • Program_Plan_Of_Care_log.Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from the source system when the log entry was generated, aiding in synchronization and timeline analysis.

  • Program_Plan_Of_Care_log.Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the file from the source system, useful for data tracking and management.

  • Program_Plan_Of_Care_log.Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: The version of the data schema to which the log record conforms, important for compatibility and data structure management.

  • Program_Plan_Of_Care_log.Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A partition key used for distributing and managing the dataset efficiently, especially in large-scale data environments.

  • Program_Plan_Of_Care_log.Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean flag that indicates whether the log record has been marked for deletion, critical for data cleanliness and accuracy.

  • Program_Plan_Of_Care_log._updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A system-generated timestamp or flag indicating when the record was last updated, ensuring data timeliness.

  • Program_Plan_Of_Care_log.Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the specific action taken or recorded in the log, providing clarity on the nature of the log entry.

  • Program_Plan_Of_Care_log.Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Table Name

Columns

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the program.

  • Screening_Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key associated with the screening request.

Program Dataset Specification

Screening Request

  • Screening_Request_Date

  • Type: DATE

  • Description: Date of the screening request.

  • Behavioral_Health

  • Type: BOOL

  • Description: Indicator specifying if the program is related to behavioral health.

Program Designation

  • Program_Designation

  • Type: STRING

  • Description: A code or identifier representing the designation of the program.

  • Program_Designation_Description

  • Type: STRING

  • Description: A detailed description of the program designation.

Program Type

  • Program_Type

  • Type: STRING

  • Description: A code or identifier representing the type of program.

  • Program_Type_Description

  • Type: STRING

  • Description: A detailed description of the program type.

External Program Information

  • External_Program_ID

  • Type: STRING

  • Description: An external identifier for the program, possibly used by other systems or vendors.

  • External_Program_Vendor_Code

  • Type: STRING

  • Description: A code identifying the external vendor associated with the program, if applicable.

Current Step and State

  • Current_Step

  • Type: STRING

  • Description: An identifier or code representing the current step in the program process.

  • Current_Step_Description

  • Type: STRING

  • Description: A detailed description of the current step in the program process.

  • Current_State

  • Type: STRING

  • Description: A code or identifier representing the current state of the program.

  • Current_State_Description

  • Type: STRING

  • Description: A detailed description of the current state of the program.

Digital Pause Information

  • Digital_Pause_Indicator

  • Type: BOOL

  • Description: An indicator showing whether the digital aspects of the program are currently paused.

  • Digital_Pause_By_Type

  • Type: STRING

  • Description: A code or identifier indicating the type of entity that initiated the digital pause.

  • Digital_Pause_By_Type_Description

  • Type: STRING

  • Description: A description of the type of entity that initiated the digital pause.

  • Digital_Pause_Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp when the digital pause was initiated.

Source Information

  • Source

  • Type: STRING

  • Description: Source of the program data. See Dictionary Program Source table in the Dictionary Dataset Specification.

  • Source_Description

  • Type: STRING

  • Description: Description of the data source. See Dictionary Program Source table in the Dictionary Dataset Specification.

Screening Program Details

  • Screening_Program

  • Type: STRING

  • Description: Program associated with the screening.

  • Screening_Program_Description

  • Type: STRING

  • Description: Description of the screening program.

  • Screening_Severity

  • Type: STRING

  • Description: Severity level of the screening. See Dictionary Program Severity table in the Dictionary Dataset Specification.

  • Screening_Severity_Description

  • Type: STRING

  • Description: Description of the screening severity. See Dictionary Program Severity table in the Dictionary Dataset Specification.

  • Screening_Product

  • Type: STRING

  • Description: Product associated with the screening. See Dictionary Product table in the Dictionary Dataset Specification.

  • Screening_Product_Description

  • Type: STRING

  • Description: Description of the screening product. See Dictionary Product table in the Dictionary Dataset Specification.

Screening Request Timestamps

  • Screening_Request_Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the screening request was created.

  • Screening_Request_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the screening request was last modified.

Providers

Providers Information

  • Providers.Program_Provider_Key

  • Type: INT64

  • Description: The key associated with the provider within the program.

  • Providers.Program_ID

  • Type: STRING

  • Description: The identifier of the program to which the provider role belongs. See Dictionary Program table in the Dictionary Dataset Specification.

  • Providers.Provider_Key

  • Type: INT64

  • Description: The key or identifier associated with the provider in the system.

  • Providers.Provider_ID

  • Type: STRING

  • Description: The identification number or code assigned to the provider.

  • Providers.Provider_NPI

  • Type: STRING

  • Description: The National Provider Identifier (NPI) of the provider.

  • Providers.Primary

  • Type: BOOL

  • Description: Indicates whether the provider holds a primary role within the program.

  • Providers.Created_Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the provider role entry was initially created.

  • Providers.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the provider role entry.

Providers Roles

  • Providers.Roles.Program_Provider_Role_Key

  • Type: INT64

  • Description: The unique key or identifier for the provider role entry in the program's custom provider roles table.

  • Providers.Roles.Code

  • Type: STRING

  • Description: The code associated with the provider role. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

  • Providers.Roles.Description

  • Type: STRING

  • Description: The description or name of the provider role, providing details about the role's responsibilities or functions. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

  • Providers.Roles.Role_Effective_Date

  • Type: DATE

  • Description: The date when the provider assumed or started the role within the program.

  • Providers.Roles.Role_Termination_Date

  • Type: DATE

  • Description: The date when the provider's role within the program was terminated or ended.

  • Providers.Roles.Role_Created_Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the provider role entry was initially created or established.

  • Providers.Roles.Role_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the provider role entry, including changes to role details such as effective or termination dates.

Screening Details

  • Screening_Key

  • Type: INT64

  • Description: Key associated with the screening.

  • Screening_Date

  • Type: DATE

  • Description: Date of the screening.

  • Close_Date

  • Type: DATE

  • Description: Date when the screening was closed.

  • Screening_Status

  • Type: STRING

  • Description: Status of the screening. See Dictionary Program Screening Status table in the Dictionary Dataset Specification.

Enrollment Details

  • Not_Enrolled_Reason

  • Type: STRING

  • Description: Reason for not enrolling in the program. See Dictionary Not Enrolled Reason table in the Dictionary Dataset Specification.

  • Not_Enrolled_Reason_Description

  • Type: STRING

  • Description: Description of the reason for not enrolling in the program. See Dictionary Not Enrolled Reason table in the Dictionary Dataset Specification.

Program Information

  • Program_ID

  • Type: STRING

  • Description: Unique identifier for the program. See Dictionary Program table in the Dictionary Dataset Specification.

  • Close_Reason

  • Type: STRING

  • Description: Reason for closing the program. See Dictionary Program Close Reason table in the Dictionary Dataset Specification.

  • Close_Reason_Description

  • Type: STRING

  • Description: Description of the reason for closing the program. See Dictionary Program Close Reason table in the Dictionary Dataset Specification.

Program Dataset Specification

Screening Information

Screening_Owner_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the owner of the screening.

Screening_Owner_Department_ID

  • Required: YES

  • Type: STRING

  • Description: Department ID of the owner of the screening.

Screening_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the screening was created.

Screening_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Screener_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the screener.

Screening_Reopen_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the screening was reopened.

Screening_Reopen_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for reopening the screening.

  • Reference: See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

Screening_Reopen_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the reason for reopening the screening.

  • Reference: See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

Source_System_ID

  • Required: YES

  • Type: STRING

  • Description: ID of the source system.

  • Reference: See Dictionary Source System table in the Dictionary Dataset Specification.

Source_System_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the source system.

  • Reference: See Dictionary Source System table in the Dictionary Dataset Specification.

Source_System_Record_ID

  • Required: YES

  • Type: STRING

  • Description: Record ID of the source system.

Enrollment Information

Program_Enrollment_Key

  • Required: YES

  • Type: INT64

  • Description: Key associated with the program enrollment.

Enrollment_Program

  • Required: YES

  • Type: STRING

  • Description: Program associated with the enrollment.

Enrollment_Program_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the enrollment program.

Enrollment_Severity

  • Required: YES

  • Type: STRING

  • Description: Severity level of the enrollment.

  • Reference: See Dictionary Program Severity table in the Dictionary Dataset Specification.

Enrollment_Severity_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the enrollment severity.

  • Reference: See Dictionary Program Severity table in the Dictionary Dataset Specification.

Enrollment_Product

  • Required: YES

  • Type: STRING

  • Description: Product associated with the enrollment.

  • Reference: See Dictionary Product table in the Dictionary Dataset Specification.

Enrollment_Product_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the enrollment product.

  • Reference: See Dictionary Product table in the Dictionary Dataset Specification.

Enrollment_Date

  • Required: YES

  • Type: DATE

  • Description: Date of the enrollment.

Enrollment_Start_Date

  • Required: YES

  • Type: DATE

  • Description: Start date of the enrollment.

Enrollment_Reopen_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for reopening the enrollment.

  • Reference: See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

Enrollment_Reopen_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the reason for reopening the enrollment.

  • Reference: See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

Enrollment_Reopen_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the enrollment was reopened.

Enroller_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the enroller.

Enrollment_Owner_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the owner of the enrollment.

Enrollment_Owner_Department_ID

  • Required: YES

  • Type: STRING

  • Description: Department ID of the owner of the enrollment.

Enrollment_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the enrollment was created.

Enrollment_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Diagnoses

Diagnoses

  • Required: NO

  • Type: ARRAY

  • Description: Diagnoses associated with the program.

Diagnoses.Program_Diagnosis_Key

  • Required: YES

  • Type: INT64

  • Description: The unique key or identifier for the diagnosis entry in the program's diagnoses table.

Diagnoses.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the diagnosis entry was initially created.

Diagnoses.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the diagnosis entry.

Diagnoses.Primary

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the diagnosis is the primary diagnosis for the program.

Diagnoses.Code

  • Required: YES

  • Type: STRING

  • Description: The code representing the diagnosis.

Diagnoses.Description

  • Required: YES

  • Type: STRING

  • Description: The description or name of the diagnosis, providing details about the medical condition or ailment.

Diagnoses.Coding_Scheme

  • Required: YES

  • Type: STRING

  • Description: The coding scheme used for the diagnosis code.

Diagnoses.Coding_Scheme_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the coding scheme used for the diagnosis code.

Diagnoses.Condition_Category

  • Required: YES

  • Type: STRING

  • Description: The category or classification of the medical condition associated with the diagnosis.

Diagnoses.Condition_Category_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the category or classification of the medical condition associated with the diagnosis.

Diagnoses.Sequence

  • Required: YES

  • Type: INT64

  • Description: The sequence number indicating the order of importance or relevance of the diagnosis within the program.

Diagnoses.Axis

  • Required: YES

  • Type: STRING

  • Description: The axis associated with the diagnosis code.

  • Reference: See Dictionary Axis table in the Dictionary Dataset Specification.

Diagnoses.Axis_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the axis associated with the diagnosis code.

  • Reference: See Dictionary Axis table in the Dictionary Dataset Specification.

Social Problems

Social_Problems

  • Required: NO

  • Type: ARRAY

  • Description: Social problems associated with the program.

Social_Problems.Program_Social_Problem_Key

  • Required: YES

  • Type: INT64

  • Description: Unique key associated with the social problem entry.

  • Reference: See Dictionary Axis Social Problem table in the Dictionary Dataset Specification.

Social_Problems.Code

  • Required: YES

  • Type: STRING

  • Description: Code representing the social problem.

Social_Problems.Description

  • Required: YES

  • Type: STRING

  • Description: Description of the social problem.

  • Reference: See Dictionary Axis Social Problem table in the Dictionary Dataset Specification.

Social_Problems.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the social problem entry was created.

Social_Problems.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the social problem entry was last modified.

Global Assessment of Functioning

Global_Assessment_of_Functioning

  • Required: NO

  • Type: ARRAY

  • Description: Assessment of the member's global functioning.

Program_Global_Assessment_of_Functioning_Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for each record of global assessment of functioning within the program.

Program_Global_Assessment_of_Functioning_Key.Score

  • Required: YES

  • Type: INT64

  • Description: The score assigned for the global assessment of functioning.

Program_Global_Assessment_of_Functioning_Key.Score_Entry_Date

  • Required: YES

  • Type: DATE

  • Description: The date when the score for the global assessment of functioning was entered.

Program_Global_Assessment_of_Functioning_Key.Latest

  • Required: YES

  • Type: BOOL

  • Description: Indicates if the global assessment of functioning is the latest one.

Program Dataset Specification

Global Assessment of Functioning Key

Created Timestamp

  • Type: TIMESTAMP

  • Description: The date and time when the assessment record was created.

Last Modified Timestamp

  • Type: TIMESTAMP

  • Description: The date and time when the assessment record was last modified.

Custom Fields

General Information

  • Type: ARRAY

  • Description: Custom fields associated with the program.

Program Custom Field Key

  • Type: INT64

  • Description: The unique key or identifier for the custom field entry in the program's custom fields table.

ID

  • Type: STRING

  • Description: The identification number or code assigned to the custom field.

Title

  • Type: STRING

  • Description: The title or name of the custom field, providing a brief description of its purpose or content.

Use

  • Type: STRING

  • Description: Indicates how the custom field is utilized within the system or application.

Created Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the custom field entry was initially created.

Last Modified Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the custom field entry.

Values

  • Type: ARRAY

  • Description: Value of the custom field.

Value

  • Type: STRING

  • Description: The value associated with the custom field.

Value Description

  • Type: STRING

  • Description: A description or explanation providing additional context for the value of the custom field, especially if the value is not self-explanatory.

Select Key

  • Type: INT64

  • Description: The key associated with the selection made in the custom field, if applicable.

Select Created Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the selection in the custom field was initially created.

Select Last Modified Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the selection in the custom field.

Notes

General Information

  • Type: ARRAY

  • Description: Notes related to the program.

Program Note Key

  • Type: INT64

  • Description: Unique identifier for each program note entry.

Text

  • Type: STRING

  • Description: The content of the note.

Type

  • Type: STRING

  • Description: Indicates the type of note. See Dictionary Note Type table in the Dictionary Dataset Specification.

Type Description

  • Type: STRING

  • Description: Description of the note type. See Dictionary Note Type table in the Dictionary Dataset Specification.

Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

Author User ID

  • Type: STRING

  • Description: User ID of the author who created the note.

Void Indicator

  • Type: BOOL

  • Description: Indicator whether the note is voided or not.

Void Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the note was voided.

Void Reason

  • Type: STRING

  • Description: Reason for voiding the note. See Dictionary Note Void Reason table in the Dictionary Dataset Specification.

Void Reason Description

  • Type: STRING

  • Description: Description of the reason for voiding the note. See Dictionary Note Void Reason table in the Dictionary Dataset Specification.

Void User ID

  • Type: STRING

  • Description: User ID of the user who voided the note.

Created Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

Last Modified Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating the last modification time of the note.

Visibility Level

  • Type: INT64

  • Description: Level of visibility for the program.

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.

Type

  • Type: STRING

  • Description: Type of the program.

Tenant

  • Type: STRING

  • Description: Tenant associated with the program.

Active Version

  • Type: BOOL

  • Description: Active version of the program.

Date

  • Type: DATE

  • Description: Date associated with the program.

Sequence

  • Type: INT64

  • Description: Sequence of the program.

Source System Name

  • Type: STRING

  • Description: Name of the source system.

Source Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp associated with the source.

Source File Name

  • Type: STRING

  • Description: Name of the source file.

Deleted Indicator

  • Type: BOOL

  • Description: Indicator specifying if the program is deleted.

Schema Version

  • Type: FLOAT64

  • Description: Schema version of the program.

Member Partition

  • Type: INT64

  • Description: Partition associated with the member.

Digital

  • Type: BOOL

  • Description: Indicates whether the screening or enrollment process is digital (e.g., Yes/No).

Enrollment Status

  • Type: STRING

  • Description: Current status of the enrollment (e.g., Active, Inactive, Pending).

Enrollment Reopen User ID

  • Type: STRING

  • Description: Identifier for the user who reopened the enrollment.

Last Closed User ID

  • Type: STRING

  • Description: The user ID of the person who last closed or completed the program.

Steps

General Information

  • Type: ARRAY

  • Description: A collection of steps associated with the program.

Step

  • Type: STRING

  • Description: An identifier or code for a specific step in the program.

Step Description

  • Type: STRING

  • Description: A detailed description of the step.

State

  • Type: STRING

  • Description: A code or identifier representing the current state of the step.

State Description

  • Type: STRING

  • Description: A detailed description of the current state of the step.

State Last Modified User ID

  • Type: STRING

  • Description: The user ID of the person who last modified the state of the step.

State Created Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp when the state of the step was initially created.

State Last Modified Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp when the state of the step was last modified.

Transaction Actor Type

  • Type: STRING

  • Description: Type of the actor performing the transaction.

Program Features

Program Management

  • Description: Stores details on the administration and operational aspects of healthcare programs, helping to oversee and coordinate activities effectively.

Enrollment Details

  • Description: Contains information about patient enrollment in specific programs, critical for tracking participation and engagement.

Care Planning

  • Description: Provides structured data on the planning of individual patient care within programs, ensuring tailored and proactive healthcare delivery.

Problem Identification

  • Description: Captures issues and challenges identified during the care process, facilitating timely interventions and support.

Notes and Logs

  • Description: Includes detailed notes and logs that document ongoing activities, observations, and interventions, offering a comprehensive view of patient interactions and program operations.

History Tracking

  • Description: Maintains a record of changes and updates to the program dataset.

Program Dataset Specification

Overview

The program dataset specification includes records of historical data related to program changes and patient progress. This data is essential for longitudinal studies and outcome assessments. The dataset consists of raw data storage, which holds unprocessed data, providing a robust foundation for in-depth analysis and research. This enables further insights into program effectiveness and areas for improvement.

Table Content

Table Structure

Table Name

Column Name

Is Nullable

Data Type

Description

Program_ID

YES

STRING

A unique identifier assigned to each program within the database. See Dictionary Program table in the Dictionary Dataset Specification.

Screening_Key

YES

INT64

A key associated with screening records linked to the program.

Screening_Request_Key

YES

INT64

A key associated with screening requests linked to the program.

Program_Enrollment_Key

YES

INT64

An identifier assigned to program enrollment records.

Member_ID

YES

STRING

An identification number for the member enrolled in the program.

Member_Enrollment_Key

YES

STRING

An identifier for the member's enrollment, determined by locating the primary active enrollment where the screening date falls between the enrollment's effective and termination dates. If multiple enrollments exist, the one with the latest effective and termination dates is selected.

Member_Enrollment_Effective_Date

YES

DATE

The date when the member's enrollment in the program started, derived from the "Effective_Date" parameter within the "Member Enrollment" table associated with the member.

Member_Enrollment_Termination_Date

YES

DATE

The date when the member's enrollment in the program ended, derived from the "Termination_Date" parameter within the "Member Enrollment" table associated with the member.

Group_ID

YES

STRING

An identification number for the group associated with the member's enrollment, sourced from the "Group_ID" parameter within the "Member Enrollment" table associated with the member.

Group_Name

YES

STRING

The name of the group associated with the member's enrollment, retrieved from the "Group_Name" parameter within the "Member Enrollment" table associated with the member.

Plan_ID

YES

STRING

An identification number for the plan associated with the member's enrollment, obtained from the "Plan_ID" parameter within the "Member Enrollment" table associated with the member.

Plan_Description

YES

STRING

A description of the plan associated with the member's enrollment, fetched from the "Plan_Description" parameter within the "Member Enrollment" table associated with the member.

Line_Of_Business

YES

STRING

Identifier for the line of business associated with the member's enrollment. This identifier is mapped from the "Line_Of_Business" parameter within the "Member Enrollment" table. See Dictionary Line Of Business table in the Dictionary Dataset Specification.

Line_Of_Business_Description

YES

STRING

Description of the line of business associated with the member's enrollment. This description is obtained from the "Line_Of_Business_Description" parameter within the "Member Enrollment" table. See Dictionary Line Of Business table in the Dictionary Dataset Specification.

Screening_Request_Date

YES

DATE

The date when the screening request was made.

Program_Class_Description

YES

STRING

Description of the program class. If Behavioral_Health is true, the description is 'Behavioral Health'; otherwise, it's 'Medical/Surgical'.

Source

YES

STRING

The source of the data or information. See Dictionary Program Source table in the Dictionary Dataset Specification.

Source_Description

YES

STRING

Description of the data or information source. See Dictionary Program Source table in the Dictionary Dataset Specification.

Screening_Program

YES

STRING

The program associated with the screening.

Screening_Program_Description

YES

STRING

Description of the program associated with the screening.

Screening_Severity

YES

STRING

The severity level of the screening. See Dictionary Program Severity table in the Dictionary Dataset Specification.

Screening_Severity_Description

YES

STRING

Description of the severity level of the screening. It is derived based on the value of the "Screening_Severity" parameter. See Dictionary Program Severity table in the Dictionary Dataset Specification.

Screening_Product

YES

STRING

The product related to the screening. See Dictionary Product table in the Dictionary Dataset Specification.

Screening_Product_Description

YES

STRING

Description of the product related to the screening. See Dictionary Product table in the Dictionary Dataset Specification.

Screening_Request_Created_Timestamp

YES

TIMESTAMP

The timestamp indicating when the screening request was created.

Screening_Request_Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp indicating when the screening request was last modified.

Screening_Date

YES

DATE

The date when the screening occurred.

Screening_Status

YES

STRING

The status of the screening request. See Dictionary Program Screening Status table in the Dictionary Dataset Specification.

Screening_Status_Description

YES

STRING

Description of the screening status. It is derived based on the value of the "Screening_Status" parameter. See Dictionary Program Screening Status table in the Dictionary Dataset Specification.

Referral_Outstanding_Days

YES

INT64

The number of days the referral has been outstanding. If the screening status is 'NOTCOMPLETED', this parameter calculates the difference between the current date and the screening request date. Otherwise, it's null.

Total_Duration_Days

YES

INT64

Total duration, in days, of the program's enrollment. This is calculated based on various conditions including enrollment start date, close date, and current date.

Enrollment_Status

YES

STRING

The status of the enrollment.

Program Dataset Specification

Enrollment Status

Enrollment_Status_Description

  • Type: STRING

  • Required: YES

  • Description: Description corresponding to the enrollment status, providing additional context on the program's enrollment state.

Not_Enrolled_Reason

  • Type: STRING

  • Required: YES

  • Description: Reason for not enrolling in the program, if applicable.\ See Dictionary Not Enrolled Reason table in the Dictionary Dataset Specification.

Not_Enrolled_Reason_Description

  • Type: STRING

  • Required: YES

  • Description: Description explaining the reason for not enrolling in the program, if provided.\ See Dictionary Not Enrolled Reason table in the Dictionary Dataset Specification.

Program Closure

Close_Reason

  • Type: STRING

  • Required: YES

  • Description: The reason for closing the program, if applicable.\ See Dictionary Program Close Reason table in the Dictionary Dataset Specification.

Close_Reason_Description

  • Type: STRING

  • Required: YES

  • Description: Description explaining the reason for closing the program, if provided.\ See Dictionary Program Close Reason table in the Dictionary Dataset Specification.

Screening Information

Screening_Owner_ID

  • Type: STRING

  • Required: YES

  • Description: Identification of the screening owner, which can be either an individual or a department.

Screening_Owner_Type

  • Type: STRING

  • Required: YES

  • Description: Type of screening owner, indicating whether it's an individual ("INDV") or a department ("DEPT").

Screening_Owner_Name

  • Type: STRING

  • Required: YES

  • Description: Name of the screening owner, which could be a user's full name or a department's name, based on the screening owner ID.

Screening_Owner_User_Name

  • Type: STRING

  • Required: YES

  • Description: User name of the screening owner.

Screening_Owner_Department_ID

  • Type: STRING

  • Required: YES

  • Description: Department ID of the screening owner.

Screening_Owner_Department_Name

  • Type: STRING

  • Required: YES

  • Description: Department name of the screening owner.

Screening_Owner_User_ID

  • Type: STRING

  • Required: YES

  • Description: ID of the screening owner.

Screening_Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating when the screening was initially created.

Screening_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating the last modification made to the screening.

Screener_User_ID

  • Type: STRING

  • Required: YES

  • Description: Identification of the user who conducted the screening.

Screener_User_Name

  • Type: STRING

  • Required: YES

  • Description: Name of the user who conducted the screening.

Source System

Source_System_ID

  • Type: STRING

  • Required: YES

  • Description: Identification of the source system.\ See Dictionary Source System table in the Dictionary Dataset Specification.

Source_System_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the source system.\ See Dictionary Source System table in the Dictionary Dataset Specification.

Source_System_Record_ID

  • Type: STRING

  • Required: YES

  • Description: Record ID from the source system where the Source_System_ID is 'CARE_PLANNER_WEB'.

Enrollment Information

Enrollment_Program

  • Type: STRING

  • Required: YES

  • Description: The program associated with enrollment.

Enrollment_Program_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the program associated with enrollment.

Enrollment_Severity

  • Type: STRING

  • Required: YES

  • Description: Severity level associated with enrollment.\ See Dictionary Program Severity table in the Dictionary Dataset Specification.

Enrollment_Severity_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the severity level associated with enrollment.\ See Dictionary Program Severity table in the Dictionary Dataset Specification.

Enrollment_Product

  • Type: STRING

  • Required: YES

  • Description: The product linked to the enrollment.\ See Dictionary Product table in the Dictionary Dataset Specification.

Enrollment_Product_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the product linked to the enrollment.\ See Dictionary Product table in the Dictionary Dataset Specification.

Enrollment_Date

  • Type: DATE

  • Required: YES

  • Description: The date when enrollment in the program occurred.

Close_Date

  • Type: DATE

  • Required: YES

  • Description: The date when the program was closed, if applicable.

Closed

  • Type: BOOL

  • Required: YES

  • Description: Indicates whether the program is closed. It is true if the Close_Date is not null, otherwise false.

Enrollment_Start_Date

  • Type: DATE

  • Required: YES

  • Description: The date when enrollment in the program started.

Enroller_User_ID

  • Type: STRING

  • Required: YES

  • Description: Identification of the user who enrolled the program.

Enroller_User_Name

  • Type: STRING

  • Required: YES

  • Description: Name of the user who enrolled the program, mapped to their full name.

Enrollment_Owner_ID

  • Type: STRING

  • Required: YES

  • Description: Identification of the owner of the enrollment, which can be either an individual or a department.

Enrollment_Owner_Type

  • Type: STRING

  • Required: YES

  • Description: Type of enrollment owner, indicating whether it's an individual ("INDV") or a department ("DEPT").

Enrollment_Owner_Name

  • Type: STRING

  • Required: YES

  • Description: Name of the owner of the enrollment, which could be a user's full name or a department's name, based on the enrollment owner ID.

Enrollment_Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating when the enrollment was initially created.

Enrollment_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating the last modification made to the enrollment.

Provider Information

Primary_Provider_Key

  • Type: INT64

  • Required: YES

  • Description: The primary key of the primary provider associated with the program.

Primary_Provider_ID

  • Type: STRING

  • Required: YES

  • Description: The identification of the primary provider associated with the program.

Primary_Provider_NPI

  • Type: STRING

  • Required: YES

  • Description: The National Provider Identifier (NPI) of the primary provider associated with the program.

Primary_Provider_Type

  • Type: STRING

  • Required: YES

  • Description: Type of the primary provider associated with the program.

Primary_Provider_Type_Description

  • Type: STRING

  • Required: YES

  • Description: Description for the type of the primary provider associated with the program.

Primary_Provider_Name

  • Type: STRING

  • Required: YES

  • Description: The name of the primary provider associated with the program, mapped to their full name.

Diagnosis Information

Primary_Diagnosis_Key

  • Type: INT64

  • Required: YES

  • Description: The primary key associated with the primary diagnosis of the program.

Primary_Diagnosis_Code

  • Type: STRING

  • Required: YES

  • Description: The code representing the primary diagnosis of the program.

Primary_Diagnosis_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the primary diagnosis of the program.

Primary_Diagnosis_Coding_Scheme

  • Type: STRING

  • Required: YES

  • Description: Coding scheme associated with the primary diagnosis of the program.

Program Dataset Specification

Primary Diagnosis

Primary_Diagnosis_Coding_Scheme_Description

  • Data Type: STRING

  • Description: The coding scheme used for the primary diagnosis of the program.

Primary_Diagnosis_Condition_Category

  • Data Type: STRING

  • Description: The category of the primary diagnosis condition.

Primary_Diagnosis_Condition_Category_Description

  • Data Type: STRING

  • Description: Description of the category of the primary diagnosis condition.

Primary_Axis

  • Data Type: STRING

  • Description: The primary axis associated with the diagnosis.

Primary_Axis_Description

  • Data Type: STRING

  • Description: Description of the primary axis associated with the diagnosis.

Primary_Diagnosis_Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the primary diagnosis was initially created.

Primary_Diagnosis_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the last modification made to the primary diagnosis.

Primary_Diagnosis_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the primary diagnosis was last updated in the program.

Program Details

Program_Type

  • Data Type: STRING

  • Description: Type or category of the program (e.g., clinical, wellness).

Program_Type_Description

  • Data Type: STRING

  • Description: Detailed description of the type or category of the program.

Digital

  • Data Type: BOOL

  • Description: Indicator of whether the program is conducted digitally (yes/no).

External_Program_ID

  • Data Type: STRING

  • Description: Unique identifier for an external program linked to this dataset.

External_Program_Vendor_Code

  • Data Type: STRING

  • Description: Code representing the vendor providing the external program.

External_Program_Vendor_Description

  • Data Type: STRING

  • Description: Description of the external program vendor.

External_Program_Vendor_Phone

  • Data Type: STRING

  • Description: Phone number of the external program vendor.

External_Program_Vendor_Email

  • Data Type: STRING

  • Description: Email address of the external program vendor.

  • Data Type: STRING

  • Description: Link or URL for the external program vendor.

Program Status

Current_Step

  • Data Type: STRING

  • Description: Identifier for the current step or phase within the program.

Current_Step_Description

  • Data Type: STRING

  • Description: Description of the current step or phase within the program.

Current_State

  • Data Type: STRING

  • Description: State or status of the program (e.g., active, paused, completed).

Current_State_Description

  • Data Type: STRING

  • Description: Detailed description of the program's current state or status.

Digital_Pause_Indicator

  • Data Type: BOOL

  • Description: Indicator of whether the program is currently paused digitally (yes/no).

Digital_Pause_By_Type

  • Data Type: STRING

  • Description: Type or reason for the digital pause.

Digital_Pause_By_Type_Description

  • Data Type: STRING

  • Description: Detailed description of the type or reason for the digital pause.

Digital_Pause_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the program was paused digitally.

Last_Closed_User_ID

  • Data Type: STRING

  • Description: User ID of the individual who last closed or completed the program.

Last_Closed_User_Name

  • Data Type: STRING

  • Description: Name of the individual who last closed or completed the program.

Audit History

Program_ID

  • Data Type: STRING

  • Description: The identifier of the program associated with the edit history record. See Dictionary Program table in the Dictionary Dataset Specification.

Audit_Class

  • Data Type: STRING

  • Description: The class or category of the audit data point being modified (e.g., demographic information, medical history, treatment plan). See Dictionary Audit Log Class table in the Dictionary Dataset Specification.

Audit_Data_Point

  • Data Type: STRING

  • Description: The specific data point within the audit class being modified (e.g., patient age, diagnosis, medication dosage). See Dictionary Audit Log Data Point table in the Dictionary Dataset Specification.

Old_Value

  • Data Type: STRING

  • Description: The previous value of the edited data point before the change.

New_Value

  • Data Type: STRING

  • Description: The new value of the edited data point after the change.

Close_Date

  • Data Type: DATE

  • Description: The date when the edit was made.

Edit_User_ID

  • Data Type: STRING

  • Description: The identifier of the user who made the edit.

Edit_User_Name

  • Data Type: STRING

  • Description: The name of the user who made the edit.

Edit_Timestamp

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the edit was made.

Program Creation

Program_ID

  • Data Type: STRING

  • Description: The unique identifier for the program.

Created_User_ID

  • Data Type: STRING

  • Description: The user ID of the person who created the program.

Created_User_Name

  • Data Type: STRING

  • Description: The name of the user who created the program.

Custom Fields

Program_Custom_Field_Key

  • Data Type: INT64

  • Description: The unique key or identifier for the custom field entry in the program's custom fields table.

Screening_Key

  • Data Type: INT64

  • Description: The key associated with the screening process to which the custom field pertains.

Program_ID

  • Data Type: STRING

  • Description: The identifier of the program to which the custom field belongs. See Dictionary Program table in the Dictionary Dataset Specification.

ID

  • Data Type: STRING

  • Description: The identification number or code assigned to the custom field.

Title

  • Data Type: STRING

  • Description: The title or name of the custom field, providing a brief description of its purpose or content.

Use

  • Data Type: STRING

  • Description: Indicates how the custom field is utilized within the system or application.

Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the custom field entry was initially created.

Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the custom field entry.

Value

  • Data Type: STRING

  • Description: The value associated with the custom field.

Value_Description

  • Data Type: STRING

  • Description: A description or explanation providing additional context for the value of the custom field, especially if the value is not self-explanatory.

Program Dataset Specification

Select Fields

Select_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key associated with the selection made in the custom field, if applicable.

Select_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the selection in the custom field was initially created.

Select_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the selection in the custom field.

Program Provider Roles Table

Program_Provider_Role_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The unique key or identifier for the provider role entry in the program's custom provider roles table.

Program_Provider_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key associated with the provider within the program.

Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key associated with the screening process to which the provider role pertains.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the program to which the provider role belongs. See Dictionary Program table in the Dictionary Dataset Specification.

Provider_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key or identifier associated with the provider in the system.

Provider_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identification number or code assigned to the provider.

Provider_NPI

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The National Provider Identifier (NPI) of the provider.

Primary_Provider_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the primary provider associated with the program.

Primary_Provider_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description for the type of the primary provider associated with the program.

Provider_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the provider.

Primary

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the provider holds a primary role within the program.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the provider role entry was initially created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the provider role entry.

Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code associated with the provider role. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The description or name of the provider role, providing details about the role's responsibilities or functions. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

Role_Effective_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the provider assumed or started the role within the program.

Role_Termination_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the provider's role within the program was terminated or ended.

Role_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the provider role entry was initially created or established.

Role_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the provider role entry, including changes to role details such as effective or termination dates.

Screening Table

Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the screening entry.

Decision_Changed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether a decision has been changed (e.g., Yes/No).

Decision_Change_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the decision change was made.

Decision_Change_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Specific date when the decision change was recorded.

Decision_Change_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who made the decision change.

Decision_Change_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who made the decision change.

Program Diagnoses Table

Program_Diagnosis_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The unique key or identifier for the diagnosis entry in the program's diagnoses table.

Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key associated with the screening process to which the diagnosis pertains.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the program to which the diagnosis belongs. See Dictionary Program table in the Dictionary Dataset Specification.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the diagnosis entry was initially created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the diagnosis entry.

Primary

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the diagnosis is the primary diagnosis for the program.

Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code representing the diagnosis.

Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The description or name of the diagnosis, providing details about the medical condition or ailment.

Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The coding scheme used for the diagnosis code.

Coding_Scheme_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the coding scheme used for the diagnosis code.

Condition_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The category or classification of the medical condition associated with the diagnosis.

Condition_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the category or classification of the medical condition associated with the diagnosis.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The sequence number indicating the order of importance or relevance of the diagnosis within the program.

Axis

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The axis associated with the diagnosis code. See Dictionary Axis table in the Dictionary Dataset Specification.

Axis_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the axis associated with the diagnosis code. See Dictionary Axis table in the Dictionary Dataset Specification.

Cost Saving Program Enrollment Details Table

Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The unique key or identifier for the enrollment in the program's enrollment cost saving details table.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the program to which the enrollment cost saving details belong.

Program Dataset Specification

Cost Saving Program Enrollment Details

Savings Documentation Start Date

  • Required: YES

  • Type: DATE

  • Description: The start date of the documentation period for cost-saving measures.

Savings Documentation End Date

  • Required: YES

  • Type: DATE

  • Description: The end date of the documentation period for cost-saving measures.

Cost Saving Code

  • Required: YES

  • Type: STRING

  • Description: The code representing the specific cost-saving measure.

Cost Saving Description

  • Required: YES

  • Type: STRING

  • Description: The description or name of the cost-saving measure, providing details about the method or approach used to save costs.

Cost Saving Type

  • Required: YES

  • Type: STRING

  • Description: The type or category of the cost-saving measure.

Cost Saving Type Description

  • Required: YES

  • Type: STRING

  • Description: Description of the type or category of the cost-saving measure.

Other Cost Saving Description

  • Required: YES

  • Type: STRING

  • Description: Additional description or details for the cost-saving measure if it does not fit into predefined categories.

Care Management Type

  • Required: YES

  • Type: STRING

  • Description: The type or method of care management associated with the cost-saving measure.

Care Management Type Description

  • Required: YES

  • Type: STRING

  • Description: Description of the type or method of care management associated with the cost-saving measure.

Coordinated Care Discharge Disposition

  • Required: YES

  • Type: STRING

  • Description: The disposition of the patient upon discharge related to coordinated care efforts.

Coordinated Care Discharge Disposition Description

  • Required: YES

  • Type: STRING

  • Description: Description of the disposition of the patient upon discharge related to coordinated care efforts.

Other Coordinated Care Discharge Disposition Description

  • Required: YES

  • Type: INT64

  • Description: Additional description or details for the disposition of the patient upon discharge related to coordinated care efforts if it does not fit into predefined categories.

Cost Saving ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the specific cost-saving entry.

Permission Required

  • Required: YES

  • Type: BOOL

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

Permission From Name

  • Required: YES

  • Type: STRING

  • Description: The name of the entity or individual from whom permission is required for the cost-saving measure.

Permission From Role

  • Required: YES

  • Type: STRING

  • Description: The role or position of the entity or individual from whom permission is required for the cost-saving measure.

Medical Director Name

  • Required: YES

  • Type: STRING

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

Cost Saving Void Indicator

  • Required: YES

  • Type: BOOL

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

Cost Saving Void Reason

  • Required: YES

  • Type: STRING

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

Cost Saving Void Reason Description

  • Required: YES

  • Type: STRING

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

Cost Saving Created User ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the cost-saving entry.

Cost Saving Created User Name

  • Required: YES

  • Type: STRING

  • Description: The name of the user who created the cost-saving entry.

Cost Saving Last Modified User ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the cost-saving entry.

Cost Saving Last Modified User Name

  • Required: YES

  • Type: STRING

  • Description: The name of the user who last modified the cost-saving entry.

Cost Saving Created Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the cost-saving entry was initially created.

Cost Saving Last Modified Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the cost-saving entry.

Cost ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the cost associated with the cost-saving measure.

Cost Void Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the cost entry has been voided.

Cost Void Reason

  • Required: YES

  • Type: STRING

  • Description: The reason for voiding the cost entry.

Cost Void Reason Description

  • Required: YES

  • Type: STRING

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

Diagnosis Code

  • Required: YES

  • Type: STRING

  • Description: The code representing the diagnosis associated with the cost-saving details.

Diagnosis Description

  • Required: YES

  • Type: STRING

  • Description: The description or name of the diagnosis, providing details about the medical condition or ailment.

Diagnosis Group

  • Required: YES

  • Type: STRING

  • Description: The group to which the diagnosis belongs.

Diagnosis Group Description

  • Required: YES

  • Type: STRING

  • Description: Description of the diagnosis group.

Diagnosis Coding Scheme

  • Required: YES

  • Type: STRING

  • Description: The coding scheme used for the diagnosis code.

Bed Type

  • Required: YES

  • Type: STRING

  • Description: The type of bed used for the patient's care. See Dictionary Bed Type table in the Dictionary Dataset Specification.

Bed Type Description

  • Required: YES

  • Type: STRING

  • Description: Description of the type of bed used for the patient's care. See Dictionary Bed Type table in the Dictionary Dataset Specification.

Program Dataset Specification

Cost Saving Program Enrollment Details

Dataset Columns

  • Type_Of_Care

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type or category of care provided.

  • Type_Of_Care_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the type or category of care provided.

  • Units

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The number of units of the service provided.

  • Cost_Per_Unit

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The cost per unit of the service provided.

  • Cost_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code representing the service provided.

  • Service_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The description or name of the service provided.

  • Service_Unit_Of_Measure

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unit of measure for the service provided.

  • Service_Provider_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the provider who delivered the service.

  • Primary_Service_Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The coding scheme used for the primary service code.

  • Cost_Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the cost-saving details.

  • Cost_Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who created the cost-saving details.

  • Cost_Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the cost-saving details.

  • Cost_Last_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the cost-saving details.

  • Cost_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the cost-saving details were initially created.

  • Cost_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the cost-saving details.

  • Total_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The total cost associated with the provided service or care.

  • Expected_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The expected cost of the service or care.

  • Actual_Cost

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The actual cost incurred for the service or care.

  • Cost_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The category or classification of the cost.

  • Cost_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the category or classification of the cost.

  • Cost_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Savings_Documentation_End_Date_YYYYMM

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date of the documentation period for savings in YYYYMM format.

  • Documentation_Closed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the documentation for cost savings is closed.

  • Condition_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a category or classification related to specific conditions (e.g., health conditions, cost-saving criteria).

  • Condition_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional details about the condition category (e.g., “Chronic Diseases” or “Eligibility Criteria”).

Cost Saving Program Enrollment Notes

Dataset Columns

  • Note_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The unique identifier/key for the cost-saving note.

  • Cost_Saving_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The key linking the note to the specific cost-saving details to which it pertains.

  • Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content or text of the note, providing additional information or comments related to the cost-saving details.

  • Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Author_User_Name

  • Is Nullable: YES

  • Data Type: STRING

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

  • Author_User_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title or position of the user who authored or created the note.

  • Author_Phone_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The phone number associated with the author of the note, if applicable.

  • Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the note is voided.

  • Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was voided.

  • Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding the note.

  • Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the reason for voiding the note.

  • Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who voided the note.

  • Void_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who voided the note.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the note was initially created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the note.

Program Dataset Specification

Cost Saving Program Enrollment Summary

Table Columns

Column Name

Is Nullable

Data Type

Description

Savings_Documentation_End_Date_YYYYMM

YES

STRING

The end date of the documentation period for cost savings, represented in YYYYMM format.

Enrollment_Program

YES

STRING

The identifier or code for the enrollment program associated with the cost-saving summary.

Enrollment_Program_Description

YES

STRING

A description providing details about the enrollment program associated with the cost-saving summary.

Enrollment_Product

YES

STRING

The identifier or code for the product related to the enrollment program. See Dictionary Product table in the Dictionary Dataset Specification.

Enrollment_Product_Description

YES

STRING

A description providing details about the product related to the enrollment program. See Dictionary Product table in the Dictionary Dataset Specification.

Group_ID

YES

STRING

The identifier for the group associated with the cost-saving summary.

Group_Name

YES

STRING

The name or label of the group associated with the cost-saving summary.

Plan_ID

YES

STRING

The identifier for the plan associated with the cost-saving summary.

Plan_Description

YES

STRING

A description providing details about the plan associated with the cost-saving summary.

Line_Of_Business

YES

STRING

The identifier for the line of business associated with the cost-saving summary. See Dictionary Line Of Business table in the Dictionary Dataset Specification.

Line_Of_Business_Description

YES

STRING

A description providing details about the line of business associated with the cost-saving summary. See Dictionary Line Of Business table in the Dictionary Dataset Specification.

Client_Code

YES

STRING

The code representing the client associated with the cost-saving summary.

Client_Code_Description

YES

STRING

A description providing details about the client associated with the cost-saving summary.

Cost_Saving_Type

YES

STRING

The type or category of cost-saving.

Cost_Saving_Type_Description

YES

STRING

A description providing details about the type or category of cost-saving.

Total_Cost_Saving_Count

YES

INT64

The total count of cost-saving instances.

Total_Expected_Cost

YES

NUMERIC

The total expected cost for all instances of cost-saving.

Total_Actual_Cost

YES

NUMERIC

The total actual cost for all instances of cost-saving.

Total_Cost_Saving

YES

NUMERIC

The total cost savings achieved across all instances.

Program Enrollment Key

Table Columns

Column Name

Is Nullable

Data Type

Description

Program_Enrollment_Key

YES

INT64

The unique identifier for the enrollment within the program.

First_Enrollment_Owner_ID

YES

STRING

The ID of the first owner responsible for the enrollment, determined from historical data within each enrolled program ID.

First_Enrollment_Owner_Name

YES

STRING

The name of the first owner responsible for the enrollment, derived from historical data within each enrolled program ID.

First_Enrollment_Owner_Type

YES

STRING

The type of the first owner responsible for the enrollment, determined from historical data within each enrolled program ID (e.g., individual or department).

Enrollment_Owner_ID

YES

STRING

The ID of the current owner responsible for the enrollment, derived from the current program data, considering both user and department IDs.

Enrollment_Owner_Name

YES

STRING

The name of the current owner responsible for the enrollment, derived from the current program data, considering both user and department names.

Enrollment_Owner_Type

YES

STRING

The type of the current owner responsible for the enrollment, derived from the current program data (e.g., individual or department).

Previous_Enrollment_Owner_ID

YES

STRING

The ID of the previous owner responsible for the enrollment, determined from historical data within each enrolled program ID.

Previous_Enrollment_Owner_Name

YES

STRING

The name of the previous owner responsible for the enrollment, derived from historical data within each enrolled program ID.

Previous_Enrollment_Owner_Type

YES

STRING

The type of the previous owner responsible for the enrollment, determined from historical data within each enrolled program ID (e.g., individual or department).

First

YES

BOOL

A flag indicating whether the record is the first historical record within a program.

Latest

YES

BOOL

A flag indicating whether the record is the latest historical record within a program.

Effective_Timestamp

YES

TIMESTAMP

The timestamp indicating the effective time of the record.

Transaction_User_ID

YES

STRING

The ID of the user associated with the transaction.

Transaction_User_Name

YES

STRING

The full name of the user associated with the transaction, derived from the user ID.

Deleted_Indicator

YES

BOOL

A flag used as a filter, typically set to false to filter out deleted records.

Program Dataset Specification

Program Enrollment Details

Program Enrollment Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the program enrollment entry.

Days in Closed Program

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days the program was in a closed state.

Enrollment Month Count

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Total number of months the enrollment has been active.

Days in Program

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Total number of days the enrollment has been active.

Enrollment Reopen Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of times the enrollment has been reopened.

Enrollment Reopen Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for reopening the enrollment.

Enrollment Reopen Reason Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the reason for reopening the enrollment.

Enrollment Reopen Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the enrollment was reopened.

Enrollment Reopen User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who reopened the enrollment.

Enrollment Reopen User Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who reopened the enrollment.

Enrollment Reopen

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the enrollment has been reopened (e.g., Yes/No).

Program Enrollment Table

Program Enrollment Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each enrollment record in the program.

Program ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program associated with the enrollment. See Dictionary Program table in the Dictionary Dataset Specification.

Enrollment Start Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the enrollment started. For reopened programs, the reopen date is used as the enrollment start date.

Enrollment Close Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the enrollment was closed.

Days in Closed Program

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days the program was closed. Calculated based on the closed and open/reopen dates for all iterations using data from the Program_LOG table.

Gap Days

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days between the current program's closed date and the next program's reopen date.

Enrollment Reopen

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the enrollment was reopened. True if the program was reopened, otherwise false.

Enrollment Reopen User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who reopened the enrollment.

Enrollment Reopen User Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full name of the user who initiated the reopening of the enrollment. This information is mapped to the Full_Name field within the User table based on the Enrollment_Reopen_User_ID.

Enrollment Reopen Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for reopening the enrollment. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

Enrollment Reopen Reason Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the reason for reopening the enrollment. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

Enrollment Reopen Order

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequential number assigned to each open/reopen/close record within an enrollment ID.

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether a record is the latest or not. True if it's the latest record, otherwise false.

Enrollment Severity Table

Program Enrollment Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each enrollment record in the program.

First Enrollment Severity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The severity of the first enrollment in the program, calculated based on data from the Program_LOG table. See Dictionary Program Severity table in the Dictionary Dataset Specification.

First Enrollment Severity Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the severity of the first enrollment, derived from data in the Program_LOG table. See Dictionary Program Severity table in the Dictionary Dataset Specification.

First Effective Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the severity for the first enrollment was set within the program.

Enrollment Severity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Severity of the current enrollment in the program. See Dictionary Program Severity table in the Dictionary Dataset Specification.

Enrollment Severity Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the severity of the current enrollment. See Dictionary Program Severity table in the Dictionary Dataset Specification.

Previous Enrollment Severity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Severity of the enrollment before the current one, calculated based on data from the Program_LOG table. See Dictionary Program Severity table in the Dictionary Dataset Specification.

Previous Enrollment Severity Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the severity of the enrollment before the current one, derived from data in the Program_LOG table. See Dictionary Program Severity table in the Dictionary Dataset Specification.

Next Effective Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the next historical record of enrollment severity within the program begins. If null, the current record is the latest change.

First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether a record is the first historical record within a program. True if it is the first record, false otherwise.

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether a record is the latest historical record within a program. True if it is the latest record, false otherwise.

Effective Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when a change to the enrolled severity occurred within the program.

Program Enrollment Severity User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user responsible for setting the enrollment severity.

Program Enrollment Severity User Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full name of the user responsible for setting the enrollment severity, derived from the User table.

Deleted Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator used as a filter. False indicates that the record is not deleted.

Global Assessment of Functioning Table

Program Global Assessment of Functioning Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each record of global assessment of functioning.

Program Dataset Specification

Screening Assessment

Table Content

Column Name

Is Nullable

Data Type

Description

Screening_Key

YES

INT64

Identifier linking the assessment to a specific screening process.

Program_ID

YES

STRING

Unique identifier for the program associated with the assessment. See Dictionary Program table in the Dictionary Dataset Specification.

Score

YES

INT64

The score assigned for the global assessment of functioning.

Score_Entry_Date

YES

DATE

The date when the score for the global assessment of functioning was entered.

Created_Timestamp

YES

TIMESTAMP

The date and time when the assessment record was created.

Last_Modified_Timestamp

YES

TIMESTAMP

The date and time when the assessment record was last modified.

Screening Request

Table Content

Column Name

Is Nullable

Data Type

Description

Screening_Request_Key

YES

INT64

Unique identifier for the screening request associated with the program move.

Program_ID

YES

STRING

Unique identifier for the program involved in the move. See Dictionary Program table in the Dictionary Dataset Specification.

Entity_Move_Key

YES

INT64

Unique key for tracking the specific move event within the program.

From_Member_Key

YES

INT64

Unique key of the member from whom the program is being moved.

To_Member_Key

YES

INT64

Unique key of the member to whom the program is being moved.

From_Member_ID

YES

STRING

Identifier for the member from which the program was moved.

To_Member_ID

YES

STRING

Identifier for the member to which the program was moved.

Moved_By_User_ID

YES

STRING

User ID of the user who initiated the program move.

Moved_By_User_Name

YES

STRING

Full name of the user who initiated the program move.

Moved_Timestamp

YES

TIMESTAMP

Timestamp indicating when the program move occurred.

Program Notes

Table Content

Column Name

Is Nullable

Data Type

Description

Program_Note_Key

YES

STRING

Unique identifier for each program note entry.

Screening_Key

YES

INT64

Unique identifier linking the note to a specific screening.

Text

YES

STRING

The content of the note.

Type

YES

STRING

Indicates the type of note. See Dictionary Note Type table in the Dictionary Dataset Specification.

Type_Description

YES

STRING

Description of the note type. See Dictionary Note Type table in the Dictionary Dataset Specification.

Timestamp

YES

TIMESTAMP

Timestamp indicating when the note was created.

Author_User_ID

YES

STRING

User ID of the author who created the note.

Author_User_Name

YES

STRING

Full name of the author who created the note.

Void_Indicator

YES

BOOL

Indicator whether the note is voided or not.

Void_Timestamp

YES

TIMESTAMP

Timestamp indicating when the note was voided.

Void_Reason

YES

STRING

Reason for voiding the note. See Dictionary Note Void Reason table in the Dictionary Dataset Specification.

Void_Reason_Description

YES

STRING

Description of the reason for voiding the note. See Dictionary Note Void Reason table in the Dictionary Dataset Specification.

Void_User_ID

YES

STRING

User ID of the user who voided the note.

Void_User_Name

YES

STRING

Full name of the user who voided the note.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the note was created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating the last modification time of the note.

Program Plan of Care Goal Barrier

Table Content

Column Name

Is Nullable

Data Type

Description

Program_Plan_Of_Care_Goal_Barrier_Key

YES

INT64

Unique identifier for each barrier entry within a program plan of care goal. See Dictionary Barrier table in the Dictionary Dataset Specification.

Program_Plan_Of_Care_Goal_Key

YES

INT64

Unique identifier linking the barrier to a specific program plan of care goal.

Code

YES

STRING

Code representing the barrier.

Description

YES

STRING

Description of the barrier. See Dictionary Barrier table in the Dictionary Dataset Specification.

Other_Description

YES

STRING

Additional description if the barrier is not covered by the predefined codes.

Identification_Date

YES

DATE

Date when the barrier was identified.

Resolution_Date

YES

DATE

Date when the barrier was resolved.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the barrier entry was created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating the last modification time of the barrier entry.

Barrier_Resolved

YES

BOOL

Indicator whether the barrier is resolved or not.

Barrier_Resolved_Days

YES

INT64

Number of days taken to resolve the barrier.

Barrier_Resolved_Days_Description

YES

STRING

Description of the duration taken to resolve the barrier.

Barrier_Resolved_Days_Sort_Order

YES

INT64

Sort order for displaying barriers based on the number of days taken to resolve them, used for sorting purposes.

Program Plan of Care Goal Focus

Table Content

Column Name

Is Nullable

Data Type

Description

Goal_Key

YES

INT64

Unique identifier for each program plan of care goal. See Dictionary Goal Focus table in the Dictionary Dataset Specification.

First_Goal_Focus_Description

YES

STRING

Description of the first goal focus associated with the program plan of care goal.

Goal_Focus_Description

YES

STRING

Description of the current goal focus associated with the program plan of care goal. See Dictionary Goal Focus table in the Dictionary Dataset Specification.

Previous_Goal_Focus_Description

YES

STRING

Description of the previous goal focus associated with the program plan of care goal.

Effective_Timestamp

YES

TIMESTAMP

Timestamp indicating when the goal focus change took effect.

First

YES

BOOL

Indicates whether the record represents the first goal focus.

Program Dataset Specification

Historical Change of Goal Focus

Columns

  • Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the record represents the latest historical change of the goal focus within a program goal.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier of the user who initiated the change in goal focus.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator of whether the record has been deleted.

Program Plan of Care Goal Focus

Columns

  • Program_Plan_Of_Care_Goal_Focus_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each program plan of care goal focus. See Dictionary Goal Focus table in the Dictionary Dataset Specification.

  • Program_Plan_Of_Care_Goal_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier linking the goal focus to the corresponding program plan of care goal.

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the program plan of care goal focus.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the program plan of care goal focus. See Dictionary Goal Focus table in the Dictionary Dataset Specification.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the program plan of care goal focus was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the program plan of care goal focus was last modified.

Program Plan of Care Goal Intervention Engagement Notes

Columns

  • Program_Plan_Of_Care_Goal_Intervention_Engagement_Emmi_Note_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each note related to program plan of care goal intervention engagement.

  • Program_Plan_Of_Care_Goal_Intervention_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier linking the note to the corresponding program plan of care goal intervention.

  • Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text content of the note.

  • Entry_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was entered.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Program Plan of Care Goal

Columns

  • Program_Plan_Of_Care_Goal_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each plan of care goal. See Dictionary Goal table in the Dictionary Dataset Specification.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the member associated with the goal.

  • Problem_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the problem associated with the goal.

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the goal.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the goal. See Dictionary Goal table in the Dictionary Dataset Specification.

  • Other_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description for the goal if available.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the goal. See Dictionary Goal Type table in the Dictionary Dataset Specification.

  • Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the goal type. See Dictionary Goal Type table in the Dictionary Dataset Specification.

  • Start_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the goal was initiated.

  • Actual_Completion_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Actual completion date of the goal.

  • Target_Completion_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Target completion date set for the goal.

  • Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome of the goal. See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

  • Outcome_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the outcome. See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

  • Outcome_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category of the outcome. See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

  • Outcome_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the outcome category. See Dictionary Goal Outcome Category table in the Dictionary Dataset Specification.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the goal was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Goal_Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Count of goals associated with the plan of care.

  • Barriers_Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Count of barriers associated with the goal.

  • Interventions_Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Count of interventions associated with the goal.

  • Barriers_Exists

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether barriers exist for the goal.

  • Interventions_Exists

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether interventions exist for the goal.

  • Goal_Closed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the goal is closed.

  • Closed_State

  • Is Nullable: YES

  • Data Type: STRING

  • Description: State of closure for the goal.

  • Closed_State_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the closure state for the goal.

  • Closed_Days_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the days until closure for the goal.

  • Closed_Days_Sort_Order

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sort order for the days until closure for the goal.

  • Closed_Days

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days until closure for the goal.

Program Plan of Care Notes

Columns

  • Program_Plan_Of_Care_Note_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for each note associated with a plan of care.

  • Problem_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the problem related to the note.

  • Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content of the note.

  • Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who authored the note.

  • Author_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full name of the user who authored the note.

  • Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the note has been voided.

  • Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the note was voided.

  • Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The reason for voiding the note.

  • Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the reason for voiding the note.

  • Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who voided the note.

  • Void_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who voided the note.

Program Dataset Specification

Table: Program_Problem_raw

Columns

  • d_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the problem.

  • Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the enrollment program related to the problem.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the program associated with the problem. See Dictionary Program table in the Dictionary Dataset Specification.

  • Problem_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the problem entry.

  • Member_Enrollment_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member's enrollment.

  • Member_Enrollment_Effective_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Effective date of the member's enrollment in the program.

  • Member_Enrollment_Termination_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Termination date of the member's enrollment in the program.

  • Group_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the group to which the member belongs.

  • Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the group to which the member belongs.

  • Plan_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the plan associated with the problem.

  • Plan_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the plan associated with the problem.

  • Line_Of_Business

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Line of business related to the problem. See Dictionary Line Of Business table in the Dictionary Dataset Specification.

  • Line_Of_Business_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the line of business related to the problem. See Dictionary Line Of Business table in the Dictionary Dataset Specification.

  • Problem

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the problem. See Dictionary Problem table in the Dictionary Dataset Specification.

  • Problem_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the problem. See Dictionary Problem table in the Dictionary Dataset Specification.

  • Problem_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the problem. See Dictionary Problem Status table in the Dictionary Dataset Specification.

  • Problem_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the problem status. See Dictionary Problem Status table in the Dictionary Dataset Specification.

  • Outcome_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the outcome of the problem.

  • Problem_Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome of the problem. See Dictionary Problem Outcome table in the Dictionary Dataset Specification.

  • Problem_Outcome_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the outcome of the problem. See Dictionary Problem Outcome table in the Dictionary Dataset Specification.

  • Problem_Outcome_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category of the outcome of the problem. See Dictionary Problem Outcome Category table in the Dictionary Dataset Specification.

  • Problem_Outcome_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the category of the outcome of the problem. See Dictionary Problem Outcome Category table in the Dictionary Dataset Specification.

  • Problem_Other_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description of the problem if necessary.

  • Start_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the problem was initiated.

  • Actual_Completion_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Actual completion date of the problem.

  • Target_Completion_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Target completion date of the problem.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the problem entry was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the problem entry was last modified.

  • Problem_Closed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the problem is closed or not.

  • Problem_Closed_Days

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days the problem has been closed.

  • Problem_Closed_Days_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the number of days the problem has been closed.

  • Problem_Closed_Days_Sort_Order

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sorting order of the problem based on closed days.

  • Closed_State

  • Is Nullable: YES

  • Data Type: STRING

  • Description: State of closure for the problem.

  • Closed_State_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the state of closure for the problem.

  • Goals_Exist

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether goals exist for the problem.

  • Barriers_Exist

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether barriers exist for the problem.

  • Interventions_Exist

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether interventions exist for the problem.

  • Goals_Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of goals associated with the problem.

  • Barriers_Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of barriers associated with the problem.

  • Interventions_Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of interventions associated with the problem.

Table: Program_Plan_Of_Care_raw

Columns

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the program plan of care.

  • Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the enrollment program associated with the plan of care.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the program associated with the plan of care. See Dictionary Program table in the Dictionary Dataset Specification.

  • Problem_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the problem entry in the plan of care.

  • Problem

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the problem in the plan of care. See Dictionary Problem table in the Dictionary Dataset Specification.

  • Problem_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the problem in the plan of care. See Dictionary Problem table in the Dictionary Dataset Specification.

  • Problem_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the problem in the plan of care. See Dictionary Problem Status table in the Dictionary Dataset Specification.

  • Problem_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the problem status in the plan of care. See Dictionary Problem Status table in the Dictionary Dataset Specification.

Program Dataset Specification

Problem in the Plan of Care

Problem Status

  • Field Name: Problem_Status

  • Required: YES

  • Type: STRING

  • Description: Description of the status of the problem in the plan of care.\ See Dictionary Problem Status table in the Dictionary Dataset Specification.

Outcome Code

  • Field Name: Outcome_Code

  • Required: YES

  • Type: STRING

  • Description: Code representing the outcome of the problem in the plan of care.

Problem Outcome

  • Field Name: Problem_Outcome

  • Required: YES

  • Type: STRING

  • Description: Outcome of the problem in the plan of care.\ See Dictionary Problem Outcome table in the Dictionary Dataset Specification.

Problem Outcome Description

  • Field Name: Problem_Outcome_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the outcome of the problem in the plan of care.\ See Dictionary Problem Outcome table in the Dictionary Dataset Specification.

Problem Outcome Category

  • Field Name: Problem_Outcome_Category

  • Required: YES

  • Type: STRING

  • Description: Category of the outcome of the problem in the plan of care.\ See Dictionary Problem Outcome Category table in the Dictionary Dataset Specification.

Problem Outcome Category Description

  • Field Name: Problem_Outcome_Category_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the category of the outcome of the problem in the plan of care.\ See Dictionary Problem Outcome Category table in the Dictionary Dataset Specification.

Problem Other Description

  • Field Name: Problem_Other_Description

  • Required: YES

  • Type: STRING

  • Description: Additional description of the problem in the plan of care if necessary.

Start Date

  • Field Name: Start_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the problem in the plan of care was initiated.

Actual Completion Date

  • Field Name: Actual_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: Actual completion date of the problem in the plan of care.

Target Completion Date

  • Field Name: Target_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: Target completion date of the problem in the plan of care.

Created Timestamp

  • Field Name: Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the problem entry in the plan of care was created.

Last Modified Timestamp

  • Field Name: Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the problem entry in the plan of care was last modified.

Notes

  • Field Name: Notes

  • Required: NO

  • Type: ARRAY

  • Description: Any additional notes or comments related to the plan of care.

Notes Fields

  • Field Name: Notes.Note_Key\ Required: YES\ Type: INT64\ Description: The unique identifier/key for the cost-saving note.

  • Field Name: Notes.Text\ Required: YES\ Type: STRING\ Description: The content or text of the note, providing additional information or comments related to the cost-saving details.

  • Field Name: Notes.Author_User_ID\ Required: YES\ Type: STRING\ Description: The identifier of the user who authored or created the note.

  • Field Name: Notes.Created_Timestamp\ Required: YES\ Type: TIMESTAMP\ Description: The timestamp indicating when the note was initially created.

  • Field Name: Notes.Last_Modified_Timestamp\ Required: YES\ Type: TIMESTAMP\ Description: The timestamp indicating the most recent modification made to the note.

Goals Associated with the Plan of Care

Goals

  • Field Name: Goals

  • Required: NO

  • Type: ARRAY

  • Description: Goals associated with the problem in the plan of care.

Goals Fields

  • Field Name: Goals.Program_Plan_Of_Care_Goal_Key\ Required: YES\ Type: INT64\ Description: Unique identifier for each plan of care goal.\ See Dictionary Goal table in the Dictionary Dataset Specification.

  • Field Name: Goals.Code\ Required: YES\ Type: STRING\ Description: Code representing the goal.

  • Field Name: Goals.Description\ Required: YES\ Type: STRING\ Description: Description of the goal.\ See Dictionary Goal table in the Dictionary Dataset Specification.

  • Field Name: Goals.Other_Description\ Required: YES\ Type: STRING\ Description: Additional description for the goal if available.

  • Field Name: Goals.Type\ Required: YES\ Type: STRING\ Description: Type of the goal.\ See Dictionary Goal Type table in the Dictionary Dataset Specification.

  • Field Name: Goals.Type_Description\ Required: YES\ Type: STRING\ Description: Description of the goal type.\ See Dictionary Goal Type table in the Dictionary Dataset Specification.

  • Field Name: Goals.Start_Date\ Required: YES\ Type: DATE\ Description: Date when the goal was initiated.

  • Field Name: Goals.Actual_Completion_Date\ Required: YES\ Type: DATE\ Description: Actual completion date of the goal.

  • Field Name: Goals.Target_Completion_Date\ Required: YES\ Type: DATE\ Description: Target completion date set for the goal.

  • Field Name: Goals.Outcome\ Required: YES\ Type: STRING\ Description: Outcome of the goal.\ See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

  • Field Name: Goals.Outcome_Description\ Required: YES\ Type: STRING\ Description: Description of the outcome.\ See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

  • Field Name: Goals.Outcome_Category\ Required: YES\ Type: STRING\ Description: Category of the outcome.\ See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

  • Field Name: Goals.Outcome_Category_Description\ Required: YES\ Type: STRING\ Description: Description of the outcome category.\ See Dictionary Goal Outcome Category table in the Dictionary Dataset Specification.

  • Field Name: Goals.Created_Timestamp\ Required: YES\ Type: TIMESTAMP\ Description: Timestamp indicating when the goal was created.

  • Field Name: Goals.Last_Modified_Timestamp\ Required: YES\ Type: TIMESTAMP\ Description: Timestamp indicating when the goal was last modified.

Goal Focuses

  • Field Name: Goals.Focuses

  • Required: NO

  • Type: ARRAY

  • Description: Goal focuses.

Goal Focuses Fields

  • Field Name: Goals.Focuses.Program_Plan_Of_Care_Goal_Focus_Key\ Required: YES\ Type: INT64\ Description: Unique identifier for each program plan of care goal focus.\ See Dictionary Goal Focus table in the Dictionary Dataset Specification.

  • Field Name: Goals.Focuses.Code\ Required: YES\ Type: STRING\ Description: Code representing the program plan of care goal focus.

  • Field Name: Goals.Focuses.Description\ Required: YES\ Type: STRING\ Description: Description of the program plan of care goal focus.\ See Dictionary Goal Focus table in the Dictionary Dataset Specification.

  • Field Name: Goals.Focuses.Created_Timestamp\ Required: YES\ Type: TIMESTAMP\ Description: Timestamp indicating when the program plan of care goal focus was created.

  • Field Name: Goals.Focuses.Last_Modified_Timestamp\ Required: YES\ Type: TIMESTAMP\ Description: Timestamp indicating when the program plan of care goal focus was last modified.

Program Dataset Specification

Program_Plan_Of_Care_raw

Goals.Interventions

  • Goals.Interventions

  • Type: ARRAY

  • Description: Interventions related to the goals.

  • Goals.Interventions.Key

  • Type: INT64

  • Required: YES

  • Description: Unique key of the intervention.

  • Goals.Interventions.Code

  • Type: STRING

  • Required: YES

  • Description: Code representing the goal.

  • Goals.Interventions.Description

  • Type: STRING

  • Required: YES

  • Description: Description of the goal. See Dictionary Goal table in the Dictionary Dataset Specification.

  • Goals.Interventions.Other_Description

  • Type: STRING

  • Required: YES

  • Description: Additional description for the goal if available.

  • Goals.Interventions.Start_Date

  • Type: DATE

  • Required: YES

  • Description: Date when the goal was initiated.

  • Goals.Interventions.Actual_Completion_Date

  • Type: DATE

  • Required: YES

  • Description: Actual completion date of the goal.

  • Goals.Interventions.Target_Completion_Date

  • Type: DATE

  • Required: YES

  • Description: Target completion date set for the goal.

  • Goals.Interventions.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the goal was created.

  • Goals.Interventions.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

  • Goals.Interventions.Engagement

  • Type: STRUCT

  • Required: NO

  • Description: General engagement details related to goals and interventions.

  • Goals.Interventions.Engagement.Emmi

  • Type: STRUCT

  • Required: NO

  • Description: Specific engagement details related to the Emmi program.

  • Goals.Interventions.Engagement.Emmi.Status

  • Type: STRING

  • Required: NO

  • Description: Current status of the engagement within the Emmi program.

  • Goals.Interventions.Engagement.Emmi.Status_Description

  • Type: STRING

  • Required: NO

  • Description: Detailed description of the current status within the Emmi program.

Goals.Engagement

  • Goals.Engagement

  • Type: STRUCT

  • Required: NO

  • Description: Represents engagement details related to a specific goal for a member.

  • Goals.Engagement.Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for the engagement record.

  • Goals.Engagement.Status

  • Type: STRING

  • Required: YES

  • Description: The current status of the engagement, indicating its progress.

  • Goals.Engagement.Status_Description

  • Type: STRING

  • Required: YES

  • Description: A description providing more context on the engagement status.

  • Goals.Engagement.Initiated_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the engagement was initiated or started.

  • Goals.Engagement.Completed_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the engagement was completed.

  • Goals.Engagement.Last_Activity_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp of the last recorded activity related to the engagement.

  • Goals.Engagement.Type

  • Type: STRING

  • Required: YES

  • Description: The type of engagement, categorizing the nature of the activity or interaction.

  • Goals.Engagement.Type_Description

  • Type: STRING

  • Required: YES

  • Description: A detailed description of the engagement type.

  • Goals.Engagement.Code

  • Type: STRING

  • Required: YES

  • Description: A code representing the specific type of engagement.

  • Goals.Engagement.Description

  • Type: STRING

  • Required: YES

  • Description: A detailed description of the engagement and its purpose or focus.

  • Goals.Engagement.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the engagement record was created.

  • Goals.Engagement.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the engagement record was last updated or modified.

Goals.Emmi

  • Goals.Emmi

  • Type: STRUCT

  • Required: NO

  • Description: Contains information related to Emmi (a specific health-related communication) engagement.

  • Goals.Emmi.Member_Email_Address

  • Type: STRING

  • Required: YES

  • Description: The email address of the member associated with the Emmi engagement.

  • Goals.Emmi.Access_Code

  • Type: STRING

  • Required: YES

  • Description: A unique code allowing the member to access the Emmi communication or content.

  • Goals.Emmi.Access_URL

  • Type: STRING

  • Required: YES

  • Description: A URL link that directs the member to the Emmi content or interaction.

  • Goals.Emmi.Target_Date

  • Type: DATE

  • Required: YES

  • Description: The target date for completing the engagement or action related to Emmi.

  • Goals.Emmi.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the Emmi engagement record was created.

  • Goals.Emmi.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the Emmi engagement record was last updated.

Goals.Notes

  • Goals.Notes

  • Type: ARRAY

  • Required: NO

  • Description: Free-text field that includes any notes related to the goal or engagement process.

  • Goals.Notes.Program_Plan_Of_Care_Goal_Intervention_Engagement_Emmi_Note_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for each note related to program plan of care goal intervention engagement.

  • Goals.Notes.Text

  • Type: STRING

  • Required: YES

  • Description: Text content of the note.

  • Goals.Notes.Entry_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the note was entered.

  • Goals.Notes.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the note was created.

  • Goals.Notes.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Goals.Barriers

  • Goals.Barriers

  • Type: ARRAY

  • Required: NO

  • Goals.Barriers.Program_Plan_Of_Care_Goal_Barrier_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for each barrier entry within a program plan of care goal. See Dictionary Barrier table in the Dictionary Dataset Specification.

  • Goals.Barriers.Code

  • Type: STRING

  • Required: YES

  • Description: Code representing the barrier.

Program Dataset Specification

Program Plan of Care Raw

Goals.Barriers.Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the barrier. See Dictionary Barrier table in the Dictionary Dataset Specification.

Goals.Barriers.Other_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description if the barrier is not covered by the predefined codes.

Goals.Barriers.Identification_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the barrier was identified.

Goals.Barriers.Resolution_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the barrier was resolved.

Goals.Barriers.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the barrier entry was created.

Goals.Barriers.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification time of the barrier entry.

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: Unique identifier for the user who performed the transaction related to the plan of care.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of record or transaction related to the plan of care.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant information associated with the plan of care.

Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Active version of the plan of care.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the plan of care.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the plan of care.

Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system providing data for the plan of care.

Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the data was sourced for the plan of care.

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file containing data for the plan of care.

Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Schema version of the dataset.

Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition information associated with the member.

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the record is deleted or not.

_updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the record is updated or not.

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Questionnaire Program Question Response Comparison

Program_Enrollment_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the enrollment program associated with the question response comparison.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the program associated with the question response comparison. See Dictionary Program table in the Dictionary Dataset Specification.

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the question response comparison.

Enrollment_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Program name or code for the enrollment associated with the question response comparison.

Enrollment_Program_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the program for the enrollment associated with the question response comparison.

Enrollment_Product

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Product name or code for the enrollment associated with the question response comparison. See Dictionary Product table in the Dictionary Dataset Specification.

Enrollment_Product_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the product for the enrollment associated with the question response comparison. See Dictionary Product table in the Dictionary Dataset Specification.

Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the question associated with the response comparison.

Program_Enrollment_Start_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Start date of the enrollment program associated with the question response comparison.

Program_Close_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Close date of the enrollment program associated with the question response comparison.

Program_Close_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for closing the enrollment program associated with the question response comparison. See Dictionary Program Close Reason table in the Dictionary Dataset Specification.

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Class of the question associated with the response comparison.

Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the class of the question associated with the response comparison.

Full_Question_Clinical

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full clinical description of the question associated with the response comparison.

Short_Question

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Short description or abbreviation of the question associated with the response comparison.

Question_Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title of the report containing the question associated with the response comparison.

Question_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the question associated with the response comparison.

Program Dataset Specification

Questionnaire Program Question Response Comparison

Question Response Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of response expected for the question associated with the response comparison.

Question Display Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Display type of the question associated with the response comparison.

Question Response Type Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the response type expected for the question associated with the response comparison.

Question Response Value Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Value type of the response for the question associated with the response comparison.

Question Response Value Type Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the value type of the response for the question associated with the response comparison.

First Response Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the first response for the question associated with the response comparison.

First Response Value Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text value of the first response for the question associated with the response comparison.

First Response Value Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date value of the first response for the question associated with the response comparison.

First Response Value Number

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Numeric value of the first response for the question associated with the response comparison.

Latest Response Value Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text value of the latest response for the question associated with the response comparison.

Latest Response Value Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date value of the latest response for the question associated with the response comparison.

Latest Response Value Number

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Numeric value of the latest response for the question associated with the response comparison.

Latest Response Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the latest response for the question associated with the response comparison.

Days Count Between First and Last Responses

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days between the first and latest responses for the question associated with the response comparison.

One Response Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying if there is only one response for the question associated with the response comparison.

Program Provider Roles

Program Provider Roles Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the program provider roles entry.

Program Provider Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the program provider associated with the roles.

Program ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the program associated with the provider roles. See Dictionary Program table in the Dictionary Dataset Specification.

Provider ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the provider associated with the roles.

Provider NPI

  • Is Nullable: YES

  • Data Type: STRING

  • Description: National Provider Identifier (NPI) of the provider associated with the roles.

Primary

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying if the role is primary for the provider.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the provider roles entry was created.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the provider roles entry was last modified.

Role Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the role of the provider within the program. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

Role Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the role of the provider within the program. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

Role Effective Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Effective date of the provider's role within the program.

Role Termination Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Termination date of the provider's role within the program, if applicable.

Role Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the provider's role entry was created.

Role Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the provider's role entry was last modified.

Screening

Screening Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key associated with the screening.

First Screening Owner ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the first screening owner.

First Screening Owner Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the first screening owner.

First Screening Owner Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the first screening owner (calculated based on Program LOG data within each enrolled program ID).

Screening Owner ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the screening owner.

Screening Owner Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the screening owner.

Screening Owner Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the screening owner (calculated based on Program LOG data within each enrolled program ID).

Previous Screening Owner ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the previous screening owner.

Previous Screening Owner Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the previous screening owner.

Previous Screening Owner Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the previous screening owner (calculated based on Program LOG data within each enrolled program ID).

First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Set to true for the first historical record within a program.

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Set to true for the latest historical record within a program.

Program Dataset Specification

Table: Screening Ownership

Column Name

Is Nullable

Data Type

Description

Effective_Timestamp

YES

TIMESTAMP

Timestamp indicating the effectiveness of the screening ownership.

Transaction_User_ID

YES

STRING

ID of the user associated with the transaction.

Transaction_User_Name

YES

STRING

Name of the user associated with the transaction.

Deleted_Indicator

YES

BOOL

Indicator used to filter deleted records.

Table: Screening Entry

Column Name

Is Nullable

Data Type

Description

Screening_Key

YES

INT64

Unique identifier for the screening entry.

Screening_Reopen_Date

YES

DATE

Date when the screening was reopened.

Screening_Reopen_Reason

YES

STRING

Reason for reopening the screening.

Screening_Reopen_Reason_Description

YES

STRING

Detailed description of the reason for reopening the screening.

Table: Screening Details

Column Name

Is Nullable

Data Type

Description

Screening_Key

YES

INT64

Unique key associated with the screening.

Program_ID

YES

STRING

Identifier of the program. See Dictionary Program table in the Dictionary Dataset Specification.

Social_Problem_Code_1

YES

BOOL

Indicates whether there is a value for Social_Problems.Code for the first social problem.

Social_Problem_Code_2

YES

BOOL

Indicates whether there is a value for Social_Problems.Code for the second social problem.

Social_Problem_Code_3

YES

BOOL

Indicates whether there is a value for Social_Problems.Code for the third social problem.

Social_Problem_Code_4

YES

BOOL

Indicates whether there is a value for Social_Problems.Code for the fourth social problem.

Social_Problem_Code_5

YES

BOOL

Indicates whether there is a value for Social_Problems.Code for the fifth social problem.

Social_Problem_Code_6

YES

BOOL

Indicates whether there is a value for Social_Problems.Code for the sixth social problem.

Social_Problem_Code_7

YES

BOOL

Indicates whether there is a value for Social_Problems.Code for the seventh social problem.

Social_Problem_Code_8

YES

BOOL

Indicates whether there is a value for Social_Problems.Code for the eighth social problem.

Social_Problem_Code_9

YES

BOOL

Indicates whether there is a value for Social_Problems.Code for the ninth social problem.

Social_Problems_Selected

YES

STRING

Comma-separated descriptions for all valued Social_Problems.Description based on Social_Problems.Key.

Table: Program Workflow Steps

Column Name

Is Nullable

Data Type

Description

Program_ID

YES

STRING

Unique identifier for the program associated with the steps.

Screening_Key

YES

INT64

Key or identifier for the screening process linked to the program.

Step

YES

STRING

Identifier for a specific step within the program's workflow.

Step_Description

YES

STRING

Detailed description of the step within the program's workflow.

State

YES

STRING

Current state or status of the step (e.g., active, completed).

State_Description

YES

STRING

Detailed description of the state or status of the step.

State_Last_Modified_User_ID

YES

STRING

ID of the user who last modified the state of the step.

State_Last_Modified_User_Name

YES

STRING

Name of the user who last modified the state of the step.

State_Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the state of the step was initially created.

State_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the state of the step was last updated.

Table: Program Log Entry

Column Name

Is Nullable

Data Type

Description

Member_ID

YES

STRING

Identifier for the member associated with the program log entry.

Screening_Request_Key

YES

INT64

Unique identifier for the screening request.

Screening_Request_Date

YES

DATE

Date when the screening request was made.

Behavioral_Health

YES

BOOL

Indicator for whether the screening is related to behavioral health.

Program_Designation

YES

STRING

A code or identifier representing the designation of the program.

Program_Designation_Description

YES

STRING

A detailed description of the program designation.

Program_Type

YES

STRING

A code or identifier representing the type of program.

Program_Type_Description

YES

STRING

A detailed description of the program type.

External_Program_ID

YES

STRING

An external identifier for the program, possibly used by other systems or vendors.

External_Program_Vendor_Code

YES

STRING

A code identifying the external vendor associated with the program, if applicable.

Current_Step

YES

STRING

An identifier or code representing the current step in the program process.

Current_Step_Description

YES

STRING

A detailed description of the current step in the program process.

Current_State

YES

STRING

A code or identifier representing the current state of the program.

Current_State_Description

YES

STRING

A detailed description of the current state of the program.

Digital_Pause_Indicator

YES

BOOL

An indicator showing whether the digital aspects of the program are currently paused.

Digital_Pause_By_Type

YES

STRING

A code or identifier indicating the type of entity that initiated the digital pause.

Digital_Pause_By_Type_Description

YES

STRING

A description of the type of entity that initiated the digital pause.

Digital_Pause_Timestamp

YES

TIMESTAMP

The timestamp when the digital pause was initiated.

Source

YES

STRING

Source of the screening request. See Dictionary Program Source table in the Dictionary Dataset Specification.

Source_Description

YES

STRING

Description of the source of the screening request. See Dictionary Program Source table in the Dictionary Dataset Specification.

Program Dataset Specification

Screening Program

Screening_Program

  • Required: YES

  • Type: STRING

  • Description: Program associated with the screening.

Screening_Program_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the screening program.

Screening_Severity

  • Required: YES

  • Type: STRING

  • Description: Severity level of the screening. See Dictionary Program Severity table in the Dictionary Dataset Specification.

Screening_Severity_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the severity level of the screening. See Dictionary Program Severity table in the Dictionary Dataset Specification.

Screening_Product

  • Required: YES

  • Type: STRING

  • Description: Product associated with the screening. See Dictionary Product table in the Dictionary Dataset Specification.

Screening_Product_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the screening product. See Dictionary Product table in the Dictionary Dataset Specification.

Screening_Request_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the screening request was created.

Screening_Request_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the screening request was last modified.

Providers

Providers

  • Required: NO

  • Type: ARRAY

  • Description: Providers involved in the screening.

Providers.Program_Provider_Key

  • Required: YES

  • Type: INT64

  • Description: The key associated with the provider within the program.

Providers.Program_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the program to which the provider role belongs. See Dictionary Program table in the Dictionary Dataset Specification.

Providers.Provider_Key

  • Required: YES

  • Type: INT64

  • Description: The key or identifier associated with the provider in the system.

Providers.Provider_ID

  • Required: YES

  • Type: STRING

  • Description: The identification number or code assigned to the provider.

Providers.Provider_NPI

  • Required: YES

  • Type: STRING

  • Description: The National Provider Identifier (NPI) of the provider.

Providers.Primary

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the provider holds a primary role within the program.

Providers.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the provider role entry was initially created.

Providers.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the provider role entry.

Providers.Roles

Providers.Roles

  • Required: NO

  • Type: ARRAY

  • Description: Providers' roles.

Providers.Roles.Program_Provider_Role_Key

  • Required: YES

  • Type: INT64

  • Description: The unique key or identifier for the provider role entry in the program's custom provider roles table.

Providers.Roles.Code

  • Required: YES

  • Type: STRING

  • Description: The code associated with the provider role. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

Providers.Roles.Description

  • Required: YES

  • Type: STRING

  • Description: The description or name of the provider role, providing details about the role's responsibilities or functions. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

Providers.Roles.Role_Effective_Date

  • Required: YES

  • Type: DATE

  • Description: The date when the provider assumed or started the role within the program.

Providers.Roles.Role_Termination_Date

  • Required: YES

  • Type: DATE

  • Description: The date when the provider's role within the program was terminated or ended.

Providers.Roles.Role_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the provider role entry was initially created or established.

Providers.Roles.Role_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the provider role entry, including changes to role details such as effective or termination dates.

Screening Details

Screening_Key

  • Required: YES

  • Type: INT64

  • Description: Key identifier for the screening.

Screening_Date

  • Required: YES

  • Type: DATE

  • Description: Date of the screening.

Close_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the screening was closed.

Screening_Status

  • Required: YES

  • Type: STRING

  • Description: Status of the screening. See Dictionary Program Screening Status table in the Dictionary Dataset Specification.

Not_Enrolled_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for not enrolling the member in the program. See Dictionary Not Enrolled Reason table in the Dictionary Dataset Specification.

Not_Enrolled_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the reason for not enrolling the member in the program. See Dictionary Not Enrolled Reason table in the Dictionary Dataset Specification.

Program_ID

  • Required: YES

  • Type: STRING

  • Description: Unique identifier for the program associated with the screening. See Dictionary Program table in the Dictionary Dataset Specification.

Close_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for closing the screening. See Dictionary Program Close Reason table in the Dictionary Dataset Specification.

Close_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the reason for closing the screening. See Dictionary Program Close Reason table in the Dictionary Dataset Specification.

Screening_Owner_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the screening owner.

Screening_Owner_Department_ID

  • Required: YES

  • Type: STRING

  • Description: Department ID of the screening owner.

Screening_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the screening was created.

Screening_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Screener_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the screener.

Screening_Reopen_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the screening was reopened.

Screening_Reopen_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for reopening the screening. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

Screening_Reopen_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the reason for reopening the screening. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

Source_System_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the source system. See Dictionary Source System table in the Dictionary Dataset Specification.

Source_System_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the source system. See Dictionary Source System table in the Dictionary Dataset Specification.

Source_System_Record_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the source system record.

Program_Enrollment_Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the program enrollment.

Program Dataset Specification

Enrollment

Enrollment_Program

  • Required: YES

  • Type: STRING

  • Description: Program associated with the enrollment.

Enrollment_Program_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the enrollment program.

Enrollment_Severity

  • Required: YES

  • Type: STRING

  • Description: Severity level of the enrollment. See Dictionary Program Severity table in the Dictionary Dataset Specification.

Enrollment_Severity_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the severity level of the enrollment. See Dictionary Program Severity table in the Dictionary Dataset Specification.

Enrollment_Product

  • Required: YES

  • Type: STRING

  • Description: Product associated with the enrollment. See Dictionary Product table in the Dictionary Dataset Specification.

Enrollment_Product_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the enrollment product. See Dictionary Product table in the Dictionary Dataset Specification.

Enrollment_Date

  • Required: YES

  • Type: DATE

  • Description: Date of the enrollment.

Enrollment_Start_Date

  • Required: YES

  • Type: DATE

  • Description: Start date of the enrollment.

Enrollment_Reopen_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for reopening the enrollment. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

Enrollment_Reopen_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the reason for reopening the enrollment. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

Enrollment_Reopen_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the enrollment was reopened.

Enroller_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the enroller.

Enrollment_Owner_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the enrollment owner.

Enrollment_Owner_Department_ID

  • Required: YES

  • Type: STRING

  • Description: Department ID of the enrollment owner.

Enrollment_Owner_Department_Name

  • Required: YES

  • Type: STRING

  • Description: Department name of the enrollment owner.

Enrollment_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the enrollment was created.

Enrollment_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Diagnoses

Diagnoses

  • Required: NO

  • Type: ARRAY

  • Description: Diagnoses associated with the program.

Diagnoses.Program_Diagnosis_Key

  • Required: YES

  • Type: INT64

  • Description: The unique key or identifier for the diagnosis entry in the program's diagnoses table.

Diagnoses.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the diagnosis entry was initially created.

Diagnoses.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the diagnosis entry.

Diagnoses.Primary

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the diagnosis is the primary diagnosis for the program.

Diagnoses.Code

  • Required: YES

  • Type: STRING

  • Description: The code representing the diagnosis.

Diagnoses.Description

  • Required: YES

  • Type: STRING

  • Description: The description or name of the diagnosis, providing details about the medical condition or ailment.

Diagnoses.Coding_Scheme

  • Required: YES

  • Type: STRING

  • Description: The coding scheme used for the diagnosis code.

Diagnoses.Coding_Scheme_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the coding scheme used for the diagnosis code.

Diagnoses.Condition_Category

  • Required: YES

  • Type: STRING

  • Description: The category or classification of the medical condition associated with the diagnosis.

Diagnoses.Condition_Category_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the category or classification of the medical condition associated with the diagnosis.

Diagnoses.Sequence

  • Required: YES

  • Type: INT64

  • Description: The sequence number indicating the order of importance or relevance of the diagnosis within the program.

Diagnoses.Axis

  • Required: YES

  • Type: STRING

  • Description: The axis associated with the diagnosis code. See Dictionary Axis table in the Dictionary Dataset Specification.

Diagnoses.Axis_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the axis associated with the diagnosis code. See Dictionary Axis table in the Dictionary Dataset Specification.

Social Problems

Social_Problems

  • Required: NO

  • Type: ARRAY

  • Description: Social problems associated with the program.

Social_Problems.Program_Social_Problem_Key

  • Required: YES

  • Type: INT64

  • Description: Unique key associated with the social problem entry. See Dictionary Axis Social Problem table in the Dictionary Dataset Specification.

Social_Problems.Code

  • Required: YES

  • Type: STRING

  • Description: Code representing the social problem.

Social_Problems.Description

  • Required: YES

  • Type: STRING

  • Description: Description of the social problem. See Dictionary Axis Social Problem table in the Dictionary Dataset Specification.

Social_Problems.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the social problem entry was created.

Social_Problems.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the social problem entry was last modified.

Global Assessment of Functioning

Global_Assessment_of_Functioning

  • Required: NO

  • Type: ARRAY

  • Description: Assessment of the member's global functioning.

Program_Global_Assessment_of_Functioning_Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for each record of global assessment of functioning within the program.

Program_Global_Assessment_of_Functioning_Key.Score

  • Required: YES

  • Type: INT64

  • Description: The score assigned for the global assessment of functioning.

Program_Global_Assessment_of_Functioning_Key.Score_Entry_Date

  • Required: YES

  • Type: DATE

  • Description: The date when the score for the global assessment of functioning was entered.

Program_Global_Assessment_of_Functioning_Key.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date and time when the assessment record was created.

Program_Global_Assessment_of_Functioning_Key.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date and time when the assessment record was last modified.

Custom Fields

Custom_Fields

  • Required: NO

  • Type: ARRAY

  • Description: Custom fields associated with the program.

Custom_Fields.Program_Custom_Field_Key

  • Required: YES

  • Type: INT64

  • Description: The unique key or identifier for the custom field entry in the program's custom fields table.

Custom_Fields.ID

  • Required: YES

  • Type: STRING

  • Description: The identification number or code assigned to the custom field.

Custom_Fields.Title

  • Required: YES

  • Type: STRING

  • Description: The title or name of the custom field, providing a brief description of its purpose or content.

Custom_Fields.Use

  • Required: YES

  • Type: STRING

  • Description: Indicates how the custom field is utilized within the system or application.

Program Dataset Specification

Custom Fields

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the custom field entry was initially created.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the custom field entry.

Values

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Value of the custom field.

Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The value associated with the custom field.

Value Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description or explanation providing additional context for the value of the custom field, especially if the value is not self-explanatory.

Select Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key associated with the selection made in the custom field, if applicable.

Select Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the selection in the custom field was initially created.

Select Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the selection in the custom field.

Notes

Program Note Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each program note entry.

Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content of the note.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the type of note. See Dictionary Note Type table in the Dictionary Dataset Specification.

Type Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the note type. See Dictionary Note Type table in the Dictionary Dataset Specification.

Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

Author User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the author who created the note.

Void Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the note is voided or not.

Void Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was voided.

Void Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding the note. See Dictionary Note Void Reason table in the Dictionary Dataset Specification.

Void Reason Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the reason for voiding the note. See Dictionary Note Void Reason table in the Dictionary Dataset Specification.

Void User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who voided the note.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification time of the note.

Visibility Level

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Level of visibility for the program.

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.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of action or event.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the record.

Active Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Active version of the record.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the record.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the record.

Source System Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system.

Source Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the source system.

Source File Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file.

Deleted Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for whether the record is deleted.

Schema Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema.

Member Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition information for the member.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed on the record.

Last Closed User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last closed or completed the program.

Steps

Step

  • Is Nullable: NO

  • Data Type: STRING

  • Description: An identifier or code for a specific step in the program.

Step Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: A detailed description of the step.

State

  • Is Nullable: NO

  • Data Type: STRING

  • Description: A code or identifier representing the current state of the step.

State Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: A detailed description of the current state of the step.

State Last Modified User ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The user ID of the person who last modified the state of the step.

State Created Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: The timestamp when the state of the step was initially created.

State Last Modified Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: The timestamp when the state of the step was last modified.

Digital

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the screening or enrollment process is digital (e.g., Yes/No).

Enrollment Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of the enrollment (e.g., Active, Inactive, Pending).

Enrollment Reopen User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who reopened the enrollment.

Transaction Actor Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Program Plan of Care Log

Member ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier assigned to the member within the system, crucial for associating the care plan with the correct individual.

Program Enrollment Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Represents the specific enrollment instance of the member in the program, vital for tracking their participation and progress.

Program ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the specific program under which the plan of care is created, linking the care activities to the broader service or treatment plan. See Dictionary Program table in the Dictionary Dataset Specification.

Problem Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key identifying the specific health or care issue addressed within the plan, essential for targeted care management.

Problem

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A concise label or code for the health issue being addressed.

Program Dataset Specification

Program_Plan_Of_Care_log

Problem_Description

  • Required: YES

  • Type: STRING

  • Description: Detailed explanation of the health issue, providing context and clarity for care providers and stakeholders.

  • Reference: See Dictionary Problem table in the Dictionary Dataset Specification.

Problem_Status

  • Required: YES

  • Type: STRING

  • Description: Current status of the health issue, indicating progress, resolution, or ongoing management needs.

  • Reference: See Dictionary Problem Status table in the Dictionary Dataset Specification.

Problem_Status_Description

  • Required: YES

  • Type: STRING

  • Description: Expounds on the status, offering detailed insight into the patient's condition or progress in the care plan.

  • Reference: See Dictionary Problem Status table in the Dictionary Dataset Specification.

Outcome_Code

  • Required: YES

  • Type: STRING

  • Description: A code that represents the expected or achieved outcome for the care plan, helping in evaluating the effectiveness of care.

Problem_Outcome

  • Required: YES

  • Type: STRING

  • Description: Describes the result or impact of the care interventions on the member’s health issue.

  • Reference: See Dictionary Problem Outcome table in the Dictionary Dataset Specification.

Problem_Outcome_Description

  • Required: YES

  • Type: STRING

  • Description: Offers detailed narrative on the outcomes, providing a qualitative measure of care effectiveness.

  • Reference: See Dictionary Problem Outcome table in the Dictionary Dataset Specification.

Problem_Outcome_Category

  • Required: YES

  • Type: STRING

  • Description: Categorizes the outcome to facilitate analysis and reporting on the care provided.

  • Reference: See Dictionary Problem Outcome Category table in the Dictionary Dataset Specification.

Problem_Outcome_Category_Description

  • Required: YES

  • Type: STRING

  • Description: Provides a comprehensive explanation of the category, enriching the understanding of care results.

  • Reference: See Dictionary Problem Outcome Category table in the Dictionary Dataset Specification.

Problem_Other_Description

  • Required: YES

  • Type: STRING

  • Description: Allows for additional notes or details about the problem that may not fit within standard fields, ensuring thorough documentation.

Start_Date

  • Required: YES

  • Type: DATE

  • Description: The date when the care plan or related intervention began, marking the timeline of care delivery.

Actual_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: The date when the care activities were actually completed, critical for tracking the actual duration of care.

Target_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: The planned or expected date for completing the care activities, important for monitoring adherence to care timelines.

Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date and time when the care log record was initially created, important for data management and audit trails.

Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Indicates the most recent update to the care log record, essential for tracking changes and current status.

Notes

  • Required: NO

  • Type: ARRAY

  • Description: Any additional notes or comments related to the plan of care.

Notes.Note_Key

  • Required: YES

  • Type: INT64

  • Description: The unique identifier/key for the cost-saving note.

Notes.Text

  • Required: YES

  • Type: STRING

  • Description: The content or text of the note, providing additional information or comments related to the cost-saving details.

Notes.Author_User_ID

  • Required: YES

  • Type: STRING

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

Notes.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the note was initially created.

Notes.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the note.

Goals

  • Required: NO

  • Type: ARRAY

  • Description: Goals associated with the problem in the plan of care.

Goals.Program_Plan_Of_Care_Goal_Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for each plan of care goal.

  • Reference: See Dictionary Goal table in the Dictionary Dataset Specification.

Goals.Code

  • Required: YES

  • Type: STRING

  • Description: Code representing the goal.

Goals.Description

  • Required: YES

  • Type: STRING

  • Description: Description of the goal.

  • Reference: See Dictionary Goal table in the Dictionary Dataset Specification.

Goals.Other_Description

  • Required: YES

  • Type: STRING

  • Description: Additional description for the goal if available.

Goals.Type

  • Required: YES

  • Type: STRING

  • Description: Type of the goal.

  • Reference: See Dictionary Goal Type table in the Dictionary Dataset Specification.

Goals.Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the goal type.

  • Reference: See Dictionary Goal Type table in the Dictionary Dataset Specification.

Goals.Start_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the goal was initiated.

Goals.Actual_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: Actual completion date of the goal.

Goals.Target_Completion_Date

  • Required: YES

  • Type: DATE

  • Description: Target completion date set for the goal.

Goals.Outcome

  • Required: YES

  • Type: STRING

  • Description: Outcome of the goal.

  • Reference: See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

Goals.Outcome_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the outcome.

  • Reference: See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

Goals.Outcome_Category

  • Required: YES

  • Type: STRING

  • Description: Category of the outcome.

  • Reference: See Dictionary Goal Outcome table in the Dictionary Dataset Specification.

Goals.Outcome_Category_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the outcome category.

  • Reference: See Dictionary Goal Outcome Category table in the Dictionary Dataset Specification.

Goals.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the goal was created.

Goals.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Goals.Focuses

  • Required: NO

  • Type: ARRAY

  • Description: Goal focuses.

Goals.Focuses.Program_Plan_Of_Care_Goal_Focus_Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for each program plan of care goal focus.

  • Reference: See Dictionary Goal Focus table in the Dictionary Dataset Specification.

Goals.Focuses.Code

  • Required: YES

  • Type: STRING

  • Description: Code representing the goal focus.

Program Dataset Specification

Goals

Focuses

  • Goals.Focuses.Description

  • Type: STRING

  • Required: YES

  • Description: Description of the program plan of care goal focus. See Dictionary Goal Focus table in the Dictionary Dataset Specification.

  • Goals.Focuses.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the program plan of care goal focus was created.

  • Goals.Focuses.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the program plan of care goal focus was last modified.

Interventions

  • Goals.Interventions

  • Type: ARRAY

  • Required: NO

  • Description: Interventions related to the goals.

  • Goals.Interventions.Key

  • Type: INT64

  • Required: YES

  • Description: Unique key of the intervention.

  • Goals.Interventions.Code

  • Type: STRING

  • Required: YES

  • Description: Code representing the goal.

  • Goals.Interventions.Description

  • Type: STRING

  • Required: YES

  • Description: Description of the goal. See Dictionary Goal table in the Dictionary Dataset Specification.

  • Goals.Interventions.Other_Description

  • Type: STRING

  • Required: YES

  • Description: Additional description for the goal if available.

  • Goals.Interventions.Start_Date

  • Type: DATE

  • Required: YES

  • Description: Date when the goal was initiated.

  • Goals.Interventions.Actual_Completion_Date

  • Type: DATE

  • Required: YES

  • Description: Actual completion date of the goal.

  • Goals.Interventions.Target_Completion_Date

  • Type: DATE

  • Required: YES

  • Description: Target completion date set for the goal.

  • Goals.Interventions.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the goal was created.

  • Goals.Interventions.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Engagement

  • Goals.Engagement

  • Type: STRUCT

  • Required: NO

  • Description: Represents engagement details related to a specific goal for a member.

  • Goals.Engagement.Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for the engagement record.

  • Goals.Engagement.Status

  • Type: STRING

  • Required: YES

  • Description: The current status of the engagement, indicating its progress.

  • Goals.Engagement.Status_Description

  • Type: STRING

  • Required: YES

  • Description: A description providing more context on the engagement status.

  • Goals.Engagement.Initiated_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the engagement was initiated or started.

  • Goals.Engagement.Completed_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the engagement was completed.

  • Goals.Engagement.Last_Activity_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp of the last recorded activity related to the engagement.

  • Goals.Engagement.Type

  • Type: STRING

  • Required: YES

  • Description: The type of engagement, categorizing the nature of the activity or interaction.

  • Goals.Engagement.Type_Description

  • Type: STRING

  • Required: YES

  • Description: A detailed description of the engagement type.

  • Goals.Engagement.Code

  • Type: STRING

  • Required: YES

  • Description: A code representing the specific type of engagement.

  • Goals.Engagement.Description

  • Type: STRING

  • Required: YES

  • Description: A detailed description of the engagement and its purpose or focus.

  • Goals.Engagement.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the engagement record was created.

  • Goals.Engagement.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the engagement record was last updated or modified.

Emmi

  • Goals.Emmi

  • Type: STRUCT

  • Required: NO

  • Description: Contains information related to Emmi (a specific health-related communication) engagement.

  • Goals.Emmi.Member_Email_Address

  • Type: STRING

  • Required: YES

  • Description: The email address of the member associated with the Emmi engagement.

  • Goals.Emmi.Access_Code

  • Type: STRING

  • Required: YES

  • Description: A unique code allowing the member to access the Emmi communication or content.

  • Goals.Emmi.Access_URL

  • Type: STRING

  • Required: YES

  • Description: A URL link that directs the member to the Emmi content or interaction.

  • Goals.Emmi.Target_Date

  • Type: DATE

  • Required: YES

  • Description: The target date for completing the engagement or action related to Emmi.

  • Goals.Emmi.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the Emmi engagement record was created.

  • Goals.Emmi.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the Emmi engagement record was last updated.

Notes

  • Goals.Notes

  • Type: ARRAY

  • Required: NO

  • Description: Free-text field that includes any notes related to the goal or engagement process.

  • Goals.Notes.Program_Plan_Of_Care_Goal_Intervention_Engagement_Emmi_Note_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for each note related to program plan of care goal intervention engagement.

  • Goals.Notes.Text

  • Type: STRING

  • Required: YES

  • Description: Text content of the note.

  • Goals.Notes.Entry_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the note was entered.

  • Goals.Notes.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the note was created.

  • Goals.Notes.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Barriers

  • Goals.Barriers

  • Type: ARRAY

  • Required: NO

  • Goals.Barriers.Program_Plan_Of_Care_Goal_Barrier_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for each barrier entry within a program plan of care goal. See Dictionary Barrier table in the Dictionary Dataset Specification.

  • Goals.Barriers.Code

  • Type: STRING

  • Required: YES

  • Description: Code representing the barrier.

  • Goals.Barriers.Description

  • Type: STRING

  • Required: YES

  • Description: Description of the barrier. See Dictionary Barrier table in the Dictionary Dataset Specification.

  • Goals.Barriers.Other_Description

  • Type: STRING

  • Required: YES

  • Description: Additional description if the barrier is not covered by the predefined codes.

  • Goals.Barriers.Identification_Date

  • Type: DATE

  • Required: YES

  • Description: Date when the barrier was identified.

  • Goals.Barriers.Resolution_Date

  • Type: DATE

  • Required: YES

  • Description: Date when the barrier was resolved.

  • Goals.Barriers.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the barrier entry was created.

  • Goals.Barriers.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating the last modification time of the barrier entry.

Program Plan of Care Log

  • Program_Plan_Of_Care_Log.Record_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The latest timestamp when any part of the log record was updated, ensuring accurate and current data tracking.

  • Program_Plan_Of_Care_Log.Transaction_User_ID

  • Type: STRING

  • Required: YES

  • Description: Identifier of the user who performed the latest transaction or update on the care log, ensuring accountability and traceability.

  • Program_Plan_Of_Care_Log.Type

  • Type: STRING

  • Required: YES

  • Description: The type or category of the log entry, useful for organizing.

Program Dataset Specification

Program_Plan_Of_Care_Log

Columns and Descriptions

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the specific tenant or administrative domain within which the care log is managed, crucial for data segregation and management.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the log record is the current active version, essential for maintaining data integrity and relevance.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the log entry, often used for reporting and tracking purposes.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A numerical sequence that orders the log entries, useful for chronological sorting and analysis.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the system from which the log data originates, key for integration and data sourcing.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from the source system when the log entry was generated, aiding in synchronization and timeline analysis.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the file from the source system, useful for data tracking and management.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: The version of the data schema to which the log record conforms, important for compatibility and data structure management.

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A partition key used for distributing and managing the dataset efficiently, especially in large-scale data environments.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean flag that indicates whether the log record has been marked for deletion, critical for data cleanliness and accuracy.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A system-generated timestamp or flag indicating when the record was last updated, ensuring data timeliness.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the specific action taken or recorded in the log, providing clarity on the nature of the log entry.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Table Content

General Columns

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the program.

  • Screening_Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key associated with the screening request.

  • Screening_Request_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date of the screening request.

  • Behavioral_Health

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying if the program is related to behavioral health.

  • Program_Designation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier representing the designation of the program.

  • Program_Designation_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the program designation.

  • Program_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier representing the type of program.

  • Program_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the program type.

  • External_Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An external identifier for the program, possibly used by other systems or vendors.

  • External_Program_Vendor_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code identifying the external vendor associated with the program, if applicable.

  • Current_Step

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier or code representing the current step in the program process.

  • Current_Step_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the current step in the program process.

  • Current_State

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier representing the current state of the program.

  • Current_State_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the current state of the program.

  • Digital_Pause_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: An indicator showing whether the digital aspects of the program are currently paused.

  • Digital_Pause_By_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier indicating the type of entity that initiated the digital pause.

  • Digital_Pause_By_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the type of entity that initiated the digital pause.

  • Digital_Pause_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the digital pause was initiated.

  • Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source of the program data. See Dictionary Program Source table in the Dictionary Dataset Specification.

  • Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the data source. See Dictionary Program Source table in the Dictionary Dataset Specification.

  • Screening_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Program associated with the screening.

  • Screening_Program_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the screening program.

  • Screening_Severity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Severity level of the screening. See Dictionary Program Severity table in the Dictionary Dataset Specification.

  • Screening_Severity_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the screening severity. See Dictionary Program Severity table in the Dictionary Dataset Specification.

  • Screening_Product

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Product associated with the screening. See Dictionary Product table in the Dictionary Dataset Specification.

  • Screening_Product_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the screening product. See Dictionary Product table in the Dictionary Dataset Specification.

  • Screening_Request_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the screening request was created.

  • Screening_Request_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the screening request was last modified.

Providers

Columns and Descriptions

  • Providers

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Providers involved in the screening.

  • Providers.Program_Provider_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key associated with the provider within the program.

  • Providers.Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the program to which the provider role belongs. See Dictionary Program table in the Dictionary Dataset Specification.

  • Providers.Provider_Key

  • Is Nullable: YES

  • Data Type: INT

  • Description: The key associated with the provider.

Program Dataset Specification

Providers

Provider Details

  • Provider_ID

  • Required: YES

  • Type: STRING

  • Description: The identification number or code assigned to the provider.

  • Provider_NPI

  • Required: YES

  • Type: STRING

  • Description: The National Provider Identifier (NPI) of the provider.

  • Primary

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the provider holds a primary role within the program.

  • Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the provider role entry was initially created.

  • Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the provider role entry.

Provider Roles

  • Roles

  • Required: NO

  • Type: ARRAY

  • Description: Providers' roles.

Role Details

  • Program_Provider_Role_Key

  • Required: YES

  • Type: INT64

  • Description: The unique key or identifier for the provider role entry in the program's custom provider roles table.

  • Code

  • Required: YES

  • Type: STRING

  • Description: The code associated with the provider role. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

  • Description

  • Required: YES

  • Type: STRING

  • Description: The description or name of the provider role, providing details about the role's responsibilities or functions. See Dictionary Program Provider Role table in the Dictionary Dataset Specification.

  • Role_Effective_Date

  • Required: YES

  • Type: DATE

  • Description: The date when the provider assumed or started the role within the program.

  • Role_Termination_Date

  • Required: YES

  • Type: DATE

  • Description: The date when the provider's role within the program was terminated or ended.

  • Role_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating when the provider role entry was initially created or established.

  • Role_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The timestamp indicating the most recent modification made to the provider role entry, including changes to role details such as effective or termination dates.

Screening

Screening Details

  • Screening_Key

  • Required: YES

  • Type: INT64

  • Description: Key associated with the screening.

  • Screening_Date

  • Required: YES

  • Type: DATE

  • Description: Date of the screening.

  • Close_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the screening was closed.

  • Screening_Status

  • Required: YES

  • Type: STRING

  • Description: Status of the screening. See Dictionary Program Screening Status table in the Dictionary Dataset Specification.

  • Not_Enrolled_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for not enrolling in the program. See Dictionary Not Enrolled Reason table in the Dictionary Dataset Specification.

  • Not_Enrolled_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the reason for not enrolling in the program. See Dictionary Not Enrolled Reason table in the Dictionary Dataset Specification.

  • Program_ID

  • Required: YES

  • Type: STRING

  • Description: Unique identifier for the program. See Dictionary Program table in the Dictionary Dataset Specification.

  • Close_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for closing the program. See Dictionary Program Close Reason table in the Dictionary Dataset Specification.

  • Close_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the reason for closing the program. See Dictionary Program Close Reason table in the Dictionary Dataset Specification.

  • Screening_Owner_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the owner of the screening.

  • Screening_Owner_Department_ID

  • Required: YES

  • Type: STRING

  • Description: Department ID of the owner of the screening.

  • Screening_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the screening was created.

  • Screening_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

  • Screener_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the screener.

  • Screening_Reopen_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the screening was reopened.

  • Screening_Reopen_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for reopening the screening. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

  • Screening_Reopen_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the reason for reopening the screening. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

  • Source_System_ID

  • Required: YES

  • Type: STRING

  • Description: ID of the source system. See Dictionary Source System table in the Dictionary Dataset Specification.

  • Source_System_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the source system. See Dictionary Source System table in the Dictionary Dataset Specification.

  • Source_System_Record_ID

  • Required: YES

  • Type: STRING

  • Description: Record ID of the source system.

Program Enrollment

Enrollment Details

  • Program_Enrollment_Key

  • Required: YES

  • Type: INT64

  • Description: Key associated with the program enrollment.

  • Enrollment_Program

  • Required: YES

  • Type: STRING

  • Description: Program associated with the enrollment.

  • Enrollment_Program_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the enrollment program.

  • Enrollment_Severity

  • Required: YES

  • Type: STRING

  • Description: Severity level of the enrollment. See Dictionary Program Severity table in the Dictionary Dataset Specification.

  • Enrollment_Severity_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the enrollment severity. See Dictionary Program Severity table in the Dictionary Dataset Specification.

  • Enrollment_Product

  • Required: YES

  • Type: STRING

  • Description: Product associated with the enrollment. See Dictionary Product table in the Dictionary Dataset Specification.

  • Enrollment_Product_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the enrollment product. See Dictionary Product table in the Dictionary Dataset Specification.

  • Enrollment_Date

  • Required: YES

  • Type: DATE

  • Description: Date of the enrollment.

  • Enrollment_Start_Date

  • Required: YES

  • Type: DATE

  • Description: Start date of the enrollment.

  • Enrollment_Reopen_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for reopening the enrollment. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

  • Enrollment_Reopen_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the reason for reopening the enrollment. See Dictionary Program Reopen Reason table in the Dictionary Dataset Specification.

  • Enrollment_Reopen_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the enrollment was reopened.

  • Enroller_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the enroller.

  • Enrollment_Owner_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the enrollment owner.

Program Dataset Specification

Enrollment Information

Enrollment Owner

  • Enrollment_Owner_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the owner of the enrollment.

  • Enrollment_Owner_Department_ID

  • Type: STRING

  • Required: YES

  • Description: Department ID of the owner of the enrollment.

Enrollment Timestamps

  • Enrollment_Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the enrollment was created.

  • Enrollment_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Diagnoses

Diagnoses Overview

  • Diagnoses

  • Type: ARRAY

  • Required: NO

  • Description: Diagnoses associated with the program.

Diagnoses Fields

  • Diagnoses.Program_Diagnosis_Key

  • Type: INT64

  • Required: YES

  • Description: The unique key or identifier for the diagnosis entry in the program's diagnoses table.

  • Diagnoses.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating when the diagnosis entry was initially created.

  • Diagnoses.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating the most recent modification made to the diagnosis entry.

  • Diagnoses.Primary

  • Type: BOOL

  • Required: YES

  • Description: Indicates whether the diagnosis is the primary diagnosis for the program.

  • Diagnoses.Code

  • Type: STRING

  • Required: YES

  • Description: The code representing the diagnosis.

  • Diagnoses.Description

  • Type: STRING

  • Required: YES

  • Description: The description or name of the diagnosis, providing details about the medical condition or ailment.

  • Diagnoses.Coding_Scheme

  • Type: STRING

  • Required: YES

  • Description: The coding scheme used for the diagnosis code.

  • Diagnoses.Coding_Scheme_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the coding scheme used for the diagnosis code.

  • Diagnoses.Condition_Category

  • Type: STRING

  • Required: YES

  • Description: The category or classification of the medical condition associated with the diagnosis.

  • Diagnoses.Condition_Category_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the category or classification of the medical condition associated with the diagnosis.

  • Diagnoses.Sequence

  • Type: INT64

  • Required: YES

  • Description: The sequence number indicating the order of importance or relevance of the diagnosis within the program.

  • Diagnoses.Axis

  • Type: STRING

  • Required: YES

  • Description: The axis associated with the diagnosis code. See Dictionary Axis table in the Dictionary Dataset Specification.

  • Diagnoses.Axis_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the axis associated with the diagnosis code. See Dictionary Axis table in the Dictionary Dataset Specification.

Social Problems

Social Problems Overview

  • Social_Problems

  • Type: ARRAY

  • Required: NO

  • Description: Social problems associated with the program.

Social Problems Fields

  • Social_Problems.Program_Social_Problem_Key

  • Type: INT64

  • Required: YES

  • Description: Unique key associated with the social problem entry. See Dictionary Axis Social Problem table in the Dictionary Dataset Specification.

  • Social_Problems.Code

  • Type: STRING

  • Required: YES

  • Description: Code representing the social problem.

  • Social_Problems.Description

  • Type: STRING

  • Required: YES

  • Description: Description of the social problem. See Dictionary Axis Social Problem table in the Dictionary Dataset Specification.

  • Social_Problems.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the social problem entry was created.

  • Social_Problems.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the social problem entry was last modified.

Global Assessment of Functioning

Global Assessment Overview

  • Global_Assessment_of_Functioning

  • Type: ARRAY

  • Required: NO

  • Description: Assessment of the member's global functioning.

Global Assessment Fields

  • Program_Global_Assessment_of_Functioning_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for each record of global assessment of functioning within the program.

  • Program_Global_Assessment_of_Functioning_Key.Score

  • Type: INT64

  • Required: YES

  • Description: The score assigned for the global assessment of functioning.

  • Program_Global_Assessment_of_Functioning_Key.Score_Entry_Date

  • Type: DATE

  • Required: YES

  • Description: The date when the score for the global assessment of functioning was entered.

  • Program_Global_Assessment_of_Functioning_Key.Latest

  • Type: BOOL

  • Required: YES

  • Description: Indicates if the global assessment of functioning is the latest one.

  • Program_Global_Assessment_of_Functioning_Key.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The date and time when the assessment record was created.

  • Program_Global_Assessment_of_Functioning_Key.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The date and time when the assessment record was last modified.

Custom Fields

Custom Fields Overview

  • Custom_Fields

  • Type: ARRAY

  • Required: NO

  • Description: Custom fields associated with the program.

Custom Fields Details

  • Custom_Fields.Program_Custom_Field_Key

  • Type: INT64

  • Required: YES

  • Description: The unique key or identifier for the custom field entry in the program's custom fields table.

  • Custom_Fields.ID

  • Type: STRING

  • Required: YES

  • Description: The identification number or code assigned to the custom field.

  • Custom_Fields.Title

  • Type: STRING

  • Required: YES

  • Description: The title or name of the custom field, providing a brief description of its purpose or content.

  • Custom_Fields.Use

  • Type: STRING

  • Required: YES

  • Description: Indicates how the custom field is utilized within the system or application.

  • Custom_Fields.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating when the custom field entry was initially created.

  • Custom_Fields.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating the most recent modification made to the custom field entry.

Custom Field Values

  • Custom_Fields.Values

  • Type: ARRAY

  • Required: NO

  • Description: Value of the custom field.

  • Custom_Fields.Values.Value

  • Type: STRING

  • Required: YES

  • Description: The value associated with the custom field.

  • Custom_Fields.Values.Value_Description

  • Type: STRING

  • Required: YES

  • Description: A description or explanation providing additional context for the value of the custom field, especially if the value is not self-explanatory.

  • Custom_Fields.Values.Select_Key

  • Type: INT64

  • Required: YES

  • Description: The key associated with the selection made in the custom field, if applicable.

  • Custom_Fields.Values.Select_Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating when the selection in the custom field was initially created.

  • Custom_Fields.Values.Select_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp indicating the most recent modification made to the selection in the custom field.

Notes

Notes Overview

  • Notes

  • Type: ARRAY

  • Required: NO

  • Description: Notes related to the program.

Notes Fields

  • Notes.Program_Note_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for each program note entry.

  • Notes.Text

  • Type: STRING

  • Required: YES

  • Description: The content of the note.

  • Notes.Type

  • Type: STRING

  • Required: YES

  • Description: Indicates the type of note. See Dictionary Note Type table in the Dictionary Dataset Specification.

  • Notes.Type_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the note type.

Program Dataset Specification

Notes

Notes.Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

Notes.Author_User_ID

  • Type: STRING

  • Description: User ID of the author who created the note.

Notes.Void_Indicator

  • Type: BOOL

  • Description: Indicator whether the note is voided or not.

Notes.Void_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the note was voided.

Notes.Void_Reason

  • Type: STRING

  • Description: Reason for voiding the note. See Dictionary Note Void Reason table in the Dictionary Dataset Specification.

Notes.Void_Reason_Description

  • Type: STRING

  • Description: Description of the reason for voiding the note. See Dictionary Note Void Reason table in the Dictionary Dataset Specification.

Notes.Void_User_ID

  • Type: STRING

  • Description: User ID of the user who voided the note.

Notes.Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the note was created.

Notes.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating the last modification time of the note.

Program Details

Visibility_Level

  • Type: INT64

  • Description: Level of visibility for the program.

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.

Type

  • Type: STRING

  • Description: Type of the program.

Tenant

  • Type: STRING

  • Description: Tenant associated with the program.

Active_Version

  • Type: BOOL

  • Description: Active version of the program.

Date

  • Type: DATE

  • Description: Date associated with the program.

Sequence

  • Type: INT64

  • Description: Sequence of the program.

Source_System_Name

  • Type: STRING

  • Description: Name of the source system.

Source_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp associated with the source.

Source_File_Name

  • Type: STRING

  • Description: Name of the source file.

Deleted_Indicator

  • Type: BOOL

  • Description: Indicator specifying if the program is deleted.

Schema_Version

  • Type: FLOAT64

  • Description: Schema version of the program.

Member_Partition

  • Type: INT64

  • Description: Partition associated with the member.

Digital

  • Type: BOOL

  • Description: Indicates whether the screening or enrollment process is digital (e.g., Yes/No).

Enrollment_Status

  • Type: STRING

  • Description: Current status of the enrollment (e.g., Active, Inactive, Pending).

Enrollment_Reopen_User_ID

  • Type: STRING

  • Description: Identifier for the user who reopened the enrollment.

Last_Closed_User_ID

  • Type: STRING

  • Description: The user ID of the person who last closed or completed the program.

Steps

Steps.Step

  • Type: STRING

  • Description: An identifier or code for a specific step in the program.

Steps.Step_Description

  • Type: STRING

  • Description: A detailed description of the step.

Steps.State

  • Type: STRING

  • Description: A code or identifier representing the current state of the step.

Steps.State_Description

  • Type: STRING

  • Description: A detailed description of the current state of the step.

Steps.State_Last_Modified_User_ID

  • Type: STRING

  • Description: The user ID of the person who last modified the state of the step.

Steps.State_Created_Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp when the state of the step was initially created.

Steps.State_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp when the state of the step was last modified.

Transaction Details

Transaction_Actor_Type

  • Type: STRING

  • Description: Type of the actor performing the transaction.

Related Articles
Provider Dataset Specification
Letter Dataset Specification
Interaction Topic Dataset Specification
Members Dataset Specification
Task Dataset Specification
Did this answer your question?