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
| 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 TFNRegistry™ specification manual that corresponds with the release of software active in the SCP. |
| 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. |
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 |
|