New Search
<br />FUND_CODE344 <br />Sum of ACTUAL_AMOUNT <br />PROJECT_IDPROJECT_DESCACCOUNTDEPTIDCLASS_FLDTotal <br />945422PBM 2014 Bicycle Ped Imp 9332 <br />6173500039.90 <br />9332 <br />617360000.00 <br />9332 <br />6173900092.16 <br />9332 <br />61891000969.80 <br />9332 <br />61899000541.90 <br />9332 <br />618370000.00 <br />945422 Total1,643.76 <br />955212PBM Acorn Park St Ped Improv 9332 <br />6173500010,280.25 <br />9332 <br />617360002,180.24 <br />9332 <br />618990002,230.80 <br />9332 <br />618640000.00 <br />955212 Total14,691.29 <br />955834S Willamette St Improvement 9332 <br />6173900011,000.00 <br />9332 <br />618910001,571.64 <br />9332 <br />61862000103.13 <br />955834 Total12,674.77 <br />955372PBM 2015 Bicycle & Ped Improve9332 <br />617390007,854.64 <br />9332 <br />6189000010,157.50 <br />9332 <br />6189100063,164.90 <br />9332 <br />61899000623.00 <br />955372 Total81,800.04 <br />Grand Total110,809.86 <br />Bike/Ped project expesnes fund 344 coded period 7 and later. <br />Used period 7, since audit for bond projects runs Jan - Dec, and period 6 and prior were in the last audit. <br />Use of code 925 for bike/ped projects for the 2012 bond, since these projects can be a subsection of a larger street repair. <br />SQL <br />SELECT GL_MASTER.FUND_CODE, GL_MASTER.PROJECT_ID, GL_PROJECT.PROJECT_DESC, GL_MASTER.ACCOUNT, GL_MASTER.DEPTID, GL_MASTER.ACTUAL_AMOUNT, GL_MASTER.CLASS_FLD <br />FROM QUERY_GL.dbo.GL_MASTER GL_MASTER, QUERY_GL.dbo.GL_PROJECT GL_PROJECT <br />WHERE GL_MASTER.PROJECT_ID = GL_PROJECT.PROJECT_ID AND ((GL_MASTER.FISCAL_YEAR='2015') AND (GL_MASTER.ACCT_PERIOD>=7) AND (GL_MASTER.FUND_CODE='344') <br />AND (GL_MASTER.PROJECT_ID In ('945422','955372','955212','955834'))) <br />