SSR_RI_OLO_NLD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SSR_BR_INDEX_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction Index ID
2	SSR_BR_MSGUUID	Character(50)	VARCHAR2(50) NOT NULL	Message ID
3	SSR_BR_TRANS_INOUT	Character(1)	VARCHAR2(1) NOT NULL	Transaction Direction I=Inbound O=Outbound
4	SSR_BR_TRANS_DTTM	DateTime(26)	TIMESTAMP	Transaction DateTime
5	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
6	SERVICENAME	Character(50)	VARCHAR2(50) NOT NULL	Service name
7	SSR_BR_MSGBO	Character(50)	VARCHAR2(50) NOT NULL	Message
8	SSR_BR_SENDER	Character(4)	VARCHAR2(4) NOT NULL	Transaction Sender
9	SSR_BR_RECEIVER	Character(4)	VARCHAR2(4) NOT NULL	Receiver
10	SSR_BR_ACCEPTED	Character(1)	VARCHAR2(1) NOT NULL	Accepted Indicator J=Accepted N=Rejected
11	IBPUBTRANSACTID	Character(36)	VARCHAR2(36) NOT NULL	Orig Transaction ID
12	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
13	SSR_RI_EDU_GOV_NLD	Character(20)	VARCHAR2(20) NOT NULL	Educational Board Code
14	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
15	SSR_RI_OLO_COD_NLD	Character(12)	VARCHAR2(12) NOT NULL	RIO Establishment ID
16	BEGIN_DT	Date(10)	DATE	Begin Date
17	END_DT	Date(10)	DATE	end date
18	SSR_RI_POSTAL_NLD	Character(7)	VARCHAR2(7) NOT NULL	Postal
19	SSR_RI_NUM1_NLD	Character(6)	VARCHAR2(6) NOT NULL	Number 1
20	SSR_RI_NUM2_NLD	Character(6)	VARCHAR2(6) NOT NULL	Number 2
21	SSR_RI_BAGID_NLD	Character(50)	VARCHAR2(50) NOT NULL	BagID
22	SCC_LATITUDE	Signed Number(12,7)	DECIMAL(10,7) NOT NULL	Latitude
23	SCC_LONGITUDE	Signed Number(12,7)	DECIMAL(10,7) NOT NULL	Longitude
24	SSR_RI_MUT_TYP_NLD	Character(4)	VARCHAR2(4) NOT NULL	Mutation Type T=Addition V=Removal W=Change