Records essential personal information of members, such as names, dates of birth, and other identifiers.

Provides a foundational understanding of the patient demographic.

Captures current contact details for each member.

Ensures communication channels are up-to-date and accessible for healthcare providers and administrative purposes.

Documents each member's enrollment timeline within different healthcare plans or services.

Offers insights into their healthcare journey and coverage status.

Tracks participation in various health programs.

Crucial for assessing member engagement and the effectiveness of different health interventions.

Includes medical diagnosis information linked to each member.

Critical for clinical decision-making and health management.

Records important alerts related to members, such as reminders for preventive screenings or follow-ups.

Enhances proactive healthcare delivery.

Provides flexibility to record additional data points specific to the organization's needs.

Allows for tailored data management.

Facilitates the analysis of member data by matching population segments.

Useful for public health studies and targeted care strategies.

Is Nullable: YES

Data Type: STRING

Description: Member’s unique key used to identify records within the Accountable Care Model (ACM). This key is null if the record does not originate from ACM.

Is Nullable: YES

Data Type: STRING

Description: Code representing a segment or group within the client's business, facilitating organization-specific categorizations. Refer to the Dictionary Client table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Describes the business group or segment associated with the Client Code, enhancing understanding of client structure. See Dictionary Client table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier assigned to a client within the healthcare management system.

Is Nullable: YES

Data Type: STRING

Description: Identifier for a subdivision or smaller unit within a client's structure, used for more detailed categorization.

Is Nullable: YES

Data Type: STRING

Description: Coded value representing the member's biological sex, with options like Male, Female, Unknown, and Not Valued. See Dictionary Gender table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Description of the biological sex of the member. Valid entries include Male, Female, Unknown, and Not Valued. See Dictionary Gender table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: BOOL

Description: Indicates whether a member is currently active within the system. If true, the member is active; otherwise, they are considered inactive.

Is Nullable: YES

Data Type: BOOL

Description: Flag indicating whether the member is assigned a temporary ID. Useful for identifying provisional records or memberships.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Records the birth date of the member, including year, month, and day, to calculate age and other demographics-related values.

Is Nullable: YES

Data Type: INT64

Description: Represents the age of the member, calculated based on the birth date. This field is computed in views and is not stored.

Is Nullable: YES

Data Type: STRING

Description: Categorical representation of the member's age, typically grouped into ranges (e.g., 20-30, 31-40). This field is calculated in views.

Is Nullable: YES

Data Type: STRING

Description: Code that signifies the primary language spoken by the member as self-reported. Refer to the Dictionary Language table in the Dictionary Dataset Specification for valid values.

Is Nullable: YES

Data Type: STRING

Description: Descriptive text of the primary language spoken by the member, providing a human-readable format. See Dictionary Language table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Code indicating the member's current marital status. Valid values are detailed in the Dictionary Marital Status table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Provides a description of the marital status of the member. Refer to the Dictionary Marital Status table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Unique alphanumeric identifier assigned to the member by the Managed Care Organization (MCO), serving as the primary key for reference.

Is Nullable: YES

Data Type: STRING

Description: The Social Security Number of the member.

Is Nullable: YES

Data Type: STRING

Description: Social Security Number of the member, a nine-digit number issued by the Social Security Administration, used primarily for identification purposes within the U.S.

Is Nullable: YES

Data Type: STRING

Description: Identifier unique to the member within the Medicare system, used for tracking and benefits management.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the member within the Medicaid system, facilitating benefits administration and eligibility verification.

Is Nullable: YES

Data Type: STRING

Description: Coded value representing the member’s race, used for demographic and health-related statistical analyses.

Is Nullable: YES

Data Type: STRING

Description: Detailed description of the member's race, enriching data understanding for health disparity studies and reporting.

Is Nullable: YES

Data Type: STRING

Description: Identifier or name of the healthcare provider primarily responsible for the member's care, facilitating association and accountability in care management.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking when the member's record was initially created in the system.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the most recent modification made to the member's record, indicating the latest update.

Is Nullable: YES

Data Type: STRING

Description: Prefix or title used before the member's name to denote formal address or social status, such as Dr., Mr., Mrs., etc.

Is Nullable: YES

Data Type: STRING

Description: The first name of the member as registered in the healthcare management system.

Is Nullable: YES

Data Type: STRING

Description: The middle name of the member, included for full identification and record completeness.

Is Nullable: YES

Data Type: STRING

Description: The last name or family name of the member, crucial for identification and documentation purposes.

Is Nullable: YES

Data Type: STRING

Description: Suffix or title used after the member's name to denote qualifications, generational suffixes, or honors, such as Jr., Sr., Ph.D., etc.

Is Nullable: YES

Data Type: STRING

Description: Full name of the member, combining first, middle, last names, and suffixes for complete identification. Used in reports and formal documentation.

Is Nullable: YES

Data Type: STRING

Description: Code representing the time zone in which the member is located, utilized for scheduling and timing of services.

Reference: See Dictionary Timezone table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Abbreviation of the member's time zone, reflecting their geographic location's standard time offset.

Reference: See Dictionary Timezone table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: System code for the time zone applicable to the member's location, aiding in time-sensitive operations and communication.

Reference: See Dictionary Timezone table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Name of the time zone associated with the member's geographic location, facilitating appropriate timing for services and communications.

Reference: See Dictionary Timezone table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: DATE

Description: The date from which the member became eligible for digital services or features.

Is Nullable: YES

Data Type: DATE

Description: The date on which the member's eligibility for digital services or features ended or is scheduled to end.

Is Nullable: YES

Data Type: STRING

Description: Unique key for the member's address, obtained from the Accountable Care Model (ACM). Null if the address data is not sourced from ACM.

Is Nullable: YES

Data Type: STRING

Description: Alphanumeric identifier assigned to the member by the Managed Care Organization (MCO), used to link addresses to specific members.

Is Nullable: YES

Data Type: STRING

Description: Two-letter state abbreviation where the member resides, used for regional analysis and reporting.

Reference: See Dictionary State table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Full name of the state for the member's address, providing clarity for data processing and reporting.

Reference: See Dictionary State table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Code that categorizes the type of the address, such as residential or business.

Reference: See Dictionary Address Type table in the Dictionary Dataset Specification for detailed classifications.

Is Nullable: YES

Data Type: STRING

Description: Description of the address type, helping to understand the nature of the address associated with the member.

Is Nullable: YES

Data Type: STRING

Description: The primary street address or location description for the member, serving as the first line of the address.

Is Nullable: YES

Data Type: STRING

Description: Additional address information such as apartment number or suite, serving as the second line of the address.

Is Nullable: YES

Data Type: STRING

Description: Further address details that may include building information or other specifics, serving as the third line of the address.

Is Nullable: YES

Data Type: STRING

Description: Name of the city for the member's address, essential for local health service allocation and mail delivery.

Is Nullable: YES

Data Type: STRING

