4 Period Decimal (13,3) idb_pd_sup_purchases / Supplier pd_sup_deemed_take Deemed Take 5 Unadjusted Decimal (13,3) idb_pd_sup_purchases / Supplier unadj_sup_deemed_take Deemed Take 6 Supplier Decimal (13,3) idb_pd_sup_purchases / Spill Adjusted sup_pd_weighted_consum Take (Supplier Period Weighted Consumption) 7 Total Period Decimal (13,3) idb_ssr_run_gsp_group_pds / NPG total_pd_npg_spill 8 Total Period Decimal (13,3) idb_ssr_run_gsp_group_pds / Weighted total_pd_weighted_consum Consumption 9 GSP Group Decimal (18,9) idb_ssr_run_gsp_group_pds / Correction gsp_group_cctn_factor Factor 10 CCC Decimal (13,3) A derived value formed by Aggregated summing Supplier idf_agtd_sup_pd_consums / Consumption agtd_sup_consum across all Consumption Component Classes for a supplier 11 CCC Decimal (13,3) A derived value formed by Aggregated summing Supplier Line idf_agtd_sup_pd_consums / Loss agtd_sup_line_loss across all CCC for a supplier 12 CCC Decimal (13,3) A derived value formed by Corrected summing Supplier idf_agtd_sup_pd_consums / Consumption corrected_sup_consum across all Consumption Component Classes for a supplier 13 CCC Decimal (13,3) A derived value formed by Corrected summing Supplier Line idf_agtd_sup_pd_consums / Loss corrected_sup_line_loss across all CCC for a supplier TOT Field Field Name Type Source / Value 1 Record Type text(3) = TOT 2 Daily Supplier Decimal (13,3) idb_pd_sup_purchases / Deemed Take pd_sup_deemed_take summed for all periods of the day 3 Daily Decimal (13,3) idb_pd_sup_purchases / Unadjusted unadj_sup_deemed_take summed Supplier for all periods of the day Deemed Take
4 Period Supplier Deemed Take Decimal (13,3) idb_pd_sup_purchases / pd_sup_deemed_take 5 Unadjusted Supplier Deemed Take Decimal (13,3) idb_pd_sup_purchases / unadj_sup_deemed_take 6 Supplier Adjusted Take (Supplier Period Weighted Consumption) Decimal (13,3) idb_pd_sup_purchases / sup_pd_weighted_consum 7 Total Period NPG Spill Decimal (13,3) idb_ssr_run_gsp_group_pds / total_pd_npg_spill 8 Total Period Weighted Consumption Decimal (13,3) idb_ssr_run_gsp_group_pds / total_pd_weighted_consum 9 GSP Group Correction Factor Decimal (18,9) idb_ssr_run_gsp_group_pds / gsp_group_cctn_factor 10 CCC Aggregated Supplier Consumption Decimal (13,3) A derived value formed by summing idf_agtd_sup_pd_consums / agtd_sup_consum across all Consumption Component Classes for a supplier 11 CCC Aggregated Supplier Line Loss Decimal (13,3) A derived value formed by summing idf_agtd_sup_pd_consums / agtd_sup_line_loss across all CCC for a supplier 12 CCC Corrected Supplier Consumption Decimal (13,3) A derived value formed by summing idf_agtd_sup_pd_consums / corrected_sup_consum across all Consumption Component Classes for a supplier 13 CCC Corrected Supplier Line Loss Decimal (13,3) A derived value formed by summing idf_agtd_sup_pd_consums / corrected_sup_line_loss across all CCC for a supplier TOT Field Field Name Type Source / Value 1 Record Type text(3) = TOT 2 Daily Supplier Deemed Take Decimal (13,3) idb_pd_sup_purchases / pd_sup_deemed_take summed for all periods of the day 3 Daily Unadjusted Supplier Deemed Take Decimal (13,3) idb_pd_sup_purchases / unadj_sup_deemed_take summed for all periods of the day
SVAAISRA_Technical_Spec_redlined_v27.2_CP1418.docx