Skip to main content

Dictionary Dataset Specification D L

Updated over 2 months ago

Dictionary Dataset Specification D L

Dictionary Dataset Specification (D-L)

Dictionary Deescalate Reason

Table Structure

  • Deescalate_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for deescalation.

  • Deescalate_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the deescalation reason.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the deescalation reason is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the deescalation reason 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 Delegate Entity

Table Structure

  • Delegate_Entity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Entity authorized to act on behalf of another (e.g., delegated provider, representative).

  • Delegate_Entity_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the delegate entity.

  • Full_Delegation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicator whether full delegation is granted.

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

Table Structure

  • Department_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code identifying the department.

  • Department_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the department.

  • Product_Availability

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the availability of the product within the department.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the department record is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which the department record is effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Diagnosis Category

Table Structure

  • Diagnosis_Category_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code assigned to identify the diagnosis category within the healthcare domain.

  • Diagnosis_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the diagnosis category, explaining its purpose and classification.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis category became effective and available for use.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis category record was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Diagnosis Group

Table Structure

  • Diagnosis_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing a specific diagnosis group.

Dictionary Dataset Specification (D-L)

Dictionary_Diagnosis_Group

Columns and Descriptions

  • Diagnosis_Group_Mdc_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code linking the diagnosis group to a specific Major Diagnostic Category (MDC).

  • Diagnosis_Group_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of code set used for the diagnosis group (e.g., ICD, SNOMED).

  • Diagnosis_Group_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code indicating the type or category of the diagnosis group.

  • Diagnosis_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the diagnosis group, providing context and classification.

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting code in the range for the diagnosis group.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending code in the range for the diagnosis group.

  • Arithmetic_Mean_Los

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The arithmetic mean length of stay (LOS) associated with this diagnosis group.

  • Geometric_Mean_Los

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The geometric mean length of stay (LOS) for patients in this diagnosis group.

  • Relative_Weight

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A relative weight assigned to this diagnosis group, often used in payment calculations.

  • Post_Acute

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this diagnosis group is eligible for post-acute care payment adjustments.

  • Special_Pay

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this diagnosis group qualifies for special payment conditions.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the code set (e.g., ICD-10, CPT) used for the diagnosis group.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Version of the code set associated with the diagnosis group.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the diagnosis group is currently active (e.g., "Y" for active, "N" for inactive).

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis group became effective and valid for use.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis group record was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Diagnosis_ICD10

Columns and Descriptions

  • Diagnosis_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique ICD-10 diagnosis code used for classification.

  • Diagnosis_Formatted_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The formatted version of the diagnosis code, typically including punctuation or formatting details.

  • Diagnosis_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of code set the diagnosis belongs to, such as "ICD-10".

  • Diagnosis_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the diagnosis represented by the ICD-10 code.

  • Diagnosis_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A short-term description of the diagnosis for simplified referencing.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of visibility for the diagnosis (e.g., "Public" or "Restricted").

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting code in a range of ICD-10 codes, if applicable.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending code in a range of ICD-10 codes, if applicable.

  • Billable

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the diagnosis code is billable (e.g., "Y" for yes, "N" for no).

  • Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting date from which the diagnosis code became billable.

  • Billable_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending date after which the diagnosis code is no longer billable.

  • Chapter

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ICD-10 chapter or category to which the diagnosis belongs.

  • Upper_Case_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The uppercase representation of the diagnosis code, used for standardized referencing.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the code set (e.g., ICD-10) associated with the diagnosis.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version of the code set in use for the diagnosis.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the diagnosis code is currently active (e.g., "Y" for active, "N" for inactive).

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis code became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis record was last modified.

Dictionary_Diagnosis_ICD9

Columns and Descriptions

  • Diagnosis_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique ICD-9 diagnosis code used for classification.

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An alternative representation or abbreviation of the diagnosis code.

  • Diagnosis_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of code set the diagnosis belongs to, such as "ICD-9".

  • Diagnosis_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the diagnosis represented by the ICD-9 code.

  • Short_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A short-term description of the diagnosis for simplified referencing.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of visibility for the diagnosis (e.g., "Public" or "Restricted").

Dictionary Dataset Specification (D-L)

Dictionary Diagnosis ICD9

Columns and Descriptions

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting code in a range of ICD-9 codes, if applicable.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending code in a range of ICD-9 codes, if applicable.

  • Billable

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the diagnosis code is billable (e.g., "Y" for yes, "N" for no).

  • Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting date from which the diagnosis code became billable.

  • Billable_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending date after which the diagnosis code is no longer billable.

  • Chapter

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ICD-9 chapter or category to which the diagnosis belongs.

  • Upper_Case_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The uppercase representation of the diagnosis code, used for standardized referencing.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the code set (e.g., ICD-9) associated with the diagnosis.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version of the code set in use for the diagnosis.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the diagnosis code is currently active (e.g., "Y" for active, "N" for inactive).

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis code became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis record was last modified.

Dictionary Diagnosis Introducer

Columns and Descriptions

  • Diagnosis_Introducer_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique code representing the diagnosis introducer.

  • Diagnosis_Introducer_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the diagnosis introducer, explaining its purpose and context.

  • Diagnosis_Introducer_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The category or classification of the diagnosis introducer (e.g., primary, secondary).

  • Diagnosis_Scheme_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code of the scheme or system in which the diagnosis introducer is defined.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis introducer became effective and valid for use.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for the diagnosis introducer.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the diagnosis introducer record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis introducer record was last updated.

Dictionary Discharge Disposition

Columns and Descriptions

  • Disposition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome or decision related to a specific event (e.g., case disposition, claim resolution).

  • Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the discharge disposition.

  • ACTIVE

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the discharge disposition is currently active or in use.

  • 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 Dispense As Written

