Myleave

auditlogs

auditlogs
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	No
LOG_USER	varchar	25	No	No	No
LOG_MODULE	varchar	50	No	No	No
LOG_DATE	datetime	0	No	No	No
LOG_TBL	varchar	50	No	No	No
LOG_KEYREC	varchar	50	No	No	No
LOG_FIELD	varchar	25	No	No	No
LOG_OLDVAL	longtext	0	No	No	No
LOG_NEWVAL	longtext	0	No	No	No
LOG_CHANGE	varchar	25	No	No	No
LOG_SQLEXEC	longtext	0	No	No	No
LOG_IPADDR	varchar	25	No	No	No
LOG_PRNT	varchar	25	No	No	No

ccback

ccback
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
mymodule	varchar	20	No	No	No
myremark	varchar	1	No	No	No
myuser	varchar	10	No	No	No
myppdte	datetime	0	No	No	No
mydate	datetime	0	No	No	No
mycomp	varchar	10	No	No	No

dept_sect_emp_tag

dept_sect_emp_tag
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	No
SECT_CODE	varchar	25	No	No	No
DEPT_CODE	varchar	25	No	No	No
EMPNUMB	varchar	25	No	No	No
TAGGED_FA	varchar	1	No	No	No
TAGGED_IA	varchar	1	No	No	No
TAGGED_RL	varchar	1	No	No	No
TAGGED_ACTV	varchar	1	No	No	No

depthd

depthd
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	No
DEPT_CODE	varchar	25	No	No	No
DEPT_NAME	varchar	150	No	No	No
DEPT_DIVHEAD	varchar	150	No	No	No

lv2013

lv2013
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment