Loading...
Searching...
No Matches
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
12proc sql;
13create 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
39insert 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
50insert 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 ;
62insert 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 ;
74insert 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 ;
87insert 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 ;