Index page

 

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