b265d972591d4a7127c6818c4fd1099bf3e63a1d,pudl/models/ferc1.py,PurchasedPowerFERC1,PurchasedPowerFERC1_1,#,353

Before Change

    record_id = Column(String, nullable=False)
    report_year = Column(Integer, nullable=False)
    authority_company_name = Column(String)
    statistical_classification = Column(String)
    rate_schedule_tariff_num = Column(String)
    avg_billing_demand_mw = Column(String)
    avg_monthly_ncp_demand_mw = Column(String)
    avg_monthly_cp_demand_mw = Column(String)

After Change

        String,
        comment="Name of the seller, or the other party in an exchange transaction."
    )
    purchase_type = Column(
        Enum(*pc.ferc1_power_purchase_type.values(),
             name="ferc1_power_purchase_type"),
        comment="Categorization based on the original contractual terms and conditions of the service. Must be one of "requirements", "long_firm", "intermediate_firm", "short_firm", "long_unit", "intermediate_unit", "exchange", "other_service", or "adjustment". Requirements service is ongoing high reliability service, with load integrated into system resource planning. "Long term" means 5+ years. "Intermediate term" is 1-5 years. "Short term" is less than 1 year. "Firm" means not interruptible for economic reasons. "unit" indicates service from a particular designated generating unit. "exchange" is an in-kind transaction."
    )
    tariff = Column(
        String,
        comment="FERC Rate Schedule Number or Tariff. (Note: may be incomplete if originally reported on multiple lines.)"
    )

Instances