Stuart Malcolm

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
65
Potential ability
90
Home reputation
65
Current reputation
65
World reputation
15
International appearances
0
Coaching qualification
2

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

Determination 13

1 of 26 values recorded from staff_ability. Not recorded: Judging player ability, Judging player potential, Judging staff ability, Judging team data, Analysing data, Presenting data, Tactical knowledge, Coaching, Coaching technique, Hardness of training, Youngsters, Physiotherapy, Injury management, Motivating, People management, Discipline, Mind games, Patience, Eccentricity, Versatility, Buying players, Negotiating, Business, Resources, Interference.

Coaching

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

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 5
Directness 20
Tempo 12
Width 7
Depth 17
Pressing 7
Flexibility 3
Squad rotation 3
Dirtiness allowance 15

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

Career spells

Marked current: 1 of 23 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
St Johnstone Player 1996-07-01 2002-06-30 Ended
Cowdenbeath Player 1999-01-01 1999-07-01 Ended
Plymouth Argyle Player 2002-07-01 2003-06-30 Ended
Ross County Player 2003-07-01 2005-03-20 Ended
Drogheda United Player 2005-03-24 2005-12-11 Ended
Dublin City F.C. Player 2005-12-12 2006-07-17 Ended
Alloa Athletic Player 2006-08-01 2007-01-31 Ended
Montrose Player 2007-03-01 2007-05-31 Ended
Shelbourne F.C. Player 2007-07-01 2007-12-31 Ended
Finn Harps Player 2008-01-15 2009-07-07 Ended
Forfar Athletic Player 2009-07-07 2009-09-29 Ended
Arbroath Player 2010-07-21 2013-05-31 Ended
Forfar Athletic Player 2013-07-01 2015-05-31 Ended
Stenhousemuir Player 2015-06-01 2016-05-31 Ended
Forfar Athletic Player 2016-07-01 2017-05-21 Ended
Albion Rovers Assistant Manager 2017-05-22 2018-05-07 Ended
East Kilbride Assistant Manager 2018-06-01 2018-09-30 Ended
East Kilbride Manager 2018-10-01 2019-11-10 Ended
Forfar Athletic Manager 2019-11-10 2021-04-09 Ended
Berwick Rangers Manager 2021-05-31 2023-10-24 Ended
Arbroath Coach 2023-10-24 2023-12-06 Ended
Arbroath Manager 2023-11-25 2023-12-04 Ended
East Fife Coach 2024-02-18 — Current

National-team spells

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

Club contract

Joined
2024-02-18
Contract start
2024-02-18
Expires
2026-05-31
Weekly wage
£150

Squad numbers

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

Languages

Languages from person_language.
LanguageFirst languageProficiency
English Yes —

Relations and preferences

Liked clubs

ClubRating
Plymouth Argyle 100
St Johnstone 90
Ross County 50
Falkirk 100

Liked people

Disliked people

PersonRating
Alan Andrew Martin 100

Personal information

Date of birth
1979-08-20
Nationality
Scotland
Birth city
Edinburgh
Joined current club
2024-02-18

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 8
Ambition 9
Controversy 10
Loyalty 15
Pressure 12
Professionalism 9
Sportsmanship 14
Temperament 12