J.4A_Attachment_04A.pdf

Line Number

Name of Bureau

Application or Interface Name

Interface Type

Detailed Description

1 All Hyperion Other (Describe in Comments)

Extract from all three CFS implementations of balance information in support of consolidated reporting using Hyperion.

2 CENSUS ATRAK - Generic Approval and

Tracking System

(ATRAK)

Bureau Specific Interface

Provides the ability for anything that needs an approval in CBS to be routed to the appropriate individuals for approval. This also provides the associated tracking of when things were approved and by whom.

3 CENSUS Bankcard (SP3) ACCS upload

APSI/ CSC

Interface

Automated FTP – Daily file from CBS to Citibank

4 CENSUS Budget/Maintenance Data

Bureau Specific Interface

Valid maintenance data needs to go to several systems, one example is Budgetary data for valid projects is created into files to send to T&A systems.

5 CENSUS C.Award ORSI CSC Interface

CACI provided COTTS product to award procurements - Daily (via Tibco)

6 CENSUS C.Request ORSI CSC Interface

CACI provided COTTS product to request procurement actions - Daily (via Tibco)

7 CENSUS CAMPIN -

Centralized

Application for Managing Personnel Investigations and

Non-employees

(CAMPIN)

Bureau Specific Interface

System that processes applicants and contractors for entrance and exist processes.

8 CENSUS CARMIN - Cost and Response

Management Network

Bureau Specific Interface

CARMN is a reporting application that provides expenditures (costs) related to field work (progress), providing average costs per unit of work, and survey performance data, which enable cost analysis and cost modeling resulting in informed cost management. CARMN is used to make management decisions that can immediately impact response rates and survey costs. CARMN integrates data from existing data systems to provide a source of timely cost and progress information related to field data-collection operations.

9 CENSUS CDFR / DW Bureau Specific Interface

Census Specific Financial reports showing data from various CBS modules and processes, such as General Ledger, Accounts Payable, Accounts Receivable, and Maintenance Data. Estimates and actuals for financial transactions , using limited by division, at the detailed and summary level go to various other systems at Census

10 CENSUS COBRA -

Consolidated

Budget Reporting and Analysis

Bureau Specific Interface

COBRA is a Hyperion based commercial-off-the-shelf (COTS) system in Budget division adapted for the preparation of Budget Operating Plans and other Budget support and reporting activities. Budget Operating Plans are interfaced to CFS via the COBRA Budget division custom interface which compiles COBRA data in formats required for interfacing through the CFS Standard Interface for Budget (formerly BUD002). A portion of the application is integrated with CFS to update CFS tables directly for project and task code.

11 CENSUS CPMS - Census Printing

Management System

Bureau Specific Interface

Monitors external printing procurements through the Government Printing Office (GPO) and other selected vendors – orders and change orders, receipts, IPAC disbursement classification and reconciliation. The system includes functionality that provides financial discipline in the printing area that cannot be accomplished within the CFS and procurement systems due to complexity. This is vitally important due to the high volumes and dollar amounts that occur during Decennial and special censuses. The orders portion is currently integrated with CFS but will be converted to interface through the Obligation and Requisition Standard Interface (ORSI ) when that interface becomes available in production; the receipts and invoice transactions are interfaced through the Standard Interface for Accounts Payable (SI-AP)

12 CENSUS CPMS - Census Printing

Management System

ORSI CSC

Interface

Monitors external printing procurements through the Government Printing Office (GPO) and other selected vendors – orders and change orders, receipts, IPAC disbursement classification and reconciliation. The system includes functionality that provides financial discipline in the printing area that cannot be accomplished within the CFS and procurement systems due to complexity. This is vitally important due to the high volumes and dollar amounts that occur during Decennial and special censuses. The orders portion is currently integrated with CFS but will be converted to interface through the Obligation and Requisition Standard Interface (ORSI ) when that interface becomes available in production; the receipts and invoice transactions are interfaced through the Standard Interface for Accounts Payable (SI-AP)

13 CENSUS CPMS - Census Printing

Management System

APSI CSC

Interface

Monitors external printing procurements through the Government Printing Office (GPO) and other selected vendors – orders and change orders, receipts, IPAC disbursement classification and reconciliation. The system includes functionality that provides financial discipline in the printing area that cannot be accomplished within the CFS and procurement systems due to complexity. This is vitally important due to the high volumes and dollar amounts that occur during Decennial and special censuses. The orders portion is currently integrated with CFS but will be converted to interface through the Obligation and Requisition Standard Interface (ORSI ) when that interface becomes available in production; the receipts and invoice transactions are interfaced through the Standard Interface for Accounts Payable (SI-AP)

14 CENSUS CUR - CBS User Re-authorization (CUR)

Bureau Specific Interface

Automated system (user provisioning tool) to allow supervisors to re-authorize their employees semi-annually to use various applications within CBS with various privileges, and for re-certifications of all kinds, as appropriate.

15 CENSUS DAPPS - Decennial Payroll Interface

NFC CSC

Interface/ Bureau Specific Interface

ASD Supports a People-Soft system for payrolling the temporary Decennial enumerators. This People-Soft system creates data files from it's "GL Module" and places these files in a directory on it's machine.

CBS has a process that automatically copies files from the "Decennial" machine to the CBS server in the /interfaces/dapps directory.

CBS then has a manual load screen that uploads the contents of the files into a series of staging tables in CBS at the SSN level. Then the contents of the staging tables are rolled up by ACCS, assigned a bulk decennial employee number, and inserted into the nfc_stag table of the CSC's NFC Payroll Interface.

(if necessary), and post the data.

DAPPS data are rolled up by ACCS, and then placed in the nfc staging table (nfc_stag). The NFC001 process is executed to validate the DAPPS data, and the NFC002 process posts DAPPS data to the General Ledger. Other NFC processes effect DAPPS data as well, like the NFC003 Reject Correction screen, and the NFC011 Revalidation Process.

