Table Description
Medical Expense Evidence: Medical Expense evidence details for a household.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Income Support Screening::Service Layer::Entity::ISExpenseEvidence::ISMedicalExpenseEvidence::ISMedicalExpenseEvidence
Controlling File: ISScreening\model\Packages\Service Layer\Entity\ISMedicalExpenseEvidence_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
isMedicalExpenseEvidenceIDkeynoThe system generated unique identifier of a MedicalExpenseEvidence record.IS_MEDICAL_EXPENSE_EVIDENCE_ID SVR_INT64
participantRoleIDdetailsnoThe concernRoleID of the household member for whom the MedicalExpenseEvidence is recorded.CONCERN_ROLE_ID SVR_INT64
medicalExpenseTypedetails The type of medical expense e.g. prescription drugs, glasses etc.IS_MEDICAL_EXPENSE_TYPEMedicalExpenseTypeSVR_STRING<10>
medicalExpenseFrequencydetails The frequency at which the expense is incurredFREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
medicalExpenseAmountdetails The amount of the expenseCURAM_AMOUNT SVR_MONEY
Foreign Keys (1)
ChildParent
ISMedicalExpenseEvidence.participantRoleIDConcernRole.concernRoleID
Indices (1)
Index NameAttributes
IND__605828499participantRoleID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: isMedicalExpenseEvidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readByKeyParticipantRoleIDnsread To retrieve a medical expense evidence record for a specific household member. 
validateDetails  Validates the ISMedicalExpenseEvidence details prior to insert and modify.  
Related Pages (12)