Skip to main content

Standard Date Dataset Specification

Updated over a month ago

Standard Date Dataset Specification

Standard Date Dataset Specification

The Standard Date Dataset Specification is designed to provide a standardized set of date parameters, essential for performing various time-based calculations and analyses. It facilitates precise and uniform time-related operations across different systems and applications.

Key Features

  • Standardized Date Formats: Ensures consistency in how dates are represented and stored, which is crucial for accurate data comparison and aggregation.

  • Date Parameters for Calculations: Includes essential date elements such as day, month, year, and time, allowing for detailed and complex time-based calculations.

  • Time Zone Considerations: Accounts for different time zones to ensure accurate timing across global systems, enhancing the reliability of time-sensitive operations.

This dataset is vital for organizations that rely on precise timing and scheduling in their operations, supporting everything from financial forecasting and project management to historical data analysis and future planning.

Standard Date

Table Structure

Column Name

Is Nullable

Data Type

Description

Current_Date

YES

DATE

The current date in the standard date format.

Tomorrow

YES

DATE

The date for the day following the current date.

Yesterday

YES

DATE

The date for the day preceding the current date.

First_Day_Last_Week

YES

DATE

The date corresponding to the first day of the previous week.

Last_Day_Last_Week

YES

DATE

The date corresponding to the last day of the previous week.

First_Day_Last_Month

YES

DATE

The date for the first day of the previous month.

Last_Day_Last_Month

YES

DATE

The date for the last day of the previous month.

First_Day_Last_Quarter

YES

DATE

The date marking the first day of the previous quarter.

Last_Day_Last_Quarter

YES

DATE

The date marking the last day of the previous quarter.

First_Day_Current_Year

YES

DATE

The date for the first day of the current year.

Last_Day_Current_Year

YES

DATE

The date for the last day of the current year.

First_Day_Last_Year

YES

DATE

The date for the first day of the last year.

Last_Day_Last_Year

YES

DATE

The date for the last day of the last year.

Day_One_Year_Ago

YES

DATE

The date exactly one year prior to the current date.

Day_Two_Year_Ago

YES

DATE

The date exactly two years prior to the current date.

Current_Year

YES

STRING

The current year in string format.

Year_Ten_Years_Ago

YES

STRING

The year that was ten years prior to the current year in string format.

Standard Date Range

Table Structure

Column Name

Is Nullable

Data Type

Description

Date_Range

YES

STRING

A string representation of the date range, typically encompassing a start and end date.

Start_Date

YES

DATE

The starting date and time for the date range, indicating when the period begins.

End_Date

YES

DATE

The ending date and time for the date range, indicating when the period ends.

Non Calendar Year Date Range

Table Structure

Column Name

Is Nullable

Data Type

Description

Year

YES

INT64

The specific year for the date range.

Year_Start_Month

YES

INT64

The month in which the year starts.

Year_Start_Month_Name

YES

STRING

The name of the month in which the year starts.

Year_Start_Date

YES

DATE

The exact start date of the year.

Year_End_Date

YES

DATE

The exact end date of the year.

Quarter

YES

INT64

The specific quarter within the year.

Quarter_Start_Date

YES

DATE

The exact start date of the quarter.

Quarter_End_Date

YES

DATE

The exact end date of the quarter.

Real Time Condition

Table Structure

Column Name

Is Nullable

Data Type

Description

Condition_ID

YES

STRING

A unique identifier for each specific condition or health issue.

Member_ID

YES

STRING

A unique identifier for each individual or member associated with the condition.

Encounter_ID

YES

STRING

Identifies a specific encounter or interaction related to the condition (e.g., clinic visit, hospital admission).

FHIR_String

YES

STRING

Refers to a string value conforming to the Fast Healthcare Interoperability Resources (FHIR) standard.

Code

YES

STRING

Represents a code or classification associated with the condition (e.g., ICD-10 code).

Code_Type

YES

STRING

Indicates the type or system of coding used for the condition code (e.g., ICD-10, SNOMED CT).

Description

NO

