Attachment 9 - ASSC Application List.pdf

Characteristics of Active ASSC Applications

Application Name: Administrative, Legislative Executive Request Tracking System

Acronym

ALERTS

Office

OGC

Description Tracking system of requests for comments on pending legislation.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Business Operations

Monthly Transaction Volume

Small: Less 100 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Low/Very Manageable

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture

SQL

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Medium (26 to 199)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio General DO Administrative Systems

Tuesday, October 27, 2009 Page 1 of 36

Application Name: Asset Management

Acronym

AM

Office

ASM - OAM

Description ASM-OAM project is on "hold"

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Business Operations

Monthly Transaction Volume

Year Implem or Rewritten

Size

Complexity

Medium/Moderate Complexity

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software

COTS

Primary Data Mgmt Architecture

Authentication Password

Security Classification Sensitive but Unclassified

COOP/DR Functionality

Number of User Accounts

Enterprise (over 500)

SDLC Stage Planning

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio AS Management Enterprise Systems

Tuesday, October 27, 2009 Page 2 of 36

Application Name: Automated Blocking and Reject Reporting System

ABARRS

Office

OFAC

Description Tracks all blocked transactions from financial instititutions. Primary application resides on DO LAN, a portion of the public facing application resides at Qwest and is dependent on TSAS.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

100000

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Business Operations

Monthly Transaction Volume

Medium: 100-999 Month

Year Implem or Rewritten

Size

Large Over $500K Complexity

Significant/High Degree of Complexity

Annual Number of Releases Significant: 3 to 5 releases each with 3 to 6 changes with 2 to 4 entailing significant function features or upgrades

Operational Availability Requirements High (99.5 - 99.9% or greater availability 365 Days less than 5 hours down time per month)

Software Custom Code

Primary Data Mgmt Architecture Oracle

Authentication PKI/Token

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Enterprise (over 500)

SDLC Stage Operational

Secondary Data Mgmt Architecture

SQL

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio Terrorism Finance and Asset Control

Tuesday, October 27, 2009 Page 3 of 36

Application Name: Blocked Assets

BA

Office

OFAC

Description Annual reporting of blocked assets by financial institutions. Closely related to ABaRRS which monitors continuous reported of blocked financial transactions.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code 30000

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Business Operations

Monthly Transaction Volume

Small: Less 100 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Low/Very Manageable

Annual Number of Releases Significant: 3 to 5 releases each with 3 to 6 changes with 2 to 4 entailing significant function features or upgrades

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Small (less than 25)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 4 of 36

Application Name: Business Intelligence Tool

SHIMS-BI

Office Treasury-wide

Description Business intelligence solution for Safety (SHIMS) .

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Analytical

Functional Category Human Resources

Business Value Business Operations

Monthly Transaction Volume

Medium: 100-999 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Medium/Moderate Complexity

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software

COTS

Primary Data Mgmt Architecture

SQL

Authentication Password

Security Classification Sensitive but Unclassified

COOP/DR Functionality

Number of User Accounts

Medium (26 to 199)

SDLC Stage Planning

Secondary Data Mgmt Architecture Other

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 5 of 36

Application Name: Case Matters Management System

CMMS

Office

OGC

Description This is a business application that accounts, documents, tracks and reports on the pending, active and closed legal cases being handled by the Associate General Counsel for General Law and Ethics (GLE).

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Administrative/General Suppor

Monthly Transaction Volume

Small: Less 100 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Low/Very Manageable

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture Access

Authentication Password

Security Classification Sensitive but Unclassified

COOP/DR Functionality Batched Weekly/Monthly DR/COOP content refresh

Number of User Accounts

Small (less than 25)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 6 of 36

Application Name: Confidential Financial Disclosure Tracking

CFDT

Office

OGC

Description Financial Disclosure System is used to maintain statistics data concerning the proper disclosure for each employee. Used by GLE. Application rewritten in Summer 2007.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Business Operations

