R/tri_tri_source_reduct_qty.R

#' Retrieve tri source reduct qty data from tri database
#' 
#' @param DOC_CTRL_NUM e.g. '1300140000011'. See Details.
#' @param RECYC_ONSITE_CURR_YR_QTY e.g. '70000'. See Details.
#' @param RECYC_ONSITE_CURR_YR_NA e.g. '0'. See Details.
#' @param RECYC_ONSITE_PREV_YR_QTY e.g. '65000'. See Details.
#' @param RECYC_ONSITE_PREV_YR_NA e.g. '0'. See Details.
#' @param RECYC_ONSITE_FOLL_YR_QTY e.g. '70000'. See Details.
#' @param RECYC_ONSITE_FOLL_YR_NA e.g. '0'. See Details.
#' @param RECYC_ONSITE_SECD_YR_QTY e.g. '70000'. See Details.
#' @param RECYC_ONSITE_SECD_YR_NA e.g. '0'. See Details.
#' @param RECYC_OFFSITE_CURR_YR_QTY e.g. '174020'. See Details.
#' @param RECYC_OFFSITE_CURR_YR_NA e.g. '0'. See Details.
#' @param RECYC_OFFSITE_PREV_YR_QTY e.g. '241502'. See Details.
#' @param RECYC_OFFSITE_PREV_YR_NA e.g. '0'. See Details.
#' @param RECYC_OFFSITE_FOLL_YR_QTY e.g. '170000'. See Details.
#' @param RECYC_OFFSITE_FOLL_YR_NA e.g. '0'. See Details.
#' @param RECYC_OFFSITE_SECD_YR_QTY e.g. '160000'. See Details.
#' @param RECYC_OFFSITE_SECD_YR_NA e.g. '0'. See Details.
#' @param ENERGY_ONSITE_CURR_YR_QTY e.g. '0'. See Details.
#' @param ENERGY_ONSITE_CURR_YR_NA e.g. '0'. See Details.
#' @param ENERGY_ONSITE_PREV_YR_QTY e.g. '0'. See Details.
#' @param ENERGY_ONSITE_PREV_YR_NA e.g. '0'. See Details.
#' @param ENERGY_ONSITE_FOLL_YR_QTY e.g. '0'. See Details.
#' @param ENERGY_ONSITE_FOLL_YR_NA e.g. '0'. See Details.
#' @param ENERGY_ONSITE_SECD_YR_QTY e.g. '0'. See Details.
#' @param ENERGY_ONSITE_SECD_YR_NA e.g. '0'. See Details.
#' @param ENERGY_OFFSITE_CURR_YR_QTY e.g. '0'. See Details.
#' @param ENERGY_OFFSITE_CURR_YR_NA e.g. '0'. See Details.
#' @param ENERGY_OFFSITE_PREV_YR_QTY e.g. '0'. See Details.
#' @param ENERGY_OFFSITE_PREV_YR_NA e.g. '0'. See Details.
#' @param ENERGY_OFFSITE_FOLL_YR_QTY e.g. '0'. See Details.
#' @param ENERGY_OFFSITE_FOLL_YR_NA e.g. '0'. See Details.
#' @param ENERGY_OFFSITE_SECD_YR_QTY e.g. '0'. See Details.
#' @param ENERGY_OFFSITE_SECD_YR_NA e.g. '0'. See Details.
#' @param TREATED_ONSITE_CURR_YR_QTY e.g. '200'. See Details.
#' @param TREATED_ONSITE_CURR_YR_NA e.g. '0'. See Details.
#' @param TREATED_ONSITE_PREV_YR_QTY e.g. '0'. See Details.
#' @param TREATED_ONSITE_PREV_YR_NA e.g. '0'. See Details.
#' @param TREATED_ONSITE_FOLL_YR_QTY e.g. '250'. See Details.
#' @param TREATED_ONSITE_FOLL_YR_NA e.g. '0'. See Details.
#' @param TREATED_ONSITE_SECD_YR_QTY e.g. '250'. See Details.
#' @param TREATED_ONSITE_SECD_YR_NA e.g. '0'. See Details.
#' @param TREATED_OFFSITE_CURR_YR_QTY e.g. '0'. See Details.
#' @param TREATED_OFFSITE_CURR_YR_NA e.g. '0'. See Details.
#' @param TREATED_OFFSITE_PREV_YR_QTY e.g. '0'. See Details.
#' @param TREATED_OFFSITE_PREV_YR_NA e.g. '0'. See Details.
#' @param TREATED_OFFSITE_FOLL_YR_QTY e.g. '0'. See Details.
#' @param TREATED_OFFSITE_FOLL_YR_NA e.g. '0'. See Details.
#' @param TREATED_OFFSITE_SECD_YR_QTY e.g. '0'. See Details.
#' @param TREATED_OFFSITE_SECD_YR_NA e.g. '0'. See Details.
#' @param REL_CURR_YR_QTY e.g. '190'. See Details.
#' @param REL_CURR_YR_NA e.g. '0'. See Details.
#' @param REL_PREV_YR_QTY e.g. '220'. See Details.
#' @param REL_PREV_YR_NA e.g. '0'. See Details.
#' @param REL_FOLL_YR_QTY e.g. '180'. See Details.
#' @param REL_FOLL_YR_NA e.g. '0'. See Details.
#' @param REL_SECD_YR_QTY e.g. '170'. See Details.
#' @param REL_SECD_YR_NA e.g. '0'. See Details.
#' @param REL_81A_CURR_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81A_CURR_YR_NA e.g. 'NA'. See Details.
#' @param REL_81A_PREV_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81A_PREV_YR_NA e.g. 'NA'. See Details.
#' @param REL_81A_FOLL_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81A_FOLL_YR_NA e.g. 'NA'. See Details.
#' @param REL_81A_SECD_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81A_SECD_YR_NA e.g. 'NA'. See Details.
#' @param REL_81B_CURR_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81B_CURR_YR_NA e.g. 'NA'. See Details.
#' @param REL_81B_PREV_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81B_PREV_YR_NA e.g. 'NA'. See Details.
#' @param REL_81B_FOLL_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81B_FOLL_YR_NA e.g. 'NA'. See Details.
#' @param REL_81B_SECD_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81B_SECD_YR_NA e.g. 'NA'. See Details.
#' @param REL_81C_CURR_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81C_CURR_YR_NA e.g. 'NA'. See Details.
#' @param REL_81C_PREV_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81C_PREV_YR_NA e.g. 'NA'. See Details.
#' @param REL_81C_FOLL_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81C_FOLL_YR_NA e.g. 'NA'. See Details.
#' @param REL_81C_SECD_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81C_SECD_YR_NA e.g. 'NA'. See Details.
#' @param REL_81D_CURR_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81D_CURR_YR_NA e.g. 'NA'. See Details.
#' @param REL_81D_PREV_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81D_PREV_YR_NA e.g. 'NA'. See Details.
#' @param REL_81D_FOLL_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81D_FOLL_YR_NA e.g. 'NA'. See Details.
#' @param REL_81D_SECD_YR_QTY e.g. 'NA'. See Details.
#' @param REL_81D_SECD_YR_NA e.g. 'NA'. See Details.
#' @export

