Docstoc

MODULAR_RCRA_DataAnalysis58_DOC

Document Sample
MODULAR_RCRA_DataAnalysis58_DOC Powered By Docstoc
					1cdd2d9a-70d6-4b80-80ae-391d0f0e0328.xls                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   flow_Handler




             A                 B                   C                     D                    E                   F                    G                    H                    I                    J                   K                    L                   M                    N                    O                    P                    Q                    R                   S                    T              U        V               W              X          Y         Z       AA             AB               AC                  AD                  AE                   AF                   AG




                         Original Data                           Original Source                                                      Dictionary Entry                                Object Class        Object Class        Property Term          Property Term                         Representation        Representation         Data Type                                 AssociatedObject AssociatedObject                      MinOc MaxOcc                                                                                                EDSC XML Tag           EDSC Standard      EDSC Dictionary
  1         ID              Source         Original Source ID      Data Name                Definition           XML Tag Name                Name            ABIE/ASBIE/BBIE            Qualifier             Term                 Qualifier          Possessive        Property Term       Term Qualifier             Term              Qualifier             Data Type             ClassQualifier     ClassTerm        BusinessTerm(s) curs     urs     RCRA Format   MinLength MaxLength Length Total Digits   Fraction Digits   Owning Agency       Name                   Group             Entry Name          EDSC Format
  2                                                                                                           HazardousWasteHandlerSubmission
                                                                                       This is the root element.                                            ASBIE                   Handler
                                                                                                                                     Hazardous Waste_ Handler. _ Submission.HazardousWaste            Handler               HazardousWasteHandler                     Submission                                                                                                  HazardousWaste
                                                                                                                                                                                                                                                                                                                                                          HazardousWasteHandlerDataType             Handler                                  1        1
  3                                                                                                           HazardousWasteHandlerDataType
                                                                                       Hazardous waste handler.                      Hazardous Waste_ Handler. Details
                                                                                                                                                            ABIE                   HazardousWaste     Handler                                                         Details                                                                             NA
  4                                                                                                                                                         ASBIE                  HazardousWaste
                                                                                       Facility Submission. FacilitySubmission Hazardous Waste_ Handler. Facility Submission. Facility Submission     Handler                                                         FacilitySubmission                                                                  FacilitySubmissionDataType                FacilitySubmission                       1 unbounded
  5                                                                                                           FacilitySubmissionDataType Submission. Details
                                                                                       Details of facility submission.               Facility               ABIE                                      FacilitySubmission                                              Details                                                                             NA
  6                                                             Transaction Code                              TransactionCode        Facility Submission. BBIE
                                                                                       Transaction code used to define the add, update, or delete. Transaction. Code                                  FacilitySubmission                                              Transaction                              Code                                       TransactionCodeDataType                                                            0        1 CHAR(1)                                      1
  7                                                        1    EPA Handler ID         Number that uniquely HandlerIDthe handler.Facility Submission. Handler_ Identifier
                                                                                                               identifies                                   BBIE                                      FacilitySubmission Handler                                      Identifier                               Identifier                                 HandlerIDDataType                                                                  1        1 CHAR(12)                4          12                                                                          Facility
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    InformationSystemIdentifier Identification Environmental Information System Identification Number
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   Alphanumeric (30)
  8                                                        6    Extract Flag                                  is available for extract for Submission. Public Use_ Extract. Indicator
                                                                                                                                     Facility
                                                                                       Designates that data PublicUseExtractIndicator public use.           BBIE                                      FacilitySubmission PublicUse                                    Extract                                  Indicator                                  PublicUseExtractIndicatorDataType                                                  0        1 CHAR(1)
  9                                                        3                           Computer-generated FacilityRegistryID key in the EPA FINDSBBIE system used as an identifier to cross-reference entities regulated under different environmental programs. The Agency Facility Identification Data Standard (FIDS) requires that program offices store this key in their data systems.
                                                                EPA Facility Identification Code                                                              Registry. Identifier
                                                                                                              primary facility-level Facility Submission. _ data                                      FacilitySubmission Facility                                     Registry                                 Identifier                                 FacilityRegistryIDDataType                                                         0        1 VARCHAR2(12)            1           12                                                      FacilityRegistryIdentifier
 10                                                        9    Notes                                           about the handler. Facility Submission. Supplemental_ Information
                                                                                       Additional informationSupplementalInformation                        BBIE                                      FacilitySubmission Supplemental                                 Information                              Text                                       SupplementalInformationDataType                                                    0        1 VARCHAR2(240)           1          240
 11                                                      358                                                  PreviousHandler
                                                                                       Association of handler Ids with their previous handler Ids.
                                                                                                                                     Facility Submission. Previous Handler. Previous Handler
                                                                                                                                                            ASBIE                                     FacilitySubmission                                              PreviousHandler                                                                     PreviousHandlerDataType                   PreviousHandler                          0 unbounded
 12                                                      370                                                  Handler
                                                                                       Top level of all information about the handler.
                                                                                                                                     Facility Submission. Handler. Handler
                                                                                                                                                            ASBIE                                     FacilitySubmission                                              Handler                                                                             HandlerDataType                           Handler                                  1 unbounded
 13                                                                                                           and activity data.
                                                                                       Handler identification HandlerDataType        Handler. Details       ABIE                                      Handler                                                         Details                                                                             NA
 14                                                             Transaction Code                              TransactionCode        Handler. delete.
                                                                                       Transaction code used to define the add, update, orTransaction.BBIE   Code                                     Handler                                                         Transaction                              Code                                       TransactionCodeDataType                                                            0        1 CHAR(1)                                      1
 15                                                       12    Activity Location                              of the agency regulating the handler.        BBIE
                                                                                       Indicates the locationActivityLocationCode Handler. Activity_ Location. Code                                   Handler               Activity                                  Location                                 Code                                       ActivityLocationCodeDataType                                                       1        1 CHAR(2)                                      2
 16                                                       11    Source Type                                   SourceTypeCode         Handler. Source_ Type. Code
                                                                                                                                                            BBIE
                                                                                       Code indicating the source of information for the associated data (activity, wastes, etc.).                    Handler               Source                                    Type                                     Code                                       SourceTypeCodeDataType                                                             1        1 CHAR(1)                                      1
 17                                                       13    Handler Sequence Number                         each source record about a handler. Record_ Sequence. Number
                                                                                       Sequence number forSourceRecordSequenceNumber Handler. Source        BBIE                                      Handler               SourceRecord                              Sequence                                 Number                                     SourceRecordSequenceNumberDataType                                                 1        1 NUMBER(6)                                             6
 18                                                       14    Receive Date                                  ReceiveDate            Handler. Receive_ Date BBIE
                                                                                       Date that the form (indicated by the associated Source) was received from the handler by the appropriate authority.
                                                                                                                                                                                                      Handler               Receive                                   Date                                     Date                                       ReceiveDateDataType                                                                0        1 DATE
 19                                                       61                                                    received for the handler.
                                                                Acknowledge Date Date information wasAcknowledgeReceiptDate                                 BBIE
                                                                                                                                     Handler. Acknowledge Receipt_ Date                               Handler               AcknowledgeReceipt                        Date                                     Date                                       AcknowledgeReceiptDateDataType                                                     0        1 DATE
 20                                                       16    Non-Notifier                                  NonNotifierIndicator Handler. Non Notifier.BBIEIndicator
                                                                                       Flag indicating that the handler has been identified through a source other than Notification and is suspected of conducting RCRA-regulated activities without proper authority.
                                                                                                                                                                                                      Handler                                                         NonNotifier                              Indicator                                  NonNotifierIndicatorDataType                                                       0        1 CHAR(1)
 21                                                       17    Number of Employees                           OnsiteEmployeeQuantity Handler. Onsite_ Employee. Quantity
                                                                                       The number of employees currently working at the site.               BBIE                                      Handler               Onsite                                    Employee                                 Quantity                                   OnsiteEmployeeQuantityDataType                                                     0        1 NUMBER(9)                                             9
 22                                                       88                           Number that may        SecondaryID             identify Secondary_ BBIE
                                                                Other/Secondary Identification Number be assigned by States toHandler. individual handlers.  Identifier                               Handler               Secondary                                 Identifier                               Identifier                                 SecondaryIDDataType                                                                0        1 VARCHAR2(12)            1          12
 23                                                       89    TSD Date                                      TreatmentStorageDisposalDate
                                                                                                                                     Handler. Treatment Storage Disposal_ Date
                                                                                                                                                            BBIE
                                                                                       The date that operation of the facility commenced, the date construction on the facility commenced, or the date that operation isTreatmentStorageDisposal
                                                                                                                                                                                                      Handler                expected to begin.                       Date                                     Date                                       TreatmentStorageDisposalDateDataType                                               0        1 DATE
 24                                                       90    Off-Site Waste Receipt                        OffsiteWasteReceiptCodeHandler. Offsite_ Waste accepts hazardous waste from another site (site identified by a different EPA ID). If information is alsoWasteReceipt specific processes and wastes which are accepted, it is indicated by a flag at the process unit level (Process Unit Group Commercial Status).
                                                                                                                                                            BBIE
                                                                                       Code indicating that the handler, whether public or private, currentlyReceipt. Code                            Handler               Offsite                                    available on the                        Code                                       OffsiteWasteReceiptCodeDataType                                                    0        1 CHAR(1)                                      1
 25                                                       91    Accessibility                                 AccessibilityCode      Handler. Accessibility_ Code
                                                                                                                                                             normal
                                                                                       Code indicating the reason why the handler is not accessible for BBIE RCRA tracking and processing (previously called Bankrupt Indicator).
                                                                                                                                                                                                      Handler               Accessibility                             Code                                     Code                                       AccessibilityCodeDataType                                                          0        1 CHAR(1)                                      1
 26                                                      280    Owner                                         that defines the county code.
                                                                                       Indicates the agency CountyCodeOwner Handler. County_ Code Owner     BBIE                                      Handler               County                                    CodeOwner                                Code                                       CountyCodeOwnerDataType                                                            0        1 CHAR(2)                                      2
 27                                                      281    County Code                                   CountyCode             Handler. County_ Code  BBIE                                      Handler
                                                                                       The Federal Information Processing Standard (FIPS) code for the county in which the facility is located (Ref: FIPS Publication, 6-3, "Counties and County Equivalents of the States of the United States").
                                                                                                                                                                                                                            County                                    Code                                     Code                                       CountyCodeDataType                                                                 0        1 VARCHAR2(5)             1            5
 28                                                      101    Notes                                           about the handler. Handler. Supplemental_ Information
                                                                                       Additional informationSupplementalInformation                        BBIE                                      Handler               Supplemental                              Information                              Text                                       SupplementalInformationDataType                                                    0        1 VARCHAR2(240)           1          240
 29                                                                                                           LocationAddress
                                                                                       Location address information.                                        ASBIE
                                                                                                                                     Handler. Location Address. Location Address                      Handler                                                         LocationAddress                                                                     LocationAddressDataType                   LocationAddress                          0        1
 30                                                                                                           MailingAddress         Handler.               ASBIE
                                                                                       Address infromation specific to mailing addresses. Mailing Address. Mailing Address                            Handler                                                         MailingAddress                                                                      MailingAddressDataType                    MailingAddress                           0        1
 31                                                                                                            contact address       Handler.               ASBIE
                                                                                       Contains contact and ContactAddress information. Contact. Contact Address                                      Handler                                                         Contact                                                                             ContactAddressDataType                    ContactAddress                           0        1
 32                                                                                                            contact address information for the holder ASBIE permit.
                                                                                                                                     H                       of the
                                                                                       Contains contact and PermitContactAddress andler. Permit_ Contact. Contact Address                             Handler               Permit                                    Contact                                                                             ContactAddressDataType                    ContactAddress                           0        1
 33                                                                                                           RCRAGeographicCoordinate RCRA_ Geographic Coordinate. Geographic Coordinate
                                                                                       Latitude/Longitude information.               Handler.               ASBIE                                     Handler               RCRA                                      GeographicCoordinate                                                                                        RCRA
                                                                                                                                                                                                                                                                                                                                                          RCRAGeographicCoordinateDataType          GeographicCoordinate                     0 unbounded
 34                                                                                    Used oil codes.        UsedOil                                       ASBIE
                                                                                                                                     Handler. Used Oil. Used Oil                                      Handler                                                         UsedOil                                                                             UsedOilDataType                           UsedOil                                  0 unbounded
 35                                                                                                           WasteActivitySite
                                                                                       State and EPA hazardous waste activity codes.                        ASBIE
                                                                                                                                     Handler. Waste Activity. Waste Activity                          Handler                                                         WasteActivity                                                                                               Site
                                                                                                                                                                                                                                                                                                                                                          SiteWasteActivityDataType                 WasteActivity                            0        1
 36                                                                                                           StateWasteGenerator andler.
                                                                                                                                     H                      ASBIE
                                                                                       Federal generator status codes and descriptions. State_ Waste Generator. Waste Generator                       Handler               State                                     WasteGenerator                                                                      WasteGeneratorDataType                    WasteGenerator                           0 unbounded
 37                                                                                                           FederalWasteGenerator
                                                                                       State generator status codes and descriptions.                       ASBIE
                                                                                                                                     Handler. Federal_ Waste Generator. Waste Generator               Handler               Federal                                   WasteGenerator                                                                      WasteGeneratorDataType                    WasteGenerator                           0 unbounded
 38                                                                                                           Certification          Handler. Certification.ASBIE
                                                                                       Waste information certification for the handler.                       Certification                           Handler                                                         Certification                                                                       CertificationDataType                     Certification                            0 unbounded
 39                                                                                                           NAICS                  Handler. reported for the
                                                                                                                                                            ASBIE
                                                                                       North American Industry Classification Status codesNAICS. NAICS handler.                                       Handler                                                         NAICS                                                                               NAICSDataType                             NAICS                                    0 unbounded
 40                                                                                                           OwnerOperatorFacility                         ASBIE
                                                                                       Handler owner and operator information. Handler. Owner Operator. Owner Operator                                Handler                                                         OwnerOperator                                                                                               Facility
                                                                                                                                                                                                                                                                                                                                                          FacilityOwnerOperatorDataType             OwnerOperator                            0 unbounded
 41                                                                                                           PermitEnvironmental Handler. Permit. Permit
                                                                                       Information about environmental permits issued to the handler. ASBIE                                           Handler                                                         Permit                                                                                                      Environmental
                                                                                                                                                                                                                                                                                                                                                          EnvironmentalPermitDataType               Permit                                   0 unbounded
 42                                                                                                           StateActivity
                                                                                       State waste activity of the handler.                                 ASBIE
                                                                                                                                     Handler. State Activity. Activity                                Handler                                                         StateActivity                                                                       StateActivityDataType   State             UniversalWasteActivity                   0 unbounded
 43                                                                                                           HandlerUniversalWasteActivity handler.
                                                                                                                                     Handler.               ASBIE
                                                                                       Information about universal waste generated by the _ Universal Waste. Universal Waste Activity                 Handler               Handler                                   UniversalWaste                                                                                              Handler
                                                                                                                                                                                                                                                                                                                                                          HandlerUniversalWasteActivityDataType UniversalWasteActivity                       0 unbounded
 44                                                                                                           HandlerWasteCodeDetailsHandler. Waste Code_ streams.
                                                                                                                                                            ASBIE
                                                                                       Hazardous waste codes describing the handler's hazardous wasteDetails. Waste Code                              Handler               Handler                                   WasteCodeDetails                                                                    WasteCodeDataType                         WasteCode                                0 unbounded
 45                                                                                                           EnvironmentalPermitDataType
                                                                                                                                     Environmental_ Permit. Details
                                                                                       Information about environmental permits issued to the handler. ABIE                         Environmental      Permit                                                          Details                                                                             NA
 46                                                             Transaction Code                              TransactionCode        Environmental_ Permit. Transaction. Code Environmental
                                                                                       Transaction code used to define the add, update, or delete.          BBIE                                      Permit                                                          Transaction                              Code                                       TransactionCodeDataType                                                            0        1 CHAR(1)                                      1
 47                                                      151    Other Permit NumberIdentification number EnvironmentalPermitIDnvironmental_issuedBBIE handler, or the number of a filed application for which an EnvironmentalPermit has not yet been issued.
                                                                                                              of an effective environmental permit Permit. _the
                                                                                                                                     E                        to Identifier        Environmental      Permit                environmental permit                      Identifier                               Identifier                                 EnvironmentalPermitIDDataType                                                      1        1 VARCHAR2(13)            1          13                                                       OtherPermitIdentifier                1.3                      A(30)
 48                                                      318    Owner                                         that defines the otherEnvironmental_ Permit. _ Owner. Name Environmental
                                                                                                                                      permit type.
                                                                                       Indicates the agency EnvironmentalPermitOwnerName                    BBIE                                      Permit                EnvironmentalPermit                       Owner                                    Name                                       EnvironmentalPermitOwnerNameDataType                                               0        1 CHAR(2)                                      2
 49                                                      319    Other Permit Type Code indicating the environmental programEnvironmental_ Permit. _ Type. Code
                                                                                                              EnvironmentalPermitTypeCode
                                                                                                                                      and/or jurisdictional authority under which an environmental permit was issued to the EnvironmentalPermit an application has been filed for which a permit has not yet been issued. This data element is applicable to TSD facilities only.
                                                                                                                                                            BBIE                   Environmental      Permit                facility, or under which                  Type                                     Code                                       EnvironmentalPermitTypeCodeDataType                                                0        1 CHAR(1)                                      1                                              PermitTypeCode                       1.5                      A(120)
 50                                                      154                           Description of any permit type indicated asEnvironmental_ Permit. _Type field.
                                                                Other Permit Description                                              O (Other)             BBIE
                                                                                                              EnvironmentalPermitDescription in the Permit Description             Environmental      Permit                EnvironmentalPermit                       Description                              Text                                       EnvironmentalPermitDescriptionDataType                                             0        1 VARCHAR2(20)            1           20
 51                                                      157    Notes                                           of the environmental Environmental_ Permit. Supplemental_ Information
                                                                                       Additional descriptionSupplementalInformation permit.                BBIE                   Environmental      Permit                Supplemental                              Information                              Text                                       SupplementalInformationDataType                                                    0        1 VARCHAR2(240)           1          240
 52                                                                                                           PreviousHandlerDataTypePrevious Handler. Details
                                                                                       Association of handler Ids with their previous handler Ids.          ABIE                                      PreviousHandler                                                 Details                                                                             NA
 53                                                             Transaction Code                              TransactionCode        Previous delete.       BBIE
                                                                                       Transaction code used to define the add, update, orHandler. Transaction. Code                                  PreviousHandler                                                 Transaction                              Code                                       TransactionCodeDataType                                                            0        1 CHAR(1)                                      1
 54                                                                                                           PreviousHandlerID Previous Handler. _ Identifier
                                                                                       Previous EPA Handler IDs                                             BBIE                                      PreviousHandler       PreviousHandler                           Identifier                               Identifier                                 PreviousHandlerIDDataType                                                          1        1 CHAR(1)                                      1
 55                                                      190    Notes                                           about the previous EPA
                                                                                                                                     Previous Universal BBIE
                                                                                                                                     Handler_ Handler.
                                                                                       Additional informationSupplementalInformation Handler ID. Supplemental_ Information                            PreviousHandler       Supplemental                              Information                              Text                                       SupplementalInformationDataType                                                    0        1 VARCHAR2(480)           1          480
 56                                                                                                                                  W aste Activity.
                                                                                                              HandlerUniversalW asteActivityDataType        ABIE                   Handler            UniversalWasteActivity                                          Details                                                                             NA
 57                                                             Transaction Code                              TransactionCode        Universal delete.      BBIE
                                                                                       Transaction code used to define the add, update, or Waste Activity. Transaction. Code                          UniversalWasteActivity                                          Transaction                              Code                                       TransactionCodeDataType                                                            0        1 CHAR(1)                                      1
 58                                                      342    Owner                                         that defines the universal waste type.
                                                                                                                                     Universal              BBIE
                                                                                       Indicates the agency UniversalWasteOwnerName Waste Activity. _ Owner. Name                                     UniversalWasteActivity niversalWaste
                                                                                                                                                                                                                            U                                         Owner                                    Name                                       UniversalWasteOwnerNameDataType                                                    1        1 CHAR(2)                                      2
 59                                                      343    Universal Waste Type                          UniversalWasteTypeCode
                                                                                       Code indicating the type of universal waste.                         BBIE
                                                                                                                                     Universal Waste Activity. _ Type. Code                           UniversalWasteActivity niversalWaste
                                                                                                                                                                                                                            U                                         Type                                     Code                                       UniversalWasteTypeCodeDataType                                                     1        1 CHAR(1)                                      1
 60                                                      173    Accumulated                                   AccumulatedWasteCode   Universal Waste waste on site.
                                                                                                                                                            BBIE
                                                                                       Code indicating that the handler is engaged in accumulating Activity. Accumulated_ . Code                      UniversalWasteActivity ccumulated
                                                                                                                                                                                                                            A                                         Waste                                    Code                                       AccumulatedWasteCodeDataType                                                       0        1 CHAR(1)                                      1
 61                                                      174    Generated                                     GeneratedHandlerCode   Universal Waste Activity.site.
                                                                                       Code indicating that the handler is engaged in generating waste BBIE  on Generated_ Handler. Code              UniversalWasteActivity enerated
                                                                                                                                                                                                                            G                                         Handler                                  Code                                       GeneratedHandlerCodeDataType                                                       0        1 CHAR(1)                                      1
 62                                                      177    Notes                                           about the universal waste.
                                                                                       Additional informationSupplementalInformation                        BBIE
                                                                                                                                     Universal Waste Activity. Supplemental_ Information              UniversalWasteActivity upplemental
                                                                                                                                                                                                                            S                                         Information                              Text                                       SupplementalInformationDataType                                                    0        1 VARCHAR2(240)           1          240
 63




                                                                                                                                                                                                                                                                                                                     1 of 15                                                                                                                                                                                                                                                                                                 2/25/2012
