Skip to main content

Dictionary Dataset Specification A C

Updated over 2 months ago

Dictionary Dataset Specification A C

Dictionary Dataset Specification (A-C)

The "Dictionary Dataset Specification" is designed to standardize and organize essential healthcare-related data across various domains. This dataset plays a critical role in ensuring data consistency, supporting interoperability, and enabling precise data management across healthcare systems. It contains a wide array of reference tables that cover operational, clinical, and administrative aspects of healthcare. These dictionaries are pivotal for maintaining uniformity in data interpretation, enhancing decision-making, and ensuring compliance with healthcare standards and regulations.

Key Components of the Dataset

Dictionary Address Type

  • Standardizes address types used across healthcare records for accurate patient and provider information.

Dictionary Alert

  • Defines various types of alerts related to patient care, such as clinical or administrative warnings.

Dictionary Appeal Due Date Change Reason

  • Captures standardized reasons for modifying appeal due dates, ensuring clear documentation and compliance in appeals processing.

Dictionary Appeal Levels, Types, Process, and Status

  • Ensures consistent tracking and categorization of appeals, enabling clear resolution paths for patient grievances.

Dictionary Application Config & User Type

  • Manages application-specific configurations and user types for system access control and customization.

Dictionary Attributed Provider Type & Audit Log

  • Provides standard references for healthcare provider types and system audit classifications, essential for compliance and operational transparency.

Dictionary Auto Approval Rules

  • Defines rules and types for automatic approvals, streamlining operational workflows while maintaining regulatory compliance.

Dictionary Axis, Barriers, and Social Problems

  • Standardizes terms for documenting social determinants of health and barriers to care, supporting patient-centric care plans.

Dictionary Bed Type & Care Management Types

  • Ensures consistency in documenting facility resources and care management approaches to optimize patient care coordination.

Dictionary Cost & Cost Saving Categories

  • Organizes financial data related to healthcare services, helping healthcare organizations track costs, savings, and cost void reasons.

Dictionary Condition Categories & Coding Schemes

  • Standardizes clinical diagnosis categories and coding schemes to ensure uniformity in diagnostic and procedural data.

Dictionary Enrollment, Gender, and Demographic Attributes

  • Captures demographic data related to patient enrollment, gender, marital status, and member engagement for comprehensive patient profiling.

Dictionary Goals, Outcomes, and Treatment Settings

  • Defines clinical goals, outcomes, and treatment settings to support patient-centered care and track progress throughout healthcare programs.

Dictionary Language & Preferred Contact Method

  • Ensures accurate documentation of patient language preferences and communication methods, facilitating improved patient engagement.

Dictionary Problem Status, Types, and Solutions

  • Standardizes documentation for clinical problems and outcomes, ensuring accurate tracking and resolution of health issues.

Dictionary Program & Provider Roles

  • Tracks healthcare programs and roles of participating providers to facilitate coordination across multidisciplinary teams.

Dictionary Service, Product, and Specialty

  • Organizes services, products, and provider specialties to ensure consistent billing, referrals, and clinical service documentation.

Dictionary Security Resource & Permissions Elements

  • Controls access to system resources by defining security roles and permissions, ensuring compliance with healthcare security standards.

Dictionary Task Types & Outcomes

  • Manages task types, reasons, and outcomes within healthcare operations to streamline workflows and improve task management.

Dictionary Treatment Types & Units of Measure

  • Ensures consistent documentation of treatment types, settings, and units of measure across various healthcare disciplines.

Detailed Dictionary Entries

Dictionary Account

  • Provides standardized definitions for account-related data, ensuring consistency in financial and administrative operations.

Dictionary Address Type

  • Specifies address types used in healthcare records, such as residential, mailing, or billing addresses.

Dictionary Adjustment Type Translation

  • Translates adjustment types for claims and billing processes, ensuring accurate financial reconciliation.

Dictionary Admission Source

  • Standardizes sources of admission, such as emergency room, physician referral, or transfer from another facility.

Dictionary Admission Type

  • Categorizes types of admissions, including elective, urgent, or emergency admissions.

Dictionary Appeal Process Type Appeal Level Mapping

  • Maps appeal process types to corresponding appeal levels, ensuring alignment in appeals tracking and resolution.

Dictionary Appeal Reason

  • Defines standardized reasons for appeals, such as denial of coverage or incorrect billing.

Dictionary Appeal Requestor

  • Identifies the entity requesting an appeal, such as the patient, provider, or payer.

Dictionary Appeal Reviewer

  • Specifies the role or entity responsible for reviewing appeals, ensuring accountability in the appeals process.

Dictionary Appeal Source

  • Categorizes the origin of appeals, such as patient complaints or provider disputes.

Dictionary Appeal Type Appeal Level Mapping

  • Maps appeal types to corresponding levels, supporting consistent categorization and resolution workflows.

Dictionary Application Config

  • Manages system-wide application configurations, enabling customization and operational efficiency.

Dictionary Appointment Event Type

  • Standardizes types of appointment events, such as cancellations, reschedules, or confirmations.

Dictionary Attachment Category

  • Categorizes types of attachments in healthcare records, such as clinical documents or administrative files.

Dictionary Audit Log Class

  • Defines classes for audit logs, supporting compliance and traceability in system operations.

Dictionary Audit Log Data Point

  • Specifies data points captured in audit logs, ensuring detailed tracking of system activities.

Dictionary Audit Transaction Type

  • Categorizes transaction types for audit purposes, such as data creation, modification, or deletion.

Dictionary Availity Treatment Setting

  • Standardizes treatment settings, such as inpatient, outpatient, or home care.

Dictionary Axis

  • Provides a framework for categorizing clinical data along specific axes, such as diagnosis or treatment.

Dictionary Axis Social Problem

  • Defines social problems impacting health outcomes, supporting comprehensive care planning.

