Table Description
Hearing Representative: A participant who attends a hearing as a representative for either the appellant or the respondent of a hearing case.

Representatives are registered as part of creating other roles rather than as an independent business process. These other roles are contracts for participants, correspondents for participants or cases and case nominees.

Example

An example of a representative is a legal attorney who is hired to represent the appellant's interests at a hearing.

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::HearingRepresentative::HearingRepresentative
Controlling File: Appeal\model\Packages\Service Layer\entity\Hearing\HearingRepresentative\HearingRepresentative_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
hearingRepresentativeIDkeynoUnique ID for a hearing representative record.HEARING_REPRESENTATIVE_ID SVR_INT64
hearingIDdetailsnoUnique ID of the associated hearing. Links the hearing representative to the related hearing. HEARING_ID SVR_INT64
caseParticipantRoleIDdetailsnoUnique ID of the case participant role. Links the hearing representative to the related case participant role. CASE_PARTICIPANT_ROLE_ID SVR_INT64
feeAmountdetails Fee being charged by the representative for the hearing.CURAM_AMOUNT SVR_MONEY
feeApprovedCodedetails Approval status for a hearing representative's fee. The value can be 'Not Actioned', 'Approved' or 'Rejected'. FEE_APPROVED_CODEFeeApprovedSVR_STRING<10>
commentsdetails Free-form textual comments that are entered by the user.COMMENTS SVR_STRING<300>
participatedCodedetails This shows whether the hearing representative actually participated in the Hearing or not. The value can be 'Not Held', 'Attended' or 'No Show'. PARTICIPATION_CODEHearingParticipationSVR_STRING<10>
behalfOfCodedetails Who the representative is attending the hearing on behalf of. The representative can be attending on behalf of the appellant, respondent or third party (if applicable). BEHALF_OF_CODEOnBehalfOfSVR_STRING<10>
typeCodedetails Type of representative the hearing representative is. An example of a hearing representative type is a lawyer, family member or union representative. HEARING_REPRESENTATIVE_TYPE_CODEHearingRepresentativeSVR_STRING<10>
Foreign Keys (2)
ChildParent
HearingRepresentative.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
HearingRepresentative.hearingIDHearing.hearingID
Indices (1)
Index NameAttributes
HRHringIDCPRIdxhearingID, caseParticipantRoleID
Operations (26)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: hearingRepresentativeID
PRE_DATA_ACCESS: yes
Standard Operation 
readDetailsAndNamens Reads details about the hearing representative.SQL
modifyDetailsnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Modifies detail on a hearing representative 
searchByHearingIDnsmulti Returns the details of all the hearing representative for a given hearing case, including the name, which is stored in the concernRole table.SQL
modifyFeensmodifyOPTIMISTIC_LOCKING: yes
Modifies the fee details on a hearing representative. Allows the user to modify the fee amount and the fee approved code. 
readForModifyFeensread Reads the fields needed to modify fee details 
validateInsert  Validates that the details being inserted are correct. 
validateModify  Validates that the details being modified are correct 
validate  Common validate method 
modifyParticipatedCodensmodifyOPTIMISTIC_LOCKING: yes
Modifies the participatedCode of the hearing representative 
countActiveByHearingIDCaseParticipantRoleIDnsPRE_DATA_ACCESS: yes
 
Counts the number of active hearing representatives matching the given caseParticipantRole.SQL
searchActiveByHearingIDnsmultiPRE_DATA_ACCESS: no
 
Returns the details of all the active hearing representative for a given hearing case.SQL
readStatusCaseParticipantRoleIDns Reads the status and caseParticipantRoleID of the hearing representative.SQL
searchActiveHearingRepAndCaseParticipantRoleByHearingIDnsmultiPRE_DATA_ACCESS: yes
 
Retrieves a list the IDs of participantRole, concernRole and HearingRepresentative for a given hearing ID.SQL
searchActiveHearingRepAndCaseParticipantRoleByHearingCaseIDnsmultiPRE_DATA_ACCESS: yes
 
