People Depot Data Dictionary

	A	B	C	D	E	F	G	H	I
1	logical_name	column_name	definition	data_type	default_value	example_value	sensitive_policy	required	notes

2	User Universal Unique Identifier	user_uuid	A value that provides unique identification of a person in the user table.	user_uuid		40e6215d-b5c6-4896-987c-f30f3678f608	Not Sensitive	TRUE	In a previous meeting a decision was agreed upon to use UUIDs as primary keys. Updating field name to reflect
3	First Name	first_nm	A word or phrase that designates the first name of the user.	varchar		Wednesday	PII	TRUE	changed name from first_name
4	Last Name	last_nm	A word or phrase that designates the last name of the user.	varchar		Addams	PII	TRUE	changed name from last_name
5	Gmail	gmail	A valid email address allowing the user access to organization resources.	varchar		darkside@gmail.com	PII	TRUE
6	Preferred Email	preferred_email	A valid email address a user can provide if they prefer not to use Gmail for communication.	varchar		waddams@hackforla.org	PII	TRUE
7	User Status	status_ind	A value that identifies whether or not a user is active, inactive, or on hold.	enum		active, inactive, hold	Not Sensitive	TRUE	select list of values on front-end
8	Current Practice Area	current_practice_area_nm	A word or phrase that designates a user's current practice area.	enum		UI/UX, Graphic Design	Not Sensitive
9	Current Job Title	current_job_title_nm	A word or phrase that designates a user's current job title.	varchar			Not Sensitive
10	Target Practice Area	target_practice_area_nm	A word or phrase that designates a user's target practice area.	enum			Not Sensitive
11	Target Job Title	target_job_title_nm	A word or phrase that designates a user's target job title.	varchar			Not Sensitive
12	Desired Roles	desired_roles_list	A list of values indicating the roles a user is interested in.	enum			Not Sensitive		multi-select array of values.
13	Availability Array	availability_ary	An array of values indicating a user's availability.	varchar/int			Not Sensitive		multi-select array of values
14	Current Skills List	current_skills_list	A list of values indication a user's current skills.	varchar			Not Sensitive		multi-select array of values
15	Target Skills List	target_skills_list	A list of values indicating the skills a user would like to acquire.	varchar			Not Sensitive		multi-select array of values
16	LinkedIn URL	linkedin_url	A uniform resource locatior pointing to a user's LinkedIn profile.	varchar
17	Referred by	referred_by_nm	A word or phrase that designates the name of the person who referred a new volunteer.	varchar			PII
18	GitHub Handle	github_handle	A string that indicates the shorthand name of a user's GitHub account.	varchar
19	Phone Number	phone_num	A value that provides the identification of a user's primary phone number and is used for making connections.	varchar			PII
20	Texting Okay	texting_ok_ind	A value that identifies whether or the user has given permission for text messaging to be used as a form of communication.	boolean			Not Sensitive
21	Slack Identifier	slack_id	A value that provides unique identification of a user in the Slack application.	varchar
22	Time Zone	time_zone_nm	A word or phrase that designates the name of a user's timezone as defined in the IANA timezone database.	varchar			Not Sensitive		multi-select list of values on front-end
23	Row Updated Timestamp	row_updated_ts	A combination of date and time to the microsecond that represents when a row was updated.	timestamp			Not Sensitive
24	Row Created Timestamp	row_created_ts	A combination of date and time to the microsecond that represents when a row was created.	timestamp			Not Sensitive
25	Password	password	A value that is associated with a user's account and grants them access to the application.	varchar			Restricted
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100