| 2265 |
kivins |
1 |
CREATE USER TSB
|
|
|
2 |
IDENTIFIED BY VALUES '28B463B25321502F'
|
|
|
3 |
DEFAULT TABLESPACE AFC_DATA
|
|
|
4 |
TEMPORARY TABLESPACE TEMP
|
|
|
5 |
PROFILE DEFAULT
|
|
|
6 |
ACCOUNT UNLOCK;
|
|
|
7 |
-- 3 Roles for TSB
|
|
|
8 |
GRANT CONNECT TO TSB;
|
|
|
9 |
GRANT RESOURCE TO TSB;
|
|
|
10 |
GRANT BPS TO TSB;
|
|
|
11 |
ALTER USER TSB DEFAULT ROLE ALL;
|
|
|
12 |
-- 5 System Privileges for TSB
|
|
|
13 |
GRANT CREATE ROLE TO TSB;
|
|
|
14 |
GRANT GRANT ANY ROLE TO TSB;
|
|
|
15 |
GRANT CREATE SESSION TO TSB;
|
|
|
16 |
GRANT UNLIMITED TABLESPACE TO TSB;
|
|
|
17 |
GRANT CREATE PUBLIC SYNONYM TO TSB;
|
|
|
18 |
|
|
|
19 |
|
|
|
20 |
alter session set current_schema = TSB;
|
|
|
21 |
|
|
|
22 |
|
|
|
23 |
CREATE TABLE TSB.ITERATIONS
|
|
|
24 |
(
|
|
|
25 |
PROJECT_CODE VARCHAR2(10 BYTE) CONSTRAINT C_ITERATIONS_36172 NOT NULL,
|
|
|
26 |
ITERATION INTEGER CONSTRAINT C_ITERATIONS_36173 NOT NULL,
|
|
|
27 |
NOTES VARCHAR2(1024 BYTE),
|
|
|
28 |
TXNSTORAGE_PATH VARCHAR2(128 BYTE),
|
|
|
29 |
USERNAME VARCHAR2(256 BYTE),
|
|
|
30 |
SCHEMA_VERSION VARCHAR2(12 BYTE)
|
|
|
31 |
)
|
|
|
32 |
TABLESPACE AFC_DATA
|
|
|
33 |
PCTUSED 0
|
|
|
34 |
PCTFREE 10
|
|
|
35 |
INITRANS 1
|
|
|
36 |
MAXTRANS 255
|
|
|
37 |
STORAGE (
|
|
|
38 |
INITIAL 64K
|
|
|
39 |
MINEXTENTS 1
|
|
|
40 |
MAXEXTENTS 2147483645
|
|
|
41 |
PCTINCREASE 0
|
|
|
42 |
BUFFER_POOL DEFAULT
|
|
|
43 |
)
|
|
|
44 |
LOGGING
|
|
|
45 |
NOCOMPRESS
|
|
|
46 |
NOCACHE
|
|
|
47 |
NOPARALLEL
|
|
|
48 |
MONITORING;
|
|
|
49 |
|
|
|
50 |
|
|
|
51 |
CREATE TABLE TSB.ITERATION_PARAMS
|
|
|
52 |
(
|
|
|
53 |
PROJECT_CODE VARCHAR2(10 BYTE) CONSTRAINT C_ITERATION_PARAMS_36175 NOT NULL,
|
|
|
54 |
ITERATION INTEGER DEFAULT 25 CONSTRAINT C_ITERATION_PARAMS_36176 NOT NULL,
|
|
|
55 |
NAME VARCHAR2(64 BYTE) CONSTRAINT C_ITERATION_PARAMS_36177 NOT NULL,
|
|
|
56 |
FIELDVALUE VARCHAR2(64 BYTE),
|
|
|
57 |
TESTSCENARIO_NO NUMBER,
|
|
|
58 |
SUPPORTED NUMBER(1) DEFAULT 1
|
|
|
59 |
)
|
|
|
60 |
TABLESPACE AFC_DATA
|
|
|
61 |
PCTUSED 0
|
|
|
62 |
PCTFREE 10
|
|
|
63 |
INITRANS 1
|
|
|
64 |
MAXTRANS 255
|
|
|
65 |
STORAGE (
|
|
|
66 |
INITIAL 64K
|
|
|
67 |
MINEXTENTS 1
|
|
|
68 |
MAXEXTENTS 2147483645
|
|
|
69 |
PCTINCREASE 0
|
|
|
70 |
BUFFER_POOL DEFAULT
|
|
|
71 |
)
|
|
|
72 |
LOGGING
|
|
|
73 |
NOCOMPRESS
|
|
|
74 |
NOCACHE
|
|
|
75 |
NOPARALLEL
|
|
|
76 |
MONITORING;
|
|
|
77 |
|
|
|
78 |
|
|
|
79 |
CREATE TABLE TSB.MASS_TXNS
|
|
|
80 |
(
|
|
|
81 |
PROJECTCODE VARCHAR2(10 BYTE) CONSTRAINT C_MASS_TXNS_36166 NOT NULL,
|
|
|
82 |
ITERATION INTEGER CONSTRAINT C_MASS_TXNS_36167 NOT NULL,
|
|
|
83 |
UDTYPE INTEGER CONSTRAINT C_MASS_TXNS_36168 NOT NULL,
|
|
|
84 |
UDSUBTYPE INTEGER CONSTRAINT C_MASS_TXNS_36169 NOT NULL,
|
|
|
85 |
NAME VARCHAR2(128 BYTE),
|
|
|
86 |
DESCRIPTION VARCHAR2(1024 BYTE),
|
|
|
87 |
ENABLED CHAR(1 BYTE) DEFAULT 'N' NOT NULL
|
|
|
88 |
)
|
|
|
89 |
TABLESPACE AFC_DATA
|
|
|
90 |
PCTUSED 0
|
|
|
91 |
PCTFREE 10
|
|
|
92 |
INITRANS 1
|
|
|
93 |
MAXTRANS 255
|
|
|
94 |
STORAGE (
|
|
|
95 |
INITIAL 64K
|
|
|
96 |
MINEXTENTS 1
|
|
|
97 |
MAXEXTENTS 2147483645
|
|
|
98 |
PCTINCREASE 0
|
|
|
99 |
BUFFER_POOL DEFAULT
|
|
|
100 |
)
|
|
|
101 |
LOGGING
|
|
|
102 |
NOCOMPRESS
|
|
|
103 |
NOCACHE
|
|
|
104 |
NOPARALLEL
|
|
|
105 |
MONITORING;
|
|
|
106 |
|
|
|
107 |
|
|
|
108 |
CREATE TABLE TSB.PROJECTS
|
|
|
109 |
(
|
|
|
110 |
PROJECT_CODE VARCHAR2(10 BYTE) CONSTRAINT C_PROJECTS_36162 NOT NULL,
|
|
|
111 |
NAME VARCHAR2(128 BYTE) CONSTRAINT C_PROJECTS_36163 NOT NULL,
|
|
|
112 |
TESTTEAM_CODE VARCHAR2(3 BYTE) CONSTRAINT C_PROJECTS_36164 NOT NULL,
|
|
|
113 |
ADDED DATE
|
|
|
114 |
)
|
|
|
115 |
TABLESPACE AFC_DATA
|
|
|
116 |
PCTUSED 0
|
|
|
117 |
PCTFREE 10
|
|
|
118 |
INITRANS 1
|
|
|
119 |
MAXTRANS 255
|
|
|
120 |
STORAGE (
|
|
|
121 |
INITIAL 64K
|
|
|
122 |
MINEXTENTS 1
|
|
|
123 |
MAXEXTENTS 2147483645
|
|
|
124 |
PCTINCREASE 0
|
|
|
125 |
BUFFER_POOL DEFAULT
|
|
|
126 |
)
|
|
|
127 |
LOGGING
|
|
|
128 |
NOCOMPRESS
|
|
|
129 |
NOCACHE
|
|
|
130 |
NOPARALLEL
|
|
|
131 |
MONITORING;
|
|
|
132 |
|
|
|
133 |
|
|
|
134 |
CREATE TABLE TSB.SEQGEN
|
|
|
135 |
(
|
|
|
136 |
PROJECT_CODE VARCHAR2(10 BYTE) CONSTRAINT C_SEQGEN_36151 NOT NULL,
|
|
|
137 |
ITERATION NUMBER CONSTRAINT C_SEQGEN_36152 NOT NULL,
|
|
|
138 |
SEQNAME VARCHAR2(200 BYTE) CONSTRAINT C_SEQGEN_36153 NOT NULL,
|
|
|
139 |
SEQVALUE NUMBER
|
|
|
140 |
)
|
|
|
141 |
TABLESPACE AFC_DATA
|
|
|
142 |
PCTUSED 0
|
|
|
143 |
PCTFREE 10
|
|
|
144 |
INITRANS 1
|
|
|
145 |
MAXTRANS 255
|
|
|
146 |
STORAGE (
|
|
|
147 |
INITIAL 64K
|
|
|
148 |
MINEXTENTS 1
|
|
|
149 |
MAXEXTENTS 2147483645
|
|
|
150 |
PCTINCREASE 0
|
|
|
151 |
BUFFER_POOL DEFAULT
|
|
|
152 |
)
|
|
|
153 |
LOGGING
|
|
|
154 |
NOCOMPRESS
|
|
|
155 |
NOCACHE
|
|
|
156 |
NOPARALLEL
|
|
|
157 |
MONITORING;
|
|
|
158 |
|
|
|
159 |
|
|
|
160 |
CREATE TABLE TSB.TESTCASES
|
|
|
161 |
(
|
|
|
162 |
USECASE_ID VARCHAR2(64 BYTE) CONSTRAINT C_TESTCASES_36192 NOT NULL,
|
|
|
163 |
NAME VARCHAR2(64 BYTE) DEFAULT 'Not named',
|
|
|
164 |
DESCRIPTION VARCHAR2(2048 BYTE),
|
|
|
165 |
TESTCASE_ID VARCHAR2(15 BYTE) CONSTRAINT C_TESTCASES_36194 NOT NULL,
|
|
|
166 |
TRACEABILITY_REF VARCHAR2(20 BYTE),
|
|
|
167 |
REF_TYPE VARCHAR2(40 BYTE),
|
|
|
168 |
USE_CASE_TYPE CHAR(1 BYTE),
|
|
|
169 |
CASE_REPEAT INTEGER DEFAULT 1,
|
|
|
170 |
REPEAT_DELAY INTEGER DEFAULT 5,
|
|
|
171 |
BATCH_SIZE INTEGER DEFAULT 99
|
|
|
172 |
)
|
|
|
173 |
TABLESPACE AFC_DATA
|
|
|
174 |
PCTUSED 0
|
|
|
175 |
PCTFREE 10
|
|
|
176 |
INITRANS 1
|
|
|
177 |
MAXTRANS 255
|
|
|
178 |
STORAGE (
|
|
|
179 |
INITIAL 64K
|
|
|
180 |
MINEXTENTS 1
|
|
|
181 |
MAXEXTENTS 2147483645
|
|
|
182 |
PCTINCREASE 0
|
|
|
183 |
BUFFER_POOL DEFAULT
|
|
|
184 |
)
|
|
|
185 |
LOGGING
|
|
|
186 |
NOCOMPRESS
|
|
|
187 |
NOCACHE
|
|
|
188 |
NOPARALLEL
|
|
|
189 |
MONITORING;
|
|
|
190 |
|
|
|
191 |
|
|
|
192 |
CREATE TABLE TSB.TEST_SCENARIOS
|
|
|
193 |
(
|
|
|
194 |
TESTSCENARIO_NO INTEGER CONSTRAINT C_TEST_SCENARIOS_36155 NOT NULL,
|
|
|
195 |
TESTCASE_ID VARCHAR2(20 BYTE) CONSTRAINT C_TEST_SCENARIOS_36156 NOT NULL,
|
|
|
196 |
DESCRIPTION VARCHAR2(4000 BYTE),
|
|
|
197 |
USECASE VARCHAR2(64 BYTE),
|
|
|
198 |
TESTCASE_SEQNO INTEGER CONSTRAINT C_TEST_SCENARIOS_36158 NOT NULL,
|
|
|
199 |
PROJECT_CODE VARCHAR2(10 BYTE) CONSTRAINT C_TEST_SCENARIOS_36159 NOT NULL,
|
|
|
200 |
ITERATION INTEGER CONSTRAINT C_TEST_SCENARIOS_36160 NOT NULL,
|
|
|
201 |
PREREQUISITE_SCENARIO NUMBER,
|
|
|
202 |
CCHLOG VARCHAR2(4000 BYTE),
|
|
|
203 |
ISSLOG VARCHAR2(4000 BYTE),
|
|
|
204 |
NAME VARCHAR2(256 BYTE),
|
|
|
205 |
REPEAT_COUNT INTEGER DEFAULT 1,
|
|
|
206 |
BATCH_SIZE INTEGER DEFAULT 1000
|
|
|
207 |
)
|
|
|
208 |
TABLESPACE AFC_DATA
|
|
|
209 |
PCTUSED 0
|
|
|
210 |
PCTFREE 10
|
|
|
211 |
INITRANS 1
|
|
|
212 |
MAXTRANS 255
|
|
|
213 |
STORAGE (
|
|
|
214 |
INITIAL 64K
|
|
|
215 |
MINEXTENTS 1
|
|
|
216 |
MAXEXTENTS 2147483645
|
|
|
217 |
PCTINCREASE 0
|
|
|
218 |
BUFFER_POOL DEFAULT
|
|
|
219 |
)
|
|
|
220 |
LOGGING
|
|
|
221 |
NOCOMPRESS
|
|
|
222 |
NOCACHE
|
|
|
223 |
NOPARALLEL
|
|
|
224 |
MONITORING;
|
|
|
225 |
|
|
|
226 |
|
|
|
227 |
CREATE TABLE TSB.TRANSACTION_SPECIFICATION
|
|
|
228 |
(
|
|
|
229 |
TXNSPEC_NO INTEGER CONSTRAINT C_TRANSACTION_SPECIFICAT_56898 NOT NULL,
|
|
|
230 |
NOTES VARCHAR2(512 BYTE),
|
|
|
231 |
TESTSCENARIO_NO INTEGER CONSTRAINT C_TRANSACTION_SPECIFICAT_56899 NOT NULL,
|
|
|
232 |
DESCRIPTION VARCHAR2(64 BYTE),
|
|
|
233 |
UDTYPE NUMBER CONSTRAINT C_TRANSACTION_SPECIFICAT_56900 NOT NULL,
|
|
|
234 |
UDSUBTYPE NUMBER CONSTRAINT C_TRANSACTION_SPECIFICAT_56901 NOT NULL,
|
|
|
235 |
PROJECT_CODE VARCHAR2(10 BYTE) CONSTRAINT C_TRANSACTION_SPECIFICAT_56902 NOT NULL,
|
|
|
236 |
ITERATION NUMBER CONSTRAINT C_TRANSACTION_SPECIFICAT_56903 NOT NULL,
|
|
|
237 |
SEQ_NO NUMBER
|
|
|
238 |
)
|
|
|
239 |
TABLESPACE AFC_DATA
|
|
|
240 |
PCTUSED 0
|
|
|
241 |
PCTFREE 10
|
|
|
242 |
INITRANS 1
|
|
|
243 |
MAXTRANS 255
|
|
|
244 |
STORAGE (
|
|
|
245 |
INITIAL 64K
|
|
|
246 |
MINEXTENTS 1
|
|
|
247 |
MAXEXTENTS 2147483645
|
|
|
248 |
PCTINCREASE 0
|
|
|
249 |
BUFFER_POOL DEFAULT
|
|
|
250 |
)
|
|
|
251 |
LOGGING
|
|
|
252 |
NOCOMPRESS
|
|
|
253 |
NOCACHE
|
|
|
254 |
NOPARALLEL
|
|
|
255 |
MONITORING;
|
|
|
256 |
|
|
|
257 |
|
|
|
258 |
|
|
|
259 |
|
|
|
260 |
|
|
|
261 |
|
|
|
262 |
|
|
|
263 |
CREATE TABLE TSB.TXNSPEC_VALUES
|
|
|
264 |
(
|
|
|
265 |
FIELDTAG INTEGER CONSTRAINT C_TXNSPEC_VALUES_36185 NOT NULL,
|
|
|
266 |
FIELDVALUE VARCHAR2(64 BYTE),
|
|
|
267 |
NOTES VARCHAR2(512 BYTE),
|
|
|
268 |
TXNSPEC_NO INTEGER CONSTRAINT C_TXNSPEC_VALUES_36186 NOT NULL,
|
|
|
269 |
TESTSCENARIO_NO INTEGER CONSTRAINT C_TXNSPEC_VALUES_36187 NOT NULL,
|
|
|
270 |
FIELDNAME VARCHAR2(64 BYTE),
|
|
|
271 |
XPATH VARCHAR2(512 BYTE),
|
|
|
272 |
PROJECT_CODE VARCHAR2(10 BYTE),
|
|
|
273 |
ITERATION NUMBER,
|
|
|
274 |
USER_SUPPLIED CHAR(1 BYTE),
|
|
|
275 |
SUBSCRIPT NUMBER(4) DEFAULT 0,
|
|
|
276 |
DISPLAY_FIELDNAME VARCHAR2(64 BYTE),
|
|
|
277 |
ORDINAL INTEGER DEFAULT 0 CONSTRAINT C_TXNSPEC_VALUES_36188 NOT NULL,
|
|
|
278 |
CHILD_COUNT INTEGER DEFAULT 0 CONSTRAINT C_TXNSPEC_VALUES_36189 NOT NULL,
|
|
|
279 |
OBSOLETE CHAR(1 BYTE) DEFAULT 'N' CONSTRAINT C_TXNSPEC_VALUES_36190 NOT NULL,
|
|
|
280 |
DISPLAYABLE CHAR(1 BYTE) DEFAULT 'Y'
|
|
|
281 |
)
|
|
|
282 |
TABLESPACE AFC_DATA
|
|
|
283 |
PCTUSED 0
|
|
|
284 |
PCTFREE 10
|
|
|
285 |
INITRANS 1
|
|
|
286 |
MAXTRANS 255
|
|
|
287 |
STORAGE (
|
|
|
288 |
INITIAL 4M
|
|
|
289 |
MINEXTENTS 1
|
|
|
290 |
MAXEXTENTS 2147483645
|
|
|
291 |
PCTINCREASE 0
|
|
|
292 |
BUFFER_POOL DEFAULT
|
|
|
293 |
)
|
|
|
294 |
LOGGING
|
|
|
295 |
NOCOMPRESS
|
|
|
296 |
NOCACHE
|
|
|
297 |
NOPARALLEL
|
|
|
298 |
MONITORING;
|
|
|
299 |
|
|
|
300 |
|
|
|
301 |
CREATE UNIQUE INDEX TSB.PK_ITERATIONS ON TSB.ITERATIONS
|
|
|
302 |
(PROJECT_CODE, ITERATION)
|
|
|
303 |
NOLOGGING
|
|
|
304 |
TABLESPACE AFC_INDX
|
|
|
305 |
PCTFREE 10
|
|
|
306 |
INITRANS 2
|
|
|
307 |
MAXTRANS 255
|
|
|
308 |
STORAGE (
|
|
|
309 |
INITIAL 64K
|
|
|
310 |
MINEXTENTS 1
|
|
|
311 |
MAXEXTENTS 2147483645
|
|
|
312 |
PCTINCREASE 0
|
|
|
313 |
BUFFER_POOL DEFAULT
|
|
|
314 |
)
|
|
|
315 |
NOPARALLEL;
|
|
|
316 |
|
|
|
317 |
|
|
|
318 |
CREATE UNIQUE INDEX TSB.U_ITERATION_PARAMS_49325 ON TSB.ITERATION_PARAMS
|
|
|
319 |
(ITERATION, TESTSCENARIO_NO, PROJECT_CODE, NAME)
|
|
|
320 |
NOLOGGING
|
|
|
321 |
TABLESPACE AFC_INDX
|
|
|
322 |
PCTFREE 10
|
|
|
323 |
INITRANS 2
|
|
|
324 |
MAXTRANS 255
|
|
|
325 |
STORAGE (
|
|
|
326 |
INITIAL 64K
|
|
|
327 |
MINEXTENTS 1
|
|
|
328 |
MAXEXTENTS 2147483645
|
|
|
329 |
PCTINCREASE 0
|
|
|
330 |
BUFFER_POOL DEFAULT
|
|
|
331 |
)
|
|
|
332 |
NOPARALLEL;
|
|
|
333 |
|
|
|
334 |
|
|
|
335 |
CREATE UNIQUE INDEX TSB.PK_MASS_TXNS ON TSB.MASS_TXNS
|
|
|
336 |
(UDTYPE, UDSUBTYPE, PROJECTCODE, ITERATION)
|
|
|
337 |
NOLOGGING
|
|
|
338 |
TABLESPACE AFC_INDX
|
|
|
339 |
PCTFREE 10
|
|
|
340 |
INITRANS 2
|
|
|
341 |
MAXTRANS 255
|
|
|
342 |
STORAGE (
|
|
|
343 |
INITIAL 64K
|
|
|
344 |
MINEXTENTS 1
|
|
|
345 |
MAXEXTENTS 2147483645
|
|
|
346 |
PCTINCREASE 0
|
|
|
347 |
BUFFER_POOL DEFAULT
|
|
|
348 |
)
|
|
|
349 |
NOPARALLEL;
|
|
|
350 |
|
|
|
351 |
|
|
|
352 |
CREATE UNIQUE INDEX TSB.PROJECT_CODE_PK ON TSB.PROJECTS
|
|
|
353 |
(PROJECT_CODE)
|
|
|
354 |
NOLOGGING
|
|
|
355 |
TABLESPACE AFC_INDX
|
|
|
356 |
PCTFREE 10
|
|
|
357 |
INITRANS 2
|
|
|
358 |
MAXTRANS 255
|
|
|
359 |
STORAGE (
|
|
|
360 |
INITIAL 64K
|
|
|
361 |
MINEXTENTS 1
|
|
|
362 |
MAXEXTENTS 2147483645
|
|
|
363 |
PCTINCREASE 0
|
|
|
364 |
BUFFER_POOL DEFAULT
|
|
|
365 |
)
|
|
|
366 |
NOPARALLEL;
|
|
|
367 |
|
|
|
368 |
|
|
|
369 |
CREATE UNIQUE INDEX TSB.PK_SEQGEN ON TSB.SEQGEN
|
|
|
370 |
(PROJECT_CODE, ITERATION, SEQNAME)
|
|
|
371 |
NOLOGGING
|
|
|
372 |
TABLESPACE AFC_INDX
|
|
|
373 |
PCTFREE 10
|
|
|
374 |
INITRANS 2
|
|
|
375 |
MAXTRANS 255
|
|
|
376 |
STORAGE (
|
|
|
377 |
INITIAL 64K
|
|
|
378 |
MINEXTENTS 1
|
|
|
379 |
MAXEXTENTS 2147483645
|
|
|
380 |
PCTINCREASE 0
|
|
|
381 |
BUFFER_POOL DEFAULT
|
|
|
382 |
)
|
|
|
383 |
NOPARALLEL;
|
|
|
384 |
|
|
|
385 |
|
|
|
386 |
CREATE UNIQUE INDEX TSB.PK_TESTCASES ON TSB.TESTCASES
|
|
|
387 |
(TESTCASE_ID)
|
|
|
388 |
NOLOGGING
|
|
|
389 |
TABLESPACE AFC_INDX
|
|
|
390 |
PCTFREE 10
|
|
|
391 |
INITRANS 2
|
|
|
392 |
MAXTRANS 255
|
|
|
393 |
STORAGE (
|
|
|
394 |
INITIAL 64K
|
|
|
395 |
MINEXTENTS 1
|
|
|
396 |
MAXEXTENTS 2147483645
|
|
|
397 |
PCTINCREASE 0
|
|
|
398 |
BUFFER_POOL DEFAULT
|
|
|
399 |
)
|
|
|
400 |
NOPARALLEL;
|
|
|
401 |
|
|
|
402 |
|
|
|
403 |
CREATE INDEX TSB.TEST_SCENARIO_INDEX ON TSB.TEST_SCENARIOS
|
|
|
404 |
(TESTCASE_ID, TESTCASE_SEQNO)
|
|
|
405 |
NOLOGGING
|
|
|
406 |
TABLESPACE AFC_INDX
|
|
|
407 |
PCTFREE 10
|
|
|
408 |
INITRANS 2
|
|
|
409 |
MAXTRANS 255
|
|
|
410 |
STORAGE (
|
|
|
411 |
INITIAL 64K
|
|
|
412 |
MINEXTENTS 1
|
|
|
413 |
MAXEXTENTS 2147483645
|
|
|
414 |
PCTINCREASE 0
|
|
|
415 |
BUFFER_POOL DEFAULT
|
|
|
416 |
)
|
|
|
417 |
NOPARALLEL;
|
|
|
418 |
|
|
|
419 |
|
|
|
420 |
CREATE UNIQUE INDEX TSB.PK_TEST_SCENARIOS ON TSB.TEST_SCENARIOS
|
|
|
421 |
(TESTSCENARIO_NO)
|
|
|
422 |
NOLOGGING
|
|
|
423 |
TABLESPACE AFC_INDX
|
|
|
424 |
PCTFREE 10
|
|
|
425 |
INITRANS 2
|
|
|
426 |
MAXTRANS 255
|
|
|
427 |
STORAGE (
|
|
|
428 |
INITIAL 64K
|
|
|
429 |
MINEXTENTS 1
|
|
|
430 |
MAXEXTENTS 2147483645
|
|
|
431 |
PCTINCREASE 0
|
|
|
432 |
BUFFER_POOL DEFAULT
|
|
|
433 |
)
|
|
|
434 |
NOPARALLEL;
|
|
|
435 |
|
|
|
436 |
|
|
|
437 |
CREATE UNIQUE INDEX TSB.PK_TRANSACTION_SPECIFICATION ON TSB.TRANSACTION_SPECIFICATION
|
|
|
438 |
(TXNSPEC_NO)
|
|
|
439 |
NOLOGGING
|
|
|
440 |
TABLESPACE AFC_INDX
|
|
|
441 |
PCTFREE 10
|
|
|
442 |
INITRANS 2
|
|
|
443 |
MAXTRANS 255
|
|
|
444 |
STORAGE (
|
|
|
445 |
INITIAL 64K
|
|
|
446 |
MINEXTENTS 1
|
|
|
447 |
MAXEXTENTS 2147483645
|
|
|
448 |
PCTINCREASE 0
|
|
|
449 |
BUFFER_POOL DEFAULT
|
|
|
450 |
)
|
|
|
451 |
NOPARALLEL;
|
|
|
452 |
|
|
|
453 |
|
|
|
454 |
|
|
|
455 |
|
|
|
456 |
|
|
|
457 |
CREATE UNIQUE INDEX TSB.PK_TXNSPEC_VALUES ON TSB.TXNSPEC_VALUES
|
|
|
458 |
(TXNSPEC_NO, XPATH)
|
|
|
459 |
NOLOGGING
|
|
|
460 |
TABLESPACE AFC_INDX
|
|
|
461 |
PCTFREE 10
|
|
|
462 |
INITRANS 2
|
|
|
463 |
MAXTRANS 255
|
|
|
464 |
STORAGE (
|
|
|
465 |
INITIAL 2M
|
|
|
466 |
MINEXTENTS 1
|
|
|
467 |
MAXEXTENTS 2147483645
|
|
|
468 |
PCTINCREASE 0
|
|
|
469 |
BUFFER_POOL DEFAULT
|
|
|
470 |
)
|
|
|
471 |
NOPARALLEL;
|
|
|
472 |
|
|
|
473 |
|
|
|
474 |
CREATE INDEX TSB.TXNSPEC_SCENARIO_VALUES ON TSB.TXNSPEC_VALUES
|
|
|
475 |
(TESTSCENARIO_NO)
|
|
|
476 |
NOLOGGING
|
|
|
477 |
TABLESPACE AFC_INDX
|
|
|
478 |
PCTFREE 10
|
|
|
479 |
INITRANS 2
|
|
|
480 |
MAXTRANS 255
|
|
|
481 |
STORAGE (
|
|
|
482 |
INITIAL 512K
|
|
|
483 |
MINEXTENTS 1
|
|
|
484 |
MAXEXTENTS 2147483645
|
|
|
485 |
PCTINCREASE 0
|
|
|
486 |
BUFFER_POOL DEFAULT
|
|
|
487 |
)
|
|
|
488 |
NOPARALLEL;
|
|
|
489 |
|
|
|
490 |
|
|
|
491 |
|
|
|
492 |
ALTER TABLE TSB.ITERATIONS ADD (
|
|
|
493 |
CONSTRAINT PK_ITERATIONS
|
|
|
494 |
PRIMARY KEY
|
|
|
495 |
(PROJECT_CODE, ITERATION)
|
|
|
496 |
USING INDEX
|
|
|
497 |
TABLESPACE AFC_INDX
|
|
|
498 |
PCTFREE 10
|
|
|
499 |
INITRANS 2
|
|
|
500 |
MAXTRANS 255
|
|
|
501 |
STORAGE (
|
|
|
502 |
INITIAL 64K
|
|
|
503 |
MINEXTENTS 1
|
|
|
504 |
MAXEXTENTS 2147483645
|
|
|
505 |
PCTINCREASE 0
|
|
|
506 |
));
|
|
|
507 |
|
|
|
508 |
|
|
|
509 |
ALTER TABLE TSB.ITERATION_PARAMS ADD (
|
|
|
510 |
CONSTRAINT U_ITERATION_PARAMS_49325
|
|
|
511 |
UNIQUE (ITERATION, TESTSCENARIO_NO, PROJECT_CODE, NAME)
|
|
|
512 |
USING INDEX
|
|
|
513 |
TABLESPACE AFC_INDX
|
|
|
514 |
PCTFREE 10
|
|
|
515 |
INITRANS 2
|
|
|
516 |
MAXTRANS 255
|
|
|
517 |
STORAGE (
|
|
|
518 |
INITIAL 64K
|
|
|
519 |
MINEXTENTS 1
|
|
|
520 |
MAXEXTENTS 2147483645
|
|
|
521 |
PCTINCREASE 0
|
|
|
522 |
));
|
|
|
523 |
|
|
|
524 |
|
|
|
525 |
ALTER TABLE TSB.MASS_TXNS ADD (
|
|
|
526 |
CHECK (enabled in ('Y','N')));
|
|
|
527 |
|
|
|
528 |
ALTER TABLE TSB.MASS_TXNS ADD (
|
|
|
529 |
CONSTRAINT PK_MASS_TXNS
|
|
|
530 |
PRIMARY KEY
|
|
|
531 |
(UDTYPE, UDSUBTYPE, PROJECTCODE, ITERATION)
|
|
|
532 |
USING INDEX
|
|
|
533 |
TABLESPACE AFC_INDX
|
|
|
534 |
PCTFREE 10
|
|
|
535 |
INITRANS 2
|
|
|
536 |
MAXTRANS 255
|
|
|
537 |
STORAGE (
|
|
|
538 |
INITIAL 64K
|
|
|
539 |
MINEXTENTS 1
|
|
|
540 |
MAXEXTENTS 2147483645
|
|
|
541 |
PCTINCREASE 0
|
|
|
542 |
));
|
|
|
543 |
|
|
|
544 |
|
|
|
545 |
ALTER TABLE TSB.PROJECTS ADD (
|
|
|
546 |
CONSTRAINT PROJECT_CODE_PK
|
|
|
547 |
PRIMARY KEY
|
|
|
548 |
(PROJECT_CODE)
|
|
|
549 |
USING INDEX
|
|
|
550 |
TABLESPACE AFC_INDX
|
|
|
551 |
PCTFREE 10
|
|
|
552 |
INITRANS 2
|
|
|
553 |
MAXTRANS 255
|
|
|
554 |
STORAGE (
|
|
|
555 |
INITIAL 64K
|
|
|
556 |
MINEXTENTS 1
|
|
|
557 |
MAXEXTENTS 2147483645
|
|
|
558 |
PCTINCREASE 0
|
|
|
559 |
));
|
|
|
560 |
|
|
|
561 |
|
|
|
562 |
ALTER TABLE TSB.SEQGEN ADD (
|
|
|
563 |
CONSTRAINT PK_SEQGEN
|
|
|
564 |
PRIMARY KEY
|
|
|
565 |
(PROJECT_CODE, ITERATION, SEQNAME)
|
|
|
566 |
USING INDEX
|
|
|
567 |
TABLESPACE AFC_INDX
|
|
|
568 |
PCTFREE 10
|
|
|
569 |
INITRANS 2
|
|
|
570 |
MAXTRANS 255
|
|
|
571 |
STORAGE (
|
|
|
572 |
INITIAL 64K
|
|
|
573 |
MINEXTENTS 1
|
|
|
574 |
MAXEXTENTS 2147483645
|
|
|
575 |
PCTINCREASE 0
|
|
|
576 |
));
|
|
|
577 |
|
|
|
578 |
|
|
|
579 |
ALTER TABLE TSB.TESTCASES ADD (
|
|
|
580 |
CONSTRAINT PK_TESTCASES
|
|
|
581 |
PRIMARY KEY
|
|
|
582 |
(TESTCASE_ID)
|
|
|
583 |
USING INDEX
|
|
|
584 |
TABLESPACE AFC_INDX
|
|
|
585 |
PCTFREE 10
|
|
|
586 |
INITRANS 2
|
|
|
587 |
MAXTRANS 255
|
|
|
588 |
STORAGE (
|
|
|
589 |
INITIAL 64K
|
|
|
590 |
MINEXTENTS 1
|
|
|
591 |
MAXEXTENTS 2147483645
|
|
|
592 |
PCTINCREASE 0
|
|
|
593 |
));
|
|
|
594 |
|
|
|
595 |
|
|
|
596 |
ALTER TABLE TSB.TEST_SCENARIOS ADD (
|
|
|
597 |
CONSTRAINT PK_TEST_SCENARIOS
|
|
|
598 |
PRIMARY KEY
|
|
|
599 |
(TESTSCENARIO_NO)
|
|
|
600 |
USING INDEX
|
|
|
601 |
TABLESPACE AFC_INDX
|
|
|
602 |
PCTFREE 10
|
|
|
603 |
INITRANS 2
|
|
|
604 |
MAXTRANS 255
|
|
|
605 |
STORAGE (
|
|
|
606 |
INITIAL 64K
|
|
|
607 |
MINEXTENTS 1
|
|
|
608 |
MAXEXTENTS 2147483645
|
|
|
609 |
PCTINCREASE 0
|
|
|
610 |
));
|
|
|
611 |
|
|
|
612 |
|
|
|
613 |
ALTER TABLE TSB.TRANSACTION_SPECIFICATION ADD (
|
|
|
614 |
CONSTRAINT PK_TRANSACTION_SPECIFICATION
|
|
|
615 |
PRIMARY KEY
|
|
|
616 |
(TXNSPEC_NO)
|
|
|
617 |
USING INDEX
|
|
|
618 |
TABLESPACE AFC_INDX
|
|
|
619 |
PCTFREE 10
|
|
|
620 |
INITRANS 2
|
|
|
621 |
MAXTRANS 255
|
|
|
622 |
STORAGE (
|
|
|
623 |
INITIAL 64K
|
|
|
624 |
MINEXTENTS 1
|
|
|
625 |
MAXEXTENTS 2147483645
|
|
|
626 |
PCTINCREASE 0
|
|
|
627 |
));
|
|
|
628 |
|
|
|
629 |
|
|
|
630 |
|
|
|
631 |
|
|
|
632 |
ALTER TABLE TSB.TXNSPEC_VALUES ADD (
|
|
|
633 |
CONSTRAINT PK_TXNSPEC_VALUES
|
|
|
634 |
PRIMARY KEY
|
|
|
635 |
(TXNSPEC_NO, XPATH)
|
|
|
636 |
USING INDEX
|
|
|
637 |
TABLESPACE AFC_INDX
|
|
|
638 |
PCTFREE 10
|
|
|
639 |
INITRANS 2
|
|
|
640 |
MAXTRANS 255
|
|
|
641 |
STORAGE (
|
|
|
642 |
INITIAL 2M
|
|
|
643 |
MINEXTENTS 1
|
|
|
644 |
MAXEXTENTS 2147483645
|
|
|
645 |
PCTINCREASE 0
|
|
|
646 |
));
|
|
|
647 |
|
|
|
648 |
|
|
|
649 |
ALTER TABLE TSB.ITERATIONS ADD (
|
|
|
650 |
CONSTRAINT R_ITERATIONS_36205
|
|
|
651 |
FOREIGN KEY (PROJECT_CODE)
|
|
|
652 |
REFERENCES TSB.PROJECTS (PROJECT_CODE));
|
|
|
653 |
|
|
|
654 |
|
|
|
655 |
ALTER TABLE TSB.ITERATION_PARAMS ADD (
|
|
|
656 |
CONSTRAINT R_ITERATION_PARAMS_36197
|
|
|
657 |
FOREIGN KEY (PROJECT_CODE, ITERATION)
|
|
|
658 |
REFERENCES TSB.ITERATIONS (PROJECT_CODE,ITERATION));
|
|
|
659 |
|
|
|
660 |
ALTER TABLE TSB.ITERATION_PARAMS ADD (
|
|
|
661 |
CONSTRAINT R_ITERATION_PARAMS_36198
|
|
|
662 |
FOREIGN KEY (TESTSCENARIO_NO)
|
|
|
663 |
REFERENCES TSB.TEST_SCENARIOS (TESTSCENARIO_NO));
|
|
|
664 |
|
|
|
665 |
|
|
|
666 |
ALTER TABLE TSB.MASS_TXNS ADD (
|
|
|
667 |
CONSTRAINT R_MASS_TXNS_36204
|
|
|
668 |
FOREIGN KEY (PROJECTCODE, ITERATION)
|
|
|
669 |
REFERENCES TSB.ITERATIONS (PROJECT_CODE,ITERATION));
|
|
|
670 |
|
|
|
671 |
|
|
|
672 |
ALTER TABLE TSB.SEQGEN ADD (
|
|
|
673 |
CONSTRAINT R_SEQGEN_36211
|
|
|
674 |
FOREIGN KEY (PROJECT_CODE, ITERATION)
|
|
|
675 |
REFERENCES TSB.ITERATIONS (PROJECT_CODE,ITERATION));
|
|
|
676 |
|
|
|
677 |
|
|
|
678 |
ALTER TABLE TSB.TEST_SCENARIOS ADD (
|
|
|
679 |
CONSTRAINT R_TEST_SCENARIOS_36202
|
|
|
680 |
FOREIGN KEY (TESTCASE_ID)
|
|
|
681 |
REFERENCES TSB.TESTCASES (TESTCASE_ID));
|
|
|
682 |
|
|
|
683 |
ALTER TABLE TSB.TEST_SCENARIOS ADD (
|
|
|
684 |
CONSTRAINT R_TEST_SCENARIOS_36203
|
|
|
685 |
FOREIGN KEY (PROJECT_CODE, ITERATION)
|
|
|
686 |
REFERENCES TSB.ITERATIONS (PROJECT_CODE,ITERATION));
|
|
|
687 |
|
|
|
688 |
|
|
|
689 |
ALTER TABLE TSB.TRANSACTION_SPECIFICATION ADD (
|
|
|
690 |
CONSTRAINT R_TRANSACTION_SPECIFICAT_24284
|
|
|
691 |
FOREIGN KEY (PROJECT_CODE, ITERATION)
|
|
|
692 |
REFERENCES TSB.ITERATIONS (PROJECT_CODE,ITERATION));
|
|
|
693 |
|
|
|
694 |
ALTER TABLE TSB.TRANSACTION_SPECIFICATION ADD (
|
|
|
695 |
CONSTRAINT R_TRANSACTION_SPECIFICAT_24283
|
|
|
696 |
FOREIGN KEY (TESTSCENARIO_NO)
|
|
|
697 |
REFERENCES TSB.TEST_SCENARIOS (TESTSCENARIO_NO));
|
|
|
698 |
|
|
|
699 |
ALTER TABLE TSB.TRANSACTION_SPECIFICATION ADD (
|
|
|
700 |
CONSTRAINT TRANS_SPEC_MASS_TXNS_C
|
|
|
701 |
FOREIGN KEY (UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION)
|
|
|
702 |
REFERENCES TSB.MASS_TXNS (UDTYPE,UDSUBTYPE,PROJECTCODE,ITERATION));
|
|
|
703 |
|
|
|
704 |
|
|
|
705 |
|
|
|
706 |
ALTER TABLE TSB.TXNSPEC_VALUES ADD (
|
|
|
707 |
CONSTRAINT R_TXNSPEC_VALUES_36201
|
|
|
708 |
FOREIGN KEY (PROJECT_CODE, ITERATION)
|
|
|
709 |
REFERENCES TSB.ITERATIONS (PROJECT_CODE,ITERATION));
|
|
|
710 |
|
|
|
711 |
ALTER TABLE TSB.TXNSPEC_VALUES ADD (
|
|
|
712 |
CONSTRAINT R_TXNSPEC_VALUES_36200
|
|
|
713 |
FOREIGN KEY (TESTSCENARIO_NO)
|
|
|
714 |
REFERENCES TSB.TEST_SCENARIOS (TESTSCENARIO_NO));
|
|
|
715 |
|
|
|
716 |
|
|
|
717 |
INSERT INTO TSB.PROJECTS ( PROJECT_CODE, NAME, TESTTEAM_CODE, ADDED ) VALUES (
|
|
|
718 |
'SLS', 'Stockholm', 'SLS', NULL);
|
|
|
719 |
COMMIT;
|
|
|
720 |
|
|
|
721 |
|
|
|
722 |
INSERT INTO TSB.ITERATIONS ( PROJECT_CODE, ITERATION, NOTES, TXNSTORAGE_PATH, USERNAME,
|
|
|
723 |
SCHEMA_VERSION ) VALUES (
|
|
|
724 |
'SLS', 25, NULL, NULL, 'kivins', '25.17.0.sls');
|
|
|
725 |
COMMIT;
|
|
|
726 |
|
|
|
727 |
|
|
|
728 |
|
|
|
729 |
|
|
|
730 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
731 |
ENABLED ) VALUES (
|
|
|
732 |
'SLS', 25, 4, 39, 'TxnOtherPaymentJourney_t', 'This transaction is sent from a device when a journey is taken, and the related ticket is issued based on something other than a product (ie: a cash ticket, a free ticket from a loyalty meter).'
|
|
|
733 |
, 'N');
|
|
|
734 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
735 |
ENABLED ) VALUES (
|
|
|
736 |
'SLS', 25, 4, 42, 'TxnOtherPayment_t', 'This UD should be used when payments are made for things which are not transit related ie purchasing a newspaper from a retailer, paying rent etc.'
|
|
|
737 |
, 'N');
|
|
|
738 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
739 |
ENABLED ) VALUES (
|
|
|
740 |
'SLS', 25, 4, 33, 'TxnOtherSettleClaim_t', 'This transaction prompts that the claim is approved and is to be settled.'
|
|
|
741 |
, 'N');
|
|
|
742 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
743 |
ENABLED ) VALUES (
|
|
|
744 |
'SLS', 25, 4, 45, 'TxnOtherSettleLumpSumPayment_t', 'Used in Delayed Settlement to prompt the Financial System to settle the lump sum from product usage from the CCH to the operator'
|
|
|
745 |
, 'N');
|
|
|
746 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
747 |
ENABLED ) VALUES (
|
|
|
748 |
'SLS', 25, 4, 46, 'TxnOtherSettleLumpSumRevenue_t', 'Used in Delayed Settlement to prompt the Financial System to settle the lump sum from product sales from the operator to the CCH'
|
|
|
749 |
, 'N');
|
|
|
750 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
751 |
ENABLED ) VALUES (
|
|
|
752 |
'SLS', 25, 4, 27, 'TxnPaymentDetails_t', 'This transaction contains EFT and other payment details that may need to be recorded by a device under some circumstances. Normally this transaction would only be produced if the information it stores is to be recorded and the payment method used for the accompanying txn is EFT or cheque.'
|
|
|
753 |
, 'N');
|
|
|
754 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
755 |
ENABLED ) VALUES (
|
|
|
756 |
'SLS', 25, 3, 58, 'TxnProductAccountManualOperation_t', NULL, 'N');
|
|
|
757 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
758 |
ENABLED ) VALUES (
|
|
|
759 |
'SLS', 25, 3, 38, 'TxnProductAccountPurge_t', 'Created to purge a product account.'
|
|
|
760 |
, 'N');
|
|
|
761 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
762 |
ENABLED ) VALUES (
|
|
|
763 |
'SLS', 25, 3, 48, 'TxnProductActionlistedUsageDetected_t', 'Created when the usage of an actionlisted product has been detected. This transaction is only generated by the back office actionlist management system. The transaction is generated when a usage transaction is generated by a device for an account that has been actionlisted by the back office and should really be blocked rather than allowed to be used. This can happen when the actionlist size is too big and not all actionlist entries make it down to the devices. The Usage Detected transaction is generated (OLS) and processed (OFS) in the back office as the back office is aware of the actionlisting state of each account. After the transaction is processed by the actionlisting system at the OFS, the actionlist entry gets a higher priority so there is a better chance to block the account the next time a card is presented at a device with the updated actionlist.'
|
|
|
764 |
, 'N');
|
|
|
765 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
766 |
ENABLED ) VALUES (
|
|
|
767 |
'SLS', 25, 3, 78, 'TxnProductActionlistFailure_t', 'Generated by a device when an action item in a Product actionlist cannot be processed for some reason.'
|
|
|
768 |
, 'N');
|
|
|
769 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
770 |
ENABLED ) VALUES (
|
|
|
771 |
'SLS', 25, 3, 82, 'TxnProductActionlistRequest_t', 'Generate by any component in the system to request actionlisting on a product. In response to this transaction, the actionlist manager will generate the appropriate actionlisting transaction.'
|
|
|
772 |
, 'N');
|
|
|
773 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
774 |
ENABLED ) VALUES (
|
|
|
775 |
'SLS', 25, 3, 42, 'TxnProductActionlist_t', 'Created to actionlist a product', 'N');
|
|
|
776 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
777 |
ENABLED ) VALUES (
|
|
|
778 |
'SLS', 25, 3, 51, 'TxnProductAutoloadDisable_t', 'Generated when an autoload facility on a card is disabled.'
|
|
|
779 |
, 'N');
|
|
|
780 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
781 |
ENABLED ) VALUES (
|
|
|
782 |
'SLS', 25, 3, 9, 'TxnProductAutoloadEnable_t', 'Created by a Card device when an Autoload facility on a Card is enabled for use by the Cardholder. The facility will be enabled following the initialisation of an autoload facility or when the autoload facility is being re-enabled following disablement due to bad debt (or other) reasons.'
|
|
|
783 |
, 'N');
|
|
|
784 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
785 |
ENABLED ) VALUES (
|
|
|
786 |
'SLS', 25, 3, 67, 'TxnProductAutoloadSettlement_t', 'Created by the Autoload Funds Manager on receipt of an add value transaction - with method of payment autoload or remote add - and posted to the product issuer.'
|
|
|
787 |
, 'N');
|
|
|
788 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
789 |
ENABLED ) VALUES (
|
|
|
790 |
'SLS', 25, 3, 70, 'TxnProductAutoloadUpdate_t', 'Created by a Card device when an autoload facility has been created (but not enabled) or updated on a Card'
|
|
|
791 |
, 'N');
|
|
|
792 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
793 |
ENABLED ) VALUES (
|
|
|
794 |
'SLS', 25, 3, 5, 'TxnProductBlock_t', 'Created when a Card Device blocks a Product from usage. Blocking may be as a result of a hotlisting match or other validity rule process failures such as excessive purse value.'
|
|
|
795 |
, 'N');
|
|
|
796 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
797 |
ENABLED ) VALUES (
|
|
|
798 |
'SLS', 25, 3, 76, 'TxnProductCurrencyChanged_t', 'Created by a card device when the currency of a multiride or pass product has changed.'
|
|
|
799 |
, 'N');
|
|
|
800 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
801 |
ENABLED ) VALUES (
|
|
|
802 |
'SLS', 25, 3, 4, 'TxnProductDelete_t', 'Created by a Card Device when it has removed a Product from a Card.'
|
|
|
803 |
, 'N');
|
|
|
804 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
805 |
ENABLED ) VALUES (
|
|
|
806 |
'SLS', 25, 3, 34, 'TxnProductDepositReceipt_t', 'Created by a Card Device when a cardholder pays a deposit for a product.'
|
|
|
807 |
, 'N');
|
|
|
808 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
809 |
ENABLED ) VALUES (
|
|
|
810 |
'SLS', 25, 3, 35, 'TxnProductDepositRefund_t', 'Created by a Card Device when a refund of a product deposit is made'
|
|
|
811 |
, 'N');
|
|
|
812 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
813 |
ENABLED ) VALUES (
|
|
|
814 |
'SLS', 25, 3, 96, 'TxnProductIssuerManualAdjust_t', NULL, 'N');
|
|
|
815 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
816 |
ENABLED ) VALUES (
|
|
|
817 |
'SLS', 25, 3, 7, 'TxnProductKeysUpdate_t', 'Created by a Card Device when it has upgraded the Security Keys on a Product to a later revision or at time of issue of product.'
|
|
|
818 |
, 'N');
|
|
|
819 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
820 |
ENABLED ) VALUES (
|
|
|
821 |
'SLS', 25, 3, 41, 'TxnProductMultirideAddRecover_t', 'Created to recover add value funds from a missing pass add transaction.'
|
|
|
822 |
, 'N');
|
|
|
823 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
824 |
ENABLED ) VALUES (
|
|
|
825 |
'SLS', 25, 3, 18, 'TxnProductMultirideAddReverse_t', 'Created by a Card Device when an add value to a pass product is reversed.'
|
|
|
826 |
, 'N');
|
|
|
827 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
828 |
ENABLED ) VALUES (
|
|
|
829 |
'SLS', 25, 3, 12, 'TxnProductMultirideAdd_t', 'Created by a Card Device when it receives payment and adds that value to a multiride product.'
|
|
|
830 |
, 'N');
|
|
|
831 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
832 |
ENABLED ) VALUES (
|
|
|
833 |
'SLS', 25, 3, 79, 'TxnProductMultirideIssueReverse_t', 'Indicates that the Multiride Product Issue action has been reversed.'
|
|
|
834 |
, 'N');
|
|
|
835 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
836 |
ENABLED ) VALUES (
|
|
|
837 |
'SLS', 25, 3, 3, 'TxnProductMultirideIssue_t', 'Created upon a successful issue of a multiride product'
|
|
|
838 |
, 'N');
|
|
|
839 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
840 |
ENABLED ) VALUES (
|
|
|
841 |
'SLS', 25, 3, 110, 'TxnProductMultiridePurchaseRemoteReverse_t', 'Created by a back office function (eg. agency website) when a remote purchase of a multiride is reversed.'
|
|
|
842 |
, 'N');
|
|
|
843 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
844 |
ENABLED ) VALUES (
|
|
|
845 |
'SLS', 25, 3, 111, 'TxnProductMultiridePurchaseRemote_t', 'Created by a back office function (eg. website) when a remote purchase of a multiride is made for subsequent loading to a card when it is presented at a device'
|
|
|
846 |
, 'N');
|
|
|
847 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
848 |
ENABLED ) VALUES (
|
|
|
849 |
'SLS', 25, 3, 95, 'TxnProductMultirideRebateOnExit_t', NULL, 'N');
|
|
|
850 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
851 |
ENABLED ) VALUES (
|
|
|
852 |
'SLS', 25, 3, 74, 'TxnProductMultirideRefundAccountBased_t', 'Created by a product issuers back-office function at the time a deferred full or partial refund of the remaining value on a multiride product is made to the cardholder from the product issuers back-office function as opposed to directly to the cardholder in person.'
|
|
|
853 |
, 'N');
|
|
|
854 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
855 |
ENABLED ) VALUES (
|
|
|
856 |
'SLS', 25, 3, 28, 'TxnProductMultirideRefund_t', 'Created by a Card Device when it performs a refund on a multiride product. This transaction will be generated at the time a Cardholder hands over a working Card.'
|
|
|
857 |
, 'N');
|
|
|
858 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
859 |
ENABLED ) VALUES (
|
|
|
860 |
'SLS', 25, 3, 63, 'TxnProductMultirideReplace_t', 'Created by a Card Device when it moves a multiride product from one Card to another.'
|
|
|
861 |
, 'N');
|
|
|
862 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
863 |
ENABLED ) VALUES (
|
|
|
864 |
'SLS', 25, 3, 99, 'TxnProductMultirideUseJourneyReverse_t', NULL, 'N');
|
|
|
865 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
866 |
ENABLED ) VALUES (
|
|
|
867 |
'SLS', 25, 3, 86, 'TxnProductMultirideUseJourney_t', 'Transaction recording a journey made using a multiride product.'
|
|
|
868 |
, 'N');
|
|
|
869 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
870 |
ENABLED ) VALUES (
|
|
|
871 |
'SLS', 25, 3, 97, 'TxnProductMultirideUseOnEntryReverse_t', NULL, 'N');
|
|
|
872 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
873 |
ENABLED ) VALUES (
|
|
|
874 |
'SLS', 25, 3, 90, 'TxnProductMultirideUseOnEntry_t', 'Transaction recording a journey made using a multiride product where the journey is paid for on entry to the system. This transaction is intented for use in a two-tag system.'
|
|
|
875 |
, 'N');
|
|
|
876 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
877 |
ENABLED ) VALUES (
|
|
|
878 |
'SLS', 25, 3, 98, 'TxnProductMultirideUseOnExitReverse_t', NULL, 'N');
|
|
|
879 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
880 |
ENABLED ) VALUES (
|
|
|
881 |
'SLS', 25, 3, 93, 'TxnProductMultirideUseOnExit_t', 'Transaction recording a journey made using a multiride product where the journey is paid for on exit from the system. This transaction is intented for use in a two-tag system.'
|
|
|
882 |
, 'N');
|
|
|
883 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
884 |
ENABLED ) VALUES (
|
|
|
885 |
'SLS', 25, 3, 40, 'TxnProductPassAddRecover_t', 'Created to recover add value funds from a missing pass add transaction.'
|
|
|
886 |
, 'N');
|
|
|
887 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
888 |
ENABLED ) VALUES (
|
|
|
889 |
'SLS', 25, 3, 17, 'TxnProductPassAddReverse_t', 'Created by a Card Device when an add value to a pass product is reversed.'
|
|
|
890 |
, 'N');
|
|
|
891 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
892 |
ENABLED ) VALUES (
|
|
|
893 |
'SLS', 25, 3, 11, 'TxnProductPassAdd_t', 'Created by a Card Device when it receives payment and adds that value to a pass product.'
|
|
|
894 |
, 'N');
|
|
|
895 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
896 |
ENABLED ) VALUES (
|
|
|
897 |
'SLS', 25, 3, 80, 'TxnProductPassIssueReverse_t', 'Indicates that the Pass Product Issue action has been reversed.'
|
|
|
898 |
, 'N');
|
|
|
899 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
900 |
ENABLED ) VALUES (
|
|
|
901 |
'SLS', 25, 3, 2, 'TxnProductPassIssue_t', 'Created upon a successful issue of a pass product'
|
|
|
902 |
, 'Y');
|
|
|
903 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
904 |
ENABLED ) VALUES (
|
|
|
905 |
'SLS', 25, 3, 108, 'TxnProductPassPurchaseRemoteReverse_t', 'Created by a back office function (eg. agency website) when a remote purchase of a pass is reversed.'
|
|
|
906 |
, 'N');
|
|
|
907 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
908 |
ENABLED ) VALUES (
|
|
|
909 |
'SLS', 25, 3, 109, 'TxnProductPassPurchaseRemote_t', 'Created by a back office function (eg. website) when a remote purchase of a pass is made for subsequent loading to a card when it is presented at a device.'
|
|
|
910 |
, 'N');
|
|
|
911 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
912 |
ENABLED ) VALUES (
|
|
|
913 |
'SLS', 25, 3, 75, 'TxnProductPassRefundAccountBased_t', 'Created by a product issuers back-office function at the time a deferred full or partial refund of the remaining value on a pass product is made to the cardholder from the product issuers back-office function as opposed to directly to the cardholder in person.'
|
|
|
914 |
, 'N');
|
|
|
915 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
916 |
ENABLED ) VALUES (
|
|
|
917 |
'SLS', 25, 3, 27, 'TxnProductPassRefund_t', 'Created by a Card Device when it performs a refund on a pass product. This transaction will be generated at the time a Cardholder hands over a working Card.'
|
|
|
918 |
, 'N');
|
|
|
919 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
920 |
ENABLED ) VALUES (
|
|
|
921 |
'SLS', 25, 3, 64, 'TxnProductPassReplace_t', 'Created by a Card Device when it moves a pass product from one Card to another.'
|
|
|
922 |
, 'N');
|
|
|
923 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
924 |
ENABLED ) VALUES (
|
|
|
925 |
'SLS', 25, 3, 103, 'TxnProductPassUseJourneyReverse_t', NULL, 'N');
|
|
|
926 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
927 |
ENABLED ) VALUES (
|
|
|
928 |
'SLS', 25, 3, 85, 'TxnProductPassUseJourney_t', 'Transaction recording a journey made using a pass product.'
|
|
|
929 |
, 'Y');
|
|
|
930 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
931 |
ENABLED ) VALUES (
|
|
|
932 |
'SLS', 25, 3, 104, 'TxnProductPassUseOnEntryReverse_t', NULL, 'N');
|
|
|
933 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
934 |
ENABLED ) VALUES (
|
|
|
935 |
'SLS', 25, 3, 89, 'TxnProductPassUseOnEntry_t', 'Transaction recording a journey made using a pass product where the product is paid for on entry to the system. This transaction is intented for use in a two-tag system.'
|
|
|
936 |
, 'N');
|
|
|
937 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
938 |
ENABLED ) VALUES (
|
|
|
939 |
'SLS', 25, 3, 105, 'TxnProductPassUseOnExitReverse_t', NULL, 'N');
|
|
|
940 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
941 |
ENABLED ) VALUES (
|
|
|
942 |
'SLS', 25, 3, 92, 'TxnProductPassUseOnExit_t', 'Transaction recording a journey made using a pass product where the product is paid for on exit from the system. This transaction is intented for use in a two-tag system.'
|
|
|
943 |
, 'N');
|
|
|
944 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
945 |
ENABLED ) VALUES (
|
|
|
946 |
'SLS', 25, 3, 39, 'TxnProductPurseAddRecover_t', 'Created to recover add value funds from a missing purse add value transaction.'
|
|
|
947 |
, 'N');
|
|
|
948 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
949 |
ENABLED ) VALUES (
|
|
|
950 |
'SLS', 25, 3, 106, 'TxnProductPurseAddRemoteReverse_t', 'Created by a back office function (eg. agency website) when a remote purchase of purse value is reversed.'
|
|
|
951 |
, 'N');
|
|
|
952 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
953 |
ENABLED ) VALUES (
|
|
|
954 |
'SLS', 25, 3, 107, 'TxnProductPurseAddRemote_t', 'Created by a back office function (eg. website) when a remote purchase of purse value is made for subsequent loading to a card when it is presented at a device.'
|
|
|
955 |
, 'N');
|
|
|
956 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
957 |
ENABLED ) VALUES (
|
|
|
958 |
'SLS', 25, 3, 16, 'TxnProductPurseAddReverse_t', 'Created by a Card Device when an add value to a purse product is reversed.'
|
|
|
959 |
, 'N');
|
|
|
960 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
961 |
ENABLED ) VALUES (
|
|
|
962 |
'SLS', 25, 3, 10, 'TxnProductPurseAdd_t', 'Created by a Card Device when it receives payment and adds that value to a purse product.'
|
|
|
963 |
, 'N');
|
|
|
964 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
965 |
ENABLED ) VALUES (
|
|
|
966 |
'SLS', 25, 3, 77, 'TxnProductPurseCurrencyChanged_t', 'Created by a card device when the currency of a purse product has changed.'
|
|
|
967 |
, 'N');
|
|
|
968 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
969 |
ENABLED ) VALUES (
|
|
|
970 |
'SLS', 25, 3, 81, 'TxnProductPurseIssueReverse_t', 'Indicates that the Purse Product Issue action has been reversed.'
|
|
|
971 |
, 'N');
|
|
|
972 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
973 |
ENABLED ) VALUES (
|
|
|
974 |
'SLS', 25, 3, 1, 'TxnProductPurseIssue_t', 'Created upon a successful issue of a purse product'
|
|
|
975 |
, 'N');
|
|
|
976 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
977 |
ENABLED ) VALUES (
|
|
|
978 |
'SLS', 25, 3, 87, 'TxnProductPurseRebateOnExit_t', 'Created by a Card Device when it rebates the difference between the charged fare on entry with the calculated fare on exit'
|
|
|
979 |
, 'N');
|
|
|
980 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
981 |
ENABLED ) VALUES (
|
|
|
982 |
'SLS', 25, 3, 73, 'TxnProductPurseRefundAccountBased_t', 'Created by a product issuer''s back-office function at the time a deferred full or partial refund of the remaining value on a purse product is made to the cardholder from the product issuer''s back-office function as opposed to directly to the cardholder in person.'
|
|
|
983 |
, 'N');
|
|
|
984 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
985 |
ENABLED ) VALUES (
|
|
|
986 |
'SLS', 25, 3, 26, 'TxnProductPurseRefund_t', 'Created by a Card Device when it performs a refund on a purse product. This transaction will be generated at the time a Cardholder hands over a working Card.'
|
|
|
987 |
, 'N');
|
|
|
988 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
989 |
ENABLED ) VALUES (
|
|
|
990 |
'SLS', 25, 3, 62, 'TxnProductPurseReplace_t', 'Created by a Card Device when it moves a purse product from one Card to another.'
|
|
|
991 |
, 'N');
|
|
|
992 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
993 |
ENABLED ) VALUES (
|
|
|
994 |
'SLS', 25, 3, 100, 'TxnProductPurseUseJourneyReverse_t', NULL, 'N');
|
|
|
995 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
996 |
ENABLED ) VALUES (
|
|
|
997 |
'SLS', 25, 3, 84, 'TxnProductPurseUseJourney_t', 'Transaction recording a journey made using a purse product.'
|
|
|
998 |
, 'N');
|
|
|
999 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1000 |
ENABLED ) VALUES (
|
|
|
1001 |
'SLS', 25, 3, 102, 'TxnProductPurseUseOnEntryReverse_t', NULL, 'N');
|
|
|
1002 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1003 |
ENABLED ) VALUES (
|
|
|
1004 |
'SLS', 25, 3, 88, 'TxnProductPurseUseOnEntry_t', 'Transaction recording a journey made using a purse product where the product is paid for on entry to the system. This transaction is intented for use in a two-tag system.'
|
|
|
1005 |
, 'N');
|
|
|
1006 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1007 |
ENABLED ) VALUES (
|
|
|
1008 |
'SLS', 25, 3, 101, 'TxnProductPurseUseOnExitReverse_t', NULL, 'N');
|
|
|
1009 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1010 |
ENABLED ) VALUES (
|
|
|
1011 |
'SLS', 25, 3, 91, 'TxnProductPurseUseOnExit_t', 'Transaction recording a journey made using a purse product where the product is paid for on exit from the system. This transaction is intented for use in a two-tag system.'
|
|
|
1012 |
, 'N');
|
|
|
1013 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1014 |
ENABLED ) VALUES (
|
|
|
1015 |
'SLS', 25, 3, 19, 'TxnProductPurseUseReverse_t', 'Created by a Card Device when it cancels the current fare on a product and re-credits it back to a purse product. This will typically occur in the instance of a Cardholder boarding the wrong bus, their Card having been processed by a Bus Entry Processor and a fare being deducted from the Purse.'
|
|
|
1016 |
, 'N');
|
|
|
1017 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1018 |
ENABLED ) VALUES (
|
|
|
1019 |
'SLS', 25, 3, 13, 'TxnProductPurseUse_t', 'Created by a Card Device when it uses Purse Product to pay a fare.'
|
|
|
1020 |
, 'N');
|
|
|
1021 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1022 |
ENABLED ) VALUES (
|
|
|
1023 |
'SLS', 25, 3, 29, 'TxnProductRefundDeferred_t', 'Created by a Card Device at the time a Cardholder surrenders a Monetary Card Purse (in an attempt to obtain a refund) but that Card Purse is either damaged or has performed a recent AutoTop-Up. The true value on the Card can not be accurately determined at the time of surrender. The Card Purse will be the subject of a deferred refund.'
|
|
|
1024 |
, 'N');
|
|
|
1025 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1026 |
ENABLED ) VALUES (
|
|
|
1027 |
'SLS', 25, 3, 72, 'TxnProductRefundRequestAccountBased_t', 'Created by an application provider''s back-office function at the time a request is received to refund - after a set period of time - the value of a product.'
|
|
|
1028 |
, 'N');
|
|
|
1029 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1030 |
ENABLED ) VALUES (
|
|
|
1031 |
'SLS', 25, 3, 56, 'TxnProductRemainingValueDiscrepancy_t', 'Created by product management to indicate that the product remaining value reported by a device was different from that calculated by the issuer.'
|
|
|
1032 |
, 'N');
|
|
|
1033 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1034 |
ENABLED ) VALUES (
|
|
|
1035 |
'SLS', 25, 3, 94, 'TxnProductSurchargeRebateOnExit_t', 'Created by a Card Device when it rebates the difference between the charged surcharge (not fare) on entry with the calculated surcharge on exit.'
|
|
|
1036 |
, 'N');
|
|
|
1037 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1038 |
ENABLED ) VALUES (
|
|
|
1039 |
'SLS', 25, 3, 25, 'TxnProductSurcharge_t', 'Created by a Card Device when it uses a Purse product for the purposes of paying (in full or in part) for a Card surcharge (or penalty fee) that is being applied by an inspector, for example, over-riding in the rail or bus network.'
|
|
|
1040 |
, 'N');
|
|
|
1041 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1042 |
ENABLED ) VALUES (
|
|
|
1043 |
'SLS', 25, 3, 31, 'TxnProductTollingUpdate_t', 'Created by a Card when tolling product details are changed.'
|
|
|
1044 |
, 'N');
|
|
|
1045 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1046 |
ENABLED ) VALUES (
|
|
|
1047 |
'SLS', 25, 3, 83, 'TxnProductUnactionlistRequest_t', 'Generate by any component in the system to request un-actionlisting on a product. In response to this transaction, the actionlist manager will generate the appropriate actionlisting transaction.'
|
|
|
1048 |
, 'N');
|
|
|
1049 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1050 |
ENABLED ) VALUES (
|
|
|
1051 |
'SLS', 25, 3, 43, 'TxnProductUnactionlist_t', 'Created to unactionlist a product'
|
|
|
1052 |
, 'N');
|
|
|
1053 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1054 |
ENABLED ) VALUES (
|
|
|
1055 |
'SLS', 25, 3, 6, 'TxnProductUnblock_t', 'Created when a Card Device unblocks a previously blocked product.'
|
|
|
1056 |
, 'N');
|
|
|
1057 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1058 |
ENABLED ) VALUES (
|
|
|
1059 |
'SLS', 25, 3, 71, 'TxnProductValueWriteOffNeg_t', 'Created to write-off the value of missing purse or multiride product transactions - used for negative write offs.'
|
|
|
1060 |
, 'N');
|
|
|
1061 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1062 |
ENABLED ) VALUES (
|
|
|
1063 |
'SLS', 25, 3, 37, 'TxnProductValueWriteOffPos_t', 'Created to write-off the value of missing purse or multiride product transactions. Used for positive write offs.'
|
|
|
1064 |
, 'N');
|
|
|
1065 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1066 |
ENABLED ) VALUES (
|
|
|
1067 |
'SLS', 25, 4, 8, 'TxnSamActionlistUpdate_t', 'Created when a new device actionlist is generated. Max number of entries in this list is 300.'
|
|
|
1068 |
, 'N');
|
|
|
1069 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1070 |
ENABLED ) VALUES (
|
|
|
1071 |
'SLS', 25, 4, 22, 'TxnShiftEnd_t', 'Produced when an operator ends a shift on a device. Produced by DAF''s OAR component on behalf of the device. When an OpAp card is not used, sysCardCom_t and sysApplicationCom_t are not populated'
|
|
|
1072 |
, 'N');
|
|
|
1073 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1074 |
ENABLED ) VALUES (
|
|
|
1075 |
'SLS', 25, 4, 17, 'TxnShiftRead_t', 'Produced when operator shift data is read from an OpAp card. If multiple shift data are read from OpAp, each will result in one of these messages. Each set of these will usually be combined with one TxnOperatorCashDepositUpdate_t for the cash received as part of the transaction. Produced by the OAR DAF component on behalf of the device.'
|
|
|
1076 |
, 'N');
|
|
|
1077 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1078 |
ENABLED ) VALUES (
|
|
|
1079 |
'SLS', 25, 4, 21, 'TxnShiftStart_t', 'Produced when an operator begins a shift on a device. Produced by DAF''s OAR component on behalf of the device. When no OpAp card is presented, SysCardCom_t and SysApplicationCom_t are not populated.'
|
|
|
1080 |
, 'N');
|
|
|
1081 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1082 |
ENABLED ) VALUES (
|
|
|
1083 |
'SLS', 25, 7, 22, 'TxnSlsEntryExitPeriodData_t', 'Generated by Entry/Exit barrier devices (i.e. gates) to report passenger flow counts for a time period.'
|
|
|
1084 |
, 'N');
|
|
|
1085 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1086 |
ENABLED ) VALUES (
|
|
|
1087 |
'SLS', 25, 7, 23, 'TxnSlsProductPassActivate_t', 'Created upon a successful activation of a dormant product. The main consumer of this information is accrual accounting.'
|
|
|
1088 |
, 'N');
|
|
|
1089 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1090 |
ENABLED ) VALUES (
|
|
|
1091 |
'SLS', 25, 4, 24, 'TxnTripEnd_t', 'Created when a trip is ended and no operator application is in use. When an operator application is in use, other transactions may be generated.'
|
|
|
1092 |
, 'N');
|
|
|
1093 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1094 |
ENABLED ) VALUES (
|
|
|
1095 |
'SLS', 25, 4, 23, 'TxnTripStart_t', 'Created when a trip is started (usually on a bus) and no operator application is in use. When an operator application is in use, other transactions may be generated.'
|
|
|
1096 |
, 'N');
|
|
|
1097 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1098 |
ENABLED ) VALUES (
|
|
|
1099 |
'SLS', 25, 2, 8, 'TxnApplicationAccountCloseOff_t', 'Close off an application account.'
|
|
|
1100 |
, 'N');
|
|
|
1101 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1102 |
ENABLED ) VALUES (
|
|
|
1103 |
'SLS', 25, 2, 21, 'TxnApplicationAccountManualOperation_t', NULL, 'N');
|
|
|
1104 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1105 |
ENABLED ) VALUES (
|
|
|
1106 |
'SLS', 25, 2, 9, 'TxnApplicationAccountPurge_t', 'Purge an application account', 'N');
|
|
|
1107 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1108 |
ENABLED ) VALUES (
|
|
|
1109 |
'SLS', 25, 2, 14, 'TxnApplicationActionlistedUsageDetected_t', 'Created when the usage of an actionlisted application has been detected. This transaction is only generated by the back office actionlist management system. The transaction is generated when a usage transaction is generated by a device for an account that has been actionlisted by the back office and should really be blocked rather than allowed to be used. This can happen when the actionlist size is too big and not all actionlist entries make it down to the devices. The Usage Detected transaction is generated (OLS) and processed (OFS) in the back office as the back office is aware of the actionlisting state of each account. After the transaction is processed by the actionlisting system at the OFS, the actionlist entry gets a higher priority so there is a better chance to block the account the next time a card is presented at a device with the updated actionlist.'
|
|
|
1110 |
, 'N');
|
|
|
1111 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1112 |
ENABLED ) VALUES (
|
|
|
1113 |
'SLS', 25, 2, 23, 'TxnApplicationActionlistFailure_t', 'Generated by a device when an action item in an Application actionlist cannot be processed for some reason.'
|
|
|
1114 |
, 'N');
|
|
|
1115 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1116 |
ENABLED ) VALUES (
|
|
|
1117 |
'SLS', 25, 2, 25, 'TxnApplicationActionlistRequest_t', 'Generate by any component in the system to request actionlisting on an application. In response to this transaction, the actionlist manager will generate the appropriate actionlisting transaction.'
|
|
|
1118 |
, 'N');
|
|
|
1119 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1120 |
ENABLED ) VALUES (
|
|
|
1121 |
'SLS', 25, 2, 12, 'TxnApplicationActionlist_t', 'Created to actionlist an application. This transaction is also used to notify product issuers of the products contained in a particular application that their parent application is actionlisted.'
|
|
|
1122 |
, 'N');
|
|
|
1123 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1124 |
ENABLED ) VALUES (
|
|
|
1125 |
'SLS', 25, 2, 3, 'TxnApplicationBlock_t', 'Created when a Card Device blocks an application from usage. This may be as a result of a hotlisting match or other validity rule process failures.'
|
|
|
1126 |
, 'N');
|
|
|
1127 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1128 |
ENABLED ) VALUES (
|
|
|
1129 |
'SLS', 25, 2, 24, 'TxnApplicationCreateReverse_t', 'Indicates that the Application Create action has been reversed.'
|
|
|
1130 |
, 'N');
|
|
|
1131 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1132 |
ENABLED ) VALUES (
|
|
|
1133 |
'SLS', 25, 2, 1, 'TxnApplicationCreate_t', 'Created upon a successful issue of an Application.'
|
|
|
1134 |
, 'N');
|
|
|
1135 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1136 |
ENABLED ) VALUES (
|
|
|
1137 |
'SLS', 25, 2, 2, 'TxnApplicationDelete_t', 'Created by a Card Device when it has removed an application from a Card'
|
|
|
1138 |
, 'N');
|
|
|
1139 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1140 |
ENABLED ) VALUES (
|
|
|
1141 |
'SLS', 25, 2, 5, 'TxnApplicationKeysUpdate_t', 'Created by a Card Device when it has upgraded the Security Keys on a Application to a later revision. This transaction is also generated when the keys are initially installed.'
|
|
|
1142 |
, 'N');
|
|
|
1143 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1144 |
ENABLED ) VALUES (
|
|
|
1145 |
'SLS', 25, 2, 17, 'TxnApplicationOperatorRoleAdd_t', 'Indicates that a role was added to an Operator application. If multiple roles are added to a particular operator application, this txn must be generated once for each role added.'
|
|
|
1146 |
, 'N');
|
|
|
1147 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1148 |
ENABLED ) VALUES (
|
|
|
1149 |
'SLS', 25, 2, 18, 'TxnApplicationOperatorRoleDelete_t', 'Indicates that a role was deleted from an Operator application. If multiple roles are deleted from a particular operator application, this txn must be generated once for each role deleted.'
|
|
|
1150 |
, 'N');
|
|
|
1151 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1152 |
ENABLED ) VALUES (
|
|
|
1153 |
'SLS', 25, 2, 19, 'TxnApplicationPassengerTypeChange_t', 'Indicates that the passenger type on an application changed. This is based on the assumption that all products on the application always have the same class. If this is not true, this transaction shouldn''t be used.'
|
|
|
1154 |
, 'N');
|
|
|
1155 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1156 |
ENABLED ) VALUES (
|
|
|
1157 |
'SLS', 25, 2, 16, 'TxnApplicationPersonaliseUpdate_t', 'Created when the personalisation details associated with an application are updated.'
|
|
|
1158 |
, 'N');
|
|
|
1159 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1160 |
ENABLED ) VALUES (
|
|
|
1161 |
'SLS', 25, 2, 15, 'TxnApplicationPersonalise_t', 'Created upon a successful Personalisation of an application'
|
|
|
1162 |
, 'N');
|
|
|
1163 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1164 |
ENABLED ) VALUES (
|
|
|
1165 |
'SLS', 25, 2, 22, 'TxnApplicationRefundRequestAccountBased_t', 'Created by a card issuer''s back office function at the time a request is received to refund - after a waiting a set period of time - the value of all products on an application.'
|
|
|
1166 |
, 'N');
|
|
|
1167 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1168 |
ENABLED ) VALUES (
|
|
|
1169 |
'SLS', 25, 2, 7, 'TxnApplicationReplace_t', 'Created when replacing a transaction.'
|
|
|
1170 |
, 'N');
|
|
|
1171 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1172 |
ENABLED ) VALUES (
|
|
|
1173 |
'SLS', 25, 2, 26, 'TxnApplicationUnactionlistRequest_t', 'Generate by any component in the system to request un-actionlisting on an application. In response to this transaction, the actionlist manager will generate the appropriate actionlisting transaction.'
|
|
|
1174 |
, 'N');
|
|
|
1175 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1176 |
ENABLED ) VALUES (
|
|
|
1177 |
'SLS', 25, 2, 13, 'TxnApplicationUnactionlist_t', 'Created to unactionlist an application. This transaction is also used to notify product issuers of the products contained in a particular application that their parent application is actionlisted.'
|
|
|
1178 |
, 'N');
|
|
|
1179 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1180 |
ENABLED ) VALUES (
|
|
|
1181 |
'SLS', 25, 2, 4, 'TxnApplicationUnblock_t', 'Created when a Card Device unblocks a previously blocked application.'
|
|
|
1182 |
, 'N');
|
|
|
1183 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1184 |
ENABLED ) VALUES (
|
|
|
1185 |
'SLS', 25, 2, 27, 'TxnApplicationUpdate_t', 'Generated by devices that update the TransAp object on a card. Currently only supports updating the expiry date -- will need to be expanded when update of other fields is required.'
|
|
|
1186 |
, 'N');
|
|
|
1187 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1188 |
ENABLED ) VALUES (
|
|
|
1189 |
'SLS', 25, 5, 1, 'TxnAuditRegister_t', 'This transaction is used for recording audit registers. It contains a number of audit registers as key/value pairs.'
|
|
|
1190 |
, 'N');
|
|
|
1191 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1192 |
ENABLED ) VALUES (
|
|
|
1193 |
'SLS', 25, 1, 16, 'TxnCardAccountCloseOff_t', 'Created to close off a card.', 'N');
|
|
|
1194 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1195 |
ENABLED ) VALUES (
|
|
|
1196 |
'SLS', 25, 1, 26, 'TxnCardAccountManualOperation_t', NULL, 'N');
|
|
|
1197 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1198 |
ENABLED ) VALUES (
|
|
|
1199 |
'SLS', 25, 1, 20, 'TxnCardActionlistedUsageDetected_t', 'Created when the usage of an actionlisted card has been detected at the backend. This transaction is only generated by the back office actionlist management system. The transaction is generated when a usage transaction is generated by a device for an account that has been actionlisted by the back office and should really be blocked rather than allowed to be used. This can happen when the actionlist size is too big and not all actionlist entries make it down to the devices. The Usage Detected transaction is generated (OLS) and processed (OFS) in the back office as the back office is aware of the actionlisting state of each account. After the transaction is processed by the actionlisting system at the OFS, the actionlist entry gets a higher priority so there is a better chance to block the account the next time a card is presented at a device with the updated actionlist.'
|
|
|
1200 |
, 'N');
|
|
|
1201 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1202 |
ENABLED ) VALUES (
|
|
|
1203 |
'SLS', 25, 1, 30, 'TxnCardActionlistFailure_t', 'Generated by a device when an action item in an Application actionlist cannot be processed for some reason.'
|
|
|
1204 |
, 'N');
|
|
|
1205 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1206 |
ENABLED ) VALUES (
|
|
|
1207 |
'SLS', 25, 1, 34, 'TxnCardActionlistRequest_t', 'Generate by any component in the system to request actionlisting on a card. In response to this transaction, the actionlist manager will generate the appropriate actionlisting transaction.'
|
|
|
1208 |
, 'N');
|
|
|
1209 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1210 |
ENABLED ) VALUES (
|
|
|
1211 |
'SLS', 25, 1, 18, 'TxnCardActionlist_t', 'Created to actionlist a card. This transaction is also used to notify application providers and product issuers of the applications and products contained on a particular card that their parent card is actionlisted.'
|
|
|
1212 |
, 'N');
|
|
|
1213 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1214 |
ENABLED ) VALUES (
|
|
|
1215 |
'SLS', 25, 1, 1, 'TxnCardApplication_t', 'Created when applying for a card.', 'N');
|
|
|
1216 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1217 |
ENABLED ) VALUES (
|
|
|
1218 |
'SLS', 25, 1, 6, 'TxnCardBlock_t', 'Created when a Card Device blocks a Card from usage. Blocking may be as a result of a hotlisting match, other Card validity rule processing failures (such as Card expiry) or as part of the Card initialisation/issue process.'
|
|
|
1219 |
, 'Y');
|
|
|
1220 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1221 |
ENABLED ) VALUES (
|
|
|
1222 |
'SLS', 25, 1, 29, 'TxnCardCurrencyChanged_t', 'Created by a card device when the currency of the card has changed.'
|
|
|
1223 |
, 'N');
|
|
|
1224 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1225 |
ENABLED ) VALUES (
|
|
|
1226 |
'SLS', 25, 1, 37, 'TxnCardIssuerManualAdjust_t', NULL, 'N');
|
|
|
1227 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1228 |
ENABLED ) VALUES (
|
|
|
1229 |
'SLS', 25, 1, 32, 'TxnCardDepositReceiptReverse_t', 'Indicates that the Card Deposit Receipt action has been reversed.'
|
|
|
1230 |
, 'N');
|
|
|
1231 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1232 |
ENABLED ) VALUES (
|
|
|
1233 |
'SLS', 25, 1, 9, 'TxnCardDepositReceipt_t', 'Created by a Card Device when a cardholder pays a deposit for the Card.'
|
|
|
1234 |
, 'N');
|
|
|
1235 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1236 |
ENABLED ) VALUES (
|
|
|
1237 |
'SLS', 25, 1, 33, 'TxnCardFeeReverse_t', 'Indicates that the Card Fee action has been reversed.'
|
|
|
1238 |
, 'N');
|
|
|
1239 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1240 |
ENABLED ) VALUES (
|
|
|
1241 |
'SLS', 25, 1, 22, 'TxnCardFee_t', 'Generated where the Cardholder is charged a non-refundable fee for the card'
|
|
|
1242 |
, 'N');
|
|
|
1243 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1244 |
ENABLED ) VALUES (
|
|
|
1245 |
'SLS', 25, 4, 28, 'TxnCardholderAccountManualOperation_t', 'This transaction is required for update auditing purposes.'
|
|
|
1246 |
, 'N');
|
|
|
1247 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1248 |
ENABLED ) VALUES (
|
|
|
1249 |
'SLS', 25, 4, 34, 'TxnCardholderFee_t', 'The date and time a fee was charged to the cardholder'
|
|
|
1250 |
, 'N');
|
|
|
1251 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1252 |
ENABLED ) VALUES (
|
|
|
1253 |
'SLS', 25, 4, 6, 'TxnCardholderImage_t', 'A record of a cardholder image', 'N');
|
|
|
1254 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1255 |
ENABLED ) VALUES (
|
|
|
1256 |
'SLS', 25, 1, 2, 'TxnCardInitialise_t', 'Created upon a successful Card Initialisation (or successful Card Re-initialisation)'
|
|
|
1257 |
, 'N');
|
|
|
1258 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1259 |
ENABLED ) VALUES (
|
|
|
1260 |
'SLS', 25, 1, 31, 'TxnCardIssueReverse_t', 'Indicates that the Card Issue action has been reversed.'
|
|
|
1261 |
, 'N');
|
|
|
1262 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1263 |
ENABLED ) VALUES (
|
|
|
1264 |
'SLS', 25, 1, 3, 'TxnCardIssue_t', 'Created upon a successful issue of an Anonymous or Personalised Card'
|
|
|
1265 |
, 'N');
|
|
|
1266 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1267 |
ENABLED ) VALUES (
|
|
|
1268 |
'SLS', 25, 1, 8, 'TxnCardKeysUpdate_t', 'Created by a Card Device when it has upgraded the Security Keys on a Card to a later revision'
|
|
|
1269 |
, 'N');
|
|
|
1270 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1271 |
ENABLED ) VALUES (
|
|
|
1272 |
'SLS', 25, 1, 14, 'TxnCardLogin_t', 'Created by a Card Device when an authorised staff employee (e.g. operator, inspector, supervisor, sales person) successfully uses their Card to log on to the device.'
|
|
|
1273 |
, 'N');
|
|
|
1274 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1275 |
ENABLED ) VALUES (
|
|
|
1276 |
'SLS', 25, 1, 15, 'TxnCardLogout_t', 'Created by a Card Device when an authorised staff employee (e.g. operator, inspector, supervisor, sales person) successfully uses their Card to log out from a device.'
|
|
|
1277 |
, 'N');
|
|
|
1278 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1279 |
ENABLED ) VALUES (
|
|
|
1280 |
'SLS', 25, 1, 5, 'TxnCardPersonaliseUpdate_t', 'Created when personalisation details are amended.'
|
|
|
1281 |
, 'N');
|
|
|
1282 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1283 |
ENABLED ) VALUES (
|
|
|
1284 |
'SLS', 25, 1, 4, 'TxnCardPersonalise_t', 'Created upon a successful Personalisation of a Card'
|
|
|
1285 |
, 'N');
|
|
|
1286 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1287 |
ENABLED ) VALUES (
|
|
|
1288 |
'SLS', 25, 1, 17, 'TxnCardPurge_t', 'Created to purge a Card Account.', 'N');
|
|
|
1289 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1290 |
ENABLED ) VALUES (
|
|
|
1291 |
'SLS', 25, 1, 21, 'TxnCardRangeActionlistUpdate_t', 'Created when a new card range actionlist is to be generated. Max number of entries in this list is 300.'
|
|
|
1292 |
, 'N');
|
|
|
1293 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1294 |
ENABLED ) VALUES (
|
|
|
1295 |
'SLS', 25, 1, 28, 'TxnCardRefundAccountBased_t', 'Created by a card issuers back-office function at the time a deferred full or partial refund of the deposit on a card is made to the cardholder from the card issuers back-office function as opposed to directly to the cardholder in person.'
|
|
|
1296 |
, 'N');
|
|
|
1297 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1298 |
ENABLED ) VALUES (
|
|
|
1299 |
'SLS', 25, 1, 12, 'TxnCardRefundDeferred_t', 'Created by a Card Device at the time a Cardholder surrenders a Card (in an attempt to obtain a refund) but that Card is damaged. The Card will be the subject of a deferred refund.'
|
|
|
1300 |
, 'N');
|
|
|
1301 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1302 |
ENABLED ) VALUES (
|
|
|
1303 |
'SLS', 25, 1, 27, 'TxnCardRefundRequestAccountBased_t', 'Created by a cardholder data owners back-office function at the time a request is received from a cardholder to refund - after waiting a set period of time - the deposit value and the value of all products on a card associated with the cardholder.'
|
|
|
1304 |
, 'N');
|
|
|
1305 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1306 |
ENABLED ) VALUES (
|
|
|
1307 |
'SLS', 25, 1, 10, 'TxnCardRefund_t', 'Created by a Card Device when it performs an immediate refund on a Card.'
|
|
|
1308 |
, 'N');
|
|
|
1309 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1310 |
ENABLED ) VALUES (
|
|
|
1311 |
'SLS', 25, 1, 13, 'TxnCardReplace_t', 'Created by a Card Device when it replaces an old Card with a new Card. The actual Card replacement process will be summarised using a number of UD transactions, for example, a refund transaction for the old Card, a replacement transaction simply identifying the old and new Card IDs and facility enablement transactions that establish the working state of the new Card.'
|
|
|
1312 |
, 'N');
|
|
|
1313 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1314 |
ENABLED ) VALUES (
|
|
|
1315 |
'SLS', 25, 1, 11, 'TxnCardSurrender_t', 'Indicates that a card has been physically surrendered, usually to obtain an immediate or deferred refund.'
|
|
|
1316 |
, 'N');
|
|
|
1317 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1318 |
ENABLED ) VALUES (
|
|
|
1319 |
'SLS', 25, 1, 35, 'TxnCardUnactionlistRequest_t', 'Generate by any component in the system to request un-actionlisting on a card. In response to this transaction, the actionlist manager will generate the appropriate actionlisting transaction.'
|
|
|
1320 |
, 'N');
|
|
|
1321 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1322 |
ENABLED ) VALUES (
|
|
|
1323 |
'SLS', 25, 1, 19, 'TxnCardUnactionlist_t', 'Created to unactionlist a card. This transaction is also used to notify application providers and product issuers of the applications and products contained on a particular card that their parent card is actionlisted.'
|
|
|
1324 |
, 'N');
|
|
|
1325 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1326 |
ENABLED ) VALUES (
|
|
|
1327 |
'SLS', 25, 1, 7, 'TxnCardUnblock_t', 'Created when a Card Device unblocks a previously blocked card.'
|
|
|
1328 |
, 'Y');
|
|
|
1329 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1330 |
ENABLED ) VALUES (
|
|
|
1331 |
'SLS', 25, 1, 36, 'TxnCardUseFailed_t', 'This UD allows the device to report on the type of failure experienced during a card read. The reason for the failure can be determined by the enumerated value specified in ProductUseFailed_t. The sequence of validation will occur as follows: TransAp CARD object TransAp APPLICATION object TransAp TICKET object The product found on the card, ie period pass, multiride, purse. If the device application software is unable to reach a certain level within the validation, then the associated header will be marked as invalid, by setting the UNSPECIFIED value in the appropriate ''type'' field ie. the validation reached only the card and found it invalid, then SysApplicationCom_t.applicationType=APPLICATION_TYPE_UNSPECIFIED and SysProductCom_t.productType = PRODUCT_TYPE_UNSPECIFIED.'
|
|
|
1332 |
, 'N');
|
|
|
1333 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1334 |
ENABLED ) VALUES (
|
|
|
1335 |
'SLS', 25, 4, 25, 'TxnEftReversalResult_t', 'Generated when an attempt to load value onto a product failed even after the success of the EFT payment transaction. This transaction captures the results of the EFT reversal tranaction that is initiated after the load failure.'
|
|
|
1336 |
, 'N');
|
|
|
1337 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1338 |
ENABLED ) VALUES (
|
|
|
1339 |
'SLS', 25, 6, 3, 'TxnEventData_t', 'Created for events requiring a variable length payload'
|
|
|
1340 |
, 'N');
|
|
|
1341 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1342 |
ENABLED ) VALUES (
|
|
|
1343 |
'SLS', 25, 4, 38, 'TxnExportAdjustment_t', 'A TxnExportAdjustment transaction is generated when adjustment is made to financial figures via the FinGUI manually.'
|
|
|
1344 |
, 'N');
|
|
|
1345 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1346 |
ENABLED ) VALUES (
|
|
|
1347 |
'SLS', 25, 4, 15, 'TxnOperatorCashDepositUpdate_t', 'Produced when an operator deposits cash at a device. May be generated in concert with one or more TxnOperatorShiftRead messages representing each shift read from the OpAp card contributing cash to this deposit. Produced by the OAR DAF component on behalf of the device.'
|
|
|
1348 |
, 'N');
|
|
|
1349 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1350 |
ENABLED ) VALUES (
|
|
|
1351 |
'SLS', 25, 4, 44, 'TxnOperatorShiftDeposit_t', 'Record end of shift deposits of actual cash transactions.'
|
|
|
1352 |
, 'N');
|
|
|
1353 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1354 |
ENABLED ) VALUES (
|
|
|
1355 |
'SLS', 25, 4, 36, 'TxnOtherAuditAuthorisedAdjustment_t', 'Txn for auditing purpose to record that a Manual Adjustment has been fully authorised'
|
|
|
1356 |
, 'N');
|
|
|
1357 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1358 |
ENABLED ) VALUES (
|
|
|
1359 |
'SLS', 25, 4, 37, 'TxnOtherAuditAuthorisedSettlement_t', 'Txn for auditing purpose to record that a Settlement figure has been fully authorised'
|
|
|
1360 |
, 'N');
|
|
|
1361 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1362 |
ENABLED ) VALUES (
|
|
|
1363 |
'SLS', 25, 4, 35, 'TxnOtherAuditClaim_t', 'Txn for auditing purpose to record that a Claim has been processed during Settlement. A fee may be charged on this audit'
|
|
|
1364 |
, 'N');
|
|
|
1365 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1366 |
ENABLED ) VALUES (
|
|
|
1367 |
'SLS', 25, 4, 41, 'TxnOtherBadDebtSettled_t', 'This transaction is used to record the when a cardholder pays money towards the settlement of a bad debt against them. The product details may or may not be filled in dependent upon whether a scheme wishes to record the specific product associated with the bad debt.'
|
|
|
1368 |
, 'N');
|
|
|
1369 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1370 |
ENABLED ) VALUES (
|
|
|
1371 |
'SLS', 25, 4, 32, 'TxnOtherChargeFee_t', NULL, 'N');
|
|
|
1372 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1373 |
ENABLED ) VALUES (
|
|
|
1374 |
'SLS', 25, 4, 30, 'TxnOtherFundsRequest_t', 'The TxnFundsRequest is used by the OLS to request funds from the autoload manager.'
|
|
|
1375 |
, 'N');
|
|
|
1376 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1377 |
ENABLED ) VALUES (
|
|
|
1378 |
'SLS', 25, 4, 31, 'TxnOtherFundsResponse_t', 'The autoload manager uses the TxnFundsResponse to inform the OLS on the status of the request.'
|
|
|
1379 |
, 'N');
|
|
|
1380 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1381 |
ENABLED ) VALUES (
|
|
|
1382 |
'SLS', 25, 4, 40, 'TxnOtherPaymentJourneyReverse_t', 'This transaction is produced when reversing a cash payment transaction.'
|
|
|
1383 |
, 'N');
|
|
|
1384 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1385 |
ENABLED ) VALUES (
|
|
|
1386 |
'SLS', 25, 4, 43, 'TxnOtherPaymentReverse_t', 'This transaction reverses a TxnOtherPayment_t UD record.'
|
|
|
1387 |
, 'N');
|
|
|
1388 |
INSERT INTO TSB.MASS_TXNS ( PROJECTCODE, ITERATION, UDTYPE, UDSUBTYPE, NAME, DESCRIPTION,
|
|
|
1389 |
ENABLED ) VALUES (
|
|
|
1390 |
'SLS', 25, 3, 36, 'TxnProductAccountCloseOff_t', 'Created to close off a product account.'
|
|
|
1391 |
, 'N');
|
|
|
1392 |
COMMIT;
|
|
|
1393 |
|
|
|
1394 |
|
|
|
1395 |
|
|
|
1396 |
--sequences
|
|
|
1397 |
|
|
|
1398 |
CREATE SEQUENCE TSB.TESTSCENARIOS
|
|
|
1399 |
START WITH 10000
|
|
|
1400 |
MAXVALUE 999999999999999999999999999
|
|
|
1401 |
MINVALUE 1
|
|
|
1402 |
NOCYCLE
|
|
|
1403 |
NOCACHE
|
|
|
1404 |
NOORDER;
|
|
|
1405 |
|
|
|
1406 |
|
|
|
1407 |
CREATE SEQUENCE TSB.TXNSPECS
|
|
|
1408 |
START WITH 100000
|
|
|
1409 |
MAXVALUE 999999999999999999999999999
|
|
|
1410 |
MINVALUE 0
|
|
|
1411 |
NOCYCLE
|
|
|
1412 |
NOCACHE
|
|
|
1413 |
NOORDER;
|
|
|
1414 |
|
|
|
1415 |
|
|
|
1416 |
|
|
|
1417 |
--triggers
|
|
|
1418 |
|
|
|
1419 |
|
|
|
1420 |
|
|
|
1421 |
|
|
|
1422 |
|
|
|
1423 |
CREATE OR REPLACE TRIGGER TSB.STRG_TRANSACTION_SPEC
|
|
|
1424 |
BEFORE INSERT ON TRANSACTION_SPECIFICATION FOR EACH ROW
|
|
|
1425 |
BEGIN
|
|
|
1426 |
SELECT TXNSPECS.nextval INTO :NEW.TXNSPEC_NO FROM DUAL;
|
|
|
1427 |
END;
|
|
|
1428 |
/
|
|
|
1429 |
SHOW ERRORS;
|
|
|
1430 |
|
|
|
1431 |
|
|
|
1432 |
|
|
|
1433 |
|
|
|
1434 |
CREATE OR REPLACE TRIGGER TSB.STRG_TESTSCENARIOS
|
|
|
1435 |
BEFORE INSERT ON TEST_SCENARIOS FOR EACH ROW
|
|
|
1436 |
BEGIN
|
|
|
1437 |
SELECT TESTSCENARIOS.nextval INTO :NEW.TESTSCENARIO_NO FROM DUAL;
|
|
|
1438 |
END;
|
|
|
1439 |
/
|
|
|
1440 |
SHOW ERRORS;
|
|
|
1441 |
|
|
|
1442 |
|
|
|
1443 |
|
|
|
1444 |
|
|
|
1445 |
|
|
|
1446 |
|