Export Tables

Each object that is available for export has within it various fields that you can choose to further customize your export. Each of these fields correspond to a field in the requirements manager.

The objects you can select and their respective fields are detailed in the following tables.
  • Project Tables
  • User Tables
  • Group Tables
  • Requirement Tables
  • Traceability Tables
  • Security Tables
  • User-Defined Attribute Tables
  • Other Tables

Project Tables

The tables below describe the objects you can select and their respective fields of the Project tables.

Table 1. Project
Field Name Type Size
id_number Number 4
project_name Text 255
description Memo N/A
email_addr Text 255
test_director_integration_enabled Yes/No 1
scm_integration_enabled Yes/No 1
Table 2. Project Baseline Map
Field Name Type Size
project_id_number Number 4
baseline_id_number Number 4
Table 3. Project Group-Security Profile Map
Field Name Type Size
group_id Number 4
secruty_profile_id_number Number 4
project_id_number Number 4
Table 4. Project User-Security Profile Map
Field Name Type Size
user-id Number 4
security_profile_id_number Number 4
project_id_number Number 4

User Tables

The table below describe the objects you can select and their respective fields of the User tables.

Table 5. Users
Field Name Type Size
id_number Number 4
user_id Text 255
first_name Text 255
last_name Text 255
email_addr Text 255
department Number 4
location Text 255
phone_num Text 255
fax_num Text 255
pager_num Text 255
must_change_password Yes/No 1
can_not_change_password Yes/No 1
password_never_expires Yes/No 1
account_disabled Yes/No 1
Table 6. User Groups
Field Name Type Size
id_number Number 4
name Text 255
description Memo N/A
email_addr Text 255
Table 7. User-Group Map
Field Name Type Size
user_number Number 4
group_id_number Number 4

Group Tables

The tables below describe the objects you can select and their respective fields of the Group tables.

Table 8. Group
Field Name Type Size
id_number Number 4
group Text 255
Table 9. Member
Field Name Type Size
id_number Number 4
group Text 255
member Text 255

Requirement Tables

The tables below describe the objects you can select and their respective fields of the Requirement tables.

Table 10. Requirement Change
Field Name Type Size
id_number Number 4
revision_index Number 4
field_id Text 255
old_value Memo N/A
new_value Memo N/A
Table 11. Requirement Revision
Field Name Type Size
id_number Number 4
revision_index Number 4
index Text 255
rev_number Text 255
user_name Text 255
date_name Text 255
Table 12. Requirement Type_UDA Map
Field Name Type Size
req_type_id_number Number 4
uda_id_number Number 4
Table 13. Requirement Info
Field Name Type Size
id_number Number 4
name Text 255
type Text 255
owner Text 255
status Text 255
priority Text 255
version Text 255
description Memo N/A
validation Memo N/A
tag Text 255
hierarchy Text 255
index Number 4
name_tag Text 255
Table 14. Requirement Type
Field Name Type Size
id_number Number 4
version Number 4
name Text 255
description Memo N/A
tag Text 6

Traceability Tables

The tables below describe the objects you can select and their respective fields of the Traceability tables.

Table 15. Trace From
Field Name Type Size
trace_from_id_number Number 4
id_number Number 4
from_name Text 255
suspect Text 255
Field Name Type Size
trace_to_id_number Number 4
id_number Number 4
from_name Text 255
suspect Text 255

Security Tables

The tables below describe the objects you can select and their respective fields of the Security tables.

Table 16. Security Profile
Field Name Type Size
id_number Number 4
name Text 255
description Memo N/A
Table 17. Security Profile-Requirement Type
Field Name Type Size
sec_profile_id_number Number 4
req_type_id_number Number 4
access Text 255
delete Text 255
Table 18. Security Profile_UDA
Field Name Type Size
sec_profile_id_number Number 4
req_type_id_number Number 4
access Text 255
uda_id_number Number 4

User-Defined Attribute Tables

The tables below describe the objects you can select and their respective fields of the User-Defined Attribute Tables.

Table 19. UDA User List Selection Info
Field Name Type Size
uda_id_number Number 4
is_expandable_list Yes/No 1
selection_item Number 4
Table 20. UDA Text Field
Field Name Type Size
uda_id_number Number 4
min_length Number 4
max_length Number 4
num_lines_displayed Number 4
default_value Text 255
Table 21. UDA User
Field Name Type Size
uda_id_number Number 4
is_expandable_list Yes/No 1
selection_item Number 4
default_item Number 4
Table 22. UDA Values
Field Name Type Size
uda_id_number Number 4
min_length Number 4
max_length Number 4
input_mask Text 255
Table 23. UDA Text Line
Field Name Type Size
uda_id_number Number 4
min_length Number 4
max_length Number 4
input_mask Number 4
default_value Text 255
Table 24. UDA Date Info
Field Name Type Size
uda_id_number Number 4
min_length Number 4
max_length Number 4
default_value Text 255
Table 25. UDA Single Selection List Info
Field Name Type Size
uda_id_number Number 4
presentation_type Text 255
ordinality Number 4
selection_item Text 255
default_value Number 4

Other Tables

The tables below describe the objects you can select and their respective fields of other Tables.

Table 26. Baseline
Field Name Type Size
id_number Number 4
baseline_type Text 255
name Text 255
description Text 255
email_addr Text 255
baseline_lock_status Text 255
Table 27. Department
Field Name Type Size
id_number Number 4
status Integer 2
name Text 255
description Memo N/A
Table 28. Custom Tab-UDA Map
Field Name Type Size
req_type_id Number 4
name Text 255
UDA_id_number Number 4
Table 29. Document Reference
Field Name Type Size
Document Reference Number 4
id_number Number 4
file Text 255
description Memo N/A
Table 30. Custom Tab
Field Name Type Size
req_type Number 4
name Text 255
Table 31. Glossary
Field Name Type Size
term_name Text 255
definition Text 255
Table 32. Discussion
Field Name Type Size
requirement_id Number 4
subject Text 255
date Date/Time 8
user_id Text 255
body Memo N/A
depth Number 4