GAAP Data Export - File Layout and Data Mapping

FISCAL_YEAR

Retrieved from the Year field on the OH GAAP Data Export page.

REC_ID

The record identifier.

Valid values:

• AF = Fund Import records

• CT = Cash Import records

TRAN_IND

The transaction identifier.

Valid values:

• 1 = Cash Import (Cash) records

• 2 = Cash Import (Expenditure) records

• 3 = Cash Import (Revenue) records

It must be blank for Fund Import records.

FUND

Fund from orgn.fund positions 1 – 3.

FUNC

• For Expense records, this is the Function code. This is retrieved from whichever orgn level is defined as the function in the EMIS profile.

• For Revenue records, this is the Revenue code. This is retrieved from the account number (not including a leading alphabetic character, if present).

OBJ

For Expense records, this is the account number.

SCC

The Special Cost Center (SCC) from orgn.fund positions 4 -7.

BEGIN_BAL

For Cash Import (Cash) records only. The beginning balance transaction is found by selecting the amount of the transaction for the year with a description resembling “BEGINNING CASH BALANCE” or “STARTING CASH BALANCE” for the general ledger record fund and the cash account(s) entered by the user.

ORIG_BUDGET

For Expenditure and Revenue records only. Selected from the transaction table for the current year where t_c = 11 (original expenditure budget) or 12 (original revenue budget).

REVISED_BUDGET

For Expenditure and Revenue records only. The sum of budgets bud1 – bud12 (plus bud13 if the Include Period 13 option on the OH GAAP Data Export page is selected).

ACTUAL

For Expenditure and Revenue records only. The sum of actuals exp1 – exp12 (plus exp13 if the Include Period 13 option on the OH GAAP Data Export page is selected).

PRIOR_ENCUMB

For Expenditure and Revenue records only. Prior year encumbrance that was rolled forward to the current year. Selected from transactions for the account with a description resembling ‘ENCUMBRANCE CARRIED FORWARD’.

CURRENT_ENCUMB

For Expenditure and Revenue records only. The sum of encumbrances enc1 – enc12 (plus enc13 if the Include Period 13 option on the OH GAAP Data Export page is selected).

EXP_AGNST_ENCUMB

The expense against prior encumbrance.

Always 0.

ACCT_DESC

The description from orgn.title.

For Fund Import records only.

BUDGETED

For Fund Import records only.

Valid values:

• Y = Budgeted

• N = Not budgeted

Determined by selecting from the transaction table for the current year where t_c = 11 (original expenditure budget) or 12 (original revenue budget). If found, the fund is reported as Budgeted.

FUND_TYPE

For Fund Import records only.

The fund type determined from the EMIS table ohetble_fcls. The one-character EMIS code is translated to a two-character FUND_TYPE as follows:

• A = AF (Agency Fund)

• C= CP (Capital Projects)

• D = DS (Debt Service)

• E = EF (Enterprise Fund)

• G =GF (General Fund)

• V = IT (Investment Trust Fund)

• P = PE (Permanent)

• R = PP (Private Purpose Trust)

• W = PS (Pension)

• S = SR (Special Revenue)

• I = P (Internal Service Fund)