Table Description
Motivation: An instance of a motivation type. A motivation is a type of process that a citizen may want to perform from the Universal Access portal. Motivations provide the infrastructure to allow a customer to add custom processes to the portal, for example, Apply For Healthcare. A motivation type consists of an IEG script, a datastore schema, a rule set to process the data collected in the IEG script and display rules to display the results of the rule set execution. This entity represents an instance of a motivation type which is created by or on behalf of a client in order to achieve a particular goal such as finding healthcare. In the main, the life cycle of a motivation conforms to the following basic pattern:
  • Collect data from the user
  • Execute rules based on the collected data
  • Display results based on the rules execution
  • Perform follow on actions
The execution of the rule set leads to the creation of related MotivationResult.

Example

Motivations can be used to add a process to allow a citizen to Apply For Healthcare.
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::CitizenWorkspace::Entity::Motivations::Motivation
Controlling File: CitizenWorkspace\model\Packages\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
motivationIDkeynoUnique identifier for this record.INTERNAL_ID SVR_INT64
dataStoreIDdetailsyesThe related data store root entity.INTERNAL_ID SVR_INT64
timestampdetailsyesThe timestamp of when the record was created.MOTIVATION_TIMESTAMP SVR_DATETIME
usernamedetailsnoThe user who launched the motivation. Motivations can only be launched by Citizen Workspace users.USER_NAME SVR_STRING<64>
typeIDdetailsyesThe related MotivationType of this Motivation. This Motivation is an instance of that type.INTERNAL_ID SVR_INT64
statedetailsnoThe state of this Motivation. This is a code from the MotivationState codetable, e.g. Started, In Progress, Evaluated, Complete, Cancelled.CW_MOTIVATION_STATEMotivationStateSVR_STRING<10>
scriptExecutionIDdetailsyesThe IEG script execution identifier.INTERNAL_ID SVR_INT64
Foreign Keys (4)
ChildParent
Motivation.dataStoreIDDatastoreEntity.entityID
Motivation.typeIDMotivationType.motivationTypeID
MotivationIntakeAppLink.motiveIDMotivation.motivationID
MotivationResult.motivationIDMotivation.motivationID
Indices (5)
Index NameAttributes
MotStateUserIdxusername, state
MOTSCRPTEXIDXscriptExecutionID
MotUserIdxusername
IND__146817367dataStoreID
IND_1272772478typeID
Operations (10)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: motivationID
Standard insert operation. 
readread Standard read operation. 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard modify operation. 
readByUserAndStatereadmultiORDER_BY: timestamp DESC
Returns a list of motivations or the specified user and state. 
readByDatastoreIDreadmulti   
searchPurgeableMotivationByUserNamensmulti  SQL
removeremove Standard Operation 
searchNonReferencedMotivationsnsmulti  SQL
readByScriptExecutionnsread   
readByStatereadmulti   
Related Pages (2)