CY - PGC
---------

CY-PGC = Protocol Gas Cylinder

This transaction is used to define the Producer ID (PGVP-ID) / Cylinder ID owned by an agency and the associated gas in the cylinder. This transaction is used to update end use date of a gas when the cylinder is refilled. When a cylinder has the same parameter defined twice the dates may not overlap.

Rules
^^^^^

A parameter defined for a cylinder may not be deleted if it is in use for an assessment.

Expiration Date/Last Use Date may not be null. The field should be updated if the gas runs out before the expiration date.

A record is unique to a PGVP-ID / Cylinder ID / Agency Code combination.

If a cylinder is refilled with the same gas as before then there may not be any overlap of the certification date and expiration/last use date.

Format
^^^^^^

.. list-table:: CY - Protocol Gas Cylinder transaction format
   :widths: 1 5 15 4 3 1
   :header-rows: 1


 * - Seq.
     - Name
     - Description
     - Formatting Rules
     - Required
     - Key
   * - 1
     - `Transaction Type <Transaction%20Type.html>`_
     - Quality Assurance transaction identifier.
     - Must = CY
     - Always
     - 
   * - 2
     - `Action Indicator <Action%20Indicator%20for%20Transaction.html>`_
     - Indicator for Insert, Update, or Delete action.
     - Must = I, U, or D
     - Always
     - 
   * - 3
     - `PGVP ID <Producer%20ID.html>`_
     - Unique ID assigned by EPA's Clean Air Power Sector Programs for each Protocol Gas Producer.
     - Must be in CYLINDER_PRODUCERS table.
     - Always
     - Y
   * - 4
     - `Cylinder ID <Cylinder%20ID.html>`_
     - Unique ID stamped into each cylinder.
     - VARCHAR.
     - Always
     - Y
   * - 5
     - `Agency Code <Agency%20ID.html>`_
     - Agency Code of the organization that owns the cylinder.
     - Must exist in AGENCIES reference table.
     - Always
     - Y
   * - 6
     - `Parameter Code <Parameter%20Code.html>`_
     - The AQS parameter code(s) of the certified standards in the cylinder.
     - Must be CO, SO2, NO or NOx.
     - Always
     - Y
   * - 7
     - `Units <Reported%20Unit%20Code.html>`_
     - Units associated with the certified parameter concentrations in the cylinder.
     - Must exist in UNITS reference table.
     - Always
     - Y
   * - 8
     - `Certified Concentration <Cylinder%20Certified%20Concentration.html>`_
     - Gas concentration(s) certified by the protocol gas producer
     - Decimal.
     - Always
     - Y
   * - 9
     - `Certification Date`_
     -  Date the parameter concentration was certified by the Protocol Gas Producer. NOTE: the certification date of a refilled cylinder standard must be greater than the expiration/last use date of any prior standards for the cylinder. 
     - YYYYMMDD.
     - Always
     - Y
   * - 10
     - `Expiration Date / Last Use Date`_
     - Value should be the expiration date of the certified standard unless or until the certified cylinder is returned to the Producer for a refill; in which case the value is modified to be the date the standard was last used by the agency.
     - YYYYMMDD.
     - Always
     - Y