Some samples from SFS
Post date: Nov 14, 2013 8:33:20 PM
siva_ddl.sfs_event_workflows
workflow_id customer_id region_id marketplace_id workflow_type workflow_status completed_reason
Min. : 99415201 Min. :3.573e+03 Min. :1 Min. :1 FraudSeller :173318 Completed:245303 ActionTaken: 9532
1st Qu.:100471388 1st Qu.:6.498e+08 1st Qu.:1 1st Qu.:1 SFSBuyerSellerCollusion: 56843 Running :164949 Passed :222799
Median :101527776 Median :1.522e+09 Median :1 Median :1 VCACSeller : 97287 Terminated : 12972
Mean :101527243 Mean :2.374e+16 Mean :1 Mean :1 VelocityEvaluation : 82804 NA's :164949
3rd Qu.:102582104 3rd Qu.:8.118e+09 3rd Qu.:1 3rd Qu.:1
Max. :103639461 Max. :9.223e+18 Max. :1 Max. :1
event_type event_source event_status event_date created_by creation_date last_updated_by
ProActiveVelEval :82804 SIVA :254114 Succeeded:410252 23-OCT-13: 16291 mqapps:410252 24-OCT-13: 16106 mqapps:410252
bankAccountUpdateVCAC:58108 FraudService : 82804 24-OCT-13: 16149 23-OCT-13: 16100
bankAccountUpdateDup :56855 InvestigatorWorkbench: 28098 28-OCT-13: 15901 28-OCT-13: 15866
bankAccountUpdate :56204 FOLDAction : 20260 03-OCT-13: 15749 03-OCT-13: 15749
AWSRegistration :54146 CATNIP : 10663 07-OCT-13: 15663 07-OCT-13: 15663
CCUpdate :28801 BBC : 10169 22-OCT-13: 15582 22-OCT-13: 15580
(Other) :73334 (Other) : 4144 (Other) :314917 (Other) :315188
last_updated_date
15-OCT-13: 16587
23-OCT-13: 16215
24-OCT-13: 16035
28-OCT-13: 15826
03-OCT-13: 15754
07-OCT-13: 15667
(Other) :314168
> unique(impopSeller$workflow_type)
[1] FraudSeller VelocityEvaluation VCACSeller SFSBuyerSellerCollusion
Levels: FraudSeller SFSBuyerSellerCollusion VCACSeller VelocityEvaluation
> unique(impopSeller$workflow_status)
[1] Running Completed
Levels: Completed Running
> unique(impopSeller$completed_reason)
[1] <NA> Passed ActionTaken Terminated
Levels: ActionTaken Passed Terminated
> unique(impopSeller$event_type)
[1] signin ProActiveVelEval CCUpdate bankAccountUpdateVCAC AWSRegistration bankAccountUpdateDup
[7] foldListingVCAC SellerFraudRefund bankAccountUpdate RiskyContact foldListingFraud block
[13] fraud SellerRiskyRefund OfflineFraud SellerRefund RiskyListingFraud
17 Levels: AWSRegistration CCUpdate OfflineFraud ProActiveVelEval RiskyContact RiskyListingFraud SellerFraudRefund SellerRefund ... signin
> unique(impopSeller$event_source)
[1] CATNIP FraudService SIVA FOLDAction RefundControlService BBC
[7] InvestigatorWorkbench OfflineFraud OfflineReport
Levels: BBC CATNIP FOLDAction FraudService InvestigatorWorkbench OfflineFraud OfflineReport RefundControlService SIVA
siva_ddl.sfs_actions
action_id region_id workflow_id action_type rule_id status
Min. :27174521 Min. :1 Min. : 97195991 Annotate : 55552 secondary_fraud_relation_audit: 35773 Completed :243259
1st Qu.:27785216 1st Qu.:1 1st Qu.:100310456 Audit :114721 high_short_term_odr : 24090 Error : 65
Median :28396071 Median :1 Median :101426841 Investigate : 10820 primary_fraud_relation : 22702 SkippedDuplicate: 947
Mean :28396037 Mean :1 Mean :101382167 VelocityEvaluation.bump20: 12248 fraudrl_cc_alone : 21886
3rd Qu.:29006776 3rd Qu.:1 3rd Qu.:102447091 VelocityEvaluation.pass : 50930 Silver tier low risk-bump20 : 21645
Max. :29617561 Max. :1 Max. :103639461 Seller warned in last 30 days : 17319
(Other) :100856
reason
audit rule :114721
Matched Rule : 52759
SellerFraudService rules fired :<br>[Seller warned in last 30 days] (fired ruleId=96751): <br> [Rule Data]:$num_warnseller_actions=1<br> : 12793
SellerFraudService rules fired :<br>[Number of VL changes last day] (fired ruleId=99261): Pass seller if number of Velocity Limit changes in the last 24 hrs above threshold.<br> [Rule Data]:$vl_change_last_day=1<br>: 4667
SellerFraudService rules fired :<br>[Check seller age exists] (fired ruleId=5347050): <br> [Rule Data]:<br> : 4304
SellerFraudService rules fired :<br>[high_short_term_odr] (fired ruleId=6347550): Short term ODR high.<br> [Rule Data]:$numdefects15_75=0, $num3porders15_75=0<br> : 3230
(Other) : 51797
created_by creation_date last_updated_by last_updated_date
mqapps:244271 24-OCT-13: 9666 mqapps:244271 24-OCT-13: 9666
30-OCT-13: 9544 30-OCT-13: 9544
23-OCT-13: 9418 23-OCT-13: 9418
25-OCT-13: 9365 25-OCT-13: 9364
22-OCT-13: 9300 22-OCT-13: 9300
29-OCT-13: 9273 29-OCT-13: 9273
(Other) :187705 (Other) :187706
> unique(impopSeller$action_type)
[1] VelocityEvaluation.pass Annotate Investigate Audit VelocityEvaluation.bump20
Levels: Annotate Audit Investigate VelocityEvaluation.bump20 VelocityEvaluation.pass
> unique(impopSeller$rule_id)
[1] silver_tier_high_vl Seller listings enforcement in last 30 d Number of VL changes last day
[4] Seller warned in last 30 days fraudrl_cmsphone1 LowSellerBuyerCommRate
[7] Silver tier low risk-bump20 Low_current_velocitylimit Score age
[10] high_short_term_odr secondary_fraud_relation_audit NewSigninIP3
[13] check_pending_status commmgr_response_rate fraudrl_cc_alone
[16] primary_fraud_relation risky_listing_mid_not_same risky_type_A_level1
[19] fraudrl_fp1 Queued for fraud suspicion in last 30 da Seller has disbursement restrictions
[22] risk_type_A_level2 seller reinstated in last 30 days Check seller age exists
[25] combination_LR_model3 fine_tune_fraudrl_cc awsNegHits
[28] blocked_neg_hit awsHRI risky_listing_high_siva_score
[31] Individual tier low risk-bump20 fine_tune_fraudrl_cc_relaxed buyer_seller_related
[34] secondary_relations_small_seller Currently on watchlist or rolling reserv fraudrl_fubid1
[37] primary_fraud_relation_v2 awsRiskyRels fba_cnr_mo
[40] Number of autobumps neg_hard_hit awsRiskyIPDoms
[43] fraudrelation_fp_IPDomain risk_type_A_level3 risk_type_A_age_random
[46] individual_tier_high_velocity Seller PYP action in last 30 days fraudrl_passwd1
[49] suspicious_recent_signins HighFraudRatioIPandFP1 RiskyCountry
[52] BAUpdate_First_GMISurge fold_gmilow_ba_and_signin risky_signins_7_day
[55] combination_LR_model2 awsSICInconsistency baupdate_acctupdate_riskysignin
[58] inconsSigninNewBA shipped_from_multiple_states buyer_seller_related_second
[61] combination_LR_model1 total_related_buyers fold_firstGMI_ba
[64] fraudrl_fubid_ubid risky_listing_high_siva_score_v2 BAUpdate_GMISurge
[67] Check if velocity limit exists vcac_caper_risky_event risky_signin_30day_count
[70] suspicious_refund fold_textbook_vc_check RiskyBankName
[73] shipment_intercepted_by_sender redirect_comm counterfeit_commmgr_messages
[76] Velocity limit exempt
> unique(impopSeller$status)
[1] Completed SkippedDuplicate Error
Levels: Completed Error SkippedDuplicate