| Description | Column | Datatype |
|---|---|---|
| Prime rate bank number | prim_num_s | char (4) |
| Date (YYMM)
Notes: 1. The date segment of the key does not use the actual year. 50 years are added to the year for 21st century sorting purposes. That is, February 1990 is represented as "4002". 2. There are 2 special records for each prime rate, one with ".000" in the date segment, which represents the day before the first date on file. The other has ".001" in the date segment, which represents the day after the last update. That is, prime rate "1234" would have 2 special records with keys "1234.000" and "1234.001" |
dpr_key_seg_s | char (4) |
| Sybase timestamp | timestamp | timestamp |
| Date of last update | d_lup_s | datetime |
| Average prime rate | p_avg_d | double precision |
| Daily prime rates array [1] | p_prim1_d | double precision |
| Daily prime rates array [2] | p_prim2_d | double precision |
| Daily prime rates array [3] | p_prim3_d | double precision |
| Daily prime rates array [4] | p_prim4_d | double precision |
| Daily prime rates array [5] | p_prim5_d | double precision |
| Daily prime rates array [6] | p_prim6_d | double precision |
| Daily prime rates array [7] | p_prim7_d | double precision |
| Daily prime rates array [8] | p_prim8_d | double precision |
| Daily prime rates array [9] | p_prim9_d | double precision |
| Daily prime rates array [10] | p_prim10_d | double precision |
| Daily prime rates array [11] | p_prim11_d | double precision |
| Daily prime rates array [12] | p_prim12_d | double precision |
| Daily prime rates array [13] | p_prim13_d | double precision |
| Daily prime rates array [14] | p_prim14_d | double precision |
| Daily prime rates array [15] | p_prim15_d | double precision |
| Daily prime rates array [16] | p_prim16_d | double precision |
| Daily prime rates array [17] | p_prim17_d | double precision |
| Daily prime rates array [18] | p_prim18_d | double precision |
| Daily prime rates array [19] | p_prim19_d | double precision |
| Daily prime rates array [20] | p_prim20_d | double precision |
| Daily prime rates array [21] | p_prim21_d | double precision |
| Daily prime rates array [22] | p_prim22_d | double precision |
| Daily prime rates array [23] | p_prim23_d | double precision |
| Daily prime rates array [24] | p_prim24_d | double precision |
| Daily prime rates array [25] | p_prim25_d | double precision |
| Daily prime rates array [26] | p_prim26_d | double precision |
| Daily prime rates array [27] | p_prim27_d | double precision |
| Daily prime rates array [28] | p_prim28_d | double precision |
| Daily prime rates array [29] | p_prim29_d | double precision |
| Daily prime rates array [30] | p_prim30_d | double precision |
| Daily prime rates array [31] | p_prim31_d | double precision |
| Index name | Piece 1 | Piece 2 |
|---|---|---|
| rpr_idx0 | prim_num_s | dpr_key_seg_s |