This table contains all of the table names that must be linked to ManagingEnergy if the application is to run correctly. The TableType column determines which database the tables are stored in. Here is a complete listing of the tables linked to ManagingEnergy in version 9.102.
Table Type |
Table Name |
ADMIN |
tblWeb_ReportTags |
OPPS |
Opportunity_EnergyEffManual |
OPPS |
Opportunity_List |
PROJECT - COMMON |
tblCommonItems |
PROJECT - COMMON |
tblDesignIlluminationLevels |
PROJECT - COMMON |
tblEmCoeff |
PROJECT - COMMON |
tblEmElecCoeff |
PROJECT - COMMON |
tblFacilityTypeInfo |
PROJECT - COMMON |
tblLtgBallasts |
PROJECT - COMMON |
tblLtgFixtures |
PROJECT - COMMON |
tblLtgLamps |
PROJECT - COMMON |
tblLtgRetrofitList |
PROJECT - COMMON |
tblManufacturer |
PROJECT - COMMON |
tblManufacturerType |
PROJECT - COMMON |
tblOppCategories |
PROJECT - COMMON |
tblOppCategoriesAssigned |
PROJECT - COMMON |
tblPlantCategory |
PROJECT - COMMON |
tblProvinces |
PROJECT - COMMON |
tblUtType |
PROJECT - COMMON |
tblUtUnit |
PROJECT - DATA |
tblAltIdentifiers |
PROJECT - DATA |
tblAltIdentifiersApplied |
PROJECT - DATA |
tblDepartmentMembers |
PROJECT - DATA |
tblDepartments |
PROJECT - DATA |
tblFacility |
PROJECT - DATA |
tblFacilityControls |
PROJECT - DATA |
tblFacilityDetails |
PROJECT - DATA |
tblFacilityEnergy |
PROJECT - DATA |
tblFacilityLtg |
PROJECT - DATA |
tblFacilityMedia |
PROJECT - DATA |
tblFacilityOppMediaLinks |
PROJECT - DATA |
tblFacilitySiteVisits |
PROJECT - DATA |
tblLtgRetrofits |
PROJECT - DATA |
tblLtgSurvey |
PROJECT - DATA |
tblLtgZones |
PROJECT - DATA |
tblOppImpact |
PROJECT - DATA |
tblOppor |
PROJECT - DATA |
tblPeople |
PROJECT - DATA |
tblProject |
PROJECT - DATA |
tblScenarios |
PROJECT - DATA |
tblScenariosApplied |
PROJECT - DATA |
tblStatus |
PROJECT - DATA |
tblStatusDescription |
PROJECT - DATA |
tblTECH_A |
PROJECT - DATA |
tblTECH_A1 |
PROJECT - DATA |
tblTECH_A2 |
PROJECT - DATA |
tblTECH_A3 |
PROJECT - DATA |
tblTECH_B |
PROJECT - DATA |
tblTECH_B1 |
PROJECT - DATA |
tblTECH_C |
PROJECT - DATA |
tblTECH_D |
PROJECT - DATA |
tblTECH_E |
PROJECT - DATA |
tblTECH_E1 |
PROJECT - DATA |
tblTECH_F |
PROJECT - DATA |
tblTECH_F1 |
PROJECT - DATA |
tblTECH_F2 |
PROJECT - DATA |
tblTECH_F3 |
PROJECT - DATA |
tblTECH_G |
PROJECT - DATA |
tblTECH_H |
PROJECT - DATA |
tblTECH_I |
PROJECT - DATA |
tblTECH_J |
PROJECT - DATA |
tblTECH_L |
PROJECT - DATA |
tblTECH_L1 |
PROJECT - DATA |
tblTECH_M |
PROJECT - DATA |
tblTECH_M1 |
PROJECT - DATA |
tblTECH_N |
PROJECT - DATA |
tblTECH_O |
PROJECT - DATA |
tblTECH_Outline |
PROJECT - DATA |
tblTECH_SUB_DOORS |
PROJECT - DATA |
tblTECH_SUB_EXTERIOR |
PROJECT - DATA |
tblTECH_SUB_FIXTURES |
PROJECT - DATA |
tblTECH_SUB_WINDOWS |
PROJECT - DATA |
tblTECH_SUB_ZONES |
PROJECT - DATA |
tblTECH_Z |
PROJECT - DATA |
tblUtAdjustmentDetails |
PROJECT - DATA |
tblUtAdjustments |
PROJECT - DATA |
tblUtImport_Profile |
PROJECT - DATA |
tblUtImport_ProfileDetails |
PROJECT - DATA |
tblUtMeterBaseModel |
PROJECT - DATA |
tblUtMeterBillAmounts |
PROJECT - DATA |
tblUtMeterBillAmounts_BackupData |
PROJECT - DATA |
tblUtMeterBills |
PROJECT - DATA |
tblUtMeterComponents |
PROJECT - DATA |
tblUtMeters |
PROJECT - DATA |
tblUtProviderComponentList |
PROJECT - DATA |
tblUtProviders |
PROJECT - DATA |
tblUtVariables |
PROJECT - DATA |
tblUtVariableValues |
PROJECT - DATA |
tblWeb_RoleAccess |
PROJECT - DATA |
tblWeb_Roles |
PROJECT - DATA |
tblWeb_UserFacilityAccess |
PROJECT - DATA |
tblWeb_Users |
PROJECT - VIEW |
qryAllPlants |
PROJECT - VIEW |
qryLtgRetrofitsTransfer |
PROJECT - VIEW |
qryLtgSurveyWCalcs |
PROJECT - VIEW |
qryUtMeterAttachmentDataByDay |
PROJECT - VIEW |
qryUtMeterBills |
PROJECT - VIEW |
qryUtMeterBillsAndComponentTypes |
PROJECT - VIEW |
qryUtMeterInformation |
WEATHER |
tblNCDCWeatherData |
WEATHER |
tblNCDCWeatherStations |
WEATHER |
tblWYEC2WeatherData |
WEATHER |
tblWYEC2WeatherStations |