SSR_ECK_TRN_NLD(SQL Table) |
Index Back |
---|---|
ECK transaction record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SSR_BR_MSGUUID | Character(50) | VARCHAR2(50) NOT NULL | Message ID |
2 | SSR_BR_TRANS_DTTM | DateTime(26) | TIMESTAMP | Transaction DateTime |
3 | SSR_BR_TRANS_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Studielink Message Status
A=Partly processed C=Created P=Processed R=Received S=Suspended T=Error U=Unprocessed V=Sent |
4 | SERVICENAME | Character(50) | VARCHAR2(50) NOT NULL | Service name |
5 | SSR_BR_MSGBO | Character(50) | VARCHAR2(50) NOT NULL | Message |
6 | SSR_BR_SENDER | Character(4) | VARCHAR2(4) NOT NULL | Transaction Sender |
7 | SSR_BR_RECEIVER | Character(4) | VARCHAR2(4) NOT NULL | Receiver |
8 | SSR_BR_ACCEPTED | Character(1) | VARCHAR2(1) NOT NULL |
Accepted Indicator
J=Accepted N=Rejected |
9 | IBPUBTRANSACTID | Character(36) | VARCHAR2(36) NOT NULL | Orig Transaction ID |
10 | SSR_ECK_MSGTYP_NLD | Character(3) | VARCHAR2(3) NOT NULL |
ECK Message Type
BAT=retrieveBatch CHN=retrieveChain CRC=Corrected BSN ECK=Stampseudonym / ECK iD SCT=retrieveSector STM=Stampseudonym SWP=Swap of OWN for BSN |
11 | SSR_ECK_PRCTYP_NLD | Character(3) | VARCHAR2(3) NOT NULL |
ECK Process Type
BAT=Batch IND=Individual |
12 | SSR_BR_ERROR_CODE | Character(60) | VARCHAR2(60) NOT NULL | Error Code |
13 | SSR_BR_ERROR_TEXT | Character(200) | VARCHAR2(200) NOT NULL | Error Text |
14 | SSR_ECK_BTCHID_NLD | Character(50) | VARCHAR2(50) NOT NULL | ECK Batch Id |