NOAA NOAA MARS Management analysis and reporting system

Back to Archive Index

ARCHIVE - New Features in MARS as of December 30, 2008

BOP Upload - Completed changes to BOP upload utility. An option has been provided to upload multiple files per FMC based on the Fund/Program selected.

FY '09 OPT Out Year Planning - Each year the MARS team will copy over current year Org, Project & Task combinations to the new FY to be used for planning purposes, e.g Labor Projections, Spending plans, etc. In doing so, the development team will only copy over valid Org, Project & Task combinations utilized in the current year. When copied, these combinations will reflect the new accounting structure defined by Finance. Once the accounting information is available in CBS, the FRS record will be over-written. Unused OPT combinations will be removed.

OPT Group/OPT Sub-Group - Within the Data Entry Module, several reports under the "Status of Funds" selection have a feature that groups data based on a pre-defined Org - Project - Task combination. This capability has been incorporated into the Reporting & Querying module. For consistency purposes, the naming convention used in the Data Entry module of "Division and Branch" has been changed to "OPT Group and OPT Subgroup". Instructions to setup unique OPT groupings can be found in the MARS System Administrators users guide under Project Setup.

PCARD Processing Changes - Due to changes to the NOAA Purchase Card process, changes were made to the MARS system to continue capturing detail level PCard data. Using the new View (NDW_CBS_TRANS_MV) provided by CBS, the development team updated existing AP_Trans credit card records for FY 2008/2009 where the reconciliation notes were missing. For all new AP_Trans PCARD records, the Purchase Item Description/Note will be populated, and will be carried through to the MARS commitment record created by the auto-ob feature. If no description is available in the notes, "credit card purchases" will default.

Travel/FY Logic Changes - FY for Travel records had been generated differently within the Data Entry Module and Reporting & Querying Module. To fix this issue, the Data Entry Module changed the algorithm to use Trip Date to determine the FY. This process mirrors the Reporting & Querying procedure. The change took effect Oct 1 for all '09 Travel.

CBS Travel Processing Changes - In FY 08, CBS changed the Travel process. To accommodate these changes, the MARS Team implemented procedures to auto-obligate Travel and update the detail information with data from the Reserv_Trans table. The development team also changed the match settings to auto-ob travel for all FMC's. We are currently monitoring the changes, new data will not be populated from Reserv_trans until January 6 - the next expected CBS software release date.

Variance Report (FTE enhancements) - The development team completed changes to the Variance report by adding the FTE objects to all universes so reports can be built based on an FTE reporting approach by Org or Program. The new objects will be as follows:

  • FTE (Org) - FTE with Leave spread. OC 77 and 09WLV project codes are excluded from this FTE value. Use this object when the desired result is FTE by Organization.
  • FTE (Program) - FTE with Overhead and Leave spread. Internal fund is excluded from this FTE value. Use this object when the desired result is FTE by Program.
Any existing FTE report will automatically pick up the FTE (Org) definition. The NOAA Variance Reporting is using the FTE (Org) definition.