• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Recipe 6. Time Cards > Ingredients

Ingredients

8 Application Pages:

  • 2 User Pages

    • Add Time Card

    • Project Summary (also accessed by the administrator)

  • 6 Administration Pages

    • Add Project

    • Add Job Code

    • Hours Breakdown

    • Task Detail

    • Task Update

    • View Time Cards

1 Data Source:

  • 1 Database with:

    • 4 Tables

      • TimeCard— Includes records for all time cards entered in the application with fields for the ID, employee, project, date logged, assigned date, hours, and description.

      • Projects— Tracks the available projects, their managers, estimated hours, and actual hours logged.

      • JobTypes— A listing of the tasks available to be assigned on a time card; each job type includes a short description, ID, and billing rate.

      • Employees— This is the standard employee table used throughout the book, used when a new time card is created.

    • 6 SQL Queries

      • ProjectTimeCards— A virtual table joining the TimeCard and Projects tables.

      • HoursBreakdown— A SQL statement that combines the ProjectTimeCards query and JobTypes table.

      • ProjectSummary— A SQL statement that extracts data from the HoursBreakdown query.

      • DailyHours, WeeklyHours, and MonthlyHours— Three separate SQL statements, each of which derives summaries from the HoursBreakdown query.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint