CO Digital Upload PreK (Colorado)

Tool Search: Digital Upload PreK Report

The Preschool Immunization Digital Upload is used to report student immunization compliance for each vaccine dose.

Screenshot of the Colorado Digital Upload Pre-K Report.CO Digital Upload Pre-K Report

Report Logic

The report aggregates a count of days between the student's birth date and immunization dose dates per vaccine.

The report can be run against a district’s active year as well as any prior year. 

Prior to running report: 

  • The City ID field located at System Administration > Resources > School must be populated.
  • Users need to validate County and County number is accurate according to the State. This is located at System Admin > Resources > Counties. The counties in which the School(s) reside at System Administration > Resources > District Counties must also be populated.

Report Editor

FieldDescription
CountyThe county in which the school resides.
Effective Date

The date the report will run.


The field is auto-populated with the current date, but can be changed by using the calendar icon to select a date or entering a new date in mmddyy format.

FormatSelection determines whether the extract generates in the State Upload, CSV, or HTML format.
Calendar SelectionAt least one calendar needs to be selected in order to generate the report. Calendars can be selected by the active year, by school name or by year.
Report GenerationThe report can be generated immediately using the Generate Report button. Or, use the Submit to Batch button to select when the report is generated. See the Batch Queue article for more information on this functionality.

Generate the PreK Digital Upload Report

  1. Select the County from the dropdown.
  2. Enter the desired Effective Date.
  3. Select the Format of the report.
  4. Select the Calendar(s) from which to report information.
  5. Click the Generate Extract button or use the Submit to Batch button. The report displays in the desired format.

Report Layout

Data ElementDescriptionLocation
County NameThe name of the county selected in the report editor.

Alphanumeric
System Administration > Resources > District Counties > Name

dis.county

School Code


The CDHS number.

Numeric

System Administration > Resources > School > CDHS Code


CDHScode

School Name

The school name.

Alphanumeric
System Administration > Resources > School > Name

sch.name

School Address


The address of the school.

Alphanumeric
System Administration > Resources > School > Address

sch.address

School City ID

The city ID of the school.

Alphanumeric
System Administration > Resources > School > City ID

sch.cityid

School County ID

The school county ID of the school.

Alphanumeric
System Administration > Resources > District Counties > Number

county.number

School Zip Code

The zip code of the school.

Numeric
System Administration > Resources > School > Zip

sch.zip
Date CreatedThe effective date selected in the report editor.

YYYY-MM-DD (space) HH:MM:SS
Selected in report editor

Student ID

The student's State identification number.

Numeric

Census > People > Demographics > Student State ID


student.stateID

Grade

The student's grade level.

Alphanumeric

Student > General > Enrollments > Grade


student.grade

DTaP 1

immunization.code = DTap-DTP
The number of days between the student's birthdate and the date of the first DTaP dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate1date minus student.birthdate
DTaP 2

immunization.code = DTap-DTP
The number of days between the student's birthdate and the date of the second DTaP dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate2date minus student.birthdate
DTaP 3

immunization.code = DTap-DTP
The number of days between the student's birthdate and the date of the third DTaP dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate3date minus student.birthdate
DTaP 4

immunization.code = DTap-DTP
The number of days between the student's birthdate and the date of the fourth DTaP dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate4date minus student.birthdate
DTaP 5

immunization.code = DTap-DTP
The number of days between the student's birthdate and the date of the fifth DTaP dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate5date minus student.birthdate
DTaP 6

immunization.code = DTap-DTP
The number of days between the student's birthdate and the date of the sixth DTaP dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate6date minus student.birthdate
DTaP 7

immunization.code = DTap-DTP
The number of days between the student's birthdate and the date of the seventh DTaP dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate7date minus student.birthdate
DTaP 8

immunization.code = DTap-DTP
The number of days between the student's birthdate and the date of the eight DTaP dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate8date minus student.birthdate
DTaP 9

immunization.code = DTap-DTP
The number of days between the student's birthdate and the date of the ninth DTaP dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate9date minus student.birthdate
DTaP 10

immunization.code = DTap-DTP
The number of days between the student's birthdate and the date of the ninth DTaP dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate10date minus student.birthdate
DTaP ExemptThe name of the exemption claimed for the DTaP vaccine.

Alphanumeric

Student > Health > Immunizations


