class FilingsCd(CalAccessBaseModel):
"""
This table is the parent table from which all links and association to
a filing are derived.
"""
UNIQUE_KEY = "FILING_ID"
filing_id = fields.IntegerField(
db_column='FILING_ID',
db_index=True,
verbose_name='filing ID',
help_text="Unique filing identificiation number")
FILING_TYPE_CHOICES = (
(22001, 'Electronic'),
(22002, 'Key data entry'),
(22003, 'Historical lobby'),
(22004, 'Historical campaign'),
(22005, 'AMS'),
(22006, 'Cal Online'),
)
filing_type = fields.IntegerField(db_column='FILING_TYPE',
db_index=True,
choices=FILING_TYPE_CHOICES,
help_text="The type of filing")
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILINGS_CD'
verbose_name = 'FILINGS_CD'
verbose_name_plural = 'FILINGS_CD'
def __str__(self):
return str("%s %s" % (self.filing_id, self.filing_type))
class FilerEthicsClassCd(CalAccessBaseModel):
"""
This table stores lobbyist ethics training dates.
"""
UNIQUE_KEY = "FILER_ID", "SESSION_ID", "ETHICS_DATE"
filer_id = fields.IntegerField(
verbose_name='filer ID',
db_column='FILER_ID',
null=True,
db_index=True,
help_text="Filer's unique identification number",
)
session_id = fields.IntegerField(
verbose_name='session ID',
db_column='SESSION_ID',
help_text='Legislative session identification number',
null=True,
)
ethics_date = fields.DateTimeField(
db_column='ETHICS_DATE',
null=True,
help_text="Date ethics training was accomplished"
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILER_ETHICS_CLASS_CD'
verbose_name = 'FILER_ETHICS_CLASS_CD'
verbose_name_plural = 'FILER_ETHICS_CLASS_CD'
def __str__(self):
return str(self.filer_id)
class LookupCode(CalAccessBaseModel):
"""
The description of some lookup codes in the system.
"""
UNIQUE_KEY = ("CODE_ID", "CODE_TYPE")
code_type = fields.IntegerField(
db_column='CODE_TYPE',
help_text="This field is undocumented",
)
code_id = fields.IntegerField(
db_column='CODE_ID',
help_text="The code's identification number",
)
code_desc = fields.CharField(
db_column='CODE_DESC',
max_length=100,
null=True,
help_text="Code description",
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'LOOKUP_CODES_CD'
verbose_name = 'LOOKUP_CODES_CD'
verbose_name_plural = 'LOOKUP_CODES_CD'
def __str__(self):
return str(self.code_id)
class ReceivedFilingsCd(CalAccessBaseModel):
"""
This table is undocumented.
"""
UNIQUE_KEY = False
filer_id = fields.IntegerField(
verbose_name='filer ID',
db_column='FILER_ID',
null=True,
db_index=True,
help_text="Filer's unique identification number",
)
filing_file_name = fields.CharField(
db_column='FILING_FILE_NAME',
max_length=14,
help_text="The field is undocumented"
)
received_date = fields.DateField(
db_column='RECEIVED_DATE',
null=True,
help_text="Date received",
)
filing_directory = fields.CharField(
db_column='FILING_DIRECTORY',
max_length=45,
help_text="This field is undocumented",
)
filing_id = fields.IntegerField(
db_column='FILING_ID',
db_index=True,
verbose_name='filing ID',
help_text="Unique filing identificiation number",
null=True,
blank=True,
)
form_id = fields.CharField(
db_column='FORM_ID',
max_length=4,
blank=True,
help_text="Form identification code"
)
receive_comment = fields.CharField(
db_column='RECEIVE_COMMENT',
max_length=51,
help_text="A comment"
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'RECEIVED_FILINGS_CD'
verbose_name = 'RECEIVED_FILINGS_CD'
verbose_name_plural = 'RECEIVED_FILINGS_CD'
def __str__(self):
return str(self.filing_id)
class ReportsCd(CalAccessBaseModel):
"""
This is an undocumented model.
"""
UNIQUE_KEY = "RPT_ID"
rpt_id = fields.IntegerField(
db_column='RPT_ID',
help_text="Unique identification number"
)
rpt_name = fields.CharField(
db_column='RPT_NAME',
max_length=74,
help_text="Name of the report"
)
rpt_desc_field = fields.CharField(
db_column='RPT_DESC_',
max_length=32,
blank=True,
help_text="Description of the report"
)
path = fields.CharField(
db_column='PATH',
max_length=32,
blank=True,
help_text="Report path"
)
data_object = fields.CharField(
db_column='DATA_OBJECT',
max_length=38,
help_text="This field is undocumented"
)
parms_flg_y_n = fields.IntegerField(
db_column='PARMS_FLG_Y_N',
blank=True,
null=True,
help_text="Parameters indication flag"
)
rpt_type = fields.IntegerField(
db_column='RPT_TYPE',
help_text="Type of the report"
)
parm_definition = fields.IntegerField(
db_column='PARM_DEFINITION',
help_text="Parameter definition"
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'REPORTS_CD'
verbose_name = 'REPORTS_CD'
verbose_name_plural = 'REPORTS_CD'
def __str__(self):
return str(self.rpt_id)
class FilingPeriodCd(CalAccessBaseModel):
"""
An undocumented table that contains metadata for a variety
of filing periods.
"""
UNIQUE_KEY = "PERIOD_ID"
period_id = fields.IntegerField(
db_column='PERIOD_ID',
help_text="Unique period identification number"
)
start_date = fields.DateField(
db_column='START_DATE',
null=True,
help_text="Starting date for period"
)
end_date = fields.DateField(
db_column='END_DATE',
null=True,
help_text="Ending date of period"
)
PERIOD_TYPE_CHOICES = (
(1500, 'Standard period'),
(1501, 'Non-standard period'),
)
period_type = fields.IntegerField(
db_column='PERIOD_TYPE',
choices=PERIOD_TYPE_CHOICES
)
per_grp_type = fields.IntegerField(
db_column='PER_GRP_TYPE',
help_text="Period group type"
)
period_desc = fields.CharField(
max_length=255,
db_column='PERIOD_DESC',
help_text="Period description"
)
deadline = fields.DateField(
db_column='DEADLINE',
null=True,
help_text="Deadline date"
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILING_PERIOD_CD'
verbose_name = 'FILING_PERIOD_CD'
verbose_name_plural = 'FILING_PERIOD_CD'
ordering = ("-end_date",)
def __str__(self):
return str(self.period_id)
class GroupTypesCd(CalAccessBaseModel):
"""
This lookup table stores group type information.
"""
UNIQUE_KEY = "GRP_ID"
DOCUMENTCLOUD_PAGES = [
DocumentCloud(id='2711614-CalAccessTablesWeb', start_page=78, end_page=79),
]
grp_id = fields.IntegerField(
db_column='GRP_ID',
verbose_name="Group ID",
help_text="Group identification number"
)
grp_name = fields.CharField(
db_column='GRP_NAME',
max_length=28,
blank=True,
verbose_name="Group name"
)
grp_desc = fields.CharField(
db_column='GRP_DESC',
max_length=32,
blank=True,
verbose_name="Group description"
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'GROUP_TYPES_CD'
verbose_name = 'GROUP_TYPES_CD'
verbose_name_plural = 'GROUP_TYPES_CD'
def __str__(self):
return str(self.grp_id)
class LegislativeSessionsCd(CalAccessBaseModel):
"""
Legislative session, begin and end dates look up table.
"""
UNIQUE_KEY = "SESSION_ID"
session_id = fields.IntegerField(
verbose_name='session ID',
db_column='SESSION_ID',
help_text='Legislative session identification number',
null=True,
)
begin_date = fields.DateField(
db_column='BEGIN_DATE',
null=True,
help_text="Session start date"
)
end_date = fields.DateField(
db_column='END_DATE',
null=True,
help_text="Session end date"
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'LEGISLATIVE_SESSIONS_CD'
verbose_name = 'LEGISLATIVE_SESSIONS_CD'
verbose_name_plural = 'LEGISLATIVE_SESSIONS_CD'
def __str__(self):
return str(self.session_id)
class FilerAcronymsCd(CalAccessBaseModel):
"""
Links acronyms to filers
"""
UNIQUE_KEY = ("ACRONYM", "FILER_ID")
acronym = fields.CharField(
db_column='ACRONYM',
max_length=32,
help_text="AMS acronym"
)
filer_id = fields.IntegerField(
verbose_name='filer ID',
db_column='FILER_ID',
null=True,
db_index=True,
help_text="Filer's unique identification number",
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILER_ACRONYMS_CD'
verbose_name = 'FILER_ACRONYMS_CD'
verbose_name_plural = 'FILER_ACRONYMS_CD'
ordering = ("id",)
def __str__(self):
return self.acronym
class AddressCd(CalAccessBaseModel):
"""
This table holds all addresses for the system. This table can be used
for address-based searches and formes the bases for address information
desplayed by the AMS.
"""
UNIQUE_KEY = "ADRID"
DOCUMENTCLOUD_PAGES = [
DocumentCloud(id='2711614-CalAccessTablesWeb', start_page=16)
]
adrid = fields.IntegerField(
db_column="ADRID",
verbose_name="Address ID",
help_text='Address indentification number'
)
city = fields.CharField(
max_length=500,
db_column="CITY",
help_text='Address city'
)
st = fields.CharField(
max_length=500,
db_column="ST",
verbose_name='State',
help_text='Address state'
)
zip4 = fields.CharField(
db_column="ZIP4",
null=True,
max_length=10,
help_text='Address ZIP Code'
)
phon = fields.CharField(
db_column="PHON",
null=True,
max_length=20,
verbose_name='Phone',
help_text='Address phone number'
)
fax = fields.CharField(
db_column="FAX",
null=True,
max_length=20,
help_text='Address fax number'
)
email = fields.CharField(
max_length=500,
db_column="EMAIL",
help_text='Address email'
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'ADDRESS_CD'
verbose_name = 'ADDRESS_CD'
verbose_name_plural = 'ADDRESS_CD'
def __str__(self):
return str(self.adrid)
class FilerAddressCd(CalAccessBaseModel):
"""
Links filers and addresses. This table maintains a history of when
addresses change.
"""
UNIQUE_KEY = ("FILER_ID", "ADRID")
filer_id = fields.IntegerField(
verbose_name='filer ID',
db_column='FILER_ID',
null=True,
db_index=True,
help_text="Filer's unique identification number",
)
adrid = fields.IntegerField(
db_column='ADRID',
verbose_name='Address ID',
help_text="Address identification number"
)
effect_dt = fields.DateTimeField(
db_column='EFFECT_DT',
blank=True,
null=True,
help_text="Address effective date",
verbose_name='Effective date'
)
add_type = fields.IntegerField(
db_column='ADD_TYPE',
blank=True,
null=True,
verbose_name="Address type"
)
session_id = fields.IntegerField(
verbose_name='session ID',
db_column='SESSION_ID',
help_text='Legislative session identification number',
null=True,
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILER_ADDRESS_CD'
verbose_name = 'FILER_ADDRESS_CD'
verbose_name_plural = 'FILER_ADDRESS_CD'
def __str__(self):
return str(self.filer_id)
class FilerInterestsCd(CalAccessBaseModel):
"""
Links a filer to their interest codes.
"""
UNIQUE_KEY = (
"FILER_ID",
"INTEREST_CD",
"EFFECT_DATE",
"SESSION_ID"
)
filer_id = fields.IntegerField(
verbose_name='filer ID',
db_column='FILER_ID',
null=True,
db_index=True,
help_text="Filer's unique identification number",
)
session_id = fields.IntegerField(
verbose_name='session ID',
db_column='SESSION_ID',
help_text='Legislative session identification number',
null=True,
)
interest_cd = fields.IntegerField(
db_column='INTEREST_CD',
blank=True,
null=True,
verbose_name="interest code"
)
effect_date = fields.DateTimeField(
db_column='EFFECT_DATE',
null=True,
verbose_name="Effective date"
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILER_INTERESTS_CD'
verbose_name = 'FILER_INTERESTS_CD'
verbose_name_plural = 'FILER_INTERESTS_CD'
def __str__(self):
return str(self.filer_id)
class FilerTypesCd(CalAccessBaseModel):
"""
This lookup table describes filer types.
"""
UNIQUE_KEY = "FILTER_TYPE"
filer_type = fields.IntegerField(
db_column='FILER_TYPE',
help_text="Filer type identification number"
)
description = fields.CharField(
max_length=255,
db_column='DESCRIPTION',
help_text="Description of the filer type"
)
grp_type = fields.IntegerField(
null=True,
db_column='GRP_TYPE',
blank=True,
help_text="Group type assocated with the filer type"
)
calc_use = fields.CharField(
max_length=1,
db_column='CALC_USE',
blank=True,
help_text="Use checkbox flag"
)
grace_period = fields.CharField(
max_length=12,
db_column='GRACE_PERIOD',
blank=True,
help_text="This field is undocumented"
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILER_TYPES_CD'
verbose_name = 'FILER_TYPES_CD'
verbose_name_plural = 'FILER_TYPES_CD'
ordering = ("filer_type",)
def __str__(self):
return str(self.filer_type)
class BallotMeasuresCd(CalAccessBaseModel):
"""
Ballot measure dates and times
"""
UNIQUE_KEY = "FILER_ID"
election_date = fields.DateTimeField(
db_column='ELECTION_DATE',
null=True,
help_text="Ballot measure election date"
)
filer_id = fields.IntegerField(
verbose_name='filer ID',
db_column='FILER_ID',
null=True,
db_index=True,
help_text="Filer's unique identification number",
)
measure_no = fields.CharField(
db_column='MEASURE_NO',
max_length=2,
help_text="Ballot measure number"
)
measure_name = fields.CharField(
db_column='MEASURE_NAME',
max_length=163,
help_text="Ballot measure full name"
)
measure_short_name = fields.CharField(
db_column='MEASURE_SHORT_NAME',
max_length=50,
blank=True,
help_text="Ballot measure short name"
)
jurisdiction = fields.CharField(
db_column='JURISDICTION',
max_length=9,
help_text="This field is undocumented"
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'BALLOT_MEASURES_CD'
verbose_name = 'BALLOT_MEASURES_CD'
verbose_name_plural = 'BALLOT_MEASURES_CD'
ordering = (
"-election_date",
"measure_no",
"measure_short_name",
"measure_name"
)
def __str__(self):
return self.measure_name
class FilerTypePeriodsCd(CalAccessBaseModel):
"""
This table and its fields are listed in the official CAL-ACCESS documentation,
but is not fully explained. The table's description contains this note: "J M needs
to document. This is in his list of tables designed for future enhancements."
"""
UNIQUE_KEY = (
"ELECTION_TYPE",
"FILER_TYPE",
"PERIOD_ID",
)
DOCUMENTCLOUD_PAGES = [
DocumentCloud(id='2711614-CalAccessTablesWeb', start_page=8),
DocumentCloud(id='2711614-CalAccessTablesWeb', start_page=71),
]
election_type = fields.IntegerField(
db_column="ELECTION_TYPE",
db_index=True,
help_text="Election type"
)
filer_type = fields.IntegerField(
db_column="FILER_TYPE",
db_index=True,
help_text="Filer type identification number."
)
period_id = fields.IntegerField(
db_column="PERIOD_ID",
db_index=True,
help_text="Period identification number."
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILER_TYPE_PERIODS'
verbose_name = 'FILER_TYPE_PERIODS'
verbose_name_plural = 'FILER_TYPE_PERIODS'
def __str__(self):
return str(self.filer_type)
class ImageLinksCd(CalAccessBaseModel):
"""
This table links images to filers and accounts.
"""
UNIQUE_KEY = ("IMG_LINK_ID", "IMG_ID")
img_link_id = fields.IntegerField(
db_column='IMG_LINK_ID',
verbose_name="Image link ID",
help_text="Image link identification number"
)
img_link_type = fields.IntegerField(
db_column='IMG_LINK_TYPE',
verbose_name="Image link type"
)
img_id = fields.IntegerField(
db_column='IMG_ID',
verbose_name="Image ID",
help_text="Image identification number"
)
img_type = fields.IntegerField(
db_column='IMG_TYPE',
verbose_name="Image type"
)
img_dt = fields.DateField(
db_column='IMG_DT',
null=True,
verbose_name="Image date"
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'IMAGE_LINKS_CD'
verbose_name = 'IMAGE_LINKS_CD'
verbose_name_plural = 'IMAGE_LINKS_CD'
def __str__(self):
return str(self.img_link_id)
class FilersCd(CalAccessBaseModel):
"""
This table is the parent table from which all links and associations
to a filer are derived.
"""
UNIQUE_KEY = "FILER_ID"
filer_id = fields.IntegerField(
verbose_name='filer ID',
db_column='FILER_ID',
null=True,
db_index=True,
help_text="Filer's unique identification number",
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILERS_CD'
verbose_name = 'FILERS_CD'
verbose_name_plural = 'FILERS_CD'
def __str__(self):
return str(self.filer_id)
class FilerXrefCd(CalAccessBaseModel):
"""
This table maps legacy filer identification numbers to the system's filer
identification numbers.
"""
UNIQUE_KEY = ("FILER_ID", "XREF_ID")
filer_id = fields.IntegerField(
verbose_name='filer ID',
db_column='FILER_ID',
null=True,
db_index=True,
help_text="Filer's unique identification number",
)
xref_id = fields.CharField(
verbose_name='crossreference filer ID',
max_length=32,
db_column='XREF_ID',
db_index=True,
help_text="Alternative filer ID found on many forms"
)
effect_dt = fields.DateField(
db_column='EFFECT_DT',
null=True,
verbose_name="Effective date"
)
migration_source = fields.CharField(
max_length=50,
db_column='MIGRATION_SOURCE',
help_text="Source of the XREF_ID. Migration or generated by the AMS."
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILER_XREF_CD'
verbose_name = 'FILER_XREF_CD'
verbose_name_plural = 'FILER_XREF_CD'
def __str__(self):
return str(self.filer_id)
class TextMemoCd(CalAccessBaseModel):
"""
Text memos attached to electronic filings
"""
UNIQUE_KEY = ("FILING_ID", "AMEND_ID", "LINE_ITEM", "REC_TYPE",
"FORM_TYPE")
filing_id = fields.IntegerField(
db_column='FILING_ID',
db_index=True,
verbose_name='filing ID',
help_text="Unique filing identificiation number")
amend_id = fields.IntegerField(
db_column='AMEND_ID',
db_index=True,
help_text="Amendment identification number. A number of 0 is the \
original filing and 1 to 999 amendments.",
verbose_name="amendment ID")
line_item = fields.IntegerField(
db_column='LINE_ITEM',
help_text="Line item number of this record",
db_index=True,
)
REC_TYPE_CHOICES = (
('i', 'i'),
('MEMO', 'MEMO'),
('TEXT', 'TEXT'),
('trun', 'trun'),
('Unde', 'Unde'),
)
rec_type = fields.CharField(db_column='REC_TYPE',
max_length=4,
db_index=True,
choices=REC_TYPE_CHOICES,
verbose_name='record type')
FORM_TYPE_CHOICES = (
(' E', ''),
('410', ''),
('460', ''),
('461', ''),
('465', ''),
('496', ''),
('497', ''),
('497P1', ''),
('497P2', ''),
('A', ''),
('A4', ''),
('A6', ''),
('B', ''),
('B1', ''),
('B2', ''),
('B3', ''),
('C', ''),
('COMMENTS', ''),
('CVR', ''),
('D', ''),
('DEBTF', ''),
('E', ''),
('EXPNT', ''),
('F', ''),
('F401', ''),
('F401A', ''),
('F401B', ''),
('F401B-1', ''),
('F405', ''),
('F410', ''),
('F425', ''),
('F450', ''),
('F450P5', ''),
('F460', ''),
('F461', ''),
('F461P1', ''),
('F461P2', ''),
('F461P5', ''),
('F465', ''),
('F465P3', ''),
('F496', ''),
('F496P3', ''),
('F497', ''),
('F497P1', ''),
('F497P2', ''),
('F498-A', ''),
('F498-R', ''),
('F601', ''),
('F601P2A', ''),
('F601P2B', ''),
('F602', ''),
('F603', ''),
('F604', ''),
('F605', ''),
('F606', ''),
('F607', ''),
('F615', ''),
('F615P1', ''),
('F615P2', ''),
('F625', ''),
('F625P2', ''),
('F625P3A', ''),
('F625P3B', ''),
('F625P4B', ''),
('F635', ''),
('F635P3B', ''),
('F635P3C', ''),
('F635P4B', ''),
('F645', ''),
('F645P2A', ''),
('F645P3B', ''),
('G', ''),
('H', ''),
('H1', ''),
('H2', ''),
('H3', ''),
('I', ''),
('PT5', ''),
('RCPTB1', ''),
('RCPTC', ''),
('RCPTI', ''),
('S497', ''),
('S630', ''),
('S635-C', ''),
('S635C', ''),
('S640', ''),
('SCH A', ''),
('SF', ''),
('SMRY', ''),
('SPLT', ''),
('SUM', ''),
('SUMMARY', ''),
)
form_type = fields.CharField(
db_column='FORM_TYPE',
max_length=8,
help_text='Name of the source filing form or schedule',
db_index=True,
choices=FORM_TYPE_CHOICES)
ref_no = fields.CharField(db_column='REF_NO',
max_length=20,
blank=True,
help_text='Links text memo to a specific record',
verbose_name='reference number')
text4000 = fields.CharField(db_column='TEXT4000',
max_length=4000,
blank=True,
help_text='Contents of the text memo',
verbose_name='text')
class Meta:
app_label = 'calaccess_raw'
db_table = 'TEXT_MEMO_CD'
verbose_name = 'TEXT_MEMO_CD'
verbose_name_plural = 'TEXT_MEMO_CD'
def __str__(self):
return str(self.filing_id)
class FilerFilingsCd(CalAccessBaseModel):
"""
Key table that links filers to their paper, key data entry, legacy,
and electronic filings. This table is used as an index to locate
filing information.
"""
UNIQUE_KEY = ("FILER_ID", "FILING_ID", "FORM_ID", "FILING_SEQUENCE")
DOCUMENTCLOUD_PAGES = [
DocumentCloud(id='2711614-CalAccessTablesWeb',
start_page=61,
end_page=62),
]
filer_id = fields.IntegerField(
verbose_name='filer ID',
db_column='FILER_ID',
db_index=True,
null=True,
help_text="Filer's unique identification number")
filing_id = fields.IntegerField(
db_column='FILING_ID',
db_index=True,
verbose_name='filing ID',
help_text="Unique filing identificiation number")
period_id = fields.IntegerField(
null=True,
db_column='PERIOD_ID',
blank=True,
help_text="Identifies the period when the filing was recieved.")
FORM_ID_CHOICES = (
('E530', ''),
('F111', ''),
('F400', ''),
('F401', ''),
('F402', ''),
('F405', ''),
('F410', ''),
('F410 AT', ''),
('F410ATR', ''),
('F415', ''),
('F416', ''),
('F419', ''),
('F420', ''),
('F421', ''),
('F425', ''),
('F430', ''),
('F440', ''),
('F450', ''),
('F460', ''),
('F461', ''),
('F465', ''),
('F470', ''),
('F470S', ''),
('F480', ''),
('F490', ''),
('F495', ''),
('F496', ''),
('F497', ''),
('F498', ''),
('F500', ''),
('F501', ''),
('F501502', ''),
('F502', ''),
('F555', ''),
('F601', ''),
('F602', ''),
('F603', ''),
('F604', ''),
('F605', ''),
('F606', ''),
('F607', ''),
('F615', ''),
('F625', ''),
('F635', ''),
('F645', ''),
('F666', ''),
('F690', ''),
('F700', ''),
('F777', ''),
('F888', ''),
('F900', ''),
('F999', ''),
)
form_id = fields.CharField(max_length=7,
db_column='FORM_ID',
db_index=True,
verbose_name='form type',
choices=FORM_ID_CHOICES,
help_text="Form identification code")
filing_sequence = fields.IntegerField(
db_column='FILING_SEQUENCE',
db_index=True,
help_text="Amendment number where 0 is an original filing and 1 to \
999 are amendments")
filing_date = fields.DateField(
db_column='FILING_DATE',
help_text="Date the filing entered into the system",
null=True)
STATEMENT_TYPE_CHOICES = (
(0, ''),
(10001, ''),
(10002, ''),
(10003, ''),
(10004, ''),
(10005, ''),
(10006, ''),
(10007, ''),
)
stmnt_type = fields.IntegerField(db_column='STMNT_TYPE',
verbose_name="statement type",
db_index=True,
choices=STATEMENT_TYPE_CHOICES,
help_text="Type of statement")
STATEMENT_STATUS_CHOICES = (
(0, ''),
(11001, ''),
(11002, ''),
(11003, ''),
)
stmnt_status = fields.IntegerField(
db_column='STMNT_STATUS',
db_index=True,
null=True,
help_text="The status of the statement. If the filing has been \
reviewed or not reviewed.",
verbose_name='statement status',
choices=STATEMENT_STATUS_CHOICES,
)
session_id = fields.IntegerField(
verbose_name='session ID',
db_column='SESSION_ID',
help_text='Legislative session identification number',
null=True,
)
user_id = fields.CharField(
max_length=12,
db_column='USER_ID',
verbose_name="User ID",
help_text="User identifier of the PRD user who logged the filing")
special_audit = fields.IntegerField(
null=True,
db_column='SPECIAL_AUDIT',
blank=True,
help_text="Denotes whether the filing has been audited for money \
laundering or other special condition.")
fine_audit = fields.IntegerField(
null=True,
db_column='FINE_AUDIT',
blank=True,
help_text="Indicates whether a filing has been audited for a fine")
rpt_start = fields.DateField(
null=True,
db_column='RPT_START',
blank=True,
help_text="Starting date for the period the filing represents",
)
rpt_end = fields.DateField(
null=True,
db_column='RPT_END',
blank=True,
help_text="Ending date for the period the filing represents",
)
rpt_date = fields.DateField(
null=True,
db_column='RPT_DATE',
blank=True,
help_text="Date filing received",
)
FILING_TYPE_CHOICES = (
(0, '0 (Unknown)'),
(22001, 'Electronic'),
(22006, 'Cal Online'),
)
filing_type = fields.IntegerField(db_column='FILING_TYPE',
null=True,
blank=True,
choices=FILING_TYPE_CHOICES,
help_text="The type of filing")
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILER_FILINGS_CD'
verbose_name = 'FILER_FILINGS_CD'
verbose_name_plural = 'FILER_FILINGS_CD'
def __str__(self):
return str("%s %s" % (self.filer_id, self.filing_id))
class HdrCd(CalAccessBaseModel):
"""
Electronic filing record header data
"""
UNIQUE_KEY = ("FILING_ID", "AMEND_ID")
amend_id = fields.IntegerField(
db_column='AMEND_ID',
db_index=True,
help_text="Amendment identification number. A number of 0 is the \
original filing and 1 to 999 amendments.",
verbose_name="amendment ID")
cal_ver = fields.CharField(
max_length=4,
db_column='CAL_VER',
blank=True,
help_text="CAL Version number the filing was made using")
ef_type = fields.CharField(
max_length=3,
db_column='EF_TYPE',
blank=True,
help_text='Electronic filing type. This will always have the \
value of "CAL".')
filing_id = fields.IntegerField(
db_column='FILING_ID',
db_index=True,
verbose_name='filing ID',
help_text="Unique filing identificiation number")
hdr_comment = fields.CharField(
max_length=200,
db_column='HDRCOMMENT',
blank=True,
verbose_name="Header comment",
help_text="Typically used for development and test filings")
REC_TYPE_CHOICES = (("HDR", "HDR"), )
rec_type = fields.CharField(
verbose_name='record type',
db_column='REC_TYPE',
max_length=4,
db_index=True,
choices=REC_TYPE_CHOICES,
)
soft_name = fields.CharField(
max_length=90,
db_column='SOFT_NAME',
blank=True,
help_text="Filing software name used to electronically file")
soft_ver = fields.CharField(max_length=16,
db_column='SOFT_VER',
blank=True,
help_text="Filing software version number")
state_cd = fields.CharField(
max_length=2,
db_column='STATE_CD',
blank=True,
verbose_name='State code',
help_text="The state code value entered in the electronic filing")
class Meta:
app_label = 'calaccess_raw'
db_table = 'HDR_CD'
verbose_name = 'HDR_CD'
verbose_name_plural = 'HDR_CD'
def __str__(self):
return str(self.filing_id)
class HeaderCd(CalAccessBaseModel):
"""
Lookup table used to report form 460 information in the AMS.
"""
UNIQUE_KEY = ("LINE_NUMBER", "FORM_ID", "REC_TYPE")
line_number = fields.IntegerField(db_column='LINE_NUMBER',
help_text="This field is undocumented")
form_id = fields.CharField(db_column='FORM_ID',
max_length=5,
help_text="Form identification code",
verbose_name="Form ID")
REC_TYPE_CHOICES = (
("AP1", "AP1"),
("AP2", "AP2"),
("SMRY_HEADER", "SMRY_HEADER"),
)
rec_type = fields.CharField(
verbose_name='record type',
db_column='REC_TYPE',
max_length=11,
db_index=True,
choices=REC_TYPE_CHOICES,
)
section_label = fields.CharField(db_column='SECTION_LABEL',
max_length=58,
blank=True,
help_text="This field is undocumented")
comments1 = fields.CharField(db_column='COMMENTS1',
max_length=48,
blank=True,
help_text="This field is undocumented")
comments2 = fields.CharField(db_column='COMMENTS2',
max_length=48,
blank=True,
help_text="This field is undocumented")
label = fields.CharField(db_column='LABEL',
max_length=98,
help_text="This field is undocumented")
column_a = fields.IntegerField(db_column='COLUMN_A',
blank=True,
null=True,
help_text="This field is undocumented")
column_b = fields.IntegerField(db_column='COLUMN_B',
blank=True,
null=True,
help_text="This field is undocumented")
column_c = fields.IntegerField(db_column='COLUMN_C',
blank=True,
null=True,
help_text="This field is undocumented")
show_c = fields.IntegerField(db_column='SHOW_C',
blank=True,
null=True,
help_text="This field is undocumented")
show_b = fields.IntegerField(db_column='SHOW_B',
blank=True,
null=True,
help_text="This field is undocumented")
class Meta:
app_label = 'calaccess_raw'
db_table = 'HEADER_CD'
verbose_name = 'HEADER_CD'
verbose_name_plural = 'HEADER_CD'
def __str__(self):
return str(self.form_id)
class SmryCd(CalAccessBaseModel):
"""
Summary totals from filings.
"""
UNIQUE_KEY = (
"FILING_ID",
"AMEND_ID",
"LINE_ITEM",
"REC_TYPE",
"FORM_TYPE",
)
DOCUMENTCLOUD_PAGES = [
DocumentCloud(id='2711614-CalAccessTablesWeb',
start_page=131,
end_page=132),
]
filing_id = fields.IntegerField(
db_column='FILING_ID',
db_index=True,
verbose_name='filing ID',
help_text="Unique filing identificiation number")
amend_id = fields.IntegerField(
db_column='AMEND_ID',
db_index=True,
help_text="Amendment identification number. A number of 0 is the \
original filing and 1 to 999 amendments.",
verbose_name="amendment ID")
line_item = fields.CharField(max_length=8,
db_column='LINE_ITEM',
db_index=True,
help_text="Line item number of this record")
REC_TYPE_CHOICES = (('SMRY', 'SMRY'), )
rec_type = fields.CharField(
max_length=4,
db_column='REC_TYPE',
db_index=True,
choices=REC_TYPE_CHOICES,
verbose_name='record type',
)
FORM_TYPE_CHOICES = (
('401A', 'Form 401 (Slate mailer organization campaign statement): \
Schedule A, payments received'),
('401B', 'Form 401 (Slate mailer organization campaign statement): \
Schedule B, payments made'),
('401B-1', 'Form 401 (Slate mailer organization campaign statement): \
Schedule B1, payments made by agent or independent contractor'),
('A', 'Form 460 (Recipient committee campaign statement): \
Schedule A, '),
('B1', 'Form 460 (Recipient committee campaign statement): \
Schedule B1, '),
('B2', 'Form 460 (Recipient committee campaign statement): \
Schedule B2, '),
('B3', 'Form 460 (Recipient committee campaign statement): \
Schedule B3, '),
('C', 'Form 460 (Recipient committee campaign statement): \
Schedule C, '),
('D', 'Form 460 (Recipient committee campaign statement): \
Schedule D, '),
('E', 'Form 460 (Recipient committee campaign statement): \
Schedule E, '),
('F', 'Form 460 (Recipient committee campaign statement): \
Schedule F, '),
('G', 'Form 460 (Recipient committee campaign statement): \
Schedule G, '),
('H', 'Form 460 (Recipient committee campaign statement): \
Schedule H, '),
('H1', 'Form 460 (Recipient committee campaign statement): \
Schedule H1, '),
('H2', 'Form 460 (Recipient committee campaign statement): \
Schedule H2, '),
('H3', 'Form 460 (Recipient committee campaign statement): \
Schedule H3, '),
('I', 'Form 460 (Recipient committee campaign statement): \
Schedule I, '),
('F401', 'Form 401 (Slate mailer organization campaign statement)'),
('F450', 'Form 450 (Recipient committee campaign statement, \
short form)'),
('F460', 'Form 460 (Recipient committee campaign statement)'),
('F461', 'Form 461 (Independent expenditure and major donor \
committee campaign statement)'),
('F465', 'Form 465 ()'),
('F625', 'Form 625 (Report of lobbying firm)'),
('F625P2', 'Form 625 (Report of lobbying firm): \
Part 2, payments received in connection with lobbying activity'),
('F625P3A', 'Form 625 (Report of lobbying firm): \
Part 3A, payments for activity expenses made in connection with \
lobbying activities'),
('F625P3B', 'Form 625 (Report of lobbying firm): \
Part 3B, payments to other lobbying firms made in connection with \
lobbying activities'),
('F635', 'Form 635 (Report of lobbyist employer and lobbying \
coalition)'),
('F635P3A', 'Form 635 (Report of lobbyist employer and lobbying \
coalition): Part 3A, payments in in-house employee lobbyists'),
('F635P3B', 'Form 635 (Report of lobbyist employer and lobbying \
coalition): Part 3B, payments to lobbying firms'),
('F635P3C', 'Form 635 (Report of lobbyist employer and lobbying \
coalition): Part 3C, activity expenses'),
('F635P3D', 'Form 635 (Report of lobbyist employer and lobbying \
coalition): Part 3D, other payments to influence legislative or \
administrative action'),
('F635P3E', 'Form 635 (Report of lobbyist employer and lobbying \
coalition): Part 3E, payments in connection with administrative testimony \
in ratemaking proceedings before the California Public Utilities Commission'),
('F645', 'Form 645 (Report of person spending $5,000 or more to \
influence legislative or administrative action)'),
('F645P2A', 'Form 645 (Report of person spending $5,000 or more to \
influence legislative or administrative action): Part 2A, activity expenses'),
('F645P2B', 'Form 645 (Report of person spending $5,000 or more to \
influence legislative or administrative action): Part 2B, \
other payments to influence legislative or administrative action'),
('F645P2C', 'Form 645 (Report of person spending $5,000 or more to \
influence legislative or administrative action): Part 2C, \
payments in connection with administrative testimony in ratemaking \
proceedings before the California Public Utilities Commission'),
('F900', 'Form 900 (Form 900 (Public Employee\'s Retirement Board \
Candidate Campaign Statement)'),
('S640', 'Form 640 (Governmental agencies reporting ther payments to \
influence legislative or administrative action attachment)'),
)
form_type = fields.CharField(
max_length=8,
db_column='FORM_TYPE',
db_index=True,
choices=FORM_TYPE_CHOICES,
help_text='Name of the source filing form or schedule')
amount_a = fields.DecimalField(decimal_places=2,
null=True,
max_digits=14,
db_column='AMOUNT_A',
blank=True,
help_text='Summary amount from column A',
verbose_name='amount A')
amount_b = fields.DecimalField(decimal_places=2,
null=True,
max_digits=14,
db_column='AMOUNT_B',
blank=True,
help_text='Summary amount from column B',
verbose_name='amount B')
amount_c = fields.DecimalField(decimal_places=2,
null=True,
max_digits=14,
db_column='AMOUNT_C',
blank=True,
help_text='Summary amount from column C',
verbose_name='amount C')
elec_dt = fields.DateField(db_column='ELEC_DT',
null=True,
blank=True,
verbose_name='election date')
class Meta:
app_label = 'calaccess_raw'
db_table = 'SMRY_CD'
verbose_name = 'SMRY_CD'
verbose_name_plural = 'SMRY_CD'
ordering = ("filing_id", "-amend_id", 'form_type', "line_item")
def __str__(self):
return str(self.filing_id)
def pretty_amount_a(self):
if self.amount_a is None:
return None
return "$%s" % intcomma(floatformat(self.amount_a, 0))
pretty_amount_a.short_description = 'amount A'
def pretty_amount_b(self):
if self.amount_b is None:
return None
return "$%s" % intcomma(floatformat(self.amount_b, 0))
pretty_amount_b.short_description = 'amount B'
def pretty_amount_c(self):
if self.amount_c is None:
return None
return "$%s" % intcomma(floatformat(self.amount_c, 0))
pretty_amount_c.short_description = 'amount C'
class FilerToFilerTypeCd(CalAccessBaseModel):
"""
This table links a filer to a set of characteristics that describe the
filer. This table maintains a history of changes and allows the filer
to change characteristics over time.
"""
UNIQUE_KEY = (
"FILER_ID",
"FILER_TYPE",
"SESSION_ID",
"EFFECT_DT"
)
filer_id = fields.IntegerField(
verbose_name='filer ID',
null=True,
db_index=True,
help_text="Filer's unique identification number",
db_column='FILER_ID',
)
filer_type = fields.IntegerField(
help_text="Filer type identification number",
db_column='FILER_TYPE',
)
active = fields.CharField(
max_length=1,
help_text="Indicates if the filer is currently active",
db_column='ACTIVE',
)
race = fields.IntegerField(
null=True,
blank=True,
help_text="If applicable indicates the race in which the filer is \
running",
db_column='RACE',
)
session_id = fields.IntegerField(
verbose_name='session ID',
db_column='SESSION_ID',
help_text='Legislative session identification number',
null=True,
)
category = fields.IntegerField(
null=True,
blank=True,
help_text="Defines the filer's category such as controlled, jointly \
controlled, etc. (subset of filer's type)",
db_column='CATEGORY',
)
category_type = fields.IntegerField(
null=True,
blank=True,
help_text="When applicable, the category type specifies additional \
information about the category. (e.g. state, local, etc.)",
db_column='CATEGORY_TYPE',
)
sub_category = fields.IntegerField(
null=True,
blank=True,
help_text="When applicable specifies general purpose, primarily \
formed, etc.",
db_column='SUB_CATEGORY',
)
effect_dt = fields.DateField(
null=True,
help_text="The date the filer assumed the current class or type",
db_column='EFFECT_DT',
)
sub_category_type = fields.IntegerField(
null=True,
blank=True,
help_text="When applicable specifies broad based or small contributor",
db_column='SUB_CATEGORY_TYPE',
)
election_type = fields.IntegerField(
null=True,
blank=True,
help_text="Indicates type of election (general, primary, special)",
db_column='ELECTION_TYPE',
)
sub_category_a = fields.CharField(
max_length=1,
blank=True,
help_text="Indicates if sponsored or not",
db_column='SUB_CATEGORY_A',
)
nyq_dt = fields.DateField(
null=True,
blank=True,
help_text="Indicates the date when a committee reached its qualifying \
level of activity",
db_column='NYQ_DT',
)
PARTY_CODE_CHOICES = (
(16001, 'DEMOCRATIC'),
(16002, 'REPUBLICAN'),
(16003, 'GREEN PARTY'),
(16004, 'REFORM PARTY'),
(16005, 'AMERICAN INDEPENDENT PARTY'),
(16006, 'PEACE AND FREEDOM'),
(16007, 'INDEPENDENT'),
(16008, 'LIBERTARIAN'),
(16009, 'NON PARTISAN'),
(16010, 'NATURAL LAW'),
(16011, 'UNKNOWN'),
(16012, 'NO PARTY PREFERENCE'),
(16013, 'AMERICANS ELECT'),
# The codes below occur in the database but are
# undocumented in the lookup table
(16020, 'UNKNOWN'),
(16014, 'UNKNOWN'),
(0, 'UNKNOWN'),
(None, 'NONE'),
)
party_cd = fields.IntegerField(
null=True,
blank=True,
help_text="Filer's political party",
db_column='PARTY_CD',
choices=PARTY_CODE_CHOICES,
)
county_cd = fields.IntegerField(
null=True,
blank=True,
help_text="Filer's county code",
db_column='COUNTY_CD',
)
district_cd = fields.IntegerField(
null=True,
blank=True,
help_text="Filer's district number for the office being sought. \
Populated for Senate, Assembly or Board of Equalization races",
db_column='DISTRICT_CD',
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILER_TO_FILER_TYPE_CD'
verbose_name = 'FILER_TO_FILER_TYPE_CD'
verbose_name_plural = 'FILER_TO_FILER_TYPE_CD'
def __str__(self):
return str(self.filer_id)
class CvrE530Cd(CalAccessBaseModel):
"""
This table method is undocumented.
"""
UNIQUE_KEY = ("FILING_ID", "AMEND_ID")
filing_id = fields.IntegerField(
db_column='FILING_ID',
db_index=True,
verbose_name='filing ID',
help_text="Unique filing identificiation number")
DOCUMENTCLOUD_PAGES = [
DocumentCloud(id='2711614-CalAccessTablesWeb',
start_page=29,
end_page=30),
]
amend_id = fields.IntegerField(
db_column='AMEND_ID',
db_index=True,
help_text="Amendment identification number. A number of 0 is the \
original filing and 1 to 999 amendments.",
verbose_name="amendment ID")
REC_TYPE_CHOICES = (("CVR", "CVR"), )
rec_type = fields.CharField(
verbose_name='record type',
db_column='REC_TYPE',
max_length=4,
db_index=True,
choices=REC_TYPE_CHOICES,
)
FORM_TYPE_CHOICES = (('E530', 'Form 530 (Issue advocacy report)'), )
form_type = fields.CharField(
db_column='FORM_TYPE',
max_length=4,
db_index=True,
help_text='Name of the source filing form or schedule',
choices=FORM_TYPE_CHOICES,
)
ENTITY_CODE_CHOICES = (
# Defined here:
# http://www.documentcloud.org/documents/1308003-cal-access-cal-format.html#document/p9
('', 'Unknown'), )
entity_cd = fields.CharField(db_column='ENTITY_CD',
max_length=32,
blank=True,
verbose_name='entity code',
choices=ENTITY_CODE_CHOICES)
filer_naml = fields.CharField(db_column='FILER_NAML',
max_length=200,
help_text="Filer last name")
filer_namf = fields.CharField(db_column='FILER_NAMF',
max_length=4,
blank=True,
help_text="Filer first name")
filer_namt = fields.CharField(db_column='FILER_NAMT',
max_length=32,
blank=True,
help_text="Filer title or prefix")
filer_nams = fields.CharField(db_column='FILER_NAMS',
max_length=32,
blank=True,
help_text="Filer suffix")
report_num = fields.CharField(db_column='REPORT_NUM',
max_length=32,
blank=True,
help_text="This field is undocumented")
rpt_date = fields.DateField(db_column='RPT_DATE',
null=True,
help_text="This field is undocumented")
filer_city = fields.CharField(db_column='FILER_CITY',
max_length=16,
blank=True,
help_text='Filer city')
filer_st = fields.CharField(db_column='FILER_ST',
max_length=4,
blank=True,
verbose_name='Filer state')
filer_zip4 = fields.CharField(db_column='FILER_ZIP4',
max_length=10,
blank=True,
help_text='Filer ZIP Code')
occupation = fields.CharField(db_column='OCCUPATION',
max_length=15,
blank=True,
help_text="This field is undocumented")
employer = fields.CharField(db_column='EMPLOYER',
max_length=13,
blank=True,
help_text="This field is undocumented")
cand_naml = fields.CharField(db_column='CAND_NAML',
max_length=46,
help_text="Candidate last name")
cand_namf = fields.CharField(db_column='CAND_NAMF',
max_length=21,
blank=True,
help_text="Candidate first name")
cand_namt = fields.CharField(db_column='CAND_NAMT',
max_length=32,
blank=True,
help_text="Candidate title or prefix")
cand_nams = fields.CharField(db_column='CAND_NAMS',
max_length=32,
blank=True,
help_text="Candidate suffix")
district_cd = fields.IntegerField(db_column='DISTRICT_CD',
help_text="This field is undocumented")
OFFICE_CODE_CHOICES = (
(30001, "PRESIDENT"),
(30002, "GOVERNOR"),
(30003, "LIEUTENANT GOVERNOR"),
(30004, "SECRETARY OF STATE"),
(30005, "CONTROLLER"),
(30006, "TREASURER"),
(30007, "ATTORNEY GENERAL"),
(30008, "SUPERINTENDENT OF PUBLIC INSTRUCTION"),
(30009, "MEMBER BOARD OF EQUALIZATION"),
(30010, "OXNARD HARBOR COMMISSIONER"),
(30011, "CITY CONTROLLER"),
(30012, "STATE SENATE"),
(30013, "ASSEMBLY"),
(30014, "INSURANCE COMMISSIONER"),
(30015, "JUDGE"),
(30016, "BOARD MEMBER"),
(30017, "TAX COLLECTOR"),
(30018, "TRUSTEE"),
(30019, "SUPERVISOR"),
(30020, "SHERIFF"),
(30021, "CORONER"),
(30022, "MARSHALL"),
(30023, "CITY CLERK"),
(30024, "SCHOOL BOARD"),
(30025, "HARBOR COMMISSIONER"),
(30026, "DISTRICT ATTORNEY"),
(30027, "COUNTY CLERK"),
(30028, "AUDITOR"),
(30029, "MAYOR"),
(30030, "CITY ATTORNEY"),
(30031, "DEMOCRATIC COUNTY CENTRAL COMMITTEE"),
(30032, "TOWN COUNCIL"),
(30033, "ASSESSOR"),
(30034, "CITY TREASURER"),
(30035, "CITY COUNCIL"),
(30036, "COMMISSIONER"),
(30037, "REPUBLICAN COUNTY CENTRAL COMMITTEE"),
(30038, "DIRECTOR"),
(30039, "DIRECTOR OF ZONE 7"),
(30040, "COMMUNITY COLLEGE BOARD"),
(30041, "POLICE CHIEF"),
(30042, "CHIEF OF POLICE"),
(30043, "CENTRAL COMMITTEE"),
(30044, "BOARD OF EDUCATION"),
(30045, "BOARD OF DIRECTORS"),
(30046, "COLLEGE BOARD"),
(30047, "BART BOARD DIRECTOR"),
(30048, "BOARD OF TRUSTEES"),
(30049, "IRRIGATION"),
(30050, "WATER BOARD"),
(30051, "COMMUNITY PLANNING GROUP"),
(30052, "BOARD OF SUPERVISORS"),
(30053, "SUPERIOR COURT JUDGE"),
(30054, "DISTRICT ATTORNEY/PUBLIC DEFENDER"),
(30055, "MEASURE"),
(30056, "CITY PROSECUTOR"),
(30057, "SUPREME COURT JUDGE"),
(30058, "PUBLIC EMPLOYEES RETIREMENT BOARD"),
(30059, "APPELLATE COURT JUDGE"),
(50001, "Ag"),
(50002, "Assembly"),
(50003, "Assessor"),
(50004, "Assessor/Clerk/Recorder"),
(50005, "Assessor/County Clerk/Recorder"),
(50006, "Assessor/Recorder"),
(50007, "Associate Justice"),
(50008, "Auditor"),
(50009, "Auditor/Controller"),
(50010, "Auditor/Controller/Clerk/Recorder"),
(50011, "Auditor/Controller/Recorder"),
(50012, "Auditor/Controller/Treasurer/Tax Collector"),
(50013, "Auditor/Recorder"),
(50014, "Board Member"),
(50015, "Board Of Director"),
(50016, "Board Of Supervisor"),
(50017, "Boe"),
(50018, "Chief Justice"),
(50019, "City"),
(50020, "City Attorney"),
(50021, "City Auditor"),
(50022, "City Clerk"),
(50023, "City Council"),
(50024, "City Of Los Angeles"),
(50025, "City Of South El Monte"),
(50026, "City Prosecutor"),
(50027, "City Treasurer"),
(50028, "Clerk/Auditor"),
(50029, "Clerk/Record/Public Admin"),
(50030, "Clerk/Recorder"),
(50031, "Clerk/Recorder/Registar"),
(50032, "Clerk/Recorder/Registrar"),
(50033, "Commissioner"),
(50034, "Controller"),
(50035, "Costa Mesa"),
(50036, "Council Member"),
(50037, "County Clerk"),
(50038, "County Clerk/Auditor"),
(50039, "County Clerk/Auditor/Controller"),
(50040, "County Clerk/Recorder"),
(50041, "County Clerk/Recorder/Assessor"),
(50042, "County Clerk/Recorder/Public Admin"),
(50043, "Democratic County Central Committee"),
(50044, "Director"),
(50045, "District Attorney"),
(50046, "District Attorney/Public Administrator"),
(50047, "Gccc"),
(50048, "Governor"),
(50049, "Harbor Commissioner"),
(50050, "Ic"),
(50051, "Irrigation Dist"),
(50052, "Judge"),
(50053, "Justice"),
(50054, "Legislature"),
(50055, "Lieutenant Governor"),
(50056, "Mayor"),
(50057, "N/A"),
(50058, "Placentia"),
(50059, "Public Administrator"),
(50060, "Public Administrator/Guardian"),
(50061, "Rent Stabilization Board"),
(50062, "Republican Central Committee"),
(50063, "San Francisco Dccc"),
(50064, "Sanger"),
(50065, "School Board"),
(50066, "Secretary Of State"),
(50067, "Senator"),
(50068, "Sheriff"),
(50069, "Sheriff/Coroner"),
(50070, "Sheriff/Coroner/Marshall"),
(50071, "Sheriff/Coroner/Public Administrator"),
(50072, "Solana Beach"),
(50073, "Superintendent"),
(50074, "Supervisor"),
(50075, "Supt Of Schools"),
(50076, "Tax Collector"),
(50077, "Town Council"),
(50078, "Treasurer"),
(50079, "Treasurer/Tax Collector"),
(50080, "Treasurer/Tax Collector/Clerk"),
(50081, "Treasurer/Tax Collector/Public Administrator"),
(50082, "Treasurer/Tax Collector/Public Administrator/County Clerk"),
(50083, "Treasurer/Tax Collector/Recorder"),
(50084, "Trustee"),
(50085, "Weed Recreation Board Member"),
)
office_cd = fields.IntegerField(
db_column='OFFICE_CD',
verbose_name="office code",
help_text="Identifies the office being sought",
choices=OFFICE_CODE_CHOICES)
pmnt_dt = fields.DateField(db_column='PMNT_DT',
null=True,
help_text="This field is undocumented")
pmnt_amount = fields.FloatField(db_column='PMNT_AMOUNT',
help_text="This field is undocumented")
type_literature = fields.IntegerField(
db_column='TYPE_LITERATURE', help_text="This field is undocumented")
type_printads = fields.IntegerField(db_column='TYPE_PRINTADS',
help_text="This field is undocumented")
type_radio = fields.IntegerField(db_column='TYPE_RADIO',
help_text="This field is undocumented")
type_tv = fields.IntegerField(db_column='TYPE_TV',
help_text="This field is undocumented")
type_it = fields.IntegerField(db_column='TYPE_IT',
help_text="This field is undocumented")
type_billboards = fields.IntegerField(
db_column='TYPE_BILLBOARDS', help_text="This field is undocumented")
type_other = fields.IntegerField(db_column='TYPE_OTHER',
help_text="This field is undocumented")
other_desc = fields.CharField(db_column='OTHER_DESC',
max_length=49,
help_text="This field is undocumented")
class Meta:
app_label = 'calaccess_raw'
db_table = 'CVR_E530_CD'
verbose_name = 'CVR_E530_CD'
verbose_name_plural = 'CVR_E530_CD'
def __str__(self):
return str(self.filing_id)
class SpltCd(CalAccessBaseModel):
"""
Split records
"""
UNIQUE_KEY = ("FILING_ID", "AMEND_ID", "LINE_ITEM", "PFORM_TYPE")
amend_id = fields.IntegerField(
db_column='AMEND_ID',
db_index=True,
help_text="Amendment identification number. A number of 0 is the \
original filing and 1 to 999 amendments.",
verbose_name="amendment ID")
elec_amount = fields.DecimalField(max_digits=16,
decimal_places=2,
db_column='ELEC_AMOUNT',
help_text="This field is undocumented")
elec_code = fields.CharField(
max_length=2,
db_column='ELEC_CODE',
blank=True,
help_text='This field is undocumented',
)
elec_date = fields.DateField(db_column='ELEC_DATE',
null=True,
help_text="This field is undocumented")
filing_id = fields.IntegerField(
db_column='FILING_ID',
db_index=True,
verbose_name='filing ID',
help_text="Unique filing identificiation number")
line_item = fields.IntegerField(
db_column='LINE_ITEM',
help_text="Line item number of this record",
db_index=True,
)
PFORM_TYPE_CHOICES = (
('A', ''),
('B1', ''),
('B2', ''),
('C', ''),
('D', ''),
('F450P5', ''),
('H', ''),
)
pform_type = fields.CharField(
max_length=7,
db_column='PFORM_TYPE',
db_index=True,
choices=PFORM_TYPE_CHOICES,
help_text='This field is undocumented',
)
ptran_id = fields.CharField(
verbose_name='transaction ID',
max_length=32,
db_column='PTRAN_ID',
blank=True,
help_text='Permanent value unique to this item',
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'SPLT_CD'
verbose_name = 'SPLT_CD'
verbose_name_plural = 'SPLT_CD'
def __str__(self):
return str(self.filing_id)
class FilerLinksCd(CalAccessBaseModel):
"""
Links filers to each other and records their relationship type.
"""
UNIQUE_KEY = (
"FILER_ID_A",
"FILER_ID_B",
"ACTIVE_FLG",
"SESSION_ID",
"LINK_TYPE"
)
filer_id_a = fields.IntegerField(
verbose_name='Filer ID A',
db_column='FILER_ID_A',
db_index=True,
help_text='Unique identification number for the first filer \
in the relationship',
)
filer_id_b = fields.IntegerField(
verbose_name='Filer ID B',
db_column='FILER_ID_B',
db_index=True,
help_text='Unique identification number for the second filer \
in the relationship',
)
active_flg = fields.CharField(
verbose_name='active flag',
max_length=1,
db_column='ACTIVE_FLG',
help_text='Indicates if the link is active',
)
session_id = fields.IntegerField(
verbose_name='session ID',
db_column='SESSION_ID',
help_text='Legislative session identification number',
null=True,
)
LINK_TYPE_CHOICES = (
(-12019, '-12019'),
(-12018, '-12018'),
(-12016, '-12016'),
(-12015, '-12015'),
(-12014, '-12014'),
(-12013, '-12013'),
(-12011, '-12011'),
(-12008, '-12008'),
(-12005, '-12005'),
(-12004, '-12004'),
(-12002, '-12002'),
(-12001, '-12001'),
(0, '0'),
(12001, '12001'),
(12002, '12002'),
(12004, '12004'),
(12005, '12005'),
(12008, '12008'),
(12011, '12011'),
(12013, '12013'),
(12014, '12014'),
(12015, '12015'),
(12016, '12016'),
(12018, '12018'),
(12019, '12019'),
)
link_type = fields.IntegerField(
choices=LINK_TYPE_CHOICES,
db_column='LINK_TYPE',
help_text='Denotes the type of the link',
)
link_desc = fields.CharField(
verbose_name='link description',
max_length=255,
db_column='LINK_DESC',
blank=True,
help_text='Unused',
)
effect_dt = fields.DateField(
verbose_name='effective date',
db_column='EFFECT_DT',
null=True,
help_text='Date the link became active',
)
dominate_filer = fields.CharField(
max_length=1,
db_column='DOMINATE_FILER',
blank=True,
help_text='Unused',
)
termination_dt = fields.DateField(
verbose_name='termination date',
db_column='TERMINATION_DT',
null=True,
blank=True,
help_text="Termination effective date"
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILER_LINKS_CD'
verbose_name = 'FILER_LINKS_CD'
verbose_name_plural = 'FILER_LINKS_CD'
def __str__(self):
return str('%s-%s' % (self.filer_id_a, self.filer_id_b))
class NamesCd(CalAccessBaseModel):
"""
The name of all entities in the system. Used for searches when
the name has an identification number.
"""
UNIQUE_KEY = False
namid = fields.IntegerField(
db_column='NAMID',
help_text="Identification number unique to the name",
)
naml = fields.CharField(
max_length=200,
db_column='NAML',
help_text="Last name",
)
namf = fields.CharField(
max_length=50,
db_column='NAMF',
help_text="First name",
)
namt = fields.CharField(
max_length=100,
db_column='NAMT',
blank=True,
help_text="Name title or prefix",
)
nams = fields.CharField(
max_length=30,
db_column='NAMS',
blank=True,
help_text="Name suffix",
)
moniker = fields.CharField(
max_length=30,
db_column='MONIKER',
blank=True,
help_text="Entity's moniker",
)
moniker_pos = fields.CharField(
max_length=9,
db_column='MONIKER_POS',
blank=True,
help_text="Location of the entity's moniker",
)
namm = fields.CharField(
max_length=20,
db_column='NAMM',
blank=True,
help_text="Middle name",
)
fullname = fields.CharField(
max_length=200,
db_column='FULLNAME',
help_text="Full name",
)
naml_search = fields.CharField(
max_length=200,
db_column='NAML_SEARCH',
help_text="Last name",
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'NAMES_CD'
verbose_name = 'NAMES_CD'
verbose_name_plural = 'NAMES_CD'
def __str__(self):
return str(self.namid)
class EfsFilingLogCd(CalAccessBaseModel):
"""
This is an undocumented model.
"""
UNIQUE_KEY = (
"FILING_DATE",
"VENDOR"
)
filing_date = fields.DateTimeField(
db_column='FILING_DATE',
null=True,
help_text="This field is undocumented"
)
filingstatus = fields.IntegerField(
db_column='FILINGSTATUS',
help_text="This field is undocumented"
)
vendor = fields.CharField(
db_column='VENDOR',
max_length=250,
help_text="This field is undocumented"
)
filer_id = fields.CharField(
verbose_name='filer ID',
db_column='FILER_ID',
max_length=250,
blank=True,
db_index=True,
help_text="Filer's unique identification number",
)
FORM_TYPE_CHOICES = (
('BADFORMAT 253', ''),
('F400', ''),
('F401', ''),
('F402', ''),
('F410', ''),
('F425', ''),
('F450', ''),
('F460', ''),
('F461', ''),
('F465', ''),
('F496', ''),
('F497', ''),
('F498', ''),
('F601', ''),
('F602', ''),
('F603', ''),
('F604', ''),
('F606', ''),
('F607', ''),
('F615', ''),
('F625', ''),
('F635', ''),
('F645', ''),
('form', ''),
)
form_type = fields.CharField(
db_column='FORM_TYPE',
max_length=250,
help_text='Name of the source filing form or schedule',
db_index=True,
choices=FORM_TYPE_CHOICES,
)
error_no = fields.CharField(
db_column='ERROR_NO',
max_length=250,
help_text="This field is undocumented"
)
class Meta:
app_label = 'calaccess_raw'
db_table = 'EFS_FILING_LOG_CD'
verbose_name = 'EFS_FILING_LOG_CD'
verbose_name_plural = 'EFS_FILING_LOG_CD'
def __str__(self):
return str(self.filer_id)
class FilernameCd(CalAccessBaseModel):
"""
A combination of CAL-ACCESS tables to provide the analyst with
filer information.
Full name of all PACs, firms, and employers are in the last
name field.
Major donors can be split between first and last name fields, but usually
are contained in the last name field only. Individual names of lobbyists,
candidates/officeholders, treasurers/responsible officers, and major donors
(when they are only an individual's name) use both the first and last name
fields in conjunction.
"""
UNIQUE_KEY = ("FILER_ID", "NAMID")
xref_filer_id = fields.CharField(
verbose_name='crossreference filer ID',
max_length=15,
db_column='XREF_FILER_ID',
db_index=True,
help_text="Alternative filer ID found on many forms")
DOCUMENTCLOUD_PAGES = [DocumentCloud(id='2711615-FAQ', start_page=2)]
filer_id = fields.IntegerField(
verbose_name='filer ID',
db_column='FILER_ID',
db_index=True,
null=True,
help_text="Filer's unique identification number")
FILER_TYPE_CHOICES = (
(' NOT DEFINED', 'Undefined'), ('ALL FILERS', 'All filers'),
('CANDIDATE/OFFICEHOLDER', 'Candidate/officeholder'),
('CLIENT', 'Client'), ('EMPLOYER', 'Employer'), ('FIRM', 'Firm'),
('INDIVIDUAL', 'Individual'), ('INITIATIVE',
'Initiative'), ('LOBBYIST', 'Lobbyist'),
('MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE',
'Major donor or indenpendent expenditure committee'),
('PAYMENT TO INFLUENCE', 'Payment to influence'), ('PREPAID ACCOUNT',
'Prepaid account'),
('PROPONENT', 'Proponent'), ('PROPOSITION',
'Proposition'), ('RECIPIENT COMMITTEE',
'Recipient committee'),
('SLATE MAILER ORGANIZATIONS',
'Slate mailer organization'), ('TREASURER/RESPONSIBLE OFFICER',
'Treasurer/responsible officer'))
filer_type = fields.CharField(max_length=45,
db_column='FILER_TYPE',
db_index=True,
choices=FILER_TYPE_CHOICES,
help_text='The type of filer')
STATUS_CHOICES = (
('', 'Undefined'),
('A', ''),
('ACTIVE', ''),
('INACTIVE', ''),
('P', ''),
('R', ''),
('S', ''),
('TERMINATED', ''),
('W', ''),
)
status = fields.CharField(max_length=10,
db_column='STATUS',
db_index=True,
choices=STATUS_CHOICES,
blank=True,
help_text='The status of the filer')
effect_dt = fields.DateField(
db_column='EFFECT_DT',
help_text="Effective date for status",
null=True,
)
naml = fields.CharField(max_length=200,
db_column='NAML',
help_text="Last name, sometimes full name")
namf = fields.CharField(max_length=55,
db_column='NAMF',
blank=True,
help_text="First name")
namt = fields.CharField(max_length=70,
db_column='NAMT',
blank=True,
help_text="Name prefix or title")
nams = fields.CharField(max_length=32,
db_column='NAMS',
blank=True,
help_text="Name suffix")
adr1 = fields.CharField(max_length=200,
db_column='ADR1',
blank=True,
help_text="First line of street address")
adr2 = fields.CharField(max_length=200,
db_column='ADR2',
blank=True,
help_text="Second line of street address")
city = fields.CharField(max_length=55,
db_column='CITY',
blank=True,
help_text="City address")
st = fields.CharField(max_length=4,
db_column='ST',
blank=True,
verbose_name="State")
zip4 = fields.CharField(max_length=10,
db_column='ZIP4',
blank=True,
help_text="ZIP Code")
phon = fields.CharField(max_length=60,
db_column='PHON',
blank=True,
verbose_name="Phone",
help_text="Phone number")
fax = fields.CharField(max_length=60,
db_column='FAX',
blank=True,
help_text="Fax number")
email = fields.CharField(max_length=60,
db_column='EMAIL',
blank=True,
help_text="Email address")
class Meta:
app_label = 'calaccess_raw'
db_table = 'FILERNAME_CD'
verbose_name = 'FILERNAME_CD'
verbose_name_plural = 'FILERNAME_CD'
ordering = (
"naml",
"namf",
)
def __str__(self):
return str(self.filer_id)
