name, you would retrieve multiple rows because the addition of the instructor name would make each line different.) Scroll down to the bottom of the screen and you will see the fields you selected in a box the – IUIE will order the columns in your output in the same order as they are stored in the data warehouse. It is easier to re-arrange your columns in the Advanced area than to wait for the output and re-arrange columns in an Excel file. Highlight the field that is listed last in this box and select Selection Up” to see how the order changes. “Move SUMMARY The best way to learn more about the IUIE is by actually running queries yourself. Don’t forget to use the Catalog” option it will save time. “Search – Clicking on the name of the report will give you more information about the query or table. Clicking on the names of the fields will link you to more information about the data in the fields, including the technical name of the field, possible metadata that explains more about the field, and what other tables contain this field. Clicking on the Values” button will allow you to select only the values you want. “Valid If you are not sure exactly what data is found in each field, print values for all fields using one of your own students (or yourself) as a and then comparing the output with “test” known values in SIS. Use the button (when using data extracts) to add additional criteria. This will “Advanced” allow you to limit your population so you don’t have as much editing when you get output. But everything in the Criteria” box has to be written in SQL using the technical “Additional names of the fields. The bio” data extracts run more quickly than the other data extracts. “no Limiting the number of records will the queries to run faster so you can refine your query before running the entire report, but don’t forget to take the limit off before running your final query.
name, you would retrieve multiple rows because the addition of the instructor name would make each line different.) Scroll down to the bottom of the screen and you will see the fields you selected in a box – the IUIE will order the columns in your output in the same order as they are stored in the data warehouse. It is easier to re-arrange your columns in the Advanced area than to wait for the output and re-arrange columns in an Excel file. Highlight the field that is listed last in this box and select “Move Selection Up” to see how the order changes. SUMMARY The best way to learn more about the IUIE is by actually running queries yourself. Don’t forget to use the “Search Catalog” option – it will save time. Clicking on the name of the report will give you more information about the query or table. Clicking on the names of the fields will link you to more information about the data in the fields, including the technical name of the field, possible metadata that explains more about the field, and what other tables contain this field. Clicking on the “Valid Values” button will allow you to select only the values you want. If you are not sure exactly what data is found in each field, print values for all fields using one of your own students (or yourself) as a “test” and then comparing the output with known values in SIS. Use the “Advanced” button (when using data extracts) to add additional criteria. This will allow you to limit your population so you don’t have as much editing when you get output. But everything in the “Additional Criteria” box has to be written in SQL using the technical names of the fields. The “no bio” data extracts run more quickly than the other data extracts. Limiting the number of records will the queries to run faster so you can refine your query before running the entire report, but don’t forget to take the limit off before running your final query.
IUIE-student-records-training.docx