Skip to main content

Educational Material Dataset Specification

Updated over a month ago

Educational Material Dataset Specification

Educational Material Dataset Specification

The "Educational Material Dataset Specification" is designed to manage and distribute educational resources within healthcare systems, adhering to healthcare-specific standards for content accuracy, accessibility, and compliance. This dataset is essential for providing patients, caregivers, and healthcare professionals with reliable educational content to support health literacy, informed decision-making, and patient engagement.

Overview

This dataset includes the following key tables:

Educational Material

  • Stores detailed information about each piece of educational content, including titles, descriptions, formats (e.g., articles, videos, guides), and the intended audience.

  • Ensures that healthcare organizations can offer tailored and relevant health education materials to patients and staff.

Educational Material Tags

  • Contains metadata tags associated with each educational material, such as health topics, conditions, or target groups.

  • Facilitates easy searching, categorization, and retrieval of content, ensuring that users can quickly find materials relevant to their needs.

Educational Material Log

  • Tracks changes, updates, and interactions related to the educational materials, providing a detailed audit trail.

  • Essential for maintaining version control, ensuring that all modifications are documented and that the latest, most accurate information is available.

Educational Material Raw

  • Holds unprocessed, detailed data related to the educational materials, including original formats and metadata before any transformations or updates.

  • Crucial for in-depth analysis, auditing, and research into the effectiveness of the educational materials provided.

This dataset is vital for healthcare organizations aiming to improve patient education, health literacy, and the distribution of accurate healthcare information. By managing educational materials efficiently, healthcare providers can better engage patients, enhance compliance with treatment plans, and support preventive health strategies.

Table Specifications

Educational Material

Column Name

Is Nullable

Data Type

Description

Educational_Material_Key

YES

INT64

Unique identifier for the educational material record in the system.

Educational_Material_ID

YES

STRING

Identifier for the specific piece of educational material, used to track and reference it.

Member_ID

YES

STRING

Unique identifier for the member associated with the educational material.

Program_Screening_Key

YES

INT64

Key linking the educational material to a specific program screening or assessment process.

Program_ID

YES

STRING

Identifier for the program under which the educational material is provided.

Program

YES

STRING

Name of the program associated with the educational material.

Program_Description

YES

STRING

Textual description of the program, providing more context about its purpose or content.

Material_Name

YES

STRING

Title or name of the educational material being provided.

Educational_Provider_Content_ID

YES

STRING

Identifier for the content provided by an external educational provider.

Educational_Provider_Content_Format_Type

YES

STRING

The format type of the educational content, such as video, document, or interactive module.

Educational_Provider_Content_Format_Type_Description

YES

STRING

A description of the content format type, providing further details about how the material is presented.

Automated_Source

YES

STRING

Indicates whether the educational material was generated or selected automatically by the system (e.g., via an algorithm or rule-based system).

Status

YES

STRING

Status of the educational material, indicating its availability or completion (e.g., active, archived, completed).

Status_Description

YES

STRING

Textual description of the status, offering additional context or detail about the current state of the educational material.

Source

YES

STRING

The origin or source of the educational material, such as an internal department or an external provider.

Source_Description

YES

STRING

A detailed description of the source, explaining where the educational material originates from.

Content_URL

YES

STRING

Web link or URL to access the educational material online.

Content_Duration_Minutes

YES

INT64

Duration of the educational material in minutes, applicable for media such as videos or audio content.

Created_User_ID

YES

STRING

Identifier for the user who created the educational material record.

Created_User_Name

YES

STRING

Name of the user who created the educational material record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the educational material record was created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating the last time the educational material record was modified.

Educational Material Tags

Column Name

Is Nullable

Data Type

Description

Educational_Material_Tag_Key

YES

INT64

Unique identifier for the tag associated with the educational material.

Educational_Material_Key

YES

INT64

Unique key that links the tag to the corresponding educational material record.

Value

YES

STRING

The actual tag or keyword assigned to the educational material, used for categorization, filtering, or search purposes.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the tag was created or assigned to the educational material.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating the last time the tag was modified.

Educational Material Dataset Specification

Educational Material Log Table

