SPMS Database Meeting 11 May 2005

1
SPMS Database Meeting11 May 2005
2
Registration ModuleThe Philosophy

• Christine Petit-Jean-Genaz
• EPAC Conferences Coordinator
• SPMS Administrator
• JACoW Secretary

3
Current

• New Customizable Tool called Registration
• Registration, as for PAC05, but
• May also be developed by individual conferences
  for other activities not part of GPL official
  SPMS
• Does this Tool correspond to the requirements of
  JACoW Collaboration Conferences as a whole?

4
SPMS Philosophy

• Use same data driven philosophy as for the
  Scientific Programme
• Build customized Registration Forms (via
  parameter lists) for example through the assembly
  of interfaces relating to one, several or all
  activities
• Combine several activities into one Form
• Opt for several forms
• Registration, budget handling, accommodation,
  etc. to be handled via tables

5
Modular Form

• Participation in the Conference (registration of
  delegates, logistics, payments, list of
  participants, badges, overall financial
  management)
• Participation in Social Events (logistics,
  payments)
• Participation in Excursions (logistics, payments)
• Accommodation (hotel accommodation requirements,
  payments)

6
Tables

• Type of Registrant/Individual
• Registrant (with fee)
• Registrant (fee waived)
• Retiree Registrant
• Student Registrant
• Type of Registration
• Early Registration
• Late Registration
• Retiree Registration
• Student Registration

7
Tables

• Social Events
• Banquet
• Reception
• Outing
• Tour
• Fees
• Early Fee - amount
• Late Fee - amount
• 1-day Fee - amount
• Reduced Fee - amount
• Student Fee - amount

8
Statistics as for Scientific Programme

• Running totals
• Number of Registrants by Type
• Number of Registrants by Fee
• Number Type a Delegate _at_ fee n amount paid/due
• Number Type b Delegate _at_ fee n amount paid/due
• Number attending Banquet
• Number Delegates _at_ fee n amount paid/due
• Number Accompanying Persons _at_ fee n amount
  paid/due
• Number Vendors _at_ fee n amount paid/due

9
Advantages

• Programming is done only once
• Same tool for every type of conference
• Etc.

10

• Or have I got it completely wrong?