ARRAY

A textual description providing additional context or details about the condition.

Clinical_Status

YES

STRING

Describes the current clinical status or state of the condition (e.g., active, resolved, stable).

Clinical_Status_Description

YES

STRING

Provides a detailed explanation or interpretation of the clinical status.

Created_Timestamp

YES

TIMESTAMP

The date and time when the condition record was initially created or documented.

Last_Modified_Timestamp

YES

TIMESTAMP

The most recent date and time when the condition record was modified or updated.

Real Time Condition Sources

Table Structure

Column Name

Is Nullable

Data Type

Description

Condition_ID

YES

STRING

A unique identifier for each specific condition or health issue.

Member_ID

YES

STRING

A unique identifier for each individual or member associated with the condition.

Standard Date Dataset Specification

Real_Time_Condition_Sources

Columns

  • Encounter_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies a specific encounter or interaction related to the condition (e.g., clinic visit, hospital admission).

  • Source_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for the source or origin of the condition data.

  • Source_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to additional information or context related to the source of the condition data.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the condition data was collected or recorded from the specified source.

Real_Time_Encounter

Columns

  • Encounter_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each encounter or interaction between a patient and healthcare provider.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each individual or member associated with the encounter.

  • FHIR_String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A string value conforming to the Fast Healthcare Interoperability Resources (FHIR) standard.

  • Status

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Indicates the current status of the encounter (e.g., planned, in-progress, completed).

  • Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the classification or category associated with the encounter (e.g., outpatient, emergency, etc.).

  • Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A textual description corresponding to the specific class or category assigned to the encounter.

  • Priority

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the priority level assigned to the encounter (e.g., urgent, routine, etc.).

  • Priority_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides a detailed explanation or interpretation of the priority level.

  • Type

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Specifies the type or purpose of the encounter (e.g., wellness visit, follow-up, consultation).

  • Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the purpose or context of the encounter.

  • Service_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the specific type of healthcare service provided during the encounter (e.g., diagnostic, therapeutic).

  • Service_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional details about the type of healthcare service rendered.

  • Start_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the encounter began or was initiated.

  • End_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the encounter concluded or was completed.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when the encounter record was modified or updated.

Real_Time_Encounter_Sources

Columns

  • Encounter_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each encounter or interaction within the system.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the specific member or patient associated with the encounter.

  • Source_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents an identifier for the data source or system that generated the encounter information.

  • Source_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context or details related to the data source (e.g., system name, location).

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Indicates the date and time when the encounter data was generated by the source.

Real_Time_Condition_Log

Columns

  • Condition_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each specific condition or health issue.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each individual or member associated with the condition.

  • Encounter_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies a specific encounter or interaction related to the condition (e.g., clinic visit, hospital admission).

  • FHIR_String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to a string value conforming to the Fast Healthcare Interoperability Resources (FHIR) standard.

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a code or classification associated with the condition (e.g., ICD-10 code).

  • Code_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the type or system of coding used for the condition code (e.g., ICD-10, SNOMED CT).

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A textual description providing additional context or details about the condition.

  • Clinical_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the current clinical status or state of the condition (e.g., active, resolved, stable).

  • Clinical_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides a detailed explanation or interpretation of the clinical status.

  • Sources

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Refers to the sources or origins from which the condition information was obtained.

Sources Array Parameters

  • Source_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents an identifier for the data source or system that generated the encounter information.

  • Source_ADT_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Identifier for the source of the Admission, Discharge, and Transfer (ADT) information.

  • Source_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context or details related to the data source (e.g., system name, location).

  • Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Indicates the date and time when the encounter data was generated by the source.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the specific organizational unit or context within which the condition log operates.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the condition record was initially created or documented.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when the condition record was modified or updated.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the condition log entry.

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

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

Standard Date Dataset Specification

Real_Time_Condition_raw Table

