Differences

This shows you the differences between two versions of the page.

info:raw_data_exports [2019/02/04 20:26]
esisler [Raw data exports]
info:raw_data_exports [2019/02/04 20:30] (current)
esisler
Line 53: Line 53:
 ^ Field ^ Info ^ ^ Field ^ Info ^
 | reader_id  | System assigned reader ID.  | | reader_id  | System assigned reader ID.  |
-| first_name  | First name.  | 
 | last_name  | Last name.  | | last_name  | Last name.  |
 +| first_name  | First name.  |
 | phone  | Phone number.  | | phone  | Phone number.  |
 | level_desc  | Completed level description.  | | level_desc  | Completed level description.  |
-| date_completed  | Date the level was completed.  |+| level_detail  | Which prize was given / task completed / etc for the level.  | 
 +| date_completed  | Date the level was completed.  | 
 | library_desc  | Library description.  | | library_desc  | Library description.  |
 | age_desc  | Age description.  | | age_desc  | Age description.  |
 +| bdate  | Birthdate (free-form text).  |
 +| gender_desc  | Gender description.  |
 | city_desc  | City description.  | | city_desc  | City description.  |
 | zipcode_desc  | Zipcode description.  | | zipcode_desc  | Zipcode description.  |
Line 70: Line 73:
 | date_validated  | Date the registration was validated.  | | date_validated  | Date the registration was validated.  |
 | reg_ip  | The IP address of the computer where the registration was entered.  | | reg_ip  | The IP address of the computer where the registration was entered.  |
 +| reg_form  | The form used for initial registration (self or staff).  |
 | staff_notes  | Notes to/from staff about the reader.  | | staff_notes  | Notes to/from staff about the reader.  |
 | guardian_first_name  | Guardian's first name.  | | guardian_first_name  | Guardian's first name.  |
Line 76: Line 80:
 | guardian_email  | Guardian's e-mail address.  | | guardian_email  | Guardian's e-mail address.  |
 | guardian_barcode  | Guardian's library barcode.  | | guardian_barcode  | Guardian's library barcode.  |
 +| consent  | Consent checkbox (0 or 1).  |
 +| public_checkbox  | Public checkbox (0 or 1).  |
 +| public_dropdown_desc  | Public drop-down description.  |
 +| public_textbox  | Public text box.  |
 +| staff_checkbox  | Staff checkbox (0 or 1).  |
 +| staff_dropdown_desc  | Staff drop-down description.  |
 +| staff_textbox  | Staff text box.  |
 +
  
 <note> <note>
 
info/raw_data_exports.txt (4559 views) · Last modified: 2019/02/04 20:30 by esisler