Columns and Descriptions

  • Educational_Material_Key

  • Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the educational material associated with the log entry.

  • Member_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member interacting with the educational material.

  • Program_Screening_Key

  • Nullable: YES

  • Data Type: INT64

  • Description: Key linking the educational material to a specific program screening or assessment process.

  • Program_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program under which the educational material is provided.

  • Program

  • Nullable: YES

  • Data Type: STRING

  • Description: Name of the program associated with the educational material.

  • Program_Description

  • Nullable: YES

  • Data Type: STRING

  • Description: Description of the program, providing more details about its content or purpose.

  • Educational_Material_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the specific piece of educational material, used to track and reference it.

  • Automated_Source

  • Nullable: YES

  • Data Type: STRING

  • Description: Indicator specifying whether the educational material was selected automatically by the system (e.g., based on rules or an algorithm).

  • Educational_Provider_Content

    • Nullable: YES

    • Data Type: STRUCT

    • Description: Contains information about the content provided by the educational provider.

    Educational Provider Content Fields

    • Content_ID

    • Nullable: YES

    • Data Type: STRING

    • Description: Identifier for the specific content provided by the educational provider.

    • Format_Type

    • Nullable: YES

    • Data Type: STRING

    • Description: Format type of the educational content, such as video, document, or interactive material.

    • Format_Type_Description

    • Nullable: YES

    • Data Type: STRING

    • Description: Description of the content format, explaining how the educational material is presented (e.g., multimedia, text).

    • Status

    • Nullable: YES

    • Data Type: STRING

    • Description: Status of the educational material, indicating its current state (e.g., active, completed, archived).

    • Status_Description

    • Nullable: YES

    • Data Type: STRING

    • Description: Detailed description of the status, offering further information about the material's state.

    • Created_Timestamp

    • Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the educational material log was created.

    • Last_Modified_Timestamp

    • Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating the last time the educational material log entry was modified.

    • Content_Duration_Minutes

    • Nullable: YES

    • Data Type: INT64

    • Description: The duration of the educational material in minutes, relevant for content such as videos or audio.

    • Name

    • Nullable: YES

    • Data Type: STRING

    • Description: Name or title of the educational material.

    • Source

    • Nullable: YES

    • Data Type: STRING

    • Description: The origin or source of the educational material, such as an internal department or external provider.

    • Source_Description

    • Nullable: YES

    • Data Type: STRING

    • Description: Description of the source, providing more context about where the educational material originates from.

    • Content_URL

    • Nullable: YES

    • Data Type: STRING

    • Description: URL or web link to the educational material.

    • Created_User_ID

    • Nullable: YES

    • Data Type: STRING

    • Description: Identifier for the user who created the educational material log entry.

    • Tags

    • Nullable: NO

    • Data Type: ARRAY

    • Description: Contains information about the tags or keywords associated with the educational material.

    Tags Fields

    • Key

    • Nullable: NO

    • Data Type: INT64

    • Description: Unique identifier for the tag associated with the educational material.

    • Value

    • Nullable: NO

    • Data Type: STRING

    • Description: The actual tag or keyword assigned to the educational material for categorization or filtering purposes.

    • Created_Timestamp

    • Nullable: NO

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the tag was created or assigned.

    • Last_Modified_Timestamp

    • Nullable: NO

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating the last time the tag was modified.

    • Record_Last_Modified_Timestamp

    • Nullable: YES

    • Data Type: TIMESTAMP

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

    • Transaction_User_ID

    • Nullable: YES

    • Data Type: STRING

    • Description: Identifier for the user who performed the last transaction or modification on the educational material log entry.

    • Type

    • Nullable: YES

    • Data Type: STRING

    • Description: The type or category of the educational material (e.g., educational video, document).

    • Tenant

    • Nullable: YES

    • Data Type: STRING

    • Description: Identifier for the tenant or instance managing the educational material, usually for multi-tenant systems.

    • Active_Version

    • Nullable: YES

    • Data Type: BOOL

    • Description: Indicates whether the current version of the educational material is active.

    • Date

    • Nullable: YES

    • Data Type: DATE

    • Description: The date associated with the educational material, such as when it was accessed or modified.

    • Sequence

    • Nullable: YES

    • Data Type: INT64

    • Description: Sequence number, representing the order in which the educational material log entries were created or processed.

    • Source_System_Name

    • Nullable: YES

    • Data Type: STRING

    • Description: The name of the source system from which the educational material or log originated.

    • Source_Timestamp

    • Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp when the educational material or log entry was received from the source system.

    • Source_File_Name

    • Nullable: YES

    • Data Type: STRING

    • Description: The file name associated with the source system’s content, if applicable.

    • Deleted_Indicator

    • Nullable: YES

    • Data Type: BOOL

    • Description: Boolean indicator showing whether the educational material log has been marked for deletion.

    • Schema_Version

    • Nullable: YES

    • Data Type: FLOAT64

    • Description: Version of the schema used for the educational material log, indicating structural changes or updates.

    • Member_Partition

    • Nullable: YES

    • Data Type: INT64

    • Description: Identifier for the partition where the member's data is stored, useful in systems where data is distributed across multiple partitions.

    • Action

    • Nullable: YES

    • Data Type: STRING

    • Description: Specific action related to the educational material log entry, indicating what event or action has occurred.

    • Transaction_Actor_Type

    • Nullable: YES

    • Data Type: STRING

    • Description: Type of the actor performing the transaction or modification related to the educational material log entry.

