BND_EPSD_INCL_VISITS

Description: |
This table stores the list of patient contacts that should be billed as part of a bundled episode.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
EPISODE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | EPISODE_ID | NUMERIC | No |
This column stores the unique identifier for the bundled episode record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | VISIT_CSN | NUMERIC | No |
The contact serial number of the patient contact that should be billed as part of the bundled episode.
4 | BND_EPSD_VISIT_SRC_C_NAME | VARCHAR | No |
This column stores the category ID of the source that indicated that the associated visit should be billed as part of the bundled episode.
May contain organization-specific values: No
Category Entries:
Clinical
Billing Manual Override
Link Automation
Link Automation, Manual Clinical
5 | VISIT_UPDATE_USER_ID | VARCHAR | No |
This column stores the unique identifier for the user who last associated the visit that should be billed as part of the bundled episode.
6 | VISIT_UPDATE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | VISIT_UPDATE_DTTM | DATETIME (UTC) | No |
The date and time that the user last associated the visit that should be billed as part of the bundled episode.
8 | DEFINES_CLIN_LINK_YN | VARCHAR | No |
Indicates whether the billing link is the reason the episode is linked on the clinical side (i.e. it hasn't ever been linked or unlinked directly from the clinical side)
May contain organization-specific values: No
Category Entries:
No
Yes