bulk acct maint mapping guide-15

7/30/2019 Bulk Acct Maint Mapping Guide-15

1/25

Column

* Service Zip Code

Existing Account Optional

* Desired Area Code and Prefix

Update Information

* Price Plan

* Device ID

Features

Static IP

Static IP Type

EHA Pool

EHA Pool Type

* Contract Term

* User Info: First Name

* User Info: Last Name

* User Info: Address 1

New Activation Only TemplatColumn f ields w ith an asterisk are require

Note: this template must be saved as ".XLS


2/25

User Info: Address 2

* User Info: City

* User Info: State

* User Info: Zip Code

Cost Center

User ID

Billing Info: Location Type/BusinessBilling Info: Location Type/Residential

Billing Info: Company Name

Billing Info: Attention

* Billing Info: First Name

* Billing Info: Last Name

* Billing Info: Address 1

Billing Info: Address 2

* Billing Info: City

* Billing Info: State

* Billing Info: Zip Code

* Billing Info: Phone Number


3/25

Column Description

5-digit zip code - numeric

9-digit account number - 5 digit sub number. Numeric

First 6 digits for the new mobile number area code - pre-fix (123456). No space, /, - or any other special

characters. See sample format

Place an X in this field to indicate a change is required for this row

5-digit plan code - numeric

Alpha-numeric number found on the back of the device. The Device ID can be referenced as:

ESN (Electronic Serial Number decimal format)

- 11 decimal digits beginning with 000 to 255

- Created for devices that use CDMA technology

- Can be converted to 8 ESN Hexadecimal digits

MEID (Mobile Equipment Identifier)

- 14 Hexadecimal (alphanumeric) digits beginning with A0 to FF- Created for devices that use CDMA technology

- Can be converted to pESN, but pESNs are not guaranteed to be unique

- Cannot be converted to/from ESN or ESN (HEX)

IMEI (International Mobile Equipment Identifiers)

- 14 decimal digits beginning with 35 and moving upwards

- Created for devices that use GSM technology



5-digit plan code - numeric

If multiple features need to be associated/added as part of the activation use a semi-colon to separate the

added features. No spaced. Maximum of 300 total charactersSee table below when completing rows 14- 17 for IP.

The numerical IP address.When provisioning Public Static Restricted:"R"| Unrestricted: "U" (Unrestricted).

Pool Name for EHA (Enterprise Home Agent)

When provisioning Private Dynamic Automatic: "D" | Private Static Automatic: "S".

Enter the contract term to be associated to the transaction. Example 1 or 2 - (numerical)

User first name associated to the new line of service (alpha-numeric)

User last name associated to the new line of service (alpha-numeric)

Address associated to the user (Alpha-numeric)

.

" format.


4/25


City associated to the user (Alpha)

State associated to the user (Alpha)

Zip code associated to the user (numeric)

Company Cost Center

Wireless User ID

Marking an 'X' in this field will indicate if the billing address is Business (Alpha)Marking an 'X' in this field will indicate if the billing address is Residential (alpha)

Name of your Corporation (Alpha-numeric)

Name of an individual at your company the bill should be addressed to (Alpha Numeric)



Address for the monthly bill statement (Alpha-numeric)

Address for the monthly bill statement (Alpha-numeric)

City for the monthly bill statement (alpha)

State for the monthly bill statement (alpha)

Zip code for the monthly bill statement (numeric)

Corporations Contact Number


5/25

Sample Format

90210

123456789-00001

916214

x

12345

ESN: 04115678641

MEID: A0000005F91EC4

IMEI: 35950237516264

Single Feature: 12345

Multiple Features:

123456;654321;99999

11.1.333.99

R or U

POOLONE

D or S

1

Jane

Doe

777 Example Place


6/25

Apt. 2B

Sacramento

CA

95835

Marketing_1

Sales

xx

Your Company Name Here

Accounts Payable

Jane

Doe

123 Elm Street

Unit C

Sacramento

CA

90210

9165551212


7/25


8/25


9/25


10/25

Add/Remove FeaturesAll numbers will follow the changes selected

IMPORTANT NOTES: Do not delete the first 10 rows of the template

Items hi-lighted in RED are required values.

Column Name Formatting

Wireless Number 10-digit wireless telephone number (alpha-numeric)Update Information Place an X in this field to indicate a change is required for this row


11/25

Sample Format

916-555-1212x


12/25

New Service Activation & Keep Your Number

IMPORTANT NOTES: Do not delete the first 10 rows of the templateItems highlighted in RED are required values.

Save the template as .CSV (comma separated file) and upload.

Column Column Name Column Description

A Service Zip Code 5-di it zi code - numeric

B Existing Account Optional 9-digit account number - 5 digit sub number - numeric

C Desired NPA/NXX First 6 digits for the new mobile number: area code+pre-fix (123456). No space, or a

special characters permitted. See sample format.

D Update Information Place an X in this field to indicate a change is required for this row

E Price Plan 5-digit plan code - numeric

F Alpha-numeric number found on the back of the device. The Device ID can be refere





MEID (Mobile Equipment Identifier)

- 14 Hexadecimal (alphanumeric) digits beginning with A0 to FF








- Cannot be converted to from ESN or ESN HEX

G Features 5-digit plan code - numeric

If multiple features need to be associated/added as part of the activation use a semi-

separate the added features. No spaces. Maximum of 300 total characters

H Static IP Reserved IP Address supporting 'Restricted' or 'unrestricted' values for auto assignm

I Static IP Type The type of IP address that will be utilized by the device.

Public Static Restricted (R)

Public Static Unrestricted (U)

