云公司数据字段分析
1.4.13 CLUB_FLAG.......................................................................................................................10
1.4.14 TAXPAYER_FLAG............................................................................................................... 10
1.4.15 CUST_POINT......................................................................................................................10
1.4.16 ADD_POINT....................................................................................................................... 10
1.4.17 CHNG_POINT_FLAG........................................................................................................ 10
1.4.18 EXCHGABL_POINT........................................................................................................... 10
1.4.19 GENDER_OLD................................................................................................................... 11
1.4.20 CUST_NAME_PINYIN........................................................................................................ 11
1.4.21 FIRST_NAME_CHAR......................................................................................................... 11
1.4.22 GROUP_CUST_FLAG........................................................................................................ 11
1.5 衍生指标......................................................................................................................................11
1.5.1 ONLINE_DUR.......................................................................................................................11
1.5.2 AGE........................................................................................................................................11
1.6 宽带数据行为..............................................................................................................................12
1.6.1 DIAL_ACCOUNT..................................................................................................................12
1.6.2 SEND_RATE..........................................................................................................................12
1.6.3 RECV_RATE..........................................................................................................................12
1.6.4 ACCS_MODE_CD................................................................................................................ 12
1.6.5 LIMIT_MON_CNT................................................................................................................ 12
1.6.6 LIMIT_HOUR_DUR............................................................................................................. 12
2、 用户账务信息（脱敏）................................................................................................................. 13
2.1 分区键..........................................................................................................................................13
2.1.1 PROV_ID...............................................................................................................................13
2.1.2 MONTH_ID...........................................................................................................................13
2.2 标识信息......................................................................................................................................13
2.2.1 PROV_NAME........................................................................................................................ 13
2.2.2 LATN_ID............................................................................................................................... 13
2.2.3 LATN_NAME.........................................................................................................................13
2.2.4 ACCS_NBR_MD5................................................................................................................. 13
2.2.5 PROD_INST_ID....................................................................................................................14
2.2.6 ACCT_ID...............................................................................................................................14
2.2.7 OWN_CUST_ID.................................................................................................................... 14
2.3 缴费信息......................................................................................................................................14
2.3.1 PAY_CHARGE.......................................................................................................................14
2.3.2 PAY_TIMES........................................................................................................................... 14
2.3.3 PAY_METHOD_TYPES.........................................................................................................14
2.3.4 MAX_PAY_METHOD............................................................................................................14
2.4 销账信息......................................................................................................................................15
2.4.1 BILL_AMT.............................................................................................................................15
2.4.2 LATE_AMT............................................................................................................................15
2.5 余额信息......................................................................................................................................15
2.5.1 BALANCE..............................................................................................................................15
2.5.2 STORE_BALANCE................................................................................................................15
评论0