SQL Database Tables
Below are the different data sets that you will find in the Loans_R database after deployment.
| Table | Description | 
|---|---|
| Loan | Raw data about each loan | 
| Borrower | Raw data about each borrower | 
| Merged | The merged result of Loan and Borrower | 
| Stats | Modes or Means of variables of Merged for missing values replacement | 
| Merged_Cleaned | Merged table with missing values replaced | 
| Bins | Serialized list of cutoffs used to bin numeric variables | 
| Merged_Features | Analytical data set: cleaned merged table with new features | 
| Column_Info | Serialized list of variable information including factors and their levels | 
| Hash_Id | Loan Ids and Mapping through hash function for splitting | 
| Model | Serialized version of the trained logistic regression | 
| Logistic_Coeff | Coefficients of the logistic regression formula in decreasing order of magnitude | 
| Predictions_Logistic | Predictions made on the testing set | 
| Metrics | Performance metrics of the evaluated model | 
| Operational_Metrics | Percentiles of the scores, corresponding score thresholds and bad rates among scores higher than thresholds | 
| Scores_Average | Average of the predicted scores used in scores transformation | 
| Scores | Scores computed on the testing set, transformed with Operational_Metrics | 
 
          