Table Description
HearingParticipation: stores the details of legal participants
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::Service Layer::entity::Hearing::Hearing Participation::HearingParticipation
Controlling File: Appeal\model\Packages\Service Layer\entity\Hearing\Hearing Participation\Hearing Participation_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
hearingParticipationIDkeynoUnique generated IdINTERNAL_ID SVR_INT64
caseParticipantRoleIDdetailsnoA case participant who added as a legal participant for a hearingCASE_PARTICIPANT_ROLE_ID SVR_INT64
participatedCodedetails Says the status of legal participant,such as participated,no show and not heldPARTICIPATION_CODEHearingParticipationSVR_STRING<10>
hearingIDdetailsnoUsed to represents a legal participant is part of a hearingHEARING_ID SVR_INT64
caseIDdetailsnoUsed to represents a legal participant is part of a caseCASE_ID SVR_INT64
inPersonIndicatordetails  CURAM_INDICATOR SVR_BOOLEAN
Foreign Keys (3)
ChildParent
HearingParticipation.caseIDCaseHeader.caseID
HearingParticipation.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
HearingParticipation.hearingIDHearing.hearingID
Indices (3)
Index NameAttributes
IND_1335869469hearingID
IND__144356446caseParticipantRoleID
IND__296353219caseID
Operations (13)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: hearingParticipationID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchHearingParticipantsByHearingIDnsmulti Lists all the legal participants for a hearingSQL
modifyParticipatedCodensmodify modifies the status of legal participants.such as participated,no show and not held 
countActiveByHearingAndParticipationns Provides the count of legal participants whose status is notHeld for a hearingSQL
modifyNonParticipationnsmodify COMMENTS=Sets the participation code to no show for all the service suppliers that didn't participate. PRE_DATA_ACCESS=yes  
cancelCaseParticipantRoleOnHearing    
countHearingParticipantsByCaseIDTypeStatusns This method retrieves the count of participants who have not participated in the hearing.SQL
countHearingAppellantsns This methods retrieves the appellants for a particular hearing.SQL
readParticipatedCodeByCaseParticipantRoleIDnsread This methods reads the participated code of the hearing participant. 
searchParticipantsByHearingIDParticipantTypensmulti  SQL
Related Pages (98)
Add Resolution to Appealed Items (Appeal_addResolutionToAppealedItems)
Adjourn Hearing (Appeal_adjournHearing)
Adjourn Hearing (Appeal_adjournHearingForIC)
Adjourn Hearing (Appeal_adjournHearingReview)
Complete Hearing (Appeal_completeDeskHearing)
Complete Hearing (Appeal_completeHearing)
Complete Hearing (Appeal_completeHearingForIC)
Complete Hearing (Appeal_completeHearingReviewHearing)
Confirm Location Hearing (Appeal_confirmExternalLocationHearingIC)
Confirm Hearing Review (Appeal_confirmHearing_HearingReviewForIC)
Confirm Hearing Review (Appeal_confirmHearingReviewHearing)
Confirm Hearing Review (Appeal_confirmHearingReviewHearingForIC)
Confirm Home Hearing (Appeal_confirmHomeHearing)
Confirm Home Hearing (Appeal_confirmHomeHearingIC)
Confirm Home Hearing (Appeal_confirmHomeHearingType)
Confirm Home Hearing (Appeal_confirmHomeHearingTypeIC)
Confirm Location Hearing (Appeal_confirmIssueExternalLocationHearingIC)
Confirm Location Hearing (Appeal_confirmIssueLocationHearingIC)
Confirm Location Hearing (Appeal_confirmLocationHearing)
Confirm Location Hearing (Appeal_confirmLocationHearingIC)
Confirm Phone Hearing (Appeal_confirmPhoneHearing)
Confirm Phone Hearing (Appeal_confirmPhoneHearingIC)
Confirm Phone Hearing (Appeal_confirmPhoneHearingType)
Confirm Phone Hearing (Appeal_confirmPhoneHearingTypeIC)
Confirm Reschedule External Location Hearing (Appeal_ConfirmReScheduleExternalLocationHearingIC)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleHearingReviewHearing)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleHearingReviewHearingForIC)
Confirm Reschedule Home Hearing (Appeal_confirmRescheduleHomeHearing)
Confirm Reschedule Home Hearing (Appeal_confirmRescheduleHomeHearingIC)
Confirm Reschedule Location Hearing (Appeal_confirmRescheduleLocationHearing)
Reschedule Hearing (Appeal_confirmRescheduleLocationHearingIC)
Confirm Reschedule Telephone Hearing (Appeal_confirmReschedulePhoneHearing)
Reschedule Telephone Hearing (Appeal_confirmReschedulePhoneHearingIC)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleReviewHearingDateTimeForIC)
New Appellant (Appeal_createAppellant)
Home (Appeal_hearingCaseHearingHome)
Hearing Home (Appeal_hearingCaseHearingHomeDetails)
Home (Appeal_hearingCaseHearingHomeForIC)
Home (Appeal_hearingCaseHearingHomeViewOnly)
Hearing Case Home (Appeal_hearingCaseHome)
Appeal_hearingCaseHomeDetailsForIC
Home (Appeal_hearingCaseHomeForIC)
Home (Appeal_hearingCaseHomeForICAndCancelledInd)
Hearing Case (Appeal_hearingCaseHomeViewOnly)
Hearing Case Home (Appeal_hearingCaseIssueHomeForIC)
Hearing Case Home (Appeal_hearingCaseIssueHomeViewOnly)
Attendees (Appeal_listAttendee)
Hearings (Appeal_listHearingCaseHearing)
Hearings (Appeal_listHearingCaseHearingForIC)
Hearings (Appeal_listHearingCaseIssueHearingForIC)
Items Under Appeal (Appeal_listItemsUnderAppeal)
Appeal Objects (Appeal_listObjectsByAppeal)
Appeal_listParticipantAttendeeIC
Manage Decision (Appeal_manageHearingCaseDecisionForIC)
Decisions (Appeal_manageHearingReviewDecisionForIC)
Manage Decision (Appeal_manageJudicialReviewDecisionForIC)
Reopen Hearing Case (Appeal_reopenHearingCase)
Reopen Hearing Case (Appeal_reopenHearingIssueCase)
Reschedule Desk-Based Hearing (Appeal_rescheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleIssueDeskHearing)
Appeals (Application_listAppeals)
Items Under Appeal (Application_listItemsUnderAppeal)
ApplicationContextPanel
CAProductHomeDetails
CGISSApplicationContextPanel
CGISSApplicationContextPanel1
CHIPProductHomeDetails
CREOLECAProductHomeDetails
CREOLECHIPProductHomeDetails
CREOLEFAProductHomeDetails
CREOLEMAProductHomeDetails
FAProductHomeDetails
Appeals (ISP_listAppeals)
ISPCaseHomeDetails
Add Legal Action Participants (LegalAction_addParticipant)
Legal Actions (LegalAction_listHearingAssociatedLA)
Legal Action Hearings (LegalAction_listHearings)
Legal Actions (LegalAction_listOrderAssociatedLA)
Legal Actions (LegalAction_listPetitionAssociatedLA)
Legal Action Hearings (LegalAction_listScheduledHearings)
Edit Hearing (LegalAction_modifyHearing)
Edit Legal Order (LegalAction_modifyOrder)
Edit Petition (LegalAction_modifyPetition)
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_viewPetition
LIFCProductHomeDetails
LTCProductHomeDetails
ProductHomeDetails
RefugeeProductHomeDetails
SpendDownProductHomeDetails
TBBCCProductHomeDetails