Skip to main content
Skip table of contents

MSDE Period Balances Report - File Layouts and Data Mapping

The following table lists the field number, field name, description, data type, size, and location of the data for the MD MSDE Period Balances report.

Period 13 is considered period 12, and the Period Balances Date is 30 June, year.

The default file name is PERIOD_BALANCES_XX.tsv
where
XX is the two-digit LEA number.

Field Number

Field Name

Description

Data Type

1

LOCAL_PERIOD_BALANCE_KEY

A unique key to identify each period balance.

It should be a Concatenation of School Year + Budget unit + Account + School Code + Period Balances Date, separated with a semicolon.

VarChar(200)

2

SCHOOL_YEAR

The related school year.

The default is the current school year.

The combination of School Year and School Code must be unique. You cannot create multiple records with the same School Year and School Code combination.

VarChar(10)

3

DISTRICT_CODE

The district code where the school is located.

The value is retrieved from the Local Education Agency field on the Human Resources Profile - State page.

VarChar(20)

4

LOCAL_ENTITY_KEY

The School code.

The value is retrieved from the School Number field on the General tab of the Location Table page.

The combination of School Year and School Code must be unique. You cannot create multiple records with the same School Year and School Code combination.

VarChar(100)

5

LOCAL_GL_ACCOUNT_KEY

A value that uniquely identifies each general ledger account record submitted.

This may be a single code value. However, these codes should be concatenated if multiple codes/values are required to uniquely identify a general ledger account within a district, school, and academic year.

VarChar(200)

6

PERIOD_BALANCES_DATE

The date on which the period balances entry was made. Leading 0 for MM and DD is required.

This is always the last day of the loaded period. If the load period is 1, the Period Balances Date is Jul 31, year. If the load period is 6, the Period Balances Date is Dec 31, year.

Date

7

ENCUMBRANCE_POSTINGS

The sum of Encumbrances for the related GL account for the fiscal period.

Numeric(18)

8

EXPENDITURE_POSTINGS

The sum of Expenditures for the related GL account for the fiscal period.

Numeric(18)

9

BUDGET_POSTINGS

The sum of Budgets for the related GL account for the fiscal period.

Numeric(18)

10

PERIOD_POSTINGS

The sum value of journal postings for the fiscal period. It is stored in base currency.

Numeric(18)

11

BALANCE_TYPE

In most deployments, this attribute's value is set to Standard. Still, for some financial sources, it is necessary to differentiate between types of balances, such as Balance Forward, and this attribute can be used for that purpose.

VarChar(100)

12

APPROPRIATION_BEGIN_BALANCE

The balance of Appropriations for the related GL account to-date or at the start of the fiscal period.

Numeric(18)

13

APPROPRIATION_END_BALANCE

The balance of Appropriations for the related GL account to-date or at the close of the fiscal period.

Numeric(18)

14

APPROPRIATION_POSTINGS

The sum of Appropriations for the related GL account for the fiscal period.

Numeric(18)

15

ENCUMBRANCE_BEGIN_BALANCE

The balance of Encumbrances for the related GL account to-date or at the start of the fiscal period.

Numeric(18)

16

ENCUMBRANCE_END_BALANCE

The balance of Encumbrances for the related GL account to-date or at the close of the fiscal period.

Numeric(18)

17

REQUISITION_BEGIN_BALANCE

The balance of Requisitions for the related GL account to-date or at the start of the fiscal period.

Numeric(18)

18

REQUISITION_END_BALANCE

The balance of Requisitions for the related GL account to-date or at the close of the fiscal period.

Numeric(18)

19

REQUISITION_POSTINGS

The sum of Requisitions for the related GL account for the fiscal period.

Numeric(18)

20

EXPENDITURE_BEGIN_BALANCE

The balance of Expenditures for the related GL account at the start of the fiscal period.

Numeric(18)

21

EXPENDITURE_END_BALANCE

The balance of Expenditures for the related GL account at the close of the fiscal period.

Numeric(18)

22

BUDGET_BEGIN_BALANCE

The balance of Budgets for the related GL account at the start of the fiscal period.

Numeric(18)

23

BUDGET_END_BALANCE

The balance of Budgets for the related GL account at the end of the fiscal period.

Numeric(18)

24

PERIOD_BEGIN_BALANCE

The current balance for the account. This will be the value for Balance Sheet accounts and will be the same as YTD values for other ledgers. It is stored in base currency.

Numeric(18)

25

PERIOD_END_BALANCE

The current balance for the account. This will be the value for Balance Sheet accounts and will be the same as YTD values for other ledgers. It is stored in base currency.

Numeric(18)

26

PERIOD_QUANTITY

The memo quantity of journal postings for the fiscal week to date. This is in a mixed unit of measure, so it may only be helpful in account-level reports and analysis.

Numeric(18)

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.