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 |