Mark Derrick Orme

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

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

9

Hair length code

6

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.

Goalkeeping coaching

1 of 3 values recorded from staff_coaching. Not recorded: Goalkeeper handling, Goalkeeper distribution.

Tactical style

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

Career spells

Marked current: 4 of 18 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.

Club	Role	From	To	Status
Cemaes Bay	Player	2003-07-01	2005-01-01	Ended
Llangefni Town	Player	2005-01-01	2005-01-02	Ended
Cemaes Bay	Player	2005-01-02	—	Current
Denbigh Town	Player	2007-07-01	2009-07-01	Ended
Buckley Town	Player	2009-07-01	2010-07-01	Ended
Conwy Borough Swifts	Player	2010-07-01	2012-11-15	Ended
Denbigh Town	Player	—	2012-11-15	Ended
Holywell Town	Player	2012-11-15	2013-01-01	Ended
Llandudno	Player	2014-07-01	2015-07-01	Ended
Llandudno Junction	Manager	2015-07-01	2016-02-19	Ended
Llandyrnog United	Player	2016-07-01	2017-08-24	Ended
Glan Conwy	Player	2017-08-24	—	Current
Holywell Town	Coach	2016-02-19	—	Current
Llandudno	Manager	2018-05-04	2019-04-29	Ended
Colwyn Bay	Assistant Manager	2019-04-29	2020-06-23	Ended
Glan Conwy	Coach	2020-07-18	2021-08-20	Ended
Colwyn Bay	Head of Youth Development	2021-08-20	2023-03-20	Ended
Caernarfon Town	Assistant Manager	2023-03-20	—	Current

National-team spells

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

Club contract

Club

Caernarfon Town

Team

Team 1301344

Joined

2023-03-20

Contract start

2023-03-20

Expires

—

Weekly wage

£0

Squad numbers

Squad numbers from club_squad_number, keyed on team_uid.

Team	Number
Team 1301344	—

Languages

Languages from person_language.

Language	First language	Proficiency
English	Yes	—

Relations and preferences

Other relations

Typed relations from person_other_relation.

Target type	Target	Rating
nation (object type 8)	Wales	100