Financial Assistant Database

  • Database Name
    • project_portfolio_enh
  • source file
    • trunk/Sandbox_folders/DONG_SANDBOX/Java/FinancialAssistantService/src/database/project_portfolio_enh.zip
  • tables
    • see source file…
  • views
    • Views are created to simplify query execution and improve performace. The main view, __view_project_detailed_data, is used by Query Builder application for analysis of fully built data using relations described below
    • __view_project_detailed_data
    • __view_budget_amount_totals_by_project
    • __view_financial_analysts_by_project
    • __view_portfolio_mgrs_by_project pm
    • __view_committed_amounts_by_budget_center
    • __view_obligations_outlays_by_budget_center
    • __view_obligations_outlays_goals
    • __view_budget_center_pocs bcsp
  • relations – one has many relations
    • projects
      • budget_centers
      • project_alerts
      • project_comments
      • project_totals
      • _projects_portfolio_admins
      • _projects_portfolio_mgrs
      • _projects_service_finance_pocs
      • _projects_service_project_mgrs
      • _projects_sub_projects
    • budget_centers
      • obligations_outlays
      • committed_amounts
      • _budget_center_contracts
      • _budget_center_service_pocs
    • obligations_outlays
      • financial_mitigation_plans
      • invoices
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: