OBP24_HST_CI_SA

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_HST_CI_SA

Columns
# Name Data Type Length
1 SA_ID CHARACTER(10) 10
2 PROP_DCL_RSN_CD CHARACTER(12) 12
3 PROP_SA_ID CHARACTER(10) 10
4 CIS_DIVISION CHARACTER(5) 5
5 SA_TYPE_CD CHARACTER(8) 8
6 START_OPT_CD CHARACTER(12) 12
7 START_DT TIMESTAMP 8
8 SA_STATUS_FLG CHARACTER(2) 2
9 ACCT_ID CHARACTER(10) 10
10 END_DT TIMESTAMP 8
11 OLD_ACCT_ID CHARACTER VARYING(15) 15
12 CUST_READ_FLG CHARACTER(2) 2
13 ALLOW_EST_SW CHARACTER(1) 1
14 SIC_CD CHARACTER(8) 8
15 CHAR_PREM_ID CHARACTER(10) 10
16 TOT_TO_BILL_AMT NUMERIC(15,2) 19
17 CURRENCY_CD CHARACTER(3) 3
18 VERSION INTEGER 4
19 SA_REL_ID CHARACTER(10) 10
20 STRT_RSN_FLG CHARACTER(4) 4
21 STOP_RSN_FLG CHARACTER(4) 4
22 STRT_REQED_BY CHARACTER VARYING(50) 50
23 STOP_REQED_BY CHARACTER VARYING(50) 50
24 HIGH_BILL_AMT NUMERIC(15,2) 19
25 INT_CALC_DT TIMESTAMP 8
26 CIAC_REVIEW_DT TIMESTAMP 8
27 BUS_ACTIVITY_DESC CHARACTER VARYING(250) 250
28 IB_SA_CUTOFF_TM TIMESTAMP 8
29 IB_BASE_TM_DAY_FLG CHARACTER(2) 2
30 ENRL_ID CHARACTER(12) 12
31 SPECIAL_USAGE_FLG CHARACTER(4) 4
32 PROP_SA_STAT_FLG CHARACTER(2) 2
33 NBR_PYMNT_PERIODS SMALLINT 2
34 NB_RULE_CD CHARACTER(8) 8
35 EXPIRE_DT TIMESTAMP 8
36 RENEWAL_DT TIMESTAMP 8
37 NB_APAY_FLG CHARACTER(4) 4
38 SA_DATA_AREA CHARACTER VARYING(2000) 2000
39 POLICY_ID CHARACTER(14) 14
40 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
41 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
42 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
43 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8