CLMS_LEADSHF

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACTION_CODE CHARACTER VARYING(1) 1
3 LEADNO INTEGER 4
4 STATUS INTEGER 4
5 ESTDATE TIMESTAMP 8
6 SCHGEDTE TIMESTAMP 8
7 BDM INTEGER 4
8 SOURCE INTEGER 4
9 BRANCH INTEGER 4
10 QUALDATE TIMESTAMP 8
11 INTDATE TIMESTAMP 8
12 ADVDATE TIMESTAMP 8
13 IOFFDATE TIMESTAMP 8
14 SUBCDATE TIMESTAMP 8
15 TOCRDATE TIMESTAMP 8
16 BANKDECDTE TIMESTAMP 8
17 CLOFFDATE TIMESTAMP 8
18 CLACCDATE TIMESTAMP 8
19 NPWDATE TIMESTAMP 8
20 BANKDEC CHARACTER VARYING(2) 2
21 NPWBANK CHARACTER VARYING(3) 3
22 COMMENTA CHARACTER VARYING(30) 30
23 COMMENTB CHARACTER VARYING(30) 30
24 EXPSETDTE TIMESTAMP 8
25 LASTSETDTE TIMESTAMP 8
26 ACCEPTREAS INTEGER 4
27 REVEXP CHARACTER VARYING(1) 1
28 BORCODE INTEGER 4
29 NPWREASON INTEGER 4
30 PROMDATE TIMESTAMP 8
31 SYNDICARR CHARACTER VARYING(3) 3
32 DELTA_TYPE CHARACTER VARYING(1) 1
33 EFFECTIVE_STRT_DT TIMESTAMP 8
34 EFFECTIVE_END_DT TIMESTAMP 8
35 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
36 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
37 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
38 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8