Skip to main content

Attachment Dataset Specification

Updated over a month ago

Attachment Dataset Specification

Attachment Dataset Specification

The "Attachment Dataset Specification" is meticulously designed to manage and track attachments within healthcare systems, adhering to healthcare-specific standards for data security, privacy, and integrity. This dataset is crucial for organizing and maintaining supplementary documentation related to patient care, administrative processes, and healthcare operations.

Overview

This dataset includes the following key tables:

Attachment

  • Stores records of various documents or files attached to specific entities within the healthcare system, such as patient records, treatment plans, or administrative documents.

  • Each entry includes details about the attachment type, content, and purpose, ensuring that all relevant information is systematically cataloged and easily accessible.

Attachment Log

  • Maintains a detailed history of changes, updates, and actions taken on attachments.

  • Provides a chronological audit trail of when and by whom attachments were accessed, modified, or removed, supporting transparency, accountability, and compliance with healthcare regulations.

Attachment Raw

  • Contains unprocessed, detailed data related to the attachments.

  • Essential for in-depth analysis, auditing, and research, offering a granular view of all attachment-related activities before any aggregation or transformation.

This dataset is vital for healthcare organizations aiming to enhance their document management practices, ensuring the integrity and traceability of all supplementary documentation. By providing a robust framework for managing attachments, this dataset supports the delivery of high-quality patient care and efficient administrative operations.

Table: Attachment

Column Name

Is Nullable

Data Type

Description

Member_ID

YES

STRING

Identifier for the member associated with the attachment, linking the document to a specific member's record.

Attachment_Key

YES

INT64

Unique key for identifying the attachment within the system, used as a primary reference.

Attachment_Class

YES

STRING

Category or classification of the attachment, indicating the nature or purpose of the document.

Attachment_Class_Description

YES

STRING

Detailed explanation of the attachment class, providing context about the type of document.

Screening_Key

YES

INT64

Identifier linking the attachment to a specific screening event or process, if applicable.

Request_Key

YES

INT64

Unique identifier linking the attachment to a specific service request or case in the system.

Member_Key

YES

INT64

A unique identifier that correlates the attachment specifically to the member’s record in the database.

Program_ID

YES

STRING

Identifier for the program associated with the attachment, if it is part of a program-specific documentation.

Request_ID

YES

STRING

String identifier for the service request or case to which the attachment is related.

Attachment_Type

YES

STRING

Code or identifier specifying the format or kind of attachment (e.g., PDF, image, document).

Attachment_Type_Description

YES

STRING

Description of the attachment type, detailing the format or nature of the file.

Attachment_Status

YES

STRING

Status code indicating the current state of the attachment (e.g., active, archived, pending review).

Attachment_Status_Description

YES

STRING

Detailed explanation of the current status of the attachment.

Title

YES

STRING

The title or name of the attachment, often used as a label or short description.

Location

YES

STRING

The physical or digital location where the attachment is stored or accessible.

File_Name

YES

STRING

The name of the file as stored in the system, which may include a file extension indicating the file type.

Document_ID

YES

STRING

A unique identifier for the document within the system, used for tracking and reference.

External_Document_ID

YES

STRING

An identifier for the document that is recognized outside the system, possibly by an external document management system.

Uploaded_Timestamp

YES

TIMESTAMP

The date and time when the attachment was uploaded to the system.

Active

YES

BOOL

A boolean indicator of whether the attachment is currently active and relevant.

Source_System

YES

STRING

The system or platform from which the attachment originates.

Source_System_Description

YES

STRING

Description or details about the source system providing the attachment.

Owner_User_ID

YES

STRING

Identifier of the user who owns or is responsible for the attachment.

Created_Timestamp

YES

TIMESTAMP

The timestamp marking when the attachment was first created or added to the system.

Last_Modified_Timestamp

YES

TIMESTAMP

The most recent timestamp when the attachment was modified.

Record_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating the last modification made to the record, providing a historical audit trail.

Transaction_User_ID

YES

STRING

User ID associated with the last transaction made on the attachment.

Attachment Dataset Specification

Attachment Fields

Attachment Deleted Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean flag indicating whether the attachment has been marked as deleted in the system.

Attachment Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A classification or category type of the attachment, providing further context or grouping.

Attachment Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The tenant or domain within which the attachment is managed, useful in multi-tenant systems.

Attachment Active Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the current record is the active or most up-to-date version of the attachment.

Attachment Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the attachment, often reflecting when it was created or logged.

Attachment Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A sequence number or order identifier for the attachment, possibly indicating its position in a series or process.

Attachment Source System Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the source system from which the attachment originates, aiding in traceability.

Attachment Source Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from the source system when the attachment was originally created or logged.

Attachment Source File Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The original file name of the attachment in the source system, helpful for cross-referencing.

Attachment Schema Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: The version of the data schema under which the attachment record is managed.

Attachment Member Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: An identifier used to partition the data by member, aiding in data organization and retrieval.

Attachment Updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A field indicating when the attachment record was last updated in the dataset.

Attachment Owner User Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The original owner user name of the attachment.

Attachment Log Table

Member ID

  • Is Nullable: YES

  • Data Type: STRING

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

Attachment Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the attachment record.

Attachment Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category or class of the attachment.

Attachment Class Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the attachment class.

Screening Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier linking the attachment to a specific screening, if applicable.

Request Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key relating the attachment to a specific request or case.

Member Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the member in the context of the attachment.

Program ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program associated with the attachment.

Request ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific request identifier associated with the attachment.

Attachment Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or format of the attachment (e.g., PDF, image).

Attachment Type Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Descriptive details about the type of attachment.

Attachment Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of the attachment (e.g., active, archived).

Attachment Status Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of what each status represents.

Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title or name given to the attachment.

Location

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Storage location or path of the attachment.

File Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the file attached.

Document ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Internal identifier for the document.

External Document ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: External or third-party identifier for the attachment.

Uploaded Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time the attachment was uploaded.

Active

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the attachment is currently active or not.

Source System

  • Is Nullable: YES

  • Data Type: STRING

  • Description: System from which the attachment originated.

Source System Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the source system.

Owner User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the individual who owns the attachment.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp for when the attachment was initially created.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp for the most recent modification to the attachment.

Record Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last change to the record.

Transaction User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who performed the last transaction on the attachment.

Deleted Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Flag indicating if the attachment has been marked as deleted.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: General type classification of the attachment.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the tenant or domain within which the attachment is managed.

Active Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether this version of the attachment is the active one in use.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the attachment record.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number for the attachment, indicating its order or version.

Source System Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the system from which the attachment originates.

Source Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp from the source system when the attachment was created or modified.

Source File Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: File name in the source system for the attachment.

Schema Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the data schema to which the attachment conforms.

Member Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition identifier used for data segmentation and optimization in storage.

Updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates when the attachment record was last updated.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the action taken in the log for the attachment (e.g., created, updated, deleted).

Transaction Actor Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Attachment Raw Table

Member ID

  • Is Nullable: YES

  • Data Type: STRING

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

Attachment Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key for the attachment.

Attachment Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Class of the attachment.

Attachment Dataset Specification

Attachment_raw Table

Columns and Descriptions

  • Attachment_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the attachment class.

  • Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key for the screening associated with the attachment.

  • Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key for the request associated with the attachment.

  • Member_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key for the member associated with the attachment.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program associated with the attachment.

  • Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the request associated with the attachment.

  • Attachment_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the attachment.

  • Attachment_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the attachment type.

  • Attachment_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the attachment.

  • Attachment_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the attachment status.

  • Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title of the attachment.

  • Location

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Location where the attachment is stored.

  • File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the file associated with the attachment.

  • Document_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the document associated with the attachment.

  • External_Document_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: External identifier for the document associated with the attachment.

  • Uploaded_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the attachment was uploaded.

  • Active

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the attachment is active.

  • Source_System

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source system from where the attachment originated.

  • Source_System_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the source system.

  • Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who owns the attachment.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the attachment was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the attachment 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: Identifier for the user who performed the transaction.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the attachment is deleted.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the attachment.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the attachment.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the attachment is the active version.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the attachment.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the attachment.

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

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

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating the last update of the attachment record.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Dictionary_Prescription_Origin Table

Columns and Descriptions

  • Origin_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code representing the origin of a prescription, such as electronic, written, or verbal.

  • Origin_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the prescription origin, providing context or additional information about the origin type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the prescription origin entry became valid and active within the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the prescription origin entry in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the prescription origin entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the prescription origin entry in the system.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the prescription origin entry was last updated or modified in the system.

