Table Description
External Party Office Phone Number: The phone number of an external party office where the external party carries out its services.
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::Service Layer::ExternalPartyOfficePhoneNumber::Entity::ExternalPartyOfficePhoneNumber
Controlling File: core\model\Packages\Reference Model\Service Layer\ExternalPartyOfficePhoneNumber\Entity\ExternalPartyOfficePhoneNumber_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
officePhoneNumberIDkeynoUnique reference number assigned to the external party office phone number.INTERNAL_ID SVR_INT64
externalPartyOfficeIDdetailsnoUnique reference number assigned by the system to an external party office record.INTERNAL_ID SVR_INT64
phoneNumberIDdetailsnoUnique reference number assigned to the phone number.PHONE_NUMBER_ID SVR_INT64
phoneTypedetailsnoCode table code describing the type of phone number.PHONE_TYPE_CODEPhoneTypeSVR_STRING<10>
startDatedetailsnoStart date of a phone number.CURAM_DATE SVR_DATE
endDatedetailsyesEnd date of a phone number.CURAM_DATE SVR_DATE
recordStatusdetails Code table code describing the record status of the external party office phone number record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
ExternalPartyOfficePhoneNumber.externalPartyOfficeIDExternalPartyOffice.externalPartyOfficeID
Indices (1)
Index NameAttributes
IND__1188907437externalPartyOfficeID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: officePhoneNumberID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByExternalPartyOfficeIDreadmulti This method searches for all phone number who belong to the specified external party office. 
cancelnsmodifyPRE_DATA_ACCESS: yes
This method cancels the external party office phone number. 
Related Pages (14)