Stuart Millar

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
100
Potential ability
130
Home reputation
100
Current reputation
100
World reputation
40
International appearances
0
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
0
Hair length code
4
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 12
Judging player potential 11
Youngsters 8
Discipline 10
Determination 14
Eccentricity 8
Buying players 13

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

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 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
Airdrieonians Player 1982-07-01 1984-07-01 Ended
Dundee Player 1984-07-01 1985-07-01 Ended
Montrose Player 1985-07-01 1986-07-01 Ended
Clyde Player 1986-07-01 1989-07-01 Ended
Alloa Athletic Player 1989-07-01 1990-07-01 Ended
Dumbarton Player 1990-07-01 1992-01-01 Ended
AS Evagoras Pafos Player 1992-01-01 1993-07-01 Ended
Kilsyth Rangers Player 1993-07-01 — Current
Carluke Rovers Manager 1995-07-01 1998-06-30 Ended
Cumbernauld United Manager 1998-07-01 2003-06-30 Ended
Stranraer Assistant Manager 2003-07-01 2006-06-30 Ended
Ayr United Assistant Manager 2007-03-22 2007-10-22 Ended
Ross County Chief Scout 2007-10-01 2009-05-15 Ended
Clyde Manager 2010-04-24 2011-02-02 Ended
Aberdeen Scout 2011-02-09 2011-06-08 Ended
Ross County Chief Scout 2011-06-09 2014-09-02 Ended
West Bromwich Albion Scout 2014-10-27 2015-05-31 Ended
Dumbarton Chief Scout 2015-07-31 2017-05-31 Ended
Stranraer Chief Scout 2017-05-31 2018-04-26 Ended
Stranraer Director of Football 2018-04-28 2019-03-28 Ended
Airdrieonians Director of Football 2019-03-28 2021-02-15 Ended
Bradford City Scout 2021-09-29 2022-08-01 Ended
Ross County Scout 2024-01-10 — Current

National-team spells

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

Club contract

Joined
2024-01-10
Contract start
2024-01-10
Expires
—
Weekly wage
£400

Squad numbers

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

Languages

Languages from person_language.
LanguageFirst languageProficiency
English Yes —

Relations and preferences

Liked clubs

ClubRating
Stranraer 100
Clyde 75
Airdrieonians 75

Liked people

PersonRating
— 100
Derek Watt Adams 90

Personal information

Date of birth
1965-05-16
Nationality
Scotland
Birth city
Bellshill
Joined current club
2024-01-10

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 —
Ambition 6
Controversy —
Loyalty 18
Pressure —
Professionalism 17
Sportsmanship 12
Temperament 7