# Presentation: 115031

## Interface Crosswalk  

SGL Update

**SGL Update**

**Integrated Contractor Interface Information**

##  Accounting Flexfield (AFF) Features

- Allows funds control and reporting by any of the segments
- Numeric segment values provide flexibility when grouping ranges for query or reporting purposes (e.g. 10000 – 19999, 20000 – 29999, etc.)
- DOE’s current accounting flexfield has 11 segments consisting of 64 characters

**Oracle Accounting Flex-Field (AFF)**

## DOE’s AFF Segments

**Fund (5)**
- Identifies fund type and appropriation for funds control and statutory reporting
- Rolls up to the Treasury appropriation symbol
- Replaces legacy Fund Type
- Examples: 10000=89X0240 (FT TC); 13000=89X4180 (FT VE)
**One-to-One Relationship between legacy values and new values**

**Oracle Accounting Flex-Field (AFF)**

## DOE’s AFF Segments

**Appropriation Year**
- Identifies the four-digit year in which funding is appropriated
- Adds capability to meet new/future Treasury & OMB requirements
- Required by Oracle to handle FACTS-II and upward & downward adjustments
- Examples: 2001; 2002
**Not needed in the Integrated Contractor Interface**

**Oracle Accounting Flex-Field (AFF)**

## DOE’s AFF Segments

**Allottee (2)**
- Represents the allottee to which funds are distributed by HQ budget
- Ranges to be established by cluster
- Replaces legacy Allotment symbol (1st 2 positions)
- Examples: 01=Albuquerque Operations; 31=NETL
**One-to-One Relationship between legacy values and new values**

**Oracle Accounting Flex-Field (AFF)**

## DOE’s AFF Segments

**Reporting Entity (6)**
- Ranges to be established to differentiate between integrated contractor and DOE direct activity
- Replaces legacy Field Office, Reporting Unit, Financial Plan, Local Organization, Cost Center (as used organizationally), and integrated contractor information
- Groups allottee specific information
- Examples: 000001=Albuquerque, Sandia National Lab; 008201=Oak Ridge, Finance Division
- Control segment
**One Reporting Entity per Integrated Contractor**

**Oracle Accounting Flex-Field (AFF)**

## DOE’s AFF Segments

**Standard General Ledger (SGL) (8)**
- Identifies four-digit Treasury account, two- digit DOE sub-account, two-digit reserved for future SGL expansion
- Replaces legacy Balance Sheet Code
- Examples: 1310D100=A/R Direct, OFA; 49010000=Expended Authority, Unpaid
**Summary Class Code (SCC) no longer required.  BSC, Fund Type, SCC, and B&R will determine SGL**

**Oracle Accounting Flex-Field (AFF)**

## DOE’s AFF Segments

**Object Class (5)**
- Represents three digit object class and two digit DOE sub-object class
- Replaces legacy Object Class and Cost Center (as used to breakdown object class information) and includes breakdown of Budget Reference Number prefixes in the last two positions
- Examples: 25200=Other Services; 21103=Local Travel
**OMB value.  Only three digit object class required at this time.  The only exception is for BRN prefixes.**

**Oracle Accounting Flex-Field (AFF)**

## DOE’s AFF Segments

**Program (7)**
- Represents (and replaces) the current B&R code structure and includes Major Items of Equipment (MIE), line item construction (39B&R), and Project Baseline Summary (PBS) information
- Numerous parent/child relationships
- Examples: 0010520=ST0202000, Stable Isotope Services; 0029100=DP0702000 EQU91H1, Radio Conversion
**One-to-One Relationship between legacy values and new values**

**Oracle Accounting Flex-Field (AFF)**

## DOE’s AFF Segments

**Project (7)**
- Identifies and replaces legacy Activity Data Sheets (ADS) and Technical Task Plans (TTP).
- Allows for new project requirements such as Field Work Proposal (FWP), Nuclear Energy Research Initiative (NERI), and Annual Operating Plan (AOP) numbers.
**One-to-One Relationship between legacy values and new values**

**Oracle Accounting Flex-Field (AFF)**

## DOE’s AFF Segments

**WFO or Work for Others (7)**
- Identifies (and replaces) Reimbursable Work Order number and Inter-company Work Orders
- Ranges to be established for the two different types of projects
- Examples:  3200000 = Reimbursable Work Order number 189A91342, Reimbursable Work; 4000200 = Inter-company Work Order number M1NVLL086, Petawatt Laser
**One-to-One Relationship between legacy values and new values**

**Oracle Accounting Flex-Field (AFF)**

## DOE’s AFF Segments

**Local Use (7)**
- Represents and replaces Local Project, B&Rs, and Cost Center (when used to break down project/program activity)
- Includes actual GPP/GPE numbers (BRN type captured in Object Class)
- Allows flexibility on providing lower level information
- Examples:  4010000 = Safety Equipment; 5011000 = GPP, GPD10100305 – Glove Box
**One-to-One Relationship between legacy values and new values, if needed**

**Oracle Accounting Flex-Field (AFF)**

## DOE’s AFF Segments

**Future**
- Default zero filled segment reserved to satisfy future reporting requirements
- No legacy replacement
- No examples
**No place holder necessary in the Integrated Contractor file**

**Oracle Accounting Flex-Field (AFF)**

## Additional Interface Information Required

**Fiscal Month (2)**
**Fiscal Year (4)**
**Contract ID (Purchase Order ID) (7)**
**Trading Partner (OPI) (4)**
**Asset Status (2)**
**Asset Type (3 characters instead of 6)**
**Amount (14)**
**Environmental Liability Type (3)**
**Legacy values to be used**

## 
SGL Update

**SGL Update**

**Integrated Contractor Interface Information**

## SGL Update

**SGL Teams Crosswalk is now in production**
**Draft Proprietary Crosswalk for Integrated Contractors is now available **
**SGL Chart of Accounts has been developed**
**New SGL requirements will be issued**

## SGL Requirements

**Previous guidance requested B&R on all Fund Type 51 records**
**Will now require Source Document Data on all fund type 51 records (e.g.  NETTC)**
**First three positions will be NET followed by the appropriated fund type the Fund Type 51 Data was purchased from**
**B&R data will become optional  **

## SGL Requirements (Continued)

**Add Source-Doc field to all Fund Type 54 records**
**BSC Account 1454 is no longer being used  Balances should be transferred to BSC 112Q and 333Q**

##           Questions/Comments?