skills/medalist-rating-analyzer/references/pillar_rating_input_data.md

# Pillar Rating Input Data

Reference table of pillar rating input data points, used by `scripts/pillar_data_query.py` (`get_pillar_data_id`) to look up datapoint IDs by pillar and management type.

| Pillar | Active/Passive | ID | Name |
|---|---|---|---|
| Process | Active | ZS71V | Information Ratio 1-Year - Active Process Pillar |
| Process | Active | ODA4H | Information Ratio 1-Year - Ranked - Active Process Pillar |
| Process | Active | MVD74 | Information Ratio 3-Year - Active Process Pillar |
| Process | Active | USMSQ | Information Ratio 3-Year - Ranked - Active Process Pillar |
| Process | Active | IRTWI | Information Ratio 5-Year - Active Process Pillar |
| Process | Active | V5D4Z | Information Ratio 5-Year - Ranked - Active Process Pillar |
| Process | Active | O84GJ | Brand / Asset Class Risk Adjusted Success Ratio 3-Year - Active Process Pillar |
| Process | Active | FWVGC | Brand / Asset Class Risk Adjusted Success Ratio 3-Year - Ranked - Active Process Pillar |
| Process | Active | SKB3U | Brand / Asset Class Risk Adjusted Success Ratio 5-Year - Active Process Pillar |
| Process | Active | TJU6R | Brand / Asset Class Risk Adjusted Success Ratio 5-Year - Ranked - Active Process Pillar |
| Process | Active | HS3ZZ | Brand / Asset Class Risk Adjusted Success Ratio 10-Year - Active Process Pillar |
| Process | Active | CXWKB | Brand / Asset Class Risk Adjusted Success Ratio 10-Year - Ranked - Active Process Pillar |
| Process | Active | FLU1U | Size/Style Drift 3-Year - Ranked - Active Process Pillar |
| Process | Active | W0S1A | Weighted R-Squared - Ranked - Active Process Pillar |
| Process | Passive | LMAHG | Active vs. Passive Information Ratio 10-Year - Passive Process Pillar |
| Process | Passive | WCAIL | Active vs. Passive Information Ratio 10-Year - Ranked - Passive Process Pillar |
| Process | Passive | MCRVZ | Average Active vs. Passive Information Ratio 3-Year - Passive Process Pillar |
| Process | Passive | YL2VE | Average Active vs. Passive Information Ratio 3-Year - Ranked - Passive Process Pillar |
| Process | Passive | SK7HY | Tracking Error 1-Year - Passive Process Pillar |
| Process | Passive | WOW0N | Tracking Error 1-Year - Ranked - Passive Process Pillar |
| Process | Passive | NPCA1 | Tracking Error 3-Year - Passive Process Pillar |
| Process | Passive | PZ90B | Tracking Error 3-Year - Ranked - Passive Process Pillar |
| Process | Passive | KY78O | R-Squared 3-Year - Passive Process Pillar |
| Process | Passive | CPTPE | R-Squared 3-Year - Ranked - Passive Process Pillar |
| Process | Passive | OI3FD | Average Market Cap - Passive Process Pillar |
| Process | Passive | JAFNU | Average Market Cap - Ranked - Passive Process Pillar |
| Process | Passive | L3NN1 | Equity Sector Euclidean Distance From Index - Passive Process Pillar |
| Process | Passive | PCYYI | Equity Sector Euclidean Distance From Index - Ranked - Passive Process Pillar |
| Process | Passive | ODTGR | Size Factor Exposure - Passive Process Pillar |
| Process | Passive | ZU84U | Size Factor Exposure - Ranked - Passive Process Pillar |
| Process | Passive | GO46H | Value/Growth Factor Exposure - Passive Process Pillar |
| Process | Passive | X4KM8 | Value/Growth Factor Exposure - Ranked - Passive Process Pillar |
| Process | Passive | EMN2J | % of Assets in Top 10 Holdings - Passive Process Pillar |
| Process | Passive | R5VUX | Number of Equity Holdings - Passive Process Pillar |
| Process | Passive | K3P97 | Number of Equity Holdings - Ranked - Passive Process Pillar |
| Process | Passive | DE530 | Number of Equity Holdings / Category Average - Passive Process Pillar |
| Process | Passive | MY8Q8 | Turnover Ratio - Passive Process Pillar |
| Process | Passive | AZ5TQ | Standard Deviation 1-Year - Passive Process Pillar |
| Process | Passive | OWTVQ | Standard Deviation 1-Year - Ranked - Passive Process Pillar |
| Process | Passive | T37NV | Standard Deviation 3-Year - Passive Process Pillar |
| Process | Passive | A30JF | Standard Deviation 3-Year - Ranked - Passive Process Pillar |
| Process | Passive | JXBD1 | Surveyed Effective Duration - Passive Process Pillar |
| Process | Passive | KCPFY | Surveyed Effective Duration - Ranked - Passive Process Pillar |
| Process | Passive | N136Q | Surveyed Average Credit Rating - Passive Process Pillar |
| Process | Passive | B4P9O | Surveyed Average Credit Rating - Ranked - Passive Process Pillar |
| Process | Passive | IJ6IY | Surveyed Yield to Maturity - Passive Process Pillar |
| Process | Passive | BRUNH | Surveyed Yield to Maturity - Ranked - Passive Process Pillar |
| Process | Passive | PVYH2 | Number of Bond Holdings - Passive Process Pillar |
| Process | Passive | NP3DM | Number of Bond Holdings / Category Average - Passive Process Pillar |
| Parent | Passive/Active | CW7G7 | Average Brand Obsolete Rate 5-Year - Parent Pillar |
| Parent | Passive/Active | DX37P | Brand Active/Passive Fee Rank - Parent Pillar |
| Parent | Passive/Active | EO0U8 | Average Brand Longest Manager Tenure - Ranked - Parent Pillar |
| Parent | Passive/Active | HXDS7 | Brand Risk-Adjusted Success Ratio 10-Year - Parent Pillar |
| Parent | Passive/Active | J25I9 | Average Brand Retention Ratio 5-Year - Parent Pillar |
| Parent | Passive/Active | L7CL1 | Average Brand Longest Manager Tenure - Parent Pillar |
| Parent | Passive/Active | MPFS6 | Brand Risk-Adjusted Success Ratio 3-Year - Parent Pillar |
| Parent | Passive/Active | SLP0O | Brand Risk-Adjusted Success Ratio 5-Year - Parent Pillar |
| People | Active | A9SD3 | Average Brand Retention Ratio 5-Year - Active People Pillar |
| People | Active | E89P9 | Average Brand Information Ratio 1-Year - Ranked - Active People Pillar |
| People | Active | I4JKP | Average Brand Longest Manager Tenure - Ranked - Active People Pillar |
| People | Active | LGFDO | Manager Information Ratio 1-Year - Active People Pillar |
| People | Active | MYVT1 | Manager Information Ratio 5-Year - Active People Pillar |
| People | Active | N4XVF | Average Brand Information Ratio 5-Year - Ranked - Active People Pillar |
| People | Active | O1VSB | Max Manager Ownership - Active People Pillar |
| People | Active | QOKWE | Manager Information Ratio 3-Year - Ranked - Active People Pillar |
| People | Active | QPEAA | Average Brand Information Ratio 5-Year - Active People Pillar |
| People | Active | SPKC4 | Manager Information Ratio 5-Year - Ranked - Active People Pillar |
| People | Active | SSYRV | Manager Information Ratio 1-Year - Ranked - Active People Pillar |
| People | Active | TVDB1 | Average Brand Information Ratio 3-Year - Ranked - Active People Pillar |
| People | Active | W0PWG | Fund Manager Successful Experience - Active People Pillar |
| People | Active | W2YIY | Average Brand Information Ratio 3-Year - Active People Pillar |
| People | Active | W8ESR | Average Brand Retention Ratio 5-Year - Ranked - Active People Pillar |
| People | Active | Y79S8 | Average Brand Longest Manager Tenure - Active People Pillar |
| People | Active | YQZ2E | Fund Manager Successful Experience - Ranked - Active People Pillar |
| People | Active | Z2NJG | Manager Information Ratio 3-Year - Active People Pillar |
| People | Active | ZDEUY | Average Brand Information Ratio 1-Year - Active People Pillar |