Skip to main content

Calendar Dataset Specification

Updated over a month ago

Calendar Dataset Specification

Calendar Dataset Specification

The "Calendar Dataset Specification" is designed to manage and organize scheduling and availability within healthcare systems, adhering to strict healthcare standards for operational efficiency, privacy, and data security. This dataset facilitates the management of healthcare appointments, provider availability, and event tracking, ensuring seamless coordination across clinical and administrative workflows.

Overview

This dataset includes the following key tables:

Calendar

  • Serves as the central table for managing the scheduling of healthcare-related events, such as patient appointments, medical procedures, and team meetings.

  • Helps ensure that all scheduling activities are coordinated, reducing conflicts and optimizing resource allocation.

Calendar Availability

  • Stores information about the availability of healthcare providers and resources (e.g., examination rooms, equipment).

  • Essential for ensuring that appointments and procedures are scheduled based on the real-time availability of required personnel and facilities.

Calendar Event

  • Tracks detailed information about each scheduled event, including the event type, participants (patients, healthcare providers), time, and location.

  • Ensures that all relevant data for each healthcare interaction is documented and accessible.

Calendar Event Log

  • Maintains a detailed history of updates and changes to calendar events.

  • Provides a comprehensive audit trail, ensuring transparency and accountability by tracking who made changes to events and when those changes occurred.

Calendar Log

  • Captures changes to the overall calendar structure, including modifications to general settings or scheduling rules.

  • Critical for maintaining the integrity of the scheduling system and ensuring that updates are properly documented.

Calendar Raw

  • Contains unprocessed data related to the overall calendar and scheduling entries.

  • Supports in-depth analysis, research, and audit processes by providing a complete view of calendar activities in their original form.

Calendar Event Raw

  • Stores unprocessed, detailed data for individual calendar events.

  • Allows for granular analysis of event details, which can be used for research, compliance audits, or operational improvements.

Importance

This dataset is essential for healthcare organizations that need to efficiently manage and track scheduling, availability, and event history. It supports the coordination of care, improves workflow efficiency, and ensures compliance with healthcare regulations and standards related to patient privacy and data integrity.

Table Specifications

Calendar

Column Name

Is Nullable

Data Type

Description

Calendar_Key

YES

INT64

Unique identifier for the calendar.

Name

YES

STRING

Name of the calendar.

Custom_Fields_Text

YES

STRING

Text containing custom fields associated with the calendar.

Owner_User_ID

YES

STRING

Unique identifier for the user who owns the calendar.

Created_Timestamp

YES

TIMESTAMP

Timestamp when the calendar was created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when the calendar was last modified.

Calendar Availability

Column Name

Is Nullable

Data Type

Description

Calendar_Key

YES

INT64

The unique identifier for the calendar entry associated with the availability.

Day_Of_Week

YES

STRING

Specifies the day of the week for which the availability is being recorded.

Available_Times

YES

STRING

Indicates the time intervals during which the calendar is available on the specified day of the week.

Calendar Event

Column Name

Is Nullable

Data Type

Description

Calendar_Event_Key

YES

INT64

The unique identifier for the specific calendar event.

Calendar_Event_ID

YES

STRING

The external or user-defined identifier for the calendar event.

Calendar_Key

YES

INT64

The unique identifier of the calendar to which the event belongs.

Calendar_Name

YES

STRING

The name of the calendar associated with the event.

Calendar_Event_Type_Key

YES

INT64

The unique identifier for the type of the calendar event.

Calendar_Owner_User_ID

YES

STRING

The user identifier of the calendar owner who created or manages the event.

Member_ID

YES

STRING

The unique identifier for the member associated with the event.

Title

YES

STRING

The title or name of the calendar event.

Description

YES

STRING

A description or additional information regarding the calendar event.

Location

YES

STRING

The location where the calendar event takes place, if applicable.

Custom_Fields_Text

YES

STRING

Custom-defined fields for additional information about the calendar event.

