Attachment 6 - CEFMS_Interfaces dated 07FEB2022.pdf

Interfaces

FOR

CORPS OF ENGINEERS FINANCIAL MANAGEMENT

SYSTEM (CEFMS)

US Army Corps of Engineers ®

February 2022

Controlled Unclassified Information (CUI)

DISTRIBUTION IS LIMITED TO U.S. GOVERNMENT AGENCIES AND THEIR CONTRACTORS.OTHER

REQUESTS FOR THIS DOCUMENT MUST BE REFERRED TO: CEFC-S.

CONTROLLED UNCLASSIFIED INFORMATION (CUI)

CEFMS INTERFACES

NOTICE OF CHANGES

Date

Location in Document

Type

(P=Pen & Ink, I=Insertion, R=Replace ment)

Description

Author

1/07/2008 NA NA Initial revision Doug Stalnaker 2/17/2009 Notice Of Changes I added change log Doug Stalnaker 2/17/2009 Application Interfaces R Removed paragraph about

PROMIS

Doug Stalnaker

2/17/2009 Application Interfaces I Updated information regarding the STAR System interface

Doug Stalnaker

2/27/2009 Application Interfaces R Removed 2 systems, relocated 1 to another section; minor updates to system descriptions

Doug Stalnaker

2/27/2009 Integrated Applications I Added ATMP Doug Stalnaker 1/26/2010 NA NA DOC REVIEWED Doug Stalnaker 11/08/2010 Application Interfaces R Removed AIPMS;

reformatted into DoD/Other and USACE; removed bullets, added numbering

Doug Stalnaker

1/26/2012 Integrated Applications R Moved REMIS to 'External Application Interfaces -

USACE'

Doug Stalnaker

1/26/2012 External Application Interfaces - USACE

R Changed WinIATS to IATS Doug Stalnaker

1/30/2013 Integrated Application Interfaces

R Removed VIMS Doug Stalnaker

1/30/2013 External Application Interfaces – DoD/Other Government

R Added information regarding SAM replacement for STAR.

Doug Stalnaker

2/1/2013 Title Page R Replaced Pete Brown with Sheila Smith

D. Stalnaker

10/25/2013 (throughout) I,R New document format and additions to content.

D. Stalnaker

5/29/2014 Application Interfaces I, R Change OMBIL to CWBI and update description.

D. Stalnaker

2/9/2015 Application Interfaces IR Minor name changes to DCPS and ODS

D. Stalnaker

Ink, I=Insertion, 10/6/2015 (throughout) I, R Removed CEEMIS interface, added seven prior CEEMIS interfaces, and made corrections to APPMS, ODS, TMIS, and TOP interfaces

Sheila Smith

11/3/2015 Application Interfaces R Updated Standard Procurement System (SPS) to new name of Standard Procurement System (SPS)/ Procurement Desktop- Defense (PD2) and updated description

Sheila Smith

11/13/2015 Application Interfaces R Replaced all references to BEIS DCD with DCD/DCW

Sheila Smith

2/11/2016 (throughout) I, R Minor changes to formatting. Doug Stalnaker 2/11/2016 Title Page R Removed “artifact” from document title Doug Stalnaker

11/17/2016 Application Interfaces R Removed ATMP Doug Stalnaker 11/17/2016 Applicable Controls R Replaced DIACAP controls with RMF controls Doug Stalnaker

6/8/2017 Application Interfaces I Added iUOT interface Sheila Smith 7/27/2017 Application Interfaces R Updated DDRS Sheila Smith 2/13/2018 Application Interfaces I Added ERDC DW interface Sheila Smith 5/9/2018 Application Interfaces I Added AUD-IT interface Sheila Smith 7/20/2018 (throughout) Review for FISMA Annual

Security Review.

Doug Stalnaker

7/23/2018 Application Interfaces I Updated description for Incoming Data from PROMIS to CEFMS.

Doug Stalnaker

9/14/2018 Application Interfaces I Added ASP interface. D. Stalnaker 06/20/2019 (throughout) Annual review. D. Stalnaker 6/20/2019 Application Interfaces I, R Added ALD and DLA, removed APPMS, AUD-IT, and TMIS.

D. Stalnaker

6/20/2019 All Sections I Added numbering to headings.

6/28/2019 2. Application Interfaces R Removed ALD. D. Stalnaker

