/mcpTable 73: Fields in Bulk_Job Table Keys and NULL Option Data Type Description Name PK NOT NULL DBINT Auto-assigned Unique ID and Primary Key. BulkJobID NOT NULL CHANGESTAMP Incremented when the record is changed in the database ChangeStamp NULL DBDATETIME The date and time when the job was created CreateDateTime NULL DBDATETIME Records the date and time when a record is added / updated. DateTimeStamp NULL DBINT Foreign key from Department. NULL for global department. DepartmentID NULL DESCRIPTION Describes this job Description NULL DBDATETIME The date and time when the job was finished EndDateTime NULL varchar(64) The AW on which the job will run JobHostName NULL DBSMALLINT The state of the job. The options are: • 1 = Queued • 2 = Processing • 3 = Completed successfully • 4 = Failed • 5 = Cancelled JobState NOT NULL DBSMALLINT Indicates the type of bulk job. The options are: • 1 = Dialed Number • 2 = Agent • 3 = Call Type • 4 = Skill Group • 5 = SSO Migration • 102 = Inventory Note The operation types (create, update, delete) are specified in the CSV file with each record. JobType Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 106 All Tables Bulk_Job