Table Description
County Details Link: A link between a county details and primary care provider or third party product.

This link allows a county and state to be associated with one or more third party products or primary care providers. The purpose of this link is to show the counties and states in which third party products or primary care providers are available.

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::CountyDetailsLink::CountyDetailsLink
Controlling File: ISProduct\model\Service Layer\entity\CHIP\Administration\CountyDetailsLink\CountyDetailsLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
countyDetailsLinkIDkeynoA system generated unique identifier for a county details link.COUNTY_DETAILS_LINK_ID SVR_INT64
linkedIDdetailsnoLinks this record to a third party product or primary care provider.EVD_LINKED_ID SVR_INT64
linkedTypedetails The linked entity type e.g. Primary Care Provider, Third Party Product.COUNTY_DETAILS_LINKED_TYPECountyDetailsLinkedTypeSVR_STRING<10>
countyDetailsIDdetailsyesThe unique identifier for the county details.ISP_COUNTY_DETAILS_ID SVR_INT64
statusCodedetails The status of the county details link.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
startDatedetails The start date of the county details link association.CURAM_DATE SVR_DATE
endDatedetails The end date of the county details link association.CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
CountyDetailsLink.countyDetailsIDCountyDetails.countyDetailsID
Indices (2)
Index NameAttributes
searchDtlsIdxlinkedID, linkedType
IND_2136535046countyDetailsID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: countyDetailsLinkID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
validateDetails  Validates a CountyDetails link record. 
searchCountyDetailsLinkByLinkIDTypensmulti Searches for a list of CountyDetails link records by linkedID, linkedType and status.SQL
validateDuplicates  Validates County Details link evidence against duplicates. 
searchByStatusreadmulti Search county link details by status. 
searchCountyDetailsByCountyDetailsIDreadmulti Returns a list of County Details link records containing a particular countyDetailsID. 
insertCountyDetailsLinknsinsert Inserts the records of county details link. It takes the value for countyDetailsLinkID.  
Related Pages (23)
Delete County Details (Administration_cancelCountyDetails)
Delete Primary Care Provider (Administration_cancelPrimaryCareProvider)
Delete Primary Care Provider County Details (Administration_cancelPrimaryCareProviderCountyDetails)
Delete Third Party Product County Details (Administration_cancelThirdPartyProductCountyDetails)
New Primary Care Provider County Details (Administration_createPrimaryCareProviderCountyDetails)
New Third Party Product County Details (Administration_createThirdPartyProductCountyDetails)
Primary Care Provider County Details (Administration_listPrimaryCareProviderCountyDetails)
Third Party Product County Details (Administration_listThirdPartyProductCountyDetails)
Edit Primary Care Provider County Details (Administration_modifyPrimaryCareProviderCountyDetailsFromList)
Edit Primary Care Provider County Details (Administration_modifyPrimaryCareProviderCountyDetailsFromView)
Edit Third Party Product County Details (Administration_modifyThirdPartyProductCountyDetailsFromList)
Edit Third Party Product County Details (Administration_modifyThirdPartyProductCountyDetailsFromView)
View Primary Care Provider County Details (Administration_viewPrimaryCareProviderCountyDetails)
View Third Party Product County Details (Administration_viewThirdPartyProductCountyDetails)
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)
Select Primary Care Provider (ISP_selectPCPDentalPlanBenefitDeliverySystemEvidence)
Select Primary Care Provider (ISP_selectPrimaryCareProviderBenefitDeliverySystemEvidence)
View Benefit Delivery Systems Details (ISP_viewBenefitDeliverySystemEvidence)