Synopsis
Table structure
|
Field |
Type |
Null |
Default |
Comments |
|
DOCKETID |
int(11) |
Yes |
NULL |
|
|
AGENCY |
varchar(5) |
Yes |
NULL |
Sub-agency responsible for the docket. Populated from the AGENCIES table, using the values here. |
|
DOCKETYEAR |
int(11) |
Yes |
NULL |
|
|
CATEGORY |
int(11) |
Yes |
NULL |
|
|
SUBCATEGORY |
int(11) |
Yes |
NULL |
|
|
CREATIONDATE |
date |
Yes |
NULL |
|
|
PROFMODDATE |
date |
Yes |
NULL |
|
|
CLOSINGDATE |
date |
Yes |
NULL |
|
|
COMMENTCLOSEDATE |
date |
Yes |
NULL |
|
|
STATUS |
char(1) |
Yes |
NULL |
|
|
STATDEADLINE |
date |
Yes |
NULL |
|
|
ALJHEARING |
char(1) |
Yes |
NULL |
|
|
OLDDOCKETNUMBER |
varchar(20) |
Yes |
NULL |
|
|
ACTIONOFFICE |
varchar(20) |
Yes |
NULL |
|
|
CFRVOLUME |
varchar(20) |
Yes |
NULL |
|
|
CFRPARTSUBPART |
varchar(20) |
Yes |
NULL |
|
|
TITLE |
varchar(255) |
Yes |
NULL |
|
|
SUBJECT |
varchar(255) |
Yes |
NULL |
|
|
PARTIES |
text |
Yes |
NULL |
|
|
REQUIREMENT |
varchar(255) |
Yes |
NULL |
|
|
ACTIONSOUGHT |
varchar(255) |
Yes |
NULL |
|
|
RIN |
varchar(255) |
Yes |
NULL |
|
|
STATCIT |
varchar(255) |
Yes |
NULL |
|
|
ABSTRACT |
text |
Yes |
NULL |
|
|
ARCHIVED |
char(1) |
Yes |
NULL |
|
|
TITLE_NORM |
varchar(255) |
Yes |
NULL |
|
|
SUBJECT_NORM |
varchar(255) |
Yes |
NULL |
|
|
PARTIES_NORM |
text |
Yes |
NULL |
|
|
REQUIREMENT_NORM |
varchar(255) |
Yes |
NULL |
|
|
ACTIONSOUGHT_NORM |
varchar(255) |
Yes |
NULL |
|
|
RIN_NORM |
varchar(255) |
Yes |
NULL |
|
|
STATCIT_NORM |
varchar(255) |
Yes |
NULL |
|
|
ABSTRACT_NORM |
text |
Yes |
NULL |
|
|
METADATAUPDATE |
int(11) |
Yes |
NULL |
|
|
TRIGGER_UPD_DATE |
date |
Yes |
NULL |
|
|
MIGRATED |
int(11) |
Yes |
NULL |
|
Notes