134 lines
2.8 KiB
SQL
134 lines
2.8 KiB
SQL
CREATE OR REPLACE FORCE VIEW OU_CSDB.DEBT_DAILY_MARS
|
|
AS
|
|
SELECT
|
|
A_KEY ,
|
|
NEWUPDATED ,
|
|
IDLOADDATE_DIM ,
|
|
EXTERNALCODE_ISIN ,
|
|
EXTERNALCODETYPE_NC ,
|
|
EXTERNALCODE_NATIONAL ,
|
|
IDIRINSTRUMENT ,
|
|
SHORTNAME ,
|
|
IDIRDEPOSITORY ,
|
|
IDIRDEBTTYPE ,
|
|
IDIRASSETSECTYPE ,
|
|
IDIRCLASSIFICATIONCODE_CFI ,
|
|
IDIRCLASSIFICATIONCODE_ESAI ,
|
|
IDIRCLASSIFICATIONCODE_ESAI_DM ,
|
|
IDIRCURRENCY_NOMINAL ,
|
|
AMOUNTISSUED ,
|
|
AMOUNTOUTSTANDING ,
|
|
AMOUNTOUTSTANDING_EUR ,
|
|
POOLFACTOR ,
|
|
ISSUEPRICE ,
|
|
IDISSUEDATE ,
|
|
IDIRCOUPONTYPE ,
|
|
IDIRCOUPONFREQUENCY ,
|
|
IDIRCURRENCY_COUPON ,
|
|
COUPONRATE ,
|
|
COUPONDATE ,
|
|
IDIRREDEMPTIONTYPE ,
|
|
IDIRREDEMPTIONFREQUENCY ,
|
|
IDIRCURRENCY_REDEMPTION ,
|
|
REDEMPTIONPRICE ,
|
|
IDMATURITYDATE ,
|
|
IDIRORGANISATIONALIASTYPE_IS ,
|
|
ISSUERSOURCECODE ,
|
|
ISSUEREXTERNALCODE_MFI ,
|
|
ISSUEREXTERNALCODE_BIC ,
|
|
ISSUEREXTERNALCODE_BEI ,
|
|
IDIRORGANISATION_ISSUER ,
|
|
ISSUERNAME ,
|
|
IDIRCOUNTRY ,
|
|
IDIRCOUNTRY_DM ,
|
|
IDIRCLASSIFICATIONCODE_ESAO ,
|
|
IDIRCLASSIFICATIONCODE_ESAO_DM ,
|
|
IDIRCLASSIFICATIONCODE_NACE ,
|
|
PUBLICATIONPRICEDATE ,
|
|
PUBLICATIONPRICE ,
|
|
PUBLICATIONPRICETYPE ,
|
|
PUBLICATIONPRICEQUOTATIONBASIS ,
|
|
MONTHLYAVERAGEPRICE ,
|
|
ACCRUALSTARTDATE ,
|
|
DEBTACCRUALDEBTOR ,
|
|
DEBTACCRUALDEBTOR_DM ,
|
|
DEBTACCRUALCREDITOR ,
|
|
DEBTACCRUALCREDITOR_TYP ,
|
|
ACCRUEDINTEREST ,
|
|
YTMNONOPTIONADJUSTED ,
|
|
ESCB_ISSUER_IDENT ,
|
|
ESCB_ISSUER_IDENT_TYP ,
|
|
IDUDCMPPARTY ,
|
|
AMOUNTOUTSTANDINGTYPE ,
|
|
MARKETCAPITALISATION ,
|
|
MARKETCAPITALISATION_EUR ,
|
|
VA_SECURITYSTATUS ,
|
|
VA_INSTRSUPPLEMENTARYCLASS ,
|
|
VA_RESIDUALMATURITYCLASS ,
|
|
VA_ISINSEC ,
|
|
VA_ISELIGIBLEFOREADB ,
|
|
IDIRCLASSIFICATIONCODE_ESAI10 ,
|
|
IDIRCLASSIFICATIONCODE_ESAO10 ,
|
|
IDIRDEBTTYPE_N ,
|
|
SENIORITY ,
|
|
ISSUEREXTERNALCODE_LEI ,
|
|
A_WORKFLOW_HISTORY_KEY AS A_ETL_LOAD_SET_FK ,
|
|
INSTR_ESA2010_CLASS_VALUETYPE ,
|
|
ISS_ESA2010_CLASS_VALUETYPE ,
|
|
SEC_STATUS_DATE ,
|
|
GROUP_TYPE ,
|
|
HAS_EMBEDDED_OPTION ,
|
|
VOLUME_TRADED ,
|
|
PRIMARY_LISTING_NAME ,
|
|
PRIM_LISTING_RESIDENCY_COUNTRY ,
|
|
INSTR_PORTFOLIO_FLAGS ,
|
|
BOND_DURATION ,
|
|
RESIDUAL_MATURITY ,
|
|
ORIGINAL_MATURITY ,
|
|
CFIN_CLASSIFICATION ,
|
|
COUPONFIRSTPAYMENTDATE ,
|
|
COUPONLASTPAYMENTDATE ,
|
|
COUPONRATEUNDERLYINGCODE_ISIN ,
|
|
COUPONRATESPREAD ,
|
|
COUPONRATEMULTIPLIER ,
|
|
COUPONRATECAP ,
|
|
COUPONRATEFLOOR ,
|
|
IDISSUEDATE_TRANCHE ,
|
|
ISSUEPRICE_TRANCHE ,
|
|
VA_ISPRIVATEPLACEMENT ,
|
|
RIAD_CODE ,
|
|
RIAD_OUID ,
|
|
ESG1 ,
|
|
ESG2 ,
|
|
ESG3 ,
|
|
STRIP ,
|
|
DEPOSITORY_RECEIPT ,
|
|
RULE_144A ,
|
|
REG_S ,
|
|
WARRANT ,
|
|
CSEC_RELEVANCE_STOCK ,
|
|
CSEC_RELEVANCE_GROSS_ISSUANCE ,
|
|
CSEC_RELEVANCE_REDEMPTION ,
|
|
ACCRUING_COUPON ,
|
|
ACCRUING_DISCOUNT ,
|
|
CAST (NULL AS VARCHAR2(4000 )) AS STEPID ,
|
|
CAST (NULL AS VARCHAR2(4000 )) AS PROGRAMNAME ,
|
|
CAST (NULL AS VARCHAR2(4000 )) AS PROGRAMCEILING ,
|
|
CAST (NULL AS VARCHAR2(4000 )) AS PROGRAMSTATUS ,
|
|
CAST (NULL AS VARCHAR2(4000 )) AS ISSUERNACE21SECTOR ,
|
|
CAST (NULL AS VARCHAR2(4000 )) AS INSTRUMENTQUOTATIONBASIS ,
|
|
PLACEHOLDER38 ,
|
|
PLACEHOLDER39 ,
|
|
PLACEHOLDER40 ,
|
|
PLACEHOLDER41 ,
|
|
PLACEHOLDER42 ,
|
|
PLACEHOLDER43 ,
|
|
PLACEHOLDER44 ,
|
|
PLACEHOLDER45 ,
|
|
PLACEHOLDER46 ,
|
|
PLACEHOLDER47 ,
|
|
PLACEHOLDER48 ,
|
|
PLACEHOLDER49 ,
|
|
PLACEHOLDER50
|
|
from
|
|
ODS.CSDB_DEBT_DAILY_ODS; |