Table Description
County Details: A county and state in which services are provided by third party providers and/or primary care providers.

This facilitates the identification of third party providers, for example health plans or dental plans, operating locally to the household member.

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::CountyDetails::CountyDetails
Controlling File: ISProduct\model\Service Layer\entity\CHIP\Administration\CountyDetails\CountyDetails_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
countyDetailsIDkeynoSystem generated unique identifier for the county details.ISP_COUNTY_DETAILS_ID SVR_INT64
countyCodedetails Drop down list of all counties - populated from the county code table.ISP_COUNTY_CODEUtahCountiesSVR_STRING<10>
stateCodedetails Drop down list of states within the united states.STATE_CODES_CODEStateCodesSVR_STRING<10>
statusCodedetails Status of the record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
CountyDetailsLink.countyDetailsIDCountyDetails.countyDetailsID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: countyDetailsID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
validateDetails  Validates the CountyDetails entity details. 
validateDuplicates    
readAllnkreadmulti Reads all County Details records. 
searchByStatusreadmulti Search for County Details records by status. 
searchByCountyCodeStatusreadmulti Search for County Details records by county code. 
insertCountyDetailsnsinsert Inserts the records of county details. It takes the value for countyDetailsID.  
Related Pages (41)
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 County Details (Administration_createCountyDetails)
New Primary Care Provider County Details (Administration_createPrimaryCareProviderCountyDetails)
New Third Party Product County Details (Administration_createThirdPartyProductCountyDetails)
Fee For Service Home (Administration_feeForServiceHome)
County Details (Administration_listCountyDetails)
Select State and County (Administration_listCountyStateDetails)
Fee For Service (Administration_listFeeForService)
Select State and County (Administration_listFeeForServicePCPCountyStateDetails)
Fee For Service Primary Care Provider (Administration_listPrimaryCareProviderFeeForService)
Edit County Details (Administration_modifyCountyDetailsFromList)
Edit County Details (Administration_modifyCountyDetailsFromView)
Edit Fee For Service (Administration_modifyFeeForServiceFromList)
Edit Fee For Service (Administration_modifyFeeForServiceFromView)
Edit Fee For Service Primary Care Provider (Administration_modifyFeeForServicePrimaryCareProviderFromList)
Edit Fee For Service Primary Care Provider (Administration_modifyFeeForServicePrimaryCareProviderFromView)
Edit Primary Care Provider County Details (Administration_modifyPrimaryCareProviderCountyDetailsFromList)
Edit Primary Care Provider County Details (Administration_modifyPrimaryCareProviderCountyDetailsFromView)
Edit Fee For Service Primary Care Provider (Administration_modifyPrimaryCareProviderFFSFromList)
Edit Fee For Service Primary Care Provider (Administration_modifyPrimaryCareProviderFFSFromView)
Edit Third Party Product County Details (Administration_modifyThirdPartyProductCountyDetailsFromList)
Edit Third Party Product County Details (Administration_modifyThirdPartyProductCountyDetailsFromView)
Select State & County (Administration_selectPrimaryCareProviderCountyDetails)
Select State & County (Administration_selectThirdPartyProductCountyDetails)
View County Details (Administration_viewCountyDetails)
View Fee For Service Primary Care Provider (Administration_viewFeeForServicePrimaryCareProvider)
View Fee For Service Primary Care Provider (Administration_viewFeeForServicePrimaryCareProviderFromPCP)
View Primary Care Provider County Details (Administration_viewPrimaryCareProviderCountyDetails)
View Third Party Product County Details (Administration_viewThirdPartyProductCountyDetails)
Select Dental Plan By County (ISP_selectDentalPlanBenefitDeliverySystemEvidence)
Select Primary Care Provider (ISP_selectDentalPlanByPCPBenefitDeliverySystemEvidence)
Select Dental Plan County Details (ISP_selectDentalPlanCountyDetailsBenefitDeliverySystem)
Select Health Plan By County (ISP_selectHealthPlanBenefitDeliverySystemEvidence)
Select Health Plan by Primary Care provider (ISP_selectHealthPlanByPCPBenefitDeliverySystemEvidence)
Select State & County (ISP_selectHealthPlanCountyDetailsBenefitDeliverySystem)
Select Primary Care Provider (ISP_selectPCPDentalPlanBenefitDeliverySystemEvidence)
Select Primary Care Provider (ISP_selectPrimaryCareProviderBenefitDeliverySystemEvidence)
Fee For Service (ISP_viewFeeForService)