Table Description
LegalAction: A type of case that defines legal processes associated with a case participant involved with the organization that may include judicial involvement.

Legal action may require involvement of court but all legal actions do not escalate to that point. In case of judicial involvement, multiple Hearing can be associated with a legal action for a legal action of type Hearing

Example

Crystal Jones was no longer attending high school, but frequently would visit her friends in the smoking section during breaks, as she lived nearby.Professors reported this information to the school Principle and the police were called. Crystal took flight with the police officer in pursuit on foot.Before long the officer was able to apprehend Crystal, explain the charge and her rights, and detain her. She was brought back to the station where she consented to a search by a female officer and a sizable amount of marijuana was seized. As she demonstrated that she was a potential flight risk, she was detained pending a Bail Court Hearing within 24 hours. At the court appearance of Crystal, both Prosecution and Defense Counsels presented pertinent evidence and information related to Crystal and the incident. A Judicial Interim Release (bail) Hearing was held because Crystal had been detained. The court supported the decision to continue with secure detention during court proceedings.

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::Appeals::Legal Action::Entity::LegalAction
Controlling File: Appeal\model\Packages\LegalAction\Entity\Entity_cat.efx
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
legalActionIDkeynoUnique ID of the Legal Action.INTERNAL_ID SVR_INT64
caseIDdetailsnoUnique ID of the case header record that is created for the legal action case.caseID of the CaseHeader CASE_ID SVR_INT64
configLegalActionCategoryIDdetails Configured Legal Category ID of the AdminLegalCategory INTERNAL_ID SVR_INT64
configLegalActionIDdetails Configured Legal Action ID of the AdminLegalAction INTERNAL_ID SVR_INT64
creationDatedetails System driven Legal Action creation dateCURAM_DATE SVR_DATE
startDatedetails Start date of the Legal actionCURAM_DATE SVR_DATE
endDatedetails End date of the Legal actionCURAM_DATE SVR_DATE
commentsdetails Free-form textual comments that are entered by the userCOMMENTS SVR_STRING<300>
decisiondetails Outcome of the Legal ActionCOMMENTS SVR_STRING<300>
statusCodedetails Code value to denote the legal action status like active, canceled, completed.LEGAL_ACTION_STATUS_CODELegalActionStatusSVR_STRING<10>
orgParticipantCodedetails Code value to denote whether Organization is a Petitioner, Respondent or ParticipantLEGAL_ACTION_ORG_TYPE_CODECaseParticipantRoleTypeSVR_STRING<10>
locationIDdetails Location ID of the court office. Location ID of the ExternalPartyOffice EXTERNALOFFICE_LOCATION_ID SVR_INT64
adjudicateIDdetails The person issuing the order. Usually will be a judge, but could be another person in the legal system. Office Member ID of the judge. Office Member ID of the ExternalPartyOfficeMember INTERNAL_ID SVR_INT64
Foreign Keys (1)
ChildParent
LegalAction.caseIDCaseHeader.caseID
Indices (1)
Index NameAttributes
LegalActionCaseIDIdxcaseID
Operations (16)
OperationStereotypeOptionsDescriptionSQL
insertinsertPOST_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyPOST_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
searchLegalActionsByCaseIDnsmulti Returns list of legal actions associated with a case.SQL
readByLegalActionCaseIDnsread Return Legal action details based on the legal action ID 
readLegalActionNameByCaseIDns Returns the Legal Action Name based on the Legal Action Case IDSQL
readHomePageByCaseIDns Return Legal Action Home Page name by Legal Action CaseSQL
countActiveLegalCaseParticipantsns Returns number of active participants in a legal action.SQL
searchRelatedLegalActionsnsmulti Returns list of related legal actions for a case.SQL
searchLegalActionsForAssociationnsmulti Returns list of unassociated legal actions for a case.SQL
searchLegalActionsForCaseParticipantnsmulti Returns all the legal actions for a case participant.SQL
readCourtLocationJudgeByCaseIDns Reads the court location (address and geo code)&nbsp;and details pertaining to the judge whose ID was specified.&nbsp;SQL
searchLegalActionParticipantsTabDetailnsmultiPOST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
 
 SQL
