SDW_TSDWM_INS_AR

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_SDW_TSDWM_INS_AR

Columns
# Name Data Type Length
1 AR_ID BIGINT 8
2 AR_TP_ID BIGINT 8
3 SRC_STM_ID BIGINT 8
4 SRC_CO_CODE CHARACTER VARYING(6) 6
5 SRC_PD_TP_CODE CHARACTER VARYING(6) 6
6 SRC_AC_NBR_CODE CHARACTER VARYING(20) 20
7 SRC_INS_CO_CODE CHARACTER VARYING(6) 6
8 SRC_INS_CLCN_CODE CHARACTER VARYING(6) 6
9 SRC_INS_SEQ_NBR BIGINT 8
10 UNQ_ID_SRC_STM CHARACTER VARYING(256) 256
11 LOAD_ST_F CHARACTER VARYING(1) 1
12 ISRT_RUN_AUDT_ID BIGINT 8
13 UDT_RUN_AUDT_ID BIGINT 8
14 INS_POLCY_NO CHARACTER VARYING(20) 20
15 AMT NUMERIC(14,2) 19
16 POLCY_STRT_DT DATE 4
17 POLCY_END_DT DATE 4
18 POLCY_CNCL_DT DATE 4
19 AR_INS_TP_ID BIGINT 8
20 INS_CO_TP_ID BIGINT 8
21 INS_PD_TP_ID BIGINT 8
22 INS_PVDR_CO_NM CHARACTER VARYING(80) 80
23 CRT_DT DATE 4
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