Skip to content

Available Database Tables

How to use this page

SpiraPlan has a number of database views available for creating custom reports using ESQL queries. Below, each available table is listed with all of their exact field names.

Artifact Associations

  • ARTIFACT_LINK_TYPE_ID
  • SOURCE_ARTIFACT_ID
  • SOURCE_ARTIFACT_TYPE_ID
  • DEST_ARTIFACT_ID
  • DEST_ARTIFACT_TYPE_ID
  • CREATOR_ID
  • CREATION_DATE
  • COMMENT
  • SOURCE_ARTIFACT_TYPE_NAME
  • DEST_ARTIFACT_TYPE_NAME
  • CREATOR_NAME
  • ARTIFACT_LINK_TYPE_NAME

Artifact Attachments

  • ARTIFACT_TYPE_ID
  • ARTIFACT_ID
  • ARTIFACT_TYPE_NAME
  • ARTIFACT_NAME
  • COMMENT
  • CREATOR_ID
  • CREATION_DATE
  • CREATOR_NAME
  • ATTACHMENT_ID
  • PROJECT_ID
  • ARTIFACT_STATUS_NAME

Attachments

  • ATTACHMENT_ID
  • ATTACHMENT_TYPE_ID
  • AUTHOR_ID
  • EDITOR_ID
  • FILENAME
  • DESCRIPTION
  • UPLOAD_DATE
  • EDITED_DATE
  • SIZE
  • CURRENT_VERSION
  • PROJECT_ID
  • PROJECT_ATTACHMENT_FOLDER_ID
  • CONCURRENCY_DATE
  • DOCUMENT_STATUS_ID
  • DOCUMENT_TYPE_ID
  • DOCUMENT_STATUS_NAME
  • DOCUMENT_TYPE_NAME
  • TAGS
  • CUST_01
  • CUST_02
  • CUST_03
  • CUST_04
  • CUST_05
  • CUST_06
  • CUST_07
  • CUST_08
  • CUST_09
  • CUST_10
  • CUST_11
  • CUST_12
  • CUST_13
  • CUST_14
  • CUST_15
  • CUST_16
  • CUST_17
  • CUST_18
  • CUST_19
  • CUST_20
  • CUST_21
  • CUST_22
  • CUST_23
  • CUST_24
  • CUST_25
  • CUST_26
  • CUST_27
  • CUST_28
  • CUST_29
  • CUST_30
  • IS_KEY_DOCUMENT
  • DOCUMENT_STATUS_IS_OPEN_STATUS
  • PROJECT_IS_ACTIVE
  • PROJECT_GROUP_ID
  • PROJECT_NAME
  • AUTHOR_NAME
  • EDITOR_NAME
  • ATTACHMENT_TYPE_NAME
  • PROJECT_ATTACHMENT_FOLDER_NAME

Automation Hosts

  • AUTOMATION_HOST_ID
  • PROJECT_ID
  • NAME
  • DESCRIPTION
  • TOKEN
  • LAST_UPDATE_DATE
  • IS_DELETED
  • CUST_01
  • CUST_02
  • CUST_03
  • CUST_04
  • CUST_05
  • CUST_06
  • CUST_07
  • CUST_08
  • CUST_09
  • CUST_10
  • CUST_11
  • CUST_12
  • CUST_13
  • CUST_14
  • CUST_15
  • CUST_16
  • CUST_17
  • CUST_18
  • CUST_19
  • CUST_20
  • CUST_21
  • CUST_22
  • CUST_23
  • CUST_24
  • CUST_25
  • CUST_26
  • CUST_27
  • CUST_28
  • CUST_29
  • CUST_30
  • PROJECT_NAME
  • PROJECT_GROUP_ID
  • IS_ACTIVE
  • IS_ATTACHMENTS
  • CONCURRENCY_DATE
  • LAST_CONTACT_DATE

Baselines

See this KB for some examples of using this custom report table.

  • BASELINE_ID
  • PROJECT_ID
  • CREATOR_USER_ID
  • CHANGESET_ID
  • RELEASE_ID
  • NAME
  • DESCRIPTION
  • IS_ACTIVE
  • IS_APPROVED
  • IS_DELETED
  • CREATION_DATE
  • LAST_UPDATE_DATE
  • CONCURRENCY_DATE
  • BASELINE_CREATOR_LOGIN
  • CHANGESET_CREATOR_ID
  • CHANGESET_CREATOR_LOGIN
  • ARTIFACT_TYPE_ID
  • ARTIFACT_TYPE_NAME
  • CHANGESET_DATE
  • CHANGESET_TYPE_ID
  • CHANGESET_TYPE_NAME

