Description
Contains detailed information on created defects.
Dependencies
Columns
ActFinish : datetime, allows null: yes
The date when the defect was fixed.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
ActHrs : decimal (max 18 decimal digits), allows null: yes, default: 0
The actual number of hours spent to fix the defect.
ActStart : datetime, allows null: yes
The date when the work on fixing the defect started.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
ActualResults : varchar (max), allows null: yes
The actual results of performing the reproduction steps as compared to the expected results.
This column corresponds to a field that can be available for Rich Text Feature.
AssignedToName : varchar (max 78 chars), allows null: yes
The name of the user to whom the associated item is assigned, in the Last name, First name format.
AssigneeUserId : int, allows null: no, default: 0
The ID of the user to whom the defect is assigned.
BugId : int, allows null: no
The unique numeric identifier of the item.
ClosedBy : int, allows null: yes, default: 0
The ID of the user who closed the item.
ClosedByName : varchar (max 78 chars), allows null: yes
The name of the user who closed the associated item, in the Last name, First name format.
Custom1..Custom10 : varchar (max 8000 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.
DateClosed : datetime, allows null: yes
The date and time the defect was closed.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateCreated : datetime, allows null: yes, default: Current date and time
The date and time the item was created.
DateLastEscalated : datetime, allows null: yes
The date when the associated item was last affected by an escalation rule.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateOpened : datetime, allows null: no, default: Current date and time
The date and time the defect was opened.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateResolved : datetime, allows null: yes
The date and time the defect was resolved.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateUpdated : datetime, allows null: no, default: Current date and time
The date the item was last updated.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
Description : varchar (max), allows null: yes
The defect’s description.
This column corresponds to a field that can be available for Rich Text Feature.
DestinationFastEditTitle : int, allows null: yes
The column was used in previous releases, and no longer used.
DestinationId : int, allows null: yes
The column was used in previous releases, and no longer used.
DestinationProject : int, allows null: yes
The column was used in previous releases, and no longer used.
DestinationProjId : int, allows null: yes
The column was used in previous releases, and no longer used.
EstFinish : datetime, allows null: yes
The date and time the work on the defect is estimated to finish.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
EstHrs : decimal (max 18 decimal digits), allows null: yes, default: 0
The estimated time the defect will take to resolve, in hours.
EstHrsRemaining : decimal (max 18 decimal digits), allows null: yes, default: 0
The estimated number of hours remaining to fix the defect.
EstStart : datetime, allows null: yes
The date and time the work on the defect is estimated to start.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
ExpectedResults : varchar (max), allows null: yes
The expected software results, if there were no this defect.
This column corresponds to a field that can be available for Rich Text Feature.
FolderId : int, allows null: yes
The unique identifier of the folder where the item is located.
FolderName : varchar (max 511 chars), allows null: yes
The name of the folder where the associated item is located.
FunctionalAreaCode : varchar (max 100 chars), allows null: yes
The functional area related to the defect. The code of the functional area is taken from the choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal FunctionalArea in the ValidationType column.
HowFoundCode : varchar (max 100 chars), allows null: yes
Information on how the defect was found based on the choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal BugHowFound in the ValidationType column.
ImportId : int, allows null: yes
The ID of the imported batch in which the defect was imported.
IssueCode : varchar (max 100 chars), allows null: yes
The issue code based on the choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal BugIssue in the ValidationType column.
LastEscalationRule : varchar (max 100 chars), allows null: yes
The name of the escalation rule that last affected the associated item.
LastEscalationRuleId : int, allows null: yes
The ID of the escalation rule that last affected the associated item.
ModuleCode : varchar (max 100 chars), allows null: yes
The module related to the defect. The code of the module is taken from the choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal BugModule in the ValidationType column.
NbrEscalations : int, allows null: no
The number of escalation rules affected to the defect.
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.
NbrFilesNotSecured : int, allows null: yes
The column is reserved for system use only.
NbrNotes : int, allows null: yes
The number of notes attached to the associated item.
NbrTasks : int, allows null: yes
The number of tasks attached to the associated item.
NotesDescription : varchar (max), allows null: yes
An alias for the LatestNotes column of the ExtendedAttributes table.
A description of the latest note attached to the associated item.
OpenedBy : int, allows null: no, default: 0
The ID of the user who created the defect.
OpenedByCompany : varchar (max 50 chars), allows null: yes
An alias for the CompanyName column of the Persons table.
The name of the company where the user works.
OpenedByEmail : varchar (max 255 chars), allows null: no
An alias for the Email column of the Persons table.
The email address of the user.
OpenedByName : varchar (max 78 chars), allows null: yes
The name of the user who added the associated item, in the Last name, First name format.
OriginalId : int, allows null: yes
The column is reserved for system use only.
OriginCode : varchar (max 100 chars), allows null: yes
The column is reserved for system use only.
OwnerName : varchar (max 78 chars), allows null: yes
The name of the user who owns the associated item, in the Last name, First name format.
OwnerUserId : int, allows null: yes, default: 0
The ID of the user who owns the defect.
PctComplete : tinyint, allows null: yes, default: 0
The percentage of work completed to fix the defect.
QAComplete calculates this value automatically when the user specifies how many hours have been spent to fix the defect. To learn more, see Calculation of Percent Complete and Estimated Hours Remaining.
PriorityCode : varchar (max 100 chars), allows null: yes, default:
The defect’s priority based on the choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal BugPriority in the ValidationType column.
ProjId : int, allows null: no
The ID of the project that contains the defect.
Resolution : varchar (max), allows null: yes
The defect’s resolution details.
This column corresponds to a field that can be available for Rich Text Feature.
ResolutionCode : varchar (max 100 chars), allows null: yes
The resolution code based on the choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal BugResolution in the ValidationType column.
ResolvedBy : int, allows null: yes, default: 0
The ID of the user who resolved the item.
ResolvedByName : varchar (max 78 chars), allows null: yes
The name of the user who resolved the associated item, in the Last name, First name format.
SeverityCode : varchar (max 100 chars), allows null: yes, default:
The severity of the defect based on the choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal BugSeverity in the ValidationType column.
SoftwareVersionCode : varchar (max 100 chars), allows null: yes
The software version that relates to the defect. The code of the version is taken from the choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal SoftwareVersion in the ValidationType column.
SourceFastEditTitle : int, allows null: yes
The column was used in previous releases, and no longer used.
SourceID : int, allows null: yes
The column was used in previous releases, and no longer used.
SourceProject : int, allows null: yes
The column was used in previous releases, and no longer used.
SourceProjId : int, allows null: yes
The column was used in previous releases, and no longer used.
StatusCode : varchar (max 100 chars), allows null: yes
The status of the defect based on the choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal BugStatus in the ValidationType column.
StepsToRepro : varchar (max), allows null: yes
The steps to reproduce the defect.
This column corresponds to a field that can be available for Rich Text Feature.
TestCaseId : int, allows null: yes
If the defect was created from a failed legacy test case, TestCaseId is the unique identifier of the related test case.
Title : varchar (max 255 chars), allows null: yes
The title of the defect.
TypeCode : varchar (max 100 chars), allows null: yes
The column is reserved for system use only.
UpdateUserId : int, allows null: yes
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 associated item, in the Last name, First name format.