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