Table Description
Hearing User Role: An assignment of a user to a hearing and the nature of their participation in the hearing.

There are two types of user role case owner and supervisor. By default, the case owner is the user who created the case and the supervisor is their reporting manager. User can assigned with any of the roles.

Example

The system assigns the 'case owner' role to the user who creates a hearing case. This user is the individual who accepts the initial request for appeal. This user's participation in the scheduled hearing is recorded in the system.

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::HearingUserRole::HearingUserRole
Controlling File: Appeal\model\Packages\Service Layer\entity\Hearing\HearingUserRole\HearingUserRole_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
hearingUserRoleIDkeynoUnique ID for a hearing user role record.HEARING_USER_ROLE_ID SVR_INT64
hearingIDdetailsnoUnique ID of the associated hearing. Links the hearing user role to the related hearing.HEARING_ID SVR_INT64
caseUserRoleIDdetailsnoUnique ID of the associated case user role record. Links the hearing user role to the related case user role. CASE_USER_ROLE_ID SVR_INT64
participatedCodedetails User's participation in the hearing.PARTICIPATION_CODEHearingParticipationSVR_STRING<10>
Foreign Keys (2)
ChildParent
HearingUserRole.caseUserRoleIDCaseUserRole.caseUserRoleID
HearingUserRole.hearingIDHearing.hearingID
Indices (2)
Index NameAttributes
IND_118198693hearingID
IND__1635824010caseUserRoleID
Operations (28)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: hearingUserRoleID
PRE_DATA_ACCESS: yes
Insert a hearing user role record. 
readread Read a hearing user role record. 
searchActiveByHearingIDAndRoletypensmultiPRE_DATA_ACCESS: yes
 
Search for all of the active hearing user role records for the specified hearingID and user role type.SQL
searchByHearingIDAndStatusnsmulti Return all users of a particular status for a hearing.SQL
validateInsert  Entity level validation which is called prior to inserting a record. Ensures that all required fields are entered and valid. 
searchActiveAttendeesByHearingIDnsmultiPRE_DATA_ACCESS: yes
 
Returns the active attendees for a hearing. These include all user role types except that of a hearing official.SQL
clone  Clones the details of the identified hearing user role record for the specified hearing. The statusCode, participatedCode and activityID fields are defaulted for the new record. 
readCloneDetailsnsread Reads the details being cloned from the an existing hearing user role record. 
setDefaults  Sets the default values for a hearing user role record if they are not specified. 
searchActiveUserNameByHearingIDAndTypensmultiPRE_DATA_ACCESS: yes
 
Searches for the caseUserRoleID, userName and full name details for hearing users of a specified role for a hearing.SQL
searchAllByHearingIDAndTypensmulti Reads details about all users of the specified type for the hearing.SQL
searchActiveAttendeeNamesByHearingIDnsmultiPRE_DATA_ACCESS: yes
 
Returns the list of active attendee users together with their userName and display name for the hearing.SQL
modifyParticipatedCodensmodify Modifies the hearing participated code for a user. 
searchAllByHearingIDnsmulti Returns all users, regardless of their status, for a hearing.SQL
modifyNonParticipationnsmodifyPRE_DATA_ACCESS: yes
Sets the participation code to no show for all the that didn't participate. 
searchUserParticipationnsmultiPRE_DATA_ACCESS: yes
 
Returns the users participation status for the latest completed hearing for a case- this includes all user role types except that of a hearing official and interpreter.SQL
countActiveByHearingAndParticipationnsPRE_DATA_ACCESS: yes
 
Returns the number of active hearing user roles for a hearing with the specified participation.SQL
updateNonParticipation  @superseded - replaced by modifyNonParticipation 
readHearingIDnsread This method returns the hearingID associated with a given HearingUserRoleID. 
countActiveByHearingAndUserns This counts all active users for the specified hearing with the given userName.SQL
countActiveByHearingAndTypens Counts active caseUserRole records based on hearing|D, typeCode, and recordStatus (active).SQL
countActiveByHearingIDTypeAndUserns Counts active caseUserRole records for the specified hearing, with the given userName, typeCode and recordStatus (active).SQL
readHearingIDStatusAndRoleTypens Returns the hearing id and status, and the user type and status.SQL
readUserAttendeeDetailsns Returns multiple user details based on a hearingUserRoleID.SQL
readRoleHearingAndUserns Returns the hearingID, caseUserRoleID and userName parameters for a given hearingUserRoleIDSQL
readHearingParticipatedAndUserDetailsns Returns hearing and user status, type, participated, name and id, and the case user role record status.SQL
searchAllWithVersionNumbersByHearingIDAndTypensmulti Reads details, including versionNo, about all users of the specified type for the hearing.SQL
searchAllWithVersionNumbersByHearingIDnsmulti Returns all users, regardless of their status, including versionNo, for a hearing.SQL
Related Pages (121)
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)
Edit Document (Appeal_controlMSWord)
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)
Hearing Home (Appeal_hearingReviewHearingHome)
Hearing Review Home (Appeal_hearingReviewHome)
Appeal_hearingReviewHomeForEvent
Home (Appeal_hearingReviewHomeForIC)
Hearing Review (Appeal_hearingReviewHomeViewOnly)
Hearing Review Home (Appeal_hearingReviewIssueHomeForIC)
Hearing Review Home (Appeal_hearingReviewIssueHomeViewOnly)
Hearing Home (Appeal_IC_hearingReviewHearingHome)
Hearing Home (Appeal_IC_hearingReviewHearingHomeDetails)
Hearing Home (Appeal_IC_hearingReviewHearingHomeViewOnly)
User Attendees (Appeal_IC_listHearingAttendee)
Hearing Reviewers (Appeal_IC_listHearingReviewer)
Invite User Attendee (Appeal_inviteHearingAttendee)
Invite Hearing Reviewer (Appeal_inviteHearingReviewer)
Attendees (Appeal_listAttendee)
Attendees (Appeal_listAttendeeIC)
Hearing Attendees (Appeal_listHearingAttendee)
Hearings (Appeal_listHearingCaseHearing)
Hearings (Appeal_listHearingCaseHearingForIC)
Hearings (Appeal_listHearingCaseIssueHearingForIC)
Hearing Reviewers (Appeal_listHearingReviewer)
Hearings (Appeal_listHearingReviewHearing)
Hearings (Appeal_listHearingReviewHearingForIC)
Hearings (Appeal_listHearingReviewIssueHearingForIC)
Items Under Appeal (Appeal_listItemsUnderAppeal)
Appeal Objects (Appeal_listObjectsByAppeal)
Manage Decision (Appeal_manageHearingCaseDecisionForIC)
Decisions (Appeal_manageHearingReviewDecisionForIC)
Manage Decision (Appeal_manageJudicialReviewDecisionForIC)
Edit Hearing Attendee (Appeal_modifyHearingAttendee)
Edit Microsoft Word Decision Attachment (Appeal_modifyInternalAttachment)
Remove Hearing Attendee (Appeal_removeHearingAttendee)
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)
View Hearing Attendee (Appeal_viewHearingAttendee)
View Decision Attachment (Appeal_viewInternalAttachment)
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 Microsoft Word Decision Attachment (LegalAction_modifyInternalAttachment)
Edit Legal Order (LegalAction_modifyOrder)
Edit Petition (LegalAction_modifyPetition)
Save Microsoft Word Decision Attachment (LegalAction_saveMSWord)
Schedule Hearing (LegalAction_scheduleHearing)
View Hearing (LegalAction_viewHearing)
LegalAction_viewHearingTabDetails
View Decision Attachment (LegalAction_viewInternalAttachment)
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