MSDE GL Accounts Report - File Layouts and Data Mapping
The following table lists the field number, field name, description, and data type for the MD MSDE GL Accounts report.
The default file name is GL_ACCOUNTS_XX.tsv
where
XX is the two-digit LEA number.
Field Number | Field Name | Description | Data Type |
---|---|---|---|
1 | 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) |
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 combination of School Year and School Code. | 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 combination of School Year and School Code. | VarChar(100) |
5 | GL_ACCOUNT_NUMBER | The detailed State GL Account number. | VarChar(100) |
6 | GL_STATE_FUND_CODE | The state code for the fund. | VarChar(50) |
7 | GL_LOCAL_FUND_CODE | The local code for the fund. It may be the same as the state code. | VarChar(50) |
8 | GL_FUND | The fund codes used to identify the fund types for which revenue, expenditures, assets, liabilities, and fund balances are reported. | VarChar(200) |
9 | GL_STATE_CLASS_CODE | The state code for the fund. | VarChar(50) |
10 | GL_LOCAL_CLASS_CODE | The local code for the fund. It may be the same as the state code. | VarChar(50) |
11 | GL_CLASS | Describes the nominal and real accounts. These account totals describe the operations and status of each major fund identified in the Fund code. | VarChar(200) |
12 | GL_STATE_CATEGORY_CODE | The state code for the category. | VarChar(50) |
13 | GL_LOCAL_CATEGORY_CODE | The local code for the category. It may be the same as the state code. | VarChar(50) |
14 | GL_CATEGORY | The state code for the category. The value in this field depends upon the class (and fund type) codes. | VarChar(200) |
15 | GL_STATE_PROGRAM_CODE | The state code for the program. | VarChar(50) |
16 | GL_LOCAL_PROGRAM_CODE | The local code for the program. It may be the same as the state code. | VarChar(50) |
17 | GL_PROGRAM | The value in this field depends upon the class (and fund type) codes. | VarChar(200) |
18 | GL_STATE_ACTIVITY_CODE | The state code for the activity. | VarChar(50) |
19 | GL_LOCAL_ACTIVITY_CODE | The local code for the activity. It may be the same as the state code. | VarChar(50) |
20 | GL_ACTIVITY | The value in this field depends upon the class (and fund type) codes. | VarChar(200) |
21 | GL_STATE_OBJECT_CODE | The state code for the object. | VarChar(50) |
22 | GL_LOCAL_OBJECT_CODE | The local code for the object. It may be the same as the state code. | VarChar(50) |
23 | GL_OBJECT | Describes the service or commodity obtained as the result of a specific expenditure. | VarChar(200) |
24 | GL_STATE_SUB_OBJECT_CODE | The state code for the sub-object. | VarChar(50) |
25 | GL_LOCAL_SUB_OBJECT_CODE | The local code for the sub-object. It may be the same as the state code. | VarChar(50) |
26 | GL_SUB_OBJECT | The sub-object is a further refinement of the object. The first digit of the three-digit expenditure code represents the object, and the remaining two represent the sub-object. | VarChar(200) |
27 | GL_STATE_REVENUE_SOURCE_CODE | The state code for the revenue source. | VarChar(50) |
28 | GL_LOCAL_REVENUE_SOURCE_CODE | The local code for the revenue source or asset. It may be the same as the state code. | VarChar(50) |
29 | GL_REVENUE_SOURCE | The name of the revenue source or asset. Valid values:
| VarChar(200) |
30 | GL_GRANT_DOCUMENT_NUMBER | The grant document number. | VarChar(200) |
31 | GL_LOCAL_GRANT_NUMBER | The local grant number. | VarChar(200) |
32 | GL_DESCRIPTION | A descriptive name for the financial ledger. For example, Balance Sheet, Job Costing, Profit & Loss | VarChar(300) |
33 | GL_LOCAL_OTHER_CODE | District or LEA code for another financial account code. | VarChar(50) |
34 | GL_LOCAL_OTHER_CODE2 | District or LEA code for the second other financial account code. | VarChar(50) |
35 | GL_ACCOUNT_DESCRIPTION | The short or standard description for the GL account. This typically corresponds to the third- or fourth-level code descriptions, such as NOTES/LOANS PAY, FICA WITHHELD, TRAINING, PRICE VAR, C/S FREIGHT EXP, INSURANCE, CERS, BARN, etc. | VarChar(200) |
36 | GL_ACCOUNT_FULL_DESCRIPTION | The complete description for the GL account. The account level descriptions are concatenated. | VarChar(300) |
37 | GL_STATUTE | The statute associated with this detailed State GL Account number. Valid values:
| VarChar(50) |