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