SSR_BR_IDBO_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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	BIRTHDATE	Date(10)	DATE	Date of Birth
14	SSR_BR_NAT_ID_NLD	Character(20)	VARCHAR2(20) NOT NULL	Educational Number
15	SSR_BR_SEX_NLD	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
16	SAD_SL_SOFI_NBR	Character(9)	VARCHAR2(9) NOT NULL	Social Fiscal Number
17	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
18	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix
19	SSR_BR_FST_NMS_NLD	Character(200)	VARCHAR2(200) NOT NULL	Firstnames
20	SSR_BR_DTD_NLD	Date(10)	DATE	Date Deceased
21	SSR_BR_DTE_NLD	Date(10)	DATE	Date of Emigration from NLD
22	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
23	SSR_BR_BRTHCTY_NLD	Character(4)	VARCHAR2(4) NOT NULL	Birth Country
24	SSR_BR_INDPR_NLD	Character(1)	VARCHAR2(1) NOT NULL	Indication Privacy
25	SSR_BR_VPMT_NLD	Character(2)	VARCHAR2(2) NOT NULL	Residency/Visa Permit Type
26	SSR_BR_VPEDT_NLD	Date(10)	DATE	Effective Date
27	SSR_BR_ENVP_NLD	Date(10)	DATE	End Date Res/Visa permit Type
28	SSR_BR_STREET_NLD	Character(24)	VARCHAR2(24) NOT NULL	Street
29	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
30	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
31	SSR_BR_LOC_DESCR	Character(35)	VARCHAR2(35) NOT NULL	Location Description
32	SSR_BR_HOUSE_I_NBR	Character(2)	VARCHAR2(2) NOT NULL	House Number Indication
33	SSR_BR_POSTAL_NLD	Character(7)	VARCHAR2(7) NOT NULL	Postal Code
34	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
35	SSR_BR_FR_ADDR_1	Character(35)	VARCHAR2(35) NOT NULL	Foreign Address Line 1
36	SSR_BR_FR_ADDR_2	Character(35)	VARCHAR2(35) NOT NULL	Foreign Address Line 2
37	SSR_BR_FR_ADDR_3	Character(35)	VARCHAR2(35) NOT NULL	Foreign Address Line 3
38	SSR_BR_NATIONALITY	Character(4)	VARCHAR2(4) NOT NULL	Nationality Code 1
39	SSR_BR_NATION_CD_2	Character(4)	VARCHAR2(4) NOT NULL	Nationality Code 2
40	SSR_BR_COUNTRY_NLD	Character(4)	VARCHAR2(4) NOT NULL	Country
41	SSR_BR_SPONT_NLD	Character(1)	VARCHAR2(1) NOT NULL	Spontaneous
42	SAD_GBA_B_YR_NLD	Character(4)	VARCHAR2(4) NOT NULL	GBA Year of Birth
43	SAD_GBA_B_MN_NLD	Character(2)	VARCHAR2(2) NOT NULL	GBA Month of Birth
44	SSR_BR_SUBSCR_NLD	Character(4)	VARCHAR2(4) NOT NULL	Indication Subscription AAN=Set/Change Subscription Date UIT=Cancel subscription
45	SCC_BRINCD_NLD	Character(4)	VARCHAR2(4) NOT NULL	BRINcode