Contact Manager Fields Character Limits
The following is a list of contact manager fields and custom columns available to the user. The table provides the data type and character limitations of the contact manager fields:
| Name | Null | Data Type |
|---|---|---|
| LVACCOUNT_ID | NOT NULL | NUMBER(38) |
| CLIENT_ID | NOT NULL | NUMBER(38) |
| ACCOUNT | NOT NULL | VARCHAR2(50) |
| B_ACTIVE | NUMBER(38) | |
| ACCOUNT_TO_SPEAK | VARCHAR2(50) | |
| FIRST_NAME | VARCHAR2(50) | |
| LAST_NAME | VARCHAR2(50) | |
| DOB | VARCHAR2(256) | |
| EMAIL_ADDRESS | VARCHAR2(50) | |
| SSN | VARCHAR2(32) | |
| PHONE1 | VARCHAR2(32) | |
| PHONE2 | VARCHAR2(32) | |
| PHONE3 | VARCHAR2(32) | |
| PHONE4 | VARCHAR2(32) | |
| PHONE5 | VARCHAR2(32) | |
| PHONE6 | VARCHAR2(32) | |
| PHONE7 | VARCHAR2(32) | |
| PHONE8 | VARCHAR2(32) | |
| PHONE9 | VARCHAR2(32) | |
| PHONE10 | VARCHAR2(32) | |
| ADDRESS1 | VARCHAR2(50) | |
| ADDRESS2 | VARCHAR2(50) | |
| CITY | VARCHAR2(50) | |
| STATE | VARCHAR2(50) | |
| POSTALCODE | VARCHAR2(10) | |
| COUNTRY_ID | NUMBER(38) | |
| GUARANTOR_FIRSTNAME | VARCHAR2(50) | |
| GUARANTOR_LASTNAME | VARCHAR2(50) | |
| PAYMENTBALANCE | NUMBER(9,2) | |
| AMOUNT_TO_SPEAK | NUMBER(9,2) | |
| ACCOUNT_DUE_DATE | DATE | |
| CALLATTEMPTSTODAY | NUMBER(38) | |
| CALLATTEMPTSLIFETIME | NUMBER(38) | |
| CREATEDATE | DATE | |
| CREATEUSER | DATE | |
| MODIFYDATE | DATE | |
| MODIFYUSER | VARCHAR2(50) | |
| INITIAL_LOAD_DATE | DATE | |
| INITIAL_LOAD_CAMPAIGNID | NUMBER(38) | |
| LAST_LOAD_DATE | DATE | |
| LAST_LOAD_CAMPAIGNID | NUMBER(38) | |
| DO_NOT_DIAL | NOT NULL | NUMBER(38) |
| DO_NOT_DIAL_DAILY | NOT NULL | NUMBER(38) |
| GROUP_ID | NUMBER(38) | |
| ORIGINAL_ACCOUNT_NUMBER | VARCHAR2(50) | |
| PHONE1_ATTEMPTS_TODAY | NUMBER(38) | |
| PHONE1_ATTEMPTS_LIFETIME | NUMBER(38) | |
| PHONE1_DND | NUMBER(38) | |
| PHONE1_DND_DAILY | NUMBER(38) | |
| PHONE2_ATTEMPTS_TODAY | NUMBER(38) | |
| PHONE2_ATTEMPTS_LIFETIME | NUMBER(38) | |
| PHONE2_DND | NUMBER(38) | |
| PHONE2_DND_DAILY | NUMBER(38) | |
| PHONE3_ATTEMPTS_TODAY | NUMBER(38) | |
| PHONE3_ATTEMPTS_LIFETIME | NUMBER(38) | |
| PHONE3_DND | NUMBER(38) | |
| PHONE3_DND_DAILY | NUMBER(38) | |
| PHONE4_ATTEMPTS_TODAY | NUMBER(38) | |
| PHONE4_ATTEMPTS_LIFETIME | NUMBER(38) | |
| PHONE4_DND | NUMBER(38) | |
| PHONE4_DND_DAILY | NUMBER(38) | |
| PHONE5_ATTEMPTS_TODAY | NUMBER(38) | |
| PHONE5_ATTEMPTS_LIFETIME | NUMBER(38) | |
| PHONE5_DND | NUMBER(38) | |
| PHONE5_DND_DAILY | NUMBER(38) | |
| PHONE6_ATTEMPTS_TODAY | NUMBER(38) | |
| PHONE6_ATTEMPTS_LIFETIME | NUMBER(38) | |
| PHONE6_DND | NUMBER(38) | |
| PHONE6_DND_DAILY | NUMBER(38) | |
| PHONE7_ATTEMPTS_TODAY | NUMBER(38) | |
| PHONE7_ATTEMPTS_LIFETIME | NUMBER(38) | |
| PHONE7_DND | NUMBER(38) | |
| PHONE7_DND_DAILY | NUMBER(38) | |
| PHONE8_ATTEMPTS_TODAY | NUMBER(38) | |
| PHONE8_ATTEMPTS_LIFETIME | NUMBER(38) | |
| PHONE8_DND | NUMBER(38) | |
| PHONE8_DND_DAILY | NUMBER(38) | |
| PHONE9_ATTEMPTS_TODAY | NUMBER(38) | |
| PHONE9_ATTEMPTS_LIFETIME | NUMBER(38) | |
| PHONE9_DND | NUMBER(38) | |
| PHONE9_DND_DAILY | NUMBER(38) | |
| PHONE10_ATTEMPTS_TODAY | NUMBER(38) | |
| PHONE10_ATTEMPTS_LIFETIME | NUMBER(38) | |
| PHONE10_DND | NUMBER(38) | |
| PHONE10_DND_DAILY | NUMBER(38) | |
| PRIMARY_EMAIL_CONSENT | NOT NULL | NUMBER(38) |
| SMS | NOT NULL | NUMBER(38) |
| NOT NULL | NUMBER(38) | |
| PHONE1_SMS_CONSENT | NOT NULL | NUMBER(38) |
| PHONE1_CELL_CONSENT | NOT NULL | NUMBER(38) |
| PHONE2_SMS_CONSENT | NOT NULL | NUMBER(38) |
| PHONE2_CELL_CONSENT | NOT NULL | NUMBER(38) |
| PHONE3_SMS_CONSENT | NOT NULL | NUMBER(38) |
| PHONE3_CELL_CONSENT | NOT NULL | NUMBER(38) |
| PHONE4_SMS_CONSENT | NOT NULL | NUMBER(38) |
| PHONE4_CELL_CONSENT | NOT NULL | NUMBER(38) |
| PHONE5_SMS_CONSENT | NOT NULL | NUMBER(38) |
| PHONE5_CELL_CONSENT | NOT NULL | NUMBER(38) |
| PHONE6_SMS_CONSENT | NOT NULL | NUMBER(38) |
| PHONE6_CELL_CONSENT | NOT NULL | NUMBER(38) |
| PHONE7_SMS_CONSENT | NOT NULL | NUMBER(38) |
| PHONE7_CELL_CONSENT | NOT NULL | NUMBER(38) |
| PHONE8_SMS_CONSENT | NOT NULL | NUMBER(38) |
| PHONE8_CELL_CONSENT | NOT NULL | NUMBER(38) |
| PHONE9_SMS_CONSENT | NOT NULL | NUMBER(38) |
| PHONE9_CELL_CONSENT | NOT NULL | NUMBER(38) |
| PHONE10_SMS_CONSENT | NOT NULL | NUMBER(38) |
| PHONE10_CELL_CONSENT | NOT NULL | NUMBER(38) |
| AGENT_ID | NUMBER(38) | |
| AGENT_TEAM_ID | NUMBER(38) | |
| DESCRIPTION | VARCHAR2(255) | |
| DEPARTMENT | VARCHAR2(255) | |
| SALUTATION | VARCHAR2(255) | |
| TITLE | VARCHAR2(255) | |
| COL1 | VARCHAR2(255) | |
| COL2 | VARCHAR2(255) | |
| COL3 | VARCHAR2(255) | |
| COL4 | VARCHAR2(255) | |
| COL5 | VARCHAR2(255) | |
| COL6 | VARCHAR2(255) | |
| COL7 | VARCHAR2(255) | |
| COL8 | VARCHAR2(255) | |
| COL9 | VARCHAR2(255) | |
| COL10 | VARCHAR2(255) | |
| COL11 | VARCHAR2(255) | |
| COL12 | VARCHAR2(255) | |
| COL13 | VARCHAR2(255) | |
| COL14 | VARCHAR2(255) | |
| COL15 | VARCHAR2(255) | |
| COL16 | VARCHAR2(255) | |
| COL17 | VARCHAR2(255) | |
| COL18 | VARCHAR2(255) | |
| COL19 | VARCHAR2(255) | |
| COL20 | VARCHAR2(255) | |
| COL21 | VARCHAR2(255) | |
| COL22 | VARCHAR2(255) | |
| COL23 | VARCHAR2(255) | |
| COL24 | VARCHAR2(255) | |
| COL25 | VARCHAR2(255) | |
| COL26 | VARCHAR2(255) | |
| COL27 | VARCHAR2(255) | |
| COL28 | VARCHAR2(255) | |
| COL29 | VARCHAR2(255) | |
| COL30 | VARCHAR2(255) | |
| COL31 | VARCHAR2(255) | |
| COL32 | VARCHAR2(255) | |
| COL33 | VARCHAR2(255) | |
| COL34 | VARCHAR2(255) | |
| COL35 | VARCHAR2(255) | |
| COL36 | VARCHAR2(255) | |
| COL37 | VARCHAR2(255) | |
| COL38 | VARCHAR2(255) | |
| COL39 | VARCHAR2(255) | |
| COL40 | VARCHAR2(255) | |
| COL41 | VARCHAR2(255) | |
| COL42 | VARCHAR2(255) | |
| COL43 | VARCHAR2(255) | |
| COL44 | VARCHAR2(255) | |
| COL45 | VARCHAR2(255) | |
| COL46 | VARCHAR2(255) | |
| COL47 | VARCHAR2(255) | |
| COL48 | VARCHAR2(255) | |
| COL49 | VARCHAR2(255) | |
| COL50 | VARCHAR2(255) | |
| COL51 | VARCHAR2(255) | |
| COL52 | VARCHAR2(255) | |
| COL53 | VARCHAR2(255) | |
| COL54 | VARCHAR2(255) | |
| COL55 | VARCHAR2(255) | |
| COL56 | VARCHAR2(255) | |
| COL57 | VARCHAR2(255) | |
| COL58 | VARCHAR2(255) | |
| COL59 | VARCHAR2(255) | |
| COL60 | VARCHAR2(255) | |
| COL61 | VARCHAR2(255) | |
| COL62 | VARCHAR2(255) | |
| COL63 | VARCHAR2(255) | |
| COL64 | VARCHAR2(255) | |
| COL65 | VARCHAR2(255) | |
| COL66 | VARCHAR2(255) | |
| COL67 | VARCHAR2(255) | |
| COL68 | VARCHAR2(255) | |
| COL69 | VARCHAR2(255) | |
| COL70 | VARCHAR2(255) | |
| COL71 | VARCHAR2(255) | |
| COL72 | VARCHAR2(255) | |
| COL73 | VARCHAR2(255) | |
| COL74 | VARCHAR2(255) | |
| COL75 | VARCHAR2(255) | |
| COL76 | VARCHAR2(255) | |
| COL77 | VARCHAR2(255) | |
| COL78 | VARCHAR2(255) | |
| COL79 | VARCHAR2(255) | |
| COL80 | VARCHAR2(255) | |
| COL81 | VARCHAR2(255) | |
| COL82 | VARCHAR2(255) | |
| COL83 | VARCHAR2(255) | |
| COL84 | VARCHAR2(255) | |
| COL85 | VARCHAR2(255) | |
| COL86 | VARCHAR2(255) | |
| COL87 | VARCHAR2(255) | |
| COL88 | VARCHAR2(255) | |
| COL89 | VARCHAR2(255) | |
| COL90 | VARCHAR2(255) | |
| COL91 | VARCHAR2(255) | |
| COL92 | VARCHAR2(255) | |
| COL93 | VARCHAR2(255) | |
| COL94 | VARCHAR2(255) | |
| COL95 | VARCHAR2(255) | |
| COL96 | VARCHAR2(255) | |
| COL97 | VARCHAR2(255) | |
| COL98 | VARCHAR2(255) | |
| COL99 | VARCHAR2(255) | |
| COL100 | VARCHAR2(255) |