AGEFRST - find birth to clvng <300 days As of: 2024.07.26 00:33 13740155 HO 14378696 20-JUL-22 1 15-APR-23 02 08 2958 444 25-MAY-22 23-MAY-24 13767525 HO 14811145 11-OCT-23 1 03-JUN-24 PB 03 05 19139 1356 01-JUN-24 20-JUN-24 13763948 HO 15037792 18-JUN-24 1 01-JUN-24 PB 03 09 92804 2976 18-JUN-24 25-JUL-24 12346497 HO 13547083 13-JUN-22 1 13-JUN-22 02 05 30951 1553 02-JUL-20 07-JUL-22 21-NOV-22 05 31297 562 07-JUN-24 10-JUL-24 11005079 HO 121716879 20-MAY-24 1 15-JUL-19 PB 03 05 32258 687 18-JUN-17 22-JUL-19 07-MAY-22 04 24861 948 20-MAY-24 09-JUL-24 10608159 HO 12454681 02-JUN-21 1 30-APR-18 02 05 30951 994 21-MAY-16 04-MAY-18 23-NOV-21 05 31297 563 07-JUN-24 10-JUL-24 13483351 HO 13780170 06-AUG-23 1 10-SEP-23 02 05 13419 4125 04-AUG-23 10-AUG-23 10608159 HO 12454681 02-JUN-21 3 03-JUN-20 02 05 30951 994 21-MAY-16 04-MAY-18 23-NOV-21 05 31297 563 07-JUN-24 10-JUL-24 13763945 HO 15037791 08-JUN-24 1 01-JUN-24 PB 03 09 92804 2975 08-JUN-24 25-JUL-24 10608159 HO 12454681 02-JUN-21 4 02-JUN-21 02 05 30951 994 21-MAY-16 04-MAY-18 23-NOV-21 05 31297 563 07-JUN-24 10-JUL-24 11005079 HO 121716879 20-MAY-24 2 04-AUG-20 PB 03 05 32258 687 18-JUN-17 22-JUL-19 07-MAY-22 04 24861 948 20-MAY-24 09-JUL-24 10608159 HO 12454681 02-JUN-21 2 18-APR-19 02 05 30951 994 21-MAY-16 04-MAY-18 23-NOV-21 05 31297 563 07-JUN-24 10-JUL-24 11005079 HO 121716879 20-MAY-24 3 01-DEC-21 PB 03 05 32258 687 18-JUN-17 22-JUL-19 07-MAY-22 04 24861 948 20-MAY-24 09-JUL-24 Ended at: 2024.07.26 00:35 set pagesize 50000 spo c:\temp\ais3 @c:\orawin\bin\aissupv 11658 05 2023.11.29 0 2 P P10AP @c:\orawin\bin\aissupv 12356 05 2023.06.20 0 3 P P10AP @c:\orawin\bin\aissupv 14321 05 2023.11.01 0 3 P P10AP @c:\orawin\bin\aissupv 14550 05 2021.11.28 0 6 P P10 @c:\orawin\bin\aissupv 14550 05 2022.02.05 0 6 P P10 @c:\orawin\bin\aissupv 14550 05 2022.04.20 0 6 P P10 @c:\orawin\bin\aissupv 14550 05 2022.06.29 0 6 P P10 @c:\orawin\bin\aissupv 14550 05 2022.09.10 0 6 P P10 @c:\orawin\bin\aissupv 14550 05 2022.11.23 0 6 P P10 @c:\orawin\bin\aissupv 14550 05 2023.01.31 0 6 P P10 @c:\orawin\bin\aissupv 14550 05 2023.04.15 0 6 P P10 @c:\orawin\bin\aissupv 14550 05 2023.06.19 0 6 P P10 @c:\orawin\bin\aissupv 14550 05 2023.08.30 0 6 P P10 @c:\orawin\bin\aissupv 14550 05 2023.11.07 0 6 P P10 @c:\orawin\bin\aissupv 14550 05 2024.01.23 0 6 P P10 @c:\orawin\bin\aissupv 16500 05 2021.09.02 0 6 P P10 @c:\orawin\bin\aissupv 16500 05 2021.11.22 0 6 P P10 @c:\orawin\bin\aissupv 16500 05 2022.03.09 0 6 P P10 @c:\orawin\bin\aissupv 17393 05 2023.05.09 0 3 P P10AP Hi Aug's test loaded as a Management10, from Publishable. Is that change correct @c:\orawin\bin\aissupv 17594 05 2021.06.20 0 3 P P10AP @c:\orawin\bin\aissupv 17917 05 2021.05.05 0 6 P P10 @c:\orawin\bin\aissupv 17917 05 2021.07.12 0 6 P P10 @c:\orawin\bin\aissupv 18540 05 2023.09.18 0 3 P P10AP LAUREN SOMERVILLE - 24627 as per jim booth I deleted id 217 comp 7257in order to @c:\orawin\bin\aissupv 18634 05 2023.12.27 0 2 P P10AP @c:\orawin\bin\aissupv 19139 05 2023.11.26 0 2 P P10AP @c:\orawin\bin\aissupv 21637 05 2019.12.11 0 3 P P12AP @c:\orawin\bin\aissupv 21637 05 2020.03.09 0 3 P P10AP @c:\orawin\bin\aissupv 21637 05 2020.04.14 0 3 P P10AP @c:\orawin\bin\aissupv 21637 05 2020.05.23 0 3 P P10AP @c:\orawin\bin\aissupv 21637 05 2020.06.29 0 3 P P10AP @c:\orawin\bin\aissupv 21637 05 2020.08.02 0 3 P P10AP @c:\orawin\bin\aissupv 21798 05 2023.11.14 0 3 P P10AP @c:\orawin\bin\aissupv 21880 05 2024.01.15 0 3 P P10AP @c:\orawin\bin\aissupv 22001 05 2023.11.19 0 3 P P10AP @c:\orawin\bin\aissupv 22025 05 2021.04.10 0 3 P P10AP @c:\orawin\bin\aissupv 22568 05 2023.11.20 0 3 P P10AP @c:\orawin\bin\aissupv 22591 05 2021.02.24 0 2 P P10AP @c:\orawin\bin\aissupv 22591 05 2022.05.11 0 2 P P10AP @c:\orawin\bin\aissupv 22591 05 2023.11.19 0 3 P P10AP @c:\orawin\bin\aissupv 23240 05 2021.09.12 0 2 P P12AP @c:\orawin\bin\aissupv 24591 05 2023.11.15 0 3 P P10AP @c:\orawin\bin\aissupv 24660 05 2024.02.17 0 3 P P12 @c:\orawin\bin\aissupv 31742 05 2022.06.20 0 3 P P10AP @c:\orawin\bin\aissupv 31942 05 2023.11.30 0 2 P P10AP @c:\orawin\bin\aissupv 31955 05 2022.10.30 0 6 P P10 @c:\orawin\bin\aissupv 32216 05 2023.05.10 0 2 P P10AP @c:\orawin\bin\aissupv 32561 05 2023.08.08 0 3 P P12AP @c:\orawin\bin\aissupv 32588 05 2023.09.18 0 3 P P10AP @c:\orawin\bin\aissupv 32594 05 2023.10.15 0 2 P P10AP @c:\orawin\bin\aissupv 32623 05 2017.12.17 0 3 P P10AP Spoke with CSR about this test being not supervised, he advised that this is the @c:\orawin\bin\aissupv 32700 05 2021.07.27 0 3 P P10 @c:\orawin\bin\aissupv 32750 05 2017.10.24 0 3 P P10AP CSR did this on purpose since meters need to be calibrated. CSR cannot do this. @c:\orawin\bin\aissupv 32769 05 2020.06.29 0 3 P P10 @c:\orawin\bin\aissupv 32962 05 2022.09.28 0 3 P P10AP @c:\orawin\bin\aissupv 33019 05 2023.04.10 0 5 P P10 @c:\orawin\bin\aissupv 90755 07 2024.02.13 0 3 P P10AP MEGAN FRIESEN - 24488 This test was an extra one done by the producer. I tried u @c:\orawin\bin\aissupv 90755 07 2024.02.26 0 3 P P10AP MEGAN FRIESEN - 24488 I currently do not have any info for a vet. I will contact @c:\orawin\bin\aissupv 147 08 2023.08.27 0 6 P P10 SIERRA ZMURCHYK - 24410 Animal[s] with COMP# > 9999 @c:\orawin\bin\aissupv 2147 08 2024.01.13 0 3 P P10AP @c:\orawin\bin\aissupv 34879 09 2023.06.07 0 3 P P10AP spo off AISINVTRANS - wrong agy_id / non-field staff As of: 2024.07.26 03:44 no rows selected AISINVTRANS - Field staff on LEAVE As of: 2024.07.26 03:45 no rows selected set pagesize 50000 spo c:\temp\aiss spo off ANCPED - look for ancestors in herds As of: 2024.07.26 00:55 no rows selected ANMFIND - looks for duplicate reg_ids As of: 2024.07.26 00:52 BRDB4BRT - looks for breedings before birthdate As of: 2024.07.26 00:55 Anm Id Prov Herd Comp# Birth Serviced Han Crtn Anm Crtn Brd Crtn Anb Reg num Anm Sire Serv Sire --------- ----- ------ ------- --------- --------- --------- --------- --------- --- ------------ ------------ ------------ 13739775 05 24440 1174 04-JUN-24 23-MAY-24 27-MAY-24 27-MAY-24 27-MAY-24 HO 14716190 3234629819 10608159 05 30951 994 02-JUN-21 29-JUL-17 13-JUN-16 13-JUN-16 23-AUG-17 HO 12454681 72851743 107359260 10608159 05 30951 994 02-JUN-21 11-JUL-18 13-JUN-16 13-JUN-16 22-AUG-18 HO 12454681 72851743 107281711 10608159 05 30951 994 02-JUN-21 09-JUL-19 13-JUN-16 13-JUN-16 20-AUG-19 HO 12454681 72851743 66382657 10608159 05 30951 994 02-JUN-21 02-AUG-19 13-JUN-16 13-JUN-16 20-SEP-19 HO 12454681 72851743 66382657 10608159 05 30951 994 02-JUN-21 25-AUG-19 13-JUN-16 13-JUN-16 20-SEP-19 HO 12454681 72851743 11799704 10608159 05 30951 994 02-JUN-21 25-AUG-20 13-JUN-16 13-JUN-16 19-OCT-20 HO 12454681 72851743 3129016082 12346497 05 30951 1553 13-JUN-22 17-SEP-21 13-AUG-20 13-AUG-20 01-NOV-21 HO 13547083 12638218 12638218 10608159 05 31297 563 02-JUN-21 29-JUL-17 11-JUL-24 13-JUN-16 23-AUG-17 HO 12454681 72851743 107359260 10608159 05 31297 563 02-JUN-21 11-JUL-18 11-JUL-24 13-JUN-16 22-AUG-18 HO 12454681 72851743 107281711 10608159 05 31297 563 02-JUN-21 09-JUL-19 11-JUL-24 13-JUN-16 20-AUG-19 HO 12454681 72851743 66382657 10608159 05 31297 563 02-JUN-21 02-AUG-19 11-JUL-24 13-JUN-16 20-SEP-19 HO 12454681 72851743 66382657 10608159 05 31297 563 02-JUN-21 25-AUG-19 11-JUL-24 13-JUN-16 20-SEP-19 HO 12454681 72851743 11799704 10608159 05 31297 563 02-JUN-21 25-AUG-20 11-JUL-24 13-JUN-16 19-OCT-20 HO 12454681 72851743 3129016082 12346497 05 31297 562 13-JUN-22 17-SEP-21 11-JUL-24 13-AUG-20 01-NOV-21 HO 13547083 12638218 12638218 11005079 05 32258 687 20-MAY-24 14-OCT-18 23-JUN-17 23-JUN-17 15-NOV-18 HO 121716879 3135766689 11438396 11005079 05 32258 687 20-MAY-24 30-OCT-19 23-JUN-17 23-JUN-17 18-NOV-19 HO 121716879 3135766689 107567492 11005079 05 32258 687 20-MAY-24 17-OCT-20 23-JUN-17 23-JUN-17 28-OCT-20 HO 121716879 3135766689 3143986414 11005079 05 32258 687 20-MAY-24 07-DEC-20 23-JUN-17 23-JUN-17 18-DEC-20 HO 121716879 3135766689 3143986414 11005079 05 32258 687 20-MAY-24 01-JAN-21 23-JUN-17 23-JUN-17 25-JAN-21 HO 121716879 3135766689 3143986414 11005079 05 32258 687 20-MAY-24 28-JAN-21 23-JUN-17 23-JUN-17 05-MAR-21 HO 121716879 3135766689 11005079 05 32258 687 20-MAY-24 23-FEB-21 23-JUN-17 23-JUN-17 05-MAR-21 HO 121716879 3135766689 72851738 11005079 05 32258 687 20-MAY-24 27-JAN-22 23-JUN-17 23-JUN-17 28-FEB-22 HO 121716879 3135766689 12638218 11005079 05 32258 687 20-MAY-24 31-MAR-22 23-JUN-17 23-JUN-17 09-MAY-22 HO 121716879 3135766689 24 rows selected. CALQOLD - look for left-over Calc Queue Records As of: 2024.07.26 00:45 no rows selected CHK61080 - Part 1 looks for non transfer AR As of: 2024.07.26 00:55 05 19770 1079219283 20240705094502 04-JUL-24 14141300 0 1 20240705 09:45:05 O1 1 05 19770 1079219283 20240705094502 04-JUL-24 14142600 0 1 20240705 09:45:05 O1 1 05 19770 1079219283 20240705094502 04-JUL-24 14140600 0 1 20240705 09:45:05 O1 1 05 19770 1079219283 20240705094502 04-JUL-24 14141800 0 1 20240705 09:45:05 O1 1 05 19770 1079219283 20240705094502 04-JUL-24 14141700 0 1 20240705 09:45:05 O1 1 05 19770 1079219283 20240705094502 04-JUL-24 14142400 0 1 20240705 09:45:05 O1 1 05 19770 1079219283 20240705094502 04-JUL-24 24240100 0 1 20240705 09:45:05 O1 1 05 19770 1079219283 20240705094502 04-JUL-24 24240102 0 1 20240705 09:45:05 O1 1 PL/SQL procedure successfully completed. CHK61080 - Part 2 looks for missing batch no As of: 2024.07.26 00:55 HR BILL_TO_HRD_ID AIS Tdate BATCH_NO -- -------------- ---------- ---------------- 05 19770 04-Jul-24 1 row selected. CHK61080 - Part 3 looks for non-transfer ais As of: 2024.07.26 00:55 no rows selected CHK61080 - Part 4 looks for cmi_ar_queues Error As of: 2024.07.26 00:55 no rows selected CONSCOS - looks for consecutive O/S in P herds , As of: ,2024.07.26 01:05 PR, ID,SERVICE_PL,TEST_DATE,H,SERVICE_PL,TEST_DATE,H --,----------,----------,---------,-,----------,---------,- 05, 21880,P5+5AP ,27-JUN-24,3,P5+5AP ,23-MAY-24,3 05, 24204,P5+5 ,31-JAN-24,3,P5+5 ,06-DEC-23,3 05, 31082,P5+5AP ,06-JUN-24,3,P5+5AP ,13-APR-24,3 05, 19370,P5+5AP ,27-MAY-24,3,P5+5AP ,18-APR-24,3 05, 12898,P5+5AP ,12-JUN-24,3,P5+5AP ,25-APR-24,3 07, 90755,P10AP ,05-JUN-24,3,P10AP ,23-MAY-24,3 08, 461,P5+5AP ,13-MAR-24,3,P5+5AP ,19-JAN-24,3 05, 19370,P5+5AP ,02-JUL-24,3,P5+5AP ,27-MAY-24,3 05, 32597,P5+5AP ,20-FEB-24,3,P5+5AP ,06-FEB-24,3 9 rows selected. CONSENT - look for non-null data_cnsnt ON / WC As of: 2024.07.26 00:45 no rows selected CTCENDED - looks for ended ctc with active opt As of: 2024.07.26 00:55 no rows selected CTLDIM - look for incorrect CTL DIM As of: 2024.07.26 02:49 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12799340 HO CAN F 13130077 1 04 19-MAY-22 14 13 05 20264 497 15-AUG-19 19-MAY-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12052022 HO CAN F 13521770 1 01 05-MAY-23 15-JUN-23 410 408 05 23692 1211 19-SEP-19 25-FEB-21 05 30863 3967 23-APR-22 19-MAY-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12394861 JE CAN F 13820410 1 01 05-JUN-23 27-AUG-23 277 257 09 76699 111 20-SEP-20 13-JAN-22 09 76700 111 26-JAN-23 27-JAN-23 24-OCT-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 13086804 HO CAN F 13577511 1 01 15-MAY-23 05-JUL-23 295 296 05 32124 743 29-JUL-22 29-JUL-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 13671302 JE F 3 01 09-MAR-24 18-APR-24 206 282 05 33045 63 05-MAR-24 12-MAR-24 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 13671293 JE F 3 01 10-MAR-24 25-MAR-24 207 314 05 33045 54 05-MAR-24 12-MAR-24 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11974433 HO CAN F 13238429 3 04 06-FEB-24 35 66 09 78385 3271 28-AUG-19 01-DEC-21 06-FEB-24 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11385352 HO CAN F 12941280 4 04 17-FEB-24 56 51 05 21145 1239 04-APR-18 25-APR-19 05 18237 2604 26-APR-19 01-MAR-20 05 18237 2809 14-JUN-20 17-JUN-20 15-APR-21 05 31229 597 16-APR-21 20-APR-21 17-FEB-24 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12096520 JE CAN F 13416004 2 05 22-NOV-23 43 52 05 30237 704 23-DEC-19 20-JAN-22 22-NOV-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12935295 HO CAN F 14180478 1 05 24-JAN-24 41 38 09 91691 848 05-FEB-22 24-JAN-24 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 13032767 JE CAN F 14000034 1 01 01-MAY-24 12 11 05 30079 1001 09-MAY-22 08-MAY-24 16-MAY-24 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10954430 HO CAN F 12361387 5 01 01-FEB-24 26 28 05 15436 560 28-MAR-17 17-MAY-19 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11940715 HO CAN F 13382530 3 04 07-MAR-24 30 29 05 24112 3358 31-JUL-19 06-JUL-21 07-MAR-24 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12518598 HO CAN F 13935720 2 05 06-MAY-24 41 44 05 19673 441 06-JAN-21 18-APR-23 19-MAR-24 05 10406 2101 20-MAR-24 01-APR-24 06-MAY-24 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 13050812 HO CAN F 14339035 1 05 18-JUN-24 49 51 05 16948 1249 08-JUN-22 03-MAY-24 18-JUN-24 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12688347 HO CAN F 14093722 2 01 08-JUN-24 3 4 05 18237 2980 08-JUN-21 04-JUL-23 11-JUN-24 PL/SQL procedure successfully completed. CTLDIM - completed As of: 2024.07.26 02:51 DRYCALV - looks for nbc_cd 20/21 with hts_cd 04 As of: 2024.07.26 01:05 An Ht Anm id Htp id NB L# Herd# Pr Cmptr Cntr Date Test Date Ht L# At Ht DRYCALV - ended As of: 2024.07.26 01:06 ERAERROR - looks for ERA time with > 1 hour As of: 2024.07.26 00:45 no rows selected ERRLOG - AIS61080 errors in cmi_error_logs As of: 2024.07.26 00:45 no rows selected ERROPTS - looks for errors in cmi_option_queues As of: 2024.07.26 00:39 no rows selected no rows selected no rows selected ERROPTS Part 2 - looks for proc not printed As of: 2024.07.26 00:39 no rows selected FIND_SPACES Pt 1 - find extra spaces - Contacts As of: 2024.07.26 00:55 no rows selected FIND_SPACES Pt 2 - find extra spaces - FarmName As of: 2024.07.26 00:55 no rows selected FUTREND - Future end date but not Jan 01,2111 As of: 2024.07.26 00:55 Herd Pr Opt # Start date End date ------ -- ------ ----------- ----------- 19770 05 17 Jul 01,2024 Jan 01,2026 33023 05 17 Jun 20,2023 Dec 31,2024 33024 05 17 Jul 13,2023 Dec 30,2024 33027 05 17 Jul 24,2023 Dec 31,2024 33028 05 17 Jul 24,2023 Dec 30,2024 33029 05 17 Aug 08,2023 Dec 30,2024 33032 05 17 Sep 07,2023 Dec 30,2024 33033 05 17 Sep 10,2023 Dec 31,2024 33034 05 17 Sep 12,2023 Dec 30,2024 33036 05 17 Sep 19,2023 Dec 31,2024 33038 05 17 Sep 20,2023 Dec 30,2024 33039 05 17 Sep 25,2023 Dec 31,2024 33040 05 17 Sep 28,2023 Dec 31,2024 33042 05 17 Oct 19,2023 Dec 31,2024 33043 05 17 Oct 23,2023 Dec 31,2024 33045 05 17 Nov 22,2023 Dec 30,2024 33047 05 17 Nov 28,2023 Dec 30,2024 33048 05 17 Dec 01,2023 Dec 31,2024 33054 05 17 Feb 13,2024 Jun 30,2025 33055 05 17 Feb 20,2024 Jul 01,2025 33061 05 17 Apr 15,2024 Jun 30,2025 33062 05 17 Apr 14,2024 Jun 30,2025 33064 05 17 Apr 22,2024 Jun 30,2025 33066 05 17 May 08,2024 Jun 30,2025 33067 05 17 May 08,2024 Jun 30,2025 33069 05 17 May 28,2024 Jun 30,2025 33070 05 17 Jun 30,2024 Jan 01,2026 33071 05 17 Jun 05,2024 Jul 01,2025 33072 05 17 Jun 16,2024 Jun 30,2025 33073 05 17 Jul 01,2024 Jan 01,2026 33075 05 17 Jun 27,2024 Jun 30,2025 33076 05 17 Jul 02,2024 Jun 30,2025 60967 06 17 Dec 11,2023 Dec 31,2024 60968 06 17 Apr 17,2024 Jun 30,2025 2814 08 17 Apr 01,2024 Jun 30,2025 2958 08 17 May 20,2024 Jun 30,2025 31913 09 17 Jan 02,2024 Jul 01,2025 32691 09 17 Jul 25,2023 Dec 30,2024 52125 09 17 Sep 15,2023 Dec 31,2024 39 rows selected. FUTREND - Future end date of Jan 01,2111 As of: 2024.07.26 00:55 no rows selected HTTPROB - looks for missing Htt records As of: 2024.07.26 00:55 no rows selected LACTNO - look for lact_no of 20+ As of: 2024.07.26 00:45 no rows selected LCSDRY - looks for negative dry days on lcs As of: 2024.07.26 00:41 HR HRD_ID COMPTR_NO AnmId RegId L# START_DAT END_DATE END_CYCLE DRY_DAYS L# START_DAT END_DATE END_CYCLE -- ---------- ---------- ---------- ------------ ---- --------- --------- --------- ---------- ---- --------- --------- --------- 09 92581 5985 11742694 13372683 2 14-NOV-22 02-NOV-23 01-JUL-23 -123 3 02-JUL-23 1 row selected. LENDERR - inconsistent lcs and clc end_dates As of: 2024.07.26 00:37 Anm_id L# LE Lcs End Clc End LE Comp Herd Pr Enter Left DIM ---------- --- -- --------- --------- -- ------ ------ -- --------- --------- ---------- 12720694 1 09 29-MAY-24 17-NOV-23 05 2861 33038 05 18-NOV-23 02-JUN-24 156 12720721 1 09 22-JUN-24 17-NOV-23 05 2863 33038 05 18-NOV-23 24-JUN-24 125 12765867 1 09 28-JUN-24 30-OCT-23 05 2865 33038 05 01-NOV-23 04-JUL-24 104 12765872 1 09 30-JUN-24 30-OCT-23 05 2866 33038 05 01-NOV-23 04-JUL-24 102 12765891 1 09 08-JUN-24 17-NOV-23 05 19915 32242 05 07-JUN-24 137 12765892 1 09 09-JUN-24 30-OCT-23 05 19916 32242 05 06-JUN-24 115 12804052 1 09 02-JUL-24 13-OCT-23 05 2451 33038 05 14-OCT-23 04-JUL-24 90 12846534 1 09 07-JUL-24 30-OCT-23 05 19920 32242 05 28-MAY-24 92 8 rows selected. LERNO - look for missing LER codes As of: 2024.07.26 00:47 no rows selected METERS - On option but none rented As of: 2024.07.26 00:55 no rows selected METERS - Not On option and some rented As of: 2024.07.26 00:55 no rows selected MLKHRS - looks for milking duration of 11+ hrs As of: 2024.07.26 00:45 no rows selected MLKHRS - looks for milking duration neg hrs As of: 2024.07.26 00:45 no rows selected NEGDIM - looks for negative dim in clc and ats As of: 2024.07.26 00:41 no rows selected no rows selected OPTCHCK - look for herds enrolled on Que option As of: 2024.07.26 00:39 HR HRD_ID CTC_ID SUBSTR(CMIP.CMI C LANG_1_OPT_NAME -- ---------- ------------ --------------- - ------------------------------ ALPHA_VAL START_DAT CRTN_DATE LAST_MODF LAST_MODFD_BY ------------------------------ --------- --------- --------- ------------------------------ 05 13869 1079190952 BRISSON A GENERAL INFORMATION 01_MAIL/POSTE 01-SEP-19 24-OCT-19 LTURCOTTE 1 row selected. PED07 - look for inconsistent Ped Stat 07 As of: 2024.07.26 00:55 no rows selected Anm Id AN COU S Reg_id PStat Ped Date LAST_MODF LAST_MODFD_BY ----------- -- --- - ------------ ----- ------------ --------- ------------------------------ 13797432 HO CAN F 01 25-JUL-24 OPS$PRDCMIP 13797433 HO CAN F 01 25-JUL-24 OPS$PRDCMIP 13797434 HO CAN F 01 25-JUL-24 OPS$PRDCMIP 13797436 HO CAN F 01 25-JUL-24 OPS$PRDCMIP 13797437 HO CAN F 01 25-JUL-24 OPS$PRDCMIP 13794573 HO CAN F 01 22-JUL-24 OPS$PRDCMIP 13792421 HO CAN F 01 19-JUL-24 OPS$PRDCMIP 7 rows selected. Start End Start End Start End Start End Start End Start End Start End PL/SQL procedure successfully completed. PED07 - Completed As of: 2024.07.26 00:55 PSTLCD - look for invalid postal codes As of: 2024.07.26 00:45 Ctc_id Type Pr Ctc N Surname Adr Pst cd ------------- ----- -- ----- -------------------- --------- ---------- 1079212233 A 13561 GRANT 2 B2N6V1 1079218787 O 02 99187 VERMEULEN 1 B0N2H0 1079219265 O 03 97926 AND CAROL LEVAC 1 E7L2Y7 30969 F 00090 Blom 1 j0b 2b0 31000 F 00154 Julien 1 j2r 0a2 517641611 O 04 00932 ASSELIN 1 GOR 3CO 525005103 O 04 01490 SCHEURER 1 JOG 1RO 606419196 O 04 20764 GAGNE 1 G0N 1TO 636585760 O 04 20036 GRENIER 1 J0K 3G0 649650020 O 04 19796 CHAREST 1 GOS 2WO 695968760 O 04 18261 BERGERON 1 JOS 1W0 761111911 O 04 16183 MALENFANT 1 G0L 3LO 777085938 O 04 15403 GRATTON 1 J8H2C5 909569411 O 04 07491 COUTURE 1 JOB 1L0 919902053 O 04 07259 ROBINSON 1 JOB 1M0 979106904 O 04 03893 PROVENCHER 1 GON 1B0 986470396 O 04 03333 LEMAY 1 G0S 2KO 988489418 O 04 03415 DEBLOIS 1 GOS 2S0 989617695 O 04 03463 HEBERT 1 GOS 2K0 1079181330 F 00176 TREMBLAY 1 G3z 2e3 1079183744 O 04 76301 LUPIEN 1 J0Z Z0 1079188473 O 04 76829 LESSARD 1 GOM 2B0 1079191157 O 04 77163 ET WILLIAM POULIN 1 GOS 3A0 1079193454 O 04 77393 PILON 1 J0W1N0 1079210173 O 04 78507 ROY 1 GON 1S0 1079210232 O 04 78559 LAVOIE 1 GOL 2T0 1079210888 O 04 78982 LEMAY 1 GOS 2K0 1079211048 O 04 79058 DUFAULT 1 J0H 1 H0 1079212262 O 04 79145 PIERRE-LUC MORIN 1 GOL 3L0 1079218514 A 16048 DE LADURANTAYE 2 G0M1R0 30 rows selected. EMAIL - look for invalid email addresses As of: 2024.07.26 00:45 no rows selected RPLCTSTQ - look for multi replcmnt in 180 days As of: 2024.07.26 00:45 no rows selected RPLCTSTQ - part 2 look for replcmnt > 14 days no rows selected SOPTHCR - look for hcr rec for service option As of: 2024.07.26 00:51 no rows selected SRVPNOPL - looks for herds without Service Plan As of: 2024.07.26 00:40 no rows selected SUPVHRD - incorrect cmi_herds spvse enrollment As of: 2024.07.26 00:39 no rows selected TANKLWT - looks for tank weight between 0 and 6 As of: 2024.07.26 00:39 no rows selected WEBLINK - looks for problems in web linking As of: 2024.07.26 00:55 no rows selected