J.4B_Attachment_04B.pdf

ID

Name of Bureau

Application or Interface Name

Interface Type

Detailed Description

Business Need /

Functional Impact

Frequency Source System

Target System

Complexity Interface Direction

Interface Mode

Level of Interface

Automation

Interface File Structure

Data Refining /

Translations

Interface

POC

Needed in Target DOT

ESC

Environment

Comments

A01 OS/OAM System for Award Management/Central Contractor/Federal Agency Registration

Acquisition Specific Interface

Primary supplier database for the U.S.

Federal government.

The CCR collects data from suppliers, validated and stored this data, and disseminated it to various government acquisition agencies.

Regulation - Vendors must be cleared using CCR prior to contract award.

Daily CCR/SAM C.Suite Medium In-Bound Batch Fully Flat Files Yes Gary Hill Yes

A02 OS/OAM FPDS-NG - Integrated Acquisition Environment/Federal Procurement Data System-Next Generation

Acquisition Specific Interface

The FPDS- NG is the current central repository of information on Federal contracting.

Regulation - Award data must be entered into

FPDS-NG

As Needed FPDS-NG C.Suite High Bi- Directional

Real Time

Fully XML/SOAP Yes Gary Hill Yes

A03 OS/OAM FAR Commerce Acquisition Clauses - Federal Acquisition Regulation/Commerce Acquisition Regulation Clauses

Acquisition Specific Interface

The Federal Acquisition Regulation (FAR) is the principal set of rules in the Federal Acquisition Regulation System. The Commerce Acquisition Regulation is the DOC supplement to the FAR.

Regulation - Rules must be included in awarded contracts.

As Needed OFPP/DOC C.Suite High In-Bound Batch Partially Flat Files Yes Gary Hill Yes

A04 NOAA FPDS-NG -

Integrated Acquisition Environment/Federal Procurement Data System-Next Generation

Acquisition Specific Interface

The FPDS- NG is the current central repository of information on Federal contracting. I guess you can keep this

- the interface is within the Csuite application

Regulation - Award data must be entered into

FPDS-NG

As Needed

FPDS-NG C.Suite High Bi- Directional

Real Time

Fully XML/SOAP Yes Yes

A05 NOAA FAR Commerce Acquisition Clauses - Federal Acquisition Regulation/Commerce Acquisition Regulation Clauses

Acquisition Specific Interface

The Federal Acquisition Regulation (FAR) is the principal set of rules in the Federal Acquisition Regulation System. The Commerce Acquisition Regulation is the DOC supplement to the FAR.

Regulation - Rules must be included in awarded contracts.

As Needed OFPP/DOC C.Suite High In-Bound Batch Partially Flat Files Yes Yes

A06 NOAA System for Award Management/Central Contractor/Federal Agency Registration

Acquisition Specific Interface

Primary supplier database for the U.S.

Federal government.

The CCR collects data from suppliers, validated and stored this data, and disseminated it to various government acquisition agencies.

Regulation - Vendors must be cleared using CCR prior to contract award.

Daily CCR/SAM C.Suite Medium In-Bound Batch Fully Flat Files Yes Yes

A07 NIST System for Award Management/Central Contractor/Federal Agency Registration

Acquisition Specific Interface

Primary supplier database for the U.S.

Federal government.

The CCR collects data from suppliers, validated and stored this data, and disseminated it to various government acquisition agencies.

Regulation - Vendors must be cleared using CCR prior to contract award.

Daily CCR/SAM C.Suite Medium In-Bound Batch Fully Flat Files Yes Gary Hill Yes

A08 NIST FPDS-NG - Integrated Acquisition Environment/Federal Procurement Data System-Next Generation

Acquisition Specific Interface

The FPDS- NG is the current central repository of information on Federal contracting. I guess you can keep this

- the interface is within the Csuite application

Regulation - Award data must be entered into

FPDS-NG

As Needed FPDS-NG C.Suite High Bi- Directional

Real Time

Fully XML/SOAP Yes Gary Hill Yes

A09 NIST FAR Commerce Acquisition Clauses - FAR Commerce Acquisition Clauses - Federal Acquisition Regulation/Commerce Acquisition Regulation Clauses

Acquisition Specific Interface

The Federal Acquisition Regulation (FAR) is the principal set of rules in the Federal Acquisition Regulation System. The Commerce Acquisition Regulation is the DOC supplement to the FAR.

Regulation - Rules must be included in awarded contracts.

As Needed OFPP/DOC C.Suite High In-Bound Batch Partially Flat Files Yes Gary Hill Yes

