TriPageDataModel

Description of the data model used in the EmployeePortalApp as it is customized for Trivadis AG

Overview

The portal for an employee consists of a series of tabs that each displays a restricted view on the data of a user. This data is separated from the normal free-form way a user arranges his home topic. The following sections describe the different tabs, the data they hold and the source of that data. Part of that information is stored in TWikiForms directly while additional data is aggregated dynamically by extracting the relevant information from other TWikiApplications or from an LDAP directory.

Those fields that are not stored in LDAP or aggregated by a query/search are stored in a TriPage record and marked with **. Basically these are the TWiki+manual combinations.

Each tab presents a specific view on a range of data. Part of that data is stored in TWiki itself, part of it is imported from other TWikiApplications and part of it is added by querying an LDAP database. The following documents the source of the required data and how it is acquired. Here, 'automatic' means, that the data is collected by any means of querying either an LDAP database or data generated by another application. All LDAP data sources are in a way 'acquired automatically' as they are inserted into the database from outside of TWiki.

Tobbar

Part of the information contained in the individual tabs is summarized in the top bar next to the photo.

Field	German	Description	Data source	Acquisition	Searchable
FirstName	Vorname	givenName	LDAP	automatic
LastName	Nachname	sn	LDAP	automatic
Login	Login	uid, wiki login name	LDAP	automatic
EMail	EMail	mails	LDAP	automatic
Role	Funktion	employeeType, function of MA in company	LDAP	automatic
Entry	Eintritt	time MA joined the company	LDAP	automatic
Telephone	Telefon	telephoneNumber	LDAP	automatic
Mobile	Mobile	mobile	LDAP	automatic
Telephone (private)	Telefon (privat)	homePhone	LDAP	automatic
Department	Abteilung	ou	LDAP	automatic
Location	Niederlassung	l	LDAP	automatic

Business details

Field	German	Description	Data source	Acquisition	Searchable
PreviousCompanies	Früherer Arbeitgeber	previous employers	TWiki **	manual
BranchOfTrade	Branche	branches the user has been working in	TWiki **	manual
EducationEN	Ausbildung	way of education (apprenticeship, studies, certificates)	TWiki **	manual (probably from CV-Tab later)
CertificatesOfCompetence	Zertifizierung	...	TWiki **	manual
Groups	Mailgruppen	Trivadis mail groups	LDAP	automatic
LanguageSkillsEN	Sprachkenntnisse		TWiki **	manual
Presentations	Vorträge		TWiki speech tracking app.	automatic
Publications	Artikel		TWiki article tracking app.	automatic
Projects	Projekte	aktive/inaktive Projekte (extern/intern)	TWiki project app.	automatic

Internal responsibility

Field	German	Description	Data source	Acquisition	Searchable
Instructor	Kurs-Referent	courses which the MA is holding	TWiki course app.	automatic
ServiceResponsibility	Intene Verantwortung		TWiki **	manual
InternalSystems	Interne Systeme	internal systems and applications the MA is responsible for	TWiki **	manual

Contact details

Field	German	Description	Data source	Acquisition	Searchable
FirstName	Vorname	givenName	LDAP	automatic
LastName	Nachname	sn	LDAP	automatic
Telephone	Telefon	telephoneNumber	LDAP	automatic
Mobile	Handy	mobile	LDAP	automatic
Telephone (private)	Telefon (privat)	homePhone	LDAP	automatic
Department	Abteilung	ou	LDAP	automatic
Location	Niederlassung	l	LDAP	automatic
InstantMessaging	InstantMessaging		TWiki **	manual
Photo	Foto		TWiki **	manual

CV

See also

• DocFamilyScreenshots? .
• cv-definition.xsd
• cv-example.xml