Builds

  • BUILD_ID
  • BUILD_STATUS_ID
  • RELEASE_ID
  • PROJECT_ID
  • NAME
  • DESCRIPTION

Comments

  • ARTIFACT_ID
  • CREATOR_ID
  • COMMENT_TEXT
  • CREATION_DATE
  • CREATOR_NAME
  • ARTIFACT_TYPE_NAME

Components

  • COMPONENT_ID
  • PROJECT_ID
  • NAME
  • IS_DELETED
  • IS_ACTIVE
  • PROJECT_NAME
  • PROJECT_GROUP_ID

Custom Lists

  • CUSTOM_PROPERTY_LIST_ID
  • PROJECT_ID
  • NAME
  • IS_ACTIVE
  • IS_SORTED_ON_VALUE
  • PROJECT_NAME
  • PROJECT_IS_ACTIVE
  • PROJECT_TEMPLATE_ID

Custom List Values

  • CUSTOM_PROPERTY_VALUE_ID
  • CUSTOM_PROPERTY_LIST_ID
  • NAME
  • PROJECT_ID
  • CUSTOM_PROPERTY_LIST_NAME
  • CUSTOM_PROPERTY_LIST_IS_ACTIVE
  • PROJECT_NAME
  • PROJECT_IS_ACTIVE
  • IS_ACTIVE
  • IS_DELETED
  • DEPENDENT_CUSTOM_PROPERTY_LIST_ID
  • PARENT_CUSTOM_PROPERTY_VALUE_ID

Custom Property Definitions

  • CUSTOM_PROPERTY_ID
  • CUSTOM_PROPERTY_TYPE_ID
  • PROJECT_ID
  • ARTIFACT_TYPE_ID
  • NAME
  • PROPERTY_NUMBER
  • IS_DELETED
  • CUSTOM_PROPERTY_LIST_ID
  • LEGACY_NAME
  • PROJECT_NAME
  • PROJECT_IS_ACTIVE
  • ARTIFACT_TYPE_NAME
  • CUSTOM_PROPERTY_TYPE_NAME
  • CUSTOM_PROPERTY_LIST_NAME
  • DEPENDENT_CUSTOM_PROPERTY_ID
  • PROJECT_TEMPLATE_ID

Events

  • EVENT_TYPE_ID
  • EVENT_TIME_UTC
  • EVENT_TIME
  • EVENT_CATEGORY
  • EVENT_SEQUENCE
  • EVENT_OCCURRENCE
  • EVENT_CODE
  • EVENT_DETAIL_CODE
  • MESSAGE
  • APPLICATION_PATH
  • APPLICATION_VIRTUAL_PATH
  • MACHINE_NAME
  • REQUEST_URL
  • EXCEPTION_TYPE
  • DETAILS
  • EVENT_TYPE_NAME

History Change-Sets

  • CHANGESET_ID
  • USER_ID
  • ARTIFACT_TYPE_ID
  • ARTIFACT_ID
  • CHANGE_DATE
  • CHANGETYPE_ID
  • PROJECT_ID
  • REVERT_ID
  • ARTIFACT_DESC
  • CHANGETYPE_NAME
  • USER_NAME
  • ARTIFACT_TYPE_NAME
  • SIGNATURE_HASH
  • MEANING

History Details

  • FIELD_NAME
  • OLD_VALUE
  • FIELD_CAPTION
  • NEW_VALUE
  • OLD_VALUE_INT
  • OLD_VALUE_DATE
  • NEW_VALUE_INT
  • NEW_VALUE_DATE
  • CHANGESET_ID
  • FIELD_ID
  • CUSTOM_PROPERTY_ID
  • ARTIFACT_ID
  • USER_ID
  • ARTIFACT_TYPE_ID
  • CHANGE_DATE
  • CHANGER_NAME
  • CHANGE_NAME
  • CHANGETYPE_ID

