Myleave

From SPGC Document Wiki

Revision as of 14:17, 4 August 2016 by Ojt2 (Talk | contribs) (→‎ob2015)

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

Jump to: navigation, search

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	blob	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
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	4	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	Yes	No
OBTTRANS	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	Yes	No
OBTTRANS	varchar	1	No	Yes	No

ob2015

ob2015
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	Yes	No
OBTTRANS	varchar	1	No	Yes	No

ob2016

ob2016
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
OBTTRANS	varchar	1	No	Yes	No

olvdaytype

olvdaytype
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	10	Yes	Yes	Yes
dtcode	varchar	5	No	No	No
dtdesc	varchar	15	No	No	No
dtnoday	varchar	8	No	No	No
dtalias	varchar	5	No	No	No

olvdept

olvdept
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	11	Yes	Yes	No
deptcd	varchar	20	No	No	No
deptnme	varchar	20	No	No	No
depthead	varchar	20	No	No	No

olvdepthie

olvdepthie
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	10	Yes	Yes	Yes
depenumb	varchar	20	No	Yes	No
deptsechead	varchar	25	No	Yes	No
deptsubs	varchar	25	No	Yes	No
deptsnme	varchar	40	No	Yes	No
deptheadno	varchar	25	No	Yes	No
depthead	varchar	25	No	Yes	No
deptcd	varchar	20	No	Yes	No
deptname	varchar	40	No	Yes	No

olvemp

olvemp
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	10	Yes	Yes	Yes
empuser	varchar	25	No	Yes	No
empnumb	varchar	20	No	Yes	No
emplnam	varchar	30	No	Yes	No
empmnam	varchar	30	No	Yes	No
empfnam	varchar	30	No	Yes	No
empposti	varchar	15	No	No	No
empgender	varchar	1	No	No	No
empstat	varchar	1	No	Yes	No
empcocd	varchar	1	No	No	No
emppccd	varchar	1	No	No	No
empcontact	varchar	15	No	Yes	No
empdepcd	varchar	20	No	Yes	No
empdepsec	varchar	20	No	Yes	No
empposid	int	1	No	Yes	No
empusrtyp	varchar	3	No	Yes	No
empemail	varchar	40	No	No	No
emp_isdepthd	varchar	1	No	No	No
emp_issecthd	varchar	1	No	No	No
emp_isfa	varchar	1	No	No	No
emp_isia	varchar	1	No	No	No
emp_isrl	varchar	1	No	No	No

olvleavetype

olvleavetype
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	11	Yes	Yes	No
lvtypecd	varchar	3	No	No	No
lvtypedesc	varchar	20	No	No	No
lvtypealias	varchar	5	No	No	No

olvmodaccs

olvmodaccs
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	20	Yes	Yes	Yes
MSA_USER	varchar	10	No	No	No
MSA_SYS	varchar	2	No	No	No
MSA_MODULE	varchar	4	No	No	No
MSA_SMODULE	varchar	5	No	No	No
MSA_ENCDTE	datetime	0	No	No	No
MSA_MRK	varchar	1	No	No	No

olvsect

olvsect
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	11	Yes	Yes	No
seccd	varchar	20	No	No	No
secnme	varchar	20	No	No	No
sechead	varchar	20	No	No	No
secdept	varchar	20	No	No	No

ot2013

ot2013
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
OBTTRANS	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
OBTTRANS	varchar	1	No	Yes	No

ot2015

ot2015
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
OBTTRANS	varchar	1	No	Yes	No

ot2016

ot2016
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
OBTTRANS	varchar	1	No	Yes	No

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