Table Description
Sanction: A penalty that is imposed on a person who fails to comply with a program's requirements.

In general, sanctions are imposed on a person for the period of time that the person does not comply with a program's requirements.

For certain programs if a sanction is imposed on a person they can be ineligible for that program or receive a reduced benefit amount. Certain sanctions can make the whole household ineligible.

Example

John Smith violates a condition of federal or state parole. John Smith is in receipt of Food Assistance (US) and Cash Assistance (US). A case worker creates a sanction record for John Smith with details of his violation and the duration of the penalty period for both programs. John Smith is ineligible for the Food Assistance (US) and Cash Assistance (US) programs for the period of time the parole violation occurs.
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::Case::Sanction::Sanction
Controlling File: ISProduct\model\Service Layer\entity\Case\Sanction\Sanction_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (15)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
sanctionIDkeynoSystem generated unique identifier for the sanction.ISP_SANCTION_ID SVR_INT64
concernRoleIDdetailsnoThe concern role ID of a person on whom the sanction is imposed.CONCERN_ROLE_ID SVR_INT64
sanctionReasondetails The reason the sanction was imposed. This is populated from the sanction reason code table.ISP_SANCTION_REASONSanctionReasonSVR_STRING<10>
sanctionLeveldetails The level of sanction imposed e.g. first, second etc.ISP_SANCTION_LEVELSanctionLevelSVR_STRING<10>
sanctionStartDatedetails The start date of the sanction.CURAM_DATE SVR_DATE
sanctionEndDatedetails The end date of the sanction.CURAM_DATE SVR_DATE
commentsdetails Details relating to the sanction.RICH_TEXT SVR_STRING<131072>
statusCodedetails The status of the sanction.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
programdetails The program for which the sanction is imposed. This is populated from the sanction program code table. ISP_SANCTION_PROGRAMSanctionProgramSVR_STRING<10>
numberOfMonthsdetails The number of months the sanction is imposed for.EVD_NUMBER_OF_MONTHS SVR_INT32
caseIDdetailsyesCase ID of the case from where the sanction is recorded.CASE_ID SVR_INT64
nonCompliantConcernRoleIDdetailsyesThe Concern Role ID of a person who is not complying with the program requirements.CONCERN_ROLE_ID SVR_INT64
conciliationProcInddetails This indicates whether the conciliation process has been carried out before imposing a sanction on a claimant. CURAM_INDICATOR SVR_BOOLEAN
createdBydetailsyes CONCERN_ROLE_NAME SVR_STRING<131>
createdOndetailsyes CURAM_DATETIME SVR_DATETIME
Foreign Keys (2)
ChildParent
Sanction.concernRoleIDConcernRole.concernRoleID
ISPTransferSanctionLink.sanctionIDSanction.sanctionID
Indices (2)
Index NameAttributes
SanctionConcernRoleIDIdxconcernRoleID
IND_323410771caseID
Operations (13)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: sanctionID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
readDetailsns Returns Income Support Product Sanction Evidence details including the participant's full name.SQL
validateDetails  Validates the Sanction entity details. 
readCaseParticipantsByEvidenceIDnsread Returns all related caseParticipantRoleID's for a specified Sanction ID. 
countDuplicatesnsPRE_DATA_ACCESS: yes
 		Check thats a sanction record exists already, with the same sanction reason, sanction level, program and within the same sanction date range, for the household member. SQL
readSanctionStatusnsread Reads the record status of a sanction record. 
searchListDetailsnsreadmulti   
searchByConcernRoleIDnsreadmulti To retrieve a list of all sanction records by caseParticipantRoleID 
searchByConcernRoleIDStatusnsreadmulti Search for ISP Sanction evidence by case participant role ID and the record status code 
searchByCaseIDnsreadmulti To&nbsp;retrieve&nbsp;a&nbsp;list&nbsp;of&nbsp;all&nbsp;sanction&nbsp;records&nbsp;by&nbsp;case ID 
Related Pages (51)
CAProductHomeDetails
Check Eligibility (CheckEligibility)
Check Eligibility (CheckMAEligibility)
Check Eligibility (CheckMAEligibilityFromIC)
Renew Chip Product Delivery (Chip_RenewProductDelivery)
CHIPPremiumsProductHomeDetails
CHIPProductHomeDetails
CREOLECAProductHomeDetails
CREOLECHIPProductHomeDetails
CREOLEFAProductHomeDetails
CREOLEMAProductHomeDetails
FAProductHomeDetails
Sanctions (Individual_listSanctionEvidence)
Individual_viewSanctionDetails
Cancel Sanction (ISP_cancelSanctionEvidence)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromICHome)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromPDHome)
New Sanction (ISP_createSanctionEvidence)
New Disregard (ISP_createSanctionOverride)
Sanctions (ISP_listSanctionEvidence)
Edit Sanction (ISP_modifySanctionEvidence_fromList)
Edit Sanction (ISP_modifySanctionEvidence_fromView)
Edit Disregard (ISP_modifySanctionOverride_fromList)
Modify Sanction Override Details: (ISP_modifySanctionOverride_fromView)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibility)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibilityFromMenu)
ISP_viewSanctionDetails
View Member Sanction Details: (ISP_viewSanctionEvidence)
ISPCaseHomeDetails
Check Retroactive Medical Assistance Eligibility (ISPCheckRetroactiveEligibilityPDHomeFromMenu)
Sanctions (ISPPerson_listSanctionEvidence)
ISPPerson_viewSanctionDetails
LIFCProductHomeDetails
LTCProductHomeDetails
ProductHomeDetails
RefugeeProductHomeDetails
Delete Member Sanction Details (SanctionAssessment_cancelSanction)
New Disregard (SanctionAssessment_createDisregard_CREOLE)
New Sanction (SanctionAssessment_createSanction)
New Sanction (SanctionAssessment_createSanction_CREOLE)
Sanctions: (SanctionAssessment_createSanctionOrSanctionOverride)
New Recommendation Disregard (SanctionAssessment_createSanctionOverride)
Sanctions (SanctionAssessment_listSanctions)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)
Recommendations (SanctionAssessment_recommendations_CREOLE)
SanctionAssessment_viewSanction
View Sanction (SanctionAssessment_viewSanctionDetails)
SpendDownProductHomeDetails
Renew TB Product Delivery (TBBCC_RenewProductDelivery)
TBBCCProductHomeDetails