Incidents

  • INCIDENT_ID
  • PROJECT_ID
  • PRIORITY_ID
  • SEVERITY_ID
  • INCIDENT_STATUS_ID
  • INCIDENT_TYPE_ID
  • OPENER_ID
  • OWNER_ID
  • DESCRIPTION
  • CREATION_DATE
  • CLOSED_DATE
  • LAST_UPDATE_DATE
  • DETECTED_RELEASE_ID
  • RESOLVED_RELEASE_ID
  • START_DATE
  • COMPLETION_PERCENT
  • ESTIMATED_EFFORT
  • ACTUAL_EFFORT
  • REMAINING_EFFORT
  • PROJECTED_EFFORT
  • IS_DELETED
  • VERIFIED_RELEASE_ID
  • PRIORITY_NAME
  • PRIORITY_COLOR
  • SEVERITY_NAME
  • SEVERITY_COLOR
  • INCIDENT_STATUS_NAME
  • INCIDENT_TYPE_NAME
  • OPENER_NAME
  • OWNER_NAME
  • DETECTED_RELEASE_VERSION_NUMBER
  • RESOLVED_RELEASE_VERSION_NUMBER
  • VERIFIED_RELEASE_VERSION_NUMBER
  • PROJECT_GROUP_ID
  • PROJECT_NAME
  • CUST_01
  • CUST_02
  • CUST_03
  • CUST_04
  • CUST_05
  • CUST_06
  • CUST_07
  • CUST_08
  • CUST_09
  • CUST_10
  • CUST_11
  • CUST_12
  • CUST_13
  • CUST_14
  • CUST_15
  • CUST_16
  • CUST_17
  • CUST_18
  • CUST_19
  • CUST_20
  • CUST_21
  • CUST_22
  • CUST_23
  • CUST_24
  • CUST_25
  • CUST_26
  • CUST_27
  • CUST_28
  • CUST_29
  • CUST_30
  • NAME
  • IS_ATTACHMENTS
  • COMPONENT_IDS
  • INCIDENT_STATUS_IS_OPEN_STATUS
  • PROJECT_IS_ACTIVE
  • INCIDENT_TYPE_IS_ISSUE
  • INCIDENT_TYPE_IS_RISK
  • CONCURRENCY_DATE
  • RANK
  • END_DATE
  • DETECTED_BUILD_ID
  • RESOLVED_BUILD_ID
  • DETECTED_BUILD_NAME
  • RESOLVED_BUILD_NAME

Projects (Products)

  • PROJECT_ID
  • PROJECT_GROUP_ID
  • NAME
  • DESCRIPTION
  • CREATION_DATE
  • WEBSITE
  • WORKING_HOURS
  • WORKING_DAYS
  • NON_WORKING_HOURS
  • TASK_DEFAULT_EFFORT
  • PROJECT_GROUP_NAME
  • PROJECT_GROUP_DESCRIPTION
  • IS_ACTIVE
  • IS_TIME_TRACK_INCIDENTS
  • IS_TIME_TRACK_TASKS
  • IS_EFFORT_INCIDENTS
  • IS_EFFORT_TASKS
  • IS_TASKS_AUTO_CREATE
  • REQ_DEFAULT_ESTIMATE
  • REQ_POINT_EFFORT
  • IS_REQ_STATUS_BY_TASKS
  • IS_REQ_STATUS_BY_TEST_CASES
  • IS_EFFORT_TEST_CASES
  • IS_REQ_STATUS_AUTO_PLANNED
  • PROJECT_TEMPLATE_ID
  • START_DATE
  • END_DATE
  • PERCENT_COMPLETE
  • REQUIREMENT_COUNT

Project Groups (Programs)

  • PROJECT_GROUP_ID
  • NAME
  • DESCRIPTION
  • WEBSITE
  • PROJECT_TEMPLATE_ID
  • IS_ACTIVE
  • IS_DEFAULT
  • PERCENT_COMPLETE
  • START_DATE
  • END_DATE
  • PORTFOLIO_ID
  • REQUIREMENT_COUNT

Project Release Resources

  • PROJECT_ID
  • USER_ID
  • RELEASE_ID
  • INCIDENT_EFFORT
  • TASK_EFFORT

