Skip to content

Custom database functions

Jump to bottom Edit New page
Catherine Seppanen edited this page Aug 31, 2015 · 5 revisions

public.alias_filter

  • defined in deploy/db/cost/functions/alias_filter.sql
  • called by:
    • public.build_project_future_year_inventory_matching_hierarchy_sql
    • public.populate_least_cost_strategy_worksheet
    • public.populate_project_future_year_inventory_strategy_messages.sql
    • public.populate_strategy_messages
    • public.run_multi_pollutant_max_emis_red_strategy
    • public.run_project_future_year_inventory

public.alias_inventory_filter

  • defined in deploy/db/cost/functions/alias_inventory_filter.sql
  • called by:
    • public.check_daily_temporal_allocation_xref
    • public.check_monthly_temporal_allocation_xref
    • public.create_daily_temporal_allocation_xref
    • public.create_monthly_temporal_allocation_xref
    • public.create_projected_future_year_inventory
    • public.populate_least_cost_strategy_detailed_result
    • public.populate_sources_table
    • public.run_annotate_inventory
    • public.run_apply_measures_in_series_strategy
    • public.run_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy_finalize
    • public.run_temporal_allocation_daily_to_episode
    • public.run_temporal_allocation_daily_to_month
    • public.run_temporal_allocation_to_day
    • public.run_temporal_allocation_to_month

public.apply_cap_measures_on_hap_pollutants

  • defined in deploy/db/cost/functions/apply_cap_measures_on_hap_pollutants.sql
  • calls:
    • public.concatenate_with_ampersand
    • public.check_table_for_columns
    • public.get_dataset_month
    • public.get_days_in_month
    • public.get_ann_emis_expression
    • public.get_uncontrolled_emis_expression
    • public.build_version_where_filter
  • called by:
    • AbstractStrategyTask.java
    • leastcostcurve/StrategyLoader.java

public.array_idx

  • defined in deploy/db/data/functions/array_idx.sql
  • called by:
    • SQLEnhanceFlatFile2010PointQuery.java

public.build_project_future_year_inventory_matching_hierarchy_sql

  • defined in deploy/cost/functions/build_project_future_year_inventory_matching_hierarchy_sql.sql
  • calls:
    • public.build_version_where_filter
    • public.alias_filter
    • public.check_table_for_columns
  • called by:
    • public.populate_project_future_year_inventory_strategy_messages.sql
    • public.run_project_future_year_inventory

public.build_version_where_filter (2 versions)

  • defined in deploy/db/cost/functions/build_version_where_filter.sql
  • called by:
    • public.apply_cap_measures_on_hap_pollutants
    • public.build_project_future_year_inventory_matching_hierarchy_sql
    • public.check_daily_temporal_allocation_xref
    • public.check_monthly_temporal_allocation_xref
    • public.create_daily_temporal_allocation_xref
    • public.create_monthly_temporal_allocation_xref
    • public.create_projected_future_year_inventory
    • public.populate_least_cost_strategy_detailed_result
    • public.populate_least_cost_strategy_worksheet
    • public.populate_project_future_year_inventory_strategy_messages.sql
    • public.populate_strategy_messages
    • public.run_annotate_inventory
    • public.run_apply_measures_in_series_strategy
    • public.run_apply_measures_in_series_strategy_finalize
    • public.run_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy
    • public.run_project_future_year_inventory
    • public.run_temporal_allocation_daily_to_episode
    • public.run_temporal_allocation_daily_to_month
    • public.run_temporal_allocation_to_day
    • public.run_temporal_allocation_to_month
    • public.validate_project_future_year_inventory_control_programs

public.calculate_capital_recovery_factor

  • defined in deploy/db/cost/functions/calculate_capital_recovery_factor.sql
  • called by:
    • public.get_capital_recovery_factor_expression

public.check_daily_temporal_allocation_xref

  • defined in deploy/db/tempalloc/check_daily_temporal_allocation_xref.sql
  • calls:
    • public.check_table_for_columns
    • public.alias_inventory_filter
    • public.build_version_where_filter
  • called by:
    • TemporalAllocationTask.java

public.check_monthly_temporal_allocation_xref

  • defined in deploy/db/tempalloc/check_monthly_temporal_allocation_xref.sql
  • calls:
    • public.check_table_for_columns
    • public.alias_inventory_filter
    • public.build_version_where_filter
  • called by:
    • TemporalAllocationTask.java

