Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

«Field name», Explanation, Field type/size:
«HOFNR» Meeting number (id) NUMBER/Integer
«ENAME» Meeting name TEXT/255
«SCODE» Series code (id)  NUMBERNUMBER/Long Integer
«INPUTDATE» Date of first input TEXT/255
«EDITDATE» Date meeting editions last edited TEXT/255
«YEAR» Year of meeting NUMBER/Integer
«START» Starting day/month NUMBER/Integer
«ENDD» Ending day/month NUMBER/Integer
«covid status» Meeting status regarding COVID-19
«CITY» City where meeting takes place TEXT/255
«COUNTRY» Country where meeting takes place TEXT/255
«ATTEN» Attendance NUMBER/Integer
«ACOMP» Number of accompanying persons TEXT/255
«REGFEE» Registration fee for meeting TEXT/255
«CURR» Currency for registration fee TEXT/255
«NUMHOT» Number of hotel rooms booked TEXT/255
«COMEXH» Commercial exhibition (yes/no) TEXT/255 21
«NUMEXH» Number of exhibitors TEXT/255
«COMPOS» Commercial poster exhibition TEXT/255
«NUMSURF» Number of surface space TEXT/255
«NUMPOS» Number of posters TEXT/255
«SNAME» Secretariat name TEXT/255
«SCONTACT» Secretariat contact person TEXT/255
«SADDRESS» Secretariat address TEXT/255
«SADDRESS ENTER» Secretariat address TEXT/255
«SPOCODE1» Secretariat postal code (in front of city) TEXT/255
«SCITY» Secretariat city TEXT/255
«SPOCODE2» Secretariat postal code (after city) TEXT/255
«SCOUNTRY» Secretariat country TEXT/255
«SPHONE» Secretariat phone number TEXT/255
«SFAX» Secretariat fax number TEXT/255
«SHOMEPAGE» Secretariat homepage TEXT/255
«SEMAIL» Secretariat e-mail TEXT/255
«SFUNCTION» Secretariat function TEXT/255
«ONAME» Org. committee name TEXT/255
«OCONTACT» Org. committee contact person TEXT/255
«OFUNCTION» Org. committee contacts function TEXT/255
«OADDRESS» Org. committee address TEXT/255
«OPOCODE1» Org. committee postal code (in front of city) TEXT/255
«OCITY» Org. committee city TEXT/255
«OPOCODE2» Org. committee postal code (after city) TEXT/255
«OCOUNTRY» Org. committee country TEXT/255
«OPHONE» Org. committee phone number TEXT/255
«OFAX» Org. committee fax number TEXT/255
«OHOMEPAGE» Org. committee homepage TEXT/255
«OEMAIL» Org. committee e-mail TEXT/255
«SUB1» Subject matter of meeting TEXT/254 TEXT/255
«SUB2» Subject matter of meeting TEXT/254 TEXT/255
«SUB3» Subject matter of meeting TEXT/254 TEXT/255
«FOOTLINES» Extra remarks on meeting TEXT/255
«ICODE» Int.Org. code TEXT/ 10 NUMBER/Long Integer
«INAME» Int.Org. name TEXT/ 80
«IADDRESS» Int.Org. address TEXT/254
«iaddress_enter» Int.Org. address TEXT/254
«IPOCODE1» Int.Org. postal code (in front of city) TEXT/ 10
«ICITY» Int.Org. city TEXT/ 50
«IPOCODE2» Int.Org. postal code (after city) TEXT/ 10
«ICOUNTRY» Int.Org. country TEXT/ 50
«ICPERSON» Int.Org. contact person TEXT/ 40
«IFUNCTION» Int.Org. contact persons function TEXT/ 30
«SALUTATION» Dear “Contact person Int.Org.,” TEXT/ 40
«IUNTIL» Date until Int.Org. Contact person has been assigned TEXT/ 10
«IPHONE» Int.Org. phone number TEXT/ 30
«IFAX» Int.Org. fax number TEXT/ 30
«IHOMEPAGE» Int.Org. homepage TEXT/ 80
«IEMAIL» Int.Org. e-mail TEXT/ 40
«EVENUE1» Official venue for meeting TEXT/255
«EPCO1» Official Local PCO TEXT/255
«EAIR1» Official Airline TEXT/255
«EHOT1» Official hotel(s)/accommodation TEXT/255
«EEXH1» Official exhibition management TEXT/255
«ETRA1» Official DMC TEXT/255
«notes» Personal notes TEXT/254

...