RulePoint
- RulePoint 6.2
- All Products
INSERT INTO Loan_Processing."CUSTOMER_PERSONAL_INFO" (Customer_ID,Customer_Name,Customer_Age,Customer_Address,Customer_Home_Phone_Number,Customer_Office_Address,Customer_Office_Phone_Number,Customer_Company_Name,Customer_Company_Address, Customer_Years_In_Present_Job) VALUES (1,'Michael Crichton',32,'7, Broadway Drive, NewYork, USA',87325426,'8, Passway Road, New York USA', 8792432, 'Ginge', '2321, Pathway Drive, USA', 5); INSERT INTO Loan_Processing."CUSTOMER_FINANCIAL_INFO"(Customer_ID, Net_Take_Home_Salary_per_Month, Customer_Net_Assets, Loan_EMI_payment_per_month, Total_loans) VALUES (1, 80000, 2000000, 10000, 11000); INSERT INTO Loan_Processing."CUSTOMER_CREDIT_INFO"(Customer_ID, Customer_Credit_Rating, History_of_Paying_back_loan) VALUES (1, 2, 2); INSERT INTO Loan_Processing."CUSTOMER_FAMILY_INFO"(Customer_ID, Customer_Married, Customer_Number_Of_Dependents, Spouse_Net_Salary, Years_In_Same_Marriage) VALUES (1, 1, 2,0,7); INSERT INTO Loan_Processing."CUSTOMER_CRIMINAL_INFO"(Customer_ID, Customer_Criminal_Record) VALUES (1, 1); INSERT INTO Loan_Processing."CUSTOMER_MEDICAL_HISTORY"(Customer_ID, Medical_History_Of_Customer) VALUES (1, 3); INSERT INTO Loan_Processing."CUSTOMER_LOAN_REQUEST_INFO"(Customer_ID, Customer_Loan_Amount_Requested, Number_Of_Months_To_Pay_Back) VALUES (1, 100000, 60);