public.check_table_for_columns

  • defined in deploy/db/cost/functions/check_table_for_columns.sql
  • called by:
    • SQLCompareVOCSpeciationWithHAPInventoryQuery.java
    • SQLCreateMoEmisByCtyFromAnnEmisQuery.java
    • SQLECControlScenarioQuery.java
    • public.build_project_future_year_inventory_matching_hierarchy_sql
    • public.create_daily_temporal_allocation_xref
    • public.create_least_cost_worksheet_table_indexes
    • public.create_monthly_temporal_allocation_xref
    • public.create_orl_table_indexes
    • public.create_projected_future_year_inventory
    • public.create_table_index
    • public.get_ceff_equation_expression
    • public.get_cost_expressions
    • public.populate_least_cost_strategy_worksheet
    • public.populate_project_future_year_inventory_strategy_messages.sql
    • public.populate_sources_table
    • public.populate_strategy_messages
    • public.run_annotate_inventory
    • public.run_apply_measures_in_series_strategy
    • public.run_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy_finalize
    • public.run_project_future_year_inventory
    • public.run_temporal_allocation_daily_to_episode
    • public.run_temporal_allocation_daily_to_month
    • public.run_temporal_allocation_to_day
    • public.run_temporal_allocation_to_month
    • public.validate_project_future_year_inventory_control_programs

public.clean_project_future_year_inventory_control_programs

  • defined in deploy/db/cost/functions/clean_project_future_year_inventory_control_programs.sql
  • called by:
    • projectFutureYearInventory/StrategyTask.java

public.clean_temporal_allocation_xref

  • defined in deploy/db/tempalloc/clean_temporal_allocation_xref.sql
  • called by:
    • TemporalAllocationTask.java

public.concatenate_with_ampersand [AGGREGATE]

  • defined in deploy/db/cost/functions/utility.sql
  • calls:
    • public.join_with_ampersand
  • called by:
    • AbstractControlStrategyInventoryOutput.java
    • MergedControlStrategyInventoryOutput.java
    • public.apply_cap_measures_on_hap_pollutants
    • public.populate_least_cost_strategy_worksheet
    • public.run_apply_measures_in_series_strategy
    • public.run_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy_finalize

public.convert_design_capacity_to_mw (2 versions)

  • defined in deploy/db/cost/functions/convert_design_capacity_to_mw.sql
  • called by:
    • public.get_convert_design_capacity_expression

public.count_estimate

  • defined in deploy/db/data/functions/count_estimate.sql
  • called by:
    • DataServiceImpl.java

public.create_daily_temporal_allocation_xref

  • defined in deploy/db/tempalloc/create_daily_temporal_allocation_xref.sql
  • calls:
    • public.check_table_for_columns
    • public.alias_inventory_filter
    • public.build_version_where_filter
  • called by:
    • TemporalAllocationTask.java

public.create_least_cost_worksheet_table_indexes

  • defined in deploy/db/cost/functions/create_least_cost_worksheet_table_indexes.sql
  • calls:
    • public.check_table_for_columns
  • called by:
    • LeastCostAbstractStrategyLoader.java

public.create_monthly_temporal_allocation_xref

  • defined in deploy/db/tempalloc/create_monthly_temporal_allocation_xref.sql
  • calls:
    • public.check_table_for_columns
    • public.alias_inventory_filter
    • public.build_version_where_filter
  • called by:
    • TemporalAllocationTask.java

public.create_orl_table_indexes

  • defined in deploy/db/cost/functions/create_orl_table_indexes.sql
  • calls:
    • public.check_table_for_columns
  • called by:
    • FastRunTask.java
    • PopulateFastQuasiPointDatasetTask.java
    • SQLCompareVOCSpeciationWithHAPInventoryQuery.java

public.create_projected_future_year_inventory

  • defined in deploy/db/cost/functions/create_projected_future_year_inventory.sql
  • calls:
    • public.alias_inventory_filter
    • public.check_table_for_columns
    • public.get_dataset_month
    • public.get_days_in_month
    • public.build_version_where_filter
  • called by:
    • ProjectFutureYearInventoryControlStrategyInventoryOutput.java

public.create_strategy_detailed_result_table_indexes

  • defined in deploy/db/cost/functions/create_strategy_detailed_result_table_indexes.sql
  • called by:
    • AbstractStrategyLoader.java
    • AbstractControlStrategyInventoryOutput.java
    • ApplyMeasureInSeriesControlStrategyInventoryOutput.java

