Skip to main content

Dictionary Dataset Specification R Z

Updated over a month ago

Dictionary Dataset Specification R Z

Dictionary Dataset Specification (R-Z)

Dictionary Questionnaire Access Point

Table Structure

Column Name

Is Nullable

Data Type

Description

Access_Point

YES

STRING

Describes the location or method for accessing healthcare services (e.g., in-person, telemedicine).

Access_Point_Description

YES

STRING

Further explains the characteristics or features of the specified access point.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp indicating the start of the effective period.

Created_User_ID

YES

STRING

User ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Dictionary Questionnaire Class

Table Structure

Column Name

Is Nullable

Data Type

Description

Questionnaire_Class

YES

STRING

Indicates the classification or category of a questionnaire used for assessments or patient history.

Questionnaire_Class_Description

YES

STRING

Elaborates on the purpose or scope of the specified questionnaire class.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp indicating the start of the effective period.

Created_User_ID

YES

STRING

User ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Dictionary Questionnaire Review Edit Reason

Table Structure

Column Name

Is Nullable

Data Type

Description

Review_Edit_Reason

YES

STRING

Specifies reasons for reviewing and editing information (e.g., quality assurance, compliance).

Review_Edit_Reason_Description

YES

STRING

Provides additional context or details related to the review and edit process.

Active

YES

STRING

Indicates whether the item is active.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp indicating the start of the effective period.

Created_User_ID

YES

STRING

User ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Dictionary RX Patient Relation

Table Structure

Column Name

Is Nullable

Data Type

Description

Patient_Relationship_Type_Code

YES

STRING

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

Patient_Relationship_Type_Description

YES

STRING

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

Effective_From_Timestamp

YES

TIMESTAMP

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

Created_User_ID

YES

STRING

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

Created_Timestamp

YES

TIMESTAMP

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

Dictionary Dataset Specification (R-Z)

Patient Relation

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.

Race

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.

Rating

Rating

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a numerical or qualitative assessment.

Rating_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the meaning or interpretation of the specified rating value.

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Relationship

Relationship

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to connections or associations between entities (e.g., patient-provider relationship).

Relationship_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Expands on the nature or significance of the specified relationship.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Reporting System Identifiers

System_User_Id

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for a system user in the reporting system.

System_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name associated with the system user in the reporting system.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this system user entry became or will become effective.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this system user entry.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this system user entry was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this system user entry.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this system user entry was last modified.

Request Classification

Request_Classification

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification of the request.

Request_Classification_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the request classification.

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the request classification is active.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the request classification became effective.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Request Intake Source

Request_Intake_Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source of the request intake.

Request_Intake_Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the request intake source.

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the request intake source is active.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the request intake source became effective.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Request Item Details Type

Request_Item_Details_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the type of details associated with the request item.

Dictionary Dataset Specification (R-Z)

Dictionary_Request_Item_Details_Type

Columns

  • Request_Item_Details_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the purpose or content of the specified request item details.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Request_Item_Type

Columns

  • Request_Item_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the type or category of a request item (e.g., lab test, medication refill).

  • Request_Item_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context or information about the specified request item type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Request_Provider_Role

Columns

  • Request_Provider_Role

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Defines the role or function of a provider within a specific request context.

  • Request_Provider_Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Expounds on the responsibilities or duties associated with the specified provider role.

  • System_Role

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Refers to roles or permissions within a system.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Request_Responder_Relation

Columns

  • Request_Responder_Relation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the relationship between a requester and a responder in a specific context.

  • Request_Responder_Relation_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides context or details about the specified responder relationship.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Request_Type

Columns

  • Request_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the type of request made (e.g., appointment, prescription).

  • Request_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Offers additional information about the specified request type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

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

Dictionary_Request_Urgency

Columns

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

  • Request_Urgency

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of urgency for the request.

  • Request_Urgency_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the request urgency level.

  • 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 Dataset Specification (R-Z)

Dictionary_Requester_Type

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the requester type.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the requester type.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the requester type is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the requester type became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Dictionary_Response_Type