Dictionary_Provider_Specialty_Crosswalk Table

Columns and Descriptions

  • Taxonomy_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the provider's taxonomy, typically based on healthcare specialty classification standards.

  • Taxonomy_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the taxonomy code, explaining the healthcare specialty or classification it represents.

  • Insights_Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code used within the system to represent a provider specialty as per internal insights or classifications.

  • Insights_Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the internal insights specialty code, explaining the provider's specialty or area of expertise.

  • Crosswalk_Priority

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A priority level indicating the relevance or precedence of this crosswalk mapping when multiple mappings exist for a provider specialty.

  • CMS_Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing the provider's specialty as defined by the Centers for Medicare and Medicaid Services (CMS).

  • CMS_Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the CMS specialty code, explaining the corresponding provider's specialty or classification.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the crosswalk entry became valid and active in the system.

Attachment Dataset Specification

Crosswalk

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the crosswalk entry in the system.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the crosswalk entry was created in the system.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the crosswalk entry in the system.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the crosswalk entry was last updated or modified in the system.

Dictionary_Provider_Specialty_Taxonomy

Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing a specific taxonomy entry for a provider specialty.

Undefined

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag or status indicator to identify if the taxonomy code is undefined or not assigned to a specific specialty.

Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed explanation or description of the taxonomy code and its relevance to a provider's specialty.

Patient_Centered_Medical_Home_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the specialty is associated with a patient-centered medical home (PCMH) model of care.

Grouping

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The broader category or grouping under which the provider specialty falls.

Classification

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A specific classification within the grouping that provides further granularity of the provider specialty.

Specialization

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A more detailed or focused description of the provider's area of specialization within the classification.

Definition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A formal definition of the provider specialty or taxonomy entry, detailing its scope and purpose.

Notes

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional comments or notes related to the taxonomy entry, often used for clarifications or special considerations.

Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the visibility or accessibility of the taxonomy entry within the system, such as internal or external visibility.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the taxonomy entry became active or valid in the system.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the taxonomy entry.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the taxonomy entry was created in the system.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the taxonomy entry.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the taxonomy entry was last updated or modified in the system.

Dictionary_Provider_Specialty_Type

Specialty_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code representing a specific type of provider specialty.

Specialty_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider specialty type, explaining its scope and relevance.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the specialty type became active or valid in the system.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the specialty type entry.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the specialty type entry was created in the system.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the specialty type entry.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the specialty type entry was last updated or modified in the system.

Dictionary_Provider_Type_Crosswalk

Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The originating system or reference source for the provider type data.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code representing the provider type.

Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider type, explaining its classification or category.

Member_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier linking the provider type to a specific member type category.

Member_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the member type associated with the provider type.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the provider type crosswalk entry became active or valid in the system.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the provider type crosswalk entry.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the provider type crosswalk entry was created in the system.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the provider type crosswalk entry.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the provider type crosswalk entry was last updated or modified in the system.

Dictionary_RX_Patient_Relation

Patient_Relationship_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the type of relationship the patient has with the associated entity.

Patient_Relationship_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the type of relationship the patient has with the associated entity.

Attachment Dataset Specification

Dictionary_RX_Patient_Relation

Columns

  • Relation_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the type of relationship between entities.

  • Relation_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the patient's relationship type, explaining the nature of the relationship.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the relationship type entry is considered active or valid in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the relationship type entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the relationship type entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the relationship type entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the relationship type entry was last updated or modified in the system.

Dictionary_Race

Columns

  • Race_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code that represents a specific racial category.

  • Race_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the racial category represented by the code.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the race entry is considered active or valid in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the race entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the race entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the race entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the race entry was last updated or modified.

Dictionary_Request_Urgency

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier that represents a specific urgency level for requests.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed explanation of the urgency level represented by the code.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the urgency level is currently active (True/False).

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the urgency level entry is considered active or valid in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the urgency level entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the urgency level entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the urgency level entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the urgency level entry was last updated or modified.

Dictionary_Revenue_Code

Columns

  • Revenue_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier representing a specific revenue code used for billing and categorization.

  • Revenue_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed explanation or label describing the purpose of the revenue code.

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting range of revenue codes for categorization purposes.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending range of revenue codes for categorization purposes.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific set or category to which the revenue code belongs.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version number of the code set, indicating updates or revisions.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the revenue code is currently active (True/False).

  • Room_Board_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the revenue code is associated with room and board services.

  • RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A reference number indicating the source system for the revenue code data.

  • Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether episodes of care should be included under this revenue code.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the revenue code entry is considered active or valid in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the revenue code entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the revenue code entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the revenue code entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the revenue code entry was last updated or modified.

Dictionary_Risk_Score_Type

Columns

  • Score_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier representing a specific risk score type.

  • Score_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the risk score type, explaining its purpose and application.

  • Model_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the risk model associated with this score type.

  • Model_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the type of model (e.g., predictive, analytical) used to calculate the risk score.

  • Population_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the population group (e.g., pediatric, adult) for which the risk score applies.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the risk score type entry is considered active or valid.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the risk score type entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the risk score type entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the risk score type entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the risk score type entry was last updated or modified.

Attachment Dataset Specification

Dictionary_Risk_Score_Type

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the risk score type entry.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the risk score type entry was last updated or modified.

Dictionary_Service_CPT4

Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a specific medical service or procedure, typically in accordance with a standardized coding system (e.g., CPT).

Service_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the classification or type of service code set, indicating whether the code belongs to a particular system (e.g., CPT, ICD) or custom grouping.

Service_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the medical service or procedure corresponding to the service code, explaining its purpose or nature.

Service_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A brief, abbreviated name or description of the medical service, often used for quick reference or within space-limited contexts.

Service_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A more detailed and comprehensive name or description of the service, providing full context about the service provided.

Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service should be included in the episodes of care or whether it is treated independently.

Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of access or visibility the service code has within the system (e.g., private, public, restricted).

Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The start date or time period during which the service code becomes valid or applicable.

Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date or time period during which the service code remains valid or applicable.

Billable

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service is billable, meaning that it can be charged to a payer for reimbursement.

Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The start date or period during which the service is eligible for billing.

Billable_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date or period during which the service is no longer eligible for billing.

Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific set of codes (e.g., CPT, HCPCS, ICD) that the service code belongs to, indicating the coding system it adheres to.

Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version number of the service code set, which may change over time as coding standards are updated.

RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier or reference number for the RSS feed source from which the service code and associated information are sourced or derived.

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service code is currently active or in use, as opposed to being retired or inactive.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service code becomes effective and is applicable to any relevant transactions or records.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service code entry in the database.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service code entry was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the service code entry.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service code entry was last modified.

Dictionary_Service_HCPCS

Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a specific medical service or procedure, usually based on the HCPCS (Healthcare Common Procedure Coding System) code set.

Service_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the classification or type of the code set that the service code belongs to, such as HCPCS or other coding systems.

Service_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the medical service or procedure that corresponds to the service code, providing full context of the service provided.

Service_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A concise or abbreviated name for the medical service, typically used in contexts requiring a shortened description.

Service_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A more comprehensive and detailed name or description of the service, providing full context about the medical service.

Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service code is included in the episodes of care or treated separately.

Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of access or visibility for the service code, such as whether it is publicly visible, restricted, or private within the system.

Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The date or time when the service code becomes effective and valid.

Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The date or time when the service code is no longer valid or applicable.

Billable

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service is billable, meaning that it can be used for reimbursement claims.

Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The date or time when the service becomes eligible for billing.

Billable_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The date or time when the service is no longer eligible for billing.

Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific code set (e.g., HCPCS, CPT, ICD) to which the service code belongs, representing the classification system used.

Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version of the code set to which the service code belongs, which may be updated periodically as standards evolve.

RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier or reference number for the RSS feed source from which the service code and associated information are sourced or derived.

Attachment Dataset Specification

Dictionary_Service_HCPCS

TRING

  • Data Type: STRING

  • Description: An identifier for the RSS feed source from which the service code and its associated data are sourced.

Active

  • Data Type: STRING

  • Description: A flag indicating whether the service code is currently active, meaning it can be used in transactions or is still in effect.

Effective_From_Timestamp

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service code first becomes effective, marking the start of its applicability.

Created_User_ID

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service code entry in the system.

Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: The date and time when the service code entry was created in the database.

Last_Modified_User_ID

  • Data Type: STRING

  • Description: The unique identifier of the user who last updated or modified the service code entry.

Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: The date and time when the service code entry was last modified.

