OBP24_HST_FLX_DD_ACCOUNT_METRICS_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_CODE CHARACTER VARYING(40) 40
2 BRANCH_CODE CHARACTER VARYING(10) 10
3 ARR_PRINC_MTD DOUBLE PRECISION 8
4 ARR_PRINC_YTD DOUBLE PRECISION 8
5 ARR_PRINC_ITD DOUBLE PRECISION 8
6 ARR_INT_MTD DOUBLE PRECISION 8
7 ARR_INT_YTD DOUBLE PRECISION 8
8 ARR_INT_ITD DOUBLE PRECISION 8
9 ARR_FEES_MTD DOUBLE PRECISION 8
10 ARR_FEES_YTD DOUBLE PRECISION 8
11 ARR_FEES_ITD DOUBLE PRECISION 8
12 ARR_SUSP_PRINC_MTD DOUBLE PRECISION 8
13 ARR_SUSP_PRINC_YTD DOUBLE PRECISION 8
14 ARR_SUSP_PRINC_ITD DOUBLE PRECISION 8
15 ARR_SUSP_INT_MTD DOUBLE PRECISION 8
16 ARR_SUSP_INT_YTD DOUBLE PRECISION 8
17 ARR_SUSP_INT_ITD DOUBLE PRECISION 8
18 ARR_SUSP_FEES_MTD DOUBLE PRECISION 8
19 ARR_SUSP_FEES_YTD DOUBLE PRECISION 8
20 ARR_SUSP_FEES_ITD DOUBLE PRECISION 8
21 AVG_CR_BAL_MTD DOUBLE PRECISION 8
22 AVG_CR_BAL_YTD DOUBLE PRECISION 8
23 AVG_CR_BAL_ITD DOUBLE PRECISION 8
24 AVG_DR_BAL_MTD DOUBLE PRECISION 8
25 AVG_DR_BAL_YTD DOUBLE PRECISION 8
26 AVG_DR_BAL_ITD DOUBLE PRECISION 8
27 MAX_BAL_MTD DOUBLE PRECISION 8
28 MAX_BAL_YTD DOUBLE PRECISION 8
29 MAX_BAL_ITD DOUBLE PRECISION 8
30 MIN_BAL_MTD DOUBLE PRECISION 8
31 MIN_BAL_YTD DOUBLE PRECISION 8
32 MIN_BAL_ITD DOUBLE PRECISION 8
33 SUM_CLR_BAL_MTD DOUBLE PRECISION 8
34 SUM_CLR_BAL_YTD DOUBLE PRECISION 8
35 SUM_CLR_BAL_ITD DOUBLE PRECISION 8
36 SUM_UNCLR_BAL_MTD DOUBLE PRECISION 8
37 SUM_UNCLR_BAL_YTD DOUBLE PRECISION 8
38 SUM_UNCLR_BAL_ITD DOUBLE PRECISION 8
39 DR_BAL_MTD DOUBLE PRECISION 8
40 DR_BAL_YTD DOUBLE PRECISION 8
41 DR_BAL_ITD DOUBLE PRECISION 8
42 CR_BAL_MTD DOUBLE PRECISION 8
43 CR_BAL_YTD DOUBLE PRECISION 8
44 CR_BAL_ITD DOUBLE PRECISION 8
45 DR_COUNT_MTD DOUBLE PRECISION 8
46 DR_COUNT_YTD DOUBLE PRECISION 8
47 DR_COUNT_ITD DOUBLE PRECISION 8
48 CR_COUNT_MTD DOUBLE PRECISION 8
49 CR_COUNT_YTD DOUBLE PRECISION 8
50 CR_COUNT_ITD DOUBLE PRECISION 8
51 AVG_ADHOC_CR_BAL_MTD DOUBLE PRECISION 8
52 AVG_ADHOC_CR_BAL_YTD DOUBLE PRECISION 8
53 AVG_ADHOC_CR_BAL_ITD DOUBLE PRECISION 8
54 AVG_ADHOC_DR_BAL_MTD DOUBLE PRECISION 8
55 AVG_ADHOC_DR_BAL_YTD DOUBLE PRECISION 8
56 AVG_ADHOC_DR_BAL_ITD DOUBLE PRECISION 8
57 CURRENCY_CODE CHARACTER VARYING(3) 3
58 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
59 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
60 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
61 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8