CAL-ACCESS OVERVIEW notification of processing results electronic filings ELECTRONIC FILING SUBSYSTEM validated filings accepts and validates electronic filings Campaign or Lobbying Filer (via Vendor) paper filings processing results AGENCY MANAGEMENT SUBSYSTEM filer and filing data; results of PRD management processes supports PRD busines s processes database updates database contents CAL-ACCESS DATABASE accounting records, reports, public counter products Secretary of State Political Reform Division Program Analysis queries electronic form image DISCLOSURE SUBSYSTEM database contents filer/filing information Web access Web User discloses filings to Internet Physical Data Model Model_1 Cal-Access Tables, Columns, Indexes February 21, 2000 Owner: California Secretary of State Author: ITD --- Sacramento. CA This document provides a listing of all tables, columns and indexes contained in the Oracle database for the California Automated Lobbying and Campaign Contribution & Expenditure Search System (CalACCESS). PowerDesigner 2/21/02 Page 1 Physical Data Model Model_1 Table of Contents Cal-Access Tables, Columns, Indexes............................................................................................................................................................................ 1 Table List..........................................................................................................................................................................................................................6 TABLE: ACRONYMS..................................................................................................................................................................................................... 15 TABLE: ADDRESS........................................................................................................................................................................................................ 15 TABLE: AMS_PROCESSING_STATUS........................................................................................................................................................................16 TABLE: AMS_SYSTEM_AUDIT.................................................................................................................................................................................... 16 TABLE: AMS_SYSTEM_PARMS.................................................................................................................................................................................. 17 TABLE: AUDIT_ACRONYMS........................................................................................................................................................................................ 17 TABLE: AUDIT_ADDRESS........................................................................................................................................................................................... 18 TABLE: BALLOT_MEASURES......................................................................................................................................................................................18 TABLE: CAL_FILE......................................................................................................................................................................................................... 19 TABLE: CAMPAIGN_AMENDMENT_INFO...................................................................................................................................................................19 TABLE: CARES_GROUPS............................................................................................................................................................................................20 TABLE: CARES_USERS............................................................................................................................................................................................... 20 TABLE: CASH_RECON_REPORT_WRK..................................................................................................................................................................... 21 TABLE: CHECK_OUT_STATUS................................................................................................................................................................................... 21 TABLE: CODE_LIST......................................................................................................................................................................................................22 TABLE: CORRESPONDENCE......................................................................................................................................................................................22 TABLE: CORRESPONDENCE_PREFERENCES.........................................................................................................................................................23 TABLE: CVR_CAMPAIGN_DISCLOSURE................................................................................................................................................................... 24 TABLE: CVR_E530........................................................................................................................................................................................................28 TABLE: CVR_F470........................................................................................................................................................................................................ 29 TABLE: CVR_LOBBY_DISCLOSURE...........................................................................................................................................................................31 TABLE: CVR_REGISTRATION..................................................................................................................................................................................... 34 TABLE: CVR_SO........................................................................................................................................................................................................... 38 TABLE: CVR2_CAMPAIGN_DISCLOSURE................................................................................................................................................................. 40 TABLE: CVR2_LOBBY_DISCLOSURE.........................................................................................................................................................................42 TABLE: CVR2_REGISTRATION................................................................................................................................................................................... 43 TABLE: CVR2_SO......................................................................................................................................................................................................... 44 TABLE: CVR3_VERIFICATION_INFO.......................................................................................................................................................................... 45 TABLE: DEBT................................................................................................................................................................................................................ 46 TABLE: DISCLOSURE_PROCEDURES.......................................................................................................................................................................48 TABLE: EFS_FILING_LOG........................................................................................................................................................................................... 48 TABLE: ELECTION_CANDIDATES.............................................................................................................................................................................. 49 TABLE: ELECTION_LINKS........................................................................................................................................................................................... 49 TABLE: ELECTION_RACES......................................................................................................................................................................................... 50 TABLE: ELECTION_TYPES..........................................................................................................................................................................................50 TABLE: ELECTIONS..................................................................................................................................................................................................... 51 PowerDesigner 2/21/02 Page 2 Physical Data Model Model_1 TABLE: ERROR_LOG................................................................................................................................................................................................... 52 TABLE: ERRORS_AND_OMISSIONS.......................................................................................................................................................................... 52 TABLE: EXPN................................................................................................................................................................................................................ 52 TABLE: F495P2............................................................................................................................................................................................................. 55 TABLE: F501_502..........................................................................................................................................................................................................56 TABLE: F690P2............................................................................................................................................................................................................. 58 TABLE: FEDERAL_FORMS.......................................................................................................................................................................................... 59 TABLE: FEES................................................................................................................................................................................................................ 59 TABLE: FILER_ACRONYMS.........................................................................................................................................................................................60 TABLE: FILER_ADDRESS............................................................................................................................................................................................ 60 TABLE: FILER_AUTHENTICATION..............................................................................................................................................................................61 TABLE: FILER_CORRESPONDENCE_BUILD2........................................................................................................................................................... 61 TABLE: FILER_ELECTIONS......................................................................................................................................................................................... 62 TABLE: FILER_ETHICS_CLASS.................................................................................................................................................................................. 63 TABLE: FILER_FILINGS............................................................................................................................................................................................... 63 TABLE: FILER_ID_TEMP..............................................................................................................................................................................................65 TABLE: FILER_INTERESTS......................................................................................................................................................................................... 65 TABLE: FILER_LINKS................................................................................................................................................................................................... 66 TABLE: FILER_NAMES.................................................................................................................................................................................................66 TABLE: FILER_NOTICE_GENERATION_DEF.............................................................................................................................................................67 TABLE: FILER_OBLIGATIONS..................................................................................................................................................................................... 68 TABLE: FILER_STATUS_TYPES................................................................................................................................................................................. 68 TABLE: FILER_TO_FILER_TYPE.................................................................................................................................................................................68 TABLE: FILER_TYPE_PERIODS.................................................................................................................................................................................. 70 TABLE: FILER_TYPES..................................................................................................................................................................................................70 TABLE: FILER_TYPES_TO_FORMS............................................................................................................................................................................71 TABLE: FILER_XREF....................................................................................................................................................................................................71 TABLE: FILERS............................................................................................................................................................................................................. 72 TABLE: FILING_ERROR_TYPES................................................................................................................................................................................. 72 TABLE: FILING_ERRORS.............................................................................................................................................................................................72 TABLE: FILING_ID_TEMP............................................................................................................................................................................................ 73 TABLE: FILING_PERIOD.............................................................................................................................................................................................. 73 TABLE: FILINGS............................................................................................................................................................................................................74 TABLE: FINANCIAL_ACCOUNTS_BUILD2.................................................................................................................................................................. 74 TABLE: FINANCIAL_TRANS_BUILD2.......................................................................................................................................................................... 75 TABLE: FORM_CODES................................................................................................................................................................................................ 76 TABLE: FORMAT_CODES............................................................................................................................................................................................76 TABLE: FORMS.............................................................................................................................................................................................................77 TABLE: GROUP_TYPES...............................................................................................................................................................................................77 TABLE: HDR.................................................................................................................................................................................................................. 78 TABLE: HEADER...........................................................................................................................................................................................................78 PowerDesigner 2/21/02 Page 3 Physical Data Model Model_1 TABLE: IMAGE_LINKS..................................................................................................................................................................................................79 TABLE: IMAGES............................................................................................................................................................................................................80 TABLE: LATE_CONT_IND_EXP_REPORT..................................................................................................................................................................80 TABLE: LATT.................................................................................................................................................................................................................81 TABLE: LCCM................................................................................................................................................................................................................82 TABLE: LEGISLATIVE_SESSIONS.............................................................................................................................................................................. 83 TABLE: LEMP................................................................................................................................................................................................................ 84 TABLE: LEXP.................................................................................................................................................................................................................85 TABLE: LOAN................................................................................................................................................................................................................ 86 TABLE: LOBBY_AMENDMENTS.................................................................................................................................................................................. 89 TABLE: LOBBYING_CHG_LOG....................................................................................................................................................................................90 TABLE: LOBBYIST_CONTRIBUTIONS1...................................................................................................................................................................... 91 TABLE: LOBBYIST_CONTRIBUTIONS2...................................................................................................................................................................... 92 TABLE: LOBBYIST_CONTRIBUTIONS3...................................................................................................................................................................... 93 TABLE: LOBBYIST_EMP_LOBBYIST1.........................................................................................................................................................................93 TABLE: LOBBYIST_EMP_LOBBYIST2.........................................................................................................................................................................94 TABLE: LOBBYIST_EMPLOYER_FIRMS1................................................................................................................................................................... 94 TABLE: LOBBYIST_EMPLOYER_FIRMS2................................................................................................................................................................... 95 TABLE: LOBBYIST_EMPLOYER_HISTORY................................................................................................................................................................ 95 TABLE: LOBBYIST_EMPLOYER1................................................................................................................................................................................ 96 TABLE: LOBBYIST_EMPLOYER2................................................................................................................................................................................ 97 TABLE: LOBBYIST_EMPLOYER3................................................................................................................................................................................ 98 TABLE: LOBBYIST_FIRM_EMPLOYER1..................................................................................................................................................................... 99 TABLE: LOBBYIST_FIRM_EMPLOYER2..................................................................................................................................................................... 99 TABLE: LOBBYIST_FIRM_HISTORY......................................................................................................................................................................... 100 TABLE: LOBBYIST_FIRM_LOBBYIST1......................................................................................................................................................................101 TABLE: LOBBYIST_FIRM_LOBBYIST2......................................................................................................................................................................101 TABLE: LOBBYIST_FIRM1......................................................................................................................................................................................... 102 TABLE: LOBBYIST_FIRM2......................................................................................................................................................................................... 103 TABLE: LOBBYIST_FIRM3......................................................................................................................................................................................... 104 TABLE: LOCAL_FORMS.............................................................................................................................................................................................104 TABLE: LOOKUP_CODES..........................................................................................................................................................................................105 TABLE: LOTH.............................................................................................................................................................................................................. 105 TABLE: LPAY...............................................................................................................................................................................................................106 TABLE: MESSAGES....................................................................................................................................................................................................108 TABLE: MV_SMRY_F635............................................................................................................................................................................................108 TABLE: MVIEW_DUMMY1..........................................................................................................................................................................................109 TABLE: MVIEW_DUMMY2..........................................................................................................................................................................................109 TABLE: MVIEW_ELECTRONIC_FILERS................................................................................................................................................................... 110 TABLE: MVIEW_LOBBYIST_CONTRIB..................................................................................................................................................................... 110 TABLE: NAMES........................................................................................................................................................................................................... 111 PowerDesigner 2/21/02 Page 4 Physical Data Model Model_1 TABLE: PLAN_TABLE................................................................................................................................................................................................. 111 TABLE: PRD_DATA_AUDIT........................................................................................................................................................................................112 TABLE: PRD_FINE_DETAIL....................................................................................................................................................................................... 113 TABLE: PRD_FINES....................................................................................................................................................................................................113 TABLE: PRD_LIMITS.................................................................................................................................................................................................. 114 TABLE: PRD_USER.................................................................................................................................................................................................... 114 TABLE: PRD_USER_ASSIGNMENTS........................................................................................................................................................................115 TABLE: PRD_USER_CORRESPONDENCE.............................................................................................................................................................. 115 TABLE: PRD_USER_PREFERENCE..........................................................................................................................................................................116 TABLE: PRD_USER_SECURITY_USERS..................................................................................................................................................................116 TABLE: PRD_USER_WORK_ROLES........................................................................................................................................................................ 116 TABLE: PRD_WAIVERS............................................................................................................................................................................................. 117 TABLE: RCPT..............................................................................................................................................................................................................117 TABLE: RECEIVED_FILINGS..................................................................................................................................................................................... 120 TABLE: REPORT_PROCESSING_WORK_LIST........................................................................................................................................................120 TABLE: REPORTS...................................................................................................................................................................................................... 121 TABLE: REVIEW_LIST................................................................................................................................................................................................121 TABLE: S401............................................................................................................................................................................................................... 122 TABLE: S496............................................................................................................................................................................................................... 123 TABLE: S497............................................................................................................................................................................................................... 124 TABLE: S498............................................................................................................................................................................................................... 126 TABLE: SECURITY_APPS.......................................................................................................................................................................................... 128 TABLE: SECURITY_GROUPINGS............................................................................................................................................................................. 128 TABLE: SECURITY_INFO...........................................................................................................................................................................................129 TABLE: SECURITY_TEMPLATE................................................................................................................................................................................ 129 TABLE: SECURITY_USERS....................................................................................................................................................................................... 130 TABLE: SMRY............................................................................................................................................................................................................. 130 TABLE: SPLT...............................................................................................................................................................................................................131 TABLE: SYSTEM_AUDIT............................................................................................................................................................................................ 131 TABLE: TEXT_MEMO................................................................................................................................................................................................. 132 TABLE: TVIEW_CONTRIBUTIONS3.......................................................................................................................................................................... 133 TABLE: USER_BATCH_PRINT_LIST......................................................................................................................................................................... 134 TABLE: USER_CHECK_LIST..................................................................................................................................................................................... 134 TABLE: VALIDATOR_ERRORS..................................................................................................................................................................................134 TABLE: WORK_ROLES.............................................................................................................................................................................................. 135 PowerDesigner 2/21/02 Page 5 Physical Data Model Model_1 Table List Name Code ACRONYMS ACRONYMS ADDRESS ADDRESS AMS_PROCESSING_STATUS AMS_PROCESSING_STATUS AMS_SYSTEM_AUDIT AMS_SYSTEM_PARMS AUDIT_ACRONYMS AUDIT_ADDRESS BALLOT_MEASURES CAL_FILE AMS_SYSTEM_AUDIT AMS_SYSTEM_PARMS AUDIT_ACRONYMS AUDIT_ADDRESS BALLOT_MEASURES CAL_FILE CAMPAIGN_AMENDMENT_INFO CAMPAIGN_AMENDMENT_INFO CARES_GROUPS CARES_USERS CASH_RECON_REPORT_WRK CARES_GROUPS CARES_USERS CASH_RECON_REPORT_WRK CHECK_OUT_STATUS CHECK_OUT_STATUS CODE_LIST CODE_LIST CORRESPONDENCE CORRESPONDENCE CORRESPONDENCE_PREFERENCES CORRESPONDENCE_PREFERENCES CVR_CAMPAIGN_DISCLOSURE CVR_CAMPAIGN_DISCLOSURE CVR_E530 CVR_E530 PowerDesigner 2/21/02 Label Contains acronyms and their meaning. Most common use is to relate a acronym used in an entity name to the meaning of the acronym. This table holds all addresses for the system. This table can be used for address based searches and forms the basis for address information displayed by the AMS. Reserved for future use - Maintains status of user initiated processes or jobs that may be running. JM needs to describe this table. System configuration parameters used by the AMS. Audit table for the table ACRONYMS Audit table for the table ADDRESS. Ballot Measures dates and names. Unused. This table was planned for use in storing filings into the database. SOS chose to implement this by writing the filings to CD-ROM. Amendment Information (a.k.a. Form 405; Part II) - I believe this is a table that is no longer used. W C 4/28/2000 J M needs to describe this table. Cox 4/28/2000 J M needs to describe this table. Cox 4/28/2000 J M needs to describe this table. It is in his list of tables designed for future enhancements. This table contains a list of CAL file codes. Examples include entity codes, office codes and expense codes J M needs to describe this table. Cox 4/28/2000 J M needs to describe this table. Cox 4/28/2000 Cover page information for the campaign disclosure forms (F401, F450, F460, F461, F425, F465, F496, F497, F498). This data comes from the electronic filing. The data contained herein is "as filed" by the entity making the filing. Page 6 Physical Data Model Model_1 Name Code CVR_F470 CVR_F470 CVR_LOBBY_DISCLOSURE CVR_LOBBY_DISCLOSURE CVR_REGISTRATION CVR_REGISTRATION CVR_SO CVR2_CAMPAIGN_DISCLOSURE CVR_SO CVR2_CAMPAIGN_DISCLOSURE CVR2_LOBBY_DISCLOSURE CVR2_LOBBY_DISCLOSURE CVR2_REGISTRATION CVR2_REGISTRATION CVR2_SO CVR2_SO CVR3_VERIFICATION_INFO CVR3_VERIFICATION_INFO DEBT DEBT DISCLOSURE_PROCEDURES EFS_FILING_LOG ELECTION_CANDIDATES DISCLOSURE_PROCEDURES EFS_FILING_LOG ELECTION_CANDIDATES ELECTION_LINKS ELECTION_RACES ELECTION_TYPES ELECTIONS ERROR_LOG ERRORS_AND_OMISSIONS ELECTION_LINKS ELECTION_RACES ELECTION_TYPES ELECTIONS ERROR_LOG ERRORS_AND_OMISSIONS EXPN EXPN F495P2 F495P2 F501_502 F690P2 F501_502 F690P2 FEDERAL_FORMS FEDERAL_FORMS PowerDesigner 2/21/02 Label Cover page layout for F470 Officeholder/Candidate Short Supplement Cover page information for the lobbying disclosure forms 615, 625, 635, and 645 . Cover page information for the lobbying registration forms 601, 602, 603, 604, 606, and 607. Record used to carry additional names for the campaign disclosure forms 401, 450, 460, 461, 425, 465, 496, 497, and 498. Additional names data for the lobbyist disclosure forms 615, 625, 635, and 645. Additional names layout for the Forms 601, F602, F603, F604, F606, and F607. Additional Names/ Committees information for the forms 400 and 410. Cover Page Verification Information for the Campaign Forms. Form 460 Schedule (F) Accrued Expenses (Unpaid Bills) records. J M needs to describe this table. This table indicates if a candidate for a given race is an incumbent. This table links election types and their descriptions. J M needs to describe this table. This table contains results of audit checks and the validation process. This table contains expenditure records for the Form 460 Schedules D, E, and G, the Form450 Part 5, the Form 461 Part 5, Form 465 Part 3) This table contains Form 495 Part II contribution information. Filing information for the Forms 501 and 502. Form 690 admendment information used to amend lobbying disclosure filings. Table used to log reciept of federal filings. Page 7 Physical Data Model Model_1 Name FEES FILER_ACRONYMS FILER_ADDRESS Code FEES FILER_ACRONYMS FILER_ADDRESS FILER_AUTHENTICATION FILER_AUTHENTICATION FILER_CORRESPONDENCE_BUILD2 FILER_ELECTIONS FILER_ETHICS_CLASS FILER_FILINGS FILER_CORRESPONDENCE_BUILD2 FILER_ELECTIONS FILER_ETHICS_CLASS FILER_FILINGS FILER_ID_TEMP FILER_ID_TEMP FILER_INTERESTS FILER_LINKS FILER_INTERESTS FILER_LINKS FILER_NAMES FILER_NAMES FILER_NOTICE_GENERATION_DEF FILER_NOTICE_GENERATION_DEF FILER_OBLIGATIONS FILER_OBLIGATIONS FILER_STATUS_TYPES FILER_STATUS_TYPES FILER_TO_FILER_TYPE FILER_TO_FILER_TYPE FILER_TYPE_PERIODS FILER_TYPE_PERIODS FILER_TYPES FILER_TYPES_TO_FORMS FILER_TYPES FILER_TYPES_TO_FORMS FILER_XREF FILER_XREF FILERS FILERS FILING_ERROR_TYPES FILING_ERROR_TYPES PowerDesigner 2/21/02 Label Fees, descriptions and their value Links acronyms to filers Links filers and addresses. This table maintains a history of when addresses change. This table contains the authentication information required to authenticate a filer so they may file electronically. J M needs to describe this table. This table stores lobbyist ethics training dates. 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. J M needs to describe this table. It may possibly be unused. Links a filer to their interest codes. This table links filers to other filers in the system by their type of relationship. This table links the filer to all names the filer may have been known by. This table maintains the history of filer's names. J M needs to describe this table. He indicates it is for future use. J M needs to describe this table. He indicates it is for future use. J M needs to describe this table. He indicates it is for future use. 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. J M needs to document. This is in his list of tables designed for future enhancements. This lookup table describes filer types. J M needs to describe this table. It is in his list of tables designed for future releases. This table maps legacy filer identification numbers to the systems filer identification numbers. This table is the parent table from which all linkls and assocations to a filer are derived. This lookup table provides a cross reference for errors and Page 8 Physical Data Model Model_1 Name Code Label their and messages. This table contains the errors assocated with a given filing and each of it's amendments. FILING_ERRORS FILING_ERRORS FILING_ID_TEMP FILING_PERIOD FILINGS FILING_ID_TEMP FILING_PERIOD FILINGS FINANCIAL_ACCOUNTS_BUILD2 FINANCIAL_ACCOUNTS_BUILD2 FINANCIAL_TRANS_BUILD2 FORM_CODES FORMAT_CODES FORMS GROUP_TYPES HDR HEADER FINANCIAL_TRANS_BUILD2 FORM_CODES FORMAT_CODES FORMS GROUP_TYPES HDR HEADER IMAGE_LINKS IMAGES LATE_CONT_IND_EXP_REPORT LATT IMAGE_LINKS IMAGES LATE_CONT_IND_EXP_REPORT LATT LCCM LCCM LEGISLATIVE_SESSIONS LEMP LEGISLATIVE_SESSIONS LEMP LEXP LEXP LOAN LOAN LOBBY_AMENDMENTS LOBBY_AMENDMENTS LOBBYING_CHG_LOG LOBBYIST_CONTRIBUTIONS1 LOBBYING_CHG_LOG LOBBYIST_CONTRIBUTIONS1 LOBBYIST_CONTRIBUTIONS2 LOBBYIST_CONTRIBUTIONS2 PowerDesigner 2/21/02 List of valid periods, dates, groups and deadline dates This table is the parent table from which all links and associations to a filing are derived. This table contains all fine, pre-paid account information, lobbying registration fees due, and refund information. Records over the counter line item transactions. This lookup table assocates record types to forms. J M needs to describe this table. Cox 5/10/2000 This table describes the form set. This lookup table stores group type information. Electronic filing header record data. Lookup table used to display Form 460 information in the AMS. J M needs to describe this table. This table links images to filers and accounts. This table is used to store images in the database. J M needs to describe this table. Lobbyist disclosure attachment schedules for payments form 630, 635-C, and 640 Lobbying Campaign Contribitions reported reported on the Forms 615 Part 2, 625 Part 4B, 635 Part 4B and the 645 Part 3B. Legislative session, begin and end dates look up table. Lobbyist Employers/Subcontracted Clients data from Form 601 filings. Lobbying Activity Expenditure Schedule information reported in filings of the Forms 615 Part 1, 625 Part 3A, 635 Part 3C, and 645 Part 2A. Loan Schedules / Received (B1, B2, B3) and Made (H1, H2, H3) Lobbyist regiistration amendment information (Form 605 Part I). HOLDS LOBBYIST LOG DATA FOR WEB DISPLAY Lobbyist contribution disclosure table. Temporary table used to generate disclosure table (Lobbyist Contributions 3). Lobbyist contribution disclosure table. Temporary table Page 9 Physical Data Model Name Model_1 LOBBYIST_CONTRIBUTIONS3 LOBBYIST_EMP_LOBBYIST1 LOBBYIST_CONTRIBUTIONS3 LOBBYIST_EMP_LOBBYIST1 LOBBYIST_EMP_LOBBYIST2 LOBBYIST_EMP_LOBBYIST2 LOBBYIST_EMPLOYER_FIRMS1 LOBBYIST_EMPLOYER_FIRMS1 LOBBYIST_EMPLOYER_FIRMS2 LOBBYIST_EMPLOYER_FIRMS2 LOBBYIST_EMPLOYER_HISTORY LOBBYIST_EMPLOYER_HISTORY LOBBYIST_EMPLOYER1 LOBBYIST_EMPLOYER1 LOBBYIST_EMPLOYER2 LOBBYIST_EMPLOYER2 LOBBYIST_EMPLOYER3 LOBBYIST_EMPLOYER3 LOBBYIST_FIRM_EMPLOYER1 LOBBYIST_FIRM_EMPLOYER1 LOBBYIST_FIRM_EMPLOYER2 LOBBYIST_FIRM_EMPLOYER2 Label used to generate disclosure table (Lobbyist Contributions 3). Lobbyist contribution disclosure table. Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the 2/21/02 Page 10 PowerDesigner Code Physical Data Model Model_1 Name Code LOBBYIST_FIRM_HISTORY LOBBYIST_FIRM_HISTORY LOBBYIST_FIRM_LOBBYIST1 LOBBYIST_FIRM_LOBBYIST1 LOBBYIST_FIRM_LOBBYIST2 LOBBYIST_FIRM_LOBBYIST2 LOBBYIST_FIRM1 LOBBYIST_FIRM1 LOBBYIST_FIRM2 LOBBYIST_FIRM2 LOBBYIST_FIRM3 LOBBYIST_FIRM3 LOCAL_FORMS LOOKUP_CODES LOCAL_FORMS LOOKUP_CODES LOTH LOTH LPAY LPAY MESSAGES MESSAGES MV_SMRY_F635 MVIEW_DUMMY1 MVIEW_DUMMY2 MVIEW_ELECTRONIC_FILERS MV_SMRY_F635 MVIEW_DUMMY1 MVIEW_DUMMY2 MVIEW_ELECTRONIC_FILERS PowerDesigner 2/21/02 Label multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D H's documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D Hs documentation on these tables. Cox 5/11/2000 Matt needs to describe the relationship between the multiple tables. Documentation should be cloned from D Hs's documentation on these tables. Cox 5/11/2000 This table is used to log reciept of local paper filings. This table contains the description of all lookup codes used in the system. Payment to other lobbying firms reported on Form 625 Part 3B. Payments made/received to/from Lobbying Firms reported on Form 625 Part 2 and 635 Part 3B Common messages, content, icons, print and user input capability snapshot table for snapshot CLAIMS.MV_SMRY_F635 snapshot table for snapshot CLAIMS.MVIEW_DUMMY1 snapshot table for snapshot CLAIMS.MVIEW_DUMMY2 snapshot table for snapshot Page 11 Physical Data Model Model_1 Name Code MVIEW_LOBBYIST_CONTRIB MVIEW_LOBBYIST_CONTRIB NAMES NAMES PLAN_TABLE PRD_DATA_AUDIT PRD_FINE_DETAIL PRD_FINES PRD_LIMITS PRD_USER PRD_USER_ASSIGNMENTS PLAN_TABLE PRD_DATA_AUDIT PRD_FINE_DETAIL PRD_FINES PRD_LIMITS PRD_USER PRD_USER_ASSIGNMENTS PRD_USER_CORRESPONDENCE PRD_USER_PREFERENCE PRD_USER_SECURITY_USERS PRD_USER_CORRESPONDENCE PRD_USER_PREFERENCE PRD_USER_SECURITY_USERS PRD_USER_WORK_ROLES PRD_USER_WORK_ROLES PRD_WAIVERS RCPT PRD_WAIVERS RCPT RECEIVED_FILINGS RECEIVED_FILINGS REPORT_PROCESSING_WORK_LIST REPORTS REPORT_PROCESSING_WORK_LIST REPORTS REVIEW_LIST REVIEW_LIST S401 S401 S496 S496 S497 S497 S498 S498 SECURITY_APPS SECURITY_APPS PowerDesigner 2/21/02 Label CLAIMS.MVIEW_ELECTRONIC_FILERS snapshot table for snapshot CLAIMS.MVIEW_LOBBYIST_CONTRIB This table contains the names of all entities in the system. This table is used for name searches where the entity has an identification number. This table is not unique. Detail information on how a fine was calculated. Fine summary data table. J M needs to describe this table. This table contains AMS user's profile information. This table assigns filings to system users and tracks completion status. J M needs to describe this table. J M needs to describe this table. J M needs to describe this table. It is in his list of tables designed for future enhancements. This table assigns work roles to staff members within the system. J Mo needs to describe this table. Receipts schedules for the Form 460 Schedules A, C, I, and A-1 and the Form 401 Schedule A. J M needs to descirbe this table. This may be a disclosure table descibed in D H's Documentation This table is used by the AMS for report processing. This table defines the reports available in the AMS. J Mo needs to describe some of the columns. J M needs to describe this table. It is in his list of tables designed for future enhancements. This table contains Form 401 payment and other disclosure schedule (F401B, F401B-1, F401C, F401D) information. This table contains Form 496 Late Independent Expenditures Made data. This table contains information for Form 497 Late Contributions Received/Made filings. This table contains Form 498 Late Independent Expenditures Made information. J M needs to describe this table. It is in his list of Page 12 Physical Data Model Model_1 Name Code SECURITY_GROUPINGS SECURITY_GROUPINGS SECURITY_INFO SECURITY_INFO SECURITY_TEMPLATE SECURITY_TEMPLATE SECURITY_USERS SECURITY_USERS SMRY SMRY SPLT SYSTEM_AUDIT TEXT_MEMO SPLT SYSTEM_AUDIT TEXT_MEMO TVIEW_CONTRIBUTIONS3 TVIEW_CONTRIBUTIONS3 USER_BATCH_PRINT_LIST USER_BATCH_PRINT_LIST USER_CHECK_LIST USER_CHECK_LIST VALIDATOR_ERRORS VALIDATOR_ERRORS WORK_ROLES WORK_ROLES PowerDesigner 2/21/02 Label tables designed for future enhancements. J Mo needs to describe this table. It is in his list of tables designed for future enhancements. J M needs to describe this table. It is in his list of tables designed for future enhancements. J M needs to describe this table. It is in his list of tables designed for future enhancements. J M needs to describe this table. It is in his list of tables designed for future enhancements. This table contains summary records for electronic filings. See the CAL documentation to determine legal values for each form. J M needs to describe this table. This table contains all text memos attached to electronic filings. Campaign Disclosure reporting tables. Need to get D H's Documentation to describe. J M needs to describe this table. This is in his list of tables designed for future enhancements. J M needs to describe this table. This is in his list of tables designed for future enhancements. This table is used to store the result of an electronic filing's validation errors. See the validator documentation for an explanation of how to interpret this data. This table contains the descriptions of staff work roles. Page 13 Physical Data Model Model_1 The following describes the column headings found: Each column definition includes the following properties: Property Name Code Data type others Primary key Mandatory Description Name for the column. This name improves the readability of the model Reference name for the column Form of the data corresponding to the column, such as numeric, alphanumeric, boolean, or When selected, designates a column whose values uniquely identify a row in the table When selected indicates that the column must be assigned a value The following index types exist: Key type Primary key Foreign key Alternate key Unique unique Cluster PowerDesigner Description Uniquely identifies a row in the table Depends on and migrates from a primary key in another table Uniquely identifies a row in the table, which is not also indexed by a primary key Index in which no two rows can have the same index value. All primary key indexes must be Index in which the physical order and the logical (indexed) order is the same 2/21/02 Page 14 Physical Data Model Model_1 TABLE: ACRONYMS Column List Name Code A_DESC ACRONYM EFFECT_DT STANDS_FOR Type VARCHAR2(255) VARCHAR2(32) DATE VARCHAR2(255) A_DESC ACRONYM EFFECT_DT STANDS_FOR P No Yes No No M No Yes Yes No Label Description of the Acronym Acronym text value Effective Date for the Acronym Definition of the Acronym. Index List Index Code P Yes PK_ACRONYMS F No A No U Yes C No Column Code ACRONYM Sort ASC TABLE: ADDRESS Column List Name ADR1 ADR2 ADRID CITY EMAIL FAX PHON ST ZIP4 Code Type VARCHAR2(60) VARCHAR2(60) NUMBER(9) VARCHAR2(40) VARCHAR2(40) VARCHAR2(20) VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) ADR1 ADR2 ADRID CITY EMAIL FAX PHON ST ZIP4 P No No Yes No No No No No No M No No Yes No No No No No No Label First line of the street address Second line of the street address Adress idenification number. City Electronic mail address FAX number Telephone Number. State ZIP code plus 4 Index List Index Code PK_ADDRESS PowerDesigner P Yes F No A No U Yes C No 2/21/02 Column Code ADRID Sort ASC Page 15 Physical Data Model Model_1 TABLE: AMS_PROCESSING_STATUS Column List Name CURRENT_COUNT END_DT EXCEPTION_TEXT KILL_PROCESS PROCESS_NAME START_COUNT START_DT STATUS USER_ID Code CURRENT_COUNT END_DT EXCEPTION_TEXT KILL_PROCESS PROCESS_NAME START_COUNT START_DT STATUS USER_ID Type NUMBER(9) DATE VARCHAR2(255) VARCHAR2(1) VARCHAR2(64) NUMBER(9) DATE VARCHAR2(1) VARCHAR2(12) P No No No No Yes No No No Yes M No No No No Yes No No No Yes Label AMS - Current Count AMS - End date Text describing an exception. AMS - Killl Process indicator (Y = Kill or N) AMS - Process Name AMS - Start Count AMS - Start Date Status of the process/job. User's Identifier Index List Index Code PK_AMS_PROCESSING_STATUS P Yes F No A No U Yes C No Column Code PROCESS_NAME USER_ID Sort ASC ASC TABLE: AMS_SYSTEM_AUDIT Column List Name AMS_ACTION AMS_COLUMN AMS_COMMENTS AMS_TABLE COMPUTER_NAME DT_DATE IP_ADDRESS ROW_ID USER_ID PowerDesigner Code AMS_ACTION AMS_COLUMN AMS_COMMENTS AMS_TABLE COMPUTER_NAME DT_DATE IP_ADDRESS ROW_ID USER_ID Type VARCHAR2(32) VARCHAR2(32) VARCHAR2(255) VARCHAR2(32) VARCHAR2(128) DATE VARCHAR2(2000) NUMBER(9) VARCHAR2(32) 2/21/02 P No No No No No No No Yes No M No No No No No No No Yes No Label AMS - Action AMS - Column AMS - Comments AMS - Table AMS - Computer name AMS - J M needs to describe this field. AMS - IP Address AMS - Row Id AMS - User Identifier. Page 16 Physical Data Model Model_1 Index List Index Code IX_ASA_DT_DATE PK_AMS_SYSTEM_AUDIT P No Yes F No No A No No U No Yes C No No Column Code DT_DATE ROW_ID Sort ASC ASC TABLE: AMS_SYSTEM_PARMS Column List Name NUM_PARM PARAM_NAME PARM_DESC PARM_EFFECT_DATE STR_PARM Code NUM_PARM PARAM_NAME PARM_DESC PARM_EFFECT_DATE STR_PARM Type NUMBER(9) VARCHAR2(128) VARCHAR2(255) DATE VARCHAR2(128) P No Yes No No No M No Yes No No No Label AMS - Number of parameters. AMS - Parameter Name AMS - Parameter Description AMS - Parameter Effective Date AMS - Index List Index Code PK_AMS_SYSTEM_PARMS P Yes F No A No U Yes C No Column Code PARAM_NAME Sort ASC TABLE: AUDIT_ACRONYMS Column List Name A_DESC ACRONYM ACTION EFFECT_DT MODIFIED STANDS_FOR USER_AUDIT PowerDesigner Code A_DESC ACRONYM ACTION EFFECT_DT MODIFIED STANDS_FOR USER_AUDIT Type VARCHAR2(255) VARCHAR2(32) VARCHAR2(2) DATE DATE VARCHAR2(255) VARCHAR2(30) 2/21/02 P No No No No No No No M No No No No No No No Label Audit - Description Audit - Acronym Audit - Action Audit - Effective Date Audit - Modified Date Audit - Definition of the Acronym. Audit - User Audit Page 17 Physical Data Model Model_1 TABLE: AUDIT_ADDRESS Column List Name ACTION ADR1 ADR2 ADRID CITY EMAIL FAX MODIFIED PHON ST USER_AUDIT ZIP4 Code ACTION ADR1 ADR2 ADRID CITY EMAIL FAX MODIFIED PHON ST USER_AUDIT ZIP4 Type VARCHAR2(2) VARCHAR2(60) VARCHAR2(60) NUMBER(9) VARCHAR2(40) VARCHAR2(40) VARCHAR2(20) DATE VARCHAR2(20) VARCHAR2(2) VARCHAR2(30) VARCHAR2(10) P No No No No No No No No No No No No M No No No No No No No No No No No No Label Audit - Action Audit - Filing Street 1 Audit - Filing Street 2 Audit - Adress idenification number. Audit - City Audit - E-Mail address Audit - FAX number Audit - Modified Date Audit - Phone Number. Audit - State Audit Audit - zipcode. Type DATE NUMBER(9) VARCHAR2(200) VARCHAR2(2) VARCHAR2(50) P No Yes No No No M Yes Yes Yes Yes No Label Ballot measure election date Filer's unique identification number. Ballot measure full name Ballot measure number Ballot measure short name TABLE: BALLOT_MEASURES Column List Name ELECTION_DATE FILER_ID MEASURE_NAME MEASURE_NO MEASURE_SHORT_NAM E Code ELECTION_DATE FILER_ID MEASURE_NAME MEASURE_NO MEASURE_SHORT_NAM E Index List Index Code IX_BM_ELECTION_DATE PK_BALLOT_MEASURES PowerDesigner P No Yes F No No A No No U No Yes C No No 2/21/02 Column Code ELECTION_DATE FILER_ID Sort ASC ASC Page 18 Physical Data Model Model_1 TABLE: CAL_FILE Column List Name Code CAL_FILE FILING_ID FILING_SEQUENCE Type CLOB(4000) NUMBER(9) NUMBER(9) CAL_FILE FILING_ID FILING_SEQUENCE P No Yes Yes M No Yes Yes Label CAL File contents Unique filing identification number. Amendment number where 0 is an original filing and 1 to 999 are amendments. Index List Index Code IX_CF_FILING_ID PK_CAL_FILE P No Yes F No No A No No U No Yes C No No Column Code FILING_ID FILING_ID FILING_SEQUENCE Sort ASC ASC ASC TABLE: CAMPAIGN_AMENDMENT_INFO Column List Name ALLOC_CB AMEND_ID Code ALLOC_CB AMEND_ID Type VARCHAR2(1) NUMBER(9) P No Yes M No Yes AMEND_TXT1 COVER_CB EXEC_DATE FILING_ID FORM_TYPE FROM_DATE LINE_ITEM PARTS_CB PARTS_LST REC_TYPE SCHED_CB SCHED_LST AMEND_TXT1 COVER_CB EXEC_DATE FILING_ID FORM_TYPE FROM_DATE LINE_ITEM PARTS_CB PARTS_LST REC_TYPE SCHED_CB SCHED_LST VARCHAR2(330) VARCHAR2(1) DATE NUMBER(9) VARCHAR2(4) DATE NUMBER(9) VARCHAR2(1) VARCHAR2(40) VARCHAR2(4) VARCHAR2(1) VARCHAR2(40) No No No Yes Yes No Yes No No Yes No No No No No Yes Yes No Yes No No Yes No No PowerDesigner 2/21/02 Label Allocation page is amended check-box Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Description of changes to the filing. Cover page is amended check-box Date this amendment executed on Unique filing identification number. Form Type (must equal form_type in CVR) Reporting period from date of original report Record line item number. Part(s) are amended check-box List of amended parts Record Type Value: F405 Schedules are amended check-box List of amended schedules Page 19 Physical Data Model Name SUMPG_CB THRU_DATE Model_1 Code SUMPG_CB THRU_DATE Type VARCHAR2(1) DATE P No No M No No Label Summary page is amended check-box Reporting period to/through date of original Index List Index Code PK_CAMPAIGN_AMENDMENT_INFO P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: CARES_GROUPS Column List Name GROUP_ID NAME Code GROUP_ID NAME Type NUMBER(16) VARCHAR2(64) P Yes No M Yes No Label Index List Index Code PK_CARES_GROUPS P Yes F No A No U Yes C No Column Code GROUP_ID Sort ASC TABLE: CARES_USERS Column List Name FAILED_LOGONS GLOBAL_ADMIN GROUP_ID LOCAL_ADMIN LOCKED_OUT PowerDesigner Code FAILED_LOGONS GLOBAL_ADMIN GROUP_ID LOCAL_ADMIN LOCKED_OUT Type NUMBER(16) VARCHAR2(1) NUMBER(16) VARCHAR2(1) VARCHAR2(1) 2/21/02 P No No No No No M No No No No No Label Page 20 Physical Data Model Name PASSWORD_CHANGED_ ON PASSWORD_HASH USER_ID USER_NAME Model_1 Code PASSWORD_CHANGED_ ON PASSWORD_HASH USER_ID USER_NAME DATE Type P No M No VARCHAR2(64) NUMBER(16) VARCHAR2(32) No Yes No No Yes No Label Index List Index Code PK_CARES_USERS P Yes F No A No U Yes C No Column Code USER_ID Sort ASC TABLE: CASH_RECON_REPORT_WRK Column List Name DAY_OF_MONTH USER_ID YEAR_MONTH Code DAY_OF_MONTH USER_ID YEAR_MONTH Type DATE VARCHAR2(12) NUMBER(9) P Yes Yes Yes M Yes Yes Yes Label Day of the month User Identifier. YEAR_MONTH Index List Index Code PK_CASH_RECON_REPORT_WRK P Yes F No A No U Yes C No Column Code USER_ID YEAR_MONTH DAY_OF_MONTH Sort ASC ASC ASC TABLE: CHECK_OUT_STATUS Column List Name CHK_OUT_DT ITEM_ID ITEM_TYPE PowerDesigner Code CHK_OUT_DT ITEM_ID ITEM_TYPE Type DATE NUMBER(9) NUMBER(9) P No Yes Yes 2/21/02 M No Yes Yes Label Check out status ITEM_ID Type of item. Page 21 Physical Data Model Model_1 Name USER_ID Code Type VARCHAR2(32) USER_ID P No M No Label User Identifier. Index List Index Code PK_CHECK_OUT_STATUS P Yes F No A No U Yes C No Column Code ITEM_ID ITEM_TYPE Sort ASC ASC TABLE: CODE_LIST Column List Name CODE CODE_DESC CODE_ID CODE_TYPE Code CODE CODE_DESC CODE_ID CODE_TYPE Type VARCHAR2(10) VARCHAR2(32) NUMBER(9) NUMBER(9) P Yes No No Yes M Yes No No Yes DESCRIPTION DESCRIPTION VARCHAR2(128) No No Label The text value of the code. Short description of the code Code's identification number. The type of code. This type is used for grouping codes. Reserved for future use. Long description of the code Index List Index Code PK_CODE_LIST P Yes F No A No U Yes C No Column Code CODE_TYPE CODE Sort ASC ASC TABLE: CORRESPONDENCE Column List Name COR_GRP COR_ID COR_TEXT COR_TITLE PowerDesigner Code COR_GRP COR_ID COR_TEXT COR_TITLE Type NUMBER(9) NUMBER(9) BLOB(4000) VARCHAR2(255) 2/21/02 P No Yes No No M No Yes No No Label Correspondence Group Correspondence identification number. Correspondence text. Correspondence title. Page 22 Physical Data Model Name COR_TYPE COR_XREF PLAIN_TEXT Model_1 Code COR_TYPE COR_XREF PLAIN_TEXT Type NUMBER(9) VARCHAR2(9) VARCHAR2(4000) P No No No M No No No Label Correspondence type. Correspondence cross reference. Plain Text Index List Index Code PK_CORRESPONDENCE P Yes F No A No U Yes C No Column Code COR_ID Sort ASC TABLE: CORRESPONDENCE_PREFERENCES Column List Name Code Type BOTTOMMARGIN BOTTOMMARGIN NUMBER(9) DISPLAYONLY DISPLAYONLY NUMBER(1) HEADER HEADER NUMBER(1) HSCROLLBAR HSCROLLBAR NUMBER(1) INPUTFIELDBACKCOLOR INPUTFIELDBACKCOLOR NUMBER(9) INPUTFIELDNAMESVISIB INPUTFIELDNAMESVISIB NUMBER(1) LE LE INPUTFIELDSVISIBLE INPUTFIELDSVISIBLE NUMBER(1) LEFTMARGIN LEFTMARGIN NUMBER(9) PICTUREFRAME PICTUREFRAME NUMBER(1) RETURNSVISIBLE RETURNSVISIBLE NUMBER(1) RIGHTMARGIN RIGHTMARGIN NUMBER(9) RULERBAR RULERBAR NUMBER(1) SPACESVISIBLE SPACESVISIBLE NUMBER(1) TABBAR TABBAR NUMBER(1) TABSVISIBLE TABSVISIBLE NUMBER(1) TOOLBAR TOOLBAR NUMBER(1) TOPMARGIN TOPMARGIN NUMBER(9) UNDODEPTH UNDODEPTH NUMBER(9) USER_GRP USER_GRP VARCHAR2(32) VSCROLLBAR VSCROLLBAR NUMBER(1) WORDWRAP WORDWRAP NUMBER(1) PowerDesigner 2/21/02 P No No No No No No M No No No No No No No No No No No No No No No No No No Yes No No No No No No No No No No No No No No Yes No No Label Bottom Margin INPUTFIELDBACKCOLOR INPUTFIELDNAMESVISIBLE INPUTFIELDSVISIBLE LEFTMARGIN RETURNSVISIBLE RIGHTMARGIN RULERBAR Spaces visable flag. TABSVISIBLE TOOLBAR TOPMARGIN UNDODEPTH USER_GRP Vertical Scrollbar Word wrap flag. Page 23 Physical Data Model Model_1 Index List Index Code PK_CORRESPONDENCE_PREFERENCES P Yes F No A No U Yes C No Column Code USER_GRP Sort ASC TABLE: CVR_CAMPAIGN_DISCLOSURE Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes AMENDEXP_1 AMENDEXP_2 AMENDEXP_3 ASSOC_CB AMENDEXP_1 AMENDEXP_2 AMENDEXP_3 ASSOC_CB VARCHAR2(100) VARCHAR2(100) VARCHAR2(100) VARCHAR2(1) No No No No No No No No ASSOC_INT BAL_ID BAL_JURIS BAL_NAME ASSOC_INT BAL_ID BAL_JURIS BAL_NAME VARCHAR2(90) VARCHAR2(9) VARCHAR2(40) VARCHAR2(200) No No No No No No No No BAL_NUM BRDBASE_YN BAL_NUM BRDBASE_YN VARCHAR2(3) VARCHAR2(1) No No No No BUS_ADR1 BUS_ADR1 VARCHAR2(55) No No BUS_ADR2 BUS_ADR2 VARCHAR2(55) No No BUS_CITY BUS_INTER BUS_NAME BUS_ST BUS_ZIP4 BUSACT_CB BUS_CITY BUS_INTER BUS_NAME BUS_ST BUS_ZIP4 BUSACT_CB VARCHAR2(30) VARCHAR2(40) VARCHAR2(200) VARCHAR2(2) VARCHAR2(10) VARCHAR2(1) No No No No No No No No No No No No BUSACTVITY CAND_ADR1 BUSACTVITY CAND_ADR1 VARCHAR2(90) VARCHAR2(55) No No No No PowerDesigner 2/21/02 Label Amendment number (0-999). Amendment number 0 is reserved for origninal filings. Amendment explanation line 1. Amendment explanation line 2. Amendment explanation line 3. Association Interests info included check-box. Legal values are 'X' and null. Description of association interests. Jurisdiction of ballot measure. Ballot measure name. Applies to the forms 460, 465, and 496. For KDE filings of the 496, this field contains the ballot measure identification number. Ballot measure number or letter. Broad Base Committee (yes/no) check box. Legal values are 'Y' or 'N'. First line of the employer/business street address. Applies to the form 461. Second line of the employer/business street address. Applies to the form 461. Employer/business address city Employer/business interest description. Name of employer/business. Applies to the form 461. Employer/business address state. Employer/business address zip code. Business activity info included check-box. Valid values are 'X' and null. Business activity description. First line of the candidate/officeholder's street address. Page 24 Physical Data Model Model_1 Name Code Type P M CAND_ADR2 CAND_ADR2 VARCHAR2(55) No No CAND_CITY CAND_EMAIL CAND_CITY CAND_EMAIL VARCHAR2(30) VARCHAR2(60) No No No No CAND_FAX CAND_FAX VARCHAR2(20) No No CAND_ID CAND_NAMF CAND_NAML CAND_ID CAND_NAMF CAND_NAML VARCHAR2(9) VARCHAR2(45) VARCHAR2(200) No No No No No No CAND_NAMS CAND_NAMT CAND_PHON CAND_ST CAND_ZIP4 CMTTE_ID CAND_NAMS CAND_NAMT CAND_PHON CAND_ST CAND_ZIP4 CMTTE_ID VARCHAR2(10) VARCHAR2(10) VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) VARCHAR2(9) No No No No No No No No No No No No CMTTE_TYPE CMTTE_TYPE VARCHAR2(1) No No CONTROL_YN CONTROL_YN VARCHAR2(1) No No DIST_NO DIST_NO VARCHAR2(3) No No ELECT_DATE EMPLBUS_CB ELECT_DATE EMPLBUS_CB DATE VARCHAR2(1) No No No No EMPLOYER EMPLOYER VARCHAR2(200) No No ENTITY_CD ENTITY_CD VARCHAR2(3) No No FILE_EMAIL FILER_ADR1 FILER_ADR2 FILER_CITY FILER_FAX FILER_ID FILE_EMAIL FILER_ADR1 FILER_ADR2 FILER_CITY FILER_FAX FILER_ID VARCHAR2(60) VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(20) VARCHAR2(9) No No No No No No No No No No No No PowerDesigner 2/21/02 Label Applies to form 460, 465, and 496. Second line of the candidate/officeholder's street address. Candidate/Officeholder's City Candidate/Officeholder's EMail address. This field is not contained on the forms. Candidate/Officeholder's FAX phone number. This field is not contained on the forms. Candidate/officeholder's first name. Candidate/officeholder's last name. Applies to forms 460, 465, and 496. Candidate/officeholder's name suffix. Candidate/officeholder's name prefix or title. Candidate/Officeholder's phone number. Candidate/Officeholder's State Candidate/Officeholder's ZIP code. Committee ID (Filer_id) of recipient Committee who's campaign statement is attached. This field applies to the form 401. Type of Recipient Committee. Applies to the 450/460. See the CAL docuement for a list of legal values. Controlled Committee (yes/no) check box. Legal values are 'Y' or 'N'. District number for the office being sought. Populated for Senate, Assembly, or Board of Equalization races. Date of the General Election Employer/Business Info included check-box. Legal values are 'X' or null. Applies to the Form 461. Employer. This field is most likely unused. W. Cox 5/1/2000. The entity type of the filer. These codes vary by form type. See the CAL document for the list of legal values for each form type. Filer's Email address. First line of the filer's address Second line of the filer's address. City portion of the filer's address. FAX phone number Filer's unique identification number. Page 25 Physical Data Model Model_1 Name FILER_NAMF FILER_NAML Code FILER_NAMF FILER_NAML Type VARCHAR2(45) VARCHAR2(200) P No No M No No FILER_NAMS FILER_NAMS VARCHAR2(10) No No FILER_NAMT FILER_NAMT VARCHAR2(10) No No FILER_PHON FILER_ST FILER_ZIP4 FILING_ID FORM_TYPE FILER_PHON FILER_ST FILER_ZIP4 FILING_ID FORM_TYPE VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) NUMBER(9) VARCHAR2(4) No No No Yes No No No No Yes No FROM_DATE JURIS_CD FROM_DATE JURIS_CD DATE VARCHAR2(3) No No No No JURIS_DSCR JURIS_DSCR VARCHAR2(40) No No LATE_RPTNO LATE_RPTNO VARCHAR2(30) No No MAIL_ADR1 MAIL_ADR1 VARCHAR2(55) No No MAIL_ADR2 MAIL_CITY MAIL_ST MAIL_ZIP4 OCCUPATION MAIL_ADR2 MAIL_CITY MAIL_ST MAIL_ZIP4 OCCUPATION VARCHAR2(55) VARCHAR2(30) VARCHAR2(2) VARCHAR2(10) VARCHAR2(60) No No No No No No No No No No OFF_S_H_CD OFF_S_H_CD VARCHAR2(1) No No OFFIC_DSCR OFFIC_DSCR VARCHAR2(40) No No OFFICE_CD OFFICE_CD VARCHAR2(3) No No OTHER_CB OTHER_CB VARCHAR2(1) No No OTHER_INT OTHER_INT VARCHAR2(90) No No PowerDesigner 2/21/02 Label Filer's First Name(s) if the filer is an individual. The committee's or organization's name or if an individual the filer's last name. The filer's suffix that follows their name if they are an individual. The filer's prefix or title that preceeds their name if they are an individual. Phone number of filing entity Filing entity's state portion of their address. ZIP Code plus four for for the filing entity. Unique filing identification number for the filing. Type of form being filed (Legal values are: F401, F450, F460, F461, F425, F465, F496, F497, and F498) Reporting period from date Office jurisdiction code. See the CAL document for the list of legal values. Office Jurisdiction description if the field JURIS_CD is set to city (CIT), county (CTY), local (LOC), or other (OTH). Identifying Report Number used to distinguish multiple reports filed during the same filing period. For example, this field allows for multiple form 497s to be filed on the same day. First line of the filer's mailing address. Required if different than the filer's street address. Second line of the filer's mailing address. City portion of filer's mailing address. State portion of filer's mailing address. Zipcode portion of the entities mailing address. Occupation. This field is most likely unused. W. Cox 5/1/2000. Office Sought/Held Code. Legal values are "S" for sought and "H" for held. Office sought description if the field OFFICE_CD is set to other (OTH). Code that identifies the office being sought. See the CAL document for a list of valid codes. Other entity interests info included check-box. Legal values are 'X' and null. Other entity interests description. Page 26 Physical Data Model Model_1 Name PRIMFRM_YN Code PRIMFRM_YN Type VARCHAR2(1) P No M No REC_TYPE REPORT_NUM REC_TYPE REPORT_NUM VARCHAR2(3) VARCHAR2(3) No No No No REPORTNAME REPORTNAME VARCHAR2(3) No No RPT_ATT_CB RPT_ATT_CB VARCHAR2(1) No No RPT_DATE RPTFROMDT RPT_DATE RPTFROMDT DATE DATE No No No No RPTTHRUDT RPTTHRUDT DATE No No SELFEMP_CB SELFEMP_CB VARCHAR2(1) No No SPONSOR_YN SPONSOR_YN VARCHAR2(1) No No STMT_TYPE STMT_TYPE VARCHAR2(2) No No SUP_OPP_CD SUP_OPP_CD VARCHAR2(1) No No THRU_DATE TRES_ADR1 THRU_DATE TRES_ADR1 DATE VARCHAR2(55) No No No No TRES_ADR2 TRES_ADR2 VARCHAR2(55) No No TRES_CITY TRES_CITY VARCHAR2(30) No No TRES_EMAIL TRES_FAX TRES_NAMF TRES_NAML TRES_NAMS TRES_NAMT TRES_PHON TRES_ST TRES_EMAIL TRES_FAX TRES_NAMF TRES_NAML TRES_NAMS TRES_NAMT TRES_PHON TRES_ST VARCHAR2(60) VARCHAR2(20) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(20) VARCHAR2(2) No No No No No No No No No No No No No No No No TRES_ZIP4 TRES_ZIP4 VARCHAR2(10) No No PowerDesigner 2/21/02 Label Primarily Formed Committee (yes/no) checkbox. Legal values are 'Y' or 'N'. Record Type (Always CVR) Amendment Number as reported by the filer (000-999). Report Number 000 represents an original filing. Attached campaign disclosure statement type. Legal values are 450, 460, and 461. Committee Report Attached check-box. Legal values are 'X' or null. This field applies to the form 401. Date this report is filed according to the filer. Attached campaign disclosure statement - Period from date. Attached campaign disclosure statement - Period Through date. Self-employed checkbox. This field is most likely unused. W. Cox 5/1/2000. Sponsored Committee (yes/no) checkbox. Legal values are 'Y' or 'N'. Type of statement. The legal values for the statement type vary by form. See the CAL document for a description of the legal values by form type. Support/oppose code. Legal values are "S" for support or "O" for oppose. Reporting period through date. First line of the treasurer or responsible officer's street address. Second line of the treasurer or responsible officer's street address. City portion of the treasurer or responsible officer's street address. Treasurer or responsible officer's email address. Treasurer or responsible officer's FAX phone number. Treasurer or responsible officer's first name. Treasurer or responsible officer's last name. Treasurer or responsible officer's suffix. Treasurer or responsible officer's prefix or title. Treasurer or responsible officer's phone number. State portion of the treasurer or responsible officer's address. Zip code portion of the treasurer or responsible officer's Page 27 Physical Data Model Model_1 Name Code Type P M Label address. Index List Index Code IX_CCD_AMEND_ID IX_CCD_BAL_ID IX_CCD_CAND_ID IX_CCD_FILER_ID IX_CCD_FILER_NAML IX_CCD_FILING_ID IX_CCD_FORM_TYPE IX_CCD_FROM_DATE IX_CCD_OFFICE_CD IX_CCD_REC_TYPE IX_CCD_RPT_DATE IX_CCD_THRU_DATE IX_CVR_CAMP_DISC_BAL_NAME IX_CVR_CAMP_DISC_CAND_NAML PK_CVR_CAMPAIGN_DISCLOSURE P No No No No No No No No No No No No No No Yes F No No No No No Yes No No No No No No No No No A No No No No No No No No No No No No No No No U No No No No No No No No No No No No No No Yes C No No No No No No No No No No No No No No No Column Code AMEND_ID BAL_ID CAND_ID FILER_ID FILER_NAML FILING_ID FORM_TYPE FROM_DATE OFFICE_CD REC_TYPE RPT_DATE THRU_DATE BAL_NAME CAND_NAML FILING_ID AMEND_ID Sort ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC TABLE: CVR_E530 Column List Name AMEND_ID CAND_NAMF CAND_NAML CAND_NAMS CAND_NAMT DISTRICT_CD EMPLOYER ENTITY_CD FILER_ADR1 FILER_ADR2 FILER_CITY PowerDesigner Code AMEND_ID CAND_NAMF CAND_NAML CAND_NAMS CAND_NAMT DISTRICT_CD EMPLOYER ENTITY_CD FILER_ADR1 FILER_ADR2 FILER_CITY Type NUMBER(9) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) NUMBER(9) VARCHAR2(400) VARCHAR2(3) VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) 2/21/02 P Yes No No No No No No No No No No M Yes No No No No No No No No No No Label Page 28 Physical Data Model Name FILER_NAMF FILER_NAML FILER_NAMS FILER_NAMT FILER_ST FILER_ZIP4 FILING_ID FORM_TYPE OCCUPATION OFFICE_CD OTHER_DESC PMNT_AMOUNT PMNT_DT REC_TYPE REPORT_NUM RPT_DATE TYPE_BILLBOARDS TYPE_IT TYPE_LITERATURE TYPE_OTHER TYPE_PRINTADS TYPE_RADIO TYPE_TV Model_1 Code FILER_NAMF FILER_NAML FILER_NAMS FILER_NAMT FILER_ST FILER_ZIP4 FILING_ID FORM_TYPE OCCUPATION OFFICE_CD OTHER_DESC PMNT_AMOUNT PMNT_DT REC_TYPE REPORT_NUM RPT_DATE TYPE_BILLBOARDS TYPE_IT TYPE_LITERATURE TYPE_OTHER TYPE_PRINTADS TYPE_RADIO TYPE_TV Type VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(2) VARCHAR2(10) NUMBER(9) VARCHAR2(4) VARCHAR2(400) NUMBER(9) VARCHAR2(400) NUMBER(12,2) DATE VARCHAR2(3) VARCHAR2(3) DATE CHAR(1) CHAR(1) CHAR(1) CHAR(1) CHAR(1) CHAR(1) CHAR(1) P No No No No No No Yes No No No No No No No No No No No No No No No No M No No No No No No Yes No No No No No No No No No No No No No No No No Label Index List Index Code IX_CVR_E530_AMEND_ID IX_CVR_E530_CAND_NAMF IX_CVR_E530_CAND_NAML IX_CVR_E530_FILING_ID PK_CVR_E530 P No No No No Yes F No No No Yes No A No No No No No U No No No No Yes C No No No No No Column Code AMEND_ID CAND_NAMF CAND_NAML FILING_ID FILING_ID AMEND_ID Sort ASC ASC ASC ASC ASC ASC TABLE: CVR_F470 Column List PowerDesigner 2/21/02 Page 29 Physical Data Model Model_1 Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes CAND_ADR1 CAND_ADR2 CAND_CITY CAND_EMAIL CAND_ADR1 CAND_ADR2 CAND_CITY CAND_EMAIL VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(60) No No No No No No No No CAND_FAX CAND_FAX VARCHAR2(20) No No CAND_PHON CAND_ST CAND_ZIP4 DATE_1000 CAND_PHON CAND_ST CAND_ZIP4 DATE_1000 VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) DATE No No No No No No No No DIST_NO DIST_NO VARCHAR2(3) No No ELECT_DATE ELECT_DATE DATE No No ENTITY_CD ENTITY_CD VARCHAR2(3) No No FILER_ID FILER_NAMF FILER_NAML FILER_NAMS FILER_NAMT FILER_ID FILER_NAMF FILER_NAML FILER_NAMS FILER_NAMT VARCHAR2(9) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) No No No No No No No No No No FILING_ID FORM_TYPE FILING_ID FORM_TYPE NUMBER(9) VARCHAR2(4) Yes Yes Yes Yes JURIS_CD JURIS_CD VARCHAR2(3) No No JURIS_DSCR JURIS_DSCR VARCHAR2(40) No No OFF_S_H_CD OFF_S_H_CD VARCHAR2(1) No No OFFIC_DSCR OFFIC_DSCR VARCHAR2(40) No No OFFICE_CD OFFICE_CD VARCHAR2(3) No No PowerDesigner 2/21/02 Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. First line of the filer's street address. Second line of the filer's street address. Candidate/Officeholder's City. Candidate/Officeholder's EMail address. Not required by the form. Candidate/Officeholder's FAX Phone Number. Not required by the form. Candidate/Officeholder's phone number. Filer's State Filer's zipcode Date contributions totaling $1,000 or more. (For the 470-S) District number for the office being sought. Populated for Senate, Assembly, or Board of Equalization races. Date of the general election. Required for filings in even years. The filer's entity code. The value of this column will always be Candidate/Office Holder (CAO) for this table. Filer's unique identification number. Filer's First Name(s) - required for individuals Filer's Last Name/Committee name Filer's Name Suffix The filer's prefix or title that preceeds their name if they are an individual. Unique filing identification number. Type of Filing or Formset. The value of this column will always be equal to F470. Office Jurisdiction Code. The legal values are Senate (SEN), Assembly (ASM), Board of Equalization (BOE), City (CIT), County (CTY), Local (LOC) and Other (OTH). Office jurisdiction description text reqired if the jurisdiction code (Juris_cd) is equal to CIT, CTY, LOC, or OTH. Office Sought/Held code. Legal values are "S" for sought and "H" for held. Office sought description used if the office code is other (OTH). Code that identifies the office being sought. See the Page 30 Physical Data Model Model_1 Name Code Type P M REC_TYPE REC_TYPE VARCHAR2(3) Yes Yes REPORT_NUM REPORT_NUM VARCHAR2(3) No No RPT_DATE RPT_DATE DATE No No Label CAL document for a list of valid codes. Type of CAL record. This column will always contain CVR. Report Number; 000 Original; 001-999 Amended as reported in the filing. Date this report is filed as reported by the filer. Index List Index Code PK_CVR_F470 P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC TABLE: CVR_LOBBY_DISCLOSURE Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes CTRIB_N_CB CTRIB_N_CB VARCHAR2(1) No No CTRIB_Y_CB CTRIB_Y_CB VARCHAR2(1) No No CUM_BEG_DT ENTITY_CD CUM_BEG_DT ENTITY_CD DATE VARCHAR2(3) No No No No FILER_ID FILER_ID VARCHAR2(9) No No FILER_NAMF FILER_NAML FILER_NAMS FILER_NAMF FILER_NAML FILER_NAMS VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) No No No No No No PowerDesigner 2/21/02 Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. "Campaign Contributions? None" Check-box. Used for form rendering. Legal values are "X" and null. (Applies to 625/635/645). "Campaign Contributions? P4 attached" Check-box. Used for form rendering. Legal values are "X" and null. (Applies to 625/635/645) Cumulative period beginning date Entity code of the filer who is the subject of the report. See the CAL document for legal code values for this column. Identification number of filer who is the subject of the report. (E.g Lobbyist's ID for the 615 or the Firm's ID for the 625) Filer's First Name(s) - required for persons Filer's Last Name or full name of the business entity. Filer's name suffix Page 31 Physical Data Model Model_1 Name FILER_NAMT Code FILER_NAMT Type VARCHAR2(10) P No M No FILING_ID FIRM_ADR1 FILING_ID FIRM_ADR1 NUMBER(9) VARCHAR2(55) Yes No Yes No FIRM_ADR2 FIRM_ADR2 VARCHAR2(55) No No FIRM_CITY FIRM_ID FIRM_NAME FIRM_PHON FIRM_ST FIRM_ZIP4 FORM_TYPE FIRM_CITY FIRM_ID FIRM_NAME FIRM_PHON FIRM_ST FIRM_ZIP4 FORM_TYPE VARCHAR2(30) VARCHAR2(9) VARCHAR2(200) VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) VARCHAR2(4) No No No No No No Yes No No No No No No Yes FROM_DATE LBY_ACTVTY FROM_DATE LBY_ACTVTY DATE VARCHAR2(400) No No No No LOBBY_N_CB LOBBY_N_CB VARCHAR2(1) No No LOBBY_Y_CB LOBBY_Y_CB VARCHAR2(1) No No MAIL_ADR1 MAIL_ADR1 VARCHAR2(55) No No MAIL_ADR2 MAIL_ADR2 VARCHAR2(55) No No MAIL_CITY MAIL_CITY VARCHAR2(30) No No MAIL_PHON MAIL_ST MAIL_PHON MAIL_ST VARCHAR2(20) VARCHAR2(2) No No No No MAIL_ZIP4 MAIL_ZIP4 VARCHAR2(10) No No MAJOR_NAMF MAJOR_NAMF VARCHAR2(45) No No MAJOR_NAML MAJOR_NAML VARCHAR2(200) No No PowerDesigner 2/21/02 Label The filer's prefix or title that preceeds their name if they are an individual. Unique filing identification number for the filing. First line of the Firm/Employer/Coalition or business's address. Second line of the Firm/Employer/Coalition or business's address. Firm/Employer/Coalition or business's city Identification number of the Firm/Employer/Coalition. Name of Firm/Employer/Coalition Firm, employer, coalition or business phone number. Firm/Employer/Coalition or business's state. Firm, employer, coalition or business's zip code. Type of filing or formset with legal values of F615, F625, F635, F645. This field identifies the specific type of form contained within the filing. Reporting period from date Description of lobbying activity. Applies to the Form 635/645. Additional description may be provided by the filer using text records. "Lobby Coalition - None" check-box. Used for form rendering. Legal values are "X" and null. (Applies only to 625) "Lobby Coalition - F630 Attached" check-box. Used for form rendering. Legal values are "X" and null. (Applies only to 625) First line of the filer's mailing address (if different than the street address). Second line of the filer's mailing address (if different than the street address). City portion of the filer's mailing address (if different than the street address). Unused field carried in the CAL interface. Cox 5/4/2000 State portion of the filer's mailing address (if different than the street address). Zip code portion of the filer's mailing address (If different than the street address). Major Donor First Name if an individual. (Applies to 625, 635, and 645) Major donor last name or business name (Applies to Page 32 Physical Data Model Name Model_1 Code Type P M MAJOR_NAMS MAJOR_NAMS VARCHAR2(10) No No MAJOR_NAMT MAJOR_NAMT VARCHAR2(10) No No NOPART1_CB NOPART1_CB VARCHAR2(1) No No NOPART2_CB NOPART2_CB VARCHAR2(1) No No PART1_1_CB PART1_1_CB VARCHAR2(1) No No PART1_2_CB PART1_2_CB VARCHAR2(1) No No PRN_NAMF PRN_NAML PRN_NAMS PRN_NAMT RCPCMTE_ID PRN_NAMF PRN_NAML PRN_NAMS PRN_NAMT RCPCMTE_ID VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(9) No No No No No No No No No No RCPCMTE_NM REC_TYPE REPORT_NUM RCPCMTE_NM REC_TYPE REPORT_NUM VARCHAR2(200) VARCHAR2(3) VARCHAR2(3) No Yes No No Yes No RPT_DATE SENDER_ID RPT_DATE SENDER_ID DATE VARCHAR2(9) No No No No SIG_DATE SIG_LOC SIG_NAMF SIG_DATE SIG_LOC SIG_NAMF DATE VARCHAR2(45) VARCHAR2(45) No No No No No No SIG_NAML SIG_NAML VARCHAR2(200) No No SIG_NAMS SIG_NAMT SIG_NAMS SIG_NAMT VARCHAR2(10) VARCHAR2(10) No No No No PowerDesigner 2/21/02 Label 625, 635, and 645) Major donor suffix if an individual. (Applies to 625, 635, and 645) Major donor prefix or title if an individual. (Applies to 625, 635, and 645) "No part I information" check-box. Used for form rendering. Legal values are "X" and null. (Applies only to 615) "No part II information" check-box. Used for form rendering. Legal values are "X" and null. (Applies only to 615) "Partners, Owners, ... Form 615 Attached". Used for form rendering. Legal values are "X" and null. (Applies only to 625) "Partners, Owners, ... Listed Below". Used for form rendering. Legal values are "X" and null. (Applies only to 625) Signer "as signed" first name. Used for form rendering. Signer "as signed" last name. Used for form rendering. Signer "as signed" suffix Signer "as signed" prefix or title Recipient Commitee or Major donor identification number. Recipient Commitee Name Record Type Value. This will always be CVR. Report Number; 000 Original; 001-999 Amended (as reported by the filer) Date this report is filed (as reported by the filer) Identification number of lobbyist entity that is submitting this report. This field is used to authenticate the filer and allows the firm to submit filings for their lobbyists. Date when signed. Used for form rendering. City and State where signed. Used for form rendering. Signer's "as signed" first name. Used for form rendering. Signer's "as signed" Last Name. Used for form rendering. Signer's "as signed" suffix. Used for form rendering. Signer's "as signed" prefix or title. Used for form rendering. Page 33 Physical Data Model Name SIG_TITLE THRU_DATE Model_1 Code SIG_TITLE THRU_DATE Type VARCHAR2(45) DATE P No No M No No Label Title of signer Reporting period through date. Index List Index Code IX_CLD_AMEND_ID IX_CLD_FILER_ID IX_CLD_FILING_ID IX_CLD_FORM_TYPE IX_CLD_FROM_DT IX_CLD_REC_TYPE IX_CLD_THRU_DT PK_CVR_LOBBY_DISCLOSURE P No No No No No No No Yes F No No Yes No No No No No A No No No No No No No No U No No No No No No No Yes C No No No No No No No No Column Code AMEND_ID FILER_ID FILING_ID FORM_TYPE FROM_DATE REC_TYPE THRU_DATE FILING_ID AMEND_ID REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC TABLE: CVR_REGISTRATION Column List Name A_B_ADR1 Code A_B_ADR1 Type VARCHAR2(55) P No M No A_B_ADR2 A_B_ADR2 VARCHAR2(55) No No A_B_CITY A_B_CITY VARCHAR2(30) No No A_B_NAME A_B_NAME VARCHAR2(200) No No A_B_ST A_B_ST VARCHAR2(2) No No A_B_ZIP4 A_B_ZIP4 VARCHAR2(10) No No AMEND_ID AMEND_ID NUMBER(9) Yes Yes AUTH_ADR1 AUTH_ADR1 VARCHAR2(55) No No PowerDesigner 2/21/02 Label First line of individual or business address used for print rendering. Second line of individual or business address used for print rendering. City of individual or business entity used for print rendering. Name of individual or business entity used for print rendering. State of individual or business entity used for print rendering. Zipcode of individual or business entity used for print rendering. Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. First line of the authorized lobbying firm's business Page 34 Physical Data Model Model_1 Name Code Type P M AUTH_ADR2 AUTH_ADR2 VARCHAR2(55) No No AUTH_CITY AUTH_CITY VARCHAR2(30) No No AUTH_NAME AUTH_NAME VARCHAR2(200) No No AUTH_ST AUTH_ST VARCHAR2(2) No No AUTH_ZIP4 AUTH_ZIP4 VARCHAR2(10) No No BUS_ADR1 BUS_ADR2 BUS_CB BUS_ADR1 BUS_ADR2 BUS_CB VARCHAR2(55) VARCHAR2(55) VARCHAR2(1) No No No No No No BUS_CITY BUS_CLASS BUS_CITY BUS_CLASS VARCHAR2(30) VARCHAR2(3) No No No No BUS_DESCR BUS_EMAIL BUS_FAX BUS_PHON BUS_ST BUS_ZIP4 C_LESS50 BUS_DESCR BUS_EMAIL BUS_FAX BUS_PHON BUS_ST BUS_ZIP4 C_LESS50 VARCHAR2(100) VARCHAR2(60) VARCHAR2(20) VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) VARCHAR2(1) No No No No No No No No No No No No No No C_MORE50 C_MORE50 VARCHAR2(1) No No COMPLET_DT COMPLET_DT DATE No No DESCRIP_1 DESCRIP_2 EFF_DATE ENTITY_CD DESCRIP_1 DESCRIP_2 EFF_DATE ENTITY_CD VARCHAR2(300) VARCHAR2(300) DATE VARCHAR2(3) No No No No No No No No FILER_ID FILER_ID VARCHAR2(9) No No PowerDesigner 2/21/02 Label address. Second line of the authorized lobbying firm's business address. City portion of the authorized lobbying firm's business address. Name authorized of lobbying firm. Applies to the form 602. State portion of the authorized lobbying firm's business address. Zip code portion of the authorized lobbying firm's business address. First line of the filer's business address. Second line of the filer's business address. Business included activity check-box used for print rendering. Legal values are "X" or null. Only one of the checkbox fields (Ind_CB, Bus_CB, Trade_CB or Oth_CB) can be checked. City portion of the filer's business address. Business classification values for business related entities. See the CAL document for legal values. This field is exclusive of the industry class field. One of these fields must be populated but not both. Description of business classification if coded as other. Filer's optional business E-Mail address. Filer's optional business FAX phone number. Filer's business phone number. State portion of the filer's business address. Zipcode portion of the filer's business address. No. members in Industry Assoc - 50 or less check box. Legal values are "X" or null. No. members in Industry Assoc - More than 50 check box. Legal values are "X" or null. Ethics orient course completion date. Applies to the form 604. As filed by the lobyist. Description of Business Activity, Industry, or Other Description of specific or other lobbying interests. Effective date of authorization or termination. Entity code of the subject of the filing Legal values are LBY, LEM, LCO and FRM. Filer's unique identification number. Page 35 Physical Data Model Model_1 Name FILER_NAMF FILER_NAML FILER_NAMS FILER_NAMT Code FILER_NAMF FILER_NAML FILER_NAMS FILER_NAMT Type VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) P No No No No M No No No No FILING_ID FIRM_NAME FILING_ID FIRM_NAME NUMBER(9) VARCHAR2(200) Yes No Yes No FORM_TYPE FORM_TYPE VARCHAR2(4) Yes Yes IND_CB IND_CB VARCHAR2(1) No No IND_CLASS IND_CLASS VARCHAR2(3) No No IND_DESCR INFLUEN_YN IND_DESCR INFLUEN_YN VARCHAR2(100) VARCHAR2(1) No No No No L_FIRM_CB L_FIRM_CB VARCHAR2(1) No No LBY_604_CB LBY_604_CB VARCHAR2(1) No No LBY_REG_CB LBY_REG_CB VARCHAR2(1) No No LOBBY_CB LOBBY_CB VARCHAR2(1) No No LOBBY_INT LOBBY_INT VARCHAR2(300) No No LS_BEG_YR LS_BEG_YR VARCHAR2(4) No No LS_END_YR LS_END_YR VARCHAR2(4) No No MAIL_ADR1 MAIL_ADR1 VARCHAR2(55) No No MAIL_ADR2 MAIL_ADR2 VARCHAR2(55) No No MAIL_CITY MAIL_CITY VARCHAR2(30) No No PowerDesigner 2/21/02 Label Filer's First Name(s) - required for individuals. Filer's Last Name or full business/organization name. Filer's name suffix. The filer's prefix or title that preceeds their name if they are an individual. Unique identificaton number for the filing. Name of the Lobbyist Employer or Firm. Applies to the Form 604, 606, and 607. Type of Filing or Formset. Legal values are F601, F603, F603, F604, F606, and F607. Individual check-box used for print rendering. Legal values are "X" or null. Only one of the checkbox fields (Ind_CB, Bus_CB, Trade_CB or Oth_CB) can be checked. Industry classification values used to catagorize industry related entities. See the CAL document for legal values. This field is exclusive of the business class field. One of these fields must be populated but not both. Description of industry classification if coded as other. Attempt ot influence state legislation yes/no box. Legal values are "Y" and "N". "Lobbying firm within the ...." check-box. Legal values are "X" or null. Applies to the Form 607. "Lobby agency in this 604 statement "check-box. Applies to the form 604. "Lobby agency in 601/603 Registration statement " check-box. Applies to the form 604. "Lobbyist within the meaning..." check-box. Legal values are "X" or null. Applies to the Form 607. Description of Part III Lobbying Interests. Applies to the form 603. Year the legislative session begins. Used for print rendering. Year the legislative session begins. Used for print rendering. First line of the filer's mailing address. (If different than the business address) Second line of the filer's mailing address. (If different than the business address) City portion of the filer's mailing address. Page 36 Physical Data Model Model_1 Name MAIL_PHON MAIL_ST MAIL_ZIP4 NEWCERT_CB Code MAIL_PHON MAIL_ST MAIL_ZIP4 NEWCERT_CB Type VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) VARCHAR2(1) P No No No No M No No No No OTH_CB OTH_CB VARCHAR2(1) No No PRN_NAMF PRN_NAML PRN_NAMS PRN_NAMT QUAL_DATE PRN_NAMF PRN_NAML PRN_NAMS PRN_NAMT QUAL_DATE VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) DATE No No No No No No No No No No REC_TYPE RENCERT_CB REC_TYPE RENCERT_CB VARCHAR2(4) VARCHAR2(1) Yes No Yes No REPORT_NUM REPORT_NUM VARCHAR2(3) No No RPT_DATE RPT_DATE DATE No No SENDER_ID SENDER_ID VARCHAR2(9) No No SIG_DATE SIG_LOC SIG_NAMF SIG_NAML SIG_NAMS SIG_NAMT SIG_DATE SIG_LOC SIG_NAMF SIG_NAML SIG_NAMS SIG_NAMT DATE VARCHAR2(45) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) No No No No No No No No No No No No SIG_TITLE ST_AGENCY ST_LEG_YN SIG_TITLE ST_AGENCY ST_LEG_YN VARCHAR2(45) VARCHAR2(100) VARCHAR2(1) No No No No No No STMT_FIRM STMT_FIRM VARCHAR2(90) No No TRADE_CB TRADE_CB VARCHAR2(1) No No PowerDesigner 2/21/02 Label Unused second phone number field. State portion of the filer's mailing address. Zipcode portion of the filer's mailing address. "Will take a new cert" check-box. Applies to the form 604. Other check-box used for print rendering. Legal values are "X" or null. Only one of the checkbox fields (Ind_CB, Bus_CB, Trade_CB or Oth_CB) can be checked. Signer "as signed" first name used for print rendering. Signer "as signed" last name used for print rendering. Signer "as signed" suffix used for print rendering. Signer "as signed" prefix or title used for print rendering. Date qualified. Applies to the 601/603. Only occurs once in lobbying filings. Used for print rendering. Record Type with the value: CVR Will take a renewal cert check-box. Applies to the form 604. Amendment number as reported by the filer; 000 Original; 001-999 Amended. Date this report or amendment is filed as reported by the filer. Identification number of lobbyist entity that is submitting this report. This is equal to the filer id if the filer is submitting the report and the firm or employer if they are submitting the report. Date when signed used for print rendering. City and State where signed used for print rendering. Signer's "as signed" first name used for print rendering. Signer's "as signed" last name used for print rendering. Signer's "as signed" suffix used for print rendering. Signer's "as signed" prefix or title used for print rendering. Title of signer used for print rendering. List of identified state agencies. Applies to the form 604. Will lobby state legislature (Y/N) checkbox. Applies to the form 604. Legal values are "Y" or "N". Lobby firm name in "Statement of Responsible Officer". This field only applies to the form 601. Industry/trade/professional check-box used for print rendering. Legal values are "X" or null. Only one of the Page 37 Physical Data Model Model_1 Name Code Type P M Label checkbox fields (Ind_CB, Bus_CB, Trade_CB or Oth_CB) can be checked. Index List Index Code PK_CVR_REGISTRATION P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC TABLE: CVR_SO Column List Name ACCT_OPENDT ACTVTY_LVL ADR1 ADR2 AMEND_ID BANK_ACCTNO BANK_ADR1 BANK_ADR2 BANK_CITY BANK_NAM BANK_PHON BANK_ST BANK_ZIP4 BRDBASE_CB CITY CMTE_EMAIL CMTE_FAX COM82013ID COM82013NM COM82013YN CONTROL_CB COUNTY_ACT PowerDesigner Code ACCT_OPENDT ACTVTY_LVL ADR1 ADR2 AMEND_ID BANK_ACCTNO BANK_ADR1 BANK_ADR2 BANK_CITY BANK_NAM BANK_PHON BANK_ST BANK_ZIP4 BRDBASE_CB CITY CMTE_EMAIL CMTE_FAX COM82013ID COM82013NM COM82013YN CONTROL_CB COUNTY_ACT Type DATE VARCHAR2(2) VARCHAR2(55) VARCHAR2(55) NUMBER(9) VARCHAR2(20) VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(200) VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) VARCHAR2(1) VARCHAR2(30) VARCHAR2(60) VARCHAR2(20) VARCHAR2(9) VARCHAR2(200) VARCHAR2(1) VARCHAR2(1) VARCHAR2(20) 2/21/02 P No No No No Yes No No No No No No No No No No No No No No No No No M No No No No Yes No No No No No No No No No No No No No No No No No Label Page 38 Physical Data Model Name COUNTY_RES ENTITY_CD FILER_ID FILER_NAMF FILER_NAML FILER_NAMS FILER_NAMT FILING_ID FORM_TYPE GENPURP_CB GPC_DESCR MAIL_ADR1 MAIL_ADR2 MAIL_CITY MAIL_ST MAIL_ZIP4 PHONE PRIMFC_CB QUAL_CB QUALFY_DT REC_TYPE REPORT_NUM RPT_DATE SMCONT_QUALDT SPONSOR_CB ST SURPLUSDSP TERM_DATE TRES_ADR1 TRES_ADR2 TRES_CITY TRES_NAMF TRES_NAML TRES_NAMS TRES_NAMT TRES_PHON TRES_ST TRES_ZIP4 ZIP4 PowerDesigner Model_1 Code COUNTY_RES ENTITY_CD FILER_ID FILER_NAMF FILER_NAML FILER_NAMS FILER_NAMT FILING_ID FORM_TYPE GENPURP_CB GPC_DESCR MAIL_ADR1 MAIL_ADR2 MAIL_CITY MAIL_ST MAIL_ZIP4 PHONE PRIMFC_CB QUAL_CB QUALFY_DT REC_TYPE REPORT_NUM RPT_DATE SMCONT_QUALDT SPONSOR_CB ST SURPLUSDSP TERM_DATE TRES_ADR1 TRES_ADR2 TRES_CITY TRES_NAMF TRES_NAML TRES_NAMS TRES_NAMT TRES_PHON TRES_ST TRES_ZIP4 ZIP4 Type VARCHAR2(20) VARCHAR2(3) VARCHAR2(9) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) NUMBER(9) VARCHAR2(4) VARCHAR2(1) VARCHAR2(300) VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(2) VARCHAR2(10) VARCHAR2(20) VARCHAR2(1) VARCHAR2(1) DATE VARCHAR2(3) VARCHAR2(3) DATE DATE VARCHAR2(1) VARCHAR2(2) VARCHAR2(90) DATE VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) VARCHAR2(10) 2/21/02 P No No No No No No No Yes Yes No No No No No No No No No No No Yes No No No No No No No No No No No No No No No No No No M No No No No No No No Yes Yes No No No No No No No No No No No Yes No No No No No No No No No No No No No No No No No No Label Page 39 Physical Data Model Model_1 Index List Index Code PK_CVR_SO P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC TABLE: CVR2_CAMPAIGN_DISCLOSURE Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes BAL_JURIS BAL_NAME BAL_NUM CMTE_ID BAL_JURIS BAL_NAME BAL_NUM CMTE_ID VARCHAR2(40) VARCHAR2(200) VARCHAR2(7) VARCHAR2(9) No No No No No No No No CONTROL_YN CONTROL_YN VARCHAR2(1) No No DIST_NO DIST_NO VARCHAR2(3) No No ENTITY_CD ENTITY_CD VARCHAR2(3) No No ENTY_ADR1 ENTY_ADR2 ENTY_CITY ENTY_EMAIL ENTY_FAX ENTY_NAMF ENTY_NAML ENTY_NAMS ENTY_NAMT ENTY_PHON ENTY_ST ENTY_ADR1 ENTY_ADR2 ENTY_CITY ENTY_EMAIL ENTY_FAX ENTY_NAMF ENTY_NAML ENTY_NAMS ENTY_NAMT ENTY_PHON ENTY_ST VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(60) VARCHAR2(20) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(20) VARCHAR2(2) No No No No No No No No No No No No No No No No No No No No No No PowerDesigner 2/21/02 Label Amendment Identification number. A number of 0 is an original filing. 1 - 999 represent amendments to the original filing. Jurisdiction of ballot measure. Ballot measure name. Ballot measure number or letter. Identification number for the entity used when the entity is a committee. Controlled Committee (yes/no) checkbox. Legal values are "Y" or "N". District number for the office being sought. Populated for Senate, Assembly, or Board of Equalization races. Entity code used to identify the type of entity being described with in the record. See the CAL document to determine which entity codes apply to a given form. First line of the entities streeet address. Second line of the entities streeet address. City portition of the entity's street address. Entities EMail address. Entities FAX number. Entity's first name if the entity is an individual. Entity's name or last name if the entity is an individual. Entity's last suffix if the entity is an individual. Entity's last prefix or title if the entity is an individual. Entity's phone number. State portition of the entity's street address. Page 40 Physical Data Model Model_1 Name ENTY_ZIP4 F460_PART Code ENTY_ZIP4 F460_PART Type VARCHAR2(10) VARCHAR2(2) P No No M No No FILING_ID FORM_TYPE FILING_ID FORM_TYPE NUMBER(9) VARCHAR2(4) Yes Yes Yes Yes JURIS_CD JURIS_CD VARCHAR2(3) No No JURIS_DSCR JURIS_DSCR VARCHAR2(40) No No LINE_ITEM MAIL_ADR1 LINE_ITEM MAIL_ADR1 NUMBER(9) VARCHAR2(55) Yes No Yes No MAIL_ADR2 MAIL_ADR2 VARCHAR2(55) No No MAIL_CITY MAIL_ST MAIL_ZIP4 OFF_S_H_CD MAIL_CITY MAIL_ST MAIL_ZIP4 OFF_S_H_CD VARCHAR2(30) VARCHAR2(2) VARCHAR2(10) VARCHAR2(1) No No No No No No No No OFFIC_DSCR OFFIC_DSCR VARCHAR2(40) No No OFFICE_CD OFFICE_CD VARCHAR2(3) No No REC_TYPE SUP_OPP_CD REC_TYPE SUP_OPP_CD VARCHAR2(4) VARCHAR2(1) Yes No Yes No TITLE TRAN_ID TITLE TRAN_ID VARCHAR2(90) VARCHAR2(20) No No No No TRES_NAMF TRES_NAML TRES_NAMS TRES_NAMT TRES_NAMF TRES_NAML TRES_NAMS TRES_NAMT VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) No No No No No No No No PowerDesigner 2/21/02 Label Zip code portition of the entity's street address. Part of 460 cover page coded on ths cvr2 record. Legal values are 3, 4a, 4b, 5a, 5b, or 6. Unique filing identification number. Form type indicating which type of form the record is assocated with. Determines which columns apply to the record. Office jurisdiction code. See the CAL document for a list of legal code values. Office jurisdiction description used if the jurisdiction code is equil to other. Record line item number. First line of the filer's mailing address. This field is only required if the mailing address differs from the filer's street address. Second line of the filer's mailing address. This field is only required if the mailing address differs from the filer's street address. City portion of the filer's mailing address. State portion of the filer's mailing address. Zipcode portion of the filer's mailing address. Office sought/held code. Indicates if the candidate is an incumbent. Legal values are "S" for sought and "H" for held. Office sought description used to describe the office being sought if the office code is equil to other. Code that identifies the office being sought. See the CAL document for a list of valid codes. Record Type Value: CVR2 Support/Oppose (S/O) code for the ballot measure. Legal values are "S" for support or "O" for oppose. Official title of filing officer. Applies to the form 465. Transaction identifier - permanent value unique to this item. Treasurer or responsible officer's first name. Treasurer or responsible officer's last name. Treasurer or responsible officer's suffix. Treasurer or responsible officer's prefix or title. Page 41 Physical Data Model Model_1 Index List Index Code PK_CVR2_CAMPAIGN_DISCLOSURE P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: CVR2_LOBBY_DISCLOSURE Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes ENTITY_CD ENTITY_CD VARCHAR2(3) No No ENTITY_ID ENTITY_ID VARCHAR2(9) No No ENTY_NAMF ENTY_NAML ENTY_NAMS ENTY_NAMT ENTY_NAMF ENTY_NAML ENTY_NAMS ENTY_NAMT VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) No No No No No No No No ENTY_TITLE ENTY_TITLE VARCHAR2(45) No No FILING_ID FILING_ID NUMBER(9) Yes Yes FORM_TYPE FORM_TYPE VARCHAR2(4) Yes Yes LINE_ITEM REC_TYPE TRAN_ID LINE_ITEM REC_TYPE TRAN_ID NUMBER(9) VARCHAR2(4) VARCHAR2(20) Yes Yes No Yes Yes No PowerDesigner 2/21/02 Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Entity code of the entity described by the record. Legal values include: PTN - Partner, OWN - Owner, OFF Officer, EMP - Employee Entity Identificaiton number (Partner, Owner, Officer, Employee) Entity's first name if the entity is an individual. Entity's business or last name if an individual. Entity's name suffix if the entity is an individual. Entity's name prefix or title used if the entity is an individual. Title of Partner, Owner, Officer, Employee if the entity is an individual (required on 635 only). Unique filing identification number that the record is part of. Form type that contains the record. This column must match the parent form type of CVR record for the filing. Record line item number. Record Type Value: Always CVR2 for this record. Transaction identifier - permanent value unique to this item. Page 42 Physical Data Model Model_1 Index List Index Code PK_CVR2_LOBBY_DISCLOSURE P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: CVR2_REGISTRATION Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes ENTITY_CD ENTITY_CD VARCHAR2(3) No No ENTITY_ID ENTITY_ID VARCHAR2(9) No No ENTY_NAMF ENTY_NAML ENTY_NAMF ENTY_NAML VARCHAR2(45) VARCHAR2(200) No No No No ENTY_NAMS ENTY_NAMT FILING_ID ENTY_NAMS ENTY_NAMT FILING_ID VARCHAR2(10) VARCHAR2(10) NUMBER(9) No No Yes No No Yes FORM_TYPE FORM_TYPE VARCHAR2(4) Yes Yes LINE_ITEM REC_TYPE LINE_ITEM REC_TYPE NUMBER(9) VARCHAR2(4) Yes Yes Yes Yes TRAN_ID TRAN_ID VARCHAR2(20) No No Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Entity code describing the record's entity. Legal values include SCL, MBR, and Null. Entity identification number of the entity described by the record. (Partner, Owner, Officer, Employee) Entity's first name if the entity is an individual. Entity's business or last name if the entity is an individual. Entity's name suffix if the entity is an individual. Entity's name prefix or title if the entity is an individual. Unique identification number of the filing in which the record is a part. Form type of filing the record is include in. This value must equal form_type in filings cover (CVR) record. Record line item number. Record type value: These record should always be coded as CVR2. Transaction identifier - permanent value unique to this item. Index List Index Code PowerDesigner P F A U 2/21/02 C Column Code Sort Page 43 Physical Data Model Model_1 Index Code PK_CVR2_REGISTRATION P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: CVR2_SO Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes BAL_JURIS BAL_NUM CMTE_ID DAY_PHONE DIST_NO BAL_JURIS BAL_NUM CMTE_ID DAY_PHONE DIST_NO VARCHAR2(40) VARCHAR2(7) VARCHAR2(9) VARCHAR2(20) VARCHAR2(3) No No No No No No No No No No EMAIL_ADR EMAIL_ADR VARCHAR2(60) No No ENTITY_CD ENTY_NAMF ENTY_NAML ENTITY_CD ENTY_NAMF ENTY_NAML VARCHAR2(3) VARCHAR2(45) VARCHAR2(200) No No No No No No ENTY_NAMS ENTY_NAMT FAX_PHONE FILING_ID ENTY_NAMS ENTY_NAMT FAX_PHONE FILING_ID VARCHAR2(10) VARCHAR2(10) VARCHAR2(20) NUMBER(9) No No No Yes No No No Yes FORM_TYPE FORM_TYPE VARCHAR2(4) Yes Yes IND_GROUP ITEM_CD IND_GROUP ITEM_CD VARCHAR2(90) VARCHAR2(3) No No No No JURIS_CD JURIS_CD VARCHAR2(3) No No PowerDesigner 2/21/02 Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Jurisdiction of ballot measure Ballot measure number or letter. Entities identification number. Entities daytime phone number. Office district number for Senate, Assembly, and Board of Equalization districts. E-Mail address. This field is not contained on the current forms. Entity code of the entity described by the record. Entity's first name if the entity is an individual. Entity's business name or last name if the entity is an individual. Entity's name suffix if the the entitiy is an individual. Entity's name prefix or title if the entity is an individual. Entitie's FAX number. Unique filing identification number for the filing that contains the record. Form type of the filing the record is included in. This must equal the form_type of the parent filing's cover (CVR) record. Industry group / affiliation description. Section of the Statement of Organization this itemization relates to. See the CAL document for the definition of legal values for this column. Office jurisdiction code. See the CAL document for a list Page 44 Physical Data Model Model_1 Name Code Type P M JURIS_DSCR JURIS_DSCR VARCHAR2(40) No No LINE_ITEM MAIL_ADR1 MAIL_ADR2 MAIL_CITY MAIL_ST MAIL_ZIP4 NON_PTY_CB OFF_S_H_CD LINE_ITEM MAIL_ADR1 MAIL_ADR2 MAIL_CITY MAIL_ST MAIL_ZIP4 NON_PTY_CB OFF_S_H_CD NUMBER(9) VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(2) VARCHAR2(10) VARCHAR2(1) VARCHAR2(1) Yes No No No No No No No Yes No No No No No No No OFFIC_DSCR OFFIC_DSCR VARCHAR2(40) No No OFFICE_CD OFFICE_CD VARCHAR2(3) No No PARTY_NAME POF_TITLE REC_TYPE PARTY_NAME POF_TITLE REC_TYPE VARCHAR2(200) VARCHAR2(45) VARCHAR2(4) No No Yes No No Yes SUP_OPP_CD SUP_OPP_CD VARCHAR2(1) No No TRAN_ID TRAN_ID VARCHAR2(20) No No YEAR_ELECT YEAR_ELECT VARCHAR2(4) No No Label of legal values. Office jurisdiction description provided if the jurisdiction code (JURIS_CD) equals other (OTH). Record line item number. First line of the entities mailing address. Second line of the entities mailing address. City portion of the entities mailing address. State portion of the entities mailing address. Zipcode portion of the entities mailing address. Non-partisan check-box. Legal values are "X" and null. Office sought/held code. Legal values are "S" for sought and "H" for held. Office sought description used of the Office sought code (OFFICE_CD) equals other (OTH). Code that identifies the office being sought. See the CAL document for a list of valid codes. Name of party (if partisan). Position/title of principal officer. Record Type Value: This column will always contain "CVR2". Support/oppose code (S/O). Legal values are "S" for support and "O" for oppose. Transaction identifier - permanent value unique to this item. Year of election Index List Index Code PK_CVR2_SO P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: CVR3_VERIFICATION_INFO PowerDesigner 2/21/02 Page 45 Physical Data Model Model_1 Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes ENTITY_CD ENTITY_CD VARCHAR2(3) No No FILING_ID FORM_TYPE FILING_ID FORM_TYPE NUMBER(9) VARCHAR2(4) Yes Yes Yes Yes LINE_ITEM REC_TYPE SIG_DATE SIG_LOC SIG_NAMF SIG_NAML SIG_NAMS SIG_NAMT TRAN_ID LINE_ITEM REC_TYPE SIG_DATE SIG_LOC SIG_NAMF SIG_NAML SIG_NAMS SIG_NAMT TRAN_ID NUMBER(9) VARCHAR2(4) DATE VARCHAR2(45) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(20) Yes Yes No No No No No No No Yes Yes No No No No No No No Label Amendment Identification number. Amendment number 0 is an original. Amendments are numbered 1 to 999. Entity code. See the CAL document for a list of legal values. Unique filing identification number of the parent filing. Form type of the parent filing. Legal values are [ F401 F425 F450 F460 F461 F465 F470 F400 F402 F410 ] Record line item number. Record type value. This will always be CVR3. Date when signed. City and state where signed. Signer's "as signed" frst name Signer's "as signed" last name Signer's "as signed" suffix. Signer's "as signed" prefix or title. Transaction identifier - permanent value unique to this item. Index List Index Code PK_CVR3_VERIFICATION_INFO P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: DEBT Column List Name AMEND_ID PowerDesigner Code AMEND_ID Type NUMBER(9) P Yes 2/21/02 M Yes Label Amendment Identification number. An amendment number of 0 is an original filing, 1 to 999 are Page 46 Physical Data Model Name Model_1 Code Type P M AMT_INCUR AMT_PAID BAKREF_TID AMT_INCUR AMT_PAID BAKREF_TID NUMBER(12,2) NUMBER(12,2) VARCHAR2(20) No No No No No No BEG_BAL CMTE_ID END_BAL ENTITY_CD EXPN_CODE BEG_BAL CMTE_ID END_BAL ENTITY_CD EXPN_CODE NUMBER(12,2) VARCHAR2(9) NUMBER(12,2) VARCHAR2(3) VARCHAR2(3) No No No No No No No No No No EXPN_DSCR FILING_ID FORM_TYPE LINE_ITEM MEMO_CODE MEMO_REFNO PAYEE_ADR1 PAYEE_ADR2 PAYEE_CITY PAYEE_NAMF PAYEE_NAML EXPN_DSCR FILING_ID FORM_TYPE LINE_ITEM MEMO_CODE MEMO_REFNO PAYEE_ADR1 PAYEE_ADR2 PAYEE_CITY PAYEE_NAMF PAYEE_NAML VARCHAR2(400) NUMBER(9) VARCHAR2(1) NUMBER(9) VARCHAR2(1) VARCHAR2(20) VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(45) VARCHAR2(200) No Yes Yes Yes No No No No No No No No Yes Yes Yes No No No No No No No PAYEE_NAMS PAYEE_NAMT PAYEE_ST PAYEE_ZIP4 REC_TYPE TRAN_ID PAYEE_NAMS PAYEE_NAMT PAYEE_ST PAYEE_ZIP4 REC_TYPE TRAN_ID VARCHAR2(10) VARCHAR2(100) VARCHAR2(2) VARCHAR2(10) VARCHAR2(4) VARCHAR2(20) No No No No Yes No No No No No Yes No TRES_ADR1 TRES_ADR1 VARCHAR2(55) No No TRES_ADR2 TRES_ADR2 VARCHAR2(55) No No TRES_CITY TRES_CITY VARCHAR2(30) No No TRES_NAMF TRES_NAML TRES_NAMS TRES_NAMT TRES_NAMF TRES_NAML TRES_NAMS TRES_NAMT VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(100) No No No No No No No No PowerDesigner 2/21/02 Label amendments. Amount incurred this period. Amount paid this period. Back Reference to a transaction identifier of a parent record. Outstanding balance at beginning of this period. Committee Identification number. Outstanding balance at close of this period. Entity code of the payee Expense code. Refer to the CAL document for a list of legal codes for this column. Purpose of expense and/or description/explanation. Unique filing identification number of the parent filing. Schedule Name/ID: (F - Sched F / Accrued Expenses) Record line item number. Memo amount flag Reference to text contained in a TEXT record. First line of the payee's street address. Second line of the payee's street address. Payee's city. Payee's first name if the payee is an individual. Payee's business name or last name if the payee is an individual. Payee's name suffix if the payee is an individual. Payee's prefix or title if the payee is an individual. Payee's state. Payee's zip code. Record Type Value: DEBT Transaction identifier - permanent value unique to this item. First line of the treasurer or responsible officer's street address. Second line of the treasurer or responsible officer's street address. City portion of the treasurer or responsible officer's street address. Treasurer or responsible officer's first name. Treasurer or responsible officer's last name. Treasurer or responsible officer's suffix. Treasurer or responsible officer's prefix or title. Page 47 Physical Data Model Model_1 TRES_ST Name TRES_ST Code Type VARCHAR2(2) P No M No TRES_ZIP4 TRES_ZIP4 VARCHAR2(10) No No XREF_MATCH XREF_MATCH VARCHAR2(1) No No XREF_SCHNM XREF_SCHNM VARCHAR2(2) No No Label State portion of the treasurer or responsible officer's address. Zip code portion of the treasurer or responsible officer's address. Related item on other schedule has same transaction identifier. "X" indicates this condition is true. Related record is included on Schedule 'C' Index List Index Code PK_DEBT P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: DISCLOSURE_PROCEDURES Column List Name ID PACKAGE_NAME PROC_DESC PROC_NEXT PROCEDURE_NAME Code ID PACKAGE_NAME PROC_DESC PROC_NEXT PROCEDURE_NAME Type NUMBER(4) VARCHAR2(50) VARCHAR2(50) NUMBER(4) VARCHAR2(50) P Yes No No No No M Yes No No No No Label Identification number. Package name Procedure description. Next procedure. Procedure name. Index List Index Code PK_DISC_PROCEDURES P Yes F No A No U Yes C No Column Code ID Sort ASC TABLE: EFS_FILING_LOG PowerDesigner 2/21/02 Page 48 Physical Data Model Model_1 Column List Name ERROR_NO FILER_ID FILING_DATE FILINGSTATUS FORM_TYPE VENDOR Code ERROR_NO FILER_ID FILING_DATE FILINGSTATUS FORM_TYPE VENDOR Type VARCHAR2(20) VARCHAR2(11) DATE VARCHAR2(2) VARCHAR2(5) VARCHAR2(90) P No No No No No No M No No No No No No Label Index List Index Code EFS_FILING_LOG P No F No A No U No C No Column Code FILING_DATE VENDOR Sort ASC ASC TABLE: ELECTION_CANDIDATES Column List Name ELECTION_DATE FILER_ID OFF_S_H_CD Code ELECTION_DATE FILER_ID OFF_S_H_CD Type DATE NUMBER(9) VARCHAR2(1) P Yes Yes No M Yes Yes No Label Date of the election. Committee identification number of the filer. Office sought/held code. Legal values are "S" for sought and "H" for held. Index List Index Code IX_CAND_FILING_ID PK_ELECTION_CANDIDATES P No Yes F No No A No No U No Yes C No No Column Code FILER_ID ELECTION_DATE FILER_ID Sort ASC ASC ASC TABLE: ELECTION_LINKS PowerDesigner 2/21/02 Page 49 Physical Data Model Model_1 Column List Name GENERAL_RUNOFF_ID PRIMARY_SPECIAL_ID Code GENERAL_RUNOFF_ID PRIMARY_SPECIAL_ID Type NUMBER(9) NUMBER(9) P Yes Yes M Yes Yes Label Index List Index Code IX_FL_GENERAL_RUNOFF_ID IX_FL_PRIMARY_SPECIAL_ID PK_ELECTION_LINKS P No No Yes F Yes Yes No A No No No U Yes Yes Yes C No No No Column Code GENERAL_RUNOFF_ID PRIMARY_SPECIAL_ID GENERAL_RUNOFF_ID PRIMARY_SPECIAL_ID Sort ASC ASC ASC ASC TABLE: ELECTION_RACES Column List Name DISTRICT ELECT_ID RACE RACE_ID Code Type NUMBER(9) NUMBER(9) NUMBER(9) NUMBER(9) DISTRICT ELECT_ID RACE RACE_ID P No No No Yes M No No Yes Yes Label Index List Index Code IX_ER_DISTRICT IX_ER_ELECT_ID IX_ER_RACE PK_ELECTION_RACES P No No No Yes F No Yes No No A No No No No U No No No Yes C No No No No Column Code DISTRICT ELECT_ID RACE RACE_ID Sort ASC ASC ASC ASC TABLE: ELECTION_TYPES Column List PowerDesigner 2/21/02 Page 50 Physical Data Model Name ELECT_DESC ELECT_ID Model_1 Code ELECT_DESC ELECT_ID Type VARCHAR2(128) NUMBER(9) P No Yes M Yes Yes Label Description of the election Unique Election Identification number. Index List Index Code PK_ELECTION_TYPES P Yes F No A No U Yes C No Column Code ELECT_ID Sort ASC TABLE: ELECTIONS Column List Name ELECT_DT ELECT_ID ELECT_TYPE FIRST_PRE_DEADLINE FIRST_PRE_END_DT FIRST_PRE_STRT_DT LCR_END_DT LCR_STRT_DT RPT_74_DAY_END_DT RPT_74_DAY_STRT_DT SECOND_PRE_DEADLIN E SECOND_PRE_END_DT SECOND_PRE_STRT_DT SESSION_ID Code ELECT_DT ELECT_ID ELECT_TYPE FIRST_PRE_DEADLINE FIRST_PRE_END_DT FIRST_PRE_STRT_DT LCR_END_DT LCR_STRT_DT RPT_74_DAY_END_DT RPT_74_DAY_STRT_DT SECOND_PRE_DEADLIN E SECOND_PRE_END_DT SECOND_PRE_STRT_DT SESSION_ID Type DATE NUMBER(9) NUMBER(9) DATE DATE DATE DATE DATE DATE DATE DATE P No Yes No No No No No No No No No M No Yes No No No No No No No No No DATE DATE NUMBER(9) No No No No No No Label Index List Index Code IX_E_ELECT_DT IX_E_ELECT_TYPE IX_E_SESSION_ID PK_ELECTIONS PowerDesigner P No No No Yes F No No No No A No No No No U No No No Yes C No No No No 2/21/02 Column Code ELECT_DT ELECT_TYPE SESSION_ID ELECT_ID Sort ASC ASC ASC ASC Page 51 Physical Data Model Model_1 TABLE: ERROR_LOG Column List Name Code ERR_DT ERR_MSG ERR_SEQ ERR_TABLE USER_ID Type ERR_DT ERR_MSG ERR_SEQ ERR_TABLE USER_ID P No No Yes No No DATE VARCHAR2(625) NUMBER(9) VARCHAR2(32) VARCHAR2(16) M No No Yes No No Label Date the error occurred. Error Message Error sequence number. Error table User Identifier. Index List Index Code PK_ERROR_LOG P Yes F No A No U Yes C No Column Code ERR_SEQ Sort ASC TABLE: ERRORS_AND_OMISSIONS Column List Name ERR_CODE ERR_NUM FILING_ID Code ERR_CODE ERR_NUM FILING_ID Type NUMBER(9) NUMBER(9) NUMBER(9) P No Yes Yes M Yes Yes Yes Label Error code that identifies the type of error. Error number unique to the filing. Unique filing identification number of the filing containing the error. Index List Index Code PK_ERRORS_AND_OMISSIONS P Yes F No A No U Yes C No Column Code ERR_NUM FILING_ID Sort ASC ASC TABLE: EXPN Column List PowerDesigner 2/21/02 Page 52 Physical Data Model Model_1 Name AGENT_NAMF AGENT_NAML AGENT_NAMS AGENT_NAMT AMEND_ID Code AGENT_NAMF AGENT_NAML AGENT_NAMS AGENT_NAMT AMEND_ID Type VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) NUMBER(9) P No No No No Yes M No No No No Yes AMOUNT BAKREF_TID AMOUNT BAKREF_TID NUMBER(12,2) VARCHAR2(20) No No No No BAL_JURIS BAL_NAME BAL_NUM CAND_NAMF CAND_NAML CAND_NAMS CAND_NAMT CMTE_ID BAL_JURIS BAL_NAME BAL_NUM CAND_NAMF CAND_NAML CAND_NAMS CAND_NAMT CMTE_ID VARCHAR2(40) VARCHAR2(200) VARCHAR2(7) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(9) No No No No No No No No No No No No No No No No CUM_OTH CUM_YTD DIST_NO CUM_OTH CUM_YTD DIST_NO NUMBER(12,2) NUMBER(12,2) VARCHAR2(3) No No No No No No ENTITY_CD ENTITY_CD VARCHAR2(3) No No EXPN_CHKNO EXPN_CODE EXPN_CHKNO EXPN_CODE VARCHAR2(20) VARCHAR2(3) No No No No EXPN_DATE EXPN_DSCR FILING_ID FORM_TYPE EXPN_DATE EXPN_DSCR FILING_ID FORM_TYPE DATE VARCHAR2(400) NUMBER(9) VARCHAR2(6) No No Yes Yes No No Yes Yes G_FROM_E_F G_FROM_E_F VARCHAR2(1) No No JURIS_CD JURIS_CD VARCHAR2(3) No No JURIS_DSCR JURIS_DSCR VARCHAR2(40) No No PowerDesigner 2/21/02 Label Agent or independent contractor's first name. Agent or Independent contractor's last name. Agent or independent contractor's suffix. Agent or independent contractor's prefix or title. Amendment Identification number. A number of 0 indicates an original. A number of 1 to 999 indicates an amendment. Amount Received Back Reference to a transaction identifier of a parent record. Jurisdiction of ballot measure. Ballot measure name. Ballot measure number or letter. Candidate/officeholder's first name. Candidate/officeholder's last name. Candidate/officeholder's name suffix. Candidate/officeholder's name prefix or title. Committee identification number. Not used on Form 460 Schedule D. Cumulative Other (Sched P4 and P5) Cumulative year to date amount (Schedule P4 and P5) District number for the office being sought. Populated for Senate, Assembly, or Board of Equalization races. Entity code of the payee. Legal values include COM, RCP, IND, and OTH. Check Number Expense code. See the CAL document for a list of legal values. Date of expenditure Purpose of expense and/or description/explanation Unique filing identification number. This field indicates the schedule or part of a form the record applies to. The legal values are D, E, G, F450P5, F461P5, and F465P3. Back reference from Form 460 Schedule G to Schedule E or F. Office jurisdiction code. See the CAL document for the list of legal values. Office jurisdiction description if the Jurisdiction Code (JURIS_CD) equals other (OTH) Page 53 Physical Data Model Model_1 Name LINE_ITEM MEMO_CODE MEMO_REFNO OFF_S_H_CD Code LINE_ITEM MEMO_CODE MEMO_REFNO OFF_S_H_CD Type NUMBER(9) VARCHAR2(1) VARCHAR2(20) VARCHAR2(1) P Yes No No No M Yes No No No OFFIC_DSCR OFFIC_DSCR VARCHAR2(40) No No OFFICE_CD OFFICE_CD VARCHAR2(3) No No PAYEE_ADR1 PAYEE_ADR2 PAYEE_CITY PAYEE_NAMF PAYEE_NAML PAYEE_ADR1 PAYEE_ADR2 PAYEE_CITY PAYEE_NAMF PAYEE_NAML VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(45) VARCHAR2(200) No No No No No No No No No No PAYEE_NAMS PAYEE_NAMT PAYEE_ST PAYEE_ZIP4 REC_TYPE PAYEE_NAMS PAYEE_NAMT PAYEE_ST PAYEE_ZIP4 REC_TYPE VARCHAR2(10) VARCHAR2(10) VARCHAR2(2) VARCHAR2(10) VARCHAR2(4) No No No No Yes No No No No Yes SUP_OPP_CD SUP_OPP_CD VARCHAR2(1) No No TRAN_ID TRAN_ID VARCHAR2(20) No No TRES_ADR1 TRES_ADR1 VARCHAR2(55) No No TRES_ADR2 TRES_ADR2 VARCHAR2(55) No No TRES_CITY TRES_CITY VARCHAR2(30) No No TRES_NAMF TRES_NAMF VARCHAR2(45) No No TRES_NAML TRES_NAML VARCHAR2(200) No No TRES_NAMS TRES_NAMS VARCHAR2(10) No No TRES_NAMT TRES_NAMT VARCHAR2(10) No No PowerDesigner 2/21/02 Label Record line item number. Memo amount flag Reference to text contained in a TEXT record Office sought/held code indicating if the candiate currently holds the office being sought. Legal values are "S" for sought and "H" for held. Office sought description if the office code (OFFICE_CD) equals other (OTH). Code that identifies the office being sought. See the CAL document for a list of valid codes. First line of the payee's street address. Second line of the payee's street address. Payee's city. Payee's first name if the payee is an individual. Payee's business name or last name if the payee is an individual. Payee's name suffix if the payee is an individual. Payee's prefix or title if the payee is an individual. Payee's state. Payee's zip code. Record Type Value: This column will always be coded EXPN. Support or Oppose code. Legal values are "S" for support and "O" for oppose. Transaction identifier - permanent value unique to this item. First line of the treasurer or responsible officer's street address. Second line of the treasurer or responsible officer's street address. City portion of the treasurer or responsible officer's street address. Treasurer or responsible officer's frst name. Not used on Form 460 Schedule D. Treasurer or responsible officer's last name. Not used on Form 460 Schedule D. Treasurer or responsible officer's suffix. Not used on Form 460 Schedule D. Treasurer or responsible officer's prefix or title. Not used on Form 460 Schedule D. Page 54 Physical Data Model Model_1 TRES_ST Name TRES_ST Code Type VARCHAR2(2) P No M No TRES_ZIP4 TRES_ZIP4 VARCHAR2(10) No No XREF_MATCH XREF_MATCH VARCHAR2(1) No No XREF_SCHNM XREF_SCHNM VARCHAR2(2) No No Label State portion of the treasurer or responsible officer's address. Zip code portion of the treasurer or responsible officer's address. Related item on other schedule has same transaction identifier. "X" indicates this condition is true. Related record is included on Form 460 Schedules 'B2' or 'F'. Index List Index Code IX_EXPN_AMEND_ID IX_EXPN_EXPN_CODE IX_EXPN_EXPN_DATE IX_EXPN_FILING_ID IX_EXPN_FORM_TYPE IX_EXPN_REC_TYPE PK_EXPN P No No No No No No Yes F No No No Yes No No No A No No No No No No No U No No No No No No Yes C No No No No No No No Column Code AMEND_ID EXPN_CODE EXPN_DATE FILING_ID FORM_TYPE REC_TYPE FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC TABLE: F495P2 Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes CONTRIBAMT CONTRIBAMT NUMBER(12,2) No No ELECT_DATE ELECT_DATE DATE No No ELECTJURIS FILING_ID ELECTJURIS FILING_ID VARCHAR2(40) NUMBER(9) No Yes No Yes PowerDesigner 2/21/02 Label Amendment Identification number. A number of 0 indicates an original and 1 - 999 indicate an amendment. Contribution Amount (For the period of 6 months prior to 17 days before the election) Date of the General Election This date will be the same as on the filing's cover (CVR) record. Jurisdiction of the election Unique filing identification number. Page 55 Physical Data Model Name FORM_TYPE LINE_ITEM REC_TYPE Model_1 Code FORM_TYPE LINE_ITEM REC_TYPE Type VARCHAR2(4) NUMBER(9) VARCHAR2(4) P Yes Yes Yes M Yes Yes Yes Label Type of filing or formset of the parent filing. Record line item number. Record type value. This will always equal F495. Index List Index Code PK_F495P2 P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: F501_502 Column List Name ACCEPT_LIMIT_YN ACCOUNT_NO ACCT_OP_DT AGENCY_NAM AMEND_ID Code ACCEPT_LIMIT_YN ACCOUNT_NO ACCT_OP_DT AGENCY_NAM AMEND_ID Type VARCHAR2(1) VARCHAR2(32) DATE VARCHAR2(200) NUMBER(9) P No No No No Yes M No No No No Yes CAN_NAMM CAN_SIG CAND_ADR1 CAND_ADR2 CAN_NAMM CAN_SIG CAND_ADR1 CAND_ADR2 VARCHAR2(20) VARCHAR2(200) VARCHAR2(50) VARCHAR2(50) No No No No No No No No CAND_CITY CAND_EMAIL CAND_FAX CAND_NAMF CAND_NAML CAND_NAMS CAND_NAMT CAND_PHON CAND_ST CAND_CITY CAND_EMAIL CAND_FAX CAND_NAMF CAND_NAML CAND_NAMS CAND_NAMT CAND_PHON CAND_ST VARCHAR2(30) VARCHAR2(60) VARCHAR2(20) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(100) VARCHAR2(20) VARCHAR2(2) No No No No No No No No No No No No No No No No No No PowerDesigner 2/21/02 Label Account Number Account open date Agency Name Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Candidate/Officeholder's Middle Name Candidate signature First line of the Candidate/Officeholder's street address. Second line of the Candidate/Officeholder's street address. Candidate/Officeholder's City Candidate/Officeholder's EMail Address Candidate/Officeholder's FAX phone number. Candidate/officeholder's first name. Candidate/officeholder's last name. Candidate/officeholder's name suffix. Candidate/officeholder's name prefix or title. Candidate/Officeholder's phone number. Candidate/Officeholder's State Page 56 Physical Data Model Model_1 Name CAND_ZIP4 CNTRB_PRSNL_FNDS_D T COMMITTEE_ID DID_EXCEED_DT DIST_NO Code CAND_ZIP4 CNTRB_PRSNL_FNDS_D T COMMITTEE_ID DID_EXCEED_DT DIST_NO Type VARCHAR2(10) DATE P No No M No No Label Candidate/Officeholder's ZIP+4 VARCHAR2(9) DATE VARCHAR2(3) No No No No No No Committee Identification number. DISTRICT_CD DISTRICT_CD NUMBER(9) No No ELEC_TYPE ELECT_DATE ENTITY_CD EXECUTE_DT FILER_ID FILING_ID FIN_ADR1 FIN_ADR2 FIN_CITY FIN_EMAIL FIN_FAX FIN_NAMF FIN_NAML FIN_NAMS FIN_NAMT FIN_PHON FIN_ST FIN_ZIP4 FORM_TYPE FROM_DATE JURIS_CD JURIS_DSCR MONIKER MONIKER_POS OFFIC_DSCR OFFICE_CD PARTY PARTY_CD REC_TYPE REPORT_NUM RPT_DATE ELEC_TYPE ELECT_DATE ENTITY_CD EXECUTE_DT FILER_ID FILING_ID FIN_ADR1 FIN_ADR2 FIN_CITY FIN_EMAIL FIN_FAX FIN_NAMF FIN_NAML FIN_NAMS FIN_NAMT FIN_PHON FIN_ST FIN_ZIP4 FORM_TYPE FROM_DATE JURIS_CD JURIS_DSCR MONIKER MONIKER_POS OFFIC_DSCR OFFICE_CD PARTY PARTY_CD REC_TYPE REPORT_NUM RPT_DATE NUMBER(9) DATE NUMBER(9) DATE VARCHAR2(9) NUMBER(9) VARCHAR2(50) VARCHAR2(50) VARCHAR2(30) VARCHAR2(60) VARCHAR2(20) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(100) VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) VARCHAR2(4) DATE NUMBER(9) VARCHAR2(30) VARCHAR2(20) NUMBER(9) VARCHAR2(80) NUMBER(9) VARCHAR2(200) NUMBER(9) VARCHAR2(3) VARCHAR2(3) DATE No No No No No Yes No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No Yes No No No No No No No No No No No No No No No No No No No No No No No No No PowerDesigner 2/21/02 District number for the office being sought. Populated for Senate, Assembly, or Board of Equalization races. District number for the office being sought. Populated for Senate, Assembly, or Board of Equalization races. Election type Date of the General Election Entity code Execution Date Filer's unique identification number. Unique filing identification number. First line of the financial Institution's street address. Second line of the financial Institution's street address. Financial institution's city. Financial institution's e-mail address. Financial institution's FAX Number. Unused. Financial Institution first name Financial Institution Business name. Unused. Financial Institution suffix Unused. Financial Institution prefix or title Financial institution's phone number. Financial institution's state Financial Institution's zipcode. Type of Filing or Formset Reporting period from date Office jurisdiction code. Office Jurisdiction Description Candidate/officeholder's moniker. Location of the candidate/officeholder's moniker. Office sought description Office Sought code Political Party Party Code Record Type Value: Report Number; 000 Original; 001-999 Amended Date this report is filed Page 57 Physical Data Model Name STMT_TYPE THRU_DATE YR_OF_ELEC Model_1 Code STMT_TYPE THRU_DATE YR_OF_ELEC Type NUMBER(9) DATE NUMBER(9) P No No No M No No No Label Type of statement Reporting period through date. Year of Election Index List Index Code PK_F501_502 P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID Sort ASC ASC TABLE: F690P2 Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes AMEND_TXT1 CHG_PARTS CHG_SECTS AMEND_TXT1 CHG_PARTS CHG_SECTS VARCHAR2(330) VARCHAR2(100) VARCHAR2(100) No No No No No No EXEC_DATE EXEC_DATE DATE No No FILING_ID FORM_TYPE FILING_ID FORM_TYPE NUMBER(9) VARCHAR2(4) Yes Yes Yes Yes FROM_DATE LINE_ITEM REC_TYPE FROM_DATE LINE_ITEM REC_TYPE DATE NUMBER(9) VARCHAR2(4) No Yes Yes No Yes Yes THRU_DATE THRU_DATE DATE No No Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Description of changes to the filing. "Amended info affects items on part(s)" text description. "Amended info affects items on Section(s)" text description. Date the original report (or prior amendment to the original report) was executed on. Unique filing identification number. Form Type. This must equal form type in the parent cover record (CVR). Reporting period from date of original report Record line item number. Record type value: For this record this will always equal F690. Report period to/through date of original. Index List Index Code PK_F690P2 PowerDesigner P Yes F No A No U Yes C No 2/21/02 Column Code FILING_ID AMEND_ID Sort ASC ASC Page 58 Physical Data Model Model_1 Index Code P F A U C Column Code LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC TABLE: FEDERAL_FORMS Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes COUNTY_OF_DOMICILE COUNTY_OF_DOMICILE COUNTY_WITH_VOTERS COUNTY_WITH_VOTERS ENTITY_CD ENTITY_CD FILER_ID FILER_ID FILING_ID FILING_ID FORM_TYPE FORM_TYPE PERIOD_END PERIOD_END PERIOD_START PERIOD_START PURGE_DATE PURGE_DATE REC_TYPE REC_TYPE RECIEVE_DATE RECIEVE_DATE VARCHAR2(128) VARCHAR2(128) VARCHAR2(3) VARCHAR2(7) NUMBER(9) VARCHAR2(4) DATE DATE DATE VARCHAR2(3) DATE No No No No Yes Yes No No No Yes No No No No No Yes Yes No No No Yes No RPT_TYPE SESSION_ID NUMBER(9) NUMBER(9) No No No No RPT_TYPE SESSION_ID Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. County of domicile. County with voters Filer's Entity code. Filer's identification number. Unique filing identification number. Type of Filing or Formset Filing's period ending date. Filing's period starting date. Date filing should be purged. Record Type Value: Date recieved by the Secretary of State's Political Reform Division. Report type. Session identification number. Index List Index Code PK_FEDERAL_FORMS P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC TABLE: FEES PowerDesigner 2/21/02 Page 59 Physical Data Model Model_1 Column List Name AMOUNT EFFECT_DT FEE_DESC FEE_GROUP FEE_ID FEE_NAME Code AMOUNT EFFECT_DT FEE_DESC FEE_GROUP FEE_ID FEE_NAME Type NUMBER(12,2) DATE VARCHAR2(255) NUMBER(9) NUMBER(9) VARCHAR2(255) P No No No No Yes No M No No No No Yes No Label Amount Effective Date Fee Description Fee group Unique fee identification number. Fee name Index List Index Code PK_FEES P Yes F No A No U Yes C No Column Code FEE_ID Sort ASC TABLE: FILER_ACRONYMS Column List Name ACRONYM FILER_ID Code ACRONYM FILER_ID Type VARCHAR2(32) NUMBER(9) P Yes Yes M Yes Yes Label AMS - Acronym Filer's unique identification number. Index List Index Code PK_FILER_ACRONYMS P Yes F No A No U Yes C No Column Code ACRONYM FILER_ID Sort ASC ASC TABLE: FILER_ADDRESS Column List Name ADD_TYPE ADRID PowerDesigner Code ADD_TYPE ADRID Type NUMBER(9) NUMBER(9) P No Yes 2/21/02 M No Yes Label Type of Address Adress idenification number. Page 60 Physical Data Model Name EFFECT_DT FILER_ID SESSION_ID Model_1 Code EFFECT_DT FILER_ID SESSION_ID Type DATE NUMBER(9) NUMBER(9) P No Yes No M No Yes No Label Address Effective Date Filer's identification number Session identification number. Index List Index Code IX_FA_ADRID IX_FA_FILER_ID IX_FILER_ADD_ADD_TYPE PK_FILER_ADDRESS P No No No Yes F No Yes No No A No No No No U No No No Yes C No No No No Column Code ADRID FILER_ID ADD_TYPE FILER_ID ADRID Sort ASC ASC ASC ASC ASC TABLE: FILER_AUTHENTICATION Column List FILER_ID Name FILER_ID Code Type NUMBER(9) P Yes M Yes FILER_PASSWORD LOGON_NAME FILER_PASSWORD LOGON_NAME BLOB(4000) VARCHAR2(32) No No No No Label Filer's unique identification number. Used along with the password to authenticate filers when the file electronically. Filer's password used for electronic filing. Filer's logon name. This field is populated but not used within the system. Index List Index Code PK_FILER_AUTHENTICATION P Yes F No A No U Yes C No Column Code FILER_ID Sort ASC TABLE: FILER_CORRESPONDENCE_BUILD2 Column List Name PowerDesigner Code Type P 2/21/02 M Label Page 61 Physical Data Model Name ACCT_ID BODY_TEXT COMMENTS COR_DESC CREATE_DT DOC_ID FILER_ID FILING_DUE_DT FILING_ID FILING_SEQUENCE Model_1 Code ACCT_ID BODY_TEXT COMMENTS COR_DESC CREATE_DT DOC_ID FILER_ID FILING_DUE_DT FILING_ID FILING_SEQUENCE Type NUMBER(9) BLOB(4000) VARCHAR2(256) NUMBER(9) DATE NUMBER(9) NUMBER(9) DATE NUMBER(9) NUMBER(9) LOB_REF_PERIOD LOB_REF_PERIOD NUMBER(9) NF_FORM_ID NF_FORM_ID VARCHAR2(128) PLAIN_TEXT PLAIN_TEXT VARCHAR2(4000) PRINT_DT PRINT_DT DATE REF_COR_ID REF_COR_ID NUMBER(9) REF_END_DT REF_END_DT DATE REF_STRT_DT REF_STRT_DT DATE REGARDING_CD REGARDING_CD NUMBER(9) RESPONSE_DT RESPONSE_DT DATE STATUS_CD STATUS_CD NUMBER(9) SYSTEM_GENERATED_Y SYSTEM_GENERATED_Y VARCHAR2(1) N N USER_ID USER_ID VARCHAR2(12) P No No No No No Yes No No No No M No No No No No Yes No No No No No No No No No No No No No No No No No No No No No No No No No No Label AMS - Account Id AMS - Correspondence body text AMS - Comments AMS - Correspondence Description AMS - Create Date AMS - Document Identification number. Unique identification number of filer. AMS - Filing Due Date AMS - Unique filing identification number. AMS - Amendment number where 0 is an original filing and 1 to 999 are amendments. AMS AMS AMS - Plain Text AMS - Print date. AMS AMS AMS AMS AMS AMS - Correspondence Status Code. AMS - System generated flag. No No AMS - User Identifier. Index List Index Code IX_FC_FILER_ID IX_FIL_COR_B2_LOB_REF_PRD IX_FIL_COR_B2_REF_END_DT IX_FIL_COR_B2_REGARD_CD PK_FILER_CORRESPONDENCE_BUILD2 P No No No No Yes F Yes No No No No A No No No No No U No No No No Yes C No No No No No Column Code FILER_ID LOB_REF_PERIOD REF_END_DT REGARDING_CD DOC_ID Sort ASC ASC ASC ASC ASC TABLE: FILER_ELECTIONS Column List PowerDesigner 2/21/02 Page 62 Physical Data Model Name CERTIFIED_YN FILER_ID RACE_ID RACE_RESULT Model_1 Code CERTIFIED_YN FILER_ID RACE_ID RACE_RESULT Type CHAR(1) NUMBER(9) NUMBER(9) CHAR(1) P No Yes Yes No M No Yes Yes No Label Index List Index Code IX_FE_CERTIFIED_YN IX_FE_RACE_ID IX_FE_RACE_RESULT IX_FEL_FILER_ID PK_FILER_ELECTIONS P No No No No Yes F No Yes No Yes No A No No No No No U No No No No Yes C No No No No No Column Code CERTIFIED_YN RACE_ID RACE_RESULT FILER_ID RACE_ID FILER_ID Sort ASC ASC ASC ASC ASC ASC TABLE: FILER_ETHICS_CLASS Column List Name ETHICS_DATE FILER_ID SESSION_ID Code ETHICS_DATE FILER_ID SESSION_ID Type DATE NUMBER(9) NUMBER(9) P Yes Yes Yes M Yes Yes Yes Label Date ethics training was accomplished. Filer's (lobbyist) identification number. Session identification number. Index List Index Code IX_FE_FILER_ID IX_FILER_ETHICS_CLASS_SESS_ID PK_FILER_ETHICS_CLASS P No No Yes F Yes No No A No No No U No No Yes C No No No Column Code FILER_ID SESSION_ID FILER_ID SESSION_ID ETHICS_DATE Sort ASC ASC ASC ASC ASC TABLE: FILER_FILINGS PowerDesigner 2/21/02 Page 63 Physical Data Model Model_1 Column List Name FILER_ID FILING_DATE FILING_ID FILING_SEQUENCE Code FILER_ID FILING_DATE FILING_ID FILING_SEQUENCE Type NUMBER(9) DATE NUMBER(9) NUMBER(9) P Yes No Yes Yes M Yes No Yes Yes FINE_AUDIT FORM_ID PERIOD_ID FINE_AUDIT FORM_ID PERIOD_ID NUMBER(9) VARCHAR2(7) NUMBER(9) No Yes No No Yes No RPT_DATE RPT_END RPT_START SESSION_ID SPECIAL_AUDIT RPT_DATE RPT_END RPT_START SESSION_ID SPECIAL_AUDIT DATE DATE DATE NUMBER(9) NUMBER(9) No No No No No No No No No No STMNT_STATUS STMNT_STATUS NUMBER(9) No No STMNT_TYPE STMNT_TYPE NUMBER(9) No No USER_ID USER_ID VARCHAR2(12) No No Label Filer's unique identification number. Date the filing is entered into the system. Unique filing identification number. Amendment number where 0 is an original filing and 1 to 999 are amendments. Indicates whether a filing has been audited for a fine. Form Identification code Period identification number. Identifies the period when the filing was recieved. When SOS recieved the filing. Ending date for the period the filing represents. Starting date for the period the filing represents. Legislatitive session that the filing applies to. Denotes whether the filing has been audited for money laundering or other special condition. The status of the statement. If the filing has been reviewed or not reviewed. Type of statement. (Logged paper, electronic or KDE filing) User Identifier of the PRD user who logged the filing. Index List Index Code IX_FF_FD_FORM_ID IX_FF_FDT_FM_ID P No No F No No A No No U No No C No No IX_FF_FILER_ID IX_FF_FILING_DATE IX_FF_FILING_ID IX_FF_FILING_SEQUENCE IX_FF_FINE_AUDIT IX_FF_NON_FILER No No No No No No Yes No Yes No No No No No No No No No No No No No No No No No No No No No IX_FF_PERIOD_ID IX_FF_RPT_DATE No No No No No No No No No No PowerDesigner 2/21/02 Column Code FORM_ID FORM_ID FILING_DATE FILER_ID FILING_DATE FILING_ID FILING_SEQUENCE FINE_AUDIT FILER_ID RPT_END FORM_ID PERIOD_ID RPT_DATE Sort ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC Page 64 Physical Data Model Model_1 Index Code IX_FF_RPT_END IX_FF_RPT_START IX_FF_SESSION_ID IX_FF_STMNT_STATUS IX_FF_STMNT_TYPE PK_FILER_FILINGS P No No No No No Yes F No No No No No No A No No No No No No U No No No No No Yes C No No No No No No Column Code RPT_END RPT_START SESSION_ID STMNT_STATUS STMNT_TYPE FILER_ID FILING_ID FORM_ID FILING_SEQUENCE Sort ASC ASC ASC ASC ASC ASC ASC ASC ASC TABLE: FILER_ID_TEMP Column List Name FILER_ID NEW_ID Code FILER_ID NEW_ID Type NUMBER(9) NUMBER(9) P No No M No No Label Filer's unique identification number. New identification number. Type DATE NUMBER(9) NUMBER(9) NUMBER(9) P Yes Yes Yes Yes M Yes Yes Yes Yes Label Effective Date Filer's unique identification number. Filer's interest code. Session identification number TABLE: FILER_INTERESTS Column List Name EFFECT_DATE FILER_ID INTEREST_CD SESSION_ID Code EFFECT_DATE FILER_ID INTEREST_CD SESSION_ID Index List Index Code IX_FI_FILER_ID PK_FILER_INTERESTS PowerDesigner P No No F Yes No A No No U No Yes C No No 2/21/02 Column Code FILER_ID FILER_ID INTEREST_CD EFFECT_DATE SESSION_ID Sort ASC ASC ASC ASC ASC Page 65 Physical Data Model Model_1 TABLE: FILER_LINKS Column List Name ACTIVE_FLG DOMINATE_FILER EFFECT_DT FILER_ID_A Code ACTIVE_FLG DOMINATE_FILER EFFECT_DT FILER_ID_A Type VARCHAR2(1) VARCHAR2(1) DATE NUMBER(9) P Yes No No Yes M Yes No No Yes FILER_ID_B FILER_ID_B NUMBER(9) Yes Yes LINK_DESC LINK_TYPE SESSION_ID TERMINATION_DT LINK_DESC LINK_TYPE SESSION_ID TERMINATION_DT VARCHAR2(255) NUMBER(9) NUMBER(9) DATE No Yes Yes No No Yes Yes No Label Indicates if the link is active. Unused. Date the link became active. Filer's unique identification number for the first filer in the relationship. Filer's unique identification number for the second filer in the relationship. Unused. Denotes the type of the link. Session identification number. Date the relationship was terminated. Index List Index Code IX_FL_ACTIVE_FLG IX_FL_EFFECT_DT IX_FL_FILER_ID_A IX_FL_FILER_ID_B IX_FL_LINK_TYPE IX_FL_SESSION_ID IX_FL_TERMINATION_DT PK_FILER_LINKS P No No No No No No No Yes F No No Yes Yes No No No No A No No No No No No No No U No No No No No No No Yes C No No No No No No No No Column Code ACTIVE_FLG EFFECT_DT FILER_ID_A FILER_ID_B LINK_TYPE SESSION_ID TERMINATION_DT FILER_ID_A FILER_ID_B ACTIVE_FLG SESSION_ID LINK_TYPE Sort ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC TABLE: FILER_NAMES Column List PowerDesigner 2/21/02 Page 66 Physical Data Model Model_1 ACTIVE EFFECT_DT FILER_ID NAME_TYPE NAMID ACTIVE EFFECT_DT FILER_ID NAME_TYPE NAMID VARCHAR2(1) DATE NUMBER(9) NUMBER(9) NUMBER(9) No No Yes No Yes No No Yes No Yes SESSION_ID SESSION_ID NUMBER(9) No No Indicates if the name is currently active. The name's effective date. Filer's unique identification number. Reserved for future use. Name identification number that uniquely identifies the name in the NAMES table. The session identification number. Index List Index Code IX_FILER_NAMES_EFF_DT IX_FN_ACTIVE IX_FN_FILER_ID IX_FN_NAMID IX_FN_SESSION_ID PK_FILER_NAMES P No No No No No Yes F No No Yes Yes No No A No No No No No No U No No No No No Yes C No No No No No No Column Code EFFECT_DT ACTIVE FILER_ID NAMID SESSION_ID FILER_ID NAMID Sort ASC ASC ASC ASC ASC ASC ASC TABLE: FILER_NOTICE_GENERATION_DEF Column List Name COR_DESC COR_ID ELECTION FILER_TYPE RPT_PERIOD_DESC Code COR_DESC COR_ID ELECTION FILER_TYPE RPT_PERIOD_DESC Type NUMBER(9) NUMBER(9) NUMBER(9) NUMBER(9) NUMBER(9) P No Yes Yes Yes Yes M No Yes Yes Yes Yes Label Correspondence Description Correspondence identification number. Election Filer type identification number. Report period description Index List Index Code PK_FILER_NOTICE_GENERATION_DEF PowerDesigner P Yes F No A No U Yes C No 2/21/02 Column Code COR_ID FILER_TYPE RPT_PERIOD_DESC ELECTION Sort ASC ASC ASC ASC Page 67 Physical Data Model Model_1 TABLE: FILER_OBLIGATIONS Column List Name FILER_TYPE PERIOD_ID Code FILER_TYPE PERIOD_ID Type NUMBER(9) NUMBER(9) P Yes Yes M Yes Yes Label Filer type identification number. Period identification number. Index List Index Code PK_FILER_OBLIGATIONS P Yes F No A No U Yes C No Column Code PERIOD_ID FILER_TYPE Sort ASC ASC TABLE: FILER_STATUS_TYPES Column List Name STATUS_DESC STATUS_TYPE Code STATUS_DESC STATUS_TYPE Type VARCHAR2(100) VARCHAR2(3) P No Yes M No Yes Label STATUS_DESC STATUS_TYPE Index List Index Code PK_FILER_STATUS_TYPES P Yes F No A No U Yes C No Column Code STATUS_TYPE Sort ASC TABLE: FILER_TO_FILER_TYPE Column List Name ACTIVE CATEGORY PowerDesigner Code ACTIVE CATEGORY Type VARCHAR2(1) NUMBER(9) 2/21/02 P No No M No No Label Indicates if the filer is currently active. Defines the filer's category such as controlled, jointly controlled, etc. (subset of the filer's type) Page 68 Physical Data Model Model_1 Name CATEGORY_TYPE Code CATEGORY_TYPE Type NUMBER(9) P No M No COUNTY_CD DISTRICT_CD COUNTY_CD DISTRICT_CD NUMBER(9) NUMBER(9) No No No No EFFECT_DT ELECTION_TYPE FILER_ID FILER_TYPE NYQ_DT EFFECT_DT ELECTION_TYPE FILER_ID FILER_TYPE NYQ_DT DATE NUMBER(9) NUMBER(9) NUMBER(9) DATE Yes No Yes Yes No Yes No Yes Yes No PARTY_CD RACE PARTY_CD RACE NUMBER(9) NUMBER(9) No No No No SESSION_ID SUB_CATEGORY SESSION_ID SUB_CATEGORY NUMBER(9) NUMBER(9) Yes No Yes No VARCHAR2(1) NUMBER(9) No No No No SUB_CATEGORY_A SUB_CATEGORY_A SUB_CATEGORY_TYPE SUB_CATEGORY_TYPE Label When applicable, the category type specifies addition information about the category. (E.g. State, local, etc.) Filer's county code. Filer's district number for the office being sought. Populated for Senate, Assembly, or Board of Equalization races. The date the filer assumed the current class or type. Indicates type of election (General, Primary, or Special). Filer's unique identifiction number Filer type identification number. Defines the type of filer. Indicates the date when a committee reached it's qualifying level of activity. Filer's political party. If applicable indicates the race in which the filer is running. Legislatitive session identification number. When applicable specifies general purpose, primarily formed, etc. Indicates if sponsored or not. When applicable specifies broadbased or small contributor. Index List Index Code IX_FTFT_ACTIVE IX_FTFT_CAT_TYPE IX_FTFT_CATEGORY IX_FTFT_DISTRICT_CD IX_FTFT_EFFECT_DT IX_FTFT_ELECTION_TYPE IX_FTFT_FILER_ID IX_FTFT_FILER_TYPE IX_FTFT_FT_A_EF_DT P No No No No No No No No No F No No No No No No Yes No No A No No No No No No No No No U No No No No No No No No No C No No No No No No No No No IX_FTFT_RACE IX_FTFT_SESSION_ID IX_FTFT_SUB_CAT No No No No No No No No No No No No No No No PowerDesigner 2/21/02 Column Code ACTIVE CATEGORY_TYPE CATEGORY DISTRICT_CD EFFECT_DT ELECTION_TYPE FILER_ID FILER_TYPE FILER_TYPE ACTIVE EFFECT_DT RACE SESSION_ID SUB_CATEGORY Sort ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC Page 69 Physical Data Model Model_1 Index Code PK_FILER_TO_FILER_TYPE P Yes F No A No U Yes C No Column Code FILER_ID FILER_TYPE SESSION_ID EFFECT_DT Sort ASC ASC ASC ASC TABLE: FILER_TYPE_PERIODS Column List Name ELECTION_TYPE FILER_TYPE PERIOD_ID Code ELECTION_TYPE FILER_TYPE PERIOD_ID Type NUMBER(9) NUMBER(9) NUMBER(9) P Yes Yes Yes M Yes Yes Yes Label Election type Filer type identification number. Period identification number. Index List Index Code PK_FILER_TYPE_PERIODS P Yes F No A No U Yes C No Column Code FILER_TYPE PERIOD_ID ELECTION_TYPE Sort ASC ASC ASC TABLE: FILER_TYPES Column List Name CALC_USE DESCRIPTION FILER_TYPE GRACE_PERIOD GRP_TYPE Code CALC_USE DESCRIPTION FILER_TYPE GRACE_PERIOD GRP_TYPE Type VARCHAR2(1) VARCHAR2(255) NUMBER(9) NUMBER(9) NUMBER(9) P No No Yes No No M No No Yes No No Label Use checkbox flag. Description of the filer type. Filer type identification number. Grace Period Group type assocated with the filer type. Index List Index Code PowerDesigner P F A U 2/21/02 C Column Code Sort Page 70 Physical Data Model Model_1 Index Code PK_FILER_TYPES P Yes F No A No U Yes C No Column Code FILER_TYPE Sort ASC TABLE: FILER_TYPES_TO_FORMS Column List Name FILER_TYPE FORM_ID Code FILER_TYPE FORM_ID Type NUMBER(9) VARCHAR2(7) P Yes Yes M Yes Yes Label Filer type identification number. Form Identification code Index List Index Code PK_FILER_TYPES_TO_FORMS P Yes F No A No U Yes C No Column Code FILER_TYPE FORM_ID Sort ASC ASC TABLE: FILER_XREF Column List Name EFFECT_DT FILER_ID MIGRATION_SOURCE Code EFFECT_DT FILER_ID MIGRATION_SOURCE Type DATE NUMBER(9) VARCHAR2(50) P No Yes No M No Yes No XREF_ID XREF_ID VARCHAR2(32) Yes Yes Label Effective Date Filer's unique identification number. Source of the XREF_ID. Migration or generated by the AMS. Cross-reference identification number unique to the filer. This can be a mixture of characters and numbers. Index List Index Code IX_XREF_FILER_ID IX_XREF_ID_FXREF PK_FILER_XREF PowerDesigner P No No Yes F Yes No No A No No No U No Yes Yes C No No No 2/21/02 Column Code FILER_ID XREF_ID FILER_ID XREF_ID Sort ASC ASC ASC ASC Page 71 Physical Data Model Model_1 TABLE: FILERS Column List Name FILER_ID Code Type NUMBER(9) FILER_ID P Yes M Yes Label The unique identification number for every filer within the system. Index List Index Code P Yes PK_FILERS F No A No U Yes C No Column Code FILER_ID Sort ASC TABLE: FILING_ERROR_TYPES Column List Name ERR_ID ERR_TEXT ERR_TYPE Code ERR_ID ERR_TEXT ERR_TYPE Type NUMBER(9) VARCHAR2(2000) NUMBER(9) P Yes No No M Yes No No Label Unique error identification number. Error message content Error Type Index List Index Code PK_FILING_ERROR_TYPES P Yes F No A No U Yes C No Column Code ERR_ID Sort ASC TABLE: FILING_ERRORS Column List Name ERR_ID ERR_SEQ FILING_ID PowerDesigner Code ERR_ID ERR_SEQ FILING_ID Type NUMBER(9) NUMBER(9) NUMBER(9) P Yes Yes Yes 2/21/02 M Yes Yes Yes Label Unique error identification number. Error sequence number. Unique filing identification number. Page 72 Physical Data Model Model_1 Name FILING_SEQUENCE Code FILING_SEQUENCE Type NUMBER(9) P Yes M Yes SCHEDULE_TYPE SCHEDULE_TYPE VARCHAR2(1500) No No Label Filing's amendment number. A value of 0 indicates an original and 1 to 999 are amendments. Type of schedule assocated with the error. Index List Index Code IX_FE_FILINGS_FILING_ID PK_FILING_ERRORS P No Yes F Yes No A No No U No Yes C No No Column Code FILING_ID FILING_ID FILING_SEQUENCE ERR_ID ERR_SEQ Sort ASC ASC ASC ASC ASC TABLE: FILING_ID_TEMP Column List Name FILER_ID FILING_ID NEW_ID Code FILER_ID FILING_ID NEW_ID Type NUMBER(9) NUMBER(9) NUMBER(9) P No No No M No No No Type DATE DATE NUMBER(9) VARCHAR2(255) NUMBER(9) NUMBER(9) DATE P No No No No Yes No No M No No No No Yes No No Label TABLE: FILING_PERIOD Column List Name DEADLINE END_DATE PER_GRP_TYPE PERIOD_DESC PERIOD_ID PERIOD_TYPE START_DATE PowerDesigner Code DEADLINE END_DATE PER_GRP_TYPE PERIOD_DESC PERIOD_ID PERIOD_TYPE START_DATE 2/21/02 Label Deadline date Ending date of period Period group type Period description Unique period identification number. Period's type. Starting date for period Page 73 Physical Data Model Model_1 Index List Index Code IX_FP_BETWEEN_DATE P No F No A No U No C No IX_FP_END_DATE IX_FP_START_DT PK_FILING_PERIOD No No Yes No No No No No No No No Yes No No No Column Code START_DATE END_DATE END_DATE START_DATE PERIOD_ID Sort ASC ASC ASC ASC ASC TABLE: FILINGS Column List Name FILING_ID FILING_TYPE Code FILING_ID FILING_TYPE Type NUMBER(9) NUMBER(9) P Yes No M Yes No Label Unique filing identification number. The type of filing. (E.g. KDE, AMS, Legacy, Electronic, etc.) Index List Index Code IX_FILINGS_FILING_TYPE PK_FILINGS P No Yes F No No A No No U No Yes C No No Column Code FILING_TYPE FILING_ID Sort ASC ASC TABLE: FINANCIAL_ACCOUNTS_BUILD2 Column List Name ACCT_AMOUNT ACCT_ID ACCT_STATUS ACCT_TYPE BALANCE COMMENTS DEL_FLG DUE_DT PowerDesigner Code ACCT_AMOUNT ACCT_ID ACCT_STATUS ACCT_TYPE BALANCE COMMENTS DEL_FLG DUE_DT Type NUMBER(12,2) NUMBER(9) NUMBER(9) NUMBER(9) NUMBER(12,2) VARCHAR2(255) NUMBER(9) DATE 2/21/02 P No Yes No No No No No No M No Yes No No No No No No Label AMS - Account Amount AMS - Account Identification number. Account Status indicator The type of account. Account balance. Comments Deleted Flag Due Date Page 74 Physical Data Model Name FILER_ID FILING_ID NUMBER_PAYMENTS OPEN_DT PAYMENT_PERIOD PERIOD_BEGIN_DT PERIOD_CLOSE_DT PERIOD_ID SESSION_ID USER_ID Model_1 Code FILER_ID FILING_ID NUMBER_PAYMENTS OPEN_DT PAYMENT_PERIOD PERIOD_BEGIN_DT PERIOD_CLOSE_DT PERIOD_ID SESSION_ID USER_ID Type NUMBER(9) NUMBER(9) NUMBER(9) DATE NUMBER(9) DATE DATE NUMBER(9) NUMBER(9) VARCHAR2(12) P No No No No No No No No No No M No No No No No No No No No No Label Unique filer identification number. Unique filing identification number. Number of payments. Open Date Payment period identification number. Period beginning date Period closing date. Period identification number. Session Identification number. AMS - User Identifier of the staff who processed the transaction. Index List Index Code IX_FAB_ACCT_TYPE IX_FAB_FILER_ID IX_FAB_FILING_ID IX_FAB_OPEN_DT IX_FAB_SESSION_ID PK_FINANCIAL_ACCOUNTS_BUILD2 P No No No No No Yes F No Yes No No No No A No No No No No No U No No No No No Yes C No No No No No No Column Code ACCT_TYPE FILER_ID FILING_ID OPEN_DT SESSION_ID ACCT_ID Sort ASC ASC ASC ASC ASC ASC TABLE: FINANCIAL_TRANS_BUILD2 Column List Name ACCT_ID COMMENTS COR_ID FILER_ID METHOD_OF_PMNT NAMF NAML NAMS NAMT NUM_ITEMS_PURCHASE D PowerDesigner Code ACCT_ID COMMENTS COR_ID FILER_ID METHOD_OF_PMNT NAMF NAML NAMS NAMT NUM_ITEMS_PURCHASE D Type NUMBER(9) VARCHAR2(255) NUMBER(9) NUMBER(9) NUMBER(9) VARCHAR2(50) VARCHAR2(200) VARCHAR2(30) VARCHAR2(100) NUMBER(9) 2/21/02 P No No No No No No No No No No M No No No No No No No No No No Label Account Identification number. Comments Correspondence identification number. Unique filer identification number. Payment method. First name. Last name Name suffix Name prefix or title. Number of items purchased. Page 75 Physical Data Model Model_1 Name REF_TRAN_ID SOURCE_OF_RECORD TRAN_AMOUNT TRAN_CODE TRAN_DT TRAN_ID Code REF_TRAN_ID SOURCE_OF_RECORD TRAN_AMOUNT TRAN_CODE TRAN_DT TRAN_ID Type NUMBER(9) NUMBER(9) NUMBER(12,2) VARCHAR2(32) DATE NUMBER(9) P No No No No No Yes M No No No No No Yes TRAN_TYPE USER_ID TRAN_TYPE USER_ID NUMBER(9) VARCHAR2(12) No No No No Label Reference transaction identification number. Source of the record. Amount of the transaction. Transaction code. Transction date. Transaction identifier - permanent value unique to this item Transaction Type User Identifier of the staff member who processed the transaction Index List Index Code PK_FINANCIAL_TRANS_BUILD2 P Yes F No A No U Yes C No Column Code TRAN_ID Sort ASC TABLE: FORM_CODES Column List Name CODE FORM_TYPE REC_TYPE Code Type VARCHAR2(3) VARCHAR2(7) VARCHAR2(7) CODE FORM_TYPE REC_TYPE P Yes Yes Yes M Yes Yes Yes Label Code value Type of Filing or Formset Record Type Value: Index List Index Code PK_FORM_CODES P Yes F No A No U Yes C No Column Code CODE FORM_TYPE REC_TYPE Sort ASC ASC ASC TABLE: FORMAT_CODES Column List PowerDesigner 2/21/02 Page 76 Physical Data Model Name CODE CODE_TYPE DESCRIPTION Model_1 Code CODE CODE_TYPE DESCRIPTION Type VARCHAR2(10) NUMBER(9) VARCHAR2(128) P Yes Yes No M Yes Yes No Label Code Code Type Description Index List Index Code PK_FORMAT_CODES P Yes F No A No U Yes C No Column Code CODE_TYPE CODE Sort ASC ASC TABLE: FORMS Column List Name CALC_USE DESCRIPTION DISPLAY FORM_ID FORM_TYPE HTML_DISPLAY Code CALC_USE DESCRIPTION DISPLAY FORM_ID FORM_TYPE HTML_DISPLAY Type VARCHAR2(1) VARCHAR2(255) VARCHAR2(1) VARCHAR2(7) NUMBER(9) VARCHAR2(1) P No No No Yes No No M No No No Yes No No Label Use checkbox flag. Description of the form Display checkbox flag. Form Identification code Type of filing or formset. HTML Display flag. Index List Index Code PK_FORMS P Yes F No A No U Yes C No Column Code FORM_ID Sort ASC TABLE: GROUP_TYPES Column List Name GRP_DESC GRP_ID GRP_NAME PowerDesigner Code GRP_DESC GRP_ID GRP_NAME Type VARCHAR2(255) NUMBER(9) VARCHAR2(128) 2/21/02 P No Yes No M No Yes No Label Group's description Group identification number. Group name. Page 77 Physical Data Model Model_1 Index List Index Code PK_GROUP_TYPES P Yes F No A No U Yes C No Column Code GRP_ID Sort ASC TABLE: HDR Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes CAL_VER EF_TYPE CAL_VER EF_TYPE VARCHAR2(4) VARCHAR2(3) No No No No FILING_ID HDRCOMMENT FILING_ID HDRCOMMENT NUMBER(9) VARCHAR2(200) Yes No Yes No REC_TYPE REC_TYPE VARCHAR2(3) No No SOFT_NAME SOFT_VER STATE_CD SOFT_NAME SOFT_VER STATE_CD VARCHAR2(90) VARCHAR2(16) VARCHAR2(2) No No No No No No Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. CAL Version number the filing was made using. Electronic filing type. This will always have the value of "CAL". Unique filing identification number. Header Comment. Typically used for development and test filings. Record Type Value: This value should always equal HDR. Filing software name used to electronically file. Filing software version number. The state code value entered in the electronic filing. Index List Index Code IX_HDR_AMEND_ID IX_HDR_FILING_ID IX_HDR_SOFT_NAME PK_HDR P No No No Yes F No Yes No No A No No No No U No No No Yes C No No No No Column Code AMEND_ID FILING_ID SOFT_NAME FILING_ID AMEND_ID Sort ASC ASC ASC ASC ASC TABLE: HEADER Column List PowerDesigner 2/21/02 Page 78 Physical Data Model Name COLUMN_A COLUMN_B COLUMN_C COMMENTS1 COMMENTS2 FORM_ID LABEL LINE_NUMBER REC_TYPE SECTION_LABEL SHOW_B SHOW_C Model_1 Code COLUMN_A COLUMN_B COLUMN_C COMMENTS1 COMMENTS2 FORM_ID LABEL LINE_NUMBER REC_TYPE SECTION_LABEL SHOW_B SHOW_C Type NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) VARCHAR2(128) VARCHAR2(128) VARCHAR2(7) VARCHAR2(128) NUMBER(9) VARCHAR2(32) VARCHAR2(64) NUMBER(9) NUMBER(9) P No No No No No Yes No Yes Yes No No No M No No No No No Yes No Yes Yes No No No Label Column A Column B Column C Comments Comments Form Identification code LABEL LINE_NUMBER Record Type Value: Section Label SHOW_B SHOW_C Index List Index Code PK_HEADER P Yes F No A No U Yes C No Column Code LINE_NUMBER FORM_ID REC_TYPE Sort ASC ASC ASC TABLE: IMAGE_LINKS Column List Name IMG_DT IMG_ID IMG_LINK_ID IMG_LINK_TYPE IMG_TYPE Code IMG_DT IMG_ID IMG_LINK_ID IMG_LINK_TYPE IMG_TYPE Type DATE NUMBER(9) NUMBER(9) NUMBER(9) NUMBER(9) P No Yes Yes No No M No Yes Yes No No Label Image Date Image identification number. Image link identification number. Image link type. Image Type Index List Index Code PK_IMAGE_LINKS PowerDesigner P Yes F No A No U Yes C No 2/21/02 Column Code IMG_LINK_ID IMG_ID Sort ASC ASC Page 79 Physical Data Model Model_1 TABLE: IMAGES Column List Name Code FORMAT IMAGE IMAGE_ID PATH Type CHAR(8) BLOB(4000) VARCHAR2(9) VARCHAR2(2000) FORMAT IMAGE IMAGE_ID PATH P No No Yes No M No No Yes No Label Image Format Image Blob Image Identifier. Path to where image is located Index List Index Code PK_IMAGES P Yes F No A No U Yes C No Column Code IMAGE_ID Sort ASC TABLE: LATE_CONT_IND_EXP_REPORT Column List Name AMOUNT CONTEST CONTRIB_NAME ITEM_COL10 ITEM_COL11 ITEM_COL12 ITEM_COL13 ITEM_COL14 ITEM_COL15 ITEM_COL16 ITEM_COL17 ITEM_COL18 ITEM_COL19 ITEM_COL20 ITEM_COL8 ITEM_COL9 RECPT_CAN_MEASURE PowerDesigner Code AMOUNT CONTEST CONTRIB_NAME ITEM_COL10 ITEM_COL11 ITEM_COL12 ITEM_COL13 ITEM_COL14 ITEM_COL15 ITEM_COL16 ITEM_COL17 ITEM_COL18 ITEM_COL19 ITEM_COL20 ITEM_COL8 ITEM_COL9 RECPT_CAN_MEASURE Type VARCHAR2(32) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) VARCHAR2(1000) 2/21/02 P No No No No No No No No No No No No No No No No No M No No No No No No No No No No No No No No No No No Label Amount Received Contest Contributor Name ITEM_COL10 ITEM_COL11 ITEM_COL12 ITEM_COL13 ITEM_COL14 ITEM_COL15 ITEM_COL16 ITEM_COL17 ITEM_COL18 ITEM_COL19 ITEM_COL20 ITEM_COL8 ITEM_COL9 RECPT_CAN_MEASURE Page 80 Physical Data Model Name RPT_BY RPT_NUM RPT_SESSION TRANS_DATE Model_1 Code RPT_BY RPT_NUM RPT_SESSION TRANS_DATE Type VARCHAR2(32) VARCHAR2(15) NUMBER(9) VARCHAR2(32) P No No No No M No No No No Label RPT_BY RPT_NUM RPT_SESSION Transaction date. Index List Index Code IX_LATE_CONT_IND_EXP_REPORT P No F No A No U No C No Column Code RPT_SESSION Sort ASC TABLE: LATT Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes AMOUNT CUM_AMT CUMBEG_DT ENTITY_CD FILING_ID FORM_TYPE AMOUNT CUM_AMT CUMBEG_DT ENTITY_CD FILING_ID FORM_TYPE NUMBER(12,2) NUMBER(12,2) DATE VARCHAR2(3) NUMBER(9) VARCHAR2(6) No No No No Yes Yes No No No No Yes Yes LINE_ITEM MEMO_CODE MEMO_REFNO PMT_DATE REC_TYPE RECIP_ADR1 RECIP_ADR2 RECIP_CITY RECIP_NAMF RECIP_NAML LINE_ITEM MEMO_CODE MEMO_REFNO PMT_DATE REC_TYPE RECIP_ADR1 RECIP_ADR2 RECIP_CITY RECIP_NAMF RECIP_NAML NUMBER(9) VARCHAR2(1) VARCHAR2(20) DATE VARCHAR2(4) VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(45) VARCHAR2(200) Yes No No No Yes No No No No No Yes No No No Yes No No No No No RECIP_NAMS RECIP_NAMT RECIP_ST RECIP_NAMS RECIP_NAMT RECIP_ST VARCHAR2(10) VARCHAR2(10) VARCHAR2(2) No No No No No No PowerDesigner 2/21/02 Label Amendment Identification number. A value of 0 indicates an original and 1 to 999 an amendment. Amount of payment Cumulative total to date Cumulative period beginning to date. Entity code [PRM LEM LCO LBY] Unique filing identification number. Schedule Name/ID field legal values include S630, S635, and S640. Record line item number. Memo amount flag Reference to text contained in a TEXT record Date of payment Record Type Value: LATT First line of the recipient's street address. Second line of the recipient's street address. Recipient's City Recipient's first name if the recipient is an individual. Recipient's business name or last name if the recipient is an individual. Recipient's name suffix. Recipient's name prefix or title. Recipient's State Page 81 Physical Data Model Name RECIP_ZIP4 TRAN_ID Model_1 Code RECIP_ZIP4 TRAN_ID Type VARCHAR2(10) VARCHAR2(20) P No No M No No Label Recipient's zip code. Transaction Id - permanent value unique to this item Index List Index Code PK_LATT P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: LCCM Column List Name ACCT_NAME AMEND_ID Code ACCT_NAME AMEND_ID Type VARCHAR2(90) NUMBER(9) P No Yes M No Yes AMOUNT BAKREF_TID AMOUNT BAKREF_TID NUMBER(12,2) VARCHAR2(20) No No No No CTRIB_DATE CTRIB_NAMF CTRIB_DATE CTRIB_NAMF DATE VARCHAR2(45) No No No No CTRIB_NAML CTRIB_NAML VARCHAR2(200) No No CTRIB_NAMS CTRIB_NAMT CTRIB_NAMS CTRIB_NAMT VARCHAR2(10) VARCHAR2(10) No No No No ENTITY_CD FILING_ID FORM_TYPE ENTITY_CD FILING_ID FORM_TYPE VARCHAR2(3) NUMBER(9) VARCHAR2(7) No Yes Yes No Yes Yes LINE_ITEM MEMO_CODE MEMO_REFNO LINE_ITEM MEMO_CODE MEMO_REFNO NUMBER(9) VARCHAR2(1) VARCHAR2(20) Yes No No Yes No No PowerDesigner 2/21/02 Label Name of separate account Amendment Identification number. A value of 0 indicates and original and 1 to 999 an amendment. Amount of contribution Back Reference to a transaction identifier of a parent record. Date of contribution Contributor's first name. This applies on to Form 615 filings. Contributor's last name or business name. This applies on to Form 615 filings Contributor's Suffix. This applies on to Form 615 filings. Contributor's Prefix or Title. This applies on to Form 615 filings. Recipient's entity code. Unique filing identification number. Schedule Name Identification code. Legal values include F615P2, F625P4B, F635P4B, and F645P3B. Record line item number. Memo amount flag Reference to text contained in a TEXT record Page 82 Physical Data Model Model_1 Name REC_TYPE RECIP_ADR1 RECIP_ADR2 RECIP_CITY RECIP_ID RECIP_NAMF RECIP_NAML Code REC_TYPE RECIP_ADR1 RECIP_ADR2 RECIP_CITY RECIP_ID RECIP_NAMF RECIP_NAML Type VARCHAR2(4) VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(9) VARCHAR2(45) VARCHAR2(200) P Yes No No No No No No M Yes No No No No No No RECIP_NAMS RECIP_NAMT RECIP_ST RECIP_ZIP4 TRAN_ID RECIP_NAMS RECIP_NAMT RECIP_ST RECIP_ZIP4 TRAN_ID VARCHAR2(10) VARCHAR2(10) VARCHAR2(2) VARCHAR2(10) VARCHAR2(20) No No No No No No No No No No Label Record Type Value: LCCM First line of the recipient's street address. Second line of the recipient's street address. Recipient's City Recipient's identification number. Recipient's first name if the recipient is an individual. Recipient's business name or last name if the recipient is an individual. Recipient's name suffix. Recipient's name prefix or title. Recipient's State Recipient's zip code. Transaction Id - permanent value unique to this item Index List Index Code PK_LCCM P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: LEGISLATIVE_SESSIONS Column List Name BEGIN_DATE END_DATE SESSION_ID Code BEGIN_DATE END_DATE SESSION_ID Type DATE DATE NUMBER(9) P No No Yes M Yes Yes Yes Label Session begin date Session end date Unique session identification number. Index List Index Code PK_LEGISLATIVE_SESSIONS PowerDesigner P Yes F No A No U Yes C No 2/21/02 Column Code SESSION_ID Sort ASC Page 83 Physical Data Model Model_1 TABLE: LEMP Column List Name AGENCYLIST AMEND_ID Code AGENCYLIST AMEND_ID Type VARCHAR2(200) NUMBER(9) P No Yes M No Yes CLI_ADR1 CLI_ADR2 CLI_CITY CLI_NAMF CLI_NAML CLI_NAMS CLI_NAMT CLI_PHON CLI_ST CLI_ZIP4 CLIENT_ID CLI_ADR1 CLI_ADR2 CLI_CITY CLI_NAMF CLI_NAML CLI_NAMS CLI_NAMT CLI_PHON CLI_ST CLI_ZIP4 CLIENT_ID VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) VARCHAR2(9) No No No No No No No No No No No No No No No No No No No No No No CON_PERIOD DESCRIP EFF_DATE FILING_ID FORM_TYPE CON_PERIOD DESCRIP EFF_DATE FILING_ID FORM_TYPE VARCHAR2(30) VARCHAR2(100) DATE NUMBER(9) VARCHAR2(7) No No No Yes Yes No No No Yes Yes LINE_ITEM REC_TYPE SUB_ADR1 LINE_ITEM REC_TYPE SUB_ADR1 NUMBER(9) VARCHAR2(4) VARCHAR2(55) Yes Yes No Yes Yes No SUB_ADR2 SUB_ADR2 VARCHAR2(55) No No SUB_CITY SUB_NAME SUB_PHON SUB_ST SUB_ZIP4 SUBFIRM_ID SUB_CITY SUB_NAME SUB_PHON SUB_ST SUB_ZIP4 SUBFIRM_ID VARCHAR2(30) VARCHAR2(200) VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) VARCHAR2(9) No No No No No No No No No No No No PowerDesigner 2/21/02 Label Agencies to be lobbied Amendment Identification number. A number of 0 indicates an origingal and 1 to 999 an amendment. First line of the employing client street address. Second line of the employing client street address. Employing client city Employing client first name Employing client last name or business name. Employing client suffix Employing client prefix or title Employing client's phone number. Employing client State Employing client zipcode. Identification number of the Part 2A employer or Part 2B Client/Employer. Period of the contract. Description of employer/client lobbying interests. Effective Date of Lobbying Contract Unique filing identification number. Schedule Name/Identifier. The legal values for this table are F601P2A and F601P2B. Record line item number. Record Type Value: This will always be LEMP. First line of the sub-contracting lobbying firm street address. Second line of the sub-contracting lobbying firm street address. Sub-contracting lobbying firm city. Sub-contracting lobbying firm's name. Sub-contracting lobbying firm phone number. Sub-contracting lobbying firm state. Sub-contracting lobbying firm zipcode. Identification number of the sub-contracting lobbying firm. Page 84 Physical Data Model Model_1 Name Code TRAN_ID Type VARCHAR2(20) TRAN_ID P No M No Label Transaction Identifier - permanent value unique to this item Index List Index Code PK_LEMP P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: LEXP Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes AMOUNT BAKREF_TID AMOUNT BAKREF_TID NUMBER(12,2) VARCHAR2(20) No No No No BENE_AMT BENE_NAME BENE_POSIT CREDCARDCO BENE_AMT BENE_NAME BENE_POSIT CREDCARDCO VARCHAR2(12) VARCHAR2(90) VARCHAR2(90) VARCHAR2(200) No No No No No No No No ENTITY_CD EXPN_DATE EXPN_DSCR FILING_ID FORM_TYPE ENTITY_CD EXPN_DATE EXPN_DSCR FILING_ID FORM_TYPE VARCHAR2(3) DATE VARCHAR2(90) NUMBER(9) VARCHAR2(7) No No No Yes Yes No No No Yes Yes LINE_ITEM MEMO_CODE MEMO_REFNO PAYEE_ADR1 LINE_ITEM MEMO_CODE MEMO_REFNO PAYEE_ADR1 NUMBER(9) VARCHAR2(1) VARCHAR2(20) VARCHAR2(55) Yes No No No Yes No No No PowerDesigner 2/21/02 Label Amendment Identification number. A value of 0 indicates an original filing and 1 to 999 an amendment. Amount of payment Back Reference to a transaction identifier of a parent record. Amount benefiting beneficiary Name of reportable person benefiting Official position of person benefiting Name of the credit card company if paid using a credit card. Entity code Date of expenditure Purpose of expense and/or description/explanation Unique filing identification number. Schedule Name/Idenfifier. Legal values include F615P1, F625P3A, F625P3B, F625P3C, F635P3C, and F645P2A. Record line item number. Memo amount flag Reference to text contained in a TEXT record First line of the payee's street address. Page 85 Physical Data Model Model_1 Name PAYEE_ADR2 PAYEE_CITY PAYEE_NAMF PAYEE_NAML Code PAYEE_ADR2 PAYEE_CITY PAYEE_NAMF PAYEE_NAML Type VARCHAR2(55) VARCHAR2(30) VARCHAR2(45) VARCHAR2(200) P No No No No M No No No No PAYEE_NAMS PAYEE_NAMT PAYEE_ST PAYEE_ZIP4 REC_TYPE PAYEE_NAMS PAYEE_NAMT PAYEE_ST PAYEE_ZIP4 REC_TYPE VARCHAR2(10) VARCHAR2(10) VARCHAR2(2) VARCHAR2(10) VARCHAR2(4) No No No No Yes No No No No Yes RECSUBTYPE TRAN_ID RECSUBTYPE TRAN_ID VARCHAR2(1) VARCHAR2(20) No No No No Label Second line of the payee's street address. Payee's city. Payee's first name if the payee is an individual. Payee's business name or last name if the payee is an individual. Payee's name suffix if the payee is an individual. Payee's prefix or title if the payee is an individual. Payee's state. Payee's zip code. Record Type Value: For this table this will always have a value of LEXP Record Sub-Type (Main or Detail) (1 - Main; 2 - Detail) Transaction identifier - permanent value unique to this item. Index List Index Code PK_LEXP P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: LOAN Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes BAKREF_TID BAKREF_TID VARCHAR2(20) No No CMTE_ID ENTITY_CD FILING_ID FORM_TYPE CMTE_ID ENTITY_CD FILING_ID FORM_TYPE VARCHAR2(9) VARCHAR2(3) NUMBER(9) VARCHAR2(2) No No Yes Yes No No Yes Yes PowerDesigner 2/21/02 Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Back Reference to a transaction identifier of a parent record. Committee Identification number Entity code. Unique filing identification number. Schedule name/identifier. Legal values are B1, B2, B3, H1, H2, and H3. Page 86 Physical Data Model Model_1 Name INTR_ADR1 INTR_ADR2 INTR_CITY INTR_NAMF INTR_NAML INTR_NAMS INTR_NAMT INTR_ST INTR_ZIP4 LINE_ITEM LNDR_NAMF LNDR_NAML LNDR_NAMS LNDR_NAMT LOAN_ADR1 LOAN_ADR2 LOAN_AMT1 Code INTR_ADR1 INTR_ADR2 INTR_CITY INTR_NAMF INTR_NAML INTR_NAMS INTR_NAMT INTR_ST INTR_ZIP4 LINE_ITEM LNDR_NAMF LNDR_NAML LNDR_NAMS LNDR_NAMT LOAN_ADR1 LOAN_ADR2 LOAN_AMT1 Type VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(2) VARCHAR2(10) NUMBER(9) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(55) VARCHAR2(55) NUMBER(12,2) P No No No No No No No No No Yes No No No No No No No M No No No No No No No No No Yes No No No No No No No LOAN_AMT2 LOAN_AMT2 NUMBER(12,2) No No LOAN_AMT3 LOAN_AMT3 NUMBER(12,2) No No LOAN_AMT4 LOAN_AMT4 NUMBER(12,2) No No LOAN_AMT5 LOAN_AMT6 LOAN_AMT7 LOAN_AMT8 LOAN_CITY LOAN_DATE1 LOAN_AMT5 LOAN_AMT6 LOAN_AMT7 LOAN_AMT8 LOAN_CITY LOAN_DATE1 NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) VARCHAR2(30) DATE No No No No No No No No No No No No PowerDesigner 2/21/02 Label First line of the Intermediary's street address. Second line of the Intermediary's street address. Intermediary's City Intermediary's First Name Intermediary's Last Name Intermediary's Suffix Intermediary's Prefix or Title Intermediary's state. Intermediary's zip code. Line item number within the filing. Lender's first name (if a person) Lender's last name or business name. Lender's suffix Lender's Prefix or Title First line of the lender's address. Second line of the lender's address. Repaid or forgiven amount; Original loan amount. The content of this column varies based on the schedule/part that the record applies to. See the cal document for a description of the value of this field. Outstanding Principal; unpaid balance. The content of this column varies based on the schedule/part that the record applies to. See the cal document for a description of the value of this field. Interest Paid; Unpaid interest; Interest received. The content of this column varies based on the schedule/part that the record applies to. See the cal document for a description of the value of this field. Cumulative Amount/Other. The content of this column varies based on the schedule/part that the record applies to. See the cal document for a description of the value of this field. Lender's City Date the loan was made or recieved. The content of this column varies based on the schedule/part that the record applies to. See the cal document for a Page 87 Physical Data Model Model_1 Name Code Type P M LOAN_DATE2 LOAN_DATE2 DATE No No LOAN_EMP LOAN_EMP VARCHAR2(200) No No LOAN_OCC LOAN_OCC VARCHAR2(60) No No LOAN_RATE LOAN_RATE VARCHAR2(30) No No LOAN_SELF LOAN_ST LOAN_TYPE LOAN_SELF LOAN_ST LOAN_TYPE VARCHAR2(1) VARCHAR2(2) VARCHAR2(3) No No No No No No LOAN_ZIP4 MEMO_CODE MEMO_REFNO REC_TYPE LOAN_ZIP4 MEMO_CODE MEMO_REFNO REC_TYPE VARCHAR2(10) VARCHAR2(1) VARCHAR2(20) VARCHAR2(4) No No No Yes No No No Yes TRAN_ID TRAN_ID VARCHAR2(20) No No TRES_ADR1 TRES_ADR1 VARCHAR2(55) No No TRES_ADR2 TRES_ADR2 VARCHAR2(55) No No TRES_CITY TRES_CITY VARCHAR2(30) No No TRES_NAMF TRES_NAML TRES_NAMS TRES_NAMT TRES_ST TRES_NAMF TRES_NAML TRES_NAMS TRES_NAMT TRES_ST VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(2) No No No No No No No No No No TRES_ZIP4 TRES_ZIP4 VARCHAR2(10) No No XREF_MATCH XREF_MATCH VARCHAR2(1) No No XREF_SCHNM XREF_SCHNM VARCHAR2(2) No No PowerDesigner 2/21/02 Label description of the value of this field. Date repaid/forgiven; date loan due. The content of this column varies based on the schedule/part that the record applies to. See the cal document for a description of the value of this field. Loan Employer. Applies to the Form 460 Schedule B Part 1. Loan occupation. Applies to the Form 460 Schedule B Part 1. Interest Rate. The content of this column varies based on the schedule/part that the record applies to. See the cal document for a description of the value of this field. Loan: Self-employed check-box. Lender's State Type of loan. See the CAL document for a list of legal values. Lender's zipcode. Memo amount flag Reference to text contained in a TEXT record Record Type Value: For this table this will always have a value of LOAN. Transaction Identifier - permanent value unique to this item First line of the treasurer or responsible officer's street address. Second line of the treasurer or responsible officer's street address. City portion of the treasurer or responsible officer's street address. Treasurer or responsible officer's first name. Treasurer or responsible officer's last name. Treasurer or responsible officer's suffix. Treasurer or responsible officer's prefix or title. State portion of the treasurer or responsible officer's address. Zip code portion of the treasurer or responsible officer's address. Related item on other schedule has same transaction identifier. "X" indicates this condition is true. Related record is included on Form 460 Schedule 'A' or Page 88 Physical Data Model Model_1 Name Code Type P M Label 'E'. Index List Index Code PK_LOAN P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: LOBBY_AMENDMENTS Column List Name A_L_NAMF A_L_NAML A_L_NAMS A_L_NAMT A_LE_NAMF A_LE_NAML A_LE_NAMS A_LE_NAMT A_LF_NAME ADD_L_CB ADD_L_EFF ADD_LE_CB ADD_LE_EFF ADD_LF_CB ADD_LF_EFF AMEND_ID Code A_L_NAMF A_L_NAML A_L_NAMS A_L_NAMT A_LE_NAMF A_LE_NAML A_LE_NAMS A_LE_NAMT A_LF_NAME ADD_L_CB ADD_L_EFF ADD_LE_CB ADD_LE_EFF ADD_LF_CB ADD_LF_EFF AMEND_ID Type VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(200) VARCHAR2(1) DATE VARCHAR2(1) DATE VARCHAR2(1) DATE NUMBER(9) P No No No No No No No No No No No No No No No Yes M No No No No No No No No No No No No No No No Yes D_L_NAMF D_L_NAML D_L_NAMS D_L_NAMT D_LE_NAMF D_L_NAMF D_L_NAML D_L_NAMS D_L_NAMT D_LE_NAMF VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(45) No No No No No No No No No No PowerDesigner 2/21/02 Label Add lobbyist first name Add lobbyist last name Add lobbyist suffix Add lobbyist prefix or title Add lobbyist employer first name Add lobbyist employer last name Add lobbyist employer siffux Add lobbyist employer prefix or title Add lobbying firm name Add lobbyist check-box Add lobbyist effective date Add lobbyist employer check-box Add lobbyist employer effective date Add lobbying firm check-box Add lobbying firm effective date Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Delete lobbyist first name Delete lobbyist last name Delete lobbyist suffix Delete lobbyist prefix or title Delete lobbyist employer first name Page 89 Physical Data Model Name D_LE_NAML D_LE_NAMS D_LE_NAMT D_LF_NAME DEL_L_CB DEL_L_EFF DEL_LE_CB DEL_LE_EFF DEL_LF_CB DEL_LF_EFF EXEC_DATE F606_NO F606_YES FILING_ID FORM_TYPE FROM_DATE OTHER_CB OTHER_DESC OTHER_EFF REC_TYPE THRU_DATE Model_1 Code D_LE_NAML D_LE_NAMS D_LE_NAMT D_LF_NAME DEL_L_CB DEL_L_EFF DEL_LE_CB DEL_LE_EFF DEL_LF_CB DEL_LF_EFF EXEC_DATE F606_NO F606_YES FILING_ID FORM_TYPE FROM_DATE OTHER_CB OTHER_DESC OTHER_EFF REC_TYPE THRU_DATE Type VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(200) VARCHAR2(1) DATE VARCHAR2(1) DATE VARCHAR2(1) DATE DATE VARCHAR2(1) VARCHAR2(1) NUMBER(9) VARCHAR2(4) DATE VARCHAR2(1) VARCHAR2(100) DATE VARCHAR2(4) DATE P No No No No No No No No No No No No No Yes Yes No No No No Yes No M No No No No No No No No No No No No No Yes Yes No No No No Yes No Label Delete lobbyist employer last name Delete lobbyist employer suffix Delete lobbyist employer prefix or title Delete lobbying firm name Delete lobbyist check-box Delete lobbyist effective date Delete lobbyist employer check-box Delete lobbyist employer effective date Delete lobbying firm check-box Delete lobbying firm effective date Date this amendment executed on Lobbyist ceasing employment, but remains active Lobbyist ceasing all activities (Form 606) Unique filing identification number. Type of Filing or Formset Reporting period from date of original report Other admendments check-box Description of changes Other admendments effective date Record Type Value: F605 Reporting period to/through date of original. Index List Index Code PK_LOBBY_AMENDMENTS P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC TABLE: LOBBYING_CHG_LOG Column List Name ACTION ATTRIBUTE_CHANGED CHANGE_NO PowerDesigner Code ACTION ATTRIBUTE_CHANGED CHANGE_NO Type VARCHAR2(32) VARCHAR2(45) NUMBER(9) 2/21/02 P No No Yes M No No Yes Label VALID VALUES ADD/DELETE/CHANGE VALID VALUES NAME/ADDRESS/LINK NUMBER OF CHANGE THIS SESSION Page 90 Physical Data Model Name CORRECTION_FLG EFFECT_DT ENTITY_ADR1 ENTITY_ADR2 ENTITY_CITY ENTITY_ID ENTITY_NAME ENTITY_PHONE ENTITY_ST ENTITY_TYPE ENTITY_ZIP ETHICS_DT FILER_ADR1 FILER_ADR2 FILER_CITY FILER_FULL_NAME FILER_ID FILER_PHONE FILER_ST FILER_TYPE FILER_ZIP INTERESTS LOG_DT RESPONSIBLE_OFFICER SESSION_ID Model_1 Code CORRECTION_FLG EFFECT_DT ENTITY_ADR1 ENTITY_ADR2 ENTITY_CITY ENTITY_ID ENTITY_NAME ENTITY_PHONE ENTITY_ST ENTITY_TYPE ENTITY_ZIP ETHICS_DT FILER_ADR1 FILER_ADR2 FILER_CITY FILER_FULL_NAME FILER_ID FILER_PHONE FILER_ST FILER_TYPE FILER_ZIP INTERESTS LOG_DT RESPONSIBLE_OFFICER SESSION_ID Type VARCHAR2(1) DATE VARCHAR2(60) VARCHAR2(60) VARCHAR2(40) NUMBER(9) VARCHAR2(380) VARCHAR2(20) VARCHAR2(2) NUMBER(9) VARCHAR2(10) DATE VARCHAR2(60) VARCHAR2(60) VARCHAR2(40) VARCHAR2(380) NUMBER(9) VARCHAR2(20) VARCHAR2(2) NUMBER(9) VARCHAR2(10) VARCHAR2(45) DATE VARCHAR2(380) NUMBER(9) P No No No No No No No No No No No No No No No No Yes No No No No No No No No M No No No No No No No No No No No No No No No No Yes No No No No No No No No Label Index List Index Code IX_CHNGLOG_FILER_ID IX_CHNGLOG_SESSION_ID PK_LOBBYING_CHG_LOG P No No Yes F No No No A No No No U No No Yes C No No No Column Code FILER_ID SESSION_ID FILER_ID CHANGE_NO Sort ASC ASC ASC ASC TABLE: LOBBYIST_CONTRIBUTIONS1 Column List PowerDesigner 2/21/02 Page 91 Physical Data Model Model_1 Name Code Type AMOUNT AMOUNT NUMBER(12,2) CONTRIBUTION_DT CONTRIBUTION_DT DATE FILER_ID FILER_ID NUMBER(9) FILING_PERIOD_END_DT FILING_PERIOD_END_DT DATE FILING_PERIOD_START_ FILING_PERIOD_START_ DATE DT DT RECIPIENT_ID RECIPIENT_ID NUMBER(9) RECIPIENT_NAME RECIPIENT_NAME VARCHAR2(300) P No No No No No M No No No No No Label Amount Received Contribution date. Filer's unique identification number. Filing period end date. Filing period start date. No No No No Recipient's identification number. Recipient's name. Index List Index Code IX_LOBCONTRIB_AMT1 IX_LOBCONTRIB_CONTRIB_DT1 IX_LOBCONTRIB_FIL_PER_ST_DT1 IX_LOBCONTRIB_FILER_ID1 IX_LOBCONTRIB_RECIP_NAME1 P No No No No No F No No No No No A No No No No No U No No No No No C No No No No No Column Code AMOUNT CONTRIBUTION_DT FILING_PERIOD_START_DT FILER_ID RECIPIENT_NAME Sort ASC ASC ASC ASC ASC TABLE: LOBBYIST_CONTRIBUTIONS2 Column List Name Code Type AMOUNT AMOUNT NUMBER(12,2) CONTRIBUTION_DT CONTRIBUTION_DT DATE FILER_ID FILER_ID NUMBER(9) FILING_PERIOD_END_DT FILING_PERIOD_END_DT DATE FILING_PERIOD_START_ FILING_PERIOD_START_ DATE DT DT RECIPIENT_ID RECIPIENT_ID NUMBER(9) RECIPIENT_NAME RECIPIENT_NAME VARCHAR2(300) P No No No No No M No No No No No Label Amount Received Contribution date. Filer's unique identification number. Filing period end date. Filing period start date. No No No No Recipient's identification number. Recipient's name. Index List Index Code IX_LOBCONTRIB_AMT2 IX_LOBCONTRIB_CONTRIB_DT2 PowerDesigner P No No F No No A No No U No No C No No 2/21/02 Column Code AMOUNT CONTRIBUTION_DT Sort ASC ASC Page 92 Physical Data Model Model_1 Index Code IX_LOBCONTRIB_FIL_PER_ST_DT2 IX_LOBCONTRIB_FILER_ID2 IX_LOBCONTRIB_RECIP_NAME2 P No No No F No No No A No No No U No No No C No No No Column Code FILING_PERIOD_START_DT FILER_ID RECIPIENT_NAME Sort ASC ASC ASC TABLE: LOBBYIST_CONTRIBUTIONS3 Column List Name Code Type AMOUNT AMOUNT NUMBER(12,2) CONTRIBUTION_DT CONTRIBUTION_DT DATE FILER_ID FILER_ID NUMBER(9) FILING_PERIOD_END_DT FILING_PERIOD_END_DT DATE FILING_PERIOD_START_ FILING_PERIOD_START_ DATE DT DT RECIPIENT_ID RECIPIENT_ID NUMBER(9) RECIPIENT_NAME RECIPIENT_NAME VARCHAR2(300) P No No No No No M No No No No No Label Amount Received Contribution date. Filer's unique identification number. Filing period end date. Filing period start date. No No No No Recipient's identification number. Recipient's name. P No No No No No No M No No No No No No Label Employer identification number. Employer Name Lobbyist's first name. Lobbyist's filer identification number. Lobbyist's last name. Session identification number. TABLE: LOBBYIST_EMP_LOBBYIST1 Column List Name EMPLOYER_ID EMPLOYER_NAME LOBBYIST_FIRST_NAME LOBBYIST_ID LOBBYIST_LAST_NAME SESSION_ID Code EMPLOYER_ID EMPLOYER_NAME LOBBYIST_FIRST_NAME LOBBYIST_ID LOBBYIST_LAST_NAME SESSION_ID Type NUMBER(9) VARCHAR2(400) VARCHAR2(400) NUMBER(9) VARCHAR2(400) NUMBER(9) Index List Index Code IX_LEL_EMP_ID1 IX_LEL_LOBBYIST_FNAME1 IX_LEL_LOBBYIST_ID1 PowerDesigner P No No No F No No No A No No No U No No No C No No No 2/21/02 Column Code EMPLOYER_ID LOBBYIST_FIRST_NAME LOBBYIST_ID Sort ASC ASC ASC Page 93 Physical Data Model Model_1 Index Code IX_LEL_LOBBYIST_LNAME1 P No F No A No U No C No Column Code LOBBYIST_LAST_NAME Sort ASC TABLE: LOBBYIST_EMP_LOBBYIST2 Column List Name EMPLOYER_ID EMPLOYER_NAME LOBBYIST_FIRST_NAME LOBBYIST_ID LOBBYIST_LAST_NAME SESSION_ID Code EMPLOYER_ID EMPLOYER_NAME LOBBYIST_FIRST_NAME LOBBYIST_ID LOBBYIST_LAST_NAME SESSION_ID Type NUMBER(9) VARCHAR2(400) VARCHAR2(400) NUMBER(9) VARCHAR2(400) NUMBER(9) P No No No No No No M No No No No No No Label Employer identification number. Employer Name Lobbyist's first name. Lobbyist's filer identification number. Lobbyist's last name. Session identification number. Index List Index Code IX_LEL_EMP_ID2 IX_LEL_LOBBYIST_FNAME2 IX_LEL_LOBBYIST_ID2 IX_LEL_LOBBYIST_LNAME2 P No No No No F No No No No A No No No No U No No No No C No No No No Column Code EMPLOYER_ID LOBBYIST_FIRST_NAME LOBBYIST_ID LOBBYIST_LAST_NAME Sort ASC ASC ASC ASC TABLE: LOBBYIST_EMPLOYER_FIRMS1 Column List Name EMPLOYER_ID FIRM_ID FIRM_NAME SESSION_ID TERMINATION_DT Code EMPLOYER_ID FIRM_ID FIRM_NAME SESSION_ID TERMINATION_DT Type NUMBER(9) NUMBER(9) VARCHAR2(400) NUMBER(9) DATE P No No No No No M No No No No No Label Employer identification number. Identification number of the Firm/Employer/Coalition. Name of Firm/Employer/Coalition Session identification number. Termination Effective Date. Index List PowerDesigner 2/21/02 Page 94 Physical Data Model Model_1 IX_LEF_EMP_ID1 IX_LEF_FIRM_ID1 IX_LEF_FIRM_NAME1 IX_LEF_FIRM_SESSION_ID1 No No No No No No No No No No No No No No No No No No No No EMPLOYER_ID FIRM_ID FIRM_NAME SESSION_ID ASC ASC ASC ASC TABLE: LOBBYIST_EMPLOYER_FIRMS2 Column List Name EMPLOYER_ID FIRM_ID FIRM_NAME SESSION_ID TERMINATION_DT Code EMPLOYER_ID FIRM_ID FIRM_NAME SESSION_ID TERMINATION_DT Type NUMBER(9) NUMBER(9) VARCHAR2(400) NUMBER(9) DATE P No No No No No M No No No No No Label Employer identification number. Identification number of the Firm/Employer/Coalition. Name of Firm/Employer/Coalition Session identification number. Termination Effective Date Index List Index Code IX_LEF_EMP_ID2 IX_LEF_FIRM_ID2 IX_LEF_FIRM_NAME2 IX_LEF_FIRM_SESSION_ID2 P No No No No F No No No No A No No No No U No No No No C No No No No Column Code EMPLOYER_ID FIRM_ID FIRM_NAME SESSION_ID Sort ASC ASC ASC ASC TABLE: LOBBYIST_EMPLOYER_HISTORY Column List Name CONTRIBUTOR_ID CURRENT_QTR_AMT EMPLOYER_ID EMPLOYER_NAME INTEREST_CD INTEREST_NAME QTR_1 QTR_2 PowerDesigner Code CONTRIBUTOR_ID CURRENT_QTR_AMT EMPLOYER_ID EMPLOYER_NAME INTEREST_CD INTEREST_NAME QTR_1 QTR_2 Type NUMBER(9) NUMBER(12,2) NUMBER(9) VARCHAR2(300) NUMBER(9) VARCHAR2(300) NUMBER(12,2) NUMBER(12,2) 2/21/02 P No No No No No No No No M No No No No No No No No Label Contributor identification number. Current Quarter Amount Employer identification number. Employer Name Interest code. Interest name. Quarter total amount. Quarter total amount. Page 95 Physical Data Model Name QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT Model_1 Code QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT Type NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(9) NUMBER(12,2) NUMBER(9) NUMBER(9) NUMBER(12,2) NUMBER(12,2) P No No No No No No No No No No No No M No No No No No No No No No No No No Label Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Session identification number. Total amount for the session. Total amount for year 1 of the session. Total amount for year 2 of the session. Year 1 year to date amount. Year 2 year to date amount. Index List Index Code IX_LOBEMP_H_EMP_ID IX_LOBEMP_H_EMP_NAME IX_LOBEMP_H_SESSION_ID P No No No F No No No A No No No U No No No C No No No Column Code EMPLOYER_ID EMPLOYER_NAME SESSION_ID Sort ASC ASC ASC TABLE: LOBBYIST_EMPLOYER1 Column List Name CONTRIBUTOR_ID CURRENT_QTR_AMT EMPLOYER_ID EMPLOYER_NAME INTEREST_CD INTEREST_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 PowerDesigner Code CONTRIBUTOR_ID CURRENT_QTR_AMT EMPLOYER_ID EMPLOYER_NAME INTEREST_CD INTEREST_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 Type NUMBER(9) NUMBER(12,2) NUMBER(9) VARCHAR2(300) NUMBER(9) VARCHAR2(300) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) 2/21/02 P No No No No No No No No No No No No No M No No No No No No No No No No No No No Label Contributor identification number. Current Quarter Amount Employer identification number. Employer Name Interest code. Interest name. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Page 96 Physical Data Model Name QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT Model_1 Code QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT Type NUMBER(12,2) NUMBER(9) NUMBER(12,2) NUMBER(9) NUMBER(9) NUMBER(12,2) NUMBER(12,2) P No No No No No No No M No No No No No No No Label Quarter total amount. Session identification number. Total amount for the session. Total amount for year 1 of the session. Total amount for year 2 of the session. Year 1 year to date amount. Year 2 year to date amount. Index List Index Code IX_LOBEMP_EMP_ID1 IX_LOBEMP_EMP_NAME1 IX_LOBEMP_SESSION_ID1 P No No No F No No No A No No No U No No No C No No No Column Code EMPLOYER_ID EMPLOYER_NAME SESSION_ID Sort ASC ASC ASC TABLE: LOBBYIST_EMPLOYER2 Column List Name CONTRIBUTOR_ID CURRENT_QTR_AMT EMPLOYER_ID EMPLOYER_NAME INTEREST_CD INTEREST_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 PowerDesigner Code CONTRIBUTOR_ID CURRENT_QTR_AMT EMPLOYER_ID EMPLOYER_NAME INTEREST_CD INTEREST_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 Type NUMBER(9) NUMBER(12,2) NUMBER(9) VARCHAR2(300) NUMBER(9) VARCHAR2(300) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(9) NUMBER(12,2) NUMBER(9) NUMBER(9) 2/21/02 P No No No No No No No No No No No No No No No No No No M No No No No No No No No No No No No No No No No No No Label Contributor identification number. Current Quarter Amount Employer identification number. Employer Name Interest code. Interest name. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Session identification number. Total amount for the session. Total amount for year 1 of the session. Total amount for year 2 of the session. Page 97 Physical Data Model Name YR_1_YTD_AMT YR_2_YTD_AMT Model_1 Code YR_1_YTD_AMT YR_2_YTD_AMT Type NUMBER(12,2) NUMBER(12,2) P No No M No No Label Year 1 year to date amount. Year 2 year to date amount. Index List Index Code IX_LOBEMP_EMP_ID2 IX_LOBEMP_EMP_NAME2 IX_LOBEMP_SESSION_ID2 P No No No F No No No A No No No U No No No C No No No Column Code EMPLOYER_ID EMPLOYER_NAME SESSION_ID Sort ASC ASC ASC TABLE: LOBBYIST_EMPLOYER3 Column List Name CONTRIBUTOR_ID CURRENT_QTR_AMT EMPLOYER_ID EMPLOYER_NAME INTEREST_CD INTEREST_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT PowerDesigner Code CONTRIBUTOR_ID CURRENT_QTR_AMT EMPLOYER_ID EMPLOYER_NAME INTEREST_CD INTEREST_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT Type NUMBER(9) NUMBER(12,2) NUMBER(9) VARCHAR2(300) NUMBER(9) VARCHAR2(300) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(9) NUMBER(12,2) NUMBER(9) NUMBER(9) NUMBER(12,2) NUMBER(12,2) 2/21/02 P No No No No No No No No No No No No No No No No No No No No M No No No No No No No No No No No No No No No No No No No No Label Contributor identification number. Current Quarter Amount Employer identification number. Employer Name Interest code. Interest name. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Session identification number. Total amount for the session. Total amount for year 1 of the session. Total amount for year 2 of the session. Year 1 year to date amount. Year 2 year to date amount. Page 98 Physical Data Model Model_1 TABLE: LOBBYIST_FIRM_EMPLOYER1 Column List Name CUM_TOTAL EMPLOYER_NAME EXT_LBY_ACTVTY FILING_ID FILING_SEQUENCE Code CUM_TOTAL EMPLOYER_NAME EXT_LBY_ACTVTY FILING_ID FILING_SEQUENCE Type NUMBER(12,2) VARCHAR2(200) VARCHAR2(4000) NUMBER(9) NUMBER(9) P No No No No No M No No No No No FIRM_ID FIRM_NAME LBY_ACTVTY PER_TOTAL RPT_END RPT_START FIRM_ID FIRM_NAME LBY_ACTVTY PER_TOTAL RPT_END RPT_START NUMBER(9) VARCHAR2(400) VARCHAR2(200) NUMBER(12,2) DATE DATE No No No No No No No No No No No No Label Cumulative total to date. Employer Name EXT_LBY_ACTVTY Unique filing identification number. Amendment number where 0 is an original filing and 1 to 999 are amendments. Identification number of the Firm/Employer/Coalition. Name of Firm/Employer/Coalition Description of lobbying activity. Total this reporting period Ending date for the period the filing represents. Starting date for the period the filing represents. Index List Index Code IX_LFE_EMP_NAME1 IX_LFE_FIRM_ID1 IX_LFE_FIRM_NAME1 P No No No F No No No A No No No U No No No C No No No Column Code EMPLOYER_NAME FIRM_ID FIRM_NAME Sort ASC ASC ASC TABLE: LOBBYIST_FIRM_EMPLOYER2 Column List Name CUM_TOTAL EMPLOYER_NAME EXT_LBY_ACTVTY FILING_ID FILING_SEQUENCE Code CUM_TOTAL EMPLOYER_NAME EXT_LBY_ACTVTY FILING_ID FILING_SEQUENCE Type NUMBER(12,2) VARCHAR2(200) VARCHAR2(4000) NUMBER(9) NUMBER(9) P No No No No No M No No No No No FIRM_ID FIRM_ID NUMBER(9) No No PowerDesigner 2/21/02 Label Cumulative total to date. Employer Name EXT_LBY_ACTVTY Unique filing identification number. Amendment number where 0 is an original filing and 1 to 999 are amendments. Identification number of the Firm/Employer/Coalition. Page 99 Physical Data Model Name FIRM_NAME LBY_ACTVTY PER_TOTAL RPT_END RPT_START Model_1 Code FIRM_NAME LBY_ACTVTY PER_TOTAL RPT_END RPT_START Type VARCHAR2(400) VARCHAR2(200) NUMBER(12,2) DATE DATE P No No No No No M No No No No No Label Name of Firm/Employer/Coalition Description of lobbying activity. Total this reporting period Ending date for the period the filing represents. Starting date for the period the filing represents. Index List Index Code IX_LFE_EMP_NAME2 IX_LFE_FIRM_ID2 IX_LFE_FIRM_NAME2 P No No No F No No No A No No No U No No No C No No No Column Code EMPLOYER_NAME FIRM_ID FIRM_NAME Sort ASC ASC ASC TABLE: LOBBYIST_FIRM_HISTORY Column List Name CONTRIBUTOR_ID CURRENT_QTR_AMT FIRM_ID FIRM_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT PowerDesigner Code CONTRIBUTOR_ID CURRENT_QTR_AMT FIRM_ID FIRM_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT Type NUMBER(9) NUMBER(12,2) NUMBER(9) VARCHAR2(300) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(9) NUMBER(12,2) NUMBER(9) NUMBER(9) NUMBER(12,2) NUMBER(12,2) 2/21/02 P No No No No No No No No No No No No No No No No No No M No No No No No No No No No No No No No No No No No No Label Contributor identification number. Current Quarter Amount Identification number of the Firm/Employer/Coalition. Name of Firm/Employer/Coalition Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Session identification number. Total amount for the session. Total amount for year 1 of the session. Total amount for year 2 of the session. YR_1_YTD_AMT Year 2 year to date amount. Page 100 Physical Data Model Model_1 Index List Index Code IX_LOBFIRM_H_FIRM_ID IX_LOBFIRM_H_FIRM_NAME IX_LOBFIRM_H_SESSION_ID P No No No F No No No A No No No U No No No C No No No Column Code FIRM_ID FIRM_NAME SESSION_ID Sort ASC ASC ASC TABLE: LOBBYIST_FIRM_LOBBYIST1 Column List Name FIRM_ID FIRM_NAME LOBBYIST_FIRST_NAME LOBBYIST_ID LOBBYIST_LAST_NAME SESSION_ID Code FIRM_ID FIRM_NAME LOBBYIST_FIRST_NAME LOBBYIST_ID LOBBYIST_LAST_NAME SESSION_ID Type NUMBER(9) VARCHAR2(400) VARCHAR2(400) NUMBER(9) VARCHAR2(400) NUMBER(9) P No No No No No No M No No No No No No Label Identification number of the Firm/Employer/Coalition. Name of Firm/Employer/Coalition Lobbyist's first name. Lobbyist's filer identification number. Lobbyist's last name. Session identification number. Index List Index Code IX_LFL_FIRM_ID1 IX_LFL_FIRM_NAME1 IX_LFL_LOB_FNAME1 IX_LFL_LOB_ID1 IX_LFL_LOB_LNAME1 IX_LFL_SESSION_ID1 P No No No No No No F No No No No No No A No No No No No No U No No No No No No C No No No No No No Column Code FIRM_ID FIRM_NAME LOBBYIST_FIRST_NAME LOBBYIST_ID LOBBYIST_LAST_NAME SESSION_ID Sort ASC ASC ASC ASC ASC ASC TABLE: LOBBYIST_FIRM_LOBBYIST2 Column List Name Code Type FIRM_ID FIRM_ID NUMBER(9) FIRM_NAME FIRM_NAME VARCHAR2(400) LOBBYIST_FIRST_NAME LOBBYIST_FIRST_NAME VARCHAR2(400) PowerDesigner 2/21/02 P No No No M No No No Label Identification number of the Firm/Employer/Coalition. Name of Firm/Employer/Coalition Lobbyist's first name. Page 101 Physical Data Model Model_1 Name Code LOBBYIST_ID LOBBYIST_ID LOBBYIST_LAST_NAME LOBBYIST_LAST_NAME SESSION_ID SESSION_ID Type NUMBER(9) VARCHAR2(400) NUMBER(9) P No No No M No No No Label Lobbyist's filer identification number. Lobbyist's last name. Session identification number. Index List Index Code IX_LFL_FIRM_ID2 IX_LFL_FIRM_NAME2 IX_LFL_LOB_FNAME2 IX_LFL_LOB_ID2 IX_LFL_LOB_LNAME2 IX_LFL_SESSION_ID2 P No No No No No No F No No No No No No A No No No No No No U No No No No No No C No No No No No No Column Code FIRM_ID FIRM_NAME LOBBYIST_FIRST_NAME LOBBYIST_ID LOBBYIST_LAST_NAME SESSION_ID Sort ASC ASC ASC ASC ASC ASC TABLE: LOBBYIST_FIRM1 Column List Name CONTRIBUTOR_ID CURRENT_QTR_AMT FIRM_ID FIRM_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT PowerDesigner Code CONTRIBUTOR_ID CURRENT_QTR_AMT FIRM_ID FIRM_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT Type NUMBER(9) NUMBER(12,2) NUMBER(9) VARCHAR2(300) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(9) NUMBER(12,2) NUMBER(9) NUMBER(9) NUMBER(12,2) NUMBER(12,2) 2/21/02 P No No No No No No No No No No No No No No No No No No M No No No No No No No No No No No No No No No No No No Label Contributor identification number. Current Quarter Amount Identification number of the Firm/Employer/Coalition. Name of Firm/Employer/Coalition Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Session identification number. Total amount for the session. Total amount for year 1 of the session. Total amount for year 2 of the session. Year 1 year to date amount. Year 2 year to date amount. Page 102 Physical Data Model Model_1 Index List Index Code IX_LOBFIRM_FIRM_ID1 IX_LOBFIRM_FIRM_NAME1 IX_LOBFIRM_SESSION_ID1 P No No No F No No No A No No No U No No No C No No No Column Code FIRM_ID FIRM_NAME SESSION_ID Sort ASC ASC ASC TABLE: LOBBYIST_FIRM2 Column List Name CONTRIBUTOR_ID CURRENT_QTR_AMT FIRM_ID FIRM_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT Code CONTRIBUTOR_ID CURRENT_QTR_AMT FIRM_ID FIRM_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT Type NUMBER(9) NUMBER(12,2) NUMBER(9) VARCHAR2(300) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(9) NUMBER(12,2) NUMBER(9) NUMBER(9) NUMBER(12,2) NUMBER(12,2) P No No No No No No No No No No No No No No No No No No M No No No No No No No No No No No No No No No No No No Label Contributor identification number. Current Quarter Amount Identification number of the Firm/Employer/Coalition. Name of Firm/Employer/Coalition Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Session identification number. Total amount for the session. Total amount for year 1 of the session. Total amount for year 2 of the session. Year 1 year to date amount. Year 2 year to date amount. Index List Index Code IX_LOBFIRM_FIRM_ID2 IX_LOBFIRM_FIRM_NAME2 IX_LOBFIRM_SESSION_ID2 PowerDesigner P No No No F No No No A No No No U No No No C No No No 2/21/02 Column Code FIRM_ID FIRM_NAME SESSION_ID Sort ASC ASC ASC Page 103 Physical Data Model Model_1 TABLE: LOBBYIST_FIRM3 Column List Name CONTRIBUTOR_ID CURRENT_QTR_AMT FIRM_ID FIRM_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT Code CONTRIBUTOR_ID CURRENT_QTR_AMT FIRM_ID FIRM_NAME QTR_1 QTR_2 QTR_3 QTR_4 QTR_5 QTR_6 QTR_7 QTR_8 SESSION_ID SESSION_TOTAL_AMT SESSION_YR_1 SESSION_YR_2 YR_1_YTD_AMT YR_2_YTD_AMT Type NUMBER(9) NUMBER(12,2) NUMBER(9) VARCHAR2(300) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) NUMBER(9) NUMBER(12,2) NUMBER(9) NUMBER(9) NUMBER(12,2) NUMBER(12,2) P No No No No No No No No No No No No No No No No No No M No No No No No No No No No No No No No No No No No No Label Contributor identification number. Current Quarter Amount Identification number of the Firm/Employer/Coalition. Name of Firm/Employer/Coalition Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Quarter total amount. Session identification number. Total amount for the session. Total amount for year 1 of the session. Total amount for year 2 of the session. Year 1 year to date amount. Year 2 year to date amount. Type NUMBER(9) P Yes M Yes VARCHAR2(128) VARCHAR2(128) VARCHAR2(3) VARCHAR2(7) NUMBER(9) VARCHAR2(4) DATE No No No No Yes Yes No No No No No Yes Yes No Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. County of domicile. County with voters Entity code of the filer. Filer's unique identification number. Unique filing identification number. Type of Filing or Formset Period ending date TABLE: LOCAL_FORMS Column List Name AMEND_ID Code AMEND_ID COUNTY_OF_DOMICILE COUNTY_OF_DOMICILE COUNTY_WITH_VOTERS COUNTY_WITH_VOTERS ENTITY_CD ENTITY_CD FILER_ID FILER_ID FILING_ID FILING_ID FORM_TYPE FORM_TYPE PERIOD_END PERIOD_END PowerDesigner 2/21/02 Page 104 Physical Data Model Name PERIOD_START PURGE_DATE REC_TYPE RECIEVE_DATE RPT_TYPE SESSION_ID Model_1 Code PERIOD_START PURGE_DATE REC_TYPE RECIEVE_DATE RPT_TYPE SESSION_ID Type DATE DATE VARCHAR2(3) DATE NUMBER(9) NUMBER(9) P No No Yes No No No M No No Yes No No No Label Period starting date. Date filing should be purged. Record Type. Date recieved. Type of report. Session identification number. Index List Index Code PK_LOCAL_FORMS P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC TABLE: LOOKUP_CODES Column List Name CODE_DESC CODE_ID CODE_TYPE Code CODE_DESC CODE_ID CODE_TYPE Type VARCHAR2(255) NUMBER(9) NUMBER(9) P No Yes Yes M Yes Yes Yes Label Code Description Code's identification number. Code Type Index List Index Code IX_LC_CODE_ID IX_LC_CODE_TYPE PK_LOOKUP_CODES P No No Yes F No No No A No No No U No No Yes C No No No Column Code CODE_ID CODE_TYPE CODE_ID CODE_TYPE Sort ASC ASC ASC ASC TABLE: LOTH Column List PowerDesigner 2/21/02 Page 105 Physical Data Model Model_1 Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes AMOUNT CUM_AMT FILING_ID FIRM_ADR1 AMOUNT CUM_AMT FILING_ID FIRM_ADR1 NUMBER(12,2) NUMBER(12,2) NUMBER(9) VARCHAR2(55) No No Yes No No No Yes No FIRM_ADR2 FIRM_ADR2 VARCHAR2(55) No No FIRM_CITY FIRM_NAME FIRM_PHON FIRM_ST FIRM_ZIP4 FORM_TYPE LINE_ITEM MEMO_CODE MEMO_REFNO PMT_DATE REC_TYPE SUBJ_NAMF SUBJ_NAML SUBJ_NAMS SUBJ_NAMT TRAN_ID FIRM_CITY FIRM_NAME FIRM_PHON FIRM_ST FIRM_ZIP4 FORM_TYPE LINE_ITEM MEMO_CODE MEMO_REFNO PMT_DATE REC_TYPE SUBJ_NAMF SUBJ_NAML SUBJ_NAMS SUBJ_NAMT TRAN_ID VARCHAR2(30) VARCHAR2(200) VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) VARCHAR2(7) NUMBER(9) VARCHAR2(1) VARCHAR2(20) DATE VARCHAR2(4) VARCHAR2(45) VARCHAR2(200) VARCHAR2(45) VARCHAR2(45) VARCHAR2(20) No No No No No Yes Yes No No No Yes No No No No No No No No No No Yes Yes No No No Yes No No No No No Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Amount of payment Cumulative total to date Unique filing identification number. First line of the Firm/Employer/Coalition or business's address. Second line of the Firm/Employer/Coalition or business's address. Firm/Employer/Coalition or business City Name of Firm/Employer/Coalition Firm, employer, coalition or business phone number. Firm/Employer/Coalition State Firm/Employer/Coalition ZIP+4 Schedule Name/ID: F625P3B Record line item number. Memo amount flag Reference to text contained in a TEXT record Date of payment Record Type Value: LOTH First Name of employer/client subject of lobbying Last Name of employer/client subject of lobbying Suffix of employer/client subject of lobbying Prefix/Title of employer/client subject of lobbying Transaction identifier - permanent value unique to this item. Index List Index Code PK_LOTH P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: LPAY PowerDesigner 2/21/02 Page 106 Physical Data Model Model_1 Column List Name ADVAN_AMT ADVAN_DSCR AMEND_ID Code ADVAN_AMT ADVAN_DSCR AMEND_ID Type NUMBER(12,2) VARCHAR2(100) NUMBER(9) P No No Yes M No No Yes BAKREF_TID BAKREF_TID VARCHAR2(20) No No CUM_TOTAL EMPLR_ADR1 EMPLR_ADR2 EMPLR_CITY EMPLR_ID EMPLR_NAMF EMPLR_NAML EMPLR_NAMS EMPLR_NAMT EMPLR_PHON EMPLR_ST EMPLR_ZIP4 ENTITY_CD FEES_AMT FILING_ID FORM_TYPE LBY_ACTVTY LINE_ITEM MEMO_CODE MEMO_REFNO PER_TOTAL REC_TYPE REIMB_AMT TRAN_ID CUM_TOTAL EMPLR_ADR1 EMPLR_ADR2 EMPLR_CITY EMPLR_ID EMPLR_NAMF EMPLR_NAML EMPLR_NAMS EMPLR_NAMT EMPLR_PHON EMPLR_ST EMPLR_ZIP4 ENTITY_CD FEES_AMT FILING_ID FORM_TYPE LBY_ACTVTY LINE_ITEM MEMO_CODE MEMO_REFNO PER_TOTAL REC_TYPE REIMB_AMT TRAN_ID NUMBER(12,2) VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(9) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(20) VARCHAR2(2) VARCHAR2(10) VARCHAR2(3) NUMBER(12,2) NUMBER(9) VARCHAR2(7) VARCHAR2(200) NUMBER(9) VARCHAR2(1) VARCHAR2(20) NUMBER(12,2) VARCHAR2(4) NUMBER(12,2) VARCHAR2(20) No No No No No No No No No No No No No No Yes Yes No Yes No No No Yes No No No No No No No No No No No No No No No No Yes Yes No Yes No No No Yes No No Label Advance and other payments amount Description of advance and other payments Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Back Reference to a transaction identifier of a parent record. Cumulative total to date. Employer street 1 Employer Street 2 Employer city Employer first name Name of firm, employer, coalition Employer suffix Employer prefix or title Employer phone Employer state Employer zipcode. Entity code Fees and retainers amount Unique filing identification number. Schedule Name/ID: [F625P2 F635P3B] Description of lobbying activity. Record line item number. Memo amount flag Reference to text contained in a TEXT record Total this reporting period Record Type Value: LPAY Reimbursements of expense amount Transaction identifier - permanent value unique to this item. Index List Index Code IX_LP_AMEND_ID IX_LP_EMPLR_ID PowerDesigner P No No F No No A No No U No No C No No 2/21/02 Column Code AMEND_ID EMPLR_ID Sort ASC ASC Page 107 Physical Data Model Model_1 Index Code IX_LP_FILING_ID IX_LPAY_FORM_TYPE IX_LPAY_REC_TYPE PK_LPAY P No No No Yes F Yes No No No A No No No No U No No No Yes C No No No No Column Code FILING_ID FORM_TYPE REC_TYPE FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC ASC ASC ASC TABLE: MESSAGES Column List Name MSGBUTTON MSGDEFAULTBUTTON MSGICON MSGID MSGPRINT MSGSEVERITY MSGTEXT MSGTITLE MSGUSERINPUT Code MSGBUTTON MSGDEFAULTBUTTON MSGICON MSGID MSGPRINT MSGSEVERITY MSGTEXT MSGTITLE MSGUSERINPUT Type VARCHAR2(17) FLOAT VARCHAR2(12) VARCHAR2(40) VARCHAR2(1) FLOAT VARCHAR2(255) VARCHAR2(255) VARCHAR2(1) P No No No Yes No No No No No M No No No Yes No No No No No Label Message Button Message Default Button Message Icon (stop, ok, question, et al) Unique mesage identifier. Message prints (y/n) Message Severity Message Text Message Title Message allows user input (y/n) Index List Index Code P Yes PK_MESSAGES F No A No U Yes C No Column Code MSGID Sort ASC TABLE: MV_SMRY_F635 Column List Name AMOUNT FILER_ID PowerDesigner Code AMOUNT FILER_ID Type NUMBER NUMBER(9) P No No 2/21/02 M No Yes Label Page 108 Physical Data Model Name FILING_ID FILING_SEQUENCE INTEREST_CODE RPT_END RPT_START SESSION_ID XREF_ID Model_1 Code FILING_ID FILING_SEQUENCE INTEREST_CODE RPT_END RPT_START SESSION_ID XREF_ID Type NUMBER(9) NUMBER(9) NUMBER DATE DATE NUMBER(9) VARCHAR2(4000) P No No No No No No No M Yes Yes No No No No No Label Index List Index Code IX_MVSF635_FILER_ID IX_MVSF635_FILING_ID IX_MVSF635_FILING_SEQUENCE IX_MVSF635_INTEREST_CODE IX_MVSF635_RPT_END IX_MVSF635_RPT_START IX_MVSF635_SESSION_ID P No No No No No No No F No No No No No No No A No No No No No No No U No No No No No No No C No No No No No No No Column Code FILER_ID FILING_ID FILING_SEQUENCE INTEREST_CODE RPT_END RPT_START SESSION_ID Sort ASC ASC ASC ASC ASC ASC ASC TABLE: MVIEW_DUMMY1 Column List Name FILER_ID FILER_NAME FILER_TYPE LETTER Code FILER_ID FILER_NAME FILER_TYPE LETTER Type NUMBER VARCHAR2(252) NUMBER VARCHAR2(1) P No No No No M No No No No Label Type NUMBER VARCHAR2(252) P No No M No No Label TABLE: MVIEW_DUMMY2 Column List Name FILER_ID FILER_NAME PowerDesigner Code FILER_ID FILER_NAME 2/21/02 Page 109 Physical Data Model Name FILER_TYPE LETTER Model_1 Code FILER_TYPE LETTER Type NUMBER VARCHAR2(1) P No No M No No Label P No No No No M No No No No Label TABLE: MVIEW_ELECTRONIC_FILERS Column List Name FILER_ID FILER_NAME FILER_TYPE LETTER Code FILER_ID FILER_NAME FILER_TYPE LETTER Type NUMBER VARCHAR2(252) NUMBER VARCHAR2(1) Index List Index Code IX_MVIEW_ELECT_FILERS_FT IX_MVIEW_ELECT_FILERS_LETTER P No No F No No A No No U No No C No No Column Code FILER_TYPE LETTER Sort ASC ASC TABLE: MVIEW_LOBBYIST_CONTRIB Column List Name AMEND_ID AMOUNT FILER_ID FILING_ID RPT_END RPT_START SESSION_ID Code AMEND_ID AMOUNT FILER_ID FILING_ID RPT_END RPT_START SESSION_ID Type NUMBER(9) NUMBER NUMBER(9) NUMBER(9) DATE DATE NUMBER(9) P No No No No No No No M Yes No Yes Yes No No No Label Index List Index Code PowerDesigner P F A U 2/21/02 C Column Code Sort Page 110 Physical Data Model Model_1 Index Code IX_MVLBYCTRB_AMEND_ID IX_MVLBYCTRB_AMOUNT IX_MVLBYCTRB_FILER_ID IX_MVLBYCTRB_FILING_ID IX_MVLBYCTRB_RPT_END IX_MVLBYCTRB_RPT_START IX_MVLBYCTRB_SESSION_ID P No No No No No No No F No No No No No No No A No No No No No No No U No No No No No No No C No No No No No No No Column Code AMEND_ID AMOUNT FILER_ID FILING_ID RPT_END RPT_START SESSION_ID Sort ASC ASC ASC ASC ASC ASC ASC TABLE: NAMES Column List Name FULLNAME MONIKER MONIKER_POS NAMF NAMID Code FULLNAME MONIKER MONIKER_POS NAMF NAMID Type VARCHAR2(200) VARCHAR2(30) NUMBER(9) VARCHAR2(50) NUMBER(9) P No No No No Yes M No No No No Yes NAML NAML_SEARCH NAMM NAMS NAMT NAML NAML_SEARCH NAMM NAMS NAMT VARCHAR2(200) VARCHAR2(200) VARCHAR2(30) VARCHAR2(30) VARCHAR2(100) No No No No No No No No No No Label Full Name Entities moniker. Location of the entitie's moniker. NAMF Name identification number that uniquely identifies the name in the NAMES table. Last name Last name Middle name. Name suffex. Name prefix or title. Index List Index Code IX_NAML_NAME IX_NAML_SEARCH PK_NAMES P No No Yes F No No No A No No No U No No Yes C No No No Column Code NAML NAML_SEARCH NAMID Sort ASC ASC ASC TABLE: PLAN_TABLE Column List PowerDesigner 2/21/02 Page 111 Physical Data Model Name BYTES CARDINALITY COST DISTRIBUTION ID OBJECT_INSTANCE OBJECT_NAME OBJECT_NODE OBJECT_OWNER OBJECT_TYPE OPERATION OPTIMIZER OPTIONS OTHER OTHER_TAG PARENT_ID PARTITION_ID PARTITION_START PARTITION_STOP POSITION REMARKS SEARCH_COLUMNS STATEMENT_ID TIMESTAMP Model_1 Code BYTES CARDINALITY COST DISTRIBUTION ID OBJECT_INSTANCE OBJECT_NAME OBJECT_NODE OBJECT_OWNER OBJECT_TYPE OPERATION OPTIMIZER OPTIONS OTHER OTHER_TAG PARENT_ID PARTITION_ID PARTITION_START PARTITION_STOP POSITION REMARKS SEARCH_COLUMNS STATEMENT_ID TIMESTAMP Type NUMBER NUMBER NUMBER VARCHAR2(30) NUMBER NUMBER VARCHAR2(30) VARCHAR2(128) VARCHAR2(30) VARCHAR2(30) VARCHAR2(30) VARCHAR2(255) VARCHAR2(30) LONG VARCHAR2(255) NUMBER NUMBER VARCHAR2(255) VARCHAR2(255) NUMBER VARCHAR2(80) NUMBER VARCHAR2(30) DATE P No No No No No No No No No No No No No No No No No No No No No No No No M No No No No No No No No No No No No No No No No No No No No No No No No Label Type VARCHAR2(15) NUMBER(9) NUMBER(9) NUMBER(9) VARCHAR2(200) VARCHAR2(2000) VARCHAR2(2000) NUMBER(9) P No No No No No No No No M No No No No No No No No Label TABLE: PRD_DATA_AUDIT Column List Name ACTION AUDIT_COUNT FILER_ID FILER_TYPE NAML NEW_STR_VALUE OLD_STR_VALUE SESSION_ID PowerDesigner Code ACTION AUDIT_COUNT FILER_ID FILER_TYPE NAML NEW_STR_VALUE OLD_STR_VALUE SESSION_ID 2/21/02 Page 112 Physical Data Model Name TABLENAME TIMESTAMP USER_ID Model_1 Code TABLENAME TIMESTAMP USER_ID Type VARCHAR2(32) DATE VARCHAR2(12) P No No No M No No No Label Index List Index Code IX_PDA_FILER_ID IX_PDA_IX_PDA_TIMESTAMP IX_PDA_NAML IX_PDA_SESSION_ID IX_PDA_TABLENAME IX_PDA_USER_ID P No No No No No No F No No No No No No A No No No No No No U No No No No No No C No No No No No No Column Code FILER_ID TIMESTAMP NAML SESSION_ID TABLENAME USER_ID Sort ASC ASC ASC ASC ASC ASC TABLE: PRD_FINE_DETAIL Column List Name FINE_ID ITEM_TYPE LINE_ITEM TRAN_ID TYPE_AMT TYPE_DATE Code FINE_ID ITEM_TYPE LINE_ITEM TRAN_ID TYPE_AMT TYPE_DATE Type NUMBER(9) VARCHAR2(9) NUMBER(9) NUMBER(9) NUMBER(12,2) DATE P No No No No No No M Yes No Yes No No No Label Fine Identification number. Type of item. Record line item number. Transaction Identification number Amount Date Type NUMBER(9) NUMBER(12,2) DATE NUMBER(9) NUMBER(9) P No No No No No M No No No Yes No Label Account Identification number. Amount Due Date of Entry Filer's unique identification number. Unique filing identification number TABLE: PRD_FINES Column List Name ACCT_ID AMT_DUE DATE_OF_ENTRY FILER_ID FILING_ID PowerDesigner Code ACCT_ID AMT_DUE DATE_OF_ENTRY FILER_ID FILING_ID 2/21/02 Page 113 Physical Data Model Name FINE_ID FORM_ID PERIOD_COVERED_FRO M PERIOD_COVERED_TO RECEIVED_DATE USER_ID Model_1 Code FINE_ID FORM_ID PERIOD_COVERED_FRO M PERIOD_COVERED_TO RECEIVED_DATE USER_ID Type NUMBER(9) VARCHAR2(4) DATE P No No No M Yes No No Label Fine identification number. Form Identification code Period covered from date. DATE DATE VARCHAR2(12) No No No No No No Period covered to date. Date recieved. User Identifier of the user processing the fine. Type NUMBER(9) NUMBER(12,2) DATE NUMBER(9) P Yes No No Yes M Yes No No Yes Label Account Id LIMIT_AMT LIMIT_DUE_DATE Record line item number. TABLE: PRD_LIMITS Column List Name ACCT_ID LIMIT_AMT LIMIT_DUE_DATE LINE_ITEM Code ACCT_ID LIMIT_AMT LIMIT_DUE_DATE LINE_ITEM Index List Index Code PK_PRD_LIMITS P Yes F No A No U Yes C No Column Code ACCT_ID LINE_ITEM Sort ASC ASC TABLE: PRD_USER Column List Name DESK_PHONE FIRST_NAME LAST_NAME PROXY_NAME PROXY_PASS USER_ID USER_PASS PowerDesigner Code DESK_PHONE FIRST_NAME LAST_NAME PROXY_NAME PROXY_PASS USER_ID USER_PASS Type VARCHAR2(20) VARCHAR2(16) VARCHAR2(32) VARCHAR2(12) VARCHAR2(12) VARCHAR2(12) VARCHAR2(12) 2/21/02 P No No No No No Yes No M No No No No No Yes No Label User's desk phone number. User's first name User's last name. User's proxy name User's proxy password. Unique User Identifier. User's password. Page 114 Physical Data Model Model_1 Index List Index Code P Yes PK_PRD_USER F No A No U Yes C No Column Code USER_ID Sort ASC TABLE: PRD_USER_ASSIGNMENTS Column List Name ASS_DT COMP_DT FILING_ID STATUS USER_ID Code Type DATE DATE NUMBER(9) VARCHAR2(1) VARCHAR2(12) ASS_DT COMP_DT FILING_ID STATUS USER_ID P No No Yes No Yes M No No Yes No Yes Label Assigned Date Completion date Unique filing identification number. Status of the assigned work. User Identifier Index List Index Code PK_PRD_USER_ASSIGNMENTS P Yes F No A No U Yes C No Column Code USER_ID FILING_ID Sort ASC ASC TABLE: PRD_USER_CORRESPONDENCE Column List Name COR_ID USER_ID Code Type NUMBER(9) VARCHAR2(12) COR_ID USER_ID P Yes Yes M Yes Yes Label Correspondence identification number. User Identifier. Index List Index Code PK_PRD_USER_CORRESPONDENCE PowerDesigner P Yes F No A No U Yes C No 2/21/02 Column Code COR_ID USER_ID Sort ASC ASC Page 115 Physical Data Model Model_1 TABLE: PRD_USER_PREFERENCE Column List Name PREF_NAME PREF_VALUE USER_ID Code PREF_NAME PREF_VALUE USER_ID Type VARCHAR2(32) VARCHAR2(32) VARCHAR2(12) P Yes No Yes M Yes No Yes Label Preference name. Preference value. User Identifier. Index List Index Code PK_PRD_USER_PREFERENCE P Yes F No A No U Yes C No Column Code USER_ID PREF_NAME Sort ASC ASC TABLE: PRD_USER_SECURITY_USERS Column List Name NAME USER_ID Code Type VARCHAR2(16) VARCHAR2(12) NAME USER_ID P Yes Yes M Yes Yes Label NAME User Identifier. Index List Index Code PK_PRD_USER_SECURITY_USERS P Yes F No A No U Yes C No Column Code USER_ID NAME Sort ASC ASC TABLE: PRD_USER_WORK_ROLES Column List Name USER_ID PowerDesigner Code USER_ID Type VARCHAR2(12) 2/21/02 P Yes M Yes Label User Identifier Page 116 Physical Data Model Model_1 Name WK_ID Code Type NUMBER(9) WK_ID P Yes M Yes Label Work role identification number. Index List Index Code PK_PRD_USER_WORK_ROLES P Yes F No A No U Yes C No Column Code USER_ID WK_ID Sort ASC ASC TABLE: PRD_WAIVERS Column List Name Code Type FINE_ID FINE_ID NUMBER(9) REVISED_AMT REVISED_AMT NUMBER(12,2) WAIVER_GOOD_CAUSE_ WAIVER_GOOD_CAUSE_ VARCHAR2(2) CD CD WAIVER_IND WAIVER_IND VARCHAR2(1) WAIVER_IND_DATE WAIVER_IND_DATE DATE WAIVER_NUMBER WAIVER_NUMBER NUMBER(9) WAIVER_SEND_DATE WAIVER_SEND_DATE DATE P No No No M Yes No No Label Fine identification number. REVISED_AMT Waiver good cause code. No No No No No No Yes No WAIVER_IND WAIVER_IND_DATE Unique waiver number. WAIVER_SEND_DATE Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Amount Received (Monetary, Inkkind, Promise) Back Reference to a transaction identifier of a parent record. Jurisdiction of ballot measure. Used on the Form 401 Schedule A. Ballot measure name. Used on the Form 401 Schedule A. TABLE: RCPT Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes AMOUNT BAKREF_TID AMOUNT BAKREF_TID NUMBER(12,2) VARCHAR2(20) No No No No BAL_JURIS BAL_JURIS VARCHAR2(40) No No BAL_NAME BAL_NAME VARCHAR2(200) No No PowerDesigner 2/21/02 Page 117 Physical Data Model Model_1 BAL_NUM Name BAL_NUM Type VARCHAR2(7) P No M No CAND_NAMF CAND_NAMF VARCHAR2(45) No No CAND_NAML CAND_NAML VARCHAR2(200) No No CAND_NAMS CAND_NAMS VARCHAR2(10) No No CAND_NAMT CAND_NAMT VARCHAR2(10) No No CMTE_ID CTRIB_ADR1 CTRIB_ADR2 CTRIB_CITY CTRIB_DSCR CTRIB_EMP CTRIB_NAMF CTRIB_NAML CTRIB_NAMS CTRIB_NAMT CTRIB_OCC CTRIB_SELF CTRIB_ST CTRIB_ZIP4 CUM_OTH CUM_YTD CMTE_ID CTRIB_ADR1 CTRIB_ADR2 CTRIB_CITY CTRIB_DSCR CTRIB_EMP CTRIB_NAMF CTRIB_NAML CTRIB_NAMS CTRIB_NAMT CTRIB_OCC CTRIB_SELF CTRIB_ST CTRIB_ZIP4 CUM_OTH CUM_YTD VARCHAR2(9) VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(90) VARCHAR2(200) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(60) VARCHAR2(1) VARCHAR2(2) VARCHAR2(10) NUMBER(12,2) NUMBER(12,2) No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No DATE_THRU DIST_NO ENTITY_CD FILING_ID FORM_TYPE INT_RATE INTR_ADR1 INTR_ADR2 INTR_CITY INTR_CMTEID INTR_EMP INTR_NAMF INTR_NAML DATE_THRU DIST_NO ENTITY_CD FILING_ID FORM_TYPE INT_RATE INTR_ADR1 INTR_ADR2 INTR_CITY INTR_CMTEID INTR_EMP INTR_NAMF INTR_NAML DATE VARCHAR2(3) VARCHAR2(3) NUMBER(9) VARCHAR2(9) VARCHAR2(9) VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(9) VARCHAR2(200) VARCHAR2(45) VARCHAR2(200) No No No Yes Yes No No No No No No No No No No No Yes Yes No No No No No No No No PowerDesigner Code 2/21/02 Label Ballot measure number or letter. Used on the Form 401 Schedule A. Candidate/officeholder's first name. Used on the Form 401 Schedule A. Candidate/officeholder's last name. Used on the Form 401 Schedule A. Candidate/officeholder's name suffix. Used on the Form 401 Schedule A. Candidate/officeholder's name prefix or title. Used on the Form 401 Schedule A. Committee Identification number. First line of the contributor's street address. Second line of the contributor's street address. Contributor's City Description of goods/services received. Employer Contributor's First Name Contributor's last name or business name. Contributor's Suffix Contributor's Prefix or Title Occupation Self Employed Check-box Contributor's State Contributor's ZIP+4 Cumulative Other (Sched A, A-1) Cumulative year to date amount (Form 460 Schedule A and Form 401 Schedule A, A-1) End of date range for items received Office District Number (used on F401A) Entity code: Values [CMO RCP IND OTH] Unique filing identification number. Schedule Name/ID: Sched A, C, I, A-1, F401A First line of the intermediary's street address. Second line of the Intermediary's street address. Intermediary's City Intermediary's Employer Intermediary's First Name Intermediary's Last Name Page 118 Physical Data Model Model_1 Name INTR_NAMS INTR_NAMT INTR_OCC INTR_SELF INTR_ST INTR_ZIP4 JURIS_CD Code INTR_NAMS INTR_NAMT INTR_OCC INTR_SELF INTR_ST INTR_ZIP4 JURIS_CD Type VARCHAR2(10) VARCHAR2(10) VARCHAR2(60) VARCHAR2(1) VARCHAR2(2) VARCHAR2(10) VARCHAR2(3) P No No No No No No No M No No No No No No No JURIS_DSCR LINE_ITEM MEMO_CODE MEMO_REFNO OFF_S_H_CD JURIS_DSCR LINE_ITEM MEMO_CODE MEMO_REFNO OFF_S_H_CD VARCHAR2(40) NUMBER(9) VARCHAR2(1) VARCHAR2(20) VARCHAR2(1) No Yes No No No No Yes No No No OFFIC_DSCR OFFICE_CD OFFIC_DSCR OFFICE_CD VARCHAR2(40) VARCHAR2(3) No No No No RCPT_DATE REC_TYPE SUP_OPP_CD RCPT_DATE REC_TYPE SUP_OPP_CD DATE VARCHAR2(4) VARCHAR2(1) No Yes No No Yes No TRAN_ID TRAN_ID VARCHAR2(20) No No TRAN_TYPE TRAN_TYPE VARCHAR2(1) No No TRES_ADR1 TRES_ADR1 VARCHAR2(55) No No TRES_ADR2 TRES_ADR2 VARCHAR2(55) No No TRES_CITY TRES_CITY VARCHAR2(30) No No TRES_NAMF TRES_NAML TRES_NAMS TRES_NAMT TRES_ST TRES_NAMF TRES_NAML TRES_NAMS TRES_NAMT TRES_ST VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(2) No No No No No No No No No No TRES_ZIP4 TRES_ZIP4 VARCHAR2(10) No No PowerDesigner 2/21/02 Label Intermediary's Suffix Intermediary's Prefix or Title Intermediary's Occupation Intermediary's self employed check box. Intermediary's state. Intermediary's zip code. Office jurisdiction code. See the CAL document for the list of legal values. Used on Form 401 Schedule A. Office Jurisdiction Description (used on F401A) Record line item number. Memo amount flag (Date/Amount are informational only) Reference to text contained in a TEXT record Office Sought/Held Code. Used on the Form 401 Schedule A. Legal values are "S" for sought and "H" for held. Office Sought Description (used on F401A) Code that identifies the office being sought. See the CAL document for a list of valid codes. Used on the Form 401 Schedule A) Date item received. Record Type Value: RCPT Support/oppose code. Legal values are "S" for support or "O" for oppose. Used on Form 401 Sechedule A. Transaction identifier - permanent value unique to this item. Transaction Type: Values T- third party F Forgiven loan R Returned (Negative amount) First line of the treasurer or responsible officer's street address. Second line of the treasurer or responsible officer's street address. City portion of the treasurer or responsible officer's street address. Treasurer or responsible officer's first name. Treasurer or responsible officer's last name. Treasurer or responsible officer's suffix. Treasurer or responsible officer's prefix or title. State portion of the treasurer or responsible officer's address. Zip code portion of the treasurer or responsible officer's Page 119 Physical Data Model Model_1 Name Code Type P M XREF_MATCH XREF_MATCH VARCHAR2(1) No No XREF_SCHNM XREF_SCHNM VARCHAR2(2) No No Label address. Related item on other schedule has same transaction identifier. "X" indicates this condition is true. Related record is included on Sched 'B2' or 'F' Index List Index Code PK_RCPT P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: RECEIVED_FILINGS Column List Name FILER_ID FILING_DIRECTORY FILING_FILE_NAME FILING_ID FORM_ID RECEIVE_COMMENT RECEIVED_DATE Code FILER_ID FILING_DIRECTORY FILING_FILE_NAME FILING_ID FORM_ID RECEIVE_COMMENT RECEIVED_DATE Type NUMBER(9) VARCHAR2(60) VARCHAR2(60) NUMBER(9) VARCHAR2(7) VARCHAR2(120) DATE P No No No No No No No M Yes Yes Yes No No No Yes Label Filer's unique identification number. Filing Directory FILING_FILE_NAME Unique filing identification number. Form Identification code Comment Date recieved. P Yes Yes Yes Yes M Yes Yes Yes Yes Label Filer's unique identification number. Job number Record line item number. User Identifier. TABLE: REPORT_PROCESSING_WORK_LIST Column List Name FILER_ID JOB_NUMBER LINE_ITEM USER_ID PowerDesigner Code FILER_ID JOB_NUMBER LINE_ITEM USER_ID Type NUMBER(9) NUMBER(9) NUMBER(9) VARCHAR2(32) 2/21/02 Page 120 Physical Data Model Model_1 Index List Index Code PK_REPORT_PROCESSING_WORK_LIST P Yes F No A No U Yes C No Column Code FILER_ID USER_ID JOB_NUMBER LINE_ITEM Sort ASC ASC ASC ASC TABLE: REPORTS Column List Name DATA_OBJECT PARM_DEFINITION PARMS_FLG_Y_N PATH RPT_DESC_ RPT_ID RPT_NAME RPT_TYPE Code DATA_OBJECT PARM_DEFINITION PARMS_FLG_Y_N PATH RPT_DESC_ RPT_ID RPT_NAME RPT_TYPE Type VARCHAR2(255) NUMBER(9) VARCHAR2(1) VARCHAR2(255) VARCHAR2(255) NUMBER(9) VARCHAR2(255) NUMBER(9) P No No No No No Yes No No M No No No No No Yes No No Label Data Object Parameter definition. Parameters indication flag. Report path. Description of the report. Unique report identification number Name of the report Type of the report Index List Index Code PK_REPORTS P Yes F No A No U Yes C No Column Code RPT_ID Sort ASC TABLE: REVIEW_LIST Column List Name CHK_ID FORM_ID FORM_PAGE LINE_ID REVIEW_TEXT PowerDesigner Code CHK_ID FORM_ID FORM_PAGE LINE_ID REVIEW_TEXT Type NUMBER(9) VARCHAR2(7) VARCHAR2(32) NUMBER(9) VARCHAR2(255) 2/21/02 P Yes No No No No M Yes No No No No Label Review list check identificaiton number. Form Identification code Form Page LINE_ID REVIEW_TEXT Page 121 Physical Data Model Model_1 Index List Index Code PK_REVIEW_LIST P Yes F No A No U Yes C No Column Code CHK_ID Sort ASC TABLE: S401 Column List Name AGENT_NAMF AGENT_NAML AGENT_NAMS AGENT_NAMT AGGREGATE AMEND_ID Code AGENT_NAMF AGENT_NAML AGENT_NAMS AGENT_NAMT AGGREGATE AMEND_ID Type VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) NUMBER(12,2) NUMBER(9) P No No No No No Yes M No No No No No Yes AMOUNT BAKREF_TID AMOUNT BAKREF_TID NUMBER(12,2) VARCHAR2(20) No No No No BAL_JURIS BAL_NAME BAL_NUM CAND_NAMF CAND_NAML CAND_NAMS CAND_NAMT DIST_NO BAL_JURIS BAL_NAME BAL_NUM CAND_NAMF CAND_NAML CAND_NAMS CAND_NAMT DIST_NO VARCHAR2(40) VARCHAR2(200) VARCHAR2(7) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(3) No No No No No No No No No No No No No No No No EXPN_DSCR FILING_ID FORM_TYPE JURIS_CD EXPN_DSCR FILING_ID FORM_TYPE JURIS_CD VARCHAR2(90) NUMBER(9) VARCHAR2(7) VARCHAR2(3) No Yes Yes No No Yes Yes No JURIS_DSCR LINE_ITEM MEMO_CODE MEMO_REFNO OFF_S_H_CD JURIS_DSCR LINE_ITEM MEMO_CODE MEMO_REFNO OFF_S_H_CD VARCHAR2(40) NUMBER(9) VARCHAR2(1) VARCHAR2(20) VARCHAR2(1) No Yes No No No No Yes No No No PowerDesigner 2/21/02 Label Agent or Ind. Contractor's First Name Agent or Independent contractor's last name. Agent or independent contractor's suffix. Agent or independent contractor's prefix or title. Aggregate YTD Amount (Sched 401C) Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Amount (Sched F401B, 401B-1, 401C) Back Reference to a transaction identifier of a parent record. Jurisdiction of ballot measure. Ballot measure name. Ballot measure number or letter. Candidate/officeholder's first name. Candidate/officeholder's last name. Candidate/officeholder's name suffix. Candidate/officeholder's name prefix or title. District number for the office being sought. Populated for Senate, Assembly, or Board of Equalization races. Purpose of expense and/or description/explanation Unique filing identification number. Schedule Name/ID: [F401B F401B-1 F401C F401D] Office jurisdiction code. See the CAL document for the list of legal values. Office Jurisdiction Description Record line item number. Memo amount flag Reference to text contained in a TEXT record Office sought/held code. Legal values are "S" for sought Page 122 Physical Data Model Model_1 Name Code Type P M OFFIC_DSCR OFFICE_CD OFFIC_DSCR OFFICE_CD VARCHAR2(40) VARCHAR2(3) No No No No PAYEE_ADR1 PAYEE_ADR2 PAYEE_CITY PAYEE_NAMF PAYEE_NAML PAYEE_ADR1 PAYEE_ADR2 PAYEE_CITY PAYEE_NAMF PAYEE_NAML VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(45) VARCHAR2(200) No No No No No No No No No No PAYEE_NAMS PAYEE_NAMT PAYEE_ST PAYEE_ZIP4 REC_TYPE SUP_OPP_CD PAYEE_NAMS PAYEE_NAMT PAYEE_ST PAYEE_ZIP4 REC_TYPE SUP_OPP_CD VARCHAR2(10) VARCHAR2(10) VARCHAR2(2) VARCHAR2(10) VARCHAR2(4) VARCHAR2(1) No No No No Yes No No No No No Yes No TRAN_ID TRAN_ID VARCHAR2(20) No No Label and "H" for held. Office Sought Description Code that identifies the office being sought. See the CAL document for a list of valid codes. First line of the payee's street address. Second line of the payee's street address. Payee's city. Payee's first name if the payee is an individual. Payee's business name or last name if the payee is an individual. Payee's name suffix if the payee is an individual. Payee's prefix or title if the payee is an individual. Payee's state. Payee's zip code. Record Type Value: S401 Support/oppose code. Legal values are "S" for support or "O" for oppose. Used on Form 401. Transaction Id - permanent value unique to this item Index List Index Code PK_S401 P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: S496 Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes AMOUNT DATE_THRU EXP_DATE AMOUNT DATE_THRU EXP_DATE NUMBER(12,2) DATE DATE No No No No No No PowerDesigner 2/21/02 Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Expenditure Amount End of date range for items paid Expenditure Date Page 123 Physical Data Model Name EXPN_DSCR FILING_ID FORM_TYPE LINE_ITEM MEMO_CODE MEMO_REFNO REC_TYPE TRAN_ID Model_1 Code EXPN_DSCR FILING_ID FORM_TYPE LINE_ITEM MEMO_CODE MEMO_REFNO REC_TYPE TRAN_ID Type VARCHAR2(90) NUMBER(9) VARCHAR2(4) NUMBER(9) VARCHAR2(1) VARCHAR2(20) VARCHAR2(4) VARCHAR2(20) P No Yes Yes Yes No No Yes No M No Yes Yes Yes No No Yes No Label Purpose of expense and/or description/explanation Unique filing identification number. Schedule Name/ID: F496 Record line item number. Memo amount flag Reference to text contained in a TEXT record Record Type Value:: S496 Transaction Id - permanent value unique to this item Index List Index Code IX_S496_AMEND_ID IX_S496_AMOUNT IX_S496_EXP_DATE IX_S496_FILING_ID IX_S496_FORM_TYPE IX_S496_REC_TYPE IX_S496_TRAN_ID PK_S496 P No No No No No No No Yes F No No No Yes No No No No A No No No No No No No No U No No No No No No No Yes C No No No No No No No No Column Code AMEND_ID AMOUNT EXP_DATE FILING_ID FORM_TYPE REC_TYPE TRAN_ID FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC TABLE: S497 Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes AMOUNT BAL_ID BAL_JURIS BAL_NAME BAL_NUM CAND_ID AMOUNT BAL_ID BAL_JURIS BAL_NAME BAL_NUM CAND_ID NUMBER(12,2) VARCHAR2(9) VARCHAR2(40) VARCHAR2(200) VARCHAR2(7) VARCHAR2(9) No No No No No No No No No No No No PowerDesigner 2/21/02 Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Amount Received/Made Ballot measure name. Ballot measure number or letter. Page 124 Physical Data Model Model_1 Name CAND_NAMF CAND_NAML CAND_NAMS CAND_NAMT CMTE_ID CTRIB_DATE CTRIB_EMP CTRIB_OCC CTRIB_SELF Code CAND_NAMF CAND_NAML CAND_NAMS CAND_NAMT CMTE_ID CTRIB_DATE CTRIB_EMP CTRIB_OCC CTRIB_SELF Type VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(9) DATE VARCHAR2(200) VARCHAR2(60) VARCHAR2(1) P No No No No No No No No No M No No No No No No No No No DATE_THRU DIST_NO DATE_THRU DIST_NO DATE VARCHAR2(3) No No No No ELEC_DATE ENTITY_CD ENTY_ADR1 ENTY_ADR2 ENTY_CITY ENTY_NAMF ENTY_NAML ELEC_DATE ENTITY_CD ENTY_ADR1 ENTY_ADR2 ENTY_CITY ENTY_NAMF ENTY_NAML DATE VARCHAR2(3) VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(45) VARCHAR2(200) No No No No No No No No No No No No No No ENTY_NAMS ENTY_NAMT ENTY_ST ENTY_ZIP4 FILING_ID FORM_TYPE ENTY_NAMS ENTY_NAMT ENTY_ST ENTY_ZIP4 FILING_ID FORM_TYPE VARCHAR2(10) VARCHAR2(10) VARCHAR2(2) VARCHAR2(10) NUMBER(9) VARCHAR2(6) No No No No Yes Yes No No No No Yes Yes JURIS_CD JURIS_CD VARCHAR2(3) No No JURIS_DSCR LINE_ITEM MEMO_CODE MEMO_REFNO OFF_S_H_CD JURIS_DSCR LINE_ITEM MEMO_CODE MEMO_REFNO OFF_S_H_CD VARCHAR2(40) NUMBER(9) VARCHAR2(1) VARCHAR2(20) VARCHAR2(1) No Yes No No No No Yes No No No OFFIC_DSCR OFFICE_CD OFFIC_DSCR OFFICE_CD VARCHAR2(40) VARCHAR2(3) No No No No REC_TYPE REC_TYPE VARCHAR2(4) Yes Yes PowerDesigner 2/21/02 Label Candidate/officeholder's first name. Candidate/officeholder's last name. Candidate/officeholder's name suffix. Candidate/officeholder's name prefix or title. Committee Identification number. Date item received /made Employer Occupation Self employed checkbox. "X" indicates the contributor is self-employed. End of date range for items received District number for the office being sought. Populated for Senate, Assembly, or Board of Equalization races. Date of election Entity code Filing Committee's Street 1 Filing Committee's Street 2 Filing Committee's City Entity's First Name Entity's business or last name if the entity is an individual. Entity's Last Suffix Entity's Last Prefix or Title Filing Committee's State Filing Committee's zip code. Unique filing identification number. Schedule Name/Identification. Legal values are F497P1 and F497P2. Office jurisdiction code. See the CAL document for the list of legal values. Office Jurisdiction Description Record line item number. Memo amount flag Reference to text contained in a TEXT record Office Sought/Held Code. Legal values are "S" for sought and "H" for held. Office Sought Description Code that identifies the office being sought. See the CAL document for a list of valid codes. Record Type Value: S497 Page 125 Physical Data Model Name SUP_OFF_CD SUP_OPP_CD TRAN_ID Model_1 Code SUP_OFF_CD SUP_OPP_CD TRAN_ID Type VARCHAR2(1) VARCHAR2(1) VARCHAR2(20) P No No No M No No No Label Transaction Id - permanent value unique to this item Index List Index Code IX_S497_AMEND_ID IX_S497_AMOUNT IX_S497_BAL_ID IX_S497_CAND_ID IX_S497_CAND_NAML IX_S497_CMTE_ID IX_S497_CTRIB_DATE IX_S497_ENTY_NAML IX_S497_FILING_ID IX_S497_FORM_TYPE IX_S497_OFFICE_CD IX_S497_REC_TYPE IX_S497_TRAN_ID PK_S497 P No No No No No No No No No No No No No Yes F No No No No No No No No Yes No No No No No A No No No No No No No No No No No No No No U No No No No No No No No No No No No No Yes C No No No No No No No No No No No No No No Column Code AMEND_ID AMOUNT BAL_ID CAND_ID CAND_NAML CMTE_ID CTRIB_DATE ENTY_NAML FILING_ID FORM_TYPE OFFICE_CD REC_TYPE TRAN_ID FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC ASC TABLE: S498 Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes AMT_ATTRIB AMT_RCVD BAL_JURIS BAL_NAME BAL_NUM AMT_ATTRIB AMT_RCVD BAL_JURIS BAL_NAME BAL_NUM NUMBER(12,2) NUMBER(12,2) VARCHAR2(40) VARCHAR2(200) VARCHAR2(7) No No No No No No No No No No PowerDesigner 2/21/02 Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Amount attributed (only if Form_type = 'F498-A') Amount Received Jurisdiction of ballot measure. Ballot measure name. Ballot measure number or letter. Page 126 Physical Data Model Model_1 Name CAND_NAMF CAND_NAML CAND_NAMS CAND_NAMT CMTE_ID DATE_RCVD DIST_NO Code CAND_NAMF CAND_NAML CAND_NAMS CAND_NAMT CMTE_ID DATE_RCVD DIST_NO Type VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(9) DATE VARCHAR2(3) P No No No No No No No M No No No No No No No EMPLOYER ENTITY_CD FILING_ID FORM_TYPE JURIS_CD EMPLOYER ENTITY_CD FILING_ID FORM_TYPE JURIS_CD VARCHAR2(200) VARCHAR2(3) NUMBER(9) VARCHAR2(6) VARCHAR2(3) No No Yes Yes No No No Yes Yes No JURIS_DSCR LINE_ITEM MEMO_CODE MEMO_REFNO OCCUPATION OFF_S_H_CD JURIS_DSCR LINE_ITEM MEMO_CODE MEMO_REFNO OCCUPATION OFF_S_H_CD VARCHAR2(40) NUMBER(9) VARCHAR2(1) VARCHAR2(20) VARCHAR2(60) VARCHAR2(1) No Yes No No No No No Yes No No No No OFFIC_DSCR OFFICE_CD OFFIC_DSCR OFFICE_CD VARCHAR2(40) VARCHAR2(3) No No No No PAYOR_ADR1 PAYOR_ADR2 PAYOR_CITY PAYOR_NAMF PAYOR_NAML PAYOR_NAMS PAYOR_NAMT PAYOR_ST PAYOR_ZIP4 REC_TYPE SELFEMP_CB SUP_OPP_CD PAYOR_ADR1 PAYOR_ADR2 PAYOR_CITY PAYOR_NAMF PAYOR_NAML PAYOR_NAMS PAYOR_NAMT PAYOR_ST PAYOR_ZIP4 REC_TYPE SELFEMP_CB SUP_OPP_CD VARCHAR2(55) VARCHAR2(55) VARCHAR2(30) VARCHAR2(45) VARCHAR2(200) VARCHAR2(10) VARCHAR2(10) VARCHAR2(2) VARCHAR2(10) VARCHAR2(4) VARCHAR2(1) VARCHAR2(1) No No No No No No No No No Yes No No No No No No No No No No No Yes No No TRAN_ID TRAN_ID VARCHAR2(20) No No PowerDesigner 2/21/02 Label Candidate/officeholder's first name. Candidate/officeholder's last name. Candidate/officeholder's name suffix. Candidate/officeholder's name prefix or title. Committee Identification number. Date received District number for the office being sought. Populated for Senate, Assembly, or Board of Equalization races. Employer Entity code Unique filing identification number. Schedule Name/ID: [ F498-R F498-A] Office jurisdiction code. See the CAL document for the list of legal values. Office Jurisdiction Description Record line item number. Memo amount flag Reference to text contained in a TEXT record Occupation Office Sought/Held Code. Legal values are "S" for sought and "H" for held. Office Sought Description Code that identifies the office being sought. See the CAL document for a list of valid codes. First line of the payor's street address. Second line of the payor's street address. Payor's city. Payor's first name. Payor's last name or business name. Payor's Suffix Payor's Prefix or Title Payor's State Payor's zip code. Record Type Value: S498 Self Employed check-box Support/oppose code. Legal values are "S" for support or "O" for oppose. Transaction Identifier - permanent value unique to this item Page 127 Physical Data Model Model_1 Index List Index Code PK_S498 P Yes F No A No U Yes C No Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC TABLE: SECURITY_APPS Column List Name APPLICATION DESCRIPTION Code APPLICATION DESCRIPTION Type VARCHAR2(32) VARCHAR2(64) P Yes No M Yes Yes Label Security - Application Description Index List Index Code PK_SECURITY_APPS P Yes F No A No U Yes C No Column Code APPLICATION Sort ASC TABLE: SECURITY_GROUPINGS Column List Name GROUP_NAME USER_NAME Code GROUP_NAME USER_NAME Type VARCHAR2(16) VARCHAR2(16) P Yes Yes M Yes Yes Label Group Name User Name. Index List Index Code PK_SECURITY_GROUPINGS PowerDesigner P Yes F No A No U Yes C No 2/21/02 Column Code GROUP_NAME USER_NAME Sort ASC ASC Page 128 Physical Data Model Model_1 TABLE: SECURITY_INFO Column List Name APPLICATION CONTROL STATUS USER_NAME WINDOW Code APPLICATION CONTROL STATUS USER_NAME WINDOW Type VARCHAR2(32) VARCHAR2(128) CHAR(1) VARCHAR2(16) VARCHAR2(64) P Yes Yes No Yes Yes M Yes Yes Yes Yes Yes Label Security - Application CONTROL Security status flag. User Name. WINDOW Index List Index Code PK_SECURITY_INFO P Yes F No A No U Yes C No Column Code APPLICATION WINDOW CONTROL USER_NAME Sort ASC ASC ASC ASC TABLE: SECURITY_TEMPLATE Column List Name APPLICATION CONTROL DESCRIPTION OBJECT_TYPE WINDOW Code APPLICATION CONTROL DESCRIPTION OBJECT_TYPE WINDOW Type VARCHAR2(32) VARCHAR2(128) VARCHAR2(254) VARCHAR2(24) VARCHAR2(64) P Yes Yes No No Yes M Yes Yes Yes Yes Yes Label Security - Application CONTROL Description Object type. WINDOW Index List Index Code PK_SECURITY_TEMPLATE PowerDesigner P Yes F No A No U Yes C No 2/21/02 Column Code APPLICATION WINDOW CONTROL Sort ASC ASC ASC Page 129 Physical Data Model Model_1 TABLE: SECURITY_USERS Column List Name DESCRIPTION NAME PRIORITY USER_TYPE Code DESCRIPTION NAME PRIORITY USER_TYPE Type VARCHAR2(32) VARCHAR2(16) NUMBER NUMBER P No Yes No No M Yes Yes Yes No Label Description NAME Priority. User Type. Index List Index Code PK_SECURITY_USERS P Yes F No A No U Yes C No Column Code NAME Sort ASC TABLE: SMRY Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes AMOUNT_A AMOUNT_B AMOUNT_C ELEC_DT FILING_ID FORM_TYPE LINE_ITEM REC_TYPE AMOUNT_A AMOUNT_B AMOUNT_C ELEC_DT FILING_ID FORM_TYPE LINE_ITEM REC_TYPE NUMBER(12,2) NUMBER(12,2) NUMBER(12,2) DATE NUMBER(9) VARCHAR2(8) VARCHAR2(8) VARCHAR2(4) No No No No Yes Yes Yes Yes No No No No Yes Yes Yes Yes Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Summary Amount (Column A on some forms) Summary Amount Column B Summary Amount Column C Unique filing identification number. Name of Filing Form or Schedule Name Line Number of Summary Total Record Type Value: SMRY Index List Index Code IX_SMRY_AMEND_ID IX_SMRY_FILING_ID IX_SMRY_FORM_TYPE PowerDesigner P No No No F No Yes No A No No No U No No No C No No No 2/21/02 Column Code AMEND_ID FILING_ID FORM_TYPE Sort ASC ASC ASC Page 130 Physical Data Model Model_1 Index Code IX_SMRY_LINE_ITEM IX_SMRY_REC_TYPE PK_SMRY P No No Yes F No No No A No No No U No No Yes C No No No Column Code LINE_ITEM REC_TYPE FILING_ID AMEND_ID LINE_ITEM REC_TYPE FORM_TYPE Sort ASC ASC ASC ASC ASC ASC ASC TABLE: SPLT Column List Name AMEND_ID ELEC_AMOUNT ELEC_CODE ELEC_DATE FILING_ID LINE_ITEM PFORM_TYPE PTRAN_ID Code AMEND_ID ELEC_AMOUNT ELEC_CODE ELEC_DATE FILING_ID LINE_ITEM PFORM_TYPE PTRAN_ID Type NUMBER(9) NUMBER(12,2) VARCHAR2(2) DATE NUMBER(9) NUMBER(9) VARCHAR2(7) VARCHAR2(32) P Yes No No No Yes Yes Yes No M Yes No No No Yes Yes Yes No Label Index List Index Code IX_SPLT_AMEND_ID IX_SPLT_FILING_ID IX_SPLT_FORM_TYPE IX_SPLT_PT_ID PK_SPLT P No No No No Yes F No Yes No No No A No No No No No U No No No No Yes C No No No No No Column Code AMEND_ID FILING_ID PFORM_TYPE PTRAN_ID FILING_ID AMEND_ID LINE_ITEM PFORM_TYPE Sort ASC ASC ASC ASC ASC ASC ASC ASC TABLE: SYSTEM_AUDIT PowerDesigner 2/21/02 Page 131 Physical Data Model Model_1 Column List Name ACTION COL_DATA_TYPE COL_NAME SA_DT SA_ID TAB_NAME USER_ID Code ACTION COL_DATA_TYPE COL_NAME SA_DT SA_ID TAB_NAME USER_ID Type VARCHAR2(32) VARCHAR2(12) VARCHAR2(32) DATE NUMBER(9) VARCHAR2(32) VARCHAR2(12) P No No No No Yes No No M No No No No Yes No No Label Action Column Data Type Column Name SA_DT SA_ID TAB_NAME User Identifier. Index List Index Code PK_SYSTEM_AUDIT P Yes F No A No U Yes C No Column Code SA_ID Sort ASC TABLE: TEXT_MEMO Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P Yes M Yes FILING_ID FORM_TYPE LINE_ITEM REC_TYPE REF_NO TEXT4000 FILING_ID FORM_TYPE LINE_ITEM REC_TYPE REF_NO TEXT4000 NUMBER(9) VARCHAR2(8) NUMBER(9) VARCHAR2(4) VARCHAR2(20) VARCHAR2(4000) Yes Yes Yes Yes No No Yes Yes Yes Yes No No Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. Unique filing identification number. Type of Filing or Formset the memo is assocated with. Record line item number. Record Type Value: This will always be TEXT. Used to link text memo to a specific record. Contents of the text memo. Index List Index Code PK_TEXT_MEMO PowerDesigner P Yes F No A No U Yes C No 2/21/02 Column Code FILING_ID AMEND_ID LINE_ITEM REC_TYPE Sort ASC ASC ASC ASC Page 132 Physical Data Model Index Code Model_1 P F A U C Column Code FORM_TYPE Sort ASC TABLE: TVIEW_CONTRIBUTIONS3 Column List Name Code Type CMTE_LOGICAL_TYPE CMTE_LOGICAL_TYPE VARCHAR2(32) CONTEST_2 CONTEST_2 VARCHAR2(2000) CONTEST_3 CONTEST_3 VARCHAR2(2000) CONTEST_4 CONTEST_4 VARCHAR2(2000) CONTEST_5 CONTEST_5 VARCHAR2(2000) CONTEST_6 CONTEST_6 VARCHAR2(2000) CONTEST_7 CONTEST_7 VARCHAR2(2000) CONTRIBAMOUNT CONTRIBAMOUNT NUMBER(12,2) CONTRIBENDDATE CONTRIBENDDATE DATE CONTRIBFILINGID CONTRIBFILINGID NUMBER(9) CONTRIBFIRSTNAME CONTRIBFIRSTNAME VARCHAR2(45) CONTRIBID CONTRIBID VARCHAR2(9) CONTRIBLASTNAME CONTRIBLASTNAME VARCHAR2(247) CONTRIBRECIPIENTCON CONTRIBRECIPIENTCON VARCHAR2(2000) TEST TEST CONTRIBRECIPIENTCON CONTRIBRECIPIENTCON VARCHAR2(2000) TESTID TESTID CONTRIBRECIPIENTFIRS CONTRIBRECIPIENTFIRS VARCHAR2(2000) TNAME TNAME CONTRIBRECIPIENTID CONTRIBRECIPIENTID NUMBER(9) CONTRIBRECIPIENTLAS CONTRIBRECIPIENTLAS VARCHAR2(250) TNAME TNAME CONTRIBSORTNAME CONTRIBSORTNAME VARCHAR2(10) CONTRIBSTARTDATE CONTRIBSTARTDATE DATE CONTRIBTYPE CONTRIBTYPE VARCHAR2(17) DATERECEIVED DATERECEIVED DATE DATETHRU DATETHRU DATE MEASURE MEASURE VARCHAR2(400) MEASURE_NAME MEASURE_NAME VARCHAR2(400) SUP_OPP SUP_OPP VARCHAR2(400) PowerDesigner 2/21/02 P No No No No No No No No No No No No No No M No No No No No No No No No Yes No No No No Label Contribution Amount Contribution End Date Contributor Filing Id Contributor First Name Contributor Id Contributor Last Name Contibution recipient's contest. No No Contibution recipient's contest identifier. No No Contribution Recipient First Name No No Yes No Contribution recipient's identification number. Contribution recipient's last name. No No No No No No No No No No Yes No No No No No Contribution sort name. Contribution start date. Contribution type. Date received. Date through. MEASURE MEASURE_NAME SUP_OPP Page 133 Physical Data Model Model_1 TABLE: USER_BATCH_PRINT_LIST Column List Name EXEC_DT FILER_ID JOB_TYPE QUE_DT USER_ID Code Type EXEC_DT FILER_ID JOB_TYPE QUE_DT USER_ID P No Yes Yes No Yes DATE NUMBER(9) NUMBER(9) DATE VARCHAR2(12) M No Yes Yes No Yes Label J M needs to describe this field. Filer's unique identification number. Job type. Date queued. User Identifier. Index List Index Code PK_USER_BATCH_PRINT_LIST P Yes F No A No U Yes C No Column Code FILER_ID JOB_TYPE USER_ID Sort ASC ASC ASC TABLE: USER_CHECK_LIST Column List Name CK_SEQ FORM_ID UCL_DESC WK_ID Code CK_SEQ FORM_ID UCL_DESC WK_ID Type NUMBER(9) VARCHAR2(7) VARCHAR2(255) NUMBER(9) P Yes No No Yes M Yes No No Yes Label Check List Sequence Form Identification code UCL_DESC Work role identification number. Index List Index Code PK_USER_CHECK_LIST P Yes F No A No U Yes C No Column Code WK_ID CK_SEQ Sort ASC ASC TABLE: VALIDATOR_ERRORS PowerDesigner 2/21/02 Page 134 Physical Data Model Model_1 Column List Name AMEND_ID Code AMEND_ID Type NUMBER(9) P No M No CAL_FILE_NUMBER ERROR_CODE ERROR_DESCRIPTION ERROR_TYPE FIELD_NUMBER1 CAL_FILE_NUMBER ERROR_CODE ERROR_DESCRIPTION ERROR_TYPE FIELD_NUMBER1 NUMBER(9) VARCHAR2(3) VARCHAR2(200) VARCHAR2(1) VARCHAR2(80) No No No No No No No No No No FIELD_NUMBER2 FIELD_NUMBER2 VARCHAR2(80) No No FIELD_VALUE1 FIELD_VALUE2 FILING_ID FORM_TYPE LINE_NUMBER REC_TYPE TRAN_ID FIELD_VALUE1 FIELD_VALUE2 FILING_ID FORM_TYPE LINE_NUMBER REC_TYPE TRAN_ID VARCHAR2(200) VARCHAR2(200) NUMBER(9) VARCHAR2(7) NUMBER(9) VARCHAR2(4) VARCHAR2(20) No No No No No No No No No No No No No No Type VARCHAR2(128) NUMBER(9) P No Yes M No Yes Label Amendment Identification number. A number of 0 is an original filing and 1 to 999 amendments. CAL File number Error code Description of the error. Error type Field number in the CAL document where the error is located Field number of a second field (used for validation of summary numbers) Value contained in the field. Field Value contained in the second field. Unique filing identification number. Type of Filing or Formset Line number where error occurs in the cal file Record Type Value: Transaction identifier - permanent value unique to this item. TABLE: WORK_ROLES Column List Name WK_DESC WK_ID Code WK_DESC WK_ID Label Description of the work role. Work role identification number. Index List Index Code PK_WORK_ROLES PowerDesigner P Yes F No A No U Yes C No 2/21/02 Column Code WK_ID Sort ASC Page 135