Difference between revisions of "Mypaydv"

From SPGC Document Wiki
Jump to: navigation, search
(Created page with "==ahs2016== {| class="wikitable" \ !colspan="7" | ahs2016 |- ! style="text-align:left;" | Column Name ! Data Type ! Length ! Is PrimaryKey ! Is Not Null ! Auto Increment ! Des...")
 
 
(21 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
==ahs2016==
+
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[202.2.2.52 | 202.2.2.52]]
 +
 
 +
 
 +
 
 +
==ahs2017==
 
{| class="wikitable" \
 
{| class="wikitable" \
−
!colspan="7" | ahs2016
+
!colspan="7" | ahs2017
 
|-
 
|-
 
! style="text-align:left;" | Column Name
 
! style="text-align:left;" | Column Name
Line 27: Line 31:
 
|Gross Pay
 
|Gross Pay
 
|-
 
|-
 +
|AHSALLO
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|Allowance
 +
|-
 +
|AHS13MO
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|13th Month Pay
 +
|-
 +
|AHSSLVL
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|SL/VL Pay
 +
|-
 +
|AHSSVLR
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|SL/VL Remaining
 +
|-
 +
|AHSBONS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|Bonus
 +
|-
 +
|AHSTAXD
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|Tax Due
 +
|-
 +
|AHSTAXW
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|Tax WithHeld
 +
|}
 +
 +
 +
 +
==attk_essi2017==
 +
{| class="wikitable" \
 +
!colspan="7" | attk_essi2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|EMPNUMB
 +
|Varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AAM
 +
|Date Time
 +
|15
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|APM
 +
|Date Time
 +
|None
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|OAM
 +
|Date Time
 +
|None
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|OPM
 +
|Date Time
 +
|None
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|OFLAG
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|LVHR
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|LVCODE
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|LVOPTN
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|CWSTAG
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|UNTAG
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|LATES_AM
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|LATES_AP
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|THOURS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|ACT_HOURS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|NDED
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|OHOURS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|DAYCODE
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|SRDCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|ESCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|JBLV
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPPHDTE
 +
|date
 +
|none
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|A_AM
 +
|datetime
 +
|none
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|A_PM
 +
|datetime
 +
|none
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|C_HRS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|TMARK
 +
|varchar
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|REFDATE
 +
|date
 +
|none
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|DATEPOST
 +
|datetime
 +
|none
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|COFF
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|SHFCD
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|TTHOURS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|THRS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|TFHRS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|}
 +
 +
 +
==attk_sppe2017==
 +
{| class="wikitable" \
 +
!colspan="7" | attk_sppe2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|EMPNUMB
 +
|Varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AAM
 +
|Date Time
 +
|15
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|APM
 +
|Date Time
 +
|None
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|OAM
 +
|Date Time
 +
|None
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|OPM
 +
|Date Time
 +
|None
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|OFLAG
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|LVHR
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|LVCODE
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|LVOPTN
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|CWSTAG
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|UNTAG
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|LATES_AM
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|LATES_AP
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|THOURS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|ACT_HOURS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|NDED
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|OHOURS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|DAYCODE
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|SRDCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|ESCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|JBLV
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPPHDTE
 +
|date
 +
|none
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|A_AM
 +
|datetime
 +
|none
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|A_PM
 +
|datetime
 +
|none
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|C_HRS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|TMARK
 +
|varchar
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|REFDATE
 +
|date
 +
|none
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|DATEPOST
 +
|datetime
 +
|none
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|COFF
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|SHFCD
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|TTHOURS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|THRS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|TFHRS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|}
 +
 +
 +
==bonus2017==
 +
{| class="wikitable" \
 +
!colspan="7" | bonus2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|AHSNUMB
 +
|Varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|AHSGPAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHS13MO
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSBONS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSSLRE
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSVLRE
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSSLPY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSVLPY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSLTAG
 +
|tinyint
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSCTAG
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSLPAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSPYNO
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSSTAT
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSPMCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSESCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSPCCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSBKCD
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSCOCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSLCCD
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSFDVL
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSFDSL
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSBPAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|AHSDPCD
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|}
 +
 +
 +
==bsv_2017==
 +
{| class="wikitable" \
 +
!colspan="7" | bsv_2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|HSTNUMB
 +
|Varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPNAME
 +
|Varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPLNAM
 +
|Varchar
 +
|50
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPFNAM
 +
|Varchar
 +
|50
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPMNAM
 +
|Varchar
 +
|50
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|EMPCOCD
 +
|Varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
 +
|HDTE
 +
|date
 +
|none
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|ESCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|TBASIC
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|TBASIC_A
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|MMO
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|13MO
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|BONUS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|BONUS2
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|LPAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|LPAY2
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|GPAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|GPAY2
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|SL_PAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|COMPNAME
 +
|varchar
 +
|60
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|DEPT
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|PCCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|LOCA
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPSTAT
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPPMCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPBKCD
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|EMPDBNK
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|EMPATMP
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
 +
|DEPTNAME
 +
|varchar
 +
|60
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|SVVSLEN
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|SLREM
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
 +
|SVVVLEN
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|VLREN
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|}
 +
 +
==bsv2017==
 +
{| class="wikitable" \
 +
!colspan="7" | bsv2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|EMPNUMB
 +
|Varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|EMP13MO
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPSLPY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|EMPVLPY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPLPAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|EMPBONS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPGPAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPBPAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPLNAM
 +
|varchar
 +
|30
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPFNAM
 +
|varchar
 +
|30
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPMNAM
 +
|varchar
 +
|30
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPCOCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPPCCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPLCCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|EMPDPCD
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPFDSL
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPFDVL
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|EMPSLRE
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPVLRE
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPESCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPPMCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPSTAT
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPPYNO
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPCTAG
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|EMPBKCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|}
 +
 +
 +
 +
==bsve_2017==
 +
{| class="wikitable" \
 +
!colspan="7" | bsve_2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|HSTNUMB
 +
|Varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|EMPNAME
 +
|Varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPLNAM
 +
|Varchar
 +
|50
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPFNAM
 +
|Varchar
 +
|50
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPMNAM
 +
|Varchar
 +
|50
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPCOCD
 +
|Varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|HDTE
 +
|date
 +
|none
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|ESCD
 +
|Varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|TBASIC
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|TBASIC_A
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|MMO
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|13MO
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|BONUS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|BONUS2
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|LPAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|LPAY2
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|GPAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|GPAY2
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|SL_PAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|COMPNAME
 +
|varchar
 +
|60
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|DEPT
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|PCCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|LOCA
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPSTAT
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPPMCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPBKCD
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPDBNK
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|EMPATMP
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
 +
|DEPTNAME
 +
|varchar
 +
|60
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
 +
 +
|SVVSLEN
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|SLREM
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|SVVVLEN
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|VLREM
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|
 +
|}
 +
 +
 +
==cv2017==
 +
{| class="wikitable" \
 +
!colspan="7" | cv2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|CWVNUMB
 +
|Varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|CWVDATE
 +
|date
 +
|none
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|CWVFSTM
 +
|varchar
 +
|4
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
|CWVESTM
 +
|varchar
 +
|4
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|CWVSTME
 +
|varchar
 +
|4
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|CWVETME
 +
|varchar
 +
|4
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|CWVATAG
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 +
 +
|CWVSFCD
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|
 +
|}
 +
 +
 +
 +
 +
==cws_2017==
 +
{| class="wikitable" \
 +
!colspan="7" | cws_2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|ID
 +
|int
 +
|11
 +
|yes
 +
|yes
 +
|yes
 +
|
 +
|-
 +
 +
 +
 +
|EMPNUMB
 +
|varchar
 +
|20
 +
|No
 +
|yes
 +
|No
 +
|
 +
|-
 +
 +
 +
|ATTDATE
 +
|date
 +
|none
 +
|No
 +
|yes
 +
|No
 +
|
 +
|-
 +
 +
 +
 +
|AMIN
 +
|datetime
 +
|none
 +
|No
 +
|yes
 +
|No
 +
|
 +
|-
 +
 +
|PMOUT
 +
|datetime
 +
|none
 +
|No
 +
|yes
 +
|No
 +
|
 +
|-
 +
 +
 +
|FLAG
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|}
 +
 +
 +
==dtr2017==
 +
{| class="wikitable" \
 +
!colspan="7" | dtr2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|DTRCODE
 +
|varchar
 +
|3
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DTRDATE
 +
|varchar
 +
|6
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DTRTIME
 +
|varchar
 +
|4
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DTRTMP1
 +
|varchar
 +
|2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
 +
|DTRSHFT
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DTRCRNO
 +
|varchar
 +
|12
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DTRREMK
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|}
 +
 +
 +
==dtrallow2017==
 +
{| class="wikitable" \
 +
!colspan="7" | dtrallow2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|DTRAENUMB
 +
|varchar
 +
|15
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DTRACDTE
 +
|date
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DTRADATE
 +
|date
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DTRACODE
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DTRAOR
 +
|varchar
 +
|100
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DTRAUSER
 +
|varchar
 +
|10
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DTRAENCD
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DTRAFLAG
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DTRAABY
 +
|varchar
 +
|10
 +
|no
 +
|no
 +
|no
 +
|
 +
|}
 +
 +
 +
 +
==dtt2017==
 +
{| class="wikitable" \
 +
!colspan="7" | dtt2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|recid
 +
|int
 +
|30
 +
|yes
 +
|yes
 +
|yes
 +
|
 +
|-
 +
 +
|DT_ENUMB
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_WS_CODE
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_DYCODE
 +
|varchar
 +
|3
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_DYTYPE
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_LCCD
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
 +
|DT_DPCD
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_COCD
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_FPID
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_PCCD
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_TDPD
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_DTETRIX
 +
|date
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_SAMIN
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_SPMOUT
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
 +
|DT_GPERD
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_NSSTART
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_NSEND
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_AAMIN
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_APMOUT
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_ACBOUT
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_ACBIN
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_CBOUT
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_CBIN
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_CBLATES
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_AMIN
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_PMOUT
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_AM_IN
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_PM_OUT
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_VAMIN
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_VPMOUT
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_AMLATES
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_PMLATES
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_UNDERT
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_UTFILE
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_ATHRS
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_ABS
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_REQTHRS
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_NS_HRS
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_AM_NS_HRS
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_ROTAM
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_ROTPM
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_USER
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
 +
|DT_DATEP
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_REMK
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_NDFLAG
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_FLAG
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_COMPLETE
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_MHC_GRP
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_OTAM_PD
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_OTPM_PD
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_AMLATES_DED
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_UNDERT_DED
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_OTREG_RD
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_REG_HRS_PD
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_NS_HRS_PD
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_THRSWS
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_AMLATES_MIN
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_UNDERT_MIN
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_EMP_RDORG
 +
|varchar
 +
|3
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_EMP_RDORD
 +
|varchar
 +
|3
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_EMP_OTSUN
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_EMP_OTHOL
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_EMP_OTREG
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
 +
|DT_PYTYPE
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_TXTYPE
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_ERATEC
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_NODYYR
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_NOHRDY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_THRSWS_PD
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_CDTE
 +
|date
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_LV_CODE
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_LVP_DYS
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_LVP_HRS
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_CS
 +
|varchar
 +
|25
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_REGD_X8
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_REGD_PHOL
 +
|date
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_REGD_PHOL_HRS_PD
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_CSHIFT
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_OT_IN
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_OT_OUT
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_OT_S
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_OT_E
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_WS_GPERD
 +
|double
 +
|10,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_AUTO_AMHDAY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_AUTO_AMWDAY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_MINS_MIN_OT
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DT_MFLAG_DAY
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_AUTO_PMHDAY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_AUTO_PMWDAY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DT_CB
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|}
 +
 +
 +
==dv2017==
 +
{| class="wikitable" \
 +
!colspan="7" | dv2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|DTVNUMB
 +
|varchar
 +
|15
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DTVUSER
 +
|varchar
 +
|10
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DTVDATE
 +
|date
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DTVAMIN
 +
|varchar
 +
|4
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DTV_AMI
 +
|varchar
 +
|4
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DTVPMOT
 +
|varchar
 +
|4
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|DTV_PMO
 +
|varchar
 +
|4
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|DTVSFCD
 +
|varchar
 +
|3
 +
|no
 +
|no
 +
|no
 +
|
 +
|}
 +
 +
 +
==hst2017==
 +
{| class="wikitable" \
 +
!colspan="7" | hst2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|HSTNUMB
 +
|varchar
 +
|15
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTCDTE
 +
|datetime
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTMPAY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTMALL
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
 +
|HSTBPAY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTBALL
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTGPAY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTSSSR
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTSSSE
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTTAXC
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTECCM
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTPIBE
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTMEDE
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTMEDR
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTTDED
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTADON
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTNSPY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|HSTOTNS
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTOTPY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTSLPY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTVLPY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTDOPY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTLHPY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
 +
|HSTSHPY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
 +
|HSTCOFF
 +
|varchar
 +
|3
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTCOCD
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTPCCD
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTHOLD
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|HSTPYNO
 +
|varchar
 +
|9
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTDPCD
 +
|varchar
 +
|10
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTLCCD
 +
|varchar
 +
|3
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTPSNO
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
 +
|HSTBKCD
 +
|varchar
 +
|5
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|HSTESCD
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|HSTFLPY
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTTDPD
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|}
 +
 +
==hstmwe2017==
 +
{| class="wikitable" \
 +
!colspan="7" | hstmwe2017
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
! Description
 +
|-
 +
 +
|HSTNUMB
 +
|varchar
 +
|15
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|HSTCDTE
 +
|date
 +
|
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|HSTPCCD
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|HSTCOCD
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTESCD
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|HSTTAXC
 +
|double
 +
|15,2
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
|HSTMD
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|-
 +
 +
 +
|HSTMWE
 +
|varchar
 +
|1
 +
|no
 +
|no
 +
|no
 +
|
 +
|}

Latest revision as of 18:08, 12 July 2017

Main Page > Application Development Team > DB Specs > 202.2.2.52


ahs2017

ahs2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
AHSNUMB Varchar 15 No No No Employee No.
AHSGPAY double 15,2 No No No Gross Pay
AHSALLO double 15,2 No No No Allowance
AHS13MO double 15,2 No No No 13th Month Pay
AHSSLVL double 15,2 No No No SL/VL Pay
AHSSVLR double 15,2 No No No SL/VL Remaining
AHSBONS double 15,2 No No No Bonus
AHSTAXD double 15,2 No No No Tax Due
AHSTAXW double 15,2 No No No Tax WithHeld


attk_essi2017

attk_essi2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
EMPNUMB Varchar 15 No No No
AAM Date Time 15 No No No
APM Date Time None No No No
OAM Date Time None No No No
OPM Date Time None No No No
OFLAG varchar 10 No No No
LVHR double 15,2 No No No
LVCODE varchar 10 No No No
LVOPTN varchar 1 No No No
CWSTAG varchar 10 No No No
UNTAG varchar 10 No No No
LATES_AM double 15,2 No No No
LATES_AP double 15,2 No No No
THOURS double 15,2 No No No
ACT_HOURS double 15,2 No No No
NDED double 15,2 No No No
OHOURS double 15,2 No No No
DAYCODE varchar 10 No No No
SRDCD varchar 1 No No No
ESCD varchar 1 No No No
JBLV varchar 10 No No No
EMPPHDTE date none No No No
A_AM datetime none No No No
A_PM datetime none No No No
C_HRS double 15,2 No No No
TMARK varchar 15,2 No No No
REFDATE date none No No No
DATEPOST datetime none No No No
COFF varchar 3 No No No
SHFCD varchar 3 No No No
TTHOURS double 15,2 No No No
THRS double 15,2 No No No
TFHRS double 15,2 No No No


attk_sppe2017

attk_sppe2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
EMPNUMB Varchar 15 No No No
AAM Date Time 15 No No No
APM Date Time None No No No
OAM Date Time None No No No
OPM Date Time None No No No
OFLAG varchar 10 No No No
LVHR double 15,2 No No No
LVCODE varchar 10 No No No
LVOPTN varchar 1 No No No
CWSTAG varchar 10 No No No
UNTAG varchar 10 No No No
LATES_AM double 15,2 No No No
LATES_AP double 15,2 No No No
THOURS double 15,2 No No No
ACT_HOURS double 15,2 No No No
NDED double 15,2 No No No
OHOURS double 15,2 No No No
DAYCODE varchar 10 No No No
SRDCD varchar 1 No No No
ESCD varchar 1 No No No
JBLV varchar 10 No No No
EMPPHDTE date none No No No
A_AM datetime none No No No
A_PM datetime none No No No
C_HRS double 15,2 No No No
TMARK varchar 15,2 No No No
REFDATE date none No No No
DATEPOST datetime none No No No
COFF varchar 3 No No No
SHFCD varchar 3 No No No
TTHOURS double 15,2 No No No
THRS double 15,2 No No No
TFHRS double 15,2 No No No


bonus2017

bonus2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
AHSNUMB Varchar 15 No No No
AHSGPAY double 15,2 No No No
AHS13MO double 15,2 No No No
AHSBONS double 15,2 No No No
AHSSLRE double 15,2 No No No
AHSVLRE double 15,2 No No No
AHSSLPY double 15,2 No No No
AHSVLPY double 15,2 No No No
AHSLTAG tinyint 1 No No No
AHSCTAG varchar 1 No No No
AHSLPAY double 15,2 No No No
AHSPYNO varchar 10 No No No
AHSSTAT varchar 1 No No No
AHSPMCD varchar 1 No No No
AHSESCD varchar 1 No No No
AHSPCCD varchar 1 No No No
AHSBKCD varchar 5 No No No
AHSCOCD varchar 1 No No No
AHSLCCD varchar 3 No No No
AHSFDVL double 15,2 No No No
AHSFDSL double 15,2 No No No
AHSBPAY double 15,2 No No No
AHSDPCD double 15,2 No No No


bsv_2017

bsv_2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
HSTNUMB Varchar 15 No No No
EMPNAME Varchar 150 No No No
EMPLNAM Varchar 50 No No No
EMPFNAM Varchar 50 No No No
EMPMNAM Varchar 50 No No No
EMPCOCD Varchar 1 No No No
HDTE date none No No No
ESCD varchar 1 No No No
TBASIC double 15,2 No No No
TBASIC_A double 15,2 No No No
MMO double 15,2 No No No
13MO double 15,2 No No No
BONUS double 15,2 No No No
BONUS2 double 15,2 No No No
LPAY double 15,2 No No No
LPAY2 double 15,2 No No No
GPAY double 15,2 No No No
GPAY2 double 15,2 No No No
SL_PAY double 15,2 No No No
COMPNAME varchar 60 No No No
DEPT varchar 10 No No No
PCCD varchar 1 No No No
LOCA varchar 3 No No No
EMPSTAT varchar 1 No No No
EMPPMCD varchar 1 No No No
EMPBKCD varchar 3 No No No
EMPDBNK varchar 5 No No No
EMPATMP varchar 25 No No No
DEPTNAME varchar 60 No No No
SVVSLEN double 15,2 No No No
SLREM double 15,2 No No No
SVVVLEN double 15,2 No No No
VLREN double 15,2 No No No

bsv2017

bsv2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
EMPNUMB Varchar 15 No No No
EMP13MO double 15,2 No No No
EMPSLPY double 15,2 No No No
EMPVLPY double 15,2 No No No
EMPLPAY double 15,2 No No No
EMPBONS double 15,2 No No No
EMPGPAY double 15,2 No No No
EMPBPAY double 15,2 No No No
EMPLNAM varchar 30 No No No
EMPFNAM varchar 30 No No No
EMPMNAM varchar 30 No No No
EMPCOCD varchar 1 No No No
EMPPCCD varchar 1 No No No
EMPLCCD varchar 1 No No No
EMPDPCD varchar 10 No No No
EMPFDSL double 15,2 No No No
EMPFDVL double 15,2 No No No
EMPSLRE double 15,2 No No No
EMPVLRE double 15,2 No No No
EMPESCD varchar 1 No No No
EMPPMCD varchar 1 No No No
EMPSTAT varchar 1 No No No
EMPPYNO varchar 10 No No No
EMPCTAG varchar 1 No No No
EMPBKCD varchar 1 No No No


bsve_2017

bsve_2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
HSTNUMB Varchar 15 No No No
EMPNAME Varchar 150 No No No
EMPLNAM Varchar 50 No No No
EMPFNAM Varchar 50 No No No
EMPMNAM Varchar 50 No No No
EMPCOCD Varchar 1 No No No
HDTE date none No No No
ESCD Varchar 1 No No No
TBASIC double 15,2 No No No
TBASIC_A double 15,2 No No No
MMO double 15,2 No No No
13MO double 15,2 No No No
BONUS double 15,2 No No No
BONUS2 double 15,2 No No No
LPAY double 15,2 No No No
LPAY2 double 15,2 No No No
GPAY double 15,2 No No No
GPAY2 double 15,2 No No No
SL_PAY double 15,2 No No No
COMPNAME varchar 60 No No No
DEPT varchar 10 No No No
PCCD varchar 1 No No No
LOCA varchar 3 No No No
EMPSTAT varchar 1 No No No
EMPPMCD varchar 1 No No No
EMPBKCD varchar 3 No No No
EMPDBNK varchar 5 No No No
EMPATMP varchar 25 No No No
DEPTNAME varchar 60 No No No
SVVSLEN double 15,2 No No No
SLREM double 15,2 No No No
SVVVLEN double 15,2 No No No
VLREM double 15,2 No No No


cv2017

cv2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
CWVNUMB Varchar 15 No No No
CWVDATE date none No No No
CWVFSTM varchar 4 No No No
CWVESTM varchar 4 No No No
CWVSTME varchar 4 No No No
CWVETME varchar 4 No No No
CWVATAG varchar 1 No No No
CWVSFCD varchar 3 No No No



cws_2017

cws_2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
ID int 11 yes yes yes
EMPNUMB varchar 20 No yes No
ATTDATE date none No yes No
AMIN datetime none No yes No
PMOUT datetime none No yes No
FLAG varchar 1 No No No


dtr2017

dtr2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
DTRCODE varchar 3 no no no
DTRDATE varchar 6 no no no
DTRTIME varchar 4 no no no
DTRTMP1 varchar 2 no no no
DTRSHFT varchar 1 no no no
DTRCRNO varchar 12 no no no
DTRREMK varchar 1 no no no


dtrallow2017

dtrallow2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
DTRAENUMB varchar 15 no no no
DTRACDTE date no no no
DTRADATE date no no no
DTRACODE varchar 25 no no no
DTRAOR varchar 100 no no no
DTRAUSER varchar 10 no no no
DTRAENCD datetime no no no
DTRAFLAG varchar 1 no no no
DTRAABY varchar 10 no no no


dtt2017

dtt2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
recid int 30 yes yes yes
DT_ENUMB varchar 25 no no no
DT_WS_CODE varchar 25 no no no
DT_DYCODE varchar 3 no no no
DT_DYTYPE varchar 25 no no no
DT_LCCD varchar 25 no no no
DT_DPCD varchar 25 no no no
DT_COCD varchar 25 no no no
DT_FPID varchar 25 no no no
DT_PCCD varchar 25 no no no
DT_TDPD varchar 25 no no no
DT_DTETRIX date no no no
DT_SAMIN datetime no no no
DT_SPMOUT datetime no no no
DT_GPERD double 15,2 no no no
DT_NSSTART datetime no no no
DT_NSEND datetime no no no
DT_AAMIN datetime no no no
DT_APMOUT datetime no no no
DT_ACBOUT datetime no no no
DT_ACBIN datetime no no no
DT_CBOUT datetime no no no
DT_CBIN datetime no no no
DT_CBLATES double 15,2 no no no
DT_AMIN datetime no no no
DT_PMOUT datetime no no no
DT_AM_IN datetime no no no
DT_PM_OUT datetime no no no
DT_VAMIN datetime no no no
DT_VPMOUT datetime no no no
DT_AMLATES double 15,2 no no no
DT_PMLATES double 15,2 no no no
DT_UNDERT double 15,2 no no no
DT_UTFILE double 15,2 no no no
DT_ATHRS double 15,2 no no no
DT_ABS double 15,2 no no no
DT_REQTHRS double 15,2 no no no
DT_NS_HRS double 15,2 no no no
DT_AM_NS_HRS double 15,2 no no no
DT_ROTAM double 15,2 no no no
DT_ROTPM double 15,2 no no no
DT_USER varchar 25 no no no
DT_DATEP datetime no no no
DT_REMK varchar 25 no no no
DT_NDFLAG varchar 1 no no no
DT_FLAG varchar 1 no no no
DT_COMPLETE varchar 1 no no no
DT_MHC_GRP varchar 1 no no no
DT_OTAM_PD double 15,2 no no no
DT_OTPM_PD double 15,2 no no no
DT_AMLATES_DED double 15,2 no no no
DT_UNDERT_DED double 15,2 no no no
DT_OTREG_RD double 15,2 no no no
DT_REG_HRS_PD double 15,2 no no no
DT_NS_HRS_PD double 15,2 no no no
DT_THRSWS double 15,2 no no no
DT_AMLATES_MIN double 15,2 no no no
DT_UNDERT_MIN double 15,2 no no no
DT_EMP_RDORG varchar 3 no no no
DT_EMP_RDORD varchar 3 no no no
DT_EMP_OTSUN varchar 1 no no no
DT_EMP_OTHOL varchar 1 no no no
DT_EMP_OTREG varchar 1 no no no
DT_PYTYPE varchar 1 no no no
DT_TXTYPE varchar 1 no no no
DT_ERATEC varchar 25 no no no
DT_NODYYR double 15,2 no no no
DT_NOHRDY double 15,2 no no no
DT_THRSWS_PD double 15,2 no no no
DT_CDTE date no no no
DT_LV_CODE varchar 25 no no no
DT_LVP_DYS double 15,2 no no no
DT_LVP_HRS double 15,2 no no no
DT_CS varchar 25 no no no
DT_REGD_X8 double 15,2 no no no
DT_REGD_PHOL date no no no
DT_REGD_PHOL_HRS_PD double 15,2 no no no
DT_CSHIFT varchar 1 no no no
DT_OT_IN datetime no no no
DT_OT_OUT datetime no no no
DT_OT_S datetime no no no
DT_OT_E datetime no no no
DT_WS_GPERD double 10,2 no no no
DT_AUTO_AMHDAY double 15,2 no no no
DT_AUTO_AMWDAY double 15,2 no no no
DT_MINS_MIN_OT double 15,2 no no no
DT_MFLAG_DAY varchar 1 no no no
DT_AUTO_PMHDAY double 15,2 no no no
DT_AUTO_PMWDAY double 15,2 no no no
DT_CB double 15,2 no no no


dv2017

dv2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
DTVNUMB varchar 15 no no no
DTVUSER varchar 10 no no no
DTVDATE date no no no
DTVAMIN varchar 4 no no no
DTV_AMI varchar 4 no no no
DTVPMOT varchar 4 no no no
DTV_PMO varchar 4 no no no
DTVSFCD varchar 3 no no no


hst2017

hst2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
HSTNUMB varchar 15 no no no
HSTCDTE datetime no no no
HSTMPAY double 15,2 no no no
HSTMALL double 15,2 no no no
HSTBPAY double 15,2 no no no
HSTBALL double 15,2 no no no
HSTGPAY double 15,2 no no no
HSTSSSR double 15,2 no no no
HSTSSSE double 15,2 no no no
HSTTAXC double 15,2 no no no
HSTECCM double 15,2 no no no
HSTPIBE double 15,2 no no no
HSTMEDE double 15,2 no no no
HSTMEDR double 15,2 no no no
HSTTDED double 15,2 no no no
HSTADON double 15,2 no no no
HSTNSPY double 15,2 no no no
HSTOTNS double 15,2 no no no
HSTOTPY double 15,2 no no no
HSTSLPY double 15,2 no no no
HSTVLPY double 15,2 no no no
HSTDOPY double 15,2 no no no
HSTLHPY double 15,2 no no no
HSTSHPY double 15,2 no no no
HSTCOFF varchar 3 no no no
HSTCOCD varchar 1 no no no
HSTPCCD varchar 1 no no no
HSTHOLD varchar 1 no no no
HSTPYNO varchar 9 no no no
HSTDPCD varchar 10 no no no
HSTLCCD varchar 3 no no no
HSTPSNO varchar 1 no no no
HSTBKCD varchar 5 no no no
HSTESCD varchar 1 no no no
HSTFLPY double 15,2 no no no
HSTTDPD varchar 1 no no no

hstmwe2017

hstmwe2017
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
HSTNUMB varchar 15 no no no
HSTCDTE date no no no
HSTPCCD varchar 1 no no no
HSTCOCD varchar 1 no no no
HSTESCD varchar 1 no no no
HSTTAXC double 15,2 no no no
HSTMD varchar 1 no no no
HSTMWE varchar 1 no no no
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mypaydv&oldid=5393"