ALM Project 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 NullsDefaultFormula
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: LISTS.LS_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: LISTS.LS_ID 

FIELDS: SYSTEM_FIELD.SF_ID

GROUPS: GROUPS.GR_ID

int4  
Indexes
IndexDescriptionPrimaryUnique
LINKED_TEMPALTE_ITEMS_UK  
LINKED_TEMPLATE_ITEMS_PK 
See Also