Skip to main content

Medication Manual Entry Dataset Specification

Updated over a month ago

Medication Manual Entry Dataset Specification

Medication Manual Entry Dataset Specification

The "Medication Manual Entry Dataset Specification" is designed to manage and track medications that are manually entered into healthcare systems, ensuring accurate documentation, compliance with healthcare standards, and alignment with patient safety protocols. This dataset plays a crucial role in capturing manual entries of medications that may not be automatically recorded through electronic health record (EHR) systems, supporting the accurate management of prescriptions, treatment plans, and medication-related decisions.

The dataset adheres to healthcare-specific standards, ensuring data integrity, patient safety, and compliance with regulatory requirements. It includes the following key tables:

Medication Manual Entry

Stores detailed information about medications that are manually entered by healthcare providers or administrative staff. This table captures essential details such as:

  • Medication name

  • Dosage

  • Frequency

  • Prescribing provider

  • Patient information

This ensures that any manually prescribed or administered medications are accurately documented, reducing the risk of errors and ensuring continuity of care.

Table Schema

Column Name

Is Nullable

Data Type

Description

Medication_Manual_Entry_Key

NO

STRING

The unique identifier for the manual medication entry.

Member_ID

NO

STRING

The unique identifier of the member associated with the medication entry.

Medication_User_Entered_Name

YES

STRING

The name of the medication as entered by the user.

Status

YES

STRING

The current status of the medication entry (Enum: ACTIVE / INACTIVE / DELETED).

Status_Description

YES

STRING

A description providing more context about the status of the medication entry.

Custom_Medication_Name_Indicator

YES

BOOL

Returns 'false' if the 'Medication_User_Entered_Name' field is empty; otherwise, returns 'true'.

National_Drug_Code

YES

STRING

The National Drug Code (NDC) associated with the medication.

National_Drug_Code_Description

YES

STRING

A description of the National Drug Code (NDC) for the medication.

Drug_Code_Description

YES

STRING

A description of the drug code.

Brand_Name

YES

STRING

The brand name of the medication.

Brand_Or_Generic_Code

YES

STRING

Indicates whether the medication is a brand or generic product.

Drug_Class

YES

STRING

The class of the drug (e.g., analgesic, antihypertensive).

Drug_Class_Description

YES

STRING

A description of the drug class.

Drug_Package_Size

YES

STRING

The size of the drug package (e.g., number of pills, volume of liquid).

Drug_Package_Description

YES

STRING

A description of the drug package.

Drug_Admin_Route

YES

STRING

The route of drug administration (e.g., oral, intravenous).

Drug_Admin_Route_Description

YES

STRING

A description of the drug administration route.

From_Date

YES

DATE

The date when the medication administration started.

To_Date

YES

DATE

The date when the medication administration ended.

Frequency

YES

STRING

The frequency with which the medication is administered.

Frequency_Description

YES

STRING

A description of the medication frequency.

Created_User_ID

YES

STRING

The ID of the user who created the manual medication entry.

Created_User_Name

YES

STRING

The name of the user who created the manual medication entry.

Creator_Type

YES

STRING

The type of user who created the manual medication entry (e.g., healthcare provider, patient).

Last_Modified_User_ID

YES

STRING

The ID of the user who last modified the manual medication entry.

Last_Modified_User_Name

YES

STRING

The name of the user who last modified the manual medication entry.

Last_Modifier_Type

YES

STRING

The type of user who last modified the manual medication entry.

Created_Timestamp

YES

TIMESTAMP

The timestamp when the manual medication entry was created.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when the manual medication entry was last modified.

Medication Manual Entry Log

Tracks changes, updates, and modifications made to manually entered medications. This log provides an audit trail that ensures:

  • Transparency

  • Accountability

  • Compliance with healthcare regulations, such as those mandated by HIPAA

It captures when and by whom entries were modified, helping healthcare organizations monitor medication records for accuracy.

Table Schema

Column Name

Is Nullable

Data Type

Description

Medication_Manual_Entry_Key

NO

STRING

The unique identifier for the manual medication entry.

Member_ID

NO

STRING

The unique identifier of the member associated with the medication entry.

Medication Manual Entry Raw

Contains unprocessed data related to manually entered medications, providing a comprehensive view of medication entries before any transformation or aggregation. This raw data is essential for:

  • In-depth analysis

  • Audits

  • Research purposes

