Admin Guides copy

Page tree

The following table contains most of the Contact Manager fields (including the custom fields) and their data type, along with the character limits specified within parentheses.

FieldData 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)
PHONE2VARCHAR2(32)
PHONE3    VARCHAR2(32)
PHONE4  VARCHAR2(32)
PHONE5      VARCHAR2(32)
PHONE6    VARCHAR2(32)
PHONE7   VARCHAR2(32)
PHONE8       VARCHAR2(32)
PHONE9VARCHAR2(32)
PHONE10VARCHAR2(32)
ADDRESS1    VARCHAR2(50)
ADDRESS2  VARCHAR2(50)
CITY  VARCHAR2(50)
STATE            VARCHAR2(50)
POSTALCODE  VARCHAR2(10)
COUNTRY_ID   NUMBER(38)
GUARANTOR_FIRSTNAMEVARCHAR2(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) 
CREATEDATEDATE
CREATEUSERDATE
MODIFYDATEDATE  
MODIFYUSERVARCHAR2(50)
INITIAL_LOAD_DATE DATE
INITIAL_LOAD_CAMPAIGNID NUMBER(38)
LAST_LOAD_DATEDATE 
LAST_LOAD_CAMPAIGNIDNUMBER(38)
DO_NOT_DIAL (Not Null)NUMBER(38)
DO_NOT_DIAL_DAILY (Not Null)NUMBER(38)
GROUP_ID NUMBER(38)
ORIGINAL_ACCOUNT_NUMBERVARCHAR2(50)
PHONE1_ATTEMPTS_TODAYNUMBER(38)
PHONE1_ATTEMPTS_LIFETIMENUMBER(38)
PHONE1_DNDNUMBER(38)
PHONE1_DND_DAILY NUMBER(38)
PHONE2_ATTEMPTS_TODAYNUMBER(38)
PHONE2_ATTEMPTS_LIFETIMENUMBER(38)
PHONE2_DNDNUMBER(38)
PHONE2_DND_DAILY NUMBER(38)
PHONE3_ATTEMPTS_TODAYNUMBER(38)
PHONE3_ATTEMPTS_LIFETIMENUMBER(38)
PHONE3_DNDNUMBER(38)
PHONE3_DND_DAILY  NUMBER(38)
PHONE4_ATTEMPTS_TODAY  NUMBER(38)
PHONE4_ATTEMPTS_LIFETIMENUMBER(38)
PHONE4_DND NUMBER(38)
PHONE4_DND_DAILYNUMBER(38)
PHONE5_ATTEMPTS_TODAY NUMBER(38)
PHONE5_ATTEMPTS_LIFETIMENUMBER(38)
PHONE5_DNDNUMBER(38)
PHONE5_DND_DAILY NUMBER(38)
PHONE6_ATTEMPTS_TODAY NUMBER(38)
PHONE6_ATTEMPTS_LIFETIMENUMBER(38)
PHONE6_DNDNUMBER(38)
PHONE6_DND_DAILY  NUMBER(38)
PHONE7_ATTEMPTS_TODAYNUMBER(38)
PHONE7_ATTEMPTS_LIFETIMENUMBER(38)
PHONE7_DND NUMBER(38)
PHONE7_DND_DAILYNUMBER(38)
PHONE8_ATTEMPTS_TODAY NUMBER(38)
PHONE8_ATTEMPTS_LIFETIME NUMBER(38)
PHONE8_DNDNUMBER(38)
PHONE8_DND_DAILYNUMBER(38)
PHONE9_ATTEMPTS_TODAYNUMBER(38)
PHONE9_ATTEMPTS_LIFETIMENUMBER(38)
PHONE9_DNDNUMBER(38)
PHONE9_DND_DAILY NUMBER(38)
PHONE10_ATTEMPTS_TODAYNUMBER(38)
PHONE10_ATTEMPTS_LIFETIMENUMBER(38)
PHONE10_DNDNUMBER(38)
PHONE10_DND_DAILYNUMBER(38)
PRIMARY_EMAIL_CONSENT (Not Null) NUMBER(38)
SMS (Not Null)NUMBER(38)
EMAIL (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_IDNUMBER(38)
DESCRIPTIONVARCHAR2(125)
DEPARTMENT VARCHAR2(125)
SALUTATIONVARCHAR2(125)
TITLEVARCHAR2(125)
COL1VARCHAR2(255) 
COL2VARCHAR2(255) 
COL3VARCHAR2(255) 
COL4VARCHAR2(255) 
COL5VARCHAR2(255) 
COL6VARCHAR2(255) 
COL7VARCHAR2(255) 
COL8VARCHAR2(255) 
COL9VARCHAR2(255) 
COL10VARCHAR2(255) 
COL11VARCHAR2(255) 
COL12VARCHAR2(255) 
COL13VARCHAR2(255) 
COL14VARCHAR2(255) 
COL15VARCHAR2(255) 
COL16VARCHAR2(255) 
COL17VARCHAR2(255) 
COL18VARCHAR2(255) 
COL19VARCHAR2(255) 
COL20VARCHAR2(255) 
COL21VARCHAR2(255) 
COL22VARCHAR2(255) 
COL23VARCHAR2(255) 
COL24VARCHAR2(255) 
COL25VARCHAR2(255) 
COL26VARCHAR2(255) 
COL27VARCHAR2(255) 
COL28VARCHAR2(255) 
COL29VARCHAR2(255) 
COL30VARCHAR2(255) 
COL31VARCHAR2(255) 
COL32VARCHAR2(255) 
COL33VARCHAR2(255) 
COL34VARCHAR2(255) 
COL35VARCHAR2(255) 
COL36VARCHAR2(255) 
COL37VARCHAR2(255) 
COL38VARCHAR2(255) 
COL39VARCHAR2(255) 
COL40VARCHAR2(255) 
COL41VARCHAR2(255) 
COL42VARCHAR2(255) 
COL43VARCHAR2(255) 
COL44VARCHAR2(255) 
COL45VARCHAR2(255) 
COL46VARCHAR2(255) 
COL47VARCHAR2(255) 
COL48VARCHAR2(255) 
COL49VARCHAR2(255) 
COL50VARCHAR2(255) 
COL51VARCHAR2(255) 
COL52VARCHAR2(255) 
COL53VARCHAR2(255) 
COL54VARCHAR2(255) 
COL55VARCHAR2(255) 
COL56VARCHAR2(255) 
COL57VARCHAR2(255) 
COL58VARCHAR2(255) 
COL59VARCHAR2(255) 
COL60VARCHAR2(255) 
COL61VARCHAR2(255) 
COL62VARCHAR2(255) 
COL63VARCHAR2(255) 
COL64VARCHAR2(255) 
COL65VARCHAR2(255) 
COL66VARCHAR2(255) 
COL67VARCHAR2(255) 
COL68VARCHAR2(255) 
COL69VARCHAR2(255) 
COL70VARCHAR2(255) 
COL71VARCHAR2(255) 
COL72VARCHAR2(255) 
COL73VARCHAR2(255) 
COL74VARCHAR2(255) 
COL75VARCHAR2(255) 
COL76VARCHAR2(255) 
COL77VARCHAR2(255) 
COL78VARCHAR2(255) 
COL79VARCHAR2(255) 
COL80VARCHAR2(255) 
COL81VARCHAR2(255) 
COL82VARCHAR2(255) 
COL83VARCHAR2(255) 
COL84VARCHAR2(255) 
COL85VARCHAR2(255) 
COL86VARCHAR2(255) 
COL87VARCHAR2(255) 
COL88VARCHAR2(255) 
COL89VARCHAR2(255) 
COL90VARCHAR2(255) 
COL91VARCHAR2(255) 
COL92VARCHAR2(255) 
COL93VARCHAR2(255) 
COL94VARCHAR2(255) 
COL95VARCHAR2(255) 
COL96VARCHAR2(255) 
COL97VARCHAR2(255) 
COL98VARCHAR2(255) 
COL99VARCHAR2(255) 
COL100VARCHAR2(255) 
  • No labels