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 |