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 and the cylinder is refilled before the prior fill's 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.
Parameter code(s) of the certified standard in a cylinder may only be CO, SO2, NO or NOx.
Examples:
CY|I|B2|536871|6000|007|06|20220601|20220630
Format¶
Seq. |
Name |
Description |
Formatting Rules |
Required |
Key |
|---|---|---|---|---|---|
1 |
Cylinder transaction identifier. |
Must = CY |
Always |
||
2 |
Indicator for Insert, Update, or Delete action. |
Must = I, U, or D |
Always |
||
3 |
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 |
Unique ID stamped into each cylinder. |
VARCHAR. |
Always |
Y |
|
5 |
Agency Code of the organization that owns the cylinder. |
Must exist in AGENCIES reference table. |
Always |
Y |
|
6 |
The AQS parameter code(s) of the certified standards in the cylinder. |
Must be CO, SO2, NO or NOx. |
Always |
Y |
|
7 |
Units associated with the certified parameter concentrations in the cylinder. |
Must exist in UNITS reference table. |
Always |
Y |
|
8 |
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 |