Difference between revisions of "Mypaydv"

From SPGC Document Wiki
Jump to: navigation, search
Line 266: Line 266:
 
|No
 
|No
 
|
 
|
−
|}
+
|-
 +
 
 +
|SRDCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 
 +
|ESCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 
 +
 
 +
|JBLV
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
 +
 
 +
|EMPPHDTE
 +
|date
 +
|10
 +
|No
 +
|No
 +
|No
 +
|
 +
|-
  
  
Line 626: Line 663:
  
  
−
==bonus2017==
+
==bsv_2017==
 
{| class="wikitable" \
 
{| class="wikitable" \
−
!colspan="7" | bonus2017
+
!colspan="7" | bsv_2017
 
|-
 
|-
 
! style="text-align:left;" | Column Name
 
! style="text-align:left;" | Column Name
Line 804: Line 841:
 
|
 
|
 
|}
 
|}
 +
 +
 +
 +
==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
 +
|
 +
|-

Revision as of 17:48, 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
SRDCD varchar 1 No No No
ESCD varchar 1 No No No
JBLV varchar 10 No No No
EMPPHDTE date 10 No No No
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

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


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


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