Developer Programs

Learn

Docs

lnmast_raw

Core Schemas > Silverlake > lnmast_raw
Column nameDescriptionModeTypeLength
__opContains the operation type. Values are I for insert, U for update, D for delete.REQUIREDSTRING
__op_tsoperation timestamp added by export codeREQUIREDTIMESTAMP
__uidThe Unique ID of this entry. Data, UUID, or GUIDREQUIREDSTRING
__verMapping and Schema VersionREQUIREDINTEGER
br_num_Branch Number | DEC(3,0)NULLABLEINTEGER3
acctnoAccount Number | DEC(16,0)NULLABLEINTEGER16
actypeAccount Type | CHAR(1)NULLABLESTRING1
snameShort Name | CHAR(20)NULLABLESTRING20
cifnoCIF Number | CHAR(7)NULLABLESTRING7
altaddAlternate Address Code | CHAR(1)NULLABLESTRING1
addnamAdditional Names Code | CHAR(1)NULLABLESTRING1
altnamAlternate Names Code | CHAR(1)NULLABLESTRING1
offcrOfficer | CHAR(6)NULLABLESTRING6
coffcrOfficer | CHAR(6)NULLABLESTRING6
statusStatus | DEC(1,0)NULLABLEINTEGER1
prvstsPrevious Status | DEC(1,0)NULLABLEINTEGER1
classClass Code | CHAR(1)NULLABLESTRING1
typeLoan Type | CHAR(2)NULLABLESTRING2
orgamtOriginal Balance | DEC(13,2)NULLABLEFLOAT13.2
cbalCurrent Balance | DEC(13,2)NULLABLEFLOAT13.2
acbalAccrual Balance | DEC(13,2)NULLABLEFLOAT13.2
qrybalQuery Balance | DEC(13,2)NULLABLEFLOAT13.2
sldbalSold Balances | DEC(13,2)NULLABLEFLOAT13.2
accintAccrued Interest | DEC(15,5)NULLABLEFLOAT15.5
accin2Secondary Accrued Int | DEC(15,5)NULLABLEFLOAT15.5
dlraccM-T-D Dealer Accrued Int | DEC(11,5)NULLABLEFLOAT11.5
pdiemDaily Accrual | DEC(13,5)NULLABLEFLOAT13.5
bkdiscBank Discount | DEC(9,2)NULLABLEFLOAT9.2
dlrdscDealer Discount | DEC(9,2)NULLABLEFLOAT9.2
othchgOther Charges | DEC(11,2)NULLABLEFLOAT11.2
asslcAssessed Late Charges | DEC(11,2)NULLABLEFLOAT11.2
paidlcPaid Late Charges | DEC(11,2)NULLABLEFLOAT11.2
mincgMinimum Charge | DEC(5,2)NULLABLEFLOAT5.2
curpoCurrent Month Payoff | DEC(13,2)NULLABLEFLOAT13.2
nxtpoNext Month Payoff | DEC(13,2)NULLABLEFLOAT13.2
intrebInterest Rebate | DEC(9,2)NULLABLEFLOAT9.2
dlrrebDealer Rebate | DEC(9,2)NULLABLEFLOAT9.2
pmtamtPayment Amount | DEC(11,2)NULLABLEFLOAT11.2
piamtPrinc & int pmt amt | DEC(11,2)NULLABLEFLOAT11.2
lstpmtLast Pymt Amount | DEC(11,2)NULLABLEFLOAT11.2
prtpmtPartial Pymt Amt | DEC(11,2)NULLABLEFLOAT11.2
bilprnBilled Prin Amt | DEC(13,2)NULLABLEFLOAT13.2
bilintBilled Int Amt | DEC(11,2)NULLABLEFLOAT11.2
bilescBilled Escrow Amt | DEC(9,2)NULLABLEFLOAT9.2
billcBilled Late Chgs | DEC(9,2)NULLABLEFLOAT9.2
bilocBilled Other Chgs | DEC(11,2)NULLABLEFLOAT11.2
bilclBilled Credit Life | DEC(11,2)NULLABLEFLOAT11.2
bilahBilled A&H Insurance | DEC(11,2)NULLABLEFLOAT11.2
bilunBilled Unemployment | DEC(11,2)NULLABLEFLOAT11.2
eoldpmOld Payment Amount | DEC(11,2)NULLABLEFLOAT11.2
oldpiOld P&I amount | DEC(11,2)NULLABLEFLOAT11.2
oldepmOld Escrow pmt amt | DEC(11,2)NULLABLEFLOAT11.2
newpmtNew Payment Amount | DEC(11,2)NULLABLEFLOAT11.2
newpiNew P&I Pmt Amount | DEC(11,2)NULLABLEFLOAT11.2
amrsusAmortized Pymt Suspense | DEC(9,2)NULLABLEFLOAT9.2
subamtSubsidy amount in effect | DEC(13,2)NULLABLEFLOAT13.2
subremSubsidy balance remaining | DEC(13,2)NULLABLEFLOAT13.2
amrintOne Mo Int On Amort Loan | DEC(11,2)NULLABLEFLOAT11.2
apramtAppraised Value | DEC(9,0)NULLABLEINTEGER9
anincmAnnual Income | DEC(11,2)NULLABLEFLOAT11.2
preaccAccrued Int at Year End | DEC(11,2)NULLABLEFLOAT11.2
predscInt Rebate at Year End | DEC(9,2)NULLABLEFLOAT9.2
yscbalYesterday Balance | DEC(13,2)NULLABLEFLOAT13.2
ysacciYesterdays Accrued | DEC(15,5)NULLABLEFLOAT15.5
ysirebYesterdays Int rebate | DEC(9,2)NULLABLEFLOAT9.2
ysdrebYesterday Dealer rebate | DEC(9,2)NULLABLEFLOAT9.2
ysothcYesterdays Other Chgs | DEC(11,2)NULLABLEFLOAT11.2
intodyInterest Paid Today | DEC(9,2)NULLABLEFLOAT9.2
stmbalBalance Last Stmt | DEC(13,2)NULLABLEFLOAT13.2
renbalRenew/Ext Balance | DEC(13,2)NULLABLEFLOAT13.2
ballonBalloon Payment | DEC(11,2)NULLABLEFLOAT11.2
pacbalLast Accrual Balance | DEC(13,2)NULLABLEFLOAT13.2
chgoffCharge Off Amount | DEC(13,2)NULLABLEFLOAT13.2
pntpdPoints Paid | DEC(11,2)NULLABLEFLOAT11.2
lstadvLast Advance | DEC(11,2)NULLABLEFLOAT11.2
curtmnCurtailment | DEC(11,2)NULLABLEFLOAT11.2
accurtAccrual Curtailment this Period | DEC(13,2)NULLABLEFLOAT13.2
shcoprShadow charged off principal | DEC(13,2)NULLABLEFLOAT13.2
shcoinShadow charged off interest | DEC(13,2)NULLABLEFLOAT13.2
shiapShadow interest applied to principal | DEC(11,2)NULLABLEFLOAT11.2
shglprShadow GL principal balance | DEC(13,2)NULLABLEFLOAT13.2
shacciShadow accrued interest | DEC(15,5)NULLABLEFLOAT15.5
shcintShadow capitalized fees | DEC(11,2)NULLABLEFLOAT11.2
shcstsShadow Status | CHAR(1)NULLABLESTRING1
yrlfeeYearly fee | DEC(11,2)NULLABLEFLOAT11.2
minadvMinimum Advance | DEC(9,0)NULLABLEINTEGER9
lnuchgUnpaid Charges | DEC(11,2)NULLABLEFLOAT11.2
poamntPrin Collected At payoff | DEC(13,2)NULLABLEFLOAT13.2
orgadvOriginal advance Amount | DEC(11,2)NULLABLEFLOAT11.2
mtdadvMTD Advances | DEC(11,2)NULLABLEFLOAT11.2
mtdcurtMTD Curtailments | DEC(11,2)NULLABLEFLOAT11.2
mtdprinMTD Principal Payments | DEC(11,2)NULLABLEFLOAT11.2
mtdcapdrMTD Capitalization Debits | DEC(11,2)NULLABLEFLOAT11.2
mtdcapcrMTD Capitalization Credits | DEC(11,2)NULLABLEFLOAT11.2
orgdt6Original Loan Date | DEC(6,0)NULLABLEINTEGER6
matdt6Maturity Date | DEC(6,0)NULLABLEINTEGER6
datop6Date Entered | DEC(6,0)NULLABLEINTEGER6
nrevd6Next Review Date | DEC(6,0)NULLABLEINTEGER6
coexd6Collat Ins Expiration | DEC(6,0)NULLABLEINTEGER6
ucexd6UCC Expiration Date | DEC(6,0)NULLABLEINTEGER6
nspdt6Next Sched Pymt Date | DEC(6,0)NULLABLEINTEGER6
fpdt61st Pymt Date | DEC(6,0)NULLABLEINTEGER6
lpdt6Last Pymt Date | DEC(6,0)NULLABLEINTEGER6
npdt6Next Pymt Due Date | DEC(6,0)NULLABLEINTEGER6
npdayPymt Day of Month | DEC(2,0)NULLABLEINTEGER2
thrud6Pymt Good Thru Date | DEC(6,0)NULLABLEINTEGER6
pdtod6Int Paid to Date | DEC(6,0)NULLABLEINTEGER6
cured6Last Right to Cure Date | DEC(6,0)NULLABLEINTEGER6
curbd6Cure by Date | DEC(6,0)NULLABLEINTEGER6
rendt6Date Last Renewed | DEC(6,0)NULLABLEINTEGER6
renpd6Date Previous Renewal | DEC(6,0)NULLABLEINTEGER6
extdt6Last Extension Date | DEC(6,0)NULLABLEINTEGER6
extpd6Date Previous Extension | DEC(6,0)NULLABLEINTEGER6
examd6Examiner Class Date | DEC(6,0)NULLABLEINTEGER6
lfmdt6Last Maint Date | DEC(6,0)NULLABLEINTEGER6
orgmd6Original Maturity Date | DEC(6,0)NULLABLEINTEGER6
nwpmd6New P&I Effective Date | DEC(6,0)NULLABLEINTEGER6
nwesd6New escrow payment effective date | DEC(6,0)NULLABLEINTEGER6
nwead6New escrow pmt effective date after spread | DEC(6,0)NULLABLEINTEGER6
neand6Next escrow analysis date | DEC(6,0)NULLABLEINTEGER6
prevd6Rate Review Date | DEC(6,0)NULLABLEINTEGER6
stmdt6Date Last Statement | DEC(6,0)NULLABLEINTEGER6
cpndt6Coupon Book Reorder Date | DEC(6,0)NULLABLEINTEGER6
nacdt6Nonaccrual Date | DEC(6,0)NULLABLEINTEGER6
chgdt6Chg off Date | DEC(6,0)NULLABLEINTEGER6
wchdt6Date on Watch list | DEC(6,0)NULLABLEINTEGER6
prvdayRate Review Day | DEC(2,0)NULLABLEINTEGER2
appdt6Last Appraisal Date | DEC(6,0)NULLABLEINTEGER6
amrdt6Amortize Thru Date | DEC(6,0)NULLABLEINTEGER6
lstad6Last Advance Date | DEC(6,0)NULLABLEINTEGER6
lstcp6Last Coupon Order Date | DEC(6,0)NULLABLEINTEGER6
ecrdt6Rate Cap Review Date | DEC(6,0)NULLABLEINTEGER6
ecrdayRate Cap Review Day | DEC(2,0)NULLABLEINTEGER2
enwrd6New Rate Effective Date | DEC(6,0)NULLABLEINTEGER6
cvexp6Convertable Expiration date | DEC(6,0)NULLABLEINTEGER6
activ6Last Activity Date | DEC(6,0)NULLABLEINTEGER6
frcld6Foreclosure date | DEC(6,0)NULLABLEINTEGER6
reamd6Payment Reamortization date | DEC(6,0)NULLABLEINTEGER6
reamdayPayment Reamortization day of month | DEC(2,0)NULLABLEINTEGER2
dtpdo6Date paid off | DEC(6,0)NULLABLEINTEGER6
cnvdt6Conversion Date | DEC(6,0)NULLABLEINTEGER6
permfd6PERMANENT FINANCE DATE | DEC(6,0)NULLABLEINTEGER6
hecnv6Loan Conversion Date | DEC(6,0)NULLABLEINTEGER6
steprd6Step Rate End Date | DEC(6,0)NULLABLEINTEGER6
orgadvd6Date orig Advance | DEC(6,0)NULLABLEINTEGER6
repricd6Last Re-priced Date | DEC(6,0)NULLABLEINTEGER6
orgdtOriginal Loan Date | DEC(7,0)NULLABLEINTEGER7
matdtMaturity Date | DEC(7,0)NULLABLEINTEGER7
datopnDate Entered | DEC(7,0)NULLABLEINTEGER7
nrevdtNext Review Date | DEC(7,0)NULLABLEINTEGER7
coexdtCollat Ins Expiration | DEC(7,0)NULLABLEINTEGER7
ucexdtUCC Expiration Date | DEC(7,0)NULLABLEINTEGER7
nspdtNext Sched Pymt Date | DEC(7,0)NULLABLEINTEGER7
fpdt1st Pymt Date | DEC(7,0)NULLABLEINTEGER7
lpdtLast Pymt Date | DEC(7,0)NULLABLEINTEGER7
npdtNext Pymt Due Date | DEC(7,0)NULLABLEINTEGER7
thrudtPymt Good Thru Date | DEC(7,0)NULLABLEINTEGER7
pdtodtInt Paid to Date | DEC(7,0)NULLABLEINTEGER7
curedtLast Right to Cure Date | DEC(7,0)NULLABLEINTEGER7
curbdtCure by Date | DEC(7,0)NULLABLEINTEGER7
rendtDate Last Renewed | DEC(7,0)NULLABLEINTEGER7
renpdtDate Previous Renewal | DEC(7,0)NULLABLEINTEGER7
extdtLast Extension Date | DEC(7,0)NULLABLEINTEGER7
extpdtDate Previous Extension | DEC(7,0)NULLABLEINTEGER7
examdtExaminer Class Date | DEC(7,0)NULLABLEINTEGER7
lfmdtLast Maint Date | DEC(7,0)NULLABLEINTEGER7
orgmdtOriginal Maturity Date | DEC(7,0)NULLABLEINTEGER7
nwpmdtNew P&I Effective Date | DEC(7,0)NULLABLEINTEGER7
nwesdtNew escrow payment effective date | DEC(7,0)NULLABLEINTEGER7
nweadtNew escrow pmt effective date after spread | DEC(7,0)NULLABLEINTEGER7
neandtNext escrow analysis date | DEC(7,0)NULLABLEINTEGER7
prevdtRate Review Date | DEC(7,0)NULLABLEINTEGER7
stmdtDate Last Statement | DEC(7,0)NULLABLEINTEGER7
cpndtCoupon Book Reorder Date | DEC(7,0)NULLABLEINTEGER7
nacdtNonaccrual Date | DEC(7,0)NULLABLEINTEGER7
chgdtChg off Date | DEC(7,0)NULLABLEINTEGER7
wchdtDate on Watch list | DEC(7,0)NULLABLEINTEGER7
appdt7Last Appraisal Date | DEC(7,0)NULLABLEINTEGER7
amrdt7Amortize Thru Date | DEC(7,0)NULLABLEINTEGER7
lstad7Last Advance Date | DEC(7,0)NULLABLEINTEGER7
lstcp7Last Coupon Order Date | DEC(7,0)NULLABLEINTEGER7
ecrdtRate Cap Review Date | DEC(7,0)NULLABLEINTEGER7
enwrdtNew Rate Effective Date | DEC(7,0)NULLABLEINTEGER7
cvexp7Convertable Expiration date | DEC(7,0)NULLABLEINTEGER7
activ7Last Activity Date | DEC(7,0)NULLABLEINTEGER7
frcld7Foreclosure date | DEC(7,0)NULLABLEINTEGER7
reamd7Payment Reamortization date | DEC(7,0)NULLABLEINTEGER7
dtpdo7Date paid off | DEC(7,0)NULLABLEINTEGER7
cnvdt7Conversion Date | DEC(7,0)NULLABLEINTEGER7
permfd7PERMANENT FINANCE DATE | DEC(7,0)NULLABLEINTEGER7
hecnv7Loan Conversion Date | DEC(7,0)NULLABLEINTEGER7
steprdtStep Rate End Date | DEC(7,0)NULLABLEINTEGER7
orgadvd7Date orig Advance | DEC(7,0)NULLABLEINTEGER7
repricd7Last Re-priced Date | DEC(7,0)NULLABLEINTEGER7
rateNote Rate | DEC(9,8)NULLABLEFLOAT9.8
dlqrateDelinquent rate | DEC(9,8)NULLABLEFLOAT9.8
dlrateDealer Rate | DEC(9,8)NULLABLEFLOAT9.8
dlrupcUpfront percentage | DEC(9,8)NULLABLEFLOAT9.8
dlrrpcDealer Reserve Pct | DEC(9,8)NULLABLEFLOAT9.8
dlrdys# of days forfeit rebate | DEC(3,0)NULLABLEINTEGER3
dlrpmt# of pmts forfeit rebate | DEC(3,0)NULLABLEINTEGER3
dlrforForfeit U/F Dlr Disc/Reb | CHAR(1)NULLABLESTRING1
dlrbodU/F Remainder Bank/Dlr | CHAR(1)NULLABLESTRING1
dlrrsvDealer Reserve | DEC(11,2)NULLABLEFLOAT11.2
dlrbrsBank Reserve | DEC(11,2)NULLABLEFLOAT11.2
dlrernDealer Earnings | DEC(11,2)NULLABLEFLOAT11.2
dlrberBank Earnings | DEC(11,2)NULLABLEFLOAT11.2
dlruerUpfront Earnings | DEC(11,2)NULLABLEFLOAT11.2
dlrferForfeited Earnings | DEC(11,2)NULLABLEFLOAT11.2
ttlintTotal Interest | DEC(11,2)NULLABLEFLOAT11.2
matratMaturity Rate | DEC(9,8)NULLABLEFLOAT9.8
prate_num_Rate Number | DEC(3,0)NULLABLEINTEGER3
dlqrate_num_Delinquent Rate Number | DEC(3,0)NULLABLEINTEGER3
pvariRate Variance | DEC(9,8)NULLABLEFLOAT9.8
pvcodeRate Variance Code | CHAR(1)NULLABLESTRING1
dlqvariDelinquent rate variance | DEC(9,8)NULLABLEFLOAT9.8
dlqvcodeDelinquent rate variance code | CHAR(1)NULLABLESTRING1
dlqrtdysDelinquent rate days | DEC(3,0)NULLABLEINTEGER3
pfloorRate Floor | DEC(9,8)NULLABLEFLOAT9.8
pceilRate Ceiling | DEC(9,8)NULLABLEFLOAT9.8
prtermRate Review Term | DEC(3,0)NULLABLEINTEGER3
prcodeRate Review Term Code | CHAR(1)NULLABLESTRING1
ecapupRate Cap Upwards | DEC(9,8)NULLABLEFLOAT9.8
ecapdnRate Cap Downwards | DEC(9,8)NULLABLEFLOAT9.8
ecrtrmRate Cap Period | DEC(3,0)NULLABLEINTEGER3
ecrtcdRate Cap Period Code | CHAR(1)NULLABLESTRING1
ecryovRate Carryover | DEC(9,8)NULLABLEFLOAT9.8
ecryosRate Carryover Sign | CHAR(1)NULLABLESTRING1
ecrnovNew Rate Carryover | DEC(9,8)NULLABLEFLOAT9.8
ecrnosNew Carryover Sign | CHAR(1)NULLABLESTRING1
ecrpovPrevious Rate Carryover | DEC(9,8)NULLABLEFLOAT9.8
ecrposPrevious Carryover Sign | CHAR(1)NULLABLESTRING1
ecryouUse Rate Carryover | CHAR(1)NULLABLESTRING1
ermethRounding Method | CHAR(1)NULLABLESTRING1
eramtRound to Amount | DEC(9,8)NULLABLEFLOAT9.8
ecprtRate at Beg Of Period | DEC(9,8)NULLABLEFLOAT9.8
eprvrtPrevious Rate | DEC(9,8)NULLABLEFLOAT9.8
enwrtNew Rate | DEC(9,8)NULLABLEFLOAT9.8
epmcapPayment Amount Cap | DEC(9,8)NULLABLEFLOAT9.8
enpdysNotice Pre-Days | DEC(2,0)NULLABLEINTEGER2
orgidxOriginal index | DEC(9,8)NULLABLEFLOAT9.8
curidxCurrent index | DEC(9,8)NULLABLEFLOAT9.8
prvidxPrevious index | DEC(9,8)NULLABLEFLOAT9.8
futidxFuture index | DEC(9,8)NULLABLEFLOAT9.8
cvrtabConvertable ARM | CHAR(1)NULLABLESTRING1
cindx_num_Convertable Index number | DEC(3,0)NULLABLEINTEGER3
cvvariConvertable Variance | DEC(9,8)NULLABLEFLOAT9.8
cvvarcConvertable Variance code | CHAR(1)NULLABLESTRING1
termLoan Term | DEC(3,0)NULLABLEINTEGER3
tmcodeLoan Term Code | CHAR(1)NULLABLESTRING1
freqPayment Frequency | DEC(3,0)NULLABLEINTEGER3
frcodePayment Freq Code | CHAR(1)NULLABLESTRING1
semdy1Semi Mnthly 1st day | DEC(2,0)NULLABLEINTEGER2
semdy2Semi Mnthly 2nd day | DEC(2,0)NULLABLEINTEGER2
ibaseInterest Base | DEC(1,0)NULLABLEINTEGER1
pmtcodPayment Code | DEC(1,0)NULLABLEINTEGER1
altschAlternate Pymt Sched | CHAR(1)NULLABLESTRING1
reamorReamortize Payment Amt | CHAR(1)NULLABLESTRING1
bilndy#days for Billing Notice | DEC(3,0)NULLABLEINTEGER3
reamtrmReamortization Term | DEC(3,0)NULLABLEINTEGER3
reamtmcdReamortization Term code | CHAR(1)NULLABLESTRING1
pflcProfit Period Late Chgs | DEC(9,2)NULLABLEFLOAT9.2
pfextfProfit Period Ext Fees | DEC(9,2)NULLABLEFLOAT9.2
pfbalProfit period Agg Bal | DEC(15,2)NULLABLEFLOAT15.2
pfearnProfit period Int earned | DEC(11,2)NULLABLEFLOAT11.2
pfdaysProfit period Agg Days | DEC(5,0)NULLABLEINTEGER5
cpd10Times Past Due 10-29 | DEC(3,0)NULLABLEINTEGER3
cpd30Times Past Due 30-59 | DEC(3,0)NULLABLEINTEGER3
cpd60Times Past Due 60-89 | DEC(3,0)NULLABLEINTEGER3
cpd90Times Past Due 90-119 | DEC(3,0)NULLABLEINTEGER3
extfeeExtension Fees YTD | DEC(9,2)NULLABLEFLOAT9.2
orgfeeOrigination Fees YTD | DEC(9,2)NULLABLEFLOAT9.2
ytdintInterest Paid YTD | DEC(13,2)NULLABLEFLOAT13.2
ytdprnPrincipal Paid YTD | DEC(13,2)NULLABLEFLOAT13.2
ytdlcLate chgs Paid YTD | DEC(9,2)NULLABLEFLOAT9.2
extytdTimes Extended Y-T-D | DEC(3,0)NULLABLEINTEGER3
rtcytdRight to Cures Y-T-D | DEC(3,0)NULLABLEINTEGER3
renytdTimes Renewed Y-T-D | DEC(3,0)NULLABLEINTEGER3
ytdadvYTD Advances | DEC(11,2)NULLABLEFLOAT11.2
ytdcurtYTD Curtailments | DEC(11,2)NULLABLEFLOAT11.2
ytdprinYTD Principal Payments | DEC(11,2)NULLABLEFLOAT11.2
ytdcapdrYTD Capitalization Debits | DEC(11,2)NULLABLEFLOAT11.2
ytdcapcrYTD Capitalization Credits | DEC(11,2)NULLABLEFLOAT11.2
ppd10Last Year Past Due 10-29 | DEC(3,0)NULLABLEINTEGER3
ppd30Last Year Past Due 30-59 | DEC(3,0)NULLABLEINTEGER3
ppd60Last Year Past Due 60-89 | DEC(3,0)NULLABLEINTEGER3
ppd90Last Year Past Due 90-119 | DEC(3,0)NULLABLEINTEGER3
intpreInt Paid Last Year | DEC(13,2)NULLABLEFLOAT13.2
lcpreLC paid Last Year | DEC(9,2)NULLABLEFLOAT9.2
irspreIRS Interest Last year | DEC(13,2)NULLABLEFLOAT13.2
extprePymt # Extended Last Yr | DEC(3,0)NULLABLEINTEGER3
orgpreOrg fees Previous year | DEC(9,2)NULLABLEFLOAT9.2
renpreTimes Renewed Last Year | DEC(3,0)NULLABLEINTEGER3
lpd10Life Time Past Due 10-29 | DEC(3,0)NULLABLEINTEGER3
lpd30Life Time Past Due 30-59 | DEC(3,0)NULLABLEINTEGER3
lpd60Life Time Past Due 60-89 | DEC(3,0)NULLABLEINTEGER3
lpd90Life Time Past Due 90-119 | DEC(3,0)NULLABLEINTEGER3
intltdInt Paid Life to Date | DEC(13,2)NULLABLEFLOAT13.2
extltdPymt # Extended L-T-D | DEC(3,0)NULLABLEINTEGER3
rtcltdRight to Cures L-T-D | DEC(3,0)NULLABLEINTEGER3
extmthMonths Extended LTD | DEC(3,0)NULLABLEINTEGER3
extfelExtension Fees LTD | DEC(9,2)NULLABLEFLOAT9.2
renltdTimes Renewed L-T-D | DEC(3,0)NULLABLEINTEGER3
irsltdIRS Interest L-T-D | DEC(13,2)NULLABLEFLOAT13.2
orgltdOrg fees Life to date | DEC(9,2)NULLABLEFLOAT9.2
nexltd# Extension Life to date | DEC(3,0)NULLABLEINTEGER3
delin4# Delin Quarter 4 | DEC(2,0)NULLABLEINTEGER2
delin3# Delin Quarter 3 | DEC(2,0)NULLABLEINTEGER2
delin2# Delin Quarter 2 | DEC(2,0)NULLABLEINTEGER2
delin1# Delin Curr Quarter | DEC(2,0)NULLABLEINTEGER2
qagqrybalQUARTERLY AGGREGATE QUERY BALANCE | DEC(15,2)NULLABLEFLOAT15.2
partidParticipation Code | CHAR(1)NULLABLESTRING1
clcodeCredit Line Code | CHAR(1)NULLABLESTRING1
deptcdDepartment Code | CHAR(1)NULLABLESTRING1
shadowShadow processing flag | CHAR(1)NULLABLESTRING1
shaccfShadow accrual flag | CHAR(1)NULLABLESTRING1
shrpcoShadow report as C/O | CHAR(1)NULLABLESTRING1
grpGroup Code | DEC(3,0)NULLABLEINTEGER3
glcostGL Cost Center | DEC(4,0)NULLABLEINTEGER4
glprodGL Product Code | DEC(3,0)NULLABLEINTEGER3
calrepCall Report Code | CHAR(8)NULLABLESTRING8
colcodCollateral Code | DEC(3,0)NULLABLEINTEGER3
purcodPurpose Code | DEC(2,0)NULLABLEINTEGER2
dlrnoDealer # | DEC(7,0)NULLABLEINTEGER7
hmailHold Mail Code | CHAR(1)NULLABLESTRING1
includInclude on Stmt Code | CHAR(1)NULLABLESTRING1
demstuDemand/Student Loan Code | CHAR(1)NULLABLESTRING1
indcodStandard Industry Code | DEC(4,0)NULLABLEINTEGER4
naicscNAICS Code | CHAR(6)NULLABLESTRING6
escpsqEscrow posting sequence | DEC(1,0)NULLABLEINTEGER1
intpsqInterest posting seq | DEC(1,0)NULLABLEINTEGER1
ltcpsqLate chg posting seq | DEC(1,0)NULLABLEINTEGER1
othpsqOther chg posting seq | DEC(1,0)NULLABLEINTEGER1
prnpsqPrincipal posting seq | DEC(1,0)NULLABLEINTEGER1
inspsqInsurance posting seq | DEC(1,0)NULLABLEINTEGER1
usebilUse Billed Amounts | CHAR(1)NULLABLESTRING1
sendcdPrint Billing Notice | CHAR(1)NULLABLESTRING1
sendmtPrint Final Pay Notice | CHAR(1)NULLABLESTRING1
titleTitle Still Needed Code | CHAR(1)NULLABLESTRING1
pnflagPast Due Notice Code | DEC(1,0)NULLABLEINTEGER1
phflagPast Due History Flag | CHAR(1)NULLABLESTRING1
sendpdSend Past Due Notice | CHAR(1)NULLABLESTRING1
pdcodeOn Past Due Report | CHAR(1)NULLABLESTRING1
lctypeLate Charge Type | CHAR(3)NULLABLESTRING3
ignlcpIgnore L/C - O/C Posting Sequence | CHAR(1)NULLABLESTRING1
typclsClassification Type | CHAR(1)NULLABLESTRING1
ratcodCredit Rating Code | DEC(3,0)NULLABLEINTEGER3
censusCensus Tract 1 | DEC(7,2)NULLABLEFLOAT7.2
smsaSMSA Number | DEC(5,0)NULLABLEINTEGER5
cralocCRA Location | DEC(9,0)NULLABLEINTEGER9
stateState Code | CHAR(2)NULLABLESTRING2
crastaCRA State Code | DEC(2,0)NULLABLEINTEGER2
countyCounty Code | DEC(3,0)NULLABLEINTEGER3
vin_num_Vehicle ID No. | CHAR(30)NULLABLESTRING30
msgSpecial Message Flag | CHAR(1)NULLABLESTRING1
renextRenewed/Extended This Mo | CHAR(1)NULLABLESTRING1
user1User Code Number 1 | CHAR(2)NULLABLESTRING2
user2User Code Number 2 | CHAR(1)NULLABLESTRING1
escrowEscrow/Mortgage Info? | CHAR(1)NULLABLESTRING1
clszroClose On Zero Bal Code | CHAR(1)NULLABLESTRING1
couponPrint Coupon Book Flag | CHAR(1)NULLABLESTRING1
cpntrmCoupon Book Term | DEC(3,0)NULLABLEINTEGER3
hasarmA.R.M. Info Code | CHAR(1)NULLABLESTRING1
almtypALM Type | CHAR(1)NULLABLESTRING1
prtpctParticipation Percent | DEC(17,16)NULLABLEFLOAT17.16
prprpcParticipation principal payment split percentage | DEC(17,16)NULLABLEFLOAT17.16
prinpcParticipation interest payment split percentage | DEC(17,16)NULLABLEFLOAT17.16
prtsq_num_Participation sequence number | DEC(5,0)NULLABLEINTEGER5
prtpmsParticipation payment split option | CHAR(1)NULLABLESTRING1
prt1pmParticipation 1st payment interest option | CHAR(1)NULLABLESTRING1
fndsq_num_Participation funding sequence | DEC(5,0)NULLABLEINTEGER5
fndlmtParticipation funding limit | DEC(13,2)NULLABLEFLOAT13.2
fndpctParticipation funding percentage | DEC(17,16)NULLABLEFLOAT17.16
pcacc_num_Part/Chg off Acct Num | DEC(16,0)NULLABLEINTEGER16
pcactpPart/Chg off Acct Type | CHAR(1)NULLABLESTRING1
clacc_num_Cr Line Number | DEC(16,0)NULLABLEINTEGER16
taxrefCr Line Tax Reference # | CHAR(20)NULLABLESTRING20
rlacc_num_Related Acct Num | DEC(16,0)NULLABLEINTEGER16
rlactpRelated Acct Type | CHAR(1)NULLABLESTRING1
hdacc_num_Hold account number | DEC(16,0)NULLABLEINTEGER16
hdactpHold account type | CHAR(1)NULLABLESTRING1
rewln_num_Rewrite to Loan # | DEC(16,0)NULLABLEINTEGER16
rq1098Requires 1098 | CHAR(1)NULLABLESTRING1
stmpasStmt or Passbook code | CHAR(1)NULLABLESTRING1
matgrcMaturity Grace Days | DEC(3,0)NULLABLEINTEGER3
wchcodWatch list Code | CHAR(1)NULLABLESTRING1
pppcodPrepayment Penalty Code | CHAR(3)NULLABLESTRING3
flinrqFlood Ins. Required? | CHAR(1)NULLABLESTRING1
brwpdBORROWER PAID DIRECTLY | CHAR(1)NULLABLESTRING1
rstrucRestructured Flag | CHAR(1)NULLABLESTRING1
secureAccount Level Security | CHAR(1)NULLABLESTRING1
lnpic1Programmer Use #1 | CHAR(2)NULLABLESTRING2
lnpic2Programmer Use #2 | CHAR(2)NULLABLESTRING2
lnpic3Programmer Use #3 | CHAR(5)NULLABLESTRING5
lnpic4Programmer Use #4 | CHAR(5)NULLABLESTRING5
lnpic5Programmer Use #5 | CHAR(10)NULLABLESTRING10
lnpic6Programmer Use #6 | CHAR(10)NULLABLESTRING10
lnpic7Programmer Use #7 | CHAR(10)NULLABLESTRING10
lnpdt1Programmer DATE #1 | DEC(7,0)NULLABLEINTEGER7
lnpd61Programmer DATE #1 | DEC(6,0)NULLABLEINTEGER6
lnpdt2Programmer DATE #2 | DEC(7,0)NULLABLEINTEGER7
lnpd62Programmer DATE #2 | DEC(6,0)NULLABLEINTEGER6
lnpam1Programmer AMT #1 | DEC(13,2)NULLABLEFLOAT13.2
lnpam2Programmer AMT #2 | DEC(13,2)NULLABLEFLOAT13.2
lnpam3Programmer AMT #3 | DEC(13,2)NULLABLEFLOAT13.2
lnpam4Programmer AMT #4 | DEC(13,2)NULLABLEFLOAT13.2
lnpam5Programmer AMT #5 | DEC(13,2)NULLABLEFLOAT13.2
lnpam6Programmer AMT #6 | DEC(13,2)NULLABLEFLOAT13.2
lnpam7Programmer AMT #7 | DEC(13,2)NULLABLEFLOAT13.2
lnanicAnnual Interest Income | DEC(13,2)NULLABLEFLOAT13.2
ltvratLoan to value ratio | DEC(5,4)NULLABLEFLOAT5.4
cltvrtCalculated PMI LTV Ratio | DEC(5,4)NULLABLEFLOAT5.4
sloutsSenior Lien Outsourced | CHAR(1)NULLABLESTRING1
oldmnyOld Money | DEC(13,2)NULLABLEFLOAT13.2
newmnyNew Money | DEC(13,2)NULLABLEFLOAT13.2
dwnpmtDown payment | DEC(11,2)NULLABLEFLOAT11.2
xclsttExclude from auto nonaccr status | CHAR(1)NULLABLESTRING1
popendPayoff pending flag | CHAR(1)NULLABLESTRING1
unpadvUnpost advances if over credit limit | CHAR(1)NULLABLESTRING1
remtrmRemaining Term | DEC(3,0)NULLABLEINTEGER3
cramilMILITARY CODE | DEC(1,0)NULLABLEINTEGER1
scracodSCRA Send Code | CHAR(1)NULLABLESTRING1
scrabdateSCRA Begin Date YYYYDDD | DEC(7,0)NULLABLEINTEGER7
scrabdat6SCRA Begin Date MMDDYY | DEC(6,0)NULLABLEINTEGER6
scraedateSCRA End Date YYYYDDD | DEC(7,0)NULLABLEINTEGER7
scraedat6SCRA End Date MMDDYY | DEC(6,0)NULLABLEINTEGER6
lnspccC/B Special Comment Code | CHAR(2)NULLABLESTRING2
cbc10Credit Bureau Past 10-29 | DEC(3,0)NULLABLEINTEGER3
cbc30Credit Bureau Past 30-59 | DEC(3,0)NULLABLEINTEGER3
cbc60Credit Bureau Past 60-89 | DEC(3,0)NULLABLEINTEGER3
cbc90Credit Bureau Past 90 + | DEC(3,0)NULLABLEINTEGER3
stm_num_acUnit Priced # of accts | DEC(7,0)NULLABLEINTEGER7
rstadvRestrict Auto advances | CHAR(1)NULLABLESTRING1
rstpmtRestrict Auto payments | CHAR(1)NULLABLESTRING1
lnmchkMinimum Check Advance | DEC(9,0)NULLABLEINTEGER9
lnreghReg H Code | CHAR(4)NULLABLESTRING4
lnsenlSenior Lien | DEC(11,0)NULLABLEINTEGER11
badck_num_Number of bad checks | DEC(3,0)NULLABLEINTEGER3
hiriskHigh Risk Customer | CHAR(1)NULLABLESTRING1
lnregpPrivacy Act opt out | CHAR(1)NULLABLESTRING1
receitReceipt Y/N | CHAR(1)NULLABLESTRING1
dloratDelinquent Org. Rate | DEC(9,8)NULLABLEFLOAT9.8
negpctNegative Amort. percent cap | DEC(3,0)NULLABLEINTEGER3
nsffeeDefault NSF Fee | DEC(11,2)NULLABLEFLOAT11.2
madvfeMinimum Check Tolerance | DEC(9,0)NULLABLEINTEGER9
defintDeferred Interest | DEC(13,2)NULLABLEFLOAT13.2
ptdintPaid to Deferred Int | DEC(13,2)NULLABLEFLOAT13.2
usrstsLoan User Status Code | CHAR(3)NULLABLESTRING3
stpadvStop advances | CHAR(1)NULLABLESTRING1
stpad6Stop advances Expiration date | DEC(6,0)NULLABLEINTEGER6
stpad7Stop advances Expiration date | DEC(7,0)NULLABLEINTEGER7
stppmtStop payments | CHAR(1)NULLABLESTRING1
stppm6Stop payments Expiration date | DEC(6,0)NULLABLEINTEGER6
stppm7Stop payments Expiration date | DEC(7,0)NULLABLEINTEGER7
stptaxStop tax disbursements | CHAR(1)NULLABLESTRING1
stptx6Stop tax disb Expiration date | DEC(6,0)NULLABLEINTEGER6
stptx7Stop tax disb Expiration date | DEC(7,0)NULLABLEINTEGER7
stphzdStop hazard disbursements | CHAR(1)NULLABLESTRING1
stphz6Stop hazard disb Exp. Date | DEC(6,0)NULLABLEINTEGER6
stphz7Stop hazard disb Exp. Date | DEC(7,0)NULLABLEINTEGER7
stpoptStop optional insurance disb | CHAR(1)NULLABLESTRING1
stpop6Stop optional disb Exp. Date | DEC(6,0)NULLABLEINTEGER6
stpop7Stop optional disb Exp. Date | DEC(7,0)NULLABLEINTEGER7
stplnsStop loan sale | CHAR(1)NULLABLESTRING1
stpls6Stop loan sale Exp. Date | DEC(6,0)NULLABLEINTEGER6
stpls7Stop loan sale Exp. Date | DEC(7,0)NULLABLEINTEGER7
stpnotStop notices | CHAR(1)NULLABLESTRING1
stpnt6Stop Notices Exp. Date | DEC(6,0)NULLABLEINTEGER6
stpnt7Stop Notices Exp. Date | DEC(7,0)NULLABLEINTEGER7
stpcrpStop credit reporting | CHAR(1)NULLABLESTRING1
stpcr6Stop Cred Rpt Exp. Date | DEC(6,0)NULLABLEINTEGER6
stpcr7Stop Cred Rpt Exp. Date | DEC(7,0)NULLABLEINTEGER7
stpprpStop prepayments | CHAR(1)NULLABLESTRING1
stppr6Stop prepayments Exp. Date | DEC(6,0)NULLABLEINTEGER6
stppr7Stop prepayments Exp. Date | DEC(7,0)NULLABLEINTEGER7
stpacrStop accrual | CHAR(1)NULLABLESTRING1
stpac6Stop accrual Exp. Date | DEC(6,0)NULLABLEINTEGER6
stpac7Stop accrual Exp. Date | DEC(7,0)NULLABLEINTEGER7
stpcorStop correspondence | CHAR(1)NULLABLESTRING1
stpco6Stop corresp Exp. Date | DEC(6,0)NULLABLEINTEGER6
stpco7Stop corresp Exp. Date | DEC(7,0)NULLABLEINTEGER7
stpirsStop IRS reporting | CHAR(1)NULLABLESTRING1
stpir6Stop IRS Rpt Exp. Date | DEC(6,0)NULLABLEINTEGER6
stpir7Stop IRS Rpt Exp. Date | DEC(7,0)NULLABLEINTEGER7
stpstmStop statments | CHAR(1)NULLABLESTRING1
stpst6Stop statement Exp. Date | DEC(6,0)NULLABLEINTEGER6
stpst7Stop statement Exp. Date | DEC(7,0)NULLABLEINTEGER7
stpcouStop coupon generation | CHAR(1)NULLABLESTRING1
stpcp6Stop coupon Exp. Date | DEC(6,0)NULLABLEINTEGER6
stpcp7Stop coupon Exp. Date | DEC(7,0)NULLABLEINTEGER7
stpesdStop all escrow disbursements | CHAR(1)NULLABLESTRING1
stped6Stop Esc Disb Exp. Date | DEC(6,0)NULLABLEINTEGER6
stped7Stop Esc Disb Exp. Date | DEC(7,0)NULLABLEINTEGER7
stpesaStop escrow analysis | CHAR(1)NULLABLESTRING1
stpea6Stop Esc Anal Exp. Date | DEC(6,0)NULLABLEINTEGER6
stpea7Stop Esc Anal Exp. Date | DEC(7,0)NULLABLEINTEGER7
stppdpStop past due reporting | CHAR(1)NULLABLESTRING1
stppd6Stop past due rpt Exp Date | DEC(6,0)NULLABLEINTEGER6
stppd7Stop past due rpt Exp Date | DEC(7,0)NULLABLEINTEGER7
pstshrPost Short Payment | CHAR(1)NULLABLESTRING1
useunaUse Payment Suspense | CHAR(1)NULLABLESTRING1
howunaHow to Post Payment Suspense | CHAR(1)NULLABLESTRING1
dlrlocDealer Location | DEC(7,0)NULLABLEINTEGER7
dlrtypDealer Type | DEC(2,0)NULLABLEINTEGER2
dlrfdpForfeit after days/pmts | CHAR(1)NULLABLESTRING1
dlrfdpcForfeit after days/pmts charge-off | CHAR(1)NULLABLESTRING1
cdlrforFORFEIT U/F DLR DISC/REB | CHAR(1)NULLABLESTRING1
cdlrdys# OF DAYS FORFEIT REBATE | DEC(3,0)NULLABLEINTEGER3
cdlrpmt# OF PMTS FORFEIT REBATE | DEC(3,0)NULLABLEINTEGER3
cdlrpddCHG-OFF Percent | DEC(9,8)NULLABLEFLOAT9.8
recrscdRecourse Code | CHAR(1)NULLABLESTRING1
recrspcRecourse Percent | DEC(9,8)NULLABLEFLOAT9.8
recrstmRecourse Term | DEC(3,0)NULLABLEINTEGER3
recrstcRecourse Term Code | CHAR(1)NULLABLESTRING1
recdaypDays Past Due Recourse | DEC(4,0)NULLABLEINTEGER4
recintRecourse Interest | DEC(11,2)NULLABLEFLOAT11.2
partid_num_Participation ID number | DEC(7,0)NULLABLEINTEGER7
pnflagsPast Due Notice Code | DEC(1,0)NULLABLEINTEGER1
payex6Payoff Pending Expiration Date | DEC(6,0)NULLABLEINTEGER6
payex7Payoff Pending Expiration Date | DEC(7,0)NULLABLEINTEGER7
cpd120Times Past Due 120-149 | DEC(3,0)NULLABLEINTEGER3
cpd150Times Past Due 150-179 | DEC(3,0)NULLABLEINTEGER3
cpd180Times Past Due 180 + | DEC(3,0)NULLABLEINTEGER3
ppd120Last Year Past Due 120-149 | DEC(3,0)NULLABLEINTEGER3
ppd150Last Year Past Due 150-179 | DEC(3,0)NULLABLEINTEGER3
ppd180Last Year Past Due 180 + | DEC(3,0)NULLABLEINTEGER3
lpd120Life Time Past Due 120-149 | DEC(3,0)NULLABLEINTEGER3
lpd150Life Time Past Due 150-179 | DEC(3,0)NULLABLEINTEGER3
lpd180Life Time Past Due 180 + | DEC(3,0)NULLABLEINTEGER3
pctrea% of Balance to Re-am | DEC(9,8)NULLABLEFLOAT9.8
partpcParticipation Percentage | DEC(17,16)NULLABLEFLOAT17.16
bilolaBilled Overline Principal | DEC(11,2)NULLABLEFLOAT11.2
ytdpenYTD Prepayment Penalty | DEC(11,2)NULLABLEFLOAT11.2
prepenPrepayment Penalty Last Year | DEC(11,2)NULLABLEFLOAT11.2
ltdpenPrepayment Penalty Life to Date | DEC(11,2)NULLABLEFLOAT11.2
subprmSub-Prime Lending | CHAR(1)NULLABLESTRING1
ovlfeeDefault Overline Fee | DEC(11,2)NULLABLEFLOAT11.2
clcif_num_Credit Line CIF Number | CHAR(7)NULLABLESTRING7
adotnbAdd Overline Fee to the next bill | CHAR(1)NULLABLESTRING1
untpdlrfpUnit Priced Reporting Method | CHAR(1)NULLABLESTRING1
minuntadvMinimum Unit Priced Advance | DEC(11,2)NULLABLEFLOAT11.2
syndagtnbrSyndication Agent Number | DEC(7,0)NULLABLEINTEGER7
syndmbrnbrSyndication Member Number | DEC(7,0)NULLABLEINTEGER7
shrntlcrdShared National Credit | CHAR(1)NULLABLESTRING1
corresbankCorrespondent Bank | CHAR(1)NULLABLESTRING1
crcytypeCurrency Type | CHAR(2)NULLABLESTRING2
frdalrtFraud Alert | CHAR(1)NULLABLESTRING1
argprdcodARGO PRODUCT TYPE | CHAR(3)NULLABLESTRING3
constrCONSTRUCTION LOAN TRACKING | CHAR(1)NULLABLESTRING1
rgriskREGULATORY RISK WEIGHT | DEC(3,0)NULLABLEINTEGER3
teaserREGULATORY TEASER RATE APPLIES | CHAR(1)NULLABLESTRING1
cspltvCalculated Supervisory LTV Ratio | DEC(5,4)NULLABLEFLOAT5.4
exsltvExclude From Supervisory LTV | DEC(2,0)NULLABLEINTEGER2
exrelpException to RE Lending Policy | DEC(2,0)NULLABLEINTEGER2
lnatmcrdATM Card Access | CHAR(1)NULLABLESTRING1
hmdaHMDA REQUIRED Y/N | CHAR(1)NULLABLESTRING1
salesacSales Associate | CHAR(15)NULLABLESTRING15
rtcctrRight to Cure Counter | DEC(3,0)NULLABLEINTEGER3
affiliateAffiliate Loan Y/N | CHAR(1)NULLABLESTRING1
minbilMin amt to create bill | DEC(11,2)NULLABLEFLOAT11.2
intfirInterest first product | CHAR(1)NULLABLESTRING1
steprtStep Rate Loan Y/N | CHAR(1)NULLABLESTRING1
lnlangLanguage Code | CHAR(3)NULLABLESTRING3
appdlnsApply payments to past due loans | CHAR(1)NULLABLESTRING1
nbrpdpmtNumber of payments past due to trigger | DEC(3,0)NULLABLEINTEGER3
apppdlnsApply payments to pre-paid loans | CHAR(1)NULLABLESTRING1
npdappltNumber, percent or dollar amount to trigger | DEC(9,0)NULLABLEINTEGER9
npdppltrNumber, percent or dollar to trigger | CHAR(1)NULLABLESTRING1
postexpcPost excess as a Principal Curtailment | CHAR(1)NULLABLESTRING1
shdow6Shadow Processing Date | DEC(6,0)NULLABLEINTEGER6
shdow7Shadow Processing Date | DEC(7,0)NULLABLEINTEGER7
rshtpc6Roll Short on Pcode 6 | CHAR(1)NULLABLESTRING1
odibasAccrue Odd Days at 365 Ibase | CHAR(1)NULLABLESTRING1
mtdadv_num_Number MTD Advances | DEC(3,0)NULLABLEINTEGER3
yrlcalcYearly Fee Calc Code | CHAR(3)NULLABLESTRING3
loccalcLOC Fee Calc Code | CHAR(3)NULLABLESTRING3
locfreqLOC Fee Frequency | DEC(3,0)NULLABLEINTEGER3
locfrcdLOC Fee Freq Code | CHAR(1)NULLABLESTRING1
locfdt6LOC Fee Date 6 | DEC(6,0)NULLABLEINTEGER6
locfdt7LOC Fee Date 7 | DEC(7,0)NULLABLEINTEGER7
locfdyLOC Fee Freq Day | DEC(2,0)NULLABLEINTEGER2
unucalcUnused Line Calc Code | CHAR(3)NULLABLESTRING3
unufreqUnused Line Frequency | DEC(3,0)NULLABLEINTEGER3
unufrcdUnused Line Freq Code | CHAR(1)NULLABLESTRING1
unufdt6Unused Line Date 6 | DEC(6,0)NULLABLEINTEGER6
unufdt7Unused Line Date 7 | DEC(7,0)NULLABLEINTEGER7
unufdyUnused Line Freq Day | DEC(2,0)NULLABLEINTEGER2
_num_dyszrocurCur Month Days Paid Zero | DEC(2,0)NULLABLEINTEGER2
_num_dyszro01January Days Paid Zero | DEC(2,0)NULLABLEINTEGER2
_num_dyszro02Febuary Days Paid Zero | DEC(2,0)NULLABLEINTEGER2
_num_dyszro03March Days Paid Zero | DEC(2,0)NULLABLEINTEGER2
_num_dyszro04April Days Paid Zero | DEC(2,0)NULLABLEINTEGER2
_num_dyszro05May Days Paid Zero | DEC(2,0)NULLABLEINTEGER2
_num_dyszro06June Days Paid Zero | DEC(2,0)NULLABLEINTEGER2
_num_dyszro07July Days Paid Zero | DEC(2,0)NULLABLEINTEGER2
_num_dyszro08August Days Paid Zero | DEC(2,0)NULLABLEINTEGER2
_num_dyszro09September Days Paid Zero | DEC(2,0)NULLABLEINTEGER2
_num_dyszro10October Days Paid Zero | DEC(2,0)NULLABLEINTEGER2
_num_dyszro11November Days Paid Zero | DEC(2,0)NULLABLEINTEGER2
_num_dyszro12December Days Paid Zero | DEC(2,0)NULLABLEINTEGER2
lptypeCurtailment/ Recoupment Penalty Type | DEC(3,0)NULLABLEINTEGER3
cpasslnPass curtailment to sold loan | CHAR(1)NULLABLESTRING1
rpasslnPass recoupment to sold loan | CHAR(1)NULLABLESTRING1
rpasspctRecoupment percentage to pass to sold loan | DEC(6,5)NULLABLEFLOAT6.5
ppsdt6Curtailment Start Date | DEC(6,0)NULLABLEINTEGER6
ppsdt7Curtailment Start Date | DEC(7,0)NULLABLEINTEGER7
ppsfrqCurtailment Start Frequency | DEC(3,0)NULLABLEINTEGER3
ppscodCurtailment Start Frequency Code | CHAR(1)NULLABLESTRING1
ppdbalBeginning Decl Penalty Balance | DEC(13,2)NULLABLEFLOAT13.2
ppcurtTotal Curtailments | DEC(13,2)NULLABLEFLOAT13.2
ppexp6Curtailment Expire Date | DEC(6,0)NULLABLEINTEGER6
ppexp7Curtailment Expire Date | DEC(7,0)NULLABLEINTEGER7
curntc6Notice of Curtailment Date | DEC(6,0)NULLABLEINTEGER6
curntc7Notice of Curtailment Date | DEC(7,0)NULLABLEINTEGER7
curexp6Curtailment Notice Expire Date | DEC(6,0)NULLABLEINTEGER6
curexp7Curtailment Notice Expire Date | DEC(7,0)NULLABLEINTEGER7
curall6Curtailment Allowable Date | DEC(6,0)NULLABLEINTEGER6
curall7Curtailment Allowable Date | DEC(7,0)NULLABLEINTEGER7
invall6Investor Allowable Date | DEC(6,0)NULLABLEINTEGER6
invall7Investor Allowable Date | DEC(7,0)NULLABLEINTEGER7
recoupasdRecoupment Fee Assessed this Period | CHAR(1)NULLABLESTRING1
recoupytdRecoupment Fee Paid YTD | DEC(11,2)NULLABLEFLOAT11.2
recouppreRecoupment Fee Paid Prev YTD | DEC(11,2)NULLABLEFLOAT11.2
nsfntcytdInsufficient Notice Fee Paid YTD | DEC(11,2)NULLABLEFLOAT11.2
nsfntcpreInsufficient Notice Fee Prev YTD | DEC(11,2)NULLABLEFLOAT11.2
paycurtPayoff curtailment amount | DEC(11,2)NULLABLEFLOAT11.2
paycoupPayoff recoupment amount | DEC(11,2)NULLABLEFLOAT11.2
recprndt6Recoupment renewal date | DEC(6,0)NULLABLEINTEGER6
recprndt7Recoupment renewal date | DEC(7,0)NULLABLEINTEGER7
curtamt1Curtlmnt P/O penalty amt | DEC(11,2)NULLABLEFLOAT11.2
curtamt2Recoup P/O penalty amt | DEC(11,2)NULLABLEFLOAT11.2
datepen16Penalty Date 1 | DEC(6,0)NULLABLEINTEGER6
datepen17Penalty Date 1 | DEC(7,0)NULLABLEINTEGER7
datepen26Penalty Date 2 | DEC(6,0)NULLABLEINTEGER6
datepen27Penalty Date 2 | DEC(7,0)NULLABLEINTEGER7
lntierTiered Rate Type? | CHAR(1)NULLABLESTRING1
lqbl_num_2Balance tier 2 | DEC(11,0)NULLABLEINTEGER11
lqrt_num_2Rate number tier 2 | DEC(3,0)NULLABLEINTEGER3
lqbl_num_3Balance tier 3 | DEC(11,0)NULLABLEINTEGER11
lqrt_num_3Rate number tier 3 | DEC(3,0)NULLABLEINTEGER3
lqbl_num_4Balance tier 4 | DEC(11,0)NULLABLEINTEGER11
lqrt_num_4Rate number tier 4 | DEC(3,0)NULLABLEINTEGER3
lqbl_num_5Balance tier 5 | DEC(11,0)NULLABLEINTEGER11
lqrt_num_5Rate number tier 5 | DEC(3,0)NULLABLEINTEGER3
lqbl_num_6Balance tier 6 | DEC(11,0)NULLABLEINTEGER11
lqrt_num_6Rate number tier 6 | DEC(3,0)NULLABLEINTEGER3
lqbl_num_7Balance tier 7 | DEC(11,0)NULLABLEINTEGER11
lqrt_num_7Rate number tier 7 | DEC(3,0)NULLABLEINTEGER3
lqbl_num_8Balance tier 8 | DEC(11,0)NULLABLEINTEGER11
lqrt_num_8Rate number tier 8 | DEC(3,0)NULLABLEINTEGER3
lqbl_num_9Balance tier 9 | DEC(11,0)NULLABLEINTEGER11
lqrt_num_9Rate number tier 9 | DEC(3,0)NULLABLEINTEGER3
lqbl_num_10Balance tier 10 | DEC(11,0)NULLABLEINTEGER11
lqrt_num_10Rate number tier 10 | DEC(3,0)NULLABLEINTEGER3
lsplitCalc split rate accruals | CHAR(1)NULLABLESTRING1
lienposnLien Position | DEC(1,0)NULLABLEINTEGER1
odpuseholdUse DDA Hold For ODP Xfer | CHAR(1)NULLABLESTRING1
penrat_num_Penalty APR number | DEC(3,0)NULLABLEINTEGER3
pennewrtPenalty APR will be | DEC(9,8)NULLABLEFLOAT9.8
penratePenalty APR | DEC(9,8)NULLABLEFLOAT9.8
penpdaysDays past due to send penalty APR notice | DEC(3,0)NULLABLEINTEGER3
penaftntDays after notice penalty APR begins | DEC(2,0)NULLABLEINTEGER2
penrvtmPenalty APR review term | DEC(3,0)NULLABLEINTEGER3
penrvtmcPenalty APR review term code | CHAR(1)NULLABLESTRING1
pennotd6Penalty notice date | DEC(6,0)NULLABLEINTEGER6
pennotd7Penalty notice date | DEC(7,0)NULLABLEINTEGER7
penstdt6Penalty APR start date | DEC(6,0)NULLABLEINTEGER6
penstdt7Penalty APR start date | DEC(7,0)NULLABLEINTEGER7
penrvdt6Penalty APR review date | DEC(6,0)NULLABLEINTEGER6
penrvdt7Penalty APR review date | DEC(7,0)NULLABLEINTEGER7
penratynPenalty APR in effect | CHAR(1)NULLABLESTRING1
penlnrateLoan APR at penalty end | DEC(9,8)NULLABLEFLOAT9.8
ppvariPart Rate Variance | DEC(9,8)NULLABLEFLOAT9.8
ppvcodePart Rate Variance Code | CHAR(1)NULLABLESTRING1
speclenSpecialty Lending | CHAR(1)NULLABLESTRING1
tsamt1Tech Serv amount 1 | DEC(13,2)NULLABLEFLOAT13.2
tsamt2Tech Serv amount 2 | DEC(13,2)NULLABLEFLOAT13.2
tsdate1Tech Serv Date 1 | DEC(7,0)NULLABLEINTEGER7
tsdate2Tech Serv Date 2 | DEC(7,0)NULLABLEINTEGER7
ts1char1Tech Serv misc code 1 | CHAR(1)NULLABLESTRING1
ts1char2Tech Serv misc code 2 | CHAR(1)NULLABLESTRING1
ts2char3Tech Serv misc code 3 | CHAR(2)NULLABLESTRING2
ts2char4Tech Serv misc code 4 | CHAR(2)NULLABLESTRING2
prmrskratPrimary Risk Rating | CHAR(3)NULLABLESTRING3
rskratdt6Risk Rating Date | DEC(6,0)NULLABLEINTEGER6
rskratdt7Risk Rating Date | DEC(7,0)NULLABLEINTEGER7
splrskrat1Split Risk Rating 1 | CHAR(3)NULLABLESTRING3
splrskamt1Split Risk Rating 1 Established Position | DEC(13,2)NULLABLEFLOAT13.2
splrskrat2Split Risk Rating 2 | CHAR(3)NULLABLESTRING3
splrskpct2Split Risk Rating 2 Percent | DEC(2,0)NULLABLEINTEGER2
splrskamt2Split Risk Rating 2 Amount | DEC(13,2)NULLABLEFLOAT13.2
splrskrat3Split Risk Rating 3 | CHAR(3)NULLABLESTRING3
splrskpct3Split Risk Rating 3 Percent | DEC(2,0)NULLABLEINTEGER2
splrskamt3Split Risk Rating 3 Amount | DEC(13,2)NULLABLEFLOAT13.2
splrskca1Split Risk Rating 1 Calculated Position | DEC(13,2)NULLABLEFLOAT13.2
ngamorg_mon_Negative am org. balance | DEC(13,2)NULLABLEFLOAT13.2
autobilPrint Auto Pay Message | CHAR(1)NULLABLESTRING1
ytdescEscrow Paid YTD | DEC(13,2)NULLABLEFLOAT13.2
prvescEscrow Paid Last year | DEC(13,2)NULLABLEFLOAT13.2
ytdfeeFees Paid YTD | DEC(13,2)NULLABLEFLOAT13.2
prvfeeFees Paid Last Year | DEC(13,2)NULLABLEFLOAT13.2
prvprnPrincipal Paid Last Year | DEC(13,2)NULLABLEFLOAT13.2
pridwePrincipal dwelling | CHAR(1)NULLABLESTRING1
armntcARM Notice type | CHAR(1)NULLABLESTRING1
inarmdDays before rate change to send initial notice | DEC(3,0)NULLABLEINTEGER3
armsntInitial ARM notice sent | CHAR(1)NULLABLESTRING1
eindt6Early Intervention Notice Date | DEC(6,0)NULLABLEINTEGER6
eindt7Early Intervention Notice Date | DEC(7,0)NULLABLEINTEGER7
Last updated Thu Dec 12 2024