Dict-Physical

Table MF_CommitteeParticipation

Card of table MF_CommitteeParticipation

Name	MF_CommitteeParticipation
Dimensional Type	Fact
Comment	Fact table holding committee-participation information for employees. Grain is one row per employee per committee per term. Although staff/regular employees may participate on committees, their participation isn't considered part of their workload in the same way that it is for faculty, and we don't base workload calculations and key performance metrics on it. As a result, if you do reporting based on this table, you should typically exclude non-faculty. Reporting should generally not be done on the start and end date fields included in this table (but not exposed in views). They are mainly used for internal bookkeeping and validation.

Check constraint name of the table MF_CommitteeParticipation

CKT_MF_COMMITTEEPARTICIPATION

List of outgoing references of the table MF_CommitteeParticipation

Relationship_39

MD_Employee (Shortcut)

MD_CollPers_SurrogateKey

Relationship_41

MD_CarlTerm (Shortcut)

MD_CarlTerm_SurrogateKey

List of diagrams containing the table MF_CommitteeParticipation

StarsEmployeeDiagram

List of columns of the table MF_CommitteeParticipation

MD_CollPers_SurrogateKey

<None>

numeric

MD_CarlTerm_SurrogateKey

<None>

numeric

MF_ComPart_StartDateInteger

Start date of participation instance. E.g., if a faculty member participates continuously on Admin Council for three terms, then all three records for these terms will have a start date of whenever the participation began. It's all considered to be one participation instance.

This field is typically not used for reporting, because it implies a different grain than the grain of this table, which is one row per term per committee per employee. The start date field implies a grain of one row per participation instance per committee per employee. This can be confusing for users.

DW_DateInteger

int

MF_ComPart_EndDateInteger

End date of participation instance. E.g., if a faculty member participates continuously on Admin Council for three terms, then all three records for these terms will have an end date of whenever the participation stopped (i.e., the same end date). It's all considered to be one participation instance.

This field is typically not used for reporting, because it implies a different grain than the grain of this table, which is one row per term per committee per employee. The end date field implies a grain of one row per participation instance per committee per employee. This can be confusing for users.

DW_DateInteger

int

MF_ComPart_Count

<None>

int

MF_ComPart_AuditKey

DW_AuditKey

bigint

MF_ComPart_Timestamp

<None>

timestamp

List of indexes of the table MF_CommitteeParticipation

MF_COMMITTEEPARTICIPATION_PK

TRUE

FALSE

MF_CommitteeParticipation

List of keys of the table MF_CommitteeParticipation

Identifier_1

Home