Monthly Transaction Volume

Small: Less 100 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Low/Very Manageable

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture

SQL

Authentication

Security Classification Sensitive but Unclassified

COOP/DR Functionality Batched Weekly/Monthly DR/COOP content refresh

Number of User Accounts

Small (less than 25)

SDLC Stage Development

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio HR Applications

Tuesday, October 27, 2009 Page 7 of 36

Application Name: Consolidated Data Service Support/Market Room

MRK RM

Office Various

Description Provide technical support to senior executives and economists who use Reuters, Bloomberg and Haver (umbrella for separate projects)

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Analytical

Functional Category Specialized

Business Value Business Operations

Monthly Transaction Volume

Medium: 100-999 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Medium/Moderate Complexity

Annual Number of Releases

Operational Availability Requirements Standard 99.0 - 99.5% Availability with scheduled outages for maintenance

Software Data Service

Primary Data Mgmt Architecture Other

Authentication Password

Security Classification Unclassified

COOP/DR Functionality

Number of User Accounts

Small (less than 25)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio Information Content and Data Services

Tuesday, October 27, 2009 Page 8 of 36

Application Name: Cuba Travel and Licensing

CTAL

Office

OFAC

Description Tracking and licensing of people traveling to Cuba. The bulk of the application resides on the DO LAN. A portion is public facing and resides at Qwest.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code 40000

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Business Operations

Monthly Transaction Volume

Enterprise: Over 2000

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Significant/High Degree of Complexity

Annual Number of Releases Significant: 3 to 5 releases each with 3 to 6 changes with 2 to 4 entailing significant function features or upgrades

Operational Availability Requirements Standard 99.0 - 99.5% Availability with scheduled outages for maintenance

Software Custom Code

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Medium (26 to 199)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 9 of 36

Application Name: Document Capture Pilot

DCP

Office

OFAC

Description Automating the creation of electronic versions of correspondence for Licensing officers including fillable forms, scanning, barcodes, etc. for the Cuba Travel License project.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Document/Content Management

Business Value Business Operations

Monthly Transaction Volume

Medium: 100-999 Month

Year Implem or Rewritten

Size

Complexity

Significant/High Degree of Complexity

Annual Number of Releases

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software

COTS

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Small (less than 25)

SDLC Stage Development

Secondary Data Mgmt Architecture

SQL

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 10 of 36

Application Name: Electronic Wire Transfer Licenses

EWTL

Office

OFAC

Description Provide the DC Licensing staff with tools similar to CTAL's successful public facing licensing capabilities for the Miami office.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Document/Content Management

Business Value Business Operations

Monthly Transaction Volume

Medium: 100-999 Month

Year Implem or Rewritten

Size

Complexity

Significant/High Degree of Complexity

Annual Number of Releases

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software

COTS

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Small (less than 25)

SDLC Stage Development

Secondary Data Mgmt Architecture

SQL

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 11 of 36

Application Name: Employee Entry Exit

EEE

Office

ASM - HR

Description A browser-based system to automate the preparation and request for services for a new employee in DO and to automate the pre-exit clearance process for departing employees.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Business Operations

Monthly Transaction Volume

Small: Less 100 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Medium/Moderate Complexity

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture

SQL

Authentication Password

Security Classification Sensitive but Unclassified

COOP/DR Functionality Batched Weekly/Monthly DR/COOP content refresh

Number of User Accounts

Medium (26 to 199)

SDLC Stage

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio HR Applications

Tuesday, October 27, 2009 Page 12 of 36

Application Name: Enterprise Content Management for OFAC

ECM OFAC

Office

OFAC

Description Long-term project to assist OFAC in managing casework, correspondence, licenses, etc.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Document/Content Management

Business Value Business Operations

Monthly Transaction Volume

Medium: 100-999 Month

Year Implem or Rewritten

Size

Complexity

Medium/Moderate Complexity

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Standard 99.0 - 99.5% Availability with scheduled outages for maintenance