Releases

  • RELEASE_ID
  • PROJECT_ID
  • CREATOR_ID
  • NAME
  • VERSION_NUMBER
  • DESCRIPTION
  • INDENT_LEVEL
  • CREATION_DATE
  • LAST_UPDATE_DATE
  • START_DATE
  • END_DATE
  • RESOURCE_COUNT
  • DAYS_NON_WORKING
  • PLANNED_EFFORT
  • AVAILABLE_EFFORT
  • COUNT_BLOCKED
  • COUNT_CAUTION
  • COUNT_FAILED
  • COUNT_NOT_APPLICABLE
  • COUNT_NOT_RUN
  • COUNT_PASSED
  • TASK_COUNT
  • TASK_PERCENT_ON_TIME
  • TASK_PERCENT_LATE_FINISH
  • TASK_PERCENT_NOT_START
  • TASK_PERCENT_LATE_START
  • TASK_ESTIMATED_EFFORT
  • TASK_ACTUAL_EFFORT
  • TASK_PROJECTED_EFFORT
  • TASK_REMAINING_EFFORT
  • IS_DELETED
  • CREATOR_NAME
  • FULL_NAME
  • PROJECT_NAME
  • PROJECT_GROUP_ID
  • CUST_01
  • CUST_02
  • CUST_03
  • CUST_04
  • CUST_05
  • CUST_06
  • CUST_07
  • CUST_08
  • CUST_09
  • CUST_10
  • CUST_11
  • CUST_12
  • CUST_13
  • CUST_14
  • CUST_15
  • CUST_16
  • CUST_17
  • CUST_18
  • CUST_19
  • CUST_20
  • CUST_21
  • CUST_22
  • CUST_23
  • CUST_24
  • CUST_25
  • CUST_26
  • CUST_27
  • CUST_28
  • CUST_29
  • CUST_30
  • RELEASE_TYPE_ID
  • RELEASE_STATUS_ID
  • OWNER_ID
  • IS_SUMMARY
  • IS_ATTACHMENTS
  • OWNER_NAME
  • RELEASE_TYPE_NAME
  • RELEASE_STATUS_NAME
  • CONCURRENCY_DATE
  • MILESTONE_ID
  • PERCENT_COMPLETE
  • PLANNED_POINTS
  • REQUIREMENT_POINTS
  • REQUIREMENT_COUNT

Release Test Case Mapping

  • RELEASE_ID
  • TEST_CASE_ID
  • RELEASE_NAME
  • RELEASE_VERSION_NUMBER
  • TEST_CASE_NAME
  • PROJECT_ID
  • PROJECT_NAME
  • RELEASE_TYPE_ID
  • RELEASE_TYPE_NAME
  • EXECUTION_STATUS_ID
  • EXECUTION_DATE
  • ACTUAL_DURATION

Requirements

  • REQUIREMENT_ID
  • AUTHOR_ID
  • OWNER_ID
  • RELEASE_ID
  • PROJECT_ID
  • IMPORTANCE_ID
  • NAME
  • CREATION_DATE
  • INDENT_LEVEL
  • DESCRIPTION
  • LAST_UPDATE_DATE
  • COVERAGE_COUNT_TOTAL
  • COVERAGE_COUNT_PASSED
  • COVERAGE_COUNT_FAILED
  • COVERAGE_COUNT_CAUTION
  • COVERAGE_COUNT_BLOCKED
  • TASK_COUNT
  • TASK_ESTIMATED_EFFORT
  • TASK_ACTUAL_EFFORT
  • TASK_PROJECTED_EFFORT
  • TASK_REMAINING_EFFORT
  • TASK_PERCENT_ON_TIME
  • TASK_PERCENT_LATE_FINISH
  • TASK_PERCENT_NOT_START
  • TASK_PERCENT_LATE_START
  • IS_DELETED
  • AUTHOR_NAME
  • OWNER_NAME
  • IMPORTANCE_NAME
  • RELEASE_VERSION_NUMBER
  • PROJECT_NAME
  • PROJECT_GROUP_ID
  • CUST_01
  • CUST_02
  • CUST_03
  • CUST_04
  • CUST_05
  • CUST_06
  • CUST_07
  • CUST_08
  • CUST_09
  • CUST_10
  • CUST_11
  • CUST_12
  • CUST_13
  • CUST_14
  • CUST_15
  • CUST_16
  • CUST_17
  • CUST_18
  • CUST_19
  • CUST_20
  • CUST_21
  • CUST_22
  • CUST_23
  • CUST_24
  • CUST_25
  • CUST_26
  • CUST_27
  • CUST_28
  • CUST_29
  • CUST_30
  • REQUIREMENT_TYPE_ID
  • REQUIREMENT_STATUS_ID
  • COMPONENT_ID
  • IS_SUMMARY
  • IS_ATTACHMENTS
  • CONCURRENCY_DATE
  • REQUIREMENT_STATUS_NAME
  • REQUIREMENT_TYPE_NAME
  • COMPONENT_NAME
  • ESTIMATE_POINTS
  • ESTIMATED_EFFORT
  • RANK
  • THEME_ID
  • GOAL_ID
  • START_DATE
  • END_DATE
  • PERCENT_COMPLETE

