Table Description
ServiceAreaLink: This entity is used to associate counties and zip codes with a service area.
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::WorkspaceServices::Entity::Intake::ServiceAreaLink::ServiceAreaLink
Controlling File: WorkspaceServices\model\Packages\Entity\ServiceAreaLink\ServiceAreaLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
serviceAreaLinkIDkeynoUnique identifier for this record.INTERNAL_ID SVR_INT64
serviceAreaIDdetailsnoA reference to the service area.INTERNAL_ID SVR_INT64
relatedTypedetails The type of item added to the service area, either county or zip code.SERVICE_AREA_LINK_TYPEServiceAreaLinkTypeSVR_STRING<10>
relatedCodedetails The county or the zip code.CODETABLE_CODE SVR_STRING<10>
recordStatusdetails The status of the record, Active or Cancelled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
ServiceAreaLink.serviceAreaIDServiceArea.serviceAreaID
Indices (1)
Index NameAttributes
IND__238672294serviceAreaID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: serviceAreaLinkID
AUTO_ID_KEY: INTAKERAKS
Standard Operation 
readread Standard Operation 
removeremove Standard Operation 
searchByIDTypeStatusreadmulti   
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
insertServiceAreaLinknsinsert   
Related Pages (3)