Stock Training Manual - PDF by mml13993

VIEWS: 8 PAGES: 30

More Info
									Systems Training Manual

                    DFAS Rome

                             For

                         ATLAS

        Accounting Transaction Ledger Archival System

              STANFINS Data Query
         STANdard FINance Systems-current (Army)

                           EDA

                 Electronic Document Access

                          OLRV

                  On Line Report Viewing


                     A Desktop Guide

                        Prepared by

   DFAS Rome Accounting Directorate & Systems Office

                      December 2003
                                              Overview


This manual has been developed to provide a guide for budget personnel in the use of four of the available
data archive systems: ATLAS, EDA, STANFINS DATA QUERY and OLRV.
Each customer site and computer system is different. This manual is only a guide; each individual
computer system may be different.



                                     ATLAS (Page 5)

                        Accounting Transaction Ledger Archival System

ATLAS was developed as a method to easily query information that is no longer available on Army
Standard Information Management System (ASIMS). The ATLAS files for DFAS Rome serviced
installations contain the NXG (Non-Stock Fund Open History Records) by month. The program easily
exports data to STANFINS for data input or EXCEL for data manipulation.



                             STANFINS DATAQUERY (Page 8)
                            Standard Finance Systems-current (Army)

DATAQUERY is a software product developed by Computer Associates, Inc. It is a powerful, easy-to-
use tool for accessing most information in the Army Standard Information Management System (ASIMS)
database. DATAQUERY contains: the APC Master File (AXW); the Non Stock Fund Open History
records (NXG); the Non Stock Fund Closed History records (AX5); the Non stock Fund Orders and
Payables (LXG); the General Ledger Details record, prior month’s business, (AJU); Current Status of
Accounts by Appropriation (BXU) – note: information from this file creates the 218 report: and the ARP
Customer Master Record (FXW).



                                          EDA (Page 20)

                                    Electronic Document Access

Electronic Document Access acts as an electronic file cabinet for the storage and retrieval of documents.
EDA replaces the paper process by providing a single, read-only electronic file that can be accessed by
any authorized user. EDA is an on-line web based system. The system provides storage and retrieval of:
post-award contracts; contract modifications; personal property and freight Government Bills of Lading
(GBLs); Commercial Pay Vouchers; Travel Pay Vouchers; Contract Deficiency Reports (1716s); Materiel
Acceptance and Accounts Payable Reports (MAAPRS); and army Direct Vendor Deliveries (DVDs).




                                                                                                        2
                                       OLRV (Page 23)

                                     On Line Report Viewing

On-Line Report View (OLRV) is the DFAS standard paperless initiative. The process uses a commercial
off the shelf (COTS) software product called Report.web. OLRV takes the data normally printed out of
STANFINS and generates an electronic copy of the report that can be viewed on your desktop PC through
a web browser. This is a useful tool to view the Non-Stock Fund Orders & Payables, Fund Status reports,
and other reports generated from STANFINS cycles.



                                     DISA FORM 41        (Page 29)

The DISA Form 41 is the DoD official System Authorization Access Request (SAAR) Form. The
information will be used to verify that you are an authorized user of a Government automated information
system (AIS) and/or to verify your level of Government security clearance. This form is needed for EDA,
OLRV and STANFINS Dataquery.




                                                                                                      3
                                Quick Reference Guide

Contracts            EDA Æ        Contract search ……………………………………….. Page 20

Fund Status          OLRV Æ       AVK 30 Prior year……………………………………. Page 23
                                  AVK 51 Current year, by appropriations/ASN
                                  AVK 52 Current year, by appropriations by program director
                     STANFINS Æ   BXU Query…………………………………………….. Page 8

Travel history        ATLAS Æ     Query by beginning Doc number ……………………… Page 5
 By doc number        EDA Æ       Vouchers Æ         by Document Number …………… Page 20
 By Social Security # EDA Æ       Voucher Travel Æ by Social Security Number
 By Dov #             EDA Æ       Voucher Travel Æ by Dov Number
Backup for Rome EDA Æ             Voucher Travel
  travel vouchers

Payroll Current      STANFINS Æ   NXG Query…………………………………………….. Page 8

What processed       STANFINS Æ   NXG Query ………………………….………………… Page 7
 in the last cycle

What didn’t          OLRV Æ       AVK018 Daily Preliminary Balance report ………….. Page 23
 Process

Something old        ATLAS Æ      Query by appropriate condition (DOC, EOR, etc)….….. Page 5
(Research)
Obligations          STANFINS Æ   NXG, BXU, LXG……………………………………… Page 8
                     OLRV Æ       AVK131 ……………………………………………….. Page 23

APC                  OLRV Æ       AVK774 master file,…………………..……………….. Page 23
                                  AVK003 update; AVK006 error report
                     STANFINS Æ   AXW Query ……………………………………….….... Page 8

Reimbursement        STANFINS Æ   FXW Query …………………………………………….. Page 8
                     OLRV Æ       AVK024 ARP exception report,……………………...… Page 23
                                  AVK126 weekly

Monthly Report       OLRVÆ        AVK329 Status of AOB CSCFA 218….………………. Page 23
                                  AVK295 Status of REIM 112 pt 3-8
                                  AVK296 Status of REIM 112 pt 1-2

Payments             EDA Æ        Voucher Æ          by Voucher Number……………… Page 20
                     EDA Æ        Voucher Æ          by Document Number
                     EDA Æ        Voucher Æ          by Contract Number

DISA 41 Form         ……………………………………………………………………………… Page 29


                                                                                               4
        Accounting Transaction Ledger Archival System (ATLAS)
What is ATLAS?
ATLAS is an off line system for data storage. The data is stored on the customer’s local
network and will require file maintenance.

Where does the data come from?
The data for ATLAS comes from the STANFINS current month transaction file, all type
actions (NXG). Available files are shown by month. Most of DFAS Rome supported
installations have ATLAS files that date back to 1996.

Why use ATLAS?
The advantage of using ATLAS is a complete history of a document number can be
retrieved at one time.

How to get access to ATLAS?
Contact the Rome-Help Desk for information on obtaining a copy of the ATLAS
software and computer system requirements. A Rome systems technician will contact
you. ROME-HELPDESK@DFAS.MIL

Where to go for more information on ATLAS?
The Rome Customer Service Guide and your servicing Rome Accounting Branch can
provide more information on ATLAS.
https://dfas4dod.dfas.mil/centers/dfasin/rome/customerservice

How to use ATLAS:

Note: ATLAS is a DOS based program. The mouse will not work. All selections must
be made using the keyboard. Use the directional arrows to move around in the menus
and use the <Enter> key to select the highlighted item. Each selection has a highlighted
letter. Pressing that letter on the keyboard will also select the item. On many of the
screens the footer information contains shortcut keys for mass selections or de-selections.
The space bar is used to tag items in the installation and month screens.
When running a query, it will run faster if indexed fields are used. The indexed fields
are: Standard document number (DOC_NO); fiscal year and APC (FAPC); Element of
Expense (EOE); Type action (TA); block number (BLK); and Voucher number (DOV).

