View VMD_CarletonOrganization

Card of view VMD_CarletonOrganization

Name

VMD_CarletonOrganization

Comment

See documentation on MD_CarletonOrganization in the ViewsFaculty package.

The main reason for having this table in the warehouse is to facilitate faculty non-course-related workload reporting.

Dimensional Type

Dimension


SQL query of the view VMD_CarletonOrganization

select
MD_CarlOrg_SurrogateKey,
MD_CarlOrg_ColleagueID,
MD_CarlOrg_Name
from
MD_CARLETONORGANIZATION


List of incoming view references of the view VMD_CarletonOrganization

Name

Child Table/View

ViewReference_97

VMF_FacultyNonTeachingAssignment


List of referenced objects of the view VMD_CarletonOrganization

Name

MD_CarletonOrganization


List of diagrams containing the view VMD_CarletonOrganization

Name

ViewsFacultyDiagram


List of permissions of the view VMD_CarletonOrganization

Grant

User

SELECT,VIEW DEFINITION

FacultyReader


List of view columns of the view VMD_CarletonOrganization

Name

Data Type

Comment

Length

MD_CarlOrg_SurrogateKey

numeric

 

 

MD_CarlOrg_ColleagueID

char(5)

 

 

MD_CarlOrg_Name

varchar(64)

 

 


Previous
Home
Next