SAD_SBB_INT_NLD(SQL Table) |
Index Back |
|---|---|
BRON BO Integration Setup2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Added Subrecord for Integration Security Configuration (WSA Signing) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAD_SBB_OIN_NLD | Character(80) | VARCHAR2(80) NOT NULL | Unique Identification number for SBB processing |
| 2 | SAD_SBB_WSDL_NLD | Character(80) | VARCHAR2(80) NOT NULL | WSDL Address |
| 3 | SAD_SBB_LINK_NLD | Character(254) | VARCHAR2(254) NOT NULL | SBB file path |
| 4 | SAD_SBBWSAANON_NLD | Character(80) | VARCHAR2(80) NOT NULL | WSA Anonymous String |
| 5 | SCC_BRINCD_NLD | Character(4) | VARCHAR2(4) NOT NULL |
BRINcode
Prompt Table: SCC_BRIN_CD_VW |
| 6 | SAD_SBB_OINR_NLD | Character(80) | VARCHAR2(80) NOT NULL | Unique Identification number for BRON processing |
| 7 | SSR_WSA_WSUSCHEMA | Character(254) | VARCHAR2(254) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: WSU Schema |
| 8 | SSR_WSA_WSSESCHEMA | Character(254) | VARCHAR2(254) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: WSSE Schema |
| 9 | SSR_WSA_WSASCHEMA | Character(254) | VARCHAR2(254) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: WSA Schema |
| 10 | SSR_WSA_CANON_MTHD | Character(254) | VARCHAR2(254) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Canonicalization Method used for Signing ROD (Bron) / RIO / VVA / SBB messages |
| 11 | SSR_WSA_DIGST_MTHD | Character(254) | VARCHAR2(254) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Digest Method used for Signing ROD (Bron) / RIO / VVA / SBB messages |
| 12 | SSR_WSA_SIGN_MTHD | Character(254) | VARCHAR2(254) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Signature Method used for Signing ROD (Bron) / RIO / VVA / SBB messages |
| 13 | SSR_WSA_CR_HASH_FN | Character(20) | VARCHAR2(20) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Cryptographic Hash Function used for Signing ROD (Bron) / RIO / VVA / SBB messages |
| 14 | SSR_WSA_SIGN_ALGO | Character(20) | VARCHAR2(20) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Signing Algorithm used for Signing ROD (Bron) / RIO / VVA / SBB messages |
| 15 | SSR_WSA_BSEC_TKN_E | Character(254) | VARCHAR2(254) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Binary Security Token Encoding Type |
| 16 | SSR_WSA_BSEC_TKN_V | Character(254) | VARCHAR2(254) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Binary Security Token Encoding Value |
| 17 | SSR_WSA_CERTID | Character(10) | VARCHAR2(10) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Certificate Id used for Signing ROD (Bron) / RIO / VVA / SBB messages |
| 18 | SSR_WSA_TS_EXPIRE | Number(3,0) | SMALLINT NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Timestamp Expiration (in minutes) used for Signing ROD (Bron) / RIO / VVA / SBB messages |
| 19 | SSR_WSA_KEYINFO_ID | Character(20) | VARCHAR2(20) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Key Info Id used for Signing ROD (Bron) / RIO / VVA / SBB messages |
| 20 | SSR_WSA_SEC_TKN_ID | Character(20) | VARCHAR2(20) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Security Token Reference Value Id used for Signing ROD (Bron) / RIO / VVA / SBB messages |
| 21 | SSR_WSA_SEC_TK_URI | Character(20) | VARCHAR2(20) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Security Token Reference URI used for Signing ROD (Bron) / RIO / VVA / SBB messages |
| 22 | SSR_WSA_SEC_TK_TYP | Character(254) | VARCHAR2(254) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Security Token Reference Value Type used for Signing ROD (Bron) / RIO / VVA / SBB messages |
| 23 | IB_GATEWAY_URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 24 | SSR_WSA_KEYSTORE_L | Character(254) | VARCHAR2(254) NOT NULL | 2023-07-10, Bug 35269600 - SSR_EA_EARLYADMISSION, SSR_BRON AND SSR_RIO NEED UPDATE FOR REGULATORY NLD DEMAND: Keystore Location where the Certificate used for Signing ROD (Bron) / RIO / VVA / SBB messages is stored |
| 25 | CERTALIAS | Character(50) | VARCHAR2(50) NOT NULL | Certificate Alias |