/mcpKeys and NULL Option Data Type Description Name NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NOT NULL varchar(64) The name of the contact table into which this file is to be imported. ContactTableName NULL DBDATETIME Records the date and time when a record is added/updated. DateTimeStamp NULL DBINT The day of the month to run this import. Only used when MonthlyEnabled is set to Y. DayOfMonth NOT NULL DBCHAR Deleted Flag. Stored as a character: • Y = Yes • N = No Deleted NOT NULL DBCHAR Indicates whether file is fixed format, comma delimited, or pipe delimited. • F = Fixed format • C = Comma delimited • P = Pipe delimited DelimiterType NULL DBINT A unique identifier that identifies a department in CCDM/CCMP deployment. DepartmentID NOT NULL DBCHAR A flag that indicates whether this import should be run at the scheduled time: • Y = Run at scheduled time. • N = Do not run at scheduled time. Enabled NULL varchar(255) The directory where the file to be imported is stored. UNC naming convention. FilePath NOT NULL DBCHAR Valid options include: • Y = Import files are imported as soon as they are created. After the import is complete, the import file is renamed or deleted. • N = Import files are not imported as soon as they are created. FilePollingEnabled Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 275 All Tables Import_Rule