The timesheet entity stores information about the amount of a worker's time spent on a specifik task/job. Timesheets can contain also informations about the time breaks in this working period.
Database level
The entity's attributes are shown below. Mandatory fields are marked with a red star:
|
Name |
Type |
Label |
Description |
|---|---|---|---|
|
form * |
String |
|
Represents the entity form. Will always be "tim". |
|
tim_per_unid * |
String |
|
The unique ID of the person document |
|
tim_per_name * |
String |
|
The name of the person document composed as the first name and the last name (empty space in between). |
|
tim_created_from * |
String |
|
The parent entity type under which the timesheet has been created and referenced. This is limited to: {cce=cost center; sop=opportunity; prj=project; cpg=campaign; sac=activity} |
|
tim_top_parent * |
String |
|
The parent process type under which the timesheet has been created and referenced. This is limited to: {cce=cost center; sop=opportunity; prj=project; cpg=campaign} |
|
tim_perprj_unid * |
String |
|
The unique ID of the person's participation document. |
|
tim_break_duration |
Number |
Break duration |
The break duration between two intervals of working within a day (e.g. "1,50" means an hour and half break) |
|
tim_break_start |
Time/Date |
Break start |
Beginning of the break as date and time within a day (e.g. 13:15 means quartal past one p.m.) |
|
tim_break_end |
Time/Date |
Break end |
End of the break as date and time within a day ( e.g. 14:15 means quartal past two p.m.) |
|
tim_cce_name |
String |
|
Name of the cost center ( e.g. "IT-Support"; "Region-South") |
|
tim_cce_unid |
String |
|
The unique-ID of the cost center document. |
|
tim_date * |
Time/Date |
|
The date for which the time sheet is created. |
|
tim_start |
Time/Date |
|
Beginning of the work as date and time within a day ( e.g. 08:15 means quartal past eight a.m.) |
|
tim_end |
Time/Date |
|
End of the work as date and time within a day ( e.g. 18:15 means quartal past six p.m.). |
|
tim_duration |
Number |
|
Time duration from start working till leaving the office. |
|
tim_desc * |
String |
Description |
Describes the working details. |
|
tim_fee |
Number |
Fee |
Represents the fee of the assigned working time as a value. |
|
tim_has_break |
String |
|
"1" - yes, has a break "0"- no, hasn't a break. |
|
tim_hourly_fee |
Number |
|
The fee per hour of the person which is assigning the time sheet. |
|
tim_perprj_fct |
String |
|
Represents the function of the person within the company as a Pop-up Menu of preset choices. |
|
tim_perprj_role |
String |
|
Represents the function of the person within the project as a Pop-up Menu of preset choices. |
|
tim_pos_is_cma |
String |
|
"1" - yes, it is a time sheet for a change management position "0" - no, it is not a time sheet for a change management position |
|
tim_pos_name |
String
|
Position Name |
Represents the name of the position including number under which the timesheet has been created and referenced. |
|
tim_pos_type |
String
|
|
Represents the type of the position within the process as a Pop-up Menu of preset choices {ser=service; prd=product}. |
|
tim_pos_unid |
String |
|
The unique ID of the position document. |
|
tim_prj_name |
|
Process name |
The name of the project. |
|
tim_prj_unid |
|
|
The unique ID of the project document. |
|
tim_rqa_trvtime |
String
|
|
"1" - yes, the time accounting represents travel time; "0" - no, the time accounting do not represents travel time. |
|
tim_state * |
Number
|
|
The state of the time sheet document as a number limited to {100, 200, 10000} |
|
tim_state_text * |
String |
|
The state of the time sheet document as a Pop-up Menu limited to {planed, assigned, canceled} |
|
tim_work_duration |
Number |
|
Represents the total worked time within the day, without breaks. |
QEE classes level
The class representing the Time-Sheet is QEETim.
Inherits from: QEEObject
REST level
The endpoints dealing with Time-Sheet are:
xrTim (GET, POST, PUT, DELETE)
xrTims (GET, PUT, DELETE)