16 CENSUS DATA Act Extract CSC DATA

ACT

Extract

These are a set of extracts run on a monthly/quarterly basis to comply with Treasury's and OMB's DATA Act initiative. The Extracts are consolidated within the EAS DATA Act application and then uploaded to Treasury's DATA Act website.

17 CENSUS DSI - Data Sales Interface

ARSI CSC

Interface

The Census Bureau offices that offer data sales products will log onto pay.gov when a customer places an order for one of these products. A daily download is done from pay.gov by CBS processing staff. The data file is then loaded into the DSI for validation.

posting into the CFS.

18 CENSUS E2 Obligation Interface

E2 CSC

Interface

Webservice interface between CWT E2 system and CFS Instances.

19 CENSUS E2 SFTP MIS DATA Bureau Specific Interface

Batch interface between CFS instances and E2. This includes Management Information Data (MIS).

20 CENSUS E2 SFTP

Transactions (Voucher and

Status)

E2 CSC

Interface

Batch interface between CFS instances and E2. This includes Voucher Interface and Status Return Messages.

21 CENSUS Employee Interface Bureau Specific Interface

Gathers NFC employee data from HRD, and inserts/updates it in the CBS employee_control, employee_detail, vendor_control and vendor_detail tables. GL029 displays information stored in the employee_control and employee_detail tables. PM002 displays information stored in the vendor_control and vendor_detail tables. Interface provides employee data to the CCR and Remedy Action Request System.

22 CENSUS Employee Roster Bureau Specific Interface

This allows employees to update their own locater information (building and room) in employee_control. This also allows Administrative Liaisons to update information for the areas under them.

23 CENSUS ESPS - Express Small Package

System

APSI CSC

Interface

Billing data from all sources are downloaded from proprietary FEDEX/UPS program for the weekly EDI ASCII files of invoices (one file for domestic and one file for international). Once files are loaded, ESPS performs edits and validations. Once everything has been processed through ESPS, including the reconciliation processes, the data are placed in the CSC's AP Standard Interface for posting to the CFS.

ESPS' reconciliation feature allows user's to adjust ACCS codes before posting occurs. There is a process that "sweeps" reconciled transactions daily, and places them in the AP Standard Interface. If transactions have not been reconciled in ESPS within 20 days, they are "swept" to the AP Standard Interface for posting.

In addition, a module creates an edited paper copy of the BC-41 form to authorize ACSD to ship something, and charge a specific ACCS code. ACSD enters information on this paper form into a FedEx or UPS vendor system.

24 CENSUS ETMIS - Education & Training

Management System

Bureau Specific Interface

Allows training offices to define class schedules and solicit students to sign up for that training. Outputs include various reports, in addition to class rosters. External training orders and costs currently posts directly to CFS Payment Management Tables, but will be converted to use ORSI when that interface is available in production. These costs along with training data paid for by credit card are retrieved from the CPCS for subsequent feed to the Human Resources Division’s training history database. Internal training costs incurred are forwarded to FIN for keying into ICDS via a Form BC-563 Internal Cost Distribution Report. After processing through ICDS to create the related Working Capital Fund revenue entries, the data is posted to CFS via the Summary Level Transfer standard interface. ETMIS+ also tracks the status of Title 13 training for employees and contractors.

25 CENSUS ETMIS - Education & Training

Management System

ORSI CSC

Interface

Allows training offices to define class schedules and solicit students to sign up for that training. Outputs include various reports, in addition to class rosters. External training orders and costs currently posts directly to CFS Payment Management Tables, but will be converted to use ORSI when that interface is available in production. These costs along with training data paid for by credit card are retrieved from the CPCS for subsequent feed to the Human Resources Division’s training history database. Internal training costs incurred are forwarded to FIN for keying into ICDS via a Form BC-563 Internal Cost Distribution Report. After processing through ICDS to create the related Working Capital Fund revenue entries, the data is posted to CFS via the Summary Level Transfer standard interface. ETMIS+ also tracks the status of Title 13 training for employees and contractors.

26 CENSUS General Information

(GI)

Bureau Specific Interface

This is a collection of screens where users can lookup information for general interest. Examples include but are not limited to - Employee Roster, Building Locations, CBS Coordinators, etc..

27 CENSUS ETS2 CBA APSI CSC

Interface

Processes travel ticket costs and related fees for invoices from CWTSATO Travel Agency and Citibank.

28 CENSUS HMT - Hazardous Materials Tracking

(HMT)

Bureau Specific Interface

