Table Description
Sanction Override: A manual override created for a sanction recommendation which the system has determined a potential sanction with respect of a person failure to comply with a program's requirements.

System processing determines if sanctions should be imposed on an individual based on the evidence recorded on the case, or their failure to meet specific program requirements. Rules determine if any of the evidence recorded on the case should be reviewed by a case worker as it may be subject to a potential sanction. The rules also define the details of the sanction that should be imposed in respect of the evidence. The output of the rules provides the user with the sanction recommendation necessary to investigate the specific evidence, and manually create the appropriate sanction , or to use their discretion and manually create a sanction override.

If a sanction override is created for a person in respect of a specific program requirement failure, rules will ignore the potential sanction for the duration of the sanction override.

Example

John Smith violates a condition of federal or state parole. John Smith is in receipt of Food Assistance (US) and Cash Assistance (US). John Smith fails sanction assessment due to his parole violation. A case worker creates a sanction override for John Smith with details of the duration of the sanction override for both programs. John Smith is eligible for the Food Assistance and Cash Assistance programs for the duration of the sanction override.

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::SanctionOverride::SanctionOverride
Controlling File: ISProduct\model\Service Layer\entity\Case\SanctionOverride\SanctionOverride_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
sanctionOverrideIDkeynoSystem generated unique identifier for the sanction override.ISP_SANCTION_OVERRIDE_ID SVR_INT64
concernRoleIDdetailsnoThe concern role ID of a person for whom the sanction override is created.CONCERN_ROLE_ID SVR_INT64
programdetails The program for which the sanction override is created.ISP_SANCTION_PROGRAMSanctionProgramSVR_STRING<10>
sanctionReasondetails The reason the sanction override is created. This is populated from the sanction override reason code table.ISP_SANCTION_REASONSanctionReasonSVR_STRING<10>
startDatedetails The start date of the sanction override.CURAM_DATE SVR_DATE
endDatedetails The end date of the sanction override.CURAM_DATE SVR_DATE
statusCodedetails The status of the sanction override.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Details relating to the sanction override.RICH_TEXT SVR_STRING<131072>
numberOfMonthsdetails The number of months the sanction override is created for.EVD_NUMBER_OF_MONTHS SVR_INT32
caseIDdetailsyesCase ID of the case from where the sanction override is recorded.CASE_ID SVR_INT64
createdBydetailsyes CONCERN_ROLE_NAME SVR_STRING<131>
createdOndetailsyes CURAM_DATETIME SVR_DATETIME
Foreign Keys (1)
ChildParent
SanctionOverride.concernRoleIDConcernRole.concernRoleID
Indices (2)
Index NameAttributes
SnovrdCroleIDIdxconcernRoleID
IND__811474713caseID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: sanctionOverrideID
PRE_DATA_ACCESS: yes
Inserts the SanctionOverride record to the database 
readread Reads the SanctionOverride record from the database. 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Modifies the SanctionOverride record 
removeremove Removes the SanctionOverride record from the database. 
readSanctionOverrideParticipantNamens Returns Income Support Product Sanction Override Evidence details including the participant's full name.SQL
searchByConcernRoleIDnsreadmulti Read all Sanction Override for the given case participant 
readSanctionStatusnsread Reads the record status of a sanction override record. 
countDuplicatesnsPRE_DATA_ACCESS: yes
 
Check thats a sanction override record exists already, with the same sanction reason, program and within the same sanction date range, for the household member. SQL
searchByCaseIDnsreadmulti Read&nbsp;all&nbsp;Sanction&nbsp;Override&nbsp;for&nbsp;a given case ID. 
Related Pages (26)