SABRS Table Management

Document Sample
SABRS Table Management Powered By Docstoc
					      UNITED STATES MARINE CORPS
            FINANCIAL MANAGEMENT SCHOOL
       MARINE CORPS SERVICE SUPPORT SCHOOLS
                  TRAINING COMMAND
                    PSC BOX 20041
     CAMP LEJEUNE, NORTH CAROLINA 28542-0041




           STUDENT OUTLINE

                  FMRAC 0301

           SABRS TABLE MANAGEMENT

FINANCIAL MANAGEMENT RESOURCE ANALYST COURSE


               REVISED 7/15/10
                           FMRAC 0301
                                Rev 7/10



LEARNING OBJECTIVES:

TERMINAL LEARNING OBJECTIVE: Given financial data elements,
access to Standard Accounting Budgeting and Reporting System
(SABRS) and the reference, maintain local tables in SABRS to
ensure 100% accuracy of financial data in SABRS. (3451-FMGT-
1005)

ENABLING LEARNING OBJECTIVES:

   (1) With the aid of references, identify the key terms related
to accounting system tables to ensure 100% accuracy of financial
data in SABRS. (3451-FMGT-1005a)

   (2) With the aid of references, identify the key concepts
related to accounting system tables to ensure 100% accuracy of
finanacial data in SABRS. (3451-FMGT-1005b)

   (3) With the aid of references, given financial data elements,
verify the appropriate use of the financial data elements to
ensure 100% accuracy of financial data in SABRS. (3451-FMGT-
1005c)

   (4) Given access to SABRS and the references, navigate trhough
SABRS to the SABRS Table Maintenance module to ensure 100%
accuracy of financial data in SABRS. (3451-FMGT-1005d)

   (5) Given access to SABRS, financial data elements and the
references, update SABRS Table Maintenance to ensure 100%
accuracy of financial data in SABRS. (3451-FMGT-1005e)

   (6) Given access to SABRS, financial data elements and the
references, validate SABRS Table Maintenance to ensure 100%
accuracy of financial data in SABRS. (3451-FMGT-1005f)

1. INTRODUCTION TO TABLE MANAGEMENT:

   a. Tables are important to SABRS. Tables hold information
through which SABRS validates financial transactions. The
purpose of tables in SABRS is to validate transactions, ensure
system security and to assist in reports distribution.

   b. The SABRS main menu provides the user with SABRS table
management processes. The first SABRS table management option
under option #6 from the SABRS main menu will take you to SABRS
table menu. You would select option #1 SABRS tables which will
bring you to the SABRS Table Maintenance Main Menu. Within this


                                   2
                            FMRAC 0301
                               Rev 7/10



menu there are options to access tables that drive the SABRS
financial system to ensure 100% accuracy of financial data.

   c. There are two (2) tables groups: central tables and local
tables.

     (1) Central tables contain mostly fiscal codes and
financial information used by all Financial Managers throughout
the Marine Corps. These tables are maintained by DFAS-Cleveland
HQMC, RFA and in order to edit and/or update the tables you must
first submit a formatted request up a sequenced chain for change
approval.

     (2) Local tables are used by the local accounting activity
and provide users with data specific to the activity. Data on
these tables apply to the lowest levels of accounting and are
subject to periodic maintenance and updates. Local tables are
maintained by authorized local personnel(i.e. Comptrollers). In
many cases, only a qualified technician will be granted access
to table maintenance because of the importance of tables to the
proper operation of SABRS.

   d. DFAS has provided a SABRS manual to assist users in table
maintenance; SABRS O&M central/local tables. This manual covers
each table and show, step-by-step, how to add, change and delete
table records. The manuals are available on-line at
https://dfas4dod.dfas.mil/systems/sabrs/manuals3.htm.

2.   TABLE MAINTENANCE PROCEDURES:

   a. To access the table management process, the user's profile
must be authorized. The user performing local table maintenance
on the tables must be loaded to Table 502 Local Update Table.
View these tables to ensure your User-Id is loaded. If not,
request access through HQMC, RFA because these tables are
central tables.

   b. Accessing SABRS you will see the Main Menu below. To