Dictionary Barrier

  • Identifies barriers to care, such as transportation issues or financial constraints, enabling targeted interventions.

Dictionary Bed Type

  • Standardizes bed types in healthcare facilities, such as ICU, general ward, or maternity beds.

Dictionary CCS 9 10 Multi Diagnosis Tool

  • Supports multi-diagnosis coding using CCS (Clinical Classification Software) versions 9 and 10.

Dictionary CareWebQI Guideline

  • Provides standardized guidelines for CareWebQI, ensuring consistent application of clinical protocols.

Dictionary CareWebQI Review Status

  • Tracks review statuses within CareWebQI, supporting operational transparency and compliance.

Dictionary Care Management Type

  • Categorizes types of care management, such as chronic disease management or transitional care.

Dictionary Carrier

  • Defines carriers for healthcare claims, such as insurance providers or third-party payers.

Dictionary Claim Line Unit Code

  • Standardizes unit codes for claim lines, ensuring accurate billing and reimbursement.

Dictionary Claim Status

  • Tracks statuses of claims, such as pending, approved, or denied.

Dictionary Claim Type

  • Categorizes types of claims, such as medical, pharmacy, or dental claims.

Dictionary Client

  • Provides standardized definitions for client-related data, ensuring consistency in administrative operations.

Dictionary Client Alias

  • Captures alternate names or identifiers for clients, supporting accurate recordkeeping.

Dictionary Coding Scheme

  • Standardizes coding schemes for clinical and administrative data, such as ICD or CPT codes.

Dictionary Condition

  • Defines clinical conditions for accurate documentation and diagnosis.

Dictionary Condition Category

  • Categorizes conditions into broader categories, supporting data analysis and reporting.

Dictionary Condition Mapping Rules

  • Establishes rules for mapping conditions across coding systems, ensuring interoperability.

Dictionary Coordinated Care Discharge Disposition

  • Standardizes discharge dispositions for coordinated care, such as home care or rehabilitation.

Dictionary Cost Category

  • Categorizes healthcare costs, supporting financial tracking and analysis.

Dictionary Cost Saving

  • Tracks cost-saving measures, such as preventive care or efficient resource utilization.

Dictionary Cost Saving Cost Void Reason

  • Defines reasons for voiding cost savings, ensuring accurate financial documentation.

Dictionary Cost Saving Diagnosis Group

  • Categorizes diagnoses associated with cost-saving measures, supporting targeted interventions.

Dictionary Cost Saving Type

  • Defines types of cost-saving initiatives, such as bundled payments or value-based care.

Dictionary Cost Saving Type Of Care

  • Categorizes types of care associated with cost savings, such as outpatient or telehealth services.

Dictionary Cost Saving Void Reason

  • Captures reasons for voiding cost savings, ensuring compliance and transparency.

Dictionary Cost Type

  • Categorizes types of healthcare costs, such as direct, indirect, or capital costs.

Dictionary Dataset Specification (A-C)

This dataset enhances clinical decision-making, ensures data integrity and interoperability, and supports regulatory compliance across healthcare organizations. Below is the detailed specification for tables and columns within the dataset.

Dictionary_Account

Columns

  • Account_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code identifying the account in the dictionary.

  • Account_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the account, providing context and purpose within the dictionary.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which the account entry becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the account entry in the dictionary.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the account entry was initially created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

Dictionary_Address_Type

Columns

  • Address_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of address (e.g., mailing, billing, residential).

  • Address_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the address 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_Adjustment_Type_Translation

Columns

  • Source_Adjustment_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code representing the adjustment type in the source system.

  • Target_Adjustment_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code representing the adjustment type in the target system.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which the translation becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the adjustment type translation entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the adjustment type translation entry was initially created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the adjustment type translation entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the most recent modification to the adjustment type translation entry.

Dictionary_Admission_Source

Columns

  • Source_Adjustment_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code representing the adjustment type in the source system.

  • Target_Adjustment_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code representing the adjustment type in the target system.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which the translation becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the adjustment type translation entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the adjustment type translation entry was initially created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the adjustment type translation entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the most recent modification to the adjustment type translation entry.

Dictionary_Admission_Type

Columns

  • Admission_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the type of admission, such as elective, emergency, or urgent.

  • Admission_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the type of admission, providing clarity on the admission process.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the admission type becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the admission type entry was initially created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the most recent modification to the admission type entry.

Dictionary_Alert

Columns

  • Alert

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates an alert or notification associated with a specific condition or event.

  • Alert_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the alert.

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

Dictionary Dataset Specification (A-C)

Dictionary_Alert

Columns

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Appeal_Due_Date_Change_Reason

Columns

  • Appeal_Due_Date_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for changing the due date of an appeal.

  • Appeal_Due_Date_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the appeal due date change 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_Appeal_Level

Columns

  • Appeal_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of appeal.

  • Appeal_Level_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the appeal 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_Appeal_Process_Type

Columns

  • Appeal_Process_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of appeal process.

  • Appeal_Process_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the appeal process 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_Appeal_Process_Type_Appeal_Level_Mapping

Columns

  • Appeal_Process_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the appeal process.

  • Appeal_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of the appeal.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the appeal process type is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the appeal process 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_Appeal_Reason

Columns

  • Appeal_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for initiating an appeal.

  • Appeal_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the appeal 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_Appeal_Requestor

Columns

  • Appeal_Requestor

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Entity or individual requesting the appeal.

  • Appeal_Requestor_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the appeal requestor.

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

Columns

  • Appeal_Reviewer

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Person or entity responsible for reviewing the appeal.

Dictionary Dataset Specification (A-C)

Dictionary_Appeal_Reviewer

Columns

  • Appeal_Reviewer_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the appeal reviewer.

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

Columns

  • Appeal_Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source or origin of the appeal (e.g., member, provider, payer).

  • Appeal_Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the appeal source.

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

