Common Properties

Introduction › Public Interface View Definitions › Common Properties

Common Properties

Most Public Interface views have columns representing these properties:

Name of Column (Property)	Function
MODEL_ID	Identifies the model that contains the object
TBNAME	Identifies the individual table (SQL view) name
ID	Identifies the object within the encyclopedia
ORG_ENCY_ID	Identifies the original encyclopedia of the object
ORG_ID	Identifies the original object

(ORG_ENCY_ID and ORG_ID let you trace the ancestry of an object if it has been copied.)

For example, the view ATTRIBUTE contains one row for every attribute of every entity type in every model. Each attribute has a column for MODEL_ID, TBNAME, ID, ORG_ENCY_ID, ORG_ID, and a foreign key (PARENT_ENTITY_ID) that identifies the entity type to which the attribute belongs. Each row also contains columns for the attribute’s properties, such as NAME, DSD_NAME, TYPE, and DOMAIN.

The following table contains some representative entries from the view ATTRIBUTE:

MODEL_ID	TBNAME	ID	ORG_ENCY_ID	ORG_ID	NAME	DSD_NAME	SEQ	OPT	TYPE	DOMAIN		PARENT_ENTITY_ID
4782	Attribute	5917	1234	5917	NUMBER	NUMBER	01	M	B	N	...	5678
4782	Attribute	6310	1234	6310	QTY ON HAND	QTY ON HAND	03	M	B	N	...	6121
4782	Attribute	5712	1234	5712	ADDRESS	ADDRESS	03	M	B	T	...	5678
4782	Attribute	6797	1234	6797	SHIP TO	SHIP TO	04	M	B	T	...	6121
4782	Attribute	8194	1234	8194	GOVERNER	GOVERNER	01	M	B	T	...	7953
4782	Attribute	8196	1234	8196	CAPITAL	CAPITAL	01	M	B	T	...	7953
4782	Attribute	6795	1234	6795	QUANTITY	QUANTITY	02	M	B	N	...	6780
4782	Attribute	5938	1234	5938	CATEGORY	CATEGORY	08	M	B	T	...	5678
4782	Attribute	5715	1234	5715	ZIP	ZIP	06	M	B	N	...	5678