| Columns | 
| Name | 
Description | 
Datatype ¿? | 
Allow Null | 
| por_s | 
Portfolio  | 
CHAR(2) | 
no | 
| unique_l | 
Record number (value is always 1)  | 
NUMBER(10) | 
no | 
| stamp_l | 
Record modification stamp  | 
NUMBER(10) | 
no | 
| app_stat_list_s | 
List of application statuses  | 
VARCHAR2(148) | 
yes | 
| app_ent_s | 
Entry requirements  | 
VARCHAR2(148) | 
yes | 
| disp1_s | 
Display field (X/' ')  | 
VARCHAR2(200) | 
yes | 
| disp2_s | 
Display field (X/' ')  | 
VARCHAR2(200) | 
yes | 
| disp3_s | 
Display field (X/' ')  | 
VARCHAR2(200) | 
yes | 
| fmv_trm1_l | 
FMV term [1]  | 
NUMBER(10) | 
yes | 
| fmv_trm2_l | 
FMV term [2]  | 
NUMBER(10) | 
yes | 
| fmv_trm3_l | 
FMV term [3]  | 
NUMBER(10) | 
yes | 
| fmv_trm4_l | 
FMV term [4]  | 
NUMBER(10) | 
yes | 
| fmv_trm5_l | 
FMV term [5]  | 
NUMBER(10) | 
yes | 
| h_cntr1_d | 
Maximum lease rate - precomputed simple  | 
NUMBER(15,5) | 
yes | 
| h_cntr2_d | 
Maximum lease rate - simple interest  | 
NUMBER(15,5) | 
yes | 
| h_cntr3_d | 
Maximum lease rate - level yield  | 
NUMBER(15,5) | 
yes | 
| h_cntr4_d | 
Maximum lease rate - rule of 12/78ths  | 
NUMBER(15,5) | 
yes | 
| h_cntr5_d | 
Maximum lease rate - straight line  | 
NUMBER(15,5) | 
yes | 
| l_cntr1_d | 
Minimum lease rate - precomputed simple  | 
NUMBER(15,5) | 
yes | 
| l_cntr2_d | 
Minimum lease rate - simple interest  | 
NUMBER(15,5) | 
yes | 
| l_cntr3_d | 
Minimum lease rate - level yield  | 
NUMBER(15,5) | 
yes | 
| l_cntr4_d | 
Minimum lease rate - rule of 12/78ths  | 
NUMBER(15,5) | 
yes | 
| l_cntr5_d | 
Minimum lease rate - straight line  | 
NUMBER(15,5) | 
yes | 
| h_dlr1_d | 
Maximum vendor rate - precomputed simple  | 
NUMBER(15,5) | 
yes | 
| h_dlr2_d | 
Maximum vendor rate - simple interest  | 
NUMBER(15,5) | 
yes | 
| h_dlr3_d | 
Maximum vendor rate - level yield  | 
NUMBER(15,5) | 
yes | 
| h_dlr4_d | 
Maximum vendor rate - rule of 12/78ths  | 
NUMBER(15,5) | 
yes | 
| h_dlr5_d | 
Maximum vendor rate - straight line  | 
NUMBER(15,5) | 
yes | 
| l_dlr1_d | 
Minimum vendor rate - precomputed simple  | 
NUMBER(15,5) | 
yes | 
| l_dlr2_d | 
Minimum vendor rate - simple interest  | 
NUMBER(15,5) | 
yes | 
| l_dlr3_d | 
Minimum vendor rate - level yield  | 
NUMBER(15,5) | 
yes | 
| l_dlr4_d | 
Minimum vendor rate - rule of 12/78ths  | 
NUMBER(15,5) | 
yes | 
| l_dlr5_d | 
Minimum vendor rate - straight line  | 
NUMBER(15,5) | 
yes | 
| h_inv1_d | 
Maximum investor rate - precomputed simple  | 
NUMBER(15,5) | 
yes | 
| h_inv2_d | 
Maximum investor rate - simple interest  | 
NUMBER(15,5) | 
yes | 
| h_inv3_d | 
Maximum investor rate - level yield  | 
NUMBER(15,5) | 
yes | 
| h_inv4_d | 
Maximum investor rate - rule of 12/78ths  | 
NUMBER(15,5) | 
yes | 
| h_inv5_d | 
Maximum investor rate - straight line  | 
NUMBER(15,5) | 
yes | 
| l_inv1_d | 
Minimum investor rate - precomputed simple  | 
NUMBER(15,5) | 
yes | 
| l_inv2_d | 
Minimum investor rate - simple interest  | 
NUMBER(15,5) | 
yes | 
| l_inv3_d | 
Minimum investor rate - level yield  | 
NUMBER(15,5) | 
yes | 
| l_inv4_d | 
Minimum investor rate - rule of 12/78ths  | 
NUMBER(15,5) | 
yes | 
| l_inv5_d | 
Minimum investor rate - straight line  | 
NUMBER(15,5) | 
yes | 
| fmv_per1_d | 
FMV percentage [1]  | 
NUMBER(15,2) | 
yes | 
| fmv_per2_d | 
FMV percentage [2]  | 
NUMBER(15,2) | 
yes | 
| fmv_per3_d | 
FMV percentage [3]  | 
NUMBER(15,2) | 
yes | 
| fmv_per4_d | 
FMV percentage [4]  | 
NUMBER(15,2) | 
yes | 
| fmv_per5_d | 
FMV percentage [5]  | 
NUMBER(15,2) | 
yes | 
| dflt_displ_pmt_c | 
Default display payment amount (Y/N)  | 
CHAR(1) | 
yes | 
| add_com_trn_c | 
Add comment to transaction (Y/N)  | 
CHAR(1) | 
yes | 
| past_due_priority_c | 
Priority settings affect application of payments to past-due
  items in (A/B/N):
  A - all payment processing
  B - batch payment processing only
  N - no payment processing  | 
