Afonso Abel de Campos

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

50

Potential ability

70

Home reputation

100

Current reputation

20

World reputation

5

International appearances

25

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

3

Hair colour code

7

Hair length code

0

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: 8 of 9 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
Atlético Petróleos de Luanda	Player	—	—	Current
Sport Lisboa e Benfica - SAD	Player	—	—	Current
Clube de Futebol Estrela da Amadora	Player	—	—	Current
Sporting Clube de Braga	Player	—	—	Current
Sport Benfica e Castelo Branco	Player	—	—	Current
Gelora Dewata	Player	—	—	Current
Futebol Clube de Alverca	Player	—	—	Current
PSIS Semarang	Player	—	—	Current
Sport Luanda e Benfica	Manager	2002-01-01	2002-12-31	Ended

National-team spells

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

Club contract

No club contract is recorded in person_club_contract for this person.

Languages

No languages are recorded in person_language for this person.

Retirement

Retirement facts from person_retirement.

Type	Date
Total player retirement	1997-12-31

Relations and preferences

Liked clubs

Club	Rating
Sport Lisboa e Benfica - SAD	100
Atlético Petróleos de Luanda	100

Liked people

Person	Rating
—	100
Djalma Braume Manuel Abel Campos	100

Other relations

Typed relations from person_other_relation.

Target type	Target	Rating
nation	Portugal	100