3.2.4 Party Contact Details
Entity Name: CONT
Description: This table holds party contact details from product processor.
Data Sequence:
CONT|Party Id|Contact Point|Value|Time From (weekdays)|Time To (weekdays)|Time From (weekends)|Time To (weekends)|Do Not Disturb|Do Not Disturb Start Date|Do Not Disturb End Date|Is Preferred|Is Preferred for SMS Alerts|Permission to Call|Permission to Record Calls|Consent to communicate Electronically|Time Zone|Country Code|Phone Extension|Consent to communicate on Messenger|Start Date|End Date|Preference Frequency|Status|udf1|udf2|udf3|udf4|udf5|udf6|udf7|udf8|udf9|udf10|udf11|udf12|udf13|udf14|udf15|udf16|udf17|udf18|udf19|udf20|udf21|udf22|udf23|udf24|udf25|udf26|udf27|udf28|udf29|udf30|udf31|udf32|udf33|udf34|udf35|udf36|udf37|udf38|udf39|udf40|udf41|udf42|udf43|udf44|udf45|udf46|udf47|udf48|udf49|udf50
Table 3-10 Party Contact Details
Field Name | Description | Possible Values / Examples | Data Type | Data Length | Required/Optional |
---|---|---|---|---|---|
Party Id | Party Id as stored in Host | - | VARCHAR2 | 30 | Required |
Contact Point | Type of Contact Point |
CLRHM - Mobile Home CLRWK - Mobile Work ELAHM - Email Home ELAWK - Email Home FLLHM- Fixed Landline Home |
VARCHAR2 | 30 | Required |
Value | Contact Point Value e.g. if Contact Point is Mobile then provide mobile number, if Email then provide email id | - | VARCHAR2 | 30 | Required |
Time From (weekdays) | Start Time for contacting on weekdays | In hundred hour format (e.g. 1800 for 6:00 PM) | NUMBER | 4 | Optional |
Time To (weekdays) | End Time for contacting on weekdays | In hundred hour format (e.g. 1800 for 6:00 PM) | NUMBER | 4 | Optional |
Time From (weekends) | Start Time for contacting on weekends | In hundred hour format (e.g. 1800 for 6:00 PM) | NUMBER | 4 | Optional |
Time To (weekends) | End Time for contacting on weekends | In hundred hour format (e.g. 1800 for 6:00 PM) | NUMBER | 4 | Optional |
Do Not Disturb | Do Not Disturb Flag | Y/N | NUMBER | 1 | Optional |
Do Not Disturb Start Date | Do Not Disturb Start Date | - | DATE | - | Optional |
Do Not Disturb End Date | Do Not Disturb End Date | - | DATE | - | Optional |
Is Preferred | Is the number preferred to Contact | Y/N | CHAR | 1 | Optional |
Is Preferred for SMS Alerts | Is Preferred for SMS Alerts | Y/N | CHAR | 1 | Optional |
Permission to Call | Permission to Call | Y/N | CHAR | 1 | Optional |
Permission to Record Calls | Permission to Record Calls | Y/N | CHAR | 1 | Optional |
Consent to communicate Electronically | Consent to communicate Electronically | Y/N | CHAR | 1 | Optional |
Time Zone | Time Zone | - | VARCHAR2 | 30 | Optional |
Country Code | ISD code of Country | - | VARCHAR2 | 10 | Optional |
Phone Extension | Phone Extension | - | VARCHAR2 | 30 | Optional |
Consent to communicate On Messenger | Consent to communicate on Messenger | Y/N | CHAR | 1 | Optional |
Start Date | Start date for using this contact point and type | - | DATE | - | Optional |
End Date | End date for using this contact point and type | - | DATE | - | Optional |
Preference Frequency | Preferred Frequency of contact | - | VARCHAR2 | 10 | Optional |
Status | Status if this active or dormant | - | VARCHAR2 | 30 | Optional |
Parent topic: Party Data