perform maintenance on SABRS non-O&M tables, enter Option #6.




                                  3
                                         FMRAC 0301
                                              Rev 7/10



 10:09:31                           SABRS                              DFMS0000
 21 Nov 05                        MAIN MENU                            DFPS0000
  -------------------------------------------------------------------------------

 SELECT AN OPTION: __

                   1.   AUTHORIZATION PROCESSING
                   2.   BUDGET EXECUTION ACTIVITY AUTHORIZATION PROCESSING
                   3.   INITIATIONS/COMMITMENTS/OBLIGATIONS/EXPENSES
                   4.   CORRECTION PROCESSING
                   5.   REPORTS INQUIRY
                   6.   TABLE MANAGEMENT
                   7.   ONLINE ALLOCATIONS
                   8.   REIMBURSABLES
                   9.   O&M TRVL/ALLOCATIONS

     FASTPATH==> ________________________________________________________________
 PF1=HELP,PF6=EXIT



     (1) Once you have entered Option #6, you will encounter
the screen below. From there you will enter the short name or
number of the table you want. Or, you can press enter and a
list of the SABRS tables will appear. From there you can enter
a “X” in the space provided next to the table.


    09:10:51                           SABRS                              DFMT0000
    22 Nov 05               TABLE MAINTENANCE MAIN MENU                   DFPT0000
   -------------------------------------------------------------------------------
   ENTER A TABLE NAME/NUMBER HERE: __________


    (OR LEAVE BLANK TO RECEIVE A LIST OF TABLE NAMES)




     (2) Once your selected table appears, you have 3 options:
Add (A), change (C) or delete (D). In a highlighted space on
the selected table (each table is different), you can enter the
A, C, or D and perform the required maintenance.




   FASTPATH==>
  ________________________________________________________________
   PF1=HELP,PF3=PREV,PF4=MAIN,PF6=EXIT




                                                 4
                            FMRAC 0301
                               Rev 7/10




4. SABRS Local Tables:

   a. There are many local tables and we will not discuss every
table available in SABRS in this outline. We will focus our
efforts on the local tables required to establish a new Budget
Execution Activity (BEA) and User-ID and prepare them for
spending.

   b. Tables must be loaded in a sequential order because tables
check each other for accuracy. For example, if you load out the
FIP table and input a BEA that was not loaded first, you will
encounter an error stating that the BEA is not loaded. The
following is a list of local tables required to establish a new
BEA and User Id and prepare them for processing spending
transactions:

    (1) Establishing tables for the BEA and User ID:

TABLE SHORT NAME     TABLE NUMBER      TABLE TYPE
USER-DFLT               224            SABRS local
AUTHSPEND          204            SABRS local


    (2) Establishing tables for spending transactions:

TABLE SHORT NAME     TABLE NUMBER      TABLE TYPE
M-DSSC-FIP         0F2            O&M local
M-FIP-XREF         030            O&M local


                                  5
                                                  FMRAC 0301
                                                        Rev 7/10



     (3) Table 224: USER-DFLT Maintenance Table:                                    This table
allows a user access to the newly loaded BEA.

 10:07:09                         SABRS                                DFMT224A
 21 Nov 05                USER-DFLT MAINTENANCE                        DFPT224M
 ------------------------------------------------------------------------------
  SEARCH KEY: _TGF0GC_________________________________________________
                   FUND    OBJ-CLASS SUB    BUD-EXEC BUD-EXEC BUR-CTRL
  ACT USER-ID      FUNC      CODE     HEAD    ACTY    SUBACTY      NO
  --- --------   -------- --------- ---- -------- -------- --------
   _ A0ND46      R001         260     NC2A               00      8A004
   _ BACO07      27H002       250     27H0     BF        10      10199
   _ BACO22      27H002       260     27H0     BF        10      10199
   _ DBBF06      144088       260     4588     04        04      00042
   _ GFF028      27C001               27C0     60        10      10701
   _ GR2F07      27H002               27H0     TX        10      10508
   _ G9A1JG      01A0         117     2701     61        10      11691
   _ G9A1JM      2700002      260     2700     90        10      67026
   _ G9A1J4      R00128       260     NC2A     J3        10      8A005
   _ G9A1J9      27C010       110     27C0     90        10      10004
   _ PJSC07      05A0         260     2741     KB        10      31198
   _ TGF0GC      1A1A         260     27A0     94        10      67026



     (4) Table 0F2 M-DSSC-FIP Maintenance Table (if DSSC): If
