spacer

FRS master files

spacer

The following is a listing of the masterfile descriptions used to report data from the Financial Records System (FRS). The last 2 digits of the file name indicates the particular data file. For instance, a data file ending with 14 would be for General Ledger account attributes, whereas, one ending in 15 would be for the Subsidiary Ledger. Click on any file to see the complete listing of the fields and formats used for that particular data file. Please note that the definitions for the D9530F02, F03, F04, F05 & F83 use the masterfile definitions for the D9530F09. Therefore, you will see the F09 in the heading for these listings. Also, the mfd for D95HSF26 is the same as D9530F26.

A word regarding the naming convention of the data files.

Current Fiscal Year Files: These files are always prefixed by D9530F__ where the '30' indicates that the data contained in the file will be for the current fiscal year. For instance, to report current subsidiary ledger attributes for an FRS account the user would employ the definitions from the D9530F15 file. To report on a General Ledger account attributes the D9530F14 would be used.

Prior Fiscal Year Files: These files are always prefixed by D95LYF__ where the 'LY' indicates files from the year preceding the current year. They are the Last Year files. Therefore, D95LYF15 will contain FRS Subsidiary Ledger data for the fiscal year that precedes the current open year.

Previous Fiscal Years' Files: Previous fiscal year files are prefixed by D95YYF__ where the 'YY' signifies which previous fiscal year data is being drawn from. So, to see Subsidiary Ledger information from 1996 the user will draw data from the D9596F15 file.

spacer
Name Descriptions

D0000F01 *

University 7-Digit Department Table (MUD)

D0000F02 * University 5-Digit Department Table (MUD)
D0000F03 * University Department Unit Table (MUD)
D0000F04 * University Department Executive Level Table (MUD)
D0000F05 * University Department Campus Table (MUD)
D0000F06 * University Sub-Department Table (MUD)

D9530F00 *

DBD Translation Extract

D9530F01

State Coding Attributes

D9530F02 *

Week-to-Date Transaction History through the Previous Day

D9530F03 *

Month-to-Date Transaction History through the Previous Week

D9530F04 *

Year-to-Date Transaction History through the Previous Month

D9530F05 *

Month-to-Date Transaction History through the Previous Day

D9530F09 *

Year-to-Date Transaction History through the Previous Day

D9530F13 *

Account Attribute Translations

D9530F14 *

General Ledger Account Attributes and Dollar Records

D9530F15 *

Subsidiary Ledger Account Attributes and Dollar Records

D9530F16 *

Open Commitments currently viewed on-line

D9530F25 ^

Vendor File

D9530F26 ^

Voucher Records from the current fiscal year and any records from the prior fiscal years that are still upaid.

D95HSF26 ^

Voucher Records from 3 prior fiscal years plus some records from the current fiscal year that have been paid.

D9530F28 ^

Duplicate Invoice edit records

D9530F32 ^

Purchase Order Invoice Records

D9530F34 ^

PurchasingModule Document Header Records (Purchase Orders, Requistions, Bids and Future Orders)

D9530F35 ^

Purchase Order Receiving File

D9530F36 ^

Purchasing Module Document Line Item Detail (Purchase Orders, Requisitions, Bids and Future Orders)

D9530F50 +

Asset File

D9530F51 +

Fixed Asset Notes

D9530F52 +

Building File

D9530F53 +

Fixed Assets Indirect Transaction History

D9530F54 +

Fixed Assets Direct Transaction History

D9530F55 +

Equipment Class

D9530F56 +

Acquisition Methods

D9530F57 +

Disposal Methods

D9530F58 +

Depreciation Methods

D9530F83

Previous Month-to-Date Transaction History

D9530F60

Bid List File

D9530F61

Commodity File

 

* Execute EX F9530S99 to link to the attribute and transaction tables simultaneously

^ Execute EX F9530S94 to link to the vendor, voucher & purchase order files simultaneously.

+ Execute EX F9530S95 to link to the Fixed Asset master files simultaneously.

Please remember that you may also execute a READACC in your focexec if you do not want to link to every single master file that the above programs give you access to. An EX READACC masterfile name may be placed within your focexec.

spacer

Return to Focus Main Menu

Return to FRS Main Menu

508 UsableNet Approved (v. 1.2.1)

Last updated 8/21/08 CBM