db_view_1 Database view

Depends on

• db_table_15
• db_table_14
• db_table_1

Depended on by (none)

db_view_2 Database view

Depends on

• db_table_4
• db_table_14

Depended on by

• query9.sql
• query11.sql

db_view_3 Database view

Depends on

• db_table_5
• db_table_14

Depended on by

• query12.sql
• query28.sql

db_view_4 Database view

Documentation

This view contains miscellaneous other data for the current period.

Depends on

• db_table_10
• db_table_14

Depended on by

• query7.sql
• query9.sql
• query13.sql
• query22.sql

db_view_5 Database view

Documentation

This view contains miscellaneous other data for the previous period.

Depends on

• db_table_10
• db_table_14

Depended on by

• query22.sql

db_view_6 Database view

Depends on

• db_table_10

Depended on by

• db_view_7

db_view_7 Database view

Depends on

• db_view_6
• db_table_14

Depended on by

• query9.sql
• query17.sql

db_view_8 Database view

Depends on

• db_table_15
• db_table_14

Depended on by

• query27.sql
• query31.sql

db_view_9 Database view

Depends on

• db_table_18
• db_table_14

Depended on by

• query5.sql
• query6.sql
• query7.sql
• query8.sql
• query9.sql
• query14.sql
• query15.sql
• query18.sql
• query20.sql
• query21.sql
• query25.sql
• query26.sql
• query31.sql

db_view_10 Database view

Depends on

• db_table_18
• db_table_14

Depended on by

• query20.sql
• query21.sql

db_view_11 Database view

Depends on

• db_table_24
• db_table_14

Depended on by

• query16.sql
• query29.sql

db_view_12 Database view

Depends on

• db_table_28
• db_table_14

Depended on by

• query6.sql
• query30.sql

db_table_1 Database table

Depends on (none)

Depended on by

• db_view_1

db_table_2 Database table

Depends on (none)

Depended on by

• query10.sql

db_table_3 Database table

Depends on

• SASProject.egp

Depended on by

• db_table_4

db_table_4 Database table

Depends on

• SASProject.egp
• db_table_3

Depended on by

• db_view_2
• query2.sql
• query3.sql
• query4.sql

db_table_5 Database table

Depends on

• db_table_7
• ETL process 1

Depended on by

• db_view_3

db_table_6 Database table

Depends on

• ETL process 1

Depended on by (none)

db_table_7 Database table

Depends on

• ETL process 1

Depended on by

• db_table_5

db_table_8 Database table

Depends on

• query5.sql

Depended on by

• query19.sql

db_table_9 Database table

Depends on (none)

Depended on by

• query1.sql

db_table_10 Database table

Documentation

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

Depends on

• db_table_12
• ETL process 2

Depended on by

• db_view_4
• db_view_5
• db_view_6

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

• ETL process 2

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

• ETL process 2

Depended on by

• db_table_10

db_table_13 Database table

Depends on (none)

Depended on by

• query18.sql
• query19.sql
• query31.sql

db_table_14 Database table

Depends on (none)

Depended on by

• db_view_1
• db_view_2
• db_view_3
• db_view_4
• db_view_5
• db_view_7
• db_view_8
• db_view_9
• db_view_10
• db_view_11
• db_view_12
• query5.sql
• query6.sql
• query10.sql
• query18.sql
• query19.sql
• query20.sql
• query21.sql
• query22.sql
• query23.sql
• query24.sql
• query31.sql

db_table_15 Database table

Depends on

• db_table_17
• ETL process 3

Depended on by

• db_view_1
• db_view_8
• query23.sql

db_table_16 Database table

Depends on

• ETL process 3

Depended on by (none)

db_table_17 Database table

Depends on

• ETL process 3

Depended on by

• db_table_15

db_table_18 Database table

Depends on

• db_table_20
• ETL process 4

Depended on by

• db_view_9
• db_view_10
• query9.sql
• query18.sql
• query19.sql

db_table_19 Database table

Depends on

• ETL process 4

Depended on by (none)

db_table_20 Database table

Depends on

• ETL process 4

Depended on by

• db_table_18

db_table_21 Database table

Depends on (none)

Depended on by

• query31.sql

db_table_22 Database table

Depends on (none)

Depended on by

• query1.sql

db_table_23 Database table

Depends on (none)

Depended on by

• query1.sql

db_table_24 Database table

Depends on

• query6.sql

Depended on by

• db_view_11

db_table_25 Database table

Depends on (none)

Depended on by

• query6.sql

db_table_26 Database table

Depends on (none)

Depended on by

• query6.sql

db_table_27 Database table

Depends on (none)

Depended on by

• query6.sql
• query16.sql

db_table_28 Database table

Depends on

• db_table_30
• ETL process 5

Depended on by

• db_view_12
• query24.sql

db_table_29 Database table

Depends on

• ETL process 5

Depended on by (none)

db_table_30 Database table

Depends on

• ETL process 5

Depended on by

• db_table_28

query1.sql Database query

Depends on

• db_table_9
• db_table_23
• db_table_22

Depended on by (none)

query2.sql Database query

Depends on

• db_table_4

Depended on by

• Data store 1

query3.sql Database query

Documentation

This query returns some data needed for Report 5.

Depends on

• db_table_4

Depended on by

• Data store 1

