rhqa Table: Historical Asset for Lease Extension/Reversal 2
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rhqa Historical Asset for Lease Extension/Reversal 2 table.

Parent-Child: This table has a parent table--click here for a listing.

rhqa Columns

Description	Column Name	Data Type ?	Characteristics ?
Lease	lse_s	char	length 10
Extension	ext_num_s	char	length 2
Asset	unit_s	char	length 10
Record number	unique_l	number	precision 10
Record modification stamp	stamp_l	number	precision 10
Additional method of depreciation 1	ger1_s	char	length 4
Additional method of depreciation 2	ger2_s	char	length 4
Depreciation M-T-D additional 1	ger1_mtd_d	number	precision 15, scale 2
Depreciation Y-T-D additional 1	ger1_ytd_d	number	precision 15, scale 2
Depreciation L-T-D additional 1	ger1_ltd_d	number	precision 15, scale 2
Depreciation M-T-D additional 2	ger2_mtd_d	number	precision 15, scale 2
Depreciation Y-T-D additional 2	ger2_ytd_d	number	precision 15, scale 2
Depreciation L-T-D additional 2	ger2_ltd_d	number	precision 15, scale 2
Equipment street address 2	eq_add2_s	varchar2	length 36
Collateral substitution dealer	sub_dlr_s	char	length 9
Collateral substitution date	d_sub_s	date	format YYYYMMDD
Collateral substitution mileage	sub_miles_l	number	precision 10
Extended warranty months	ext_war_mnths_l	number	precision 10
Extended warranty miles	ext_war_miles_l	number	precision 10
Warranty mileage allowance	war_miles_l	number	precision 10
Total days in pending repossesion	days_p_repo_l	number	precision 10
Vehicle color	color_s	char	length 10
Manufacturers key code	cd_key_s	char	length 6
State of license plate issue	lic_st_s	char	length 2
Lien holder claim	lien_hldr_claim_c	char	length 1
Repossesion investments	repo_invst_d	number	precision 15, scale 2
Repair charges	repair_d	number	precision 15, scale 2
App recon charges	beauty_d	number	precision 15, scale 2
Incentive charges	incentive_d	number	precision 15, scale 2
Transportation cost	transprt_d	number	precision 15, scale 2
Sales fee charges	sale_fee_d	number	precision 15, scale 2
DMV/title charges	dmv_d	number	precision 15, scale 2
Repairs/labor charges	rep_labor_d	number	precision 15, scale 2
Storage charges recovery	storage_rec_d	number	precision 15, scale 2
Storage charges remarketing	storage_rem_d	number	precision 15, scale 2
Other credits	other_cr_d	number	precision 15, scale 2
Gross proceeds	gr_proc_d	number	precision 15, scale 2
Pre gap payments due	pre_gap_d	number	precision 15, scale 2
Permanent state status (Y/N)	perm_st_c	char	length 1
Part number	part_num_s	varchar2	length 25
Number of sub-assets on an asset	sub_count_l	number	precision 10
Insurance cancellation date	d_ins_can_s	date	format YYYYMMDD
Insurance expiration date	d_ins_exp_s	date	format YYYYMMDD
Insurance bank code	ins_bank_s	char	length 3
Insurance cancellation reason	ins_can_s	char	length 4
Insurance asset (Y/N)	ins_unit_c	char	length 1
Diminishing value rate	p_dim_val_d	number	precision 15, scale 5
Insurance percentage	p_ins_d	number	precision 15, scale 5
Unearned insurance income	ue_ins_inc_d	number	precision 15, scale 2
Life-to-date insurance payable	ltd_ins_pay_d	number	precision 15, scale 2
Life-to-date insurance commission	ltd_ins_com_d	number	precision 15, scale 2
Life-to-Date insurance income	ltd_ins_inc_d	number	precision 15, scale 2
Refund insurance payable	ins_pay_refund_d	number	precision 15, scale 2
Refund insurance commission	ins_com_refund_d	number	precision 15, scale 2
Refund insurance income	ins_inc_refund_d	number	precision 15, scale 2
Payment schedule adjustment method A=Amount T=Term	pmt_sch_meth_c	char	length 1
Previous life-to-date depreciation	prev_ltd_bkd_d	number	precision 15, scale 2
Previous book depreciation basis	prev_taxbasis_d	number	precision 15, scale 2
Previous book salvage value	prev_sal_bkd_d	number	precision 15, scale 2
Depreciation change counter	depr_chg_l	number	precision 10
Previous book depreciation start date	d_prev_bkd_s	date	format YYYYMMDD
Previous book depreciation method	prev_bkd_s	char	length 4
Changed accounting method from FIN to OPER (Y/N)	fin_to_oper_c	char	length 1
Deferred book depreciation amount	def_bkd_d	number	precision 15, scale 2
Deferred book depreciation taken N - Not taken D - Taken by depreciation P - Taken by payoff S = Taken by sale of asset	def_bkd_taken_c	char	length 1
Leveraged (Y/N)	lvr_c	char	length 1
AMT depreciation life	amt_life_l	number	precision 10
Federal depreciation life	fed_life_l	number	precision 10
Deferred tax YTD amount	dfrd_tax_ytd_d	number	precision 15, scale 2
FSC exclusion Y-T-D amount	fsc_ytd_d	number	precision 15, scale 2
Interest expenses Y-T-D amount	int_expn_ytd_d	number	precision 15, scale 2
Off lease billing invoice/rent amount	olb_invo_d	number	precision 15, scale 2
Off lease billing sales tax amount	olb_stax_d	number	precision 15, scale 2
Taxable income Y-T-D amount	tax_inc_ytd_d	number	precision 15, scale 2
Previous Y-T-D federal AMT depreciation	prev_ytd_fed_amt_d	number	precision 15, scale 2
Previous Y-T-D federal depreciation	prev_ytd_fed_d	number	precision 15, scale 2
Previous Y-T-D state depreciation	prev_ytd_st_d	number	precision 15, scale 2
Optional residual	opt_res_d	number	precision 15, scale 2
Property tax exempt code	ptax_exempt_s	char	length 4
Property tax last used date	d_ptax_last_used_s	date	format YYYYMMDD
Sales/use tax exempt code	stax_exempt_s	char	length 4
Utilize vehicle tax rates (Y/N)	utilize_veh_tax_rates_c	char	length 1
Payoff quote preparation date	d_payoff_quote_s	date	format YYYYMMDD
Custom payoff quote amount [1]	custom_payoff_quote1_d	number	precision 15, scale 2
Custom payoff quote amount [2]	custom_payoff_quote2_d	number	precision 15, scale 2
Custom payoff quote amount [3]	custom_payoff_quote3_d	number	precision 15, scale 2
Custom payoff quote amount [4]	custom_payoff_quote4_d	number	precision 15, scale 2
Custom payoff quote amount [5]	custom_payoff_quote5_d	number	precision 15, scale 2

rhqa Indexes

Index Name	Piece 1	Piece 2	Piece 3	Piece 4
rhqa_idx0	lse_s	ext_num_s	unit_s	unique_l

Parent Table Listing

Table Name	Description
rhq	Historical Asset for Lease Extension/Reversal

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.

LeasePak 6.0a Documentation Suite

© 2008 by McCue Systems Incorporated. All rights reserved.

The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.