Skip to main content

Dictionary Dataset Specification M Q

Updated over 5 months ago

Dictionary Dataset Specification M Q

Dictionary Dataset Specification (M-Q)

Dictionary MEG Malignancy

Table Name: Dictionary_MEG_Malignancy

Columns:

  • Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code assigned to represent a specific malignancy group.

  • Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the malignancy group.

  • Disease_Stage

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The stage of the disease within the malignancy group.

  • Disease_Stage_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the disease stage.

  • Health_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An indicator of the overall health status associated with this malignancy group and stage.

  • Episode_Group_Assignment

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The assignment of this malignancy to a specific episode group for treatment or tracking purposes.

  • Clean_Period

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The period of time required after treatment during which no symptoms are present to consider the condition resolved.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this malignancy entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this malignancy entry is currently active or in use.

Dictionary MEG Provider Type Crosswalk

Table Name: Dictionary_MEG_Provider_Type_Crosswalk

Columns:

  • Meg_Provider_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing a provider type crosswalk.

Dictionary Marital Status

(Content for this section is not provided in the input.)

Dictionary Medical Policy Category

(Content for this section is not provided in the input.)

Dictionary Member Alert

(Content for this section is not provided in the input.)

Dictionary Member Alternate ID

(Content for this section is not provided in the input.)

Dictionary Member Alternate ID Type

(Content for this section is not provided in the input.)

Dictionary Member Contact Association

(Content for this section is not provided in the input.)

Dictionary Member Engagement Status

(Content for this section is not provided in the input.)

Dictionary Member Engagement Type

(Content for this section is not provided in the input.)

Dictionary Member Enrollment Alert

(Content for this section is not provided in the input.)

Dictionary Monitor Rule

(Content for this section is not provided in the input.)

Dictionary Not Enrolled Reason

(Content for this section is not provided in the input.)

Dictionary Note Type

(Content for this section is not provided in the input.)

Dictionary Note Void Reason

(Content for this section is not provided in the input.)

Dictionary Opportunity Score Health Status Category

(Content for this section is not provided in the input.)

Dictionary Opportunity Score Health Status Category Crosswalk

(Content for this section is not provided in the input.)

Dictionary Opportunity Score Lab Ranges Crosswalk

(Content for this section is not provided in the input.)

Dictionary Opportunity Score Populations Crosswalk

(Content for this section is not provided in the input.)

Dictionary Opportunity Score Rule

(Content for this section is not provided in the input.)

Dictionary Opportunity Score Weighting Values

(Content for this section is not provided in the input.)

Dictionary Outcome Reason

(Content for this section is not provided in the input.)

Dictionary Outcome Status

(Content for this section is not provided in the input.)

Dictionary Outcome Status Outcome Reason Mapping

(Content for this section is not provided in the input.)

Dictionary Overall Request Status

(Content for this section is not provided in the input.)

Dictionary Participating Network Status

(Content for this section is not provided in the input.)

Dictionary Penalty

(Content for this section is not provided in the input.)

Dictionary Permissions Criteria Operator

(Content for this section is not provided in the input.)

Dictionary Permissions Element

(Content for this section is not provided in the input.)

Dictionary Permissions Element Class

(Content for this section is not provided in the input.)

Dictionary Pft Dx Icd10

(Content for this section is not provided in the input.)

Dictionary Phone Type

(Content for this section is not provided in the input.)

Dictionary Place Of Service

(Content for this section is not provided in the input.)

Dictionary Place Of Service CMS

(Content for this section is not provided in the input.)

Dictionary Plan

(Content for this section is not provided in the input.)

Dictionary Point Service Vendor

(Content for this section is not provided in the input.)

Dictionary Population

(Content for this section is not provided in the input.)

Dictionary Population Type

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Account

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Carrier Code

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Client Code

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Condition

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Diagnosis

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Discharge Code

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Drug

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Encounter Class

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Encounter Condition

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Encounter Priority

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Encounter Service Type

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Group

(Content for this section is not provided in the input.)

Dictionary Predefined Groups LOINC

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Line Of Business

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Place Of Service

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Plan

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Program

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Provider Specialty

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Provider Specialty Taxonomy

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Revenue Code

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Service

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Service Modifier

(Content for this section is not provided in the input.)

Dictionary Predefined Groups Subclient

(Content for this section is not provided in the input.)

Dictionary Preferred Contact Method

(Content for this section is not provided in the input.)

Dictionary Preferred Contact Time

(Content for this section is not provided in the input.)

Dictionary Prescription Origin

(Content for this section is not provided in the input.)

Dictionary Primary Service Vendor Contacts

(Content for this section is not provided in the input.)

Dictionary Priority

(Content for this section is not provided in the input.)

Dictionary Problem

(Content for this section is not provided in the input.)

Dictionary Problem Outcome

(Content for this section is not provided in the input.)

Dictionary Problem Outcome Category

(Content for this section is not provided in the input.)

Dictionary Problem Status

(Content for this section is not provided in the input.)

Dictionary Product

(Content for this section is not provided in the input.)

Dictionary Product Program Mapping

(Content for this section is not provided in the input.)

Dictionary Program

(Content for this section is not provided in the input.)

Dictionary Program Close Reason

(Content for this section is not provided in the input.)

Dictionary Program Provider Role

(Content for this section is not provided in the input.)

Dictionary Program Reopen Reason

(Content for this section is not provided in the input.)

Dictionary Program Screening Status

(Content for this section is not provided in the input.)

Dictionary Program Severity

(Content for this section is not provided in the input.)

Dictionary Program Source

(Content for this section is not provided in the input.)

Dictionary Provider Alternate ID

(Content for this section is not provided in the input.)

Dictionary Provider Alternate ID Type

(Content for this section is not provided in the input.)

Dictionary Provider Contact Association

(Content for this section is not provided in the input.)

Dictionary Provider Network

(Content for this section is not provided in the input.)

Dictionary Provider Set Code

(Content for this section is not provided in the input.)

Dictionary Provider Specialty

(Content for this section is not provided in the input.)

Dictionary Provider Specialty Crosswalk

(Content for this section is not provided in the input.)

Dictionary Provider Specialty Taxonomy

(Content for this section is not provided in the input.)

Dictionary Provider Specialty Type

(Content for this section is not provided in the input.)

Dictionary Provider Type

(Content for this section is not provided in the input.)

Dictionary Provider Type Crosswalk

(Content for this section is not provided in the input.)

Dictionary Questionnaire Access Point

(Content for this section is not provided in the input.)

Dictionary Questionnaire Class

(Content for this section is not provided in the input.)

Dictionary Questionnaire Review Edit Reason

(Content for this section is not provided in the input.)

Dictionary RX Patient Relation

(Content for this section is not provided in the input.)

Dictionary Race

(Content for this section is not provided in the input.)

Dictionary Request Urgency

(Content for this section is not provided in the input.)

Dictionary Revenue Code

(Content for this section is not provided in the input.)

Dictionary Risk Score Type

(Content for this section is not provided in the input.)

Dictionary Service CPT4

(Content for this section is not provided in the input.)

Dictionary Service HCPCS

(Content for this section is not provided in the input.)

Dictionary Service ICD10

(Content for this section is not provided in the input.)

Dictionary Service ICD9

(Content for this section is not provided in the input.)

Dictionary Service Introducer

(Content for this section is not provided in the input.)

Dictionary Service Modifier CPT4

(Content for this section is not provided in the input.)

Dictionary Service Modifier HCPCS

(Content for this section is not provided in the input.)

Dictionary Service Setting Code

(Content for this section is not provided in the input.)

Dictionary Source Of Payment Typology

(Content for this section is not provided in the input.)

Dictionary State Province

(Content for this section is not provided in the input.)

Dictionary Subclient

(Content for this section is not provided in the input.)

Dictionary System Source Table Name Column Name Is Nullable Data Type Description

(Content for this section is not provided in the input.)

Dictionary Dataset Specification (M-Q)

Dictionary_MEG_Provider_Type_Crosswalk

Columns

  • Med_Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing a corresponding medical specialty.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this crosswalk entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Marital_Status

Columns

  • Marital_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Legal or social status related to marriage (e.g., single, married, divorced).

  • Marital_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the marital 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_Medical_Policy_Category

Columns

  • Medical_Policy_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code identifying the medical policy.

  • Medical_Policy_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the medical policy.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the medical policy is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which the medical policy 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_Member_Alert

Columns

  • Alert

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier representing a specific alert related to a member in the medical system.

  • Alert_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed explanation of the alert, describing the reason or context in which the alert is raised.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the alert became effective or started being applicable to the member.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who initially created the alert entry in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the alert was first created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the alert is currently active or in use for the member.

Dictionary_Member_Alternate_ID

Columns

  • Alternate_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code that serves as an alternate or secondary ID for the member.

  • Alternate_ID_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description or explanation of the purpose or use of the alternate ID for the member.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the alternate ID becomes effective for the member.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who initially created the alternate ID entry in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the alternate ID was first created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the alternate ID entry in the system.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the alternate ID was last updated or modified.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the alternate ID is currently active or in use for the member.

Dictionary_Member_Alternate_ID_Type

Columns

  • Alternate_ID_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of alternate identifier (e.g., social security number, driver’s license).

  • Alternate_ID_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the alternate identifier type.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (M-Q)

Dictionary_Member_Contact_Association

Columns

  • Contact_Association

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Relationship or association between contacts (e.g., emergency contact, primary contact).

  • Contact_Association_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the contact association.

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

Columns

  • Member_Engagement_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current engagement status of a member (e.g., active, inactive, engaged).

  • Member_Engagement_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the member engagement 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_Member_Engagement_Type

Columns

  • Member_Engagement_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Member_Engagement_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the member engagement 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_Member_Enrollment_Alert

Columns

  • Enrollment_Alert

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier for the enrollment alert, indicating a specific condition or status related to a member's enrollment.

  • Enrollment_Alert_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the enrollment alert, explaining the nature or purpose of the alert.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the enrollment alert becomes active and applicable.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who initially created the enrollment alert entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the enrollment alert entry was first created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the enrollment alert is currently active and in use.

Dictionary_Monitor_Rule

Columns

  • Monitor_Rule_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key or identifier for a monitoring rule.

  • Monitor_Rule_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label for the monitoring rule.

  • Active

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the rule 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_Not_Enrolled_Reason

Columns

  • Not_Enrolled_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for a member not being enrolled in a specific program or service.

  • Not_Enrolled_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the reason for non-enrollment.

  • 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 (M-Q)

Dictionary_Note_Type

Columns

  • Note_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of note (e.g., clinical, administrative).

  • Note_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Note_Type_Domain

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Domain the note type belongs to.

Dictionary_Note_Void_Reason

