| Operation | Stereotype | Options | Description | SQL |
| insert | insert | | Standard Operation | |
| modify | modify | OPTIMISTIC_LOCKING: yes
| Standard Operation | |
| read | read | | Standard Operation | |
| searchByCaseID | readmulti | | reads all matching records | |
| searchNonCancelledCertifications | nsmulti | | This method is used as the driving cursor for the EvaluateCertificationGracePeriod
batch job. The `order by` in the SQL statement is important to the processing in
this batch program, i.e.. processing will only occur on records with the maximum
periodToDate per caseID. Therefore, based on the SQL, only the first record per
caseID will be processed. This approach was taken since the SQL to produce the
'correct' result set was using a lot of business logic and would make this batch
job difficult to maintain/customize.
| SQL |
| readActiveCertification | ns | | Return a record which has the same caseID
and dateOfCalculation is in between fromDate and toDate.
StatusCode will be the input attribute, This will decide what kind of records to be retrieved from the database
i.e. Active or Canceled
| SQL |
| searchActiveByCaseID | readmulti | | reads all active matching records | |
| searchCertificationGracePeriod | nsmulti | | Method to search for all records that are the most recent entry for a case, and retrieve their details, the status of the associated cases and the certGracePeriod of the associated products | SQL |
| countAllByCaseIDDateStatus | ns | PRE_DATA_ACCESS: yes
| Returns the number of certifications for a case that are active and who's from date is before the date entered. | SQL |
| readEarliestActiveCertificationDate | ns | | Method to get the earliest active certification from date. | SQL |
| searchCertificationByCaseId | nsmulti | | To retrieve the list of certifications which are sorted by period from date. | SQL |
| searchCertificationByCaseIdAndVersionNo | nsmulti | | To retrieve the list of certifications which are sorted by period from date. | SQL |
|