If immCpl.exemption is not null and expired date <= effective date, the immCpl.stateexemption description reports (i.e. Personal, Religious, Medical, or Lab Verified). If immCpl.exemption is null, 'None' reports.

DTaP In ProcessReports 0 (zero).

Numeric
N/A
Polio 1

immunization.code = IPV, OPV, or IPV/OPV
The number of days between the student's birthdate and the date of the first Polio dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate1date minus student.birthdate
Polio 2

immunization.code = IPV, OPV, or IPV/OPV
The number of days between the student's birthdate and the date of the second Polio dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate2date minus student.birthdate
Polio 3

immunization.code = IPV, OPV, or IPV/OPV
The number of days between the student's birthdate and the date of the third Polio dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate3date minus student.birthdate
Polio 4

immunization.code = IPV, OPV, or IPV/OPV
The number of days between the student's birthdate and the date of the fourth Polio dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate4date minus student.birthdate
Polio 5

immunization.code = IPV, OPV, or IPV/OPV
The number of days between the student's birthdate and the date of the fifth Polio dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate5date minus student.birthdate
Polio 6

immunization.code = IPV, OPV, or IPV/OPV
The number of days between the student's birthdate and the date of the sixth Polio dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate6date minus student.birthdate
Polio 7

immunization.code = IPV, OPV, or IPV/OPV
The number of days between the student's birthdate and the date of the seventh Polio dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate7date minus student.birthdate
Polio 8

immunization.code = IPV, OPV, or IPV/OPV
The number of days between the student's birthdate and the date of the eighth Polio dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate8date minus student.birthdate
Polio 9

immunization.code = IPV, OPV, or IPV/OPV
The number of days between the student's birthdate and the date of the ninth Polio dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate9date minus student.birthdate
Polio 10

immunization.code = IPV, OPV, or IPV/OPV
The number of days between the student's birthdate and the date of the tenth Polio dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate10date minus student.birthdate
Polio ExemptThe name of the exemption claimed for the Polio vaccine.

Alphanumeric

Student > Health > Immunizations


If immCpl.exemption is not null and expired date <= effective date, the immCpl.stateexemption description reports (i.e. Personal, Religious, Medical, or Lab Verified). If immCpl.exemption is null, 'None' reports. If the student is over 18 years old, "Aged Out" reports.

Polio In ProcessReports 0 (zero).

Numeric
N/A
MMR 1

immunization.code = MMR or MMRV
The number of days between the student's birthdate and the date of the first MMR dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate1date minus student.birthdate
MMR 2

immunization.code = MMR or MMRV
The number of days between the student's birthdate and the date of the second MMR dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate2date minus student.birthdate
MMR 3

immunization.code = MMR or MMRV
The number of days between the student's birthdate and the date of the third MMR dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate3date minus student.birthdate
MMR 4

immunization.code = MMR or MMRV
The number of days between the student's birthdate and the date of the fourthMMR dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate4date minus student.birthdate
MMR 5

immunization.code = MMR or MMRV
The number of days between the student's birthdate and the date of the fifth MMR dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate5date minus student.birthdate
MMR 6

immunization.code = MMR or MMRV
The number of days between the student's birthdate and the date of the sixth MMR dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate6date minus student.birthdate
MMR 7

immunization.code = MMR or MMRV
The number of days between the student's birthdate and the date of the seventh MMR dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate7date minus student.birthdate
MMR 8

immunization.code = MMR or MMRV
The number of days between the student's birthdate and the date of the eighth MMR dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate8date minus student.birthdate
MMR 9

immunization.code = MMR or MMRV
The number of days between the student's birthdate and the date of the ninth MMR dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate9date minus student.birthdate
MMR 10

immunization.code = MMR or MMRV
The number of days between the student's birthdate and the date of the tenth MMR dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate10date minus student.birthdate
MMR ExemptionThe name of the exemption claimed for the MMR vaccine.

Alphanumeric

Student > Health > Immunizations


If immCpl.exemption is not null and expired date <= effective date, the immCpl.stateexemption description reports (i.e. Personal, Religious, Medical, or Lab Verified). If immCpl.exemption is null, 'None' reports.

MMR In ProcessReports 0 (zero).

Numeric
N/A
HepB 1

immunization.code =  HepB or HepB-2 
The number of days between the student's birthdate and the date of the first Hepatitis B dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate1date minus student.birthdate
HepB 2

