| Name | Description | 
|---|---|
| rap | Application | 
| Name | Segment 1 | Segment 2 | 
|---|---|---|
| rapa_idx0 | app_s | unique_l | 
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null | 
| app_s | Application  | 
char(10) | no | 
| unique_l | Record number (value is always 1)  | 
integer | no | 
| timestamp | Record modification stamp  | 
timestamp | yes | 
| stg_eqty_d | Staged equity amount  | 
double precision | yes | 
| lvr_c | Leveraged (Y/N)  | 
char(1) | yes | 
| d_lvr_com_s | Leveraged commencement date  | 
datetime | yes | 
| d_lst_lvr_s | Date of last leveraged table download  | 
datetime | yes | 
| lvr_trm_l | Leveraged term  | 
integer | yes | 
| stg_eqty_pay_to_s | Staged equity fund payable to  | 
char(9) | yes | 
| npyr_min_d | Non-pyramiding late charge minimum payment due  | 
double precision | yes | 
| note_follow_up_l | Notebook follow-up days  | 
integer | yes | 
| d_fasb13_test_s | FASB 13 test date  | 
datetime | yes | 
| fasb13_test_c | FASB 13 test result (P/F/' ') P - Pass F - Fail ' ' - Untested  | 
char(1) | yes | 
| orig_intfc_s | Originating interface MBT - Microbilt MPR - mPower STM - SuperTrump  | 
char(3) | yes | 
| metro2_s | Metro2 file format code  | 
char(4) | yes | 
| invo_format_s | Invoice format code  | 
char(4) | yes | 
| non_comm_d | Non commission amount  | 
double precision | yes | 
| opt_res_d | Optional residual  | 
double precision | yes | 
| p_opt_res_d | Optional residual percentage  | 
double precision | yes | 
| revolving_drawdown_c | Revolving drawdown credit (Y/N)  | 
char(1) | yes | 
| stax_exempt_s | Sales/use tax exempt code  | 
char(4) | yes | 
| oper_drawdown_d | Operating lease application drawdown amount  | 
double precision | yes | 
| dlr_rec_pmts_d | Dealer-received payments  | 
double precision | yes | 
| prn_write_down_c | Principal write down (Y/N)  | 
char(1) | yes | 
| float_bus_or_cal_c | Set float rate on business or calendar day (P/F/C) P - previous business day F - following business day C - calendar day  | 
char(1) | yes | 
| float_frq_s | Frequency of float rate setting DAY - daily MON - monthly QTR - quarterly SEMI - semiannually ANNL - annually NONE - rate setting functionality is disabled  | 
char(4) | yes | 
| float_day_l | Day of month on which float rate is set (1-31 or 0) A value of zero indicates that the rate setting functionality has been disabled.  | 
integer | yes | 
| float_mon_l | Month in which float rate is set (1-12 or 0) 0 - if frequency is NONE, MON or DAY 1 to 3 - if frequency is QTR 1 to 6 - if frequency is SEMI 1 to 12 - if frequency is ANNL  | 
integer | yes | 
| p_float_base_d | Float base rate percentage  | 
double precision | yes | 
| calendar_s | Calendar to use for determining business days  | 
char(4) | yes | 
| dlr_pmt_bank_code_s | Dealer payment bank code  | 
char(4) | yes | 
| d_cntr_end_s | Contract end date  | 
datetime | yes | 
| dlr_pmt_applied_c | Dealer payments applied (Y/N)  | 
char(1) | yes | 
| rcr_pmt_sched_c | Has recurring charge payment schedule (Y/N)  | 
char(1) | yes | 
| rcr_synch_c | Recurring charge payment schedule in synch with lease (Y/N)  | 
char(1) | yes | 
| asset_lvl_c | Has asset level payment schedule (Y/N)  | 
char(1) | yes | 
| assmt_desc_c | Has assessment description (Y/N)  | 
char(1) | yes | 
| p_unused_fee_d | Unused drawdown fee rate  | 
double precision | yes | 
| unused_fee_thresh_d | Unused drawdown fee threshold  | 
double precision | yes | 
| d_unused_fee_start_s | Start date of unused drawdown fee assessment  | 
datetime | yes | 
| d_unused_fee_next_s | Next date of unused drawdown fee assessment  | 
datetime | yes | 
| unused_fee_frq_s | Unused drawdown fee frequency (NONE/DAY/MON/QTR/SEMI/ANNL)  | 
char(4) | yes | 
| pmt_hier_s | Payment hierarchy  | 
char(4) | yes | 
| pool_id_s | Pool ID  | 
char(10) | yes | 
| inst_id_s | PAP institution/ACH transit ID  | 
char(9) | yes | 
| payer_acct_s | PAP account number  | 
char(17) | yes | 
| payer_acct_nam_s | PAP bank account name  | 
char(50) | yes | 
| d_pap_eff_s | PAP effective date  | 
datetime | yes | 
| vtx_o_c | Use Vertex O (Y/N/NULL) Y - Vertex O is used N or NULL - Vertex O is not used  | 
char(1) | yes | 
| int_free_mths_l | Interest free months  | 
integer | yes | 
| prepaid_c | Prepaid lease (Y/N)  | 
char(1) | yes | 
| auto_pay_interval_l | Auto-pay interval frequency (0/1/2/4) 0 - defined in rjp (Automatic Payment Interval Schedule) 1 - once per billing cycle 2 - twice per billing cycle 4 - four times per billing cycle  | 
integer | yes | 
| idc8_d | Guaranteed reserves IDC8  | 
double precision | yes | 
| idc9_d | Guaranteed reserves IDC9  | 
double precision | yes | 
| idca_d | Guaranteed reserves IDCA  | 
double precision | yes | 
| idcb_d | Guaranteed reserves IDCB  | 
double precision | yes | 
| idcc_d | Guaranteed reserves IDCC  | 
double precision | yes | 
| idcd_d | Guaranteed reserves IDCD  | 
double precision | yes | 
| idce_d | Guaranteed reserves IDCE  | 
double precision | yes | 
| idcf_d | Guaranteed reserves IDCF  | 
double precision | yes | 
| idcg_d | Guaranteed reserves IDCG  | 
double precision | yes | 
| idch_d | Guaranteed reserves IDCH  | 
double precision | yes | 
| idc_asc842_d | Total IDC ASC 842 initial direct cost amount  | 
double precision | yes | 
| accrual_cycle_c | Accrual/billing cycle (M/S/B/W) M - Monthly (12 per year) S - Semi-monthly (24 per year) B - Bi-weekly (26 per year) W - Weekly (52 per year)  | 
char(1) | yes | 
| idc_book_accting_c | IDC book accounting method (I/A/B) I - Income A - Amortization B - Alternative amortization  | 
char(1) | yes | 
| pmt_source_s | Payment source  | 
char(2) | yes | 
| auto_pay_c | Auto-pay through a Payment Service (Y/N)  | 
char(1) | yes | 
| d_auto_pay_start_s | Auto-pay start date  | 
datetime | yes | 
| d_auto_pay_stop_s | Auto-pay stop date  | 
datetime | yes | 
| auto_pay_amt_type_c | Auto-pay amount type (A/B/C/D/T/P/O/' ')
  A - Total outstanding on current invoice (apply lease)
  B - Total outstanding on current invoice (apply invoice)
  C - Payment and tax outstanding on current invoice (apply
      lease)
  D - Payment and tax outstanding on current invoice (apply
      invoice)
  T - Total outstanding on lease
  P - Payment and tax outstanding on lease
  O - Other specified amount
  ' ' - n/a | 
char(1) | yes | 
| auto_pay_other_amt_d | Auto-pay other amount  | 
double precision | yes |