Workhours View

Applies to QAComplete 12.71 SaaS, last modified on January 19, 2021

Description

Contains records from the Workhours table with extra information, such as the title of the related item, the ID of the project that contains the item, and so on.

Dependencies

Columns

DateUpdated  :  datetime, allows null: no

The date and time when the item was updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateWorked  :  datetime, allows null: no

The date of work the item contains.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

Description  :  varchar (max 500 chars), allows null: yes

The description of the post.

This column corresponds to a field that can be available for Rich Text Feature.

EntityCode  :  varchar (max 100 chars), allows null: no

The entity code of the related item.

You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.

FKId  :  int, allows null: no

The ID of the related item.

HrsWorked  :  decimal (max 18 decimal digits), allows null: no

The number of posted work hours the item contains.

IsActive  :  varchar (max 1 char), allows null: yes

Indicates whether the related item is active.

ProjId  :  int, allows null: yes

The ID of the project that contains the related item.

ProjPlanId  :  int, allows null: yes

If the related item is a Project plan task, it is the ID of the parent project plan.

ProjPlanName  :  varchar (max 50 chars), allows null: yes

If the related item is a Project plan task, it is the name of the parent project plan.

TeamMember  :  varchar (max 78 chars), allows null: yes

The name of the user who worked the hours.

Title  :  varchar (max 100 chars), allows null: yes

The name of the related item.

UpdateUserId  :  int, allows null: no

The ID of the user who updated the item.

UserId  :  int, allows null: no, default: 0

The ID of the user who worked the hours.

UserName  :  varchar (max 78 chars), allows null: yes

The name of the user who last updated the item.

WorkHoursId  :  int, allows null: no

The unique numeric identifier of the item.

See Also

Workhours Table
Crossmodules

Highlight search results