immunization.code =  HepB or HepB-2 
The number of days between the student's birthdate and the date of the second Hepatitis B dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate2date minus student.birthdate
HepB 3

immunization.code =  HepB or HepB-2 
The number of days between the student's birthdate and the date of the third Hepatitis B dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate3date minus student.birthdate
HepB 4

immunization.code =  HepB or HepB-2 
The number of days between the student's birthdate and the date of the fourth Hepatitis B dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate4date minus student.birthdate
HepB 5

immunization.code =  HepB or HepB-2 
The number of days between the student's birthdate and the date of the fifth Hepatitis B dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate5date minus student.birthdate
HepB 6

immunization.code =  HepB or HepB-2 
The number of days between the student's birthdate and the date of the sixth Hepatitis B dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate6date minus student.birthdate
HepB 7

immunization.code =  HepB or HepB-2 
The number of days between the student's birthdate and the date of the seventh Hepatitis B dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate7date minus student.birthdate
HepB 8

immunization.code =  HepB or HepB-2 
The number of days between the student's birthdate and the date of the eighth Hepatitis B dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate8date minus student.birthdate
HepB 9

immunization.code =  HepB or HepB-2 
The number of days between the student's birthdate and the date of the ninth Hepatitis B dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate9date minus student.birthdate
HepB 10

immunization.code =  HepB or HepB-2 
The number of days between the student's birthdate and the date of the tenth Hepatitis B dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate10date minus student.birthdate
HepB ExemptThe name of the exemption claimed for the Hepatitis B vaccine.

Alphanumeric

Student > Health > Immunizations


If immCpl.exemption is not null and expired date <= effective date, the immCpl.stateexemption description reports (i.e. Personal, Religious, Medical, or Lab Verified). If immCpl.exemption is null, 'None' reports.

HepB In ProcessReports 0 (zero).

Numeric
N/A
Varicella 1

immunization.code = Varicella or MMRV
The number of days between the student's birthdate and the date of the first Varicella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate1date minus student.birthdate
Varicella 2

immunization.code = Varicella or MMRV
The number of days between the student's birthdate and the date of the second Varicella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate2date minus student.birthdate
Varicella 3

immunization.code = Varicella or MMRV
The number of days between the student's birthdate and the date of the third Varicella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate3date minus student.birthdate
Varicella 4

immunization.code = Varicella or MMRV
The number of days between the student's birthdate and the date of the fourth Varicella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate4date minus student.birthdate
Varicella 5

immunization.code = Varicella or MMRV
The number of days between the student's birthdate and the date of the fifth Varicella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate5date minus student.birthdate
Varicella 6

immunization.code = Varicella or MMRV
The number of days between the student's birthdate and the date of the sixth Varicella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate6date minus student.birthdate
Varicella 7

immunization.code = Varicella or MMRV
The number of days between the student's birthdate and the date of the seventh Varicella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate7date minus student.birthdate
Varicella 8

immunization.code = Varicella or MMRV
The number of days between the student's birthdate and the date of the eighth Varicella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate8date minus student.birthdate
Varicella 9

immunization.code = Varicella or MMRV
The number of days between the student's birthdate and the date of the ninth Varicella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate9date minus student.birthdate
Varicella 10

immunization.code = Varicella or MMRV
The number of days between the student's birthdate and the date of the tenth Varicella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate10date minus student.birthdate
Varicella ExemptThe name of the exemption claimed for the Varicella vaccine.

Alphanumeric

Student > Health > Immunizations


If immCpl.exemption is not null and expired date <= effective date, the immCpl.stateexemption description reports (i.e. Personal, Religious, Medical, or Lab Verified). If immCpl.exemption is null, 'None' reports.

Varicella In ProcessReports 0 (zero).

Numeric
N/A
Varicella HistoryReports 1 if the Exemption = Lab Verified. Reports 0 (zero) otherwise.

Student > Health > Immunizations


If immCpl.exemption is not null and expired date <= effective date AND  immCpl.stateexemption = L (Lab Verified), reports 1. If immCpl.exemption is null, 0 reports.

Tdap 1

immunization.code = Tdap
The number of days between the student's birthdate and the date of the first Tdap dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate1date minus student.birthdate
Tdap 2

