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
IB Pool
IB Class
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
Message not sent: Suppressed by data segmentation restrictions
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_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
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_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
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
45 | RECIP_SUSC_PREF_LINE | INTEGER | No |
Stores the line in related group LNO 51266 that holds which susceptibility tests in the order were reported to the submitter recipient.
46 | RCP_OVERRIDE_ADDRESS_IDENT | VARCHAR | No |
The unique address identifier which was used to select the destination override address for the recipient report. The selected address may differ from the preferred address when a fax is desired and the preferred address does not include a fax. This is currently used for storing provider address unique identifier (SER-21000) when they are used for result report generation.
47 | RCP_OVR_PREF_ADDRESS_IDENT | VARCHAR | No |
The unique address identifier which was preferred to be used to select the destination override address for the recipient report. The selected address may differ from the preferred address when a fax is desired and the preferred address does not include a fax. This is currently used for storing provider address unique identifier (SER-21000) when they are used for result report generation.
48 | RCP_OVRD_PREF_ADDRESS_SOURCE_C_NAME | VARCHAR | No |
The source which was preferred to be used to select the destination override address for the recipient report. The selected address source may differ from the preferred address source when a fax is desired and the preferred address does not include a fax.
The category values for this column were already listed for column: RCPNT_OVRD_ADDRESS_SOURCE_C_NAME