Table Description
ISP Transfer Sanction Link: A link between a sanction and either a resource transfer or an automatic resource transfer.

The system executes rules on all resource transfer records to determine which transfers, if any, are sanctionable. Resource transfer is accessed from the resource transfer and ownership evidence entities as well as from the automatic resource transfer case. All sanctionable resource transfers for a household member are collated into one sanction detailing when the sanction starts and ends. A resource transfer sanction link is created to link each sanctionable resource transfer to the sanction.

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::ISPTransferSanctionLink::ISPTransferSanctionLink
Controlling File: ISProduct\model\Service Layer\entity\Case\ISPTransferSanctionLink\ISPTransferSanctionLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
transferSanctionIDkeynoSystem generated unique identifier for the transfer sanction.INTERNAL_ID SVR_INT64
sanctionIDdetailsnoSystem generated unique identifier for the sanction.ISP_SANCTION_ID SVR_INT64
linkedIDdetails Linked ID, foreign key to various resource transfer entities.INTERNAL_ID SVR_INT64
linkedTransferTypedetails Resource type of the transfer.CODETABLE_CODE SVR_STRING<10>
durationOfDisqualificationdetails Sanction duration.CURAM_AMOUNT SVR_MONEY
disqualificationStartDatedetails Start date of sanction penalty.CURAM_DATE SVR_DATE
endDatedetails End date of sanction penalty.CURAM_DATE SVR_DATE
commentsdetails Details relating to the transfer sanction.COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
ISPTransferSanctionLink.sanctionIDSanction.sanctionID
Indices (1)
Index NameAttributes
IND__1077132785sanctionID
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: transferSanctionID
PRE_DATA_ACCESS: no
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: no
Standard Operation 
readResourceTransferRelatedTransferSanctionListDetailsnsmulti Read resource transfer related sanction list that make up each sanction member record.SQL
readDetailsForISPResourceTransferSanctionns Read resource transfer sanction details for a resource transfer sanction.SQL
removeremove Standard Operation 
readDetailsForAutoISPResourceTransferSanctionns Read details for auto resource transfer type.SQL
readDetailsForOwnershipSanction  Read resource transfer sanction details for an ownership sanction. 
countTransferLinksForSanctionns Returns the number of existing transfer link records for a particular sanctionID.SQL
readOwnershipRelatedTransferSanctionListDetailsnsmulti Read ownership related sanctions list that make up each sanction member record.SQL
readTransferSanctionListDetails  Read sanctions list that make up each sanction member record. 
Related Pages (12)