Description |
Column |
Datatype |
Portfolio
|
por_s |
char (2) |
Record number
|
unique_l |
integer |
Sybase timestamp
|
timestamp |
timestamp |
List of application statuses
|
app_stat_list_s |
char (148) |
Entry requirements
|
app_ent_s |
char (148) |
Display field (X/' ')
|
disp1_s |
char (200) |
Display field (X/' ')
|
disp2_s |
char (200) |
Display field (X/' ')
|
disp3_s |
char (200) |
FMV term [1]
|
fmv_trm1_l |
integer |
FMV term [2]
|
fmv_trm2_l |
integer |
FMV term [3]
|
fmv_trm3_l |
integer |
FMV term [4]
|
fmv_trm4_l |
integer |
FMV term [5]
|
fmv_trm5_l |
integer |
Maximum lease rate - precomputed simple
|
h_cntr1_d |
double precision |
Maximum lease rate - simple interest
|
h_cntr2_d |
double precision |
Maximum lease rate - level yield
|
h_cntr3_d |
double precision |
Maximum lease rate - rule of 12/78ths
|
h_cntr4_d |
double precision |
Maximum lease rate - straight line
|
h_cntr5_d |
double precision |
Minimum lease rate - precomputed simple
|
l_cntr1_d |
double precision |
Minimum lease rate - simple interest
|
l_cntr2_d |
double precision |
Minimum lease rate - level yield
|
l_cntr3_d |
double precision |
Minimum lease rate - rule of 12/78ths
|
l_cntr4_d |
double precision |
Minimum lease rate - straight line
|
l_cntr5_d |
double precision |
Maximum vendor rate - precomputed simple
|
h_dlr1_d |
double precision |
Maximum vendor rate - simple interest
|
h_dlr2_d |
double precision |
Maximum vendor rate - level yield
|
h_dlr3_d |
double precision |
Maximum vendor rate - rule of 12/78ths
|
h_dlr4_d |
double precision |
Maximum vendor rate - straight line
|
h_dlr5_d |
double precision |
Minimum vendor rate - precomputed simple
|
l_dlr1_d |
double precision |
Minimum vendor rate - simple interest
|
l_dlr2_d |
double precision |
Minimum vendor rate - level yield
|
l_dlr3_d |
double precision |
Minimum vendor rate - rule of 12/78ths
|
l_dlr4_d |
double precision |
Minimum vendor rate - straight line
|
l_dlr5_d |
double precision |
Maximum investor rate - precomputed simple
|
h_inv1_d |
double precision |
Maximum investor rate - simple interest
|
h_inv2_d |
double precision |
Maximum investor rate - level yield
|
h_inv3_d |
double precision |
Maximum investor rate - rule of 12/78ths
|
h_inv4_d |
double precision |
Maximum investor rate - straight line
|
h_inv5_d |
double precision |
Minimum investor rate - precomputed simple
|
l_inv1_d |
double precision |
Minimum investor rate - simple interest
|
l_inv2_d |
double precision |
Minimum investor rate - level yield
|
l_inv3_d |
double precision |
Minimum investor rate - rule of 12/78ths
|
l_inv4_d |
double precision |
Minimum investor rate - straight line
|
l_inv5_d |
double precision |
FMV percentage [1]
|
fmv_per1_d |
double precision |
FMV percentage [2]
|
fmv_per2_d |
double precision |
FMV percentage [3]
|
fmv_per3_d |
double precision |
FMV percentage [4]
|
fmv_per4_d |
double precision |
FMV percentage [5]
|
fmv_per5_d |
double precision |
Default display payment amount (Y/N)
|
dflt_displ_pmt_c |
char (1) |
Add comment to transaction (Y/N)
|
add_com_trn_c |
char (1) |
Apply payments past due/priority (A/B/N)
|
past_due_priority_c |
char (1) |
Priority assessment (Y/N)
|
asm_priority_c |
char (33) |
Principal/payment interest bank code
|
waive_bank_s |
char (3) |
IDC1 alias - 21 characters
|
s_idc1_s |
char (21) |
IDC2 alias - 21 characters
|
s_idc2_s |
char (21) |
IDC3 alias - 21 characters
|
s_idc3_s |
char (21) |
IDC4 alias - 21 characters
|
s_idc4_s |
char (21) |
IDC5 alias - 21 characters
|
s_idc5_s |
char (21) |
IDR1 alias - 21 characters
|
s_idr1_s |
char (21) |
IDR2 alias - 21 characters
|
s_idr2_s |
char (21) |
IDR3 alias - 21 characters
|
s_idr3_s |
char (21) |
IDR4 alias - 21 characters
|
s_idr4_s |
char (21) |
IDR5 alias - 21 characters
|
s_idr5_s |
char (21) |
IDR6 alias - 21 characters
|
s_idr6_s |
char (21) |
IDR7 alias - 21 characters
|
s_idr7_s |
char (21) |
IDR8 alias - 21 characters
|
s_idr8_s |
char (21) |
IDR9 alias - 21 characters
|
s_idr9_s |
char (21) |
IDRA alias - 21 characters
|
s_idra_s |
char (21) |
IDRB alias - 21 characters
|
s_idrb_s |
char (21) |
IDRC alias - 21 characters
|
s_idrc_s |
char (21) |
IDC1 alias - 9 characters
|
ss_idc1_s |
char (9) |
IDC2 alias - 9 characters
|
ss_idc2_s |
char (9) |
IDC3 alias - 9 characters
|
ss_idc3_s |
char (9) |
IDC4 alias - 9 characters
|
ss_idc4_s |
char (9) |
IDC5 alias - 9 characters
|
ss_idc5_s |
char (9) |
IDR1 alias - 9 characters
|
ss_idr1_s |
char (9) |
IDR2 alias - 9 characters
|
ss_idr2_s |
char (9) |
IDR3 alias - 9 characters
|
ss_idr3_s |
char (9) |
IDR4 alias - 9 characters
|
ss_idr4_s |
char (9) |
IDR5 alias - 9 characters
|
ss_idr5_s |
char (9) |
IDR6 alias - 9 characters
|
ss_idr6_s |
char (9) |
IDR7 alias - 9 characters
|
ss_idr7_s |
char (9) |
IDR8 alias - 9 characters
|
ss_idr8_s |
char (9) |
IDR9 alias - 9 characters
|
ss_idr9_s |
char (9) |
IDRA alias - 9 characters
|
ss_idra_s |
char (9) |
IDRB alias - 9 characters
|
ss_idrb_s |
char (9) |
IDRC alias - 9 characters
|
ss_idrc_s |
char (9) |
Down payment is informational only (Y/N)
|
dwn_pmt_inf_c |
char (1) |
Automatic payoff loss tolerance
|
auto_payo_loss_tol_d |
double precision |
Automatic payoff gain tolerance
|
auto_payo_gain_tol_d |
double precision |
Reversal reason code/bank code [1]
|
rev_cat1_s |
char (5) |
Reversal reason code/bank code [2]
|
rev_cat2_s |
char (5) |
Reversal reason code/bank code [3]
|
rev_cat3_s |
char (5) |
Reversal reason code/bank code [4]
|
rev_cat4_s |
char (5) |
Reversal reason code/bank code [5]
|
rev_cat5_s |
char (5) |
Default bank code for auto suspense
|
cc_auto_sus_bank_s |
char (3) |
Default C/R/O for auto suspense
|
cc_auto_sus_cro_s |
char (7) |
Delinquency payment percentage
|
del_pmt_perc_l |
integer |
Delinquency category boundaries [4]
|
delq4_l |
integer |
Delinquency category boundaries [5]
|
delq5_l |
integer |
Delinquency category boundaries [6]
|
delq6_l |
integer |
Default securitization bank code
|
sec_bank_s |
char (3) |
Override late charges for delinquency
payment percentage (Y/N)
|
over_ltchgs_del_pmt_c |
char (1) |
Number of payments for first extension/deferment eligibility
|
pmt_frst_extdef_l |
integer |
Number of payments between for next extension/deferment
|
pmt_btw_extdef_l |
integer |
(c) Copyright 2004 McCue Systems, Inc.