Requirement Incidents

  • INCIDENT_ID
  • DETECTED_RELEASE_ID
  • IS_OPEN_STATUS

Requirement Steps

  • REQUIREMENT_ID
  • POSITION
  • DESCRIPTION
  • IS_DELETED
  • CREATION_DATE
  • LAST_UPDATE_DATE
  • CONCURRENCY_DATE
  • REQUIREMENT_NAME
  • REQUIREMENT_LAST_UPDATE_DATE
  • PROJECT_IS_ACTIVE
  • PROJECT_PROJECT_GROUP_ID
  • PROJECT_NAME

Requirement Test Case Coverage

  • REQUIREMENT_ID
  • TEST_CASE_ID
  • REQUIREMENT_NAME
  • TEST_CASE_NAME
  • PROJECT_ID
  • PROJECT_NAME

Requirement Test Step Coverage

  • TEST_STEP_ID
  • REQUIREMENT_NAME
  • POSITION
  • STEP_DESCRIPTION
  • EXPECTED_RESULT
  • SAMPLE_DATA
  • PROJECT_ID
  • PROJECT_NAME

Risks

  • RISK_ID
  • RISK_IMPACT_ID
  • RISK_STATUS_ID
  • RISK_PROBABILITY_ID
  • RISK_TYPE_ID
  • PROJECT_ID
  • CREATOR_ID
  • OWNER_ID
  • PROJECT_GROUP_ID
  • RELEASE_ID
  • COMPONENT_ID
  • NAME
  • DESCRIPTION
  • IS_DELETED
  • CREATION_DATE
  • LAST_UPDATE_DATE
  • CONCURRENCY_DATE
  • REVIEW_DATE
  • GOAL_ID
  • CLOSED_DATE
  • IS_ATTACHMENTS
  • RISK_PROBABILITY_NAME
  • RISK_PROBABILITY_COLOR
  • RISK_PROBABILITY_SCORE
  • RISK_IMPACT_NAME
  • RISK_IMPACT_COLOR
  • RISK_IMPACT_SCORE
  • RISK_EXPOSURE
  • RISK_STATUS_NAME
  • RISK_STATUS_IS_OPEN
  • RISK_TYPE_NAME
  • CREATOR_NAME
  • OWNER_NAME
  • RELEASE_VERSION_NUMBER
  • RELEASE_NAME
  • COMPONENT_NAME
  • GOAL_NAME
  • PROJECT_IS_ACTIVE
  • PROJECT_PROJECT_GROUP_ID
  • PROJECT_NAME
  • CUST_01
  • CUST_02
  • CUST_03
  • CUST_04
  • CUST_05
  • CUST_06
  • CUST_07
  • CUST_08
  • CUST_09
  • CUST_10
  • CUST_11
  • CUST_12
  • CUST_13
  • CUST_14
  • CUST_15
  • CUST_16
  • CUST_17
  • CUST_18
  • CUST_19
  • CUST_20
  • CUST_21
  • CUST_22
  • CUST_23
  • CUST_24
  • CUST_25
  • CUST_26
  • CUST_27
  • CUST_28
  • CUST_29
  • CUST_30

Risk Mitigations

  • RISK_ID
  • POSITION
  • DESCRIPTION
  • IS_DELETED
  • CREATION_DATE
  • LAST_UPDATE_DATE
  • CONCURRENCY_DATE
  • IS_ACTIVE
  • REVIEW_DATE
  • RISK_NAME
  • RISK_REVIEW_DATE
  • PROJECT_IS_ACTIVE
  • PROJECT_PROJECT_GROUP_ID
  • PROJECT_NAME

