File and Folder Names
-
BudgetRevenue.txt
-
BudgetExpenditure.txt
-
BudgetBalanceSheet.txt
-
ActualRevenue.txt
-
ActualExpenditure.txt
- ActualBalanceSheet.txt
File formats - Tab Separated Value. In Excel select Save as:
Text (Tab delimited) (*.txt)
Header - First line in each file should have:
SAU ReportName RecordCount DateTime
1000 BudgetRevenue 967 04/15/2006 12:00:00 AM
File names -
Format -
BudgetRevenue.txt
SAUCode FiscalYear Quarter FundCode RevenueCode Title Amount
BudgetExpenditure.txt
SAUCode FiscalYear Quarter FundCode ProgramCode FunctionCode ObjectCode CostCenter Title Amount
BudgetBalanceSheet.txt
SAUCode FiscalYear Quarter FundCode BalanceSheetCode Title Amount
ActualRevenue.txt
SAUCode FiscalYear Quarter FundCode RevenueCode Description Amount
ActualExpenditure.txt
SAUCode FiscalYear Quarter FundCode ProgramCode FunctionCode ObjectCode CostCenter Title Amount
ActualBalanceSheet.txt
SAUCode FiscalYear Quarter FundCode BalanceSheetCode Title Amount
Data types are as follows -
Amount = up to 10000000000.00 10 Billion with two decimal places and no comma separators,
BalanceSheetCode = 4 Digit Numeric
CostCenter = 2 Digit Numeric (01, 02, 03, 04, 99)
Title = 200 Char Text without tabs in them (Support expenditures purchased services students)
FiscalYear = 4 Digit Numeric (07/08 would be 2008)
FunctionCode = 4 Digit Numeric
FundCode = 4 Digit Numeric
ObjectCode = 4 Digit Numeric
ProgramCode = 4 Digit Numeric
Quarter = 2 Digits Numeric (01, 02, 03, 04)
Revenue Code = 4 Digit Numeric
SAUCode = 4 Digit Numeric 1000-9999