lnmast_raw

Pipelined Data Sets > 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

Have a Question?

Have a how-to question? Seeing a weird error? Get help on StackOverflow.
Register for the Developer Office Hours where we answer technical Q&A from the audience.

Please ignore this field

Did this page help you?

Last updated Wed Mar 4 2026