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
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