Many of the columns in the SIS data warehouse are paired, one contains the code and the other contains a description. When a column is paired in such a fashion, you should use the code for your selection criteria. You can use the description field in your report if you will be showing it to people who are not familiar with the codes.
| E.g. | |
| PRIM_FACULTY_CODE: | AR, CE, DE, etc. |
| PRIM_FACULTY: | Faculty of Arts, Centre for Continuing Ed, Faculty of Dentistry, etc. |
| PRIM_MAJOR1_CODE: | DNT, PFF, SMD, etc. |
| PRIM_MAJOR1: | Dentistry, Proficiency in French, Sports Medicine, etc. |
| PRIM_DEGREE_CODE: | BSC, C-PRFR, LLB, etc. |
| PRIM_DEGREE: | Bachelor of Science, Cert Proficiency in French, Bachelor of Laws, etc. |
To help you decipher the information contained in the SIS data warehouse, a series of documents have been created with descriptions of the columns and examples of the data in which they contain. Follow this link to go to the documentation site.