Building an enterprise material-price database: a three-channel-separated price fact table, collection-and-review workflow, and dynamic maintenance mechanism
An enterprise database holds "tradable, voucher-backed real prices" rather than published prices: build market prices/published prices/vendor quotations as three separately classified channels, never mixed, dominated by transaction prices; the core is a traceable price fact table (material identifier + price attributes + region and period + source voucher + quality status), supported by a material master-data table, a supplier table, and an inquiry ledger; transaction data updates in real time, estimate/approximate-estimate libraries adjust monthly/quarterly, and prices without vouchers are not entered.
Applicable Codes
- T/ZBD 100.1-2022 建设工程造价数据建设通用标准
- DBJ/T 15-153-2019 广东省建设项目全过程造价管理规范
- GB/T 51095-2015 建设工程造价咨询规范
- GB/T 50500-2024 建设工程工程量清单计价标准
- GB/T 51290-2018 建设工程造价指标指数分类与测算标准
Topic Positioning
The complete build path for an enterprise material-price database: the three-channel-separated price system, the traceable "price fact table" data structure, the multi-channel collection and review workflow, the dynamic maintenance mechanism, and the linkage with tender quotation, contract price adjustment, and indicator analysis.
Core Conclusions
Four build steps: (1) define goals — tender quotation needs speed and freshness, contract price adjustment must retain price sources and vouchers, budget compilation links to quota base-period prices, and cost analysis needs tax-exclusive price and other fields. (2) Build the model — the core is the price fact table: material code/name/specification/unit, price type (market/published/vendor), tax-inclusive flag and rate, region (precise to county/district level), period and price-collection date, source channel and voucher number, entry clerk/reviewer, quality status; supported by a material master-data table, supplier table, and inquiry ledger. (3) Build the collection system — market prices are dominated by real transactions (internal procurement platforms, public resource trading platforms, material trading platforms, manual inquiries); multi-party inquiries and price comparison fill the inquiry ledger, then are reviewed and entered; published prices and vendor quotations are built separately as reference comparisons only and never mixed with market prices. (4) Dynamic maintenance — transaction-cost data updates in real time to reflect factor prices at and after the tender time point; the estimate/approximate-estimate library adjusts monthly/quarterly; expired prices move to the history table; prices without vouchers are not entered.
Applicable Boundaries
Applies to enterprise cost-data infrastructure (material price management for building and municipal works); not applicable to one-off price taking for pricing assembly (see the "market-inquiry pricing" card) or to government published-price releases themselves. Prices in the database must carry vouchers and periods to support contract price adjustment (GB/T 50500-2024 Appendix A: both base-period and measurement-period prices must state their sources); data of different regions, cost types, or periods must not be mixed (GB/T 51290-2018 four-dimension distinction).
Further Reading
T/ZBD 100.1-2022 "General standard for construction cost data development" Clauses 7.2.3, 7.2.4, 7.3.1, 7.3.2; DBJ/T 15-153-2019 "Specification for whole-process cost management of construction projects in Guangdong" Clauses 3.7.4, 7.6.2, 7.6.4; GB/T 51095-2015 "Code for construction cost consultancy" Clause 3.5.2; GB/T 50500-2024 Appendix A price-information adjustment method; GB/T 51290-2018 Clauses 3.0.2, 3.0.3.