Tables not created by ALM

Extensions and add-ins to ALM may create tables or add fields. These tables and fields are not documented in this reference.

Tables created by ALM after installation

ALM creates some tables after installation as needed. These tables support calculations and complex activities such as: copying entities with dependencies between projects, capturing baselines, check-in, check-out, comparisons, and others.

All such tables are for internal use. Do not alter or attempt to use the data.

These tables are not documented in this reference.

Examples of such tables are:

• CLOSURE_PERS*
• TTBLCL_*

Tables BP_PARAM_VIRT and BP_ITER_PARAM_VIRT are created in projects under version control when parameters are missing from the BP_PARAM, VC_BP_PARAM,  BP_ITER_PARAM or VC_BP_ITER_PARAM tables. These virtual parameters are copied to the primary tables as needed.

Mirror Tables

ALM creates tables that mirror other tables for special purposes.

• BL_<primary table> tables support baselining for the primary table.
• HIST_<primary table> tables contain history records for the primary table.
• VC_<primary table> tables support version control for the primary table.

Most of the fields of the mirror tables are the same as those of the primary table. Therefore, mirror tables are not documented in this reference.

Some additional fields in the mirror tables are:

• *_BL_ID - The baseline ID.
• *_VC_CHECKIN_DATE - The date this version was checked in according to the server clock.
• *_VC_CHECKIN_TIME - The time this version was checked in according to the server clock.
• *_VC_CHECKIN_USER_NAME - The user name of the user who checked in this version.
• *_VC_CHECKOUT_COMMENTS - The user's comments when checking out the item.
• *_VC_CHECKOUT_DATE - The date this version was checked out according to the server clock.
• *_VC_CHECKOUT_TIME - The time this version was checked out according to the server clock.
• *_VC_CHECKOUT_USER_NAME - The user who checked out the item under version control.
• *_VC_DATE - The checkin date.
• *_VC_STATUS - The version status: Checked in, checked out, or read only.
• *_VC_TIME - The check-in time.
• *_VC_VERSION_NUMBER - The version ID of the entity.
• *_VER_STAMP - The version number of the record.
• *_VTS - The version time stamp.
• *VC_CHECKIN_COMMENTS - The user's comments when checking in the item.