Field Mappings

The following table lists the fields in the data model and how they are mapped to the input files, datastore schema, and cube levels.

Data Model Input Files Datastore Cube Level Notes
all.As-of Date DRC Trade Level.AsOfDate all.AsOfDate AsOfDate
JTD Exposure.Trade ID DRC Trade Level.TradeId DRCBase.TradeId TradeId
all.Risk Class DRC Trade Level.RiskClass DRCBase.RiskClass Risk Class “DRC Sec non-CTP”
JTD Exposure.Risk Measure
Risk Factor.Risk Measure
Risk Measure “DRC”
JTD Exposure.Risk Factor Name
Risk Factor.Risk Factor Name
DRC Trade Level.RiskFactor DRCBase.Risk Factor Risk Factor
Tranche.Tranche
Risk Factor.Tranche
DRC Trade Level.Underlying Tranche.Tranche DRC Sec non-CTP Tranche Also Underlying
Risk Factor.Maturity DRC Trade Level.Maturity RiskFactorDescription.Maturity DRC Maturity
Tranche.Bucket DRC Trade Level.Bucket Tranche.Bucket DRC Sec non-CTP Bucket
Tranche.Seniority DRC Trade Level.Seniority Tranche.Seniority DRC Sec non-CTP Seniority “senior”
Tranche.Rating DRC Trade Level.Rating Tranche.Rating DRC Sec non-CTP Rating
Tranche.Rating Type DRC Trade Level.Rating type Tranche.Type DRC Sec non-CTP Rating Type “STC”
Tranche.Region DRC Trade Level.Region Tranche.Region DRC Sec non-CTP Region
Tranche.Asset Class DRC Trade Level.AssetClass Tranche.Asset Class DRC Sec non-CTP Asset Class
Tranche.Attachment Point DRC Trade Level.Attachment Tranche.Attachment DRC Sec non-CTP Attachment
Tranche.Detachment Point DRC Trade Level.Detachment Tranche.Detachment DRC Sec non-CTP Detachment
Tranche.Risk Weight DRC Trade Level.Risk Weight Tranche.RiskWeight
JTD Exposure.Direction DRC Trade Level.Direction DRCBase.Direction DRC Direction “long” or “short”
JTD Exposure.Market Value DRC Trade Level.MarketValue DRCBase.PresentValue