BBU To Update Contact Communication Preference
There are few requests to update the contact communication preference. As there are many such requests to update the communication preference, this page will provide the design details to BBU functionality.
The BBU template to update contact communication preference is attached below and the below table gives the details of the template.
| Sl.No | Filed Name | Description |
|---|---|---|
| 1 | Sequence Number | Sequence number of the record in template |
| 2 | Customer Code | Customer code with which the contact is associated for which the communication preference needs to be updated |
| 3 | Contact Code | Contact code for which the communication preference needs to be updated |
| 4 | Brand Code | Brand code against which the communication preference needs to be updated |
| 5 | Document Type | Document type against which the communication preference needs to be updated. Below are various typesArrival noticeBooking confirmationDelivery Order (CY)Delivery Order (SD)Equipment release orderExport Collection Order (SD shipment only)Special cargo acceptance requestStatus NotificationTPDoc Negotiable ReceivedTPDoc Negotiable ShippedTPDoc Sea Waybill ReceivedTPDoc Sea Waybill Shipped |
| 6 | Communication Preference Type | This is the communication preference type needs to be updated. Below are various typesAlternative e-mailDo Not SendFaxMobileOther e-mailPrintPrimary e-mailTelephoneWebPostal Address |
| 7 | Communication Detail | This actual communication preference value to be updated |
Below are the high level steps to update communication preference for a contact either by manual or by BBU
- First delete existing entry from CONTACT_DOC_TYPE_AND_COMM_PREF table with the combination of CUSTOMER_CMD_CODE,CONTACT_CMD_CODE,BRAND_CODE,DOCUMENT_TYPE,COMMUNICATION_PREF_TYPE if it already present and then create new entry
- Delete will be soft delete not hard delete
- CONTACT_DOC_TYPE_AND_COMM_PREF is the table in which against CUSTOMER_CMD_CODE,CONTACT_CMD_CODE,BRAND_CODE,DOCUMENT_TYPE,COMMUNICATION_PREF_TYPE combination the OTH_COMM_DTL attribute value will be updated.
update mdm_smds.contact_doc_type_and_comm_pref set is_deleted = 'Y', update_user = 'CMD_ADMIN', update_time = current_timestamp, source_of_last_update = 'PRTL' where CUSTOMER_CMD_CODE = 'TW00557649' and CONTACT_CMD_CODE = '' and BRAND_CODE='' and DOCUMENT_TYPE='' and COMMUNICATION_PREF_TYPE='';
- If the given customer-contact parent records not present then we can update the communication preference.
- Below are the Attributes in BBU template which are already mentioned in above table CUSTOMER_CMD_CODE CONTACT_CMD_CODE BRAND_CODE DOCUMENT_TYPE COMMUNICATION_PREF_TYPE OTH_COMM_DTL
- If the communication preferecne with combination of CUSTOMER_CMD_CODE,CONTACT_CMD_CODE,BRAND_CODE,DOCUMENT_TYPE,COMMUNICATION_PREF_TYPE, OTH_COMM_DTL already present, what we need to do?
- If the communication preference with CUSTOMER_CMD_CODE,CONTACT_CMD_CODE,BRAND_CODE,DOCUMENT_TYPE,COMMUNICATION_PREF_TYPE, OTH_COMM_DTL combination already not present, then we can create new record.
- If the communication preference already present with CUSTOMER_CMD_CODE,CONTACT_CMD_CODE,BRAND_CODE,DOCUMENT_TYPE combination but any attribute either COMMUNICATION_PREF_TYPE or OTH_COMM_DTL is different then soft delete existing and create new record
- If communication pref is present for a particular brand, do we need to create same for the requested brand ?
BBU Template