History of checked in versions of the entity.
For descriptions of the table and columns, see the referenced entity table. For example, for details of HIST_TEST, see the TEST table.
Column Name | Description | Datatype | Length | Allow Nulls | Default | |
---|---|---|---|---|---|---|
![]() | RQ_VC_VERSION_NUMBER | The version ID of the entity. | int | 4 | ||
![]() | RQ_REQ_ID | int | 4 | |||
RQ_FATHER_ID | The ID of the parent entity. | int | 4 | ![]() | ||
RQ_ORDER_ID | int | 4 | ![]() | |||
RQ_ISTEMPLATE | int | 4 | ![]() | |||
RQ_REQ_COMMENT | varchar | 16 | ![]() | |||
RQ_REQ_REVIEWED | varchar | 255 | ![]() | |||
RQ_REQ_PATH | The highest level node has path AAA. Each child node down the tree inherits the parent path and adds three letters,where the current level numeration is concatenated to the inherited path. For example, the child requirements of the first node (AAA) have paths of AAAAAA, AAAAAB, AAAAAC, and so on. The characters V and W are not used. | varchar | 255 | |||
RQ_REQ_STATUS | varchar | 255 | ![]() | |||
RQ_REQ_PRIORITY | varchar | 255 | ![]() | |||
RQ_REQ_TYPE | varchar | 255 | ![]() | |||
RQ_REQ_PRODUCT | varchar | 255 | ![]() | |||
RQ_REQ_NAME | The name of the item. | varchar | 255 | ![]() | ||
RQ_REQ_AUTHOR | varchar | 255 | ![]() | |||
RQ_RBT_IGNORE_IN_ANALYSIS | varchar | 1 | ![]() | |||
RQ_RBT_BSNS_IMPACT | varchar | 1 | ![]() | |||
RQ_RBT_CUSTOM_BSNS_IMPACT | varchar | 1 | ![]() | |||
RQ_RBT_USE_CUSTOM_BSNS_IMPACT | varchar | 1 | ![]() | |||
RQ_RBT_EFFECTIVE_BSNS_IMPACT | varchar | 1 | ![]() | |||
RQ_RBT_FAIL_PROB | varchar | 1 | ![]() | |||
RQ_RBT_CUSTOM_FAIL_PROB | varchar | 1 | ![]() | |||
RQ_RBT_USE_CUSTOM_FAIL_PROB | varchar | 1 | ![]() | |||
RQ_RBT_EFFECTIVE_FAIL_PROB | varchar | 1 | ![]() | |||
RQ_RBT_RISK | varchar | 1 | ![]() | |||
RQ_RBT_CUSTOM_RISK | varchar | 1 | ![]() | |||
RQ_RBT_USE_CUSTOM_RISK | varchar | 1 | ![]() | |||
RQ_RBT_EFFECTIVE_RISK | varchar | 1 | ![]() | |||
RQ_RBT_FUNC_CMPLX | varchar | 1 | ![]() | |||
RQ_RBT_CUSTOM_FUNC_CMPLX | varchar | 1 | ![]() | |||
RQ_RBT_USE_CUSTOM_FUNC_CMPLX | varchar | 1 | ![]() | |||
RQ_RBT_EFFECTIVE_FUNC_CMPLX | varchar | 1 | ![]() | |||
RQ_RBT_TESTING_LEVEL | varchar | 70 | ![]() | |||
RQ_RBT_CUSTOM_TESTING_LEVEL | varchar | 70 | ![]() | |||
RQ_RBT_TESTING_HOURS | int | 4 | ![]() | |||
RQ_RBT_CUSTOM_TESTING_HOURS | int | 4 | ![]() | |||
RQ_RBT_USE_CUSTOM_TL_AND_TE | varchar | 1 | ![]() | |||
RQ_RBT_RND_ESTIM_EFFORT_HOURS | int | 4 | ![]() | |||
RQ_RBT_ASSESSMENT_DATA | varchar | 16 | ![]() | |||
RQ_RBT_ANALYSIS_PARENT_REQ_ID | int | 4 | ![]() | |||
RQ_RBT_ANALYSIS_SETUP_DATA | varchar | 16 | ![]() | |||
RQ_RBT_ANALYSIS_RESULT_DATA | varchar | 16 | ![]() | |||
RQ_RBT_LAST_ANALYSIS_DATE | datetime | 4 | ![]() | |||
RQ_USER_01 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_02 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_03 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_04 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_05 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_06 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_07 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_08 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_09 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_10 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_11 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_12 | User-defined field. | varchar | 40 | ![]() | ||
RQ_REQ_VER_STAMP | The version number of this record. | int | 4 | ![]() | ||
RQ_ATTACHMENT | A value of Y indicates that the item has at least one attachment. | varchar | 1 | ![]() | ||
RQ_REQ_DATE | datetime | 4 | ![]() | |||
RQ_REQ_TIME | varchar | 10 | ![]() | |||
RQ_NO_OF_SONS | int | 4 | ![]() | |||
RQ_IS_FOLDER | varchar | 1 | ![]() | |||
RQ_VTS | The version time stamp. | varchar | 20 | ![]() | ||
RQ_USER_13 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_14 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_15 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_16 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_17 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_18 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_19 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_20 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_21 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_22 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_23 | User-defined field. | varchar | 40 | ![]() | ||
RQ_USER_24 | User-defined field. | varchar | 40 | ![]() | ||
RQ_REQUEST_ID | int | 4 | ![]() | |||
RQ_TEXT_SYNC | For internal use. Do not change data. | varchar | 1 | ![]() | ||
RQ_REQUEST_SERVER | varchar | 120 | ![]() | |||
RQ_REQUEST_TYPE | varchar | 120 | ![]() | |||
RQ_REQUEST_STATUS | varchar | 40 | ![]() | |||
RQ_REQUEST_UPDATES | varchar | 120 | ![]() | |||
RQ_REQUEST_ASSIGN_TO | varchar | 120 | ![]() | |||
RQ_REQUEST_NOTE | varchar | 16 | ![]() | |||
RQ_TYPE_ID | int | 4 | ||||
RQ_TARGET_RCYC_VARCHAR | varchar | 255 | ![]() | |||
RQ_TARGET_REL_VARCHAR | varchar | 255 | ![]() | |||
RQ_TARGET_RCYC | int | 4 | ![]() | |||
RQ_TARGET_REL | int | 4 | ![]() | |||
RQ_DEV_COMMENTS | Comments.Comments | varchar | 16 | ![]() | ||
RQ_HAS_RICH_CONTENT | varchar | 1 | ![]() | |||
RQ_VC_STATUS | The version status: Checked in, checked out, or read only. | varchar | 20 | ![]() | ||
RQ_VC_CHECKIN_USER_NAME | The user name of the user who checked in this version. | varchar | 60 | ![]() | ||
RQ_VC_CHECKIN_DATE | The date this version was checked in according to the server clock. | datetime | 4 | ![]() | ||
RQ_VC_CHECKIN_TIME | The time this version was checked in according to the server clock. | varchar | 10 | ![]() | ||
RQ_VC_CHECKIN_COMMENTS | Comments.The user's comments when checking in the item. | varchar | 16 | ![]() | ||
RQ_VC_CHECKOUT_USER_NAME | The user who checked out the item under version control. | varchar | 60 | ![]() | ||
RQ_VC_CHECKOUT_DATE | The date the version was checked out according to the server clock. | datetime | 4 | ![]() | ||
RQ_VC_CHECKOUT_TIME | The time this version was checked out according to the server clock. | varchar | 10 | ![]() | ||
RQ_VC_CHECKOUT_COMMENTS | Comments.The user's comments when checking out the item. | varchar | 16 | ![]() | ||
RQ_REQ_RICH_CONTENT | varchar | 16 | ![]() |