|
Name |
|
|
Dimensional Type |
Fact |
|
Comment |
This dimension, MF_FacultyNonTeachingAssignment, records faculty membership on boards, committees, etc., as well as 'membership' in pseudo-commmittees. The grain is one row per faculty member, per non-teaching assignment, per term. |
|
CKT_MF_FACULTYNONTEACHINGASSIG |
|
Name |
Parent Table |
Foreign Key Columns |
|
Reference_5 |
MD_CollPers_SurrogateKey |
|
|
Relationship_4 |
MD_CarlOrg_SurrogateKey |
|
|
Relationship_5 |
MD_CollPers_SurrogateKey |
|
|
Relationship_40 |
MD_CarlTerm_SurrogateKey |
|
Name |
Code |
|
Name |
|
Name |
Comment |
Domain |
Data Type |
Length |
|
MD_CarlOrg_SurrogateKey |
|
<None> |
numeric |
|
|
MD_CollPers_SurrogateKey |
|
<None> |
numeric |
|
|
MD_CarlTerm_SurrogateKey |
|
<None> |
numeric |
|
|
MF_NonTeachAsgn_PersCollID |
Personal Colleague ID (not the same as the Colleague ID, i.e., the unique identifier, designating a relationship between an activity and a person). |
DW_ColleagueID |
char(7) |
7 |
|
MF_NonTeachAsgn_ColleagueID |
Key tying a person to an organization in Colleague. It comes in at the wrong grain for us to use it as an alternate key here, though, since this value remains the same if a person serves, e.g., on the same committee multiple times. |
DW_CodeDescShort |
varchar(16) |
16 |
|
MF_NonTeachAsgn_Workload |
Name of committee. |
<None> |
float |
|
|
MF_NonTeachAsgn_StartDate |
Do not expose to users. Maintained purely for checking/auditing purposes, carried over from the underlying Colleague file. |
<None> |
datetime |
|
|
MF_NonTeachAsgn_EndDate |
Do not expose to users. Maintained purely for checking/auditing purposes, carried over from the underlying Colleague file. |
<None> |
datetime |
|
|
MF_NonTeachAsgn_IsLeave |
|
DW_YesOrNoNOTNULL |
char(3) |
3 |
|
MF_NonTeachAsgn_IsPaid |
|
DW_YesOrNoNOTNULL |
char(3) |
3 |
|
MF_NonTeachAsgn_AuditKey |
|
DW_AuditKey |
bigint |
|
|
MF_NonTeachAsgn_Timestamp |
|
<None> |
timestamp |
|
|
Name |
Unique |
Cluster |
Primary |
Foreign Key |
Alternate Key |
Table |
|
MF_FACULTYNONTEACHINGASSIGNMENT_PK |
TRUE |
FALSE |
TRUE |
FALSE |
FALSE |
|
Name |
|
Identifier_1 |
|
|
|