Capital Improvement Planning (CIP)

The Capital Improvement Planning (CIP) module enables agencies to capture data related to their Capital Improvement Planning including Revenues and Expenditures. You can then convert a CIP into a Project using the Create Master Project toolkit in this module.

To open this module, select Work > Project Management > Capital Improvement Planning (CIP).

Open the Work > Project Management > CIP module.
Click Add . A new record appears.
Enter a CIP ID. *This is required and must be unique.
Enter a Name to further identify your CIP.
Select the Fiscal Year to which you want this CIP associated.
Select a Program Rec # and Master Project Rec # to which you want the CIP associated.
Enter a Project Start Date and Project End Date as desired.
Select a Fund Group, and Fund Detail if desired.
Enter a Project Cost.
Additional funding fields will auto-populate or calculate from associated fields and records:
1. Prior Years Funding
2. Current Funding
3. Funded
4. Unfunded
5. Total Expenditure
Select the plan's Staff Priority and Council Priority, as desired.
Complete additional fields as desired.
Click Save . The new record appears in the Project Management > CIP grid.

Open the Project Management > CIP module.
Click the to expand the CIP to which you want to add a CIP Revenue.
Click Add in the CIP Revenue grid. A new record opens.
The Program ID will auto-populate from the related CIP and its related Program.
Select a Fiscal Year.*
Enter a Revenue Amount.*
Enter an As of Date.*
*These fields are required and must form a unique combination.
Select Prior Year Budget
Enter other information as desired.
Select Save . The new record appears in the CIP Revenue grid.

Open the Project Management > CIP module.
Click the to expand the CIP to which you want to add a CIP Expenditure.
Click Add in the CIP Expenditure grid. A new record opens.
Select a Fiscal Year.*
Enter an Expenditure Amount.*
Enter a Posting Date.*
*These fields are required and must form a unique combination.
Enter other information as desired.
Click Save . The new record appears in the CIP Expenditure grid.

Open the Work > Project Management > CIP module.
Select one or more CIP records from which you want to created an associated Master Project record.
Click the Toolkit and select Create Master Project(s) | Selected Record(s). A pop-up appears asking you to confirm running the toolkit against the selected record(s).
Select OK. A pop-up confirms the toolkit ran successfully. The new Master Project record(s) appear in the Master Project module containing the following fields copied from the original CIP record:
- Name
- ID
- Description
- Long Description (Memo 2)
- Scope (Memo 3)

Open the Work > Project Management > Programs module.
Select one or more Program records for which you want to rollover a CIP Fiscal Year.
Click the Toolkit and select Rollover CIP Fiscal Year | Selected Record(s). A pop-up similar to the following appears containing a list of available CIP Fiscal Years to select from:
Select the Fiscal Year you wish to use for the newly created records.
Click Select. The toolkit makes copies of the Program record and its CIP, CIP Expenditure and CIP Revenue record(s) containing each record's original data and the new Fiscal Year you selected in the toolkit.
- The toolkit will NOT copy CIP records that have the Converted to Project or Inactive fields marked as TRUE.
- The toolkit will create CIP Revenue records based on the Calculate Prior Year Funding Work Option:
  - If TRUE, the toolkit will copy all CIP Revenues related to CIP record(s) linked to the Program from which the toolkit was run. Then, if the new CIP Revenue's Fiscal Year < the new CIP's Fiscal Year, the new CIP Revenue's Prior Year field is marked as TRUE.
  - If FALSE, the toolkit will only copy CIP Revenues whose original Fiscal Year >= the new CIP's Fiscal Year.