Previous Topic: Add Schema Changes to Derived UniverseNext Topic: Reports and Folder Structures


Common Schema Modifications

You can implement schema modifications in the Universe. To familiarize you with the process, the following table lists the common schema modifications that you might encounter.

When a field type is defined in Web Screen Painter as...

Follow these rules when using the field in the Universe:
Right click the attribute and select...

INTEGER

Object Properties, Definition Tab, Type = Number

STRING

Object Properties, Definition Tab, Type = Character

DATE

Object Properties, Definition Tab, Type = Date

Object Format, Number Tab: Choose category "Date/Time"; Choose Format mm/dd/yyyy hh:mm:ss AM/PM

DURATION

Object Properties, Definition Tab, Type = Number; Object Properties, Definition Tab, Select = PdmSeconds(object.attr)

SREL

Create a CA SDM attribute alias.

BREL

Not Applicable

QREL

Not Applicable

DERIVED

Use an appropriate data type and object format for the value stored in the derived field, if desired. The Derived field can produce any result, so there is not a specific standard to follow.

Special Case: Local

This is not a data type defined within Web Screen Painter, but instead a data type used by the universe sometimes to indicate an unsupported data type.

The Local field is displayed in the right pane of the universe with type "L". These fields can be dragged, but not dropped into a class on the right universe pane. Most often, fields data types such as binary, are not supported by the Universe. However, they can be added to the left pane of the universe by creating an object and placing the PdmString (object.attribute) in the "SELECT" window of the Edit Properties dialog.