HMCSOSTraining_EE06                                Employee Info and Amt Paid for ASRS                                                                                                                                                                                                                            Employee                                          McsosTrainingFY0506.dbo.viwRTEmpDeductions.DeductionDescription LIKE 'ASRS%'  
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
DMCSOSTraining_EE06                                viwRTEmployees                                                                                                                                                                                                                                                 Name                                                                                                                                                                                                                                                           Employee Name                                                                                       00000000010000000020                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_EE06                                viwRTEmployees                                                                                                                                                                                                                                                 BirthDate                                                                                                                                                                                                                                                      BirthDate                                                                                           00000000020000000050                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_EE06                                viwRTEmployees                                                                                                                                                                                                                                                 HireDate                                                                                                                                                                                                                                                       HireDate                                                                                            00000000030000000040                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_EE06                                viwRTEmployees                                                                                                                                                                                                                                                 LastName                                                                                                                                                                                                                                                       LastName                                                                                            00000000040000000010                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_EE06                                viwRTEmpDeductions                                                                                                                                                                                                                                             Amount                                                                                                                                                                                                                                                         Amount                                                                                              00000000050000000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
DMCSOSTraining_EE06                                viwRTEmpDeductions                                                                                                                                                                                                                                             DeductionDescription                                                                                                                                                                                                                                           DeductionDescription                                                                                00000000060000000000