Sections B, C, and D Report Mapping

Name of school or program

N/A

This value is taken from the prompts when the report is run.

Date of report

N/A

This date value is taken from the prompts when the report is run.

Child's name

reg.last_name, reg.first_name

Registration > Entry & Reports > Student Demographic > Registration

Last Name, First Name

Grade

and

Birthdate

reg_grade.state_code_equiv

and 

reg.birthdate

Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Entry/Withdrawal Details

Grade

Registration > Entry & Reports > Student Demographic > Registration

Birthdate

Parent's name

and

current mailing address

reg_contact.first_name + reg_contact.middle_name + reg_contact.last_name + reg_contact.generation

and 

reg_contact.street_number + reg_contact.street_prefix + reg_contact.street_name + reg_contact.street_suffix + reg_contact.street_type + reg_contact.apartment + reg_contact.complex + reg_contact.city + reg_contact.state + reg_contact.zip

Registration > Entry & Reports > Student Demographic > Contacts

First Name, Middle Name, Last Name, Generation

Registration > Entry & Reports > Student Demographic > Contacts

Mailing Address

Exclusion order mailed?  Y/N

N/A

Defaulted to blank

Vaccines

med_general.immune_status

Medical > All > Student > Immunizations

Student Status

Excluded?  Y/N

N/A

Defaulted to blank

Check if no record

N/A

Medical > All > Student > Immunizations

Student Status

If Student Status is "NR" then the checkbox will be checked.