Difference between revisions of "Mypaydv"

From SPGC Document Wiki
Jump to: navigation, search
Line 264: Line 264:
 
|No
 
|No
 
|
 
|
−
|-
+
|-}
  
  
Line 439: Line 439:
 
|varchar
 
|varchar
 
|10
 
|10
 +
|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
 
|No

Revision as of 17:35, 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_sppe2017

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

bonus2017

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