1 / 8

JACoW Team Meeting

This system offers a tailored approach by combining generic code with customizable registration data. Its database design allows for easy setup and management, driven by metadata. It ensures secure payment processing and detailed reporting capabilities.

yolandar
Download Presentation

JACoW Team Meeting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. JACoW Team Meeting JACoW Database Scientific Program Management System (SPMS) Registration Module Matt Arena, Fermi National Accelerator Laboratory

  2. Registration Module • One size fits all – not realistic • Customized for each conference – not realistic • Solution – all little bit of both • Generic code • Customizable registration data

  3. Advantages • One source code • Administrator has complete control • Multiple pages (delegates, staff, tour, teachers) • Same data fields (banquet, reception) • Routine registration prompts and pages downloaded from repository

  4. Disadvantages • Longer setup time • Setup more complex (popup lists, “matrix”) • Not very intuitive (documentation pending) • Unique database design (see server model) • Difficult to generate ad hock reports • Possible solutions: • XML, warehouse views, CSV extract files • Others? I’m open to suggestions

  5. Design • Driven by meta data (see server model diagram) • Prompt, length, mandatory, etc. • Data Types: text, number, date, fee • Display styles: text, multi-line, popup lists and yes/no • Fees optionally attached to any item • Two items may be combined into one fee structure • Conditional mandatory requirement based on Y/N item • Optionally, limits the number of registrants

  6. Pages • Built by adding meta data items • SPMS • builds page using meta data • in the specified order • validates the input (required, proper data type) • calculates the total fees • displays an invoice • Sends email to user • proceeds to payment processing

  7. Payment Processing • All web traffic encrypted via SSL • Dynamic payment types • Online and Conference only options • Special instructions per payment type • Email when payment is processed • Reminder email (and delay) per payment type • Tracks credit cards for multiple use • Sensitive data encrypted in the DB • Payments time stamped (late fee calculation)

  8. Reports • Budget – totals by meta data item • Country/region counts • Statistics – ad hoc query tool • Summary Statistics – totals by presentation type and payment type • Extracts – all meta data dumped by page into Excel spreadsheet

More Related