Table Description
Summary View Field Definition: Stores Summary View Fields information.

The entity defines Summary View Fields by associating field name with Rules Data Object Name, Data Item Name and Data Type to the field.

Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::SummaryViews::Service Layer::Entity::SummaryViewDefinition::SummaryViewFieldDefinition
Controlling File: SummaryViews\model\Packages\Service Layer\Entity\SummaryViewDefinition\SummaryViewDefinition_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
summaryViewFieldDefinitionIDkeynoUnique reference number assigned by the System to a Summary View Field Definition record.INTERNAL_ID SVR_INT64
summaryViewGroupDefinitionIDdetailsnoSummary View Group Definition ID to which this Summary View Field Definition belongsINTERNAL_ID SVR_INT64
fieldNamedetails Summary View Field NameSUMMARY_VIEW_FIELD_NAMESummaryViewFieldNameSVR_STRING<10>
rdoNamedetails Rules Data Object Name which would be used to read data item mentioned in the recordRULES_DATA_OBJECT_NAME SVR_STRING<100>
dataItemNamedetails Data Item Name of the Rules Data Object which would be read to show information in rules summaryDATA_ITEM_NAME SVR_STRING<100>
dataTypedetails Data Type of the Data ItemDATA_ITEM_TYPE SVR_STRING<100>
displayOrderdetails Order in which field can be displayedSUMMARY_VIEW_DISPLAY_ORDER SVR_INT32
fieldTypedetails Type of Summary View Field to distinguish a field having hyperlink to other Summary ViewSUMMARY_VIEW_FIELD_TYPESummaryViewFieldTypeSVR_STRING<10>
linkedSummaryViewdetails Summary View Definition which would be used to retrieve Summary information when hyperlink is clickedSUMMARY_VIEW_DEFINITION SVR_INT64
fieldLinkTextdetails A static Link Text can be used instead of Data Item Value to show hyperlinkSUMMARY_VIEW_FIELD_LINKTEXT SVR_STRING<100>
Foreign Keys (1)
ChildParent
SummaryViewFieldDefinition.summaryViewGroupDefinitionIDSummaryViewGroupDefinition.summaryViewGroupDefinitionID
Indices (1)
Index NameAttributes
IND_365420959summaryViewGroupDefinitionID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: summaryViewFieldDefinitionID
AUTO_ID_KEY: SUMVWFLDID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
searchBySummaryViewGroupDefinitionIDreadmulti Retrieves all the Summary View Field Definitions for a given Summary View Group Definition ID 
modifyDataItemDetailsnsmodify Modifies data item name and type for a given Summary View Field Definition 
removeBySummaryViewGroupDefinitionIDnsremovePRE_DATA_ACCESS: no
Removes all Summary View Field Definitions for a given Summary View Group Definition ID 
modifySummaryViewFieldDetailsnsmodify Modifies summary view field details 
insertSummaryViewFieldDefinitionnsinsert Insertrs values to the Summary View Field Definition. This method allows to enter primary key values. 
Related Pages (14)