Instructor-migration

From VPOIDS Documentation

Data we capture about pilots and their ratings and certifications:

In AFIDS 1.0:

  • licenseType
  • ifr (bit), 1 or 0
  • multiEngine (bit), 1 or 0
  • seInstructor (mixed):
    • No 3,691
    • 1 65
    • 0 2436
    • CFII 134
    • CFI 326
  • meInstructor
    • MEII 166
    • MEI 80
    • No 3753
    • 1 111
    • 0 2390
    • CFI 152
  • otherRatings (no data in AFIDS 1.0)

hseats:

  • HSEATS 6Hr 229
  • HSEATS Sustainer 119
  • NULL 5906
  • HSEATS 2Hr 398

In AFIDS 2.0:

  • license_type (same as AFIDS 1.0)
  • ifr (tinyint) 1 or 0 (same as AFIDS 1.0)
  • multi_engine (tinyint) 1 or 0 (same as AFIDS 1.0)
  • se_instructor
  • me_instructor
  • other_ratings (same as AFIDS 1.0)

Application_temp

ratings (varchar) medical_class license_type hseats_interest tinyint

In the membership application and renewal, the member is given a series of checkboxes for ratings:

  • CFI
  • CFII
  • Private
  • Commercial
  • ATP
  • IFR
  • Multi
  • Other

Application

When the application is processed

  • license_type
  • ifr
  • multi
  • se_instructor
  • me_instructor
  • other_ratings
  • medical_class
  • hseats_interest tinyint

Pilot

When the application_temp is processed, the ratings field is mapped into the fields in the pilot table:

  • license_type. License type can be Private, Commercial, or ATP. The default is set to Private, and then it checks to see if Commercial or ATP is in the ratings fields. If it's there, it over-writes with the "higher" rating.
  • ifr tinyint. If ifr is in the string, then this is set to 1.
  • multi_engine tinyint. If multi is in the string, then this is set to 1.
  • se_instructor varchar(5).
  • me_instructor varchar(5)
  • other_ratings
  • hseats varchar(30)
  • pilot_license_types: { 'Private':'Private', 'Commercial':'Commercial', 'ATP':'ATP' }
  • pilot_me_instructor: { 'MEI':'MEI', 'MEII':'MEII' }
  • pilot_se_instructor: { 'CFI':'CFI', 'CFII':'CFII' }

hseats:

  • hseats Yes or No

Information flow

  1. Member application - ratings field is populated with comma delimited text strings
  2. Process application - ratings field is parsed into license_type, ifr, multi, se_instructor, me_instructor and other_ratings in pilot table
  3. Process application - ratings field is parsed into license_type, ifr, multi, se_instructor, me_instructor and other_ratings in application table
  4. Add or edit pilot record
  5. Member renewal application
  6. Renewal application - ratings field is populated with comma delimited text strings
  7. Process application - ratings field is parsed into license_type, ifr, multi, se_instructor, me_instructor and other_ratings in pilot table
  8. Process application - ratings field is parsed into license_type, ifr, multi, se_instructor, me_instructor and other_ratings in application table