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.

This article explains 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 9, 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 is now the Credit Card Transaction ID or the Out of Pocket Report ID. Previously this was the report name.

PO/Encumbrance Number, Transaction Number and Control Number: For GEMS transactions, this is now the Credit Card Transaction ID or the Out of Pocket Report ID. Previously this was the name of the employee submitting the GEMS Report

PO/Encumbrance Number: first 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 and Predefined Conditions):

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, Webi, Universe, GPB, GPW, encumbrance   Doc ID:32947
Owner:James I.Group:University of Chicago
Created:2013-08-22 10:56 CDTUpdated:2017-03-02 20:54 CDT
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  0   0