Myleave

Main Page > Application Development Team > DB Specs > 202.2.2.52

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	Yes	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
OTMNUMB	varchar	15	No	Yes	No
OTMDATE	datetime	0	No	Yes	No
OTMEFTME	varchar	4	No	Yes	No
OTMETTME	varchar	4	No	Yes	No
OTMFTME	varchar	4	No	Yes	No
OTMTTME	varchar	4	No	Yes	No
OTMIAPP	varchar	1	no	Yes	No
OTMIAPPDTVW	datetime	0	No	Yes	No
OTMIAPPDT	datetime	0	No	Yes	No
OTMIAPPDISR	longtext	0	No	No	No
OTMFAPP	varchar	1	No	Yes	No
OTMFAPPDTVW	datetime	0	No	Yes	No
OTMFAPPDT	datetime	0	No	Yes	No
OTMFAPPDISR	longtext	0	No	No	No
OBTPURP	longtext	0	No	Yes	No
OTMDTFLD	datetime	0	No	Yes	No
OTMRNUMB	varchar	20	No	No	No
OTMFNUMB	varchar	20	No	No	No
OTMCOCD	varchar	1	No	Yes	No
OTMSECCD	varchar	20	No	Yes	No
OTMDEPT	varchar	20	No	Yes	No
OTMSAVED	varchar	1	No	Yes	No
OTMSAVED2	varchar	1	No	Yes	No
OTMTRANS	varchar	1	No	Yes	No

ot2014

ot2014
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
OTMNUMB	varchar	15	No	Yes	No
OTMDATE	datetime	0	No	Yes	No
OTMEFTME	varchar	4	No	Yes	No
OTMETTME	varchar	4	No	Yes	No
OTMFTME	varchar	4	No	Yes	No
OTMTTME	varchar	4	No	Yes	No
OTMIAPP	varchar	1	no	Yes	No
OTMIAPPDTVW	datetime	0	No	Yes	No
OTMIAPPDT	datetime	0	No	Yes	No
OTMIAPPDISR	longtext	0	No	No	No
OTMFAPP	varchar	1	No	Yes	No
OTMFAPPDTVW	datetime	0	No	Yes	No
OTMFAPPDT	datetime	0	No	Yes	No
OTMFAPPDISR	longtext	0	No	No	No
OBTPURP	longtext	0	No	Yes	No
OTMDTFLD	datetime	0	No	Yes	No
OTMRNUMB	varchar	20	No	No	No
OTMFNUMB	varchar	20	No	No	No
OTMCOCD	varchar	1	No	Yes	No
OTMSECCD	varchar	20	No	Yes	No
OTMDEPT	varchar	20	No	Yes	No
OTMSAVED	varchar	1	No	Yes	No
OTMSAVED2	varchar	1	No	Yes	No
OTMTRANS	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
OTMNUMB	varchar	15	No	Yes	No
OTMDATE	datetime	0	No	Yes	No
OTMEFTME	varchar	4	No	Yes	No
OTMETTME	varchar	4	No	Yes	No
OTMFTME	varchar	4	No	Yes	No
OTMTTME	varchar	4	No	Yes	No
OTMIAPP	varchar	1	no	Yes	No
OTMIAPPDTVW	datetime	0	No	Yes	No
OTMIAPPDT	datetime	0	No	Yes	No
OTMIAPPDISR	longtext	0	No	No	No
OTMFAPP	varchar	1	No	Yes	No
OTMFAPPDTVW	datetime	0	No	Yes	No
OTMFAPPDT	datetime	0	No	Yes	No
OTMFAPPDISR	longtext	0	No	No	No
OBTPURP	longtext	0	No	Yes	No
OTMDTFLD	datetime	0	No	Yes	No
OTMRNUMB	varchar	20	No	No	No
OTMFNUMB	varchar	20	No	No	No
OTMCOCD	varchar	1	No	Yes	No
OTMSECCD	varchar	20	No	Yes	No
OTMDEPT	varchar	20	No	Yes	No
OTMSAVED	varchar	1	No	Yes	No
OTMSAVED2	varchar	1	No	Yes	No
OTMTRANS	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
OTMNUMB	varchar	15	No	Yes	No
OTMDATE	datetime	0	No	Yes	No
OTMEFTME	varchar	4	No	Yes	No
OTMETTME	varchar	4	No	Yes	No
OTMFTME	varchar	4	No	Yes	No
OTMTTME	varchar	4	No	Yes	No
OTMIAPP	varchar	1	no	Yes	No
OTMIAPPDTVW	datetime	0	No	Yes	No
OTMIAPPDT	datetime	0	No	Yes	No
OTMIAPPDISR	longtext	0	No	No	No
OTMFAPP	varchar	1	No	Yes	No
OTMFAPPDTVW	datetime	0	No	Yes	No
OTMFAPPDT	datetime	0	No	Yes	No
OTMFAPPDISR	longtext	0	No	No	No
OBTPURP	longtext	0	No	Yes	No
OTMDTFLD	datetime	0	No	Yes	No
OTMRNUMB	varchar	20	No	No	No
OTMFNUMB	varchar	20	No	No	No
OTMCOCD	varchar	1	No	Yes	No
OTMSECCD	varchar	20	No	Yes	No
OTMDEPT	varchar	20	No	Yes	No
OTMSAVED	varchar	1	No	Yes	No
OTMSAVED2	varchar	1	No	Yes	No
OTMTRANS	varchar	1	No	Yes	No

