Difference between revisions of "Mypaydv"

From SPGC Document Wiki
Jump to: navigation, search
Line 86: Line 86:
 
|}
 
|}
  
 +
 +
 +
==attk_essi2017==
 +
{| class="wikitable" \
 +
!colspan="7" | ahs2016
 +
|-
 +
! 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
 +
|
 +
|-
  
  

Revision as of 17:25, 10 July 2017

Main Page > Application Development Team > DB Specs > 202.2.2.52

ahs2017

ahs2016
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

ahs2016
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
ahs2016
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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mypaydv&oldid=5374"