Exportable Fields from CT2k:
Table/Column
|
Table Name |
Table Column Name |
Comment |
|
Analysis |
||
|
AnalysisDate |
||
|
Originator |
Committee name |
|
|
OriginatorHouse |
House of committee |
|
|
Assigned |
||
|
Assigned |
From position form, who bill is assigned to |
|
|
Bill |
||
|
Measure |
||
|
Author |
||
|
Topic |
||
|
RelatingTo |
||
|
LongAuthor |
||
|
ChapterNumber |
||
|
Title |
||
|
CurrentLocation |
||
|
CurrentHouse |
||
|
CurrentLocationDate |
||
|
Status |
||
|
StatusDate |
||
|
EnrollmentDate |
||
|
ChapterDate |
||
|
MeasurePrefix |
AB, SB, etc |
|
|
MeasureNumber |
1,2,3… |
|
|
LineItemVetoDate |
||
|
VetoDate |
||
|
EnrolledDate |
||
|
LastAmendDate |
||
|
TextVersion |
A, I, E, C, V of most recent text version |
|
|
TextVersionDate |
Date of most recent text version |
|
|
IntroducedDate |
||
|
BillType |
||
|
BillType |
Urgency, fiscal, etc. |
|
|
Calendar |
||
|
CalendarDateTime |
||
|
Committee |
||
|
House |
||
|
CalendarType |
Floor or committee |
|
|
Room |
||
|
Chair |
||
|
State |
||
|
Description |
||
|
ItemNumber |
Item number for floor events |
|
|
Client |
||
|
ClientName |
From position form, organization bill is assigned to |
|
|
Committee |
||
|
Name |
Name of committee |
|
|
Chair |
||
|
ViceChair |
||
|
Secretary |
||
|
House |
||
|
Staff |
||
|
Group |
||
|
GroupName |
From position form, group assigned to |
|
|
History |
History events for a bill |
|
|
EventDate |
||
|
Description |
||
|
Member |
Members of Senate and Assembly |
|
|
FName |
||
|
MName |
||
|
LName |
||
|
House |
||
|
District |
||
|
TerminationDate |
||
|
|
||
|
Room |
||
|
Phone |
||
|
Fax |
||
|
Party |
||
|
MemberVote |
||
|
Decision |
Y, N, A |
|
|
Misc1 |
||
|
Misc1 |
From position form |
|
|
Misc2 |
||
|
Misc2 |
From position form |
|
|
Notes |
||
|
Notes |
From position form |
|
|
Position |
||
|
YesFavorable |
Is a Yes vote favorable? |
|
|
Dead |
||
|
PhysicalFile |
||
|
Archived |
Is this position form archived? |
|
|
Priority |
||
|
Priority |
From position form, priority of bill |
|
|
Short |
||
|
Short |
From position form, position taken on bill |
|
|
Subject |
||
|
Subject |
From position form, subject of bill |
|
|
SummaryDigest |
||
|
ShortSummary |
||
|
LongSummary |
||
|
Digest |
||
|
BasisDate |
||
|
TextVersion |
List of text versions for a bill |
|
|
TextDate |
||
|
VersionType |
A,I,E,C,V |
|
|
FileType |
Html or pdf |
|
|
UserSummary |
||
|
UserSummary |
User written summary for bill |
|
|
Vote |
List of votes taken on a bill |
|
|
VoteDate |
||
|
Originator |
House/Committee where vote was taken |