It helps ensure that manual medication entries are captured and recorded accurately.

Importance of the Dataset

This dataset is essential for healthcare organizations that handle manual medication entries, ensuring that all medications are properly tracked and documented, even if they are not entered through automated systems. By maintaining a clear audit trail and supporting detailed data analysis, this dataset helps ensure:

  • Patient safety

  • Medication accuracy

  • Compliance with healthcare regulations

Medication Manual Entry Dataset Specification

Medication Manual Entry Log

Column Specifications

  • Medication_User_Entered_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the medication as entered by the user.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The current status of the medication entry (e.g., active, discontinued).

  • Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description providing more context about the status of the medication entry.

  • Custom_Medication_Name_Indicator

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An indicator showing if the medication name is custom-entered rather than selected from a standard list.

  • National_Drug_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The National Drug Code (NDC) associated with the medication.

  • National_Drug_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the National Drug Code (NDC) for the medication.

  • Brand_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The brand name of the medication.

  • Brand_Or_Generic_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the medication is a brand or generic product.

  • Drug_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The class of the drug (e.g., analgesic, antihypertensive).

  • Drug_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the drug class.

  • Drug_Package_Size

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The size of the drug package (e.g., number of pills, volume of liquid).

  • Drug_Package_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the drug package.

  • Drug_Admin_Route

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The route of drug administration (e.g., oral, intravenous).

  • Drug_Admin_Route_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the drug administration route.

  • From_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the medication administration started.

  • To_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the medication administration ended.

  • Frequency

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The frequency with which the medication is administered.

  • Frequency_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the medication frequency.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the manual medication entry was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the manual medication entry was last modified.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who created the manual medication entry.

  • Creator_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of user who created the manual medication entry (e.g., healthcare provider, patient).

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who last modified the manual medication entry.

  • Last_Modifier_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of user who last modified the manual medication entry.

  • Record_Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: The timestamp when the manual medication log record was last modified.

  • Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

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

  • Deleted_Indicator

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicates whether the manual medication entry has been marked as deleted ('false' by default).

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of record for the manual medication entry.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The tenant associated with the manual medication entry.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

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

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date related to the manual medication entry.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The sequence number of the manual medication entry record.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the source system that provided the manual medication entry.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the source system provided the manual medication entry.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The file name from the source system containing the manual medication entry.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: The version of the schema used for the manual medication entry record.

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The partition for the member data related to the manual medication entry.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The field indicating the last update to the manual medication entry log.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The action performed on the manual medication entry (e.g., created, modified, deleted).

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Medication Manual Entry Raw

Column Specifications

  • Medication_Manual_Entry_Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The unique key identifying a manual medication entry.

  • Member_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The identifier of the member associated with the medication entry.

  • Medication_User_Entered_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the medication as entered by the user.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The current status of the medication entry (e.g., active, discontinued).

  • Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description providing details about the status of the medication entry.

  • Custom_Medication_Name_Indicator

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An indicator showing if the medication name is custom-entered rather than selected from a standard list.

  • National_Drug_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The National Drug Code (NDC) for the medication.

  • National_Drug_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the National Drug Code (NDC) for the medication.

  • Brand_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The brand name of the medication.

Medication Manual Entry Dataset Specification

Overview

Medication Manual Entry

Stores detailed information about medications that are manually entered by healthcare providers or administrative staff. This table captures essential details such as medication name, dosage, frequency, prescribing provider, and patient information. This ensures that any manually prescribed or administered medications are accurately documented, reducing the risk of errors and ensuring continuity of care.

Medication Manual Entry Log

Tracks changes, updates, and modifications made to manually entered medications. This log provides an audit trail that ensures transparency, accountability, and compliance with healthcare regulations, such as those mandated by HIPAA. It captures when and by whom entries were modified, helping healthcare organizations monitor medication records for accuracy.

Medication Manual Entry Raw

Contains unprocessed data related to manually entered medications, providing a comprehensive view of medication entries before any transformation or aggregation. This raw data is essential for in-depth analysis, audits, and research purposes, helping to ensure that manual medication entries are captured and recorded accurately.

Table Content

Medication Manual Entry Raw

Column Name

Is Nullable

Data Type

Description

Medication_Manual_Entry_Key

NO

STRING

The unique identifier for the manual medication entry.

Member_ID

NO

STRING

The unique identifier of the member associated with the medication entry.

Medication_User_Entered_Name

YES

STRING