Retrieves a list the IDs of participantRole, concernRole and HearingRepresentative for a given hearing case ID.SQL
readCloneDetailsnsread Reads the details of a hearing representative needed to create a clone. 
searchActiveHearingRepNameAndCaseParticipantRoleByHearingIDnsmultiPRE_DATA_ACCESS: no
 
Return the active hearing representatives and their full names for a hearing.SQL
clone  Clones a hearing representative. 
readFeeNoticeDetailsnsread Returns the information for the fee notice. 
modifyNonParticipationnsmodifyPRE_DATA_ACCESS: yes
Sets the participation code to no show for all the representatives that didn't participate. 
readHearingIDCaseParticipantRoleIDnsread Reads the hearingID and caseParticipantRoleID. 
read  @superseded - replaced by readDetailsAndName 
modify  @superseded - replaced by modifyDetails 
updateNonParticipation  @superseded - replaced by modifyNonParticipation 
countActiveByHearingAndParticipationnsPRE_DATA_ACCESS: yes
 
Returns the number of active hearing representatives for a specified hearing and participation.SQL
readHearingIDByRepresentativeIDnsread   
Related Pages (70)
Adjourn Hearing (Appeal_adjournHearing)
Adjourn Hearing (Appeal_adjournHearingForIC)
Adjourn Hearing (Appeal_adjournHearingReview)
Approve Resolution (Appeal_approveDecision)
Cancel Appeal Hearing (Appeal_cancelHearingCase)
Cancel Hearing Case (Appeal_cancelHearingIssueCase)
Cancel Hearing Review (Appeal_cancelHearingReview)
Cancel Judicial Review (Appeal_cancelJudicialReview)
Delete Hearing Representative (Appeal_cancelRepresentative)
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)
Continue Hearing (Appeal_continueHearing)
Continue Hearing (Appeal_continueHearingReviewHearing)
New Hearing Representative (Appeal_createRepresentative)
Delete Hearing Representative (Appeal_IC_cancelHearingReviewRepresentative)
Delete Hearing Representative (Appeal_IC_cancelRepresentative)
Hearing Representatives (Appeal_IC_listHearingReviewRepresentative)
Representatives (Appeal_IC_listRepresentative)
Hearing Representatives (Appeal_IC_listRepresentativeOnDeskHearing)
Edit Hearing Representative Fee (Appeal_IC_modifyHearingReviewRepresentativeFee)
Edit Hearing Representative (Appeal_IC_modifyHearingReviewRepresentativeFromView)
Edit Fee (Appeal_IC_modifyRepresentativeFee)
Edit Hearing Representative (Appeal_IC_modifyRepresentativeFromList)
Edit Hearing Representative (Appeal_IC_modifyRepresentativeFromView)
View Hearing Representative Details (Appeal_IC_viewHearingReviewRepresentative)
View Hearing Representative Details (Appeal_IC_viewRepresentative)
Select Hearing Participant (Appeal_listActiveParticipants)
Select Hearing Participant (Appeal_listActiveParticipantsIC)
Attendees (Appeal_listAttendee)
Hearing Representatives (Appeal_listHearingReviewRepresentative)
Appeal_listParticipantAttendeeIC
Hearing Representatives (Appeal_listRepresentative)
Hearing Representatives (Appeal_listRepresentativeOnDeskHearing)
Edit Hearing Representative Fee (Appeal_modifyRepresentativeFee)
Edit Hearing Representative (Appeal_modifyRepresentativeFromList)
Edit Hearing Representative (Appeal_modifyRepresentativeFromView)
Reschedule Desk-Based Hearing (Appeal_rescheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleIssueDeskHearing)
Submit Resolution (Appeal_submitDecision)
View Hearing Representative Details (Appeal_viewRepresentative)
Schedule Hearing (LegalAction_scheduleHearing)