r_action

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ r_case_number unit_id action_sequence recurrence action_table_code action_field_code action_date date_entered action_control
101 101 01-RC-20309 A 0 0 RPRRD Issue 1995-09-01T00:00:00 1999-03-08T10:45:00 219
102 102 01-RC-20309 A 0 0 RWITH Appr 1996-03-25T00:00:00 2000-02-23T11:16:00 2532
103 103 01-RC-20309 A 0 1 RPRRD BrfRc 1995-08-09T00:00:00 1999-03-08T10:44:00 218
104 104 01-RC-20309 A 0 1 RPRRD Issue 1995-09-01T00:00:00 2000-03-22T08:58:00 2669
105 105 01-RC-20309 A 1 0 RPRRD Issue 1995-09-01T00:00:00    
106 106 01-RC-20310 A 0 0 RBLCK Block 2000-02-11T00:00:00 2000-02-17T11:42:00 2513
107 107 01-RC-20310 A 0 0 RBLCK Unblk 2000-02-23T00:00:00 2000-02-23T10:50:00 2529
108 108 01-RC-20310 A 0 0 RCASE Filed 1995-05-31T00:00:00 1999-03-08T10:47:00 220
109 109 01-RC-20310 A 0 0 RCLOS Close 2000-02-23T00:00:00 2000-02-23T11:14:00 2531
110 110 01-RC-20310 A 0 0 RPRHR Close 1995-07-19T00:00:00 1999-03-08T10:50:00 221
111 111 01-RC-20310 A 0 0 RPRHR HORpt 1995-07-20T00:00:00 1999-03-08T10:50:00 221
112 112 01-RC-20310 A 0 0 RPRHR Notic 1995-06-09T00:00:00 2000-03-31T11:19:00 2752
113 113 01-RC-20310 A 0 0 RPRHR Open 1995-06-19T00:00:00    
114 114 01-RC-20310 A 0 0 RPRRD BrfRc 1995-08-09T00:00:00 1999-03-08T10:50:00 222
115 115 01-RC-20310 A 0 0 RPRRD Issue 1995-09-01T00:00:00 1999-03-08T10:51:00 224
116 116 01-RC-20310 A 0 0 RWITH Appr 1996-03-25T00:00:00 2000-02-23T11:11:00 2530
117 117 01-RC-20310 A 0 1 RPRRD BrfRc 1995-08-09T00:00:00 1999-03-08T10:50:00 223
118 118 01-RC-20360 A 0 0 RBLCK Block 1995-09-20T00:00:00 1999-08-04T19:56:00 1478
119 119 01-RC-20360 A 0 0 RCASE Filed 1995-09-18T00:00:00 1999-08-04T19:55:00 1477
120 120 01-RC-20360 A 0 0 RCLOS Close 2003-12-16T00:00:00 2003-12-29T10:12:00 51048
121 121 01-RC-20360 A 0 0 RWITH Appr 2003-12-16T00:00:00 2003-12-29T10:12:00 51047
122 122 01-RC-20460 A 0 0 RBLCK Block 1996-05-16T00:00:00 1999-03-08T10:56:00 227
123 123 01-RC-20460 A 0 0 RBLCK Unblk 2003-11-05T00:00:00 2003-11-07T09:58:00 45772
124 124 01-RC-20460 A 0 0 RCASE Filed 1996-05-10T00:00:00 1999-03-08T10:53:00 225
125 125 01-RC-20460 A 0 0 RCLOS Close 2003-11-05T00:00:00 2003-11-07T09:57:00 45771
126 126 01-RC-20460 A 0 0 RPRHR Notic 1996-05-13T00:00:00 1999-03-08T10:55:00 226
127 127 01-RC-20460 A 0 0 RWITH Appr 2003-11-05T00:00:00 2003-11-07T09:57:00 45770
128 128 01-RC-20463 A 0 0 RBLCK Block 1996-07-08T00:00:00 1999-03-04T20:21:00 35
129 129 01-RC-20463 A 0 0 RCASE Filed 1996-05-20T00:00:00 1999-03-04T20:15:00 26
130 130 01-RC-20463 A 0 0 RCLOS Close 1999-10-27T00:00:00 1999-11-02T00:45:00 2026
131 131 01-RC-20463 A 0 0 RPRHR Close 1996-06-10T00:00:00 1999-03-04T20:20:00 31
132 132 01-RC-20463 A 0 0 RPRHR HORpt 1996-06-11T00:00:00 1999-03-04T20:20:00 31
133 133 01-RC-20463 A 0 0 RPRHR Notic 1995-05-21T00:00:00 1999-03-04T20:18:00 28
134 134 01-RC-20463 A 0 0 RPRHR Open 1996-06-10T00:00:00 1999-03-04T20:20:00 31
135 135 01-RC-20463 A 0 0 RPRHR Resch 1996-06-10T00:00:00 1999-03-04T20:19:00 29
136 136 01-RC-20463 A 0 0 RPRRD BrfRc 1996-06-17T00:00:00 1999-03-04T20:21:00 33
137 137 01-RC-20463 A 0 0 RPRRD Issue 1996-06-26T00:00:00 1999-03-04T20:21:00 34
138 138 01-RC-20463 A 0 0 RWITH Appr 1999-10-27T00:00:00 1999-11-02T00:41:00 2025
139 139 01-RC-20463 A 1 0 RBLCK Block 1996-08-21T00:00:00 1999-03-04T20:27:00 39
140 140 01-RC-20463 A 2 0 RBLCK Block 1996-09-09T00:00:00 1999-03-04T20:29:00 41
141 141 01-RC-20467 A 0 0 RCASE Filed 1996-05-28T00:00:00 1999-03-09T08:07:00 238
142 142 01-RC-20467 A 0 0 RCLOS Close 2001-01-10T00:00:00 2001-01-12T10:16:00 4160
143 143 01-RC-20467 A 0 0 RELEC Elect 1996-07-11T00:00:00    
144 144 01-RC-20467 A 0 0 RPRHR Notic 1996-05-28T00:00:00 2001-01-12T09:39:00 4154
145 145 01-RC-20467 A 0 0 RPSRD Actn 1996-09-09T00:00:00 2001-01-12T10:13:00 4158
146 146 01-RC-20467 A 0 0 RRAGR Appr 1996-06-14T00:00:00 1999-03-09T11:48:00 268
147 147 01-RC-20467 A 0 0 RWITH Appr 2001-01-10T00:00:00 2001-01-12T10:15:00 4159
148 148 01-RC-20467 A 1 0 RELEC Elect 1996-07-11T00:00:00 2001-01-12T09:47:00 4155
149 149 01-RC-20467 A 1 0 ROBJ Objec 1996-07-12T00:00:00 2001-01-12T10:10:00 4157
150 150 01-RC-20467 A 1 0 RPRHR Notic 1996-05-28T00:00:00    
151 151 01-RC-20467 A 1 1 ROBJ Objec 2001-01-10T00:00:00 2001-01-26T08:39:00 4227
152 152 01-RC-20467 A 1 1 RTALL Tally 1996-01-11T00:00:00 2001-01-12T09:54:00 4156
153 153 01-RC-20467 A 2 0 RRAGR Appr 1996-06-14T00:00:00    
154 154 01-RC-20508 A 0 0 RCASE Filed 1996-09-16T00:00:00 1999-08-18T13:50:00 1566
155 155 01-RC-20508 A 0 0 RCLOS Close 1999-10-28T00:00:00 1999-10-28T23:27:00 1993
156 156 01-RC-20508 A 0 0 RPRHR Close 1996-09-30T00:00:00 1999-08-18T13:55:00 1567
157 157 01-RC-20508 A 0 0 RPRHR HORpt 1996-10-01T00:00:00 1999-08-18T13:55:00 1567
158 158 01-RC-20508 A 0 0 RPRHR Open 1996-09-30T00:00:00    
159 159 01-RC-20508 A 0 0 RPRRD BrfRc 1996-10-10T00:00:00 1999-08-18T13:56:00 1568
160 160 01-RC-20508 A 0 0 RPRRD Issue 1996-11-07T00:00:00 1999-08-18T13:57:00 1570
161 161 01-RC-20508 A 0 1 RPRRD BrfRc 1996-10-10T00:00:00 1999-08-18T13:57:00 1569
162 162 01-RC-20508 A 182 0 RCERT Resul 1999-10-28T00:00:00 1999-10-28T12:18:00 1990
163 163 01-RC-20508 A 182 0 RELEC Elect 1996-12-06T00:00:00 1999-10-20T08:47:00 1901
164 164 01-RC-20508 A 182 1 RTALL Tally 1999-10-19T00:00:00 1999-10-20T08:52:00 1902
165 165 01-RC-20538 A 0 0 RBLCK Block 1996-11-29T00:00:00 1999-03-05T20:26:00 83
166 166 01-RC-20538 A 0 0 RBLCK Unblk 2003-11-10T00:00:00 2003-11-12T09:40:00 46327
167 167 01-RC-20538 A 0 0 RCASE Filed 1996-11-21T00:00:00 1999-03-05T20:25:00 82
168 168 01-RC-20538 A 0 0 RCLOS Close 2003-11-10T00:00:00 2003-11-12T09:39:00 46326
169 169 01-RC-20538 A 0 0 RPRHR Notic 1996-11-22T00:00:00    
170 170 01-RC-20574 A 0 0 RCASE Filed 1997-02-13T00:00:00 1999-03-05T13:57:00 136
171 171 01-RC-20574 A 0 0 RCLOS Close 2000-01-03T00:00:00 2000-01-03T21:29:00 2290
172 172 01-RC-20574 A 0 0 RPRHR Close 1997-07-17T00:00:00 1999-03-05T14:00:00 138
173 173 01-RC-20574 A 0 0 RPRHR HORpt 1997-07-18T00:00:00 1999-03-05T14:00:00 138
174 174 01-RC-20574 A 0 0 RPRHR Notic 1997-02-14T00:00:00 1999-03-05T13:59:00 137
175 175 01-RC-20574 A 0 0 RPRHR Open 1997-03-18T00:00:00 1999-03-05T14:00:00 138
176 176 01-RC-20574 A 0 0 RPRRD BrfRc 1997-08-27T00:00:00 1999-03-05T14:03:00 139
177 177 01-RC-20574 A 0 0 RPRRD Issue 1997-10-17T00:00:00 1999-03-05T14:06:00 141
178 178 01-RC-20574 A 0 1 RPRRD BrfRc 1997-08-27T00:00:00 1999-03-05T14:03:00 140
179 179 01-RC-20574 A 213 0 RCERT Rep 2000-01-03T00:00:00 2000-01-03T11:49:00 2291
180 180 01-RC-20574 A 213 0 RELEC Elect 1999-12-21T00:00:00 1999-12-23T12:23:00 2268
181 181 01-RC-20574 A 213 1 RTALL Tally 1999-12-21T00:00:00 1999-12-23T12:34:00 2269
182 182 01-RC-20600 A 0 0 RBLCK Block 1997-05-20T00:00:00 1999-08-19T08:45:00 1599
183 183 01-RC-20600 A 0 0 RCASE Filed 1997-04-21T00:00:00 1999-08-19T08:41:00 1597
184 184 01-RC-20600 A 0 0 RCLOS Close 2002-05-10T00:00:00 2002-05-14T16:08:00 6348
185 185 01-RC-20600 A 0 0 RWITH Appr 2002-05-10T00:00:00 2002-05-14T16:04:00 6347
186 186 01-RC-20622 A 0 0 RAMND Amend 1997-11-17T00:00:00 1999-03-09T08:04:00 237
187 187 01-RC-20622 A 0 0 RBLCK Block 1997-05-20T00:00:00 1999-03-09T08:01:00 236
188 188 01-RC-20622 A 0 0 RCASE Filed 1997-05-13T00:00:00 1999-03-09T07:58:00 235
189 189 01-RC-20622 A 0 0 RCLOS Close 2003-11-17T00:00:00 2003-11-18T13:52:00 47089
190 190 01-RC-20622 A 0 0 RPRHR Notic 1997-05-14T00:00:00    
191 191 01-RC-20622 A 0 0 RWITH Appr 2003-11-17T00:00:00 2003-11-18T13:52:00 47088
192 192 01-RC-20626 A 0 0 RBLCK Block 1997-06-27T00:00:00 2005-04-11T09:14:00 118225
193 193 01-RC-20626 A 0 0 RCASE Filed 1997-05-23T00:00:00 1999-08-19T08:54:00 1601
194 194 01-RC-20626 A 0 0 RCLOS Close 2005-01-06T00:00:00 2005-01-13T15:00:00 104188
195 195 01-RC-20626 A 0 0 RPRHR Notic 1997-05-27T00:00:00    
196 196 01-RC-20626 A 0 0 RRAGR Appr 1997-06-24T00:00:00 2001-01-26T09:33:00 4228
197 197 01-RC-20626 A 0 0 RWITH Appr 2005-01-06T00:00:00 2005-01-13T15:00:00 104187
198 198 01-RC-20626 A 1 0 RRAGR Appr 1997-06-24T00:00:00    
199 199 01-RC-20634 A 0 0 RBLCK Block 1997-07-11T00:00:00 1999-03-09T08:54:00 256
200 200 01-RC-20634 A 0 0 RCASE Filed 1997-06-04T00:00:00 1999-03-09T08:51:00 254

Next page

CREATE TABLE "r_action" (
    "r_case_number" text,
    "unit_id" text,
    "action_sequence" integer,
    "recurrence" integer,
    "action_table_code" text,
    "action_field_code" text,
    "action_date" text,
    "date_entered" text,
    "action_control" integer,
    FOREIGN KEY (r_case_number, unit_id) REFERENCES r_bargaining_unit (r_case_number, unit_id)
);