The HDAR Unit consists of about 25 - 30 individual members and 30 or so individual projects carrying out various activities in support of about 10 USF Health departments. Members and  Projects are each individually funded by 1 or more funding source accounts. There are about 5 - 10 funding source account numbers that fund members and projects. Each member or project belongs to a Team. Each Team is a collection of members and projects. Teams do not get individually funded - a Team's funding is an aggregation of all of the members and the projects funds. Members, Projects and Teams record expenses in a ledger that maintains all of the business transactions at this unit. An accounting report is run once a day to sum each member and each project total expenses, and subtract that sum from the funding source account, to calculate the current funds remaining for each member or project. The report is run for members, projects, and teams. The expenses are summed and subtracted for each funding source account individually, so that the member, project and team knows how much money is remaining for each funding source account to spend as well as the total sum of funds remaining. An expense transaction is made up of an initiator, category, type, vendor, purpose, amount, invoice document/receipt, request date, paid date, reconcile date, request FY, paid FY. An expense is associated with 1 member, 1 project, and 1 team (but not all three are needed for an expense); 1 or more departments sharing the expense; and 1 or more funding accounts to pay the expense.
Actors and Roles:
• Members are funded by funding sources and create expenses
• Projects are funded by funding sources and create expenses
• Teams consist of members and projects and create expenses
• Funding Sources fund members and projects
• Departments consist of members and projects and create expenses
• Expenses are the records of business transactions of members, projects, departments, and
teams.

Business Rules:
A Team consists of 1 or more members and 1 or more projects
A member is assigned to one and only one team; and one and only one department; and is funded
by 1 or more funding sources.
A project is assigned to one and only one team; and one and only one department; and is funded
by 1 or more funding sources.
A department consists of 1 or more members and 1 or more projects; and participates in
expenses.
An expense consists of 1 member, 1 project, 1 team (but do not need all three at the same time);
and 1 or more departments; and 1 or more funding sources.
ERD Entities with Attributes:
• Member: MemberID, First and last name, phone, email contact.
• Project: ProjectID, Project name.
• Team: TeamID, Team name.
• Funding_Source: FundID, Fund name, account number.
• Department: DeptID, Department name.
• Expense: ExpenseID, initiator, category, type, vendor, purpose, amount, invoice
document/receipt, request date, paid date, reconcile date, request FY, paid FY,
memberID, projectID, deptID.
EERD Associate Entities:
• Expense_Department_Sharing
• Expense_Funding_Source_Sharing
• Member_Funding_Source
• Project_Funding_Source

 

 

Reports:
• Total amount by type.
o And member
o And Team
o And Project
• Total amount by vendor.
o And member
o And Team
o And Project
• Total amount by purpose.
o And member
o And Team
o And Project
• List all expenses requested in one FY and paid in a different FY.
• List all expenses with no reconcile date
• Total amount by category
o And member
o And Team
o And Project
• List all amounts, request date, paid date and reconcile date
o Sorted by request date
o Sorted by paid date
o Sorted by reconcile date

Answer rating: 100% (QA)

Entity Relationship Diagram ERD for USF Health HDAR Unit Entities Member Project Team FundingSource Department Expense Attributes Member MemberID Firs... View the full answer