The RHDB Invalid 6-Digit Converted CR table contains the converted Customer Records generated by the CR Batch Tool (in “RM” mode - removing invalid 6-Digit in Customer Records) after it has been executed. The data is accessible by authorized users. A Resp Org user can access/view the data they have permissions for (see Table 74 RHDB_INVALID6D_CRCONVERT).
Table 74 RHDB_INVALID6D_CRCONVERT
RHDB_INVALID6D_CRCONVERT |
||
Field |
Characters |
Description |
Rundatetime |
Timestamp |
Indicates the date & time when the tool is run. Format YYYYMMDDHH24MISSTTT. |
Dialnbr |
varchar2(15) |
Indicates the Toll-Free Number (DIAL#) or Template Name of the affected Customer Record that has invalid 6-Digit data. |
Effectivedate |
Date |
Indicates the Effective Date of the associated Customer Record. Format YYMMDDHH24MI. |
Resporg |
varchar2(5) |
Controlling Resp Org of the Customer Record. |
Crstatus |
varchar2 (1) |
Indicates the status of the associated Customer Record; Possible values:
|
Automaticflag |
varchar2 (1) |
Indicates whether the affected CR should be automatically converted or manual intervention is needed. Possible value: “Y” (automatic) for CRs successfully converted. |
Nphoneaffected |
varchar2 (1) |
Indicates whether the nphone field in CAD/TAD has invalid 6-Digit data or not. “Y” or “N”. |
Terminatingnbraffected |
varchar2 (1) |
Indicates whether the terminating number field in CAD/TAD has invalid 6-Digit data or not. “Y” or “N”. |
Lsoaffected |
varchar2 (1) |
Indicates whether the lso field in CAD/TAD has invalid 6- Digit data or not. “Y” or “N”. |
Aoslabelaffected |
varchar2 (1) |
Indicates whether the AOS label in CAD/TAD has invalid 6-Digit data or not. “Y” or “N”. |
Cpraffected |
varchar2 (1) |
Indicates whether the CPR of the associated CR has invalid 6-Digit data or not. “Y” or “N”. |
Ladaffected |
varchar2 (1) |
Indicates whether the LAD of the associated CR has invalid 6-Digit data or not. “Y” or “N”. |