Difference between revisions of "Mypaydv"

From SPGC Document Wiki
Jump to: navigation, search
Line 298: Line 298:
 
|EMPPHDTE
 
|EMPPHDTE
 
|date
 
|date
−
|10
+
|none
 
|No
 
|No
 
|No
 
|No
Line 304: Line 304:
 
|
 
|
 
|-
 
|-
 +
 +
|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
 +
|
 +
|}
  
  
Line 478: Line 578:
 
|varchar
 
|varchar
 
|10
 
|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
 
|No
Line 659: Line 897:
 
|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
 +
|
 +
|}
  
  
Line 840: Line 1,122:
 
|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==
Line 870: Line 1,291:
 
|double
 
|double
 
|15,2
 
|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
 
|No

Revision as of 18:11, 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
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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mypaydv&oldid=5382"