Table MD_LeaveInfo

Card of table MD_LeaveInfo

Name

MD_LeaveInfo

Dimensional Type

Dimension

Comment

People go on leave for various reasons. There is sick leave, vacation, etc. This dimension catalogs the various leave plan types (vacation, sick, etc.), leave codes (Bi-weekly vacation accrual, Funeral sick leave, etc.), and leave actions (adjust, accrue, use, etc.).

Leave plan types, codes, and actions are all lumped together because there aren't a lot of actively used unique combinations of these three things at Carleton (as of March 2011 there are 49, actually). So there is no need for separate dimensions.


Check constraint name of the table MD_LeaveInfo

CKT_MD_LEAVEINFO


List of incoming references of the table MD_LeaveInfo

Name

Child Table

Foreign Key Columns

Relationship_150

MF_LeaveAccrual

MD_LeaveInfo_SurrogateKey


List of referencing views of the table MD_LeaveInfo

Name

Code

VMD_LeaveInfo

VMD_LEAVEINFO


List of diagrams containing the table MD_LeaveInfo

Name

DimsEmployeeDiagram


List of columns of the table MD_LeaveInfo

Name

Comment

Domain

Data Type

Length

MD_LeaveInfo_SurrogateKey

 

<None>

numeric

 

MD_LeaveInfo_Name

 

DW_CodeDesc

varchar(32)

32

MD_LeaveInfo_Code

 

DW_CodeDescShort

varchar(16)

16

MD_LeaveInfo_ActionName

 

DW_CodeDesc

varchar(32)

32

MD_LeaveInfo_ActionCode

 

<None>

char(1)

1

MD_LeaveInfo_PlanTypeName

 

DW_CodeDesc

varchar(32)

32

MD_LeaveInfo_PlanTypeCode

 

DW_Colleague5CharCode

char(5)

5

MD_LeaveInfo_AuditKey

 

DW_AuditKey

bigint

 

MD_LeaveInfo_Timestamp

 

<None>

timestamp

 


List of indexes of the table MD_LeaveInfo

Name

Unique

Cluster

Primary

Foreign Key

Alternate Key

Table

MD_LEAVEINFO_PK

TRUE

TRUE

TRUE

FALSE

FALSE

MD_LeaveInfo

MD_LEAVEINFO_AK

TRUE

FALSE

FALSE

FALSE

TRUE

MD_LeaveInfo


List of keys of the table MD_LeaveInfo

Name

Identifier_1

AltKey


Previous
Home
Next