paysliplog

paysliplog
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
Id	int	11	Yes	Yes	No
EmployeeNo	varchar	20	No	Yes	No
PayDate	date	0	No	Yes	No
DateOpen	datetime	0	No	Yes	No
IpAddress	varchar	50	No	Yes	No

pd2014

pd2014
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	11	Yes	Yes	No
PDMCOCD	varchar	25	No	No	No
PDMLCCD	varchar	25	No	No	No
PDMCOFF	varchar	3	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	datetime	0	No	No	No
PDMSTDT	datetime	0	No	No	No

pd2015

pd2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	11	Yes	Yes	No
PDMCOCD	varchar	25	No	No	No
PDMLCCD	varchar	25	No	No	No
PDMCOFF	varchar	3	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	datetime	0	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_essi2013

pdm_essi2013
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMTDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	double	15,2	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_essi2014

pdm_essi2014
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMTDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	double	15,2	No	No	No
PDMSTDT	datetime	0	No	No	No

pd2016

pd2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	11	Yes	Yes	Yes
PDMCOCD	varchar	25	No	No	No
PDMLCCD	varchar	25	No	No	No
PDMCOFF	varchar	3	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMTDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	datetime	0	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_essi2015

pdm_essi2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	3	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMTDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	datetime	0	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_essi2016

pdm_essi2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMTDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	double	15,2	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_sppe2013

pdm_sppe2013
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMTDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	double	15,2	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_sppe2014

pdm_sppe2014
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMTDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	double	15,2	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_sppe2015

pdm_sppe2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMTDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	double	15,2	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_sppe2016

pdm_sppe2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMTDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	double	15,2	No	No	No
PDMSTDT	datetime	0	No	No	No

pdv2013

pdv2013
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDVCOFF	varchar	30	No	No	No
PDVFDTE	datetime	0	No	No	No
PDVTDTE	datetime	0	No	No	No
PDVPOST	varchar	7	No	No	No
PDVAFDT	datetime	0	No	No	No
PDVATDT	datetime	0	No	No	No
PDVDAYS	double	15,2	No	No	No
PDVADFD	datetime	0	No	No	No
PDVADTD	datetime	0	No	No	No
PDVSFDT	double	15,2	No	No	No
PDVSTDT	datetime	0	No	No	No

pdv2014