Description: Alphanumeric code assigned to the member's address location for facilitating mail sorting and delivery.

Is Nullable: YES

Data Type: BOOL

Description: Indicates whether this is the member's preferred address for communications, which is critical for sending important health documents or correspondence.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking when the address record for the member was initially created, useful for data tracking and audits.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the most recent update made to the address record, indicating the latest data modification for tracking changes.

Is Nullable: YES

Data Type: STRING

Description: The county where the member's primary address is located, important for regional health services administration and demographic studies.

Is Nullable: YES

Data Type: STRING

Description: The country of the member's address, vital for processing international health claims and understanding global member distribution.

Member_Alert_Key

Is Nullable: YES

Data Type: STRING

Description: Unique key identifying each specific alert for a member, used for tracking and management. Refer to the Dictionary Alert table in the Dictionary Dataset Specification for more details on alert categories.

Member_ID

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for a member within the healthcare management system, used to link alerts to specific member profiles.

Code

Is Nullable: YES

Data Type: STRING

Description: Identifier for specific alerts related to a member, highlighting urgent or special needs such as Case Management or Eligibility issues.\ Note: Selection of multiple alerts may result in data duplication in reporting outputs.

Description

Is Nullable: YES

Data Type: STRING

Description: Description of the alert, clarifying the nature of the notification or issue related to the member. Special attention is needed for aspects like Case Management, Eligibility, etc. See Dictionary Alert table for details.

Created_Timestamp

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp indicating when the alert record was initially created. This is crucial for understanding the timeline of alerts in a member's healthcare management.

Last_Modified_Timestamp

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the latest update to the alert record, used to track changes and maintain up-to-date alert information.

Member_Alternate_ID_Key

Is Nullable: YES

Data Type: STRING

Description: Unique key for each alternate ID assigned to a member. This subclass is used to manage multiple IDs per member, which may result in report duplication per ID. Excludes members without alternate IDs from reports.

Member_ID

Is Nullable: YES

Data Type: STRING

Description: Identifier used by the Managed Care Organization (MCO) in addition to the standard Care Management Member ID. This ID is crucial for linking alternate identifiers with the member's primary record.

Type

Is Nullable: YES

Data Type: STRING

Description: Code representing the type of the alternate ID assigned to a member, such as emergency contact, secondary insurance, etc. Refer to the Dictionary Member Alternate ID Type table in the Dictionary Dataset Specification.

Type_Description

Is Nullable: YES

Data Type: STRING

Description: Description of the alternate ID type, providing context for why and how the alternate ID is used. See Dictionary Member Alternate ID Type table in the Dictionary Dataset Specification for detailed categorization and use cases.

Value

Is Nullable: YES

Data Type: STRING

Description: The actual alternate ID value assigned to the member, such as a secondary insurance number or emergency contact ID, used in managing member information across different systems or departments.

Created_Timestamp

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking when the alternate ID record was created. This helps in tracking when the ID was added to the member's profile, important for data management and audits.

Last_Modified_Timestamp

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp indicating the most recent update made to the alternate ID record, essential for maintaining the timeliness and accuracy of the member's information.

Member_Contact_Email_Key

Is Nullable: YES

Data Type: INT64

Description: Unique key identifying each email record associated with a member. Used for managing multiple email addresses and ensuring data integrity. Refer to the Dictionary Email Type table in the Dictionary Dataset Specification.

Member_Contact_Key

Is Nullable: YES

Data Type: STRING

Description: Unique key linking the email record to the member’s contact information within the healthcare system’s database.

Member_ID

Is Nullable: YES

Data Type: STRING

Description: Alphanumeric identifier assigned to the member by the Managed Care Organization (MCO), used to link email addresses to specific member profiles.

Address

Is Nullable: YES

Data Type: STRING

Description: The email address through which a member receives electronic communications. This can include personal, work, or other types of email addresses as defined in system settings.

Description

Is Nullable: YES

Data Type: STRING

Description: Describes the type of email address linked to the member, such as personal or work. Useful for distinguishing between different communications preferences. See Dictionary Email Type table for more details.

Preferred

Is Nullable: YES

Data Type: BOOL

Description: Indicates whether this email address is the preferred contact method for the member. This setting is important for prioritizing communication channels.

Created_Timestamp

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking when the email record was initially created, providing a timeline for when the member's contact information was added to the system.

Last_Modified_Timestamp

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the most recent update made to the email record, crucial for maintaining accurate and up-to-date contact information for the member.

Member_Contact_Phone_Key

Is Nullable: YES

Data Type: INT64

Description: Unique key identifying each phone record associated with a member. This key is used to manage multiple phone numbers and ensure accurate linkage to member records.

Member_Contact_Key

Is Nullable: YES

Data Type: STRING

Description: Unique key linking the phone record to the member’s contact information within the healthcare system’s database. This ensures all phone numbers are accurately associated with the correct member contact profiles.

Member_ID

Is Nullable: YES

Data Type: STRING

Description: Alphanumeric identifier assigned to the member by the Managed Care Organization (MCO). This ID links the phone number to the specific member profile, ensuring accurate communication records.

Number

Is Nullable: YES

Data Type: STRING

Description: The primary phone number used by the member, which could include personal, work, or other types of phone numbers based on the member's preference.

Description

Is Nullable: YES

Data Type: STRING

Description: Describes the type of the phone number, such as work/office, cell, or home. This classification helps in directing communication effectively.

Is Nullable: YES

Data Type: BOOL

Description: Indicates whether this phone number is the member's preferred contact method. Setting a number as preferred is crucial for ensuring that primary communication efforts use this number.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking when the phone record was created. This information is vital for tracking the addition of new contact numbers to a member's profile and for historical data integrity.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the most recent update made to the phone record. This timestamp is essential for tracking changes and maintaining up-to-date contact information for the member.

Is Nullable: YES

Data Type: INT64

Description: Unique key identifying each contact record associated with a member, used for database management and querying.

Is Nullable: YES

Data Type: STRING

Description: Alphanumeric identifier assigned to the member by the Managed Care Organization (MCO), linking the contact information to the member's profile.

Is Nullable: YES

Data Type: STRING

Description: Code indicating the member's preferred method of contact, such as email, phone, or mail. See Dictionary Preferred Contact Method table in the Dictionary Dataset Specification for valid values.

Is Nullable: YES

Data Type: STRING

Description: Description of the preferred contact method, explaining how and when to use each method for communicating with the member. See Dictionary Preferred Contact Method table for details.

Is Nullable: YES

Data Type: STRING

Description: Code representing the member's preferred time to be contacted, optimizing communication efforts. See Dictionary Preferred Contact Time table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Description of the preferred contact time, detailing suitable times during which the member wishes to be contacted. See Dictionary Preferred Contact Time table for more information.

Is Nullable: YES

Data Type: STRING

Description: Code that categorizes the member's type of association or relationship with the contact information. See Dictionary Member Contact Association table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Description of the association or relationship type, enhancing understanding of the contact's relevance. See Dictionary Member Contact Association table for detailed descriptions.