Columns

  • Response_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the type of response provided (e.g., confirmation, denial).

  • Response_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Elaborates on the meaning or purpose of the specified response type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Response_Value_Type

Columns

  • Response_Value_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the data type or format of a response value (e.g., text, numeric).

  • Response_Value_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides context regarding the interpretation or handling of response values.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was last 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_Review_Type

Columns

  • Review_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the type of review conducted (e.g., clinical review, audit).

  • Review_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the focus or purpose of the specified review type.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was last 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: The type of risk model associated with this score type.

Dictionary Dataset Specification (R-Z)

Dictionary Risk Score Type

Columns and Descriptions

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

Dictionary Route Type

Columns and Descriptions

  • Route_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the method or pathway for handling requests or information flow.

  • Route_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Expands on the characteristics or options related to the specified route type.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Security Resource Class

Columns and Descriptions

  • Security_Resource_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classifies security resources (e.g., user accounts, permissions).

  • Security_Resource_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides context or details about the specified security resource class.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Service CPT4

Columns and Descriptions

  • 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 updated or modified.

Dictionary Dataset Specification (R-Z)

Dictionary_Service_CPT4

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Service_Code_Modifier

Service_Code_Modifier

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes modifiers applied to service codes (e.g., billing modifiers).

Service_Code_Modifier_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explains the impact or purpose of the specified service code modifier.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record 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 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

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

Dictionary Dataset Specification (R-Z)

Dictionary_Service_ICD10

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.

Dictionary_Service_ICD9

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 Dataset Specification (R-Z)

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.

Dictionary_Service_Modifier_CPT4

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

  • 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 Dataset Specification (R-Z)

Dictionary_Service_Modifier_HCPCS

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

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_Service_Status

Service_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the status of a service (e.g., active, inactive, pending).

Service_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context or meaning for the specified service status.

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Source_Of_Payment_Typology

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.

Dictionary Dataset Specification (R-Z)

Dictionary_Source_Of_Payment_Typology

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.

Dictionary_Source_System

Source_System_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the originating system or source of data (e.g., EMR, claims system).

Source_System_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the characteristics or purpose of the specified source system.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Specialty

Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a code or identifier for a specific medical specialty (e.g., cardiology, dermatology).

Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context or details about the specified medical specialty.

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Stage_Type

Stage_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier representing a specific stage type in a process or workflow.

Stage_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the stage type.

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this stage type is currently active or in use.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this stage type entry became or will become effective.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this stage type entry.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this stage type entry was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this stage type entry.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this stage type entry was last modified.

Dictionary_State

State

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to a geographical state within a country (e.g., California, New York).

State_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the name of the state corresponding to the provided state code.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_State_Province

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: Timestamp indicating the start of the effective period.

Dictionary Dataset Specification (R-Z)

Dictionary_State_Province

Columns

  • State_Province_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

Dictionary_Subscriber_Relationship

Columns

  • Relationship

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Defines the type of relationship between the subscriber and another party (e.g., spouse, dependent, etc.).

  • Party

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The entity or individual that has a relationship with the subscriber (e.g., employer, guardian, etc.).

  • Relationship_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the relationship type, providing further context and explanation.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the subscriber relationship becomes effective or valid.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the subscriber relationship entry in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the subscriber relationship entry was initially created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

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_Task_Class

Columns

  • Task_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the classification or category of a task (e.g., administrative, clinical).

  • Task_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Elaborates on the purpose or characteristics of the specified task class.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Task_Outcome

Columns

  • Task_Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the outcome or result of a completed task (e.g., approved, rejected).

  • Task_Outcome_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context regarding the meaning or significance of the specified task outcome.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (R-Z)

Dictionary_Task_Outcome

Columns

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Task_Reason

Columns

  • Task_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the reason or purpose behind a task (e.g., appointment scheduling, prescription renewal).

  • Task_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Expands on the nature or motivation for the specified task reason.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Task_Type

Columns

  • Task_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the type or category of a task (e.g., lab order, referral).

  • Task_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Offers additional information about the specified task type.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Task_Void_Reason

