3 Data Aggregator text(40) idb_mkt_ppts / mkt_ppt_name Name 4 Data Aggregator text(1) or Assign Data Aggregation Type to matching ‘H’ ‘N’. Type Participant Role Code for role code and for role (i.e. ‘N’ ‘B’ ‘H’ code ‘A’). 5 Data Aggregator Run integer(7) idb_sup_data_agtn_in_ssr_runs / data_agtn_run_number Number 6 Data Aggregator Run date idb_sup_data_agtn / sett_date Settlement 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 integer(2) idb_ssr_runs / ssa_sett_run_number Number 3 SSA Settlement Date date idb_ssa_sett_runs / sett_date 4 SSA Settlement Run text(1) idb_ssa_sett_runs / sett_run_type_id Type 5 CDCS Extract integer(2) idb_ssa_sett_runs / cdsc_extract_number Number Repeating Structure of the File (sort order shown in brackets):
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):
SVAAISRA_Technical_Spec_redlined_v27.2_CP1418.docx