CFD_TCFDD_INCIDENT_WORKNOTE

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INCIDENT_SIDE_CODE CHARACTER VARYING(10) 10
2 CUST_INCIDENT_NUM CHARACTER VARYING(20) 20
3 INCIDENT_WRK_NOTE_NUM BIGINT 8
4 SEQ_NUM BIGINT 8
5 EFF_STRT_DATE TIMESTAMP 8
6 CUST_INCIDENT_ID BIGINT 8
7 WRK_NOTE_TYP_CODE BIGINT 8
8 WRK_NOTE_ENTRY_UID CHARACTER VARYING(10) 10
9 WRK_NOTE_ENTRY_DATE TIMESTAMP 8
10 PUBLISH_BIT_MASK_IND BIGINT 8
11 INCIDENT_WRK_NOTE_TEXT CHARACTER VARYING(3000) 3000
12 WRK_NOTE_INSERT_UID CHARACTER VARYING(30) 30
13 WRK_NOTE_INSERT_DATE TIMESTAMP 8
14 WRK_NOTE_MODIFIED_DATE TIMESTAMP 8
15 EFF_END_DATE TIMESTAMP 8
16 SNPSHT_DATE TIMESTAMP 8
17 DATA_LOAD_DATE TIMESTAMP 8
18 SRC_SYS_ID CHARACTER VARYING(5) 5
19 LOAD_ID BIGINT 8
20 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
21 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
22 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
23 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8