D9650 members

KBH Software
Explanation of fields & Notes - Sql notes at end

---

• Id
• Active Space or Y , N=Not Active
• Security 10 = floor members, 50 = Club Admin, 80 = District Users, 85= District user with some edit rights, 90 = District Admin, 99 = Sys Admin
• Password
• User_Name - Optional for frequent users
• [disc] Directory_Years = 2009-2010 = 10, 2010-2011 = 11,   This now controlled in Committee_members file
• Surname
• Given
• Partner_given
• Address
• Home_phone
• Work_phone
• Mobile
• Fax
• Business_email
• Home_email
• Preferred_email
• Club
• RI_Number
• Classification
• [disc] Club_position Now controlled by committee-members
• Photo
• Bulletin
• Roster_OK
• Badge_No
• Recognitions - Temp field until Recognition database added used by rctfl only
• Log = Audit Log
• Date_created
• Amended_By - added 03/06/09
• Date_amended
• Notes