immunization.code = Tdap
The number of days between the student's birthdate and the date of the second Tdap dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate2date minus student.birthdate
Tdap 3

immunization.code = Tdap
The number of days between the student's birthdate and the date of the third Tdap dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate3date minus student.birthdate
Tdap 4

immunization.code = Tdap
The number of days between the student's birthdate and the date of the fourth Tdap dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date
 
Calculated value = immunization.doseDate4date minus student.birthdate
Tdap 5

immunization.code = Tdap
The number of days between the student's birthdate and the date of the fifth Tdap dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate5date minus student.birthdate
Tdap 6

immunization.code = Tdap
The number of days between the student's birthdate and the date of the sixth Tdap dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate6date minus student.birthdate
Tdap 7

immunization.code = Tdap
The number of days between the student's birthdate and the date of the seventh Tdap dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate7date minus student.birthdate
Tdap 8

immunization.code = Tdap
The number of days between the student's birthdate and the date of the eighth Tdap dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate8date minus student.birthdate
Tdap 9

immunization.code = Tdap
The number of days between the student's birthdate and the date of the ninth Tdap dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate9date minus student.birthdate
Tdap 10

immunization.code = Tdap
The number of days between the student's birthdate and the date of the tenth Tdap dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate10date minus student.birthdate
Tdap ExemptThe name of the exemption claimed for the Tdap vaccine.

Alphanumeric

Student > Health > Immunizations


If immCpl.exemption is not null and expired date <= effective date, the immCpl.stateexemption description reports (i.e. Personal, Religious, Medical, or Lab Verified). If immCpl.exemption is null, 'None' reports.

Tdap In ProcessReports 0 (zero).

Numeric
N/A
HIB 1

immunization.code =  Hib or Hib-3
The number of days between the student's birthdate and the date of the first HIB dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate1date minus student.birthdate
HIB 2

immunization.code =  Hib or Hib-3
The number of days between the student's birthdate and the date of the second HIB dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate2date minus student.birthdate
HIB 3

immunization.code =  Hib or Hib-3
The number of days between the student's birthdate and the date of the third HIB dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate3date minus student.birthdate
HIB 4

immunization.code =  Hib or Hib-3
The number of days between the student's birthdate and the date of the fourth HIB dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate4date minus student.birthdate
HIB 5

immunization.code =  Hib or Hib-3
The number of days between the student's birthdate and the date of the fifth HIB dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate5date minus student.birthdate
HIB 6

immunization.code =  Hib or Hib-3
The number of days between the student's birthdate and the date of the sixth HIB dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate6date minus student.birthdate
HIB 7

immunization.code =  Hib or Hib-3
The number of days between the student's birthdate and the date of the first seventh  dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate7date minus student.birthdate
HIB 8

immunization.code =  Hib or Hib-3
The number of days between the student's birthdate and the date of the eighth HIB dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate8date minus student.birthdate
HIB 9

immunization.code =  Hib or Hib-3
The number of days between the student's birthdate and the date of the ninth HIB dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate9date minus student.birthdate
HIB 10

immunization.code =  Hib or Hib-3
The number of days between the student's birthdate and the date of the tenth HIB dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate10date minus student.birthdate
HIB ExemptThe name of the exemption claimed for the HIB vaccine.

Alphanumeric

Student > Health > Immunizations


If immCpl.exemption is not null and expired date <= effective date, the immCpl.stateexemption description reports (i.e. Personal, Religious, Medical, or Lab Verified). If immCpl.exemption is null, 'None' reports.

HIB In ProcessReports 0 (zero).

Numeric
N/A
PCV 1

immunization.code =  PCV, PPV
The number of days between the student's birthdate and the date of the first PCV dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate1date minus student.birthdate
PCV 2

immunization.code =  PCV, PPV
The number of days between the student's birthdate and the date of the second PCV dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate2date minus student.birthdate
PCV 3

immunization.code =  PCV, PPV
The number of days between the student's birthdate and the date of the third PCV dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate3date minus student.birthdate
PCV 4

immunization.code =  PCV, PPV
The number of days between the student's birthdate and the date of the fourth PCV dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate4date minus student.birthdate
PCV 5

immunization.code =  PCV, PPV
The number of days between the student's birthdate and the date of the fifth PCV dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate5date minus student.birthdate
PCV 6

