HMCSOSTraining_EE02                                Show Active Employees with Leave Balances                                                                                                                                                                                                                      Employee                                          McsosTrainingFY0506.dbo.viwRTEmployees.Status = 'Active'  
 AND
McsosTrainingFY0506.dbo.viwRTEmpLeavePlans.Active <> 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
DMCSOSTraining_EE02                                viwRTEmployees                                                                                                                                                                                                                                                 Name                                                                                                                                                                                                                                                           Name                                                                                                00000000010000000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_EE02                                viwRTEmployees                                                                                                                                                                                                                                                 TotalYears                                                                                                                                                                                                                                                     TotalYears                                                                                          00000000020000000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_EE02                                viwRTEmpLeavePlans                                                                                                                                                                                                                                             LeaveDescription                                                                                                                                                                                                                                               LeaveDescription                                                                                    00000000030000000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_EE02                                viwRTEmpLeavePlans                                                                                                                                                                                                                                             Balance                                                                                                                                                                                                                                                        Balance                                                                                             00000000040000000000