Spargo Reg Example

	A	B	C	D	E	F	G	H	I	J
1	Client Endpoint	Client Attribute	Client Value	JUNO Attribute Type	JUNO Attribute ID	Tag/Dimension ID	System of Record	Show in Reporting?	Show on User Profile (onlly visible to user)?	Show on Public Profile?

2	Person	ashId		manup_users	client_id		Client	Yes	No	No
3	Person	firstName		manup_users	user_firstname		Client	Yes	Yes	Yes
4	Person	lastName		manup_users	user_lastname		Client	Yes	Yes	Yes
5	Person	email		manup_users	user_email		Client	Yes	Yes	No
6	Person	organization		manup_users	user_company		Client	Yes	Yes	Yes
7	Person	registrationId		Dimension	registrationId	22	Client	Yes	Yes	No
8	Person	degree		Dimension	degree	20	Client	Yes	Yes	No
9	Person	title		Dimension	title	18	Client	Yes	Yes	Yes
10	Person	city		Dimension	city	13	Client	Yes	Yes	No
11	Person	state		Dimension	state_province	14	Client	Yes	Yes	No
12	Person	country		Dimension	country	16	Client	Yes	Yes	Yes
13	Demographic	idQID_decoded = Twitter Handle @		Dimension	twitter	3	Client	No	Yes	Yes
14	Demographic	idQID_decoded = I consent to the sale, transfer, and processing of my personal data by exhibitors in attendance at this conference for marketing purposes.	Yes	Tag Type: Privacy Level	Yes	98	Client
15	Demographic	idQID_decoded = I consent to the sale, transfer, and processing of my personal data by exhibitors in attendance at this conference for marketing purposes.	No	Tag Type: Privacy Level	No	99
16	Demographic	idQID_decoded = Pronouns		Dimension	pronouns	23	Client	No	Yes	Yes
17	Demographic	idQID_decoded = Is this your first time attending the ASH annual meeting?		Dimension	meeting_attendance	24	Client	Yes	No	No
18	Demographic	idQID_decoded = What year did you attend your first ASH annual meeting?		Dimension	attend_year	26	Client	Yes	No	No
19	Demographic	idQID_decoded = Are you in a community-based private practice?		Dimension	private_practice	27	Client	Yes	Yes	No
20	Demographic	idQID_decoded = Primary Institutional Affiliation:	Medical School/Academic Center	Tag Type: Institutional Affiliation	Medical School/Academic Center	283	Client	Yes	Yes	Yes
21	Demographic	idQID_decoded = Primary Institutional Affiliation:	Other	Tag Type: Institutional Affiliation	Other	284	Client	Yes	Yes	Yes
22	Demographic	idQID_decoded = Primary Institutional Affiliation:	Non-Profit Research Institute	Tag Type: Institutional Affiliation	Non-Profit Research Institute	285	Client	Yes	Yes	Yes
23	Demographic	idQID_decoded = Primary Institutional Affiliation:	Federal Health System Entity (e.g. VA., military, etc.)	Tag Type: Institutional Affiliation	Federal Health System Entity (e.g. VA., military, etc.)	286	Client	Yes	Yes	Yes
24	Demographic	idQID_decoded = Primary Institutional Affiliation:	Corporate Research Institute	Tag Type: Institutional Affiliation	Corporate Research Institute	287	Client	Yes	Yes	Yes
25	Demographic	idQID_decoded = Primary Institutional Affiliation:	Private Practice	Tag Type: Institutional Affiliation	Private Practice	288	Client	Yes	Yes	Yes
26	Demographic	idQID_decoded = Primary Institutional Affiliation:	Hospital or Clinical Facility	Tag Type: Institutional Affiliation	Hospital or Clinical Facility	289	Client	Yes	Yes	Yes
27	Demographic	idQID_decoded = Primary Institutional Affiliation:	Corporate (Biotech or Pharmaceutical)	Tag Type: Institutional Affiliation	Corporate (Biotech or Pharmaceutical)	290	Client	Yes	Yes	Yes
28	Demographic	idQID_decoded = Primary Institutional Affiliation:	Free Standing Health Care Facility	Tag Type: Institutional Affiliation	Free Standing Health Care Facility	291	Client	Yes	Yes	Yes
29	Demographic	idQID_decoded = Specify hospital based setting:	Predominantly researcher with time on service	Tag Type: Hospital Setting	Predominantly researcher with time on service	292	Client	Yes	Yes	Yes
30	Demographic	idQID_decoded = Specify hospital based setting:	Clinician scholar	Tag Type: Hospital Setting	Clinician scholar	293	Client	Yes	Yes	Yes
31	Demographic	idQID_decoded = Specify hospital based setting:	Clinical laboratory physician	Tag Type: Hospital Setting	Clinical laboratory physician	294	Client	Yes	Yes	Yes
32	Demographic	idQID_decoded = Non-Malignant Hematology:	0%	Tag Type: Non-Malignant Hematology	Non-Malignant Hematology - 0%	295	Client	Yes	Yes	Yes
33	Demographic	idQID_decoded = Non-Malignant Hematology:	25%	Tag Type: Non-Malignant Hematology	Non-Malignant Hematology - 25%	296	Client	Yes	Yes	Yes
34	Demographic	idQID_decoded = Non-Malignant Hematology:	50%	Tag Type: Non-Malignant Hematology	Non-Malignant Hematology - 50%	297	Client	Yes	Yes	Yes
35	Demographic	idQID_decoded = Non-Malignant Hematology:	75%	Tag Type: Non-Malignant Hematology	Non-Malignant Hematology - 75%	298	Client	Yes	Yes	Yes
36	Demographic	idQID_decoded = Non-Malignant Hematology:	100%	Tag Type: Non-Malignant Hematology	Non-Malignant Hematology - 100%	299	Client	Yes	Yes	Yes
37	Demographic	idQID_decoded = Malignant Hematology:	0%	Tag Type: Malignant Hematology	Malignant Hematology - 0%	300	Client	Yes	Yes	Yes
38	Demographic	idQID_decoded = Malignant Hematology:	25%	Tag Type: Malignant Hematology	Malignant Hematology - 25%	301	Client	Yes	Yes	Yes
39	Demographic	idQID_decoded = Malignant Hematology:	50%	Tag Type: Malignant Hematology	Malignant Hematology - 50%	302	Client	Yes	Yes	Yes
40	Demographic	idQID_decoded = Malignant Hematology:	75%	Tag Type: Malignant Hematology	Malignant Hematology - 75%	303	Client	Yes	Yes	Yes
41	Demographic	idQID_decoded = Malignant Hematology:	100%	Tag Type: Malignant Hematology	Malignant Hematology - 100%	304	Client	Yes	Yes	Yes
42	Demographic	idQID_decoded = Solid Malignancies:	0%	Tag Type: Solid Malignancies	Solid Malignancies - 0%	305	Client	Yes	Yes	Yes
43	Demographic	idQID_decoded = Solid Malignancies:	25%	Tag Type: Solid Malignancies	Solid Malignancies - 25%	306	Client	Yes	Yes	Yes
44	Demographic	idQID_decoded = Solid Malignancies:	50%	Tag Type: Solid Malignancies	Solid Malignancies - 50%	307	Client	Yes	Yes	Yes
45	Demographic	idQID_decoded = Solid Malignancies:	75%	Tag Type: Solid Malignancies	Solid Malignancies - 75%	308	Client	Yes	Yes	Yes
46	Demographic	idQID_decoded = Solid Malignancies:	100%	Tag Type: Solid Malignancies	Solid Malignancies - 100%	309	Client	Yes	Yes	Yes
47	Demographic	idQID_decoded = Other:	0%	Tag Type: Other:	Other - 0%	310	Client	Yes	Yes	Yes
48	Demographic	idQID_decoded = Other:	25%	Tag Type: Other:	Other - 25%	311	Client	Yes	Yes	Yes
49	Demographic	idQID_decoded = Other:	50%	Tag Type: Other:	Other - 50%	312	Client	Yes	Yes	Yes
50	Demographic	idQID_decoded = Other:	75%	Tag Type: Other:	Other - 75%	313	Client	Yes	Yes	Yes
51	Demographic	idQID_decoded = Other:	100%	Tag Type: Other:	Other - 100%	314	Client	Yes	Yes	Yes
52	Demographic	idQID_decoded = Primary Subspecialty Area:	Internal Medicine - Hematology	Tag Type: Primary Subspecialty Area:	Internal Medicine - Hematology	315	Client	Yes	Yes	Yes
53	Demographic	idQID_decoded = Primary Subspecialty Area:	Internal Medicine - Hematology-Oncology	Tag Type: Primary Subspecialty Area:	Internal Medicine - Hematology-Oncology	316	Client	Yes	Yes	Yes
54	Demographic	idQID_decoded = Primary Subspecialty Area:	Internal Medicine - Oncology	Tag Type: Primary Subspecialty Area:	Internal Medicine - Oncology	317	Client	Yes	Yes	Yes
55	Demographic	idQID_decoded = Primary Subspecialty Area:	Internal Medicine - Transfusion Medicine	Tag Type: Primary Subspecialty Area:	Internal Medicine - Transfusion Medicine	318	Client	Yes	Yes	Yes
56	Demographic	idQID_decoded = Primary Subspecialty Area:	Internal Medicine - Other	Tag Type: Primary Subspecialty Area:	Internal Medicine - Other	319	Client	Yes	Yes	Yes
57	Demographic	idQID_decoded = Primary Subspecialty Area:	Pathology - Laboratory Medicine	Tag Type: Primary Subspecialty Area:	Pathology - Laboratory Medicine	320	Client	Yes	Yes	Yes
58	Demographic	idQID_decoded = Primary Subspecialty Area:	Pathology - Transfusion Medicine	Tag Type: Primary Subspecialty Area:	Pathology - Transfusion Medicine	321	Client	Yes	Yes	Yes
59	Demographic	idQID_decoded = Primary Subspecialty Area:	Pathology - Hematopathology	Tag Type: Primary Subspecialty Area:	Pathology - Hematopathology	322	Client	Yes	Yes	Yes
60	Demographic	idQID_decoded = Primary Subspecialty Area:	Pathology - Other	Tag Type: Primary Subspecialty Area:	Pathology - Other	323	Client	Yes	Yes	Yes
61	Demographic	idQID_decoded = Primary Subspecialty Area:	Pediatrics - Hematology	Tag Type: Primary Subspecialty Area:	Pediatrics - Hematology	324	Client	Yes	Yes	Yes
62	Demographic	idQID_decoded = Primary Subspecialty Area:	Pediatrics - Oncology	Tag Type: Primary Subspecialty Area:	Pediatrics - Oncology	325	Client	Yes	Yes	Yes
63	Demographic	idQID_decoded = Primary Subspecialty Area:	Pediatrics - Hematology-Oncology	Tag Type: Primary Subspecialty Area:	Pediatrics - Hematology-Oncology	326	Client	Yes	Yes	Yes
64	Demographic	idQID_decoded = Primary Subspecialty Area:	Pediatrics - Transfusion Medicine	Tag Type: Primary Subspecialty Area:	Pediatrics - Transfusion Medicine	327	Client	Yes	Yes	Yes
65	Demographic	idQID_decoded = Primary Subspecialty Area:	Pediatrics - Other	Tag Type: Primary Subspecialty Area:	Pediatrics - Other	328	Client	Yes	Yes	Yes
66	Demographic	idQID_decoded = Primary Subspecialty Area:	Research Scientist - Biochemistry/Molecular Biology	Tag Type: Primary Subspecialty Area:	Research Scientist - Biochemistry/Molecular Biology	329	Client	Yes	Yes	Yes
67	Demographic	idQID_decoded = Primary Subspecialty Area:	Research Scientist - Transfusion Medicine	Tag Type: Primary Subspecialty Area:	Research Scientist - Transfusion Medicine	330	Client	Yes	Yes	Yes
68	Demographic	idQID_decoded = Primary Subspecialty Area:	Research Scientist - Immunology/Microbiology	Tag Type: Primary Subspecialty Area:	Research Scientist - Immunology/Microbiology	331	Client	Yes	Yes	Yes
69	Demographic	idQID_decoded = Primary Subspecialty Area:	Research Scientist - Cell Biology	Tag Type: Primary Subspecialty Area:	Research Scientist - Cell Biology	332	Client	Yes	Yes	Yes
70	Demographic	idQID_decoded = Primary Subspecialty Area:	Research Scientist - Hematology	Tag Type: Primary Subspecialty Area:	Research Scientist - Hematology	333	Client	Yes	Yes	Yes
71	Demographic	idQID_decoded = Primary Subspecialty Area:	Research Scientist - Oncology	Tag Type: Primary Subspecialty Area:	Research Scientist - Oncology	334	Client	Yes	Yes	Yes
72	Demographic	idQID_decoded = Primary Subspecialty Area:	Research Scientist - Pharmacology	Tag Type: Primary Subspecialty Area:	Research Scientist - Pharmacology	335	Client	Yes	Yes	Yes
73	Demographic	idQID_decoded = Primary Subspecialty Area:	Research Scientist - Biophysics/Physiology	Tag Type: Primary Subspecialty Area:	Research Scientist - Biophysics/Physiology	336	Client	Yes	Yes	Yes
74	Demographic	idQID_decoded = Primary Subspecialty Area:	Research Scientist - Ultrastructure	Tag Type: Primary Subspecialty Area:	Research Scientist - Ultrastructure	337	Client	Yes	Yes	Yes
75	Demographic	idQID_decoded = Primary Subspecialty Area:	Research Scientist - Other	Tag Type: Primary Subspecialty Area:	Research Scientist - Other	339	Client	Yes	No	No
76	Person	registrationType	ATT	Tag Type: registrationType	ATT	340	Client	Yes	No	No
77	Person	registrationType	EXH	Tag Type: registrationType	EXH	341	Client	Yes	No	No
78	Person	registrationType	GRP	Tag Type: registrationType	GRP	342	Client	Yes	No	No
79	Person	registrationType	JSA	Tag Type: registrationType	JSA	343	Client	Yes	No	No
80	Person	registrationType	MED	Tag Type: registrationType	MED	344	Client	Yes	No	No
81	Person	registrationType	STF	Tag Type: registrationType	STF	345	Client	Yes	No	No
82	Person	registrationType	VEN	Tag Type: registrationType	VEN	346	Client	Yes	No	No
83	Person	subRegistrationType	5	Tag Type: subRegistrationType	Allied Health Professional	347	Client	Yes	No	No
84	Person	subRegistrationType	44	Tag Type: subRegistrationType	ASH Staff	348	Client	Yes	No	No
85	Person	subRegistrationType	3	Tag Type: subRegistrationType	Associate Member	349	Client	Yes	No	No
86	Person	subRegistrationType	21	Tag Type: subRegistrationType	Exhibitor Booth Personnel	350	Client	Yes	No	No
87	Person	subRegistrationType	22	Tag Type: subRegistrationType	Exhibitor	50	Client	Yes	No	No
88	Person	subRegistrationType	7	Tag Type: subRegistrationType	Graduate/Medical Student Member	351	Client	Yes	No	No
89	Person	subRegistrationType	6	Tag Type: subRegistrationType	Honorary/Emeritus Member	352	Client	Yes	No	No
90	Person	subRegistrationType	9	Tag Type: subRegistrationType	Honorary/Emeritus Member (as of 1/1/15)	353	Client	Yes	No	No
91	Person	subRegistrationType	10	Tag Type: subRegistrationType	International Associate Member	354	Client	Yes	No	No
92	Person	subRegistrationType	45	Tag Type: subRegistrationType	JSA Staff	355	Client	Yes	No	No
93	Person	subRegistrationType	43	Tag Type: subRegistrationType	Media	356	Client	Yes	No	No
94	Person	subRegistrationType	1	Tag Type: subRegistrationType	Member (Active or International)	357	Client	Yes	No	No
95	Person	subRegistrationType	2	Tag Type: subRegistrationType	Non-Member	358	Client	Yes	No	No
96	Person	subRegistrationType	4	Tag Type: subRegistrationType	Non-Member in Training (NMIT)	359	Client	Yes	No	No
97	Person	subRegistrationType	8	Tag Type: subRegistrationType	Resident Member	360	Client	Yes	No	No
98	Person	subRegistrationType	46	Tag Type: subRegistrationType	Vendor	361	Client	Yes	No	No
99	Person	subRegistrationType	3	Tag Type: subRegistrationType	Trainee	362	Client	Yes	No	No
100	Person	subRegistrationType	7	Tag Type: subRegistrationType	Trainee	362	Client	Yes	No	No