A10 Census System for Award Management/Central Contractor/Federal Agency Registration

Acquisition Specific Interface

Primary supplier database for the U.S.

Federal government.

The CCR collects data from suppliers, validated and stored this data, and disseminated it to various government acquisition agencies.

Regulation - Vendors must be cleared using CCR prior to contract award.

Daily CCR/SAM C.Suite Medium In-Bound Batch Fully Flat Files Yes Sharon Driggins

Yes

A11 Census FPDS-NG - Integrated Acquisition Environment/Federal Procurement Data System-Next Generation

Acquisition Specific Interface

The FPDS- NG is the current central repository of information on Federal contracting.

Regulation - Award data must be entered into

FPDS-NG

As Needed FPDS-NG C.Suite High Bi- Directional

Real Time

Fully XML/SOAP Yes Sharon Driggins

Yes

A12 Census FAR Commerce Acquisition Clauses - Federal Acquisition Regulation/Commerce Acquisition Regulation Clauses

Acquisition Specific Interface

The Federal Acquisition Regulation (FAR) is the principal set of rules in the Federal Acquisition Regulation System. The Commerce Acquisition Regulation is the DOC supplement to the FAR.

Regulation - Rules must be included in awarded contracts.

As Needed OFPP/DOC C.Suite High In-Bound Batch Partially Flat Files Yes Sharon Driggins

Yes

A13 NIST Storeroom Descriptions (Maximo)

- Maximo Storeroom Catalog Data File

Bureau Specific Interface

Maximo generates a file processed through informatica of storeroom inventory catalog descriptions that are then populated in

CSTARS

Provides descriptions of storeroom items within

CSTARTS

when used during ordering.

As Needed Maximo, Informatica

C.Suite Medium In-Bound Batch Partially Flat File Yes Yes

A14 NIST Vendor Data Maximo

- CSTARS Vendor Data into Maximo

Bureau Specific Interface

Vendors are populated in Maximo (daily) to assist in work order tracking process and the associated materials used to make up the work order.

Used to keep track of the vendors used to support a work order

Daily C.Suite Maximo Medium Out- Bound

Batch Partially Flat File Yes Application Systems Division

Yes

M01 NOAA NFC - Management Analysis and Reporting System (MARS) feed from the National finance Center (NFC)

Bureau Specific Interface

Focused queries that are run in NFC then sent to ASD.

MARS pulls data from ASD on a daily basis.

Operational reporting on data related to awards, union inquiries.

Also used for labor projections in

MARS.

Daily NFC MARS In Bound Mary Rieck TBD Will MARS functionality be included in the BAS Enterprise Data Warehouse (EDW) or one of the other

BAS

compoments?

M02 NOAA GSA Vehicle - Management Analysis and Reporting System (MARS) feed from the GSA Vehicle

Bureau Specific Interface

Direct Connection

TBD GSA Vehicle MARS In Bound Mary Rieck TBD GSA Vehicle = FedFMS?

Will MARS functionality be included in the BAS Enterprise Data Warehouse (EDW) or one of the other

BAS

compoments?

M03 NOAA Grants Online - Management Analysis and Reporting System (MARS) feed from Grants Online

Bureau Specific Interface

ETL pulls data from GOL on a nightly basis

Daily Grants Online

MARS In Bound Mary Rieck TBD Will MARS functionality be included in the BAS Enterprise Data Warehouse (EDW) or one of the other

BAS

compoments?

P01 NIST Census Excess Property File (to Oracle Fixed Assets)

Personal Property Specific Interface

Oracle Fixed Assets receives file from Census for Excess property

Required for tracking excess property.

NIST can receive excess property from other DOC bureaus

As Needed Census Sunflower Low In-Bound File Partially Flat File No Bill Turner Yes

P02 NIST HQ Excess Property - Excess property file & catalog property description file from DoC HQ Sunflower

Personal Property Specific Interface

Oracle Fixed Assets receives file from DoC's HQ on excess property AND DOC's Sunflower for excess property file, and catalog product description file.

Required for tracking excess property.

NIST can receive excess property from other DoC bureaus.

Oracle Fixed Assets needs the catalog property description item names to record the excess property items from SunFlower (DoC HQ)

As Needed Sunflower - DoC HQ

Sunflower Low In-Bound File Partially Flat File No Bill Turner Yes

P03 NOAA GSAXcess Personal Property Specific Interface

Sunflower GSAxcess Medium Out- Bound

Yes Larry Oats