Software

COTS

Primary Data Mgmt Architecture

SQL

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Medium (26 to 199)

SDLC Stage Planning

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 13 of 36

Application Name: File Inventory System Hypertext

FISH

Office Tax Policy

Description The FISH system is a Visual Basic/ACCESS application that assists Tax Policy staff in tracking the contents of DVD disks containing information used to run the Tax Models.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Business Operations

Monthly Transaction Volume

Small: Less 100 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Low/Very Manageable

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture Access

Authentication

Security Classification Sensitive but Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Medium (26 to 199)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio Domestic, Tax, and International Fiscal Poli

Tuesday, October 27, 2009 Page 14 of 36

Application Name: Financial Analysis and Reporting System (FARS)

FARS

Office

DCFO

Description FARS represents the umbrella of DCFO financial management applications. Includes TIER, CFO Vision, JAMES, and PRS. These fours applications are listed separate, thus no details listed in this profile.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Analytical

Functional Category Tracking/Rptg

Business Value Business Operations

Monthly Transaction Volume

Year Implem or Rewritten

Size

Large Over $500K Complexity

Significant/High Degree of Complexity

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Standard 99.0 - 99.5% Availability with scheduled outages for maintenance

Software

Primary Data Mgmt Architecture

Authentication

Security Classification Sensitive but Unclassified

COOP/DR Functionality Batched Weekly/Monthly DR/COOP content refresh

Number of User Accounts

Medium (26 to 199)

SDLC Stage Retired

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 15 of 36

Application Name: FOIA Case Management System for OFAC

OFAC/FOIA

Office

OFAC

Description Develop a FOIA case management system for OFAC

FISMA Major

Data Elements

Number Of Programs

Lines Of Code 50000

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Statutory

Business Value Business Operations

Monthly Transaction Volume

Small: Less 100 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Low/Very Manageable

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Small (less than 25)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 16 of 36

Application Name: Foreign Assets Control Database

FACDB

Office

OFAC

Description The FACDB system is OFAC’s primary document tracking and license management system. Most correspondence that is delivered to OFAC is logged into the FACDB system. The system tracks blocked assets, controlled correspondence, case management, and licensing.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

300000

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Statutory

Business Value Business Operations

Monthly Transaction Volume

Enterprise: Over 2000

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Medium/Moderate Complexity

Annual Number of Releases Significant: 3 to 5 releases each with 3 to 6 changes with 2 to 4 entailing significant function features or upgrades

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Large(200 to 500)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 17 of 36

Application Name: Freedom of Information Act

FOIA

Office ASM - Disclosure Services

Description This system tracks FOIA requests and produces statistical reports. (ACCESS)

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Administrative/General Suppor

Monthly Transaction Volume

Small: Less 100 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Low/Very Manageable

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture

SQL

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Small (less than 25)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 18 of 36

Application Name: Integrated Administration Module for OFAC Applications

IAM

Office

OFAC

Description A centralized tool to be used by selected OFAC staff to administer access rights and roles for users. This tool will be implemented across all OFAC applications with the exception of the Call Center.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Specialized

Business Value Administrative/General Suppor

Monthly Transaction Volume

Medium: 100-999 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Medium/Moderate Complexity

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Standard 99.0 - 99.5% Availability with scheduled outages for maintenance

Software Custom Code

Primary Data Mgmt Architecture

Authentication

Security Classification Sensitive but Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Medium (26 to 199)

SDLC Stage Planning

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 19 of 36

Application Name: Joint Audit Management Enterprise System

JAMES

Office

DCFO

Description The JAMES system tracks audits done at any bureau or at the headquarters level. Currently over 300 open audits or remedial action plans are being tracked, containing almost individual 1000 Planned Corrective Actions (PCA) being carried out throughout the department.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code 72000

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Mission Critical/High Value

Monthly Transaction Volume

Large: 1000-1999 Month

Year Implem or Rewritten