Columns and Descriptions

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the dispense-as-written directive, used for prescribing medications.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the dispense-as-written directive, explaining its purpose and usage.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the dispense-as-written directive became effective and valid for use.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for the dispense-as-written directive.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the dispense-as-written directive record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the dispense-as-written directive record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the dispense-as-written directive record was last updated.

Dictionary Disposition

Columns and Descriptions

  • Disposition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome or decision related to a specific event (e.g., case disposition, claim resolution).

  • Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the 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 Dataset Specification (D-L)

Dictionary_Disposition

Columns

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Divert_Reason

Columns

  • Divert_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for diverting or redirecting a process or task.

  • Divert_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the divert reason.

  • Divert_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of diversion (e.g., medical, administrative).

  • Designation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A specific label or classification related to the divert reason, providing additional context.

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

Columns

  • Divert_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of diversion (e.g., medical, administrative).

  • Divert_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the divert 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_Drug

Columns

  • NDC

  • Is Nullable: YES

  • Data Type: STRING

  • Description: National Drug Code (NDC) representing a unique identifier for the drug.

  • Maintenance_Drug_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code indicating whether the drug is classified as a maintenance medication.

  • Drug_Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the drug's therapeutic class.

  • Maintenance_Drug_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the drug's maintenance classification.

  • Drug_Package_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the drug's packaging details.

  • Drug_Scheme_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code related to the scheme under which the drug is categorized.

  • GPI2_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: 2-digit Generic Product Identifier (GPI) code indicating a broad therapeutic category.

  • GPI6_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: 6-digit Generic Product Identifier (GPI) code specifying a narrower therapeutic category.

  • Admin_Route_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code indicating the route of administration for the drug (e.g., oral, intravenous).

  • Admin_Route_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the route of administration for the drug.

  • Drug_Brand_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the drug's brand name.

  • Parent_Drug_Class_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the parent level of the drug class hierarchy.

  • Multiple_Source_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code indicating whether the drug has multiple sources (e.g., generic equivalents).

  • GPI14_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: 14-digit Generic Product Identifier (GPI) code providing the most detailed product classification.

  • GPI6_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the 6-digit GPI code classification.

  • Drug_Class_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Hierarchical level of the drug's class in the classification scheme.

  • Med_Trputc_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Flag indicating if the drug is classified as a medical therapeutic product.

  • Drug_Brand_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the brand of the drug.

  • Parent_Drug_Class_Description_Full

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full description of the parent drug class.

  • GPI4_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the 4-digit GPI code classification.

  • Dea_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the DEA (Drug Enforcement Administration) classification for the drug.

  • GPI2_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the 2-digit GPI code classification.

  • NDC_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • GPI4_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: 4-digit Generic Product Identifier (GPI) code specifying a subcategory.

  • GPI14_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the 14-digit GPI code classification.

  • Parent_Drug_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the parent drug class.

  • Drug_Class_Scheme_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the scheme used for drug class classification.

  • Drug_Class_Description_Full

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Comprehensive description of the drug's class.

  • Dea_Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the DEA classification of the drug.

  • GPI10_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the 10-digit GPI code classification.

  • GPI10_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: 10-digit Generic Product Identifier (GPI) code providing detailed therapeutic classification.

  • Product_Description_Abbreviation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Abbreviated description of the product.

  • Drug_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: General description of the drug's class.

  • Parent_Drug_Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code of the parent drug class in the hierarchy.

  • Drug_Package_Size

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The size of the drug package, indicating quantity or volume.

Dictionary Dataset Specification (D-L)

Dictionary_Drug

Columns

  • Drug_Class_Lvl

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of the drug's class in the classification hierarchy.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The level of visibility assigned to the drug for reporting or categorization purposes.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the drug's record became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who created the drug record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the drug record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified the drug record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the drug record was last updated.

Dictionary_Drug_Type

Columns

  • Drug_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the drug type.

  • Drug_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the drug type, indicating its classification or usage category.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the drug type record became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the drug type record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the drug type record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the drug type record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the drug type record was last updated.

Dictionary_Email_Type

Columns

  • Email_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification of email types (e.g., notification, communication).

  • Email_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the email 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_Emmi_Status

Columns

  • Emmi_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status related to electronic medical record exchange (e.g., sent, received).

  • Emmi_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the Emmi 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_Employer_Group

Columns

  • Group_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for a specific group or category.

  • Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label for the group.

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

Columns

  • Encounter_Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the type or classification of the healthcare encounter.

  • Encounter_Class_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or description of the encounter class, providing a clear identification of the type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the encounter class became effective and valid for use.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for the encounter class.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the encounter class record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the encounter class record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the last modification made to the encounter class record.

Dictionary_Encounter_Condition

Columns

  • Encounter_Condition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code that identifies the encounter condition.

  • Encounter_Condition_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the encounter condition, providing a human-readable description.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the encounter condition became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for this encounter condition.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the encounter condition record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the record for this encounter condition.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the record was last modified.

Dictionary Dataset Specification (D-L)

Dictionary Encounter Condition

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the encounter condition record was last updated.

Dictionary Encounter Priority

Encounter Priority Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the priority level of the encounter.

Encounter Priority Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the encounter priority, providing a descriptive label for the priority level.

Effective From Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the encounter priority became effective in the system.

Created User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for this encounter priority.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the encounter priority record was created.

Last Modified User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the record for this encounter priority.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the encounter priority record was last updated.

Dictionary Encounter Service Type

Encounter Service Type Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code identifying the type of service associated with the encounter.

Encounter Service Type Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the service type for the encounter, providing a descriptive label.

Effective From Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the service type became effective in the system.

Created User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for this service type.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the service type record was created.

Last Modified User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the record for this service type.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the service type record was last updated.

Dictionary Encounter Status

Encounter Status Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the status of an encounter.

