url.EID=decrypt(#url.EID#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex"); SELECT * FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID = '#url.EID#' AND Emp_Type != 'Physician' SELECT * FROM #Request.prefix_db_agency#.EmployeeLicenses WHERE Emp_ID = '#url.EID#' And (License_Type like '%License%' or License_Type like '%Auto%' or License_Type like 'Other' or License_Type like '%Liability %') And (License_Number IS NOT NUll AND License_Number !='NA') AND MEasure=0 AND Status=0 AND Units=0 AND Deleted <> 1 Order by Expiration_Date Asc SELECT * FROM #Request.prefix_db_agency#.EmployeeLicenses WHERE Emp_ID = '#url.EID#' And (License_Type = 'Background Check' or License_Type = 'CPR Certification' or License_Type = 'TB Test' or License_Type = 'Physical Exam' or License_Type like 'Other') And (License_Number IS NUll OR License_Number='' OR License_Number='NA') AND MEasure=0 AND Status=0 AND Units=0 AND Deleted <> 1 Order by Expiration_Date Asc SELECT * FROM #Request.prefix_db_agency#.EmployeeLicenses WHERE Emp_ID = '#url.EID#' And (License_Type = 'Cont Ed' or License_Type = 'Inservice' or License_Type like 'Other') And (License_Number IS NUll OR License_Number='' OR License_Number='NA') AND (MEasure IS NOT NULL AND MEasure !='0') AND (Units IS NOT NULL AND Units !='0') AND Status=0 AND Deleted <> 1 Order by Expiration_Date Asc
#GetE.Emp_First# #GetE.Emp_Last#
Back
Licenses & Insurance
Add License
License Status Date
#GetE.Skill_1# License #Trim(Left(GetEL.Comments,20))#...#GetEL.License_Type# Expired Active #DateFormat(GetEL.Expiration_Date,"mm/dd/yyyy")# #DateFormat(GetEL.Expiration_Date,"mm/dd/yyyy")#
Background & Health
Run Exclusion Check Add Background
License Status Date
#Trim(Left(Comments,20))#...#License_Type# Expired Active #DateFormat(GetEB.Expiration_Date,"mm/dd/yyyy")# #DateFormat(GetEB.Expiration_Date,"mm/dd/yyyy")#
Continuing Education & Inservices
Add Cont Ed/Inservice
License Units Measure Date
#License_Type# #Units# #measure# completed #DateFormat(GetEC.Issue_Date,"mm/dd/yyyy")#
SELECT idEmployee_Files as id,Title,FileName,Created,Emp_ID,CreatedBy FROM #Request.prefix_db_agency#.Employee_Files WHERE AgencyId = '#session.AgencyId#' and Emp_ID= '#url.EID#' ORDER BY idEmployee_Files
The file you uploaded exceeded the 5MB file size limit.
Please reduce the size of the file and try uploading again.
#GetE.Emp_First# #GetE.Emp_Last#'s Files
Upload Employee Files
SELECT e.Emp_Last, e.Emp_First FROM #Request.prefix_db_lookup#.pEmployee e WHERE e.Emp_ID = '#getFiles.CreatedBy#'
Title Change Title File Name Change FileName Upload Date Action
No Files have been Uploaded
#getFiles.Title# Edit #getFiles.FileName# Edit #DateFormat(getFiles.Created, 'mm/dd/yyyy')# Delete