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