The SCP Status table contains the node and application status data for each SCP.
| 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 TFNRegistry 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 TFNRegistry. |
| StateCode | varchar2(2) | The state code. |
| ExtractDate | Date | The date when the record was sent to the RHDB database. |
Index for RHDB_SCPSTATUS Table
| RHDB_SCPSTATUS | |
| Index Name | Fields Used |
| rhdb_ SCPStatus _idx1 |
|
| rhdb_ SCPStatus _idx2 |
|