Application provides safety representatives quick access to current product material safety data sheets (MSDS's), help to prepare for surveys of assignment areas, helps to conduct periodic surveys in assignment areas, make results of the surveys available to the Safety Office in hazardous materials quarterly reports of assignment areas. The reports indicate where hazardous materials are located, how much is present (i.e., the number of containers), and whether MSDS's are posted. The system also provides a data source for the HRD safety web site.

29 CENSUS HR Connect Bureau Specific Interface

TBD

30 CENSUS ICDS - Internal Cost Distribution System

SLT CSC

Interface

A data capture system for manual and automated internal cost distributions (Form BC-563) for the Working Capital Fund and Special Cost Collection activities. The application also creates the related revenue or reimbursement entries prior to interfacing the transactions to CFS via the Summary Level Transfer standard interface.

The CENDocS application directly populates information into the ICDS staging table for processing expenses/revenues associated with ACSD printing design services. There are also manual data entry screens used within the ICDS application that Finance and NPC use.

31 CENSUS ITBP/CAT Bureau Specific Interface

IT Business Plan (ITBP) process is a Census developed process used by ISSRO to aid in managing IT Business Plans. The process is integrated into CFS and captures information from ORSI CSTARS requisitions and obligations on the transaction level once the transactions are interfaced into CFS by ORSI.

used by C.Request users to track the approval chain associated with a C.Request requisition once it has been interfaced into CFS. ISSRO CSTARS Approval Tracking (CAT2) is a Census developed application used by ISSRO staff to track and view C.Request Interfaced requisitions once they have been interfaced into CFS.

32 CENSUS ITBP/CAT -

Continued

Bureau Specific Interface

IT Purchases within the Census Bureau require an approved IT Purchase Plan. These approved IT Purchase Plans are assigned a number. When IT Purchases are made, the number is placed on CSTARS purchasing documents. This application sits on top of CSTARS/TIBCO and tracks dollar amounts used on the IT Purchase Plan numbers for Central IT, to show remaining balances.

Census tracks spending against an IT Business Plan (ITBP). Purchase amounts from CSTARS are tracked against the ITBPs, to ensure spending is planned.

33 CENSUS JBOND - James Bond Identification more discussions are needed to understand requirement

Bureau Specific Interface

The Census Bureau has a policy stating one employee (Govt. or contractor) have the same user id across all systems used at Census. This means, for example, the user id is the same for network access, CBS access, and other applications. This application generates the user id based on information in the employee_control table for NFC pay rolled and contract employees, and from the Decennial DAPPS application for FDCA accounts.

This application also interfaces email addresses and phone numbers into the CBS employee_control table from our office that maintains these items.

Due to it's involvement in generating user ids, this application is integral to our employee entry and exit processes.

34 CENSUS NFC Payroll - Census

NFC CSC

Interface

The Census Bureau charges Benefits expenses computed by the NFC to the actual work project instead of the Working Capital Fund (WCF).

Salary estimates are loaded into CBS using the NFC200 process, which means the salary estimates are based on T&A information, which is at a work project level. Benefit estimates done by the NFC007 use a prior pay period as a base, and apply a percentage.

cyclical work projects.

The NFC402 process was created to generate Benefit estimates based on the Salary estimates instead of a prior pay period. This means Benefit estimates are in-line with Salary estimates for highly seasonal or cyclical work projects. This has proven to be a great value to many project managers at Census.

This process works by obtaining information from the GJ tables regarding Salary estimates, then applies "rates" from a maintenance table to the appropriate data. Resulting calculations go to nfc_stag. Then the NFC001 is run for validation, and the NFC002 is run for posting.

35 Census NFC Personnel - NFC Personnel File into CFS

NFC CSC

Interface

FTP- Bi-Weekly

36 CENSUS NPC Apps

JARS/CARS/JTAS -

NPC Applications

JTAS (Jeffersonville Time and

Attendance System) JARS (Jeffersonville

Activity Reporting System)

CARS (Cost Activity Reporting System)

Bureau Specific Interface

JARS - Collects and reports labor hours and costs for the multitude of activities that NPC performs. It outputs weekly production statistics for time and attendance output and monthly incentive awards for NPC staff who work on production standard related tasks.

CARS - Collects information from JARS (Jeffersonville Activity Reporting System), compares that information with budget information entered by CARS users, and creates various reports at different accounting classification levels. (National Processing Center (NPC) staff use the information for forecasting and estimating labor costs.)

data.

JTAS uses the data entered into NPC JARS, and produces a Time and Attendance data file for upload into Web T&A for pay rolling NPC and Telephone Center employees.

37 CENSUS OAR+ - Overtime Authorization

Request System

Bureau Specific Interface

Application allows authorized supervisors and/or their timekeeper to create a request for overtime or compensatory time for an employee. After completing the request, the creator forwards it to the initiator. The initiator reviews the request, then initiates the approval process.

and attaches it to the employee's time sheet.

38 CENSUS OE/I/ Order Inventory -possible to use Oracle Module -property requirement

(ILMS)

Bureau Specific Interface

OE/I is a system written by Oracle Financials, and it serves multiple warehouse organizations to accommodate ordering and distributing of ongoing Census Bureau products/information. The system generates a “pick slip” for pulling the appropriate inventory.

It is a stand-alone system that interfaces some maintenance data into it from CBS.

39 CENSUS Payroll Estimates - Payroll Estimates using NFC screens

NFC CSC

Interface

Payroll estimates are processed monthly prior to close

40 CENSUS Pears Bureau Specific Interface

Employee's supervisor is populated into employee_control

41 CENSUS Postal APSI CSC Interface

Centralizes the cost accounting and reporting for U.S. Postal Services including bulk mailing, imprint services from NPC, and postal meters. Then it distributes the costs to the end users. Postal is interfaced to the CFS Payments Management module through the Standard Interface for Accounts Payable.

Postal interfaces data files from: (1) HQ/RO meters, (2) NPC meters, and (3) permit imprint. Data can be manually keyed as well. Postal pulls, the data together from the various sources, then reconciles against OMAS.

42 CENSUS PTCS - Property and Tort Claim

Bureau Specific Interface

Allows users to insert, update, delete, and query Personal Property and Tort Claims. It documents and tracks all personal property and tort claims for Census headquarters, Divisions, Regions, and other off-site locations. The system provides reporting and letter-writing functionality, allowing the user to generate different types of letters and reports as its output.

43 CENSUS Remedy Bureau Specific

IT service management system where tickets are created to manage, track, and process incidents.

44 CENSUS SAM - System for Award Management

Bureau Specific Interface

Daily

45 CENSUS SMRS - Safety Monitor Reporting

System

Bureau Specific Interface

Application provides a mechanism to help the Human Resources Division (HRD) Safety Office track and maintain assignments of responsibility for Safety Representatives and Safety Monitors, identification of impaired employees by division and primary and secondary safety representative, and tracking of training given to safety representatives and safety monitors.

46 CENSUS T&A Validation Project

Bureau Specific Interface

In the Census Bureau's COBRA Budgeting system, monies are assigned to various Division/project combinations. These data are transferred to CBS, and a screen allows program areas to decide whether funding is usable for payroll or not. If funding is available for payroll, then the Division/project combinations with payroll funding are placed in an edit file for use with Web T&A, and Winfred (a FLD system written by HRD, similar to NPC JARS and NPC JTAS, that creates a T&A file for upload to Web T&A).

47 CENSUS Transportation Apps ( Carpool, Parking &

Subsidy)

Bureau Specific Interface

This system provides users with the ability to request and track various transportation related activities. These include but are not limited to Carpool, Parking and Subsidy.

48 CENSUS Treasury

49 CENSUS UTS - Unified Tracking System

Bureau Specific Interface

The Unified Tracking System (UTS) is a data warehouse that provides a view of Census data over time, across surveys, and from different data capture sources at one time; all of the data in one place to view, analyze, and make more efficient and effective decisions.

50 CENSUS Various Employee Bureau Specific Interface

Various extracts of employee and contractor data, sometimes combined with data from other AMSD Systems and then transferred to systems from other areas of Census.

51 NIST 1099 & 1042

generation

Bureau Specific Interface

Sql query scripts run in Toad to generate cvs file for upload into 1099 Pro software. 1099Pro generates 1099 and 1042 for vendors. Data from CFS is uploaded to "1099 Pro" software to print the 1099s. Includes CPCS data for payments to merchants that are 1099 reportable.

52 NIST Accrued and Subscript - Pay.gov

Forms with ARSI interface to CFS:

* NIST

Accreditations and

Subscriptions Payment Form

ARSI CSC

Interface

Automated - Daily:

NIST sales/collection system that sells materials/data to the public. Funding supports scientific research.

See for additional information: https://pay.gov/paygov/agencySearchForms.html?

nc=1379596008836&agencyDN=ou%3DFA_National+Institute+of+Standards+and+Technology%2Cou%3DFA_Department+of+Commerce%2Cou%3DFA_Executive+Branch%2Cou%3DFederal+Agency%2Cou%3DTreasury+Web+Application+Infrastructure%2Cou%3DFiscal+Service%2Cou%3DDepartment+of+the+Treasury%2Co%3DU.S.+Government%2Cc%3DUS&alphabet=N

53 NIST ACCS Data to Maximo

Bureau Specific Interface

Accounting codes are loaded into Maximo so that work orders can have valid projects, accounting elements to charge to. ACCS Data elements file from CBS is loaded through Informatica to populate Maximo.

54 NIST American Bankers Assoc - American

Bankers Association (ABA) download

Bureau Specific Interface

Weekly - updating bank information

55 NIST ASAP Authorizations ASAP CSC Interface

Automated Standard Application for payments used to notify treasury that the Grantee has been awarded funds and the amount that they are authorized to draw.

56 NIST ASAP Treasury Draw ASAP

CSC developed interface - ASAP (Automated Standard Application for Payments) for Grant payment activity. Processes invoice record to PM003 as paid to denote a payment to a grantee that was made through asap.gov

57 NIST ASD - Administrative Services Division – motor vehicle rentals, postal chargebacks, shipping/receiving, demurrage

SLT CSC

Interface

MONTHLY - internal billing application for NIST 341B services such as printing, duplicating, Visual Arts, etc.

58 NIST Bankcard (SP3) ACCS upload

APSI/ CSC

Interface

Automated FTP – Daily file from CBS to Citibank.

59 NIST Daily RA File Processing

APSI/ CSC

Interface

Automated FTP - Daily All cardholder's purchases are load the day after the purchase occurs.

60 NIST Bankcard Monthly AO/CH Updates

OVP/CPCS

CSC

Interface

Automated FTP - Monthly Contains new or updated personnel with purchase cards. - Contains approval officer and card holder information.

61 NIST Automated FTP – Monthly file from Citibank which is used to load customer purchase card transactions for payment

APSI/ CSC

Interface

Allows NIST to record transactions at the detail level.

62 NIST Boulder Plant Charges NIST

SLT CSC

Interface

NIST ONLY Informatica Weekly Monthly

63 NIST Boulder Printing & Duplicating

SLT CSC

Interface

MONTHLY

NIST & NTIA Boulder charges

64 NIST Boulder Publications

(NEW)

SLT CSC

Interface

NIST/NTIA Desktop Monthly

65 NIST Boulder Shops NTIA SLT CSC Interface

NIST/NTIA Desktop Weekly

66 NIST Boulder Storeroom SLT CSC Interface

NIST/NTIA Desktop Monthly

67 NIST C.Award ORSI CSC Interface

CACI provided COTTS product to award procurements - Daily (via Tibco)

68 NIST C.Request ORSI CSC Interface

CACI provided COTTS product to request procurement actions - Daily (via Tibco)

69 NIST Calibration Payments - NIST

Calibrations Payment Form

ARSI CSC

Interface

Same description as #79 above for all; but separating out on inventory and ask for the diagram as well

70 NIST Calibrations ARSI CSC Interface

Billing file sent from Calibrations ISSC database. Interface to generate bills to customers for calibration and measurement services to both commercial and federal customers.

71 NIST CMVP Billing file. We pull from CMVP server and place on CATSFS, then pull to CFS ARSI directory.

Bureau Specific Interface

72 NIST Computer Services - Blackberry/Mobile

Devices

SLT CSC

Interface

MONTHLY

73 NIST Computer Services (TSM - night cycle tape backup process)

SLT CSC

Interface

Server WEEKLY

74 NIST Conf and Webinars - NIST Conference and Webinars Payment form

ARSI CSC

Interface

Same description as #79 above for all; but separating out on inventory and ask for the diagram as well

75 NIST CSTARS FPDS-NG

connection

76 NIST CSTARS OMB MAX

77 NIST CSTARS to ServiceNow data sharing

78 NIST CSTARS Vendor Table output for Maximo

Informatica

79 NIST DATA Act Extract CSC DATA

ACT

Extract

These are a set of extracts run on a monthly/quarterly basis to comply with Treasury's and OMB's DATA Act initiative. The Extracts are consolidated within the EAS DATA Act application and then uploaded to Treasury's DATA Act website.

80 NIST Desktop Billings SLT CSC Interface

WEEKLY - iTAC support charges

81 NIST Do Not Pay Bureau Specific

Outbound interface from CFS. Sql job run against CFS vendor table and then is sent to St. Louis FRB via Treasury to determine list of payees not to submit payment. Manual analysis is required

82 NIST DoS (Authorizations)

- Department of State Interface

FMC60 file - Authorizations

SLT CSC

Interface

ITA/DoS - Daily

Five different input files (FMC60, FMC62, FMC80, VADR, CAPPs) that are fixed width or tilde delimited are loaded daily to CFS. Process requires significant PL/SQL logic to bride DoS and DOC financial systems. Output files from PL/SQL process are fixed width CFS SLT formatted files

Additionally many input DoS accounting codes are captured for auditability to the DoS's financial system, and to assure Treasury Cash balances are consistent.

Foreign currency amounts and exchange rates are also captured to facilitate downstream exchange rate fluctuation/impact analyses, and then to adjust fund authorizations where appropriate.

Also, manual aspects of this interface include sending fund authorizations to the DoS. And calculating ITA's Foreign Service Liability (leave and severance payout calculation); end result is several liability GL account updates

83 NIST DoS (CAPPS) - Department of State Interface CAPPS file

SLT CSC

Interface

See #75 above - Payroll data of US Nationals working overseas

84 NIST DoS (FMC62) - Department of State Interface FMC62 file

SLT CSC

Interface

See #75 above - obligations and accruals

85 NIST DoS (Pay & Collect) - Department of State

Interface - VADR (Payments &

Collections) file

SLT CSC

Interface

See #75 above

86 NIST DoS (Payroll) - Department of State

Interface - FSN Payroll

SLT CSC

Interface

See #75 - Foreign service national payroll from DoS

87 NIST DoS 1166 BFND (includes ARD and BOP notification emails)

Other (Describe in Comments)

Extract from CFS BOP data to DoS 1166 fixed length flat file format. DoS uploads into their financial system.

State obtain the 1166 file via manual Data Control (Althea Young) cfsc.state.gov file upload.

88 NIST E2 ACCS files extracted from CBS, saved to CATSFS, then pushed to

CWT.

E2 CSC

Interface

89 NIST E2 CBA files pulled from GTA/CBA, Saved to CATSFS, then loaded to CFS

APSI CSC

Interface

Government Travel Account (GTA) - Desktop Monthly; GTA is a pre-APSI translation/interface routine with error fallout/correction screens before the data is transferred (table driven) into APSI tables. AdTrav is the ticket provider.

90 NIST CBA E2 Interface E2 CSC Interface

E2 CBA files pulled from E2 CBA interface, saved to CATSFS, then loaded to CFS

91 NIST E2 Obligation Interface

E2 CSC

Interface

Webservice interface between CWT E2 system and CFS Instances.

92 NIST E2 SFTP MIS DATA Bureau Specific Interface

Batch interface between CFS instances and E2. This includes Management Information Data (MIS).

93 NIST E2 SFTP

Transactions (Voucher and

Status)

E2 CSC

Interface

Batch interface between CFS instances and E2. This includes Voucher Interface and Status Return Messages.

94 NIST W2 Data Extract (1099 Data Extract)

Bureau Specific Interface

Data Extract from CBS to process information in the 1099 software (separate from CBS)

95 NIST Emp Email Addr Update - Employee

Email Address Updates

Bureau Specific Interface

Monthly GL029

96 NIST Estimated Accrual Application

APSI CSC

Interface

Year End Estimated Accrual Portal Application. Users enter data in the EA forms application and then data is transferred to APSI tables for batch import into CFS.

97 NIST Facilities PO System (Award, Bankcard) - PO System (Work

Orders, Award and Bankcard Data)

Bureau Specific Interface

The PO System is a secondary system used by Plant to help reconcile work orders between CFS, C.Suite and CPCS. There is a difference in level of detailed captured in CFS, C.Suite, CPCS compared to Maximo, and therefore, the PO System acts as the translator to reconcile the two systems (Maximo/CBS/C.Suite/CPCS).

98 NIST Federal Workforce Transportation

System (rename on diagram)

SLT CSC

Interface

Informatica - Monthly

99 NIST GMIS - Grants Management

Information System

ORSI CSC

Records grant awards in CBS. This interface will remain until NIST migrates to NOAA's Grants Online System.

100 NIST GMIS to Grants.gov

101 NIST Govt Bill of Lading (GBL) - Government Bill of Lading (GBL) Interface *Proposed

To-Be* Orders & Invoices

APSI CSC

Interface

Future proposed interface to handle transportation of goods related to travel, relocation

102 NIST Govt Bill of Lading (GBL) - Government Bill of Lading (GBL) Interface *Proposed

To-Be* Orders & Invoices

ORSI CSC

Interface

Future proposed interface to handle transportation of goods related to travel, relocation

103 NIST Grant Disbursement Payments - Cross

Serviced (non-GMIS) Grant Disbursement

Payments

Bureau Specific Interface

Daily

104 NIST Grants Enterprise Management

(GEMS) -- (denote as To-Be)

ORSI CSC

Interface

Records grant awards in CBS. This interface will remain until NIST migrates to NOAA's Grants Online System.

105 NIST Informatica (GEN2PDI) GenX

Informatica

106 NIST ITA Centralized Services

Bureau Specific Interface

Monthly allocation process to distribute centralized service costs to ITA's program area. Involves detailed Excel spreadsheet with percentage adjustment, and GJ Upload (GLN222 screen) to CFS

107 NIST ITA eMenu CC and ACH - ITA eMenu credit card and ACH collections (from pay.gov)

ARSI CSC

Interface

Daily sFTP file received from the ITA eMenu J2EE application that facilitated credit card collections with customers and pay.gov.

108 NIST ITA Safe Harbor CC and ACH - ITA

SafeHarbor credit card and ACH collections (from pay.gov)

ARSI CSC

Interface

Daily sFTP file received from the ITA eMenu J2EE application (which also hosts the SafeHarbor application) that facilitated credit card collections with customers and pay.gov.

109 NIST ITL CMVP Billing and Revenue data share from SQL extract on CBS DW, saved to CATFS, then pushed to CMVP server.

Bureau Specific Interface

ITL CMVP Billing and Revenue data share from SQL extract on CBS DW, saved to CATFS, then pushed to CMVP server.

110 NIST Labor Telework Loads file NFC Telework hours file from T Drive to CBS DW

File downloaded by Terry S to CATSFS?

111 NIST Lockbox - multiple check (i.e. ACH) collection points

ARSI CSC

Interface

FTP - Daily - collections information

112 NIST Maximo - ACCS Informatica

113 NIST Misc. Payment - NIST Miscellaneous

Payment Form

ARSI CSC

Interface

Same description as #79 above for all; but separating out on inventory and ask for the diagram as well

114 NIST NFC Payroll - Regular Labor Files

NFC CSC

Interface

FTP- Weekly

115 NIST NFC Personnel - NFC Personnel File into CFS

NFC CSC

Interface

FTP- Bi-Weekly

116 NIST NIST Personnel File

- My Tools and BST

Bureau Specific Interface

FTP- Bi-Weekly

117 NIST NIST to SalesForce CRM system (this is a placeholder for connections that will be in place prior to our move to OKC but are still being developed and may change)

WebServices for CBS Customer look-ups, new customer setup, and CBS revenue look-ups

And possible SFTP connection from SalesForce CRM cloud to CBS for ARSI interface files.

118 NIST NIST to Treasury BFS locations

Note:

2 VPN tunnels to Treasury BFS locations. One VPN goes to the Primary BFS location and the other VPN goes to the failover BFS location. These VPNs carry Connect:Direct production traffic for PAM (payments), ASAP, and DNP data.

119 NIST NTIA Boulder Plant Charges

APSI CSC

Interface

Informatica Monthly

120 NIST OISM Services SLT CSC Interface

Weekly - charges for OCIO special services

121 NIST OS WCF unbilled collections (~quarterly). NIST AR generates the ARSI UCL files from Excel, saves to CATSFS, then help desk ticket to Ping to move to ARSI CFS directory for CFS ARSI upload.

122 NIST Other SLT processes completed per NIST Data Control:

*added - A&R Reimbursable

Billings *added - NFC WCF

Costs

* HCHB/WCF Rent

(OS)

* Network/FTS (OS)

* Pepco/Washington

Gas (OS)

* Steam, Storm

Water (OS)

* OS Transit Benefits

* Water/Sewer (OS)

*OS WITS

* DHS (ITA)

* ROW (ITA)

* TOPS (ITA)

*ITA Transit Benefits *Deferred income memos (NIST)

NEW:

*UPS Bills (all bureaus)

*Accounting Services (OS)

*OCIO Chargebacks

(NIST)

SLT CSC

Interface

Monthly - AP Services

123 NIST Pay.Gov Baldridge interface

ARSI CSC

Interface

Daily - Treasury system for collections Internal website to NIST Baldridge website where customers can purchase NIST Baldridge application templates, etc., and the NIST website interfaces with pay.gov to process payment info for purchases. Data to CBS originates from pay.gov and uses ARSI to process into CBS

124 NIST Pay.Gov Std Ref Data - Pay.Gov Web Service Interactive

(non user data entry forms):

* Standard Reference Data (SRD) interface

ARSI CSC

Interface

Daily - Treasury system for collections Internal website to NIST; SRM website where customers can purchase NIST Baldridge application templates, etc., and the NIST website interfaces with pay.gov to process payment info for purchases. Data to CBS originates from pay.gov and uses ARSI to process into CBS

125 NIST Payroll Estimates - NIST Pay Period

End Labor Estimates NFC200 (for NIST only)

NFC CSC

Interface

FTP- Bi-Weekly

126 NIST Plant Gburg - Plant Gaithersburg

SLT CSC

Interface

Informatica MONTHLY

127 NIST SAM - System for Award Management

Bureau Specific Interface

Daily

128 NIST Shipping Charges SLT CSC Interface

Desktop- Monthly

129 NIST Shops NIST SLT CSC Interface

Desktop MONTHLY

130 NIST Siemens SLT CSC Interface

Monthly - telephone charges

131 NIST SLT Others Continued

**New Manual SLTs**added

- Monthly Rounding Difference

-Cash Reconciliation Corrections

- DoS AoC Requests -Burden (ITA)

- Monthly Property Reconciliations Reclassification

- Computing and Labor QPD CShop

Labor

- Electronic Shop

Labor Charges-QPD E-shop Labor

-Instrument Labor Charges-QPD IShop

Labor

- Interdivision Work

Orders (IWO)

- Corrections of Internal Costs

SLT CSC

Interface

Monthly - AP Services

132 NIST SRM Billings ARSI CSC Interface

Standard Reference Material that NIST sells to customers. SRM database generates bill file for upload into CFS via ARSI.

133 NIST SRM Customer Data Entry to "Customer Look-up form"

SRM DB Link to CBS DW. To write customer data to CFS

134 NIST Std Ref Material - Standard Reference

Material (SRM)

ARSI CSC

Interface

Same description as #79 above for all; but separating out on inventory and ask for the diagram as well

135 NIST Storeroom Inventory system

SLT CSC

Interface

Server-Weekly - Storeroom Issues File, Storeroom Surcharge, Storeroom Adjustments

136 NIST Sunflower HR interface. Query from CPR (Central People Repository), generate on pcbsinf01/2 server, save to CATSF, sFTP Sunflower sFTP server.

Bureau Specific Interface

137 NIST Sunflower PO CPCS interface. Query from CBS, generate on pcbsinf01/2 server, save to CATSF, sFTP Sunflower sFTP server.

Bureau Specific

138 NIST Sunflower PO CSTARS interface.

Query from CBS, generate on pcbsinf01/2 server, save to CATSF, sFTP Sunflower sFTP server.

Bureau Specific Interface

139 NIST Sunflower SAML authentications

Sunflower authentication between OKC hosted Sunflower and NIST's authentication store

140 NIST Sunflower: ANT asset web service query

Bureau Specific Interface

141 NIST Sunflower: Property ANTS interface

Bureau Specific Interface

ANTS shows all devices on the network. Interface to property that reports the devices/property on the network to the property system.

Possible to use this to inventory those devices/assets instead of physically scanning and inventorying

142 NIST Sunflower: Scanner interface to property

Bureau Specific Interface

Export data file from the scanner softer that is imported into Sunflower (Keith K)

143 NIST TADDS process to generate the file - Quarterly Estimate from Web TA for CFS and MyTools

HR File estimate (TA file) But this file is for CFS Labor Estimates.

Input is the AO's estimates in Web TA. Data then loaded into MyTools.

144 NIST Travel Relocation Orders & Vouchers

APSI CSC

Interface

Frequency TBD (Daily or Monthly). To record travel relocation payments made from USDA/NFC.

145 NIST Various web service interfaces between NIST CBS and NIST program areas, e.g.

- MML Travel Actuals look-up

- SRM Customer Look-up

- NAIS Award Look-up (under development)

- CMVP revenue look-up (under development)

- Other future web services

WebServices from NIST Gaithersburg program areas to NIST CBS.

146 NIST Verizon/WITS Phone Charges

SLT CSC

Interface

Informatica - Monthly - Washington Interagency Telecommunication Services (WITS)

147 NIST Work Order, Award & Bankcard to Maximo

Bureau Specific Interface

Process between Maximo, CFS, CPCS, and C.Suite in which Maximo receives all of the CSTARS PO items (and Bankcard property items from CPCS) for population into Maximo Warehouse Management system C.Suite feeds award data directly into Maximo.

Also, an CPCS property extract file (for transactions with object class 31xx) is transferred to Maximo

Work Order information is loaded to Maximo to facilitate work order tracking. Work Order info originates from C.Suite passes through Informatica for formatting/loading into Maximo.

148 NOAA NFC & USCG

Personnel -

Employee Interface

NFC CSC

Interface

Used to collect and enter WFM employee data from the NFC and Coast Guard

149 NOAA ASAP Authorizations

- ASAP Profiles and

Authorizations

ASAP CSC

Interface

Automated Standard Application for payments used to notify treasury that the Grantee has been awarded funds and the amount that they are authorized to draw.

150 NOAA ASAP Treasury Draw ASAP CSC Interface

Automated Standard Application for Payments used for processing Grant Advance requests and transactions;

151 NOAA Bankcard (SP3) ACCS upload

APSI/ CSC

Interface

Process travel ticket costs and related fees for invoices from CWTSATO Travel Agency and Citibank.

152 NOAA C.Award ORSI CSC Interface

Real time interface between C.Suite and CFS.

153 NOAA C.Request ORSI CSC Interface

Real time interface between C.Suite and CFS.

154 NOAA ETS2 CBA APSI CSC

Interface

NOAA receives multiple monthly files from the TMC (AdTrav) and a monthly file from FedTraveler (EDA only) for the cost of the Airline Tickets charged to the Government's Travel Accounts.

155 NOAA CIR Interface Other (Describe in Comments)

Interface between Dept. of Treasury's Collections Information Repository (CIR) system and CFS for DSFA ACH and credit card collections made via Pay.gov. CIR provides collections data via a daily batch in XML file format (separate files are produced for ACH and credit card data).

Deposit Ticket, and Unbilled Collection) for upload into CFS via the ARSI. The interface also provides reports to assist NOAA FO staff with reconciling to CIR (summary and exception reports) and also generates email notifications summarizing the results of processing.

