| Description | Column | Datatype |
|---|---|---|
| Client | client_id_s | char (9) |
| Credit bureau code | cb_s | char (4) |
| Credit bureau product code | cred_prod_s | char (4) |
| Request date | d_reqst_s | datetime |
| Request time | t_reqst_s | char (6) |
| Sybase timestamp | timestamp | timestamp |
| Client type
L - Lessee C - Co-lessee G - Guarantor U - User-defined client |
client_typ_c | char (1) |
| Application | app_s | char (10) |
| Operator initials | opr_s | char (3) |
| SS/Bus ID | ss_s | char (20) |
| Last name | last_name_s | char (36) |
| First name | first_name_s | char (36) |
| Middle name | mid_name_s | char (36) |
| Generation or title | generation_title_s | char (4) |
| Address type code (S/P/R)
S - Standard P - P.O. Box R - Rural Route |
add_type_c | char (1) |
| Street/house number, PO Box or Rural Route | street_num_s | char (15) |
| Street name | street_name_s | char (36) |
| Street type code | street_type_s | char (2) |
| Street direction (N/S/E/W/NW/SW/SE/NE) | street_dir_s | char (2) |
| Suite | suite_s | char (6) |
| City | cty_s | char (25) |
| State | st_s | char (2) |
| Zip code | zip_s | char (9) |
| Report status (?/?) | rpt_status_c | char (1) |
| Credit score | crd_scr_s | char (4) |
| End time | t_end_s | char (6) |
| Report file name | rpt_name_s | char (36) |
| Transaction ID | trn_id_s | char (10) |
| File number | file_num_s | char (9) |
| Sequence number | seq_num_s | char (3) |
| Globally unique identifier | guid_s | char (32) |
| Index name | Piece 1 | Piece 2 | Piece 3 | Piece 4 | Piece 5 | Piece 6 |
|---|---|---|---|---|---|---|
| rkr_idx0 | client_id_s | cb_s | cred_prod_s | d_reqst_s | t_reqst_s | |
| rkr_idx1 | app_s | client_id_s | cb_s | cred_prod_s | d_reqst_s | t_reqst_s |