Columns

  • Appeal_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of the appeal (e.g., pending, approved, denied).

  • Appeal_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the appeal 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_Appeal_Type

Columns

  • Appeal_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of appeal (e.g., medical necessity, claim denial).

  • Appeal_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the appeal 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_Appeal_Type_Appeal_Level_Mapping

Columns

  • Appeal_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the appeal.

  • Appeal_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of the appeal.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the appeal type is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the appeal 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_Application_Config

Columns

  • Application_Config_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific configuration setting or parameter in an application.

  • Application_Config_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Value associated with the application configuration code.

  • Application_Config_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the application configuration code.

  • Application_Config_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category or group to which the application configuration belongs.

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

Columns

  • Application_User_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of user accessing the application (e.g., member, provider, administrator).

  • Application_User_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the application user type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (A-C)

Dictionary_Application_User_Type

Fields

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

Fields

  • Event_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code assigned to identify a specific type of appointment event.

  • Event_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the appointment event type.

  • Related_Entity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The entity (e.g., patient, provider) to which this event type is related.

  • Minutes_Before

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The number of minutes before the appointment that this event occurs.

  • Appointment_Time_Minutes

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The duration of the appointment in minutes.

  • Minutes_After

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The number of minutes after the appointment that this event occurs.

  • Reminder_Hours

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The number of hours before the appointment when a reminder should be sent.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this appointment event type became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this appointment event 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 appointment event type entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Attachment_Category

Fields

  • Attachment_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category of the attachment.

  • Attachment_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the attachment category.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the attachment category is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the attachment category 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_Attributed_Provider_Type

Fields

  • Attributed_Provider_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of healthcare provider attributed to a specific member or population.

  • Attributed_Provider_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code assigned to represent the attributed provider type.

  • Attributed_Provider_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the attributed provider 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_Audit_Log_Class

Fields

  • Audit_Log_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification or category of audit log entries (e.g., security, data access).

  • Audit_Log_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the audit log 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_Audit_Log_Data_Point

Fields

  • Audit_Log_Data_Point

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific data point or event captured in the audit log (e.g., login attempt, data modification).

  • Audit_Log_Data_Point_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the audit log data point.

  • Audit_Log_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Audit log data point 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 Dataset Specification (A-C)

Dictionary_Audit_Transaction_Type

Columns

  • Audit_Transaction_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of transaction recorded in the audit log (e.g., read, write, delete).

  • Audit_Transaction_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the audit 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.

Dictionary_Auto_Approval_Rule

Columns

  • Auto_Approval_Rule_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique key or identifier for an automated approval rule.

  • Auto_Approval_Rule_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of automated approval rule (e.g., cost-saving, medical necessity).

  • Auto_Approval_Rule_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label for the automated approval rule.

  • Auto_Approval_Rule_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the automated approval rule.

  • Auto_Approval_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether an automated approval was granted or denied.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Active_Date

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Indicates the date from which the rule is active.

  • Inactive_Date

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Indicates the date from which the rule is inactive.

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

Columns

  • Auto_Approval_Rule_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the automated approval rule.

  • Auto_Approval_Rule_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the automated approval rule 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_Availity_Treatment_Setting

Columns

  • Treatment_Setting

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier representing a specific treatment setting in the Availity system.

  • Treatment_Setting_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the treatment setting.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this treatment setting is currently active or in use.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this treatment setting 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 treatment setting entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this treatment setting entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this treatment setting entry was last modified.

Dictionary_Axis

Columns

  • Axis

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a specific dimension or category (e.g., time, geography) in data analysis.

  • Axis_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the axis.

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

Columns

  • Social_Problem

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Social issue or problem relevant to healthcare (e.g., substance abuse, homelessness).

  • Social_Problem_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the social problem.

  • 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 (A-C)

Last Modified Information

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_Axis_Social_Problem

Barrier

Barrier

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Obstacle or challenge affecting healthcare access or outcomes (e.g., language barrier, transportation).

Barrier_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the barrier.

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_Bed_Type

Bed_Type

Bed_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of hospital bed (e.g., general ward, intensive care unit).

Bed_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the bed 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_CCS_9_10_Multi_Diagnosis_Tool

CCS Diagnosis

CCS_Diagnosis_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing a specific Clinical Classification Software (CCS) diagnosis.

CCS_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The category under which the CCS diagnosis falls, grouping similar diagnoses for analysis.

CCS_Diagnosis_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the CCS diagnosis, providing additional context and clarity.

CCS_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the CCS category, offering further explanation about the grouping or classification.

CCS_Level_1

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The first hierarchical level of classification within the CCS tool, representing broader diagnostic groups.

CCS_Level_1_Label

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The label associated with the first level of CCS classification, offering a descriptive name for the group.

CCS_Level_2

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The second hierarchical level of classification within the CCS tool, representing more specific groups.

CCS_Level_2_Label

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The label associated with the second level of CCS classification, offering a descriptive name for the subgroup.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the CCS diagnosis or classification became effective.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the CCS diagnosis or classification entry.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the CCS diagnosis or classification entry was initially created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the CCS diagnosis or classification entry.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the most recent modification made to the CCS diagnosis or classification entry.

Dictionary_CareWebQI_Guideline

Guideline

Guideline_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific clinical guideline or recommendation.

Guideline_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label for the clinical guideline.

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_CareWebQI_Review_Status

Review Status

Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of a particular entity (e.g., active, inactive).

Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the status.

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_Care_Management_Type

(Content for this section appears incomplete in the provided text.)

Dictionary Dataset Specification (A-C)

Dictionary_Care_Management_Type

Columns

  • Care_Management_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category or approach to managing patient care (e.g., disease management, case management).

  • Care_Management_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the care management 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_Carrier

Columns

  • Carrier

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Insurance carrier or provider organization responsible for coverage.

  • Carrier_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the insurance carrier.

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