Encounter Status Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or label of the encounter status, providing a descriptive identifier.

Effective From Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the encounter status became effective in the system.

Created User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for this encounter status.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the record for the encounter status was created.

Last Modified User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the record for this encounter status.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the record for the encounter status was last updated.

Dictionary Enrollment Alert

Enrollment Alert

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Alert related to enrollment or registration (e.g., missing information, eligibility issue).

Enrollment Alert Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the enrollment 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 Enrollment Provider Role

Provider Role

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Role or function of a healthcare provider (e.g., primary care physician, specialist).

Provider Role Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the provider role.

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

Group Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code identifying the episode group.

Group Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the episode group, providing a descriptive label for the group.

Clean Period

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The period used to determine the time frame for grouping episodes (e.g., days or months).

Type Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing the type of episode group.

Type Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or description of the type of episode group.

SDC Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code linking the episode group to a specific Standardized Data Code (SDC).

SDC Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or description associated with the Standardized Data Code for the episode group.

Dictionary Dataset Specification (D-L)

Dictionary Episode Group

Columns

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the episode group became effective in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for this episode group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the record for the episode group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the record for this episode group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the record for the episode group was last updated.

Dictionary External Population

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier code for the external population.

  • Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the external population, providing a descriptive label.

  • Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The origin or source of the external population data (e.g., system name or dataset).

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the external population record became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the external population record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the external population record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the external population record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the external population record was last updated.

Dictionary External Population Source

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code identifying the external population source.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the external population source, providing context and clarity.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the external population source record became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the external population source record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the external population source record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the external population source record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the external population source record was last updated.

Dictionary Gender

Columns

  • Gender

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification of individuals based on their biological sex.

  • Gender_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the gender 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 Goal

Columns

  • Goal

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific objective or target to achieve.

  • Goal_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the goal.

  • 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 Goal Focus

Columns

  • Goal_Focus

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Area of focus related to the goal (e.g., physical fitness, mental health).

  • Goal_Focus_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the goal focus.

  • 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 Goal Outcome

Columns

  • Goal_Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Desired outcome resulting from achieving the goal (e.g., improved mobility, reduced pain).

  • Goal_Outcome_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the goal outcome.

  • Goal_Outcome_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category or group to which the goal outcome belongs.

  • 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 (D-L)

Dictionary_Goal_Outcome

Columns

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Goal_Outcome_Category

Columns

  • Goal_Outcome_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category or group to which the goal outcome belongs.

  • Goal_Outcome_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the goal outcome 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_Goal_Type

Columns

  • Goal_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or nature of the goal (e.g., short-term, long-term, behavioral).

  • Goal_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the goal 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_HL7_Abnormal_Flags

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing an HL7 abnormal flag.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the HL7 abnormal flag, indicating its significance or usage context.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the abnormal flag became effective for use.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for the abnormal flag.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the abnormal flag record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the abnormal flag record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the abnormal flag record was last updated.

Dictionary_Healthcare_Type

Columns

  • Healthcare_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of healthcare.

  • Healthcare_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the healthcare type.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the healthcare type is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the healthcare type became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Dictionary_Holiday_Schedule

Columns

  • Holiday_Date

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Date of a recognized holiday or observance.

  • Holiday_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the holiday or observance.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicator whether an item is currently active or 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_InterQualConnect_Review_Criteria_Met

Columns

  • Criteria_Met

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicator whether specific criteria have been met.

  • Criteria_Met_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the criteria met.

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

Columns

  • Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Result or consequence of an action or process (e.g., successful enrollment, treatment outcome).

  • Outcome_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the outcome.

Dictionary Dataset Specification (D-L)

Dictionary InterQualConnect Review Outcome

Columns

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary InterQualConnect Review Product

Columns

  • Product

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific item, service, or offering (e.g., insurance plan, medication).

  • Product_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the product.

  • Product_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of product (e.g., health insurance, financial product).

  • 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 iExchange Group

Columns

  • iExchange_Group_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for a specific group within an exchange system.

  • iExchange_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label for the iExchange group.

  • 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 Interaction Disposition

Columns

  • Interaction_Disposition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome or decision related to a specific interaction (e.g., call resolved, escalation).

  • Interaction_Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the interaction 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 Interaction Topic

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Short alphanumeric identifier or reference for an item (e.g., product code, category code).

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed explanation or label of the code.

  • 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 Interaction Topic Resolution

Columns

  • Resolution

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome or solution resulting from addressing an issue or problem (e.g., case resolved, issue closed).

  • Resolution_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the resolution.

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

Columns

  • Interaction_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of interaction (e.g., phone call, email, chat).

  • Interaction_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the interaction type.

Dictionary Dataset Specification (D-L)

Dictionary Interaction Type

Columns and Descriptions

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

Columns and Descriptions

  • Intervention

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action or measure taken to address a specific issue or problem (e.g., counseling, medication adjustment).

  • Intervention_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the intervention.

  • Member_Engagement

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of engagement or involvement of a member in a program or service (e.g., high, moderate, low).

  • Member_Engagement_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the member engagement level.

  • Member_Engagement_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of member engagement (e.g., proactive, reactive).

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

