Why Export Contact Object Erases the Leading Zeros from Phone Numbers?

Summary:

Why Export Contact Object Erases the Leading Zeros from Phone Numbers?

Content (required):

**This post was created as part of a How to Service Request (SR) **

Export the contact object via Export Management, in the export output .csv file, leading zeros are erased from PhoneAreaCode and PhoneNumber fields. Why?

select owner_table_id, PHONE_AREA_CODE, PHONE_NUMBER, raw_phone_number from fusion.hz_contact_points where owner_table_id in (300000156472372,300000156519245);

 OWNER_TABLE_ID   PHONE_AREA_CODE        PHONE_NUMBER    RAW_PHONE_NUMBER

    300000156472372                                                  04112345678             1-04112345678

    300000156519245   041                                               1234567                 1-041-1234567

Instead of seeing 041 for the Phone Area Code in the output .csv file, you see 41.