1.27 Contact Details File Upload

This topics describes the information to perform the bulk upload for the contact details maintenance in common core.

This process allows user to add, replace or remove records in contact data segment.

File Type Supported - CSV

File Naming Convention - ObpyContact_<UniqueName>.csv

Note:

Replace the <UniqueName> for each file upload.

Note:

The fields marked as Required are mandatory.

Table 1-37 Contact Details File Upload – Records

SR NO. FIELD CONSIDERATION UPLOAD FIELD NAME UI FIELD NAME ADD OPERATION REPLACE OPERATION REMOVE OPERATION DESCRIPTION
1 HEADER BASIC_INFO_CIF_ID NA Required Required Required Valid CIF ID
2 OPERATION CONTACT_OPERATION NA Required as "add" Required as "replace" Required as "remove" Operation to be performed
3 PARAM P_CONTACT_RECORD_IDENTIFIER NA Not Required Conditional Conditional Unique Party+Data Segment level record identifier
4 PARAM P_CONTACT_TYPE NA Not Required Conditional Conditional Type of Contact as Email or Mobile.

Sub-Entity Code

Email - EML

Mobile - MBL
5 PARAM P_CONTACT_VALUE1 NA Not Required Conditional Conditional Contact Value
  • Mobile Number for in case of Mobile Contact Type
  • Email ID in case of Email Contact Type
6 PARAM P_CONTACT_VALUE2 NA Not Required Conditional Conditional Contact Value
  • Mobile Number for in case of Mobile Contact Type
  • Empty in case of Email Contact Type
7 PARAM P_CONTACT_SUB_TYPE NA Not Required Conditional Conditional Sub-Type of Contact

Sub-Entity Codes as Configured for Entity Code

Mobile - CSY

Email - CSE
8 VALUES V_CONTACT_TYPE

Contact Type

EML for Email

MBL for Mobile

 Required As per Update Not Required Type of Contact as Email or Mobile.

Sub-Entity Code

Email - EML

Mobile - MBL
9 VALUES V_CONTACT_VALUE1 ISD Code or Email ID Required As per Update Not Required Contact Value
  • Mobile Number for in case of Mobile Contact Type
  • Email ID in case of Email Contact Type
10 VALUES V_CONTACT_VALUE2 Mobile Number Conditional As per Update Not Required Contact Value
  • Mobile Number for in case of Mobile Contact Type
  • Empty in case of Email Contact Type
11 VALUES V_CONTACT_SUB_TYPE Contact Sub Type Required As per Update Not Required Sub-Type of Contact

Sub-Entity Codes as Configured for Entity Code

Mobile - CSY

Email - CSE
12 VALUES V_CONTACT_PREFERRED Preferred Required As per Update Not Required Boleean true or false
13 VALUES V_CONTACT_ACTIVE_STATUS Activation Status Optional As per Update Not Required As per new field definition
14 VALUES V_CONTACT_VERIFIED_STATUS Verification Status Optional As per Update Not Required As per new field definition
15 VALUES V_CONTACT_VERIFIED_TYPE Verified Contact Type Optional As per Update Not Required As per new field definition
16 VALUES V_CONTACT_VERIFIED_DATETIME Verification Date/Time Optional As per Update Not Required As per new field definition
17 VALUES V_CONTACT_VERIFIED_BY Verified By Optional As per Update Not Required As per new field definition
18 VALUES V_CONTACT_MNL_VERIFIED_STATUS Manual Verification Status Optional As per Update Not Required As per new field definition
19 VALUES V_CONTACT_MNL_VERIFIED_CHANNEL Manual Verification Channel Optional As per Update Not Required As per new field definition
20 VALUES V_CONTACT_MNL_VERIFIED_DATETIME Manual Verification Date/Time Optional As per Update Not Required As per new field definition

Note:

For more information on File Upload Process, refer section: File Upload.

Parent topic: Configurations