Table Description
Verification Category: Verification Category information
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::Verification::Administration::Service Layer::Verification Category::Entity::VerificationCategory
Controlling File: Verification\model\Packages\Administration\Service Layer\Verification Category\Entity\Verification Category_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
verificationCategoryIDkeynoThe unique system generated identifier for the verification category record.VERIFICATION_CATEGORY_ID SVR_INT64
namedetailsnoThe name of the verification category,e.g. Personal, Income, Employment.VERIFICATION_CATEGORY_NAMEVerificationCatNameSVR_STRING<10>
dateCreateddetailsnoThe creation date of the record.CURAM_DATE SVR_DATE
commentsdetails General remarks entered by the user.COMMENTS SVR_STRING<300>
recordStatusdetails Used to support logical deletes.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
VerifiableDataItem.verificationCategoryIDVerificationCategory.verificationCategoryID
Indices (1)
Index NameAttributes
nameStatusIdxname, recordStatus
Operations (16)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: verificationCategoryID
AUTO_ID_KEY: RVERFNBO
PRE_DATA_ACCESS: yes
Persists a new Verification Category 
readreadPRE_DATA_ACCESS: no
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Persists the changes to Verification Category 
validateDetails  Validates Verification Category. 
cancelnsmodifyPRE_DATA_ACCESS: yes
changes the status of Verification Category to 'Cancelled'. 
validateCancel  Validation is done before Cancel 
validateInsert  Validation is done before insert. 
validateModify  Validation is done before Modify. 
searchAllVerificationCategoryNamesnsmulti Returns a list of Verification Category names and their unique identifiers.SQL
searchVerificationCategoryListDetailsnsmulti Returns a list of Verification Category records containing the details required to be displayed in a list page.SQL
countByNameAndStatusns Counts active Verification categories with the same name.SQL
readNameByIDnsread Read name of Verification Category . 
searchAllActiveNamesnsmultiPRE_DATA_ACCESS: yes
 		 SQL
readStatusByIDnsread   
insertVerificationCategoryinsert Inserts Verification Category record. This method expects the verificationCategoryID to be set by the calling method. It is preferred to call insertVerificationCategory method only in scenarios where calling method wants to set the value of primary key by itself. 
modifyVerificationCategorymodifyOPTIMISTIC_LOCKING: yes
Persists the changes to Verification Category. 
Related Pages (9)