Ink, I=Insertion, 3/19/2020 2. Application Interfaces R Removed CWBI. D. Stalnaker 3/19/2020 2. Application Interfaces I Added ALD. D. Stalnaker 8/11/2020 2. Application Interfaces R Name change, replaced

DRCED with ADVANA.

D. Stalnaker

8/11/2020 2. Application Interfaces I Added CIO/G-6 ServiceNow. D. Stalnaker 8/25/2020 2. Application Interfaces I Added CHRA and TMIS. D. Stalnaker 2/8/2021 (throughout) Annual review for FISMA. D. Stalnaker 2/8/2021 2. Application Interfaces I Added ACWS, DLA, re-ordered.

D. Stalnaker

2/24/2021 2. Application Interfaces R Name change; replaced ALD with AV (Army Vantage)

D. Stalnaker

2/7/2022 (throughout) Annual review for FISMA. D. Stalnaker 2/7/2022 2. Application Interfaces R Remove ASP as it is now part of SNOW.

1. Introduction Connections between CEFMS and external systems, whether internal or external to USACE, provide a means of entry and access to system data that must be protected as per DoDI 8500.2.

Application Interfaces with CEFMS occur when:

1. An external Application Program Interface (API) connects directly to CEFMS for the purpose of adding, modifying, or deleting data in one or both applications. This data can be exchanged unilaterally or bi-directionally.

2. A file is exchanged between CEFMS and an API that adds, modifies, or deletes data in one or both applications

3. An application uses objects (possibly shared) located in the same database instance and interfaces with CEFMS through an API.

In addition to Application Interfaces, users from Corp Headquarters, Districts, Divisions, Labs, Centers, and Contractor personnel interface with CEFMS to retrieve data. These are termed User Interfaces and considered a part of the CEFMS product, therefore not requiring documentation in this artifact.

2. Applicable Controls The following table lists the NIST Special Publication 800-53, Revision 4 Controls satisfied by this artifact.

Control CCI#

AC-4.2 001414

AC-4.4 001549

AC-4.6 001551

AC-20.1 000093

AC-20.2 002332

AC-20(1).5 002337

AC-21.1 000098

AC-21.2 001470

AC-21.3 001471

AC-21.4 001472

CA-3.1 000257

CA-3.2 000258

CA-3.3 000259

CA-3.4 000260

CA-3.5 002083

CA-3(1).1 000262

CA-9.2 002102

CA-9.3 002103

Control CCI#

CA-9.4 002104

CA-9.5 002105

UL-2.2 003590

UL-2.3 003591

3. Application Interfaces CEFMS interfaces with 30 systems (see table below) via various connection methods.

Each external application is managed and operated independently of CEFMS and requires its own Authority To Operate (ATO), Certificate Of Networthiness (CoN), and Memorandum of Agreement

(MOA).

System Acronym Description I/O Method Advancing Analytics

Advana is a single authoritative repository for DoD data, to provide DoD leaders greater insights into auditability, business operations, performance, and readiness. Advana provides a shared data and analytic environment to accelerate analytics by automating data capture, integration cleansing, and standardizing DoD common enterprise data.

ADVANA

(formerly DRCED and

AUD-IT)

Outgoing monthly transfer of two accumulated history detail transaction data files (CEFMS Transaction Registers, CEFMS FDM Transaction Register) as well as summarized Trial Balance data files.

O Pre-defined, structured data files

Army Contract Writing System

ACWS is the Army's single, next-generation, enterprise-wide contract writing, management, execution, and close-out software system. ACWS will replace SPS, PADDS, and VCE, facilitate the standardization of Army Procurement business processes and streamline the integration with Army Enterprise Resource Planning systems.

ACWS Outgoing transfer of contract funding data;

Incoming transfer of contract funding data

I/O Pre-defined, structured data files

Army Vantage

Army Vantage ingests, stores, and processes a variety of Business System Data from across the Army enterprise, including both NIPR and SIPR data regarding Personnel, Readiness, Equipment, Acquisitions, etc.

AV Outgoing monthly transfer of 021 and 097 Transactions data, 021 FDM Transactions data, 021 Civil Labor Hours, and General Ledger Trial Balance for 021 and 097. Data accessed via the same files sent to iUoT described below.

