Andy Smith

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

45

Potential ability

60

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

3

Hair length code

4

Skin tone code

2

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 8 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
AFC Wimbledon	Scout	2013-06-01	2014-06-30	Ended
Banstead Athletic	Goalkeeping Coach	2014-07-01	2017-05-30	Ended
Epsom & Ewell	Assistant Manager	2017-08-01	2017-11-30	Ended
South Park	Goalkeeping Coach	2018-06-01	2019-02-28	Ended
Merstham	Goalkeeping Coach	2019-06-01	2021-11-30	Ended
Dulwich Hamlet	Goalkeeping Coach	2021-09-15	—	Current
Bracknell Town	Goalkeeping Coach	2021-09-30	2022-09-15	Ended
Dulwich Hamlet	Goalkeeping Coach	2022-09-15	—	Current

National-team spells

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

Club contract

Club

Dulwich Hamlet

Team

Team 1103726

Joined

2022-09-15

Contract start

2022-10-21

Expires

2023-06-30

Weekly wage

£90

Squad numbers

Squad numbers from club_squad_number, keyed on team_uid.

Team	Number
Team 1103726	—

Languages

Languages from person_language.

Language	First language	Proficiency
English	Yes	—

Relations and preferences

No relations or preferences are recorded for this person.