Financial Data Sources

Tableau financial data sources allow users to access curated data behind the Fiscal Panther Hub dashboards. Once granted access to the enterprise dashboards through the Federated Authorization process (GL Mart), you will have access to the enterprise GL data sources and Tableau Web Edit.

Join our Analytics and Data at Pitt Team site for posts from the Analytics team and for connecting with others using the data source and other content.

Available field definitions and report guidance can be downloaded:

*Click the download icon in the upper right of the screen to download the full document. Each source has its own worksheet and additional sheets contain guidance and definitions.

GL Transactions + Encumbrance

This data source contains GL transaction level detail, including encumbrances from PantherExpress purchase orders and the PBCS forecasting applications (Operating Funds Forecasting and Grants Forecasting). Data is updated nightly from transactions posted to the general ledger and imported from PantherExpress and PBCS.

This data source should be used when transaction details are required and/or transaction totals by a range of months are needed. It cannot be used for monthly budget balances as Budgets are posted in PRISM to specific periods. For operating accounts, the budgets typically follow the Fiscal Year. The initial budget is loaded to July in October and BMRs can happen throughout the year. For Sponsored projects, the budget initial budget is loaded when the project is activated and BMRs can happen throughout. This source can be used to find budget transactions but should not be used for budget balances.

Encumbrances are always rolled forward and will be shown in the current GL period. A separate data source is in development to provide detailed encumbrance information.

See the GL Data Dictionary for specific field information and guidance.

GL Monthly + Encumbrance

This data source contains the monthly snapshots of aggregate general ledger information, including encumbrances from PantherExpress purchase orders and the PBCS forecasting applications (Operating Funds Forecasting and Grants Forecasting). The PantherExpress and PBCS encumbrance snapshots began in December 2024. Data is updated nightly from transactions posted to the general ledger however the final month total is not complete until the month end close process as completed. The month end closes is typically finalized in PRISM on the 4th business day of the new month. Additional information on the PRISM month end close can be found on the Controllers Office site.

This data source should be used to find account and budget balances at the end of each GL period. Fiscal Year to Date (FYTD) and Project Year to Date (PYTD) represent separate aggregate measures and should not be summed together. Fiscal Year to Date (FYTD) tracks all relevant financial activity from the beginning of the fiscal year up to the current date. Project Year to Date (PYTD) aggregates financial activity from the start of the project to the current date (which could span multiple fiscal years). Since each is already a cumulative total based on different time frames and scopes, adding them would result in double-counting or misrepresenting the financial data.

See the GL Data Dictionary for specific field information and guidance.

GL Labor Transactions

This data source contains the detailed labor distribution transaction information from payroll records. Labor distribution is posted within PRISM as part of the GL month end close process and thus information is only available after the month end close process has completed. The month end closes is typically finalized in PRISM on the 4th business day of the new month. Additional information on the PRISM month end close can be found on the Controllers Office site.

When using this data source, keep in mind that payroll activity can be posted to GL during the month and will appear in the compensation subcodes (5xxx). The example is adjustments and hourly employees. However, fringe benefits are not calculated until the month end close, as well as the employee detail as noted above. Additionally, adjustments and regular pay are two distinct fields and both should be reviewed when assessing account activity.

See the GL Data Dictionary for specific field information and guidance.

Labor SPAR Period

This data source contains detailed SPAR information for employees on the monthly payroll (those whose distributions are processed via a SPAR record). SPAR distribution percentages can be changed in PRISM after the period has closed until the SPAR period has been certified. There are three SPAR periods per calendar year, each are four month long: JAN-APR, MAY-AUG, SEP-DEC. The new SPAR period is generated after the prior period is closed. The closing process can take several days and thus the new SPAR period is not typically not available for the first six business days of the new period. Employees will have a period without an active SPAR. these periods are the first days in January, May and September. Projected distribution information is also included when the forecasting applications have been used to create employee encumbrances. Data from the PBCS applications (Grants Forecasting and Operating Funds Forecasting) is imported daily.

See the GL Data Dictionary for specific field information and guidance.

Labor TEAM Hourly

This data source contains detailed current TEAM task information for hourly employees(employees on the bi-weekly payroll). TEAM information is maintained in Pitt Worx. An hourly employee can be assigned more than one task. A task is typically their primary job in which they log hours worked on a weekly time card. When hours are logged and approved for the task, the labor distribution process will charge the active distribution percentage and hourly rate for the task. Once labor is charged, changes for paid hours must be processed through a journal entry. The task effective dates and percentages can be changed at any time. Unlike SPAR, labor distribution adjustments are not automatically created and thus historical information is not available as it may not reflect the actual labor distribution charges to the task/rate/account.

See the GL Data Dictionary for specific field information and guidance.

Labor PBCS Detail

This data source contains detailed employee compensation encumbrances from the enterprise forecasting applications: Operating Funds Forecasting and Grants Forecasting. The applications are built on the Oracle EPM platform, formerly PBCS (Planning Budgeting and Cloud Solution). These applications allow designated financial users to centrally manage budgets, track expenses, and provide compensation and non-compensation forecasting for all entities. PRISM and Pitt Worx data is loaded daily to allow ongoing budget maintenance. For more information, please visit Oracle Planning and Budgeting Cloud Solution - PBCS

See the GL Data Dictionary for specific field information and guidance.