Start_Timestamp

YES

TIMESTAMP

The timestamp indicating when the calendar event starts.

End_Timestamp

YES

TIMESTAMP

The timestamp indicating when the calendar event ends.

Event_Type

YES

STRING

The type or category of the calendar event.

Event_Type_Description

YES

STRING

A description of the type of the calendar event.

Event_Type_Custom_Fields_Text

YES

STRING

Custom-defined fields specific to the event type.

Event_Type_Padding_Before

YES

INT64

The amount of time, in minutes, reserved before the event for preparation or padding.

Event_Type_Padding_After

YES

INT64

The amount of time, in minutes, reserved after the event for wrap-up or padding.

Status

YES

STRING

The current status of the calendar event (e.g., Scheduled, Canceled).

Status_Description

YES

STRING

A description of the event’s current status.

Created_Timestamp

YES

TIMESTAMP

The timestamp indicating when the calendar event was created.

Calendar Dataset Specification

Calendar Event Log

Columns

  • Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the calendar event was last modified.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the calendar event.

  • Calendar_Event_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key for the calendar event.

  • Calendar_Event_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the calendar event.

  • Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title of the calendar event.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the calendar event.

  • Location

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Location where the calendar event will take place.

  • Custom_Fields_Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom fields related to the calendar event in text format.

  • Start_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Start timestamp of the calendar event.

  • End_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: End timestamp of the calendar event.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the calendar event was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the calendar event was last modified.

  • Calendar

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Struct containing calendar details.

  • Fields:

    • Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Unique key for the calendar.

    • Name

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Name of the calendar.

    • Owner_User_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Identifier for the owner user of the calendar.

  • Event_Type

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Struct containing event type details.

  • Fields:

    • Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Unique key for the event type.

    • Description

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Description of the event type.

    • Internal_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Internal identifier for the event type.

    • Custom_Fields_Text

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Custom fields related to the event type in text format.

    • Padding_Before

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Padding time before the event in minutes.

    • Padding_After

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Padding time after the event in minutes.

  • Status_Internal_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Internal identifier for the event status.

  • Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the event status.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the calendar event.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the calendar event.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the calendar event is the active version.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date of the calendar event.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the calendar event.

  • 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 when the data was sourced.

  • 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 whether the calendar event 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 number for the member associated with the calendar event.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating the last update of the calendar event record.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed on the calendar event.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Calendar Log

Columns

  • Calendar_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the calendar entry.

  • Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the calendar entry.

  • Availability

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: General availability status of the calendar entry.

  • Fields:

    • Day_Of_Week

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Specific days of the week when the calendar entry is available.

    • Available_Times

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Specific times during the day when the calendar entry is available.

  • Custom_Fields_Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text containing custom fields related to the calendar entry.

  • Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the owner of the calendar entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the calendar entry was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the calendar entry was last modified.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the calendar entry.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant identifier associated with the calendar entry.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the version of the calendar entry is active.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the calendar entry.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number for the calendar entry.

  • 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 from 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 of whether the calendar entry has been deleted.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the calendar entry.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action associated with the calendar entry.

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition information for the member.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Update information for the calendar entry.

Calendar Raw

Columns

  • Calendar_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the calendar entry.

  • Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the calendar entry.

  • Availability

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: General availability status of the calendar entry.

  • Fields:

    • Day_Of_Week

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Specific days of the week when the calendar entry is available.

    • Available_Times

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Specific times during the day when the calendar entry is available.

Calendar Dataset Specification

Calendar Table

Serves as the central table for managing the scheduling of healthcare-related events, such as patient appointments, medical procedures, and team meetings. It helps ensure that all scheduling activities are coordinated, reducing conflicts and optimizing resource allocation.

