loan deal/loan facility

loandeal: bank give a loan to borrower

LOANDEALID

VERSION

LDRDEALID

LDRVERSION

DEALSNPCUSIP

DEALTYPE

DEALNAME

DEALDESC

DEALSTATUS

CRAGREEMENTDATE

CRAGREEMENTCLSDATE

CRAGREEMENTEFFDATE

CRAGREEMENTMATDATE

GLOBALSIZE

GLOBALCCY

SYNDCOUNTRY

REFINANCEFLAG

AMENDFLAG

RESTATEFLAG

ISSUERCONSENTFLAG

MINASSIGNMENTAMOUNT

BUSINESSDAYRULE

LDRISSUERID

ISSUERNAME

ISSUERSTATUS

ISSUECOUNTRYCD

ISSUECCY

CITIRATING

SNPRATING

MOODYRATING

FITCHRATING

COBINDUSTRYCD

COBINDUSTRYNAME

SICINDUSTRYCD

SICINDUSTRYNAME

DUPLICATELDRDEALID

RECORDSTATUS

CREATEDBY

CREATIONDATE

MODIFIEDBY

MODIFICATIONDATE

SNPISSUERRATING

SNPCORPFAMILYRATING

MOODYISSUERRATING

MOODYCORPFAMILYRATING

FITCHISSUERRATING

FITCHCORPFAMILYRATING

72

10

5780

SYNDICATED

NIGHTHAWK RADIOLOGY

A

22-JUN-07 12.00.00.000000000 AM

1.5E+08

USA

0

5780

NIGHTHAWK RADIOLOGY HOLDINGS INC

A

USA

NR

WR

8071

MEDICAL LABORATORIES

LIVE

pr33684

18-APR-08 07.53.35.844000000 PM

pr33684

01-FEB-11 10.24.30.805000000 PM

B+

B2

NR

loanfacility: bank seperate the loan deal to serval loan facilities, then sell them.(loanfacility may be seperated into 2 , one for funded the other for unfunded)

LOANFACILITYID

VERSION

LOANDEALID

LDRFACILITYID

LDRVERSION

LDRDEALID

SNPCUSIP

LOANXID

LPCID

MOODYSID

FACILITYCUSIP

FACILITYTYPE

FACILITYNAME

FACILITYDESC

FACILITYSTATUS

LSTATYPE

GLOBALSIZE

ORIGGLOBALSIZE

FUNDEDFLAG

FUNDEDAMOUNT

UNFUNDEDAMOUNT

DRAWDOWNLIMIT

CRAGREEMENTDATE

ISSUEDATE

MATURITYDATE

FIXEDRATEFLAG

BASERATECATEGORY

BASERATE

SPREAD

ALLINRATE

LASTRATERESETDATE

COUPONFREQUENCY

RATERESETFREQUENCY

DAYCOUNT

REPAYMENTSENIORITY

SECUREDFLAG

LIENSENIORITY

PRORATAFLAG

MINBORROWAMOUNT

INCRBORROWAMOUNT

PREPAYMENTOPTIONFLAG

AMORTIZATIONFLAG

EVERGREENREVOLVERFLAG

TERMOUTREVOLVERCONVFLAG

TERMOUTREVOLVERCONVDATE

PAYMENTINKINDFLAG

CITIRATING

SNPRATING

MOODYRATING

FITCHRATING

DUPLICATECUSIP

FUNDEDCUSIP

REVOLVERCOMMCUSIP

RECORDSTATUS

CREATEDBY

CREATIONDATE

MODIFIEDBY

MODIFICATIONDATE

COMMITEDOBLIGATIONFLAG

ASSETID

COVLITEFLAG

GLOBALCCY

1941

2

72

11263

5780

LX075209

6727369B3

DDTL

NIGHTHAWK RADIOLOGY DDTL FUN

DDTL FUN

A

7

50000000

50000000

F

50000000

0

0

22-JUN-07 12.00.00.000000000 AM

02-JUL-14 12.00.00.000000000 AM

N

LIBOR

0

2.5

2.5

22-JUN-07 12.00.00.000000000 AM

Q

0

Act/360

0

N

0

0

B+

B1

LIVE

pr33684

10-JUN-08 03.50.09.977000000 PM

pr33684

23-JAN-09 06.18.39.290000000 PM

N

11950

USD

78

7

72

11261

5780

841089

NOLXMARK

8.2E+08

6727369A5

TL

NIGHTHAWK RADIOLOGY TL B

TL B

A

7

1E+08

75000000

F

1E+08

0

0

22-JUN-07 12.00.00.000000000 AM

30-JUN-14 12.00.00.000000000 AM

