mpe_tables.ddl
Go to the documentation of this file.
1 /**
2  @file
3  @brief ddl file
4  @details
5 
6 
7  @version 9.2
8  @author 4GL Apps Ltd
9  @copyright 4GL Apps Ltd
10 **/
11 
12 proc sql;
13 create table &curlib..mpe_tables(
14  tx_from num not null format=datetime19.3,
15  tx_to num not null format=datetime19.3,
16  libref char(8) not null,
17  dsn char(32) not null,
18  num_of_approvals_required int,
19  loadtype char(12) ,
20  buskey char(1000) ,
21  var_txfrom char(32) ,
22  var_txto char(32) ,
23  var_busfrom char(32) ,
24  var_busto char(32) ,
25  var_processed char(32) ,
26  close_vars varchar(500),
27  pre_edit_hook char(200),
28  post_edit_hook char(200),
29  pre_approve_hook char(200) ,
30  post_approve_hook char(200) ,
31  signoff_cols varchar(500),
32  signoff_hook varchar(200),
33  notes char(1000) ,
34  rk_underlying char(1000) ,
35  audit_libds char(41),
36  constraint pk_mpe_tables
37  primary key(tx_from, libref, dsn));
38 
39 insert into &syslast
40  set tx_from=0
41  ,tx_to='31DEC5999:23:59:59'dt
42  ,libref="&mpelib"
43  ,dsn='MPE_LOCKANYTABLE'
44  ,num_of_approvals_required=1
45  ,loadtype='UPDATE'
46  ,buskey='LOCK_LIB LOCK_DS'
47  ,notes='Should not normally be edited, means a process failed and was left hung'
48  ;
49 
50 insert into &syslast
51  set tx_from=0
52  ,tx_to='31DEC5999:23:59:59'dt
53  ,libref="&mpelib"
54  ,dsn='MPE_TABLES'
55  ,num_of_approvals_required=1
56  ,loadtype='TXTEMPORAL'
57  ,buskey='LIBREF DSN'
58  ,var_txfrom='TX_FROM'
59  ,var_txto='TX_TO'
60  ,notes='This entry allows the MP Editor to edit itself!'
61  ;
62 insert into &syslast
63  set tx_from=0
64  ,tx_to='31DEC5999:23:59:59'dt
65  ,libref="&mpelib"
66  ,dsn='MPE_SECURITY'
67  ,num_of_approvals_required=1
68  ,loadtype='TXTEMPORAL'
69  ,buskey='LIBREF DSN ACCESS_LEVEL SAS_GROUP'
70  ,var_txfrom='TX_FROM'
71  ,var_txto='TX_TO'
72  ,notes='Shows which metadata groups can edit which tables'
73  ;
74 insert into &syslast
75  set tx_from=0
76  ,tx_to='31DEC5999:23:59:59'dt
77  ,libref="&mpelib"
78  ,dsn='MPE_SELECTBOX'
79  ,num_of_approvals_required=1
80  ,loadtype='TXTEMPORAL'
81  ,buskey='SELECTBOX_RK'
82  ,var_txfrom='VER_FROM_DTTM'
83  ,var_txto='VER_TO_DTTM'
84  ,notes='Can configure dropdowns for the front end'
85  ,rk_underlying='SELECT_LIB SELECT_DS BASE_COLUMN SELECTBOX_VALUE'
86  ;
87 insert into &mpelib..mpe_tables
88  set tx_from=0
89  ,tx_to='31DEC5999:23:59:59'dt
90  ,libref="&mpelib"
91  ,dsn='MPE_X_TEST'
92  ,num_of_approvals_required=1
93  ,loadtype='UPDATE'
94  ,buskey='PRIMARY_KEY_FIELD'
95  ,notes='Test table for controller'
96  ;
97  insert into &mpelib..mpe_tables
98  set tx_from=0
99  ,tx_to='31DEC5999:23:59:59'dt
100  ,libref="&mpelib"
101  ,dsn='MPE_VALIDATIONS'
102  ,num_of_approvals_required=1
103  ,loadtype='TXTEMPORAL'
104  ,buskey='BASE_LIB BASE_DS BASE_COL RULE_TYPE'
105  ,notes='Configuration of data quality rules in Editor component'
106  ,var_txfrom='TX_FROM'
107  ,var_txto='TX_TO'
108  ;
109  insert into &mpelib..mpe_tables
110  set tx_from=0
111  ,tx_to='31DEC5999:23:59:59'dt
112  ,libref="&mpelib"
113  ,dsn='MPE_DATADICTIONARY'
114  ,num_of_approvals_required=1
115  ,loadtype='TXTEMPORAL'
116  ,buskey='DD_TYPE DD_SOURCE'
117  ,notes='Configuration of data dictionary'
118  ,var_txfrom='TX_FROM'
119  ,var_txto='TX_TO'
120  ;