Columns and Descriptions

  • LOINC_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for a LOINC code, representing a specific laboratory or clinical observation.

  • Component

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The component or analyte that the LOINC code refers to, such as "Glucose" or "Cholesterol."

  • Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The classification code for the LOINC term, grouping similar tests or observations.

  • Class_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of class for the LOINC code, indicating its category in the hierarchy.

  • Short_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A concise name for the LOINC code, commonly used in reporting or display systems.

  • Long_Common_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed, standardized name for the LOINC code, providing clarity on its meaning and use.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The visibility level of the LOINC code, indicating its relevance or accessibility in specific contexts.

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting range for a code set if the LOINC code is part of a series or range.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending range for a code set if the LOINC code is part of a series or range.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The current status of the LOINC code, such as "Active" or "Deprecated."

  • Common_Test

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the LOINC code represents a commonly performed test.

  • Property

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The property of the observation, such as "Mass" or "Concentration," represented by the LOINC code.

  • Time

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The time aspect of the observation, such as "Point in time" or "24 hours."

  • System

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The system or specimen associated with the LOINC code, such as "Blood" or "Urine."

  • Scale

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The scale of measurement, such as "Quantitative" or "Ordinal."

  • Method

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The method used for the observation, if applicable, such as "EIA" or "Immunoassay."

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The set to which the LOINC code belongs, for grouping and categorization purposes.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version of the LOINC code, representing updates or revisions.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the LOINC code is currently active or inactive.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the LOINC code became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the LOINC code record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the LOINC code record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the LOINC code record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the LOINC code record was last updated.

Dictionary LOINC Class

Columns and Descriptions

  • Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the LOINC class, representing a grouping of related laboratory or clinical tests.

  • Class_Type_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the LOINC class type, categorizing the nature of tests or observations within the class.

  • Class_Type_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier for the type of class, enabling differentiation between similar categories.

  • Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the LOINC class, providing context and purpose for the grouped observations.

  • Class_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting point or initial version of the LOINC class, if applicable.

  • Class_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending point or final version of the LOINC class, if applicable.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The set of codes associated with the LOINC class, providing a reference for classification.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version of the code set, reflecting updates or revisions to the LOINC class.

Dictionary Dataset Specification (D-L)

Dictionary_LOINC_Class

Columns

  • y_LOINC_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the LOINC class is currently active (TRUE) or inactive (FALSE).

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the LOINC class became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the LOINC class record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the LOINC class record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the LOINC class record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the last modification made to the LOINC class record.

Dictionary_Lab_Result_Interpretation

Columns

  • Input

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The input value or code representing a specific laboratory result interpretation.

  • Output

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The output value or translated result corresponding to the input, providing standardized interpretation.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the interpretation mapping became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the interpretation mapping record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the last modification made to the interpretation mapping record.

Dictionary_Language

Columns

  • Language

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific language used for communication or documentation (e.g., English, Spanish).

  • Language_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the language.

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

Columns

  • Length_Of_Stay_Unit_Of_Measure

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unit of measurement for length of stay (e.g., days, hours).

  • Length_Of_Stay_Unit_Of_Measure_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the length of stay unit of measure.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Letter_Action

Columns

  • Letter_Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action associated with a letter (e.g., send, archive, review).

  • Letter_Action_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the letter action.

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

Columns

  • Letter_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification or category of letters (e.g., medical, administrative).

  • Letter_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the letter 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_Letter_Status

Columns

  • Letter_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of a letter (e.g., drafted, sent, received).

  • Letter_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the letter 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 Dataset Specification (D-L)

Dictionary_Letter_Type

Columns

  • Letter_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or purpose of a letter (e.g., appointment reminder, denial notice).

  • Letter_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the letter 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_Line_Of_Business

Columns

  • Line_Of_Business

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific business line or area (e.g., health insurance, dental coverage).

  • Line_Of_Business_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the line of business.

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

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the link.

  • Link_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the link.

  • Link_URL

  • Is Nullable: YES

  • Data Type: STRING

  • Description: URL of the link.

  • Link_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the link.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the link is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the link 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_Deescalate_Reason

Columns

  • Deescalate_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for deescalation.

  • Deescalate_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the deescalation reason.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the deescalation reason is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the deescalation reason 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_Delegate_Entity

Columns

  • Delegate_Entity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Entity authorized to act on behalf of another (e.g., delegated provider, representative).

  • Delegate_Entity_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the delegate entity.

  • Full_Delegation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicator whether full delegation is granted.

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

Columns

  • Department_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code identifying the department.

  • Department_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the department.

  • Product_Availability

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the availability of the product within the department.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the department record is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which the department record is effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (D-L)

Dictionary_Diagnosis_Category

Columns

  • Diagnosis_Category_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code assigned to identify the diagnosis category within the healthcare domain.

  • Diagnosis_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the diagnosis category, explaining its purpose and classification.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis category became effective and available for use.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis category record was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Diagnosis_Group

Columns

  • Diagnosis_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing a specific diagnosis group in the healthcare domain.

  • Diagnosis_Group_Mdc_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code linking the diagnosis group to a specific Major Diagnostic Category (MDC).

  • Diagnosis_Group_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of code set used for the diagnosis group (e.g., ICD, SNOMED).

  • Diagnosis_Group_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code indicating the type or category of the diagnosis group.

  • Diagnosis_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the diagnosis group, providing context and classification.

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting code in the range for the diagnosis group.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending code in the range for the diagnosis group.

  • Arithmetic_Mean_Los

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The arithmetic mean length of stay (LOS) associated with this diagnosis group.

  • Geometric_Mean_Los

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The geometric mean length of stay (LOS) for patients in this diagnosis group.

  • Relative_Weight

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A relative weight assigned to this diagnosis group, often used in payment calculations.

  • Post_Acute

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this diagnosis group is eligible for post-acute care payment adjustments.

  • Special_Pay

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this diagnosis group qualifies for special payment conditions.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the code set (e.g., ICD-10, CPT) used for the diagnosis group.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Version of the code set associated with the diagnosis group.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the diagnosis group is currently active (e.g., "Y" for active, "N" for inactive).

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis group became effective and valid for use.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis group record was created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Diagnosis_ICD10

