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:

NameTypeLabelDescription
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=campagne; 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=campagne}

tim_perprj_unid *String
The unique ID of the person's participation document.
tim_break_durationNumberBreak durationThe break duration between two intervals of working within  a day (e.g. "1,50" means an hour and half break)
tim_break_startTime/DateBreak startBeginning of the break as date and time within  a day (e.g. 13:15 means quartal past one p.m.)
tim_break_endTime/DateBreak endEnd of the break as date and time within  a day ( e.g. 14:15 means quartal past two p.m.)
tim_cce_nameString
Name of the cost center ( e.g. "IT-Support"; "Region-South")
tim_cce_unidString
The unique-ID of the cost center document.
tim_date *Time/Date
The date for which the time sheet is created.
tim_startTime/Date
Beginning of the work as date and time within  a day ( e.g. 08:15 means quartal past eight a.m.)
tim_endTime/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 *StringDescriptionDescribes the working details.
tim_fee

Number

FeeRepresents the fee of the assigned working time as a value.
tim_has_breakString

"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_cmaString

"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 NameRepresents 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_unidString 
The unique ID of the position document.
tim_prj_name
Process nameThe 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)