the new BEA is requiring DSSC supplies, it will be issued a DSSC
credit card with a Job Order Number (JON). In order for SABRS
to accept these transactions from DSSC, a JON with a
corresponding FIP must be loaded to this table. DSSC works off
JON’s and SABRS works off FIPS. When this table is loaded,
SABRS will check the JON from DSSC and match it against this
table. When SABRS finds the JON, SABRS will extract the FIP
that corresponds to that JON and process the transactions.


 10:24:13                     SABRS REPORT                            GFSMU101
 21 Nov 05             TABLE: M-DSSC-FIP ( 0F2 )                      GFSPU120
  _______________________________________________________________________________
  SEARCH KEY> M99255_________________________________________________
   MA-KEY FC SERIAL EXP JO-WC MAC     FA WC FC OCSOC CAC BRC JNLU RON RBC
  _______________________________________________________________________________


  M99255   BQ   94000171   T   10   M99255   94   10   BQ   26A0   G4LS
  M99255   BQ   94000171   T   50   M99255   94   50   BQ   26A0   G4LS
  M99255   BQ   94000272   T   50   M99255   94   50   BQ   26A0   G4LS
  M99255   BQ   AA00930A   T   AA   M99255   AA   10   BQ   26A0   G4LS   0AA   A
  M99255   BQ   AA00930B   T   AA   M99255   AA   00   BQ   26A0   G4LS   0AA   B
  M99255   BQ   AC00960A   T   AC   M99255   AC   00   BQ   26A0   G4LS   0AC   A
  M99255   BQ   AC00960B   T   AC   M99255   AC   00   BQ   26A0   G4LS   0AC   B




     (5) Table 204 AUTHSPEND Table: This table loads the DIC’s
that will enable the user to process transactions (spending and
authorization). An example is provided below:




                                                            6
                                        FMRAC 0301
                                             Rev 7/10




     (6) Table 502 LOCAL-UPD Maintenance Table: This table
allows a user to update non-O&M local tables. This is a central
table that can only be established by DFAS. A user can make
additions, changes or deletions to any non-O&M local table.


 10:30:49                         SABRS                               DFMT502A
 23 Nov 05                LOCAL-UPD MAINTENANCE                       DFPT502M
------------------------------------------------------------------------------
 SEARCH KEY: TGF0GC__________________________________________________
                 MCC     ALLOT   SUBALLOT WORK
 ACT USER-ID RECIP-ID RECIP-ID RECIP-ID CTR-ID
 --- -------- -------- -------- -------- -------
  _   TGF0GC
  _   TKAC02
  _   TKAC05
  _   TKAC06
  _   TKAC07
  _   TKAC08
  _   TKAC09
  _   TKAC11
  _   TKAC12
  _   TKAC13




 FASTPATH==>
SUMMARY
________________________________________________________________
 PF1=HELP,PF2=PRINT,PF3=PREV,PF4=MAIN,PF6=EXIT,PF7=PGUP,PF8=PGDN
      Thus far, we have covered the introduction to Table
Management, table identification, table maintenance procedures,
SABRS local tables, purpose of tables and why they are
important; identification of tables in SABRS, groups of tables;
various local tables; how to load tables and finally the


                                                7
                           FMRAC 0301
                              Rev 7/10



sequential order in which they must be loaded. With this
knowledge that you have gained, I am confident that you can
ensure the security and validity of all SABRS transactions for
your unit. At this time fill out an instructional rating form
then take a break.

References:
SABRS
                            NOTES
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________
________________________________________________________________


                                 8

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:29
posted:5/25/2012
language:
pages:8