The data fields for the reporting tables associated with the PCB Module are documented, by table, below.
| English Name | Oracle Name | Description |
| Region | REGION | The two-digit code for the region in which the site is located. [see nationally-defined values] |
| State | STATE | State postal code for the state in which the site is located. [see nationally-defined values] |
| State Name | STATE_NAME | State name for the state in which the site is located. [see nationally-defined values] |
| ID | ID | Unique internal identifier (synthetic key) associated with the site. |
| Site ID | SITE_ID | Unique identification number assigned by the Region or EPA Headquarters to each PCB site. Note: Handlers associated with Navajo Nation should be assigned Site Ids beginning with "NN" regardless of where the site is physically located. |
| Site Name | SITE_NAME | The legal name of the site. |
| Location Street Number | LOCATION_STREET_NO | Street number from the physical address of the primary site entrance. |
| Location Street 1 | LOCATION_ADDRESS1 | First line of the street address, route number, or other specific identifier describing the physical address of the primary site entrance. |
| Location Street 2 | LOCATION_ADDRESS2 | Second line of the street address (or the post office box number), route number, or other specific identifier describing the physical address of the primary site entrance. |
| Location City | LOCATION_CITY | Name of the city or town in which the handler is physically located. |
| Location State | LOCATION_STATE | State code of the location address. [see nationally-defined values for the United States or nationally-defined values for foreign states] |
| Location Zip Code | LOCATION_ZIP | The zip code in which the site is physically located. Note: Zip codes associated with US addresses may be formatted as 99999, 999999999, or 99999-9999 but will be stored in the database as 99999 or 99999-9999. |
| Location Country | LOCATION_COUNTRY | Country code of the location address. [see nationally-defined values] |
| Location Latitude Measure | LOCATION_LATITUDE |
Latitude of the site location expressed in GPS (Global Positioning System) format. The user should provide the decimal degrees value representing the degrees, minutes, and seconds. [Value must be between 0 and 90 unless the Handler ID starts with AS then the value must be between -15 and 90] Note: Valid latitude example: 69.288268 |
| Location Longitude Measure | LOCATION_LONGITUDE | Longitude of the site location expressed in GPS (Global Positioning System) format. The user should provide the decimal degrees value representing the degrees, minutes, and seconds. [Value must be between -180 and -60 unless the Handler ID starts with AK, AS, GU, MP, TT, XI, or XJ then the value must be between -180 and 180] Note: Valid longitude example: -147.650167 |
| Mailing Street Number | MAIL_STREET_NO | The street number from the primary business mailing address. |
| Mailing Street 1 | MAIL_ADDRESS1 | First line of the street address (or the post office box number) for primary business mailing purposes. |
| Mailing Street 2 | MAIL_ADDRESS2 | Second line of the street address (or the post office box number) for primary business mailing purposes. |
| Mailing City | MAIL_CITY | Name of the city or town of the site's mailing address. |
| Mailing State | MAIL_STATE | State code of the mailing address. [see nationally-defined values for the United States or nationally-defined values for foreign states] |
| Mailing Zip Code | MAIL_ZIP | Zip code of the primary business mailing address. Note: Zip codes associated with US addresses may be formatted as 99999, 999999999, or 99999-9999 but will be stored in the database as 99999 or 99999-9999. |
| Mailing Country | MAIL_COUNTRY | Country code of the mailing address. [see nationally-defined values] |
| Contact First Name | CONTACT_FIRST_NAME | First name of the primary contact person for the site location who should contacted regarding information submitted on the notification form. |
| Contact Middle Initial | CONTACT_MIDDLE_INITIAL | Middle initial of the primary contact person for the site location who should be contacted regarding information submitted on the notification form. |
| Contact Last Name | CONTACT_LAST_NAME | Last name of the primary contact person for the site location who should be contacted regarding information submitted on the notification form. |
| Contact Telephone Number | CONTACT_PHONE | Telephone number at which the site contact may be reached. Note: Phone numbers associated with US addresses may be formatted as 9999999999 or 999-999-9999 but will be stored in the database as 999-999-9999. |
| Contact Telephone Extension | CONTACT_PHONE_EXT | Telephone number extension associated with the contact. |
| Contact Email Address | CONTACT_EMAIL | Email address associated with the contact. |
| Contact Title | CONTACT_TITLE | Title of the site contact person. |
| Owner Name | OWNER_NAME | The name of the entity (individual, agency, or corporation) having legal ownership of the physical operation. The owner name may or may not be the same as the actual site name. |
|
Certified Date |
CERTIFIED_DATE | The date that the notification form was certified by the owner, operator, or authorized representative of the site. |
| Receive Date | RECEIVE_DATE | Date that the notification form was received from the site by the appropriate authority. |
| Generator | GENERATOR | Indicates whether the site is a generator with on-site storage defined as a user, owner, or processor of PCBs or PCB items and you maintain your own storage facilities subject to 40 CFR 761.65(b) or (c)(7) for PCBs. [Y - Yes; N - No] |
| Storer | STORER | Indicates whether the site is a commercial storer defined as a site that owns or operates a storage facility which is subject to the storage facility standards of 40 CFR 761.65(b)or (c)(7), and which engages in off-site storage activities involving the PCB wastes generated by others. Most commercial storers of PCB waste perform waste storage services in exchange for a fee or other compensation, but the receipt of compensation is not necessary for your storage facility to qualify as a commercial storer of PCB wastes generated by others. [Y - Yes; N - No] |
| Transporter | TRANSPORTER | Indicates whether the site is a transporter defined as a site that moves PCBs by air, rail, highway, or water. [Y - Yes; N - No] |
| Research | RESEARCH | Indicates whether the site is a R&D/Treatability facility defined as a site that is engaged in conducting R&D into PCB disposal technologies and cannot accept waste on a commercial scale. [Y - Yes; N - No] |
| Disposer | DISPOSER | Indicates whether the site is an approved disposer defined as a site that currently holds a valid EPA permit to dispose of PCBs in concentrations exceeding 50 ppm in a landfill, through alternative technology, or incineration. [Y - Yes; N - No] |
|
Smelter |
SMELTER | Indicates whether the site operates a device to dispose of PCBs, or if you dispose of PCBs in compliance with Section 761.71 (i.e., high efficiency boilers) or Section 761.72 (i.e., scrap metal recovery oven/smelter). [Y - Yes; N - No] |
| Non-Notifier | NON_NOTIFIER | Flag indicating that the site has been identified through a source other than Notification and is suspected of conducting PCB activities without proper authority. [Y - Yes; N - No] |
| Facility Type | FACILITY_TYPE | The code(s) associated with the type(s) of business activities (e.g., K-12 school, university) that occur at the facility. Determined by the implementer entering the record into RCRAInfo at the time of entry. [see nationally-defined values] |
| Facility Type Description | FACILITY_TYPE_DESC | The description(s) associated with the type(s) of business activities (e.g., K-12 school, university) that occur at the facility. Determined by the implementer entering the record into RCRAInfo at the time of entry. [see nationally-defined values] |
| Facility Type Other Description | FACILITY_TYPE_OTHER_DESC | The description provided for the type of business activity that occurred at the facility that was classified as "Other" (i.e., a nationally-defined value does not exist for this business activity). |
| Cleanup 61b Notification | CLEANUP_61B_NOTIFICATION | Indicates that the site has been identified through the submission of a 61(b) cleanup notificaiton. [Y - Yes; N - No; null] |
| English Name | Oracle Name | Description | ||||||||||||||||||||
| ID | ID | Unique internal identifier (synthetic key) associated with the approval. | ||||||||||||||||||||
| Region | REGION | The two-digit code for the region in which the site is located. [see nationally-defined values] | ||||||||||||||||||||
| State | STATE | State postal code for the state in which the site is located. [see nationally-defined values] | ||||||||||||||||||||
| State Name | STATE_NAME | State name for the state in which the site is located. [see nationally-defined values] | ||||||||||||||||||||
| Site ID | SITE_ID | Unique identification number assigned by the Region or EPA Headquarters to each PCB site. Note: Handlers associated with Navajo Nation should be assigned Site Ids beginning with "NN" regardless of where the site is physically located. | ||||||||||||||||||||
| Site Name* | SITE_NAME | The legal name of the site. | ||||||||||||||||||||
| Location Street Number* | LOCATION_STREET_NO | Street number from the physical address of the primary site entrance. | ||||||||||||||||||||
| Location Street 1* | LOCATION_ADDRESS1 | First line of the street address, route number, or other specific identifier describing the physical address of the primary site entrance. | ||||||||||||||||||||
| Location Street 2* | LOCATION_ADDRESS2 | Second line of the street address (or the post office box number), route number, or other specific identifier describing the physical address of the primary site entrance. | ||||||||||||||||||||
| Location City* | LOCATION_CITY | Name of the city or town in which the handler is physically located. | ||||||||||||||||||||
| Location State* | LOCATION_STATE | State code of the location address. [see nationally-defined values for the United States or nationally-defined values for foreign states] | ||||||||||||||||||||
| Location Zip Code* | LOCATION_ZIP | The zip code in which the site is physically located. Note: Zip codes associated with US addresses may be formatted as 99999, 999999999, or 99999-9999 but will be stored in the database as 99999 or 99999-9999. | ||||||||||||||||||||
| Location Latitude Measure | LOCATION_LATITUDE | Latitude of the site location expressed in GPS (Global Positioning System) format. The user should provide the decimal degrees value representing the degrees, minutes, and seconds. [Value must be between 0 and 90 unless the Handler ID starts with AS then the value must be between -15 and 90] Note: Valid latitude example: 69.288268 | ||||||||||||||||||||
| Location Longitude Measure | LOCATION_LONGITUDE | Longitude of the site location expressed in GPS (Global Positioning System) format. The user should provide the decimal degrees value representing the degrees, minutes, and seconds. [Value must be between -180 and -60 unless the Handler ID starts with AK, AS, GU, MP, TT, XI, or XJ then the value must be between -180 and 180] Note: Valid longitude example: -147.650167 | ||||||||||||||||||||
| Facility Type | FACILITY_TYPE | The code(s) associated with the type(s) of business activities (e.g., K-12 school, university) that occur at the facility. Determined by the implementer entering the record into RCRAInfo at the time of entry. [see nationally-defined values] | ||||||||||||||||||||
| Facility Type Description | FACILITY_TYPE_DESC | The description(s) associated with the type(s) of business activities (e.g., K-12 school, university) that occur at the facility. Determined by the implementer entering the record into RCRAInfo at the time of entry. [see nationally-defined values] | ||||||||||||||||||||
| Facility Type Other Description | FACILITY_TYPE_OTHER_DESC | The description provided for the type of business activity that occurred at the facility that was classified as "Other" (i.e., a nationally-defined value does not exist for this business activity). | ||||||||||||||||||||
| Cleanup 61b Notification | CLEANUP_61B_NOTIFICATION | Indicates that the site has been identified through the submission of a 61(b) cleanup notificaiton. [Y - Yes; N - No; null] | ||||||||||||||||||||
| Approval Identifier | APPROVAL_IDENTIFIER | Unique internal identifier associated with the approval. It contains the approval type(s) within the identifier. | ||||||||||||||||||||
| Approval Name | APPROVAL_NAME | An optional name that is assigned, by the user, to the approval. | ||||||||||||||||||||
| Activity Type | ACTIVITY_TYPE | Indicates if approval being acted up is an initial approval, an approval that is being renewed, or an approval that is being modified. [I - Initial; R - Renewal; M - Modification] | ||||||||||||||||||||
| Approval Status | APPROVAL_STATUS | Indicates the current status associated with the approval. [see nationally-defined values] | ||||||||||||||||||||
| Approval Status Description | APPROVAL_STATUS_DESC | The description of the current status associated with the approval. [see nationally-defined values] | ||||||||||||||||||||
| Approval Type | APPROVAL_TYPE | Indicates the type of the approval. [see nationally-defined values] | ||||||||||||||||||||
| Approval Type Description | APPROVAL_TYPE_DESC | The description of the type of the approval. [see nationally-defined values] | ||||||||||||||||||||
| Milestone Identifier | MILESTONE_IDENTIFIER | Unique internal identifier associated with the milestone. | ||||||||||||||||||||
| Milestone Type | MILESTONE_TYPE | Indicates the type of milestone associated with the approval. [see nationally-defined values] | ||||||||||||||||||||
| Milestone Type Description | MILESTONE_TYPE_DESC | The description of the milestone associated with the approval. [see nationally-defined values] | ||||||||||||||||||||
| Milestone Date* | MILESTONE_DATE | The "key" date of the of the milestone associated with the approval. | ||||||||||||||||||||
| Approval Created Date | APPROVAL_CREATED_DATE | The date that the approval was created. | ||||||||||||||||||||
| Approval Signed Date | APPROVAL_SIGNED_DATE | The most recent date that the approval was signed. | ||||||||||||||||||||
| All Approval Signed Dates | ALL_APPROVAL_SIGNED_DATES | In some instances an approval may have more than one approval signed date. This field shows all of the approval signed dates associated with the approval concatenated together, from the oldest signed date to the most recent signed date. | ||||||||||||||||||||
| Expiration Date | EXPIRATION_DATE | The most recent date that the approval expires. | ||||||||||||||||||||
| All Approval Expiration Dates | ALL_APPROVAL_EXP_DATES | In some instances an approval may have more than one expiration date. This field shows all of the expiration dates associated with the approval concatenated together, from the oldest expiration date to the most recent expiration date. | ||||||||||||||||||||
| Issuing Authority | ISSUING_AUTHORITY | Indicates the authority that issued the approval. [see nationally-defined values] | ||||||||||||||||||||
| Issuing Authority Description | ISSUING_AUTHOITY_DESC | The description of the authority that issued the approval. [see nationally-defined values] | ||||||||||||||||||||
| ACS Points | ACS_POINTS | A measure of PCB approval accomplishments that are used for the official reporting of EPA's annual goals developed under the Government Performance Results Act (GPRA).
|
||||||||||||||||||||
| ACS Date | ACS_DATE | The date of the accomplishment used to designate the fiscal year in which an accomplishment occurred. |
*The values in these fields may be the same or different from the corresponding information in the PCB_NOTIFICATION_REPORT_VIEW.