Columns

  • Task_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the reason for voiding or canceling a task (e.g., patient cancellation, provider error).

  • Task_Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides context or details about the specified task void reason.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Time_Unit_Of_Measure

Columns

  • Time_Unit_Of_Measure

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the unit of measurement for time (e.g., minutes, hours).

  • Time_Unit_Of_Measure_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the meaning or interpretation of the specified time unit of measure.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

Dictionary_Timezone

Columns

  • Time_Zone_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies a specific time zone (e.g., UTC, PST).

  • Time_Zone_Abbreviation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides the abbreviated name for the specified time zone.

  • Time_Zone_System_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the system or standard used for time zone representation (e.g., IANA, Olson).

  • Time_Zone_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the full name or label for the specified time zone.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Transaction_Source

Columns

  • Transaction_Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the source or origin of a transaction (e.g., electronic health record, billing system).

  • Transaction_Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Expounds on the characteristics or purpose of the specified transaction source.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Dictionary Dataset Specification (R-Z)

Dictionary_Transaction_Source

Columns

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Transaction_Type

Columns

  • Transaction_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the type of transaction (e.g., claim submission, payment).

  • Transaction_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the purpose or context of the specified transaction type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Log_Entry_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of log entry associated with this transaction type.

Dictionary_Treatment_Setting

Columns

  • Treatment_Setting

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific setting or environment where the treatment is provided (e.g., inpatient, outpatient, etc.).

  • Treatment_Setting_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed explanation or description of the treatment setting and its context.

  • Bhvrl_Health_Flag

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A flag indicating whether the treatment setting is related to behavioral health (e.g., mental health services).

  • Medical_Flag

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A flag indicating whether the treatment setting pertains to medical health services.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A status indicator showing whether the treatment setting is currently active or in use.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the treatment setting becomes effective or is put into use.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Treatment_Setting_Code

Columns

  • Treatment_Setting

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Setting for the treatment.

  • Treatment_Setting_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the treatment setting.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of visibility for the treatment setting.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the treatment setting became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Behavioral_Health

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the treatment setting is related to behavioral health.

  • Physical_Health

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the treatment setting is related to physical health.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the treatment setting is active.

Dictionary_Treatment_Setting_To_Request_Type_Mapping

Columns

  • Dictionary_Treatment_Setting_To_Request_Type_Mapping_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the mapping between treatment setting and request type.

  • Treatment_Setting

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the treatment setting involved in the mapping (e.g., inpatient, outpatient).

  • Request_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Defines the type of request associated with the treatment setting.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the mapping is active (e.g., 'Yes' or 'No').

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this mapping becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created this mapping entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this mapping was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified this mapping.

Dictionary_Treatment_Type

Columns

  • Treatment_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of treatment.

  • Treatment_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the treatment type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the treatment type became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last modified the record.

Dictionary Dataset Specification (R-Z)

Dictionary_Treatment_Type

Columns

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the treatment type is active.

  • Behavioral_Health

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the treatment type is related to behavioral health.

  • Physical_Health

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the treatment type is related to physical health.

Dictionary_Treatment_Setting_To_Treatment_Type_Mapping

Columns

  • Treatment_Setting_To_Treatment_Type_Mapping_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the mapping between treatment setting and treatment type.

  • Treatment_Setting

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the treatment setting involved in the mapping (e.g., inpatient, outpatient).

  • Treatment_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Defines the type of treatment associated with the treatment setting.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the mapping is active (e.g., 'Yes' or 'No').

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this mapping becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created this mapping entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this mapping was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified this mapping.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this mapping was last modified.

Dictionary_Treatment_Unit_Of_Measure

Columns

  • Treatment_Unit_Of_Measure

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the unit of measurement for treatment quantities (e.g., milligrams, sessions).

  • Treatment_Unit_Of_Measure_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the interpretation or significance of the specified treatment unit of measure.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Urgency

Columns

  • Urgency

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the level of urgency or priority for a task or request (e.g., routine, urgent).

  • Urgency_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context regarding the meaning or impact of the specified urgency level.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_User_Role

