OEB_MTL_CATEGORIES_B

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CATEGORY_ID BIGINT 8
2 STRUCTURE_ID BIGINT 8
3 LAST_UPDATE_DATE TIMESTAMP 8
4 LAST_UPDATED_BY BIGINT 8
5 CREATION_DATE TIMESTAMP 8
6 CREATED_BY BIGINT 8
7 LAST_UPDATE_LOGIN BIGINT 8
8 DESCRIPTION CHARACTER VARYING(240) 240
9 DISABLE_DATE TIMESTAMP 8
10 SEGMENT1 CHARACTER VARYING(40) 40
11 SEGMENT2 CHARACTER VARYING(40) 40
12 SEGMENT3 CHARACTER VARYING(40) 40
13 SEGMENT4 CHARACTER VARYING(40) 40
14 SEGMENT5 CHARACTER VARYING(40) 40
15 SEGMENT6 CHARACTER VARYING(40) 40
16 SEGMENT7 CHARACTER VARYING(40) 40
17 SEGMENT8 CHARACTER VARYING(40) 40
18 SEGMENT9 CHARACTER VARYING(40) 40
19 SEGMENT10 CHARACTER VARYING(40) 40
20 SEGMENT11 CHARACTER VARYING(40) 40
21 SEGMENT12 CHARACTER VARYING(40) 40
22 SEGMENT13 CHARACTER VARYING(40) 40
23 SEGMENT14 CHARACTER VARYING(40) 40
24 SEGMENT15 CHARACTER VARYING(40) 40
25 SEGMENT16 CHARACTER VARYING(40) 40
26 SEGMENT17 CHARACTER VARYING(40) 40
27 SEGMENT18 CHARACTER VARYING(40) 40
28 SEGMENT19 CHARACTER VARYING(40) 40
29 SEGMENT20 CHARACTER VARYING(40) 40
30 SUMMARY_FLAG CHARACTER VARYING(1) 1
31 ENABLED_FLAG CHARACTER VARYING(1) 1
32 START_DATE_ACTIVE TIMESTAMP 8
33 END_DATE_ACTIVE TIMESTAMP 8
34 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
35 ATTRIBUTE1 CHARACTER VARYING(150) 150
36 ATTRIBUTE2 CHARACTER VARYING(150) 150
37 ATTRIBUTE3 CHARACTER VARYING(150) 150
38 ATTRIBUTE4 CHARACTER VARYING(150) 150
39 ATTRIBUTE5 CHARACTER VARYING(150) 150
40 ATTRIBUTE6 CHARACTER VARYING(150) 150
41 ATTRIBUTE7 CHARACTER VARYING(150) 150
42 ATTRIBUTE8 CHARACTER VARYING(150) 150
43 ATTRIBUTE9 CHARACTER VARYING(150) 150
44 ATTRIBUTE10 CHARACTER VARYING(150) 150
45 ATTRIBUTE11 CHARACTER VARYING(150) 150
46 ATTRIBUTE12 CHARACTER VARYING(150) 150
47 ATTRIBUTE13 CHARACTER VARYING(150) 150
48 ATTRIBUTE14 CHARACTER VARYING(150) 150
49 ATTRIBUTE15 CHARACTER VARYING(150) 150
50 REQUEST_ID BIGINT 8
51 PROGRAM_APPLICATION_ID BIGINT 8
52 PROGRAM_ID BIGINT 8
53 PROGRAM_UPDATE_DATE TIMESTAMP 8
54 WEB_STATUS CHARACTER VARYING(30) 30
55 SUPPLIER_ENABLED_FLAG CHARACTER VARYING(1) 1
56 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
57 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
58 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
59 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8