User Tools

Site Tools


projects:ceo_bi_reports_4

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_4 [2019/06/21 12:44]
192.168.2.211
projects:ceo_bi_reports_4 [2019/06/21 12:47] (current)
192.168.2.211
Line 104: Line 104:
  
 === Request 6: Selections - Final Selections Consultation to Selections Complete === === Request 6: Selections - Final Selections Consultation to Selections Complete ===
-Updated on 06/06/2019.+Updated on 21/06/2019.
 <​code>​ <​code>​
 SELECT SELECT
 +   ​job.s_job_num AS "Job Number",​
 +   ​jobStatus.s_name AS "Job Status",​
 +   ​rDiv.s_name AS Company,
    ​dia_dentry.d_dentry_fman AS final_selections_consultation,​    ​dia_dentry.d_dentry_fman AS final_selections_consultation,​
    ​admin.d_csel_comp AS selection_completed,​    ​admin.d_csel_comp AS selection_completed,​
Line 118: Line 121:
       fworksqlecm.dbo.dia_dentry ​       fworksqlecm.dbo.dia_dentry ​
       ON dia_dentry.l_job_id = job.l_job_id ​       ON dia_dentry.l_job_id = job.l_job_id ​
 +   INNER JOIN
 +      list_item AS jobStatus ​
 +      ON job.l_job_status_gl_id = jobStatus.l_list_item_id ​
 +   INNER JOIN
 +      rDiv 
 +      ON job.l_context_id = rDiv.l_context_id ​      
 WHERE WHERE
    ​dia_dentry.d_dentry_fman IS NOT NULL     ​dia_dentry.d_dentry_fman IS NOT NULL 
Line 124: Line 133:
  
 === Request 7: Estimating - Ready to Est to Estimating Complete === === Request 7: Estimating - Ready to Est to Estimating Complete ===
-Updated on 06/06/2019.+Updated on 21/06/2019.
  
 <​code>​ <​code>​
 SELECT SELECT
 +   ​job.s_job_num AS "Job Number",​
 +   ​jobStatus.s_name AS "Job Status",​
 +   ​rDiv.s_name AS Company,
    ​udf_job1.d_readytoest AS ready_to_estimating,​    ​udf_job1.d_readytoest AS ready_to_estimating,​
    ​admin.d_ordering_comp AS estimating_completed,​    ​admin.d_ordering_comp AS estimating_completed,​
Line 139: Line 151:
       fworksqlecm.dbo.udf_job1 ​       fworksqlecm.dbo.udf_job1 ​
       ON udf_job1.l_job_id = job.l_job_id ​       ON udf_job1.l_job_id = job.l_job_id ​
 +   INNER JOIN
 +      list_item AS jobStatus ​
 +      ON job.l_job_status_gl_id = jobStatus.l_list_item_id ​
 +   INNER JOIN
 +      rDiv 
 +      ON job.l_context_id = rDiv.l_context_id ​      
 WHERE WHERE
    ​udf_job1.d_readytoest IS NOT NULL     ​udf_job1.d_readytoest IS NOT NULL 
Line 145: Line 163:
  
 === Request 8: Sent to Site to Handover - Administration Complete to Handover Actual Complete === === Request 8: Sent to Site to Handover - Administration Complete to Handover Actual Complete ===
-Updated on 06/06/2019.+Updated on 21/06/2019.
  
 <​code>​ <​code>​
 SELECT SELECT
 +   ​job.s_job_num AS "Job Number",​
 +   ​jobStatus.s_name AS "Job Status",​
 +   ​rDiv.s_name AS Company,
    ​prd_hElev.s_name AS "​Elevation",​    ​prd_hElev.s_name AS "​Elevation",​
    ​admin.d_admin_comp_act AS "​Adminsitration Completed",​    ​admin.d_admin_comp_act AS "​Adminsitration Completed",​
Line 167: Line 188:
       FworkSQLEcm.dbo.prd_hElev ​       FworkSQLEcm.dbo.prd_hElev ​
       ON job.l_prd_hElev_id = prd_hElev.l_prd_hElev_id ​       ON job.l_prd_hElev_id = prd_hElev.l_prd_hElev_id ​
 +   INNER JOIN
 +      list_item AS jobStatus ​
 +      ON job.l_job_status_gl_id = jobStatus.l_list_item_id ​
 +   INNER JOIN
 +      rDiv 
 +      ON job.l_context_id = rDiv.l_context_id ​     ​
 WHERE WHERE
    ​admin.d_admin_comp_act IS NOT NULL     ​admin.d_admin_comp_act IS NOT NULL 
Line 174: Line 201:
  
 === Request 9: Footings to Handover - Footings Pour Actual Complete to Handover Actual Complete === === Request 9: Footings to Handover - Footings Pour Actual Complete to Handover Actual Complete ===
-Updated on 06/06/2019.+Updated on 21/06/2019.
  
 <​code>​ <​code>​
 SELECT SELECT
 +   ​job.s_job_num AS "Job Number",​
 +   ​jobStatus.s_name AS "Job Status",​
 +   ​rDiv.s_name AS Company,
    ​prd_hElev.s_name AS "​Elevation",​    ​prd_hElev.s_name AS "​Elevation",​
    ​cst.d_base_comp_act AS "​Footings Pour Actual Complete",​    ​cst.d_base_comp_act AS "​Footings Pour Actual Complete",​
Line 199: Line 229:
       fworksqlecm.dbo.cst ​       fworksqlecm.dbo.cst ​
       ON cst.l_job_id = job.l_job_id ​       ON cst.l_job_id = job.l_job_id ​
 +   INNER JOIN
 +      list_item AS jobStatus ​
 +      ON job.l_job_status_gl_id = jobStatus.l_list_item_id ​
 +   INNER JOIN
 +      rDiv 
 +      ON job.l_context_id = rDiv.l_context_id ​      
 WHERE WHERE
    ​cst.d_base_comp_act IS NOT NULL     ​cst.d_base_comp_act IS NOT NULL 
projects/ceo_bi_reports_4.txt ยท Last modified: 2019/06/21 12:47 by 192.168.2.211