Columns

  • Diagnosis_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique ICD-10 diagnosis code used for classification.

  • Diagnosis_Formatted_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The formatted version of the diagnosis code, typically including punctuation or formatting details.

  • Diagnosis_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of code set the diagnosis belongs to, such as "ICD-10".

  • Diagnosis_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the diagnosis represented by the ICD-10 code.

  • Diagnosis_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A short-term description of the diagnosis for simplified referencing.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of visibility for the diagnosis (e.g., "Public" or "Restricted").

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting code in a range of ICD-10 codes, if applicable.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending code in a range of ICD-10 codes, if applicable.

  • Billable

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the diagnosis code is billable (e.g., "Y" for yes, "N" for no).

  • Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting date from which the diagnosis code became billable.

  • Billable_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending date after which the diagnosis code is no longer billable.

  • Chapter

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ICD-10 chapter or category to which the diagnosis belongs.

  • Upper_Case_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The uppercase representation of the diagnosis code, used for standardization.

Dictionary Dataset Specification (D-L)

Dictionary_Diagnosis_ICD10

Columns

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the code set (e.g., ICD-10) associated with the diagnosis.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version of the code set in use for the diagnosis.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the diagnosis code is currently active (e.g., "Y" for active, "N" for inactive).

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis code became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis record was last modified.

Dictionary_Diagnosis_ICD9

Columns

  • Diagnosis_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique ICD-9 diagnosis code used for classification.

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An alternative representation or abbreviation of the diagnosis code.

  • Diagnosis_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of code set the diagnosis belongs to, such as "ICD-9".

  • Diagnosis_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the diagnosis represented by the ICD-9 code.

  • Short_Term

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A short-term description of the diagnosis for simplified referencing.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the level of visibility for the diagnosis (e.g., "Public" or "Restricted").

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting code in a range of ICD-9 codes, if applicable.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending code in a range of ICD-9 codes, if applicable.

  • Billable

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the diagnosis code is billable (e.g., "Y" for yes, "N" for no).

  • Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting date from which the diagnosis code became billable.

  • Billable_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending date after which the diagnosis code is no longer billable.

  • Chapter

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ICD-9 chapter or category to which the diagnosis belongs.

  • Upper_Case_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The uppercase representation of the diagnosis code, used for standardized referencing.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the code set (e.g., ICD-9) associated with the diagnosis.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version of the code set in use for the diagnosis.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the diagnosis code is currently active (e.g., "Y" for active, "N" for inactive).

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis code became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis record was last modified.

Dictionary_Diagnosis_Introducer

Columns

  • Diagnosis_Introducer_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique code representing the diagnosis introducer.

  • Diagnosis_Introducer_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the diagnosis introducer, explaining its purpose and context.

  • Diagnosis_Introducer_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The category or classification of the diagnosis introducer (e.g., primary, secondary).

  • Diagnosis_Scheme_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code of the scheme or system in which the diagnosis introducer is defined.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis introducer became effective and valid for use.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for the diagnosis introducer.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the diagnosis introducer record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the diagnosis introducer record was last updated.

Dictionary_Discharge_Disposition

Columns

  • Disposition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome or decision related to a specific event (e.g., case disposition, claim resolution).

  • Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the discharge disposition.

  • ACTIVE

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the discharge disposition is currently active or in use.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the discharge disposition became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the discharge disposition record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the discharge disposition record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the discharge disposition record was last updated.

Dictionary Dataset Specification (D-L)

Dictionary_Discharge_Disposition

Columns

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Dispense_As_Written

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the dispense-as-written directive, used for prescribing medications.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the dispense-as-written directive, explaining its purpose and usage.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the dispense-as-written directive became effective and valid for use.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for the dispense-as-written directive.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the dispense-as-written directive record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the dispense-as-written directive record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the dispense-as-written directive record was last updated.

Dictionary_Disposition

Columns

  • Disposition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome or decision related to a specific event (e.g., case disposition, claim resolution).

  • Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Columns

  • Divert_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for diverting or redirecting a process or task.

  • Divert_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the divert reason.

  • Divert_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of diversion (e.g., medical, administrative).

  • Designation

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A specific label or classification related to the divert reason, providing additional context.

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

Columns

  • Divert_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of diversion (e.g., medical, administrative).

  • Divert_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the divert 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_Drug

Columns

  • NDC

  • Is Nullable: YES

  • Data Type: STRING

  • Description: National Drug Code (NDC) representing a unique identifier for the drug.

  • Maintenance_Drug_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code indicating whether the drug is classified as a maintenance medication.

  • Drug_Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the drug's therapeutic class.

  • Maintenance_Drug_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the drug's maintenance classification.

  • Drug_Package_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the drug's packaging details.

  • Drug_Scheme_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code related to the scheme under which the drug is categorized.

  • GPI2_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: 2-digit Generic Product Identifier (GPI) code indicating a broad therapeutic category.

  • GPI6_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: 6-digit Generic Product Identifier (GPI) code indicating a specific therapeutic category.

Dictionary Dataset Specification (D-L)

Dictionary_Drug

