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 date to Settlement Date idb_vscpcs. eff_from_sett_date 4 Effective To Settlement date to Date 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 boolean to Indicator 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 date to Settlement Date idb_afycs. eff_from_sett_date 4 Effective To Settlement date to Date 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 decimal to Yearly Consumption (7,6) idb_afycs.afyc 3 Time Pattern Regime Id text(5) shows which TPR record is parent Repeating structure of file:
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:
SVAAISRA_Technical_Spec_redlined_v27.2_CP1418.docx