CA PMA Chargeback Tables › QUERYTAB (Saved Query Definition Table)

QUERYTAB (Saved Query Definition Table)

This table defines queries which are stored by name, for later retrieval and use. This provides a way for nontechnicians to execute queries against the CCCTAB, CCCMOD, BUDTAB, and DBCRTAB tables for on demand reporting purposes.

           Key  Field-Name          Type      Length

            *   VERSION             CHAR         8
            *   QNAME               CHAR         8
                SUMFLAG             CHAR         1
                BRFLAG              CHAR         1
                BDFLAG              CHAR         1
                ORDID               CHAR         3
                ORDID_B             CHAR         1
                ORDID_O             CHAR         1
                CNT                 CHAR        16
                CNT_OP              CHAR         1
                CNT_S               CHAR         3
                ELEM                CHAR        16
                ELEM_B              CHAR         1
                ELEM_O              CHAR         1
                RATE                CHAR        16
                RATE_OP             CHAR         1
                RATE_S              CHAR         3
                QUAL                CHAR        16
                QUAL_B              CHAR         1
                QUAL_O              CHAR         1
                UNITS               CHAR        16
                UNITS_OP            CHAR         1
                UNITS_S             CHAR         3
                PER_FR              CHAR         4
                PER_TO              CHAR         4
                PER_B               CHAR         1
                PER_O               CHAR         1
                BUDAM               CHAR        16
                BUDAM_OP            CHAR         1
                BUDAM_S             CHAR         3
                ST1                 CHAR        16
                ST1_B               CHAR         1
                ST1_O               CHAR         1
                BUDPC               CHAR        16
                BUDPC_OP            CHAR         1
                BUDPC_S             CHAR         3
                ST2                 CHAR        16
                ST2_B               CHAR         1
                ST2_O               CHAR         1
                CHG                 CHAR        16
                CHG_OP              CHAR         1
                CHG_S               CHAR         3
                ST3                 CHAR        16
                ST3_B               CHAR         1
                ST3_O               CHAR         1
                DBAM                CHAR        16
                DBAM_OP             CHAR         1
                DBAM_S              CHAR         3
                ST4                 CHAR        16
                ST4_B               CHAR         1

           Key  Field-Name          Type      Length


                ST4_O               CHAR         1
                CRAM                CHAR        16
                CRAM_OP             CHAR         1
                CRAM_S              CHAR         3
                ST5                 CHAR        16
                ST5_B               CHAR         1
                ST5_O               CHAR         1
                TOT                 CHAR        16
                TOT_OP              CHAR         1
                TOT_S               CHAR         3
                DESC                CHAR        20
                DESCRIPT            CHAR        20