rca Table: Lease Form
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rca Lease Form table.

rca Columns

DescriptionColumn NameData Type ?Characteristics ?
Lease form codefrm_scharlength 4
Record modification stampstamp_lnumberprecision 10
Late charge methodlatch_scharlength 4
Purchase option methodpurch_scharlength 4
Out of state relocation policyreloc_scharlength 4
Payoff calculation methodpayoff_scharlength 4
Termination calculation methodtermin_scharlength 4
Prepayment penalty methodprepay_scharlength 4
Property tax late charge codeptax_scharlength 4
Lease form descriptiondesc_svarchar2length 36
Use assessments in late charge calculations (Y/N)asm_in_late_chrg_ccharlength 1
Insurance - public liability (Y/N)ins_pl_ccharlength 1
Insurance - property damage (Y/N)ins_pd_ccharlength 1
Insurance - collision deductible (Y/N)ins_cd_ccharlength 1
Insurance - comprehensive (Y/N)ins_co_ccharlength 1
Insurance - additional insured (Y/N)ins_ai_ccharlength 1
Insurance - loss payable (Y/N)ins_lp_ccharlength 1
Insurance - bodily injury liability (Y/N)ins_bi_ccharlength 1
Early term - termination fee (Y/N)tea_tf_ccharlength 1
Early term - pre-payment penalties (Y/N)tea_pp_ccharlength 1
Maturity - termination late charge (Y/N)tma_lc_ccharlength 1
Maturity - termination late charge (Y/N)tma_tf_ccharlength 1
Maturity - excess mileage charge (Y/N)tma_em_ccharlength 1
Maturity - wear & tear deductible (Y/N)tma_wt_ccharlength 1
Maturity - purchase option (Y/N)tma_po_ccharlength 1
Maturity - new lease (Y/N)tma_nl_ccharlength 1
Maturity - finance (Y/N)tma_fn_ccharlength 1
Mileage - average allowable (Y/N)mil_aa_ccharlength 1
Payoff - calculate sales tax on payoff (Y/N)pay_st_ccharlength 1
Payoff - include ITC recapture (Y/N)pay_it_ccharlength 1
Payment effective date default (C/D)
C - Current date
D - Due date
eff_def_ccharlength 1
Place late charge on delinquent invoice (Y/N)ltch_on_delinq_ccharlength 1
Average yearly allowable mileagemil_aam_lnumberprecision 10
Grace days for late charge termination calculationtma_grc_lnumberprecision 10
Grace period in daysgrc_lnumberprecision 10
Late charge percentagep_lc_dnumberprecision 15, scale 5
Purchase percentage - KBB wholesalep_bb_dnumberprecision 15, scale 5
Purchase percentage - original costp_oc_dnumberprecision 15, scale 5
Termination fee percentagep_tf_dnumberprecision 15, scale 5
Pre-payment penalties percentagep_pp_dnumberprecision 15, scale 5
Termination late charge ratep_tlc_dnumberprecision 15, scale 5
Property tax late charge percentagep_pt_dnumberprecision 15, scale 5
Insurance - public liability coverageins_plc_dnumberprecision 15, scale 2
Insurance - property damage coverageins_pdc_dnumberprecision 15, scale 2
Insurance - collision deductible amountins_cda_dnumberprecision 15, scale 2
Insurance - comprehensive amountins_coa_dnumberprecision 15, scale 2
Insurance - bodily injury coverageins_bic_dnumberprecision 15, scale 2
Late charge - minimum dollar amountlch_min_dnumberprecision 15, scale 2
Late charge - maximum dollar amountlch_max_dnumberprecision 15, scale 2
Late charge - fixed dollar amountlch_fix_dnumberprecision 15, scale 2
Early term - termination feetea_tfe_dnumberprecision 15, scale 2
Early term - pre-payment penaltytea_ppp_dnumberprecision 15, scale 2
Maturity - termination feetma_tfe_dnumberprecision 15, scale 2
Maturity - excess mile (cents/mile)tma_emc_dnumberprecision 15, scale 2
Maturity - wear and tear deductibletma_wtd_dnumberprecision 15, scale 2
Relocation - monthly removal feerel_mrf_dnumberprecision 15, scale 2
Late charge grace amountltch_grc_amt_dnumberprecision 15, scale 2
Advanced invoice daysadv_inv_days_lnumberprecision 10
Revision dated_revision_sdateformat YYYYMMDD
Late charge statelate_chrg_st_scharlength 2
Type of contracttyp_cont_svarchar2length 20
Maximum group life insurance (Y/N)max_grp_life_ccharlength 1
Maximum group life insurancemax_grp_life_dnumberprecision 15, scale 2
Written notice of termination dayswrit_ntc_term_lnumberprecision 10
Returned check charge maximumret_chk_chrg_dnumberprecision 15, scale 2
Returned check charge percent maximump_ret_chk_chrg_per_dnumberprecision 15, scale 5
Payment accrual methodpmt_acc_meth_scharlength 4
Purchase option grace dayspur_opt_grc_days_lnumberprecision 10
Purchase option notice required dayspur_opt_ntc_req_days_lnumberprecision 10
Group life premimum allow (Y/N)grp_life_prem_allw_ccharlength 1
Minimum finance chargemin_fin_chrg_dnumberprecision 15, scale 2
Payoff adjustment periodpayoff_adj_per_lnumberprecision 10
Payoff adjustment sourcepayoff_adj_src_svarchar2length 25
Payoff grace period dayspayoff_grc_per_days_lnumberprecision 10
Payoff notice required dayspayoff_ntc_req_days_lnumberprecision 10
Pre-payment fees (Y/N)pre_pmt_fee_ccharlength 1
Additional rent typeadd_rent_typ_scharlength 10
Excess restoration costsexc_rest_cost_dnumberprecision 15, scale 2
Excess msrp chargesexc_msrp_chrg_dnumberprecision 15, scale 2
Excess mileage chargesexc_mile_chrg_msrp_dnumberprecision 15, scale 2
Switch for fees and taxes (Y/N)fee_tax_ccharlength 1
Attorney fees maximum percentp_att_fee_max_dnumberprecision 15, scale 5
Notice of sale daysntc_sale_days_lnumberprecision 10
Effective date on leased_clnt_eff_sdateformat YYYYMMDD
Last date acceptedd_last_acpt_sdateformat YYYYMMDD
Assigned default insurance (Y/N)assgn_def_ccharlength 1
Written notice of lessor cancellation dayswrit_ntc_les_can_days_lnumberprecision 10
Grace days non gfxxgrc_days_non_gfxx_lnumberprecision 10
Written notice of termination flag (Y/N)writ_ntc_term_ccharlength 1
Form numberform_num_svarchar2length 36
Form vendorform_dlr_svarchar2length 36
Product type codeprd_scharlength 4
Interest typeint_typ_scharlength 4
Maximum interest rates typemax_int_rate_typ_scharlength 4
Balloon notes permissible (Y/N)balloon_notes_ccharlength 1
Force placed insurance allowed (Y/N)force_placed_ins_ccharlength 1
Suppress late fee if payment (Y/N)suppress_late_fee_ccharlength 1
Suppress late fee if payment percentagep_suppress_late_fee_dnumberprecision 15, scale 5
Termination dated_termination_sdateformat YYYYMMDD
Termination feeterm_fee_dnumberprecision 15, scale 2
Documentation preparation feedoc_preparation_fee_dnumberprecision 15, scale 2
Purchase option feepurch_option_fee_dnumberprecision 15, scale 2
Extension/Deferment/Due Day change feeext_def_due_fee_dnumberprecision 15, scale 2
Administrative fee - NSFadm_nsf_fee_dnumberprecision 15, scale 2
Administrative fee - NSF percentagep_adm_nsf_fee_dnumberprecision 15, scale 5
Administrative fee - Parking ticketadm_park_tix_fee_dnumberprecision 15, scale 2
Administrative fee - Property taxadm_prop_tax_fee_dnumberprecision 15, scale 2
Languagelanguage_scharlength 2
FC rebate - rebate method [1]fc_rebate1_ccharlength 1
FC rebate - rebate method [2]fc_rebate2_ccharlength 1
FC rebate - rebate method [3]fc_rebate3_ccharlength 1
FC rebate - rebate method [4]fc_rebate4_ccharlength 1
FC rebate - sign [1]fc_sign1_ccharlength 1
FC rebate - sign [2]fc_sign2_ccharlength 1
FC rebate - sign [3]fc_sign3_ccharlength 1
FC rebate - sign [4]fc_sign4_ccharlength 1
FC rebate - term [1]fc_term1_lnumberprecision 10
FC rebate - term [2]fc_term2_lnumberprecision 10
FC rebate - term [3]fc_term3_lnumberprecision 10
FC rebate - term [4]fc_term4_lnumberprecision 10
CL/A&H rebate - rebate method [1]clah_rebate1_ccharlength 1
CL/A&H rebate - rebate method [2]clah_rebate2_ccharlength 1
CL/A&H rebate - rebate method [3]clah_rebate3_ccharlength 1
CL/A&H rebate - rebate method [4]clah_rebate4_ccharlength 1
CL/A&H rebate - sign [1]clah_sign1_ccharlength 1
CL/A&H rebate - sign [2]clah_sign2_ccharlength 1
CL/A&H rebate - sign [3]clah_sign3_ccharlength 1
CL/A&H rebate - sign [4]clah_sign4_ccharlength 1
CL/A&H rebate - term [1]clah_term1_lnumberprecision 10
CL/A&H rebate - term [2]clah_term2_lnumberprecision 10
CL/A&H rebate - term [3]clah_term3_lnumberprecision 10
CL/A&H rebate - term [4]clah_term4_lnumberprecision 10
Calculate rebate for payoff (Y/N)payoff_rebate_ccharlength 1
Warranty rebate - rebate method (Y/N) [1]warr_rebate1_ccharlength 1
Warranty rebate - rebate method (Y/N) [2]warr_rebate2_ccharlength 1
Warranty rebate - rebate method (Y/N) [3]warr_rebate3_ccharlength 1
Warranty rebate - rebate method (Y/N) [4]warr_rebate4_ccharlength 1
Warranty rebate - sign [1]warr_sign1_ccharlength 1
Warranty rebate - sign [2]warr_sign2_ccharlength 1
Warranty rebate - sign [3]warr_sign3_ccharlength 1
Warranty rebate - sign [4]warr_sign4_ccharlength 1
Warranty rebate - term [1]warr_term1_lnumberprecision 10
Warranty rebate - term [2]warr_term2_lnumberprecision 10
Warranty rebate - term [3]warr_term3_lnumberprecision 10
Warranty rebate - term [4]warr_term4_lnumberprecision 10
Calculate late charge on original amount (Y/N)late_chrg_on_orig_amt_ccharlength 1

rca Indexes

Index NamePiece 1
rca_idx0frm_s

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.