Share this page
ALM Project Database Reference
td.RESOURCES Table
Description
A file or folder stored in the ALM repository that is represented by a resource.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | 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 who checked in this version of the item. If this item has not been checked in, the field is blank. | 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. If the item is not checked out, this field is blank. | 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 | A Flow is an abstract entity with no direct representation in the project database. It consists of both a Component and a Test of Test.Type BUSINESS-PROCESS. This field links a Component to a Test, thereby defining the Flow. The field contains the TEST.TS_TEST_ID of the test with which the component forms a Flow. | int | 4 | | |||
| RSC_BPTA_TYPE | NULL=not change detectable 1=SAP 2=ORACLE 1000=APPLICATION AREA | int | 4 | | |||
| RSC_BPTA_CHANGE_DETECTED | 1 - No change detected 2 - Change status is unknown 3 - Change detected | int | 4 | | |||
| RSC_BPTA_CHANGE_TIMESTAMP | The time the last change was detected. | varchar | 30 | | |||
| RSC_BPTA_LAST_UPDATE_TIMESTAMP | The time of the last update. | varchar | 30 | | |||
| RSC_BPTA_SOR_ID | The ID of the Shared Object Repository related to this application area. | int | 4 | | |||
| RSC_BPTA_LOCATION_ID_IN_APP | The ID of the screen which is the subject of this component. Used by Unified Functional Testing. | varchar | 255 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| RESOURCES_IDX1 | | ||
| RESOURCES_PK | | |
See Also
Related Objects