Columns and Descriptions

  • Condition_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each specific condition or health issue.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each individual or member associated with the condition.

  • Encounter_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies a specific encounter or interaction related to the condition (e.g., clinic visit, hospital admission).

  • FHIR_String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to a string value conforming to the Fast Healthcare Interoperability Resources (FHIR) standard.

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a code or classification associated with the condition (e.g., ICD-10 code).

  • Code_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the type or system of coding used for the condition code (e.g., ICD-10, SNOMED CT).

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A textual description providing additional context or details about the condition.

  • Clinical_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the current clinical status or state of the condition (e.g., active, resolved, stable).

  • Clinical_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides a detailed explanation or interpretation of the clinical status.

  • Sources

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Refers to the sources or origins from which the condition information was obtained.

    • Source_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Represents an identifier for the data source or system that generated the encounter information.

    • Source_ADT_ID

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Identifier for the source of the Admission, Discharge, and Transfer (ADT) information.

    • Source_Reference

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Provides additional context or details related to the data source (e.g., system name, location).

    • Timestamp

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Indicates the date and time when the encounter data was generated by the source.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the specific organizational unit or context within which the condition log operates.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the condition record was initially created or documented.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when the condition record was modified or updated.

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific partition or subset of members within the dataset.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the condition log entry.

Real_Time_Encounter_log Table

Columns and Descriptions

  • Encounter_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each encounter or interaction within the system.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the specific member or patient associated with the encounter.

  • FHIR_String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A string representation conforming to the Fast Healthcare Interoperability Resources (FHIR) standard. It may contain relevant health-related information.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the current status of the encounter (e.g., scheduled, in progress, completed, canceled).

  • Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Categorizes the type of encounter (e.g., outpatient, inpatient, emergency).

  • Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional details about the encounter class (e.g., “Emergency” or “Outpatient Clinic”).

  • Priority

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the urgency or priority level of the encounter (e.g., routine, urgent, immediate).

  • Priority_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the meaning or context of the priority level (e.g., “Routine” indicates non-urgent care).

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the purpose or nature of the encounter (e.g., consultation, follow-up, preventive).

  • Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Elaborates on the encounter type (e.g., “Consultation” for specialist advice).

  • Service_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the specific medical service provided during the encounter (e.g., diagnostic, therapeutic).

  • Service_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides details about the service type (e.g., “Diagnostic Imaging” or “Physical Therapy”).

  • Start_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Indicates the date and time when the encounter began.

  • End_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Marks the date and time when the encounter concluded.

  • Sources

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Identifies the sources of data or information contributing to the encounter log.

    • Source_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Represents an identifier for the data source or system that generated the encounter information.

    • Source_ADT_ID

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Identifier for the source of the Admission, Discharge, and Transfer (ADT) information.

    • Source_Reference

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Provides additional context or details related to the data source (e.g., system name, location).

    • Timestamp

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Indicates the date and time when the encounter data was generated by the source.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Denotes the organizational unit or entity associated with the encounter (e.g., hospital, clinic).

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Records the date and time when the encounter log entry was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Captures the most recent modification date and time for the encounter log entry.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Represents a specific date associated with the encounter (e.g., appointment date).

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for a specific partition or subset of members within the dataset.

Standard Date Dataset Specification

Real-Time Encounter Log

Table Name: Real_Time_Encounter_log

  • Column Name: Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific action or event logged in real-time for the condition.

Real-Time Encounter Raw

Table Name: Real_Time_Encounter_raw

