VISIBILITY 8:00 – 5:00
- Whitepaper. Going to add in the part about the form creation system and default visualization capability.
VISIBILITY 8:00 – 5:00
Start: 11:00
End: 7:10
8:00 – 4:00 VISIBILITY
7:30 – 4:30 VISIBILITY
Start: 10:35
end: 6:45
SELECT p.* FROM project_portfolio.projects p, project_portfolio.budget_centers b, project_portfolio.budget_amounts a, project_portfolio.obligations_outlays o, project_portfolio.obligations_outlays_goals g WHERE p.uid = b.project_id AND b.uid = a.budget_center_id AND b.uid = o.funding_id AND b.appropriation = g.appropriation AND g.year = year_count AND a.year = g.year AND (o.month_1 < IF (o.type like ‘%Outlay%’, (g.outlay_month_1 * a.amount / 100), (g.obligation_month_1 * a.amount) / 100) OR o.month_2 < IF (o.type like ‘%Outlay%’, (g.outlay_month_2 * a.amount / 100), (g.obligation_month_2 * a.amount) / 100) OR o.month_3 < IF (o.type like ‘%Outlay%’, (g.outlay_month_3 * a.amount / 100), (g.obligation_month_3 * a.amount) / 100) OR o.month_4 < IF (o.type like ‘%Outlay%’, (g.outlay_month_4 * a.amount / 100), (g.obligation_month_4 * a.amount) / 100) OR o.month_5 < IF (o.type like ‘%Outlay%’, (g.outlay_month_5 * a.amount / 100), (g.obligation_month_5 * a.amount) / 100) OR o.month_6 < IF (o.type like ‘%Outlay%’, (g.outlay_month_6 * a.amount / 100), (g.obligation_month_6 * a.amount) / 100) OR o.month_7 < IF (o.type like ‘%Outlay%’, (g.outlay_month_7 * a.amount / 100), (g.obligation_month_7 * a.amount) / 100) OR o.month_8 < IF (o.type like ‘%Outlay%’, (g.outlay_month_8 * a.amount / 100), (g.obligation_month_8 * a.amount) / 100) OR o.month_9 < IF (o.type like ‘%Outlay%’, (g.outlay_month_9 * a.amount / 100), (g.obligation_month_9 * a.amount) / 100) OR o.month_10 < IF (o.type like ‘%Outlay%’, (g.outlay_month_10 * a.amount / 100), (g.obligation_month_10 * a.amount) / 100) OR o.month_11 < IF (o.type like ‘%Outlay%’, (g.outlay_month_11 * a.amount / 100), (g.obligation_month_11 * a.amount) / 100) OR o.month_12 < IF (o.type like ‘%Outlay%’, (g.outlay_month_12 * a.amount / 100), (g.obligation_month_12 * a.amount) / 100)) GROUP BY p.uid ORDER BY b.uid, a.year, o.year
8:30 – 4:30 VISIBILITY
Continuing Visibility 2 documentation
Running into the following error – not consistent – but frequent:
Projects – Projects – Enter Monthly Status Data – After selecting contract –
Gets hung up on message (highlighted in blue wave pattern – as if it is processing) – “Project selected… creating data panels”
Showed to Dong – Thanks!
7:30 – 3:30 VISIBILITY
Start 10:15
End: 6:15
Start: 10:15
End: 6:15
8:00 – 4:00 VISIBILITY
You must be logged in to post a comment.