Data cleanup to do Organizations - org_type_id - some are null buildings cannot have created_date = null This record has no org_id (1364, NULL, 'Enfield Elementary', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1271, '2015-07-31 07:30:43', 1271), Addresses table has null values for zip_code, state, city, and there are non-state values for state column. (ie; the abbreviation of a person, numbers, etc.) floorplans table - floor_number has wide variety of value types (Emerson, Portable, Basement, Area A.1, Area A.2 First Floor Cafeteria, Tower 3, Red 100, Ground, HTC@LHS, East Wing, Atheletics(yes, misspelled), and actual numbers). If these values are desirable, should we rename the column to something like location, machine_location, or location_specifics? floorplans table - last_audited_by has many null values and the values are names. Can we change this to an int id? users table - massachusetts contacts will be removed by Pam