Field	German	Description	Data source	Acquisition	Searchable
Name	Name	PersAngaben	TWiki **	manual
Photo	Bild	PersAngaben	TWiki **	manual
YearOfBirth	Jahrgang	PersAngaben	TWiki **	manual
EducationDE	Ausbildung	PersAngaben	TWiki **	manual
NationalityDE	Nationalität	PersAngaben: AT, CH, DE, FR	TWiki **	manual
RoleDE	Funktion	PersAngaben	TWiki **	manual
LanguageSkillsDE	Sprachen	PersAngaben	TWiki **	manual
OtherLanguageSkillsDE	SonstigeSprachen	PersAngaben	TWiki **	manual
DescriptionDE?	KurzbeschreibungDE		TWiki **	manual
JobHistoryDE	BerufDE	topic that contains the table data	TWiki **	manual
MainFocusDE	SchwerpunkteDE		TWiki **	manual
ProgrammingLanguagesDE	ProgrammiersprachenDE		TWiki **	manual
OperatingSystemsDE	BetriebsystemeDE		TWiki **	manual
DatabasesDE	DatenbankenDE		TWiki **	manual
MethodsDE	MethodenDE		TWiki **	manual
TechnologiesDE	TechnologienDE		TWiki **	manual
CommunicationDE	KommunikationDE		TWiki **	manual
MiddlewareDE	MiddlewareDE		TWiki **	manual
FrameworksDE	FrameworksDE		TWiki **	manual
ProjectsDE	ProjekteDE	topic that contains the table dat a	TWiki **	manual
EducationEN	Ausbildung	PersAngaben	TWiki **	manual
NationalityEN	Nationalität	PersAngaben: AT, CH, DE, FR	TWiki **	manual
RoleEN	Funktion	PersAngaben	TWiki **	manual
LanguageSkillsEN	Sprachen	PersAngaben	TWiki **	manual
OtherLanguageSkillsEN	SonstigeSprachen	PersAngaben	TWiki **	manual
DescriptionEN	KurzbeschreibungEN		TWiki **	manual
JobHistoryEN	BerufEN	topic that contains the table data	TWiki **	manual
MainFocusEN	SchwerpunkteEN		TWiki **	manual
ProgrammingLanguagesEN	ProgrammiersprachenEN		TWiki **	manual
OperatingSystemsEN	BetriebsystemeEN		TWiki **	manual
DatabasesEN	DatenbankenEN		TWiki **	manual
MethodsEN	MethodenEN		TWiki **	manual
TechnologiesEN	TechnologienEN		TWiki **	manual
CommunicationEN	KommunikationEN		TWiki **	manual
MiddlewareEN	MiddlewareEN		TWiki **	manual
FrameworksEN	FrameworksEN		TWiki **	manual
ProjectsEN	ProjekteEN	topic that contains the table data	TWiki **	manual

Skills

