In addition to over 200 CAMIS canned reports, the Division of Capital Asset Management and Maintenance (DCAMM) has developed a set of generic reports on buildings, building systems, outstanding building deficiency projects and equipment by using Discoverer, a report writer by Oracle. Brief descriptions of these reports are listed below. You can access these reports within CAMIS by adding a "Quick Pick Button" to the navigator. Detailed Step-by-Step Directions pdf format of report_viewer_8i.pdf PDF are attached here.

Building Information Reports:

Each Building Information Report listed below contains two separate worksheets titled 'General' and 'Floor & Room'. The information on these sheets are explained here:

  • General worksheet includes Org ID, Site Code, Site Name, Building Code, Building Name, Address, Municipality, Owned, Building Status, Square Feet, Replacement Value, Overall Rating, Construction Year, Building Type, Building Usage, Number of Floor, Basement, Historic Building, Occupy Group, Percent

  • Floor & Room worksheet includes Org ID, Site Code, Site Name, Building Code, Building Name, Floor, Floor Description, Floor SF, Floor Status, Room, Room Description, Room SF, Room Status, Capacity, Seating, Occupy Group

    • FAMIS.BldgInfo_byBldg (prompt to enter 10-digit Building Code)
    • FAMIS.BldgInfo_byDrill (report by selected Executive Office, Site and/or Building)
    • FAMIS.BldgInfo_byOrg (prompt to enter 3-digit Organization ID)
    • FAMIS.BldgInfo_bySite (prompt to enter 5-digit Site Code)
    • FAMIS.BldgInfo_noPara (generate report with no Parameter needed)

Building System Reports:

  • includes Site Code, Site Name, Building Code, Building Name, Overall Rating, Building System, System Condition

    • FAMIS.BldgSys_byBldg (prompt to enter 10-digit Building Code)
    • FAMIS.BldgSys_byOrg (prompt to enter 3-digit Organization ID)
    • FAMIS.BldgSys_bySite (prompt to enter 5-digit Site Code)
    • FAMIS.BldgSys_noPara (generate report with no Parameter needed)

Outstanding Building Deficiency Project Reports identified by year 2000 CAMIS survey:

  • includes Org Id, Site Code, Site Name, Building Code, Building Name, Square Feet, Municipal Zone, Project Number, Project Description, Estimated Cost

    • FAMIS.Project_bySite (prompt to enter 5-digit Site Code)
    • FAMIS.Project_Corrected (generate report with no Parameter needed)

Each drill down Project Report listed below contains six worksheets titled 'Executive Office', 'User Agency', 'Site', 'Building', 'Project', 'Project & Phase'. The information on these sheets is explained here:

  • Executive Office worksheet includes Executive Office, # of Site, # of Building, # of Project, Estimated Cost
  • User Agency worksheet includes Executive Office, User Agency, # of Site, # of Building, # of Project, Estimated Cost
  • Site worksheet includes Executive Office, User Agency, Site, # of Building, # of Project, Estimated Cost
  • Building worksheet includes Executive Office, User Agency, Site, Building, # of Project, Estimated Cost
  • Project worksheet includes Executive Office, User Agency, Site, Building, Project, # of Phase, Estimated Cost
  • Project & Phase worksheet includes Executive Office, User Agency, Site, Building, Project, Phase, Estimated Cost

    • FAMIS.Project_DrillbyCode (report by selected Executive Office, User Agency, Site, Building, Project)
    • FAMIS.Project_DrillbyDesc (report by selected Executive Office, User Agency, Site, Building, Project)

Outstanding Building Deficiency Project Reports identified by year 2000 CAMIS survey with phase details:

  • includes Site Code, Site Name, Building Code, Building Name, Square Feet, Priority, Project Number, Project Number, Project Description, Phase Number, Phase Description, Estimated Cost

    • FAMIS.BldgProj_byOrg (prompt to enter 3-digit Organization ID)
    • FAMIS.BldgProj_byOwn (prompt to enter 3-digit Agency Code)
    • FAMIS.BldgProj_bySite (prompt to enter 5-digit Site Code)

Equipment Reports:

  • includes Keyword, Site Code, Site Name, Building Code, Building Name, Equipment Code, Nomenclature, Equipment Condition, Replacement Cost, Expected Useful Life

    • FAMIS.Equip_byBldg (prompt to enter 10-digit Building Code)
    • FAMIS.Equip_byDrill (report by selected Keyword, Site and/or Building)
    • FAMIS.Equip_byOrg (prompt to enter 3-digit Organization ID)
    • FAMIS.Equip_bySite (prompt to enter 5-digit Site Code)
    • FAMIS.Equip_noPara (generate report with no Parameter needed)

CAMIS Self Service Reports:

  • Department List includes Org Id, Department, Description
  • Requester List includes Org Id, Requestor

    • FAMIS.FSS_Department List
    • FAMIS.FSS_Requestor List

More reports will be developed and posted here. Please check periodically. If you would like to see some specific reports for your maintenance management needs, please send requests to the CAMIS HelpDesk at CamisHelpdesk.DCAM@State.MA.US.

Tips to Export Report Data to Excel Format from Oracle Discoverer Report Viewer:

  • Direct Export Data to Excel Format from the Oracle Discoverer 4i Viewer; users need to have Microsoft Excel 2000 or later version.
  • Alternative method has to be used if users have Excel 97 or prior version. Users have to export the report data to Text Format (xxxx.txt) first, then import into the Excel application.