rst Table: State
Sybase DBMS

Specifies the columns and rows with Sybase data type information for the rst State table.

rst Columns

Description	Column Name	Data Type ?	Characteristics ?
State	st_s	char	length 2
Record modification stamp	timestamp	timestamp
State name	st_nam_s	char	length 20
State maximum interest rate	p_max_st_d	double	scale 5
Revision date	d_revision_s	datetime	format YYYYMMDD
Vehicle - new maximum interest rate	p_veh_new_d	double	scale 5
Vehicle - other maximum interest rate	p_veh_oth_new_d	double	scale 5
Vehicle - 1 year used maximum interest rate	p_veh_1yr_d	double	scale 5
Vehicle - 2 year used maximum interest rate	p_veh_2yr_d	double	scale 5
Vehicle - 3 year used maximum interest rate	p_veh_3yr_d	double	scale 5
Vehicle - 4 year used maximum interest rate	p_veh_4yr_d	double	scale 5
Vehicle - 5 year used maximum interest rate	p_veh_5yr_d	double	scale 5
Vehicle - 6 year used maximum interest rate	p_veh_6yr_d	double	scale 5
Vehicle - over 6 years used maximum interest rate	p_veh_ov6_d	double	scale 5
Term - term [1]	trm_trm1_l	integer
Term - term [2]	trm_trm2_l	integer
Term - term [3]	trm_trm3_l	integer
Term - term [4]	trm_trm4_l	integer
Term - term [5]	trm_trm5_l	integer
Term - term [6]	trm_trm6_l	integer
Term - 1 year used maximum interest rate [1]	p_trm_1yr1_d	double	scale 5
Term - 1 year used maximum interest rate [2]	p_trm_1yr2_d	double	scale 5
Term - 1 year used maximum interest rate [3]	p_trm_1yr3_d	double	scale 5
Term - 1 year used maximum interest rate [4]	p_trm_1yr4_d	double	scale 5
Term - 1 year used maximum interest rate [5]	p_trm_1yr5_d	double	scale 5
Term - 1 year used maximum interest rate [6]	p_trm_1yr6_d	double	scale 5
Term - 2 year used maximum interest rate [1]	p_trm_2yr1_d	double	scale 5
Term - 2 year used maximum interest rate [2]	p_trm_2yr2_d	double	scale 5
Term - 2 year used maximum interest rate [3]	p_trm_2yr3_d	double	scale 5
Term - 2 year used maximum interest rate [4]	p_trm_2yr4_d	double	scale 5
Term - 2 year used maximum interest rate [5]	p_trm_2yr5_d	double	scale 5
Term - 2 year used maximum interest rate [6]	p_trm_2yr6_d	double	scale 5
Term - 3 year used maximum interest rate [1]	p_trm_3yr1_d	double	scale 5
Term - 3 year used maximum interest rate [2]	p_trm_3yr2_d	double	scale 5
Term - 3 year used maximum interest rate [3]	p_trm_3yr3_d	double	scale 5
Term - 3 year used maximum interest rate [4]	p_trm_3yr4_d	double	scale 5
Term - 3 year used maximum interest rate [5]	p_trm_3yr5_d	double	scale 5
Term - 3 year used maximum interest rate [6]	p_trm_3yr6_d	double	scale 5
Term - 4 year used maximum interest rate [1]	p_trm_4yr1_d	double	scale 5
Term - 4 year used maximum interest rate [2]	p_trm_4yr2_d	double	scale 5
Term - 4 year used maximum interest rate [3]	p_trm_4yr3_d	double	scale 5
Term - 4 year used maximum interest rate [4]	p_trm_4yr4_d	double	scale 5
Term - 4 year used maximum interest rate [5]	p_trm_4yr5_d	double	scale 5
Term - 4 year used maximum interest rate [6]	p_trm_4yr6_d	double	scale 5
Term - 5 year used maximum interest rate [1]	p_trm_5yr1_d	double	scale 5
Term - 5 year used maximum interest rate [2]	p_trm_5yr2_d	double	scale 5
Term - 5 year used maximum interest rate [3]	p_trm_5yr3_d	double	scale 5
Term - 5 year used maximum interest rate [4]	p_trm_5yr4_d	double	scale 5
Term - 5 year used maximum interest rate [5]	p_trm_5yr5_d	double	scale 5
Term - 5 year used maximum interest rate [6]	p_trm_5yr6_d	double	scale 5
Term - 6 year used maximum interest rate [1]	p_trm_6yr1_d	double	scale 5
Term - 6 year used maximum interest rate [2]	p_trm_6yr2_d	double	scale 5
Term - 6 year used maximum interest rate [3]	p_trm_6yr3_d	double	scale 5
Term - 6 year used maximum interest rate [4]	p_trm_6yr4_d	double	scale 5
Term - 6 year used maximum interest rate [5]	p_trm_6yr5_d	double	scale 5
Term - 6 year used maximum interest rate [6]	p_trm_6yr6_d	double	scale 5
Term - over 6 years used maximum interest rate [1]	p_trm_ov61_d	double	scale 5
Term - over 6 years used maximum interest rate [2]	p_trm_ov62_d	double	scale 5
Term - over 6 years used maximum interest rate [3]	p_trm_ov63_d	double	scale 5
Term - over 6 years used maximum interest rate [4]	p_trm_ov64_d	double	scale 5
Term - over 6 years used maximum interest rate [5]	p_trm_ov65_d	double	scale 5
Term - over 6 years used maximum interest rate [6]	p_trm_ov66_d	double	scale 5
Term - new maximum interest rate [1]	p_trm_new1_d	double	scale 5
Term - new maximum interest rate [2]	p_trm_new2_d	double	scale 5
Term - new maximum interest rate [3]	p_trm_new3_d	double	scale 5
Term - new maximum interest rate [4]	p_trm_new4_d	double	scale 5
Term - new maximum interest rate [5]	p_trm_new5_d	double	scale 5
Term - new maximum interest rate [6]	p_trm_new6_d	double	scale 5
Term - other new maximum interest rate [1]	p_trm_oth_new1_d	double	scale 5
Term - other new maximum interest rate [2]	p_trm_oth_new2_d	double	scale 5
Term - other new maximum interest rate [3]	p_trm_oth_new3_d	double	scale 5
Term - other new maximum interest rate [4]	p_trm_oth_new4_d	double	scale 5
Term - other new maximum interest rate [5]	p_trm_oth_new5_d	double	scale 5
Term - other new maximum interest rate [6]	p_trm_oth_new6_d	double	scale 5
Balance - amount [1]	bal_amt1_d	double	scale 2
Balance - amount [2]	bal_amt2_d	double	scale 2
Balance - amount [3]	bal_amt3_d	double	scale 2
Balance - amount [4]	bal_amt4_d	double	scale 2
Balance - maximum APR per amount [1]	p_bal_apr1_d	double	scale 5
Balance - maximum APR per amount [2]	p_bal_apr2_d	double	scale 5
Balance - maximum APR per amount [3]	p_bal_apr3_d	double	scale 5
Balance - maximum APR per amount [4]	p_bal_apr4_d	double	scale 5
Number of days to expiration after letter sent	days_to_letter_exp_l	integer
Able to redeem (Y/N)	redeem_c	char	length 1
Rate code	tax_rate_s	char	length 4
Vehicle tax type	veh_tax_type_s	char	length 4
Equipment tax type	eq_tax_type_s	char	length 4
Ignore unit overrides (Y/N)	ign_over_c	char	length 1
Allow trade-in tax credit (Y/N)	trd_tx_crd_c	char	length 1
State tax identification number	st_tax_id_s	char	length 36
Up front letter code	upf_ltr_code_s	char	length 8
Monthly letter code	mth_ltr_code_s	char	length 8
Tax rate change (Y/N)	rate_chg_c	char	length 1
Country code	country_s	char	length 4
State geocode 0 - if state is a non-vertex state # - if state is a vertex state 70 - if state is a Canadian province	geo_st_l	integer
County geocode 0 - if geo_st_l is not 70 # - if geo_st_l is 70	geo_ct_l	integer
Separate vehicle tax disbursal report (Y/N)	veh_tax_rpt_c	char	length 1
Rate-set to utilize in vehicle accruals (E/U/S/N) E - Equipment rental rates U - Vehicle use rates S - Vehicle sales rates N - None	veh_accrual_tax_rates_c	char	length 1
Rate-set to utilize in vehicle payoffs (E/U/S/N) E - Equipment rental rates U - Vehicle use rates S - Vehicle sales rates N - None	veh_payoff_tax_rates_c	char	length 1

rst Indexes

Index Name	Piece 1
rst_idx0	st_s

Data Type Definitions and Characteristics

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

char

Sybase fixed length character string. Typically used to store short and medium-length string data such as keys, names, addresses, descriptions, four-character codes, and single-character switch values.
Characteristics:

• length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.

datetime

Sybase date and time, containing century, year, month, day, hour, minute, second, and second fraction (to 1/300 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.

double

Sybase numeric data type. Typically used to store percentage, rate, and dollar amount information.
Characteristics:

• scale - The fractional granularity, meaning the number of places available to the right of the decimal point.

integer

Sybase numeric data type. Typically used to store counter and whole number information--term length, payment due day, number of units on lease, number of times delinquent, etc.

timestamp

Sybase data type based on the varbinary data type storing raw binary data. Whenever a table includes a timestamp column, Sybase updates the information in timestamp each time a user inserts or updates a record, preventing multiple-user cross-update data corruption.

text

Sybase expandable character data type. Typically used to store long-length string data such as notebook entries.

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.