| insert | insert | | Standard Operation | |
| modify | modify | OPTIMISTIC_LOCKING: yes
| Standard Operation | |
| read | read | | Standard Operation | |
| searchByApplicationCaseAdmin | readmulti | | Returns a list of all Assessment Case records that are related to the given assessmentCaseID. This operation is used to list assessment cases that are related to a particular assessment case admin record. | |
| searchByOwner | readmulti | WHERE: applicationCaseID in (
Select caseID from CaseHeader
where CaseHeader.ownerOrgobjectLinkID = :orgObjectLinkID
and CaseHeader.caseTypeCode = 'CT10201'
)
| Returns all Application Cases for the given OrgObjectLinkID. A search of all CaseHeader records is done where the caseType is ApplicationCase and the ownerOrgObjectLinkID matches the given OrgObjectLinkID. The corresponding ApplicationCase records are returned. | |
| searchByParticipantRoleAndType | readmulti | WHERE: applicationCaseID in (
Select CaseHeader.caseID from CaseHeader, CaseParticipantRole
WHERE CaseHeader.caseID = CaseParticipantRole.caseID
and CaseHeader.caseTypeCode = :caseTypeCode
AND CaseParticipantRole.participantRoleID = :concernRoleID
AND (CaseParticipantRole.typeCode='PRI' OR CaseParticipantRole.typeCode='MEM')
)
| Returns all Application Cases for the given concernRoleID. A search of all CaseHeader records is done where the caseType is ApplicationCase with the CaseParticiapntRole to be of type Member or Primary and the particpantRoleID of the CaseParticipant matches the given concernRoleID. The corresponding ApplicationCase records are returned. | |
| searchByParticipantRoleTypeAndStatus | readmulti | WHERE: status != :status AND
applicationCaseID in (
Select CaseHeader.caseID from CaseHeader, CaseParticipantRole
WHERE CaseHeader.caseID = CaseParticipantRole.caseID
and CaseHeader.caseTypeCode = :caseTypeCode
AND CaseParticipantRole.participantRoleID = :concernRoleID
AND (CaseParticipantRole.typeCode='PRI' OR CaseParticipantRole.typeCode='MEM')
)
| Returns all Application Cases for the given concernRoleID where the status is not 'Closed' i.e. it is 'Open' or 'Ready for Determination'.
A search of all CaseHeader records is done where the caseType is ApplicationCase with the CaseParticiapntRole to be of type Member or Primary and the particpantRoleID of the CaseParticipant matches the given concernRoleID. The corresponding ApplicationCase records are returned. | |
| searchReferralCaseByParticipantRoleAndType | readmulti | WHERE: applicationCaseAdminID in (
Select APPLICATIONCASEADMINID from APPLICATIONCASEADMIN where APPLICATIONCASEADMIN.APPLICATIONCASEADMINID = applicationCaseAdminID
and APPLICATIONCASE.REFERRALSOURCE IS NOT NULL
)
and applicationCaseID in (
Select CaseHeader.caseID from CaseHeader, CaseParticipantRole
WHERE CaseHeader.caseID = CaseParticipantRole.caseID
and CaseHeader.caseTypeCode = :caseTypeCode
AND CaseParticipantRole.participantRoleID = :concernRoleID
AND (CaseParticipantRole.typeCode='PRI' OR CaseParticipantRole.typeCode='MEM')
)
| Returns all Referral Cases for the given concernRoleID. A search of all CaseHeader records is done where the caseType is ApplicationCase with the CaseParticiapntRole to be of type Member or Primary and the particpantRoleID of the CaseParticipant matches the given concernRoleID. The corresponding ReferralCase records are returned. | |
| countByApplicationCaseAdminID | ns | | Count the number of application case created for the admin configuration.
@param key The unique identifier of the application case Admin ID.
@return count The no of cases . | SQL |