Tasks

  • TASK_ID
  • TASK_STATUS_ID
  • PROJECT_ID
  • REQUIREMENT_ID
  • RELEASE_ID
  • CREATOR_ID
  • OWNER_ID
  • TASK_PRIORITY_ID
  • NAME
  • DESCRIPTION
  • CREATION_DATE
  • LAST_UPDATE_DATE
  • START_DATE
  • END_DATE
  • COMPLETION_PERCENT
  • ESTIMATED_EFFORT
  • ACTUAL_EFFORT
  • PROJECTED_EFFORT
  • REMAINING_EFFORT
  • IS_DELETED
  • TASK_STATUS_NAME
  • OWNER_NAME
  • CREATOR_NAME
  • TASK_PRIORITY_NAME
  • PROJECT_NAME
  • PROJECT_GROUP_ID
  • RELEASE_VERSION_NUMBER
  • CUST_01
  • CUST_02
  • CUST_03
  • CUST_04
  • CUST_05
  • CUST_06
  • CUST_07
  • CUST_08
  • CUST_09
  • CUST_10
  • CUST_11
  • CUST_12
  • CUST_13
  • CUST_14
  • CUST_15
  • CUST_16
  • CUST_17
  • CUST_18
  • CUST_19
  • CUST_20
  • CUST_21
  • CUST_22
  • CUST_23
  • CUST_24
  • CUST_25
  • CUST_26
  • CUST_27
  • CUST_28
  • CUST_29
  • CUST_30
  • TASK_TYPE_ID
  • TASK_FOLDER_ID
  • IS_ATTACHMENTS
  • CONCURRENCY_DATE
  • REQUIREMENT_NAME
  • TASK_TYPE_NAME
  • COMPONENT_ID
  • COMPONENT_NAME
  • RISK_ID

Test Cases

  • TEST_CASE_ID
  • EXECUTION_STATUS_ID
  • TEST_CASE_PRIORITY_ID
  • PROJECT_ID
  • AUTHOR_ID
  • NAME
  • OWNER_ID
  • DESCRIPTION
  • EXECUTION_DATE
  • CREATION_DATE
  • LAST_UPDATE_DATE
  • AUTOMATION_ENGINE_ID
  • AUTOMATION_ATTACHMENT_ID
  • ESTIMATED_DURATION
  • IS_DELETED
  • EXECUTION_STATUS_NAME
  • TEST_CASE_PRIORITY_NAME
  • AUTHOR_NAME
  • OWNER_NAME
  • AUTOMATION_ENGINE_NAME
  • PROJECT_NAME
  • PROJECT_GROUP_ID
  • CUST_01
  • CUST_02
  • CUST_03
  • CUST_04
  • CUST_05
  • CUST_06
  • CUST_07
  • CUST_08
  • CUST_09
  • CUST_10
  • CUST_11
  • CUST_12
  • CUST_13
  • CUST_14
  • CUST_15
  • CUST_16
  • CUST_17
  • CUST_18
  • CUST_19
  • CUST_20
  • CUST_21
  • CUST_22
  • CUST_23
  • CUST_24
  • CUST_25
  • CUST_26
  • CUST_27
  • CUST_28
  • CUST_29
  • CUST_30
  • CONCURRENCY_DATE
  • TEST_CASE_STATUS_ID
  • TEST_CASE_TYPE_ID
  • TEST_CASE_FOLDER_ID
  • IS_ATTACHMENTS
  • IS_TEST_STEPS
  • ACTUAL_DURATION
  • TEST_CASE_STATUS_NAME
  • TEST_CASE_TYPE_NAME
  • COMPONENT_IDS
  • IS_SUSPECT

Test Case Folders

  • TEST_CASE_FOLDER_ID
  • PARENT_TEST_CASE_FOLDER_ID
  • PROJECT_ID
  • NAME
  • DESCRIPTION
  • EXECUTION_DATE
  • LAST_UPDATE_DATE
  • ESTIMATED_DURATION
  • ACTUAL_DURATION
  • COUNT_PASSED
  • COUNT_FAILED
  • COUNT_BLOCKED
  • COUNT_CAUTION
  • COUNT_NOT_RUN
  • COUNT_NOT_APPLICABLE
  • PROJECT_NAME
  • PROJECT_GROUP_ID

Test Case Incidents

  • INCIDENT_ID
  • DETECTED_RELEASE_ID
  • RESOLVED_RELEASE_ID
  • VERIFIED_RELEASE_ID
  • IS_OPEN_STATUS

