The SCP Status table contains the node and application status data for each SCP (see Table 101 RHDB_SCPSTATUS).
Table 101 RHDB_SCPSTATUS
|
RHDB_SCPSTATUS |
||
|
Field |
Characters |
Description |
|
ScpId |
varchar2(4) |
The SCP ID code. |
|
ClliCode |
varchar2(11) |
The eleven character Common Language code for the SCP Id. |
|
Application |
varchar2(5) |
The application at the SCP:
|
|
Mate |
varchar2(4) |
The SCP ID for the MATE for the 800 type service. |
|
OverloadLevel |
varchar2(3) |
The node overload level: 0, 1, 2, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8, 4, 5, or 6. |
|
VersionNumber |
varchar2(7) |
The version number of the SCP software. |
|
ManualNumber |
varchar2(17) |
The reference number of the SMS/800 TFN Registry specification manual that corresponds with the release of software active in the SCP. |
|
ApplicationStatus |
varchar2(17) |
The status of the application:
|
|
QueueState |
varchar2(9) |
The queue state of the application in SMS/800 TFN Registry. |
|
StateCode |
varchar2(2) |
The state code. |
|
ExtractDate |
Date |
The date when the record was sent to the RHDB database. |
Index for RHDB_SCPSTATUS Table
The index and fields used for the RHDB_SCPSTATUS table are:
|
RHDB_SCPSTATUS |
|
|
Index Name |
Fields Used |
|
rhdb_ SCPStatus _idx1 |
|
|
rhdb_ SCPStatus _idx2 |
|