Columns

  • Note_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding or canceling a note.

  • Note_Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the note void reason.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Opportunity_Score_Health_Status_Category

Columns

  • Episode_Group

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The group or category of the medical episode.

  • Disease_Stage

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The stage of the disease within the episode group.

  • Health_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An indicator of the overall health status associated with this category.

  • Start_Days

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The starting day of the time range for this health status category.

  • End_Days

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ending day of the time range for this health status category.

  • Category_Desc

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the health status category.

  • Category_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code assigned to represent the health status category.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this health status category entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this health status category entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this health status category entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this health status category entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this health status category entry was last modified.

Dictionary_Opportunity_Score_Health_Status_Category_Crosswalk

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing a specific health status category in the opportunity score system.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the health status category.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this crosswalk entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Opportunity_Score_Lab_Ranges_Crosswalk

Columns

  • ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for this lab range entry in the opportunity score system.

  • Lab_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier for the specific lab test associated with this range.

  • Comment

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional notes or comments about this lab range.

  • Lower_Range

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The lower boundary of the lab value range.

  • Upper_Range

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The upper boundary of the lab value range.

  • Units

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The units of measurement for the lab values.

  • Score

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The opportunity score associated with this lab range.

  • Overriding_Lab_Rules

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Any special rules that override standard scoring for this lab range.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this lab range entry became or will become effective.

Dictionary Dataset Specification (M-Q)

Dictionary Opportunity Score Lab Ranges Crosswalk

Columns

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this lab range entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this lab range entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this lab range entry was last modified.

Dictionary Opportunity Score Populations Crosswalk

Columns

  • Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The category or group of the population being scored.

  • Rule_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier for the specific rule applied to this population category.

  • Score

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The opportunity score associated with this population category and rule.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this population crosswalk entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this population crosswalk entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this population crosswalk entry was last modified.

Dictionary Opportunity Score Rule

Columns

  • Rule_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for the opportunity score rule.

  • Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the rule.

  • Health_Status_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The health status category to which this rule applies.

  • Low_Range

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The lower boundary of the range for which this rule is applicable.

  • High_Range

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The upper boundary of the range for which this rule is applicable.

  • Product

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The product or service associated with this rule.

  • Program_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code of the program to which this rule belongs.

  • Rule_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type or category of the rule.

  • Score_Indicator

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An indicator of how this rule affects the overall score.

  • Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag or marker associated with this rule.

  • Severity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The severity level assigned to this rule.

  • Rule_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The category or group to which this rule belongs.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this rule became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this rule was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Opportunity Score Weighting Values

Columns

  • Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or identifier of the weighting factor.

  • Weight

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The numerical weight assigned to this factor in the opportunity score calculation.

  • Minimum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The minimum allowed value for this weighting factor.

  • Maximum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The maximum allowed value for this weighting factor.

  • Default_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The default value used for this weighting factor if no specific value is provided.

  • Round_On_Point_Five

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the value should be rounded to the nearest 0.5.

  • ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for this weighting value entry.

  • Base_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The base value used in calculations involving this weighting factor.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this weighting value entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this weighting value entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this weighting value entry was last modified.

Dictionary Outcome Reason

Columns

  • Outcome_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for a specific outcome (e.g., claim denial, treatment success).

  • Outcome_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the outcome reason.

Dictionary Dataset Specification (M-Q)

Dictionary Outcome Reason

Columns

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

Columns

  • Outcome_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of a specific outcome (e.g., achieved, pending).

  • Outcome_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the outcome status.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Outcome Status Outcome Reason Mapping

Columns

  • Outcome_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The status of the outcome of the appeal process.

  • Outcome_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The reason for the outcome status.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the outcome record is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which the outcome 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 Overall Request Status

Columns

  • Overall_Request_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Overall status of a request or process (e.g., approved, denied, pending).

  • Overall_Request_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the overall request 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 Participating Network Status

Columns

  • Participating_Network_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status related to network participation (e.g., in-network, out-of-network).

  • Participating_Network_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the participating network 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 Penalty

Columns

  • Penalty

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Consequence or fine imposed due to non-compliance or violation (e.g., late payment penalty).

  • Penalty_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the penalty.

  • 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 Permissions Criteria Operator

Columns

  • Permissions_Criteria_Operator

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Operator used in permissions criteria (e.g., AND, OR).

  • Permissions_Criteria_Operator_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the permissions criteria operator.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Dictionary Dataset Specification (M-Q)

Dictionary_Permissions_Criteria_Operator

Columns

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Permissions_Element

Columns

  • Permissions_Element

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents an element or component for which permissions are defined.

  • Permissions_Element_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the permissions element.

  • Permissions_Element_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification or category of the permissions element.

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

Columns

  • Permissions_Element_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification or category of the permissions element.

  • Permissions_Element_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the permissions element 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_Pft_Dx_Icd10

Columns

  • Display_Term_Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text to display for the term.

  • Term_Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Actual term text.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the term 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_Phone_Type

Columns

  • Phone_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of phone number (e.g., mobile, home, work).

  • Phone_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Columns

  • Place_Of_Service

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific location or setting where a service is provided (e.g., hospital, clinic, home).

  • Place_Of_Service_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the place of service.

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

Columns

  • Service_Place_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code assigned by CMS to represent a specific place of service.

  • Service_Place_Desc

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the place of service.

  • Service_Setting_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing the broader service setting category.

  • Service_Setting_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the service setting category.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this place of service entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this place of service entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this place of service entry was last modified.

Dictionary Dataset Specification (M-Q)

Dictionary_Plan

Columns

  • Plan_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for a specific health insurance plan.

  • Plan_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the health insurance plan.

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

Columns

  • vendorCode

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code assigned to identify a specific point of service vendor.

  • vendorCodeDescription

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the vendor associated with the vendor code.

  • vendorLink

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A URL or reference link to the vendor's website or additional information.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this vendor entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Population

Columns

  • Population_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for a specific population group or category.

  • Population_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Descriptive name or label for the population group.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the current status of the population (e.g., active, inactive, pending).

  • Parent_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of parent entity associated with this population (e.g., organization, region, etc.).

  • Parent_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the parent entity (e.g., organization ID, region ID).

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

Columns

  • Rep_Rule_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing a specific population type or representation rule.

  • Rep_Rule_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the population type or representation rule.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Predefined_Groups_Account

Columns

  • Predefined_Account_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing a predefined group of accounts.

  • Predefined_Account_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the predefined account group.

  • Predefined_Account_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the predefined account group.

  • Account_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific account code associated with this group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this predefined account group entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this predefined account group entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined account group entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this predefined account group entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined account group entry was last modified.

Dictionary_Predefined_Groups_Carrier_Code

Columns

  • Predefined_Carrier_Code_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the predefined carrier code group.

  • Predefined_Carrier_Code_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined carrier code group.

  • Predefined_Carrier_Code_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined carrier code group.

  • Carrier_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the carrier.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this predefined carrier code group entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this predefined carrier code group entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined carrier code group entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this predefined carrier code group entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined carrier code group entry was last modified.

Dictionary Dataset Specification (M-Q)

Dictionary_Predefined_Groups_Carrier_Code

Columns

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the predefined carrier code group 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_Predefined_Groups_Client_Code

Columns

  • Predefined_Client_Code_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the predefined client code group.

  • Predefined_Client_Code_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined client code group.

  • Predefined_Client_Code_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined client code group.

  • Client_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the client.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the predefined client code group 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_Predefined_Groups_Condition

Columns

  • Predefined_Condition_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing a predefined group of medical conditions.

  • Predefined_Condition_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the predefined condition group.

  • Predefined_Condition_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the predefined condition group.

  • Condition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific condition code associated with this group.

  • Subcondition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A subcategory or more specific code within the condition code.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this predefined condition group entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this predefined condition group entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined condition group entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this predefined condition group entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined condition group entry was last modified.

Dictionary_Predefined_Groups_Diagnosis

Columns

  • Predefined_Diagnosis_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing a predefined group of diagnoses.

  • Predefined_Diagnosis_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the predefined diagnosis group.

  • Predefined_Diagnosis_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the predefined diagnosis group.

  • Diagnosis_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific diagnosis code associated with this group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this predefined diagnosis group entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this predefined diagnosis group entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined diagnosis group entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this predefined diagnosis group entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined diagnosis group entry was last modified.

Dictionary_Predefined_Groups_Discharge_Code

Columns

  • Predefined_Discharge_Code_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of discharge codes.

  • Predefined_Discharge_Code_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of discharge codes.

  • Predefined_Discharge_Code_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group of discharge codes and its purpose.

  • Condition_Scheme_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the condition or scheme associated with the discharge group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined discharge group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined discharge code group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined discharge code group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined discharge code group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined discharge code group was last modified.

Dictionary Dataset Specification (M-Q)

Dictionary_Predefined_Groups_Drug

Columns

  • Predefined_Drug_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of drugs.

  • Predefined_Drug_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of drugs.

  • Predefined_Drug_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined drug group and its purpose or characteristics.

  • GPI2_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Two-character GPI (Generic Product Identifier) code representing a high-level drug group.

  • GPI4_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Four-character GPI code providing a more specific classification of drugs within a group.

  • GPI6_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Six-character GPI code providing a detailed classification of drugs.

  • GPI10_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Ten-character GPI code offering the most specific classification of a drug.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined drug group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined drug group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined drug group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined drug group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined drug group was last updated.

Dictionary_Predefined_Groups_Encounter_Class

Columns

  • Predefined_Encounter_Class_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of encounter classes.

  • Predefined_Encounter_Class_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of encounter classes.

  • Predefined_Encounter_Class_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined encounter class group and its purpose or characteristics.

  • Encounter_Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific encounter class within the group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter class group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined encounter class group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter class group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined encounter class group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter class group was last updated.

Dictionary_Predefined_Groups_Encounter_Condition

Columns

  • Predefined_Encounter_Condition_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of encounter conditions.

  • Predefined_Encounter_Condition_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of encounter conditions.

  • Predefined_Encounter_Condition_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group of encounter conditions and its purpose.

  • Encounter_Condition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific encounter condition within the group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter condition group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined encounter condition group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter condition group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined encounter condition group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter condition group was last updated.

Dictionary_Predefined_Groups_Encounter_Priority

Columns

  • Predefined_Encounter_Priority_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of encounter priorities.

  • Predefined_Encounter_Priority_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of encounter priorities.

  • Predefined_Encounter_Priority_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group of encounter priorities and its purpose.

  • Encounter_Priority_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific encounter priority within the group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter priority group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined encounter priority group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter priority group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined encounter priority group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter priority group was last updated.

