{% extends "base.html" %} {% block title %} General Imports {% endblock %} {% block nav %} General Imports {% endblock %} {% block content %}
{% if process_ids %}Action | Type | |||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
insert | site | Site Code | Site Name | |||||||||||||||||||||||||||||
delete | site | Site Code | ||||||||||||||||||||||||||||||
update | site | Current Site Code | New Site Code | Site Name | ||||||||||||||||||||||||||||
insert | supply | Site Code | Source Code | Generator Type | Supply Name | GSP Group (geographic location) | Start date (yyyy-MM-dd hh:mm) | Finish Date | MOP Contract | MOP Account | DC Contract | DC Account | Meter Serial Number | Profile Class | Meter Timeswitch Class | CoP | Standard Settlement Configuration (blank for HH supplies) | Energisation Status | Properties | Import MPAN Core | Import LLFC | Import Supply Capacity | Import Supplier Contract | Import Supplier Account | Export MPAN Core | Export LLFC | Export Supply Capacity | Export Supplier Contract | Export Supplier Account | |||
update | supply | MPAN Core | Source Code | Generator Type | Supply Name | GSP Group | ||||||||||||||||||||||||||
delete | supply | MPAN Core | ||||||||||||||||||||||||||||||
insert | era | MPAN Core | Start date (yyyy-MM-dd) | Site Code | MOP Contract | MOP Account | DC Contract | DC Account | Meter Serial Number | Profile Class | MTC | CoP | Comms Type | SSC | Energisation Status | Properties | Import MPAN Core | Import LLFC | Import Supply Capacity | Import Supplier Contract | Import Supplier Account | Import ACTIVE? | Import REACTIVE_IMP? | Import REACTIVE_EXP? | Export MPAN Core | Export LLFC | Export Supply Capacity | Export Supplier Contract | Export Supplier Account | Export ACTIVE? | Export REACTIVE_IMP? | Export REACTIVE_EXP? |
update | era | MPAN Core | Date | Start date | Finish date | MOP Contract | MOP Account | DC Contract | DC Account | Meter Serial Number | Profile Class | MTC | CoP | Comms Type | SSC | Energisation Status | Properties | Import MPAN Core | Import LLFC | Import Supply Capacity | Import Supplier Contract | Import Supplier Account | Export MPAN Core | Export LLFC | Export Supply Capacity | Export Supplier Contract | Export Supplier Account | |||||
delete | era | MPAN Core | Date | |||||||||||||||||||||||||||||
insert | channel | MPAN Core | Date (yyyy-MM-dd hh:mm) | Import Related? | Channel Type (active, reactive import, reactive export) | |||||||||||||||||||||||||||
delete | channel | MPAN Core | Date | Import Related? | Channel Type (active, reactive import, reactive export) | |||||||||||||||||||||||||||
insert | site_era | Site Code | Core MPAN | Era Start Date | Is Physical? | |||||||||||||||||||||||||||
insert | hh_datum | MPAN Core | Date | Channel Type | Value | Status | ||||||||||||||||||||||||||
insert | user | Email Address | Password | Password Digest | User Role | Participant Code | Role Code | |||||||||||||||||||||||||
update | user | Current Email Address | Email Address | Password | Password Digest | User Role | Participant Code | Role Code | ||||||||||||||||||||||||
insert | channel_snag_ignore | MPAN Core | Import Related? | Channel Type | Description | From | To | |||||||||||||||||||||||||
insert | channel_snag_unignore | MPAN Core | Import Related? | Channel Type | Description | From | To | |||||||||||||||||||||||||
insert | site_snag_ignore | Site Code | Description | From | To | |||||||||||||||||||||||||||
insert | batch | Role Name (dc, supplier or mop) | Contract Name | Reference | Description | |||||||||||||||||||||||||||
update | batch | Role Name (dc, supplier or mop) | Contract Name | Old Reference | New Reference | Description | ||||||||||||||||||||||||||
insert | bill | Role Name (dc, supplier or mop) | Contract Name | Batch Reference | Mpan Core | Issue Date | Start Date | Finish Date | Net | Vat | Gross | Account Reference | Reference | Type | Breakdown | Kwh | (Meter Serial Number | Mpan | Coefficient | Units | TPR | Previous Date | Previous Value | Previous Type | Present Date | Present Value | Present Type)* | |||||
update | bill | Chellow Id | Account | Reference | Issue Date | Start Date | Finish Date | kwh | Net | Vat | Type | Paid? | Breakdown | |||||||||||||||||||
update | register_read | Chellow Id | TPR | Coefficient | Units | Meter Serial Number | MPAN | Previous Date | Previous Value | Previous Type | Present Date | Present Value | Present Type | |||||||||||||||||||
insert | llfc | DNO Code | LLFC Code | LLFC Description | Voltage Level Code | Is Substation? | Is Import? | Valid From | Valid To | |||||||||||||||||||||||
update | llfc | DNO Code | LLFC Code | Valid From | LLFC Description | Voltage Level Code | Is Substation? | Is Import? | Valid To | |||||||||||||||||||||||
delete | llfc | DNO Code | LLFC Code | Date | ||||||||||||||||||||||||||||
insert | market_role | Market Role Code | Market Role Description | |||||||||||||||||||||||||||||
insert | party | Market Role Code | Participant Code | Name | Valid From (YYYY-MM-dd hh:mm) | Valid To (YYYY-MM-dd hh:mm) | DNO Code | |||||||||||||||||||||||||
insert | g_supply | Site Code | MPRN | Supply Name | Exit Zone | Start date (yyyy-MM-dd hh:mm) | Finish Date (YYYY-MM-dd hh:mm or blank for ongoing) | Meter Serial Number | Correction Factor | Unit | Contract | Account | Reading Frequency | |||||||||||||||||||
update | g_supply | Existing MPRN | MPRN | Supply Name | Exit Zone | |||||||||||||||||||||||||||
delete | g_supply | MPRN | ||||||||||||||||||||||||||||||
insert | g_batch | Contract Name | Reference | Description | ||||||||||||||||||||||||||||
update | g_batch | Contract Name | Old Reference | New Reference | Description | |||||||||||||||||||||||||||
insert | g_bill | Contract Name | Batch Reference | MPRN | Issue Date (YYY-MM-dd hh:mm) | Start Date (YYY-MM-dd hh:mm) | Finish Date (YYY-MM-dd hh:mm) | Net GBP | VAT GBP | Gross GBP | Account | Reference | Type | Breakdown | kWh | (Meter Serial Number | Unit | Correction Factor | Calorific Value | Previous Date | Previous Value | Previous Type | Present Date | Present Value | Present Type)* | |||||||
insert | valid_mtc_llfc_ssc_pc | DNO Code | MTC Code | MTC Valid From (YYYY-MM-dd hh:mm) | LLFC Code | LLFC Valid From (YYYY-MM-dd hh:mm) | SSC Code | SSC Valid From | PC Code | Valid From (YYYY-MM-dd hh:mm) | Valid To (YYYY-MM-dd hh:mm or blank) | |||||||||||||||||||||
update | valid_mtc_llfc_ssc_pc | DNO Code | MTC Code | MTC Valid From (YYYY-MM-dd hh:mm) | LLFC Code | LLFC Valid From (YYYY-MM-dd hh:mm) | SSC Code | SSC Valid From | PC Code | Valid From (YYYY-MM-dd hh:mm) | Valid To (YYYY-MM-dd hh:mm or blank) |