It is assumed that if the core data is requested from the Secretary of State, that the requesting party will have an experienced relational database person available to use it. This document is meant as a guide for this person.
Overview of the export process
The export process is a complete set of all data and tables at a point in time. We will call this the ‘UccCore’.
Table Design and Relations
You will find in this zipped package four pipe delimited text files containing the tables Filings, FilingAmendments, Debtors and SecuredParties.
When imported into a relational database and properly related, these files make what we call the UccCore.
The center of the table structure is the Filings table. It has a primary key called the FileNumber. All other tables are related to it in a one to many relationship between the Filings Table Primary Key, FileNumber, (ONE) and the Foreign Key, FileNumber (MANY), found in each of the other tables.
A listing of the tablesfollows:
UID = Record Unique Identifier. Will be unique values for the recordset
Pkey <table> = Primary Key for the <table> (Primary Relation)
Fkey <table> = Foreign Key for the <table> (Child Table)
[Filings]
[FileNumber] [varchar] (30) , Pkey
[FileDateTime] [varchar] (20),
[Type] [varchar] (250) ,
[AltFilingTypeId] [varchar] (250),
[OriginalFileNumber] [varchar] (30) ,
[LapseDate] [varchar] (20) ,
[PageCount] [varchar] (4),
[Debtors]
[FileNumber] [varchar] (30), Fkey
[NamePosition] [varchar] (4)
[OrganizationalType] [varchar] (20)
[OrganizationName] [varchar] (300)
[LastName] [varchar] (100),
[FirstName] [varchar] (100),
[MiddleName] [varchar] (100
[Suffix] [varchar] (50),
[addr1] [varchar] (255),
[addr2] [varchar] (50),
[addr3] [varchar] (50),
[addr4] [varchar] (50),
[City] [varchar] (30),
[State] [varchar] (30),
[PostalCode] [varchar] (20),
[County] [varchar] (50),
[Country] [varchar] (50),
[MailAddress] [varchar] (255)
[Blank] [varchar] (255),
[FilingAmendments]
[FileNumber] [varchar] (30), Fkey
[AmendmentType] [varchar] (50) ,
[SecuredParties]
[FileNumber] [varchar] (30, Fkey)
[NamePosition] [varchar] (4),
[PartyTypeId] [varchar] (4) ,
[OrganizationalType] [varchar] (20),
[OrganizationName] [varchar] (300)
[LastName] [varchar] (100),
[FirstName] [varchar] (100) ,
[MiddleName] [varchar] (100),
[Suffix] [varchar] (50),
[addr1] [varchar] (255),
[addr2] [varchar] (50),
[addr3] [varchar] (50),
[addr4] [varchar] (50),
[City] [varchar] (30),
[State] [varchar] (30),
[PostalCode] [varchar] (20)
[County] [varchar] (30),
[Country] [varchar] (50),
[MailAddress] [varchar] (255),
[Blank] [varchar] (255)