Columns

  • Unit_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the type of unit associated with a claim line, such as service or product units.

  • Unit_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the unit type, providing clarity about the nature of the units in claim lines.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the unit type code became effective for use in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the unit type entry in the dictionary.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the unit type entry was initially created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the unit type entry in the dictionary.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the most recent modification to the unit type entry in the dictionary.

Dictionary_Claim_Status

Columns

  • Claim_Status_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the status of a claim, such as "Pending," "Approved," or "Rejected."

  • Claim_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the claim status, providing additional context for the associated status code.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the claim status code became effective for use.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the claim status entry in the dictionary.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the claim status entry was initially created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the claim status entry in the dictionary.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the most recent modification to the claim status entry in the dictionary.

Dictionary_Claim_Type

Columns

  • Claim_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier representing the type of claim, such as "Inpatient," "Outpatient," or "Pharmacy."

  • Claim_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the claim type, providing additional context for the associated type code.

  • Claim_Type_Code_Short

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A short or abbreviated version of the claim type code for simplified reference or reporting purposes.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the claim type code became valid and active in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the claim type entry in the dictionary dataset.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the claim type entry was initially added to the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the claim type entry was last modified, reflecting the most recent update.

Dictionary_Client

Columns

  • Client

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Client organization or entity served by the system (e.g., healthcare provider, employer).

  • Client_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the client organization.

  • 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 (A-C)

Dictionary_Client_Alias

Columns

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier representing the tenant within the healthcare system.

  • Alias

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique alias assigned to the client, used for identification or grouping purposes.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the client alias became effective in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the client alias record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the client alias record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the client alias record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the client alias record was last updated in the system.

Dictionary_Coding_Scheme

Columns

  • Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Standardized system for assigning codes to medical concepts (e.g., ICD-10, CPT).

  • Coding_Scheme_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the coding scheme.

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

Columns

  • Condition_Mapped

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the condition has been mapped to a standard code or description.

  • Condition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique code assigned to the condition within the system.

  • Condition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the condition, providing clarity on its definition or classification.

  • Subcondition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique code assigned to a specific subcondition under the primary condition.

  • Subcondition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the subcondition associated with the primary condition.

  • Condition_Chronic_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the condition is classified as chronic (e.g., "Y" for Yes or "N" for No).

  • Source_Condition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code for the condition as received from the source system or external dataset.

  • Chronic_Acute

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the condition is chronic, acute, or falls into another classification category.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of visibility for the condition in the system, such as user or department-specific.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the condition became effective in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the condition record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the condition record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the condition record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the condition record was last updated in the system.

Dictionary_Condition_Category

Columns

  • Condition_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category or group of related medical conditions (e.g., cardiovascular, respiratory).

  • Condition_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the condition category.

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

Columns

  • Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing a group of conditions or mapping rules for classification and application.

  • Condition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique code assigned to the condition that the mapping rule applies to.

  • Mapping_Rule

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed rule specifying how the condition is mapped, including criteria and logic used for mapping.

  • Inclusive_Diagnosis_Codes_Group

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A group of diagnosis codes that are included as part of the mapping rule for this condition.

  • Exclusive_Diagnosis_Codes_Group

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A group of diagnosis codes that are excluded from the mapping rule for this condition.

  • Episode_Count

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the required number of episodes for the condition to meet the mapping criteria.

  • Acceptable_Disease_Stage_Threshold

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the acceptable stage threshold for the disease when applying the mapping rule.

  • Unacceptable_Disease_Stage_Threshold

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the unacceptable stage threshold for the disease, beyond which the mapping rule does not apply.

Dictionary Dataset Specification (A-C)

Dictionary Condition Mapping Rules

Columns

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the mapping rule became effective in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the mapping rule record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the mapping rule record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the mapping rule record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the mapping rule record was last updated in the system.

Dictionary Coordinated Care Discharge Disposition

Columns

  • Coordinated_Care_Discharge_Disposition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Discharge disposition related to coordinated care (e.g., home health, skilled nursing facility).

  • Coordinated_Care_Discharge_Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the coordinated care discharge disposition.

  • 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 Cost Category

Columns

  • Cost_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification of costs (e.g., direct medical costs, administrative costs).

  • Cost_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the cost category.

  • 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 Cost Saving

Columns

  • Cost_Saving

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates cost-saving measures or strategies.

  • Cost_Saving_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the cost-saving approach.

  • 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 Cost Saving Cost Void Reason

Columns

  • Cost_Saving_Cost_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding or canceling a cost-saving entry.

  • Cost_Saving_Cost_Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the cost-saving 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 Cost Saving Diagnosis Group

Columns

  • Cost_Saving_Diagnosis_Group

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Grouping of diagnoses related to cost-saving efforts.

  • Cost_Saving_Diagnosis_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the cost-saving diagnosis group.

  • 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 Cost Saving Type

Columns

  • Cost_Saving_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of cost-saving initiative (e.g., utilization review, generic drug substitution).

  • Cost_Saving_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the cost-saving type.

Dictionary Dataset Specification (A-C)

Dictionary_Cost_Saving_Type

Table Name: Dictionary_Cost_Saving_Type

  • Column Name: Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Column Name: Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Column Name: Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Cost_Saving_Type_Of_Care

Table Name: Dictionary_Cost_Saving_Type_Of_Care

  • Column Name: Cost_Saving_Type_Of_Care

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific area of care targeted for cost-saving measures (e.g., outpatient visits, prescription drugs).

  • Column Name: Cost_Saving_Type_Of_Care_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the cost-saving type of care.

  • Column Name: Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Column Name: Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Column Name: Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Cost_Saving_Void_Reason

Table Name: Dictionary_Cost_Saving_Void_Reason

  • Column Name: Cost_Saving_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding or canceling a cost-saving entry.

  • Column Name: Cost_Saving_Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the cost-saving void reason.

  • Column Name: Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Column Name: Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Column Name: Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Cost_Type

