| Operation | Stereotype | Options | Description | SQL |
| insert | insert | AUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
| Standard Operation | |
| read | read | | Standard Operation | |
| modify | modify | OPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
| Standard Operation | |
| remove | remove | | Standard Operation | |
| readHholdMemberCaseParticipant | ns | | Reads a household member record returning the participant name and the caseParticipantRoleID. | SQL |
| readHholdMemberSelectDetails | ns | | Reads a household member, returning the caseParticipantRoleID, name, and date of birth. | SQL |
| readCaseParticipantsByEvidenceID | nsread | | Returns all related caseParticipantRoleID's for a specified Household Member ID. | |
| readHMParticipantRoleDetails | ns | | Operation to return the participant role id, participant role name, marital status, gender, and date of birth of the household member. | SQL |
| readParticipantRoleDetails | ns | | Operation to return ParticipantRoleID, ParticipantRoleName, DateOfBirth, MaritalStatus, Gender and CaseParticipantRoleID | SQL |
| readMemberAlternateIDSSN | ns | | Reads a members current alternateID of type SSN by the participantRoleID | SQL |
| readDatabaseCaseMemberAlternateIDSSN | ns | | Reads a members current alternateID of type SSN by the caseParticipantRoleID. | SQL |
| readCitizenStatus | nsread | | Reads the citizenship, nationality or alien status of a household member. | |
| readVeteranStatus | nsread | | Reads the veteran status code for a household member. | |
| readProspectHholdMemberSelectDetails | ns | | Reads a prospect household member, returning the caseParticipantRoleID, name, and date of birth. | SQL |
|
