Standard Financial Information Structure (SFIS) Business Transformation Agency - PowerPoint PPT Presentation

Loading...

PPT – Standard Financial Information Structure (SFIS) Business Transformation Agency PowerPoint presentation | free to download - id: 3e03bb-NDhhZ



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Standard Financial Information Structure (SFIS) Business Transformation Agency

Description:

Standard Financial Information Structure (SFIS) Business Transformation Agency Current Financial Visibility Challenge Authoritative Guidance for Arriving at SFIS ... – PowerPoint PPT presentation

Number of Views:36
Avg rating:3.0/5.0
Slides: 31
Provided by: novagaOrg
Learn more at: http://www.novaga.org
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Standard Financial Information Structure (SFIS) Business Transformation Agency


1
Standard Financial Information
Structure(SFIS) Business Transformation Agency
2
Current Financial Visibility Challenge
  • Lack of financial data standards across the
    Services impedes the ability to analyze
    performance on an enterprise-wide basis

3
Authoritative Guidance for Arriving at SFIS Terms
  • National Defense Authorization Act (NDAA)
  • Requires an information infrastructure which, at
    a minimum, integrates budget, accounting, program
    information, systems and performance
  • Office of Management and Budget (OMB) Circular
    A-127
  • Requires agencies financial management systems
    to reflect an agency-wide financial information
    classification structure that is consistent with
    the U.S. Government Standard General Ledger
    (USSGL)
  • Government Performance and Results Act (GPRA)
  • Requires annual performance reporting that links
    performance planned to performance achieved
  • Financial Accounting and Standards Board (FASAB)
  • Requires standards for managerial cost accounting
    government-wide
  • OMB, Office of Federal Financial Management
    (OFFM)
  • Requires that, within each department or agency,
    the accounting classification elements and
    definitions must be standardized to ensure
    uniform and efficient accounting treatment,
    classification, and reporting
  • Treasury Financial Manual (TFM)
  • Requires a generalized uniform chart of accounts
    and account transactions, collectively referred
    to as the United States Government Standard
    General Ledger (USSGL).

4
SFIS Summary
  • Description and Objective SFIS is the DoDs
    common business language that enables budgeting,
    performance based management, and the generation
    of financial statements. It provides an
    enterprise-wide standard for categorizing
    financial information along several dimensions to
    support financial management and reporting
    functions. These dimensions include
    Appropriation Account Information, Budget Program
    Information, Organizational Information,
    Transactional Information, Trading Partner
    Information, and Cost Accounting Information.
  • Deployment Categories
  • Legacy Accounting Systems
  • Encompasses existing Component financial
    accounting systems
  • Utilizes a centralized cross-walk capability to
    translate accounting transaction data to SFIS
    compliant data
  • Business Feeder Systems
  • Encompasses systems which create business
    transactions within DoD
  • Includes systems that create transactions such as
    travel orders, contracts, contract modifications,
    and certain types of invoices
  • Target Accounting Systems
  • Encompasses emerging environments, including ERP
    systems
  • SFIS compliance to be embedded directly in these
    target systems

SFIS Components
  • Benefits
  • Standardizes financial reporting data across DoD
  • Enables decision-makers to efficiently compare
    similar programs and activities across DoD
  • Provides decision-makers the level of detail they
    require for information retrieval and
    auditability
  • Improves the efficiency of maintaining business
    systems, thereby reducing costly maintenance and
    translation of non-standard data
  • Provides an audit trail
  • Links program execution to performance, budgetary
    resources, and actual financial information
  • SFIS Phases
  • SFIS Phase 1 59 elements released in BEA 3.0
    Sept 05
  • SFIS Phase II 5 new data elements released in
    BEA 4.0 Sept 06
  • SFIS Phase III 12 new data elements and 1
    deletion will be released in BEA 4.1 March 07

5
SFIS Data Elements
Appropriation Account Information
Transactional Information
  • Department Regular
  • Department Transfer
  • Main Account
  • Sub Account
  • Apportionment Category
  • Receipt Indicator
  • Sub Classification
  • Period of Availability
  • Reimbursable Flag
  • Fund Type
  • Advance Flag
  • Authority Type
  • Availability Time
  • Borrowing Source
  • Definite Indefinite Flag
  • Public Law Number
  • Program Report Code
  • TAFS Status
  • Year of Budget Authority

