search

bcgov / entity

ServiceBC Registry Team working on Legal Entities
Apache License 2.0
23 stars 57 forks source link

Correct Base Registrations with duplicate gc text #12098

Open mstanton1 opened 2 years ago

mstanton1 commented 2 years ago

In Zenhub 790 a client identified general collateral issues with two of their registrations. Doug has found a table of 198 base registrations with duplicate gc text, including the 2 registrations in this ticket. Registration numbers are in the attached file (tsv).

https://app.zenhub.com/files/377224980/a2dfb286-47e8-4c47-93c3-1ccd7f87f087/download

  1. BA to spot check to confirm that the issues are showing in PROD.
  2. Groom with team to identify the best way to resolve these.
mstanton1 commented 2 years ago

Changes made by Bob/Ali to data are unclear as there were various transforms done along export. It will be challenging to fix as a batch. A first step to fixing would be to obtain confirmation of how the data appeared in the legacy system.

I have sent a request to Advocette (May 6th) to determine if they can pull the legacy general collateral text for the list.

jinghualicgi commented 2 years ago

Revisited in May13th bug triage, need to wait for Ali

mstanton1 commented 2 years ago

Input from Doug:

https://app.zenhub.com/files/157936592/e7b375c3-c1a8-4ced-85f1-e54ed2ddfe3e/download Attached as .txt but should be saved at tsv when saved.

doug-lovett commented 2 years ago

@PatrickAHeath I have attached the TEST base registration information for the general collateral update to remove duplicate text. Do you want to review it before I update the TEST database?

Rename the spreadsheet file type to .tsv after downloading

https://app.zenhub.com/files/157936592/e9f85897-09aa-4362-8128-924815a45eae/download

PatrickAHeath commented 2 years ago

@doug-lovett @mstanton1 Started spot checking - 768940K looks good!

180523N & 458775N - still show duplicated lines.

Where would I find the Legacy PPR GC text?

mstanton1 commented 2 years ago

Patrick's analysis compared the data we had in PPR PROD to the files that resulted from Doug's update. In most cases these were fine but a few had differences we could not verify. As per discussion today the decision is to compare a number of files against the Legacy PPR general collateral.

Request sent to Ali for Legacy PPR files for:

277102K 852306M 896435K 5683325 459834N 564113H 987217J

PatrickAHeath commented 2 years ago

@doug-lovett The spreadsheet doesn't included updated text for 564113H in column D. This is the extremely large GC text example - should we just compare to what was loaded initially?

doug-lovett commented 2 years ago

@PatrickAHeath in the general-collateral-remove-duplicate.tsv file I see a column D updated_desc value for row 27:

