New items added to the Finance Data Model effective Dec. 1

    December 1, 2023

    Effective December 1, 2023, the following new items will be added to the Finance Data Model for the community:

    • FN Fiscal Period Dim
      • New field added to report on quarters
      • Example: FY24-Q1, FY24-Q2, etc.
    • FN Supplier Invoice Header Dim
      • New Dimension to the Model named ‘FN Supplier Invoice Header Dim,’ which contains various Header Level Attributes for Supplier Invoice transactions
    • FN Journal Budget Balance Fact
      • New Field to the Journal Budget Balance Fact, named ‘Supplier Invoice Header Invoice Total Amt’
    • Transaction ID field
      • A new field, ‘Transaction ID’ has been created. When selected, this field is comprised of the Operational Transaction Number or Journal Number fields. If blank, it will return the Operational Transaction field
    • ‘Costing Treatment’ field has been added to the ‘General Financial – Dept’ perspective
      • ‘Costing Treatment’ field has been added to the ‘General Financial – Dept.’ perspective in the Finance Data Model for reporting usage
    • FY Journal or Budget Description
      • A new column has been created called ‘FY Journal or Budget Description.’ This is a combination of the following fields:
        • Fiscal Year
        • Row Type
        • Ledger Type Description
      • Example: FY23 Actuals, FY19 Obligations, FY24 FBB Q2 Forecast, etc.
    • ‘As of Date’ field
      • ​o A new “As of Date” field, on the FN Load Data Table, that displays the last date the data was loaded in the Finance Data Model (example: 11/5/2023)