| Description | Column | Datatype |
|---|---|---|
| Lease or application | app_lse_s | char (10) |
| Client type
C - Co-lessee G - Guarantor U - User-defined client |
client_typ_c | char (1) |
| Client | client_id_s | char (9) |
| Sybase timestamp | timestamp | timestamp |
| Relationship to application/lease (guarantor only) | relation_s | char (25) |
| Primary guarantor (guarantor only) | primary_grn_c | char (1) |
| Index name | Piece 1 | Piece 2 | Piece 3 |
|---|---|---|---|
| rgc_idx0 | app_lse_s | client_typ_c | client_id_s |
| rgc_idx1 | client_id_s | app_lse_s | client_typ_c |