Dictionary_Service_ICD10

Service_Code

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a specific medical service or diagnosis, typically based on the ICD-10 (International Classification of Diseases, 10th Revision) coding system.

Service_Code_Set_Type

  • Data Type: STRING

  • Description: Specifies the classification or type of code set, indicating whether the code belongs to a particular system (e.g., ICD-10, ICD-9, or other medical coding systems).

Service_Description

  • Data Type: STRING

  • Description: A detailed description of the medical diagnosis, service, or procedure corresponding to the ICD-10 service code, explaining its nature and purpose.

Service_Short_Term

  • Data Type: STRING

  • Description: A concise or abbreviated version of the service description, typically used for quick reference or in situations requiring a shortened name.

Service_Long_Term

  • Data Type: STRING

  • Description: A more detailed and comprehensive name or description of the service or diagnosis, providing full context of the medical condition or treatment.

Include_Episodes_Flag

  • Data Type: STRING

  • Description: A flag indicating whether the service or diagnosis is included in the episodes of care, or whether it is considered separately in medical records.

Visibility_Level

  • Data Type: STRING

  • Description: Specifies the level of access or visibility the service code has within the system (e.g., public, restricted, private).

Code_Start

  • Data Type: STRING

  • Description: The start date or period during which the service or diagnosis code becomes valid and applicable.

Code_End

  • Data Type: STRING

  • Description: The end date or period during which the service or diagnosis code remains valid and applicable.

Billable

  • Data Type: STRING

  • Description: A flag indicating whether the service or diagnosis code is billable, meaning it can be used for reimbursement purposes.

Billable_Start

  • Data Type: STRING

  • Description: The start date or period during which the service or diagnosis code is eligible for billing.

Billable_End

  • Data Type: STRING

  • Description: The end date or period during which the service or diagnosis code is no longer eligible for billing.

Code_Set

  • Data Type: STRING

  • Description: The specific code set (e.g., ICD-10, ICD-9) that the service code belongs to, indicating which classification system is used for coding.

Code_Version

  • Data Type: STRING

  • Description: The version number of the ICD-10 code set that the service or diagnosis code is a part of, which may change over time with updates to the coding system.

RSS_Source_Number

  • Data Type: STRING

  • Description: An identifier for the RSS feed source from which the service code and associated data are derived or sourced.

Active

  • Data Type: STRING

  • Description: A flag indicating whether the service code is currently active and in use, or whether it has been retired or is inactive.

Effective_From_Timestamp

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service or diagnosis code first becomes effective and applicable to relevant medical records or transactions.

Created_User_ID

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service or diagnosis code entry in the database.

Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: The date and time when the service or diagnosis code entry was created in the system.

Last_Modified_User_ID

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the service or diagnosis code entry.

Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: The date and time when the service or diagnosis code entry was last modified.

Dictionary_Service_ICD9

Service_Code

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a specific medical diagnosis or service, typically based on the ICD-9 (International Classification of Diseases, 9th Revision) coding system.

Service_Code_Set_Type

  • Data Type: STRING

  • Description: Specifies the classification or type of code set, indicating whether the code belongs to the ICD-9 system or another medical coding standard (e.g., ICD-10, CPT).

Service_Description

  • Data Type: STRING

  • Description: A detailed description of the medical diagnosis or service corresponding to the ICD-9 service code, explaining the nature and details of the condition or procedure.

Service_Short_Term

  • Data Type: STRING

  • Description: A concise or abbreviated version of the service description, typically used for quick reference or in situations requiring a shortened name.

Service_Long_Term

  • Data Type: STRING

  • Description: A more detailed and comprehensive description of the diagnosis or service, providing full context about the medical condition or procedure.

Include_Episodes_Flag

  • Data Type: STRING

  • Description: A flag indicating whether the service or diagnosis code is included in episodes of care, or whether it is considered separately in medical records.

Attachment Dataset Specification

Dictionary_Service_ICD9

Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of access or visibility the service code has within the system, such as public, restricted, or private.

Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The start date or time when the service or diagnosis code becomes valid and applicable.

Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date or time when the service or diagnosis code is no longer valid or applicable.

Billable

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service or diagnosis code is billable, meaning it is eligible for reimbursement by payers.

Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The date or time when the service or diagnosis code becomes eligible for billing or reimbursement.

Billable_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The date or time when the service or diagnosis code is no longer eligible for billing or reimbursement.

Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific coding system or set (e.g., ICD-9) that the service code belongs to, defining which classification system is used for the diagnosis or service.

Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version number of the ICD-9 code set that the service or diagnosis code belongs to, reflecting updates or changes in the coding system.

RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier for the RSS feed source from which the service code and related data are derived.

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service code is currently active, meaning it can be used in medical records and billing, or if it has been retired or deactivated.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service or diagnosis code first becomes valid and applicable to medical records or billing transactions.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service or diagnosis code entry in the system.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service or diagnosis code entry was created in the database.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the service or diagnosis code entry.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service or diagnosis code entry was last modified in the database.

Dictionary_Service_Introducer

Service_Introducer_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a service introducer, which refers to the person, organization, or system that introduces or initiates a medical service or procedure.

Service_Introducer_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the service introducer, explaining the role, function, or purpose of the entity or system introducing the medical service or procedure.

Service_Introducer_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The classification or category under which the service introducer falls, such as physician, hospital, or healthcare provider.

Service_Scheme_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code that identifies the scheme or plan under which the medical service or procedure is introduced, which may refer to insurance, payment models, or healthcare programs.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service introducer becomes valid or active in the system, marking the start of its applicability.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service introducer entry in the database.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service introducer entry was created in the system or database.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the service introducer entry.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service introducer entry was last modified in the database.

Dictionary_Service_Modifier_CPT4

Service_Modifier_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code assigned to a service modifier, which provides additional information about a procedure or service, typically used in CPT (Current Procedural Terminology) coding.

Service_Modifier_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the classification or type of the code set to which the service modifier belongs, such as CPT4 or other medical coding systems.

Service_Modifier_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the service modifier, explaining the purpose or nature of the modifier and how it alters or clarifies the primary procedure or service code.

Service_Modifier_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A more detailed or comprehensive description of the service modifier, offering an extended explanation of its use or application in the medical context.

Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The start date or period when the service modifier code becomes effective and applicable in medical billing or coding transactions.

Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date or period when the service modifier code is no longer applicable, marking the expiration of its validity in coding systems.

Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The coding system or set (e.g., CPT4) that the service modifier belongs to, specifying the framework in which the modifier is used.

Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version number of the code set that the service modifier is a part of, which can change over time as the coding standards are updated.

Attachment Dataset Specification

Dictionary_Service_Modifier_CPT4

Columns

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service modifier is currently active and valid for use in medical coding and billing.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service modifier code becomes effective and applicable for use in transactions or medical records.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service modifier entry in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service modifier entry was created in the database.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the service modifier entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service modifier entry was last modified in the system.

Dictionary_Service_Modifier_HCPCS

Columns

  • Service_Modifier_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code assigned to a service modifier, which provides additional information about a procedure or service, typically used in HCPCS (Healthcare Common Procedure Coding System).

  • Service_Modifier_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the classification or type of the code set to which the service modifier belongs, such as HCPCS or other medical coding systems.

  • Service_Modifier_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the service modifier, explaining its purpose or nature and how it alters or clarifies the primary procedure or service code.

  • Service_Modifier_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A more detailed or comprehensive description of the service modifier, offering an extended explanation of its use or application in medical coding and billing.

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The start date or period when the service modifier code becomes effective and applicable in medical billing or coding transactions.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date or period when the service modifier code is no longer applicable, marking the expiration of its validity in coding systems.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The coding system or set (e.g., HCPCS) that the service modifier belongs to, specifying the framework in which the modifier is used.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version number of the code set that the service modifier is a part of, which can change over time as the coding standards are updated.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service modifier is currently active and valid for use in medical coding and billing.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service modifier code becomes effective and applicable for use in transactions or medical records.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service modifier entry in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service modifier entry was created in the database.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the service modifier entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service modifier entry was last modified in the system.

Dictionary_Service_Setting_Code

