Information about defects.
For table relationships, see the Defect Module Overview.
Column Name | Description | Datatype | Length | Allow Nulls |
|
---|---|---|---|---|---|
BG_BUG_ID | The defect record ID. | Integer | 4 | ||
BG_STATUS | The current status of the defect.
The values are from the Bug Status custom list. Typical values are: Open, Fixed, Closed, New, Rejected, and Reopen. |
VarChar | 70 | ||
BG_RESPONSIBLE | The name of the developer responsible for fixing the defect. | VarChar | 60 | ||
BG_PROJECT | The name of the project in which the
defect was found.
The values are from the All Projects custom list. |
VarChar | 70 | ||
BG_SUBJECT | The subject in the test plan tree to which the bug is related: ALL_LISTS.AL_ITEM_ID. | Integer | 4 | ||
BG_SUMMARY | A summary of the defect. | VarChar | 255 | ||
BG_DESCRIPTION | A description of the defect. | LongVarChar | 16 | ||
BG_DEV_COMMENTS | Comments about the defect, usually by the developer responsible for the defect. | LongVarChar | 16 | ||
BG_REPRODUCIBLE | Indicates whether the tester was able to reproduce the defect. | VarChar | 1 | ||
BG_SEVERITY | The severity level of the defect.
The values are from the Severity custom list. Typical values are: 1-Low, 2-Medium, 3-High, 4-Very High, 5-Urgent. |
VarChar | 70 | ||
BG_PRIORITY | The priority level of the defect.
The values are from the Priority custom list. Typical values are: 1-Low, 2-Medium, 3-High, 4-Very High, 5-Urgent. |
VarChar | 70 | ||
BG_DETECTED_BY | The user name of the tester who found the defect. | VarChar | 60 | ||
BG_DETECTION_DATE | The date the defect was found. | DBTimeStamp | 4 | ||
BG_DETECTION_VERSION | The version in which the defect was detected. | VarChar | 70 | ||
BG_PLANNED_CLOSING_VER | The version in which the developer estimates the defect will be closed. | VarChar | 70 | ||
BG_ESTIMATED_FIX_TIME | The number of days the developer estimates will be required to fix the defect. | Integer | 4 | ||
BG_ACTUAL_FIX_TIME | The number of days worked to fix the defect. | Integer | 4 | ||
BG_CLOSING_DATE | The date the defect record was closed. | DBTimeStamp | 4 | ||
BG_CLOSING_VERSION | The version in which the defect record was closed. | VarChar | 70 | ||
BG_TO_MAIL | Indicates whether a defect report should be mailed to users registered to receive such reports. | VarChar | 1 | ||
BG_ATTACHMENT | Indicates whether the defect record has
any attachments.
The value of this field can be either Y or N. |
VarChar | 1 | ||
BG_USER_01 | User-defined field. | VarChar | 40 | ||
BG_USER_02 | User-defined field. | VarChar | 40 | ||
BG_USER_03 | User-defined field. | VarChar | 40 | ||
BG_USER_04 | User-defined field. | VarChar | 40 | ||
BG_USER_05 | User-defined field. | VarChar | 40 | ||
BG_USER_06 | User-defined field. | VarChar | 40 | ||
BG_USER_07 | User-defined field. | VarChar | 40 | ||
BG_USER_08 | User-defined field. | VarChar | 40 | ||
BG_USER_09 | User-defined field. | VarChar | 40 | ||
BG_USER_10 | User-defined field. | VarChar | 40 | ||
BG_USER_11 | User-defined field. | VarChar | 40 | ||
BG_USER_12 | User-defined field. | VarChar | 40 | ||
BG_USER_13 | User-defined field. | VarChar | 40 | ||
BG_USER_14 | User-defined field. | VarChar | 40 | ||
BG_USER_15 | User-defined field. | VarChar | 40 | ||
BG_USER_16 | User-defined field. | VarChar | 40 | ||
BG_USER_17 | User-defined field. | VarChar | 40 | ||
BG_USER_18 | User-defined field. | VarChar | 40 | ||
BG_USER_19 | User-defined field. | VarChar | 40 | ||
BG_USER_20 | User-defined field. | VarChar | 40 | ||
BG_USER_21 | User-defined field. | VarChar | 40 | ||
BG_USER_22 | User-defined field. | VarChar | 40 | ||
BG_USER_23 | User-defined field. | VarChar | 40 | ||
BG_USER_24 | User-defined field. | VarChar | 40 | ||
BG_USER_HR_01 | BG_USER_HR_01 to BG_USER_HR_06 are for backward compatibility. Fields may be removed in future version. | Integer | 4 | ||
BG_BUG_VER_STAMP | A number indicating the revision number of this record. Increments each time a change is made. | Integer | 4 | ||
BG_HAS_CHANGE | For backward compatibility. | VarChar | 50 | ||
BG_VTS | The version time stamp. Indicates the time this record was last changed according to the database server. | VarChar | 20 | ||
BG_EXTENDED_REFERENCE | For internal use. Do not change data. | VarChar | 50 | ||
BG_REQUEST_ID | The ITG Request ID. This field is used internally by ITG to link ITG requests to defects. | Integer | 4 | ||
BG_TEXT_SYNC | For internal use. Do not change data. | VarChar | 1 | ||
BG_REQUEST_SERVER | The URL of the ITG server. This field is used internally by ITG. | VarChar | 120 | ||
BG_REQUEST_TYPE | The ITG request type. This field is used internally by ITG. | VarChar | 120 | ||
BG_REQUEST_NOTE | The notes added to the linked request in ITG. | LongVarChar | 16 | ||
BG_CYCLE_ID | For backward compatibility. | Integer | 4 | ||
BG_TEST_REFERENCE | For backward compatibility. | Integer | 4 | ||
BG_CYCLE_REFERENCE | For backward compatibility. | VarChar | 255 | ||
BG_RUN_REFERENCE | For backward compatibility. | Integer | 4 | ||
BG_STEP_REFERENCE | For backward compatibility. | Integer | 4 | ||
BG_DETECTED_IN_REL | The RELEASES.REL_ID of the release in which the defect was detected. | Integer | 4 | ||
BG_DETECTED_IN_RCYC | The RELEASE_CYCLES.RCYC_ID of the release cycle in which the defect was detected. | Integer | 4 | ||
BG_TARGET_REL | The RELEASES.REL_ID of the release in which the defect is planned to be fixed. | Integer | 4 | ||
BG_TARGET_RCYC | The RELEASE_CYCLES.RCYC_ID of the release cycle in which the defect is planned to be fixed. | Integer | 4 |
Index | Primary | Unique |
---|---|---|
BG_PRIMARYKEY | ||
BG_COMPOUND_IDX | ||
BG_TO_MAIL_IDX |
Trigger | Description |
---|---|
AUTR66132_BUG |
Copyright 2002-2007 Mercury Interactive Corporation. |
|
Documentation comments or suggestions? Please send feedback to SW-Doc@hp.com |