Table Name: Dictionary_Cost_Type

  • Column Name: Cost_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification of costs (e.g., direct, indirect).

  • Column Name: Cost_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the cost type.

  • Column Name: Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Column Name: Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Additional Dictionary Modules

  • Dictionary Address Type: Standardizes address types used across healthcare records for accurate patient and provider information.

  • Dictionary Alert: Defines various types of alerts related to patient care, such as clinical or administrative warnings.

  • Dictionary Appeal Due Date Change Reason: Captures standardized reasons for modifying appeal due dates, ensuring clear documentation and compliance in appeals processing.

  • Dictionary Appeal Levels, Types, Process, and Status: Ensures consistent tracking and categorization of appeals, enabling clear resolution paths for patient grievances.

  • Dictionary Application Config & User Type: Manages application-specific configurations and user types for system access control and customization.

  • Dictionary Attributed Provider Type & Audit Log: Provides standard references for healthcare provider types and system audit classifications, essential for compliance and operational transparency.

  • Dictionary Auto Approval Rules: Defines rules and types for automatic approvals, streamlining operational workflows while maintaining regulatory compliance.

  • Dictionary Axis, Barriers, and Social Problems: Standardizes terms for documenting social determinants of health and barriers to care, supporting patient-centric care plans.

  • Dictionary Bed Type & Care Management Types: Ensures consistency in documenting facility resources and care management approaches to optimize patient care coordination.

  • Dictionary Cost & Cost Saving Categories: Organizes financial data related to healthcare services, helping healthcare organizations track costs, savings, and cost void reasons.

  • Dictionary Condition Categories & Coding Schemes: Standardizes clinical diagnosis categories and coding schemes to ensure uniformity in diagnostic and procedural data.

  • Dictionary Enrollment, Gender, and Demographic Attributes: Captures demographic data related to patient enrollment, gender, marital status, and member engagement for comprehensive patient profiling.

  • Dictionary Goals, Outcomes, and Treatment Settings: Defines clinical goals, outcomes, and treatment settings to support patient-centered care and track progress throughout healthcare programs.

  • Dictionary Language & Preferred Contact Method: Ensures accurate documentation of patient language preferences and communication methods, facilitating improved patient engagement.

  • Dictionary Problem Status, Types, and Solutions: Standardizes documentation for clinical problems and outcomes.

Dictionary Dataset Specification (A-C)

Dictionary Program & Provider Roles

Tracks healthcare programs and roles of participating providers to facilitate coordination across multidisciplinary teams.

Dictionary Service, Product, and Specialty

Organizes services, products, and provider specialties to ensure consistent billing, referrals, and clinical service documentation.

Dictionary Security Resource & Permissions Elements

Controls access to system resources by defining security roles and permissions, ensuring compliance with healthcare security standards.

Dictionary Task Types & Outcomes

Manages task types, reasons, and outcomes within healthcare operations to streamline workflows and improve task management.

Dictionary Treatment Types & Units of Measure

Ensures consistent documentation of treatment types, settings, and units of measure across various healthcare disciplines.

Table Content

Dictionary_Account

Table Name

Column Name

Is Nullable

Data Type

Description

Dictionary_Account

Account_Code

YES

STRING

A unique code identifying the account in the dictionary.

Dictionary_Account

Account_Description

YES

STRING

A detailed description of the account, providing context and purpose within the dictionary.

Dictionary_Account

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp from which the account entry becomes effective.

Dictionary_Account

Created_User_ID

YES

STRING

The identifier of the user who created the account entry in the dictionary.

Dictionary_Account

Created_Timestamp

YES

TIMESTAMP

The timestamp when the account entry was initially created.

Dictionary_Account

Last_Modified_User_ID

YES

STRING

The identifier of the user who last modified the account entry.

Dictionary_Account

Last_Modified_Timestamp

YES

TIMESTAMP

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

Dictionary_Account

Active

YES

STRING

Indicates whether the item is active.

Dictionary_Address_Type

Table Name

Column Name

Is Nullable

Data Type

Description

Dictionary_Address_Type

Address_Type

YES

STRING

Type of address (e.g., mailing, billing, residential).

Dictionary_Address_Type

Address_Type_Description

YES

STRING

Detailed description of the address type.

Dictionary_Address_Type

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp indicating the start of the effective period.

Dictionary_Address_Type

Created_User_ID

YES

STRING

User ID of the user who created the record.

Dictionary_Address_Type

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Dictionary_Address_Type

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Dictionary_Address_Type

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Dictionary_Adjustment_Type_Translation

Table Name

Column Name

Is Nullable

Data Type

Description

Dictionary_Adjustment_Type_Translation

Source_Adjustment_Type_Code

YES

STRING

The code representing the adjustment type in the source system.

Dictionary_Adjustment_Type_Translation

Target_Adjustment_Type_Code

YES

STRING

The code representing the adjustment type in the target system.

Dictionary_Adjustment_Type_Translation

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp from which the translation becomes effective.

Dictionary_Adjustment_Type_Translation

Created_User_ID

YES

STRING

The identifier of the user who created the adjustment type translation entry.

Dictionary_Adjustment_Type_Translation

Created_Timestamp

YES

TIMESTAMP

The timestamp when the adjustment type translation entry was initially created.

Dictionary_Adjustment_Type_Translation

Last_Modified_User_ID

YES

STRING

The identifier of the user who last modified the adjustment type translation entry.

Dictionary_Adjustment_Type_Translation

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp of the most recent modification to the adjustment type translation entry.

Dictionary_Admission_Source

Table Name

Column Name

Is Nullable

Data Type

Description

Dictionary_Admission_Source

Source_Adjustment_Type_Code

YES

STRING

The code representing the adjustment type in the source system.

Dictionary_Admission_Source

Target_Adjustment_Type_Code

YES

STRING

The code representing the adjustment type in the target system.

Dictionary_Admission_Source

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp from which the translation becomes effective.