tri_tri_source_reduct_qty <- function(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) {
    
    args <- list(DOC_CTRL_NUM = DOC_CTRL_NUM, RECYC_ONSITE_CURR_YR_QTY = RECYC_ONSITE_CURR_YR_QTY, 
        RECYC_ONSITE_CURR_YR_NA = RECYC_ONSITE_CURR_YR_NA, RECYC_ONSITE_PREV_YR_QTY = RECYC_ONSITE_PREV_YR_QTY, 
        RECYC_ONSITE_PREV_YR_NA = RECYC_ONSITE_PREV_YR_NA, RECYC_ONSITE_FOLL_YR_QTY = RECYC_ONSITE_FOLL_YR_QTY, 
        RECYC_ONSITE_FOLL_YR_NA = RECYC_ONSITE_FOLL_YR_NA, RECYC_ONSITE_SECD_YR_QTY = RECYC_ONSITE_SECD_YR_QTY, 
        RECYC_ONSITE_SECD_YR_NA = RECYC_ONSITE_SECD_YR_NA, RECYC_OFFSITE_CURR_YR_QTY = RECYC_OFFSITE_CURR_YR_QTY, 
        RECYC_OFFSITE_CURR_YR_NA = RECYC_OFFSITE_CURR_YR_NA, RECYC_OFFSITE_PREV_YR_QTY = RECYC_OFFSITE_PREV_YR_QTY, 
        RECYC_OFFSITE_PREV_YR_NA = RECYC_OFFSITE_PREV_YR_NA, RECYC_OFFSITE_FOLL_YR_QTY = RECYC_OFFSITE_FOLL_YR_QTY, 
        RECYC_OFFSITE_FOLL_YR_NA = RECYC_OFFSITE_FOLL_YR_NA, RECYC_OFFSITE_SECD_YR_QTY = RECYC_OFFSITE_SECD_YR_QTY, 
        RECYC_OFFSITE_SECD_YR_NA = RECYC_OFFSITE_SECD_YR_NA, ENERGY_ONSITE_CURR_YR_QTY = ENERGY_ONSITE_CURR_YR_QTY, 
        ENERGY_ONSITE_CURR_YR_NA = ENERGY_ONSITE_CURR_YR_NA, ENERGY_ONSITE_PREV_YR_QTY = ENERGY_ONSITE_PREV_YR_QTY, 
        ENERGY_ONSITE_PREV_YR_NA = ENERGY_ONSITE_PREV_YR_NA, ENERGY_ONSITE_FOLL_YR_QTY = ENERGY_ONSITE_FOLL_YR_QTY, 
        ENERGY_ONSITE_FOLL_YR_NA = ENERGY_ONSITE_FOLL_YR_NA, ENERGY_ONSITE_SECD_YR_QTY = ENERGY_ONSITE_SECD_YR_QTY, 
        ENERGY_ONSITE_SECD_YR_NA = ENERGY_ONSITE_SECD_YR_NA, ENERGY_OFFSITE_CURR_YR_QTY = ENERGY_OFFSITE_CURR_YR_QTY, 
        ENERGY_OFFSITE_CURR_YR_NA = ENERGY_OFFSITE_CURR_YR_NA, ENERGY_OFFSITE_PREV_YR_QTY = ENERGY_OFFSITE_PREV_YR_QTY, 
        ENERGY_OFFSITE_PREV_YR_NA = ENERGY_OFFSITE_PREV_YR_NA, ENERGY_OFFSITE_FOLL_YR_QTY = ENERGY_OFFSITE_FOLL_YR_QTY, 
        ENERGY_OFFSITE_FOLL_YR_NA = ENERGY_OFFSITE_FOLL_YR_NA, ENERGY_OFFSITE_SECD_YR_QTY = ENERGY_OFFSITE_SECD_YR_QTY, 
        ENERGY_OFFSITE_SECD_YR_NA = ENERGY_OFFSITE_SECD_YR_NA, TREATED_ONSITE_CURR_YR_QTY = TREATED_ONSITE_CURR_YR_QTY, 
        TREATED_ONSITE_CURR_YR_NA = TREATED_ONSITE_CURR_YR_NA, TREATED_ONSITE_PREV_YR_QTY = TREATED_ONSITE_PREV_YR_QTY, 
        TREATED_ONSITE_PREV_YR_NA = TREATED_ONSITE_PREV_YR_NA, TREATED_ONSITE_FOLL_YR_QTY = TREATED_ONSITE_FOLL_YR_QTY, 
        TREATED_ONSITE_FOLL_YR_NA = TREATED_ONSITE_FOLL_YR_NA, TREATED_ONSITE_SECD_YR_QTY = TREATED_ONSITE_SECD_YR_QTY, 
        TREATED_ONSITE_SECD_YR_NA = TREATED_ONSITE_SECD_YR_NA, TREATED_OFFSITE_CURR_YR_QTY = TREATED_OFFSITE_CURR_YR_QTY, 
        TREATED_OFFSITE_CURR_YR_NA = TREATED_OFFSITE_CURR_YR_NA, TREATED_OFFSITE_PREV_YR_QTY = TREATED_OFFSITE_PREV_YR_QTY, 
        TREATED_OFFSITE_PREV_YR_NA = TREATED_OFFSITE_PREV_YR_NA, TREATED_OFFSITE_FOLL_YR_QTY = TREATED_OFFSITE_FOLL_YR_QTY, 
        TREATED_OFFSITE_FOLL_YR_NA = TREATED_OFFSITE_FOLL_YR_NA, TREATED_OFFSITE_SECD_YR_QTY = TREATED_OFFSITE_SECD_YR_QTY, 
        TREATED_OFFSITE_SECD_YR_NA = TREATED_OFFSITE_SECD_YR_NA, REL_CURR_YR_QTY = REL_CURR_YR_QTY, 
        REL_CURR_YR_NA = REL_CURR_YR_NA, REL_PREV_YR_QTY = REL_PREV_YR_QTY, REL_PREV_YR_NA = REL_PREV_YR_NA, 
        REL_FOLL_YR_QTY = REL_FOLL_YR_QTY, REL_FOLL_YR_NA = REL_FOLL_YR_NA, REL_SECD_YR_QTY = REL_SECD_YR_QTY, 
        REL_SECD_YR_NA = REL_SECD_YR_NA, REL_81A_CURR_YR_QTY = REL_81A_CURR_YR_QTY, 
        REL_81A_CURR_YR_NA = REL_81A_CURR_YR_NA, REL_81A_PREV_YR_QTY = REL_81A_PREV_YR_QTY, 
        REL_81A_PREV_YR_NA = REL_81A_PREV_YR_NA, REL_81A_FOLL_YR_QTY = REL_81A_FOLL_YR_QTY, 
        REL_81A_FOLL_YR_NA = REL_81A_FOLL_YR_NA, REL_81A_SECD_YR_QTY = REL_81A_SECD_YR_QTY, 
        REL_81A_SECD_YR_NA = REL_81A_SECD_YR_NA, REL_81B_CURR_YR_QTY = REL_81B_CURR_YR_QTY, 
        REL_81B_CURR_YR_NA = REL_81B_CURR_YR_NA, REL_81B_PREV_YR_QTY = REL_81B_PREV_YR_QTY, 
        REL_81B_PREV_YR_NA = REL_81B_PREV_YR_NA, REL_81B_FOLL_YR_QTY = REL_81B_FOLL_YR_QTY, 
        REL_81B_FOLL_YR_NA = REL_81B_FOLL_YR_NA, REL_81B_SECD_YR_QTY = REL_81B_SECD_YR_QTY, 
        REL_81B_SECD_YR_NA = REL_81B_SECD_YR_NA, REL_81C_CURR_YR_QTY = REL_81C_CURR_YR_QTY, 
        REL_81C_CURR_YR_NA = REL_81C_CURR_YR_NA, REL_81C_PREV_YR_QTY = REL_81C_PREV_YR_QTY, 
        REL_81C_PREV_YR_NA = REL_81C_PREV_YR_NA, REL_81C_FOLL_YR_QTY = REL_81C_FOLL_YR_QTY, 
        REL_81C_FOLL_YR_NA = REL_81C_FOLL_YR_NA, REL_81C_SECD_YR_QTY = REL_81C_SECD_YR_QTY, 
        REL_81C_SECD_YR_NA = REL_81C_SECD_YR_NA, REL_81D_CURR_YR_QTY = REL_81D_CURR_YR_QTY, 
        REL_81D_CURR_YR_NA = REL_81D_CURR_YR_NA, REL_81D_PREV_YR_QTY = REL_81D_PREV_YR_QTY, 
        REL_81D_PREV_YR_NA = REL_81D_PREV_YR_NA, REL_81D_FOLL_YR_QTY = REL_81D_FOLL_YR_QTY, 
        REL_81D_FOLL_YR_NA = REL_81D_FOLL_YR_NA, REL_81D_SECD_YR_QTY = REL_81D_SECD_YR_QTY, 
        REL_81D_SECD_YR_NA = REL_81D_SECD_YR_NA)
    ret <- envir_get("tri_source_reduct_qty", args)
    
    ret
} 
markwh/envirofacts documentation built on May 21, 2019, 12:26 p.m.