Alternate Contact Number in the Unity Database

Unanswered Question
Aug 19th, 2008


I have a client that would like us to pre-load approximately 700 cell phone #s as alternate contacts for their users. I can see how I can use the sp_ModifyMenuEntry procedure to assign the action to the 1 key, but I haven't been able to find where in the database the alternate contact number is stored.

Can anyone tell me how to find this or is this particular value not available via the stored procedures/views?



I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
milucero Wed, 08/20/2008 - 11:07


What version of Unity are you using?

Normaly all extensions are store in the DTMFAccessId table.

You may aslo be able to use the bulk edit tool to accomplish this.


paulw.wilkinson Wed, 08/20/2008 - 13:27


It is Unity 5. I will have another look at that table, but I don't think it is there.

From the web interface you can select "call alternate number" from the menu configuration options and then enter the number in a text field directly below this option.

Ginger Dillon Wed, 08/20/2008 - 16:18

Hi -

Have you considered Bulk Edit using a CSV file that selects the subscribers to edit?


eschulz Wed, 08/20/2008 - 16:32

BulkEdit sounds like a much better way to go. But if you must know, the Alt Contact Number is stored in the ReferralExtension column of the Subscriber table.



This Discussion