156 NOAA Commerce Bankcard Center - CH/AO

Updates

OVP/CPCS

CSC

Interface

The Commerce Bankcard Center is the Department's application. NOAA has developed routines which load the cardholder and approving official information. NOAA routines also extract 1099 and ACCS information as well as provide bi-directional SSN files.

157 NOAA Commerce Bankcard Center - Invoices

OVP/CPCS

CSC

Interface

The Commerce Bankcard Center is the Department's application. NOAA has developed routines which load the invoices official information.

158 NOAA Commerce Bankcard Center - Monthly

Transactions

OVP/CPCS

CSC

Interface

The Commerce Bankcard Center is the Department's application. NOAA has developed routines which load the detailed transactions associated to the invoice.

159 NOAA DATA Act Extract CSC DATA

ACT

Extract

These are a set of extracts run on a monthly/quarterly basis to comply with Treasury's and OMB's DATA Act initiative. The Extracts are consolidated within the EAS DATA Act application and then uploaded to Treasury's DATA Act website.

160 NOAA Do Not Pay Bureau Specific Interface

Sql job run against CFS vendor table. Results SFTP'd to Treasury to compare vendors in CFS to the DNP data in order to identify vendors that the Department should no longer do business with. Manual analysis is required.

161 NOAA E2 MIS DATA Bureau Specific Interface