(NOAA) /

Eric Smith (Census)

Yes

P04 NIST Central People Repository File (to Oracle Fixed Assets)

Other Sunflower also receives files containing updated

NIST

personnel (People), locations (Sites, Buildings, Rooms).

Personnel info is stored in Sunflower b/c each staff is assigned some aspect of NIST property (i.e., computer, laptop, cell phone, etc.)

The Central People Reposity (CPR) is a database maintained by NIST Applications Systems Division and contains data from the following sources:

NFC, Human Resources Arrival and Departure System

(HRADS)

NIST

Associate Information System

(NAIS), NIST-

Keep record of employees that leave/are new as they may be responsible for NIST owned government property

As Needed

CPR

Database

Sunflower Low In-Bound File Partially Flat File No Bill Turner Yes

P05 NIST GSA Excess Property File

Personal Property Specific Interface

Oracle Fixed Assets also sends a file to GSA for excess property

Sunflower GSA Out- Bound

File Flat file Yes Bill Turner Yes

P06 OS/OAM GSAXcess Personal Property Specific Interface

Sunflower GSAxcess Medium Out- Bound

Yes Andy Durant

Yes

P07 CENSUS Various Property Interfaces

Other (Describe in Comments)

Inventory data is received by the property system from other systems and sends data to other systems in order to facilitate the inventory needs of the Bureau tracks employees, including field reps to accountable property

Daily APMS Varies Low Out- Bound

Batch Fully data file No Yes We have requirements for the ability to look at property data as a snapshot in time as well as current inventory.

This capability still needs to exist.

Whether we need to the ability to load data from other systems will depend upon functionality in property systems

P08 NOAA Sunflower Property - Management Analysis and Reporting System (MARS) feed from NOAA Personal Property System (Sunflower)

Bureau Specific Interface

Personal Property data is pulled from Sunflower via reports and loaded into

MARS.

Personal Property data is combined with AP data from CBS to identify unreconciled personal property

TBD Sunflower MARS In Bound Mary Rieck TBD Not a direct connection.

Will MARS functionality be included in the BAS Enterprise Data Warehouse (EDW) or one of the other

BAS

compoments?

R01 NOAA GSA real property Real Property Specific Interface

Ability to interface with GSA real property system.

Monthly rent and DHS bill data imported from GSA's Rent on the Web system to DOC's Federal Real Property Management System in order to pay NOAA's bills due to GSA and DHS each month.

Data is critical to ability to pay NOAA's GSA rent bill.

NOAA has a small window of time between when rent bills are released and when we must pay them. The system must be able to import the bills and to allocate costs according to the multiple accounting codes within the FRPM system. The end result of the current process is a monthly file uploaded to CBS to send an IPAC to GSA paying NOAA's bill.

Monthly GSA Rent on the Web

Currently DOC's

Federal Real Property

Management System

(FRPM) but would be the new system.

Low In-Bound Batch Partially Flat file Yes Christine Beinhacker or John Albrecht

Yes Currently files downloaded from GSA ROW site are csv files - one for rent and one for DHS bills. RPMD changes commas to spaces and produces the files (see text files

10AP1300

and

13AG1300

attached to our e-mail) for import into

FRPM. FRPM

extracts all of the pricing data and sf from the file that is found on a GSA bill (see PDF file GSA and DHS Rent Bills for August 2013 attached to e-mail). In processing the import, FRPM does some analysis of the new data to produce reports that show changes from preious period (see Word Document GSA Rent Process using

FRPM) .

NOTE: RPMD

believes that the file could be downloaded as an Excel file which may be preferable.

Currently not downloaded as Excel because FRPM is configured for the text file.

R02 NOAA GSA/OMB Federal Real Property Inventory Profile Interface

Real Property Specific Interface

Annual file produced as an export for GSA/OMB's required Federal Real Property Profile.

Detailed specifications are issued each year by the Federal Real Property Council (see attached

FY13

Guidance for Real Property Inventory Reporting).

This is a mandatory reporting requirement to GSA/OMB and is enforced.

Annually Currently Federal Real

Property Management System but would need to be whatever system replaces

FRPM

GSA/OMB

Federal Real

Property Profile

Low Out- Bound

