PAT_MYC_ACSS_TRK

Description:

This table keeps an audit trail of changes made to the status of a web based chart system account.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique identifier for the patient record. This ID may be encrypted if you have elected to use enterprise reporting’s security utility.
2	LINE	INTEGER	No
	The line number used to identify each row of access data associated with an individual patient record.
3	MYC_ACSS_USER_ID	VARCHAR	No
	This column stores the unique identifier for the user record who performed some action regarding the patient's web based chart system account.
4	MYC_ACSS_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	MYC_ACSS_ACTION_C_NAME	VARCHAR	No
	The category value corresponding to the action that was performed on the patient's web based chart system account. May contain organization-specific values: No Category Entries: ENABLE DISABLE DELETECODE Enable for proxy Disable for proxy Activate Patient
6	ACSS_TIMESTAMP	DATETIME (Local)	No
	This is a timestamp indicating when the patient's web based chart system account was changed.
7	ACSS_PROXY_CMT	VARCHAR	No
	The comment, if one was entered, when an account was activated for proxy use.
8	MYC_ACSS_CODE	VARCHAR	No
	This stores the access code that was generated for an activation action performed on the patient's web based chart system account.