Table Description
User Search Filter: Filter options used on various user search pages.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::UserSearchFilter::Entity::UserSearchFilter
Controlling File: core\model\Packages\Reference Model\Service Layer\UserSearchFilter\Entity\UserSearchFilter_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
userSearchFilterIDkeyno USER_SEARCH_FILTER_ID SVR_INT64
userNamedetailsno USER_NAME SVR_STRING<64>
userSearchTypedetails  USER_SEARCH_TYPEUserSearchTypeSVR_STRING<10>
filterDatadetails  XML_DESCRIPTION_STRING SVR_STRING<1400>
recordStatusdetails  RECORD_STATUSRecordStatusSVR_STRING<10>
pageIDdetails Page namePAGE_ID SVR_STRING<200>
Indices (1)
Index NameAttributes
UserSearchFilterIndexuserName, userSearchType, recordStatus
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: userSearchFilterID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Method to cancel specified UserSearchFilter record. 
readActiveByUserNameAndTypensPRE_DATA_ACCESS: yes
 		Read active XML filter data for specified user name and user search type.SQL
countActiveByUserNameAndTypensPRE_DATA_ACCESS: yes
 		Count active records by user name and user search type.SQL
validateDetails  Method to validate user search filter details. 
readActiveByUserNameTypeAndPageIDnsPRE_DATA_ACCESS: yes
 		Read active XML filter data for specified user name, user search type and pageID.SQL
Related Pages (10)