View graph

db_view_1 Database view

No documentation for this object

Depends on

Depended on by (none)

db_view_2 Database view

No documentation for this object

Depends on

Depended on by

db_view_3 Database view

No documentation for this object

Depends on

Depended on by

db_view_4 Database view

Documentation

This view contains miscellaneous other data for the current period.

Depends on

Depended on by

db_view_5 Database view

Documentation

This view contains miscellaneous other data for the previous period.

Depends on

Depended on by

db_view_6 Database view

No documentation for this object

Depends on

Depended on by

db_view_7 Database view

No documentation for this object

Depends on

Depended on by

db_view_8 Database view

No documentation for this object

Depends on

Depended on by

db_view_9 Database view

No documentation for this object

Depends on

Depended on by

db_view_10 Database view

No documentation for this object

Depends on

Depended on by

db_view_11 Database view

No documentation for this object

Depends on

Depended on by

db_view_12 Database view

No documentation for this object

Depends on

Depended on by

db_table_1 Database table

No documentation for this object

Depends on (none)

Depended on by

db_table_2 Database table

No documentation for this object

Depends on (none)

Depended on by

db_table_3 Database table

No documentation for this object

Depends on

Depended on by

db_table_4 Database table

No documentation for this object

Depends on

Depended on by

db_table_5 Database table

No documentation for this object

Depends on

Depended on by

db_table_6 Database table

No documentation for this object

Depends on

Depended on by (none)

db_table_7 Database table

No documentation for this object

Depends on

Depended on by

db_table_8 Database table

No documentation for this object

Depends on

Depended on by

db_table_9 Database table

No documentation for this object

Depends on (none)

Depended on by

db_table_10 Database table

Documentation

This table contains miscellaneous other data for current and historical periods.

Depends on

Depended on by

db_table_11 Database table

Documentation

This table contains miscellaneous other data for all periods. Where db_table_10 contains the latest data for each period, this table stores all updates to the miscellaneous items data.

Depends on

Depended on by (none)

db_table_12 Database table

Documentation

This table temporarily stores the miscellaneous other data for the current period while the data is being extracted and loaded to the database.

Depends on

Depended on by

db_table_13 Database table

No documentation for this object

Depends on (none)

Depended on by

db_table_14 Database table

No documentation for this object

Depends on (none)

Depended on by

db_table_15 Database table

No documentation for this object

Depends on

Depended on by

db_table_16 Database table

No documentation for this object

Depends on

Depended on by (none)

db_table_17 Database table

No documentation for this object

Depends on

Depended on by

db_table_18 Database table

No documentation for this object

Depends on

Depended on by

db_table_19 Database table

No documentation for this object

Depends on

Depended on by (none)

db_table_20 Database table

No documentation for this object

Depends on

Depended on by

db_table_21 Database table

No documentation for this object

Depends on (none)

Depended on by

db_table_22 Database table

No documentation for this object

Depends on (none)

Depended on by

db_table_23 Database table

No documentation for this object

Depends on (none)

Depended on by

db_table_24 Database table

No documentation for this object

Depends on

Depended on by

db_table_25 Database table

No documentation for this object

Depends on (none)

Depended on by

db_table_26 Database table

No documentation for this object

Depends on (none)

Depended on by

db_table_27 Database table

No documentation for this object

Depends on (none)

Depended on by

db_table_28 Database table

No documentation for this object

Depends on

Depended on by

db_table_29 Database table

No documentation for this object

Depends on

Depended on by (none)

db_table_30 Database table

No documentation for this object

Depends on

Depended on by

query1.sql Database query

No documentation for this object

Depends on

Depended on by (none)

query2.sql Database query

No documentation for this object

Depends on

Depended on by

query3.sql Database query

Documentation

This query returns some data needed for Report 5.

Depends on

Depended on by

query4.sql Database query

Documentation

This query returns some data needed for Report 6.

Depends on

Depended on by

query5.sql Database query

No documentation for this object

Depends on

Depended on by

query6.sql Database query

No documentation for this object

Depends on

Depended on by

query7.sql Database query

No documentation for this object

Depends on

Depended on by

query8.sql Database query

No documentation for this object

Depends on

Depended on by

query9.sql Database query