Columns and Descriptions

  • Generic_Product_Identifier (GPI) Code

  • Data Type: STRING

  • Description: 6-digit Generic Product Identifier (GPI) code specifying a narrower therapeutic category.

  • Admin_Route_Code

  • Data Type: STRING

  • Description: Code indicating the route of administration for the drug (e.g., oral, intravenous).

  • Admin_Route_Description

  • Data Type: STRING

  • Description: Description of the route of administration for the drug.

  • Drug_Brand_Description

  • Data Type: STRING

  • Description: Description of the drug's brand name.

  • Parent_Drug_Class_Level

  • Data Type: STRING

  • Description: Code representing the parent level of the drug class hierarchy.

  • Multiple_Source_Code

  • Data Type: STRING

  • Description: Code indicating whether the drug has multiple sources (e.g., generic equivalents).

  • GPI14_Code

  • Data Type: STRING

  • Description: 14-digit Generic Product Identifier (GPI) code providing the most detailed product classification.

  • GPI6_Description

  • Data Type: STRING

  • Description: Description of the 6-digit GPI code classification.

  • Drug_Class_Level

  • Data Type: STRING

  • Description: Hierarchical level of the drug's class in the classification scheme.

  • Med_Trputc_Flag

  • Data Type: STRING

  • Description: Flag indicating if the drug is classified as a medical therapeutic product.

  • Drug_Brand_Code

  • Data Type: STRING

  • Description: Code representing the brand of the drug.

  • Parent_Drug_Class_Description_Full

  • Data Type: STRING

  • Description: Full description of the parent drug class.

  • GPI4_Description

  • Data Type: STRING

  • Description: Description of the 4-digit GPI code classification.

  • Dea_Class_Description

  • Data Type: STRING

  • Description: Description of the DEA (Drug Enforcement Administration) classification for the drug.

  • GPI2_Description

  • Data Type: STRING

  • Description: Description of the 2-digit GPI code classification.

  • NDC_Description

  • Data Type: STRING

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

  • GPI4_Code

  • Data Type: STRING

  • Description: 4-digit Generic Product Identifier (GPI) code specifying a subcategory.

  • GPI14_Description

  • Data Type: STRING

  • Description: Description of the 14-digit GPI code classification.

  • Parent_Drug_Class_Description

  • Data Type: STRING

  • Description: Description of the parent drug class.

  • Drug_Class_Scheme_Description

  • Data Type: STRING

  • Description: Description of the scheme used for drug class classification.

  • Drug_Class_Description_Full

  • Data Type: STRING

  • Description: Comprehensive description of the drug's class.

  • Dea_Class_Code

  • Data Type: STRING

  • Description: Code representing the DEA classification of the drug.

  • GPI10_Description

  • Data Type: STRING

  • Description: Description of the 10-digit GPI code classification.

  • GPI10_Code

  • Data Type: STRING

  • Description: 10-digit Generic Product Identifier (GPI) code providing detailed therapeutic classification.

  • Product_Description_Abbreviation

  • Data Type: STRING

  • Description: Abbreviated description of the product.

  • Drug_Class_Description

  • Data Type: STRING

  • Description: General description of the drug's class.

  • Parent_Drug_Class_Code

  • Data Type: STRING

  • Description: Code of the parent drug class in the hierarchy.

  • Drug_Package_Size

  • Data Type: STRING

  • Description: The size of the drug package, indicating quantity or volume.

  • Drug_Class_Lvl

  • Data Type: STRING

  • Description: Level of the drug's class in the classification hierarchy.

  • Visibility_Level

  • Data Type: STRING

  • Description: The level of visibility assigned to the drug for reporting or categorization purposes.

  • Effective_From_Timestamp

  • Data Type: TIMESTAMP

  • Description: Date and time when the drug's record became effective.

  • Created_User_ID

  • Data Type: STRING

  • Description: Identifier of the user who created the drug record.

  • Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the drug record was created.

  • Last_Modified_User_ID

  • Data Type: STRING

  • Description: Identifier of the user who last modified the drug record.

  • Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the drug record was last updated.

Dictionary_Drug_Type

Columns and Descriptions

  • Drug_Type_Code

  • Data Type: STRING

  • Description: A unique code representing the drug type.

  • Drug_Type_Description

  • Data Type: STRING

  • Description: A detailed description of the drug type, indicating its classification or usage category.

  • Effective_From_Timestamp

  • Data Type: TIMESTAMP

  • Description: The date and time from which the drug type record became effective.

  • Created_User_ID

  • Data Type: STRING

  • Description: The identifier of the user who created the drug type record.

  • Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the drug type record was created.

  • Last_Modified_User_ID

  • Data Type: STRING

  • Description: The identifier of the user who last modified the drug type record.

  • Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the drug type record was last updated.

Dictionary_Email_Type

Columns and Descriptions

  • Email_Type

  • Data Type: STRING

  • Description: Classification of email types (e.g., notification, communication).

  • Email_Type_Description

  • Data Type: STRING

  • Description: Explanation of the email type.

  • Effective_From_Timestamp

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Data Type: STRING

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

  • Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (D-L)

Dictionary Emmi Status

Column Name

Is Nullable

Data Type

Description

Emmi_Status

YES

STRING

Status related to electronic medical record exchange (e.g., sent, received).

Emmi_Status_Description

YES

STRING

Detailed description of the Emmi status.

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

Column Name

Is Nullable

Data Type

Description

Group_ID

YES

STRING

Identifier for a specific group or category.

Group_Name

YES

STRING

Name or label for the group.

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

Column Name

Is Nullable

Data Type

Description

Encounter_Class_Code

YES

STRING

A unique code representing the type or classification of the healthcare encounter.

Encounter_Class_Name

YES

STRING

The name or description of the encounter class, providing a clear identification of the type.

Effective_From_Timestamp

YES

TIMESTAMP

The date and time when the encounter class became effective and valid for use.

Created_User_ID

YES

STRING

The identifier of the user who created the record for the encounter class.

Created_Timestamp

YES

TIMESTAMP

The timestamp indicating when the encounter class record was created.

Last_Modified_User_ID

YES

STRING

The identifier of the user who last modified the encounter class record.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp indicating the last modification made to the encounter class record.

Dictionary Encounter Condition

Column Name

Is Nullable

Data Type

Description

Encounter_Condition_Code

YES

STRING

A unique code that identifies the encounter condition.

Encounter_Condition_Name

YES

STRING

The name of the encounter condition, providing a human-readable description.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp indicating when the encounter condition became effective.

Created_User_ID

YES

STRING

The identifier of the user who created the record for this encounter condition.

Created_Timestamp

YES

TIMESTAMP

The timestamp when the encounter condition record was created.

Last_Modified_User_ID