Test Configuration Entries

  • TEST_CONFIGURATION_SET_ID
  • POSITION
  • TEST_CONFIGURATION_SET_NAME
  • IS_TEST_CONFIGURATION_SET_ACTIVE
  • CUSTOM_PROPERTY_VALUE_ID
  • TEST_CASE_PARAMETER_NAME
  • TEST_CASE_PARAMETER_VALUE
  • PROJECT_NAME
  • PROJECT_GROUP_ID

Test Configuration Sets

  • TEST_CONFIGURATION_SET_ID
  • PROJECT_ID
  • NAME
  • DESCRIPTION
  • IS_ACTIVE
  • IS_DELETED
  • CREATION_DATE
  • LAST_UPDATED_DATE
  • CONCURRENCY_DATE
  • PROJECT_NAME
  • PROJECT_GROUP_ID

Test Runs

  • TEST_RUN_ID
  • TEST_CASE_ID
  • NAME
  • DESCRIPTION
  • ESTIMATED_DURATION
  • ACTUAL_DURATION
  • TEST_RUN_TYPE_ID
  • TESTER_ID
  • EXECUTION_STATUS_ID
  • START_DATE
  • END_DATE
  • RUNNER_NAME
  • RUNNER_TEST_NAME
  • RUNNER_ASSERT_COUNT
  • RUNNER_MESSAGE
  • RUNNER_STACK_TRACE
  • EXECUTION_STATUS_NAME
  • TESTER_NAME
  • TEST_RUNS_PENDING_ID
  • RELEASE_ID
  • TEST_SET_ID
  • TEST_SET_TEST_CASE_ID
  • RELEASE_NAME
  • RELEASE_VERSION_NUMBER
  • TEST_SET_NAME
  • TEST_RUN_TYPE_NAME
  • AUTOMATION_HOST_ID
  • AUTOMATION_HOST_NAME
  • AUTOMATION_ENGINE_ID
  • BUILD_ID
  • BUILD_NAME
  • TEST_RUN_FORMAT_ID
  • PROJECT_NAME
  • PROJECT_GROUP_ID
  • CUST_01
  • CUST_02
  • CUST_03
  • CUST_04
  • CUST_05
  • CUST_06
  • CUST_07
  • CUST_08
  • CUST_09
  • CUST_10
  • CUST_11
  • CUST_12
  • CUST_13
  • CUST_14
  • CUST_15
  • CUST_16
  • CUST_17
  • CUST_18
  • CUST_19
  • CUST_20
  • CUST_21
  • CUST_22
  • CUST_23
  • CUST_24
  • CUST_25
  • CUST_26
  • CUST_27
  • CUST_28
  • CUST_29
  • CUST_30
  • IS_ATTACHMENTS
  • IS_DELETED
  • CONCURRENCY_DATE
  • PROJECT_ID
  • CHANGESET_ID
  • TEST_CONFIGURATION_ID

Test Run Incidents

  • INCIDENT_ID
  • DETECTED_RELEASE_ID
  • RESOLVED_RELEASE_ID
  • VERIFIED_RELEASE_ID
  • IS_OPEN_STATUS

Test Run Steps

  • TEST_RUN_STEP_ID
  • EXECUTION_STATUS_ID
  • TEST_CASE_ID
  • TEST_STEP_ID
  • TEST_RUN_ID
  • DESCRIPTION
  • POSITION
  • EXPECTED_RESULT
  • SAMPLE_DATA
  • ACTUAL_RESULT
  • EXECUTION_STATUS_NAME
  • TEST_CASE_NAME
  • PROJECT_ID
  • PROJECT_NAME
  • PROJECT_GROUP_ID
  • START_DATE
  • END_DATE
  • ACTUAL_DURATION