O Pre-defined, structured data files

Civilian Human Resources Agency

CHRA Incoming employee master personnel records from HQACPERS.

I Email

HQACPERS provides dynamic and static data concerning Army Civilian Personnel. It includes strength accounting, employment, special employment, training, awards, performance data, and acquisition data.

CHRA maintains the system.

Defense Check Reconciliation Module

DCRM is the management control and reporting system for U.S. Treasury checks issued by the DoD, for direct submission of the check issue detail to the Department of the Treasury.

DCRM Outgoing transfer of Level 8 Check Issuance Reporting of check number and amount to Treasury

O Pre-defined, structured data file

Defense Civilian Pay System

The DCPS program mission is to process payroll for DoD and non-DoD civilian employees in accordance with existing regulatory, statutory, and financial information requirements relating to civilian pay entitlements and applicable policies and procedures.

DCPS Outgoing transfer of T&A Payroll data;

Incoming transfer of Gross Pay Reconciliation Extract, Accrued Leave Liability Extract, MER Employee Record Extract, MER Employee Leave Accrual Extract

I/O Pre-defined, structured data file

Defense Corporate Database / Defense Corporate Warehouse

The DCD is the middle-ware to interface, standardize and share data between financial systems and provide supplemental functionality to support migratory initiatives. DCD helps eliminate multiple non-standard interfaces between migratory and legacy systems. It provides the capability to convert, normalize and summarize disparate financial data from multiple systems. All transactions received by the DCD are subsequently migrated over to the DCW on a daily basis. The DCW can provide query and reporting capability for users in a central repository of information. DCD and DCW are web-based and menu driven.

DCD /

DCW

Outgoing transfer of Property, Plant and Equipment Transactions monthly and General Fund Commitments, Obligations, Accruals and Disbursements data daily for each FOC

O Pre-defined, structured data files

Defense Departmental Reporting System

DDRS-Budgetary module is a DoD application that facilitates the

DDRS Outgoing daily and monthly Integrated Command Accounting and Reporting (ICAR) data and monthly General Ledger Trial Balance data

O Pre-defined, structured data files preparation of the DoD monthly budgetary financial departmental reports and their respective audit trails.

Defense Logistics Agency

Defense Logistics Agency manages the global supply chain – from raw materials to end user to disposition – for the Army, Marine Corps, Navy, Air Force, Space Force, Coast Guard, 11 combatant commands, other federal agencies, and partner and allied nations.

DLA Outgoing transfer of Funding Authorization Document (FADS) data for the Enterprise Funds Distribution and Purchase Request and Commitment (PR&C) data for the Army Contract Writing System;

Incoming transfer of Funding Authorization Document (FADS) data from the Enterprise Funds Distribution system; contact obligation data from the Army Contract Writing System.

I/O Pre-defined, data files

Departmental Cash Management System

DCMS is a legacy system implemented in 1959 with enhancement in November 1995. The primary goal for DCMS is to manage, reconcile, and report all Air Force cash disbursements, reimbursement, and collections and receipts department-wide. It consolidates all appropriations and accounting classification elements used by all services within a single validation system.

DCMS-Merged Accountability and Fund Reporting (MAFR) is a mainframe module of DCMS. It controls and consolidates all payments and collections data of Air Force Funds. It ensures reporting and accountable activities records agree with distribution of funds to DOD and to report all funds at the level of detail prescribed by the Office Of Management and Budget (OMB), Treasury, and DOD. This interface pertains to DCMS-MAFR via DCMS- DCMS-DCMS File Inventory (DCMS-

DFI).

DCMS Outgoing monthly Air Force department level Disbursing file containing disbursement data by Fiscal month and year to DCMS-MAFR via DCMS-DFI

O Pre-defined, structured data file

Engineer Research and Development Center (ERDC) Data Warehouse

ERDC DW is a single information system to be used by ERDC as an upward

ERDC DW Outgoing transfer of financial data from the U4 CEFMS database

O Direct Data Transfer, database to database reporting tool that retrieves data from CEFMS and other systems.

Engineers Link Interactive

ENGLink provides the framework for processing information and performing command and control to U.S. Army Corps of Engineers (USACE) elements responding to civil and military contingencies.

ENGLINK Outgoing transfer of Personnel data O Direct Data Transfer, database to database

