Table Description
Service Supplier Link: A service supplied by a service supplier.
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::Core::Reference Model::Concern::Entity Objects::ServiceSupplierLink::ServiceSupplierLink
Controlling File: core\model\Packages\Concern\ServiceSupplierLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
serviceSupplierLinkIDkeynoUnique identifier for this serviceSupplierLink recordSERVICE_SUPPLIER_LINK_ID SVR_INT64
serviceIDdetailsnounique identifier for the ServiceSERVICE_ID SVR_INT64
supplierConcernRoleIDdetailsnoUnique reference number assigned by the system to a ConcernCONCERN_ROLE_ID SVR_INT64
startDatedetails Commencement Date for a service supplied by a supplierCURAM_DATE SVR_DATE
endDatedetails Expiry Date for a service supplied by a supplierCURAM_DATE SVR_DATE
statusCodedetails the Status code for a service supplied by a supplierRECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Comments on a service supplied by a supplierCOMMENTS SVR_STRING<300>
nextPaymentDatedetails The next payment date for the service being suppliedCURAM_DATE SVR_DATE
paymentFrequencydetails The payment frequency to the supplier for the serviceFREQUENCY_PATTERN SVR_STRING<9>
methodOfPmtCodedetails The preferred method of paymentMETHOD_OF_DELIVERY_CODEMethodOfDeliverySVR_STRING<10>
currencyTypedetails The preferred currency for paymentCURRENCY_CODECurrencySVR_STRING<10>
Foreign Keys (2)
ChildParent
ServiceSupplierLink.serviceIDService.serviceID
ServiceSupplierLink.supplierConcernRoleIDServiceSupplier.concernRoleID
Indices (3)
Index NameAttributes
DupSearchIndexsupplierConcernRoleID, serviceID, endDate, startDate, serviceSupplierLinkID, statusCode
ServiSuppLinkIndexserviceID, supplierConcernRoleID
SerSupplierLinkIndsupplierConcernRoleID, endDate
Operations (12)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchBySupplierConcernRoleIDreadmulti Retrieves a list of services supplier Links 
searchByConcernRoleIDnsmulti Retrieves a list of services supplied by a concernSQL
searchServicesNotSuppliednsmulti reads a list of services not supplied by the service supplier on the current date, with a status of normalSQL
searchByServiceIDnsreadmulti Retrieves a list of ConcernRoleIDs based on a service supplied. 
searchForDuplicatesnsmulti Search for any duplicate recordsSQL
searchByServicensreadmulti Read multiple records using the service id as the key 
searchActiveByConcernRoleIDnsmulti Retrieves a list of active services supplied by a concernSQL
searchByConcernRoleIDAndVersionNonsmulti Retrieves a list of services supplied by a concernSQL
Related Pages (20)