immunization.code =  PCV, PPV
The number of days between the student's birthdate and the date of the sixth PCV dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate6date minus student.birthdate
PCV 7

immunization.code =  PCV, PPV
The number of days between the student's birthdate and the date of the seventh PCV dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate7date minus student.birthdate
PCV 8

immunization.code =  PCV, PPV
The number of days between the student's birthdate and the date of the eighth PCV dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate8date minus student.birthdate
PCV 9

immunization.code =  PCV, PPV
The number of days between the student's birthdate and the date of the ninth PCV dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate9date minus student.birthdate
PCV 10

immunization.code =  PCV, PPV
The number of days between the student's birthdate and the date of the tenth PCV  dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate10date minus student.birthdate
PCV ExemptThe name of the exemption claimed for the PCV vaccine.

Alphanumeric

Student > Health > Immunizations


If immCpl.exemption is not null and expired date <= effective date, the immCpl.stateexemption description reports (i.e. Personal, Religious, Medical, or Lab Verified). If immCpl.exemption is null, 'None' reports.

PCV In ProcessReports 0 (zero).

Numeric
N/A
ComplianceReports a value of 1 if the student's immunization compliance status for all required grade/age level is Compliant, No Requriement, or In Progress.

Numeric
Calculated
HepD Two Dose Series

immunization.code = HepB-2
Indicates if the student has received two doses in the Hepatitis B 2 dose series vaccines.Calculated = Reports 1 if immunization.doseDate1date of immunization.code = HEpB-2 AND immunization.dosesDate2date of immunization.code = HepB-2 are not null. Otherwise, 0 (zero) reports.
DT 1

immunization.code = DT
The number of days between the student's birthdate and the date of the first DT dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate1date minus student.birthdate
DT 2

immunization.code = DT
The number of days between the student's birthdate and the date of the second DT dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate2date minus student.birthdate
DT 3

immunization.code = DT
The number of days between the student's birthdate and the date of the third DT dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate3date minus student.birthdate
DT 4

immunization.code = DT
The number of days between the student's birthdate and the date of the first fourth dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate4date minus student.birthdate
DT 5

immunization.code = DT
The number of days between the student's birthdate and the date of the first fifth dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate5date minus student.birthdate
DT 6

immunization.code = DT
The number of days between the student's birthdate and the date of the first sixth dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate6date minus student.birthdate
DT 7

immunization.code = DT
The number of days between the student's birthdate and the date of the seventh DT dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate7date minus student.birthdate
DT 8

immunization.code = DT
The number of days between the student's birthdate and the date of the eighth DT dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate8date minus student.birthdate
DT 9

immunization.code = DT
The number of days between the student's birthdate and the date of the ninth DT dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate9date minus student.birthdate
DT 10

immunization.code = DT
The number of days between the student's birthdate and the date of the tenth DT dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate10date minus student.birthdate
Td 1

immunization.code = Td
The number of days between the student's birthdate and the date of the first Td dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate1date minus student.birthdate
Td 2

immunization.code = Td
The number of days between the student's birthdate and the date of the second Td dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate2date minus student.birthdate
Td 3

immunization.code = Td
The number of days between the student's birthdate and the date of the third Td dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate3date minus student.birthdate
Td 4

immunization.code = Td
The number of days between the student's birthdate and the date of the fourth Td dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate4date minus student.birthdate
Td 5

immunization.code = Td
The number of days between the student's birthdate and the date of the fifth Td dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate5date minus student.birthdate
Td 6

immunization.code = Td
The number of days between the student's birthdate and the date of the sixth Td dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate6date minus student.birthdate
Td 7

immunization.code = Td
The number of days between the student's birthdate and the date of the seventh Td dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate7date minus student.birthdate
Td 8

immunization.code = Td
The number of days between the student's birthdate and the date of the eighth Td dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate8date minus student.birthdate
Td 9

immunization.code = Td
The number of days between the student's birthdate and the date of the ninth Td dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate9date minus student.birthdate
Td 10

immunization.code = Td
The number of days between the student's birthdate and the date of the tenth Td dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate10date minus student.birthdate
Measles 1

immunization.code = Measles
The number of days between the student's birthdate and the date of the first Measles dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate1date minus student.birthdate
Measles 2

