rps Table: Historical Lease
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rps Historical Lease table.

Parent-Child: This table has one or more child tables--click here for a listing.



rps Columns

DescriptionColumn NameData Type ?Characteristics ?
Leaselse_scharlength 10
Record modification stampstamp_lnumberprecision 10
Portfoliopor_scharlength 2
Companycom_scharlength 2
Regionreg_scharlength 2
Officeoff_scharlength 3
Lessee numberles_scharlength 9
Vendordlr_scharlength 9
Equipment acquisition dated_acq_sdateformat YYYYMMDD
Lease dated_lsd_sdateformat YYYYMMDD
Equipment activity status dated_act_sdateformat YYYYMMDD
Maturity dated_mat_sdateformat YYYYMMDD
Effective dated_eff_sdateformat YYYYMMDD
Date of payoff/terminationd_pay_sdateformat YYYYMMDD
Time of payoff/terminationt_pay_scharlength 6
Activity statusact_scharlength 4
Lease ratingrat_scharlength 4
Payoff sourcep_src_scharlength 4
Payoff methodmeth_scharlength 4
Transaction codetrn_scharlength 4
Asset manufacturer codemnf_scharlength 4
Asset model codemdl_scharlength 4
Asset model yearmodel_yr_scharlength 2
New/used (N/U)new_ccharlength 1
Payoff type - payoff/termination (P/T)ptyp_ccharlength 1
Lease descriptiondesc_svarchar2length 36
Operator initialsopr_scharlength 3
Number of payments accruedpmt_lnumberprecision 10
Lease termtrm_lnumberprecision 10
Payoff amount duepay_due_dnumberprecision 15, scale 2
Proceeds of salepro_sale_dnumberprecision 15, scale 2
Gain/Loss on terminationgnls_dnumberprecision 15, scale 2
Allowance for bad debtallow_dnumberprecision 15, scale 2
Original acquisition costorg_dnumberprecision 15, scale 2
Residual amountres_dnumberprecision 15, scale 2
Net receipts L-T-D (actual)rec_ltd_dnumberprecision 15, scale 2
Net receipts Y-T-Drec_ytd_dnumberprecision 15, scale 2
Other income L-T-Doth_ltd_dnumberprecision 15, scale 2
Other income Y-T-Doth_ytd_dnumberprecision 15, scale 2
Payoff taxable amounttax_amt_dnumberprecision 15, scale 2
Number of times delinquent [1]del1_lnumberprecision 10
Number of times delinquent [2]del2_lnumberprecision 10
Number of times delinquent [3]del3_lnumberprecision 10
Number of times delinquent [4]del4_lnumberprecision 10
Number of times delinquent [5]del5_lnumberprecision 10
Number of times delinquent [6]del6_lnumberprecision 10
Number of times delinquent [7]del7_lnumberprecision 10
Excess mileagemileage_dnumberprecision 15, scale 2
Wear & tearwear_dnumberprecision 15, scale 2
FMV quotefmv_dnumberprecision 15, scale 2
Security depositsec_dnumberprecision 15, scale 2
Reversed paymentsrev_pmt_dnumberprecision 15, scale 2
Base payoff amountbase_dnumberprecision 15, scale 2
Payments outstandingpmt_outs_dnumberprecision 15, scale 2
Assessments outstandingasm_outs_dnumberprecision 15, scale 2
Additional chargesadd_dnumberprecision 15, scale 2
Fee/penaltyfee_dnumberprecision 15, scale 2
ITC recaptureditc_dnumberprecision 15, scale 2
Credit life insurance 1 rebatecr_lif1_re_dnumberprecision 15, scale 2
Credit life insurance 2 rebatecr_lif2_re_dnumberprecision 15, scale 2
Credit disability insurance 1 rebatecr_dis1_re_dnumberprecision 15, scale 2
Credit disability insurance 2 rebatecr_dis2_re_dnumberprecision 15, scale 2
Total quotequote_dnumberprecision 15, scale 2
Total receivedtot_rcv_dnumberprecision 15, scale 2
Payoff amountpayoff_dnumberprecision 15, scale 2
Refund check amountrefund_dnumberprecision 15, scale 2
Debt principle balance amountdebt_prn_bal_dnumberprecision 15, scale 2
Debt additional interest amountdebt_add_int_dnumberprecision 15, scale 2
Debt penalty fee amountdebt_pen_dnumberprecision 15, scale 2
Tax gain/loss amounttax_gnls_dnumberprecision 15, scale 2
Staged equity account payable clearing amountstg_eqty_ap_clr_dnumberprecision 15, scale 2
Broker fee account payable clearing amountbrk_fee_ap_clr_dnumberprecision 15, scale 2
Payoff source namepayo_src_name_svarchar2length 36
Principal write down (Y/N)prn_write_down_ccharlength 1
Metro2 file format codemetro2_scharlength 4
Date of first delinquencyd_first_delq_sdateformat YYYYMMDD
Invoice format codeinvo_format_scharlength 4
Security deposit disbursal status (P/U/N)
P - processed
U - unprocessed
N - n/a
sec_status_ccharlength 1
Security deposit refund amountsec_refund_dnumberprecision 15, scale 2
Non commission amountnon_comm_dnumberprecision 15, scale 2



rps Indexes

Index NamePiece 1Piece 2Piece 3Piece 4Piece 5
rps_idx0lse_s
rps_idx1por_scom_sreg_soff_slse_s
rps_idx2les_slse_s
rps_idx3dlr_slse_s



Child Table Listing

Table NameDescription
rpspHistorical Lease Payment Schedule



Data Type Definitions and Characteristics

Following are descriptions of the Oracle data types used in the LeasePak database. Note that LeasePak does not use all the Oracle data types.

char
Oracle fixed length character string. Typically used to store short-length string data such as keys, four-character codes, and single-character switch values.
Characteristics:
  • length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.

date
Oracle date and time, containing century, year, month, day, hour, minute, and second information.
Characteristics:
  • format - The date format for the LeasePak database. For example, format YYYYMMDD is the 4-digit year number followed by the 2-digit month number followed by the 2-digit day number with no intervening punctuation.

number
Oracle numeric data type. Used for all numbers.
Characteristics:
  • precision - The magnitude and fractional granularity together, meaning the maximum number of places available to both the left and right of the decimal point. Use precision minus scale to determine the maximum number of places available to the left of the decimal point.
  • scale - The fractional granularity, meaning the maximum number of places available to the right of the decimal point.

varchar2
Oracle variable length character string. Typically used to store medium and long-length string data such as names, addresses, descriptions, and notebook entries.
Characteristics:
  • length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.