glmast_raw
Pipelined Data Sets
>
SilverLake
>
glmast_raw
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| __op | Contains the operation type. Values are I for insert, U for update, D for delete. | REQUIRED | STRING | |
| __op_ts | operation timestamp added by export code | REQUIRED | TIMESTAMP | |
| __uid | The Unique ID of this entry. Data, UUID, or GUID | REQUIRED | STRING | |
| __ver | Mapping and Schema Version | REQUIRED | INTEGER | |
| bankno | Bank number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| branch | Branch number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| acctno | Account number | DEC(7,0) | NULLABLE | INTEGER | 7 |
| conacc | Consolidated acct# | DEC(7,0) | NULLABLE | INTEGER | 7 |
| center | Cost center | DEC(4,0) | NULLABLE | INTEGER | 4 |
| prdcod | Product code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| status | Account status | DEC(1,0) | NULLABLE | INTEGER | 1 |
| post | Posting status | CHAR(1) | NULLABLE | STRING | 1 |
| title | Account title | CHAR(35) | NULLABLE | STRING | 35 |
| actype | Account type | CHAR(1) | NULLABLE | STRING | 1 |
| reptyp | Report type | CHAR(1) | NULLABLE | STRING | 1 |
| actseq | Account sequence | CHAR(1) | NULLABLE | STRING | 1 |
| level | Totaling level | DEC(1,0) | NULLABLE | INTEGER | 1 |
| officr | Officer Code | CHAR(6) | NULLABLE | STRING | 6 |
| balcod | Normal Balance | CHAR(1) | NULLABLE | STRING | 1 |
| pstfrq | Posting Frequency | CHAR(1) | NULLABLE | STRING | 1 |
| trntyp | Transaction Type | CHAR(1) | NULLABLE | STRING | 1 |
| mandes | Mandatory Description | CHAR(1) | NULLABLE | STRING | 1 |
| manoff | Mandatory Officer | CHAR(1) | NULLABLE | STRING | 1 |
| risk | Risk based Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| calrp1 | Call Report code | CHAR(8) | NULLABLE | STRING | 8 |
| calrp2 | Call Report code | CHAR(8) | NULLABLE | STRING | 8 |
| calrp3 | Call Report code | CHAR(8) | NULLABLE | STRING | 8 |
| calrp4 | Call Report code | CHAR(8) | NULLABLE | STRING | 8 |
| cond1 | Stmt of condition code | DEC(4,0) | NULLABLE | INTEGER | 4 |
| cond2 | Stmt of condition code | DEC(4,0) | NULLABLE | INTEGER | 4 |
| cond3 | Stmt of condition code | DEC(4,0) | NULLABLE | INTEGER | 4 |
| cond4 | Stmt of condition code | DEC(4,0) | NULLABLE | INTEGER | 4 |
| cond5 | Stmt of condition code | DEC(4,0) | NULLABLE | INTEGER | 4 |
| cond6 | Stmt of condition code | DEC(4,0) | NULLABLE | INTEGER | 4 |
| cond7 | Stmt of condition code | DEC(4,0) | NULLABLE | INTEGER | 4 |
| cond8 | Stmt of condition code | DEC(4,0) | NULLABLE | INTEGER | 4 |
| cond9 | Stmt of condition code | DEC(4,0) | NULLABLE | INTEGER | 4 |
| glsic1 | Special Info Code 1 | CHAR(1) | NULLABLE | STRING | 1 |
| glsic2 | Special Info Code 2 | CHAR(1) | NULLABLE | STRING | 1 |
| glsic3 | Special Info Code 3 | CHAR(1) | NULLABLE | STRING | 1 |
| glsic4 | Special Info Code 4 | CHAR(1) | NULLABLE | STRING | 1 |
| datcv7 | Date Converted | DEC(7,0) | NULLABLE | INTEGER | 7 |
| datcv6 | Date Converted | DEC(6,0) | NULLABLE | INTEGER | 6 |
| dla7 | Date last active | DEC(7,0) | NULLABLE | INTEGER | 7 |
| dla6 | Date last active | DEC(6,0) | NULLABLE | INTEGER | 6 |
| datop7 | Date opened | DEC(7,0) | NULLABLE | INTEGER | 7 |
| datop6 | Date opened | DEC(6,0) | NULLABLE | INTEGER | 6 |
| daten7 | Date entered | DEC(7,0) | NULLABLE | INTEGER | 7 |
| daten6 | Date entered | DEC(6,0) | NULLABLE | INTEGER | 6 |
| dlm7 | Date of last maintenance | DEC(7,0) | NULLABLE | INTEGER | 7 |
| dlm6 | Date of last maintenance | DEC(6,0) | NULLABLE | INTEGER | 6 |
| curbal | Current balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| netchg | Net Change Today | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| yesbal | Yesterdays balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| begcyr | Begin Bal Curr Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| beglyr | Begin Bal Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| begpyr | Begin Bal Prev Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| mtdbal | MTD balance | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| qtdbal | QTD balance | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| ytdbal | YTD balance | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| mtdavg | MTD average | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| qtdavg | QTD average | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ytdavg | YTD average | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ytdavl | YTD average Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| ytdavp | YTD average Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| magbal | MTD aggregate balance | DEC(17,2) | NULLABLE | FLOAT | 17.2 |
| qagbal | QTD aggregate balance | DEC(17,2) | NULLABLE | FLOAT | 17.2 |
| yagbal | YTD aggregate balance | DEC(17,2) | NULLABLE | FLOAT | 17.2 |
| glpic1 | Programmer Use #1 | CHAR(2) | NULLABLE | STRING | 2 |
| glpic2 | Programmer Use #2 | CHAR(2) | NULLABLE | STRING | 2 |
| glpd71 | Programmer DATE #1 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| glpd61 | Programmer DATE #1 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| glpd72 | Programmer DATE #2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| glpd62 | Programmer DATE #2 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| glpam1 | Programmer AMT #1 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| glpam2 | Programmer AMT #2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| glpam3 | Programmer AMT #2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| glpam4 | Programmer AMT #2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmeb1 | Month end 1 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmeb2 | Month end 2 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmeb3 | Month end 3 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmeb4 | Month end 4 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmeb5 | Month end 5 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmeb6 | Month end 6 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmeb7 | Month end 7 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmeb8 | Month end 8 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmeb9 | Month end 9 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmeb10 | Month end 10 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmeb11 | Month end 11 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmeb12 | Month end 12 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmeb1 | Month end 1 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmeb2 | Month end 2 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmeb3 | Month end 3 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmeb4 | Month end 4 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmeb5 | Month end 5 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmeb6 | Month end 6 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmeb7 | Month end 7 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmeb8 | Month end 8 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmeb9 | Month end 9 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmeb10 | Month end 10 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmeb11 | Month end 11 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmeb12 | Month end 12 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmeb1 | Month end 1 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmeb2 | Month end 2 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmeb3 | Month end 3 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmeb4 | Month end 4 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmeb5 | Month end 5 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmeb6 | Month end 6 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmeb7 | Month end 7 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmeb8 | Month end 8 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmeb9 | Month end 9 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmeb10 | Month end 10 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmeb11 | Month end 11 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmeb12 | Month end 12 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmtd1 | Mth to date 1 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmtd2 | Mth to date 2 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmtd3 | Mth to date 3 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmtd4 | Mth to date 4 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmtd5 | Mth to date 5 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmtd6 | Mth to date 6 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmtd7 | Mth to date 7 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmtd8 | Mth to date 8 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmtd9 | Mth to date 9 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmtd10 | Mth to date 10 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmtd11 | Mth to date 11 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cmtd12 | Mth to date 12 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmtd1 | Mth to date 1 Last Yr | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmtd2 | Mth to date 2 Last Yr | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmtd3 | Mth to date 3 Last Yr | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmtd4 | Mth to date 4 Last Yr | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmtd5 | Mth to date 5 Last Yr | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmtd6 | Mth to date 6 Last Yr | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmtd7 | Mth to date 7 Last Yr | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmtd8 | Mth to date 8 Last Yr | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmtd9 | Mth to date 9 Last Yr | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmtd10 | Mth to date 10 Last Yr | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmtd11 | Mth to date 11 Last Yr | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lmtd12 | Mth to date 12 Last Yr | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmtd1 | Mth to date 1 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmtd2 | Mth to date 2 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmtd3 | Mth to date 3 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmtd4 | Mth to date 4 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmtd5 | Mth to date 5 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmtd6 | Mth to date 6 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmtd7 | Mth to date 7 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmtd8 | Mth to date 8 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmtd9 | Mth to date 9 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmtd10 | Mth to date 10 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmtd11 | Mth to date 11 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pmtd12 | Mth to date 12 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cagg1 | Month agg 1 Current | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| cagg2 | Month agg 2 Current | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| cagg3 | Month agg 3 Current | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| cagg4 | Month agg 4 Current | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| cagg5 | Month agg 5 Current | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| cagg6 | Month agg 6 Current | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| cagg7 | Month agg 7 Current | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| cagg8 | Month agg 8 Current | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| cagg9 | Month agg 9 Current | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| cagg10 | Month agg 10 Current | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| cagg11 | Month agg 11 Current | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| cagg12 | Month agg 12 Current | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| lagg1 | Month agg 1 Last Year | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| lagg2 | Month agg 2 Last Year | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| lagg3 | Month agg 3 Last Year | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| lagg4 | Month agg 4 Last Year | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| lagg5 | Month agg 5 Last Year | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| lagg6 | Month agg 6 Last Year | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| lagg7 | Month agg 7 Last Year | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| lagg8 | Month agg 8 Last Year | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| lagg9 | Month agg 9 Last Year | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| lagg10 | Month agg 10 Last Year | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| lagg11 | Month agg 11 Last Year | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| lagg12 | Month agg 12 Last Year | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| pagg1 | Month agg 1 Previous | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| pagg2 | Month agg 2 Previous | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| pagg3 | Month agg 3 Previous | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| pagg4 | Month agg 4 Previous | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| pagg5 | Month agg 5 Previous | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| pagg6 | Month agg 6 Previous | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| pagg7 | Month agg 7 Previous | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| pagg8 | Month agg 8 Previous | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| pagg9 | Month agg 9 Previous | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| pagg10 | Month agg 10 Previous | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| pagg11 | Month agg 11 Previous | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| pagg12 | Month agg 12 Previous | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| cavg1 | Month avg 1 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cavg2 | Month avg 2 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cavg3 | Month avg 3 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cavg4 | Month avg 4 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cavg5 | Month avg 5 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cavg6 | Month avg 6 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cavg7 | Month avg 7 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cavg8 | Month avg 8 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cavg9 | Month avg 9 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cavg10 | Month avg 10 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cavg11 | Month avg 11 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cavg12 | Month avg 12 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lavg1 | Month avg 1 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lavg2 | Month avg 2 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lavg3 | Month avg 3 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lavg4 | Month avg 4 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lavg5 | Month avg 5 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lavg6 | Month avg 6 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lavg7 | Month avg 7 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lavg8 | Month avg 8 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lavg9 | Month avg 9 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lavg10 | Month avg 10 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lavg11 | Month avg 11 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lavg12 | Month avg 12 Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pavg1 | Month avg 1 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pavg2 | Month avg 2 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pavg3 | Month avg 3 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pavg4 | Month avg 4 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pavg5 | Month avg 5 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pavg6 | Month avg 6 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pavg7 | Month avg 7 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pavg8 | Month avg 8 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pavg9 | Month avg 9 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pavg10 | Month avg 10 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pavg11 | Month avg 11 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pavg12 | Month avg 12 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cqeb1 | Qtr end 1 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cqeb2 | Qtr end 2 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cqeb3 | Qtr end 3 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cqeb4 | Qtr end 4 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lqeb1 | Qtr end 1 Last | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lqeb2 | Qtr end 2 Last | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lqeb3 | Qtr end 3 Last | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lqeb4 | Qtr end 4 Last | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pqeb1 | Qtr end 1 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pqeb2 | Qtr end 2 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pqeb3 | Qtr end 3 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pqeb4 | Qtr end 4 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cqtd1 | Qtr to date 1 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cqtd2 | Qtr to date 2 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cqtd3 | Qtr to date 3 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cqtd4 | Qtr to date 4 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lqtd1 | Qtr to date 1 Last | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lqtd2 | Qtr to date 2 Last | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lqtd3 | Qtr to date 3 Last | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lqtd4 | Qtr to date 4 Last | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pqtd1 | Qtr to date 1 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pqtd2 | Qtr to date 2 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pqtd3 | Qtr to date 3 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pqtd4 | Qtr to date 4 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cqav1 | Qtr average 1 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cqav2 | Qtr average 2 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cqav3 | Qtr average 3 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cqav4 | Qtr average 4 Current | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lqav1 | Qtr average 1 Last | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lqav2 | Qtr average 2 Last | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lqav3 | Qtr average 3 Last | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lqav4 | Qtr average 4 Last | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pqav1 | Qtr average 1 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pqav2 | Qtr average 2 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pqav3 | Qtr average 3 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pqav4 | Qtr average 4 Previous | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| cbud1 | Budget 1 Current | DEC(11,0) | NULLABLE | INTEGER | 11 |
| cbud2 | Budget 2 Current | DEC(11,0) | NULLABLE | INTEGER | 11 |
| cbud3 | Budget 3 Current | DEC(11,0) | NULLABLE | INTEGER | 11 |
| cbud4 | Budget 4 Current | DEC(11,0) | NULLABLE | INTEGER | 11 |
| cbud5 | Budget 5 Current | DEC(11,0) | NULLABLE | INTEGER | 11 |
| cbud6 | Budget 6 Current | DEC(11,0) | NULLABLE | INTEGER | 11 |
| cbud7 | Budget 7 Current | DEC(11,0) | NULLABLE | INTEGER | 11 |
| cbud8 | Budget 8 Current | DEC(11,0) | NULLABLE | INTEGER | 11 |
| cbud9 | Budget 9 Current | DEC(11,0) | NULLABLE | INTEGER | 11 |
| cbud10 | Budget 10 Current | DEC(11,0) | NULLABLE | INTEGER | 11 |
| cbud11 | Budget 11 Current | DEC(11,0) | NULLABLE | INTEGER | 11 |
| cbud12 | Budget 12 Current | DEC(11,0) | NULLABLE | INTEGER | 11 |
| cbudgt | Total Budget Current | DEC(11,0) | NULLABLE | INTEGER | 11 |
| obud1 | Budget 1 Original | DEC(11,0) | NULLABLE | INTEGER | 11 |
| obud2 | Budget 2 Original | DEC(11,0) | NULLABLE | INTEGER | 11 |
| obud3 | Budget 3 Original | DEC(11,0) | NULLABLE | INTEGER | 11 |
| obud4 | Budget 4 Original | DEC(11,0) | NULLABLE | INTEGER | 11 |
| obud5 | Budget 5 Original | DEC(11,0) | NULLABLE | INTEGER | 11 |
| obud6 | Budget 6 Original | DEC(11,0) | NULLABLE | INTEGER | 11 |
| obud7 | Budget 7 Original | DEC(11,0) | NULLABLE | INTEGER | 11 |
| obud8 | Budget 8 Original | DEC(11,0) | NULLABLE | INTEGER | 11 |
| obud9 | Budget 9 Original | DEC(11,0) | NULLABLE | INTEGER | 11 |
| obud10 | Budget 10 Original | DEC(11,0) | NULLABLE | INTEGER | 11 |
| obud11 | Budget 11 Original | DEC(11,0) | NULLABLE | INTEGER | 11 |
| obud12 | Budget 12 Original | DEC(11,0) | NULLABLE | INTEGER | 11 |
| obudgt | Total Budget Original | DEC(11,0) | NULLABLE | INTEGER | 11 |
| lbud1 | Budget 1 Last Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| lbud2 | Budget 2 Last Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| lbud3 | Budget 3 Last Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| lbud4 | Budget 4 Last Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| lbud5 | Budget 5 Last Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| lbud6 | Budget 6 Last Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| lbud7 | Budget 7 Last Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| lbud8 | Budget 8 Last Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| lbud9 | Budget 9 Last Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| lbud10 | Budget 10 Last Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| lbud11 | Budget 11 Last Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| lbud12 | Budget 12 Last Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| lbudgt | Total Budget Last Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| nbud1 | Budget 1 Next Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| nbud2 | Budget 2 Next Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| nbud3 | Budget 3 Next Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| nbud4 | Budget 4 Next Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| nbud5 | Budget 5 Next Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| nbud6 | Budget 6 Next Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| nbud7 | Budget 7 Next Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| nbud8 | Budget 8 Next Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| nbud9 | Budget 9 Next Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| nbud10 | Budget 10 Next Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| nbud11 | Budget 11 Next Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| nbud12 | Budget 12 Next Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
| nbudgt | Total Budget Next Year | DEC(11,0) | NULLABLE | INTEGER | 11 |
Have a Question?
- Have a how-to question? Seeing a weird error? Get help on StackOverflow.
- Register for the Developer Office Hours where we answer technical Q&A from the audience.
Did this page help you?
Last updated Wed Mar 4 2026