public.create_table_index (2 versions)

  • defined in deploy/db/cost/functions/create_table_index.sql
  • calls:
    • public.check_table_for_columns
  • called by:
    • PostgresTableDefinition.java
    • projectFutureYearInventory/StrategyTask.java
    • SQLCompareVOCSpeciationWithHAPInventoryQuery.java

public.eliminate_least_cost_strategy_source_measures

  • defined in deploy/db/cost/functions/eliminate_least_cost_strategy_source_measures.sql
  • called by:
    • LeastCostAbstractStrategyLoader.java

public.get_ann_emis_expression

  • defined in deploy/db/cost/functions/get_ann_emis_expression.sql
  • called by:
    • public.apply_cap_measures_on_hap_pollutants
    • public.get_ceff_equation_expression
    • public.get_cost_expressions
    • public.get_emis_reduction_expression
    • public.get_remaining_emis_expression
    • public.populate_least_cost_strategy_detailed_result
    • public.populate_least_cost_strategy_worksheet
    • public.run_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy

public.get_capital_recovery_factor_expression

  • defined in deploy/db/cost/functions/get_capital_recovery_factor_expression.sql
  • calls:
    • public.calculate_capital_recovery_factor
  • called by:
    • public.get_cost_expressions

public.get_ceff_equation_expression (2 versions)

  • defined in deploy/db/cost/functions/get_ceff_equation_expression.sql
  • calls:
    • public.get_stkflow_expression
    • public.check_table_for_columns
    • public.get_dataset_month
    • public.get_days_in_month
    • public.get_ann_emis_expression
  • called by:
    • public.get_control_percent_reduction_expression
    • public.get_cost_expressions
    • public.populate_least_cost_strategy_worksheet
    • public.run_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy

public.get_control_percent_reduction_expression (2 versions)

  • defined in deploy/db/cost/functions/get_control_percent_reduction_expression.sql
  • calls:
    • public.get_ceff_equation_expression
  • called by:
    • public.get_cost_expressions
    • public.get_emis_reduction_expression
    • public.get_remaining_emis_expression
    • public.populate_least_cost_strategy_worksheet
    • public.run_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy

public.get_convert_design_capacity_expression (2 versions)

  • defined in deploy/db/cost/functions/get_convert_design_capacity_expression.sql
  • calls:
    • public.convert_design_capacity_to_mw
  • called by:
    • public.get_cost_expressions

public.get_cost_expressions

  • defined in deploy/db/cost/functions/cost_equations_v2.sql
  • calls:
    • public.get_stkflow_expression
    • public.get_convert_design_capacity_expression
    • public.get_capital_recovery_factor_expression
    • public.check_table_for_columns
    • public.get_dataset_month
    • public.get_days_in_month
    • public.get_days_in_year
    • public.get_ann_emis_expression
    • public.get_uncontrolled_emis_expression
    • public.get_ceff_equation_expression
    • public.get_control_percent_reduction_expression
    • public.get_remaining_emis_expression
    • public.get_emis_reduction_expression
  • called by:
    • public.populate_least_cost_strategy_worksheet
    • public.run_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy

public.get_dataset_month

  • defined in deploy/db/cost/functions/get_dataset_month.sql
  • called by:
    • public.apply_cap_measures_on_hap_pollutants
    • public.create_projected_future_year_inventory
    • public.get_ceff_equation_expression
    • public.get_cost_expressions
    • public.populate_least_cost_strategy_detailed_result
    • public.populate_least_cost_strategy_worksheet
    • public.run_annotate_inventory
    • public.run_apply_measures_in_series_strategy
    • public.run_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy_finalize
    • public.run_project_future_year_inventory
    • public.run_temporal_allocation_to_month

public.get_days_in_month

  • defined in deploy/db/cost/functions/get_days_in_month.sql
  • called by:
    • public.apply_cap_measures_on_hap_pollutants
    • public.create_projected_future_year_inventory
    • public.get_ceff_equation_expression
    • public.get_cost_expressions
    • public.populate_least_cost_strategy_detailed_result
    • public.populate_least_cost_strategy_worksheet
    • public.run_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy
    • public.run_project_future_year_inventory
    • public.run_temporal_allocation_daily_to_month
    • public.run_temporal_allocation_to_month

