Supplier BM Unit Report 18,425 736,997 145 106,864,585 Supplier Purchase Matrix Report 21,718 2,171,807 145 314,912,000 Deemed Take 637 87,906 145 12,746,370 Supplier Purchase 637 50,960 145 7,389,200 GSP Group Consumption Totals Report 19,968 1,717,248 145 249,000,960 TUOS 218,863 9,411,109 5 47,055,545 BM Unit Supplier Take Energy Volume Report 196,390 4,320,580 5 21,602,900 BM Unit SVA Gross Demand Report 196,390 4,320,580 5 21,602,900 PR - SSC 71,940 1,798,500 54 97,119,000 PR - Standing Profile Data 2,984 298,400 54 16,113,600 PR - Daily Profile Data 539,565 161,869,500 32 5,179,824,000 PR - Daily Profile Extract 20,709 455,598 14 6,378,372 PR - Contact Interval Data Report 1,324 33,100 29 959,900 Pool Reports Report Name Records per Report Report Size (bytes) Per AFYC Recalculation Report 65,562 1,639,040 Per yearly report The derivation of these figures is detailed in Volume 4, Appendix A. Switch
2 Time Pattern Regime Id text(5) to idb_measurement_ requirements.tpr_id idb_afycs.tpr_id VSD - VSCPC Details Field Field Name Type Comments 1 Record Type text(3) = VSD 2 Profile Class Id integer(2) to idb_vscpcs.pfl_class_id idb_vmr_pfl_classes. pfl_class_id idb_afycs.pfl_class_id 3 Effective From Settlement Date date to idb_vscpcs. eff_from_sett_date 4 Effective To Settlement Date date to idb_vscpcs. eff_to_sett_date (O) SLM - Switched Load Measurement Requirement Details Field Field Name Type Comments 1 Record Type text(3) = SLM 2 Switched Load Indicator boolean to idb_vmr_pfl_classes. Switched_load_ind 3 Time Pattern Regime Id text(5) to idb_vmr_pfl_classes.tpr_id ASD - AFYCS Details Field Field Name Type Comments 1 Record Type text(3) = ASD 2 GSP Group Id text(2) to idb_afycs.gsp_group_id 3 Effective From Settlement Date date to idb_afycs. eff_from_sett_date 4 Effective To Settlement Date date to idb_afycs. eff_to_sett_date (O) AFD - Average Fraction of Yearly Consumption Details Field Field Name Type Comments 1 Record Type text(3) = AFD 2 Average Fraction of Yearly Consumption decimal (7,6) to idb_afycs.afyc 3 Time Pattern Regime Id text(5) shows which TPR record is parent Repeating structure of file:
3 Data Aggregator Name text(40) idb_mkt_ppts / mkt_ppt_name 4 Data Aggregator Type text(1) ‘H’ or ‘N’. Assign Data Aggregation Type to matching Participant Role Code (i.e. ‘N’ for role code ‘B’ and ‘H’ for role code ‘A’). 5 Data Aggregator Run Number integer(7) idb_sup_data_agtn_in_ssr_runs / data_agtn_run_number 6 Data Aggregator Run Settlement Date date idb_sup_data_agtn / sett_date GP3 Field Field Name Type Source / Value 1 Record Type text(3) = GP3 2 GSP Group Id text(2) idb_sup_data_agtn_in_ssr_runs / gsp_group_id SSA Field Field Name Type Source / Value 1 Record Type text(3) = SSA 2 SSA Settlement Run Number integer(2) idb_ssr_runs / ssa_sett_run_number 3 SSA Settlement Date date idb_ssa_sett_runs / sett_date 4 SSA Settlement Run Type text(1) idb_ssa_sett_runs / sett_run_type_id 5 CDCS Extract Number integer(2) idb_ssa_sett_runs / cdsc_extract_number Repeating Structure of the File (sort order shown in brackets):
8 SPM Total EAC MSID Count integer(8) idf_sup_purchase_matrices / spm_total_eac_msid_count 9 SPM Total Annualised Advance Decimal (13,3) idf_sup_purchase_matrices / spm_total_aa 10 SPM Total AA MSID Count integer(8) idf_sup_purchase_matrices / spm_total_aa_msid_count 11 SPM Total Unmetered Consumption Decimal (13,3) idf_sup_purchase_matrices / spm_total_unmtd_consum 12 SPM Total Unmetered MSID Count integer(8) idf_sup_purchase_matrices / spm_total_unmtd_msid_count 13 SPM Default EAC MSID Count integer(8) idf_sup_purchase_matrices / spm_dflt_eac_msid_count 14 SPM Default Unmetered MSID Count integer(8) idf_sup_purchase_matrices / spm_dflt_unmtd_msid_count Repeating structure of the file (sort order shown in brackets):
6 Corrected Supplier Consumption Decimal (13,3) idf_agtd_sup_pd_consums / corrected_sup_consum(O) 7 Corrected Supplier Line Loss Decimal (13,3) idf_agtd_sup_pd_consums / corrected_sup_line_loss(O) TOT Field Field Name Type Source / Value 1 Record Type text(3) = TOT 2 Daily CCC Aggregated Supplier Consumption Decimal (13,3) Sum of the Aggregated Supplier Consumption for all settlement periods of the day(O) 3 Daily CCC Aggregated Supplier Line Loss Decimal (13,3) Sum of the Aggregated Supplier Line Loss for all settlement periods of the day(O) 4 Daily CCC Corrected Supplier Consumption Decimal (13,3) Sum of the Corrected Supplier Consumption for all settlement periods of the day(O) 5 Daily CCC Corrected Supplier Line Loss Decimal (13,3) Sum of the Corrected Supplier Line Loss for all settlement periods of the day(O) 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 8 Supplier Id text(4) idf_agtd_sup_da_pd_consums / sup_mkt_ppt_id 9 Supplier Name text(40) idb_mkt_ppts / mkt_ppt_name GP2 Field Field Name Type Source / Value 1 Record Type text(3) = GP2 2 GSP Group Id text(2) idf_agtd_sup_da_pd_consums / gsp_group_id
2 Settlement Date Date idb_ssr_runs / sett_date 3 Settlement Code text(2) idb_ssr_runs / sett_code 4 Run Type Code text(2) idb_ssr_runs / ssr_run_type_id 5 Run Number integer(7) idb_ssr_runs / ssr_run_type_id 6 GSP Group text(2) Null RDT Field Field Name Type Source / Value 1 Record Type text(3) = RDT 2 User Name text(8) 3 Report Parameters text(30) Input SSR Run Number HDR Field Field Name Type Source / Value 1 Record Type text(3) = HDR 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 8 Supplier Id text(4) idb_pd_sup_purchases / sup_mkt_ppt_id 9 Supplier Name text(40) idb_mkt_ppts / mkt_ppt_name GSP Field Field Name Type Source / Value 1 Record Type text(3) = GSP 2 GSP Group Id text(2) idb_pd_sup_purchases / gsp_group_id 3 GSP Group Name text(30) idb_gsp_groups / gsp_group_name SPX Field Field Name Type Source / Value 1 Record Type text(3) = SPX 2 Settlement Period Id integer(2) idb_pd_sup_purchases / sett_pd_id 3 Settlement Period Label text(6) Generated by a function call
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
4 Daily Supplier Pre-Spill Adjusted Take Decimal (13,3) idb_pd_sup_purchases / sup_pd_weighted_consum summed for all periods of the day 5 Daily 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 summed for all periods of the day 6 Daily 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 summed for all periods of the day 7 Daily 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 summed for all periods of the day 8 Daily 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 summed for all periods of the day Repeating Structure of the File (sort order shown in brackets):
1 00:30 2.5000 3456 (Repeated for all settlement periods) 48 00:00 2.5000 3456 Daily Tot: 120.0000 165888 (Repeated for all CCCs relevant to the BM Unit) (Repeated for all BM Units relevant to the Supplier in GSP Group for the Data Aggregator) (Repeated for all Half Hourly Data Aggregators who have sent energy values for the Supplier and GSP Group) Page 95 _Supplier BM Unit Report ISR Agent 03/07/2000 12:46 -- End of Report --
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
3 AA/EAC Indicator text(1) idb_consum_comp_class / aa_eac_ind (O) 4 Indicator text(1) idb_consum_comp_class / actual_estimated_ind (O) 5 Data Aggregation Type text(1) idb_consum_comp_class / data_agtn_type 6 Indicator text(1) idb_consum_comp_class / mtd_unmtd_ind 7 Consumption Component Indicator text(1) idb_consum_comp_class / consum_comp_ind 8 Measurement Quantity Id text(2) idb_consum_comp_class / measurement_quantity_id 9 GSP Group Correction Scaling Factor Decimal (4,2) idb_gsp_group_correction_sf_ssr_runs / gsp_group_correction_sf SP2 Field Field Name Type Source / Value 1 Record Type text(3) = SP2 2 GSP Group Id text(2) idb_ssr_run_gsp_groups / gsp_group_id 3 GSP Group Name text(30) idb_gsp_groups / gsp_group_name 4 Settlement Period Id integer(2) idb_ssr_run_gsp_group_pds / sett_pd_id 5 Settlement Period Label text(6) Generated by a function call 6 GSP Group Correction Factor Decimal (18,9) idb_ssr_run_gsp_group_pds / gsp_group_cctn_factor
IDL PPR GSP period purchases tolerance 1 Y MPR BSR BUSTEV Report Recipient Role F Y MPR TSR TUOS Role Code Z Y MPT BSR BUSTEV Report Recipient Id Agent’s ID Y MPT CDC CDCA Participant Id Agent’s ID Y MPT SSA SSA Participant Id Agent’s ID N MPT TSR TUOS Participant Id Agent’s ID Y SYS DBV Oracle database version number Instance specific N SYS DUS No. Suppliers batched to DUoS 20 Y SYS ISV ISRA software version number Instance specific N SYS MDD Multiple Distrib Start Date N SYS MKR System Market Role G N SYS NTD Date that the New Electricity Trading Arrangements become effective expect to be N SYS ORG System Organisation Name ISR Name N SYS OSV Operating system version number Instance specific Y SYS PID System Participant ID CAPG N SYS SCO ISRA database object schema owner. Username N SYS SBV Supplier BM Unit Report SSR Run BM Unit Id Value To be supplied by the Pool N SYS SBC Supplier BM Unit Report Default BM Unit Reason Code Value (for exclusion of energy from the SSR Run) To be supplied by the Pool N SYS BSD BETTA Start Date N SYS BRD BETTA Coefficients End Date N Oracle Parameters and Optimisation The parameters listed below are identified as necessary for ISRA to work correctly. Other parameters can be set to tune the Oracle instance or run it in a certain way.
Use of Flat File Tables Flat File Record Type Size (Bytes) Per Derivation idf_agtd_sup_da_pd_consums ZHD 36 SPC 21 CON 33 File Size 1,024,026 Each ZHD + ((HHCCC*HHSUP_GSP)* SDK + (HHCCC*HHSUP_GSP)*(CON*SPD)) 26,624,676 HH data aggregator per supplier per GSP Group * HHDA_SG * GSP 133,123,380 Settlement Day *SRPSD 97,313,190,780 Retention days *RPD idf_agtd_sup_pd_consums ZHD 36 SPC 11 CON 44 File Size 1,970,180 GSP Group ZHD+((HHCCC*HHSUP_GSP + NHHCCC*NHHSUP_GSP)*SDK + 25,612,340 Settlement Run *GSP 128,061,700 Settlement Day *SRPSD 93,613,102,700 Retention *RPD
Corrected Supplier Consumption corrected_sup_consum_nn Corrected Supplier Line Loss corrected_sup_line_loss_nn Average Fraction Of Yearly Consumption idb_afycs This entity has been merged with its parent, Average Fraction of Yearly Consumption Set. The attributes “Time Pattern Regime ID” and “Average Fraction of Yearly Consumption” have been added to the parent. The merged table takes the name of the child as it more logically corresponds to what it holds. Profile Class Id pfl_class_id Time Pattern Regime Id tpr_id Standard Settlement Configuration Id ssc_id Effective From Settlement Date {AFOYCS} eff_from_sett_date GSP Group Id gsp_group_id Effective From Settlement Date {VSCPC} N/A Average Fraction of Yearly Consumption afyc Average Fraction Of Yearly Consumption Set idb_afycs Entity “Average Fraction of Yearly Consumption” has been merged in. GSP Group Id gsp_group_id Profile Class Id pfl_class_id Standard Settlement Configuration Id ssc_id
Effective From Settlement Date {VSCPC} N/A Effective From Settlement Date {AFOYCS} eff_from_sett_date Effective to Settlement Date {AFOYCS} eff_to_sett_date Basic Period Profile Coefficient idf_basic_pd_pfl_coefs Not implemented as an Oracle database table. See chapters 2 and 4 on flat file implementation. GSP Group Id gsp_group_id Profile Class Id pfl_class_id Profile Id pfl_id Settlement Date sett_date Settlement Period Id N/A Time-period denormalised in the file. Basic Period Profile Coefficient pd_pfl_coef BM Unit for Supplier in GSP Group idb_bm_unit_in_gsp_groups GSP Group Id gsp_group_id Supplier Market Participant Id mkt_ppt_id Supplier Market Participant Role Code mkt_ppt_role_code BM Unit Id bm_unit_id Effective From Settlement Date {BMUIGG} eff_from_sett_date Effective To Settlement Date {BMUIGG} (O) eff_to_sett_date Default BM Unit Flag default_bm_unit_flag Clock Interval idb_clock_intervals
Effective From Settlement Date {PSET} eff_from_sett_date Group Average Annual Consumption group_average_annual_consum GSP Group Correction Scaling Factor idb_gsp_group_cctn_sfs Consumption Component Class Id consum_comp_class_id Effective From Settlement Date {GGCSF} eff_from_sett_date GSP Group Correction Scaling Factor gsp_group_cctn_sf GSP Group Correction Scaling Factor used in SSR Runs idb_gsp_group_cctn_sf_ssr_runs SSR Run Number ssr_run_number Consumption Component Class ID consum_comp_class_id GSP Group Correction Scaling Factor gsp_group_correction_sf GSP Group Distributor idb_mkt_ppt_role_in_gsp_groups This entity has been subtyped by this table. GSP Group Id gsp_group_id Effective From Date {GGD} eff_from_date Effective To Dat eff_to_date Distributor Market Participant Id mkt_ppt_id Distributor Market Participant Role Code mkt_ppt_role_code GSP Group Take idb_gsp_group_takes
Market Participant Role Code Market Participant Role Description Measurement Quantity cdb_ref_values This entity is being managed by the cdb_ref_domains and cdb_ref_values tables as a domain. Measurement Quantity Id Direction of energy flow Measurement Requirement idb_measurement_requirements Time Pattern Regime Id tpr_id Standard Settlement Configuration Id ssc_id Non-Half Hourly BM Unit Allocation idb_nhh_bm_unit_allocation BM Unit Id bm_unit_id Profile Class Id pfl_class_id Standard Settlement Configuration Id ssc_id Effective From Settlement Date {BMUIGG} eff_from_sett_date_bmuigg Effective From Settlement Date {NHHBMUA} eff_from_sett_date Effective To Settlement Date {NHHBMUA} (O) eff_to_sett_date Period Profile Class Coefficient idf_pd_pfl_class_coefs Not implemented as an Oracle database table. See chapters 2 and 4 on flat file implementation. Profile Class Id pfl_class_id GSP Group Id gsp_group_id
SSR Run Number ssr_run_number Profile Class Id pfl_class_id GSP Group Id gsp_group_id Line Loss Factor Class Id llf_class_id Standard Settlement Configuration Id ssc_id Time Pattern Regime Id tpr_id Settlement Period Id N/A Time-period denormalised in the flat file. Supplier Market Participant Id sup_mkt_ppt_id Supplier Market Participant Role Code sup_mkt_ppt_role_code Distributor Market Participant Id dist_mkt_ppt_id Distributor Market Participant Role Code dist_mkt_ppt_role_code Effective From Settlement Date {VSCPC} N/A Not carried down from parent. Profiled SPM Total Annualised Advance pfld_spm_total_aa_nn Profiled SPM Total EAC pfld_spm_total_eac_nn Profiled SPM Total Unmetered Consumption pfld_spm_total_unmtd_consum_nn Regression Coefficient idb_pd_pfl_regr_coefs This entity has been merged with “Period Regression Equation” and “Profile Regression Equation Set” and all of these are managed by this table. Profile Class Id pfl_class_id Profile Id pfl_id
GSP Group Correction Factor gsp_group_cctn_factor Total Period Weighted Consumption total_pd_weighted_consum Total Period NPG Spill total_pd_npg_spill SSR Run LLF File idb_ssr_run_llf_files SSR Run Number ssr_run_number GSP Group ID gsp_group_id Data File Sequence Number llf_file_id The file that contains the distributor’s line loss factors. Standard Settlement Configuration idb_sscs Standard Settlement Configuration Id ssc_id Standard Settlement Configuration Desc ssc_desc Tele-Switch User Id teleswitch_user_id Tele-switch Group Id teleswitch_group_id Active Flag active_flag SSC Type ssc_type Value is “I” (Import) or “E” (Export) Supplier idb_mkt_ppt_roles This entity is a subtype of a “Market Participant Role”. Market Participant Id mkt_ppt_id Market Participant Role Code mkt_ppt_role_code Pool Member Id pool_member_id Supplier Data Aggregation idb_sup_data_agtns Data Aggregation Run Number data_agtn_run_number Data Aggregation Type da_mkt_ppt_role_code GSP Group Id gsp_group_id
Data Aggregator Market Participant Id da_mkt_ppt_id Data Aggregator Market Participant Role Code da_mkt_ppt_role_code Supplier Market Participant Id sup_mkt_ppt_id Supplier Market Participant Role Code sup_mkt_ppt_role_code Settlement Date sett_date Settlement Code sett_code Effective From Settlement Date N/A Not carried down from parent. Supplier Data Aggregation Used In SSR Run idb_sup_data_agtn_in_ssr_runs GSP Group Id gsp_group_id Data Aggregation Type da_mkt_ppt_role_code Data Aggregation Run Number data_agtn_run_number SSR Run Number ssr_run_number Data Aggregator Market Participant Id da_mkt_ppt_id Data Aggregator Market Participant Role Code da_mkt_ppt_role_code Supplier Market Participant Id sup_mkt_ppt_id Supplier Market Participant Role Code sup_mkt_ppt_role_code Supplier In GSP Group idb_mkt_ppt_role_in_gsp_groups This entity has been subtyped by this table. GSP Group Id gsp_group_id Supplier Market Participant Id mkt_ppt_id Supplier Market Participant Role Code mkt_ppt_role_code
Effective From Settlement Date eff_from_date Effective To Settlement Date eff_to_date Supplier Purchase Matrix idf_sup_purchase_matrices Not implemented as an Oracle database table. See chapters 2 and 4 on flat file implementation. GSP Group Id gsp_group_id Data Aggregation Run Number data_agtn_run_number Line Loss Factor Class Id llf_class_id Distributor Market Participant Id dist_mkt_ppt_id Distributor Market Participant Role Code dist_mkt_ppt_role_code Data Aggregator Market Participant Id da_mkt_ppt_id Data Aggregator Market Participant Role Code da_mkt_ppt_role_code Supplier Market Participant Id sup_mkt_ppt_id Supplier Market Participant Role Code sup_mkt_ppt_role_code Profile Class Id pfl_class_id Time Pattern Regime Id tpr_id Standard Settlement Configuration Id ssc_id Data Aggregation Type da_mkt_ppt_role_code SPM Total EAC spm_total_eac SPM Total Annualised Advance spm_total_aa SPM Total Unmetered Consumption spm_total_unmtd_consum
SPM Total EAC MSID Count spm_total_eac_msid_count SPM Total AA MSID Count spm_total_aa_msid_count SPM Total Unmetered MSID Count spm_total_unmtd_msid_count SPM Default EAC MSID Count spm_dflt_eac_msid_count SPM Default Unmetered MSID Count spm_dflt_unmtd_msid_count System Configuration cdb_system_parameter System Market Participant Id N/A System Market Participant Role Code N/A Settlement Day Archive Days N/A Tele-switch Contact Tele-switch contact code cdb_ref_values This entity is being managed by the cdb_ref_domains and cdb_ref_values tables as a domain. Tele-Switch Contact Interval Tele-switch Group Id idb_tsw_contact_intervals teleswitch_group_id Tele-switch User Id teleswitch_user_id Tele-switch contact Code teleswitch_contact_code Tele-switch Start Date and time teleswitch_start_date_time Tele-switch End Date and time teleswitch_end_date_time Tele-switch Contact State teleswitch_contact_state Tele-switch Contact Rule Tele-switch Time Pattern Regime Id idb_teleswitch_contact_rules teleswitch_tpr_id Tele-switch Register Rule Id teleswitch_register_rule_id Tele-switch Contact Code teleswitch_contact_code Tele-switch Contact Rule teleswitch_contact_rule Tele-switch Register Tele-switch Time Pattern
List of Values On Settlement Code, displaying Settlement Code and Settlement Description Poplists N/A Buttons N/A Additional Behaviour N/A Description This form will be based on two blocks: CTRL - non-base table, non queryable. SETT - base table on idb_Settlements. Queryable, insert/delete/update allowed. Each record in this block will be linked directly to the settlement date in the top block, ie. Only records matching the settlement date above can be manipulated here. Form structure Object Description Form: CALEMAIN Title : Maintain Settlement Calendar. Block: CTRL non-base table. Insert, Update allowed. Join columns: ctrl.nbt_sett_date = sett.sett_dt. nbt_sett_date Label : Date Display. Mandatory. User Enterable. Insert. Update. Block: SETT Base table on idb_settlements. Query, Update, Insert, Delete allowed. Order by settlement_code. sett_code Label : Code Display. User Enterable. Query. Insert. Delete. Must be unique for the nbt_sett_date. LoV on idb_sett_types. nbt_sett_description Label : Description Display only. payment_date Label : Payment Date Display. User Enterable. Query. Insert. Delete. Format : DD-MON-YYYY. nbt_runs Label : Run(s) Display only. Planned_ssr_run_date Label : Planned Run Date Display. User Enterable. Query. Insert. Update. Delete. Format : DD-MON-YYYY.
Form: SSCTMAIN Title : Maintain Standard Settlement Configurations and assign Time Patterns. Block: ISC Base table on idb_sscs Query, Update, Delete, Insert allowed. Join columns: sscs.ssc_id = mear.ssc_id Order by ssc_id ssc_id Label : SSC Display. User Enterable. Query. Insert. Delete. Ssc_desc Label : Description Display. User Enterable. Query. Insert. Update. Delete. Teleswitch_User_Id Label : Tele-switch User Display. User Enterable. Query. Insert. Update. Delete. LoV available based on distinct values from idb_sscs. Validation: Range check against cdb_ref_values where domain_code = ‘TSUI’. Teleswitch_Group_Id Label : Tele-switch Group Display. User Enterable. Query. Insert. Update. Delete. LoV available based on idb_sscs where sccs.teleswitch_user_id = specified Tele-switch User. Validation: Range check against cdb_ref_values where domain_code = ‘TSGI’. SSC Type Label : SSC Type Display. User Enterable. Query. Insert. Update. LoV available, currently only E or I. Validation: Must be in cdb_ref_values where domain_code = ‘SSCT’. Active_flag Label : Active. Display. User Enterable.. Query. Insert. Update. Delete. Block: CTRL non-base table. Display only. Join columns: ctrl.nbt_ssc_id = sscs.ssc_id ctrl.nbt_ssc_desc = sscs.ssc_desc Nbt_ssc_id Label : SSC Display only. Nbt_ssc_desc Label : Description Display only.
Creation_time Label : Creation Timestamp Display. Query. Nbt_load_cb Label : Load. Display. Check box. Query. Update. Block: ILS Base table on idb_load_sett_prices view. (Settlement Price Data Files) file_type = ctrl.nbt_file_type. Query. Update. Order by creation_time (descending), settlement_date Settlement_date Label : Date Display. Query. Format : DD-MON-YYYY. run_type_code Label : Run Type. Display. Query. Run_number Label : Run Number Display. Query. Creation_time Label : Creation Timestamp Display. Query. Nbt_load_cb Label : Load. Display. Query. Update. Block: ILT Base table on idb_load_timestamps view. (Line Loss Factor Data Files) (Tele-switch Pool Market Domain Data Files) (Regression Equation Data Files) (Scottish Regression Equation Data Files12) (Sunset Data Files) (Profile Data Files) (Tele-switch Switching Times Data Files) (Data Aggregation and Settlements Timetable Files) (Market Domain Data Complete Set) Query. Update. file_type = ctrl.nbt_file_type. Order by creation_time (descending), participant_id. participant_id Label : Market Participant Display. Query mkt_ppt_name Label : Name Display. Query.
The functionality described here is for manual request only. Standing Profile Data Report generation is described in Chapter 7, Daily Profile Production Run Subsystem Specification - Report IDP_PR_SPD. Inputs Function Name: IDP_PR_SPD() Arguments: Settlement Date (IN) Profile Production Run Number (IN) GSP Group Id (IN) - List of GSP Groups to be included Return: success/failure This report is produced from files held in the ISRA Flat File Store. Outputs See Section 3.1.14.3 Human Readable Output See Section 3.1.14.3 Functionality The detailed processing for this report is described in the Function Description and Event Description. Report IDP_PR_DPR Function Definition Ref: I0025B Produce Profile Reports - Daily Profile Data Report Enquiry Description: Daily Profile Data Report This report contains Basic Period Profile Coefficients, Combined Period Profile Coefficients and Period Profile Coefficients with their Standard Settlement Configuration, Profile, Profile Class and GSP Group details. The functionality described here is for manual request only Daily Profile Data Report generation is described in Chapter 7, Daily Profile Production Run Subsystem Specification - Report IDP_PR_DPR. Inputs Function Name: IDP_PR_DPR() Arguments: Settlement Date (IN) Profile Production Run Number (IN) GSP Group Id (IN) - List of GSP Groups to be included Return: success/failure This report is produced from files held in the ISRA Flat File Store. Outputs See Section 3.1.14.2 Human Readable Output See Section 3.1.14.2
nbt_max_llf_file_id Label : Latest LLF File Id Integer. Display Only. No User Entry. Mandatory. Auto Populated once all the other input values are available. Action on Query None. Action on Update None. Action on Insert None. Action on Delete None. Action on Button Report Validate if the user has entered a valid combination of nbt_dist_mkt_ppt_id, nbt_sett_date and nbt_sett_pd_id. Validate the auto-populated value for nbt_max_llf_file_id and if found null then do not allow user to launch the report. The report is initiated in the background using the CSC.Submit() function. A command is built up for the report that consists of the <report name> ||’,’|| nbt_dist_mkt_ppt_id ||’,’|| nbt_sett_date ||’,’|| nbt_sett_pd_id ||’,’|| nbt_max_llf_file_id. Process IRP_SSR_INITIATE_REPORTS This process is called on completion of an SSR run and initiates all the reports which are scheduled to be produced for each SSR run. A single process is submitted to the scheduler using the CSC.SUBMIT mechanism for each report for a single supplier. The scheduler controls the number of processes which can be run in parallel. For each supplier active in the SSR run the following reports are submitted to the scheduler using the CSC.SUBMIT mechanism: Supplier settlement header; Supplier purchase matrix report; supplier purchase report; Half Hourly demand report; Deemed Take report; DUoS report. SVA Gross Demand report For each distributor that is active during the SSR a DUoS report process for the distributor is submitted to the scheduler.
Standard Reports Report Name Lines per Report Derivation Average Line Length Average Report Size (bytes) Reports per settlement day Derivation Total Size per settlement Day DUOS (Distributor) 31,454 SPM_GSPST * GSP*2 /DIS 300 9,436,050 200 DIS*SRPSD 1,887,210,000 DUOS (Supplier) 43,384 SPM_GSPST * GSP*2 /SUP 300 13,015,241 145 SUP*SRPSD 1,887,210,000 Supplier BM Unit Report 18,425 GSP * + 40 736,997 145 SUP*SRPSD 106,864,585 HH Demand 47,424 + 50 2,371,200 145 SUP*SRPSD 343,824,000 GSP Group Consumption Totals Report 19,968 60 1,198,080 145 SUP*SRPSD 173,721,600 Supplier Settlement Report Header 57 GSP + (HHDA_SG+DAPG)*GSP + 5 40 2,280 145 SUP*SRPSD 330,600 Supplier Purchase Matrix Report 21,718 GSP + GSP*DAPG + SPM_GSPST*GSP/SUP 100 2,171,807 145 SUP*SRPSD 314,912,000 Deemed Take 637 GSP * (SPD+1) 138 87,906 145 SUP*SRPSD 12,746,370 Supplier Purchase 637 GSP * (SPD+1) 80 50,960 145 SUP*SRPSD 7,389,200 TUOS 218,863 GSP*SUP*(SPD+1) 43 9,411,109 5 SRPSD 47,055,545 BM Unit Supplier Take 196,390 GSP * ( 1 + SUP_GSP * ( 2 + SPD )) 22 4,320,580 5 SRPSD 21,602,900 BM Unit SVA 196,390 GSP * ( 1 + SUP_GSP * ( 2 22 4,320,580 5 SRPSD 21,602,900
Gross Demand + SPD )) PR - SSC 71,940 VSSCPC + VMRPC + + TPR*AVG_TB_TPR_DAY 25 1,798,500 54 97,119,000 PR Tele-switch Contact Interval Data 1,324 1 + 1 + 1 + 1 + TELE_USER + TELE_GROUP + CONTACTS + TSW_CON_INT 25 33,100 29 SUP 959,900 PR - Standing Profile Data 2,984 PC+PROF*(1+GSP+SPD) 100 298,400 54 PRPSD 16,113,600 PR - Daily Profile Data 539,565 GSP * (1 + PC + PROF*2 + VSSCPC*2 + VMRPC*2 300 161,869,500 32 PRPSD*SUP 5,179,824,000 PR - Daily Profile Extract 20,709 1+PC+VSSCPC+VMRPC 22 455,598 14 PRPSD*GSP 6,378,372 Totals 1,553 10,103,261,672
8.5.3 Procedure Read Parameters 8.5.4 Procedure Validate Data Availability 8.5.5 Process GSP Group 8.5.6 Procedure Process Non-Half Hourly Data 8.5.7 Procedure Aggregate Half Hourly Data 8.5.8 Procedure Perform GSP Based Calculations 8.5.9 Procedure Perform GSP Correction 8.5.10 Calculate Supplier Purchases 8.5.11 Procedure Perform Spillage Adjustments 8.22 Use of English. 8.23 2.6.2 Merging of Logical Entities 2.6.6 Implementation of Logical Entities by Data Files 2.11 Operational Design 8. Settlement 8.24 2.8 Fallback, Backup and Recovery 9.1 Compliant with TSA 9.2 2.3.7 CFR File Receipt 2.3.10 CFS File Send 9.3 I0013B I0020B 3.1.2 GSP Group Take File 6.5.2 Procedure IDL_GSP_GP_TAKE 3.1.8 Settlement Price Data File 6.5.7 Procedure IDL_SETT_PRICE3. R2_ITT1 I0012 I0028A I0028B 5.6.20 Form ISY_TSCIMAIN 2.3.1 IDL Data Loader 6.6.1 Form IDL_LOADUTIL 3.1.11 Tele-switch Contact Interval Data File 6.5.11 Procedure IDL_TSW_CONTACT R2_ITT2 I0016 7.5.1 Form IDP_PROFUTIL 7.5.2 Procedure IDP_DPP_RUN 7.5.3 Procedure IDP_DPP_GSP R2_ITT3 I0018 I0031 I0040 3.1.6 Pool Market Domain Data File 6.6.1 Form ISY_LOADUTIL 6.5.5 Procedure IDL_PL_MKT_DOM 4.3.3 Physical Data Model 5.6.18 Form ISY_SSCTMAIN 5.6.22 Form ISY_TIPAMAIN R2_ITT4 I0025A I0025B 7.5.1 Form IDP_PROFUTIL 7.5.4 Report IDP_PR_SSC 7.5.5 Report IDP_PR_TSW
Package 2 (MDD) SIR R1116 (LCRA128/1, LCRA128/3, LCRA136) I0018 I0033, I0033E I0043 3.1.6 Tele-switch Pool Market Domain Data File 6.5.5 Procedure IDL_PL_MKT_DOM 5.6.3 Form ISY_AFYCMAIN 3.1.7 Market Domain Data Complete Set 6.6.1 Form IDL_LOADUTIL 6.5.14 Procedure IDL_MDD_COMP_SET SIR R1724 (LCR 108) I0045 AFYC Recalculation Report Form ISY_AFYC_REPT 9.6.28 Report IRP_AFYC Specification SIR R2215 ( LCR150 LCR151 LCR155 ) I0046 Various SIR R2327 ( LCR159 LCR164 LCR165 ) I0015 I0017 I0018 I0022 I0026 I0027 I0029 I0032 I0033 I0037 I0046 I0047 I0048 Various CP1093 I0010 I0010E I0009 I0009E I0017B I0022B I0049 Volume 2, Appendix A Volume 2, Appendix C 5.6.1 ISRA Application Menu Structure 5.6.8 Form ISY_DAGGMAIN 5.6.15 Form ISY_MPGGMAIN 6.5.4 Procedure IDL_AGG_HHD 6.5.5 Procedure IDL_SPM 3.2.6 Standing Data Update Report for Suppliers 9.5.9 Standing Data Update Report for Suppliers 9.6.1 Form ISY_GRINUTIL