Mark Picking

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
55
Potential ability
90
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
11
Hair length code
6
Skin tone code
4

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 12 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
Coleraine Player 1998-07-01 2001-07-01 Ended
Linfield Player 2001-07-01 2006-06-05 Ended
Ballymena United Player 2006-06-05 2010-05-31 Ended
Ards Player 2009-08-21 2010-05-30 Ended
Ards Player 2010-05-31 2012-05-31 Ended
Police Service of Northern Ireland Player 2012-07-01 2013-08-09 Ended
Larne Player 2013-08-09 2014-03-05 Ended
Shankill United Player 2014-03-05 2014-10-11 Ended
Albert Foundry Player 2014-10-11 2016-07-01 Ended
Comber Rec Assistant Manager — — Current
Shankill United Assistant Manager 2018-06-03 2019-08-31 Ended
Comber Rec Assistant Manager 2020-07-18 — Current

National-team spells

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

Club contract

Joined
2020-07-18
Contract start
2021-07-01
Expires
2022-06-30
Weekly wage
£0

Squad numbers

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

Languages

Languages from person_language.
LanguageFirst languageProficiency
English Yes —

Retirement

Retirement facts from person_retirement.
TypeDate
Total player retirement 2016-07-01

Relations and preferences

Liked clubs

ClubRating
Linfield 100

Disliked clubs

ClubRating
Glentoran 100

Liked people

PersonRating
David Rainey 100

Personal information

Date of birth
1975-12-18
Nationality
Northern Ireland
Birth city
Belfast
Joined current club
2020-07-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 12
Ambition 13
Controversy 9
Loyalty 6
Pressure 11
Professionalism 11
Sportsmanship 13
Temperament 14