query4.sql Database query

Documentation

This query returns some data needed for Report 6.

Depends on

• db_table_4

Depended on by

• Data store 1

query5.sql Database query

Depends on

• db_view_9
• db_table_14

Depended on by

• db_table_8

query6.sql Database query

Depends on

• db_view_12
• db_table_25
• db_table_26
• db_table_27
• db_view_9
• db_table_14

Depended on by

• db_table_24

query7.sql Database query

Depends on

• db_view_4
• db_view_9

Depended on by

• Data store 2

query8.sql Database query

Depends on

• db_view_9

Depended on by

• Data store 2

query9.sql Database query

Depends on

• db_view_9
• db_view_4
• db_view_2
• db_view_7
• db_table_18

Depended on by

• Data store 2

query10.sql Database query

Depends on

• db_table_2
• db_table_14

Depended on by

• Data store 2

query11.sql Database query

Depends on

• db_view_2

Depended on by

• Data store 2

query12.sql Database query

Depends on

• db_view_3

Depended on by

• Data store 2

query13.sql Database query

Depends on

• db_view_4

Depended on by

• Data store 2

query14.sql Database query

Depends on

• db_view_9

Depended on by

• Data store 2

query15.sql Database query

Depends on

• db_view_9

Depended on by

• Data store 2

query16.sql Database query

Depends on

• db_view_11
• db_table_27

Depended on by

• Data store 2

query17.sql Database query

Depends on

• db_view_7

Depended on by

• Data store 2

query18.sql Database query

Depends on

• db_table_18
• db_table_13
• db_table_14
• db_view_9

Depended on by

• Data store 2

query19.sql Database query

Depends on

• db_table_18
• db_table_13
• db_table_14
• db_table_8

Depended on by

• Data store 2

query20.sql Database query

Depends on

• db_view_9
• db_view_10
• db_table_14

Depended on by

• Data store 2

query21.sql Database query

Depends on

• db_view_9
• db_view_10
• db_table_14

Depended on by

• Data store 2

query22.sql Database query

Depends on

• db_view_4
• db_view_5
• db_table_14

Depended on by

• Data store 2

query23.sql Database query

Depends on

• db_table_15
• db_table_14

Depended on by

• Data store 3

query24.sql Database query

Depends on

• db_table_28
• db_table_14

Depended on by

• Data store 4

query25.sql Database query

Depends on

• db_view_9

Depended on by (none)

query26.sql Database query

Depends on

• db_view_9

Depended on by (none)

query27.sql Database query

Depends on

• db_view_8

Depended on by (none)

query28.sql Database query

Depends on

• db_view_3

Depended on by (none)

query29.sql Database query

Depends on

• db_view_11

Depended on by (none)

query30.sql Database query

Depends on

• db_view_12

Depended on by (none)

query31.sql Database query

Depends on

• db_view_9
• db_view_8
• db_table_21
• db_table_14
• db_table_13

Depended on by (none)

SASProject.egp SAS project

Depends on (none)

Depended on by

• db_table_3
• db_table_4

ETL process 1 Extract-transform-load process

Depends on (none)

Depended on by

• db_table_5
• db_table_6
• db_table_7

ETL process 2 Extract-transform-load process

Depends on (none)

Depended on by

• db_table_10
• db_table_11
• db_table_12

ETL process 3 Extract-transform-load process

Depends on (none)

Depended on by

• db_table_15
• db_table_16
• db_table_17

ETL process 4 Extract-transform-load process

Depends on (none)

Depended on by

• db_table_18
• db_table_19
• db_table_20

ETL process 5 Extract-transform-load process

Depends on (none)

Depended on by

• db_table_28
• db_table_29
• db_table_30

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

• query2.sql
• query3.sql
• query4.sql

Depended on by

• Intermediate step 1
• Intermediate step 2
• Intermediate step 3

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

• query7.sql
• query8.sql
• query9.sql
• query10.sql
• query11.sql
• query12.sql
• query13.sql
• query14.sql
• query15.sql
• query16.sql
• query17.sql
• query18.sql
• query19.sql
• query20.sql
• query21.sql
• query22.sql

Depended on by

• Report 1
• Report 2
• Report 3
• Report 4
• Upstream report 1
• Upstream report 2
• Upstream report 3

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

• query23.sql

Depended on by

• Report 5

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

• query24.sql

Depended on by

• Report 6

Intermediate step 1 Report

Depends on

• Data store 1

Depended on by

• Report 6

Intermediate step 2 Report

Depends on

• Data store 1

Depended on by

• Report 5

Report 1 Report

Depends on

• Data store 2

Depended on by (none)

Report 2 Report

Depends on

• Data store 2

Depended on by (none)

Report 3 Report

Depends on

• Data store 2

Depended on by (none)

Report 4 Report

Depends on

• Data store 2

Depended on by (none)

Report 5 Report

Depends on

• Data store 3
• Intermediate step 2

Depended on by

• Intermediate step 3

Intermediate step 3 Report

Depends on

• Report 5
• Data store 1

Depended on by (none)

Report 6 Report

Depends on

• Data store 4
• Intermediate step 1

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:

• query14.sql

Depends on

• Data store 2

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:

• query15.sql

Depends on

• Data store 2

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:

• query16.sql

Depends on

• Data store 2

Depended on by (none)