Below is the uncorrected machine-read text of this chapter, intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text of each book. Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.
48 This appendix outlines the formatting and data type specifi- cations for data to be exported to the L32C assessment tool. Three main categories of data exports are required, repre- sented by the following tables: Organizations (Table A.1), Contacts (Table A.2), and Survey Responses (Table A.3). Each responder and contact must belong to an organization sup- plied in the Organizations table. Export files must use the comma-separated values (*.csv) format. Further information regarding the fields and data types is supplied in the tables. A p p e n d i x A External Input Data Requirements Table A.1. Organization Field Specifications Field Name Data Type Length (characters) Comment Name Text 255 â Billing Street Text 255 â Billing City Text 255 â Billing State Text 2 â Billing Postal Code Text 10 â Phone Text 50 â Website Text 255 â Organizations Table A.2. Contact Field Specifications Field Name Data Type Length (characters) Comment Mailing City Text 255 â Mailing State Text 2 â Mailing Postal Code Text 10 â Phone Text 50 â Fax Text 50 â Mobile Phone Text 50 â E-mail Text 255 â Organization Name Text 255 â Title Text 255 Contactâs job title Department Text 255 â Responder Discipline C Text 255 Contactâs job disci- pline, selected from the following list: DOT, Emergency Medical Services, Fire and Rescue, Law Enforcement, Towing and Recovery Is Trainer C Boolean â TRUE if contact is considered a trainer, FALSE otherwise Designated POCC Boolean â TRUE if contact is considered a des- ignated point of contact (POC), FALSE otherwise Responder Affiliation C Text 255 Contactâs affiliation, selected from the following list: Paid Professional, Volunteer, Not Applicable (continued) Contacts Table A.2. Contact Field Specifications Field Name Data Type Length (characters) Comment First Name Text 50 â Last Name Text 50 â Mailing Street Text 255 â (continued)
49 A set of pertinent responder questions, outlined in Table A.4, must be included at the beginning of every survey, regardless of survey type. The remaining questions for Level 1 and Level 2 will be supplied by the sponsoring agency. For Level 1, these questions should be prefixed with the header string [Q#] where # is the question number. For Level 2, the prefix is [L#Q#] where the first # refers to the lesson number under which the question falls. Survey export file names must begin with the string Level # where # can be either 1 or 2. Responses The Responses table contains sets of survey responses for each of the responders to the surveys. Within the scope of this proj- ect, only Level 1 and Level 2 survey types may require external data input. For optimal assessment, all the responders to the Level 1 survey should also complete the Level 2 survey. Additionally, every responder has a unique ID string that is to be used in both survey types. Table A.3. Response Field Specifications Field Name Data Type Length (characters) Comment Question Text 255 Question text, must be prefixed with a header, for example, [L#Q#].a Response Text 255 The userâs response to multiple-choice, true/false questions Comment Text 255 The userâs response to open-ended questions Date/Time Date â The userâs response to questions regarding dates Created At Date â Creation date of survey question Internal ID Number 8 Unique identifier for each survey responder Collector Text 255 Identifies the iteration of a set of surveys; formatted as 1.0, 2.1, etc. a The two #s in the header [L#Q#] denote the lesson number and question number. For questions with multiple subparts, use the header format [L#Q#|A] where A stands for the part of the question [e.g., Question 1. (a), (b), (c)]. For the pertinent responder questions outlined in Table A.4, use the header [Q#], as there is no associated lesson. Table A.4. Question Specifications and Sample Responses Question Response Comment Date/Time Created At [Q1] Your agency or organization: Brentwood Fire and Rescue 1/18/2014 12:25 [Q2] In what state is your agency/organization based? TN 1/18/2014 12:25 [Q3] Your affiliation with this agency/organization: Paid Professional 1/18/2014 12:25 [Q4] Your primary TIM discipline: Fire and Rescue 1/18/2014 12:25 [Q5] Why did you take this course? A. Required by my agency/organization 1/18/2014 12:25 [Q6] Course start date 1/30/2014 1/18/2014 12:25 [Q7] Did you take this course online? Yes 1/18/2014 12:25 [Q8] Training locationâcity Warwick 1/18/2014 12:25 [Q9] Training locationâstate RI 1/18/2014 12:25