LeadStatusHistoryTable::getMap

static function getMap()
{
	return array(
		'ID' => array('data_type' => 'integer', 'primary' => true, 'autocomplete' => true),
		'TYPE_ID' => array('data_type' => 'integer', 'required' => true),
		'OWNER_ID' => array('data_type' => 'integer', 'required' => true),
		'CREATED_TIME' => array('data_type' => 'datetime', 'required' => true),
		'CREATED_DATE' => array('data_type' => 'date', 'required' => true),
		'PERIOD_YEAR' => array('data_type' => 'integer'),
		'PERIOD_QUARTER' => array('data_type' => 'integer'),
		'PERIOD_MONTH' => array('data_type' => 'integer'),
		'RESPONSIBLE_ID' => array('data_type' => 'integer'),
		'STATUS_SEMANTIC_ID' => array('data_type' => 'string'),
		'STATUS_ID' => array('data_type' => 'string'),
		'IS_IN_WORK' => array('data_type' => 'boolean', 'values' => array('N', 'Y')),
		'IS_JUNK' => array('data_type' => 'boolean', 'values' => array('N', 'Y')),
		'HAS_SUPPOSED_HISTORY_RECORD' => array(
			'data_type' => 'integer',
			'expression' => array(
				'CASE WHEN EXISTS (SELECT 1 FROM b_crm_lead_status_history_with_supposed WHERE OWNER_ID = %s AND CREATED_TIME = %s AND STATUS_ID = %s) THEN 1 ELSE 0 END',
				'OWNER_ID',
				'CREATED_TIME',
				'STATUS_ID'
			),
		),
	);
}