ACDE_DataDictionary_DAQA_v1.0.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Level1	Level2	Level3	Level4	Level5	Level6	Description	Format	Mapping	Notes
2	_id						The database unique identifier	ObjectId	rename as "ori_dbid" and migrate to ACDE.person collection.
3	id						The original DAQA archobj unique identifier	int	rename as "ori_id" and migrate to ACDE.person collection.
4	owner						It seems that it’s the id of author submitting the data.	int	rename as "contributors" and migrate to ACDE.person collection.
5	created						The date of record created.	json document	rename as "date_crated" and migrate to ACDE.person collection.
6	created	year						digit string
7	created	month						digit string
8	created	day						digit string
9	pubts						The timestamp of record published.	json document	Fully migrate to ACDE.person collection.
10	pubts	year						digit string
11	pubts	month						digit string
12	pubts	day						digit string
13	type						The type of record.	string	rename as "_class_ori" and migrate to ACDE.person collection.
14	version						The version of record.	int	Fully migrate to ACDE.person collection.
15	note						The note of record.	string	Fully migrate to ACDE.person collection.
16	ori_url						The original website url of record.	string	Fully migrate to ACDE.person collection.
17	ori_url_data						The url of access the raw data of record.	string	Fully migrate to ACDE.person collection.
18	inserted_ts_acde						The ts of access the raw acde of recind.	datetime	[DROP]
19	is_published						Whether the original website has published of record.	string	rename as "record_status" and migrate to ACDE.person collection.
20	label						The label of person.	string	rename as "display_name"; merge into "alternative_names". Then migrate to ACDE.person collection.
21	preflabel						The preferred label of person.	string	rename as "display_name" if "preflabel" = "label"; merge into "alternative_names". Then migrate to ACDE.person collection.
22	gender						The gender of person.	string	Fully migrate to ACDE.person collection.
23	summary						The summary of person.	string	Fully migrate to ACDE.person collection.
24	firstname						The firstname of person.	string	rename as "primary_name.given_names" and migrate to ACDE.person collection.
25	lastname						The lastname of person.	string	rename as "primary_name.family_name" and migrate to ACDE.person collection.
26	associatedMedia						The associated media of record.	Array of json documents.	[DROP]
27	birth						The birth information of person.	json document	Fully migrate to ACDE.person collection.
28	birth	coverage
29	birth	coverage	date
30	birth	coverage	date	year
31	death						The death information of person.	json document	Fully migrate to ACDE.person collection.
32	death	coverage
33	death	coverage	date
34	death	coverage	date	year
35	architect							boolean	rename as "is_architect" and migrate to ACDE.person collection.
36	practicedinqueensland							boolean	rename as "is_practicedinqueensland" and migrate to ACDE.person collection.
37	influence_on_QLD_architecture							Null	Fully migrate to ACDE.person collection.
38	career							Array of json documents.	Fully migrate to ACDE.person collection.
39	career	date_start					The starting year of career. It is part of the "career.career_periods".	int
40	career	date_end					The ending year of career. It is part of the "career.career_periods".	int
41	career	is_ongoing						boolean
42	career	registrations						list of strings
43	career	career_focus						string
44	career	career_periods					The career periods of the person.	Array of json documents.
45	career	career_periods	coverage_range
46	career	career_periods	coverage_range	date_range
47	career	career_periods	coverage_range	date_range	date_start
48	career	career_periods	coverage_range	date_range	date_start	year
49	career	career_periods	coverage_range	date_range	date_end
50	career	career_periods	coverage_range	date_range	date_end	year
51	career	career_periods	occupation
52	career	career_periods	occupation	title
53	career	career_periods	occupation	type
54	education_trainings						The education and trainings the person has got	Array of json documents.	Fully migrate to ACDE.person collection.
55	education_trainings	coverage_range
56	education_trainings	coverage_range	date_range
57	education_trainings	coverage_range	date_range	date_end
58	education_trainings	coverage_range	date_range	date_end	year
59	education_trainings	coverage_range	date_range	date_start
60	education_trainings	coverage_range	place
61	education_trainings	organization
62	education_trainings	organization	name
63	education_trainings	organization	qualification
64	education_trainings	organization	type
65	interviews						Meta information of relative interviews of the individual. It’s a collection of individual record in interview	Array of json documents.	Reconstruct as the record in relationship collection, then [DROP]
66	media						Meta information of associated medias of the individual, which is usually the portrait of the individual.	Array of json documents.	Reconstruct as the record in relationship collection, then [DROP]
67	media	id
68	media	creator
69	media	created
70	media	type
71	media	label
72	media	preferred
73	media	owner
74	media	description
75	media	filename
76	media	filesize
77	media	identifier
78	media	location
79	media	mimetype
80	media	rights
81	registrations							Array of json documents.	Fully migrate to ACDE.person collection.
82	registrations	coverage
83	registrations	coverage	date
84	registrations	coverage	date	year
85	registrations	coverage	place
86	relationships						Meta information of associated relationships of the individual.	Array of json documents.	Reconstruct as the record in relationship collection, then [DROP].	As the relationship attribute has been migrated to relationship collection, the original attribute can be dropped.
87	relationships	_id
88	relationships	relationship
89	relationships	relationshipid
90	relationships	ori_url_data
91	relationships	note
92	relationships	inserted_ts_acde
93	relationships	subject
94	relationships	subject_ori_url
95	relationships	subjectlabel
96	relationships	subjecttype
97	relationships	subjectarchitect
98	relationships	subjectpracticedinqueensland
99	relationships	object
100	relationships	objectlabel