Columns

  • Service_Setting_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code that identifies a specific setting or environment in which a medical service or procedure is provided, such as an outpatient clinic, hospital, or home care setting.

  • Service_Setting_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the service setting, explaining the environment or context in which the medical service or procedure is performed.

  • Service_Location_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing the specific physical location or facility where the medical service or procedure is provided (e.g., hospital, clinic, or physician’s office).

  • RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier for the RSS feed source from which the setting code and associated data are sourced or derived.

  • Place_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code that classifies or categorizes the group of places where services are delivered, which can be used for organizational or billing purposes.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of visibility or access that the service setting code has within the system, such as public, restricted, or private access.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service setting code becomes valid and applicable, marking the start of its usage in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service setting code entry in the database.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service setting code entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the service setting code entry in the database.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service setting code entry was last modified in the system.

Dictionary_Source_Of_Payment_Typology

Columns

  • Concept_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a specific concept in the payment typology.

Attachment Dataset Specification

Dictionary: Source of Payment Typology

Concept Name

  • Column Name: Concept_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name associated with the concept code, describing the specific concept within the source of payment typology, such as a specific payment model or category.

Preferred Concept Name

  • Column Name: Preferred_Concept_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The most commonly used or recommended name for the concept, preferred for clarity or consistency in the context of payment typology.

Preferred Alternate Code

  • Column Name: Preferred_Alternate_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An alternate code that can be used for the same concept, offering flexibility or compatibility with other coding systems or terminology.

Code System ID

  • Column Name: Code_System_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the code system to which the concept code belongs, such as ICD, CPT, or another relevant coding system used for payment typology.

Code System Name

  • Column Name: Code_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the coding system that the concept code belongs to, such as the ICD-10, CPT, or HCPCS coding systems.

Code System Code

  • Column Name: Code_System_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code that identifies the specific version or set of codes within the coding system, potentially linking to a particular standard version or update.

Code System Version

  • Column Name: Code_System_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version of the code system used for the concept, reflecting updates or changes in the coding standards (e.g., ICD-10 vs. ICD-11).

HL7 Table 0396 Code

  • Column Name: HL7_Table_0396_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code from the HL7 (Health Level 7) Table 0396, which is a standardized code system used in healthcare data exchange for payment typology and related concepts.

Value Set Concept Description

  • Column Name: Value_Set_Concept_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the concept within the value set, explaining the nature and context of the concept in the source of payment typology.

Value Set Code

  • Column Name: Value_Set_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique code that identifies a specific value set, which is a collection of codes or concepts grouped together under a common categorization or purpose.

Value Set Version

  • Column Name: Value_Set_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version number of the value set, indicating when the value set was last updated or modified, ensuring that the concept codes align with the most current standard.

Effective From Timestamp

  • Column Name: Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the concept and associated codes or descriptions become valid and applicable for use in the payment typology system.

Created User ID

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the source of payment typology entry in the system.

Created Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the source of payment typology entry was created in the system or database.

Last Modified User ID

  • Column Name: Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the source of payment typology entry.

Last Modified Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the source of payment typology entry was last modified in the database.

Dictionary: State Province

State Province Code

  • Column Name: State_Province_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a state or province, used to represent a specific geographic region or administrative division within a country.

State Province Name

  • Column Name: State_Province_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the state or province, such as "California" or "Ontario," representing a specific geographic area within a country.

Effective From Timestamp

  • Column Name: Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the state or province code becomes valid or effective in the system, marking the start of its usage.

Created User ID

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the state or province entry in the database.

Created Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the state or province entry was created in the system.

Last Modified User ID

  • Column Name: Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the state or province entry in the system.

Last Modified Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the state or province entry was last modified in the system.

Dictionary: Subclient

Subclient Code

  • Column Name: Subclient_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a subclient, representing a distinct business unit or subsidiary within a larger organization or client structure.

Subclient Description

  • Column Name: Subclient_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the subclient, explaining the specific function, role, or purpose of the subclient within the overall organization or system.

Effective From Timestamp

  • Column Name: Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the subclient code becomes valid or applicable in the system, marking the start of its usage.

Created User ID

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the subclient entry in the database.

Created Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the subclient entry was created in the system.

Last Modified User ID

  • Column Name: Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the subclient entry in the database.

Last Modified Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the subclient entry was last modified in the system.

Dictionary: System Source

System Source Code

  • Column Name: System_Source_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a system source, representing the origin or provider of a system or.

Attachment Dataset Specification

Dictionary System Source

System Source Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the system source, indicating the specific source or system from which data is derived, such as a particular database or external information provider.

Effective From Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the system source code becomes valid or applicable in the system, marking the start of its usage.

Created User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the system source entry in the database.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the system source entry was created in the system.

Last Modified User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the system source entry in the database.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the system source entry was last modified in the system.

Dictionary Treatment Setting Code

Treatment Setting

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code representing a specific treatment setting, such as inpatient, outpatient, or home care, where medical treatments or procedures are provided.

Treatment Setting Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the treatment setting, explaining the type of care or treatment environment associated with the setting, such as "hospital" or "rehabilitation center."

Visibility Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of visibility or access to the treatment setting code within the system, indicating whether it is public, restricted, or private.

Effective From Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the treatment setting code becomes valid and applicable for use in the system.

Created User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the treatment setting entry in the database.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the treatment setting entry was created in the system.

Last Modified User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the treatment setting entry in the system.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the treatment setting entry was last modified in the system.

Dictionary Visibility Level

Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier or code representing a specific visibility level, such as "Public," "Restricted," or "Private," that defines the access control for certain data elements.

Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed explanation of the visibility level, describing its purpose, scope, and restrictions, such as who can access or view the data associated with the level.

Effective From Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the visibility level becomes valid and applicable in the system.

Created User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the visibility level entry in the database.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the visibility level entry was created in the system.

Last Modified User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the visibility level entry in the system.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the visibility level entry was last modified in the system.

Dictionary Visibility Level Mapping

Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The origin or source of the data that is being mapped to a specific visibility level, which could refer to a system, data set, or process that defines the visibility assignment.

Visibility Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific visibility level (such as "Public," "Restricted," or "Private") assigned to the data source, indicating the access control and restrictions for the data.

Effective From Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the visibility level mapping becomes valid and applicable for use in the system, marking the start of its usage.

Created User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the visibility level mapping entry in the system.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the visibility level mapping entry was created in the system.

Last Modified User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the visibility level mapping entry in the system.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the visibility level mapping entry was last modified in the system.

Attachment

  • Description: Stores records of various documents or files attached to specific entities within the healthcare system, such as patient records, treatment plans, or administrative documents. Each entry includes details about the attachment type, content, and purpose, ensuring that all relevant information is systematically cataloged and easily accessible.

Attachment Log

  • Description: Maintains a detailed history of changes, updates, and actions taken on attachments. This log provides a chronological audit trail of when and by whom attachments were accessed, modified, or removed, supporting transparency, accountability, and compliance with healthcare regulations.

Attachment Raw

  • Description: Contains unprocessed, detailed data related to the attachments. This raw data is essential for in-depth analysis and auditing.

Attachment Dataset Specification

Overview

The Attachment Dataset Specification provides a detailed structure and description of all attachment-related activities before any aggregation or transformation. This dataset is critical for tracking, auditing, and research purposes, offering a granular view of the data.

Attachment Table

Table Description

The Attachment table contains detailed information about attachments, including metadata, classification, status, and ownership. Below is the specification for each column in the table.

Table Content

Column Name

Is Nullable

Data Type

Description

Member_ID

YES

STRING

Identifier for the member associated with the attachment, linking the document to a specific member's record.

Attachment_Key

YES

INT64

Unique key for identifying the attachment within the system, used as a primary reference.

Attachment_Class

YES

STRING

Category or classification of the attachment, indicating the nature or purpose of the document.

Attachment_Class_Description

YES

STRING

Detailed explanation of the attachment class, providing context about the type of document.

Screening_Key

YES

INT64

Identifier linking the attachment to a specific screening event or process, if applicable.

Request_Key

YES

INT64

Unique identifier linking the attachment to a specific service request or case in the system.

Member_Key

YES

INT64

A unique identifier that correlates the attachment specifically to the member’s record in the database.

Program_ID

YES

STRING

Identifier for the program associated with the attachment, if it is part of a program-specific documentation.

Request_ID

YES

STRING

String identifier for the service request or case to which the attachment is related.

Attachment_Type

YES

STRING

Code or identifier specifying the format or kind of attachment (e.g., PDF, image, document).

Attachment_Type_Description

YES

STRING

Description of the attachment type, detailing the format or nature of the file.

Attachment_Status

YES

STRING

Status code indicating the current state of the attachment (e.g., active, archived, pending review).

Attachment_Status_Description

YES

STRING

