Biospecimen QC- question about rule 80

[erincschwartz]

It does not appear that Rule 80 is flagging according to the rule description:

Connect ID 8393015300 has never been checked in for a research collection. I do have HFH investigating why clinical blood and urine lab orders have an entry date AFTER the clinical blood and urine collection dates. It appears that HFH had not previously sent the order placed data and just did so after the 12/8 prod files were pushed.

This can wait for Kelsey's return if it cannot be investigated by another member of the Analytics team.

[hullingsag]

@michellehudson - Would you feel comfortable looking into this? Please reach out if you have questions!

[michellehudson]

Hi @hullingsag - The code for Rule 80 doesn't look like it's referencing BioChk_TimeBL_v1r0 (d_331584571_d_266600170_d_840048338) at all unless I'm missing something. Can you take a look? Connect ID 8393015300 has N/A for BioChk_TimeBL_v1r0.

80. The visit research collection visit check-in time (BioChk_TimeBL_v1r0) must be before the date of the earliest blood or urine specimen finalized. (BioFin_ResearchBldTmBL_v1r0 and BioFin_ResearchUrnTmBL_v1r0)

DrawOrder_Colct2 <- bioqc %>%  filter(as.numeric(difftime(d_173836415_d_266600170_d_184451682, d_173836415_d_266600170_d_982213346, units="days")) > 2  & 
                                        Connect_ID!='1094193968') %>%
  select(Site, Connect_ID, d_173836415_d_266600170_d_184451682, d_173836415_d_266600170_d_982213346,
         d_173836415_d_266600170_d_139245758) %>%  safe_arrange(Site)


colnames(DrawOrder_Colct2) <- c("Site", "Connect ID", "BioClin_BldUrnPlcdTmBL", "BioClin_ClinBloodTmBL", "BioClin_ClinicalUrnTmBL")
knitr::kable(DrawOrder_Colct2, longtable = TRUE)  %>% kable_styling(latex_options = "scale_down", full_width = FALSE, font_size=8)

Or is there something wrong with the way Rule 80 is written in English? Rule 77 also says:

77. The visit research collection visit check-in time (BioChk_TimeBL_v1r0) must be before the date of the earliest blood or urine specimen finalized. (BioFin_ResearchBldTmBL_v1r0 and BioFin_ResearchUrnTmBL_v1r0)

Is Rule 80 supposed to be doing something else?