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
—
Potential ability
—
Home reputation
0
Current reputation
0
World reputation
0
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.

Appearance

Ethnicity code
0
Hair colour code
3
Hair length code
5
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

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: 2 of 17 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 — — Current
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-31 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 2017-05-21 — Current

National-team spells

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

Club contract

Team
—
Joined
2017-05-21
Contract start
—
Expires
—
Weekly wage
—

Languages

Languages from person_language.
LanguageFirst languageProficiency
English Yes —

Relations and preferences

Liked clubs

Liked people

PersonRating
— 100
Brian Kerr 100

Personal information

Date of birth
1979-08-20
Nationality
Scotland
Birth city
Edinburgh
Joined current club
2017-05-21

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