pdv2014
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDVCOFF	varchar	30	No	No	No
PDVFDTE	datetime	0	No	No	No
PDVTDTE	datetime	0	No	No	No
PDVPOST	varchar	7	No	No	No
PDVAFDT	datetime	0	No	No	No
PDVATDT	datetime	0	No	No	No
PDVDAYS	double	15,2	No	No	No
PDVADFD	datetime	0	No	No	No
PDVADTD	datetime	0	No	No	No
PDVSFDT	double	15,2	No	No	No
PDVSTDT	datetime	0	No	No	No

pdv2015

pdv2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDVCOFF	varchar	30	No	No	No
PDVFDTE	datetime	0	No	No	No
PDVTDTE	datetime	0	No	No	No
PDVPOST	varchar	7	No	No	No
PDVAFDT	datetime	0	No	No	No
PDVATDT	datetime	0	No	No	No
PDVDAYS	double	15,2	No	No	No
PDVADFD	datetime	0	No	No	No
PDVADTD	datetime	0	No	No	No
PDVSFDT	double	15,2	No	No	No
PDVSTDT	datetime	0	No	No	No

pdv2016

pdv2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDVCOFF	varchar	30	No	No	No
PDVFDTE	datetime	0	No	No	No
PDVTDTE	datetime	0	No	No	No
PDVPOST	varchar	7	No	No	No
PDVAFDT	datetime	0	No	No	No
PDVATDT	datetime	0	No	No	No
PDVDAYS	double	15,2	No	No	No
PDVADFD	datetime	0	No	No	No
PDVADTD	datetime	0	No	No	No
PDVSFDT	double	15,2	No	No	No
PDVSTDT	datetime	0	No	No	No

secthd

secthd
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
SECT_CODE	varchar	25	No	No	No
SECT_NAME	varchar	150	No	No	No

syslogs

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

tblclrlog

tblclrlog
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	20	Yes	Yes	No
LOG_ENUMB	varchar	25	No	No	No
LOG_RCP	varchar	150	No	No	No
LOG_RCPID	datetime	20	No	No	No
LOG_SENDER	varchar	150	No	No	No
LOG_RCPDVIEW	datetime	0	No	No	No
LOG_RCPCLEARED	varchar	1	No	No	No
LOG_RCPCLEARED_DATE	datetime	0	No	No	No
LOG_RCPREMK	longtext	0	No	No	No
LOG_USER	varchar	50	No	No	No
LOG_IDENC	varchar	50	No	No	No
LOG_SEND_DATE	datetime	0	No	No	No
LOG_DATE_APP	date	0	No	No	No
LOG_MODULE	varchar	25	No	No	No

un2013

un2013
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
UNTNUMB	varchar	15	No	Yes	No
UNTDATE	datetime	0	No	Yes	No
UNTSTME	varchar	4	No	Yes	No
UNTETME	varchar	4	No	Yes	No
UNTPURP	longtext	0	No	Yes	No
UNTIAPP	varchar	1	No	Yes	No
UNTIAPPDT	datetime	0	No	Yes	No
UNTIAPPDTVW	datetime	0	No	No	No
UNTIAPPDISP	longtext	0	No	Yes	No
UNTFAPP	varchar	1	No	Yes	No
UNTFAPPDT	datetime	0	No	Yes	No
UNTFAPPDTVW	datetime	0	No	Yes	No
UNTFAPPDISP	longtext	0	No	Yes	No
UNTDTFLD	datetime	0	No	Yes	No
UNTRNUMB	varchar	20	No	No	No
UNTFNUMB	varchar	20	No	No	No
UNTCOCD	varchar	1	No	Yes	No
UNTSECCD	varchar	20	No	Yes	No
UNTDEPT	varchar	20	No	Yes	No
UNTSAVED	varchar	1	No	Yes	No
UNTTRANS	varchar	1	No	Yes	No

un2014

