RDM_TELEPHONY_ITEM_V

Database

SDSNZS01_RDM

Schema

CDCPADM_RDM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ID INTEGER 4
2 MUID CHARACTER VARYING(4000) 4000
3 VERSIONNAME NATIONAL CHARACTER VARYING(50) 50
4 VERSIONNUMBER INTEGER 4
5 VERSION_ID INTEGER 4
6 VERSIONFLAG NATIONAL CHARACTER VARYING(50) 50
7 NAME NATIONAL CHARACTER VARYING(250) 250
8 CODE NATIONAL CHARACTER VARYING(250) 250
9 CHANGETRACKINGMASK INTEGER 4
10 DATE_FROM TIMESTAMP 8
11 DATE_TO TIMESTAMP 8
12 ACD_CODE NATIONAL CHARACTER VARYING(250) 250
13 ACD_NAME NATIONAL CHARACTER VARYING(250) 250
14 ACD_ID INTEGER 4
15 ITEM_TYPE_CODE NATIONAL CHARACTER VARYING(250) 250
16 ITEM_TYPE_NAME NATIONAL CHARACTER VARYING(250) 250
17 ITEM_TYPE_ID INTEGER 4
18 ITEM_VALUE_CODE NATIONAL CHARACTER VARYING(250) 250
19 ITEM_VALUE_NAME NATIONAL CHARACTER VARYING(250) 250
20 ITEM_VALUE_ID INTEGER 4
21 ITEM_NAME_CODE NATIONAL CHARACTER VARYING(250) 250
22 ITEM_NAME_NAME NATIONAL CHARACTER VARYING(250) 250
23 ITEM_NAME_ID INTEGER 4
24 ITEM_GROUP NATIONAL CHARACTER VARYING(100) 100
25 BRAND_CODE NATIONAL CHARACTER VARYING(250) 250
26 BRAND_NAME NATIONAL CHARACTER VARYING(250) 250
27 BRAND_ID INTEGER 4
28 BRAND_GROUP_CODE NATIONAL CHARACTER VARYING(250) 250
29 BRAND_GROUP_NAME NATIONAL CHARACTER VARYING(250) 250
30 BRAND_GROUP_ID INTEGER 4
31 PRODUCT_CODE NATIONAL CHARACTER VARYING(250) 250
32 PRODUCT_NAME NATIONAL CHARACTER VARYING(250) 250
33 PRODUCT_ID INTEGER 4
34 PRODUCT_CATEGORY_CODE NATIONAL CHARACTER VARYING(250) 250
35 PRODUCT_CATEGORY_NAME NATIONAL CHARACTER VARYING(250) 250
36 PRODUCT_CATEGORY_ID INTEGER 4
37 LOB_PRODUCTGROUP_CODE NATIONAL CHARACTER VARYING(250) 250
38 LOB_PRODUCTGROUP_NAME NATIONAL CHARACTER VARYING(250) 250
39 LOB_PRODUCTGROUP_ID INTEGER 4
40 ENQUIRY_TYPE_CODE NATIONAL CHARACTER VARYING(250) 250
41 ENQUIRY_TYPE_NAME NATIONAL CHARACTER VARYING(250) 250
42 ENQUIRY_TYPE_ID INTEGER 4
43 QUEUE_TYPE_CODE NATIONAL CHARACTER VARYING(250) 250
44 QUEUE_TYPE_NAME NATIONAL CHARACTER VARYING(250) 250
45 QUEUE_TYPE_ID INTEGER 4
46 REPORT_GROUP_CODE NATIONAL CHARACTER VARYING(250) 250
47 REPORT_GROUP_NAME NATIONAL CHARACTER VARYING(250) 250
48 REPORT_GROUP_ID INTEGER 4
49 DEPARTMENT_CODE NATIONAL CHARACTER VARYING(250) 250
50 DEPARTMENT_NAME NATIONAL CHARACTER VARYING(250) 250
51 DEPARTMENT_ID INTEGER 4
52 OFFSHORE_FLAG_CODE NATIONAL CHARACTER VARYING(250) 250
53 OFFSHORE_FLAG_NAME NATIONAL CHARACTER VARYING(250) 250
54 OFFSHORE_FLAG_ID INTEGER 4
55 MONDAY_CODE NATIONAL CHARACTER VARYING(250) 250
56 MONDAY_NAME NATIONAL CHARACTER VARYING(250) 250
57 MONDAY_ID INTEGER 4
58 TUESDAY_CODE NATIONAL CHARACTER VARYING(250) 250
59 TUESDAY_NAME NATIONAL CHARACTER VARYING(250) 250
60 TUESDAY_ID INTEGER 4
61 WEDNESDAY_CODE NATIONAL CHARACTER VARYING(250) 250
62 WEDNESDAY_NAME NATIONAL CHARACTER VARYING(250) 250
63 WEDNESDAY_ID INTEGER 4
64 THURSDAY_CODE NATIONAL CHARACTER VARYING(250) 250
65 THURSDAY_NAME NATIONAL CHARACTER VARYING(250) 250
66 THURSDAY_ID INTEGER 4
67 FRIDAY_CODE NATIONAL CHARACTER VARYING(250) 250
68 FRIDAY_NAME NATIONAL CHARACTER VARYING(250) 250
69 FRIDAY_ID INTEGER 4
70 SATURDAY_CODE NATIONAL CHARACTER VARYING(250) 250
71 SATURDAY_NAME NATIONAL CHARACTER VARYING(250) 250
72 SATURDAY_ID INTEGER 4
73 SUNDAY_CODE NATIONAL CHARACTER VARYING(250) 250
74 SUNDAY_NAME NATIONAL CHARACTER VARYING(250) 250
75 SUNDAY_ID INTEGER 4
76 WFM_CAMPAIGN_NAME_CODE NATIONAL CHARACTER VARYING(250) 250
77 WFM_CAMPAIGN_NAME_NAME NATIONAL CHARACTER VARYING(250) 250
78 WFM_CAMPAIGN_NAME_ID INTEGER 4
79 WFM_PARENT_QUEUE_NAME_CODE NATIONAL CHARACTER VARYING(250) 250
80 WFM_PARENT_QUEUE_NAME_NAME NATIONAL CHARACTER VARYING(250) 250
81 WFM_PARENT_QUEUE_NAME_ID INTEGER 4
82 ENTERDATETIME TIMESTAMP 8
83 ENTERUSERNAME NATIONAL CHARACTER VARYING(100) 100
84 ENTERVERSIONNUMBER INTEGER 4
85 LASTCHGDATETIME TIMESTAMP 8
86 LASTCHGUSERNAME NATIONAL CHARACTER VARYING(100) 100
87 LASTCHGVERSIONNUMBER INTEGER 4
88 VALIDATIONSTATUS NATIONAL CHARACTER VARYING(250) 250
89 CDC_SRC_SYSTEM_CODE CHARACTER(4) 4
90 CDC_RECORD_TYPE CHARACTER(14) 14
91 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
92 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8