GUAR_PAT_BILLING_ACSS_HX

Description: |
This table keeps an audit trail of changes made to the list of MyChart accounts that have billing access to the guarantor account. Every time an account is added or revoked, a row will be added to this table.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ACCT_ID | NUMERIC | No |
The unique identifier (.1 item) for the guarantor 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 | BILL_ACSS_MYPT_ID | VARCHAR | No |
Item to store history for MyChart accounts that have billing access to the guarantor account
4 | BILL_ACSS_ACTION_C_NAME | VARCHAR | No |
The action associated with changes to MyChart accounts that have billing access to the guarantor account
May contain organization-specific values: No
Category Entries:
Added
Revoked
5 | BILL_ACSS_USER_ID | VARCHAR | No |
EMP ID of user who added or revoked a MyChart account that has billing access to the guarantor account
6 | BILL_ACSS_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | BILL_ACSS_INST_UTC_DTTM | DATETIME (UTC) | No |
The action time instant associated with changes to MyChart accounts that have billing access to the guarantor account
8 | BILL_ACSS_REV_RSN_C_NAME | VARCHAR | No |
Item to store the reason for revocation whenever an end user manually revokes a MyChart account that has billing access to the guarantor account
May contain organization-specific values: Yes
Category Entries:
Wrong User Chosen
Patient Requested
Other
Removed By Guarantor
9 | BILL_ACSS_REV_CMT | VARCHAR | No |
Item to store the comment entered whenever an end user manually revokes a MyChart account that has billing access to the guarantor account