Detailed explanation of the current status of the attachment.

Title

YES

STRING

The title or name of the attachment, often used as a label or short description.

Location

YES

STRING

The physical or digital location where the attachment is stored or accessible.

File_Name

YES

STRING

The name of the file as stored in the system, which may include a file extension indicating the file type.

Document_ID

YES

STRING

A unique identifier for the document within the system, used for tracking and reference.

External_Document_ID

YES

STRING

An identifier for the document that is recognized outside the system, possibly by an external document management system.

Uploaded_Timestamp

YES

TIMESTAMP

The date and time when the attachment was uploaded to the system.

Active

YES

BOOL

A boolean indicator of whether the attachment is currently active and relevant.

Source_System

YES

STRING

The system or platform from which the attachment originates.

Source_System_Description

YES

STRING

Description or details about the source system providing the attachment.

Owner_User_ID

YES

STRING

Identifier of the user who owns or is responsible for the attachment.

Created_Timestamp

YES

TIMESTAMP

The timestamp marking when the attachment was first created or added to the system.

Last_Modified_Timestamp

YES

TIMESTAMP

The most recent timestamp when the attachment was modified.

Record_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating the last modification made to the record, providing a historical audit trail.

Transaction_User_ID

YES

STRING

User ID associated with the last transaction made on the attachment, for tracking and audit purposes.

Deleted_Indicator

YES

BOOL

Boolean flag indicating whether the attachment has been marked as deleted in the system.

Type

YES

STRING

A classification or category type of the attachment, providing further context or grouping.

Tenant

YES

STRING

The tenant or domain within which the attachment is managed, useful in multi-tenant systems.

Active_Version

YES

BOOL

Indicates whether the current record is the active or most up-to-date version of the attachment.

Date

YES

DATE

The date associated with the attachment, often reflecting when it was created or logged.

Sequence

YES

INT64

A sequence number or order identifier for the attachment, possibly indicating its position in a series or process.

Source_System_Name

YES

STRING

The name of the source system from which the attachment originates, aiding in traceability.

Source_Timestamp

YES

TIMESTAMP

The timestamp from the source system when the attachment was originally created or logged.

Source_File_Name

YES

STRING

The original file name of the attachment in the source system, helpful for cross-referencing.

Schema_Version

YES

FLOAT64

The version of the data schema under which the attachment record is managed.

Member_Partition

YES

INT64

An identifier used to partition the data by member, aiding in data organization and retrieval.

_updated

YES

STRING

A field indicating when the attachment record was last updated in the dataset.

Owner_User_Name

YES

STRING

The original owner user name of the attachment.

Attachment Log Table

Table Description

The Attachment_log table provides a historical log of attachment-related activities, capturing changes and updates for audit and tracking purposes.

Table Content

Column Name

Is Nullable

Data Type

Description

Member_ID

YES

STRING

Identifier for the member associated with the attachment.

Attachment_Key

YES

INT64

Unique identifier for the attachment.

Attachment Dataset Specification

Attachment Log

Table Structure

Column Name

Is Nullable

Data Type

Description

Attachment_Class

YES

STRING

Category or class of the attachment.

Attachment_Class_Description

YES

STRING

Detailed description of the attachment class.

Screening_Key

YES

INT64

Identifier linking the attachment to a specific screening, if applicable.

Request_Key

YES

INT64

Key relating the attachment to a specific request or case.

Member_Key

YES

INT64

Unique identifier for the member in the context of the attachment.

Program_ID

YES

STRING

Identifier for the program associated with the attachment.

Request_ID

YES

STRING

Specific request identifier associated with the attachment.

Attachment_Type

YES

STRING

Type or format of the attachment (e.g., PDF, image).

Attachment_Type_Description

YES

STRING

Descriptive details about the type of attachment.

Attachment_Status

YES

STRING

Current status of the attachment (e.g., active, archived).

Attachment_Status_Description

YES

STRING

Description of what each status represents.

Title

YES

STRING

Title or name given to the attachment.

Location

YES

STRING

Storage location or path of the attachment.

File_Name

YES

STRING

Name of the file attached.

Document_ID

YES

STRING

Internal identifier for the document.

External_Document_ID

YES

STRING

External or third-party identifier for the attachment.

Uploaded_Timestamp

YES

TIMESTAMP

Date and time the attachment was uploaded.

Active

YES

BOOL

Indicates whether the attachment is currently active or not.

Source_System

YES

STRING

System from which the attachment originated.

Source_System_Description

YES

STRING

Description of the source system.

Owner_User_ID

YES

STRING

User ID of the individual who owns the attachment.

Created_Timestamp

YES

TIMESTAMP

Timestamp for when the attachment was initially created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp for the most recent modification to the attachment.

Record_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating the last change to the record.

Transaction_User_ID

YES

STRING

Identifier for the user who performed the last transaction on the attachment.

Deleted_Indicator

YES

BOOL

Flag indicating if the attachment has been marked as deleted.

Type

YES

STRING

General type classification of the attachment.

Tenant

YES

STRING

Identifier for the tenant or domain within which the attachment is managed.

Active_Version

YES

BOOL

Indicates whether this version of the attachment is the active one in use.

Date

YES

DATE

Date associated with the attachment record.

Sequence

YES

INT64

Sequence number for the attachment, indicating its order or version.

Source_System_Name

YES

STRING

Name of the system from which the attachment originates.

Source_Timestamp

YES

TIMESTAMP

Timestamp from the source system when the attachment was created or modified.

Source_File_Name

YES

STRING

File name in the source system for the attachment.

Schema_Version

YES

FLOAT64

Version of the data schema to which the attachment conforms.

Member_Partition

YES

INT64

Partition identifier used for data segmentation and optimization in storage.

_updated

YES

STRING

Indicates when the attachment record was last updated.

Action

YES

STRING

Describes the action taken in the log for the attachment (e.g., created, updated, deleted).

Transaction_Actor_Type

YES

STRING

Type of the actor performing the transaction.

Attachment Raw

Table Structure

Column Name

Is Nullable

Data Type

Description

Member_ID

YES

STRING

Unique identifier for the member associated with the attachment.

Attachment_Key

YES

INT64

Unique key for the attachment.

Attachment_Class

YES

STRING

Class of the attachment, defining its category.

Attachment_Class_Description

YES

STRING

Description of the attachment class.

Screening_Key

YES

INT64

Unique key for the screening associated with the attachment.

Request_Key

YES

INT64

Unique key for the request associated with the attachment.

Member_Key

YES

INT64

Unique key for the member associated with the attachment.

Program_ID

YES

STRING

Identifier for the program associated with the attachment.

Request_ID

YES

STRING

Identifier for the request associated with the attachment.

Attachment_Type

YES

STRING

Type of the attachment.

Attachment_Type_Description

YES

STRING

Description of the attachment type.

Attachment_Status

YES

STRING

Status of the attachment.

Attachment_Status_Description

YES

STRING

Description of the attachment status.

Title

YES

STRING

Title of the attachment.

Location

YES

STRING

Location where the attachment is stored.

File_Name

YES

STRING

Name of the file associated with the attachment.

Document_ID

YES

STRING

Unique identifier for the document.

Attachment Dataset Specification

Attachment_raw Table

Column Name

Is Nullable

Data Type

Description

External_Document_ID

YES

STRING

External identifier for the document associated with the attachment.

Uploaded_Timestamp

YES

TIMESTAMP

Timestamp when the attachment was uploaded.

Active

YES

BOOL

Indicator whether the attachment is active.

Source_System

YES

STRING

Source system from where the attachment originated.

Source_System_Description

YES

STRING

Description of the source system.

Owner_User_ID

YES

STRING

Identifier for the user who owns the attachment.

Created_Timestamp

YES

TIMESTAMP

Timestamp when the attachment was created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when the attachment was last modified.

Record_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when the record was last modified.

Transaction_User_ID

YES

STRING

Identifier for the user who performed the transaction.

Deleted_Indicator

YES

BOOL

Indicator whether the attachment is deleted.

Type

YES

STRING

Type of the attachment.

Tenant

YES

STRING

Tenant associated with the attachment.

Active_Version

YES

BOOL

Indicator whether the attachment is the active version.

Date

YES

DATE

Date associated with the attachment.

Sequence

YES

INT64

Sequence number of the attachment.

Source_System_Name

YES

STRING

Name of the source system.

Source_Timestamp

YES

TIMESTAMP

Timestamp when the data was sourced.

Source_File_Name

YES