Enterprise Data Warehouse

The EDW is the CIO lead program to provide a central repository of core USACE data.

EDW Outgoing transfer of data to support data warehouse creation and ad-hoc reporting at all levels

O Direct Data Transfer, database to database

Facilities and Equipment Maintenance

The FEM system provides Corps activities with a tracking and control system for the management of facility and equipment maintenance, equipment calibration, equipment maintenance contracts, inventory control, asset costs, preventive and corrective maintenance, and capacity data. FEM automates the management of maintenance of materiel and the real property infrastructure for civil funded facilities.

FEM Outgoing transfer of Asset and Property data;

Incoming transfer of Purchase Request data

I/O Direct Data Transfer, database to database

Formerly Used Defense Sites Management Information System

FUDSMIS is the single information system to be used by HQUSACE, division and districts to manage and execute the Formerly Used Defense Sites (FUDS) Program.

FUDSMIS Outgoing transfer of funding data, including allocations, commitments, obligations, and expenditures for FUDS projects

O Direct Data Transfer, database to database

General Accounting & Finance System Datamart

GAFS-DM is an Oracle based Datamart and three associated applications that extend the capabilities of the core accounting systems that are used by DFAS to manage, account for, and report status of funds allocated to the United States Air Force. The purpose of the

GAFS-DM Outgoing transfer of two files monthly containing Air Force financial data. File one contains data from OAC 77 in D…B…T (DBT) format, and file two contains Supporting voucher level detail for the AF7801 report.

O Pre-defined, data files

GAFS-DM is to provide a single source of transaction-level accounting data for the Air Force General Funds and summary-level data for Working Capital Funds (WCF) accounting transaction-level data, and to enable the Air Force to produce transaction-driven financial working papers.

Headquarters Accounting and Reporting System

HQARS is a departmental level financial reporting system for receiving, validating consolidating budget execution, expenditure and general ledger data from field accounting offices.

HQARS Outgoing transfer of 302, 304, 218, 112, Schedule 9, IBOP and the General Ledger data to be uploaded into HQARS monthly data file

Integrated Automated Travel System

IATS is the financial management software serving as the primary Department of Defense (DOD) travel claim processing system. The IATS performs all processing from initiating the account record through disbursement.

IATS interfaces with other DOD accounting and disbursing systems to provide accurate travel claim documentation and travel record information. IATS also interfaces with DoD payroll systems.

IATS Outgoing transfer of detailed voucher

Incoming transfer of settlement amount due

I/O Pre-defined, structured data file

Interim Universe of Transactions (iUoT) Environment

The Interim Universe of Transactions (iUoT) is a short-term audit-support solution to provide the following capabilities while the long term, SAP HANA-based Universe of Transactions solution is being stood up:

iUoT Environment

Outgoing monthly transfer of 021 and 097 Transactions data, 021 FDM Transactions data, 021 Civil Labor Hours, and General Ledger Trial Balance for 021 and 097 data files

Operational Data Store

ODS gives DFAS and Army financial managers the ability to retrieve, review, update and store accounting/financial payment information. Database records are also used for extraction or compilation of data and reports for

ODS Outgoing transfer of ICAR and Daily Transactions data and transfer of voucher level transactions at full AMSCO/EOR level representing of all military transactions for Army Financial Management and DCAS efforts

O Direct Data Transfer, database to database;

Pre-defined, data file budget execution status and statistical analyses for use internally or externally as required by DoD or other government agencies.

Program Budget Accounting System - Funds Distribution

PBAS-FD was designed to be the funds distribution system for the Army, which includes all appropriations with a treasury index of 97 (TI-97).

PBAS-FD Incoming monthly TI-97 Army funding data

I Pre-defined, structured data file

Programs and Project Management Information System

PROMIS is the standard USACE-wide automated system for managing project execution in accordance with the Project Management Business Process (PMBP).

PROMIS Outgoing transfer of Employee, Organization, Resource and Budget Work Item data;

Incoming Project Work Item creation/deletion, Work Breakdown Structure deletion, P6 Task deletion, 2101 Schedule of Obligations and Expenditures.

I/O Direct Data Transfer, database to database

Real Estate Management Information System

REMIS provides a uniform, automated method of recording, storing, retrieving, and reporting information related to Real Property Assets and Outgrants for which the US Army Corps of Engineers are the owner and/or executive agent.

