You are here: Database Tables > Explanation of the Major RLSS Database Tables

EXPLANATION OF THE MAJOR RLSS DATABASE TABLES

Menu Item

Tools














​
​Codes




















​Loan Master

















​



​Master Query














​Loan Activity





Amortizations



​
​Reports




































​Special Features

Table

tblOrg


​tblSecurity

tblMenuOptions

tblSupplement


​tblOptions


​tblCompanies


tblSetupStatus

tblSetupLoanOfficer

tblSetupBorrower


tblSetupLoanType

tblSetupFundSource

tblSetupCollateral

tblSetupZoning

tblSetupGL

​
​tblSetupElement


tblLoanMaster

tblLoanInfo


tblLoanFund



​tblOptionDetail


tblLoanCollateral

tblSetupEthnicity


​tblStates

​tblMultipleBorrower


tblMasterFileQueryA



tblMasterFileQueryM



​tbleMFQM

​
​tbleReportsFields



tblLoanActivity

tblLoanAdditionalCost


tblAschedule

tblLoanAmortization
​

​
tblMasterFileReport


tblTempMasterFile


tblStatusTemp


tblMonthlyLoanTrans


tblSetupJournal



tblJournalEntry



tblJournalEntryDetail


tblJournalEntryTemp


tblAgingReportTemp


tblPortfolioStatisticsTemp



​​tblMonthFundSource

​

tblConversation


tblLoanCoupons


​​tblQuickDateListing

Explanation

​Oranization name, address, phone number, FID#, and GMS client #

User names and passwords

User access to program features

Installed supplements and related passwords

Optional Loan Master field names and data types

​Log-in organization name(s)


Loan Status codes and descriptions

Loan Officer codes and descriptions

Borrower Type codes and descriptions

Loan Type codes and descriptions

Loan Fund codes and descriptions

Collateral descriptions

Zoning codes and descriptions

General Ledger codes and descriptions

Element codes and descriptions


"Borrower" tab data

"Loan Statistics" and "Loan Terms" data

Funds, amounts and percentage of total funding associated with each loan

Optional field data associated with each loan

Collateral associated with each loan

Ethnicity codes as input into Loan Master

All available 2-character state codes

"Multiple Borrower" data


Temporary table to hold loan activity details if selected during query preparation

Temporary table to hold master file details if selected during query preparation

Temporary table used in preparation of Master Query reports

​Temporary table to hold data for reporting format


Details of all recorded activity

Holds Additional Loan Costs entered


Create a new amortization schedule

Holds stored amortization schedules for potential retrieval


Temporary table to organize and prepare Master File Report

Temporary table to organize and prepare Master File Report

Temporary table to organize and prepare Master File Report

Temporary table to prepare Monthly Activity Report

Holds Journal Entry setup, associating GL codes with specific funds and elements

Holds batch numbers, element numbers, and activity period for prepared Journal Entries

Activity details associated with created Journal Entries

Temporary table used to create Journal Entries

Temporary table used to organize and create delinquency reports

Temporary table used to organize and create Portfolio Statistics Report

​Temporary table to prepare Portfolio Statistics Report when pulled by specific funding source.


Stores conversations entered through Loan Master Files

Temporary table used to calculate and create Loan Coupons

​Temporary table used to calculate and create Quick Date Listings