David Andreoli

Staff

Staff record

staff is the non-playing subtype of person: people this export decoded as staff rather than as players. It is only one of the three places a career can live. Plenty of well-known managers have no staff row at all — some are stored as players, and many sit in person_unclassified, whose subtype the decoder could not determine. Whichever table a person is in, their jobs come from staff_history joined to job_type, which is the table below.

Current ability
70
Potential ability
100
Home reputation
70
Current reputation
70
World reputation
20
International appearances
0
Coaching qualification
—

Ability and the three reputations are the raw game figures, which run to roughly 200 rather than to 20 — they are printed exactly as stored and nothing is converted. coaching_qualification is a badge level with no lookup table in the export, so it is shown as the stored number and no name is invented for it.

Calculated at game start

Age at game start
42
Reputation
National 0.0 / 5 stars
Coaching style
—
Preferred mentality
—
Preferred playing style
—
Preferred pressing style
—

Football Manager's own game-start calculations from the attributes above, ported from the game's rules by the enriched overlay (method in each value's tooltip). Coaching scores use the game's FM22 training categories applied to every release and leave out the secondary-job and injury reductions; a dash is a value the rule had no input for, and board members have no reputation label.

Appearance

Ethnicity code
1
Hair colour code
0
Hair length code
4
Skin tone code
5

Raw codes from the source. The export carries no lookup table for any of them, so they are shown as stored and are not given names.

Non-playing ability

A staff_ability row exists, but none of its 26 values are recorded.

Coaching

A staff_coaching row exists, but none of its 6 values are recorded.

Tactical style

A staff_tactical_style row exists, but none of its 17 values are recorded.

Career spells

Marked current: 3 of 8 spells. A spell counts as current when date_left is empty or falls in the future — the source records plenty of long-finished spells with no end date, so more than one spell can carry the mark.

Career spells from staff_history, in the order the export wrote them.
ClubRoleFromToStatus
FC Luzern Player 2001-07-01 — Current
FC Lugano Player 2005-07-01 2006-01-01 Ended
SC Kriens Player 2007-07-01 2009-06-30 Ended
FC Sursee Player 2009-07-01 2009-12-31 Ended
SC Cham Player 2010-01-01 2010-07-01 Ended
SC Buochs Player 2010-07-01 — Current
SC Buochs Manager 2014-07-01 2017-06-30 Ended
FC Littau Manager 2019-07-01 — Current

National-team spells

No national-team spells are recorded in person_nation_contract for this person.

Club contract

Joined
2019-07-01
Contract start
2019-07-01
Expires
—
Weekly wage
£0

Squad numbers

Squad numbers from club_squad_number, keyed on team_uid.
TeamNumber
Team 98010060 —

Languages

Languages from person_language.
LanguageFirst languageProficiency
French No 10
Italian No 5
German No 5
English No 4

Relations and preferences

Other relations

Typed relations from person_other_relation.
Target typeTargetRating
nation (object type 8) Italy 100

Personal information

Date of birth
1982-09-29
Nationality
Switzerland
Birth city
Luzern
Joined current club
2019-07-01