Batch interface between CFS instances and E2. This includes Management Information Data (MIS).

162 NOAA E2 Obligation Interface

E2 CSC

Interface

Webservice interface between CWT E2 system and CFS Instances.

163 NOAA E2 SFTP

Transactions

(Voucher, Status, and ACCS)

E2 CSC

Interface

Batch interface between CFS instances and E2. This includes Voucher Interface and Status Return Messages.

164 NOAA EDA Grants Bureau Specific Interface

NDW Extract Interface - NOAA provides accounting support for EDA's Grants Processing.

165 NOAA ESPS - Express Small Package

System

APSI CSC

Interface

NOAA's application used to process FedEx and UPS Express Small Package shipments.

166 NOAA Grants on-line ORSI CSC Interface

This application supports the grant award process within NOAA and grantee reporting requirements. - Obligation balances are retrieved from the NDW as a near-real-time data feed.

167 NOAA Grants Online extract

Bureau Specific Interface

DW extract

168 NOAA Grants on-line/SF270 Invoice

Processing

NOAA

specific utilizing

APSI logic

Processes SF270 (invoices) transactions from Grants Online

169 NOAA GSA Motor Pool APSI CSC Interface

NOAA's application used to process motor pool charges from GSA

170 NOAA NDW Extract Applications

Bureau Specific Interface

