LNO_LAB_RECIP_INFO
Description:
Recipient information for lab result report (LNO) records.

Primary Key
Column Name Ordinal Position
RECORD_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique identifier for the LNO record.
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 RCPNT_ORDER_ID NUMERIC No
Stores the order record for which a report will be printed or has printed for the given recipient.
4 RECIPIENT_TYPE_C_NAME VARCHAR No
Stores the report's recipient type.
May contain organization-specific values: No
Category Entries:
Authorizing Provider
Primary Care Physician
CC Provider
CC Employee
Free text CC
Submitter
Department
Patient
Patient/Source
CC Submitter
Ordering Provider
5 RECIPIENT_STATUS_C_NAME VARCHAR No
Stores the status of the report which will be printed or has printed for the given recipient.
May contain organization-specific values: No
Category Entries:
Ready
Replaced
Printed - Ad hoc
Printed - Auto
Patient not discharged
Report not final
Printed - Manually
Delayed Recipient
Hold
Hold - Resolved
Paper report skipped: Suppressed by routing record In Basket setup
Message sent
Message sent: Extension
Recipient Removed
Message initiated
Message not sent: Submitter ineligible
Message not sent: Verification status ineligible
Message not sent: Result not reportable
Message not sent: Result source ineligible
Message not sent: Resulting agency ineligible
Message not sent: CC submitters ineligible
Message not sent: Miscellaneous failure
Message not sent: Order not linked to patient
Message not sent: Order group not ready
Message not sent: Custom interface filter
Message not sent: Consent not given
Message not sent: Interface only sends Final and Corrected
Message not sent: Interface only sends Prelim, Final, and Corrected
Message not sent: interface only sends In Process, Prelim, or Final
Message not sent: CC submitter cancel won't be sent
Message not sent: Parent orders aren't sent
Message not sent: Interface only sends electronic cancer checklists
Message not sent: Interface canceled orders aren't sent
Message not sent: Performable cancels aren't sent
Message not sent: Order suppressed
Message initiated: Sending pending results
Message not sent: Ineligible interface
Message not sent: Order filtered by rule
Message not sent: Network orders aren't sent
Message not sent: Interface does not send unsolicited cancels
Paper report skipped: Suppressed by recipient skip paper setup
Paper report skipped: Suppressed by routing record extension setup
Message not sent: Not intended resend recipient
6 RECIPIENT_EVNT_INST DATETIME (Local) No
Stores the instant this line was added to the recipient's table.
7 RCPT_RRT_SUB_TYPE_C_NAME VARCHAR No
Stores the sub type of the report.
May contain organization-specific values: No
Category Entries:
End of Week Report
Final Summary Report
8 RCPNT_TYPE_DEP_ID NUMERIC No
Stores the department record if the recipient is the department.
9 RCPNT_TYPE_SMT_ID NUMERIC No
Stores the submitter record if the recipient is the submitter.
10 RCPNT_TYPE_SMT_ID_RECORD_NAME VARCHAR No
The name of the submitter record.
11 RCPNT_TYPE_SER_ID VARCHAR No
Stores the provider record if the recipient is the provider.
12 RCPNT_TYPE_RQG_ID NUMERIC No
Stores the patient/source record if the recipient is a non enterprise patient.
13 RCPNT_TYPE_EMP_ID VARCHAR No
Stores the employee record if the recipient is the employee.
14 RCPNT_TYPE_EMP_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
15 RCPNT_TYPE_FREE_TXT VARCHAR No
Stores the free text name of the recipient.
16 RCPNT_HOLD_TYPE_C_NAME VARCHAR No
The recipient hold type category number for the recipient.
May contain organization-specific values: No
Category Entries:
City mismatch
17 RCPNT_HOLD_OVT_LN INTEGER No
Contains the recipient hold test (OVT) line.
18 RCPNT_HOLD_BSDON_C_NAME VARCHAR No
Contains the recipient hold based on address category.
May contain organization-specific values: No
Category Entries:
Physician
Agency
Patient
Provider
Submitter
19 RCPNT_HOLD_QUAL_LN INTEGER No
Contains the recipient hold rule qualifier line.
20 RCPNT_RSLN_C_NAME VARCHAR No
The recipient hold resolution category number for the recipient.
May contain organization-specific values: Yes
Category Entries:
Ignore
Added Recipient
21 RCPNT_RSLN_INST DATETIME (Local) No
Contains the recipient hold resolution instant.
22 RCPNT_RSLN_USER_ID VARCHAR No
Contains the recipient hold resolution user.
23 RCPNT_RSLN_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
24 RCPNT_RSLN_LINE INTEGER No
Contains the line in the related group for the recipient hold resolution instant that audits the chosen CC recipient
25 RCPNT_LPP_ID NUMERIC No
Stores the programming point which added this recipient
26 RCPNT_LPP_ID_LPP_NAME VARCHAR No
The name of the extension.
27 RCPNT_RPTBL_RULE_YN VARCHAR No
Indicates if the recipient on the row was added because of a reportable rule.
May contain organization-specific values: No
Category Entries:
No
Yes
28 RCPNT_CORRECTED_RPT INTEGER No
If the report on the row was sent to a health agency based on a reportable rule, and the results later change such that it is no longer reportable to the health agency, this item stores the row in the LNO_LAB_RECIP_INFO table that contains the corrected report.
29 RESEND_EMP_ID VARCHAR No
The ID of the user who resent the message. Messages sent over an interface may sometimes fail to deliver and would need to be resent. This column will have a value only for resent messages.
30 RESEND_EMP_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
31 RESEND_RELATED_LN INTEGER No
The line number of the associated recipient's record. This points to the recipient line of the interface message that was resent. Messages sent over an interface may sometimes fail to deliver and would need to be resent. This column will have a value only for resent messages.
32 RESEND_REASON_C_NAME VARCHAR No
The category number of the reason for resending an interface message. Messages sent over an interface may sometimes fail to deliver and would need to be resent. This column will have a value only for resent messages.
May contain organization-specific values: Yes
Category Entries:
Others
33 RESULT_TRGR_LPP_ID NUMERIC No
The ID of the extension that triggered the result. This column will have a value only for those results that were triggered by a post event extension set up to send results over an interface.
34 RESULT_TRGR_LPP_ID_LPP_NAME VARCHAR No
The name of the extension.
35 WHO_REMOV_RECPNT_ID VARCHAR No
The user ID of the user who removed this recipient from result reports.
36 WHO_REMOV_RECPNT_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
37 RECPNT_REMOV_RSN_C_NAME VARCHAR No
The category number of the reason for which this recipient was removed from result reports.
May contain organization-specific values: Yes
38 RCPNT_OVRD_DEV_ID NUMERIC No
The record ID of the override device that the recipient is to use when the report prints.
39 RCPNT_OVRD_DEV_ID_PRINT_DEVICE_NAME VARCHAR No
The printer name.
40 RCPNT_OVRD_FAX_NUM VARCHAR No
The override fax number that the recipient is to use when the report prints.
41 RCPNT_RPTBL_RULE_ID NUMERIC No
This item stores the record ID for the reporting rule that caused the recipient to be added.
42 RCPNT_RPTBL_RULE_ID_RULE_NAME VARCHAR No
The name of the reporting rule.
43 RCPNT_OVRD_ADDRESS_SOURCE_C_NAME VARCHAR No
The source which was used to select the destination override address for the recipient report.
May contain organization-specific values: No
Category Entries:
Unknown
User selected
Requisition authorizing provider
Lab additional recipient extension
Lab CC List
Provider encounter submitter
Submitter
Department lab fax
Provider lab fax
Routing provider address extension
Provider primary
Provider requisition submitter
Provider CC linked submitter
Care Team
Requisition ordering provider
Order authorizing provider
Order ordering provider
Order referring provider
Radiant CC List
Order referral
Encounter referral
Encounter admitting
Current admitting
Provider secondary
44 RCPNT_OVRD_DEVICE_SOURCE_C_NAME VARCHAR No
The source which was used to select the override printing/faxing device for the recipient report.
May contain organization-specific values: No
Category Entries:
Unknown
User selected
Lab additional recipient extension
Provider lab printer
Submitter
Lab routing fax device
Resulting lab
Department external recipient printer
Department printer class mapping
Facility