| insert | insert | AUTO_ID: hearingID
PRE_DATA_ACCESS: yes
| Insert a new hearing record | |
| readLatestPostponedByCaseIDAndStatus | ns | PRE_DATA_ACCESS: no
| Read the most recent postponed hearing using the specified status for a case. | SQL |
| readCaseByHearingIDAndStatus | nsread | | Reads for the appeal case for the specified hearing and status. | |
| readScheduledByCaseID | nsread | PRE_DATA_ACCESS: yes
| Returns the scheduled hearing and date for a caseID. There should only be one scheduled hearing for a case at any one time.
| |
| readCaseAndStatusByHearingID | nsread | | Read for the case and status for the specified hearing. | |
| validateInsert | | | This method is invoked from the generated preInsert method for the entity and does all of the entity level validations required prior to inserting a record into the table. | |
| readScheduledDate | nsread | | Reads the scheduled date for a hearing. | |
| readNotificationDetails | nsread | | Reads the details required for hearing notification.
NOTE: This method will need to be modified as more information is received regarding the details for inclusion in the hearing notification.
| |
| readScheduledDateAndType | nsread | | Reads the date and typeCode of a scheduled hearing by hearingID. There can only be one scheduled hearing for a case. | |
| modifyStatusCodesByHearingCaseAndStatus | nsmodify | | Entity method to update scheduled hearings to canceled. | |
| readLatestHearingAndStatusByCase | ns | | Returns the hearing ID and status for the latest hearing on the specified appeal case. | SQL |
| readLatestHearingByCaseAndStatus | ns | | Returns the hearing ID for the latest hearing of the specified status on the specified appeal case. | SQL |
| readSummaryDetails | ns | PRE_DATA_ACCESS: yes
| Reads the summary details for a hearing. | SQL |
| readDetailsForModify | nsread | | Reads the details for a hearing which can be modified. | |
| searchHearingsByCaseID | nsreadmulti | | Returns the list of all hearings and their status for an appeal case. | |
| modifyCommentsAndTimes | nsmodify | PRE_DATA_ACCESS: yes
| Modifies a hearing. | |
| validateModify | | | Performs validation of a hearing modification prior to the actual database update. | |
| formatActualTimes | | | Formats the actual start and actual end date-time values such that the date is equal to the scheduled date of the hearing. | |
| readStatusByHearingID | nsread | | Returns the status of a hearing. | |
| modifyThirdPartyParticipatedCode | nsmodify | | Modifies the third party participated code for a hearing. | |
| modifyRespondentParticipatedCode | nsmodify | | Modifies the respondent participated code for a hearing. | |
| modifyParticipatedCodes | nsmodify | | | |
| readVersionNumber | nsread | | Reads the version number for a hearing. | |
| modifyPostponeDetails | nsmodify | PRE_DATA_ACCESS: yes
| Modifies the hearing details for a postponement. | |
| validateModifyPostpone | | | Performs pre-modify validations for a hearing postponement. | |
| modifyStatus | nsmodify | | Modifies the statusCode for a hearing. | |
| readReviewSummaryDetails | ns | | Reads the summary details for a hearing review. | SQL |
| readCaseOwner | ns | | Returns the case owner for a hearing's appeal case. | SQL |
| readStatusAndDateAndType | nsread | | Returns the statusCode, scheduledDateTime and typeCode for the hearingID provided. | |
| readCase | nsread | | Returns the caseID for a hearing. | |
| modifyPostponeAndTimeAndStatusDetails | nsmodify | PRE_DATA_ACCESS: yes
| Modifies the postpone reason, postpone date, postpone text, actual start time, actual end time and statusCode for the hearing. | |
| modifyStatusAndTimeDetails | nsmodify | PRE_DATA_ACCESS: yes
| Modifies the hearing status code and the actual start and end times for a hearing. | |
| readLatestParticipatedAndTypeDetailsByCase | ns | | Returns the type and participated details for the latest hearing on the specified appeal case. | SQL |
| readScheduledDateAndReference | nsread | | Returns the scheduled date and time and the reference number for a hearing. | |
| readDetailsForModifyValidation | nsread | | Reads the details for a hearing to validate a modification. | |
| searchParticipantRoleByTypeAndStatus | nsmulti | PRE_DATA_ACCESS: no
| Returns the concernRoleID of a participant of a specified type and status for a hearing. | SQL |
| readParticipatedAndVersionNoDetails | nsread | | Returns the participated code and version number details | |
| readLatestHearingIDRefLocationAddress | ns | | Retrieves details about the latest hearing for the specified case. | SQL |
| readLatestHearingIDRefLocationAddressByCaseAndStatus | ns | | Retrieves details about the latest hearing for the specified case. | SQL |
| readLatestHearingIDRefScheduledDateByCaseAndStatus | ns | | Retrieves details about the latest hearing for the specified case. | SQL |
| readLatestScheduleNoticeDetailsByCase | ns | PRE_DATA_ACCESS: yes
| Retrieves details for a schedule notice for a hearing on the specified appeal case. | SQL |
| readLatestPostponedByCaseIDStatusAndDate | ns | PRE_DATA_ACCESS: yes
| Reads the most recently postponed hearing for the specified case, for the specified date. | SQL |
| readContinaunceDetails | nsread | | Returns details relating to the continuance of a hearing. | |
| readLatestPostponedStatusByCase | ns | PRE_DATA_ACCESS: yes
| Reads the status of the latest postponed hearing on the specified case. | SQL |
| readScheduledDateAndLocation | nsread | | Reads scheduled date, time and locationID for the specified hearing. | |
| readScheduledDateAndStatus | nsread | | Returns the scheduled date and status for the hearing. | |
| readLatestParticipatedAndTypeDetailsByCaseAndStatus | ns | | Returns the type and participated details for the latest hearing with the specified status for the specified appeal case. | SQL |
| readActualTimeDetails | nsread | | Returns the actual start and end times for the hearing. Returns the scheduled date also. | |
| modify | | | @superseded - replaced by modifyCommentsAndTimes | |
| countByCaseIDStatusScheduledDateTime | ns | | Counts the number of hearings matching this date time and status for the specified caseID, | SQL |
| readLatestAdjournOrCompletedHearingDateByCaseID | ns | PRE_DATA_ACCESS: yes
| Reads the latest scheduled or completed date | SQL |
| readFirstPostponedByCaseIDAndStatus | ns | | Read the first postponed hearing using the specified status for a case. | SQL |
| readLatestScheduledDateByCaseAndStatus | ns | | Retrieves the scheduled date of the latest hearing with the given status for a case. | SQL |
| searchActiveParticipantNameAddrByIDAndType | nsmulti | PRE_DATA_ACCESS: yes
| Returns the name of each active case participant of the specified type for a hearing. | SQL |
| readDeskHearingSummaryDetails | ns | PRE_DATA_ACCESS: yes
| Reads the summary details for a desk-based hearing. | SQL |
| countScheduledDateByCaseAndStatus | ns | | Retrieves a count of the scheduled hearings with the given status for a case. | SQL |
| readScheduledDateTimeByCase | ns | | Reads the scheduled date time by case ID. | SQL |
| readHearingIDByAppealID | ns | | | SQL |
| readLocationTypeByHearingID | ns | | | SQL |
| read | read | | Standard Operation | |
| readOfficialNameByHearingIDTypeCode | ns | | | SQL |
| searchParticipantRoleIdByHearingID | nsmulti | | | SQL |
| searchParticipantRoleIDByCaseIDTypeStatus | nsmulti | | | SQL |
| searchHearingsByCaseForTabDetail | nsmulti | | | SQL |
| readHearingAttendeeTabDetails | ns | PRE_DATA_ACCESS: yes
| Reads counts of the User, Participant, Service Supplier and Third Party attendees who were invited to a hearing.<br />
Representatives and Witness attendees are counted in the participant part of the query. | SQL |
| readHearingTabDetail | ns | | Return the details of the hearing for the context
panel. Including the details for the context description. | SQL |
| searchHearingOfficialTabDetail | nsmulti | PRE_DATA_ACCESS: yes
| <p>
Lists the User Hearing Officials associated with the hearing.
</p> | SQL |
| searchHearingOfficialParticipantsByHearingID | nsmulti | | Lists the Particiapant Hearing Officials for a Hearing. | SQL |
