Element Type Definition: DATA

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	DATA_ITEM
Short Name	DIT
View Name	CI_DATA_ITEMS
Description	Definition of a data item, a piece of information similar in nature to
	an attribute (but not belonging to an entity) that can be used in
	dataflows and contained in datastores

Sub-type of	NON_SHAREABLE_ELEMENT
Versioning:	Structure of DATA_ITEM versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	NAME
Used by:	Oracle Designer
Underlying table:	SDD_DIT
Changes:	Summary of changes to DATA_ITEM in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
AUTHORITY	VARCHAR2(10)	Y	The level of authority needed to update this data item. Prompt: Authority
AVERAGE_LENGTH	NUMBER(3, 0)	Y	The average length for this data item. Prompt: Average Length
DECIMAL_PLACES	NUMBER(3, 0)	Y	The number of decimal places allowed for this data item. Prompt: Decimal Places
DERIVATION	VARCHAR2(240)	Y	Any algorithm or expression that describes how this data item is derived. Prompt: Derivation
FORMAT	VARCHAR2(35)	N	The format of this data item e.g. NUMBER, CHAR. Prompt: Format Uppercase	DATAFORMAT	VARCHAR2
MAXIMUM_LENGTH	NUMBER(3, 0)	Y	The maximum length for this data item. Prompt: Maximum Length
NAME	VARCHAR2(40)	N	The name of this data item. Prompt: Name Uppercase
NOTES	VARCHAR2(80)	Y	Brief notes relating to this data item. Prompt: Comment
RESPONSIBLE	VARCHAR2(10)	Y	An identifier for the user who is responsible for this data item. Prompt: Responsible
UNIT_OF_MEASURE	VARCHAR2(10)	Y	The units of measure for this data item. Prompt: Units

Other Properties
DATA_ITEM has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility
The following 'standard' properties are also inherited by all element types: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference DATA_ITEM:

Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DATAFLOW_DATA_ITEM_USAGE must be of one and only one DATA_ITEM
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each DATASTORE_DATA_ITEM_USAGE must be of one and only one DATA_ITEM
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype