Department head details

Department head details

This report is used to get the complete list of Department and the department head configured in the application

SELECT dept.deptid "Department ID",
       dept.deptname "Department Name",
       dept.phoneno "Phone No",
       dept.fax "Fax",
       sdorg.name "Site Name",
       aa.first_name "Department Head",
       dept.deptdesc "Department Description",
       da.first_name "Approver" FROM departmentdefinition dept
LEFT JOIN sduser sd ON sd.userid=dept.deptheadid
LEFT JOIN aaauser aa ON aa.user_id=sd.userid
LEFT JOIN sitedefinition site ON site.siteid=dept.siteid
LEFT JOIN sdorganization sdorg ON sdorg.org_id=site.siteid
LEFT JOIN RoleToUserMapping rum ON dept.deptid=rum.EntityValue
LEFT JOIN aaauser da ON rum.userid=da.user_id
ORDER BY 5



          • Related Articles

          • Requester details

            This report is used to find the Requester complete details.  SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department", ...
          • Purchase details

            SELECT po.POCUSTOMID "PO Number", max(po.PONAME) "PO Name", max(po.TERMS) "PO Terms", LONGTODATE(max(po.DATEORDERED)) "Ordered Date", max(pos.STATUSNAME) "PO Status", max(poa.FIRST_NAME) "Purchase Requester", max(po.SHIPTO) "Ship To", max(paao.NAME) ...
          • Contract Details

            SELECT mcdt.Contractid "Contract ID", mcdt.CONTRACTNAME "Contract Name", mcdt.comments "Description", contractcategory.Categoryname "Contract Type", LONGTODATE(mcdt.CREATEDDATE) "Created Time", LONGTODATE(mcdt.FROMDATE) "From Date", ...
          • Purchase Request details

            SELECT pr.Requestid "Requestid", pr.Subject "Subject", pr.Description "Description", longtodate(pr.Requesteddate) "Requesteddate", longtodate(pr.Daterequired) "Daterequired", longtodate(pr.createddate) "createddate", pr.Shipping_details ...
          • Software details

            SELECT systeminfo.workstationname             "Workstation",         Max(aaauser.first_name)                "User",         ( softwarelist.softwarename )          "Software_Name",         Max(softwaretype.softwaretype)         "Software_Type",  ...