2 Daily Profiled Decimal Supplier Profiled EAC and Profiled SPM Total (13,3) Unmetered consumption summed for all EAC settlement periods 3 Daily Profiled Decimal Supplier Profiled AA summed for all SPM Total (13,3) settlement periods Annualised Advance DUoS Report : Domain Data HD2 Field Field Name Type Source / Value 1 Record Type text(3) = HD2 2 Settlement Date idb_ssr_runs / sett_date Date 3 Settlement text(2) idb_ssr_runs / sett_code Code 4 Settlement text(30) idb_sett_types / description Code Description 5 SSR Run Date Date idb_ssr_runs / ssr_run_date 6 SSR Run integer(7) idb_ssr_runs / ssr_run_number Number 7 SSR Run Type text(2) idb_ssr_runs / ssr_run_type_id Id SU2 (Supplier Report) Field Field Name Type Source / Value 1 Record Type text(3) = SU2 2 Supplier Id text(4) idf_agtd_sup_pd_consums / sup_mkt_ppt_id 3 Supplier Name text(40) idb_mkt_ppts / mkt_ppt_name SUP (Distributor Report) Field Field Name Type Source / Value 1 Record Type text(3) = SUP 2 Supplier Id text(4) idf_sup_purchase_matrices / sup_mkt_ppt_id 3 Supplier text(40) idb_mkt_ppts / mkt_ppt_name Name 4 Pool Member text(4) idb_market_ppt_roles / pool_member_id Id CCC Field Field Name Type Source / Value 1 Record Type text(3) = CCC 2 Consumption integer(2) idb_consum_comp_class / Component consum_comp_class_id Class Id
2 Daily Profiled SPM Total EAC Decimal (13,3) Supplier Profiled EAC and Profiled Unmetered consumption summed for all settlement periods 3 Daily Profiled SPM Total Annualised Advance Decimal (13,3) Supplier Profiled AA summed for all settlement periods DUoS Report : Domain Data HD2 Field Field Name Type Source / Value 1 Record Type text(3) = HD2 2 Settlement Date Date idb_ssr_runs / sett_date 3 Settlement Code text(2) idb_ssr_runs / sett_code 4 Settlement Code Description text(30) idb_sett_types / description 5 SSR Run Date Date idb_ssr_runs / ssr_run_date 6 SSR Run Number integer(7) idb_ssr_runs / ssr_run_number 7 SSR Run Type Id text(2) idb_ssr_runs / ssr_run_type_id SU2 (Supplier Report) Field Field Name Type Source / Value 1 Record Type text(3) = SU2 2 Supplier Id text(4) idf_agtd_sup_pd_consums / sup_mkt_ppt_id 3 Supplier Name text(40) idb_mkt_ppts / mkt_ppt_name SUP (Distributor Report) Field Field Name Type Source / Value 1 Record Type text(3) = SUP 2 Supplier Id text(4) idf_sup_purchase_matrices / sup_mkt_ppt_id 3 Supplier Name text(40) idb_mkt_ppts / mkt_ppt_name 4 Pool Member Id text(4) idb_market_ppt_roles / pool_member_id CCC Field Field Name Type Source / Value 1 Record Type text(3) = CCC 2 Consumption Component Class Id integer(2) idb_consum_comp_class / consum_comp_class_id
SVAAISRA_Technical_Spec_redlined_v27.2_CP1418.docx