Table Description
Third Party Product: A type of benefit delivery system used by the organization when processing medical assistance product deliveries, such as the Children's Health Insurance Program.

A benefit delivery system contains the details of the health plan, dental plan and the doctor and dentist who are providing the services under the plans associated with a household member eligible for the Children's Health Insurance Program. A third party product is either a health plan or a dental plan.

This is a business processing entity which is used during the maintenance and creation of 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.

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::Administration::ThirdPartyProduct::ThirdPartyProduct
Controlling File: ISProduct\model\Service Layer\entity\CHIP\Administration\ThirdPartyProduct\ThirdPartyProduct_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
thirdPartyProductIDkeynoSystem assigned unique reference number for a third party product.ISP_THIRD_PARTY_PRODUCT_ID SVR_INT64
thirdPartyProductTypedetails They type of the third party product used by the organization.ISP_THIRD_PARTY_PRODUCT_TYPEThirdPartyProductTypeSVR_STRING<10>
thirdPartyProductNamedetails The full name of the third party product.FULL_NAME SVR_STRING<131>
thirdPartyProductAddressIDdetails Unique reference number for the address of this third party product.ADDRESS_ID SVR_INT64
thirdPartyProductStartDatedetails The start date of the third party product.CURAM_DATE SVR_DATE
thirdPartyProductEndDatedetails The end date of the third party product.CURAM_DATE SVR_DATE
thirdPartyProductSWCoverageInddetails Indicator to show whether the third party product provides coverage for all counties within the state.CURAM_INDICATOR SVR_BOOLEAN
thirdPartyProductWebAddressdetails The web address of the third party product.WEBSITE_ADDRESS SVR_STRING<50>
statusCodedetails Third party product status code.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
thirdPartyProductPhoneNoIDdetails Unique reference number for the phone number record for this third party product.PHONE_NUMBER_ID SVR_INT64
Foreign Keys (1)
ChildParent
ThirdPartyProductPCPLink.thirdPartyProductIDThirdPartyProduct.thirdPartyProductID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: thirdPartyProductID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readAllnkreadmulti Reads all Third Party Product records. 
searchByStatusreadmulti Search for Third Party Product records by status. 
validateDetails  Validates the Third Party Product entity details 
validateDuplicates  Validates the Third Party Product evidence against existing records 
searchByTypensmulti Search for Third Party Products by type.SQL
insertThirdPartyProductnsinsert Inserts the records of third party product. It takes the value for thirdPartyProductID.  
Related Pages (36)
Delete County Details (Administration_cancelCountyDetails)
Delete Primary Care Provider (Administration_cancelPrimaryCareProvider)
Delete Primary Care Provider County Details (Administration_cancelPrimaryCareProviderCountyDetails)
Delete Primary Care Provider Third Party Product (Administration_cancelPrimaryCareProviderTPPLink)
Delete Third Party Product (Administration_cancelThirdPartyProduct)
Delete Third Party Product County Details (Administration_cancelThirdPartyProductCountyDetails)
Delete Third Party Product Primary Care Provider (Administration_cancelThirdPartyProductPCPLink)
New Primary Care Provider County Details (Administration_createPrimaryCareProviderCountyDetails)
New Primary Care Provider Third Party Product (Administration_createPrimaryCareProviderTPPLink)
New Third Party Product (Administration_createThirdPartyProduct)
New Third Party Product County Details (Administration_createThirdPartyProductCountyDetails)
New Third Party Product Primary Care Provider (Administration_createThirdPartyProductPCPLink)
Primary Care Provider Third Party Product (Administration_listPrimaryCareProviderTPPLink)
Third Party Product (Administration_listThirdPartyProduct)
Edit Primary Care Provider County Details (Administration_modifyPrimaryCareProviderCountyDetailsFromList)
Edit Primary Care Provider County Details (Administration_modifyPrimaryCareProviderCountyDetailsFromView)
Edit Primary Care Provider Third Party Product (Administration_modifyPrimaryCareProviderTPPLink_fromList)
Edit Primary Care Provider Third Party Product (Administration_modifyPrimaryCareProviderTPPLink_fromView)
Edit Third Party Product County Details (Administration_modifyThirdPartyProductCountyDetailsFromList)
Edit Third Party Product County Details (Administration_modifyThirdPartyProductCountyDetailsFromView)
Edit Third Party Product (Administration_modifyThirdPartyProductFromList)
Edit Third Party Product (Administration_modifyThirdPartyProductFromView)
Edit Third Party Product Primary Care Provider (Administration_modifyThirdPartyProductPCPLink_fromList)
Edit Third Party Product Primary Care Provider (Administration_modifyThirdPartyProductPCPLink_fromView)
Select Primary Care Provider Third Party Product (Administration_selectPrimaryCareProviderTPPLink)
View Primary Care Provider Third Party Product (Administration_viewPrimaryCareProviderTPPLink)
View Third Party Product (Administration_viewThirdPartyProduct)
Benefit Delivery Systems (ISP_listBenefitDeliverySystemEvidence)
Modify Benefit Delivery Systems Details (ISP_modifyBenefitDeliverySystemEvidence_fromList)
Modify Benefit Delivery Systems Details (ISP_modifyBenefitDeliverySystemEvidence_fromView)
Select Dental Plan By County (ISP_selectDentalPlanBenefitDeliverySystemEvidence)
Select Primary Care Provider (ISP_selectDentalPlanByPCPBenefitDeliverySystemEvidence)
Select Health Plan By County (ISP_selectHealthPlanBenefitDeliverySystemEvidence)
Select Health Plan by Primary Care provider (ISP_selectHealthPlanByPCPBenefitDeliverySystemEvidence)
View Benefit Delivery Systems Details (ISP_viewBenefitDeliverySystemEvidence)
Third Party Product Details (ISP_viewThirdPartyProduct)