DIM_CUST_H_GCIS_CUST_CONSENT_DTL

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CIS_PROFILE_ID INTEGER 4
2 CHANNEL_CODE CHARACTER VARYING(15) 15
3 CONSENT_INDICATOR CHARACTER VARYING(1) 1
4 SOURCE_SYSTEM_ENTERED CHARACTER VARYING(3) 3
5 SOURCE_SYSTEM_WRITTEN CHARACTER VARYING(3) 3
6 USER_ENTERED CHARACTER VARYING(10) 10
7 USER_WRITTEN CHARACTER VARYING(10) 10
8 TIMESTAMP_ENTERED TIMESTAMP 8
9 TIMESTAMP_WRITTEN TIMESTAMP 8
11 EFF_STRT_DATE TIMESTAMP 8
12 EFF_END_DATE TIMESTAMP 8
13 IS_RECORD_CURRENT CHARACTER VARYING(3) 3
14 IS_RECORD_DELETED CHARACTER VARYING(3) 3
15 SNPSHT_DATE TIMESTAMP 8