Table Description
Benefit Delivery System Details: A health plan or a fee-for-service system and a dental plan or a fee-for-service system for a child in receipt of the Children's Health Insurance Program (CHIP).

A health plan or dental plan is an organization of licensed insurers, non profit organizations and managed care organizations (Co's) who are contracted to provide services to children eligible for the Children's Health Insurance Program. A primary care provider (PC) is a doctor, nurse, dentist or other health professional who is responsible for providing and coordinating the CHIP child's health care.

Most CHIP children will receive care through a health plan or dental plan, however if there is no health plan or dental plan available in the area, they can choose fee-for-service. With fee for service you can attend any doctor or other provider who will take your children's medical card for payment.

This is a business processing entity which is associated with the Children's Health Insurance Program product delivery. An organization's administrator must administer certain entities when creating and maintaining Children's Health Insurance Program product deliveries.

Example

Susan Smith is a child in a household who is currently receiving Children's Health Insurance. Susan Smith has a health and dental plan which are provided for by Susan Smith's local family doctor and dentist. A case worker creates a Benefit Delivery System Details record with the details of the health plan, dental plan and the doctor and dentist who are providing the services under of those plans to Susan Smith. Benefit Delivery System Details is on Susan's Smith's Children's Health Insurance product delivery.

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 Product::Service Layer::entity::CHIP::Processing Entities::BenefitDeliverySystemDetails::BenefitDeliverySystemDetails
Controlling File: ISProduct\model\Service Layer\entity\CHIP\Processing Entities\BenefitDeliverySystemDetails\BenefitDeliverySystemDetails_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
benefitDelSysDtlsIDkeynoSystem generated unique identifier for the benefit delivery system details.ISP_BENEFIT_DELIVERY_SYSTEM_DETAILS_ID SVR_INT64
caseIDdetailsnoThe unique identifier of the associated product delivery.CASE_ID SVR_INT64
concernRoleIDdetailsnoThe unique identifier of the household member included in the product delivery to whom these benefit delivery system details apply.CONCERN_ROLE_ID SVR_INT64
healthPlanIDdetails The unique identifier of the health plan included in the product delivery.ISP_THIRD_PARTY_PRODUCT_ID SVR_INT64
dentalPlanIDdetails The unique identifier of the dental plan included in the product delivery.ISP_THIRD_PARTY_PRODUCT_ID SVR_INT64
healthPlanFeeForServiceIDdetails The unique identifier of the medical fee for service system included in the product delivery.FEE_FOR_SERVICE_ID SVR_INT64
dentalPlanFeeForServiceIDdetails The unique identifier of the dental fee for service system included in the product delivery.FEE_FOR_SERVICE_ID SVR_INT64
healthPlanPrimCareProvIDdetails The unique identifier of the primary care provider associated with the health plan included in the product delivery.PRIMARY_CARE_PROVIDER_ID SVR_INT64
dentalPlanPrimCareProvIDdetails The unique identifier of the primary care provider associated with the dental plan included in the product delivery.PRIMARY_CARE_PROVIDER_ID SVR_INT64
startDatedetails The start date of the benefit delivery system details.CURAM_DATE SVR_DATE
endDatedetails The end date of the benefit delivery system details.CURAM_DATE SVR_DATE
statusdetails The status of the benefit delivery system details. This cannot be modified by the user.EVIDENCE_STATUS_CODEEvidenceStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
BenefitDeliverySystemDetails.caseIDCaseHeader.caseID
BenefitDeliverySystemDetails.concernRoleIDConcernRole.concernRoleID
Indices (2)
Index NameAttributes
IND__1000572126caseID
IND__1570529254concernRoleID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: benefitDelSysDtlsID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readmultireadmulti   
validateDuplicates    
readBenefitDeliverySystemByCaseIDConcernRoleIDnsreadmulti Read a benefit delivery system by case id and concern role id. 
Related Pages (15)