CDI_TCFDD_CUSTOMER_AUX_RTH

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(3) 3
2 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
3 BRND_CODE CHARACTER VARYING(10) 10
4 CONSNT_FLG CHARACTER VARYING(1) 1
5 CONSNT_UPD_DT TIMESTAMP 8
6 SAC_CODE CHARACTER VARYING(8) 8
7 POLICY_NUM CHARACTER VARYING(30) 30
8 REGISTERED_DT TIMESTAMP 8
9 EZINE_SUBSCRIBED_FLG CHARACTER VARYING(20) 20
10 EZINE_SUBSCRIPTION_CHG_DATE TIMESTAMP 8
11 TOT_VISITS_CNT BIGINT 8
12 LST_VISIT_DATE TIMESTAMP 8
13 Q_SCORE_DATE_TME TIMESTAMP 8
14 Q_SCORE BIGINT 8
15 EXERCISE_TYP CHARACTER VARYING(10) 10
16 CIGARETTE_CNT BIGINT 8
17 ALCOHOL_AMT NUMERIC(16,2) 19
18 CUST_HEIGHT CHARACTER VARYING(6) 6
19 CUST_WEIGHT CHARACTER VARYING(6) 6
20 CUST_WAISTSIZE CHARACTER VARYING(6) 6
21 CUST_HIPSIZE CHARACTER VARYING(6) 6
22 CUST_BLOOD_PRESSURE CHARACTER VARYING(6) 6
23 CUST_SYSTOLIC_BP CHARACTER VARYING(3) 3
24 CUST_DIASTOLIC_BP CHARACTER VARYING(3) 3
25 CUST_BPREADING_METH CHARACTER VARYING(8) 8
26 CUST_CVDRISK CHARACTER VARYING(6) 6
27 CUST_CHOLESTEROL_VAL CHARACTER VARYING(6) 6
28 TOT_CHOLESTEROL_VAL CHARACTER VARYING(6) 6
29 HDL_CHOLESTEROL_VAL CHARACTER VARYING(6) 6
30 CUST_GLUCOSE_VAL CHARACTER VARYING(4) 4
31 CUST_FASTING_HOURS CHARACTER VARYING(5) 5
32 CUST_DIET_SCORE CHARACTER VARYING(4) 4
33 CUST_STRESS_SCORE CHARACTER VARYING(4) 4
34 DIABETIC_FLG CHARACTER VARYING(1) 1
35 APPOINTMENTS_BOOKED CHARACTER VARYING(4) 4
36 APPOINTMENTS_ATTD CHARACTER VARYING(4) 4
37 TWELVE_WK_SIGNUP_FLG CHARACTER VARYING(1) 1
38 ALCOHOL_PRGRM_FLG CHARACTER VARYING(1) 1
39 SMOKING_PRGRM_FLG CHARACTER VARYING(1) 1
40 EXERCISE_PRGRM_FLG CHARACTER VARYING(1) 1
41 DIET_PRGRM_FLG CHARACTER VARYING(1) 1
42 WEIGHT_PRGRM_FLG CHARACTER VARYING(1) 1
43 DATE_ARCHIVED TIMESTAMP 8
44 CUST_HEALTH_ISSUES_DETS CHARACTER VARYING(100) 100
45 SAC_DESC CHARACTER VARYING(50) 50
46 BEST_DESCRIBES_YOU CHARACTER VARYING(100) 100
47 VOUCHER_CODE CHARACTER VARYING(50) 50
48 CNTCT_PH_NUM CHARACTER VARYING(50) 50
49 EFF_STRT_DATE TIMESTAMP 8
50 EFF_END_DATE TIMESTAMP 8
51 DATA_LOAD_DATE TIMESTAMP 8
52 SNPSHT_DATE TIMESTAMP 8
53 SRC_SYS_ID CHARACTER VARYING(5) 5
54 LOAD_ID BIGINT 8
55 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
56 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
57 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
58 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8