Dictionary_Admission_Source

Created_User_ID

YES

STRING

The identifier of the user who created the adjustment type translation entry.

Dictionary_Admission_Source

Created_Timestamp

YES

TIMESTAMP

The timestamp when the adjustment type translation entry was initially created.

Dictionary_Admission_Source

Last_Modified_User_ID

YES

STRING

The identifier of the user who last modified the adjustment type translation entry.

Dictionary_Admission_Source

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp of the most recent modification to the adjustment type translation entry.

Dictionary_Admission_Type

Table Name

Column Name

Is Nullable

Data Type

Description

Dictionary_Admission_Type

Admission_Type_Code

YES

STRING

A unique code representing the type of admission, such as elective, emergency, or urgent.

Dictionary_Admission_Type

Admission_Type_Description

YES

STRING

A detailed description of the type of admission, providing clarity on the admission process.

Dictionary_Admission_Type

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp indicating when the admission type becomes effective.

Dictionary_Admission_Type

Created_User_ID

YES

STRING

The identifier of the user who created the admission type entry.

Dictionary_Admission_Type

Created_Timestamp

YES

TIMESTAMP

The timestamp when the admission type entry was initially created.

Dictionary Dataset Specification (A-C)

Dictionary_Admission_Type

Columns

  • Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the admission type entry was initially created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the most recent modification to the admission type entry.

  • Admission_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the type of admission, such as elective, emergency, or urgent.

Dictionary_Alert

Columns

  • Alert

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates an alert or notification associated with a specific condition or event.

  • Alert_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the alert.

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

Columns

  • Appeal_Due_Date_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for changing the due date of an appeal.

  • Appeal_Due_Date_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the appeal due date change 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_Appeal_Level

Columns

  • Appeal_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of appeal.

  • Appeal_Level_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the appeal 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_Appeal_Process_Type

Columns

  • Appeal_Process_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of appeal process.

  • Appeal_Process_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the appeal process 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_Appeal_Process_Type_Appeal_Level_Mapping

Columns

  • Appeal_Process_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the appeal process.

  • Appeal_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of the appeal.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the appeal process type is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the appeal process 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 Dataset Specification (A-C)

Dictionary_Appeal_Reason

Columns

  • Appeal_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for initiating an appeal.

  • Appeal_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the appeal 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_Appeal_Requestor

Columns

  • Appeal_Requestor

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Entity or individual requesting the appeal.

  • Appeal_Requestor_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the appeal requestor.

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

Columns

  • Appeal_Reviewer

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Person or entity responsible for reviewing the appeal.

  • Appeal_Reviewer_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the appeal reviewer.

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

Columns

  • Appeal_Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source or origin of the appeal (e.g., member, provider, payer).

  • Appeal_Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the appeal source.

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

Columns

  • Appeal_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of the appeal (e.g., pending, approved, denied).

  • Appeal_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the appeal 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_Appeal_Type

Columns

  • Appeal_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of appeal (e.g., medical necessity, claim denial).

  • Appeal_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the appeal 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 Dataset Specification (A-C)

Dictionary_Appeal_Type_Appeal_Level_Mapping

Columns

  • Appeal_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the appeal.

  • Appeal_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of the appeal.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the appeal type is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the appeal 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_Application_Config

Columns

  • Application_Config_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific configuration setting or parameter in an application.

  • Application_Config_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Value associated with the application configuration code.

  • Application_Config_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the application configuration code.

  • Application_Config_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category or group to which the application configuration belongs.

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

Columns

  • Application_User_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of user accessing the application (e.g., member, provider, administrator).

  • Application_User_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the application user 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_Appointment_Event_Type

Columns

  • Event_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code assigned to identify a specific type of appointment event.

  • Event_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the appointment event type.

  • Related_Entity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The entity (e.g., patient, provider) to which this event type is related.

  • Minutes_Before

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The number of minutes before the appointment that this event occurs.

  • Appointment_Time_Minutes

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The duration of the appointment in minutes.

  • Minutes_After

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The number of minutes after the appointment that this event occurs.

  • Reminder_Hours

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The number of hours before the appointment when a reminder should be sent.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this appointment event type became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this appointment event 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 appointment event type entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Attachment_Category

Columns

  • Attachment_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category of the attachment.

  • Attachment_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the attachment category.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the attachment category is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the attachment category became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Dictionary Dataset Specification (A-C)

Dictionary_Attachment_Category

Fields

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

Fields

  • Attributed_Provider_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of healthcare provider attributed to a specific member or population.

  • Attributed_Provider_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code assigned to represent the attributed provider type.

  • Attributed_Provider_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the attributed provider 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_Audit_Log_Class

Fields

  • Audit_Log_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification or category of audit log entries (e.g., security, data access).

  • Audit_Log_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the audit log 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_Audit_Log_Data_Point

Fields

  • Audit_Log_Data_Point

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific data point or event captured in the audit log (e.g., login attempt, data modification).

  • Audit_Log_Data_Point_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the audit log data point.

  • Audit_Log_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Audit log data point 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_Audit_Transaction_Type

Fields

  • Audit_Transaction_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of transaction recorded in the audit log (e.g., read, write, delete).

  • Audit_Transaction_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the audit 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.

Dictionary_Auto_Approval_Rule

Fields

  • Auto_Approval_Rule_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique key or identifier for an automated approval rule.

  • Auto_Approval_Rule_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of automated approval rule (e.g., cost-saving, medical necessity).

  • Auto_Approval_Rule_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label for the automated approval rule.

  • Auto_Approval_Rule_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the automated approval rule.

  • Auto_Approval_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether an automated approval was granted or denied.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Active_Date

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Indicates the date from which the rule is active.

  • Inactive_Date

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Indicates the date from which the rule is inactive.

  • 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 (A-C)

Dictionary_Auto_Approval_Rule

Table Content

Column Name

Is Nullable