Columns

  • Role_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code or identifier associated with a specific user role within the system.

  • Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A brief description or label that explains the purpose or function of the user role.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

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

Columns

  • 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 visibility level associated with the source data.

Dictionary Dataset Specification (R-Z)

Dictionary_Visibility_Level_Mapping

ES

  • 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

  • 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

  • Data Type: STRING

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

Created_Timestamp

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Data Type: TIMESTAMP

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

Dictionary_Waiver

Waiver

  • Data Type: STRING

  • Description: Refers to a waiver or exception granted under specific circumstances (e.g., copayment waiver).

Waiver_Description

  • Data Type: STRING

  • Description: Expands on the conditions or reasons for granting the specified waiver.

Active

  • Data Type: STRING

  • Description: Indicates whether the item is active.

Effective_From_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

Created_User_ID

  • Data Type: STRING

  • Description: User ID of the user who created the record.

Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_User_ID

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Last_Modified_Timestamp

  • Data Type: TIMESTAMP

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

Dictionary_Questionnaire_Access_Point

Column Name

Is Nullable

Data Type

Description

Access_Point

YES

STRING

Describes the location or method for accessing healthcare services (e.g., in-person, telemedicine).

Access_Point_Description

YES

STRING

Further explains the characteristics or features of the specified access point.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp indicating the start of the effective period.

Created_User_ID

YES

STRING

User ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Dictionary_Questionnaire_Class

Column Name

Is Nullable

Data Type

Description

Questionnaire_Class

YES

STRING

Indicates the classification or category of a questionnaire used for assessments or patient history.

Questionnaire_Class_Description

YES

STRING

Elaborates on the purpose or scope of the specified questionnaire class.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp indicating the start of the effective period.

Created_User_ID

YES

STRING

User ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Dictionary_Questionnaire_Review_Edit_Reason

Column Name

Is Nullable

Data Type

Description

Review_Edit_Reason

YES

STRING

Specifies reasons for reviewing and editing information (e.g., quality assurance, compliance).

Review_Edit_Reason_Description

YES

STRING

Provides additional context or details related to the review and edit process.

Active

YES

STRING

Indicates whether the item is active.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp indicating the start of the effective period.

Created_User_ID

YES

STRING

User ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Dictionary_RX_Patient_Relation

Column Name

Is Nullable

Data Type

Description

Patient_Relationship_Type_Code

YES

STRING

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

Patient_Relationship_Type_Description

YES

STRING

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

Effective_From_Timestamp

YES

TIMESTAMP

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

Dictionary Dataset Specification (R-Z)

Dictionary_RX_Patient_Relation

Columns

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

Columns

  • Rating

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a numerical or qualitative assessment.

  • Rating_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the meaning or interpretation of the specified rating value.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Relationship

Columns

  • Relationship

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to connections or associations between entities (e.g., patient-provider relationship).

  • Relationship_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Expands on the nature or significance of the specified relationship.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Reporting_System_Identifiers

Columns

  • System_User_Id

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for a system user in the reporting system.

  • System_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name associated with the system user in the reporting system.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this system user entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this system user entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this system user entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this system user entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this system user entry was last modified.

Dictionary_Request_Classification

Columns

  • Request_Classification

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification of the request.

  • Request_Classification_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the request classification.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the request classification is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the request classification became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Dictionary_Request_Intake_Source

Columns

  • Request_Intake_Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source of the request intake.

Dictionary Dataset Specification (R-Z)

Dictionary_Request_Intake_Source

Columns

  • Request_Intake_Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the request intake source.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the request intake source is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the request intake source became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Dictionary_Request_Item_Details_Type

Columns

  • Request_Item_Details_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the type of details associated with a specific request item.

  • Request_Item_Details_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the purpose or content of the specified request item details.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Request_Item_Type

Columns

  • Request_Item_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the type or category of a request item (e.g., lab test, medication refill).

  • Request_Item_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context or information about the specified request item type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Request_Provider_Role

