CDI_TCFDW_PSTREE_HIERARCHY

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LEAF_CODE CHARACTER VARYING(240) 240
2 LEAF_DESC CHARACTER VARYING(240) 240
3 LEAF_STATUS CHARACTER VARYING(1) 1
4 SM_TREE_SETID CHARACTER VARYING(5) 5
5 TREE_NAME CHARACTER VARYING(18) 18
6 TREE_EFFDT DATE 4
7 LEVEL_1_CODE CHARACTER VARYING(60) 60
8 LEVEL_1_DESC CHARACTER VARYING(240) 240
9 LEVEL_1_NUM BIGINT 8
10 LEVEL_2_CODE CHARACTER VARYING(150) 150
11 LEVEL_2_DESC CHARACTER VARYING(240) 240
12 LEVEL_2_NUM BIGINT 8
13 LEVEL_3_CODE CHARACTER VARYING(150) 150
14 LEVEL_3_DESC CHARACTER VARYING(240) 240
15 LEVEL_3_NUM BIGINT 8
16 LEVEL_4_CODE CHARACTER VARYING(150) 150
17 LEVEL_4_DESC CHARACTER VARYING(240) 240
18 LEVEL_4_NUM BIGINT 8
19 LEVEL_5_CODE CHARACTER VARYING(150) 150
20 LEVEL_5_DESC CHARACTER VARYING(240) 240
21 LEVEL_5_NUM BIGINT 8
22 LEVEL_6_CODE CHARACTER VARYING(150) 150
23 LEVEL_6_DESC CHARACTER VARYING(240) 240
24 LEVEL_6_NUM BIGINT 8
25 LEVEL_7_CODE CHARACTER VARYING(150) 150
26 LEVEL_7_DESC CHARACTER VARYING(240) 240
27 LEVEL_7_NUM BIGINT 8
28 LEVEL_8_CODE CHARACTER VARYING(150) 150
29 LEVEL_8_DESC CHARACTER VARYING(240) 240
30 LEVEL_8_NUM BIGINT 8
31 LEVEL_9_CODE CHARACTER VARYING(150) 150
32 LEVEL_9_DESC CHARACTER VARYING(240) 240
33 LEVEL_9_NUM BIGINT 8
34 LEVEL_10_CODE CHARACTER VARYING(150) 150
35 LEVEL_10_DESC CHARACTER VARYING(240) 240
36 LEVEL_10_NUM BIGINT 8
37 LEVEL_11_CODE CHARACTER VARYING(150) 150
38 LEVEL_11_DESC CHARACTER VARYING(240) 240
39 LEVEL_11_NUM BIGINT 8
40 LEVEL_12_CODE CHARACTER VARYING(150) 150
41 LEVEL_12_DESC CHARACTER VARYING(240) 240
42 LEVEL_12_NUM BIGINT 8
43 LEVEL_13_CODE CHARACTER VARYING(150) 150
44 LEVEL_13_DESC CHARACTER VARYING(240) 240
45 LEVEL_13_NUM BIGINT 8
46 LEVEL_14_CODE CHARACTER VARYING(150) 150
47 LEVEL_14_DESC CHARACTER VARYING(240) 240
48 LEVEL_14_NUM BIGINT 8
49 LEVEL_15_CODE CHARACTER VARYING(150) 150
50 LEVEL_15_DESC CHARACTER VARYING(240) 240
51 LEVEL_15_NUM BIGINT 8
52 TREE_LEVEL_NUM BIGINT 8
53 LEVEL_COUNT BIGINT 8
54 SM_TREE_STATUS CHARACTER VARYING(1) 1
55 TREE_STRCT_ID CHARACTER VARYING(18) 18
56 EFF_STRT_DATE DATE 4
57 EFF_END_DATE DATE 4
58 SRC_SYS_ID CHARACTER VARYING(5) 5
59 LOAD_ID BIGINT 8
60 DATA_LOAD_DATE DATE 4
61 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
62 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
63 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
64 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8