Size

Medium $100K - $499 Complexity

Significant/High Degree of Complexity

Annual Number of Releases Moderate: 3 to 4 releases each with 3 to 5 changes ranging from simple to more complex

Operational Availability Requirements Standard 99.0 - 99.5% Availability with scheduled outages for maintenance

Software Custom Code

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Sensitive but Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Medium (26 to 199)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 20 of 36

Application Name: Joint Operations

JOPS

Office

TEOAF

Description Joint Operations will manage obligations and invoices for asset forfeitures conducted by Federal, State and Local enforcement entities. TSAS-dependent. July 2007 - went operational

FISMA Major

Data Elements

Number Of Programs

Lines Of Code 50000

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Workflow

Business Value Business Operations

Monthly Transaction Volume

Medium: 100-999 Month

Year Implem or Rewritten

Size

Medium $100K - $499 Complexity

Significant/High Degree of Complexity

Annual Number of Releases Significant: 3 to 5 releases each with 3 to 6 changes with 2 to 4 entailing significant function features or upgrades

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture

SQL

Authentication PKI/Token

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Large(200 to 500)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 21 of 36

Application Name: Library Acquisition (eSubscription) eSub

Office ASM - Facilities - Library

Description Acquisition tracking for Main Treasury library subscriptions and budget.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Business Operations

Monthly Transaction Volume

Small: Less 100 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Medium/Moderate Complexity

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture

SQL

Authentication Password

Security Classification Unclassified

COOP/DR Functionality None

Number of User Accounts

Small (less than 25)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 22 of 36

Application Name: Long Term Proforma

ProForma

Office Dom Fin

Description ProForma is a custom tool which performs complex modeling and analysis of long term Treasury debt financing scenarios. Used by Office of Debt Management (ODM)

FISMA Major

Data Elements

Number Of Programs

Lines Of Code 30000

Application Categorization

Application Metrics

Application Architecture

Application Type Analytical

Functional Category Specialized

Business Value Mission Critical/High Value

Monthly Transaction Volume

Medium: 100-999 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Significant/High Degree of Complexity

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements High (99.5 - 99.9% or greater availability 365 Days less than 5 hours down time per month)

Software Custom Code

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Sensitive but Unclassified

COOP/DR Functionality None

Number of User Accounts

Small (less than 25)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 23 of 36

Application Name: OFAC Business Intelligence Pilot

OFAC/BI

Office

OFAC

Description Provide BI for SDN application using Oracle Discoverer.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Analytical

Functional Category Data Warehouse/BI

Business Value Business Operations

Monthly Transaction Volume

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Medium/Moderate Complexity

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Standard 99.0 - 99.5% Availability with scheduled outages for maintenance

Software

COTS

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Sensitive but Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Small (less than 25)

SDLC Stage Development

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 24 of 36

Application Name: Performance Reporting System

PRS

Office

ASM - DASMB - OPB

Description Repository of Treasury GPRA performance measures and fiscal target data. (ORACLE). Part of the FARS Umbrella.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code 91000

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Mission Critical/High Value

Monthly Transaction Volume

Large: 1000-1999 Month

Year Implem or Rewritten

Size

Medium $100K - $499 Complexity

Medium/Moderate Complexity

Annual Number of Releases Small: 2 to 3 releases each with between 2 & 5 simple changes

Operational Availability Requirements Standard 99.0 - 99.5% Availability with scheduled outages for maintenance

Software Custom Code

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Sensitive but Unclassified

COOP/DR Functionality Batched Weekly/Monthly DR/COOP content refresh

Number of User Accounts

Medium (26 to 199)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 25 of 36

Application Name: Safety Health Information Management System

SHIMS

Office ASM - Safety

Description A centralized reporting and tracking of accidents and safety incidents for all Treasury Bureaus

FISMA Major

Data Elements

Number Of Programs

Lines Of Code 60000

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Business Operations

Monthly Transaction Volume