The name of the medication as entered by the user.

Status

YES

STRING

The current status of the medication entry (Enum: ACTIVE / INACTIVE / DELETED).

Status_Description

YES

STRING

A description providing more context about the status of the medication entry.

Custom_Medication_Name_Indicator

YES

BOOL

Returns 'false' if the 'Medication_User_Entered_Name' field is empty; otherwise, returns 'true'.

National_Drug_Code

YES

STRING

The National Drug Code (NDC) associated with the medication.

Medication Manual Entry Raw Fields

  • Brand_Or_Generic_Code

  • Required: YES

  • Data Type: STRING

  • Description: A code indicating whether the medication is a brand or a generic product.

  • Drug_Class

  • Required: YES

  • Data Type: STRING

  • Description: The class of the drug (e.g., analgesic, antihypertensive).

  • Drug_Class_Description

  • Required: YES

  • Data Type: STRING

  • Description: A description of the drug class.

  • Drug_Package_Size

  • Required: YES

  • Data Type: STRING

  • Description: The size of the drug package (e.g., number of pills, volume of liquid).

  • Drug_Package_Description

  • Required: YES

  • Data Type: STRING

  • Description: A description of the drug package.

  • Drug_Admin_Route

  • Required: YES

  • Data Type: STRING

  • Description: The route of administration for the medication (e.g., oral, intravenous).

  • Drug_Admin_Route_Description

  • Required: YES

  • Data Type: STRING

  • Description: A description of the drug administration route.

  • From_Date

  • Required: YES

  • Data Type: DATE

  • Description: The start date for the medication administration.

  • To_Date

  • Required: YES

  • Data Type: DATE

  • Description: The end date for the medication administration.

  • Frequency

  • Required: YES

  • Data Type: STRING

  • Description: The frequency with which the medication is administered.

  • Frequency_Description

  • Required: YES

  • Data Type: STRING

  • Description: A description of the frequency of medication administration.

  • Created_Timestamp

  • Required: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the manual medication entry was created.

  • Last_Modified_Timestamp

  • Required: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the manual medication entry was last modified.

  • Created_User_ID

  • Required: YES

  • Data Type: STRING

  • Description: The ID of the user who created the manual medication entry.

  • Creator_Type

  • Required: YES

  • Data Type: STRING

  • Description: The type of the user who created the medication entry (e.g., healthcare provider, patient).

  • Last_Modified_User_ID

  • Required: YES

  • Data Type: STRING

  • Description: The ID of the user who last modified the manual medication entry.

  • Last_Modifier_Type

  • Required: YES

  • Data Type: STRING

  • Description: The type of the user who last modified the medication entry.

  • Record_Last_Modified_Timestamp

  • Required: NO

  • Data Type: TIMESTAMP

  • Description: The timestamp of the most recent modification to the medication entry record.

  • Transaction_User_ID

  • Required: NO

  • Data Type: STRING

  • Description: The ID of the user responsible for the transaction involving this medication entry.

  • Deleted_Indicator

  • Required: NO

  • Data Type: BOOL

  • Description: Indicates whether the medication entry has been deleted ('false' by default).

  • Type

  • Required: YES

  • Data Type: STRING

  • Description: The type of the manual medication entry.

  • Tenant

  • Required: YES

  • Data Type: STRING

  • Description: The tenant associated with this medication entry.

  • Active_Version

  • Required: YES

  • Data Type: BOOL

  • Description: Indicates whether the medication entry is an active version.

  • Date

  • Required: YES

  • Data Type: DATE

  • Description: The date associated with the medication entry.

  • Sequence

  • Required: YES

  • Data Type: INT64

  • Description: The sequence number for the manual medication entry.

  • Source_System_Name

  • Required: YES

  • Data Type: STRING

  • Description: The name of the system from which the medication entry originated.

  • Source_Timestamp

  • Required: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the source system provided the medication entry.

  • Source_File_Name

  • Required: YES

  • Data Type: STRING

  • Description: The file name from the source system that contains the medication entry.

  • Schema_Version

  • Required: YES

  • Data Type: FLOAT64

  • Description: The version of the schema used for the manual medication entry record.

  • Member_Partition

  • Required: YES

  • Data Type: INT64

  • Description: The partition of the member data related to this medication entry.

  • _updated

  • Required: YES

  • Data Type: STRING

  • Description: The timestamp of the last update to the medication entry.

  • Transaction_Actor_Type

  • Required: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Medication Manual Entry Dataset Specification

