| insert | insert | AUTO_ID: hearingDecisionID
PRE_DATA_ACCESS: yes
| Standard Operation | |
| read | read | | Standard Operation | |
| modify | modify | OPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
| Standard Operation | |
| validate | | | Validates the details of the hearing decision. | |
| readCaseAndResolution | nsread | | Reads the internal reference number assigned to the case and the resolution of the decision. | |
| readVersion | nsread | | Reads the version number of the specified hearing decision. | |
| modifyStatus | nsmodify | OPTIMISTIC_LOCKING: yes
| Modifies the status of the specified hearing decision. | |
| readResolutionCodeByCase | nsread | | Returns the resolution details for the caseID | |
| readResolutionDateStatusByCase | nsread | | Returns the decision date and status for a case. | |
| readStatus | nsread | | Returns a hearing decision status. | |
| readCase | nsread | | Returns the caseID for the hearing decision. | |
| countIsUserSupervisor | ns | PRE_DATA_ACCESS: yes
| Method to check is the user a supervisor. A user is a supervisor if the user holds a lead position or holds a position that another position reports to. | SQL |
| searchIsUserSupervisor | | | @superseded - replaced by countIsUserSupervisor | |
| readOverallDecisionByCase | ns | | Returns the overall appeal decision for an appeal case. | SQL |
| readOverallSummary | nsread | | Reads the summary details of the hearing decision; this does not include any attachment details. | |
| modifyDateCommentsAndStatus | nsmodify | | Modifies the date, comments and status for a hearing decision. | |
| readStatusAndCaseStatus | ns | | Returns the hearing decision status and the case status of the associated appeal case. | SQL |
| readIDByCase | nsread | | Returns the hearing decision identifier for a given appeal case. | |
| readDateResolutionAndRefByCase | ns | | Returns the decision date, decision resolution and the appeal case reference for the decision for the appeal case. | SQL |
| readVersionNoByCase | nsread | | Returns the version number of the hearing decision given the case id. | |
| readDecisionIDDateAndVersionByCase | ns | | Returns the decision date, decision id and the decision version number for the appeal case. | SQL |
| countIDByCase | ns | | Returns the count of hearing decisions for a given appeal case. | SQL |
| readStatusByCase | nsread | | Returns the identifier and status of the hearing decision using the appeal caseID. Note that there can never be more than HearingDecision record for an appeal case within the application.
| |
| readIDAndResolutionByCase | nsread | | Returns the hearingDecisionID and decision resolutionCode for an appeal caseID. Note that there will only be one hearing decision record per appeal case within the application. | |
| modifyResolutionCode | nsmodify | | Modifies the resolution for an appeal case. | |
| readScheduledDateTimeByCase | ns | | Read scheduled date time by case. | SQL |
| modifyComments | nsmodify | | Modifies the date, comments and status for a hearing decision. | |