1cdd2d9a-70d6-4b80-80ae-391d0f0e0328.xls                                                                                                                                                                                                                                                                                                                          flow_Handler




            AH                     AI               AJ                   AK                     AL                       AM                   AN                 AO                  AP                    AQ                AR              BJ               BK   BL   BM             BN   BO   BP   BQ   BR   BS   BT   BU   BV   BW   BX   BY   BZ   CA   CB




                        CRM M ajo r Dat a   CRM M ajo r Dat a   CRM Co m p o u n d     CRM Co m p o u n d                            CRM Dat a B lo c k   CRM Dat a                                                               M an d at o r y Dat a
  1    EDR Identifier   Group               G r o u p ID        Dat a B lo c k         Dat a B lo c k ID        CRM Dat a B lo c k   ID                   Elem en t          Comment               RCRA Table           Module    Elem en t
  2
  3
  4
  5
  6                                                                                                                                                                                                                                                       1
  7                                                             Facility Site                               4                                                                                     HBASIC           Handler                                1
  8                                                                                                                                                                                               HBASIC           Handler                                1
  9                     Facility            F                   Facility Identification F.01                    Facility Identity    F.02                 Systems Classifications Unique ID/NumberHBASIC           Handler                                0
 10                                                                                                                                                                                               HBASIC           Handler                                0
 11
 12                                                                                                                                                                                             HHANDLER2          Handler
 13
 14                                                                                                                                                                                                                                                       1
 15                                                                                                                                                                                             HHANDLER2          Handler                                1
 16                                                                                                                                                                          Source of Data     HHANDLER2          Handler                                1
 17                                                                                                                                                                                             HHANDLER2          Handler                                1
 18                                                                                                                                                                                                                                                       1
 19                                                                                                                                                                                             HHANDLER2          Handler                                1
 20                                                                                                                                                                                             HHANDLER2          Handler                                1
 21                                                                                                                                                                                             HHANDLER2          Handler                                0
 22                                                                                                                                                                                             HHANDLER2          Handler                                0
 23                                                                                                                                                                                             HHANDLER2          Handler                                1
 24                                                                                                                                                                                             HHANDLER2          Handler                                1
 25                                                                                                                                                                                             HHANDLER2          Handler                                1
 26                                                                                                                                                                                             LU_COUNTY          Handler                                1
 27                                                                                                                                                                                             LU_COUNTY          Handler                                1
 28                                                                                                                                                                                             HHANDLER2          Handler                                0
 29                                                                                                                                                                                                                                                       1
 30                                                                                                                                                                                                                                                       1
 31                                                                                                                                                                                                                                                       0
 32                                                                                                                                                                                                                                                       0
 33                                                                                                                                                                                                                                                       1
 34                                                                                                                                                                                                                                                       1
 35                                                                                                                                                                                                                                                       1
 36                                                                                                                                                                                                                                                       1
 37                                                                                                                                                                                                                                                       1
 38                                                                                                                                                                                             HCERTIFCATION      Handler                                1
 39                                                                                                                                                                                             HNAICS             Handler                                1
 40                                                                                                                                                                                                                                                       1
 41                                                                                                                                                                                                                                                       0
 42                                                                                                                                                                                             HSTATE_ACTIVITY Handler                                   0
 43                                                                                                                                                                                             HUNIVERSAL_WASTEHandler                                   1
 44                                                                                                                                                                                             HWASTE_CODE     Handler                                   0
 45
 46                                                                                                                                                                                                                                                       1
 47                                                                                                                                                                          Alternative Identifier HOTHER_PERMIT2 Handler                                0
 48                                                                                                                                                                                                 LU_OTHER_PERMITHandler                                0
 49                     Permit              P                   Permit Identification P.03                      Permit Identitfy     P.01                 Permit Type                               LU_OTHER_PERMITHandler                                0
 50                                                                                                                                                                                                 HOTHER_PERMIT2 Handler                                0
 51                                                                                                                                                                                                 HOTHER_PERMIT2 Handler                                0
 52
 53                                                                                                                                                                                                                                                       1
 54                                                                                                                                                                                                                                                       1
 55                                                                                                                                                                                             HPREVIOUS_ID       Handler                                0
 56
 57                                                                                                                                                                                                                                                       1
 58                                                                                                                                                                                                                LU_UNIVERSAL_WASTE                     0
 59                                                                                                                                                                                                                LU_UNIVERSAL_WASTE                     0
 60                                                                                                                                                                                                                HUNIVERSAL_WASTE                       0
 61                                                                                                                                                                                                                HUNIVERSAL_WASTE                       0
 62                                                                                                                                                                                                                HUNIVERSAL_WASTE                       0
 63




                                                                                                                                                                                                                                                                             2 of 15                                                                                2/25/2012
