Table Description
Hearing Activity Link: The relationship between a hearing and the activities created for that hearing.

When user appeals for an appeal case a hearing scheduler schedules a hearing to review the case by hearing officials. Then system inserts an activity in the hearing official's calendar for a particular date, time and location.

Example

Linda Smith applies for sickness benefit with an organization. It is calculated that Linda is entitled to $40 a week. Linda is dissatisfied with this rate of payment and submits a request for appeal to the organization.

A user creates an appeal case in the system. A hearing scheduler schedules a hearing where Linda's case will be reviewed by a hearing official. The system inserts an activity in the hearing official's calendar for a particular date, time and location.

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::HearingActivityLink::HearingActivityLink
Controlling File: Appeal\model\Packages\Service Layer\entity\Hearing\HearingActivityLink\HearingActivityLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
hearingActivityLinkIDkeynoUnique ID for the Hearing Activity Link record.HEARING_ACTIVITY_LINK_ID SVR_INT64
hearingIDdetailsnoUnique ID of the associated hearing. Links the activity to the related hearing.HEARING_ID SVR_INT64
activityIDdetailsnoUnique ID of the associated activity. Links the hearing to the related activity.ACTIVITY_ID SVR_INT64
typeCodedetails Hearing activity relationship type. Currently there is just one type of 'Hearing'.HEARING_ACTIVITY_TYPE_CODEHearingActivityTypeSVR_STRING<10>
Foreign Keys (2)
ChildParent
HearingActivityLink.activityIDActivity.activityID
HearingActivityLink.hearingIDHearing.hearingID
Indices (2)
Index NameAttributes
ActivityIDIndexactivityID
HearingIDIndexhearingID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: hearingActivityLinkID
PRE_DATA_ACCESS: yes
Insert a hearing activity link record. 
validateInsert  Entity level validation which is called prior to inserting a record. Ensures that all required fields are entered and valid. 
countByActivityIDns Counts all entries that match the given activity idSQL
searchActivityIDByHearingIDnsreadmulti Returns a list of activity ID variables from the HearingActivityLink table with the given hearing ID. 
searchActivityIDByHearingIDAndUsernsmulti Returns the activityIDs for the given hearing that have the given user name.SQL
countActiveActivityByTypeHearingIDAndUsernsPRE_DATA_ACCESS: yes
 
Counts the activities based on the hearingID, userName, activityStatus and hearingActivityLinkType.SQL
readActiveActivityByTypeHearingIDAndUsernsPRE_DATA_ACCESS: yes
 
Returns the activity IDs based on the hearingID, userName, activityStatus and hearingActivityLink type.SQL
Related Pages (34)
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)
Invite User Attendee (Appeal_inviteHearingAttendee)
Invite Hearing Reviewer (Appeal_inviteHearingReviewer)
Remove Hearing Attendee (Appeal_removeHearingAttendee)
Reschedule Desk-Based Hearing (Appeal_rescheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleIssueDeskHearing)
Schedule Hearing (LegalAction_scheduleHearing)