| Name | Segment 1 | Segment 2 |
|---|---|---|
| rcm_idx0 | lse_s | client_id_s |
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null |
| lse_s | Lease |
||
| client_id_s | Client |
||
Record modification stamp |
|||
| d_run_s | Run date |
||
| t_run_s | Run time |
||
| client_typ_c | Client type (L/C/G) L - Lessee C - Co-lessee G - Guarantor |
||
| mod_typ_c | Modification type (A/D/1/2/3/4) A - Add: report on both extracts D - Delete: report on both extracts 1 - Add: report on metro2 extract 2 - Add: report on business extract 3 - Delete: report on metro2 extract 4 - Delete: report on business extract |
||
| delete_reason_c | Reason client was removed from lease (T/X/Z) T - Termination of association with lease X - Deceased Z - Association with lease made in error |
||