Loading...
Searching...
No Matches
mpe_submit.ddl
Go to the documentation of this file.
1/**
2 @file
3 @brief ddl file
4 @details Captures the submit process lifecycle
5
6 @version 9.2
7 @author 4GL Apps Ltd
8 @copyright 4GL Apps Ltd
9**/
10
11proc sql;
12create table &curlib..mpe_submit(
13 table_id varchar(32) not null,
14 submit_status_cd varchar(10) not null,
15 base_lib char(8) not null,
16 base_ds char(32) not null,
17 submitted_by_nm varchar(100) not null,
18 submitted_on_dttm num not null format=datetime19.2,
19 submitted_reason_txt varchar(400),
20 input_obs num,
21 input_vars num,
22 num_of_approvals_required num not null,
23 num_of_approvals_remaining num not null,
24 reviewed_by_nm char(100),
25 reviewed_on_dttm num,
26 constraint pk_mpe_submit
27 primary key(table_id)
28);
29