countActiveLegalActionsByCaseIDnsPRE_DATA_ACCESS: yes
 
<span lang="EN-IE" style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-ansi-language: EN-IE; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Counts the active Legal Actions associated with a case.</span>SQL
countActiveLegalActionsByParticipantIDnsPRE_DATA_ACCESS: yes
 
<span lang="EN-IE" style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-ansi-language: EN-IE; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Count the number of active Legal Actions where the participant has a role.</span>SQL
Related Pages (60)
Legal Actions (AdminLegalAction_listLegalActionPopup)
Schedule Hearing (Appeal_displaySchedule_HearingReview)
Schedule Hearing Review (Appeal_displaySchedule_HearingReviewForIC)
Schedule Hearing (Appeal_displaySchedule_HomeHearing)
Schedule Hearing (Appeal_displaySchedule_HomeHearingForIC)
Schedule Hearing (Appeal_displaySchedule_HomeHearingForIC1)
Schedule Hearing REVIEW (Appeal_displaySchedule_IssueHearingReviewForIC)
Schedule Hearing (Appeal_displaySchedule_IssueHomeHearingForIC)
Schedule Hearing (Appeal_displaySchedule_IssueLocationHearingIC)
Schedule Hearing (Appeal_displaySchedule_IssuePhoneHearingForIC)
Schedule Hearing (Appeal_displaySchedule_LocationHearing)
Schedule Hearing (Appeal_displaySchedule_LocationHearingIC)
Schedule Hearing (Appeal_displaySchedule_PhoneHearing)
Schedule Hearing (Appeal_displaySchedule_PhoneHearingForIC)
Schedule Hearing (Appeal_displaySchedule_PhoneHearingForIC1)
Add Legal Action Participants (LegalAction_addParticipant)
Associate Legal Actions (LegalAction_associateLegalAction)
Delete Legal Action (LegalAction_cancel)
Cancel Legal Action Record (LegalAction_cancelLegalAction)
Close Case (LegalAction_close)
New Decision (LegalAction_createDecision)
New Hearing (LegalAction_createHearing)
New Legal Action (LegalAction_createLegalAction)
New Legal Order (LegalAction_createOrder)
New Petition (LegalAction_createPetition)
New Statement (LegalAction_createStatement)
Legal Actions (LegalAction_listHearingAssociatedLA)
Legal Action Participants (LegalAction_listHearingParticipants)
Legal Actions (LegalAction_listLegalActionPopup)
Legal Actions (LegalAction_listLegalActions)
Legal Action Participants (LegalAction_listLegalParticipants)
Legal Actions (LegalAction_listOrderAssociatedLA)
Legal Action Participants (LegalAction_listOrderParticipants)
Legal Actions (LegalAction_listPetitionAssociatedLA)
Legal Action Participants (LegalAction_listPetitionParticipants)
Manage Decision (LegalAction_manageDecision)
Decisions (LegalAction_manageDecision1)
Edit Hearing (LegalAction_modifyHearing)
Edit Legal Order (LegalAction_modifyOrder)
Edit Participant Legal Status (LegalAction_modifyParticipantStatus)
Edit Petition (LegalAction_modifyPetition)
View Participant Legal Status (LegalAction_readParticipantStatus)
Schedule Hearing (LegalAction_scheduleHearing)
View Hearing (LegalAction_viewHearing)
LegalAction_viewHearingTabDetails
View Legal Action (LegalAction_viewLegalAction)
LegalAction_viewOrder
View Legal Action (LegalAction_viewOrderConditions)
View Requirements and Conditions (LegalAction_viewOrderRequirements)
LegalAction_viewOrderTabDetails
LegalAction_viewPetition
LegalAction_viewPetitionTabDetails
Legal Actions (LegalStatus_listLegalActionForCasePopup)
Legal Status (LegalStatus_listLegalStatusForCase)
Legal Status (LegalStatus_listLSForCaseMember)
Modify Legal Status (LegalStatus_modifyFromCase)
Modify Legal Status (LegalStatus_modifyFromCase1)
Legal Status (LegalStatus_modifyLSForCaseMember)
LegalStatus_viewFromCase
Legal Status (LegalStatus_viewLSForCaseMember)