| 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 |