Teamcenter Data Model

In this section we will study the data model of important business objects in My Teamcenter and how
they are stored in the database.

Objects & Relations

Item, Item Revision and its Master Forms

Business Object Database Storage Class

Business Object
BusinessObject -

POM_object POM_object
POM Object POM_application_object POM_application_object

WorkspaceObject WorkspaceObject

Item Item
POM Application
Item Master Form

ItemRevision ItemRevision

WorkspaceObject ItemRevision Master Form

Item Item Revision Form

Item Master Item Revison Master

 Document, Document Revision and its Master Forms

Business Object Database Storage Class

WorkspaceObject
Document Document

Document Master Form

DocumentRevision DocumentRevision

DocumentRevision Master Form

Item Item Revision Form

Document Document Revision Document Master Document Revision Master

Dataset
Business Object Database Storage Class

Dataset Dataset

MSExcelX Dataset

UGMODEL Dataset

PDF Dataset
 WorkspaceObject

Dataset

MSExcelX UGMODEL PDF

Folder
Business Object Database Storage Class
WorkspaceObject
Folder Folder

Fnd0HomeFolder Folder

Mail Folder Folder

Folder User_Inbox User_Inbox

Envelope Envelope

Fnd0HomeFoldere Mail Folder User_Inbox Envelope

Commonly used Relations’ Information
Relation Name Relation Parent Primary Object Secondary Object Purpose

IMAN_master_form ImanRelation Item Form Automatically create when

master form created

IMAN_master_form ImanRelation ItemRevision Form Automatically create when

master form created

TC_Attaches ImanRelation ItemRevision Dataset Whenever dataset is attached

to Item Revision

IMAN_manifestation ImanRelation ItemRevision UGMASTER Created automatically when

Item created from NX

IMAN_UG_altrep ImanRelation ItemRevision UGALTREP Created automatically when

Item created from NX

IMAN_specification ImanRelation ItemRevision ItemRevision Typically used when Document

Revision is related to Item
Revision

Important Attributes
Attribute Name Business Objects Available Purpose
On

Item Id Item and it’s children Used to uniquely identify the business object in
Teamcenter

Name Workspace Object and it’s Used to capture the name with which the business
children object is identified in your organization

Type Workspace Object and it’s Gives information as regards what type of business
children object it is. This can be a good information to filter /
sort business objects of similar type

Revision Item Revision and its children Gives information about the revision level of the
business object.

Sequence Id Item Revision and its children Gives information about the sequence level of the
business object. Sequences are typically created when
Attribute Name Business Objects Available Purpose
On

a business undergoes a check-out and check-in cycle.

Sequence Limit Item Revision and its children Gives information about the maximum number of
sequences that will be stored at any given point of
time for the business object

Item Item Revision and its children Gives information about the Item business object for
the give revision object. This a link attribute and on
clicking the link one can view the Item object

Version Number Workspace Object and it’s Gives information about the version level of the
children dataset. Versions are typically created when a dataset
undergoes a check-out and check-in cycle.

Version Limit Workspace Object and it’s Gives information about the maximum number of
children versions that will be stored at any given point of time
for the dataset

POM Application Object and Gives information about the date and time when this
it’s children business object was created

Checked-Out Workspace Object and it’s Gives information about whether the business object
children is currently checked out (or edited)

Checked-Out By Workspace Object and it’s Gives information about the TC User who has checked
children out (or editing) this business object. This is a link
attribute which provides link to the user object

Checked-Out Date Workspace Object and it’s Gives information about the date and time when this
children business object has been checked out.

Owning User POM Application Object and This attribute gives information about the user who
it’s children created this object. Since the attribute actually
provides a link to the TC user object one can get more
user details by clicking on that link

Owning Group POM Application Object and This attribute gives information about the TC Group to
it’s children which the user who created this object belongs to.
Since the attribute actually provides a link to the TC
user object one can get more user details by clicking
on that link

Last Modified Date POM Application Object and Gives information about the date and time when this
it’s children business object was last modified

Last Modifying User POM Application Object and This attribute gives information about the TC User
Attribute Name Business Objects Available Purpose
On

it’s children who last modified this business object. Since the
attribute actually provides a link to the TC user object
one can get more user details by clicking on that link
Preferences
Preference Name Purpose

AE_dataset_default_keep_limit Determines the number of old dataset versions to store in the database.
When this number is exceeded, the oldest dataset version is deleted

Mail_OSMail_Activated Determines whether operating system e-mail can be sent from

Teamcenter. When enabled, users can send OS e-mail by clicking Send
To à Envelope

Revision_Name_Based_On_ItemRevision Specifies whether revision names displayed in the rich client Revise
dialog box are based on item revision names or item names.

Typically we provide the same name for Item and its Revision, hence we
would not be able to make out the difference. Try changing the names
for Item and Revision and see how this preference affects the display

TC_Auto_Checkout Enables or suppresses automatic implicit check out of non-NX datasets.

Implicit check out automatically prevents users from gaining write
access to a non-NX dataset if another user has opened it.

TC_Enable_Implicit_CO Determines whether implicit checkout, save, and checkin is enabled in

the Properties dialog box, form dialog boxes, the Viewer view, and the
Summary view.

TC_Enable_legacy_create Determines if either the legacy or the generic dialog box is displayed for
the Create command. If no value is specified, the new generic dialog box
is displayed by default.

TC_Enable_LegacySaveAs Specifies whether the legacy Save As dialog box is displayed for all types
in the rich client.

TC_suppress_Edit_Latest_Menu Enables or suppresses the Edit Latest command in the rich client. This
menu command updates all version-0 datasets to reference the latest
saved version in the database.

TCDefaultKeepLimit Determines the number of sequences the system maintains as an item

revision is checked in and out of the database. At logon, the system
automatically removes

the oldest sequence when the limit specified with this preference is
reached

WhereReferencePOMPref Specifies whether all instances and classes found in the database that
contain references to a specified instance are displayed in the Impact
Analysis view

WHERE_REFERENCED_RELATIONS_FILTER Specifies custom relations displayed in the Where Referenced Options

 Preference Name Purpose

relation list. Added relations are not displayed in the Paste Special, Paste
dialog box and are not defined as child relations.

Please refer the pdf named, “preferences_environment_variables_reference.pdf” to understand in

details each of the above preference variables and any additional ones