Home
Contents
Index
Search
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
Home
Contents
Index
Search