HEALTH_CARE_AGENT_HX

Description:

This table records a history of HCA (Health Care Agent) status changes documented in SEC_ACP_HEALTH_CARE_AGENTS (LVN 44200). Whenever an agent is activated or deactivated, information about the agent is stored in this table.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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	ACTIVE_STATUS_YN_NAME	VARCHAR	No
	This column displays a history of health care agent status changes. 1 indicates that the agent was activated. 0 indicates that the agent was deactivated. May contain organization-specific values: No Category Entries: No Yes
4	USER_ID	VARCHAR	No
	This column displays the user ID (EMP ID) of the user who documented the change of status for the agent.
5	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	UTC_INST_DTTM	DATETIME (UTC)	No
	This column displays the UTC instant that the change of status for the agent was documented.
7	AGENT_UID	VARCHAR	No
	This column displays an ID which uniquely identifies which emergency contact stores info about the agent.
8	AGENT_NAME	VARCHAR	No
	This column displays the name of the Health Care Agent.
9	RELATIONSHIP_PERSONAL_C_NAME	VARCHAR	No
	This column displays the personal relationship between the Health Care Agent and the patient at the time of the status change. May contain organization-specific values: Yes
10	RELATIONSHIP_AGENT_TYP_C_NAME	VARCHAR	No
	This column displays what type of Health Care Agent relationship existed between the agent and the patient at the time of the status change. (Examples: Health Care Agent, First Alternate Health Care Agent, Second Alternate Health Care Agent.) May contain organization-specific values: Yes Category Entries: Health Care Agent First Alternate Health Care Agent Second Alternate Health Care Agent
11	PHONE_PRIMARY_C_NAME	VARCHAR	No
	This column displays the primary or preferred phone number on file for the agent at the time of the status change. May contain organization-specific values: No Category Entries: Home phone Work phone Mobile phone
12	PHONE_HOME	VARCHAR	No
	This column displays the home phone number on file for the agent at the time of the status change.
13	PHONE_WORK	VARCHAR	No
	This column displays the work phone number on file for the agent at the time of the status change.
14	PHONE_MOBILE	VARCHAR	No
	This column displays the mobile or cellular phone number on file for the agent at the time of the status change.