LCA_COMM_ATTACH
Description:
This table contains information regarding attachments sent in a communication routing job. Information includes the report ID of the report sent, the letter ID of a letter sent, a file name if a blob server was used, the attachment description, the attachment name and the ID of the fax report sent.

Primary Key
Column Name Ordinal Position
COMMUNICATION_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 COMMUNICATION_ID NUMERIC No
Internal ID for communication management routing for In Basket and Chart Review audit trail records.
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_REPORT_ID VARCHAR No
lrp report id of report sent in attachment
4 COMM_REPORT_ID_REPORT_NAME VARCHAR No
The name of the report
5 LETTER_ID VARCHAR No
hno letter id of letter sent in attachment
6 OTHER_BLOB_IDS VARCHAR No
file name if a blob server was used other than the letter
7 LETTER_BLOB VARCHAR No
file name if a letter blob server was used
8 REPORT_BLOB VARCHAR No
file name if a report blob server was used
9 DESCR VARCHAR No
description of the attachment
10 ATTACHMENT_NAME VARCHAR No
This column stores the attachment date (LCA-350). This typically stores the date listed in the first date column on the Chart Review tab.
11 FAX_REPORT_ID VARCHAR No
lrp id for faxes sent in the attachment
12 FAX_REPORT_ID_REPORT_NAME VARCHAR No
The name of the report
13 PAT_ENC_CSN NUMERIC No
The column serves as a link to EPT encounters whose reports/notes might have resulted in the creation of the LCA record.
14 HNO_CSN NUMERIC No
CSN of a note that was routed
15 EPISODE_ID NUMERIC No
This item stores the ID of the routed Episode.
16 DXR_ID NUMERIC No
This item stores the ID of the routed DXR.
17 LCA_COMM_LNO_ID NUMERIC No
Stores the LNO ID of the Patient Summary Extract routed from Chart Review
18 ORDER_ID NUMERIC No
Contains the ORD ID of the order routed from Chart Review
19 REFERRAL_ID NUMERIC No
Contains the RFL ID of the referral routed from Chart Review
20 DOCUMENT_ID VARCHAR No
Contains the DCS ID of the document/media routed from Chart Review
21 IS_SUM_OF_CARE_ATTCHMENT_YN VARCHAR No
Whether this attachment is a Summary of Care
May contain organization-specific values: No
Category Entries:
No
Yes