Batch Partially XML file in a format prescribed by GSA/OMB (see FY13 Guidance for Real Property Inventory Reporting at http://www.gsa.gov/portal/mediaId/178911/fileName/2013_Data_Dictionary_VERSION_2_912 as well as txt file FY2012 NOAA xml for FRPP)

Yes Chris Coneeney

Yes Report produced annually.

Normally DOC produces the XML file and runs it through the FRPP system which generates an error report.

We work to fix the errors within our FRPM system and then DOC and we repeat the process until they receive an error free report. The DOC runs the process and produces one report to

FRPP

covering all Department Agencies.

R03 NOAA NOAA Staff Directory Real Property Specific Interface

Data on personnel assigned by location to determine utilization rates.

Without the interface NOAA is not able to provide data DOC and other stakeholders utilization information.

Monthly NOAA Staff Directory

Current FRPM but would be the new system

Low In-Bound Batch Fully Excel Yes LaNetta McWilliams

Yes Data from the NOAA Staff Directory would have to be tied to a key identifier such as property ID.

R04 NOAA Real Property Deferred Maintenance and Repair System

Real Property Specific Interface

Previously a software program known as the Integrated Facilities Information Program

(IFIP)

software was used to develop NOAA's list of Real Property Deferred Maintenance projects and NOAA's repair backlog -required for

NOAA

financials and for the Federal Real Property Profile.

NOAA has not yet replaced IFIP but envisions that a replacement will be acquired or will need to be designed to capture this information.

Ideally BAS would incorporate this function and no interface would be needed.

NOAA is required to report on deferred maintenance and on its repair backlog as part of Circular A- 136 and to

GSA/OMB

under Executive Order 13327 Federal Real Property Asset Management for the Federal Real Property Profile. The deferred maintenance and repair interface would be needed in order to track and report on this information.

Annually TBD Currently FRPM but would be the new system

Low Bi- Directional

Batch Fully TBD Yes N/A Yes Data on properties in the Real Property Inventory, i.e.

Property ID, Address, Line Office, would need to be provided to the IFIP replacement software and data from the

IFIP

replacement software (property condition information and repair cost estimates) would need to be provided to or incorporated into the system that replaces

FRPM.

R05 OS/OAM GSA real property Real Property Specific Interface

Ability to interface with GSA real property system.

Monthly rent and DHS bill data imported from GSA's Rent on the Web system to DOC's Federal Real Property Management System in order to pay NOAA's bills due to GSA and DHS each month.

Data is critical to ability to pay GSA rent bill.

There is a small window of time between when rent bills are released and when we must pay them. The system must be able to import the bills and to allocate costs according to the multiple accounting codes within the FRPM system. The end result of the current process is a monthly file uploaded to CBS to send an IPAC to GSA paying DOC's bill.

Monthly GSA Rent on the Web

Currently DOC's

Federal Real Property

Management System

(FRPM) but would be the new system.

Low In-Bound Batch Partially Flat file Yes Andy Durant

Yes Currently files downloaded from GSA ROW site are csv files - one for rent and one for DHS bills. RPMD changes commas to spaces and produces the files (see text files

10AP1300

and

13AG1300

attached to our e-mail) for import into

FRPM. FRPM

extracts all of the pricing data and sf from the file that is found on a GSA bill (see PDF file GSA and DHS Rent Bills for August 2013 attached to e-mail). In processing the import, FRPM does some analysis of the new data to produce reports that show changes from preious period (see Word Document GSA Rent Process using FRPM)

. NOTE:

RPMD

believes that the file could be downloaded as an Excel file which may be preferable.

Currently not downloaded as Excel because FRPM is configured for the text file.

R06 OS/OAM GSA/OMB Federal Real Property Inventory Profile Interface

Real Property Specific Interface

Annual file produced as an export for GSA/OMB's required Federal Real Property Profile.

Detailed specifications are issued each year by the Federal Real Property Council (see attached

FY13

Guidance for Real Property Inventory Reporting).

This is a mandatory reporting requirement to GSA/OMB and is enforced.

Annually Currently Federal Real

Property Management System but would need to be whatever system replaces

FRPM

GSA/OMB

Federal Real

Property Profile

Low Out- Bound

Batch Partially XML file in a format prescribed by GSA/OMB (see FY13 Guidance for Real Property Inventory Reporting at http://www.gsa.gov/portal/mediaId/178911/fileName/2013_Data_Dictionary_VERSION_2_912 as well as txt file FY2012 NOAA xml for FRPP)

Yes Andy Durant

Yes Report produced annually.

Normally

DOC

produces the XML file and runs it through the FRPP system which generates an error report.

We work to fix the errors within our FRPM system and then DOC and we repeat the process until they receive an error free report. The DOC runs the process and produces one report to

FRPP

covering all Department Agencies.