• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Enterprise Data Warehouse
Logo, Texas A&M University System, Office of Information Technology
  • Home
  • About
    • Governance
    • Security
      • Quarterly User Review Process
      • Quarterly User Review Form
      • Authorized Security Requesters
  • Documentation
  • Report Inventory
    • All Commonly Used Reports
    • Reports Grouped by Process
  • Universes
    • HCM Universes
    • Financial Universes
    • Payroll Universes
    • Historic BPP Universes
  • Training
  • Data Status
    • Academic Data Status
    • Budget Load Status
    • Data Load Status
    • Payroll Data Status
  • Office of Information Technology
    • Services
    • Contact the Office of Information Technology
    • Search OIT
Home / Universes / Financial Universes / Financial SL-GL Combined

Financial SL-GL Combined

Purpose

The purpose of the SL-GL Combined universe is to provide, in a single universe, all activity that impacts the GLs fund balance. This is done by normalizing activity in GL account controls (4000-4999) with activity on SL subcodes (0001-9999) into a single view.

Due to the blending of data from two data sources – at times queries on this universe can be slower than on the SL-SA Summary and the GL Snapshot.

Also with this universe, since all SL accounts map to a GL account, all activity can be reported by GL account.

Grain

A record is kept in this universe for every object code, per support account, per fiscal month, per fiscal year. This is why it is called a summary universe – additional detail is available in the transaction detail universe.

For GL Accounts, this universe only include fund addition and deduction subcodes (4000-5999).

Measures

The measures in this universe are complex. Since this universe involves reclassification of amounts based on different classification methods – it contains many measures.

Net Service Departments – Some of the measures in this universe are coded (Net-DSD). This means that this measure is computed after service department revenues are netted against service department expenses. So one can expect, if using the Net-DSD measures, that revenues will be zero in the designated service department fund groups, and that expenses will be reduced by those revenues in the same fund groups.

By Budget Pattern Group These measures are based on the classification of actuals into revenues, expenses, and transfers. This classification is based on the budget pattern that the object code maps to in the master object code database. (Maintained on the TAMUS.EDU web site). For example, the indirect cost expense object codes (9600-9699) are mapped to System pattern R35 (Contracts and Grants Revenue). Therefore, these actuals will show up in the measure (BP Revenues). So the measures are:

  • BP Expenses – Actuals from object codes that are mapped to an “Expense” type budget pattern. Expense are carried as positive numbers.
  • BP Revenues – Actuals from object codes that are mapped to an “Revenue” type budget pattern. Revenues are carried as positive numbers.
  • BP Transfers – Actuals from object codes that are mapped to an “Revenue” type budget pattern. Transfers In will be positive, Transfers out will be negative.
  • BP Adjustments – Actuals from object codes that are mapped to an “Adjustment” type budget pattern. Positive adjustments increase the fund balance.
  • BP Net Change – The net change contains all actuals, and are signed to reflect the net impact on fund balance.

By AFR Group These measures are based on the classification of actuals into revenues, expenses, and transfers. This classification is based on the AFR Roll-up group that the object code maps to in the master object code database. (maintained on the TAMUS.EDU web site). For example, the object code 6311 is mapped to AFR Rollup group Revenue-Net Professional Fees. Therefore, these actuals will show up in the measure (AFR Revenues). So the measures are:

  • AFR Expenses – Actuals from object codes that are mapped to an “Expense” type AFR rollup group. Expense are carried as positive numbers.
  • AFR Revenues – Actuals from object codes that are mapped to an “Revenue” AFR rollup group. Revenues are carried as positive numbers.
  • AFR Transfers – Actuals from object codes that are mapped to an “Revenue” AFR rollup group. Transfers in will be positive, transfers out will be negative.
  • AFR Adjustments – Actuals from object codes that are mapped to an “Adjustment” AFR rollup group. Positive adjustments increase the fund balance.
  • AFR Net Change – The net change contains all actuals, and are signed to reflect the net impact on fund balance.

By FAMIS Groups These measures are based on the classification of actuals into revenues, expenses, additions and deductions. This is the FAMIS native classification of object codes:

  • Expenses – Actuals from object codes >= 1000 on SL accounts
  • Revenues – Actuals from object codes < 1000 on SL accounts
  • Additions – Actuals from object codes 4000-4999 on GL accounts
  • Deductions – Actuals from object codes 5000-5999 on GL accounts
  • Net Change – The net change contains all actuals, and are signed to reflect the net impact on fund balance.

Filters

Filters are predefined limiting criteria that allow you to select a subset of the data in the universe. This universe has the following filters defined:

  • Exclude GL subcodes 4700 and 5700 – Since these subcodes are normally used to move funds to fund balance reserves (2759-2799) – these subcode are often excluded when running change in fund balance reports.
  • Current funds – AFR fund group between 10 and 40.
  • Designated Services Department Fund Groups – AFR fund group between 21 and 29.
  • Current Month Year – This filter select the last loaded fiscal month
  • Current Fiscal Year – This filter selects the last loaded Fiscal Year
  • GL Accounts Only – Select only GL accounts.
  • SL Accounts Only – Selects only SL accounts.

Dimensions

This universe contains links to the following dimensions. Any attribute in these dimensions can be used to sort, filter, subset, or include on the report or graph.

  • Time
  • Member
  • Organization
  • Account Attributes
  • Subcode / Category
  • Sponsor
  • GL Account Attributes

Primary Sidebar

Related

  • Financial Budget Detail
  • Financial Fixed Assets
  • Financial GL Account Snapshot
  • Financial SL-GL Balances
  • Financial SL-GL Combined
  • Financial SL-SA Account Summary
  • Financial Voucher
  • Financial Account Transaction Detail

Copyright © 2025 Texas A&M University System All rights reserved.

301 Tarrow Street, College Station, TX 77840 | MAP | Phone: (979) 458-7700 | email: support@tamus.edu
State of Texas | Texas Homeland Security | Texas Veterans Portal | Statewide Search | Risk, Fraud & Misconduct Hotline | Privacy | Web Accessibility | State Link Policy | Campus Carry

Texas A&M University System