m2

--手动催欠任务
select * from ccare.dc_manual_collect_task;
/*
任务流水 TASK_ID
任务ID FIXED_TASK_ID
帐户ID ACCT_ID
客户ID CUST_ID
用户ID SUB_ID
地区编码 LOCAL_ID
任务状态 STATUS
原因 STATUS_REASON
催欠员ID COLLECTOR_ID
跟踪员ID TRACER_ID
加入时间 ENTRY_DATE
分配时间 ASSIGN_DATE
过期时间 EXP_DATE
备注 REMARK
操作员ID OPER_ID
操作日期 OPER_DATE
欠费总额 ALL_INVOICE_AMT
缴费总额 ALL_PAYMENT_AMT
*/

select * from ccare.dc_manual_collect_task_sub;

select * from ccare.dc_tmp_collect_task_info;

--select * from ccare.dc_rule_group_collect_param;

select * from ccare.dc_rule_status_chg;

---------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------
--自动指派催欠任务(Auto Assign Collect Task)
select * from ccare
---------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------
--催欠员动作(Collector Activity)
select * from ccare.dc_collector_activity;
---------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------
--分期缴费(Installment)

---------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------
--佣金管理(Commission Management)

---------------------------------------------------------------------------------------------------------

--任务表
select * from ccare.dc_credit_validate_task;

--调查因子表
select * from ccare.dc_credit_validate_result;
    --Validator_id：调查员
    --Check_staff_id：检查员
    --Local_id：用户local
    --Eff_date：用户激活时间
    --Result_date：记录调查结果的时间
    --Mapping_result_1：对应界面上Criteria
    --Mapping_result_2：INFORMATION FROM FIELD SURVEY，界面上没有显示，可以不用关心