SMART Messages


MESSAGE 111010-01
DATE November 10, 2010
AUTHOR Data Warehouse
Subject New Subject Area is Now Available in the Data Warehouse

Message Text: Dear Colleague

We are pleased to announce that the following subject area is now available in the data warehouse:

FMS – GL – Commitment Control Activity Log
• Data extracted on weeknights
• Contains information from the SMART Commitment Control Activity Log Table
• Data available is based on GL Business Unit security

Example Reports:
Total encumbrances by source transaction (purchase orders and travel authorizations)
Encumbrance document details (Purchase Order Id and Travel Authorization ID)
Revenue Budget Activity details (revenue by deposit id and journal id)

Note: Due to the detailed information available in this subject area, take care to add enough criteria to limit your search results. At minimum be sure to use the Fiscal Year and Accounting Period columns to limit your results to a single accounting period. An update will be available soon to provide the Commitment Control Transaction Date (the date in which the activity was recorded to the budget ledger) which will allow you to further limit your request to particular date ranges.



Quick Links

Search the Site

Contact Us

Send us an email

Sign Up

Sign up for the SMART InfoList