Table Description
CERT Specification : An association between a CER rule set and an IEG Script and data store.

An assessment may be executed using C\u00FAram Decision Assist (CDA) or C\u00FAram Express Rules (CER). If CER is used this entity stores the details of the CER rule set and details of the IEG script used to gather assessment answers. For example, a Family Strength and Needs Assessment uses CDA to produce results whereas a Risk Assessment uses CER to produce results as the assessment contains more complex processing.

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::AssessmentPlanning::Administration::Entity::CERTSpecification::CERTSpecification
Controlling File: AssessmentPlanning\model\Packages\Administration\Entity\CERTSpecification_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
certSpecificationIDkeynoUnique identifier for a CER Specification.INTERNAL_ID SVR_INT64
nameIDdetailsnoThe localizable name of the CER assessment specification.LOCALIZABLE_TEXT_ID SVR_INT64
iegScriptIDdetailsnoA reference to the CER script for this assessment.IEG_SCRIPT_ID SVR_STRING<100>
iegScriptTypedetailsnoThe type of IEG script.IEG_USERDEFINIED_TYPE SVR_STRING<128>
iegScriptVersiondetailsnoThe version of the IEG script.IEG_SCRIPT_VERSION SVR_STRING<50>
schemaNamedetailsnoThe data store schema used to store the IEG assessment answers.DATASTORE_SCHEMA_NAME SVR_STRING<40>
creoleRuleSetIDdetailsnoThe identifier of the CER rule set.INTERNAL_ID SVR_INT64
scoringUseddetailsnoIndicates if the CER rules set return a score for each factors as opposed to returning the classification.CURAM_INDICATOR SVR_BOOLEAN
recordStatusdetailsnoStatus of the CER Specification record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (4)
ChildParent
CERTSpecification.creoleRuleSetIDCREOLERuleSet.creoleRuleSetID
CERTSpecification.schemaNameDatastoreSchema.schemaName
CERTSpecification.iegScriptIDIEGScriptInfo.scriptID
CERTSpecification.nameIDLocalizableText.localizableTextID
Indices (5)
Index NameAttributes
IND_81349324schemaName
IND__647900143iegScriptID
IND_138602704iegScriptType
IND__1440590974iegScriptVersion
IND_371157990nameID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: certSpecificationID
AUTO_ID_KEY: ASSMTBO
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByStatusreadmulti Returns a list of CERT Specification records for the given status. 
Related Pages (12)