| insert | insert | AUTO_ID: hearingServiceSupplierID
PRE_DATA_ACCESS: yes
| Standard Operation | |
| searchByHearingIDAndStatus | nsmulti | | Retrieve all service suppliers of a specified status for a hearing. | SQL |
| clone | | | Clone the specified hearing service supplier details for a different hearing. | |
| readCloneDetails | nsread | | Read the details that can be cloned for the specified hearing service supplier. | |
| setDefaults | | | Set the default values for the hearing service supplier details if not already set. | |
| validateInsert | | | Entity level validation performed prior to an insert into the database to ensure that all required fields have been specified and valid. | |
| searchActiveInterpreterAndCaseParticipantByHearingID | nsmulti | PRE_DATA_ACCESS: yes
| Returns the hearingServiceSupplierID, caseParticipantRoleID and participantRoleID or caseUserRoleID for all active interpreters by hearingID. | SQL |
| searchActiveInterpreterAndCaseParticipantByHearingCaseID | nsmulti | PRE_DATA_ACCESS: yes
| Returns the heringServiceSupplierID, caseParticipantRoleID and participantRoleID, or caseUserRoleID for all active interpreters by caseID. | SQL |
| modifyParticipatedCodeAndComment | nsmodify | | Modifies the participated code and comment for the hearing service supplier. | |
| searchActiveInterpreterNameAndCaseParticipantByHearingID | nsmulti | PRE_DATA_ACCESS: yes
| Returns the name and participant details for the active interpreters for a hearing. | SQL |
| readTypeAndSupplierLinkID | nsread | | Reads the type and link reference of the hearing service supplier. | |
| countByHearingIDAndSupplierLinkID | ns | | Counts service suppliers by hearing ID and supplier link ID. | SQL |
| searchInterpreterByHearingID | nsmulti | | Returns the hearing service suppliers and types for the specified hearing. | SQL |
| readInterpreterByCaseParticipantRoleAndHearingID | ns | | Reads interpreter details based on a case participant role. | SQL |
| readInterpreterByUserRoleAndHearingID | ns | | Reads interpreter details based on a case user role. | SQL |
| searchActiveInterpreterNameAndCaseUserRoleByHearingID | nsmulti | | Returns the name and user details for the active interpreters for a hearing. | SQL |
| readHearingAndParticipatedCode | nsread | | Reads the unique internal reference number for the hearing, based on the hearing service supplier. | |
| searchUserDetailsByHearingID | nsmulti | | Returns the details for all user type service suppliers for the specified hearingID. | SQL |
| modifyNonParticipation | nsmodify | PRE_DATA_ACCESS: yes
| Sets the participation code to no show for all the service suppliers that didn't participate. | |
| readHearing | nsread | | | |
| countActiveParticipantByHearingParticipation | ns | PRE_DATA_ACCESS: yes
| Returns the number of active participant service suppliers for a hearing with the specified participation. | SQL |
| countActiveUserByHearingParticipation | ns | PRE_DATA_ACCESS: yes
| Returns the number of active user service suppliers for a hearing with the specified participation. | SQL |
| updateNonParticipation | | | @superseded - replaced by modifyNonParticipation | |
| searchUserDetailsWithVersionNumbersByHearingID | nsmulti | | Returns the details, including versionNo, for all user type service suppliers for the specified hearingID. | SQL |