Columns and Descriptions

  • Encounter_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each encounter or interaction within the system.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the specific member or patient associated with the encounter.

  • FHIR_String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A string representation conforming to the Fast Healthcare Interoperability Resources (FHIR) standard. It may contain relevant health-related information.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the current status of the encounter (e.g., scheduled, in progress, completed, canceled).

  • Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Categorizes the type of encounter (e.g., outpatient, inpatient, emergency).

  • Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional details about the encounter class (e.g., “Emergency” or “Outpatient Clinic”).

  • Priority

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the urgency or priority level of the encounter (e.g., routine, urgent, immediate).

  • Priority_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the meaning or context of the priority level (e.g., “Routine” indicates non-urgent care).

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the purpose or nature of the encounter (e.g., consultation, follow-up, preventive).

  • Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Elaborates on the encounter type (e.g., “Consultation” for specialist advice).

  • Service_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the specific medical service provided during the encounter (e.g., diagnostic, therapeutic).

  • Service_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides details about the service type (e.g., “Diagnostic Imaging” or “Physical Therapy”).

  • Start_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Indicates the date and time when the encounter began.

  • End_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Marks the date and time when the encounter concluded.

  • Sources

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Identifies the sources of data or information contributing to the encounter log.

    • Sources.Source_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Represents an identifier for the data source or system that generated the encounter information.

    • Sources.Source_ADT_ID

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Identifier for the source of the Admission, Discharge, and Transfer (ADT) information.

    • Sources.Source_Reference

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Provides additional context or details related to the data source (e.g., system name, location).

    • Sources.Timestamp

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Indicates the date and time when the encounter data was generated by the source.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Denotes the organizational unit or entity associated with the encounter (e.g., hospital, clinic).

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Records the date and time when the encounter log entry was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Captures the most recent modification date and time for the encounter log entry.

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Represents a partition or subgroup of members within the dataset (if applicable).

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Represents a specific date associated with the encounter (e.g., appointment date).

    • Standardized Date Formats: Ensures consistency in how dates are represented and stored, which is crucial for accurate data comparison and aggregation.

    • Date Parameters for Calculations: Includes essential date elements such as day, month, year, and time, allowing for detailed and complex time-based calculations.

    • Time Zone Considerations: Accounts for different time zones to ensure accurate timing across global systems, enhancing the reliability of time-sensitive operations.

Standard Date Table

Table Name: Standard_Date

Columns and Descriptions

Column Name

Is Nullable

Data Type

Description

Current_Date

YES

DATE

The current date in the standard date format.

Tomorrow

YES

DATE

The date for the day following the current date.

Yesterday

YES

DATE

The date for the day preceding the current date.

First_Day_Last_Week

YES

DATE

The date corresponding to the first day of the previous week.

Last_Day_Last_Week

YES

DATE

The date corresponding to the last day of the previous week.

First_Day_Last_Month

YES

DATE

The date for the first day of the previous month.

Last_Day_Last_Month

YES

DATE

The date for the last day of the previous month.

First_Day_Last_Quarter

YES

DATE

The date marking the first day of the previous quarter.

Last_Day_Last_Quarter

YES

DATE

The date marking the last day of the previous quarter.

First_Day_Current_Year

YES

DATE

The date for the first day of the current year.

Last_Day_Current_Year

YES

DATE

The date for the last day of the current year.

First_Day_Last_Year

YES

DATE

The date for the first day of the last year.

Last_Day_Last_Year

YES

DATE

The date for the last day of the last year.

Day_One_Year_Ago

YES

DATE

The date exactly one year prior to the current date.

Day_Two_Year_Ago

YES

DATE

The date exactly two years prior to the current date.

Current_Year

YES

STRING

The current year in string format.

Year_Ten_Years_Ago

YES

STRING

The year that was ten years prior to the current year in string format.

Standard Date Range Table

Table Name: Standard_Date_Range

Columns and Descriptions

Column Name

Is Nullable

Data Type

Description

Date_Range

YES

ARRAY

Represents a range of dates for analysis or calculations.

Standard Date Dataset Specification

Standard Date Range

Start Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The starting date and time for the date range, indicating when the period begins.

End Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The ending date and time for the date range, indicating when the period ends.

String Representation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A string representation of the date range, typically encompassing a start and end date.

Non-Calendar Year Date Range

Year

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The specific year for the date range.

Year Start Month

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The month in which the year starts.

Year Start Month Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the month in which the year starts.

Year Start Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The exact start date of the year.

Year End Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The exact end date of the year.

Quarter

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The specific quarter within the year.

Quarter Start Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The exact start date of the quarter.

Quarter End Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The exact end date of the quarter.

Real-Time Condition

Condition ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each specific condition or health issue.

Member ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each individual or member associated with the condition.

