Package StarsEmployee

Diagram StarsEmployeeDiagram

List of outgoing references of the table MF_PositionFunding List of outgoing references of the table MF_BenefitEmployeeContribution List of outgoing references of the table MF_BenefitCarletonContribution List of References in Diagram List of incoming references of the table MD_Benefit List of outgoing references of the table MF_BenefitCost List of incoming references of the table MD_LeaveInfo List of incoming references of the table MD_Position List of incoming references of the table MD_CarletonDepartment List of outgoing references of the table MF_BenefitDates List of incoming references of the table MD_EmployeeStatus List of outgoing references of the table MF_PerPosition Table MF_BenefitEmployeeContribution Table MF_BenefitCarletonContribution Table MD_EmployeeStatus Table MF_CommitteeParticipation Table MD_LeaveInfo Table MD_CarlTerm Table MD_CarletonDepartment Table MF_LeaveAccrual Table MD_Benefit Table MF_BenefitDates Table MF_PositionFunding Table MF_BenefitCost Table MF_PerPosition Table MD_GLAccount Table MD_Date Table MD_Position Table MD_Employee
StarsEmployeeDiagram

Card of Diagram StarsEmployeeDiagram

Name

StarsEmployeeDiagram

Comment

Dimensions and facts relating to people and positions, for us in demographic analysis of the workforce, open/filled positions, compa ratios, and so on.


List of Tables in Diagram

Name

Creation Date

Dimensional Type

Class Name

MD_Benefit

Friday, January 15, 2010 12:10:28 PM

Dimension

Shortcut of table

MD_CarletonDepartment

Friday, February 26, 2010 11:50:32 AM

Dimension

Shortcut of table

MD_CarlTerm

Monday, September 14, 2009 2:24:37 PM

Dimension

Shortcut of table

MD_Date

Monday, September 14, 2009 2:24:37 PM

Dimension

Shortcut of table

MD_Employee

Monday, September 14, 2009 2:24:37 PM

Dimension

Shortcut of table

MD_EmployeeStatus

Friday, February 26, 2010 11:54:47 AM

Dimension

Shortcut of table

MD_GLAccount

Monday, January 18, 2010 1:44:20 PM

Dimension

Shortcut of table

MD_LeaveInfo

Thursday, January 13, 2011 10:36:59 AM

Dimension

Shortcut of table

MD_Position

Wednesday, November 25, 2009 3:40:05 PM

Dimension

Shortcut of table

MF_BenefitCarletonContribution

Thursday, January 13, 2011 10:36:59 AM

Fact

Table

MF_BenefitCost

Friday, January 15, 2010 12:10:28 PM

Fact

Table

MF_BenefitDates

Friday, January 15, 2010 12:10:28 PM

Fact

Table

MF_BenefitEmployeeContribution

Thursday, January 13, 2011 10:36:59 AM

Fact

Table

MF_CommitteeParticipation

Monday, September 14, 2009 2:24:37 PM

Fact

Table

MF_LeaveAccrual

Thursday, January 13, 2011 10:36:59 AM

Fact

Table

MF_PerPosition

Wednesday, November 25, 2009 3:40:05 PM

Fact

Table

MF_PositionFunding

Monday, January 18, 2010 1:44:20 PM

Fact

Table


List of References in Diagram

Name

Parent Table

Child Table

Foreign Key Columns

Relationship_39

MD_Employee (Shortcut)

MF_CommitteeParticipation

MD_CollPers_SurrogateKey

Relationship_41

MD_CarlTerm (Shortcut)

MF_CommitteeParticipation

MD_CarlTerm_SurrogateKey

Relationship_42

MD_Employee (Shortcut)

MF_PerPosition

MD_CollPers_SurrogateKey

Relationship_43

MD_Position (Shortcut)

MF_PerPosition

MD_Pos_SurrogateKey

Relationship_62

MD_Employee (Shortcut)

MF_BenefitDates

MD_CollPers_SurrogateKey

Relationship_63

MD_Benefit (Shortcut)

MF_BenefitDates

MD_Benefit_SurrogateKey

Relationship_64

MD_Date (Shortcut)

MF_BenefitDates

MD_Date_DateInteger

Relationship_65

MD_Benefit (Shortcut)

MF_BenefitCost

MD_Benefit_SurrogateKey

Relationship_66

MD_Employee (Shortcut)

MF_BenefitCost

MD_CollPers_SurrogateKey

Relationship_67

MD_Date (Shortcut)

MF_BenefitCost

MD_BenCost_StartDate

Relationship_68

MD_Employee (Shortcut)

MF_PerPosition

MD_CollPers_SupervisorKey

Relationship_71

MD_Position (Shortcut)

MF_PositionFunding

MD_Pos_SurrogateKey

Relationship_72

MD_GLAccount (Shortcut)

MF_PositionFunding

MD_GLAcc_SurrogateKey

Relationship_75

MD_CarletonDepartment (Shortcut)

MF_PerPosition

MD_CarlDept_SurrogateKey

Relationship_76

MD_EmployeeStatus (Shortcut)

MF_PerPosition

MD_EmpStat_SurrogateKey

Relationship_146

MD_Benefit (Shortcut)

MF_BenefitEmployeeContribution

MD_Benefit_SurrogateKey

Relationship_147

MD_Employee (Shortcut)

MF_BenefitEmployeeContribution

MD_CollPers_SurrogateKey

Relationship_148

MD_Employee (Shortcut)

MF_BenefitCarletonContribution

MD_CollPers_SurrogateKey

Relationship_149

MD_Benefit (Shortcut)

MF_BenefitCarletonContribution

MD_Benefit_SurrogateKey

Relationship_150

MD_LeaveInfo (Shortcut)

MF_LeaveAccrual

MD_LeaveInfo_SurrogateKey

Relationship_151

MD_Employee (Shortcut)

MF_LeaveAccrual

MD_CollPers_SurrogateKey

Relationship_152

MD_Date (Shortcut)

MF_BenefitEmployeeContribution

MD_Date_DateInteger

Relationship_153

MD_Date (Shortcut)

MF_BenefitCarletonContribution

MD_Date_DateInteger

Relationship_154

MD_Date (Shortcut)

MF_LeaveAccrual

MD_Date_DateInteger