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 (see Table 59 RHDB_ALLOWABLECICS).
Table 59 RHDB_ALLOWABLECICS
|
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
The index and fields used for the RHDB_ALLOWABLECICS table are:
|
RHDB_ALLOWABLECICS |
|
|
Index Name |
Fields Used |
|
rhdb_AllowableCICs_idx1 |
Entity Carrier Code |
|
rhdb_AllowableCICs_idx2 |
CarrierCode Entity |