NOAA has numerous specialty applications that extract data on a nightly basis from the NDW; these include but are not limited to: Management and Analysis Reporting System (MARS); Grants Online (GOL); DSFA; Sunflower; and EDA. This includes Financial and application related data.

171 NOAA NDW Extract Applications - AR &

Customer

Bureau Specific Interface

Provide customer and accounts receivable data to NMFS DSFA system to support updating DSFA customer profiles and customer accounts with CBS data (i.e., receivable adjustments and collections, customer data, etc.). DSFA relevant customer and AR data is provided to NMFS via extract tables.

update DSFA customer profiles with CBS Customer and Contact Numbers (key data elements for interfacing receivables (ID#14) and collections (ID#20)) and DSFA customer accounts with collections, adjustments, etc. to provide DSFA customer with a status of their account.

tables via database link.

172 NOAA NFC Payroll NFC CSC Interface

National Finance Center - processes NOAA civilian payroll.

173 NOAA NLSC DB Link (Read Only)

Bureau Specific Interface

Kansas City NLSC Link to read CFS data

174 NOAA Post As Approved PM006 Adjustments

NOAA

Specific utilizing

OVP500

logic

Posts Bankcard reconciliations as approved (due to high volume)

175 NOAA Relocation Manager (Obligations)

Bureau Specific Interface

Automated travel document preparation and accounting system for PCS travel

176 NOAA Relocation Manager (Vouchers)

Bureau Specific Interface

Automated travel document preparation and accounting system for PCS travel obligations

177 NOAA Relocation Mgr. Data Feed - Relocation

Manager Employee/Traveler

Data Feed

NOAA

Specific

Feed from CBS to Relocation Manager listing detailed employees, vendors, and bargaining unit data

178 NOAA SAM - System for Award Management

Bureau Specific Interface

Vendor Standard interface between CCR.gov/SAM and CFS.

179 NOAA SISP - Departmental Seafood

Acceptance System

ARSI CSC

Interface

Departmental Seafood Acceptance System - generates bills and delinquent notices for seafood inspection services provided by the National Marine Fisheries Service (NMFS) Seafood Inspection Program (SIP).

180 NOAA SLT Interface SLT CSC

Used to post general ledger journal voucher transactions.

181 NOAA Telcom Charges - Telecommunications

APSI CSC

Interface

NOAA's application used to process the telecommunication charges from GSA as well as commercial vendors.

182 NOAA USCG Payroll - US Coast Guard Payroll/

Personnel

NFC CSC

Interface

US Coast Guard Payroll/ Personnel - processes NOAA Corps payroll actions

183 NIST Enterprise Backup SLT CSC Interface

Monthly ServiceNow to CFS SLT interface

184 NIST Central File Service SLT CSC Interface

Monthly ServiceNow to CFS SLT interface

185 NIST NIST OISM Virtual Server Services

SLT CSC

Interface

Monthly ServiceNow to CFS SLT interface

186 NIST Amazon Web Services Billing

Distribution

SLT CSC

Interface

Monthly ServiceNow to CFS SLT interface

187 NIST NIST OISM Physical Server billings

SLT CSC

Interface

Monthly ServiceNow to CFS SLT interface

188 NIST Enterprise Backup (additional SLT interface files are expected in the future)

SLT CSC

Interface

Monthly ServiceNow to CFS SLT interface

189 NIST Salesforce\Pay.gov to CFS ARSI

ARSI CSC

Interface

Daily ARSI interfaces files(4 different files) from Salesforce and pay.gov to post prepayments, prepayment reclassifications, billings, and collections.

190 NIST ITA

Salesforce\Pay.gov to CFS ARSI

ARSI CSC

Interface

Daily ARSI interfaces files from ITA's Salesforce instance and pay.gov to NIST CFS. (This effort is currently under development and is intended to replace ITA's eMenu financial functions)

191 Census DBIT Bureau Specific Interface

Decennial Budget Integration Tool

192 Census CLC Bureau Specific Interface

Commerce Learning Center

193 Census CHEC Bureau Specific Interface

Clearance processing of all personnel at Census

194 Census FIAT Bureau Specific Interface

Finanacial Investments Analysis Tool

195 Census DAPPS Bureau Specific Interface

Decennial Payroll Interface

196 Census CDL Bureau Specific Interface

Census Data Lake

197 Census GL Data Bureau Specific Interface

This is an interface of transactions from the general ledger for a specific set of ACCS values and timeframes.

198 Census Contracts Bureau Specific Interface

This is an interface of Financial information about contract awards from the financial system for a specific set of ACCS values and timeframes.

199 Census SP3 Monthly Invoices/corrections

APSI/ CSC

Interface

Automated FTP – Monthly file from Citibank which is used to load customer purchase card transactions for payment

200 NOAA SP3 Monthly Invoices/corrections

APSI/ CSC

Automated FTP – Monthly file from Citibank which is used to load customer purchase card transactions for payment