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.