Upload Guidelines:
The file must be saved in an Excel workbook (.csv, .xls, .xlsx) file format.
- The Excel workbook should contain a Header row and a Data row(s).
- The Header row (column) should contain the following field names (delimited by a comma if using a Comma Separated Values (CSV) file type): “Toll-Free Number”, “RespOrgID”, and “CurrentStatus” in separate columns.
- The Header row can contain the following field names (delimited by a comma if using a CSV file type): “Approval” and “RejectNote” in separate columns to the right of the “CurrentStatus” column.
- The “Toll-Free Number” column is required and must contain a single 10 Digit Toll-Free Number (TFN) per row. This column must contain only the TFN(s) that you want to remove from the request.
- The “RespOrgID” column is required. If data is populated in the rows for this column, it must contain a single Controlling (current, old) Resp Org ID (5 alphanumeric characters) per row.
- The “CurrentStatus” column is required. If data is populated in the rows for this column, it must contain the current status of the TFN (a single status per row) or the Data rows must be left blank.
- The “Approval” column is optional and if used, the Data rows must be left blank.
- The “RejectNote” column is optional and if used, the Data rows must be left blank.
Outgoing ROC Request Excel Workbook Upload Example:
Toll-Free Number |
RespOrgID |
CurrentStatus |
Approval |
RejectNote |
800-000-0000 |
AAXXX |
Pending |
|
|
888-000-0000 |
BBXXX |
Pending |
|
|
877-000-0000 |
CCXXX |
Pending |
|
|
866-000-0000 |
DDXXX |
Pending |
|
|
855-000-0000 |
EEXXX |
Pending |
|
|
855-000-0001 |
FFXXX |
Pending |
|
|
855-000-0002 |
GGXXX |
Overdue |
|
|