RX_ENROLLMENTS_HX

Description: |
This table contains an audit trail history for edits made to a pharmacy enrollment.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SUMMARY_BLOCK_ID | NUMERIC | No |
The unique identifier for the summary block 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 | RXENROLL_EDIT_USER_ID | VARCHAR | No |
The unique identifier for the user record who updated the pharmacy enrollment for a given edit.
4 | RXENROLL_EDIT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | RXENROLL_EDIT_DTTM | DATETIME (Local) | No |
The instant the pharmacy enrollment was updated on this edit
6 | ENROLL_PROG_C_NAME | VARCHAR | No |
The enrollment program category ID for the pharmacy enrollment on this edit
May contain organization-specific values: Yes
7 | RXENROLL_STATUS_C_NAME | VARCHAR | No |
The enrollment status category ID for this enrollment on this edit.
May contain organization-specific values: No
Category Entries:
Under Review
Enrolled
Disenrolled
Declined
Deleted
8 | RXENROLL_ENROLLMENT_DATE | DATETIME | No |
The enrollment start date documented for this enrollment on this edit
9 | RXENROLL_DISENROLL_DATE | DATETIME | No |
The disenrollment date documented on the enrollment on this edit
10 | RXENROLL_DECLINE_DATE | DATETIME | No |
The decline date documented on the enrollment on this edit