Is Nullable: YES

Data Type: STRING

Description: Additional contact information for the member that does not fit standard categories but is essential for comprehensive communication strategies.

Is Nullable: YES

Data Type: BOOL

Description: Indicates whether the contact information is the member's preferred choice. This setting is crucial for prioritizing communication channels.

Is Nullable: YES

Data Type: BOOL

Description: Flag indicating whether the member is currently active (1) or inactive (0) in the system. This is vital for maintaining up-to-date records and ensuring effective member management.

Is Nullable: YES

Data Type: STRING

Description: The first name of the member associated with the contact information, used for personalization and identification.

Is Nullable: YES

Data Type: STRING

Description: The middle name of the member, providing additional identification details that may be necessary for certain communications or legal documentation.

Is Nullable: YES

Data Type: STRING

Description: The last name of the member, crucial for full identification and formal communication purposes.

Is Nullable: YES

Data Type: STRING

Description: Prefix or title used before the member's name to denote formal address or social status, such as Dr., Mr., Mrs., etc.

Is Nullable: YES

Data Type: STRING

Description: Suffix or title used after the member's name to denote qualifications, generational suffixes, or honors, such as Jr., Sr., Ph.D., etc.

Is Nullable: YES

Data Type: STRING

Description: Code representing the time zone in which the member is located, utilized for scheduling and timing of communications. See Dictionary Timezone table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Abbreviation of the member's time zone, reflecting their geographic location's standard time offset. See Dictionary Timezone table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: System code for the time zone applicable to the member's location, aiding in time-sensitive operations and communication. See Dictionary Timezone table for details.

Is Nullable: YES

Data Type: STRING

Description: Name of the time zone associated with the member's geographic location, facilitating appropriate timing for services and communications. See Dictionary Timezone table for comprehensive details.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking when the contact record was initially created, providing a timeline for when the member's contact information was added to the system.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the most recent update made to the contact record, essential for maintaining the timeliness and accuracy of the member's contact information.

Is Nullable: YES

Data Type: INT64

Description: Unique key assigned to each custom field associated with a member. This key is used for identification and retrieval of custom field data within the system.

Is Nullable: YES

Data Type: INT64

Description: Unique key identifying the selection options available for a custom field, linking it to predefined choices in the system.

Is Nullable: YES

Data Type: STRING

Description: Alphanumeric identifier assigned to the member by the Managed Care Organization (MCO), used to link the custom fields specifically to the member's record.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the custom field within the healthcare management system.

Is Nullable: YES

Data Type: STRING

Description: The human-readable name for the custom field, designed to be easily understood and referenced within the healthcare system.

Is Nullable: YES

Data Type: STRING

Description: Specifies the application type of the custom field; 'ENTRY' for direct input fields, and 'SELECT' for fields requiring selection from predefined options.

Is Nullable: YES

Data Type: STRING

Description: The content or data stored in the custom field for the member. This can vary from textual entries to selections made from a set list, depending on the field type.

Is Nullable: YES

Data Type: STRING

Description: Description of the value held in the custom field, providing context or additional details about the selected options for fields of type 'SELECT'.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking when the custom field was initially created. This helps in tracking the addition of new custom fields to a member's profile.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the most recent modification made to the custom field, crucial for tracking updates and maintaining current data.

Is Nullable: YES

Data Type: INT64

Description: Unique key identifying each specific diagnosis associated with a member, used for tracking and management within the healthcare system.

Is Nullable: YES

Data Type: STRING

Description: Alphanumeric identifier assigned to the member by the Managed Care Organization (MCO), linking the diagnosis to the member's healthcare record.

Is Nullable: YES

Data Type: STRING

Description: Categorization of the diagnosis based on the condition or disease group, aiding in treatment planning and statistical analysis.

Is Nullable: YES

Data Type: STRING

Description: Detailed description of the condition category, providing further insight into the type of health issue classified under the diagnosis. This includes proprietary classifications used by Care Intelligence.

Is Nullable: YES

Data Type: STRING

Description: The coding system used for documenting the diagnosis, such as ICD-10, helping standardize diagnoses across the healthcare industry.

Is Nullable: YES

Data Type: STRING

Description: Explanation of the coding scheme used, which may include details on its application and relevance to different health conditions.

Is Nullable: YES

Data Type: STRING

Description: Specific code assigned to the diagnosis according to the coding scheme employed, such as 'F41.9' for a particular mental health condition.

Is Nullable: YES

Data Type: STRING

Description: Narrative description of the diagnosis, providing details about the member’s specific condition or symptoms.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking when the diagnosis record was initially created, important for historical data and tracking the onset of conditions.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the most recent update made to the diagnosis record, crucial for maintaining up-to-date and accurate medical information.

Is Nullable: YES

Data Type: STRING

Description: Unique key assigned to each email record associated with a member, used for identifying and managing email information within the system.

Is Nullable: YES

Data Type: STRING

Description: Alphanumeric identifier assigned to the member by the Managed Care Organization (MCO), linking the email to the member's healthcare profile.

Is Nullable: YES

Data Type: STRING

Description: Categorization of the email address by its intended use, such as personal or work. Refer to the Dictionary Email Type table in the Dictionary Dataset Specification for valid values.

Is Nullable: YES

Data Type: STRING

Description: Description of the email type, providing further details on how the email is used, for example, personal or work purposes. See Dictionary Email Type table for more details.

Is Nullable: YES

Data Type: STRING

Description: The email address used by the member, facilitating electronic communications related to health services and care management.

Is Nullable: YES

Data Type: BOOL

Description: Indicates whether this email address is the preferred contact method for the member, important for prioritizing communication channels.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking when the email address record was created in the system, providing a reference for tracking changes and updates.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the most recent modification made to the email record, essential for maintaining accurate and up-to-date member information.

Is Nullable: YES

Data Type: STRING

Description: Unique key for the member’s enrollment record, used to identify and manage enrollment details within the Care Intelligence system. Null if data is not sourced from Care Intelligence.

Is Nullable: YES

Data Type: STRING

Description: Key used specifically for reporting and analysis purposes, associated with the member’s enrollment data.

Is Nullable: YES

Data Type: STRING

Description: Alphanumeric identifier assigned to the member by the Managed Care Organization (MCO), linking the enrollment record to the specific member.

Is Nullable: YES

Data Type: STRING

Description: Identifier for the group under which the member is enrolled. This is defined by the customer’s eligibility system and may vary based on the group’s specific requirements and restrictions.

Is Nullable: YES

Data Type: STRING

Description: The name of the group to which the member is currently assigned, as defined in the eligibility system of the healthcare provider.

Is Nullable: YES

Data Type: STRING

Description: Identifier for the member’s specific enrollment plan, used for managing health services and coverage details.

Is Nullable: YES

Data Type: STRING

Description: Descriptive details about the plan under which the member is enrolled, explaining coverage, benefits, and limitations.

