8ab31ccce5629d57ad6ca671a90c39d54fdda568,pudl/models/ferc1.py,PurchasedPowerFERC1,PurchasedPowerFERC1_1,#,347

Before Change

    __tablename__ = "purchased_power_ferc1"
    id = Column(Integer, autoincrement=True, primary_key=True)
    utility_id_ferc1 = Column(Integer,
                              ForeignKey("utilities_ferc.utility_id_ferc1"),
                              nullable=False)
    record_id = Column(String, nullable=False)
    report_year = Column(Integer, nullable=False)

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", "electricity_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