HP ALM Database Reference
td.LINKED_TEMPLATE_ITEMS Table

Description

An association between project items and template items.

Remarks

For each project customization item of each category, stores the template item ID to which it is linked.

Columns

 Column NameDescriptionDatatypeLengthAllow NullsDefault
Primary Key LTI_IDThe record ID.int4  
 LTI_CATEGORY_NAME

One of: REQUIREMENT_TYPE, LOOKUP_LISTS, FIELDS, or GROUPS.

varchar30 
 LTI_PROJECT_ITEM_ID

The ID of the linked item in the project. One of:

REQUIREMENT_TYPE: REQ_TYPE.TPR_TYPE_ID

LOOKUP_LISTS: ALL_LISTS.AL_ITEM_ID

FIELDS: SYSTEM_FIELD.SF_ID

GROUPS: GROUPS.GR_ID

int4 
 LTI_TEMPLATE_ITEM_IDThe ID of the linked item in the template. One of:

REQUIREMENT_TYPE: REQ_TYPE.TPR_TYPE_ID

LOOKUP_LISTS: ALL_LISTS.AL_ITEM_ID

FIELDS: SYSTEM_FIELD.SF_ID

GROUPS: GROUPS.GR_ID

int4 

See Also