tri_tri_source_reduct_qty: Retrieve tri source reduct qty data from tri database

Description Usage Arguments

Description

Retrieve tri source reduct qty data from tri database

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
tri_tri_source_reduct_qty(DOC_CTRL_NUM = NULL,
  RECYC_ONSITE_CURR_YR_QTY = NULL, RECYC_ONSITE_CURR_YR_NA = NULL,
  RECYC_ONSITE_PREV_YR_QTY = NULL, RECYC_ONSITE_PREV_YR_NA = NULL,
  RECYC_ONSITE_FOLL_YR_QTY = NULL, RECYC_ONSITE_FOLL_YR_NA = NULL,
  RECYC_ONSITE_SECD_YR_QTY = NULL, RECYC_ONSITE_SECD_YR_NA = NULL,
  RECYC_OFFSITE_CURR_YR_QTY = NULL, RECYC_OFFSITE_CURR_YR_NA = NULL,
  RECYC_OFFSITE_PREV_YR_QTY = NULL, RECYC_OFFSITE_PREV_YR_NA = NULL,
  RECYC_OFFSITE_FOLL_YR_QTY = NULL, RECYC_OFFSITE_FOLL_YR_NA = NULL,
  RECYC_OFFSITE_SECD_YR_QTY = NULL, RECYC_OFFSITE_SECD_YR_NA = NULL,
  ENERGY_ONSITE_CURR_YR_QTY = NULL, ENERGY_ONSITE_CURR_YR_NA = NULL,
  ENERGY_ONSITE_PREV_YR_QTY = NULL, ENERGY_ONSITE_PREV_YR_NA = NULL,
  ENERGY_ONSITE_FOLL_YR_QTY = NULL, ENERGY_ONSITE_FOLL_YR_NA = NULL,
  ENERGY_ONSITE_SECD_YR_QTY = NULL, ENERGY_ONSITE_SECD_YR_NA = NULL,
  ENERGY_OFFSITE_CURR_YR_QTY = NULL, ENERGY_OFFSITE_CURR_YR_NA = NULL,
  ENERGY_OFFSITE_PREV_YR_QTY = NULL, ENERGY_OFFSITE_PREV_YR_NA = NULL,
  ENERGY_OFFSITE_FOLL_YR_QTY = NULL, ENERGY_OFFSITE_FOLL_YR_NA = NULL,
  ENERGY_OFFSITE_SECD_YR_QTY = NULL, ENERGY_OFFSITE_SECD_YR_NA = NULL,
  TREATED_ONSITE_CURR_YR_QTY = NULL, TREATED_ONSITE_CURR_YR_NA = NULL,
  TREATED_ONSITE_PREV_YR_QTY = NULL, TREATED_ONSITE_PREV_YR_NA = NULL,
  TREATED_ONSITE_FOLL_YR_QTY = NULL, TREATED_ONSITE_FOLL_YR_NA = NULL,
  TREATED_ONSITE_SECD_YR_QTY = NULL, TREATED_ONSITE_SECD_YR_NA = NULL,
  TREATED_OFFSITE_CURR_YR_QTY = NULL,
  TREATED_OFFSITE_CURR_YR_NA = NULL,
  TREATED_OFFSITE_PREV_YR_QTY = NULL,
  TREATED_OFFSITE_PREV_YR_NA = NULL,
  TREATED_OFFSITE_FOLL_YR_QTY = NULL,
  TREATED_OFFSITE_FOLL_YR_NA = NULL,
  TREATED_OFFSITE_SECD_YR_QTY = NULL,
  TREATED_OFFSITE_SECD_YR_NA = NULL, REL_CURR_YR_QTY = NULL,
  REL_CURR_YR_NA = NULL, REL_PREV_YR_QTY = NULL,
  REL_PREV_YR_NA = NULL, REL_FOLL_YR_QTY = NULL,
  REL_FOLL_YR_NA = NULL, REL_SECD_YR_QTY = NULL,
  REL_SECD_YR_NA = NULL, REL_81A_CURR_YR_QTY = NULL,
  REL_81A_CURR_YR_NA = NULL, REL_81A_PREV_YR_QTY = NULL,
  REL_81A_PREV_YR_NA = NULL, REL_81A_FOLL_YR_QTY = NULL,
  REL_81A_FOLL_YR_NA = NULL, REL_81A_SECD_YR_QTY = NULL,
  REL_81A_SECD_YR_NA = NULL, REL_81B_CURR_YR_QTY = NULL,
  REL_81B_CURR_YR_NA = NULL, REL_81B_PREV_YR_QTY = NULL,
  REL_81B_PREV_YR_NA = NULL, REL_81B_FOLL_YR_QTY = NULL,
  REL_81B_FOLL_YR_NA = NULL, REL_81B_SECD_YR_QTY = NULL,
  REL_81B_SECD_YR_NA = NULL, REL_81C_CURR_YR_QTY = NULL,
  REL_81C_CURR_YR_NA = NULL, REL_81C_PREV_YR_QTY = NULL,
  REL_81C_PREV_YR_NA = NULL, REL_81C_FOLL_YR_QTY = NULL,
  REL_81C_FOLL_YR_NA = NULL, REL_81C_SECD_YR_QTY = NULL,
  REL_81C_SECD_YR_NA = NULL, REL_81D_CURR_YR_QTY = NULL,
  REL_81D_CURR_YR_NA = NULL, REL_81D_PREV_YR_QTY = NULL,
  REL_81D_PREV_YR_NA = NULL, REL_81D_FOLL_YR_QTY = NULL,
  REL_81D_FOLL_YR_NA = NULL, REL_81D_SECD_YR_QTY = NULL,
  REL_81D_SECD_YR_NA = NULL)