CHAR(1) | 
yes | 
| waive_bank_s | 
Principal/payment interest bank code  | 
CHAR(3) | 
yes | 
| s_idc1_s | 
IDC1 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idc2_s | 
IDC2 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idc3_s | 
IDC3 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idc4_s | 
IDC4 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idc5_s | 
IDC5 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idr1_s | 
IDR1 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idr2_s | 
IDR2 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idr3_s | 
IDR3 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idr4_s | 
IDR4 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idr5_s | 
IDR5 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idr6_s | 
IDR6 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idr7_s | 
IDR7 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idr8_s | 
IDR8 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idr9_s | 
IDR9 alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idra_s | 
IDRA alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idrb_s | 
IDRB alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| s_idrc_s | 
IDRC alias - 21 characters  | 
VARCHAR2(21) | 
yes | 
| ss_idc1_s | 
IDC1 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idc2_s | 
IDC2 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idc3_s | 
IDC3 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idc4_s | 
IDC4 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idc5_s | 
IDC5 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idr1_s | 
IDR1 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idr2_s | 
IDR2 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idr3_s | 
IDR3 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idr4_s | 
IDR4 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idr5_s | 
IDR5 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idr6_s | 
IDR6 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idr7_s | 
IDR7 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idr8_s | 
IDR8 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idr9_s | 
IDR9 alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idra_s | 
IDRA alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idrb_s | 
IDRB alias - 9 characters  | 
CHAR(9) | 
yes | 
| ss_idrc_s | 
IDRC alias - 9 characters  | 
CHAR(9) | 
yes | 
| dwn_pmt_inf_c | 
Down payment is informational only (Y/N)  | 
CHAR(1) | 
yes | 
| auto_payo_loss_tol_d | 
Automatic payoff loss tolerance  | 
NUMBER(15,2) | 
yes | 
| auto_payo_gain_tol_d | 
Automatic payoff gain tolerance  | 
NUMBER(15,2) | 
yes | 
| rev_cat1_s | 
Reversal reason code/bank code [1]  | 
CHAR(5) | 
yes | 
| rev_cat2_s | 
Reversal reason code/bank code [2]  | 
CHAR(5) | 
yes | 
| rev_cat3_s | 
Reversal reason code/bank code [3]  | 
CHAR(5) | 
yes | 
| rev_cat4_s | 
Reversal reason code/bank code [4]  | 
CHAR(5) | 
yes | 
| rev_cat5_s | 
Reversal reason code/bank code [5]  | 
CHAR(5) | 
yes | 
| cc_auto_sus_bank_s | 
Default bank code for auto suspense  | 
CHAR(3) | 
yes | 
| cc_auto_sus_cro_s | 
Default C/R/O for auto suspense  | 
CHAR(7) | 
yes | 
| del_pmt_perc_l | 
Delinquency payment percentage  | 
NUMBER(10) | 
yes | 
| delq4_l | 
Delinquency category boundaries [4]  | 
NUMBER(10) | 
yes | 
| delq5_l | 
Delinquency category boundaries [5]  | 
NUMBER(10) | 
yes | 
| delq6_l | 
Delinquency category boundaries [6]  | 
NUMBER(10) | 
yes | 
| sec_bank_s | 
Default securitization bank code  | 
CHAR(3) | 
yes | 
| delq_method_c | 
Delinquency determination method before payoff (A/B/C)
  A - principal and interest
  B - principal, interest, and sales tax
  C - principal, interest, and charges included by column
      rpar.chrg_delq_c | 
CHAR(1) | 
yes | 
| pmt_frst_extdef_l | 
Number of payments for first extension/deferment eligibility  | 
NUMBER(10) | 
yes | 
| pmt_btw_extdef_l | 
Number of payments between for next extension/deferment  | 
NUMBER(10) | 
yes |