Data Dictionary

Legend:
* mandatory: required field (campo obrigatório)
* retrievable: appears on a registry visualization (campo presente na visualização do registro)
* searchable: indexed field (campo indexado, permite que seja buscado em caixas de pesquisa)
* canonical field name: real name of the field at the data model (nome real do campo no modelo de dados)

Institution

table name = institution

field	description	mandatory	retrievable	searchable	canonical field name
name		x	x		name
description	a brief description of the institution		x		description
phone number		x	x		phone_number
email address		x	x		email_address
web site			x		web_site
legal registry	CPF/CNPJ or other registry num		x		legal_registry
[Localization]		x	x		localization_id
institutional group	the category that the institution fits	x	x		institutional_group_id

Localization

table name = localization

field	description	mandatory	retrievable	searchable	canonical field name
POBOX		x	x		post_office_box
address		x	x		address
neighborhood		x	x		neighborhood
city		x	x		city
federal unit		x			federal_unit
country		x	x		country
latitude					latitude
longitude					longitude

Organizational Unit

table name = organizational_unit

field	description	mandatory	retrievable	searchable	canonical field name
[Institution]		x	x		institution_id
name		x	x		name
description			x		description
phone number			x		phone_number
fax number			x		fax_number
email address			x		email_address
web site			x		web_site

Institutional Group

table name = institutional_group

field	description	mandatory	retrievable	searchable	canonical field name
name		x	x		name
description			x		description

Person

table name = sf_guard_user_profile

field	description	mandatory	retrievable	searchable	canonical field name
name		x	x		name
function	secretariat, systems analyst	x	x		function
degree			x		degree
gender			x		gender
birth_date					birth_date
working area	depends on the type field		x		working_area
legal registry	CPF/CNPJ or other registry num		x		legal_registry
[Localization]		x	x		localization_id
phone number			x		phone_number
cel number					cel_number
email address		x	x		email_address
web site			x		web_site