The EdReflect Offboarding Data Product is used by organizations as a way to save a copy of raw data stored in the EdRefect platform. This product is shared with organizations as part of the offboarding process.
This table summarizes the files included in the EdReflect Offboarding Data Product. The data product must be accesses via sftp. Each File Group contains one or more .csv files (called ‘Tables’ below). Each .csv file contains field definitions. Please see the example below:
For a complete set of field definitions for each file, please access your data product. Contact support@edreflect.com with questions about how to access or if you need to be directed to a member of our product team for assistance.
Offboarding Data Product Summary Table
|
File Group Name
|
Description
|
|
artifacts
|
Table details artifacts uploaded into the system
|
|
assignments
|
5 tables detailing system assignments for users: (1) assignments, (2) assignments.learners, (3) assignments.observers, (4) assignments.learnerGroups, (5) assignments.observerGroups
|
|
eoy.Classifications
|
Table details classifications used for End-of-Year tool
(NOTE: only applicable for organizations using the EdReflect End-of- Year Tool).
|
|
evidences
|
3 tables detailing collected evidence for learners: (1) evidence metadata, (2) evidence aligned to goals, (3) evidence aligned to rubric indicators
|
|
goals
|
8 tables detailing goals data:
(1) goals (2) alignedIndicators (3) goal comments (4) goal comment replies (5) goal posts (6) goal post attachments (7) goal questions (8) goal users
(NOTE: only application for organizations that use EdReflect’s Goals tools)
|
|
groups
|
4 tables detailing groups data:
(1) groups (2) reports groups (3) roles groups (4) rubric groups
|
|
observationTemplates
|
9 tables detailing observations metadata:
(1) Observation Templates (2) Observation Template activities (3) Observation Template activities aligned indicators (4) Observation Template activity steps (5) Observation Template activity step forms (6) Observation Template activity step form elements (7) Observation Template activity step form element choices (8) Observation Template learner group limits (9) Observation Template observer group limits
|
|
observations
|
15 tables detailing observations data:
(1) Observations (2) Activity meeting notes (3) Activity meeting notes content (4) Read Only Observers (5) Observation work (6) Observation work evaluations (7) Observation work evaluation indicators (8) Observation work evaluation indicators comments (9) Observation work evaluation indicators proficiency level subitem index (10) Observations work steps (11) Observations work step artifacts (12) Observations work step evidences (13) Observation work step form elements (14) Observation work step snapshots (15) Observation work step status messages
|
|
ratings
|
4 tables detailing ratings data:
(1) Ratings metadata (2) Sets of ratings on a specific rubric (3) Actual selected ratings (4) Ratings Proficiency Level Subitems Indexes
|
|
rubrics
|
7 tables detailing rubrics data:
(1) Rubric metadata (2) Rubric proficiency levels (3) Rubric standards (4) Rubric indicators (aka domains) (5) Rubric indicator indicators (6) Rubric indicator indicators proficiency levels (7) Rubric standards indicators proficiency levels
(NOTE: Indicators ++ Indicators are recursive and can be 4 levels deep, but will follow the conventions above. You can store them flatly with a level field equal to the number of indicators strings in the csv title, or you can create a table for each level.)
|
|
sloTemplates
|
4 tables detailing SLO templates:
(1) SLO templates metadata (2) SLO templates sections (3) SLO template section elements (4) SLO template section elements choices
(NOTE: only applicable for organizations using EdReflect’s SLO tool)
|
|
slos
|
10 tables detailing users' SLOs:
(1) SLOs (2) SLO answers (3) SLO answer assessments (4) SLO answer assessments measures (5) SLO answer assessment measures multiple values (6) SLO answers assessment ratings (7) SLO answers details (i.e. content) (8) SLO answers details multiple values (9) SLO answer identifiers (10) SLO answers identifiers multiple values3
|
|
snapshots
|
3 tables detailing snapshots data:
(1) Snapshots metadata (2) Snapshots activity works (3) Snapshots indexes
|
|
users
|
9 tables detailing user data:
(1) users (2) users BloomList items (3) users BloomList reflections (4) users content areas (from profile page) (5) users files (6) users grades (from profile page) (7) users groups (8) users roles (9) users subOrgs
|
This article is available as a PDF download below to share with your organization's IT or Data team to assist with setting up the EdReflect Offboarding Data Product.
Comments
0 comments
Article is closed for comments.