Test Sets

  • TEST_SET_ID
  • PROJECT_ID
  • RELEASE_ID
  • TEST_SET_STATUS_ID
  • CREATOR_ID
  • OWNER_ID
  • AUTOMATION_HOST_ID
  • TEST_RUN_TYPE_ID
  • RECURRENCE_ID
  • NAME
  • DESCRIPTION
  • CREATION_DATE
  • PLANNED_DATE
  • LAST_UPDATE_DATE
  • IS_DELETED
  • CONCURRENCY_DATE
  • RELEASE_VERSION_NUMBER
  • PROJECT_NAME
  • TEST_CASE_COUNT
  • TEST_SET_STATUS_NAME
  • CREATOR_NAME
  • OWNER_NAME
  • PROJECT_ACTIVE_YN
  • AUTOMATION_HOST_NAME
  • TEST_RUN_TYPE_NAME
  • RECURRENCE_NAME
  • PROJECT_GROUP_ID
  • CUST_01
  • CUST_02
  • CUST_03
  • CUST_04
  • CUST_05
  • CUST_06
  • CUST_07
  • CUST_08
  • CUST_09
  • CUST_10
  • CUST_11
  • CUST_12
  • CUST_13
  • CUST_14
  • CUST_15
  • CUST_16
  • CUST_17
  • CUST_18
  • CUST_19
  • CUST_20
  • CUST_21
  • CUST_22
  • CUST_23
  • CUST_24
  • CUST_25
  • CUST_26
  • CUST_27
  • CUST_28
  • CUST_29
  • CUST_30
  • TEST_SET_FOLDER_ID
  • IS_ATTACHMENTS
  • BUILD_EXECUTE_TIME_INTERVAL
  • ESTIMATED_DURATION
  • ACTUAL_DURATION
  • COUNT_PASSED
  • COUNT_FAILED
  • COUNT_CAUTION
  • COUNT_BLOCKED
  • COUNT_NOT_RUN
  • COUNT_NOT_APPLICABLE
  • EXECUTION_DATE
  • IS_DYNAMIC
  • DYNAMIC_QUERY
  • IS_AUTO_SCHEDULED
  • TEST_CONFIGURATION_SET_ID

Test Set Folders

  • TEST_SET_FOLDER_ID
  • PROJECT_ID
  • PARENT_TEST_SET_FOLDER_ID
  • NAME
  • DESCRIPTION
  • CREATION_DATE
  • LAST_UPDATE_DATE
  • EXECUTION_DATE
  • ESTIMATED_DURATION
  • ACTUAL_DURATION
  • COUNT_PASSED
  • COUNT_FAILED
  • COUNT_CAUTION
  • COUNT_BLOCKED
  • COUNT_NOT_RUN
  • COUNT_NOT_APPLICABLE
  • PROJECT_NAME
  • PROJECT_GROUP_ID

Test Set Incidents

  • INCIDENT_ID
  • DETECTED_RELEASE_ID
  • RESOLVED_RELEASE_ID
  • VERIFIED_RELEASE_ID
  • IS_OPEN_STATUS

Test Set Test Cases

  • TEST_SET_TEST_CASE_ID
  • TEST_SET_ID
  • TEST_CASE_ID
  • OWNER_ID
  • POSITION
  • TEST_SET_NAME
  • TEST_CASE_NAME
  • OWNER_NAME
  • PROJECT_ID
  • PROJECT_NAME
  • PLANNED_DATE
  • IS_SETUP_TEARDOWN

Test Steps

  • TEST_STEP_ID
  • TEST_CASE_ID
  • EXECUTION_STATUS_ID
  • DESCRIPTION
  • LINKED_TEST_CASE_ID
  • POSITION
  • EXPECTED_RESULT
  • SAMPLE_DATA
  • LAST_UPDATE_DATE
  • IS_DELETED
  • EXECUTION_STATUS_NAME
  • TEST_CASE_NAME
  • PROJECT_ID
  • PROJECT_NAME
  • PROJECT_GROUP_ID
  • CUST_01
  • CUST_02
  • CUST_03
  • CUST_04
  • CUST_05
  • CUST_06
  • CUST_07
  • CUST_08
  • CUST_09
  • CUST_10
  • CUST_11
  • CUST_12
  • CUST_13
  • CUST_14
  • CUST_15
  • CUST_16
  • CUST_17
  • CUST_18
  • CUST_19
  • CUST_20
  • CUST_21
  • CUST_22
  • CUST_23
  • CUST_24
  • CUST_25
  • CUST_26
  • CUST_27
  • CUST_28
  • CUST_29
  • CUST_30
  • IS_ATTACHMENTS
  • CONCURRENCY_DATE
  • PRECONDITION

Users

  • USER_NAME
  • EMAIL_ADDRESS
  • IS_ACTIVE
  • CREATION_DATE
  • LDAP_DN
  • FIRST_NAME
  • LAST_NAME
  • MIDDLE_INITIAL
  • DEPARTMENT
  • LAST_UPDATE_DATE
  • TIMEZONE
  • LAST_OPENED_PROJECT_ID
  • IS_APPROVED
  • LAST_LOGIN_DATE
  • LAST_ACTIVITY_DATE