Is Nullable: YES

Data Type: STRING

Description: Categorization of the member’s enrollment based on the line of business, such as Medicaid, Medicare, or Commercial.

Line_Of_Business_Description

Is Nullable: YES

Data Type: STRING

Description: Code identifying the line of business under which the member’s plan falls, which helps in categorizing and managing different types of plans based on their nature and provided benefits.

Additional Information: Description of the line of business, providing more detailed information on the nature of the business and the associated services. See Dictionary Line Of Business table in the Dictionary Dataset Specification.

Effective_Date

Is Nullable: YES

Data Type: DATE

Description: The date on which the member’s enrollment in the plan becomes effective, marking the start of coverage.

Termination_Date

Is Nullable: YES

Data Type: DATE

Description: The date on which the member’s enrollment in the plan is scheduled to end or has ended, marking the cessation of coverage.

Carrier

Is Nullable: YES

Data Type: STRING

Description: Identifier for the insurance carrier underwriting the member’s plan at the time of enrollment.

Additional Information: See Dictionary Carrier table in the Dictionary Dataset Specification.

Carrier_Description

Is Nullable: YES

Data Type: STRING

Description: Description of the carrier providing the insurance coverage, detailing the carrier’s role and significance in the plan.

Additional Information: See Dictionary Carrier table in the Dictionary Dataset Specification.

Relationship

Is Nullable: YES

Data Type: STRING

Description: Code that describes the member’s relationship to the primary subscriber of the plan, such as dependent, self, or spouse.

Additional Information: See Dictionary Relationship table in the Dictionary Dataset Specification.

Relationship_Description

Is Nullable: YES

Data Type: STRING

Description: Detailed description of the member’s relationship to the primary subscriber, providing context for eligibility and coverage terms.

Additional Information: See Dictionary Relationship table in the Dictionary Dataset Specification.

Subscriber_ID

Is Nullable: YES

Data Type: STRING

Description: Identifier assigned to the primary subscriber under which the member is enrolled, used for linking family or group plans.

Subscriber_Membership_ID

Is Nullable: YES

Data Type: STRING

Description: Membership ID assigned to the subscriber, under which the member’s coverage details are listed and managed.

Most_Recent_Primary_Enrollment_Indicator

Is Nullable: YES

Data Type: BOOL

Description: Indicator to denote if this enrollment record is the most recent primary enrollment for the member.

Current_Enrollment_Indicator

Is Nullable: YES

Data Type: BOOL

Description: Indicates whether the record represents the member’s current enrollment status, which is calculated based on real-time data.

Current_Primary_Enrollment_Indicator

Is Nullable: YES

Data Type: BOOL

Description: Indicates whether the record represents the member’s current primary enrollment status, which is calculated based on real-time data.

Waiting_Period_Days

Is Nullable: YES

Data Type: INT64

Description: The number of days constituting the waiting period before the member’s coverage becomes effective under the new plan.

Primary_Enrollment

Is Nullable: YES

Data Type: BOOL

Description: Indicates if the record pertains to the member’s primary insurance eligibility at present, including the effective and termination dates.

Source_Of_Payment

Is Nullable: YES

Data Type: STRING

Description: Code representing the primary source of payment for the member’s enrollment plan, such as private pay or government-funded.

Source_Of_Payment_Description

Is Nullable: YES

Data Type: STRING

Description: Descriptive information about the source of payment for the member’s coverage, providing insights into the financial arrangements.

Active

Is Nullable: YES

Data Type: BOOL

Description: Indicator showing whether the member’s enrollment is currently active, providing a quick reference for eligibility status.

Account_ID

Is Nullable: YES

Data Type: STRING

Description: Identifier for the member’s account under which the enrollment details are managed and billed.

Membership_ID

Is Nullable: YES

Data Type: STRING

Description: Unique membership identifier for the member within the healthcare system, used to track and manage individual health records and billing.

Payer_Coordinating_ID

Is Nullable: YES

Data Type: STRING

Description: ID used for coordination between different payers when multiple sources of payment are involved in the member’s coverage.

Employment_Status_Code

Is Nullable: YES

Data Type: STRING

Description: Code that describes the member’s current employment status, which can affect eligibility and coverage details.

Pharmacy_Benefit

Is Nullable: YES

Data Type: BOOL

Description: Indicates whether the member’s plan includes benefits for pharmaceuticals, important for coverage and cost management.

Medical_Benefit

Is Nullable: YES

Data Type: BOOL

Description: Indicates whether the member’s plan includes medical benefits, crucial for access to healthcare services.

Created_Timestamp

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp when the member’s enrollment record was created, important for historical data tracking and system updates.

Last_Modified_Timestamp

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp when the member’s enrollment record was last modified, essential for maintaining current and accurate enrollment information.

Member_Enrollment_Alert_Key

Is Nullable: YES

Data Type: STRING

Description: Unique key for identifying each enrollment alert associated with a member, facilitating tracking and management of alerts within the healthcare system.

Member_Enrollment_Key

Is Nullable: YES

Data Type: STRING

Description: Key linking the alert to the specific enrollment record of a member, used to identify the context of the alert within member data.

Member_Enrollment_Reporting_Key

Is Nullable: YES

Data Type: STRING

Description: Key used for reporting purposes related to specific enrollment alerts, enabling detailed tracking and analysis of alert conditions and statuses.

Member_ID

Is Nullable: YES

Data Type: STRING

Description: Alphanumeric identifier assigned to the member by the Managed Care Organization (MCO), linking the alert to the member’s profile.

Group_ID

Is Nullable: YES

Data Type: STRING

Description: Identifier for the group associated with the member’s enrollment at the time of the alert, used to categorize alerts by group affiliation.

Plan_ID

Is Nullable: YES

Data Type: STRING

Description: Identifier for the plan associated with the member’s enrollment at the time of the alert, aiding in identifying specific plan-related issues.

Is Nullable: YES

Data Type: STRING

Description: Identifier for the line of business under which the member’s plan falls at the time of the alert, useful for categorizing and managing alerts based on business segment.\ See Dictionary Line Of Business table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: DATE

Description: The date when the member’s enrollment (or the relevant condition triggering the alert) became effective, critical for timing and relevance of the alert.

Is Nullable: YES

Data Type: DATE

Description: The date when the member’s enrollment (or the condition associated with the alert) is scheduled to end, important for managing end of coverage or condition alerts.

Is Nullable: YES

Data Type: STRING

Description: Identifier used to signify specific situations requiring attention in member enrollment, such as Coordination of Benefits or Pharmacy Lock-in restrictions.\ Note: Selection of multiple alerts may result in data duplication in reporting.

Is Nullable: YES

Data Type: STRING

Description: Detailed description of the enrollment alert, outlining the nature and specifics of the situation that necessitated the alert.\ See Dictionary Enrollment Alert table in the Dictionary Dataset Specification for detailed descriptions.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking the creation of the enrollment alert record, essential for tracking when the alert was initiated and logged in the system.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the most recent update made to the enrollment alert record, crucial for maintaining up-to-date information on the alert’s status and resolution.

