Phone Number from SAT Load Not Saving in PeopleSoft Default Format
I'm working through an issue with phone numbers that we are bringing in via our SAT load through File Parser. The file parser mapping is set up to bring in phone numbers direct from file. At some point, either at staging or when being inserted into PS_PERSONAL_PHONE, I would expect the phone number to be saved in the database in the PeopleSoft format (555/555-5555), but the numbers are saved only as ten digits without any special characters.
After navigating to Add/Update a person, the phone number appears to be formatted correctly. After saving the record, the phone number is updated in the PS_PERSONAL_PHONE record with the correct formatting. In order to fix this we currently have to open each record one by one and save or sql update the numbers.