{% extends "base.html" %} {% block title %} Chellow > 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) | Finish Date | MOP Contract | MOP Account | HHDC Contract | HHDC Account | Meter Serial Number | Profile Class | Meter Timeswitch Class | CoP | Standard Settlement Configuration (blank for HH supplies) | 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 | |||||||||||||||||||||||
insert | era | MPAN Core | Start date (yyyy-MM-dd) | Site Code | MOP Contract | MOP Account | HHDC Contract | HHDC Account | Meter Serial Number | Profile Class | MTC | CoP | SSC | 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 | HHDC Contract | HHDC Account | Meter Serial Number | Profile Class | MTC | CoP | SSC | 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 | Is Import? | Is kWh? | Description | From | To | ||||||||||||||||||||||
insert | site_snag_ignore | Site Code | Description | From | To | ||||||||||||||||||||||||
insert | batch | Role Name (hhdc, supplier or mop) | Contract Name | Reference | Description | ||||||||||||||||||||||||
update | batch | Role Name (hhdc, supplier or mop) | Contract Name | Old Reference | New Reference | Description | |||||||||||||||||||||||
insert | bill | Role Name(hhdc, 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 | ||||||||||||||||||||
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 |