31:T6f2,eventlevel = md` These tests return data from the from the *events_qa* API endpoint. This data matches what can be viewed in the *Sampleing Events* table on the portal, but is structured for easier use in the OSV. ## Survey Log Tests
* Checks that *date* and *survey* on the portal match *date_actual* and *survey* in the survey log. The test is done both ways to check what is on the portal is in the survey log and vice versa. ## Matrix Tests
First, the entire historical matrix is filtered to only return matrices occuring within the period selected. For zooplankton variables, *net_id* is created (based on the variable description) and added to the variable list. Briefly, each date and variable combination in the matrix is checked against the portal data. The variable list in each row of the matrix is first parsed to perform the tests at the variable level. #### Matrix items not found in the portal
*All variables except those below* * For each day each variable was found in the portal we test that the variable, *event_depth*, *station* and *survey* in the matrix match the portal's *varibale*, *depth*, *site_id*, and *survey*. *POMFAS* * Same as above, except the matrix *event_depth* is checked that it is less than or equal to the portal's *depth*. *Zooplankton* * The matrix's *netid*, *station* and *survey* are checked to find a match with *net_id*, *site_id* and *survey*. Depth is not checked for zooplankton. #### Portal data not found in the matrix
*All variables except zooplankton* * Checks that the portal's *variable* *site_id*, and *depth* match the matrix's *variable*, *event_depth* and *station*. *Zooplankton* * Checks that for the correct matrix based on date, the portal's *net_id* matches the matrix's *netid*. `32:Tad0,md` ## Matrix Tests First, the historical matrix is filtered to only include the sample type and date range selected. Any matrix that was active during the data range selected will be returned. For *Microbial* sample type - any matrix variables containing *DNA*, *RNA* or *Cell C.* will be returned. For *Zooplankton* - a *net_id* column is added to the matrix based on the bongo filter size and variable. #### Matrix items not found in the portal
*All sample types except those below* * Checks that the matrix *event_depth*, *station* and *survey* matches *line_out_depth*, *site_id* and *survey* in the portal. *POMFAS* * Same as above, except the matrix *event_depth* is greater than the portal's data *line_out_depth_range*. *Zooplankton* * Checks that the *netid*, *station* and *survey* in the matrix matches *net_id*, *site_id* and *survey* in the portal. #### Portal data not found in the matrix
*All variables except those below* * Checks that the portal's *survey*, *site_id* and *line_out_depth* matches *survey*, *station* and *event_depth* in the matrix. *POMSFA* * Same as above except checkes that the portal's *line_out_depth_range* is less than *event_depth* in the matrix. *Zooplankton* * Checkst that the portal's *survey*, *site_id* and *net_id* matches the matrix's *survey*, *station* and *netid*. ## Inventory Test
The *hakai_id* of each sample returned by the portal is loaded from eLAB. * Each *hakai_id* from the portal is checked against each *name* found in eLAB. *Zooplankton* * Each *isotpe* item from the portal is checked against each *name* found in eLAB. * Each *fatty_acids* item from the portal is checked against each *name* found in eLAB. * Each *microscopy* item from the portal is checked against each *name* found in eLAB. ## Additional Zooplankton Tests
#### Insufficient number of samples
* Checks that tow table *isotope* is not *null*, and if *mesh_size\_um\_* is *250* that the *isotope* number of samples is less than *5*, otherwise *isotope* number of samples should be less than *7*. #### Zooplankton tow not found in microscopy table
* Checks that tow *microscopy* matches microscopy *hakai_id* #### Microscopy not found in tow table
* Checks that tow *hakai_id* matches tow *microscopy* #### Zooplankton tow not found in isotope table
* Checks that each tow *isotope* item matches isotope table *hakai_id* #### Isotope not found in tow table
* Checks that isotope *hakai_id* matches tow *isotope* item. #### Zooplankton tow not found in fatty acids table
* Checks that each tow *fatty_acids* item matches fatty acid table *hakai_id* #### Fatty acids not found in tow table
* Checks that fatty acid *hakai_id* matches tow *fatty_acids* item. `33:Taef,xx = md` ## Portal Tests By Sample Type *Nutrients* > 1) Portal matches elab entry ( 'Site ID' on the portal contains 'Station' on eLab , 'Date' on the portal matches 'Date Collected' on eLab, 'Line Out Depth' on the portal matches 'Depth (m)' on eLab.) > 2) If 'Source' on the portal is M and 'Volume (ml)' on the portal is NOT 13, flag. If 'Source' on the portal is F and the 'Volume (ml)' on the portal is NOT 12 flag. *Phytoplankton* > 1) Portal matches elab entry ( 'Site ID' on the portal matches 'Station' on eLab, 'Date' on the portal matches 'Date Collected' on eLab, 'Line Out Depth' on the portal matches 'Depth (m)' on eLab.) > 2) Flag for investigating ( If 'Site ID' on the portal is QU38 and 'Volume (ml)' on the portal is NOT 125, or 'Site ID' is not QU38 and 'Volume (ml)' is not 250). > 3) If Site ID is QU38 and Line out = 9 then the Sample Style should be a tow sample and the sample volume should be 125ml. If the Site ID is QU38 and Line out =1 then the Sample Style is a grab sample and the sample volume should be 125ml. For all other Site ID's regardless of Line out the Sample Style should be grab sample and the volume should be 250ml > For the tow sample, check that 'Mesh Size (um)' is 20, 'Net Dim. (cm)' is 20 and 'Net Length (cm)' is 100 . *Microbial* > 1) Portal matches elab entry ( 'Site ID' on the portal matches 'Station' on eLab, 'Date' on the portal matches 'Date Collected' on eLab, 'Line Out Depth' on the portal matches 'Depth (m)' on eLab.). > 2) Flag for comment if 'Line Out Depth' on the portal is not 0 and there is no value in 'Pressure Transducer Depth (m)' > 3) Flag for investigating if 'Sample Type' on the portal is Cell Count and 'Volume (ml)' is not 2. Flag for comment or error if 'Sample Type' on the portal is RNA or DNA and 'Volume (ml)' is not 2000. *HPLC* > 1) Portal matches elab entry ( 'Site ID' on the portal matches 'Station' on eLab , 'Date' on the portal matches 'Date Collected' on eLab, 'Line Out Depth' on the portal matches 'Depth (m)' on eLab., 'Volume (ml)' on the portal matches 'Volume (mL)' on eLab.). *POMFA* > 1) Portal matches elab entry ( 'Site ID' on the portal matches 'Station' on eLab , 'Date' on the portal matches 'Date Collected' on eLab, 'Volume (ml)' on the portal matches 'Volume (mL)' on eLab.) *POMS* > 1) Portal matches elab entry ( 'Site ID' on the portal matches 'Station' on eLab , 'Date' on the portal matches 'Date Collected' on eLab, 'Line Out Depth' on the portal matches 'Depth (m)' on eLab.). *CHL* > 1) Portal matches elab entry ( 'Site ID' on the portal matches 'Station' on eLab , 'Date' on the portal matches 'Date Collected' on eLab, 'Line Out Depth' on the portal matches 'Depth (m)' on eLab, and filter type on portal and elab match). Yet to implement: > *Zoop* `34:[] 2f:{"title":"OSV Documentation","cells":[{"id":0,"value":"md`# OSV Documentation\n

\"Girl — Image: Hakai Magic shot by Will McInnes

\nThis document provides baisc details on how the OSV works. In bullet points you'll find information on what exactly is being tested, while the rest of the text describes how the code (roughly) works. \n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"html`

Event Level Tests

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":13,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":70,"value":"md`\n## Inventory (eLAB) Tests
\n\nThe *hakai_id* of each sample returned by the portal is loaded from eLAB.\n\n* Each *hakai_id* returned from the portal is checked against each *name* found in eLAB.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":98,"value":"html`

Sample Level Tests

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":101,"value":"md`\nFor these tests, data is loaded by sample type from the portal. For zooplankton, data is loaded from the *zooplankton_tow*, *zooplankton_microscopy*, *zooplankton_isotope* and *zooplankton_fatty_acids* tables.\n\n## Survey Log Tests
\n\n* Checks that *date* and *survey* on the portal match *date_actual* and *survey* in the survey log. \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":110,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":248,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"html``","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}