| Columns |
| Name |
Description | Datatype ¿? |
Allow Null |
| ext_num_s |
Extension | CHAR(2) |
no |
| cycle_num_s |
Accrual/billing cycle change number in a given lease period
The first lease period is from book lease to maturity.
Each subsequent lease extension (if any) represents a
new and separate lease period. |
CHAR(2) |
no |
| lse_s |
Lease |
CHAR(10) |
no |
| unique_l |
Record number (value is always 1) | NUMBER(10) |
no |
| stamp_l |
Record modification stamp |
NUMBER(10) |
no |
| lse_fee1_man_ltd_d |
Lease fee manual assessment L-T-D [1] | NUMBER(15,2) |
yes |
| lse_fee2_man_ltd_d |
Lease fee manual assessment L-T-D [2] |
NUMBER(15,2) |
yes |
| lse_fee3_man_ltd_d |
Lease fee manual assessment L-T-D [3] |
NUMBER(15,2) |
yes |
| lse_fee4_man_ltd_d |
Lease fee manual assessment L-T-D [4] |
NUMBER(15,2) |
yes |
| lse_fee5_man_ltd_d |
Lease fee manual assessment L-T-D [5] |
NUMBER(15,2) |
yes |
| lse_fee6_man_ltd_d |
Lease fee manual assessment L-T-D [6] |
NUMBER(15,2) |
yes |
| lse_fee7_man_ltd_d |
Lease fee manual assessment L-T-D [7] |
NUMBER(15,2) |
yes |
| lse_fee8_man_ltd_d |
Lease fee manual assessment L-T-D [8] |
NUMBER(15,2) |
yes |
| lse_fee9_man_ltd_d |
Lease fee manual assessment L-T-D [9] |
NUMBER(15,2) |
yes |
| lse_fee10_man_ltd_d |
Lease fee manual assessment L-T-D [10] |
NUMBER(15,2) |
yes |
| lse_fee11_man_ltd_d |
Lease fee manual assessment L-T-D [11] |
NUMBER(15,2) |
yes |
| lse_fee12_man_ltd_d |
Lease fee manual assessment L-T-D [12] |
NUMBER(15,2) |
yes |
| lse_fee13_man_ltd_d |
Lease fee manual assessment L-T-D [13] |
NUMBER(15,2) |
yes |
| lse_fee14_man_ltd_d |
Lease fee manual assessment L-T-D [14] |
NUMBER(15,2) |
yes |
| lse_fee15_man_ltd_d |
Lease fee manual assessment L-T-D [15] |
NUMBER(15,2) |
yes |
| lse_fee16_man_ltd_d |
Lease fee manual assessment L-T-D [16] |
NUMBER(15,2) |
yes |
| lse_fee17_man_ltd_d |
Lease fee manual assessment L-T-D [17] |
NUMBER(15,2) |
yes |
| lse_fee18_man_ltd_d |
Lease fee manual assessment L-T-D [18] |
NUMBER(15,2) |
yes |
| lse_fee19_man_ltd_d |
Lease fee manual assessment L-T-D [19] |
NUMBER(15,2) |
yes |
| lse_fee20_man_ltd_d |
Lease fee manual assessment L-T-D [20] |
NUMBER(15,2) |
yes |
| unit_fee1_man_ltd_d |
Asset fee manual assessment L-T-D [1] |
NUMBER(15,2) |
yes |
| unit_fee2_man_ltd_d |
Asset fee manual assessment L-T-D [2] |
NUMBER(15,2) |
yes |
| unit_fee3_man_ltd_d |
Asset fee manual assessment L-T-D [3] |
NUMBER(15,2) |
yes |
| unit_fee4_man_ltd_d |
Asset fee manual assessment L-T-D [4] |
NUMBER(15,2) |
yes |
| unit_fee5_man_ltd_d |
Asset fee manual assessment L-T-D [5] |
NUMBER(15,2) |
yes |
| unit_fee6_man_ltd_d |
Asset fee manual assessment L-T-D [6] |
NUMBER(15,2) |
yes |
| unit_fee7_man_ltd_d |
Asset fee manual assessment L-T-D [7] |
NUMBER(15,2) |
yes |
| unit_fee8_man_ltd_d |
Asset fee manual assessment L-T-D [8] |
NUMBER(15,2) |
yes |
| unit_fee9_man_ltd_d |
Asset fee manual assessment L-T-D [9] |
NUMBER(15,2) |
yes |
| unit_fee10_man_ltd_d |
Asset fee manual assessment L-T-D [10] |
NUMBER(15,2) |
yes |
| rcr_man_ltd16_d |
Recurring charge manual assessment L-T-D [16] |
NUMBER(15,2) |
yes |
| rcr_man_ltd17_d |
Recurring charge manual assessment L-T-D [17] |
NUMBER(15,2) |
yes |
| rcr_man_ltd18_d |
Recurring charge manual assessment L-T-D [18] |
NUMBER(15,2) |
yes |
| rcr_man_ltd19_d |
Recurring charge manual assessment L-T-D [19] |
NUMBER(15,2) |
yes |
| rcr_man_ltd20_d |
Recurring charge manual assessment L-T-D [20] |
NUMBER(15,2) |
yes |
| rcr_man_ltd21_d |
Recurring charge manual assessment L-T-D [21] |
NUMBER(15,2) |
yes |
| rcr_man_ltd22_d |
Recurring charge manual assessment L-T-D [22] |
NUMBER(15,2) |
yes |
| rcr_man_ltd23_d |
Recurring charge manual assessment L-T-D [23] |
NUMBER(15,2) |
yes |
| rcr_man_ltd24_d |
Recurring charge manual assessment L-T-D [24] |
NUMBER(15,2) |
yes |
| rcr_man_ltd25_d |
Recurring charge manual assessment L-T-D [25] |
NUMBER(15,2) |
yes |
| rcr_man_ltd26_d |
Recurring charge manual assessment L-T-D [26] |
NUMBER(15,2) |
yes |
| rcr_man_ltd27_d |
Recurring charge manual assessment L-T-D [27] |
NUMBER(15,2) |
yes |
| rcr_man_ltd28_d |
Recurring charge manual assessment L-T-D [28] |
NUMBER(15,2) |
yes |
| rcr_man_ltd29_d |
Recurring charge manual assessment L-T-D [29] |
NUMBER(15,2) |
yes |
| rcr_man_ltd30_d |
Recurring charge manual assessment L-T-D [30] |
NUMBER(15,2) |
yes |
| rcr_man_ltd31_d |
Recurring charge manual assessment L-T-D [31] |
NUMBER(15,2) |
yes |
| rcr_man_ltd32_d |
Recurring charge manual assessment L-T-D [32] |
NUMBER(15,2) |
yes |
| rcr_man_ltd33_d |
Recurring charge manual assessment L-T-D [33] |
NUMBER(15,2) |
yes |
| rcr_man_ltd34_d |
Recurring charge manual assessment L-T-D [34] |
NUMBER(15,2) |
yes |
| rcr_man_ltd35_d |
Recurring charge manual assessment L-T-D [35] |
NUMBER(15,2) |
yes |
| lse_fee1_waive_ltd_d |
Lease fee waived L-T-D [1] |
NUMBER(15,2) |
yes |
| lse_fee2_waive_ltd_d |
Lease fee waived L-T-D [2] |
NUMBER(15,2) |
yes |
| lse_fee3_waive_ltd_d |
Lease fee waived L-T-D [3] |
NUMBER(15,2) |
yes |
| lse_fee4_waive_ltd_d |
Lease fee waived L-T-D [4] |
NUMBER(15,2) |
yes |
| lse_fee5_waive_ltd_d |
Lease fee waived L-T-D [5] |
NUMBER(15,2) |
yes |
| lse_fee6_waive_ltd_d |
Lease fee waived L-T-D [6] |
NUMBER(15,2) |
yes |
| lse_fee7_waive_ltd_d |
Lease fee waived L-T-D [7] |
NUMBER(15,2) |
yes |
| lse_fee8_waive_ltd_d |
Lease fee waived L-T-D [8] |
NUMBER(15,2) |
yes |
| lse_fee9_waive_ltd_d |
Lease fee waived L-T-D [9] |
NUMBER(15,2) |
yes |
| lse_fee10_waive_ltd_d |
Lease fee waived L-T-D [10] |
NUMBER(15,2) |
yes |
| lse_fee11_waive_ltd_d |
Lease fee waived L-T-D [11] |
NUMBER(15,2) |
yes |
| lse_fee12_waive_ltd_d |
Lease fee waived L-T-D [12] |
NUMBER(15,2) |
yes |
| lse_fee13_waive_ltd_d |
Lease fee waived L-T-D [13] |
NUMBER(15,2) |
yes |
| lse_fee14_waive_ltd_d |
Lease fee waived L-T-D [14] |
NUMBER(15,2) |
yes |
| lse_fee15_waive_ltd_d |
Lease fee waived L-T-D [15] |
NUMBER(15,2) |
yes |
| lse_fee16_waive_ltd_d |
Lease fee waived L-T-D [16] |
NUMBER(15,2) |
yes |
| lse_fee17_waive_ltd_d |
Lease fee waived L-T-D [17] |
NUMBER(15,2) |
yes |
| lse_fee18_waive_ltd_d |
Lease fee waived L-T-D [18] |
NUMBER(15,2) |
yes |
| lse_fee19_waive_ltd_d |
Lease fee waived L-T-D [19] |
NUMBER(15,2) |
yes |
| lse_fee20_waive_ltd_d |
Lease fee waived L-T-D [20] |
NUMBER(15,2) |
yes |
| unit_fee1_waive_ltd_d |
Asset fee waived L-T-D [1] |
NUMBER(15,2) |
yes |
| unit_fee2_waive_ltd_d |
Asset fee waived L-T-D [2] |
NUMBER(15,2) |
yes |
| unit_fee3_waive_ltd_d |
Asset fee waived L-T-D [3] |
NUMBER(15,2) |
yes |
| unit_fee4_waive_ltd_d |
Asset fee waived L-T-D [4] |
NUMBER(15,2) |
yes |
| unit_fee5_waive_ltd_d |
Asset fee waived L-T-D [5] |
NUMBER(15,2) |
yes |
| unit_fee6_waive_ltd_d |
Asset fee waived L-T-D [6] |
NUMBER(15,2) |
yes |
| unit_fee7_waive_ltd_d |
Asset fee waived L-T-D [7] |
NUMBER(15,2) |
yes |
| unit_fee8_waive_ltd_d |
Asset fee waived L-T-D [8] |
NUMBER(15,2) |
yes |
| unit_fee9_waive_ltd_d |
Asset fee waived L-T-D [9] |
NUMBER(15,2) |
yes |
| unit_fee10_waive_ltd_d |
Asset fee waived L-T-D [10] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd16_d |
Recurring charge waived L-T-D [16] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd17_d |
Recurring charge waived L-T-D [17] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd18_d |
Recurring charge waived L-T-D [18] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd19_d |
Recurring charge waived L-T-D [19] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd20_d |
Recurring charge waived L-T-D [20] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd21_d |
Recurring charge waived L-T-D [21] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd22_d |
Recurring charge waived L-T-D [22] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd23_d |
Recurring charge waived L-T-D [23] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd24_d |
Recurring charge waived L-T-D [24] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd25_d |
Recurring charge waived L-T-D [25] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd26_d |
Recurring charge waived L-T-D [26] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd27_d |
Recurring charge waived L-T-D [27] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd28_d |
Recurring charge waived L-T-D [28] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd29_d |
Recurring charge waived L-T-D [29] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd30_d |
Recurring charge waived L-T-D [30] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd31_d |
Recurring charge waived L-T-D [31] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd32_d |
Recurring charge waived L-T-D [32] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd33_d |
Recurring charge waived L-T-D [33] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd34_d |
Recurring charge waived L-T-D [34] |
NUMBER(15,2) |
yes |
| rcr_waive_ltd35_d |
Recurring charge waived L-T-D [35] |
NUMBER(15,2) |
yes |
| idc8_d |
Guaranteed reserves IDC8 |
NUMBER(15,2) |
yes |
| idc8_ap_d |
Payable amount IDC8 |
NUMBER(15,2) |
yes |
| idc8_cur_d |
Current IDC8 |
NUMBER(15,2) |
yes |
| idc8_red_d |
Reduction IDC8 |
NUMBER(15,2) |
yes |
| idc8_susp_d |
Suspended IDC8 |
NUMBER(15,2) |
yes |
| idc8_ue_d |
Unearned IDC8 |
NUMBER(15,2) |
yes |
| idc8_ytd_d |
Year to date IDC8 |
NUMBER(15,2) |
yes |
| alt_idc8_cur_d |
Alternate current IDC8 |
NUMBER(15,2) |
yes |
| alt_idc8_ue_d |
Alternate unearned IDC8 |
NUMBER(15,2) |
yes |
| alt_idc8_ytd_d |
Alternate year to date IDC8 |
NUMBER(15,2) |
yes |
| idc9_d |
Guaranteed reserves IDC9 |
NUMBER(15,2) |
yes |
| idc9_ap_d |
Payable amount IDC9 |
NUMBER(15,2) |
yes |
| idc9_cur_d |
Current IDC9 |
NUMBER(15,2) |
yes |
| idc9_red_d |
Reduction IDC9 |
NUMBER(15,2) |
yes |
| idc9_susp_d |
Suspended IDC9 |
NUMBER(15,2) |
yes |
| idc9_ue_d |
Unearned IDC9 |
NUMBER(15,2) |
yes |
| idc9_ytd_d |
Year to date IDC9 |
NUMBER(15,2) |
yes |
| alt_idc9_cur_d |
Alternate current IDC9 |
NUMBER(15,2) |
yes |
| alt_idc9_ue_d |
Alternate unearned IDC9 |
NUMBER(15,2) |
yes |
| alt_idc9_ytd_d |
Alternate year to date IDC9 |
NUMBER(15,2) |
yes |
| idca_d |
Guaranteed reserves IDCA |
NUMBER(15,2) |
yes |
| idca_ap_d |
Payable amount IDCA |
NUMBER(15,2) |
yes |
| idca_cur_d |
Current IDCA |
NUMBER(15,2) |
yes |
| idca_red_d |
Reduction IDCA |
NUMBER(15,2) |
yes |
| idca_susp_d |
Suspended IDCA |
NUMBER(15,2) |
yes |
| idca_ue_d |
Unearned IDCA |
NUMBER(15,2) |
yes |
| idca_ytd_d |
Year to date IDCA |
NUMBER(15,2) |
yes |
| alt_idca_cur_d |
Alternate current IDCA |
NUMBER(15,2) |
yes |
| alt_idca_ue_d |
Alternate unearned IDCA |
NUMBER(15,2) |
yes |
| alt_idca_ytd_d |
Alternate year to date IDCA |
NUMBER(15,2) |
yes |
| idcb_d |
Guaranteed reserves IDCB |
NUMBER(15,2) |
yes |
| idcb_ap_d |
Payable amount IDCB |
NUMBER(15,2) |
yes |
| idcb_cur_d |
Current IDCB |
NUMBER(15,2) |
yes |
| idcb_red_d |
Reduction IDCB |
NUMBER(15,2) |
yes |
| idcb_susp_d |
Suspended IDCB |
NUMBER(15,2) |
yes |
| idcb_ue_d |
Unearned IDCB |
NUMBER(15,2) |
yes |
| idcb_ytd_d |
Year to date IDCB |
NUMBER(15,2) |
yes |
| alt_idcb_cur_d |
Alternate current IDCB |
NUMBER(15,2) |
yes |
| alt_idcb_ue_d |
Alternate unearned IDCB |
NUMBER(15,2) |
yes |
| alt_idcb_ytd_d |
Alternate year to date IDCB |
NUMBER(15,2) |
yes |
| idcc_d |
Guaranteed reserves IDCC |
NUMBER(15,2) |
yes |
| idcc_ap_d |
Payable amount IDCC |
NUMBER(15,2) |
yes |
| idcc_cur_d |
Current IDCC |
NUMBER(15,2) |
yes |
| idcc_red_d |
Reduction IDCC |
NUMBER(15,2) |
yes |
| idcc_susp_d |
Suspended IDCC |
NUMBER(15,2) |
yes |
| idcc_ue_d |
Unearned IDCC |
NUMBER(15,2) |
yes |
| idcc_ytd_d |
Year to date IDCC |
NUMBER(15,2) |
yes |
| alt_idcc_cur_d |
Alternate current IDCC |
NUMBER(15,2) |
yes |
| alt_idcc_ue_d |
Alternate unearned IDCC |
NUMBER(15,2) |
yes |
| alt_idcc_ytd_d |
Alternate year to date IDCC |
NUMBER(15,2) |
yes |
| idcd_d |
Guaranteed reserves IDCD |
NUMBER(15,2) |
yes |
| idcd_ap_d |
Payable amount IDCD |
NUMBER(15,2) |
yes |
| idcd_cur_d |
Current IDCD |
NUMBER(15,2) |
yes |
| idcd_red_d |
Reduction IDCD |
NUMBER(15,2) |
yes |
| idcd_susp_d |
Suspended IDCD |
NUMBER(15,2) |
yes |
| idcd_ue_d |
Unearned IDCD |
NUMBER(15,2) |
yes |
| idcd_ytd_d |
Year to date IDCD |
NUMBER(15,2) |
yes |
| alt_idcd_cur_d |
Alternate current IDCD |
NUMBER(15,2) |
yes |
| alt_idcd_ue_d |
Alternate unearned IDCD |
NUMBER(15,2) |
yes |
| alt_idcd_ytd_d |
Alternate year to date IDCD |
NUMBER(15,2) |
yes |
| idce_d |
Guaranteed reserves IDCE |
NUMBER(15,2) |
yes |
| idce_ap_d |
Payable amount IDCE |
NUMBER(15,2) |
yes |
| idce_cur_d |
Current IDCE |
NUMBER(15,2) |
yes |
| idce_red_d |
Reduction IDCE |
NUMBER(15,2) |
yes |
| idce_susp_d |
Suspended IDCE |
NUMBER(15,2) |
yes |
| idce_ue_d |
Unearned IDCE |
NUMBER(15,2) |
yes |
| idce_ytd_d |
Year to date IDCE |
NUMBER(15,2) |
yes |
| alt_idce_cur_d |
Alternate current IDCE |
NUMBER(15,2) |
yes |
| alt_idce_ue_d |
Alternate unearned IDCE |
NUMBER(15,2) |
yes |
| alt_idce_ytd_d |
Alternate year to date IDCE |
NUMBER(15,2) |
yes |
| idcf_d |
Guaranteed reserves IDCF |
NUMBER(15,2) |
yes |
| idcf_ap_d |
Payable amount IDCF |
NUMBER(15,2) |
yes |
| idcf_cur_d |
Current IDCF |
NUMBER(15,2) |
yes |
| idcf_red_d |
Reduction IDCF |
NUMBER(15,2) |
yes |
| idcf_susp_d |
Suspended IDCF |
NUMBER(15,2) |
yes |
| idcf_ue_d |
Unearned IDCF |
NUMBER(15,2) |
yes |
| idcf_ytd_d |
Year to date IDCF |
NUMBER(15,2) |
yes |
| alt_idcf_cur_d |
Alternate current IDCF |
NUMBER(15,2) |
yes |
| alt_idcf_ue_d |
Alternate unearned IDCF |
NUMBER(15,2) |
yes |
| alt_idcf_ytd_d |
Alternate year to date IDCF |
NUMBER(15,2) |
yes |
| idcg_d |
Guaranteed reserves IDCG |
NUMBER(15,2) |
yes |
| idcg_ap_d |
Payable amount IDCG |
NUMBER(15,2) |
yes |
| idcg_cur_d |
Current IDCG |
NUMBER(15,2) |
yes |
| idcg_red_d |
Reduction IDCG |
NUMBER(15,2) |
yes |
| idcg_susp_d |
Suspended IDCG |
NUMBER(15,2) |
yes |
| idcg_ue_d |
Unearned IDCG |
NUMBER(15,2) |
yes |
| idcg_ytd_d |
Year to date IDCG |
NUMBER(15,2) |
yes |
| alt_idcg_cur_d |
Alternate current IDCG |
NUMBER(15,2) |
yes |
| alt_idcg_ue_d |
Alternate unearned IDCG |
NUMBER(15,2) |
yes |
| alt_idcg_ytd_d |
Alternate year to date IDCG |
NUMBER(15,2) |
yes |
| idch_d |
Guaranteed reserves IDCH |
NUMBER(15,2) |
yes |
| idch_ap_d |
Payable amount IDCH |
NUMBER(15,2) |
yes |
| idch_cur_d |
Current IDCH |
NUMBER(15,2) |
yes |
| idch_red_d |
Reduction IDCH |
NUMBER(15,2) |
yes |
| idch_susp_d |
Suspended IDCH |
NUMBER(15,2) |
yes |
| idch_ue_d |
Unearned IDCH |
NUMBER(15,2) |
yes |
| idch_ytd_d |
Year to date IDCH |
NUMBER(15,2) |
yes |
| alt_idch_cur_d |
Alternate current IDCH |
NUMBER(15,2) |
yes |
| alt_idch_ue_d |
Alternate unearned IDCH |
NUMBER(15,2) |
yes |
| alt_idch_ytd_d |
Alternate year to date IDCH |
NUMBER(15,2) |
yes |