The SCP List table contains the following data for each SCP:
- SCP Id code
- Node Id code
- Applications at the SCP
- Mate for the SCP
- Version number of the SCP software
- Manual number
- Queue state of the application
- State code for the SCP
Table 119 RHDB_SCPLIST
|
RHDB_SCPLIST |
||
|
Field |
Characters |
Description |
|
ScpId |
varchar2(4) |
The SCP ID code. |
|
NodeId |
varchar2(11) |
The 11 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. |
|
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. |
|
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_SCPLIST Table
The index and fields used for the RHDB_SCPLIST table are the same as for the RHDB_SCPSTATUS table:
|
RHDB_SCPLIST |
|
|
Index Name |
Fields Used |
|
rhdb_ ScpStatus _idx1 |
|
|
rhdb_ ScpStatus _idx2 |
|