Columns

  • Request_Provider_Role

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Defines the role or function of a provider within a specific request context.

  • Request_Provider_Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Expounds on the responsibilities or duties associated with the specified provider role.

  • System_Role

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Refers to roles or permissions within a system.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Request_Responder_Relation

Columns

  • Request_Responder_Relation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the relationship between a requester and a responder in a specific context.

  • Request_Responder_Relation_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides context or details about the specified responder relationship.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Request_Type

Columns

  • Request_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the type of request made (e.g., appointment, prescription).

  • Request_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Offers additional information about the specified request type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

Dictionary Dataset Specification (R-Z)

Dictionary_Request_Type

Column Name

Is Nullable

Data Type

Description

Created_User_ID

YES

STRING

User ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Active

YES

STRING

A flag indicating whether the request type is currently active (True/False).

Dictionary_Request_Urgency

Column Name

Is Nullable

Data Type

Description

Active

YES

STRING

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

Effective_From_Timestamp

YES

TIMESTAMP

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

Created_User_ID

YES

STRING

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

Created_Timestamp

YES

TIMESTAMP

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

Last_Modified_User_ID

YES

STRING

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

Request_Urgency

YES

STRING

Level of urgency for the request.

Request_Urgency_Description

YES

STRING

Description of the request urgency level.

Last_Modified_Timestamp

YES

TIMESTAMP

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

Dictionary_Requester_Type

Column Name

Is Nullable

Data Type

Description

Code

YES

STRING

Code for the requester type.

Description

YES

STRING

Description of the requester type.

Active

YES

STRING

Indicates if the requester type is active.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp when the requester type became effective.

Created_User_ID

YES

STRING

Identifier for the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp when the record was created.

Last_Modified_User_ID

YES

STRING

Identifier for the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when the record was last modified.

Dictionary_Response_Type

Column Name

Is Nullable

Data Type

Description

Response_Type

YES

STRING

Specifies the type of response provided (e.g., confirmation, denial).

Response_Type_Description

YES

STRING

Elaborates on the meaning or purpose of the specified response type.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp indicating the start of the effective period.

Created_User_ID

YES

STRING

User ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Dictionary_Response_Value_Type

Column Name

Is Nullable

Data Type

Description

Response_Value_Type

YES

STRING

Identifies the data type or format of a response value (e.g., text, numeric).

Response_Value_Type_Description

YES

STRING

Provides context regarding the interpretation or handling of response values.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp indicating the start of the effective period.

Created_User_ID

YES

STRING

User ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Dictionary_Revenue_Code

Column Name

Is Nullable

Data Type

Description

Revenue_Code

YES

STRING

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

Revenue_Code_Description

YES

STRING

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

Code_Start

YES

STRING

The starting range of revenue codes for categorization purposes.

Code_End

YES

STRING

The ending range of revenue codes for categorization purposes.

Code_Set

YES

STRING

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

Code_Version

YES

STRING

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

Active

YES

STRING

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

Room_Board_Flag

YES

STRING

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

RSS_Source_Number

YES

STRING

A reference number indicating the source system for the revenue code.

Dictionary Dataset Specification (R-Z)

Dictionary Revenue Code

Columns

  • 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 Review Type

Columns

  • Review_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the type of review conducted (e.g., clinical review, audit).

  • Review_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the focus or purpose of the specified review type.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was last 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.

Dictionary Route Type

Columns

  • Route_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the method or pathway for handling requests or information flow.

  • Route_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Expands on the characteristics or options related to the specified route type.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Security Resource Class

Columns

  • Security_Resource_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classifies security resources (e.g., user accounts, permissions).

  • Security_Resource_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides context or details about the specified security resource class.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was last 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 type of code set used for categorizing medical services or procedures.

Dictionary Dataset Specification (R-Z)

Dictionary_Service_CPT4

Columns and Descriptions

  • Service_Description

  • 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

  • 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

  • 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

  • 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

  • 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

  • Nullable: YES

  • Data Type: STRING

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

  • Code_End

  • Nullable: YES

  • Data Type: STRING

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

  • Billable

  • 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

  • Nullable: YES

  • Data Type: STRING

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

  • Billable_End

  • Nullable: YES

  • Data Type: STRING

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

  • Code_Set

  • 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

  • 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

  • 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

  • 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

  • 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

  • Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Service_Code_Modifier