Arguments

DOC_CTRL_NUM

e.g. '1300140000011'. See Details.

RECYC_ONSITE_CURR_YR_QTY

e.g. '70000'. See Details.

RECYC_ONSITE_CURR_YR_NA

e.g. '0'. See Details.

RECYC_ONSITE_PREV_YR_QTY

e.g. '65000'. See Details.

RECYC_ONSITE_PREV_YR_NA

e.g. '0'. See Details.

RECYC_ONSITE_FOLL_YR_QTY

e.g. '70000'. See Details.

RECYC_ONSITE_FOLL_YR_NA

e.g. '0'. See Details.

RECYC_ONSITE_SECD_YR_QTY

e.g. '70000'. See Details.

RECYC_ONSITE_SECD_YR_NA

e.g. '0'. See Details.

RECYC_OFFSITE_CURR_YR_QTY

e.g. '174020'. See Details.

RECYC_OFFSITE_CURR_YR_NA

e.g. '0'. See Details.

RECYC_OFFSITE_PREV_YR_QTY

e.g. '241502'. See Details.

RECYC_OFFSITE_PREV_YR_NA

e.g. '0'. See Details.

RECYC_OFFSITE_FOLL_YR_QTY

e.g. '170000'. See Details.

RECYC_OFFSITE_FOLL_YR_NA

e.g. '0'. See Details.

RECYC_OFFSITE_SECD_YR_QTY

e.g. '160000'. See Details.

RECYC_OFFSITE_SECD_YR_NA

e.g. '0'. See Details.

ENERGY_ONSITE_CURR_YR_QTY

e.g. '0'. See Details.

ENERGY_ONSITE_CURR_YR_NA

e.g. '0'. See Details.

ENERGY_ONSITE_PREV_YR_QTY

e.g. '0'. See Details.

ENERGY_ONSITE_PREV_YR_NA

e.g. '0'. See Details.

ENERGY_ONSITE_FOLL_YR_QTY

e.g. '0'. See Details.

ENERGY_ONSITE_FOLL_YR_NA

e.g. '0'. See Details.

ENERGY_ONSITE_SECD_YR_QTY

e.g. '0'. See Details.

ENERGY_ONSITE_SECD_YR_NA

e.g. '0'. See Details.

ENERGY_OFFSITE_CURR_YR_QTY

e.g. '0'. See Details.

ENERGY_OFFSITE_CURR_YR_NA

e.g. '0'. See Details.

ENERGY_OFFSITE_PREV_YR_QTY

e.g. '0'. See Details.

ENERGY_OFFSITE_PREV_YR_NA

e.g. '0'. See Details.

ENERGY_OFFSITE_FOLL_YR_QTY

e.g. '0'. See Details.

ENERGY_OFFSITE_FOLL_YR_NA

e.g. '0'. See Details.

ENERGY_OFFSITE_SECD_YR_QTY

e.g. '0'. See Details.

ENERGY_OFFSITE_SECD_YR_NA

e.g. '0'. See Details.

TREATED_ONSITE_CURR_YR_QTY

e.g. '200'. See Details.

TREATED_ONSITE_CURR_YR_NA

