CFD_TCFDD_INCIDENT_REMINDER

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INCIDENT_SITE_CODE CHARACTER VARYING(10) 10
2 INCIDENT_REMINDER_NUM BIGINT 8
3 CUST_INCIDENT_NUM CHARACTER VARYING(20) 20
4 INCIDENT_TBL_NAM CHARACTER VARYING(30) 30
5 EFF_STRT_DATE TIMESTAMP 8
6 CUST_INCIDENT_ID BIGINT 8
7 USER_ID CHARACTER VARYING(20) 20
8 INCIDENT_MSG_TEXT CHARACTER VARYING(300) 300
9 DUE_BY_DATE TIMESTAMP 8
10 RECUR_TYP_CODE BIGINT 8
11 RECUR_INTERVAL_CODE BIGINT 8
12 INCIDENT_ALARAM_CODE BIGINT 8
13 INCIDENT_REMINDER_INSERT_DATE TIMESTAMP 8
14 RECORD_STAT_CODE BIGINT 8
15 MODIFIED_DATE TIMESTAMP 8
16 EFF_END_DATE TIMESTAMP 8
17 SNPSHT_DATE TIMESTAMP 8
18 DATA_LOAD_DATE TIMESTAMP 8
19 SRC_SYS_ID CHARACTER VARYING(5) 5
20 LOAD_ID BIGINT 8
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8