VLIR returns Lab Import Record information (see Lab Import Review) for a specific data value specified by varnum and offset/datetime

SYNTAX:

VLIR(varnum,offset/date,field) 

varnum:  The variable number to get the audit information for.

Offset/Date: If the field is numeric it is assumed to be the offset and is defined as the offset (number of slots for the variable type) from the start date of the report.  For example, if the start date is 1/1/2000 and the offset is 2 the value for the 2nd data slot will be returned.  I.E. for an hourly variable the value for the 1AM to 2AM slot will be returned, for a 15 minute variable the value for the 12:15 AM to 12:30AM slot will be returned.  If the offset is 3, the value for 2AM to 3AM (hourly var).  If the field is a date/time in quotes or a cell reference to a cell containing a date/time the value for the slot specified by the date/time will be returned.

field: The field to return from the LabImportRecs table.

ID
SAMPLENUMBER
SAMPLELOCATIONID
ANALYTE
TESTGROUP
COLLECTIONDATE
COLLECTEDBY
QUALIFIER
RESULTNUMERIC
RESULT
UNITS
FLAG
MDL
RL
METHOD
PREPMETHOD
CONTAINER
MATRIX
SAMPLETYPE
DILUTIONFACTOR
RECEIVEDDATE
ANALYSISSTARTDATE
ANALYSISDATE
ANALYZEDBY
LAB
EXTLABSAMPLENUMBER
CASNUMBER
PROJECT
SAMPLEADDRESS
CITY
STATE
ZIP
LATITUDE
LONGITUDE
PWSID
WSFID
SAMPLEPTID
NOTES
LD1
LD2
LD3
LD4
LD5
LD6
LD7
LD8
LD9
CLIENT
FILEID
FILENAME
FILEROW
STATUS
VARID
DATESTAMP
AUDITIMPORTUSER
AUDITIMPORTTIMESTAMP
AUDITUSER
AUDITTIMESTAMP

 

EXAMPLES:

VLIR(8001,1,"SAMPLENUMBER") - Return the SampleNumber from the Lab Import Record for variable 8001 for day 1 of the report.