Available Custom Reports Tables
Available in SpiraTest, SpiraTeam, SpiraPlan
How to use this page
Spira 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.
Many tables have a single field shown in italic - these are the Primary Keys for that table, which means that field can be used as the unique identifier for each row of data.
Artifact Associations
| R_ArtifactAssociations |
| 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 Associations - Extended
For normal use we strongly recommend using the standard artifact association view above. This extended view adds the artifact names, which can be very helpful, but will make the reports using it run much slower.
| R_ArtifactAssociationExtended |
| 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 |
| SOURCE_ARTIFACT_NAME |
| DEST_ARTIFACT_NAME |
Artifact Attachments
| R_ArtifactAttachments |
| ARTIFACT_TYPE_ID |
| ARTIFACT_ID |
| ARTIFACT_TYPE_NAME |
| ARTIFACT_NAME |
| COMMENT |
| CREATOR_ID |
| CREATION_DATE |
| CREATOR_NAME |
| ATTACHMENT_ID |
| PROJECT_ID |
| ARTIFACT_STATUS_NAME |
| R_ArtifactTags |
| ARTIFACT_ID |
| ARTIFACT_TYPE_ID |
| TAGS |
| PROJECT_ID |
| PROJECT_NAME |
| ARTIFACT_TYPE_NAME |
Artifact Types
| R_ArtifactTypes |
| ARTIFACT_TYPE_ID |
| NAME |
| PREFIX |
Attachments
| R_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_99 |
| 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 |
Attachment Folders
| R_AttachmentFolders |
| PROJECT_ATTACHMENT_FOLDER_ID |
| PROJECT_ID |
| PARENT_PROJECT_ATTACHMENT_FOLDER_ID |
| NAME |
| PROJECT_NAME |
| PROJECT_GROUP_ID |
Attachment Versions
| R_AttachmentVersions |
| ATTACHMENT_VERSION_ID |
| ATTACHMENT_ID |
| AUTHOR_ID |
| FILENAME |
| DESCRIPTION |
| UPLOAD_DATE |
| SIZE |
| VERSION_NUMBER |
| IS_CURRENT |
| CHANGESET_ID |
| AUTHOR_NAME |
| ATTACHMENT_TYPE_ID |
| PROJECT_ID |
Automation Hosts
| R_AutomationHosts |
| AUTOMATION_HOST_ID |
| PROJECT_ID |
| NAME |
| DESCRIPTION |
| TOKEN |
| LAST_UPDATE_DATE |
| IS_DELETED |
| CUST_01... |
| CUST_99 |
| PROJECT_NAME |
| PROJECT_GROUP_ID |
| IS_ACTIVE |
| IS_ATTACHMENTS |
| CONCURRENCY_DATE |
| LAST_CONTACT_DATE |
Baselines
Available in SpiraTeam and SpiraPlan only
See this KB for some examples of using this custom report table
| R_Baselines |
| 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
Note that BUILD_STATUS_ID can have the following values: 1 = Failed, 2 = Succeeded, 3 = Unstable, 4 = Aborted.
| R_Builds |
| BUILD_ID |
| BUILD_STATUS_ID |
| RELEASE_ID |
| PROJECT_ID |
| NAME |
| DESCRIPTION |
Build Statuses
| R_BuildStatuses |
| BUILD_STATUS_ID |
| NAME |
| IS_ACTIVE |
Capabilities
Available in SpiraPlan only
| R_ProjectGroup_Capabilities |
| CAPABILITY_ID |
| PROJECT_GROUP_ID |
| MILESTONE_ID |
| STATUS_ID |
| TYPE_ID |
| PRIORITY_ID |
| NAME |
| DESCRIPTION |
| IS_DELETED |
| PERCENT_COMPLETE |
| PROJECT_REQUIREMENT_COUNT |
| INDENT_LEVEL |
| CONCURRENCY_GUID |
| CREATOR_ID |
| OWNER_ID |
| CREATION_DATE |
| LAST_UPDATED_DATE |
| IS_SUMMARY |
| STATUS_NAME |
| STATUS_IS_OPEN |
| TYPE_NAME |
| PRIORITY_NAME |
| PRIORITY_COLOR |
| PRIORITY_SCORE |
| MILESTONE_NAME |
| CREATOR_NAME |
| OWNER_NAME |
| PROJECT_GROUP_NAME |
| CUST_01... |
| CUST_30 |
Capability Priorities
Available in SpiraPlan only
| R_ProjectGroup_Capability_Priorities |
| PRIORITY_ID |
| NAME |
| COLOR |
| IS_ACTIVE |
| IS_DELETED |
| SCORE |
Capability Requirement Associations
Available in SpiraPlan only
| R_ProjectGroup_Capability_Project_Requirements |
| CAPABILITY_ID |
| REQUIREMENT_ID |
| ARTIFACT_LINK_TYPE_ID |
| CAPABILITY_NAME |
| REQUIREMENT_NAME |
| ARTIFACT_LINK_TYPE_NAME |
Capability Statuses
Available in SpiraPlan only
| R_ProjectGroup_Capability_Statuses |
| STATUS_ID |
| NAME |
| POSITION |
| IS_ACTIVE |
| IS_DELETED |
| IS_DEFAULT |
| IS_OPEN |
| ON_BOARD |
Capability Types
Available in SpiraPlan only
| R_ProjectGroup_Capability_Types |
| TYPE_ID |
| NAME |
| IS_ACTIVE |
| IS_DELETED |
| IS_DEFAULT |
| R_Comments |
| ARTIFACT_TYPE_ID |
| ARTIFACT_ID |
| CREATOR_ID |
| COMMENT_TEXT |
| CREATION_DATE |
| CREATOR_NAME |
| ARTIFACT_TYPE_NAME |
Components
| R_Components |
| COMPONENT_ID |
| PROJECT_ID |
| NAME |
| IS_DELETED |
| IS_ACTIVE |
| PROJECT_NAME |
| PROJECT_GROUP_ID |
Custom Lists
| R_CustomLists |
| CUSTOM_PROPERTY_LIST_ID |
| PROJECT_ID |
| NAME |
| IS_ACTIVE |
| IS_SORTED_ON_VALUE |
| PROJECT_NAME |
| PROJECT_IS_ACTIVE |
| PROJECT_TEMPLATE_ID |
Custom List Values
| R_CustomListValues |
| 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
| R_CustomPropertyDefinitions |
| 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 |
Document Statuses
| R_DocumentStatuses |
| DOCUMENT_STATUS_ID |
| PROJECT_TEMPLATE_ID |
| NAME |
| POSITION |
| IS_ACTIVE |
| IS_OPEN_STATUS |
| IS_DEFAULT |
| PROJECT_TEMPLATE_NAME |
Document Types
| R_DocumentTypes |
| DOCUMENT_TYPE_ID |
| PROJECT_TEMPLATE_ID |
| DOCUMENT_WORKFLOW_ID |
| NAME |
| DESCRIPTION |
| IS_ACTIVE |
| IS_DEFAULT |
| PROJECT_TEMPLATE_NAME |
Events
| R_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 |
Global / System Custom Property Definitions
| R_GlobalCustomPropertyDefinitions |
| CUSTOM_PROPERTY_ID |
| CUSTOM_PROPERTY_TYPE_ID |
| CUSTOM_PROPERTY_TYPE_NAME |
| WORKSPACE_TYPE_ID |
| WORKSPACE_TYPE_NAME |
| NAME |
| PROPERTY_NUMBER |
| IS_DELETED |
| CUSTOM_PROPERTY_LIST_ID |
| CUSTOM_PROPERTY_LIST_NAME |
| POSITION |
| DESCRIPTION |
Global / System Custom Property Lists
| R_GlobalCustomLists |
| CUSTOM_PROPERTY_LIST_ID |
| NAME |
| IS_ACTIVE |
| IS_SORTED_ON_VALUE |
Global / System Custom Property List Values
| R_GlobalCustomListValues |
| CUSTOM_PROPERTY_VALUE_ID |
| NAME |
| IS_ACTIVE |
| IS_DELETED |
| CUSTOM_PROPERTY_LIST_ID |
| CUSTOM_PROPERTY_LIST_NAME |
| CUSTOM_PROPERTY_LIST_IS_ACTIVE |
Global / System History Change-Sets
| R_Global_HistoryChangeSets |
| CHANGESET_ID |
| USER_ID |
| CHANGE_DATE |
| CHANGETYPE_ID |
| ARTIFACT_TYPE_ID |
| ARTIFACT_ID |
| ARTIFACT_DESC |
| WORKSPACE_TYPE_ID |
| WORKSPACE_ID |
| CHANGETYPE_NAME |
| USER_NAME |
| ARTIFACT_TYPE_NAME |
| WORKSPACE_TYPE_NAME |
Global / System History Details
| R_Global_HistoryDetails |
| ARTIFACT_HISTORY_ID |
| FIELD_NAME |
| OLD_VALUE |
| NEW_VALUE |
| CHANGESET_ID |
| FIELD_TYPE_ID |
| CUSTOM_PROPERTY_ID |
| ARTIFACT_ID |
| USER_ID |
| ARTIFACT_TYPE_ID |
| CHANGE_DATE |
| USER_NAME |
| CHANGE_NAME |
| CHANGETYPE_ID |
| ARTIFACT_FIELD_TYPE_ID |
| ARTIFACT_TYPE_NAME |
History Change-Sets
| R_HistoryChangeSets |
| 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
| R_HistoryDetails |
| 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
| R_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_99 |
| 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 |
| TAGS |
Incident Priorities
| R_IncidentPriorities |
| PRIORITY_ID |
| PROJECT_TEMPLATE_ID |
| NAME |
| COLOR |
| IS_ACTIVE |
| SCORE |
| PROJECT_TEMPLATE_NAME |
Incident Severities
| R_IncidentSeverities |
| SEVERITY_ID |
| PROJECT_TEMPLATE_ID |
| NAME |
| COLOR |
| IS_ACTIVE |
| SCORE |
| PROJECT_TEMPLATE_NAME |
Incident Statuses
| R_IncidentStatuses |
| INCIDENT_STATUS_ID |
| PROJECT_TEMPLATE_ID |
| NAME |
| IS_ACTIVE |
| IS_OPEN_STATUS |
| IS_DEFAULT |
| PROJECT_TEMPLATE_NAME |
Incident Types
| R_IncidentTypes |
| INCIDENT_TYPE_ID |
| PROJECT_TEMPLATE_ID |
| WORKFLOW_ID |
| NAME |
| IS_ACTIVE |
| IS_ISSUE |
| IS_DEFAULT |
| PROJECT_TEMPLATE_NAME |
Pending Test Runs
| R_PendingTestRuns |
| TEST_RUNS_PENDING_ID |
| PROJECT_ID |
| TEST_SET_ID |
| TESTER_ID |
| NAME |
| CREATION_DATE |
| LAST_UPDATE_DATE |
| COUNT_PASSED |
| COUNT_FAILED |
| COUNT_BLOCKED |
| COUNT_CAUTION |
| COUNT_NOT_RUN |
| COUNT_NOT_APPLICABLE |
| TESTER_LOGIN |
| TESTER_FULLNAME |
| TEST_SET_NAME |
| PROJECT_NAME |
Portfolios
Available in SpiraPlan only
| R_Portfolios |
| PORTFOLIO_ID |
| NAME |
| DESCRIPTION |
| IS_ACTIVE |
| START_DATE |
| END_DATE |
| PERCENT_COMPLETE |
| REQUIREMENT_COUNT |
Program Milestones
Available in SpiraPlan only
| R_ProjectGroup_Milestones |
| PROJECT_GROUP_MILESTONE_ID |
| PROJECT_GROUP_ID |
| TYPE_ID |
| STATUS_ID |
| NAME |
| DESCRIPTION |
| IS_DELETED |
| START_DATE |
| END_DATE |
| PERCENT_COMPLETE |
| CHILDREN_START_DATE |
| CHILDREN_END_DATE |
| PROJECT_RELEASE_COUNT |
| PROJECT_GROUP_REQUIREMENT_COUNT |
| CONCURRENCY_GUID |
| CREATOR_ID |
| OWNER_ID |
| CREATION_DATE |
| LAST_UPDATED_DATE |
| STATUS_NAME |
| STATUS_IS_OPEN |
| TYPE_NAME |
| CREATOR_NAME |
| OWNER_NAME |
| PROJECT_GROUP_NAME |
| CUST_01... |
| CUST_30 |
Program Milestone Releases
Available in SpiraPlan only
| R_ProjectGroup_Milestone_Project_Releases |
| PROJECT_GROUP_MILESTONE_ID |
| RELEASE_ID |
| ARTIFACT_LINK_TYPE_ID |
| PROJECT_GROUP_MILESTONE_NAME |
| RELEASE_NAME |
| ARTIFACT_LINK_TYPE_NAME |
Program Milestone Statuses
Available in SpiraPlan only
| R_ProjectGroup_Milestone_Statuses |
| STATUS_ID |
| NAME |
| IS_ACTIVE |
| IS_DELETED |
| IS_DEFAULT |
| IS_OPEN |
Program Milestone Types
Available in SpiraPlan only
| R_ProjectGroup_Milestone_Types |
| TYPE_ID |
| NAME |
| IS_ACTIVE |
| IS_DELETED |
| IS_DEFAULT |
Project Artifacts Sharing
Retrieves data about cross product associations
| R_ProjectArtifactSharings |
| SOURCE_PROJECT_ID |
| DEST_PROJECT_ID |
| ARTIFACT_TYPE_ID |
| SOURCE_PROJECT_NAME |
| DEST_PROJECT_NAME |
| ARTIFACT_TYPE_NAME |
| ARTIFACT_TYPE_PREFIX |
Projects (Products)
| R_Projects |
| 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 |
| CUST_01... |
| CUST_30 |
Project Groups (Programs)
| R_ProjectGroups |
| PROJECT_GROUP_ID |
| NAME |
| DESCRIPTION |
| WEBSITE |
| PROJECT_TEMPLATE_ID |
| IS_ACTIVE |
| IS_DEFAULT |
| PERCENT_COMPLETE |
| START_DATE |
| END_DATE |
| PORTFOLIO_ID |
| REQUIREMENT_COUNT |
Project Group Membership (Program Membership)
| R_ProjectGroup_MembershipUsers |
| PROJECT_GROUP_ID |
| PROJECT_GROUP_NAME |
| PROJECT_GROUP_IS_ACTIVE |
| PROJECT_GROUP_ROLE_ID |
| PROJECT_GROUP_ROLE_NAME |
| PROJECT_GROUP_ROLE_ISACTIVE |
| USER_ID |
| USER_NAME |
| USER_FULLNAME |
Project (Product) Membership
| R_ProjectMembership |
| PROJECT_ID |
| USER_ID |
| PROJECT_ROLE_ID |
| PROJECT_NAME |
| PROJECT_ROLE_NAME |
| USER_NAME |
| FIRST_NAME |
| LAST_NAME |
| DEPARTMENT |
| IS_SYSTEM_ADMIN |
Project Release Resources
| R_ProjectReleaseResources |
| PROJECT_ID |
| USER_ID |
| RELEASE_ID |
| INCIDENT_EFFORT |
| TASK_EFFORT |
Project Roles
| R_ProjectRoles |
| PROJECT_ROLE_ID |
| NAME |
| IS_ACTIVE |
| DESCRIPTION |
| IS_ADMIN |
| IS_DISCUSSIONS_ADD |
| IS_SOURCE_CODE_VIEW |
| IS_SOURCE_CODE_EDIT |
| IS_DOCUMENT_FOLDERS_EDIT |
| IS_LIMITED_VIEW |
| IS_TEMPLATE_ADMIN |
| ARTIFACT_TYPE_ID |
| ARTIFACT |
| PERMISSION |
| R_ProjectTags |
| PROJECT_ID |
| TAG |
| PROJECT_NAME |
Project Teams Users
Available in SpiraPlan only
| R_Project_Team_Users |
| PROJECT_ID |
| PROJECT_NAME |
| USER_ID |
| USER_NAME |
| TEAM_ID |
| TEAM_NAME |
Project (Product) Templates
| R_ProjectTemplates |
| PROJECT_TEMPLATE_ID |
| NAME |
| DESCRIPTION |
| IS_ACTIVE |
Releases
| R_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_99 |
| 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 |
| TAGS |
Release Test Case Mapping
| R_ReleaseTestCases |
| 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
| R_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_99 |
| 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 |
| GOAL_ID |
| START_DATE |
| END_DATE |
| PERCENT_COMPLETE |
| TAGS |
Requirement Importances
| R_Requirement_Importance |
| IMPORTANCE_ID |
| PROJECT_TEMPLATE_ID |
| NAME |
| IS_ACTIVE |
| COLOR |
| SCORE |
Requirement Incidents
| R_RequirementIncidents |
| REQUIREMENT_ID |
| INCIDENT_ID |
| DETECTED_RELEASE_ID |
| IS_OPEN_STATUS |
Requirement Incidents - Extended
For normal use we strongly recommend using the standard artifact association view above. This extended view adds the artifact names, which can be very helpful, but will make the reports using it run much slower.
| R_RequirementIncidents |
| REQUIREMENT_ID |
| INCIDENT_ID |
| DETECTED_RELEASE_ID |
| IS_OPEN_STATUS |
| REQUIREMENT_NAME |
| INCIDENT_NAME |
Requirement Steps
| R_RequirementSteps |
| 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
| R_RequirementTestCases |
| REQUIREMENT_ID |
| TEST_CASE_ID |
| REQUIREMENT_NAME |
| TEST_CASE_NAME |
| PROJECT_ID |
| PROJECT_NAME |
Requirement Test Step Coverage
| R_RequirementTestSteps |
| TEST_STEP_ID |
| REQUIREMENT_NAME |
| POSITION |
| STEP_DESCRIPTION |
| EXPECTED_RESULT |
| SAMPLE_DATA |
| PROJECT_ID |
| PROJECT_NAME |
Requirement Types
| R_RequirementTypes |
| REQUIREMENT_TYPE_ID |
| REQUIREMENT_WORKFLOW_ID |
| PROJECT_TEMPLATE_ID |
| NAME |
| ICON |
| IS_ACTIVE |
| IS_STEPS |
| IS_DEFAULT |
| IS_KEY_TYPE |
| PROJECT_TEMPLATE_NAME |
Risks
Available in SpiraTeam and SpiraPlan only
| R_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_99 |
| TAGS |
Risk Impacts
Available in SpiraTeam and SpiraPlan only
| R_RiskImpacts |
| RISK_IMPACT_ID |
| PROJECT_TEMPLATE_ID |
| NAME |
| COLOR |
| IS_ACTIVE |
| POSITION |
| SCORE |
| PROJECT_TEMPLATE_NAME |
Risk Mitigations
Available in SpiraTeam and SpiraPlan only
| R_RiskMitigations |
| RISK_ID |
| RISK_MITIGATION_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 |
| PROJECT_ID |
Risk Probabilities
Available in SpiraTeam and SpiraPlan only
| R_RiskProbabilities |
| RISK_PROBABILITY_ID |
| PROJECT_TEMPLATE_ID |
| NAME |
| COLOR |
| IS_ACTIVE |
| POSITION |
| SCORE |
| PROJECT_TEMPLATE_NAME |
Risk Statuses
Available in SpiraTeam and SpiraPlan only
| R_RiskStatuses |
| RISK_STATUS_ID |
| NAME |
| IS_ACTIVE |
| IS_DEFAULT |
| IS_OPEN |
| POSITION |
| PROJECT_TEMPLATE_ID |
| PROJECT_TEMPLATE_NAME |
Risk Types
Available in SpiraTeam and SpiraPlan only
| R_RiskTypes |
| RISK_TYPE_ID |
| NAME |
| IS_ACTIVE |
| IS_DEFAULT |
| PROJECT_TEMPLATE_ID |
| RISK_WORKFLOW_ID |
| PROJECT_TEMPLATE_NAME |
Source Code Associations
Available in SpiraTeam and SpiraPlan only
| R_SourceCodeAssociations |
| ARTIFACT_SOURCE_CODE_REVISION_ID |
| ARTIFACT_TYPE_ID |
| ARTIFACT_ID |
| REVISION_KEY |
| COMMENT |
| CREATION_DATE |
| ARTIFACT_TYPE_NAME |
| ARTIFACT_TYPE_PREFIX |
Source Code Commits
Available in SpiraTeam and SpiraPlan only
| R_SourceCodeCommits |
| VERSION_CONTROL_SYSTEM_ID |
| PROJECT_ID |
| REVISION_ID |
| NAME |
| REVISION_KEY |
| AUTHOR_NAME |
| MESSAGE |
| UPDATE_DATE |
| CONTENT_CHANGED |
| PROPERTIES_CHANGED |
| VERSION_CONTROL_SYSTEM_NAME |
| VERSION_CONTROL_SYSTEM_DESCRIPTION |
| VERSION_CONTROL_SYSTEM_IS_ACTIVE |
| PROJECT_NAME |
| BRANCH_NAME |
| BRANCH_PATH |
| BRANCH_IS_HEAD |
Tasks
Available in SpiraTeam and SpiraPlan only
| R_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_99 |
| TASK_TYPE_ID |
| TASK_FOLDER_ID |
| IS_ATTACHMENTS |
| CONCURRENCY_DATE |
| REQUIREMENT_NAME |
| TASK_TYPE_NAME |
| COMPONENT_ID |
| COMPONENT_NAME |
| RISK_ID |
| TAGS |
Task Folders
Available in SpiraTeam and SpiraPlan only
| R_TaskFolders |
| TASK_FOLDER_ID |
| PROJECT_ID |
| NAME |
| PARENT_TASK_FOLDER_ID |
| HIERARCHY_LEVEL |
| INDENT_LEVEL |
Task Priorities
Available in SpiraTeam and SpiraPlan only
| R_TaskPriorities |
| TASK_PRIORITY_ID |
| PROJECT_TEMPLATE_ID |
| NAME |
| IS_ACTIVE |
| COLOR |
| SCORE |
| PROJECT_TEMPLATE_NAME |
Task Types
Available in SpiraTeam and SpiraPlan only
| R_TaskTypes |
| TASK_TYPE_ID |
| PROJECT_TEMPLATE_ID |
| TASK_WORKFLOW_ID |
| NAME |
| POSITION |
| IS_ACTIVE |
| IS_DEFAULT |
| IS_PULL_REQUEST |
| PROJECT_TEMPLATE_NAME |
Teams
Available in SpiraPlan only
| R_Teams |
| TEAM_ID |
| NAME |
| DESCRIPTION |
| IS_ACTIVE |
| IS_DELETED |
Test Cases
| R_TestCases |
| 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_99 |
| 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 |
| TAGS |
Test Case Folders
| R_TestCaseFolders |
| 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 |
| HIERARCHY_LEVEL |
| INDENT_LEVEL |
Test Case Incidents
| R_TestCaseIncidents |
| TEST_CASE_ID |
| INCIDENT_ID |
| DETECTED_RELEASE_ID |
| RESOLVED_RELEASE_ID |
| VERIFIED_RELEASE_ID |
| IS_OPEN_STATUS |
Test Case Priorities
| R_TestCase_Priorities |
| TEST_CASE_PRIORITY_ID |
| PROJECT_TEMPLATE_ID |
| NAME |
| IS_ACTIVE |
| COLOR |
| SCORE |
Test Case Types
| R_TestCaseTypes |
| TEST_CASE_TYPE_ID |
| PROJECT_TEMPLATE_ID |
| TEST_CASE_WORKFLOW_ID |
| NAME |
| IS_ACTIVE |
| POSITION |
| IS_DEFAULT |
| IS_EXPLORATORY |
| IS_BDD |
| PROJECT_TEMPLATE_NAME |
Test Configuration Entries
| R_TestConfigurationEntries |
| TEST_CONFIGURATION_ID |
| 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 |
| PROJECT_ID |
Test Configuration Sets
| R_TestConfigurationSets |
| 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
Note that the TEST_RUN_TYPE_ID can have two values: 1 = Manual, 2 = Automated
| R_TestRuns |
| 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_99 |
| IS_ATTACHMENTS |
| IS_DELETED |
| CONCURRENCY_DATE |
| PROJECT_ID |
| CHANGESET_ID |
| TEST_CONFIGURATION_ID |
| TAGS |
Test Run Incidents
| R_TestRunIncidents |
| TEST_RUN_ID |
| INCIDENT_ID |
| DETECTED_RELEASE_ID |
| RESOLVED_RELEASE_ID |
| VERIFIED_RELEASE_ID |
| IS_OPEN_STATUS |
| TEST_STEP_ID |
| TEST_RUN_STEP_ID |
Test Run Steps
| R_TestRunSteps |
| 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
| R_TestSets |
| 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 |
| PROJECT_IS_ACTIVE |
| AUTOMATION_HOST_NAME |
| TEST_RUN_TYPE_NAME |
| RECURRENCE_NAME |
| PROJECT_GROUP_ID |
| CUST_01... |
| CUST_99 |
| 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 |
| TAGS |
Test Set Folders
| R_TestSetFolders |
| 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 |
| HIERARCHY_LEVEL |
| INDENT_LEVEL |
Test Set Incidents
| R_TestSetIncidents |
| TEST_SET_ID |
| INCIDENT_ID |
| DETECTED_RELEASE_ID |
| RESOLVED_RELEASE_ID |
| VERIFIED_RELEASE_ID |
| IS_OPEN_STATUS |
Test Set Test Cases
| R_TestSetTestCases |
| 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
| R_TestSteps |
| 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_99 |
| IS_ATTACHMENTS |
| CONCURRENCY_DATE |
| PRECONDITION |
Timesheets
Available in SpiraTeam and SpiraPlan only
| R_Timesheets |
| TIMESHEET_ID |
| SUBMITTER_USER_ID |
| SUBMITTER_USER_NAME |
| APPROVER_USER_ID |
| APPROVER_USER_NAME |
| TIMESHEET_STATUS_ID |
| TIMESHEET_STATUS_NAME |
| CREATION_DATE |
| APPROVAL_DATE |
| LAST_UPDATE_DATE |
| START_DATE |
| END_DATE |
| COMMENTS |
| APPROVER_COMMENTS |
Timesheet Entries
Available in SpiraTeam and SpiraPlan only
| R_TimesheetEntries |
| TIMESHEET_ENTRY_ID |
| TIMESHEET_ID |
| USER_ID |
| USER_NAME |
| ARTIFACT_TYPE_ID |
| ARTIFACT_TYPE_NAME |
| ARTIFACT_ID |
| ARTIFACT_NAME |
| EFFORT_MINUTES |
| EFFORT_DATE |
| PROJECT_ID |
| PROJECT_NAME |
| PROJECT_GROUP_ID |
| PROJECT_GROUP_NAME |
| RESOURCE_CATEGORY_ID |
Timesheet Statuses
Available in SpiraTeam and SpiraPlan only
| R_TimesheetStatuses |
| TIMESHEET_STATUS_ID |
| TIMESHEET_STATUS_NAME |
| IS_ACTIVE |
| IS_OPEN |
Timesheets with Entries
Available in SpiraTeam and SpiraPlan only
This table combines the information from the timesheets table and the timesheet entries table to give a unified view of a timesheet and all of its key information.
| R_TimesheetWithEntries |
| TIMESHEET_ID |
| SUBMITTER_USER_ID |
| SUBMITTER_USER_NAME |
| APPROVER_USER_ID |
| APPROVER_USER_NAME |
| TIMESHEET_STATUS_ID |
| TIMESHEET_STATUS_NAME |
| CREATION_DATE |
| APPROVAL_DATE |
| LAST_UPDATE_DATE |
| START_DATE |
| END_DATE |
| COMMENTS |
| APPROVER_COMMENTS |
| TIMESHEET_ENTRY_ID |
| ARTIFACT_TYPE_ID |
| ARTIFACT_TYPE_NAME |
| ARTIFACT_ID |
| ARTIFACT_NAME |
| EFFORT_MINUTES |
| EFFORT_DATE |
| PROJECT_ID |
| PROJECT_NAME |
| PROJECT_GROUP_ID |
| PROJECT_GROUP_NAME |
| RESOURCE_CATEGORY_ID |
Users
| R_Users |
| USER_ID |
| 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 |
| ORGANIZATION |
| LAST_OPENED_PROJECT_GROUP_ID |
| LAST_OPENED_PROJECT_TEMPLATE_ID |
| IS_ADMIN |
| IS_REPORT_ADMIN |
| IS_RESOURCE_ADMIN |
| IS_PORTFOLIO_ADMIN |
| LAST_PASSWORD_CHANGED_DATE |