un2014
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
UNTNUMB	varchar	15	No	Yes	No
UNTDATE	datetime	0	No	Yes	No
UNTSTME	varchar	4	No	Yes	No
UNTETME	varchar	4	No	Yes	No
UNTPURP	longtext	0	No	Yes	No
UNTIAPP	varchar	1	No	Yes	No
UNTIAPPDT	datetime	0	No	Yes	No
UNTIAPPDTVW	datetime	0	No	No	No
UNTIAPPDISP	longtext	0	No	Yes	No
UNTFAPP	varchar	1	No	Yes	No
UNTFAPPDT	datetime	0	No	Yes	No
UNTFAPPDTVW	datetime	0	No	Yes	No
UNTFAPPDISP	longtext	0	No	Yes	No
UNTDTFLD	datetime	0	No	Yes	No
UNTRNUMB	varchar	20	No	No	No
UNTFNUMB	varchar	20	No	No	No
UNTCOCD	varchar	1	No	Yes	No
UNTSECCD	varchar	20	No	Yes	No
UNTDEPT	varchar	20	No	Yes	No
UNTSAVED	varchar	1	No	Yes	No
UNTTRANS	varchar	1	No	Yes	No

un2015

un2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
UNTNUMB	varchar	15	No	Yes	No
UNTDATE	datetime	0	No	Yes	No
UNTSTME	varchar	4	No	Yes	No
UNTETME	varchar	4	No	Yes	No
UNTPURP	longtext	0	No	Yes	No
UNTIAPP	varchar	1	No	Yes	No
UNTIAPPDT	datetime	0	No	Yes	No
UNTIAPPDTVW	datetime	0	No	No	No
UNTIAPPDISP	longtext	0	No	Yes	No
UNTFAPP	varchar	1	No	Yes	No
UNTFAPPDT	datetime	0	No	Yes	No
UNTFAPPDTVW	datetime	0	No	Yes	No
UNTFAPPDISP	longtext	0	No	Yes	No
UNTDTFLD	datetime	0	No	Yes	No
UNTRNUMB	varchar	20	No	No	No
UNTFNUMB	varchar	20	No	No	No
UNTCOCD	varchar	1	No	Yes	No
UNTSECCD	varchar	20	No	Yes	No
UNTDEPT	varchar	20	No	Yes	No
UNTSAVED	varchar	1	No	Yes	No
UNTTRANS	varchar	1	No	Yes	No

un2016

un2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
UNTNUMB	varchar	15	No	Yes	No
UNTDATE	datetime	0	No	Yes	No
UNTSTME	varchar	4	No	Yes	No
UNTETME	varchar	4	No	Yes	No
UNTPURP	longtext	0	No	Yes	No
UNTIAPP	varchar	1	No	Yes	No
UNTIAPPDT	datetime	0	No	Yes	No
UNTIAPPDTVW	datetime	0	No	No	No
UNTIAPPDISP	longtext	0	No	Yes	No
UNTFAPP	varchar	1	No	Yes	No
UNTFAPPDT	datetime	0	No	Yes	No
UNTFAPPDTVW	datetime	0	No	Yes	No
UNTFAPPDISP	longtext	0	No	Yes	No
UNTDTFLD	datetime	0	No	Yes	No
UNTRNUMB	varchar	20	No	No	No
UNTFNUMB	varchar	20	No	No	No
UNTCOCD	varchar	1	No	Yes	No
UNTSECCD	varchar	20	No	Yes	No
UNTDEPT	varchar	20	No	Yes	No
UNTSAVED	varchar	1	No	Yes	No
UNTTRANS	varchar	1	No	Yes	No

unibio_bk

unibio_bk
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
FPENUMB	varchar	10	Yes	Yes	No
FPID	varchar	10	No	No	No
FPDATE	datetime	0	No	No	No
FPIO	varchar	5	No	No	No
OLDBARID	varchar	20	No	No	No

Main Page > Application Development Team > DB Specs > 202.2.2.52