Search | Directories | Reference Tools
UW Home > Admin Systems > Systems on Keynes 

man working
image
Online Guides--    [ FIN ] [ PAS ] [ SDB ]
[ SDB-older content ]
[ FASTRANS ] [ FAST ]
[System Operating Hours]
[Administrative Systems Status]

FAST Downloading:
Electronic Transfer of Budget Activity Report (BAR) Transactions

This document is for the employee who uses a local database or spreadsheet to analyze or further process budget activity data. FAST Downloading provides for the electronic transfer of Budget Activity Report (BAR) data from the central Financial Accounting System to a local work station.

Included on this page:

Additional References

Introduction

FAST Downloading is available to all campus departments, whether they deal with large or small volumes of financial transactions. There is no charge for this service.

To use FAST Downloading, you need a PC, MAC or other work station connected to the campus network. You will also need to have your administrative system usercode modified to allow it to run FAST.

Note:

BAR data is available for downloading by FAST during the period that it is available for inquiry via your FIN screen, normally up to 16 months after creation.

Getting Access

Send email to help@u.washington.edu.

Overview

FAST Downloading consists of three steps:

  1. Extract the data you want from the central financial files.
  2. Transfer the selected data file to your work station.
  3. When you are sure you have a satisfactory file on your work station, you delete your extracted file from quipu.u.washington.edu (pronounced key-poo).

Extract (Create) Your Data File

  1. Make a network connection to keynes.u.washington.edu.
    You will get a "SIGN-ON SCREEN".

  2. Sign on using your administrative system Usercode and Password.

    Note: If you have more than one usercode, use the one that was modified to run FAST Downloading.

  3. Enter your PRN from your SecurID card at the "PRN SCREEN".

    You will get a "MAIN MENU".

  4. Type "EXTRACT" in the Choice box
  5. Press [Enter]

    You will get a "HOST DATABASE EXTRACTION SCREEN".

  6. Fill out the screen as follows:
    (use upper case, tab between entries, shift/tab to go back)

    Application System: Type "FIN"

    User: and Password: Type your administrative system Usercode and Password.
    If you have more than one, use the one that provides FIN system inquiry access to the budgets you want to download.

    File Name: Type a name of your choice. Use letters and numbers, no special characters, generally no more than 8 characters. The limit is 17 characters.

    Request: Type in the selection criteria that you want to use, from the Parameter Code Table.
    Parameters can be referenced using two-character codes or keywords. Most parameters allow for up to 20 instances or ranges of values to be specified. You must specify at least one of the following parameters: Accounting month, Posting date, or Budget number. In addition, you must always specify a File format. If you have high-level access, then you must specify either Budget number or Organization code. You can only extract data for budget numbers that you have access to.

    Biennium: You may specify a Biennium, using the Biennium parameter. If you do not specify a biennium, FAST will default to the current biennium, unless:

    • You specify an accounting month greater than the current accounting month, or
    • The current accounting month is 25, 26, or 27

    In which case FAST will default to the previous biennium.

Example: To extract data records for budget number 14-9999, for accounting month 22, and put those records into a DASCI8 format file, you would type the following:

AM:22

BG:149999

FM:DASCI8

Note that there is no space between the parameter code, colon and value.

It could also have been entered as follows:

MONTH:22 BGT:149999 FORMAT:DASCI8

 

Press [Enter]

to send your extraction request.

You will see several messages as your request (job) is placed in the "queue", then the message: "Please press enter key to return to Menu". At this point, you may either:

Press [Enter]
to close your on-line session, and let your request be processed unobserved, or
leave your on-line session active to observe the progress of your request.

Your request may process immediately, or it may take several hours to be processed, depending on the number of requests ahead of yours in the queue, and the other work that the system is doing.

If you choose to keep your on-line session, you will eventually see:

"TRANSACTION RECORDS WRITTEN +9999999".

This is the number of records extracted into your file. Two messages beginning with , "#EOT", and "#EOJ", after the previous message, mean your extract is done.

Press [Enter] to return to the MAIN MENU;
type "BYE" in the Choice box and
press [Enter] to sign off.

Transfer (Copy) Your File to Your Work Station

Use secure file transfer software to copy your extracted file from quipu.u.washington.edu to your work station.

  1. Initiate a file transfer session from your work station
  2. connect to quipu.u.washington.edu for file transfer purposes, and
  3. get the file from there.

Be sure to transfer your file as a character or ASCII file.

For File Transfer:

Delete Your Original Extracted File from quipu.u.washington.edu

Once you have successfully copied your extracted file to your work station, you should remove the original file from quipu.

Return to keynes.u.washington.edu,
sign on as you did previously, get to the "MAIN MENU",
type "CANDE" in the Choice box and press [Enter].

Type "REMOVE <filename>" at the "#" prompt,
press [Enter].

You should get a message validating the deletion.

Type BYE at the "#" prompt,
press [Enter].

If you would like to see the files you have on keynes,

Go to CANDE and enter:
"FILE" at the "#" prompt.

Special Note for LARGE or COMPLEX Extracts

If your request extracts a very large file, or if it is complex (such as a range of budget numbers) your run may exceed the default processing limit of 15 seconds, and fail. In that case, specify a larger processing limit by including the Processor time parameter in your selection criteria. Run times will be longer for higher values, often overnight for 900, so use the lowest value that will do the job.

Note: The Processor time parameter, when used, must ALWAYS be entered as the FIRST PARAMETER in the Request box.

Online Guides--    [ FIN ] [ PAS ] [ SDB ]
[ FASTRANS ] [ FAST ]