Dict-Physical

View VMF_LeaveAccrual

Card of view VMF_LeaveAccrual

Name	VMF_LeaveAccrual
Comment	See documentation on MF_LeaveAccrual in the StarsEmployee package.
Dimensional Type	Fact

SQL query of the view VMF_LeaveAccrual

select
MD_LeaveInfo_SurrogateKey,
MD_CollPers_SurrogateKey,
MD_Date_DateInteger,
MF_Leave_AccrualID,
MF_Leave_ColleagueID,
MF_Leave_IsEnded,
MF_Leave_Action,
MF_Leave_Amount,
MF_Leave_MaxAccrual,
MF_Leave_Balance,
MF_Leave_Count
from
MF_LEAVEACCRUAL

List of outgoing view references of the view VMF_LeaveAccrual

ViewReference_168

VMD_LeaveInfo

ViewReference_170

VMD_Employee

ViewReference_171

VMD_Date (Shortcut)

List of referenced objects of the view VMF_LeaveAccrual

MF_LeaveAccrual

List of diagrams containing the view VMF_LeaveAccrual

ViewsEmployeeDiagram

List of permissions of the view VMF_LeaveAccrual

SELECT,VIEW DEFINITION

EmployeeReader

List of view columns of the view VMF_LeaveAccrual

MD_LeaveInfo_SurrogateKey

numeric

MD_CollPers_SurrogateKey

numeric

MD_Date_DateInteger

int

Integer representation of the date (e.g., 20070101 for 1 Jan 2007). Defaults to 99991231, for situations where a date is required but none is available.

MF_Leave_AccrualID

varchar(32)

ID associated with accrual in Colleague. Implemented as a degenerate dimension here. Do not expose to users!

Could be used as the sole primary key for this fact table, but we don't want to count on that. Hence we use it in conjunction with the date and the employee foreign keys.

MF_Leave_ColleagueID

char(7)

Generally should not be exposed to users. It is used by the ETL loads instead of the employee's surrogate key, which might be revised if we load more history into MD_Employee.

MF_Leave_IsEnded

char(3)

'Yes' if a given leave action (accrual, decrease, etc.) applies to a plan that, for a given employee, has ended as of the last data warehouse load. 'No' otherwise.

Use this value as a filter, to remove non-current accrual information.

MF_Leave_Action

char(1)

Single-letter code designating whether the MF_Leave_Amount is and accrual (A), usage (U), etc.

This attribute is generally not not needed because the value of MF_Leave_Amount will be negative in the case of a U, and positive in the case of an A. In some cases, one may want to look only at usage/reductions and not accruals or vice versa. In such cases, this attribute would be useful, although it is also available on the MD_LeaveInfo dimension.

MF_Leave_Amount

float

MF_Leave_MaxAccrual

float

Not currently populated.

Some leave plans have no max accrual (i.e., accrual limit), so this value may be null. The value here is the max as of the date of the accrual.

When aggregated, the values in this field should be aggregated by taking the rightmost or max() value, not the sum.

MF_Leave_Balance

float

Balance available for a given leave category and a given person at a given time.

Generally this should be calculated by aggregating on MF_Leave_Amount, not by using this field.

When aggregated, it should be aggregated by taking the rightmost or max() value, not the sum.

MF_Leave_Count

int

Simply counts leave accrual/usage actions. Generally not useful.

Home