Is Nullable: YES

Data Type: INT64

Description: Unique identifier for each custom field associated with a member's enrollment, sourced from ACM when available; null if data is not sourced from ACM.

Is Nullable: YES

Data Type: STRING

Description: Key linking the custom field to a specific member enrollment record, allowing for detailed tracking and management of custom data fields within the enrollment process.

Is Nullable: YES

Data Type: INT64

Description: Key associated with the selection options of a custom field when the type is 'SELECT', enabling linking to predefined options in the system.

Is Nullable: YES

Data Type: STRING

Description: Custom reporting key used to aggregate or categorize enrollment data based on specific custom fields for enhanced reporting and analysis.

Is Nullable: YES

Data Type: STRING

Description: Alphanumeric identifier assigned to the member by the Managed Care Organization (MCO), linking the custom fields to the specific member’s enrollment record.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier used for reporting and managing specific custom fields within the member’s enrollment data, facilitating specific data operations.

Is Nullable: YES

Data Type: STRING

Description: The human-readable name for the custom field, designed to be easily understandable and referenced within the healthcare system for clarity and ease of use.

Is Nullable: YES

Data Type: STRING

Description: Specifies the application type of the custom field; 'ENTRY' for direct input fields, and 'SELECT' for fields requiring selection from predefined options, guiding user interaction.

Is Nullable: YES

Data Type: STRING

Description: The data or selection stored in the custom field for the member, which can vary from textual entries to selections made from a set list, depending on the field type.

Is Nullable: YES

Data Type: STRING

Description: Description of the value held in the custom field, providing context or additional details about the selected options or entered data, particularly for 'SELECT' type fields.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking when the custom field or its value was initially created within the system, providing a timeline for when data was added to the member's enrollment profile.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the most recent modification made to the custom field or its value, crucial for tracking changes and maintaining up-to-date and accurate information within the enrollment.

Is Nullable: YES

Data Type: INT64

Description: Unique identifier for each member’s network within the Accountable Care Model (ACM); null if the data is not sourced from ACM.

Is Nullable: YES

Data Type: STRING

Description: Key linking the network information specifically to a member's enrollment record, facilitating management and tracking within the healthcare system.

Is Nullable: YES

Data Type: STRING

Description: Reporting key used to aggregate or reference the member’s network-related data within reports and analyses.

Is Nullable: YES

Data Type: STRING

Description: Alphanumeric identifier assigned to the member by the Managed Care Organization (MCO), used to link network data to the member's healthcare record.

Is Nullable: YES

Data Type: STRING

Description: Identifier for the group associated with the member’s network enrollment, reflecting the organizational structure under which the member is covered.

Is Nullable: YES

Data Type: STRING

Description: Identifier for the specific plan associated with the member's network enrollment, detailing the coverage plan under which the member is insured.

Is Nullable: YES

Data Type: STRING

Description: Categorization of the member’s enrollment according to the line of business, which describes the type of service or coverage offered.\ See Dictionary Line Of Business table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: DATE

Description: The start date when the member’s network coverage became active, marking the beginning of the insurance coverage under the specific network.

Is Nullable: YES

Data Type: DATE

Description: The end date when the member’s network coverage is scheduled to terminate, marking the conclusion of the insurance coverage under the specific network.

Is Nullable: YES

Data Type: STRING

Description: Code that identifies the network associated with the member’s insurance coverage, used for administrative and tracking purposes within healthcare programs.

Is Nullable: YES

Data Type: STRING

Description: Name of the network associated with the member's insurance coverage, providing a clear and identifiable label for the network within administrative processes.

Is Nullable: YES

Data Type: DATE

Description: Date when the member's current insurance network coverage began, crucial for tracking eligibility and coverage periods within the network.

Is Nullable: YES

Data Type: DATE

Description: Date when the member's current insurance network coverage will end or has ended, important for managing transitions and ensuring continuity of care.

Is Nullable: YES

Data Type: BOOL

Description: Flag indicating whether the network is the member's primary network for insurance coverage, where 1 represents primary and 0 represents non-primary. This affects prioritization of claims and services.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking the creation of the network record within the member’s profile, used for data integrity and tracking the addition of network details.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the most recent modification made to the network record, essential for maintaining accurate and up-to-date network information.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for each provider associated with a member’s enrollment, used for tracking and managing provider data within the healthcare system.

Is Nullable: YES

Data Type: STRING

Description: Key linking the provider data specifically to a member's enrollment record, facilitating management and tracking of healthcare providers.

Is Nullable: YES

Data Type: STRING

Description: Reporting key used to categorize or reference the member’s provider data within reports and analyses, enhancing data utilization for performance monitoring and compliance tracking.

Is Nullable: YES

Data Type: STRING

Description: Identifier assigned to the member by the Managed Care Organization (MCO), linking the provider data to the member’s healthcare record.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the provider within the member's enrollment, used to distinguish between multiple providers within the healthcare system.

Is Nullable: YES

Data Type: STRING

Description: National Provider Identifier (NPI) for the provider, a unique identification number used in the U.S. for covered healthcare providers.

Is Nullable: YES

Data Type: STRING

Description: Type of provider, such as general practitioner or specialist, categorized to aid in the management and reporting of care services. See Dictionary Provider Type table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Description of the provider type, detailing the roles and responsibilities associated with different provider types. See Dictionary Provider Type table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Role of the provider within the member’s care plan, such as primary care provider or consultant. See Dictionary Enrollment Provider Role table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Detailed description of the provider’s role in the member’s healthcare, such as their specific duties or specialties. See Dictionary Enrollment Provider Role table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: DATE

Description: The date when the provider’s involvement in the member’s care officially begins, crucial for tracking provider changes and coverage periods.

Is Nullable: YES

Data Type: DATE

Description: The date when the provider’s involvement in the member’s care officially ends, important for historical data tracking and ensuring accurate records.

Is Nullable: YES

Data Type: BOOL

Description: Indicator showing whether this provider record is the most recent primary provider for the member, used for current status updates.

Is Nullable: YES

Data Type: BOOL

Description: Flag indicating whether this provider is currently active in the member’s care, essential for maintaining accurate and up-to-date healthcare records.

Is Nullable: YES

Data Type: STRING

Description: Entity delegated by the primary provider to perform certain healthcare services on behalf of the member. See Dictionary Delegate Entity table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: STRING

Description: Description of the delegate entity, explaining the nature of delegated services and responsibilities. See Dictionary Delegate Entity table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking when the provider record was initially created in the system, used for tracking and audit purposes.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the most recent modification made to the provider record, crucial for tracking changes and maintaining up-to-date information.

Is Nullable: YES

Data Type: STRING

Description: Identifier for the group under which the member was most recently primarily enrolled, reflecting the latest organizational context of the member’s insurance coverage.