public.get_days_in_year

  • defined in deploy/db/cost/functions/get_days_in_year.sql
  • called by:
    • public.populate_least_cost_strategy_worksheet
    • public.run_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy
    • public.get_cost_expressions

public.get_default_costs

  • defined in deploy/db/cost/functions/cost_equations_old_approach.sql
  • calls:
    • public.calculate_capital_recovery_factor
  • called by:
    • public.get_strategy_costs

public.get_emis_reduction_expression (2 versions)

  • defined in deploy/db/cost/functions/get_emis_reduction_expression.sql
  • calls:
    • public.get_ann_emis_expression
    • public.get_uncontrolled_ann_emis_expression
    • public.get_control_percent_reduction_expression
    • public.get_uncontrolled_emis_expression
  • called by:
    • public.get_cost_expressions

public.get_least_cost_worksheet_emis_reduction

  • defined in deploy/db/cost/functions/get_least_cost_worksheet_emis_reduction.sql
  • called by:
    • public.narrow_in_on_least_cost_target
    • public.populate_least_cost_strategy_detailed_result

public.get_remaining_emis_expression (2 versions)

  • defined in deploy/db/cost/functions/get_remaining_emis_expression.sql
  • calls:
    • public.get_ann_emis_expression
    • public.get_control_percent_reduction_expression
    • public.get_uncontrolled_ann_emis_expression
  • called by:
    • public.get_cost_expressions
    • public.populate_least_cost_strategy_worksheet
    • public.run_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy

public.get_stkflow_expression

  • defined in deploy/db/cost/functions/get_stkflow_expression.sql
  • called by:
    • public.get_ceff_equation_expression
    • public.get_cost_expressions

public.get_strategy_costs (3 versions)

  • defined in deploy/db/cost/functions/cost_equations_old_approach.sql
  • version 1 calls:
    • public.convert_design_capacity_to_mw
    • public.get_type1_equation_costs
    • public.get_type2_equation_costs
    • public.get_type7_equation_costs
    • public.get_type8_equation_costs
    • public.get_type9_equation_costs
    • public.get_type11_equation_costs
    • public.get_default_costs
  • version 2 adds annual_avg_hours_per_year argument, variable and fixed O&M output
    • public.convert_design_capacity_to_mw
    • public.get_type3_equation_costs
    • public.get_type4_equation_costs
    • public.get_type5_equation_costs
    • public.get_type6_equation_costs
    • public.get_type10_equation_costs
    • public.get_strategy_costs (version 1)
    • public.get_default_costs
  • version 3 adds stack_temperature argument to version 2
    • public.get_type12_equation_costs
    • public.get_strategy_costs (version 2)
    • public.get_default_costs
  • called by:
    • public.run_annotate_inventory (version 1)
    • public.run_apply_measures_in_series_strategy (version 1)
    • public.run_project_future_year_inventory (version 1)

public.get_type1_equation_costs

  • defined in deploy/db/cost/functions/cost_equations_old_approach.sql
  • calls:
    • public.calculate_capital_recovery_factor
  • called by:
    • public.get_strategy_costs

public.get_type2_equation_costs

  • defined in deploy/db/cost/functions/cost_equations_old_approach.sql
  • calls:
    • public.calculate_capital_recovery_factor
  • called by:
    • public.get_strategy_costs

public.get_type7_equation_costs

  • defined in deploy/db/cost/functions/cost_equations_old_approach.sql
  • calls:
    • public.calculate_capital_recovery_factor
  • called by:
    • public.get_strategy_costs

public.get_type8_equation_costs

  • defined in deploy/db/cost/functions/cost_equations_old_approach.sql
  • calls:
    • public.calculate_capital_recovery_factor
  • called by:
    • public.get_strategy_costs

public.get_type9_equation_costs

  • defined in deploy/db/cost/functions/cost_equations_old_approach.sql
  • calls:
    • public.calculate_capital_recovery_factor
  • called by:
    • public.get_strategy_costs

public.get_type11_equation_costs

  • defined in deploy/db/cost/functions/cost_equations_old_approach.sql
  • calls:
    • public.calculate_capital_recovery_factor
  • called by:
    • public.get_strategy_costs

public.get_uncontrolled_ann_emis_expression

  • defined in deploy/db/cost/functions/get_uncontrolled_ann_emis_expression.sql
  • called by:
    • public.get_remaining_emis_expression
    • public.get_emis_reduction_expression

