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 |