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:
Invited
Revoked
Verified
Invite Canceled
Invite Declined
Invite Resent
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
User Doesn't Know Guarantor
User Doesn't Want Access
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
10 | BILL_ACCS_INV_CODE | VARCHAR | No |
History item tracking the invite code when tracking an invite from MyChart
11 | BILL_ACCS_INV_STS_C_NAME | VARCHAR | No |
History item to track the invite status when a tracking an invite from MyChart or Hyperspace
May contain organization-specific values: No
Category Entries:
Sent
Confirmed
Declined
Attempted
Failed
Inactive
Expired
Revoked