Medium: 100-999 Month

Year Implem or Rewritten

Size

Large Over $500K Complexity

Medium/Moderate Complexity

Annual Number of Releases Significant: 3 to 5 releases each with 3 to 6 changes with 2 to 4 entailing significant function features or upgrades

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture

SQL

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Medium (26 to 199)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 26 of 36

Application Name: SAS/CFO Vision

CFOVision

Office

DCFO

Description Analytical front end for the Treasury Information Repository (TIER), the centralized repository of financial data from all Treasury bureaus. Multi-dimensional database of financial and budgetary data used to prepare departmental consolidated financial statements.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Analytical

Functional Category Tracking/Rptg

Business Value Mission Critical/High Value

Monthly Transaction Volume

Enterprise: Over 2000

Year Implem or Rewritten

Size

Medium $100K - $499 Complexity

Significant/High Degree of Complexity

Annual Number of Releases Moderate: 3 to 4 releases each with 3 to 5 changes ranging from simple to more complex

Operational Availability Requirements Standard 99.0 - 99.5% Availability with scheduled outages for maintenance

Software

COTS

Primary Data Mgmt Architecture Other

Authentication Password

Security Classification Sensitive but Unclassified

COOP/DR Functionality Batched Weekly/Monthly DR/COOP content refresh

Number of User Accounts

Medium (26 to 199)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 27 of 36

Application Name: Securities Management and Retrieval Technology

SMART

Office Dom Fin

Description This system tracks all information about Treasury marketable securities and produces data to generate the Treasury Yield Curve. Also calculates interest costs, debt outstanding and other financial measures associated with future Treasury auctions. Used by Office of Debt Management (ODM)

FISMA Major

Data Elements

Number Of Programs

Lines Of Code 20000

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Statutory

Business Value Mission Critical/High Value

Monthly Transaction Volume

Medium: 100-999 Month

Year Implem or Rewritten

Size

Large Over $500K Complexity

Significant/High Degree of Complexity

Annual Number of Releases Significant: 3 to 5 releases each with 3 to 6 changes with 2 to 4 entailing significant function features or upgrades

Operational Availability Requirements High (99.5 - 99.9% or greater availability 365 Days less than 5 hours down time per month)

Software Custom Code

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Sensitive but Unclassified

COOP/DR Functionality Batched Weekly/Monthly DR/COOP content refresh

Number of User Accounts

Small (less than 25)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 28 of 36

Application Name: Service Provider Regulatory Program

SPRP

Office

OFAC

Description Provides a secure data warehouse and data entry and analysis tool to track Service Providers that send funds to Cuba.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

210000

Application Categorization

Application Metrics

Application Architecture

Application Type Analytical

Functional Category Data Warehouse/BI

Business Value Business Operations

Monthly Transaction Volume

Small: Less 100 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Medium/Moderate Complexity

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Small (less than 25)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 29 of 36

Application Name: Small Business Review System

SBRS

Office

ASM-OSDBU

Description Enable Office of Small and Disadvantaged Business contracting officers to submit, review, approve, and tracking Small Business Review Forms electronically.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Collaborative

Functional Category Workflow

Business Value Business Operations

Monthly Transaction Volume

Small: Less 100 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Low/Very Manageable

Annual Number of Releases Small: 2 to 3 releases each with between 2 & 5 simple changes

Operational Availability Requirements Standard 99.0 - 99.5% Availability with scheduled outages for maintenance

Software Custom Code

Primary Data Mgmt Architecture

SQL

Authentication Password

Security Classification Sensitive but Unclassified

COOP/DR Functionality None

Number of User Accounts

Large(200 to 500)

SDLC Stage Pilot

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 30 of 36

Application Name: Source Data Aggregation

DDP

Office International Affairs

