State of Vermont
Legislative Bill Tracking System

Bill Status Database File Layouts



STATUS.TXT - Status and History

Field                     Start  Length
-----------------------  ------  ------
Bill                          1       6
Title                         7      60
Drafter                      67      10
BDocNo                       77       6
CurBody                      83       1
HCode                        84       6
HStat                        90      22
HStatDat                    112      10
H1Date                      122      10
H1Jrn                       132       4
H2Act                       136       6
H2Date                      142      10
H2Jrn                       152       4
H3Act                       156       6
H3Date                      162      10
H3Jrn                       172       4
HPDocNo                     176       6
SCode                       182       6
SStat                       188      22
SStatDat                    210      10
S1Date                      220      10
S1Jrn                       230       4
S2Act                       234       6
S2Date                      240      10
S2Jrn                       250       4
S3Act                       254       6
S3Date                      260      10
S3Jrn                       270       4
SPDocNo                     274       6
AgrDate                     280      10
SentDate                    290      10
GovAct                      300       6
GovDate                     306      10
ActNo                       316       4
EffDate                     320      10
VariesFlag                  330       1
FDocNo                      331       6
FileLoc                     337      10
Request                     347       7
HAskDate                    354      10
HWDrDate                    364      10
HLieDate                    374      10
HCallDat                    384      10
SAskDate                    394      10
SWDrDate                    404      10
SLieDate                    414      10
SCallDat                    424      10
RecSeries                   434       3
PRA                         437       4

AMENDS.TXT - Amendments

Field                     Start  Length
-----------------------  ------  ------        ------
Bill                          1       6
Body                          7       1
Sequence                      8       6
Member                       14      20
Date                         34      10
Calendar                     44       4
FlAction                     48       5
Journal                      53       4
JrnDate                      57      10

COMREPTS.TXT - Committee Reports

Field                     Start  Length
-----------------------  ------  ------        ------
Bill                          1       6
Body                          7       1
Sequence                      8       6
Comm                         14      20
InDate                       34      10
OutDate                      44      10
Report                       54       5
Calendar                     59       4
FlAction                     63       5
Journal                      68       4
JrnDate                      72      10

CONFCOMM.TXT - Conference Committees

Field                     Start  Length
-----------------------  ------  ------        ------
Bill                          1       6
Sequence                      7       6
HCrDate                      13      10
SCrDate                      23      10
HMemb1                       33      20
HMemb2                       53      20
HMemb3                       73      20
SMemb1                       93      20
SMemb2                      113      20
SMemb3                      133      20
CCAction                    153      13
ActDate                     166      10
FlAction                    176       5
Journal                     181       4
JrnDate                     185      10

KEYWORD.TXT - Keywords

Field                     Start  Length
-----------------------  ------  ------        ------
Bill                          1       6
Sequence                      7       6
Keyword                      13      20

ROLLCALL.TXT - Rollcall Votes

Field                     Start  Length
-----------------------  ------  ------        ------
Bill                          1       6
Body                          7       1
Sequence                      8       6
Date                         14      10
Question                     24      30
Ayes                         54       6
Nays                         60       6
PassFail                     66       1
Journal                      67       4
JrnDate                      71      10

SECTIONS.TXT - VSA Sections Affected (passed bills only)

Field                     Start  Length
-----------------------  ------  ------        ------
Bill                          1       6
Sequence                      7       6
RecType                      13       1
TitleNo                      14       2
TitSuff                      16       1
DocType                      17       5
ArtNo                        22       2
Hyphen                       24       1
SecNo                        25       6
Suffix                       31       2

SPONSOR.TXT - Sponsors

Field                     Start  Length
-----------------------  ------  ------        ------
Bill                          1       6
Sequence                      7       6
Sponsor                      13      20