Jim Duffy

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
110
Home reputation
100
Current reputation
100
World reputation
80
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
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 6
Judging player potential 6
Tactical knowledge 8
Hardness of training 16
Youngsters 18
Motivating 17
People management 14
Discipline 15
Mind games 3
Determination 14
Buying players 12

11 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, Patience, Eccentricity, Versatility, Negotiating, Business, Resources, Interference.

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 18
Technical 16
Tactical 12
Mental 11
Fitness 13
Attacking 9
Defending 18
Technical 16
Tactical 12
Mental 11
Fitness 13

6 of 6 values recorded from staff_coaching.

Tactical style

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

Attacking 14
Directness 12
Tempo 17
Width 15
Depth 14
Pressing 15
Flexibility 9
Squad rotation 10

8 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, Dirtiness allowance.

Career spells

Marked current: 2 of 27 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
Celtic Player 1978-07-01 1981-07-01 Ended
Greenock Morton Player 1981-07-01 1985-07-01 Ended
Dundee Player 1985-07-01 1988-07-01 Ended
Queen's Park Assistant Manager — — Current
Airdrieonians (Ext.) Coach 1988-06-01 1988-06-30 Ended
Falkirk Player 1988-07-01 1989-07-01 Ended
Dundee Player 1989-07-01 1990-07-01 Ended
Falkirk Manager 1988-09-03 1989-11-01 Ended
Partick Thistle Player 1990-07-01 1992-07-01 Ended
Dundee Player 1992-07-01 — Current
Dundee Player / Manager 1993-08-26 1996-12-29 Ended
Hibernian Manager 1996-12-30 1998-02-02 Ended
Chelsea Manager 1998-03-01 2001-02-28 Ended
Portsmouth Assistant Manager 2001-02-28 2002-01-07 Ended
Dundee Manager 2002-07-04 2005-08-24 Ended
Heart Of Midlothian Coach 2006-01-31 2006-02-13 Ended
Heart Of Midlothian Director of Football 2006-02-13 2006-03-22 Ended
Norwich City Assistant Manager 2007-02-09 2007-10-30 Ended
Brechin City Manager 2009-01-10 2010-05-19 Ended
Clyde Manager 2011-02-06 2014-05-19 Ended
Greenock Morton Manager 2014-05-19 2018-04-29 Ended
Dumbarton Manager 2018-10-17 2021-05-24 Ended
Ayr United Coach 2021-06-03 2021-10-01 Ended
Ayr United Manager 2021-09-09 2021-10-01 Ended
Ayr United Manager 2021-10-01 2021-12-20 Ended
Clyde Manager 2022-11-07 2023-05-24 Ended
Clyde Director of Football 2023-05-24 2023-08-18 Ended

National-team spells

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

Club contract

Joined
2025-05-23
Contract start
2025-05-23
Expires
—
Weekly wage
£500

Squad numbers

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

Languages

Languages from person_language.
LanguageFirst languageProficiency
English Yes —

Relations and preferences

Liked clubs

ClubRating
Dundee 100
Celtic 100

Liked people

PersonRating
Gary Oliver 100
— 100
— 95
Graham Cyril Rix 95
Chic Charnley 85
Craig McPherson 75
— 60

Disliked people

PersonRating
Lee Mair 75

Personal information

Date of birth
1959-04-27
Nationality
Scotland
Birth city
Glasgow
Joined current club
2025-05-23

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 13
Ambition 12
Controversy 5
Loyalty 10
Pressure 11
Professionalism 13
Sportsmanship 14
Temperament 12