Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
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 issuer’s 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 issuer’s 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 issuer’s 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 issuer’s 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 issuer’s 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 issuer’s 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 owner’s 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 
CREATE OR REPLACE TRIGGER TSB.NOTFORDISPLAY
1420 
AFTER UPDATE
1421 
OF FIELDVALUE
1422 
ON TSB.TXNSPEC_VALUES
1423 
REFERENCING NEW AS NEW OLD AS OLD
1424 
DECLARE
1425 
tmpVar NUMBER;
1426 
 
1427 
BEGIN
1428 
 
1429 
   update txnspec_values
1430 
   set displayable = 'N'
1431 
   where fieldname in ('formatVersion','txnMac', 'keyVersion', 'applicationProviderId', 'applicationSerialNumber', 'udType', 'udSubtype',
1432 
   'currencyIndicatorFinDetails','processedDate','cardIssuerId','productIssuerId','routeLineId','numberOfPassengers','applicationPassengerType','passEndDateTime')
1433 
   and  displayable = 'Y';
1434 
 
1435 
END NOTFORDISPLAY;
1436 
/
1437 
SHOW ERRORS;
1438 
 
1439 
 
1440 
 
1441 
CREATE OR REPLACE TRIGGER TSB.STRG_TRANSACTION_SPEC
1442 
  BEFORE INSERT ON TRANSACTION_SPECIFICATION FOR EACH ROW
1443 
BEGIN
1444 
  SELECT TXNSPECS.nextval INTO :NEW.TXNSPEC_NO FROM DUAL;
1445 
END;
1446 
/
1447 
SHOW ERRORS;
1448 
 
1449 
 
1450 
 
1451 
 
1452 
CREATE OR REPLACE TRIGGER TSB.STRG_TESTSCENARIOS
1453 
  BEFORE INSERT ON TEST_SCENARIOS FOR EACH ROW
1454 
BEGIN
1455 
  SELECT TESTSCENARIOS.nextval INTO :NEW.TESTSCENARIO_NO FROM DUAL;
1456 
END;
1457 
/
1458 
SHOW ERRORS;
1459 
 
1460 
 
1461 
 
1462 
 
1463 
 
1464