Columns

  • Availability.Available_Times

  • Data Type: STRING

  • Nullable: NO

  • Description: Specific times during the day when the calendar entry is available.

  • Custom_Fields_Text

  • Data Type: STRING

  • Nullable: YES

  • Description: Text containing custom fields related to the calendar entry.

  • Owner_User_ID

  • Data Type: STRING

  • Nullable: YES

  • Description: User ID of the owner of the calendar entry.

  • Created_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: Timestamp when the calendar entry was created.

  • Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: Timestamp when the calendar entry was last modified.

  • Record_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Data Type: STRING

  • Nullable: YES

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

  • Type

  • Data Type: STRING

  • Nullable: YES

  • Description: Type of the calendar entry.

  • Tenant

  • Data Type: STRING

  • Nullable: YES

  • Description: Tenant identifier associated with the calendar entry.

  • Active_Version

  • Data Type: BOOL

  • Nullable: YES

  • Description: Indicates whether the version of the calendar entry is active.

  • Date

  • Data Type: DATE

  • Nullable: YES

  • Description: Date associated with the calendar entry.

  • Sequence

  • Data Type: INT64

  • Nullable: YES

  • Description: Sequence number for the calendar entry.

  • Source_System_Name

  • Data Type: STRING

  • Nullable: YES

  • Description: Name of the source system.

  • Source_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: Timestamp from the source system.

  • Source_File_Name

  • Data Type: STRING

  • Nullable: YES

  • Description: Name of the source file.

  • Deleted_Indicator

  • Data Type: BOOL

  • Nullable: YES

  • Description: Indicator of whether the calendar entry has been deleted.

  • Schema_Version

  • Data Type: FLOAT64

  • Nullable: YES

  • Description: Version of the schema used for the calendar entry.

  • Member_Partition

  • Data Type: INT64

  • Nullable: YES

  • Description: Partition information for the member.

  • _updated

  • Data Type: STRING

  • Nullable: YES

  • Description: Update information for the calendar entry.

Calendar Availability Table

Stores information about the availability of healthcare providers and resources (e.g., examination rooms, equipment). This table is essential for ensuring that appointments and procedures are scheduled based on the real-time availability of required personnel and facilities.

Calendar Event Table

Tracks detailed information about each scheduled event, including the event type, participants (patients, healthcare providers), time, and location. This table ensures that all relevant data for each healthcare interaction is documented and accessible.