REMIS Outgoing transfer of User/Employee, Addressee, AMSCO, Appropriation, Asset, Collection, Debtor, County/State, Property, RGA, Work Item, Unit of Measure, and Work Management data;

Incoming Addressee, Property ID Codes, and Revenue Generating Agreements creation

I/O Direct Data Transfer, database to database

Rental Facilities Management Information System

RFMIS is the system of record for the all in-leasing activities of the U. S. Army Corps of Engineers Real Estate community. RFMIS supports the requirements to execute the mission by offering a web-based system that allows for the entering, modifying and tracking of all in-leasing data.

RFMIS Outgoing transfer of Addressee, Customer Order, Employee, Funding, General Ledger, Invoice Labor, Obligation, Payment, Receipt Voucher, Receiving Report, Revolving Fund, and Work Item data

O Direct Data Transfer, database to database.

Resident Management System

RMS is an automated construction management/quality assurance information system designed primarily for the daily requirements of USACE field construction personnel. Its primary features include capabilities to support construction planning, contract

RMS Outgoing transfer of Appropriation Data, Funding Accounts, Work Items, PRACs and PRAC line items, Obligation Line Items, Invoice and Invoice Line Items, Payment Receipts, Project Management Task Information;

I/O Direct Data Transfer, database administration, quality assurance, payments, correspondence, submittal management, safety and accident administration, modification processing, and management reporting.

Incoming transfer of ENG93 Header Information, Obligation Payment Information, and Obligation Withholding and Refund information

Shared Accounting Module - Department of the Treasury Financial Management Service

SAM is an application developed by the Federal Reserve Bank of St. Louis in conjunction with Financial Management Service (FMS). SAM's primary function is to assist Federal Program Agencies (FPA) in classifying transactions as they occur by validating or deriving Treasury Account Symbol (TAS) and Business Event Type Code (BETC) information.

SAM Incoming transfer of Agency Location and Department Codes

I Pre-defined, structured data file

ServiceNow - CIO/G-6

ServiceNow is the next generation platform in support of USACE IT Service Requests, Configuration Management Database (CMDB) management, reporting, and other IT functions.

SNOW Outgoing transfer of Property Book data, to include bar codes and transaction data

Incoming transfer of bar codes and inventory data

I/O Direct Data Transfer, database to database.

Standard Procurement System/ Procurement Desktop-Defense

The Standard Procurement System (SPS) Program is the cornerstone for the DoD's paperless acquisition initiative.

Procurement Desktop-Defense (PD2) provides automated strategic, streamlined contract management support for the procurement professional within a complete workflow management solution

SPS/PD2 Outgoing transfer of Purchase Request

Incoming transfer of Procurement data

I/O Pre-defined, structured data file

Training Management Information System

The USACE Learning Center’s (ULC) Training Management Information System (TMIS) is the automated system that enables the ULC to manage and implement the Proponent-Sponsored Engineer Corps Training (PROSPECT) Program. TMIS contains all PROSPECT Program management data including the registration, cataloging, scheduling, student evaluation and record keeping functions.

TMIS Incoming transfer of Training Session Course Schedule information

I Direct Data Transfer, database.

Treasury Offset Program

TOP is a system that maintains data about delinquent non-tax Federal debts and debts being collected by States that are eligible for offset and compares that data with information about Federal payments. Debts that are collected by States through offset of Federal payments include delinquent support obligations and nontax and tax debts owed to States.

TOP Outgoing transfer of Vendor Extract File containing the names and taxpayer identification numbers (TINs) of payment recipients

Incoming transfer of Vendor Match File containing indicator of payees who own delinquent debts eligible for collection by offset and or a Federal tax debt, collected by levy of contract payments, processed and disbursed by USACE

I/O Pre-defined, structured data file

4. Interfacing Process All system interfaces with CEFMS are fully documented in individual, signed Memorandums of Agreements (MOAs) based on a template derived from Appendices A and B of NIST 800-47 and maintained as part of the CEFMS IA catalog of documents in the CEFMS Team SharePoint archive.

Note: For USACE Systems, only properly accredited systems with an approved Core Investment Capabilities Document (CICD) and authorization from the Executive Functional Assessment Team (EFAT) to expend funds will be considered for interfacing.