YES

STRING

The identifier of the user who last modified the record for this encounter condition.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when the encounter condition record was last updated.

Dictionary Encounter Priority

Column Name

Is Nullable

Data Type

Description

Encounter_Priority_Code

YES

STRING

A unique code representing the priority level of the encounter.

Encounter_Priority_Name

YES

STRING

The name of the encounter priority, providing a descriptive label for the priority level.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp indicating when the encounter priority became effective in the system.

Created_User_ID

YES

STRING

The identifier of the user who created the record for this encounter priority.

Created_Timestamp

YES

TIMESTAMP

The timestamp when the encounter priority record was created.

Last_Modified_User_ID

YES

STRING

The identifier of the user who last modified the record for this encounter priority.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when the encounter priority record was last updated.

Dictionary Encounter Service Type

Column Name

Is Nullable

Data Type

Description

Encounter_Service_Type_Code

YES

STRING

A unique code identifying the type of service associated with the encounter.

Encounter_Service_Type_Name

YES

STRING

The name of the service type for the encounter, providing a descriptive label.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp indicating when the service type became effective in the system.

Dictionary Dataset Specification (D-L)

Dictionary Encounter Service Type

Columns

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for this service type.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the service type record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the record for this service type.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the service type record was last updated.

Dictionary Encounter Status

Columns

  • Encounter_Status_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the status of an encounter.

  • Encounter_Status_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or label of the encounter status, providing a descriptive identifier.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the encounter status became effective in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for this encounter status.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the record for the encounter status was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the record for this encounter status.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the record for the encounter status was last updated.

Dictionary Enrollment Alert

Columns

  • Enrollment_Alert

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Alert related to enrollment or registration (e.g., missing information, eligibility issue).

  • Enrollment_Alert_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the enrollment 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 Enrollment Provider Role

Columns

  • Provider_Role

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Role or function of a healthcare provider (e.g., primary care physician, specialist).

  • Provider_Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the provider role.

  • 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 Episode Group

Columns

  • Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code identifying the episode group.

  • Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the episode group, providing a descriptive label for the group.

  • Clean_Period

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The period used to determine the time frame for grouping episodes (e.g., days or months).

  • Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing the type of episode group.

  • Type_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or description of the type of episode group.

  • SDC_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code linking the episode group to a specific Standardized Data Code (SDC).

  • SDC_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or description associated with the Standardized Data Code for the episode group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the episode group became effective in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the record for this episode group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the record for the episode group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the record for this episode group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the record for the episode group was last updated.

Dictionary External Population

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier code for the external population.

  • Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the external population, providing a descriptive label.

  • Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The origin or source of the external population data (e.g., system name or dataset).

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the external population data became effective in the system.

Dictionary Dataset Specification (D-L)

Dictionary_External_Population

Columns

  • estamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the external population record became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the external population record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the external population record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the external population record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the external population record was last updated.

Dictionary_External_Population_Source

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code identifying the external population source.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the external population source, providing context and clarity.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the external population source record became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the external population source record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the external population source record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the external population source record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the external population source record was last updated.

Dictionary_Gender

Columns

  • Gender

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification of individuals based on their biological sex.

  • Gender_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the gender 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_Goal

Columns

  • Goal

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific objective or target to achieve.

  • Goal_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the goal.

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

Columns

  • Goal_Focus

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Area of focus related to the goal (e.g., physical fitness, mental health).

  • Goal_Focus_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the goal focus.

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

Columns

  • Goal_Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Desired outcome resulting from achieving the goal (e.g., improved mobility, reduced pain).

  • Goal_Outcome_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the goal outcome.

  • Goal_Outcome_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category or group to which the goal outcome belongs.

  • 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 (D-L)

Dictionary_Goal_Outcome_Category

Column Name

Is Nullable

Data Type

Description

Goal_Outcome_Category

YES

STRING

Explanation of the goal outcome category.

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_Goal_Type

Column Name

Is Nullable

Data Type

Description

Goal_Type

YES

STRING

Type or nature of the goal (e.g., short-term, long-term, behavioral).

Goal_Type_Description

YES

STRING

Detailed description of the goal 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_HL7_Abnormal_Flags

Column Name

Is Nullable

Data Type

Description

Code

YES

STRING

A unique code representing an HL7 abnormal flag.

Description

YES

STRING

A detailed description of the HL7 abnormal flag, indicating its significance or usage context.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp indicating when the abnormal flag became effective for use.

Created_User_ID

YES

STRING

The identifier of the user who created the record for the abnormal flag.

Created_Timestamp

YES

TIMESTAMP

The timestamp when the abnormal flag record was created.

Last_Modified_User_ID

YES

STRING

The identifier of the user who last modified the abnormal flag record.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when the abnormal flag record was last updated.

Dictionary_Healthcare_Type

Column Name

Is Nullable

Data Type

Description

Healthcare_Type

YES

STRING

Type of healthcare.

Healthcare_Type_Description

YES

STRING

Description of the healthcare type.

Active

YES

STRING

Indicates if the healthcare type is active.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp when the healthcare type became effective.

Created_User_ID

YES

STRING

Identifier for the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp when the record was created.

Last_Modified_User_ID

YES

STRING

Identifier for the user who last modified the record.

Dictionary_Holiday_Schedule

Column Name

Is Nullable

Data Type

Description

Holiday_Date

YES

STRING

Date of a recognized holiday or observance.

Holiday_Description

YES

STRING

Description of the holiday or observance.

Active

YES

STRING

Indicator whether an item is currently active or inactive.

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_InterQualConnect_Review_Criteria_Met

Column Name

Is Nullable

Data Type

Description

Criteria_Met

YES

STRING

Indicator whether specific criteria have been met.

Criteria_Met_Description

YES

STRING