No documentation for this object

Depends on

Depended on by

query10.sql Database query

No documentation for this object

Depends on

Depended on by

query11.sql Database query

No documentation for this object

Depends on

Depended on by

query12.sql Database query

No documentation for this object

Depends on

Depended on by

query13.sql Database query

No documentation for this object

Depends on

Depended on by

query14.sql Database query

No documentation for this object

Depends on

Depended on by

query15.sql Database query

No documentation for this object

Depends on

Depended on by

query16.sql Database query

No documentation for this object

Depends on

Depended on by

query17.sql Database query

No documentation for this object

Depends on

Depended on by

query18.sql Database query

No documentation for this object

Depends on

Depended on by

query19.sql Database query

No documentation for this object

Depends on

Depended on by

query20.sql Database query

No documentation for this object

Depends on

Depended on by

query21.sql Database query

No documentation for this object

Depends on

Depended on by

query22.sql Database query

No documentation for this object

Depends on

Depended on by

query23.sql Database query

No documentation for this object

Depends on

Depended on by

query24.sql Database query

No documentation for this object

Depends on

Depended on by

query25.sql Database query

No documentation for this object

Depends on

Depended on by (none)

query26.sql Database query

No documentation for this object

Depends on

Depended on by (none)

query27.sql Database query

No documentation for this object

Depends on

Depended on by (none)

query28.sql Database query

No documentation for this object

Depends on

Depended on by (none)

query29.sql Database query

No documentation for this object

Depends on

Depended on by (none)

query30.sql Database query

No documentation for this object

Depends on

Depended on by (none)

query31.sql Database query

No documentation for this object

Depends on

Depended on by (none)

SASProject.egp SAS project

No documentation for this object

Depends on (none)

Depended on by

ETL process 1 Extract-transform-load process

No documentation for this object

Depends on (none)

Depended on by

ETL process 2 Extract-transform-load process

No documentation for this object

Depends on (none)

Depended on by

ETL process 3 Extract-transform-load process

No documentation for this object

Depends on (none)

Depended on by

ETL process 4 Extract-transform-load process

No documentation for this object

Depends on (none)

Depended on by

ETL process 5 Extract-transform-load process

No documentation for this object

Depends on (none)

Depended on by

Data store 1 Access database

Documentation

The database that provides some data for Report 5, Report 6, and Intermediate step 3. It is located at:

/path/Data store 1

This database contains some simple mapping logic that takes the results of the query2.sql query and splits it into one query for each of the Intermediate step 3 files.

Depends on

Depended on by

Data store 2 Access database

Documentation

The database that provides the data for the reports and the upstream reports. It is located at:

/path/Data store 2

Depends on

Depended on by

Data store 3 Access database

Documentation

The database that provides some data for Report 5. It is located at:

/path/Data store 3

Depends on

Depended on by

Data store 4 Access database

Documentation

The database that provides some data for Report 6. It is located at:

/path/Utilization_Triangles\Data store 3

Depends on

Depended on by

Intermediate step 1 Report

No documentation for this object

Depends on

Depended on by

Intermediate step 2 Report

No documentation for this object

Depends on

Depended on by

Report 1 Report

No documentation for this object

Depends on

Depended on by (none)

Report 2 Report

No documentation for this object

Depends on

Depended on by (none)

Report 3 Report

No documentation for this object

Depends on

Depended on by (none)

Report 4 Report

No documentation for this object

Depends on

Depended on by (none)

Report 5 Report

No documentation for this object

Depends on

Depended on by

Intermediate step 3 Report

No documentation for this object

Depends on

Depended on by (none)

Report 6 Report

No documentation for this object

Depends on

Depended on by (none)

Upstream report 1 Report

Documentation

This file is used to report some stuff upstream. It is located at:

/path/Upstream report 1

It uses the following queries as data sources:

Depends on

Depended on by (none)

Upstream report 2 Report

Documentation

This file is used to report some other stuff upstream. It is located at:

/path/Upstream report 2

It uses the following queries as data sources:

Depends on

Depended on by (none)

Upstream report 3 Report

Documentation

This file is used to report even more stuff upstream. It is located at:

/path/Upstream report 3

It uses the following queries as data sources:

Depends on

Depended on by (none)