Table Description
InternalAssistanceHistory: Details of the benefits received in the current state are stored as part of InternalAssistanceHistory, which captures - Household member, From month, From year, To month, To year, Number of months, Program Type
Model Details
Location in Model: Logical View::MetaModel::Curam::Income Support Product::Service Layer::entity::InternalAssistanceHistory::InternalAssistanceHistory
Controlling File: ISProduct\model\Service Layer\entity\InternalAssistanceHistory\InternalAssistanceHistory_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
internalAssistanceHistoryIDkeynoSystem generated unique identifier for the InternalAssistanceHistoryINTERNAL_ASSISTANCE_HISTORY_ID SVR_INT64
caseParticipantRoleIDdetails The internal system identifier of the household member who is subject to the federal time limit requirementsCASE_PARTICIPANT_ROLE_ID SVR_INT64
caseIDdetails The internal system identifier of the product delivery on which the payment processing has identified countable InternalAssistanceHistory Months. This holds the Product Delivery Case ID.CASE_ID SVR_INT64
startMonthdetails start month of assistance receivedEVD_MONTHMonthSVR_STRING<10>
startYeardetails start year of assistance receivedYEAR SVR_INT32
endMonthdetails end month of assistance receivedEVD_MONTHMonthSVR_STRING<10>
endYeardetails end year of assistance receivedYEAR SVR_INT32
numberOfMonthsdetails Number of months within the period From and To, including the From date and the To date. For example, if the period from is May/2006 and the period to is Dec/2006 the number of months is 8EVD_NUMBER_OF_MONTHS SVR_INT32
statusdetails Code value to indicate record statusRECORD_STATUS_CODERecordStatusSVR_STRING<10>
programTypedetails Code value to indicate program type.EVD_ASSISTANCE_TYPE_CODEAssistanceTypeSVR_STRING<10>
Indices (2)
Index NameAttributes
IntAssisHistCPRoleIdxcaseParticipantRoleID, status, programType
IntAssisHistPCIdxcaseID, programType
Operations (10)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: internalAssistanceHistoryID
Standard Insert on InternalAssistanceHistory month. 
readread Standard read on InternalAssistanceHistory. 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard modify on InternalAssistanceHistory month. 
removeremove Standard remove on InternalAssistanceHistory month. 
searchByParticipantStatusandProgramreadmulti Returns the InternalAssistanceHistory records by status and person. 
searchByProductDeliveryCaseIDAndTypereadmulti Returns the InternalAssistanceHistory records by product delivery case and program type. 
searchByCaseIDnsmulti This method reads all the InternalAssistanceHistory record for a Integrated Case IDSQL
modifyStatusnsmodifyOPTIMISTIC_LOCKING: yes
Updates the status of InternalAssistanceHistory record for InternalAssistanceHistoryKey 
addInternalAssistanceHistorybatchinsert This method does batch insert of InternalAssistanceHistory records 
searchByProductDeliveryCaseIDTypeAndStatusreadmulti COMMENTS=Returns the InternalAssistanceHistory records by product delivery case , program type and status 
Related Pages (19)