SSR_BR_MIDB_NLD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	BIRTHDATE	Date(10)	DATE	Date of Birth
3	SSR_BR_NAT_ID_NLD	Character(20)	VARCHAR2(20) NOT NULL	Educational Number
4	SSR_BR_SEX_NLD	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
5	SAD_SL_SOFI_NBR	Character(9)	VARCHAR2(9) NOT NULL	Social Fiscal Number
6	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
7	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix
8	SSR_BR_FST_NMS_NLD	Character(200)	VARCHAR2(200) NOT NULL	Firstnames
9	SSR_BR_DTD_NLD	Date(10)	DATE	Date Deceased
10	SSR_BR_DTE_NLD	Date(10)	DATE	Date of Emigration from NLD
11	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
12	SSR_BR_BRTHCTY_NLD	Character(4)	VARCHAR2(4) NOT NULL	Birth Country
13	SSR_BR_INDPR_NLD	Character(1)	VARCHAR2(1) NOT NULL	Indication Privacy
14	SSR_BR_VPMT_NLD	Character(2)	VARCHAR2(2) NOT NULL	Residency/Visa Permit Type
15	SSR_BR_VPEDT_NLD	Date(10)	DATE	Effective Date
16	SSR_BR_ENVP_NLD	Date(10)	DATE	End Date Res/Visa permit Type
17	SSR_BR_STREET_NLD	Character(24)	VARCHAR2(24) NOT NULL	Street
18	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
19	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
20	SSR_BR_LOC_DESCR	Character(35)	VARCHAR2(35) NOT NULL	Location Description
21	SSR_BR_HOUSE_I_NBR	Character(2)	VARCHAR2(2) NOT NULL	House Number Indication
22	SSR_BR_POSTAL_NLD	Character(7)	VARCHAR2(7) NOT NULL	Postal Code
23	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
24	SSR_BR_FR_ADDR_1	Character(35)	VARCHAR2(35) NOT NULL	Foreign Address Line 1
25	SSR_BR_FR_ADDR_2	Character(35)	VARCHAR2(35) NOT NULL	Foreign Address Line 2
26	SSR_BR_FR_ADDR_3	Character(35)	VARCHAR2(35) NOT NULL	Foreign Address Line 3
27	SSR_BR_NATIONALITY	Character(4)	VARCHAR2(4) NOT NULL	Nationality Code 1
28	SSR_BR_NATION_CD_2	Character(4)	VARCHAR2(4) NOT NULL	Nationality Code 2
29	SSR_BR_COUNTRY_NLD	Character(4)	VARCHAR2(4) NOT NULL	Country
30	SAD_GBA_B_YR_NLD	Character(4)	VARCHAR2(4) NOT NULL	GBA Year of Birth
31	SAD_GBA_B_MN_NLD	Character(2)	VARCHAR2(2) NOT NULL	GBA Month of Birth
32	SSR_BR_SUBSCR_NLD	Character(4)	VARCHAR2(4) NOT NULL	Indication Subscription AAN=Set/Change Subscription Date UIT=Cancel subscription Default Value: UIT