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.
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)
DBD Translation Extract
State Coding Attributes
Week-to-Date Transaction History through the Previous Day
Month-to-Date Transaction History through the Previous Week
Year-to-Date Transaction History through the Previous Month
Month-to-Date Transaction History through the Previous Day
Year-to-Date Transaction History through the Previous Day
Account Attribute Translations
General Ledger Account Attributes and Dollar Records
Subsidiary Ledger Account Attributes and Dollar Records
Open Commitments currently viewed on-line
Voucher Records from the current fiscal year and any records from the prior fiscal years that are still upaid.
Voucher Records from 3 prior fiscal years plus some records from the current fiscal year that have been paid.
Duplicate Invoice edit records
Purchase Order Invoice Records
PurchasingModule Document Header Records (Purchase Orders, Requistions, Bids and Future Orders)
Purchase Order Receiving File
Purchasing Module Document Line Item Detail (Purchase Orders, Requisitions, Bids and Future Orders)
Fixed Asset Notes
Fixed Assets Indirect Transaction History
Fixed Assets Direct Transaction History
Previous Month-to-Date Transaction History
Bid List 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.
Last updated 8/21/08 CBM