Database Table: MedicalScreening
Medical Screening: This evidence captures details about a Household Member's screening diagnosis and period of certification. A Household Member may be screened for Cancer or Tuberculosis conditions. If a Household Member is diagnosed with a condition it is then certified by a medical professional, for a set period of time. A Medical Screening record is specifically created for a Household Member seeking medical assistance for Tuberculosis or Breast or Cervical Cancer. Example
A case worker creates a Medical Screening record for Linda Smith. Linda Smith has had medical screening and has been diagnosed with breast cancer. This diagnosis has been certified by a medical professional for a period of 1 month. |
| Location in Model: | Logical View::MetaModel::Curam::Evidence::Service Layer::Entity::Household::MedicalScreening::MedicalScreening |
| Controlling File: | Evidence\model\ServiceLayer\entity\Household\MedicalScreening\MedicalScreening_cat.efx |
| ALLOW_OPTIMISTIC_LOCKING | yes |
| Attribute | Stereotype | Nullable | Description | Domain Definition | Codetable | DDL Type |
| evidenceID | key | no | System generated unique identifier for the Medical Screening. There is no UI field for this attribute. | EVIDENCE_ID | | SVR_INT64 |
| diagnosis | details | yes | The result of the screening and the type of medical condition identified. Examples include: Breast Cancer, Cervical Cancer, TB, etc. This is populated from the 'ScreenDiagnosis' code table. The UI field name for this attribute is 'Screen Diagnosis'. | EVD_MEDICAL_SCREENING_DIAGNOSIS | ScreenDiagnosis | SVR_STRING<10> |
| certificationStartDate | details | yes | The date from which the Household Member is certified for the identified medical illness. The UI field name for this attribute is 'Certification Start Date'. | CURAM_DATE | | SVR_DATE |
| certificationEndDate | details | | The date until which the certifcation for the identified medical illness is valid. The UI field name for this attribute is 'Certification End Date'. | CURAM_DATE | | SVR_DATE |
| details | | Additional details related to the Medical Screening. The UI field name for this attribute is 'Comments'. | COMMENTS | | SVR_STRING<300> |
| caseParticipantRoleID | details | no | The Case Participant Role ID of the Household member for whom the Medical Screening record is being created. The UI field name for this attribute is 'Household Member'. | CASE_PARTICIPANT_ROLE_ID | | SVR_INT64 |
|
| Operation | Stereotype | Options | Description | SQL |
| insert | insert | AUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
| Standard Operation | |
| read | read | | Standard Operation | |
| modify | modify | PRE_DATA_ACCESS: yes
| Standard Operation | |
|
