User Tools

Site Tools


projects:ceo_bi_reports_3

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
projects:ceo_bi_reports_3 [2019/06/21 10:00]
192.168.2.159
projects:ceo_bi_reports_3 [2019/06/21 10:02] (current)
192.168.2.159
Line 331: Line 331:
 </​code>​ </​code>​
  
-=== Request 12: Selections Complete === +=== Request 6: Selections Complete === 
-Updated on 05/​06/​2019. +Updated on 21/06/2019.
-<​code>​ +
-SELECT +
-   ​entity.s_name AS "​Selections Consultant",​ +
-   ​admin.d_cSel_comp AS "​Selections Complete"​  +
-FROM +
-   ​FworkSQLEcm.dbo.job  +
-   INNER JOIN +
-      FworkSQLEcm.dbo.udf_job1  +
-      ON udf_job1.l_job_id = job.l_job_id  +
-   INNER JOIN +
-      FworkSQLEcm.dbo.admin  +
-      ON admin.l_job_id = job.l_job_id  +
-   INNER JOIN +
-      FworkSQLEcm.dbo.dia_dEntry  +
-      ON admin.l_cSel_cAppt_id = dia_dEntry.l_dia_dEntry_id  +
-   INNER JOIN +
-      FworkSQLEcm.dbo.entity  +
-      ON dia_dEntry.l_staff_e_id = entity.l_entity_id  +
-WHERE +
-   ​admin.d_cSel_comp IS NOT NULL +
-</​code>​ +
- +
-=== Request 6: Selections Complete ​- By Selections Consultant=== +
-Updated on 05/06/2019.+
 <​code>​ <​code>​
 SELECT SELECT
Line 362: Line 338:
    ​jobStatus.s_name AS "Job Status",​    ​jobStatus.s_name AS "Job Status",​
    ​rDiv.s_name AS Company,    ​rDiv.s_name AS Company,
-   ​entity.s_name AS "​Selections Consultant"​+   ​entity.s_name AS "​Selections Consultant", 
 +   ​admin.d_cSel_comp AS "​Selections Complete" ​
 FROM FROM
    ​FworkSQLEcm.dbo.job ​    ​FworkSQLEcm.dbo.job ​
projects/ceo_bi_reports_3.txt · Last modified: 2019/06/21 10:02 by 192.168.2.159