Topics Map > University of Chicago > IT Services > Business Systems > Reporting Systems

Business Objects - IRF - GEMS data in Transaction Tracking

This article explains the changes to the IRF Transaction Tracking (TT) Universe for the unbundling of the GEMS data and the introduction of the Business Objects GEMS reporting Universe as of August 9th 2013.

GEMS data in IRF Financials

For additional information, see the GEMS Unbundling on the Financial Services Site

General Notes and Information

  • GEM batches are prefixed with either “GPB” or “GPW”
  • All New Gems objects will be blank if the transaction is not a GEMS transaction after 7/31/2013

Updated TT Universe Objects

These updates apply to both the SL and the GL versions of these objects

  • Trans Desc - For GEMS transactions this was previously the Report Name, now for GEMS transactions this will be either the Credit Card Transaction ID or the Out of Pocket Report ID.
  • PO/Encumbrance Number, Transaction Number and Control Number - For GEMS transactions this was previously the Name of the employee submitting the GEMS Report, now for GEMS transactions this will be:
    • PO/Encumbrance Number - 1st seven characters of the CNetID of the employee with the GEMS transaction or report
    • Transaction Number and Control Number
      • For a Credit Card transaction, these fields combined are the truncated merchant name for the individual credit card transaction in GEMS
      • For an Out of Pocket Report, these fields combined are the truncated GEMS report description for out of pocket expenses

New TT Universe Objects

The GEMS data in the updated objects above is directly available in the following new Universe structures (Folders in Bold, Predefined Conditions in Italics):

  • SL GEMS Data (new Class under SL Transactions folder)
    • GEMS CNetID
    • GEMS Credit Card Transactions
    • GEMS Out of Pocket Reports
    • GEMS Credit Card Transaction
      • GEMS Credit Card Transaction ID
      • GEMS Credit Card Vendor Name
    • GEMS Out of Pocket Report
      • GEMS Out of Pocket Report ID
      • GEMS Out of Pocket Report Description
  •  GL GEMS Data (new Class under GL Transactions folder)
    • GEMS CNetID (GL)
    • GEMS Credit Card Transactions (GL)
    • GEMS Out of Pocket Reports (GL)
    • GEMS Credit Card Transaction
      • GEMS Credit Card Transaction ID (GL)
      • GEMS Credit Card Vendor Name (GL)
    • GEMS Out of Pocket Report
      • GEMS Out of Pocket Report ID (GL)
      • GEMS Out of Pocket Report Description (GL)



Keywords:TT Deski Webi Universe GPB GPW encumbrance   Doc ID:32947
Owner:James I.Group:University of Chicago
Created:2013-08-22 09:56 CSTUpdated:2013-10-23 07:58 CST
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  0   0