Database Table: Emergency
Emergency: This evidence captures details about a Household Member's medical condition and whether this condition constitutes an emergency. Emergency is specifically recorded for the purposes of determining eligibility for Emergency Medical Assistance.
Medical Assistance provides payment for care and services necessary for the treatment of an emergency medical condition. The payments exclude care and services that are related to either an organ transplant procedure or routine prenatal or postpartum care. A medical claims department assesses whether a specific condition is deemed an emergency based on the medical reports supplied by the applicant. Example A case worker creates an Emergency record for Linda Smith who was involved in a car accident last month. Linda Smith received approved emergency treatment following her car accident for one week. |
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
|
|
Location in Model: | Logical View::MetaModel::Curam::Evidence::Service Layer::Entity::Household::Emergency::Emergency |
Controlling File: | Evidence\model\ServiceLayer\entity\Household\Emergency\Emergency_cat.efx |
ALLOW_OPTIMISTIC_LOCKING | yes |
Attribute | Stereotype | Nullable | Description | Domain Definition | Codetable | DDL Type |
evidenceID | key | no | System generated unique identifier for the Emergency record. There is no UI field for the same. | EVIDENCE_ID | | SVR_INT64 |
caseParticipantRoleID | details | no | The Case Participant Role ID of the Household Member for whom the Emergency record is being created. The UI field name for this attribute is 'Household Member'. | CASE_PARTICIPANT_ROLE_ID | | SVR_INT64 |
medicalConditionType | details | yes | The Medical Condition which gave rise to the emergency. Examples would include: Heart Attack, Emergency Department Visit, etc. This is populated from the 'MedicalConditionType' code table. The UI field name for this attribute is 'Emergency Medical Condition'. | EVD_MEDICAL_CONDITION_TYPE | MedicalConditionType | SVR_STRING<10> |
startDate | details | yes | The start date of the approved emergency treatment for the medical condition. The UI field name for this attribute is 'Emergency Start Date'. | CURAM_DATE | | SVR_DATE |
endDate | details | yes | The end date of the approved emergency treatment for the medical condition. The UI field name for this attribute is 'Emergency End Date'. | CURAM_DATE | | SVR_DATE |
applicationDate | details | yes | This is the date that the applicant or their representative made their application for emergency assistance for this medical condition. The UI field name for this attribute is 'Application Date'. | CURAM_DATE | | SVR_DATE |
approvalStatus | details | yes | Decision on whether the medical condition is approved as an emergency. Example would include: Approved - Emergency Condition, Denied - Related to PostPartum Care, etc. This is populated from the 'Approval' code table. The UI field name for this attribute is 'Approval Status'. | EVD_APPROVAL | Approval | SVR_STRING<10> |
approvalBody | details | | Specific departments or organizations that can approve a medical condition as an emergency. Examples would include: Medical Claims Department, Bureau of Eligibility Services, etc. This is populated from the 'ApprovalBody' code table. The UI field name for this attribute is 'Approval Department'. | EVD_APPROVAL_BODY | ApprovalBody | SVR_STRING<10> |
approvalDate | details | yes | The date on which the medical condition and its duration was approved as an emergency. The UI field name for this attribute is 'Approval Status'. | CURAM_DATE | | SVR_DATE |
| details | | Additional details related to the Emergency. The UI field name for this attribute is 'Comments'. | COMMENTS | | SVR_STRING<300> |
|
Index Name | Attributes |
IND_929317766 | caseParticipantRoleID |
|
Operation | Stereotype | Options | Description | SQL |
insert | insert | AUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
| Insert an emergency evidence record | |
read | read | | Reads an emergency evidence record | |
modify | modify | OPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
| Modifies an emergency evidence record | |
|