#DateInMonth#
SELECT pEmployee.Emp_Last as Emp_Last, pEmployee.Emp_First as Emp_First
FROM pEmployee
WHERE pEmployee.Emp_ID = #theid#
#mid(Emp_First,1,1)#. #Emp_Last#:
#GetToken(StartTime,1,":")#:#GetToken(StartTime,2,":")#
- #GetToken(EndTime,1,":")#:#GetToken(EndTime,2,":")#
(#Total_Units# Units)
#LEFT(Notes,20)#...
#VisitType#
#VisitType# #VisitType# with #mid(Pt_First,1,1)#. #Pt_Last# (#Pt_Agy_ID#)
(#Certification_Start# - #Certification_END#)
#VisitType#
#VisitType# with #mid(Pt_First,1,1)#. #Pt_Last# (#Pt_Agy_ID#)
(#Certification_Start# - #Certification_END#)
#VisitType# #VisitType# with #mid(Pt_First,1,1)#. #Pt_Last# (#Pt_Agy_ID#)
(#Certification_Start# - #Certification_END#)
#VisitType# #VisitType# with #mid(Pt_First,1,1)#. #Pt_Last# (#Pt_Agy_ID#)
(#Certification_Start# - #Certification_END#)
#VisitType# #VisitType# with #mid(Pt_First,1,1)#. #Pt_Last# (#Pt_Agy_ID#)
(#Certification_Start# - #Certification_END#)
#VisitType# #VisitType# #VisitType# with #mid(Pt_First,1,1)#. #Pt_Last# (#Pt_Agy_ID#)
(#Certification_Start# - #Certification_END#)
#VisitType# for #mid(Pt_First,1,1)#. #Pt_Last# (#Pt_Agy_ID#)
(#Certification_Start# - #Certification_END#)
#VisitType#
#VisitType#
#VisitType#
#VisitType#
#VisitType#
#VisitType#
#VisitType#
#VisitType#
#VisitType#
#VisitType#
#VisitType#
#VisitType#
with #mid(Pt_First,1,1)#. #Pt_Last# (#Pt_Agy_ID#) (#Certification_Start# - #Certification_END#)
#VisitType# #LEFT(Notes,20)#...
#GetToken(StartTime,1,":")#:#GetToken(StartTime,2,":")#
- #GetToken(EndTime,1,":")#:#GetToken(EndTime,2,":")#
(#Total_Units# Units)
|
|
| |