Table Description
Fee For Service Primary Care Provider Link: A link between a fee for service and a primary care provider.

This represents a primary care provider who is offering a fee for service in the fee for service county.

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.

Example

TODO
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::FeeForServicePCPLink::FeeForServicePCPLink
Controlling File: ISProduct\model\Service Layer\entity\CHIP\Administration\FeeForServicePCPLink\FeeForServicePCPLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
feeForServicePCPIDkeynoA system generated unique identifier for the fee for service primary care provider link.FEE_FOR_SERVICE_PCP_ID SVR_INT64
feeForServiceIDdetailsnoA system generated unique identifier for the linked fee for service.FEE_FOR_SERVICE_ID SVR_INT64
primaryCareProviderIDdetailsnoThe unique identifier for the primary care provider.PRIMARY_CARE_PROVIDER_ID SVR_INT64
startDatedetails The start date of the fee for service primary care provider link.CURAM_DATE SVR_DATE
endDatedetails The end date of the fee for service primary care provider link.CURAM_DATE SVR_DATE
statusCodedetails The fee for service primary care provider link status code.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
FeeForServicePCPLink.feeForServiceIDFeeForService.feeForServiceID
FeeForServicePCPLink.primaryCareProviderIDPrimaryCareProvider.primaryCareProviderID
Indices (2)
Index NameAttributes
IND__1367670011primaryCareProviderID
IND__230498669feeForServiceID
Operations (10)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: feeForServicePCPID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
validateDetails  Validates a Fee For Service Primary Care Provider record. 
searchPCPFeeForServiceByFeeForServiceIDnsmulti Returns a list of Primary Care Provider Fee For Service records by Fee For Service ID.SQL
removeByPrimaryCareProviderIDnsremove   
searchFeeForServicePCPByPrimaryCareProviderIDns Searches for a Fee For Service Primary Care Provider record by primaryCareProviderID.SQL
validateDuplicates  Validates a of Fee For Service Primary Care Provider record against duplicates. 
searchByStatusreadmulti Search fee for service primary care provider link status key. 
insertFeeForServicePCPLinknsinsert Inserts the records of fee for service pcp link. It takes the value for feeForServicePCPLinkID.  
Related Pages (17)
Delete Fee For Service (Administration_cancelFeeForService)
Delete Fee For Service Primary Care Provider (Administration_cancelFeeForServicePrimaryCareProvider)
Delete Primary Care Provider (Administration_cancelPrimaryCareProvider)
Delete Fee For Service Primary Care Provider (Administration_cancelPrimaryCareProviderFFS)
New Fee For Service Primary Care Provider (Administration_createFeeForServicePrimaryCareProvider)
Fee For Service Primary Care Provider (Administration_listFeeForServicePrimaryCareProvider)
Fee For Service Primary Care Provider (Administration_listPrimaryCareProviderFeeForService)
Edit Fee For Service Primary Care Provider (Administration_modifyFeeForServicePrimaryCareProviderFromList)
Edit Fee For Service Primary Care Provider (Administration_modifyFeeForServicePrimaryCareProviderFromView)
Edit Fee For Service Primary Care Provider (Administration_modifyPrimaryCareProviderFFSFromList)
Edit Fee For Service Primary Care Provider (Administration_modifyPrimaryCareProviderFFSFromView)
View Fee For Service Primary Care Provider (Administration_viewFeeForServicePrimaryCareProvider)
View Fee For Service Primary Care Provider (Administration_viewFeeForServicePrimaryCareProviderFromPCP)
Select Primary Care Provider (ISP_selectDentalPlanByPCPBenefitDeliverySystemEvidence)
Select Health Plan by Primary Care provider (ISP_selectHealthPlanByPCPBenefitDeliverySystemEvidence)
Select Primary Care Provider (ISP_selectPCPDentalPlanBenefitDeliverySystemEvidence)
Select Primary Care Provider (ISP_selectPrimaryCareProviderBenefitDeliverySystemEvidence)