What is the Foundation Data Model?
- The Foundation Data Model (FDM) is a framework that supports reporting, security, and workflow in Workday.
- The Foundation on Data Model will replace the current Chart of Accounts (i.e. FOAP)
- Current Banner fund and org numbers will become worktags in Workday.
- It is no longer necessary to memorize long strings of numbers, instead utilize Workday’s search functionality to find worktags.
What is a Worktag?
- Worktags are dimensions that help identify financial transactions and categorize them for reporting.
- Worktags entered on transactions drive workflow. For example, if a transaction requires approval, the Worktags entered may determine who it routes to.
- Worktags can be organized into hierarchies which can streamline reporting.
Worktag Types
There are 3 types of worktags:
- Driver Worktags: A type of worktag identifying the primary source that drives a transaction.
- Related Worktags: A type of worktag that can auto-populate based on the driver worktag entered on a transaction
- Other worktags: Any other worktags that may need to be added based on the type of transaction
By entering a driver worktag, which is required on most transactions, related Worktags will be able to automatically populate their values
Examples:
|
Banner
|
Banner
|
Workday
|
Workday
|
|
Fund
|
100000
200000-209999
210000-219999
230000-239999
|
Fund Worktag
|
FD1000
FD2000
FD2100 OR FY2110 (depending on restriction)
FD2300
|
|
Org
|
10000-President’s office
21000-Dean’s office CBS
|
Cost Center Worktag
|
CC10000 - President’s office
CC21000- Dean’s office CBS
|
|
Account
|
6440-Office Supplies
6836-Equipment
4327-Testing income
|
Ledger Account
Spend Categories
Revenue Categories
|
6440-Office Supplies
Office Supplies (maps to 6440 ledger acct)
Equipment (maps to 6800 ledger acct)
Testing income (maps to 4320 General revenue)
|
|
Program Code
|
10-Instruction
50-Student Services
|
Function worktag
|
FX010-Instruction
FX050-Student Services
|
|
Activity
code
|
5071-Annual Giving
|
Custom Worktag (not required to be entered)
|
Annual Giving
|
|
What is different?
|
|
Fund
|
205210-FMS-Finance office
|
Designated Fund Worktag
|
DF205210-FMS-Finance office (fund will prefill with FD2000
|
|
Fund
|
21’s 22’s, 23’s, 24’s, 53’s,
54’s
|
Gift Fund Worktag
|
GIFT220060-Scholarship-Annual Fund (fund will prefill with FD2200)
|
|
Fund
|
7 project funds
|
Project worktag
|
PRJ700580-Technology Renewal (fund will prefill with FD7000)
|
| |
|
LTV (lifetime value) worktag
|
New and will prefill for you based on Cost Center
|
| |
|
Campus worktag
|
University system, Abilene, Dallas (new will be driven by Cost Center)
|
|
Finance & Accounting/Budget
|
|
Banner
|
Workday
|
|
Budget
|
Budget or Plan
|
|
Budget Transfer
|
Budget Amendment
|
|
FUPLOAD or FEED
|
EIB (Enterprise Interface Builder)
|
|
FGAJVCM
|
Create Journal
|
|
FGITBSR or FGITBAL
|
Balance sheet or Trial Balance
|
|
Index (Also FUND)
|
Worktags: Activity/Gift/Grant/Project
|
|
Pool Account
|
Ledger Account Summary
|
|
Proxy
|
My Delegations
|
|
Rule Class
|
Amendment Type
|
|
Purchasing/Expenses
|
|
Banner
|
Workday
|
|
Account
|
Spend Category
|
|
Vendor
|
Supplier
|
|
Vendor History
|
Find Supplier
|
|
Vendor Inquiry
|
View Supplier Invoice
|
|
Vendor Invoice Number
|
Supplier Reference number
|
|
Request a PO
|
Create a Requisition
|
|
Approval Process
|
Business Process
|
|
Request for Payment (Direct Pay)
|
Create Supplier Invoice Request
|
|
Document History
|
My Receipt/My Requisition
|
|
Find vendor Invoice
|
Find Suppliers/Find Supplier Invoices
|
|
Invoice Inquiry
|
Find Supplier Invoices
|
|
Non-employee payment
|
Ad Hoc Payment Request
|
|
PCard (Concur)
|
PCard (Procurement Card) Expense
|