Encounter ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies a specific encounter or interaction related to the condition (e.g., clinic visit, hospital admission).

FHIR String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to a string value conforming to the Fast Healthcare Interoperability Resources (FHIR) standard.

Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a code or classification associated with the condition (e.g., ICD-10 code).

Code Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the type or system of coding used for the condition code (e.g., ICD-10, SNOMED CT).

Description

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: A textual description providing additional context or details about the condition.

Clinical Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the current clinical status or state of the condition (e.g., active, resolved, stable).

Clinical Status Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides a detailed explanation or interpretation of the clinical status.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the condition record was initially created or documented.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when the condition record was modified or updated.

Real-Time Condition Sources

Condition ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each specific condition or health issue.

Member ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each individual or member associated with the condition.

Encounter ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies a specific encounter or interaction related to the condition (e.g., clinic visit, hospital admission).

Source ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for the source or origin of the condition data.

Source Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to additional information or context related to the source of the condition data.

Source Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the condition data was collected or recorded from the specified source.

Real-Time Encounter

Encounter ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each encounter or interaction between a patient and healthcare provider.

Member ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each individual or member associated with the encounter.

FHIR String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A string value conforming to the Fast Healthcare Interoperability Resources (FHIR) standard.

Status

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Indicates the current status of the encounter (e.g., planned, in-progress, completed).

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the classification or category associated with the encounter (e.g., outpatient, emergency, etc.).

Class Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A textual description corresponding to the specific class or category assigned to the encounter.

Priority

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the priority level assigned to the encounter (e.g., urgent, routine, etc.).

Priority Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides a detailed explanation or interpretation of the priority level.

Type

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Specifies the type or purpose of the encounter (e.g., wellness visit, follow-up, consultation).

Type Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the purpose or context of the encounter.

Service Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the specific type of healthcare service provided during the encounter (e.g., diagnostic, therapeutic).

Service Type Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional details about the type of healthcare service rendered.

Start Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the encounter began or was initiated.

End Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the encounter concluded or ended.

Standard Date Dataset Specification

Real_Time_Encounter Table

Column Name

Is Nullable

Data Type

Description

Created_Timestamp

YES

TIMESTAMP

The date and time when the encounter record was initially created.

Last_Modified_Timestamp

YES

TIMESTAMP

The most recent date and time when the encounter record was modified or updated.

Real_Time_Encounter_Sources Table

Column Name

Is Nullable

Data Type

Description

Encounter_ID

YES

STRING

A unique identifier for each encounter or interaction within the system.

Member_ID

YES

STRING

Identifies the specific member or patient associated with the encounter.

Source_ID

YES

STRING

Represents an identifier for the data source or system that generated the encounter information.

Source_Reference

YES

STRING

Provides additional context or details related to the data source (e.g., system name, location).

Source_Timestamp

YES

TIMESTAMP

Indicates the date and time when the encounter data was generated by the source.

Real_Time_Condition_log Table

Column Name

Is Nullable

Data Type

Description

Condition_ID

YES

STRING

A unique identifier for each specific condition or health issue.

Member_ID

YES

STRING

A unique identifier for each individual or member associated with the condition.

Encounter_ID

YES

STRING

Identifies a specific encounter or interaction related to the condition (e.g., clinic visit, hospital admission).

FHIR_String

YES

STRING

Refers to a string value conforming to the Fast Healthcare Interoperability Resources (FHIR) standard.

Code

YES

STRING

Represents a code or classification associated with the condition (e.g., ICD-10 code).

Code_Type

YES

STRING

Indicates the type or system of coding used for the condition code (e.g., ICD-10, SNOMED CT).

Description

YES

STRING

A textual description providing additional context or details about the condition.

Clinical_Status

YES

STRING

Describes the current clinical status or state of the condition (e.g., active, resolved, stable).

Clinical_Status_Description

YES

STRING

Provides a detailed explanation or interpretation of the clinical status.

Sources

NO

ARRAY

Refers to the sources or origins from which the condition information was obtained. See below for detailed information on each parameter in the Array.