Columns

  • Member_ID

  • Data Type: STRING

  • Nullable: YES

  • Description: Unique identifier for the member associated with the calendar event.

  • Calendar_Event_Key

  • Data Type: INT64

  • Nullable: YES

  • Description: Unique key for the calendar event.

  • Calendar_Event_ID

  • Data Type: STRING

  • Nullable: YES

  • Description: Unique identifier for the calendar event.

  • Title

  • Data Type: STRING

  • Nullable: YES

  • Description: Title of the calendar event.

  • Description

  • Data Type: STRING

  • Nullable: YES

  • Description: Description of the calendar event.

  • Location

  • Data Type: STRING

  • Nullable: YES

  • Description: Location where the calendar event will take place.

  • Custom_Fields_Text

  • Data Type: STRING

  • Nullable: YES

  • Description: Custom fields related to the calendar event in text format.

  • Start_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: Start timestamp of the calendar event.

  • End_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: End timestamp of the calendar event.

  • Created_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: Timestamp when the calendar event was created.

  • Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: Timestamp when the calendar event was last modified.

  • Calendar

  • Data Type: STRUCT

  • Nullable: YES

  • Description: Struct containing details about the calendar.

  • Fields:

    • Key: INT64, Unique key for the calendar.

    • Name: STRING, Name of the calendar.

    • Owner_User_ID: STRING, User ID of the owner of the calendar.

  • Event_Type

  • Data Type: STRUCT

  • Nullable: YES

  • Description: Struct containing details about the event type.

  • Fields:

    • Key: INT64, Unique key for the event type.

    • Description: STRING, Description of the event type.

    • Internal_ID: STRING, Internal identifier for the event type.

    • Custom_Fields_Text: STRING, Custom fields related to the event type in text format.

    • Padding_Before: INT64, Padding time before the event starts, in minutes.

    • Padding_After: INT64, Padding time after the event ends, in minutes.

  • Status_Internal_ID

  • Data Type: STRING

  • Nullable: YES

  • Description: Internal identifier for the event status.

  • Status_Description

  • Data Type: STRING

  • Nullable: YES

  • Description: Description of the event status.

  • Record_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Data Type: STRING

  • Nullable: YES

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

  • Type

  • Data Type: STRING

  • Nullable: YES

  • Description: Type of the calendar event.

  • Tenant

  • Data Type: STRING

  • Nullable: YES

  • Description: Tenant identifier associated with the calendar event.

  • Active_Version

  • Data Type: BOOL

  • Nullable: YES

  • Description: Indicates whether the version of the calendar event is active.

  • Date

  • Data Type: DATE

  • Nullable: YES

  • Description: Date associated with the calendar event.

  • Sequence

  • Data Type: INT64

  • Nullable: YES

  • Description: Sequence number for the calendar event.

  • Source_System_Name

  • Data Type: STRING

  • Nullable: YES

  • Description: Name of the source system.

  • Source_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: Timestamp from the source system.

  • Source_File_Name

  • Data Type: STRING

  • Nullable: YES

  • Description: Name of the source file.

  • Deleted_Indicator

  • Data Type: BOOL

  • Nullable: YES

  • Description: Indicator of whether the calendar event has been deleted.

  • Member_Partition

  • Data Type: INT64

  • Nullable: YES

  • Description: Partition information for the member.

  • Schema_Version

  • Data Type: FLOAT64

  • Nullable: YES

  • Description: Version of the schema used for the calendar event.

  • _updated

  • Data Type: STRING

  • Nullable: YES

  • Description: Update information for the calendar event.

  • Transaction_Actor_Type

  • Data Type: STRING

  • Nullable: YES

  • Description: Type of the actor performing the transaction.

Calendar Event Log Table

Maintains a detailed history of updates and changes to calendar events. This log provides a comprehensive record of modifications, ensuring traceability and accountability.

Calendar Dataset Specification

Overview

The calendar dataset is designed to ensure transparency, accountability, and in-depth analysis of scheduling activities. It includes various logs and raw data tables that capture changes, unprocessed data, and detailed event information.

Key Components

  • Audit Trail: Ensures transparency and accountability by tracking who made changes to events and when those changes occurred.

  • Calendar Log: Captures changes to the overall calendar structure, including modifications to general settings or scheduling rules. This log is critical for maintaining the integrity of the scheduling system and ensuring that updates are properly documented.

  • Calendar Raw: Contains unprocessed data related to the overall calendar and scheduling entries. This raw data supports in-depth analysis, research, and audit processes by providing a complete view of calendar activities in their original form.

  • Calendar Event Raw: Stores unprocessed, detailed data for individual calendar events. This table allows for the granular analysis of event details, which can be used for research, compliance audits, or operational improvements.

Table Specifications

Calendar Table

Table Name

Column Name

Is Nullable

Data Type

Description

Calendar

Calendar_Key

YES

INT64

Unique identifier for the calendar.

Calendar

Name

YES

STRING

Name of the calendar.

Calendar

Custom_Fields_Text

YES

STRING

Text containing custom fields associated with the calendar.

Calendar

Owner_User_ID

YES

STRING

Unique identifier for the user who owns the calendar.

Calendar

Created_Timestamp

YES

TIMESTAMP

Timestamp when the calendar was created.

Calendar

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when the calendar was last modified.

Calendar Availability Table

Table Name

Column Name

Is Nullable

Data Type

Description

Calendar_Availability

Calendar_Key

YES

INT64

The unique identifier for the calendar entry associated with the availability.

Calendar_Availability

Day_Of_Week

YES

STRING

Specifies the day of the week for which the availability is being recorded.

Calendar_Availability

Available_Times

YES

STRING

Indicates the time intervals during which the calendar is available on the specified day of the week.

