Maintenance Object: CUST CONTACT - Customer Contact
----------------------------------------------------------------------------------------------------
Table: CI_CC - Customer Contact
----------------------------------------------------------------------------------------------------
The data for CLOB field CC_DATA_AREA should be enclosed by <endclob>.
Delimiter: ,
Enclosing Character: "
For not-nullable fields with no value, provide a single space enclosed in enclosing character
Fields:
The first 30 characters contain target table name CI_CC padded with spaces

CC_ID - Customer Contact ID                                                                         CHAR (10)
USER_ID - User                                                                                      CHAR (8)
PER_ID - Person ID                                                                                  CHAR (10) NULLABLE
CC_DTTM - Contact Date Time                                                                         DATE (26) 'YYYY-MM-DD HH24:MI:SS'
CC_CL_CD - Contact Class                                                                            CHAR (4)
CC_TYPE_CD - Contact Type                                                                           CHAR (12)
PRINT_LETTER_SW - Print Letter                                                                      CHAR (1)
LETTER_PRINT_DTTM - Letter Print Date/Time                                                          DATE (26) 'YYYY-MM-DD HH24:MI:SS' NULLABLE
LTR_TMPL_CD - Letter Template                                                                       CHAR (12)
DESCRLONG - Detailed Description                                                                    VARC (4000)
VERSION - Version                                                                                   NUMB (5)
BATCH_CD - Batch Control                                                                            CHAR (8)
BATCH_NBR - Batch Number                                                                            NUMB (10)
CC_STATUS_FLG - Contact Status                                                                      CHAR (4)
CONTACT_METH_FLG - Preferred Contact Method                                                         CHAR (4)
CC_DATA_AREA - Customer Contact Data Area                                                           CHAR (10000) NULLABLE
C1_CONTACT_ID - Person Contact                                                                      CHAR (10) NULLABLE
PREM_ID - Premise ID                                                                                CHAR (10) NULLABLE
ACCT_ID - Account ID                                                                                CHAR (10) NULLABLE
CC_ENTITY_FLG - Customer Contact Entity                                                             CHAR (4)
----------------------------------------------------------------------------------------------------
Table: CI_CC_CHAR - Customer Contact Characteristics
----------------------------------------------------------------------------------------------------
Delimiter: ,
Enclosing Character: "
For not-nullable fields with no value, provide a single space enclosed in enclosing character
Fields:
The first 30 characters contain target table name CI_CC_CHAR padded with spaces

CC_ID - Customer Contact ID                                                                         CHAR (10)
CHAR_TYPE_CD - Characteristic Type                                                                  CHAR (8)
CHAR_VAL - Characteristic Value                                                                     CHAR (16)
ADHOC_CHAR_VAL - Adhoc Characteristic Value                                                         VARC (254)
CHAR_VAL_FK1 - Characteristic Value FK 1                                                            VARC (50)
CHAR_VAL_FK2 - Characteristic Value FK 2                                                            VARC (50)
CHAR_VAL_FK3 - Characteristic Value FK 3                                                            VARC (50)
CHAR_VAL_FK4 - Characteristic Value FK 4                                                            VARC (50)
CHAR_VAL_FK5 - Characteristic Value FK 5                                                            VARC (50)
VERSION - Version                                                                                   NUMB (5)
SRCH_CHAR_VAL - Search Characteristic Value                                                         VARC (50)
----------------------------------------------------------------------------------------------------
Table: CI_CC_LOG - Customer Contact Log
----------------------------------------------------------------------------------------------------
Delimiter: ,
Enclosing Character: "
For not-nullable fields with no value, provide a single space enclosed in enclosing character
Fields:
The first 30 characters contain target table name CI_CC_LOG padded with spaces

CC_ID - Customer Contact ID                                                                         CHAR (10)
CC_LOG_ID - Customer Contact Log ID                                                                 CHAR (12)
TRIGGER_DT - Trigger Date                                                                           DATE (10) 'YYYY-MM-DD' NULLABLE
ROLE_ID - To Do Role                                                                                CHAR (10)
ASSIGNED_TO - User                                                                                  CHAR (8)
USER_ID - User                                                                                      CHAR (8)
CRE_DTTM - Create Date/Time                                                                         DATE (26) 'YYYY-MM-DD HH24:MI:SS'
CC_LOG_CONTENT - Log Entry                                                                          VARC (2000)
TRIGGER_BP_SW - Trigger Business Process                                                            CHAR (1)
VERSION - Version                                                                                   NUMB (5)