LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rho Table: Historical Location

Description Column Datatype
State st_s char (2)
County location code ct_s char (4)
City location code cy_s char (4)
Run date d_run_s date
Run time t_run_s char (6)
Oracle row stamp stamp_l number (10)
Effective date of rate change, state d_st_s date
Effective date of rate change, county d_ct_s date
Effective date of rate change, city d_cy_s date
State rate p_st_rat_d number (15,5)
County rate p_ct_rat_d number (15,5)
City rate p_cy_rat_d number (15,5)
State maximum tax amount st_max_d number (15,2)
County maximum tax amount ct_max_d number (15,2)
City maximum tax amount cy_max_d number (15,2)
County transit rate p_ct_tran_rat_d number (15,5)
City transit rate p_cy_tran_rat_d number (15,5)

rho Indexes:

Index name Piece 1 Piece 2 Piece 3 Piece 4 Piece 5
rho_idx0 st_s ct_s cy_s d_run_s t_run_s


HomeTableIndexes