Person
- Engine: SQL (Django model / relational table)
- App: reference
- Table/Collection:
reference_person - Verbose name: Person
Person(created, last_edit_time, last_edit_by, is_dirty, id, first_name, first_name_local, last_name, last_name_local, gender, date_of_birth, date_of_death, former_name, home_address, postcode, social_security, medical_exam_date, medical_exam_expiry_date, nickname, instagram_user, twitter_user, alt_address, alt_postcode, email, alt_email, phone, mobile, height, weight, size, shoe_size, photo, profile_crop_width, profile_crop_height, profile_crop_x, profile_crop_y, recent_photo, recent_photo_crop_width, recent_photo_crop_height, recent_photo_crop_x, recent_photo_crop_y, parent_or_guardian_name, parent_or_guardian_phone, parent_or_guardian_email, coach_name, coach_email, eql, next_of_kin_name, next_of_kin_relationship, next_of_kin_phone, next_of_kin_email, nationality, nationality2, residence, residence2, national_id, world_id, world_slug, region_of_birth, region_of_residence, department1, department2, club_text, age_group_text, summary_text, coach_text, is_inactive, hide_profile, key_fn_ln_dob, key_nn_ln_dob, key_nn_ln_email, key_nn_ln_mobile, key_national_id, user, managed_by_user, ipc_classification_track, ipc_classification_field, dedup, external_crm_id, cached_last)
| Field | Type | Column/Key | Null/Default | PK | Choices | Notes |
|---|---|---|---|---|---|---|
| created | DateTimeField | created | null | — | — | |
| last_edit_time | DateTimeField | last_edit_time | null | — | — | |
| last_edit_by | CharField | last_edit_by | null | — | — | |
| is_dirty | BooleanField | is_dirty | dflt=True | — | — | |
| id | CharField | id | — | PK | — | Unique random ID |
| first_name | CharField | first_name | — | — | — | |
| first_name_local | CharField | first_name_local | — | — | — | |
| last_name | CharField | last_name | — | — | — | |
| last_name_local | CharField | last_name_local | — | — | — | |
| gender | CharField | gender | — | M: M; F: F; X: X | — | |
| date_of_birth | DateField | date_of_birth | — | — | dd-MM-yyyy | |
| date_of_death | DateField | date_of_death | null | — | dd-MM-yyyy | |
| former_name | CharField | former_name | — | — | Use for maiden names, deed poll etc | |
| home_address | CharField | home_address | — | — | Street, house, apartment, city/town, county | |
| postcode | CharField | postcode | — | — | — | |
| social_security | CharField | social_security | — | — | 11 digits | |
| medical_exam_date | DateField | medical_exam_date | null | — | When was the most recent medical examination? | |
| medical_exam_expiry_date | DateField | medical_exam_expiry_date | null | — | When does the most recent medical examination validity expir… | |
| nickname | CharField | nickname | — | — | Concurrently used nickname (e.g. Rob for Robert) | |
| instagram_user | CharField | instagram_user | — | — | Instagram username, without the @ symbol | |
| twitter_user | CharField | twitter_user | — | — | Twitter/X username, without the @ symbol | |
| alt_address | CharField | alt_address | — | — | Alternate address | |
| alt_postcode | CharField | alt_postcode | — | — | — | |
| CharField | — | — | — | |||
| alt_email | CharField | alt_email | — | — | — | |
| phone | CharField | phone | — | — | Home phone number | |
| mobile | CharField | mobile | — | — | Mobile phone number | |
| height | PositiveSmallIntegerField | height | null | — | cm | |
| weight | FloatField | weight | null | — | kg | |
| size | CharField | size | — | XS: XS; S: S; M: M; L: L; XL: XL; XXL: XXL; XXXL: XXXL | shirt size | |
| shoe_size | IntegerField | shoe_size | null | — | Euro size (26 to 47) | |
| photo | FileField | photo | null | — | 200x200 JPEG/JPG or SVG or PNG | |
| profile_crop_width | FloatField | profile_crop_width | null | — | width cropping value | |
| profile_crop_height | FloatField | profile_crop_height | null | — | height cropping value | |
| profile_crop_x | FloatField | profile_crop_x | null | — | x cropping value | |
| profile_crop_y | FloatField | profile_crop_y | null | — | y cropping value | |
| recent_photo | FileField | recent_photo | null | — | 200x200 JPEG/JPG or SVG or PNG | |
| recent_photo_crop_width | FloatField | recent_photo_crop_width | null | — | width cropping value | |
| recent_photo_crop_height | FloatField | recent_photo_crop_height | null | — | height cropping value | |
| recent_photo_crop_x | FloatField | recent_photo_crop_x | null | — | x cropping value | |
| recent_photo_crop_y | FloatField | recent_photo_crop_y | null | — | y cropping value | |
| parent_or_guardian_name | CharField | parent_or_guardian_name | — | — | — | |
| parent_or_guardian_phone | CharField | parent_or_guardian_phone | — | — | — | |
| parent_or_guardian_email | CharField | parent_or_guardian_email | — | — | — | |
| coach_name | CharField | coach_name | — | — | — | |
| coach_email | CharField | coach_email | — | — | — | |
| eql | IntegerField | eql | null | 1: Level 1; 2: Level 2; 3: Level 3; 4: Level 4; 5: Level 5; 6: Level 6; 7: Level 7; 8: Level 8 | European Qualification Level | |
| next_of_kin_name | CharField | next_of_kin_name | — | — | — | |
| next_of_kin_relationship | CharField | next_of_kin_relationship | — | — | — | |
| next_of_kin_phone | CharField | next_of_kin_phone | — | — | — | |
| next_of_kin_email | CharField | next_of_kin_email | — | — | — | |
| nationality | ForeignKey → Country (FK) | nationality_id | null | — | Country he/she would compete for | |
| nationality2 | ForeignKey → Country (FK) | nationality2_id | null | — | Use for dual nationality | |
| residence | ForeignKey → Country (FK) | residence_id | null | — | Country of residence | |
| residence2 | ForeignKey → Country (FK) | residence2_id | null | — | Use for dual residence | |
| national_id | CharField | national_id | null | — | ID in national system; general spare field when importing da… | |
| world_id | IntegerField | world_id | null | — | ID in World Athletics database | |
| world_slug | CharField | world_slug | — | — | URL slug on World Athletics website | |
| region_of_birth | ForeignKey → Region (FK) | region_of_birth_id | null | — | Local region of birth | |
| region_of_residence | ForeignKey → Region (FK) | region_of_residence_id | null | — | Local region of residence | |
| department1 | CharField | department1 | null | : ------; RCFVS: RCFVS; MST: MST; SKFPB: SKFPB; DINAMO: DINAMO; SK VS RB: SK VS RB | Department athlete belongs to, important for getting paid. | |
| department2 | CharField | department2 | null | : ------; RCFVS: RCFVS; MST: MST; SKFPB: SKFPB; DINAMO: DINAMO; SK VS RB: SK VS RB | Second deparment athlete belongs to. | |
| club_text | CharField | club_text | — | — | Cached club code(s), for efficient querying, auto-calculated | |
| age_group_text | CharField | age_group_text | — | — | Cached current age group, for efficient querying, auto-calcu… | |
| summary_text | CharField | summary_text | — | — | Cached identity string, for efficient querying, auto-calcula… | |
| coach_text | CharField | coach_text | — | — | Cached coach names, for efficient querying, auto-calculated | |
| is_inactive | BooleanField | is_inactive | dflt=False | — | if set, this person will be hidden from view | |
| hide_profile | BooleanField | hide_profile | dflt=False | — | Hide this person's profile page from the public and from sea… | |
| key_fn_ln_dob | CharField | key_fn_ln_dob | — | — | — | |
| key_nn_ln_dob | CharField | key_nn_ln_dob | — | — | — | |
| key_nn_ln_email | CharField | key_nn_ln_email | — | — | — | |
| key_nn_ln_mobile | CharField | key_nn_ln_mobile | — | — | — | |
| key_national_id | CharField | key_national_id | — | — | — | |
| user | OneToOneField → User | user_id | null | — | User account which really is the person | |
| managed_by_user | ForeignKey → User (FK) | managed_by_user_id | null | — | User account which manages this person (e.g parent, spouse) | |
| ipc_classification_track | CharField | ipc_classification_track | — | T11: T11 - Vision impairment; T12: T12 - Vision impairment; T13: T13 - Vision impairment; T20: T20 - Intellectual impairment; T32: T32 - Co-ordination impairments (hypertonia, ataxia and athetosis); T33: T33 - Co-ordination impairments (hypertonia, ataxia and athetosis); T34: T34 - Co-ordination impairments (hypertonia, ataxia and athetosis); T35: T35 - Co-ordination impairments (hypertonia, ataxia and athetosis); T36: T36 - Co-ordination impairments (hypertonia, ataxia and athetosis); T37: T37 - Co-ordination impairments (hypertonia, ataxia and athetosis); T38: T38 - Co-ordination impairments (hypertonia, ataxia and athetosis); T40: T40 - Short stature; T41: T41 - Short stature; T42: T42 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T43: T43 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T44: T44 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T45: T45 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; T46: T46 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; T47: T47 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; T51: T51 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T52: T52 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T53: T53 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T54: T54 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T61: T61 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T62: T62 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T63: T63 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T64: T64 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T71: T71 - athletes with severe co-ordination impairment (hypertonia, ataxia, athetosis); T72: T72 - athletes with severe co-ordination impairment (hypertonia, ataxia, athetosis) | International Paralympic Committee classification code for P… | |
| ipc_classification_field | CharField | ipc_classification_field | — | F11: F11 - Vision impairment; F12: F12 - Vision impairment; F13: F13 - Vision impairment; F20: F20 - Intellectual impairment; F31: F31 - Co-ordination impairments (hypertonia, ataxia and athetosis); F32: F32 - Co-ordination impairments (hypertonia, ataxia and athetosis); F33: F33 - Co-ordination impairments (hypertonia, ataxia and athetosis); F34: F34 - Co-ordination impairments (hypertonia, ataxia and athetosis); F35: F35 - Co-ordination impairments (hypertonia, ataxia and athetosis); F36: F36 - Co-ordination impairments (hypertonia, ataxia and athetosis); F37: F37 - Co-ordination impairments (hypertonia, ataxia and athetosis); F38: F38 - Co-ordination impairments (hypertonia, ataxia and athetosis); F40: F40 - Short stature; F41: F41 - Short stature; F42: F42 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F43: F43 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F44: F44 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F45: F45 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; F46: F46 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; F51: F51 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F52: F52 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F53: F53 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F54: F54 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F55: F55 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F56: F56 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F57: F57 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F61: F61 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; F62: F62 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; F63: F63 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; F64: F64 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference | International Paralympic Committee classification code for P… | |
| dedup | CharField | dedup | — | — | To distinguish people whos name/dob are exact matches | |
| external_crm_id | CharField | external_crm_id | — | — | Id of crm e.g. Kit | |
| cached_last | DateTimeField | cached_last | null | — | Timestamp of the last time this persons data was cached. |
Field names link to their fuller explanation below.
Field details
Click a field name in the table above to jump to its explanation. Fields with no help text yet show a prompt, and are the ones to improve by adding a help_text on the model field, then regenerating.
created
- Engine: SQL
- Type:
DateTimeField - Column/Key:
created - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
last_edit_time
- Engine: SQL
- Type:
DateTimeField - Column/Key:
last_edit_time - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
last_edit_by
- Engine: SQL
- Type:
CharField - Column/Key:
last_edit_by - nullable
No help text yet — add a help_text on the model field and regenerate to fill this in.
is_dirty
- Engine: SQL
- Type:
BooleanField - Column/Key:
is_dirty - default =
True
No help text yet — add a help_text on the model field and regenerate to fill this in.
id
- Engine: SQL
- Type:
CharField - Column/Key:
id - primary key
Unique random ID
first_name
- Engine: SQL
- Type:
CharField - Column/Key:
first_name
No help text yet — add a help_text on the model field and regenerate to fill this in.
first_name_local
- Engine: SQL
- Type:
CharField - Column/Key:
first_name_local
No help text yet — add a help_text on the model field and regenerate to fill this in.
last_name
- Engine: SQL
- Type:
CharField - Column/Key:
last_name
No help text yet — add a help_text on the model field and regenerate to fill this in.
last_name_local
- Engine: SQL
- Type:
CharField - Column/Key:
last_name_local
No help text yet — add a help_text on the model field and regenerate to fill this in.
gender
- Engine: SQL
- Type:
CharField - Column/Key:
gender - choices: M: M; F: F; X: X
No help text yet — add a help_text on the model field and regenerate to fill this in.
date_of_birth
- Engine: SQL
- Type:
DateField - Column/Key:
date_of_birth
dd-MM-yyyy
date_of_death
- Engine: SQL
- Type:
DateField - Column/Key:
date_of_death - nullable
dd-MM-yyyy
former_name
- Engine: SQL
- Type:
CharField - Column/Key:
former_name
Use for maiden names, deed poll etc
home_address
- Engine: SQL
- Type:
CharField - Column/Key:
home_address
Street, house, apartment, city/town, county
postcode
- Engine: SQL
- Type:
CharField - Column/Key:
postcode
No help text yet — add a help_text on the model field and regenerate to fill this in.
social_security
- Engine: SQL
- Type:
CharField - Column/Key:
social_security
11 digits
medical_exam_date
- Engine: SQL
- Type:
DateField - Column/Key:
medical_exam_date - nullable
When was the most recent medical examination?
medical_exam_expiry_date
- Engine: SQL
- Type:
DateField - Column/Key:
medical_exam_expiry_date - nullable
When does the most recent medical examination validity expire?
nickname
- Engine: SQL
- Type:
CharField - Column/Key:
nickname
Concurrently used nickname (e.g. Rob for Robert)
instagram_user
- Engine: SQL
- Type:
CharField - Column/Key:
instagram_user
Instagram username, without the @ symbol
twitter_user
- Engine: SQL
- Type:
CharField - Column/Key:
twitter_user
Twitter/X username, without the @ symbol
alt_address
- Engine: SQL
- Type:
CharField - Column/Key:
alt_address
Alternate address
alt_postcode
- Engine: SQL
- Type:
CharField - Column/Key:
alt_postcode
No help text yet — add a help_text on the model field and regenerate to fill this in.
- Engine: SQL
- Type:
CharField - Column/Key:
email
No help text yet — add a help_text on the model field and regenerate to fill this in.
alt_email
- Engine: SQL
- Type:
CharField - Column/Key:
alt_email
No help text yet — add a help_text on the model field and regenerate to fill this in.
phone
- Engine: SQL
- Type:
CharField - Column/Key:
phone
Home phone number
mobile
- Engine: SQL
- Type:
CharField - Column/Key:
mobile
Mobile phone number
height
- Engine: SQL
- Type:
PositiveSmallIntegerField - Column/Key:
height - nullable
cm
weight
- Engine: SQL
- Type:
FloatField - Column/Key:
weight - nullable
kg
size
- Engine: SQL
- Type:
CharField - Column/Key:
size - choices: XS: XS; S: S; M: M; L: L; XL: XL; XXL: XXL; XXXL: XXXL
shirt size
shoe_size
- Engine: SQL
- Type:
IntegerField - Column/Key:
shoe_size - nullable
Euro size (26 to 47)
photo
- Engine: SQL
- Type:
FileField - Column/Key:
photo - nullable
200x200 JPEG/JPG or SVG or PNG
profile_crop_width
- Engine: SQL
- Type:
FloatField - Column/Key:
profile_crop_width - nullable
width cropping value
profile_crop_height
- Engine: SQL
- Type:
FloatField - Column/Key:
profile_crop_height - nullable
height cropping value
profile_crop_x
- Engine: SQL
- Type:
FloatField - Column/Key:
profile_crop_x - nullable
x cropping value
profile_crop_y
- Engine: SQL
- Type:
FloatField - Column/Key:
profile_crop_y - nullable
y cropping value
recent_photo
- Engine: SQL
- Type:
FileField - Column/Key:
recent_photo - nullable
200x200 JPEG/JPG or SVG or PNG
recent_photo_crop_width
- Engine: SQL
- Type:
FloatField - Column/Key:
recent_photo_crop_width - nullable
width cropping value
recent_photo_crop_height
- Engine: SQL
- Type:
FloatField - Column/Key:
recent_photo_crop_height - nullable
height cropping value
recent_photo_crop_x
- Engine: SQL
- Type:
FloatField - Column/Key:
recent_photo_crop_x - nullable
x cropping value
recent_photo_crop_y
- Engine: SQL
- Type:
FloatField - Column/Key:
recent_photo_crop_y - nullable
y cropping value
parent_or_guardian_name
- Engine: SQL
- Type:
CharField - Column/Key:
parent_or_guardian_name
No help text yet — add a help_text on the model field and regenerate to fill this in.
parent_or_guardian_phone
- Engine: SQL
- Type:
CharField - Column/Key:
parent_or_guardian_phone
No help text yet — add a help_text on the model field and regenerate to fill this in.
parent_or_guardian_email
- Engine: SQL
- Type:
CharField - Column/Key:
parent_or_guardian_email
No help text yet — add a help_text on the model field and regenerate to fill this in.
coach_name
- Engine: SQL
- Type:
CharField - Column/Key:
coach_name
No help text yet — add a help_text on the model field and regenerate to fill this in.
coach_email
- Engine: SQL
- Type:
CharField - Column/Key:
coach_email
No help text yet — add a help_text on the model field and regenerate to fill this in.
eql
- Engine: SQL
- Type:
IntegerField - Column/Key:
eql - nullable; choices: 1: Level 1; 2: Level 2; 3: Level 3; 4: Level 4; 5: Level 5; 6: Level 6; 7: Level 7; 8: Level 8
European Qualification Level
next_of_kin_name
- Engine: SQL
- Type:
CharField - Column/Key:
next_of_kin_name
No help text yet — add a help_text on the model field and regenerate to fill this in.
next_of_kin_relationship
- Engine: SQL
- Type:
CharField - Column/Key:
next_of_kin_relationship
No help text yet — add a help_text on the model field and regenerate to fill this in.
next_of_kin_phone
- Engine: SQL
- Type:
CharField - Column/Key:
next_of_kin_phone
No help text yet — add a help_text on the model field and regenerate to fill this in.
next_of_kin_email
- Engine: SQL
- Type:
CharField - Column/Key:
next_of_kin_email
No help text yet — add a help_text on the model field and regenerate to fill this in.
nationality
- Engine: SQL
- Type:
ForeignKey→ Country (FK) - Column/Key:
nationality_id - nullable
Country he/she would compete for
nationality2
- Engine: SQL
- Type:
ForeignKey→ Country (FK) - Column/Key:
nationality2_id - nullable
Use for dual nationality
residence
- Engine: SQL
- Type:
ForeignKey→ Country (FK) - Column/Key:
residence_id - nullable
Country of residence
residence2
- Engine: SQL
- Type:
ForeignKey→ Country (FK) - Column/Key:
residence2_id - nullable
Use for dual residence
national_id
- Engine: SQL
- Type:
CharField - Column/Key:
national_id - nullable
ID in national system; general spare field when importing data
world_id
- Engine: SQL
- Type:
IntegerField - Column/Key:
world_id - nullable
ID in World Athletics database
world_slug
- Engine: SQL
- Type:
CharField - Column/Key:
world_slug
URL slug on World Athletics website
region_of_birth
- Engine: SQL
- Type:
ForeignKey→ Region (FK) - Column/Key:
region_of_birth_id - nullable
Local region of birth
region_of_residence
- Engine: SQL
- Type:
ForeignKey→ Region (FK) - Column/Key:
region_of_residence_id - nullable
Local region of residence
department1
- Engine: SQL
- Type:
CharField - Column/Key:
department1 - nullable; choices: : ------; RCFVS: RCFVS; MST: MST; SKFPB: SKFPB; DINAMO: DINAMO; SK VS RB: SK VS RB
Department athlete belongs to, important for getting paid.
department2
- Engine: SQL
- Type:
CharField - Column/Key:
department2 - nullable; choices: : ------; RCFVS: RCFVS; MST: MST; SKFPB: SKFPB; DINAMO: DINAMO; SK VS RB: SK VS RB
Second deparment athlete belongs to.
club_text
- Engine: SQL
- Type:
CharField - Column/Key:
club_text
Cached club code(s), for efficient querying, auto-calculated
age_group_text
- Engine: SQL
- Type:
CharField - Column/Key:
age_group_text
Cached current age group, for efficient querying, auto-calculated
summary_text
- Engine: SQL
- Type:
CharField - Column/Key:
summary_text
Cached identity string, for efficient querying, auto-calculated
coach_text
- Engine: SQL
- Type:
CharField - Column/Key:
coach_text
Cached coach names, for efficient querying, auto-calculated
is_inactive
- Engine: SQL
- Type:
BooleanField - Column/Key:
is_inactive - default =
False
if set, this person will be hidden from view
hide_profile
- Engine: SQL
- Type:
BooleanField - Column/Key:
hide_profile - default =
False
Hide this person's profile page from the public and from search engines
key_fn_ln_dob
- Engine: SQL
- Type:
CharField - Column/Key:
key_fn_ln_dob
No help text yet — add a help_text on the model field and regenerate to fill this in.
key_nn_ln_dob
- Engine: SQL
- Type:
CharField - Column/Key:
key_nn_ln_dob
No help text yet — add a help_text on the model field and regenerate to fill this in.
key_nn_ln_email
- Engine: SQL
- Type:
CharField - Column/Key:
key_nn_ln_email
No help text yet — add a help_text on the model field and regenerate to fill this in.
key_nn_ln_mobile
- Engine: SQL
- Type:
CharField - Column/Key:
key_nn_ln_mobile
No help text yet — add a help_text on the model field and regenerate to fill this in.
key_national_id
- Engine: SQL
- Type:
CharField - Column/Key:
key_national_id
No help text yet — add a help_text on the model field and regenerate to fill this in.
user
- Engine: SQL
- Type:
OneToOneField→ User - Column/Key:
user_id - nullable
User account which really is the person
managed_by_user
- Engine: SQL
- Type:
ForeignKey→ User (FK) - Column/Key:
managed_by_user_id - nullable
User account which manages this person (e.g parent, spouse)
ipc_classification_track
- Engine: SQL
- Type:
CharField - Column/Key:
ipc_classification_track - choices: T11: T11 - Vision impairment; T12: T12 - Vision impairment; T13: T13 - Vision impairment; T20: T20 - Intellectual impairment; T32: T32 - Co-ordination impairments (hypertonia, ataxia and athetosis); T33: T33 - Co-ordination impairments (hypertonia, ataxia and athetosis); T34: T34 - Co-ordination impairments (hypertonia, ataxia and athetosis); T35: T35 - Co-ordination impairments (hypertonia, ataxia and athetosis); T36: T36 - Co-ordination impairments (hypertonia, ataxia and athetosis); T37: T37 - Co-ordination impairments (hypertonia, ataxia and athetosis); T38: T38 - Co-ordination impairments (hypertonia, ataxia and athetosis); T40: T40 - Short stature; T41: T41 - Short stature; T42: T42 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T43: T43 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T44: T44 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T45: T45 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; T46: T46 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; T47: T47 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; T51: T51 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T52: T52 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T53: T53 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T54: T54 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; T61: T61 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T62: T62 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T63: T63 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T64: T64 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; T71: T71 - athletes with severe co-ordination impairment (hypertonia, ataxia, athetosis); T72: T72 - athletes with severe co-ordination impairment (hypertonia, ataxia, athetosis)
International Paralympic Committee classification code for Para Athletes
ipc_classification_field
- Engine: SQL
- Type:
CharField - Column/Key:
ipc_classification_field - choices: F11: F11 - Vision impairment; F12: F12 - Vision impairment; F13: F13 - Vision impairment; F20: F20 - Intellectual impairment; F31: F31 - Co-ordination impairments (hypertonia, ataxia and athetosis); F32: F32 - Co-ordination impairments (hypertonia, ataxia and athetosis); F33: F33 - Co-ordination impairments (hypertonia, ataxia and athetosis); F34: F34 - Co-ordination impairments (hypertonia, ataxia and athetosis); F35: F35 - Co-ordination impairments (hypertonia, ataxia and athetosis); F36: F36 - Co-ordination impairments (hypertonia, ataxia and athetosis); F37: F37 - Co-ordination impairments (hypertonia, ataxia and athetosis); F38: F38 - Co-ordination impairments (hypertonia, ataxia and athetosis); F40: F40 - Short stature; F41: F41 - Short stature; F42: F42 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F43: F43 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F44: F44 - Lower limb competing without prosthesis affected by limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F45: F45 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; F46: F46 - Upper limb/s affected by limb deficiency, impaired muscle power or impaired passive range of movement; F51: F51 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F52: F52 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F53: F53 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F54: F54 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F55: F55 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F56: F56 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F57: F57 - Limb deficiency, leg length difference, impaired muscle power or impaired passive range of movement; F61: F61 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; F62: F62 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; F63: F63 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference; F64: F64 - Lower limb/s competing with prosthesis affected by limb deficiency and leg length difference
International Paralympic Committee classification code for Para Athletes
dedup
- Engine: SQL
- Type:
CharField - Column/Key:
dedup
To distinguish people whos name/dob are exact matches
external_crm_id
- Engine: SQL
- Type:
CharField - Column/Key:
external_crm_id
Id of crm e.g. Kit
cached_last
- Engine: SQL
- Type:
DateTimeField - Column/Key:
cached_last - nullable
Timestamp of the last time this persons data was cached.
Generated by docs_models management command for SQL.