Table Description

Level Of Care: This evidence captures the details of a household member's required Level of Care based on their physical and mental state.

The level of medical or nursing care required by the household member is certified by a medically qualified individual. The Level of Care record includes details such as the type of certifier, the certification start and end dates and the certifier's name and address.

Example

A case worker creates a Level Of Care record for Linda Smith. Linda Smith is ill and requires hospital care which has been certified by her physician.
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::Evidence::Service Layer::Entity::Household::LevelOfCare::LevelOfCare
Controlling File: Evidence\model\ServiceLayer\entity\Household\LevelOfCare\LevelOfCare_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Level of Care record. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Household Member who needs special care. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
levelOfCareTypedetailsyes

The level of care type. Examples include 'Hospital Level of Care', 'IMD', 'Intermediate or Skilled Nursing Care', etc. This is populated from the 'LevelOfCareType' code table. The UI field name for this attribute is 'Level of Care Type'.

EVD_LEVEL_OF_CARE_TYPELevelOfCareTypeSVR_STRING<10>
certifierParticipantRoleIDdetailsyes

The Case Participant Role ID of the person who certifies the requested level of care. The UI field name for this attribute is 'Certifier Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
certifierTypedetails 

Type of Certifier, examples include: Physician, Recognized Authority, etc. This is populated from the 'CertifierType' code table. The UI field name for this attribute is 'Certifier Type'.

EVD_CERTIFIER_TYPECertifierTypeSVR_STRING<10>
certificationStartDatedetailsyes

The date from which the certification is valid. The UI field name for this attribute is 'Certification Start Date'.

CURAM_DATE SVR_DATE
certificationEndDatedetails 

The date until which the certification is valid. The UI field name for this attribute is 'Certification End Date'.

CURAM_DATE SVR_DATE
commentsdetails 

Additional details related to the Level of Care record. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
Foreign Keys (2)
ChildParent
LevelOfCare.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
LevelOfCare.certifierParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (2)
Index NameAttributes
IND_1205001697caseParticipantRoleID
IND__773903678certifierParticipantRoleID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
Related Pages (6)