r_action
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 |
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) );