Description IA obtains economic data from a variety of government, international, and commercial services. Desire is to create a central repository within DO LAN environment to house multiple generations of these variousdatasets for recurring an ad hoc professional staff analysis. IA seeks a 4 to 5 phased effort to create an "integrated data store". Phase I is to simply establish a consolidated repository for this source data in its native format. This is a World Bank application that Treasury is trying to leverage and install for its use.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Collaborative

Functional Category Data Warehouse/BI

Business Value Business Operations

Monthly Transaction Volume

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Medium/Moderate Complexity

Annual Number of Releases Small: 2 to 3 releases each with between 2 & 5 simple changes

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture Other

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Small (less than 25)

SDLC Stage Development

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 31 of 36

Application Name: Specially Designated Nationals

SDN

Office

OFAC

Description Specially Designated Nationals - list of individuals whose transactions must be monitored or blocked by financial institutions. SDN database is used by ABaRRS, Blocked Assets and the OFAC staff as well as the public.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code 20000

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Business Operations

Monthly Transaction Volume

Medium: 100-999 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Significant/High Degree of Complexity

Annual Number of Releases Significant: 3 to 5 releases each with 3 to 6 changes with 2 to 4 entailing significant function features or upgrades

Operational Availability Requirements High (99.5 - 99.9% or greater availability 365 Days less than 5 hours down time per month)

Software Custom Code

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Medium (26 to 199)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 32 of 36

Application Name: TECHLIB

TECHLIB

Office ASM - Facilities - Library

Description Provides cataloging and acquisition information for the library. (Techlib, Basis)

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Tracking/Rptg

Business Value Business Operations

Monthly Transaction Volume

Small: Less 100 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Medium/Moderate Complexity

Annual Number of Releases Small: 2 to 3 releases each with between 2 & 5 simple changes

Operational Availability Requirements Standard 99.0 - 99.5% Availability with scheduled outages for maintenance

Software

COTS

Primary Data Mgmt Architecture Other

Authentication Password

Security Classification Sensitive but Unclassified

COOP/DR Functionality None

Number of User Accounts

Small (less than 25)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 33 of 36

Application Name: Treasury Assignment and Correspondence Tracking

TACT

Office Exec Sec

Description Executive correspondence tracking system (imaging, workflow, search and retrieval).

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

140000

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Workflow

Business Value Mission Critical/High Value

Monthly Transaction Volume

Enterprise: Over 2000

Year Implem or Rewritten

Size

Large Over $500K Complexity

Significant/High Degree of Complexity

Annual Number of Releases Small: 2 to 3 releases each with between 2 & 5 simple changes

Operational Availability Requirements High (99.5 - 99.9% or greater availability 365 Days less than 5 hours down time per month)

Software Custom Code

Primary Data Mgmt Architecture

SQL

Authentication Password

Security Classification Unclassified

COOP/DR Functionality None

Number of User Accounts

Large(200 to 500)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio Document Management and Collaboration

Tuesday, October 27, 2009 Page 34 of 36

Application Name: Treasury Information Executive Repository

TIER

Office

DCFO

Description TIER is the Treasury Department's official financial system of records. Data is submitted by the bureaus. Trillions of dollars in assets and liabilities are tracked.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

275000

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Data Warehouse/BI

Business Value Mission Critical/High Value

Monthly Transaction Volume

Enterprise: Over 2000

Year Implem or Rewritten

Size

Medium $100K - $499 Complexity

Significant/High Degree of Complexity

Annual Number of Releases Moderate: 3 to 4 releases each with 3 to 5 changes ranging from simple to more complex

Operational Availability Requirements Standard 99.0 - 99.5% Availability with scheduled outages for maintenance

Software Custom Code

Primary Data Mgmt Architecture Oracle

Authentication Password

Security Classification Sensitive but Unclassified

COOP/DR Functionality Batched Weekly/Monthly DR/COOP content refresh

Number of User Accounts

Medium (26 to 199)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 35 of 36

Application Name: Treasury Orders and DO Directives System

TODDS

Office ASM - Info Resource

