CDS Views for Commodity Derivative Risk Management (FIN-FSCM-CMM-RSK)

CDS View NameDescriptionSQL View Name
C_CMMDTYMTMFINCURVALSQRYDerivative MTM Current QueryCDRVTVMTMCURQRY
C_CMMDTYMTMFINENDOFDAYQRYDerivative MTM End-Of-Day QueryCDRVTVMTMEODQRY
C_CMMDTYPNLFINVALUEQUERYDerivative PnL QueryCDRVTVPNLQRY
E_FINANCIALINSTRCHARACTERISTICExtension View for DerivativesEVFINDDB
I_CMMDTYCommodityICMMDTY
I_CMMDTYCATEGORYCommodity CategoryICMMDTYCATEGORY
I_CMMDTYCATEGORYTEXTCommodity Category TextICMMDTYCATEGORYT
I_CMMDTYFINSYNCRESULTDerivative Basic Layer: Select data from FINSYNCIFINSYNC
I_CMMDTYMTMFINVALUESDerivative MTM Interface LayerIDRVTVMTMIL
I_CMMDTYMTMFINVALUESCUBEDerivative MTM CubeIDRVTVMTMCUBE
I_CMMDTYPNLFINVALUESDerivative PnL Interface LayerICMMDTYPNLFIN
I_CMMDTYPNLFINVALUESCUBEDerivative PnL CubeIDRVTVPNLCUBE
I_CMMDTYPRICEEXPOSURECATEGORYCommodity Price Exposure CategoryICOEXCAT
I_CMMDTYPRICEEXPOSURECATEGORYTCommodity Price Exposure Category TextICOEXCATT
I_CMMDTYPRICEEXPSRDELIVERYSTSCommodity Price Exposure Delivery StatusICOEXDELSTS
I_CMMDTYPRICEEXPSRDELIVERYSTSTCommodity Price Exposure Delivery Status TextICOEXDELSTST
I_CMMDTYPRICEEXPSRINVCSTSTCommodity Price Exposure Invoicing Status TextICOEXINVCSTST
I_CMMDTYPRICEEXPSRINVOICINGSTSCommodity Price Exposure Invoicing StatusICOEXINVCSTS
I_CMMDTYPRICEFIXATIONSTATUSCommodity Price Fixation StatusICMMDTYPRFIXSTS
I_CMMDTYPRICEFIXATIONSTATUSTCommodity Price Fixation Status TextICMMDTYPRFIXSTST
I_CMMDTYPRICERISKPROFILECommodity Price Risk ProfileICOEXRPFL
I_CMMDTYPRICERISKPROFILETCommodity Price Risk Profile TextICOEXRPFLT
I_CMMDTYTEXTCommodity TextICMMDTYT
I_CMMDTYTYPECommodity TypeICMMDTYTYPE
I_CMMDTYTYPETEXTCommodity Type TextICMMDTYTYPET
I_COMMODITYTRANSACTIONTYPECommodity Transaction TypeICOEXTTYP
I_COMMODITYTRANSACTIONTYPETCommodity Transaction Type TextICOEXTTYPT
I_DERIVATIVECMMDTYEXPSRDrvtv Basic Layer Select data from VFINDIVFINDDB
I_DERIVATIVEEXPSRPOSITIONDerivative Position Derivative CubeIVFINDCUBE
I_DRVTVPOSINTERFACELAYERDerivative Position Interface Layer ExtensionIVFINDIL
I_FIRSTCMMDTYGROUPFirst Customer Specific Commodity GroupIFIRSTCMMDTYGRP
I_FIRSTCMMDTYGROUPTEXTFirst Customer Specific Commodity Group NameIFIRSTCMMDTYGRPT
I_SECONDCMMDTYGROUPSecond Customer Specific Commodity GroupISECNDCMMDTYGRP
I_SECONDCMMDTYGROUPTEXTSecond Customer Specific Commodity Group NameISECNDCMMDTYGRPT
I_VERSIONEDFINEVALRSLTSDerivative Basic Layer : Selecting data from VFINRIVFINRDB
I_VERSIONEDRISKADMINDATABasic Layer : Selecting data from CMMF_SVSTATEISTATEDB
P_CMMDTYPNLFINVALUEDerivative PnL Interface LayerPCMMDTYPNLFIN
P_DERIVATIVEPOSADPTRLAYERDerivative Positions Adapter LayerPVFINDAL
P_DERIVATIVEPOSBUSLAYERDerivative Position Business LayerPVFINDBL
P_DERIVATIVEPOSDODTECHLAYERTechnical Layer for Day over DayPVFINDDODTL
P_DERIVATIVEPOSINTERFACELAYERDerivative Position Interface LayerPVFINDIL
P_DERIVATIVEPOSOPTNDELTADerivative Position Option Delta FactorPOPTDELTAPOS
P_DERIVATIVEPOSTECHLAYERTechnical layer for Current valuesPVFINDCURRTL
P_DRVTVBEGINNINGPOSPNLDerivative Beginning Position Technical LayerPDRVTVBPPNL
P_DRVTVBEGINNINGPOSPNLCALCDerivative Beginning Position Business LayerPDRVTVBPPNLCALC
P_DRVTVCALCPOSITIONDATADerivative Calculation Position Data for FWERPDRVTVCALCPOS
P_DRVTVCLASSPOSITIONDATADerivative Class Position Data for FWERPDRVTVCLASSPOS
P_DRVTVEXERCISERIGHTSCDS for FWER Exercised RightsPDRVTVFWER
P_DRVTVFLOWSSELECTORDerivative Persistent Flows Selector for FWERPDRVTVFLOWS
P_DRVTVINSTRAVGGRPGDerivative Technical Layer : Average GroupingPVFINDAVGTL
P_DRVTVINSTRDODALLVERSIONDerivative position DOD All Versions Technical LayerPDRVTVDODALL
P_DRVTVINSTRDODAVGGRPGDerivative DOD Average GroupingPVFINDDODAVGTL
P_DRVTVINSTRDODQTYCNSLDTNDerivative DOD Quantity ConsolidationPVFINDDODQTY
P_DRVTVINSTRENDOFDAYAVGGRPGDerivative EOD Average GroupingPVFINDEODAVGTL
P_DRVTVINSTRENDOFDAYQTYCNSLDTNDerivative EOD Quantity ConsolidationPVFINDEODQTY
P_DRVTVINSTRMATGRPGDerivative Instrument Maturity Code GroupingPVFINDMATCDGRP
P_DRVTVINSTRQTYCNSLDTNDerivative Current TL : Quantity ConsolidationPVFINDCURQTY
P_DRVTVLOTDATADerivative Lot ID Data for FWERPDRVTVLOTDATA
P_DRVTVMTMALDerivative MTM Adapter LayerPDRVTVMTMAL
P_DRVTVMTMBLDerivative MTM Business LayerPDRVTVMTMBL
P_DRVTVNEWACTYPNLDerivative New Activity Technical LayerPDRVTVNAPNL
P_DRVTVNEWACTYPNLCALCDerivative New Activity Business LayerPDRVTVNAPNLCALC
P_DRVTVPOSENDOFDAYTECHLAYERTechnical Layer for End of DayPVFINDEODTL
P_DRVTVPOSILDerivative Position Interface LayerPDRVTVPOSIL
P_DRVTVSECURITYDATADerivative Security ID Data for FWERPDRVTVSECID
P_DRVTVSECURITYIDDATADerivative Security Class Data for FWERPDRVTVSECCLASS
P_EVALRSLTSCURLTSTEvaluation Current Latest RecordsPVFINRCURLATEST
P_EVALRSLTSCURTLEvaluation Results Current Technical LayerPEVALRSLTSCURTL
P_EVALRSLTSCURUNIONEvaluation Results Current UnionPVFINRCURTLUNION
P_EVALRSLTSCURVALSEvaluation Current RecordsPVFINRCURVALUES
P_EVALRSLTSDODPNLEvaluation Result DOD Technical LayerPEVALRSLTSDODPNL
P_EVALRSLTSENDOFDAYLTSTEvaluation EOD Latest RecordsPVFINREODLATEST
P_EVALRSLTSENDOFDAYPNLEvaluation Result EOD Technical LayerPEVALRSLTSEODPNL
P_EVALRSLTSENDOFDAYTLEvaluation Result EOD Technical LayerPEVALRSLTSTL
P_EVALRSLTSENDOFDAYUNIONEvaluation EOD Union Technical LayerPVFINREODTLUNION
P_EVALRSLTSENDOFDAYVALSEvaluation EOD RecordsPVFINREODVALUES
P_EVALRSLTSMTMDODTLEvaluation Result MTM DOD Technical LayerPEVALMTMDODTL
P_EXPOSUREBUCKETExposure BucketPEXPOSUREBUCKET
P_EXPOSUREBUCKET_FINANCIALExposure Bucket dimension for financial transactionsPEXPBUCKETFIN
P_EXPOSUREBUCKET_HRExposure Bucket hedging relationshipPEXPBUCKET
P_EXPOSUREBUCKET_HR_VERSIONHedging Relationship version by date and timePEXPBUCKETHRV
P_EXPOSUREBUCKET_PHYSICALExposure Bucket dimension for physical transactionsPEXPBUCKETPHYS
P_VERFINEVALOPTNDELTAUNIONDerivative Position VFINR option Delta Union viewPVFINODLTAUNION