Step-by-step Instructions:
1.	 Double-Click on the ATLAS icon to open.
2.	 Hit any key when the ATLAS version/information screen comes up.
3.	 Hit any key when the security screen comes up.
4.	 The “Files” menu will be selected (highlighted), press <Enter>.
5.	 The "NXG-STANFINS" menu will be selected, press <Enter>. Note: ATLAS was
    built to hold other databases, such as the APC Master File, but currently most of the
    DFAS Rome supported installation’s ATLAS files have only been loaded with the
    NXG files.


                                                                                            5
6.	 The installation will be pre-selected (Highlighted). Press <Enter>.
7.	 Use the directional arrow keys and the <Space> bar to tag the monthly files to query
    on, or use the shortcut keys noted in the footer for a mass selection and press
    <Enter>.
8.	 The “Query” menu will be selected. The “Display Fields” and “Sort Order”
    commands are optional, if you wish to change the way the report is viewed, see
    below, otherwise use the directional arrow keys to navigate down to the “Condition”
    command, press <Enter>.
    a.	 The “Display Fields” command. This command allows you to change which
        fields are displayed and what order they are displayed in. The default is to display
        all the fields in the following order: DOC_ NO, FAPC, EOE, TA, F, AMOUNT,
        T, LIC, ODC, BLK, JULIAN, DOV, MNHRS, AFCR, FAC LC, DEPT, BSN,
        LIMIT, PY, OA RD, ASN, PE, FSN, PFC, ORG, FILDATES, DR MARKERS.
        To change the fields:
                 1.	 If necessary, use the directional arrow keys to move to the “Display
                     Fields” command, press <Enter>.
                 2.	 You will see that all of the fields are in the right hand box titled
                     “Selected Fields”. The footer box contains directions on how to
                     add/remove fields. To remove all the fields, use the <F10> key. You
                     will see that the fields move to the left-hand box titled “Available
                     Fields.” Use the directional arrow keys and the <Space> bar to select
                     the fields.
                 3.	 When you have the fields you want, in the order you wish to view
                     them, press <Esc>.
    b.	 The “Sort Order” command. The default sort order for ATLAS is a numeric-
        alpha sort of the DOC_NO field. To change the sort order:
                 1.	 If necessary, use the directional arrow keys to move to the “Sort
                     Order” command, press <Enter>.
                 2.	 You will see the “Available Fields” in a box on the left. The footer
                     box contains instructions on how to add the fields to the sort. As you
                     add them you will notice the fields will move to the right-hand box
                     titled “Selected Fields”. Use the directional arrow keys to navigate to
                     particular fields.
                 3.	 When you have the fields you want, in the order you wish them to be
                     sorted in, press <Esc>.
9.	 The “Condition” command. This is where you give the information you want to
    query on.
10. Highlight "Add Condition" and press <Enter>. This will display the list of
    available fields/search criteria.
