Table Description

Pregnancy: This evidence captures the details about a Household Member's pregnancy.

The pregnancy due-date is used to determine the eligibility for certain programs. Recording details of the father of the unborn child is optional. A father may be a Household Member, an existing case participant with a role of type 'father of unborn child', a registered person, or an unregistered individual who is recorded on the system as a representative.

A pregnant Household Member must have at least one Unborn Child record associated with their Pregnancy record.

Example

A case worker creates a Pregnancy record for Linda Smith as she is currently expecting one child. Linda Smith is living with the father of her unborn child so the father's details are recorded on her Pregnancy record. The case worker creates one Unborn Child record associated to Linda Smith's Pregnancy record.

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::Pregnancy::Pregnancy
Controlling File: Evidence\model\ServiceLayer\entity\Household\Pregnancy\Pregnancy_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

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

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the pregnant Household Member. The UI field Name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
dueDatedetails 

The date on which the baby is due. The UI field Name for this attribute is 'Due Date'.

CURAM_DATE SVR_DATE
fahCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the father of the unborn child. The UI field Name for this attribute is 'Father Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
commentsdetails 

Additional details related to the Pregnancy record. The UI field Name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
startDatedetails 

The start date of the pregnancy. The UI field Name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The end date of the pregnancy. The UI field Name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
Pregnancy.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND_1369116706caseParticipantRoleID
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 (25)