name

Yes

Specifies the name of the sqlViewColumn.

dataType

Yes

The data type of the sqlViewColumn. Valid values are:

• String
• Integer
• SmallInteger
• TinyInteger
• Real
• Double
• Character
• String
• LongString
• DateTime
• Decimal

length

No

0

For string columns, the length (in characters) of the column. This is required for string columns. The length can be increased, but cannot be decreased, as this could cause data loss.

description

No

Description of the sqlViewColumn and its purpose.

isSearchable

No

false

For Oracle database systems, indicates if this column should be searchable in a case-insensitive manner or not.

isUserDefined

No

true

Indicates if this sqlViewColumn has been defined by the customer.

clarifyGenericFieldID

No

-1

This data is used by Amdocs/Clarify applications to identify fields in different objects that are handled in a similar way. For example, a WIPbin contains different types of objects, such as cases and bugs. Certain fields in these objects (such as the ID number and title) are treated in the same way by the application and are assigned the same clarifyGenericFieldID.

isCurrencyData

No

false

Indicates if this sqlViewColumn holds monetary (currency) data.

isPredefined

No

false

This attribute is not typically used.

isMandatory

No

false

This attribute is not typically used.

isDirect

No

false

This attribute is not typically used.

order

No

The order of the sqlViewColumn within the table.

See Also

sqlView

databaseSpecificSql

Next

databaseSpecificSql