ProjectPlanHours View

Applies to QAComplete 12.83 SaaS, last modified on June 23, 2021

Description

Contains information about the posted hours spent on working on project plan tasks.

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.

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

The number of posted work hours the item contains.

IsActive  :  char (max 1 char), allows null: no, default: Y

Indicates whether the plan is active.

ProjId  :  int, allows null: no

The ID of the project that contains the item.

ProjPlanId  :  int, allows null: no

The unique numeric identifier of the project plan.

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

The name of the project plan.

TaskId  :  int, allows null: no

An alias for the FKId column of the Workhours table.

The ID of the related item.

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

The name of the project plan task.

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

ProjectPlans Table
Project Management

Highlight search results