public.get_uncontrolled_emis_expression

  • defined in deploy/db/cost/functions/get_uncontrolled_emis_expression.sql
  • called by:
    • public.apply_cap_measures_on_hap_pollutants
    • public.get_cost_expressions
    • public.get_emis_reduction_expression
    • public.populate_least_cost_strategy_worksheet
    • public.run_max_emis_red_strategy
    • public.run_multi_pollutant_max_emis_red_strategy

public.isdate

  • defined in deploy/db/cost/functions/isdate.sql
  • called by:
    • public.validate_project_future_year_inventory_control_programs

public.join_with_ampersand

  • defined in deploy/db/cost/functions/utility.sql
  • called by:
    • public.concatenate_with_ampersand

public.multiply

  • defined in deploy/db/cost/functions/utility.sql
  • called by:
    • public.times

public.narrow_in_on_least_cost_target

  • defined in deploy/db/cost/functions/narrow_in_on_least_cost_target.sql
  • calls:
    • public.get_least_cost_worksheet_emis_reduction
  • called by:
    • public.populate_least_cost_strategy_detailed_result

public.populate_least_cost_strategy_detailed_result

  • defined in deploy/db/cost/functions/populate_least_cost_strategy_detailed_result.sql
  • calls:
    • public.alias_inventory_filter
    • public.get_dataset_month
    • public.get_days_in_month
    • public.build_version_where_filter
    • public.get_ann_emis_expression
    • public.get_least_cost_worksheet_emis_reduction
    • public.narrow_in_on_least_cost_target
  • called by:
    • LeastCostAbstractStrategyLoader.java

public.populate_least_cost_strategy_worksheet

  • defined in deploy/db/cost/functions/populate_least_cost_strategy_worksheet.sql
  • calls:
    • public.alias_filter
    • public.check_table_for_columns
    • public.concatenate_with_ampersand
    • public.get_dataset_month
    • public.get_days_in_month
    • public.get_days_in_year
    • public.build_version_where_filter
    • public.get_ann_emis_expression
    • public.get_uncontrolled_emis_expression
    • public.get_ceff_equation_expression
    • public.get_control_percent_reduction_expression
    • public.get_remaining_emis_expression
    • public.get_cost_expressions
  • called by:
    • LeastCostAbstractStrategyLoader.java

public.populate_project_future_year_inventory_strategy_messages.sql

  • defined in deploy/db/cost/functions/populate_project_future_year_inventory_strategy_messages.sql
  • calls:
    • public.build_version_where_filter
    • public.check_table_for_columns
    • public.alias_filter
    • public.build_project_future_year_inventory_matching_hierarchy_sql
  • called by:
    • projectFutureYearInventory/StrategyLoader.java

public.populate_sources_table

  • defined in deploy/db/cost/functions/populate_sources_table.sql
  • calls:
    • public.check_table_for_columns
    • public.alias_inventory_filter
  • called by:
    • AbstractStrategyTask.java
    • SQLCompareVOCSpeciationWithHAPInventoryQuery.java

public.populate_strategy_messages

  • defined in deploy/db/cost/functions/populate_strategy_messages.sql
  • calls:
    • public.alias_filter
    • public.check_table_for_columns
    • public.build_version_where_filter
  • called by:
    • AbstractStrategyLoader.java

public.run_annotate_inventory

  • defined in deploy/db/cost/functions/run_annotate_inventory.sql
  • calls:
    • public.alias_inventory_filter
    • public.check_table_for_columns
    • public.get_dataset_month
    • public.build_version_where_filter
    • public.get_strategy_costs
  • called by:
    • annotateinventory/StrategyLoader.java

public.run_apply_measures_in_series_strategy

  • defined in deploy/db/cost/functions/run_apply_measures_in_series_strategy.sql
  • calls:
    • public.concatenate_with_ampersand
    • public.alias_inventory_filter
    • public.check_table_for_columns
    • public.build_version_where_filter
    • public.get_dataset_month
    • public.get_strategy_costs
  • called by:
    • applyMeasuresInSeries/StrategyLoader.java

public.run_apply_measures_in_series_strategy_finalize

  • defined in deploy/db/cost/functions/run_apply_measures_in_series_strategy.sql
  • calls:
    • public.build_version_where_filter
    • public.times
  • called by:
    • applyMeasuresInSeries/StrategyLoader.java

