The TSDS Extract Field Defaults screen displays a list of fields submitted in the TSDS extracts, along with the table name and field number from which the data is extracted. If set up, the field’s default value also displays; this is also dependent upon whether there is extract logic used when extracting the value of the field for reporting to the state.
1. From the Texas Reports menu, click TSDS Extract Field Defaults.
This navigates to the TSDS Extract Field Defaults screen. A list of the TSDS extracts display, along with the applicable fields and extract information.
2. Click on any of the extracts along the left side of the screen to review data for that extract.
The report displays the Field Name, Table, Custom Field Number, Default, and Extract Logic.
The Table and Custom Field Number columns display the database table and field pulled.
The Default column displays what is set on the Student Fields screen as the State Reporting Fallback Value.
The Extract Logic column displays the logic that will be used at the time of extract if the system finds blanks or if there is a state defined default.
Utilize the Search text box at the top of the extracts panel by typing the name of an extract to quickly navigate from one extract to another.
To close the panel, click the X. Doing so will allow for more room on the screen, which will be helpful when viewing extract data. To make the panel reappear, click the arrow where the panel used to display.
To export the listed extract data to an Excel spreadsheet, click the floppy disk icon.
To filter the listed data, enter a search term in the Search text box above the table and press Enter.
Data can be organized by clicking on any of the headers, such as Field Name or Table; click once for ascending results; click twice for descending results. In the image shown, Field Name was clicked twice; therefore, Field Name results start at the end of the alphabet.
