all data is live and searchable
|
Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||
|
|
|
Yellow
|
|
|||
|
|||
|
|
|
Notes:
|
|
Database Tables: Elements_of_time – the main time id and element Time_action_logs – automated to record changes in the action status - (?) may need an ending daye/time Time_sub_assignments – actual assignments to main - time_sub_pools – pool names - time_sub_pool_assignments – assignments to a pool - Optional tie to the assignments but not required (all work together) time_sub_comments – comments and notes time_sub_dates – sub dates and times time_sub_gps – gps subs and/or rfid tags table time_sub_payroll – this is how you tie time to payroll time_sub_reminders – this is a sub table to make assignment to remind users time_sub_sign_offs – this is a sub table for sign-offs and sign-off assignment time tmplates – helps to define the needs and settings used for the elements of time When testing…. Add mode… start date, date/time [end date, date/time, none, +/- numbers, every frequency] Edit mode… start date, date/time [end date, date/time, none, +/- numbers, every frequency] Total time with decimals – make sure the conversions work out okay Check every major switch use _ … on the template |