Columns and Descriptions

  • Service_Code_Modifier

  • Nullable: YES

  • Data Type: STRING

  • Description: Describes modifiers applied to service codes (e.g., billing modifiers).

  • Service_Code_Modifier_Description

  • Nullable: YES

  • Data Type: STRING

  • Description: Explains the impact or purpose of the specified service code modifier.

  • Effective_From_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Service_HCPCS

Columns and Descriptions

  • Service_Code

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • Nullable: YES

  • Data Type: STRING

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

  • Code_End

  • Nullable: YES

  • Data Type: STRING

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

Dictionary Dataset Specification (R-Z)

Dictionary_Service_HCPCS

Ring

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

  • Is Nullable: YES

  • Data Type: STRING

Billable

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

  • Is Nullable: YES

  • Data Type: STRING

Billable_Start

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

  • Is Nullable: YES

  • Data Type: STRING

Billable_End

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

  • Is Nullable: YES

  • Data Type: STRING

Code_Set

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

  • Is Nullable: YES

  • Data Type: STRING

Code_Version

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

  • Is Nullable: YES

  • Data Type: STRING

RSS_Source_Number

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

  • Is Nullable: YES

  • Data Type: STRING

Active

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

  • Is Nullable: YES

  • Data Type: STRING

Effective_From_Timestamp

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

  • Is Nullable: YES

  • Data Type: TIMESTAMP

Created_User_ID

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

  • Is Nullable: YES

  • Data Type: STRING

Created_Timestamp

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

  • Is Nullable: YES

  • Data Type: TIMESTAMP

Last_Modified_User_ID

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

  • Is Nullable: YES

  • Data Type: STRING

Last_Modified_Timestamp

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

  • Is Nullable: YES

  • Data Type: TIMESTAMP

Dictionary_Service_ICD10

Service_Code

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

  • Is Nullable: YES

  • Data Type: STRING

Service_Code_Set_Type

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

  • Is Nullable: YES

  • Data Type: STRING

Service_Description

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

  • Is Nullable: YES

  • Data Type: STRING

Service_Short_Term

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

  • Is Nullable: YES

  • Data Type: STRING

Service_Long_Term

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

  • Is Nullable: YES

  • Data Type: STRING

Include_Episodes_Flag

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

  • Is Nullable: YES

  • Data Type: STRING

Visibility_Level

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

  • Is Nullable: YES

  • Data Type: STRING

Code_Start

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

  • Is Nullable: YES

  • Data Type: STRING

Code_End

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

  • Is Nullable: YES

  • Data Type: STRING

Billable

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

  • Is Nullable: YES

  • Data Type: STRING

Billable_Start

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

  • Is Nullable: YES

  • Data Type: STRING

Billable_End

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

  • Is Nullable: YES

  • Data Type: STRING

Code_Set

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

  • Is Nullable: YES

  • Data Type: STRING

Code_Version

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

  • Is Nullable: YES

  • Data Type: STRING

RSS_Source_Number

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

  • Is Nullable: YES

  • Data Type: STRING

Active

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

  • Is Nullable: YES

  • Data Type: STRING

Effective_From_Timestamp

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

  • Is Nullable: YES

  • Data Type: TIMESTAMP

Created_User_ID

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

  • Is Nullable: YES

  • Data Type: STRING

Created_Timestamp

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

  • Is Nullable: YES

  • Data Type: TIMESTAMP

Last_Modified_User_ID

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

  • Is Nullable: YES

  • Data Type: STRING

Last_Modified_Timestamp

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

  • Is Nullable: YES

  • Data Type: TIMESTAMP

Dictionary Dataset Specification (R-Z)

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.

Dictionary Dataset Specification (R-Z)

Dictionary_Service_Modifier_CPT4

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

  • 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 assigned to a service setting.

Dictionary Dataset Specification (R-Z)

