| insert | insert | AUTO_ID: caseEvidenceTreeID
POST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
| Standard Operation | |
| readStatusEffectiveDateAndCaseID | nsread | | Reads the statusCode, effectiveFrom date and caseID of a caseEvidenceTree record. | |
| validateActivate | | | Validates the activation of an In Edit evidence tree. | |
| readStatusCode | nsread | | Reads the status code of an evidence tree. | |
| validateCancel | | | Validates the cancellation of an evidence set. | |
| modifyStatusCode | nsmodify | OPTIMISTIC_LOCKING: yes
POST_DATA_ACCESS: yes
| Modifies the statusCode of an evidence tree. | |
| cancel | | | Cancels an evidence tree. | |
| validateInsert | | | Validates the insertion of an evidence tree. | |
| countActiveInEditByCaseID | ns | PRE_DATA_ACCESS: yes
| Counts the number of evidence trees belonging to a case. | SQL |
| activate | | | Activates an evidence tree with a status of In Edit. | |
| modifyLinksToReadOnly | | | Modifies the isEditableInTreeInd on the evidence tree's link records to be false. | |
| readByStatusEffectiveDateAndCaseID | ns | PRE_DATA_ACCESS: yes
| Reads the CaseEvidenceTree entity by statusCode, effectiveFrom date and caseID. | SQL |
| modify | modify | | Standard Operation | |
| readStatusEffectiveDateCaseAndVersion | nsread | | | |
| searchActiveInEditEvidenceByCaseID | nsmulti | PRE_DATA_ACCESS: yes
| Searches for all caseEvidenceTree records on a case with a status of Active or InEdit. | SQL |
| readEffectiveDateAndStatus | nsread | | Reads the effectiveFrom date and status code of an evidence tree. | |
| readCaseID | nsread | | Reads the caseID of a specified evidence tree. | |
| searchByEffectiveDateAndCaseID | nsmulti | PRE_DATA_ACCESS: yes
| Searches all case evidence tree records for a specified effectiveFrom date and caseID. | SQL |
| readNextActiveEvidence | ns | PRE_DATA_ACCESS: yes
| Retrieves the details of the active case evidence tree record with the next highest effective from date after that supplied. | SQL |
| searchAllEvidence | nsmulti | PRE_DATA_ACCESS: no
| Retrieves all case evidence tree records for a specified case. | SQL |
| searchByStatusEffectiveDateAndCaseID | nsmulti | PRE_DATA_ACCESS: yes
| Searches the CaseEvidenceTree entity by statusCode, effectiveFrom date and caseID. | SQL |
| readEffectiveFrom | nsread | | Reads the effective from date of the case evidence tree. | |
| determineReassessmentDates | | | Determines dates over which possible reassessment may need to occur during the activation or cancellation of an evidence tree. | |
| read | read | | Standard Operation | |
| readNearestActiveEvidence | ns | PRE_DATA_ACCESS: yes
| This operation is used to read the nearest active evidence record in the past to the input date.
The first step is to calculate the maximum effective from date for the required caseID and statusCode before a specified cut-off date - where no date is available null is used. Once this is done the resulting date is used to select all data from the corresponding case evidence tree.
| SQL |
| readNearestActiveEvidenceByGroup | ns | PRE_DATA_ACCESS: yes
| This operation is used to read the nearest active evidence record in the past to the input date, for a given Case, which has an associated Case Evidence Group record of the specified evidence group.
The first step is to calculate the maximum effective from date for the required caseID and statusCode before a specified cut-off date - where no date is available null is used. The results are restricted to only those that match the evidence group name code from the case evidence group table.
Once this is done the resulting date is used to select all data from the corresponding case evidence tree. As many groups may apply to the resultant date, the results must be restricted again to the group name code.
| SQL |
| searchNearestEvidence | nsmulti | PRE_DATA_ACCESS: yes
| Searches the nearest evidence on a specified case for the the specified date and status codes.
The first step is to calculate the maximum effective from date for the required
caseID and statusCodes before a specified cut-off date - where no date is available
null is used. Once this is done the resulting date is used to select all data from
the corresponding case evidence tree.
| SQL |
| searchAllLessCanceledAndSuperseded | nsmulti | PRE_DATA_ACCESS: yes
| Retrieves all case evidence tree records for a specified case excluding canceled and superseded records. | SQL |
| suspend | | | Suspends the evidence tree. | |
| readEffectiveDateStatusAndPreviousEvidenceID | nsread | | Reads the case evidence tree's date, status code and previous evidence identifier. | |
| readCaseIDAndEffectiveDate | nsread | | Reads the caseID and effectiveFrom date for a specified evidence tree. | |
| validateSuspend | | | Validates the suspension of a case evidence tree. | |
| readNearestEvidenceByStatus | ns | PRE_DATA_ACCESS: yes
| This operation is used to read the nearest evidence record in the past to the input date.
The first step is to calculate the maximum effective from date for the required caseID and statusCode before a specified cut-off date - where no date is available null is used. Once this is done the resulting date is used to select all data from the corresponding case evidence tree.
| SQL |
| readNearestEvidenceByStatusAndGroup | ns | PRE_DATA_ACCESS: yes
| This operation is used to read the nearest evidence record in the past to the input date, for a given Case, which has an associated Case Evidence Group record of the specified evidence group.
The first step is to calculate the maximum effective from date for the required caseID and statusCode before a specified cut-off date - where no date is available null is used. The results are restricted to only those that match the evidence group name code from the case evidence group table.
Once this is done the resulting date is used to select all data from the corresponding case evidence tree. As many groups may apply to the resultant date, the results must be restricted again to the group name code.
| SQL |
| readCaseStatus | ns | | This method reads the case status from the case header.
The caseEvidenceTreeID is used to retrieve the caseID from the CaseEvidenceTree entity which in turn is used to read the caseStatus from the CaseHeader.
| SQL |
| searchByCaseIDAndStatus | readmulti | | This method returns all the records matching a CaseEvidenceTree caseID and statusCode. | |