Educational Material Dataset Specification

Overview

The Educational Material dataset stores detailed information about each piece of educational content, including titles, descriptions, formats (e.g., articles, videos, guides), and the intended audience. This table ensures that healthcare organizations can offer tailored and relevant health education.

Table: Educational_Material_raw

Columns

Educational_Material_Key

  • Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the educational material entry in the raw dataset.

Member_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the educational material.

Program_Screening_Key

  • Nullable: YES

  • Data Type: INT64

  • Description: Key linking the educational material to a specific program screening or assessment process.

Program_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program under which the educational material is provided.

Program

  • Nullable: YES

  • Data Type: STRING

  • Description: Name of the program associated with the educational material.

Program_Description

  • Nullable: YES

  • Data Type: STRING

  • Description: Description of the program, providing additional details about its content or purpose.

Educational_Material_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the specific piece of educational material in the raw data.

Automated_Source

  • Nullable: YES

  • Data Type: STRING

  • Description: Indicator showing whether the educational material was selected automatically by the system.

Educational_Provider_Content

  • Nullable: YES

  • Data Type: STRUCT

  • Description: Contains information about the content provided by an educational provider.

Educational_Provider_Content.Content_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the specific content provided by the educational provider.

Educational_Provider_Content.Format_Type

  • Nullable: YES

  • Data Type: STRING

  • Description: Format type of the educational content, such as video, document, or interactive material.

Educational_Provider_Content.Format_Type_Description

  • Nullable: YES

  • Data Type: STRING

  • Description: Description of the content format, explaining the presentation type (e.g., multimedia, text).

Status

  • Nullable: YES

  • Data Type: STRING

  • Description: Status of the educational material, such as whether it is active, completed, or archived.

Status_Description

  • Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the current status of the educational material.

Created_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the educational material was created in the raw dataset.

Last_Modified_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the educational material was last modified.

Content_Duration_Minutes

  • Nullable: YES

  • Data Type: INT64

  • Description: The duration of the educational material in minutes, relevant for content like videos or audio.

Name

  • Nullable: YES

  • Data Type: STRING

  • Description: Name or title of the educational material.

Source

  • Nullable: YES

  • Data Type: STRING

  • Description: The origin or source of the educational material, such as an internal department or external provider.

Source_Description

  • Nullable: YES

  • Data Type: STRING

  • Description: Additional description of the source, providing context about where the educational material originated from.

Content_URL

  • Nullable: YES

  • Data Type: STRING

  • Description: URL or web link to access the educational material online.

Created_User_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the educational material in the raw dataset.

Tags

  • Nullable: NO

  • Data Type: ARRAY

  • Description: Contains information about the tags or keywords assigned to the educational material.

Tags.Key

  • Nullable: NO

  • Data Type: INT64

  • Description: Unique key identifying the tag associated with the educational material.

Tags.Value

  • Nullable: NO

  • Data Type: STRING

  • Description: The actual tag or keyword assigned to the educational material, used for categorization or filtering purposes.