1cdd2d9a-70d6-4b80-80ae-391d0f0e0328.xls                                                                                                                                                                                                                                                                                                                                                                                                                       flow_Permitting




           A                 B                 C                     D                      E                 F                   G                    H                    I                J                  K                L                    M                  N                     O                      P              Q                   R                 S                     T             U                    V                      W
                                                                                                                                                                                                                                                                                                                                                As s o c iat ed   As s o c iat ed
                    Org in al Dat a   Org in al So u rc e   Orig in al So u rc e                                      Dic t io n ary En t ry   AB IE/ASB IE/B B I Ob jec t Clas s                     Pro p ert y Term   Pro p ert y Term                      Rep res en t at io n   Rep res en t at io n   Dat a Ty p e                       Ob jec t Clas s   Ob jec t Clas s     B u s in es s
 1 ID               So u rc e         ID                    Dat a Nam e          Def in it io n     XM L Tag Nam e Nam e                       E                  Qu alif ier       Ob jec t Clas s   Qu alif ier        Po s s es s iv e   Pro p ert y Term   Term Qu alif ier       Term                   Qu alif ier    Dat a Ty p e        Qu alif er        Term                Term (s )       M in Oc c u rs       M ax Oc c u rs       Fo rm at
                                                                                                                      Hazardous
                                                                                                    HazardousW aste W aste_ Perm it.
                                                                                  T his is the root Perm itSubm issio _ Subm ission.                                                                                                                                                                                        HazardousW aste
 2                                                                                elem ent.         n                 Perm it                  ASBIE              HazardousW aste Perm it             HazardousW astePerm it                Submission                                                                      Perm itDataT ype HazardousW aste Perm it                                                   1                    1
                                                                                                                      Hazardous
                                                                                  Hazardous waste HazardousW aste W aste_ Perm it.
 3                                                                                perm it.          Perm itDataT ype Details                   ABIE               HazardousW aste Perm it                                                                                                                                   NA
                                                                                                                      Hazardous
                                                                                                                      W aste_ Perm it.
                                                                                                                      _ Facility
                                                                                  Hazardous waste                     Subm ission.                                                                                                                                                                                          Perm itFacilitySu
                                                                                  perm it facility  Perm itFacilitySu Perm it Facility                                                                                                                                                                                      bm issionDataT y                      Perm itFacilitySu
 4                                                                                subm ission.
                                                                                  Permit facility   bm ission         Subm ission
                                                                                                    Perm itFacilitySu Perm it Facility         ASBIE      HazardousW aste Perm it
                                                                                                                                                                               itFacilitySu           Perm it                               FacilitySubmission                                                              pe                                    bm ission                                            1 unbounded
 5                                                                                submission.       bm issionDataT y Subm ission.       ABIE                              bm ission                                                                                                                                         NA
                                                                                                                                                                          Perm itFacilitySu
 6                                                    520   EPA Handler ID Number that uniquely identifies the handler. Facility Submission. Handler_ Identifier
                                                                                                  HandlerID          Permit             BBIE                              bm ission
                                                                                                                                                                          Perm itFacilitySu           Handler                               Identifier                                Identifier                            HandlerIDDataType                                                                          1                    1 CHAR(12)
 7                                                                            Permit data for thePermitSeries
                                                                                                   permit series.    Permit Facility Submission. Series. Permit Series
                                                                                                                                        ASBIE                             bm ission
                                                                                                                                                                          Perm itFacilitySu                                                 PermitSeries       Information                                                  PermitSeriesDataType                  PermitSeries                                         0 unbounded
 8                                                                            Identification and description of a process unit groupSubmission. PermitUnit. Permit Unit
                                                                                                  PermitUnit         Permit Facility    ASBIE                             bm ission                                                         PermitUnit                                                                      PermitUnitDataType                                                                         0 unbounded
                                                                              Perm it series      Perm itSeriesDat Perm it Series.
  9                                                                           data.               aT ype             Details            ABIE                              Perm itSeries                                                     Details                                                                         NA
 10                                                         Transaction Code Transaction code used to define the add, update, or Transaction. Code
                                                                                                  TransactionCode Permit Series. delete.BBIE                              Perm itSeries                                           Transaction                                         Code                                  TransactionCodeDataType                                                                    0                    1   CHAR(1)
 11                                                   489   Series Sequence Number                value used to uniquely identify _ Sequence.
                                                                              System-generated PermitSeriesSequenceNumbera permit series. Number
                                                                                                                     Permit Series.     BBIE                              Perm itSeries               Perm itSeries               Sequence                                            Number                                PermitSeriesSequenceNumberDataType                                                         1                    1   NUMBER(4)
 12                                                   490   Series Name                           PermitSeriesName
                                                                              Name or number assigned by the implementing agency.BBIE
                                                                                                                     Permit Series. _ Name                                Perm itSeries               Perm itSeries               Name                                                Name                                  PermitSeriesNameDataType                                                                   0                    1   VARCHAR2(12)
 13                                                   491   EPA Attorney OwnerIndicates the agency that defines the Permit Series. EPAAttorney_ Data Owner. Code
                                                                                                  EPAAttorneyDataOwnerCode
                                                                                                                     person identifier. BBIE                              Perm itSeries          EPAAttorney                      DataOwner                                           Code                                  EPAAttorneyDataOwnerCodeDataType                                                           0                    1   CHAR(2)
 14                                                   492   EPA Attorney ID Current attorney atEPAAttorneyID
                                                                                                   the EPA level.    Permit Series. EPAAttorney_ Identifier
                                                                                                                                        BBIE                              Perm itSeries          EPAAttorney                      Identifier                   Identifier             Identifier                            EPAAttorneyIDDataType                                                                      0                    1   VARCHAR2(5)
 15                                                   493                                                                                                                 Perm
                                                                              Indicates the agency that defines the Permit Series. EPAResponsiblePerson_ Data Owner. Code itSeries
                                                            EPA Responsible Person Owner                             person identifier. BBIE
                                                                                                  EPAResponsiblePersonDataOwnerCode                                                              EPAResponsiblePerson             DataOwner                                           Code                                  EPAResponsiblePersonDataOwnerCodeDataType                                                  0                    1   CHAR(2)
 16                                                   494   EPA Responsible Person ID currently responsible for the permit at the EPA level.
                                                                              The person          EPAResponsiblePersonID
                                                                                                                     Permit Series. EPAResponsiblePerson_ Identifier
                                                                                                                                        BBIE                              Perm itSeries          EPAResponsiblePerson             Identifier                   Identifier             Identifier                            EPAResponsiblePersonIDDataType                                                             0                    1   VARCHAR2(5)
 17                                                   497   State Responsible Indicates the agency that defines the Permit Series. State Responsible Person_ Data Owner. Perm itSeries
                                                                               Person Owner                          person identifier. BBIE
                                                                                                  StateResponsiblePersonDataOwnerCode                                     Code                   StateResponsiblePerson           DataOwner                                           Code                                  StateResponsiblePersonDataOwnerCodeDataType                                                0                    1   CHAR(2)
 18                                                   498   State Responsible The person currently responsible for the permit at the State level.
                                                                               Person ID          StateResponsiblePersonID
                                                                                                                     Permit Series. State Responsible Person_ Identifier
                                                                                                                                        BBIE                              Perm itSeries          StateResponsiblePerson           Identifier                                          Identifier                            StateResponsiblePersonIDDataType                                                           0                    1   VARCHAR(5)
 19                                                   495   State Attorney Owner
                                                                              Indicates the agency that defines the Permit Series. State Attorney_ Data Owner. Code
                                                                                                  StateAttorneyDataOwnerCode
                                                                                                                     person identifier. BBIE                              Perm itSeries          StateAttorney                    DataOwner                                           Code                                  StateAttorneyDataOwnerCodeDataType                                                         0                    1   CHAR(2)
 20                                                   496   State Attorney ID Current attorney atStateAttorneyID Permit Series. State Attorney_ Identifier
                                                                                                   the State level.                     BBIE                              Perm itSeries          StateAttorney                    Identifier                   Identifier             Identifier                            StateAttorneyIDDataType                                                                    0                    1   VARCHAR2(5)
 21                                                   501   Notes             Additional description of the permit series. Series. Supplemental_ Information
                                                                                                  SupplementalInformation
                                                                                                                     Permit             BBIE                              Perm itSeries          Supplemental                     Information                                         Text                                  SupplementalInformationDataType                                                            0                    1   VARCHAR2(240)
 22                                                                           Permit event data about a permit series.
                                                                                                  PermitEvent        Permit Series. Event. Permit Event
                                                                                                                                        ASBIE                             Perm itSeries                                           PermitEvent                                                                               PermitEventDataType               PermitEvent                                              0 unbounded
 23                                                                           Permit event data. PermitEventDataType                     ABIE
                                                                                                                     Permit Event. Details                                     PermitEvent                                        Details                                                                                   NA
 24                                                                                               TransactionCode Permit Event. delete.  BBIE
                                                            Transaction Code Transaction code used to define the add, update, orTransaction. Code                              PermitEvent                                        Transaction                                         Code                                  TransactionCodeDataType                                                                    0                    1   CHAR(1)
 25                                                                                               ActivityLocationCode
                                                                                                                     Permit Event. Activity_
                                                                                                                                         BBIE
                                                            Activity Location Indicates the location of the agency regulating the handler. Location. Code                      PermitEvent       Activity                         Location                                            Code                                  ActivityLocationCodeDataType                                                               1                    1   CHAR(2)
 26                                                   504   Permit Event Owner                    PermitEventDataOwnerCode
                                                                                                                     event code.         BBIE
                                                                              Indicates the agency that defines the Permit Event. PermitEvent_ Data Owner. Code                PermitEvent       PermitEvent                      DataOwner                                           Code                                  PermitEventDataOwnerCodeDataType                                                           1                    1   VARCHAR2(2)
 27                                                   505                                         PermitEventCode Permit Event. program event and
                                                                                                                                         BBIE                                  PermitEvent
                                                            Permit Event CodeCode used to indicate a specific permitting/closure PermitEvent_ Codestatus that has actually occurred or is scheduled to occur.
                                                                                                                                                                                                 PermitEvent                      Code                                                Code                                  PermitEventCodeDataType                                                                    1                    1   VARCHAR2(7)
 28                                                   507   Responsible Agency                    ResponsibleAgencyNameEvent. Responsible Agency_ Name
                                                                                                                     Permit
                                                                              Code indicating the agency responsible for conducting aBBIE  specific permitting/closure program event.
                                                                                                                                                                               PermitEvent       ResponsibleAgency                Name                                                Name                                  ResponsibleAgencyNameDataType                                                              1                    1   CHAR(1)
 29                                                   506                     System-generated PermitEventSequenceNumber a PermitEvent_ Sequence. Number
                                                            Event Sequence Number                                    Permit Event.       BBIE
                                                                                                  value used to uniquely identify permit event.                                PermitEvent       PermitEvent       EventSequence Sequence                                             Number                                PermitEventSequenceNumberDataType                                                          1                    1   NUMBER(3)
 30                                                   511                     Date on which actual completion of a Permit Event. Actual_ Date
                                                            Actual Date of Event                  ActualDate                              event
                                                                                                                      permitting/closure BBIE occurs.                          PermitEvent       Actual            ActualEvent    Date                         Date                   Date                                  ActualDateDataType                                                                         0                    1   DATE
 31                                                   509                     The original        OriginalScheduledDate Event. Original Scheduled_ Date
                                                                                                                     Permit
                                                            Original Scheduled Event Date scheduled completion date for an event. BBIE                                         PermitEvent       OriginalScheduled                Date                                                Date                                  OriginalScheduledDateDataType                                                              0                    1   DATE
 32                                                                           The new             NewScheduledDate ermit Event.
                                                                                                                     P
                                                            New Scheduled Event Date scheduled completion date for an event. NewBBIE      Scheduled_ Date                      PermitEvent       NewScheduled                     Date                                                Date                                  NewScheduledDateDataType                                                                                            DATE
 33                                                   513                       Person the agency that defines the Permit Event. Responsible Person_ Data Owner. Code PermitEvent
                                                                                                                     person identifier.
                                                            Event ResponsibleIndicatesOwner ResponsiblePersonDataOwnerCode BBIE                                                                  ResponsiblePerson                DataOwner                                           Code                                  ResponsiblePersonDataOwnerCodeDataType                                                     0                    1   CHAR(2)
 34                                                   514                       Person ID         ResponsiblePersonIDPermit Event. Responsible Person_ Identifier
                                                                                                                                         BBIE
                                                            Event ResponsibleThe person currently responsible for the event. Foreign key to PERSON_IDENTIFIER in LU_STAFF.     PermitEvent       ResponsiblePerson                Identifier                                          Identifier                            ResponsiblePersonIDDataType                                                                0                    1   CHAR(5)
 35                                                   515                       Suborganization Owner
                                                                                                  ResponsibleSuborganizationDataOwnerCode
                                                                                                                     suborganization identifier.
                                                                                                                                         BBIE
                                                            Event ResponsibleIndicates the agency that defines the Permit Event. Responsible Suborganization_ Data Owner. Code PermitEvent       ResponsibleSuborganization       DataOwner                                           Code                                  ResponsibleSuborganizationDataOwnerCodeDataType                                            0                    1   CHAR(2)
 36                                                   516                       Suborganization ResponsibleSuborganizationID Responsible Suborganization_ Identifier PermitEvent
                                                                                                                     Permit Event.       BBIE
                                                            Event ResponsibleName or abbreviation of a state division/section (suborganization).                                                 ResponsibleSuborganization       Identifier                                          Identifier                            ResponsibleSuborganizationIDDataType                                                       0                    1   VARCHAR2(5)
 37                                                   519   Notes                                 SupplementalInformation
                                                                                                                     Permit              BBIE
                                                                              Additional description of the permit event. Event. Supplemental_ Information                     PermitEvent       Supplemental                     Information                                         Text                                  SupplementalInformationDataType                                                            0                    1   VARCHAR2(240)
 38                                                                                               PermitUnit         Permit Event. Permit Unit.Permit Unit
                                                                              Identification and description of a process unit group     ASBIE                                 PermitEvent                                        PermitUnit                                                                                PermitUnitDataType                PermitUnit                                               0 unbounded
 39                                                                                               PermitUnitDataType
                                                                              Characteristics of process unit group.Permit Unit. Details ABIE                                  PermitUnit                                         Details                                                                                   NA
 40                                                                                               TransactionCode Permit Unit. or delete.BBIE
                                                            Transaction Code Transaction code used to define the add, update, Transaction. Code                                PermitUnit                                         Transaction                                         Code                                  TransactionCodeDataType                                                                    0                    1   CHAR(1)
 41                                                   521                     System-generated PermitUnitSequenceNumber a process unit. Sequence. Number
                                                            Process Unit Sequence Number                             Permit Unit.        BBIE
                                                                                                  value used to uniquely identify Permit Event_                                PermitUnit        PermitUnit                       Sequence                                            Number                                PermitUnitSequenceNumberDataType                                                           1                    1   NUMBER(4)
 42                                                   522   Process Unit Name                     PermitUnitName Permit Unit. Permitto identify a process unit group.
                                                                              Name or number assigned by the implementing agency BBIE      Event_ Name                         PermitUnit        PermitUnit                       Name                                                Name                                  PermitUnitNameDataType                                                                     0                    1   VARCHAR2(18)
 43                                                   525   Notes                                 SupplementalInformation Unit.
                                                                                                                     Permit              BBIE
                                                                              Additional description of the process unit group. Supplemental_ Information                      PermitUnit        Supplemental                     Information                                         Text                                  SupplementalInformationDataType                                                            0                    1   VARCHAR2(240)
 44                                                                                                details.                              ASBIE
                                                                              Process unit groupDetailPermitUnit Permit Unit. Detail_ . Process Unit                           PermitUnit        Detail                           PermitUnit                                                                                                  Detail
                                                                                                                                                                                                                                                                                                                            DetailPermitUnitDataType          PermitUnit                                               0 unbounded
 45                                                                                               PermitEvent
                                                                              Permit event data about a process unit.                    ASBIE
                                                                                                                     Permit Unit. Permit Event. Permit Event                   PermitUnit                                         PermitEvent                                                                               PermitEventDataType               PermitEvent                                              0 unbounded
 46                                                                                               DetailPermitUnitDataType
                                                                                                                      details.
                                                                              Characteristics of process unit group Detail_ Permit Unit. Details
                                                                                                                                         ABIE                Detail            PermitUnit                                         Detail                                                                                    NA
 47                                                                                               TransactionCode Detail_ Permit delete. BBIE
                                                            Transaction Code Transaction code used to define the add, update, or Unit. Transaction. Code     Detail            PermitUnit                                         Transaction                                         Code                                  TransactionCodeDataType                                                                    0                    1   CHAR(1)
 48                                                   528                     System-generated PermitUnitDetailSequenceNumber BBIE
                                                            Process Unit Detail Sequence Number                      Detail_ Permit Unit. Process Unit       Detail
                                                                                                  value used to uniquely identify a process unit detail. Detail_ Sequence. Number
                                                                                                                                                                               PermitUnit        PermitUnitDetail                 Sequence                                            Number                                PermitUnitDetailSequenceNumberDataType                                                     1                    1   NUMBER(4)
 49                                                   540   Process Code Owner                    ProcessUnitOwnerCode code.
                                                                                                                     process             BBIE                Detail
                                                                              Indicates the agency that defines the Detail_ Permit Unit. Process Unit_ Owner. Code             PermitUnit        PermitUnit                       Owner                                               Code                                  PermitUnitOwnerCodeDataType                                                                0                    1   CHAR(2)
 50                                                   541   Process Code                          ProcessUnitCode Detail_ Permit Unit. storage, or disposal
                                                                                                                                         BBIE                Detail
                                                                              Code specifying the unit group's current waste treatment, Process Unit_ Code process.            PermitUnit        PermitUnit                       Code                                                Code                                  PermitUnitCodeDataType                                                                     0                    1   CHAR(1)
 51                                                   529                     Date specifying when the other information inPermit Unit. Process Status_ Detail process, capacity, and operating and legal status) became effective.
                                                            Process Status Effective Date                            Detail_             BBIE                 Effective
                                                                                                  PermitStatusEffectiveDate the process detail data record (i.e., Date         PermitUnit        PermitStatus                     EffectiveDate                                       Date                                  PermitStatusEffectiveDateDataType                                                          0                    1   DATE
 52                                                   530                                         PermitUnitCapacityQuantity
                                                            Process Capacity Amount of waste capacity.                                   BBIE                Detail
                                                                                                                     Detail_ Permit Unit. Process Unit _ Capacity. Quantity PermitUnit           PermitUnit                       Capacity                                            Quantity                              PermitUnitCapacityQuantityDataType                                                         0                    1   DECIMAL(15,3)
 53                                                   532                     Indicates the agency that defines the Detail_ Permit Unit. Capacity_ Owner. Code
                                                            Capacity Type Owner                   CapacityOwnerCode  capacity type.      BBIE                Detail            PermitUnit        Capacity                         Owner                                               Code                                  CapacityOwnerCodeDataType                                                                  0                    1   CHAR(2)
 54                                                   533   Capacity Type                         CapacityTypeCode                       BBIE
                                                                              Code indicating the type of capacity. Detail_ Permit Unit. Capacity_ Type. CodeDetail            PermitUnit        Capacity                         Type                                                Code                                  CapacityTypeCodeDataType                                                                   0                    1   CHAR(1)
 55                                                   531                     Total number of units of
                                                                                                  PermitUnitQuantity Detail_ Permit Unit. Process Unit . Quantity
                                                                                                                                         BBIE                Detail
                                                            Number of Units within Process Unit Groupthe same process grouped together to form a single process unit group.    PermitUnit        PermitUnit                       Unit                                                Quantity                              PermitUnitQuantityDataType                                                                 0                    1   NUMBER(7)
 56                                                   534                     Indicates           CommercialStatusOwnerCode status.
                                                                                                                     commercial          BBIE
                                                            Commercial Status Owner the agency that defines the Detail_ Permit Unit. Commercial Status_ Owner. Code PermitUnit
                                                                                                                                                             Detail                              CommercialStatus                 Owner                                               Code                                  CommercialStatusOwnerCodeDataType                                                          0                    1   CHAR(2)
 57                                                   535   Commercial Status                     CommercialStatusCode Permit Unit. accepts hazardous waste
                                                                                                                     Detail_             BBIE                Detail
                                                                              Code indicating that the facility, whether public or private, Commercial Status_ Codefor the process unit group from a third party.
                                                                                                                                                                               PermitUnit        CommercialStatus                 Code                                                Code                                  CommercialStatusCodeDataType                                                               0                    1   CHAR(1)
 58                                                   536                     Indicates the       LegalOperatingStatusOwnerCode status code.
                                                                                                                     legal/operating     BBIE                Detail
                                                            Legal/Operating Status Owner agency that defines the Detail_ Permit Unit. Legal Operating Status_ Owner. Code      PermitUnit        LegalOperatingStatus             Owner                                               Code                                  LegalOperatingStatusOwnerCodeDataType                                                      0                    1   CHAR(2)
 59                                                   537                     Code                LegalOperatingStatusCode
                                                                                                                     Detail_ Permit legal status) conditions that reflect RCRA program activity requirements of a unit.
                                                                                                                                         BBIE                Detail
                                                            Legal/Operating Status used to indicate programmatic (operating and Unit. Legal Operating Status_ Code             PermitUnit        LegalOperatingStatus             Code                                                Code                                  LegalOperatingStatusCodeDataType                                                           0                    1   CHAR(4)
 60                                                   538                     Indicates the agency that defines the Detail_Permit Unit.BBIE
                                                            Unit of Measure Owner                                    unit of measure. Measurement. _ Owner. Code
                                                                                                  MeasurementOwnerCode                                       Detail            PermitUnit        Measurement                      Owner                                               Code                                  MeasurementOwnerCodeDataType                                                               0                    1   CHAR(2)
 61                                                                                               MeasurementUnit Detail_Permit Unit.BBIE
                                                            Unit of Measure Indicates the unit of measure                                                    Detail
                                                                                                                                           Measurement. _ Unit.Quantity        PermitUnit                                         Unit                                                Measure                               MeasurementUnitDataType                                                                    0                    1   CHAR(1)
 62                                                   542                     I                   SubprocessOwnerCodesubprocess code. BBIE
                                                            Subprocess Ownerndicates the agency that defines the Detail_ Permit Unit. Subprocess_ Owner. CodeDetail            PermitUnit        Subprocess                       Owner                                               Code                                  SubprocessOwnerCodeDataType                                                                0                    1   CHAR(2)
 63                                                   622                                         SubprocessCode unit group's wasteBBIE     Subprocess_ Code Detail
                                                            Subprocess Code Optional code to further delineate theDetail_ Permit Unit.treatment, storage or disposal process.  PermitUnit        Subprocess                       Code                         Code                   Code                                  SubprocessCodeDataType                                                                     0                    1   VARCHAR2(3)
 64                                                   546   Notes                                 SupplementalInformation Permit Unit. Supplemental_ Information
                                                                                                                     Detail_
                                                                              Additional description of the process unit group detail. BBIE                  Detail            PermitUnit        Supplemental                     Information                                         Text                                  SupplementalInformationDataType                                                            0                    1   VARCHAR2(240)
 65                                                                                               for process unit. Detail_ Permit Unit. Waste. Waste
                                                                              Waste information Waste                                    ASBIE                                 PermitUnit                                         Waste                                                                                     WasteDataType                     Waste                                                    0 unbounded
 66                                                                                               WasteDataType Waste. Details
                                                                              Waste code and unit of measure.                            ABIE                                  Waste                                              Details                                                                                   NA
 67                                                                           Handler Waste Code.                    W                   ASBIE
                                                                                                  HandlerWasteCode aste. Handler_ Waste Code                                   Waste                                              WasteCode                                                                                                   Handler
                                                                                                                                                                                                                                                                                                                            HandlerWasteCodeDataType          WasteCode                                                1                    1
 68                                                                           Unit of measure. MeasurementDataType   Measurement. DetailsABIE                                  Measurement                                        Details                      Details                                                      NA
 69                                                                                               TransactionCode Measurement. delete.   BBIE
                                                            Transaction Code Transaction code used to define the add, update, or Transaction. Code                             Measurement                                        Transaction                                         Code                                  TransactionCodeDataType                                                                    0                    1 CHAR(1)
 70                                                   538                     Indicates the agency that defines the Measurement. Owner. Code
                                                            Unit of Measure Owner                                    unit of measure. BBIE
                                                                                                  MeasurementOwnerCode                                                         Measurement       Measurement                      Owner                                               Code                                  MeasurementOwnerCodeDataType                                                               0                    1 CHAR(2)
 71                                                   631                     Code                MeasurementTypeCodeMeasurement. Type. Code
                                                                                                                                         BBIE
                                                            Unit of Measure Type indicating the unit of measure of the associated design capacity.                             Measurement       Measurement                      Type                                                Code                                  MeasurementTypeCodeDataType                                                                0                    1 CHAR(1)
 72




                                                                                                                                                                                                                                 3 of 15                                                                                                                                                                                                                            2/25/2012
1cdd2d9a-70d6-4b80-80ae-391d0f0e0328.xls                                                                                                                                                                                                                                                                                                                                                                                                      flow_Permitting




             X                    Y                           Z                AA                      AB                       AC               AD                 AE                  AF                  AG                  AH                  AI                AJ                 AK               AL                AM                AN                AO             AP              AQ            AR               BJ         BK
                                                                                                                                                                                EDSC                                                                                            CRM              CRM
                                                                                                                                             EDSC XM L Tag   EDSC St an d ard   Dic t io n ary En t ry                                      CRM M ajo r Dat a CRM M ajo r Dat a Co m p o u n d   Co m p o u n d                         CRM Dat a B lo c k CRM Dat a                                                    Mandatory Data
 1 M in L en g t h       M ax L en g t h         L en g t h           To t al Dig it s        Frac t io n Dig it s       Ow n in g Ag en c y Nam e           G ro u p           Nam e                  EDSC Fo rm at   EDR Id en t if ier   G ro u p          G ro u p ID       Dat a B lo c k   Dat a B lo c k ID   CRM Dat a B lo c k ID                 Elem en t   Co m m en t     RCRA Tab le    M o d u leNam e      Element




 2


 3




 4
 5
                                                                                                                                          InformationSyste Facility             Environmental       Alphanumeric                                                                                                                                                       Environmental
 6                   4                     12                                                                                             mIdentifier      Identification       Information         (30)                                                                                                                                                               Information     PUNIT          Permitting                     1
 7                                                                                                                                                                              System                                                                                                                                                                                 System
 8

  9
 10                                                               1                                                                                                                                                                                                                                                                                                                                                                  1
 11                                                                                      4                                                                                                                                                                                                                                                                                             PSERIES        Permitting                     1
 12                  1                     12                                                                                                                                                                                                                                                                                                                                          PSERIES        Permitting                     1
 13                                                               2                                                                                                                                                                                                                                                                                                                    PSERIES        Permitting                     0
 14                  1                      5                                                                                                                                                                                                                                                                                                                                          PSERIES        Permitting                     0
 15                                                               2                                                                                                                                                                                                                                                                                                                    PSERIES        Permitting                     0
 16                  1                      5                                                                                                                                                                                                                                                                                                                                          PSERIES        Permitting                     0
 17                                                               2                                                                                                                                                                                                                                                                                                                    PSERIES        Permitting                     0
 18                  1                      5                                                                                                                                                                                                                                                                                                                                          PSERIES        Permitting                     0
 19                                                               2                                                                                                                                                                                                                                                                                                                    PSERIES        Permitting                     0
 20                  1                       5                                                                                                                                                                                                                                                                                                                                         PSERIES        Permitting                     0
 21                  1                     240                                                                                                                                                                                                                                                                                                                                         PSERIES        Permitting                     0
 22
 23
 24                                                               1                                                                                                                                                                                                                                                                                                                                                                  1
 25                                                               2                                                                                                                                                                                                                                                                                                                                                                  1
 26                  1                      2                                                                                                                                                                                                                                                                                                                                          PEVENT         Permitting                     1
 27                  1                      7                                                                                                                                                                                                                                                                                                                                          PEVENT         Permitting                     1
 28                                                               1                                                                                                                                                                                                                                                                                                                    PEVENT         Permitting                     1
 29                                                                                      3                                                                                                                                                                                                                                                                                             PEVENT         Permitting                     1
 30                                                                                                                                                          Date                                   Date (YYYYMMDD)                                                                                                                                                                    PEVENT         Permitting                     0
 31                                                                                                                                                                                                                                                                                                                                                                                    PEVENT         Permitting                     0
 32                                                                                                                                                                                                                                                                                                                                                                                                                                  0
 33                  1                       2                                                                                                                                                                                                                                                                                                                                         PEVENT         Permitting                     0
 34                  1                       5                                                                                                                                                                                                                                                                                                                                         PEVENT         Permitting                     0
 35                  1                       2                                                                                                                                                                                                                                                                                                                                         PEVENT         Permitting                     0
 36                  1                       5                                                                                                                                                                                                                                                                                                                                         PEVENT         Permitting                     0
 37                  1                     240                                                                                                                                                                                                                                                                                                                                         PEVENT         Permitting                     0
 38
 39
 40                  1                      1                                                                                                                                                                                                                                                                                                                                                                                        1
 41                                                                                      4                                                                                                                                                                                                                                                                                             PUNIT          Permitting                     1
 42                  1                      18                                                                                                                                                                                                                                                                                                                                         PUNIT          Permitting                     1
 43                  1                     240                                                                                                                                                                                                                                                                                                                                         PUNIT          Permitting                     0
 44
 45
 46
 47                                                               1                                                                                                                                                                                                                                                                                                                                                                  1
 48                                                                                      4                                                                                                                                                                                                                                                                                             PUNIT_DETAIL   Permitting                     1
 49                                                               2                                                                                                                                                                                                                                                                                                                    PUNIT_DETAIL   Permitting                     1
 50                                                               3                                                                                                                                                                                                                                                                                                                    PUNIT_DETAIL   Permitting                     1
 51                                                                                                                                                                                                                                                                                                                                                                                    PUNIT_DETAIL   Permitting                     1
 52                                                                                      15                          3                                                                                                                                                                                                                                                                 PUNIT_DETAIL   Permitting                     1
 53                                                               2                                                                                                                                                                                                                                                                                                                    PUNIT_DETAIL   Permitting                     1
 54                                                               1                                                                                                                                                                                                                                                                                                                    PUNIT_DETAIL   Permitting                     1
 55                                                                                      7                                                                                                                                                                                                                                                                                             PUNIT_DETAIL   Permitting                     1
 56                                                               2                                                                                                                                                                                                                                                                                                                    PUNIT_DETAIL   Permitting                     1
 57                                                               1                                                                                                                                                                                                                                                                                                                    PUNIT_DETAIL   Permitting                     1
 58                                                               2                                                                                                                                                                                                                                                                                                                    PUNIT_DETAIL   Permitting                     1
 59                                                               4                                                                                                                                                                                                                                                                                                                    PUNIT_DETAIL   Permitting                     1
 60                                                               2                                                                                                                                                                                                                                                                                                                    PUNIT_DETAIL   Permitting                     1
 61                                                               1                                                                                                                                                                                                                                                                                                                                                                  1
 62                                                               2                                                                                                                                                                                                                                                                                                                    PUNIT_DETAIL Permitting                       0
 63                  1                       3                                                                                                                                                                                                                                                                                                                                                      Permitting
                                                                                                                                                                                                                                                                                                                                                                                       LU_SUBPROCESS_CODE                            0
 64                  1                     240                                                                                                                                                                                                                                                                                                                                         PUNIT_DETAIL Permitting                       0
 65
 66
 67
 68
 69                                                               1                                                                                                                                                                                                                                                                                                                                                                  1
 70                                                               2                                                                                                                                                                                                                                                                                                                    PUNIT_DETAIL Permitting                       1
 71                                                               1                                                                                                                                                                                                                                                                                                                                 Permitting
                                                                                                                                                                                                                                                                                                                                                                                       LU_UNIT_OF_MEASURE                            1
 72




                                                                                                                                                                                                                                                   4 of 15                                                                                                                                                                                         2/25/2012
1cdd2d9a-70d6-4b80-80ae-391d0f0e0328.xls                                                                                                                                                                                                                                                                                                                                                                                                                            flow_CorrectiveAction




            A                B               C                    D                   E                    F                   G                    H                    I                   J                   K                    L                   M                        N               O                    P                   Q                    R                    S                   T                   U                    V                       W
                                                                                                                                                                                                                                                                                                                                                     Assoc iated            Assoc iated
                     Orginal Data     Orginal Sourc e    Original Sourc e                                            Dic tionary Entry     ABIE/ASBIE/BBI      Objec t Class                          Property Term          Property Term                            Representation      Representation       Data Ty pe                            Objec t Class          Objec t Class        Business
 1    ID             Sourc e          ID                 Data Nam e          Definition          XM L Tag Nam e Nam e                      E                   Qualifier            Objec t Class     Qualifier              Possessive          Property Term        Term Qualifier      Term                 Qualifier           Data Ty pe        Qualifer               Term                 Term (s)            M in Oc c urs         M ax Oc c urs         Form at
 2                                                                           This is the root    HazardousW aste Hazardous                 ASBIE               HazardousW aste      CorrectiveAction  HazardousW aste                            Submission                                                                        HazardousW aste HazardousW aste          CorrectiveAction                                           1                    1
 3                                                                                               HazardousW aste Hazardous                 ABIE                HazardousW aste      CorrectiveAction                                                                                                                               NA
 4                                                                           Facility corrective CorrectiveActionF Hazardous               ASBIE               HazardousW aste      CorrectiveActionF CorrectiveAction
                                                                                                                                                                                    CorrectiveAction                                             FacilitySubmission                                                                CorrectiveActionF                        CorrectiveActionF                                          1 unbounded
 5                                                                           action              CorrectiveActionF Corrective Action       ABIE                                     acilitySubmission
                                                                                                                                                                                    CorrectiveActionF                                            Details                                                                           NA
                                                                                                                                                                                                                                                                                                                                   HandlerIDDataTy
 6                                                       EPA Handler ID                          acilitySubmission Facility
                                                                                                 HandlerID           Corrective Action
                                                                             Number that uniquely identifies the handler.                  BBIE                                     CorrectiveActionF Handler
                                                                                                                                                                                    acilitySubmission                                            Identifier           Identifier          Identifier                               pe                                       Handler                                                    1                    1 CHAR(12)
 7                                                                                               Area
                                                                             Corrective action area data.            Facility
                                                                                                                     Corrective Action     ASBIE                                    acilitySubmission
                                                                                                                                                                                    CorrectiveActionF                                            Area                                                                              AreaDataType
                                                                                                                                                                                                                                                                                                                                   AuthorityDataTyp                         Area                                                       0 unbounded
 8                                                                                               Authority           Facility
                                                                                                                     Corrective
                                                                             Authority and responsible corrective action entity. Action    ASBIE                                    acilitySubmission                                            Authority                                                                         e                                        Authority                                                  0 unbounded
                                                                                                                                                                                    CorrectiveActionF
 9                                                                                                  Event
                                                                              Corrective action event.                    Facility
                                                                                                                          Corrective Action ASBIE                                     acilitySubmission                                            Event                                                                          EventDataType                           Event                                                      0 unbounded
                                                                              Corrective action AreaDataType              Facility
                                                                                                                          Area. Details
 10                                                                           area data.                                                        ABIE                                  Area                                                         Details                                                                        NA
 11                                                      Transaction Code Transaction code used to define the add, update, or delete.
                                                                                                    TransactionCode Area. Transaction. Code     BBIE                                  Area                                                         Transaction                              Code                                  TransactionCodeDataType                                                                            0                      1    CHAR(1)
 12                                                368                        Code                  AreaSequenceNumber    to uniquely designate a group
                                                                                                                                                BBIE                                  Area                and
                                                         Area Sequence Number used for administrative purposes Area. _ Sequence. Number of units (or a single unit) with a common history Areaprojection of corrective action requirements.        Sequence                                 Number                                AreaSequenceNumberDataType                                                                         1                      1    NUMBER(4)
 13                                                370   Area Facility-wide Indicator that the corrective action applies to Facility -wide_ Indicator
                                                                              Indicates             Facility-wideIndicatorArea. the entire facility.
                                                                                                                                                BBIE                                  Area               Facility-wide                             Indicator                                Indicator                             Facility-wideIndicatorDataType                                                                     0                      1    CHAR(1)
 14                                                371   Area Name            Name or number assigned by the implementing agency to BBIE a corrective action area.
                                                                                                    Name                  Area. Name             identify                             Area                                                         Name                                     Name                                  NameDataType                                                                                       0                      1    VARCHAR2(40)
 15                                                369   Air Release Indicator                       has been a release to air (either within BBIEIndicator                           Area               Air
                                                                              Indicates that there AirReleaseIndicatorArea. Air_ Release.or beyond the facility boundary) from the unit/area. This may include releases of subsurface gas. Release                                          Indicator                             AirReleaseIndicatorDataType                                                                        0                      1    CHAR(1)
 16                                                372   Groundwater Release Indicator there GroundwaterReleaseIndicator
                                                                              Indicates that         has been a release Area. Groundwater_ Release. Indicator
                                                                                                                           to groundwater from the unit/area.
                                                                                                                                                BBIE                                  Area               Groundwater                               Release                                  Indicator                             GroundwaterReleaseIndicatorDataType                                                                0                      1    CHAR(1)
 17                                                374   Soil Release Indicator                                            to
                                                                                                     has been a release Area. (either withinBBIE    Indicator                         Area               Soil                                      Release
                                                                              Indicates that there SoilReleaseIndicator soilSoil_ Release.or beyond the facility boundary) from the unit/area. This may include subsoil contamination beneath the unit/area.                                Indicator                             SoilReleaseIndicatorDataType                                                                       0                      1    CHAR(1)
 18                                                375                        Indicates that                               to surface
                                                                                                     has been a release Area. Surface Water_ Release. Indicator
                                                                                                                                                BBIE                                  Area
                                                         Surface Water Release Indicator there SurfaceWaterReleaseIndicatorwater (either within or beyond the facility boundary) from the unit/area.     SurfaceWater                              Release                                  Indicator                             SurfaceWaterReleaseIndicatorDataType                                                               0                      1    CHAR(1)
 19                                                373   Regulated Unit Indicator
                                                                              Indicates that the corrective action applies to Regulated_ unit. Indicator
                                                                                                    RegulatedUnitIndicator a regulated Unit.
                                                                                                                          Area.                 BBIE                                  Area               Regulated                                 Unit                                     Indicator                             RegulatedUnitIndicatorDataType                                                                     0                      1    CHAR(1)
 20                                                378   EPA Responsible Person Owner agency that defines the person identifier.
                                                                              Indicates the         EPAResponsiblePersonDataOwnerCode
                                                                                                                          Area. EPAResponsiblePerson_ Data Owner. Code
                                                                                                                                                BBIE                                  Area               EPAResponsiblePerson                      DataOwner                                Code                                  EPAResponsiblePersonDataOwnerCodeDataType                                                          0                      1    CHAR(2)
 21                                                379   EPA Responsible Personor Region identifier (two characters) and initials of staff person (three characters).
                                                                              State Identifier      EPAResponsiblePersonIDArea. EPAResponsiblePerson_ Identifier
                                                                                                                                                BBIE                                  Area               EPAResponsiblePerson                      Identifier                               Identifier                            EPAResponsiblePersonIDDataType                                                                     0                      1    VARCHAR2(5)
 22                                                376   State Responsible Person Owneragency that defines the person identifier.
                                                                              Indicates the         StateResponsiblePersonDataOwnerCode Person_ Data Owner. Code
                                                                                                                          Area. State Responsible
                                                                                                                                                BBIE                                  Area               StateResponsiblePerson                    DataOwner                                Code                                  StateResponsiblePersonDataOwnerCodeDataType                                                        0                      1    CHAR(2)
 23                                                377   State Responsible Person Identifier currently responsible for overseeing the corrective actionIdentifier
                                                                              The state person StateResponsiblePersonID   Area. State Responsible Person_ area.
                                                                                                                                                BBIE                                  Area               StateResponsiblePerson                    Identifier                               Identifier                            StateResponsiblePersonIDDataType                                                                   0                      1    VARCHAR2(5)
 24                                                382   Notes                Additional description of the corrective action Supplemental_ Information
                                                                                                    SupplementalInformation area.
                                                                                                                          Area.                 BBIE                                  Area               Supplemental                              Information                              Text                                  SupplementalInformationDataType                                                                    0                      1    VARCHAR2(240)
 25                                                                           Details for authority AuthorityDataType Authority. Details ABIE
                                                                                                     and responsible corrective action entity.                                        Authority                                                    Details                                                                        NA
 26                                                                                                 TransactionCode Authority. or delete.
                                                         Transaction Code Transaction code used to define the add, update, Transaction. Code    BBIE                                  Authority                                                    Transaction                              Code                                  TransactionCodeDataType                                                                            0                      1    CHAR(1)
 27                                                                                                 in file name.         A                     BBIE
                                                         Activity Location Previously handled ActivityLocationCode uthority. Activity_ Location. Code                                 Authority          Activity                                  Location                                 Code                                  ActivityLocationCodeDataType                                                                       1                      1    CHAR(2)
 28                                                384                                              AuthorityDataOwnerCodeAuthority.
                                                         Authority Owner Indicates the agency that defines the authority. _ Data Owner. Code    BBIE                                  Authority          Authority                                 DataOwner                                Code                                  AuthorityDataOwnerCodeDataType                                                                     1                      1    CHAR(2)
 29                                                385   Authority Type                             AuthorityTypeCode Authority. _ Type. Code   BBIE
                                                                              A code used to indicate whether a permit, administrative order, or other authority has been issued Authority
                                                                                                                                                                                      to implement the corrective action process.
                                                                                                                                                                                                         Authority                                 Type                                     Code                                  AuthorityTypeCodeDataType                                                                          1                      1    VARCHAR2(5)
 30                                                387                        C                      agency responsibleAuthority. Responsible Agency_ Code or permit modification and for overseeing the activities imposed by that authority.
                                                         Responsible Agency ode indicating theResponsibleAgencyCode                             BBIE
                                                                                                                            for originating the specific order, permit                Authority          ResponsibleAgency                         Code                                     Code                                  ResponsibleAgencyCodeDataType                                                                      1                      1    CHAR(1)
 31                                                386   Effective Date                             EffectiveDate         Authority. Effective_BBIEDate
                                                                              For a permit modification the effective date is cited in that document. For a unilateral order or consent decree it is the date the authorized agency official signs the order, unless a different date is cited within the order.
                                                                                                                                                                                      Authority          Effective                                 Date                                     Date                                  EffectiveDateDataType                                                                              1                      1    DATE
 32                                                389   Issue Date                                  agency official signs the order, permit, BBIE
                                                                              Date the authorizedIssueDate                                       or
                                                                                                                          Authority. Issue_ Date permit modification.                 Authority          Issue                                     Date                                     Date                                  IssueDateDataType                                                                                  0                      1    DATE
 33                                                391   Revoke Date                                RevokeDate            Authority. Revoke_ Date
                                                                              The date when the corrective action authority is revoked. BBIE                                          Authority          Revoke                                    Date                                     Date                                  RevokeDateDataType                                                                                 0                      1    DATE
 34                                                390                        The                     the Director requires the owner/operator to establish and maintain an information repository at a location near the facility for the purpose of making accessible to interested parties documents, reports, and other publicEstablishedRepositoryCodeDataType
                                                                                                                          Authority.            BBIE
                                                         Repository Established action by whichEstablishedRepositoryCode Established_ Repository. Code                                Authority          Established                               Repository                               Code                                                                                                                                     0                      1
                                                                                                                                                                                                                                                                                                                                   information relevant to public understanding of the activities, findings, and plans for such corrective action initiatives.   CHAR(1)
 35                                                394                        Indicates the agency that defines the program. Responsible Lead Program_ Data Owner. Code Authority
                                                         Responsible Lead Program Owner                                   Authority.
                                                                                                    ResponsibleLeadProgramDataOwnerCode         BBIE                                                     ResponsibleLeadProgram
                                                                                                                                                                                                                              ResponsibleLeadProgram
                                                                                                                                                                                                                                                   DataOwner                                Code                                  ResponsibleLeadProgramDataOwnerCodeDataType                                                        0                      1    CHAR(2)
 36                                                395                        Code indicating theResponsibleLeadProgramID Responsible Lead Program_ Identifier
                                                         Responsible Lead Program                                         Authority.            BBIE
                                                                                                     program in which the organization establishes the applicable guidance that the authority should be issued.
                                                                                                                                                                                      Authority          ResponsibleLeadProgram                    Identifier                               Identifier                            ResponsibleLeadProgramIDDataType                                                                   0                      1    VARCHAR2(5)
 37                                                392                        Indicates Owner ResponsibleSuborganizationDataOwnerCode
                                                                                                                          Authority. Responsible Suborganization_ Data Owner. Code
                                                         Responsible Suborganizationthe agency that defines the suborganization identifier.     BBIE                                  Authority          ResponsibleSuborganization                DataOwner                                Code                                  ResponsibleSuborganizationDataOwnerCodeDataType                                                    0                      1    CHAR(2)
 38                                                393                        Code indicating theResponsibleSuborganizationID
                                                         Responsible Suborganization                                      Authority. Responsible overseeing the activities imposed by the authority.
                                                                                                                                                BBIE
                                                                                                     section of the organization accountable forSuborganization_ Identifier           Authority          ResponsibleSuborganization                Identifier                               Identifier                            ResponsibleSuborganizationIDDataType                                                               0                      1    VARCHAR2(5)
 39                                                398                        Indicates             ResponsiblePersonDataOwnerCode BBIE
                                                                                                                          Authority. Responsible Person_ Data Owner. Code
                                                         Responsible Person Owner the agency that defines the person identifier.                                                      Authority          ResponsiblePerson                         DataOwner                                Code                                  ResponsiblePersonDataOwnerCodeDataType                                                             0                      1    CHAR(2)
 40                                                399                        State or Region identifier (two characters) and initials of staff person (three characters).
                                                         Responsible Person Identifier              ResponsiblePersonID                         BBIE
                                                                                                                          Authority. Responsible Person_ Identifier                   Authority          ResponsiblePerson                         Identifier                               Identifier                            ResponsiblePersonIDDataType                                                                        0                      1    VARCHAR2(5)
 41                                                396   Attorney Owner                             EPAAttorneyDataOwnerCode EPAAttorney_ Data Owner. Code
                                                                                                                          Authority.
                                                                              Indicates the agency that defines the person identifier.          BBIE                                  Authority          EPAAttorney                               DataOwner                                Code                                  EPAAttorneyDataOwnerCodeDataType                                                                   0                      1    CHAR(2)
 42                                                397                                              EPAAttorneyID         Authority. EPAAttorney_ Identifier
                                                                                                                                                BBIE                                  Authority
                                                         Attorney Identifier The first two characters must be a Region code (R1 - R0) or a valid state postal code. The last three characters are a code or initials of the attorney.
                                                                                                                                                                                                         EPAAttorney                               Identifier                               Identifier                            EPAAttorneyIDDataType                                                                              0                      1    VARCHAR2(5)
 43                                                402   Notes                                      SupplementalInformation                     BBIE
                                                                              Additional description of the authority. Authority. Supplemental_ Information                           Authority          Supplemental                              Information                              Text                                  SupplementalInformationDataType                                                                    0                      1    VARCHAR2(240)
 44                                                                           Statutory citation. StatutoryCitation Authority. Statutory ASBIE Statutory Citation
                                                                                                                                                 Citation.                            Authority                                                    StatutoryCitation                                                              StatutoryCitationDataType               StatutoryCitation                                          0 unbounded
 45                                                                                                 Event
                                                                              Corrective action event.                                          ASBIE
                                                                                                                          Authority. Event. Event                                     Authority                                                    Event                                                                          EventDataType                           Event                                                      0 unbounded
 46                                                                                                  citation.            Statutory
                                                                              Details for statutory StatutoryCitationDataType Citation. Details ABIE                                  StatutoryCitation                                            Details                                                                        NA
 47                                                                                                 TransactionCode Statutory or delete.        BBIE
                                                         Transaction Code Transaction code used to define the add, update,Citation. Transaction. Code                                 StatutoryCitation                                            Transaction                              Code                                  TransactionCodeDataType                                                                            0                      1    CHAR(1)
 48                                                403                        Indicates the agency that defines the statutory citation. _BBIE Owner. Code
                                                         Statutory Citation Owner                                         Statutory Citation. Data
                                                                                                    StatutoryCitationDataOwnerCode                                                    StatutoryCitation StatutoryCitation                          DataOwner                                Code                                  StatutoryCitationDataOwnerCodeDataType                                                             1                      1    CHAR(2)
 49                                                473                                              StatutoryCitationID Statutory provision providing legal authority for imposition of requirements.
                                                         Statutory Citation Code designating specific statutory or regulatory Citation. _BBIE      Identifier                         StatutoryCitation StatutoryCitation                          Identifier                               Identifier                            StatutoryCitationIDDataType                                                                        1                      1    VARCHAR2(5)
 50                                                413   Notes                                      SupplementalInformation
                                                                                                                          Statutory Citation. Supplemental_ Information
                                                                              Additional description of the statute citation.                   BBIE                                  StatutoryCitation Supplemental                               Information                              Text                                  SupplementalInformationDataType                                                                    0                      1    VARCHAR2(240)
 51                                                                                                 EventDataType
                                                                              Details for corrective action event.        Event. Details        ABIE                                  Event                                                        Details                                                                        NA
 52                                                                                                 TransactionCode Event. Transaction. BBIE
                                                         Transaction Code Transaction code used to define the add, update, or delete.Code                                             Event                                                        Transaction                              Code                                  TransactionCodeDataType                                                                            0                      1    CHAR(1)
 53                                                                                                 in file name.         E                     BBIE
                                                         Activity Location Previously handled ActivityLocationCode vent. Activity_ Location. Code                                     Event              Activity                                  Location                                 Code                                  ActivityLocationCodeDataType                                                                       1                      1    CHAR(2)
 54                                                351                        Indicates the         CorrectiveActionEventDataOwnerCode BBIE Data Owner. Code
                                                                                                                          Event. Corrective Action_
                                                         Corrective Action Event Owner agency that defines the corrective action event.                                               Event              CorrectiveActionEvent                     DataOwner                                Code                                  CorrectiveActionEventDataOwnerCodeDataType                                                         1                      1    CHAR(2)
 55                                                447                        A code which corresponds to a specific Event. or event type. The first two characters indicate the event category and the last three characters the numeric event number.
                                                         Corrective Action Event Code                                      event Corrective Action_ . Code
                                                                                                    CorrectiveActionEventCode                   BBIE                                  Event              CorrectiveActionEvent                     Event                                    Code                                  CorrectiveActionEventCodeDataType                                                                  1                      1    VARCHAR2(7)
 56                                                354                        Code indicating theResponsibleAgencyCode Responsible BBIE corrective action event.
                                                         Event Responsible Agency                                           for overseeing a specific
                                                                                                     agency responsibleEvent.                     Agency_ Code                        Event              ResponsibleAgency                         Code                                     Code                                  ResponsibleAgencyCodeDataType                                                                      1                      1    CHAR(1)
 57                                                353   Event Sequence Number                      EventSequenceNumber _ Sequence.BBIE
                                                                                                                          Event.                   Number
                                                                              System-generated value used to uniquely identify multiple occurrences of a corrective action event.     Event              Event                                     Sequence                                 Number                                EventSequenceNumberDataType                                                                        1                      1    NUMBER(3)
 58                                                356   Actual Date of Event                       ActualDate            Event. Actual_ Date   BBIE
                                                                              Date on which actual completion of a corrective action event occurs.                                    Event              Actual                                    Date                                     Date                                  ActualDateDataType                                                                                 0                      1    DATE
 59                                                358   Original Scheduled The original
                                                                              Event Date                                  Event.                BBIE
                                                                                                    OriginalScheduledDate Original Scheduled_ Date                                    Event              OriginalScheduled                         Date                                     Date                                  OriginalScheduledDateDataType                                                                      0                      1    DATE
                                                                              scheduled
                                                                              Revised
 60                                                359   New Scheduled Event Date                   NewScheduledDateEvent. New Scheduled_ Date  BBIE                                  Event              NewScheduled                              Date                                     Date                                  NewScheduledDateDataType                                                                           0                      1    DATE
 61                                                360                        scheduled agency that
                                                                              Indicates the         ResponsibleSuborganizationDataOwnerCode
                                                                                                                          Event. Responsible BBIE
                                                         Event Responsible Suborganization Owner defines the suborganization identifier.          Suborganization_ Data Owner. Code Event                ResponsibleSuborganization                DataOwner                                Code                                  ResponsibleSuborganizationDataOwnerCodeDataType                                                    0                      1    CHAR(2)
 62                                                361                        Name or abbreviation of a state division/section (suborganization).
                                                         Event Responsible Suborganization ResponsibleSuborganizationID   Event. Responsible BBIE Suborganization_ Identifier         Event              ResponsibleSuborganization                Identifier                               Identifier                            ResponsibleSuborganizationIDDataType                                                               0                      1    VARCHAR2(5)
 63                                                362                        Indicates the agency that defines the person identifier.
                                                         Event Responsible Person Owner                                   Event. Responsible Person_ Data Owner. Code
                                                                                                    ResponsiblePersonDataOwnerCode BBIE                                               Event              ResponsiblePerson                         DataOwner                                Code                                  ResponsiblePersonDataOwnerCodeDataType                                                             0                      1    CHAR(2)
 64                                                363                        State or Region       ResponsiblePersonID   Event. initials of staff person (three characters).
                                                         Event Responsible Person Identifieridentifier (two characters) and Responsible BBIE      Person_ Identifier                  Event              ResponsiblePerson                         Identifier                               Identifier                            ResponsiblePersonIDDataType                                                                        0                      1    VARCHAR2(5)
 65                                                366   Notes                                      SupplementalInformation Supplemental_ Information
                                                                                                                          Event.
                                                                              Additional description of the corrective action event.            BBIE                                  Event              Supplemental                              Information                              Text                                  SupplementalInformationDataType                                                                    0                      1    VARCHAR2(240)
 66




                                                                                                                                                                                                                                   5 of 15                                                                                                                                                                                                                                     2/25/2012
1cdd2d9a-70d6-4b80-80ae-391d0f0e0328.xls                                                                                                                                                                                                                                                                                                                                                                   flow_CorrectiveAction




             X                 Y                     Z              AA                 AB               AC                     AD              AE                    AF                AG            AH                  AI         AJ               AK                    AL          AM                 AN               AO                 AP               AQ             AR                BJ

                                                                                                                    EDSC XM L Tag      EDSC Standard          EDSC Dic tionary                                 CRM M ajor Data CRM M ajor Data CRM Com pound CRM Com pound                        CRM Data Bloc k   CRM Data                                                              Mandatory Data
 1    M in Length       M ax Length         Length           TotalDigits       Frac tion Digits   Ow ning Agenc y   Nam e              Group                  Entry Nam e      EDSC Form at   EDR Identifier   Group           Group ID        Data Bloc k   Data Bloc k ID CRM Data Bloc k       ID                Elem ent          Com m ent        RCRA Table      M oduleNam e          Element
 2
 3
 4
 5
 6                  4                  12                                                                           InformationSyste   Facility               Environmental   Alphanumeric                                                                                                                                                                                                             1
 7                                                                                                                  mIdentifier        Identification         Information     (30)
 8
 9

 10
 11                                                      1                                                                                                                                                                                                                                                                                                                                             1
 12                                                                        4                                                                                                                                                                                                                                                                           AAREA           CorrectiveAction                1
 13                                                                                                                                                                                                            Spatial Data    SD             Area               SD.01                                              Area Type                          AAREA           CorrectiveAction                1
 14                 1                  40                                                                                                                                                                                                                                                                                                              AAREA           CorrectiveAction                1
 15                                                                                                                                                                                                            Release         R                             R.08
                                                                                                                                                                                                                                              Waste Management/Disposal         Receiving Environment
                                                                                                                                                                                                                                                                                                  R.07              Media Type                         AAREA           CorrectiveAction                1
 16                                                                                                                                                                                                            Release         R                             R.08
                                                                                                                                                                                                                                              Waste Management/Disposal         Receiving Environment
                                                                                                                                                                                                                                                                                                  R.07              Media Type                         AAREA           CorrectiveAction                1
 17                                                                                                                                                                                                            Release         R                             R.08
                                                                                                                                                                                                                                              Waste Management/Disposal         Receiving Environment
                                                                                                                                                                                                                                                                                                  R.07              Media Type                         AAREA           CorrectiveAction                1
 18                                                                                                                                                                                                            Release         R                             R.08
                                                                                                                                                                                                                                              Waste Management/Disposal         Receiving Environment
                                                                                                                                                                                                                                                                                                  R.07              Media Type                         AAREA           CorrectiveAction                1
 19                                                                                                                                                                                                                                                                                                                                                    AAREA           CorrectiveAction                0
 20                                                      2                                                                                                                                                                                                                                                                                             AAREA           CorrectiveAction                0
 21                 1                   5                                                                                                                                                                                                                                                                                                              AAREA           CorrectiveAction                0
 22                                                      2                                                                                                                                                                                                                                                                                             AAREA           CorrectiveAction                0
 23                 1                   5                                                                                                                                                                                                                                                                                                              AAREA           CorrectiveAction                0
 24                 1                 240                                                                                                                                                                                                                                                                                                              AAREA           CorrectiveAction                0
 25
 26                                                      1                                                                                                                                                                                                                                                                                                                                             1
 27                                                      2                                                                                                                                                                                                                                                                                                                                             1
 28                                                      2                                                                                                                                                                                                                                                                                             ACA_AUTHORITY CorrectiveAction                  1
 29                 1                   5                                                                                                                                                                                                                                                                                                              ACA_AUTHORITY CorrectiveAction                  1
 30                                                      1                                                                                                                                                                                                                                                                                             ACA_AUTHORITY CorrectiveAction                  1
 31                                                                                                                 PermitEffectiveDate                 3.4                   Date (YYYYMMDD)                  Permit          P              Monitoring Requirement
                                                                                                                                                                                                                                                                P.10            Limit Condition   P.12              Effective Date                     ACA_AUTHORITY CorrectiveAction                  1
 32                                                                                                                                                                                                                                                                                                                                                    ACA_AUTHORITY CorrectiveAction                  1
 33                                                                                                                                                                                                                                                                                                                                                    ACA_AUTHORITY CorrectiveAction                  1
 34                                                      1                                                                                                                                                                                                                                                                                             ACA_AUTHORITY CorrectiveAction                  0
 35                                                      2                                                                                                                                                                                                                                                                                             ACA_AUTHORITY CorrectiveAction                  1
 36                 1                   5                                                                                                                                                                                                                                                                                                              ACA_AUTHORITY CorrectiveAction                  1
 37                                                      2                                                                                                                                                                                                                                                                                             ACA_AUTHORITY CorrectiveAction                  0
 38                 1                   5                                                                                                                                                                                                                                                                                                              ACA_AUTHORITY CorrectiveAction                  0
 39                                                      2                                                                                                                                                                                                                                                                                             ACA_AUTHORITY CorrectiveAction                  0
 40                 1                   5                                                                                                                                                                                                                                                                                                              ACA_AUTHORITY CorrectiveAction                  0
 41                                                      2                                                                                                                                                                                                                                                                                             ACA_AUTHORITY CorrectiveAction                  0
 42                 1                   5                                                                                                                                                                                                                                                                                                              ACA_AUTHORITY CorrectiveAction                  0
 43                 1                 240                                                                                                                                                                                                                                                                                                              ACA_AUTHORITY CorrectiveAction                  0
 44
 45
 46
 47                                                      1                                                                                                                                                                                                                                                                                                                                             1
 48                                                      2                                                                                                                                                                                                                                                                                                           CorrectiveAction
                                                                                                                                                                                                                                                                                                                                                       ASTATUTE_CITATION                               1
 49                 1                   5                                                                           Citation                            29                    A(200)                           Enforcement     E              Enforcement Identification
                                                                                                                                                                                                                                                                 E.01                             E.03
                                                                                                                                                                                                                                                                                Enforcement Description             Enforcement Citation/Description                 CorrectiveAction
                                                                                                                                                                                                                                                                                                                                                       LU_STATUTORY_CITATION                           1
 50                 1                 240                                                                                                                                                                                                                                                                                                                            CorrectiveAction
                                                                                                                                                                                                                                                                                                                                                       ASTATUTE_CITATION                               0
 51
 52                                                      1                                                                                                                                                                                                                                                                                                                                             1
 53                                                      2                                                                                                                                                                                                                                                                                                                                             1
 54                                                      2                                                                                                                                                                                                                                                                                             AEVENT          CorrectiveAction                1
 55                 1                   7                                                                                                                                                                                                                                                                                                              LU_CA_EVENT     CorrectiveAction                1
 56                                                      1                                                                                                                                                                                                                                                                                             AEVENT          CorrectiveAction                1
 57                                                                        3                                                                                                                                                                                                                                                                           AEVENT          CorrectiveAction                1
 58                                                                                                                                                                                                                                                                                                                                                    AEVENT          CorrectiveAction                1
 59                                                                                                                                                                                                                                                                                                                                                    AEVENT          CorrectiveAction                0
 60                                                                                                                                                                                                                                                                                                                                                    AEVENT          CorrectiveAction                0
 61                                                      2                                                                                                                                                                                                                                                                                             AEVENT          CorrectiveAction                0
 62                 1                   5                                                                                                                                                                                                                                                                                                              AEVENT          CorrectiveAction                0
 63                                                      2                                                                                                                                                                                                                                                                                             AEVENT          CorrectiveAction                0
 64                 1                   5                                                                                                                                                                                                                                                                                                              AEVENT          CorrectiveAction                0
 65                 1                 240                                                                                                                                                                                                                                                                                                              AEVENT          CorrectiveAction                0
 66




                                                                                                                                                                                                                     6 of 15                                                                                                                                                                                         2/25/2012
1cdd2d9a-70d6-4b80-80ae-391d0f0e0328.xls                                                                                                                                                                                                                                                                                                                                                                  flow_WA




           C                         D                            E                                       F                                    G                 H                I                J                K         L              M               N               O               P               Q                R               S                T           U                 V

                                                                                                                                                                                                                         Property                                                                                             Associated     Associated
    Orginal                                                                                                                                           ABIE/ASBIE/B Object Class                        Property          Term             Property                         Representatio                                     Object Class Object Class      Business
  1 Source ID       Original Source Data Name        Definition           XML Tag Name                                                                BIE
                                                                                                                                     Dictionary Entry Name             Qualifier       Object Class Term Qualifier Possessive             Term                                n Qualifier Data Type Qualifier
                                                                                                                                                                                                                                                            Representation TermTerm                           Data Type        Qualifer          Term        Term(s)   Min Occurs        Max Occurs
  2                                                  This is the root     HazardousWasteActivitySubmission                           Hazardous        ASBIE            HazardousWas Activity           HazardousWas                       Submission                                                        HazardousWas HazardousWas Activity                                      1                 1
  3                                                                       HazardousWasteActivityDataType                             Hazardous        ABIE             HazardousWas Activity                                              Details                                                           NA
  4                                                  Facility waste       WasteActivityFacilitySubmission                            Waste_           ASBIE            Waste           Activity        Facility                           Submission                                                        FacilitySubmis Facility         Submission                              1 unbounded
  5                                                                       for waste activity.
                                                     Facility submission WasteActivityFacilitySubmissionDataType                     Site_ Submission. Details
                                                                                                                                                      ABIE             Site            Submission                                         Details                                                           NA
  6          1449   EPA Handler ID                                        HandlerID
                                                     Number that uniquely identifies the handler.                                                     BBIE
                                                                                                                                     Site_ Submission. Handler_ Identifier
                                                                                                                                                                       Site            Submission      Handler                            Identifier                      Identifier                        HandlerIDDataType                                                       1                 1
  7           650   Include in National Report                            IncludeInNationalReportIndicator
                                                     A flag indicating whether the record is to be included in the National Biennial Site_ Submission. Waste Report. Site Report. Indicator
                                                                                                                                     RCRA Hazardous Include In National
                                                                                                                                                      BBIE                             Submission                                         IncludeInNationalReport         Indicator                         IncludeInNationalReportIndicatorDataType                                1                 1
  8                 Submittal Reason                 Reason for Submittal.SubmittalReasonCode                                                         BBIE
                                                                                                                                     Site_ Submission. Submittal Reason. Code
                                                                                                                                                                       Site            Submission                                         SubmittalReason                 Code                              SubmittalReasonCodeDataType                                             1                 1
  9           667   Notes                                                 SupplementalInformation
                                                     Additional description of the GM Form.                                                           BBIE
                                                                                                                                     Site_ Submission. Supplemental_ Information
                                                                                                                                                                       Site            Submission      Supplemental                       Information                     Text                              SupplementalInformationDataType                                         0                 1
 10                                                  Waste activity and address information
                                                                          WasteActivityAddress                                       Site_ Submission. Waste Activity_ Address. Waste Activity Address
                                                                                                                                                      ASBIE            Site            Submission      WasteActivity                      Address                                                           WasteActivityAddressDataType WasteActivityAddress                       0                 1
 11                                                                       WasteManagement
                                                     Waste Management Information                                                                     ASBIE            Site
                                                                                                                                     Site_ Submission. Waste Management. Waste Management
                                                                                                                                                                                       Submission                                         WasteManagement                                                   WasteManagementDataType         WasteManagement                         0                 1
 12                                                                       WasteReceived
                                                     Waste received information                                                                       ASBIE            Site
                                                                                                                                     Site_ Submission. Waste Received. Waste Received  Submission                                         WasteReceived                                                     WasteReceivedDataType           WasteReceived                           0                 1
 13                                                                       WasteManagementDataType
                                                     Waste Management Information.                                                                    ABIE
                                                                                                                                     Waste Management. Details                         WasteManagement                                    Details                                                           NA
 14                 Transaction Code                 Transaction code used to define the add, update, or delete.
                                                                          TransactionCode                                            Waste Management. Transaction. Code
                                                                                                                                                      BBIE                             WasteManagement                                    Transaction                     Code                              TransactionCodeDataType                                                 0                 1
 15           646   Hazardous Waste Stream Form GM Page Number of theHazardousWasteStreamFormPageNumber
                                                     Page number           form used to enter the information in the Stream segment and all child segments of Stream.
                                                                                                                                                      BBIE                             WasteManagement
                                                                                                                                     Waste Management. Hazardous Stream Form_ Page. Number             HazardousWasteStreamForm           Page                            Number                            HazardousWasteStreamFormPageNumberDataType                              1                 1
 16           656   Waste Form Code                  This field provides the form code used to describe the waste. Form codes indicate whether the waste is a Code type of lab pack, sludge, gas, solid, or liquid. Valid values are “B” followed by three digits. The site may have left this field blank. WasteFormCodeDataType
                                                                          WasteFormCode                                              Waste Management. Form. specific
                                                                                                                                                      BBIE                             WasteManagement                                    WasteForm                       Code                                                                                                      0                 1
 17           652   Unit of Measure Code             Code indicating the MeasurementCode
                                                                           unit of measure.                                                           BBIE
                                                                                                                                     Waste Management. Measurement. Code               WasteManagement                                    Measurement                     Code                              MeasurementCodeDataType                                                 1                 1
 18           651   Waste Density                    Density of the waste stream in pounds/gallons or specific gravity.
                                                                          DensityMeasurement                                                          BBIE
                                                                                                                                     Waste Management. Density. Measurement            WasteManagement                                    Density                         Measurement                       DensityMeasurementDataType                                              1                 1
 19           953   Density Unit of Measure Code                          DensityMeasurementCode                                                      BBIE
                                                                                                                                     Waste Management. Density_ Measurement. Code      WasteManagement Density                            Measurement
                                                     Code which denotes the unit of measure of the density of the waste stream, used in conjunction with the reported quantity of the waste stream received by a site (Form WR) or generated by a site (Form GM). Code                                      DensityMeasurementCodeDataType                                          1                 1
 20                 Management Method Code           Origin managementOriginManagementMethodCode
                                                                            method for source code G25.                              Waste Management. Origin_ Method. Code
                                                                                                                                                      BBIE                             WasteManagement Origin                             ManagementMethod                Code                              OriginManagementMethodCodeDataType                                      1                 1
 21                 Source Code                      Source Code.         SourceCode                                                 Waste Management. Source. Code
                                                                                                                                                      BBIE                             WasteManagement                                    Source                          Code                              SourceCodeDataType                                                      1                 1
 22                 Generated Quantity               Quantity Generated GeneratorQuantity
                                                                           in Reporting Year.                                        Waste Management. Generator. Quantity
                                                                                                                                                      BBIE                             WasteManagement                                    Generator                       Quantity                          GeneratorQuantityDataType                                               1                 1
 23                 DESCRIPTION                      Description of the GM Form.
                                                                          Description                                                Waste Management. Description
                                                                                                                                                      BBIE                             WasteManagement                                    Description                     Text                              DescriptionDataType                                                     0                 1
 24                 NOTES                            Additional description of the GM Form.
                                                                          SupplementalInformation                                    Waste Management. Supplemental_ Information WasteManagement
                                                                                                                                                      BBIE                                             Supplemental                       Information                     Text                              SupplementalInformationDataType                                         0                 1
 25                 ON_SITE_MANAGEMENT               Management method flag indicating the on-site management of the waste stream. Management. On Site. Indicator
                                                                          OnSiteManagementIndicator                                  Waste            BBIE                             WasteManagement                                    OnSiteManagement                Indicator                         OnSiteManagementIndicatorDataType                                       1                 1
 26                 OFF_SITE_SHIPMENT                Management method flag indicating the off-site shipment of the waste stream.
                                                                          OffSiteShipmentIndicator                                   Waste Management. Off Site Shipment. Indicator WasteManagement
                                                                                                                                                      BBIE                                                                                OffSiteShipment                 Indicator                         OffSiteShipmentIndicatorDataType                                        1                 1
 27                                                  Code used to describe hazardous waste.
                                                                          WasteCode                                                  Waste Management. Code. Waste Code
                                                                                                                                                      BBIE                             WasteManagement                                    WasteCode                                                         WasteCodeDataType               WasteCode                               0 unbounded
 28                                                  Details for managing off-site shipment of the waste stream.
                                                                          OffSiteShipment                                                             ASBIE                            WasteManagement
                                                                                                                                     Waste Management. Off Site Shipment. Off Site Shipment                                               OffSiteShipment                                                   OffSiteShipmentDataType         OffSiteShipment                         0 unbounded
 29                                                  Details for on-site management of the waste stream.
                                                                          OnSiteManagement                                           Waste Management. On Site. On Site Management
                                                                                                                                                      ASBIE                            WasteManagement                                    OnSiteManagement                                                  OnSiteManagementDataType        OnSiteManagement                        0 unbounded
 30                                                  Details for managing off-site shipment of the waste stream.
                                                                          OffSiteShipmentDataType                                    Off Site Shipment. Details
                                                                                                                                                      ABIE                             OffSiteShipment                                    Details                                                           NA
 31                 Transaction Code                                      TransactionCode
                                                     Transaction code used to define the add, update, or delete.                                      BBIE
                                                                                                                                     Off Site Shipment. Transaction. Code              OffSiteShipment                                    Transaction                     Code                              TransactionCodeDataType                                                 0                 1
 32                 Page Number                                            form used to                                              Off Site child segments Number
                                                                                                                                                      BBIE
                                                     Page number of thePageNumber enter the information in the Stream segment and allShipment. Page.of Stream.                         OffSiteShipment                                    Page                            Number                            PageNumberDataType                                                      1                 1
 33           685   TDR Site Sequence Number                              SequenceNumber
                                                     Sequence number for Off-site Shipment on Form GM.                               Off Site Shipment. Sequence. Number
                                                                                                                                                      BBIE                             OffSiteShipment                                    Sequence                        Number                            SequenceNumberDataType                                                  1                 1
 34           764   Management Method Code                                ManagementMethodCode
                                                     Management method code for the on-site management, off-site management, or Site Shipment. Management Method. Code OffSiteShipment
                                                                                                                                     Off generated residual waste of the waste stream.
                                                                                                                                                      BBIE                                                                                ManagementMethod                Code                              ManagementMethodCodeDataType                                            0                 1
 35          1167   TDR Identification Number                             TDRID                                                      Off
                                                     Number assigned by EPA or the state that uniquely identifies the generating site.Site Shipment. TDR_ Identifier
                                                                                                                                                      BBIE                             OffSiteShipmentTDR                                 Identifier                      Identifier                        TDRIDDataType                                                           1                 1
 36           687   TDR Quantity                                           the waste described that was shipped during the current Off Site Shipment. TDR. Quantity
                                                     The total quantity ofTDRQuantity                                                reporting year. BBIE                              OffSiteShipment                                    TDR                             Quantity                          TDRQuantityDataType                                                     1                 1
 37                                                  Details for on-site management of the waste stream.
                                                                          OnSiteManagementDataType                                   On Site Management. Details
                                                                                                                                                      ABIE                             OnSiteManagement                                   Details                                                           NA
 38                 Transaction Code                                      TransactionCode
                                                     Transaction code used to define the add, update, or delete.                                      BBIE
                                                                                                                                     On Site Management. Transaction. Code             OnSiteManagement                                   Transaction                     Code                              TransactionCodeDataType                                                 0                 1
 39                 Page Number                                            form used to                                              On Site child segments of Stream.
                                                                                                                                                      BBIE
                                                     Page number of thePageNumber enter the information in the Stream segment and all Management. Page. Number                         OnSiteManagement                                   Page                            Number                            PageNumberDataType                                                      1                 1
 40           673   System Type Page Number                               SystemTypeSequenceNumber
                                                     Sequence number for On-Site Treatment System on Form GM.                                         BBIE
                                                                                                                                     On Site Management. System Type_ Sequence. Number OnSiteManagementSystemType                         Sequence                        Number                            SystemTypeSequenceNumberDataType                                        1                 1
 41           764   Management Method Code                                ManagementMethodCode
                                                     Management method code for the on-site management, off-site management, or Site Management. Method. Code
                                                                                                                                     On generated residual waste of the waste stream. OnSiteManagement
                                                                                                                                                      BBIE                                                                                ManagementMethod                Code                              ManagementMethodCodeDataType                                            1                 1
 42          1140   Managed Quantity                                      ManagedQuantity
                                                     Quantity of waste described in Section I of Form GM that was treated, disposed, Site Management. Managed. Quantity the current reporting year.
                                                                                                                                     On discharged, or recycled on-site during
                                                                                                                                                      BBIE                             OnSiteManagement                                   Managed                         Quantity                          ManagedQuantityDataType                                                 1                 1
 43                                                                       WasteReceivedDataType
                                                     Waste received information.                                                                      ABIE
                                                                                                                                     Waste Received. Details                           WasteReceived                                      Details                                                           NA
 44                 Transaction Code                                      TransactionCode
                                                     Transaction code used to define the add, update, or delete.                                      BBIE
                                                                                                                                     Waste Received. Transaction. Code                 WasteReceived                                      Transaction                     Code                              TransactionCodeDataType                                                 0                 1
 45          1164                                    Page number
                    Hazardous Waste Stream Form WR Page Number of theHazardousWasteStreamFormPageNumber
                                                                           form used to enter the information in the Stream segment and all child segments of Stream. Form_ Page.WasteReceived HazardousWasteStreamForm
                                                                                                                                     Waste Received. Hazardous Stream
                                                                                                                                                      BBIE                              Number                                            Page                            Number                            HazardousWasteStreamFormPageNumberDataType                              1                 1
 46           707   Form WR Waste Subpage Number                          sequence number.
                                                     Form WR subpage FormWRWasteSubpageNumber                                        Waste Received. FormWRWaste_ Subpage. Number
                                                                                                                                                      BBIE                             WasteReceived FormWRWaste                          Subpage                         Number                            FormWRWasteSubpageNumberDataType                                        1                 1
 47           716   Waste Form Code                                                                                                  Waste Received. waste Code
                                                     This field provides the form code used to describe the waste. Form codes indicate whether the Form. is a specific type of lab pack, sludge, gas, solid, or liquid. Valid values are “B” followed by three digits.
                                                                          FormCode                                                                    BBIE                             WasteReceived                                      Form                            Code                              FormCodeDataType                                                        0                 1
 48           652   Unit of Measure Code             Unit of measure code.MeasurementCode                                            Waste Received. Measurement. Code
                                                                                                                                                      BBIE                             WasteReceived                                      Measurement                     Code                              MeasurementCodeDataType                                                 1                 1
 49           651   Waste Density                                         WasteDensityMeasurement
                                                     Density of the waste stream in pounds/gallons or specific gravity.              Waste Received. Density. Measurement
                                                                                                                                                      BBIE                             WasteReceived                                      WasteDensity                    Measurement                       WasteDensityMeasurementDataType                                         1                 1
 50           953   Density Unit of Measure Code                          DensityMeasurementCodeIndicator
                                                     Code which denotes the unit of measure of the density of the waste stream, used in conjunction with theMeasurement Code. the waste stream received by a site (Form WR) or generated by a site (Form GM). Indicator
                                                                                                                                     Waste Received. Density_ reported quantity of Indicator
                                                                                                                                                      BBIE                             WasteReceived Density                              MeasurementCode                                                   DensityMeasurementCodeIndicatorDataType                                 1                 1

 51            684 Management Method Code                                      ManagementMethodCode
                                                          Management method code for the on-site management, off-site management, or generated residual waste of Method. Code
                                                                                                                                           Waste Received. Management the waste stream. WasteReceived
                                                                                                                                                            BBIE                                                                      ManagementMethod                Code                             ManagementMethodCodeDataType                                                 1                 1
 52            684 TDR Identification Number                                   TDRIDIdentifer                                              Waste Received. TDR_ Identifier. Identifer
                                                                                                                                                            BBIE
                                                          Number assigned by EPA or the state that uniquely identifies the handler or off-site facility to which waste was shipped.              WasteReceived TDR                    Identifier                      Identifer                        TDRIDIdentiferDataType                                                       1                 1
 53            697 TDR Quantity                                                 the waste described that was received during the currentWaste Received. TDR. Quantity
                                                          The total quantity ofTDRQuantity                                                  reporting year. BBIE                                 WasteReceived                        TDR                             Quantity                         TDRQuantityDataType                                                          1                 1
 54                Description                                                 Description
                                                          Waste Stream Description.                                                                         BBIE
                                                                                                                                           Waste Received. Description                           WasteReceived                        Description                     Text                             DescriptionDataType                                                          0                 1
 55            727 Notes                                                       SupplementalInformation
                                                          Additional description of the WR Form.                                                            BBIE
                                                                                                                                           Waste Received. Supplemental_ Information             WasteReceived Supplemental           Information                     Text                             SupplementalInformationDataType                                              0                 1
 56                                                       Federal waste codes. FederalWasteCode                                                             BBIE
                                                                                                                                           Waste Received. Federal_ Code. Waste Code             WasteReceived Federal                WasteCode                                                        WasteCodeDataType              WasteCode                                     0 unbounded
 57                                                       Waste activity
                                                          State waste codes. StateWasteCode                                                Waste Activity BBIE
                                                                                                                                           Waste Received. State_ Code. Waste Code               WasteActivityA
                                                                                                                                                                                                 WasteReceived State                  WasteCode                                                        WasteCodeDataType              WasteCode                                     0 unbounded
 58                                                       and address
                                                          Waste activity       WasteActivityAddressDataType                                Address.
                                                                                                                                           Waste Activity   ABIE                                 ddress
                                                                                                                                                                                                 WasteActivityA                       Details                                                          NA
                                                                                                                                                                                                                                                                                                       WasteActivityA
 59                                                       and address
                                                          Waste activities     AddressDetailsWasteActivity                                 Address.
                                                                                                                                           Waste Activity ASBIE                                  ddress
                                                                                                                                                                                                 WasteActivityA                       AddressDetails                                                   WasteActivity WasteActivity AddressDetails
                                                                                                                                                                                                                                                                                                       ddressDetailsD                                                               0                 1
 60                                                       details
                                                          Waste activity       DetailsWasteActivity                                        Address.
                                                                                                                                           Waste Activity ASBIE                                  ddress
                                                                                                                                                                                                 WasteActivityA                       Details                                                          DetailsDataTyp WasteActivity Details                                         0                 1
 61                                                       and address          WasteActivityAddressDetailsDataType                         Address          ABIE                                 ddressDetails
                                                                                                                                                                                                 WasteActivityA                       Details                                                          NA
 62                                                                            LocationAddress
                                                          Location address information.                                                                                                          ddressDetails
                                                                                                                                                                                                 WasteActivityA
                                                                                                                                           Waste Activity Address Details. Location. Location Address
                                                                                                                                                            ASBIE                                                                     LocationAddress                                                                                 LocationAddress                               0                 1
 63                                                                             specific to mailing addresses.
                                                          Address infromationMailingAddress                                                                                                      ddressDetails
                                                                                                                                                                                                 WasteActivityA
                                                                                                                                           Waste Activity Address Details. Mailing. Mailing Address
                                                                                                                                                            ASBIE                                                                     MailingAddress                                                                                  MailingAddress                                0                 1
 64                                                                            Contact
                                                          Contains contact and contact address information.                                Waste Activity Address Details. Contact. Contact ddressDetails
                                                                                                                                                            ASBIE                                WasteActivityA                       Contact                                                                                         Contact                                       0                 1
 65                                                                            W
                                                          Waste actvity details asteActivityWasteActivityDetails                                                                                 ddressDetails
                                                                                                                                                                                                 WasteActivityA
                                                                                                                                           Waste Activity Address Details. Waste Activity. Waste Activity Details
                                                                                                                                                            ASBIE                                                                     Waste Activity                                                   WasteActivityDetailsDataType WasteActivityDetails                            0                 1
 66                                                                            FederalWasteGenerator                                       Waste Activity ASBIE                                  ddressDetails Federal
                                                                                                                                                                                                 WasteActivityA
                                                          Federal code indicating that the handler is engaged in the generation of hazardous waste. Address Details. Federal_ Generator. Waste Generator                              WasteGenerator                                                   WasteGeneratorDataType         WasteGenerator                                0                 1
 67                                                                            StateWasteGenerator                                         Waste Activity Address Details. State_ Generator.ddressDetails State
                                                          State code indicating that the handler is engaged in the generation of hazardous waste.           ASBIE                                WasteActivityA
                                                                                                                                                                                                  Waste Generator                     WasteGenerator                                                   WasteGeneratorDataType         WasteGenerator                                0                 1
 68                                                       Used Oil codes.      UsedOil                                                                      ASBIE
                                                                                                                                           Waste Activity Address Details. Used Oil. Used Oil    ddressDetails
                                                                                                                                                                                                 WasteActivity                        UsedOil                                                          UsedOilDataType                UsedOil                                       0 unbounded
 69                                                       Waste activities details.
                                                                               WasteActivityDetailsDataType                                Waste Activity Details. Details
                                                                                                                                                            ABIE                                 Details
                                                                                                                                                                                                 WasteActivity                        Details                                                          NA
 70                                                                            NAICS
                                                          North American Industry Classification Status codes reported for the handler. Waste Activity Details. NAICS. NAICS
                                                                                                                                                            ASBIE                                Details
                                                                                                                                                                                                 WasteActivity                        NAICS                                                            NAICSDataType                  NAICS                                         0   unbounded
 71                                                       Certification information for the person who certified report to the authorizing agency.Activity Details. Certification. Certification Details
                                                                               Certification                                               Waste            ASBIE                                WasteActivity                        Certification                                                    CertificationDataType          Certification                                 0   unbounded
 72                                                       State waste activity StateActivity
                                                                               of the handler.                                             Waste Activity Details. State. State Activity
                                                                                                                                                            ASBIE                                Details
                                                                                                                                                                                                 WasteActivity                        StateActivity                                                    StateActivityDataType          StateActivity                                 0   unbounded
 73                                                                            Operator Information.
                                                          Handler Owner and FacilityOwnerOperator                                                           ASBIE                                Details
                                                                                                                                                                                                 WasteActivity
                                                                                                                                           Waste Activity Details. Facility_ Owner Operator. Owner Operator Facility                  OwnerOperator                                                                     Facility
                                                                                                                                                                                                                                                                                                       FacilityOwnerOperatorDataType OwnerOperator                                  0   unbounded
 74                                                                            FederalUniversalWasteActivity                               Waste Activity ASBIE                                  Details
                                                                                                                                                                                                 WasteActivity Federal
                                                          Federal code indicating that the handler is engaged in the generation of hazardous waste. Details. Federal_ Universal. Universal Waste Activity                             UniversalWaste                                                                    Federal       UniversalWasteActivity
                                                                                                                                                                                                                                                                                                       StateUniversalWasteActivityDataType                                          0   unbounded
 75                                                       State code indicating that the handler is engaged in the generation of hazardous waste.
                                                                               StateUniversalWasteActivity                                                  ASBIE                                Details
                                                                                                                                           Waste Activity Details. State_ Universal. Universal Waste Activity State                   UniversalWaste                                                                    State         UniversalWasteActivity
                                                                                                                                                                                                                                                                                                       StateUniversalWasteActivityDataType                                          0   unbounded
 76




                                                                                                                                                                                                               7 of 15                                                                                                                                                                                    2/25/2012
1cdd2d9a-70d6-4b80-80ae-391d0f0e0328.xls                                                                                                                                                                                                                                                                                                                         flow_WA




               W             X               Y              Z              AA               AB               AC            AD                AE                 AF          AG              AH                 AI        AJ             AK              AL            AM              AN        AO        AP        AQ            AR              BJ        BK

                                                                                                                                          EDSC             EDSC                                                                   CRM            CRM
                                                                                          Fraction                     EDSC XML          Standard        Dictionary                              CRM Major          CRM Major     Compound       Compound      CRM Data       CRM Data     CRM Data                                           Mandatory
  1   Format            Min Length       Max Length       Length       Total Digits        Digits        Owning Agency Tag Name           Group         Entry Name    EDSC Format EDR Identifier Data Group         Data Group ID Data Block     Data Block ID Block          Block ID     Element    Comment   RCRA Table   ModuleName      Data Element
  2
  3
  4
  5
  6   CHAR(12)                       4            12                                                                                 Facility Identification
                                                                                                                     InformationSystemIdentifier                        Alphanumeric (30)
                                                                                                                                                        Environmental Information System Identification Number                   Facility Site               4                                                             Waste
                                                                                                                                                                                                                                                                                                                AR_BWM_ACTIVITY Activity                1
  7   CHAR(1)                                                                                                                                                                                                                                                                                                   BGM_BASIC Waste Activity                1
  8   CHAR(2)                                                      2                                                                                                                                                                                                                                                       Waste Activity               0
  9   VARCHAR2(240)                  1           240                                                                                                                                                                                                                                                            BGM_BASIC Waste Activity                1
 10
 11
 12
 13
 14   CHAR(1)                                                      1                                                                                                                                                                                                                                                        Waste Activity              1
 15   CHAR(5)                                                      5                                                                                                                                                                                                                                            BGM_BASIC Waste Activity                0
 16   CHAR(4)                                                      4                                                                                                                                                                                                                                            BGM_BASIC Waste Activity                1
 17   CHAR(2)                                                      2                                                 ResultValueUn 2.1.2                              A(10)                                                                                                                                     BGM_BASIC Waste Activity                1
 18   NUMBER(5,2)                                                                     5              2                               Permitting Information
                                                                                                                     FacilityFeatureCharacteristicMeasure             Alphanumeric                     Substance    S                           S.01
                                                                                                                                                                                                                                 Substance Identification                      S.04
                                                                                                                                                                                                                                                                 Substance Property        Density              BGM_BASIC Waste Activity                1
 19   CHAR(1)                                                      1                                                                 2.1.2
                                                                                                                     ResultValueUnitMeasureName                       A(10)
                                                                                                                                                                      Alphanumeric                                                                                                                                          Waste Activity
                                                                                                                                                                                                                                                                                                                LU_DENSITY_UNIT_OF_MEASURE              1
 20   CHAR(4)                                                      4                                                                 Permitting Information
                                                                                                                     MethodologyTypeText                              (10)                                                                                                                                                  Waste Activity              1
 21   CHAR(1)                                                      1                                                                                                                                                                                                                                                        Waste Activity              1
 22   NUMBER(13,2)                                                               13                  2                                                                                                                                                                                                                      Waste Activity              1
 23   VARCHAR2(240)                  1           240                                                                                                                                                                                                                                                                        Waste Activity              0
 24   VARCHAR2(240)                  1           240                                                                                                                                                                                                                                                                        Waste Activity              0
 25   CHAR(1)                                                                                                                      Permitting Information
                                                                                                                     MethodologyTypeText                              Alphanumeric (30)                                                                                                                                     Waste Activity              1
 26   CHAR(1)                                                                                                                      Permitting Information
                                                                                                                     MethodologyTypeText                              Alphanumeric (30)                                                                                                                                     Waste Activity              1
 27   VARCHAR2(6)                    1                6                                                                                                                                                                                                                                                                                                 1
 28
 29
 30
 31   CHAR(1)                                                      1                                                                                                                                                                                                                                                       Waste Activity               1
 32   NUMBER(5)                                                                       5                                                                                                                                                                                                                                    Waste Activity
                                                                                                                                                                                                                                                                                                                BGM_OFFSITE_SHIPMENT                    0
 33   NUMBER(5)                                                                       5                                                                                                                                                                                                                                    Waste Activity
                                                                                                                                                                                                                                                                                                                BGM_OFFSITE_SHIPMENT                    1
 34   CHAR(4)                                                      4                                                 MethodologyTypeText
                                                                                                                                   Permitting Information             Alphanumeric (30)                                                                                                                                     Waste Activity
                                                                                                                                                                                                                                                                                                                LU_MANAGEMENT_METHOD                    1
 35   VARCHAR2(12)                   1            12                                                                                                                                                                                                                                                                        Waste Activity
                                                                                                                                                                                                                                                                                                                BR1_BASIC_FORM_WR_INFO                  1
 36   NUMBER (18,7)                                                              18                  7                                                                                                                                                                                                                      Waste Activity
                                                                                                                                                                                                                                                                                                                BGM_OFFSITE_SHIPMENT                    1
 37
 38   CHAR(1)                                                      1                                                                                                                                                                                                                                                       Waste Activity               1
 39   NUMBER(5)                                                                       5                                                                                                                                                                                                                                    Waste Activity
                                                                                                                                                                                                                                                                                                                BGM_ONSITE_TREATMENT                    0
 40   NUMBER(5)                                                                       5                                                                               Alphanumeric                                                                                                                                         Waste Activity
                                                                                                                                                                                                                                                                                                                BGM_ONSITE_TREATMENT                    1
 41   CHAR(4)                                                      4                                                 MethodologyTypeText
                                                                                                                                   Permitting Information             (30)                                                                                                                                                 Waste Activity
                                                                                                                                                                                                                                                                                                                LU_MANAGEMENT_METHOD                    1
 42   NUMBER(18,7)                                                               18                  7                                                                                                                                                                                                                     Waste Activity
                                                                                                                                                                                                                                                                                                                BG6_FORM_GM_ONSITE_TREATMENT            1
 43
 44   CHAR(1)                                                      1                                                                                                                                                                                                                                                        Waste Activity              1
 45   NUMBER(5)                                                                       5                                                                                                                                                                                                                                     Waste Activity
                                                                                                                                                                                                                                                                                                                BR1_BASIC_FORM_WR_INFO                  0
 46   NUMBER(5)                                                                       5                                                                                                                                                                                                                         BWR_BASIC Waste Activity                0
 47   CHAR(4)                                                      4                                                                                                                                                                                                                                            BWR_BASIC Waste Activity                1
 48   CHAR(2)                                                      2                                                 ResultValueUn     2.1.2                          A(10)                                                                                                                                     BGM_BASIC Waste Activity                1
 49   NUMBER(5,2)                                                                     5              2               FacilityFeature   Permitting Information         Alphanumeric                     Substance    S                           S.01
                                                                                                                                                                                                                                 Substance Identification                      S.04
                                                                                                                                                                                                                                                                 Substance Property        Density              BGM_BASIC Waste Activity                1
 50   CHAR(1)                                                                                                        ResultValueUn     2.1.2                          A(10)                                                                                                                                                 Waste Activity
                                                                                                                                                                                                                                                                                                                LU_DENSITY_UNIT_OF_MEASURE              1
                                                                                                                     MethodologyTy                                    Alphanumeric
 51   CHAR(4)                                                      4                                                 peText            Permitting Information         (30)                                                                                                                                      BGM_BASIC Waste Activity                1
 52   VARCHAR2(12)                   1            12                                                                                                                                                                                                                                                                       Waste Activity
                                                                                                                                                                                                                                                                                                                BG5_FORM_GM_OFFSITE_SHIPMENTS           1
 53   VARCHAR2(18)                   1            18                                                                                                                                                                                                                                                            BWR_BASIC Waste Activity                1
 54   VARCHAR2(240)                  1           240                                                                                                                                                                                                                                                                       Waste Activity               0
 55   VARCHAR2(240)                  1           240                                                                                                                                                                                                                                                            BWR_BASIC Waste Activity                0
 56   VARCHAR2(6)                    1             6                                                                                                                                                                                                                                                                                                    1
 57   VARCHAR2(6)                    1             6                                                                                                                                                                                                                                                                                                    1
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76




                                                                                                                                                                                                     8 of 15                                                                                                                                                     2/25/2012
1cdd2d9a-70d6-4b80-80ae-391d0f0e0328.xls             flow_WA




          BL




  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50

 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76




                                           9 of 15   2/25/2012
1cdd2d9a-70d6-4b80-80ae-391d0f0e0328.xls                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                flow_Shared




         A           B           C              D             E                            F                            G             H              I            J             K             L            M             N             O       P            Q           R              S          T         U        V             W              X           Y             Z           AA              AB            AC         AD            AE            AF               AG         AH              AI       AJ         AK              AL
                                                                                                                                                                                Property                                                                            Associate                                                                                                                                                                               EDSC                                                                   CRM
                  Original                  Original                                                              Dictionary                  Object       Object   Property     Term                             Represent                                         dObjectCl      Associate                                                                                                                                                 EDSC         Dictionary                               CRM Major CRM Major CRM         Compou n d
                   Data       Original       Source                                                                  Entry     ABIE/ASBI       Class        Class     Term     Possessiv              PropertyTe ation Term     Represent Data Type                 assQualifi     dObjectCl BusinessT                                                                                 Total         Fraction       Owning   EDSC XML      Standard         Entry       EDSC            EDR        Data      Data      Compou n d Data B lock
  1      ID       Source     Source ID     Data Name Definition                     XML Tag Name                    Name         E/BBIE      Qualifier       Term   Qualifier      e                      rm       Qualifier    ation Term Qualifier   Data Type       er           assTerm    erm(s)  MinOccurs MaxOccurs       Format       MinLength   MaxLength       Length       Digits         Digits        Agency   Tag Name       Group           Name        Format        Identifier   Grou p    Grou p ID Data B lock ID
  2                                                     Hazardous waste codes describing the handler's hazardous waste streams. Code. Details
                                                                      HazardousWasteCodeDataType
                                           Handler Waste Code Information                                         Hazardous_ Waste
                                                                                                                               ABIE         Hazardous WasteCode                                       Details                   Details                WasteCode
  3                                                     Transaction code used to define the add, update, or delete.
                                           Transaction Code           TransactionCode                                          Transaction
                                                                                                                  Waste Code. BBIE                      WasteCode                                     Transaction               Code                   TransactionCodeDataType                                  0        1 CHAR(1)                                                 1
  4                                  301   Owner                      WasteCodeOwnerName
                                                        Indicates the agency that owns the data record.           Handler_ Waste Code. _ Owner. Name WasteCode WasteCode
                                                                                                                               BBIE                                                                   Owner                     Name                   WasteCodeOwnerNameDataType                               1        1 CHAR(2)                                                 2
  5                                  300                Code used describe hazardous waste.
                                           Hazardous Waste Code to WasteCode                                      Waste Code. BBIE                      WasteCode                                     WasteCode                 Code                   WasteCodeDataType                                        1        1 VARCHAR2(6)                1               6
  6                                                     Hazardous waste codes describing the handler's hazardous waste streams.
                                                                      HandlerWasteCodeDataType
                                           Handler Waste Code Information                                         Handler_ Waste Code. Details
                                                                                                                               ABIE         Handler     WasteCode                                     Details                   Details                NA
  7                                                     Transaction code used to define the add, update, or delete.
                                           Transaction Code           TransactionCode                                          BBIE
                                                                                                                  Handler_ Waste Code. Transaction      WasteCode                                     Transaction               Code                   TransactionCodeDataType                                  0        1   CHAR(1)                                               1
  8                                  301   Owner                      WasteCodeOwnerName
                                                        Indicates the agency that owns the data record.                        BBIE
                                                                                                                  Handler_ Waste Code. _ Owner. Name WasteCode WasteCode                              Owner                     Name                   WasteCodeOwnerNameDataType                               1        1   CHAR(2)                                               2
  9                                  300                Code used describe hazardous waste.
                                           Hazardous Waste Code to WasteCode                                                   BBIE
                                                                                                                  Handler_ Waste Code.                  WasteCode                                     WasteCode                 Code                   WasteCodeDataType                                        1        1   VARCHAR2(6)              1               6
 10                                  232                The quantity of waste that is handled by each process code. This element pertainsEstimated_ Quantity
                                           Estimated Quantity         EstimatedQuantity                                        BBIE                     WasteCode
                                                                                                                  Handler_ Waste Code. only to Part A submissions. Estimated                          Quantity                  Quantity               EstimatedQuantityDataType                                0        1   NUMBER(15,5)                                                       15              5
 11                                  631                Code indicating the unit of measure of the associated design capacity. BBIE
                                           Unit of Measure Type       MeasurementTypeCode                         Measurement. _ Type. Code             MeasurementMeasurement                        Type                      Code                   MeasurementTypeCodeDataType                              0        1   CHAR(1)                                               1
 12                                                                   WasteGeneratorDataType
                                                        State and federal generator status codes and descriptions.             ABIE
                                                                                                                  Waste Generator. Details              WasteGenerator                                Details                                          NA
 13                                                     Transaction code used to define the add, update, or delete.
                                           Transaction Code           TransactionCode                                          BBIE
                                                                                                                  Waste Generator. Transaction. Code WasteGenerator                                   Transaction               Code                   TransactionCodeDataType                                  0        1 CHAR(1)                                                 1

14                                   292 Owner                          WasteGeneratorOwnerName
                                                        Indicates the agency that defines the generator status type.                 BBIE
                                                                                                                      Waste Generator. _ Owner. Name             WasteGeneratorWasteGenerator           Owner                   Name                   WasteGeneratorOwnerNameDataType                          0        1 CHAR(2)                                                 2
15                                                      Code indicating that
                                                                        WasteGeneratorStatusCode                      Waste Generator. _ Status. Code
                                     293 Waste Generator Status Code the handler is engaged in the generation of hazardous waste.    BBIE                        WasteGeneratorWasteGenerator           Status                  Code                   WasteGeneratorStatusCodeDataType                         0        1 VARCHAR2(6)                1               6
16                                                                      NAICSDataType
                                                        NAICS Codes reported for the handler.                         NAICS. Details ABIE                        NAICS                                  Details                                        NA
17                                                      Transaction code used to define the add, update, or delete.
                                         Transaction Code               TransactionCode                                              BBIE
                                                                                                                      NAICS. Transaction. Code                   NAICS                                  Transaction             Code                   TransactionCodeDataType                                  0        1   CHAR(1)                                               1
18                                                      Sequence number for each NAICS code
                                     119 NAICS Sequence Number NAICSSequenceNumber for the handler. NAICS. _ Sequence. Number        BBIE                        NAICS         NAICS                    Sequence                Number                 NAICSSequenceNumberDataType                              1        1   NUMBER(4)                                                           4
19                                   310 Owner                          NAICSOwnerCode
                                                        Indicates the agency that defines the NAICS Code.                            BBIE
                                                                                                                      NAICS. _ Owner. Code                       NAICS         NAICS                    Owner                   Code                   NAICSOwnerCodeDataType                                   0        1   CHAR(2)                                               2
20                                                      The North Classification System (NAICS) System
                                                                        NAICSCode
                                     311 North American IndustryAmerican Industry ClassificationCode Code that identifies BBIE
                                                                                                                      NAICS. _ Code business activities of the facility.
                                                                                                                                     the                         NAICS         NAICS                    Code                    Code                   NAICSCodeDataType                                        0        1   VARCHAR2(6)              1              6                                                       NAICSCode              6.1                N(6)                        Facility   F                     F.03
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Envrionmental Interest
21                                   124 Notes                          SupplementalInformation
                                                        Additional information about the NAICS Code.                                 BBIE
                                                                                                                      NAICS. Supplemental_ Information           NAICS         Supplemental             Information             Text                   SupplementalInformationDataType                          0        1   VARCHAR2(2000)           1           2000
22                                                      Used oil codes. UsedOilDataType                                              ABIE
                                                                                                                      Used Oil. Details                          UsedOil                                Details                                        NA
23                                                      Transaction code used to define the add, update, or delete.
                                         Transaction Code               TransactionCode                                              BBIE
                                                                                                                      Used Oil. Transaction. Code                UsedOil                                Transaction             Code                   TransactionCodeDataType                                  0        1   CHAR(1)                                               1
24                                                       Burner         FuelBurnerCode                                Used Oil. fuel.BBIE
                                      81 Used Oil FuelCode indicating that the handler is engaged in the burning of used oilFuel Burner. Code                    UsedOil                                FuelBurner              Code                   FuelBurnerCodeDataType                                   0        1   CHAR(1)                                               1
25                                                      Code            ProcessorCode                                 Used Oil. Processor. Code
                                      82 Used Oil Processorindicating that the handler is engaged in processing used oil activities. BBIE                        UsedOil                                Processor               Code                   ProcessorCodeDataType                                    0        1   CHAR(1)                                               1
26                                                      Code            RefinerCode                                   Used Oil. Refiner.
                                                                                                                                     BBIE
                                      83 Used Oil Refiner indicating that the handler is engaged in re-refining used oil activities. Code                        UsedOil                                Refiner                 Code                   RefinerCodeDataType                                      0        1   CHAR(1)                                               1
27                                                       Marketer to Burner
                                                                        MarketBurnerCode                              oil to Oil. Market
                                                                                                                                     BBIE
                                      84 Used Oil FuelCode indicating that the handler directs shipments of usedUsed burners. Burner. Code                       UsedOil                                MarketBurner            Code                   MarketBurnerCodeDataType                                 0        1   CHAR(1)                                               1
28                                                      Code indicating that
                                                                        SpecificationMarketerCode                     Used Oil. Specification Marketer. Code
                                                                                                                                     BBIE
                                      85 Specification Used Oil Marketer the handler is a marketer who first claims the used oil meets the specifications.UsedOil                                       SpecificationMarketer   Code                   SpecificationMarketerCodeDataType                        0        1   CHAR(1)                                               1
29                                                      Code indicating that the handler owns                         Used Oil. Transfer
                                                                                                                                     BBIE
                                      86 Used Oil Transfer Facility TransferFacilityCode or operates a used oil transfer facility. Facility. Code                UsedOil                                TransferFacility        Code                   TransferFacilityCodeDataType                             0        1   CHAR(1)                                               1
30                                                      Code indicating that the handler is engaged in used oil transportation and/or transfer facility activities.
                                      87 Used Oil Transporter           TransporterCode                                              BBIE
                                                                                                                      Used Oil. Transporter. Code                UsedOil                                Transporter             Code                   TransporterCodeDataType                                  0        1   CHAR(1)                                               1
31                                                                      CertificationDataType
                                                        Waste information certification for the handler.                             ABIE
                                                                                                                      Certification. Details                     Certification                          Details                                        NA
32                                                      Transaction code used to define the add, update, or delete.
                                         Transaction Code               TransactionCode                                              BBIE
                                                                                                                      Certification. Transaction. Code           Certification                          Transaction             Code                   TransactionCodeDataType                                  0        1   CHAR(1)                  1               1
33                                                      Sequence number CertificationSequenceNumber                                  BBIE
                                     106 Certification Sequence Number for each certification for the handler. Certification. _ Sequence. Number                 Certification Certification            Sequence                Number                 CertificationSequenceNumberDataType                      1        1   NUMBER(8)                                                           8
34                                                      Date on which the handler                                     reporting site.BBIE
                                     107 Certification Signed Date SignedDate information was certified by the Certification. Signed. Date                       Certification                          Signed                  Date                   SignedDateDataType                                       0        1   DATE
35                                                      Title           Title                                         Certification. Title
                                                                                                                                     BBIE
                                     108 Certification Title of the person who certified the handler information reported to the authorizing agency.             Certification                          Title                   Text                   TitleDataType                                            0        1   VARCHAR2(45)             1             45
36                                                      First name the person
                                     109 Certification First Name of FirstName who certified the handler information reported to the authorizing agency. Certification First
                                                                                                                      Certification. First_ Name
                                                                                                                                     BBIE                                                               Name                    Name                   FirstNameDataType                                        0        1   VARCHAR2(15)             1             15                                                       FirstName 1.1.5                           A(30)                       TBC                                 TBC.08\ C.01
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Certification\ Contact Identification
37                                                      Middle initial MiddleInitial                                  Certification. Middle_ Initial
                                                                                                                                     BBIE
                                     110 Certification Middle Initial of the person who certified the handler information reported to the authorizing agency. Certification Middle                      Initial                 Text                   MiddleInitialDataType                                    0        1   CHAR(1)                                               1                                         MiddleName 1.1.6                          A(10)                       TBC                                 TBC.08\ C.01
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Certification\ Contact Identification
38                                                      Last name the person
                                     111 Certification Last Name of LastName who certified the handler information reported to the authorizing agency. Certification Last
                                                                                                                      Certification. Last_ Name
                                                                                                                                     BBIE                                                               Name                    Name                   LastNameDataType                                         0        1   VARCHAR2(15)             1             15                                                       LastName 1.1.7                            A(30)                       TBC                                 TBC.08\ C.01
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Certification\ Contact Identification
39                                   114 Notes                          SupplementalInformation
                                                        Additional information about the certification.                              BBIE
                                                                                                                      Certification. Supplemental_ Information Certification Supplemental               Information             Text                   SupplementalInformationDataType                          0        1   VARCHAR2(240)            1            240
40                                                                      StateActivityDataType
                                                        State waste activity of the handler.                                          Details
                                                                                                                      State Activity.ABIE                        StateActivity                          Details                                        NA
41                                                      Transaction code used to define the add, update, or delete.
                                         Transaction Code               TransactionCode                                               Transaction. Code
                                                                                                                      State Activity.BBIE                        StateActivity                          Transaction             Code                   TransactionCodeDataType                                  0        1   CHAR(1)                                               1
42                                   334 Owner                          StateActivityOwnerName
                                                        Indicates the agency that defines the state activity type. State Activity.BBIE_ Owner. Name              StateActivity StateActivity            Owner                   Name                   StateActivityOwnerNameDataType                           1        1   CHAR(2)                                               2
43                                                      Code            StateActivityTypeCode
                                     335 State Activity Type indicating the type of state activity.                                   _ Type. Code
                                                                                                                      State Activity.BBIE                        StateActivity StateActivity            Type                    Code                   StateActivityTypeCodeDataType                            1        1   VARCHAR2(5)              1              5
44                                   166 Notes                          SupplementalInformation
                                                        Additional information about the state activity.                              Supplemental_ InformationStateActivity Supplemental
                                                                                                                      State Activity.BBIE                                                               Information             Text                   SupplementalInformationDataType                          0        1   VARCHAR2(2000)           1           2000
45                                                                      FacilityOwnerOperatorDataType
                                                        Owner/operator information about the handler.                 Facility_ Owner Operator. Details
                                                                                                                                     ABIE            Facility    OwnerOperator                          Details                                        NA
46                                                      Transaction code used to define the add, update, or delete.
                                         Transaction Code               TransactionCode                                              BBIE            Facility
                                                                                                                      Facility_ Owner Operator. Transaction. CodeOwnerOperator                          Transaction             Code                   TransactionCodeDataType                                  0        1   CHAR(1)                                               1
47                                                      Sequential number used to order multiple occurrences of owners and operators.
                                                                         Number
                                     129 Owner/Operator Sequence OwnerOperatorSequenceNumber                                         BBIE             Sequence. Number
                                                                                                                      Facility_ Owner Operator. _Facility        OwnerOperator OwnerOperator            Sequence                Number                 OwnerOperatorSequenceNumberDataType                      1        1   NUMBER(4)                                                           4
48                                                      Code indicating whether the data is associated with a current or previous owner or operator. The system will allow multiple current owners and operators. Indicator
                                     130 Owner/Operator Indicator OwnerOperatorIndicator                                             BBIE             Indicator
                                                                                                                      Facility_ Owner Operator. _Facility        OwnerOperator OwnerOperator            Indicator               Indicator              OwnerOperatorIndicatorDataType                           0        1   CHAR(2)
49                                                      Code indicating the owner/operator type.
                                     132 Owner/Operator Type            OwnerOperatorTypeCode                                        BBIE             Type.
                                                                                                                      Facility_ Owner Operator. _Facility Code OwnerOperator   OwnerOperator            Type                    Code                   OwnerOperatorTypeCodeDataType                            0        1   CHAR(1)                                               1
50                                                       Current        CurrentStartDate                                             BBIE            Facility    Date
                                     133 Date BecameDate indicating when the owner/operator became current. Facility_ Owner Operator. Current_ Start OwnerOperator             Current                  StartDate               Date                   CurrentStartDateDataType                                 0        1   DATE                                                                                            PermitEffectiveDate 3.4                   Date (YYYMMDD)
51                                                      Date indicating when the owner/operator changed to a different owner/operator.
                                     134 Date Ended Current             CurrentEndDate                                               BBIE            Facility
                                                                                                                      Facility_ Owner Operator. Current_ End DateOwnerOperator Current                  EndDate                 Date                   CurrentEndDateDataType                                   0        1   DATE                                                                                            PermitExpirationDate 3.5                  Date (YYYMMDD)
52                                                      Dunn and Bradstreet number used as an identifier
                                         Dunn and Bradstreet Number     DUNSID                                                       BBIE            Facility
                                                                                                                      Facility_ Owner Operator. DUNS_ Identifier OwnerOperator DUNS                     Identifier              Identifier             DUNSIDDataType                                           0        1   VARCHAR2(10)             1             10
53                                   146 Notes                          SupplementalInformation
                                                        Additional information about the owner/operator.                             BBIE            Facility     Information Supplemental
                                                                                                                      Facility_ Owner Operator. Supplemental_OwnerOperator                              Information             Text                   SupplementalInformationDataType                          0        1   VARCHAR2(240)            1            240
54                                                      Contact address information for the facility owner/operator.
                                                                        AddressContact                                Federal_       ASBIE
                                                                                                                      Facility_ Owner Operator. Address. Contact Address
                                                                                                                                                     Facility    OwnerOperator                          Address                                        ContactAddressDataType ContactAddress                    0        1
55                                                                      FederalUniversalWasteActivityDataType Universal              ABIE            Federal     UniversalWasteActivity                 Details                                        NA                         UniversalWasteActivity
56                                       GEN_BATT Transaction code used to define the add, update, or delete.
                                         Transaction Code               TransactionCode                                              BBIE
                                                                                                                      Universal Waste Activity. Transaction. CodeUniversalWasteActivity                 Transaction             Code                   TransactionCodeDataType                                  0        1   CHAR(1)                                               1
57                                       ERIES                          GeneratorBatteriesIndicator
                                         ACC_BATT Large Quantity Generator of Batteries(Yes = 'Y', No = 'N') UniversalW aste         BBIE                                      Generator
                                                                                                                                                                               Accumulato
                                                                                                                                                                 UniversalWasteActivity                 Batteries               Indicator              GeneratorBatteriesIndicatorDataType                      0        1   CHAR(1)
58                                       GEN_PEST Large Quantity Accumulator of Batteries(Yes = 'Y', No = 'N') aste
                                         ERIES                          AccumulatorBatteriesIndicator                 W
                                                                                                                      Universal      BBIE                                      r
                                                                                                                                                                 UniversalWasteActivity                 Batteries               Indicator              AccumulatorBatteriesIndicatorDataType                    0        1   CHAR(1)
59                                       ACC_PEST Large Quantity Generator of Pesticides(Yes = 'Y', No = 'N') aste
                                         ICIDES                         GeneratorPesticidesIndicator                  W
                                                                                                                      Universal      BBIE                                      Generator
                                                                                                                                                                               Accumulato
                                                                                                                                                                 UniversalWasteActivity                 Pesticides              Indicator              GeneratorPesticidesIndicatorDataType                     0        1   CHAR(1)
60                                       ICIDES                         AccumulatorPesticidesIndicator
                                         GEN_THE Large Quantity Accumulator of Pesticides(Yes = 'Y', No = 'N')        W aste
                                                                                                                      Universal      BBIE                                      r
                                                                                                                                                                 UniversalWasteActivity                 Pesticides              Indicator              AccumulatorPesticidesIndicatorDataType                   0        1   CHAR(1)
61                                       ACC_THE                        GeneratorThermostatsIndicator
                                         RMOSTAT Large Quantity Generator of Thermostats(Yes = 'Y', No = 'N')         W aste
                                                                                                                      Universal      BBIE                                      Generator
                                                                                                                                                                               Accumulato
                                                                                                                                                                 UniversalWasteActivity                 Thermostats             Indicator              GeneratorThermostatsIndicatorDataType                    0        1   CHAR(1)
62                                       GEN_LAM                        AccumulatorThermostatsIndicator
                                         RMOSTAT Large Quantity Accumulator of Thermostats(Yes = 'Y', No = 'N')       W aste
                                                                                                                      Universal      BBIE                                      r
                                                                                                                                                                 UniversalWasteActivity                 Thermostats             Indicator              AccumulatorThermostatsIndicatorDataType                  0        1   CHAR(1)
63                                       PS                             GeneratorLampsIndicator
                                         ACC_LAM Large Quantity Generator of Lamps(Yes = 'Y', No = 'N') Universal     W aste         BBIE                                      Generator
                                                                                                                                                                               Accumulato
                                                                                                                                                                 UniversalWasteActivity                 Lamps                   Indicator              GeneratorLampsIndicatorDataType                          0        1   CHAR(1)
64                                       PS                             AccumulatorLampsIndicator
                                                        Large Quantity Accumulator of Lamps(Yes = 'Y', No = 'N') W aste              BBIE                                      r
                                                                                                                                                                 UniversalWasteActivity                 Lamps                   Indicator              AccumulatorLampsIndicatorDataType                        0        1   CHAR(1)
65                                                                      StateUniversalWasteActivityDataType
                                                        Information about universal waste generated by the handler.   State_ Universal Waste Activity. Details UniversalWasteActivity
                                                                                                                                     ABIE            State                                              Details                                        NA                         UniversalWasteActivity
66                                                      Transaction code used to define the add, update, or delete.
                                         Transaction Code               TransactionCode                                              BBIE
                                                                                                                      Universal Waste Activity. Transaction. CodeUniversalWasteActivity                 Transaction             Code                   TransactionCodeDataType                                  0        1   CHAR(1)                                               1
67                                   342 Owner                          UniversalWasteOwnerName                                      BBIE
                                                        Indicates the agency that defines the universal waste type.Universal Waste Activity. _ Owner. Name                     UniversalWaste
                                                                                                                                                                 UniversalWasteActivity                 Owner                   Name                   UniversalWasteOwnerNameDataType                          1        1   CHAR(2)                                               2
68                                                      Code indicating the type of universal waste.
                                     343 Universal Waste Type           UniversalWasteTypeCode                                       BBIE                                      UniversalWaste
                                                                                                                      Universal Waste Activity. _ Type. Code UniversalWasteActivity                     Type                    Code                   UniversalWasteTypeCodeDataType                           1        1   CHAR(1)                                               1
69                                                                      AccumulatedWasteCode                          Universal WasteBBIE                         Code
                                     173 Accumulated Code indicating that the handler is engaged in accumulating waste on site. Activity. Accumulated_ .UniversalWasteActivity Accumulated              Waste                   Code                   AccumulatedWasteCodeDataType                             0        1   CHAR(1)                                               1
70                                                                      GeneratedHandlerCode                          Universal Waste Activity. Generated_ Handler. Code Generated
                                     174 Generated Code indicating that the handler is engaged in generating waste on site. BBIE                                 UniversalWasteActivity                 Handler                 Code                   GeneratedHandlerCodeDataType                             0        1   CHAR(1)                                               1
71                                   177 Notes                          SupplementalInformation
                                                        Additional information about the universal waste.                            BBIE                        Information Supplemental
                                                                                                                      Universal Waste Activity. Supplemental_ UniversalWasteActivity                    Information             Text                   SupplementalInformationDataType                          0        1   VARCHAR2(240)            1            240
72                                                                      UniversalWasteActivityDataType                W aste         ABIE                        UniversalWasteActivity                 Details                                        NA
73                                                      Transaction code used to define the add, update, or delete.
                                         Transaction Code               TransactionCode                                              BBIE
                                                                                                                      Universal Waste Activity. Transaction. CodeUniversalWasteActivity                 Transaction             Code                   TransactionCodeDataType                                  0        1   CHAR(1)                                               1
74                                   342 Owner                          UniversalWasteOwnerName                                      BBIE
                                                        Indicates the agency that defines the universal waste type.Universal Waste Activity. _ Owner. Name                     UniversalWaste
                                                                                                                                                                 UniversalWasteActivity                 Owner                   Name                   UniversalWasteOwnerNameDataType                          0        1   CHAR(2)                                               2
75                                                      Code indicating the type of universal waste.
                                     343 Universal Waste Type           UniversalWasteTypeCode                                       BBIE                                      UniversalWaste
                                                                                                                      Universal Waste Activity. _ Type. Code UniversalWasteActivity                     Type                    Code                   UniversalWasteTypeCodeDataType                           0        1   CHAR(1)                                               1
76                                                                      AccumulatedWasteCode                          Universal WasteBBIE                         Code
                                     173 Accumulated Code indicating that the handler is engaged in accumulating waste on site. Activity. Accumulated_ .UniversalWasteActivity Accumulated              Waste                   Code                   AccumulatedWasteCodeDataType                             0        1   CHAR(1)                                               1
77                                                                      GeneratedHandlerCode                          Universal Waste Activity. Generated_ Handler. Code Generated
                                     174 Generated Code indicating that the handler is engaged in generating waste on site. BBIE                                 UniversalWasteActivity                 Handler                 Code                   GeneratedHandlerCodeDataType                             0        1   CHAR(1)                                               1
78                                       GEN_BATT Additional information about the universal waste.
                                     177 Notes                          SupplementalInformation                                      BBIE                        Information Supplemental
                                                                                                                      Universal Waste Activity. Supplemental_ UniversalWasteActivity                    Information             Text                   SupplementalInformationDataType                          0        1   VARCHAR2(240)            1            240
79                                       ERIES                          GeneratorBatteriesIndicator
                                         ACC_BATT Large Quantity Generator of Batteries(Yes = 'Y', No = 'N') UniversalW aste         BBIE                                      Generator
                                                                                                                                                                               Accumulato
                                                                                                                                                                 UniversalWasteActivity                 Batteries               Indicator              GeneratorBatteriesIndicatorDataType                      0        1   CHAR(1)
80                                                                      AccumulatorBatteriesIndicator
                                         GEN_PEST Large Quantity Accumulator of Batteries(Yes = 'Y', No = 'N') aste
                                         ERIES                                                                        W
                                                                                                                      Universal      BBIE                                      r
                                                                                                                                                                 UniversalWasteActivity                 Batteries               Indicator              AccumulatorBatteriesIndicatorDataType                    0        1   CHAR(1)
81                                       ACC_PEST Large Quantity Generator of Pesticides(Yes = 'Y', No = 'N') aste
                                         ICIDES                         GeneratorPesticidesIndicator                  W
                                                                                                                      Universal      BBIE                                      Generator
                                                                                                                                                                               Accumulato
                                                                                                                                                                 UniversalWasteActivity                 Pesticides              Indicator              GeneratorPesticidesIndicatorDataType                     0        1   CHAR(1)
82                                       ICIDES                         AccumulatorPesticidesIndicator
                                         GEN_THE Large Quantity Accumulator of Pesticides(Yes = 'Y', No = 'N')        W aste
                                                                                                                      Universal      BBIE                                      r
                                                                                                                                                                 UniversalWasteActivity                 Pesticides              Indicator              AccumulatorPesticidesIndicatorDataType                   0        1   CHAR(1)
83                                       ACC_THE                        GeneratorThermostatsIndicator
                                         RMOSTAT Large Quantity Generator of Thermostats(Yes = 'Y', No = 'N')         W aste
                                                                                                                      Universal      BBIE                                      Generator
                                                                                                                                                                               Accumulato
                                                                                                                                                                 UniversalWasteActivity                 Thermostats             Indicator              GeneratorThermostatsIndicatorDataType                    0        1   CHAR(1)
84                                       GEN_LAM                        AccumulatorThermostatsIndicator
                                         RMOSTAT Large Quantity Accumulator of Thermostats(Yes = 'Y', No = 'N')       W aste
                                                                                                                      Universal      BBIE                                      r
                                                                                                                                                                 UniversalWasteActivity                 Thermostats             Indicator              AccumulatorThermostatsIndicatorDataType                  0        1   CHAR(1)
85                                       PS                             GeneratorLampsIndicator
                                         ACC_LAM Large Quantity Generator of Lamps(Yes = 'Y', No = 'N') Universal     W aste         BBIE                                      Generator
                                                                                                                                                                               Accumulato
                                                                                                                                                                 UniversalWasteActivity                 Lamps                   Indicator              GeneratorLampsIndicatorDataType                          0        1   CHAR(1)
86                                       PS                             AccumulatorLampsIndicator
                                                        Large Quantity Accumulator of Lamps(Yes = 'Y', No = 'N') W aste              BBIE                                      r
                                                                                                                                                                 UniversalWasteActivity                 Lamps                   Indicator              AccumulatorLampsIndicatorDataType                        0        1   CHAR(1)
87                                                                      SiteWasteActivityDataType
                                                        Site waste activity codes.                                    Site_ Waste Activity. Details
                                                                                                                                     ABIE            Site        WasteActivity                          Details                                        NA
88                                                      Transaction code used to define the add, update, or delete.
                                         Transaction Code               TransactionCode                                              BBIE            Site
                                                                                                                      Site_ Waste Activity. Transaction. Code WasteActivity                             Transaction             Code                   TransactionCodeDataType                                  0        1   CHAR(1)                                               1
89                                                                      FacilitySiteName
                                      15 Site Name The legal name of the site.                                                       BBIE
                                                                                                                      Site_ Waste Activity. Facility_ . Name WasteActivityFacility
                                                                                                                                                     Site                                               Site                    Name                   FacilitySiteNameDataType                                 0        1   VARCHAR2(40)             1             40                                                                     1.1.2
                                                                                                                                                                                                                                                                                                                                                                                                                             FacilitySiteName                          Alphanumeric                Facility   F                         F.01
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Facility Identification
90                                                                      LandTypeCode                                  Site_ Waste Activity.
                                                                                                                                      is located.     Type.
                                      26 Land Type Code indicating current ownership status of the land on which the facilityBBIE Land_Site Code WasteActivityLand                                      Type                    Code                   LandTypeCodeDataType                                     0        1   CHAR(1)                                               1
91                                                                      StateDistrictCode                             Site_ Waste Activity. State District. CodeWasteActivity
                                                                                                                                     BBIE
                                      27 State District Code indicating the state-designated legislative district(s) in which the site is located. Site                                                 StateDistrict           Code                   StateDistrictCodeDataType                                0        1   VARCHAR2(10)             1             10
92                                                      Code indicating that the handler is engaged in importing hazardous waste into the United States. WasteActivityImporter
                                      71 Importer Activity              ImporterActivityCode                                         BBIE            Site
                                                                                                                      Site_ Waste Activity. Importer_ . Code                                            Activity                Code                   ImporterActivityCodeDataType                             0        1   CHAR(1)                                               1
93                                                      Generator MixedWasteGeneratorCode                             Site_ waste Activity. Mixed_ Generator. WasteActivityMixedWaste
                                                                                                                                     BBIE            Site        Code
                                      72 Mixed Waste Code indicating that the handler is engaged in generating mixed Waste(waste that is both hazardous and radioactive).                               Generator               Code                   MixedWasteGeneratorCodeDataType                          0        1   CHAR(1)                                               1
94                                                      Code            RecyclerActivityCode                          Site_ Waste Activity. Recycler_ . Code WasteActivityRecycler
                                      73 Recycler Activity indicating that the handler is engaged in recycling hazardous waste.      BBIE            Site                                               Activity                Code                   RecyclerActivityCodeDataType                             0        1   CHAR(1)                                               1
95                                                      Code            TransporterActivityCode                       Site_ of hazardous waste. Site
                                                                                                                                     BBIE
                                      74 Transporter Activityindicating that the handler is engaged in the transportationWaste Activity. Transporter_ . Code     WasteActivityTransporter               Activity                Code                   TransporterActivityCodeDataType                          0        1   VARCHAR2(1)              1               1
96                                                                      TreatmentStorageDisposalActivityCode          Site_ Waste BBIEdisposal of hazardous waste.
                                                                                                                                                     Site
                                      75 TSD Activity Code indicating that the handler is engaged in the treatment, storage, orActivity. Treatment Storage WasteActivityTreatmentStorageDisposalActivity
                                                                                                                                                                 Disposal_ . Code                                               Code                   TreatmentStorageDisposalActivityCodeDataType             0        1   CHAR(1)                                               1
97                                                      Injection Activity
                                                                        UndergroundInjectionActivityCode              Site_ or disposes of hazardous waste and has an injection well located at the installation.
                                                                                                                                     BBIE            Site
                                      76 Underground Code indicating that the handler generates and or treats, stores,Waste Activity. Underground Injection_ . Code
                                                                                                                                                                 WasteActivityUndergroundInjection      Activity                Code                   UndergroundInjectionActivityCodeDataType                 0        1   CHAR(1)                                               1
98                                                      Code indicating that the
                                                                        UniversalWasteDestinationFacilityIndicator Site_ hazardous waste on site.
                                                                                                                                     BBIE            Site
                                      77 Universal Waste Destination Facility handler treats, disposes of, or recycles Waste Activity. Universal_ Destination Facility. Indicator
                                                                                                                                                                 WasteActivityUniversalWaste            DestinationFacility     Indicator              UniversalWasteDestinationFacilityIndicatorDataType       0        1   CHAR(1)
99                                                      Code            TransferFacilityIndicator                     Site_ Waste BBIE
                                      78 Transfer Facility indicating that the handler owns or operates a transfer facility. Activity. Transfer Facility. Indicator
                                                                                                                                                     Site        WasteActivity                          TransferFacility        Indicator              TransferFacilityIndicatorDataType                        0        1   CHAR(1)                                                                                                              7.1
                                                                                                                                                                                                                                                                                                                                                                                                                             FacilityOwnershipTypeName                 A(15)                       Release    R                    R.08
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Waste Management Disposal
100                                                      Exemption OnsiteBurnerExemptionCode                          Site_ Waste Activity. Onsite Burner_ Exemption. Code
                                                                                                                                     BBIE
                                      79 Onsite BurnerCode indicating that the handler qualifies for the Small Quantity Onsite Burner Exemption.     Site        WasteActivityOnsiteBurner              Exemption               Code                   OnsiteBurnerExemptionCodeDataType                        0        1   CHAR(1)                                               1
101                                                     Code            FurnaceExemptionCode                          Site_ Waste Activity. Furnace Exemption.
                                                                                                                                     BBIE            Site
                                      80 Furnace Exemption indicating that the handler qualifies for the Smelting, Melting, and Refining Furnace_ Exemption. CodeWasteActivityFurnace                   Exemption               Code                   FurnaceExemptionCodeDataType                             0        1   CHAR(1)                                               1
102                                                                     RCRAGeographicCoordinateDataType              coordinates datatype.
                                                                                                                                     ABIE            RCRA
                                                        Structural restriction customization of the FRS geographicRCRA_ Geographic Coordinate. Details GeographicCoordinate                                                                            GeographicCoordinate
103                                                     Transaction code used to define the add, update, or delete.
                                         Transaction Code               TransactionCode                                              BBIE
                                                                                                                      Geographic Coordinate. Transaction. Code   GeographicCoordinate                   Transaction             Code                   TransactionCodeDataType                                  0        1   CHAR(1)                                               1
104                                                                      of the angular distance on a meridian north or south of theBBIE
                                                        The measure LatitudeMeasure                                                   equator.
                                                                                                                      Geographic Coordinate. Latitude. Measure   GeographicCoordinate                   Latitude                Measure                LatitudeMeasureDataType                                  0        1   NUMBER (10,6)                                                      10              6
105                                                                      of the angular distance on a meridian east or west of the Coordinate. Longitude. Measure
                                                        The measure LongitudeMeasure                                                 BBIE
                                                                                                                      Geographic prime meridian.                 GeographicCoordinate                   Longitude               Measure                LongitudeMeasureDataType                                 0        1   NUMBER (11,6)                                                      11              6
106                                                                      of the accuracy (in meters) of               Geographic Coordinate.
                                                                                                                                     BBIE                        GeographicCoordinate
                                                        The measure HorizontalAccuracyMeasure the latitude and longitude coordinates. Horizontal_ Accuracy. Measure            Horizontal               Accuracy                Measure                HorizontalAccuracyMeasureDataType                        0        1   VARCHAR2(6)              1              6
107                                                                     HorizontalCollectionMethod                    Geographic Coordinate. Horizontal_ a point on the earth.
                                                                                                                                     BBIE                        GeographicCoordinate
                                                        The text that describes the method used to determine the latitude and longitude coordinates for Collection Method      Horizontal               CollectionMethod        Text                   HorizontalCollectionMethodDataType                       0        1   VARCHAR2(3)              1              3
108                                                                     HorizontalReferenceDatumName                  Geographic Coordinate. Horizontal_ Reference Datum. Name
                                                                                                                                     BBIE
                                                        The name that describes the reference datum used in determining latitude and longitude coordinates.                    Horizontal
                                                                                                                                                                 GeographicCoordinate                   ReferenceDatum          Name                   HorizontalReferenceDatumNameDataType                     0        1   VARCHAR2(3)              1              3
109                                                                     SourceMapScaleNumber                          Geographic Coordinate. Source Map Scale. Number
                                                                                                                                     BBIE                        map or photo.
                                                        The number that represents the proportional distance on the ground for one unit of measure on the GeographicCoordinate                          SourceMapScale          Number                 SourceMapScaleNumberDataType                             0        1   VARCHAR2(10)             1             10
110                                                                     ReferencePointText                            Geographic Coordinate. Reference Point
                                                        The text that identifies the place for which geographic coordinates were BBIEestablished.                GeographicCoordinate                   ReferencePoint          Text                   ReferencePointDataType                                   0        1   VARCHAR2(3)              1              3
111                                                                     GeometricTypeName                             Geographic or a sequence of latitude and Name
                                                                                                                                     BBIE                        GeographicCoordinate
                                                        The name that identifies the geometric entity represented by one point Coordinate. Geometric Type. longitude points.                            GeometricType           Name                   GeometricTypeNameDataType                                0        1   VARCHAR2(15)             1             15
112                                                                     RCRAPhoneEmailDataType                        RCRA_ Phone    ABIE
                                                        Structural restriction customization of the FRS PhoneFaxEmail datatype. Email. Details       RCRA        PhoneEmail                             Details                 Details                PhoneFaxEmail
113                                                                     EmailAddress
                                                        Email address associated with the permit contact.                            BBIE
                                                                                                                      Phone Fax Email. _ Address                 PhoneFaxEmail Email                    Address                 Text                   EmailAddressDataType                                     0        1 VARCHAR2(240)              1            240
114                                                                     TelephoneNumber
                                                        Telephone number associated with the permit contact.                         BBIE
                                                                                                                      Phone Fax Email. Telephone. Number PhoneFaxEmail                                  Telephone               Number                 TelephoneNumberDataType                                  0        1 VARCHAR2(15)               1             15
115                                                                     PhoneExtentionNumber                          Phone          BBIE
                                                        Telephone number extension associated with the permit contact. Fax Email. Extention. Number              PhoneFaxEmail                          PhoneExtention          Number                 PhoneExtentionNumberDataType                             0        1 VARCHAR2(6)                1             15
116                                                                     ContactDataType
                                                        Structural restriction customization of the Contact datatype.                ABIE
                                                                                                                      Contact. Details                           Contact                                Details                                        NA
117                                                     First name of the person                                      Contact. First_ Name
                                                                                                                                     BBIE
                                      48 Permit Contact First Name FirstName who is familiar with the handler's Hazardous Waste Permit information. Contact                    First                    Name                    Name                   FirstNameDataType                                        0        1 VARCHAR2(15)               1             15                                                       FirstName 1.1.5                           A(30)
118                                                     Middle initial of
                                                                        MiddleInitial                                 Contact. Middle_ Initial
                                                                                                                                     BBIE
                                      49 Permit Contact Middle Initial the person who is familiar with the handler's Hazardous Waste Permit information. Contact               Middle                   Initial                 Text                   MiddleInitialDataType                                    0        1 CHAR(1)                                                 1                                         MiddleName 1.1.6                          A(10)
119                                                     Last name of the person                                       Contact. Last_ Name
                                                                                                                                     BBIE
                                      50 Permit Contact Last Name LastName who is familiar with the handler's Hazardous Waste Permit information. Contact                      Last                     Name                    Name                   LastNameDataType                                         0        1 VARCHAR2(15)               1             15                                                       LastName 1.1.7                            A(30)
120                                                                     of an organization
                                                        Formal name OrganizationFormalName                                           BBIE
                                                                                                                      Contact. OrganizationFormal.Name           Contact       OrganizationFormal       Name                    Name                   OrganizationFormalNameDataType                           0        1 VARCHAR2(30)               1             30
121                                                                     RCRAPhoneEmail                                Contact. RCRA_ ASBIE
                                                        Structural restriction customization of the FRS PhoneFaxEmail datatype. Phone Email. Phone Email         Contact       RCRA                     PhoneEmail                                                   RCRA
                                                                                                                                                                                                                                                       RCRAPhoneEmailDataType     PhoneEmail                    0        1
122                                                                     ContactAddressDataType
                                                        Contact address information.                                                 ABIE
                                                                                                                      Contact Address. Details                   ContactAddress                         Details                                        NA
123                                                                     Contact
                                                        Contact information.                                                         ASBIE
                                                                                                                      Contact Address. Contact                   ContactAddress                         Contact                                        ContactDataType            Contact                       0        1
124                                                                     MailingAddress
                                                        Mailing address information.                                                 ASBIE
                                                                                                                      Contact Address. Mailing. Mailing Address  ContactAddress                         MailingAddress                                                            MailingAddress                0        1
125




                                                                                                                                                                                                                                                                                 10 of 15                                                                                                                                                                                                                                                  2/25/2012
1cdd2d9a-70d6-4b80-80ae-391d0f0e0328.xls                                                                                                           flow_Shared




           AM                 AN       AO               AP        AQ           AR             BJ                BK
                                                                                                              Waste      BL   BM   BN
                                                                                                             Activity
                                                                                         Handler            Mandatory
      CRM Data       CRM Data      CRM Data                     RCRA                    Mandatory              Data
  1   B lock         B lock ID     Elemen t      Commen t       Table        Module    Data Element          Element
  2
  3
  4                                                                   Handler
                                                             LU_WASTE_CODE                          N/A             1
  5                                                                   Handler
                                                             LU_WASTE_CODE                          N/A             1
  6
  7
  8                                                                   Handler
                                                             LU_WASTE_CODE                              0           1
  9                                                                   Handler
                                                             LU_WASTE_CODE                              0           1
 10                                                                                                     0           1
 11                                                                    Permitting
                                                             LU_UNIT_OF_MEASURE                         0           1
 12
 13
                                                                                       1, if value is
14                                                                                     1,2,n                        1
15                                                                                                      0           0
16
17
18                                                           HNAICS        Handler                      1         N/A
19                                                                                                      0         N/A
20                    F
      Facility Activity .07        SIC/NAICS Code                                                       0         N/A
21                                                           HNAICS        Handler                      0         N/A
22
23
24                                                           HHANDLER2Handler                           1         N/A
25                                                           HHANDLER2Handler                           1         N/A
26                                                           HHANDLER2Handler                           1         N/A
27                                                           HHANDLER2Handler                           1         N/A
28                                                           HHANDLER2Handler                           1         N/A
29                                                           HHANDLER2Handler                           1         N/A
30                                                           HHANDLER2Handler                           1         N/A
31
32
33                                                                     Handler
                                                             HCERTIFICATION                             1         N/A
34                                                                     Handler
                                                             HCERTIFICATION                             1         N/A
35                                                                     Handler
                                                             HCERTIFICATION                             1         N/A
36                   C.02
      Individual Identity          First Name                          Handler
                                                             HCERTIFICATION                             1         N/A
37                   C.02
      Individual Identity          Middle Name                         Handler
                                                             HCERTIFICATION                             1         N/A
38                   C.02
      Individual Identity          Last Name                           Handler
                                                             HCERTIFICATION                             1         N/A
39                                                                     Handler
                                                             HCERTIFICATION                             0         N/A
40
41
42                                                                    Handler
                                                             LU_STATE_ACTIVITY                          0           1
43                                                                    Handler
                                                             LU_STATE_ACTIVITY                          0           1
44                                                                    Handler
                                                             HSTATE_ACTIVITY                            0           0
45
46
47                                                               HOWNER_OPERATOR2
                                                                         Handler               1              N/A
48                                               Affiliation Type OWNER_OPERATOR2
                                                                 H       Handler               1              N/A
49                                               Organization Type
                                                                 HOWNER_OPERATOR2
                                                                         Handler               1              N/A
50                                               Affiliation Start Date
                                                                 HOWNER_OPERATOR2
                                                                         Handler               1              N/A
51                                                                       Handler                              N/A
                                                                 HOWNER_OPERATOR2 1, if owneroperator indicator is po or pp
52                                               Organizaton DUNS Number
                                                                 HOWNER_OPERATOR2
                                                                         Handler               1              N/A
53                                                               HOWNER_OPERATOR2
                                                                         Handler               0              N/A
54                                                                                             1
55
56
57                                                                                                  N/A            N/A
58                                                                                                  N/A            N/A
59                                                                                                  N/A            N/A
60                                                                                                  N/A            N/A
61                                                                                                  N/A            N/A
62                                                                                                  N/A            N/A
63                                                                                                  N/A            N/A
64                                                                                                  N/A            N/A
65
66
67                                                           LU_UNIVERSAL_WASTE
                                                                      Handler                         0             1
68                                                                    Handler
                                                             LU_UNIVERSAL_WASTE                       0             1
69                                                                    Handler
                                                             HUNIVERSAL_WASTE                       N/A             1
70                                                                    Handler
                                                             HUNIVERSAL_WASTE                       N/A             1
71                                                                    Handler
                                                             HUNIVERSAL_WASTE                         0             1
72
73
74                                                                    Handler
                                                             LU_UNIVERSAL_WASTE                       0              1
75                                                                    Handler
                                                             LU_UNIVERSAL_WASTE                       0              1
76                                                                    Handler
                                                             HUNIVERSAL_WASTE                         0              1
77                                                                    Handler
                                                             HUNIVERSAL_WASTE                         0              1
78                                                                    Handler
                                                             HUNIVERSAL_WASTE                         0              1
79                                                                                                  N/A            N/A
80                                                                                                  N/A            N/A
81                                                                                                  N/A            N/A
82                                                                                                  N/A            N/A
83                                                                                                  N/A            N/A
84                                                                                                  N/A            N/A
85                                                                                                  N/A            N/A
86                                                                                                  N/A            N/A
87
88
89                    F
      Facility Identity .02        Facility Site Name         HHANDLER2     Handler                     1           1
90                                                            HHANDLER2     Handler                     1           1
91                                                            HHANDLER2
                                                Legislative District Number Handler                     0           0
92                                                            HHANDLER2     Handler                     0           0
93                                                            HHANDLER2     Handler                     0           0
94                                                            HHANDLER2     Handler                     0           0
95                                                            HHANDLER2     Handler                     1           1
96                                                            HHANDLER2     Handler                     1           1
97                                                            HHANDLER2     Handler                     1           1
98                                                            HHANDLER2     Handler                     0           0
99               R.10
      Waste Disposal Activity      Transfer Facility                                                    0           0
100                                                           HHANDLER2     Handler                     0           0
101                                                           HHANDLER2     Handler                     0           0
102
103
104                                                                                                     1          N/A
105                                                                                                     1          N/A
106                                                                                                     0          N/A
107                                                                                                     0          N/A
108                                                                                                     0          N/A
109                                                                                                     0          N/A
110                                                                                                     0          N/A
111                                                                                                     0          N/A
112
113                                                                                                     1          N/A
114                                                                                                     1          N/A
115                                                                                                     1          N/A
116
117                                                            HHANDLER2    Handler                 1               1
118                                                            HHANDLER2    Handler                 1               1
119                                                            HHANDLER2    Handler                 1               1
120                                              Use First, Middle, Last OR OrganizationFormal Name 1               1
121
122
123
124
125




                                                                                                                                        11 of 15    2/25/2012
          1cdd2d9a-70d6-4b80-80ae-391d0f0e0328.xls                                                                                                                                                                                           FRS


     A           B          C            D            E            F           G           H            I            J           K         L         M         N          O         P          Q         R          S         T       U        V
                                      Original                                                                                          Property           Represent                                 Associate
              Original                Source                                                 Object                 Object   Property    Term                ation    Represent                      dObjectCl Associate
               Data       Original     Data                   XML Tag            ABIE/ASBI   Class                   Class    Term     Possessiv PropertyT   Term       ation   Data Type            assQualifi dObjectCl Business MinOccur MaxOccur
1    ID       Source     Source ID     Name       Definition   Name   Dictionary Entry Name Qualifier
                                                                                   E/BBIE                            Term    Qualifier     e        erm     Qualifier   Term     Qualifier Data Type    er       assTerm   Term(s)    s        s
                                                                                                                 MailingAdd
2                                                 Reused from FRS Schema modules. ABIEDetails
                                                               MailingAddressDataType
                                                                             Mailing Address.                    ress                              Details                                NA
                                                                                                                 MailingAdd MailingAdd
3                                                              MailingAddressText Address.
                                                  Reused from FRS Schema modules. BBIE_ Text
                                                                             Mailing                             ress         ress                 Text                      Text         MailingAddressTextDataType                     0          1
                                                                                                                 MailingAdd
4                                                 Reused from FRS Schema modules. BBIESupplemental
                                                               SupplementalAddress
                                                                             Mailing Address.                    ress         Supplemental         Address                   Text         SupplementalAddressDataType                    0          1
                                                                                                                 MailingAdd MailingAdd
 5                                                             MailingAddressCityName
                                                  Reused from FRS Schema modules. BBIE_ City. Name
                                                                             Mailing Address.                    ress         ress                 City                      Name         MailingAddressCityNameDataType                 0          1
 6                                                             MailingAddressStateUSPSCode
                                                                             Mailing Address.
                                                  Reused from FRS Schema modules. BBIE_ State U S P. Code        MailingAddress
                                                                                                                              MailingAddress       StateUSPS                 Code         MailingAddressStateUSPCodeDataType             0          1
 7                                                             MailingAddressStateName
                                                                             Mailing Address.
                                                  Reused from FRS Schema modules. BBIE_ State. Name              MailingAddress
                                                                                                                              MailingAddress       State                     Name         MailingAddressStateNameDataType                0          1
 8                                                             MailingAddressCountryName
                                                                             Mailing Address.
                                                  Reused from FRS Schema modules. BBIE_ Country. Name MailingAddress          MailingAddress       Country                   Name         MailingAddressCountryNameDataType              0          1
 9                                                             MailingAddressZipCode
                                                                             Mailing Address.
                                                  Reused from FRS Schema modules. BBIE_ Zip. Code                MailingAddress
                                                                                                                              MailingAddress       Zip                       Code         MailingAddressZipCodeDataType                  0          1
10                                                             LocationAddressDataType
                                                                             Location Address.
                                                  Reused from FRS Schema modules. ABIE Details                   LocationAddress                   Details                   Details      NA
11                                                             LocationAddressText Address.
                                                                             Location
                                                  Reused from FRS Schema modules. BBIE _ Text                    LocationAddress
                                                                                                                              LocationAddress      Text                      Text         LocationAddressTextDataType                    0          1
12                                                             SupplementalLocation
                                                                             Location Address.
                                                  Reused from FRS Schema modules. BBIE Supplemental              LocationAddress
                                                                                                                              Supplemental         Location                  Text         SupplementalLocationDataType                   0          1
13                                                             LocalityNameocation Address.
                                                                             L
                                                  Reused from FRS Schema modules. BBIE Locality. Name LocationAddress                              Locality                  Name         LocalityNameDataType                           0          1
14                                                             CountyStateFIPSCode
                                                                             Location Address.
                                                  Reused from FRS Schema modules. BBIE County State_ FIPS. Code  LocationAddress
                                                                                                                              CountyState          FIPS                      Code         CountyStateFIPSCodeDataType                    0          1
15                                                             CountyName    Location Address.
                                                  Reused from FRS Schema modules. BBIE County. Name              LocationAddress                   County                    Name         CountyNameDataType                             0          1
16                                                             StateUSPSCode Location Address.
                                                  Reused from FRS Schema modules. BBIE State U S P. CodeLocationAddress                            StateUSPS                 Code         StateUSPCodeDataType                           0          1
17                                                             StateName Location Address.
                                                  Reused from FRS Schema modules. BBIE State. Name               LocationAddress                   State                     Name         StateNameDataType                              0          1
18                                                             CountryName   Location Address.
                                                  Reused from FRS Schema modules. BBIE Country. Name LocationAddress                               Country                   Name         CountryNameDataType                            0          1
19                                                             LocationZipCode
                                                                             Location Address.
                                                  Reused from FRS Schema modules. BBIE _ Zip. Code               LocationAddress
                                                                                                                              Location             Zip                       Code         LocationZipCodeDataType                        0          1
20                                                             LocationDescription Address.
                                                                             Location
                                                  Reused from FRS Schema modules. BBIE _ Description             LocationAddress
                                                                                                                              Location             Description               Text         LocationDescriptionDataType                    0          1
21                                                             PhoneFaxEmailDataType
                                                                             Phone Fax Email.
                                                  Reused from FRS Schema modules. ABIE Details                   PhoneFaxEmail                     Details                   Details      NA
22                                                             EmailAddress  Phone Fax Email. _ Address
                                                                                         BBIE
                                                  Email address associated with the permit contact.              PhoneFaxEmailEmail                Address                   Text         EmailAddressDataType                           0          1
23                                                             TelephoneNumber Fax Email. Telephone.
                                                                             Phone       BBIE
                                                  Telephone number associated with the permit contact. Number    PhoneFaxEmail                     Telephone                 Number       TelephoneNumberDataType                        0          1
24                                                             PhoneExtentionNumberEmail. Extention. NumberPhoneFaxEmail
                                                                             Phone Fax BBIE
                                                  Telephone number extension associated with the permit contact.                                   PhoneExtention            Number       PhoneExtentionNumberDataType                   0          1
25                                                             FaxNumber Phone Fax Email.
                                                  Reused from FRS Schema modules. BBIE Number                    PhoneFaxEmail                     Fax                       Number       FaxNumberDataType                              0          1
26                                                             AlternateTelephoneNumber
                                                                             Phone Fax Email.                    PhoneFaxEmail
                                                  Reused from FRS Schema modules. BBIE Alternate_ Telephone. NumberAlternate                       Telephone                 Number       AlternateTelephoneNumberDataType               0          1
27                                                             GeographicCoordinateDataType
                                                                             Geographic Coordinate. Details
                                                  Reused from FRS Schema modules. ABIE                           GeographicCoordinate              Details                   Details      NA
28                                                             LatitudeMeasure
                                                                             Geographic Coordinate. Latitude. Measure
                                                  Reused from FRS Schema modules. BBIE                           GeographicCoordinate              Latitude                  Measure      LatitudeMeasureDataType                        0          1
29                                                             LongitudeMeasure
                                                                             Geographic Coordinate. Longitude. Measure
                                                  Reused from FRS Schema modules. BBIE                           GeographicCoordinate              Longitude                 Measure      LongitudeMeasureDataType                       0          1
30                                                             HorizontalAccuracyMeasure
                                                  Reused from FRS Schema modules. BBIE
                                                                             Geographic Coordinate. Horizontal_ GeographicCoordinate
                                                                                                                  Accuracy. Measure
                                                                                                                              Horizontal           Accuracy                  Measure      HorizontalAccuracyMeasureDataType              0          1
31                                                             HorizontalCollectionMethod
                                                  Reused from FRS Schema modules. BBIE
                                                                             Geographic Coordinate. Horizontal_ GeographicCoordinate
                                                                                                                  Collection Method
                                                                                                                              Horizontal           CollectionMethod          Text         HorizontalCollectionMethodDataType             0          1
32                                                             HorizontalReferenceDatumName
                                                  Reused from FRS Schema modules. BBIE
                                                                             Geographic Coordinate. Horizontal_ GeographicCoordinate
                                                                                                                  Reference Datum. Name
                                                                                                                              Horizontal           ReferenceDatum            Name         HorizontalReferenceDatumNameDataType           0          1
33                                                             SourceMapScaleNumber
                                                                             Geographic Coordinate. Source MapGeographicCoordinate
                                                  Reused from FRS Schema modules. BBIE                            Scale. Number                    SourceMapScale            Number       SourceMapScaleNumberDataType                   0          1
34                                                             ReferencePointGeographic Coordinate. Reference Point
                                                  Reused from FRS Schema modules. BBIE                           GeographicCoordinate              ReferencePoint            Text         ReferencePointDataType                         0          1
35                                                             DataCollectionDate
                                                                             Geographic Coordinate. Data Collection. Date
                                                  Reused from FRS Schema modules. BBIE                           GeographicCoordinate              DataCollection            Date         DataCollectionDateDataType                     0          1
36                                                             GeometricTypeName Coordinate. Geometric Type. Name
                                                                             Geographic
                                                  Reused from FRS Schema modules. BBIE                           GeographicCoordinate              GeometricType             Name         GeometricTypeNameDataType                      0          1
37                                                             LocationComments
                                                                             Geographic Coordinate. Location Comments
                                                  Reused from FRS Schema modules. BBIE                           GeographicCoordinate              LocationComments          Text         LocationCommentsDataType                       0          1
38                                                             VerticalCollectionMethod
                                                  Reused from FRS Schema modules. BBIE
                                                                             Geographic Coordinate. Vertical_ Collection Method
                                                                                                                 GeographicCoordinate
                                                                                                                              Vertical             CollectionMethod          Text         VerticalCollectionMethodDataType               0          1
39                                                             VerticalMeasure
                                                                             Geographic Coordinate. Vertical_ Measure
                                                  Reused from FRS Schema modules. BBIE                           GeographicCoordinate Vertical
                                                                                                                              Vertical             Measure                   Measure      VerticalMeasureDataType                        0          1
40                                                             VerticalAccuracyMeasure
                                                  Reused from FRS Schema modules. BBIE
                                                                             Geographic Coordinate. Vertical_ Accuracy. Measure
                                                                                                                 GeographicCoordinate
                                                                                                                              Vertical             Accuracy                  Measure      VerticalAccuracyMeasureDataType                0          1
41                                                             VerticalReferenceDatumName
                                                  Reused from FRS Schema modules. BBIE
                                                                             Geographic Coordinate. Vertical_ Reference Datum. Name
                                                                                                                 GeographicCoordinate
                                                                                                                              Vertical             ReferenceDatum            Name         VerticalReferenceDatumNameDataType             0          1
42                                                             DataSourceNameGeographic Coordinate. Data Source. Name
                                                  Reused from FRS Schema modules. BBIE                           GeographicCoordinate              DataSource                Name         DataSourceNameDataType                         0          1
43                                                             CoordinateDataSourceName
                                                                             Geographic Coordinate. _ Data Source. Name Coordinate
                                                  Reused from FRS Schema modules. BBIE                           GeographicCoordinate              DataSource                Name         CoordinateDataSourceNameDataType               0          1
44                                                             SubEntityID Geographic Coordinate. Sub Entity. Identifier
                                                  Reused from FRS Schema modules. BBIE                           GeographicCoordinate              SubEntity                 Identifier   SubEntityIDDataType                            0          1
45                                                             SubEntityTypeName
                                                                             Geographic Coordinate. Sub Entity Type. Name
                                                  Reused from FRS Schema modules. BBIE                           GeographicCoordinate              SubEntityType             Name         SubEntityTypeNameDataType                      0          1
46                                                             AddressDataType
                                                  Details for an address Address. DetailsABIE                    Address                           Details                   Details      NA
47                              28                The street StreetNumber     address. BBIE
                                     Mailing Street Number number for anAddress. Street_ Number                  Address      Street               Number                    Number       StreetNumberDataType                           0          1
48                              29                First        Address       Address.
                                     Mailing Street 1 line of the street address (or theBBIE office box number).
                                                                                          post                   Address                           Address                   Text         AddressDataType                                0          1
49                              30                Second line SupplementalAddressSupplemental
                                     Mailing Street 2                        address
                                                               of the streetAddress. (or BBIE
                                                                                         the post office box number).
                                                                                                                 Address      Supplemental         Address                   Text         SupplementalAddressDataType                    0          1
50                              31                              city or town.A           BBIE
                                     Mailing City Name of theLocalityName ddress. Locality. Name                 Address                           Locality                  Name         LocalityNameDataType                           0          1
51                              32   Mailing State             StateCode Address. State. BBIE
                                                  The two-letter postal code for the state. Code                 Address                           State                     Code         StateCodeDataType                              0          1
52                              33                Zip code. PostalCode Address. Postal. Code
                                     Mailing ZIP Code                                    BBIE                    Address                           Postal                    Code         PostalCodeDataType                             0          1
53                              34                Country code.
                                     Mailing Country                         A
                                                               CountryCode ddress. Country. Code
                                                                                         BBIE                    Address                           Country                   Code         CountryCodeDataType                            0          1
54                                                                           Latitude Longitude. Details
                                                               LatitudeLongitudeDataType ABIE                    LatitudeLongitude                                                        NA
55                                                Code
                                     Transaction Transaction TransactionCode
                                                               code used to define the add, update, or delete. LatitudeLongitude
                                                                             Latitude Longitude. Transaction. Code
                                                                                         BBIE                                                      Transaction               Code         TransactionCodeDataType                        0          1
56                              63                The code GeometricTypeCode Longitude. Geometric_ Type. point
                                                                             Latitude    BBIE
                                     Geometric Type Code that represents the geometric entity described by oneCode or aGeometric of latitude and longitude points.
                                                                                                                 LatitudeLongitude
                                                                                                                               sequence            Type                      Code         GeometricTypeCodeDataType                      0          1
57                              64                The measure of the
                                                               HorizontalAccuracyMeasure
                                                                             Latitude Longitude. Horizontal_ Accuracy. Measure
                                                                                         BBIE
                                     Horizontal Accuracy Measure accuracy (in meters) of the latitude and longitude coordinates.
                                                                                                                 LatitudeLongitude
                                                                                                                              Horizontal           Accuracy                  Measure      HorizontalAccuracyMeasureDataType              0          1
58                              65                The code that represents the methodBBIE to determineCollection_ Method. Code coordinates for Method location.
                                                               HorizontalCollectionMethodCode
                                     Horizontal Collection Method                         used
                                                                             Latitude Longitude. Horizontal the latitude and longitude
                                                                                                                 LatitudeLongitude
                                                                                                                              HorizontalCollection the site                  Code         HorizontalCollectionMethodCodeDataType         0          1
59                              66                The code that represents the reference datum used in determining the latitude and longitude coordinates for the site location.
                                     Horizontal Reference Datum              Latitude Longitude.
                                                                                         BBIE
                                                               HorizontalReferenceDatumCodeHorizontal_ Reference Datum. Code
                                                                                                                 LatitudeLongitude
                                                                                                                              Horizontal           ReferenceDatum            Code         HorizontalReferenceDatumCodeDataType           0          1
60                              67                Latitude of the site location, expressed in GPSMeasurePositioning System) format.
                                     Latitude Measure                        Latitude Longitude. _ (Global
                                                               LatitudeMeasure           BBIE                    LatitudeLongitude
                                                                                                                              Latitude             Measure                   Measure      LatitudeMeasureDataType                        0          1
61                              68                Longitude ofLongitudeMeasure Longitude.GPS (Global Positioning System) format.
                                     Longitude Measure                       Latitude    BBIE
                                                                the site location, expressed in _ Measure        LatitudeLongitude
                                                                                                                              Longitude            Measure                   Measure      LongitudeMeasureDataType                       0          1
62                              69                The Code ReferencePointCodeLongitude. geographic coordinates
                                                                             Latitude    BBIE
                                     Reference Point code that represents the place for whichReference_ Point. Code were established.
                                                                                                                 LatitudeLongitude
                                                                                                                              Reference            Point                     Code         ReferencePointCodeDataType                     0          1
63                              70                Scale NumbersSourceMapScaleNumber determine latitude/longitude.
                                                                              map used to
                                     Source Map Scale of detail on sourceLatitude Longitude. Source Map_ Scale. Number SourceMap
                                                                                         BBIE                    LatitudeLongitude                 Scale                     Number       SourceMapScaleNumberDataType                   0          1
64


                                                                                                                                      12 of 15                                                                                          2/25/2012
            1cdd2d9a-70d6-4b80-80ae-391d0f0e0328.xls                                                                                                                                                                 FRS


        W           X         Y          Z          AA        AB         AC        AD          AE           AF         AG           AH      AI          AJ          AK          AL          AM          AN
                                                                                 EDSC
                                                            EDSC       EDSC    Dictionary                             Major     Compoun
                         MaxLengt TotalDigit      Owning   XML Tag    Standard   Entry        EDSC         EDR         Data      d Data                Data       RCRA
1     Format   MinLength    h         s           Agency    Name       Group     Name        Format      Identifier   Group      Block  DataBlock    Element      Table      Module     UBL

2

3 VARCHAR2(30)          1          30

4 VARCHAR2(30)          1          30

 5   VARCHAR2(25)       1          25
 6   CHAR2(2)           1           2
 7   VARCHAR2(25)       1          25
 8   CHAR(2)            1           2
 9   VARCHAR2(14)       1          14
10
11   VARCHAR2(25)       1          25
12   VARCHAR2(30)       1          30
13   VARCHAR(12)        1          12
14   VARCHAR(12)        1          12
15   VARCHAR(12)        1          12
16   CHAR2(2)           1          14
17   CHAR(2)            1           2
18   CHAR(2)            1           2
19   VARCHAR2(14)       1          14
20   VARCHAR2(30)       1          30
21
22   VARCHAR2(240)      1         240
23   VARCHAR2(15)       1          15
24   VARCHAR2(6)        1           6
25   VARCHAR2(15)       1          15
26   VARCHAR2(15)       1          15
27
28   NUMBER (10,6)                           16
29   NUMBER (11,6)                           17
30   VARCHAR2(6)        1           6
31   VARCHAR2(3)        1           3
32   VARCHAR2(3)        1           3
33   VARCHAR2(10)       1          10
34   VARCHAR2(3)        1           3
35   VARCHAR2(15)
36   VARCHAR2(15)       1          15
37   VARCHAR2(100)      1         100
38   VARCHAR2(3)        1           3
39   VARCHAR2(15)       1
40   VARCHAR2(6)        1           6
41   VARCHAR2(3)        1           3
42   VARCHAR2(15)       1          15
43   VARCHAR2(15)       1          15
44   VARCHAR2(15)       1          15
45   VARCHAR2(15)       1          15
46
47   VARCHAR2(12)       1          12                      MailingAddressText
                                                                      2.1.1                 A (50)                                                             HHANDLER2 andler
                                                                                                                                                                             H
                                                                                                                                                    C.05 Address Identification; address
48   VARCHAR2(30)       1          30                      MailingAddressText
                                                                      2.1.1                 A (50)                                                             HHANDLER2 andler
                                                                                                                                                                             H
                                                                                                                                                    C.05 Address Identification; address
49   VARCHAR2(30)       1          30                      SupplementalAddressText
                                                                      2.1.2                 A (50)                                                             HHANDLER2 andler
                                                                                                                                                                             H
                                                                                                                                                    C.05 Address Identification; address
50   VARCHAR2(25)       1          25                      MailingAddressCityName
                                                                      2.1.3                 A (30)                                                             HHANDLER2 andler
                                                                                                                                                                             H
                                                                                                                                                    C.05 Address Identification; City Name
51   CHAR(2)            1           2                      MailingAddressStateCode
                                                                      2.1.4                 Alphanumeric                                                       HHANDLER2 andler
                                                                                                                                                                             H           CountrySub-entity
                                                                                                                                                    C.05 Address Identification; State Code
52   VARCHAR2(14)       1          14                      AddressPostalCode
                                                                      2.1.5                 A (14)                                                             HHANDLER2 andler
                                                                                                                                                                             H
                                                                                                                                                    C.05 Address Identification; zip codePostalZone
53   CHAR(2)            1           2                      MailingAddressCountryCode
                                                                      2.1.6                 Alphanumeric                                                                     H
                                                                                                                                                               HHANDLER2 andler
54
55                      1           1
56   VARCHAR2(3)        1           3                      GeometricTypeCode                         3        5614                                                        H
                                                                                                                                                              HHANDLER2 andler
57   VARCHAR2(6)        1           6                      HorizontalAccuracyMeasure                 6        5264                                                        H
                                                                                                                                                              HHANDLER2 andler
58   VARCHAR2(3)        1           3                      HorizontalCollectionMethodCode            3        5238                                                        H
                                                                                                                                                              HHANDLER2 andler
59   VARCHAR2(3)        1           3                      HorizontalReferenceDatumCode              3        5308                                                        H
                                                                                                                                                              HHANDLER2 andler
60   NUMBER(10,6)       1                    16            Latitude Measure                         10        5518                                            HHANDLER2 andler
                                                                                                                                                                          H
                                                                                                                                                    SD.02 Geographical Location Description; Latitude Measure
61   NUMBER(11,6)       1                    17            Longitude Measure                        11        5520                                            HHANDLER2 andler
                                                                                                                                                                          H
                                                                                                                                                    SD.02 Geographical Location Description; Longitude Measure
62   VARCHAR2(3)        1           3                      ReferencePointCode                        3        5608                                                        H
                                                                                                                                                              HHANDLER2 andler
63   NUMBER(10)         1                    10            SourceMapScaleNumber                     10        5318                                                        H
                                                                                                                                                              HHANDLER2 andler
64


                                                                                                                              13 of 15                                                                           2/25/2012
7/10/2005 LMI made the following updates to the spreadsheets:
The following additional columns were added
Column W Format= The datatype from the RCRAInfo DEDs
Column X Min Length= specifies a minimum length
Column Y Max Length= specifies a maximum length
Column Z Length= specifies an exact length
Column AA Total Digits= specifies a maximum number of digits
Column AB Fraction Digits= specifies the maximum number of digits in the fractional portion of a decimal

Column BJ Mandatory Data Element= This is taken from the RCRAInfo DEDs and specifies if an element is Nation

These updates are have been carried forward into a set of XML Schemas called:
RCRAInfo_HazardousWasteModuleNamev1.0.xsd
onal portion of a decimal

d specifies if an element is Nationally required. 1= true or yes and 0=false or no

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:2/26/2012
language:
pages:15