Transaction Type USSGL Account Number Debit/Credit
Begin/End Indicator Transaction Effective
Date Transaction Post Date Transaction
Amount Exchange/Non-Exchange Indicator Custodial/N
on-Custodial Indicator Foreign Currency
Code Country Code Entity/Non-Entity
Indicator Covered/Un-Covered Indicator Current/Non
-current Demand Unique Identifier Expense
Type Liability Type Revenue Type Business Event
Type Code FMS Customer Code FMS Case FMS Line
Organization Information
Organization Unique Identifier Agency Disbursing
Identifier Agency Accounting Identifier
SFIS Webpage http//www.dod.mil/dbt/sfis_resources
.html SFIS Library http//www.dod.mil/dbt/SFIS_Lib
rary.html
6
SFIS Governance Structure (Core Team)
7
Governance Structure and its relation to the
organizational components
DBSMCDefense Business Systems Management
Committee
PSA CAs
USD (C)
USD (ATL)
USD (ATL)
USD (PR)
ASD(NII)/DCIO
HRMHuman Resources Management
RPILMReal Property Installations Lifecycle
Management
WSLM/MSSMWeapon Systems Lifecycle Management and
Materiel Supply Services Management
FMFinancial Management
EIEMA Enterprise Information Environment Mission
Area
IRBs
Single Entry Point for Components to Process
Component PCA
Component PCA
Component PCA
Component Business Processes
Component Business Processes
Component Business Processes
8
SFIS Implementation Conditions
  • Comptrollers Memo is the basis of
    implementation.
  • All Systems must comply with the Under Secretary
    of Defense (Comptroller) memorandum, "Standard
    Financial Information Structure (SFIS)
    Implementation Policy", dated August 4, 2005.
  • The policy includes SFIS Conditions to define
    business systems in varying stages of
    transformation.
  • And, the policy mandates specific compliance
    requirements for each SFIS condition

9
SFIS Legacy Accounting System Condition
  • Under the Legacy Accounting System Condition, a
    program must submit to its PCA and appropriate
    IRB NLT XXXX,
  • (1) an SFIS Compliance Plan which includes the
    following
  • - An implementation meeting with the BEIS
    integrators or projected date of completion
  • - Identification of crosswalks to BEIS
  • - Interface plan or projected date of
    completion
  • (2) Verification that above information is
    consistent with information in the DoD
    Enterprise Transition Plan (ETP) or, if not
    consistent, when the ETP will be updated to
    reflect this information

10
SFIS Legacy Business Feeder System Condition
  • Under the Legacy Business Feeder System
    condition, a program must submit to the
    appropriate IRB via its PCA NLT XXXX
  •  
  • (1) If not using a translator, an SFIS
    Compliance Checklist for business feeder system
  • (2) an SFIS Implementation Plan which includes
    the following
  • - List of interfaces with accounting systems
    (target and legacy)
  • - Full operational date(s) for interface(s)
    with target accounting system(s)
  • - Date SFIS compliance has been realized or is
    expected
  • (3) Verification that above information is
    consistent with information in the DoD
    Enterprise Transition Plan (ETP) or, if not
    consistent, when the ETP will be updated to
    reflect this information.
  • Legacy business feeder systems who will not
    interface with the target environment are not
    required to meet these SFIS conditions.

11
SFIS Target Business Feeder System Condition
  • Under the Target Business Feeder System
    condition, a program must submit to the
    appropriate IRB via its PCA NLT XXXX
  •  
  • (1) the results  of the independent third party
    assessment of FFMIA compliance or when you
    expect to have it,
  • (2) an SFIS Compliance Checklist for business
    feeder systems
  • (3) an SFIS Implementation Plan which includes
    the following
  • - A list of systems being replaced and when (if
    applicable)
  • - List of interfaces with accounting systems
    (target and legacy)
  • - Full operational date(s) for interface(s)
    with target accounting system(s)
  • - Date SFIS compliance has been realized or is
    expected
  • (4) Verification that above information is
    consistent with information in the DoD
    Enterprise Transition Plan (ETP) or, if not
    consistent, when the ETP will be updated to
    reflect this information
  • This condition applies only to business feeder
    systems who will have a direct interface with
    the Target environment.

12
SFIS Target Accounting System Condition
  • Under the Target Accounting System condition, a
    program must submit to the program's PCA and
    appropriate IRB NLT XXXX,
  • (1) the results  of the independent third party
    assessment of FFMIA compliance or when you
    expect to have it ,
  • (2) an SFIS Compliance Checklist,
  •  
  • (3) an SFIS Implementation Plan that includes
    the following
  •   - An implementation meeting with the BTA
    Enterprise Integration Team or target date,
  • - List of interfaces with accounting/business
    feeder systems (target or legacy),
  • - A list of systems being replaced and when (if
    applicable)
  • - Date SFIS compliance has been realized or is
    expected
  • (4) Verification that above information is
    consistent with information in the DoD
    Enterprise Transition Plan (ETP) or, if not
    consistent, when the ETP will be updated to
    reflect this information.