Tags.Created_Timestamp

  • Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the tag was created or assigned.

Tags.Last_Modified_Timestamp

  • Nullable: NO

  • Data Type: TIMESTAMP

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

Record_Last_Modified_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification of the entire raw record.

Transaction_User_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last performed a transaction or modification on the educational material record.

Type

  • Nullable: YES

  • Data Type: STRING

  • Description: The type or category of the educational material (e.g., video, document).

Tenant

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the tenant or instance managing the educational material, relevant in multi-tenant systems.

Active_Version

  • Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying whether the current version of the educational material is active.

Date

  • Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the educational material, such as when it was created, modified, or accessed.

Sequence

  • Nullable: YES

  • Data Type: INT64

  • Description: Sequence number representing the order in which the educational material was processed or logged.

Source_System_Name

  • Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from which the educational material or content originated.

Source_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the educational material was received from the source system.

Source_File_Name

  • Nullable: YES

  • Data Type: STRING

  • Description: File name associated with the source system’s content, if applicable.

Deleted_Indicator

  • Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicator showing whether the educational material has been marked for deletion.

Schema_Version

  • Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the educational material record, indicating structural updates or changes.

Member_Partition

  • Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the partition where the member's data is stored, relevant in systems where data is distributed across multiple partitions.

Transaction_Actor_Type

  • Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Educational Material Dataset Specification

Overview

The Educational Material Dataset is designed to manage, track, and provide educational materials to patients and staff. It includes metadata, logs, and raw data to ensure efficient categorization, retrieval, and auditing of educational content.

Features

Educational Material Tags

  • Contains metadata tags associated with each educational material, such as health topics, conditions, or target groups.

  • Facilitates easy searching, categorization, and retrieval of content.

  • Ensures users can quickly find materials relevant to their needs.

Educational Material Log

  • Tracks changes, updates, and interactions related to the educational materials.

  • Provides a detailed audit trail for maintaining version control.

  • Ensures all modifications are documented and the latest, most accurate information is available.

Educational Material Raw

  • Holds unprocessed, detailed data related to the educational materials.

  • Includes original formats and metadata before any transformations or updates.

  • Crucial for in-depth analysis, auditing, and research into the effectiveness of the educational materials provided.

Table Specifications

Educational_Material Table

Column Name

Is Nullable

Data Type

Description

Educational_Material_Key

YES

INT64

Unique identifier for the educational material record in the system.

Educational_Material_ID

YES

STRING

Identifier for the specific piece of educational material, used to track and reference it.

Member_ID

YES

STRING

Unique identifier for the member associated with the educational material.

Program_Screening_Key

YES

INT64

Key linking the educational material to a specific program screening or assessment process.

Program_ID

YES

STRING

Identifier for the program under which the educational material is provided.

Program

YES

STRING

Name of the program associated with the educational material.

Program_Description

YES

STRING

Textual description of the program, providing more context about its purpose or content.

Material_Name

YES

STRING

Title or name of the educational material being provided.

Educational_Provider_Content_ID

YES

STRING

Identifier for the content provided by an external educational provider.

Educational_Provider_Content_Format_Type

YES

STRING

The format type of the educational content, such as video, document, or interactive module.

Educational_Provider_Content_Format_Type_Description

YES

STRING

A description of the content format type, providing further details about how the material is presented.

Automated_Source

YES

STRING

Indicates whether the educational material was generated or selected automatically by the system (e.g., via an algorithm or rule-based system).

Status

YES

STRING

Status of the educational material, indicating its availability or completion (e.g., active, archived, completed).

Status_Description

YES

STRING

Textual description of the status, offering additional context or detail about the current state of the educational material.

Source

YES

STRING

The origin or source of the educational material, such as an internal department or an external provider.

Source_Description

YES

STRING

A detailed description of the source, explaining where the educational material originates from.

Content_URL

YES

STRING

Web link or URL to access the educational material online.

Content_Duration_Minutes

YES

INT64

Duration of the educational material in minutes, applicable for media such as videos or audio content.

Created_User_ID

YES

STRING

Identifier for the user who created the educational material record.

Created_User_Name

YES

STRING

Name of the user who created the educational material record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the educational material record was created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating the last time the educational material record was modified.

