-
Notifications
You must be signed in to change notification settings - Fork 0
/
sse_Dataset_ModelingPD_dtPDModel.xmi
4 lines (4 loc) · 1.14 KB
/
sse_Dataset_ModelingPD_dtPDModel.xmi
1
2
3
4
<?xml version="1.0" encoding="ASCII"?>
<sse:Dataset xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:sse="http://www.neoflex.ru/meta/sse" name="ModelingPD_dtPDModel" shortName="dtPDModel" description="Preparing data for PD models" interpreter="SQL" expression="SELECT ID_Account,
 ID_Customer,
 C_Portfolio, 
 C_ProductType, 
 D_StartDate, 
 D_MaturityDate, 
 D_ReferenceDate, 
 N_DaysInArrears, 
 F_Default, 
 N_OutstandingPrincipalAmount, 
 N_AccruedInterestAmount, 
 N_PastDueAmount, 
 N_WriteOffAmount, 
 N_CreditLineAmount, 
 N_UsedCreditLineAmount, 
 C_CreditLineType,
 AuxField1,
 AuxField2,
 AuxField3,
 AuxField4,
 RefMonth
 FROM dtAccounts 
 WHERE D_StartDate >= date_format('2001-01-01', 'y-M-d') 
 ORDER BY ID_Customer, ID_Account, D_ReferenceDate">
<auditInfo changeUser="admin" changeDateTime="2019-06-21T13:57:14.086+0300" createUser="mtugushev" createDateTime="2019-05-13T18:36:53.569+0300"/>
</sse:Dataset>