Table Description
Allegation: Details of an allegation.

Details of an allegation.

Example

For example, Mary Smith alleges that John Smith has committed sexual abuse on his daughter Linda Smith. The abuse has taken place in the home on 16 June 2006.

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::Core::Reference Model::Service Layer::Allegation::Entity::Allegation
Controlling File: core\model\Packages\Reference Model\Service Layer\Allegation\Entity\Allegation_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
allegationIDkeynoUnique reference number assigned by the system to the allegation record.ALLEGATION_ID SVR_INT64
caseIDdetailsnoUnique reference number of the case header record created for the allegation.CASE_ID SVR_INT64
typedetails The type of allegation, e.g. sexual abuse, child neglect, benefit fraud.ALLEGATION_TYPE_CODEAllegationTypeSVR_STRING<10>
allegationDateTimedetails The date and time that the allegation took place.CURAM_DATETIME SVR_DATETIME
methoddetails The method by which the allegation was made, e.g. phone, email.ALLEGATION_METHOD_CODEAllegationMethodSVR_STRING<10>
locationdetails The location of the allegation.ALLEGATION_LOCATION_CODEAllegationLocationSVR_STRING<10>
descriptiondetails Textual description of the allegation.ALLEGATION_DESCRIPTION SVR_STRING<40000>
creationDatedetails Date the allegation was recorded on the system.CURAM_DATE SVR_DATE
reportedDateTimedetails The date and time that the allegation was reported.CURAM_DATETIME SVR_DATETIME
recordStatusdetails Status of the allegation record. The values are 'Active' or 'Canceled'. Logical deletion is supported.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
sourceCaseParticipantRoleIDdetails Source of the allegation.CASE_PARTICIPANT_ROLE_ID SVR_INT64
anonymousInddetails Indicator to denote whether on not the source is anonymous.BOOLEAN_TYPE SVR_BOOLEAN
addressIDdetails The location of the allegation.ADDRESS_ID SVR_INT64
Foreign Keys (1)
ChildParent
AllegationRole.allegationIDAllegation.allegationID
Indices (2)
Index NameAttributes
allegatnCaseIDIdxcaseID
sourceRoleIDCaseStatusIdxsourceCaseParticipantRoleID, caseID, recordStatus
Operations (10)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: allegationID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyPRE_DATA_ACCESS: yes
Standard Operation 
searchByInvestigationCaseIDnsreadmulti   
validate    
searchBySourceCaseIDStatusnsreadmulti Returns a list of allegations using the source case participant role id and case id. 
searchByActionIDnsmultiPRE_DATA_ACCESS: yes
 
Method to search Allegation details list for specified Action.SQL
searchActiveUnassignedForActionByCaseIDnsmultiPRE_DATA_ACCESS: yes
 
Method to search active Allegation Details list which are not assigned to Action by case id.SQL
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
  
searchByActiveInvestigationCaseIDnsreadmulti   
Related Pages (54)
Add Existing Situations to Action (Action_associateSituations)
New Situation for Action (Action_createSituations)
Delete Action Plan (ActionPlan_cancelActionPlan)
Edit Attachment (Attachment_modify)
Edit Attachment (CalendarMeetingMinutes_modifyAttachmentFromList)
Home (ICInvestigationSample_home)
Allegations (ICInvestigationSample_listAllegation)
- (Investigation_homeTabDetails)
Investigation_homeTabDetailsPreview
InvestigationDelivery_allegationAttachmentDetails
Allegation (InvestigationDelivery_allegationHomeTab)
InvestigationDelivery_allegationParticipantDetails
InvestigationDelivery_allegationSourceDetails
Delete Allegation (InvestigationDelivery_cancelAllegation)
New Allegation (InvestigationDelivery_createAllegation)
Add Attachment (InvestigationDelivery_createAllegationAttachment)
Add Participant (InvestigationDelivery_createAllegationRole)
New Finding (InvestigationDelivery_createFinding)
Add Resolution (InvestigationDelivery_createResolution)
Allegations (InvestigationDelivery_listAllegation1)
List Allegation for Action (InvestigationDelivery_listAllegationForAction)
Finding History (InvestigationDelivery_listFindingHistory)
Edit Allegation (InvestigationDelivery_modifyAllegationFromList)
Edit Allegation (InvestigationDelivery_modifyAllegationFromView)
Edit Allegation Participant (InvestigationDelivery_modifyAllegationRole)
Edit Finding (InvestigationDelivery_modifyFinding)
Override Finding (InvestigationDelivery_overrideFinding)
Remove Participant (InvestigationDelivery_removeAllegationRole)
View Allegation: (InvestigationDelivery_viewActionAllegation)
View Action: (InvestigationDelivery_viewActionFromActionPlan)
View Action (InvestigationDelivery_viewActionFromActionPlanTransaction)
View Action: (InvestigationDelivery_viewActionFromList)
View Allegation: (InvestigationDelivery_viewAllegation)
View Allegation (InvestigationDelivery_viewAllegationFromHome)
View Allegation (InvestigationDelivery_viewAllegationTransaction)
View Finding (InvestigationDelivery_viewFindingFromList)
Home (InvestigationSample_home)
InvestigationSample_listAllegation
Edit Attachment (MeetingMinutes_modifyAttachmentFromList)
Edit Attachment (MeetingMinutes_modifyAttachmentFromListFromAgenda)
Edit Attachment (MeetingMinutes_modifySingleAttachment)
Allegations: (ProviderInvestigation_listAllegation)
Home (ProviderManagement_investigationHome)
Edit Attachment (ProviderManagement_modifyIncidentAttachment)
- (ProviderManagement_viewProviderInvestigationTabDetails)
New Situation (Situation_createSituation)
Allegations Associated to Situation (Situation_listAllegations)
Edit Situation (Situation_modifySituation)
View Allegation (Situation_viewAllegationPopup)
View Situation (Situation_viewSituation)
Edit Attachment (SocialEnterpriseFolder_modifyAttachmentFromList)
Edit Attachment (SocialEnterpriseFolder_modifyAttachmentFromView)
Modify File: (SocialEnterpriseFolder_modifyIncidentFileFromList)
Modify File: (SocialEnterpriseFolder_modifyIncidentFileFromView)