Educational_Material_Tags Table

Column Name

Is Nullable

Data Type

Description

Educational_Material_Tag_Key

YES

INT64

Unique identifier for the tag associated with the educational material.

Educational_Material_Key

YES

INT64

Unique key that links the tag to the corresponding educational material record.

Value

YES

STRING

The actual tag or keyword assigned to the educational material, used for categorization, filtering, or search purposes.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the tag was created or assigned to the educational material.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating the last time the tag was modified or updated.

Educational_Material_Log Table

Column Name

Is Nullable

Data Type

Description

Educational_Material_Key

YES

INT64

Unique identifier for the educational material associated with the log entry.

Member_ID

YES

STRING

Unique identifier for the member interacting with the educational material.

Program_Screening_Key

YES

INT64

Key linking the educational material to a specific program screening or assessment process.

Program_ID

YES

STRING

Identifier for the program under which the educational material is provided.

Program

YES

STRING

Name of the program associated with the educational material.

Educational Material Dataset Specification

Educational Material Log

Program Description

  • Column Name: Program_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the program, providing more details about its content or purpose.

Educational Material ID

  • Column Name: Educational_Material_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the specific piece of educational material, used to track and reference it.

Automated Source

  • Column Name: Automated_Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicator specifying whether the educational material was selected automatically by the system (e.g., based on rules or an algorithm).

Educational Provider Content

  • Column Name: Educational_Provider_Content

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Contains information about the content provided by the educational provider.

Content ID

  • Column Name: Educational_Provider_Content.Content_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the specific content provided by the educational provider.

Format Type

  • Column Name: Educational_Provider_Content.Format_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Format type of the educational content, such as video, document, or interactive material.

Format Type Description

  • Column Name: Educational_Provider_Content.Format_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the content format, explaining how the educational material is presented (e.g., multimedia, text).

Status

  • Column Name: Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the educational material, indicating its current state (e.g., active, completed, archived).

Status Description

  • Column Name: Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the status, offering further information about the material's state.

Created Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the educational material log was created.

Last Modified Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last time the educational material log entry was modified.

Content Duration Minutes

  • Column Name: Content_Duration_Minutes

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The duration of the educational material in minutes, relevant for content such as videos or audio.

Name

  • Column Name: Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or title of the educational material.

Source

  • Column Name: Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The origin or source of the educational material, such as an internal department or external provider.

Source Description

  • Column Name: Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the source, providing more context about where the educational material originates from.

Content URL

  • Column Name: Content_URL

  • Is Nullable: YES

  • Data Type: STRING

  • Description: URL or web link to the educational material.

Created User ID

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the educational material log entry.

Tags

  • Column Name: Tags

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Contains information about the tags or keywords associated with the educational material.

Tag Key

  • Column Name: Tags.Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Unique identifier for the tag associated with the educational material.

Tag Value

  • Column Name: Tags.Value

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The actual tag or keyword assigned to the educational material for categorization or filtering purposes.

Tag Created Timestamp

  • Column Name: Tags.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the tag was created or assigned.

Tag Last Modified Timestamp

  • Column Name: Tags.Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last time the tag was modified.

Record Last Modified Timestamp

  • Column Name: Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Transaction User ID

  • Column Name: Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who performed the last transaction or modification on the educational material log entry.

Type

  • Column Name: Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type or category of the educational material (e.g., educational video, document).

Tenant

  • Column Name: Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the tenant or instance managing the educational material, usually for multi-tenant systems.

Active Version

  • Column Name: Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the current version of the educational material is active.

Date

  • Column Name: Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the educational material, such as when it was accessed or modified.

Sequence

  • Column Name: Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number, representing the order in which the educational material log entries were created or processed.

Source System Name

  • Column Name: Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the source system from which the educational material or log originated.

Source Timestamp

  • Column Name: Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the educational material or log entry was received from the source system.

Source File Name

  • Column Name: Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The file name associated with the source system’s content, if applicable.

Deleted Indicator

  • Column Name: Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicator showing whether the educational material log has been marked for deletion.

Schema Version

  • Column Name: Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the educational material log, indicating structural changes or updates.

Member Partition

  • Column Name: Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the partition where the member's data is stored, useful in systems where data is distributed across multiple partitions.