Is Nullable: YES

Data Type: STRING

Description: Identifier for the healthcare plan under which the member was most recently primarily enrolled, detailing the specific coverage plan currently active or most recently active for the member.

Is Nullable: YES

Data Type: STRING

Description: Type of business under which the member’s most recent primary enrollment is categorized, which defines the nature of the healthcare services provided.

See Dictionary Line Of Business table in the Dictionary Dataset Specification.

Is Nullable: YES

Data Type: DATE

Description: The start date of the member’s most recent primary enrollment period, marking when the member’s current primary coverage began.

Is Nullable: YES

Data Type: DATE

Description: The end date of the member’s most recent primary enrollment period, marking when the member’s current primary coverage is scheduled to end or has ended.

Is Nullable: YES

Data Type: BOOL

Description: Indicates whether the record represents the member's most recent period of primary enrollment, used to determine primary coverage status.

Is Nullable: YES

Data Type: BOOL

Description: Indicates whether the member’s most recent primary enrollment is currently active, reflecting ongoing primary coverage.

Is Nullable: YES

Data Type: BOOL

Description: Indicator showing whether this enrollment record is the most recent instance of primary enrollment for the member, typically calculated during the data extraction and transformation process.

Is Nullable: YES

Data Type: STRING

Description: Unique key identifying each note entry associated with a member, used for tracking and management within the healthcare system.

Is Nullable: YES

Data Type: STRING

Description: Identifier linking the note to a specific member, ensuring that notes are correctly associated with member profiles.

Is Nullable: YES

Data Type: STRING

Description: Code indicating why a note was voided or considered irrelevant.

See Dictionary Note Void Reason table in the Dictionary Dataset Specification for valid codes.

Is Nullable: YES

Data Type: STRING

Description: Description of the void reason, providing context on why the note was voided.

See Dictionary Note Void Reason table in the Dictionary Dataset Specification for detailed descriptions.

Is Nullable: YES

Data Type: STRING

Description: Type of note, categorizing the content or purpose of the note within the member's record.

See Dictionary Note Type table in the Dictionary Dataset Specification for valid types.

Is Nullable: YES

Data Type: STRING

Description: Detailed description of the note type, explaining the context or intended use of the note.

See Dictionary Note Type table in the Dictionary Dataset Specification for details.

Is Nullable: YES

Data Type: STRING

Description: User ID of the individual who authored the note, linking responsibility to a specific user within the healthcare system.

Is Nullable: YES

Data Type: STRING

Description: Full name of the note's author, derived from the user ID, providing clear identification of who created the note.

Is Nullable: YES

Data Type: STRING

Description: User ID of the individual who voided the note, if applicable, linking the void action to a specific user.

Is Nullable: YES

Data Type: STRING

Description: Full name of the user who voided the note, derived from the void user ID, providing clear identification of who voided the note.

Is Nullable: YES

Data Type: STRING

Description: Actual text of the note, detailing observations, actions, or other relevant information about the member.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp indicating when the note was originally created, essential for tracking the timeline of documentation.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the last modification made to the note, crucial for maintaining an up-to-date record.

Is Nullable: YES

Data Type: BOOL

Description: Boolean flag indicating whether the note has been voided, used to manage the visibility and relevance of notes within the member's record.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking when the note was voided, if applicable, used to record the exact time when the note was deemed irrelevant or incorrect.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the member or patient.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp indicating when the opportunity score calculation was completed.

Is Nullable: YES

Data Type: STRING

Description: Identifier for the specific population group.

Is Nullable: YES

Data Type: STRING

Description: Description of the population group (e.g., high-risk, low-risk).

Is Nullable: YES

Data Type: STRING

Description: Type of population (e.g., clinical, demographic, etc.).

Is Nullable: YES

Data Type: STRING

Description: Severity level associated with the population (e.g., mild, moderate, severe).

Is Nullable: YES

Data Type: INT64

Description: Level of visibility or access control for the population data.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the member or patient.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp indicating when the opportunity score calculation was completed.

Is Nullable: YES

Data Type: STRING

Description: Identifier for the specific population group.

Population_ID

Is Nullable: YES

Data Type: STRING

Description: Identifier for the specific population group.

Population_Description

Is Nullable: YES

Data Type: STRING

Description: Description of the population group (e.g., high-risk, low-risk).

Population_Type

Is Nullable: YES

Data Type: STRING

Description: Type of population (e.g., clinical, demographic, etc.).

Population_Severity

Is Nullable: YES

Data Type: STRING

Description: Severity level associated with the population (e.g., mild, moderate, severe).

Type

Is Nullable: YES

Data Type: STRING

Description: Type of opportunity score (e.g., health-related, financial, etc.).

Tenant

Is Nullable: YES

Data Type: STRING

Description: Identifier for the specific tenant or organization.

Active_Version

Is Nullable: YES

Data Type: BOOL

Description: Version of the opportunity score data that is currently active.

Date

Is Nullable: YES

Data Type: DATE

Description: Date associated with the opportunity score data.

Sequence

Is Nullable: YES

Data Type: INT64

Description: Sequence number for the opportunity score data.

Source_System_Name

Is Nullable: YES

Data Type: STRING

Description: Name of the system or application that generated the opportunity score data.

Source_File_Name

Is Nullable: YES

Data Type: STRING

Description: Name of the file containing the opportunity score data.

Source_Timestamp

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp when the opportunity score data was generated.

Schema_Version

Is Nullable: YES

Data Type: FLOAT64

Description: Version of the schema or data model used for the opportunity score data.

Deleted_Indicator

Is Nullable: YES

Data Type: BOOL

Description: Indicator to mark whether the record has been deleted.

Member_Partition

Is Nullable: YES

Data Type: INT64

Description: Partition or segment of the member data (if applicable).

_updated

Is Nullable: YES

Data Type: STRING

Description: Timestamp indicating when the record was last updated.

Action

Is Nullable: YES

Data Type: STRING

Description: Description of the action associated with the opportunity score (e.g., recommendation, intervention).

Visibility_Level

Is Nullable: YES

Data Type: INT64

Description: Level of visibility or access control for the population data.

Member_ID

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the member or patient.

Finish_Timestamp

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp indicating when the opportunity score calculation was completed.

Population_ID

Is Nullable: YES

Data Type: STRING

Description: Identifier for the specific population group.

Population_Description

Is Nullable: YES

Data Type: STRING

Description: Description of the population group (e.g., high-risk, low-risk).

Population_Type

Is Nullable: YES

Data Type: STRING

Description: Type of population (e.g., clinical, demographic, etc.).

Population_Severity

Is Nullable: YES

Data Type: STRING

Description: Severity level associated with the population (e.g., mild, moderate, severe).

Type

Is Nullable: YES

Data Type: STRING

Description: Type of opportunity score (e.g., health-related, financial, etc.).

Tenant

Is Nullable: YES

Data Type: STRING

Description: Identifier for the specific tenant or organization.