immunization.code = Measles
The number of days between the student's birthdate and the date of the second Measles dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate2date minus student.birthdate
Measles 3

immunization.code = Measles
The number of days between the student's birthdate and the date of the third Measles dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate3date minus student.birthdate
Measles 4

immunization.code = Measles
The number of days between the student's birthdate and the date of the fourth Measles dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate4date minus student.birthdate
Measles 5

immunization.code = Measles
The number of days between the student's birthdate and the date of the fifth Measles dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate5date minus student.birthdate
Measles 6

immunization.code = Measles
The number of days between the student's birthdate and the date of the sixth Measles dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDat60date minus student.birthdate
Measles 7

immunization.code = Measles
The number of days between the student's birthdate and the date of the seventh Measles dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate7date minus student.birthdate
Measles 8

immunization.code = Measles
The number of days between the student's birthdate and the date of the eighth Measles dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate8date minus student.birthdate
Measles 9

immunization.code = Measles
The number of days between the student's birthdate and the date of the ninth Measles dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate9date minus student.birthdate
Measles 10

immunization.code = Measles
The number of days between the student's birthdate and the date of the tenth Measles dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate10date minus student.birthdate
Mumps 1

immunization.code = Mumps
The number of days between the student's birthdate and the date of the first Mumps dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate1date minus student.birthdate
Mumps 2

immunization.code = Mumps
The number of days between the student's birthdate and the date of the second Mumps dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate2date minus student.birthdate
Mumps 3

immunization.code = Mumps
The number of days between the student's birthdate and the date of the third Mumps dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate3date minus student.birthdate
Mumps 4

immunization.code = Mumps
The number of days between the student's birthdate and the date of the fourth Mumps dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate4date minus student.birthdate
Mumps 5

immunization.code = Mumps
The number of days between the student's birthdate and the date of the fifth Mumps dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate5date minus student.birthdate
Mumps 6

immunization.code = Mumps
The number of days between the student's birthdate and the date of the sixth Mumps dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate6date minus student.birthdate
Mumps 7

immunization.code = Mumps
The number of days between the student's birthdate and the date of the seventh Mumps dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate7date minus student.birthdate
Mumps 8

immunization.code = Mumps
The number of days between the student's birthdate and the date of the eighth Mumps dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate8date minus student.birthdate
Mumps 9

immunization.code = Mumps
The number of days between the student's birthdate and the date of the ninth Mumps dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate9date minus student.birthdate
Mumps 10

immunization.code = Mumps
The number of days between the student's birthdate and the date of the tenth Mumps dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate10date minus student.birthdate
Rubella 1

immunization.code = Rubella
The number of days between the student's birthdate and the date of the first Rubella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate1date minus student.birthdate
Rubella 2

immunization.code = Rubella
The number of days between the student's birthdate and the date of the second Rubella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate2date minus student.birthdate
Rubella 3

immunization.code = Rubella
The number of days between the student's birthdate and the date of the third Rubella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate3date minus student.birthdate
Rubella 4

immunization.code = Rubella
The number of days between the student's birthdate and the date of the fourth Rubella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate4date minus student.birthdate
Rubella 5

immunization.code = Rubella
The number of days between the student's birthdate and the date of the fifth Rubella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate5date minus student.birthdate
Rubella 6

immunization.code = Rubella
The number of days between the student's birthdate and the date of the sixth Rubella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate6date minus student.birthdate
Rubella 7

immunization.code = Rubella
The number of days between the student's birthdate and the date of the seventh Rubella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate7date minus student.birthdate
Rubella 8

immunization.code = Rubella
The number of days between the student's birthdate and the date of the eighth Rubella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate8date minus student.birthdate
Rubella 9

immunization.code = Rubella
The number of days between the student's birthdate and the date of the ninth Rubella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate9date minus student.birthdate
Rubella 10

immunization.code = Rubella
The number of days between the student's birthdate and the date of the tenth Rubella dose administered.

Numeric
Student > Health > Immunizations; Census > People > Demographics > Birth Date

Calculated value = immunization.doseDate10date minus student.birthdate

Report Examples

Screenshot of a state upload format example.State Upload FormatScreenshot of an HTML report example.HTML FormatScreenshot of a CSV report example.CSV Format


Previous Versions

CO Digital Upload PreK (Colorado) [.2307 and previous]