Action

  • Column Name: Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific action related to the educational material log entry, indicating what event or action has occurred.

Transaction Actor Type

  • Column Name: Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Educational Material Raw

Educational Material Key

  • Column Name: Educational_Material_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the educational material entry in the raw dataset.

Member ID

  • Column Name: Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member associated with the educational material entry.

Educational Material Dataset Specification

Overview

This document provides a detailed specification for the dataset related to educational materials in Care Intelligence systems. Each field is described with its name, data type, and purpose.

Fields

Member Information

  • Unique identifier for the member associated with the educational material

  • Field Name: Educational_Material_raw

  • Column Name: Program_Screening_Key

  • Required: YES

  • Data Type: INT64

  • Description: Key linking the educational material to a specific program screening or assessment process.

Program Details

  • Identifier for the program under which the educational material is provided

  • Field Name: Educational_Material_raw

  • Column Name: Program_ID

  • Required: YES

  • Data Type: STRING

  • Name of the program associated with the educational material

  • Field Name: Educational_Material_raw

  • Column Name: Program

  • Required: YES

  • Data Type: STRING

  • Description of the program, providing additional details about its content or purpose

  • Field Name: Educational_Material_raw

  • Column Name: Program_Description

  • Required: YES

  • Data Type: STRING

Educational Material Identification

  • Identifier for the specific piece of educational material in the raw data

  • Field Name: Educational_Material_raw

  • Column Name: Educational_Material_ID

  • Required: YES

  • Data Type: STRING

  • Indicator showing whether the educational material was selected automatically by the system

  • Field Name: Educational_Material_raw

  • Column Name: Automated_Source

  • Required: YES

  • Data Type: STRING

Educational Provider Content

  • Contains information about the content provided by an educational provider

  • Field Name: Educational_Material_raw

  • Column Name: Educational_Provider_Content

  • Required: YES

  • Data Type: STRUCT

  • Identifier for the specific content provided by the educational provider

  • Field Name: Educational_Material_raw

  • Column Name: Educational_Provider_Content.Content_ID

  • Required: YES

  • Data Type: STRING

  • Format type of the educational content, such as video, document, or interactive material

  • Field Name: Educational_Material_raw

  • Column Name: Educational_Provider_Content.Format_Type

  • Required: YES

  • Data Type: STRING

  • Description of the content format, explaining the presentation type (e.g., multimedia, text)

  • Field Name: Educational_Material_raw

  • Column Name: Educational_Provider_Content.Format_Type_Description

  • Required: YES

  • Data Type: STRING

Status Information

  • Status of the educational material, such as whether it is active, completed, or archived

  • Field Name: Educational_Material_raw

  • Column Name: Status

  • Required: YES

  • Data Type: STRING

  • Detailed description of the current status of the educational material

  • Field Name: Educational_Material_raw

  • Column Name: Status_Description

  • Required: YES

  • Data Type: STRING

Timestamps

  • Timestamp indicating when the educational material was created in the raw dataset

  • Field Name: Educational_Material_raw

  • Column Name: Created_Timestamp

  • Required: YES

  • Data Type: TIMESTAMP

  • Timestamp indicating when the educational material was last modified

  • Field Name: Educational_Material_raw

  • Column Name: Last_Modified_Timestamp

  • Required: YES

  • Data Type: TIMESTAMP

Content Details

  • The duration of the educational material in minutes, relevant for content like videos or audio

  • Field Name: Educational_Material_raw

  • Column Name: Content_Duration_Minutes

  • Required: YES

  • Data Type: INT64

  • Name or title of the educational material

  • Field Name: Educational_Material_raw

  • Column Name: Name

  • Required: YES

  • Data Type: STRING

  • The origin or source of the educational material, such as an internal department or external provider

  • Field Name: Educational_Material_raw

  • Column Name: Source

  • Required: YES

  • Data Type: STRING

  • Additional description of the source, providing context about where the educational material originated from

  • Field Name: Educational_Material_raw

  • Column Name: Source_Description

  • Required: YES

  • Data Type: STRING

  • URL or web link to access the educational material online

  • Field Name: Educational_Material_raw

  • Column Name: Content_URL

  • Required: YES

  • Data Type: STRING

