Appendix B: SIGUANET corporate data tables

This is a list of SIGUANET tables in the public schema which hold basic information about your organization. Many of them are look up tables storing staff, organizational unit and position lists. Assuming these corporate data already exist in an ORACLE database, you may automate and schedule data transfer using the DbSync module.
Documentation on table fields most probably suitable for synchronization is also included. Primary keys are prefixed with '#'.

personal

Staff personal data

field name	description	references
#nif	personal identifier
apellido1	first surname
apellido2	second surname
nombre	given name

centro

Teaching or research units having higher academic rank (faculties, colleges, institutes)

field name	description	references
#cod_centro	unit identifier
txt_centro	unit name

departamento

Teaching or research base units (teaching departments)

field name	description	references
#cod_dpto	unit identifier
txt_dpto	unit name
cod_centro	parent unit identifier	centros.cod_centro

unidades

Administrative base units

field name	description	references
#cod_unidad	unit identifier
txt_unidad	unit name

subunidades

Administrative subunits

field name	description	references
#cod_sub	subunit identifier
txt_sub	subunit name

puestos

Job positions

field name	description	references
#cod_puesto	position identifier
txt_puesto	position name

becarios

Stores locations and data about research grant holders

field name	description	references
#nif	personal identifier
apellido1	first surname
apellido2	second surname
nombre	given name
cod_depto_centro_subunidad	organizational unit this grant holder works for (fuzzy)
cod_puesto	job position identifier	puestos.cod_puesto

personalpas

Stores locations and data about administrative and service staff

field name	description	references
#nif	personal identifier	personal.nif
#cod_puesto	job position identifier	puestos.cod_puesto
#cod_unidad	administrative base unit this employee works for	departamentossigua.cod_dpto_sigua
#cod_sub	administrative subunit this employee works for	subunidades.cod_sub
#cod_centro	unit of higher academic rank this employee integrates into	centros.cod_centro

personalpdi

Stores locations and data about teaching and research staff

field name	description	references
#nif	personal identifier	personal.nif
#cod_puesto	job position identifier	puestos.cod_puesto
#cod_centro	unit of higher academic rank this employee integrates into	centros.cod_centro
#cod_depto	teaching or research base unit this employee works for	departamentos.cod_dpto

cargos

Governance positions

field name	description	references
#cod_cargo	position identifier
txt_cargo	position name

personalpdi_cargos

Stores appointments of teaching and research employees for governance positions including their location

field name	description	references
#nif	personal identifier	personal.nif
#cod_cargo	position name	cargos.cod_cargo