The Allowable CICs for Customer Record Input and Approval Report is a pre- defined on- demand report that is initiated from an output to Reporting.
This report lists the Carrier Identification Codes (CICs) that a Resp Org user is allowed to use in Customer Records. All Resp Orgs within the same Entity can use the same CICs in their records. For all CICs other than CIC-0110: This report indicates whether or not approval is required for addition-to-routing or routing-changes.
Disclaimer: Any images in this article are intended to be used as a guide for educational purposes only and they may differ slightly from the Production Environment.
Allowable CICs for Customer Record Input and Approval Field Descriptions
The following table identifies the Allowable CICs for Customer Record Input and Approval fields and their descriptions
|
Allowable CICs for Customer Record Input and Approval Field Descriptions |
|
|
Field |
Description |
|
Entity |
An identifier for the Entity. |
|
Resp Org |
An identifier for the Resp Org. |
|
Carrier Code |
Identifies the CICs that can be used in the Customer Records belonging to the queried Resp Org or Entity. The CICs are listed in ascending numerical order. |
|
Approval Add |
Indicates whether or not approval is required for addition-to-routing (ADD). For CIC-0110 these fields will have a “-”. For all other CICs, this field will have either an N or Y. |
|
Approval Change |
Indicates whether approval is required for routing-changes (CHANGE). For CIC-0110 these fields will have a “-”. For all other CICs, this field will have either an N or Y. |
|
Last Refresh Date/Time |
Identifies the date and time the report was last refreshed. |
|
Record Count |
Display the count of records associated with the filtered data set (xxxxxxx) and the grand total of records (yyyyyyy) formatted as xxxxxxx/yyyyyyy. |
Data Source Used to Create the Report
The “RHDB_ALLOWABLECICS” data source is used to create the Allowable CICs for Customer Record Input and Approval report. The fields used from this table are:
- As Of
- Automatic Manual Flag
- CCS Network Allowable CICs
- Approval Add1
- Approval Change1
- Entity
- Last Update Date/Time
- Resp Org
- Create Logonid
- Create Time
- Extractdate
- Logonid
- Phone
- Telco
- Update Logonid
- Update Time
- Username
- CR Status
- Effective Date
Note: Click here to find more information about the Allowable CICs for Customer Record Input and Approval Table (RHDB_ALLOWABLECICS).