11. Use the directional arrow keys to move to the appropriate field and press <Enter>.
12. Select the qualifier (begins with, equal to, etc.) for the field and press <Enter>.
13. Type in the specific search criteria and press <Enter>.
14. You may choose additional query criteria. Highlight "Add Condition" and press
    <Enter>. A decision box will come up, you must choose “AND” or “OR”. The
    “AND” is used if there is another field that needs to be found in order to satisfy the
    query needs (ex. EOE = ‘21T2’ .AND. TA = ‘21’. The “OR” is used if there is



                                                                                          6
    another set of criteria that is needed to satisfy the query (ex. EOE = ‘21T1’ .or. EOE
    = ‘21T2’. The “Add Condition” screen also gives the option to “Edit Condition”
    or “Delete Condition”, you may return to this spot to use these commands when you
    need to alter the query criteria. Selecting either of these commands will highlight the
    first query condition in the list, if you wish to alter or delete one of the other
    conditions, use the directional arrow keys to move to the other condition before
    pressing <Enter>.
15. When you have finished adding query criteria: use the directional arrow keys to move
    to the “EXIT” command at the lower right corner of the screen and press <Enter>;
    or press the <Esc> key.
16. The main screen will reappear, the Query menu will be open, and the “Execute
    Query” command will now be available. Navigate to it by using the directional
    arrow keys and press <Enter>.
17. A decision box will appear asking "Start NEW Results File?" Select “NEW” and
    press <Enter> to execute the query.
18. When all months have been searched that were selected in Step 7, a decision box will
    appear asking, “Search additional months?” Unless you made a mistake in Step 7,
    press <Enter>.
19. A decision box will appear asking “Easy-View/Print Results Now?” “NO” is
    preselected. Press <Enter>. (The Easy-View is NOT easy to view.)
20. This will return you to the main screen with the Output menu selections visible.
    “View/Browse Records” command is highlighted.
    a.	 To view the records on your screen press <Enter>. Use the directional arrow
         keys and the <Page-Up>, <Page Down> keys to move around in your report.
         The footer of the report explains which shortcut keys can be used while viewing.
         Note: pressing the “Q” key will print your report without having to return to the
         Output menu.
    b.	 To print the results. Using the directional arrow keys, select ”Printer/FAX/File"
         and press <Enter>. There will be a series of small boxes appearing asking
         various questions. Read and answer the questions accordingly. The results will
         print out in a landscape format.
    c. 	 Saving your results in Excel. Under the Output menu, select
         "EXCEL/Lotus/Quattro" and press <Enter>. Using the directional arrow keys,
         select the program to save it to. If you have a higher version than is listed, select
         the highest version available. A small box will appear asking for the filename.
         Type in the path and name you desire. e.g.: C:\Roy\Result.xls




                                                                                            7
                           STANFINS DATAQUERY

What is STANFINS DATAQUERY?
STANFINS DATAQUERY is a data access system. It holds the current STANFINS
APC and Customer Number master files, Non-stock Fund Orders & Payables, Fund
Status, and Annual Reimbursement Program.

Where does the data come from?
The data for STANFINS DATAQUERY comes from the files as produced in each
STANFINS cycle.
STANFINS data files:
File               Description Name
NXG        Current month transaction file. Contains all transactions
AX5        All transactions dropped from the NXG. Records are retained in this file 6
           months after liquidation from the Non stock Fund Orders & Payables file.
           Does not contain TA 20s and 29s.
LXG        Non-stock Fund Orders & Payables undelivered orders/accounts payables
AJU        General ledger detail records (prior month).
BXU        Subsidiary Ledgers – Ledger Code records 1-27. This file contains current
           status of accounts by appropriation. Information is used to create the 218
           report. (BSN 2020 = ledger code 1, BSN 0725 = ledger code 26, most
           other BSN = ledger code 25)
FXW        This is the Annual Reimbursement Program Customer Master Record.
           This file contains the current status of Reimbursements. This file is used to
           create the CSCFA 112 Report.
HXG        Annual Reimbursement Program detail records. Contains all current
           month reimbursement transactions.
AXW        System APC Master File.
JXG1       Contains TBO current month detail records. This file can be viewed by
           TL NUMBER /DSSN.
JXG2       Contains TBO current month KC card file. This file can be viewed by TL
           NUMBER/ DSSN.




                                                                                      8
Why use STANFINS DATAQUERY?
STANFINS DATAQUERY is very easy to use. There are numerous pre-made queries
that do not need any modifications before use. STANFINS DATAQUERY has a wild
card character (#) that can be used anywhere in a data field in order to determine a
specific unknown character. It provides the most current information from the master
files.

How to get access to STANFINS DATAQUERY:
See Chapter 1, Section 15 of the Rome Customer Service Guide
https://dfas4dod.dfas.mil/centers/dfasin/rome/customerservice or contact the Rome-Help
Desk for information on computer system requirements. A Rome systems technician will
contact you. ROME-HELPDESK@DFAS.MIL

Where to go for more information on STANFINS DATAQUERY:
The STANFINS DATAQUERY users manual can be found at:
https://dfas4dod.dfas.mil/systems/srd1

How to use STANFINS DATAQUERY:

Standard queries for each of the major STANFINS data files are resident in each
database. Examples of these queries are at the end of the step-by-step instructions for use
of an existing query. There are numerous other queries that have been made “Public” by
their creators. Any user may use all queries that have been saved as “Public”. STANFINS
DATAQUERY is case sensitive, but it will default to CAPS when pushing the <Enter>
key, it is not necessary to have your cap locks on.

Step by Step Instructions for use of an existing query:

1.	 Double click on the “Floatlu” icon.
2.	 Click on the appropriate DMC for your database to select it.
3.	 Click “OK”
4.	 Enter the two-letter code for the appropriate database. Press <ENTER>.
5.	 The security screen comes up. Press <ENTER>.
6.	 Enter your UserID, Password, and Acct name. Press <Enter>.
7.	 Use the <Page Down> key and the directional arrow keys to move to the _ beside the
    Session ID for your database. Press <Enter>.
8.	 Type: DQRY. Press <Enter>.
9.	 Type in your User ID. Press <Enter>.
10. The cursor will be at the _ after “ENTER THE NUMBER OF THE DESIRED
    FUNCTION ===>”. Type: 1. Press <Enter>.
11. The cursor will be at the _ in front of “_ Queries and Terms      - List all queries and
    terms accessible to you.” Press <Enter>.
12. The screen opens to the list of queries. Navigate to the query you would like to use.
    Note: there are more than one installation’s files in each DMC database, you must use
    a query that was built for the installation that you have access for. In the first
    statement of the query, the FIND statement, a table will be listed (NXG, LXG, etc.)



                                                                                          9
   followed by a 3-character number. This number is the STANFINS Database ID. It

   identifies a specific installation.

   For: Fiscal Station Number           Use: STANFINS Database ID

        01088 	                              040
        09076 	                              071
        14021 	                              098
        15056 	                              034
        18043 	                              039
        30093 	                              082
        30145 	                              093
        31001 	                              022
        36004 	                              048
        38042 	                              050
        44008	                               061
        45016	                               090
        91089	                               071
        92032	                               072
        92033	                               073

   To navigate to the query:
   a.	 You can use the <Page Down> key and the directional arrow keys.
   b.	 Or if you know the complete name of the query, at the => symbol, type: ED a
       space and then the name of the query (EX: =>ED MLS-FXW).
   c.	 Or if you know what the name of the query starts with (many people save the
       queries with a name starting with their initials), press the <TAB> key and type in
       the start of the name, and then press <ENTER>, then use the <Page Down> and
       the directional arrow keys.
   d.	 Press <Enter>.

12. Fill in the wild characters (#) in the fields for which you would like to narrow the
    search. The more narrow the search, the less time it will take the query to run.
    Warning: you do not want to run a standard LXG, AX5, AJU, BXU or NXG query
    without narrowing the search, it will take too long to load the entire master file.
13. Press <F3> to execute the query.
    If you get the message:
    “DQ804E - YOU ARE NOT AUTHORIZED TO ACCESS THIS TABLE”, you
    have attempted to use a query for the wrong installation (see the Note in Step 12),
    change to a query that is built for your installation.
    If you get the message:
    DQ180I - QUERY EXECUTION WAS STOPPED BECAUSE NO ROWS
    WERE FOUND, nothing matched your search criteria, modify the search and try
    again.
    If you get the message:
    Press the appropriate PF key.

    --------------------------------------------------------------------------DQE50

    DATAQUERY: DATA SELECTION STATUS




                                                                                       10
    -------------------------------------------------------------------------------
    Number of rows selected ====> 000002468
    Press PF3 to end SELECTION and report on only the rows selected so far.
    Press PF4 to continue execution of the SELECTION step.
    It is best to press <PF4> until you get all the rows that match your criteria, but if you
    know how many rows you were expecting to find and it matches you can shortcut the
    process and press <PF3>.
15. If you have not suppressed the Execution panel, you will need to press <F3> again.
16. Press <F3> again to get the summary information for the query.
17. You can print the results of your query by using the print screen icon or by pressing
    the <ALT> and the <P> keys simultaneously.
18. Press the <F2> button to return to the previous page.




                                                                                           11
Standard STANFINS Queries
LXG FILE:
This query gives you open lines on the Non Stock Orders and Payables listing (AVK-
602).

NAME: LXG-QUERY            TYPE: QUERY STATUS: PUBLIC
DESCRIPTION: SEARCH NON-STOCK/AVK-602

================================ T O P===========================
01 FIND LXG034 WITH DOC-NO ='##############' AND FY = '#' OA = '##'
02 ASN = '####' APC = '####' EOE = '####'
03 SORT BY (ASN)(FY) EOE APC DOC-NO
04 PRINT FY 'Y' EOE 'EOR' APC ODC 'O' DOC-NO OBLIG PIC '$$$$,$$9.99-'
05 ACCRUAL PIC '$$$$,$$9.99-' DISB '$$$$,$$9.99' OA ASN
=========================== B O T T O M=========================


LXG FILE (NULOs):
This query will give you all the lines on the LXG file where the disbursement exceeds the

obligation.


NAME:     NEGATIVE-UNLIQ         TYPE: QUERY STATUS: PUBLIC

DESCRIPTION: IDENTIFY NEGATIVE UNLIQUIDATE OBLIGATIONS ON LXG


================================ T O P==========================

01 */THIS STANDARD QUERY IDENTIFIES THE NEGATIVE UNLIQUIDATED

02 WITHIN THE LXG FILE OF STANFINS. CHANGE THE # SIGNS TO THE

03 APPROPRIATE DATABASE ID.WRITTEN BY TIM ALLMAN, DSN 699-6932

04 05/29/2001               /*

05 FIND ALL LXG### OBLIG GTE '0.00' (OBLIG - DISB) LT '0.00'

06 EOE NE '41##' '46##' '49##' OA NE '01' LC NE '17' '21' PE NE '9966'

07 SET NULO (11.2) = OBLIG - DISB

08 SORT (FY DEPT BSN LIMIT) APC EOE DOC-NO

09 PRINT TITLE 'NEGATIVE UNLIQUIDATED REPORT'

10 FY APC EOE ODC

11 (NULO) 'NULO' PIC 'ZZZ,ZZZ,ZZ9.99-'

12 (OBLIG) 'OBLIGATIONS' PIC 'ZZZ,ZZZ,ZZ9.99-'

13 (DISB) 'DISBURSMENTS' PIC 'ZZZ,ZZZ,ZZ9.99-'

14 DOC-NO OBLIG-DATE 'OBLIG/DATE' DISB-DATE 'DISB/DATE' DEPT FY

15 BSN LIMIT PE 'PROGRAM/ELEMENT'

=========================== B O T T O M =========================


Note: Information that is contained between the */ /* symbols is for your information

only, it is not part of the query and does not affect its execution.



                                                                                         12
AXW FILE:
This query gives you the APC Master File Information (AVK 774):

NAME:     AXW-QUERY            TYPE: QUERY STATUS: PUBLIC

DESCRIPTION: AXW APC MASTER FILE


================================ T O P===========================
01 FIND AXW034 FY ='#' APC ='####' BSN = '####' LIMIT = '####' LC = '##'
02 PRINT FY APC FAC D-CODE ACCT-CLASS PY AMS CR-FY CR-APC
03 SPEC-PROJ LC RSC1MPE-218-ANN 'MDEP-LVL' EXP-218-ANN PD-MAJ PD-
04 MIN CDE-78 DESCPT CAOB-LEVEL CUST-NBR FUNC-COST MWR-CD LOC
05 INSTAL-CD EXP-218-MON MPE-218-MON
06 RCN 'MDEP' FUND-CNTL-LV TDA GEO-AREA UIC CEIL-218-MON
07 CEIL-218- ANN
=========================== B O T T O M =========================

NXG FILE:
This query identifies transactions posted in the current month.

NAME:     NXG-QUERY          TYPE: QUERY STATUS: PUBLIC

DESCRIPTION: NXG CURRENT MONTH TRANACTIONS


================================ T O P===========================
01 FIND NXG034 DOC-NO = '##############'
02 APC = '####' EOE = '####'
03 SORT (TA) JUL-CYC-DATE
04 PRINT TA BLK FY EOE APC DOC-NO ODC DOV (AMOUNT)
05 JUL-CYC-DATE 'DT'
=========================== B O T T O M =========================

AJU FILE:
This query identifies transactions posted in the previous month.


NAME:        MLS-AJU                TYPE: QUERY STATUS: PUBLIC

DESCRIPTION: PREV MONTH INPUT

================================ T O P ==========================

01 FIND AJU022 WITH APC = '####' EOE = '####'BLK = '###'TA = '##'

02 FY = '#' DOV = '######'

03 DOC-NO = '##############'

04 SORT BY (TA)

05 PRINT TITLE 'AJU' FY 'Y' APC EOE DOV DOC-NO (AMOUNT) PIC

06 '$$$,$$$,$$9.99' TA BLK AFCR 'C' ODC 'O' JUL-CYC-DATE 'DATE'

=========================== B O T T O M ========================





                                                                      13
AX5 FILE:
This query identifies transactions from the previous 6 months.


NAME:     MLS-AX5            TYPE: QUERY STATUS: PUBLIC

DESCRIPTION: AX5 BY DOC FY BLK DOV EOE


================================ T O P==========================

01 FIND AX5022 WITH APC = '####' EOE = '####' DOC-NO =

02 '##############' TA = '##' FY = '#' BLK = '###'

03 DOV = '######' AND JUL-CYC-DATE GTE '#####'

04 SORT DOC-NO

05 PRINT TITLE 'AX5'

06 APC EOE DOV DOC-NO (AMOUNT) AVK022MD$ BLK

07 FY JUL-CYC-DATE 'DATE' TA IBOP

=========================== B O T T O M ========================



BXU FILE (Funding):
This query gives totals for obligations, accruals, disbursements and funding, to include
inception figures. The data is used to prepare the 218 report.


NAME:     BXU-FUNDING           TYPE: QUERY STATUS: PUBLIC

DESCRIPTION: 218 ALLOT FUNDS AVAIL


================================ T O P===========================
01 FIND BXU034 OA = '##' FY = '#' ASN = '####' AMS11 = '###########' RT = 'D'
02 BSN = '####' SET ACCR (10.2) = ACCR-INC + ACCR-FYTD + ACCR-CM
03 SET ANN (10.2) = ANN-PROG
04 SET ALLOT = ALLT-ORD-FYTD + ALLT-ORD-INC
05 SET OBLIG (10.2) = OBLIG-INC + OBLIG-FYTD + OBLIG-CM + DEOB-FYTD
06 + DEOB-CM
07 SET DISB = DISB-INC + DISB-FYTD + DISB-CM-BY-US + DISB-CM-BY-OTH
08 DISB-CM-BY-INT SET AVAIL (10.2) = ANN - OBLIG
09 SORT (ASN) (BSN) (AMS11) (APC) PRINT BSN EOR
10 (ALLOT) PIC '$$$,$$$,$$$,$$9.99-' (ANN) PIC '$$$,$$$,$$$,$$9.99-'
11 (OBLIG) PIC '$$$,$$$,$$$,$$9.99-'(ACCR) PIC '$$$,$$$,$$$,$$9.99-'
12 (DISB) PIC '$$$,$$$,$$$,$$9.99-' (AVAIL) PIC '$$$,$$$,$$$,$$9.99-'
=========================== B O T T O M =========================




                                                                                           14
FXW QUERY:
This query will pull various data elements related to the Customer Number Master file
(AVK 778):


NAME:     MLS-FXW          TYPE: QUERY STATUS: PUBLIC
DESCRIPTION: CUSTOMER NUMBER ETC.

 ================================ T O P==========================
01 FIND FXWAVK01-R-022 RECORDS WITH CUST-NBR = '######' RSC = '###'
02 AUTHORITY ='##############'PROG-DIR = '#' ACTIVITY-CODE = '#'
03 SET TOTAL-ORDERS (9.2) = ORDERS-INC + ORDERS-FYTD + ORDERS-CM
04 SET TOTAL-EARNINGS (9.2) = REIMB-INC + REIMB-FYTD + REIMB-CM
05 SET TOTAL-TRANS (9.2) = TRANS-INC + TRANS-FYTD + TRANS-CM
06 SET TOTAL-COLLECTIONS (9.2) = COLL-INC + COLL-FYTD +
07 COLL-STA-CM +COLL-OTH-CM + COLL-IF-CM
08 SET UNFILLED-ORDERS (9.2) = TOTAL-ORDERS - TOTAL-EARNINGS
09 SET ACCTS-REC (9.2) = TOTAL-EARNINGS + TOTAL-COLLECTIONS
10 + TOTAL-TRANS SORT CUST-NBR DISPLAY CUST-NBR CUST-NAME
11 CUST-ADDR CITY-STATE-ZIP ACT-CLS-OFC-BLD ACT-CLS-BLG-OFC
12 BILLED-OFFICE-APC AUTHORITY BILLING-OFFICE- APC
13 PROG-DIR ACTIVITY-CODE BLANK1 'BILL DEC-CD'
14 UNFILLED-ORDERS PIC '$$$,$$$,$99.99' ACCTS-REC PIC '$$$,$$$,$99.99'
15 UNFIL-ORD-1OCT ACCT-REC-1OCT
16 TOTAL-ORDERS PIC '$$$,$$$,$99.99' TOTAL-EARNINGS
17 PIC '$$$,$$$,$99.99' TOTAL-COLLECTIONS PIC '$$$,$$$,$99.99'
18 TOTAL-TRANS PIC '$$$,$$$,$$9.99'
19 ARP-FYTD ARP-ANN ORDERS-INC ORDERS-FYTD ORDERS-CM
20 REIMB-INC REIMB-FYTD REIMB-CM TRANS-INC TRANS-FYTD TRANS-CM
21 COLL-INC COLL-FYTDCOLL-STA-CM COLL-OTH-CM
=========================== B O T T O M =========================




                                                                                  15
Modification of an Existing Query

Queries may be built from scratch, but if there isn’t an existing query that meets your
needs, the easiest way to solve the problem is to modify an existing query. Choose a
query that uses the file that you need the information from and comes closest to satisfying
your needs and then use the information below to modify it.

The query below is presented as an example for the instructions that follow.

NAME: NULO-BASIC                 TYPE: QUERY              STATUS: PUBLIC
DESCRIPTION: ----------------------------------------------------------
01   FIND LXG071
02   APC NE ‘9A76’ PE NE ‘9966’ FY NE ‘F’ ’X’
03   EOE NE ‘4###’ ‘1###’
04   APC = ‘####’ FY = ‘#’
05   OBLIG GTE ‘0’DISB GT OBLIG
06   RELATED BY APC TO FIRST RECORDS AXW022
     PD-MAJ = ‘#’ PD-MIN = ‘#’
07   SET NULO (7.2) = LXG022 ( DISB - OBLIG )
08   SORT LXG022 DISB-DATE ASCENDING
09   PRINT TITLE1 ‘ NULOS OUTSTANDING’
10   LXG022 DISB-DATE FY APC EOE DOC-NO
11   (OBLIG) (DISB) (NULO) PIC ‘$$$,$$$.$$9.99’
12   AXW022 PD-MAJ PD-MIN


‘Find’ Statement
(Ref Line 01 in the sample query)

The first line of the query states the specific file the information is to be pulled from. It is
best to start with a query that has the file you want because most of the files do not have
the same fields in them. The exception to this is the NXG and AJU; you can safely (and
quickly) change a query back and forth between these two files just by changing the file
name.

As you are modifying a query, you might find it necessary to add additional lines. To do
so, move the cursor to the line in the query where the new line is to be inserted and type a
I (for insert) on the first character of the line number. For more than one line, type the I
and then the number or lines required over the second character of the line number. Press
<Enter>. For example to add one line to in the AXW area, you would type ‘I’ over the
07 line (now I7). This would create a new #08 line. To get three lines in Print area you
would type ‘I3’ over the 10 line. If you would like to delete an unnecessary line type a D
over the first character in the line number. Press <Enter>.




                                                                                             16
Defined Data Elements
(Ref Line 02, 03 & 04 in the sample query)

These lines identify specific data elements, the qualifier for the element and, enclosed in
apostrophes, either the specific data required, or the standard length of the element using
the “wild” character ‘#’. (Examples: APC = ‘3XSL’ or APC = ‘####’)

To find the data elements that are found in any particular data file, move the cursor to the
top of page and type: Display (filename), press <Enter>. (Example: Display LXG071).
If you do not know the field length, after doing the above, press <F3>, then press <F5>,
you will get a chart with all of the field names and column lengths. To return to the
query go to the top of the page and type: ED * after the =>, press <Enter>.

The qualifiers that may be used are:

Symbol                        Meaning

GT                            Greater Than
GTE                           Greater Than Or Equal To
=                             Equal To
LT                            Less Than
LTE                           Less Than Or Equal To
NE                            Not Equal To
Containing                    Is present anywhere in the data element (does not have to
                              be correct field length)


‘Related by’ Statement
(Ref Line 06 of the sample query)

The system can combine more than one data file and work the data within the same
query, if there is a common data element in both files. In the sample query, we are
combining the data available from both the LXG file and the AXW file.
As the APC is a common element in most files, it is quite often used as the relating
element. Note that the statement reads ‘Related by APC to first records AXW022’.
The phrase ‘first records’ is in the query so you do not get repeated data lines in the
answer. Without this wording, the system would print the same line of data each time it
encountered the APC in the AXW file. If the system found the APC listed as ‘0’Yr, ‘1’Yr
and ‘2’Yr in that file, the system would list a single line of LXG data 3 times.

Location of ‘Related By’ statement. This statement should be placed after the
requirements of the first data file used in the query. In the sample query, we opened with
a ‘Find LXG022’ and then set out the conditions we wanted to apply to that file. Once
the files have been linked, set whatever conditions you want for the second file.
 It is not required that specific data elements be defined under the ‘Related By’
statement. The files can be linked just to print data from both files.


                                                                                          17
 ‘Set’ Statement
(Ref Line 07 in the sample query)

This statement can be used to do arithmetic functions in the data and create outcomes as
new data elements. In line 08 of the sample query, the statement reads:
 Set NULO (7.2) = LXG022 (DISB -OBLIG). We have created a new data element
called ‘NULO’, we told the system how to determine the data element. Statement tells
the system to ‘go’ to the LXG022 file and subtract the obligation from the disbursement
and call the difference a NULO. We have specified the size of the NULO field: 9 spaces
wide and that it contains 2 decimal places (7.2). The system will read the statement as
being ‘the NULO is 9 spaces wide with 7 spaces to the left of the decimal point and 2
spaces to the right of the decimal point’ (e.g. $1,000,000.00). Always ensure that you set
the created data elements wide enough to cover all of the expected data results. If the
width of the field is not sufficient, an error message such as ***E3**** will appear
instead of the data result. To fix this error, go back to the query and enlarge the field size.

‘Sort’ Statement
(Ref Line 08 in the sample STANFINS query listed in the beginning of this section)

This statement selects which order to display the data in. You can create multiple ‘Sorts’
such as: Sort FY APC EOE. The system will sort the data left to right, (first FY then
APC and then by EOE). In other words, each data element is a ‘Sort’ within the data
element to its left. Default sort order is ascending, you can change that by typing: SORT
DESCENDING.

Enclosing the data element in parentheses will also set the ‘grouping’ of data for the
summary information.

Usually, this statement will be the second to last statement in the query.

 If a related by statement has been used in the query, you must specify which file contains
the data elements that are being sorted.

‘Print’ or ‘Display’ Statement
(Ref Line 10 in the sample STANFINS query listed in the beginning of this section)

This is a ‘must’ statement, if this statement is missing, all the work of the query will be
invisible. It must be the last statement in the query.

If you use ‘Display’, the information will be presented in rows. One record will be
displayed per page. Queries with numerous displayed fields such as the standard FXW
query will have multiple pages per record. Press the <F8> to move to the next page.
<F7> returns to the previous page.

If you use ‘Print’ the information will be presented in columns. Your columns will be set
at the default length of the data field, or at the length of your field name, whichever is


                                                                                            18
greater. You may rename your field in order to change the length of the field or to better
identify the data presented. To do so, immediately after the field name type the name you
wish to have displayed, enclosed in apostrophes. (For instance, in the FXW file the
customers APC is in the field named “Billed-Office-APC”, the field length would be 17
characters, but the data itself is only 4 characters. If you would like to save room on your
page, you could type ‘BLD’ directly after the Billed-Office-APC, and the field length
would become 4 characters, the length of the actual data. You may add one or two titles
to your ‘Print’ query; the second title must be listed directly after the first one. Type:
Title1 and then put the ‘name’ of the query contained within apostrophes, continue with
Title2. If you prefer just one title you can leave off the numeral 1.

Next, identify what data elements you want to see. If you are using more than one data
file (by use of a ‘Related’ statement), you must identify where the data elements are to be
found. Notice that in line 11 of the sample query, line reads: ‘LXG022 DISB-DATE’.

Each field with Dollar or numeric value fields needs to be formatted to suppress the
leading zeroes. To do this the statement AVK***MD$ (for monetary amounts) or
AVK***MQ$ (for non-monetary amounts) needs to be inserted immediately after the
data field name in the print or display statement. (Substitute your 3 character database ID
for the *** in the statement.) If you wish to save space, as well as suppress the leading
zeroes, you can use a ‘PIC’ statement in place of the AVK***MD$ statement. Use as
many $ signs as necessary to specify the maximum expected amount. For example ‘PIC
$,$$$,$$9.99’ will limit the results to 9 places, with commas and decimals in the
prescribed spots.


Summarizing the DATA

Summary information can be obtained for each query by grouping the data and
specifying the dollar values to subtotal. In the ‘Sort’ statement specify the data fields
that you would like to group by enclosing them in parentheses. In the ‘Print’ statement
enclose the dollar amount fields to be subtotaled within parentheses. After executing the
query, press the <F3> again to get the summary information.

Saving the Query

After you have completed the query, it can be saved for future use. Move to the top of
query and on line that reads ‘Name’, type a name for the query. It must be a unique
name and can be up to 8 characters in length. Providing a description of the query in the
‘Description’ line (in the sample query, we did not use this option) is also an option.
Press <F4>. To permanently save changes made to a query, press <F9>. Note: you may
only “update” a query that the system recognizes as having been saved by you. IF you
try to update a query that is not “yours” you will receive the following error message:
DQ018E - YOU CANNOT DELETE OR REPLACE A MEMBER THAT DOESN'T
BELONG TO YOU, in this case rename and save the query using <F4>.




                                                                                         19
                        EDA Electronic Document Access
What is EDA?
EDA is an on-line, web- based system. The system provides storage and retrieval of
documents.

Where does the data come from?
Many DOD sources: Contracts, contract modifications, travel payments, airline tickets,
contract payments, Government bill of lading, and DAPS travel systems. Travel
settlements processed by DFAS Rome Travel section are available in the DAPS travel
system. Information includes all back up documentation for the travel vouchers effective
1 July 2003.

Why use EDA?
One can see contract payments, history of payments, travel history of payments, freight
payments, airline tickets, and copies of contracts. The actual document is available to
view rather than the key punched information.

How to get access to EDA:

EDA can be accessed through Netscape or Internet Explorer. In order to get access to
EDA you must register on-line.

1. Click on your desktop icon for either Netscape or Internet Explorer
2. Type in the EDA address: http://eda.ogden.disa.mil and hit enter.
3. The ‘Department of Defense Electronic Document Access’ page will come up. In
the section ‘To Become a New EDA User’ under Step1: ‘Choose Type of Registration’
click on ‘Government User Registration’.
4. The ‘Register Government User’ page will appear. Under Step 3 click on the ‘EDA
Registration Form’ under ‘Username/Password’.
5. The ‘Government User Registration’ form will appear. Fill out, at a minimum, all the
information marked by an asterisk. For ‘Command/Service/Agency’ select ‘DFAS’ on
the dropdown menu. Organization will then appear. Select ‘Rome’ on the dropdown
menu. Under ‘Access to’ put a checkmark next to all document types you require access
to. Click on the ‘Submit’ button.
6. The ‘EDA- New User Registration’ form will appear. You will need to create a
username and password. The username should be your last name followed by the first
initial of your first name. The password must be at least 8 characters in length and
contain at least one number, special character and a combination of upper and lower case
letters. Check the document types you need access to again and check the ‘I accept this
statement of accountability’ at the bottom of the page. Then click on ‘Submit’.
7. A ‘Registration Acknowledgement’ screen will appear notifying you that you have
successfully completed the first three steps of the registration process. You will receive a
confirmation e-mail and a notification e-mail will be sent to your Electronic Business
Point of Contact (EB POC).


                                                                                          20
8. The Electronic Business Points of Contact (EB POC) for DFAS Rome is The Rome
Help Desk. ROME-HELPDESK@DFAS.MIL They will review your registration
application and have you submit a DISA Form 41 requesting access to EDA. Once you
have been approved you will receive an e-mail notification and instructions on how to
activate your password by going to the link:
https://eda2.ogden.disa.mil/pls/register/pw_reset.PW_Reset_complete.

Where to go for more information on EDA:
See the EDA User's Guide for instructions on accessing the EDA application at:
http://eda.ogden.disa.mil/users_guide/index.html


How to use EDA:

1.	 Open web site (Netscape is preferred browser) http://eda.ogden.disa.mil.
2.	 Click in to the “Login to EDA” box.
3.	 Click “DECC- Columbus index Server (with username/password)” or “DECC-
    Ogden Index (with username/password)”.
4.	 Type in user name and password (case sensitive) click OK

This brings you to the Document selection screen where you can select the type of
document you are searching for.

Contracts and applicable contract modifications

1.	 Select “Contracts”
2.	 Select “Search for Specific Contract and Delivery order”
3.	 Type in contract number in Contract Number box (DABJ6004D0006). If Delivery
    Order is known input appropriate delivery order information in “Delivery Order”
    box.
4.	 Click “View Search Results” Search results will list Contracts that matched
5.	 Click on hyperlink Contract number and an Adobe Acrobat reader will show the
    selected contract. The document can then be viewed, printed, or saved.


Travel Voucher

1.	 Click on “Voucher--Travel”
2.	 Type in appropriate information (Top Choices: Voucher Number, Payee Name, or
    Payee SSN) Use Drop down boxes for “equal” or “like”
3.	 Click on “Search Results”
4.	 A list of records retrieved by DOV and PAID DATE should appear.
5.	 Click on hyperlink of the DOV that is needed.
6.	 Click on hyperlink selection number and the html copy should appear, if there is an
    attachment a paper clip icon will appear in the far right column.
7.	 Double -Click the paper clip icon to view the supporting documents.



                                                                                          21
Vouchers Commercial

1.	 Click on “Voucher--Commercial”
2.	 Click on “Search selection” (Top Choices: Voucher Number, Document Reference,
    or Contract Number).
3.	 Type in appropriate information (voucher number “220056”) (document reference
    number “WE20000047N066”) or (contract Number “DABT57-00P1011”) appropriate
    search results should appear.
4.	 Choose the correct Voucher DOV number by Paid Date Click on Hyperlink.
5.	 Voucher Information will appear listing Voucher dates and Lines of accounting.
6.	 Click on hyperlink Dov number and an Adobe Acrobat reader will show the selected
    voucher. The document can then be viewed, printed, or saved.




                                                                                  22
                          On-Line Report View (OLRV)
What is OLRV?
On-Line Report View is a web-based service providing the STANFINS-produced reports

on screen. The reports can be accessed without printing a hard copy.

.

Where does the data come from?
The data comes from the print file output from the Stanfins cycles.

Why use OLRV?

The benefits of OLRV On-Line Report Viewing are: saves money by eliminating
hardcopy output and all associated costs; readily accessible through the web; ensures
financial information is timely to the customer for decision making; easy to use – report
data can be extracted and manipulated through desktop applications; used to create
customized Management Reports; archives data to a storage area network (SAN) or off
line library for long-term storage.


How to get access to OLRV

Submit a completed DISA Form 41, parts I-IV, to your servicing field location (Rome).
The DISA Form 41’s can be mailed or faxed in. Originals are needed but not at the time
of the initial request. The fax number is DSN 220-6964 or commercial (315) 330-6964.
The mailing address is: DFAS-Rome/AS, ATTN: Systems (OLRV), 325 Brooks Road,
Rome, NY 13441. Blank DISA Form 41’s highlighting all the areas on the form that are
required to be filled out are available through e-mail. A point of contact for OLRV is:
ROME-HELPDESK@DFAS.MIL

Once the completed DISA Form 41 is received, Systems personnel at Rome will then e-
mail the user name and temporary password to the individual along with the site address.
Instructions on how to create a new password and general information on what setup is
required in order to access the site will also be included. A reminder to mail in the
original DISA Form 41 requesting access is also included if it has not yet been received.
Failure to mail in the original will result in the OLRV account being suspended after 30
days and deleted after 90 days.




                                                                                        23
System Setup Requirements to Access OLRV (On-Line Report View)

1.	 The OLRV web site can be accessed through either Netscape Navigator or Internet
    Explorer. https://dro.olrv.ogden.disa.mil.
2.	 Needed web browser: Internet Explorer V5.0+ or Netscape Navigator V4.06+.
3.	 128-bit encryption. This can be checked in Netscape by clicking on the ‘Help’ menu
    and selecting ‘About Communicator’. It will indicate whether the version supports
    U.S. Security. In Internet Explorer click on the ‘Help’ menu and select ‘About
    Internet Explorer’. Check the Cipher strength to determine if it has 128-bit
    encryption.
4.	 Must access OLRV from a .mil or .Gov. address. OLRV is open to all of these
    addresses.


How to use OLRV (On-Line Report View)

1. Click on your desktop icon for either Netscape or Internet Explorer.
2. Type in the OLRV address: https://dro.olrv.ogden.disa.mil and hit enter.
3. A box will pop up for you to enter your username and password. The password is case
sensitive, the username is not.

(First time users will be presented with 5 Java Security screens. Check the box that says
remembers this decision and click the grant button. After you have gone through all the
security screens you will be taken to the password reset page to create your own
password. Passwords must be 8 characters in length and contain a number, a special
character and a combination of capital and small letters.)

4. An OLRV welcome page will come up with the phone numbers to access the OLRV
Helpdesk. Click on “Enter”.
5. Report.Web Insight page will appear with the following options: Direct Interface,
Search Reports, Help, View by Folder, View by Date and View by Name. Our most
common method of accessing the reports is ‘View by Folder’. Click on this.
6. The box for entering your username and password will appear a second time. Fill this
in and click on ‘OK’.
7. A list of reports by folder will appear named by the installation and with the DPI code.
Click on the left arrow to expand the list to the report names. The report names include
the name of the STANFINS report followed by the installation DPI code and the name of
the cycle that generates the report.
8. Click on the arrow to the left of the report names and it will open up to list the reports
by date and time on the right side of the screen.
9. Click on the desired date and time on the right side to open up the report.




                                                                                           24
When first connecting to the new Report.Web server you will be presented with five
screens. Check the box that says remember this decision, and click the grant button.
This will only happen the first time you access a Report.Web ver 2.6 web site.




                                                                                       25
                  NAVIGATING IN OLRV (On-Line Report View)

1.	 When the selected report screen comes up, you will see a split screen. The left side
    shows the report directory (Tree View), and the right side will show the report.
    TIP: To make the report viewable using the entire screen select the Toggle Tree
    View Button.

2.	 The OLRV Icon buttons and toolbars, reading from left to right, perform the
    following functions:

   a.	 Back Button - Allows you to return to select a different report.

   b.	 Print Button – To print a page or pages of a report click the printer button and a
       dialog box will appear. Enter a page range and click OK.

   c.	 Print Preview Button - Displays the report as it would appear if printed.

   d.	 Copy Button – To export particular areas of a report to another application,
       highlight the area you want to export. Click the Copy Button. Open Word, Excel,
       Access, etc., and click on Edit. From the drop down menu click on Paste.

   e.	 Find Button – To find an item in a report, click on the Find Button and a dialog
       box will appear. Enter the item you’re looking for and click OK.

   f.	 Find Next Button – Use this button to find the next occurrence of the item you’re
       looking for.

   g.	 Font Toolbar – Changes the font of the report.

   h.	 Font Size Toolbar – Changes the print size of the report.

   i.	 Zoom In Button – Allows you to Zoom in closer on the report

   j.	 Zoom Out Button – Allows you to Zoom Out from the report

   k.	 Size To Fit Button – This button can be used to expand the report to fit the
       viewing window.

   l.	 Green Bar Button – Displays a visual of “green bar” ruling paper.

   m.	 Toggle Tree View Button – Turns on and off the report directory tree view.

   n.	 Page Up Button – Moves the report up one page.

   o.	 Page Down Button – Moves the report down one page.




                                                                                           26
(A)    (B)       (C)      (D) (E)     (F)   (G) (H)      (I)     (J) (K)      (L)       (M)    (N)    (O)
  Back Print    Print    Copy Find   Find   Font Font   Zoom   Zoom Size     Green     Toggle Page   Page
               Preview               Next        Size    In     Out to fit    Bar    Tree View Up    Down




                                                                                                     27
                                                     ORLV REPORT LISTING
AVK RPT# CYCL                                                DESCRIPTION OF REPORT

AVK 003   D2    MASTER UPDATE LISTING - displays additions, changes, and deletions that processed to the master file.
                MASTER UPDATE ERROR REPORT - displays lines that did not process to master file along with respective error
AVK 006   D2    codes.
AVK 009   D2    F & AO INPUT - listing of all transactions included in the daily input.

AVK 018   D2    DAILY PRELIMINARY BALANCE REPORT - validates all FAO input data after source documents have been processed.

AVK 024   D3    ARP EXCEPTION/INQUIRY REPORT - provides detail transactions as well as customer status by customer number.
AVK 030   D6    PRIOR YEAR FUND STATUS - provides status of obligations against prior year funds
AVK 051   D6    FUND CONTROL AND STATUS - current year fund control status sorted by appropriation.
                FUND CONTROL AND STATUS BY PROGRAM DIRECTOR - current year fund control status sorted by program
AVK 052   D6    director.
             ACCOUNTS REC. STATUS ARP - AUTOMATIC - provides the means for program directors to monitor their automatic
             reimbursement activity. Activity is reported in terms of "FYTD" program, orders received and their percentage of the
AVK 117   WC programs, earnings, collections.
             ACCOUNTS REC. STATUS ARP - FUNDED - provides the means for program directors to monitor their funded
             reimbursement activity. Activity is reported in terms of "FYTD" program, orders received and their percentage of the
AVK 120   WC programs, earnings, collections.
             WEEKLY STATUS OF REIMBURSEMENTS - summarizes data by reimbursement source within subprogram/project,
AVK 126   WC type of funding, and allotment for each appropriation.
             DETAIL OBLIGATION REPORT (ALL YEAR) - contains all detail obligations processed during the period by DOD within
             APC. Financial managers
AVK 131   WB can use this report to reconcile obligations and commitments recorded on their resource control ledger.
             STATUS OF REIM 112 PT 3-8 - summarizes the accounts receivable, advances, and other debts of nongovernmental
AVK 295   MH agencies.
             STATUS OF REIM 112 PT I & II - reviewed by financial managers to detect deviations from planned reimbursement
AVK 296   MH activity.
             STATUS OF AOB CSCFA 218 - primary report prepared at fiscal station level to provide status data to operating
AVK 329   MH agencies.
                STATUS OF APPROVED RESOURCES (MDEP) - Obligations, deobligations, civilian end strength, officer end strength,
                warrant officer end strength, and enlisted end strength are reported by direct, funded, and automatic sources of funding
AVK 331   MH    at the MDEP. (appropriation, ams, object class, mdep)
                STATUS OF APPROVED RESOURCES (MEMO) RECON - Obligations, deobligations, civilian end strength, officer end
                strength, warrant officer end strength, and enlisted end strength are reported by direct, funded, and automatic sources of
AVK 333   MH    funding at the MDEP. (appropriation, ams, mdep)
                NON STOCK FUND ORDERS AND PAYABLES - report shows the cumulative status of each record in LXGAVK file by
AVK 602   RR    document number.
                302/304 REPORT - primary report prepared at the DSSN/fiscal station level to provide disbursing/collection data to the
AVK 656   M3    Treasury.
                DCPS FUND DATA REPORT - report displays each individual social security number and all pay and benefits. It also
AVK 692   SD    displays the employee name and the “User Name” which identifies the CSR who worked the account.

                STANFINS CIV PAY RECORDS ON DAILY INPUT FILE - provides a formatted listing of the transactions in the BUQAVK
                file which is input to the Daily cycle. These transactions are sorted and summarized by Type Action/Block Number and
AVK 694   SD    APC. Totals are provided by APC and Block Numbers. This report shows end strength and manhours by EOR/APC.
                DCPS INTERFACE CHANGE LISTING - report is produced by Program Director and shows employee names, SSN,
                EOR, terminal leave, OT pay, Holiday Pay, Civ. incentive awards, Performance cash awards, and Overseas Allowances
AVK 697   SD    in separate columns for the employee.
                APC MASTER FILE PRINT - complete listing of all APCs that can be obtained in several sequences depending upon
AVK 774   RY    control card input.
                ARP MASTER FILE PRINT - (FXWAVK). The master list of customer numbers with names, address, billing APC, billed
AVK 778   RY    APC, Customer MIPRs and accounting classifications.
                SCHEDULE OF APPROVED PROGRAM/FUNDS AND UNLIQ OBLIG - Annual Schedule of Approved Resources
AVK 850   T9    (SOAR) that is certified at yearend.
                INSTALLATION GENERAL LEDGER TRIAL BALANCE - contains the current month activity and the current general
AVK 901   TF    ledger values for all fund entities. It also includes the normal account balance.
                                                                                                                       28

                                              SYSTEM AUTHORIZATION ACCESS REQUEST (SAAR)

                                                                            PRIVACY ACT STATEMENT
Public Law 99-474, the Counterfeit Access Device and Computer Fraud and Abuse Act of 1984, authorizes collection of this information. The information will be used to verify
that you are an authorized user of a Government automated information system (AIS) and/or to verify your level of Government security clearance. Although disclosure of the
information is voluntary, failure to provide the information may impede or prevent the processing of your “System Authorization Access Request (SAAR)”. Disclosure of records
or the information contained therein may be specifically disclosed outside the DoD according to the “Blanket Routine Uses” set forth at the beginning of the DISA compilation of
systems of records, published annually in the Federal Register, and the disclosures generally permitted under 5 U.S.C. 552a(b) of the Privacy Act.

TYPE OF REQUEST                                                                                                                      DATE
                         X     INITIAL                                MODIFICATION                        DELETION

                                                                     PART I (To be completed by User)
1. NAME (LAST, First, MI)                                                                                                            2. SOCIAL SECURITY NUMBER

3. ORGANIZATION                                                             4. OFFICE SYMBOL/DEPARTMENT                              5. ACCOUNT CODE
                                                                                                                                                N/A
6. JOB TITLE/FUNCTION                                                                         7. GRADE/RANK                          8. PHONE (DSN)

STATEMENT OF ACCOUNTABILITY
       I understand my obligation to protect my password. I assume the responsibility for data and system I am granted access to. I will not exceed my authorized access.

USER SIGNATURE                                                                                                                       DATE



                                                      PART II (To be completed by User’s Security Manager)

9. CLEARANCE LEVEL                                                    10. TYPE OF INVESTIGATION                                      11. DATE OF INVESTIGATION

12. VERIFIED BY (Signature)                                                                   13. PHONE NUMBER                       14. DATE


                                                           PART III (To be completed by User’s Supervisor)

15. ACCESS REQUIRED (Location) – i.e. DMC or DMC’s
 Access to which (OLRV) site(s):
16. ACCESS TO CLASSIFIED REQUIRED?                                  17. TYPE OF USER                                                  SECURITY ADMINISTRATOR
       X NO              YES                                             X FUNCTIONAL                      SYSTEM                     APPLICATION DEVELOPER
                                                                                                                                      OTHER (Specify)
18. JUSTIFICATION FOR ACCESS
To review STANFINS reports via OLRV

IP# ___________________


E-MAIL ADDRESS:



VERIFICATION OF NEED TO KNOW
      I certify that this user requires access as requested in the performance of his/her job function.

19. SIGNATURE OF SUPERVISOR                                                          20. ORG./DEPT.            21. PHONE NUMBER                 22. DATE


23. SIGNATURE OF FUNCTIONAL DATA OWNER/OPR                                           24. ORG./DEPT.            25. PHONE NUMBER                 26. DATE
                                                                                 .




                                                    PART IV (To be completed by AIS Security Staff adding user)

27. USERID (Mainframe)                                        28. USERID (Mid-Tier)                                    29. USERID (Network)

30. SIGNATURE                                                                                 31. PHONE NUMBER                       32. DATE

                                                                                                                                                     29
NOTES





         30

								
To top