MSDE Annual Financial Report - Data Definitions
The following table lists the data items, type, size, and from where the data is retrieved.
Data Item | Type | Size | Location |
|---|---|---|---|
Year | Char | 2 | Entered when data is loaded. |
Key Organization | Character | 16 | md_afrcross.key_orgn |
Account | Character | 8 | md_afrcross.account |
MSDE Account | Character | 11 | md_afrcross.msde_acct |
Local Grant | Character | 10 | md_afrcross.local_grant |
MSDE Grant | Character | 8 | md_afrcross.msde_grant |
Fund Source | Character | 4 | md_afrcross.fund_source |
Amount | Decimal | 12,2 | Expenditure Records: All expenditure ledger records for the selected year are processed, regardless of active or inactive status. Find the AFR Crosswalk entry for each expenditure ledger record: SELECT * FROM md_afrcross WHERE md_afrcross.yr = expledgr.yr AND md_afrcross.key_orgn = expledgr.key_orgn AND md_afrcross.account = expledgr.account If a crosswalk record is found, then the amount is the sum of (expledgr.exp1 + expledgr.enc1) through (expledgr.exp13 + expledgr.enc13) |
MSDE Fund | Character | 1 | md_afrcross.msde_acct[1,1] |
MSDE Class | Character | 1 | md_afrcross.msde_acct[2,2] |
MSDE Category | Character | 2 | md_afrcross.msde_acct[3,4] |
MSDE Program | Character | 2 | md_afrcross.msde_acct[5,6] |
MSDE Activity | Character | 2 | md_afrcross.msde_acct[7,8] |
MSDE Object | Character | 1 | md_afrcross.msde_acct[9,9] |
MSDE Sub-Object | Character | 2 | md_afrcross.msde_acct[10,11] |
Ledger Type (Hidden) | Character | 1 | R = Revenue Ledger E = Expenditure Ledger S = Balance Sheet/General Ledger |