Myleave

From SPGC Document Wiki

Revision as of 13:19, 4 August 2016 by Ojt2 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

Contents

1 auditlogs
2 ccback
3 dept_sect_emp_tag
4 depthd
5 lv2013
6 lv2014
7 lv2015
8 lv2016
9 myci_sessions
10 myusers
11 ob2013
12 ob2014

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

myusers

myusers
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
myusername	varchar	10	No	No	No
myuserfname	varchar	20	No	No	No
myuserlname	varchar	20	No	No	No
myusermname	varchar	20	No	No	No
myuserfulln	varchar	50	No	No	No
myuserpass	varchar	50	No	No	No
myuserlevel	varchar	3	No	No	No
LOG_OLDVAL	longtext	0	No	No	No
myuservalis	datetime	0	No	No	No
myuservalie	datetime	0	No	No	No
myusercostc	varchar	10	No	No	No
myusergroup	varchar	15	No	No	No
myuseracomp	varchar	40	No	No	No
myusertype	varchar	7	No	No	No
myuseraccess	varchar	40	No	No	No

ob2013

0b2013
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
OBTNUMB	varchar	8	No	Yes	No
OBTDATE	datetime	0	No	Yes	No
OBTEDTME	varchar	4	No	No	No
OBTEATME	varchar	4	No	No	No
OBTDTME	varchar	4	No	Yes	No
OBTATME	varchar	4	No	Yes	No
OBTIAPP	varchar	1	no	Yes	No
OBTIAPPDTVW	datetime	0	No	Yes	No
OBTIAPPDT	datetime	0	No	Yes	No
OBTIAPPDISR	longtext	0	No	No	No
OBTFAPP	varchar	1	No	Yes	No
OBTFAPPDTVW	datetime	0	No	Yes	No
OBTFAPPDT	datetime	0	No	Yes	No
OBTFAPPDISR	longtext	0	No	No	No
OBTPURP	longtext	0	No	Yes	No
OBTDTFLD	datetime	0	No	Yes	No
OBTRNUMB	varchar	20	No	No	No
OBTFNUMB	varchar	20	No	No	No
OBTCOCD	varchar	1	No	Yes	No
OBTSECCD	varchar	20	No	Yes	No
OBTDEPT	varchar	20	No	Yes	No
OBTSAVED	varchar	1	No	Yes	No
OBTSAVED2	varchar	1	No	No	No
LOATRANS	varchar	1	No	Yes	No

ob2014

ob2014
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
OBTNUMB	varchar	8	No	Yes	No
OBTDATE	datetime	0	No	Yes	No
OBTEDTME	varchar	4	No	No	No
OBTEATME	varchar	4	No	No	No
OBTDTME	varchar	4	No	Yes	No
OBTATME	varchar	4	No	Yes	No
OBTIAPP	varchar	1	no	Yes	No
OBTIAPPDTVW	datetime	0	No	Yes	No
OBTIAPPDT	datetime	0	No	Yes	No
OBTIAPPDISR	longtext	0	No	No	No
OBTFAPP	varchar	1	No	Yes	No
OBTFAPPDTVW	datetime	0	No	Yes	No
OBTFAPPDT	datetime	0	No	Yes	No
OBTFAPPDISR	longtext	0	No	No	No
OBTPURP	longtext	0	No	Yes	No
OBTDTFLD	datetime	0	No	Yes	No
OBTRNUMB	varchar	20	No	No	No
OBTFNUMB	varchar	20	No	No	No
OBTCOCD	varchar	1	No	Yes	No
OBTSECCD	varchar	20	No	Yes	No
OBTDEPT	varchar	20	No	Yes	No
OBTSAVED	varchar	1	No	Yes	No
OBTSAVED2	varchar	1	No	No	No
LOATRANS	varchar	1	No	Yes	No

Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Myleave&oldid=2416"