Get documents about "Ingrian Systems - Excel
Description
Ingrian Systems document sample
Document Sample
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
1 EOT CEPO CEPO Ad Track Access, SQL Server 2000 Tracks projects from the Advertised phase through the life of the project,
recording all modifications. It is also tracks documents that are
submitted to CEPO (like a log). Reports generated from the database
include Advertised, Awarded, Extra Work Orde
2 EOT CEPO CEPO Warehouse Queries Access, SQL Server 2000 Provides a list of a dozen reports for CEPO.
3 EOT CEPO State Aid Ledger Access, SQL Server 2000 Used in tracking of specific local city/towns construction contracts
funded by MHD or FHWA.
4 EOT Civil Rights CHAMP VB Tracks civil rights compliance.
5 EOT Commissioner's Office Elected Officials Correspondence and Meetings Access, SQL Server 2000 System to track incoming and outgoing correspondence of various
formats as well as meeting attendees. Specifically geared toward
correspondence from and to elected officials - municipal level as well as
state level.
6 EOT EEOEA Commonwealth Capital Application ASP, SQL Server 2000 Commonwealth Capital Application provides EoEEA administrators the
ability to dynamically create questions, guidance and criteria points for
the Commonwealth Capital program. Scorecards are then dynamically
generated for municipalities to complete. Resp
7 EOT Financial Cashier Access, SQL Server 2000 Tracks bid, plans, standard construction manual, and other document
purchases related to Contracts.
8 EOT Fiscal Local Warehouse Status Page ASP.Net, SQL Server 2005 This screen provides a status of all the tables loaded from the
Commonwealth Information Warehouse (CIW) into the Local
Warehouse (MHDWH).
9 EOT Fiscal Reporting Center Federal Reimbursement Loader Access This application is used by Fiscal to load Federal Reimbursement data.
10 EOT HR Bi-Weekly Timesheet Excel EOT Bi-Weekly Employee Timesheet entry system.
11 EOT HR OT Payroll Reports ASP.Net, SQL Server 2000 Overtime Payroll Reports. Invoked from OTPayroll Web on the Intraway
12 EOT HR OTPayroll Web ASP.Net, SQL Server 2000 The first module in the OT Payroll system.
13 EOT HR Reporting Center for HR Data SharePoint, SQL Server 2000, HR Cubes and Reports in support of HR and Civil Rights workforce
Analysis Server analyses.
14 EOT IT All Things SharePoint SharePoint This site is for users and developers who will find general SharePoint
information and specific information on SharePoint within the
Department.
15 EOT IT Application Development Delivery Access, SQL Server 2000 Used in displaying applications in the "My Applications" screen.
Developers enter the basic data. This includes the menu name, the
location of the front end, the contact. The network group associated
with the application is what governs who sees the li
16 EOT IT Application Tracker Access 2003, SQL Server 2005, Used by EOT IT to track applications at a high level. Includes a model
Reporting Services of the databases used by a system, servers housing the database, and
modules such as reports produced by a system.
17 EOT IT Award A Bid Access, SQL Application to create Bid Award letters and emails. Uses AE Data (read-
only)
18 EOT IT CIW Replatforming Project SharePoint Information on the Netezza Replatforming project.
19 EOT IT Communications SharePoint Site SharePoint Telephony Data Repository
20 EOT IT EOT Helpdesk Portal - SharePoint SharePoint Area to store Helpdesk documentation, openly discuss current issues,
and push out issue information to users.
21 EOT IT EOT IT Developer Portal SharePoint Provides a place for procedures, document sharing, major IT initiatives,
reports, etc.
Page 1 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
22 EOT IT Information Security Center - SharePoint SharePoint An Information Security Center site dedicated to providing our user
community with current information on terminology, best practices,
vulnerabilities and trends in the Information Security Industry.
23 EOT IT MHD Database Aministration (DBA) Site SharePoint, SQL Server 2000 This SharePoint provides technical information to developers about
MHD databases.
24 EOT IT Project Tracker (ProjTrak) ASP.Net, SQL Server 2005 ProjTrak is used for tracking Development projects and related issues
across EOT efforts. Used as a project management tool for IT Services
and business stakeholders (iPoP Committee, etc.)
25 EOT IT Reporting Center Support ASP, SQL Server 2000 A simple generic screen used in maintaining yearly goals used in
reports such as Advertising vs. YTD Goal. Goals are usually set
annually.
26 EOT IT Trackit Request Tracking System VB, SQL Server 2000 Used by EOT IT to track incoming Help Desk requests and issues. Also
can be used to track inventory.
27 EOT Labor Relations Civil Rights Resume Bank Access, SQL Server 2000 System for entering and referring resumes for EOT and MHD.
28 EOT Legal EOT Law SharePoint Site SharePoint EOT Law Office Collaboration Portal
29 EOT Legal Legal Case Tracking Access, SQL Server 2000 This MS Access application is used by Legal to track their cases.
30 EOT MHD / CEPO Chapter 90 Apportionment ASP, SQL Server 2000 Displays apportionment data for 351 cities and towns as well as the
necessary contract files.
31 EOT QA EOT QA Team Portal - SharePoint SharePoint The purpose of this site is to allow better information flow when QA
works on MHD/EOT projects.
32 EOT RMV ALARS Office Maint Service ASP.NET (VB) Oracle 11g Shared service for maintaining ALARS office records
33 EOT RMV ALARS Gateways C/C++ Used by legacy applications for to access ALARS data and transactions
34 EOT RMV ALARS User (aka MIS Security) Access 2.0 Oracle 10.2 Tracks ALARS Clerk Ids
35 EOT RMV Application Home ASP.NET (VB) Oracle 11g URL redirector for ITD to RMV applications
36 EOT RMV Application Portal ASP.NET (VB) Oracle 11g Provides single location for accessing intranet applications
37 EOT RMV AppSec Service ASP.NET (VB) Oracle 11g Provide single point for authentication and authorization for all intranet
and internet applications
38 EOT RMV AppSec Admin ASP.NET (VB) Oracle 11g Management tool for configuring users and applications for the AppSec
service
39 EOT RMV ATS Examiners Console ASP.NET (VB) Oracle 9i on AIX Automated Testing System application for administering exams
P590 at ITD
40 EOT RMV ATS Testing Station ASP.NET (VB) Oracle 9i on AIX Automated Testing System application for taking exams
P590 at ITD
41 EOT RMV ATS Question Maintenance ASP.NET (VB) Oracle 9i on AIX Automated Testing System application for question editing
P590 at ITD
42 EOT RMV ATS Web Services ASP.NET (VB) Oracle 9i on AIX Web services used to schedule exams and post exam results
P590 at ITD
43 EOT RMV ATST VB 5.0 Access 2.0 Tracks parts used on cars with salvage titles
44 EOT RMV ATST Random ASP.NET (VB) Crystal Reports Random list generator for inspecting salvaged vehicles
Oracle 11g
45 EOT RMV BrefQuery VB 3.0 Crystal Reports Access Query tool for BREFs
2.0
46 EOT RMV CAB Excise Calculator Realia COBOL Third party software to calculate excise for a vehicle
47 EOT RMV CAB Reports Access 97 FoxPro Reporting tool for CAB Title application
48 EOT RMV CAB Title Foxpro 2.6 FoxPro Case management tool
Page 2 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
49 EOT RMV Case Investigation System VB 5.0 Crystal Reports Access Tracks investigations done by the Special Investigations group
2.0
50 EOT RMV CJIS OUI/LSI System ASP.NET (VB) Crystal Reports Reporting tool for CJIS OUI and LSI data loaded by the CJIS sweeper.
Access 97
51 EOT RMV CJIS sweeper VB 5.0 Access 97 Receives OUI and LSI files from CJIS and updates ALARS
52 EOT RMV Confidential Plates ASP.NET (VB) Oracle 11g Confidential plates registrations and tracking
53 EOT RMV Crash Data VB 5.0 Crystal Reports Oracle 9i Comprehensive tracking and reporting tool for motor vehicle crashes in
on AIX P590 at ITD MA
54 EOT RMV Crash Data Electronic Submission VB 5.0, XML Oracle 9i on AIX Accepts electronically submitted crash reports from law enforcement
P590 at ITD
55 EOT RMV Data Warehouse Oracle 10g License and Person data
56 EOT RMV Dealer Repair Clipper dBase Tracks Sec V dealers, source for Sec V excise data
57 EOT RMV Driver Exam VB 5.0 Crystal Reports Access Driver test generation and grading system for driving school instructors
2.0
58 EOT RMV Drive Problem Tracking ASP.NET (VB) Oracle 11g Tracks issue related to the DRIVE program
59 EOT RMV Driver Licensing Foxpro 2.6 FoxPro Driving Schools and Instructors. Transportal Pro Screen Scraping -
feature not used anymore
60 EOT RMV DVS ASP.NET (VB) Oracle 11g Verifies driver license status for registered driver's of a vendor
61 EOT RMV DVD VB 5.0 Oracle 9i on AIX P590 at Billing system for Driver Vehicle Data
ITD
62 EOT RMV EDS Stats Foxpro 2.6 FoxPro EDS ALARS Statistical Reports to monitor IDMS db capacity (three
pieces - Reports, Reprint, DBA)
63 EOT RMV Email Service ASP.NET (VB) Oracle 11g Provides single location for formatting, sending and temporarily storing
application generated emails.
64 EOT RMV Email Template Manager ASP.NET (VB) Oracle 11g Used to create email templates used in the Email Service.
65 EOT RMV Employee Info Access 2000 Access 2000 RMV temp employee information.
66 EOT RMV FTP Gateways C/C++ Coordinates transfer and conversion of files between RMV and
Secretary of the Commonwealth
67 EOT RMV IPAYTAX VB 5.0 Crystal Reports Access Tax complaint tracking
2.0
68 EOT RMV Internet Manager VB 5.0 Crystal Reports Oracle Used to query and generate stats for the older internet transactions
10g
69 EOT RMV Internet Manager Web ASP.NET (VB) Crystal Reports Used to query and generate stats for the newer internet transactions
Oracle 11g
70 EOT RMV Internet Transactions (original) ASP.NET (VB) Oracle 10g Change of Address
Special Plates
Citation Payment
Renew License
Renew Mass ID
Renew Registration
Duplicate License
Duplicate Mass ID
Duplicate Registration
71 EOT RMV Internet Registration Inquiry ASP.NET (VB) Oracle 11g Public facing reg inquiry
72 EOT RMV Internet Title/Lien Inquiry ASP.NET (VB) Oracle 11g Public facing title/lien inquiry
73 EOT RMV Internet License/Permit Inquiry ASP.NET (VB) Oracle 11g Public facing license inquiry
74 EOT RMV Internet Driver's Ed Certificate ASP.NET (VB) Oracle 11g Public facing drivers ed cert inquiry
75 EOT RMV Internet JOL Web ASP.NET (VB) Oracle 11g Submit results for certain exams
Page 3 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
76 EOT RMV Internet Organ Donor ASP.NET (VB) Oracle 11g Update your organ donor status on your License
77 EOT RMV Internet Sweepers VB 5.0, C/C++ Oracle 10g Receive internet and renew by phone transactions and process against
ALARS
78 EOT RMV KMS ASP Oracle 10g Knowledge Management System. Built by Avaya
79 EOT RMV KTA Sweepers VB 5.0 Crystal Reports Oracle KTA Sweepers handle the back end process of the KTA front end.
10g
80 EOT RMV KTA Manager VB 5.0 Oracle 10g Utility tool for managing KTA sweepers
81 EOT RMV KTA VB 5.0 Crystal Reports Oracle The application handles fee calculation for Massachusetts and other
10g IRP jurisdictions. It determines necessary distribution amounts to the
other jurisdictions
82 EOT RMV License Service ASP.NET (VB) Shared service for license inquiry on ALARS
83 EOT RMV Motor Voter Realia COBOL Maintenance tool for managing container file for the Secretary of the
Commonwealth
84 EOT RMV Oracle Password Change VB .NET Oracle 9i Allows users to change their Oracle password
85 EOT RMV PDS Instructor Access 2000 Tracks professional driving schools.
86 EOT RMV Photo imaging 16 C/C++ ALARS Primary RMV Licensing, MAB and Inspector Licensing application
87 EOT RMV Photo imaging 32 C/C++ 6.0 ALARS Primary RMV Licensing, MAB and Inspector Licensing application
88 EOT RMV Photo imaging L-1 C/C++ 6.0 ALARS Primary RMV Licensing, MAB and Inspector Licensing application
89 EOT RMV Plate Lottery Realia COBOL Application for entering people into the plate lottery system
90 EOT RMV RDS Oracle 10g Data warehouse for ALARS cash transactions
91 EOT RMV Revenue Control Over Short VB 5.0 Crystal Reports Oracle 9i Revenue Operations' over / short cash clerk tracking
on AIX P590 at ITD
92 EOT RMV Red Light Blue Light Access 2000 Access 2000 Red Light (Fire) and Blue Light (Police) registrations and tracking
93 EOT RMV Registration Transaction Statistics Access 97 Oracle 10g Front end query tool to the RDS data warehouse
94 EOT RMV Renew by Phone Oracle 10g Automated voice response application, currently only handles Reg
Renew
95 EOT RMV Return License VB 5.0 uses CAB Title's db Scan licenses returned in the mail. Stores data in CAB dbf.
96 EOT RMV School Bus Endorsements Access 2000 Tracks school bus endorsements
97 EOT RMV Section 5 VB 5.0 Crystal Reports Oracle Section 5 applications and tracking system
7.3.4 (NT)
98 EOT RMV Section 5 sweeper VB 5.0 Oracle 7.3.4 (NT) Section 5 ALARS to Oracle conversion sweeper
99 EOT RMV SPOS ASP.NET (VB) Oracle 9i Special Plate Order System
100 EOT RMV STS VB 5.0 Crystal Reports Oracle 9i Time logging and CSR tracking system
r2 at ITD on P590 AIX, Access
2000
101 EOT RMV STS Intake ASP.NET (VB) Oracle 9i Used to request CSRs via the web
102 EOT RMV TEMPIS ASP.NET (VB) Oracle 11g Issue temporary dealer plates. Requires duplex printing
103 EOT RMV Transaction Service ASP.NET (VB) Oracle 11g Used to track intranet and internet web based transactions. Info is
available to Internet Manager application.
104 EOT RMV USD SQL Server 2000 CA application (customized) to support help desk processes
105 EOT RMV Vehicle Service ASP.NET (VB) Shared service for title, registration and vehicle inquiries on ALARS
106 EOT RMV VIS VB 5.0 Crystal Reports Access Vehicle inspection system (only motorcycle sticker tracking still in use)
2.0
107 EOT RMV VISITS ASP.NET (VB) Crystal Reports Inspection station and school bus inspection
Oracle 11g
108 EOT RMV Workload Manager VB 5.0 Oracle 10g, Access CA job scheduling tool. Runs 30+ custom backend VB5, .NET, etc jobs
Page 4 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
109 EOT RMV Registration ALARS, 3270 Allows the RMV to add new registrations, transfer, amend and inquire
on existing registrations.
110 EOT RMV Reg - Bank Lienholder Maint ALARS, 3270 Allows RMV to add, modify and view Lienholder information.
111 EOT RMV Reg - VIN/NADA/Make Maint ALARS, 3270 Allows RMV to add new makes to ALARS, view VIN information from
NADA
112 EOT RMV Reg - Corp/Comp Maint ALARS, 3270 Allows RMV to add, delete, modify and view Corporation/Company
information
113 EOT RMV Reg - EVR ALARS, 3270, AAMVA Allows Dealers to renew, transfer, cancel and issue new registrations
electronically
114 EOT RMV Title ALARS, 3270 Allows RMV to create, amend, print, and inquire on Title information
115 EOT RMV Cash ALARS, 3270 Subsystem provides detailed cash flow information from the point of
transaction activity to the transfer of funds to the state treasury and
other accounts. Also collects fees, disburses fees, reports on fees
collected/disbursed and captures detailed cler
116 EOT RMV Security ALARS, 3270 Multi level system that controls system access by the user, function or
activity being performed, terminal and time of day; Also allows
maintenance of this information by security administrator.
117 EOT RMV Emissions/Inspections ALARS, 3270 Captures and stores inspection data; also allows the user to inquire,
add, change and delete inspection information.
118 EOT RMV Suspensions ALARS, 3270 Provides the RMV the capability to suspend or revoke both license and
vehicle registrations; maintains driving records and histories on
licensed, unlicensed and out-of-state licensed operators; allows the
RMV to enter hearing information, findings; allows
119 EOT RMV CMVI ALARS, 3270 Allows the RMV the ability to process citations for Civil Motor Vehicle
Infractions for the district courts; also collects CMVI data, fees and
fines.
120 EOT RMV NonRenew ALARS, 3270 Allows the RMV the ability to mark registrations for non-renewal when a
customer has unpaid parking tickets, excise tax bills, unresolved
abandoned vehicle citations, outstanding child support payments or
warrants for his/her arrest
121 EOT RMV UMS (Uninsured Motorist Subsystem) ALARS, 3270 Allows the insurance companies to communicate to the RMV insurance
status of registered vehicles; insurance companies can add, cancel,
renew or modify insurance polices attached to individual registrations via
on-line screens or nightly batch process.
122 EOT RMV CVO ALARS, 3270 Commercial Vehicle Operations - allows the RMV to issue, inquire,
amend, renew, and print permits for overweight reducible vehicles
123 EOT RMV Section 5 ALARS, 3270 Allows the RMV to process, view, add, delete and modify Section 5
registrations (Dealer/Repair/Farm/Owner Contractor/Transport)
124 EOT RMV NMVTIS ALARS, 3270, AAMVA National Motor Vehicle Title Information System enables states to
electronically exchange title, brand and title theft information prior to
issuing a new Title
Page 5 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
125 EOT RMV Accident Information ALARS, 3270 Maintenance of Town and suburb information
126 EOT RMV MRB ALARS, 3270 Merit Rating Board subsystem
127 EOT RMV MAB ALARS, 3270, AAMVA, CDLIS, Medical Affairs Bureau subsystem
NDR, SSA
128 EOT RMV Licensing ALARS, 3270, AAMVA, CDLIS, Driver Permit and Licensing subsystem
NDR, SSA
129 EOT RMV Inspector Licensing ALARS, 3270, AAMVA, CDLIS, Vehicle Inspector Licensing subsystem
NDR, SSA
130 EOT RMV Exam Booking ALARS, 3270 Office and exam scheduling services
131 EOT RMV PDPS ALARS, 3270, AAMVA, NDR Problem Driver Pointer System - tracks and maintains a pointer file of
problem drivers who have been convicted of a major conviction,
currently under suspension, have been revoked/suspended in the past
as reported by each state
132 EOT RMV QMatic Branch ticket queuing system for customers
133 EOT RMV MVN Branch ad and queuing displays
134 EOT RMV / MHD Copras ASP.NET (VB) Oracle 10g Commercial Overweight Permit Renewal Application System
135 EOT Secretary EOT Contact Database Access, SQL Server 2005 Database used to maintain contact information and group listings for
EOT Secretary office.
136 EOT Secretary Management Reporting SharePoint Portal SharePoint Secretary's Task Tracker.
137 EOT EOT Portal (SharePoint) SharePoint EOT Portal Starting Page. It provides links to the Sharepoint Sites
currently available
138 EOT Federal Transportation Reauthorization - SharePoint A team collaboration site for the Federal Transportation Reauthorization
SharePoint Project.
139 EOT Intraway Intranet Site ASP, SQL Server 2000 Provides the web starting point for all MHD and several EOT
applications. Many of the applications listed here have their entrance
through the Intraway.
140 EOT MassRides Web Page ASP, SQL Server 2000 Allows users to register for carpooling and vanpooling.
141 EOT Reporting Center ASP, SQL Server 2000, The Reporting Center is a centralized location for enterprise reporting
Reporting Services, Analysis that includes Management Reports, Financial / Local Aid, Projects,
Server Bridges, Construction and Highway Operations reports and cubes.
142 EOT SharePoint Transportation Bond Bill Project Site SharePoint, Reporting services SharePoint Site used for hosting of reports and for collaborative efforts
pertaining to the 2008 Transportation Bond Bill and other Bond Bills.
143 MAC Airport Information Mgt System Access MAC and FAA grant awards to local airports for renovation and
expansion of their facilities. Projects are entered and tracked in this
database as well as State payments. It generates payment vouchers
(invoices), award amounts.
144 MAC MAC Web Site ASP, SQL Server 2000 Used by statewide airports for the requesting and issuance of airport
security badges.
145 MHD ABP Accelerated Bridge Program (ABP) SharePoint SharePoint Contains Accelerated Bridge Program (ABP) goals and progress used
Site by multiple agencies including DCR.
146 MHD Audit Audit Access Audit group database
147 MHD Bridge Bridge Management System 4D MHD tracks the Status of all bridges via the Bridge Identification
Number (BIN) in support of internal as well as Federal reporting.
148 MHD Bridge Historic Bridge Inventory List ASP, SQL Server 2000 Lists historical bridges in Massachusetts.
149 MHD CEPO Reporting Center for CEPO ASP.Net, SQL Server 2000 Capital spending web-based reports of Cash Flow and Status of
Available funds by org.
Page 6 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
150 MHD Chief Engineer's Office Accurate Cost Estimator Excel This tool is designed to help planning and design engineers at
Massachusetts Highway Department to make accurate cost estimates
of bridge construction projects when little information is known.
151 MHD Chief Engineer's Office Architecture and Engineering Board (A & E Board) Access 2000 Used for the authorization of Projects.
152 MHD Construction Advertised Projects Bid Opening Schedule ASP, SQL Server 2000 Displays current list of advertised MHD projects.
153 MHD Construction Construction Contracts Access System used to manage prequalification of contractors as well as bid
opening, plans and specifications distribution, etc. Used in the tracking
of construction and maintenance contracts going out for Bid. Includes
approved vendors. Slated for Phase 1 CMS
154 MHD Construction Construction Division System Access Used in tracking Contracts, Payments, Correspondence Log by Boston
HQ Construction office.
155 MHD Construction Construction Project Estimator ASP.Net, SQL Server 2000 You can generate a preliminary estimate from an existing MassHighway
project that is currently in the design phase or from a new, non-
MassHighway project that you define.
156 MHD Construction Construction Staffing Access Active and Future Construction Staffing
157 MHD Construction Contracts And Records Access Department Secretary Tracking System
158 MHD Construction Correspondence Tracking Access Letters and memos to the Commissioner
159 MHD Construction District Contract Database Access, SQL Server 2000 Used by Districts to track construction contract status including all-
important spending and projections. Also generates Federal reports and
HQ Reports. Slated for Phase 2 CMS
160 MHD Construction District Projects Database Access Used by District 5 internally to track Project status for briefings.
161 MHD Construction District Stockroom Inventory System Access Inventory tracking system. (being replaced by FleetWave)
162 MHD Construction EBO ASP, ASP.Net, SQL Server 2005 Labor compliance and certified payroll tracking. Will replace CHAMPS
163 MHD CONSTRUCTION Prequalified Consultants ASP, SQL Server 2000 Provides basic information about architectural and engineering firms
that are currently prequalified by MassHighway.
164 MHD Construction S.A.M. (Site Application Module) ASP, SQL Server 2000, DTS Used by Construction field engineers to track the items on a contract.
165 MHD Construction Weighted Average Bid Program ASP.Net, SQL Server 2000 The Weighted Bid Prices module of the Construction Project Estimator
is intended to provide access to timely average mean and median bid
price data.
166 MHD Highway Engineering Utility Contacts ASP Display all utility contact information by selecting a municipality from the
drop-down list.
167 MHD Highway Engineering Utility Contracts Access Database to store utility job information.
168 MHD Highway Ops Adopt a Highway Access Tracks Adopt-A-Highway routes and organizations
169 MHD Highway Ops Event Reporting System ASP, Oracle The web-based Event Reporting System (ERS) allows the entry and
viewing of real-time transportation and security related events
throughout the Commonwealth of Massachusetts. In addition to being a
point of information entry and viewing, the ERS facilitate
170 MHD Highway Ops FleetWave Fleet Management System ASP.Net, SQL Server 2005 Used by Highway Operations to track all vehicles owned/rented by EOT
and parts inventory.
171 MHD Highway Ops Highway Emergency Locator Patrol (HELP) Access Tracks activities related to the Cares Vans that respond to highway
emergencies.
172 MHD Highway Ops MASSTERS ASP, Oracle Used by Traffic Ops Center to track event requests.
Page 7 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
173 MHD Highway Ops Snow and Ice Administration Access, SQL Server 2000 Allows District personnel to edit and update the Equipment and Vendor
information. This data is exported regularly to the external database in
support of the Time Keeper web application.
174 MHD Highway Ops Snow and Ice Time Keeper ASP, SQL Server 2000 During snowfall and icing events, the Snow and Ice Engineers log
equipment and material usage into this web-based application. The
data is used for payment.
175 MHD Highway Ops TOC Call Log Access Tracks calls made into the MHD Traffic Operations Center (TOC)
176 MHD Highway Ops / District District Administration Database Access Tracks personnel info, positions, expenses, training, attendance,
1 actions, equipment, overtime, accidents.
177 MHD HR Job Postings Access Database to store internal job postings
178 MHD HR Reporting Center for HR Data for MHD SharePoint, SQL Server 2000, HR Reports and cubes in support of HR and Civil Rights workforce
Analysis Server analyses for MHD personnel.
179 MHD IT Administration Engineering System (AE) VB.Net, Access 2000, SQL The AE system allows MassHighway to track the status of construction
Server 2000 contracts, from the office estimate to finals payment processing.
180 MHD OAD Outdoor Advertising Access, ASP.Net, SQL Server Tracks sign inventory , permit issued, license issued and inspections
2005 completed for the MHD Outdoor Advertising program.
181 MHD PERMITS Online Truck Permits ASP.Net, ASP, SQL Server 2000 Allows companies to request and pay for a permit to travel
Massachusetts roadways with oversized/overweight vehicles.
182 MHD PLANNING Road Inventory Interactive Maps ASP.Net, SQL Server 2000, This interactive mapping application is used to show the most
ARCIMS commonly requested road inventory attributes that the Planning Office
maintains in ArcGIS format.
183 MHD PPD Public Private Development Unit Access Used in tracking environmental permitting.
184 MHD Project Management ProjectInfo Housekeeping Reports Reporting Services, SQL Server This system provides a collection of reports that help identify Projects
2005 and/or Contracts that might benefit from attention by the MHD Project
Managers, etc.
185 MHD Project Management Structurally Deficient Bridges Access 2000, SQL Server 2000 Provides an interface for creation of a link between a Structurally
Deficient (SD) Bridge and the ProjectInfo project associated with it. This
link is used in the Reporting Center's Governor's report.
186 MHD Safety Signal Inventory Database Access Signal Inventory Database
187 MHD Survey Survey Control and Layout Points ASP, ARCIMS, SQL Server 2000 Allows survey and civil engineering companies to display control points,
layout plans and easement plans.
188 MHD Traffic Intersection Inventory Layout System Access Used by the Traffic section to plan out intersection design and catalog
intersection diagrams. Contains info like location, pavement markings,
equipment, traffic signal wiring diagrams, traffic control box settings,
traffic turning volume, utility poles,
189 MHD TRAFFIC Traffic Volume Counts ASP Displays traffic count information by either municipality or numbered
route.
190 MHD District and Town Information ASP, SQL Server 2000 Displays town data (website, projects, and utility contacts) organized by
MHD district and municipality.
191 MHD MHD Cash Flow ASP.Net, SQL Server 2000, This web-based database application tracks required cash flow for
Analysis Server construction projects from beginning (To be Advertised) all the way to In
construction and completion (Inactive). Costs are rolled up by Fiscal
Year based on basic models or actual project
192 MHD ProjectInfo ASP.Net, SQL Server 2005, VB6 Central repository for Project and Contract related data for MHD.
193 MHD ProjectInfo External (Web) ASP.Net, SQL Server 2005 External (Web) version of ProjectInfo. This is primarily a reporting
system of projects in design or construction.
Page 8 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
194 MHD Reporting Center for the Governors Report SharePoint, SQL Server 2000 Reports used by Deputy Commissioner to report monthly progress to
the Commissioner and eventually to the Secretary. Reports include
Structurally Deficient Bridge status, etc.
195 MHD State Highway Access Permits Access, ASP.Net, SQL Server Prior to entering a state highway for any reason other than for travel one
2005 must have an Access Permit. This system allows the entry and storage
of a state highway access permit application. Currently being
redesigned.
196 MTA Accounting Oracle Financials Oracle Accounting, Budget and Finance
197 MTA Accounting Noetix Views Noetix Financial reporting Tool
198 MTA Accounting Oracle Discoverer Oracle Accounting, Budget and Finance
199 MTA Accounting Unpaid Toll Application Trending Reporting
Access97
200 MTA Accounting Invoicing Paid CAT Custom Oracle Aggregates all accounting Financial Reports
201 MTA Accounting Joint Venture commitments CAT Custom Oracle Subset breakout of Joint Venture Financial Values
202 MTA Communications FactoryServer MASS Group Maintenance and Asset Management for Communications
203 MTA Construction Automated Mod Process CAT Custom Oracle Controls contract Modification Pay item Generation & Financial Rules
204 MTA Construction Communications control Register - Construction CAT Custom Oracle Tracks incoming & outgoing contractors Letters
205 MTA Construction Concrete Test Results CAT Custom Oracle Tracks, Monitors & Messages Contract concrete sampling
206 MTA Construction Contract / Package Statusing CAT Custom Oracle Reports & controls contract Specific dates & Status (NTP, Su, CPT,
Award, etc.
207 MTA Construction Contract Fixed Milestones CAT Custom Oracle Summary Report Shows forecast and actual dates for each contract
208 MTA Construction Contract Punch List CAT Custom Oracle Tracks the List of uncompleted contract items
209 MTA Construction Contract Status CAT Custom Oracle Summarizes contract Specific Key categories (RFI, DR, DOM, ETC
counts and Status)
210 MTA Construction Contract Statusing CAT Custom Oracle Reports & controls contract Specific dates & Status (NTP, Su, CPT,
Award, etc.
211 MTA Construction CQE Processing CAT Custom Oracle Controls/Manage and Feeds Project accounting System for contractor
Payments
212 MTA Construction CQE Processing / Vouchers CAT Custom Oracle Contract Quantities estimates used to Pay contractors
213 MTA Construction Deficiency Reporting CAT Custom Oracle Administers contractor deficiencies
214 MTA Construction Design document Tracking CAT Custom Oracle Tracks Design Documents (merged with DCL)
215 MTA Construction Disposition of Materials CAT Custom Oracle Administers contract Material deficiencies
216 MTA Construction Drawing control Logs CAT Custom Oracle Tracks contract drawings with Revisions & affect docs
217 MTA Construction Equipment/Workforce CAT Custom Oracle Tracks contract equipment & Labor
218 MTA Construction Field change Notice CAT Custom Oracle Related to documenting changes to drawings From construction
219 MTA Construction Field engineer daily Reports CAT Custom Oracle Captures FE comments about specific construction activities on a daily
basis
220 MTA Construction Field Safety Report CAT Custom Oracle Tracks and reports on all Field Safety issues
221 MTA Construction Force account commitments CAT Custom Oracle Used to Pay Force accounts (NSTAR, Keyspan)
222 MTA Construction Inter-contract Issues CAT Custom Oracle Tracks Issues between construction contracts along with their reporting
and final disposition
223 MTA Construction Material/Job control Logs CAT Custom Oracle Tracks and administers Material Specific contractor Submittals
224 MTA Construction Meeting Minutes/action items CAT Custom Oracle Captures contract Meeting Minutes and Tracks Meeting actions
Page 9 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
225 MTA Construction Open items CAT Custom Oracle Merges DOM & Submittal open items to Summarize contract - Lab
Reporting
226 MTA Construction Photo Database CAT Custom Oracle Manages Project Photos
227 MTA Construction Police Log CAT Custom Oracle Tracks and Pays Police details That Support construction
228 MTA Construction Request for information Logs CAT Custom Oracle Tracks, administers & dispositions contractor Requests for information
229 MTA Construction Subcontractor approval Log CAT Custom Oracle Tracks & controls Subcontractor usage for The contract & Project
230 MTA Construction Submittal Tracking CAT Custom Oracle Tracks & controls contractor Submittals in The Field office & Lab
231 MTA Construction Survey Request Log CAT Custom Oracle Tracks The Field office Requests for Surveying
232 MTA Construction Primavera Primavera Primavera Schedules Provided by contractor used to Show forecasted
completion dates and actual dates
233 MTA Construction Von Gunten Concrete Test system (Lab Data) Von Gunten / Sharknet Tracks & stores the measurement results for Concrete cylinder break
tests. DTR (Daily Test Report System) and CPR (Cement Product
Performance Reporting System)
234 MTA Construction - Claims & Certified Payroll for C17AA CAT Custom Oracle Tracks the C17AA Certified Payroll for McCourt / Obiyashi
Changes
235 MTA Construction - Claims & Construction forecasting CAT Custom Oracle Allows FCAS to enter Pay item forecasts for Trending
Changes
236 MTA Construction - Claims & Contingency drawdown CAT Custom Oracle Monitors & administers Project contingency drawdowns
Changes
237 MTA Construction - Claims & Contractor Proposals/Claims CAT Custom Oracle Contractor Proposal Module Tracks & does "ball in court"
Changes Responsibilities
238 MTA Construction - Claims & Mod Tracking CAT Custom Oracle Controls Financial Project Rules in Mod development
Changes
239 MTA Construction - Claims & PCN Tracking CAT Custom Oracle PCN is Now called issues. The issue Module is The Preliminary
Changes Notification for Mods
240 MTA Cost Scheduling Budget control CAT Custom Oracle Administers The Project budget control System
241 MTA Cost Scheduling Construction/design commitments. CAT Custom Oracle Tracks Funding Commitments for Construction and Design contracts
242 MTA Cost Scheduling Escalation Processing CAT Custom Oracle Tracks escalation factors & centroids for contracts
243 MTA Cost Scheduling Financial database integrity & tracking CAT Custom Oracle Consists of upper Level Tables & Reporting That Maintain accuracy
244 MTA Cost Scheduling Management Reporting CAT Custom Oracle Umbrella Reporting System That covers a Myriad of individual Reports
245 MTA Cost Scheduling MCN/BTN Processing CAT Custom Oracle Management change Notice & budget Transfer Tracking System
246 MTA Cost Scheduling Project Financing CAT Custom Oracle Part of obligation Financing System Relation to State & Federal
Participation
247 MTA Engineering 4D Client Bridge Inspection software Bridge Inspection Tracking
248 MTA Engineering ArcView ESRI Drawing & Mapping
249 MTA Engineering AutoCAD / AutoCAD Light Drawing application
250 MTA Engineering Auto Sketch Auto Desk Engineering
251 MTA Engineering AutoCad, Autocad Map3D Auto Desk Engineering
252 MTA Engineering CADD Engineering - Master Utilities Inventory GDS Engineering
Database
253 MTA Engineering CADD Engineering - MCN - Tunnel and Boat GDS Engineering
Section SIP Plans
Page 10 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
254 MTA Engineering Drafting Operations for Architecture and Urban GDS Engineering,Architecture & Urban Design
Design
255 MTA Engineering Drainage Structural Plans GDS Engineering, Environmental
256 MTA Engineering GDS Classic Informatix Drawing Support
257 MTA Engineering GDS Micro Informatix Drawing Support
258 MTA Engineering Instrumentation Monitoring CAT Custom Oracle Maintains all The Project Instrumentation & Their Readings Throughout
Time
259 MTA Engineering Microstation / Intergraph Integraph Drawing Support
260 MTA Engineering Oracle/GIS interface CAT Custom Oracle, GDS Marries The Cadd database to Oracle datapoints to develop drawings
261 MTA Engineering Record Drawings Various
262 MTA Engineering Right of Way Layout Drawings Production GDS Engineering
263 MTA Engineering Special Projects - Public Improvement Autocad, GDS Engineering
Commission (PIC)
264 MTA Engineering Utility As-Builts ? Engineering
265 MTA Engineering Work Program 16 - Exporting of CADD/GDS for GDS Engineering, O & M
O&M Manuals
266 MTA Engineering Work Program 16 - Section Design CADD File Autocad, GDS Engineering, O & M
Conversion
267 MTA Engineering Consultant Progress Payments (SDC) CAT Custom Oracle Tracks & Monitors Payments to Section design consultants (Like CQE
Process)
268 MTA Engineering Traffic Submittal Response CAT Custom Oracle Allows contract Submittals Relating to Traffic to be answered on-Line
269 MTA Environmental Services BSC Permit Index and Correspondence Database CAT Custom Access97 Tracks all CA/T permit actions and correspondence
270 MTA Estimating Bid item Master Lists Timberline Estimating Contract bid item Lists
271 MTA Estimating Bid Tabulations Timberline Estimating Evaluates Submitted contract bids/Tallies Variables
272 MTA Facilities AssureID Identification MTA Prox ID Creation and Tracking
Resources
273 MTA Facilities Garage Pass Tracking Application Access97 Tracking and reporting
274 MTA Facilities Mailstop Management CAT Custom Oracle Controls Project Mail Stops
275 MTA Facilities Telephone Management CAT Custom Oracle Manage Who Has What Telephone, Pagers, cell Phones & Radios
276 MTA Facilities Meeting Room Manager Netsim Allows booking and tracking of conference rooms
277 MTA Financial Funding Management CAT Custom Oracle Administers Funding Sources & Management - no longer used
278 MTA Financial Obligation forecasting CAT Custom Oracle Administers obligation forecasting - reports only
279 MTA Financial Projectwide cash flow CAT Custom Oracle Utilizes Field Scheduling cash flow data to develop Project cash flow
280 MTA HR/Benefits Correspondence Tracking Application Tracking and reporting
Access97
281 MTA Human Resources Training CAT Custom Oracle Tracks each employee's Participation in Training classes
282 MTA IT Crystal Report Professional Business Objects/SAP Report Generation
283 MTA IT Business Objects Enterprise Business Objects/SAP Toll Data Analysis & Reporting
284 MTA IT Crystal Report Developer Business Objects/SAP Report Generation
285 MTA IT Toad for Oracle Quest Oracle database development, management and analysis tool
286 MTA IT Track-It! Numara Help Desk Call/Inventory/
Service Contract/Software Management Tracking & Reporting
287 MTA IT MTA Web Site Ashton Services MTA Web Site
Galaxy
Page 11 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
288 MTA IT Content Management System Ashton Services MTA Web Site
Galaxy
289 MTA IT Adobe Acrobat Professional Adobe Documentation create and edit
290 MTA IT Microsoft Office Professional Microsoft Office Applications and Tools
291 MTA IT Microsoft Visio Professional Microsoft Flow Charts Creator
292 MTA IT Microsoft Windows XP Professional Microsoft Operating System
293 MTA IT Microsoft Windows Server Microsoft Foundation for Applications
294 MTA IT Oracle Financials Client (Jinitiator)
295 MTA IT SnagIt SnagIt Image Capture
296 MTA IT Simplicit Locked Browser
297 MTA IT VMPlayer/VMWare Client VMware PC Virtualization
298 MTA IT WinZip WinZip File compression & encryption
299 MTA IT Active Directory Microsoft Directory and Security
300 MTA IT ADManager AdventNet Directory and Security
301 MTA IT BlackBerry Enterprise Server RIM Remote Access to Exchange
302 MTA IT Lyris ListManager Lyris Tool used to manage our distribution list of subscribers to our
newsletters and alerts
303 MTA IT FASTLANE Account Manager Web site Transcore System used to manage accounts of transponder owners/holders
304 MTA IT WebTrends WebTrends Web analytics tool
305 MTA IT Survey Monkey Survey Monkey Survey Builder Tool
306 MTA IT Enterprise Vault/KVS Symantec E-mail archiving and discovery
307 MTA IT Exchange Server Microsoft E-mail/Calendar/Contacts
308 MTA IT HP Systems Insight Manager HP Network and Server Monitoring
309 MTA IT McAfee ePolicy Orchestrator/VirusScan McAfee AntiVirus/Security
310 MTA IT Symantec Antivirus Endpoint Protection Symantec AntiVirus/Security
311 MTA IT Media Server Streaming of live traffic cameras
312 MTA IT NetBackup Symantec Data Protection (Backup/Restore)
313 MTA IT Backup Exec Symantec Data Protection (Backup/Restore)
314 MTA IT CA BrightStor ArcServe Backup Computer Associates Data Protection (Backup/Restore)
315 MTA IT Orion Solarwinds Network and Server Monitoring
316 MTA IT PatchLink Update Lumension Server Patch Management
317 MTA IT ProfileMaker Microsoft Drive Mappings and Desktop OS/Application Customization
318 MTA IT Quest Recovery Manager for Active Directory Quest Protection of critical security and directory data
319 MTA IT Terminal Services (VPN Server) Microsoft Remote Access
320 MTA IT TreeSize Professional TreeSize Network and Server Monitoring
321 MTA IT Vmware ESX Server VMware Virtualization
322 MTA IT Websense Websense Internet Access Management
323 MTA IT WSUS (Windows Server Update Services) Microsoft Desktop Patch Management
324 MTA IT MPET MMIS Four Winds Group M&O Management
325 MTA IT Ingrian Networks (1 database license, non-prod) Safenet PCI Compliance
326 MTA IT Ingrian Networks (2 application licenses, non- Safenet PCI Compliance
prod)
327 MTA IT Ingrian Networks (2 database license, prod) Safenet PCI Compliance
328 MTA IT Ingrian Networks (4 application licenses, prod) Safenet PCI Compliance
Page 12 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
329 MTA IT Barcode / Asset Management & Tracking CAT Custom Oracle Track asset inventory via barcode
330 MTA IT Tape Inventory Tracking CAT Custom Oracle Tracks the Inventory of CA/T Backup tapes.
331 MTA IT Form Flow Delrina
332 MTA ITS Sybase Sybase, Inc.
333 MTA ITS GroupWise Novell GroupWise E-Mail
334 MTA ITS GroupWise-Web Mail Novell/W2K Web Based Mail Access
335 MTA ITS Novell Novell Network File/Print Services
336 MTA ITS Novell Novell Network File/Print Services
337 MTA ITS Access control / Safety CAT Custom Oracle Controls & administers Oracle Menu Access for The Project
338 MTA ITS Network id Tracking CAT Custom Oracle Part of The Oracle Menu System That Validates Network user ids to
employees
339 MTA ITS Oracle Project Menu CAT Custom Oracle The Oracle Menu System
340 MTA ITS Software diskettes, CDs CAT Custom Oracle Used by IT dep't to Track Location, Status, Media Type & Version
341 MTA ITS Adobe Acrobat Reader Adobe Used for reading/viewing pdf files
342 MTA ITS Adobe Acrobat Writer Adobe Used for creating pdf files
343 MTA ITS Adobe Illustrator Adobe Photo / Presentation
344 MTA ITS Adobe Photoshop Adobe Photo / Presentation
345 MTA ITS dBase Borland Used to look at Legacy systems
346 MTA ITS FoxPro Microsoft Used to look at Legacy systems
347 MTA ITS Lotus 123 Lotus
348 MTA ITS Lotus Organizer Lotus
349 MTA ITS Microsoft Office MicroSoft Word / Excel / Powerpoint / Internet Explorer
350 MTA ITS Microsoft Terminal Server Microsoft
351 MTA ITS Microsoft Visio MicroSoft Visio
352 MTA ITS Nexic Forensics Nexic Email inquiries
353 MTA ITS Spotlight on Oracle Quest Software DBA Tool
354 MTA ITS TOAD for Oracle Quest Software Application Development Tool
355 MTA ITS VAX VMS HP
356 MTA ITS Veritas Backup Exec Symantec IT Backup Software
357 MTA ITS Virus Protection Symantic, McAfee Virus Protection
358 MTA ITS Visual Basic MS VB Program development
359 MTA ITS WinZip V8 Microsoft Compress Files
360 MTA ITS WipeDrive White Canyon Wipes Disk Drives clean of data
361 MTA ITS Word Perfect 6.1 Corel Word Processor
362 MTA ITS Remedy Action Request Helpdesk Ticket Tracking Remedy Corporation Tracks Help Desk, Network, and MIS tickets for IT
System
363 MTA Legal Time Matters LexisNexis Legal Case Management
364 MTA Legal Westlaw/Premise Westlaw Legal Documentation
365 MTA Maintenance Ford IDS Software Vehicle Maintenance
366 MTA Maintenance GPS Fleet VehicleTracking
367 MTA MTA/MHD Mod Date/Approval Tracking CAT Custom Oracle Part of the Mod Tracking Process now
368 MTA MTA/MHD PCN Date/Approval Tracking CAT Custom Oracle Part of the PCN/Issue Tracking Process Now
369 MTA OCC Operations OCC Incident Tracker MTA Custom Incident Tracking System
370 MTA OCC Operations C22A9 Security System CA/T CA/T Facilities Security
Mass Electric/Siemens
371 MTA OCC Operations Integrated Project Control System (IPCS) CA/T Traffic Management
Transdyn DYNAC used as the base software Transdyn, Inc. Facilities Management
Page 13 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
372 MTA OCC Operations Fire Zone MTA Custom
Access97
373 MTA OCC Operations Dambach VMS Dambach Dambach VMS Sign Control
374 MTA OCC Operations Double-Take Replication and Failover for OCC
375 MTA OCC Operations Emergin Emergin Paging Software
376 MTA Operations EJ Ward Fuel System EJ Ward Fuel Usage Tracking
377 MTA Operations IMaint DPSI Inventory & Maintenenace Tracking
378 MTA Operations Real Estate Application Rent/Lease tracking and reporting
Access97
379 MTA Operations Storms Application Material and Labor Reporting
Access97
380 MTA Operations Training Application Tracking and reporting
Access97
381 MTA Operations Contracts Application Tracking and reporting
Access97
382 MTA Operations Clearance Certificate CAT Custom Oracle Controls tracking of employee clearance certificate for those leaving the
project
383 MTA Operations & O&M CCR CAT Custom Oracle Tracks operations & Maintenance CCR (Letters In/Out)
Maintenance
384 MTA Operations & O&M Equipment Turnover CAT Custom Oracle Tracks expected equipment testing and turnover capability
Maintenance
385 MTA Operations & O&M RFI Response CAT Custom Oracle Tracks O&M Responses to Requests for Information (also establishes
Maintenance Prelim. Status)
386 MTA Operations & O&M Submittal Response CAT Custom Oracle Tracks O&M Responses to contractor Submittals (also establishes
Maintenance Prelim. Status)
387 MTA Operations & O&M Training Tracking CAT Custom Oracle Tracks & administers Training Provided to MTA users on contract
Maintenance equip/Systems
388 MTA Operations & Roadway/Facility Turnover CAT Custom Oracle Tracks planned turnover of all facilities and roads
Maintenance
389 MTA Payroll Kronos Time & Attendance - MTA Kronos Time & Attendance
390 MTA Payroll Kronos Time & Attendance - State Police Kronos Time & Attendance
391 MTA Payroll PeopleSoft Oracle Payroll
HR/Benefits
392 MTA Payroll Payroll Transmission and Reporting
Access97
393 MTA Records Management Administrative Archive & Turnover Index Tracking CAT Custom Oracle Controls archive box Submission, Retrieval & Return
394 MTA Records Management Communications control Register - Procurement CAT Custom Oracle Component of The Project CCR System custom Tailored to
Procurement
395 MTA Records Management Correspondence Numbering Log (CNL) CAT Custom Oracle Controls outgoing Project Letter Numbers
396 MTA Records Management Freedom of information Request CAT Custom Oracle Tracks Requests From General Public for Project information & Their
disposition
397 MTA Records Management Informal Correspondence CAT Custom Oracle Tracks all informal correspondence
398 MTA Records Management Keyfile Document Tracking CAT Custom Oracle Document Imaging
Page 14 of 15
95247a97-5cb4-4622-9407-189b0b3a12af.xls - as of May 5, 2009
Ref# Owner Department Name of Application Technology Description
399 MTA Records Management Master File index CAT Custom Oracle Manage Project Letter File codes
400 MTA Records Management MTA Oracle Archives CAT Custom Oracle Controls archive box Submission, Retrieval & Return for the MTA
401 MTA Records Management Old-CCR CAT Custom Oracle Old Correspondence Control data - used for searches
402 MTA Records Management PDCC CCR CAT Custom Oracle PDCC Correspondence Control
403 MTA Records Management Project Manual Tracking CAT Custom Oracle Tracks all Project Procedure Manuals
404 MTA Records Management Project Report Tracking CAT Custom Oracle Tracks all Project Reports and Their Location
405 MTA Records Management Record Request Tracking CAT Custom Oracle Tracks all internal and External requests for records and information
406 MTA Records Management SDC Correspondence CAT Custom Oracle Tracks correspondence of SDCs
407 MTA Risk Management WC_Reporting_DB.mdb Claim Management (enhancement)
Access97
408 MTA Risk Management Loss Run Application Claim Management (enhancement)
Access97
409 MTA Risk Management Workers Compensation Application Claim Management
Access97
410 MTA Safety Monthly Safety Walkdown CAT Custom Oracle Tracks monthly waldowns with BFD at field sites
411 MTA State Police State Police Detail Application Details & Overtime Tracking for Payroll and assignment
Access97
412 MTA State Police State Police Citation Application Massachusetts Citation tracking for Troop E
Access97
413 MTA State Police State Police Accident Log Massachusetts Accident tracking for Troop E
Access97
414 MTA State Police Info Rad Info Rad Paging Software
415 MTA State Police Morse Watchman Software
416 RMV IT RMV Intranet HTML, ASP RMV Intranet
417 RMV Crash Data ASP.Net, SQL Server 2000, Interactive mapping application that displays accident data. Organized
ARCIMS by year and location.
418 RMV Reporting Center for RMV ASP, Analysis Server The Reporting Center for RMV currently provides Bus Inspection Data
419 RMV RMV Crash Reporting Center ASP.Net, SQL Server 2000, Crash cubes and reports site developed for MHD. Provides reports, Ad-
Analysis Server Hoc reporting, Analytics, and Mapping based on RMV crash data.
420 DCD Project Site SharePoint Used by Boston HQ, IT Developers, and District Construction personnel
to stay updated on DCD development work.
Page 15 of 15
Related docs