User Information

  • Identifier for the user who created the educational material in the raw dataset

  • Field Name: Educational_Material_raw

  • Column Name: Created_User_ID

  • Required: YES

  • Data Type: STRING

Tags

  • Contains information about the tags or keywords assigned to the educational material

  • Field Name: Educational_Material_raw

  • Column Name: Tags

  • Required: NO

  • Data Type: ARRAY

  • Unique key identifying the tag associated with the educational material

  • Field Name: Educational_Material_raw

  • Column Name: Tags.Key

  • Required: NO

  • Data Type: INT64

  • The actual tag or keyword assigned to the educational material, used for categorization or filtering purposes

  • Field Name: Educational_Material_raw

  • Column Name: Tags.Value

  • Required: NO

  • Data Type: STRING

  • Timestamp indicating when the tag was created or assigned

  • Field Name: Educational_Material_raw

  • Column Name: Tags.Created_Timestamp

  • Required: NO

  • Data Type: TIMESTAMP

  • Timestamp indicating when the tag was last modified

  • Field Name: Educational_Material_raw

  • Column Name: Tags.Last_Modified_Timestamp

  • Required: NO

  • Data Type: TIMESTAMP

Record Information

  • Timestamp indicating the last modification of the entire raw record

  • Field Name: Educational_Material_raw

  • Column Name: Record_Last_Modified_Timestamp

  • Required: YES

  • Data Type: TIMESTAMP

  • Identifier for the user who last performed a transaction or modification on the educational material record

  • Field Name: Educational_Material_raw

  • Column Name: Transaction_User_ID

  • Required: YES

  • Data Type: STRING

Additional Details

  • The type or category of the educational material (e.g., video, document)

  • Field Name: Educational_Material_raw

  • Column Name: Type

  • Required: YES

  • Data Type: STRING

  • Identifier for the tenant or instance managing the educational material, relevant in multi-tenant systems

  • Field Name: Educational_Material_raw

  • Column Name: Tenant

  • Required: YES

  • Data Type: STRING

  • Indicator specifying whether the current version of the educational material is active

  • Field Name: Educational_Material_raw

  • Column Name: Active_Version

  • Required: YES

  • Data Type: BOOL

  • The date associated with the educational material, such as when it was created, modified, or accessed

  • Field Name: Educational_Material_raw

  • Column Name: Date

  • Required: YES

  • Data Type: DATE

  • Sequence number representing the order in which the educational material was processed or logged

  • Field Name: Educational_Material_raw

  • Column Name: Sequence

  • Required: YES

  • Data Type: INT64

Source System Information

  • Name of the source system from which the educational material or content originated

  • Field Name: Educational_Material_raw

  • Column Name: Source_System_Name

  • Required: YES

  • Data Type: STRING

  • Timestamp when the educational material was received from the source system

  • Field Name: Educational_Material_raw

  • Column Name: Source_Timestamp

  • Required: YES

  • Data Type: TIMESTAMP

  • File name associated with the source system’s content, if applicable

  • Field Name: Educational_Material_raw

  • Column Name: Source_File_Name

  • Required: YES

  • Data Type: STRING

Deletion and Schema Information

  • Boolean indicator showing whether the educational material has been marked for deletion

  • Field Name: Educational_Material_raw

  • Column Name: Deleted_Indicator

  • Required: YES

  • Data Type: BOOL

  • Version of the schema used for the educational material record, indicating structural updates or changes

  • Field Name: Educational_Material_raw

  • Column Name: Schema_Version

  • Required: YES

  • Data Type: FLOAT64

Partition and Actor Information

  • Identifier for the partition where the member's data is stored, relevant in systems where data is distributed across multiple partitions

  • Field Name: Educational_Material_raw

  • Column Name: Member_Partition

  • Required: YES

  • Data Type: INT64

  • Type of the actor performing the transaction

  • Field Name: Educational_Material_raw

  • Column Name: Transaction_Actor_Type

  • Required: YES

  • Data Type: STRING

Related Articles
Assessment Dataset Specification
Questionnaire Dataset Specification
Notification Dataset Specification
User Dataset Specification
Calendar Dataset Specification
Did this answer your question?