Data Pipeline EDIS Export (Colorado)

Tool Search: EDIS Export

The Data Pipeline EDIS Export allows districts to review State Education IDs. This extract can be used in conjunction with the EDIS/RITS Import Tool.

Screenshot of the EDIS Export in Reporting, CO Data Pipeline. EDIS Export

Read - Access and generate Data Pipeline EDIS Export.
Write - N/A
Add - N/A
Delete - N/A

For more information about Tool Rights and how they function, see the Tool Rights article. 

Report Logic

One record reports for any staff member who has an active District Employment record based on the selection (active, inactive, or all) in the extract editor.The staff member must have an active District Assignment record for the school selected on the extract editor.

Records are matched using the state locator extract based on the Person ID. If Campus is missing or has a different State ID value, the value from the import file updates the Campus value.

Non-Binary Gender Reporting

Schools can assign students a gender of M: Male, F: Female or N: Non-binary. This is done on the Identities tool and/or the Demographics tool. 

Data Pipeline Extracts and other required extracts use the Legal Gender field included in the Protected Identity Information to report student identity information.

To properly record a gender of N: Non-Binary, on the Identities tool:

  1. Assign the Gender of N: Non-Binary in the standard identify fields.
  2. Assign the Protected Identity Information Legal Gender field to M: Male, F: Female or N: Non-Binary.
  3. Save the record when finished.

Screenshot of the Gender and Legal Gender fields on the Census, People, Identities record. Gender and Legal Gender Assignment

Report Editor

The following fields are available for selection.

FieldDescription
Effective DateStaff employment records within the selected calendar(s) as of this date are included in the extract.
FormatSelection indicates how the extract generates, either in CSV or HTML format.
Staff without EDIDsWhen marked, only staff who are not currently assigned a staff ID are included in the report.
Active/InactiveAllows users to include or exclude staff from reporting based on whether or not they have an active or inactive employment record as of the Effective Date entered in the selected school.
School SelectionSelection indicates from which school staff data reports. At least one school needs to be selected.
Report GenerationThe extract 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 Report

  1. Enter the Effective Date of the report.
  2. Select the desired Format.
  3. If only those staff members who do not have staff IDs should be included in the report, mark the Staff without EDIDs checkbox.
  4. Select the school(s) from which to report the data.
  5. Click the Generate Extract button or use the Submit to Batch button. The report displays in the selected format.

Screenshot of the CSV Format of the EDIS Export.EDIS Export, CSV Format

Screenshot of the HTML Format of the EDIS Export. EDIS Export, HTML Format

Report Layout

Data ElementDescriptionLocation
EDIDReports the unique state educator ID Number.

Numeric, 8 digits
Demographics > Person Identifiers > Staff State ID

Person.staffStateID
SSNReports the educator's Social Security number.

Numeric, 9 digits
Demographics > Soc Sec Number

Identity.SSN
District CodeReports the state district number of where the educator has a district assignment or employment record.

Numeric, 4 digits
District Information > State District Number

District.stateDistrictNumber
LAEDIDReports the locally assigned staff number.

Numeric, 10 digits
Demographics > Person Identifiers > Local Staff Number

Person.localStaffNumber
Last Name

Reports the educator's last name.


When the Report Legal Name checkbox is marked, the Last Name reports from the Legal Last Name field.


Alphanumeric, 30 characters

Demographics > Person Information > Last Name


Identity.lastName


Identities > Protected Identity Information > Legal Last Name


Identity.legalLastName

First Name

Reports the educator's first name.


When the Report Legal Name checkbox is marked, the First Name reports from the Legal First Name field.


Alphanumeric, 30 characters

Demographics > Person Information > First Name


Identity.firstName


Identities > Protected Identity Information > Legal First Name


Identity.legalFirstName

Middle Name

Reports the educator's middle name.


When the Report Legal Name checkbox is marked, the Middle Name reports from the Legal Middle Name field.


Alphanumeric, 30 characters

Demographics > Person Information > Middle Name


Identity.middleName


Identities > Protected Identity Information > Legal Middle Name


Identity.legalMiddleName

Birth DateReports the educator's birth date.

Date field, 8 characters (MMDDYYYY)

Demographics > Person Information > Birth Date

Identity.birthDate
Gender

Reports the educator's gender.

  • 01 - Female
  • 02 - Male
  • 03 - Non-binary

When the Report Legal Name checkbox is marked, the Gender reports from the Legal Gender field. 


Numeric, 2 digits

Demographics > Person Information > Gender


Identity.gender


Identities > Protected Identity Information > Legal Gender


Identity.legalGender