onShore TimeSheet™ Operations Manual | ||
---|---|---|
Prev |
There are some tables in the database. They are listed below:
Table 1. category -- list of possible categories of work for hours and jobs
Field Name | Data Type | Field Definition |
---|---|---|
category_id | text | the id for the category |
creator_id | text | the id for who created the category |
Table 2. client -- list of all clients with open or closed jobs
Field Name | Data Type | Field Definition |
---|---|---|
default_bill_rate | money | the default billing rate for the client |
client_id | int | client id (generated externally from onShore TimeSheet) |
default_approved | int | if automatically approved, 0 = no, 1 = yes |
Table 3. hours -- list of all logged, approved and deleted hours in onShore TimeSheet
Field Name | Data Type | Field Definition |
---|---|---|
downloaded | text | downloaded because approved, 0 = no, 1 = yes |
approval_date | date | the date the hours were approved |
date_entered | date | date the user logged the hours, generated by onShore TimeSheet as the time the entry is made |
time_in | text | time the hours entry started |
time_out | text | time the hours entry stopped |
intime | text | date the user attributes the hours worked |
expense_amount | money | |
fkapprover_id | text | the id of the supervisor who approved the hours |
parking | real | parking fees accrued for this hours entry |
comment | text | comments about the hours worked |
hours_description | text | the description of the hours worked |
del | text | is this a deleted hours entry, 0 = no, 1 = yes |
billable | int | should this be billable to the client, 0 = no, 1 = yes |
hours_id | int | id of the hours being logged, generated internally by onShore TimeSheet |
category | text | category for this work (from set list) |
Table 4. job -- list of all possible jobs
Field Name | Data Type | Field Definition |
---|---|---|
downloaded | text | if the job has been downloaded or not, 0 = no, 1 = yes |
default_approved | int | any hours logged to the job are automatically approved |
flag_hrs | int | number of hours logged to this job for flagging a warning to the supervisor |
job_id | int | id of the job, generated internally by onShore TimeSheet |
bill_rate | money | the billing rate for this job |
current_hours_estimate | real | |
open_date | date | date the job was opened |
estimated_hours | real | estimated number of hours for the completion of this job |
open | int | job is open or not, 0 = no, 1 = yes |
close_date | date | date the job was closed |
fknotify_id | text | list of user id's, as relate to the personnel_ids in the personnel table, to notify of the job's creation |
current_estimate_date | date | the date the estimate of hours was made on the job |
job_description | text | the description of the job |
category | text | category for this job (from set list) |
fksupervisor_id | text | the id of the supervisor responsible for this job, as relates to the id in the personnel table |
Table 5. notification -- table of who should be notified for actions on a job (not implemented)
Field Name | Data Type | Field Definition |
---|---|---|
fkjob_id | int | the job id number (relates to job_id in job table) |
fkpersonnel_id | text | the personnel id number (relates to personnel_id in personnel table) |
Table 6. personnel -- list of all personnel, employees and supervisors who use timesheet
Field Name | Data Type | Field Definition |
---|---|---|
text | e-mail address | |
first_name | text | user's first name |
personnel_id | text | the logon id for the user |
last_name | text | user's last name |
super_user | text | if they have supervisor status or not, 0 = no, 1 = yes |
middle_name | text | user's middle initial |