Home : Lab Import Review
Q14830 - INFO: Lab Import Review

Lab Import Review allows users to review imported records, alias locations and test/analytes, and reimport data if necessary. 

Records are imported via Q15000 interface. 

Displays records based on the Collection Date.

Colors indicate the status of the record.  Some records can have multiple status, therefore click on row and view status bar to see statuses.

STATUS Value (LabImportRecs.Status) Description
0 Data is ready to be imported (a variable has been found for the Location and Test)
1 Data has been imported
2 No variable has been found (The location and test have been found)
4 No location found (SampleLocationId is not equal to any Location Alias)
8 No test found (Analyte is not equal to any LC_TEST_ALIAS.ALIASNAME)
16 User has marked record as ignored, data will not be imported.

Status are added together if more than 1 status applies.  Example a status of 6 (2 + 4) means there is no location match and no test match.

 

TECH NOTES:

1. Menu item only appears if the LabImportRecs table exists in the database.  Table is created by the Q15000 Interface.

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 8/7/2025 8:59 AM.
Last Modified on 8/11/2025 11:43 AM.
Last Modified by Scott Dorner.
Article has been viewed 142 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article