Medication Manual Entry Table

Columns

  • National_Drug_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the National Drug Code (NDC) for the medication.

  • Drug_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the drug code.

  • Brand_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The brand name of the medication.

  • Brand_Or_Generic_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the medication is a brand or generic product.

  • Drug_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The class of the drug (e.g., analgesic, antihypertensive).

  • Drug_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the drug class.

  • Drug_Package_Size

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The size of the drug package (e.g., number of pills, volume of liquid).

  • Drug_Package_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the drug package.

  • Drug_Admin_Route

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The route of drug administration (e.g., oral, intravenous).

  • Drug_Admin_Route_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the drug administration route.

  • From_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the medication administration started.

  • To_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the medication administration ended.

  • Frequency

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The frequency with which the medication is administered.

  • Frequency_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the medication frequency.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who created the manual medication entry.

  • Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who created the manual medication entry.

  • Creator_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of user who created the manual medication entry (e.g., healthcare provider, patient).

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who last modified the manual medication entry.

  • Last_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the manual medication entry.

  • Last_Modifier_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of user who last modified the manual medication entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the manual medication entry was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the manual medication entry was last modified.

Medication Manual Entry Log Table

Columns

  • Medication_Manual_Entry_Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The unique identifier for the manual medication entry.

  • Member_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The unique identifier of the member associated with the medication entry.

  • Medication_User_Entered_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the medication as entered by the user.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The current status of the medication entry (e.g., active, discontinued).

  • Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description providing more context about the status of the medication entry.

  • Custom_Medication_Name_Indicator

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An indicator showing if the medication name is custom-entered rather than selected from a standard list.

  • National_Drug_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The National Drug Code (NDC) associated with the medication.

  • National_Drug_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the National Drug Code (NDC) for the medication.

  • Brand_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The brand name of the medication.

  • Brand_Or_Generic_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the medication is a brand or generic product.

  • Drug_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The class of the drug (e.g., analgesic, antihypertensive).

  • Drug_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the drug class.

  • Drug_Package_Size

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The size of the drug package (e.g., number of pills, volume of liquid).

  • Drug_Package_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the drug package.

  • Drug_Admin_Route

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The route of drug administration (e.g., oral, intravenous).

  • Drug_Admin_Route_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the drug administration route.

  • From_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the medication administration started.

  • To_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the medication administration ended.

  • Frequency

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The frequency with which the medication is administered.

  • Frequency_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the medication frequency.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the manual medication entry was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the manual medication entry was last modified.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who created the manual medication entry.

  • Creator_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of user who created the manual medication entry (e.g., healthcare provider, patient).

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who last modified the manual medication entry.

Medication Manual Entry Dataset Specification

Medication Manual Entry Log

Columns and Descriptions

Column Name

Is Nullable

Data Type

Description

Last_Modifier_User_ID

YES

STRING

The ID of the user who last modified the manual medication entry.

Last_Modifier_Type

YES

STRING

The type of user who last modified the manual medication entry.

Record_Last_Modified_Timestamp

NO

TIMESTAMP

The timestamp when the manual medication log record was last modified.

Transaction_User_ID

NO

STRING

The ID of the user associated with the transaction modifying the medication entry.

Deleted_Indicator

NO

BOOL

Indicates whether the manual medication entry has been marked as deleted ('false' by default).

Type

YES

STRING

The type of record for the manual medication entry.

Tenant

YES

STRING

The tenant associated with the manual medication entry.

Active_Version

YES

BOOL

Indicates whether the version of the manual medication entry is active.

Date

YES

DATE

The date related to the manual medication entry.

Sequence

YES

INT64

The sequence number of the manual medication entry record.

Source_System_Name

YES

STRING

The name of the source system that provided the manual medication entry.

Source_Timestamp

YES

TIMESTAMP

The timestamp when the source system provided the manual medication entry.

Source_File_Name

YES

STRING

The file name from the source system containing the manual medication entry.

Schema_Version

YES

FLOAT64

The version of the schema used for the manual medication entry record.

Member_Partition

YES

INT64

The partition for the member data related to the manual medication entry.

_updated

YES

STRING

The field indicating the last update to the manual medication entry log.

Action

YES

STRING

The action performed on the manual medication entry (e.g., created, modified, deleted).

Transaction_Actor_Type

YES

STRING

