This table stores information of defect tracking change request form.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| formobjid | integer | not null | Object ID of form |
| dtapplication | varchar(66) | with null | User-defined form field. Application. |
| dtcategory | char(12) | with null | User-defined form field. . Possible Example: category |
| dtcomponent | varchar(66) | with null | User-defined form field.. Possible Example: component |
| dtconfirmedby | varchar(66) | with null | User-defined form field : Possible Example: confirmer |
| dtconfirmedos | char(32) | with null | User-defined form field. Possible Example: confirmed os |
| dtconfirmedversion | char(32) | with null | User-defined form field. Possible Example: confirmed version |
| dtdateclosed | date | with null | User-defined form field. Possible Example: date closed |
| dtdateconfirmed | date | with null | User-defined form field. Possible Example: date confirmed |
| dtdatereported | date | with null | User-defined field. Automatically populated by a trigger when you create the form. |
| dtdefectkey | char(19) | with null | User-defined form field. Possible Example: defect key |
| dtdescription | varchar(2000) | with null | User-defined form field. Possible Example: description of the problem |
| dtdeveloper | char(32) | with null | User-defined form field. Possible Example: developer |
| dtdocimpact | char(12) | with null | User-defined form field. Possible Example: impacts docs (YES/NO) |
| dtdocument | varchar(130) | with null | User-defined form field. Possible Example: document needing changes |
| dtfixby | date | with null | User-defined form field. Possible Example: date fix is required |
| dtimpact | char(9) | with null | User-defined form field. Possible Example: impact of the fix |
| dtinvestigator | char(32) | with null | User-defined form field. Possible Example: investigator of the problem |
| dtinvestnotes | varchar(2000) | with null | User-defined note. Possible Example: investigation notes |
| dtkeyword | varchar(66) | with null | User-defined form field. Possible Example: keyword for the fix |
| dtlikelihood | char(9) | with null | User-defined form field. Possible Example: chances of this bug happening |
| dtmilestone | char(12) | with null | User-defined form field. Possible Example: which milestone this fix falls under |
| dtorigin | char(8) | with null | User-defined form field. Possible Example: where this problem came from |
| dtothercategory | char(30) | with null | User-defined form field. Possible Example: another category for the fix |
| dtpriority | char(10) | with null | Select Table option menu |
| dtrecommend | varchar(77) | with null | User-defined form field. Possible Example: recommended action |
| dtreleasenum | char(32) | with null | User-defined form field. Possible Example: the release number |
| dtreportedby | varchar(66) | with null | User-defined form field. Possible Example: who reported the problem |
| dtreportedos | char(32) | with null | User-defined form field. Possible Example: reported os |
| dtresolution | varchar(2000) | with null | User-defined form field. Possible Example: the resolution |
| dtrevisionnum | char(32) | with null | User-defined form field: |
| dtseverity | char(21) | with null | Selectable option menu |
| dttestcases | varchar(2000) | with null | User-defined form field. Possible Example: test cases |
| dttester | char(32) | with null | User-defined form field. Possible Example: who did the testing |
| dttestresults | varchar(2000) | with null | User-defined form field. Possible Example: results of the testing |
| dtunittest | varchar(2000) | with null | User-defined form field. Possible Example: unit tests |
Product Name: AllFusion Harvest Change Manager
Table Type: Table