SQL Database Tables
Below are the different data sets that you will find in the Fraud_R database after deployment.
| File | Description |
|---|---|
| Account_Info | Raw account data |
| Untagged_Transactions | Raw transactions data without tags and without account data |
| Fraud | Raw fraudulent transactions data |
| Account_Info_Sort | Account_Info table, sorted in ascending order of accountID and descending order of the records date |
| Untagged_Transactions_Acct | Untagged transactions with account information |
| Tagged | Tagged transactions with account information |
| Hash_Id | Each account ID hashed to an integer |
| Tagged_Training | Training set with tagged data |
| Tagged_Training_Preprocessed (View) | Preprocessed training set |
| Tagged_Training_Preprocessed_Features1 (View) | Intermediate preprocessed training set with new features |
| Tagged_Training_Preprocessed_Features (View) | Preprocessed training set with new features |
| Risk Tables | Each one contains the risk value for every level of a given variable, computed on the training set |
| Risk_Var | Names of the risk tables and variables they correspond to |
| Transaction_History | Historical data to be used for aggregates computation |
| Trained_Model | Serialized GBT model trained on the training set |
| Tagged_Testing | Testing set with tagged data |
| Tagged_Testing_Preprocessed (View) | Preprocessed testing set |
| Tagged_Testing_Preprocessed_Features1 (View) | Intermediate preprocessed testing set with new features |
| Tagged_Testing_Preprocessed_Features (View) | Preprocessed testing set with new features |
| Predict_Score | Predicted scores on the testing set |
| Performance_Auc | Area under the curve (AUC) for predictions on the testing set |
| Performance | Account level evaluation metrics for predictions on the testing set |
| Parsed_String | Single transaction parsed into variables |
| Parsed_String_Acct | Single transaction parsed into variables, with added account information |
| Parsed_String_Acct_Preprocessed (View) | Single transaction parsed and preprocessed |
| Parsed_String_Acct_Preprocessed_Features1 (View) | Intermediate preprocessed single transaction parsed with new features |
| Parsed_String_Acct_Preprocessed_Features (View) | Single transaction parsed, preprocessed, and with new features |
| Predict_Score_Single_Transaction | Predicted score for the single transaction |
