Table Description
Contact Address: An address for a contact.
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::ContactAddress::ContactAddress
Controlling File: core\model\Packages\Concern\ContactAddress_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
contactAddressIDkeynoUnique reference number assigned by the systemCONTACT_ADDRESS_ID SVR_INT64
contactIDdetailsnoUnique reference number assigned by the system to a contact.CONTACT_ID SVR_INT64
addressIDdetailsnoUnique reference number assigned by the system to an addressADDRESS_ID SVR_INT64
typeCodedetails Code value to indicate the type of address for the ContactADDRESS_TYPE_CODEAddressTypeSVR_STRING<10>
startDatedetails Commencement Date of Contact Address.CURAM_DATE SVR_DATE
endDatedetails Expiry Date of Contact Address.CURAM_DATE SVR_DATE
statusCodedetails contains contact address status code.CODETABLE_CODE SVR_STRING<10>
commentsdetails contains comments of contact address.COMMENTS SVR_STRING<300>
Foreign Keys (2)
ChildParent
ContactAddress.addressIDAddress.addressID
ContactAddress.contactIDConcernRoleContact.contactID
Indices (2)
Index NameAttributes
ContactAddressIndecontactID
IND__1791905436addressID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByContactIDnsmulti Populate all the records by contactIDSQL
removeremove Standard Operation 
searchActiveByContactIDnsmulti read all the active contactsSQL
Related Pages (0)