13
(No Transcript)
14
Lessons learned
  • Formal Investment Review Board process that is
    supported by all business areas at the
    highest-levels of senior leadership
  • Cross-Functional Governance Structure that meets
    on a regular basis to collaborate on all data
    requirements
  • Enterprise Architecture that contains target
    requirements
  • Standard definitions, business rules, and
    values.
  • Functional experts focus on the what and ERP
    implementation experts focus on the how
  • ERP implementation experts on staff
  • Focus on end-to-end process not just financial
  • Net-Centric and Tiered Accountability Approach

15
Tiered Accountability
Enterprise Shared Services and System Capabilities
DoD ENTERPRISE LAYER
Enterprise Rules and Standards for
Interoperability
16
SFIS Integration with Key BTA Initiatives
BEA
SFIS requirements and rules are integrated in
several products of the BEA SFIS requirements
are integrated with the USSGL Transaction Library
Successful business transformation across the
Department is dependant on integration of all
three initiatives
SFIS
USSGL
17
Date Element Comparison
CGAC element DoD Element Project
Code Project Identifier Government-Wide Project
Code Contingency Code Line of Business
Subfunction Code Line of Business USSGL Account
Code USSGL/DoD Account Code USSGL Account
Extension Code USSGL/DoD Account Code Federal or
Non-Federal Code Federal/Non-Federal
Indicator Trading Partner Agency
Identifier Direct Transfer Agency Trading
Partner Bureau Identifier N/A Advance Code
Advanced Flag Authority Type Code Authority
Type Cover or Not Covered Covered/Uncovered Credi
t Cohort Year Derived Current or Subsequent
Code Availability Time Entity or
Nonentity Entity/Nonentity Exchange or
Nonexchange Code Exchange/NonExchange New or
Balance Code Year of Budget Authority Public
Law Number Public Law Number Trading Partner
Main Account Code Direct Transfer
Account Transfer To or From Code Transfer
To/From Accounting Period Derived Object Class
Code Object Class Code Object Class Extension
Code N/A Revenue Source Code N/A Budget Fiscal
Year Derived Business Event Type Code BETC
Agency Location Code Agency Disbursing
Identifier Cost Center Cost Center Activity
Code Activity Identifier
CGAC element DoD Element Internal Fund
Code None Sub-level Prefix Code N/A Allocation
Transfer Agency Identifier Department
Transfer Agency Identifier Department
Regular Beginning Period of Availability Period
of Availability Ending Period of Availability
Period of Availability Availability Type
Code Availability Type Main Account Code Main
Account Sub-Account Code Sub-Account Agency
Identifier Department Regular Budget Bureau
Code N/A Budget Account Code None Budget
Account Title None Federal Account Symbol
Title N/A Fund Type Code Fund Type Receipt
Account Indicator Receipt Indicator Financing
Account Code Financing Account Code FACTS II
Reportable Indicator None Start
Date Derived Expiration Date Derived
Cancellation Date Derived Authority Duration
Code Derived Apportionment Category
Code Apportionment Category BEA Category
Code BEA Category Borrowing Source
Code Borrowing Source Budget Function/Sub
Function Budget Function/Sub Function Custodial
or Noncustodial Code Custodial/Noncustodial
Code Definite or Indefinite Code Definite/Indefin
ite Code Direct or Reimbursable
Code Reimbursable Flag Reporting Agency
Identifier OUID Reporting Bureau
Code N/A Internal Organization
Code OUID Alternate Internal Org.
Code N/A Strategic Goal Code N/A Program
Code Program Code Apportionment Category B
Program Code Program Code Apportionment Category
B Program Text Program Code Program Report
Category Code Program Report Code Program Report
Category Text Program Report Code
18
SFIS Tutor
  • Description The SFIS tutorial is designed for
    Financial Professionals and Enterprise Resource
    Planning programmers who work with financial
    systems. The multimedia lessons are designed to
    provide background information about the Standard
    Financial Information Structure. Lessons 2-7
    describe the SFIS components and corresponding
    elements within each component required for
    various reporting requirements. The final lesson
    is a culmination of prior lessons, applying the
    information to a practical example buying a
    tank.
  • Prerequisite A basic understanding of the
    Budgeting/Accounting Transaction Life Cycle.
    Lesson 1 SFIS Overview should be viewed prior
    to all others. Once lesson 1 is reviewed lessons
    2-7 can be completed in any order. The summary
    lesson is Lesson 8 - Buying a Tank. This lesson
    is best completed after lessons 1-7 have been
    viewed.
  • Audience The courses are relevant to all DoD
    Financial Professionals and Enterprise Resource
    Planning programmers who work with financial
    systems.
  • http//www.defenselink.mil/bta/products/training/S
    FIS/

