LOAD DATA
APPEND
INTO TABLE FhlLoanUI
FIELDS TERMINATED BY "|"
(
SecMnem,
LoanSeqNum,
FctrDt   date 'YYYYMMDD',
PoolIssDt  date 'YYYYMMDD',
Prefix,
CouponType,
CUSIP,
LoanPurpose,
TPOFlag,
PropType,
OccStatus,
NumUnits,
State,
CS,
OrigTerm,
OrigLTV,
PpayProtMtgFlag,
InterestOnlyPerFlag,
FirstPaymtDt   date 'YYYYMMDD',
FirstPIPaymtDt  date 'YYYYMMDD',
MatDt    date 'YYYYMMDD',
OrigNoteRate,
PoolIssNoteRate,
PoolIssNetNoteRate,
NoteRate,
NetNoteRate,
OrigLoanAmt,
PoolIssRPB,
CurrRPB,
LoanAge,
RemTerm,
MonthsToAmort,
Seller,
Servicer,
DocTypeAssetFlag,
DocTypeEmplFlag,
DocTypeIncomeFlag,
OrigCombLTV,
NumBorrowers,
FirstTimeHomeBuyerFlag,
PctMtgIns,
DTI,
MSA,
UCS,
ELTV,
MtgInsCancelFlag,
GovtAgy,
AssumabilityFlag,
PpayPremTerm,
LoanPartnPct,
CorrectionFlag,
PropValMethod,
UpdSrc,
UpdDt   timestamp 'YYYYMMDD HH24:MI:SS',
ADR,
NumADR,
TotDefAmt,
BAP,
DaysDelinq,
SellerCity,
SellerState,
ServicerCity,
ServicerState,
SpecialEligProg
)