The Allowable CICs for Customer Record Input and Approval table contains the CICs that a Resp Org user is allowed to use in Customer Records. For all CICs other than CIC-0110, the data indicates whether approval is required for addition-to-routing or routing changes.
| RHDB_ALLOWABLECICS | ||
| Field | Characters | Description |
| Entity | varchar2(2) | The first two characters of the user’s Resp Org. |
| Org | varchar2(3) | The 3rd, 4th and 5th characters of the user’s Resp Org ID. |
| CarrierCode | varchar2(6) | The CICs that can be used in the Customer Records belonging to any Resp Org in this Entity. |
| ApprovalAdd | varchar2(1) | 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. |
| ApprovalChange | varchar2(1) | 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. |
| RespOrg | varchar2(5) | The Resp Org ID. Please Note: This field is only available in Reporting. |
| Reporting Allowable CICs table also includes a Resp Org Field, for Reporting online user’s convenience, that is formed by the concatenation of the Entity field and Org field. |
Index for RHDB_ALLOWABLECICS Table
| RHDB_ALLOWABLECICS | |
| Index Name | Fields Used |
| rhdb_AllowableCICs_idx1 | Entity Carrier Code |
| rhdb_AllowableCICs_idx2 | CarrierCode Entity |