OBP24_HST_FLX_IN_MOD_CAP_STATISTICS

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LOG_ID CHARACTER VARYING(300) 300
2 POSTING_DATE TIMESTAMP 8
3 ARRANGEMENT_NUMBER CHARACTER VARYING(45) 45
4 INTEREST_RULE_ID CHARACTER VARYING(10) 10
5 PRODUCT_CLASS CHARACTER VARYING(25) 25
6 INT_CLASS_CODE CHARACTER VARYING(25) 25
7 INT_DIVISION_CODE CHARACTER VARYING(25) 25
8 PREV_STAT_BEGIN_DATE TIMESTAMP 8
9 PREV_STAT_END_DATE TIMESTAMP 8
10 CURR_STAT_BEGIN_DATE TIMESTAMP 8
11 CURR_STAT_END_DATE TIMESTAMP 8
12 FREQ_MOD_EFFECTIVE_DATE TIMESTAMP 8
13 PREV_ANNI_DAY DOUBLE PRECISION 8
14 CURR_ANNI_DAY DOUBLE PRECISION 8
15 PREV_STD_FREQ_CODE CHARACTER VARYING(50) 50
16 CURR_STD_FREQ_CODE CHARACTER VARYING(50) 50
17 PREV_CAP_DUE_DATE TIMESTAMP 8
18 PREV_CAP_SCH_DATE TIMESTAMP 8
19 PREV_CAP_PROC_DATE TIMESTAMP 8
20 CURR_CAP_DUE_DATE TIMESTAMP 8
21 CURR_CAP_SCH_DATE TIMESTAMP 8
22 CURR_CAP_PROC_DATE TIMESTAMP 8
23 IS_APPLICABLE_IN_CURRENT_CYCLE CHARACTER VARYING(1) 1
24 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
25 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
26 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
27 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8