v_sd_finance_costs_tobedeleted

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

Program

VARCHAR

50

Program ID

VARCHAR

20

CAPEX-OPEN POS

DECIMAL

34

√

null

CAPEX-POSTED COSTS

DECIMAL

34

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

select (case when ((`g`.`group_id` = 1) and (year(`p`.`complete_date`) > year(curdate())) and (`p`.`status_id` = 1)) then 'Corp New 2015' else `g`.`sd_group` end) AS `Program`,(case when ((`g`.`group_id` = 1) and (year(`p`.`complete_date`) > year(curdate())) and (`p`.`status_id` = 1)) then 'SD.CN15' else `g`.`sd_name` end) AS `Program ID`,sum(cast((case when (`c`.`cost_type` = 'Open') then `c`.`cost` else 0 end) as decimal(12,0))) AS `CAPEX-OPEN POS`,sum(cast((case when (`c`.`cost_type` = 'Posted') then `c`.`cost` else 0 end) as decimal(12,0))) AS `CAPEX-POSTED COSTS` from (((((`tb2`.`project` `p` join `tb2`.`project_sd_group` `g` on((`g`.`group_id` = `p`.`prj_program_id`))) left join `tb2`.`project_status` `ps` on((`p`.`status_id` = `ps`.`id`))) join `tb2`.`site` `s` on((`s`.`id` = `p`.`site_id`))) left join `tb2`.`site_status` `ss` on((`s`.`status_code` = `ss`.`status_code`))) left join `tb2`.`sd_finance_costs` `c` on(((`c`.`sap` = `s`.`sap`) and (`c`.`short_text` = (case when ((`g`.`group_id` = 1) and (year(`p`.`complete_date`) > year(curdate())) and (`p`.`status_id` = 1)) then 'SD.CN15' else `g`.`sd_name` end))))) where (`s`.`status_code` in ('OPEN','POTL','CLSD','FTLN')) group by (case when ((`g`.`group_id` = 1) and (year(`p`.`complete_date`) > year(curdate())) and (`p`.`status_id` = 1)) then 'Corp New 2015' else `g`.`sd_group` end)

v_sd_finance_costs_tobedeleted

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views