MSDE Annual Financial Report - Data Definitions

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

Revenue Records: Find the AFR Crosswalk entry for each revenue ledger record:

SELECT * FROM md_afrcross

WHERE md_afrcross.yr = revledgr.yr

AND md_afrcross.key_orgn = revledgr.key_orgn

AND md_afrcross.account  = revledgr.account

If a crosswalk record is found, then the amount is the sum of (revledgr.exp1) through (revledgr.exp13)

General Ledger Records: Find the AFR Crosswalk entry for each general ledger record:

SELECT * FROM md_afrcross

WHERE md_afrcross.yr = genledgr.yr

AND md_afrcross.key_orgn = genledgr.fund

AND md_afrcross.account  = genledgr.account

If a crosswalk record is found, then the amount is the sum of (genledgr.gl_bal1) through (genledgr.gl_bal13)

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