A file or folder stored in the ALM repository that is represented by a resource.
Column Name | Description | Datatype | Length | Allow Nulls | Default | |
---|---|---|---|---|---|---|
![]() | RSC_ID | The record ID. | int | 4 | ||
RSC_NAME | The name of the resource. | varchar | 255 | |||
RSC_FILE_NAME | The file or folder name without the path. | varchar | 255 | ![]() | ||
RSC_LOCATION_TYPE | For future use. The value is always "Local". | varchar | 20 | |||
RSC_TYPE | One of the values of the Resource Type project list. The type determines the icon and viewer used for the resource in the Resources Tree and resource viewer tab. The generic type is Test Resource. | varchar | 255 | |||
RSC_DESCRIPTION | A free text description of this item. | varchar | 16 | ![]() | ||
RSC_PARENT_ID | The RESOURCE_FOLDERS.RFO_ID of the folder containing this item. | int | 4 | |||
RSC_VER_STAMP | The version number of this record. | int | 4 | |||
RSC_CREATED_BY | The user who created the resource. | varchar | 60 | |||
RSC_CREATION_DATE | The date on which the resource was created. | datetime | 4 | ![]() | ||
RSC_DEV_COMMENTS | Comments added for the resource. | varchar | 16 | ![]() | ||
RSC_USER_01 | User-defined field. | varchar | 40 | ![]() | ||
RSC_VC_VERSION_NUMBER | The version ID of the entity. | int | 4 | ![]() | ||
RSC_VC_STATUS | The version status: Checked in, checked out, or read only. | varchar | 20 | ![]() | ||
RSC_VC_CHECKIN_USER_NAME | The user name of the user who checked in this version. | varchar | 60 | ![]() | ||
RSC_VC_CHECKIN_DATE | The date this version was checked in according to the server clock. | datetime | 4 | ![]() | ||
RSC_VC_CHECKIN_TIME | The time this version was checked in according to the server clock. | varchar | 10 | ![]() | ||
RSC_VC_CHECKIN_COMMENTS | Comments.The user's comments when checking in the item. | varchar | 16 | ![]() | ||
RSC_VC_CHECKOUT_USER_NAME | The user who checked out the item under version control. | varchar | 60 | ![]() | ||
RSC_VC_CHECKOUT_DATE | The date the version was checked out according to the server clock. | datetime | 4 | ![]() | ||
RSC_VC_CHECKOUT_TIME | The time this version was checked out according to the server clock. | varchar | 10 | ![]() | ||
RSC_VC_CHECKOUT_COMMENTS | Comments.The user's comments when checking out the item. | varchar | 16 | ![]() | ||
RSC_VTS | The version time stamp. | varchar | 20 | ![]() | ||
RSC_BPTA_FLOW_TEST_ID | int | 4 | ![]() | |||
RSC_BPTA_TYPE | int | 4 | ![]() | |||
RSC_BPTA_CHANGE_DETECTED | int | 4 | ![]() | |||
RSC_BPTA_CHANGE_TIMESTAMP | varchar | 30 | ![]() | |||
RSC_BPTA_LAST_UPDATE_TIMESTAMP | varchar | 30 | ![]() | |||
RSC_BPTA_SOR_ID | int | 4 | ![]() | |||
RSC_BPTA_LOCATION_ID_IN_APP | varchar | 255 | ![]() |