Data Type

Description

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_Auto_Approval_Rule_Type

Table Content

Column Name

Is Nullable

Data Type

Description

Auto_Approval_Rule_Type

YES

STRING

Type of the automated approval rule.

Auto_Approval_Rule_Type_Description

YES

STRING

Explanation of the automated approval rule 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_Availity_Treatment_Setting

Table Content

Column Name

Is Nullable

Data Type

Description

Treatment_Setting

YES

STRING

A code or identifier representing a specific treatment setting in the system.

Treatment_Setting_Description

YES

STRING

A detailed description of the treatment setting.

Active

YES

STRING

Indicates whether this treatment setting is currently active or in use.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp from which this treatment setting entry became or will become effective.

Created_User_ID

YES

STRING

The user ID of the person who created this treatment setting entry.

Created_Timestamp

YES

TIMESTAMP

The timestamp when this treatment setting entry was created.

Last_Modified_User_ID

YES

STRING

The user ID of the person who last modified this treatment setting entry.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when this treatment setting entry was last modified.

Dictionary_Axis

Table Content

Column Name

Is Nullable

Data Type

Description

Axis

YES

STRING

Represents a specific dimension or category (e.g., time, geography) in data analysis.

Axis_Description

YES

STRING

Detailed description of the axis.

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_Axis_Social_Problem

Table Content

Column Name

Is Nullable

Data Type

Description

Social_Problem

YES

STRING

Social issue or problem relevant to healthcare (e.g., substance abuse, homelessness).

Social_Problem_Description

YES

STRING

Explanation of the social problem.

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_Barrier

Table Content

Column Name

Is Nullable

Data Type

Description

Barrier

YES

STRING

Obstacle or challenge affecting healthcare access or outcomes (e.g., language barrier, transportation).

Barrier_Description

YES

STRING

Detailed description of the barrier.

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_Bed_Type

Table Content

Column Name

Is Nullable

Data Type

Description

Bed_Type

YES

STRING

Type of hospital bed (e.g., general ward, intensive care unit).

Bed_Type_Description

YES

STRING

Explanation of the bed type.

Active

YES

STRING

Indicates whether the item is active.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp indicating the start of the effective period.

Dictionary Dataset Specification (A-C)

Dictionary_Bed_Type

Columns

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

Columns

  • CCS_Diagnosis_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing a specific Clinical Classification Software (CCS) diagnosis.

  • CCS_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The category under which the CCS diagnosis falls, grouping similar diagnoses for analysis.

  • CCS_Diagnosis_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the CCS diagnosis, providing additional context and clarity.

  • CCS_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the CCS category, offering further explanation about the grouping or classification.

  • CCS_Level_1

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The first hierarchical level of classification within the CCS tool, representing broader diagnostic groups.

  • CCS_Level_1_Label

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The label associated with the first level of CCS classification, offering a descriptive name for the group.

  • CCS_Level_2

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The second hierarchical level of classification within the CCS tool, representing more specific groups.

  • CCS_Level_2_Label

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The label associated with the second level of CCS classification, offering a descriptive name for the subgroup.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the CCS diagnosis or classification became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the CCS diagnosis or classification entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the CCS diagnosis or classification entry was initially created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the CCS diagnosis or classification entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the most recent modification made to the CCS diagnosis or classification entry.

Dictionary_CareWebQI_Guideline

Columns

  • Guideline_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific clinical guideline or recommendation.

  • Guideline_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label for the clinical guideline.

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

Columns

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of a particular entity (e.g., active, inactive).

  • Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the status.

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

Columns

  • Care_Management_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category or approach to managing patient care (e.g., disease management, case management).

  • Care_Management_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the care management 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 Dataset Specification (A-C)

Dictionary_Carrier

Column Name

Is Nullable

Data Type

Description

Carrier

YES

STRING

Insurance carrier or provider organization responsible for coverage.

Carrier_Description

YES

STRING

Explanation of the insurance carrier.

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.

Active

YES

STRING

Indicates whether the item is active.

Dictionary_Claim_Line_Unit_Code

Column Name

Is Nullable

Data Type

Description

Unit_Type_Code

YES

STRING

A unique code representing the type of unit associated with a claim line, such as service or product units.

Unit_Type_Description

YES

STRING

A detailed description of the unit type, providing clarity about the nature of the units in claim lines.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp indicating when the unit type code became effective for use in the system.

Created_User_ID

YES

STRING

The identifier of the user who created the unit type entry in the dictionary.

Created_Timestamp

YES

TIMESTAMP

The timestamp when the unit type entry was initially created in the system.

Last_Modified_User_ID

YES

STRING

The identifier of the user who last modified the unit type entry in the dictionary.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp of the most recent modification to the unit type entry in the dictionary.

Dictionary_Claim_Status

Column Name

Is Nullable

Data Type

Description

Claim_Status_Code

YES

STRING

A unique code representing the status of a claim, such as "Pending," "Approved," or "Rejected."

Claim_Status_Description

YES

STRING

A detailed description of the claim status, providing additional context for the associated status code.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp indicating when the claim status code became effective for use.

Created_User_ID

YES

STRING

The identifier of the user who created the claim status entry in the dictionary.

Created_Timestamp

YES

TIMESTAMP

The timestamp when the claim status entry was initially created in the system.

Last_Modified_User_ID

YES

STRING

The identifier of the user who last modified the claim status entry in the dictionary.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp of the most recent modification to the claim status entry in the dictionary.

Dictionary_Claim_Type

Column Name

Is Nullable

Data Type

Description

Claim_Type_Code

YES

STRING

A unique identifier representing the type of claim, such as "Inpatient," "Outpatient," or "Pharmacy."

Claim_Type_Description

YES

STRING

A detailed description of the claim type, providing additional context for the associated type code.

Claim_Type_Code_Short

YES

STRING

