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
RECID	int	11	Yes	Yes	No
LOANUMB	varchar	15	No	No	No
LOADATE	datetime	0	No	No	No
LOAOPTN	varchar	1	No	No	No
LOACODE	varchar	1	No	No	No
LOAHOUR	double	15,5	No	No	No
LOAHRPD	double	15,5	No	No	No
LOAASTA	varchar	1	no	Yes	No
LOAASTADT	datetime	0	No	No	No
LOAASTADTVW	datetime	0	No	No	No
LOAASTADISR	longtext	0	No	No	No
LOAAREC	varchar	1	No	Yes	No
LOADISREAS	longtext	0	No	No	No
LOAARECDT	datetime	0	No	No	No
LOAARECDTVW	datetime	0	No	No	No
LOADTFLD	datetime	0	No	No	No
LOAREASON	longtext	0	No	No	No
LOARELIEV	varchar	15	No	No	No
LOARNUMB	varchar	15	No	No	No
LOAFNUMB	varchar	15	No	No	No
LOACOCD	varchar	1	No	No	No
LOAEMAIL	varchar	20	No	Yes	No
LOASECCD	varchar	20	No	No	No
LOADEPCD	varchar	20	No	No	No
LOASAVED	varchar	1	No	Yes	No
LOATRANS	varchar	1	No	Yes	No

lv2014

lv2014
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
LOANUMB	varchar	15	No	No	No
LOADATE	datetime	0	No	No	No
LOAOPTN	varchar	1	No	No	No
LOACODE	varchar	1	No	No	No
LOAHOUR	double	15,5	No	No	No
LOAHRPD	double	15,5	No	No	No
LOAASTA	varchar	1	no	Yes	No
LOAASTADT	datetime	0	No	No	No
LOAASTADTVW	datetime	0	No	No	No
LOAASTADISR	longtext	0	No	No	No
LOAAREC	varchar	1	No	Yes	No
LOADISREAS	longtext	0	No	No	No
LOAARECDT	datetime	0	No	No	No
LOAARECDTVW	datetime	0	No	No	No
LOADTFLD	datetime	0	No	No	No
LOAREASON	longtext	0	No	No	No
LOARELIEV	varchar	15	No	No	No
LOARNUMB	varchar	15	No	No	No
LOAFNUMB	varchar	15	No	No	No
LOACOCD	varchar	1	No	No	No
LOAEMAIL	varchar	20	No	Yes	No
LOASECCD	varchar	20	No	No	No
LOADEPCD	varchar	20	No	No	No
LOASAVED	varchar	1	No	Yes	No
LOATRANS	varchar	1	No	Yes	No

lv2015

lv2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
LOANUMB	varchar	15	No	No	No
LOADATE	datetime	0	No	No	No
LOAOPTN	varchar	1	No	No	No
LOACODE	varchar	1	No	No	No
LOAHOUR	double	15,5	No	No	No
LOAHRPD	double	15,5	No	No	No
LOAASTA	varchar	1	no	Yes	No
LOAASTADT	datetime	0	No	No	No
LOAASTADTVW	datetime	0	No	No	No
LOAASTADISR	longtext	0	No	No	No
LOAAREC	varchar	1	No	Yes	No
LOADISREAS	longtext	0	No	No	No
LOAARECDT	datetime	0	No	No	No
LOAARECDTVW	datetime	0	No	No	No
LOADTFLD	datetime	0	No	No	No
LOAREASON	longtext	0	No	No	No
LOARELIEV	varchar	15	No	No	No
LOARNUMB	varchar	15	No	No	No
LOAFNUMB	varchar	15	No	No	No
LOACOCD	varchar	1	No	No	No
LOAEMAIL	varchar	20	No	Yes	No
LOASECCD	varchar	20	No	No	No
LOADEPCD	varchar	20	No	No	No
LOASAVED	varchar	1	No	Yes	No
LOATRANS	varchar	1	No	Yes	No

lv2016

lv2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
LOANUMB	varchar	15	No	No	No
LOADATE	datetime	0	No	No	No
LOAOPTN	varchar	1	No	No	No
LOACODE	varchar	1	No	No	No
LOAHOUR	double	15,5	No	No	No
LOAHRPD	double	15,5	No	No	No
LOAASTA	varchar	1	no	Yes	No
LOAASTADT	datetime	0	No	No	No
LOAASTADTVW	datetime	0	No	No	No
LOAASTADISR	longtext	0	No	No	No
LOAAREC	varchar	1	No	Yes	No
LOADISREAS	longtext	0	No	No	No
LOAARECDT	datetime	0	No	No	No
LOAARECDTVW	datetime	0	No	No	No
LOADTFLD	datetime	0	No	No	No
LOAREASON	longtext	0	No	No	No
LOARELIEV	varchar	15	No	No	No
LOARNUMB	varchar	15	No	No	No
LOAFNUMB	varchar	15	No	No	No
LOACOCD	varchar	1	No	No	No
LOAEMAIL	varchar	20	No	Yes	No
LOASECCD	varchar	20	No	No	No
LOADEPCD	varchar	20	No	No	No
LOASAVED	varchar	1	No	Yes	No
LOATRANS	varchar	1	No	Yes	No

myci_sessions

myci_sessions
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	varchar	40	Yes	Yes	No
ip_address	varchar	45	No	Yes	No
timestamp	int	10	No	Yes	Yes
data	bob	0	No	Yes	No