FAQs – Early Adopters – General

See also FAQs – Early Adopters – Technical Support 

TSDS Overview

What additional costs will be associated with TSDS implementation?

LEAs should ask their ESC and source system vendors for pricing information.

In the TSDS model there is reference to "ETL." What does that mean?

Extract, Transform, Load: a system for moving data from one data repository to another.

Unique ID

Are we going to be able to delete batch files for Unique ID?

Deleting a batch file can only be done before the assignment phase. You can retire Unique IDs, which will propagate to the EDIT+ PID system.

Are we going to be able to delete batch files for TSDS PEIMS (raw data)?

Yes, batch files can be deleted from the Operational Data Store (ODS) using the delete utility.

Data Loading

Will the data loads involve an overnight process where our SIS extracts data and sends via FTP, or do we build a batch file and upload?

This functionality will be specific to the source system vendor. Please check with your vendor.

Is it up to the LEAs to schedule their loads?

Yes. The LEAs may schedule their loads daily, weekly, or monthly. Loads may also be scheduled on-demand.

Will the file upload process be both manual and automated?

Yes. The LEA may schedule their loads daily, weekly, or monthly. Loads may also be scheduled on-demand.

Does the data file which is picked up by the DTU stay on the LEA server after it is grabbed?

Yes, when the Data Transfer Utility (DTU) picks up the file, it creates a date/time archive folder and adds the file to this folder. These files will be kept for a configured period of time.