Detailed description of the criteria met.

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 Dataset Specification (D-L)

Dictionary InterQualConnect Review Outcome

Columns

  • Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Result or consequence of an action or process (e.g., successful enrollment, treatment outcome).

  • Outcome_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the outcome.

  • 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 InterQualConnect Review Product

Columns

  • Product

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific item, service, or offering (e.g., insurance plan, medication).

  • Product_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the product.

  • Product_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of product (e.g., health insurance, financial product).

  • 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 iExchange Group

Columns

  • iExchange_Group_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for a specific group within an exchange system.

  • iExchange_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label for the iExchange group.

  • 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 Interaction Disposition

Columns

  • Interaction_Disposition

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome or decision related to a specific interaction (e.g., call resolved, escalation).

  • Interaction_Disposition_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the interaction 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 Interaction Topic

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Short alphanumeric identifier or reference for an item (e.g., product code, category code).

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed explanation or label of the code.

  • 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 Interaction Topic Resolution

Columns

  • Resolution

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome or solution resulting from addressing an issue or problem (e.g., case resolved, issue closed).

  • Resolution_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the resolution.

  • 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 (D-L)

Dictionary_Interaction_Topic_Resolution

Columns

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Interaction_Type

Columns

  • Interaction_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of interaction (e.g., phone call, email, chat).

  • Interaction_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the interaction 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_Intervention

Columns

  • Intervention

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action or measure taken to address a specific issue or problem (e.g., counseling, medication adjustment).

  • Intervention_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the intervention.

  • Member_Engagement

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of engagement or involvement of a member in a program or service (e.g., high, moderate, low).

  • Member_Engagement_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the member engagement level.

  • Member_Engagement_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of member engagement (e.g., proactive, reactive).

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

Columns

  • LOINC_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for a LOINC code, representing a specific laboratory or clinical observation.

  • Component

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The component or analyte that the LOINC code refers to, such as "Glucose" or "Cholesterol."

  • Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The classification code for the LOINC term, grouping similar tests or observations.

  • Class_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of class for the LOINC code, indicating its category in the hierarchy.

  • Short_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A concise name for the LOINC code, commonly used in reporting or display systems.

  • Long_Common_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed, standardized name for the LOINC code, providing clarity on its meaning and use.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The visibility level of the LOINC code, indicating its relevance or accessibility in specific contexts.

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting range for a code set if the LOINC code is part of a series or range.

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending range for a code set if the LOINC code is part of a series or range.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The current status of the LOINC code, such as "Active" or "Deprecated."

  • Common_Test

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the LOINC code represents a commonly performed test.

  • Property

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The property of the observation, such as "Mass" or "Concentration," represented by the LOINC code.

  • Time

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The time aspect of the observation, such as "Point in time" or "24 hours."

  • System

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The system or specimen associated with the LOINC code, such as "Blood" or "Urine."

  • Scale

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The scale of measurement, such as "Quantitative" or "Ordinal."

  • Method

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The method used for the observation, if applicable, such as "EIA" or "Immunoassay."

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The set to which the LOINC code belongs, for grouping and categorization purposes.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version of the LOINC code, representing updates or revisions.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the LOINC code is currently active or inactive.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the LOINC code became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier 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 (D-L)

Dictionary_LOINC

Columns

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the LOINC code record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the LOINC code record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the LOINC code record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the LOINC code record was last updated.

Dictionary_LOINC_Class

Columns

  • Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the LOINC class, representing a grouping of related laboratory or clinical tests.

  • Class_Type_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the LOINC class type, categorizing the nature of tests or observations within the class.

  • Class_Type_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier for the type of class, enabling differentiation between similar categories.

  • Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the LOINC class, providing context and purpose for the grouped observations.

  • Class_Start

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting point or initial version of the LOINC class, if applicable.

  • Class_End

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending point or final version of the LOINC class, if applicable.

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The set of codes associated with the LOINC class, providing a reference for classification.

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The version of the code set, reflecting updates or revisions to the LOINC class.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the LOINC class is currently active (TRUE) or inactive (FALSE).

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the LOINC class became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the LOINC class record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the LOINC class record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the LOINC class record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the last modification made to the LOINC class record.

Dictionary_Lab_Result_Interpretation

Columns

  • Input

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The input value or code representing a specific laboratory result interpretation.

  • Output

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The output value or translated result corresponding to the input, providing standardized interpretation.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the interpretation mapping became effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the interpretation mapping record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the last modification made to the interpretation mapping record.

Dictionary_Language

Columns

  • Language

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific language used for communication or documentation (e.g., English, Spanish).

  • Language_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the language.

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

Columns

  • Length_Of_Stay_Unit_Of_Measure

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unit of measurement for length of stay (e.g., days, hours).

  • Length_Of_Stay_Unit_Of_Measure_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the length of stay unit of measure.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Letter_Action

Columns

  • Letter_Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action associated with a letter (e.g., send, archive, review).

  • Letter_Action_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the letter action.

Dictionary Dataset Specification (D-L)

Dictionary_Letter_Action

Columns

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Letter_Class

Columns

  • Letter_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification or category of letters (e.g., medical, administrative).

  • Letter_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the letter 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_Letter_Status

Columns

  • Letter_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of a letter (e.g., drafted, sent, received).

  • Letter_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the letter 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_Letter_Type

Columns

  • Letter_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or purpose of a letter (e.g., appointment reminder, denial notice).

  • Letter_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the letter 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_Line_Of_Business

Columns

  • Line_Of_Business

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific business line or area (e.g., health insurance, dental coverage).

  • Line_Of_Business_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the line of business.

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

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the link.

  • Link_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the link.

  • Link_URL

  • Is Nullable: YES

  • Data Type: STRING

  • Description: URL of the link.

  • Link_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the link.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the link is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the link 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.

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