https://app.powerbi.com/groups/me/apps/688149d8-19d3-4e2c-8ffa-3eab914eaa50/reports/b15bf282-5dec-4020-a1f8-599fc3b03ca1/ReportSection75e6432bad9d5f75f74c?ctid=91347cb6-c2b2-44ed-bc6d-9d72e3337f8b 

The Batch Status Report – KANA tracks the location of a sample in the system.The Status column is able to help identify whether a lot is still with QC or QA. Further explanation of what each value in the Status column means: 

Sample not received = QC has not received all samples 

Sample Received not tested = QC has received all samples but have not started entering data 

QA needs to release = batch status is either pending release or preliminary release 

Released = QA has released 

Cancelled = Batch was cancelled 

Rejected = batch was rejected 

Testing in progress = QC needs to finish data entry and approval or receive the retain sample 

Testing completed, needs KIQC QA review = QC has approved the data but it needs final QC review 

 

The life cycle of the Batch Status is provided by Steve Seals: 

The data is refreshed 14 times a day at the following times (Central time): 5:30 am, 6:30 am, 7:30 am, 8:30 am, 9:30 am, 10:30 am, 11:30 am, 12:30 pm.1:30 pm,2:30 pm, 3:30 pm, 4:30 pm,4:30pm, 7:00 pm. 

The report is connected to BPW_Datamarts and connected to five tables: V_LV_Batch, V_LV_Product, V_LV_SampleTest, V_LV_SpecDetails, and V_LV_SampleTestResult.