STRING

Name of the source file.

Schema_Version

YES

FLOAT64

Version of the schema.

Member_Partition

YES

INT64

Partition number for the member associated with the attachment.

_updated

YES

STRING

Timestamp indicating the last update of the attachment record.

Transaction_Actor_Type

YES

STRING

Type of the actor performing the transaction.

Dictionary_Prescription_Origin Table

Column Name

Is Nullable

Data Type

Description

Origin_Code

YES

STRING

A unique identifier or code representing the origin of a prescription, such as electronic, written, or verbal.

Origin_Description

YES

STRING

A detailed description of the prescription origin, providing context or additional information about the origin type.

Effective_From_Timestamp

YES

TIMESTAMP

The date and time when the prescription origin entry became valid and active within the system.

Created_User_ID

YES

STRING

The unique identifier of the user who created the prescription origin entry in the system.

Created_Timestamp

YES

TIMESTAMP

The date and time when the prescription origin entry was created in the system.

Last_Modified_User_ID

YES

STRING

The unique identifier of the user who last modified the prescription origin entry in the system.

Last_Modified_Timestamp

YES

TIMESTAMP

The date and time when the prescription origin entry was last updated or modified in the system.

Dictionary_Provider_Specialty_Crosswalk Table

Column Name

Is Nullable

Data Type

Description

Taxonomy_Code

YES

STRING

A unique code representing the provider's taxonomy, typically based on healthcare specialty classification standards.

Taxonomy_Description

YES

STRING

A detailed description of the taxonomy code, explaining the healthcare specialty or classification it represents.

Insights_Specialty_Code

YES

STRING

A unique code used within the system to represent a provider specialty as per internal insights or classifications.

Insights_Specialty_Description

YES

STRING

A detailed description of the internal insights specialty code, explaining the provider's specialty or area of expertise.

Crosswalk_Priority

YES

STRING

A priority level indicating the relevance or precedence of this crosswalk mapping when multiple mappings exist for a provider specialty.

CMS_Specialty_Code

YES

STRING

A code representing the provider's specialty as defined by the Centers for Medicare and Medicaid Services (CMS).

CMS_Specialty_Description

YES

STRING

A detailed description of the CMS specialty code, explaining the corresponding provider's specialty or classification.

Effective_From_Timestamp

YES

TIMESTAMP

The date and time when the crosswalk entry became valid and active in the system.

Created_User_ID

YES

STRING

The unique identifier of the user who created the crosswalk entry in the system.

Created_Timestamp

YES

TIMESTAMP

The date and time when the crosswalk entry was created in the system.

Last_Modified_User_ID

YES

STRING

The unique identifier of the user who last modified the crosswalk entry in the system.

Last_Modified_Timestamp

YES

TIMESTAMP

The date and time when the crosswalk entry was last updated or modified in the system.

Attachment Dataset Specification

Dictionary Provider Specialty Taxonomy

Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing a specific taxonomy entry for a provider specialty.

Undefined

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag or status indicator to identify if the taxonomy code is undefined or not assigned to a specific specialty.

Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed explanation or description of the taxonomy code and its relevance to a provider's specialty.

Patient_Centered_Medical_Home_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the specialty is associated with a patient-centered medical home (PCMH) model of care.

Grouping

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The broader category or grouping under which the provider specialty falls.

Classification

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A specific classification within the grouping that provides further granularity of the provider specialty.

Specialization

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A more detailed or focused description of the provider's area of specialization within the classification.

Definition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A formal definition of the provider specialty or taxonomy entry, detailing its scope and purpose.

Notes

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional comments or notes related to the taxonomy entry, often used for clarifications or special considerations.

Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the visibility or accessibility of the taxonomy entry within the system, such as internal or external visibility.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the taxonomy entry became active or valid in the system.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the taxonomy entry.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the taxonomy entry was created in the system.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the taxonomy entry.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the taxonomy entry was last updated or modified in the system.

Dictionary Provider Specialty Type

Specialty_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code representing a specific type of provider specialty.

Specialty_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider specialty type, explaining its scope and relevance.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the specialty type became active or valid in the system.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the specialty type entry.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the specialty type entry was created in the system.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the specialty type entry.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the specialty type entry was last updated or modified in the system.

Dictionary Provider Type Crosswalk

Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The originating system or reference source for the provider type data.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code representing the provider type.

Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider type, explaining its classification or category.

Member_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier linking the provider type to a specific member type category.

Member_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the member type associated with the provider type.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the provider type crosswalk entry became active or valid in the system.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the provider type crosswalk entry.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the provider type crosswalk entry was created in the system.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the provider type crosswalk entry.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the provider type crosswalk entry was last updated or modified in the system.

Dictionary RX Patient Relation

Patient_Relationship_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the type of relationship the patient has with the associated entity.

Patient_Relationship_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the patient's relationship type, explaining the nature of the relationship.

Attachment Dataset Specification

Dictionary_RX_Patient_Relation

Columns

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the relationship type entry is considered active or valid in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the relationship type entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the relationship type entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the relationship type entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the relationship type entry was last updated or modified in the system.

Dictionary_Race

Columns

  • Race_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code that represents a specific racial category.

  • Race_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the racial category represented by the code.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the race entry is considered active or valid in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the race entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the race entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the race entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the race entry was last updated or modified.

Dictionary_Request_Urgency

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier that represents a specific urgency level for requests.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed explanation of the urgency level represented by the code.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the urgency level is currently active (True/False).

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the urgency level entry is considered active or valid in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the urgency level entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the urgency level entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the urgency level entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the urgency level entry was last updated or modified.

Dictionary_Revenue_Code

Columns

  • Revenue_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier representing a specific revenue code used for billing and categorization.

  • Revenue_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed explanation or label describing the purpose of the revenue code.

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting range of revenue codes for categorization purposes.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending range of revenue codes for categorization purposes.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific set or category to which the revenue code belongs.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version number of the code set, indicating updates or revisions.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the revenue code is currently active (True/False).

  • Room_Board_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the revenue code is associated with room and board services.

  • RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A reference number indicating the source system for the revenue code data.

  • Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether episodes of care should be included under this revenue code.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the revenue code entry is considered active or valid in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the revenue code entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the revenue code entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the revenue code entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the revenue code entry was last updated or modified.

Dictionary_Risk_Score_Type

Columns

  • Score_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier representing a specific risk score type.

  • Score_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the risk score type, explaining its purpose and application.

  • Model_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the risk model associated with this score type.

  • Model_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the type of model (e.g., predictive, analytical) used to calculate the risk score.

  • Population_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the population group (e.g., pediatric, adult) for which the risk score type is applicable.

Attachment Dataset Specification

Dictionary_Risk_Score_Type

Columns

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the risk score type entry is considered active or valid.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the risk score type entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the risk score type entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the risk score type entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the risk score type entry was last updated or modified.

Dictionary_Service_CPT4

Columns

  • Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a specific medical service or procedure, typically in accordance with a standardized coding system (e.g., CPT).

  • Service_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the classification or type of service code set, indicating whether the code belongs to a particular system (e.g., CPT, ICD) or custom grouping.

  • Service_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the medical service or procedure corresponding to the service code, explaining its purpose or nature.

  • Service_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A brief, abbreviated name or description of the medical service, often used for quick reference or within space-limited contexts.

  • Service_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A more detailed and comprehensive name or description of the service, providing full context about the service provided.

  • Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service should be included in the episodes of care or whether it is treated independently.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of access or visibility the service code has within the system (e.g., private, public, restricted).

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The start date or time period during which the service code becomes valid or applicable.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date or time period during which the service code remains valid or applicable.

  • Billable

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service is billable, meaning that it can be charged to a payer for reimbursement.

  • Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The start date or period during which the service is eligible for billing.

  • Billable_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date or period during which the service is no longer eligible for billing.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific set of codes (e.g., CPT, HCPCS, ICD) that the service code belongs to, indicating the coding system it adheres to.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version number of the service code set, which may change over time as coding standards are updated.

  • RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier or reference number for the RSS feed source from which the service code and associated information are sourced or derived.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service code is currently active or in use, as opposed to being retired or inactive.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service code becomes effective and is applicable to any relevant transactions or records.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service code entry in the database.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service code entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the service code entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service code entry was last modified.

Dictionary_Service_HCPCS

