Difference between revisions of "202.2.2.89"

From SPGC Document Wiki
Jump to: navigation, search
 
(5 intermediate revisions by one other user not shown)
Line 1: Line 1:
==paysliplog==
+
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]]
{| 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
+
|}
+

Latest revision as of 14:32, 24 August 2016

Main Page > Application Development Team > DB Specs