Timesheet (tim)
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)