Dictionary_Service_Setting_Code

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_Service_Status

Service_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the status of a service (e.g., active, inactive, pending).

Service_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context or meaning for the specified service status.

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Source_Of_Payment_Typology

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 remains current.

Dictionary Dataset Specification (R-Z)

Dictionary_Source_Of_Payment_Typology

Columns

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

Dictionary_Source_System

Columns

  • Source_System_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the originating system or source of data (e.g., EMR, claims system).

  • Source_System_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the characteristics or purpose of the specified source system.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Specialty

Columns

  • Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a code or identifier for a specific medical specialty (e.g., cardiology, dermatology).

  • Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context or details about the specified medical specialty.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Stage_Type

Columns

  • Stage_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier representing a specific stage type in a process or workflow.

  • Stage_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the stage type.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this stage type is currently active or in use.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this stage type entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this stage type entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this stage type entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this stage type entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this stage type entry was last modified.

Dictionary_State

Columns

  • State

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to a geographical state within a country (e.g., California, New York).

  • State_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the name of the state corresponding to the provided state code.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

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: Timestamp indicating when the state or province entry was created.

Dictionary Dataset Specification (R-Z)

Dictionary_State_Province

Columns

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

Dictionary_Subscriber_Relationship

Columns

  • Relationship

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Defines the type of relationship between the subscriber and another party (e.g., spouse, dependent, etc.).

  • Party

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The entity or individual that has a relationship with the subscriber (e.g., employer, guardian, etc.).

  • Relationship_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the relationship type, providing further context and explanation.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the subscriber relationship becomes effective or valid.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the subscriber relationship entry in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the subscriber relationship entry was initially created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

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_Task_Class

Columns

  • Task_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the classification or category of a task (e.g., administrative, clinical).

  • Task_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Elaborates on the purpose or characteristics of the specified task class.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Task_Outcome

Columns

  • Task_Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the outcome or result of a completed task (e.g., approved, rejected).

  • Task_Outcome_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context regarding the meaning or significance of the specified task outcome.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

Dictionary Dataset Specification (R-Z)

Dictionary_Task_Outcome

Columns

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Task_Reason

Columns

  • Task_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the reason or purpose behind a task (e.g., appointment scheduling, prescription renewal).

  • Task_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Expands on the nature or motivation for the specified task reason.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Task_Type

Columns

  • Task_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the type or category of a task (e.g., lab order, referral).

  • Task_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Offers additional information about the specified task type.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Task_Void_Reason

Columns

  • Task_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the reason for voiding or canceling a task (e.g., patient cancellation, provider error).

  • Task_Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides context or details about the specified task void reason.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Time_Unit_Of_Measure

Columns

  • Time_Unit_Of_Measure

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the unit of measurement for time (e.g., minutes, hours).

  • Time_Unit_Of_Measure_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the meaning or interpretation of the specified time unit of measure.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

Dictionary_Timezone

Columns

  • Time_Zone_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies a specific time zone (e.g., UTC, PST).

  • Time_Zone_Abbreviation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides the abbreviated name for the specified time zone.

  • Time_Zone_System_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the system or standard used for time zone representation (e.g., IANA, Olson).

  • Time_Zone_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the full name or label for the specified time zone.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (R-Z)

Dictionary_Timezone

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Transaction_Source

Transaction_Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the source or origin of a transaction (e.g., electronic health record, billing system).

Transaction_Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Expounds on the characteristics or purpose of the specified transaction source.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Transaction_Type

Transaction_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the type of transaction (e.g., claim submission, payment).

Transaction_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the purpose or context of the specified transaction type.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Log_Entry_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of log entry associated with this transaction type.

Dictionary_Treatment_Setting

Treatment_Setting

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific setting or environment where the treatment is provided (e.g., inpatient, outpatient, etc.).

Treatment_Setting_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed explanation or description of the treatment setting and its context.

Bhvrl_Health_Flag

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A flag indicating whether the treatment setting is related to behavioral health (e.g., mental health services).

