Element Type Definition: TRANSFORMATION_MAPPING

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	TRANSFORMATION_MAPPING_SET
Short Name	TMS
View Name	CI_TRANSFORMATION_MAPPING_SETS
Description	A transformation mapping set represents the overall "collective"
	mapping for transformation, made up of individual pairs of specified
	elements (ie MAPPING_ELEMENTS)

	Transformation Mapping Sets can only be created by the transformers

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

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
REMARK	VARCHAR2(240)	Y	A single line remark concerning the mapping Prompt: Comment
TRANSFORMATION_TYPE	VARCHAR2(8)	N	Indicates the type of transformation mappings that this set contains Prompt: Transformation Type Uppercase Updatable only if null	TRANSFORMATION_TYPE

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC	Description

Other Properties
TRANSFORMATION_MAPPING_SET 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 TRANSFORMATION_MAPPING_SET:

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 DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
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