Element Type Definition: TRANSFORMER

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	TRANSFORMER_STANDARD
Short Name	TRS
View Name	CI_TRANSFORMER_STANDARDS
Description	Standard that can be applied to projects regarding the transformers

Sub-type of	PROJECT_STANDARD
Versioning:	Structure of TRANSFORMER_STANDARD versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	NAME
Used by:	JDeveloper Enterprise Edition
Underlying table:	SDD_PST

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
COLUMN_PREFIX	VARCHAR2(20)	Y	Column prefix to be used in projects to which this standard applies Prompt: Column Prefix
CREATE_RTL_PK_COLS_FLAG	VARCHAR2(1)	N	Indicates whether Run Time Library mantained primary key columns to be created in projects to which this standard applies Not displayed Uppercase	YESNO	Y
DISCRIMINATOR_COLUMN_SUFFIX	VARCHAR2(20)	Y	Discriminator column suffix to be used in projects to which this standard applies Prompt: Discriminator Column Suffix
FK_CONSTRAINT_SUFFIX	VARCHAR2(20)	Y	Foreign key constraint suffix to be used in projects to which this standard applies Prompt: Foreign Key Constraint Suffix
MM_ASSOC_IMPLEMENTATION	VARCHAR2(12)	N	Indicates how M;M associations are to be implemented in projects to which this standard applies Prompt: M:M Association Implementation Uppercase	MM_IMPLEMENTATION	INTERSECTION
NAME	VARCHAR2(100)	N	Name of the project standard Prompt: Name Defined on PST supertype
ORACLE_ATT_PREFIX_FOR_ASS_ENDS	VARCHAR2(20)	Y	Oracle type attribute prefix for association ends to be used in projects to which this standard applies Not displayed
ORACLE_COLLECTION_TYPE_PREFIX	VARCHAR2(20)	Y	Oracle collection type prefix to be used in projects to which this standard applies Not displayed
ORACLE_TYPE_SUFFIX	VARCHAR2(20)	Y	Oracle type suffix to be used in projects to which this standard applies Not displayed
PK_CONSTRAINT_SUFFIX	VARCHAR2(20)	Y	Primary key constraint suffix to be used in projects to which this standard applies Prompt: Primary Key Constraint Suffix
PROJECT_STANDARD_SUBTYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal system maintained property indicating the PROJECT_STANDARD subtype Not displayed Uppercase System maintained Not updatable by user Defined on PST supertype	PROJECT_STANDARD_SUBTYPE
SEQUENCE_SUFFIX	VARCHAR2(20)	Y	Sequence (for surrogate primary key) suffix to be used in projects to which this standard applies Prompt: Sequence Suffix
SURROGATE_PK_COLUMN_SUFFIX	VARCHAR2(20)	Y	Surrogate primary key column suffix to be used in projects to which this standard applies Prompt: Surrogate PK Column Suffix
TABLE_PREFIX	VARCHAR2(20)	Y	Table prefix to be used in projects to which this standard applies Prompt: Table Prefix
UK_CONSTRAINT_SUFFIX	VARCHAR2(20)	Y	Unique key constraint suffix to be used in projects to which this standard applies Prompt: Unique Key Constraint Suffix
UPDATE_SERVER_MODEL_FLAG	VARCHAR2(1)	N	Indicates whether the transformer is to update names of server model elements Prompt: Update Server Model ? Uppercase	YESNO	N

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC Defined on PST supertype	Description
NOTES	CDINOT Defined on PST supertype	Notes

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

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 ELEMENT_RULE_USAGE must be applicable to one and only one CIELEMENT (in arc)
Each PROJECT may be using one and only one TRANSFORMER_STANDARD
Each DATATYPE_MAPPING must be defined in one and only one PROJECT_STANDARD
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each TAGGED_VALUE must be in the context of one and only one CIELEMENT (in arc)
Each UML_DEPENDENCY_CLIENT must be identifying as client one and only one CIELEMENT (in arc)
Each UML_DEPENDENCY_SUPPLIER must be identifying as supplier one and only one CIELEMENT (in arc)

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