FAQs

This list of frequently asked questions is designed to answer common questions related to the SIS data warehouse. If you wish to post to the SIS data warehouse FAQs, please send your questions or comments to john.alton [at] mcgill.ca (John Alton).

1. I am having a problem connecting to the SIS data warehouse, who should I contact for help?
2. I would like to get training on how to use Crystal Reports, who should I contact for help?
3. I am having a problem with the query that I am writing, who should I contact for help?
4. I have a question about the data that I see who should I contact for help?
5. I don't understand what is wrong with the query that I am writing, who should I contact for help?
6. My query is becoming too complicated, who should I contact for help?
7. I would like to have a new column or view created, who should I contact for help?
8. Where do I find the SIS data warehouse?
9. What do I need to access the SIS data warehouse?
10. What is the SIS data warehouse?
11. Where do I find information on the columns?
12. Where can I get a description of the columns?
13. What are that columns that I see?
14. What is the difference between the views with the suffix "CURR_TERM" and the regular academic and course views?
15. Where do I see pre-banner (legacy) data?
16. What legacy data was converted?
17. What is the difference between the columns with "CODE" and the columns with similar names with out the "CODE" suffix?
18. What is the difference between the "TERM_CODE_KEY" and the "TERM_CODE"?
19. Why am I seeing the same student many times?
20. How do I find students who have applied to graduate?
21. I am not getting a complete listing when I run my query in Crystal Reports?