PluginConfigWSTrustBridge (ver9.0.0)
This table is used to store setup information when using a WS-Trust Bridge for a plugin. The WS-Trust Bridge Setup page is accessible via Start > System > System Settings > Plugin Management Configuration > PowerSchool WS-Trust Bridge > WS-Trust Bridge.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
EncryptionCert | 9.0.0 | Varchar2(256) | The name of the certificate used to encrypt the security token. The certificate must be the same as the certificate used by ADFS. |
ID | 9.0.0 | Number(10,0) | Unique number created by the application. Required. |
IDPSigningCert | 9.0.0 | Varchar2(256) | The name of the certificate used to sign the SAML response. Must be the same as the certificate used by ADFS. |
PassiveAddress | 9.0.0 | Varchar2(256) | The URL of the ADFS. |
PluginDefID | 9.0.0 | Number(10,0) | ID of the associated PluginDef record. Required. |
Realm | 9.0.0 | Varchar2(256) | The URL used by PowerSchool to communicate with ADFS. PowerSchool WS-Trust Bridge plugin installation defaults the value to the External Access on the Global Server Settings page. |
| SecurityAttributeName | 9.0.0 | Varchar2(40) | The name of the ADFS claim. Claims are used for authorization purposes. |
WhenCreated | 9.0.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 9.0.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 9.0.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 9.0.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |