Ryan John Esson

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
105
Potential ability
130
Home reputation
75
Current reputation
105
World reputation
40
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
2
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

Judging player ability 11
Judging player potential 12
Tactical knowledge 8
Hardness of training 13
Youngsters 15
Physiotherapy 4
Motivating 13
People management 13
Discipline 12
Mind games 8
Determination 13
Versatility 9
Buying players 6

13 of 26 values recorded from staff_ability. Not recorded: Judging staff ability, Judging team data, Analysing data, Presenting data, Coaching, Coaching technique, Injury management, Patience, Eccentricity, 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 4
Defending 8
Technical 11
Tactical 9
Mental 12
Fitness 8
Attacking 4
Defending 8
Technical 11
Tactical 9
Mental 12
Fitness 8

6 of 6 values recorded from staff_coaching.

Goalkeeping coaching

Goalkeeper shot stopping 13
Goalkeeper handling 13
Goalkeeper distribution 12

3 of 3 values recorded from staff_coaching.

Tactical style

A staff_tactical_style row exists, but none of its 17 values are recorded.

Career spells

Marked current: 4 of 7 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
Parkvale Player — — Current
Aberdeen Player 1996-10-23 2006-06-30 Ended
Rotherham United Player — — Current
Shrewsbury Town Player 2006-06-30 2008-01-30 Ended
Hereford United Player 2008-03-17 2008-06-30 Ended
Inverness Caledonian Thistle Player 2008-07-20 — Current
Inverness Caledonian Thistle Goalkeeping Coach 2018-06-01 — Current

National-team spells

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

Club contract

Joined
2018-06-01
Contract start
2018-05-31
Expires
2020-05-31
Weekly wage
£500

Squad numbers

Squad numbers from club_squad_number, keyed on team_uid.
TeamNumber
Team 1577 1

Languages

Languages from person_language.
LanguageFirst languageProficiency
English Yes —

Relations and preferences

Liked clubs

ClubRating
Aberdeen 75

Liked people

PersonRating
Jim Leighton 100

Personal information

Date of birth
1980-03-19
Nationality
Scotland
Birth city
Aberdeen
Joined current club
2018-06-01

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