A short or abbreviated version of the claim type code for simplified reference or reporting purposes.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp indicating when the claim type code became valid and active in the system.

Created_User_ID

YES

STRING

The unique identifier of the user who created the claim type entry in the dictionary dataset.

Created_Timestamp

YES

TIMESTAMP

The timestamp when the claim type entry was initially added to the system.

Last_Modified_User_ID

YES

STRING

The unique identifier of the user who last updated or modified the claim type entry.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when the claim type entry was last modified, reflecting the most recent update.

Dictionary_Client

Column Name

Is Nullable

Data Type

Description

Client

YES

STRING

Client organization or entity served by the system (e.g., healthcare provider, employer).

Client_Description

YES

STRING

Description of the client organization.

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_Client_Alias

Column Name

Is Nullable

Data Type

Description

Tenant

YES

STRING

The unique identifier representing the tenant within the healthcare system.

Dictionary Dataset Specification (A-C)

Dictionary_Client_Alias

Columns

  • Alias

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique alias assigned to the client, used for identification or grouping purposes.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the client alias became effective in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the client alias record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the client alias record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the client alias record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the client alias record was last updated in the system.

Dictionary_Coding_Scheme

Columns

  • Coding_Scheme

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Standardized system for assigning codes to medical concepts (e.g., ICD-10, CPT).

  • Coding_Scheme_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the coding scheme.

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

Columns

  • Condition_Mapped

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the condition has been mapped to a standard code or description.

  • Condition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique code assigned to the condition within the system.

  • Condition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the condition, providing clarity on its definition or classification.

  • Subcondition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique code assigned to a specific subcondition under the primary condition.

  • Subcondition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the subcondition associated with the primary condition.

  • Condition_Chronic_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the condition is classified as chronic (e.g., "Y" for Yes or "N" for No).

  • Source_Condition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code for the condition as received from the source system or external dataset.

  • Chronic_Acute

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the condition is chronic, acute, or falls into another classification category.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of visibility for the condition in the system, such as user or department-specific.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the condition became effective in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the condition record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the condition record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the condition record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the condition record was last updated in the system.

Dictionary_Condition_Category

Columns

  • Condition_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category or group of related medical conditions (e.g., cardiovascular, respiratory).

  • Condition_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the condition category.

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

Columns

  • Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing a group of conditions or mapping rules for classification and application.

  • Condition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique code assigned to the condition that the mapping rule applies to.

  • Mapping_Rule

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed rule specifying how the condition is mapped, including criteria and logic used for mapping.

  • Inclusive_Diagnosis_Codes_Group

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A group of diagnosis codes that are included as part of the mapping rule for this condition.

  • Exclusive_Diagnosis_Codes_Group

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A group of diagnosis codes that are excluded from the mapping rule for this condition.

  • Episode_Count

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the required number of episodes for the condition to meet the mapping criteria.

Dictionary Dataset Specification (A-C)

Dictionary Condition Mapping Rules

Columns

  • Acceptable_Disease_Stage_Threshold

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the acceptable stage threshold for the disease when applying the mapping rule.

  • Unacceptable_Disease_Stage_Threshold

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the unacceptable stage threshold for the disease, beyond which the mapping rule does not apply.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the mapping rule became effective in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the mapping rule record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the mapping rule record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the mapping rule record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the mapping rule record was last updated in the system.

Dictionary Coordinated Care Discharge Disposition

Columns

  • Coordinated_Care_Discharge_Disposition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Discharge disposition related to coordinated care (e.g., home health, skilled nursing facility).

  • Coordinated_Care_Discharge_Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the coordinated care discharge disposition.

  • 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 Cost Category

Columns

  • Cost_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification of costs (e.g., direct medical costs, administrative costs).

  • Cost_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the cost category.

  • 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 Cost Saving

Columns

  • Cost_Saving

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates cost-saving measures or strategies.

  • Cost_Saving_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the cost-saving approach.

  • 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 Cost Saving Cost Void Reason

Columns

  • Cost_Saving_Cost_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding or canceling a cost-saving entry.

  • Cost_Saving_Cost_Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the cost-saving 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 Cost Saving Diagnosis Group

Columns

  • Cost_Saving_Diagnosis_Group

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Grouping of diagnoses related to cost-saving efforts.

  • Cost_Saving_Diagnosis_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the cost-saving diagnosis group.

Dictionary Dataset Specification (A-C)

Dictionary_Cost_Saving_Diagnosis_Group

Table Content

Column Name

Is Nullable

Data Type

Description

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_Cost_Saving_Type

Table Content

Column Name

Is Nullable

Data Type

Description

Cost_Saving_Type

YES

STRING

Type of cost-saving initiative (e.g., utilization review, generic drug substitution).

Cost_Saving_Type_Description

YES

STRING

Explanation of the cost-saving type.

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_Cost_Saving_Type_Of_Care

Table Content

Column Name

Is Nullable

Data Type

Description

Cost_Saving_Type_Of_Care

YES

STRING

Specific area of care targeted for cost-saving measures (e.g., outpatient visits, prescription drugs).

Cost_Saving_Type_Of_Care_Description

YES

STRING

Detailed description of the cost-saving type of care.

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_Cost_Saving_Void_Reason

Table Content

Column Name

Is Nullable

Data Type

Description

Cost_Saving_Void_Reason

YES

STRING

Reason for voiding or canceling a cost-saving entry.

Cost_Saving_Void_Reason_Description

YES

STRING

Explanation of the cost-saving void reason.

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_Cost_Type

Table Content

Column Name

Is Nullable

Data Type

Description

Cost_Type

YES

STRING

Classification of costs (e.g., direct, indirect).

Cost_Type_Description

YES

STRING

Detailed description of the cost 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.

Related Articles
Dictionary Dataset Specification
Department Dataset Specification
User Dataset Specification
Dictionary Dataset Specification M Q
Dictionary Dataset Specification R Z
Did this answer your question?