Desc Descriptions

Public Interface Export Function › Tasks Related to All Tables › Description Tables › Desc Descriptions

Desc Descriptions

The description table (DESC) contains the textual description for all objects. When you select Detail and Description in a toolset, you create a row in this table. The text of the description of each object that has a description is maintained in this table.

This table has two columns. They are:

ID—Identifier of the object for which this is a description.
TEXT—Text of the description

Join ID of DESC with ID of the table for which the description is sought. Remember, if no description exists, nothing is returned. TEXT is a variable length text field.

To select the name and description of objects in table, enter the following syntax:

SELECT table.NAME, DESC.TEXT
  FROM MODEL, table, DESC
  WHERE MODEL.NAME= 'my model name'
  AND table.MODEL_ID = MODEL.ID
  AND DESC.ID = table.ID;

The following tables have descriptions:

Table Name	Table Contents
ACTION_BLOCK	Action Block Definition (Analysis and Design)
ACTIVITY_CLUSTER	Activity Cluster
ADD_DEPENDNCY	ADD Dependency
ALIAS	Alias name for an entity type, subtype, or attribute
ATTRIBUTE	Attribute of an entity type, subtype, or system entity type (work attribute set)
BAA_ACTN_BLK	Analysis Action Block Definition
BSD_ACTN_BLK	Design Action Block
BUS_GOAL	Business Goal
BUS_LOCATION	Location of Business Assets
BUS_OBJECTIVE	Business Objective
BUS_PROC_STEP	Business Procedure Step
BUSINESS_SYS	Business System
BUSINESS_PROC	Business Procedure
COMPONENT_IMPLEM	Component Implementation
COMPONENT_SPEC	Component Specification
CRITICAL_SUCCESS	Critical Success Factor
CURRENT_INFO_SYS	Current Information System
CURRENT_DATA	Current Database or Store
DATA_BASE	Database
DATA_CLUSTER	Data Cluster
DATA_STORE_INDEX	Indexspace Data Store
DATA_STORE_TBLSP	Tablespace Data Store
DATASET_INDEX	Indexspace Data Set
DATASET_TBLSP	Tablespace Data Set
DERIVATION_ALGOR	Derivation Algorithm
DIALECT	Dialect
DIALOG_FLOW	Dialog Flow
ENTITY_SUBTYP	Entity subtype
ENTITY_TYPE	Entity type
ENTITY_VIEW	Entity View
ENTRY_POINT	Entry Point Definition
ENVIRONMENT	Hardware/Software Environment
EXPECT_EFFECT	Expected Effect
FACILITY	Computing/Communication Facility
FIELD	Field Definition
FUNCTION_DEF	Function Definition
GROUP_VIEW	Group View
IDENTIFIER	Identifier
INFORMATION_NEED	Information Need
INTERFACE_TYPE	Interface Type
INTRFCE_TYPE_MDL	Interface Type Model
LINKAGE	Linkage
MATRIX	Matrices
OBJECT_CLASS	Object Class (System- and User‑defined)
ORGANIZAT_UNIT	Organizational Unit
PAD_FUNCTION	System‑supplied Functions
PARTITIONING	Partitioning of an entity type or subtype
PERMIT_VALUE	Permitted Value of an attribute
PROCESS_DEF	Process Definition
RECORD	Record Definition
REL_MUTL_EXCL	Mutually exclusive relationship
RELATIONSHIP	Relationship between two entity types/subtypes
SCREEN_DEF	Screen Definition
SCREEN_TMPLT	Screen Template
SPEC_TYPE	Specification Type
STRATEGY	Strategy
SUBJECT AREA	Subject Area
SYS_ATTRIBUTE	System Attribute
SYS_ENT_TYPE	System Entity Type (Work Attribute Set)
TACTIC	Tactic
USER_DEF_OBJECT	User‑defined Object
XTERNL_EVENT	External Event
XTERNL_OBJECT	External Object