Calendar Event Table

Table Name

Column Name

Is Nullable

Data Type

Description

Calendar_Event

Calendar_Event_Key

YES

INT64

The unique identifier for the specific calendar event.

Calendar_Event

Calendar_Event_ID

YES

STRING

The external or user-defined identifier for the calendar event.

Calendar_Event

Calendar_Key

YES

INT64

The unique identifier of the calendar to which the event belongs.

Calendar_Event

Calendar_Name

YES

STRING

The name of the calendar associated with the event.

Calendar_Event

Calendar_Event_Type_Key

YES

INT64

The unique identifier for the type of the calendar event.

Calendar_Event

Calendar_Owner_User_ID

YES

STRING

The user identifier of the calendar owner who created or manages the event.

Calendar_Event

Member_ID

YES

STRING

The unique identifier for the member associated with the event.

Calendar_Event

Title

YES

STRING

The title or name of the calendar event.

Calendar_Event

Description

YES

STRING

A description or additional information regarding the calendar event.

Calendar_Event

Location

YES

STRING

The location where the calendar event takes place, if applicable.

Calendar_Event

Custom_Fields_Text

YES

STRING

Custom-defined fields for additional information about the calendar event.

Calendar_Event

Start_Timestamp

YES

TIMESTAMP

The timestamp indicating when the calendar event starts.

Calendar_Event

End_Timestamp

YES

TIMESTAMP

The timestamp indicating when the calendar event ends.

Calendar_Event

Event_Type

YES

STRING

The type or category of the calendar event.

Calendar_Event

Event_Type_Description

YES

STRING

A description of the type of the calendar event.

Calendar_Event

Event_Type_Custom_Fields_Text

YES

STRING

Custom-defined fields specific to the event type.

Calendar_Event

Event_Type_Padding_Before

YES

INT64

The amount of time, in minutes, reserved before the event for preparation or padding.

Calendar_Event

Event_Type_Padding_After

YES

INT64

The amount of time, in minutes, reserved after the event for wrap-up or padding.

Calendar_Event

Status

YES

STRING

The current status of the calendar event (e.g., Scheduled, Canceled).

Calendar_Event

Status_Description

YES

STRING

A description of the event’s current status.

Calendar_Event

Created_Timestamp

YES

TIMESTAMP

The timestamp indicating when the calendar event was created.

Calendar_Event

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp indicating when the calendar event was last modified.

Calendar Event Log Table

Table Name

Column Name

Is Nullable

Data Type

Description

Calendar_Event_log

Member_ID

YES

STRING

Unique identifier for the member associated with the calendar event.

Calendar_Event_log

Calendar_Event_Key

YES

INT64

Unique key for the calendar event.

Calendar_Event_log

Calendar_Event_ID

YES

STRING

Unique identifier for the calendar event.

Calendar_Event_log

Title

YES

STRING

Title of the calendar event.

Calendar_Event_log

Description

YES

STRING

Description of the calendar event.

Calendar_Event_log

Location

YES

STRING

Location where the calendar event will take place.

Calendar_Event_log

Custom_Fields_Text

YES

STRING

Custom fields related to the calendar event in text format.

Calendar_Event_log

Start_Timestamp

YES

TIMESTAMP

Start timestamp of the calendar event.

Calendar_Event_log

End_Timestamp

YES

TIMESTAMP

End timestamp of the calendar event.

Calendar_Event_log

Created_Timestamp

YES

TIMESTAMP

Timestamp when the calendar event was created.

Calendar_Event_log

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when the calendar event was last modified.

Calendar_Event_log

Calendar

YES

STRUCT

Struct containing calendar details.

Calendar Dataset Specification

Calendar

Calendar Attributes

  • Calendar_Key

  • Data Type: INT64

  • Description: Unique key for the calendar.

  • Calendar.Name

  • Data Type: STRING

  • Description: Name of the calendar.

  • Calendar.Owner_User_ID

  • Data Type: STRING

  • Description: Identifier for the owner user of the calendar.

