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) |