|
Table: ACTNTGT
| Note | Contains a list of target users for automation rule actions. This table has a many-to-one relationship with the TRGACTN table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| ACTIONID | No | NUMERIC(10) | Yes | Link to a record ID in TRGACTN table |
| TARGET | No | NUMERIC(5) | No | Target for automation rule action; includes the following values:
0 (action not set)
1 (Entered by user)
2 (assigned users)
3 (Found by users)
4 (Modified by users)
5 (last user to enter event)
6 (user)
7 (security group)
8 (current user)
9 (unassigned) |
| TGTOPT | No | NUMERIC(10) | No | If target is a user, links to user ID in USERS table. If target is last user to enter an event, contains the event ID. If target is Found by or Modified by users, contains user; includes the following values:
0 (first user)
1 (last user)
2 (all users)
Otherwise, contains 0. |
Table: ATTACHINFO
| Note | Contains additional information on attachments to test cases and test runs. Each table row represents one file attached to the given record. This table has one-to-one relationship with ATTACHMT table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| ATTACHTYPE | No | NUMERIC(10) | Yes | Attachment type: 0 (Regular attachment), 1 (Script), 2 (Run Result) |
| ATTACHID | No | NUMERIC(10) | Yes | Record ID in ATTACHMT table |
| TYPE | No | NUMERIC(2) | Yes | Indicates Attachment table type (tableID_Attachments or tableID_SCCFiles) |
| OWNERTYPE | No | NUMERIC(10) | Yes | Entity Type to which attachment belongs to |
| OWNERID | No | NUMERIC(10) | Yes | Entity record ID to which attachment belongs to |
| SCRPTORDER | No | NUMERIC(10) | No | This field is valid only if attachment type is script. Indicates order script is displayed in scripts tab and executed. |
| SCRPTSTAT | No | VARCHAR(1020) | No | This field is valid only if attachment type is script. Indicates status of the script. |
Table: ATTACHMT
| Note | Contains file attachment information. Each table row represents one file attached to the given record. This table has a many-to-one relationship with the REPORTBY table. Each row has a reported by record ID that matches a record ID in the REPORTBY table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| ENTITYTYPE | No | NUMERIC(10) | No | The table attachment is linked to. (Defect, Defect event, Test case, Test case event, Test run, or Test run event) |
| ATTTYPE | No | NUMERIC(1) | No | File attachment type; includes the following values: 1 (Mac binary file), 2 (other file type) |
| ENTITYRID | No | NUMERIC(10) | No | Links to a REPORTBY table or DEFECTEVTS table record ID in case of Defects, otherwise links to Entity record ID. |
| FILENAME | No | VARCHAR(800) | No | Original file name, before it was attached to an entity. |
| MACTYPE | No | NUMERIC(10) | No | Mac type. Only valid for Mac. |
| MACCREATOR | No | NUMERIC(10) | No | Mac creator. Only valid for Mac. |
| DATECREATE | No | DATETIME | No | File creation date |
| DATEMODIFY | No | DATETIME | No | File modification date |
| FILESIZE | No | NUMERIC(10) | No | File size |
| ARCHVFILE | No | VARCHAR(96) | Yes | Attachment filename in the project's attachment archive, which may be the project's Attach directory or the ATTARCHIVE database table. |
| COMPRESSED | No | NUMERIC(1) | No | Reserved for future use |
| ATTACHINDB | No | NUMERIC(1) | No | Flag indicates if archive file contents are stored in database (valid for RDBMS only) |
| FIELDID | No | NUMERIC(10) | No | Contains field id of field containing image for WYSIWYG inline images. |
| IMGWIDTH | No | NUMERIC(5) | No | Width of original image added as inline WYSIWYG image. |
| IMGHEIGHT | No | NUMERIC(5) | No | Height of original image added as inline WYSIWYG image. |
| SUBTYPEID | No | NUMERIC(10) | No | SubType ID |
Table: ATTARCHIVE
| Note | Contains file attachment archive information. Each table row represents one file attachment. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| ARCHVFILE | No | VARCHAR(96) | No | Attachment filename in the project's attachment archive, which may be the project's Attach directory or the ATTARCHIVE database table. |
| FILEDATA | No | IMAGE | No | Binary attachment data |
Table: AUDITLOG
| Note | Contains the changes made to defect, test case or test run records. Each row records changes made to an entity and information regarding who, when, and how changes were made. Change information is stored in such a way that, if the user information is modified or deleted at a later date, the audit log table represents the information as it was when the changes were made. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| DATETIME | No | DATETIME | Yes | Date and time change was made; changed item identified by ENTITYTYPE and ENTITYID |
| LOGINNAME | No | VARCHAR(356) | Yes | User login name |
| FULLNAME | No | VARCHAR(260) | Yes | Full name (last, first) of user making the changes |
| ENTITYTYPE | No | NUMERIC(10) | Yes | Entity to which the changes are linked to, defects, test cases or test runs |
| ENTITYID | No | NUMERIC(10) | Yes | Link to the record ID in the table specified by ENTITYTYPE |
| AUTOREASON | No | VARCHAR(1020) | Yes | Description of how item was changed (e.g., renumbered, changed via bulk field changes) |
| ENTITYIDEN | No | VARCHAR(1020) | No | Description of changed item |
| MANREASON | No | VARCHAR(1020) | No | Reason, entered by user, describing why changes were made; identified by ENTITYTYPE and ENTITYID |
| MODSOURCE | No | VARCHAR(1020) | No | Description of source of changes (e.g, Web, SOAP, XML) |
| MODTYPE | No | VARCHAR(1020) | No | Description of how source changes were made (e.g. Edit Window, List window, bulk field changes) |
| CHANGES | No | TEXT | No | XML-formatted text documents changes |
| HASH | No | VARCHAR(1020) | No | An MD5 hash the DATETIME, LOGINNAME, FULLNAME, ENTITYTYPE, ENTITYID, ENTITYIDEN, MODSOURCE, MODTYPE, AUTOREASON, MANREASON, CHANGES, and SIGCAPTURED columns; verifies that data for this row has not been modified. |
| SIGCAPTURED | No | NUMERIC(1) | No | Indicates if electronic signatured is captured for this change. |
Table: AUTOMATIONBUILD
| Note | Contains automation builds. Each table row represents one automation build. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| SuiteID | No | NUMERIC(10) | No | Record ID of the parent automation suite |
| BuildDescription | No | NVARCHAR(max) | No | Description for the automation build |
| BuildNumber | No | NVARCHAR(max) | No | String representation of a build number |
| idTRSet | No | NUMERIC(10) | No | Record ID of a Test Run set |
| PropertiesJson | No | NVARCHAR(max) | No | Build properties in JSON format |
| RunConfigParamJson | No | NVARCHAR(max) | No | Build configuration parameters in JSON format |
| BuildState | No | NUMERIC(10) | No | State of the automation bulid:
0 (not_set)
1 (started)
2 (building)
3 (waitingOnResults))
4 (finished)
5 (unknown) |
| DateTimeStarted | No | DATETIME | No | Date/time the automation build was started |
| Duration | No | NUMERIC(10) | No | Duration of the automation build |
| Source | No | NVARCHAR(max) | No | Source of automation build |
| dateCreated | No | DATETIME | No | Date/time the automation build was created. |
| idCreateBy | No | NUMERIC(10) | No | User who created the automation buld. |
| dateModify | No | DATETIME | No | Date/time the automation build was last modified. |
| idModifyBy | No | NUMERIC(10) | No | User who last modified the automation build. |
| dateSubmitted | No | DATETIME | No | Date/time the automation build was submitted. |
| idSubmittedBy | No | NUMERIC(10) | No | User who submitted the automation buld. |
| PendingRunID | No | NVARCHAR(200) | No | Identifier that is used for automation builds started from Helix ALM that can be used to update the automation build when results are submitted. |
| AISUUID | No | NVARCHAR(200) | No | Identifier used by the Helix ALM Automation Service to uniquely identify a build. |
| Branch | No | NVARCHAR(max) | No | Branch for automation build. |
| TotalTests | No | NUMERIC(10) | No | Total number of test results submitted for the automation build. |
| PassedTests | No | NUMERIC(10) | No | Total number of test results submitted for the automation build with a passed status. |
| FailedTests | No | NUMERIC(10) | No | Total number of test results submitted for the automation build with a failed status. |
| SkippedTests | No | NUMERIC(10) | No | Total number of test results submitted for the automation build with a skipped status. |
| BlockedTests | No | NUMERIC(10) | No | Total number of test results submitted for the automation build with a blocked status. |
| UnknownTests | No | NUMERIC(10) | No | Total number of test results submitted for the automation build with an unknown status. |
| BuildURL | No | NVARCHAR(max) | No | URL to the automation build in external system. |
| ProcessingLog | No | NVARCHAR(max) | No | Log containing issues that happened when an automation build was submitted. |
| TestCaseSetID | No | NUMERIC(10) | No | Record ID of the automation test case set the automation build is using. |
| Locked | No | NUMERIC(1) | No | Boolean indicating that an automation build is locked. |
| Destroyed | No | VARCHAR(1) | No | Boolean indicating if this row is marked for destruction. |
Table: AUTOMATIONSUITE
| Note | Contains automation suite. Each table row represents one automation suite. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| Name | No | NVARCHAR(510) | Yes | The name of the automation suite |
| Description | No | NVARCHAR(max) | No | The description of the automation suite |
| dateCreated | No | DATETIME | No | Date the automation suite was created |
| idCreateBy | No | NUMERIC(10) | No | Record ID of the user that create the automation suite |
| dateModify | No | DATETIME | No | Date the automation suite was last modified |
| idModifyBy | No | NUMERIC(10) | No | Record ID of the the last user that modified the automation suite |
| Active | No | NUMERIC(1) | No | Boolean indicating if this automation suite is active |
| ScriptID | No | NVARCHAR(256) | No | The automation suite script ID prefix |
| TestCaseSetID | No | NUMERIC(10) | No | Record ID of the automation test case set the automation suite is using. |
Table: AUTOMATIONTESTRESULT
| Note | Contains automation test results. Each table row represents one automation test result. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC | Yes | Helix ALM project ID, identifies row’s parent project |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| BuildID | No | NUMERIC(10) | Yes | Record ID of the parent automation build |
| SuiteID | No | NUMERIC(10) | No | Record ID of the parent automation suite |
| Name | No | NVARCHAR(max) | No | Name of the automation test result. |
| UniqueName | No | NVARCHAR(max) | No | Unique name of the automation test result. All automation test results within a single build must have a unique name. This property can be used when performing manual associations. |
| Status | No | NUMERIC(10) | No | Status of the automation test result
0 (not_set)
1 (passed)
2 (failed)
3 (skipped)
4 (blocked)
5 (unknown) |
| Device | No | NVARCHAR(max) | No | Device the automated test result was tested on. |
| OS | No | NVARCHAR(max) | No | Operating system the automated test result was tested on. |
| OSVersion | No | NVARCHAR(max) | No | Operating system version the automated test result was tested on. |
| Manufacturer | No | NVARCHAR(max) | No | Manufacturer the automated test result was tested on. |
| Model | No | NVARCHAR(max) | No | Model the automated test result was tested on. |
| Browser | No | NVARCHAR(max) | No | Browser the automated test result was tested on. |
| BrowserVersion | No | NVARCHAR(max) | No | Browser version the automated test result was tested on. |
| DateTimeStarted | No | DATETIME | No | Date/time the automation test result was started |
| Duration | No | NUMERIC(10) | No | Duration of the automation test result |
| ExternalURL | No | NVARCHAR(max) | No | URL to the automation test result in external system. |
| PropertiesJson | No | NVARCHAR(max) | No | Automation test result properties in JSON format |
| ErrorMessage | No | NVARCHAR(max) | No | Error message information reported for the automation test result. |
| Destroyed | No | NUMERIC(1) | No | Boolean indicating if this row is marked for destruction. |
Table: AUTOTESTCONF
| Note | Contains information about automation configurations. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| AutoTestConfType | No | NUMERIC(10) | Yes | Type of automation configuration:
0 (not set)
1 (Jenkins) |
| Name | No | NVARCHAR(2048) | Yes | Name of the automation confirguration |
| Description | No | NVARCHAR(max) | No | Description of the automation configuration |
| ConfData | No | NVARCHAR(max) | No | Automation configuration data in JSON format |
Table: AUTO_RESULT_TC
| Note | Information about automation test results associated to test cases. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| TestCaseID | Yes | NUMERIC(10) | Yes | Record ID of a test case that may be associated with an automated test result. The test case will not appear as associated to the automation test result in Helix ALM if the value in the Associated column is 0. |
| ResultID | Yes | NUMERIC(10) | Yes | Record ID of an automated test result that may be associated with a test case. The automated test result will not appear as associated to the test case in Helix ALM if the value in the Associated column is 0. |
| BuildID | No | NUMERIC(10) | Yes | Record ID of the parent automation build |
| SuiteID | No | NUMERIC(10) | Yes | Record ID of the parent automation suite |
| Status | No | NUMERIC(10) | Yes | Status of the automation test result
0 (not_set)
1 (passed)
2 (failed)
3 (skipped)
4 (blocked)
5 (unknown) |
| Associated | No | NUMERIC(1) | Yes | Boolean indicating if the test case and automation test result are associated.
A value of 1 indicates the test case and automated test result are associated.
A value of 0 here indicates that when an automation build was submitted an automated test result had information to match the automation suites script prefix, but the test case matching that prefix information was not included in the automation suite. |
| Destroyed | No | NUMERIC(1) | Yes | Boolean indicating if this row is marked for destruction. |
Table: AUTO_SUITE_USER
| Note | Contains automation suite owners. Each table row represents one automation suite owner. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| SuiteID | Yes | NUMERIC(10) | Yes | Record ID of the parent automation suite |
| UserID | No | NUMERIC(10) | Yes | Record ID that represents a user |
Table: AUTO_TESTCASESET
| Note | Identifies a specific set of test cases referenced by an automation suite or build. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| IsShared | No | NUMERIC(1) | Yes | Indicates that the automation test case set is used by more than one object |
| Destroyed | No | NUMERIC(1) | No | Boolean indicating if this row is marked for destruction. |
Table: AUTO_TESTCASESET_TC
| Note | Information about specific test cases included in automation test case sets. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| TESTCASESETID | No | NUMERIC(10) | Yes | ID for a test case set a test case item is in. |
| TestCaseID | No | NUMERIC(10) | Yes | The ID of a test case included in an automation test case set. |
| UniqueName | No | NVARCHAR(max) | No | String representing the unique name of an automation test result. Used to match an automation test result with a test case. |
| Destroyed | No | NUMERIC(1) | No | Boolean indicating if this row is marked for destruction. |
Table: BASELINELOG
| Note | Contains baseline audit log information. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idUser | No | NUMERIC(10) | No | User who made the change. Links to a record ID in USERS table |
| dateLog | No | TIMESTAMP | No | Date/time the change occurred. |
| Notes | No | VARCHAR(4000) | No | Description of the change. |
| ParentID | No | NUMERIC(10) | No | Links to a record ID in the BASELINES table. |
| AuditID | No | NUMERIC(10) | No | ID of the associated audit log entry, if any. |
Table: BASELINES
| Note | Contains information about baselines. Additional information related to a baseline is available in the following tables: BASELINE_CREATE_ITEMS, BASELINE_CREATE_LINK, BASELINE_CREATE_FLTR, BASELINES_META, and BASELINELOG tables. Information about the items in the baseline can be found in the BASELINE_ISSUE, VERSION_ISSUE, VERSION_ISSUE_ATTACHMT, BASELINE_FLDR, VERSION_FLDR, VERSION_FLDR_ATTACHMT, BASELINE_DOC, VERSION_DOC, VERSION_DOC_ATTACHMT, BASELINE_REQ, VERSION_REQ, VERSION_REQ_ATTACHMT, BASELINE_TC, VERSION_TC, VERSION_TC_ATTACHMT, BASELINE_TR, VERSION_TR, VERSION_TR_ATTACHMT, and BASELINE_SUMMARY. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| MetaDataID | No | NUMERIC(10) | Yes | |
| dateCreate | No | TIMESTAMP | No | Date/time the baseline was created. |
| idCreateBy | No | NUMERIC(10) | No | User who created the baseline. |
| Name | No | VARCHAR(512) | Yes | Name of the baseline. |
| Description | No | VARCHAR(4000) | No | Description of the baseline. |
| dateModify | No | TIMESTAMP | No | Date/time the baseline was last modified. |
| idModifyBy | No | NUMERIC(10) | No | User who last modified the baseline. |
| AddedFrom | No | NUMERIC(5) | No | Method used to add baseline; includes the following values:
0 (unknown)
1 (Add Baseline window) |
| ItemCount | No | NUMERIC(10) | Yes | Number of items in the baseline. |
| Status | No | NUMERIC(1) | Yes | Status of the baseline; includes the following values:
0 (Baseline was created successfully)
1 (Baseline was not created successfully)
2 (Baseline is being created) |
| Destroyed | No | NUMERIC(1) | Yes | Boolean indicating if this row is marked for destruction. |
Table: BASELINES_META
| Note | Contains metadata for baselines. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| version | Yes | NUMERIC(10) | Yes | Part of the unique identifier for a table row. Specifies the version of baseline metadata. |
| versionBaseID | No | NUMERIC(10) | No | A non-null value that indicates if the data stored in versionDataJson is a JSON patch that needs to be applied to the row identified by this column. |
| versionDataJson | No | TEXT | Yes | JSON representation of metadata for the baseline. |
| SchemaVersion | No | NUMERIC(10) | Yes | Schema version of the data stored in versionDataJson. |
| hash | No | VARCHAR(1020) | Yes | md5 hash value for the fully-formed version JSON data. |
| Destroyed | No | NUMERIC(1) | Yes | Boolean that indicates if this version is marked to be destroyed. |
Table: BASELINE_CREATE_FLTR
| Note | Contains information about filters used when adding a baseline. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idBaseline | Yes | NUMERIC(10) | Yes | ID of the parent baseline. |
| EntityType | Yes | NUMERIC(10) | Yes | Item type for a filter selected when adding the baseline. |
| idFilter | No | NUMERIC(10) | No | Record ID of a filter used when adding a baseline. |
| FilterName | No | VARCHAR(252) | No | Filter name when the baseline was added. |
| FilterJson | No | TEXT | No | JSON representation of the filter when the baseline was added. |
Table: BASELINE_CREATE_ITEMS
| Note | Contains information about items selected when adding a baseline. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idBaseline | Yes | NUMERIC(10) | Yes | ID of the parent baseline. |
| idItem | Yes | NUMERIC(10) | Yes | Record ID of an item selected when adding the baseline. |
| EntityType | Yes | NUMERIC(10) | Yes | Item type that was selected when adding the baseline. |
Table: BASELINE_CREATE_LINK
| Note | Contains information about links used when adding a baseline. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idBaseline | Yes | NUMERIC(10) | Yes | ID of the parent baseline. |
| idItem | Yes | NUMERIC(10) | Yes | Record ID for a link definition used when adding the baseline. |
Table: BASELINE_DOC
| Note | Associates requirement document JSON version data with a baseline. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idBaseline | Yes | NUMERIC(10) | Yes | ID for a baseline a requirement document version is in. |
| idItem | Yes | NUMERIC(10) | Yes | Part of the identifier information for a requirement document version in a baseline. |
| idItemVersion | Yes | NUMERIC(10) | Yes | Part of the identifier information for a requirement document version in a baseline. |
Table: BASELINE_FLDR
| Note | Associates folder JSON version data with a baseline. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idBaseline | Yes | NUMERIC(10) | Yes | ID for a baseline a folder version is in. |
| idItem | Yes | NUMERIC(10) | Yes | Part of the identifier information for a folder version in a baseline. |
| idItemVersion | Yes | NUMERIC(10) | Yes | Part of the identifier information for a folder version in a baseline. |
Table: BASELINE_ISSUE
| Note | Associates issue JSON version data with a baseline. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idBaseline | Yes | NUMERIC(10) | Yes | ID for a baseline an issue version is in. |
| idItem | Yes | NUMERIC(10) | Yes | Part of the identifier information for an issue version in a baseline. |
| idItemVersion | Yes | NUMERIC(10) | Yes | Part of the identifier information for an issue version in a baseline. |
Table: BASELINE_REQ
| Note | Associates requirement JSON version data with a baseline. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idBaseline | Yes | NUMERIC(10) | Yes | ID for a baseline a requirement version is in. |
| idItem | Yes | NUMERIC(10) | Yes | Part of the identifier information for a requirement version in a baseline. |
| idItemVersion | Yes | NUMERIC(10) | Yes | Part of the identifier information for a requirement version in a baseline. |
Table: BASELINE_SUMMARY
| Note | Contains summary data about item versions in a baseline. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| EntityRID | Yes | NUMERIC(10) | Yes | Part of the identifier information for a item version in a baseline. |
| EntityType | Yes | NUMERIC(10) | Yes | Part of the identifier information for an item version in a baseline. |
| idItemVersion | Yes | NUMERIC(10) | Yes | Part of the identifier information for an item version in a baseline. |
| EntityNumber | No | NUMERIC(10) | No | Item number when the baseline was added. |
| TypeID | No | NUMERIC(10) | No | Item type when the baseline was added. For requirements, the value is the requirement type. For folders, the value is the folder type. |
| Summary | No | VARCHAR(1020) | No | Item summary when the baseline was added. |
| Status | No | VARCHAR(128) | No | Item status when the baseline was added. |
| StPrefix | No | VARCHAR(20) | No | Tag prefix for an item when a baseline was added. |
| StSuffix | No | VARCHAR(20) | No | Tag suffix for an item when a baseline was added. |
| StDateCreated | No | TIMESTAMP | No | Creation date for a requirement type when a baseline was added. |
| FolderPath | No | TEXT | No | Full folder path for a folder when a baseline was added. Only populated for folders. |
| hash | No | VARCHAR(1020) | Yes | md5 hash value for the fully=formed version JSON data for the item version the summary data represents. |
| Destroyed | No | NUMERIC(1) | No | Boolean that indicates if this row is marked for destruction. |
Table: BASELINE_TC
| Note | Associates test case JSON version data with a baseline. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idBaseline | Yes | NUMERIC(10) | Yes | ID for a baseline a test case version is in. |
| idItem | Yes | NUMERIC(10) | Yes | Part of the identifier information for a test case version in a baseline. |
| idItemVersion | Yes | NUMERIC(10) | Yes | Part of the identifier information for a test case version in a baseline. |
Table: BASELINE_TR
| Note | Associates test run JSON version data with a baseline. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idBaseline | Yes | NUMERIC(10) | Yes | ID for a baseline a test run version is in. |
| idItem | Yes | NUMERIC(10) | Yes | Part of the identifier information for a test run version in a baseline. |
| idItemVersion | Yes | NUMERIC(10) | Yes | Part of the identifier information for a test run version in a baseline. |
Table: CHARTS
| Note | Contains live chart report information. Each table row represents one live chart report. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| NAME | No | VARCHAR(128) | No | Name field. |
| TITLE | No | VARCHAR(4000) | No | Title field used on report output. |
| IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
| ACCESSSTAT | No | NUMERIC(2) | No | Report access state; values are: 1 (Shared) and 3 (Private) |
| ENTITYMASK | No | NUMERIC(10) | No | A bitmask of the entity types that the chart supports. |
| DFCTFLTRID | No | NUMERIC(10) | No | Issue filter the chart uses. |
| TSTCFLTRID | No | NUMERIC(10) | No | Test case filter the chart uses. |
| TSTRFLTRID | No | NUMERIC(10) | No | Test run filter the chart uses. |
| RQMTFLTRID | No | NUMERIC(10) | No | Requirement filter the chart uses. |
| RDMTFLTRID | No | NUMERIC(10) | No | Requirement document filter the chart uses. |
| XML | No | TEXT | No | XML text containing additional parameters. (Stored as XML to allow for future expansion). |
Table: CHARTSET
| Note | Contains live chart report attributes. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row's parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| CHARTID | No | NUMERIC(10) | No | Links to a record ID in CHARTS table. |
| USERID | No | NUMERIC(10) | No | Links to a record ID in USERS table. |
| FILTERID | No | NUMERIC(10) | No | Filter the chart uses. |
| ISINTFILT | No | NUMERIC(1) | No | Indicates if filter is interactive. |
| SHWENTTYPE | No | NUMERIC(10) | No | Indicates entity type of the chart settings. |
| ISRECUR | No | NUMERIC(1) | No | Indicates if folder recursive option is selected |
| FOLDRECID | No | NUMERIC(10) | No | Links to a record ID in FOLDER table. |
| FOLDOWNID | No | NUMERIC(10) | No | Indicates folder owner ID |
| ZORDER | No | NUMERIC(5) | No | Indicates Z order of the window. |
| WIDTH | No | NUMERIC(5) | No | Width of live chart window in pixels |
| HEIGHT | No | NUMERIC(5) | No | Height of live chart window in pixels |
| XPOS | No | NUMERIC(10) | No | X position of the live chart window in the MDI client area. |
| YPOS | No | NUMERIC(10) | No | Y position of the live chart window in the MDI client area. |
| ISMAX | No | NUMERIC(1) | No | Indicates if live chart window was maximized when client was closed. |
| SHWTITLE | No | NUMERIC(1) | No | Indicates if chart title should be visible. |
| SHWLGND | No | NUMERIC(1) | No | Indicates if chart legend should be visible. |
| SHWXAXIS | No | NUMERIC(1) | No | Indicates if chart X axis should be visible. |
| SHWYAXLT | No | NUMERIC(1) | No | Indicates if chart left Y axis should be visible. |
| SHWYAXRT | No | NUMERIC(1) | No | Indicates if chart right Y axis should be visible. |
| SHWXAXLBL | No | NUMERIC(1) | No | Indicates if chart X axis labels should be visible. |
| SHWYLTLBL | No | NUMERIC(1) | No | Indicates if chart left Y axis labels should be visible. |
| SHWYRTLBL | No | NUMERIC(1) | No | Indicates if chart right Y axis labels should be visible. |
| SHWDATLBL | No | NUMERIC(1) | No | Indicates if chart data labels should be visible. |
Table: CSDOCVAL
| Note | Contains information related to custom fields on a requirement document. Each table row represents one custom field value associated with a single document. This table has a many-to-one relationship with the DOCUMENT table and FLDDFNTN table. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in DOCUMENT table |
| IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
| CUSTVALUE | No | TEXT | No | If custom field is an edit box, this is the text the user enters; if custom field is a pop-up menu, comma separated record IDs will be set. |
| HASERROR | No | NUMERIC(1) | No | Indicates if there is a custom field calculation error. |
Table: CSRDEVTVL
| Note | Contains custom field values for requirement document events. Each table row represents one custom field value for a single event. This table has a many-to-one relationship with the DOCEVTS and the FLDDFNTN tables. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
| CUSTVALUE | No | TEXT | No | Custom field value (comma separated record IDs for drop-down list) |
| IDEVENT | No | NUMERIC(10) | No | Links to a record ID in DOCEVTS table |
Table: CSREQVAL
| Note | Contains information related to custom fields on a requirement. Each table row represents one custom field value associated with a single requirement. This table has a many-to-one relationship with the REQMNT table and FLDDFNTN table. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in REQMNT table |
| IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
| CUSTVALUE | No | TEXT | No | If custom field is an edit box, this is the text the user enters; if custom field is a pop-up menu, comma separated record IDs will be set. |
| HASERROR | No | NUMERIC(1) | No | Indicates if there is a custom field calculation error. |
Table: CSREVTVL
| Note | Contains custom field values for requirement events. Each table row represents one custom field value for a single event. This table has a many-to-one relationship with the REQEVTS and the FLDDFNTN tables. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
| CUSTVALUE | No | TEXT | No | Custom field value (comma separated record IDs for drop-down list) |
| IDEVENT | No | NUMERIC(10) | No | Links to a record ID in REQEVTS table |
Table: CSTDEVTVAL
| Note | Contains custom field values for defect events. Each table row represents one custom field value for a single event. This table has a many-to-one relationship with the DEFECTEVTS and the FLDDFNTN tables. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
| CUSTVALUE | No | TEXT | No | Custom field value (comma separated record IDs for drop-down list) |
| IDDEFEVT | No | NUMERIC(10) | No | Links to a record ID in DEFECTEVTS table |
Table: CSTTCEVTVAL
| Note | Contains custom field values for test case events. Each table row represents one custom field value for a single event. This table has a many-to-one relationship with the TCEVTS and the FLDDFNTN tables. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
| CUSTVALUE | No | TEXT | No | Custom field value (comma separated record IDs for drop-down list) |
| IDDEFEVT | No | NUMERIC(10) | No | Links to a record ID in TCEVTS table |
Table: CSTTREVTVAL
| Note | Contains custom field values for test run events. Each table row represents one custom field value for a single event. This table has a many-to-one relationship with the TREVTS and the FLDDFNTN tables. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
| CUSTVALUE | No | TEXT | No | Custom field value (comma separated record IDs for drop-down list) |
| IDDEFEVT | No | NUMERIC(10) | No | Links to a record ID in TREVTS table |
Table: CUSTMMAP
| Note | Contains field level mappings for creating-type-from-type. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| SRCFLDID | No | NUMERIC(10) | No | Field ID for the source field. |
| DSTNFLDID | No | NUMERIC(10) | No | Field ID for the destination field. |
| PREPNDTEXT | No | TEXT | No | Prepend text. |
| APPNDTEXT | No | TEXT | No | Append text. |
| ORDERNUM | No | NUMERIC(5) | No | Order number of mapping rule within mapping rule dialog. |
| PARENTACTIONID | No | NUMERIC(10) | Yes | Refers to the parent row in OBJCTGEN. |
Table: CUSTMVAL
| Note | Contains information related to custom fields on a defect. Each table row represents one custom field value associated with a single defect. This table has a many-to-one relationship with the DEFECTS table and the FLDDFNTN table. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in DEFECTS table |
| CUSTVALUE | No | TEXT | No | If custom field is an edit box, this is the text the user enters; if custom field is a pop-up menu, links to a record ID. |
| IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
| HASERROR | No | NUMERIC(1) | No | Indicates if there is a custom field calculation error. |
Table: CUSTTCVAL
| Note | Contains information related to custom fields on a test case. Each table row represents one custom field value associated with a single test case. This table has a many-to-one relationship with the TESTCASE table and FLDDFNTN table. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in TESTCASE table |
| CUSTVALUE | No | TEXT | No | If custom field is an edit box, this is the text the user enters; if custom field is a pop-up menu, comma separated record IDs will be set. |
| IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
| CVVRSTATE | No | NUMERIC(5) | No | Type of coverage variable:
0 (Unknown)
1 (Required)
2 (Excluded)
3 (Generated)
4 (Additional)
5 (All Coverage) |
| HASERROR | No | NUMERIC(1) | No | Indicates if there is a custom field calculation error. |
Table: CUSTTRVAL
| Note | Contains information related to custom fields on a test run. Each table row represents one custom field value associated with a single test run. This table has a many-to-one relationship with the TESTRUN table and FLDDFNTN table. If the custom field is a drop-down list, comma separated record IDs of inherent field tables or user/customer tables or FLDCUSTM tables will be set depending value list type. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in TESTRUN table |
| CUSTVALUE | No | TEXT | No | If custom field is an edit box, this is the text the user enters; if custom field is a pop-up menu, comma separated record IDs will be set. |
| IDCUSTREC | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table |
| CVVRSTATE | No | NUMERIC(5) | No | Type of coverage variable:
0 (Unknown)
1 (Required)
2 (Excluded)
3 (Generated)
4 (Additional)
5 (All Coverage) |
| HASERROR | No | NUMERIC(1) | No | Indicates if there is a custom field calculation error. |
Table: DASHBOARDLVCHARTWIDGET
| Note | Contains dashboard chart widget information. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| XML | No | TEXT | No | XML that contains all chart settings. |
Table: DASHBOARDSTATICWIDGET
| Note | Reserved for future use. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Reserved for future use. |
| CONTENT | No | TEXT | No | Reserved for future use. |
Table: DASHBOARDSTATUSWIDGET
| Note | Contains dashboard burn down or burn up widget information. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| RECURSIVE | No | NUMERIC(1) | Yes | Indicates if folder recursive option is selected. |
| OVERRIDEPLANNING | No | NUMERIC(1) | Yes | Indicates if widget uses own planning information instead of folder release planning information. |
| STARTDATE | No | DATETIME | No | Widget planning period start date. |
| ENDDATE | No | DATETIME | No | Widget planning period end date. |
| INCLUDEWEEKENDS | No | NUMERIC(1) | No | Indicates if planning information includes weekends. |
| BURNDOWN | No | NUMERIC(1) | Yes | Indicates if the widget type is burn down. 0 indicates the widget type is burn up. |
| FOLDERID | No | NUMERIC(10) | No | Folder that contains items to include in widget data. |
| DATATOCHART | No | NUMERIC(10) | No | Time tracking fields; includes the following values:
0 (Hours)
1 (Story Points for burn down widget or Story Points Done for burn up widget)
2 (Story Points Accepted for burn up widget) |
| UNITS | No | NUMERIC(10) | No | Units to display; includes the following values:
0 (Days)
1 (Weeks)
2 (Months) |
| ENABLEDTYPES | No | NUMERIC(10) | No | Bit flags that indicate item types included in the widget:
0x01 (Defects)
0x02 (Test Cases)
0x04 (Test Runs)
0x08 (Requirements)
0x10 (Requirement Documents) |
Table: DASHBOARDTILEWIDGET
| Note | Contains dashboard count widget information. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| FILTERENTITYTYPE | No | NUMERIC(10) | Yes | Item type included in the widget. |
| FILTERID | No | NUMERIC(10) | Yes | Filter the widget uses. |
| HASGRADIENT | No | NUMERIC(1) | Yes | Indicates if the widget uses a gradient. |
Table: DASHBOARDVIEW
| Note | Contains dashboard information. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| NAME | No | VARCHAR(256) | Yes | Dashboard name. |
| DESCRIPTION | No | VARCHAR(1020) | No | Dashboard description. |
| LAYOUT | No | NUMERIC(10) | Yes | Dashboard layout; includes the following values:
1 (One column)
2 (Two equal-sized columns)
3 (Two columns with a larger left column)
4 (Two columns with a larger right column)
5 (Three equal-sized columns) |
| HASHEADER | No | NUMERIC(1) | Yes | Indicates if the dashboard includes a header area above the columns. |
Table: DASHBOARDVIEWORDER
| Note | Contains the order to display dashboards in for a specified user. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| VIEWID | Yes | NUMERIC(10) | Yes | Dashboard ID. |
| USERID | Yes | NUMERIC(10) | Yes | Link to a record ID in USERS table. |
| ORDERNUM | No | NUMERIC(10) | Yes | Order number of the dashboard on the Dashboards window or page. |
| ISACTIVE | No | NUMERIC(1) | Yes | Indicates if the dashboard is the active dashboard when the Dashboards window or page opens. |
| ISVISIBLE | No | NUMERIC(1) | Yes | Indicates if the dashboard is shown in a tab on the Dashboards window or page. |
Table: DASHBOARDVIEWWIDGET
| Note | Contains information about the widgets included in a dashboard. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| WIDGETID | Yes | NUMERIC(10) | Yes | Widget ID. |
| VIEWID | Yes | NUMERIC(10) | Yes | Dashboard ID. |
| LOCATION | Yes | NUMERIC(10) | Yes | Dashboard column that includes the widget. 0 indicates the widget is in the dashboard header area. |
| ORDERNUM | Yes | NUMERIC(10) | Yes | Order number of the widget in the specified dashboard column. |
Table: DASHBOARDWIDGET
| Note | Contains basic information included in all dashboard widgets. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| TITLE | No | VARCHAR(512) | Yes | Widget name. |
| DESCRIPTION | No | VARCHAR(1020) | No | Widget description. |
| WIDGETTYPE | No | NUMERIC(10) | Yes | fromIdentifies the table to retrieve widget settings from; includes the following values:
1 (DASHBOARDCOUNTWIDGET)
4 (DASHBOARDLIVECHARTWIDGET)
5 or 6 (DASHBOARDSTATUSWIDGET) |
Table: DASHRECACT
| Note | Contains dashboard recent activity |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| DATELOG | No | DATETIME | Yes | Date/time the activity occurred. |
| CHANGETYPE | No | NUMERIC(10) | Yes | Activity type:
0 (Unknown)
1 (Item added)
2 (Item edited)
3 (Workflow event)
4 (Items merged) |
| USERID | No | NUMERIC(10) | No | User who performed the action. |
| ENTITYID | No | NUMERIC(10) | No | Item the activity was performed on. |
| ENTITYTYPE | No | NUMERIC(10) | No | Item type the activity was performed on. |
| EVTDEFID | No | NUMERIC(10) | No | Links to a record ID in EVENTS table. |
| EVTUSERID | No | NUMERIC(10) | No | User in the workflow event By field. |
| EVTDATE | No | DATETIME | No | Date in the workflow event Date field. |
| TIMESPENT | No | NUMERIC(20, 2) | No | Time in the workflow event Hours field. |
| RSLTSTATE | No | NUMERIC(10) | No | Resulting state for the workflow event. |
| ASGNDUSERS | No | VARCHAR(4000) | No | Users the item was assigned to. |
| EVTMARKSUSPECT | No | NUMERIC(1) | No | Indicates if the item was marked as suspect. |
| NOTES | No | TEXT | No | Workflow event notes. |
Table: DEFECTEVTS
| Note | Contains event information for each event recorded with a defect. Each table row represents a single defect event. This table has a many-to-one relationship with the DEFECTS table, the EVENTS table, the USERS table, and the STATES table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| EVTDEFID | No | NUMERIC(10) | No | Links to a record ID in EVENTS table |
| ORDERNUM | No | NUMERIC(5) | No | Identifies order the defect event was created relative to other defect events; an internal counter for a specific defect |
| PARENTID | No | NUMERIC(10) | Yes | Links to a record ID in DEFECTS table |
| EVTMUPARNT | No | NUMERIC(10) | No | Links to a record ID in DEFECTEVTS table; if event is a response to a multi-user assignment, field is the record ID of the parent event; if event is not a response to a multiuser assignment, field contains the value -1 |
| IDUSER | No | NUMERIC(10) | No | Links to a record ID in USERS table; if user created event, it has the record ID of the user; if event was generated by Helix ALM, it has a record ID of -2 |
| DATEEVENT | No | DATETIME | No | Defect event date |
| NOTES | No | TEXT | No | Notes field |
| TIMESPENT | No | NUMERIC(20, 2) | No | If event definition for this event (EVENT table) has the time reporting option selected, field stores the amount of time entered by the user; if event does not record time spent, this field has the value -1 |
| RSLTSTATE | No | NUMERIC(10) | No | Links to a record ID in STATES table; if event affects resulting defect state, field contains the record ID of resulting state; if event does not affect resulting state, a value of 0 is stored in field |
| RELVERSION | No | VARCHAR(1020) | No | Notes field if event is configured to include release notes information |
| ASGNDUSERS | No | VARCHAR(4000) | No | If event is an assignment event (EVENT table), field contains a list of record IDs linked to the USERS table; if event is not an assignment, field is empty |
| GENBYTYPE | No | NUMERIC(2) | No | Value that identifies how event was created; includes following values:
0 (created by user)
1 (created by multi-user assignment)
2 (created by auto assignment)
3 (created by auto escalation) |
| CREATORID | No | NUMERIC(10) | No | Stores record id of who created the event in the following cases:
- Escalation rule record id
- Trigger rule record id
- User record id of user that performed an action generating a system comment event |
| DEFASGEFF | No | NUMERIC(2) | No | Stores assignment of event at the time it was run (intended to preserve history if the event definition is
modified); includes the following values:
1 (event results in new assignment)
2 (event has no effect on assignment)
3 (event clears assignment) |
| OVRWF | No | NUMERIC(1) | No | Flag indicates if event is a result of a Workflow Override |
| OVRWFUSRID | No | NUMERIC(10) | No | Links to the USERS table; if event is a result of a Workflow Override, field stores the record ID of user; otherwise, the value 0 is written to field |
| SSPLNKITMS | No | NUMERIC(1) | No | Flag indicating if user specified to mark dependent items as suspect. |
Table: DEFECTS
| Note | Contains defect information. Each table row represents one defect. Additional information associated with a defect is found in the DEFECTEVTS table. This table has a one-to-one relationship with the STATES, FLDTYPE, FLDPROD, FLDDISPO, FLDPRIOR, FLDCOMP and FLDSEVER tables. This table has a many-to-many relationship with the USERS table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| DATECREATE | No | DATETIME | No | Date/time (in GMT) defect was added to the database |
| IDCREATEBY | No | NUMERIC(10) | No | User who added the defect, Links to a record ID in USERS table |
| DATEMODIFY | No | DATETIME | No | Date/time (in GMT) defect was last modified |
| IDMODIFYBY | No | NUMERIC(10) | No | User who last modified the defect, Links to a record ID in USERS table |
| DEFECTNUM | No | NUMERIC(10) | No | Defect number, value is zero if number not yet assigned |
| SUMMARY | No | VARCHAR(1020) | No | Summary field |
| STATUS | No | NUMERIC(10) | No | Defect state, links to a record ID in STATES table |
| INITSTATUS | No | NUMERIC(10) | No | Initial defect state |
| IDTYPE | No | NUMERIC(10) | No | Type field, links to a record ID in FLDTYPE table |
| IDPRODUCT | No | NUMERIC(10) | No | Product field, links to a record ID in FLDPROD table |
| REFERENCE | No | VARCHAR(1020) | No | Reference field |
| IDENTERBY | No | NUMERIC(10) | No | Entered by field, links to a record ID in USERS table |
| IDDISPOSIT | No | NUMERIC(10) | No | Disposition field, links to a record ID in FLDDISPO table |
| IDPRIORITY | No | NUMERIC(10) | No | Priority field, links to a record ID in FLDPRIOR table |
| IDCOMPON | No | NUMERIC(10) | No | Component field, links to a record ID in FLDCOMP table |
| IDSEVERITY | No | NUMERIC(10) | No | Severity field, links to a record ID in FLDSEVER table |
| DATEENTER | No | DATETIME | No | Date entered field (in GMT) |
| ADDLOCAT | No | NUMERIC(5) | No | Method used to add defect; includes the following values:
0 (unknown)
1 (Add defect window)
2 (SoloSubmit)
3 (SoloBug file)
4 (Email import)
5 (Text file import)
6 (Helix ALM user duplicated a defect) If a defect was created during a conversion from a TestTrack 1.8.x or Workgroup database, value is set to "unknown" |
| WORKAROUND | No | TEXT | No | Workaround field |
| IDTICKET | No | NUMERIC(10) | No | Reserved for future functionality |
| CURASGTO | No | TEXT | No | Stores names of users defect is currently assigned to for external reporting tools. |
Table: DEFLOG
| Note | Contains historical log information about changes made to defect records. Each row in this table represents a log entry in one of the defect records. Each row has a defect record ID that matches a record ID in the DEFECTS table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDUSER | No | NUMERIC(10) | No | User who made change, links to a record ID in USERS table |
| DATELOG | No | DATETIME | No | Date/time the change occurred |
| NOTES | No | VARCHAR(4000) | No | Description of the change |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in DEFECTS table |
| AUDITID | No | NUMERIC(10) | No | ID of the associated audit log entry, if any. |
Table: DISPNAME
| Note | Contains text strings used in the interface. This table contains the Rename Field Label values. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| DISPLAY | No | VARCHAR(1020) | No | Text string used in the user interface display |
Table: DOCCHNGS
| Note | Contains the original values for fields that were changed after a document snapshot was created. The document itself always stores the current value. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in DOCSNPST table |
| IDFIELD | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table indentifying the field. |
| HASVALUE | No | NUMERIC(1) | No | Flag indicating if OrigValue field represents original value. If false the original value was NULL. |
| ORIGVALUE | No | TEXT | No | Contains the original value for the field stored as the string value. |
Table: DOCEVTS
| Note | Contains event information for each event recorded with a document. Each table row represents a single document event. This table has a many-to-one relationship with the DOCUMENT table, the EVENTS table, the USERS table, and the STATES table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| EVTDEFID | No | NUMERIC(10) | No | Links to a record ID in EVENTS table |
| ORDERNUM | No | NUMERIC(5) | No | Identifies order the document event was created relative to other document events; an internal counter for a specific document. |
| PARENTID | No | NUMERIC(10) | Yes | Links to a record ID in DOCUMENT table |
| EVTMUPARNT | No | NUMERIC(10) | No | Links to a record ID in DOCEVTS table; if event is a response to a multi-user assignment, field is the record ID of the parent event; if event is not a response to a multiuser assignment, field contains the value -1 |
| IDUSER | No | NUMERIC(10) | No | Links to a record ID in USERS table; if user created event, it has the record ID of the user; if event was generated by Helix ALM, it has a record ID of -2 |
| DATEEVENT | No | DATETIME | No | Document event date |
| NOTES | No | TEXT | No | Notes field |
| TIMESPENT | No | NUMERIC(20, 2) | No | If event definition for this event (EVENT table) has the time reporting option selected, field stores the amount of time entered by the user; if event does not record time spent, this field has the value -1 |
| RSLTSTATE | No | NUMERIC(10) | No | Links to a record ID in STATES table; if event affects resulting document state, field contains the record ID of resulting state; if event does not affect resulting state, a value of 0 is stored in field |
| RELVERSION | No | VARCHAR(1020) | No | Notes field if event is configured to include release notes information |
| ASGNDUSERS | No | VARCHAR(4000) | No | If event is an assignment event (EVENT table), field contains a list of record IDs linked to the USERS table; if event is not an assignment, field is empty |
| GENBYTYPE | No | NUMERIC(2) | No | Value that identifies how event was created; includes following values:
0 (created by user)
1 (created by multi-user assignment)
2 (created by auto assignment)
3 (created by auto escalation) |
| CREATORID | No | NUMERIC(10) | No | Stores record id of who created the event in the following cases:
- Escalation rule record id
- Trigger rule record id
- User record id of user that performed an action generating a system comment event |
| DEFASGEFF | No | NUMERIC(2) | No | Stores assignment of event at the time it was run (intended to preserve history if the event definition is
modified); includes the following values:
1 (event results in new assignment)
2 (event has no effect on assignment)
3 (event clears assignment) |
| OVRWF | No | NUMERIC(1) | No | Flag indicates if event is a result of a Workflow Override |
| OVRWFUSRID | No | NUMERIC(10) | No | Links to the USERS table; if event is a result of a Workflow Override, field stores the record ID of user; otherwise, the value 0 is written to field |
| SSPLNKITMS | No | NUMERIC(1) | No | Flag indicating if user specified to mark dependent items as suspect. |
| VERSION | No | NUMERIC(10) | No | Contains the version number of the document that was current when the event was entered. |
Table: DOCEXPORTFAVORITES
| Note | Relates users to favorited Word export templates. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| TemplateID | Yes | NUMERIC(10) | Yes | Template record ID. |
| UserID | Yes | NUMERIC(10) | Yes | User record ID. |
Table: DOCEXPORTGRP
| Note | Relates security groups to Word export templates they can use. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| TemplateID | Yes | NUMERIC(10) | Yes | Template record ID. |
| UserGroupID | Yes | NUMERIC(10) | Yes | Security group record ID. |
Table: DOCEXPORTTEMPLATE
| Note | Contains Word export templates. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| TemplateName | No | NVARCHAR(128) | Yes | Template name. |
| TemplateDesc | No | NVARCHAR(1000) | No | Template description. |
| TemplateType | No | NUMERIC(10) | Yes | Template type; includes the following values:
0: Microsoft Word |
| IsDraft | No | NUMERIC(1) | No | Indicates if the template is marked as a draft. |
| DocTemplateName | No | NVARCHAR(512) | No | Template file name. |
| EntityMask | No | NUMERIC(10) | No | Item types at the top level of the template file; includes the following bit values:
0x01 = Issue
0x02 = Test case
0x04 = Test run
0x08 = Requirement
0x10 = Document
0x20 = Folder |
| ContainsString | No | NVARCHAR(512) | No | Item types the template file supports. |
| CreatedUserID | No | NUMERIC(10) | No | Record ID of user who created the template. |
| CreatedDate | No | DATETIME | No | Date/time the template was created. |
| LastModUserID | No | NUMERIC(10) | No | Record ID of the last user who uploaded a new version of the template file. |
| LastModDate | No | DATETIME | No | Date/time a new version of the template file was last uploaded. |
| OrigDocTemplate | No | VARBINARY(max) | No | Buffer that contains the original uploaded template file. |
| DocumentStructure | No | VARBINARY(max) | No | Buffer JSON representation of the XML data structure parsed from OrigDocTemplate. |
Table: DOCLOG
| Note | Contains historical log information about changes made to requirement document records. Each row in this table represents a log entry in one of the document records. Each row has a document record ID that matches a record ID in the DOCUMENT table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDUSER | No | NUMERIC(10) | No | User who made change, links to a record ID in USERS table |
| DATELOG | No | DATETIME | No | Date/time the change occurred |
| NOTES | No | VARCHAR(4000) | No | Description of the change |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in DOCUMENT table |
| AUDITID | No | NUMERIC(10) | No | ID of the associated audit log entry, if any. |
Table: DOCSNPST
| Note | Contains document snapshot information. Each table row represents one document snapshot. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| IDDOCUMENT | No | NUMERIC(10) | No | Links to a record ID in DOCUMENT table |
| DATECREATE | No | DATETIME | No | Date/time (in GMT) snapshot was added to the database |
| IDCREATEBY | No | NUMERIC(10) | No | User who added the snapshot. Links to a record ID in USERS table |
| VERSION | No | NUMERIC(10) | No | Snapshot version number |
| LABEL | No | VARCHAR(128) | No | Snapshot label |
| COMMNT | No | TEXT | No | Snapshot comment |
Table: DOCTESTCOVERAGE
| Note | Holds document test coverage data. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| DocumentID | No | NUMERIC(10) | Yes | Link to a record ID in DOCUMENT table. |
| TestRunFilterID | No | NUMERIC(10) | No | RecordID of a test run filter. |
| Enabled | No | NUMERIC(1) | No | Boolean indicating if document test coverage is enabled for the specified document. |
Table: DOCTREE
| Note | Contains the requirement relationship tree for the current version of the document. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDDOCUMENT | Yes | NUMERIC(10) | Yes | Links to a record ID in DOCUMENT table |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in DOCTREE table; Field contains the record ID of the parent node in the tree. If the node is at the top level ParnetID contains 0. |
| IDREQMNT | No | NUMERIC(10) | No | Links to a record ID in REQMNT table |
| SIBORDER | No | NUMERIC(10) | No | Contains the order of this node in relation to its siblings in the parent node. |
| ISSUSPECT | No | NUMERIC(1) | No | Flag indicating if the node is marked as suspect. |
Table: DOCUMENT
| Note | Contains requirement document information. Each table row represents one requirement document. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| DATECREATE | No | DATETIME | No | Date/time (in GMT) document was added to the database |
| IDCREATEBY | No | NUMERIC(10) | No | User who added the document. Links to a record ID in USERS table |
| DATEMODIFY | No | DATETIME | No | Date/time (in GMT) document was last modified |
| IDMODIFYBY | No | NUMERIC(10) | No | User who last modified the document. Links to a record ID in USERS table |
| DOCNUM | No | NUMERIC(10) | No | Document number, value is zero if number not yet assigned |
| NAME | No | VARCHAR(1020) | No | Document name. |
| IDSTATUS | No | NUMERIC(10) | No | Current document state, links to a record ID in STATES table |
| ADDLOCAT | No | NUMERIC(5) | No | Method used to add requirement document, includes the following values:
0 (unknown)
1 (Add requirement document window)
4 (Email import)
5 (Text file import)
6 (Helix ALM user duplicated a requirement document)
13 (Microsoft Word import) |
| VERSION | No | NUMERIC(10) | No | Current document version number. |
| DESCRPTN | No | TEXT | No | Document description |
| PGWIDTH | No | NUMERIC(10, 3) | No | Current page width for multi-line text fields in specification window. |
| LEFTMARGIN | No | NUMERIC(10, 3) | No | Current left margin indent in specification window. |
| UNITTYPE | No | NUMERIC(2) | No | Units that the page width and left margin are specified in.
0 - Pixels
1 - Inches
2 - Centimeters |
| CURASGTO | No | TEXT | No | Stores names of users document is currently assigned to for external reporting tools. |
| INITSTATUS | No | NUMERIC(10) | No | Initial document state. |
Table: DRAFTFIELD
| Note | Contains draft version/inactive custom fields. Each table row represents one draft custom field. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ENTITYTYPE | No | NUMERIC(10) | Yes | Table this field is linked to. |
| SOURCEFIELD | No | NUMERIC(10) | Yes | Links to a record ID FLDDFNTN table. |
| XML | No | TEXT | No | Draft field data. |
Table: EMAIL
| Note | Contains tracked email information. Each table row represents one email. This table has a one-to-one relationship with the EMAILASSOC table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ISORPHAN | No | NUMERIC(1) | No | Flag indicates if email is associated with an entity |
| SUBJECT | No | VARCHAR(1020) | No | Email subject |
| BODY | No | TEXT | No | Email message body |
| DATESENT | No | DATETIME | No | Date/time email was sent |
| DATERECD | No | DATETIME | No | Date/time email was received |
| THDMSGID | No | VARCHAR(1020) | No | Email message ID in thread |
| DIRECTION | No | NUMERIC(5) | No | Indicates if email was sent or received; includes the following values:
0 (outgoing)
1 (incoming) |
| ISHTML | No | NUMERIC(1) | No | Indicates if the email is in HTML format |
Table: EMAILASSOC
| Note | Contains information about records tracked emails are associated with. Each table row represents an email association with one entity. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ENTITYTYPE | No | NUMERIC(10) | No | Entity type the email is associated with |
| ENTITYRID | No | NUMERIC(10) | No | Link to a record ID in corresponding entity table |
| EMAILID | No | NUMERIC(10) | No | Link to a record ID in EMAIL table |
| PARENTID | No | NUMERIC(10) | No | Parent email ID |
Table: EMAILRECP
| Note | Contains email recipient information. This table has a many-to-one relationship with the EMAIL table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| EMAILID | No | NUMERIC(10) | No | Link to a record ID in EMAIL table |
| TYPE | No | NUMERIC(1) | No | Recipient type; includes the following values:
1 (From)
2 (To)
3 (Cc)
4 (Bcc) |
| USERID | No | NUMERIC(10) | No | Link to a record ID in USERS table |
| ADDRESS | No | VARCHAR(252) | No | Recipient email address |
Table: EMAILTMP
| Note | Contains email template information. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| EMAILDESC | No | VARCHAR(1020) | No | Description of when email template is used |
| SUBJECT | No | VARCHAR(1020) | No | Email template subject field |
| TEMPLATE | No | TEXT | No | Email template message body |
| NAME | No | VARCHAR(128) | No | Email template name |
| MULTIPLE | No | NUMERIC(1) | No | Flag indicates if multiple recipients can be specified; if set to N, multiple emails with a single recipient will be sent |
| MAILGROUPS | No | VARCHAR(4000) | No | Specifies which security groups can be sent the message, links to the USERGRP table |
| HTML | No | NUMERIC(1) | No | Flag indicates if the email is sent in HTML format |
| ALLOWALL | No | NUMERIC(1) | No | Flag indicates that all groups can receive this email |
| ENTITYTYPE | No | NUMERIC(10) | No | Entity type the template is associated to |
Table: EVENTS
| Note | Contains event definition information. Each table row represents one event definition. This table has a many-to-one relationship with the FLDDFNTN table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| ENTITYTYPE | No | NUMERIC(10) | No | Entity type to which event is linked to |
| NAME | No | VARCHAR(128) | No | Event name |
| EVENTDESC | No | VARCHAR(1020) | No | Event description |
| ACTIVE | No | NUMERIC(1) | No | Flat indicates if the event is active in the workflow |
| EVENTORDER | No | NUMERIC(10) | No | Identifies order events are displayed on workflow configuration screens |
| INFORM | No | NUMERIC(1) | No | Flag indicates if event is informational only or affects current state of the entity |
| ALLOWATTCH | No | NUMERIC(1) | No | Flag indicates if files can be attached to the event |
| TIMETRK | No | NUMERIC(1) | No | Flag indicates if time tracking is enabled for the event |
| TIMETRKOPT | No | NUMERIC(2) | No | Value indicates how time tracking operates; includes the following values:
1 (display sum of event hours)
2 (display last event hours) |
| ASSIGNEFF | No | NUMERIC(2) | No | Stores assignment value of event; includes the following values:
1 (event results in new assignment)
2 (event has no effect on assignment)
3 (event clears assignment) |
| RSLTSTATES | No | VARCHAR(4000) | No | Specifies valid states for event, links to STATES table |
| QKLINKICON | No | VARCHAR(1020) | No | Specifies file name used as a graphic on the Helix ALM Web list window for creating this type of event |
| EVENTICON | No | IMAGE | No | Binary data for the toolbar icon displayed on the Helix ALM Windows client |
| INCEVTICON | No | NUMERIC(1) | No | Flag indicates if icon be displayed on the Windows toolbar |
| EVTICONNM | No | VARCHAR(1020) | No | Name of file used for event icon |
| EVTINCREL | No | NUMERIC(1) | No | Flag indicates if event notes should be included with release notes |
| ALLOWMUAS | No | NUMERIC(1) | No | Flag indicates if multiple user assignment is allowed |
| REQESIGS | No | NUMERIC(1) | No | Flag indicates electronic signature is required to complete this event |
| HIDEDLG | No | NUMERIC(1) | No | Flag indicates to hide dialog if there are no fields to be shown. Currently it is implemented only for test runs. |
| EVVSRWMOD | No | NUMERIC(1) | No | Flag indicates if event notes should be included with the requirement document review mode; applies to requirements only. |
| DNLNKSUSP | No | NUMERIC(1) | No | Flag indicates if the event should include the "Mark dependent items as suspect" option. |
Table: EXTERNPROVIDER
| Note | Contains information that enables integration with external source control providers, such as Git |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| PROVIDERTYPE | No | NUMERIC(10) | No | Defines the provider type:
1 - SCM Provider |
| PROVSUBTYPE | No | NUMERIC(10) | Yes | Defines the provider type sub type:
0 - Other
1 - Surround SCM
2 - Git
3 - GitHub |
| APIKEY | No | VARCHAR(256) | No | Contains the provider key which uniquely identifies the provider when it connects to the project |
| NAME | No | VARCHAR(1024) | Yes | Contains the provider name. This field is required and must be unique. |
| ACTIVE | No | NUMERIC(1) | Yes | Indicates if the provider is active. |
| SERVERADDR | No | VARCHAR(2048) | No | Surround SCM Server Path |
| SERVERPORT | No | NUMERIC(10) | No | Surround SCM Server port |
| COMMITURL | No | VARCHAR(4000) | No | Commit viewer URL path string. |
| FILEURL | No | VARCHAR(4000) | No | File viewer URL path string. |
| REPOURL | No | VARCHAR(4000) | No | GitHub repository URL path string. |
| PROVIDERCGIURL | No | VARCHAR(4000) | No | The URL of the external provider CGI. |
Table: EXTERN_ITEM_ASSOC_ITEM
| Note | Contains external item associations, such as for JIRA issues. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ProviderID | No | NUMERIC(10) | Yes | Record ID that identifies the external association provider row for the external item. |
| ItemID | No | NUMERIC(10) | Yes | Record ID that identifies the Helix ALM item associated with the external item. |
| ItemType | No | NUMERIC(10) | Yes | Helix ALM item type associated with the external item. |
| CreatedDate | No | DATETIME | No | Date/time the association was created. |
| ProviderData | No | VARBINARY(max) | No | External data from the provider that identifies the specific external item. |
Table: EXTERN_ITEM_ASSOC_PROV
| Note | Contains external item association providers, such as JIRA. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| Location | No | NVARCHAR(512) | Yes | URL or other location for the provider. |
| Enabled | No | NUMERIC(10) | Yes | Indicates if the provider is enabled in Helix ALM. |
| ProviderData | No | VARBINARY(max) | No | JSON identification data given from the provider to Helix ALM. |
| ConfigData | No | VARBINARY(max) | No | JSON data representing the provider configuration in the Helix ALM project. |
Table: FIELDCALC
| Note | Contains calculated custom field details. Each table row represents one calculated custom field. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| IDFIELDDEF | No | NUMERIC(10) | Yes | Links to a record ID in FLDDFNTN table. |
| IDFIELD1 | No | NUMERIC(10) | No | For time span calculated fields, this will store the Field ID of the first time field. |
| IDFIELD2 | No | NUMERIC(10) | No | For time span calculated fields, this will store the Field ID of the second time field |
| UNIT | No | NUMERIC(2) | No | For time span calculated fields, this will store the unit to use for the difference |
| ROUNDING | No | NUMERIC(2) | No | For time span calculated fields, this will store the rounding behavior |
| FIELDCALCTYPE | No | NUMERIC(2) | No | Field calculation type. (kCalcType_NotSet = 0, kCalculationWithFormula, kCalculatedPopup, kCalculatedTimespan, kMappedField) |
| INCLWEEKENDS | No | NUMERIC(1) | No | Flag to indicate if weekend is included in calculation. |
| LASTERRORDATE | No | DATETIME | No | This will store the last time that this field had an error (on any item). |
| LASTLOGDATE | No | DATETIME | No | This will store the last time that an error message was logged for this field. |
| FORMULA | No | TEXT | No | This will store the formula for the calculated field. |
Table: FIELDGROUP
| Note | Holds field group information. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| LayoutID | No | NUMERIC(10) | Yes | Link to a record ID in FIELDLAYOUT table. |
| Name | No | NVARCHAR(128) | Yes | Name of the field group. |
| Description | No | NVARCHAR(1024) | No | Description of the field group. |
| OrderNum | No | NUMERIC(10) | Yes | Indicates the priority order of the field group within a field layout. |
Table: FIELDGROUPFIELDS
| Note | Holds field information for field groups. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| LayoutID | Yes | NUMERIC(10) | Yes | Link to a record ID in FIELDLAYOUT table. |
| GroupID | No | NUMERIC(10) | Yes | Link to a record ID in FIELDGROUP table. |
| FieldID | Yes | NUMERIC(10) | Yes | RecordID of field in field group. |
| OrderNum | No | NUMERIC(10) | Yes | Indicates the priority order of the field within a field group. |
Table: FIELDLAYOUT
| Note | Contains data about field layouts. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| EntityType | No | NUMERIC(10) | Yes | Table ID for item type. |
| SubtypeID | No | NUMERIC(10) | No | Links to idRecord in SUBTYPE table. |
| Name | No | NVARCHAR(256) | Yes | Name of the field layout. |
| Description | No | NVARCHAR(2048) | No | Description of the field layout. |
| OrderNum | No | NUMERIC(10) | Yes | Indicates the priority order of the field layout. |
| IsDefault | No | NUMERIC(1) | Yes | Indicates if the field layout is the default layout for the specified entity type. |
Table: FIELDLAYOUTUSERGROUPS
| Note | Holds data associating user groups to field layouts. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | No | NUMERIC(10) | No | Helix ALM project ID, identifies row’s parent project. |
| LayoutID | No | VARCHAR(40) | No | ID for field layout to associate with security group. |
| GroupID | No | VARCHAR(40) | No | ID for security group specified by field layout. |
Table: FIELDREL
| Note | Contains the definition of field relationships setup for this database. Each table row represents one field relationship. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ENTITYTYPE | No | NUMERIC(10) | No | Parent entity type the relationship is linked to. |
| CHILDTYPE | No | NUMERIC(10) | No | Child entity type the relationship is linked to. |
| IDPARENT | No | NUMERIC(10) | Yes | Identifies parent field in the field relationship. |
| IDCHILD | No | NUMERIC(10) | Yes | Identifies child field in the field relationship. |
| RULES | No | TEXT | No | List of record IDs for parent and child fields that describe the relationship of the field items. |
Table: FIELDSTYLES
| Note | Contains field value style settings. May be associated with multiple fields. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| NAME | No | VARCHAR(1020) | Yes | Style name in style list. |
| ORDERNUM | No | NUMERIC(10) | Yes | Order of style in style list. |
| BOLD | No | NUMERIC(1) | Yes | Indicates if the style is bold. |
| ITALIC | No | NUMERIC(1) | Yes | Indicates if the style is italics. |
| UNDERLINE | No | NUMERIC(1) | Yes | Indicates if the style is underlined. |
| STRIKEOUT | No | NUMERIC(1) | Yes | Indicates if the style is strikeout. |
| COLOR | No | VARCHAR(24) | Yes | Style text color in 6 hex digits. |
| BACKGROUNDCOLOR | No | VARCHAR(24) | Yes | Style background color in 6 hex digits. |
| HIDETEXT | No | NUMERIC(1) | Yes | Indicates if text is hidden when the style is applied. |
| ICON | No | IMAGE | No | Binary data containing the icon image file. |
Table: FIELDSTYLESASSOC
| Note | Associates a field and popup value with a style. The field style mapping associates a field style with a workflow state or a pop-up menu item. If the parent type is 1, the parent ID column is interpreted as a workflow state and the child columns are interpreted as states that use the style. If parent type is 2, the parent ID represents the record ID of the pop-up menu. The child IDs represent the pop-up menu items that use the style. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| PARENTTYPE | No | NUMERIC(10) | Yes | How to interpret the data in the ParentID and ChildID columns. Valid values are Workflow or PopupItem. |
| PARENTID | No | NUMERIC(10) | Yes | If ParentType is Workflow, this is the entity type of the workflow (e.g. tableID_Defects, tableID_TestCases, etc.). If ParentType is PopupItem, this is the record ID of the pop-up list this entry is for. |
| CHILDID | No | NUMERIC(10) | Yes | If ParentType is Workflow, this is the workflow state record ID. If ParentType is PopupItem, this is the pop-up item record ID. |
| FIELDSTYLEID | No | NUMERIC(10) | Yes | Record ID for field style to apply to the associated item. |
Table: FILTDISP
| Note | Contains restriction items in a filter. Each table row represents one displayed line in a filter. This table has a many-to-one relationship with the FILTER table. Each row has a filter record ID that matches a record ID in the FILTER table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| FILTERID | No | NUMERIC(10) | No | Filter record ID. |
| FILTORDER | No | NUMERIC(3) | No | Restriction item order, relative to other items. |
| BNOT | No | NUMERIC(1) | No | Indicates if Not flag is set. |
| OPENPAREN | No | NUMERIC(2) | No | Number of open parentheses that appear before
restriction item. |
| CLOSEPAREN | No | NUMERIC(2) | No | Number of close parentheses that appear after restriction
item. |
| FILTERTYPE | No | NUMERIC(2) | No | Operator applied to the next restriction item; includes the following values:
0 (none)
2 (AND operator)
3 (OR operator) |
| RESTRICTN | No | TEXT | No | Filter restriction information; field can use information from a filter restriction definition and code them into a string value stored in this field |
| PROMPT | No | NUMERIC(1) | No | Indicates if filter is interactive and should prompt user for values when used. |
Table: FILTER
| Note | Contains filter information. Each table row represents one filter for the given entity type. Additional information associated with a filter is found in the FILTDISP table, which has a many-to-one relationship to this table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FILTERTYPE | No | NUMERIC(10) | Yes | Filter entity type |
| NAME | No | VARCHAR(252) | Yes | Name field |
| FILTERDESC | No | VARCHAR(1020) | No | Description field |
| IDOWNER | No | NUMERIC(10) | No | Filter owner, links to a record ID in USERS table. |
| ACCESSSTAT | No | NUMERIC(1) | Yes | Filter shared with access state; includes the following values:
0 (No one)
1 (Everyone)
2 (All Users)
3 (All Customers)
4 (Selected Groups)
5 (Published)
6 (Selected Users) |
Table: FLDCOMP
| Note | Contains the components pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FIELDORDER | No | NUMERIC(10) | No | Pop-up item order, relative to other items. |
| DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for this pop-up menu item. |
Table: FLDCUSTM
| Note | Contains the custom field pop-up menu values. Each row in this table represents one pop-up menu item. This table has a many-to-one relationship with the FLDPULIST table. Each row in this table has a Pop-up list record ID that matches a record ID in the FLDPULIST table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDPULIST | No | NUMERIC(10) | Yes | Links to a record ID in FLDPULIST table. |
| FIELDORDER | No | NUMERIC(10) | No | Item order, relative to other items. |
| DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDDFNTN
| Note | Contains definitions for fields of all entity type and event fields. Each table row represents a single field. Custom pop-up fields, for both entity and entity events, have many-to-one relationship with the FLDPULIST table that links to pop-up menu items in FLDCUSTM table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ENTITYTYPE | No | NUMERIC(10) | No | Table this field is linked to. |
| FIELDID | No | NUMERIC(10) | No | Field ID that uniquely identifies a field in an entity type. |
| POSITION | No | NUMERIC(5) | No | For custom fields, order field displays on the custom field tab; for inherent fields, value is -1. |
| FIELDCODE | No | VARCHAR(1020) | No | Character string used as a replacement field code for email templates. |
| FIELDTYPE | No | NUMERIC(5) | No | Stores value that describes field type; includes the following values:
1 (pop-up menu)
2 (string)
3 (Boolean)
4 (date)
5 (version field)
6 (Component)
7 (Disposition) |
| FIELDOPTS | No | NUMERIC(10) | No | Stores value that describes data allowed for this field; includes the following values:
0 (no option specified)
1 (integer values)
2 (floating point values)
3 (include time - only for date fields)
5 (memo field)
6 (Hyperlink) |
| FLDFLGOPTS | No | NUMERIC(10) | No | Stores field flag options; includes the following values:
0 (no option specified)
1 (Include Global users or customers)
2 (Include Local users or customers)
4 (Multi-select field) |
| ATTFLAG | No | NUMERIC(10) | No | Bit flag indicates which text import/export options are available; the following options can be combined with an OR operator:
0x0001 (field can be imported via text import)
0x0002 (field can be exported via text export)
0x0004 (field defaults to checked on text export dialog)
0x0008 (field defaults to checked on text import dialog) |
| SHORTNAME | No | VARCHAR(1020) | No | Field name as displayed with entity or event dialog. |
| LONGNAME | No | VARCHAR(1020) | No | Field name as displayed in list windows, filters, and reports. |
| MAXSIZE | No | NUMERIC(10) | No | Maximum field length, only applies to custom fields for entity and entity events; all other fields have value of -1. |
| NUMROWS | No | NUMERIC(10) | No | Number of rows for multi-line text fields; minimum value is 2, maximum is 10. |
| ACTIVE | No | NUMERIC(1) | No | Flag indicates if the field is being used. |
| EDTREQDFLT | No | NUMERIC(1) | No | Flag indicates if required fields and default values can be modified. |
| DEFAULTVAL | No | NUMERIC(10) | No | Default value for this field; stored values are based on field type; for string fields, the only value allowed is -4 (blank record ID); for pop-up menus, the allowed values are: 0 (not set record ID) and any valid record ID in corresponding table; for user fields, allowed values are: -2 (current user), 0 (not set record ID); for date fields, allowed values are: 0 (not set record ID), 1 (current date). |
| ALLOWDEFLT | No | NUMERIC(1) | No | Flag indicates if the default can be set. |
| ENTITYRID | No | NUMERIC(10) | No | Links to record ID of event definition (EVENTS) if definition is for an event field; for entity fields, value is 0. |
| REQUIRED | No | NUMERIC(1) | No | Flag indicates if the field is required. |
| IDPULIST | No | NUMERIC(10) | No | This is applicable only for pop-up menu items; indicates TableID for inherent fields, Record ID in FLDPULIST for custom pop-up menu items; All other fields have value of 0. |
| DEFAULTSTR | No | TEXT | No | Reserved for future use. |
| dateCreated | No | TIMESTAMP | No | Date the field was created. |
Table: FLDDISPO
| Note | Contains the disposition pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FIELDORDER | No | NUMERIC(10) | No | Pop-up item order, relative to other items. |
| DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDPRIOR
| Note | Contains the priority pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
| DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDPROD
| Note | Contains the product pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
| DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDPULIST
| Note | Contains pop-up list names. FLDDFNTN table maps to FLDPULIST record ID for each pop-up menu item. List of actual values for each PU List is stored in FLDCUSTM table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| LISTNAME | No | VARCHAR(128) | No | Pop-up list name. |
Table: FLDRDTL
| Note | Contains the additional folder details for the folder table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| FLDRTYPID | No | NUMERIC(10) | No | Foreign key to folder type table. |
| FLDRDTLS | No | TEXT | No | Folder WYSIWYG text entered for the folder. |
| ALLWEDTDTL | No | NUMERIC(1) | No | Flag indicating if users can edit the folder details field from the list window. |
| WEBURL | No | TEXT | No | Folder web URL. |
| STARTDATE | No | DATETIME | No | Folder release planning start date. |
| ENDDATE | No | DATETIME | No | Folder release planning end date. |
| INCLWKENDS | No | NUMERIC(1) | No | Folder release planning include weekends flag. |
| NONWKDYS | No | NUMERIC(10) | No | Folder release planning non working days. |
| WORKHRS | No | NUMERIC(20, 2) | No | Folder release planning work hours. |
| AVAILUSRS | No | NUMERIC(20, 2) | No | Folder release planning available users. |
| PTOHRS | No | NUMERIC(20, 2) | No | Folder release planning vacation and holiday hours. |
| STORYPTS | No | NUMERIC(10) | No | Folder release planning target stroy points. |
Table: FLDREPRO
| Note | Contains the reproduced pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
| DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDRITEM
| Note | Contains folder item information. Each table row represents one folder item. This table has a many-toone relationship with the FOLDER table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| FOLDERID | No | NUMERIC(10) | No | Link to a record ID in the FOLDER table. |
| ENTITYTYPE | No | NUMERIC(10) | No | Entity type the item is related to. |
| ENTITYID | No | NUMERIC(10) | No | Link to a record ID in the DEFECT, TESTCASE, or TESTRUN table. |
| ITEMRANK | No | NUMERIC(10) | No | |
Table: FLDRLOG
| Note | Contains historical log information about changes to folders. Each row in this table represents a log entry for a folder. Each row has a folder record ID that matches a record ID in the FOLDER table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDUSER | No | NUMERIC(10) | No | User who made change, links to a record ID in USERS table. |
| DATELOG | No | DATETIME | No | Date/time the change occurred. |
| NOTES | No | VARCHAR(4000) | No | Description of the change. |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in the FOLDER table. |
| AUDITID | No | NUMERIC(10) | No | ID of the associated audit log entry, if any. |
Table: FLDRPRIO
| Note | Contains requirement importance pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
| DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDRTYP
| Note | Contains folder type information. Each table row represents one type value. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| NAME | No | VARCHAR(128) | No | Folder type name. |
| DESCRPTN | No | VARCHAR(1020) | No | Folder type description. |
| OPENICON | No | IMAGE | No | Open folder icon image. |
| OPNICONNM | No | VARCHAR(1020) | No | Filename of the image file that was selected for the open folder icon image. |
| CLOSEDICON | No | IMAGE | No | Closed folder icon image. |
| CLSICONNM | No | VARCHAR(1020) | No | Filename of the image file that was selected for the closed folder icon image. |
| ISACTIVE | No | NUMERIC(1) | No | Flag indicating if folder type is active. |
| ALLOWURL | No | NUMERIC(1) | No | Flag indicating if folder type should support URLs. |
| ALLWWYGTXT | No | NUMERIC(1) | No | Flag indicating if folder type should support WYSIWYG text. |
| ALLWTMTRK | No | NUMERIC(1) | No | Flag indicating if folder type should support release planning |
| ORDERNUM | No | NUMERIC(10) | No | Order number of the folder type within the list. |
| BANNERCLR | No | VARCHAR(24) | No | Banner color for the folder type |
| DEFAULTTASKBOARD | No | NUMERIC(10) | No | The default Task Board to use for this folder type. |
| ENABLETASKBOARD | No | NUMERIC(1) | No | Boolean indicating if task boards are enabled for the folder type. |
Table: FLDSEVER
| Note | Contains the severity pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
| DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDTOTP
| Note | Contains test object type pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
| DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDTRSET
| Note | Contains test run set pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
| DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDTYPE
| Note | Contains the type pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
| DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item. |
Table: FLDVERSN
| Note | Contains the version pop-up menu values. Each row in this table represents one pop-up menu item. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FIELDORDER | No | NUMERIC(10) | No | Popup item order, relative to other items. |
| DESCRIPTOR | No | VARCHAR(1020) | No | Text displayed for pop-up menu item |
Table: FOLDER
| Note | Contains folder information. Each table row represents one folder. Folder item information is in the FLDRITEM table. This table has a one-to-many relationship with the FLDRITEM table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| OWNERID | No | NUMERIC(10) | No | Links to a record ID in USERS table. |
| PARENTID | No | NUMERIC(10) | No | Record ID of the parent folder. |
| FLDRORDER | No | NUMERIC(5) | No | Folder order, relative to other folders. |
| NAME | No | VARCHAR(128) | No | Folder name. |
| DESCRPTN | No | VARCHAR(1020) | No | Folder description. |
| DATECREATE | No | DATETIME | No | Date/time folder was created. |
| IDCREATEBY | No | NUMERIC(10) | No | User who created the folder, links to a record ID in USERS table |
| DATEMODIFY | No | DATETIME | No | Date/time folder was last modified. |
| IDMODIFYBY | No | NUMERIC(10) | No | User who last modified the folder, links to a record ID in USERS table |
| ADDEDFROM | No | NUMERIC(5) | No | How folder was added; includes the following values:
0 (location unknown)
1 (add window)
2 (SoloSubmit page)
3 (SoloBug import)
4 (email import)
5 (text import)
6 (duplicated)
7 (XML import)
8 (SOAP API)
9 (help desk - obsolete)
10 (QA Wizard Pro)
11 (generated test run)
12 (Helix ALM Outlook add-in) |
| MULTIDESC | No | TEXT | No | Notes associated with the folder (WYSIWYG field). |
| URL | No | TEXT | No | URL associated with the folder |
| TASKBOARDID | No | NUMERIC(10) | No | Record ID of the task board used when viewing the folder. |
| ISLOCKED | No | NUMERIC(1) | Yes | Indicates if the folder is locked. |
| DEFAULTPERMISSION | No | NUMERIC(10) | Yes | Default permission for all users who do have a specific folder override; includes the following values:
0 (No permissions)
1 (All folder permissions)
2 (Add, remove, and rank items in folder)
3 (Add items to folder)
4 (No folder permissions) |
Table: FOLDER_PERM_GROUPS
| Note | Contains information about folder permissions. Each row contains a permission set for a specific group on a specific folder. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| GroupID | Yes | NUMERIC(10) | Yes | ID for the security group with folder permissions set. |
| FolderID | Yes | NUMERIC(10) | Yes | ID for the folder with permissions set. |
| Permission | No | NUMERIC(10) | Yes | Folder permissions set for a specific user; includes the following values:
0 (No permissions set)
1 (All folder permissions)
2 (Add, remove, and rank items in folder)
3 (Add items to folder)
4 (No folder permissions) |
Table: FOLDER_PERM_USERS
| Note | Contains information about folder permissions. Each row contains a permission set for a specific user on a specific folder. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| UserID | Yes | NUMERIC(10) | Yes | ID for a user with folder permissions set. |
| FolderID | Yes | NUMERIC(10) | Yes | ID for a folder with permissions set. |
| Permission | No | NUMERIC(10) | Yes | Folder permissions set for a specific user; includes the following values:
0 (No permissions set)
1 (All folder permissions)
2 (Add, remove, and rank items in folder)
3 (Add items to folder)
4 (No folder permissions) |
Table: GROUPSDEFAULTVIEW
| Note | Table linking views to the groups they are a default for. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | No | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ViewID | No | NUMERIC(10) | Yes | ID of the default view. |
| GroupID | No | NUMERIC(10) | Yes | The ID of a group the view is a default for. |
Table: INPUTMAP
| Note | Contains input mapping rule for a formula based calculated custom field. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDFIELDCALC | No | NUMERIC(10) | Yes | Links to a record ID in FIELDCALC table. |
| IDFIELDDEF | No | NUMERIC(10) | Yes | Links to a record ID in FLDDFNTN table. |
| IDPUVALUE | No | NUMERIC(10) | Yes | Popup list ID value. |
| VALUE | No | VARCHAR(1020) | No | Input map value. |
Table: LIMIT_FIELD_USERS
| Note | Contains user and field associations. Each table row represents associations between a user field and a user that is allowed to be displayed. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FldID | Yes | NUMERIC(10) | Yes | ID for a user type field that is limiting the displayed users. |
| UserID | Yes | NUMERIC(10) | Yes | ID for a user that is allowed to be displayed as selectable for a user type field. |
Table: LIMIT_FLD_GROUPS
| Note | Contains user group and field associations. Each table row represents associations between a user field and a security group with users that are allowed to be displayed. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FldID | Yes | NUMERIC(10) | Yes | ID of a user type field that is limiting the displayed users. |
| GroupID | Yes | NUMERIC(10) | Yes | ID for a security group that is allowed to have the users in it displayed as selectable for a user type field. |
Table: LINKDFNTN
| Note | Contains a list of user-defined link definitions. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| LINKORDER | No | NUMERIC(10) | No | Order of row in list of link definitions. |
| LINKNAME | No | VARCHAR(128) | No | Unique name for link definition. |
| LINKCOMMNT | No | VARCHAR(1020) | No | Comment associated with link definition. |
| LINKPARENT | No | NUMERIC(1) | No | Flag indicates if link definition requires a parent. |
| LINKACTIVE | No | NUMERIC(1) | No | Flag indicates if link definition is active. |
| LINKENTS | No | VARCHAR(255) | No | Indicates allowed entities for this link. |
| COMNTREQD | No | NUMERIC(1) | No | Flag indicating if link comment is required when creating a new link using this definition. |
| ALLWDPRNTS | No | VARCHAR(255) | No | List of table ids allowed to be parent in link using this definition. |
| ALLWDCHLD | No | VARCHAR(255) | No | List of table ids allowed to be children or peers in link using this definition. |
| MAXITEMS | No | NUMERIC(10) | No | Number of items allowed to be linked together using this definition. |
| ALLWSUSPCT | No | NUMERIC(1) | No | Flag indicating if children or peers in link using this definition should be marked as suspect when suspect event is added to parent. |
Table: LINKHISTRY
| Note | Contains history of changes made to links. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| LINKID | No | NUMERIC(10) | Yes | Links to parent record in LINKS table. |
| HISTORDER | No | NUMERIC(10) | No | Order that events appear in link’s history. |
| HISTDATE | No | DATETIME | No | Date link was changed. |
| FIRSTNAME | No | VARCHAR(128) | No | First name of user who made change. |
| LASTNAME | No | VARCHAR(128) | No | Last name of user who made change. |
| HISTINFO | No | VARCHAR(1020) | No | Detailed description of change. |
Table: LINKITEM
| Note | Contains the information for a single item within a link in the LINK table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| LINKID | No | NUMERIC(10) | Yes | Links to parent record in LINKS table. |
| ITEMORDER | No | NUMERIC(10) | No | Item order in peer/child list; value of 0 indicates parent item in link. |
| ENTITYTYPE | No | NUMERIC(10) | No | Table that the linked item is associated with. |
| ENTITYID | No | NUMERIC(10) | No | Record ID of defect item is linked to. |
| ITEMSTATUS | No | NUMERIC(5) | No | Reserved for future use. |
| SUSPSTAT | No | NUMERIC(10) | No | Indicates suspect status of linked items.
0 (Not suspect)
1 (Suspect status caused by workflow)
2 (Suspect status was set manually) |
| SUSPBY | No | NUMERIC(10) | No | RecordID of user who made link suspect. |
| SUSPDATE | No | DATETIME | No | Date & time when link was made suspect. |
| SUSPNOTES | No | VARCHAR(1020) | No | Notes entered by user when link was made suspect. |
| SRCTYPE | No | NUMERIC(10) | No | Table ID of the item in the link that made this link suspect. |
| SRCID | No | NUMERIC(10) | No | Record ID of the item in the link that made this link suspect. |
| DATEADDED | No | DATETIME | No | Indicates date/time item was added to the link. |
Table: LINKS
| Note | Contains a list of items added to a link. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| LINKDEFID | No | NUMERIC(10) | Yes | Link to LINKDFNTN table. Identifies the link type. |
| LINKSTATUS | No | NUMERIC(5) | No | Reserved for future use. |
| LINKCOMMNT | No | VARCHAR(1020) | No | Comment entered by user when link was created. |
Table: LINKWRKFLW
| Note | Contains the options that describe the workflow behaviors for items in the LINKDFNTN table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies parent project for row. |
| LINKDEFID | Yes | NUMERIC(10) | Yes | Link to LINKDFNTN table. Identifies the link type. |
| LINKRLTN | No | NUMERIC(5) | No | Enumerated relationship type of this behavior:
1 - Parent
2 - Child
3 - Peer |
| LINKOPTION | No | NUMERIC(5) | No | Enumerated option for the workflow behavior:
1 - Prevent parent from closing if children are open
2 - Prevent child from re-opening if parent is closed
3 - Prevent child from closing if parent is open
4 - Prevent parent from re-opening if children are closed
5 - Close peers in order
6 - Re-open peers in reverse order |
Table: LISTWND
| Note | Contains list window information. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| USERID | No | NUMERIC(10) | No | Link to a record ID in USERS table. |
| ENTITYTYPE | No | NUMERIC(10) | No | Entity type of the list window. |
| WIDTH | No | NUMERIC(5) | No | List window width in pixels. |
| HEIGHT | No | NUMERIC(5) | No | List window height in pixels. |
| XPOS | No | NUMERIC(10) | No | X position of the list window in the MDI client area. |
| YPOS | No | NUMERIC(10) | No | Y position of the list window in the MDI client area. |
| ISOPEN | No | NUMERIC(1) | No | Indicates if window was open when client was closed. |
| ZORDER | No | NUMERIC(5) | No | Z order of the window. |
| CLIENTW | No | NUMERIC(5) | No | Width of the MDI client area the window was displayed in (for applying width correction). |
| CLIENTH | No | NUMERIC(5) | No | Height of the MDI client area the window was displayed in (for applying height correction). |
Table: LISTWNDTAB
| Note | Contains list window tab information. Each table row represents one tab. This table has a many-to-one relationship with the LISTWND table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| LISTWNDID | No | NUMERIC(10) | No | Link to a record ID in LISTWND table. |
| NAME | No | VARCHAR(512) | No | Tab name. |
| PRISORT | No | NUMERIC(10) | No | Primary sort field ID. |
| SECSORT | No | NUMERIC(10) | No | Secondary sort field ID. |
| PRISRTORDR | No | NUMERIC(1) | No | Primary sort column order. |
| SECSRTORDR | No | NUMERIC(1) | No | Secondary sort column order. |
| FILTERID | No | NUMERIC(10) | No | Filter the list window uses. |
| TABORDER | No | NUMERIC(5) | No | Tab order, relative to other tabs. |
| ACTIVE | No | NUMERIC(1) | No | Indicates if the tab is selected. |
Table: OBJCTGEN
| Note | Contains create-type-from-type mappings. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| SRCENTITYTYPE | No | NUMERIC(10) | No | The source entity type of the object generation action. |
| SRCSUBTYPEID | No | NUMERIC(10) | No | The source subtype of the object generation action. |
| DSTENTITYTYPE | No | NUMERIC(10) | No | The destination entity type of the object generation action. |
| DSTSUBTYPEID | No | NUMERIC(10) | No | The destination subtype of the object generation action. |
| ADDTOFOLDER | No | NUMERIC(1) | No | True if generated items should be added to the same folders as the source item. |
| COPYFIELDDATA | No | NUMERIC(1) | No | True if additional field information should be copied, e.g. "Copy description fields from all issue reported by records to the requirement description" |
| LINKDEFID | No | NUMERIC(10) | No | The ID of the link definition to use. |
| PROMPTTOLINK | No | NUMERIC(1) | No | True if the user is prompted to add the link. |
| PARENTINLINK | No | NUMERIC(10) | No | An enumeration indicating which item is made the parent in the link if the link is a parent/child link. Source(0), destination(1), special(2). |
| ACTTYPE | No | NUMERIC(10) | No | An enumeration indicating what type of object generation this is, Create(0), Generate(1), or Insert Shared Steps(2). |
| ADDTODOCUMENT | No | NUMERIC(1) | No | True if the newly created requirement should be added to a document. |
Table: OUTPUTMAP
| Note | Contains ouput mapping for a calculated pop-up custom field. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDFIELDCALC | No | NUMERIC(10) | Yes | Links to a record ID in FIELDCALC table. |
| MAPCOND | No | NUMERIC(10) | Yes | An enumerated value corresponding to "Greater Than", "Equal To", etc. (kCondition_Invalid, kCondition_Greater, kCondition_GreaterOrEqual, kCondition_Less, kCondition_LessOrEqual, kCondition_Equal, kCondition_NotEqual, kCondition_DefaultValue) |
| MAPPING | No | NUMERIC(10) | Yes | The output value |
| MAPORDER | No | NUMERIC(10) | Yes | Order of this mapping rule in the list of output mappings |
| MAPVALUE | No | VARCHAR(80) | No | Numeric portion of the condition |
Table: OWNERLCK
| Note | Contains Helix ALM internal information. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| DBVERSION | No | VARCHAR(40) | No | Database version number, specifies database table format. |
Table: PARENTCHILDASSOC
| Note | Associates a parent record with a child record. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ASSOCTYPE | No | NUMERIC(10) | Yes | How data in the ParentID and ChildID columns is interpreted. Can only be 1 initially.
1 - Indicates PARENTID in SCCFILE.idRecord and a CHILDID in USERS.idRecord, which associates a source control file record with multiple AuthorIDs (Helix ALM user IDs).
2 - Indicates PARENTID in TASKBOARD.idRecord and a CHILDID in SUBTYPES.idRecord.
3 - Indicates PARENTID in TASKBOARDCOLUMN.idRecord and a CHILDID in STATES.idRecord. |
| PARENTID | No | NUMERIC(10) | Yes | RecordID of an SCCFILE if AssocType is 1. |
| CHILDID | No | NUMERIC(10) | Yes | AuthorID (Helix ALM user ID) for the SCCFILE parent if AssocType is 1. |
Table: RDBMSOPTNS
| Note | Contains the options and settings used when connecting to this RDBMS database. Works like a Windows INI file and each entry has a name/value pair. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| OPTDESC | No | VARCHAR(128) | No | Option name. |
| OPTVALUE | No | VARCHAR(1020) | No | Option value. |
Table: REPORTBY
| Note | Contains defect reported by information. Each table row represents one report of a defect. This table has a many-to-one relationship with the DEFECTS table because Helix ALM allows multiple reports of a single defect. Each row in this table has a defect record ID that matches a record ID in the DEFECTS table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDFOUNDBY | No | NUMERIC(10) | No | Found by field, links to a record ID in USERS table. |
| DATEFOUND | No | DATETIME | No | Found by date field. |
| ORDERNUM | No | NUMERIC(5) | No | Identifies reported by record order, relative to other reported by records; internal counter for a specific defect. |
| VERSNFOUND | No | VARCHAR(128) | No | Version found in field. This field stores the text of the item if selected from the FLDVERSN table. |
| DESCRPTN | No | TEXT | No | Description field. |
| IDREPROD | No | NUMERIC(10) | No | Reproduced field, links to a record ID in FLDREPRO table. |
| REPROSTEPS | No | TEXT | No | Steps to reproduce field. |
| TSTCONTYPE | No | NUMERIC(5) | No | Computer configuration field type; includes the following values:
1 (User’s Test Configuration)
2 (Standard Test Configuration) |
| IDCONFIG | No | NUMERIC(10) | No | Standard computer configuration field, links to a record ID in SYSCONF table |
| OTHERHWSW | No | TEXT | No | Other hardware and software field. |
| CONTACT | No | VARCHAR(252) | No | User contact information, either phone number or email address. |
| IDDEFREC | No | NUMERIC(10) | No | Links to a record ID in DEFECTS table. |
Table: REQCHNGS
| Note | Contains the original values for fields that were changed after a requirement version was created. The requirement itself always stores the current value. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in REQVRSN table |
| IDFIELD | No | NUMERIC(10) | No | Links to a record ID in FLDDFNTN table indentifying the field. |
| HASVALUE | No | NUMERIC(1) | No | Flag indicating if OrigValue field represents original value. If false the original value was NULL. |
| ORIGVALUE | No | TEXT | No | Contains the original value for the field stored as the string value. |
Table: REQEVTS
| Note | Contains event information for each event recorded with a requirement. Each table row represents a single requirement event. This table has a many-to-one relationship with the REQMNT table, the EVENTS table, the USERS table, and the STATES table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| EVTDEFID | No | NUMERIC(10) | No | Links to a record ID in EVENTS table |
| ORDERNUM | No | NUMERIC(5) | No | Identifies order the requirement event was created relative to other requirement events; an internal counter for a specific requirement. |
| PARENTID | No | NUMERIC(10) | Yes | Links to a record ID in REQMNT table |
| EVTMUPARNT | No | NUMERIC(10) | No | Links to a record ID in REQEVTS table; if event is a response to a multi-user assignment, field is the record ID of the parent event; if event is not a response to a multiuser assignment, field contains the value -1 |
| IDUSER | No | NUMERIC(10) | No | Links to a record ID in USERS table; if user created event, it has the record ID of the user; if event was generated by Helix ALM, it has a record ID of -2 |
| DATEEVENT | No | DATETIME | No | Requirement event date |
| NOTES | No | TEXT | No | Notes field |
| TIMESPENT | No | NUMERIC(20, 2) | No | If event definition for this event (EVENT table) has the time reporting option selected, field stores the amount of time entered by the user; if event does not record time spent, this field has the value -1 |
| RSLTSTATE | No | NUMERIC(10) | No | Links to a record ID in STATES table; if event affects resulting defect state, field contains the record ID of
resulting state; if event does not affect resulting state, a value of 0 is stored in field |
| RELVERSION | No | VARCHAR(1020) | No | Notes field if event is configured to include release notes information |
| ASGNDUSERS | No | VARCHAR(4000) | No | If event is an assignment event (EVENT table), field contains a list of record IDs linked to the USERS table; if
event is not an assignment, field is empty |
| GENBYTYPE | No | NUMERIC(2) | No | Value that identifies how event was created; includes following values:
0 (created by user)
1 (created by multi-user assignment)
2 (created by auto assignment)
3 (created by auto escalation) |
| CREATORID | No | NUMERIC(10) | No | Stores record id of who created the event in the following cases:
- Escalation rule record id
- Trigger rule record id
- User record id of user that performed an action generating a system comment event |
| DEFASGEFF | No | NUMERIC(2) | No | Stores assignment of event at the time it was run (intended to preserve history if the event definition is
modified); includes the following values:
1 (event results in new assignment)
2 (event has no effect on assignment)
3 (event clears assignment) |
| OVRWF | No | NUMERIC(1) | No | Flag indicates if event is a result of a Workflow Override |
| OVRWFUSRID | No | NUMERIC(10) | No | Links to the USERS table; if event is a result of a Workflow Override, field stores the record ID of user; otherwise, the value 0 is written to field |
| SSPLNKITMS | No | NUMERIC(1) | No | Flag indicating if user specified to mark dependent items as suspect. |
| VERSION | No | NUMERIC(10) | No | Contains the version number of the requirement that was current when the event was entered. |
Table: REQLOG
| Note | Contains historical log information about changes made to requirement records. Each row in this table represents a log entry in one of the requirement records. Each row has a requirement record ID that matches a record ID in the REQMNT table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDUSER | No | NUMERIC(10) | No | User who made change, links to a record ID in USERS table |
| DATELOG | No | DATETIME | No | Date/time the change occurred |
| NOTES | No | VARCHAR(4000) | No | Description of the change |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in REQMNT table |
| AUDITID | No | NUMERIC(10) | No | ID of the associated audit log entry, if any. |
Table: REQMNT
| Note | Contains requirement information. Each table row represents either one requirement. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| DATECREATE | No | DATETIME | No | Date/time (in GMT) requirement was added to the database |
| IDCREATEBY | No | NUMERIC(10) | No | User who added the requirement. Links to a record ID in USERS table |
| DATEMODIFY | No | DATETIME | No | Date/time (in GMT) requirement was last modified |
| IDMODIFYBY | No | NUMERIC(10) | No | User who last modified the requirement. Links to a record ID in USERS table |
| DATEENTER | No | DATETIME | No | Date entered field (in GMT) |
| IDENTERBY | No | NUMERIC(10) | No | Entered by field, links to a record ID in USERS table |
| REQNUM | No | NUMERIC(10) | No | Requirement number, value is zero if number not yet assigned |
| TAG | No | VARCHAR(88) | No | Contains the requirement tag number. |
| SUMMARY | No | VARCHAR(1020) | No | Summary field |
| IDSTATUS | No | NUMERIC(10) | No | Current requirement state, links to a record ID in STATES table |
| IDTYPE | No | NUMERIC(10) | No | Requirement type, links to a record ID in SUBTYPE table |
| ADDLOCAT | No | NUMERIC(5) | No | Method used to add requirement, includes the following values:
0 (unknown)
1 (Add requirement window)
4 (Email import)
5 (Text file import)
13 (MS Word Import) |
| VERSION | No | NUMERIC(10) | No | Current requirement version number. |
| IDPRIORITY | No | NUMERIC(10) | No | Importance field, links to a record ID in FLDRPRIO table |
| DESCRPTN | No | TEXT | No | Description field. |
| CURASGTO | No | TEXT | No | Stores names of users requirement is currently assigned to for external reporting tools. |
| INITSTATUS | No | NUMERIC(10) | No | Initial requirement state. |
Table: REQVRSN
| Note | Contains requirement version information. Each table row represents one requirement version. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| IDREQMNT | No | NUMERIC(10) | No | Links to a record ID in REQMNT table |
| DATECREATE | No | DATETIME | No | Date/time (in GMT) requirement version was added to the database |
| IDCREATEBY | No | NUMERIC(10) | No | User who created the requirement version. Links to a record ID in USERS table |
| VERSION | No | NUMERIC(10) | No | Contains the version number of the requirement version. |
Table: RPCHRT
| Note | Contains report chart information. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| CHRTRPTID | No | NUMERIC(10) | Yes | Report chart is associated with. Links to a record ID in RPDETL, RPDIST, RPLIST, or RPTREND table. |
| CHRTPOS | No | NUMERIC(2) | No | Chart position in the report. |
| CHRTTYP | No | NUMERIC(2) | No | Chart type; includes the following values:
0 (Unknown)
1 (Pie)
2 (3DPie)
3 (Bar)
4 (3DBar)
5 (Floating Bar)
6 (3D Floating Bar)
7 (Area)
8 (3DArea)
9 (Line)
10 (3DLine) |
| TITLE | No | VARCHAR(4000) | No | Chart title. |
| TITLESZ | No | NUMERIC(2) | No | Chart title size; Includes the following values:
0 (Unknown)
1 (Very Small)
2 (Small)
3 (Medium)
4 (Large)
5 (Very Large) |
| DATAFLDID | No | NUMERIC(10) | No | Report data type; includes the following values:
-1 (Invalid)
0 (Defects)
4 (Customers)
1 (Users)
2 (Security Groups)
3 (Test Configs)
8 (Defect Filters)
9 (Reports)
10 (Workbook Tasks) |
| TITLECLR | No | NUMERIC(10) | No | Title font color (RGB format). |
| WIDTH | No | NUMERIC(5) | No | Chart width in pixels. |
| HEIGHT | No | NUMERIC(5) | No | Chart height in pixels. |
| BKGCLR | No | NUMERIC(10) | No | Chart background color (RGB format). |
| DATPRVLST | No | VARCHAR(4000) | No | List of field IDs to chart. |
| PIELBLS | No | NUMERIC(1) | No | Indicates if labels used on a pie chart. |
| PIELBLSZ | No | NUMERIC(2) | No | Size of pie chart labels. |
| PIESHWPCTS | No | NUMERIC(1) | No | Indicates if percentage amount is shown on slice of a pie chart. |
| PIELBLPOS | No | NUMERIC(5) | No | Pie chart label position in pixels. |
| PIELBLCLR | No | NUMERIC(10) | No | Pie chart label color (RGB format). |
| BARSHWGRD | No | NUMERIC(1) | No | Indicates if grid is shown on a bar chart. |
| BARSHOWX | No | NUMERIC(1) | No | Indicates if x-axis is shown on a bar chart. |
| BARSHOWY | No | NUMERIC(1) | No | Indicates if y-axis is shown on a bar chart. |
| BARXTTLE | No | VARCHAR(128) | No | Bar chart x-axis title. |
| BARXTTLESZ | No | NUMERIC(2) | No | Bar chart x-axis size. |
| BARYTTLE | No | VARCHAR(128) | No | Bar chart y-axis title. |
| BARYTTLESZ | No | NUMERIC(2) | No | Bar chart y-axis title. |
| BARAXSLBLS | No | NUMERIC(1) | No | Indicates if value labels are shown along axis of a graph of a bar chart. |
| BARXLBLSZ | No | NUMERIC(2) | No | Bar chart x-axis labels size |
| BARXLBLCLR | No | NUMERIC(10) | No | Bar chart x-axis labels color (RGB format). |
| BARYLBLSZ | No | NUMERIC(2) | No | Bar chart y-axis labels size. |
| BARYLBLCLR | No | NUMERIC(10) | No | Bar chart y-axis labels color (RGB format). |
| BARLBLSPC | No | NUMERIC(5) | No | Spacing between bar chart columns. |
| BARDNSTY | No | NUMERIC(5) | No | Placing of marks on the y-axis of a bar chart; the higher the percentage, the more dense the marks displayed. |
| BARXTTLCLR | No | NUMERIC(10) | No | Bar chart x-axis title color (RGB format). |
| BARYTTLCLR | No | NUMERIC(10) | No | Bar chart y-axis title color (RGB format). |
| BARGRDCLR | No | NUMERIC(10) | No | Bar chart grid color (RGB format). |
Table: RPCUSTOM
| Note | Contains custom report information. Each table row represents one custom report. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| NAME | No | VARCHAR(512) | No | Name field. |
| TITLE | No | VARCHAR(4000) | No | Title field used on report output. |
| IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
| ACCESSSTAT | No | NUMERIC(2) | No | Report share with setting, possible values include:
0 (No one)
1 (Everyone)
2 (All Users)
3 (All Customers)
4 (Selected Groups)
5 (Published)
6 (Selected Users) |
| STYLENAME | No | VARCHAR(1020) | No | Name of the .xslt file from the \StyleSheets\Custom directory. |
| STYLEDIR | No | VARCHAR(1020) | No | Directory where the .xslt file referenced in StyleName is located. |
| STYLREPTYP | No | NUMERIC(2) | No | Report type; includes the following values: 0 (Unknown), 1 (Detailed), 2 (Distribution), 3 (List), 4 (Trend), 5 (Custom). |
| STYLSCOPE | No | NUMERIC(2) | No | Indicates where report stylesheet is applicable; includes the following values: 0 (Unknown), 1 (Local) - not valid for this type, 2 (Server), 3 (Database) |
| STYLDTPRV | No | NUMERIC(10) | No | Indicates report data type for the report; includes the following values:
-1 (Invalid)
0 (Defects)
1 (Users)
2 (Security Groups)
3 (Test Configs)
4 (Customers)
8 (Defect Filters)
9 (Reports)
10 (Workbook Tasks)
13 (Test Cases)
14 (Test Runs)
15 (Folders)
16 (All Types)
18 (Documents)
19 (ReqDocuments) |
| DATEPRFROM | No | DATETIME | No | Contains the from date if specified in the Options tab. |
| DATEPRTO | No | DATETIME | No | Contains the thru date if specified in the Options tab. |
| IDFOLDER | No | NUMERIC(10) | No | Folder idRecord for folder specified on the Source tab. |
| RECURSIVE | No | NUMERIC(1) | No | Recursive folder checkbox as specified on the Source tab. |
| ENTITYMASK | No | NUMERIC(10) | No | A bitmask of the entity types that the chart supports. |
| DFCTFLTRID | No | NUMERIC(10) | No | Issue filter the report uses. |
| TSTCFLTRID | No | NUMERIC(10) | No | Test case filter the report uses. |
| TSTRFLTRID | No | NUMERIC(10) | No | Test run filter the report uses. |
| RQMTFLTRID | No | NUMERIC(10) | No | Requirement filter the report uses. |
| RDMTFLTRID | No | NUMERIC(10) | No | Requirement document filter the report uses. |
| SRTPRFLDID | No | NUMERIC(10) | No | Primary sort column field ID. |
| SRTSCFLDID | No | NUMERIC(10) | No | Secondary sort column field ID. |
| SRTPRORDER | No | NUMERIC(2) | No | Primary sort order. |
| SRTSCORDER | No | NUMERIC(2) | No | Secondary sort order. |
| OPTIONS | No | TEXT | No | XML text containing additional parameters... - Include Links - Link Defiition list of links to include, list of folder types to include - Show Chart - Show Data (Stored as XML to allow for future expansion). |
Table: RPDETL
| Note | Contains detail report information. Each table row represents one detail report. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
| IDFILTER | No | NUMERIC(10) | No | Filter the report uses. |
| NAME | No | VARCHAR(512) | No | Name field. |
| TITLE | No | VARCHAR(4000) | No | Title field used on report output. |
| ACCESSSTAT | No | NUMERIC(1) | No | Report share with setting, possible values include:
0 (No one)
1 (Everyone)
2 (All Users)
3 (All Customers)
4 (Selected Groups)
5 (Published)
6 (Selected Users) |
| STYLENAME | No | VARCHAR(1020) | No | XSLT document for file name. |
| STYLEDIR | No | VARCHAR(1020) | No | Directory where STYLENAME file is located. |
| STYLREPTYP | No | NUMERIC(2) | No | Indicates type of report; includes the following values:
0 (Unknown)
1 (Detail)
2 (Distribution)
3 (List)
4 (Trend) |
| STYLSCOPE | No | NUMERIC(2) | No | Indicates where report stylesheet is applicable; includes the following values:
0 (Unknown)
1 (Local)
2 (Server)
3 (Database) |
| BRKAFTITEM | No | NUMERIC(1) | No | Insert page break between items flag. |
| TYPETOSHOW | No | NUMERIC(2) | No | Indicates report object type; includes the following values:
0 (Issues)
1 (Users)
2 (Security Groups)
3 (Test Configurations)
4 (Customers)
5 (No longer used)
6 (No longer used)
7 (No longer used)
8 (Issue Filters)
9 (Reports)
10 (Workbook tasks )
11 (Audit Events)
12 (Workflow)
13 (Test Cases)
14 (Manual Test Runs)
15 (Folders)
16 (Core Items)
17 (External Reports)
18 (Requirements)
19 (Requirement Documents)
20 (Dashboard WIdgets)
21 (Custom)
22 (All)
23 (Requirement Document Specification)
24 (Baselines)
25 (Baseline Items)
26 (Automated Test Results) |
| STYLDTPRV | No | NUMERIC(10) | No | Indicates report data type; includes the following values:
-1 (Invalid)
0 (Defects)
4 (Customers)
1 (Users)
2 (Security Groups)
3 (Test Configs)
8 (Defect Filters)
9 (Reports)
10 (Workbook Tasks) |
| PRINTALL | No | NUMERIC(1) | No | Include all entities in report or only selected entities (where an entity is defined by the selection in the TYPETOSHOW field). |
| SHOWLIST | No | VARCHAR(4000) | No | List of entities to include in report (where an entity is defined by the selection in the TYPETOSHOW field); list has user record IDs that link to the USERS, USERGRP, or SYSCONF table. |
| SRTPRFLDID | No | NUMERIC(10) | No | Primary sort column field ID. |
| SRTSCFLDID | No | NUMERIC(10) | No | Secondary sort column field ID. |
| SRTPRORDER | No | NUMERIC(2) | No | Order primary sort column is sorted. |
| SRTSCORDER | No | NUMERIC(2) | No | Order secondary sort column is sorted. |
Table: RPDIST
| Note | Contains distribution report information. Each table row represents one distribution report. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| NAME | No | VARCHAR(512) | No | Name field. |
| TITLE | No | VARCHAR(4000) | No | Title field used on report output. |
| IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
| ACCESSSTAT | No | NUMERIC(1) | No | Report share with setting, possible values include:
0 (No one)
1 (Everyone)
2 (All Users)
3 (All Customers)
4 (Selected Groups)
5 (Published)
6 (Selected Users) |
| STYLENAME | No | VARCHAR(1020) | No | XSLT document file name. |
| STYLEDIR | No | VARCHAR(1020) | No | Directory where STYLENAME file is located. |
| STYLREPTYP | No | NUMERIC(2) | No | Indicates type of report; Includes the following values:
0 (Unknown)
1 (Detailed)
2 (Distribution)
3 (List)
4 (Trend) |
| STYLSCOPE | No | NUMERIC(2) | No | Indicates where report stylesheet is applicable; includes the following values:
0 (Unknown)
1 (Local)
2 (Server)
3 (Database) |
| STYLDTPRV | No | NUMERIC(10) | No | Indicates report data type for the report; includes the following values:
-1 (Invalid)
0 (Defects)
4 (Customers)
1 (Users)
2 (Security Groups)
3 (Test Configs)
8 (Defect Filters)
9 (Reports)
10 (Workbook Tasks) |
| REPORTON | No | NUMERIC(2) | No | Report on field option; includes the following values:
1 (Action by user)
2 (Reported by field)
3 (Status by field) |
| USERACTION | No | NUMERIC(10) | No | User action selected from pop-up menu, used if REPORTON field is set to “Action by user”’; includes the
following values:
1 (Found)
2 (Assigned)
3 (Fixed)
4 (Verified)
5 (Closed) |
| REPRTBYFLD | No | NUMERIC(10) | No | Reported by field selected from pop-up menu, used if REPORTON field is set to Reported by field; Includes the following values:
1 (Status)
2 (Type)
3 (Priority)
4 (Product)
5 (Resolution)
6 (Test Configuration)
7 (Component)
8 (Disposition) |
| STATSBYFLD | No | NUMERIC(2) | No | Status by field selected from pop-up menu, used if REPORTON field is set to “Status by field”; includes the following values:
1 (Type)
2 (Priority)
3 (Product)
4 (Component) |
| DATEPRFROM | No | DATETIME | No | From field in the report options. |
| DATEPRTHRU | No | DATETIME | No | Through field in the report options. |
| INCTOTALS | No | NUMERIC(1) | No | Include totals field. |
| IDFILTER | No | NUMERIC(10) | No | Filter the report uses. |
| XAXISFLDID | No | NUMERIC(10) | No | X-axis column field ID. |
| YAXISFLDID | No | NUMERIC(10) | No | Y-axis column field ID. |
| SRTPRFLDID | No | NUMERIC(10) | No | Primary sort column field ID. |
| SRTSCFLDID | No | NUMERIC(10) | No | Secondary sort column field ID. |
| SRTPRORDER | No | NUMERIC(2) | No | Primary column sort order. |
| SRTSCORDER | No | NUMERIC(2) | No | Secondary column sort order. |
| EXCLCOLS | No | VARCHAR(4000) | No | Reserved for future use. |
| RECPERPG | No | NUMERIC(5) | No | Records per printed page. |
| HIDEEMPTYR | No | NUMERIC(1) | No | Flag indicates if empty rows are displayed. |
| HIDEEMPTYC | No | NUMERIC(1) | No | Flag indicates if empty columns are displayed. |
| TYPETOSHOW | No | NUMERIC(2) | No | Indicates report object type; includes the following values:
1 (Defects)
2 (Users)
3 (Security Groups)
4 (Test Configurations)
5 (Customers) |
Table: RPEXTERN
| Note | Contains external report information. Each table row represents one external report. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| IDFILTER | No | NUMERIC(10) | No | Filter the report uses. |
| IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
| NAME | No | VARCHAR(512) | No | Name field. |
| TITLE | No | VARCHAR(4000) | No | Title field used on report output. |
| ACCESSSTAT | No | NUMERIC(1) | No | Report share with setting, possible values include:
0 (No one)
1 (Everyone)
2 (All Users)
3 (All Customers)
4 (Selected Groups)
5 (Published)
6 (Selected Users) |
| ORGNLNAME | No | VARCHAR(128) | No | Original name of external report. |
| ADDLINFO | No | TEXT | No | Additional information about the report. |
| EXRPTID | No | TEXT | No | External report identifier field. |
| SRVCGUID | No | VARCHAR(38) | No | External reporting service identifier field. |
| OUTPTYP | No | NUMERIC(10) | No | Output format of the report. |
Table: RPFRMT
| Note | Describes the layout of a field type on a report. The field type default uses the values from the XSL file. Each field type has a parent type that is used unless the field has a defined format. In this case, the field’s format is used. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID uniquely identifying a row in this table |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| FRMTFNT | No | NUMERIC(2) | No | Font family; includes the following values:
-1 (use XSL value)
1 (serif)
2 (sans serif)
3 (cursive)
4 (monospace)
5 (fantasy) |
| CHRTRPTID | No | NUMERIC(10) | No | Specifies report format is associated with (customization can only be applied to list reports); links to a record ID in RPLIST table. |
| FNTSZ | No | NUMERIC(5) | No | Font size in pixels. |
| FNTWT | No | NUMERIC(2) | No | Font weight or thickness; includes the following values:
-1 (use xsl value)
0 (100)
1 (200)
2 (300)
3 (400)
4 (500)
5 (600)
6 (700)
7 (800)
8 (900) |
| FNTCLR | No | NUMERIC(10) | No | Font color (RGB format). |
| FNTBKGCLR | No | NUMERIC(10) | No | Font background color (RGB format). |
| HALIGN | No | NUMERIC(2) | No | Field horizontal alignment; includes the following values:
-1 (use xsl value)
0 (left)
1 (center)
2 (right)
3 (justify) |
| VALIGN | No | NUMERIC(2) | No | Field vertical alignment; includes the following values:
-1 (use xsl value)
0 (top)
1 (middle)
2 (bottom)
3 (baseline) |
| WIDTH | No | NUMERIC(5) | No | Field width. |
| HEIGHT | No | NUMERIC(5) | No | Field height. |
| BRDRSZ | No | NUMERIC(5) | No | Border size. |
| TBLBKGCLR | No | NUMERIC(10) | No | Background field color (RGB format). |
| FRMTPAD | No | NUMERIC(5) | No | Cell padding. |
| FRMTSP | No | NUMERIC(5) | No | Cell spacing. |
| FRMTTYPE | No | NUMERIC(5) | No | Field format; includes the following values:
-1 (Invalid)
0 (Field)
1000 (Header)
2000 (Detail Table)
3000 (Detail Column Heading)
4000 (Detail Row Heading)
5000 (Detail Data Cells)
6000 (Detail Row Totals)
7000 (Detail Column Totals)
8000 (Footer) |
| PRNTTYP | No | NUMERIC(5) | No | Parent field format; includes the following values:
-1 (Invalid)
0 (Field)
1000 (Header)
2000 (Detail Table)
3000 (Detail Column Heading)
4000 (Detail Row Heading)
5000 (Detail Data Cells)
6000 (Detail Row Totals)
7000 (Detail Column Totals)
8000 (Footer) |
| FRMTFLDID | No | NUMERIC(10) | No | Field ID. |
Table: RPIDS
| Note | Contains a row for each report defined in the database, regardless of report type. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| TYPE | No | NUMERIC(5) | No | Report type; includes the following values:
1 (Detail)
2 (Distribution)
3 (List)
4 (Trend) |
Table: RPLIST
| Note | Contains list report information. Each table row represents one list report. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| NAME | No | VARCHAR(512) | No | Report name. |
| IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
| TITLE | No | VARCHAR(4000) | No | Report title. |
| ACCESSSTAT | No | NUMERIC(1) | No | Report share with setting, possible values include:
0 (No one)
1 (Everyone)
2 (All Users)
3 (All Customers)
4 (Selected Groups)
5 (Published)
6 (Selected Users) |
| STYLENAME | No | VARCHAR(1020) | No | XSLT document file name. |
| STYLEDIR | No | VARCHAR(1020) | No | Directory where the STYLENAME file is located. |
| STYLREPTYP | No | NUMERIC(2) | No | Report type; includes the following values:
0 (Unknown)
1 (Detailed)
2 (Distribution)
3 (List)
4 (Trend) |
| STYLSCOPE | No | NUMERIC(2) | No | Indicates where report stylesheet is applicable; includes the following values:
0 (Unknown)
1 (Local)
2 (Server)
3 (Database) |
| STYLDTPRV | No | NUMERIC(10) | No | Report data type; includes the following values:
-1 (Invalid)
0 (Defects)
4 (Customers)
1 (Users)
2 (Security Groups)
3 (Test Configs)
8 (Defect Filters)
9 (Reports)
10 (Workbook Tasks) |
| TYPETOSHOW | No | NUMERIC(2) | No | Report object type; includes the following values:
0 Issues
1 Users
2 Security Groups
3 Test Configurations
4 Customers
5 No Longer Used
6 No Longer Used
7 No Longer Used
8 Filters,
9 Reports
10 Tasks
11 Audit Events
12 Workflow
13 Test Cases
14 Manual Test Runs
15 Folders
16 Core Items
17 External
18 Requirements
19 Requirement Documents
20 Dashboard Widget
21 Custom
22 All
23 Requirement Document Specification
24 Baselines
25 Baseline Items
26 Automated Test Results |
| GRIDLINES | No | NUMERIC(1) | No | Print grid lines. |
| SHOWLIST | No | VARCHAR(4000) | No | List of entities to include in the report (where an entity is defined by the selection in the TYPETOSHOW field); list has user record IDs that link to USERS, USERGRP, or SYSCONF table |
| SRTPRFLDID | No | NUMERIC(10) | No | Primary sort column field ID. |
| IDFILTER | No | NUMERIC(10) | No | Filter the report uses. |
| SRTSCFLDID | No | NUMERIC(10) | No | Secondary sort column field ID. |
| SRTPRORDER | No | NUMERIC(2) | No | Order the primary sort column is sorted. |
| SRTSCORDER | No | NUMERIC(2) | No | Order the secondary sort column is sorted. |
| RECPERPG | No | NUMERIC(5) | No | Records per printed page. |
Table: RPTREND
| Note | Contains trend report information. Each table row represents one trend report. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| NAME | No | VARCHAR(512) | No | Report name. |
| TITLE | No | VARCHAR(4000) | No | Report title. |
| IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
| ACCESSSTAT | No | NUMERIC(1) | No | Report share with setting, possible values include:
0 (No one)
1 (Everyone)
2 (All Users)
3 (All Customers)
4 (Selected Groups)
5 (Published)
6 (Selected Users) |
| STYLENAME | No | VARCHAR(1020) | No | XSLT document file name |
| STYLEDIR | No | VARCHAR(1020) | No | Directory where the STYLENAME file is located. |
| STYLREPTYP | No | NUMERIC(2) | No | Report type; includes the following values:
0 (Unknown)
1 (Detailed)
2 (Distribution)
3 (List)
4 (Trend) |
| STYLSCOPE | No | NUMERIC(2) | No | Indicates where the report stylesheet is applicable; includes the following values:
0 (Unknown)
1 (Local)
2 (Server)
3 (Database) |
| STYLDTPRV | No | NUMERIC(10) | No | Report data type; includes the following values:
-1 (Invalid)
0 (Defects)
4 (Customers)
1 (Users)
2 (Security Groups)
3 (Test Configs)
8 (Defect Filters)
9 (Reports)
10 (Workbook Tasks)
13 (Test Cases)
14 (Test Runs) |
| DATEPRFROM | No | DATETIME | No | From field (date/time). |
| DATEPRTHRU | No | DATETIME | No | Through field (date/time). |
| PERDUNITS | No | NUMERIC(2) | No | Period units; includes the following values:
1 (Days)
2 (Weeks)
3 (Months) |
| INCTOTALS | No | NUMERIC(1) | No | Include totals field. |
| REPORTON | No | NUMERIC(2) | No | Report on field; includes the following values:
1 (Defect status)
2 (Defect action by field) |
| DEFEVTREPT | No | NUMERIC(10) | No | Defect action selected in pop-up menu, only used if REPORTON field is set to Defect action by field; includes the following values:
1 (Found)
2 (Fixed)
3 (Verified Passed)
4 (Verified Failed)
5 (Closed) |
| SECNDFIELD | No | NUMERIC(10) | No | Status by field selected in pop-up menu, field is used if the REPORTON field is set to Defect action by field; includes the following values:
1 (Type)
2 (Priority)
3 (Resolution) |
| IDFILTER | No | NUMERIC(10) | No | Filter the report uses. |
| INCALLSTS | No | NUMERIC(1) | No | Include all status events for each defect. |
| INCTOTOP | No | NUMERIC(1) | No | Show number of events open in each period. |
| EXCLCOLS | No | VARCHAR(4000) | No | Reserved for future use. |
| RECPERPG | No | NUMERIC(5) | No | Records per printed page. |
| HIDEEMPTYC | No | NUMERIC(1) | No | Flag indicates if empty columns are displayed. |
| TYPETOSHOW | No | NUMERIC(2) | No | Indicates report object type; includes the following values:
0 (Defects)
4 (Customers)
1 (Users)
2 (Security Groups)
3 (Test Configs)
8 (Defect Filters)
9 (Reports)
10 (Workbook Tasks)
13 (Test Cases)
14 (Test Runs) |
Table: RUNCONFIGURATION
| Note | Contains data for default values when running an automation suite. Each table row represents default run parameter for one automation suite. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| AutoTestConfID | No | NUMERIC(10) | Yes | Record ID of the parent automation test configuration |
| SuiteID | No | NUMERIC(10) | Yes | Record ID of the parent automation suite |
| JsonData | No | NVARCHAR(max) | No | Default data to use when attempting to run an automation suite in JSON format. |
Table: SCCFILE
| Note | Contains SCC file information. Each table row represents one SCC file that is attached to an entity. This table has a many-to-one relationship with the corresponding entity table. Each row has an entity record ID. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ENTITYRID | No | NUMERIC(10) | Yes | Links to a record ID in corresponding entity table. |
| ENTITYTYPE | No | NUMERIC(10) | Yes | Entity type to which SCC File is linked to. |
| FILENAME | No | VARCHAR(1020) | No | File name in SCC system. |
| VERSION | No | TEXT | No | Version number of fix in the SCC system. |
| DATEFIXED | No | DATETIME | No | Date fix was made. |
| CHGLSTID | No | NUMERIC(10) | No | Change list record ID from the SCMCHGLST table. |
| PROVIDERID | No | NUMERIC(10) | No | Provider ID from the SCMPROVIDER table if the file was submitted by a configured external source control provider. |
| HYPERLINK | No | TEXT | No | Full file URL path to view the file if generated by XML import because the provider was not available. |
| AUTHOR | No | TEXT | No | Author who changed file for commit. Text string or user ID if committed by Helix ALM user. |
| HYPERLINKDETAIL | No | TEXT | No | JSON submitted by the external provider if the provider hook used a set of name/value pairs for field code replacement. |
| CHANGETYPE | No | NUMERIC(10) | No | Type of file change associated with the attachment:
0 (Unknown)
1 (File added)
2 (File edited)
3 (File removed) |
| ISPENDING | No | NUMERIC(1) | Yes | Indicates if the changelist is in a pending state. |
Table: SCMCHGLST
| Note | Contains source control changelist information. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ENTITYRID | No | NUMERIC(10) | Yes | Entity Record ID to which changelist is associated with. |
| ENTITYTYPE | No | NUMERIC(10) | Yes | Entity type to which changelist is associated with. |
| CHGLSTID | No | NUMERIC(10) | Yes | Changelist ID stored in the source control application. |
| COMMITTED | No | NUMERIC(1) | Yes | Flag indicates if changelist is committed. |
| MLNENAME | No | TEXT | No | Mainline name. |
| NAME | No | TEXT | No | Changelist name. |
| PROVIDERID | No | NUMERIC(10) | No | Provider ID from the SCMPROVIDER table if the file was submitted by a configured source control provider. |
| BRANCHNAME | No | TEXT | No | Branch the change was committed to. |
| ATTACHDATE | No | DATETIME | No | Date and time the changelist was committed to Helix ALM from the source control provider. |
| HYPERLINK | No | TEXT | No | Full file URL path to view the file if generated by XML import because the provider was not available. |
| AUTHOR | No | TEXT | No | Author who changed file for commit. Text string. |
| AUTHORID | No | NUMERIC(10) | No | User ID if committed by Helix ALM user. |
| HYPERLINKDETAIL | No | TEXT | No | JSON submitted by the source control provider if the provider hook used a set of name/value pairs for field code replacement. |
| ISPENDING | No | NUMERIC(1) | Yes | Indicates if the changelist is in a pending state. |
Table: SHAREGROUPSFILTER
| Note | Table linking filters to the groups they are shared with. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | No | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ItemID | No | NUMERIC(10) | Yes | ID of the shared filter. |
| GroupID | No | NUMERIC(10) | Yes | The ID of a group the item is shared with. |
Table: SHAREGROUPSFOLDER
| Note | Table linking folders to the groups they are shared with. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | No | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ItemID | No | NUMERIC(10) | Yes | ID of the shared folder. |
| GroupID | No | NUMERIC(10) | Yes | The ID of a group the item is shared with. |
Table: SHAREGROUPSREPORT
| Note | Table linking reports to the groups they are shared with. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | No | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ItemID | No | NUMERIC(10) | Yes | ID of the shared report |
| GroupID | No | NUMERIC(10) | Yes | The ID of a group the item is shared with. |
Table: SHAREGROUPSVIEW
| Note | Table linking saved tab/views to the groups they are shared with. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | No | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ItemID | No | NUMERIC(10) | Yes | ID of the shared tab/view. |
| GroupID | No | NUMERIC(10) | Yes | The ID of a group the item is shared with. |
Table: SHAREUSERSFILTER
| Note | Table linking filters to the users they are shared with. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | No | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ItemID | No | NUMERIC(10) | Yes | ID of the shared filter |
| UserID | No | NUMERIC(10) | Yes | The ID of a user the item is shared with. |
Table: SHAREUSERSFOLDER
| Note | Table linking folders to the users they are shared with. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | No | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ItemID | No | NUMERIC(10) | Yes | ID of the shared folder |
| UserID | No | NUMERIC(10) | Yes | The ID of a user the item is shared with. |
Table: SHAREUSERSREPORT
| Note | Table linking reports to the users they are shared with. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | No | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ItemID | No | NUMERIC(10) | Yes | The report that is shared with users |
| UserID | No | NUMERIC(10) | Yes | The ID of a user the item is shared with. |
Table: SHAREUSERSVIEW
| Note | Table linking saved tabs/views to the users they are shared with. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | No | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ItemID | No | NUMERIC(10) | Yes | ID of the shared tab/view. |
| UserID | No | NUMERIC(10) | Yes | The ID of a user the item is shared with. |
Table: SHRWUSRGRP
| Note | Contains settings for sharing filters with security groups. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ENTITYID | No | NUMERIC(10) | No | Identifies the item being shared with a security group. Currently only filters and reports are shared. |
| USRGROUPID | No | NUMERIC(10) | No | Identifies which security groups are shared with the item. |
| ENTITYTYPE | No | NUMERIC(10) | No | Indicates which entity type is being shared by this record. Currently only filters and reports are shared with security groups. |
Table: SNPSTTRE
| Note | Contains the requirement relationship tree for a snapshot of the document. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDSNAPSHOT | Yes | NUMERIC(10) | Yes | Links to a record ID in DOCSNPST table |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in SNPSTTRE table; Field contains the record ID of the parent node in the tree. If the node is at the top level ParnetID contains 0. |
| IDREQMNT | No | NUMERIC(10) | No | Links to a record ID in REQMNT table |
| REQVERSION | No | NUMERIC(10) | No | Contains the version number of the requirement that was current when the snapshot was created. |
| SIBORDER | No | NUMERIC(10) | No | Contains the order of this node in relation to its siblings in the parent node. |
Table: SPELLCHK
| Note | Contains the spell check options for a specified user. Each row contains the options for one specific user. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Link to USERS table; a value of 0x7FFFFFFF is used to store default system options. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| DMTLEX | No | IMAGE | No | Custom dictionary words (user’s or system-wide). |
| SPELLOPT | No | NUMERIC(10) | No | Bit field used to store different spell check options; values that can be used in this field are:
0x00000001 - Ignore capitalized words
0x00000002 - Ignore words that have mixed case.
0x00000004 - Ignore words in uppercase
0x00000008 - Ignore words with numbers
0x00000100 - Report doubled words
0x00000200 - Ignore case sensitive words
0x00004000 - Make phonetic suggestions
0x00080000 - Make typographic suggestions
0x00400000 - Ignore domain names
Other bit values are used internally by Helix ALM; only the bit fields listed above can be modified via ODBC |
| LANGCODE | No | NUMERIC(10) | No | Specifies language used when spell checking; there are over 50 allowed values, but typical values are:
24941 - American English
25202 - British English
25441 - Canadian English |
| LEXSRCH | No | NUMERIC(10) | No | Search depth used for spell checking; following are used by:
0 - fast but less accurate
1 - moderately fast and accurate
2 - slow but accurate |
Table: STATES
| Note | Contains information about states that an entity can transition into. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ENTITYTYPE | No | NUMERIC(10) | No | The table state is linked to. |
| NAME | No | VARCHAR(128) | No | State name. |
| STATEDESC | No | VARCHAR(1020) | No | State description. |
| ACTIVE | No | NUMERIC(1) | No | Flag indicates if the state is active in the workflow. |
| STATEORDER | No | NUMERIC(10) | No | Identifies the order the state displays on the workflow configuration screens. |
| ATTRIB | No | NUMERIC(2) | No | Indicates if state is open or closed; includes the following values:
1 (open)
2 (closed) |
| ONLYASSIGN | No | NUMERIC(1) | No | Flag indicates if only assigned users can enter event |
| MULTIRULE | No | NUMERIC(2) | No | For states which are multi-user assignments, rule determines when state is completed and the corresponding entity moves to new state; includes the following values:
1 (use the first response)
2 (wait for all responses - use highest priority response)
3 (wait for highest priority response) |
| CNGENTSTRS | No | NUMERIC(1) | No | Flag indicates if this state can generate test runs; applies to test cases only. |
| COMPLSTAT | No | NUMERIC(5) | No | Indicates test run result, passed/failed/other; applies to test runs only. |
| LOCKED | No | NUMERIC(2) | No | Indicates if the item is locked in this state. |
| CNGENTSTCS | No | NUMERIC(1) | No | Flag indicates if this state can generate test cases; applies to requirements only. |
Table: STEPDATA
| Note | Contains test run step details. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ACTRSLTS | No | TEXT | No | Actual Results. |
| ISTCNOTE | No | NUMERIC(1) | No | Flag to indicate if this step is from test case. |
| NORDER | No | NUMERIC(10) | No | Order of steps. |
| STAMPTIME | No | DATETIME | No | Datetime of steps. |
| STEPDATA | No | TEXT | No | Steps |
| STEPRSLTS | No | NUMERIC(10) | No | Step results. |
| STEPTYPE | No | NUMERIC(10) | No | Step type (eComment = 1, eInsertedTestCase = 2, eStep = 3, eEmptyLine = 4, eCheckBox = 5 etc) |
| IDSTAMPUSR | No | NUMERIC(10) | No | UserID |
| IDTESTRUN | No | NUMERIC(10) | No | TestRun ID |
| ATTCHMNTS | No | TEXT | No | Step data attachments. |
Table: SUBCMDSC
| Note | Contains user group subtype command security settings. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| SECGRPID | No | NUMERIC(10) | Yes | Links to idRecord in USERGRP table. |
| SUBTYPEID | No | NUMERIC(10) | Yes | Links to idRecord in SUBTYPE table. |
| ENTITYTYPE | No | NUMERIC(10) | Yes | Table ID for item type. Currently only requirements are supported. |
| COMMDENIED | No | VARCHAR(3500) | No | Command security options. |
Table: SUBFLDDF
| Note | Contains default values and required field settings for fields by subtype. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| FLDDEFID | No | NUMERIC(10) | Yes | Links to the idRecord in the FLDDRNTN table. |
| SUBTYPEID | No | NUMERIC(10) | Yes | Links to the idRecord in the SUBTYPE table. |
| DEFAULTVAL | No | NUMERIC(10) | Yes | Default value for this field; stored values are based on field type; for string fields, the only value allowed is -4 (blank record ID); for pop-up menus, the allowed values are: 0 (not set record ID) and any valid record ID in corresponding table; for user fields, allowed values are: -2 (current user), 0 (not set record ID); for date fields, allowed values are: 0 (not set record ID), 1 (current date). |
| REQUIRED | No | NUMERIC(1) | Yes | Flag indicates if the field is required. |
| DEFAULTSTR | No | TEXT | No | Reserved for future use. |
Table: SUBFLDSC
| Note | Contains user group subtype field level security settings. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| SECGRPID | No | NUMERIC(10) | Yes | Links to idRecord in USERGRP table. |
| SUBTYPEID | No | NUMERIC(10) | Yes | Links to idRecord in SUBTYPE table. |
| ENTITYTYPE | No | NUMERIC(10) | Yes | Table ID for item type. Currently only requirements are supported. |
| FIELDSEC | No | TEXT | No | Field level security options |
Table: SUBTYPE
| Note | Contains requirement type information. Each table row represents one type value. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ENTITYTYPE | No | NUMERIC(10) | Yes | Table this type is linked to. Currently types are only supported for requirements. |
| DISPORDER | No | NUMERIC(3) | Yes | Popup display item order, relative to other types in this table. |
| NAME | No | VARCHAR(252) | Yes | Type name |
| STDESC | No | VARCHAR(1020) | No | Type description |
| STICON | No | IMAGE | No | Type icon |
| STICONNM | No | VARCHAR(1020) | No | Type icon file name |
| STPREFIX | No | VARCHAR(20) | No | Type tag prefix |
| STSUFFIX | No | VARCHAR(20) | No | Type tag suffix |
| SUMFRMTFNT | No | NUMERIC(2) | No | Reserved for future use |
| SUMFNTSZ | No | NUMERIC(5) | No | Reserved for future use |
| SUMFNTWT | No | NUMERIC(2) | No | Reserved for future use |
| SUMFNTCLR | No | NUMERIC(10) | No | Reserved for future use |
| DTLFRMTFNT | No | NUMERIC(2) | No | Reserved for future use |
| DTLFNTSZ | No | NUMERIC(5) | No | Reserved for future use |
| DTLFNTWT | No | NUMERIC(2) | No | Reserved for future use |
| DTLFNTCLR | No | NUMERIC(10) | No | Reserved for future use |
| ACTIVE | No | NUMERIC(1) | No | Flag indicating if type is active, can be selected for new items. |
| dateCreated | No | TIMESTAMP | No | Date the subtype was created. |
| ExcludeCoverage | No | NUMERIC(1) | No | Boolean indicating if the subtype is excluded from document test coverage. |
Table: SYSCONF
| Note | Contains test configuration information. Each table row represents one system test configuration. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| CONFTYPE | No | NUMERIC(1) | No | System configuration type; includes the following values:
1 (User’s Test Configuration)
2 (Standard Test Configuration) |
| SYSNAME | No | VARCHAR(128) | No | Name field. |
| LOCATION | No | VARCHAR(1020) | No | Reserved for future use. |
| COMPMODEL | No | VARCHAR(1020) | No | Computer model field. |
| COMPBRAND | No | VARCHAR(1020) | No | Computer brand field. |
| CPUTYPE | No | VARCHAR(128) | No | CPU type field. |
| CPUSPEED | No | VARCHAR(128) | No | CPU speed field (value specified in MHz). |
| HDISKTYPT | No | VARCHAR(1020) | No | Hard disk type field. |
| HDISKSIZE | No | VARCHAR(1020) | No | Hard disk size field (value specified in MB). |
| RAMSIZE | No | VARCHAR(128) | No | RAM field (value specified in MB) |
| ROMSIZE | No | VARCHAR(128) | No | ROM field (value specified in MB). |
| OSNAME | No | VARCHAR(252) | No | Operating system field. |
| OSVERSION | No | VARCHAR(128) | No | Operating system version field. |
| VIDEONAME | No | VARCHAR(252) | No | Video controller field. |
| HASMULTMON | No | NUMERIC(1) | No | Has multiple monitors field. |
| HASCDROM | No | NUMERIC(1) | No | Has CD-ROM field |
| CDROMMODEL | No | VARCHAR(252) | No | CD-ROM model field. |
| HASSCANR | No | NUMERIC(1) | No | Has scanner field. |
| SCANRMODEL | No | VARCHAR(252) | No | Scanner model field. |
| HASMODEM | No | NUMERIC(1) | No | Has modem field. |
| MODEMMODEL | No | VARCHAR(252) | No | Modem model field. |
| HASPRINT | No | NUMERIC(1) | No | Has printer field |
| PRINTMODEL | No | VARCHAR(252) | No | Printer model field |
| OTHERHW | No | VARCHAR(1020) | No | Other hardware and software field. |
Table: TABFILTER
| Note | Stores the temporary filters settings that are applied to any given tab when the user logs out. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| TABID | No | NUMERIC(10) | No | Record ID that uniquely identifies the list window tab this filter was assigned to. |
| ENTITYTYPE | No | NUMERIC(10) | No | Entity type the filter is associated with. |
| NAME | No | VARCHAR(252) | No | Name field |
| FILTERTYPE | No | NUMERIC(2) | No | Filter type: 0 - Normal, 1 - Find, 2 - Drilldown |
| USERID | No | NUMERIC(10) | Yes | Links to a record ID in USERS table. |
Table: TABFLTRDSP
| Note | Store the restrictions used by the temporary filters that are applied to any given tab when the user logs out. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| TABFLTRID | No | NUMERIC(10) | No | Identifies parent TABFILTER record. |
| LINEORDER | No | NUMERIC(3) | No | Restriction item order, relative to other items. |
| NOTFLAG | No | NUMERIC(1) | No | Indicates if Not flag is set. |
| OPENPAREN | No | NUMERIC(2) | No | Number of open parentheses that appear before
restriction item. |
| CLOSEPAREN | No | NUMERIC(2) | No | Number of open parentheses that appear after
restriction item. |
| RSTNTYPE | No | NUMERIC(2) | No | Operator applied to the next restriction item; includes the following values:
0 (none)
2 (AND operator)
3 (OR operator) |
| RESTRICTN | No | TEXT | No | Filter restriction information; field can use information from a filter restriction definition and code them into a
string value stored in this field |
Table: TABMAPVALUE
| Note | Contains table lookup mapping values for calculated pop-up custom field. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| IDTABMAP | No | NUMERIC(10) | Yes | Links to a record ID in TABULARMAP table. |
| IDFIELDDEF | No | NUMERIC(10) | Yes | Links to a record ID in FLDDFNTN table. |
| IDPUVALUE | No | NUMERIC(10) | Yes | The input pop-up list value for this mapping |
Table: TABULARMAP
| Note | Contains table lookup mapping for calculated pop-up custom field. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| IDFIELDDEF | No | NUMERIC(10) | Yes | Links to a record ID in FLDDFNTN table. |
| IDPUVALUE | No | NUMERIC(10) | Yes | The output pop-up list value for this mapping |
Table: TACTMOD
| Note | Contains information for the modify automation rule action. This table has a many-to-one relationship with the TRGACTN table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ACTIONID | No | NUMERIC(10) | Yes | Link to a record ID in the TRGACTN table. |
| ENTITYID | No | NUMERIC(10) | Yes | Entity type. |
| FIELDID | No | NUMERIC(10) | Yes | Field to be modified, links to a record ID in FLDDFNTN table. |
| FLDTYPE | No | NUMERIC(5) | No | Field type; includes the following values:
0 (invalid field type)
1 (text)
2 (text without replace)
3 (date)
4 (date/time)
5 (check box)
6 (pop-up menu)
7 (test case steps) |
| ACTION | No | NUMERIC(5) | No | Action to modify field; includes the following values:
0 (no action)
1 (set to value)
2 (prepend)
3 (append)
4 (replace) |
| VALA | No | TEXT | No | If action is set to value, contains value to set (e.g., if field is pop-up menu, contains record ID of value to set). |
| VALB | No | TEXT | No | If action is replace, contains strings to replace VALA with. |
Table: TASK
| Note | Contains workbook task information. Each table row represents one task defined in the workbook. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| TASKTYPE | No | NUMERIC(2) | Yes | Task type; includes the following values:
0 (Unknown)
1 (ToDo)
2 (Defect)
3 (TestCase)
4 (TestRun) |
| TASKSTATUS | No | NUMERIC(2) | No | Task status; includes the following values:
0 (Unknown)
1 (On Hold)
2 (Open)
3 (Done) |
| IDPRIORITY | No | NUMERIC(10) | No | Priority field, links to a record ID in FLDPRIOR table. |
| SUMMARY | No | VARCHAR(1020) | No | To do summary field. |
| VERSIONDUE | No | VARCHAR(128) | No | Need by version field. |
| DATEDUE | No | DATETIME | No | Need by date field. |
| DATEASSIGN | No | DATETIME | No | Date field. |
| IDASGTOUSR | No | NUMERIC(10) | No | User task is assigned to, links to a record ID in USERS table. |
| IDASGBYUSR | No | NUMERIC(10) | No | Reserved for future use. |
| TASKDESC | No | TEXT | No | Description field. |
Table: TASKBOARD
| Note | Contains the list of task boards configured for each project. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| TaskBoardName | No | VARCHAR(512) | Yes | Task board name. |
| TaskBoardDesc | No | VARCHAR(1020) | No | Task board description. |
| ShowEmptyLanesFolder | No | NUMERIC(1) | Yes | Boolean indicating if swimlanes should be displayed for empty folders when grouping by folder. |
| RollUpFieldFolder | No | NUMERIC(10) | Yes | Field ID for the field to use for rollup value when grouping by folder. |
| RollUpFieldUser | No | NUMERIC(10) | Yes | Field ID for the field to use for rollup value when grouping by user. |
| ShowEmptyLanesType | No | NUMERIC(1) | Yes | Boolean indicating if swimlanes should be displayed for items with no linked children when grouping by relationship. |
| RollUpFieldType | No | NUMERIC(10) | Yes | Field ID for the field to use for rollup value when grouping by relationship. |
| ShowEmptyLanesDoc | No | NUMERIC(1) | Yes | Boolean indicating if swimlanes should be displayed for empty documents when grouping by document. |
| RollUpFieldDoc | No | NUMERIC(10) | Yes | Field ID for the field to use for rollup value when grouping by document. |
| ShowAllReqTypes | No | NUMERIC(10) | Yes | Boolean indicating if all requirements types should be displayed when grouping by document. |
| Flags | No | NUMERIC(10) | Yes | Indicates the enabled group by options for the task board. |
Table: TASKBOARDCOLUMN
| Note | Contains the list of columns configured for a task board. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ParentTaskBoardID | No | NUMERIC(10) | Yes | Record ID for the parent task board the column is in. |
| ColumnName | No | VARCHAR(512) | Yes | Task board column name. |
| ColumnDescription | No | VARCHAR(1020) | No | Task board column description. |
| OrderNum | No | NUMERIC(5) | Yes | Position for this column relative to other columns in the task board. |
| WIPLimit | No | NUMERIC(10) | No | Work In Progress (WIP) limit for the column. Can be NULL to indicate no WIP limit is set. |
Table: TASKBOARDENTITYOPTNS
| Note | Contains card color information for each item type in the task board. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ParentTaskBoardID | No | NUMERIC(10) | Yes | Record ID for the parent task board. |
| EntityType | No | NUMERIC(10) | Yes | Item type ID to use the specified color. |
| SubtypeID | No | NUMERIC(10) | Yes | Requirement type ID to use the specified color. |
| FieldID | No | NUMERIC(10) | Yes | Field ID to use the field style color from. Reserved for future use. |
| DefaultColor | No | VARCHAR(6) | Yes | String representation of the color to use for the item type and requirement type. |
Table: TASKBOARDTYPEENTITY
| Note | Contains information about item types and requirement types that can be swimlanes when grouping by relationship. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| ParentTaskBoardID | No | NUMERIC(10) | Yes | Record ID for the parent task board. |
| EntityType | No | NUMERIC(10) | Yes | Item type ID. |
| SubtypeID | No | NUMERIC(10) | Yes | Requirement type ID. |
Table: TCEVTS
| Note | Contains event information for each event recorded with a test case. Each table row represents a single test case event. This table has a many-to-one relationship with the TESTCASE table, the EVENTS table, the USERS table, and the STATES table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| EVTDEFID | No | NUMERIC(10) | No | Links to a record ID in EVENTS table. |
| ORDERNUM | No | NUMERIC(5) | No | Identifies order the test case event was created relative to other test case events; an internal counter for a specific test case. |
| PARENTID | No | NUMERIC(10) | Yes | Links to a record ID in TESTCASE table. |
| EVTMUPARNT | No | NUMERIC(10) | No | Links to a record ID in TCEVTS table; if event is a response to a multi-user assignment, field is the record ID of the parent event; if event is not a response to a multi-user assignment, field contains the value -1. |
| IDUSER | No | NUMERIC(10) | No | Links to a record ID in USERS table; if user created event, it has the record ID of the user; if event was generated by Helix ALM, it has a record ID of -2 |
| DATEEVENT | No | DATETIME | No | Test case event date. |
| NOTES | No | TEXT | No | Notes field. |
| TIMESPENT | No | NUMERIC(20, 2) | No | If event definition for this event (EVENT table) has the time reporting option selected, field stores the amount of time entered by the user; if event does not record time spent, this field has the value -1. |
| RSLTSTATE | No | NUMERIC(10) | No | Links to a record ID in STATES table; if event affects resulting test case state, field contains the record ID of resulting state; if event does not affect resulting state, a value of 0 is stored in field |
| RELVERSION | No | VARCHAR(1020) | No | Notes field if event is configured to include release notes information |
| ASGNDUSERS | No | VARCHAR(4000) | No | If event is an assignment event (EVENT table), field contains a list of record IDs linked to the USERS table; if event is not an assignment, field is empty |
| GENBYTYPE | No | NUMERIC(2) | No | Value that identifies how event was created; includes following values:
0 (created by user)
1 (created by multi-user assignment)
2 (created by auto assignment)
3 (created by auto escalation) |
| CREATORID | No | NUMERIC(10) | No | Stores record id of who created the event in the following cases:
- Escalation rule record ID
- Trigger rule record ID
- User record ID of user that performed an action generating a system comment event |
| DEFASGEFF | No | NUMERIC(2) | No | Stores assignment of event at the time it was run (intended to preserve history if the event definition is modified); includes the following values:
1 (event results in new assignment)
2 (event has no effect on assignment)
3 (event clears assignment) |
| OVRWF | No | NUMERIC(1) | No | Flag indicates if event is a result of a Workflow Override. |
| OVRWFUSRID | No | NUMERIC(10) | No | Links to the USERS table; if event is a result of a Workflow Override, field stores the record ID of user; otherwise, the value 0 is written to field. |
| SSPLNKITMS | No | NUMERIC(1) | No | Flag indicating if user specified to mark dependent items as suspect. |
Table: TCLOG
| Note | Contains historical log information about changes made to test case records. Each row in this table represents a log entry in one of the test case records. Each table row has a test case record ID that matches a record ID in the TESTCASE table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDUSER | No | NUMERIC(10) | No | User who made change, links to a record ID in USERS table. |
| DATELOG | No | DATETIME | No | Date time the change occurred. |
| NOTES | No | VARCHAR(4000) | No | Description of the change. |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in TESTCASE table. |
| AUDITID | No | NUMERIC(10) | No | ID of the associated audit log entry, if any. |
Table: TCM_SUITE_ASSOCIATIONS
| Note | Contains information about test run suite folders and the parent test case suite folders. Each table row represents associations between a test run suite folder and its parent test case suite folder. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| SOURCE_TC_SUITE | Yes | NUMERIC(10) | Yes | Source test case suite folder used to generate a test run suite folder. |
| GENERATED_TR_SUITE | Yes | NUMERIC(10) | Yes | Test run suite folder generated from a test case suite folder. |
Table: TESTCASE
| Note | Contains test case information. Each table row represents one test case. Additional information associated with a test case is found in the TCEVTS table. This table has a one-to-one relationship with the STATES and FLDTOTP tables. This table has a many-to-many relationship with the USERS table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| DATECREATE | No | DATETIME | No | Date/time (in GMT) test case was added to the database. |
| IDCREATEBY | No | NUMERIC(10) | No | User who added the test case, links to a record ID in USERS table. |
| DATEMODIFY | No | DATETIME | No | Date/time (in GMT) test case was last modified. |
| IDMODIFYBY | No | NUMERIC(10) | No | User who last modified the test case, links to a record ID in USERS table. |
| TSTCASENUM | No | NUMERIC(10) | No | Test case number, value is zero if number not assigned. |
| SUMMARY | No | VARCHAR(1020) | No | Summary field. |
| IDTYPE | No | NUMERIC(10) | No | Test object type field, links to a record ID in FLDTOTP table. |
| ISAUTOTEST | No | NUMERIC(1) | No | Flag indicates if this is automated test. |
| ESTTIME | No | NUMERIC(10) | No | Estimated time of this test case execution. |
| STEPS | No | TEXT | No | Test case steps. |
| ADDEDFROM | No | NUMERIC(6) | No | Method used to add test case; includes the following values:
0 (unknown)
1 (Add test case window)
5 (Text file import)
6 (Helix ALM user duplicated a test case) |
| SAVEGRID | No | NUMERIC(1) | No | Flag indicates to save test runs in grid mode or plain text. |
| STATUS | No | NUMERIC(10) | No | Record id of the current state for the test case. |
| CURASGTO | No | TEXT | No | Names of the users the test case is currently assigned to. |
| SAVEMODE | No | NUMERIC(10) | No | Indicates how test runs should be generated.
0 (Use existing setting)
1 (Text View)
2 (Grid View)
3 (Detail Grid View) |
| TESTCASE | No | NUMERIC(10) | No | Initial test case state |
Table: TESTRUN
| Note | Contains test run information. Each table row represents one test run. Additional information associated with a test run is found in the TREVTS table. This table has a one-to-one relationship with the STATES, FLDTOTP and FLDTRSET tables. This table has a many-to-many relationship with the USERS table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| DATECREATE | No | DATETIME | No | Date/time (in GMT) test run was added to the database. |
| IDCREATEBY | No | NUMERIC(10) | No | User who added the test run, links to a record ID in USERS table. |
| DATEMODIFY | No | DATETIME | No | Date/time (in GMT) test run was last modified. |
| IDMODIFYBY | No | NUMERIC(10) | No | User who last modified the test run, links to a record ID in USERS table. |
| TSTCASERID | No | NUMERIC(10) | No | Test case record ID. |
| SUMMARY | No | VARCHAR(1020) | No | Summary field. |
| IDTYPE | No | NUMERIC(10) | No | Test object type field, links to a record ID in FLDTOTP table. |
| ISAUTOTEST | No | NUMERIC(1) | No | Flag indicates if this is automated test. |
| ESTTIME | No | NUMERIC(10) | No | Estimated time of this test run execution. |
| STEPS | No | TEXT | No | Test case steps. |
| ADDEDFROM | No | NUMERIC(6) | No | Method used to add test case; includes the following values:
0 (unknown)
1 (Add test run window)
5 (Text file import)
6 (Helix ALM user duplicated a test run) |
| TSTRUNNUM | No | NUMERIC(10) | No | Test run number (Auto generated). |
| IDTRSET | No | NUMERIC(10) | No | Test run set field, links to a record ID in FLDTRSET table. |
| VIEWGRID | No | NUMERIC(1) | No | Flag indicates to view test runs in grid mode or plain text. |
| PRBSTATE | No | TEXT | No | Problem statement for this test run, if any. |
| STATUS | No | NUMERIC(10) | No | Record id of the current state for the test run. |
| CURASGTO | No | TEXT | No | Names of the users the test run is currently assigned to. |
| VIEWMODE | No | NUMERIC(10) | No | Indicates how test runs were generated.
0 (Use existing setting)
1 (Text View)
2 (Grid View)
3 (Detail Grid View) |
| INTSTATUS | No | NUMERIC(10) | No | Initial testrun state |
Table: TILECOLORMAP
| Note | Contains all color settings for home page widgets. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| TILEID | No | NUMERIC(10) | Yes | Parent widget record ID |
| VALUESTART | No | NUMERIC(10) | Yes | Number of items that must pass the widget filter to start using the specified color |
| COLOR | No | VARCHAR(24) | Yes | Color to use. Hex string. |
Table: TRACEREPORT
| Note | Contains custom traceability report information. Each table row represents one custom traceability report. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| NAME | No | VARCHAR(512) | No | Name field. |
| TITLE | No | VARCHAR(4000) | No | Title field used on report output. |
| IDOWNER | No | NUMERIC(10) | No | Report owner, links to a record ID in USERS table. |
| ACCESSSTAT | No | NUMERIC(2) | No | Report access state; values are: 1 (Shared) and 3 (Private) |
| ENTITYMASK | No | NUMERIC(10) | No | A bitmask of the entity types that the traceability report contains across all columns. |
| XML | No | TEXT | No | XML text containing additional parameters. (Stored as XML to allow for future expansion). |
Table: TRANSITION
| Note | Contains information describing which events can be entered for corresponding entities which are in a given state. If the state is a result of a multi-user assignment, also contained within the table is the priority of the resulting states. This table has a one-to-many relationship with the EVENTS table and the STATES table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| ENTITYTYPE | No | NUMERIC(10) | No | Table state is linked to. |
| STATERECID | No | NUMERIC(10) | No | Transition rule that apply to the entity in state referenced by this record ID; links to a record ID in STATES table. |
| ISDEFAULT | No | NUMERIC(1) | No | Flag indicates if state referenced by STATERECID is default state for new defects/test cases /test runs. |
| EVENTIDS | No | VARCHAR(3500) | No | Serialized record IDs linked to EVENTS table; record IDs in this field correspond to events that can be entered when an entity is in the STATERECID state |
| RSTLSTPRTY | No | VARCHAR(3500) | No | Serialized record IDs linked to STATES table, field used when current state is a multi-user assignment; lists priority of states that are evaluated to determine resulting state of a multi-user assignment. |
Table: TREVTS
| Note | Contains event information for each event recorded with a test run. Each table row represents a single test run event. This table has a many-to-one relationship with the TESTRUN table, the EVENTS table, the USERS table, and the STATES table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| EVTDEFID | No | NUMERIC(10) | No | Links to a record ID in EVENTS table. |
| ORDERNUM | No | NUMERIC(5) | No | Identifies order the test run event was created relative to other test run events; an internal counter for a specific testrun. |
| PARENTID | No | NUMERIC(10) | Yes | Links to a record ID in TESTRUN table. |
| EVTMUPARNT | No | NUMERIC(10) | No | Links to a record ID in TREVTS table; if event is a response to a multi-user assignment, field is the record ID of theparent event; if event is not a response to a multi-user assignment, field contains the value -1. |
| IDUSER | No | NUMERIC(10) | No | Links to a record ID in USERS table; if user created event, it has the record ID of the user; if event was generated by Helix ALM, it has a record ID of -2. |
| DATEEVENT | No | DATETIME | No | Test run event date. |
| NOTES | No | TEXT | No | Notes field. |
| TIMESPENT | No | NUMERIC(20, 2) | No | If event definition for this event (EVENT table) has the time reporting option selected, field stores the amount of time entered by the user; if event does not record time spent, this field has the value -1. |
| RSLTSTATE | No | NUMERIC(10) | No | Links to a record ID in STATES table; if event affects resulting test run state, field contains the record ID of resulting state; if event does not affect resulting state, a value of 0 is stored in field. |
| RELVERSION | No | VARCHAR(1020) | No | Notes field if event is configured to include release notes information. |
| ASGNDUSERS | No | VARCHAR(4000) | No | If event is an assignment event (EVENT table), field contains a list of record IDs linked to the USERS table; if event is not an assignment, field is empty. |
| GENBYTYPE | No | NUMERIC(2) | No | Value that identifies how event was created; includes following values:
0 (created by user)
1 (created by multi-user assignment)
2 (created by auto assignment)
3 (created by auto escalation) |
| CREATORID | No | NUMERIC(10) | No | Stores record id of who created the event in the following cases:
- Escalation rule record id
- Trigger rule record id
- User record id of user that performed an action generating a system comment event |
| DEFASGEFF | No | NUMERIC(2) | No | Stores assignment of event at the time it was run (intended to preserve history if the event definition is modified); includes the following values:
1 (event results in new assignment)
2 (event has no effect on assignment)
3 (event clears assignment) |
| OVRWF | No | NUMERIC(1) | No | Flag indicates if event is a result of a Workflow Override. |
| OVRWFUSRID | No | NUMERIC(10) | No | Links to the USERS table; if event is a result of a Workflow Override, field stores the record ID of user; otherwise, the value 0 is written to field. |
| SSPLNKITMS | No | NUMERIC(1) | No | Flag indicating if user specified to mark dependent items as suspect. |
Table: TRGACTN
| Note | Contains user notification and automation rule action information. This table has a many-to-one relationship with the TRIGGERS table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| TRIGGERID | No | NUMERIC(10) | Yes | Link to a record ID in TRIGGERS table. |
| TYPE | No | NUMERIC(5) | Yes | Action type; includes the following values:
0 (not set)
1 (enter event)
2 (notification)
3 (modify)
4 (run executable)
5 (prevent) |
| ONLYIFASGN | No | NUMERIC(1) | No | If user notification, indicates to only notify currently assigned user. |
| ENTIFASGND | No | NUMERIC(1) | No | If enter event action, indicates if event is entered if the record is already assigned. |
| OWNCHGS | No | NUMERIC(1) | No | If user notification, indicates if user receives email if they made changes to cause notification to be sent. |
| ACTOPTID | No | NUMERIC(10) | Yes | If enter event action, contains event ID; if prevent action, field contains message path; otherwise, field is NULL. |
| ACTOPTSTR | No | TEXT | No | If run executable action, contains executable path; if prevent action, contains prevent message. |
| TRACKEMAIL | No | NUMERIC(1) | No | Indicates if email is tracked for send email actions. |
Table: TRGOUTWEBHOOKACT
| Note | Contains webhook automation rule action information. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| TriggerID | No | NUMERIC(10) | Yes | Link to a record ID in TRIGGERS table. |
| WebhookRecpID | No | NUMERIC(10) | Yes | Link to a record ID in WEBHOOKRECP table. |
| SendExtraData | No | NUMERIC(1) | No | Reserved for future use. Boolean to indicate if additional data should be sent in addition to normal webhook data. |
Table: TRIGGERS
| Note | Contains automation rule information. This table has a many-to-many relationship with the STATES and FILTERS tables. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| CREATEDATE | No | DATETIME | No | Date/time rule was created. |
| ENTITYTYPE | No | NUMERIC(10) | No | Entity type the rule is associated with. |
| ENABLED | No | NUMERIC(1) | No | Indicates if the rule is enabled. |
| NAME | No | VARCHAR(400) | No | Trigger name. |
| OWNERID | No | NUMERIC(10) | No | If user notification, links to a record ID in USERS table; if automation rule, value is 0. |
| RULETYPE | No | NUMERIC(10) | No | Rule type; includes the following values:
0 (not set)
1 (notification)
2 (before save trigger)
3 (after save trigger)
4 (escalation) |
| CONDTYPE | No | NUMERIC(10) | No | Type of trigger condition; includes the following values:
0 (not set)
1 (state transition)
2 (item created)
3 (item merged)
4 (item assigned a number)
5 (item renumbered)
6 (item changed)
7 (item event changed)
8 (item assigned)
9 (test run generated) |
| TYPEOPT | No | NUMERIC(10) | No | Links to a record ID in STATES table. |
| FILTERID | No | NUMERIC(10) | No | Filter the trigger uses. |
| TRIGORDER | No | NUMERIC(10) | No | Order of before save trigger rules. |
| STOPIFPASS | No | NUMERIC(1) | No | Stops processing of next rule if this rule passes; only applies to before save triggers. |
| ISPRESAVE | No | NUMERIC(1) | No | Indicates if rule is before save or after save triggers. |
| APPLYONCE | No | NUMERIC(1) | No | Flag indicates to inactivate the rule after it runs once; only applies to escalations. |
| RUNONCE | No | NUMERIC(1) | No | Flag indicates to apply the rule once per record; only applies to escalations. |
| RUNONIMP | No | NUMERIC(1) | No | Flag indicates to run trigger when performing XML or text import; only applies to triggers. |
| LASTEVAL | No | DATETIME | No | Last date/time rule was evaluated; not set if the rule is never evaluated. |
Table: TRIGLOG
| Note | Contains historical log information about changes to automation rules. Each table row represents a log entry for a rule. Each table row has a record ID that matches a record ID in the TRIGGERS table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| TRIGGERID | No | NUMERIC(10) | Yes | Links to a record ID in TRIGGERS table. |
| ENTITYID | No | NUMERIC(10) | No | Entity type modified by automation rule. |
| RULENAME | No | VARCHAR(400) | No | Rule name that caused message to be generated. |
| MSGDATE | No | DATETIME | No | Date/time modification occurred. |
| RULETYPE | No | NUMERIC(5) | No | Rule type; includes the following values:
0 (not set)
1 (notification)
2 (before save trigger)
3 (after save trigger)
4 (escalation) |
| MSG | No | TEXT | No | Message written to log. |
Table: TRIGSCHD
| Note | Contains schedule information for escalation rules. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| TRIGGERID | No | NUMERIC(10) | Yes | Link to a record ID in TRIGGERS table. |
| PERIOD | No | NUMERIC(5) | No | Evaluation frequency; includes the following values:
0 (not set)
1 (daily)
2 (weekly)
3 (monthly)
4 (manually) |
| USESTRT | No | NUMERIC(1) | No | If evaluation is daily, indicates if hour or start time is used. |
| STARTTIME | No | DATETIME | No | Evaluation start date/time. |
| HOURFREQ | No | NUMERIC(5) | No | If evaluation is daily on a specific hour, contains the hour frequency. |
| DYSOFWK | No | NUMERIC | No | If evaluation is weekly, contains a comma-delimited list of enumerated days of the week to evaluate rule. |
| USEDYMNTH | No | NUMERIC(1) | No | If evaluation is monthly, indicates day of month option is selected. |
| DYMNTH | No | NUMERIC(5) | No | Day of month to evaluate rules on. |
| DAYOPT | No | NUMERIC(5) | No | If evaluation is monthly, day to evaluate in month; includes the following values:
0 (not set)
1 (first)
2 (second)
3 (third)
4 (fourth)
5 (last) |
| DYOFWK | No | NUMERIC(5) | No | If evaluation is monthly, contains day of the week to evaluate rule. |
| MNTHSOFYR | No | NUMERIC(5) | No | If evaluation is monthly, contains months to evaluate rule. |
Table: TRLOG
| Note | Contains historical log information about changes made to test run records. Each row in this table represents a log entry in one of the test run records. Each table row has a test run record ID that matches a record ID in the TESTRUN table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDUSER | No | NUMERIC(10) | No | User who made change, links to a record ID in USERS table. |
| DATELOG | No | DATETIME | No | Date time the change occurred. |
| NOTES | No | VARCHAR(4000) | No | Description of the change. |
| PARENTID | No | NUMERIC(10) | No | Links to a record ID in TESTRUN table. |
| AUDITID | No | NUMERIC(10) | No | ID of the associated audit log entry, if any. |
Table: TTDBOPTN
| Note | Contains database options. Works like a Windows INI file and each entry has a name/value pair. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| OPTDESC | No | NVARCHAR(63) | No | Description of option represented in this row. |
| OPTVALUE | No | NVARCHAR(356) | No | Value of option represented in this row. |
Table: TTPROJECTS
| Note | Contains the list of Helix ALM projects that reside in the RDBMS database. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project; all other project-related tables link to this id. |
| TTPROJNAME | No | VARCHAR(128) | Yes | Project name, which must be unique within the database. |
| TTPROJUUID | No | VARCHAR(152) | Yes | Universally unique project identifier. |
| TTSERVUUID | No | VARCHAR(152) | No | Universally unique identifier of Helix ALM Server that hosts the project. |
| TTPROJVERS | No | VARCHAR(40) | No | Project version number. |
| TTSERVDBID | No | NUMERIC(10) | No | Server database ID. |
Table: USERGROUPASSOC
| Note | Contains user group associations. Each table row represents associations between a user and a security group the user is in. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| UserID | Yes | NUMERIC(10) | Yes | ID for a user in a security group. |
| GroupID | Yes | NUMERIC(10) | Yes | ID for security groups a user is in. |
Table: USERGRP
| Note | Contains user group information. Each table row represents one user group. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| NAME | No | VARCHAR(128) | No | Name field |
| GROUPDESC | No | VARCHAR(1020) | No | Description field. |
| NOTES | No | TEXT | No | Notes field. |
| INUSERPOPUP | No | NUMERIC(1) | No | Include users in pop-up menus field. |
| INCSTPOPUP | No | NUMERIC(1) | No | Include customers in pop-up menus field. |
| IDDEFFLT | No | NUMERIC(10) | No | Filter that restricts issues users in this group can work with. |
| IDTCFLT | No | NUMERIC(10) | No | Filter that restricts test cases users in this group can work with. |
| IDTRFLT | No | NUMERIC(10) | No | Filter that restricts test runs users in this group can work with. |
| IDREQFLT | No | NUMERIC(10) | No | Filter that restricts requirements users in this group can work with. |
| IDDOCFLT | No | NUMERIC(10) | No | Filter that restricts requirement documents users in this group can work with. |
| ONLYMYDEF | No | NUMERIC(1) | No | Defect security option of "Users can only see and work with the defects they reported". |
| ONLYMYTC | No | NUMERIC(1) | No | Test case security option of "Users can only see and work with the test cases they reported". |
| ONLYMYTR | No | NUMERIC(1) | No | Test run security option of "Users can only see and work with the test runs they reported". |
| ONLYMYREQ | No | NUMERIC(1) | No | Requirement security option of "Users can only see and work with the requirements they reported". |
| ONLYMYDOC | No | NUMERIC(1) | No | Requirement document security option of "Users can only see and work with the requirement documents they reported". |
| FIELDSEC | No | TEXT | No | Field level security options |
| EVTDENIED | No | VARCHAR(3500) | No | Serialized list of record IDs linked to EVENTS table; contains record IDs of events that security group members cannot perform. |
Table: USERGRPDENIEDCMDS
| Note | Table containing a list of command numbers that are not allowed for each security group. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| GroupID | Yes | NUMERIC(10) | Yes | The user group |
| Command | Yes | NUMERIC(10) | Yes | The command number that the user group is denied access to |
Table: USERS
| Note | Contains user and customer information. Each table row represents either one user or one customer. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| ACTIVE | No | NUMERIC(1) | Yes | Flag indicates if a user is active; if false, user is inactive. |
| FIRSTNAME | No | VARCHAR(128) | No | First name field. |
| LASTNAME | No | VARCHAR(128) | No | Last name field. |
| LOGINNAME | No | VARCHAR(1424) | Yes | Login name field. As login name is stored as an encrypted string and for local users an empty string of 32 characters is encrypted therefore this field will not be null. |
| DATELOGOUT | No | DATETIME | No | Date/time (in GMT) that user last logged out of Helix ALM. |
| NOTES | No | TEXT | No | Notes field. |
| PHONETYPE1 | No | NUMERIC(2) | No | First phone number type field; includes the following values:
1 (Work)
2 (Fax)
3 (Home)
4 (Pager)
5 (Mobile) |
| PHONENUM1 | No | VARCHAR(128) | No | First phone number field. |
| PHONETYPE2 | No | NUMERIC(2) | No | Second phone number type field; includes the following values:
1 (Work)
2 (Fax)
3 (Home)
4 (Pager)
5 (Mobile) |
| PHONENUM2 | No | VARCHAR(128) | No | Second phone number field. |
| BETASITE | No | NUMERIC(1) | No | Beta test site field (used only for customers) |
| COMPANY | No | VARCHAR(252) | No | Company field (used only for customers) |
| ADDRESS | No | VARCHAR(1020) | No | Address field (used only for customers) |
| IDTESTCONF | No | NUMERIC(10) | No | Links to a record ID in SYSCONF table where user’s system configuration information is stored. |
| EMAILTYPE | No | NUMERIC(2) | No | Email type field; includes the following values:
1 (Internet)
2 (MAPI)
3 (Other) |
| ISCUSTOMER | No | NUMERIC(1) | Yes | Flag indicates if a user is a customer; if false, this is a user, if true, this is a customer. |
| ISGLOBAL | No | NUMERIC(1) | Yes | Flag indicates if user is a global user. |
| EMAILADDR | No | VARCHAR(252) | No | Email address field. |
| ALLOWSSO | No | NUMERIC(1) | No | Flag indicates single sign-on support. |
| INITIALS | No | VARCHAR(32) | No | Middle initials. |
| DIVISION | No | VARCHAR(252) | No | User's division within company |
| DEPARTMENT | No | VARCHAR(252) | No | User's department within division |
| ADDLINFO | No | TEXT | No | Additional info about user, reserved for future use |
Table: USERSET
| Note | Contains user settings information. Each user has a set of user settings (also referred to as user options). The record ID has a one-to-one relationship with the USERS table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| NOTFSOUND | No | NUMERIC(1) | No | Play a sound option for assignment notification. |
| NOTFDIALOG | No | NUMERIC(1) | No | Display a dialog box option for assignment notification. |
| DBLCLKEDIT | No | NUMERIC(1) | No | Double-click on items field. |
| NAMEORDER | No | NUMERIC(10) | No | Display names as option; includes the following values:
0 (First Last)
1 (Last First) |
| RECPERPAGE | No | NUMERIC(5) | No | Web option to limit number of defects displayed per page on the Work With Defects window. |
| ASGNINSTAT | No | NUMERIC(1) | No | Status display option, determines if assignment information is displayed in the status field. |
| GRAYCLSDEF | No | NUMERIC(1) | No | Grey out closed defects field. |
| WARNFLDREL | No | NUMERIC(1) | No | User option to display warning when field relationship information may be impacted |
| AFTDEFADD | No | NUMERIC(2) | No | Action performed after adding a defect; includes the following values:
0 (Set all fields to their default values)
1 (Retain pop-up menu values)
2 (Close the Add Defect window) |
| SCCIUNAME | No | VARCHAR(1424) | No | Username for the SCC integration; this username is for this Helix ALM user. |
| SCCIPWD | No | VARCHAR(2832) | No | Password for the SCC integration; this password is for this Helix ALM user. |
| PROJNAME | No | VARCHAR(1020) | No | Project name for SCC integration. |
| DBPATH | No | VARCHAR(1020) | No | SCC integration connection information. |
| WEBTZOPT | No | NUMERIC(1) | No | Determines time zone to use for web interface; includes the following values: are GMT, server’s time zone, or specified time zone (see the WebTzOff field). |
| WEBTZOFF | No | NUMERIC(6) | No | Specified time zone for web interface. |
| DEFLAYOUT | No | NUMERIC(1) | No | Indicates defect view window layout, vertical tab view or single page view. |
| AFTTCADD | No | NUMERIC(2) | No | Action performed after adding a test case; includes the following values:
0 (Set all fields to their default values)
1 (Retain pop-up menu values)
2 (Close the Add test case window) |
| GRAYCLOSTC | No | NUMERIC(1) | No | Dim, or gray out, closed test cases field. |
| GRAYCOMPTR | No | NUMERIC(1) | No | Dim, or gray out, completed test runs field. |
| HDDFOVVWTB | No | NUMERIC(1) | No | Indicates if defect Overview tab is displayed or hidden. |
| HDTCOVVWTB | No | NUMERIC(1) | No | Indicates if test case Overview tab is displayed or hidden. |
| HDTROVVWTB | No | NUMERIC(1) | No | Indicates if test run Overview tab is displayed or hidden. |
| ALWSTBBR | No | NUMERIC(1) | No | Indicates if tab bar is displayed or hidden. |
| HGHLTCOLOR | No | VARCHAR(24) | No | Highlight color code for type ahead searching. |
| HGHLTBOLD | No | NUMERIC(1) | No | Indicates if type ahead search text results are bold |
| HGHLTUNDER | No | NUMERIC(1) | No | Indicates if type ahead search results are underlined. |
| HGHLITALIC | No | NUMERIC(1) | No | Indicates if type ahead search results are italicized. |
| DRDNCOLOR | No | VARCHAR(24) | No | Color code for column filters in list windows. |
| OPNSPCDC | No | NUMERIC(1) | No | Open requirement document in specification window field. |
| REQEVTINLN | No | NUMERIC(1) | No | |
| AFTRQADD | No | NUMERIC(2) | No | Action performed after adding a requirement; includes the following values:
0 (Set all fields to their default values)
1 (Retain pop-up menu values)
2 (Close the Add Requirement window) |
| AFTDOCADD | No | NUMERIC(2) | No | Action performed after adding a requirement document; includes the following values:
0 (Set all fields to their default values)
1 (Retain pop-up menu values)
2 (Close the Add Requirement Document window) |
| GRAYCLOSRQ | No | NUMERIC(1) | No | Dim, or gray out, closed requirements field. |
| GRAYCLOSDC | No | NUMERIC(1) | No | Dim, or gray out, closed requirement documents field. |
| HDRQOVVWTB | No | NUMERIC(1) | No | Indicates if defect Overview tab is displayed or hidden on Requirements detail window. |
| HDDCOVVWTB | No | NUMERIC(1) | No | Indicates if defect Overview tab is displayed or hidden on Requirement Documents detail window. |
| ADDCOLOR | No | VARCHAR(24) | No | Added requirement text color for differences window. |
| ADDBOLD | No | NUMERIC(1) | No | Added requirements text displays in bold for differences window. |
| ADDUNDER | No | NUMERIC(1) | No | Added requirements text displays underlined for differences window. |
| ADDITALIC | No | NUMERIC(1) | No | Added requirements text displays in italic for differences window. |
| ADDSTRIKE | No | NUMERIC(1) | No | Added requirements text displays in strikeout for differences window. |
| REMVCOLOR | No | VARCHAR(24) | No | Removed requirement text color for differences window. |
| REMVBOLD | No | NUMERIC(1) | No | Removed requirements text displays in bold for differences window. |
| REMVUNDER | No | NUMERIC(1) | No | Removed requirements text displays underlined for differences window. |
| REMVITALIC | No | NUMERIC(1) | No | Removed requirements text displays in italic for differences window. |
| REMVSTRIKE | No | NUMERIC(1) | No | Removed requirements text displays in strikeout for differences window. |
Table: USERSETENT
| Note | Contains shortcut menu settings for a specified user. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| USERID | No | NUMERIC(10) | Yes | Links to a record ID in USERS table. |
| ENTITYTYPE | No | NUMERIC(10) | Yes | Identifies the list window the shortcut menu settings apply to. |
| CTXACTENUMS | No | TEXT | No | Actions included in the shortcut menu. |
| SHOWWRKFWSUB | No | NUMERIC(1) | Yes | Flag that indicates if workflow events are grouped in a sub-menu. |
| ALLOWWRKFWEVTS | No | TEXT | No | Reserved for future use. |
Table: USER_AUTOTESTCONF
| Note | User specific information for communicating with a specific automated test configuration. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| UserID | Yes | NUMERIC(10) | Yes | Record ID of the a user |
| AutoTestConfID | Yes | NUMERIC(10) | Yes | Record ID of an automated test configuration |
| ConfData | No | NVARCHAR(max) | Yes | User specific data for communicating with an automated test configuration |
Table: VERSION_DOC
| Note | Contains JSON version data for requirement documents. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idItem | Yes | NUMERIC(10) | Yes | Part of the unique identifier for a table row. If the original item this version was created from still exists, the value corresponds to the idRecord column in the DOCUMENT table. |
| version | Yes | NUMERIC(10) | Yes | Part of the unique identifer for a table row. Specifies the item version. |
| versionBaseItemID | No | NUMERIC(10) | No | A non-null value that indicates if the data stored in versionDataJson is a JSON patch that needs to be applied to the row identified by this column and versionBaseItemID. |
| versionBaseVersion | No | NUMERIC(10) | No | A non-null value that indicates that the data stored in versionDataJson is a JSON patch that needs to be applied to the row identified by this column and versionBaseVersion. |
| versionDataJson | No | TEXT | Yes | A JSON representation of a version of an item. May be an entire representation or a JSON patch that needs to be applied on top of another version specified by versionBaseItemID and versionBaseVersion. |
| SchemaVersion | No | NUMERIC(10) | Yes | Schema version of the data stored in versionDataJson. |
| hash | No | VARCHAR(1020) | Yes | md5 hash value for the fully-formed version JSON data. |
| Destroyed | No | NUMERIC(1) | Yes | Boolean that indicates if the item version is marked to be destroyed. |
Table: VERSION_DOC_ATTACHMT
| Note | Contains file attachment version data for requirement documents. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. If the original item that this version was created from still exists, the value corresponds to the idRecord column in the ATTACHMT table. |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| EntityRID | Yes | NUMERIC(10) | Yes | Part of the identifier information for the parent item in the VERSION_DOC table. |
| idItemVersion | Yes | NUMERIC(10) | Yes | Part of the identifier information for the parent item in the VERSION_DOC table. |
| AttType | No | NUMERIC(1) | No | File attachment type; includes the following values: 1 (Mac binary file), 2 (other file type) |
| FileName | No | VARCHAR(800) | No | Original file name before it was attached to an item. |
| MacType | No | NUMERIC(10) | No | Mac type. Only valid for Mac. |
| MacCreator | No | NUMERIC(10) | No | Mac creator. Only valid for Mac. |
| dateCreate | No | TIMESTAMP | No | Date/time the file was created. |
| dateModify | No | TIMESTAMP | No | Date/time the file was last modified. |
| FileSize | No | NUMERIC(10) | No | File size |
| ArchvFile | No | VARCHAR(96) | Yes | Attachment filename in the project's attachment archive, which may be the project's Attach directory or the ATTARCHIVE database table. |
| Compressed | No | NUMERIC(1) | No | Reserved for future use |
| AttachInDB | No | NUMERIC(1) | No | Flag that indicates if the archive file contents are stored in database. Only valid for RDBMS. |
| FieldID | No | NUMERIC(10) | No | Field ID for the field that the image is in. Only for inline images in multi-line text fields. |
| ImgWidth | No | NUMERIC(5) | No | Width of original image when added inline to a multi-line text field. |
| ImgHeight | No | NUMERIC(5) | No | Height of original image when added inline to a multi-line text field. |
Table: VERSION_FLDR
| Note | Contains JSON version data for folders. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idItem | Yes | NUMERIC(10) | Yes | Part of the unique identifier for a table row. If the original item this version was created from still exists, the value corresponds to the idRecord column in the FOLDER table. |
| version | Yes | NUMERIC(10) | Yes | Part of the unique identifer for a table row. Specifies the item version. |
| versionBaseItemID | No | NUMERIC(10) | No | A non-null value that indicates if the data stored in versionDataJson is a JSON patch that needs to be applied to the row identified by this column and versionBaseItemID. |
| versionBaseVersion | No | NUMERIC(10) | No | A non-null value that indicates that the data stored in versionDataJson is a JSON patch that needs to be applied to the row identified by this column and versionBaseVersion. |
| versionDataJson | No | TEXT | Yes | A JSON representation of a version of an item. May be an entire representation or a JSON patch that needs to be applied on top of another version specified by versionBaseItemID and versionBaseVersion. |
| SchemaVersion | No | NUMERIC(10) | Yes | Schema version of the data stored in versionDataJson. |
| hash | No | VARCHAR(1020) | Yes | md5 hash value for the fully-formed version JSON data. |
| Destroyed | No | NUMERIC(1) | Yes | Boolean that indicates if the item version is marked to be destroyed. |
Table: VERSION_FLDR_ATTACHMT
| Note | Contains file attachment version data for folders. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. If the original item that this version was created from still exists, the value corresponds to the idRecord column in the ATTACHMT table. |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| EntityRID | Yes | NUMERIC(10) | Yes | Part of the identifier information for the parent item in the VERSION_FLDR table. |
| idItemVersion | Yes | NUMERIC(10) | Yes | Part of the identifier information for the parent item in the VERSION_FLDR table. |
| AttType | No | NUMERIC(1) | No | File attachment type; includes the following values: 1 (Mac binary file), 2 (other file type) |
| FileName | No | VARCHAR(800) | No | Original file name before it was attached to an item. |
| MacType | No | NUMERIC(10) | No | Mac type. Only valid for Mac. |
| MacCreator | No | NUMERIC(10) | No | Mac creator. Only valid for Mac. |
| dateCreate | No | TIMESTAMP | No | Date/time the file was created. |
| dateModify | No | TIMESTAMP | No | Date/time the file was last modifie |
| FileSize | No | NUMERIC(10) | No | File size |
| ArchvFile | No | VARCHAR(96) | Yes | Attachment filename in the project's attachment archive, which may be the project's Attach directory or the ATTARCHIVE database table. |
| Compressed | No | NUMERIC(1) | No | Reserved for future use |
| AttachInDB | No | NUMERIC(1) | No | Flag that indicates if the archive file contents are stored in database. Only valid for RDBMS. |
| FieldID | No | NUMERIC(10) | No | Field ID for the field that the image is in. Only for inline images in multi-line text fields. |
| ImgWidth | No | NUMERIC(5) | No | Width of original image when added inline to a multi-line text field. |
| ImgHeight | No | NUMERIC(5) | No | Height of original image when added inline to a multi-line text field.image. |
Table: VERSION_ISSUE
| Note | Contains JSON version data for issues. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idItem | Yes | NUMERIC(10) | Yes | Part of the unique identifier for a table row. If the original item this version was created from still exists, the value corresponds to the idRecord column in the DEFECT table. |
| version | Yes | NUMERIC(10) | Yes | Part of the unique identifer for a table row. Specifies the item version. |
| versionBaseItemID | No | NUMERIC(10) | No | A non-null value that indicates if the data stored in versionDataJson is a JSON patch that needs to be applied to the row identified by this column and versionBaseItemID. |
| versionBaseVersion | No | NUMERIC(10) | No | A non-null value that indicates that the data stored in versionDataJson is a JSON patch that needs to be applied to the row identified by this column and versionBaseVersion. |
| versionDataJson | No | TEXT | Yes | A JSON representation of a version of an item. May be an entire representation or a JSON patch that needs to be applied on top of another version specified by versionBaseItemID and versionBaseVersion. |
| SchemaVersion | No | NUMERIC(10) | Yes | Schema version of the data stored in versionDataJson. |
| hash | No | VARCHAR(1020) | Yes | md5 hash value for the fully-formed version JSON data. |
| Destroyed | No | NUMERIC(1) | Yes | Boolean that indicates if the item version is marked to be destroyed. |
Table: VERSION_ISSUE_ATTACHMT
| Note | Contains file attachment version data for issues. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. If the original item that this version was created from still exists, the value corresponds to the idRecord column in the ATTACHMT table. |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| EntityRID | Yes | NUMERIC(10) | Yes | Part of the identifier information for the parent item in the VERSION_ISSUE table. |
| idItemVersion | Yes | NUMERIC(10) | Yes | Part of the identifier information for the parent item in the VERSION_ISSUE table. |
| AttType | No | NUMERIC(1) | No | File attachment type; includes the following values: 1 (Mac binary file), 2 (other file type) |
| FileName | No | VARCHAR(800) | No | Original file name before it was attached to an item. |
| MacType | No | NUMERIC(10) | No | Mac type. Only valid for Mac. |
| MacCreator | No | NUMERIC(10) | No | Mac creator. Only valid for Mac. |
| dateCreate | No | TIMESTAMP | No | Date/time the file was created. |
| dateModify | No | TIMESTAMP | No | Date/time the file was last modified. |
| FileSize | No | NUMERIC(10) | No | File size |
| ArchvFile | No | VARCHAR(96) | Yes | Attachment filename in the project's attachment archive, which may be the project's Attach directory or the ATTARCHIVE database table. |
| Compressed | No | NUMERIC(1) | No | Reserved for future use |
| AttachInDB | No | NUMERIC(1) | No | Flag that indicates if the archive file contents are stored in database. Only valid for RDBMS. |
| FieldID | No | NUMERIC(10) | No | Field ID for the field that the image is in. Only for inline images in multi-line text fields. |
| ImgWidth | No | NUMERIC(5) | No | Width of original image when added inline to a multi-line text field. |
| ImgHeight | No | NUMERIC(5) | No | Height of original image when added inline to a multi-line text field. |
Table: VERSION_REQ
| Note | Contains JSON version data for requirements. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idItem | Yes | NUMERIC(10) | Yes | Part of the unique identifier for a table row. If the original item this version was created from still exists, the value corresponds to the idRecord column in the REQMNT table. |
| version | Yes | NUMERIC(10) | Yes | Part of the unique identifer for a table row. Specifies the item version. |
| versionBaseItemID | No | NUMERIC(10) | No | A non-null value that indicates if the data stored in versionDataJson is a JSON patch that needs to be applied to the row identified by this column and versionBaseItemID. |
| versionBaseVersion | No | NUMERIC(10) | No | A non-null value indicates that the data stored in versionDataJson is a JSON patch that need to be applied to the row identified by this column and versionBaseVersion. |
| versionDataJson | No | TEXT | Yes | A JSON representation of a version of an item. May be an entire representation or a JSON patch that needs to be applied on top of another version specified by versionBaseItemID and versionBaseVersio |
| SchemaVersion | No | NUMERIC(10) | Yes | Schema version of the data stored in versionDataJson. |
| hash | No | VARCHAR(1020) | Yes | md5 hash value for the fully-formed version JSON data. |
| Destroyed | No | NUMERIC(1) | Yes | Boolean that indicates if the item version is marked to be destroyed. |
Table: VERSION_REQ_ATTACHMT
| Note | Contains file attachment version data for requirements. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. If the original item that this version was created from still exists, the value corresponds to the idRecord column in the ATTACHMT table. |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| EntityRID | Yes | NUMERIC(10) | Yes | Part of the identifier information for the parent item in the VERSION_REQ table. |
| idItemVersion | Yes | NUMERIC(10) | Yes | Part of the identifier information for the parent item in the VERSION_REQ table. |
| AttType | No | NUMERIC(1) | No | File attachment type; includes the following values: 1 (Mac binary file), 2 (other file type) |
| FileName | No | VARCHAR(800) | No | Original file name before it was attached to an item. |
| MacType | No | NUMERIC(10) | No | Mac type. Only valid for Mac. |
| MacCreator | No | NUMERIC(10) | No | Mac creator. Only valid for Mac. |
| dateCreate | No | TIMESTAMP | No | Date/time the file was created. |
| dateModify | No | TIMESTAMP | No | Date/time the file was last modified. |
| FileSize | No | NUMERIC(10) | No | File size |
| ArchvFile | No | VARCHAR(96) | Yes | Attachment filename in the project's attachment archive, which may be the project's Attach directory or the ATTARCHIVE database table. |
| Compressed | No | NUMERIC(1) | No | Reserved for future use |
| AttachInDB | No | NUMERIC(1) | No | Flag that indicates if the archive file contents are stored in database. Only valid for RDBMS. |
| FieldID | No | NUMERIC(10) | No | Field ID for the field that the image is in. Only for inline images in multi-line text fields. |
| ImgWidth | No | NUMERIC(5) | No | Width of original image when added inline to a multi-line text field. |
| ImgHeight | No | NUMERIC(5) | No | Height of original image when added inline to a multi-line text field. |
Table: VERSION_TC
| Note | Contains JSON version data for test cases. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idItem | Yes | NUMERIC(10) | Yes | Part of the unique identifier for a table row. If the original item this version was created from still exists, the value corresponds to the idRecord column in the TESTCASE table. |
| version | Yes | NUMERIC(10) | Yes | Part of the unique identifer for a table row. Specifies the item version. |
| versionBaseItemID | No | NUMERIC(10) | No | A non-null value that indicates if the data stored in versionDataJson is a JSON patch that needs to be applied to the row identified by this column and versionBaseItemID. |
| versionBaseVersion | No | NUMERIC(10) | No | A non-null value that indicates that the data stored in versionDataJson is a JSON patch that needs to be applied to the row identified by this column and versionBaseVersion. |
| versionDataJson | No | TEXT | Yes | A JSON representation of a version of an item. May be an entire representation or a JSON patch that needs to be applied on top of another version specified by versionBaseItemID and versionBaseVersion. |
| SchemaVersion | No | NUMERIC(10) | Yes | Schema version of the data stored in versionDataJson. |
| hash | No | VARCHAR(1020) | Yes | d5 hash value for the fully-formed version JSON data. |
| Destroyed | No | NUMERIC(1) | Yes | Boolean that indicates if the item version is marked to be destroyed. |
Table: VERSION_TC_ATTACHMT
| Note | Contains file attachment version data for test cases. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. If the original item that this version was created from still exists, the value corresponds to the idRecord column in the ATTACHMT table. |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| EntityRID | Yes | NUMERIC(10) | Yes | Part of the identifier information for the parent item in the VERSION_TC table. |
| idItemVersion | Yes | NUMERIC(10) | Yes | Part of the identifier information for the parent item in the VERSION_TC table. |
| AttType | No | NUMERIC(1) | No | File attachment type; includes the following values: 1 (Mac binary file), 2 (other file type) |
| FileName | No | VARCHAR(800) | No | Original file name before it was attached to an item. |
| MacType | No | NUMERIC(10) | No | Mac type. Only valid for Mac. |
| MacCreator | No | NUMERIC(10) | No | Mac creator. Only valid for Mac. |
| dateCreate | No | TIMESTAMP | No | Date/time the file was created. |
| dateModify | No | TIMESTAMP | No | Date/time the file was last modified. |
| FileSize | No | NUMERIC(10) | No | File size |
| ArchvFile | No | VARCHAR(96) | Yes | Attachment filename in the project's attachment archive, which may be the project's Attach directory or the ATTARCHIVE database table. |
| Compressed | No | NUMERIC(1) | No | Reserved for future use |
| AttachInDB | No | NUMERIC(1) | No | Flag that indicates if the archive file contents are stored in database. Only valid for RDBMS. |
| FieldID | No | NUMERIC(10) | No | Field ID for the field that the image is in. Only for inline images in multi-line text fields. |
| ImgWidth | No | NUMERIC(5) | No | Width of original image when added inline to a multi-line text field. |
| ImgHeight | No | NUMERIC(5) | No | Height of original image when added inline to a multi-line text field. |
Table: VERSION_TR
| Note | Contains JSON version data for test runs. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| idItem | Yes | NUMERIC(10) | Yes | Part of the unique identifier for a table row. If the original item this version was created from still exists, the value corresponds to the idRecord column in the TESTRUN table. |
| version | Yes | NUMERIC(10) | Yes | Part of the unique identifer for a table row. Specifies the item version. |
| versionBaseItemID | No | NUMERIC(10) | No | A non-null value that indicates if the data stored in versionDataJson is a JSON patch that needs to be applied to the row identified by this column and versionBaseItemID. |
| versionBaseVersion | No | NUMERIC(10) | No | A non-null value that indicates that the data stored in versionDataJson is a JSON patch that needs to be applied to the row identified by this column and versionBaseVersion. |
| versionDataJson | No | TEXT | Yes | A JSON representation of a version of an item. May be an entire representation or a JSON patch that needs to be applied on top of another version specified by versionBaseItemID and versionBas |
| SchemaVersion | No | NUMERIC(10) | Yes | Schema version of the data stored in versionDataJson. |
| hash | No | VARCHAR(1020) | Yes | md5 hash value for the fully-formed version JSON data. |
| Destroyed | No | NUMERIC(1) | Yes | Boolean that indicates if the item version is marked to be destroyed. |
Table: VERSION_TR_ATTACHMT
| Note | Contains file attachment version data for test runs. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. If the original item that this version was created from still exists, the value corresponds to the idRecord column in the ATTACHMT table. |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project |
| EntityRID | Yes | NUMERIC(10) | Yes | Part of the identifier information for the parent item in the VERSION_TR table. |
| idItemVersion | Yes | NUMERIC(10) | Yes | Part of the identifier information for the parent item in the VERSION_TR table. |
| AttType | No | NUMERIC(1) | No | File attachment type; includes the following values: 1 (Mac binary file), 2 (other file type) |
| FileName | No | VARCHAR(800) | No | Original file name before it was attached to an item. |
| MacType | No | NUMERIC(10) | No | Mac type. Only valid for Mac.. |
| MacCreator | No | NUMERIC(10) | No | Mac creator. Only valid for Mac. |
| dateCreate | No | TIMESTAMP | No | File creation date |
| dateModify | No | TIMESTAMP | No | File modification date |
| FileSize | No | NUMERIC(10) | No | File size |
| ArchvFile | No | VARCHAR(96) | Yes | Attachment filename in the project's attachment archive, which may be the project's Attach directory or the ATTARCHIVE database table. |
| Compressed | No | NUMERIC(1) | No | Reserved for future use |
| AttachInDB | No | NUMERIC(1) | No | Flag indicates if archive file contents are stored in database (valid for RDBMS only) |
| FieldID | No | NUMERIC(10) | No | Contains field id of field containing image for WYSIWYG inline images. |
| ImgWidth | No | NUMERIC(5) | No | Width of original image added as inline WYSIWYG image. |
| ImgHeight | No | NUMERIC(5) | No | Height of original image added as inline WYSIWYG image. |
Table: VIEWCOLINFO
| Note | Contains user-defined saved tab/view column information. Each table row represents one column in a saved tab/view. This table has a many-to-one relationship with the VIEWINFO table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| VIEWID | No | NUMERIC(10) | No | Link to a record ID in VIEWINFO table. |
| VIEWTYPE | No | NUMERIC(5) | No | View type; includes the following values:
0 (list window tab)
1 (user-definedview) |
| ENTITYTYPE | No | NUMERIC(10) | No | Entity type the view is associated with. |
| FIELDID | No | NUMERIC(10) | No | Field displayed in column, links to a record in FLDDFNTN table. |
| COLORDER | No | NUMERIC(5) | No | Order of column, relative to other columns. |
| WIDTH | No | NUMERIC(5) | No | Column width. |
Table: VIEWINFO
| Note | Contains user-defined saved tab/view information. Each table row represents one saved tab/view. This table has a one-to-many relationship with the VIEWCOLINFO table. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| PROJECTID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| IDRECORD | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| USERID | No | NUMERIC(10) | No | Link to a record in USERS table. |
| ENTITYTYPE | No | NUMERIC(10) | No | Entity type the view is associated with. |
| NAME | No | VARCHAR(512) | No | Tab/View name. |
| PRISORT | No | NUMERIC(10) | No | Primary sort field ID. |
| SECSORT | No | NUMERIC(10) | No | Secondary sort field ID. |
| PRISRTORDR | No | NUMERIC(1) | No | Primary sort column order. |
| SECSRTORDR | No | NUMERIC(1) | No | Secondary sort column order. |
| FILTERID | No | NUMERIC(10) | No | Filter the view uses. |
| SHARESETTING | No | NUMERIC(10) | No | The view's share with setting, possible values include:
0 (No one)
1 (Everyone)
2 (All Users)
3 (All Customers)
4 (Selected Groups)
5 (Published)
6 (Selected Users) |
Table: WATCHEDITEMS
| Note | Contains a list of items watched by users. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | No | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| UserID | No | NUMERIC(10) | Yes | ID of the user watching the item |
| ItemID | No | NUMERIC(10) | Yes | ID of item watched by the user |
| ItemType | No | NUMERIC(10) | Yes | Item type the user is watching |
Table: WEBHOOKITEM
| Note | Contains information about Helix ALM items that need to have webhook data sent to a webhook recipient. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| WebhookRecpID | No | NUMERIC(10) | Yes | Link to a record ID in WEBHOOKRECP table. |
| EntityType | No | NUMERIC(10) | No | Entity type the of item to send webhook data for. |
| EntityID | No | NUMERIC(10) | No | Link to a record ID in the DEFECTS, TESTCASE, TESTRUN, REQMNT, or DOCUMENT table. |
| ChangeType | No | NUMERIC(10) | No | Information about how the item changed. Possible Values are:
0 - chage type not set
1- item was created
2 - item was modified
3 - item was deleted |
| Version | No | NUMERIC(1) | No | Version of the webhook data. |
| DateTimeCreated | No | DATETIME | No | Date the webhook item was created. |
| ItemData | No | NVARCHAR(max) | No | JSON data about the item. |
Table: WEBHOOKQUEUE
| Note | Contains the actual webhook data that will be sent to a webhook recipient and information about failures sending webhook data to the recipient. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| WebhookRecpID | No | NUMERIC(10) | Yes | Link to a record ID in WEBHOOKRECP table. |
| WebHookDetail | No | NVARCHAR(max) | No | JSON data to send to a webhook recipient. |
| Retries | No | NUMERIC(2) | No | Number of times we've attempted to send the webhook unsucessully. |
| Status | No | NUMERIC(10) | No | Contains the HTTP status code from attempt to send webhook to recipient. |
| Version | No | NUMERIC(1) | No | Version of the webhook data. |
| DateTimeCreated | No | DATETIME | No | Date and time the webhook data was created. |
| UUID | No | VARCHAR(38) | No | Unique identifier for the webhook data. |
| LastRetryDate | No | DATETIME | No | Date and time of last attempt to send webhook data. |
| NextRetryDate | No | DATETIME | No | Date and time for next attempt to send webhook data. |
| IsDeadLetter | No | NUMERIC(1) | No | Reserved for future use. Boolean to indicate that webhook data will not be sent due to failures. |
Table: WEBHOOKRECP
| Note | Contains information about webhook recipients. |
Columns:
| Column name | Primary key | Data type | Not NULL | Note |
| ProjectID | Yes | NUMERIC(10) | Yes | Helix ALM project ID, identifies row’s parent project. |
| idRecord | Yes | NUMERIC(10) | Yes | Record ID that uniquely identifies a table row. |
| Name | No | NVARCHAR(64) | Yes | Name of the webhook recipient. |
| Description | No | NVARCHAR(510) | No | Description of the webhook recipient. |
| DestinationURL | No | NVARCHAR(max) | No | The URL of the webhook recipient. |
| Headers | No | NVARCHAR(max) | No | Extra headers to send with webhook data. |
| Version | No | NUMERIC(1) | No | Version of the webhook data to send. |
| Batching | No | NUMERIC(1) | No | Boolean to indicate if the webhook recipient can send combine multiple webhook notifications into a single message. |
| Disabled | No | NUMERIC(10) | No | Boolean to indicate if the webhook recipient is disabled. |
| DisabledMsg | No | NVARCHAR(max) | No | Message indicating why the webhook recipient is disabled. |
| VerifyMethod | No | NUMERIC(10) | No | The webhook secret signature type. Values are:
0 - no signature type.
1 - signature type is SHA256
2 - signature type is SHA512 |
| VerifySecret | No | NVARCHAR(708) | No | The webhook secret value. |
| VerifyMethodSec | No | NUMERIC(10) | No | The webhook secondary secret signature type. Values are:
0 - no signature type.
1 - signature type is SHA256
2 - signature type is SHA512 |
| VerifySecretSec | No | NVARCHAR(708) | No | The webhook secondary secret value. |
| VerifySecretSecExpDate | No | DATETIME | No | The date time at which the secondary secret expires and will no longer be used. |
|