Table Description
Hearing Transcription Request: A request for a recorded copy of a hearing.

After a hearing is scheduled for an appeal case user can request for a copy of transcription of a hearing @curam.entity appeal.sl.entity.Hearing hearing}. The details of the requester and transcriber are recorded in the system.

Example

A request is received from an appellant Linda Smith for a copy of a transcription of a hearing. The details for the requester Linda Smith and the transcriber are recorded in the system. The transcriber may already be registered as a service supplier 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::HearingTranscriptionRequest::HearingTranscriptionRequest
Controlling File: Appeal\model\Packages\Service Layer\entity\Hearing\HearingTranscriptionRequest\HearingTranscriptionRequest_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
hearingTranscriptionRequestIDkeynoUnique ID for a hearing transcription request record.TRANSCRIPTION_REQUEST_ID SVR_INT64
hearingIDdetailsnoUnique ID of the associated hearing. Links the hearing transcription request to the related hearing.HEARING_ID SVR_INT64
requestedByIDdetailsnoUnique ID for the person who requested the transcription.CASE_PARTICIPANT_ROLE_ID SVR_INT64
transcriberIDdetailsnoUnique ID for the person who transcribes the hearing.CASE_PARTICIPANT_ROLE_ID SVR_INT64
dateRequesteddetails Date on which the transcription request was made.CURAM_DATE SVR_DATE
dateSentToTranscriberdetails Date on which the transcription material was sent to the transcriber.CURAM_DATE SVR_DATE
dateDuedetails Date on which the completed transcription is due.CURAM_DATE SVR_DATE
dateReceivedFromTranscriberdetails Date on which the organization received the completed transcription from the transcriber.CURAM_DATE SVR_DATE
caseAttachmentLinkIDdetailsyesUnique ID of the associated case attachment link. Links the hearing transcription request to the related case attachment. CASE_ATTACHMENT_LINK_ID SVR_INT64
dateSentToRequesterdetails Date on which the completed transcription was sent to the requester of the transcription.CURAM_DATE SVR_DATE
commentsdetails Free-form textual comments that are entered by the user.COMMENTS SVR_STRING<300>
recordStatusCodedetails Status of the transcription request record. The values are 'Active' or 'Cancelled'.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (4)
ChildParent
HearingTranscriptionRequest.caseAttachmentLinkIDCaseAttachmentLink.caseAttachmentLinkID
HearingTranscriptionRequest.requestedByIDCaseParticipantRole.caseParticipantRoleID
HearingTranscriptionRequest.transcriberIDCaseParticipantRole.caseParticipantRoleID
HearingTranscriptionRequest.hearingIDHearing.hearingID
Indices (4)
Index NameAttributes
HearingTRHSIndexhearingID, recordStatusCode
IND__267559530caseAttachmentLinkID
IND__1127675054requestedByID
IND_1009584650transcriberID
Operations (19)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: hearingTranscriptionRequestID
PRE_DATA_ACCESS: yes
Standard Operation 
searchActiveByHearingIDnsreadmultiPRE_DATA_ACCESS: yes
Reads the active transcription request records for the hearing. 
clone  Clone the specified hearing transcription request for a different hearing. 
readCloneDetailsnsread Read the details to be cloned from the specified hearing transcription request. 
setDefaults  Set the default values for the hearing transcription request if they are not already set. 
validate  Entity level validation preformed prior to inserting or modifying a record. 
readread Standard Operation 
modifyDetailsnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Modifies a subset of the transcription request details. 
modifyStatusnsmodifyOPTIMISTIC_LOCKING: yes
Modifies the status of the transcription request. 
readSummarynsread Reads summary details of the transcription request. 
searchSummaryByHearingnsreadmulti Retrieves summary details of all transcription requests for the specified hearing. 
readAttachmentns Reads attachment details for the specified transcription request.SQL
readDateSentToRequesternsread Reads the date that the transcription was sent to the requester. 
countByHearingRequesterStatusns Returns a count of all requests for the specified hearing and requester with the specified status.SQL
readStatusnsread Reads the status of the specified transcription request. 
readCaseAttachmentLinknsread Reads the case attachment link identifier of the specified transcription request. 
countReceivedTranscriptsByCasensPRE_DATA_ACCESS: yes
 
Counts the number of transcripts on the specified case that have been received from transcribers (where the date received has been set).SQL
readRequesternsread Returns the identifier of the participant who requested the hearing transcription. 
readHearingnsread Returns the hearingID for a hearing transcription request. 
Related Pages (68)
Add Issue to Judicial Review (Appeal_addIssueToJudicialReview)
Add Case to Judicial Review (Appeal_addJudicialReviewCase)
Add Case to Judicial Review (Appeal_addJudicialReviewCaseIC)
Add Case to Judicial Review (Appeal_addJudicialReviewIssueCase)
Add Case to Judicial Review (Appeal_addJudicialReviewIssueCaseIC)
Add Case to Judicial Review (Appeal_addJudicialReviewObjectCase)
Adjourn Hearing (Appeal_adjournHearing)
Adjourn Hearing (Appeal_adjournHearingForIC)
Adjourn Hearing (Appeal_adjournHearingReview)
Delete Transcription Request (Appeal_cancelTranscription)
Delete Transcription Request (Appeal_cancelTranscriptionIC)
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 Judicial Review (Appeal_createIssueJudicialReviewMultipleCases)
New Judicial Review (Appeal_createIssueJudicialReviewMultipleCasesIC)
New Judicial Review (Appeal_createJudicialReviewMultipleCases)
New Judicial Review (Appeal_createJudicialReviewMultipleCasesIC)
New Judicial Review (Appeal_createJudicialReviewObjectMultipleCases)
New Case Appeal (Appeal_createProductAppeal)
New Transcription Request (Appeal_createTranscription)
New Case Appeal (Appeal_createWizard)
Transcription Requests (Appeal_listHearingReviewTranscription)
Transcription Requests (Appeal_listHearingReviewTranscriptionIC)
Transcription Requests (Appeal_listTranscription)
Transcription Requests (Appeal_listTranscriptionIC)
Edit Transcription Request Details (Appeal_modifyTranscriptionFromList)
Edit Transcription Request Details (Appeal_modifyTranscriptionFromListIC)
Edit Transcription Request Details (Appeal_modifyTranscriptionFromView)
Edit Transcription Request Details (Appeal_modifyTranscriptionFromViewIC)
New Case Appeal (Appeal_newCaseAppeal)
New Appeal (Appeal_nextStageAppeal)
Reschedule Desk-Based Hearing (Appeal_rescheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleIssueDeskHearing)
View Transcription Request Details (Appeal_viewTranscription)
View Transcription Request Details (Appeal_viewTranscriptionIC)
New Program Appeal (AppealWizard_createAppeal)
New Determination Appeal (AppealWizard_DeterminationCreateAppeal)
New Program Appeal (IntakeAppealWizard_createAppeal)
Schedule Hearing (LegalAction_scheduleHearing)