19
BackupBusiness Transformation Agency
20
SAP Module Functionality
Funds Management
FM
Sales and Distribution
Investment Management
IM
Supply Materials Management
Financial Accounting
FI
FI
SD
Production Planning
Controlling
MM
CO
Single Integrated Database
AM
Quality Management
PP
Asset Management
QM
Plant Maintenance (MRO)
PM
PS
Project Systems
WF
HR
IS-PS
PAY
Workflow
Human Resources
CATS
Industry Solutions - Public Sector
Time Attendance
21
Scope of Oracles ERP Capability
  • Leverage a common data model that produces a
    single source of truth across the enterprise
  • Provide out-of-the-box cross-functional
    integration that eliminates costly services
    engagements
  • Use flexible, open standards
  • Support modular deploymentby functional area

22
SFIS Attributes and Standard ERP (SAP)
Configuration
Many SFIS Attributes in SAP areLinked to Funds
ManagementMaster Data Configuration (See
Following Slides for Examples)
23
SFIS Attributes and Standard ERP (SAP)
Configuration
In this example An Army OM Fund Master
Recordfor FY2008 OM is created and
Characteristics are assigned to this
fundusing the Classification functionality
SFIS Attributesare Created in theClassification
Systemand then assigned to theFund Master
RecordThis ensures that only allowed values
are used.
This is a Master Data Example of SFIS in SAP
A1
A6 A10
A24
A8
This attributes are now linked to the Fund for
all transactions using that Fund.
24
SFIS Attributes and Standard ERP (SAP)
Configuration
During configuration of the software, Rules or
Strategies are configured to make the system
pick up SFIS elements using STEPS such as
Derivations when transactions are run
1
2
3
4
This is a Derivation Example of SFIS in SAP
TargetFields
5
Unique Groupings of Source Fields will Allow the
derivation of the appropriate SFIS element when
configuration of the system is complete. For
Example If Trading Partner ID is Government
then Fed/Non-Fed will be F.
25
SFIS Attributes and Standard ERP (Oracle)
Configuration
Treasury Main Accounts are defined.
SFIS Main Account
1st
A03
One or more Appropriations are defined as a level
underneath each Main Account.
SFIS Fund Type
A10
SFIS Receipt Indicator
A06
2nd
SFIS Department Regular
A01
A26
SFIS Financing Account Indicator
Used to determine SFIS TAFS Status
A02
SFIS Department Transfer
A18
26
SFIS Attributes and Standard ERP (Oracle)
Configuration
Appropriation specific and lower level attributes
A12
SFIS Authority Type Code
SFIS Definite/Indefinite Flag
A15
T10
SFIS Custodial/Non-Custodial
B09
SFIS BEA Category
A05 A09
B09
SFIS BEA Category
A14
SFIS Borrowing Source
SFIS Apportionment Category SFIS Reimbursable Flag
B01
SFIS Budget Function
Provides link to Treasury Symbol(s)
27
Accounting Classification and Funds Control
Department Regular Main Account Period of
Availability Budget Activity Budget
Sub-Activity Budget Line Item
The SFIS Standard Accounting Classification
uniquely identifies a pot of money that must be
tracked from Budget to execution. The SFIS
Standard Accounting Classification must be
referenced to every financial transaction where
budget authority is used or impacted
28
Funding Transfers
Department Transfer Direct Transfer
Agency Direct Transfer Account Transfer To/From
Department Transfer is used for the transfer of
obligational authority. The transferring agency
retains responsibility for the fund
account. Direct Transfer Agency, Direct
Transfer Account, and Transfer To/From, used
together, are used for the transfer of budget
authority.
29
Chart of Accounts and Financial Statement
Reporting
FACTS I Budget Function/Sub-Function Exchange/Non
-Exchange Indicator Business Partner
Number Non-FACTS I Transaction Type USSGL
Account Number Begin/End Indicator Transaction
Effective Date Transaction Post Date Transaction
Amount Entity/Non-Entity Indicator Covered/Non-Cov
ered Indicator
Custodial/Non-Custodial Indicator Federal/Non-Fed
eral Indicator Debit/Credit Current/Non-Current A
sset Type Asset Unique Identifier Trading Partner
Indicator
30
FACTS II Reporting
Department Regular Main Account Period of
Availability Sub Account Reimbursable Flag Fund
Type Advance Flag Authority Type Availability
Time Definite/Indefinite Flag
Public Law Number Program Report Code TAFS
Status Deficiency Flag Expiration Flag Financing
Account Indicator BEA Category Indicator Foreign
Currency Code Country Code Begin/End Indicator
Borrowing Source Debit/Credit Indicator Direct
Transfer Account Direct Transfer Agency Program
Report Code Transfer To/From Year of Budget
Authority Department Transfer Apportionment
Category Federal/Non-Federal Indicator
About PowerShow.com