Active_Version

Is Nullable: YES

Data Type: BOOL

Description: Version of the opportunity score data that is currently active.

Date

Is Nullable: YES

Data Type: DATE

Description: Date associated with the opportunity score data.

Sequence

Is Nullable: YES

Data Type: INT64

Description: Sequence number for the opportunity score data.

Source_System_Name

Is Nullable: YES

Data Type: STRING

Description: Name of the system or application that generated the opportunity score data.

Source_File_Name

Is Nullable: YES

Data Type: STRING

Description: Name of the file containing the opportunity score data.

Source_Timestamp

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp when the opportunity score data was generated.

Schema_Version

Is Nullable: YES

Data Type: FLOAT64

Description: Version of the schema or data model used for the opportunity score data.

Deleted_Indicator

Is Nullable: YES

Data Type: BOOL

Description: Indicator to mark whether the record has been deleted.

Member_Partition

Is Nullable: YES

Data Type: INT64

Description: Partition or segment of the member data (if applicable).

_updated

Is Nullable: YES

Data Type: STRING

Description: Timestamp indicating when the record was last updated.

Action

Is Nullable: YES

Data Type: STRING

Description: Description of the action associated with the opportunity score (e.g., recommendation, intervention).

Visibility_Level

Is Nullable: YES

Data Type: INT64

Description: Level of visibility or access control for the population data.

Member_Phone_Key

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for each phone record associated with a member, used for tracking and managing phone data within the healthcare system.

Member_ID

Is Nullable: YES

Data Type: STRING

Description: Alphanumeric identifier assigned to the member by the Managed Care Organization (MCO), linking the phone record to the member’s healthcare profile.

Type

Is Nullable: YES

Data Type: STRING

Description: Type of phone number, such as home, mobile, or work, categorizing the number for specific uses and accessibility.

Type_Description

Is Nullable: YES

Data Type: STRING

Description: Description of the phone number type, providing additional details about the intended use or context of the phone number.

Number

Is Nullable: YES

Data Type: STRING

Description: The actual phone number associated with the member, used for communication and contact purposes.

Preferred

Is Nullable: YES

Data Type: BOOL

Description: Indicates whether the phone number is the preferred contact method for the member.

Is Nullable: YES

Data Type: BOOLEAN

Description: Indicates whether this phone number is the member's preferred contact method, prioritizing it for communications from the healthcare provider.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking when the phone record was initially created, important for tracking the addition of contact methods to a member's profile.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp of the most recent update made to the phone record, essential for maintaining current and accurate contact information.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the execution of a population batch in which the member participated, used to track individual engagements in population health management activities.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for a population matching batch execution, serving as a logical foreign key to the Populations_Execution table, indicating specific population processing instances.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking the completion of the population match batch in which the member's data was processed, essential for data partitioning and maintenance within the system.

Is Nullable: NO

Data Type: DATE

Description: Array of dates documenting each time the member’s data was matched against population criteria, used for tracking and historical reference.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the member involved in the population match, linking the population data to the specific member’s healthcare record.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the population to which the member was matched, also encompassing version information to specify the particular criteria or definition version of the population.

Is Nullable: YES

Data Type: STRING

Description: Human-readable name for the population, provided with the population definition, used for easier identification and reporting.

Is Nullable: YES

Data Type: STRING

Description: Program code associated with the population, indicating the specific ACM program tied to the population, if applicable. This field is optional, reflecting plans for populations without program ties.

Is Nullable: NO

Data Type: STRING

Description: Array of version strings for the population definition, detailing revisions or updates to the population criteria over time, essential for historical tracking and compliance verification.

Is Nullable: YES

Data Type: STRING

Description: User identifier for the last person who modified the population matching record, ensuring traceability and accountability within population management.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp for the last modification made to the population matching record, crucial for maintaining an accurate and current database.

Is Nullable: YES

Data Type: STRING

Description: Code indicating the severity level assigned to the population match, which can be 'L' (Low), 'M' (Medium), or 'H' (High), based on defined criteria and calculated during batch processing.

Is Nullable: YES

Data Type: STRING

Description: Description of the severity level, translating codes into full descriptions such as LOW, MEDIUM, or HIGH, providing clear context for severity assessments within population health management.

Is Nullable: YES

Data Type: STRING

Description: Code identifying the type of care gap associated with the population, which defines the specific healthcare needs or shortcomings addressed by the population criteria.

Is Nullable: YES

Data Type: STRING

Description: Detailed description of the gap in care type, enriched by looking up definitions by codes to provide a comprehensive understanding of the care gap associated with the population match.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the execution of a population match operation within a specific batch, tracking individual member processing events.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for a batch execution of a population matching process, corresponding to a specific population management task.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the tenant under which the population match log is recorded, ensuring data segmentation and security within multi-tenant systems.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking the completion of the population matching process for the batch, essential for tracking end times and supporting system maintenance and data partitioning.

Is Nullable: YES

Data Type: DATE

Description: Date when the population match log entry was recorded, used for historical tracking and reporting purposes.

Is Nullable: YES

Data Type: STRING

Description: Identifier for the member whose data was processed in the population matching log, linking the log entry to a specific individual within the healthcare system.

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the population against which the member was matched, including version information to specify the criteria version at the time of matching.

Is Nullable: YES

Data Type: STRING

Description: Human-readable name of the population involved in the matching process, aiding in identification and reporting.

Is Nullable: YES

Data Type: STRING

Description: Code associated with the healthcare program to which the population match is related, if applicable, indicating programmatic contexts of the population health initiatives.

Is Nullable: YES

Data Type: STRING

Description: Version information of the population criteria used in the match, essential for tracking changes and updates in population definitions over time.

Is Nullable: YES

Data Type: STRING

Description: User identifier for the last person who modified the population match log entry, ensuring traceability and accountability.

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp for the last modification made to the population match log entry, crucial for maintaining an accurate and current database.

Modified_By

Is Nullable: YES

Data Type: STRING

Description: User identifier for the last person who modified the population match log, ensuring accountability and traceability within the system.

Modified_At

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp for the last modification made to the population match log entry, crucial for maintaining an accurate and current log of population matching activities.

Severity_Code

Is Nullable: YES

Data Type: STRING

Description: Code indicating the severity of the population match, which could be L (Low), M (Medium), or H (High), used for prioritizing interventions and managing healthcare responses.

Severity_Description

Is Nullable: YES

Data Type: STRING

Description: Detailed description of the severity level associated with the population match, providing full textual representations such as LOW, MEDIUM, or HIGH.

Visibility_Level

Is Nullable: YES

Data Type: STRING

Description: Code defining the visibility level of the population data within the system, ranging from 1 (Always visible) to 4 (Never visible), essential for managing data access and confidentiality.

Visibility_Level_Description

Is Nullable: YES

Data Type: STRING

Description: Description of the visibility level, providing a detailed explanation of access restrictions for the population data based on predefined settings.

Gap_In_Care_Type

