Workday Foundation Data Model (FDM) Guide
Worktags | Code | Definitions | Helpful Questions and Tips |
---|---|---|---|
Cost Center | CCXXXXX | A unit within an organization to which costs and revenues are recorded. | Which Unit does this Transaction pertain to? Review the ‘EHE Cost Center Hierarchy’ file, or search ‘Cost Center FDM’ in Workday for a list of active values. |
Fund | FDXXX | Represents unrestricted, temporarily restricted, permanently restricted and board designated activities. | What is the funding source being used for the transaction? Review the ‘Workday Worktag Look‐up File’ or search ‘Fund FDM’ in Workday for a list of active values. |
Balancing Unit | BLXXXX | Used when there is a need to track assets and liabilities for the purpose of creating a full balance sheet. | Within EHE, this is associated with the Cost Center; which Cost Center does the transaction pertain to, and what is its associated balancing unit? Review the ‘Workday Worktag Look‐up File’ for a listing of EHE balancing units. |
Gift | GFXXXXXX | An irrevocable transfer of personal property (e.g. cash, securities, books. Equipment) or real property (e.g. land, buildings) by a donor. | Are Advancement funds involved (FD500 or FD510)? If so, a Gift worktag is required. Refer to The Advancement System (TAS) for worktag and equity information. |
Grant | GRXXXXXX | A sum of money utilized by the university for a specific purpose, usually research. | Is this transaction being managed by the Office of Research? Does the transaction involve an agreement between an OSU Unit and an external entity for which a contract/MOU is on file? If so, a grant worktag is required. Refer to the PI Portal @ osp.osu.edu, grant manager, or fiscal representative for more information. |
Program | PGXXXXXX | Used to collect costs and revenue for activities across cost centers that are not date bound. | Is this expense related to an ongoing program or initiative? Is it directly related to an academic program? This is an optional worktag, but is typically included for reporting purposes. |
Activities & Events | AEXXXXXX | Used to track and report revenue and expense for localized activities that are short‐lived or annually reoccurring. | Are there multiple activities within a program worktag for which there may be reporting needs? This is an optional worktag that is less common, but is included when necedssary. |
Assignee | ASXXXXXX | Used to track and report on items at an individual’s level. | Is there a need to track a source of funding for an indvidual? Best practice is to include the assignee value when applicable. |
Area | ARXXXX | Used to track and report revenue, expense and statistics for areas or groups of individuals and nursing units that cross multiple worktags, such as cost centers, programs or projects. | This worktag will default based on other worktags entered for the transaction. |
Reporting Summary for Financial Foundation Data Model (FDM) Values
Financial FDM worktag values are easily found in Workday reports. As new values are created, or existing values inactivated, these reports will reflect those changes in the system.
Find Worktag values
To pul a report of worktag values, simply type the name of the worktag type, followed by “FDM Values” in the search bar in Workday. For example:
- Balancing Unit – FDM Values
- Cost Center – FDM Values
- Gift – FDM Values
- Ledgar Account – FDM Values
- Spend Categories – FDM Values
It is not necessary to input anything in the parameters to run these reports. Simply click Okay.
Some worktag types do not have their own report and are found in one of these reports:
- Custom Worktags – FDM Values (such as Financial Class, Location, Work Order)
- Custom Organizations – FDM Values (such as Academic Period, Assignee)
Guiding Principles ‐ Costing Allocations for College‐backed Personnel
College‐funded faculty and staff on GFA (recurring budget) will require both the Activities & Events and Expenditure Treatment Worktags:
AE102461 EHE | GFA Funded Personnel ‐ ET100 Continuing Funds
College‐funded faculty and staff on Cash (non‐recurring budget) will require both the Activities & Events and Expenditure Treatment Worktags:
AE102462 EHE | Cash Funded Personnel ‐ ET105 Cash Funded
All Faculty, Graduate Assistants, and Lecturer appointments should include an Academic Program worktag:
Faculty Example: Cost Center – Fund – Balancing Unit ‐ Academic Program ‐ AE102461 EHE | GFA Funded Personnel ‐ ET100 Continuing Funds
Specials Example: Cost Center ‐ Fund ‐ Balancing Unit ‐ Academic Program
Some units may choose to further track specials appointments by sub‐program within the main academic program using an Activities & Events value.
This practice is permitted for Specials appointments only
Cost Center
The unit for which
work is being
performed
Fund
The source of funding
for the work being
performed
Balancing Unit
Corresponds to unit
for which work is
being performed
Program
Academic program
for which work is
being performed
Activities & Events
Tracks general funds
budget needed to
fund FTE throughout
the college
Expenditure Treatment
Serves as an identifier for
FTE that should be college‐
backed, but costing has
been temporarily modified
for various business
purposes
Costing Allocation Examples
Tenure‐Track Faculty
CC11168 EHE | Human Sciences Administration – FD100 General Fund – BL1138 EHE | General – PG102108 Consumer Sciences Program – AE102461 EHE | GFA Funded Personnel – ET100 Continuing Funds
CC11168 – FD100 – BL1138 – PG102108 – AE102461 – ET100
Clinical Faculty
CC11168 EHE | Human Sciences Administration – FD100 General Fund – BL1138 EHE | General – PG102108 Consumer Sciences Program –
AE102462 EHE | Cash Funded Personnel – ET105 Cash Funded
CC11168 – FD100 – BL1138 – PG102108 – AE102462 – ET105
Graduate Assistants & Lecturers
CC11168 EHE | Human Sciences Administration – FD100 General Fund – BL1138 EHE | General – PG102108 Consumer Sciences Program
CC11168 – FD100 – BL1138 – PG102108
Staff
CC11168 EHE | Human Sciences Administration – FD100 General Fund – BL1138 EHE | General ‐ AE102461 EHE | GFA Funded Personnel –
ET100 Continuing Funds
CC11168 – FD100 – BL1138 – AE102461 – ET100