marcus-e
1/26/2018 - 5:57 PM

Meena - Contracts by Fund Type CAMM

Contracts by Fund Type report in CAMM DB. Modified to get Measure M only, and without CO-OPs.

ContractsByFundTypeCAMM.sql
content_copyfile_download
--Contracts by Fund Type using CAMM database. For Meena who wants non-coops only.
SELECT DISTINCT(c.CONTRACTNUM), c.CONTRACTCOMMENT, v.vendorname, c.CONTRACTAMT, c.EFFDATE,  C.EXPDATE, pauser.paname, c.FUNDTYPEDESC, c.FUNDINGSOURCE1, c.FUNDINGSOURCE2
FROM CONTRACT c, VENDOR v, PAUSER

WHERE c.vendornum = v.vendornum and 
c.panum = pauser.panum AND
(c.FUNDINGSOURCE1 = 'MEASURE M-0010' OR c.FUNDINGSOURCE2 = 'MEASURE M-0010' OR c.fundtypedesc = 'MEASURE M(0010)') AND
UPPER(c.CONTRACTCOMMENT) NOT LIKE '%COOP%' AND
UPPER(c.CONTRACTCOMMENT) NOT LIKE '%CO-OP%' AND
UPPER(v.VENDORNAME) NOT LIKE '%CITY OF%' AND
UPPER(v.VENDORNAME) NOT LIKE '%COUNTY OF%'

ORDER BY c.contractnum;