CFD_TCFDD_ONLINE_REGISTRATION

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ONL_RGSTN_ID BIGINT 8
2 EFF_STRT_DATE TIMESTAMP 8
3 PRDT_INFO_TEXT CHARACTER VARYING(100) 100
4 BRND_CODE CHARACTER VARYING(50) 50
5 REN_DATE TIMESTAMP 8
6 TITLE CHARACTER VARYING(10) 10
7 FRST_NAM CHARACTER VARYING(50) 50
8 MIDDLE_NAM CHARACTER VARYING(50) 50
9 LST_NAM CHARACTER VARYING(50) 50
10 GNDR_CODE CHARACTER VARYING(10) 10
11 OVR_55_IND CHARACTER VARYING(3) 3
12 EMAIL_ID CHARACTER VARYING(150) 150
13 EMAIL_STAT_CODE CHARACTER VARYING(50) 50
14 EMAIL_SENT_DATE TIMESTAMP 8
15 DIALLER_EXTRACT_IND CHARACTER VARYING(3) 3
16 DIALLER_EXTRACT_DATE TIMESTAMP 8
17 PH_NUM CHARACTER VARYING(20) 20
18 PH_STATE_CODE CHARACTER VARYING(50) 50
19 ADDR_LNE_1 CHARACTER VARYING(100) 100
20 ADDR_LNE_2 CHARACTER VARYING(100) 100
21 SBRB_CODE CHARACTER VARYING(50) 50
22 STATE_CODE CHARACTER VARYING(50) 50
23 POST_CODE CHARACTER VARYING(10) 10
24 PROM_CODE CHARACTER VARYING(50) 50
25 CREATED_DATE TIMESTAMP 8
26 MODIFIED_DATE TIMESTAMP 8
27 EFF_END_DATE TIMESTAMP 8
28 DATA_LOAD_DATE TIMESTAMP 8
29 SNPSHT_DATE TIMESTAMP 8
30 SRC_SYS_ID CHARACTER VARYING(5) 5
31 LOAD_ID BIGINT 8
32 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
33 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
34 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
35 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8