lnmast_raw
Core Schemas
>
Silverlake
>
lnmast_raw
Column name | Description | Mode | Type | Length |
---|---|---|---|---|
__op | Contains the operation type. Values are I for insert, U for update, D for delete. | REQUIRED | STRING | |
__op_ts | operation timestamp added by export code | REQUIRED | TIMESTAMP | |
__uid | The Unique ID of this entry. Data, UUID, or GUID | REQUIRED | STRING | |
__ver | Mapping and Schema Version | REQUIRED | INTEGER | |
br_num_ | Branch Number | DEC(3,0) | NULLABLE | INTEGER | 3 |
acctno | Account Number | DEC(16,0) | NULLABLE | INTEGER | 16 |
actype | Account Type | CHAR(1) | NULLABLE | STRING | 1 |
sname | Short Name | CHAR(20) | NULLABLE | STRING | 20 |
cifno | CIF Number | CHAR(7) | NULLABLE | STRING | 7 |
altadd | Alternate Address Code | CHAR(1) | NULLABLE | STRING | 1 |
addnam | Additional Names Code | CHAR(1) | NULLABLE | STRING | 1 |
altnam | Alternate Names Code | CHAR(1) | NULLABLE | STRING | 1 |
offcr | Officer | CHAR(6) | NULLABLE | STRING | 6 |
coffcr | Officer | CHAR(6) | NULLABLE | STRING | 6 |
status | Status | DEC(1,0) | NULLABLE | INTEGER | 1 |
prvsts | Previous Status | DEC(1,0) | NULLABLE | INTEGER | 1 |
class | Class Code | CHAR(1) | NULLABLE | STRING | 1 |
type | Loan Type | CHAR(2) | NULLABLE | STRING | 2 |
orgamt | Original Balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
cbal | Current Balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
acbal | Accrual Balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
qrybal | Query Balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
sldbal | Sold Balances | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
accint | Accrued Interest | DEC(15,5) | NULLABLE | FLOAT | 15.5 |
accin2 | Secondary Accrued Int | DEC(15,5) | NULLABLE | FLOAT | 15.5 |
dlracc | M-T-D Dealer Accrued Int | DEC(11,5) | NULLABLE | FLOAT | 11.5 |
pdiem | Daily Accrual | DEC(13,5) | NULLABLE | FLOAT | 13.5 |
bkdisc | Bank Discount | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
dlrdsc | Dealer Discount | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
othchg | Other Charges | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
asslc | Assessed Late Charges | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
paidlc | Paid Late Charges | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
mincg | Minimum Charge | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
curpo | Current Month Payoff | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
nxtpo | Next Month Payoff | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
intreb | Interest Rebate | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
dlrreb | Dealer Rebate | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
pmtamt | Payment Amount | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
piamt | Princ & int pmt amt | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
lstpmt | Last Pymt Amount | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
prtpmt | Partial Pymt Amt | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
bilprn | Billed Prin Amt | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
bilint | Billed Int Amt | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
bilesc | Billed Escrow Amt | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
billc | Billed Late Chgs | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
biloc | Billed Other Chgs | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
bilcl | Billed Credit Life | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
bilah | Billed A&H Insurance | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
bilun | Billed Unemployment | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
eoldpm | Old Payment Amount | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
oldpi | Old P&I amount | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
oldepm | Old Escrow pmt amt | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
newpmt | New Payment Amount | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
newpi | New P&I Pmt Amount | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
amrsus | Amortized Pymt Suspense | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
subamt | Subsidy amount in effect | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
subrem | Subsidy balance remaining | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
amrint | One Mo Int On Amort Loan | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
apramt | Appraised Value | DEC(9,0) | NULLABLE | INTEGER | 9 |
anincm | Annual Income | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
preacc | Accrued Int at Year End | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
predsc | Int Rebate at Year End | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
yscbal | Yesterday Balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ysacci | Yesterdays Accrued | DEC(15,5) | NULLABLE | FLOAT | 15.5 |
ysireb | Yesterdays Int rebate | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
ysdreb | Yesterday Dealer rebate | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
ysothc | Yesterdays Other Chgs | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
intody | Interest Paid Today | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
stmbal | Balance Last Stmt | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
renbal | Renew/Ext Balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ballon | Balloon Payment | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
pacbal | Last Accrual Balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
chgoff | Charge Off Amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
pntpd | Points Paid | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
lstadv | Last Advance | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
curtmn | Curtailment | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
accurt | Accrual Curtailment this Period | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
shcopr | Shadow charged off principal | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
shcoin | Shadow charged off interest | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
shiap | Shadow interest applied to principal | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
shglpr | Shadow GL principal balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
shacci | Shadow accrued interest | DEC(15,5) | NULLABLE | FLOAT | 15.5 |
shcint | Shadow capitalized fees | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
shcsts | Shadow Status | CHAR(1) | NULLABLE | STRING | 1 |
yrlfee | Yearly fee | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
minadv | Minimum Advance | DEC(9,0) | NULLABLE | INTEGER | 9 |
lnuchg | Unpaid Charges | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
poamnt | Prin Collected At payoff | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
orgadv | Original advance Amount | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
mtdadv | MTD Advances | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
mtdcurt | MTD Curtailments | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
mtdprin | MTD Principal Payments | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
mtdcapdr | MTD Capitalization Debits | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
mtdcapcr | MTD Capitalization Credits | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
orgdt6 | Original Loan Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
matdt6 | Maturity Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
datop6 | Date Entered | DEC(6,0) | NULLABLE | INTEGER | 6 |
nrevd6 | Next Review Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
coexd6 | Collat Ins Expiration | DEC(6,0) | NULLABLE | INTEGER | 6 |
ucexd6 | UCC Expiration Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
nspdt6 | Next Sched Pymt Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
fpdt6 | 1st Pymt Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
lpdt6 | Last Pymt Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
npdt6 | Next Pymt Due Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
npday | Pymt Day of Month | DEC(2,0) | NULLABLE | INTEGER | 2 |
thrud6 | Pymt Good Thru Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
pdtod6 | Int Paid to Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
cured6 | Last Right to Cure Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
curbd6 | Cure by Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
rendt6 | Date Last Renewed | DEC(6,0) | NULLABLE | INTEGER | 6 |
renpd6 | Date Previous Renewal | DEC(6,0) | NULLABLE | INTEGER | 6 |
extdt6 | Last Extension Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
extpd6 | Date Previous Extension | DEC(6,0) | NULLABLE | INTEGER | 6 |
examd6 | Examiner Class Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
lfmdt6 | Last Maint Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
orgmd6 | Original Maturity Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
nwpmd6 | New P&I Effective Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
nwesd6 | New escrow payment effective date | DEC(6,0) | NULLABLE | INTEGER | 6 |
nwead6 | New escrow pmt effective date after spread | DEC(6,0) | NULLABLE | INTEGER | 6 |
neand6 | Next escrow analysis date | DEC(6,0) | NULLABLE | INTEGER | 6 |
prevd6 | Rate Review Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stmdt6 | Date Last Statement | DEC(6,0) | NULLABLE | INTEGER | 6 |
cpndt6 | Coupon Book Reorder Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
nacdt6 | Nonaccrual Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
chgdt6 | Chg off Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
wchdt6 | Date on Watch list | DEC(6,0) | NULLABLE | INTEGER | 6 |
prvday | Rate Review Day | DEC(2,0) | NULLABLE | INTEGER | 2 |
appdt6 | Last Appraisal Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
amrdt6 | Amortize Thru Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
lstad6 | Last Advance Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
lstcp6 | Last Coupon Order Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
ecrdt6 | Rate Cap Review Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
ecrday | Rate Cap Review Day | DEC(2,0) | NULLABLE | INTEGER | 2 |
enwrd6 | New Rate Effective Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
cvexp6 | Convertable Expiration date | DEC(6,0) | NULLABLE | INTEGER | 6 |
activ6 | Last Activity Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
frcld6 | Foreclosure date | DEC(6,0) | NULLABLE | INTEGER | 6 |
reamd6 | Payment Reamortization date | DEC(6,0) | NULLABLE | INTEGER | 6 |
reamday | Payment Reamortization day of month | DEC(2,0) | NULLABLE | INTEGER | 2 |
dtpdo6 | Date paid off | DEC(6,0) | NULLABLE | INTEGER | 6 |
cnvdt6 | Conversion Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
permfd6 | PERMANENT FINANCE DATE | DEC(6,0) | NULLABLE | INTEGER | 6 |
hecnv6 | Loan Conversion Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
steprd6 | Step Rate End Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
orgadvd6 | Date orig Advance | DEC(6,0) | NULLABLE | INTEGER | 6 |
repricd6 | Last Re-priced Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
orgdt | Original Loan Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
matdt | Maturity Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
datopn | Date Entered | DEC(7,0) | NULLABLE | INTEGER | 7 |
nrevdt | Next Review Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
coexdt | Collat Ins Expiration | DEC(7,0) | NULLABLE | INTEGER | 7 |
ucexdt | UCC Expiration Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
nspdt | Next Sched Pymt Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
fpdt | 1st Pymt Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
lpdt | Last Pymt Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
npdt | Next Pymt Due Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
thrudt | Pymt Good Thru Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
pdtodt | Int Paid to Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
curedt | Last Right to Cure Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
curbdt | Cure by Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
rendt | Date Last Renewed | DEC(7,0) | NULLABLE | INTEGER | 7 |
renpdt | Date Previous Renewal | DEC(7,0) | NULLABLE | INTEGER | 7 |
extdt | Last Extension Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
extpdt | Date Previous Extension | DEC(7,0) | NULLABLE | INTEGER | 7 |
examdt | Examiner Class Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
lfmdt | Last Maint Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
orgmdt | Original Maturity Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
nwpmdt | New P&I Effective Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
nwesdt | New escrow payment effective date | DEC(7,0) | NULLABLE | INTEGER | 7 |
nweadt | New escrow pmt effective date after spread | DEC(7,0) | NULLABLE | INTEGER | 7 |
neandt | Next escrow analysis date | DEC(7,0) | NULLABLE | INTEGER | 7 |
prevdt | Rate Review Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stmdt | Date Last Statement | DEC(7,0) | NULLABLE | INTEGER | 7 |
cpndt | Coupon Book Reorder Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
nacdt | Nonaccrual Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
chgdt | Chg off Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
wchdt | Date on Watch list | DEC(7,0) | NULLABLE | INTEGER | 7 |
appdt7 | Last Appraisal Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
amrdt7 | Amortize Thru Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
lstad7 | Last Advance Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
lstcp7 | Last Coupon Order Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
ecrdt | Rate Cap Review Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
enwrdt | New Rate Effective Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
cvexp7 | Convertable Expiration date | DEC(7,0) | NULLABLE | INTEGER | 7 |
activ7 | Last Activity Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
frcld7 | Foreclosure date | DEC(7,0) | NULLABLE | INTEGER | 7 |
reamd7 | Payment Reamortization date | DEC(7,0) | NULLABLE | INTEGER | 7 |
dtpdo7 | Date paid off | DEC(7,0) | NULLABLE | INTEGER | 7 |
cnvdt7 | Conversion Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
permfd7 | PERMANENT FINANCE DATE | DEC(7,0) | NULLABLE | INTEGER | 7 |
hecnv7 | Loan Conversion Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
steprdt | Step Rate End Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
orgadvd7 | Date orig Advance | DEC(7,0) | NULLABLE | INTEGER | 7 |
repricd7 | Last Re-priced Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
rate | Note Rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
dlqrate | Delinquent rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
dlrate | Dealer Rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
dlrupc | Upfront percentage | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
dlrrpc | Dealer Reserve Pct | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
dlrdys | # of days forfeit rebate | DEC(3,0) | NULLABLE | INTEGER | 3 |
dlrpmt | # of pmts forfeit rebate | DEC(3,0) | NULLABLE | INTEGER | 3 |
dlrfor | Forfeit U/F Dlr Disc/Reb | CHAR(1) | NULLABLE | STRING | 1 |
dlrbod | U/F Remainder Bank/Dlr | CHAR(1) | NULLABLE | STRING | 1 |
dlrrsv | Dealer Reserve | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
dlrbrs | Bank Reserve | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
dlrern | Dealer Earnings | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
dlrber | Bank Earnings | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
dlruer | Upfront Earnings | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
dlrfer | Forfeited Earnings | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ttlint | Total Interest | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
matrat | Maturity Rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
prate_num_ | Rate Number | DEC(3,0) | NULLABLE | INTEGER | 3 |
dlqrate_num_ | Delinquent Rate Number | DEC(3,0) | NULLABLE | INTEGER | 3 |
pvari | Rate Variance | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
pvcode | Rate Variance Code | CHAR(1) | NULLABLE | STRING | 1 |
dlqvari | Delinquent rate variance | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
dlqvcode | Delinquent rate variance code | CHAR(1) | NULLABLE | STRING | 1 |
dlqrtdys | Delinquent rate days | DEC(3,0) | NULLABLE | INTEGER | 3 |
pfloor | Rate Floor | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
pceil | Rate Ceiling | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
prterm | Rate Review Term | DEC(3,0) | NULLABLE | INTEGER | 3 |
prcode | Rate Review Term Code | CHAR(1) | NULLABLE | STRING | 1 |
ecapup | Rate Cap Upwards | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
ecapdn | Rate Cap Downwards | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
ecrtrm | Rate Cap Period | DEC(3,0) | NULLABLE | INTEGER | 3 |
ecrtcd | Rate Cap Period Code | CHAR(1) | NULLABLE | STRING | 1 |
ecryov | Rate Carryover | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
ecryos | Rate Carryover Sign | CHAR(1) | NULLABLE | STRING | 1 |
ecrnov | New Rate Carryover | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
ecrnos | New Carryover Sign | CHAR(1) | NULLABLE | STRING | 1 |
ecrpov | Previous Rate Carryover | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
ecrpos | Previous Carryover Sign | CHAR(1) | NULLABLE | STRING | 1 |
ecryou | Use Rate Carryover | CHAR(1) | NULLABLE | STRING | 1 |
ermeth | Rounding Method | CHAR(1) | NULLABLE | STRING | 1 |
eramt | Round to Amount | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
ecprt | Rate at Beg Of Period | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
eprvrt | Previous Rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
enwrt | New Rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
epmcap | Payment Amount Cap | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
enpdys | Notice Pre-Days | DEC(2,0) | NULLABLE | INTEGER | 2 |
orgidx | Original index | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
curidx | Current index | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
prvidx | Previous index | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
futidx | Future index | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
cvrtab | Convertable ARM | CHAR(1) | NULLABLE | STRING | 1 |
cindx_num_ | Convertable Index number | DEC(3,0) | NULLABLE | INTEGER | 3 |
cvvari | Convertable Variance | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
cvvarc | Convertable Variance code | CHAR(1) | NULLABLE | STRING | 1 |
term | Loan Term | DEC(3,0) | NULLABLE | INTEGER | 3 |
tmcode | Loan Term Code | CHAR(1) | NULLABLE | STRING | 1 |
freq | Payment Frequency | DEC(3,0) | NULLABLE | INTEGER | 3 |
frcode | Payment Freq Code | CHAR(1) | NULLABLE | STRING | 1 |
semdy1 | Semi Mnthly 1st day | DEC(2,0) | NULLABLE | INTEGER | 2 |
semdy2 | Semi Mnthly 2nd day | DEC(2,0) | NULLABLE | INTEGER | 2 |
ibase | Interest Base | DEC(1,0) | NULLABLE | INTEGER | 1 |
pmtcod | Payment Code | DEC(1,0) | NULLABLE | INTEGER | 1 |
altsch | Alternate Pymt Sched | CHAR(1) | NULLABLE | STRING | 1 |
reamor | Reamortize Payment Amt | CHAR(1) | NULLABLE | STRING | 1 |
bilndy | #days for Billing Notice | DEC(3,0) | NULLABLE | INTEGER | 3 |
reamtrm | Reamortization Term | DEC(3,0) | NULLABLE | INTEGER | 3 |
reamtmcd | Reamortization Term code | CHAR(1) | NULLABLE | STRING | 1 |
pflc | Profit Period Late Chgs | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
pfextf | Profit Period Ext Fees | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
pfbal | Profit period Agg Bal | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
pfearn | Profit period Int earned | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
pfdays | Profit period Agg Days | DEC(5,0) | NULLABLE | INTEGER | 5 |
cpd10 | Times Past Due 10-29 | DEC(3,0) | NULLABLE | INTEGER | 3 |
cpd30 | Times Past Due 30-59 | DEC(3,0) | NULLABLE | INTEGER | 3 |
cpd60 | Times Past Due 60-89 | DEC(3,0) | NULLABLE | INTEGER | 3 |
cpd90 | Times Past Due 90-119 | DEC(3,0) | NULLABLE | INTEGER | 3 |
extfee | Extension Fees YTD | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
orgfee | Origination Fees YTD | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
ytdint | Interest Paid YTD | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ytdprn | Principal Paid YTD | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ytdlc | Late chgs Paid YTD | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
extytd | Times Extended Y-T-D | DEC(3,0) | NULLABLE | INTEGER | 3 |
rtcytd | Right to Cures Y-T-D | DEC(3,0) | NULLABLE | INTEGER | 3 |
renytd | Times Renewed Y-T-D | DEC(3,0) | NULLABLE | INTEGER | 3 |
ytdadv | YTD Advances | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ytdcurt | YTD Curtailments | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ytdprin | YTD Principal Payments | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ytdcapdr | YTD Capitalization Debits | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ytdcapcr | YTD Capitalization Credits | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ppd10 | Last Year Past Due 10-29 | DEC(3,0) | NULLABLE | INTEGER | 3 |
ppd30 | Last Year Past Due 30-59 | DEC(3,0) | NULLABLE | INTEGER | 3 |
ppd60 | Last Year Past Due 60-89 | DEC(3,0) | NULLABLE | INTEGER | 3 |
ppd90 | Last Year Past Due 90-119 | DEC(3,0) | NULLABLE | INTEGER | 3 |
intpre | Int Paid Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
lcpre | LC paid Last Year | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
irspre | IRS Interest Last year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
extpre | Pymt # Extended Last Yr | DEC(3,0) | NULLABLE | INTEGER | 3 |
orgpre | Org fees Previous year | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
renpre | Times Renewed Last Year | DEC(3,0) | NULLABLE | INTEGER | 3 |
lpd10 | Life Time Past Due 10-29 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lpd30 | Life Time Past Due 30-59 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lpd60 | Life Time Past Due 60-89 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lpd90 | Life Time Past Due 90-119 | DEC(3,0) | NULLABLE | INTEGER | 3 |
intltd | Int Paid Life to Date | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
extltd | Pymt # Extended L-T-D | DEC(3,0) | NULLABLE | INTEGER | 3 |
rtcltd | Right to Cures L-T-D | DEC(3,0) | NULLABLE | INTEGER | 3 |
extmth | Months Extended LTD | DEC(3,0) | NULLABLE | INTEGER | 3 |
extfel | Extension Fees LTD | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
renltd | Times Renewed L-T-D | DEC(3,0) | NULLABLE | INTEGER | 3 |
irsltd | IRS Interest L-T-D | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
orgltd | Org fees Life to date | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
nexltd | # Extension Life to date | DEC(3,0) | NULLABLE | INTEGER | 3 |
delin4 | # Delin Quarter 4 | DEC(2,0) | NULLABLE | INTEGER | 2 |
delin3 | # Delin Quarter 3 | DEC(2,0) | NULLABLE | INTEGER | 2 |
delin2 | # Delin Quarter 2 | DEC(2,0) | NULLABLE | INTEGER | 2 |
delin1 | # Delin Curr Quarter | DEC(2,0) | NULLABLE | INTEGER | 2 |
qagqrybal | QUARTERLY AGGREGATE QUERY BALANCE | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
partid | Participation Code | CHAR(1) | NULLABLE | STRING | 1 |
clcode | Credit Line Code | CHAR(1) | NULLABLE | STRING | 1 |
deptcd | Department Code | CHAR(1) | NULLABLE | STRING | 1 |
shadow | Shadow processing flag | CHAR(1) | NULLABLE | STRING | 1 |
shaccf | Shadow accrual flag | CHAR(1) | NULLABLE | STRING | 1 |
shrpco | Shadow report as C/O | CHAR(1) | NULLABLE | STRING | 1 |
grp | Group Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
glcost | GL Cost Center | DEC(4,0) | NULLABLE | INTEGER | 4 |
glprod | GL Product Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
calrep | Call Report Code | CHAR(8) | NULLABLE | STRING | 8 |
colcod | Collateral Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
purcod | Purpose Code | DEC(2,0) | NULLABLE | INTEGER | 2 |
dlrno | Dealer # | DEC(7,0) | NULLABLE | INTEGER | 7 |
hmail | Hold Mail Code | CHAR(1) | NULLABLE | STRING | 1 |
includ | Include on Stmt Code | CHAR(1) | NULLABLE | STRING | 1 |
demstu | Demand/Student Loan Code | CHAR(1) | NULLABLE | STRING | 1 |
indcod | Standard Industry Code | DEC(4,0) | NULLABLE | INTEGER | 4 |
naicsc | NAICS Code | CHAR(6) | NULLABLE | STRING | 6 |
escpsq | Escrow posting sequence | DEC(1,0) | NULLABLE | INTEGER | 1 |
intpsq | Interest posting seq | DEC(1,0) | NULLABLE | INTEGER | 1 |
ltcpsq | Late chg posting seq | DEC(1,0) | NULLABLE | INTEGER | 1 |
othpsq | Other chg posting seq | DEC(1,0) | NULLABLE | INTEGER | 1 |
prnpsq | Principal posting seq | DEC(1,0) | NULLABLE | INTEGER | 1 |
inspsq | Insurance posting seq | DEC(1,0) | NULLABLE | INTEGER | 1 |
usebil | Use Billed Amounts | CHAR(1) | NULLABLE | STRING | 1 |
sendcd | Print Billing Notice | CHAR(1) | NULLABLE | STRING | 1 |
sendmt | Print Final Pay Notice | CHAR(1) | NULLABLE | STRING | 1 |
title | Title Still Needed Code | CHAR(1) | NULLABLE | STRING | 1 |
pnflag | Past Due Notice Code | DEC(1,0) | NULLABLE | INTEGER | 1 |
phflag | Past Due History Flag | CHAR(1) | NULLABLE | STRING | 1 |
sendpd | Send Past Due Notice | CHAR(1) | NULLABLE | STRING | 1 |
pdcode | On Past Due Report | CHAR(1) | NULLABLE | STRING | 1 |
lctype | Late Charge Type | CHAR(3) | NULLABLE | STRING | 3 |
ignlcp | Ignore L/C - O/C Posting Sequence | CHAR(1) | NULLABLE | STRING | 1 |
typcls | Classification Type | CHAR(1) | NULLABLE | STRING | 1 |
ratcod | Credit Rating Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
census | Census Tract 1 | DEC(7,2) | NULLABLE | FLOAT | 7.2 |
smsa | SMSA Number | DEC(5,0) | NULLABLE | INTEGER | 5 |
craloc | CRA Location | DEC(9,0) | NULLABLE | INTEGER | 9 |
state | State Code | CHAR(2) | NULLABLE | STRING | 2 |
crasta | CRA State Code | DEC(2,0) | NULLABLE | INTEGER | 2 |
county | County Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
vin_num_ | Vehicle ID No. | CHAR(30) | NULLABLE | STRING | 30 |
msg | Special Message Flag | CHAR(1) | NULLABLE | STRING | 1 |
renext | Renewed/Extended This Mo | CHAR(1) | NULLABLE | STRING | 1 |
user1 | User Code Number 1 | CHAR(2) | NULLABLE | STRING | 2 |
user2 | User Code Number 2 | CHAR(1) | NULLABLE | STRING | 1 |
escrow | Escrow/Mortgage Info? | CHAR(1) | NULLABLE | STRING | 1 |
clszro | Close On Zero Bal Code | CHAR(1) | NULLABLE | STRING | 1 |
coupon | Print Coupon Book Flag | CHAR(1) | NULLABLE | STRING | 1 |
cpntrm | Coupon Book Term | DEC(3,0) | NULLABLE | INTEGER | 3 |
hasarm | A.R.M. Info Code | CHAR(1) | NULLABLE | STRING | 1 |
almtyp | ALM Type | CHAR(1) | NULLABLE | STRING | 1 |
prtpct | Participation Percent | DEC(17,16) | NULLABLE | FLOAT | 17.16 |
prprpc | Participation principal payment split percentage | DEC(17,16) | NULLABLE | FLOAT | 17.16 |
prinpc | Participation interest payment split percentage | DEC(17,16) | NULLABLE | FLOAT | 17.16 |
prtsq_num_ | Participation sequence number | DEC(5,0) | NULLABLE | INTEGER | 5 |
prtpms | Participation payment split option | CHAR(1) | NULLABLE | STRING | 1 |
prt1pm | Participation 1st payment interest option | CHAR(1) | NULLABLE | STRING | 1 |
fndsq_num_ | Participation funding sequence | DEC(5,0) | NULLABLE | INTEGER | 5 |
fndlmt | Participation funding limit | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
fndpct | Participation funding percentage | DEC(17,16) | NULLABLE | FLOAT | 17.16 |
pcacc_num_ | Part/Chg off Acct Num | DEC(16,0) | NULLABLE | INTEGER | 16 |
pcactp | Part/Chg off Acct Type | CHAR(1) | NULLABLE | STRING | 1 |
clacc_num_ | Cr Line Number | DEC(16,0) | NULLABLE | INTEGER | 16 |
taxref | Cr Line Tax Reference # | CHAR(20) | NULLABLE | STRING | 20 |
rlacc_num_ | Related Acct Num | DEC(16,0) | NULLABLE | INTEGER | 16 |
rlactp | Related Acct Type | CHAR(1) | NULLABLE | STRING | 1 |
hdacc_num_ | Hold account number | DEC(16,0) | NULLABLE | INTEGER | 16 |
hdactp | Hold account type | CHAR(1) | NULLABLE | STRING | 1 |
rewln_num_ | Rewrite to Loan # | DEC(16,0) | NULLABLE | INTEGER | 16 |
rq1098 | Requires 1098 | CHAR(1) | NULLABLE | STRING | 1 |
stmpas | Stmt or Passbook code | CHAR(1) | NULLABLE | STRING | 1 |
matgrc | Maturity Grace Days | DEC(3,0) | NULLABLE | INTEGER | 3 |
wchcod | Watch list Code | CHAR(1) | NULLABLE | STRING | 1 |
pppcod | Prepayment Penalty Code | CHAR(3) | NULLABLE | STRING | 3 |
flinrq | Flood Ins. Required? | CHAR(1) | NULLABLE | STRING | 1 |
brwpd | BORROWER PAID DIRECTLY | CHAR(1) | NULLABLE | STRING | 1 |
rstruc | Restructured Flag | CHAR(1) | NULLABLE | STRING | 1 |
secure | Account Level Security | CHAR(1) | NULLABLE | STRING | 1 |
lnpic1 | Programmer Use #1 | CHAR(2) | NULLABLE | STRING | 2 |
lnpic2 | Programmer Use #2 | CHAR(2) | NULLABLE | STRING | 2 |
lnpic3 | Programmer Use #3 | CHAR(5) | NULLABLE | STRING | 5 |
lnpic4 | Programmer Use #4 | CHAR(5) | NULLABLE | STRING | 5 |
lnpic5 | Programmer Use #5 | CHAR(10) | NULLABLE | STRING | 10 |
lnpic6 | Programmer Use #6 | CHAR(10) | NULLABLE | STRING | 10 |
lnpic7 | Programmer Use #7 | CHAR(10) | NULLABLE | STRING | 10 |
lnpdt1 | Programmer DATE #1 | DEC(7,0) | NULLABLE | INTEGER | 7 |
lnpd61 | Programmer DATE #1 | DEC(6,0) | NULLABLE | INTEGER | 6 |
lnpdt2 | Programmer DATE #2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
lnpd62 | Programmer DATE #2 | DEC(6,0) | NULLABLE | INTEGER | 6 |
lnpam1 | Programmer AMT #1 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
lnpam2 | Programmer AMT #2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
lnpam3 | Programmer AMT #3 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
lnpam4 | Programmer AMT #4 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
lnpam5 | Programmer AMT #5 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
lnpam6 | Programmer AMT #6 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
lnpam7 | Programmer AMT #7 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
lnanic | Annual Interest Income | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ltvrat | Loan to value ratio | DEC(5,4) | NULLABLE | FLOAT | 5.4 |
cltvrt | Calculated PMI LTV Ratio | DEC(5,4) | NULLABLE | FLOAT | 5.4 |
slouts | Senior Lien Outsourced | CHAR(1) | NULLABLE | STRING | 1 |
oldmny | Old Money | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
newmny | New Money | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
dwnpmt | Down payment | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
xclstt | Exclude from auto nonaccr status | CHAR(1) | NULLABLE | STRING | 1 |
popend | Payoff pending flag | CHAR(1) | NULLABLE | STRING | 1 |
unpadv | Unpost advances if over credit limit | CHAR(1) | NULLABLE | STRING | 1 |
remtrm | Remaining Term | DEC(3,0) | NULLABLE | INTEGER | 3 |
cramil | MILITARY CODE | DEC(1,0) | NULLABLE | INTEGER | 1 |
scracod | SCRA Send Code | CHAR(1) | NULLABLE | STRING | 1 |
scrabdate | SCRA Begin Date YYYYDDD | DEC(7,0) | NULLABLE | INTEGER | 7 |
scrabdat6 | SCRA Begin Date MMDDYY | DEC(6,0) | NULLABLE | INTEGER | 6 |
scraedate | SCRA End Date YYYYDDD | DEC(7,0) | NULLABLE | INTEGER | 7 |
scraedat6 | SCRA End Date MMDDYY | DEC(6,0) | NULLABLE | INTEGER | 6 |
lnspcc | C/B Special Comment Code | CHAR(2) | NULLABLE | STRING | 2 |
cbc10 | Credit Bureau Past 10-29 | DEC(3,0) | NULLABLE | INTEGER | 3 |
cbc30 | Credit Bureau Past 30-59 | DEC(3,0) | NULLABLE | INTEGER | 3 |
cbc60 | Credit Bureau Past 60-89 | DEC(3,0) | NULLABLE | INTEGER | 3 |
cbc90 | Credit Bureau Past 90 + | DEC(3,0) | NULLABLE | INTEGER | 3 |
stm_num_ac | Unit Priced # of accts | DEC(7,0) | NULLABLE | INTEGER | 7 |
rstadv | Restrict Auto advances | CHAR(1) | NULLABLE | STRING | 1 |
rstpmt | Restrict Auto payments | CHAR(1) | NULLABLE | STRING | 1 |
lnmchk | Minimum Check Advance | DEC(9,0) | NULLABLE | INTEGER | 9 |
lnregh | Reg H Code | CHAR(4) | NULLABLE | STRING | 4 |
lnsenl | Senior Lien | DEC(11,0) | NULLABLE | INTEGER | 11 |
badck_num_ | Number of bad checks | DEC(3,0) | NULLABLE | INTEGER | 3 |
hirisk | High Risk Customer | CHAR(1) | NULLABLE | STRING | 1 |
lnregp | Privacy Act opt out | CHAR(1) | NULLABLE | STRING | 1 |
receit | Receipt Y/N | CHAR(1) | NULLABLE | STRING | 1 |
dlorat | Delinquent Org. Rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
negpct | Negative Amort. percent cap | DEC(3,0) | NULLABLE | INTEGER | 3 |
nsffee | Default NSF Fee | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
madvfe | Minimum Check Tolerance | DEC(9,0) | NULLABLE | INTEGER | 9 |
defint | Deferred Interest | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ptdint | Paid to Deferred Int | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
usrsts | Loan User Status Code | CHAR(3) | NULLABLE | STRING | 3 |
stpadv | Stop advances | CHAR(1) | NULLABLE | STRING | 1 |
stpad6 | Stop advances Expiration date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stpad7 | Stop advances Expiration date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stppmt | Stop payments | CHAR(1) | NULLABLE | STRING | 1 |
stppm6 | Stop payments Expiration date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stppm7 | Stop payments Expiration date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stptax | Stop tax disbursements | CHAR(1) | NULLABLE | STRING | 1 |
stptx6 | Stop tax disb Expiration date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stptx7 | Stop tax disb Expiration date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stphzd | Stop hazard disbursements | CHAR(1) | NULLABLE | STRING | 1 |
stphz6 | Stop hazard disb Exp. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stphz7 | Stop hazard disb Exp. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stpopt | Stop optional insurance disb | CHAR(1) | NULLABLE | STRING | 1 |
stpop6 | Stop optional disb Exp. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stpop7 | Stop optional disb Exp. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stplns | Stop loan sale | CHAR(1) | NULLABLE | STRING | 1 |
stpls6 | Stop loan sale Exp. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stpls7 | Stop loan sale Exp. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stpnot | Stop notices | CHAR(1) | NULLABLE | STRING | 1 |
stpnt6 | Stop Notices Exp. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stpnt7 | Stop Notices Exp. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stpcrp | Stop credit reporting | CHAR(1) | NULLABLE | STRING | 1 |
stpcr6 | Stop Cred Rpt Exp. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stpcr7 | Stop Cred Rpt Exp. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stpprp | Stop prepayments | CHAR(1) | NULLABLE | STRING | 1 |
stppr6 | Stop prepayments Exp. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stppr7 | Stop prepayments Exp. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stpacr | Stop accrual | CHAR(1) | NULLABLE | STRING | 1 |
stpac6 | Stop accrual Exp. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stpac7 | Stop accrual Exp. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stpcor | Stop correspondence | CHAR(1) | NULLABLE | STRING | 1 |
stpco6 | Stop corresp Exp. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stpco7 | Stop corresp Exp. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stpirs | Stop IRS reporting | CHAR(1) | NULLABLE | STRING | 1 |
stpir6 | Stop IRS Rpt Exp. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stpir7 | Stop IRS Rpt Exp. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stpstm | Stop statments | CHAR(1) | NULLABLE | STRING | 1 |
stpst6 | Stop statement Exp. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stpst7 | Stop statement Exp. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stpcou | Stop coupon generation | CHAR(1) | NULLABLE | STRING | 1 |
stpcp6 | Stop coupon Exp. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stpcp7 | Stop coupon Exp. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stpesd | Stop all escrow disbursements | CHAR(1) | NULLABLE | STRING | 1 |
stped6 | Stop Esc Disb Exp. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stped7 | Stop Esc Disb Exp. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stpesa | Stop escrow analysis | CHAR(1) | NULLABLE | STRING | 1 |
stpea6 | Stop Esc Anal Exp. Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stpea7 | Stop Esc Anal Exp. Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
stppdp | Stop past due reporting | CHAR(1) | NULLABLE | STRING | 1 |
stppd6 | Stop past due rpt Exp Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
stppd7 | Stop past due rpt Exp Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
pstshr | Post Short Payment | CHAR(1) | NULLABLE | STRING | 1 |
useuna | Use Payment Suspense | CHAR(1) | NULLABLE | STRING | 1 |
howuna | How to Post Payment Suspense | CHAR(1) | NULLABLE | STRING | 1 |
dlrloc | Dealer Location | DEC(7,0) | NULLABLE | INTEGER | 7 |
dlrtyp | Dealer Type | DEC(2,0) | NULLABLE | INTEGER | 2 |
dlrfdp | Forfeit after days/pmts | CHAR(1) | NULLABLE | STRING | 1 |
dlrfdpc | Forfeit after days/pmts charge-off | CHAR(1) | NULLABLE | STRING | 1 |
cdlrfor | FORFEIT U/F DLR DISC/REB | CHAR(1) | NULLABLE | STRING | 1 |
cdlrdys | # OF DAYS FORFEIT REBATE | DEC(3,0) | NULLABLE | INTEGER | 3 |
cdlrpmt | # OF PMTS FORFEIT REBATE | DEC(3,0) | NULLABLE | INTEGER | 3 |
cdlrpdd | CHG-OFF Percent | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
recrscd | Recourse Code | CHAR(1) | NULLABLE | STRING | 1 |
recrspc | Recourse Percent | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
recrstm | Recourse Term | DEC(3,0) | NULLABLE | INTEGER | 3 |
recrstc | Recourse Term Code | CHAR(1) | NULLABLE | STRING | 1 |
recdayp | Days Past Due Recourse | DEC(4,0) | NULLABLE | INTEGER | 4 |
recint | Recourse Interest | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
partid_num_ | Participation ID number | DEC(7,0) | NULLABLE | INTEGER | 7 |
pnflags | Past Due Notice Code | DEC(1,0) | NULLABLE | INTEGER | 1 |
payex6 | Payoff Pending Expiration Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
payex7 | Payoff Pending Expiration Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
cpd120 | Times Past Due 120-149 | DEC(3,0) | NULLABLE | INTEGER | 3 |
cpd150 | Times Past Due 150-179 | DEC(3,0) | NULLABLE | INTEGER | 3 |
cpd180 | Times Past Due 180 + | DEC(3,0) | NULLABLE | INTEGER | 3 |
ppd120 | Last Year Past Due 120-149 | DEC(3,0) | NULLABLE | INTEGER | 3 |
ppd150 | Last Year Past Due 150-179 | DEC(3,0) | NULLABLE | INTEGER | 3 |
ppd180 | Last Year Past Due 180 + | DEC(3,0) | NULLABLE | INTEGER | 3 |
lpd120 | Life Time Past Due 120-149 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lpd150 | Life Time Past Due 150-179 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lpd180 | Life Time Past Due 180 + | DEC(3,0) | NULLABLE | INTEGER | 3 |
pctrea | % of Balance to Re-am | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
partpc | Participation Percentage | DEC(17,16) | NULLABLE | FLOAT | 17.16 |
bilola | Billed Overline Principal | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ytdpen | YTD Prepayment Penalty | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
prepen | Prepayment Penalty Last Year | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
ltdpen | Prepayment Penalty Life to Date | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
subprm | Sub-Prime Lending | CHAR(1) | NULLABLE | STRING | 1 |
ovlfee | Default Overline Fee | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
clcif_num_ | Credit Line CIF Number | CHAR(7) | NULLABLE | STRING | 7 |
adotnb | Add Overline Fee to the next bill | CHAR(1) | NULLABLE | STRING | 1 |
untpdlrfp | Unit Priced Reporting Method | CHAR(1) | NULLABLE | STRING | 1 |
minuntadv | Minimum Unit Priced Advance | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
syndagtnbr | Syndication Agent Number | DEC(7,0) | NULLABLE | INTEGER | 7 |
syndmbrnbr | Syndication Member Number | DEC(7,0) | NULLABLE | INTEGER | 7 |
shrntlcrd | Shared National Credit | CHAR(1) | NULLABLE | STRING | 1 |
corresbank | Correspondent Bank | CHAR(1) | NULLABLE | STRING | 1 |
crcytype | Currency Type | CHAR(2) | NULLABLE | STRING | 2 |
frdalrt | Fraud Alert | CHAR(1) | NULLABLE | STRING | 1 |
argprdcod | ARGO PRODUCT TYPE | CHAR(3) | NULLABLE | STRING | 3 |
constr | CONSTRUCTION LOAN TRACKING | CHAR(1) | NULLABLE | STRING | 1 |
rgrisk | REGULATORY RISK WEIGHT | DEC(3,0) | NULLABLE | INTEGER | 3 |
teaser | REGULATORY TEASER RATE APPLIES | CHAR(1) | NULLABLE | STRING | 1 |
cspltv | Calculated Supervisory LTV Ratio | DEC(5,4) | NULLABLE | FLOAT | 5.4 |
exsltv | Exclude From Supervisory LTV | DEC(2,0) | NULLABLE | INTEGER | 2 |
exrelp | Exception to RE Lending Policy | DEC(2,0) | NULLABLE | INTEGER | 2 |
lnatmcrd | ATM Card Access | CHAR(1) | NULLABLE | STRING | 1 |
hmda | HMDA REQUIRED Y/N | CHAR(1) | NULLABLE | STRING | 1 |
salesac | Sales Associate | CHAR(15) | NULLABLE | STRING | 15 |
rtcctr | Right to Cure Counter | DEC(3,0) | NULLABLE | INTEGER | 3 |
affiliate | Affiliate Loan Y/N | CHAR(1) | NULLABLE | STRING | 1 |
minbil | Min amt to create bill | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
intfir | Interest first product | CHAR(1) | NULLABLE | STRING | 1 |
steprt | Step Rate Loan Y/N | CHAR(1) | NULLABLE | STRING | 1 |
lnlang | Language Code | CHAR(3) | NULLABLE | STRING | 3 |
appdlns | Apply payments to past due loans | CHAR(1) | NULLABLE | STRING | 1 |
nbrpdpmt | Number of payments past due to trigger | DEC(3,0) | NULLABLE | INTEGER | 3 |
apppdlns | Apply payments to pre-paid loans | CHAR(1) | NULLABLE | STRING | 1 |
npdapplt | Number, percent or dollar amount to trigger | DEC(9,0) | NULLABLE | INTEGER | 9 |
npdppltr | Number, percent or dollar to trigger | CHAR(1) | NULLABLE | STRING | 1 |
postexpc | Post excess as a Principal Curtailment | CHAR(1) | NULLABLE | STRING | 1 |
shdow6 | Shadow Processing Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
shdow7 | Shadow Processing Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
rshtpc6 | Roll Short on Pcode 6 | CHAR(1) | NULLABLE | STRING | 1 |
odibas | Accrue Odd Days at 365 Ibase | CHAR(1) | NULLABLE | STRING | 1 |
mtdadv_num_ | Number MTD Advances | DEC(3,0) | NULLABLE | INTEGER | 3 |
yrlcalc | Yearly Fee Calc Code | CHAR(3) | NULLABLE | STRING | 3 |
loccalc | LOC Fee Calc Code | CHAR(3) | NULLABLE | STRING | 3 |
locfreq | LOC Fee Frequency | DEC(3,0) | NULLABLE | INTEGER | 3 |
locfrcd | LOC Fee Freq Code | CHAR(1) | NULLABLE | STRING | 1 |
locfdt6 | LOC Fee Date 6 | DEC(6,0) | NULLABLE | INTEGER | 6 |
locfdt7 | LOC Fee Date 7 | DEC(7,0) | NULLABLE | INTEGER | 7 |
locfdy | LOC Fee Freq Day | DEC(2,0) | NULLABLE | INTEGER | 2 |
unucalc | Unused Line Calc Code | CHAR(3) | NULLABLE | STRING | 3 |
unufreq | Unused Line Frequency | DEC(3,0) | NULLABLE | INTEGER | 3 |
unufrcd | Unused Line Freq Code | CHAR(1) | NULLABLE | STRING | 1 |
unufdt6 | Unused Line Date 6 | DEC(6,0) | NULLABLE | INTEGER | 6 |
unufdt7 | Unused Line Date 7 | DEC(7,0) | NULLABLE | INTEGER | 7 |
unufdy | Unused Line Freq Day | DEC(2,0) | NULLABLE | INTEGER | 2 |
_num_dyszrocur | Cur Month Days Paid Zero | DEC(2,0) | NULLABLE | INTEGER | 2 |
_num_dyszro01 | January Days Paid Zero | DEC(2,0) | NULLABLE | INTEGER | 2 |
_num_dyszro02 | Febuary Days Paid Zero | DEC(2,0) | NULLABLE | INTEGER | 2 |
_num_dyszro03 | March Days Paid Zero | DEC(2,0) | NULLABLE | INTEGER | 2 |
_num_dyszro04 | April Days Paid Zero | DEC(2,0) | NULLABLE | INTEGER | 2 |
_num_dyszro05 | May Days Paid Zero | DEC(2,0) | NULLABLE | INTEGER | 2 |
_num_dyszro06 | June Days Paid Zero | DEC(2,0) | NULLABLE | INTEGER | 2 |
_num_dyszro07 | July Days Paid Zero | DEC(2,0) | NULLABLE | INTEGER | 2 |
_num_dyszro08 | August Days Paid Zero | DEC(2,0) | NULLABLE | INTEGER | 2 |
_num_dyszro09 | September Days Paid Zero | DEC(2,0) | NULLABLE | INTEGER | 2 |
_num_dyszro10 | October Days Paid Zero | DEC(2,0) | NULLABLE | INTEGER | 2 |
_num_dyszro11 | November Days Paid Zero | DEC(2,0) | NULLABLE | INTEGER | 2 |
_num_dyszro12 | December Days Paid Zero | DEC(2,0) | NULLABLE | INTEGER | 2 |
lptype | Curtailment/ Recoupment Penalty Type | DEC(3,0) | NULLABLE | INTEGER | 3 |
cpassln | Pass curtailment to sold loan | CHAR(1) | NULLABLE | STRING | 1 |
rpassln | Pass recoupment to sold loan | CHAR(1) | NULLABLE | STRING | 1 |
rpasspct | Recoupment percentage to pass to sold loan | DEC(6,5) | NULLABLE | FLOAT | 6.5 |
ppsdt6 | Curtailment Start Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
ppsdt7 | Curtailment Start Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
ppsfrq | Curtailment Start Frequency | DEC(3,0) | NULLABLE | INTEGER | 3 |
ppscod | Curtailment Start Frequency Code | CHAR(1) | NULLABLE | STRING | 1 |
ppdbal | Beginning Decl Penalty Balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ppcurt | Total Curtailments | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ppexp6 | Curtailment Expire Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
ppexp7 | Curtailment Expire Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
curntc6 | Notice of Curtailment Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
curntc7 | Notice of Curtailment Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
curexp6 | Curtailment Notice Expire Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
curexp7 | Curtailment Notice Expire Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
curall6 | Curtailment Allowable Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
curall7 | Curtailment Allowable Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
invall6 | Investor Allowable Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
invall7 | Investor Allowable Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
recoupasd | Recoupment Fee Assessed this Period | CHAR(1) | NULLABLE | STRING | 1 |
recoupytd | Recoupment Fee Paid YTD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
recouppre | Recoupment Fee Paid Prev YTD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
nsfntcytd | Insufficient Notice Fee Paid YTD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
nsfntcpre | Insufficient Notice Fee Prev YTD | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
paycurt | Payoff curtailment amount | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
paycoup | Payoff recoupment amount | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
recprndt6 | Recoupment renewal date | DEC(6,0) | NULLABLE | INTEGER | 6 |
recprndt7 | Recoupment renewal date | DEC(7,0) | NULLABLE | INTEGER | 7 |
curtamt1 | Curtlmnt P/O penalty amt | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
curtamt2 | Recoup P/O penalty amt | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
datepen16 | Penalty Date 1 | DEC(6,0) | NULLABLE | INTEGER | 6 |
datepen17 | Penalty Date 1 | DEC(7,0) | NULLABLE | INTEGER | 7 |
datepen26 | Penalty Date 2 | DEC(6,0) | NULLABLE | INTEGER | 6 |
datepen27 | Penalty Date 2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
lntier | Tiered Rate Type? | CHAR(1) | NULLABLE | STRING | 1 |
lqbl_num_2 | Balance tier 2 | DEC(11,0) | NULLABLE | INTEGER | 11 |
lqrt_num_2 | Rate number tier 2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lqbl_num_3 | Balance tier 3 | DEC(11,0) | NULLABLE | INTEGER | 11 |
lqrt_num_3 | Rate number tier 3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lqbl_num_4 | Balance tier 4 | DEC(11,0) | NULLABLE | INTEGER | 11 |
lqrt_num_4 | Rate number tier 4 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lqbl_num_5 | Balance tier 5 | DEC(11,0) | NULLABLE | INTEGER | 11 |
lqrt_num_5 | Rate number tier 5 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lqbl_num_6 | Balance tier 6 | DEC(11,0) | NULLABLE | INTEGER | 11 |
lqrt_num_6 | Rate number tier 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lqbl_num_7 | Balance tier 7 | DEC(11,0) | NULLABLE | INTEGER | 11 |
lqrt_num_7 | Rate number tier 7 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lqbl_num_8 | Balance tier 8 | DEC(11,0) | NULLABLE | INTEGER | 11 |
lqrt_num_8 | Rate number tier 8 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lqbl_num_9 | Balance tier 9 | DEC(11,0) | NULLABLE | INTEGER | 11 |
lqrt_num_9 | Rate number tier 9 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lqbl_num_10 | Balance tier 10 | DEC(11,0) | NULLABLE | INTEGER | 11 |
lqrt_num_10 | Rate number tier 10 | DEC(3,0) | NULLABLE | INTEGER | 3 |
lsplit | Calc split rate accruals | CHAR(1) | NULLABLE | STRING | 1 |
lienposn | Lien Position | DEC(1,0) | NULLABLE | INTEGER | 1 |
odpusehold | Use DDA Hold For ODP Xfer | CHAR(1) | NULLABLE | STRING | 1 |
penrat_num_ | Penalty APR number | DEC(3,0) | NULLABLE | INTEGER | 3 |
pennewrt | Penalty APR will be | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
penrate | Penalty APR | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
penpdays | Days past due to send penalty APR notice | DEC(3,0) | NULLABLE | INTEGER | 3 |
penaftnt | Days after notice penalty APR begins | DEC(2,0) | NULLABLE | INTEGER | 2 |
penrvtm | Penalty APR review term | DEC(3,0) | NULLABLE | INTEGER | 3 |
penrvtmc | Penalty APR review term code | CHAR(1) | NULLABLE | STRING | 1 |
pennotd6 | Penalty notice date | DEC(6,0) | NULLABLE | INTEGER | 6 |
pennotd7 | Penalty notice date | DEC(7,0) | NULLABLE | INTEGER | 7 |
penstdt6 | Penalty APR start date | DEC(6,0) | NULLABLE | INTEGER | 6 |
penstdt7 | Penalty APR start date | DEC(7,0) | NULLABLE | INTEGER | 7 |
penrvdt6 | Penalty APR review date | DEC(6,0) | NULLABLE | INTEGER | 6 |
penrvdt7 | Penalty APR review date | DEC(7,0) | NULLABLE | INTEGER | 7 |
penratyn | Penalty APR in effect | CHAR(1) | NULLABLE | STRING | 1 |
penlnrate | Loan APR at penalty end | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
ppvari | Part Rate Variance | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
ppvcode | Part Rate Variance Code | CHAR(1) | NULLABLE | STRING | 1 |
speclen | Specialty Lending | CHAR(1) | NULLABLE | STRING | 1 |
tsamt1 | Tech Serv amount 1 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
tsamt2 | Tech Serv amount 2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
tsdate1 | Tech Serv Date 1 | DEC(7,0) | NULLABLE | INTEGER | 7 |
tsdate2 | Tech Serv Date 2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
ts1char1 | Tech Serv misc code 1 | CHAR(1) | NULLABLE | STRING | 1 |
ts1char2 | Tech Serv misc code 2 | CHAR(1) | NULLABLE | STRING | 1 |
ts2char3 | Tech Serv misc code 3 | CHAR(2) | NULLABLE | STRING | 2 |
ts2char4 | Tech Serv misc code 4 | CHAR(2) | NULLABLE | STRING | 2 |
prmrskrat | Primary Risk Rating | CHAR(3) | NULLABLE | STRING | 3 |
rskratdt6 | Risk Rating Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
rskratdt7 | Risk Rating Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
splrskrat1 | Split Risk Rating 1 | CHAR(3) | NULLABLE | STRING | 3 |
splrskamt1 | Split Risk Rating 1 Established Position | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
splrskrat2 | Split Risk Rating 2 | CHAR(3) | NULLABLE | STRING | 3 |
splrskpct2 | Split Risk Rating 2 Percent | DEC(2,0) | NULLABLE | INTEGER | 2 |
splrskamt2 | Split Risk Rating 2 Amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
splrskrat3 | Split Risk Rating 3 | CHAR(3) | NULLABLE | STRING | 3 |
splrskpct3 | Split Risk Rating 3 Percent | DEC(2,0) | NULLABLE | INTEGER | 2 |
splrskamt3 | Split Risk Rating 3 Amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
splrskca1 | Split Risk Rating 1 Calculated Position | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ngamorg_mon_ | Negative am org. balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
autobil | Print Auto Pay Message | CHAR(1) | NULLABLE | STRING | 1 |
ytdesc | Escrow Paid YTD | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
prvesc | Escrow Paid Last year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
ytdfee | Fees Paid YTD | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
prvfee | Fees Paid Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
prvprn | Principal Paid Last Year | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
pridwe | Principal dwelling | CHAR(1) | NULLABLE | STRING | 1 |
armntc | ARM Notice type | CHAR(1) | NULLABLE | STRING | 1 |
inarmd | Days before rate change to send initial notice | DEC(3,0) | NULLABLE | INTEGER | 3 |
armsnt | Initial ARM notice sent | CHAR(1) | NULLABLE | STRING | 1 |
eindt6 | Early Intervention Notice Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
eindt7 | Early Intervention Notice Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
Last updated Thu Dec 12 2024