Type of the actor performing the transaction.

Custom_Medication_Name_Indicator

YES

STRING

An indicator showing if the medication name is custom-entered rather than selected from a standard list.

Medication Manual Entry Raw

Columns and Descriptions

Column Name

Is Nullable

Data Type

Description

Medication_Manual_Entry_Key

NO

STRING

The unique key identifying a manual medication entry.

Member_ID

NO

STRING

The identifier of the member associated with the medication entry.

Medication_User_Entered_Name

YES

STRING

The name of the medication as entered by the user.

Status

YES

STRING

The current status of the medication entry (e.g., active, discontinued).

Status_Description

YES

STRING

A description providing details about the status of the medication entry.

National_Drug_Code

YES

STRING

The National Drug Code (NDC) for the medication.

National_Drug_Code_Description

YES

STRING

A description of the National Drug Code (NDC) for the medication.

Brand_Name

YES

STRING

The brand name of the medication.

Brand_Or_Generic_Code

YES

STRING

A code indicating whether the medication is a brand or a generic product.

Drug_Class

YES

STRING

The class of the drug (e.g., analgesic, antihypertensive).

Drug_Class_Description

YES

STRING

A description of the drug class.

Drug_Package_Size

YES

STRING

The size of the drug package (e.g., number of pills, volume of liquid).

Drug_Package_Description

YES

STRING

A description of the drug package.

Drug_Admin_Route

YES

STRING

The route of administration for the medication (e.g., oral, intravenous).

Drug_Admin_Route_Description

YES

STRING

A description of the drug administration route.

From_Date

YES

DATE

The start date for the medication administration.

To_Date

YES

DATE

The end date for the medication administration.

Frequency

YES

STRING

The frequency with which the medication is administered.

Frequency_Description

YES

STRING

A description of the frequency of medication administration.

Created_Timestamp

YES

TIMESTAMP

The timestamp when the manual medication entry was created.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when the manual medication entry was last modified.

Created_User_ID

YES

STRING

The ID of the user who created the manual medication entry.

Creator_Type

YES

STRING

The type of the user who created the medication entry (e.g., healthcare provider, patient).

Last_Modified_User_ID

YES

STRING

The ID of the user who last modified the manual medication entry.

Last_Modifier_Type

YES

STRING

The type of the user who last modified the medication entry.

Record_Last_Modified_Timestamp

NO

TIMESTAMP

The timestamp of the most recent modification to the medication entry.

Medication Manual Entry Dataset Specification

Dataset Fields

Medication_Manual_Entry_raw

Transaction_User_ID

  • Required: No

  • Type: STRING

  • Description: The ID of the user responsible for the transaction involving this medication entry.

Deleted_Indicator

  • Required: No

  • Type: BOOL

  • Description: Indicates whether the medication entry has been deleted (false by default).

Type

  • Required: Yes

  • Type: STRING

  • Description: The type of the manual medication entry.

Tenant

  • Required: Yes

  • Type: STRING

  • Description: The tenant associated with this medication entry.

Active_Version

  • Required: Yes

  • Type: BOOL

  • Description: Indicates whether the medication entry is an active version.

Date

  • Required: Yes

  • Type: DATE

  • Description: The date associated with the medication entry.

Sequence

  • Required: Yes

  • Type: INT64

  • Description: The sequence number for the manual medication entry.

Source_System_Name

  • Required: Yes

  • Type: STRING

  • Description: The name of the system from which the medication entry originated.

Source_Timestamp

  • Required: Yes

  • Type: TIMESTAMP

  • Description: The timestamp when the source system provided the medication entry.

Source_File_Name

  • Required: Yes

  • Type: STRING

  • Description: The file name from the source system that contains the medication entry.

Schema_Version

  • Required: Yes

  • Type: FLOAT64

  • Description: The version of the schema used for the manual medication entry record.

Member_Partition

  • Required: Yes

  • Type: INT64

  • Description: The partition of the member data related to this medication entry.

_updated

  • Required: Yes

  • Type: STRING

  • Description: The timestamp of the last update to the medication entry.

Transaction_Actor_Type

  • Required: Yes

  • Type: STRING

  • Description: Type of the actor performing the transaction.

Related Articles
Dictionary Dataset Specification
Rx Claim Dataset Specification
Attachment Dataset Specification
Dictionary Dataset Specification M Q
Dictionary Dataset Specification R Z
Did this answer your question?