CFD_TCFDD_SERV_REQ

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SERV_REQ_ID BIGINT 8
2 SERV_REQ_NUM CHARACTER VARYING(64) 64
3 ASSC_CNTCT_ID CHARACTER VARYING(30) 30
4 EXTRNL_SYS_ID CHARACTER VARYING(30) 30
5 ACCT_NUM CHARACTER VARYING(40) 40
6 BUS_CUST_DESC CHARACTER VARYING(30) 30
7 SERV_REQ_CAT_DESC CHARACTER VARYING(30) 30
8 SERV_REQ_SUBCATEGORY_DESC CHARACTER VARYING(30) 30
9 SERV_REQ_OPEN_TS TIMESTAMP 8
10 SERV_REQ_CLOSE_TS TIMESTAMP 8
11 SERV_REQ_DUE_TS TIMESTAMP 8
12 CUST_ID_FROM_DESC CHARACTER VARYING(30) 30
13 CUST_ID_TO_DESC CHARACTER VARYING(30) 30
14 E_MAIL_DESC CHARACTER VARYING(100) 100
15 SERV_REQ_OWNR_DESC CHARACTER VARYING(30) 30
16 SERV_REQ_PRTY_DESC CHARACTER VARYING(30) 30
17 REFUND_AMT NUMERIC(18,6) 19
18 RESOLUTION_1_DESC CHARACTER VARYING(30) 30
19 RESOLUTION_2_DESC CHARACTER VARYING(30) 30
20 SLA_DAY_CNT_DESC CHARACTER VARYING(30) 30
21 SERV_REQ_SRC_DESC CHARACTER VARYING(30) 30
22 SERV_REQ_STAT_DESC CHARACTER VARYING(30) 30
23 SERV_REQ_SUBJECT_DESC CHARACTER VARYING(2000) 2000
24 SYS_STAT_DESC CHARACTER VARYING(30) 30
25 SERV_REQ_TYP_1_DESC CHARACTER VARYING(30) 30
26 SERV_REQ_TYP_2_DESC CHARACTER VARYING(30) 30
27 ENTERPRISE_OWNR_ID CHARACTER VARYING(40) 40
28 ENTERPRISE_OWNER_NAME CHARACTER VARYING(255) 255
29 WRK_PH_NUM CHARACTER VARYING(35) 35
30 CREATED_BY_NAM CHARACTER VARYING(100) 100
31 CREATE_UID CHARACTER VARYING(10) 10
32 CREATE_TS TIMESTAMP 8
33 MOD_UID CHARACTER VARYING(10) 10
34 MOD_TS TIMESTAMP 8
35 EFF_STRT_DATE TIMESTAMP 8
36 EFF_END_DATE TIMESTAMP 8
37 DATA_LOAD_DATE TIMESTAMP 8
38 SNPSHT_DATE TIMESTAMP 8
39 SRC_SYS_ID CHARACTER VARYING(5) 5
40 LOAD_ID BIGINT 8
41 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
42 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
43 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
44 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8