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
Electronic Authorization Message
Suppress Result Routing
Payer Platform Notification
Internal Payer Notification
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_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of 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.