Calendar Event Log

Event Type

  • Event_Type.Key

  • Data Type: INT64

  • Description: Unique key for the event type.

  • Event_Type.Description

  • Data Type: STRING

  • Description: Description of the event type.

  • Event_Type.Internal_ID

  • Data Type: STRING

  • Description: Internal identifier for the event type.

  • Event_Type.Custom_Fields_Text

  • Data Type: STRING

  • Description: Custom fields related to the event type in text format.

  • Event_Type.Padding_Before

  • Data Type: INT64

  • Description: Padding time before the event in minutes.

  • Event_Type.Padding_After

  • Data Type: INT64

  • Description: Padding time after the event in minutes.

Event Log Attributes

  • Status_Internal_ID

  • Data Type: STRING

  • Description: Internal identifier for the event status.

  • Status_Description

  • Data Type: STRING

  • Description: Description of the event status.

  • Record_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction.

  • Type

  • Data Type: STRING

  • Description: Type of the calendar event.

  • Tenant

  • Data Type: STRING

  • Description: Tenant associated with the calendar event.

  • Active_Version

  • Data Type: BOOL

  • Description: Indicator whether the calendar event is the active version.

  • Date

  • Data Type: DATE

  • Description: Date of the calendar event.

  • Sequence

  • Data Type: INT64

  • Description: Sequence number of the calendar event.

  • Source_System_Name

  • Data Type: STRING

  • Description: Name of the source system.

  • Source_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the data was sourced.

  • Source_File_Name

  • Data Type: STRING

  • Description: Name of the source file.

  • Deleted_Indicator

  • Data Type: BOOL

  • Description: Indicator whether the calendar event is deleted.

  • Schema_Version

  • Data Type: FLOAT64

  • Description: Version of the schema.

  • Member_Partition

  • Data Type: INT64

  • Description: Partition number for the member associated with the calendar event.

  • _updated

  • Data Type: STRING

  • Description: Timestamp indicating the last update of the calendar event record.

  • Action

  • Data Type: STRING

  • Description: Action performed on the calendar event.

  • Transaction_Actor_Type

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Calendar Log

Log Attributes

  • Calendar_Key

  • Data Type: INT64

  • Description: Unique identifier for the calendar entry.

  • Name

  • Data Type: STRING

  • Description: Name of the calendar entry.

  • Availability

  • Data Type: ARRAY

  • Description: General availability status of the calendar entry.

  • Availability.Day_Of_Week

    • Data Type: STRING

    • Description: Specific days of the week when the calendar entry is available.

  • Availability.Available_Times

    • Data Type: STRING

    • Description: Specific times during the day when the calendar entry is available.

  • Custom_Fields_Text

  • Data Type: STRING

  • Description: Text containing custom fields related to the calendar entry.

  • Owner_User_ID

  • Data Type: STRING

  • Description: User ID of the owner of the calendar entry.

  • Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the calendar entry was created.

  • Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the calendar entry was last modified.

  • Record_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Data Type: STRING

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

  • Type

  • Data Type: STRING

  • Description: Type of the calendar entry.

  • Tenant

  • Data Type: STRING

  • Description: Tenant identifier associated with the calendar entry.

  • Active_Version

  • Data Type: BOOL

  • Description: Indicates whether the version of the calendar entry is active.

  • Date

  • Data Type: DATE

  • Description: Date associated with the calendar entry.

  • Sequence

  • Data Type: INT64

  • Description: Sequence number for the calendar entry.

  • Source_System_Name

  • Data Type: STRING

  • Description: Name of the source system.

  • Source_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp from the source system.

  • Source_File_Name

  • Data Type: STRING

  • Description: Name of the source file.

  • Deleted_Indicator

  • Data Type: BOOL

  • Description: Indicator of whether the calendar entry has been deleted.

  • Schema_Version

  • Data Type: FLOAT64

  • Description: Version of the schema used for the calendar entry.

  • Action

  • Data Type: STRING

  • Description: Action associated with the calendar entry.

  • Member_Partition

  • Data Type: INT64

  • Description: Partition information for the member.

  • _updated

  • Data Type: STRING

  • Description: Update information for the calendar entry.

