View name : vw_dev_est_reqs_status_forcast

Columns :
1. Forecast ID : iddev_est_reqs_status_forcast
(Hoover) Actual Status ID : iddev_est_reqs_status_nm

2. Phase Lag : for_lag_time_vir
(Hoover)  Previous End : for_stat_e_dt_pre_fmt Next Start : for_stat_st_dt_fmt
ag Tm
3. Cube Details : req_desc
(Hoover) 1. Owner : owner_fnm, owner_ref_nm 2. Estimator : est_fnm, est_ref_nm

4. Cube ID : iddev_est_reqs
(Hoover) 1. Apex ID : iddev_apps 2. Apex Name : app_name 3. Glacier ID : iddev_est 4. Glacier Type : est_type 5. Glacier Summary : dev_est_smry 

5 Phase : req_status_nm
Hoover 1. Cube Type : req_type_nm 2. Skills : skill_lvl_nm 3. Gap : gap_lvl_nm

6 Phase Tm : for_stat_time_vir
(Hoover) Forecast Start : for_stat_st_dt_fmt to Forecast End : for_stat_e_dt_fmt

7. Assigned To : assigned_to_fnm, assigned_to_nm

8. Budget Amt :  for_req_bud_stat_amt, for_req_bud_stat_amt_pcnt

9 Paid : req_stat_paid_amt, req_stat_paid_amt_pcnt

10 Balance : req_stat_bal_amt, req_stat_bal_amt_pcnt

11. Hist : hist_cnt

12 Updated : last_updated_fmt,updater_nm,updater_fnm, 

13. SELECTION COLUMN

https://dev1.atguru.work/heshmapatel/mb_updates/try_code/progress_ref1.php

Left Filter : -

1. Total (iddev_est_reqs_status_nm)  [count] [sum (for_req_bud_amt, 4K) (Hoover : Budget : $4,000)]
[req_stat_amt $3k(H : Invoiced : $3000.50) ], [req_stat_paid $1k(H Paid : $1200.50 ], [req_stat_bal $1K (H Balance : $1800.00) ]

2. Budget for_req_bud_amt_nm

2. Apex app_name(Hoover ID iddev_apps), [count] [sum (for_req_bud_amt, 4K) (Hoover : Budget : $400,000)]
 [req_stat_amt $3k(H : Invoiced : $3000.50) ], [req_stat_paid $1k(H Paid : $1200.50 ], [req_stat_bal $1K (H Balance : $1800.00) ]

4. Owner owner_fnm, owner_ref_nm

5. Estimator est_fnm, est_ref_nm

6. Glacier ID (Search) iddev_est (Hoover 

7. Category category_nm 

8. Cube Status (open, close) req_e_dt

9 Assigned To ( Search ) assigned_to_fnm, assigned_to_nm

10 Phase req_status_nm

11. Cube Type req_type_nm

12. Cube Skills skill_lvl_nm

13. Cube Gap gap_lvl_nm

14 Forecast Status

14 Forecast Year

15. Forecast Month

Top Nav.
1. Budget for_req_bud_amt_nm 2. Balance req_stat_bal 3. Forecast Start or_stat_st_dt 4. Forecast End for_stat_e_dt 5. Duration for_stat_time 6 Lag for_lag_time  7. Apex app_name 8. Owner owner_ref_nm 9. Estimator est_ref_nm. 10  Assigned To  assigned_to_nm 11 Phase Type req_status_nm 12 Cube Type req_type_nm
Not Hidden
ForeCast ID, Cube Details