Tenant

YES

STRING

Specifies the specific organizational unit or context within which the condition log operates.

Created_Timestamp

YES

TIMESTAMP

The date and time when the condition record was initially created or documented.

Last_Modified_Timestamp

YES

TIMESTAMP

The most recent date and time when the condition record was modified or updated.

Date

YES

DATE

The date associated with the condition log entry.

Member_Partition

YES

INT64

Identifier for the partition or segment of the member data.

Action

YES

STRING

Specific action or event logged in real-time for the condition.

Sources Array Parameters

Parameter Name

Is Nullable

Data Type

Description

Sources.Source_ID

YES

STRING

Represents an identifier for the data source or system that generated the encounter information.

Sources.Source_ADT_ID

NO

STRING

Identifier for the source of the Admission, Discharge, and Transfer (ADT) information.

Sources.Source_Reference

YES

STRING

Provides additional context or details related to the data source (e.g., system name, location).

Sources.Timestamp

YES

TIMESTAMP

Indicates the date and time when the encounter data was generated by the source.

Real_Time_Condition_raw Table

Column Name

Is Nullable

Data Type

Description

Condition_ID

YES

STRING

A unique identifier for each specific condition or health issue.

Member_ID

YES

STRING

A unique identifier for each individual or member associated with the condition.

Encounter_ID

YES

STRING

Identifies a specific encounter or interaction related to the condition (e.g., clinic visit, hospital admission).

FHIR_String

YES

STRING

Refers to a string value conforming to the Fast Healthcare Interoperability Resources (FHIR) standard.

Code

YES

STRING

Represents a code or classification associated with the condition (e.g., ICD-10 code).

Code_Type

YES

STRING

Indicates the type or system of coding used for the condition code (e.g., ICD-10, SNOMED CT).

Description

YES

STRING

A textual description providing additional context or details about the condition.

Clinical_Status

YES

STRING

Describes the current clinical status or state of the condition (e.g., active, resolved, stable).

Clinical_Status_Description

YES

STRING

Provides a detailed explanation or interpretation of the clinical status.

Sources

NO

ARRAY

Refers to the sources or origins from which the condition information was obtained. See below for detailed information on each parameter in the Array.

Sources Array Parameters

Parameter Name

Is Nullable

Data Type

Description

Sources.Source_ID

YES

STRING

Represents an identifier for the data source or system that generated the encounter information.

Sources.Source_ADT_ID

NO

STRING

Identifier for the source of the Admission, Discharge, and Transfer (ADT) information.

Sources.Source_Reference

YES

STRING

Provides additional context or details related to the data source (e.g., system name, location).

Sources.Timestamp

YES

TIMESTAMP

Indicates the date and time when the encounter data was generated by the source.

Standard Date Dataset Specification

Real_Time_Condition_raw Table

Columns

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the specific organizational unit or context within which the condition log operates.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the condition record was initially created or documented.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when the condition record was modified or updated.

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific partition or subset of members within the dataset.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the condition log entry.

Real_Time_Encounter_log Table

Columns

  • Encounter_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each encounter or interaction within the system.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the specific member or patient associated with the encounter.

  • FHIR_String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A string representation conforming to the Fast Healthcare Interoperability Resources (FHIR) standard. It may contain relevant health-related information.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the current status of the encounter (e.g., scheduled, in progress, completed, canceled).

  • Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Categorizes the type of encounter (e.g., outpatient, inpatient, emergency).

  • Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional details about the encounter class (e.g., “Emergency” or “Outpatient Clinic”).

  • Priority

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the urgency or priority level of the encounter (e.g., routine, urgent, immediate).

  • Priority_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the meaning or context of the priority level (e.g., “Routine” indicates non-urgent care).

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the purpose or nature of the encounter (e.g., consultation, follow-up, preventive).

  • Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Elaborates on the encounter type (e.g., “Consultation” for specialist advice).

  • Service_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the specific medical service provided during the encounter (e.g., diagnostic, therapeutic).

  • Service_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides details about the service type (e.g., “Diagnostic Imaging” or “Physical Therapy”).

  • Start_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Indicates the date and time when the encounter began.

  • End_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Marks the date and time when the encounter concluded.

  • Sources

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Identifies the sources of data or information contributing to the encounter log.

