[Push to IMDB manually] #luna

push_to_imdb

EXEC cm_inventory_management.dbo.spIMDB_BlotterLoad
 @Debug = 0,
 @EmailList = '[email protected];[email protected]',
 @XMLParam = '
 <poolList>
<pooldetails id="CN4856" agency="GNMA" portid="1" trnno="31334961" compid="1" isoverride="1" iscollapse="0">
	<loans/>
	<investors>
		<investor name="WELLS" id="104">
			<salesprice>98.25390625</salesprice>
			<tradedate>2022/04/25</tradedate>
			<size>80685586</size>
			<brokerdealer>WELLS</brokerdealer>
			<daysofinterest>1</daysofinterest>
			<settlementdate>2022/05/02</settlementdate>
		</investor>
	</investors>
	<warehouse isoverride="0">
		<issueupb line="baml">7240379.41</issueupb>
		<issueupb line="citi">0.0</issueupb>
		<issueupb line="cs">10270379.11</issueupb>
		<issueupb line="ms">373447.0</issueupb>
		<issueupb line="rbs">0.0</issueupb>
		<issueupb line="rbc">41094037.38</issueupb>
		<issueupb line="jpm">3638181.1</issueupb>
		<issueupb line="cash">0.0</issueupb>
		<issueupb line="db">0.0</issueupb>
		<issueupb line="barc">0.0</issueupb>
		<issueupb line="bnp">2607727.65</issueupb>
	</warehouse>
	<totalissueupb>80685586.37</totalissueupb>
	<projecteddeliverydate>2022/05/02</projecteddeliverydate>
	<dbcertification>2022/04/25</dbcertification>
	<receivefreedate>2022/05/02</receivefreedate>
	<sma/>
	<entity>PLS</entity>
	<executiontype>MBS</executiontype>
	<pooltype>
		<![CDATA[ PLS GNII30 3.5% MULTI ]]>
	</pooltype>
	<poolterm>30</poolterm>
	<convfha>GOV</convfha>
	<fixedarm>Fixed</fixedarm>
	<spec>
		<![CDATA[ NewProd ]]>
	</spec>
	<securityrate>3.5</securityrate>
	<cusip>36179W5D6</cusip>
	<externalpoolnum>MA8044</externalpoolnum>
	<pop>256</pop>
	<pooleddate>2022/04/21</pooleddate>
	<allocateddate>2022/04/21</allocateddate>
	<submissiondate>2022/04/21</submissiondate>
	<gestation line="BAML">
		<initialpayment>76875285.78</initialpayment>
		<holdbackamount>2378302.20</holdbackamount>
		<fundingdate>2022/04/25</fundingdate>
		<currentliborrate>0.698</currentliborrate>
		<libor>0.698</libor>
		<applicablepercent>1.375</applicablepercent>
		<discountrate>2.073</discountrate>
		<perdiemcof>0.006</perdiemcof>
		<issuedate>2022/05/01</issuedate>
		<fundingpooltype>G2SF</fundingpooltype>

	</gestation>
	<createdon>2022/04/21</createdon>
	<mipnum>MA8044</mipnum>
	<whline>BAML/BNP/CS/GS/JPM/MS/RBC/WF</whline>
	<qrmstatus id="5">Settled</qrmstatus>
	<updateddate>2022-05-02 12:08:58.617837000</updateddate>
	<wlcra>N</wlcra>
	<crt>N</crt>
	<securitydetails>
		<![CDATA[ GNMA II 30 3.5% 05/01/2052 ]]>
	</securitydetails>
	<lastmodifiedby/>
</pooldetails>
<pooldetails id="CN4862" agency="GNMA" portid="1" trnno="31455290" compid="1" isoverride="0" iscollapse="0">
	<loans/>
	<investors>
		<investor name="BARX" id="105">
			<salesprice>98.56640625</salesprice>
			<tradedate>2022/04/27</tradedate>
			<size>31601871</size>
			<brokerdealer>BARX</brokerdealer>
			<daysofinterest>1</daysofinterest>
			<settlementdate>2022/05/02</settlementdate>
		</investor>
	</investors>
	<warehouse isoverride="0">
		<issueupb line="baml">1698044.69</issueupb>
		<issueupb line="citi">0.0</issueupb>
		<issueupb line="cs">4249527.56</issueupb>
		<issueupb line="ms">0.0</issueupb>
		<issueupb line="rbs">0.0</issueupb>
		<issueupb line="rbc">17252478.48</issueupb>
		<issueupb line="jpm">317640.0</issueupb>
		<issueupb line="cash">0.0</issueupb>
		<issueupb line="db">0.0</issueupb>
		<issueupb line="barc">2335529.0</issueupb>
		<issueupb line="bnp">574120.0</issueupb>
	</warehouse>
	<totalissueupb>31601871.58</totalissueupb>
	<projecteddeliverydate>2022/05/02</projecteddeliverydate>
	<dbcertification>2022/04/26</dbcertification>
	<receivefreedate>2022/05/02</receivefreedate>
	<sma/>
	<entity>PLS</entity>
	<executiontype>MBS</executiontype>
	<pooltype>
		<![CDATA[ PLS GNII30 3.5% MULTI ]]>
	</pooltype>
	<poolterm>30</poolterm>
	<convfha>GOV</convfha>
	<fixedarm>Fixed</fixedarm>
	<spec>
		<![CDATA[ NewProd ]]>
	</spec>
	<securityrate>3.5</securityrate>
	<cusip>36179W5D6</cusip>
	<externalpoolnum>MA8044</externalpoolnum>
	<pop>95</pop>
	<pooleddate>2022/04/22</pooleddate>
	<allocateddate>2022/04/22</allocateddate>
	<submissiondate>2022/04/22</submissiondate>
	<gestation/>
	<createdon>2022/04/22</createdon>
	<mipnum>MA8044</mipnum>
	<whline>BAML/BARC/BNP/CS/GS/JPM/RBC/WF</whline>
	<qrmstatus id="3">Certified</qrmstatus>
	<updateddate>2022-05-02 11:06:16.398989000</updateddate>
	<wlcra>N</wlcra>
	<crt>N</crt>
	<securitydetails>
		<![CDATA[ GNMA II 30 3.5% 05/01/2052 ]]>
	</securitydetails>
	<lastmodifiedby/>
</pooldetails></poolList>
'