D:CitizenScriptInfo

Table Description

Citizen Script Information: Holds information about the current execution of IEG scripts in relation to the Citizen Portal. Optimistic locking is not required for this entity as only one user will ever be updating a record on this table, i.e. the citizen as they navigate through the Citizen Portal.

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::CitizenScriptInfo::CitizenScriptInfo
Controlling File:	CitizenWorkspace\model\Packages\Entity\CitizenScriptInfo_cat.efx

Table Options

ALLOW_OPTIMISTIC_LOCKING

Attributes (9)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
scriptExecutionID	key	no	The execution ID associated with the ieg script.	INTERNAL_ID		SVR_INT64
userName	details	no	The username of the user that the script belongs to, this is used to ensure that only the user who started the script is the only user who has access to the information captured during the script.	USER_NAME		SVR_STRING<64>
startDate	details	no	The date the script was started.	CURAM_DATE		SVR_DATE
lastUpdatedDate	details	no	The date the script was last updated.	CURAM_DATE		SVR_DATE
status	details	no	The current status of the script, e.g. Open, In Progress, Submitted or Cancelled.	CITIZEN_SCRIPT_STATUS	CitizenScriptStatus	SVR_STRING<10>
applicationRelatedID	details	yes	ID of the related application type (screening or intake).	INTERNAL_ID		SVR_INT64
scriptType	details	no	The type of script being executed, e.g. Intake, Submission, Screening or Filtered Screening.	ONLINE_SCRIPT_TYPE	OnlineScriptType	SVR_STRING<10>
datastoreID	details	no	The id of the root datastore entity used by the script.	DATASTORE_UID		SVR_INT64
datastoreSchema	details	no	The name of the datastore schema used by the script to capture data.	DATASTORE_SCHEMA_NAME		SVR_STRING<40>

Foreign Keys (2)

Child	Parent
CitizenScriptInfo.datastoreID	DatastoreEntity.entityID
CitizenScriptInfo.datastoreSchema	DatastoreSchema.schemaName

Indices (8)

Index Name	Attributes
CitzScrptInfIdx1	userName, scriptType, status, applicationRelatedID
CitzScrptDateScrptTypIdx	scriptType, lastUpdatedDate
CitzScrptDateKeyIdx	lastUpdatedDate
CitzDatScrptTypStatusIdx	status, scriptType, lastUpdatedDate
CitzScrptStatusDatIdx	status, lastUpdatedDate
SearchFailedRecordIndex	scriptType, status
IND_786411796	datastoreID
IND_2041521466	datastoreSchema

Operations (19)

Operation	Stereotype	Options	Description	SQL
insert	insert		Standard Operation
searchByDatastore	readmulti	WHERE: datastoreID = :datastoreID
searchByDateScriptTypeAndStatus	readmulti	WHERE: lastUpdatedDate < :date AND status = :status AND scriptType = :scriptType	Searches for records by script type and status which have a lastUpdatedDate before the specified date.
read	read		Standard Operation
modify	modify	OPTIMISTIC_LOCKING: no	Standard Operation
remove	remove		Standard Operation
searchByUserNameScriptTypeAndStatus	readmulti		Searches for script info record based on username and status.
readByUserNameAndScriptExecution	nsread		Reads a script info record based on execution id and username.
readByUserNameScriptTypeStatusAndRelatedID	nsread		Reads a script info record based on username, script type, status and relatedID
searchByStatus	readmulti		Searches for Citizen Script Info record based on status.
searchByStatusAndDate	readmulti	ORDER_BY: lastUpdatedDate WHERE: lastUpdatedDate < :date AND status = :status	Searches for records by status which have a lastUpdatedDate before the specified date.
searchByUserName	readmulti		Searches for records by the userName field.
searchFailedApplications	nsmulti			SQL
searchFailedLifeEvents	nsmulti			SQL
readLastWritten	ns			SQL
searchByScriptTypeAndDate	readmulti	WHERE: lastUpdatedDate < :lastUpdatedDate AND scriptType = :scriptType
searchByPurgeDate	readmulti	WHERE: lastUpdatedDate < :lastUpdatedDate	Searches for Citizen Script Info record based on status which have a lastUpdatedDate before the specified date.
searchCitizenScriptInfoByDateScriptTypeAndStatus	readmulti	WHERE: lastUpdatedDate < :lastUpdatedDate AND status = :status AND scriptType = :scriptType	Searches for records by script type and status which have a lastUpdatedDate before the specified date.
searchCitizenScriptInfoByStatusAndDate	readmulti	ORDER_BY: lastUpdatedDate WHERE: lastUpdatedDate < :lastUpdatedDate AND status = :status	Searches for records by status which have a lastUpdatedDate before the specified date.

Related Pages (0)

Database Table: CitizenScriptInfo