Table Description
ISP Sanction Assessment Processing: This is a processing entity that is used for maintaining action status for each sanction assessment record for an integrated case from within the inbox task.

The sanction assessment status records are created in this entity after sanction assessment is run and there is ineligible sanction assessment result. These records are used to create sanction or sanction overrides. Once all the sanction assessment records are actioned i.e. sanctioned or overridden, or when the task is closed, the records are deleted from this entity for the integrated case.
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::Income Support Product::Service Layer::entity::Processing::ISPSanctionAssessmentProc::ISPSanctionAssessmentProc
Controlling File: ISProduct\model\Service Layer\entity\Processing\ISPSanctionAssessmentProc\ISPSanctionAssessmentProc_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
sanctionAssessmentIDkeynoSystem generated unique identifier for the sanction assessment processing.ISP_SANCTION_ASSESSMENT_ID SVR_INT64
caseIDdetailsnoThe unique ID of the case to which the ISPSanctionAssessmentProc refers.CASE_ID SVR_INT64
concernroleIDdetailsnoThe unique ID a participant is given in a particular role within a case.CONCERN_ROLE_ID SVR_INT64
caseDecisionIDdetailsnoThe unique ID of the case decision.CASE_DECISION_ID SVR_INT64
objectiveIDdetails The unique ID of the objective.RULES_OBJECTIVE_ID SVR_STRING<16>
actionStatusdetails The action status of the sanction assessment.ACTION_STATUSSanctionAssessmentStatusSVR_STRING<10>
sanctionIDdetails The unique identifier of the sanction associated with the assessment.ISP_SANCTION_ID SVR_INT64
sanctionOverrideIDdetails The unique identifier of the sanction override associated with the assessment.ISP_SANCTION_OVERRIDE_ID SVR_INT64
Foreign Keys (1)
ChildParent
ISPSanctionAssessmentProc.caseIDCaseHeader.caseID
Indices (6)
Index NameAttributes
IND_3040145caseDecisionID
IND_1150121482objectiveID
IND_1392033575concernroleID
IND_984807573caseID
IND_1605190844sanctionID
IND_1952270504sanctionOverrideID
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: sanctionAssessmentID
This method inserts a new record into the ISPSanctionAssessmentProc table 
readByCaseDecisionAndObjectiveIDnsread This method fetches the record based on Case Decision and objective ID 
modifyActionStatusnsmodifyOPTIMISTIC_LOCKING: no
Modifies the action status field in the ISPSanctionAssessmentProc table. 
readread Reads the SanctionAssessmentProc record from the database. 
removeremove Remove the SanctionAssessmentProc record from the database. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies the SanctionAssessmentProc record in the database. 
readByCaseIDreadmulti This method reads all the records based on CaseID 
removeByIntegratedCaseIDnsremove This method removes a record identified by the unique integrated case id from the ISPSanctionAssessmentProc table 
insertSanctionAssessmentRecordsbatchinsert This method does batch insert of sanction assessment records 
modifyActionStatusBySanctionIDnsmodify This method modifies the status of the record identified by Sanction ID 
modifyActionStatusByOverrideIDnsmodify This method modifies Action status recognized by Sanction Override ID 
Related Pages (33)
CAProductHomeDetails
Check Eligibility (CheckEligibility)
Check Eligibility (CheckMAEligibility)
Check Eligibility (CheckMAEligibilityFromIC)
CHIPProductHomeDetails
CREOLECAProductHomeDetails
CREOLECHIPProductHomeDetails
CREOLEFAProductHomeDetails
CREOLEMAProductHomeDetails
FAProductHomeDetails
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromICHome)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromPDHome)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibility)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibilityFromMenu)
ISPCaseHomeDetails
Check Retroactive Medical Assistance Eligibility (ISPCheckRetroactiveEligibilityPDHomeFromMenu)
LIFCProductHomeDetails
LTCProductHomeDetails
ProductHomeDetails
RefugeeProductHomeDetails
Delete Member Sanction Details (SanctionAssessment_cancelSanction)
Delete Member Sanction Override Details: (SanctionAssessment_cancelSanctionOverride)
New Sanction (SanctionAssessment_createSanction)
Sanctions: (SanctionAssessment_createSanctionOrSanctionOverride)
New Recommendation Disregard (SanctionAssessment_createSanctionOverride)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)
Recommendations (SanctionAssessment_recommendations)
Sanction Recommendations (SanctionAssessment_SanctionResults)
SanctionAssessment_viewSanction
View Member Sanction Override Details (SanctionAssessment_viewSanctionOverride)
SpendDownProductHomeDetails
TBBCCProductHomeDetails