J EHA Pool Pool of IP addresses grouped by numeric range or attribute whether it be restricted

unrestricted

K EHA Pool Type Private D namic Automatic D or Private Static Automatic S

L Contract Term Enter the contract term to be associated to the transaction. Example 1 or 2 - (numer

M Carrier Info: Existing Port in MTN Mobile/landline Telephone Number porting over from another service provider (num

N Carrier Info: Account Number Billing account number from other service provider (alpha-numeric)

O Carrier Info: Account PIN This is a password or verification number. May or may not be required by other serv

id (Al h i )

Device ID


13/25

Change Plan/Text/DataIMPORTANT NOTE: Do not delete the first 10 rows of the template

The available plan codes for use are listed in row 7 of the spreadsheet.

Items hi-lighted in RED are required values.

Column Name Formatting

Wireless Number 10-digit wireless telephone number (alpha-numeric)

Update Information* Place an 'X' in this field to indicate a change is required for this row

After all necessary wireless numbers are selected, save the template as a .CSV (comma separated

will proceed to an online plan selection process. All wireless numbers selected for an update will


14/25

Sample Format Notes

916-555-1212This column will pre-populate with all the wireless numbers

associated to the account.

XIt is critical an "X" be placed in each row to insure successful

automation

file and upload per Bulk instructions. Upon upload, the system

receive the same plan selected during the online process.


15/25


16/25

Other Account MaintenanIMPORTANT NOTE: Do not delete the

Include an 'X' in the row for the reque

Column Name

Wireless Number (uneditable)Wireless User Name (uneditable)

Update Information

First Name

Last Name

Address 1

Address 2

City

State

Zip

Contact Phone number #1

Ext #1

Contact Phone number #2

Ext #2

Current Device ID (uneditable)

Suspend Lost/Stolen - 3G

New Device ID

After all necessary wireless numbers a


17/25

Suspend Seasonal/Vacation

Suspend with billing

Suspend without billing

Resume

Reset Voice Mail password


18/25

ceirst 10 rows of the template.

sted service transaction.

Formatting

Mobile telephone number - 10-digit number(numerical)User first and last name associated to the wireless number (Alpha-numeric)

Place an X in this field to indicate a change is required for this row





City associated to the user (Alpha)

State associated to the user (Alpha)

Zip code associated to the user (numeric)

Contact Number user can be reached (numeric). Supports hyphen and no-hyphen

Extension associated to Contact Phone Number (numeric)

Contact Number user can be reached (numeric). Supports hyphen and no-hyphen

Extension associated to Contact Phone Number (numeric)

The Serial Number associated to your existing device

Alpha-numeric number found on the back of the device. The Device ID can be referenced as:





MEID (Mobile Equipment Identifier)- 14 Hexadecimal (alphanumeric) digits beginning with A0 to FF









Suspends service when device was lost/stolen.

.

re selected, save the template as a .CSV (comma separated file) and upload.


19/25

Suspends service while user of device is on vacation.

Suspend service with the monthly access charges. Place an 'X' to indicate the transaction will be with

billing.

Suspend service without the monthly access charges. Place an 'X' to indicate the transaction will be

without billing.

Re-establish service from a suspended status.

Reset the voice mail password to the a default password: 1+last four digits of the wireless number. Place

an 'X' to indicate a change to the voicemail password is required


20/25

Sample Format Notes

916-555-1212 Value is pre-populated and uneditableJane Doe Value is pre-populated and uneditable

XValue is required. It is critical an "X "be placed in each row to insure

successful automation

Jane Value is pre-populated

Doe Value is pre-populated

777 Example Place Value is pre-populated

Apt. 2B Value is pre-populated if entered

Sacramento Value is pre-populated

CA Value is pre-populated

95835 Value is pre-populated

9165551212 or 916-555-1212 Value is pre-populated

1111 Value is pre-populated if entered

9165551212 or 916-555-1212 Not required

1111 Not required

41115678644 Value is pre-populated

04115678641 Not required with Suspend/Resume requests

A0000005F91EC4 Not required with Suspend/Resume requests

35950237516264 Not required with Suspend/Resume requests

X

If suspending the device for lost/stolen this column must be marked with an

'x' on the spreadsheet when suspending a device. In addition the 'Suspend

with billing' or 'Suspend without Billing' must be marked in conjunction with

this selection in order to suspend the service.


21/25

X

If suspending the device for seasonal/vacation this column must be marked as

an 'x' on the spreadsheet when suspending a device. In addition the 'Suspend

with billing' or 'Suspend without Billing' must be marked in conjunction with

this selection in order to suspend the service.

X

Either 'Suspend with billing' or 'Suspend without billing' must be marked with

an 'x' in conjunction with either 'Suspend Lost/Stolen' or 'SuspendSeasonal/Vacation.'

X

Either 'Suspend with billing' or 'Suspend without billing' must be marked with

an 'x' in conjunction with either 'Suspend Lost/Stolen' or 'Suspend

Seasonal/Vacation.'

X Place an 'X' to indicate this line of service will be resumed.

X Not required. This transaction is not in use for M2M


22/25


23/25


24/25

Bulk Upload Template

The following instructions apply to all spreadsheets available to Bulk Account Maintenance EXCEPT the

New Activation Only transaction. Refer to the tab that corresponds with your transaction for required

columns and formatting rules.

Instructions

1. Do not delete or change Rows 1 10.

a. Select all the cells in the spreadsheet. b. Right-click and select Format Cells in themenu.

c. Click on the Number tab. d. Select the Text option under the Categorysection.

e. Click on the OK button


25/25

bulk acct maint mapping guide-15

Documents