Sources Array Parameters

  • Source_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents an identifier for the data source or system that generated the encounter information.

  • Source_ADT_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Identifier for the source of the Admission, Discharge, and Transfer (ADT) information.

  • Source_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context or details related to the data source (e.g., system name, location).

  • Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Indicates the date and time when the encounter data was generated by the source.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Denotes the organizational unit or entity associated with the encounter (e.g., hospital, clinic).

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Records the date and time when the encounter log entry was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Captures the most recent modification date and time for the encounter log entry.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Represents a specific date associated with the encounter (e.g., appointment date).

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the partition or segment of the member data.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific action or event logged in real-time for the condition.

Real_Time_Encounter_raw Table

Columns

  • Encounter_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each encounter or interaction within the system.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the specific member or patient associated with the encounter.

  • FHIR_String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A string representation conforming to the Fast Healthcare Interoperability Resources (FHIR) standard. It may contain relevant health-related information.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the current status of the encounter (e.g., scheduled, in progress, completed, canceled).

  • Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Categorizes the type of encounter (e.g., outpatient, inpatient, emergency).

  • Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional details about the encounter class (e.g., “Emergency” or “Outpatient Clinic”).

  • Priority

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the urgency or priority level of the encounter (e.g., routine, urgent, immediate).

  • Priority_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the meaning or context of the priority level (e.g., “Routine” indicates non-urgent care).

Standard Date Dataset Specification

Real_Time_Encounter_raw Fields

Priority_Level

  • Type: STRING

  • Required: YES

  • Description: Specifies the priority level of the encounter (e.g., “Routine” indicates non-urgent care).

Type

  • Type: STRING

  • Required: YES

  • Description: Specifies the purpose or nature of the encounter (e.g., consultation, follow-up, preventive).

Type_Description

  • Type: STRING

  • Required: YES

  • Description: Elaborates on the encounter type (e.g., “Consultation” for specialist advice).

Service_Type

  • Type: STRING

  • Required: YES

  • Description: Refers to the specific medical service provided during the encounter (e.g., diagnostic, therapeutic).

Service_Type_Description

  • Type: STRING

  • Required: YES

  • Description: Provides details about the service type (e.g., “Diagnostic Imaging” or “Physical Therapy”).

Start_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Indicates the date and time when the encounter began.

End_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Marks the date and time when the encounter concluded.

Sources

  • Type: ARRAY

  • Required: NO

  • Description: Identifies the sources of data or information contributing to the encounter log. See below for detailed information on each parameter in the array.

Sources.Source_ID

  • Type: STRING

  • Required: YES

  • Description: Represents an identifier for the data source or system that generated the encounter information.

Sources.Source_ADT_ID

  • Type: STRING

  • Required: NO

  • Description: Identifier for the source of the Admission, Discharge, and Transfer (ADT) information.

Sources.Source_Reference

  • Type: STRING

  • Required: YES

  • Description: Provides additional context or details related to the data source (e.g., system name, location).

Sources.Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Indicates the date and time when the encounter data was generated by the source.

Tenant

  • Type: STRING

  • Required: YES

  • Description: Denotes the organizational unit or entity associated with the encounter (e.g., hospital, clinic).

Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Records the date and time when the encounter log entry was created.

Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Captures the most recent modification date and time for the encounter log entry.

Member_Partition

  • Type: INT64

  • Required: YES

  • Description: Represents a partition or subgroup of members within the dataset (if applicable).

Date

  • Type: DATE

  • Required: YES

  • Description: Represents a specific date associated with the encounter (e.g., appointment date).

Related Articles
Condition Dataset Specification
Dictionary Dataset Specification
Dictionary Dataset Specification D L
Attachment Dataset Specification
Dictionary Dataset Specification M Q
Did this answer your question?