Reporting Data exports: Reading Minutes

The Reporting Data screen shows several export options. This article covers the exports related to participant Reading Minutes.

1. Select the highest organization or group of interest in the context menu.

If you select an organization (bold header in the hierarchy), the export will pull Reading Minutes records for all children in that organization and in any nested suborganizations within it. 

To access data for an inactive/completed group or child, select the organization the group or child was in. You will be able to filter to see just the desired group or participants in later steps.

2. From the main menu, expand the Data section and select Data Exports.

3. Choose the Reporting Data tab.

4. Filter by date range and/or participant (optional)

Leave both Database Insert Date and Transaction Date blank to export data for all dates for the selected context and/or participant.

5. Click Reading Minutes button at bottom of screen.

The CSV file that downloads can be opened in Excel or other spreadsheet program for analysis.

List of exported fields and descriptions

Field Description
DateCompleted Date the caregiver reported the minutes
Child's chronological age on date completed, expressed in months
ExcludedFromStarCalcs FALSE = Regular reading minutes, included in star calculations
TRUE = Reading minutes from Snapshot, not included in star calculations
ProgramType LENA program the child is in (Grow, Home, Snapshot, SP, Start)
OrgID LENA database ID number for participant’s organization
GroupID LENA database ID number for participant’s functional group
RMGroupID LENA database ID number for the group the participant was in when these minutes were reported.
Usually = GroupID; will differ if child has been moved between groups.
ParticipantID LENA database ID number for participant
Participant External Reference ID
LENA database ID number for these reported minutes
DatabaseInsertDateTime Local date and time the minutes info was committed to LENA Online database; aligned to time zone of participant’s organization