|
Name |
|
|
Comment |
Fact table-view that reflects the many-to-many relationship between majors and degree students. |
|
Dimensional Type |
Fact |
|
select |
|
Name |
Parent Table/View |
|
ViewReference_102 |
|
|
ViewReference_104 |
|
Name |
|
Name |
Code |
Type |
Target Package |
|
View |
|
Name |
|
Grant |
User |
|
SELECT,VIEW DEFINITION |
AcadRecordReader |
|
Name |
Data Type |
Comment |
Length |
|
MD_CollPers_SurrogateKey |
numeric |
|
|
|
MD_Major_SurrogateKey |
numeric |
|
|
|
MF_Major_Count |
int |
DO NOT EXPOSE THIS TO USERS, because it doesn't count anything they'd probably consider useful. It counts the number of rows in MD_DEGREESTUDENT with a valid major 1 + the number of rows with a valid major 2 + the number of rows with a valid major 3, etc. |
|
|
|
|