Description System to draft and approve Treasury Orders/Directives and DO Directives - Phase 1 Completed in 2007. Summer 2007 -development of Phases 2 and 3 initiated.

FISMA Major

Data Elements

Number Of Programs

Lines Of Code

Application Categorization

Application Metrics

Application Architecture

Application Type Transactional

Functional Category Workflow

Business Value Business Operations

Monthly Transaction Volume

Small: Less 100 Month

Year Implem or Rewritten

Size

Small $100-$99K Complexity

Low/Very Manageable

Annual Number of Releases Limited: 1-2 each with less than 3 discrete functional changes/fixes

Operational Availability Requirements Basic 95 - 99.0% during EST business hours

Software Custom Code

Primary Data Mgmt Architecture

SQL

Authentication Password

Security Classification Unclassified

COOP/DR Functionality Planned/Unfunded

Number of User Accounts

Small (less than 25)

SDLC Stage Operational

Secondary Data Mgmt Architecture

MS OS - DO LAN

MS OS - Cyber Cente

Vax Alpha - DO Other

Sun - Cyber Center

Operating System - Environment Primary Application Languages

Visual Basic .Net C# Java

ASP Perl Script Cobol

VBAFortran PL*SQL

T*SQL OtherJavaScript

Portfolio

Tuesday, October 27, 2009 Page 36 of 36

Applications Inventory

Page No.

Apps Acronym Project Name Office Portfolio

O&M Level Code Status Server Type Client SW Description

1 ALERTS Administrative, Legislative Executive Request Tracking System

OGC General DO Administrative Systems

I Operational Client Server VB6 Runtime (Install Pkg on G drive), SQLserver Client V6.5-needs CD Burn, Outlook 2000 -email, Word 2000

Tracking system of requests for comments on pending legislation

2 AM Asset Management ASM - OAM AS Management Enterprise Systems

III Planning WEB ASM-OAM project is on "hold"

3 ABARRS Automated Blocking and Reject Reporting System

OFAC Terrorism Finance and Asset Control

III Operational WEB Internet Explorer Tracks all blocked transactions from financial institutions. Primary application resides on DO LAN, a portion of the public facing application resides at Qwest and is dependent on TSAS.

4 BA Blocked Assets OFAC Terrorism Finance and Asset Control

II Operational WEB Annual reporting of blocked assets by financial institutions. Closely related to ABaRRS which monitors continuous reported of blocked financial transactions.

5 SHIMS-BI Business Intelligence Tool

Treasury-wide

AS Management Enterprise Systems

III Operational WEB Business intelligence solution for Safety (SHIMS)

6 CMMS Case Matters Management System

OGC General DO Administrative Systems

I Operational Client Server Access97 migrating to Access2000

This is a business application that accounts, documents, tracks and reports on the pending, active and closed legal cases being handled by the Associate General Counsel for General Law and Ethics (GLE).

7 CFDT Confidential Financial Disclosure Tracking

OGC HR Applications I Operational ClientServer SQL*Server, VB6 Financial Disclosure System is used to maintain statistics data concerning the proper disclosure for each employee. Used by GLE. Application rewritten in Summer 2007.

8 MRK RM Consolidated Data Service Support/Market Room

Various Information Content and Data Services

I Operational WEB Provide technical support to senior executives and economists who use Reuters, Bloomberg and Haver (umbrella for separate projects)

9 CTAL Cuba Travel and OFAC Terrorism Finance and Asset III Operational WEB Internet Explorer Tracking and licensing of people traveling to9 CTAL Cuba Travel and Licensing

OFAC Terrorism Finance and Asset Control

III Operational WEB Internet Explorer Tracking and licensing of people traveling to Cuba. The bulk of the application resides on the DO LAN. A portion is public facing and resides at Qwest.

10 DCP Document Capture Pilot OFAC Terrorism Finance and Asset Control

I Operational WEB Automating the creation of electronic versions of correspondence for Licensing officers including fillable forms, scanning, barcodes, etc.