Operational data exports: Organizations

The Organizations export returns information on all organizations and suborganizations in the selected context.

This export is available to any LENA user with account administrator or view org permissions.

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

2. From the main menu, expand the Data section, select Data Exports, and then choose the Operational Data tab.

(Note: Your list of tabs may be different, as available options differ by LENA program type.)

3. Filter by date range (optional).

Leave dates blank to export all data.

4. Click the Organization button at the bottom of the screen.

The exported CSV can be opened as a spreadsheet in Excel.

Click here for a list of exported fields and their descriptions.
Field
Description
OrgID
Organization's LENA Online database ID number
ParentOrg ID number of the organization within which this org is located
OrgName Name of organization
Active Indicates whether this organization is active or inactive
ProgramType Organization's LENA program type
ExcludeFromAnalysis Indicates whether the organization's data has been flagged for exclusion from LENA's internal analyses (e.g., test data, training data, etc.)
DatabaseInsertDateTime Date and time when the org was added to the system