Columns

  • Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a specific medical service or procedure, usually based on the HCPCS (Healthcare Common Procedure Coding System) code set.

  • Service_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the classification or type of the code set that the service code belongs to, such as HCPCS or other coding systems.

  • Service_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the medical service or procedure that corresponds to the service code, providing full context of the service provided.

  • Service_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A concise or abbreviated name for the medical service, typically used in contexts requiring a shortened description.

  • Service_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A more comprehensive and detailed name or description of the service, providing full context about the medical service.

  • Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service code is included in the episodes of care or treated separately.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of access or visibility for the service code, such as whether it is publicly visible, restricted, or private within the system.

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The date or time period during which the service code becomes valid or applicable.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date or time period during which the service code remains valid or applicable.

Attachment Dataset Specification

Dictionary_Service_HCPCS

Columns

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The date or time when the service code becomes effective and valid.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The date or time when the service code is no longer valid or applicable.

  • Billable

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service is billable, meaning that it can be used for reimbursement claims.

  • Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The date or time when the service becomes eligible for billing.

  • Billable_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The date or time when the service is no longer eligible for billing.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific code set (e.g., HCPCS, CPT, ICD) to which the service code belongs, representing the classification system used.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version of the code set to which the service code belongs, which may be updated periodically as standards evolve.

  • RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier for the RSS feed source from which the service code and its associated data are sourced.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service code is currently active, meaning it can be used in transactions or is still in effect.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service code first becomes effective, marking the start of its applicability.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service code entry in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service code entry was created in the database.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last updated or modified the service code entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service code entry was last modified.

Dictionary_Service_ICD10

Columns

  • Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a specific medical service or diagnosis, typically based on the ICD-10 (International Classification of Diseases, 10th Revision) coding system.

  • Service_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the classification or type of code set, indicating whether the code belongs to a particular system (e.g., ICD-10, ICD-9, or other medical coding systems).

  • Service_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the medical diagnosis, service, or procedure corresponding to the ICD-10 service code, explaining its nature and purpose.

  • Service_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A concise or abbreviated version of the service description, typically used for quick reference or in situations requiring a shortened name.

  • Service_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A more detailed and comprehensive name or description of the service or diagnosis, providing full context of the medical condition or treatment.

  • Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service or diagnosis is included in the episodes of care, or whether it is considered separately in medical records.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of access or visibility the service code has within the system (e.g., public, restricted, private).

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The start date or period during which the service or diagnosis code becomes valid and applicable.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date or period during which the service or diagnosis code remains valid and applicable.

  • Billable

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service or diagnosis code is billable, meaning it can be used for reimbursement purposes.

  • Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The start date or period during which the service or diagnosis code is eligible for billing.

  • Billable_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date or period during which the service or diagnosis code is no longer eligible for billing.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific code set (e.g., ICD-10, ICD-9) that the service code belongs to, indicating which classification system is used for coding.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version number of the ICD-10 code set that the service or diagnosis code is a part of, which may change over time with updates to the coding system.

  • RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier for the RSS feed source from which the service code and associated data are derived or sourced.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service code is currently active and in use, or whether it has been retired or is inactive.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service or diagnosis code first becomes effective and applicable to relevant medical records or transactions.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service or diagnosis code entry in the database.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service or diagnosis code entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the service or diagnosis code entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service or diagnosis code entry was last modified.

Attachment Dataset Specification

Dictionary_Service_ICD9

Columns

  • Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a specific medical diagnosis or service, typically based on the ICD-9 (International Classification of Diseases, 9th Revision) coding system.

  • Service_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the classification or type of code set, indicating whether the code belongs to the ICD-9 system or another medical coding standard (e.g., ICD-10, CPT).

  • Service_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the medical diagnosis or service corresponding to the ICD-9 service code, explaining the nature and details of the condition or procedure.

  • Service_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A concise or abbreviated version of the service description, typically used for quick reference or in situations requiring a shortened name.

  • Service_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A more detailed and comprehensive description of the diagnosis or service, providing full context about the medical condition or procedure.

  • Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service or diagnosis code is included in episodes of care, or whether it is treated independently in medical records.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of access or visibility the service code has within the system, such as public, restricted, or private.

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The start date or time when the service or diagnosis code becomes valid and applicable.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The end date or time when the service or diagnosis code is no longer valid or applicable.

  • Billable

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service or diagnosis code is billable, meaning it is eligible for reimbursement by payers.

  • Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The date or time when the service or diagnosis code becomes eligible for billing or reimbursement.

  • Billable_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The date or time when the service or diagnosis code is no longer eligible for billing or reimbursement.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific coding system or set (e.g., ICD-9) that the service code belongs to, defining which classification system is used for the diagnosis or service.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version number of the ICD-9 code set that the service or diagnosis code belongs to, reflecting updates or changes in the coding system.

  • RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier for the RSS feed source from which the service code and related data are derived.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the service code is currently active, meaning it can be used in medical records and billing, or if it has been retired or deactivated.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service or diagnosis code first becomes valid and applicable to medical records or billing transactions.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service or diagnosis code entry in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service or diagnosis code entry was created in the database.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the service or diagnosis code entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service or diagnosis code entry was last modified in the database.

Dictionary_Service_Introducer

Columns

  • Service_Introducer_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a service introducer, which refers to the person, organization, or system that introduces or initiates a medical service or procedure.

  • Service_Introducer_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the service introducer, explaining the role, function, or purpose of the entity or system introducing the medical service or procedure.

  • Service_Introducer_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The classification or category under which the service introducer falls, such as physician, hospital, or healthcare provider.

  • Service_Scheme_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code that identifies the scheme or plan under which the medical service or procedure is introduced, which may refer to insurance, payment models, or healthcare programs.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service introducer becomes valid or active in the system, marking the start of its applicability.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service introducer entry in the database.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service introducer entry was created in the system or database.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the service introducer entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service introducer entry was last modified in the database.

Attachment Dataset Specification

Dictionary_Service_Modifier_CPT4

Table Content

Column Name

Is Nullable

Data Type

Description

Service_Modifier_Code

YES

STRING

A unique code assigned to a service modifier, which provides additional information about a procedure or service, typically used in CPT (Current Procedural Terminology) coding.

Service_Modifier_Code_Set_Type

YES

STRING

Specifies the classification or type of the code set to which the service modifier belongs, such as CPT4 or other medical coding systems.

Service_Modifier_Description

YES

STRING

A detailed description of the service modifier, explaining the purpose or nature of the modifier and how it alters or clarifies the primary procedure or service code.

Service_Modifier_Long_Term

YES

STRING

A more detailed or comprehensive description of the service modifier, offering an extended explanation of its use or application in the medical context.

Code_Start

YES

STRING

The start date or period when the service modifier code becomes effective and applicable in medical billing or coding transactions.

Code_End

YES

STRING

The end date or period when the service modifier code is no longer applicable, marking the expiration of its validity in coding systems.

Code_Set

YES

STRING

The coding system or set (e.g., CPT4) that the service modifier belongs to, specifying the framework in which the modifier is used.

Code_Version

YES

STRING

The version number of the code set that the service modifier is a part of, which can change over time as the coding standards are updated.

Active

YES

STRING

A flag indicating whether the service modifier is currently active and valid for use in medical coding and billing.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp indicating when the service modifier code becomes effective and applicable for use in transactions or medical records.

Created_User_ID

YES

STRING

The unique identifier of the user who created the service modifier entry in the system.

Created_Timestamp

YES

TIMESTAMP

The date and time when the service modifier entry was created in the database.

Last_Modified_User_ID

YES

STRING

The unique identifier of the user who last modified the service modifier entry.

Last_Modified_Timestamp

YES

TIMESTAMP

The date and time when the service modifier entry was last modified in the system.

Dictionary_Service_Modifier_HCPCS

Table Content

Column Name

Is Nullable

Data Type

Description

Service_Modifier_Code

YES

STRING

A unique code assigned to a service modifier, which provides additional information about a procedure or service, typically used in HCPCS (Healthcare Common Procedure Coding System).

Service_Modifier_Code_Set_Type

YES

STRING

Specifies the classification or type of the code set to which the service modifier belongs, such as HCPCS or other medical coding systems.

Service_Modifier_Description

YES

STRING

A detailed description of the service modifier, explaining its purpose or nature and how it alters or clarifies the primary procedure or service code.

Service_Modifier_Long_Term

YES

STRING

A more detailed or comprehensive description of the service modifier, offering an extended explanation of its use or application in medical coding and billing.

Code_Start

YES

STRING

