Finance Data Model updates

March 27, 2024

Effective Wednesday, March 27 several new items have been added to the Finance Data Model. 

  • New fields pulling from YBT tables to help facilitate budget office reporting:
    • Charging Cost Center Management Rollup
    • Charging Cost Center Management Rollup Alternate
    • Charging Cost Center Functional Rollup
    • Charging Cost Center Functional Rollup Alternate
  • Additional sponsor and award fields from Workday for reporting enhancements and efficiencies:
    • Sponsor ID
    • Sponsor Status
    • Sponsor Tax ID
    • Prime Sponsor
    • Prime Sponsor ID
    • Prime Sponsor Type
    • Final Award Sponsor Name
    • Final Sponsor Type Category
    • Award Phase
    • Includes Ended, Ending Within 6 Months, Ending Within 90 Days, Ongoing
    • Award Line Basis Limit
    • Award Anticipated Sponsor Total Amount

Please email askfinance@yale.edu with questions or concerns.