N

LIBOR

0

2.5

2.5

22-JUN-07 12.00.00.000000000 AM

Q

0

Act/360

Senior

Y

1

N

0

0

N

NR

WR

LIVE

pr33684

18-APR-08 07.53.35.867000000 PM

pr33684

01-FEB-11 10.20.55.708000000 PM

N

10087

N

USD

loan trade -> swap loan -> position

loancontract/trusteecontract: describe  each buy loan trade/swap loan accrual

loan paydown,loandraw, when a loan paydown happen, need to generate a loan trade sell

 virt_TRS_daily_accruals_export_022412.csv

portfolio_name

deal_id

issuer_name

facility_id

market_identifier

accrual_start_date

accrual_end_date

initial_price

base_rate

spread

swap_spread

currency

funded_amount

unfunded_amount

funded_notional

spv_allocation_to_cfpi

counterparty

cash_recorded

total_accrued_interest

total_swap_interest

days_in_accrual

cbna_libor

cfpi_libor

cbna_spread

cfpi_spread

security_type

option_index

accrual_method

citi_cusip

entity_id

contract_id

lot_id

due_date

asset_description

all_in_rate

year_count

swap_base_rate

swap_all_in_rate

libor_total

spread_total

net_interest_due_to_counterparty

unfunded_flag

xx

xx

xx

xx

xx

2/10/2012

3/1/2012

0.9475

0.007227

0.0375

0.0135

EUR

1000000

0

947500

NDCB

2112.11

927.39

17

323.3581

604.0313

Term Loan

EurIBOR (1 month)

Actual/360

xx

370

231849

1185550

3/1/2012

Facility S

0.044727

360

0.007227

0.020727

323.3581

604.0313

1184.72

N

xx

8xx

xx

xx

xx

2/1/2012

3/1/2012

0.9425

0.007227

0.0375

0.0135

EUR

1000000

0

942500

NDCB

3230.29

1410.88

26

491.9379

918.9375

Term Loan

EurIBOR (1 month)

Actual/360

xx

370

231849

1161807

3/1/2012

Facility S

0.044727

360

0.007227

0.020727

491.9379

918.9375

1819.41

N

TrusteeMonthlyAccrual.dat

LOANCONTRACTID	VERSION	LQTCONTRACTID	PTRSID	PROGRAMCUSIP	FACILITYCUSIP	LOANFACILITYID	ALTFACILITYID	PROCESSDATE	EFFECTIVEDATE	MATURITYDATE	RECEIVEDATE	COMMITMENTAMOUNT	NOTIONALAMOUNT	UNFUNDEDAMOUNT	WTAVGPURCHASEPRICE	CONTRACTINDEX	LOANBASERATE	LOANSPREAD	LOANALLINRATE	FUNDINGBASERATE	FUNDINGSPREAD	FUNDINGALLINRATE	CLIENTDAYCOUNT	CITIDAYCOUNT	LEGALVEHICLE	LOANACCRUALDAY	LOANACCRUAL	SWAPACCRUAL	PROJECTEDLOANACCRUALDAY	PROJECTEDLOANACCRUAL	PROJECTEDSWAPACCRUAL	INTERESTRECEIVEDFLAG
xx	1	xx	xx	xx	xx	xx	xx	22-FEB-12 12.00.00.000000000 AM	03-JAN-12 12.00.00.000000000 AM	01-FEB-12 12.00.00.000000000 AM	01-FEB-12 12.00.00.000000000 AM	1000000	942500		94.25	EurIBOR (1 month)	1.0257	3.75	4.7757	1.0257	1.35	2.3757	360	360	CBNA	29	3847.09	1803.72	0	0	0	Y
xx	1	xx	xx	xx	xx	xx	xx	22-FEB-12 12.00.00.000000000 AM	10-FEB-12 12.00.00.000000000 AM	01-MAR-12 12.00.00.000000000 AM	01-MAR-12 12.00.00.000000000 AM	1000000	947500		94.75	EurIBOR (1 month)	0.7227	3.75	4.4727	0.7227	1.35	2.0727	360	360	CBNA	13	1615.14	709.18	7	869.69	381.87	N
xx	1	xx	xx	xx	xx	xx	xx	22-FEB-12 12.00.00.000000000 AM	01-FEB-12 12.00.00.000000000 AM	01-MAR-12 12.00.00.000000000 AM	01-MAR-12 12.00.00.000000000 AM	1000000	942500		94.25	EurIBOR (1 month)	0.7227	3.75	4.4727	0.7227	1.35	2.0727	360	360	CBNA	22	2733.32	1193.82	7	869.69	379.85	N