Fatal Errors As of: 2022.06.25 03:41 Fatal Errors for New Herds WH Errors Fatal errors (test already exist) and (Error creating htp) no rows selected Fatal errors from non-current tests no rows selected  Find OnFarm SCC Credits as of: 2022.06.25 03:34:26 SOURCE BILL_TO_ BILL_TO_HRD_ID HR TEST_DATE EMPL_ ITEM_CD R QUANTITY PRICE ID LINE_NO ---------- -------- -------------- -- --------- ----- --------- - --------- --------- --------- --------- ONFARM 10447-05 19711 05 23-JUN-22 24198 24-240102 0 1 1506367 4 ONFARM 10645-05 19902 05 23-JUN-22 24322 24-240102 0 1 1506306 5 ONFARM 10645-05 19902 05 23-JUN-22 24322 24-240102 0 1 1506306 3 ONFARM 02118-05 32949 05 22-JUN-22 23592 24-240102 0 1 1506216 4 ONFARM 10640-05 32962 05 23-JUN-22 23744 24-240102 0 1 1506323 6 ONFARM 10031-06 60956 06 23-JUN-22 24391 24-240102 0 1 1506480 3 ONFARM 01588-08 2932 08 20-JUN-22 24475 24-240102 0 1 1506217 5 ONFARM 10505-09 7600 09 22-JUN-22 00100 24-240102 0 1 1506247 4 8 rows selected. Find Males with Lactations as of: 2022.06.25 03:34:27 no rows selected Find mis-match species-breed on Cow Dam Sire as of: 2022.06.25 03:35:08 no rows selected Find Zero Qty - Hrs - Min as of: 2022.06.25 03:38:33 no rows selected  SMS monitoring no rows selected Id Sender Receiver Msg Status SentTime Error Msg Operator MsgType Reference ------------- ------------------------------ ------------------------------ ---------------- -------------------- -------------------- ------------------------------ ---------- ---------- ---------- 232194 1-800-549-4373 +12267509218 SCC Alert 18 Jun sent 2022-06-21 21:59:00 set to resend - second try 1 row selected. no rows selected Find advisor with wrong addr type As of: 2022.06.25 03:41 no rows selected JOHNES missing - looks for HCO but null on HTP As of: 2022.06.25 03:41 no rows selected LEUKOSIS missing - looks for HCO but null on HTP no rows selected MASTITIS 4 missing - looks for HCO but null on HTP no rows selected BVD missing - looks for HCO but null on HTP no rows selected NEOSPORA missing - looks for HCO but null on HTP no rows selected PREG CHK missing - looks for HCO but null on HTP no rows selected Mast 4 - on HTP but billing quantity is different or missing no rows selected Preg Conf - on HTP but billing quantity is different or missing PL/SQL procedure successfully completed. Johnes - on HTP but billing quantity is different or missing no rows selected Leukosis - on HTP but billing quantity is different or missing no rows selected BVD - on HTP but billing quantity is different or missing no rows selected BVD - ELISA msrmnt in the database in SUSPECT range no rows selected MILK/HR - Monitor herds on milk/hour adj As of: 2022.06.25 03:41 Pr Herd EffDate Status -- --------- --------- -------- 05 11519 20-DEC-21 3x 05 11542 31-MAY-16 2x3x 05 11768 01-NOV-21 2x3x 05 12188 03-FEB-17 3x 05 12467 19-NOV-20 2x 05 12896 26-JUN-20 3x 05 13225 22-APR-21 3x 05 13737 12-JUN-20 3x 05 14735 03-JUL-20 3x 05 15638 16-JUN-20 2x3x 05 18065 10-JUL-20 3x 05 18588 25-JUN-20 3x 05 19082 16-JUN-20 3x 05 19303 15-DEC-21 3x 05 20138 19-MAR-21 3x 05 21040 18-JUN-20 3x 05 21431 25-JUN-20 3x 05 24063 03-JUL-20 3x 05 24384 22-SEP-21 2x3x 05 25964 02-JUN-22 2x3x 05 30968 16-FEB-22 3x 05 31527 23-JUN-20 3x 05 31678 30-JUN-20 3x 05 31741 02-MAY-22 NOT USED 05 31830 01-DEC-17 2x 05 32336 15-MAR-22 2x3x 05 32411 19-DEC-20 3x 06 60038 22-OCT-21 3x 06 60151 22-JUN-20 3x 06 60180 08-JUN-20 3x 06 60543 25-JUN-11 2x3x 08 1673 15-FEB-22 2x3x 08 2556 03-JUL-20 NOT USED 09 87355 30-JUN-20 NOT USED 09 91675 21-MAY-20 3x 35 rows selected. Pr Herd EffDate Status -- --------- --------- -------- 05 11219 14-JUL-20 3x 05 13048 30-MAY-22 2x3x 05 16125 16-JUL-20 3x 05 30398 14-JUL-21 2x3x 06 60364 31-DEC-21 2x3x 07 90181 30-MAY-22 2x3x 09 33097 17-JUN-20 2x3x 7 rows selected.  Find_missing_callfee - missing in last 90 days As of: 2022.06.25 03:41 INT_ID ITEM_CD QUANTITY BILL_TO_HRD_ID Pr Testdate --------- --------- --------- -------------- -- ---------- 1506362 05-050010 58 30254 05 23-JUN-22 1 row selected. Unusual callfee billing records As of: 2022.06.25 03:34 no rows selected BARNCARD - find multiple whole herd card sets As of: 2022.06.25 03:41 no rows selected Ont citric find START: 25-Jun-2022 03:41:43 Ont citric find ENDED: 25-Jun-2022 03:41:46 FIND_HCT_BILL_TO - bill_to to ended owners As of: 2022.06.25 03:41 no rows selected ETYPE_NULL - looks for elec_file_type of null As of: 2022.06.25 03:41 no rows selected ETYPE_NULL - looks for elec_file_type of robot As of: 2022.06.25 03:41 no rows selected  HOLDINV - herd_contacts where Hold inv not set As of: 2022.06.25 03:41 ORPHOPQ - orphaned option queue records As of: 2022.06.25 03:41 no rows selected DNLERR - errors creating dnl files As of: 2022.06.25 03:41 no rows selected FIND_OFL_ERROR_HERDS started: As of: 2022.06.25 03:41 FIND_OFL_ERROR_HERDS ended: As of: 2022.06.25 03:41 OFLLOAD started: 2022.Jun.25 03:42:14 no rows selected Ofl Date Herd Pr Contact PIN Compnt CntNum HtpNum PosProto PosMycoP PosStaph PosStrep PregFull PregDisc ----------------- --------- -- ----- ------- -------- ------------ ------- ------- --------- --------- --------- --------- --------- --------- 24-Jun-2022 12:25 10175 05 00102 6733 Johnes 10 10 24-Jun-2022 12:25 20865 05 05930 1906 Johnes 5 5 24-Jun-2022 12:25 2898 08 01430 2701 Johnes 3 3 2 24-Jun-2022 15:25 10585 05 00267 9723 Preg Conf 6 6 6 24-Jun-2022 15:25 10833 05 00361 2442 Preg Conf 8 8 8 24-Jun-2022 15:25 13925 05 01613 2353 Preg Conf 8 8 8 24-Jun-2022 16:45 16536 05 10122 5246 Preg Conf 5 5 5 24-Jun-2022 15:25 21613 05 06167 9957 Preg Conf 2 2 2 24-Jun-2022 15:25 24883 05 07287 2857 Preg Conf 5 5 0 5 24-Jun-2022 15:25 25136 05 07375 4018 Preg Conf 10 10 10 24-Jun-2022 15:25 30340 05 07925 9641 Preg Conf 2 2 0 24-Jun-2022 15:25 32349 05 09655 9070 Preg Conf 3 3 2 24-Jun-2022 15:25 32431 05 09743 2274 Preg Conf 7 7 7 24-Jun-2022 15:25 60005 06 00005 4986 Preg Conf 7 7 6 24-Jun-2022 15:25 60154 06 00153 5061 Preg Conf 7 7 7 24-Jun-2022 15:25 90724 07 00455 4550 Preg Conf 1 1 1 24-Jun-2022 15:25 90815 07 00333 8774 Preg Conf 6 6 6 24-Jun-2022 15:25 2020 08 00938 8095 Preg Conf 2 2 2 24-Jun-2022 15:25 2763 08 01685 3553 Preg Conf 7 7 0 6 24-Jun-2022 15:25 2910 08 10105 5127 Preg Conf 4 4 3 24-Jun-2022 15:25 2932 08 01588 8283 Preg Conf 1 1 1 24-Jun-2022 15:25 28800 09 10108 8882 Preg Conf 4 4 4 24-Jun-2022 15:25 29797 09 10315 6040 Preg Conf 3 3 3 24-Jun-2022 15:25 55520 09 00407 5424 Preg Conf 2 2 2 24-Jun-2022 15:25 12480 05 10156 6000 Staph Aureus 4 4 1 24-Jun-2022 15:25 13925 05 01613 2353 Staph Aureus 4 4 1 24-Jun-2022 15:25 14735 05 01910 4067 Staph Aureus 3 3 24-Jun-2022 15:25 15299 05 02178 1392 Staph Aureus 2 2 2 24-Jun-2022 15:25 19730 05 05463 1380 Staph Aureus 1 1 24-Jun-2022 15:25 19961 05 05665 9776 Staph Aureus 4 4 1 24-Jun-2022 15:25 21660 05 06174 1909 Staph Aureus 5 5 2 24-Jun-2022 15:25 22005 05 06299 0385 Staph Aureus 2 2 24-Jun-2022 15:25 32772 05 10336 1822 Staph Aureus 3 3 1 24-Jun-2022 15:25 32962 05 10640 2486 Staph Aureus 2 24-Jun-2022 15:25 994 08 00238 7040 Staph Aureus 10 10 1 24-Jun-2022 15:25 1408 08 00427 6431 Staph Aureus 10 10 2 24-Jun-2022 15:25 1857 08 00776 8874 Staph Aureus 2 2 1 24-Jun-2022 15:25 2910 08 10105 5127 Staph Aureus 1 1 24-Jun-2022 15:25 7600 09 10505 0608 Staph Aureus 8 8 3 24-Jun-2022 15:25 92555 09 00656 7554 Staph Aureus 2 2 40 rows selected. FINDDOT - look for single "." in addr 1 and 2 As of: 2022.06.25 03:41 no rows selected no rows selected no rows selected no rows selected CSRCIRNO - look for CSR with null cir/ dst/ prv As of: 2022.06.25 03:41 Ctc Ctc_Id First Name Surname T FS Cir Dst Pr ----- --------- ------------------------- ----------------------------------- - -- --- --- -- 99048 1.079E+09 RODRIGO MOLANO F 10 170 04 1 row selected.