Derek McInnes

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
120
Potential ability
140
Home reputation
120
Current reputation
120
World reputation
80
International appearances
2
Coaching qualification
1

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.

Appearance

Ethnicity code
0
Hair colour code
11
Hair length code
6
Skin tone code
1

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

Judging player ability 10
Judging player potential 15
Tactical knowledge 10
Hardness of training 11
Youngsters 11
Motivating 13
People management 16
Discipline 12
Mind games 5
Patience 10
Determination 16
Versatility 1
Buying players 13
Business 14
Resources 8
Interference 2

16 of 26 values recorded from staff_ability. Not recorded: Judging staff ability, Judging team data, Analysing data, Presenting data, Coaching, Coaching technique, Physiotherapy, Injury management, Eccentricity, Negotiating.

Coaching

Coaching Coaching: 6 of 6 values recorded, plotted on a 1 to 20 scale. Coaching: 6 of 6 values recorded, plotted on a 1 to 20 scale.
6 of 6 recorded
Coaching — every value plotted above, plus the ones that are not recorded.
AttributeValue
Attacking 9
Defending 11
Technical 13
Tactical 8
Mental 15
Fitness 12
Attacking 9
Defending 11
Technical 13
Tactical 8
Mental 15
Fitness 12

6 of 6 values recorded from staff_coaching.

Goalkeeping coaching

Goalkeeper shot stopping 1

1 of 3 values recorded from staff_coaching. Not recorded: Goalkeeper handling, Goalkeeper distribution.

Tactical style

The tactical preferences this person brings to a side, on the same 1 to 20 scale.

Attacking 11
Directness 12
Tempo 13
Width 14
Depth 7
Pressing 13
Flexibility 3
Squad rotation 3
Set pieces 11
Dirtiness allowance 6

10 of 17 values recorded from staff_tactical_style. Not recorded: Sitting back, Marking, Offside, Use of playmaker, Use of subs, Free roles, Flamboyancy.

Career spells

Marked current: 2 of 13 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
Greenock Morton Player 1988-08-13 1995-11-13 Ended
Rangers Player 1995-11-13 1999-12-27 Ended
Stockport County Player 1998-11-06 1999-05-06 Ended
Toulouse FC Player 1999-12-27 2000-08-10 Ended
West Bromwich Albion Player 2000-08-10 2003-06-30 Ended
Dundee United Player 2003-07-11 2006-06-30 Ended
Millwall Player 2006-07-03 2007-01-01 Ended
St Johnstone Player 2007-01-01 — Current
St Johnstone Manager 2007-11-26 2011-10-15 Ended
Bristol City Manager 2011-10-15 2013-01-12 Ended
Aberdeen Manager 2013-04-06 2021-03-08 Ended
Kilmarnock Manager 2022-01-04 2025-05-19 Ended
Heart Of Midlothian Manager 2025-05-19 — Current

National-team spells

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

Club contract

Joined
2025-05-19
Contract start
2025-05-19
Expires
2029-05-31
Weekly wage
£0

Squad numbers

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

Languages

Languages from person_language.
LanguageFirst languageProficiency
English Yes —

Relations and preferences

Liked clubs

Disliked clubs

Liked people

Disliked people

PersonRating
Thomas Boyd 60
Edward Henrik Larsson 25

Personal information

Date of birth
1971-07-05
Nationality
Scotland
Birth city
Paisley
Joined current club
2025-05-19

Personality

Personality is stored on the same 1–20 scale as the attributes, and is shown exactly as recorded. A dash is a value the export did not record, which is not a zero.

Adaptability 3
Ambition 18
Controversy 6
Loyalty 14
Pressure 8
Professionalism 18
Sportsmanship 14
Temperament 15