e.g. '0'. See Details.

TREATED_ONSITE_PREV_YR_QTY

e.g. '0'. See Details.

TREATED_ONSITE_PREV_YR_NA

e.g. '0'. See Details.

TREATED_ONSITE_FOLL_YR_QTY

e.g. '250'. See Details.

TREATED_ONSITE_FOLL_YR_NA

e.g. '0'. See Details.

TREATED_ONSITE_SECD_YR_QTY

e.g. '250'. See Details.

TREATED_ONSITE_SECD_YR_NA

e.g. '0'. See Details.

TREATED_OFFSITE_CURR_YR_QTY

e.g. '0'. See Details.

TREATED_OFFSITE_CURR_YR_NA

e.g. '0'. See Details.

TREATED_OFFSITE_PREV_YR_QTY

e.g. '0'. See Details.

TREATED_OFFSITE_PREV_YR_NA

e.g. '0'. See Details.

TREATED_OFFSITE_FOLL_YR_QTY

e.g. '0'. See Details.

TREATED_OFFSITE_FOLL_YR_NA

e.g. '0'. See Details.

TREATED_OFFSITE_SECD_YR_QTY

e.g. '0'. See Details.

TREATED_OFFSITE_SECD_YR_NA

e.g. '0'. See Details.

REL_CURR_YR_QTY

e.g. '190'. See Details.

REL_CURR_YR_NA

e.g. '0'. See Details.

REL_PREV_YR_QTY

e.g. '220'. See Details.

REL_PREV_YR_NA

e.g. '0'. See Details.

REL_FOLL_YR_QTY

e.g. '180'. See Details.

REL_FOLL_YR_NA

e.g. '0'. See Details.

REL_SECD_YR_QTY

e.g. '170'. See Details.

REL_SECD_YR_NA

e.g. '0'. See Details.

REL_81A_CURR_YR_QTY

e.g. 'NA'. See Details.

REL_81A_CURR_YR_NA

e.g. 'NA'. See Details.

REL_81A_PREV_YR_QTY

e.g. 'NA'. See Details.

REL_81A_PREV_YR_NA

e.g. 'NA'. See Details.

REL_81A_FOLL_YR_QTY

e.g. 'NA'. See Details.

REL_81A_FOLL_YR_NA

e.g. 'NA'. See Details.

REL_81A_SECD_YR_QTY

e.g. 'NA'. See Details.

REL_81A_SECD_YR_NA

e.g. 'NA'. See Details.

REL_81B_CURR_YR_QTY

e.g. 'NA'. See Details.

REL_81B_CURR_YR_NA

e.g. 'NA'. See Details.

REL_81B_PREV_YR_QTY

e.g. 'NA'. See Details.

REL_81B_PREV_YR_NA

e.g. 'NA'. See Details.

REL_81B_FOLL_YR_QTY

e.g. 'NA'. See Details.

REL_81B_FOLL_YR_NA

e.g. 'NA'. See Details.

REL_81B_SECD_YR_QTY

e.g. 'NA'. See Details.

REL_81B_SECD_YR_NA

e.g. 'NA'. See Details.

REL_81C_CURR_YR_QTY

e.g. 'NA'. See Details.

REL_81C_CURR_YR_NA

e.g. 'NA'. See Details.

REL_81C_PREV_YR_QTY

e.g. 'NA'. See Details.

REL_81C_PREV_YR_NA

e.g. 'NA'. See Details.

REL_81C_FOLL_YR_QTY

e.g. 'NA'. See Details.

REL_81C_FOLL_YR_NA

e.g. 'NA'. See Details.

REL_81C_SECD_YR_QTY

e.g. 'NA'. See Details.

REL_81C_SECD_YR_NA

e.g. 'NA'. See Details.

REL_81D_CURR_YR_QTY

e.g. 'NA'. See Details.

REL_81D_CURR_YR_NA

e.g. 'NA'. See Details.

REL_81D_PREV_YR_QTY

e.g. 'NA'. See Details.

REL_81D_PREV_YR_NA

e.g. 'NA'. See Details.

REL_81D_FOLL_YR_QTY

e.g. 'NA'. See Details.

REL_81D_FOLL_YR_NA

e.g. 'NA'. See Details.

REL_81D_SECD_YR_QTY

e.g. 'NA'. See Details.

REL_81D_SECD_YR_NA

e.g. 'NA'. See Details.


markwh/envirofacts documentation built on May 21, 2019, 12:26 p.m.