Dictionary Dataset Specification (M-Q)

Dictionary_Predefined_Groups_Encounter_Priority

Columns

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter priority group was last updated.

Dictionary_Predefined_Groups_Encounter_Service_Type

Columns

  • Predefined_Encounter_Service_Type_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of encounter service types.

  • Predefined_Encounter_Service_Type_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of encounter service types.

  • Predefined_Encounter_Service_Type_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group of encounter service types and its purpose.

  • Encounter_Service_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific encounter service type within the group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter service type group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined encounter service type group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter service type group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined encounter service type group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter service type group was last updated.

Dictionary_Predefined_Groups_Group

Columns

  • Predefined_Group_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of groups.

  • Predefined_Group_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of groups.

  • Predefined_Group_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group of groups and its purpose.

  • Group_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for a specific group within the predefined group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined group of groups becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined group of groups.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined group of groups was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined group of groups.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined group of groups was last updated.

Dictionary_Predefined_Groups_LOINC

Columns

  • Predefined_Test_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of tests.

  • Predefined_Test_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of tests.

  • Predefined_Test_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group of tests and its intended purpose.

  • Test_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a specific test within the predefined group, typically based on LOINC.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined group of tests becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined group of tests.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined group of tests was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined group of tests.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined group of tests was last updated.

Dictionary_Predefined_Groups_Line_Of_Business

Columns

  • Predefined_LOB_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group for a Line of Business (LOB).

  • Predefined_LOB_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined Line of Business (LOB) group.

  • Predefined_LOB_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group related to the Line of Business, outlining its purpose and scope.

  • LOB_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code for the specific Line of Business (LOB) within the predefined group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined LOB group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined LOB group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined LOB group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined LOB group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined LOB group was last modified.

Dictionary_Predefined_Groups_Place_Of_Service

Columns

  • Predefined_Service_Place_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined place of service group.

  • Predefined_Service_Place_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined place of service group.

  • Predefined_Service_Place_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined place of service group and its purpose.

  • Service_Place_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific place of service within the group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined place of service group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined place of service group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined place of service group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined place of service group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined place of service group was last updated.

Dictionary Dataset Specification (M-Q)

Dictionary_Predefined_Groups_Place_Of_Service

Columns

  • ce_Place_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined place of service group.

  • Predefined_Service_Place_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined place of service, outlining its function or classification.

  • Service_Setting_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing the service setting within the predefined service place.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined place of service group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined service place group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined service place group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined service place group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined service place group was last modified.

Dictionary_Predefined_Groups_Plan

Columns

  • Predefined_Plan_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined plan group.

  • Predefined_Plan_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined plan group.

  • Predefined_Plan_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined plan group, outlining its purpose or classification.

  • Plan_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing the specific plan associated with the predefined plan group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined plan group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined plan group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined plan group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined plan group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined plan group was last modified.

Dictionary_Predefined_Groups_Program

Columns

  • Predefined_Program_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined program group.

  • Predefined_Program_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined program group.

  • Predefined_Program_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined program group, outlining its purpose or classification.

  • Program_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing the specific program associated with the predefined program group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined program group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined program group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined program group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined program group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined program group was last modified.

Dictionary_Predefined_Groups_Provider_Specialty

Columns

  • Provider_Specialty_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing a group of specialties provided by a healthcare provider.

  • Provider_Specialty_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name associated with the group of specialties that the provider offers.

  • Provider_Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider's specialty group, explaining the type of services or care that fall under the specialty.

  • Provider_Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code assigned to a specific medical specialty or service provided by the healthcare provider.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the date and time when the provider specialty information becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the record for the provider specialty group in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the record for the provider specialty group 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 record for the provider specialty group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the record for the provider specialty group was last modified.

Dictionary_Predefined_Groups_Provider_Specialty_Taxonomy

Columns

  • Provider_Specialty_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing a predefined group of provider specialties.

  • Provider_Specialty_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the predefined provider specialty group.

  • Provider_Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider specialty group.

Dictionary Dataset Specification (M-Q)

Dictionary_Predefined_Groups_Provider_Specialty_Taxonomy

Provider_Specialty_Taxonomy

  • Column Name: Provider_Specialty_Taxonomy

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific provider specialty code associated with this group.

Effective_From_Timestamp

  • Column Name: Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this predefined provider specialty group entry became or will become effective.

Created_User_ID

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this predefined provider specialty group entry.

Created_Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined provider specialty group entry was created.

Last_Modified_User_ID

  • Column Name: Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this predefined provider specialty group entry.

Last_Modified_Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined provider specialty group entry was last modified.

Dictionary_Predefined_Groups_Revenue_Code

Predefined_Revenue_Code_Group_Code

  • Column Name: Predefined_Revenue_Code_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing a group of related revenue codes in the healthcare billing system.

Predefined_Revenue_Code_Group_Name

  • Column Name: Predefined_Revenue_Code_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name associated with the group of revenue codes.

Predefined_Revenue_Code_Group_Description

  • Column Name: Predefined_Revenue_Code_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description explaining the specific group of revenue codes, which are used to classify and track healthcare services for billing purposes.

Revenue_Code

  • Column Name: Revenue_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code used to represent a specific medical service or procedure for billing and insurance purposes.

Effective_From_Timestamp

  • Column Name: Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the date and time when the revenue code group becomes effective in the system.

Created_User_ID

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the revenue code group record in the system.

Created_Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Column Name: Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the revenue code group record in the system.

Last_Modified_Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the revenue code group record was last modified in the system.

Dictionary_Predefined_Groups_Service

Predefined_Service_Group_Code

  • Column Name: Predefined_Service_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for a predefined group of related healthcare services or procedures.

Predefined_Service_Group_Name

  • Column Name: Predefined_Service_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name associated with the group of services, used to categorize a set of related medical procedures or services within the system.

Predefined_Service_Group_Description

  • Column Name: Predefined_Service_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description providing further detail on the services included in the predefined group, explaining the purpose or scope of the services within the group.

Service_Code

  • Column Name: Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code that identifies a specific medical service or procedure within the healthcare system.

Effective_From_Timestamp

  • Column Name: Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the date and time when the predefined service group became active or effective in the system.

Created_User_ID

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the predefined service group record in the system.

Created_Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Column Name: Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the predefined service group record in the system.

Last_Modified_Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the predefined service group record was last modified in the system.

Dictionary_Predefined_Groups_Service_Modifier

Predefined_Service_Modifier_Group_Code

  • Column Name: Predefined_Service_Modifier_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for a predefined group of service modifiers, which are codes that modify or further specify the nature of a service or procedure in the healthcare system.

Predefined_Service_Modifier_Group_Name

  • Column Name: Predefined_Service_Modifier_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name assigned to the predefined group of service modifiers, used for categorizing and grouping related service modifications within the system.

Predefined_Service_Modifier_Group_Description

  • Column Name: Predefined_Service_Modifier_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description that provides details on the group of service modifiers, explaining the context or purpose of the modifiers within the predefined group.

Service_Modifier_Code

  • Column Name: Service_Modifier_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code that uniquely identifies a specific service modifier within the healthcare system, which adjusts or specifies a procedure's details or conditions.

Effective_From_Timestamp

  • Column Name: Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the exact date and time when the predefined service modifier group became active or effective in the system.

Created_User_ID

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the predefined service modifier group record was created within the system.

Dictionary Dataset Specification (M-Q)

Dictionary Predefined Groups Service Modifier

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the predefined service modifier group record in the system.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the most recent modification made to the predefined service modifier group record in the system.

Dictionary Predefined Groups Subclient

Predefined_Subclient_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for a predefined group of subclients, which are typically smaller subdivisions or entities under a main client or program in the system.

Predefined_Subclient_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name assigned to the predefined group of subclients, used to categorize or label different subclients within the system.

Predefined_Subclient_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description that provides details about the predefined group of subclients, explaining the context or purpose of the group within the organization or system.

Subclient_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code that identifies a specific subclient within the broader program or client group, enabling specific tracking or management of subclient activities or services.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp that marks the date and time when the predefined subclient group became active or effective within the system.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the predefined subclient group record in the system.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the predefined subclient group record was created within the system.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the predefined subclient group record in the system.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the predefined subclient group record was last modified in the system.

Dictionary Preferred Contact Method

Method

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Approach or technique used to accomplish a task or process (e.g., payment method, communication method).

Method_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the method.

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 Preferred Contact Time

Time

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a specific point in time for making a contact.

Time_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the time parameter.

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

Origin_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Origin_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Primary Service Vendor Contacts

Vendor_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier assigned to the primary service vendor.

Vendor_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description or name associated with the primary service vendor code.

Vendor_Phone

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Contact phone number for the primary service vendor.

Vendor_Email

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Contact email address for the primary service vendor.

Dictionary Dataset Specification (M-Q)

Dictionary_Primary_Service_Vendor_Contacts

Fields

  • Vendor_Link

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Link for the primary service vendor.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which this vendor contact information is effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who initially created the vendor contact record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Priority

Fields

  • Priority

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of importance or urgency (e.g., high, medium, low).

  • Priority_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the priority.

  • Priority_Rank

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Numeric ranking of the priority level.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Problem

Fields

  • Problem

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specific issue, challenge, or concern.

  • Problem_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the problem.

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

Fields

  • Problem_Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Result or resolution related to addressing a problem (e.g., issue resolved, workaround applied).

  • Problem_Outcome_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the problem outcome.

  • Problem_Outcome_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Category or group to which the problem 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_Problem_Outcome_Category

Fields

  • Problem_Outcome_Category

  • Is Nullable: YES

  • Data Type: STRING

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

  • Problem_Outcome_Category_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Fields

  • Problem_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status or condition related to a specific problem (e.g., open, resolved, pending).

  • Problem_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Fields

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

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

Dictionary Dataset Specification (M-Q)

Dictionary_Product

Columns

  • MP

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

Columns

  • Product

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The product associated with the program, typically referring to a healthcare service, plan, or item.

  • Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The program linked to the product, often representing an initiative or medical service offered under the product.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the product-to-program mapping is currently active and in use.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the product-to-program mapping becomes valid or effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the product-to-program mapping entry in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the product-to-program mapping entry was first created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the product-to-program mapping entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the product-to-program mapping entry was last updated or modified.

Dictionary_Program

Columns

  • Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier or code for a specific program.

  • Program_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the program.

  • Program_Alias

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An alternative name or shorthand for the program.

  • Status_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing the current status of the program.

  • Status_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or description of the program's status.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code indicating the visibility level of the program.

  • Visibility_Level_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or description of the program's visibility level.

  • Designation_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing any special designation for the program.

  • Designation_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or description of the program's designation.

  • Program_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing the type of program.

  • Program_Type_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or description of the program type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this program entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Program_Close_Reason

