Server Name(s) Database Name Application
bpl‐oracle1;bpl‐oracle2 MAXPROD Maximo
bpl‐oracle1;bpl‐oracle2 LAWPROD Lawson
bpl‐oracle1;bpl‐oracle2 IMGNOW Image Now
bpl‐oracle1;bpl‐oracle2 LIVELNK Livelink
bpl‐oracle1;bpl‐oracle2 CMCR Contract Management
bpl‐oracle1;bpl‐oracle2 P6ORA P6
bpl‐oracle1;bpl‐oracle2 P6SB01 P6
bpl‐oracle1;bpl‐oracle2 GIS ArcGis
bpl‐oracle1;bpl‐oracle2 TEAMTRK Team Track Change Management
bpl‐oracle1;bpl‐oracle2 RMAN Recovery Manager
bpl‐oracle1;bpl‐oracle2 SLETM Secure Logix
bpl‐oracle1;bpl‐oracle2 BWTPMD Process Control Historian
bpl‐oracle1;bpl‐oracle2 IABPROD Impervious Billing
bpl‐oracle1;bpl‐oracle2 WAREHS9 Warehouse
bpl‐oracle1;bpl‐oracle2 SCALES Scales
bpl‐oracle1;bpl‐oracle2 FLEET FleetWave
sun‐rdc LAWPROD Lawson Standby
sun‐rdc GIS ArcGIS
cmf‐oradev PCT Procurement Contract Tool
cmf‐oradev PIMS Vertex / Oracle
bpl‐sqlreports2 VHR_DCW Ceridian bpl‐sqlreports2 cdlemailsent, DC Water Heads, emailsent, probation_union CDL Certification bpl‐sqlreports2 cdlemailsent, DC Water Heads, emailsent, probation_union ALL HCM Applications bpl‐sqlreports2 cdlemailsent, DC Water Heads, emailsent, probation_union Driver's License bpl‐sqlreports2 cdlemailsent, DC Water Heads, emailsent, probation_union eRecruiter Application tracking system
bpl‐sqlreports2 probation_union HCM probationary
bpl‐sqlreports2 SimpleK; SimpleK‐arch SimpleK
FST‐AMRDB; RDC‐AMRDB StarDatabase Star
FST‐AMRDB; RDC‐AMRDB CustomerBillingDB Billing Programs
RDC‐AMRHST StarHistorical Historical customer data
Bpl‐sqlreports2 SimpleK; SimpleK‐arch SimpleK
fst‐sql ivrstats ivr
fst‐sql NCCS_Web AMR Graph/HUNA
fst‐sql huna_test huna
bpl‐sqlcluster ivrstats ivr
bpl‐sqlcluster huna_test Website/HUNA
fst‐sql NCCS_Web* HUNA Dev/Test
bpl‐sqlreports2 KofaxCapture Kofax (Production)
bpl‐synapp sys_elogger eLogger
bpl‐sqlreports2 cAsset cSupport
bpl‐sqlreports2 cSupport cSupport
bpl‐sqlreports2 cSupport_Bomgar cSupport
bpl‐sqlreports2 cSupport_Workflow cSupport
bpl‐sqlreports2 cSupportReporting cSupport
bpl‐sqlreports2 cSurvey cSupport
bpl‐sqlreports2 WeekStats cSupport
bplsqlcluster license_agreement Software Management
bplsqlcluster license_manager Software Management
Monet aotask AO Task System
Monet avr AV Request System
Monet critlist Critical Equipment List
Monet cts Customer Tracking
Monet hr_fitness HR Fitness System
Monet lead_db
Lead Management System (leaddata/leadreports)
Monet port13 PORTS
Monet Correspondence Procurement Tracking
Monet scts Security Case Manager
Monet Correspondence Correspondence Tracking
Monet AMRGRAPH NCCS_Web
copland AMRGRAPH Internal NCCS_Web
bpl‐spsqlclus WSS_Content_HomePagePortal Intranet Home Page (MOSS 2007) bpl‐spsqlclus WSS_Content_Facilities Intranet Facilities Site(MOSS 2007) bpl‐spsqlclus WSS_Content_ab422be214ec4d5e81e6f18e53522125 Mysites (MOSS 2007)
bpl‐spsqlclus WSS_Content SharedServiceProvider(MOSS 2007) bpl‐spsqlclus
WSS_Content_55cac66abcd84b78956e76142bfc8891_
1 Intranet Sharepoint Site (MOSS 2007)
bpl‐spsqlclus SharePoint_AdminContent_e5d87842‐6b26‐4f59‐a281‐ SharePoint Central Administration V3 (MOSS
bpl‐spsqlclus WSS_Content_SSP2Mysite SSP2Mysite(MOSS 2007)
BPL‐SPSQLNODE PipelineBlue_Content_IT Pipelineblue2010 IT Site (SharePoint Server 2010) BPL‐SPSQLNODE Pipelineblue_Content_GIS Pipelineblue2010 Office of General Counsel Site (SharePoint Server 2010) BPL‐SPSQLNODE SharePoint_AdminContent SharePoint Server 2010 Central Administration Site OSTSPSQL SharePoint_AdminContent_2b66ec27‐eac5‐4439‐81f9‐ fa7bdc9a9eb3 SharePoint Server 2010 Central Administration Site (Current Development Environment) Cmfspsql WSS_Content_PipelineIntra Intranet Homepage: SharePoint 2010 Server (Future Production Environment) Cmfspsql WSS_Content_DETS Department of Engineerng Site :SharePoint 2010 Server (Future Production Environment) Cmfspsql WSS_Content_EA External Affairs Site: SharePoint 2010 Server (Production Environment) Cmfspsql WSS_Content_HCM Human Capital Management Site: SharePoint 2010 Server (Future Production Environment) Cmfspsql WSS_Content_IT Information Technology Site: SharePoint 2010 Server (Future Production Environment) Cmfspsql WSS_Content_OtherDeps SharePoint 2010 Server (Future Production Environment) Cmfspsql SharePoint_AdminContent_6606ebfe‐d5d9‐4503‐a51a‐ 91119ea47c11 SharePoint Server 2010 Central Administration Site (Production Environment) Cmfspsql WSS_Content_MySites MySite: SharePoint Server 2010 (Future Production Environment)
Description Age Public Access Asset Management Production Database, includes assets such as
Hydrants, Pipes, and the Work Orders associated with maintenance
and repair 7+ years None
Commercial Financial and Procurement Production Database,
includes vendor information, purchase orders, commercial contracts,
payments, etc. 7+ years None
Image Now Production Database for scanned invoices, etc. The
metadata for scanned images, is stored in database 4+ years None Document management Production Database, storing metadata for
externally stored documents 4+ years None
Contract Management Production Database. Includes projects, daily
reports, correspondence, images associated with projects, etc. 2 years None Project Management Production for CIP Projects. Project, vendor,
progress information is stored. 2 years None
Project Management Production for non‐CIP Projects. Project,
vendor, progress information is stored. 2 years None GIS Mapping Production Database. Coordinates of externally located
assets are stored. 4 years None
Change Management Production Database. IT change management
requst workflow information. 3 years None
Oracle Recovery Manager Production Database 7+ years None Telephony Call Management Production Database 7+ years None WasteWater Production Reporting Database 7+ years None
Impervious Billing Production Database 4 years None
Lawson Production Reporting Database 7+ years None
Truck Scales Management / reporting Production Database. Trucks,
deliveries, weights in and out, images of license plates, etc. 1 year None Fleet Management Production Database. Motor assets, driver
information. 1 year None
Redundant Database for Lawson Disaster Recovery 5 years None Redundant Database for Maximo Disaster Recovery 5 years None
Redundant Database for GIS Disaster Recovery 4 years None Contract reporting for Procurement. Pulls information from Lawson,
but only stores some contract information. 4 years None Vertex Reporting Tool. Payment and customer information pulled
from Vertex external database maintained by third party. 1 year None This database is used for HCM to do their SQL Reprting None This database is used for HCM to automatically notify employees that it is time to get their CDL Certificate renewed None this database is used to extract the employee's department head to send him a copy of the letter that the employee is receiving None this database tracks to see if the employee received their notice that their driver's license it going to expire Y72 or Y30 None Reporting database HCM uses monthly to run custom applicant reports. This is an auto feed from Ceridian None this database keeps track of employees who's has been working for DC Water for 9 months and sends a reminder to the Director 3 months before the employee's probationary time is up so the Director can deside if they would d None This DB is used by Facilities; currently the access is setup through SimpleK application and limited to the added users. For backend the access is based on DB Profiles None This DB is used for storing Automated Meter Readings. This data provides daily export to AMR Graph/HUNA database instances. Access to this db is through web interface (internal website) and through DB users and profiles None This DB is used for managing Daily Meter Downloads/Uploads from/to Vertex. Users have limited access based on their DB roles None This DB is used for providing daily extract to AMR GIS Dashboard. Users have limited access based on their DB Roles None
Stores Star historical data; access is via a Web Interface and DB user list based on managed roles None This DB is used by Facilities; currently the access is setup through SimpleK application and limited to the added users. For backend the access is based on DB Profiles None production ivrstats database ‐ stores IVR‐related stats & data like Call Volume, Employment Opportunity Listings, etc. None Used to calculate usage (which is then queried for high usage, and notifications sent out). Also used by AMR Graph The database itself is not public, there is a web AMR Graph interface that is public & displays the data in NCCS_Web to customers Backup ivrstats database (Production is on FST‐SQL) None production HUNA database keeps track of our customer high usuage water events, notifications, and preferences The database itself is not public, but data in the database is displayed to customers in the form of a HUNA email, phone call, or text message. HUNA preferences that are stored in this database are displayed to customers via a web interface (Through AMR Graph) production HUNA database keeps track of our customer high usuage water events, notifications, and preferences The database itself is not public, but data in the database is displayed to customers in the form of a HUNA email, phone call, or text message. HUNA preferences that are stored in this database are displayed to customers via a web interface (Through AMR Graph) "NCCS_Web" is production. Any database that starts with NCCS_Web (like NCCS_Web_Star5) is a temporarty Dev/Test database. The Dev/Test instance is used to dev/test a chance to AMR Graph or HUNA None Database for the Production Kofax system. Kofax is part of the Enterprise Document Management System, used to process and release documents to Livelink. None Electronic logbook software replaces paper log books and disconnected systems collecting, storing and distributing real‐time data about your 24 x 7 operations None
The system in place was deployed in 2009 and remains current with rolling application upgrades from the vendor None None IT‐Ticket Application None IT ‐ Ticket Application? None IT‐Ticket application workflow None Reporting module None Stores customer survey information None Report Manger None Keeps track of software purchaced / Software inventory None administartion setup database None Commercial system for mapping organizational goals to departmental tasks. None System for tracking room set‐up requests for A/V. None Tracks maintenance and impact of sewer/water system components None None Used during the 1010 walk company fitness program to track and compare teams. This is a seasonal database None System for tracking lead test kit results None IT Purchase Order Request Tracking System None Correspondence tracking system for Procurement's use None Tracks security incidents and responses None Correspondence tracking system for DC Water users None Allows our customers to view their water usage daily, weekly or yearly Yes Allows our Customer Service folks to view our customers water usage daily, weekly or yearly and assist them with any problems None Current Intranet Homepage in Production Environment None Current Facilities Departmental Site and Boardroom Calendar None Content from Mysites are used in Phonebook application of current intranet site None
Diffferent Services Used by MOSS 2007 None MOSS 2007 SharePoint sites with different departments contents (Current in Production) None MOSS 2007 Central Administration None MOSS 2007 Mysite None Pipelineblue2010 IT Site (old environmemnt‐not in production) None Office of the General Counsel Calendar Feature is in use None Centeal Adminstration Site (old production environment) None Managing Development Environment None Hosting Intranet HomePage None Hosting Engineering Site if Needed in Future None Hosting External Affairs Site if Needed in Future None Hosting HCM Site if Needed in Future None Hosting IT Site if Needed in Future None Hosting Other Departmental Site if Needed in Future None Managing All Intranet Web Applications None Hosting MySite if needed in future None
Populating Required Employee Information From Human Capital
Version Upgrades/Miscellous/Notes Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter
Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 11.2.0.3 None Oracle 11.2.0.3 None SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2000 N/A SQL2000 N/A SQL2000 N/A
SQL2000 N/A SQL2005 N/A SQL2000 N/A SQL2000 N/A SQL2000 N/A SQL2000 N/A SQL2000 N/A SQL2000 N/A SQL2005 N/A SQL2005 N/A
SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A SQL2005 ‐ 9.00.5069.00 (X64) N/A SQL2005 ‐ 9.00.5069.00 (X64) N/A SQL2005 ‐ 9.00.5069.00 (X64) N/A
SQL2005 ‐ 9.00.5069.00 (X64) N/A SQL2005 ‐ 9.00.5069.00 (X64) N/A SQL2005 ‐ 9.00.5069.00 (X64) N/A SQL2005 ‐ 9.00.5069.00 (X64) N/A SQL2008 R3 N/A SQL2008 R4 N/A SQL2008 R5 N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A