Ariadne - Technical description
A020 |
Persons |
Description
Maintenance screen for persons data :
- name, gender (mandatory)
- age class, performance level
- address
- entries and official roles for the current competition
- results and official roles form the archive
Access path
 F000-Menu |
A010 |
 F200-Person |
A020 |
| F190-Person-entries |
A020 |
| F192-Person-roles |
A020 |
| F194-Roles-history |
A020 |
| F196-Ranking-history |
A020 |
| F210-Address |
A014 |
| F010-Remark |
A012 |
Screenshot: F200-Person
Function structure
| Form | Control | Subform/action | Query | Table | Attribute |
| F200-Person | Q200-Persons | T200-Person | |||
| dropbox person-select |
Q203-Person-select-F200 | T200-Person | person-id | ||
| year-of-birth | when populated with valid value, the age class is preset. | ||||
| dropbox gender |
T033-Gender | gender-id | |||
| dropbox ageclass |
T044-Age-class | age-class-id | |||
| dropbox performancelevel |
list of values: 1,2,3 | ||||
| button buttonEntries |
onclick: open F486-Entries-per-person |
||||
| subform entries |
F190-Person-entries | person-id | |||
| subform roles |
F192-Person-roles | person-id | |||
| subform rankinghistory |
F196-Ranking-history | archived-person-id | |||
| subform roles-history |
F194-Roles-history | archived-person-id | |||
| subform addressdata |
F210-Address | Q210-Addresses | T210-Address | address-id *) | |
| subform remarks |
F010-Remarks | Q010-Remarks | T010-Remark | remark-id **) | |
| button ButtonAddNewPerson |
sets the form to a blank person record | ||||
| button ButtonClose |
closes the form |
*) address-id = person-id prefixed with "P"
**) remark-id = person-id prefixed with "P"
| SubForm | Control | Subform/ action | Query | Table | Attribute |
| F190-Person-entries | Q190-Person-entries | T040-Category T230-Participant T300-Kayak-club T500-Competing-unit |
person-id | ||
| button ButtonEntry |
opens F510-Competing-unit |
F190-Person-entries is only display.
| SubForm | Control | Subform | Query | Table | Attribute |
| F192-Person-roles | Q192-Person-roles | T030-Role-type T220-Official T300-Kayak-club |
person-id | ||
| button ButtonClub |
opens F310-Kayak-club-details |
F192-Person-roles is only display.
| SubForm | Control | Subform | Query | Table | Attribute |
| F194-Roles-history | Q194-Roles-history | T030-Role-type T800-Archived-competition T810-Archived-official T830-Archived-kayak-club |
archived-person-id |
F194-Roles-history is only display.
| SubForm | Control | Subform | Query | Table | Attribute |
| F196-Ranking-history | Q196-Ranking-crosstab | T032-Boat-type T040-Category T044-Age-class T800-Archived-competition T805-Archived-result |
archived-person-id |
F196-Ranking-history is only display.
Q196-Ranking-crosstab normalizes the results of history competitions with
help of the ranking scale of that competition. Ranking value of 100 points
is the best perfomance of a competition, 0 points is low level perfomance,
practically set to 600 seconds for a result.
The ranking value is calculated as follows: (100*([event-result]-[100-point-result])/([0-point-result]-[100-point-result]))
The normalized ranking values make results per competiton compariible. The ranking figures are presented for the boat classes K1, C1 and C2, per competition and per age class.
| SubForm | Control | Subform | Query | Table | Attribute |
| F210-Address | address-id *) |
*) The address-id is the person-id prefixed with the letter "P".
See further F210-Address
| SubForm | Control | Subform | Query | Table | Attribute |
| F010-Remark | remark-id *) |
*) For remarks in relation to persons, the remark-id is the person-id prefixed with "P" . See further subform F010-Remark
Change history this document
| date | Ariadne version | change |
| 15 May 2005 | 4.3.0 | button new entry removed, button entries added |
| 20 Nov 2003 | 4.2.0 | connect button to entry, connect button to kayak club, button new person |
| 01 Oct 2002 | 4.1.0 | text converted to html |