Difference between revisions of "Myleave"

From SPGC Document Wiki
Jump to: navigation, search
 
(38 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[202.2.2.52 | 202.2.2.52]]
 +
 
==auditlogs==
 
==auditlogs==
 
{| class="wikitable" \
 
{| class="wikitable" \
Line 1,074: Line 1,076:
 
|-
 
|-
 
|data
 
|data
−
|bob
+
|blob
 
|0
 
|0
 
|No
 
|No
Line 1,137: Line 1,139:
 
|varchar
 
|varchar
 
|3
 
|3
−
|No
 
−
|No
 
−
|No
 
−
|-
 
−
|LOG_OLDVAL
 
−
|longtext
 
−
|0
 
 
|No
 
|No
 
|No
 
|No
Line 1,191: Line 1,186:
 
|-
 
|-
 
|myuseraccess
 
|myuseraccess
 +
|varchar
 +
|4
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==ob2013==
 +
{| class="wikitable" \
 +
!colspan="7" | 0b2013
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | ob2014
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | ob2015
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | ob2016
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | olvdaytype
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | olvdept
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | olvdepthie
 +
|-
 +
! style="text-align:left;" | 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
 
|varchar
 
|40
 
|40
 
|No
 
|No
 +
|Yes
 
|No
 
|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
 
|No
 
|}
 
|}
 +
 +
==olvemp==
 +
{| class="wikitable" \
 +
!colspan="7" | olvemp
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | olvleavetype
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | olvmodaccs
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | olvsect
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | ot2013
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | ot2014
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | ot2015
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | ot2016
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | paysliplog
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pd2014
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pd2015
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pdm_essi2013
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pdm_essi2014
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pd2016
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pdm_essi2015
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pdm_essi2016
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pdm_sppe2013
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pdm_sppe2014
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pdm_sppe2015
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pdm_sppe2016
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pdv2013
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pdv2014
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pdv2015
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pdv2016
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | secthd
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | syslogs
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | tblclrlog
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | un2013
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | un2014
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | un2015
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | un2016
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | unibio_bk
 +
|-
 +
! style="text-align:left;" | 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 | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[202.2.2.52 | 202.2.2.52]]

Latest revision as of 09:17, 1 September 2016

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

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