forked from icstars/c35
-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathUntitled4
More file actions
44 lines (42 loc) · 2.55 KB
/
Untitled4
File metadata and controls
44 lines (42 loc) · 2.55 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
UPDATE ttx_empl_trng_reqst set Trng_Reqst_Nbr =null;
UPDATE ttx_empl_trng_reqst set Cntct_Email_Addr varchar =null;
UPDATE ttx_empl_trng_reqst set Cntct_Email_Immed_Supv_Addr varchar =null;
UPDATE ttx_empl_trng_reqst set Cntct_Email_Dept_Hd_Addr varchar =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_Id char =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_Nm varchar =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_Nbr char =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_Strt_Dt timestamp =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_End_Dt timestamp =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_Totl_Nbr_Hrs decimal(5, 2) NOT NULL =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_Cost decimal(7, 2) =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_Rltd_Exp_Amt decimal(7, 2) =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_Locn =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_Typ char =null;
UPDATE ttx_empl_trng_reqst set Trng_Reqst_Cors_Bnft_Txt =null;
UPDATE ttx_empl_trng_reqst set Trng_Reqst_Immed_Supv_Apvl_Flg =null;
UPDATE ttx_empl_trng_reqst set Trng_Reqst_Dept_Hd_Apvl_Flg =null;
UPDATE ttx_empl_trng_reqst set Trng_Reqst_VP_Apvl_Flg =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_Compl_Flg =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_Budg_Pln_Flg =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_Not_Budg_Pln_Rsn_Txt =null;
UPDATE ttx_empl_trng_reqst set Trng_Cors_Not_Compl_Rsn_Txt =null;
UPDATE ttx_empl_trng_reqst set Trng_Reqst_Fwd_Actg_Paym_Flg =null;
UPDATE ttx_empl_trng_reqst set Trng_Reqst_Paym_Recip_Email_Addr varchar =null;
UPDATE ttx_empl_trng_reqst set Trng_Reqst_Rejt_Rsn_Txt =null;
UPDATE ttx_empl_trng_reqst set Trng_Reqst_Paym_Reqst_Dt =null;
UPDATE ttx_empl_trng_reqst set Trng_Reqst_Paym_Due_Dt =null;
UPDATE ttx_empl_trng_reqst set Trng_Reqst_Paym_Chk_Amt =null;
UPDATE ttx_empl_trng_reqst set Trng_Reqst_Paym_Mail_Flg =null;
UPDATE ttx_empl_trng_reqst set Vndr_Nbr =null;
UPDATE ttx_empl_trng_reqst set Vndr_Nm =null;
UPDATE ttx_empl_trng_reqst set Vndr_Mail_Addr =null;
UPDATE ttx_empl_trng_reqst set Vndr_Mail_Addr_Ln_2 =null;
UPDATE ttx_empl_trng_reqst set Vndr_Mail_City =null;
UPDATE ttx_empl_trng_reqst set Vndr_Mail_St =null;
UPDATE ttx_empl_trng_reqst set Vndr_Mail_Zip_Cd =null;
UPDATE ttx_empl_trng_reqst set Vndr_Mail_Cntry =null;
UPDATE ttx_empl_trng_reqst set Trng_Reqst_Cost_Ctr =null;
UPDATE ttx_empl_trng_reqst set Trng_Reqst_GL_Acct_Nbr =null;
UPDATE ttx_empl_trng_reqst set Crtd_Dt timestamp =null;
UPDATE ttx_empl_trng_reqst set Lst_Updt_Dt =null;
UPDATE ttx_empl_trng_reqst set Lst_Updt_I =null;