LEASING AGREEMENT 2165719001 (120006426073) (4) ACCESS POINT NTG- 335L2VR (RFU) AND NTJ-111R (IFU) (S/N'S PA07275, PA07276, PA07276, PA07277, PA07278) (4) ACCESS POINT NTG-335L2HR (RFU) AND NTJ-111R (IFU) (S/N'S PA07042, PA07265, PA07266, PA07267), (13) WIRELESS TERMINAL NTG-337L0UR (S/N'S: PD02090, PD02091, PD02102, PD02103, PD02104, PD02105, PD02106, PD02107, PD02108, PD02109, PD02110, PD02111, PD02112) (6) ACCESS POINT NTG-335L0HR, (RFU) AND NTJ-111R (IFU) (S/N'S PA07251, PA07252, PA07253, PA07254, PA07255, PA07256) (20) NBG-399R - WT AC/DC ADAPTOR. (20) H - 7ZCCM0132 - WT AC / DC ADAPTOR CABLE (20) NQD-2049R - WT ADAPTOR (7) WIRELESS TERMINAL NTG - 337L0UR (S/N'S PD02391, PD02392, PD02393, PD02394, PD02395, PD02396, PD02397) (21) WIRELESS TERMINAL NTG-337L2UR (S/N'S PD02431, PD02432, PD02433, PD02434, PD02435, PD02436, PD02437, PD02438, PD02439, PD02440, PD02441, PD02442, PD02443, PD02444, PD02445, PD02446, PD02447, PD02448, PD02449, PD02450, PD02451) (4) ACCESS POINT NTG - 335L0VR (RFU) AND NTJ-111R (IFU) (S/N'S PA07258, PA07259, PA07260, PA07261) . EQUIPMENT LOAN AND SECURITY AGREEMENT 2165720001 (150011536471) INVOICE 00002-00466145 (45) 94-PPT-B REDLINE SINGLE AC POWER CORD TYPE B PLUG (25) 94-80L15-B-U-T35 AN801 SYSTEM 3.650-3.7 GHZ HIGH SPEED PMP S/NS 075EM08490010, 075EM08490081,075EM08500026 075EM08500029, 075EM09100205, 075EM09110196 075EM09110452, 075EM09110528, 075EM09110539 075EM09110546, 075EM09110553, 075EM09110559 075EM09110560, 075EM09110567, 075EM09110593 075EM09110670, 075EM09110673, 075EM09110682 075EM09110706, 075EM09110727, 075EM09110732 075EM09110743, 075EM10100056, 075EM10100068 075EM10100087. (20) 94-80L15-S-U-T35 AN80L SYSTEM 3.650-3.7 GHZ SPPED PMP S/NS. 075EM09100022, 075EM09110259, 075EM09110541 075EM09110548, 075EM09110557, 075EM09110667 075EM09110671, 075EM09110672, 075EM09110674 075EM09110679, 075EM09110680, 075EM09110687 075EM09110689, 075EM09110691, 075EM09110694 075EM09110697, 075EM09110699, 075EM09110702 075EM09110714, 075EM09110717 (45) 94-80L-HD-MNT - HEAVY DUTY MOUNTING KIT, VERTICAL MAST (45) 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET PROMO ALL06082010TGO INVOICE 00002-00466123, (66) 94-80L-HD-MNT HEAVY DUTY MOUNTING KIT VERTICAL MAST. (66) 94-80L-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET (66) 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG (20) 94-80L01-S-H-T58 REDLINE AN80 PMP INTEGRATED, 5.8 GHZ S/NS. 075SC10140349, 075SC10140360, 075SC10140389 075SC10170013, 075SC10180011, 075SC10180047 075SC10180059, 075SC10180120, 075SC10180143 075SC10180155, 075SC10180168, 075SC10180231 075SC10180318, 075SC10180361, 075SC10190255 075SC10200007, 075SC10200117, 075SC10200179 075SC10200248, 075SC10200256 (5) 94-80L05-B-L-T54 REDLINE AN-80L PTMP BASE STATION 36MBPS S/NS. 075SC10090147, 075SC10100096, 075SC10140035 075SC10140076, 075SC10140154 (20) 94-80L05-S-H-T54 AN-80L SUSCRIBER UNIT 5.4 GHZ S/NS 075SC10090124, 075SC10090143, 075SC10090148 075SC10100022, 075SC10100047, 075SC10100121 075SC10100221, 075SC10100261, 075SC10140001 075SC10140002, 075SC10140012, 075SC10140044 075SC10140070, 075SC10140097, 075SC10140099 075SC10140113, 075SC10140115, 075SC10140250 075SC10140252, 075SC10190220 (6) 94-80L09-B-L-T49 AN80L TERMINAL SYSTEM, 36MBPS W/PMP 075SC10180074, 075SC10220421, 075SC10230113 075SC10230127, 075SC10230247, 075SC10230397 (15) 94-80L09-S-H-T49 AN80L TERMINAL SYSTEM, W PMP SUBSCRIBER OPERATION S/NS 075SC10220153, 075SC10220385, 075SC10220401, 075SC10220413, 075SC10220420, 075SC10220458, 075SC10230005, 075SC10230018, 075SC10230048, 075SC10230065, 075SC10230090, 075SC10230106, 075SC10230122, 075SC10230210, 075SC10230215 INVOICE 00002-00466195 (1) 88.A.INK.HCC.AC.NA.R1 HORIZON COMPACT COPPER CONNECTORS AC (1) 88.A.ANT-38G-12-C, ANTENNA;38GHZ;1' ANTENNA;CLIP MOUNT (1) 88-HC-100-HP-38-B5-00-C-R1 HORIZON COMPACT 100;HP;38 GHZ BAND 5;COPPER 100/1000BT INVOICE 00002-00466172, (1) 88-A-ANT-38G-12-C ANTENNA;38GHZ;1' ANTENNA;CLIP MOUNT INVOICE 00002-00466188, (32) 94-80I-HD-MNT HEAVY DUTY MOUNTING K T, VERTICAL MAST (32) 94-801-POE-1A, POWER INJECTOR SINGLE 10/100 ETHERNET (32) 94-PPT-B, REDLINE SINGLE AC POWER CORD: TYPE B PLUG (12) 94-80I09-P-H-T49, AN80L SYSTEM TERMINAL, 54MBPS S/NS 075SC10180449, 075SC10220397, 075SC10230023 075SC10230069, 075SC10230080, 075SC10230091 075SC10230112, 075SC10230133, 075SC10230139 075SC10230151, 075SC10230238, 075SC10230325 (12) 94-80L05-P-H-T54 5.4 GHZ PTP AN80L S/NS 075SC10180198, 075SC10180242, 075SC10180323 075SC10180403, 075SC10180550, 075SC10180565 075SC10180578, 075SC10180616, 075SC10180617 075SC10180665, 075SC10180730, 075SC10180735 (8) 94-80L01-P-H-T58 REDLINE AN80 PTP INTEGRATED, 5.8 GHZ, 54 MBPS S/NS 075SC10180111, 075SC10180349, 075SC10180685 075SC10190194,075SC10200069,075SC10200136,075SC10200195, 075SC10200208 INVOICE 00002-004466189, (1) 88-A-OPT-HWR-RMTW-38 RACK MOUNT TEST SETUP W/ WAVEGUIDE 38 GHZ INVOICE 00002-00466263, (1) 94-80L05-S-H-T54 AN-80L SUBSCRIBER UNIT 5.4GHZ S/N 075SC10180288 (1) 94-801-HD-MNT, HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-801-POE-1A, POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B, REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00466262, (1) 94-80I05-S-H-T54 AN-80L SUBSCRIBER UNIT 5.4GHZ S/N 075SC10180560 (1) 94-80I-HD-MNT, HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A, POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B, REDLINE SINGLE AC POWER CORD: TYPE B PLUG DT TIRE DISTRIBUTION INVOICE 00002-00466495, (1) 94-80L05-S-H-T54 AN-80L SUBSCRIBER UNIT 5.4GHZ S/N 075SC10100234 (1) 94-80L-HD-MNT, HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80I-POE-1A, POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B, REDLINE SINGLE AC POWER CORD: TYPE B PLUG (1) TER-MT-485028/N S/N 14738 1 FT ATENNA, (1) TER-1101-898 SURGE SUPPRESSOR, (1) TER-1000-1164 POLE MOUNT (1) TER-JUMPER-CABLE JUMPER CABLE (1) TER-POE-HOLDER POE HOLDER . INVOICE 00002-00466499, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10180211 (1) 94-80L-HD-MNT, HEAVY DUTY MOUNTING KIT. VERTICAL MAST (1) 94-80L-POE-1A, POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT -B, REDLINE SINGLE AC POWER CORD: TYPE 8 PLUG INVOICE 00002-00466528, (1) 94-80L01-5-H-T58 REDLINEAN80 PMP INTEGRATED. 5.8 GHZ, SUBSCRI S/N 075SC10200096 (1) 94-80L-HD-MNT, HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A, POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B, REDLINESINGLEAC POWER CORD: TYPE B P (1) TER-JUMPER-CABLE JUMPER CABLE, (1) TER-POE-HOLDER POE HOLDER (1) TER-1101-898 SURGE SUPPRESSOR, (1) TER-1000-1164 POLE MOUNT (1) TER-MT-485028/N 1 FT ATENNA INVOICE 00002-00465338, (1) 88-A-OPT-HWR-FTB-2-A DRAGONWAVE 1 FOOT MOUNT, (1) 88-A-OPT-HWR-FTB-2.5-A 2.5' ANDREW ANTENNA MOUNT INVOICE 00002-00465304, (8) 94-80L01-P-H-T58 REDLINE AN8O PTP INTEGRATED, 5.8 GHZ, 54 MBPS S/NS 075EM10020052, 075EM10030200, 075SC10060031 075SC10060046, 075SC10090110, 075SC10100245 075SC10170099, 075SC10180010. (1) 94-80L-POE-1A POWER INJECTOF SINGLE 10/100 ETHERNET, (1) 94-PPT-8 REDLINE SINGLE AC POWER CORD: TYPE B PLUG. (1) 94-HD-MNT HEAVY DUTY MOUNT KIT FOR REDMAX CPE INVOICE 00002-00465284, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10090024 (1) 94-8OI-HD-MNT, HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A, POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B, REDLINE SINGLE AC POWER CORD: TYPE B PLUG TAG SITE - SIMR01 SS01 INVOICE 00002-00465341, (1) 88-A-ANT-24G-48-C 4FT ANTENNA 24GHZ DEMS INVOICE 00002-00465360, (8) 94-80L01-P-H-T58 REDLINE AN80 PTP INTEGRATED, 5.8 GHZ, 54 MBPS S/NS 075SC10140203, 075SC10140354, 075SC10170034 075SC10170074, 075SC10180077, 075SC10180117 075SC10180174, 075SC10180295. (8) 94-80L-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. (8) 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG. (8) 94-801-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST INVOICE 00002-00465343, (2) 94-A3204PWP REDLINE PARABOLIC ANT: 3 FOOT, 4 DEG, 32 DBI INVOICE 00002-00465367, (1) 94-80L01-S-H-T58 REDLINE AN80 PMP INTEGRATED, 5.8 GHZ, SUBSCRI S/N 075SC10180378 (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B, REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465365, (1) 94-80L01-S-H-T58 REDLINE AN80 PMP INTEGRATED, 5.8 GHZ, SUBSCRI S/N 075SC10170109 (1) 94-80L-HD-MNT, HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465408, (1) 94-80L05-S-H-T64 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10090194 (1) 94-80L-HD-MNT. HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-8OI-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465407, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10140111 (1) 94-80L-HD-MNT. HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465409, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10090173 (1) 94-80L-HD-MNT. HEAVY DUTY MOUNTING KIT, VERTICAL MAST 1) 94.80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465410, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10100279 (1) 94-80L-HD-MNT. HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465411, (1) 94-80L05-S-H-T54 AN-8OI SUBSCRIBER UNIT 5.4GHZ S/N 075SC10100144 (1) 94-80L-HD-MNT. HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465412, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10140140 (1) 94-80L-HD-MNT. HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465363, (1) 94-80L05-S-H-T58 REDLINE AN80 PMP INTEGRATED, 5.8 GHZ, SUBSCRI S/N 075SC10180225 (1) 94-80L-HD-MNT. HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465364, (1) 94-80L01-S-H-T58 REDLINE AN80 PMP INTEGRATED, 5.8 GHZ, SUBSCRI S/N 075SC10170106 (1) 94-80L-HD-MNT. HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465430, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10100238 (1) 94-80L-HD-MNT. HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465457 (20) 94-80I15-B-U-T35 AN80I SYSTEM 3.650-3.700 GHZ HIGH SPEED PMP S/NS 075EM09100053, 075EM09100142, 075EM09100210 075EM09110103, 075EM09110163, 075EM09110179 075EM09110317, 075EM09110318, 075EM09110378 075EM09110382, 075EM09110385, 075EM09110430 075EM09110494, 075EM09110522, 075EM09110529 075EM09110537, 075EM09110547, 075EM09110570 075EM09110701, 075EM09110744 (25) 94-80L15-S-U-T35 AN80I SYSTEM 3.650-3,700 GHZ HIGH SPEED PMP S/NS 075EM09100130, 075EM09100263, 075EM09110319 075EM09110492, 075EM09110503, 075EM09110527 075EM09110530, 075EM09110533, 075EM09110538 075EM09110544, 075EM09110551, 075EM09110561 075EM09110564, 075EM09110566, 075EM09110676 075EM09110681, 075EM09110688, 075EM09110690 075EM09110695, 075EM09110698, 075EM09110700 075EM09110705, 075EM09110709, 075EM09110711 075EM09110730. (45) 94-80L-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. (45) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET. (45) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465648, (1) 94-80IRR-SH-PL UPGRADE FROM SH (PMP) TO PL (PTP) INVOICE 00002-00465694, 94-A3204PWP REDLINE PARABOLIC ANT: 3 FOOT, 4 DEG, 32 DBI INVOICE 00002-00465729, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10140302 (1) 94-80L-HD-MNT. HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465728, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10140139 (1) 94-80L-HD-MNT. HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465723, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10090113 (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B. REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465724, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10090049 (1) 94-80L-HD-MNT. HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465725, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10140297 (1) 94-80L-POE-1A. POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465727, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10140078 (1) 94-80L-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST (1) 94-80L-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00465726, (1) 94-80L05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/N 075SC10140021 (1) 94-80L-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET (1) 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00464466 , (4) 94-80L-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. (4) 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. (4) 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG (1) 94-RAPMP-KIT-4-T49(16QAM) STARTER KIT, BASE STATION WHICH INCLUDES 3 SUBSCRIBERS S/N 075EM10030193 INVOICE 00002-00464506, (1) 88-A-INK-HCC-AC-NA-R1 HORIZON COMPACT COPPER CONNECTORS AC. (1) 88-HC-100-HP-18-B1-00-C-R1 HORIZON 100MBPS 18GHZ. HIGH POWER BAND 1 INVOICE 00002-00464526 , (1) 88-A-INK-HCC-AC-NA-R1 HORIZON COMPACT COPPER CONNECTORS AC. (1) 88-HC-100-HP-24-B1-00-C-R1 HORIZON COMPACT 100 HIGH POWER 24 GHZ BAND INVOICE 00002-00464527 , (2) 8B-HC-100-HP-24-B1-00-C-R1 HORIZON COMPACT 100 HIGH POWER 24 GHZ BAND 1. (2) 88-A-INK-HCC-AC-NA-R1 HORIZON COMPACT COPPER CONNECTORS AC INVOICE 00002-00464604 , (1) 88-A-INK-IDU-AC-NA-R4 AIRPAIR IDU INSTALL KIT, RELEASE 4 INVOICE 00002-00464686, (1) 94-80IRR-SH-PL UPGRADE FROM SH (PMP) TO PL (PTP)00-09-02-02-2C-6F.(1)94-80IRR-PB-PL AN80L SOFTWARE UPGRADE FROM PB TO PL 00-09-02-02-2E-CB INVOICE 00002-00464742 (3) 94-80L-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST (3) 94-80L-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET (3) 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG (3) 94-80I09-P-H-T49 AN80L SYSTEM TERMINAL, 54MBPS S/NS 075EM09390062, 075EM09390066, 075EM09390122 INVOICE 00002-00465487 (15) 94-80I01-S-H-T58 REDLINE AN80 PMP INTEGRATED, 5.8 GHZ, SUBSCRI S/NS 075EM10030167 075SC10140338, 075SC10140444, 075SC10140483 075SC10170003, 075SC10170010, 075SC10170076 075SC10170093, 075SC10170108, 075SC10170116 075SC10180042, 075SC10180050, 075SC10180064 075SC10180067, 075SC10180084 (10) 94-80I05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ S/NS 075SC10090009, 075SC10090139, 075SC10090187 075SC10100135, 075SC10100145, 075SC10100272 075SC10100274, 075SC10100278, 075SC10140142 075SC10140300. (7) 94-80I09-S-H-T49 AN80I TERMINAL SYSTEM, W PMP SUBSCRIBER OPERATION S/NS 075EM09330085, 075EM09370406 075EM09370422, 075EM09390146, 075EM09440021 075EM09440031, 075EM09450120. (48) 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. (48) 94-PPT-B REDLINE SINGLE AC POWER CORD:TYPE BPLUG. (48) 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. (5) 94-80I01-B-L-T58 AN-80I PTMP BASE STATION 36 MBPS S/NS 075SC10180109, 075SC10180183, 075SC10180280 075SC10180369, 075SC10180411. (3) 94-80I09-B-L-T49 AN80I TERMINAL SYSTEM, 36 MBPS W/PMP S/NS 075EM10030113, 075EM10030156,075EM10030260 . EQUIPMENT LOAN AND SECURITY AGREEMENT 2165721001 (150011607476) INVOICE # 00002-00467856, (94) -80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. (94)-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET (94)-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG (10) 94-80I15-P-U-T35 AN80I SYSTEM 3.65-3.7 GHZ HIGH SPEED PTP S/NS 075EM08510080, 075EM10100016, 075EM10100025, 075EM10100038, 075EM10100054, 075EM10100072, 075EM10100119, 075SC10250308, 075SC10260074, 075SC10260083 INVOICE # 00002-00469194. TER -JUMPER CABLE, TER -POLE -HOLDER TER-1101-898 SURGE SUPPRESOR. TER-1000-1164 POLE MOUNT ONE (1) TER-MT-485028/N 1 FT ANTENNA, S/N 14647 ONE (1) 94-80I05-S-H-T54 5.4GHZ PTP AN80I 5.4GHZ, S/NS 075SC10330224. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00469350, ONE(1)94-80I15-B-U-T35 AN80I SYSTEM 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC10260113, 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT,VERTICAL MAST,94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00466759, 94-RC80-OW OUT OF WARRANTY REPAIR ON AN AN80, S/N 1146. INVOICE # 00002-00469262 94-80I15-S-U-T35 AN80I SYSTEM 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC10250282. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00469469, TER -JUMPER CABLE. TER -POLE -HOLDER TER-1101-898 SURGE SUPPRESOR. TER-1000-1164 POLE MOUNT ONE (1) TER-MT-405006/N 3.65 CPE FLAT PANEL ANTENNA, S/N 00208 ONE (1) 94-80I15-S-U-T35 AN80I SYSTEM 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC10260193. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00471305, 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. INVOICE # 00002-00471255 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST INVOICE # 00002-00467824, 94-80I09-S-H-T49 AN80I TERMINAL SYSTEM, W PMP SUBSCRIBER OPERATION S/N 075SC10250031 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG 94 -80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST INVOICE # 00002-00470450, 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG 94-80I01-B-L-T58 AN-80I PTMP BASE STATION 36MBPS, S/N 075SC10200203 (3) 94-80I01-S-H-T58 REDLINE AN80 PMP INTEGRATED, 5.8GHZ, S/N 075SC10200099, 075SC10200160, 075SC10200451 (1) 94-80I05-B-L-T54 REDLINE AN-80I PTMP BASE STATION 36 MBPS, S/N 075SC10280194. (5) 94-80I05-S-H-T54 AN -80I SUBSCRIBER UNIT 5.4GHZ, S/NS 075SC10230019, 075SC10280036, 075SC10280154, 075SC10290089, 075SC10290145. (5) 94-80I15-B-U-T35 AN80I SYSTEM 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC10330226, 075SC10330181, 075SC10330290, 075SC10330403, 075SC10330424. (1) 94-80I09-B-L-T49 AN80I TERMINAL SYSTEM, 36 MBPS W/PMP, S/N 075SC10360023. (4) 94-80I09-S-H-T49 AN80I TERMINAL SYSTEM, W PMP SUBSCRIBER OPERATION, S/NS 075SC10360048, 075SC10360096, 075SC10380075, 075SC10380151, (2) 94-80I05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ, S/NS 075SC10250264, 075SC10260109. 94-80IRR-SH-PH UPGRADE FROM SH (PMP) TO PH (PTP). INVOICE # 00002-00471660 SIX (6) 94-80I05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ, S/NS 075SC10060050,075SC10190297,075SC10240133,075SC10250007,075SC10280041 075SC10280167. FOUR (4) 94-80I05-B-L-T54 REDLINE AN-8OI PTMP BASE STATION. 36 MBPS, S/NS 075SC10240216, 075SC10280032, 075SC10280069, 075SC10280083. FIVE (5) 94-80I01-S-H-T58 REDLINE AN80 PMP INTEGRATED, 5.8GHZ, S/NS 075SC10220182, 075SC10220189, 075SC10220359, 075SC10220377, 075SC10220455. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST INVOICE # 00002-00469918, 94-80IGASKET WEATHERPROOFING GASKET FOR AN80I. INVOICE # R-1606-L, WIRELESS TERMINAL NTG-337X0URS/N'S:PD02411, PD02412, PD02413, PD02414, PD02415WIRELESS TERMINAL NTG-337X2UR S/N'S: PD02465, PD02466, PD02467, PD02468. INVOICE # 00002-00470124 94-A1815MTFD ANTENNA, 1 FOOT, 15 DEGREE, 18.5DBI FLAT. 94-80I-LW-MNT LIGHT WEIGHT MOUNTING KIT, VERTICAL MAST. INVOICE # 00002-00469414 ONE (1) 94-80I05-S-H-T54 AN 80I SUBSCRIBER UNIT 5.4GHZ, S/N 075SC10330237. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG TER -JUMPER CABLE, TER -POLE -HOLDER. TER-1101-898 SURGE SUPPRESOR TER-1000-1164 POLE MOUNT. ONE (1) TER-MT-485028/N 1 FT ANTENNA, S/N 13760. INVOICE # 00002-00468568, TER -JUMPER CABLE, TER -POLE -HOLDER. TER-1101-898 SURGE SUPPRESOR. TER-1000-1164 POLE MOUNT. ONE (1) TER-MT-484026/VHN MTI 60 DEG SECTOR ANTENNA, S/N 00597. ONE (1) 94-80I09-B-L-T49 AN80I TERMINAL SYSTEM, 36 MBPS W/PMP, S/N 075SC10280156. 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. 94-801-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG. INVOICE # 00002-00469298, ONE (1) 94-80I09-S-H-T49 AN80I TERMINAL SYSTEM, W PMP SUBSCRIBER OPERATION, S/N 075SC10300135 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00471862, THREE (3) 94-80I15-B-U-T35 AN80I SYSTEM 3.6 -3.7 GHZ HIGH SPEED PMP, S/N 075SC10360194, 075SC10400021, 75SC10330382. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST INVOICE # 00002-00469299, 94-80I05-P-H-T54 5.4GHZ PTP AN80I S/N 075SC10330358. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST INVOICE # 00002-00471658, TER -JUMPER CABLE, TER -POLE -HOLDER TER-1101-898 SURGE SUPPRESOR. TER-1000-1164 POLE MOUNT ONE (1) TER -MT-485028/N 1 FT ANTENNA, S/N 14617 ONE (1) 94-80I01-S-H-T58 REDLINE AN80 PMP INTEGRATED, 5.8GHZ, S/N 075SC10220457. 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00469191, TER -JUMPER CABLE. TER -POLE -HOLDER TER-1101-898 SURGE SUPPRESOR. TER-1000-1164 POLE MOUNT ONE (1) TER-MT-485028/N 1 FT ANTENNA, S/N 13764 ONE (1) 94-80I05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ, S/N 075SC10330135. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE #00002-00469351, ONE (1) 94-80I15-S-U-T35 AN80I SYSTEM 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC10250275 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00469773, 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG (5) 94-80I01-S-H-T58 REDLINE AN80 PMP INTEGRATED, 5.8GHZ, S/NS 075SC10180264, 075SC10190161, 075SC10200207, 075SC10200274 075SC10200286. (4) 94-80I05-B-L-T54 REDLINE AN-80I PTMP BASE STATION 36MBPS, S/NS 075SC10280033, 075SC10330231, 075SC10330309, 075SC10330334. (2) 94-80I05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ, S/N 075SC10280005, 075SC10300117. (2) 94-80I09-B-L-T49 AN80I TERMINAL SYSTEM, 36 MBPS W/PMP, S/N 075SC10280066, 075SC10300229 INVOICE # 00002-00469543A, 94-80I -HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG EIGHT (8) 94-80I15-P-U-T35 AN80I SYSTEM 3.6-3.7 GHZ HIGH SPEED PTP, S/N 075SC10220078, 075SC102500286, 075SC10250085, 075SC10260003, 075SC10260012, 075SC10260093, 075SC10260205, 075SC10260207. INVOICE # 00002-00470912, 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG (2) 94-80I05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ, S/N 075SC10180733, 075SC10190224. 94-80IRR-SH-PH UPGRADE FROM SH (PMP) TO PH (PTP) (3) 94-80I05-B-L-T54 REDLINE AN-80I PTMP BASE STATION 36 MBBPS, S/N 075SC10180704, 075SC10180748, 075SC10240252. INVOICE # R-1626-L, ACCESS POINT NTG-335L2HR (RFU) AND NTJ-111R (IFU) S/N'S: PA07269, PA07270, PA07271, PA07272, PA07273WIRELESS TERMINAL NTG - 337X2URS/N'S: PD02539, PD02540, PD02541, PD02542, PD02543, PD02544, PD02545, PD02546. INVOICE # 00002-00471861 TER -JUMPER CABLE. TER -POLE -HOLDER. TER-1101-898 SURGE SUPPRESOR TER-1000-1164 POLE MOUNT. ONE (1) TER -MT-485028/N 1 FT ANTENNA, S/N 14622. ONE (1) 94-80I05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ, S/N 075SC10280158. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # R-1602-L, WIRELESS TERMINAL NTG-337X0URS/N'S: PD02402, PD02403, PD02404, PD02405, PD02406, PD02407, PD02408, PD02409, PD02410WIRELESS TERMINAL NTG-337X2URS/N'S: PD02456, PD02457, PD02458, PD02459, PD02460, PD02461, PD02462, PD02463, PD02464 INVOICE # 00002-00471163, 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. INVOICE # 00002-00469353, TER -JUMPER CABLE TER -POLE -HOLDER. TER-1101-898 SURGE SUPPRESOR TER-1000-1164 POLE MOUNT. ONE (1) TER-MT-405006/N 3.65 CPE FLAT PANEL ANTENNA, S/N 00206. ONE(1) 94-80I15-S-U-T35 AN80I SYSTEM 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC10250300. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG. INVOICE # 00002-00471678 88 -A-INK -HCC-AC-NA-R1 HORIZON COMPACT CONNECTORS AC 88-HC-100-HP-24-B1-00-C-R1 HORIZON COMPACT 100 HIGH POWER 24GHZ BAND 1. INVOICE # 00002-00470265, 94-A1815MTFD ANTENNA, 1 FOOT, 15 DEGREE, 18.5DBI FLAT 94-80I-LW-MNT LIGHT WEIGHT MOUNTING KIT, VERTICAL MAST. INVOICE # 00002-00472047,94-80I01-S-H-T58 REDLINE AN80 PMP INTEGRATED, 5.8GHZ. 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00469260, 94-80I05-P-L-T54 AN-80I 5.4GHZ 36 MBPS, S/N 075SC10330253. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG TER -JUMPER CABLE. TER -POLE -HOLDER. TER-1101-898 SURGE SUPPRESOR TER-1000-1164 POLE MOUNT. INVOICE # 00002-00469543 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG EIGHT (8) 94-80I15-P-U-T35 AN80I SYSTEM 3.65-3.7 GHZ HIGH SPEED PTP, S/N 075SC 1. 0220078, 075SC102500286, 075SC10250085, 075SC10260003, 075SC10260012, 075SC10260093, 075SC10260205, 075SC10260207. INVOICE # 00002-00469259 ONE (1) 94-80I05-P-L-T54 AN-80I 5.4GHZ 36 MBPS, S/N 075SC10330191 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG TER -JUMPER CABLE. TER -POLE -HOLDER. TER-1101-898 SURGE SUPPRESOR. TER-1000-1164 POLE MOUNT. INVOICE # 00002-00469904 94-A1815MTFD ANTENNA, 1 FOOT , 15 DEGREE, 18.5DBI FLAT INVOICE # 00002-00471259, 94-A1815MTFD ANTENNA, 1 FOOT , 15 DEGREE, 18.5DBI FLAT, 94-80I-LW-MNT LIGHT , WEIGHT MOUNTING KIT, VERTICAL MAST INVOICE # 00002-00469539, 88 -A -INK-HCC-AC-NA-R1 HORIZON COMPACT COPPER CONNECTORS AC. 88-HC-100-HP-24-B1-00-C-R1 HORIZON COMPACT 100 HIGH POWER 24GHZ BAND 1. INVOICE # 00002-00471497 88-A-INK-HCC-AC-NA-R1 HORIZON COMPACT COPPER CONNECTORS AC 88-HC-100-HP-24-B1-00-C-R1 HORIZON COMPACT 100 HIGH POWER 24GHZ BAND 1. INVOICE # 00002-00470149, FIVE (5) TER-MT-405006/N 3.65 CPE FLAT PANEL ANTENNA, S/N 180 - NMT0042975, 1. 81 - NMT0042976, 182 - NMT0042977, 183 - NMT0042978, ,184 - NMT0042979 INVOICE # 00002-00469261, 94-80I15-S-U-T35 AN80I SYSTEM 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC10260192 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE 00002-00471995, 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST ONE (1) 94-80I05-S-H-T54 AN 80I SUBSCRIBER UNIT 5.4GHZ, S/N 075SC10200402, 075SC10280165, 94-80IRR-SH-PH INVOICE # 00002-00468809, 88-HC-200-HP-24-B1-00-C-R1 24GHZ DEMS40 200 MBPS. 88-A-INK-HIC-AC-NA-R1. 88-A-OPT-HWR-RMIS-HC HORIZON COMPACT INDOOR RACK MOUNT FOR SURGE PROTECTOR. 88-A-OPT-HWR-DPRM-24 DUAL POLE RADIO MOUNT. INVOICE # 00002-00471860 94-80IRR-PL-PH AN80I UPGRADE FROM 36MB TO 54MB INVOICE # 00002-00469192, TER -JUMPER CABLE. TER -POLE -HOLDER TER-1101-898 SURGE SUPPRESOR. TER-1000-1164 POLE MOUNT ONE (1) TER-MT-485028/N 1 FT ANTENNA, S/N 13763 ONE (1) 94-80I05-P-H-T54 5.4GHZ PTP AN80I, S/N 075SC10330308 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00469470, TER -JUMPER CABLE. TER -POLE -HOLDER TER-1101-898 SURGE SUPPRESOR. TER-1000-1164 POLE MOUNT ONE (1) TER-MT-404014/NV 3.65 SECTOR ANTENNA- VERTICAL, S/N 03644 ONE (1) 94-80I15-B-U-T35 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC10260133. 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00471407, (20) 94-80I15-S-U-T35 AN80I SYSTEM 3.6-3.7 GHZ HIGH SPEED PMP S/N 075SC10260028, 075SC10280144, 075SC10290044, 075SC10290097, 075SC10290109, 075SC10290159, 075SC10290162, 075SC10290168, 075SC10290198, 075SC10290217, 075SC10300009, 075SC10300101, 075SC10300126, 075SC10300127, 075SC10300137, 075SC10300145, 075SC10300146, 075SC10300153, 075SC10300156, 075SC10300170. (3) 94-80I15-B-U-T35 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC102800133, 075SC10300110, 075SC10300152 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00469136, 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG EIGHT (8) 94-80I15-P-U-T35 AN80I SYSTEM 3.65-3.7 GHZ HIGH SPEED PTP, S/N 075SC10250121, 075SC10260117, 075SC10260156, 075SC10260160, 075SC10260167, 075SC10260171, 075SC10260196, 075SC10260210. INVOICE # 00002-00469921 94-80I-LW-MNT LIGHT WEIGHT MOUNTING KIT, VERTICAL MAST INVOICE # 00002-00469193, TER -JUMPER CABLE. TER -POLE -HOLDER TER-1101-898 SURGE SUPPRESOR. TER-1000-1164 POLE MOUNT ONE (1) TER-MT-485028/N 1 FT ANTENNA, S/N 13616 ONE (1) 94-80I05-P-H-T54 5.4GHZ PTP AN80I 5.4GHZ, S/N 075SC10330362. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00472153, 94-80I05-S-H-T54 AN 80I SUBCRIBER UNIT 5.4 GHZ, S/N 075SC10140346. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00469195, 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG TWO (2) 94-80I05-P-H-T54 5.4GHZ PTP AN80I, S/N 075SC10330355, 075SC10330453. INVOICE # 00002-00469297 94-80I05-P-H-T54 5.4GHZ PTP AN80I, S/N 075SC10330139 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00471777, 88 -A-INK -HCC-AC-NA-R1 HORIZON COMPACT CONNECTORS AC. 88-A-ANT-38G-24C DRAGON WAVE 38G2 FT ANTENNA INVOICE # 00002-00470913, 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG (2) 94-80I05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ, S/N 075SC10180734, 075SC10190206. 94-80IRR-SH-PH UPGRADE FROM SH (PMP) TO PH (PTP) INVOICE # 00002-00469352, ONE(1) 94-80I15-B-U-T35 AN80I SYSTEM 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC10240287. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG. TER -JUMPER CABLE. TER -POLE -HOLDER TER-1101-898 SURGE SUPPRESOR. TER-1000-1164 POLE MOUNT ONE (1) TER-MT-404014/NV 3.65 SECTOR ANTENNA- VERTICAL, S/N 03646 INVOICE # 00002-00472128, 88-A-ANT-38G-24-C DRAGON WAVE 38G2 FT ANTENNA. INVOICE # 00002-00471254 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG (1) 94-80I09-B-L-T49 AN80I TERMINAL SYSTEM, 36MBPS W/PMP S/N 075SC10300083. (4) 94-80I09-B-L-T49 AN80I TERMINAL SYSTEM,W/PMP , S/N 075SC10290131, 075SC10290193, 075SC10300221, 075SC10300276. (3) 94-80I05-B-L-T54 REDLINE AN-80I PTMP BASE STATION 36MBPS, S/N 075SC10280060, 075SC10280114, 075SC10290018 (6) 94-80I5-S-L-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ, S/N 075SC10240033, 075SC10260010, 075SC10260177, 075SC10280145, 075SC10280177, 075SC10280204. (4) 94-80I01-S-H-T58 REDLINE AN80 PMP INTEGRATED 5.8GHZ S/N 075SC10200520, 075SC10220351, 075SC10220483, 075SC10220495 INVOICE # 00002-00471155, 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. INVOICE # 00002-00471643 EIGHT (8) TER-MT-484026/VHN MTI 60 DEG SECTOR ANTENNA, S/N 00608NMT41615, 00637NMT0041633, 00638NMT0041634, 00640NMT0041634, 00643NMT0041632, 605NMT0041612, 607NMT0041614, 635NMT0041640. INVOICE # 00002-00471789 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG EIGHT (8) 94-80I15-S-U-T35 AN80I SYSTEM 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC10360141, 075SC10360189, 075SC10380178, 075SC10380180, 075SC10380195, 075SC10400057, 075SC10420035, 075SC10420037. 94-80IRR-SU-PU UPGRADE KEY FROM SU-PU INVOICE # 00002-00470364, 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET (35) 94-80I15-S-U-T35 AN80I SYSTEM 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC10190211, 075SC10260062, 075SC10330049, 075SC10330128, 075SC10330145, 075SC10330149, 075SC10330153, 075SC10330166, 075SC10330206, 075SC10330226, 075SC10330243, 075SC10330266, 075SC10330277, 075SC10330288, 075SC10330289, 075SC10330298, 075SC10330300, 075SC10330305, 075SC103303089, 075SC10330324, 075SC10330366, 075SC10330367, 075SC10330373, 075SC10330381, 075SC10330390, 075SC10330406, 075SC10330413, 075SC10330415, 075SC10330432, 075SC10330436, 075SC10330476, 075SC10330506, 075SC10330521, 075SC10330523, 075SC10330527 (8) 94-80I15-B-U-T35 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC10250252, 075SC10250288, 075SC10330200, 075SC10330254, 075SC10330301, 075SC10330325, 075SC10330346, 075SC10330360 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG INVOICE # 00002-00472025, 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST. 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG SEVEN (7) 94-80I15-S-U-T35 AN80I SYSTEM 3.6-3.7 GHZ HIGH SPEED PMP, S/N 075SC10250048, 075SC10360025, 075SC10360056, 075SC10360188, 075SC10380154, 075SC10400054, 075SC10420069 INVOICE # 00002-00469258, ONE (1) 94-80I01-S-H-T58 REDLINE AN80 PMP INTEGRATED, 5.8GHZ, S/N 075SC10190295. 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST.94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET. 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG TER -JUMPER CABLE. TER -POLE -HOLDER. TER-1101-898 SURGE SUPPRESOR. TER-1000-1164 POLE MOUNT. TER-MT-485028/N 1 FT ANTENNA, S/N 13762. INVOICE # 00002-00469354, TER -JUMPER CABLE. TER -POLE -HOLDER. TER-1101-898 SURGE SUPPRESOR. TER-1000-1164 POLE MOUNT. ONE (1) TER-MT-485028/N 1 FT ANTENNA, S/N 13759 ONE (1) 94-80I05-S-H-T54 AN-80I SUBSCRIBER UNIT 5.4GHZ, S/N 075SC10330229. 94-80I-HD-MNT HEAVY DUTY MOUNTING KIT, VERTICAL MAST 94-80I-POE-1A POWER INJECTOR SINGLE 10/100 ETHERNET 94-PPT-B REDLINE SINGLE AC POWER CORD: TYPE B PLUG . EQUIPMENT LOAN AND SECURITY AGREEMENT NO. 9712217001 ONE (1) CORDEX 650W 4MOD RECTIFIER SYS 10.5KVA, S/N JB36590-10-001; TWO (2) NOVUS FXM 650VA/W W/ SNMP CARD, S/N F52870 AND F52879; ONE (1) CORDEX CXRC 48-500/650WATT MOD, S/N N422531; ONE (1) CORDEX 650W 4MOD RECTIFIER SYS, S/N N422530; ONE (1) CORDEX 650W 4MOD RECTIFIER SYS 48V, S/N JB39491-10-001; TWO (2) 4' M/W 11GHZ ANT DP-HP, S/N 12US462296119 AND 12US462470704; FOUR (4) IP10-E(R3) W/ MAX CAP ACM, S/N F482604590, F482N04599, F482004551 AND F482Q04524; TWO (2) RFU-CX1M 38GHZ BH TH, S/N F472D02147 AND F472U02149; TWO (2) RFU-CX1M 38GHZ BH TL, S/N F482203877 AND F482K03878; ONE (1) XPX1461 XP2000 INVERTER, S/N 100903; FOUR (4) XPK1461 48V- DC/120V-AC INVKIT, S/N 113820, 113798, 113811 AND 113813; ELEVEN (11) XPX1461 XP2000 INVERTER, S/N 100905, 100900, 101753, 101751, 101756, 101752, 100897, 101758, 101749, 101830 AND 101755; ONE (1) TX130M+ HANDHELD DS1 TEST SET, S/N VTLA02M0110866; TWO (2) BR700G - APC UPS RS LCD 700VA, S/N S3B1239X13789 AND 3B1239X23800; TEN(10) ME-3600X-24FS-M W/ IOS & IP LI, S/N F0C1651V137, F0C1712X3U7, F0C1712X3TT, F0C1711Z0GV, F0C1712X3UC, F0C1712X3T9, F0C1712X3UD, F0C1712X3U0, F0C17123UX AND F0C1712X3US; ONE (1) ME-3600X-24FS-M W/ IOS & IP LI; TWENTY FIVE(25) 3.65 SECTOR ANT - HORIZONTAL MT404014NH, S/N 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 557, 383, 437, 436, 438,435,505, 504, 423, 424, 425, 426 AND 427; TWENTY (20) MTI 60 DEG SECT ANT MT484026NVH, S/N 1059, 1060, 1061, 1053, 1054, 1055, 1056, 1058, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1049,1048, 1626, 1633 AND 1634; SIX (6) MT-486001 2 FT ANTENNA, S/N 9010, 9274, 9253, 9264,9355 AND 9323; SEVEN (7) MTI 60 DEG SECT ANT MT484026NVH, S/N 1625, 1627,1628, 1629, 1630, 1631 AND 1632; EIGHT (8) NSB 110FT BATTERY, S/N SA1122770604, SA1122550557, SA1122760597, SA1122770987, SA1122770641, SA1122770644, SA1122770574 AND SA1122770623; FOUR (4) NSB170FT BATTERIES, S/N TA1130081257, TA1130082398, TA1130081333 AND TA1130081343; SEVEN (7) NSB110FT BATTERY, S/N SA1111220655, SA1111220626, SA1111220553, SA1111220579, SA1111220661, SA1111220666 AND SA1111220665; TWENTY (20) NSB170FT BATTERIES, S/N TA1130390156, TA1130390138, TA1130390165, TA1130370700, TA1130390150, TA1130370781, TA1130390184, TA1130390180, TA1130390149, TA1130390189, TA1130390169, TA1130390173, TA1130390106, TA1130390118, TA1130390121, TA1130390122, TA1130390164, TA1130390171, TA1130390175 AND TA1130370339; TWELVE (12) NSB100FT BATTERY, S/N NA1111531111, NA1111531042, NA1111531114, NA1111531106, NA1111531098, NA1111531266, NA1111531035, NA1111531263, NA11111571626, NA11111571640, NA11111580263 AND NA11111580272; EIGHT (8) NSB170FT BATTERIES S/N TA2130250110, TA2130250163, TA2130250112, TA2130250107, TA1130390152, TA1130381809, TA1130381803 AND TA1130381808; TWO (2) WS-C3750G-24TS-S1U, S/N F0C1028Z1NM AND F0C1019Y11R; TWO (2) CISCO 3750-24-TS-S, S/NCAT0752R0N2 AND CAT1023N465; THIRTEEN (13) GLC-LH-SM - GE SFP LCCONNECTS, S/N VAR49464, VAR49465, VAR49466, VAR49467, VAR49468, VAR49469, VAR49470, VAR49471, VAR49472, VAR49473, VAR49474, VAR49475 AND VAR49476; FIVE (5) GLC-SX-MM - GE SFP, LC SW, S/N VAR49497, VAR49498, VAR49499, VAR49500 AND VAR49501; TEN (10) GLC-T - 1000BASE-T SFP , S/N VAR49502, VAR49503, VAR49504, VAR49505, VAR49506, VAR49507, VAR49508, VAR49509, VAR49510 AND VAR42397; TEN (10) GLC-BX-U 1000BASE-BX SFP 1310, S/N VAR49487, VAR49488, VAR49489, VAR49490, VAR49491, VAR49492, VAR49493, VAR49494, VAR49495 AND VAR49496; TEN (10) GLC-BX-D 1000BASE-BX SFP 1490, S/N VAR49477, VAR49478, VAR49479, VAR49480, VAR49481, VAR49482, VAR49483, VAR49484, VAR49485 AND VAR49486; ONE (1) WS-C3750G-24TS-S1U, S/N F0C1239W19V; SEVEN (7) GLC-SX-MM - GE SFP, LC SW, S/N AGM11411399, AGM114113A9, FNS114504BW, AGM1113J49M, AGM11291HY9, AGM11291HYA AND FNS0833R6L0; TWO (2) CISCO 3500-24 SMI W/ AC POWER, S/N CAT0808N3AD AND CHK0704W1TF; TWO (2) WS-C3750G-24TS-S1U, S/N F0C1023Y065 AND F0C1023Z0A5; ONE (1) CISCO 3750-24-TS-S, S/N CAT0852Y2GX; ONE (1) WS-C3750G-24TS-S1U, S/N F0C0914U0BB; FOUR (4) GLC-LH-SM - GE SFP LCCONNECTS, S/N VAR46184, VAR46185, VAR46186 AND VAR46187; FOUR (4) GLC-SX-MM - GE SFP, LC SW, S/N VAR46188, VAR46189, VAR46190 AND VAR46191; FOUR (4) GLC-T - 1000BASE-T SFP, S/N VAR46192, VAR46193, VAR46194 AND VAR46195; THREE (3) CISCO 3500-24 SMI W/ AC POWER, S/N CAT0732X05E, CAT0651Y03X AND CAT0924X16E; ONE (1) AN80I 5.8-36M PMP SUBSCRIBER, S/N 075SC12240149; TWO (2) AN80I 5.4-36M PTP, S/N 075SC12350392 AND 075SC12350338; ONE (1) AN80I 5.8-36M PMP SUBSCRIBER, S/N 075SC12240217; THREE (3) AN80I 5.4-36M PMP SECTOR CTRL, S/N 075SC12190303, 075SC12190158 AND 075SC12150149; ONE (1) AN80I 5.4-36MBPS PTP, S/N 075SC12190149; ONE (1) AN80I 5.4-36M PMP SECTOR CTRL, S/N 075SC12150148; ONE (1) AN80I 5.4-36M PTP, S/N 075SC12350113; ONE (1) AN80I 5.4-36M PMP SUBSCRIBER, S/N 075SC12350002; ONE (1) AN80I 3.65-36M PMP SECTOR CTRL, S/N 075SC12130386; THREE (3) AN80I 5.4-36M PMP SECTOR CTRL, S/N 075SC12190784, 075SC12320078 AND 075SC12350013; ONE (1) AN80I 5.8-36M PMP SECTOR CTRL, S/N 075SC12160278; ONE (1) AN80I 4.9-36M PMP SECTOR CTRL, S/N 075SC12240150; ONE (1) AR60U LOW BAND 60GHZ, S/N BGWVRB12306013; ONE (1) AN80I 5.4-36M PMP SECTOR CTRL, S/N 075SC12350127; ONE (1) FE60U LOW BAND 100MBPS, S/N BGWVRB12406015; ONE (1) AN80I 5.4-36M PMP SUBSCRIBER, S/N 075SC12350314; TWO (2) AN80I 5.4-36M PTP, S/N 075SC12350147 AND 075SC12350138; ONE (1) AN80I 5.4-36M PMP SECTOR CTRL, S/N 075SC12350137; ONE (1) AN80I 5.4-36M PTP, S/N 075SC12350061; ONE (1) AN80I 5.4-36M PMP SECTOR CTRL, S/N 075SC12190793; TWO (2) AN80I 5.4-36M PTP , S/N 075SC12510234 AND 075SC12510159; ONE (1) AN80I 5.4-36M PMP SECTOR CTRL, S/N 075SC12510029. ESA #9712217001. THE GOODS DESCRIBED HEREIN, WHEREVER SITUATED, AND ALL PRESENT AND AFTER-ACQUIRED INTELLECTUAL PROPERTY, INTANGIBLES, ATTACHMENTS, ACCESSORIES AND ACCESSIONS THERETO AND SPARE PARTS, REPLACEMENTS, SUBSTITUTIONS, EXCHANGES AND TRADE-INS THEREFOR, AND ALL RIGHTS, RECEIVABLES AND CHATTEL PAPER DERIVED FROM OR EVIDENCING THE LEASE OR RENTAL THEREOF BY THE DEBTOR TO THIRD PARTIES, AND ALL PROCEEDS RELATING THERETO. PROCEEDS: ALL OF THE DEBTOR'S PRESENT AND AFTER- ACQUIRED PERSONAL PROPERTY WHICH IS DERIVED DIRECTLY OR INDIRECTLY FROM ANY DEALING WITH OR DISPOSITION OF THE ABOVE-DESCRIBED COLLATERAL , INCLUDING, WITHOUT LIMITING THE GENERALITY OF THE FOREGOING, ALL INSURANCE AND OTHER PAYMENTS PAYABLE AS INDEMNITY OR COMPENSATION FOR LOSS OR DAMAGE THERETO AND ALL CHATTEL PAPER, DOCUMENTS OF TITLE, GOODS, INSTRUMENTS, INTANGIBLES, MONEY AND SECURITIES. . . .

mstanton1 commented 2 years ago

@doug-lovett we are finding some issues introduced with the modified GC and still considering how to push this forward. Can you please provide an updated count of the number of registrations with this duplication and provide the expiry date and registration number for those on that list?

cc @PatrickAHeath @RFK250

doug-lovett commented 2 years ago

@mstanton1 the count is 178, base reg numbers with expiry dates attached here. Rename to .xlsx https://app.zenhub.com/files/157936592/7b300cd4-8fef-450b-babf-72fb1d1f01b9/download

mstanton1 commented 1 year ago

Approach:

1) Have @doug-lovett re-run list to identify how many active cases we currently need to address. 2) Melissa to follow up with Ali to see if he can provide the file in any other format - as currently we'd need to string together each piece in a text file. 3) Provide updated text document for Doug to load into Postgres on an item by item basis.

