Table Description
Hearing Phone Contact: The contact number details for participants of an appeal.

A hearing scheduler records contact phone numbers for each participant that is scheduled to attend a hearing.

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. An appeal case is created on the system. Once the appeal case is approved, a hearing is scheduled.

A hearing scheduler schedules a hearing and records a phone number for the hearing representative, hearing witness and interpreter who are all scheduled to attend the 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::HearingPhoneContacts::HearingPhoneContact
Controlling File: Appeal\model\Packages\Service Layer\entity\Hearing\HearingPhoneContacts\HearingPhoneContacts_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
hearingPhoneContactIDkeynoUnique ID for a hearing phone contact record.HEARING_PHONE_CONTACT_ID SVR_INT64
hearingIDdetailsnoUnique ID of the associated hearing. Links the hearing phone contact to the related hearing. HEARING_ID SVR_INT64
caseParticipantRoleIDdetailsnoUnique ID of the associated case participant role. Links the hearing phone contact to the related case participant role. CASE_PARTICIPANT_ROLE_ID SVR_INT64
concernRolePhoneNumberIDdetailsnoUnique ID of the associated concern role phone number. Links the hearing phone contact to the concern role phone number. CONCERN_ROLE_PHONE_NUMBER_ID SVR_INT64
recordStatusdetails Status of the hearing phone number record. The values are 'Active' or 'Cancelled'. RECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Free-form textual comments that are entered by the user.COMMENTS SVR_STRING<300>
Foreign Keys (3)
ChildParent
HearingPhoneContact.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
HearingPhoneContact.concernRolePhoneNumberIDConcernRolePhoneNumber.concernRolePhoneNumberID
HearingPhoneContact.hearingIDHearing.hearingID
Indices (3)
Index NameAttributes
HPCHringIDhearingID
IND__696975269caseParticipantRoleID
IND__2117396427concernRolePhoneNumberID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: hearingPhoneContactID
Standard Operation 
searchPhoneContactsnsmulti Returns a list of contacts for the specified hearing.SQL
modifyStatusnsmodify Modifies the status of the hearing phone contact 
readDetailsns Returns the details of a contact phone number for a hearing participantSQL
readDetailsForModifyns Returns the details needed for the hearing phone contact modifySQL
readHearingIDnsread Returns the hearing ID for the hearing phone contact. 
Related Pages (12)