The start date or period when the service modifier code becomes effective and applicable in medical billing or coding transactions.

Code_End

YES

STRING

The end date or period when the service modifier code is no longer applicable, marking the expiration of its validity in coding systems.

Code_Set

YES

STRING

The coding system or set (e.g., HCPCS) that the service modifier belongs to, specifying the framework in which the modifier is used.

Code_Version

YES

STRING

The version number of the code set that the service modifier is a part of, which can change over time as the coding standards are updated.

Active

YES

STRING

A flag indicating whether the service modifier is currently active and valid for use in medical coding and billing.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp indicating when the service modifier code becomes effective and applicable for use in transactions or medical records.

Created_User_ID

YES

STRING

The unique identifier of the user who created the service modifier entry in the system.

Created_Timestamp

YES

TIMESTAMP

The date and time when the service modifier entry was created in the database.

Last_Modified_User_ID

YES

STRING

The unique identifier of the user who last modified the service modifier entry.

Last_Modified_Timestamp

YES

TIMESTAMP

The date and time when the service modifier entry was last modified in the system.

Dictionary_Service_Setting_Code

Table Content

Column Name

Is Nullable

Data Type

Description

Service_Setting_Code

YES

STRING

(Content for this table appears to be incomplete.)

Attachment Dataset Specification

Dictionary_Service_Setting_Code

Columns and Descriptions

  • Service_Setting_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the service setting, explaining the environment or context in which the medical service or procedure is performed.

  • Service_Location_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing the specific physical location or facility where the medical service or procedure is provided (e.g., hospital, clinic, or physician’s office).

  • RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier for the RSS feed source from which the setting code and associated data are sourced or derived.

  • Place_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code that classifies or categorizes the group of places where services are delivered, which can be used for organizational or billing purposes.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of visibility or access that the service setting code has within the system, such as public, restricted, or private access.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service setting code becomes valid and applicable, marking the start of its usage in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the service setting code entry in the database.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service setting code entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the service setting code entry in the database.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the service setting code entry was last modified in the system.

Dictionary_Source_Of_Payment_Typology

Columns and Descriptions

  • Concept_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a specific concept in the source of payment typology, representing a distinct medical or financial concept related to payment or billing.

  • Concept_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name associated with the concept code, describing the specific concept within the source of payment typology, such as a specific payment model or category.

  • Preferred_Concept_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The most commonly used or recommended name for the concept, preferred for clarity or consistency in the context of payment typology.

  • Preferred_Alternate_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An alternate code that can be used for the same concept, offering flexibility or compatibility with other coding systems or terminology.

  • Code_System_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the code system to which the concept code belongs, such as ICD, CPT, or another relevant coding system used for payment typology.

  • Code_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the coding system that the concept code belongs to, such as the ICD-10, CPT, or HCPCS coding systems.

  • Code_System_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code that identifies the specific version or set of codes within the coding system, potentially linking to a particular standard version or update.

  • Code_System_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version of the code system used for the concept, reflecting updates or changes in the coding standards (e.g., ICD-10 vs. ICD-11).

  • HL7_Table_0396_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code from the HL7 (Health Level 7) Table 0396, which is a standardized code system used in healthcare data exchange for payment typology and related concepts.

  • Value_Set_Concept_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the concept within the value set, explaining the nature and context of the concept in the source of payment typology.

  • Value_Set_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique code that identifies a specific value set, which is a collection of codes or concepts grouped together under a common categorization or purpose.

  • Value_Set_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version number of the value set, indicating when the value set was last updated or modified, ensuring that the concept codes align with the most current standard.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the concept and associated codes or descriptions become valid and applicable for use in the payment typology system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the source of payment typology entry in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the source of payment typology entry was created in the system or database.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the source of payment typology entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the source of payment typology entry was last modified in the database.

Attachment Dataset Specification

Dictionary_State_Province

Columns

  • State_Province_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a state or province, used to represent a specific geographic region or administrative division within a country.

  • State_Province_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the state or province, such as "California" or "Ontario," representing a specific geographic area within a country.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the state or province code becomes valid or effective in the system, marking the start of its usage.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the state or province entry in the database.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the state or province entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the state or province entry in the system.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the state or province entry was last modified in the system.

Dictionary_Subclient

Columns

  • Subclient_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a subclient, representing a distinct business unit or subsidiary within a larger organization or client structure.

  • Subclient_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the subclient, explaining the specific function, role, or purpose of the subclient within the overall organization or system.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the subclient code becomes valid or applicable in the system, marking the start of its usage.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the subclient entry in the database.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the subclient entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the subclient entry in the database.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the subclient entry was last modified in the system.

Dictionary_System_Source

Columns

  • System_Source_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a system source, representing the origin or provider of a system or data source within the medical SAP environment.

  • System_Source_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the system source, indicating the specific source or system from which data is derived, such as a particular database or external information provider.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the system source code becomes valid or applicable in the system, marking the start of its usage.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the system source entry in the database.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the system source entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the system source entry in the database.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the system source entry was last modified in the system.

Dictionary_Treatment_Setting_Code

Columns

  • Treatment_Setting

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code representing a specific treatment setting, such as inpatient, outpatient, or home care, where medical treatments or procedures are provided.

  • Treatment_Setting_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the treatment setting, explaining the type of care or treatment environment associated with the setting, such as "hospital" or "rehabilitation center."

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of visibility or access to the treatment setting code within the system, indicating whether it is public, restricted, or private.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the treatment setting code becomes valid and applicable for use in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the treatment setting entry in the database.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the treatment setting entry was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the treatment setting entry in the system.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the treatment setting entry was last modified in the system.

Dictionary_Visibility_Level

Columns

  • Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier or code representing a specific visibility level, such as "Public," "Restricted," or "Private," that defines the access control for certain data elements.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed explanation of the visibility level, describing the type of access or restrictions associated with the level.

Attachment Dataset Specification

Dictionary Visibility Level

Table Content

Table Name

Column Name

Is Nullable

Data Type

Description

Dictionary_Visibility_Level

Visibility_Level

YES

STRING

The specific visibility level (e.g., "Public," "Restricted," or "Private") assigned to data, defining access control and restrictions.

Dictionary_Visibility_Level

Description

YES

STRING

A detailed explanation of the visibility level, describing its purpose, scope, and restrictions, such as who can access or view the associated data.

Dictionary_Visibility_Level

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp indicating when the visibility level becomes valid and applicable in the system.

Dictionary_Visibility_Level

Created_User_ID

YES

STRING

The unique identifier of the user who created the visibility level entry in the database.

Dictionary_Visibility_Level

Created_Timestamp

YES

TIMESTAMP

The date and time when the visibility level entry was created in the system.

Dictionary_Visibility_Level

Last_Modified_User_ID

YES

STRING

The unique identifier of the user who last modified the visibility level entry in the system.

Dictionary_Visibility_Level

Last_Modified_Timestamp

YES

TIMESTAMP

The date and time when the visibility level entry was last modified in the system.

Dictionary Visibility Level Mapping

Table Content

Table Name

Column Name

Is Nullable

Data Type

Description

Dictionary_Visibility_Level_Mapping

Source

YES

STRING

The origin or source of the data that is being mapped to a specific visibility level, which could refer to a system, data set, or process defining the visibility assignment.

Dictionary_Visibility_Level_Mapping

Visibility_Level

YES

STRING

The specific visibility level (e.g., "Public," "Restricted," or "Private") assigned to the data source, indicating access control and restrictions.

Dictionary_Visibility_Level_Mapping

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp indicating when the visibility level mapping becomes valid and applicable for use in the system, marking the start of its usage.

Dictionary_Visibility_Level_Mapping

Created_User_ID

YES

STRING

The unique identifier of the user who created the visibility level mapping entry in the system.

Dictionary_Visibility_Level_Mapping

Created_Timestamp

YES

TIMESTAMP

The date and time when the visibility level mapping entry was created in the system.

Dictionary_Visibility_Level_Mapping

Last_Modified_User_ID

YES

STRING

The unique identifier of the user who last modified the visibility level mapping entry in the system.

Dictionary_Visibility_Level_Mapping

Last_Modified_Timestamp

YES

TIMESTAMP

The date and time when the visibility level mapping entry was last modified in the system.

Related Articles
Dictionary Dataset Specification
Cost Dataset Specification
Dictionary Dataset Specification A C
Dictionary Dataset Specification M Q
Dictionary Dataset Specification R Z
Did this answer your question?