SSR_BR_INTV_NLD(SQL Table) |
Index Back |
|---|---|
BRON VAVO 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) --- BRON VAVO Integration Setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_BR_OIN_NLD | Character(80) | VARCHAR2(80) NOT NULL | Unique Identification number for BRON processing |
| 2 | SSR_BR_WSAANON_NLD | Character(80) | VARCHAR2(80) NOT NULL | WSA Anonymous String |
| 3 | SSR_BR_WSDL_ID_NLD | Character(80) | VARCHAR2(80) NOT NULL | WSDL address for Identification VAVO |
| 4 | SSR_BR_WSDL_ID2NLD | Character(80) | VARCHAR2(80) NOT NULL | WSDL address 2 for Identification VAVO |
| 5 | SSR_BR_WSDL_EN_NLD | Character(80) | VARCHAR2(80) NOT NULL | WSDL address for Enrollment VAVO |
| 6 | SSR_BR_WSDL_EN2NLD | Character(80) | VARCHAR2(80) NOT NULL | WSDL address 2 for Enrollment VAVO |
| 7 | SSR_BR_WSDL_EX_NLD | Character(80) | VARCHAR2(80) NOT NULL | WSDL address for Exam Results VAVO |
| 8 | SSR_BR_WSDL_EX2NLD | Character(80) | VARCHAR2(80) NOT NULL | WSDL address 2 for Exam Results VAVO |
| 9 | SSR_BR_NS_ID1_NLD | Character(80) | VARCHAR2(80) NOT NULL | Namespace Identification 1 |
| 10 | SSR_BR_NS_ID2_NLD | Character(80) | VARCHAR2(80) NOT NULL | Namespace Identification 2 |
| 11 | SSR_BR_NS_EN1_NLD | Character(80) | VARCHAR2(80) NOT NULL | Namespace Identification 2 |
| 12 | SSR_BR_NS_EN2_NLD | Character(80) | VARCHAR2(80) NOT NULL | Namespace Identification 2 |
| 13 | SSR_BR_NS_EX1_NLD | Character(80) | VARCHAR2(80) NOT NULL | Namespace Exam Result 1 |
| 14 | SSR_BR_NS_EX2_NLD | Character(80) | VARCHAR2(80) NOT NULL | Namespace Exam Result 2 |
| 15 | SSR_BR_NS_IN1_NLD | Character(80) | VARCHAR2(80) NOT NULL | Namespace Incoming 1 |
| 16 | SSR_BR_NS_IN2_NLD | Character(80) | VARCHAR2(80) NOT NULL | Namespace Incoming 1 |
| 17 | SSR_BR_NS_IN3_NLD | Character(80) | VARCHAR2(80) NOT NULL | Namespace Incoming 3 |
| 18 | SSR_BR_NS_IN4_NLD | Character(80) | VARCHAR2(80) NOT NULL | Namespace Incoming 4 |
| 19 | SSR_BR_NODE_NLD | Character(30) | VARCHAR2(30) NOT NULL |
BRON Messaging Node
Prompt Table: SSR_BR_NODEVWNL |
| 20 | SCC_BRINCD_NLD | Character(4) | VARCHAR2(4) NOT NULL |
BRINcode
Prompt Table: SCC_BRIN_CD_VW |
| 21 | 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 |
| 22 | 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 |
| 23 | 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 |
| 24 | 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 |
| 25 | 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 |
| 26 | 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 |
| 27 | 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 |
| 28 | 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 |
| 29 | 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 |
| 30 | 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 |
| 31 | 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 |
| 32 | 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 |
| 33 | 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 |
| 34 | 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 |
| 35 | 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 |
| 36 | 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 |
| 37 | IB_GATEWAY_URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 38 | 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 |
| 39 | CERTALIAS | Character(50) | VARCHAR2(50) NOT NULL | Certificate Alias |
| 40 | SSR_BR_LINK_NLD | Character(254) | VARCHAR2(254) NOT NULL | Logging File Path |
| 41 | SSR_BR_OINR_NLD | Character(80) | VARCHAR2(80) NOT NULL | Unique Identification number for BRON processing |