OEB_HST_FND_FLEX_VALUES

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 FLEX_VALUE_SET_ID BIGINT 8
2 FLEX_VALUE_ID BIGINT 8
3 FLEX_VALUE CHARACTER VARYING(150) 150
4 LAST_UPDATE_DATE TIMESTAMP 8
5 LAST_UPDATED_BY BIGINT 8
6 CREATION_DATE TIMESTAMP 8
7 CREATED_BY BIGINT 8
8 LAST_UPDATE_LOGIN BIGINT 8
9 ENABLED_FLAG CHARACTER VARYING(1) 1
10 SUMMARY_FLAG CHARACTER VARYING(1) 1
11 START_DATE_ACTIVE TIMESTAMP 8
12 END_DATE_ACTIVE TIMESTAMP 8
13 PARENT_FLEX_VALUE_LOW CHARACTER VARYING(60) 60
14 PARENT_FLEX_VALUE_HIGH CHARACTER VARYING(60) 60
15 STRUCTURED_HIERARCHY_LEVEL BIGINT 8
16 HIERARCHY_LEVEL CHARACTER VARYING(30) 30
17 COMPILED_VALUE_ATTRIBUTES CHARACTER VARYING(1000) 1000
18 VALUE_CATEGORY CHARACTER VARYING(30) 30
19 ATTRIBUTE1 CHARACTER VARYING(240) 240
20 ATTRIBUTE2 CHARACTER VARYING(240) 240
21 ATTRIBUTE3 CHARACTER VARYING(240) 240
22 ATTRIBUTE4 CHARACTER VARYING(240) 240
23 ATTRIBUTE5 CHARACTER VARYING(240) 240
24 ATTRIBUTE6 CHARACTER VARYING(240) 240
25 ATTRIBUTE7 CHARACTER VARYING(240) 240
26 ATTRIBUTE8 CHARACTER VARYING(240) 240
27 ATTRIBUTE9 CHARACTER VARYING(240) 240
28 ATTRIBUTE10 CHARACTER VARYING(240) 240
29 ATTRIBUTE11 CHARACTER VARYING(240) 240
30 ATTRIBUTE12 CHARACTER VARYING(240) 240
31 ATTRIBUTE13 CHARACTER VARYING(240) 240
32 ATTRIBUTE14 CHARACTER VARYING(240) 240
33 ATTRIBUTE15 CHARACTER VARYING(240) 240
34 ATTRIBUTE16 CHARACTER VARYING(240) 240
35 ATTRIBUTE17 CHARACTER VARYING(240) 240
36 ATTRIBUTE18 CHARACTER VARYING(240) 240
37 ATTRIBUTE19 CHARACTER VARYING(240) 240
38 ATTRIBUTE20 CHARACTER VARYING(240) 240
39 ATTRIBUTE21 CHARACTER VARYING(240) 240
40 ATTRIBUTE22 CHARACTER VARYING(240) 240
41 ATTRIBUTE23 CHARACTER VARYING(240) 240
42 ATTRIBUTE24 CHARACTER VARYING(240) 240
43 ATTRIBUTE25 CHARACTER VARYING(240) 240
44 ATTRIBUTE26 CHARACTER VARYING(240) 240
45 ATTRIBUTE27 CHARACTER VARYING(240) 240
46 ATTRIBUTE28 CHARACTER VARYING(240) 240
47 ATTRIBUTE29 CHARACTER VARYING(240) 240
48 ATTRIBUTE30 CHARACTER VARYING(240) 240
49 ATTRIBUTE31 CHARACTER VARYING(240) 240
50 ATTRIBUTE32 CHARACTER VARYING(240) 240
51 ATTRIBUTE33 CHARACTER VARYING(240) 240
52 ATTRIBUTE34 CHARACTER VARYING(240) 240
53 ATTRIBUTE35 CHARACTER VARYING(240) 240
54 ATTRIBUTE36 CHARACTER VARYING(240) 240
55 ATTRIBUTE37 CHARACTER VARYING(240) 240
56 ATTRIBUTE38 CHARACTER VARYING(240) 240
57 ATTRIBUTE39 CHARACTER VARYING(240) 240
58 ATTRIBUTE40 CHARACTER VARYING(240) 240
59 ATTRIBUTE41 CHARACTER VARYING(240) 240
60 ATTRIBUTE42 CHARACTER VARYING(240) 240
61 ATTRIBUTE43 CHARACTER VARYING(240) 240
62 ATTRIBUTE44 CHARACTER VARYING(240) 240
63 ATTRIBUTE45 CHARACTER VARYING(240) 240
64 ATTRIBUTE46 CHARACTER VARYING(240) 240
65 ATTRIBUTE47 CHARACTER VARYING(240) 240
66 ATTRIBUTE48 CHARACTER VARYING(240) 240
67 ATTRIBUTE49 CHARACTER VARYING(240) 240
68 ATTRIBUTE50 CHARACTER VARYING(240) 240
69 ATTRIBUTE_SORT_ORDER BIGINT 8
70 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
71 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
72 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
73 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8