MIS-FUND-EXP ------------ Contains expenditure, budget and encumbrance balances needed to reconcile to the subsidiary ledger fund summary reports. Select using FUND-EXP-SET at BIENNIUM-IND = ..., RECORD-CODE = "1". (record-code = "1" is summarized to fund, so this is a fund by fund reconciliation, using the columns indicated on rpt 42). Do a find first, then a find next until not found occurs. The data-elements used for each fund are: ACT-BTD = Total Expenditures (Rpt 42) ACT-ENCUMB-BAL = Total Encumbrance Balance (Rpt 42) BT-1ST-YR-BUD + BT-2ND-YR-BUD = Salary Recaptures (Rpt 42) PB-1ST-YR-BUD + PB-2ND-YR-BUD + TB-1ST-YR-BUD + TB-2ND-YR-BUD = Budget + Budget-Adjustments (Rpt 42) MIS-FUND-REV ------------ Select using FUND-REV-SET at BIENNIUM-IND = XX, RECORD-CODE = "1" (this is a fund by fund reconciliation) Do a find first, then a find next until a not found occurs. The data elements used for each comparison are: REV-BTD = Total Actual (Rpt 46) PB-1ST-YR-BUD + PB-2ND-YR-BUD + TB-1ST-YR-BUD + TB-2ND-YR=BUD = Total Revenue (est. + est. adj Rpt 46) MIS-PC-EXP, MIS-PC-REV, MIS-ORG-EXP, MIS-ORG-REV DATA SETS ---------------------------------------------------------- At this time there is no report which provides summary totals by Program-Category or Organization-Code. The sum of all record-type 1 records can be compared to report totals from the fund summary reports (Report 042, Current Biennium Expenditures or Report 046, Current Biennium Revenue). MIS-PC-EXP ---------- The data-elements used for each Program are: ACT-BTD = Total Expenditures (Rpt 42) ACT-ENCUMB-BAL = Total Encumbrance Balance (Rpt 42) BD-1ST-YR-BUD + BT-2ND-YR-BUD = Salary Recaptures (Rpt 42) PB-1ST-YR-BUD + PB-2ND-YR-BUD + TB-1ST-YR-BUD + TB-2ND-YR-BUD = Budget + Budget-Adjustments (Rpt 42) MIS-PC-REV ------------ Select using PC-REV-SET at BIENNIUM-IND = XX, RECORD-CODE = "1" Do a find first, then a find next until a not found occurs. The data elements used for each comparison are: REV-BTD = Total Actual (Rpt 46) PB-1ST-YR-BUD + PB-2ND-YR-BUD + TB-1ST-YR-BUD + TB-2ND-YR=BUD = Total Revenue (est. + est. adj Rpt 46) MIS-ORG-EXP ---------- Select using ORG-EXP-SET at BIENNIUM-IND = XX, RECORD-CODE = "1" and ORG-CODE = "0000000000". The data-elements used are: ACT-BTD = Total Expenditures (Rpt 42) ACT-ENCUMB-BAL = Total Encumbrance Balance (Rpt 42) BD-1ST-YR-BUD + BT-2ND-YR-BUD = Salary Recaptures (Rpt 42) PB-1ST-YR-BUD + PB-2ND-YR-BUD + TB-1ST-YR-BUD + TB-2ND-YR-BUD = Budget + Budget-Adjustments (Rpt 42) MIS-ORG-REV ------------ Select using ORG-REV-SET at BIENNIUM-IND = XX, RECORD-CODE = "1" and ORG-CODE = "0000000000". The data elements used for each comparison are: REV-BTD = Total Actual (Rpt 46) PB-1ST-YR-BUD + PB-2ND-YR-BUD + TB-1ST-YR-BUD + TB-2ND-YR=BUD = Total Revenue (est. + est. adj Rpt 46)