AGEFRST - find birth to clvng <300 days As of: 2023.09.29 00:33 13435983 HO 14797322 23-JUN-23 2 04-JAN-23 PB 03 05 18540 6701 23-JUN-23 09-AUG-23 13383912 HO 14681398 20-MAR-23 4 18-APR-22 PB 03 08 2949 6969 20-MAR-23 25-APR-23 13418622 HO 183774201 30-JUN-23 2 23-JUL-23 10 08 797 6381 30-JUN-23 06-AUG-23 12238165 HO 14516363 14-NOV-22 3 26-AUG-22 PB 03 08 1464 3039 14-NOV-22 01-MAY-20 11805085 HO 13236722 10-JAN-21 1 22-AUG-21 02 05 32022 757 10-MAR-19 21-SEP-21 12360979 HO 13424169 28-MAY-23 1 30-JUL-22 10 05 31941 2648 19-AUG-20 28-DEC-22 13395441 HO 14527341 24-MAY-23 1 15-SEP-23 PB 03 08 2441 2272 24-MAY-23 26-SEP-23 11027902 HO 12297587 13-JAN-21 2 07-JUN-19 02 05 32022 647 12-JAN-16 01-MAR-18 13176120 HO 14380952 16-OCT-22 2 05-FEB-23 PB 03 06 60282 18739 16-OCT-22 29-JAN-23 11027902 HO 12297587 13-JAN-21 1 18-FEB-18 02 05 32022 647 12-JAN-16 01-MAR-18 12238165 HO 14516363 14-NOV-22 2 12-SEP-21 PB 03 08 1464 3039 14-NOV-22 01-MAY-20 11225183 HO 12841975 21-OCT-20 1 11-FEB-20 00 11 08 1819 2044 04-DEC-17 14-FEB-20 14-OCT-20 11027902 HO 12297587 13-JAN-21 4 01-OCT-21 02 05 32022 647 12-JAN-16 01-MAR-18 13329047 HO 14416609 16-MAR-23 1 23-NOV-22 PB 03 05 18540 6177 16-MAR-23 22-SEP-23 13230710 HO 13-MAR-20 5 24-AUG-20 07 09 31913 177 08-SEP-22 14-DEC-22 18-JAN-23 10556775 HO 12414764 16-AUG-17 1 17-MAY-18 00 11 05 32008 313 16-AUG-17 11-JUN-18 20-JAN-21 13435385 JE 14815544 11-JUL-23 1 08-MAY-23 PB 03 05 33019 91 11-JUL-23 29-AUG-23 11958994 HO 3149178257 05-MAR-19 1 21-JUL-19 00 11 09 42834 12603 02-AUG-19 04-SEP-19 12286319 HO 14499765 07-JUN-23 5 23-DEC-19 PB 03 07 90741 23 12-JUN-20 16-JUN-20 23-DEC-20 06 60288 1094 07-JUN-23 10-JUL-23 19-SEP-23 13405097 HO 14416617 10-MAY-23 6 04-JUN-22 PB 03 05 18540 6685 10-MAY-23 02-AUG-23 12610888 HO 14122112 01-APR-21 1 17-JUN-21 75 03 09 42834 14135 01-APR-21 22-JUN-21 12883670 BS 14098764 08-DEC-21 1 25-SEP-22 10 09 99010 440 08-DEC-21 01-SEP-22 09 99010 483 20-SEP-22 04-NOV-22 10739328 HO 11990334 07-DEC-15 1 03-SEP-16 00 11 07 90874 2208 09-SEP-16 06-OCT-16 15-AUG-18 07 90181 4636 16-AUG-18 10-OCT-18 11161088 HO 12736616 19-JUL-19 1 27-FEB-20 00 11 05 12977 1089 04-OCT-17 05-MAR-20 19-JUL-22 11027902 HO 12297587 13-JAN-21 3 21-SEP-20 02 05 32022 647 12-JAN-16 01-MAR-18 13384794 HO 14588932 05-JAN-23 1 25-JUL-23 PB 03 08 2949 6986 05-JAN-23 29-AUG-23 12238165 HO 14516363 14-NOV-22 1 07-APR-20 PB 03 08 1464 3039 14-NOV-22 01-MAY-20 13329053 HO 14458558 05-MAR-23 1 16-MAR-23 PB 03 05 18540 6186 05-MAR-23 14-AUG-23 Ended at: 2023.09.29 00:43 set pagesize 50000 spo c:\temp\ais3 @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 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 17645 05 2023.05.10 0 3 P P10 @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 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 22025 05 2021.04.10 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 23240 05 2021.09.12 0 2 P P12AP @c:\orawin\bin\aissupv 31742 05 2022.06.20 0 3 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 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 33019 05 2023.04.10 0 5 P P10 @c:\orawin\bin\aissupv 34879 09 2023.06.07 0 3 P P10AP spo off AISINVTRANS - wrong agy_id / non-field staff As of: 2023.09.29 03:44 ID BILL_TO_HRD_ID HR AG AG TEST_DATE EMPL_ SURNAME ---------- -------------- -- -- -- --------- ----- ----------------------------------- 1496599 1001 08 14 14 29-APR-22 24436 RECK 1 row selected. AISINVTRANS - Field staff on LEAVE As of: 2023.09.29 03:45 no rows selected set pagesize 50000 spo c:\temp\aiss spo off ANMFIND - looks for duplicate reg_ids As of: 2023.09.29 00:54 BRDB4BRT - looks for breedings before birthdate As of: 2023.09.29 00:55 Anm Id Prov Herd Comp# Birth Serviced Han Crtn Anm Crtn Brd Crtn Anb Reg num Anm Sire Serv Sire --------- ----- ------ ------- --------- --------- --------- --------- --------- --- ------------ ------------ ------------ 11161088 05 12977 1089 19-JUL-19 26-JAN-19 03-NOV-17 03-NOV-17 12-FEB-19 HO 12736616 12719303 11161088 05 12977 1089 19-JUL-19 18-FEB-19 03-NOV-17 03-NOV-17 07-MAR-19 HO 12736616 12571467 11161088 05 12977 1089 19-JUL-19 01-MAY-19 03-NOV-17 03-NOV-17 17-MAY-19 HO 12736616 11161088 05 12977 1089 19-JUL-19 11-MAY-19 03-NOV-17 03-NOV-17 17-MAY-19 HO 12736616 9160287 05 31802 410 18-NOV-22 25-MAR-14 09-OCT-12 09-OCT-12 11-APR-14 HO 11233400 13442778 64700328 12360979 05 31941 2648 28-MAY-23 23-JAN-23 25-AUG-20 25-AUG-20 03-FEB-23 HO 13424169 12609140 12360979 05 31941 2648 28-MAY-23 15-FEB-23 25-AUG-20 25-AUG-20 24-MAR-23 HO 13424169 12609140 14073840 12360979 05 31941 2648 28-MAY-23 09-MAR-23 25-AUG-20 25-AUG-20 24-MAR-23 HO 13424169 12609140 11027902 05 32022 647 13-JAN-21 13-MAY-17 14-JUL-17 14-JUL-17 14-JUL-17 HO 12297587 11027902 05 32022 647 13-JAN-21 08-NOV-19 14-JUL-17 14-JUL-17 29-NOV-19 HO 12297587 11027902 05 32022 647 13-JAN-21 14-DEC-19 14-JUL-17 14-JUL-17 22-JUN-20 HO 12297587 11027902 05 32022 647 13-JAN-21 22-DEC-20 14-JUL-17 14-JUL-17 02-FEB-21 HO 12297587 12286319 06 60288 1094 07-JUN-23 19-MAR-20 11-JUL-23 19-JUN-20 19-JUN-20 HO 14499765 3207410295 12948857 12286319 06 60288 1094 07-JUN-23 14-APR-20 11-JUL-23 19-JUN-20 19-JUN-20 HO 14499765 3207410295 3147224004 12286319 07 90741 23 07-JUN-23 19-MAR-20 19-JUN-20 19-JUN-20 19-JUN-20 HO 14499765 3207410295 12948857 12286319 07 90741 23 07-JUN-23 14-APR-20 19-JUN-20 19-JUN-20 19-JUN-20 HO 14499765 3207410295 3147224004 12238165 08 1464 3039 14-NOV-22 09-JUN-20 04-MAY-20 04-MAY-20 22-JUN-20 HO 14516363 40001206 3129016332 12238165 08 1464 3039 14-NOV-22 08-OCT-20 04-MAY-20 04-MAY-20 23-OCT-20 HO 14516363 40001206 3149236600 12238165 08 1464 3039 14-NOV-22 28-OCT-20 04-MAY-20 04-MAY-20 04-DEC-20 HO 14516363 40001206 3149236600 12238165 08 1464 3039 14-NOV-22 07-DEC-20 04-MAY-20 04-MAY-20 01-FEB-21 HO 14516363 40001206 3141428562 12238165 08 1464 3039 14-NOV-22 13-NOV-21 04-MAY-20 04-MAY-20 19-NOV-21 HO 14516363 40001206 11491921 12238165 08 1464 3039 14-NOV-22 23-NOV-21 04-MAY-20 04-MAY-20 31-DEC-21 HO 14516363 40001206 11491921 12238165 08 1464 3039 14-NOV-22 12-NOV-22 04-MAY-20 04-MAY-20 25-NOV-22 HO 14516363 40001206 3142352961 11225183 08 1819 2044 21-OCT-20 12-NOV-19 22-DEC-17 22-DEC-17 05-DEC-19 HO 12841975 12648714 11225183 08 1819 2044 21-OCT-20 25-APR-20 22-DEC-17 22-DEC-17 30-APR-20 HO 12841975 12925200 11225183 08 1819 2044 21-OCT-20 04-JUN-20 22-DEC-17 22-DEC-17 19-JUN-20 HO 12841975 13390583 11225183 08 1819 2044 21-OCT-20 24-JUN-20 22-DEC-17 22-DEC-17 15-JUL-20 HO 12841975 13390583 11225183 08 1819 2044 21-OCT-20 29-JUN-20 22-DEC-17 22-DEC-17 15-JUL-20 HO 12841975 13265391 11225183 08 1819 2044 21-OCT-20 21-JUL-20 22-DEC-17 22-DEC-17 28-AUG-20 HO 12841975 13265391 11225183 08 1819 2044 21-OCT-20 10-SEP-20 22-DEC-17 22-DEC-17 27-SEP-20 HO 12841975 13265391 11225183 08 1819 2044 21-OCT-20 01-OCT-20 22-DEC-17 22-DEC-17 05-NOV-20 HO 12841975 13265391 31 rows selected. CALQOLD - look for left-over Calc Queue Records As of: 2023.09.29 00:45 no rows selected CHK61080 - Part 1 looks for non transfer AR As of: 2023.09.29 00:55 PL/SQL procedure successfully completed. CHK61080 - Part 2 looks for missing batch no As of: 2023.09.29 00:55 no rows selected CHK61080 - Part 3 looks for non-transfer ais As of: 2023.09.29 00:55 no rows selected CHK61080 - Part 4 looks for cmi_ar_queues Error As of: 2023.09.29 00:55 no rows selected CONSCOS - looks for consecutive O/S in P herds , As of: ,2023.09.29 01:05 PR, ID,SERVICE_PL,TEST_DATE,H,SERVICE_PL,TEST_DATE,H --,----------,----------,---------,-,----------,---------,- 05, 15737,P5+5AP ,07-JAN-23,3,P5+5AP ,10-NOV-22,3 05, 10691,P5+5AP ,27-SEP-23,2,P5+5AP ,16-AUG-23,3 2 rows selected. CONSENT - look for non-null data_cnsnt ON / WC As of: 2023.09.29 00:45 Pr Herd Consent Herd Name -- -------- -------------- ------------------------------------------------- 05 33010 Unrecorded JEFF/EMILY VANMILTENBURG -- 05 33019 Unrecorded ALEX WYNANDS -- WYNGOLD FARMS 05 33023 Unrecorded JANET ACRES SMILEY -- ACREDALE FARMS 05 33034 Unrecorded WILSON / JANE BOWES -- TAY VIEW 4 rows selected. CTCENDED - looks for ended ctc with active opt As of: 2023.09.29 00:55 no rows selected CTLDIM - look for incorrect CTL DIM As of: 2023.09.29 02:49 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 8919859 HO CAN F 11460857 1 01 28-JAN-16 14-APR-16 505 508 05 31761 826 16-FEB-12 01-SEP-14 05 32341 103 01-OCT-14 09-OCT-14 18-OCT-18 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12536771 HO CAN F 13171718 1 01 07-JUN-21 27-SEP-21 333 334 05 32939 123 11-NOV-20 29-JAN-21 02-OCT-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9856868 HO CAN F 11974174 3 05 04-SEP-18 5 4 05 16129 951 09-JUL-14 01-SEP-16 04-SEP-18 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10163749 HO CAN F 12256155 1 01 29-JUN-18 24-JUL-18 421 -407 05 30629 569 15-APR-15 09-MAY-17 31-AUG-19 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9430264 HO CAN F 11608849 4 01 10-JUN-19 11-AUG-19 343 -63 05 10652 1949 05-MAY-13 17-JUN-15 30-MAR-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9782298 JE CAN F 11945024 3 01 21-SEP-19 08-NOV-19 401 403 05 30252 1044 27-APR-14 27-MAY-16 06-JUL-16 05 19905 728 22-SEP-18 19-OCT-18 12-NOV-19 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11828915 HO CAN F 12099560 1 05 19-SEP-19 274 273 05 32868 11 06-MAY-19 14-MAY-19 19-SEP-19 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11412239 HO CAN F 12366451 1 01 26-JUN-19 14-JUL-19 419 421 05 22456 1621 11-MAY-18 22-MAY-18 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12072526 HO CAN F 12772905 1 05 15-JAN-20 60 59 05 32435 160 04-DEC-19 06-DEC-19 15-JAN-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9274525 HO CAN F 11590798 5 05 23-DEC-19 12 13 09 72026 9225 04-JAN-13 08-OCT-13 05 23522 8097 15-MAR-15 17-MAR-15 23-DEC-19 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11377629 HO CAN F 13055888 1 05 07-APR-20 15 18 05 16332 1687 05-APR-18 07-APR-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9791763 HO CAN F 11839403 4 01 22-MAR-20 38 47 08 2778 911 17-MAR-14 10-NOV-16 10-APR-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11298092 HO CAN F 12885389 1 04 05-MAR-20 21 14 06 60514 916 05-FEB-18 07-APR-20 05-MAR-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9005065 HO CAN F 11584537 4 04 23-FEB-20 12 13 07 90840 4537 20-MAY-12 08-APR-15 23-FEB-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10952591 HO CAN F 12749429 2 01 19-MAY-20 11 18 09 35219 7363 19-APR-17 18-JUN-19 21-JUL-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9428605 HO CAN F 11580015 4 04 26-JUN-20 5 1 05 22001 614 01-JUN-13 31-MAY-16 13-JUL-16 05 31553 427 14-JUL-16 08-AUG-16 21-SEP-16 05 20743 620 01-OCT-16 25-OCT-16 26-JUL-17 05 16674 1203 17-OCT-17 17-OCT-17 26-JUN-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10497624 HO CAN F 11819622 4 04 23-JAN-20 9 7 05 31678 731 27-JAN-16 22-FEB-16 10-MAY-18 05 31678 945 18-DEC-18 23-JAN-19 23-JAN-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9373364 HO CAN F 11309816 7 05 04-AUG-20 22 23 05 14865 694 09-APR-13 11-APR-13 04-AUG-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10873271 JE CAN F 12695523 2 05 01-JUN-20 42 -19 05 18545 1111 08-JAN-17 10-DEC-18 01-JUN-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11202738 HO CAN F 13016876 1 04 04-FEB-20 07-APR-22 10 12 05 14795 1678 06-DEC-17 02-MAR-20 04-FEB-20 05 14795 1946 01-APR-22 05-MAY-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9979180 HO CAN F 11832512 4 05 27-APR-20 42 39 06 60124 2186 22-SEP-14 20-OCT-16 29-JUN-17 06 60944 108 08-AUG-18 13-AUG-18 27-APR-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10952378 HO CAN F 12355628 2 05 20-JUN-20 6 7 05 30970 510 13-APR-17 10-OCT-18 07 90724 307 11-OCT-18 07-JUN-19 20-JUN-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10129275 HO CAN F 11278055 5 05 18-OCT-20 18 17 05 14472 885 03-APR-12 24-MAR-15 18-OCT-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12409918 HO CAN F 12663004 1 05 15-DEC-20 91 92 05 31697 1535 24-SEP-20 07-OCT-20 15-DEC-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11069777 HO CAN F 12780999 2 05 10-NOV-20 33 7 09 52020 1522 26-JUL-17 23-OCT-19 10-NOV-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11688836 HO CAN F 12787269 1 05 11-FEB-21 61 62 09 18472 1794 06-DEC-18 19-JAN-21 11-FEB-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11667901 HO CAN F 12051581 2 05 17-FEB-21 829 830 05 30022 1612 22-NOV-18 19-DEC-18 24-APR-20 05 32915 1853 20-JUN-20 02-JUL-20 17-FEB-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11509183 HO CAN F 13186060 1 05 17-NOV-20 34 35 06 60944 483 07-JUL-18 25-NOV-20 17-NOV-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11652641 HO CAN F 13101053 1 05 12-NOV-20 12 13 05 20789 2101 10-NOV-18 25-NOV-20 12-NOV-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11652648 HO CAN F 13101059 1 05 19-NOV-20 8 9 05 20789 2108 27-NOV-18 25-NOV-20 19-NOV-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9112026 HO CAN F 11583379 5 05 05-JAN-21 13 15 05 13765 935 27-AUG-12 26-JUL-14 05-JAN-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9314082 HO CAN F 11757114 6 04 04-JAN-21 30 19 05 10656 1297 17-JAN-13 18-SEP-15 04-JAN-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10935472 HO CAN F 12479192 1 01 01-SEP-20 25-OCT-20 343 342 05 23464 728 20-MAR-17 20-OCT-18 05 32034 661 30-SEP-19 16-OCT-19 01-NOV-19 04 7639 3147 20-JAN-20 31-JAN-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11759009 HO CAN F 13133408 1 05 31-JAN-21 32 42 05 32780 203 23-FEB-19 03-FEB-21 31-JAN-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10298172 HO CAN F 12335764 4 05 04-AUG-20 5 6 05 13224 1534 23-JUL-15 25-JUL-17 04-AUG-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11677662 HO CAN F 13348663 1 05 12-NOV-20 20 4 05 12872 1644 14-DEC-18 01-DEC-20 12-NOV-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11557598 HO CAN F 12772223 1 04 08-OCT-20 1 3 05 11343 956 17-SEP-18 08-OCT-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12621367 HO CAN F 12144947 1 01 26-JAN-22 25-MAR-22 319 318 05 24105 553 18-APR-21 20-APR-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12451903 HO CAN F 13148213 1 04 20-NOV-20 11 1 05 32770 235 18-JAN-19 17-NOV-20 20-NOV-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12106940 MS CAN F 12144938 1 01 20-OCT-20 24-DEC-20 307 304 05 24105 530 08-JAN-20 10-JAN-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9627623 HO CAN F 9741914 8 04 12-FEB-21 42 40 05 10226 767 19-JAN-12 15-FEB-14 12-FEB-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11525620 HO CAN F 12803377 1 04 06-NOV-20 21 17 05 20851 2999 08-AUG-18 03-NOV-20 06-NOV-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11601822 HO CAN F 13259508 1 05 20-OCT-20 14 13 05 12872 1622 09-OCT-18 23-OCT-20 20-OCT-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9860477 HO CAN F 11995865 4 05 12-AUG-20 32 23 08 2350 1074 05-JUN-14 11-OCT-16 12-AUG-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11609620 HO CAN F 13156712 1 05 07-SEP-20 0 4 08 2350 1353 16-SEP-18 28-SEP-20 07-SEP-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10672979 HO CAN F 12610117 3 04 08-JAN-21 3 2 08 2451 1226 06-AUG-16 20-APR-18 08-JAN-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10677520 HO 840 F 3126218614 4 05 13-SEP-20 3 4 05 23522 9044 14-AUG-16 16-AUG-16 13-SEP-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10203722 HO CAN F 12084409 4 05 25-AUG-20 36 41 09 91691 133 18-MAY-15 16-MAY-17 25-AUG-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12225005 JE CAN F 12520622 1 01 18-FEB-21 10-APR-21 308 307 05 30249 1324 19-APR-20 21-APR-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12638422 HO CAN F 12871848 1 01 01-JUL-21 15-AUG-21 350 349 08 2933 35 02-MAY-21 03-MAY-21 07-APR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11553661 HO CAN F 11817999 3 05 20-APR-21 175 177 05 22625 741 04-MAY-16 18-SEP-18 20-NOV-19 05 30943 683 30-NOV-19 30-NOV-19 25-OCT-20 05 17158 788 01-DEC-20 09-DEC-20 20-APR-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12433605 HO 840 F 3148033771 1 01 07-OCT-21 01-JUN-22 387 384 05 15833 1930 29-OCT-20 29-OCT-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12010262 HO CAN F 12398650 1 05 06-AUG-21 28 29 05 14520 457 19-JUN-19 05-MAY-20 05 23858 657 22-MAY-20 06-AUG-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10158583 HO CAN F 12163190 4 05 06-APR-21 42 41 08 1142 1625 20-MAR-15 07-SEP-17 06-APR-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11365826 HO CAN F 12898032 2 01 14-MAY-21 7 9 08 1590 1879 26-MAR-18 24-NOV-18 08 2924 106 01-DEC-18 08-JUN-20 21-JUN-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12348581 HO CAN F 13095172 1 01 14-MAY-21 18-JUN-21 283 282 05 32435 173 11-AUG-20 13-AUG-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11869656 HO CAN F 13294300 1 05 15-JUN-21 11 7 07 90256 2254 18-JUN-19 24-JUN-21 15-JUN-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11425598 HO CAN F 13130083 2 05 20-SEP-21 92 62 05 32246 444 06-MAY-18 23-JUL-20 20-SEP-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10347088 HO CAN F 12164270 4 05 18-JUN-21 31 30 05 14550 1276 02-SEP-15 15-NOV-17 18-JUN-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12260338 HO CAN F 12738882 1 01 01-SEP-21 01-DEC-21 501 499 05 19656 1297 24-MAY-20 26-MAY-20 24-NOV-21 05 19321 1163 25-NOV-21 15-DEC-21 05-JAN-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12379638 HO 840 F 3143525360 1 01 17-OCT-21 07-JUN-22 411 409 05 32231 316 09-SEP-20 09-SEP-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10044571 HO CAN F 11951896 4 04 21-OCT-21 31 41 05 25373 868 19-DEC-14 22-JUN-16 05 18046 566 22-AUG-16 30-MAY-17 21-OCT-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12355634 HO CAN F 12526143 2 01 17-MAY-21 16-JUL-21 305 307 05 22533 1694 18-AUG-20 18-AUG-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10927779 HO CAN F 12736390 2 01 28-JUL-21 18-SEP-21 337 342 05 30764 41999 08-MAR-17 01-JUL-18 05 32939 77 27-JAN-21 29-JAN-21 28-SEP-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11065461 HO CAN F 12643809 2 05 23-AUG-21 295 -66 05 16897 763 29-JUL-17 17-SEP-19 23-AUG-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11626419 HO CAN F 13201796 1 04 26-AUG-21 26 27 08 1142 1866 27-OCT-18 02-SEP-21 26-AUG-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9198155 HO CAN F 11668478 7 05 08-SEP-21 0 1 05 25318 876 19-OCT-12 26-JAN-15 08-SEP-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11098837 HO CAN F 12688875 3 05 10-OCT-21 12 13 05 22079 3013 11-AUG-17 12-SEP-19 10-OCT-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10934112 HO CAN F 11354725 2 05 06-APR-21 16 17 07 90287 991 04-MAR-17 18-JAN-19 06-APR-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11868586 HO CAN F 12661883 3 05 23-MAR-21 15 13 05 15732 964 19-JUN-19 19-JUN-19 23-MAR-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12453751 HO CAN F 12679637 1 01 25-SEP-21 22-OCT-21 319 322 05 31388 891 18-NOV-20 18-NOV-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12424099 AY CAN F 12753189 1 01 20-JUL-21 17-SEP-21 316 317 05 30027 2270 28-SEP-20 21-OCT-20 11-AUG-21 05 18065 1382 31-AUG-21 31-AUG-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11802314 HO CAN F 13358304 1 04 07-JUN-21 43 44 06 60946 78 22-MAR-19 28-APR-21 07-JUN-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11161300 HO CAN F 12878094 2 05 14-APR-21 10 6 05 23044 883 26-OCT-17 18-JAN-20 14-APR-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11509059 HO CAN F 12166377 5 05 19-OCT-21 23 20 06 60944 341 14-JAN-16 13-AUG-18 19-OCT-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11947239 HO CAN F 13186193 1 05 05-OCT-21 18 16 06 60944 617 21-AUG-19 21-OCT-21 05-OCT-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11332492 HO CAN F 12857506 2 05 01-MAY-21 8 10 05 10222 4543 01-MAR-18 17-APR-20 01-MAY-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11227328 HO CAN F 12874050 2 01 28-JUL-21 26-SEP-21 286 -61 05 21627 840 27-NOV-17 08-JAN-20 24-FEB-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12498011 HO CAN F 13362826 1 01 23-NOV-21 03-DEC-21 378 377 05 16265 1105 27-DEC-20 29-DEC-20 20-MAR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12534307 GU CAN F 12936121 1 01 12-NOV-21 27-DEC-21 311 310 05 30151 803 26-JAN-21 28-JAN-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11116301 HO CAN F 12827355 3 04 02-MAR-22 3 8 05 13686 741 26-AUG-17 23-OCT-19 02-MAR-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11497283 HO CAN F 13126706 2 01 23-MAR-22 15-MAY-22 326 325 08 2719 3730 04-JUL-18 17-JAN-19 08 2937 3730 05-JUN-21 07-JUN-21 31-MAY-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10825340 HO CAN F 12544702 3 01 13-DEC-21 05-FEB-22 373 353 06 60198 2878 02-DEC-16 19-DEC-18 06-NOV-20 07 90468 2116 20-DEC-20 20-JAN-21 15-FEB-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12218032 HO CAN F 13567877 1 05 26-MAY-22 39 36 05 32594 3219 11-MAR-20 03-MAY-22 26-MAY-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11696812 HO CAN F 13110736 2 05 25-DEC-21 42 34 05 18752 948 07-DEC-18 14-DEC-20 25-DEC-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11745685 HO CAN F 13137996 2 04 15-DEC-21 5 6 05 16386 896 28-JAN-19 30-DEC-20 15-DEC-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10167130 HO CAN F 12134975 5 05 28-FEB-22 49 46 08 2147 518 13-APR-15 03-JUL-17 16-MAR-18 08 2147 672 04-MAR-19 18-MAR-19 28-FEB-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9576622 HO CAN F 11875810 7 05 25-APR-22 43 41 05 30974 3456 07-OCT-13 07-DEC-15 25-APR-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12572037 HO CAN F 13453037 1 01 22-MAR-22 18-MAY-22 386 385 05 32034 746 02-MAR-21 03-MAR-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12557511 HO CAN F 13227591 1 01 11-NOV-21 08-FEB-22 293 292 07 90728 1099 25-JAN-21 18-FEB-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12605265 HO CAN F 13076997 1 01 21-DEC-21 10-JUN-23 279 277 05 10893 1818 02-APR-21 02-APR-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12566693 HO CAN F 13049501 1 06 21-OCT-21 270 272 09 92090 6513 20-FEB-21 27-FEB-21 21-OCT-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11772464 HO CAN F 13359540 1 06 21-OCT-21 272 275 09 20624 1102 20-MAR-19 01-MAY-19 09 92090 6520 03-MAR-21 01-APR-21 21-OCT-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12169632 HO CAN F 13600811 1 01 31-MAY-22 28-JUL-22 284 283 09 42660 3218 26-OCT-19 23-SEP-20 09 42660 3601 01-DEC-21 11-DEC-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12238463 HO CAN F 13447336 1 05 03-MAR-22 14 15 05 31318 731 05-MAR-20 17-FEB-22 03-MAR-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11869623 HO CAN F 13421876 2 05 06-JUN-22 27 32 05 11762 1518 22-MAY-19 01-APR-21 06-JUN-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12275810 HO CAN F 13633821 1 05 11-APR-22 9 7 05 21308 2165 05-MAY-20 12-MAY-22 11-APR-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11768767 HO CAN F 203933800 3 01 30-DEC-21 03-MAR-22 322 323 09 47835 10903 07-FEB-19 15-MAR-19 27-JAN-21 09 47836 310 28-JAN-21 03-MAR-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10939146 JE CAN F 12751479 4 04 25-APR-22 2 3 09 26813 1042 13-MAR-17 13-MAY-19 17-NOV-21 09 61100 243 19-NOV-21 22-NOV-21 25-APR-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11389275 HO CAN F 12677230 1 01 06-JAN-21 26-FEB-21 339 344 09 88385 1109 11-APR-18 31-JAN-20 29-JAN-20 09 76130 8579 16-APR-20 18-APR-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10635748 HO CAN F 12505787 3 01 21-OCT-21 28-NOV-21 373 374 05 17704 1166 22-JUN-16 20-JUN-18 01-AUG-19 05 24536 1329 19-JAN-21 12-FEB-21 31-JAN-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12033719 HO CAN F 13481614 1 05 03-JAN-22 22 25 05 16659 762 07-OCT-19 06-JAN-22 03-JAN-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12600106 HO CAN F 12879117 1 01 16-NOV-21 03-JAN-22 272 274 05 32432 9864 18-FEB-21 22-MAR-21 06-DEC-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11504560 HO CAN F 13232403 3 05 05-MAY-22 9 11 05 10069 1458 04-AUG-18 16-JUN-20 05-MAY-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11867440 HO CAN F 13259346 1 05 27-NOV-21 28 15 05 18028 854 08-JUN-19 12-FEB-20 05 17240 1073 13-FEB-20 16-NOV-21 27-NOV-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12708269 HO 840 F 3134445449 1 01 28-MAR-22 18-APR-22 285 284 05 32872 73 17-JUL-21 10-SEP-21 15-OCT-21 05 21237 2000 02-NOV-21 04-NOV-21 17-DEC-21 05 32872 86 09-JAN-22 12-JAN-22 27-MAY-22 05 32872 123 13-AUG-22 15-AUG-22 16-NOV-22 05 10222 5603 17-NOV-22 09-DEC-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12183875 HO CAN F 13414430 1 05 23-FEB-22 27 26 08 2847 1309 08-FEB-20 01-MAR-22 23-FEB-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11715777 JE CAN F 12824563 1 01 15-MAR-22 03-JUL-22 379 381 05 19711 1120 04-JAN-19 19-MAY-20 05 32068 555 20-MAY-20 19-FEB-21 05 32872 41 07-MAR-21 09-MAR-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12531037 HO CAN F 13230111 1 01 22-NOV-21 11-FEB-22 378 376 05 18781 877 25-JAN-21 25-JAN-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11682912 GU CAN F 13262789 1 01 27-NOV-21 31-MAR-22 266 267 05 30154 965 19-DEC-18 09-MAR-21 29-SEP-21 05 32899 335 03-DEC-21 04-DEC-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12635154 HO CAN F 13072707 2 01 16-JAN-22 02-APR-22 361 359 05 22704 2502 03-MAY-21 03-MAY-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12118793 HO CAN F 13531118 1 05 05-JAN-22 31 30 05 32366 705 02-JAN-20 07-DEC-21 05-JAN-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12099137 HO CAN F 13344717 1 05 31-JAN-22 10 9 05 14472 1049 08-DEC-19 24-JAN-22 31-JAN-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12068629 HO CAN F 13282593 1 05 01-JAN-22 27 28 09 310 2151 27-OCT-19 01-JAN-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9767012 HO CAN F 11918389 5 01 05-DEC-21 12 13 05 16765 892 04-APR-14 23-NOV-16 05-DEC-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12072989 HO CAN F 13547952 1 05 09-DEC-21 27 25 09 13547 5980 14-OCT-19 09-DEC-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12160800 HO CAN F 13589411 1 05 26-JUL-22 164 162 05 13152 1052 04-FEB-20 11-FEB-22 05 32573 227 24-FEB-22 04-MAR-22 26-JUL-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10158663 HO CAN F 12089015 5 04 27-JUN-22 5 6 05 18541 641 19-APR-15 03-AUG-17 27-JUN-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12194014 HO CAN F 13431654 2 05 20-DEC-22 40 23 05 21594 1313 14-FEB-20 30-NOV-21 20-DEC-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11967338 HO CAN F 13375295 2 05 19-SEP-22 74 75 06 60501 20308 15-AUG-19 28-JUL-21 19-SEP-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12370639 HO CAN F 13777079 1 05 22-AUG-22 8 7 05 21864 1363 11-AUG-20 18-AUG-22 22-AUG-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10550105 HO CAN F 12293228 5 05 16-NOV-22 54 55 05 11762 1294 22-MAR-16 25-APR-18 16-NOV-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10057611 JE CAN F 11591383 6 05 13-DEC-22 10 28 05 30258 891 16-OCT-12 14-JAN-15 06-OCT-21 05 26046 1115 12-OCT-21 13-OCT-21 13-DEC-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12399462 HO CAN F 13757758 1 05 07-SEP-22 6 8 05 25356 2015 02-SEP-20 07-SEP-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12403476 HO CAN F 13758407 1 05 02-OCT-22 41 42 05 31365 10187 27-SEP-20 25-AUG-22 02-OCT-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12789396 HO CAN F 12984475 1 01 14-AUG-22 12-OCT-22 359 362 05 18847 812 22-SEP-21 28-SEP-21 13-JUL-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12763004 HO CAN F 13279742 1 01 27-JUN-22 12-AUG-22 298 296 05 24742 2551 06-SEP-21 08-SEP-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11937965 HO CAN F 13172271 1 01 11-AUG-22 10-SEP-22 305 304 05 24692 1060 12-AUG-19 30-JUL-20 05 32965 50 28-NOV-21 01-DEC-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12334475 JE CAN F 13771851 1 05 06-JUL-22 18 13 05 19711 1288 13-JUL-20 26-JUL-22 06-JUL-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10150474 HO CAN F 11940794 4 04 06-DEC-22 13 6 06 60853 794 24-MAR-15 15-AUG-17 06-DEC-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11704964 HO CAN F 13025032 1 01 03-NOV-22 21-FEB-23 395 -116 08 168 1370 22-DEC-18 13-OCT-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11922071 HO CAN F 12186825 4 05 29-AUG-22 6 4 05 12423 2058 04-AUG-19 06-AUG-19 29-AUG-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12388972 HO CAN F 13786929 1 05 30-AUG-22 21 19 06 60707 5377 30-AUG-20 20-AUG-22 30-AUG-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10328699 HO CAN F 12351122 6 04 30-AUG-22 3 2 06 60284 3354 18-AUG-15 28-JUL-17 30-AUG-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11538848 HO CAN F 43003015 1 05 05-NOV-20 2 1 06 60503 4768 19-AUG-18 13-NOV-20 05-NOV-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11253615 HO CAN F 13033047 3 05 13-FEB-23 14 3 05 25806 1374 03-JAN-18 04-NOV-20 13-FEB-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12072407 HO CAN F 13601795 1 01 17-OCT-22 07-DEC-22 365 367 08 458 2583 29-OCT-19 13-AUG-20 08 2944 130 11-OCT-22 30-OCT-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12532389 HO CAN F 14023430 1 05 19-DEC-22 49 50 06 60501 22709 03-JAN-21 02-NOV-22 19-DEC-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11986316 HO CAN F 13304997 2 05 16-NOV-22 20 21 05 14795 1792 03-SEP-19 16-DEC-21 16-NOV-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11652786 HO CAN F 12711327 2 01 25-SEP-22 15-DEC-22 277 278 05 32159 341 07-NOV-18 23-FEB-21 17-JUL-21 05 32978 32 01-JAN-22 22-APR-22 22-JUN-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10464952 HO CAN F 11956283 5 01 06-JUL-22 09-SEP-22 397 394 09 6578 3502 30-DEC-15 22-JAN-16 10-JUL-19 09 6578 5157 14-APR-20 16-APR-20 10-MAR-21 09 6578 6860 21-JUN-21 23-JUN-21 06-JUL-22 09 6578 9040 25-OCT-22 27-OCT-22 28-DEC-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12805234 HO CAN F 13845675 1 05 28-SEP-22 31 30 05 11519 1852 25-OCT-20 28-SEP-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11411446 HO CAN F 13126675 2 01 05-JUL-22 02-AUG-22 436 430 08 2719 3683 12-MAY-18 17-JAN-19 08 2937 3683 05-JUN-21 07-JUN-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12585494 HO CAN F 12683990 5 05 19-SEP-22 0 1 05 32945 104 26-OCT-16 17-MAR-21 19-SEP-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12413908 HO CAN F 13682719 1 05 19-JUL-22 17 7 05 16082 2467 06-SEP-20 19-JUL-22 19-JUL-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12325050 HO CAN F 13812721 1 05 16-JUL-22 10 9 05 25717 1503 20-JUL-20 16-JUL-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12005969 HO CAN F 12752729 4 05 28-NOV-22 76 72 05 16765 1146 14-SEP-19 09-OCT-19 28-NOV-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12695166 JE CAN F 12790522 2 01 16-JAN-23 27-MAY-23 80 233 05 15638 1886 04-JUN-21 07-JUL-21 05-JUN-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12164817 HO CAN F 13426635 1 01 22-APR-22 39 32 05 19872 876 24-JAN-20 06-JUL-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12498019 HO CAN F 13822049 1 05 19-DEC-22 15 14 05 21637 3366 01-DEC-20 19-DEC-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12498024 HO CAN F 13822050 1 05 19-DEC-22 14 15 05 21637 3367 05-DEC-20 19-DEC-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10729496 HO CAN F 12465900 5 05 01-NOV-22 17 16 05 10035 1454 24-SEP-16 20-AUG-18 01-NOV-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12353336 HO CAN F 13734189 1 05 30-JUN-22 25 24 05 23525 7196 16-AUG-20 07-JUL-22 30-JUN-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11371794 HO CAN F 12868964 3 04 01-AUG-22 230 -135 05 10141 2028 22-MAR-18 10-MAR-20 01-AUG-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12508801 HO CAN F 13923182 1 05 01-DEC-22 22 20 05 12872 1843 19-DEC-20 07-DEC-22 01-DEC-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12300411 HO CAN F 13608504 1 04 21-NOV-22 56 55 05 20851 3523 04-JUN-20 26-OCT-22 21-NOV-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10779183 HO CAN F 108686674 4 05 10-OCT-22 31 32 04 22849 402 14-OCT-16 22-OCT-18 05 32535 4357 23-OCT-18 08-FEB-19 01-OCT-20 04 2334 1564 14-OCT-20 15-OCT-20 10-OCT-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12240240 JE CAN F 13747860 1 05 13-JUL-22 19 17 09 92581 6956 28-APR-20 26-JUL-22 13-JUL-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10120383 HO CAN F 12162005 5 05 22-AUG-22 4 3 05 10207 1358 11-FEB-15 12-JAN-17 22-AUG-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11137965 HO CAN F 12394002 4 05 15-JUL-22 12 10 05 12931 941 08-SEP-17 19-OCT-17 05 23430 1430 20-OCT-17 19-SEP-19 15-JUL-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12181636 JE CAN F 13356393 2 04 26-DEC-22 23 22 08 748 3367 01-MAR-20 30-DEC-21 26-DEC-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11043309 HO CAN F 12619823 4 04 21-OCT-22 31 22 05 22107 719 06-JUL-17 19-JUN-19 21-OCT-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 9509701 HO CAN F 11381216 7 04 19-OCT-22 2 5 05 24105 433 16-AUG-13 11-DEC-15 19-OCT-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12439880 HO CAN F 13376089 1 05 31-OCT-22 56 57 06 60501 21887 16-OCT-20 21-SEP-22 31-OCT-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12183781 HO CAN F 13268053 1 05 16-NOV-22 18 26 09 1699 1165 13-FEB-20 16-NOV-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12279631 HO CAN F 13622133 1 05 08-NOV-22 231 229 05 31941 2598 09-JUN-20 28-DEC-22 08-NOV-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11520661 HO CAN F 13256841 3 04 09-NOV-22 7 8 09 78388 1145 19-AUG-18 01-OCT-20 09-NOV-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12675110 JE CAN F 14115971 1 05 19-JAN-23 18 16 05 19762 1791 07-MAY-21 19-JAN-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12442002 HO CAN F 13838433 1 05 06-FEB-23 62 64 07 90533 1605 05-OCT-20 16-FEB-23 06-FEB-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12543671 HO CAN F 13871475 1 05 23-JAN-23 3 4 06 60143 3085 08-JAN-21 23-JAN-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11961576 HO CAN F 13425460 2 05 26-APR-23 8 6 05 25886 1686 02-SEP-19 03-JUN-22 26-APR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12500585 HO CAN F 13804979 1 04 23-FEB-23 37 33 06 60944 893 14-DEC-20 02-MAR-23 23-FEB-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12588330 HO CAN F 13805017 1 05 01-MAR-23 42 38 06 60944 925 11-FEB-21 02-MAR-23 01-MAR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12440058 HO CAN F 13376499 1 05 06-MAR-23 82 83 06 60501 22013 28-OCT-20 21-DEC-22 06-MAR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12499994 HO CAN F 13007371 2 01 10-JUN-23 326 325 05 11057 2242 21-DEC-20 29-JUL-21 18-JUL-22 01 99484 1211 30-JUL-22 05-AUG-22 14-AUG-22 02 98676 1931 15-AUG-22 07-SEP-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11717769 HO CAN F 13117865 3 04 17-MAY-23 1 7 05 16217 1294 20-JAN-19 21-JUL-21 04-JAN-22 05 16217 1501 19-JUL-22 21-JUL-22 17-MAY-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 13355463 HO CAN F 12984462 2 01 07-MAY-23 04-JUL-23 364 365 05 33009 32 01-JUN-22 27-APR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11722560 HO CAN F 13280401 3 05 24-JAN-23 17 1 09 91141 2375 03-JAN-19 13-JAN-21 24-JAN-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 6874124 HO CAN F 10887219 5 05 04-MAR-17 5 1 08 2613 1209 20-DEC-09 18-JUL-12 04-MAR-17 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10576897 HO CAN F 12365269 6 01 04-JUN-23 2 5 07 90530 1268 21-MAR-16 20-NOV-17 17-DEC-21 07 90758 1268 18-DEC-21 19-JAN-23 03-AUG-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11492745 HO CAN F 13098399 2 04 16-AUG-21 5 1 09 16846 4192 09-JUL-18 19-AUG-20 16-AUG-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12997765 JE CAN F 13571589 1 10 15-MAR-23 13-MAY-23 318 323 05 23452 1919 11-JUL-20 27-APR-22 14-MAR-23 05 22307 1705 20-MAR-23 27-MAR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11148477 HO CAN F 12797554 2 04 20-NOV-20 5 1 05 11757 1478 21-SEP-17 03-OCT-19 20-NOV-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10785824 HO CAN F 12607065 4 05 04-FEB-23 11 1 05 13110 1009 13-NOV-16 23-NOV-18 04-FEB-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11504536 HO CAN F 13201006 1 05 07-JUL-20 16 1 05 31687 1670 02-AUG-18 10-JUL-20 07-JUL-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 13313569 HO CAN F 13186071 1 05 29-OCT-20 41 40 06 60944 280 06-AUG-18 22-SEP-20 29-OCT-20 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12510441 HO CAN F 13970800 1 05 27-MAR-23 96 86 05 32611 325 07-DEC-20 02-SEP-21 05 20295 15524 03-SEP-21 17-DEC-22 05 32611 442 15-JAN-23 17-JAN-23 27-MAR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12318243 HO CAN F 13442342 2 01 19-JUN-23 24-AUG-23 293 291 09 6578 5383 02-JUL-20 28-OCT-20 09 6578 6459 06-APR-21 08-APR-21 26-MAY-21 09 2577 353 08-JUL-21 08-JUL-21 23-OCT-21 09 84716 35685 29-OCT-22 31-OCT-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11905131 HO CAN F 13382222 2 05 01-MAR-23 18 19 07 90840 6431 22-JUN-19 01-FEB-22 01-MAR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12238668 HO CAN F 13436817 1 01 31-JAN-23 327 323 05 32091 2247 22-MAR-20 29-MAY-21 05 24112 4928 30-MAY-21 30-DEC-21 05 32600 4938 30-MAR-22 26-MAY-22 17-MAR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11331399 HO CAN F 12988107 3 04 25-JUN-22 2 1 09 35219 7908 19-FEB-18 04-MAR-20 25-JUN-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12000502 HO CAN F 13008392 3 05 10-AUG-23 26 27 05 31835 988 09-SEP-19 14-SEP-21 10-AUG-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12610803 HO CAN F 13703908 1 01 12-APR-23 15-JUN-23 386 385 09 6578 6295 06-APR-21 12-AUG-21 09 6578 8123 30-MAR-22 01-APR-22 12-APR-23 09 6578 10410 25-JUN-23 27-JUN-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11138679 MS CAN F 12718570 4 04 01-MAR-23 82 72 05 11719 1108 05-OCT-17 24-SEP-19 01-MAR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11520666 HO CAN F 13256836 3 04 30-MAY-23 2 3 09 78388 1140 23-JUL-18 26-JAN-21 30-MAY-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 13125054 HO CAN F 13845906 2 05 20-AUG-23 41 42 09 42850 6413 17-AUG-22 07-SEP-22 20-AUG-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12235894 HO CAN F 13524543 1 01 31-OCT-22 267 266 08 2499 4707 28-MAR-20 02-MAR-22 20-APR-22 08 2499 5639 27-FEB-23 28-FEB-23 29-APR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11865225 HO CAN F 13325421 1 05 28-APR-21 4 1 07 90547 1405 23-MAY-19 17-JUN-21 28-APR-21 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 12284105 HO CAN F 13815747 1 05 25-MAY-22 13 1 07 90845 1487 23-MAY-20 26-MAY-22 25-MAY-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11909798 HO CAN F 13319378 2 04 01-APR-23 20 16 08 2172 969 06-JUL-19 03-AUG-21 01-APR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 10493925 HO CAN F 12148781 5 04 08-OCT-22 4 1 08 742 2569 18-JAN-16 14-MAR-18 08-OCT-22 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 11299837 HO CAN F 12944707 3 10 18-JAN-23 01-MAR-23 307 276 05 23713 969 07-FEB-18 20-DEC-18 05 30730 3706 18-JAN-23 15-FEB-23 22-MAR-23 anm_id brd cou sex reg l# LER EndDate EndCycle DIM CalcDIM 13040640 HO CAN F 13946474 1 05 11-MAY-23 19 18 05 32982 688 02-MAY-21 11-MAY-23 PL/SQL procedure successfully completed. CTLDIM - completed As of: 2023.09.29 02:52 DRYCALV - looks for nbc_cd 20/21 with hts_cd 04 As of: 2023.09.29 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: 2023.09.29 01:06 ERAERROR - looks for ERA time with > 1 hour As of: 2023.09.29 00:45 no rows selected ERRLOG - AIS61080 errors in cmi_error_logs As of: 2023.09.29 00:45 no rows selected ERROPTS - looks for errors in cmi_option_queues As of: 2023.09.29 00:39 no rows selected no rows selected no rows selected ERROPTS Part 2 - looks for proc not printed As of: 2023.09.29 00:39 no rows selected FIND_SPACES Pt 1 - find extra spaces - Contacts As of: 2023.09.29 00:55 no rows selected FIND_SPACES Pt 2 - find extra spaces - FarmName As of: 2023.09.29 00:55 no rows selected FUTREND - Future end date but not Jan 01,2111 As of: 2023.09.29 00:55 Herd Pr Opt # Start date End date ------ -- ------ ----------- ----------- 32715 05 2015 Apr 18,2017 Oct 13,2023 32954 05 17 Aug 30,2022 Dec 31,2023 32981 05 17 Jul 07,2022 Dec 31,2023 32985 05 17 Jul 10,2022 Dec 31,2023 32986 05 17 Jul 17,2022 Dec 31,2023 32987 05 17 Jul 17,2022 Dec 31,2023 32991 05 17 Aug 30,2022 Dec 31,2023 32993 05 17 Oct 04,2022 Dec 31,2023 32994 05 17 Oct 16,2022 Dec 31,2023 33004 05 17 Feb 13,2023 Jun 30,2024 33007 05 17 Mar 12,2023 Jun 30,2024 33010 05 17 Apr 20,2023 Jun 30,2024 33011 05 17 Apr 25,2023 Jun 30,2024 33012 05 17 Apr 30,2023 Jun 30,2024 33015 05 17 May 03,2023 Jun 30,2024 33018 05 17 May 23,2023 Jun 30,2024 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 60964 06 17 Jan 23,2023 Jun 30,2024 60965 06 17 Mar 21,2023 Jun 30,2024 60966 06 17 Mar 23,2023 Jun 30,2024 90755 07 17 Jul 10,2022 Dec 31,2023 90760 07 17 Apr 25,2023 Jun 30,2024 2947 08 17 Mar 28,2023 Jun 30,2024 2948 08 17 Apr 19,2023 Jun 30,2024 32691 09 17 Jul 25,2023 Dec 30,2024 52125 09 17 Sep 15,2023 Dec 31,2024 36 rows selected. FUTREND - Future end date of Jan 01,2111 As of: 2023.09.29 00:55 no rows selected HTTPROB - looks for missing Htt records As of: 2023.09.29 00:55 no rows selected LACTNO - look for lact_no of 20+ As of: 2023.09.29 00:45 no rows selected LCSDRY - looks for negative dry days on lcs As of: 2023.09.29 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 -- ---------- ---------- ---------- ------------ ---- --------- --------- --------- ---------- ---- --------- --------- --------- 05 30846 643 6677735 9957734 5 09-AUG-16 06-JUN-17 08-AUG-16 -301 6 09-AUG-16 28-JAN-18 05 30966 489 10630053 12405524 2 12-APR-20 18-JAN-21 11-APR-20 -281 3 12-APR-20 02-MAY-21 05 32556 67 10519538 12262538 1 27-DEC-17 20-NOV-18 13-JAN-18 -310 2 14-JAN-18 24-NOV-19 29-JAN-20 09 67614 898 10859544 12603666 1 23-APR-19 07-FEB-20 03-JAN-20 -34 2 04-JAN-20 15-MAR-21 17-MAY-21 4 rows selected. LENDERR - inconsistent lcs and clc end_dates As of: 2023.09.29 00:37 Anm_id L# LE Lcs End Clc End LE Comp Herd Pr Enter Left DIM ---------- --- -- --------- --------- -- ------ ------ -- --------- --------- ---------- 9900586 5 05 01-JUL-22 14-NOV-22 01 1754 21637 05 16-AUG-14 01-JUL-22 517 10794647 5 01 03-JUL-23 17-JUL-23 05 5544 18540 05 28-AUG-22 17-JUL-23 347 11316603 3 09 18-JAN-23 13-JUL-22 05 315 32639 05 08-AUG-22 25-MAY-23 177 11483620 2 09 02-APR-23 28-MAY-22 06 2290 90468 07 30-MAY-22 96 11501741 2 01 25-JUL-22 01-SEP-22 05 632 32400 05 26-OCT-21 01-SEP-22 438 11634734 2 06 28-OCT-22 14-JAN-23 09 662 10713 05 23-OCT-18 28-OCT-22 12074334 1 09 29-OCT-22 15-NOV-21 05 67 60958 06 16-NOV-21 13 12093922 1 09 18-MAY-23 19-AUG-22 05 2668 15589 05 01-MAY-23 203 12139927 1 09 23-FEB-23 19-AUG-22 05 4933 32066 05 27-AUG-22 10-MAR-23 149 12146128 2 09 29-OCT-22 23-SEP-21 05 304 32496 05 24-SEP-21 79 12399483 1 09 08-AUG-23 23-SEP-22 05 856 31690 05 24-SEP-22 39 11 rows selected. LERNO - look for missing LER codes As of: 2023.09.29 00:47 Anm_id L# Lcs Start Lcs End LE Comp Herd Pr Enter Left Pd -------- --- --------- --------- -- ----- ------ -- --------- --------- -- ######## 8 01-MAR-23 01-MAR-23 819 30154 05 18-FEB-14 29-SEP-21 03 ######## 8 01-MAR-23 01-MAR-23 1195 32301 05 25-JAN-22 05-MAR-23 03 ######## 4 16-MAR-23 16-MAR-23 723 93680 09 04-JUN-17 16-OCT-20 03 ######## 4 16-MAR-23 16-MAR-23 4950 1099 08 17-OCT-20 05-APR-23 03 ######## 2 22-JAN-23 22-JAN-23 729 2767 08 11-FEB-20 06-FEB-23 03 ######## 2 21-AUG-23 21-AUG-23 2964 23747 05 27-JUL-20 28-AUG-23 03 6 rows selected. METERS - On option but none rented As of: 2023.09.29 00:55 no rows selected METERS - Not On option and some rented As of: 2023.09.29 00:55 no rows selected MLKHRS - looks for milking duration of 11+ hrs As of: 2023.09.29 00:45 no rows selected MLKHRS - looks for milking duration neg hrs As of: 2023.09.29 00:45 no rows selected NEGDIM - looks for negative dim in clc and ats As of: 2023.09.29 00:41 HRD_ID HR COMPTR_NO LEFT_HERD LCS_ANM_ID LCS_LACT_NO DIM LE LACT_END_ LAST_MODFD_BY ---------- -- ---------- --------- ---------- ----------- ---------- -- --------- ------------------------------ 13872 05 669 02-FEB-21 11590874 2 -547 05 02-FEB-21 OPS$PRDCMIP 16324 05 1016 13-JUN-21 11860061 2 -507 05 13-JUN-21 OPS$PRDCMIP 16589 05 937 22-SEP-21 11961525 2 -361 05 22-SEP-21 OPS$PRDCMIP 16589 05 956 22-SEP-21 12077910 2 -321 05 22-SEP-21 OPS$PRDCMIP 16679 05 294 09-MAY-22 11455389 3 -60 05 09-MAY-22 OPS$PRDCMIP 16699 05 1326 13-JUN-21 11815501 2 -370 05 13-JUN-21 OPS$PRDCMIP 19139 05 951 10-JUN-20 11137883 3 -772 05 10-JUN-20 OPS$PRDCMIP 19767 05 2009 20-OCT-21 11982601 3 -303 05 20-OCT-21 OPS$PRDCMIP 24900 05 813 15-FEB-08 5009425 2 -5265 05 15-FEB-08 OPS$PRDCMIP 24900 05 887 15-FEB-10 5869079 1 -4562 05 15-FEB-10 OPS$PRDCMIP 24900 05 781 01-JUN-08 4784736 2 -5162 05 01-JUN-08 OPS$PRDCMIP 24900 05 755 15-AUG-08 4636157 3 -5077 05 15-AUG-08 OPS$PRDCMIP 24900 05 739 10-MAY-07 4534008 3 -5519 05 10-MAY-07 OPS$PRDCMIP 24900 05 693 30-SEP-04 4320373 3 -6478 05 30-SEP-04 OPS$PRDCMIP 24900 05 681 25-OCT-03 4238047 4 -6851 05 25-OCT-03 OPS$PRDCMIP 24900 05 669 10-JAN-07 4220689 4 -5691 05 10-JAN-07 OPS$PRDCMIP 24900 05 658 13-NOV-06 4189585 4 -5616 05 13-NOV-06 OPS$PRDCMIP 24900 05 612 15-MAR-03 3901333 5 -7077 05 15-MAR-03 OPS$PRDCMIP 24900 05 655 01-MAY-05 4154298 4 -6324 05 01-MAY-05 OPS$PRDCMIP 32883 05 54 04-JAN-22 12164296 2 -338 05 04-JAN-22 OPS$PRDCMIP 60946 06 159 30-DEC-22 12592274 1 -33 05 30-DEC-22 OPS$PRDCMIP 90879 07 1356 19-JAN-20 11003707 3 -853 05 19-JAN-20 OPS$PRDCMIP 90879 07 1512 15-MAR-22 12052361 2 -288 05 15-MAR-22 OPS$PRDCMIP 1179 08 2689 26-AUG-22 11232763 3 -116 05 26-AUG-22 OPS$PRDCMIP 76123 09 998 26-JAN-22 12111804 2 -310 05 26-JAN-22 OPS$PRDCMIP 76871 09 95 31-OCT-21 12025910 2 -437 05 31-OCT-21 OPS$PRDCMIP 76871 09 88 29-NOV-21 11940164 2 -358 05 29-NOV-21 OPS$PRDCMIP 76871 09 98 29-MAR-22 12119467 2 -256 05 29-MAR-22 OPS$PRDCMIP 28 rows selected. no rows selected OPTCHCK - look for herds enrolled on Que option As of: 2023.09.29 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: 2023.09.29 00:55 no rows selected Anm Id AN COU S Reg_id PStat Ped Date LAST_MODF LAST_MODFD_BY ----------- -- --- - ------------ ----- ------------ --------- ------------------------------ 13504869 HO CAN F 01 28-SEP-23 OPS$PRDCMIP 13454368 FL CAN F 06 22-SEP-23 22-SEP-23 MMOHLE 13500880 HO CAN F 01 25-SEP-23 OPS$PRDCMIP 13503028 HO CAN F 01 27-SEP-23 OPS$PRDCMIP 13503093 HO CAN F 01 27-SEP-23 OPS$PRDCMIP 13503094 HO CAN F 01 27-SEP-23 OPS$PRDCMIP 13503095 HO CAN F 01 27-SEP-23 OPS$PRDCMIP 13503096 HO CAN F 01 27-SEP-23 OPS$PRDCMIP 8 rows selected. Start End Start End Start End Start End Start End Start End Start End Start End PL/SQL procedure successfully completed. PED07 - Completed As of: 2023.09.29 00:55 PSTLCD - look for invalid postal codes As of: 2023.09.29 00:45 Ctc_id Type Pr Ctc N Surname Adr Pst cd ------------- ----- -- ----- -------------------- --------- ---------- 1079213164 O 01 99802 MACNEILL 1 COB 1V0 1079212233 A 13561 GRANT 2 B2N6V1 1079218787 O 02 99187 VERMEULEN 1 B0N2H0 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 HEROUX 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: 2023.09.29 00:45 no rows selected RPLCTSTQ - look for multi replcmnt in 180 days As of: 2023.09.29 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: 2023.09.29 00:51 no rows selected SRVPNOPL - looks for herds without Service Plan As of: 2023.09.29 00:41 no rows selected SUPVHRD - incorrect cmi_herds spvse enrollment As of: 2023.09.29 00:40 no rows selected TANKLWT - looks for tank weight between 0 and 6 As of: 2023.09.29 00:39 no rows selected WEBLINK - looks for problems in web linking As of: 2023.09.29 00:55 no rows selected