mstanton1 commented 1 year ago

@doug-lovett can you generate an updated list for this duplicate general collateral issue?

doug-lovett commented 1 year ago

@mstanton1 the count is now 171. The registrations numbers and text are attached. Rename file to .xlsx.

https://app.zenhub.com/files/157936592/bcbdb0bb-c5dc-4503-bd15-8d61ade5d214/download

catherinecarlson commented 1 year ago

@doug-lovett I'm working on updating the general collateral text for PPR reg #011313G. I don't see it in the data extract that you provided. Should it have been included?

What are the GC Count and Count columns?

doug-lovett commented 1 year ago

@catherinecarlson the data I provided was based on a table of records created by Bob from his analysis of anomalies. So 011313G probably should have been included if it contains duplicate text. For a given GC description, he split the text up into separate records. The difference in the counts indicates that duplicate text exists. One count is the number of records, the other is the number of distinct records.

mstanton1 commented 1 year ago

@lbergero819 as time allows we can work through these. The priority is any general collateral issue raised by a client though.

Process

Example Ops 2560

catherinecarlson commented 10 months ago

@doug-lovett Can you generate an updated list for this duplicate general collateral issue? Thanks

doug-lovett commented 10 months ago

Query to run in PROD readonly: select r.registration_number, count(gc.description), count(distinct gc.description), (select gc2.description from general_collateral gc2, registrations r2 where r2.registration_number = r.registration_number and r2.id = gc2.registration_id) as gc_text from general_collateral_legacy_copy gc, registrations r, financing_statements fs where r.id = gc.registration_id and r.financing_id = fs.id and r.registration_type_cl IN ('PPSALIEN', 'CROWNLIEN', 'MISCLIEN') and fs.state_type = 'ACT' and (fs.expire_date IS NULL or fs.expire_date > ((now() at time zone 'utc') - interval '30 days')) group by r.registration_number having count(gc.description) > count(distinct gc.description) ;

doug-lovett commented 10 months ago

@catherinecarlson down to 147, the latest query results are here: https://docs.google.com/spreadsheets/d/1P2-Khj_ZbPRt60FMsMXCAZ_5fPw6h1C9anZ6HfYfkM0/edit#gid=1403884870

jdyck-fw commented 5 months ago

Hopefully not too inconvenient, I'm removing the 1.5 priority label to tidy up our environment. I believe this is a left-over from Assets team deciding on MVP items for a release, and ideally items should be priority 1 or 2 instead.

mstanton1 commented 5 months ago

No concern here:) These are being tackled as they come up so likely a priority 2 but we haven't been using priority labels with MHR.