Projects View

Applies to QAComplete 12.90 SaaS & On-Premises, last modified on September 09, 2021

Description

Contains detailed information on projects.

Dependencies

Columns

ActualCost  :  money, allows null: yes

The column is reserved for system use only.

ActualHrs  :  decimal (max 18 decimal digits), allows null: yes

The column is reserved for system use only.

Custom1..Custom10  :  varchar (max 2500 chars), allows null: yes

The values of custom fields 1 - 10.

These columns correspond to fields that can be available for Rich Text Feature.

Custom11..Custom90  :  varchar (max 100 chars), allows null: yes

The values of custom fields 11 through 90.

DateBeginActual  :  datetime, allows null: yes

The column is reserved for system use only.

DateBeginScheduled  :  datetime, allows null: yes

The column is reserved for system use only.

DateCreated  :  datetime, allows null: no, default: Current date and time

The date and time the project was created.

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

DateEndActual  :  datetime, allows null: yes

The column is reserved for system use only.

DateEndScheduled  :  datetime, allows null: yes

The column is reserved for system use only.

DateUpdated  :  datetime, allows null: no, default: Current date and time

The date and time the project was last updated.

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

DeptId  :  int, allows null: no

The numeric identifier of the department that owns the project.

EstCost  :  money, allows null: yes

The column is reserved for system use only.

EstHrs  :  decimal (max 18 decimal digits), allows null: yes

The column is reserved for system use only.

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

Indicates whether the project is active.

IsAutoCalc  :  char (max 1 char), allows null: yes, default: Y

The column is reserved for system use only.

NbrEvents  :  int, allows null: yes

The number of events attached to the associated item.

NbrFiles  :  int, allows null: yes

The number of files attached to the associated item.

NbrNotes  :  int, allows null: yes

The number of notes attached to the associated item.

ProjId  :  int, allows null: no

The unique numeric identifier of the project.

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

The name of the project.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

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

The name of the user who last updated the project.

See Also

Projects Table
Setup

Highlight search results