Medical_Flag

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A flag indicating whether the treatment setting pertains to medical health services.

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A status indicator showing whether the treatment setting is currently active or in use.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the treatment setting becomes effective or is put into use.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Treatment_Setting_Code

Treatment_Setting

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Setting for the treatment.

Treatment_Setting_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the treatment setting.

Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of visibility for the treatment setting.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the treatment setting became effective.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last modified the record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Behavioral_Health

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the treatment setting is related to behavioral health.

Physical_Health

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the treatment setting is related to physical health.

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the treatment setting is active.

Dictionary_Treatment_Setting_To_Request_Type_Mapping

Dictionary_Treatment_Setting_To_Request_Type_Mapping_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the mapping between treatment setting and request type.

Treatment_Setting

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the treatment setting involved in the mapping (e.g., inpatient, outpatient, etc.).

Dictionary Dataset Specification (R-Z)

Dictionary_Treatment_Setting_To_Request_Type_Mapping

Columns

  • Request_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Defines the type of request associated with the treatment setting.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the mapping is active (e.g., 'Yes' or 'No').

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this mapping becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created this mapping entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this mapping was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified this mapping.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this mapping was last modified.

Dictionary_Treatment_Type

Columns

  • Treatment_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of treatment.

  • Treatment_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the treatment type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the treatment type became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the treatment type is active.

  • Behavioral_Health

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the treatment type is related to behavioral health.

  • Physical_Health

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the treatment type is related to physical health.

Dictionary_Treatment_Setting_To_Treatment_Type_Mapping

Columns

  • Treatment_Setting_To_Treatment_Type_Mapping_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the mapping between treatment setting and treatment type.

  • Treatment_Setting

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the treatment setting involved in the mapping (e.g., inpatient, outpatient).

  • Treatment_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Defines the type of treatment associated with the treatment setting.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the mapping is active (e.g., 'Yes' or 'No').

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this mapping becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created this mapping entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this mapping was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified this mapping.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this mapping was last modified.

Dictionary_Treatment_Unit_Of_Measure

Columns

  • Treatment_Unit_Of_Measure

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the unit of measurement for treatment quantities (e.g., milligrams, sessions).

  • Treatment_Unit_Of_Measure_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the interpretation or significance of the specified treatment unit of measure.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Urgency

Columns

  • Urgency

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the level of urgency or priority for a task or request (e.g., routine, urgent).

  • Urgency_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context regarding the meaning or impact of the specified urgency level.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the start of the effective period.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who created the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (R-Z)

Dictionary_User_Role

Table Structure

Column Name

Is Nullable

Data Type

Description

Role_Code

YES

STRING

A unique code or identifier associated with a specific user role within the system.

Role_Description

YES

STRING

A brief description or label that explains the purpose or function of the user role.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Dictionary_Visibility_Level

Table Structure

Column Name

Is Nullable

Data Type

Description

Level

YES

STRING

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

YES

STRING

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

YES

TIMESTAMP

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

Created_User_ID

YES

STRING

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

Created_Timestamp

YES

TIMESTAMP

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

Last_Modified_User_ID

YES

STRING

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

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 Structure

Column Name

Is Nullable

Data Type

Description

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 that defines the visibility assignment.

Visibility_Level

YES

STRING

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

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.

Created_User_ID

YES

STRING

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

Created_Timestamp

YES

TIMESTAMP

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

Last_Modified_User_ID

YES

STRING

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

Last_Modified_Timestamp

YES

TIMESTAMP

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

Dictionary_Waiver

Table Structure

Column Name

Is Nullable

Data Type

Description

Waiver

YES

STRING

Refers to a waiver or exception granted under specific circumstances (e.g., copayment waiver).

Waiver_Description

YES

STRING

Expands on the conditions or reasons for granting the specified waiver.

Active

YES

STRING

Indicates whether the item is active.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp indicating the start of the effective period.

Created_User_ID

YES

STRING

User ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Related Articles
Provider Dataset Specification
Dictionary Dataset Specification
Attachment Dataset Specification
Dictionary Dataset Specification A C
Dictionary Dataset Specification M Q
Did this answer your question?