Phone Plus Output Columns
Use this article if your batch processing includes Phone Plus validation. Phone Plus extends standard Phone validation with operator, portability, and switch-on confirmation data. Applies to file-based batch processing only.
Dynamic phone field names
Phone output column names include the placeholder {FIELD_NAME_PHONE}. This is replaced by your actual input column name. Example: if your phone column is named mobile, then DQE_{FIELD_NAME_PHONE}_ERROR_CODE becomes DQE_mobile_ERROR_CODE.
Phone Plus columns
| Column | Description |
|---|---|
| DQE_{FIELD_NAME_PHONE}_ERROR_CODE | Return code after Phone Plus processing |
| DQE_{FIELD_NAME_PHONE} | Reformatted phone number |
| DQE_{FIELD_NAME_PHONE}_IS_MOBILE | Mobile detection (True/False) |
| DQE_{FIELD_NAME_PHONE}_OLD_OPERATOR | Previous operator (portability) |
| DQE_{FIELD_NAME_PHONE}_OPERATOR | Current operator |
| DQE_{FIELD_NAME_PHONE}_PORTED | Portability detection (Y/N) |
Phone Plus error code values
| Value | Description |
|---|---|
| 0 | Invalid or non-existing phone number |
| 1 | Valid number with confirmation that the phone is switched on |
| 2 | Valid number — no confirmation that the phone is switched on |
Mobile detection values
| Value | Description |
|---|---|
| False | Number is not a mobile |
| True | Number is a mobile |
Portability values
| Value | Description |
|---|---|
| Y | Number has been ported to a new operator |
| N | Number has not been ported |
Best practices
- -Use ERROR_CODE to distinguish invalid, valid-on, and valid-off numbers
- -Use IS_MOBILE to adapt communication channels
- -Use operator and portability data only when relevant to your business process
- -Keep the original input phone field for comparison