Columns

  • Program_Close_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for closing or terminating a program (e.g., completion, inactivity).

  • Program_Close_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the program close reason.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Program_Provider_Role

Columns

  • Program_Provider_Role

  • Is Nullable: YES

  • Data Type: STRING

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

  • Program_Provider_Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the program provider role.

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

Columns

  • Program_Reopen_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for reopening a previously closed program (e.g., new information, member request).

  • Program_Reopen_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the program reopen reason.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (M-Q)

Dictionary_Program_Reopen_Reason

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_Program_Screening_Status

Columns

  • Program_Screening_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status related to program screening or eligibility assessment (e.g., screened, pending).

  • Program_Screening_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the program screening 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_Program_Severity

Columns

  • Program_Severity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of severity or impact associated with a program (e.g., low, moderate, high).

  • Program_Severity_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the program severity.

  • Program_Export_Severity_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code used for exporting or identifying the program severity in external systems or reporting processes.

  • Minimum_Stage_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The minimum stage or value of the program associated with this severity level, possibly reflecting an early phase.

  • Maximum_Stage_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The maximum stage or value of the program within this severity level, representing the most advanced phase covered.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the program severity is currently active and in use (active/inactive 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_Program_Source

Columns

  • Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Origin or source of specific data or information (e.g., member portal, claims data).

  • Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the data source.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Provider_Alternate_ID

Columns

  • Alternate_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An alternative identifier used for providers.

  • Alternate_ID_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the alternate provider ID type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this alternate provider ID entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this alternate provider ID entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this alternate provider ID entry was last modified.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this alternate provider ID type is currently active or in use.

Dictionary_Provider_Alternate_ID_Type

Columns

  • Alternate_ID_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of alternate identifier (e.g., social security number, driver’s license).

  • Alternate_ID_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the alternate identifier 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_Provider_Contact_Association

Columns

  • Contact_Association

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Relationship or association between the provider and the contact.

Dictionary Dataset Specification (M-Q)

Dictionary Provider Contact Association

Columns and Descriptions

  • Contact_Association_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the contact association.

  • 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 Provider Network

Columns and Descriptions

  • Network_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific network or provider group.

  • Network_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label for the network.

  • 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 Provider Set Code

Columns and Descriptions

  • Set_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier or code for a specific set or group (e.g., benefit set, service set).

  • Set_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the set 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 Provider Specialty

Columns and Descriptions

  • Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code used to identify the provider's specialty, such as cardiology, pediatrics, or surgery.

  • Specialty_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A classification of the type of specialty, indicating the category or field within healthcare to which the specialty belongs.

  • Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider’s specialty, providing additional information about the specific focus area.

  • Patient_Centered_Medical_Home_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the specialty is part of a Patient-Centered Medical Home (PCMH) model, which emphasizes coordinated care.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Defines the level of visibility or access permissions for the specialty information, potentially limiting who can view it.

  • ACTIVE

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this provider specialty is currently active or in use.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the provider’s specialty designation becomes valid or effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the entry for the provider’s specialty in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the provider’s specialty entry was first created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the provider’s specialty entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the provider’s specialty entry was last updated or modified.

Dictionary Provider Specialty Crosswalk

Columns and Descriptions

  • Taxonomy_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Taxonomy_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Insights_Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Insights_Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Crosswalk_Priority

  • Is Nullable: YES

  • Data Type: STRING

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

  • CMS_Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • CMS_Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the crosswalk mapping becomes effective.

Dictionary Dataset Specification (M-Q)

Dictionary Provider Specialty Crosswalk

Columns

  • Valid_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Provider Specialty Taxonomy

Columns

  • Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Undefined

  • Is Nullable: YES

  • Data Type: STRING

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

  • Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Patient_Centered_Medical_Home_Flag

  • Is Nullable: YES

  • Data Type: STRING

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

  • Grouping

  • Is Nullable: YES

  • Data Type: STRING

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

  • Classification

  • Is Nullable: YES

  • Data Type: STRING

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

  • Specialization

  • Is Nullable: YES

  • Data Type: STRING

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

  • Definition

  • Is Nullable: YES

  • Data Type: STRING

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

  • Notes

  • Is Nullable: YES

  • Data Type: STRING

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

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Provider Specialty Type

Columns

  • Specialty_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Specialty_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Provider Tier

Columns

  • Provider_Tier

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier representing a specific tier level for providers.

  • Provider_Tier_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider tier.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this provider tier is currently active or in use.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this provider tier entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this provider tier entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this provider tier entry was last modified.

Dictionary Provider Type

Columns

  • Provider_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Provider_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Dictionary Dataset Specification (M-Q)

Dictionary Provider Type

Columns

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who last modified this provider type entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Provider Type Crosswalk

Columns

  • Source

  • Is Nullable: YES

  • Data Type: STRING

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

  • Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Member_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Member_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Questionnaire Access Point

Columns

  • Access_Point

  • Is Nullable: YES

  • Data Type: STRING

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

  • Access_Point_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Further explains the characteristics or features of the specified access point.

  • 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 Questionnaire Class

Columns

  • Questionnaire_Class

  • Is Nullable: YES

  • Data Type: STRING

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

  • Questionnaire_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Elaborates on the purpose or scope of the specified questionnaire 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 Questionnaire Review Edit Reason

Columns

  • Review_Edit_Reason

  • Is Nullable: YES

  • Data Type: STRING

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

  • Review_Edit_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • 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 RX Patient Relation

Columns

  • Patient_Relationship_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Patient_Relationship_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (M-Q)

Dictionary_Race

Race_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Race_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Request_Urgency

Code

  • Is Nullable: YES

  • Data Type: STRING

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

Description

  • Is Nullable: YES

  • Data Type: STRING

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

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the urgency level is currently active.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Revenue_Code

Revenue_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Revenue_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Start

  • Is Nullable: YES

  • Data Type: STRING

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

Code_End

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Set

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Version

  • Is Nullable: YES

  • Data Type: STRING

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

Active

  • Is Nullable: YES

  • Data Type: STRING

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

Room_Board_Flag

  • Is Nullable: YES

  • Data Type: STRING

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

RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

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

Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Risk_Score_Type

Score_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Score_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Model_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Model_Type

  • Is Nullable: YES

  • Data Type: STRING

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

Population_Type

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Service_CPT4

Service_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Dictionary Dataset Specification (M-Q)

Dictionary_Service_CPT4

Service_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

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

Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

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

Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Start

  • Is Nullable: YES

  • Data Type: STRING

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

Code_End

  • Is Nullable: YES

  • Data Type: STRING

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

Billable

  • Is Nullable: YES

  • Data Type: STRING

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

Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

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

Billable_End

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Set

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Version

  • Is Nullable: YES

  • Data Type: STRING

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

RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

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

Active

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Service_HCPCS

Service_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

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

Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

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

Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Start

  • Is Nullable: YES

  • Data Type: STRING

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

Code_End

  • Is Nullable: YES

  • Data Type: STRING

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

Billable

  • Is Nullable: YES

  • Data Type: STRING

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

Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

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

Billable_End

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Set

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Version

  • Is Nullable: YES

  • Data Type: STRING

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

RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

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

Active

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (M-Q)

Dictionary_Service_ICD10

Columns

  • d_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Service_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

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

  • Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

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

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable_End

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

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

  • RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Service_ICD9

Columns

  • Service_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

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

  • Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

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

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable_End

  • Is Nullable: YES

  • Data Type: STRING

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

Dictionary Dataset Specification (M-Q)

Dictionary_Service_ICD9

Code_Set

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Version

  • Is Nullable: YES

  • Data Type: STRING

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

RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

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

Active

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Service_Introducer

Service_Introducer_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Introducer_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Introducer_Category

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Scheme_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Service_Modifier_CPT4

Service_Modifier_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Modifier_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Modifier_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Modifier_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Start

  • Is Nullable: YES

  • Data Type: STRING

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

Code_End

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Set

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Version

  • Is Nullable: YES

  • Data Type: STRING

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

Active

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (M-Q)

Dictionary_Service_Modifier_HCPCS

Service_Modifier_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Modifier_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Modifier_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Modifier_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Start

  • Is Nullable: YES

  • Data Type: STRING

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

Code_End

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Set

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Version

  • Is Nullable: YES

  • Data Type: STRING

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

Active

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Service_Setting_Code

Service_Setting_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Setting_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Location_Code

  • Is Nullable: YES

  • Data Type: STRING

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

RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

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

Place_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Source_Of_Payment_Typology

Concept_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Concept_Name

  • Is Nullable: YES

  • Data Type: STRING

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

Preferred_Concept_Name

  • Is Nullable: YES

  • Data Type: STRING

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

Preferred_Alternate_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Code_System_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the code system to which the concept code belongs, such as ICD.

Dictionary Dataset Specification (M-Q)

Dictionary_Source_Of_Payment_Typology

Code_System_Name

  • Is Nullable: YES

  • Data Type: STRING

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

Code_System_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Code_System_Version

  • Is Nullable: YES

  • Data Type: STRING

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

HL7_Table_0396_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Value_Set_Concept_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Value_Set_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Value_Set_Version

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_State_Province

State_Province_Code

  • Is Nullable: YES

  • Data Type: STRING

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

State_Province_Name

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Subclient

Subclient_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Subclient_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_System_Source

System_Source_Code

  • Is Nullable: YES

  • Data Type: STRING

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

System_Source_Name

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (M-Q)

Dictionary_MEG_Malignancy

Columns

Column Name

Is Nullable

Data Type

Description

Group_Code

YES

STRING

A code assigned to represent a specific malignancy group.

Group_Name

YES

STRING

The name of the malignancy group.

Disease_Stage

YES

STRING

The stage of the disease within the malignancy group.

Disease_Stage_Description

YES

STRING

A detailed description of the disease stage.

Health_Status

YES

STRING

An indicator of the overall health status associated with this malignancy group and stage.

Episode_Group_Assignment

YES

STRING

The assignment of this malignancy to a specific episode group for treatment or tracking purposes.

Clean_Period

YES

STRING

The period of time required after treatment during which no symptoms are present to consider the condition resolved.

Effective_From_Timestamp

YES

TIMESTAMP

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

Created_User_ID

YES

STRING

The user ID of the person who created this malignancy entry.

Created_Timestamp

YES

TIMESTAMP

The timestamp when this malignancy entry was created.

Last_Modified_User_ID

YES

STRING

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

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when this malignancy entry was last modified.

Active

YES

STRING

Indicates whether this malignancy entry is currently active or in use.

Dictionary_MEG_Provider_Type_Crosswalk

Columns

Column Name

Is Nullable

Data Type

Description

Meg_Provider_Type_Code

YES

STRING

A code representing a specific provider type in the Medical Episode Grouper (MEG) system.

Med_Specialty_Code

YES

STRING

A code representing a corresponding medical specialty.

Effective_From_Timestamp

YES

TIMESTAMP

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

Created_User_ID

YES

STRING

The user ID of the person who created this crosswalk entry.

Created_Timestamp

YES

TIMESTAMP

The timestamp when this crosswalk entry was created.

Last_Modified_User_ID

YES

STRING

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

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when this crosswalk entry was last modified.

Dictionary_Marital_Status

Columns

Column Name

Is Nullable

Data Type

Description

Marital_Status

YES

STRING

Legal or social status related to marriage (e.g., single, married, divorced).

Marital_Status_Description

YES

STRING

Explanation of the marital 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_Medical_Policy_Category

Columns

Column Name

Is Nullable

Data Type

Description

Medical_Policy_Code

YES

STRING

The code identifying the medical policy.

Medical_Policy_Name

YES

STRING

The name of the medical policy.

Active

YES

STRING

Indicates whether the medical policy is active.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp from which the medical policy is effective.

Created_User_ID

YES

STRING

The ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

The timestamp when the record was created.

Last_Modified_User_ID

YES

STRING

The ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when the record was last modified.

Dictionary_Member_Alert

Columns

Column Name

Is Nullable

Data Type

Description

Alert

YES

STRING

A code or identifier representing a specific alert related to a member in the medical system.

Alert_Description

YES

STRING

A detailed explanation of the alert, describing the reason or context in which the alert is raised.

Effective_From_Timestamp

YES

TIMESTAMP

The date and time when the alert became effective or started being applicable to the member.

Created_User_ID

YES

STRING

The identifier of the user who initially created the alert entry in the system.

Created_Timestamp

YES

TIMESTAMP

The date and time when the alert was first created.

Last_Modified_User_ID

YES

STRING

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

Last_Modified_Timestamp

YES

TIMESTAMP

The date and time when the alert entry was last modified.

Dictionary Dataset Specification (M-Q)

Dictionary_Member_Alert

Columns

  • ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the alert is currently active or in use for the member.

Dictionary_Member_Alternate_ID

Columns

  • Alternate_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code that serves as an alternate or secondary ID for the member.

  • Alternate_ID_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description or explanation of the purpose or use of the alternate ID for the member.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the alternate ID becomes effective for the member.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who initially created the alternate ID entry in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the alternate ID was first created in the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the alternate ID entry in the system.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the alternate ID was last updated or modified.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the alternate ID is currently active or in use for the member.

Dictionary_Member_Alternate_ID_Type

Columns

  • Alternate_ID_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of alternate identifier (e.g., social security number, driver’s license).

  • Alternate_ID_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the alternate identifier 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_Member_Contact_Association

Columns

  • Contact_Association

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Relationship or association between contacts (e.g., emergency contact, primary contact).

  • Contact_Association_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the contact association.

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

Columns

  • Member_Engagement_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current engagement status of a member (e.g., active, inactive, engaged).

  • Member_Engagement_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the member engagement 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_Member_Engagement_Type

Columns

  • Member_Engagement_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Member_Engagement_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the member engagement 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 Dataset Specification (M-Q)

Dictionary_Member_Enrollment_Alert

Columns

  • Enrollment_Alert

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier for the enrollment alert, indicating a specific condition or status related to a member's enrollment.

  • Enrollment_Alert_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the enrollment alert, explaining the nature or purpose of the alert.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the enrollment alert becomes active and applicable.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who initially created the enrollment alert entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the enrollment alert entry was first created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the enrollment alert is currently active and in use.

Dictionary_Monitor_Rule

Columns

  • Monitor_Rule_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique key or identifier for a monitoring rule.

  • Monitor_Rule_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label for the monitoring rule.

  • Active

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the rule 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_Not_Enrolled_Reason

Columns

  • Not_Enrolled_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for a member not being enrolled in a specific program or service.

  • Not_Enrolled_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the reason for non-enrollment.

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

Columns

  • Note_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of note (e.g., clinical, administrative).

  • Note_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Note_Type_Domain

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Domain the note type belongs to.

Dictionary_Note_Void_Reason

Columns

  • Note_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding or canceling a note.

  • Note_Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the note void reason.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (M-Q)

Dictionary_Opportunity_Score_Health_Status_Category

Table Content

Column Name

Is Nullable

Data Type

Description

Health_Status

YES

STRING

An indicator of the overall health status associated with this category.

Start_Days

YES

STRING

The starting day of the time range for this health status category.

End_Days

YES

STRING

The ending day of the time range for this health status category.

Category_Desc

YES

STRING

A detailed description of the health status category.

Category_Code

YES

STRING

A code assigned to represent the health status category.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp from which this health status category entry became or will become effective.

Created_User_ID

YES

STRING

The user ID of the person who created this health status category entry.

Created_Timestamp

YES

TIMESTAMP

The timestamp when this health status category entry was created.

Last_Modified_User_ID

YES

STRING

The user ID of the person who last modified this health status category entry.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when this health status category entry was last modified.

Dictionary_Opportunity_Score_Health_Status_Category_Crosswalk

Table Content

Column Name

Is Nullable

Data Type

Description

Code

YES

STRING

A code representing a specific health status category in the opportunity score system.

Description

YES

STRING

A detailed description of the health status category.

Effective_From_Timestamp

YES

TIMESTAMP

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

Created_User_ID

YES

STRING

The user ID of the person who created this crosswalk entry.

Created_Timestamp

YES

TIMESTAMP

The timestamp when this crosswalk entry was created.

Last_Modified_User_ID

YES

STRING

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

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when this crosswalk entry was last modified.

Dictionary_Opportunity_Score_Lab_Ranges_Crosswalk

Table Content

Column Name

Is Nullable

Data Type

Description

ID

YES

STRING

A unique identifier for this lab range entry in the opportunity score system.

Lab_ID

YES

STRING

An identifier for the specific lab test associated with this range.

Comment

YES

STRING

Additional notes or comments about this lab range.

Lower_Range

YES

STRING

The lower boundary of the lab value range.

Upper_Range

YES

STRING

The upper boundary of the lab value range.

Units

YES

STRING

The units of measurement for the lab values.

Score

YES

STRING

The opportunity score associated with this lab range.

Overriding_Lab_Rules

YES

STRING

Any special rules that override standard scoring for this lab range.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp from which this lab range entry became or will become effective.

Created_User_ID

YES

STRING

The user ID of the person who created this lab range entry.

Created_Timestamp

YES

TIMESTAMP

The timestamp when this lab range entry was created.

Last_Modified_User_ID

YES

STRING

The user ID of the person who last modified this lab range entry.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when this lab range entry was last modified.

Dictionary_Opportunity_Score_Populations_Crosswalk

Table Content

Column Name

Is Nullable

Data Type

Description

Category

YES

STRING

The category or group of the population being scored.

Rule_ID

YES

STRING

An identifier for the specific rule applied to this population category.

Score

YES

STRING

The opportunity score associated with this population category and rule.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp from which this population crosswalk entry became or will become effective.

Created_User_ID

YES

STRING

The user ID of the person who created this population crosswalk entry.

Created_Timestamp

YES

TIMESTAMP

The timestamp when this population crosswalk entry was created.

Last_Modified_User_ID

YES

STRING

The user ID of the person who last modified this population crosswalk entry.

Last_Modified_Timestamp

YES

TIMESTAMP

The timestamp when this population crosswalk entry was last modified.

Dictionary Dataset Specification (M-Q)

Dictionary Opportunity Score Populations Crosswalk

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this population crosswalk entry was last modified.

Dictionary Opportunity Score Rule

Rule_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for the opportunity score rule.

Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the rule.

Health_Status_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The health status category to which this rule applies.

Low_Range

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The lower boundary of the range for which this rule is applicable.

High_Range

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The upper boundary of the range for which this rule is applicable.

Product

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The product or service associated with this rule.

Program_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code of the program to which this rule belongs.

Rule_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type or category of the rule.

Score_Indicator

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An indicator of how this rule affects the overall score.

Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag or marker associated with this rule.

Severity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The severity level assigned to this rule.

Rule_Category

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The category or group to which this rule belongs.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this rule became or will become effective.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this rule was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Opportunity Score Weighting Values

Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or identifier of the weighting factor.

Weight

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The numerical weight assigned to this factor in the opportunity score calculation.

Minimum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The minimum allowed value for this weighting factor.

Maximum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The maximum allowed value for this weighting factor.

Default_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The default value used for this weighting factor if no specific value is provided.

Round_On_Point_Five

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the value should be rounded to the nearest 0.5.

ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for this weighting value entry.

Base_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The base value used in calculations involving this weighting factor.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this weighting value entry became or will become effective.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this weighting value entry was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this weighting value entry was last modified.

Dictionary Outcome Reason

Outcome_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for a specific outcome (e.g., claim denial, treatment success).

Outcome_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the outcome reason.

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Outcome Status

Outcome_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of a specific outcome (e.g., achieved, pending).

Outcome_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the outcome status.

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

Dictionary Dataset Specification (M-Q)

Dictionary Outcome Status

Columns

  • Outcome_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The status of the outcome of the appeal process.

  • 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 Outcome Status Outcome Reason Mapping

Columns

  • Outcome_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The status of the outcome of the appeal process.

  • Outcome_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The reason for the outcome status.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the outcome record is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which the outcome 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 Overall Request Status

Columns

  • Overall_Request_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Overall status of a request or process (e.g., approved, denied, pending).

  • Overall_Request_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the overall request 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 Participating Network Status

Columns

  • Participating_Network_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status related to network participation (e.g., in-network, out-of-network).

  • Participating_Network_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the participating network 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 Penalty

Columns

  • Penalty

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Consequence or fine imposed due to non-compliance or violation (e.g., late payment penalty).

  • Penalty_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the penalty.

  • 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 Permissions Criteria Operator

Columns

  • Permissions_Criteria_Operator

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Operator used in permissions criteria (e.g., AND, OR).

  • Permissions_Criteria_Operator_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the permissions criteria operator.

  • 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 (M-Q)

Dictionary_Permissions_Element

Table Structure

Column Name

Is Nullable

Data Type

Description

Permissions_Element

YES

STRING

Represents an element or component for which permissions are defined.

Permissions_Element_Description

YES

STRING

Detailed description of the permissions element.

Permissions_Element_Class

YES

STRING

Classification or category of the permissions element.

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_Permissions_Element_Class

Table Structure

Column Name

Is Nullable

Data Type

Description

Permissions_Element_Class

YES

STRING

Classification or category of the permissions element.

Permissions_Element_Class_Description

YES

STRING

Explanation of the permissions element class.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp indicating the start of the effective period.

Created_User_ID

YES

STRING

User ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Dictionary_Pft_Dx_Icd10

Table Structure

Column Name

Is Nullable

Data Type

Description

Display_Term_Text

YES

STRING

Text to display for the term.

Term_Text

YES

STRING

Actual term text.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp when the term became effective.

Created_User_ID

YES

STRING

Identifier for the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp when the record was created.

Last_Modified_User_ID

YES

STRING

Identifier for the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when the record was last modified.

Dictionary_Phone_Type

Table Structure

Column Name

Is Nullable

Data Type

Description

Phone_Type

YES

STRING

Type or category of phone number (e.g., mobile, home, work).

Phone_Type_Description

YES

STRING

Detailed description of the phone type.

Active

YES

STRING

Indicates whether the item is active.

Effective_From_Timestamp

YES

TIMESTAMP

Timestamp indicating the start of the effective period.

Created_User_ID

YES

STRING

User ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Dictionary_Place_Of_Service

Table Structure

Column Name

Is Nullable

Data Type

Description

Place_Of_Service

YES

STRING

Specific location or setting where a service is provided (e.g., hospital, clinic, home).

Place_Of_Service_Description

YES

STRING

Explanation of the place of service.

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_Place_Of_Service_CMS

Table Structure

Column Name

Is Nullable

Data Type

Description

Service_Place_Code

YES

STRING

The code assigned by CMS to represent a specific place of service.

Service_Place_Desc

YES

STRING

A detailed description of the place of service.

Service_Setting_Code

YES

STRING

A code representing the broader service setting category.

Service_Setting_Description

YES

STRING

A description of the service setting category.

Effective_From_Timestamp

YES

TIMESTAMP

The timestamp from which this place of service entry became or will become effective.

Created_User_ID

YES

STRING

The user ID of the person who created this place of service entry.

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 (M-Q)

Dictionary_Place_Of_Service_CMS

Columns

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this place of service entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this place of service entry was last modified.

Dictionary_Plan

Columns

  • Plan_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for a specific health insurance plan.

  • Plan_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the health insurance plan.

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

Columns

  • vendorCode

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code assigned to identify a specific point of service vendor.

  • vendorCodeDescription

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the vendor associated with the vendor code.

  • vendorLink

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A URL or reference link to the vendor's website or additional information.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this vendor entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Population

Columns

  • Population_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for a specific population group or category.

  • Population_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Descriptive name or label for the population group.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the current status of the population (e.g., active, inactive, pending).

  • Parent_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of parent entity associated with this population (e.g., organization, region, etc.).

  • Parent_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the parent entity (e.g., organization ID, region ID).

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

Columns

  • Rep_Rule_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing a specific population type or representation rule.

  • Rep_Rule_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the population type or representation rule.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Predefined_Groups_Account

Columns

  • Predefined_Account_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing a predefined group of accounts.

  • Predefined_Account_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the predefined account group.

  • Predefined_Account_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the predefined account group.

  • Account_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific account code associated with this group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this predefined account group entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this predefined account group entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined account group entry was created.

Dictionary Dataset Specification (M-Q)

Dictionary_Predefined_Groups_Account

Columns

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this predefined account group entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined account group entry was last modified.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined account group entry was created.

Dictionary_Predefined_Groups_Carrier_Code

Columns

  • Predefined_Carrier_Code_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the predefined carrier code group.

  • Predefined_Carrier_Code_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined carrier code group.

  • Predefined_Carrier_Code_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined carrier code group.

  • Carrier_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the carrier.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the predefined carrier code group 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_Predefined_Groups_Client_Code

Columns

  • Predefined_Client_Code_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the predefined client code group.

  • Predefined_Client_Code_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined client code group.

  • Predefined_Client_Code_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined client code group.

  • Client_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code for the client.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the predefined client code group 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_Predefined_Groups_Condition

Columns

  • Predefined_Condition_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing a predefined group of medical conditions.

  • Predefined_Condition_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the predefined condition group.

  • Predefined_Condition_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the predefined condition group.

  • Condition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific condition code associated with this group.

  • Subcondition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A subcategory or more specific code within the condition code.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this predefined condition group entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this predefined condition group entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined condition group entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this predefined condition group entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined condition group entry was last modified.

Dictionary_Predefined_Groups_Diagnosis

Columns

  • Predefined_Diagnosis_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing a predefined group of diagnoses.

  • Predefined_Diagnosis_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the predefined diagnosis group.

  • Predefined_Diagnosis_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the predefined diagnosis group.

  • Diagnosis_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific diagnosis code associated with this group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this predefined diagnosis group entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this predefined diagnosis group entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined diagnosis group entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this predefined diagnosis group entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined diagnosis group entry was last modified.

Dictionary Dataset Specification (M-Q)

Dictionary_Predefined_Groups_Diagnosis

Columns

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined diagnosis group entry was last modified.

Dictionary_Predefined_Groups_Discharge_Code

Columns

  • Predefined_Discharge_Code_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of discharge codes.

  • Predefined_Discharge_Code_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of discharge codes.

  • Predefined_Discharge_Code_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group of discharge codes and its purpose.

  • Condition_Scheme_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the condition or scheme associated with the discharge group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined discharge group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined discharge code group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined discharge code group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined discharge code group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined discharge code group was last updated.

Dictionary_Predefined_Groups_Drug

Columns

  • Predefined_Drug_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of drugs.

  • Predefined_Drug_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of drugs.

  • Predefined_Drug_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined drug group and its purpose or characteristics.

  • GPI2_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Two-character GPI (Generic Product Identifier) code representing a high-level drug group.

  • GPI4_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Four-character GPI code providing a more specific classification of drugs within a group.

  • GPI6_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Six-character GPI code providing a detailed classification of drugs.

  • GPI10_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Ten-character GPI code offering the most specific classification of a drug.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined drug group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined drug group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined drug group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined drug group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined drug group was last updated.

Dictionary_Predefined_Groups_Encounter_Class

Columns

  • Predefined_Encounter_Class_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of encounter classes.

  • Predefined_Encounter_Class_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of encounter classes.

  • Predefined_Encounter_Class_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined encounter class group and its purpose or characteristics.

  • Encounter_Class_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific encounter class within the group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter class group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined encounter class group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter class group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined encounter class group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter class group was last updated.

Dictionary_Predefined_Groups_Encounter_Condition

Columns

  • Predefined_Encounter_Condition_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of encounter conditions.

  • Predefined_Encounter_Condition_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of encounter conditions.

  • Predefined_Encounter_Condition_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group of encounter conditions and its purpose.

  • Encounter_Condition_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific encounter condition within the group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter condition group becomes effective.

Dictionary Dataset Specification (M-Q)

Dictionary_Predefined_Groups_Encounter_Condition

Columns

  • m_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter condition group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined encounter condition group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter condition group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined encounter condition group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter condition group was last updated.

Dictionary_Predefined_Groups_Encounter_Priority

Columns

  • Predefined_Encounter_Priority_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of encounter priorities.

  • Predefined_Encounter_Priority_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of encounter priorities.

  • Predefined_Encounter_Priority_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group of encounter priorities and its purpose.

  • Encounter_Priority_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific encounter priority within the group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter priority group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined encounter priority group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter priority group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined encounter priority group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter priority group was last updated.

Dictionary_Predefined_Groups_Encounter_Service_Type

Columns

  • Predefined_Encounter_Service_Type_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of encounter service types.

  • Predefined_Encounter_Service_Type_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of encounter service types.

  • Predefined_Encounter_Service_Type_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group of encounter service types and its purpose.

  • Encounter_Service_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific encounter service type within the group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter service type group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined encounter service type group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter service type group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined encounter service type group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined encounter service type group was last updated.

Dictionary_Predefined_Groups_Group

Columns

  • Predefined_Group_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of groups.

  • Predefined_Group_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of groups.

  • Predefined_Group_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group of groups and its purpose.

  • Group_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for a specific group within the predefined group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined group of groups becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined group of groups.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined group of groups was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined group of groups.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined group of groups was last updated.

Dictionary_Predefined_Groups_LOINC

Columns

  • Predefined_Test_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group of tests.

  • Predefined_Test_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined group of tests.

  • Predefined_Test_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group of tests and its purpose.

Dictionary Dataset Specification (M-Q)

Dictionary_Predefined_Groups_LOINC

Columns

  • Test_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a specific test within the predefined group, typically based on LOINC.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined group of tests becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined group of tests.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined group of tests was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined group of tests.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined group of tests was last updated.

Dictionary_Predefined_Groups_Line_Of_Business

Columns

  • Predefined_LOB_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined group for a Line of Business (LOB).

  • Predefined_LOB_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined Line of Business (LOB) group.

  • Predefined_LOB_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined group related to the Line of Business, outlining its purpose and scope.

  • LOB_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code for the specific Line of Business (LOB) within the predefined group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined LOB group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined LOB group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined LOB group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined LOB group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined LOB group was last modified.

Dictionary_Predefined_Groups_Place_Of_Service

Columns

  • Predefined_Service_Place_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined place of service group.

  • Predefined_Service_Place_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined place of service group.

  • Predefined_Service_Place_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined place of service, outlining its function or classification.

  • Service_Setting_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing the service setting within the predefined service place.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined place of service group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined service place group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined service place group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined service place group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined service place group was last modified.

Dictionary_Predefined_Groups_Plan

Columns

  • Predefined_Plan_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined plan group.

  • Predefined_Plan_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined plan group.

  • Predefined_Plan_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined plan group, outlining its purpose or classification.

  • Plan_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing the specific plan associated with the predefined plan group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined plan group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined plan group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined plan group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined plan group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined plan group was last modified.

Dictionary_Predefined_Groups_Program

Columns

  • Predefined_Program_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing a predefined program group.

  • Predefined_Program_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the predefined program group.

  • Predefined_Program_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the predefined program group, outlining its purpose or classification.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined program group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined program group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined program group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined program group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined program group was last modified.

Dictionary Dataset Specification (M-Q)

Dictionary Predefined Groups Program

Columns

  • Program_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique code representing the specific program associated with the predefined program group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined program group becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the predefined program group.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined program group was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the predefined program group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the predefined program group was last modified.

Dictionary Predefined Groups Provider Specialty

Columns

  • Provider_Specialty_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing a group of specialties provided by a healthcare provider.

  • Provider_Specialty_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name associated with the group of specialties that the provider offers.

  • Provider_Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider's specialty group, explaining the type of services or care that fall under the specialty.

  • Provider_Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code assigned to a specific medical specialty or service provided by the healthcare provider.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the date and time when the provider specialty information becomes effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the record for the provider specialty group in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the record for the provider specialty group 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 record for the provider specialty group.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the record for the provider specialty group was last modified.

Dictionary Predefined Groups Provider Specialty Taxonomy

Columns

  • Provider_Specialty_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code representing a predefined group of provider specialties.

  • Provider_Specialty_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the predefined provider specialty group.

  • Provider_Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider specialty group.

  • Provider_Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific provider specialty code associated with this group.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this predefined provider specialty group entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who created this predefined provider specialty group entry.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined provider specialty group entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this predefined provider specialty group entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this predefined provider specialty group entry was last modified.

Dictionary Predefined Groups Revenue Code

Columns

  • Predefined_Revenue_Code_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing a group of related revenue codes in the healthcare billing system.

  • Predefined_Revenue_Code_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name associated with the group of revenue codes.

  • Predefined_Revenue_Code_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description explaining the specific group of revenue codes, which are used to classify and track healthcare services for billing purposes.

  • Revenue_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code used to represent a specific medical service or procedure for billing and insurance purposes.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the date and time when the revenue code group becomes effective in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the revenue code group record in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the revenue code 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 revenue code group record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (M-Q)

Dictionary Predefined Groups Revenue Code

Columns

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the revenue code group record in the system.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the revenue code group record was last modified in the system.

Dictionary Predefined Groups Service

Columns

  • Predefined_Service_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for a predefined group of related healthcare services or procedures.

  • Predefined_Service_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name associated with the group of services, used to categorize a set of related medical procedures or services within the system.

  • Predefined_Service_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description providing further detail on the services included in the predefined group, explaining the purpose or scope of the services within the group.

  • Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code that identifies a specific medical service or procedure within the healthcare system.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the date and time when the predefined service group became active or effective in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the predefined service group record in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the predefined service 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 predefined service group record in the system.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the predefined service group record was last modified in the system.

Dictionary Predefined Groups Service Modifier

Columns

  • Predefined_Service_Modifier_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for a predefined group of service modifiers, which are codes that modify or further specify the nature of a service or procedure in the healthcare system.

  • Predefined_Service_Modifier_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name assigned to the predefined group of service modifiers, used for categorizing and grouping related service modifications within the system.

  • Predefined_Service_Modifier_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description that provides details on the group of service modifiers, explaining the context or purpose of the modifiers within the predefined group.

  • Service_Modifier_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code that uniquely identifies a specific service modifier within the healthcare system, which adjusts or specifies a procedure's details or conditions.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the exact date and time when the predefined service modifier group became active or effective in the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the predefined service modifier group record was created within the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the predefined service modifier group record in the system.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the most recent modification made to the predefined service modifier group record in the system.

Dictionary Predefined Groups Subclient

Columns

  • Predefined_Subclient_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for a predefined group of subclients, which are typically smaller subdivisions or entities under a main client or program in the system.

  • Predefined_Subclient_Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name assigned to the predefined group of subclients, used to categorize or label different subclients within the system.

  • Predefined_Subclient_Group_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description that provides details about the predefined group of subclients, explaining the context or purpose of the group within the organization or system.

  • Subclient_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code that identifies a specific subclient within the broader program or client group, enabling specific tracking or management of subclient activities or services.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp that marks the date and time when the predefined subclient group became active or effective within the system.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who created the predefined subclient group record in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the predefined subclient group record was created within the system.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier of the user who last modified the predefined subclient group record in the system.

Dictionary Dataset Specification (M-Q)

Dictionary_Predefined_Groups_Subclient

Columns

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the predefined subclient group record was last modified in the system.

Dictionary_Preferred_Contact_Method

Columns

  • Method

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Approach or technique used to accomplish a task or process (e.g., payment method, communication method).

  • Method_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the method.

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

Columns

  • Time

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a specific point in time for making a contact.

  • Time_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the time parameter.

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

Columns

  • Origin_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Origin_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Primary_Service_Vendor_Contacts

Columns

  • Vendor_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier assigned to the primary service vendor.

  • Vendor_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description or name associated with the primary service vendor code.

  • Vendor_Phone

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Contact phone number for the primary service vendor.

  • Vendor_Email

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Contact email address for the primary service vendor.

  • Vendor_Link

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Link for the primary service vendor.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which this vendor contact information is effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who initially created the vendor contact record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Priority

Columns

  • Priority

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of importance or urgency (e.g., high, medium, low).

  • Priority_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information explaining the priority.

  • Priority_Rank

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Numeric ranking of the priority level.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (M-Q)

Dictionary Priority

Column Name

Is Nullable

Data Type

Description

Created_User_ID

YES

STRING

User ID of the user who created the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was created.

Last_Modified_User_ID

YES

STRING

User ID of the user who last modified the record.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Dictionary Problem

Column Name

Is Nullable

Data Type

Description

Problem

YES

STRING

Specific issue, challenge, or concern.

Problem_Description

YES

STRING

Detailed description of the problem.

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

Column Name

Is Nullable

Data Type

Description

Problem_Outcome

YES

STRING

Result or resolution related to addressing a problem (e.g., issue resolved, workaround applied).

Problem_Outcome_Description

YES

STRING

Explanation of the problem outcome.

Problem_Outcome_Category

YES

STRING

Category or group to which the problem outcome belongs.

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 Problem Outcome Category

Column Name

Is Nullable

Data Type

Description

Problem_Outcome_Category

YES

STRING

Category or group to which the problem outcome belongs.

Problem_Outcome_Category_Description

YES

STRING

Detailed description of the problem 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 Problem Status

Column Name

Is Nullable

Data Type

Description

Problem_Status

YES

STRING

Current status or condition related to a specific problem (e.g., open, resolved, pending).

Problem_Status_Description

YES

STRING

Detailed description of the problem 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 Product

Column Name

Is Nullable

Data Type

Description

Product

YES

STRING

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

Product_Description

YES

STRING

Detailed description of the product.

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 Product Program Mapping

Column Name

Is Nullable

Data Type

Description

Product

YES

STRING

The product associated with the program, typically referring to a healthcare service, plan, or item.

Program

YES

STRING

The program linked to the product, often representing an initiative or medical service offered under the product.

Active

YES

STRING

Indicates whether the item is active.

Dictionary Dataset Specification (M-Q)

Dictionary_Product_Program_Mapping

Columns

  • YES (STRING): A flag indicating whether the product-to-program mapping is currently active and in use.

  • Effective_From_Timestamp (TIMESTAMP): The date and time from which the product-to-program mapping becomes valid or effective.

  • Created_User_ID (STRING): The identifier of the user who created the product-to-program mapping entry in the system.

  • Created_Timestamp (TIMESTAMP): The date and time when the product-to-program mapping entry was first created.

  • Last_Modified_User_ID (STRING): The identifier of the user who last modified the product-to-program mapping entry.

  • Last_Modified_Timestamp (TIMESTAMP): The date and time when the product-to-program mapping entry was last updated or modified.

Dictionary_Program

Columns

  • Program (STRING): The identifier or code for a specific program.

  • Program_Description (STRING): A detailed description of the program.

  • Program_Alias (STRING): An alternative name or shorthand for the program.

  • Status_Code (STRING): A code representing the current status of the program.

  • Status_Name (STRING): The name or description of the program's status.

  • Visibility_Level (STRING): A code indicating the visibility level of the program.

  • Visibility_Level_Name (STRING): The name or description of the program's visibility level.

  • Designation_Code (STRING): A code representing any special designation for the program.

  • Designation_Name (STRING): The name or description of the program's designation.

  • Program_Type_Code (STRING): A code representing the type of program.

  • Program_Type_Name (STRING): The name or description of the program type.

  • Effective_From_Timestamp (TIMESTAMP): The timestamp from which this program entry became or will become effective.

  • Created_User_ID (STRING): The user ID of the person who created this program entry.

  • Created_Timestamp (TIMESTAMP): The timestamp when this program entry was created.

  • Last_Modified_User_ID (STRING): The user ID of the person who last modified this program entry.

  • Last_Modified_Timestamp (TIMESTAMP): The timestamp when this program entry was last modified.

Dictionary_Program_Close_Reason

Columns

  • Program_Close_Reason (STRING): Reason for closing or terminating a program (e.g., completion, inactivity).

  • Program_Close_Reason_Description (STRING): Detailed description of the program close reason.

  • Active (STRING): Indicates whether the item is active.

  • Effective_From_Timestamp (TIMESTAMP): Timestamp indicating the start of the effective period.

  • Created_User_ID (STRING): User ID of the user who created the record.

  • Created_Timestamp (TIMESTAMP): Timestamp indicating when the record was created.

  • Last_Modified_User_ID (STRING): User ID of the user who last modified the record.

  • Last_Modified_Timestamp (TIMESTAMP): Timestamp indicating when the record was last modified.

Dictionary_Program_Provider_Role

Columns

  • Program_Provider_Role (STRING): Role or function of a provider within a program (e.g., primary care, specialist).

  • Program_Provider_Role_Description (STRING): Explanation of the program provider role.

  • Active (STRING): Indicates whether the item is active.

  • Effective_From_Timestamp (TIMESTAMP): Timestamp indicating the start of the effective period.

  • Created_User_ID (STRING): User ID of the user who created the record.

  • Created_Timestamp (TIMESTAMP): Timestamp indicating when the record was created.

  • Last_Modified_User_ID (STRING): User ID of the user who last modified the record.

  • Last_Modified_Timestamp (TIMESTAMP): Timestamp indicating when the record was last modified.

Dictionary_Program_Reopen_Reason

Columns

  • Program_Reopen_Reason (STRING): Reason for reopening a previously closed program (e.g., new information, member request).

  • Program_Reopen_Reason_Description (STRING): Detailed description of the program reopen reason.

  • Active (STRING): Indicates whether the item is active.

  • Effective_From_Timestamp (TIMESTAMP): Timestamp indicating the start of the effective period.

  • Created_User_ID (STRING): User ID of the user who created the record.

  • Created_Timestamp (TIMESTAMP): Timestamp indicating when the record was created.

  • Last_Modified_User_ID (STRING): User ID of the user who last modified the record.

  • Last_Modified_Timestamp (TIMESTAMP): Timestamp indicating when the record was last modified.

Dictionary Dataset Specification (M-Q)

Dictionary Program Reopen Reason

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 Program Screening Status

Columns

  • Program_Screening_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status related to program screening or eligibility assessment (e.g., screened, pending).

  • Program_Screening_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the program screening 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 Program Severity

Columns

  • Program_Severity

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Level of severity or impact associated with a program (e.g., low, moderate, high).

  • Program_Severity_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the program severity.

  • Program_Export_Severity_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code used for exporting or identifying the program severity in external systems or reporting processes.

  • Minimum_Stage_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The minimum stage or value of the program associated with this severity level, possibly reflecting an early phase.

  • Maximum_Stage_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The maximum stage or value of the program within this severity level, representing the most advanced phase covered.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the program severity is currently active and in use (active/inactive 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 Program Source

Columns

  • Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Origin or source of specific data or information (e.g., member portal, claims data).

  • Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the data source.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the item is active.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Provider Alternate ID

Columns

  • Alternate_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An alternative identifier used for providers.

  • Alternate_ID_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the alternate provider ID type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this alternate provider ID entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this alternate provider ID entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this alternate provider ID entry was last modified.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this alternate provider ID type is currently active or in use.

Dictionary Provider Alternate ID Type

Columns

  • Alternate_ID_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of alternate identifier (e.g., social security number, driver’s license).

  • Alternate_ID_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the alternate identifier 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.

Dictionary Dataset Specification (M-Q)

Dictionary Provider Alternate ID Type

Columns

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Provider Contact Association

Columns

  • Contact_Association

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Relationship or association between contacts (e.g., emergency contact, primary contact).

  • Contact_Association_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explanation of the contact association.

  • 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 Provider Network

Columns

  • Network_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing a specific network or provider group.

  • Network_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name or label for the network.

  • 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 Provider Set Code

Columns

  • Set_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier or code for a specific set or group (e.g., benefit set, service set).

  • Set_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the set 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 Provider Specialty

Columns

  • Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code used to identify the provider's specialty, such as cardiology, pediatrics, or surgery.

  • Specialty_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A classification of the type of specialty, indicating the category or field within healthcare to which the specialty belongs.

  • Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider’s specialty, providing additional information about the specific focus area.

  • Patient_Centered_Medical_Home_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the specialty is part of a Patient-Centered Medical Home (PCMH) model, which emphasizes coordinated care.

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Defines the level of visibility or access permissions for the specialty information, potentially limiting who can view it.

  • ACTIVE

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this provider specialty is currently active or in use.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time from which the provider’s specialty designation becomes valid or effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the entry for the provider’s specialty in the system.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the provider’s specialty entry was first created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the provider’s specialty entry.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the provider’s specialty entry was last updated or modified.

Dictionary Provider Specialty Crosswalk

Columns

  • Taxonomy_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Taxonomy_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider’s taxonomy.

Dictionary Dataset Specification (M-Q)

Dictionary Provider Specialty Crosswalk

Columns and Descriptions

  • Insights_Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Insights_Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Crosswalk_Priority

  • Is Nullable: YES

  • Data Type: STRING

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

  • CMS_Specialty_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • CMS_Specialty_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Provider Specialty Taxonomy

Columns and Descriptions

  • Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Undefined

  • Is Nullable: YES

  • Data Type: STRING

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

  • Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Patient_Centered_Medical_Home_Flag

  • Is Nullable: YES

  • Data Type: STRING

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

  • Grouping

  • Is Nullable: YES

  • Data Type: STRING

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

  • Classification

  • Is Nullable: YES

  • Data Type: STRING

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

  • Specialization

  • Is Nullable: YES

  • Data Type: STRING

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

  • Definition

  • Is Nullable: YES

  • Data Type: STRING

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

  • Notes

  • Is Nullable: YES

  • Data Type: STRING

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

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Provider Specialty Type

Columns and Descriptions

  • Specialty_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Specialty_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Provider Tier

Columns and Descriptions

  • Provider_Tier

  • Is Nullable: YES

  • Data Type: STRING

  • Description: (Description missing in the provided content.)

Dictionary Dataset Specification (M-Q)

Dictionary Provider Tier

Columns

  • Provider_Tier

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier representing a specific tier level for providers.

  • Provider_Tier_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider tier.

  • Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether this provider tier is currently active or in use.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this provider tier entry became or will become effective.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this provider tier entry was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this provider tier entry was last modified.

Dictionary Provider Type

Columns

  • Provider_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Provider_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the provider type.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Provider Type Crosswalk

Columns

  • Source

  • Is Nullable: YES

  • Data Type: STRING

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

  • Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Member_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Member_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Questionnaire Access Point

Columns

  • Access_Point

  • Is Nullable: YES

  • Data Type: STRING

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

  • Access_Point_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Further explains the characteristics or features of the specified access point.

  • 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 Questionnaire Class

Columns

  • Questionnaire_Class

  • Is Nullable: YES

  • Data Type: STRING

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

  • Questionnaire_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Elaborates on the purpose or scope of the specified questionnaire class.

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (M-Q)

Dictionary Questionnaire Review Edit Reason

Review_Edit_Reason

  • Is Nullable: YES

  • Data Type: STRING

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

Review_Edit_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

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

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 RX Patient Relation

Patient_Relationship_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Patient_Relationship_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Race

Race_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Race_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Request Urgency

Code

  • Is Nullable: YES

  • Data Type: STRING

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

Description

  • Is Nullable: YES

  • Data Type: STRING

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

Active

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether the urgency level is currently active.

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Revenue Code

Revenue_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Revenue_Code_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Start

  • Is Nullable: YES

  • Data Type: STRING

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

Code_End

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Set

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Version

  • Is Nullable: YES

  • Data Type: STRING

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

Active

  • Is Nullable: YES

  • Data Type: STRING

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

Room_Board_Flag

  • Is Nullable: YES

  • Data Type: STRING

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

RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

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

Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag indicating whether episodes are included in the revenue code categorization.

Dictionary Dataset Specification (M-Q)

Dictionary Revenue Code

Columns

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Risk Score Type

Columns

  • Score_Type_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Score_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Model_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Model_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Population_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Service CPT4

Columns

  • Service_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

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

  • Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

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

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable_End

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

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

  • RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (M-Q)

Dictionary_Service_HCPCS

Table Structure

Column Name

Is Nullable

Data Type

Description

Service_Code

YES

STRING

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

Service_Code_Set_Type

YES

STRING

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

Service_Description

YES

STRING

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

Service_Short_Term

YES

STRING

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

Service_Long_Term

YES

STRING

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

Include_Episodes_Flag

YES

STRING

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

Visibility_Level

YES

STRING

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

Code_Start

YES

STRING

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

Code_End

YES

STRING

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

Billable

YES

STRING

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

Billable_Start

YES

STRING

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

Billable_End

YES

STRING

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

Code_Set

YES

STRING

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

Code_Version

YES

STRING

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

RSS_Source_Number

YES

STRING

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

Active

YES

STRING

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

Effective_From_Timestamp

YES

TIMESTAMP

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

Created_User_ID

YES

STRING

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

Created_Timestamp

YES

TIMESTAMP

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

Last_Modified_User_ID

YES

STRING

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

Last_Modified_Timestamp

YES

TIMESTAMP

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

Dictionary_Service_ICD10

Table Structure

Column Name

Is Nullable

Data Type

Description

Service_Code

YES

STRING

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

Service_Code_Set_Type

YES

STRING

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

Service_Description

YES

STRING

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

Service_Short_Term

YES

STRING

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

Service_Long_Term

YES

STRING

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

Include_Episodes_Flag

YES

STRING

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

Visibility_Level

YES

STRING

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

Code_Start

YES

STRING

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

Code_End

YES

STRING

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

Billable

YES

STRING

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

Billable_Start

YES

STRING

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

Billable_End

YES

STRING

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

Dictionary Dataset Specification (M-Q)

Dictionary_Service_ICD10

Columns and Descriptions

  • Service_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier or code assigned to a specific medical diagnosis or service, typically based on the ICD-10 coding system.

  • Service_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

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

  • Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

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

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable_End

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

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

  • RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Service_ICD9

Columns and Descriptions

  • Service_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Short_Term

  • Is Nullable: YES

  • Data Type: STRING

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

  • Service_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

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

  • Include_Episodes_Flag

  • Is Nullable: YES

  • Data Type: STRING

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

  • Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_Start

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_End

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable_Start

  • Is Nullable: YES

  • Data Type: STRING

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

  • Billable_End

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_Set

  • Is Nullable: YES

  • Data Type: STRING

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

  • Code_Version

  • Is Nullable: YES

  • Data Type: STRING

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

  • RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

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

  • Active

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary Dataset Specification (M-Q)

Dictionary_Service_Introducer

Service_Introducer_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Introducer_Category

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Scheme_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Service_Modifier_CPT4

Service_Modifier_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Modifier_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Modifier_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Modifier_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Start

  • Is Nullable: YES

  • Data Type: STRING

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

Code_End

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Set

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Version

  • Is Nullable: YES

  • Data Type: STRING

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

Active

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Service_Modifier_HCPCS

Service_Modifier_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Modifier_Code_Set_Type

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Modifier_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Modifier_Long_Term

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Start

  • Is Nullable: YES

  • Data Type: STRING

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

Code_End

  • Is Nullable: YES

  • Data Type: STRING

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

Dictionary Dataset Specification (M-Q)

Dictionary_Service_Modifier_HCPCS

Code_Set

  • Is Nullable: YES

  • Data Type: STRING

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

Code_Version

  • Is Nullable: YES

  • Data Type: STRING

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

Active

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Service_Setting_Code

Service_Setting_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Setting_Description

  • Is Nullable: YES

  • Data Type: STRING

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

Service_Location_Code

  • Is Nullable: YES

  • Data Type: STRING

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

RSS_Source_Number

  • Is Nullable: YES

  • Data Type: STRING

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

Place_Group_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Visibility_Level

  • Is Nullable: YES

  • Data Type: STRING

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

Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Source_Of_Payment_Typology

Concept_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Concept_Name

  • Is Nullable: YES

  • Data Type: STRING

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

Preferred_Concept_Name

  • Is Nullable: YES

  • Data Type: STRING

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

Preferred_Alternate_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Code_System_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Code_System_Name

  • Is Nullable: YES

  • Data Type: STRING

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

Code_System_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Code_System_Version

  • Is Nullable: YES

  • Data Type: STRING

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

HL7_Table_0396_Code

  • Is Nullable: YES

  • Data Type: STRING

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

Value_Set_Concept_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the concept within the value set, explaining its role or significance in the context of payment typology.

Dictionary Dataset Specification (M-Q)

Dictionary_Source_Of_Payment_Typology

Columns

  • Value_Set_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Value_Set_Version

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_State_Province

Columns

  • State_Province_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • State_Province_Name

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_Subclient

Columns

  • Subclient_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Subclient_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Dictionary_System_Source

Columns

  • System_Source_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • System_Source_Name

  • Is Nullable: YES

  • Data Type: STRING

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

  • Effective_From_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

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