LNO_LAB_AUDIT_TRL
Description:
This table contains information for the audit trail of Patient Summary Extract (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 PRINT_INSTANT DATETIME (Local) No
These are the instants that copies of the report were printed.
4 DEVICE_ID NUMERIC No
These are the devices used to print the report.
5 DEVICE_ID_PRINT_DEVICE_NAME VARCHAR No
The printer name.
6 FREE_TEXT_FAX_NUM VARCHAR No
These are the numbers of the fax machines the report was sent to.
7 NUM_OF_COPIES INTEGER No
These are the number of copies of the report sent to each given destination.
8 REQUESTING_USER_ID VARCHAR No
These are the users who requested a copy of the report.
9 REQUESTING_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
10 RCPNT_EMPLOYEE_ID VARCHAR No
These are the employees who received a copy of the report.
11 RCPNT_EMPLOYEE_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
12 RCPNT_PROV_ID VARCHAR No
These are the providers who received a copy of the report.
13 RCPNT_FREE_TEXT VARCHAR No
These are the recipients of the report in freetext.
14 RCPNT_SUBMITTER_ID NUMERIC No
These are the submitters which received a copy of the report.
15 RCPNT_SUBMITTER_ID_RECORD_NAME VARCHAR No
The name of the submitter record.
16 TYPE_OF_RECIP_C_NAME VARCHAR No
For each provider recipient of the report, this indicates if the provider is an authorizing provider, a PCP, or a CC recipient.
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
17 RCPNT_DEPARTMENT_ID NUMERIC No
These are the departments who received a copy of the report.
18 RCPNT_PT_RQG_ID NUMERIC No
Stores the patient who received a copy of the report. The patient database is RQG.
19 ADDRESS_SOURCE_C_NAME VARCHAR No
The source which was used to select the destination 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
20 DEVICE_SOURCE_C_NAME VARCHAR No
The source which was used to select the 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