onShore TimeSheet™ Operations Manual

Greg Gallagher

Adam Di Carlo

$Revision: 1.11 $

Table of Contents
Overview of onShore TimeSheet Work Flow and Data Flow
Automated Operations (Cron Entries)
Application Logs
Suggested Backup Operations
PostgreSQL Tuning
Where to Go for Help
Database Dictionary

Overview of onShore TimeSheet Work Flow and Data Flow

This section will give a quick overview of the onShore TimeSheet typical work and data flow. There is no set way or manner that onShore TimeSheet must be used, this is just an example in order to get the big picture:

onShore TimeSheet Work and Data Flow

  1. Client X approaches company for a project or work.

    1. Client X entered in accounting system or database external to onShore TimeSheet which assigns the client a unique Client Id number.

    2. Client X entered into onShore TimeSheet by a supervisor with administration privileges.

  2. Job(s) created (and opened) for Client X.

    1. Users in the onShore TimeSheet system can be notified of the job's creation.

    2. Optional cron script runs to export the job's information for importing into an external database system separate from onShore TimeSheet

  3. User(s) log hours to the job(s).

  4. Cron script runs to inform supervisors that jobs have hours which require their approval.

    1. Optionally, the supervisor can do a search for unapproved hours whenever they wish through the View/Edit Hours screen.

  5. Supervisor approves (and edits if necessary) hours.

  6. Cron script, if optionally installed or enabled by the onShore TimeSheet administrator, exports all hours which have been approved for importing into an external database system separate from onShore TimeSheet. That way approved hours can be directly integrated with an invoicing system in order to bill the client.

  7. Supervisor closes a job after it is completed.