Calendar Raw

Raw Attributes

  • Calendar_Key

  • Data Type: INT64

  • Description: Unique identifier for the calendar entry.

  • Name

  • Data Type: STRING

  • Description: Name of the calendar entry.

  • Availability

  • Data Type: ARRAY

  • Description: General availability status of the calendar entry.

  • Availability.Day_Of_Week

    • Data Type: STRING

    • Description: Specific days of the week when the calendar entry is available.

  • Availability.Available_Times

    • Data Type: STRING

    • Description: Specific times during the day when the calendar entry is available.

  • Custom_Fields_Text

  • Data Type: STRING

  • Description: Text containing custom fields related to the calendar entry.

  • Owner_User_ID

  • Data Type: STRING

  • Description: User ID of the owner of the calendar entry.

  • Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the calendar entry was created.

  • Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the calendar entry was last modified.

Calendar Dataset Specification

Calendar_raw Table

Columns

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the calendar entry.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant identifier associated with the calendar entry.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the version of the calendar entry is active.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the calendar entry.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number for the calendar entry.

  • 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 from 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 of whether the calendar entry has been deleted.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the calendar entry.

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition information for the member.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Update information for the calendar entry.

Calendar_Event_raw Table

Columns

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the calendar event.

  • Calendar_Event_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key for the calendar event.

  • Calendar_Event_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the calendar event.

  • Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title of the calendar event.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the calendar event.

  • Location

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Location where the calendar event will take place.

  • Custom_Fields_Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom fields related to the calendar event in text format.

  • Start_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Start timestamp of the calendar event.

  • End_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: End timestamp of the calendar event.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the calendar event was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the calendar event was last modified.

  • Calendar

    • Is Nullable: YES

    • Data Type: STRUCT

    • Description: Struct containing details about the calendar.

    Calendar Struct

    • Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Unique key for the calendar.

    • Name

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Name of the calendar.

    • CalendarOwner_User_ID

    • Is Nullable: YES

    • Data Type: STRING

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

    • Event_Type

    • Is Nullable: YES

    • Data Type: STRUCT

    • Description: Struct containing details about the event type.

    Event_Type Struct

    • Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Unique key for the event type.

    • Description

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Description of the event type.

    • Internal_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Internal identifier for the event type.

    • Custom_Fields_Text

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Custom fields related to the event type in text format.

    • Padding_Before

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Padding time before the event starts, in minutes.

    • Padding_After

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Padding time after the event ends, in minutes.

    • Status_Internal_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Internal identifier for the event status.

    • Status_Description

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Description of the event status.

    • Record_Last_Modified_Timestamp

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp when the record was last modified.

    • Transaction_User_ID

    • Is Nullable: YES

    • Data Type: STRING

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

    • Type

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Type of the calendar event.

    • Tenant

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Tenant identifier associated with the calendar event.

    • Active_Version

    • Is Nullable: YES

    • Data Type: BOOL

    • Description: Indicates whether the version of the calendar event is active.

    • Date

    • Is Nullable: YES

    • Data Type: DATE

    • Description: Date associated with the calendar event.

    • Sequence

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Sequence number for the calendar event.

    • 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 from 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 of whether the calendar event has been deleted.

    • Member_Partition

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Partition information for the member.

    • Schema_Version

    • Is Nullable: YES

    • Data Type: FLOAT64

    • Description: Version of the schema used for the calendar event.

    • _updated

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Update information for the calendar event.

    • Transaction_Actor_Type

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Type of the actor performing the transaction.

Related Articles
Condition Dataset Specification
Letter Dataset Specification
Member App Dataset Specification
Fax Dataset Specification
Activity Stream Entry Dataset Specification
Did this answer your question?