public.run_max_emis_red_strategy

  • defined in deploy/db/cost/functions/run_max_emis_red_strategy.sql
  • calls:
    • public.concatenate_with_ampersand
    • public.alias_inventory_filter
    • public.check_table_for_columns
    • public.get_dataset_month
    • public.get_days_in_month
    • public.get_days_in_year
    • public.build_version_where_filter
    • public.get_ann_emis_expression
    • public.get_uncontrolled_emis_expression
    • public.get_ceff_equation_expression
    • public.get_control_percent_reduction_expression
    • public.get_remaining_emis_expression
    • public.get_cost_expressions
  • called by:
    • maxreduction/StrategyLoader.java

public.run_multi_pollutant_max_emis_red_strategy

  • defined in deploy/db/cost/functions/run_multi_pollutant_max_emis_red_strategy.sql
  • calls:
    • public.concatenate_with_ampersand
    • public.check_table_for_columns
    • public.alias_filter
    • public.get_dataset_month
    • public.get_days_in_month
    • public.get_days_in_year
    • public.build_version_where_filter
    • public.get_ann_emis_expression
    • public.get_uncontrolled_emis_expression
    • public.get_ceff_equation_expression
    • public.get_control_percent_reduction_expression
    • public.get_remaining_emis_expression
    • public.get_cost_expressions
  • called by:
    • multiPollutantMaxReduction/StrategyLoader.java

public.run_multi_pollutant_max_emis_red_strategy_finalize

  • defined in deploy/db/cost/functions/run_multi_pollutant_max_emis_red_strategy_finalize.sql
  • calls:
    • public.concatenate_with_ampersand
    • public.alias_inventory_filter
    • public.check_table_for_columns
    • public.get_dataset_month
    • public.get_strategy_costs
  • called by:
    • multiPollutantMaxReduction/StrategyLoader.java

public.run_project_future_year_inventory

  • defined in deploy/db/cost/functions/run_project_future_year_inventory.sql
  • calls:
    • public.check_table_for_columns
    • public.get_dataset_month
    • public.get_days_in_month
    • public.build_version_where_filter
    • public.alias_filter
    • public.build_project_future_year_inventory_matching_hierarchy_sql
    • public.get_strategy_costs
  • called by:
    • projectFutureYearInventory/StrategyLoader.java

public.run_temporal_allocation_daily_to_episode

  • defined in deploy/db/tempalloc/run_temporal_allocation_daily_to_episode.sql
  • calls:
    • public.check_table_for_columns
    • public.alias_inventory_filter
    • public.build_version_where_filter
  • called by:
    • TemporalAllocationTask.java

public.run_temporal_allocation_daily_to_month

  • defined in deploy/db/tempalloc/run_temporal_allocation_daily_to_month.sql
  • calls:
    • public.check_table_for_columns
    • public.alias_inventory_filter
    • public.build_version_where_filter
    • public.get_days_in_month
  • called by:
    • TemporalAllocationTask.java

public.run_temporal_allocation_to_day

  • defined in deploy/db/tempalloc/run_temporal_allocation_to_day.sql
  • calls:
    • public.check_table_for_columns
    • public.alias_inventory_filter
    • public.build_version_where_filter
  • called by:
    • TemporalAllocationTask.java

public.run_temporal_allocation_to_episode

  • defined in deploy/db/tempalloc/run_temporal_allocation_to_episode.sql
  • called by:
    • TemporalAllocationTask.java

public.run_temporal_allocation_to_month

  • defined in deploy/db/tempalloc/run_temporal_allocation_to_month.sql
  • calls:
    • public.alias_inventory_filter
    • public.build_version_where_filter
    • public.get_dataset_month
    • public.check_table_for_columns
    • public.get_days_in_month
  • called by:
    • TemporalAllocationTask.java

public.times [AGGREGATE]

  • defined in deploy/db/cost/functions/utility.sql
  • calls:
    • public.multiply
  • called by:
    • public.run_apply_measures_in_series_strategy_finalize

public.validate_project_future_year_inventory_control_programs

  • defined in deploy/db/cost/functions/validate_project_future_year_inventory_control_programs.sql
  • calls:
    • public.build_version_where_filter
    • public.check_table_for_columns
    • public.isdate
  • called by:
    • projectFutureYearInventory/StrategyTask.java
Add a custom footer
Add a custom sidebar

Clone this wiki locally