class AccChem(BaseRMPModel):
id = CopyFromIntegerField(
primary_key=True,
source_column='accchem_id',
verbose_name='Accident Chemical Record ID',
help_text='A unique ID for each accident chemical record.',
)
accident = CopyFromForeignKey(
'Accident',
on_delete=models.PROTECT,
help_text='The unique ID for each accident record',
)
chemical = CopyFromForeignKey(
'ChemCd',
on_delete=models.PROTECT,
help_text='The identifying ID for a particular chemical released in an '
'accident.',
)
quantity_lbs = CopyFromIntegerField(
null=True,
verbose_name='Amount Released (lbs)',
help_text='The amount of the substance released in the accident, in '
'pounds, to two significant digits.',
)
percent_weight = CopyFromDecimalField(
decimal_places=2,
null=True,
max_digits=5,
verbose_name='Percent Weight (Within Mixture)',
help_text='The percent weight of a chemical within a mixture released '
'in an accident.',
)
num_acc_flam = CopyFromIntegerField(
null=True,
verbose_name='Number of Flammable Components',
help_text='The number of listed flammable component chemicals for this'
' chemical record.',
)
cas = CopyFromCharField(
max_length=9,
verbose_name='CAS number',
help_text='The identifying CAS number for a chemical.',
)
CHEMICAL_TYPE_CHOICES = (
('T', 'toxic'),
('F', 'flammable'),
)
chemical_type = CopyFromCharField(
max_length=1,
choices=CHEMICAL_TYPE_CHOICES,
help_text='"The type of chemical.',
)
source_file = 'rmp_acc_chem'
class tblS9EmergencyResponses(BaseRMPModel):
FacilityID = CopyFromOneToOneField(
'tblS1Facilities',
db_column='FacilityID',
on_delete=models.PROTECT,
primary_key=True,
)
ER_CommunityPlan = CopyFromBooleanField(
)
ER_FacilityPlan = CopyFromBooleanField(
)
ER_ResponseActions = CopyFromBooleanField(
)
ER_PublicInfoProcedures = CopyFromBooleanField(
)
ER_EmergencyHealthCare = CopyFromBooleanField(
)
ER_ReviewDate = CopyFromCharField(
blank=True,
max_length=17,
)
ERTrainingDate = CopyFromCharField(
blank=True,
max_length=17,
)
CoordinatingAgencyName = CopyFromCharField(
max_length=250,
blank=True,
)
CoordinatingAgencyPhone = CopyFromCharField(
source_column='CoordinatingAgencyPhone',
max_length=10,
blank=True,
)
FR_OSHA1910_38 = CopyFromBooleanField(
)
FR_OSHA1910_120 = CopyFromBooleanField(
)
FR_SPCC = CopyFromBooleanField(
)
FR_RCRA = CopyFromBooleanField(
)
FR_OPA90 = CopyFromBooleanField(
)
FR_EPCRA = CopyFromBooleanField(
)
FR_OtherRegulation = CopyFromCharField(
max_length=200,
blank=True,
)
class Meta:
verbose_name = 'Emergency Response Plan'
verbose_name_plural = 'Emergency Response Plans'
class tlkpDeregistrationReason(BaseRMPModel):
LookupCode = CopyFromCharField(
primary_key=True,
max_length=2,
help_text='System generated Unique Primary key.',
)
Description = CopyFromCharField(
max_length=62,
help_text='Deregulation Reason descriptions.'
)
class Meta:
verbose_name='Lookup: Deregistration Reason'
class tlkpTopographyCode(BaseRMPModel):
LookupCode = CopyFromCharField(
primary_key=True,
max_length=1,
help_text='System generated Unique Primary key.',
)
Description = CopyFromCharField(
max_length=5,
help_text='A code representing whether the local topography is urban or rural.',
)
class Meta:
verbose_name='Lookup: Topography Code'
class tlkpWindSpeedUnitCodes(BaseRMPModel):
LookupCode = CopyFromCharField(
primary_key=True,
max_length=1,
help_text='System generated Unique Primary key.',
)
Description = CopyFromCharField(
max_length=13,
help_text='Wind Speed Unit Descriptions.',
)
class Meta:
verbose_name='Lookup: Wind Speed Unit Codes'
class tlkpSubmissionReasonCodes(BaseRMPModel):
LookupCode = CopyFromCharField(
primary_key=True,
max_length=3,
help_text='System generated Unique Primary key.',
)
Description = CopyFromCharField(
max_length=101,
help_text='Submission Reason descriptions.',
)
class Meta:
verbose_name='Lookup: Submission Reason Code'
class tlkpRejectReason(BaseRMPModel):
LookupCode = CopyFromCharField(
primary_key=True,
max_length=1,
help_text='System generated Unique Primary key.',
)
Description = CopyFromCharField(
max_length=59,
help_text='Rejection Reason descriptions.',
)
class Meta:
verbose_name='Lookup: Reject Reason'
class tlkpDocType(BaseRMPModel):
LookupCode = CopyFromCharField(
primary_key=True,
max_length=1,
help_text='Unique identifier of the document type.'
)
Description = CopyFromCharField(
max_length=30,
help_text='Full description of the document type.'
)
class Meta:
verbose_name='Lookup: Doc Type'
class tlkpS6InitiatingEvents(BaseRMPModel):
LookupCode = CopyFromCharField(
primary_key=True,
max_length=1,
help_text='System generated Unique Primary key.',
)
Description = CopyFromCharField(
max_length=40,
help_text='Pick-list text.',
)
class Meta:
verbose_name='Lookup: Initiating Events'
class tlkpDocHandle(BaseRMPModel):
LookupCode = CopyFromCharField(
primary_key=True,
max_length=1,
help_text='Primary Key.',
)
Description = CopyFromCharField(
max_length=1,
help_text='A description of how the document was handled',
)
class Meta:
verbose_name='Lookup: Deregistration Reason'
class LlmethCd(BaseRMPModel):
llmeth = CopyFromCharField(
primary_key=True,
source_column='Method_Code',
max_length=2,
)
llmeth_tr = CopyFromCharField(source_column='Method_Desc', max_length=83)
@classmethod
def get_transform_queryset(self):
m = raw_models.tlkpLatLongMethods
return m.objects.get_default_transform_queryset()
class tlkpPhysicalStateCodes(BaseRMPModel):
LookupCode = CopyFromCharField(
primary_key=True,
max_length=1,
help_text='Physical State description.',
)
Description = CopyFromCharField(
max_length=30,
help_text='System generated Unique Primary key.',
)
class Meta:
verbose_name='Lookup: Physical State Code'
class tlkpS2ScenarioCodes(BaseRMPModel):
LookupCode = CopyFromCharField(
primary_key=True,
max_length=1,
help_text='System generated Unique Primary key.',
)
Description = CopyFromCharField(
max_length=27,
help_text='Pick-list text.',
)
class Meta:
verbose_name='Lookup: Toxics Scenario Code'
class tlkpLatLongMethods(BaseRMPModel):
Primary_Key = CopyFromIntegerField(
primary_key=True,
)
Method_Code = CopyFromCharField(
max_length=2,
unique=True,
)
Method_Desc = CopyFromCharField(
max_length=83
)
class Meta:
verbose_name='Lookup: Lat/Long Method'
class tlkpLatLongDescriptions(BaseRMPModel):
Feat_Code = CopyFromCharField(
primary_key=True,
max_length=2,
help_text='Unique identifier for each Latitude and longitude '
'description.',
)
Feat_Desc = CopyFromCharField(
max_length=36,
help_text='Latitude and longitude description.',
)
class Meta:
verbose_name='Lookup: Lat/Long Description'
class FlammablesWorstCase(BaseRMPModel):
id = CopyFromIntegerField(
primary_key=True,
source_column='flammable_id',
)
procchem = CopyFromForeignKey(
'ProcChem',
on_delete=models.CASCADE
)
analytical_basis = CopyFromCharField(max_length=255, blank=True)
# quantity_lbs = CopyFromDecimalField(max_digits=6, decimal_places=2, blank=True)
# endpoint_distance = CopyFromDecimalField(max_digits=5, decimal_places=1)
quantity_lbs = CopyFromCharField(max_length=20, blank=True)
endpoint_distance = CopyFromCharField(max_length=20, blank=True)
population = CopyFromCharField(max_length=9, blank=True)
pr_schools = CopyFromBooleanField()
pr_residences = CopyFromBooleanField()
pr_hospitals = CopyFromBooleanField()
pr_prisons = CopyFromBooleanField()
pr_public_rec = CopyFromBooleanField()
pr_comm_ind = CopyFromBooleanField()
pr_othertype = CopyFromCharField(max_length=200, blank=True)
er_natlstateparks = CopyFromBooleanField()
er_wildlife_sanct = CopyFromBooleanField()
er_fedwilderness = CopyFromBooleanField()
er_othertype = CopyFromCharField(max_length=200, blank=True)
pm_blastwalls = CopyFromBooleanField()
pm_othertype = CopyFromCharField(max_length=200, blank=True)
ptrgraphic = CopyFromCharField(max_length=12, blank=True)
cbi_flag = CopyFromBooleanField()
source_file = 'rmp_worst_flam'
class tlkpNAICS(BaseRMPModel):
NAICS_CODE = CopyFromCharField(
primary_key=True,
max_length=6,
verbose_name='NAICS Code',
help_text='The 5- or 6- digit NAICS code.',
)
NAICS_DESCRIPTION = CopyFromCharField(
max_length=118,
verbose_name='NAICS Description',
help_text='Description text for the NAICS code.',
)
class Meta:
verbose_name = 'Lookup: NAICS codes'
class tlkpDocType(BaseRMPModel):
lookupcode = CopyFromCharField(
source_column='LookupCode',
primary_key=True,
max_length=1,
help_text='Unique identifier of the document type.')
description = CopyFromCharField(
max_length=30,
source_column='Description',
help_text='Full description of the document type.')
source_file = 'tlkpDocType'
class Meta:
verbose_name = 'Lookup: Doc Type'
class tlkpDeregistrationReason(BaseRMPModel):
lookupcode = CopyFromCharField(
primary_key=True,
max_length=2,
source_column='LookupCode',
help_text='System generated Unique Primary key.',
)
dereg_tr = CopyFromCharField(max_length=62,
source_column='Description',
help_text='Deregulation Reason descriptions.')
source_file = 'tlkpDeregistrationReason'
class Meta:
verbose_name = 'Lookup: Deregistration Reason'
class DochanCd(BaseRMPModel):
dochan = CopyFromCharField(
source_column='LookupCode',
primary_key=True,
max_length=1,
)
dochan_tr = CopyFromCharField(
source_column='Description',
max_length=1,
)
@classmethod
def get_transform_queryset(self):
m = raw_models.tlkpDocHandle
return m.objects.get_default_transform_queryset()
class Process(BaseRMPModel):
id = CopyFromIntegerField(
primary_key=True,
source_column='process_id',
)
process_desc = CopyFromCharField(max_length=25, blank=True)
rmp_id = CopyFromIntegerField()
program_level = CopyFromIntegerField()
cbi_flag = CopyFromBooleanField()
# TODO AGGREGATE
num_proc_chem = CopyFromIntegerField()
num_proc_naics = CopyFromIntegerField()
num_chem_real = CopyFromIntegerField()
num_chem_fake = CopyFromIntegerField()
num_worst_tox = CopyFromIntegerField()
num_worst_flam = CopyFromIntegerField()
num_alt_tox = CopyFromIntegerField()
num_alt_flam = CopyFromIntegerField()
num_prev_2 = CopyFromIntegerField()
num_prev_3 = CopyFromIntegerField()
toxic_tot = CopyFromBigIntegerField()
flam_tot = CopyFromBigIntegerField()
quantity_tot = CopyFromBigIntegerField()
# while these fields are listed in rmp_fields.csv, they do not appear in
# rmp_process.tsv ¯\_(ツ)_/¯
# chem_tox_yn = CopyFromBooleanField()
# chem_flam_yn = CopyFromBooleanField()
source_file = 'rmp_process'
class ProcChem(BaseRMPModel):
procchem_id = CopyFromBigIntegerField(
primary_key=True,
source_column='procchem_id',
)
process = CopyFromForeignKey(
'Process',
on_delete=models.CASCADE
)
chemical = CopyFromForeignKey(
'ChemCd',
on_delete=models.CASCADE
)
quantity_lbs = CopyFromBigIntegerField()
cbi_flag = CopyFromBooleanField()
num_alt_flam = CopyFromBigIntegerField()
num_alt_tox = CopyFromBigIntegerField()
num_prevent_2_chem = CopyFromBigIntegerField()
num_prevent_3_chem = CopyFromBigIntegerField()
num_proc_flam = CopyFromBigIntegerField()
num_worst_flam = CopyFromBigIntegerField()
num_worst_tox = CopyFromBigIntegerField()
cas = CopyFromBigIntegerField()
chemical_type = CopyFromCharField(max_length=1)
source_file = 'rmp_proc_chem'
class LldescCd(BaseRMPModel):
lldesc = CopyFromCharField(
source_column='Feat_Code',
primary_key=True,
max_length=2,
)
lldesc_tr = CopyFromCharField(
source_column='Feat_Desc',
max_length=36,
)
@classmethod
def get_transform_queryset(self):
m = raw_models.tlkpLatLongDescriptions
return m.objects.get_default_transform_queryset()
class tblS7PreventionProgram3Description_ChangeHistory(BaseRMPModel):
preventionprogram3descchangehistoryid = CopyFromIntegerField(
primary_key=True,
source_column='PreventionProgram3DescChangeHistoryID',
)
facilitychangehistoryid = CopyFromIntegerField(
source_column='FacilityChangeHistoryID', )
cdxcorrectioncode = CopyFromCharField(
max_length=1,
source_column='CDXCorrectionCode',
)
preventionprogram3id = CopyFromForeignKey(
'tblS7PreventionProgram3',
on_delete=models.PROTECT,
source_column='PreventionProgram3ID',
)
description = CopyFromTextField(
source_column='Description',
blank=True,
)
olddescription = CopyFromTextField(
source_column='OldDescription',
blank=True,
)
seqnum = CopyFromIntegerField(source_column='SeqNum', )
class tlkpLatLongMethods(BaseRMPModel):
primary_key = CopyFromIntegerField(
primary_key=True,
source_column='Primary_Key',
)
method_code = CopyFromCharField(
source_column='Method_Code',
max_length=2,
unique=True,
)
method_desc = CopyFromCharField(source_column='Method_Desc', max_length=83)
source_file = 'tlkpLatLongMethods'
class Meta:
verbose_name = 'Lookup: Lat/Long Method'
class ScenCd(BaseRMPModel):
"""
Accident(?) scenario.
"""
scen = CopyFromCharField(source_column='LookupCode',
primary_key=True,
max_length=1,
help_text='Unique identifier of the scenario.')
scen_tr = CopyFromCharField(source_column='Description',
max_length=27,
help_text='Full description of the scenario.')
@classmethod
def get_transform_queryset(self):
m = raw_models.tlkpS2ScenarioCodes
return m.objects.get_default_transform_queryset()
class tlkpS6InitiatingEvents(BaseRMPModel):
lookupcode = CopyFromCharField(
primary_key=True,
source_column='LookupCode',
max_length=1,
help_text='System generated Unique Primary key.',
)
description = CopyFromCharField(
source_column='Description',
max_length=40,
help_text='Pick-list text.',
)
source_file = 'tlkpS6InitiatingEvents'
class Meta:
verbose_name = 'Lookup: Initiating Events'
class ChemCd(BaseRMPModel):
id = CopyFromIntegerField(
source_column='ChemicalID',
primary_key=True,
help_text="RMP's unique identifier of a chemical substance.",
)
chemical_name = CopyFromCharField(
max_length=92,
help_text="Chemical substance name.",
)
cas2 = CopyFromCharField(
source_column='CASNumber',
max_length=10,
blank=True,
help_text="Chemical Abstracts Service (CAS) registry number "
"(is 2 meaningful?)",
)
threshold = CopyFromDecimalField(
source_column='threshold',
null=True,
decimal_places=1,
max_digits=8,
help_text='Threshold above which the chemical is regulated???')
chemical_type = CopyFromCharField(
source_column='ChemType',
max_length=1,
choices=CHEMICAL_TYPES,
blank=True,
help_text='"The type of chemical (T=toxic, F=Flammable).',
)
cbi_flag = CopyFromBooleanField(
source_column='flgCBI',
help_text='Indicates whether this record contained Confidential '
'Business Information (CBI) which has been erased by EPA '
'from the public version of the data.')
chemical_owner = CopyFromCharField(
source_column='ChemOwner',
max_length=3,
blank=True,
)
@classmethod
def get_transform_queryset(self):
m = raw_models.tlkpChemicals
return m.objects.get_default_transform_queryset()
class tlkpWindSpeedUnitCodes(BaseRMPModel):
lookupcode = CopyFromCharField(
primary_key=True,
source_column='LookupCode',
max_length=1,
help_text='System generated Unique Primary key.',
)
description = CopyFromCharField(
source_column='Description',
max_length=13,
help_text='Wind Speed Unit Descriptions.',
)
source_file = 'tlkpWindSpeedUnitCodes'
class Meta:
verbose_name = 'Lookup: Wind Speed Unit Codes'
class tlkpRejectReason(BaseRMPModel):
lookupcode = CopyFromCharField(
primary_key=True,
source_column='LookupCode',
max_length=1,
help_text='System generated Unique Primary key.',
)
description = CopyFromCharField(
source_column='Description',
max_length=59,
help_text='Rejection Reason descriptions.',
)
source_file = 'tlkpRejectReason'
class Meta:
verbose_name = 'Lookup: Reject Reason'