Field	German	Description	Data source	Acquisition	Searchable
ArchitectureBasics	Grundkonzepte		TWiki **	manual
ArchitectureSpringJava	Spring (Java)		TWiki **	manual
ArchitectureMicrosoftDotNet	Microsoft.Net		TWiki **	manual
ArchitectureOracleADF	Oracle ADF		TWiki **	manual
ArchitectureOracleForms	Oracle Forms		TWiki **	manual
ArchitectureSOA	SOA		TWiki **	manual
ArchitectureOMS	OMS (Output Management)		TWiki **	manual
SolutionsAD	AD		TWiki **	manual
SolutionsBI	BI		TWiki **	manual
SolutionsBC	BC		TWiki **	manual
SolutionsSEC	SEC		TWiki **	manual
SolutionsAPM	APM		TWiki **	manual
SolutionsIMSAMS	IMS/AMS		TWiki **	manual
DatabasesOracleDBA	Oracle DBA		TWiki **	manual
DatabasesOracleRAC	Oracle RAC		TWiki **	manual
DatabasesOracleTuning	Oracle Tuning		TWiki **	manual
DatabasesOracleBackupRecovery	Oracle Backup/Recovery		TWiki **	manual
DatabasesOracleMigration	Oracle Migration		TWiki **	manual
DatabasesSQLServerDBA	SQL Server DBA		TWiki **	manual
DatabasesSQLServerHighAvailability	SQL Server High Availability		TWiki **	manual
DatabasesSQLServerTuning	SQL Server Tuning		TWiki **	manual
DatabasesSQLServerBackupRecovery	SQL Sever Backup/Recovery		TWiki **	manual
DatabasesSQLServerMigration	SQL Sever Migration		TWiki **	manual
DatabasesMySQLDBA	MySQL DBA		TWiki **	manual
DatabasesMySQLHighAvailability	MySQL High Availability		TWiki **	manual
DatabasesMySQLBackupRecovery	MySQL Backup/Recovery		TWiki **	manual
DatabasesMySQLMigration	MySQL Migration		TWiki **	manual
DatabasesDB2390OS	DB2 390/ZOS		TWiki **	manual
DatabasesDB2	DB2 Linux/Unix		TWiki **	manual
DatabasesIMS	IMS		TWiki **	manual
DatabasesInformix	Informix		TWiki **	manual
DatabasesTeraData	TeraData		TWiki **	manual
OperatingSystemsMicrsoftClient	Microsoft Client		TWiki **	manual
OperatingSystemsMicrosoftServer	Microsoft Server		TWiki **	manual
OperatingSystemsHPUX	HP-UX		TWiki **	manual
OperatingSystemsSUNOS	SUN-OS		TWiki **	manual
OperatingSystemsAIX	AIX		TWiki **	manual
OperatingSystemsTrue64	True64		TWiki **	manual
OperatingSystemsLinuxRedHat	Linux RedHat		TWiki **	manual
OperatingSystemsLinuxSUSE	Linux SUSE		TWiki **	manual
OperatingSystemsMVS	MVS		TWiki **	manual
OperatingSystemsVMS	VMS		TWiki **	manual
OperatingSystemsVMWare	VMWare		TWiki **	manual
OperatingSystemsZen	ZEN		TWiki **	manual
DevelopmentToolsBEAWebLogic	BEA WebLogic		TWiki **	manual
DevelopmentToolsSunForte	SunForte		TWiki **	manual
DevelopmentToolsIBMWSAD	IBM WSAD		TWiki **	manual
DevelopmentToolsJbuilder	Jbuilder		TWiki **	manual
DevelopmentToolsItelliJ	ItelliJ		TWiki **	manual
DevelopmentToolsOraclePortel	Oracle Portel		TWiki **	manual
DevelopmentToolsEclipse	Eclipse		TWiki **	manual
DevelopmentToolsOracleJDeveloper	Oracle JDeveloper		TWiki **	manual
DevelopmentToolsMicrosoftVSTS	Microsoft VSTS		TWiki **	manual
ProgrammingLanguagesCobol	Cobol		TWiki **	manual
ProgrammingLanguagesHTML	HTML		TWiki **	manual
ProgrammingLanguagesDHTML	DHTML		TWiki **	manual
ProgrammingLanguagesJava	Java		TWiki **	manual
ProgrammingLanguagesJavaScript	Java Script		TWiki **	manual
ProgrammingLanguagesCCPlusPlus	C / C++		TWiki **	manual
ProgrammingLanguagesXMLXSLTCSS	XML/XSLT/CSS		TWiki **	manual
ProgrammingLanguagesXSLTFO	XSLT-FO		TWiki **	manual
ProgrammingLanguagesSQL	SQL		TWiki **	manual
ProgrammingLanguagesPLSQL	PL/SQL		TWiki **	manual
ProgrammingLanguagesPerl	Perl		TWiki **	manual
ProgrammingLanguagesPHP	PHP		TWiki **	manual
ProgrammingLanguagesShellScript	Shell Script		TWiki **	manual
ProgrammingLanguagesTSQLMicrosoft	T-SQL Microsoft		TWiki **	manual
ProgrammingLanguagesTSQLSybase	T-SQL Sybase		TWiki **	manual
CompetenceInstallationOperatingMonitoring	Installation/Operation/Monitoring		TWiki **	manual
CompetencePerformanceTuningOptimizing	Performance/Tuning/Optimizing		TWiki **	manual
CompetenceConsultingSupport	Consulting/Support		TWiki **	manual
CompetenceReviewAssessment	Review/Assessement		TWiki **	manual
CompetenceDevelopment	Development		TWiki **	manual
CompetenceTraining	Training		TWiki **	manual
SystemEngineeringBusinessProcessEngineering	Business Process Engineering		TWiki **	manual
SystemEngineeringVorgehensmodelle	Vorgehensmodelle	(Hermes, V-Modell, RUP, Crescendo, Agil, Classic)	TWiki **	manual
SystemEngineeringRequirementsEngineering	Requirements Engineering	(UseCase? , UCM, ...)	TWiki **	manual
SystemEngineeringAnalysisDesign	Analysis & Design	(ERM, SA, OO, UML, ..)	TWiki **	manual
SystemEngineeringITProzesse	IT Prozesse	(ITIL, CMMI, COBIT, ...)	TWiki **	manual
SystemEngineeringQualityAssuranceTesting	Quality Assurance & Testing		TWiki **	manual
SystemEngineeringProjectManagement	Projectmanagement		TWiki **	manual
OtherSkills	Andere		TWiki **	manual

Notes

This tab has no structured information and allows the MA to capture things like link collections, action tracking, a description of personal hobbies and interests.