LCA_COMM_USERS
Description:
Table contains information regarding the sender of a communication and the recipients of the communication. In a record the 1st entry is assumed to be the sender, subsequent entries are the recipients.

Primary Key
Column Name Ordinal Position
COMMUNICATION_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 COMMUNICATION_ID NUMERIC No
LCA routing record id
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 COMM_NAME VARCHAR No
Name of the sender/recipient
4 COMM_INI VARCHAR No
INI of the sender/recipient
5 COMM_ID_USER VARCHAR No
ID the sender/recipient
6 FAX_NUM VARCHAR No
fax number of the sender/recipient that communication would be sent to if a fax method was used to send the communication
7 PHONE_NUM VARCHAR No
phone number of the sender/recipient
8 ADDRESS VARCHAR No
address of the sender/recipient that communication would be sent to if a mailing method was used to send the communication
9 CITY VARCHAR No
city of the sender/recipient that communication would be sent to if a mailing method was used to send the communication
10 STATE VARCHAR No
state of the sender/recipient that communication would be sent to if a mailing method was used to send the communication
11 ZIP_CODE VARCHAR No
zip code of the sender/recipient that communication would be sent to if a mailing method was used to send the communication
12 COUNTRY VARCHAR No
country of the sender/recipient that communication would be sent to if a mailing method was used to send the communication
13 SENT_METHOD_C_NAME VARCHAR No
The Send Method category number for the communication.
May contain organization-specific values: Yes
Category Entries:
In Basket
Fax
Mail
Phone Call
MyChart
Network Printer
Courier Service
Outside Provider Messaging
Print Locally
EDI
Opt Out
E-mail
FHIR
Save to File
Outside Authorization Message
Suppress Result Routing
14 FILE_CREATED_YN VARCHAR No
Indicates if a file was created for that recipient. If so can look in attachments at blob columns for the file name.
May contain organization-specific values: No
Category Entries:
No
Yes
15 EMAIL VARCHAR No
email address of the sender/recipient
16 HOUSE_NUM VARCHAR No
House number of the sender/recipient that communication would be sent to if mailing method was used to send communication.
17 DISTRICT_C_NAME VARCHAR No
District of the sender/recipient that communication would be sent to if mailing method was used to send the communication.
May contain organization-specific values: Yes
18 COUNTY_C_NAME VARCHAR No
County of the sender/recipient that communication would be sent to if mailing method was used to send the communication.
May contain organization-specific values: Yes
19 COMM_USER_ID VARCHAR No
The unique ID associated with the user record for this communication if COMM_INI is EMP. This column is frequently used to link to the CLARITY_EMP table.
20 COMM_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
21 COMM_PROV_ID VARCHAR No
The unique ID associated with the provider record for this communication if COMM_INI is SER. This column is frequently used to link to the CLARITY_SER table.
22 COMM_PAT_ID VARCHAR No
The unique ID associated with the patient record for this communication if COMM_INI is EPT. This column is frequently used to link to the PATIENT table.
23 ORGANIZATION_ID NUMERIC No
The unique ID associated with the organization record for this communication if COMM_INI is DXO. This column is frequently used to link to the ORG_DETAILS table.
24 ORGANIZATION_ID_EXTERNAL_NAME VARCHAR No
Organization's external name used as the display name on forms and user interfaces.
25 COMM_REG_ID NUMERIC No
The unique ID associated with the pool record for this communication if COMM_INI is HIP. This column is frequently used to link to the CLARITY_HIP table.
26 COMM_REG_ID_REGISTRY_NAME VARCHAR No
The name of the In Basket registry in the HIP master file.
27 CONSENT_DOC_INFO_ID VARCHAR No
DCS record that contains patient consent for sending the communication to this recipient.
28 COMM_CE_SUB_MTHD_C_NAME VARCHAR No
The sub-routing method category ID for the communication.
May contain organization-specific values: No
Category Entries:
None
Outgoing Direct Address
EpicCare Link Direct Address
MedCom
PCEHR
Kanta
Pika XML
29 SENT_DIRECT_ADDRESS VARCHAR No
The address level Direct address of the recipient to whom the communication is routed.