Is Nullable: YES

Data Type: STRING

Description: Code identifying the type of care gap the population match addresses, crucial for targeted healthcare interventions and management.

Gap_In_Care_Type_Description

Is Nullable: YES

Data Type: STRING

Description: Detailed description of the care gap type, enriched by a lookup of rule codes to provide a comprehensive understanding of the healthcare needs the population match is designed to address.

Member_Partition

Is Nullable: YES

Data Type: INT64

Description: System partition used for storing the population match log, facilitating efficient data management and retrieval within distributed systems.

_updated

Is Nullable: YES

Data Type: STRING

Description: Field indicating when the population match log was last updated, used for system audits and data synchronization checks.

Action

Is Nullable: YES

Data Type: STRING

Description: Action taken in the population match log, such as 'create', 'update', or 'delete', providing an audit trail for actions performed on the log entries.

Visibility_Level_Int

Is Nullable: YES

Data Type: INT64

Description: Internal code defining the visibility level of the population data within the system.

Parent_Type

Is Nullable: YES

Data Type: STRING

Description: Type of parent entity associated with this member populations match.

Member_Populations_Execution_ID

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the execution of a population match operation within a specific batch, tracking individual member processing events.

Population_Execution_ID

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for a batch execution of a population matching process, corresponding to a specific population management task.

Tenant

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the tenant under which the population match log is recorded, ensuring data segmentation and security within multi-tenant systems.

Finish_Timestamp

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking the completion of the population matching process for the batch, essential for tracking end times and supporting system maintenance and data partitioning.

Date

Is Nullable: YES

Data Type: DATE

Description: Date when the population match log entry was recorded, used for historical tracking and reporting purposes.

Member_ID

Is Nullable: YES

Data Type: STRING

Description: Identifier for the member whose data was processed in the population matching log, linking the log entry to a specific individual within the healthcare system.

Population_ID

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the population against which the member was matched, including version information to specify the criteria version at the time of matching.

Population_Name

Is Nullable: YES

Data Type: STRING

Description: Human-readable name of the population involved in the matching process, aiding in identification and reporting.

Program_Code

Is Nullable: YES

Data Type: STRING

Description: Code associated with the healthcare program to which the population match is related, if applicable, indicating programmatic contexts of the population health initiatives.

Version

Is Nullable: YES

Data Type: STRING

Description: Version information of the population criteria used in the match, essential for tracking changes and updates in population definitions over time.

Modified_By

Is Nullable: YES

Data Type: STRING

Description: User identifier for the last person who modified the population match log, ensuring accountability and traceability within the system.

Modified_At

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp for the last modification made to the population match log entry, crucial for maintaining an accurate and current log of population matching activities.

Severity_Code

Is Nullable: YES

Data Type: STRING

Description: Code indicating the severity of the population match, which could be L (Low), M (Medium), or H (High), used for prioritizing interventions and managing healthcare responses.

Severity_Description

Is Nullable: YES

Data Type: STRING

Description: Detailed description of the severity level associated with the population match, providing full textual representations such as LOW, MEDIUM, or HIGH.

Visibility_Level

Is Nullable: YES

Data Type: STRING

Description: Code defining the visibility level of the population data within the system, ranging from 1 (Always visible) to 4 (Never visible), essential for managing data access and confidentiality.

Visibility_Level_Description

Is Nullable: YES

Data Type: STRING

Description: Description of the visibility level, providing a detailed explanation of access restrictions for the population data based on predefined settings.

Gap_In_Care_Type

Is Nullable: YES

Data Type: STRING

Description: Code identifying the type of care gap the population match addresses, crucial for targeted healthcare interventions and management.

Gap_In_Care_Type_Description

Is Nullable: YES

Data Type: STRING

Description: Detailed description of the care gap type, enriched by a lookup of rule codes to provide a comprehensive understanding of the healthcare needs the population match is designed to address.

Member_Partition

Is Nullable: YES

Data Type: INT64

Description: System partition used for storing the population match log, facilitating efficient data management and retrieval within distributed systems.

_updated

Is Nullable: YES

Data Type: STRING

Description: Field indicating when the population match log was last updated, used for system audits and data synchronization checks.

Visibility_Level_Int

Is Nullable: YES

Data Type: INT64

Description: Internal code defining the visibility level of the population data within the system.

Parent_Type

Is Nullable: YES

Data Type: STRING

Description: Type of parent entity associated with this member populations match.

Program_Matching_Execution_ID

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for each execution of the program matching process, generated at the start and used to track the specific matching operation.

Population_Execution_ID

Is Nullable: YES

Data Type: STRING

Description: Identifier for the population execution used as input for the program matching, linking the program match to specific population criteria.

Execution_Start_Timestamp

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp marking the start of the program matching process for the member, used for logging and data partitioning.

Step_ID

Is Nullable: YES

Data Type: INT64

Description: Identifier for the specific step within the program matching process, such as deduplication or blocking, with each step assigned a sequential number.

Step_Name

Is Nullable: YES

Data Type: STRING

Description: Name of the step in the program matching process, describing the function of each step like "Deduplication", "Blocking", etc., based on the matching configuration.

Member_ID

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the member whose data is being processed in the program matching, obtained from the initial population matching process.

Program_Code

Is Nullable: YES

Data Type: STRING

Description: Code identifying the specific program to which the member might be matched, obtained through the population matching process and relevant to program assignment decisions.

Severity

Is Nullable: YES

Data Type: STRING

Description: Level of severity associated with the member’s condition or situation, initially obtained from population matching or calculated in earlier steps of the process.

Pass_Indicator

Is Nullable: YES

Data Type: BOOL

Description: Indicator showing whether the member passed this step in the matching process; true if passed, false if skipped.

Skip_Reason

Is Nullable: YES

Data Type: STRING

Description: Description or debug information explaining why a member's record was skipped at a particular step, populated only when Pass_Indicator is false.

Rank

Is Nullable: YES

Data Type: INT64

Description: Ranking used to prioritize member enrollment into the program, with 1 representing the highest priority; null for members not eligible for enrollment.

Date

Is Nullable: NO

Data Type: DATE

Description: Array of dates documenting when the program matching operations were performed for this member, used for historical tracking and analysis.

Version

Is Nullable: NO

Data Type: STRING

Description: Versions of the program matching criteria or configurations used during the matching process, important for audit trails and understanding changes over time.

Modified_By

Is Nullable: YES

Data Type: STRING

Description: Identifier for the user who last modified the program matching record, ensuring accountability and traceability within the system.

Modified_At

Is Nullable: YES

Data Type: TIMESTAMP

Description: Timestamp for the last modification made to the program matching record, essential for maintaining up-to-date and accurate matching records.

Program_Matching_Execution_ID

Is Nullable: YES

Data Type: STRING

Description: Unique identifier for the execution of a program matching operation, tracking each process instance for program matching within the healthcare management system.

Population_Execution_ID

Is Nullable: YES